Corporations and Other Entities: All Filings - Constituent

This data contains information solely on merger or consolidation constituents that did not survive the merger or consolidation. Each line contains the Department of State ID number, Filing ID, Date Filed (of the certificate of merger or consolidation), Constituent Indicator, Entity Name, Effective Date of the merger or consolidation and the indicator of the entity type.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"ny-gov/corporations-and-other-entities-all-filings-dnbf-xifz\".\"corporations_and_other_entities_all_filings\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.