home / fivethirtyeight

Trump Lawsuits: trump-lawsuits.csv

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

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub

43 rows

View and edit SQL

Suggested facets: currentLocation, previousLocation, jurisdiction, nature, TrumpCategory, capacity, type, issue, docketOrig

Link rowid docketNumber dateFiled caseName plaintiff defendant currentLocation previousLocation jurisdiction judge nature TrumpCategory capacity type issue docketOrig
1 2:18-cv-02217 03/06/18 Clifford v. Trump Stephanie Clifford Donald J. Trump; Essential Consultants LLC; Michael Cohen District Court, Central District of California   1 S. James Otero; Frederick Mumm 190 1 1 2 2016 Trump campaign  
2 3:18-cv-00484 7/12/18 Cockrum v. Donald J. Trump for President, Inc. Roy Cockrum; Scott Comer; Eric Schoenberg Donald J. Trump for President, Inc. District Court, Eastern District of Virginia   1 Henry E. Hudson 440 1 6 2 2016 Trump campaign  
3 3:18-cv-06810 11/9/18 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 District Court, Northern District of California   1 Jon Steven Tigar 465 3 1 2 Asylum  
4 17-cv-2590 12/7/17 Hopi Tribe v. Trump Hopi Tribe; Navajo Nation; Ute Indian Tribe; Ute Mountain Tribe; Zuni Tribe Donald J. Trump; Ryan Zinke; Brian Steed; Sonny Purdue; Tony Tooke District Court, District of Columbia   1 Tanya Sue Chutkan 890 3 2 2 Bears Ears  
5 1:18-cv-02921 4/3/2018 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 District Court, Southern District of New York   1 Jesse Matthew Furman 889 3 2 2 Census  
6 3:18-cv-01865 3/26/18 California v. Ross State of California et al Wilbur Ross, Jr.; U.S. Department of Commerce; Bureau of the Census; Ron S. Jarmin District Court, Northern District of California   1 Richard G. Seeborg 899 3 2 2 Census  
7 8:18-cv-01570 5/31/19 La Union del Pubelo Entero v. Ross La Union del Pubelo Entero et al Wilbur Ross; U.S. Department of Commerce; Ron Jarmin; U.S. Census Bureau District Court, District of Maryland   1 George Jarrod Hazel 899 3 2 2 Census  
8 18-587 9/8/17 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
9 18-01986 8/25/16 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
10 18-1522 8/5/17 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
11 18-5243 9/18/17 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
12 1:18-cv-00068 5/1/18 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  
13 18-56351 04/30/18 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
14 0150522/2017 1/17/2017 Zervos v. Trump Summer Zervos Donald J. Trump Supreme Court of the State of New York   2 Jennifer G. Schechter   2 1 2 Defamation  
15 8:17-cv-01596 6/12/17 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  
16 18-474 1/23/17 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
17 1:17-cv-01154 6/14/17 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  
18 1:18-cv-09433 10/16/18 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  
19 18-1691 7/11/17 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
20 1:17-cr-00232 11/30/17 United States v. Flynn United States of America Michael T. Flynn District Court, District of Columbia   1 Emmet G. Sullivan   1 5 2 Mueller investigation  
21 18-3052 8/14/18 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  
22 1:17-cr-00201 10/30/17 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  
23 1:18-cr-00850 11/28/18 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  
24 1:18-cv-00152 6/27/18 American Institute for International Steel v. United States American Institute for International Steel, Inc.; Sim-Lex LP; Kurt Orban Partners, LLC; United States; Kevin K. McAleenan Court of International Trade   1 Claire R. Kelly; Jennifer Choe-Groves; Gary S. Katzmann   3 2 2 National security tariffs  
25 17-10448 8/19/16 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
26 18-2648 8/30/17 City of Philadelphia v. Attorney General United States City of Philadelphia Attorney General United States of America 3rd Circuit Court of Appeals District Court, Pennsylvania Eastern District 1 Thomas Ambro; Anthony Scirica; Midge Rendell; Michael Baylson 899 3 2 2 Sanctuary cities 2:17-cv-03894
27 1:18-cv-06859 10/12/18 City of Chicago v. Sessions (II) City of Chicago Jefferson B. Sessions III District Court, Northern District of Illinois   1 Elaine E. Bucklo; Maria Valdez 899 3 2 2 Sanctuary cities  
28 18-56292 9/29/17 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
29 2:18-cv-07347 8/22/18 City of Los Angeles v. Jefferson Sessions (II) City of Los Angeles Jefferson B. Sessions III; Laura Rogers; United States Department of Justice District Court, California Central District   1 Manuel Lawrence Real 890 3 2 2 Sanctuary cities  
30 1:18-cv-06471 7/18/18 State of New York v. U.S. Department of Justice State of New York et al U.S. Department of Justice, et al District Court, Southern District of New York   1 Edgardo Ramos 899 3 2 2 Sanctuary cities  
31 18-16496 3/9/2018 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
32 1:18-cv-01599 3/15/18 Saget v. Trump Patrick Saget, et al Donald J. Trump; Department of Homeland Security; Elaine C. Duke; Kirstjen Nielsen; United States of America New York Eastern District Court   1 William F. Kuntz 899 3 2 2 TPS revocation  
33 3:18-cv-01554 3/12/18 Ramos v. Nielsen Crista Ramos, et al Kirstjen Nielsen, et al District Court, Northern District of California   1 Edward M. Chen 440 3 2 2 TPS revocation  
34 18-5257 8/9/17 Doe v. Trump Dylan Kohere, et al James Mattis, et al D.C. Circuit Court of Appeals District Court, District of Columbia 1 Colleen Kollar-Kotelly 440 3 2 2 Transgender military ban 1:17-cv-01597
35 1:17-cv-02459 8/28/17 Stone v. Trump Brock Stone, et al Donald J. Trump, et al District Court, District of Maryland   1 George Levi Russell III 440 3 2 2 Transgender military ban  
36 18-35347 8/28/17 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
37 5:17-cv-01799 9/5/17 Stockman v. Trump Aiden Stockman, et al Donald J. Trump, et al District Court, Central District of California   1 Jesus G. Bernal 440 3 2 2 Transgender military ban  
38 1:18-cv-09936 10/29/18 Doe v. Trump Corporation Jane Doe et al The Trump Corporation et al District Court, Southern District of New York   1 Lorna G. Schofield 470 1 1 2 Trump business/foundation  
39 451130/2018 6/14/18 Underwood v. Trump People of the State of New York, by Barbara D. Underwood Donald J. Trump, Donald J. Trump, Jr., Ivanka Trump, Eric F. Trump, and the Donald Trump Foundation Supreme Court of the State of New York   2 Saliann Scarpulla 440 1 1 2 Trump business/foundation  
40 1:18-cr-00602 8/21/2018 United States v. Cohen United States of America Michael Cohen District Court, Southern District of New York   1 William H. Pauley III   1 5 2 Trump campaign  
41 1:18-cv-02849 9/13/18 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  
42 1:18-cv-02664 11/19/18 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  
43 18-496 3/15/16 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

Advanced export

JSON shape: default, array

CSV options:

CREATE TABLE "trump-lawsuits/trump-lawsuits" (
"docketNumber" TEXT,
  "dateFiled" TEXT,
  "caseName" TEXT,
  "plaintiff" TEXT,
  "defendant" TEXT,
  "currentLocation" TEXT,
  "previousLocation" REAL,
  "jurisdiction" INTEGER,
  "judge" TEXT,
  "nature" INTEGER,
  "TrumpCategory" INTEGER,
  "capacity" INTEGER,
  "type" INTEGER,
  "issue" TEXT,
  "docketOrig" REAL
)
Powered by Datasette · Query took 91.98ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub