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 = "U.S. Supreme Court" sorted by nature
This data as json, copyable, CSV (advanced)
Suggested facets: TrumpCategory, type, status, dateFiled (date)
Link | rowid | docketNumber | dateFiled | caseName | plaintiff | defendant | currentLocation | previousLocation | jurisdiction | judge | nature ▼ | TrumpCategory | capacity | type | issue | docketOrig | status |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21 | 21 | 18-496 | 2016-03-15 | Michaels v. Sessions | Barry Michaels | Jefferson Sessions; Thomas E. Brandon | U.S. Supreme Court | 9th Circuit Court of Appeals; District of Nevada | 1 | Edward Leavy; Paul Watford; Michelle Friedland; Jennifer Dorsey | 2 | 2 | 1 | Whitaker dispute | 17-15279; 2:16-cv-00578 | 2 | |
27 | 27 | 1:18-cv-02921 | 2018-04-03 | State of New York v. U.S. Department of Commerce | State of New York et al | Wilbur Ross, Jr.; U.S. Department of Commerce; Bureau of the Census; Ron S. Jarmin | U.S. Supreme Court | 1 | Jesse Matthew Furman | 889 | 3 | 2 | 2 | Census | 1 | ||
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 );