Trump Lawsuits: trump-lawsuits.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
1 row where previousLocation = "District of Arizona" sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: dateFiled (date)
Link | rowid ▲ | docketNumber | dateFiled | caseName | plaintiff | defendant | currentLocation | previousLocation | jurisdiction | judge | nature | TrumpCategory | capacity | type | issue | docketOrig | status |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18 | 18 | 17-10448 | 2016-08-19 | United States v. Joseph Arpaio | United States of America | Joseph Arpaio | 9th Circuit Court of Appeals | District of Arizona | 1 | Susan Bolton | 2 | 5 | 1 | Pardons | 2:16-cr-01012 | 1 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "trump-lawsuits/trump-lawsuits" ( "docketNumber" TEXT, "dateFiled" TEXT, "caseName" TEXT, "plaintiff" TEXT, "defendant" TEXT, "currentLocation" TEXT, "previousLocation" TEXT, "jurisdiction" INTEGER, "judge" TEXT, "nature" INTEGER, "TrumpCategory" INTEGER, "capacity" INTEGER, "type" INTEGER, "issue" TEXT, "docketOrig" TEXT, "status" INTEGER );