nominations
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.
1,360 rows where status = "Pending" sorted by received_date descending
This data as json, CSV (advanced)
Suggested facets: is_civilian, is_military, received_date (date), authority_date (date)
congress 20
status 1
- Pending · 1,360 ✖
| id | congress | number | part_number | citation | description | organization | received_date ▲ | authority_date | is_civilian | is_military | status | vote_yea | vote_nay |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 119-968-00 | 119 | 968 | 00 | PN968 | Military nomination — Armed Services | Armed Services | 2026-05-12 | 2026-05-12 | 0 | 1 | Pending | ||
| 119-969-00 | 119 | 969 | 00 | PN969 | Military nomination — Armed Services | Armed Services | 2026-05-12 | 2026-05-12 | 0 | 1 | Pending | ||
| 119-970-00 | 119 | 970 | 00 | PN970 | Military nomination — Armed Services | Armed Services | 2026-05-12 | 2026-05-12 | 0 | 1 | Pending | ||
| 119-971-00 | 119 | 971 | 00 | PN971 | Military nomination — Armed Services | Armed Services | 2026-05-12 | 2026-05-12 | 0 | 1 | Pending | ||
| 119-972-00 | 119 | 972 | 00 | PN972 | Military nomination — Armed Services | Armed Services | 2026-05-12 | 2026-05-12 | 0 | 1 | Pending | ||
| 119-973-00 | 119 | 973 | 00 | PN973 | Military nomination — Armed Services | Armed Services | 2026-05-12 | 2026-05-12 | 0 | 1 | Pending | ||
| 119-974-00 | 119 | 974 | 00 | PN974 | Military nomination — Armed Services | Armed Services | 2026-05-12 | 2026-05-12 | 0 | 1 | Pending | ||
| 119-975-00 | 119 | 975 | 00 | PN975 | Military nomination — Armed Services | Armed Services | 2026-05-12 | 2026-05-13 | 0 | 1 | Pending | ||
| 119-976-00 | 119 | 976 | 00 | PN976 | Military nomination — Armed Services | Armed Services | 2026-05-12 | 2026-05-12 | 0 | 1 | Pending | ||
| 119-977-00 | 119 | 977 | 00 | PN977 | Military nomination — Armed Services | Armed Services | 2026-05-12 | 2026-05-12 | 0 | 1 | Pending | ||
| 119-978-00 | 119 | 978 | 00 | PN978 | Military nomination — Armed Services | Armed Services | 2026-05-12 | 2026-05-12 | 0 | 1 | Pending | ||
| 119-979-00 | 119 | 979 | 00 | PN979 | Military nomination — Armed Services | Armed Services | 2026-05-12 | 2026-05-12 | 0 | 1 | Pending | ||
| 119-980-00 | 119 | 980 | 00 | PN980 | Military nomination — Armed Services | Armed Services | 2026-05-12 | 2026-05-12 | 0 | 1 | Pending | ||
| 119-981-00 | 119 | 981 | 00 | PN981 | Military nomination — Armed Services | Armed Services | 2026-05-12 | 2026-05-12 | 0 | 1 | Pending | ||
| 119-982-00 | 119 | 982 | 00 | PN982 | Military nomination — Armed Services | Armed Services | 2026-05-12 | 2026-05-12 | 0 | 1 | Pending | ||
| 119-983-00 | 119 | 983 | 00 | PN983 | Military nomination — Armed Services | Armed Services | 2026-05-12 | 2026-05-12 | 0 | 1 | Pending | ||
| 119-984-00 | 119 | 984 | 00 | PN984 | Military nomination — Armed Services | Armed Services | 2026-05-12 | 2026-05-12 | 0 | 1 | Pending | ||
| 119-985-00 | 119 | 985 | 00 | PN985 | Military nomination — Armed Services | Armed Services | 2026-05-12 | 2026-05-12 | 0 | 1 | Pending | ||
| 119-986-00 | 119 | 986 | 00 | PN986 | Military nomination — Armed Services | Armed Services | 2026-05-12 | 2026-05-12 | 0 | 1 | Pending | ||
| 119-987-00 | 119 | 987 | 00 | PN987 | Military nomination — Armed Services | Armed Services | 2026-05-12 | 2026-05-12 | 0 | 1 | Pending | ||
| 119-988-00 | 119 | 988 | 00 | PN988 | Military nomination — Armed Services | Armed Services | 2026-05-12 | 2026-05-12 | 0 | 1 | Pending | ||
| 119-989-00 | 119 | 989 | 00 | PN989 | Military nomination — Armed Services | Armed Services | 2026-05-12 | 2026-05-12 | 0 | 1 | Pending | ||
| 119-990-00 | 119 | 990 | 00 | PN990 | Military nomination — Armed Services | Armed Services | 2026-05-12 | 2026-05-14 | 0 | 1 | Pending | ||
| 119-991-00 | 119 | 991 | 00 | PN991 | Military nomination — Armed Services | Armed Services | 2026-05-12 | 2026-05-12 | 0 | 1 | Pending | ||
| 119-992-00 | 119 | 992 | 00 | PN992 | Military nomination — Armed Services | Armed Services | 2026-05-12 | 2026-05-12 | 0 | 1 | Pending | ||
| 119-993-00 | 119 | 993 | 00 | PN993 | Military nomination — Armed Services | Armed Services | 2026-05-12 | 2026-05-12 | 0 | 1 | Pending | ||
| 119-994-00 | 119 | 994 | 00 | PN994 | Military nomination — Armed Services | Armed Services | 2026-05-12 | 2026-05-12 | 0 | 1 | Pending | ||
| 119-995-00 | 119 | 995 | 00 | PN995 | Military nomination — Armed Services | Armed Services | 2026-05-12 | 2026-05-12 | 0 | 1 | Pending | ||
| 119-996-00 | 119 | 996 | 00 | PN996 | Military nomination — Armed Services | Armed Services | 2026-05-12 | 2026-05-12 | 0 | 1 | Pending | ||
| 119-997-00 | 119 | 997 | 00 | PN997 | Military nomination — Armed Services | Armed Services | 2026-05-12 | 2026-05-12 | 0 | 1 | Pending | ||
| 119-998-00 | 119 | 998 | 00 | PN998 | Military nomination — Armed Services | Armed Services | 2026-05-12 | 2026-05-12 | 0 | 1 | Pending | ||
| 119-999-01 | 119 | 999 | 01 | PN999-1 | Angela Veronica Colmenero, of Texas, to be United States District Judge for the Southern District of Texas, vice Lee H. Rosenthal, retired. | The Judiciary | 2026-05-12 | 2026-05-12 | 1 | 0 | Pending | ||
| 119-999-02 | 119 | 999 | 02 | PN999-2 | Daniel Desmond Domenico, of Colorado, to be United States Circuit Judge for the Tenth Circuit, vice Timothy M. Tymkovich, retiring. | The Judiciary | 2026-05-12 | 2026-05-12 | 1 | 0 | Pending | ||
| 119-999-03 | 119 | 999 | 03 | PN999-3 | Michael C. Martin, of Michigan, to be United States District Judge for the Eastern District of Michigan, vice Sean F. Cox, retired. | The Judiciary | 2026-05-12 | 2026-05-12 | 1 | 0 | Pending | ||
| 119-999-04 | 119 | 999 | 04 | PN999-4 | Kasdin Miller Mitchell, of Texas, to be United States District Judge for the Northern District of Texas, vice Barbara M. Lynn, retired. | The Judiciary | 2026-05-12 | 2026-05-12 | 1 | 0 | Pending | ||
| 119-999-05 | 119 | 999 | 05 | PN999-5 | Antonio M. Pozos, of Pennsylvania, to be United States District Judge for the Eastern District of Pennsylvania, vice Mitchell S. Goldberg, retired. | The Judiciary | 2026-05-12 | 2026-05-12 | 1 | 0 | Pending | ||
| 119-999-06 | 119 | 999 | 06 | PN999-6 | Daniel Mack Traynor, of North Dakota, to be United States Circuit Judge for the Eighth Circuit, vice Ralph R. Erickson, retiring. | The Judiciary | 2026-05-12 | 2026-05-12 | 1 | 0 | Pending | ||
| 119-961-01 | 119 | 961 | 01 | PN961-1 | Francis Brooke, of Virginia, to be Deputy Secretary of the Treasury, vice Michael Faulkender. | Department of the Treasury | 2026-05-11 | 2026-05-11 | 1 | 0 | Pending | ||
| 119-961-02 | 119 | 961 | 02 | PN961-2 | Cameron Hamilton, of Virginia, to be Administrator of the Federal Emergency Management Agency, Department of Homeland Security, vice Deanne Bennett Criswell, resigned. | Department of Homeland Security | 2026-05-11 | 2026-05-11 | 1 | 0 | Pending | ||
| 119-961-03 | 119 | 961 | 03 | PN961-3 | Brendan Hanrahan, of New York, to be an Assistant Secretary of State (European and Eurasian Affairs), vice James C. O'Brien, resigned. | Department of State | 2026-05-11 | 2026-05-11 | 1 | 0 | Pending | ||
| 119-961-04 | 119 | 961 | 04 | PN961-4 | Karen Jean Hedlund, of New York, to be a Member of the Surface Transportation Board for a term expiring December 31, 2030. (Reappointment) | Surface Transportation Board | 2026-05-11 | 2026-05-11 | 1 | 0 | Pending | ||
| 119-961-05 | 119 | 961 | 05 | PN961-5 | Kari Lake, of Arizona, to be Ambassador Extraordinary and Plenipotentiary of the United States of America to Jamaica. | Department of State | 2026-05-11 | 2026-05-11 | 1 | 0 | Pending | ||
| 119-961-06 | 119 | 961 | 06 | PN961-6 | Douglas Mastriano, of Pennsylvania, to be Ambassador Extraordinary and Plenipotentiary of the United States of America to the Slovak Republic. | Department of State | 2026-05-11 | 2026-05-11 | 1 | 0 | Pending | ||
| 119-961-07 | 119 | 961 | 07 | PN961-7 | Brett Matsumoto, of Maryland, to be Commissioner of Labor Statistics, Department of Labor, for a term of four years, vice Erika L. McEntarfer. | Department of Labor | 2026-05-11 | 2026-05-11 | 1 | 0 | Pending | ||
| 119-961-08 | 119 | 961 | 08 | PN961-8 | Douglas Ralph, of Kentucky, to be a Member of the National Mediation Board for a term expiring July 1, 2028, vice Deirdre Hamilton, term expired. | National Mediation Board | 2026-05-11 | 2026-05-11 | 1 | 0 | Pending | ||
| 119-961-09 | 119 | 961 | 09 | PN961-9 | Barbera Thornhill, of North Carolina, to be Director of the Office to Monitor and Combat Trafficking, with the rank of Ambassador at Large, vice Cynthia Dyer, resigned. | Department of State | 2026-05-11 | 2026-05-11 | 1 | 0 | Pending | ||
| 119-962-01 | 119 | 962 | 01 | PN962-1 | David Cummins, of Virginia, to be Administrator of the Transportation Security Administration for a term of five years, vice David P. Pekoske. | Department of Homeland Security | 2026-05-11 | 2026-05-11 | 1 | 0 | Pending | ||
| 119-962-02 | 119 | 962 | 02 | PN962-2 | Heidi Semann, of Missouri, to be Inspector General, Department of Education, vice Sandra D. Bruce. | Department of Education | 2026-05-11 | 2026-05-11 | 1 | 0 | Pending | ||
| 119-962-03 | 119 | 962 | 03 | PN962-3 | John Crews, of Virginia, to be a Member of the National Credit Union Administration Board for a term expiring August 2, 2031, vice Kyle Hauptman, term expired. | National Credit Union Administration | 2026-05-11 | 2026-05-11 | 1 | 0 | Pending | ||
| 119-963-00 | 119 | 963 | 00 | PN963 | Nicole Saphier, of New Jersey, 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 | 2026-05-11 | 2026-05-11 | 1 | 0 | Pending | ||
| 119-964-00 | 119 | 964 | 00 | PN964 | Military nomination — Armed Services | Armed Services | 2026-05-11 | 2026-05-11 | 0 | 1 | Pending | ||
| 119-965-00 | 119 | 965 | 00 | PN965 | Military nomination — Armed Services | Armed Services | 2026-05-11 | 2026-05-11 | 0 | 1 | Pending | ||
| 119-966-00 | 119 | 966 | 00 | PN966 | Military nomination — Armed Services | Armed Services | 2026-05-11 | 2026-05-11 | 0 | 1 | Pending | ||
| 119-967-00 | 119 | 967 | 00 | PN967 | Military nomination — Armed Services | Armed Services | 2026-05-11 | 2026-05-11 | 0 | 1 | Pending | ||
| 119-939-00 | 119 | 939 | 00 | PN939 | Military nomination — Armed Services | Armed Services | 2026-04-30 | 2026-04-30 | 0 | 1 | Pending | ||
| 119-940-00 | 119 | 940 | 00 | PN940 | Military nomination — Armed Services | Armed Services | 2026-04-30 | 2026-04-30 | 0 | 1 | Pending | ||
| 119-941-00 | 119 | 941 | 00 | PN941 | Military nomination — Armed Services | Armed Services | 2026-04-30 | 2026-04-30 | 0 | 1 | Pending | ||
| 119-942-00 | 119 | 942 | 00 | PN942 | Military nomination — Armed Services | Armed Services | 2026-04-30 | 2026-04-30 | 0 | 1 | Pending | ||
| 119-943-00 | 119 | 943 | 00 | PN943 | Military nomination — Armed Services | Armed Services | 2026-04-30 | 2026-04-30 | 0 | 1 | Pending | ||
| 119-944-00 | 119 | 944 | 00 | PN944 | Military nomination — Armed Services | Armed Services | 2026-04-30 | 2026-04-30 | 0 | 1 | Pending | ||
| 119-945-00 | 119 | 945 | 00 | PN945 | Military nomination — Armed Services | Armed Services | 2026-04-30 | 2026-04-30 | 0 | 1 | Pending | ||
| 119-946-00 | 119 | 946 | 00 | PN946 | Military nomination — Armed Services | Armed Services | 2026-04-30 | 2026-04-30 | 0 | 1 | Pending | ||
| 119-947-00 | 119 | 947 | 00 | PN947 | Military nomination — Armed Services | Armed Services | 2026-04-30 | 2026-04-30 | 0 | 1 | Pending | ||
| 119-948-00 | 119 | 948 | 00 | PN948 | Military nomination — Armed Services | Armed Services | 2026-04-30 | 2026-04-30 | 0 | 1 | Pending | ||
| 119-949-00 | 119 | 949 | 00 | PN949 | Military nomination — Armed Services | Armed Services | 2026-04-30 | 2026-04-30 | 0 | 1 | Pending | ||
| 119-950-00 | 119 | 950 | 00 | PN950 | Military nomination — Armed Services | Armed Services | 2026-04-30 | 2026-04-30 | 0 | 1 | Pending | ||
| 119-951-00 | 119 | 951 | 00 | PN951 | Military nomination — Armed Services | Armed Services | 2026-04-30 | 2026-04-30 | 0 | 1 | Pending | ||
| 119-952-00 | 119 | 952 | 00 | PN952 | Military nomination — Armed Services | Armed Services | 2026-04-30 | 2026-04-30 | 0 | 1 | Pending | ||
| 119-953-00 | 119 | 953 | 00 | PN953 | Military nomination — Armed Services | Armed Services | 2026-04-30 | 2026-04-30 | 0 | 1 | Pending | ||
| 119-954-00 | 119 | 954 | 00 | PN954 | Military nomination — Armed Services | Armed Services | 2026-04-30 | 2026-04-30 | 0 | 1 | Pending | ||
| 119-955-00 | 119 | 955 | 00 | PN955 | Military nomination — Armed Services | Armed Services | 2026-04-30 | 2026-04-30 | 0 | 1 | Pending | ||
| 119-956-00 | 119 | 956 | 00 | PN956 | Military nomination — Armed Services | Armed Services | 2026-04-30 | 2026-04-30 | 0 | 1 | Pending | ||
| 119-957-01 | 119 | 957 | 01 | PN957-1 | Military nomination — Armed Services | Armed Services | 2026-04-30 | 2026-04-30 | 0 | 1 | Pending | ||
| 119-957-02 | 119 | 957 | 02 | PN957-2 | Military nomination — Armed Services | Armed Services | 2026-04-30 | 2026-04-30 | 0 | 1 | Pending | ||
| 119-957-03 | 119 | 957 | 03 | PN957-3 | Military nomination — Armed Services | Armed Services | 2026-04-30 | 2026-04-30 | 0 | 1 | Pending | ||
| 119-958-00 | 119 | 958 | 00 | PN958 | Military nomination — Armed Services | Armed Services | 2026-04-30 | 2026-04-30 | 0 | 1 | Pending | ||
| 119-959-00 | 119 | 959 | 00 | PN959 | Military nomination — Armed Services | Armed Services | 2026-04-30 | 2026-04-30 | 0 | 1 | Pending | ||
| 119-937-01 | 119 | 937 | 01 | PN937-1 | David Brat, of Virginia, to be Ambassador Extraordinary and Plenipotentiary of the United States of America to the Commonwealth of Australia. | Department of State | 2026-04-27 | 2026-04-27 | 1 | 0 | Pending | ||
| 119-937-02 | 119 | 937 | 02 | PN937-2 | Hal Duncan, of Texas, to be Deputy Director of the Office of Management and Budget, vice James Bishop. | Executive Office of the President | 2026-04-27 | 2026-04-27 | 1 | 0 | Pending | ||
| 119-937-03 | 119 | 937 | 03 | PN937-3 | Sean Kaufman, of Georgia, to be Assistant Secretary for Preparedness and Response, Department of Health and Human Services, vice Dawn Myers O'Connell, resigned. | Department of Health and Human Services | 2026-04-27 | 2026-04-27 | 1 | 0 | Pending | ||
| 119-937-04 | 119 | 937 | 04 | PN937-4 | Jeffrey Ledbetter, of Virginia, to be Inspector General, Department of Housing and Urban Development, vice Rae Oliver. | Department of Housing and Urban Development | 2026-04-27 | 2026-04-27 | 1 | 0 | Pending | ||
| 119-937-05 | 119 | 937 | 05 | PN937-5 | George McMaster, of South Carolina, to be an Assistant Secretary of the Treasury, vice Joshua Frost, resigned. | Department of the Treasury | 2026-04-27 | 2026-04-27 | 1 | 0 | Pending | ||
| 119-937-06 | 119 | 937 | 06 | PN937-6 | Richard O'Malley, of Wisconsin, to be a Deputy Under Secretary of Defense, vice Radha Iyengar Plumb, resigned. | Department of Defense | 2026-04-27 | 2026-04-27 | 1 | 0 | Pending | ||
| 119-937-07 | 119 | 937 | 07 | PN937-7 | Juan Segura, of Virginia, to be an Assistant Secretary of State (Western Hemisphere Affairs), vice Brian A. Nichols. | Department of State | 2026-04-27 | 2026-04-30 | 1 | 0 | Pending | ||
| 119-937-08 | 119 | 937 | 08 | PN937-8 | Juan Segura, of Virginia, to be a Member of the Board of Directors of the Inter-American Foundation for a term expiring September 20, 2026, vice Adolfo A. Franco, term expired. | Inter-American Foundation | 2026-04-27 | 2026-04-27 | 1 | 0 | Pending | ||
| 119-937-09 | 119 | 937 | 09 | PN937-9 | Juan Segura, of Virginia, to be a Member of the Board of Directors of the Inter-American Foundation for a term expiring September 20, 2032. (Reappointment) | Inter-American Foundation | 2026-04-27 | 2026-04-27 | 1 | 0 | Pending | ||
| 119-937-10 | 119 | 937 | 10 | PN937-10 | Abby Warren, of Virginia, to be an Assistant Secretary of Commerce, vice Thea D. Rozman Kendler, resigned. | Department of Commerce | 2026-04-27 | 2026-04-27 | 1 | 0 | Pending | ||
| 119-938-01 | 119 | 938 | 01 | PN938-1 | Benjamin M. Flowers, of Ohio, to be United States Circuit Judge for the Sixth Circuit, vice Jeffrey S. Sutton, retiring. | The Judiciary | 2026-04-27 | 2026-04-27 | 1 | 0 | Pending | ||
| 119-938-02 | 119 | 938 | 02 | PN938-2 | Matthew A. Schwartz, of New York, to be United States Circuit Judge for the Second Circuit, vice Debra Ann Livingston, retiring. | The Judiciary | 2026-04-27 | 2026-04-27 | 1 | 0 | Pending | ||
| 119-931-01 | 119 | 931 | 01 | PN931-1 | Riley Barnes, of Texas, to be Director of the Peace Corps, vice Carol Spahn, resigned. | Peace Corps | 2026-04-21 | 2026-04-21 | 1 | 0 | Pending | ||
| 119-931-02 | 119 | 931 | 02 | PN931-2 | Rudolph Bauer, of South Carolina, to be Ambassador Extraordinary and Plenipotentiary of the United States of America to Belize. | Department of State | 2026-04-21 | 2026-04-21 | 1 | 0 | Pending | ||
| 119-931-03 | 119 | 931 | 03 | PN931-3 | Sean Costello, of Alabama, to be United States Attorney for the Southern District of Alabama for the term of four years, vice Richard W. Moore, resigned. | Department of Justice | 2026-04-21 | 2026-04-21 | 1 | 0 | Pending | ||
| 119-931-04 | 119 | 931 | 04 | PN931-4 | Erich Hernandez-Baquero, of Florida, to be an Assistant Secretary of the Air Force, vice Frank Calvelli, resigned. | Department of Defense | 2026-04-21 | 2026-04-21 | 1 | 0 | Pending | ||
| 119-931-05 | 119 | 931 | 05 | PN931-5 | Roger Mason, of Virginia, to be Director of the National Reconnaissance Office, vice Christopher Scolese, resigned. | Department of Defense | 2026-04-21 | 2026-04-21 | 1 | 0 | Pending | ||
| 119-931-06 | 119 | 931 | 06 | PN931-6 | Christopher Phelan, of Minnesota, to be Chairman of the Council of Economic Advisers, vice Stephen Miran, resigned. | Executive Office of the President | 2026-04-21 | 2026-04-21 | 1 | 0 | Pending | ||
| 119-931-07 | 119 | 931 | 07 | PN931-7 | Gary Shatswell, of Washington, to be an Assistant Secretary of Veterans Affairs (Information and Technology), vice Kurt D. DelBene, resigned. | Department of Veterans Affairs | 2026-04-21 | 2026-04-21 | 1 | 0 | Pending | ||
| 119-932-00 | 119 | 932 | 00 | PN932 | Erica Schwartz, of Florida, to be Director of the Centers for Disease Control and Prevention, vice Susan Monarez. | Department of Health and Human Services | 2026-04-21 | 2026-04-21 | 1 | 0 | Pending | ||
| 119-933-00 | 119 | 933 | 00 | PN933 | Don Richard Berthiaume, Jr., of Virginia, to be Inspector General, Department of Justice, vice Michael E. Horowitz. | Department of Justice | 2026-04-21 | 2026-04-21 | 1 | 0 | Pending | ||
| 119-934-00 | 119 | 934 | 00 | PN934 | Military nomination — Armed Services | Armed Services | 2026-04-21 | 2026-04-21 | 0 | 1 | Pending | ||
| 119-935-00 | 119 | 935 | 00 | PN935 | Military nomination — Armed Services | Armed Services | 2026-04-21 | 2026-04-21 | 0 | 1 | Pending |
Advanced export
JSON shape: default, array, newline-delimited, object
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);