home / kassab_analytics

Menu
  • Search all tables

Chain Steps

Ordered steps within each motion chain

Data license: Public court records

3 rows where chain_id = "RTP-2"

This data as json, CSV (advanced)

Suggested facets: date (date)

party 3

  • Court 1
  • Kassab 1
  • Pohl 1

chain_id 1

  • RTP: Favre/Precision Designation · 3 ✖
Link chain_id step_number filing_id date description party
RTP-2,1 RTP: Favre/Precision Designation RTP-2 1 47 47 2022-11-30 Pohl objection to supp. RTP Pohl
RTP-2,2 RTP: Favre/Precision Designation RTP-2 2 51 51 2023-03-02 Mtn to designate Favre/Precision as RTP Kassab
RTP-2,3 RTP: Favre/Precision Designation RTP-2 3 56 56 2023-08-14 ORDER: RTP GRANTED 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 6.326ms · Data license: Public court records