﻿_id	Company_Name	Dutch_Category	Tech_Giants_Logos	Logo_Link	First_Name	Last_Name	Title	Address_Line_1	City	Postal_Code	Phone	URL	Business_Description	Entity_Type	Is_Headquarters	NAICS_2017_Code	NAICS_2017_Description	ObjectId	lon	lat
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
