house_pre2016_office_totals_dedup (view)

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

128,263 rows

✎ View and edit SQL

This data as json, CSV (advanced)

quarter office_year office_type office_name category ytd_amount quarter_amount n_raw_rows
2009Q3 2009 other CHIEF ADMINISTRATIVE OFFICER ACCESS INFO SYS & TECH SERV TOTALS 1378846.56 745139.45 3
2009Q3 2007 other CHIEF ADMINISTRATIVE OFFICER ADMINISTRATION TOTALS 3149465.73 2103969.96 4
2009Q3 2009 other CHIEF ADMINISTRATIVE OFFICER BENEFITS & COMPENSATION TOTALS 355324.63 51656.67 3
2009Q3 2007 other CHIEF ADMINISTRATIVE OFFICER CAPITOL VISITORS CENTER TOTALS 540524.15 141855.7 10
2009Q3 2009 other CHIEF ADMINISTRATIVE OFFICER CDN - FY 2001 SUPPLEMENTAL TOTALS 360241.3 81862.95 2
2009Q3 2009 other CHIEF ADMINISTRATIVE OFFICER COMM BROADCAST ROOM RENOVATION TOTALS 515159.6 302222.28 4
2009Q3 2009 other CHIEF ADMINISTRATIVE OFFICER COMMUNICATIONS TOTALS 3420.47 515.0 2
2009Q3 2009 other CHIEF ADMINISTRATIVE OFFICER EQUIPMENT TOTALS   273557.65 13
2009Q3 2007 other CHIEF ADMINISTRATIVE OFFICER FURNITURE AND FURNISHINGS TOTALS 387816.74 312538.34 2
2009Q3 2009 other CHIEF ADMINISTRATIVE OFFICER GREENING INITIATIVES TOTALS 415736.07 74166.86 2
2009Q3 2009 other CHIEF ADMINISTRATIVE OFFICER HDTV PROJECT TOTALS 25972.98 0.0 1
2009Q3 2007 other CHIEF ADMINISTRATIVE OFFICER HEARING ROOM RENOVATIONS TOTALS 48877.07 39123.72 2
2009Q3 2009 other CHIEF ADMINISTRATIVE OFFICER LEGAL SERVICES TOTALS 79109.93 24190.48 2
2009Q3 2007 other CHIEF ADMINISTRATIVE OFFICER NETWORK SECURITY ASSURANCE TOTALS 2778314.41 818485.4 1
2009Q3 2009 other CHIEF ADMINISTRATIVE OFFICER NON-PERSONNEL TOTALS 86327.56 29016.45 2
2009Q3 2009 other CHIEF ADMINISTRATIVE OFFICER OFFICE TOTALS 11223149.46 1408828.09 24
2009Q3 2009 other CHIEF ADMINISTRATIVE OFFICER OTHER SERVICES TOTALS   459847.3 22
2009Q3 2009 other CHIEF ADMINISTRATIVE OFFICER PERSONNEL COMPENSATION TOTALS   165695.84 1
2009Q3 2007 other CHIEF ADMINISTRATIVE OFFICER PERSONNEL TOTALS 12522311.35 0.0 1
2009Q3 2009 other CHIEF ADMINISTRATIVE OFFICER PMO SUPPORT TOTALS 344719.51 102136.52 2
2009Q3 2009 other CHIEF ADMINISTRATIVE OFFICER PRINTING AND REPRODUCTION TOTALS   1935.67 5
2009Q3 2009 other CHIEF ADMINISTRATIVE OFFICER RENT, COMMUNICATION, UTILITIES TOTALS   54181.47 5
2009Q3 2007 other CHIEF ADMINISTRATIVE OFFICER SECURITY PRGM INFRASTRUCTURE TOTALS 474511.83 61320.84 1
2009Q3 2009 other CHIEF ADMINISTRATIVE OFFICER SUPPLIES AND MATERIALS TOTALS   296739.44 12
2009Q3 2007 other CHIEF ADMINISTRATIVE OFFICER TELECOMMUNICATIONS TOTALS 2532471.97 672333.83 1
2009Q3 2007 other CHIEF ADMINISTRATIVE OFFICER TRANSPORTATION OF THINGS TOTALS   3880.0 1
2009Q3 2009 other CHIEF ADMINISTRATIVE OFFICER TRAVEL TOTALS   16040.83 5
2009Q3 2007 other CHIEF ADMINISTRATIVE OFFICER WIDE AREA NETWORK TOTALS 4560368.86 1174866.05 1
2009Q3 2009 other CHIEF ADMINISTRATIVE OFFICER WOUNDED WARRIOR PROGRAM TOTALS 424570.92 183156.11 2
2009Q3 2009 other CLERK OF THE HOUSE EQUIPMENT TOTALS   407777.42 6
2009Q3 2009 other CLERK OF THE HOUSE FAMILY ROOM TOTALS 14808.42 7855.3 2
2009Q3 2009 other CLERK OF THE HOUSE LIMS TOTALS 50551.0 39751.0 3
2009Q3 2009 other CLERK OF THE HOUSE MODULAR FURNITURE TOTALS 345936.38 268878.31 3
2009Q3 2009 other CLERK OF THE HOUSE OFFICE TOTALS 22144476.52 5900380.39 14
2009Q3 2009 other CLERK OF THE HOUSE OTHER SERVICES TOTALS   446835.33 6
2009Q3 2009 other CLERK OF THE HOUSE PERSONNEL COMPENSATION TOTALS   4813808.45 1
2009Q3 2008 other CLERK OF THE HOUSE PRINTING AND REPRODUCTION TOTALS   2137.87 3
2009Q3 2009 other CLERK OF THE HOUSE RECEPTIONS TOTALS 852.0 0.0 1
2009Q3 2009 other CLERK OF THE HOUSE RENT, COMMUNICATION, UTILITIES TOTALS   50952.03 1
2009Q3 2009 other CLERK OF THE HOUSE SALARIES, OFFICERS & EMPLOYEES TOTALS 22128816.1 5892525.09 8
2009Q3 2009 other CLERK OF THE HOUSE SUPPLIES AND MATERIALS TOTALS   163252.71 6
2009Q3 2009 other CLERK OF THE HOUSE TRAVEL TOTALS   14318.26 1
2009Q3 2008 committee COMMITTEE ON AGRICULTURE EQUIPMENT TOTALS   25630.0 4
2009Q3 2008 committee COMMITTEE ON AGRICULTURE GENERAL EXPENDITURES TOTALS 5368372.16 1808769.58 6
2009Q3 2008 committee COMMITTEE ON AGRICULTURE OFFICE TOTALS 5368372.16 1808769.58 6
2009Q3 2009 committee COMMITTEE ON AGRICULTURE OTHER SERVICES TOTALS   34906.25 2
2009Q3 2008 committee COMMITTEE ON AGRICULTURE PERSONNEL COMPENSATION TOTALS   1729851.9 2
2009Q3 2009 committee COMMITTEE ON AGRICULTURE PRINTING AND REPRODUCTION TOTALS   382.9 1
2009Q3 2009 committee COMMITTEE ON AGRICULTURE RENT, COMMUNICATION, UTILITIES TOTALS   26345.55 2
2009Q3 2008 committee COMMITTEE ON AGRICULTURE SUPPLIES AND MATERIALS TOTALS   29807.72 4
2009Q3 2009 committee COMMITTEE ON AGRICULTURE TRAVEL TOTALS   11918.43 1
2009Q3 2009 committee COMMITTEE ON APPROPRIATIONS APPROPRIATIONS COMMITTEE TOTALS   7761618.62 1
2009Q3 2009 committee COMMITTEE ON APPROPRIATIONS EQUIPMENT TOTALS   29315.56 1
2009Q3 2009 committee COMMITTEE ON APPROPRIATIONS OFFICE TOTALS   7761618.62 1
2009Q3 2009 committee COMMITTEE ON APPROPRIATIONS OTHER SERVICES TOTALS   836029.73 1
2009Q3 2009 committee COMMITTEE ON APPROPRIATIONS PERSONNEL BENEFITS TOTALS   60.0 1
2009Q3 2009 committee COMMITTEE ON APPROPRIATIONS PERSONNEL COMPENSATION TOTALS   6756052.31 1
2009Q3 2009 committee COMMITTEE ON APPROPRIATIONS PRINTING AND REPRODUCTION TOTALS   2928.6 1
2009Q3 2009 committee COMMITTEE ON APPROPRIATIONS RENT, COMMUNICATION, UTILITIES TOTALS   61835.43 1
2009Q3 2009 committee COMMITTEE ON APPROPRIATIONS SUPPLIES AND MATERIALS TOTALS   48494.8 1
2009Q3 2009 committee COMMITTEE ON APPROPRIATIONS TRAVEL TOTALS   26902.19 1
2009Q3 2009 committee COMMITTEE ON BUDGET EQUIPMENT TOTALS   9616.41 1
2009Q3 2009 committee COMMITTEE ON BUDGET GENERAL EXPENDITURES TOTALS 3693997.92 1244449.46 3
2009Q3 2009 committee COMMITTEE ON BUDGET OFFICE TOTALS 3693997.92 1244449.46 3
2009Q3 2009 committee COMMITTEE ON BUDGET OTHER SERVICES TOTALS   5261.99 1
2009Q3 2009 committee COMMITTEE ON BUDGET PERSONNEL COMPENSATION TOTALS   1193398.96 1
2009Q3 2009 committee COMMITTEE ON BUDGET RENT, COMMUNICATION, UTILITIES TOTALS   10884.23 1
2009Q3 2009 committee COMMITTEE ON BUDGET SUPPLIES AND MATERIALS TOTALS   25221.87 2
2009Q3 2009 committee COMMITTEE ON BUDGET TRAVEL TOTALS   66.0 1
2009Q3 2008 committee COMMITTEE ON ENERGY & COMMERCE EQUIPMENT TOTALS   253181.76 6
2009Q3 2008 committee COMMITTEE ON ENERGY & COMMERCE GENERAL EXPENDITURES TOTALS 7950662.14 2917099.42 10
2009Q3 2008 committee COMMITTEE ON ENERGY & COMMERCE OFFICE TOTALS 7950662.14 2917099.42 10
2009Q3 2008 committee COMMITTEE ON ENERGY & COMMERCE OTHER SERVICES TOTALS   62145.36 5
2009Q3 2009 committee COMMITTEE ON ENERGY & COMMERCE PERSONNEL COMPENSATION TOTALS   2624771.41 3
2009Q3 2008 committee COMMITTEE ON ENERGY & COMMERCE PRINTING AND REPRODUCTION TOTALS   7559.0 4
2009Q3 2008 committee COMMITTEE ON ENERGY & COMMERCE RENT, COMMUNICATION, UTILITIES TOTALS   42913.64 3
2009Q3 2008 committee COMMITTEE ON ENERGY & COMMERCE SUPPLIES AND MATERIALS TOTALS   67411.26 4
2009Q3 2009 committee COMMITTEE ON ENERGY & COMMERCE TRAVEL TOTALS   26446.9 3
2009Q3 2008 committee COMMITTEE ON FINANCIAL SERVICE EQUIPMENT TOTALS   52376.21 3
2009Q3 2009 committee COMMITTEE ON FINANCIAL SERVICE GENERAL EXPENDITURES TOTALS 6006396.26 2116116.29 6
2009Q3 2009 committee COMMITTEE ON FINANCIAL SERVICE OFFICE TOTALS 6006396.26 2116116.29 6
2009Q3 2008 committee COMMITTEE ON FINANCIAL SERVICE OTHER SERVICES TOTALS   8989.5 3
2009Q3 2009 committee COMMITTEE ON FINANCIAL SERVICE PERSONNEL COMPENSATION TOTALS   2050547.82 2
2009Q3 2008 committee COMMITTEE ON FINANCIAL SERVICE PRINTING AND REPRODUCTION TOTALS   1083.36 2
2009Q3 2008 committee COMMITTEE ON FINANCIAL SERVICE RENT, COMMUNICATION, UTILITIES TOTALS   43076.19 2
2009Q3 2008 committee COMMITTEE ON FINANCIAL SERVICE SUPPLIES AND MATERIALS TOTALS   33707.74 3
2009Q3 2009 committee COMMITTEE ON FINANCIAL SERVICE TRAVEL TOTALS   9413.24 2
2009Q3 2009 committee COMMITTEE ON FOREIGN AFFAIRS EQUIPMENT TOTALS   39198.92 1
2009Q3 2009 committee COMMITTEE ON FOREIGN AFFAIRS GENERAL EXPENDITURES TOTALS 5902658.89 2001502.47 2
2009Q3 2009 committee COMMITTEE ON FOREIGN AFFAIRS OFFICE TOTALS 5902658.89 2001502.47 2
2009Q3 2009 committee COMMITTEE ON FOREIGN AFFAIRS OTHER SERVICES TOTALS   5301.99 2
2009Q3 2009 committee COMMITTEE ON FOREIGN AFFAIRS PERSONNEL COMPENSATION TOTALS   1893488.56 1
2009Q3 2009 committee COMMITTEE ON FOREIGN AFFAIRS PRINTING AND REPRODUCTION TOTALS   1508.46 1
2009Q3 2009 committee COMMITTEE ON FOREIGN AFFAIRS RENT, COMMUNICATION, UTILITIES TOTALS   25959.77 1
2009Q3 2009 committee COMMITTEE ON FOREIGN AFFAIRS SUPPLIES AND MATERIALS TOTALS   29468.63 1
2009Q3 2009 committee COMMITTEE ON FOREIGN AFFAIRS TRAVEL TOTALS   6576.14 2
2009Q3 2008 committee COMMITTEE ON JUDICIARY EQUIPMENT TOTALS   71500.0 4
2009Q3 2009 committee COMMITTEE ON JUDICIARY GENERAL EXPENDITURES TOTALS 6477228.68 2425545.4 7
2009Q3 2009 committee COMMITTEE ON JUDICIARY GENERAL EXPENDITURES-IMP TOTALS 15466.0 0.0 1
2009Q3 2009 committee COMMITTEE ON JUDICIARY OFFICE TOTALS 6477228.68 2425545.4 7

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW house_pre2016_office_totals_dedup AS
    SELECT
        quarter, office_year, office_type, office_name, category,
        MAX(ytd_amount) AS ytd_amount,
        MAX(quarter_amount) AS quarter_amount,
        COUNT(*) AS n_raw_rows
    FROM house_pre2016_office_totals
    GROUP BY quarter, office_name, category;