home / kassab_analytics

Menu
  • Search all tables

Chain Steps

Ordered steps within each motion chain

Data license: Public court records

2 rows where chain_id = "MSJ-1" and party = "Kassab"

This data as json, CSV (advanced)

Suggested facets: date (date)

party 1

  • Kassab · 2 ✖

chain_id 1

  • Kassab 1st Traditional MSJ · 2 ✖
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
MSJ-1,3 Kassab 1st Traditional MSJ MSJ-1 3 18 18 2021-08-02 Kassab reply 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.182ms · Data license: Public court records