Trump Lawsuits: trump-lawsuits.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
3 rows where currentLocation = "District Court, Northern District of California" sorted by capacity
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28 | 28 | 18-966 | 2018-03-26 | California v. Ross | State of California et al | Wilbur Ross, Jr.; U.S. Department of Commerce; Bureau of the Census; Ron S. Jarmin | District Court, Northern District of California | 1 | Richard G. Seeborg | 899 | 3 | 2 | 2 | Census | 3:18-cv-01865 | 1 | |
37 | 37 | 3:19-cv-00872 | 2019-02-18 | California et al v. Trump et al | California et al | Donald J. Trump et al | District Court, Northern District of California | 1 | Elizabeth Laporte | 890 | 3 | 2 | 2 | National emergency declaration | 1 | ||
50 | 50 | 3:18-cv-01554 | 2018-03-12 | Ramos v. Nielsen | Crista Ramos, et al | Kirstjen Nielsen, et al | District Court, Northern District of California | 1 | Edward M. Chen | 440 | 3 | 2 | 2 | TPS revocation | 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 );