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 = "RTP-1"

This data as json, CSV (advanced)

Suggested facets: date (date)

party 2

  • Kassab 3
  • Pohl 1

chain_id 1

  • RTP Designations (Initial) · 4 ✖
Link chain_id step_number filing_id date description party
RTP-1,1 RTP Designations (Initial) RTP-1 1 26 26 2022-05-13 Motion to designate RTP Kassab
RTP-1,2 RTP Designations (Initial) RTP-1 2 28 28 2022-05-31 Pohl objection to RTP Pohl
RTP-1,3 RTP Designations (Initial) RTP-1 3 44 44 2022-11-15 1st Supp. RTP motion Kassab
RTP-1,4 RTP Designations (Initial) RTP-1 4 45 45 2022-11-22 2nd Supp. RTP motion 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 6.665ms · Data license: Public court records