house_pre2016_office_totals

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

222,650 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: quarter, office_year, office_type

id ▼ quarter office_year office_type office_name category ytd_amount quarter_amount source_pdf
1 2009Q4 2009 other CLERK OF THE HOUSE MODULAR FURNITURE TOTALS 1556.2 1556.2 2009Q4_singlevolume.pdf
2 2009Q4 2009 other CLERK OF THE HOUSE OFFICE TOTALS 1556.2 1556.2 2009Q4_singlevolume.pdf
3 2009Q4 2009 other CLERK OF THE HOUSE OTHER SERVICES TOTALS   1300.0 2009Q4_singlevolume.pdf
4 2009Q4 2009 other CLERK OF THE HOUSE SUPPLIES AND MATERIALS TOTALS   208.2 2009Q4_singlevolume.pdf
5 2009Q4 2009 other CLERK OF THE HOUSE EQUIPMENT TOTALS   48.0 2009Q4_singlevolume.pdf
6 2009Q4 2009 other CLERK OF THE HOUSE MODULAR FURNITURE TOTALS   1556.2 2009Q4_singlevolume.pdf
7 2009Q4 2009 other CLERK OF THE HOUSE OFFICE TOTALS   1556.2 2009Q4_singlevolume.pdf
8 2009Q4 2009 other CLERK OF THE HOUSE OTHER SERVICES TOTALS   66900.37 2009Q4_singlevolume.pdf
9 2009Q4 2009 other CLERK OF THE HOUSE SUPPLIES AND MATERIALS TOTALS   599.28 2009Q4_singlevolume.pdf
10 2009Q4 2009 other CLERK OF THE HOUSE EQUIPMENT TOTALS   485066.97 2009Q4_singlevolume.pdf
11 2009Q4 2009 other CLERK OF THE HOUSE MODULAR FURNITURE TOTALS   552566.62 2009Q4_singlevolume.pdf
12 2009Q4 2009 other CLERK OF THE HOUSE OFFICE TOTALS   552566.62 2009Q4_singlevolume.pdf
13 2009Q4 2010 leadership OFFICE OF THE SPEAKER LEADERSHIP STATUTORY TOTALS 220964.58 220964.58 2009Q4_singlevolume.pdf
14 2009Q4 2010 leadership OFFICE OF THE SPEAKER LEADERSHIP LUMP SUM PERSONNEL TOTALS 904613.96 904613.96 2009Q4_singlevolume.pdf
15 2009Q4 2010 leadership OFFICE OF THE SPEAKER LEADERSHIP LUMP SUM NONPERS. TOTALS 90597.6 90597.6 2009Q4_singlevolume.pdf
16 2009Q4 2010 leadership OFFICE OF THE SPEAKER LEADERSHIP OFFICIAL EXPENSES TOTALS 813.43 813.43 2009Q4_singlevolume.pdf
17 2009Q4 2010 leadership OFFICE OF THE SPEAKER OFFICE TOTALS 1216989.57 1216989.57 2009Q4_singlevolume.pdf
18 2009Q4 2010 leadership OFFICE OF THE SPEAKER PERSONNEL COMPENSATION TOTALS   220964.58 2009Q4_singlevolume.pdf
19 2009Q4 2010 leadership OFFICE OF THE SPEAKER LEADERSHIP STATUTORY TOTALS   220964.58 2009Q4_singlevolume.pdf
20 2009Q4 2010 leadership OFFICE OF THE SPEAKER PERSONNEL COMPENSATION TOTALS   904613.96 2009Q4_singlevolume.pdf
21 2009Q4 2010 leadership OFFICE OF THE SPEAKER LEADERSHIP LUMP SUM PERSONNEL TOTALS   904613.96 2009Q4_singlevolume.pdf
22 2009Q4 2010 leadership OFFICE OF THE SPEAKER TRAVEL TOTALS   7164.05 2009Q4_singlevolume.pdf
23 2009Q4 2010 leadership OFFICE OF THE SPEAKER RENT, COMMUNICATION, UTILITIES TOTALS   10931.35 2009Q4_singlevolume.pdf
24 2009Q4 2010 leadership OFFICE OF THE SPEAKER PRINTING AND REPRODUCTION TOTALS   5101.17 2009Q4_singlevolume.pdf
25 2009Q4 2010 leadership OFFICE OF THE SPEAKER OTHER SERVICES TOTALS   16801.48 2009Q4_singlevolume.pdf
26 2009Q4 2010 leadership OFFICE OF THE SPEAKER SUPPLIES AND MATERIALS TOTALS   50599.55 2009Q4_singlevolume.pdf
27 2009Q4 2010 leadership OFFICE OF THE SPEAKER LEADERSHIP LUMP SUM NONPERS. TOTALS   90597.6 2009Q4_singlevolume.pdf
28 2009Q4 2010 leadership OFFICE OF THE SPEAKER SUPPLIES AND MATERIALS TOTALS   813.43 2009Q4_singlevolume.pdf
29 2009Q4 2010 leadership OFFICE OF THE SPEAKER LEADERSHIP OFFICIAL EXPENSES TOTALS   813.43 2009Q4_singlevolume.pdf
30 2009Q4 2010 leadership OFFICE OF THE SPEAKER OFFICE TOTALS   1216989.57 2009Q4_singlevolume.pdf
31 2009Q4 2009 leadership OFFICE OF THE SPEAKER PERSONNEL COMPENSATION TOTALS   6321.56 2009Q4_singlevolume.pdf
32 2009Q4 2009 leadership OFFICE OF THE SPEAKER LEADERSHIP LUMP SUM PERSONNEL TOTALS   6321.56 2009Q4_singlevolume.pdf
33 2009Q4 2009 leadership OFFICE OF THE SPEAKER TRAVEL TOTALS   6140.89 2009Q4_singlevolume.pdf
34 2009Q4 2009 leadership OFFICE OF THE SPEAKER RENT, COMMUNICATION, UTILITIES TOTALS   1579.29 2009Q4_singlevolume.pdf
35 2009Q4 2009 leadership OFFICE OF THE SPEAKER OTHER SERVICES TOTALS   153.85 2009Q4_singlevolume.pdf
36 2009Q4 2009 leadership OFFICE OF THE SPEAKER SUPPLIES AND MATERIALS TOTALS   14398.07 2009Q4_singlevolume.pdf
37 2009Q4 2009 leadership OFFICE OF THE SPEAKER LEADERSHIP LUMP SUM NONPERS. TOTALS   22272.1 2009Q4_singlevolume.pdf
38 2009Q4 2009 leadership OFFICE OF THE SPEAKER SUPPLIES AND MATERIALS TOTALS   67.5 2009Q4_singlevolume.pdf
39 2009Q4 2009 leadership OFFICE OF THE SPEAKER LEADERSHIP OFFICIAL EXPENSES TOTALS   67.5 2009Q4_singlevolume.pdf
40 2009Q4 2009 leadership OFFICE OF THE SPEAKER OFFICE TOTALS   28661.16 2009Q4_singlevolume.pdf
41 2009Q4 2010 leadership OFFICE OF THE MAJORITY LEADER LEADERSHIP STATUTORY TOTALS 110625.0 110625.0 2009Q4_singlevolume.pdf
42 2009Q4 2010 leadership OFFICE OF THE MAJORITY LEADER LEADERSHIP LUMP SUM PERSONNEL TOTALS 453349.89 453349.89 2009Q4_singlevolume.pdf
43 2009Q4 2010 leadership OFFICE OF THE MAJORITY LEADER LEADERSHIP LUMP SUM NONPERS. TOTALS 11757.55 11757.55 2009Q4_singlevolume.pdf
44 2009Q4 2010 leadership OFFICE OF THE MAJORITY LEADER LEADERSHIP OFFICIAL EXPENSES TOTALS 2499.99 2499.99 2009Q4_singlevolume.pdf
45 2009Q4 2010 leadership OFFICE OF THE MAJORITY LEADER OFFICE TOTALS 578232.43 578232.43 2009Q4_singlevolume.pdf
46 2009Q4 2010 leadership OFFICE OF THE MAJORITY LEADER PERSONNEL COMPENSATION TOTALS   110625.0 2009Q4_singlevolume.pdf
47 2009Q4 2010 leadership OFFICE OF THE MAJORITY LEADER LEADERSHIP STATUTORY TOTALS   110625.0 2009Q4_singlevolume.pdf
48 2009Q4 2010 leadership OFFICE OF THE MAJORITY LEADER PERSONNEL COMPENSATION TOTALS   453349.89 2009Q4_singlevolume.pdf
49 2009Q4 2010 leadership OFFICE OF THE MAJORITY LEADER LEADERSHIP LUMP SUM PERSONNEL TOTALS   453349.89 2009Q4_singlevolume.pdf
50 2009Q4 2010 leadership OFFICE OF THE MAJORITY LEADER TRAVEL TOTALS   75.75 2009Q4_singlevolume.pdf
51 2009Q4 2010 leadership OFFICE OF THE MAJORITY LEADER RENT, COMMUNICATION, UTILITIES TOTALS   84.5 2009Q4_singlevolume.pdf
52 2009Q4 2010 leadership OFFICE OF THE MAJORITY LEADER PRINTING AND REPRODUCTION TOTALS   6.4 2009Q4_singlevolume.pdf
53 2009Q4 2010 leadership OFFICE OF THE MAJORITY LEADER OTHER SERVICES TOTALS   222.81 2009Q4_singlevolume.pdf
54 2009Q4 2010 leadership OFFICE OF THE MAJORITY LEADER SUPPLIES AND MATERIALS TOTALS   11368.09 2009Q4_singlevolume.pdf
55 2009Q4 2010 leadership OFFICE OF THE MAJORITY LEADER LEADERSHIP LUMP SUM NONPERS. TOTALS   11757.55 2009Q4_singlevolume.pdf
56 2009Q4 2010 leadership OFFICE OF THE MAJORITY LEADER PERSONNEL BENEFITS TOTALS   2499.99 2009Q4_singlevolume.pdf
57 2009Q4 2010 leadership OFFICE OF THE MAJORITY LEADER LEADERSHIP OFFICIAL EXPENSES TOTALS   2499.99 2009Q4_singlevolume.pdf
58 2009Q4 2010 leadership OFFICE OF THE MAJORITY LEADER OFFICE TOTALS   578232.43 2009Q4_singlevolume.pdf
59 2009Q4 2009 leadership OFFICE OF THE MAJORITY LEADER PERSONNEL COMPENSATION TOTALS   4682.33 2009Q4_singlevolume.pdf
60 2009Q4 2009 leadership OFFICE OF THE MAJORITY LEADER LEADERSHIP LUMP SUM PERSONNEL TOTALS   4682.33 2009Q4_singlevolume.pdf
61 2009Q4 2009 leadership OFFICE OF THE MAJORITY LEADER TRAVEL TOTALS   44.97 2009Q4_singlevolume.pdf
62 2009Q4 2009 leadership OFFICE OF THE MAJORITY LEADER OTHER SERVICES TOTALS   250.01 2009Q4_singlevolume.pdf
63 2009Q4 2009 leadership OFFICE OF THE MAJORITY LEADER SUPPLIES AND MATERIALS TOTALS   5679.07 2009Q4_singlevolume.pdf
64 2009Q4 2009 leadership OFFICE OF THE MAJORITY LEADER LEADERSHIP LUMP SUM NONPERS. TOTALS   5974.05 2009Q4_singlevolume.pdf
65 2009Q4 2009 leadership OFFICE OF THE MAJORITY LEADER OFFICE TOTALS   10656.38 2009Q4_singlevolume.pdf
66 2009Q4 2008 leadership OFFICE OF THE MAJORITY LEADER OTHER SERVICES TOTALS   7930.89 2009Q4_singlevolume.pdf
67 2009Q4 2008 leadership OFFICE OF THE MAJORITY LEADER LEADERSHIP LUMP SUM NONPERS. TOTALS   7930.89 2009Q4_singlevolume.pdf
68 2009Q4 2008 leadership OFFICE OF THE MAJORITY LEADER OFFICE TOTALS   7930.89 2009Q4_singlevolume.pdf
69 2009Q4 2010 leadership OFFICE OF THE MINORITY LEADER LEADERSHIP STATUTORY TOTALS 293349.96 293349.96 2009Q4_singlevolume.pdf
70 2009Q4 2010 leadership OFFICE OF THE MINORITY LEADER LEADERSHIP LUMP SUM PERSONNEL TOTALS 426947.45 426947.45 2009Q4_singlevolume.pdf
71 2009Q4 2010 leadership OFFICE OF THE MINORITY LEADER LEADERSHIP LUMP SUM NONPERS. TOTALS 27857.41 27857.41 2009Q4_singlevolume.pdf
72 2009Q4 2010 leadership OFFICE OF THE MINORITY LEADER LEADERSHIP OFFICIAL EXPENSES TOTALS 2499.99 2499.99 2009Q4_singlevolume.pdf
73 2009Q4 2010 leadership OFFICE OF THE MINORITY LEADER OFFICE TOTALS 750654.81 750654.81 2009Q4_singlevolume.pdf
74 2009Q4 2010 leadership OFFICE OF THE MINORITY LEADER PERSONNEL COMPENSATION TOTALS   293349.96 2009Q4_singlevolume.pdf
75 2009Q4 2010 leadership OFFICE OF THE MINORITY LEADER LEADERSHIP STATUTORY TOTALS   293349.96 2009Q4_singlevolume.pdf
76 2009Q4 2010 leadership OFFICE OF THE MINORITY LEADER PERSONNEL COMPENSATION TOTALS   426947.45 2009Q4_singlevolume.pdf
77 2009Q4 2010 leadership OFFICE OF THE MINORITY LEADER LEADERSHIP LUMP SUM PERSONNEL TOTALS   426947.45 2009Q4_singlevolume.pdf
78 2009Q4 2010 leadership OFFICE OF THE MINORITY LEADER TRAVEL TOTALS   36.0 2009Q4_singlevolume.pdf
79 2009Q4 2010 leadership OFFICE OF THE MINORITY LEADER RENT, COMMUNICATION, UTILITIES TOTALS   138.51 2009Q4_singlevolume.pdf
80 2009Q4 2010 leadership OFFICE OF THE MINORITY LEADER PRINTING AND REPRODUCTION TOTALS   27.8 2009Q4_singlevolume.pdf
81 2009Q4 2010 leadership OFFICE OF THE MINORITY LEADER SUPPLIES AND MATERIALS TOTALS   27655.1 2009Q4_singlevolume.pdf
82 2009Q4 2010 leadership OFFICE OF THE MINORITY LEADER LEADERSHIP LUMP SUM NONPERS. TOTALS   27857.41 2009Q4_singlevolume.pdf
83 2009Q4 2010 leadership OFFICE OF THE MINORITY LEADER PERSONNEL BENEFITS TOTALS   2499.99 2009Q4_singlevolume.pdf
84 2009Q4 2010 leadership OFFICE OF THE MINORITY LEADER LEADERSHIP OFFICIAL EXPENSES TOTALS   2499.99 2009Q4_singlevolume.pdf
85 2009Q4 2010 leadership OFFICE OF THE MINORITY LEADER OFFICE TOTALS   750654.81 2009Q4_singlevolume.pdf
86 2009Q4 2009 leadership OFFICE OF THE MINORITY LEADER PERSONNEL COMPENSATION TOTALS   1462.92 2009Q4_singlevolume.pdf
87 2009Q4 2009 leadership OFFICE OF THE MINORITY LEADER LEADERSHIP LUMP SUM PERSONNEL TOTALS   1462.92 2009Q4_singlevolume.pdf
88 2009Q4 2009 leadership OFFICE OF THE MINORITY LEADER TRAVEL TOTALS   85.5 2009Q4_singlevolume.pdf
89 2009Q4 2009 leadership OFFICE OF THE MINORITY LEADER RENT, COMMUNICATION, UTILITIES TOTALS   63.6 2009Q4_singlevolume.pdf
90 2009Q4 2009 leadership OFFICE OF THE MINORITY LEADER SUPPLIES AND MATERIALS TOTALS   14630.74 2009Q4_singlevolume.pdf
91 2009Q4 2009 leadership OFFICE OF THE MINORITY LEADER LEADERSHIP LUMP SUM NONPERS. TOTALS   14779.84 2009Q4_singlevolume.pdf
92 2009Q4 2009 leadership OFFICE OF THE MINORITY LEADER OFFICE TOTALS   16242.76 2009Q4_singlevolume.pdf
93 2009Q4 2010 leadership OFFICE OF THE MAJORITY WHIP LEADERSHIP STATUTORY TOTALS 41250.0 41250.0 2009Q4_singlevolume.pdf
94 2009Q4 2010 leadership OFFICE OF THE MAJORITY WHIP LEADERSHIP LUMP SUM PERSONNEL TOTALS 342059.72 342059.72 2009Q4_singlevolume.pdf
95 2009Q4 2010 leadership OFFICE OF THE MAJORITY WHIP LEADERSHIP LUMP SUM NONPERS. TOTALS 18964.12 18964.12 2009Q4_singlevolume.pdf
96 2009Q4 2010 leadership OFFICE OF THE MAJORITY WHIP OFFICE TOTALS 402273.84 402273.84 2009Q4_singlevolume.pdf
97 2009Q4 2010 leadership OFFICE OF THE MAJORITY WHIP PERSONNEL COMPENSATION TOTALS   41250.0 2009Q4_singlevolume.pdf
98 2009Q4 2010 leadership OFFICE OF THE MAJORITY WHIP LEADERSHIP STATUTORY TOTALS   41250.0 2009Q4_singlevolume.pdf
99 2009Q4 2010 leadership OFFICE OF THE MAJORITY WHIP PERSONNEL COMPENSATION TOTALS   342059.72 2009Q4_singlevolume.pdf
100 2009Q4 2010 leadership OFFICE OF THE MAJORITY WHIP LEADERSHIP LUMP SUM PERSONNEL TOTALS   342059.72 2009Q4_singlevolume.pdf

Next page

Advanced export

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

CSV options: 

CREATE TABLE house_pre2016_office_totals (
    id               INTEGER PRIMARY KEY AUTOINCREMENT,
    quarter          TEXT NOT NULL,       -- e.g. '2015Q4'
    office_year      TEXT,                -- fiscal year from section header
    office_type      TEXT,                -- member | committee | leadership | other
    office_name      TEXT,
    category         TEXT,                -- 'OFFICE TOTALS' | 'GENERAL EXPENDITURES TOTALS' | ...
    ytd_amount       REAL,
    quarter_amount   REAL,
    source_pdf       TEXT
);
CREATE INDEX idx_hp16_quarter ON house_pre2016_office_totals(quarter);
CREATE INDEX idx_hp16_office  ON house_pre2016_office_totals(office_name);
CREATE INDEX idx_hp16_cat     ON house_pre2016_office_totals(category);