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

11 rows where TrumpCategory = 2

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: defendant, currentLocation, previousLocation, jurisdiction, nature, capacity, type, issue, status, dateFiled (date)

Link rowid ▼ docketNumber dateFiled caseName plaintiff defendant currentLocation previousLocation jurisdiction judge nature TrumpCategory capacity type issue docketOrig status
11 11 0150522/2017 2017-01-17 Zervos v. Trump Summer Zervos Donald J. Trump Supreme Court of the State of New York   2 Jennifer G. Schechter   2 1 2 Defamation   1
12 12 18-2486 2018-12-17 In re: Donald J. Trump U.S. Department of Justice District of Columbia and State of Maryland 4th Circuit Court of Appeals   1   440 2 1 2 Emoluments   1
13 13 8:17-cv-01596 2017-06-12 The District of Columbia v. Trump The District of Columbia; The State of Maryland Donald J. Trump District Court, District of Maryland   1 Peter Jo Messitte 440 2 1 2 Emoluments 18-2488 1
14 14 18-474 2017-01-23 CREW v. Trump Citizens for Responsibility and Ethics in Washington; Restaurant Opportunities Centers United; Jill Phaneuf; Eric Goode Donald J. Trump 2nd Circuit Court of Appeals District Court, Southern District of New York 1 Pierre Leval; John Walker; Christopher Droney; George B. Daniels 440 2 1 2 Emoluments 17-cv-458 1
15 15 1:17-cv-01154 2017-06-14 Blumenthal v. Trump Senator Richard Blumenthal et al Donald J. Trump District Court, District of Columbia   1 Emmet G. Sullivan 440 2 1 2 Emoluments   1
16 16 1:18-cv-09433 2018-10-16 PEN America v. Trump PEN American Center Inc Donald J. Trump District Court, Southern District of New York   1 Lorna G. Schofield 440 2 1 2 First Amendment   1
17 17 18-1691 2017-07-11 Knight First Amendment Institute at Columbia University v. Trump Knight First Amendment Institute at Columbia University; Nicholas Pappas; Philip Cohen; Rebecca Buckwalter; Joseph Papp; Holly Figueroa; Eugene Gu Donald J. Trump; Sean Spicer; Daniel Scavino 2nd Circuit Court of Appeals District Court, Southern District of New York 1 Naomi Reice Buchwald 440 2 1 2 First Amendment 1:17-cv-05205 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
19 19 1:18-cv-02849 2018-09-13 State of Maryland v. United States et al State of Maryland, et al United States of America District Court, District of Maryland   1 Ellen E. Hollander 890 2 2 2 Whitaker dispute   2
20 20 1:18-cv-02664 2018-11-19 Blumenthal v. Whitaker Richard Blumenthal; Sheldon Whitehouse; Mazie Hirono Matthew Whitaker; Donald J. Trump District Court, District of Columbia   1 Trevor McFadden 440 2 1 2 Whitaker dispute   2
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

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