Trump Lawsuits: trump-lawsuits.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
6 rows where issue = "Sanctuary cities" sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: plaintiff, currentLocation, judge, nature, dateFiled (date)
Link | rowid ▲ | docketNumber | dateFiled | caseName | plaintiff | defendant | currentLocation | previousLocation | jurisdiction | judge | nature | TrumpCategory | capacity | type | issue | docketOrig | status |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
47 | 47 | 1:18-cv-06471 | 2018-07-18 | State of New York v. U.S. Department of Justice | State of New York et al | U.S. Department of Justice, et al | District Court, Southern District of New York | 1 | Edgardo Ramos | 899 | 3 | 2 | 2 | Sanctuary cities | 1 | ||
46 | 46 | 2:18-cv-07347 | 2018-08-22 | City of Los Angeles v. Jefferson Sessions (II) | City of Los Angeles | Jefferson B. Sessions III; Laura Rogers; United States Department of Justice | District Court, California Central District | 1 | Manuel Lawrence Real | 890 | 3 | 2 | 2 | Sanctuary cities | 1 | ||
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 |
44 | 44 | 1:18-cv-06859 | 2018-10-12 | City of Chicago v. Sessions (II) | City of Chicago | Jefferson B. Sessions III | District Court, Northern District of Illinois | 1 | Elaine E. Bucklo; Maria Valdez | 899 | 3 | 2 | 2 | Sanctuary cities | 1 | ||
43 | 43 | 18-2648 | 2017-08-30 | City of Philadelphia v. Attorney General United States | City of Philadelphia | Attorney General United States of America | 3rd Circuit Court of Appeals | District Court, Pennsylvania Eastern District | 1 | Thomas Ambro; Anthony Scirica; Midge Rendell; Michael Baylson | 899 | 3 | 2 | 2 | Sanctuary cities | 2:17-cv-03894 | 1 |
42 | 42 | 1:18-cv-04853 | 2018-07-16 | City of Evanston v. Sessions | City of Evanston | Jefferson B. Sessions, et al | District Court, Northern District of Illinois | Harry Leinenweber | 899 | 3 | 2 | 2 | Sanctuary cities | 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 );