Trump Lawsuits: trump-lawsuits.csv

Table actions

This table contains the data behind the stories:

Variable Description Values
docketNumber Current docket number
dateFiled Date lawsuit was originally filed
caseName Case name (current)
plaintiff Names of plaintiffs (if more than five, "et al" for plaintiffs who are not in case name)
defendant Names of defendants (if more than five, "et al" for defendants who are not in case name)
currentLocation Court the lawsuit is currently in front of
previousLocation Other courts the case has appeared before
jurisdiction Where the case is being heard 1 = Federal; 2 = State
judge Names of the judges the case is currently before
nature PACER code for nature of lawsuit (Not relevant for criminal cases) https://www.pacer.gov/documents/natsuit.pdf
capacity The capacity in which Trump is implicated 1 = Case directed at Trump personally; 2 = Case directed at action of Trump administration; 3 = Trump as plaintiff; 4 = Trump administration as plaintiff; 5 = Case directed at Trump associate; 6 = Other
type Criminal vs. civil 1 = Criminal; 2 = Civil
TrumpCategory Whether the case is related to action before Trump was president, his personal conduct as president, or a policy action as president 1 = Case directed at pre-presidency action; 2 = Case directed at personal action of Trump as president; 3 = Case directed at policy action of Trump as president
issue Key topic area raised in the case (i.e. emoluments, First Amendment, DACA, etc). Categories created based on key policy topic area or legal issue. Calls are subjective and based on reporting and may change.
docketOrig Original docket number, if case has been appealed or changed jurisdiction
status Whether the case, or the part of the case connected to Trump, is ongoing. 1 = Case is ongoing; 2 = Case or part of case connected to Trump is closed

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette

7 rows where currentLocation = "9th Circuit Court of Appeals"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: plaintiff, defendant, previousLocation, TrumpCategory, capacity, type, issue, dateFiled (date)

Link rowid ▼ docketNumber dateFiled caseName plaintiff defendant currentLocation previousLocation jurisdiction judge nature TrumpCategory capacity type issue docketOrig status
4 4 18-56351 2018-04-30 Clifford v. Trump Stephanie Clifford Donald J. Trump 9th Circuit Court of Appeals District Court, Central District of California 1 S. James Otero; Frederick Mumm 320 1 1 2 Defamation 2:18-cv-06893 1
18 18 17-10448 2016-08-19 United States v. Joseph Arpaio United States of America Joseph Arpaio 9th Circuit Court of Appeals District of Arizona 1 Susan Bolton   2 5 1 Pardons 2:16-cr-01012 1
23 23 18-17274 2018-11-09 East Bay Sanctuary Covenant v. Trump East Bay Sanctuary Covenant; Al Otro Lado; Innovation Law Lab; Central American Resource Center in Los Angeles Donald J. Trump, et al 9th Circuit Court of Appeals District Court, Northern District of California 1 Edward Leavy; Jay Bybee; Andrew Hurwitz; Jon Steven Tigar 465 3 1 2 Asylum 3:18-cv-06810 1
25 25 19-15716, 2019-02-14 Innovation Law Lab v. Nielsen Innovation Law Lab Kirstjen Nielsen, et al 9th Circuit Court of Appeals District Court, Northern District of California   Richard G. Seeborg 551 3 2 2 Asylum 3:19-cv-00807 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
48 48 18-16496 2018-03-09 United States of America v. California et al United States of America State of California; Xavier Becerra; Edmund Brown 9th Circuit Court of Appeals District Court, Eastern District of California 1 John A. Mendez 950 3 4 2 Sanctuary laws 2:18-cv-00490 1
53 53 18-35347 2017-08-28 Karnoski v. Trump Ryan Karnoski Donald J. Trump, et al 9th Circuit Court of Appeals District Court, Western District of Washington 1 Raymond Fisher; Richard Clifton; Connie Callahan; Marsha J. Pechman 442 3 2 2 Transgender military ban 2:17-cv-01297 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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
);