plum_book_appointees

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

38,740 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: edition_year, appt_type, pay_plan, level_grade, is_vacant, is_career, source_pdf

appointee_id ▼ edition_year agency sub_office location position_title name_full name_normalized name_first name_last appt_type pay_plan level_grade is_vacant is_career source_pdf source_page
1 2004 [COMMITTEE PRINT] ARCHITECT OF THE CAPITOL Washington, DC Architect of the Capitol Alan M. Hantman ALAN M. HANTMAN Alan Hantman PAS EX III 0 0 plumbook-2004.pdf 9
2 2004 [COMMITTEE PRINT] OFFICE OF THE PUBLIC PRINTER Washington, DC Public Printer Bruce R. James BRUCE R. JAMES Bruce James PAS EX II 0 0 plumbook-2004.pdf 9
3 2004 [COMMITTEE PRINT] OFFICE OF THE PUBLIC PRINTER Do Deputy Public Printer Office of the Chief of Staff William H. Turri WILLIAM H. TURRI William Turri XS EX III 0 0 plumbook-2004.pdf 9
4 2004 LIBRARIAN OF CONGRESS   Washington, DC Librarian of Congress LIBRARY OF CONGRESS TRUST FUND BOARD Dr. James H. Billington DR. JAMES H. BILLINGTON Dr Billington PAS EX II 0 0 plumbook-2004.pdf 9
5 2004 LIBRARIAN OF CONGRESS   Do Ex-Officio (Chair) do DO     PAS WC   0 0 plumbook-2004.pdf 9
6 2004 LIBRARIAN OF CONGRESS   Do Ex-Officio Member (Secretary of the Treas- Honorable John Snow ury)         PAS WC   1 0 plumbook-2004.pdf 9
7 2004 LIBRARIAN OF CONGRESS   Do Ex-Officio Member (Chairman, Joint Com- Honorable Ted Stevens mittee on the Library) Senate         XS WC   1 0 plumbook-2004.pdf 9
8 2004 LIBRARIAN OF CONGRESS   Do Ex-Officio Member (Vice Chairman, Joint Honorable Vernon W resentatives         XS WC   1 0 plumbook-2004.pdf 9
9 2004 LIBRARIAN OF CONGRESS   Dallas, TX Member Ruth Altshuler RUTH ALTSHULER Ruth Altshuler PA WC   0 0 plumbook-2004.pdf 9
10 2004 LIBRARIAN OF CONGRESS   Bethesda, MD do B. Francis Saul II B. FRANCIS SAUL II B Saul PA WC   0 0 plumbook-2004.pdf 9
11 2004 LIBRARIAN OF CONGRESS   New York, NY do Leo J. Hindery Jr LEO J. HINDERY JR Leo Hindery XS WC   0 0 plumbook-2004.pdf 9
12 2004 LIBRARIAN OF CONGRESS   Do do John W. Kluge JOHN W. KLUGE John Kluge XS WC   0 0 plumbook-2004.pdf 9
13 2004 LIBRARIAN OF CONGRESS   Dallas, TX do Tom Luce TOM LUCE Tom Luce XS WC   0 0 plumbook-2004.pdf 9
14 2004 LIBRARIAN OF CONGRESS   Waco, TX do Bernard Rapoport BERNARD RAPOPORT Bernard Rapoport XS WC   0 0 plumbook-2004.pdf 9
15 2004 LIBRARIAN OF CONGRESS   Grand Rapids, MI do Elizabeth DeVos ELIZABETH DEVOS Elizabeth DeVos XS WC   0 0 plumbook-2004.pdf 9
16 2004 LIBRARIAN OF CONGRESS   San Francisco, CA do OLIVER WENDELL HOLMES DEVISE J. Richard Fredericks J. RICHARD FREDERICKS J Fredericks XS WC   0 0 plumbook-2004.pdf 9
17 2004 LIBRARIAN OF CONGRESS   Washington, DC Member Maeva Marcus MAEVA MARCUS Maeva Marcus PAS WC   0 0 plumbook-2004.pdf 9
18 2004 LIBRARIAN OF CONGRESS   Do do Robert Cottrol ROBERT COTTROL Robert Cottrol PAS WC   0 0 plumbook-2004.pdf 9
19 2004 LIBRARIAN OF CONGRESS   Do do Allison Eid ALLISON EID Allison Eid PAS WC   0 0 plumbook-2004.pdf 9
20 2004 LIBRARIAN OF CONGRESS   Do do Timothy Hagle TIMOTHY HAGLE Timothy Hagle PAS WC   0 0 plumbook-2004.pdf 9
21 2004 LIBRARIAN OF CONGRESS AMERICAN FOLKLIFE CENTER BOARD Durham, NC Chairman Thomas S. Rankin THOMAS S. RANKIN Thomas Rankin XS WC   0 0 plumbook-2004.pdf 10
22 2004 LIBRARIAN OF CONGRESS AMERICAN FOLKLIFE CENTER BOARD Washington, DC Ex-Officio Member Dr. James H. Billington DR. JAMES H. BILLINGTON Dr Billington PAS WC   0 0 plumbook-2004.pdf 10
23 2004 LIBRARIAN OF CONGRESS AMERICAN FOLKLIFE CENTER BOARD Do Ex-Officio Member (Secretary of the Smithso- Honorable Lawrence M.         PAS WC   1 0 plumbook-2004.pdf 10
24 2004 LIBRARIAN OF CONGRESS AMERICAN FOLKLIFE CENTER BOARD Do Ex-Officio Member (Chairman, National En- Dana Gioia dowment for the Arts)         PAS WC   1 0 plumbook-2004.pdf 10
25 2004 LIBRARIAN OF CONGRESS AMERICAN FOLKLIFE CENTER BOARD Do Ex-Officio Member (Chairman, National En- Bruce Cole dowment for the Humanities)         PAS WC   1 0 plumbook-2004.pdf 10
26 2004 LIBRARIAN OF CONGRESS AMERICAN FOLKLIFE CENTER BOARD Do Ex-Officio Member Timothy Rice TIMOTHY RICE Timothy Rice PAS WC   0 0 plumbook-2004.pdf 10
27 2004 LIBRARIAN OF CONGRESS AMERICAN FOLKLIFE CENTER BOARD Do Ex-Officio Member (President-Elect American Michael Owens Jones Folklore Society, World Arts and Cultures/ Folklore)         PAS WC   1 0 plumbook-2004.pdf 10
28 2004 LIBRARIAN OF CONGRESS AMERICAN FOLKLIFE CENTER BOARD New York, NY Member Dr. Daniel Botkin DR. DANIEL BOTKIN Dr Botkin XS WC   0 0 plumbook-2004.pdf 10
29 2004 LIBRARIAN OF CONGRESS AMERICAN FOLKLIFE CENTER BOARD Spokane, WA do John Penn Fix III JOHN PENN FIX III John Fix XS WC   0 0 plumbook-2004.pdf 10
30 2004 LIBRARIAN OF CONGRESS AMERICAN FOLKLIFE CENTER BOARD Sebastopol, CA do Mickey Hart MICKEY HART Mickey Hart XS WC   0 0 plumbook-2004.pdf 10
31 2004 LIBRARIAN OF CONGRESS AMERICAN FOLKLIFE CENTER BOARD Pierre, SD do Dennis Holub DENNIS HOLUB Dennis Holub XS WC   0 0 plumbook-2004.pdf 10
32 2004 LIBRARIAN OF CONGRESS AMERICAN FOLKLIFE CENTER BOARD Bennettsville, SC do William L. Kinney Jr WILLIAM L. KINNEY JR William Kinney XS WC   0 0 plumbook-2004.pdf 10
33 2004 LIBRARIAN OF CONGRESS AMERICAN FOLKLIFE CENTER BOARD Urbana, IL do Dr. Judith McCulloh DR. JUDITH MCCULLOH Dr McCulloh XS WC   0 0 plumbook-2004.pdf 10
34 2004 LIBRARIAN OF CONGRESS AMERICAN FOLKLIFE CENTER BOARD Tesuque, NM do Marlene Meyerson MARLENE MEYERSON Marlene Meyerson XS WC   0 0 plumbook-2004.pdf 10
35 2004 LIBRARIAN OF CONGRESS AMERICAN FOLKLIFE CENTER BOARD Cambridge, MA do Shelemay Dr. Kay Kaufman DR. KAY KAUFMAN Dr Kaufman XS WC   0 0 plumbook-2004.pdf 10
36 2004 LIBRARIAN OF CONGRESS AMERICAN FOLKLIFE CENTER BOARD Washington, DC Member (Director, National Park Service) Honorable Fran Mainella HONORABLE FRAN MAINELLA Honorable Mainella PA WC   0 0 plumbook-2004.pdf 10
37 2004 LIBRARIAN OF CONGRESS AMERICAN FOLKLIFE CENTER BOARD Do Member (Secretary for Public and Intergov- Honorable Cynthia R Affairs)         PA WC   1 0 plumbook-2004.pdf 10
38 2004 LIBRARIAN OF CONGRESS AMERICAN FOLKLIFE CENTER BOARD Do Member (Deputy Director of Projects, Office Sonya E. Medina of the First Lady)         PA WC   1 0 plumbook-2004.pdf 10
39 2004 LIBRARIAN OF CONGRESS AMERICAN FOLKLIFE CENTER BOARD Do Member (Assistant Secretary, Indian Affairs, David Wayne Anderson Department of the Interior)         PA WC   1 0 plumbook-2004.pdf 10
40 2004 LIBRARIAN OF CONGRESS AMERICAN FOLKLIFE CENTER BOARD Do do Kojo Nnamdi KOJO NNAMDI Kojo Nnamdi XS WC   0 0 plumbook-2004.pdf 10
41 2004 LIBRARIAN OF CONGRESS SECRETARIES TO THE JUDGES Do Secretary (Confidential Assistant) Mary Lou Adkins-Palumbo MARY LOU ADKINS-PALUMBO Mary Adkins-Palumbo SC GS 11 0 0 plumbook-2004.pdf 10
42 2004 LIBRARIAN OF CONGRESS SECRETARIES TO THE JUDGES Do do Mary Ann Bivens MARY ANN BIVENS Mary Bivens SC GS 11 0 0 plumbook-2004.pdf 10
43 2004 LIBRARIAN OF CONGRESS SECRETARIES TO THE JUDGES Do do Victoria L. Bowen VICTORIA L. BOWEN Victoria Bowen SC GS 11 0 0 plumbook-2004.pdf 10
44 2004 LIBRARIAN OF CONGRESS SECRETARIES TO THE JUDGES Do do Jo Brett JO BRETT Jo Brett SC GS 11 0 0 plumbook-2004.pdf 10
45 2004 LIBRARIAN OF CONGRESS SECRETARIES TO THE JUDGES Do do Shirley Crawford SHIRLEY CRAWFORD Shirley Crawford SC GS 11 0 0 plumbook-2004.pdf 10
46 2004 LIBRARIAN OF CONGRESS SECRETARIES TO THE JUDGES Do do Mary Crutchfield MARY CRUTCHFIELD Mary Crutchfield SC GS 11 0 0 plumbook-2004.pdf 10
47 2004 LIBRARIAN OF CONGRESS SECRETARIES TO THE JUDGES Do do Nancy J. Darabpour NANCY J. DARABPOUR Nancy Darabpour SC GS 11 0 0 plumbook-2004.pdf 10
48 2004 LIBRARIAN OF CONGRESS SECRETARIES TO THE JUDGES Do do Jean Douglas JEAN DOUGLAS Jean Douglas SC GS 11 0 0 plumbook-2004.pdf 10
49 2004 LIBRARIAN OF CONGRESS SECRETARIES TO THE JUDGES Do do Joan Ewing JOAN EWING Joan Ewing SC GS 11 0 0 plumbook-2004.pdf 10
50 2004 LIBRARIAN OF CONGRESS SECRETARIES TO THE JUDGES Do do Terry Farr TERRY FARR Terry Farr SC GS 11 0 0 plumbook-2004.pdf 10
51 2004 LIBRARIAN OF CONGRESS SECRETARIES TO THE JUDGES Do do Patricia Flagg PATRICIA FLAGG Patricia Flagg SC GS 11 0 0 plumbook-2004.pdf 10
52 2004 LIBRARIAN OF CONGRESS SECRETARIES TO THE JUDGES Do do Dorothy Graham DOROTHY GRAHAM Dorothy Graham SC GS 11 0 0 plumbook-2004.pdf 10
53 2004 LIBRARIAN OF CONGRESS SECRETARIES TO THE JUDGES Do do Diane M. Groves DIANE M. GROVES Diane Groves SC GS 11 0 0 plumbook-2004.pdf 10
54 2004 LIBRARIAN OF CONGRESS SECRETARIES TO THE JUDGES Washington, DC Secretary (Confidential Assistant) Dolores Hill DOLORES HILL Dolores Hill SC GS 11 0 0 plumbook-2004.pdf 11
55 2004 LIBRARIAN OF CONGRESS SECRETARIES TO THE JUDGES Do do Trelynda Kerr TRELYNDA KERR Trelynda Kerr SC GS 11 0 0 plumbook-2004.pdf 11
56 2004 LIBRARIAN OF CONGRESS SECRETARIES TO THE JUDGES Do do June Lawson JUNE LAWSON June Lawson SC GS 11 0 0 plumbook-2004.pdf 11
57 2004 LIBRARIAN OF CONGRESS SECRETARIES TO THE JUDGES Do do Velinda Morton-Payne VELINDA MORTON-PAYNE Velinda Morton-Payne SC GS 11 0 0 plumbook-2004.pdf 11
58 2004 LIBRARIAN OF CONGRESS SECRETARIES TO THE JUDGES Do do Marisa J. Nickerson MARISA J. NICKERSON Marisa Nickerson SC GS 11 0 0 plumbook-2004.pdf 11
59 2004 LIBRARIAN OF CONGRESS SECRETARIES TO THE JUDGES Do do Gay Rodey GAY RODEY Gay Rodey SC GS 11 0 0 plumbook-2004.pdf 11
60 2004 LIBRARIAN OF CONGRESS SECRETARIES TO THE JUDGES Do do Susan Sanders SUSAN SANDERS Susan Sanders SC GS 11 0 0 plumbook-2004.pdf 11
61 2004 LIBRARIAN OF CONGRESS SECRETARIES TO THE JUDGES Do do Betty Scott-Boom BETTY SCOTT-BOOM Betty Scott-Boom SC GS 11 0 0 plumbook-2004.pdf 11
62 2004 LIBRARIAN OF CONGRESS SECRETARIES TO THE JUDGES Do do Lolisa S. Simms LOLISA S. SIMMS Lolisa Simms SC GS 11 0 0 plumbook-2004.pdf 11
63 2004 LIBRARIAN OF CONGRESS SECRETARIES TO THE JUDGES Do do Gloria Thatcher GLORIA THATCHER Gloria Thatcher SC GS 11 0 0 plumbook-2004.pdf 11
64 2004 LIBRARIAN OF CONGRESS SECRETARIES TO THE JUDGES Do do Sharon Ward SHARON WARD Sharon Ward SC GS 11 0 0 plumbook-2004.pdf 11
65 2004 LIBRARIAN OF CONGRESS SECRETARIES TO THE JUDGES Do do Karen Lynn Woodard KAREN LYNN WOODARD Karen Woodard SC GS 11 0 0 plumbook-2004.pdf 11
66 2004 LIBRARIAN OF CONGRESS SECRETARIES TO THE JUDGES Do do TRIAL CLERKS         SC GS 11 1 0 plumbook-2004.pdf 11
67 2004 LIBRARIAN OF CONGRESS SECRETARIES TO THE JUDGES Do Trial Clerk Chad Muller Elkins CHAD MULLER ELKINS Chad Elkins SC GS 9 0 0 plumbook-2004.pdf 11
68 2004 LIBRARIAN OF CONGRESS SECRETARIES TO THE JUDGES Do do Davide Nicola Gadren DAVIDE NICOLA GADREN Davide Gadren SC GS 7 0 0 plumbook-2004.pdf 11
69 2004 LIBRARIAN OF CONGRESS SECRETARIES TO THE JUDGES Do do Ruxandra G. Gecui RUXANDRA G. GECUI Ruxandra Gecui SC GS 9 0 0 plumbook-2004.pdf 11
70 2004 LIBRARIAN OF CONGRESS SECRETARIES TO THE JUDGES Do do Stanley W. Hammer STANLEY W. HAMMER Stanley Hammer SC GS 7 0 0 plumbook-2004.pdf 11
71 2004 LIBRARIAN OF CONGRESS SECRETARIES TO THE JUDGES Do do Leah Heinecke-Krumhus LEAH HEINECKE-KRUMHUS Leah Heinecke-Krumhus SC GS 7 0 0 plumbook-2004.pdf 11
72 2004 LIBRARIAN OF CONGRESS SECRETARIES TO THE JUDGES Do do Ashley Morgan ASHLEY MORGAN Ashley Morgan SC GS 9 0 0 plumbook-2004.pdf 11
73 2004 LIBRARIAN OF CONGRESS SECRETARIES TO THE JUDGES Do do Papavasiliou Christopher W CHRISTOPHER W Christopher W SC GS 9 0 0 plumbook-2004.pdf 11
74 2004 LIBRARIAN OF CONGRESS SECRETARIES TO THE JUDGES Do do Mary Sutherland MARY SUTHERLAND Mary Sutherland SC GS 9 0 0 plumbook-2004.pdf 11
75 2004 LIBRARIAN OF CONGRESS SECRETARIES TO THE JUDGES Do do Verleysen Adriana Michelle ADRIANA MICHELLE Adriana Michelle SC GS 7 0 0 plumbook-2004.pdf 11
76 2004 LIBRARIAN OF CONGRESS SECRETARIES TO THE JUDGES Do do Brian K. Woody BRIAN K. WOODY Brian Woody SC GS 7 0 0 plumbook-2004.pdf 11
77 2004 LIBRARIAN OF CONGRESS SECRETARIES TO THE JUDGES Do do         SC GS 7 1 0 plumbook-2004.pdf 11
78 2004 EXECUTIVE OFFICE OF THE PRESIDENT WHITE HOUSE OFFICE Washington, DC Assistant to the President and Chief of Staff Andrew H. Card Jr         PA AD   1 0 plumbook-2004.pdf 12
79 2004 EXECUTIVE OFFICE OF THE PRESIDENT WHITE HOUSE OFFICE Do Assistant to the President for National Secu- Condoleezza Rice rity Affairs         PA AD   1 0 plumbook-2004.pdf 12
80 2004 EXECUTIVE OFFICE OF THE PRESIDENT WHITE HOUSE OFFICE Do Assistant to the President for Communica- Daniel Joseph Bartlett tions         PA AD   1 0 plumbook-2004.pdf 12
81 2004 EXECUTIVE OFFICE OF THE PRESIDENT WHITE HOUSE OFFICE Do Assistant to the President for Economic Pol- Stephen Friedman icy and Director, National Economic Coun- cil         PA AD   1 0 plumbook-2004.pdf 12
82 2004 EXECUTIVE OFFICE OF THE PRESIDENT WHITE HOUSE OFFICE Do Assistant to the President for Speechwriting Michael J. Gerson and Policy Advisor         PA AD   1 0 plumbook-2004.pdf 12
83 2004 EXECUTIVE OFFICE OF THE PRESIDENT WHITE HOUSE OFFICE Do Counsel to the President Alberto R. Gonzales ALBERTO R. GONZALES Alberto Gonzales PA AD   0 0 plumbook-2004.pdf 12
84 2004 EXECUTIVE OFFICE OF THE PRESIDENT WHITE HOUSE OFFICE Do Assistant to the President and Deputy Na- Stephen J. Hadley tional Security Advisor         PA AD   1 0 plumbook-2004.pdf 12
85 2004 EXECUTIVE OFFICE OF THE PRESIDENT WHITE HOUSE OFFICE Do Assistant to the President and Deputy Chief Joseph W. Hagin of Staff         PA AD   1 0 plumbook-2004.pdf 12
86 2004 EXECUTIVE OFFICE OF THE PRESIDENT WHITE HOUSE OFFICE Do Assistant to the President for Legislative Af- David W. Hobbs fairs         PA AD   1 0 plumbook-2004.pdf 12
87 2004 EXECUTIVE OFFICE OF THE PRESIDENT WHITE HOUSE OFFICE Do Assistant to the President and Staff Sec- Brett M. Kavanaugh retary         PA AD   1 0 plumbook-2004.pdf 12
88 2004 EXECUTIVE OFFICE OF THE PRESIDENT WHITE HOUSE OFFICE Do Assistant to the President and Chief of Staff I. Lewis Libby to the Vice President         PA AD   1 0 plumbook-2004.pdf 12
89 2004 EXECUTIVE OFFICE OF THE PRESIDENT WHITE HOUSE OFFICE Do Assistant to the President and Press Sec- Scott K. McClellan retary         PA AD   1 0 plumbook-2004.pdf 12
90 2004 EXECUTIVE OFFICE OF THE PRESIDENT WHITE HOUSE OFFICE Do Assistant to the President and Deputy Chief Harriet E. Miers of Staff         PA AD   1 0 plumbook-2004.pdf 12
91 2004 EXECUTIVE OFFICE OF THE PRESIDENT WHITE HOUSE OFFICE Do Assistant to the President for Presidential Dina H. Powell Personnel         PA AD   1 0 plumbook-2004.pdf 12
92 2004 EXECUTIVE OFFICE OF THE PRESIDENT WHITE HOUSE OFFICE Do Senior Advisor to the President Karl C. Rove KARL C. ROVE Karl Rove PA AD   0 0 plumbook-2004.pdf 12
93 2004 EXECUTIVE OFFICE OF THE PRESIDENT WHITE HOUSE OFFICE Do Assistant to the President for Domestic Policy Margaret Mary Spellings         PA AD   1 0 plumbook-2004.pdf 12
94 2004 EXECUTIVE OFFICE OF THE PRESIDENT WHITE HOUSE OFFICE Do Assistant to the President for Homeland Se- Frances Fragos Townsend curity         PA AD   1 0 plumbook-2004.pdf 12
95 2004 EXECUTIVE OFFICE OF THE PRESIDENT WHITE HOUSE OFFICE Do Deputy Assistant to the President and Dep- Robert D. Blackwill uty National Security Advisor for Strategic Planning         PA AD   1 0 plumbook-2004.pdf 12
96 2004 EXECUTIVE OFFICE OF THE PRESIDENT WHITE HOUSE OFFICE Do Deputy Assistant to the President for Man- Linda M. Gambatesa agement, Administration and Oval Office Operations         PA AD   1 0 plumbook-2004.pdf 12
97 2004 EXECUTIVE OFFICE OF THE PRESIDENT WHITE HOUSE OFFICE Do Deputy Assistant to the President and Assist- Israel Hernandez ant to the Senior Advisor         PA AD   1 0 plumbook-2004.pdf 12
98 2004 EXECUTIVE OFFICE OF THE PRESIDENT WHITE HOUSE OFFICE Do Deputy Counsel to the President David G. Leitch DAVID G. LEITCH David Leitch PA AD   0 0 plumbook-2004.pdf 12
99 2004 EXECUTIVE OFFICE OF THE PRESIDENT WHITE HOUSE OFFICE Do Deputy Assistant to the President, Deputy John P. McConnell Director of Presidential Speechwriting and Assistant to the Vice President         PA AD   1 0 plumbook-2004.pdf 12
100 2004 EXECUTIVE OFFICE OF THE PRESIDENT WHITE HOUSE OFFICE Do Deputy Assistant to the President and Cabi- Brian D. Montgomery net Secretary         PA AD   1 0 plumbook-2004.pdf 12

Next page

Advanced export

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

CSV options: 

CREATE TABLE plum_book_appointees (
    appointee_id     INTEGER PRIMARY KEY AUTOINCREMENT,
    edition_year     INTEGER NOT NULL,
    agency           TEXT,
    sub_office       TEXT,
    location         TEXT,
    position_title   TEXT NOT NULL,
    name_full        TEXT,                 -- as printed
    name_normalized  TEXT,                 -- UPPER, comma/period stripped, "First Last"
    name_first       TEXT,
    name_last        TEXT,
    appt_type        TEXT,                 -- PAS | PA | NA | SC | CA | TA | XS
    pay_plan         TEXT,                 -- EX | ES | GS | SES | ...
    level_grade      TEXT,                 -- I,II,III,IV,V (EX) or 1-15 (GS) or empty (ES)
    is_vacant        INTEGER NOT NULL DEFAULT 0,
    is_career        INTEGER NOT NULL DEFAULT 0,    -- "Career Incumbent" (no individual named)
    source_pdf       TEXT,
    source_page      INTEGER
);
CREATE INDEX idx_pba_year ON plum_book_appointees(edition_year);
CREATE INDEX idx_pba_name ON plum_book_appointees(name_last, name_first);
CREATE INDEX idx_pba_norm ON plum_book_appointees(name_normalized);
CREATE INDEX idx_pba_appt ON plum_book_appointees(appt_type);
CREATE INDEX idx_pba_agency ON plum_book_appointees(agency);