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.
40,412 rows 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
| id | congress | number | part_number | citation | description | organization | received_date ▲ | authority_date | is_civilian | is_military | status | vote_yea | vote_nay |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 119-1092-00 | 119 | 1092 | 00 | PN1092 | Walter Clayton, of New York, to be Director of National Intelligence, vice Tulsi Gabbard. | Office of the Director of National Intelligence | 2026-06-11 | 2026-06-11 | 1 | 0 | Pending | ||
| 119-1090-00 | 119 | 1090 | 00 | PN1090 | Military nomination — Armed Services | Armed Services | 2026-06-10 | 2026-06-10 | 0 | 1 | Pending | ||
| 119-1089-00 | 119 | 1089 | 00 | PN1089 | Military nomination — Armed Services | Armed Services | 2026-06-10 | 2026-06-10 | 0 | 1 | Pending | ||
| 119-1088-00 | 119 | 1088 | 00 | PN1088 | Military nomination — Armed Services | Armed Services | 2026-06-10 | 2026-06-10 | 0 | 1 | Pending | ||
| 119-1087-00 | 119 | 1087 | 00 | PN1087 | Military nomination — Armed Services | Armed Services | 2026-06-10 | 2026-06-10 | 0 | 1 | Pending | ||
| 119-1086-00 | 119 | 1086 | 00 | PN1086 | Military nomination — Armed Services | Armed Services | 2026-06-10 | 2026-06-10 | 0 | 1 | Pending | ||
| 119-1085-00 | 119 | 1085 | 00 | PN1085 | Military nomination — Armed Services | Armed Services | 2026-06-10 | 2026-06-10 | 0 | 1 | Pending | ||
| 119-1084-00 | 119 | 1084 | 00 | PN1084 | Military nomination — Armed Services | Armed Services | 2026-06-10 | 2026-06-10 | 0 | 1 | Pending | ||
| 119-1083-00 | 119 | 1083 | 00 | PN1083 | Military nomination — Armed Services | Armed Services | 2026-06-10 | 2026-06-10 | 0 | 1 | Pending | ||
| 119-1082-00 | 119 | 1082 | 00 | PN1082 | Military nomination — Armed Services | Armed Services | 2026-06-10 | 2026-06-10 | 0 | 1 | Pending | ||
| 119-1081-00 | 119 | 1081 | 00 | PN1081 | Military nomination — Armed Services | Armed Services | 2026-06-10 | 2026-06-10 | 0 | 1 | Pending | ||
| 119-1080-00 | 119 | 1080 | 00 | PN1080 | Military nomination — Armed Services | Armed Services | 2026-06-10 | 2026-06-10 | 0 | 1 | Pending | ||
| 119-1079-00 | 119 | 1079 | 00 | PN1079 | Brian Johnson, of Ohio, to be Director, Bureau of Consumer Financial Protection for a term of five years, vice Rohit Chopra. | Bureau of Consumer Financial Protection | 2026-06-10 | 2026-06-10 | 1 | 0 | Pending | ||
| 119-1078-00 | 119 | 1078 | 00 | PN1078 | Todd Blanche, of Florida, to be Attorney General, vice Pamela Bondi. | Department of Justice | 2026-06-08 | 2026-06-08 | 1 | 0 | Pending | ||
| 119-1077-00 | 119 | 1077 | 00 | PN1077 | Military nomination — Commerce, Science, and Transportation | Commerce, Science, and Transportation | 2026-06-04 | 2026-06-04 | 0 | 1 | Pending | ||
| 119-1076-00 | 119 | 1076 | 00 | PN1076 | Military nomination — Armed Services | Armed Services | 2026-06-04 | 2026-06-04 | 0 | 1 | Pending | ||
| 119-1075-00 | 119 | 1075 | 00 | PN1075 | Military nomination — Armed Services | Armed Services | 2026-06-04 | 2026-06-04 | 0 | 1 | Pending | ||
| 119-1074-00 | 119 | 1074 | 00 | PN1074 | Military nomination — Armed Services | Armed Services | 2026-06-04 | 2026-06-04 | 0 | 1 | Pending | ||
| 119-1073-00 | 119 | 1073 | 00 | PN1073 | Military nomination — Armed Services | Armed Services | 2026-06-04 | 2026-06-04 | 0 | 1 | Pending | ||
| 119-1072-00 | 119 | 1072 | 00 | PN1072 | Military nomination — Armed Services | Armed Services | 2026-06-04 | 2026-06-04 | 0 | 1 | Pending | ||
| 119-1071-00 | 119 | 1071 | 00 | PN1071 | Military nomination — Armed Services | Armed Services | 2026-06-04 | 2026-06-04 | 0 | 1 | Pending | ||
| 119-1070-00 | 119 | 1070 | 00 | PN1070 | Military nomination — Armed Services | Armed Services | 2026-06-04 | 2026-06-04 | 0 | 1 | Pending | ||
| 119-1069-00 | 119 | 1069 | 00 | PN1069 | Military nomination — Armed Services | Armed Services | 2026-06-04 | 2026-06-04 | 0 | 1 | Pending | ||
| 119-1068-00 | 119 | 1068 | 00 | PN1068 | Military nomination — Armed Services | Armed Services | 2026-06-04 | 2026-06-04 | 0 | 1 | Pending | ||
| 119-1067-00 | 119 | 1067 | 00 | PN1067 | Military nomination — Armed Services | Armed Services | 2026-06-04 | 2026-06-04 | 0 | 1 | Pending | ||
| 119-1066-00 | 119 | 1066 | 00 | PN1066 | Military nomination — Armed Services | Armed Services | 2026-06-04 | 2026-06-04 | 0 | 1 | Pending | ||
| 119-1065-00 | 119 | 1065 | 00 | PN1065 | Military nomination — Armed Services | Armed Services | 2026-06-04 | 2026-06-04 | 0 | 1 | Pending | ||
| 119-1064-00 | 119 | 1064 | 00 | PN1064 | Military nomination — Armed Services | Armed Services | 2026-06-04 | 2026-06-04 | 0 | 1 | Pending | ||
| 119-1063-00 | 119 | 1063 | 00 | PN1063 | Military nomination — Armed Services | Armed Services | 2026-06-04 | 2026-06-04 | 0 | 1 | Pending | ||
| 119-1062-00 | 119 | 1062 | 00 | PN1062 | Military nomination — Armed Services | Armed Services | 2026-06-04 | 2026-06-04 | 0 | 1 | Pending | ||
| 119-1061-00 | 119 | 1061 | 00 | PN1061 | Military nomination — Armed Services | Armed Services | 2026-06-04 | 2026-06-04 | 0 | 1 | Pending | ||
| 119-1060-00 | 119 | 1060 | 00 | PN1060 | Military nomination — Armed Services | Armed Services | 2026-06-04 | 2026-06-04 | 0 | 1 | Pending | ||
| 119-1059-00 | 119 | 1059 | 00 | PN1059 | Military nomination — Armed Services | Armed Services | 2026-06-04 | 2026-06-04 | 0 | 1 | Pending | ||
| 119-1058-00 | 119 | 1058 | 00 | PN1058 | Military nomination — Armed Services | Armed Services | 2026-06-04 | 2026-06-04 | 0 | 1 | Pending | ||
| 119-1057-00 | 119 | 1057 | 00 | PN1057 | Military nomination — Armed Services | Armed Services | 2026-06-04 | 2026-06-04 | 0 | 1 | Pending | ||
| 119-1056-00 | 119 | 1056 | 00 | PN1056 | Military nomination — Armed Services | Armed Services | 2026-06-04 | 2026-06-04 | 0 | 1 | Pending | ||
| 119-1055-00 | 119 | 1055 | 00 | PN1055 | Military nomination — Armed Services | Armed Services | 2026-06-04 | 2026-06-04 | 0 | 1 | Pending | ||
| 119-1054-00 | 119 | 1054 | 00 | PN1054 | Military nomination — Armed Services | Armed Services | 2026-06-04 | 2026-06-04 | 0 | 1 | Pending | ||
| 119-1053-00 | 119 | 1053 | 00 | PN1053 | Military nomination — Armed Services | Armed Services | 2026-06-04 | 2026-06-04 | 0 | 1 | Pending | ||
| 119-1052-00 | 119 | 1052 | 00 | PN1052 | Military nomination — Armed Services | Armed Services | 2026-06-04 | 2026-06-04 | 0 | 1 | Pending | ||
| 119-1051-00 | 119 | 1051 | 00 | PN1051 | Military nomination — Armed Services | Armed Services | 2026-06-04 | 2026-06-04 | 0 | 1 | Pending | ||
| 119-1050-00 | 119 | 1050 | 00 | PN1050 | Military nomination — Armed Services | Armed Services | 2026-06-04 | 2026-06-04 | 0 | 1 | Pending | ||
| 119-1049-00 | 119 | 1049 | 00 | PN1049 | Military nomination — Armed Services | Armed Services | 2026-06-04 | 2026-06-04 | 0 | 1 | Pending | ||
| 119-1048-00 | 119 | 1048 | 00 | PN1048 | Military nomination — Armed Services | Armed Services | 2026-06-04 | 2026-06-04 | 0 | 1 | Pending | ||
| 119-1047-00 | 119 | 1047 | 00 | PN1047 | Military nomination — Armed Services | Armed Services | 2026-06-04 | 2026-06-04 | 0 | 1 | Pending | ||
| 119-1046-00 | 119 | 1046 | 00 | PN1046 | Military nomination — Armed Services | Armed Services | 2026-06-04 | 2026-06-04 | 0 | 1 | Pending | ||
| 119-1045-00 | 119 | 1045 | 00 | PN1045 | Military nomination — Armed Services | Armed Services | 2026-06-01 | 2026-06-01 | 0 | 1 | Pending | ||
| 119-1044-00 | 119 | 1044 | 00 | PN1044 | Military nomination — Armed Services | Armed Services | 2026-06-01 | 2026-06-01 | 0 | 1 | Pending | ||
| 119-1043-00 | 119 | 1043 | 00 | PN1043 | Military nomination — Armed Services | Armed Services | 2026-06-01 | 2026-06-01 | 0 | 1 | Pending | ||
| 119-1042-00 | 119 | 1042 | 00 | PN1042 | Military nomination — Armed Services | Armed Services | 2026-06-01 | 2026-06-01 | 0 | 1 | Pending | ||
| 119-1041-00 | 119 | 1041 | 00 | PN1041 | Military nomination — Armed Services | Armed Services | 2026-06-01 | 2026-06-01 | 0 | 1 | Pending | ||
| 119-1040-00 | 119 | 1040 | 00 | PN1040 | Military nomination — Armed Services | Armed Services | 2026-06-01 | 2026-06-01 | 0 | 1 | Pending | ||
| 119-1039-00 | 119 | 1039 | 00 | PN1039 | Military nomination — Armed Services | Armed Services | 2026-06-01 | 2026-06-01 | 0 | 1 | Pending | ||
| 119-1038-00 | 119 | 1038 | 00 | PN1038 | Military nomination — Armed Services | Armed Services | 2026-06-01 | 2026-06-01 | 0 | 1 | Pending | ||
| 119-1037-00 | 119 | 1037 | 00 | PN1037 | Military nomination — Armed Services | Armed Services | 2026-06-01 | 2026-06-01 | 0 | 1 | Pending | ||
| 119-1036-00 | 119 | 1036 | 00 | PN1036 | Military nomination — Armed Services | Armed Services | 2026-06-01 | 2026-06-01 | 0 | 1 | Pending | ||
| 119-1035-00 | 119 | 1035 | 00 | PN1035 | Military nomination — Armed Services | Armed Services | 2026-06-01 | 2026-06-01 | 0 | 1 | Pending | ||
| 119-1034-00 | 119 | 1034 | 00 | PN1034 | Military nomination — Armed Services | Armed Services | 2026-06-01 | 2026-06-01 | 0 | 1 | Pending | ||
| 119-1033-00 | 119 | 1033 | 00 | PN1033 | Military nomination — Armed Services | Armed Services | 2026-06-01 | 2026-06-01 | 0 | 1 | Pending | ||
| 119-1032-00 | 119 | 1032 | 00 | PN1032 | Military nomination — Armed Services | Armed Services | 2026-06-01 | 2026-06-01 | 0 | 1 | Pending | ||
| 119-1031-00 | 119 | 1031 | 00 | PN1031 | Military nomination — Armed Services | Armed Services | 2026-06-01 | 2026-06-01 | 0 | 1 | Pending | ||
| 119-1030-00 | 119 | 1030 | 00 | PN1030 | Military nomination — Armed Services | Armed Services | 2026-06-01 | 2026-06-01 | 0 | 1 | Pending | ||
| 119-1029-00 | 119 | 1029 | 00 | PN1029 | Military nomination — Armed Services | Armed Services | 2026-06-01 | 2026-06-01 | 0 | 1 | Pending | ||
| 119-1028-00 | 119 | 1028 | 00 | PN1028 | Military nomination — Commerce, Science, and Transportation | Commerce, Science, and Transportation | 2026-06-01 | 2026-06-01 | 0 | 1 | Pending | ||
| 119-1027-00 | 119 | 1027 | 00 | PN1027 | Military nomination — Armed Services | Armed Services | 2026-06-01 | 2026-06-01 | 0 | 1 | Pending | ||
| 119-1026-00 | 119 | 1026 | 00 | PN1026 | Military nomination — Armed Services | Armed Services | 2026-06-01 | 2026-06-01 | 0 | 1 | Pending | ||
| 119-1025-00 | 119 | 1025 | 00 | PN1025 | Military nomination — Armed Services | Armed Services | 2026-06-01 | 2026-06-01 | 0 | 1 | Pending | ||
| 119-1024-00 | 119 | 1024 | 00 | PN1024 | Military nomination — Armed Services | Armed Services | 2026-06-01 | 2026-06-01 | 0 | 1 | Pending | ||
| 119-1023-00 | 119 | 1023 | 00 | PN1023 | Military nomination — Armed Services | Armed Services | 2026-06-01 | 2026-06-01 | 0 | 1 | Pending | ||
| 119-1022-40 | 119 | 1022 | 40 | PN1022-40 | Michael Young, of Utah, to be Ambassador Extraordinary and Plenipotentiary of the United States of America to the Republic of Serbia. | Department of State | 2026-06-01 | 2026-06-01 | 1 | 0 | Pending | ||
| 119-1022-39 | 119 | 1022 | 39 | PN1022-39 | Henry Wooster, of Virginia, a Career Member of the Senior Foreign Service, Class of Minister-Counselor, to be Ambassador Extraordinary and Plenipotentiary of the United States of America to the Republic of Kenya. | Department of State | 2026-06-01 | 2026-06-01 | 1 | 0 | Pending | ||
| 119-1022-38 | 119 | 1022 | 38 | PN1022-38 | Steven Weinhoeft, of Illinois, to be United States Attorney for the Southern District of Illinois for the term of four years, vice Rachelle L. Crowe. | Department of Justice | 2026-06-01 | 2026-06-01 | 1 | 0 | Pending | ||
| 119-1022-37 | 119 | 1022 | 37 | PN1022-37 | Robert Troester, of Oklahoma, to be United States Attorney for the Western District of Oklahoma for the term of four years, vice Timothy J. Downing, resigned. | Department of Justice | 2026-06-01 | 2026-06-01 | 1 | 0 | Pending | ||
| 119-1022-36 | 119 | 1022 | 36 | PN1022-36 | Daniel Travis, of California, a Career Member of the Senior Foreign Service, Class of Counselor, to be Ambassador Extraordinary and Plenipotentiary of the United States of America to the Republic of Sierra Leone. | Department of State | 2026-06-01 | 2026-06-01 | 1 | 0 | Pending | ||
| 119-1022-35 | 119 | 1022 | 35 | PN1022-35 | Bartholomew Thanhauser, of New York, to be a Member of the United States International Trade Commission for a term expiring December 16, 2027, vice David S. Johanson, term expired. | United States International Trade Commission | 2026-06-01 | 2026-06-01 | 1 | 0 | Pending | ||
| 119-1022-34 | 119 | 1022 | 34 | PN1022-34 | Laurence Socha, of Illinois, to be Ambassador Extraordinary and Plenipotentiary of the United States of America to the Republic of The Gambia. | Department of State | 2026-06-01 | 2026-06-01 | 1 | 0 | Pending | ||
| 119-1022-33 | 119 | 1022 | 33 | PN1022-33 | Peter Snyder, of Virginia, to be Ambassador Extraordinary and Plenipotentiary of the United States of America to the Republic of Ecuador. | Department of State | 2026-06-01 | 2026-06-01 | 1 | 0 | Pending | ||
| 119-1022-32 | 119 | 1022 | 32 | PN1022-32 | Seth Reister, of Florida, to be United States Marshal for the Northern District of Florida for the term of four years, vice R. Don Ladner, Jr., term expired. | Department of Justice | 2026-06-01 | 2026-06-01 | 1 | 0 | Pending | ||
| 119-1022-31 | 119 | 1022 | 31 | PN1022-31 | Daniel Perez, of Florida, to be Ambassador Extraordinary and Plenipotentiary of the United States of America to the Federative Republic of Brazil. | Department of State | 2026-06-01 | 2026-06-01 | 1 | 0 | Pending | ||
| 119-1022-30 | 119 | 1022 | 30 | PN1022-30 | Peter-Anthony Pappas, of New Jersey, to be a Member of the United States International Trade Commission for a term expiring June 16, 2035. (Reappointment) | United States International Trade Commission | 2026-06-01 | 2026-06-01 | 1 | 0 | Pending | ||
| 119-1022-29 | 119 | 1022 | 29 | PN1022-29 | Peter-Anthony Pappas, of New Jersey, to be a Member of the United States International Trade Commission for the remainder of the term expiring June 16, 2026, vice Randolph J. Stayin, resigned. | United States International Trade Commission | 2026-06-01 | 2026-06-01 | 1 | 0 | Pending | ||
| 119-1022-28 | 119 | 1022 | 28 | PN1022-28 | Nick Oberheiden, of Texas, to be Ambassador Extraordinary and Plenipotentiary of the United States of America to the Arab Republic of Egypt. | Department of State | 2026-06-01 | 2026-06-01 | 1 | 0 | Pending | ||
| 119-1022-27 | 119 | 1022 | 27 | PN1022-27 | Keith Noreika, of Pennsylvania, to be Ambassador Extraordinary and Plenipotentiary of the United States of America to the Republic of Lithuania. | Department of State | 2026-06-01 | 2026-06-01 | 1 | 0 | Pending | ||
| 119-1022-26 | 119 | 1022 | 26 | PN1022-26 | Samuel Negatu, of the District of Columbia, to be Member of the United States International Trade Commission for a term expiring June 16, 2029, vice F. Scott Kieff, term expired. | United States International Trade Commission | 2026-06-01 | 2026-06-01 | 1 | 0 | Pending | ||
| 119-1022-25 | 119 | 1022 | 25 | PN1022-25 | Christopher Nassar, of Oklahoma, to be United States Attorney for the Northern District of Oklahoma for the term of four years, vice R. Trent Shores, resigned. | Department of Justice | 2026-06-01 | 2026-06-01 | 1 | 0 | Pending | ||
| 119-1022-24 | 119 | 1022 | 24 | PN1022-24 | Nathaniel Morris, of Kentucky, to be Ambassador Extraordinary and Plenipotentiary of the United States of America to the Republic of Colombia. | Department of State | 2026-06-01 | 2026-06-01 | 1 | 0 | Pending | ||
| 119-1022-23 | 119 | 1022 | 23 | PN1022-23 | Peter McCoy, of South Carolina, to be Ambassador Extraordinary and Plenipotentiary of the United States of America to Montenegro. | Department of State | 2026-06-01 | 2026-06-01 | 1 | 0 | Pending | ||
| 119-1022-22 | 119 | 1022 | 22 | PN1022-22 | Brien Lorenze, of Virginia, to be a Commissioner of the Consumer Product Safety Commission for a term of seven years from October 27, 2024, vice Douglas Dziak, resigned. | Consumer Product Safety Commission | 2026-06-01 | 2026-06-01 | 1 | 0 | Pending | ||
| 119-1022-21 | 119 | 1022 | 21 | PN1022-21 | Maria Lopez, of Florida, to be Chairman of the Board of Veterans' Appeals for a term of six years, vice Jaime Areizaga-Soto, resigned. | Department of Veterans Affairs | 2026-06-01 | 2026-06-01 | 1 | 0 | Pending | ||
| 119-1022-20 | 119 | 1022 | 20 | PN1022-20 | Philip Lewis III, of Pennsylvania, to be United States Marshal for the Middle District of Pennsylvania for the term of four years, vice Martin J. Pane, term expired. | Department of Justice | 2026-06-01 | 2026-06-01 | 1 | 0 | Pending | ||
| 119-1022-19 | 119 | 1022 | 19 | PN1022-19 | Paul Kalmbach, of Ohio, to be Ambassador Extraordinary and Plenipotentiary of the United States of America to the Republic of Paraguay. | Department of State | 2026-06-01 | 2026-06-01 | 1 | 0 | Pending | ||
| 119-1022-18 | 119 | 1022 | 18 | PN1022-18 | Jennifer Johnson-Carroll, of Florida, to be Ambassador Extraordinary and Plenipotentiary of the United States of America to the Republic of Trinidad and Tobago. | Department of State | 2026-06-01 | 2026-06-01 | 1 | 0 | Pending | ||
| 119-1022-17 | 119 | 1022 | 17 | PN1022-17 | Daniel Johnson, of Pennsylvania, to be United States Attorney for the Western District of Pennsylvania for the term of four years, vice Eric G. Olshan. | Department of Justice | 2026-06-01 | 2026-06-01 | 1 | 0 | Pending | ||
| 119-1022-16 | 119 | 1022 | 16 | PN1022-16 | Ronald Johnson, of Massachusetts, to be Ambassador Extraordinary and Plenipotentiary of the United States of America to Bosnia and Herzegovina. | Department of State | 2026-06-01 | 2026-06-01 | 1 | 0 | Pending | ||
| 119-1022-15 | 119 | 1022 | 15 | PN1022-15 | John Hurley, of California, to be Representative of the United States of America to the Organization for Economic Cooperation and Development, with the rank of Ambassador. | Department of State | 2026-06-01 | 2026-06-01 | 1 | 0 | Pending | ||
| 119-1022-14 | 119 | 1022 | 14 | PN1022-14 | Douglas Holder, of Florida, to be Ambassador Extraordinary and Plenipotentiary of the United States of America to the Republic of Bulgaria. | Department of State | 2026-06-01 | 2026-06-01 | 1 | 0 | Pending | ||
| 119-1022-13 | 119 | 1022 | 13 | PN1022-13 | William Grayson, of California, to be Ambassador Extraordinary and Plenipotentiary of the United States of America to the Republic of Indonesia. | Department of State | 2026-06-01 | 2026-06-01 | 1 | 0 | Pending | ||
| 119-1022-12 | 119 | 1022 | 12 | PN1022-12 | Johnny Figueroa, of Tennessee, to be Ambassador at Large, Coordinator of United States Government Activities to Combat HIV/AIDS Globally. | Department of State | 2026-06-01 | 2026-06-01 | 1 | 0 | Pending | ||
| 119-1022-11 | 119 | 1022 | 11 | PN1022-11 | Johnny Figueroa, of Tennessee, to be Ambassador-At-Large for Global Health Security and Diplomacy. (New Position) | Department of State | 2026-06-01 | 2026-06-01 | 1 | 0 | Pending | ||
| 119-1022-10 | 119 | 1022 | 10 | PN1022-10 | Mark Cruz, of Oregon, to be Director of the Indian Health Service, Department of Health and Human Services, for the term of four years, vice Roselyn Tso, resigned. | Department of Health and Human Services | 2026-06-01 | 2026-06-01 | 1 | 0 | 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);