home / openregs

nominations

Executive nominations to the Senate (Congresses 100–119), with confirmation status and vote tallies.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

status
Confirmed, Withdrawn, Returned, Rejected, or Pending.
is_civilian
Whether this is a civilian (non-military) nomination.
vote_yea
Yea votes if confirmed by roll call.
vote_nay
Nay votes if confirmed by roll call.

5,111 rows where status = "Returned" sorted by received_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: part_number, is_civilian, is_military, received_date (date), authority_date (date)

congress 20

  • 113 495
  • 115 416
  • 107 380
  • 118 369
  • 117 354
  • 116 324
  • 114 300
  • 106 247
  • 109 237
  • 108 236
  • 102 233
  • 110 232
  • 111 203
  • 104 196
  • 100 177
  • 103 175
  • 112 161
  • 105 132
  • 101 131
  • 119 113

status 1

  • Returned · 5,111 ✖
id congress number part_number citation description organization received_date ▲ authority_date is_civilian is_military status vote_yea vote_nay
119-721-00 119 721 00 PN721 Military nomination — Armed Services Armed Services 2025-12-18 2026-01-03 0 1 Returned    
119-722-00 119 722 00 PN722 Military nomination — Armed Services Armed Services 2025-12-18 2026-01-03 0 1 Returned    
119-723-00 119 723 00 PN723 Military nomination — Armed Services Armed Services 2025-12-18 2026-01-03 0 1 Returned    
119-724-00 119 724 00 PN724 Military nomination — Armed Services Armed Services 2025-12-18 2026-01-03 0 1 Returned    
119-725-00 119 725 00 PN725 Military nomination — Armed Services Armed Services 2025-12-18 2026-01-03 0 1 Returned    
119-672-00 119 672 00 PN672 James Bishop, of North Carolina, to be United States Attorney for the Middle District of North Carolina for the term of four years, vice Sandra J. Hairston. Department of Justice 2025-12-01 2026-01-03 1 0 Returned    
119-673-01 119 673 01 PN673-1 Megan Blair Benton, of Missouri, to be United States District Judge for the Western District of Missouri, vice M. Douglas Harpool, retiring. The Judiciary 2025-12-01 2026-01-03 1 0 Returned    
119-673-02 119 673 02 PN673-2 Christopher Michael De Bono, of the District of Columbia, to be an Associate Judge of the Superior Court of the District of Columbia for the term of fifteen years, vice Heidi M. Pasichow, retired. The Judiciary 2025-12-01 2026-01-03 1 0 Returned    
119-673-03 119 673 03 PN673-3 Brian Charles Lea, of Tennessee, to be United States District Judge for the Western District of Tennessee, vice John Thomas Fowlkes, Jr., retired. The Judiciary 2025-12-01 2026-01-03 1 0 Returned    
119-673-04 119 673 04 PN673-4 Justin R. Olson, of Indiana, to be United States District Judge for the Southern District of Indiana, vice Jane E. Magnus-Stinson, retired. The Judiciary 2025-12-01 2026-01-03 1 0 Returned    
119-652-00 119 652 00 PN652 Stuart Levenbach, of Maryland, to be Director, Bureau of Consumer Financial Protection for a term of five years, vice Rohit Chopra. Bureau of Consumer Financial Protection 2025-11-18 2026-01-03 1 0 Returned    
119-653-00 119 653 00 PN653 Carter Crow, of Texas, to be General Counsel of the Equal Employment Opportunity Commission for a term of four years, vice Karla Ann Gilbride. Equal Employment Opportunity Commission 2025-11-18 2026-01-03 1 0 Returned    
119-654-00 119 654 00 PN654 Robert Cekada, of Florida, to be Director, Bureau of Alcohol, Tobacco, Firearms, and Explosives, vice Steven M. Dettelbach, resigned. Department of Justice 2025-11-18 2026-01-03 1 0 Returned    
119-655-01 119 655 01 PN655-1 David Clay Fowlkes, of Arkansas, to be United States District Judge for the Western District of Arkansas, vice Paul Kinloch Holmes, III, retired. The Judiciary 2025-11-18 2026-01-03 1 0 Returned    
119-655-02 119 655 02 PN655-2 Nicholas Jon Ganjei, of Texas, to be United States District Judge for the Southern District of Texas, vice Lynn H. Hughes, retired. The Judiciary 2025-11-18 2026-01-03 1 0 Returned    
119-655-03 119 655 03 PN655-3 Aaron Christian Peterson, of Alaska, to be United States District Judge for the District of Alaska, vice Timothy Mark Burgess, retired. The Judiciary 2025-11-18 2026-01-03 1 0 Returned    
119-645-01 119 645 01 PN645-1 Stevan Pearce, of New Mexico, to be Director of the Bureau of Land Management, vice Tracy Stone-Manning, resigned. Department of the Interior 2025-11-05 2026-01-03 1 0 Returned    
119-646-00 119 646 00 PN646 Daniel E. Burrows, of Colorado, to be an Assistant Attorney General, vice Aaron Reitz, resigned. Department of Justice 2025-11-05 2026-02-05 1 0 Returned    
119-616-01 119 616 01 PN616-1 Brian Barber, of Louisiana, to be United States Marshal for the Western District of Louisiana for the term of four years, vice Henry Lee Whitehorn, Sr., term expired. Department of Justice 2025-10-21 2026-01-03 1 0 Returned    
119-616-02 119 616 02 PN616-2 Brian Birdwell, of Texas, to be an Assistant Secretary of Defense, vice Christopher Joseph Lowman. Department of Defense 2025-10-21 2026-01-03 1 0 Returned    
119-616-03 119 616 03 PN616-3 John Breslow, of Arizona, to be Ambassador Extraordinary and Plenipotentiary of the United States of America to the Republic of Cyprus. Department of State 2025-10-21 2026-01-03 1 0 Returned    
119-616-04 119 616 04 PN616-4 Wesley Brooks, of Florida, to be Assistant Secretary of State for Oceans and International Environmental and Scientific Affairs, vice Monica P. Medina, resigned. Department of State 2025-10-21 2026-01-03 1 0 Returned    
119-616-05 119 616 05 PN616-5 Edward Eppler, of Connecticut, to be Chief Financial Officer, Department of Transportation, vice Victoria Marie Baecher Wassmer, resigned. Department of Transportation 2025-10-21 2026-01-03 1 0 Returned    
119-616-06 119 616 06 PN616-6 Gregory Gilmore, of Illinois, to be United States Attorney for the Central District of Illinois for the term of four years, vice Gregory K. Harris. Department of Justice 2025-10-21 2026-01-03 1 0 Returned    
119-616-07 119 616 07 PN616-7 Brian Gootkin, of Montana, to be United States Marshal for the District of Montana for the term of four years, vice Craig J. Anderson. Department of Justice 2025-10-21 2026-01-03 1 0 Returned    
119-616-08 119 616 08 PN616-8 Thomas Govan, Jr., of Alabama, to be United States Attorney for the Middle District of Alabama for the term of four years, vice Louis V. Franklin, Sr., term expired. Department of Justice 2025-10-21 2026-01-03 1 0 Returned    
119-616-09 119 616 09 PN616-9 Kevin Holmes, of Arkansas, to be United States Attorney for the Western District of Arkansas for the term of four years, vice Duane A. Kees, term expired. Department of Justice 2025-10-21 2026-01-03 1 0 Returned    
119-616-10 119 616 10 PN616-10 Gregory LoGerfo, of Massachusetts, a Career Member of the Senior Foreign Service, Class of Minister-Counselor, to be Coordinator for Counterterrorism, with the rank and status of Ambassador at Large, vice Elizabeth H. Richard. Department of State 2025-10-21 2026-01-03 1 0 Returned    
119-616-11 119 616 11 PN616-11 Ryan Raybould, of Texas, to be United States Attorney for the Northern District of Texas for the term of four years, vice Leigha Simonton. Department of Justice 2025-10-21 2026-01-03 1 0 Returned    
119-616-12 119 616 12 PN616-12 James Stuart, of Minnesota, to be United States Marshal for the District of Minnesota for the term of four years, vice Eddie M. Frizell. Department of Justice 2025-10-21 2026-01-03 1 0 Returned    
119-616-13 119 616 13 PN616-13 Phillip Williams, Jr., of Alabama, to be United States Attorney for the Northern District of Alabama for the term of four years, vice John E. Town, term expired. Department of Justice 2025-10-21 2026-01-03 1 0 Returned    
119-605-00 119 605 00 PN605 Jennifer Wicks McNamara, of Virginia, to be Ambassador Extraordinary and Plenipotentiary of the United States of America to the Socialist Republic of Vietnam. Department of State 2025-10-20 2026-01-29 1 0 Returned    
119-607-00 119 607 00 PN607 Military nomination — Armed Services Armed Services 2025-10-20 2026-01-03 0 1 Returned    
119-591-00 119 591 00 PN591 Lee Lipton, of Florida, to be Ambassador Extraordinary and Plenipotentiary of the United States of America to the Republic of the Philippines. Department of State 2025-10-08 2026-01-03 1 0 Returned    
119-585-01 119 585 01 PN585-1 Daniel Bonham, of Oregon, to be an Assistant Secretary of Labor, vice Elizabeth Schoff Watson, resigned. Department of Labor 2025-10-02 2026-01-03 1 0 Returned    
119-585-02 119 585 02 PN585-2 Mark Ditlevson, of Minnesota, to be an Assistant Secretary of Defense, vice Melissa Griffin Dalton, resigned. Department of Defense 2025-10-02 2026-01-03 1 0 Returned    
119-585-03 119 585 03 PN585-3 Paul Ferguson, of West Virginia, to be United States Marshal for the Northern District of West Virginia for the term of four years, vice J.C. Raffety, term expired. Department of Justice 2025-10-02 2026-01-03 1 0 Returned    
119-585-04 119 585 04 PN585-4 William Hewes III, of Mississippi, to be a Commissioner of the Consumer Product Safety Commission for a term expiring October 26, 2031,vice Douglas Dziak, resigned. Consumer Product Safety Commission 2025-10-02 2026-01-03 1 0 Returned    
119-585-05 119 585 05 PN585-5 Benjamin Landa, of New York, to be Ambassador Extraordinary and Plenipotentiary of the United States of America to Hungary. Department of State 2025-10-02 2026-01-03 1 0 Returned    
119-585-06 119 585 06 PN585-6 Arvind Raman, of Indiana, to be Under Secretary of Commerce for Standards and Technology, vice Laurie E. Locascio, resigned. Department of Commerce 2025-10-02 2026-01-03 1 0 Returned    
119-585-07 119 585 07 PN585-7 Robert Rotter, of Iowa, to be United States Marshal for the Northern District of Iowa for the term of four years, vice Douglas J. Strike, term expired. Department of Justice 2025-10-02 2026-01-03 1 0 Returned    
119-585-08 119 585 08 PN585-8 Daniel Satterlee, of South Dakota, to be United States Marshal for the District of South Dakota for the term of four years, vice Daniel C. Mosteller, term expired. Department of Justice 2025-10-02 2026-01-03 1 0 Returned    
119-585-09 119 585 09 PN585-9 David St. Pierre, of Maine, to be United States Marshal for the District of Maine for the term of four years, vice Theodor G. Short, term expired. Department of Justice 2025-10-02 2026-01-03 1 0 Returned    
119-586-00 119 586 00 PN586 Military nomination — Armed Services Armed Services 2025-10-02 2026-01-03 0 1 Returned    
119-589-00 119 589 00 PN589 Military nomination — Armed Services Armed Services 2025-10-02 2026-01-03 0 1 Returned    
119-559-00 119 559 00 PN559 Lindsey Robyn-Michelle Halligan, of Colorado, to be United States Attorney for the Eastern District of Virginia for the term of four years, vice Jessica D. Aber. Department of Justice 2025-09-30 2026-01-03 1 0 Returned    
119-560-01 119 560 01 PN560-1 Charlton Allen, of North Carolina, to be General Counsel of the Federal Labor Relations Authority for a term of five years, vice Julia Akins Clark, term expired. Federal Labor Relations Authority 2025-09-30 2026-01-03 1 0 Returned    
119-560-02 119 560 02 PN560-2 Andrew Benson, of Maine, to be United States Attorney for the District of Maine for the term of four years, vice Darcie N. McElwee. Department of Justice 2025-09-30 2026-01-03 1 0 Returned    
119-560-04 119 560 04 PN560-4 Jeffrey Kaufmann, of Iowa, to be a Member of the Board of Directors of the Federal Agricultural Mortgage Corporation, vice Chester John Culver. Federal Agricultural Mortgage Corporation 2025-09-30 2026-01-03 1 0 Returned    
119-560-05 119 560 05 PN560-5 Priscilla Lopez, of Florida, to be United States Marshal for the Southern District of Florida for the term of four years, vice Gadyaces S. Serralta, term expired. Department of Justice 2025-09-30 2026-01-03 1 0 Returned    
119-555-00 119 555 00 PN555 Military nomination — Armed Services Armed Services 2025-09-29 2026-01-03 0 1 Returned    
119-519-01 119 519 01 PN519-1 William Boyle, of North Carolina, to be United States Attorney for the Eastern District of North Carolina for the term of four years, vice Michael F. Easley, Jr. Department of Justice 2025-09-15 2026-01-03 1 0 Returned    
119-519-03 119 519 03 PN519-3 Zachary Keller, of Louisiana, to be United States Attorney for the Western District of Louisiana for the term of four years, vice Brandon B. Brown. Department of Justice 2025-09-15 2026-01-03 1 0 Returned    
119-518-01 119 518 01 PN518-1 John DeLeeuw, of Texas, to be a Member of the National Transportation Safety Board for the remainder of the term expiring December 31, 2026, vice Alvin Brown. National Transportation Safety Board 2025-09-10 2026-01-03 1 0 Returned    
119-518-03 119 518 03 PN518-3 Richard Kloster, of West Virginia, to be a Member of the Surface Transportation Board for a term expiring December 31, 2028, vice Martin J. Oberman, term expired. Surface Transportation Board 2025-09-10 2026-01-03 1 0 Returned    
119-518-04 119 518 04 PN518-4 Bryce McFerran, of California, to be First Vice President of the Export-Import Bank of the United States for a term expiring January 20, 2029, vice Judith DelZoppo Pryor, resigned. Export-Import Bank of the United States 2025-09-10 2026-01-03 1 0 Returned    
119-499-03 119 499 03 PN499-3 Steven Haines, of Virginia, to be an Assistant Secretary of Commerce, vice Grant T. Harris, resigned. Department of Commerce 2025-09-03 2026-01-03 1 0 Returned    
119-499-04 119 499 04 PN499-4 Robert Harvey, of Florida, to be a Federal Maritime Commissioner for a term expiring June 30, 2029, vice Carl Whitney Bentzel, term expired. Federal Maritime Commission 2025-09-03 2026-01-03 1 0 Returned    
119-499-05 119 499 05 PN499-5 George Holding, of North Carolina, to be United States Director of the European Bank for Reconstruction and Development, vice J. Steven Dowd. European Bank for Reconstruction and Development 2025-09-03 2026-01-03 1 0 Returned    
119-499-06 119 499 06 PN499-6 Sriprakash Kothari, of Massachusetts, to be an Assistant Secretary of the Treasury, vice Benjamin Harris, resigned. Department of the Treasury 2025-09-03 2026-01-03 1 0 Returned    
119-499-07 119 499 07 PN499-7 Ryan McCormack, of Virginia, to be Under Secretary of Transportation for Policy, vice Carlos Alberto Monje, Jr. Department of Transportation 2025-09-03 2026-01-03 1 0 Returned    
119-499-09 119 499 09 PN499-9 Brian David Miller, of Pennsylvania, to be United States Attorney for the Middle District of Pennsylvania for the term of four years, vice Gerard M. Karam. Department of Justice 2025-09-03 2026-01-03 1 0 Returned    
119-465-06 119 465 06 PN465-6 William Long, of Missouri, to be Ambassador Extraordinary and Plenipotentiary of the United States of America to the Republic of Iceland. Department of State 2025-09-02 2026-01-03 1 0 Returned    
119-445-04 119 445 04 PN445-4 Daniel Edwards, of North Carolina, to be an Assistant Secretary of Transportation, vice Carol Annette Petsonk, resigned. Department of Transportation 2025-07-30 2026-01-03 1 0 Returned    
119-445-08 119 445 08 PN445-8 Richard Price, of Missouri, to be United States Attorney for the Western District of Missouri for the term of four years, vice Timothy A. Garrison, term expired. Department of Justice 2025-07-30 2026-01-03 1 0 Returned    
119-445-09 119 445 09 PN445-9 Darin Smith, of Wyoming, to be United States Attorney for the District of Wyoming for the term of four years, vice Mark A. Klaassen, term expired. Department of Justice 2025-07-30 2026-01-03 1 0 Returned    
119-440-02 119 440 02 PN440-2 Military nomination — Armed Services Armed Services 2025-07-29 2026-01-03 0 1 Returned    
119-431-00 119 431 00 PN431 Military nomination — Armed Services Armed Services 2025-07-23 2026-01-03 0 1 Returned    
119-433-00 119 433 00 PN433 Military nomination — Armed Services Armed Services 2025-07-23 2026-01-03 0 1 Returned    
119-438-00 119 438 00 PN438 Military nomination — Armed Services Armed Services 2025-07-23 2026-01-03 0 1 Returned    
119-420-00 119 420 00 PN420 Military nomination — Armed Services Armed Services 2025-07-21 2026-01-03 0 1 Returned    
119-416-01 119 416 01 PN416-1 Jeffrey Anderson, of Georgia, to be Representative of the United States of America on the Council of the International Civil Aviation Organization, with the rank of Ambassador. Department of State 2025-07-16 2026-01-03 1 0 Returned    
119-416-08 119 416 08 PN416-8 Todd Lindsey, of Idaho, to be Chief Financial Officer, Department of Agriculture, vice Jon M. Holladay. Department of Agriculture 2025-07-16 2026-01-03 1 0 Returned    
119-403-02 119 403 02 PN403-2 Military nomination — Armed Services Armed Services 2025-07-15 2026-01-03 0 1 Returned    
119-405-02 119 405 02 PN405-2 Military nomination — Armed Services Armed Services 2025-07-15 2026-01-03 0 1 Returned    
119-411-00 119 411 00 PN411 Military nomination — Armed Services Armed Services 2025-07-15 2026-01-03 0 1 Returned    
119-380-01 119 380 01 PN380-1 Nicholas Adams, of Florida, to be Ambassador Extraordinary and Plenipotentiary of the United States of America to Malaysia. Department of State 2025-07-09 2026-01-03 1 0 Returned    
119-380-02 119 380 02 PN380-2 Eric Meyer, of California, to be Ambassador Extraordinary and Plenipotentiary of the United States of America to the Democratic Socialist Republic of Sri Lanka. Department of State 2025-07-09 2026-01-03 1 0 Returned    
119-379-01 119 379 01 PN379-1 Ademola Adewale-Sadik, of New York, to be United States Director of the African Development Bank for a term of five years, vice Oren E. Whyche-Shaw. African Development Bank 2025-06-30 2026-01-03 1 0 Returned    
119-379-02 119 379 02 PN379-2 Lee Beaman, of Tennessee, to be a Member of the Board of Directors of the Tennessee Valley Authority for a term expiring May 18, 2030, vice Joe H. Ritch, term expired. Tennessee Valley Authority 2025-06-30 2026-01-03 1 0 Returned    
119-379-23 119 379 23 PN379-23 Robert Sweeney, of Texas, to be United States Director of the Asian Development Bank, with the Rank of Ambassador, vice Chantale Yokmin Wong, resigned. Asian Development Bank 2025-06-30 2026-01-03 1 0 Returned    
119-379-25 119 379 25 PN379-25 Frank Weiland, of the District of Columbia, to be an Assistant Secretary of State (International Narcotics and Law Enforcement Affairs), vice Todd D. Robinson. Department of State 2025-06-30 2026-01-03 1 0 Returned    
119-377-00 119 377 00 PN377 Military nomination — Commerce, Science, and Transportation Commerce, Science, and Transportation 2025-06-26 2026-01-03 0 1 Returned    
119-345-04 119 345 04 PN345-4 Jeremy Carl, of Montana, to be an Assistant Secretary of State (International Organizations), vice Michele Jeanne Sison. Department of State 2025-06-16 2026-01-03 1 0 Returned    
119-345-07 119 345 07 PN345-7 Michael Graham, of Virginia, to be a Member of the National Transportation Safety Board for a term expiring December 31, 2030. (Reappointment) National Transportation Safety Board 2025-06-16 2026-01-03 1 0 Returned    
119-345-17 119 345 17 PN345-17 Alexander Velez-Green, of Virginia, to be a Deputy Under Secretary of Defense, vice Alexandra Baker, resigned. Department of Defense 2025-06-16 2026-01-03 1 0 Returned    
119-345-18 119 345 18 PN345-18 Bradley Walker, of North Carolina, to be Ambassador at Large for International Religious Freedom, vice Rashad Hussain. Department of State 2025-06-16 2026-01-03 1 0 Returned    
119-346-04 119 346 04 PN346-4 John M. Guard, of Florida, to be United States District Judge for the Middle District of Florida, vice Timothy J. Corrigan, retired. The Judiciary 2025-06-16 2026-01-03 1 0 Returned    
119-246-05 119 246 05 PN246-5 Austin Dahmer, of Arizona, to be an Assistant Secretary of Defense, vice Mara Elizabeth Karlin. Department of Defense 2025-06-02 2026-01-03 1 0 Returned    
119-246-08 119 246 08 PN246-8 Anthony Lomangino, of Florida, to be a Governor of the United States Postal Service for a term expiring December 8, 2031, vice Roman Martinez IV, term expired. United States Postal Service 2025-06-02 2026-01-03 1 0 Returned    
119-246-10 119 246 10 PN246-10 Casey Means, of California, to be Medical Director in the Regular Corps of the Public Health Service, subject to qualifications therefor as provided by law and regulations, and to be Surgeon General of the Public Health Service for a term of four years, vice Vivek Hallegere Murthy, resigned. Public Health Service 2025-06-02 2026-01-03 1 0 Returned    
119-246-14 119 246 14 PN246-14 Glen Smith, of Iowa, to be Under Secretary of Agriculture for Rural Development, vice Basil Ivanhoe Gooden, resigned. Department of Agriculture 2025-06-02 2026-02-24 1 0 Returned    
119-251-00 119 251 00 PN251 Military nomination — Armed Services Armed Services 2025-06-02 2026-01-03 0 1 Returned    
119-141-04 119 141 04 PN141-4 Matthew Anderson, of Colorado, to be Deputy Administrator of the National Aeronautics and Space Administration, vice Pamela A. Melroy, resigned. National Aeronautics and Space Administration 2025-05-06 2026-01-03 1 0 Returned    
119-141-15 119 141 15 PN141-15 Irving Dennis, of Ohio, to be Chief Financial Officer, Department of Housing and Urban Development, vice Vinay Vijay Singh, resigned. Department of Housing and Urban Development 2025-05-06 2026-01-03 1 0 Returned    
119-141-29 119 141 29 PN141-29 David MacNeil, of Florida, to be Ambassador at Large for Industrial and Manufacturing Competitiveness. Department of State 2025-05-06 2026-01-03 1 0 Returned    
119-132-02 119 132 02 PN132-2 Military nomination — Armed Services Armed Services 2025-04-29 2026-01-03 0 1 Returned    
119-127-04 119 127 04 PN127-4 Military nomination — Commerce, Science, and Transportation Commerce, Science, and Transportation 2025-04-28 2026-01-03 0 1 Returned    
119-115-00 119 115 00 PN115 Scott Bessent, of South Carolina, to be United States Governor of the European Bank for Reconstruction and Development; United States Governor of the Inter-American Development Bank for a term of five years; United States Governor of the International Bank for Reconstruction and Development for a term of five years; and United States Governor of the International Monetary Fund for a term of five years, vice Steven T. Mnuchin. European Bank for Reconstruction and Development 2025-04-07 2026-01-03 1 0 Returned    
119-62-00 119 62 00 PN62 Jared Novelly, of Missouri, to be Ambassador Extraordinary and Plenipotentiary of the United States of America to New Zealand, and to serve concurrently and without additional compensation as Ambassador Extraordinary and Plenipotentiary of the United States of America to the Independent State of Samoa, the Cook Islands, and Niue. Department of State 2025-04-01 2026-01-03 1 0 Returned    

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE nominations (
    id TEXT PRIMARY KEY,
    congress INTEGER,
    number INTEGER,
    part_number TEXT,
    citation TEXT,
    description TEXT,
    organization TEXT,
    received_date TEXT,
    authority_date TEXT,
    is_civilian INTEGER,
    is_military INTEGER,
    status TEXT,
    vote_yea INTEGER,
    vote_nay INTEGER
);
CREATE INDEX idx_nom_congress ON nominations(congress);
CREATE INDEX idx_nom_date ON nominations(received_date);
CREATE INDEX idx_nom_org ON nominations(organization) WHERE organization IS NOT NULL AND organization != '';
CREATE INDEX idx_nom_status_date ON nominations(status, received_date DESC);
CREATE INDEX idx_nom_civ_status ON nominations(is_civilian, status, received_date DESC);
Powered by Datasette · Queries took 149.317ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API