home / kassab_analytics

Menu
  • Search all tables

Chain Steps

Ordered steps within each motion chain

Data license: Public court records

4 rows where chain_id = "MSJ-1"

This data as json, CSV (advanced)

Suggested facets: date (date)

party 3

  • Kassab 2
  • Court 1
  • Pohl 1

chain_id 1

  • Kassab 1st Traditional MSJ · 4 ✖
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,2 Kassab 1st Traditional MSJ MSJ-1 2 17 17 2021-07-26 Pohl response Pohl
MSJ-1,3 Kassab 1st Traditional MSJ MSJ-1 3 18 18 2021-08-02 Kassab reply Kassab
MSJ-1,4 Kassab 1st Traditional MSJ MSJ-1 4 19 19 2021-08-03 ORDER: MSJ DENIED Court

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.922ms · Data license: Public court records