home / kassab_analytics

Menu
  • Search all tables

Chain Steps

Ordered steps within each motion chain

Data license: Public court records

1 row where chain_id = "MSJ-1", filing_id = 16 and party = "Kassab"

This data as json, CSV (advanced)

Suggested facets: date (date)

party 1

  • Kassab · 1 ✖

chain_id 1

  • Kassab 1st Traditional MSJ · 1 ✖
Link chain_id step_number filing_id date description party
MSJ-1,1 Kassab 1st Traditional MSJ MSJ-1 1 16 16 2021-06-08 Kassab Traditional MSJ Kassab

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE chain_steps (
    chain_id TEXT REFERENCES motion_chains(chain_id),
    step_number INTEGER,
    filing_id INTEGER REFERENCES filings(filing_id),
    date TEXT,
    description TEXT,
    party TEXT,
    PRIMARY KEY (chain_id, step_number)
);
Powered by Datasette · Queries took 7.534ms · Data license: Public court records