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

5 rows where issue = "DACA"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: nature, dateFiled (date)

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
31 31 18-01986 2016-08-25 Batalla Vidal v. Nielsen Martin Jonathan Batalla Vidal et al Donald J. Trump; Jefferson B. Sessions; Kirstjen Nielsen 2nd Circuit Court of Appeals District Court, Eastern District of New York 1 Nicholas Garaufis 899 3 2 2 DACA 1:16-cv-04756 1
32 32 18-1522 2017-08-05 CASA de Maryland, et al. v. Dept. of Homeland Security, et al. Casa de Maryland, et al Department of Homeland Security, et al 4th Circuit Court of Appeals District Court, District of Maryland 1 Roger W. Titus 899 3 2 2 DACA 8:17-cv-02942 1
33 33 18-5243 2017-09-18 NAACP v. Trump, et al., and Trustees of Princeton, et al. v. United States of America, et al. NAACP, et al Donald J. Trump, et al D.C. Circuit Court of Appeals District Court, District of Columbia 1 John D. Bates 890 3 2 2 DACA 1:17-cv-01907 1
34 34 1:18-cv-00068 2018-05-01 State of Texas et al v. United States of America et al State of Texas, et al United States of America, et al District Court, Southern District of Texas   1 Andrew Hanen 899 3 2 2 DACA   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
);