filing_group

case_number

A case in the group. Foreign key to filing.case_number; primary key in this table (each case belongs to at most one group).

created_at

Scrape timestamp.

root_case_number

The primary case in a group of consolidated cases.

updated_at

Last-update timestamp.

506,076 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Next page

CREATE TABLE filing_group(root_case_number TEXT,
                        case_number TEXT NOT NULL PRIMARY KEY,
		        created_at timestamp default CURRENT_TIMESTAMP,
                        updated_at timestamp default CURRENT_TIMESTAMP,
			FOREIGN KEY(case_number) REFERENCES filing(case_number));