{
  "fields": [{"id":"_id","type":"int"},{"id":"Company_Name","type":"text"},{"id":"Dutch_Category","type":"text"},{"id":"Tech_Giants_Logos","type":"text"},{"id":"Logo_Link","type":"text"},{"id":"First_Name","type":"text"},{"id":"Last_Name","type":"text"},{"id":"Title","type":"text"},{"id":"Address_Line_1","type":"text"},{"id":"City","type":"text"},{"id":"Postal_Code","type":"text"},{"id":"Phone","type":"text"},{"id":"URL","type":"text"},{"id":"Business_Description","type":"text"},{"id":"Entity_Type","type":"text"},{"id":"Is_Headquarters","type":"text"},{"id":"NAICS_2017_Code","type":"numeric"},{"id":"NAICS_2017_Description","type":"text"},{"id":"ObjectId","type":"numeric"},{"id":"lon","type":"numeric"},{"id":"lat","type":"numeric"}],
  "records": [
    [1,"Amazon","Logistics","Yes","https://detrp.maps.arcgis.com/sharing/rest/content/items/ce9b0f5bb9c54e08a57a72bc3817ae7b/data","Adam","Gray","Student, Graduate Business Admin","39000 Amrhein Rd","Livonia","48150-1043","1-734-591-1268","http://www.amazon.com","Amazon.Com, Inc. is primarily engaged in the warehousing and storage of a general line of goods.","Branch","FALSE",493110,"General Warehousing and Storage",1,-9286828.7569,5217234.274700001],
    [2,"Amazon","Logistics","Yes","https://detrp.maps.arcgis.com/sharing/rest/content/items/ce9b0f5bb9c54e08a57a72bc3817ae7b/data","Norman","Luzier","Area Manager","19991 Brownstown Center Dr","Brownstown Township","48183-1693","1-734-676-0070","http://www.amazon.com","Amazon.Com, Inc. is primarily engaged in the warehousing and storage of a general line of goods.","Branch","FALSE",493110,"General Warehousing and Storage",2,-9266041.9393,5184922.070100002],
    [3,"Amazon","Logistics","Yes","https://detrp.maps.arcgis.com/sharing/rest/content/items/ce9b0f5bb9c54e08a57a72bc3817ae7b/data","Amani","Archer","Area Manager","32801 Ecorse Rd","Romulus","48174-1628","1-206-266-8000","http://www.amazon.com","Amazon.Com, Inc. is primarily engaged in the warehousing and storage of a general line of goods.","Branch","FALSE",493110,"General Warehousing and Storage",3,-9279760.5269,5198874.2136999965],
    [4,"Amazon","Logistics","Yes","https://detrp.maps.arcgis.com/sharing/rest/content/items/ce9b0f5bb9c54e08a57a72bc3817ae7b/data","","","","999 Chicago Rd","Troy","48083-4227","","http://www.amazon.com","Amazon.Com, Inc. is primarily engaged in the warehousing and storage of a general line of goods.","Branch","FALSE",493110,"General Warehousing and Storage",4,-9252256.5791,5242812.009400003],
    [5,"Amazon","Logistics","Yes","https://detrp.maps.arcgis.com/sharing/rest/content/items/ce9b0f5bb9c54e08a57a72bc3817ae7b/data","","","","11457 Hannan Rd","Romulus","48174","","http://www.amazon.com","Amazon.Com, Inc. is primarily engaged in the warehousing and storage of a general line of goods.","Branch","FALSE",493110,"General Warehousing and Storage",5,-9286751.7497,5193820.317000002],
    [6,"Amazon","Logistics","Yes","https://detrp.maps.arcgis.com/sharing/rest/content/items/ce9b0f5bb9c54e08a57a72bc3817ae7b/data","","","","28415 Automation Blvd","Wixom","48393-3152","","http://www.amazon.com","Amazon.Com, Inc. is primarily engaged in the warehousing and storage of a general line of goods.","Branch","FALSE",493110,"General Warehousing and Storage",6,-9302751.2565,5235906.097599998],
    [7,"Amazon","Logistics","Yes","https://detrp.maps.arcgis.com/sharing/rest/content/items/ce9b0f5bb9c54e08a57a72bc3817ae7b/data","","","","12795 Premier Center Ct","Plymouth","48170-3212","","http://www.amazon.com","Amazon.Com, Inc. is primarily engaged in the warehousing and storage of a general line of goods.","Branch","FALSE",493110,"General Warehousing and Storage",7,-9287873.0822,5217052.156400003],
    [8,"Amazon","Logistics","Yes","https://detrp.maps.arcgis.com/sharing/rest/content/items/ce9b0f5bb9c54e08a57a72bc3817ae7b/data","","","","50500 Mound Rd","Shelby Township","48317-1318","1-410-300-7241","http://www.amazon.com","Amazon.Com, Inc. is primarily engaged in the warehousing and storage of a general line of goods.","Branch","FALSE",493110,"General Warehousing and Storage",8,-9245044.7473,5261463.304200001],
    [9,"Amazon","Logistics","Yes","https://detrp.maps.arcgis.com/sharing/rest/content/items/ce9b0f5bb9c54e08a57a72bc3817ae7b/data","","","","19991 Brownstown Center Dr Bldg 9","Trenton","48183-1693","","http://www.amazon.com","Amazon.Com, Inc. is primarily engaged in the warehousing and storage of a general line of goods.","Branch","FALSE",493110,"General Warehousing and Storage",9,-9266041.9393,5184922.070100002],
    [10,"Amazon","Logistics","Yes","https://detrp.maps.arcgis.com/sharing/rest/content/items/ce9b0f5bb9c54e08a57a72bc3817ae7b/data","","","","1400 E 10 Mile Rd","Hazel Park","48030-1263","1-248-545-6726","http://www.amazon.com","Amazon.Com, Inc. is primarily engaged in the warehousing and storage of a general line of goods.","Branch","FALSE",493110,"General Warehousing and Storage",10,-9249635.8135,5232584.3455],
    [11,"Cisco","Digital Tech","Yes","https://detrp.maps.arcgis.com/sharing/rest/content/items/c3937b36087e491e8c21843e1b829660/data","Monte","Huber","General Manager","200 Renaissance Ctr","Detroit","48243-1300","1-800-553-6387","http://www.cisco.com","Cisco Systems, Inc. is primarily engaged in manufacturing computer peripheral equipment, not elsewhere classified, including printers, plotters, and graphic displays.","Branch","FALSE",334118,"Computer Terminal and Other Computer Peripheral Equipment Manufacturing",11,-9244025.6915,5210527.477399997],
    [12,"Cisco","Digital Tech","Yes","https://detrp.maps.arcgis.com/sharing/rest/content/items/c3937b36087e491e8c21843e1b829660/data","Vivek","Tiwari","Network Consulting Engineer-General Manager","2000 Town Ctr Ste 450","Southfield","48075-1249","1-248-455-1600","http://www.cisco.com","Cisco Systems, Inc. is primarily engaged in the wholesale distribution of computers, computer peripheral equipment, and computer software.","Branch","FALSE",423430,"Computer and Computer Peripheral Equipment and Software Merchant Wholesalers",12,-9266715.5406,5232736.431999996],
    [13,"Computech","Digital Tech","Yes","https://detrp.maps.arcgis.com/sharing/rest/content/items/b5cdbded2fbe4d6a962223b0c6de3289/data","Gregory","Cheesewright","Ceo","100 W Kirby St Ste 101","Detroit","48202-4044","1-248-594-6500","http://www.computechcorp.com","Computech Corporation is primarily engaged in providing computer programming services on a contract or fee basis. Establishments of this industry perform a variety of additional services, such as computer software design and analysis; modifications of custom software; and training in the use of custom software.","Parent","TRUE",541511,"Custom Computer Programming Services",13,-9247108.0525,5214946.641099997],
    [14,"Compuware Corporation","Digital Tech","Yes","https://detrp.maps.arcgis.com/sharing/rest/content/items/c06f27f8d0e8464193a06444e5f96c7b/data","Christopher","O'Malley","Chief Executive Officer","1 Campus Martius FL 4","Detroit","48226-5099","1-313-227-7300","http://www.compuware.com","Compuware Corp (Compuware), a subsidiary of Thoma Bravo LLC, offers mainframe application development and performance optimization solutions. The company offers application analysis, application debugging, application performance management, batch automation cybersecurity, data management, data privacy services. It also provides IMS virtualization, mainframe modernization, source code management and main frame Devops. Compuware markets products under Abend-AID, Application Audit, File-AID, ISPW, Strobe, Topaz, Xpediter brand names. Compuwares major customers include Amtrak, Bridgestone, Cigna, FBL Financial group, Kelly services, Huntington, KFB, Walmart, PNC, TCF bank, Deutsche Bank, CVS Caremark, Neiman Marcus, The hartford and Nissan. The company's business operations span across the Americas, Asia-Pacific, Australia, New Zealand and Europe. Compuware is headquartered in Detroit, Michigan, the US.","Subsidiary","TRUE",541511,"Custom Computer Programming Services",14,-9244773.2397,5210879.427599996],
    [15,"Domino's Pizza","CPS","Yes","https://detrp.maps.arcgis.com/sharing/rest/content/items/50dc6b881d7044e1af33282a7c1d9d6e/data","Richard","Allison","Chief Executive Officer, Director","30 Frank Lloyd Wright Dr","Ann Arbor","48105-9759","1-734-930-3030","http://www.dominos.com","Domino's Pizza Inc (Domino's) is a pizza restaurant chain. It provides pizza delivery and carryout services as well as dine-in services through its restaurants. Domino's offers its customers a wide range of pizzas products with varying crusts and sizes, pasta-based dishes, chicken wings, boneless chicken, oven-baked sandwiches, bread side items, soft drinks and desserts. It also offers several toppings based on country and culture. The company operates through a network of company-owned and franchise stores across the US and in international markets including India, the UK, Mexico, Australia, Turkey, Japan, South Korea, Canada, France, Germany and others. Dominos is headquartered in Ann Arbor, Michigan, the US.The company reported revenues of (US Dollars) US$3,618.8 million for the fiscal year ended December 2019 (FY2019), an increase of 5.4% over FY2018. In FY2019, the companys operating margin was 17.4%, compared to an operating margin of 16.7% in FY2018. In FY2019, the company recorded a net margin of 11.1%, compared to a net margin of 10.5% in FY2018.","Parent","TRUE",722513,"Limited-Service Restaurants",15,-9315453.8384,5208640.8116],
    [16,"DTE Energy","CPS","Yes","https://detrp.maps.arcgis.com/sharing/rest/content/items/dfbed7fa50a84c47b4879842974cb394/data","Gerardo","Norcia","President, Chief Executive Officer, Director","1 Energy Plz","Detroit","48226-1221","1-313-235-4000","http://www.newlook.dteenergy.com","DTE Energy Co (DTE Energy) is an energy utility. It develops and manages energy-related businesses and services. The company generates, procures, transmits, distributes and sells electricity; procures, stores, transports, distributes and sells natural gas. DTE Energy produces power using steam, natural gas, oil, nuclear, biomass, hydro, wind and solar sources. It also markets and trades power, natural gas and environmental products, and energy financial instruments; and provides energy and asset management services using energy commodity derivative instruments. The company serves residential, commercial and industrial customers in southeastern Michigan and other regions in the country. DTE Energy is headquartered in Detroit, Michigan, the US.The company reported revenues of (US Dollars) US$12,669 million for the fiscal year ended December 2019 (FY2019), a decrease of 10.9% over FY2018. In FY2019, the companys operating margin was 13.5%, compared to an operating margin of 11.2% in FY2018. In FY2019, the company recorded a net margin of 9.2%, compared to a net margin of 7.9% in FY2018.","Parent","TRUE",221112,"Fossil Fuel Electric Power Generation",16,-9245901.0202,5211046.1494999975],
    [17,"Duo Security","Digital Tech","Yes","https://detrp.maps.arcgis.com/sharing/rest/content/items/babc2260164549feadb9cdc3f0dab89d/data","Jillian","Hufnagel","Chief Of Staff To Chief Executive Officer","123 N Ashley St Ste 200","Ann Arbor","48104-1316","1-734-330-2673","http://www.duosecurity.com","Duo Security, Inc. is primarily engaged in the design, development, and production of prepackaged computer software. Important products of this industry include operating, utility, and applications programs. Establishments of this industry may also provide services such as preparation of software documentation for the user-installation of software for the user; and training the user in the use of the software.","Subsidiary","TRUE",511210,"Software Publishers",17,-9323032.9565,5203335.284999996],
    [18,"Google","Digital Tech","Yes","https://detrp.maps.arcgis.com/sharing/rest/content/items/65cb9dc35d6045b89436c4828dbae0c6/data","Terrell","Rogers","Ceo","2300 Traverwood Dr","Ann Arbor","48105-2196","1-734-332-6500","http://www.online-motor-deutschland.de","Google Llc is primarily engaged in providing computer programming services on a contract or fee basis. Establishments of this industry perform a variety of additional services, such as computer software design and analysis; modifications of custom software; and training in the use of custom software.","Branch","FALSE",541511,"Custom Computer Programming Services",18,-9319022.5598,5206941.5451000035],
    [19,"Google","Digital Tech","Yes","https://detrp.maps.arcgis.com/sharing/rest/content/items/65cb9dc35d6045b89436c4828dbae0c6/data","Scott","Anderson","Ceo","110 Willits St","Birmingham","48009-3313","1-248-593-4000","http://www.online-motor-deutschland.de","Google Llc is primarily engaged in providing computer programming services on a contract or fee basis. Establishments of this industry perform a variety of additional services, such as computer software design and analysis; modifications of custom software; and training in the use of custom software.","Branch","FALSE",541511,"Custom Computer Programming Services",19,-9263574.5158,5243370.598200001],
    [20,"Hcl Global Systems","Digital Tech","Yes","https://detrp.maps.arcgis.com/sharing/rest/content/items/b43ee02d5a3e4b179bd8fe58e056613b/data","Durga","Gadde","President","24543 Indoplex Cir Ste 220","Farmington","48335-2529","1-248-473-0720","http://www.hclglobal.com","Hcl Global Systems, Inc. is primarily engaged in supplying computer related services, not elsewhere classified. Computer consultants operating on a contract or fee basis are classified in this industry.","Independent","FALSE",541512,"Computer Systems Design Services",20,-9283505.9621,5231986.023500003],
    [21,"Htc Global Services","Digital Tech","Yes","https://detrp.maps.arcgis.com/sharing/rest/content/items/b9342924c3e048c6a6005192cf77e1ba/data","Jim","Jiordano","President, Chief Executive Officer","3270 W Big Beaver Rd Ste 100","Troy","48084-2901","1-248-786-2500","http://www.htcinc.com","HTC Global Services offers information technology (IT) services to customers in a wide range of industries. The company specializes in such areas as application development, integration, and reengineering, software testing, enterprise content management, business intelligence, and IT infrastructure management. It also sells business process automation software for such functions as content management, claims processing, and tax accounting. Founded in 1990, HTC serves customers worldwide in industries that include automotive, manufacturing, education, health care, financial services, insurance, publishing, and retail.","Parent","TRUE",541512,"Computer Systems Design Services",21,-9261016.4193,5245664.780199997],
    [22,"Intel","Digital Tech","Yes","https://detrp.maps.arcgis.com/sharing/rest/content/items/beb8822d69064cf09522b8ddae2952e5/data","","","","22200 W 11 Mile Rd","Southfield","48037-7136","1-248-633-6676","","Nonclassifiable establishments","Independent","FALSE",999990,"Nonclassifiable Establishments",22,-9268831.7229,5234305.045999996],
    [23,"IBM","Digital Tech","Yes","https://detrp.maps.arcgis.com/sharing/rest/content/items/84254c99894c4849b2ff7d7bf7ec8341/data","Frederic","Champlain","Executive","400 Renaissance Ctr Ste 2710","Detroit","48243-1675","1-313-656-3220","http://www.ibm.com","International Business Machines Corporation is primarily engaged in furnishing business services, not elsewhere classified, such as bondspersons, drafting services, lecture bureaus, notaries public, sign painting, speakers' bureaus, water softening services, and auctioneering services, on a commission or fee basis.","Branch","FALSE",522320,"Financial Transactions Processing, Reserve, and Clearinghouse Activities",23,-9244023.9265,5210528.671800002],
    [24,"IBM","Digital Tech","Yes","https://detrp.maps.arcgis.com/sharing/rest/content/items/84254c99894c4849b2ff7d7bf7ec8341/data","Edwin","Pinheiro","Program Manager","40950 Woodward Ave Ste 200","Bloomfield Hills","48304-5127","1-313-394-3100","http://www.ibm.com","International Business Machines Corporation is primarily engaged in furnishing operating counsel and assistance to managements of private, nonprofit, and public organizations. These establishments generally perform a variety of activities, such as strategic and organizational planning; financial planning and budgeting; marketing objectives and policies; information systems planning, evaluation and selection; human resource policies and practices planning; and production scheduling and control planning.","Branch","FALSE",541611,"Administrative Management and General Management Consulting Services",24,-9267260.1078,5249846.520499997],
    [25,"IBM","Digital Tech","Yes","https://detrp.maps.arcgis.com/sharing/rest/content/items/84254c99894c4849b2ff7d7bf7ec8341/data","Douglas","Frezell","Principal","18000 W 9 Mile Rd Fl 10","Southfield","48075-4029","1-248-552-4200","http://www.ibm.com","International Business Machines Corporation is primarily engaged in the wholesale distribution of computers, computer peripheral equipment, and computer software.","Branch","FALSE",423430,"Computer and Computer Peripheral Equipment and Software Merchant Wholesalers",25,-9263811.3254,5230071.488899998],
    [26,"IBM","Digital Tech","Yes","https://detrp.maps.arcgis.com/sharing/rest/content/items/84254c99894c4849b2ff7d7bf7ec8341/data","Jeffery","Smith","Security Specialist","100 Phoenix Dr","Ann Arbor","48108-2635","1-734-913-3000","http://www.ibm.com","International Business Machines Corporation is primarily engaged in furnishing operating counsel and assistance to managements of private, nonprofit, and public organizations. These establishments generally perform a variety of activities, such as strategic and organizational planning; financial planning and budgeting; marketing objectives and policies; information systems planning, evaluation and selection; human resource policies and practices planning; and production scheduling and control planning.","Branch","FALSE",541611,"Administrative Management and General Management Consulting Services",26,-9320701.7018,5196151.993000001],
    [27,"K.L.A. Laboratories","Digital Tech","Yes","https://detrp.maps.arcgis.com/sharing/rest/content/items/f49f460a31884bf4b6cd43b0a7d7e81b/data","Matt","Obryan","President & Ceo","6800 Chase Rd","Dearborn","48126-1793","1-313-846-3800","http://www.klalabs.com","K.L.A. Laboratories, Inc. is primarily engaged in developing or modifying computer software and packaging or bundling the software with purchased computer hardware (computers and computer peripheral equipment) to create and market an integrated system for specific application. Establishments in this industry must provide each of the following services: (1) the development or modification of the computer software; (2) the marketing of purchased computer hardware; and (3) involvement in all phases of systems development from design through installation.","Parent","TRUE",541512,"Computer Systems Design Services",27,-9260230.9523,5212110.802500002],
    [28,"Kelly Services","CPS","Yes","https://detrp.maps.arcgis.com/sharing/rest/content/items/1e49aa9c7f55476bb75ba2bef0be85b6/data","George","Corona","President, CEO and Director","999 W Big Beaver Rd","Troy","48084-4716","1-248-362-4444","http://www.kellyservices.com","Kelly Services Inc (Kelly) is a provider of workforce solutions. The company offers specialty staffing, and outsourcing and consulting services on temporary, temporary-to-hire and direct-hire basis. It recruits supporting staff, manual work force, professional employees, and other staff. The company also offers centralized payroll processing solutions; recruitment process outsourcing; career transition and executive coaching and development; and executive search work force solutions. The company provides services in automotive, diversified conglomerates, consumer goods, high tech, life sciences, finance and insurance, and natural resources sectors across North America, South America, Europe, the Middle East, Africa, and Asia Pacific. Kelly is headquartered in Troy, Michigan, the US.The company reported revenues of (US Dollars) US$5,355.6 million for the fiscal year ended December 2019 (FY2019), a decrease of 2.9% over FY2018. In FY2019, the companys operating margin was 1.5%, compared to an operating margin of 1.6% in FY2018. In FY2019, the company recorded a net margin of 2.1%, compared to a net margin of 0.4% in FY2018.","Parent","TRUE",561320,"Temporary Help Services",28,-9258022.3775,5245361.302199997],
    [29,"Microsoft","Digital Tech","Yes","https://detrp.maps.arcgis.com/sharing/rest/content/items/d2aa18866c034a4f829dec14ad32ab0a/data","Susan","Demars","President","1092 Woodward Ave Ste 500","Detroit","48226-1913","1-248-208-0016","","Microsoft Corporation is primarily engaged in the design, development, and production of prepackaged computer software. Important products of this industry include operating, utility, and applications programs. Establishments of this industry may also provide services such as preparation of software documentation for the user-installation of software for the user; and training the user in the use of the software.","Branch","FALSE",511210,"Software Publishers",29,-9244801.6756,5210926.440200001],
    [30,"Microsoft","Digital Tech","Yes","https://detrp.maps.arcgis.com/sharing/rest/content/items/d2aa18866c034a4f829dec14ad32ab0a/data","Bryan","Dykstra","Director, Customer Success","27500 Novi Rd Ste K110","Novi","48377-3418","","","Microsoft Corporation is primarily engaged in providing computer programming services on a contract or fee basis. Establishments of this industry perform a variety of additional services, such as computer software design and analysis; modifications of custom software; and training in the use of custom software.","Branch","FALSE",541511,"Custom Computer Programming Services",30,-9291798.2693,5234951.167099997],
    [31,"Onestream","Digital Tech","Yes","https://detrp.maps.arcgis.com/sharing/rest/content/items/57642d992ad94764a81ca733b7988415/data","Tom","Shea","Chief Executive Officer","362 South Street Rochester","Rochester","48307","1-248-342-1541","http://www.onestreamsoftware.com","Onestream Software Llc is primarily engaged in the design, development, and production of prepackaged computer software. Important products of this industry include operating, utility, and applications programs. Establishments of this industry may also provide services such as preparation of software documentation for the user-installation of software for the user; and training the user in the use of the software.","Parent","TRUE",511210,"Software Publishers",31,-9253520.5053,5262683.000399999],
    [32,"Oracle","Digital Tech","Yes","https://detrp.maps.arcgis.com/sharing/rest/content/items/cfd9d51b2b9b4f88803a2c403423ce00/data","Dan","Vredeveld","Principal Service Delivery Manager","3216 Hickory Dr","Orion","48359-1163","1-248-393-2498","","Oracle Corporation is primarily engaged in the design, development, and production of prepackaged computer software. Important products of this industry include operating, utility, and applications programs. Establishments of this industry may also provide services such as preparation of software documentation for the user-installation of software for the user; and training the user in the use of the software.","Branch","FALSE",511210,"Software Publishers",32,-9272002.7678,5271344.457999997],
    [33,"Oracle","Digital Tech","Yes","https://detrp.maps.arcgis.com/sharing/rest/content/items/cfd9d51b2b9b4f88803a2c403423ce00/data","Sean","Howard","Senior Principal Consultant","1365 N Fairview Ln","Oakland","48306-4133","1-248-614-5139","","Oracle Systems Corporation is primarily engaged in the design, development, and production of prepackaged computer software. Important products of this industry include operating, utility, and applications programs. Establishments of this industry may also provide services such as preparation of software documentation for the user-installation of software for the user; and training the user in the use of the software.","Branch","FALSE",511210,"Software Publishers",33,-9257756.4341,5266714.770900004],
    [34,"Oracle","Digital Tech","Yes","https://detrp.maps.arcgis.com/sharing/rest/content/items/cfd9d51b2b9b4f88803a2c403423ce00/data","Ric","Ginsberg","VICE PRESIDENT SUPPORT SERVICES","3290 W Big Beaver Rd Ste 300","Troy","48084-2910","1-248-816-8050","","Oracle Systems Corporation is primarily engaged in the design, development, and production of prepackaged computer software. Important products of this industry include operating, utility, and applications programs. Establishments of this industry may also provide services such as preparation of software documentation for the user-installation of software for the user; and training the user in the use of the software.","Branch","FALSE",511210,"Software Publishers",34,-9261141.3199,5245751.5397000015],
    [35,"Pinterest","Digital Tech","Yes","https://detrp.maps.arcgis.com/sharing/rest/content/items/162a1e3140bc42af84c883cd8c248e90/data","Kelly","Majauskas","Partner Manager","1449 Woodward Ave","Detroit","48226-2001","","","Nonclassifiable establishments","Independent","FALSE",999990,"Nonclassifiable Establishments",35,-9245041.6309,5211242.911399998],
    [36,"Quicken Loans","Fintech","Yes","https://detrp.maps.arcgis.com/sharing/rest/content/items/56e56db4d72f409ba65f2f4643ef0ae2/data","Dan","Valentini","President","1050 Woodward Ave","Detroit","48226-1906","1-800-251-9080","http://www.quickenloans.com","America's largest home mortgage lender, Quicken Loans offers residential mortgages in all 50 states and provides financing options including fixed- and adjustable-rate mortgages, reverse mortgages, and refinancing through its website. The company operates a centralized loan processing facility in Detroit. Affiliate Amrock (formerly Title Source) is the largest independent title insurance, valuations, and settlement provider in the US. Its San Diego-based One Reverse Mortgage unit handles FHA-backed reverse mortgage programs. Another division, Rocket Homes (formerly In-House Realty), includes a network of more than 25,000 real estate agents. Rock Holdings, which is led by founder and chairman Dan Gilbert, owns Quicken Loans.","Subsidiary","TRUE",522292,"Real Estate Credit",36,-9244788.694,5210904.977899998],
    [37,"Rivian Automotive","Mobility","Yes","https://detrp.maps.arcgis.com/sharing/rest/content/items/049eb1e6bf3b4021a6eb8a040a4cf1d0/data","Robert","Scaringe","Ceo","13250 N Haggerty Rd","Plymouth","48170-4206","1-734-855-4350","http://www.rivian.com","Rivian Automotive, Inc. is primarily engaged in manufacturing or assembling complete passenger automobiles, trucks, commercial cars and buses, and special purpose motor vehicles which are for highway use. This also includes the manufacturing of chassis and passenger car bodies.","Parent","TRUE",336111,"Automobile Manufacturing",37,-9289502.0821,5217694.3609],
    [38,"Rivian Automotive","Mobility","Yes","https://detrp.maps.arcgis.com/sharing/rest/content/items/049eb1e6bf3b4021a6eb8a040a4cf1d0/data","Julie","Meece","Environment Health Safety Lead","13250 N Haggerty Rd","Plymouth","48170-4206","1-734-855-4350","","Rivian Automotive, Llc is primarily engaged in manufacturing or assembling complete passenger automobiles, trucks, commercial cars and buses, and special purpose motor vehicles which are for highway use. This also includes the manufacturing of chassis and passenger car bodies.","Subsidiary","TRUE",336111,"Automobile Manufacturing",38,-9289502.0821,5217694.3609],
    [39,"Secure-24","Digital Tech","Yes","https://detrp.maps.arcgis.com/sharing/rest/content/items/5a67d0ffdb154746a0a499c13b771e8d/data","Brian","Stempien","Sap Principal Architect","26955 Northwestern Hwy","Southfield","48033-4713","1-248-784-1021","","Secure-24 stands guard all day, every day. The data security company provides managed network services, disaster recovery,business process outsourcing, andWeb application hostingservices toenterprise customers in the public and private sector, including many automotive suppliers. It also targets clients in the private equityfinance, health care, and manufacturing industries, including those who need to meet federal compliance laws. Secure-24 specializes in hosting enterprisesoftware systems from Oracle and SAP. The company has data centers in Michigan and Arizona.","Subsidiary","FALSE",541513,"Computer Facilities Management Services",39,-9269940.8495,5233858.107900001],
    [40,"Stefanini","Digital Tech","Yes","https://detrp.maps.arcgis.com/sharing/rest/content/items/cdc792bbcc5d4492987dd022082076e1/data","Richard","Stefani","Pres","27100 W 11 Mile Rd","Southfield","48034-2246","1-248-357-2866","http://www.stefanini.com","Stefanini TechTeam, Inc. (Stefanini) is an information technology outsourcing (IT) company, which provides infrastructure and business process outsourcing; and application development and integration services to medium and large companies as well as government organizations. It also provides IT staffing services in diverse practice areas and sectors. The company caters to public and private organizations operating in the areas of telecom, insurance, finance, healthcare, retail and oil and gas, among others. Stefanini operates through a network of sales offices and development centers across the Americas, Europe, Latin America and Asia. It also operates support centers to serve multinational clients in their local languages. Stefanini is headquartered in Jaguariuna, Sao Paulo, Brazil.","Subsidiary","TRUE",541512,"Computer Systems Design Services",40,-9274301.0608,5234030.597400002],
    [41,"Stock X","Digital Tech","Yes","https://detrp.maps.arcgis.com/sharing/rest/content/items/60c938a963d04316bedf6c1878d3de32/data","Scott","Cutler","CEO","1046 Woodward Ave","Detroit","48226-1906","1-313-782-9543","http://www.stockx.com","Stockx Llc is primarily engaged in providing computer programming services on a contract or fee basis. Establishments of this industry perform a variety of additional services, such as computer software design and analysis; modifications of custom software; and training in the use of custom software.","Parent","TRUE",541511,"Custom Computer Programming Services",41,-9244787.4576,5210902.933899999],
    [42,"Twitter","Digital Tech","Yes","https://detrp.maps.arcgis.com/sharing/rest/content/items/e82d1e5a43984c64bf0613201466c8e9/data","","","","1319 Smith Ave","Birmingham","48009-2039","1-248-720-9898","","Twitter Pro Productions Llc is primarily engaged in the distribution (rental or sale) of theatrical and nontheatrical motion picture films or in the distribution of video tapes and disks, except to the general public.","Independent","FALSE",512120,"Motion Picture and Video Distribution",42,-9262160.0075,5241272.947099999],
    [43,"Waymo","Mobility","Yes","https://detrp.maps.arcgis.com/sharing/rest/content/items/8c18187726d64cc993ca1084065a3959/data","Robert","Ellis","Chief Engineer","46555 Magellan Dr","Novi","48377-2452","1-734-249-3872","","Nonclassifiable establishments","Independent","FALSE",999990,"Nonclassifiable Establishments",43,-9296329.9718,5236184.655299999],
    [44,"Ally Financial","Fintech","","","Jeffrey","Brown","Chief Executive Officer, Director","500 Woodward Ave FL 10","Detroit","48226-3423","1-866-710-4623","http://www.ally.com","Ally Financial Inc (Ally Financial) is a bank holding company that offers dealer finance and banking solutions Dealer finance comprises automotive finance, mortgage finance, insurance operations, and corporate finance. Banking comprises mortgage lending, deposits, online saving, certificate of deposits, checking accounts, money market, individual retirement accounts, debit and credit cards, digital wealth management, and online brokerage. It serves retail, business, automotive dealers, and corporate clients through branch offices, direct sales force, and online portals. The company operates in the US and Canada. Ally Financial is headquartered in Detroit, Michigan, the US.The bank reported interest income of (US Dollars) US$9,052 million for the fiscal year ended December 2018 (FY2018), an increase of 8.8% over FY2017. The net interest income after loan loss provision of the bank was US$4,497 million in FY2018, compared to net interest income after loan loss provision of US$4,317 million in FY2017. In FY2018, the bank recorded a net margin of 12.1%, compared to a net margin of 9.4% in FY2017.The bank reported interest income of US$2,433.0 million for the first quarter ended March 2019, an increase of 1% over the previous quarter.","Parent","TRUE",522110,"Commercial Banking",44,-9244521.2115,5210550.528700002],
    [45,"Altair Engineering","Mobility","","","James","Scapa","Chairman of the Board, Chief Executive Officer, Director","1820 E Big Beaver Rd","Troy","48083-2031","1-248-614-2400","http://www.altair.com","Altair is an information technology and product development consulting company. Altair provides software and services to more than 5,000 customers in the automotive, aerospace, heavy equipment, and consumer products industries, among others. The company develops custom software for industrial design, engineering simulation, corporate data analysis, and computer networking applications. Altair also provides product design services for automobiles and consumer goods, among other items. Customers have included such notable names as Ford, Boeing, John Deere, the US Department of Energy, the US Navy, Procter & Gamble, and Pfizer.It went public in 2017.","Parent","TRUE",511210,"Software Publishers",45,-9251953.3502,5245554.756300002],
    [46,"Altimetrik Corp.","Digital Tech","","","Raj","Sundaresan","Chief Executive Officer","1000 Town Ctr Ste 700","Southfield","48075-1220","1-248-281-2500","http://www.altimetrik.com","Altimetrik Corp. is primarily engaged in providing computer programming services on a contract or fee basis. Establishments of this industry perform a variety of additional services, such as computer software design and analysis; modifications of custom software; and training in the use of custom software.","Parent","TRUE",541511,"Custom Computer Programming Services",46,-9266680.6905,5232586.101400003],
    [47,"Ameritrust Group","Fintech","","","Kenn","Allen","President and Chief Executive Officer","26255 American Dr","Southfield","48034-6112","1-248-358-1100","http://www.ameritrustgroup.com","AmeriTrust (formerly Meadowbrook Insurance), through subsidiaries including Meadowbrook Insurance, Star Insurance, Savers Property and Casualty, Williamsburg National, ProCentury, and Century Surety, writes a variety of specialty commercial property/casualty policies including workers' compensation, commercial auto, and multi-peril liability. With coverage tailored to fit small to midsized businesses, customers include self-insured companies, trade groups, and associations. AmeriTrust also offers brokering, risk management consulting, and insurance management services including claims handling and administrative services. Chinese conglomerate Fosun International bought the firm for $433 million in 2015.","Subsidiary","TRUE",524210,"Insurance Agencies and Brokerages",47,-9273390.475,5234822.091200002],
    [48,"Aptiv","Mobility","","","Karl","Iagnemma","President & Co-Founder","5820 Innovation Dr","Troy","48098-2824","1-248-813-2000","http://www.aptiv.com","Aptiv Corporation is primarily engaged in manufacturing motor vehicle parts and accessories, but not engaged in manufacturing complete motor vehicles or passenger car bodies.","Subsidiary","TRUE",336390,"Other Motor Vehicle Parts Manufacturing",48,-9257478.6874,5251817.8576000035],
    [49,"Aptiv","Mobility","","","Marty","Mohler","Sales Director, Central U. s","5725 Innovation Dr","Troy","48098-2852","1-248-813-2000","http://www.delphi.com","Aptiv Services Us, Llc is primarily engaged in manufacturing motor vehicle parts and accessories, but not engaged in manufacturing complete motor vehicles or passenger car bodies.","Subsidiary","TRUE",336390,"Other Motor Vehicle Parts Manufacturing",49,-9257548.3784,5251562.268799998],
    [50,"Arcadia Services","Digital Tech","","","James","Bellinson","President","20750 Civic Center Dr Ste 100","Southfield","48076-4129","1-248-352-7530","http://www.arcadiahomecare.com","Arcadia Services, Inc. is primarily engaged in supplying temporary or continuing help on a contract or fee basis. The help supplied is always on the payroll of the supplying establishments, but is under the direct or general supervision of the business to whom the help is furnished.","Parent","TRUE",561320,"Temporary Help Services",50,-9267352.9481,5233451.2722999975],
    [51,"Bae Industries","Defense","","","Stephen","Bruck","V Pres","26020 Sherwood Ave","Warren","48091-1252","1-586-754-3000","http://www.baeind.com","Bae Industries, Inc. is primarily engaged in manufacturing automotive stampings, such as body parts, hubs, and trim.","Subsidiary","TRUE",336370,"Motor Vehicle Metal Stamping",51,-9243858.6391,5233943.364],
    [52,"Barton Malow Company","Construction","","","Ryan","Maibach","Chief Executive Officer","26500 American Dr","Southfield","48034-2252","1-248-436-5000","http://www.bartonmalow.com","Barton Malow Co (Barton Malow) is a general construction contractor. It provides construction services; program management; design and build; general contracting; and technology and equipment installation services throughout North America and Mexico. The company offers its services to various sectors such as healthcare, sports, education, corporate and industrial, energy, environmental, industrial, and federal and government. Some of its major projects include Lake Central High School; Ford Field LED Displays; St. Joseph's Women's Hospital NICU; St. Joseph's Hospital South-BayCare; Rockvale High School and Holland Energy Park in Holland. It has regional offices across Maryland, Michigan, North Carolina, Virginia, Indiana, Ohio, Tennessee, Illinois, Pennsylvania, Florida and Georgia. Barton Malow is headquartered in Southfield, Michigan, the US.","Subsidiary","TRUE",561110,"Office Administrative Services",52,-9273018.1151,5234370.867700003],
    [53,"Belle Tires","CPS","","","Don","Barnes","Vice President","1000 Enterprise Dr","Allen Park","48101-3029","1-888-462-3553","http://www.belletire.com","Even black rubber can be beautiful at Belle Tire. The company operates more than 80 tire stores and automotive service centers throughout Michigan and in Cleveland and Toledo, Ohio. It also has a fleet of about 20mobile repairvans.Tire brands include BF Goodrich, Continental, Kelly, and Michelin. Services cover the air conditioning, braking, coolant, and suspension systems, among others. The company added glass repairand replacement to its service offerings in 2007. Belle Tire stores also offer custom wheels from such makers as American Racing Equipment and Cragar Industries.Founded in 1922 as a single location, Belle Tireis a family-run business and led by CEO Bob Barnes.","Parent","TRUE",441320,"Tire Dealers",53,-9260455.3741,5204839.141500004],
    [54,"Big Boy Restaurants International","CPS","","","Kelly","Murphy","Senior Director","26300 Telegraph Rd Ste 101","Southfield","48033-2488","1-586-759-6000","http://www.bigboyrestaurantsinternational.com","This restaurant chain has been feeding boys big and small for more than 70 years. Big Boy Restaurants International operates and franchises more than 135 of its signature family-dining spots in Michigan and more than half a dozen other states. Known for their hamburgers (and the iconic Big Boy figure holding a plate-sized sandwich), the restaurants also offer a full menu of breakfast options along with such home style dinner favorites as meat loaf, pork chops, and chicken fried steak. More than 20 locations are company-owned, while the rest are franchised. The company also has some 300 licensed Big Boy units operating in Japan. Founded by Bob Wian in 1936, the Big Boy chain is owned by chairman Robert Liggett.","Parent","TRUE",722511,"Full-Service Restaurants",54,-9271230.5411,5233492.024300002],
    [55,"Bosch Automotive","Mobility","","","Mark","Seaquist","Traffic Manager","28635 Mound Rd","Warren","48092-5509","1-586-574-2332","http://www.otctools.com","Bosch Automotive Service Solutions Inc. is primarily engaged in furnishing automotive services, except repair and carwashes.","Subsidiary","TRUE",811198,"All Other Automotive Repair and Maintenance",55,-9244826.2318,5236743.474399999],
    [56,"Bridgewater Interiors","Mobility","","","Ronald","Hall","Vice President","4617 W Fort St","Detroit","48209-3208","1-313-842-3300","http://www.bridgewater-interiors.com","Bridgewater Interiors, L.L.C. is primarily engaged in the wholesale distribution of motor vehicle supplies, accessories, tools, and equipment; and new motor vehicle parts.","Subsidiary","TRUE",423120,"Motor Vehicle Supplies and New Parts Merchant Wholesalers",56,-9249722.3911,5207695.231200002],
    [57,"Caretech Solutions","Digital Tech","","","Robert","Milewski","Pres","3270 W Big Beaver Rd Ste 100","Troy","48084-2901","1-877-700-8324","http://www.caretech.com","When health care providers start to feel faint at the idea of managing all their data, they can call on CareTech Solutions. The company provides outsourced information technology services for hospitals, integrated health systems, and other health care organizations. It provides services for staffing, staff management, computer and network operations, help desk management, technology standards and architecture management and design, application selection and implementation, maintenance, and vendor contract management. The company is owned by a group of investors that includes Compuware, Detroit Medical Center, and Oakwood Healthcare. The company was purchased by HTC Global Services in late 2014.","Subsidiary","TRUE",541519,"Other Computer Related Services",57,-9261016.4193,5245664.780199997],
    [58,"Carhartt","CPS","","","Mark","Valade","Chief Executive Officer","5750 Mercury Dr","Dearborn","48126-4167","1-313-271-8460","http://www.carhartt.com","Carhartt makes workwear clothing meant to last. The clothing company makes rugged overalls, flame-resistant workwear, outerwear, sweatshirts, sportswear, and pants favored by farmers, construction workers, and other hard-working people. Most of Carhartt's products, sold to men, women, and children, are made in US factories. The company also has operations in Mexico and Europe. The company operates about 30 retail shops in the US. Its apparel is also carried by major chains, including Bass Pro Shops and Cabela's and international retailers in North America, Europe, and Japan. The family of founder Hamilton Carhartt owns the firm, which was founded in 1889.","Parent","TRUE",315210,"Cut and Sew Apparel Contractors",58,-9262246.9509,5210924.122100003],
    [59,"Ciber Global","Digital Tech","","","Jonathan","Gilbert","Principal Enterprise Architect & Director, It Strategy","3270 W Big Beaver Rd Ste 120","Troy","48084-2901","1-248-786-2500","http://www.ciber.com","Ciber Global LLC (Ciber), a subsidiary of HTC Global Services, is a global information technology (IT) services company. The company provides a broad range of services that include application development and maintenance, independent software vendor relationships, and managed services. It offers services to various industries including distribution, logistics, transportation, financial services, healthcare and life sciences, manufacturing and public sector and education. Ciber's partners include Amazon (AWS), Brocade, Cerner, Cisco Systems, DellEMC, , Google, Help Systems, HPE, Information Builders, Intermec, Netapp, Qlik View, Red Hat, SonicWALL, Vision Software, VMWare, Xamarin and Zebra. It's operations are spread across the US and India. Ciber is headquartered in Troy, Michigan, the US.","Subsidiary","FALSE",541512,"Computer Systems Design Services",59,-9261016.4193,5245664.780199997],
    [60,"Comerica Bank","Fintech","","","","","","","Detroit","48255","","","Comerica Bank is a commercial bank and trust company (accepting deposits) chartered under the National Bank Act.","Branch","FALSE",522110,"Commercial Banking",60,-9244861.0714,5210793.715999998],
    [61,"Detroit Entertainment","CPS","","","Mike","Roy","Vice President","2901 Grand River Ave","Detroit","48201-2907","1-313-237-7711","http://www.motorcitycasino.com","Commercial establishments, known to the public as hotels, motor hotels, motels, or tourist courts, primarily engaged in providing lodging, or lodging and meals, for the general public. Hotels which are operated by membership organizations and open to the general public are included in this industry.","Subsidiary","FALSE",721120,"Casino Hotels",61,-9247038.4829,5211971.3461000025],
    [62,"Detroit Technologies","Digital Tech","","","William","Vaughn","Executive Vice President","32500 Telegraph Rd Ste 207","Bingham Farms","48025-2463","1-248-647-0400","http://www.conformgroup.com","Detroit Technologies, Inc. is primarily engaged in manufacturing motor vehicle parts and accessories, but not engaged in manufacturing complete motor vehicles or passenger car bodies.","Parent","TRUE",336390,"Other Motor Vehicle Parts Manufacturing",62,-9271154.8505,5240247.395400003],
    [63,"Epitec","Digital Tech","","","Jerry","Sheppard","Chief Executive Officer","24800 Denso Dr Ste 150","Southfield","48033-7464","1-248-353-6800","http://www.epitecinc.com","Epitec supports the idea that surrounding oneself with smart people is the key to a successful business. The company provides information technology staffing services to businesses across the US, although its primary market is the Detroit area. It offers contract, contract-to-hire, and direct hire placement of developers, analysts, architects, engineers, and other technical staff to companies in a wide range of industries. Epitec also provides on-site management services and related custom software development. It was founded by CEO Jerry Sheppard in 1978.","Parent","TRUE",541511,"Custom Computer Programming Services",63,-9271769.4446,5232877.852300003],
    [64,"Fanuc America Corporation","Mobility","","","Mark","Sturwold","Vice President","3900 W Hamlin Rd","Rochester Hills","48309-3253","1-248-377-7000","http://www.fanucamerica.com","Warning! Warning! There's no danger for Lost in Space ' s Will Robinson as long as FANUC America makes intelligent robots that automate industrial manufacturing. A subsidiary of Japan-based robotics giant FANUC LTD, the company's robotic devices automate assembly, cleaning, dispensing, grinding, packaging, painting, polishing, and welding processes. FANUC's robots supply equipment to industries as diverse as aerospace, agriculture, food and beverage, medical devices, and textile industries, to name a few. It also provides engineering, service support, analysis, and system maintenance. Brand names include its ROBODRILL machining centers and CNC Systems factory automation products.","Subsidiary","TRUE",333249,"Other Industrial Machinery Manufacturing",64,-9262877.687,5258757.843699999],
    [65,"Faurecia Automotive","Mobility","","","Eric","Peterson","Stamping Strategy / Costing Manager, Automotive Seating Business Group-Nao","2800 High Meadow Cir","Auburn Hills","48326-2772","1-248-288-1000","http://www.faurecia.com","Faurecia Automotive Seating, Llc is primarily engaged in providing professional engineering services. Establishments primarily providing and supervising their own engineering staff on temporary contract to other firms are included in this industry.","Subsidiary","TRUE",541330,"Engineering Services",65,-9265766.6465,5260374.998599999],
    [66,"FCA","Mobility","","","Jason","Stockberger","Business Unit Leader","1000 Chrysler Dr","Auburn Hills","48326-2766","1-248-576-5741","http://www.chrysler.com","As the North American arm of Fiat Chrysler Automobiles, FCA US LLC manufactures a range of vehicles under its Fiat and Chrysler brands, including Jeep, Ram, Dodge, Alfa Romeo, and Abarth at 45 plants in the US and Mexico. It ships about 2.5 million vehicles every year. It also features its parent's trademarked MOPAR (MOtor PARts) automobile parts and service brand which carries more than 500,000 parts, options, and accessories for vehicle customization.","Subsidiary","TRUE",441110,"New Car Dealers",66,-9265394.9701,5259661.383199997],
    [67,"Fisher Unitech","Digital Tech","","","Matt","Wise","Chief Executive Officer","404 E 10 Mile Rd # 150","Pleasant Ridge","48069-1201","1-248-577-5100","http://www.funtech.com","Fisher Unitech, Llc is primarily engaged in developing or modifying computer software and packaging or bundling the software with purchased computer hardware (computers and computer peripheral equipment) to create and market an integrated system for specific application. Establishments in this industry must provide each of the following services: (1) the development or modification of the computer software; (2) the marketing of purchased computer hardware; and (3) involvement in all phases of systems development from design through installation.","Subsidiary","TRUE",541512,"Computer Systems Design Services",67,-9254533.5105,5232374.051100001],
    [68,"Flagstar Bank","Fintech","","","Danny","Wade","Vice-President","5151 Corporate Dr","Troy","48098-2639","1-248-312-2000","http://www.flagstar.com","Federally chartered savings institutions (accepting deposits) operating under Federal charter.","Subsidiary","TRUE",522120,"Savings Institutions",68,-9259137.6844,5250322.230700001],
    [69,"Ford Holdings","Mobility","","","","","","American Rd","Dearborn","48121","1-313-845-5338","http://www.ford.com","Ford Holdings Llc is primarily engaged in subdividing real property into lots, except cemetery lots, and in developing it for resale on their own account.","Subsidiary","TRUE",237210,"Land Subdivision",69,-9263233.6161,5208133.0493],
    [70,"Ford Motor Company","Mobility","","","James","Hackett","President, Chief Executive Officer, Director","1 American Rd","Dearborn","48126-2798","1-313-322-3000","http://www.ford.com","Ford Motor Co (Ford) is an automotive company, which designs, manufactures, markets and services a full line of cars, trucks, sport utility vehicles and electrified vehicles. The company provides vehicle-related financing and leasing services. Ford markets its products under the brand name of Ford and Lincoln. Ford also has interests in autonomous vehicles and mobility service entity, Ford Smart Mobility LLC. It serves customers across South America, the Middle East, Europe, North America, Africa and Asia Pacific. The company has transmission, assembly, forging, stamping and engine facilities across the world. Ford is headquartered in Dearborn, Michigan, the US.The company reported revenues of (US Dollars) US$155,900 million for the fiscal year ended December 2019 (FY2019), a decrease of 2.8% over FY2018. In FY2019, the companys operating margin was 0.3%, compared to an operating margin of 2% in FY2018. The net profit of the company was US$47 million in FY2019, compared to a net profit of US$3,677 million in FY2018. The company reported revenues of US$34,320 million for the first quarter ended March 2020, a decrease of 13.6% over the previous quarter.","Parent","TRUE",336111,"Automobile Manufacturing",70,-9262407.5881,5208644.8445999995],
    [71,"Ford Motor Company","Mobility","","","Susan","Lampinen","Colours & Materials Chief Designer","21175 Oakwood Blvd","Dearborn","48124-4079","1-313-322-7715","http://www.ford.com","Ford Motor Company is primarily engaged in manufacturing or assembling complete passenger automobiles, trucks, commercial cars and buses, and special purpose motor vehicles which are for highway use. This also includes the manufacturing of chassis and passenger car bodies.","Branch","FALSE",336111,"Automobile Manufacturing",71,-9266196.9034,5206305.162299998],
    [72,"Ford Motor Company","Mobility","","","Arthur","Jack","Principal","701 E Saint Clair St","Romeo","48065-5287","1-586-752-8000","http://www.ford.com","Ford Motor Company is primarily engaged in the retail sale of new automobiles or new and used automobiles. These establishments frequently maintain repair departments and carry stocks of replacement parts, tires, batteries, and automotive accessories. These establishments also frequently sell pickups and vans at retail.","Branch","FALSE",441110,"New Car Dealers",72,-9239358.9969,5282628.825199999],
    [73,"Ford Motor Company","Mobility","","","","","","8985 Tamarack St","Temperance","48182-9200","1-313-845-3501","http://www.ford.com","Ford Motor Company is primarily engaged in the retail sale of new automobiles or new and used automobiles. These establishments frequently maintain repair departments and carry stocks of replacement parts, tires, batteries, and automotive accessories. These establishments also frequently sell pickups and vans at retail.","Branch","FALSE",441110,"New Car Dealers",73,-9303550.2665,5127841.2249],
    [74,"Ford Motor Company","Mobility","","","Rick","Pietron","Product Development Engineer","333 Republic Dr","Allen Park","48101-3650","1-313-337-5502","http://www.ford.com","Ford Motor Company is primarily engaged in the retail sale of new automobiles or new and used automobiles. These establishments frequently maintain repair departments and carry stocks of replacement parts, tires, batteries, and automotive accessories. These establishments also frequently sell pickups and vans at retail.","Branch","FALSE",441110,"New Car Dealers",74,-9261445.0059,5205777.783699997],
    [75,"Ford Motor Company","Mobility","","","Kirk","Yancey","Chairman","20200 Rotunda Dr","Dearborn","48124-3800","1-313-805-6120","http://www.ford.com","Ford Motor Company is primarily engaged in the retail sale of new automobiles or new and used automobiles. These establishments frequently maintain repair departments and carry stocks of replacement parts, tires, batteries, and automotive accessories. These establishments also frequently sell pickups and vans at retail.","Branch","FALSE",441110,"New Car Dealers",75,-9264818.8666,5205004.457699999],
    [76,"Ford Motor Company","Mobility","","","","","","24999 Pennsylvania Rd","Brownstown","48173","1-734-942-6248","http://www.ford.com","Ford Motor Company is primarily engaged in the retail sale of new automobiles or new and used automobiles. These establishments frequently maintain repair departments and carry stocks of replacement parts, tires, batteries, and automotive accessories. These establishments also frequently sell pickups and vans at retail.","Branch","FALSE",441110,"New Car Dealers",76,-9270164.0063,5188438.622000001],
    [77,"Ford Motor Company","Mobility","","","Renee","Baker-Basler","Shipping Receiving Clerk","41873 Ecorse Rd Ste 290","Belleville","48111-5226","1-734-525-8207","http://www.ford.com","Ford Motor Company is primarily engaged in manufacturing or assembling complete passenger automobiles, trucks, commercial cars and buses, and special purpose motor vehicles which are for highway use. This also includes the manufacturing of chassis and passenger car bodies.","Branch","FALSE",336111,"Automobile Manufacturing",77,-9289880.7841,5197616.5200999975],
    [78,"Ford Motor Company","Mobility","","","William","Mikkelsen","Manager, Vehicle Logistics","11871 Middlebelt Rd","Livonia","48150-2310","1-734-523-3000","http://www.ford.com","Ford Motor Company is primarily engaged in the retail sale of new automobiles or new and used automobiles. These establishments frequently maintain repair departments and carry stocks of replacement parts, tires, batteries, and automotive accessories. These establishments also frequently sell pickups and vans at retail.","Branch","FALSE",441110,"New Car Dealers",78,-9276891.8078,5216937.822300002],
    [79,"Ford Motor Company","Mobility","","","Ali","Ahmad","Maintenance Manager","20900 West Rd","Woodhaven","48183-3327","1-734-671-7000","http://www.ford.com","Ford Motor Company is primarily engaged in the retail sale of new automobiles or new and used automobiles. These establishments frequently maintain repair departments and carry stocks of replacement parts, tires, batteries, and automotive accessories. These establishments also frequently sell pickups and vans at retail.","Branch","FALSE",441110,"New Car Dealers",79,-9265821.7536,5182733.854500003],
    [80,"Ford Motor Company","CPS","","","Jennifer","Hurt","Sales & Leasing Manager","330 Town Center Dr Ste 1100","Dearborn","48126-2711","1-313-323-3100","http://www.fordland.com","Ford Motor Land Development Corporation is primarily engaged in the operation of nonresidential buildings.","Subsidiary","TRUE",531120,"Lessors of Nonresidential Buildings (except Miniwarehouses)",80,-9263894.3686,5209102.975599997],
    [81,"Galaxy Software Solutions","Digital Tech","","","Dileep","Tiwari","Owner","5820 N Lilley Rd Ste 8","Canton","48187-3691","1-734-983-9020","http://www.galaxy-soft.com","Galaxy Software Solutions is primarily engaged in developing or modifying computer software and packaging or bundling the software with purchased computer hardware (computers and computer peripheral equipment) to create and market an integrated system for specific application. Establishments in this industry must provide each of the following services: (1) the development or modification of the computer software; (2) the marketing of purchased computer hardware; and (3) involvement in all phases of systems development from design through installation.","Independent","FALSE",541512,"Computer Systems Design Services",81,-9290495.2755,5209868.431900002],
    [82,"General Dynamics ","Defense","","","Thomas","Vettese","Director of Business Development","2909 Waterview Dr","Rochester Hills","48309-4600","1-248-293-2929","http://www.gdmissionsystems.com","General Dynamics Global Imaging Technologies, Inc. is primarily engaged in manufacturing instruments and apparatus that measure an optical property and optically project, measure, or magnify an image, such as binoculars, microscopes, prisms, and lenses. Included are the manufacturing of optical sighting and fire control equipment.","Subsidiary","TRUE",333314,"Optical Instrument and Lens Manufacturing",82,-9261683.0039,5257104.798900001],
    [83,"General Dynamics","Defense","","","Jack","Strachan","Principal Estimator","38500 Mound Rd","Sterling Heights","48310-3200","1-586-825-4000","http://www.gdls.com","A business unit of General Dynamics' Combat Systems division, General Dynamics Land Systems (GDLS) makes tracked and wheeled armored and amphibious combat vehicles for the US military and its allies (for personnel transport, medical evacuation, fire support, anti-tank missions, combat engineering, and reconnaissance). Its big gun is the Abrams main battle tank (MBT). Other products include the Stryker infantry combat vehicle and gun systems, its LAV family of combat and reconnaissance vehicles, mine resistant ambush protected vehicles (MRAPs), the Marines' Expeditionary Fighting Vehicle (EFV), and the FOX Nuclear Biological Chemical Reconnaissance System.","Subsidiary","TRUE",423860,"Transportation Equipment and Supplies (except Motor Vehicle) Merchant Wholesalers",83,-9244446.2954,5247637.6567],
    [84,"General Dynamics","Defense","","","","","","2909 Waterview Dr","Rochester","48309-4600","1-530-271-2500","","General Dynamics Mission Systems, Inc. is primarily engaged in manufacturing instruments and apparatus that measure an optical property and optically project, measure, or magnify an image, such as binoculars, microscopes, prisms, and lenses. Included are the manufacturing of optical sighting and fire control equipment.","Branch","FALSE",333314,"Optical Instrument and Lens Manufacturing",84,-9261683.0039,5257104.798900001],
    [85,"General Motors Company","Mobility","","","Mary","Barra","Chairman of the Board, Chief Executive Officer","300 Renaissance Ctr Ste L1","Detroit","48243-1403","1-313-667-1500","http://www.gm.com","General Motors Co (GM) is an automobile manufacturing company. The company, along with its partners, designs, builds, and markets cars, trucks and automobile parts around the world. GM also provides automotive financing services through its subsidiary, General Motors Financial Company. The company sells cars and trucks to commercial fleet customers, daily rental car companies, leasing companies and governments directly or through a network of dealers. Some of the companys key brands include Chevrolet, Cadillac, Buick, GMC, Holden, Opel, Baojun, Vauxhall, among others. It has operations in North America, Asia Pacific, Middle East and Africa, and South America. GM is headquartered in Detroit, Michigan, the US.The company reported revenues of (US Dollars) US$147,049 million for the fiscal year ended December 2018 (FY2018), an increase of 1% over FY2017. In FY2018, the companys operating margin was 3%, compared to an operating margin of 5.9% in FY2017. The net profit of the company was US$8,014 million in FY2018, compared to a net loss of US$3,864 million in FY2017.The company reported revenues of US$36,060.0 million for the second quarter ended June 2019, an increase of 3.4% over the previous quarter.","Parent","TRUE",336111,"Automobile Manufacturing",85,-9243967.1737,5210531.704000004],
    [86,"General Motors Company","Mobility","","","Kip","Peck","Leader","850 N Glenwood Ave","Pontiac","48340-9301","1-248-431-9552","","General Motors Company is primarily engaged in the retail sale of new automobiles or new and used automobiles. These establishments frequently maintain repair departments and carry stocks of replacement parts, tires, batteries, and automotive accessories. These establishments also frequently sell pickups and vans at retail.","Branch","FALSE",441110,"New Car Dealers",86,-9271244.8803,5260693.597099997],
    [87,"General Motors Company","Mobility","","","Jiweon","Seon","Manager","300 Renaissance Ctr L1","Detroit","48265-0001","1-313-556-5000","","General Motors Holdings Llc is primarily engaged in the retail sale of new automobiles or new and used automobiles. These establishments frequently maintain repair departments and carry stocks of replacement parts, tires, batteries, and automotive accessories. These establishments also frequently sell pickups and vans at retail.","Subsidiary","TRUE",441110,"New Car Dealers",87,-9243967.1737,5210531.704000004],
    [88,"General Motors Company","Mobility","","","Greg","Michnick","Manager, Maintenance","37350 Ecorse Rd","Romulus","48174-1396","1-734-595-5830","http://www.gm.com","General Motors Llc is primarily engaged in providing computer programming services on a contract or fee basis. Establishments of this industry perform a variety of additional services, such as computer software design and analysis; modifications of custom software; and training in the use of custom software.","Branch","FALSE",541511,"Custom Computer Programming Services",88,-9285039.6106,5199345.816],
    [89,"General Motors Company","Mobility","","","Brian","Lynch","Business Unit Manager","G3100 Van Slyke Rd","Flint","48551-0001","1-810-236-1366","http://www.gm.com","General Motors Llc is primarily engaged in the retail sale of new automobiles or new and used automobiles. These establishments frequently maintain repair departments and carry stocks of replacement parts, tires, batteries, and automotive accessories. These establishments also frequently sell pickups and vans at retail.","Branch","FALSE",441110,"New Car Dealers",89,-9318921.4278,5310113.706799999],
    [90,"Genius Solutions","Digital Tech","","","Viparadee","Thanyakarn","President","7177 Miller Dr Ste A","Warren","48092-1699","1-586-751-9080","http://www.geniussolutions.com","Genius Solutions, Inc. is primarily engaged in providing computer programming services on a contract or fee basis. Establishments of this industry perform a variety of additional services, such as computer software design and analysis; modifications of custom software; and training in the use of custom software.","Independent","FALSE",541511,"Custom Computer Programming Services",90,-9243161.1139,5240323.5266999975],
    [91,"Global Automotive Systems","Mobility","","","Tim","O'Leary","Regional / Global Quality Director","1780 Pond Run","Auburn Hills","48326-2752","1-248-299-7500","http://www.duraauto.com","Global Automotive Systems, Llc is primarily engaged in manufacturing motor vehicle parts and accessories, but not engaged in manufacturing complete motor vehicles or passenger car bodies.","Subsidiary","TRUE",336390,"Other Motor Vehicle Parts Manufacturing",91,-9264685.7325,5261407.1338],
    [92,"Grupo Antolin North America,","Mobility","","","Jorge","Espinosa","Chief Executive Officer","1700 Atlantic Blvd","Auburn Hills","48326-1504","1-248-373-1749","http://www.grupoantolin.com","Grupo Antolin North America, Inc. is primarily engaged in manufacturing motor vehicle parts and accessories, but not engaged in manufacturing complete motor vehicles or passenger car bodies.","Subsidiary","TRUE",336390,"Other Motor Vehicle Parts Manufacturing",92,-9268872.1248,5265952.263800003],
    [93,"Health Alliance Plan","CPS","","","Marc","Vanderburgq","Vice President","2850 W Grand Blvd","Detroit","48202-2692","1-313-872-8100","http://www.hap.org","If you happen to need health insurance in Michigan, you might want to visit the HAP. Health Alliance Plan of Michigan (HAP) provides health insurance products and related services to more than 650,000 members. A subsidiary of the Henry Ford Health System, the not-for-profit corporation offers managed care plans (including HMO, PPO, and consumer-directed plans) to individuals and companies throughout its service area, which covers about two dozen Michigan counties. It also offers Medicare Advantage plans and Medicare prescription drug coverage to retirees. In addition, HAP offers disease management, behavioral health, and wellness programs.The company was founded in 1960.","Subsidiary","TRUE",524114,"Direct Health and Medical Insurance Carriers",93,-9248677.7735,5216021.726899996],
    [94,"Home Point Financial Corporation","Fintech","","","Willie","Newman","Ceo And President","2211 Old Earhart Rd Ste 250","Ann Arbor","48105-2963","1-734-256-4445","http://www.homepointfinancial.com","Home Point Financial Corporation is primarily engaged in originating mortgage loans, selling mortgage loans to permanent investors, and servicing these loans. They may also provide real estate construction loans.","Parent","TRUE",522292,"Real Estate Credit",94,-9315700.227,5206869.290399998],
    [95,"Kuka Systems North America","Mobility","","","Larry","Drake","President Ceo","6600 Center Dr","Sterling Heights","48312-2666","1-586-795-2000","http://www.kukaaero.com","Kuka Systems North America Llc is primarily engaged in manufacturing metalworking machinery, not elsewhere classified.","Subsidiary","TRUE",333519,"Rolling Mill and Other Metalworking Machinery Manufacturing",95,-9244171.8891,5245146.8429000005],
    [96,"Kyyba","Digital Tech","","","Thiru","Ganesan","President-Chief Executive Officer","28230 Orchard Lake Rd Ste 130","Farmington","48334-3705","1-248-813-9665","http://www.kyyba.com","Kyyba, Inc. is primarily engaged in providing computer programming services on a contract or fee basis. Establishments of this industry perform a variety of additional services, such as computer software design and analysis; modifications of custom software; and training in the use of custom software.","Parent","TRUE",541511,"Custom Computer Programming Services",96,-9279356.0902,5236687.153800003],
    [97,"Lear Corporation","Mobility","","","Raymond","Scott","President, Chief Executive Officer, Director","21557 Telegraph Rd","Southfield","48033-6817","1-724-248-1500","http://www.lear.com","Lear Corp (Lear) designs, develops, engineer and manufacture seating assemblies, electrical distribution systems and other components for the automotive sector. It supplies seating, electrical distribution systems and electronic modules, as well as related sub-systems, components and software, to the world's major automotive manufacturers.   The company operates through two reportable business segments, Seating and E-Systems.  In FY2018, the companys capital expenditure stood at US$677 million, which was 3.2% of its revenue and grew 13.9% YoY (2018 vs 2017).  The company had over 100 subsidiaries at the end of FY2018. It operates 261 manufacturing, engineering and administrative locations in 39 countries including 85 just-in-time manufacturing facilities, 126 dedicated component manufacturing facilities, 6 sequencing and distribution sites, 36 administrative/technical support facilities and 8 advanced technology centers.","Parent","TRUE",336320,"Motor Vehicle Electrical and Electronic Equipment Manufacturing",97,-9270708.7875,5228696.383000001],
    [98,"Little Caesar Enterprises","CPS","","","David","Scrivano","President and CEO","2211 Woodward Ave","Detroit","48201-3400","1-313-983-6000","http://www.littlecaesars.com","I came, I saw, I bought a pizza. Little Caesar Enterprises operates and franchises more than 2,500 Little Caesars carryout pizza restaurants throughout the US and in about ten other countries. The chain offers a variety of original and deep-dish pizzas along with cheese bread, salads, and sandwiches. While some stores are stand-alone units, many Little Caesars locations can be found in strip malls and other high-traffic areas; the units typically do not offer dine-in seating. About 80% of the chain's outlets are run by franchisees. Little Caesars was founded in 1959 by the Ilitch family, who also control a sports and entertainment empire through Ilitch Holdings.","Subsidiary","TRUE",722513,"Limited-Service Restaurants",98,-9245384.6084,5211793.486100003],
    [99,"Marvel Technologies","Digital Tech","","","Balaji","Raj","R.Balaji. Successfactors Partner","42400 Grand River Ave Ste 207","Novi","48375-2573","1-248-946-4023","http://www.marveltechus.com","Marvel Technologies, Inc. is primarily engaged in supplying computer related services, not elsewhere classified. Computer consultants operating on a contract or fee basis are classified in this industry.","Independent","FALSE",541512,"Computer Systems Design Services",99,-9291338.7421,5233019.881999999],
    [100,"Miracle Software Systems","Digital Tech","","","Murali","Adapa","Chief Executive Officer","45625 Grand River Ave","Novi","48374-1309","1-248-233-1100","http://www.miraclesoft.com","For businesses who feel that it might take divine intervention to solve their IT problems, Miracle Software Systems offers a more down-to-Earth alternative. The company provides IT services such as enterprise application development and integration, consulting, network design, legacy systems migration, and training. The service-oriented architecture (SOA) specialist primarily installs, customizes, and supports software from IBM, but it also offers products from Oracle, and SAP, among others. Customers have included businesses in the health care (Pfizer), insurance (Premera Blue Cross), finance, logistics (Menlo Worldwide), manufacturing (John Deere), and retail (Target) industries.","Parent","TRUE",541511,"Custom Computer Programming Services",100,-9294936.0317,5233929.623300001],
    [101,"Olympia Entertainment","CPS","","","Tom","Wilson","President & Ceo","2211 Woodward Ave","Detroit","48201-3467","1-313-471-3200","http://www.olympiaentertainment.com","Olympia Entertainment, Inc. is primarily engaged in providing live theatrical presentations, such as road companies and summer theaters. This industry also includes services allied with theatrical presentations, such as casting agencies; booking agencies for plays, artists, and concerts; scenery, lighting, and other equipment services; and theatrical ticket agencies. Also included in this industry are producers of live and taped radio programs and commercials and producers of live television programs.","Subsidiary","TRUE",711410,"Agents and Managers for Artists, Athletes, Entertainers, and Other Public Figures",101,-9245384.6084,5211793.486100003],
    [102,"Plante & Moran","Fintech","","","Marty","West","President","3000 Town Ctr Ste 400","Southfield","48075-1102","1-248-352-2500","http://www.plantemoran.com","Plante & Moran is planted firmly in the upper Midwest. With 20 offices in Michigan, Ohio, and Illinois, the firm provides a variety of accounting and management consulting services. Its offerings include tax preparation, employee benefits consulting, technology assessment and planning, and wealth management. The firm has expertise in several industries ranging from retail and dealerships to health care, financial services, and manufacturing. It also serves the not-for-profit and public sectors. Plante & Moran, which is affiliated with international accounting alliance Praxity, also has offices in Mexico, India, and China. The privately-owned firm was founded by Elorion Plante in 1924.","Subsidiary","TRUE",541211,"Offices of Certified Public Accountants",102,-9266930.8276,5232854.308499999],
    [103,"Revspring","Digital Tech","","","Scott","MacKenzie","CEO","38705 7 Mile Rd Ste 450","Livonia","48152-3979","1-248-567-7300","http://www.revspringinc.com","Revspring, Inc. is primarily engaged in providing computer programming services on a contract or fee basis. Establishments of this industry perform a variety of additional services, such as computer software design and analysis; modifications of custom software; and training in the use of custom software.","Subsidiary","TRUE",541511,"Custom Computer Programming Services",103,-9287305.1866,5224673.140299998],
    [104,"Strategic Staffing Solutions","CPS","","","Allen","Coleman","Evp, Coo & Part Owner","645 Griswold St Ste 2900","Detroit","48226-4206","1-313-596-6900","http://www.strategicstaff.com","Strategic Staffing Solutions, L.C. is primarily engaged in providing employment services, except theatrical employment agencies and motion picture casting bureaus. Establishments classified here may assist either employers or those seeking employment.","Parent","TRUE",561311,"Employment Placement Agencies",104,-9244767.1712,5210592.266099997],
    [105,"Systems Technology Group","Digital Tech","","","Anup","Popat","Chief Executive Officer","3001 W Big Beaver Rd Ste 500","Troy","48084-3106","1-248-643-9010","http://www.stgit.com","Systems Technology Group, Inc is primarily engaged in providing computer programming services on a contract or fee basis. Establishments of this industry perform a variety of additional services, such as computer software design and analysis; modifications of custom software; and training in the use of custom software.","Independent","FALSE",541511,"Custom Computer Programming Services",105,-9260490.8867,5245221.0502],
    [106,"TCF Financial Corporation","Fintech","","","Thomas","Shafer","Chief Operating Officer, President And Chief Operating Officer Of Tcf Bank","333 W Fort St Ste 1800","Detroit","48226-3186","1-800-867-9757","http://www.chemicalbank.com","TCF Financial Corp (TCF) offers commercial banking services to individuals and corporates through Chemical Bank. As of December 31, 2019, it operated through 520 banking offices, 121 supermarket branches, and three campus branches and over 1,099 ATMs. It had assets of US$46.7 billion, net loans of US$32 billion, and deposits of US$34.5 billion.  TCF operates under three business segments: Consumer Banking, Commercial Banking, and Enterprise Services.","Parent","TRUE",522110,"Commercial Banking",106,-9245076.3366,5210473.8693],
    [107,"Technosoft Corporation","Digital Tech","","","Srinivas","Kamath","Chief Executive Officer","1 Towne Sq Ste 600","Southfield","48076-3710","1-248-603-2600","http://www.technosoftcorp.com","Technosoft Corporation is primarily engaged in supplying computer related services, not elsewhere classified. Computer consultants operating on a contract or fee basis are classified in this industry.","Parent","TRUE",541512,"Computer Systems Design Services",107,-9267701.1602,5233688.556400001],
    [108,"The Walbridge Group","CPS","","","Stout","Robert","Assistant Superintendent","777 Woodward Ave Ste 300","Detroit","48226-3582","1-313-963-8000","http://www.walbridge.com","The Walbridge Group Inc is a general contractor primarily engaged in the construction (including new work, additions, alterations, remodeling, and repair) of nonresidential buildings, other than industrial buildings and warehouses. Included are nonresidential buildings, such as commercial, institutional, religious, and amusement and recreational buildings.","Parent","TRUE",236220,"Commercial and Institutional Building Construction",108,-9244801.1789,5210723.543899998],
    [109,"Trillium Teamologies","Digital Tech","","","Sue","Rodzos","Owner","219 S Main St Ste 300","Royal Oak","48067-2643","1-248-584-2080","http://www.trilliumteam.com","Trillium Teamologies, Inc. is primarily engaged in supplying computer related services, not elsewhere classified. Computer consultants operating on a contract or fee basis are classified in this industry.","Independent","FALSE",541512,"Computer Systems Design Services",109,-9255528.041,5234423.245700002],
    [110,"United Shore Financial Services","Fintech","","","Mat","Ishbia","President / Chief Executive Officer","585 South Blvd E","Pontiac","48341-3163","1-855-888-8737","http://www.unitedshore.com","United Shore Financial Services, Llc is primarily engaged in originating mortgage loans, selling mortgage loans to permanent investors, and servicing these loans. They may also provide real estate construction loans.","Parent","TRUE",522292,"Real Estate Credit",110,-9269103.2697,5254290.226400003],
    [111,"V2soft","Digital Tech","","","Ganesh","Krishnamurthy","Owner","300 Enterprise Ct","Bloomfield Hills","48302-0376","1-248-904-1702","http://www.v2soft.com","V2Soft Inc. is primarily engaged in supplying computer related services, not elsewhere classified. Computer consultants operating on a contract or fee basis are classified in this industry.","Parent","TRUE",541512,"Computer Systems Design Services",111,-9271096.0672,5252544.7311],
    [112,"Valeo Switches & Detection Systems","Mobility","","","","","","150 Stephenson Hwy","Troy","48083-1116","1-248-619-8300","http://www.valeo.com","Valeo Switches & Detection Systems, Inc. is primarily engaged in manufacturing motor vehicle parts and accessories, but not engaged in manufacturing complete motor vehicles or passenger car bodies.","Subsidiary","TRUE",336390,"Other Motor Vehicle Parts Manufacturing",112,-9252704.4243,5241416.913900003],
    [113,"Visteon Corporation","Mobility","","","Sachin","Lawande","President, Chief Executive Officer, Director","1 Village Center Dr","Van Buren Twp","48111-5711","1-248-702-1203","http://www.visteon.com","Visteon Corp (Visteon) is an automotive supplier that designs, manufactures and engineers innovative cockpit electronics and connected car solutions for vehicle manufacturing company. Its product portfolio includes infotainment systems, audio systems, information displays, instrument clusters, head up displays, and telematics solutions. The company also offers a broad range of infotainment solutions that include display audio entry; and an automotive-grade, integrated domain controller approach. The company supplies its products to original equipment manufacturers (OEMs) including Ford, Mazda, General Motors, Jaguar/Land Rover, Renault/Nissan, Honda, BMW, Volkswagen, and Daimler. It operates through manufacturing, sales and service facilities in North America, South America, Asia and Europe. Visteon is headquartered in Van Buren Township, Michigan, the US.The company reported revenues of (US Dollars) US$2,984 million for the fiscal year ended December 2018 (FY2018), a decrease of 5.1% over FY2017. In FY2018, the companys operating margin was 7%, compared to an operating margin of 7.4% in FY2017. In FY2018, the company recorded a net margin of 5.5%, compared to a net margin of 5.6% in FY2017.The company reported revenues of US$733.0 million for the second quarter ended June 2019, a decrease of 0.5% over the previous quarter.","Parent","TRUE",336390,"Other Motor Vehicle Parts Manufacturing",113,-9286885.4081,5197459.832900003],
    [114,"Walbridge Aldinger","CPS","","","John","Rakolta","Chb-Chief Executive Officer","777 Woodward Ave Ste 300","Detroit","48226-3582","1-313-963-8000","http://www.walbridge.com","The Motor City has been home to Motown, Madonna, and one Walbridge Aldinger. The US construction firm provides construction management, design/build, general contracting, pre-construction, and program management services for industrial, commercial, and government facilities. It's a major builder of the nation's airports and steel and nonferrous metal plants. It also offers specialty contracting services in the areas of structural concrete, equipment installation, and facilities management. Although most of its work is done in the US, it also has operations and projects in Brazil, Mexico, the Middle East, and South America. Founded in 1916, the business is privately owned and part of The Walbridge Group.","Subsidiary","TRUE",236220,"Commercial and Institutional Building Construction",114,-9244801.1789,5210723.543899998],
    [115,"Yazaki North America","Mobility","","","Dawn","Myers","Principal CAD Designer","6801 N Haggerty Rd","Canton","48187-3538","1-734-983-1000","http://www.yazaki-na.com","Your ability to interact with your car's computer system might be predetermined by its YNA. Yazaki North America (YNA) is a leading supplier of wiring harnesses and other vehicle power and data components for the automotive industry. A subsidiary of diversified Japanese manufacturer Yazaki Corporation, Yazaki North America also offers passive and active sensors; controls for power distribution, terminals, and connections; vehicle instrumentation; and products for hybrid and electric vehicles. YNA has about two dozen facilities throughout North America.","Subsidiary","TRUE",423120,"Motor Vehicle Supplies and New Parts Merchant Wholesalers",115,-9289405.4507,5210965.0801]
]}