entities: 4341
This data as json
| entity_id | canonical_name | name_normalized | display_name | entity_type | ein | cik | uei | lei | ticker | fec_committee_id | duns | sic_code | naics_code | ntee_code | state_of_incorporation | primary_state | country | status | merged_into_entity_id | source_provenance | first_seen_date | last_seen_date | created_at | updated_at | notes | dd_id | predecessor_names | primary_industry | industry_codes | naics_description | psc_code |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4341 | ADVANCED DRAINAGE SYSTEMS, INC. | ADVANCED DRAINAGE SYSTEMS | public_company | 510105665 | 1604028 | MZVYG1V9DJC8 | 6QQTOZ5MF5DHM7K92I60 | WMS | 3086 | DE | DE | US | active | sec,gleif | 2026-04-19 18:28:09 | 2026-04-19 18:28:09 | 2026-04-19 18:28:09 | 2026-04-19 18:28:38 | DD-E-4341 | chemicals | ["chemicals"] |