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-08 sorted by defendant
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30 | 30 | 18-587 | 2017-09-08 | Regents of the University of California v. Department of Homeland Security | Janet Napolitano; UC Regents | Association of California School Administrators; Former Federal Immigration and Homeland Security Officials; Kirstjen Nielson; San Diego Unified School District; United States Department of Homeland Security | U.S. Supreme Court | 9th Circuit Court of Appeals; District Court, Northern District of California | 1 | Kim McLane Wardlaw; Jacqueline Nguyen; John B. Owens; WIlliam Haskell Alsup | 899 | 3 | 2 | 2 | DACA | 3:17-cv-05211; 18-15068 | 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 );