contact
- city
- City.
- contact_type
- Role of the contact — "name_and_mailing_address" (primary contact for the filing) or "any_other_name_or_address_necessary_to_verify_report" (alternate address).
- ein
- Employer Identification Number, when reported.
- name
- Contact person's name.
- organization
- Organization the contact is associated with.
- po_box,_bldg,_room_no,_if_any
- P.O. box, building, or room number, when applicable.
- rptId
- Foreign key to filing.rptId.
- state
- State.
- street
- Street address.
- title
- Contact person's title.
- zip_code
- ZIP code.
8,516 rows
Suggested facets: contact_type
| city | ein | name | organization | po_box,_bldg,_room_no,_if_any | state | street | title | zip_code | rptId | contact_type |
|---|---|---|---|---|---|---|---|---|---|---|
| Clermont | John Coskey | Coskey Consulting | FL | 12621 Street:Bay Breeze Ct | Consultant | 34711 | 947385 | name_and_mailing_address | ||
| 947385 | any_other_name_or_address_necessary_to_verify_report | |||||||||
| Willoughby | 93-1477487 | Thomas Allen | North Eastern Ohio Group LLC | 4958 | OH | campbell rd | President | 44094 | 946937 | name_and_mailing_address |
| Willoughby | Daniel Scruggs | North Eastern Ohio Group LLC | 4958 | OH | Cambell rd | Treasurer | 44094 | 946937 | any_other_name_or_address_necessary_to_verify_report | |
| Boynton Beach | 99-5027928 | Jose Caraballo | Ethical Labor Solution | FL | 145 South Palm Drive | Consultant | 33435 | 945178 | name_and_mailing_address | |
| 945178 | any_other_name_or_address_necessary_to_verify_report | |||||||||
| Lomita | Oscar Wilmington | Oscar Wilmington | Box 115 | CA | 2017 Lomita Blvd | Self | 90717 | 944891 | name_and_mailing_address | |
| 944891 | any_other_name_or_address_necessary_to_verify_report | |||||||||
| Vicksburg | Michael D Willams | Michael Williams | MS | 4250 highway 27 | Self | 39180 | 944151 | name_and_mailing_address | ||
| Vicksburg | Michael D Williams | Michael Williams | MS | 4250 highway 27 | Self | 39180 | 944151 | any_other_name_or_address_necessary_to_verify_report | ||
| Gloster | Jerry W Norwood | Jerry W Norwood | MS | 163 liberty rd | self | 39638 | 944147 | name_and_mailing_address | ||
| Gloster | Jerry W Norwood | N/A | MS | 163 liberty rd | Self | 39638 | 944147 | any_other_name_or_address_necessary_to_verify_report | ||
| Altamonte | Ichana A Destin | Bridge Labor Solutions | FL | 931 N State RD 434 1021-335 | Bridge Labor Solutions | 32714 | 943814 | name_and_mailing_address | ||
| 943814 | any_other_name_or_address_necessary_to_verify_report | |||||||||
| Lomita | Oscar Wilmington | Oscar Wilmington | Box 115 | CA | 2017 Lomita Blvd | Self | 90717 | 945156 | name_and_mailing_address | |
| 945156 | any_other_name_or_address_necessary_to_verify_report | |||||||||
| West Melbourne | Kelly Knisel | Kelly Knisel | FL | 1453 Eden Ln | Ms. | 32905 | 946203 | name_and_mailing_address | ||
| 946203 | any_other_name_or_address_necessary_to_verify_report | |||||||||
| Columbus | William A Wheeler | William P Wheeler | OH | 7720 Rivers Edge Drive | Consultant | 43235 - 1361 | 943807 | name_and_mailing_address | ||
| 943807 | any_other_name_or_address_necessary_to_verify_report | |||||||||
| San Antonio | 41-3317631 | Shirlyce Ammons | SA Employee Relations Strategies LLC | TX | 17806 Rockside Drive | Consultant | 78258 - 1601 | 942853 | name_and_mailing_address | |
| 942853 | any_other_name_or_address_necessary_to_verify_report | |||||||||
| Austin | 35-2957431 | Ricardo Pasalagua | LABOR RELATIONS SOLUTIONS LLC | TX | 5900 BALCONES DR STE 100 | CEO | 78731 - 4298 | 942846 | name_and_mailing_address | |
| 942846 | any_other_name_or_address_necessary_to_verify_report | |||||||||
| Bloomfield Hills | Mariam A Jabre | LNM Serivces | MI | 6755 Telegraph Rd. | Consultant | 48301 | 942755 | name_and_mailing_address | ||
| 942755 | any_other_name_or_address_necessary_to_verify_report | |||||||||
| Williamvile | 87-2248448 | Otis Arterberry | Oamalgam Studios | NY | 88 Autumnview Road | Mr | 14221 | 942306 | name_and_mailing_address | |
| 942306 | any_other_name_or_address_necessary_to_verify_report | |||||||||
| Detroit | Shaquetta A Starks | The Starks Group, Inc | MI | 609 Lawrence Street | Consultant | 48202 | 942207 | name_and_mailing_address | ||
| 942207 | any_other_name_or_address_necessary_to_verify_report | |||||||||
| Wilmington | Kevin Cruz Diaz | Kevin Cruz Diaz | DE | 1218 Peach Street | Mr | 19801 | 942132 | name_and_mailing_address | ||
| 942132 | any_other_name_or_address_necessary_to_verify_report | |||||||||
| Hueytown | LaBeatrix Tatum | BTatum Labor Consulting | AL | 3405 Ashwood Road | Owner | 35023 | 942204 | name_and_mailing_address | ||
| 942204 | any_other_name_or_address_necessary_to_verify_report | |||||||||
| Wilmington | Kevin Cruz Diaz | Kevin Cruz Diaz | DE | 1218 Peach Street | Mr | 19801 | 942133 | name_and_mailing_address | ||
| 942133 | any_other_name_or_address_necessary_to_verify_report | |||||||||
| Williamvile | 87-2248448 | Otis Arterberry | Oamalgam Studios | NY | 88 Autumnview Road | Mr | 14221 | 942308 | name_and_mailing_address | |
| 942308 | any_other_name_or_address_necessary_to_verify_report | |||||||||
| Williamvile | Otis Arterberry | Oamalgam Studios | NY | 88 Autumnview Road | Mr | 14221 | 942310 | name_and_mailing_address | ||
| 942310 | any_other_name_or_address_necessary_to_verify_report | |||||||||
| Williamvile | Otis Arterberry | Oamalgam Studios | NY | 88 Autumnview Road | Mr | 14221 | 942309 | name_and_mailing_address | ||
| 942309 | any_other_name_or_address_necessary_to_verify_report | |||||||||
| San Antonio | 41-3317631 | Shirlyce Ammons | SA Employee Relations Strategies LLC | TX | 17806 Rockside Drive | Consultant | 78258 - 1601 | 942858 | name_and_mailing_address | |
| 942858 | any_other_name_or_address_necessary_to_verify_report | |||||||||
| Henderson | Efrain Romero Romero | Roman Services | NV | 1135 Jesse Harbor Ave | Consultant | 89014 | 943811 | name_and_mailing_address | ||
| 943811 | any_other_name_or_address_necessary_to_verify_report | |||||||||
| Boynton Beach | 99-5027928 | Jose Caraballo | Ethical Labor Solution | FL | 145 South Palm Drive | Consultant | 33435 | 945175 | name_and_mailing_address | |
| 945175 | any_other_name_or_address_necessary_to_verify_report | |||||||||
| Clermont | John Coskey | Coskey Consulting | FL | 12621 Street:Bay Breeze Ct | Consultant | 34711 | 947388 | name_and_mailing_address | ||
| 947388 | any_other_name_or_address_necessary_to_verify_report | |||||||||
| Clermont | John Coskey | Coskey Consulting | FL | 12621 Street:Bay Breeze Ct | Consultant | 34711 | 947390 | name_and_mailing_address | ||
| 947390 | any_other_name_or_address_necessary_to_verify_report | |||||||||
| Wilmington | Alec Baulch | Direct Insights Consulting | NC | 912 Cicada Court | Mr | 28403 | 942014 | name_and_mailing_address | ||
| 942014 | any_other_name_or_address_necessary_to_verify_report | |||||||||
| Plano | 83-2865553 | Tenaya A Wade | Total Healing Counseling and Wellness Center | TX | 400 Chisholm Place | Consultant | 75075 | 944472 | name_and_mailing_address | |
| 944472 | any_other_name_or_address_necessary_to_verify_report | |||||||||
| Plano | 83-2865553 | Tenaya Wade | Total Healing Counseling and Wellness Center | suite 107 | TX | 400 Chisholm Place | Consultant | 75075 | 942350 | name_and_mailing_address |
| 942350 | any_other_name_or_address_necessary_to_verify_report | |||||||||
| Tampa | 99-1852665 | Dario Morillo | Hungry Lion Consulting Inc | Unit 8 | FL | 1801 N Morgan St | Consultant | 33602 | 941980 | name_and_mailing_address |
| 941980 | any_other_name_or_address_necessary_to_verify_report | |||||||||
| Glen Burnie | 33-2285251 | Wenzile T Dludlu | Arcadia Axis Consulting LLC | MD | 640 Hallmark Drive | Mrs | 21061 | 941925 | name_and_mailing_address | |
| 941925 | any_other_name_or_address_necessary_to_verify_report | |||||||||
| Bloomfield | SP Jamal Drummond | SP Drummond | NJ | 66 Ella St | Consultant | 07003 | 941900 | name_and_mailing_address | ||
| 941900 | any_other_name_or_address_necessary_to_verify_report | |||||||||
| ORLAND HILLS | 38-4264197 | Rabah Zegar | Posh Properties | IL | 9029 Robin Ct | Mr | 60487 - 4695 | 941622 | name_and_mailing_address | |
| 941622 | any_other_name_or_address_necessary_to_verify_report | |||||||||
| Ligonier | 33-1988490 | Ronal E Campos Porras | El Nomada Consulting LLC | PA | 782 Darlington Road | Consultant | 15658 | 941542 | name_and_mailing_address | |
| 941542 | any_other_name_or_address_necessary_to_verify_report | |||||||||
| Pleasant View | Devin Phillips | Devin Phillips | TN | 422 Manor Row Pleasant View | Mr. | 37146 | 940610 | name_and_mailing_address | ||
| 940610 | any_other_name_or_address_necessary_to_verify_report | |||||||||
| Las Vegas | 33-2091323 | Abraham Flores Jr. | AFJ Ventures Inc. | NV | 4375 Tallow Falls Ave | President | 89141 | 940566 | name_and_mailing_address | |
| 940566 | any_other_name_or_address_necessary_to_verify_report | |||||||||
| Katy | 41-4618500 | Arthur Tanner | Arthur Tanner Interests LLC | TX | 750 W Grand Pkwy | President | 77494 | 942480 | name_and_mailing_address | |
| 942480 | any_other_name_or_address_necessary_to_verify_report | |||||||||
| Grapevine | 87-1988577 | Gary Harrison-Ducros | HDC, LLC | TX | 4185 Hallmont Drive | Consultant | 76051 | 940796 | name_and_mailing_address | |
| 940796 | any_other_name_or_address_necessary_to_verify_report | |||||||||
| Grayslake | Michael Caserta | Self for GRCA | IL | 75 Commerce Dr | Educator | 60030 | 936907 | name_and_mailing_address | ||
| 936907 | any_other_name_or_address_necessary_to_verify_report | |||||||||
| McMinnville | 99-3889533 | Ronald Talbert | TCG Consulting, LLC | TN | 1883 Higginbotham Road | Owner | 37110 | 934447 | name_and_mailing_address | |
| 934447 | any_other_name_or_address_necessary_to_verify_report | |||||||||
| San Diego | Annette Alvarez | Annette Alvarez | 206 | CA | 1181 25th St. | Labor Relations | 92154 | 943809 | name_and_mailing_address | |
| 943809 | any_other_name_or_address_necessary_to_verify_report | |||||||||
| Innisfil | Jonathan Hasmatali | Jonathan Hasmatali | 00 | 1824 Saint Johns Road | Consultant | L9S 1 - T4 | 929685 | name_and_mailing_address | ||
| 929685 | any_other_name_or_address_necessary_to_verify_report | |||||||||
| Farmington | kevin a pena | San Juan Regional Medical Center | NM | 801 W Maple St | consultant | 87401 | 943904 | name_and_mailing_address | ||
| 943904 | any_other_name_or_address_necessary_to_verify_report | |||||||||
| Innisfil | Jonathan Hasmatali | Jonathan Hasmatali | 00 | 1824 Saint Johns Road | Consultant | L9S 1 - T4 | 941859 | name_and_mailing_address | ||
| 941859 | any_other_name_or_address_necessary_to_verify_report | |||||||||
| San Diego | Annette Alvarez | Annette Alvarez | 206 | CA | 1181 25th St. | Labor Relations | 92154 | 943810 | name_and_mailing_address | |
| 943810 | any_other_name_or_address_necessary_to_verify_report | |||||||||
| McMinnville | Ronald Talbert | TCG Consulting, LLC | TN | 1883 Higginbotham Road | Owner | 37110 | 938532 | name_and_mailing_address | ||
| 938532 | any_other_name_or_address_necessary_to_verify_report | |||||||||
| Las Vegas | 33-2091323 | Abraham Flores Jr. | AFJ Ventures Inc. | NV | 4375 Tallow Falls Ave | President | 89141 | 940565 | name_and_mailing_address | |
| 940565 | any_other_name_or_address_necessary_to_verify_report | |||||||||
| Las Vegas | 33-2091323 | Abraham Flores Jr. | AFJ Ventures Inc. | NV | 4375 Tallow Falls Ave | President | 89141 | 945710 | name_and_mailing_address | |
| 945710 | any_other_name_or_address_necessary_to_verify_report | |||||||||
| Ligonier | 33-1988490 | Ronal E Campos Porras | El Nomada Consulting LLC | PA | 782 Darlington Road | Consultant | 15658 | 941544 | name_and_mailing_address | |
| 941544 | any_other_name_or_address_necessary_to_verify_report | |||||||||
| Ligonier | Ronal E Campos Porras | El Nomada Consulting LLC | PA | 782 Darlington Road | Consultant | 15658 | 941601 | name_and_mailing_address | ||
| 941601 | any_other_name_or_address_necessary_to_verify_report |
Table schema
CREATE TABLE contact(city VARCHAR, ein VARCHAR, "name" VARCHAR, organization VARCHAR, "po_box,_bldg,_room_no,_if_any" VARCHAR, state VARCHAR, street VARCHAR, title VARCHAR, zip_code VARCHAR, rptId BIGINT, contact_type VARCHAR, FOREIGN KEY (rptId) REFERENCES filing(rptId));