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 "dateFiled" is on date 2017-09-29 sorted by issue
This data as json, copyable, CSV (advanced)
Link | rowid | docketNumber | dateFiled | caseName | plaintiff | defendant | currentLocation | previousLocation | jurisdiction | judge | nature | TrumpCategory | capacity | type | issue ▼ | docketOrig | status |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
45 | 45 | 18-56292 | 2017-09-29 | City of Los Angeles v. Jefferson Sessions | City of Los Angeles | Jefferson B. Sessions III et al | 9th Circuit Court of Appeals | District Court, Central District of California | 1 | Manuel Lawrence Real | 890 | 3 | 2 | 2 | Sanctuary cities | 2:17-cv-07215 | 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 );