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

10 rows where type = 1

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: plaintiff, currentLocation, judge, nature, TrumpCategory, capacity, issue, status, dateFiled (date)

Link rowid ▼ docketNumber dateFiled caseName plaintiff defendant currentLocation previousLocation jurisdiction judge nature TrumpCategory capacity type issue docketOrig status
6 6 18-3052 2018-08-14 In re: Grand Jury Investigation Andrew Miller United States of America D.C. Circuit Court of Appeals District Court, District of Columbia 1 Karen Henderson; Judith Rogers; Sri Srinivasen; Beryl Alaine Howell   1 5 1 Mueller investigation   1
7 7 1:18-cr-00850 2018-11-28 United States v. Cohen United States of America Michael Cohen District Court, Southern District of New York   1 William H. Pauley III   1 5 1 Mueller investigation   1
8 8 1:19-cr-00018 2019-01-24 United States v. Stone United States of America Roger Stone District Court, District of Columbia     Amy Berman Jackson   1 5 1 Mueller investigation   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
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
22 22 1:19-cv-01136 2019-04-22 Trump v. Cummings Donald J. Trump et al Elijah Cummings et al District Court, District of Columbia   1 Amir P. Mehta 890 1 3 1 Congressional investigation   1
35 35 1:17-cr-00201 2017-10-30 United States v. Manafort United States of America Paul J. Manafort District Court, District of Columbia   1 Amy Berman Jackson   3 5 1 Mueller investigation   1
55 55 1:19-cv-03826 2019-04-29 Trump et al v. Deutsche Bank and Capital One Donald J. Trump et al Deutsche Bank and Capital One District Court, Southern District of New York   1 Edgardo Ramos 890 1 3 1 Congressional investigation   1
56 56 4:18-cv-00167 2018-02-26 Texas v. United States Texas United States 5th Circuit Court of Appeals District Court, North District of Texas 1 Reed O'Connor 890 3 6 1 Affordable Care Act   1
57 57 8:17-cv-00361 2017-02-07 International Refugee Assistance Program v. Trump International Refugee Assistance Program Donald J. Trump, et al District Court, Northern District of Maryland     Theodore Chuang 440 3 2 1 Travel ban   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
);