senate_office_totals
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
25,606 rows
This data as json, CSV (advanced)
Suggested facets: report_id, congress_num, report_seq, office_party, line_category, source_pdf
| id ▼ | report_id | congress_num | session_num | report_seq | report_period | office_name | office_party | line_category | net_funds | net_expenditures | total_funding | source_pdf |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | GPO-CDOC-112sdoc10 | 112 | 10 | CHAIRMAN MAJORITY CONFERENCE COMMITTEE | D | 4748.25 | 0.0 | -4748.25 | GPO-CDOC-112sdoc10.pdf | |||
| 2 | GPO-CDOC-112sdoc10 | 112 | 10 | CHAIRMAN MAJORITY CONFERENCE COMMITTEE | D | 4990.0 | 0.0 | -4990.0 | GPO-CDOC-112sdoc10.pdf | |||
| 3 | GPO-CDOC-112sdoc10 | 112 | 10 | CHAIRMAN MAJORITY CONFERENCE COMMITTEE | D | 4690.0 | 0.0 | -4555.5 | GPO-CDOC-112sdoc10.pdf | |||
| 4 | GPO-CDOC-112sdoc10 | 112 | 10 | CHAIRMAN MAJORITY POLICY COMMITTEE | D | 3415.25 | 0.0 | -3415.25 | GPO-CDOC-112sdoc10.pdf | |||
| 5 | GPO-CDOC-112sdoc10 | 112 | 10 | CHAIRMAN MAJORITY POLICY COMMITTEE | D | 4990.0 | 0.0 | -4989.37 | GPO-CDOC-112sdoc10.pdf | |||
| 6 | GPO-CDOC-112sdoc10 | 112 | 10 | CHAIRMAN MAJORITY POLICY COMMITTEE | D | 4690.0 | -325.0 | -1325.0 | GPO-CDOC-112sdoc10.pdf | |||
| 7 | GPO-CDOC-112sdoc10 | 112 | 10 | MAJORITY LEADER | D | 51949.93 | 0.0 | -51949.93 | GPO-CDOC-112sdoc10.pdf | |||
| 8 | GPO-CDOC-112sdoc10 | 112 | 10 | MAJORITY LEADER | D | 54890.0 | 1627.85 | -53262.15 | GPO-CDOC-112sdoc10.pdf | |||
| 9 | GPO-CDOC-112sdoc10 | 112 | 10 | MAJORITY LEADER | D | 53990.0 | -21875.03 | -49377.3 | GPO-CDOC-112sdoc10.pdf | |||
| 10 | GPO-CDOC-112sdoc10 | 112 | 10 | MAJORITY WHIP | D | 9768.59 | 0.0 | -9768.59 | GPO-CDOC-112sdoc10.pdf | |||
| 11 | GPO-CDOC-112sdoc10 | 112 | 10 | MAJORITY WHIP | D | 9980.0 | 0.0 | -9910.93 | GPO-CDOC-112sdoc10.pdf | |||
| 12 | GPO-CDOC-112sdoc10 | 112 | 10 | MAJORITY WHIP | D | 9980.0 | -4135.58 | -6435.77 | GPO-CDOC-112sdoc10.pdf | |||
| 13 | GPO-CDOC-112sdoc10 | 112 | 10 | MAJORITY WHIP | D | 2210.32 | 0.0 | -2210.32 | GPO-CDOC-112sdoc10.pdf | |||
| 14 | GPO-CDOC-112sdoc10 | 112 | 10 | MAJORITY WHIP | D | 19960.0 | 0.0 | -4405.32 | GPO-CDOC-112sdoc10.pdf | |||
| 15 | GPO-CDOC-112sdoc10 | 112 | 10 | MAJORITY WHIP | D | 18760.0 | -295.5 | -685.7 | GPO-CDOC-112sdoc10.pdf | |||
| 16 | GPO-CDOC-112sdoc10 | 112 | 10 | PRESIDENT PRO TEMPORE | D | 4644.69 | 0.0 | -4644.69 | GPO-CDOC-112sdoc10.pdf | |||
| 17 | GPO-CDOC-112sdoc10 | 112 | 10 | PRESIDENT PRO TEMPORE | D | 39920.0 | 0.0 | -8702.95 | GPO-CDOC-112sdoc10.pdf | |||
| 18 | GPO-CDOC-112sdoc10 | 112 | 10 | PRESIDENT PRO TEMPORE | D | 37520.0 | -6545.37 | -11166.58 | GPO-CDOC-112sdoc10.pdf | |||
| 19 | GPO-CDOC-112sdoc10 | 112 | 10 | MINORITY LEADER | R | 31227.83 | 0.0 | -31227.83 | GPO-CDOC-112sdoc10.pdf | |||
| 20 | GPO-CDOC-112sdoc10 | 112 | 10 | MINORITY LEADER | R | 52920.0 | 0.0 | -29267.9 | GPO-CDOC-112sdoc10.pdf | |||
| 21 | GPO-CDOC-112sdoc10 | 112 | 10 | MINORITY LEADER | R | 52920.0 | -9088.04 | -17166.59 | GPO-CDOC-112sdoc10.pdf | |||
| 22 | GPO-CDOC-112sdoc10 | 112 | 10 | MINORITY WHIP | R | 2921.47 | 0.0 | -2921.47 | GPO-CDOC-112sdoc10.pdf | |||
| 23 | GPO-CDOC-112sdoc10 | 112 | 10 | MINORITY WHIP | R | 9980.0 | 0.0 | -4537.81 | GPO-CDOC-112sdoc10.pdf | |||
| 24 | GPO-CDOC-112sdoc10 | 112 | 10 | MINORITY WHIP | R | 9980.0 | 0.0 | -4000.0 | GPO-CDOC-112sdoc10.pdf | |||
| 25 | GPO-CDOC-112sdoc10 | 112 | 10 | CHAIRMAN MINORITY CONFERENCE COMMITTEE | R | 2867.3 | 0.0 | -2867.3 | GPO-CDOC-112sdoc10.pdf | |||
| 26 | GPO-CDOC-112sdoc10 | 112 | 10 | CHAIRMAN MINORITY CONFERENCE COMMITTEE | R | 4990.0 | 0.0 | -4528.63 | GPO-CDOC-112sdoc10.pdf | |||
| 27 | GPO-CDOC-112sdoc10 | 112 | 10 | CHAIRMAN MINORITY CONFERENCE COMMITTEE | R | 4690.0 | 0.0 | -4600.0 | GPO-CDOC-112sdoc10.pdf | |||
| 28 | GPO-CDOC-112sdoc10 | 112 | 10 | CHAIRMAN MINORITY POLICY COMMITTEE | R | 4931.71 | 0.0 | -4931.71 | GPO-CDOC-112sdoc10.pdf | |||
| 29 | GPO-CDOC-112sdoc10 | 112 | 10 | CHAIRMAN MINORITY POLICY COMMITTEE | R | 4990.0 | 0.0 | -3391.31 | GPO-CDOC-112sdoc10.pdf | |||
| 30 | GPO-CDOC-112sdoc10 | 112 | 10 | CHAIRMAN MINORITY POLICY COMMITTEE | R | 4690.0 | -1620.71 | -4687.5 | GPO-CDOC-112sdoc10.pdf | |||
| 31 | GPO-CDOC-112sdoc10 | 112 | 10 | MAJORITY LEADER | D | 0.0 | 0.0 | 0.0 | GPO-CDOC-112sdoc10.pdf | |||
| 32 | GPO-CDOC-112sdoc10 | 112 | 10 | MAJORITY LEADER | D | 0.0 | 0.0 | 0.0 | GPO-CDOC-112sdoc10.pdf | |||
| 33 | GPO-CDOC-112sdoc10 | 112 | 10 | MAJORITY LEADER | D | 0.0 | 0.0 | 0.0 | GPO-CDOC-112sdoc10.pdf | |||
| 34 | GPO-CDOC-112sdoc10 | 112 | 10 | MINORITY LEADER | R | 0.0 | 0.0 | 0.0 | GPO-CDOC-112sdoc10.pdf | |||
| 35 | GPO-CDOC-112sdoc10 | 112 | 10 | MINORITY LEADER | R | 1970.0 | 0.0 | 0.0 | GPO-CDOC-112sdoc10.pdf | |||
| 36 | GPO-CDOC-112sdoc10 | 112 | 10 | MINORITY LEADER | R | 1070.0 | 0.0 | 0.0 | GPO-CDOC-112sdoc10.pdf | |||
| 37 | GPO-CDOC-112sdoc10 | 112 | 10 | APPROPRIATIONS | 12882582.11 | 0.0 | -12882582.11 | GPO-CDOC-112sdoc10.pdf | ||||
| 38 | GPO-CDOC-112sdoc10 | 112 | 10 | APPROPRIATIONS | 15812312.0 | 0.0 | -12586761.99 | GPO-CDOC-112sdoc10.pdf | ||||
| 39 | GPO-CDOC-112sdoc10 | 112 | 10 | APPROPRIATIONS | 14863573.0 | -6004786.66 | -12119573.49 | GPO-CDOC-112sdoc10.pdf | ||||
| 40 | GPO-CDOC-112sdoc10 | 112 | 10 | CHAPLAIN | 414992.16 | 0.0 | -414992.16 | GPO-CDOC-112sdoc10.pdf | ||||
| 41 | GPO-CDOC-112sdoc10 | 112 | 10 | CHAPLAIN | 414170.0 | 0.0 | -414124.58 | GPO-CDOC-112sdoc10.pdf | ||||
| 42 | GPO-CDOC-112sdoc10 | 112 | 10 | CHAPLAIN | 405886.0 | -201349.8 | -405699.6 | GPO-CDOC-112sdoc10.pdf | ||||
| 43 | GPO-CDOC-112sdoc10 | 112 | 10 | MAJORITY CONFERENCE COMMITTEE | D | 1537881.46 | 0.0 | -1537881.46 | GPO-CDOC-112sdoc10.pdf | |||
| 44 | GPO-CDOC-112sdoc10 | 112 | 10 | MAJORITY CONFERENCE COMMITTEE | D | 1632548.0 | 0.0 | -1529822.84 | GPO-CDOC-112sdoc10.pdf | |||
| 45 | GPO-CDOC-112sdoc10 | 112 | 10 | MAJORITY CONFERENCE COMMITTEE | D | 1589195.0 | -702709.81 | -1486732.09 | GPO-CDOC-112sdoc10.pdf | |||
| 46 | GPO-CDOC-112sdoc10 | 112 | 10 | MAJORITY POLICY COMMITTEE | D | 1698703.25 | 0.0 | -1698703.25 | GPO-CDOC-112sdoc10.pdf | |||
| 47 | GPO-CDOC-112sdoc10 | 112 | 10 | MAJORITY POLICY COMMITTEE | D | 1699474.0 | 0.0 | -1643301.78 | GPO-CDOC-112sdoc10.pdf | |||
| 48 | GPO-CDOC-112sdoc10 | 112 | 10 | MAJORITY POLICY COMMITTEE | D | 1623905.0 | -717451.99 | -1514929.98 | GPO-CDOC-112sdoc10.pdf | |||
| 49 | GPO-CDOC-112sdoc10 | 112 | 10 | MAJORITY LEADER | D | 2487097.53 | 0.0 | -2487097.53 | GPO-CDOC-112sdoc10.pdf | |||
| 50 | GPO-CDOC-112sdoc10 | 112 | 10 | MAJORITY LEADER | D | 2527788.0 | 0.0 | -2514539.71 | GPO-CDOC-112sdoc10.pdf | |||
| 51 | GPO-CDOC-112sdoc10 | 112 | 10 | MAJORITY LEADER | D | 2600788.0 | -1131184.09 | -2444781.02 | GPO-CDOC-112sdoc10.pdf | |||
| 52 | GPO-CDOC-112sdoc10 | 112 | 10 | SECRETARY, MAJORITY CONFERENCE COMM | D | 409577.48 | 0.0 | -409577.48 | GPO-CDOC-112sdoc10.pdf | |||
| 53 | GPO-CDOC-112sdoc10 | 112 | 10 | SECRETARY, MAJORITY CONFERENCE COMM | D | 424150.0 | 0.0 | -398346.97 | GPO-CDOC-112sdoc10.pdf | |||
| 54 | GPO-CDOC-112sdoc10 | 112 | 10 | SECRETARY, MAJORITY CONFERENCE COMM | D | 398701.0 | -184479.44 | -379635.93 | GPO-CDOC-112sdoc10.pdf | |||
| 55 | GPO-CDOC-112sdoc10 | 112 | 10 | MAJORITY WHIP | D | 1446186.43 | 0.0 | -1446186.43 | GPO-CDOC-112sdoc10.pdf | |||
| 56 | GPO-CDOC-112sdoc10 | 112 | 10 | MAJORITY WHIP | D | 1640712.0 | 0.0 | -1321715.0 | GPO-CDOC-112sdoc10.pdf | |||
| 57 | GPO-CDOC-112sdoc10 | 112 | 10 | MAJORITY WHIP | D | 1640712.0 | -861803.74 | -1493159.43 | GPO-CDOC-112sdoc10.pdf | |||
| 58 | GPO-CDOC-112sdoc10 | 112 | 10 | MAJORITY WHIP | D | 2411162.97 | 0.0 | -2411162.97 | GPO-CDOC-112sdoc10.pdf | |||
| 59 | GPO-CDOC-112sdoc10 | 112 | 10 | MAJORITY WHIP | D | 2511966.0 | 0.0 | -2364115.87 | GPO-CDOC-112sdoc10.pdf | |||
| 60 | GPO-CDOC-112sdoc10 | 112 | 10 | MAJORITY WHIP | D | 2361248.0 | -1130748.5 | -2292234.66 | GPO-CDOC-112sdoc10.pdf | |||
| 61 | GPO-CDOC-112sdoc10 | 112 | 10 | PRESIDENT PRO TEMPORE | D | 423657.83 | 0.0 | -423657.83 | GPO-CDOC-112sdoc10.pdf | |||
| 62 | GPO-CDOC-112sdoc10 | 112 | 10 | PRESIDENT PRO TEMPORE | D | 750496.0 | 0.0 | -107041.49 | GPO-CDOC-112sdoc10.pdf | |||
| 63 | GPO-CDOC-112sdoc10 | 112 | 10 | PRESIDENT PRO TEMPORE | D | 705466.0 | -77433.15 | -150432.99 | GPO-CDOC-112sdoc10.pdf | |||
| 64 | GPO-CDOC-112sdoc10 | 112 | 10 | MINORITY LEADER | R | 1803670.11 | 0.0 | -1803670.11 | GPO-CDOC-112sdoc10.pdf | |||
| 65 | GPO-CDOC-112sdoc10 | 112 | 10 | MINORITY LEADER | R | 2425788.0 | 0.0 | -1657832.37 | GPO-CDOC-112sdoc10.pdf | |||
| 66 | GPO-CDOC-112sdoc10 | 112 | 10 | MINORITY LEADER | R | 2425788.0 | -825947.84 | -1649768.12 | GPO-CDOC-112sdoc10.pdf | |||
| 67 | GPO-CDOC-112sdoc10 | 112 | 10 | SECRETARY, MINORITY CONFERENCE COMM | R | 321833.31 | 0.0 | -321833.31 | GPO-CDOC-112sdoc10.pdf | |||
| 68 | GPO-CDOC-112sdoc10 | 112 | 10 | SECRETARY, MINORITY CONFERENCE COMM | R | 412150.0 | 0.0 | -213691.43 | GPO-CDOC-112sdoc10.pdf | |||
| 69 | GPO-CDOC-112sdoc10 | 112 | 10 | SECRETARY, MINORITY CONFERENCE COMM | R | 286701.0 | -132799.71 | -217660.73 | GPO-CDOC-112sdoc10.pdf | |||
| 70 | GPO-CDOC-112sdoc10 | 112 | 10 | MINORITY WHIP | R | 1196655.72 | 0.0 | -1196655.72 | GPO-CDOC-112sdoc10.pdf | |||
| 71 | GPO-CDOC-112sdoc10 | 112 | 10 | MINORITY WHIP | R | 1590712.0 | 0.0 | -1215769.73 | GPO-CDOC-112sdoc10.pdf | |||
| 72 | GPO-CDOC-112sdoc10 | 112 | 10 | MINORITY WHIP | R | 1540712.0 | -599980.13 | -1238430.47 | GPO-CDOC-112sdoc10.pdf | |||
| 73 | GPO-CDOC-112sdoc10 | 112 | 10 | MINORITY CONFERENCE COMMITTEE | R | 1305973.15 | 0.0 | -1305973.15 | GPO-CDOC-112sdoc10.pdf | |||
| 74 | GPO-CDOC-112sdoc10 | 112 | 10 | MINORITY CONFERENCE COMMITTEE | R | 1472548.0 | 0.0 | -1328761.15 | GPO-CDOC-112sdoc10.pdf | |||
| 75 | GPO-CDOC-112sdoc10 | 112 | 10 | MINORITY CONFERENCE COMMITTEE | R | 1579195.0 | -764961.73 | -1458280.73 | GPO-CDOC-112sdoc10.pdf | |||
| 76 | GPO-CDOC-112sdoc10 | 112 | 10 | MINORITY POLICY COMMITTEE | R | 1542574.59 | 0.0 | -1542574.59 | GPO-CDOC-112sdoc10.pdf | |||
| 77 | GPO-CDOC-112sdoc10 | 112 | 10 | MINORITY POLICY COMMITTEE | R | 1759474.0 | 0.0 | -1546427.08 | GPO-CDOC-112sdoc10.pdf | |||
| 78 | GPO-CDOC-112sdoc10 | 112 | 10 | MINORITY POLICY COMMITTEE | R | 1653905.0 | -797124.92 | -1561409.19 | GPO-CDOC-112sdoc10.pdf | |||
| 79 | GPO-CDOC-112sdoc10 | 112 | 10 | SECRETARY FOR THE MAJORITY | D | 770324.0 | 0.0 | -770324.0 | GPO-CDOC-112sdoc10.pdf | |||
| 80 | GPO-CDOC-112sdoc10 | 112 | 10 | SECRETARY FOR THE MAJORITY | D | 916164.0 | 0.0 | -771308.81 | GPO-CDOC-112sdoc10.pdf | |||
| 81 | GPO-CDOC-112sdoc10 | 112 | 10 | SECRETARY FOR THE MAJORITY | D | 861194.0 | -421398.73 | -821312.53 | GPO-CDOC-112sdoc10.pdf | |||
| 82 | GPO-CDOC-112sdoc10 | 112 | 10 | SECRETARY FOR THE MINORITY | R | 847431.96 | 0.0 | -847431.96 | GPO-CDOC-112sdoc10.pdf | |||
| 83 | GPO-CDOC-112sdoc10 | 112 | 10 | SECRETARY FOR THE MINORITY | R | 916164.0 | 0.0 | -781308.13 | GPO-CDOC-112sdoc10.pdf | |||
| 84 | GPO-CDOC-112sdoc10 | 112 | 10 | SECRETARY FOR THE MINORITY | R | 861194.0 | -375865.68 | -731232.05 | GPO-CDOC-112sdoc10.pdf | |||
| 85 | GPO-CDOC-112sdoc10 | 112 | 10 | SECRETARY FOR THE MINORITY | R | 19689302.8 | 0.0 | -19689302.8 | GPO-CDOC-112sdoc10.pdf | |||
| 86 | GPO-CDOC-112sdoc10 | 112 | 10 | SECRETARY FOR THE MINORITY | R | 18719887.78 | 0.0 | -18719887.78 | GPO-CDOC-112sdoc10.pdf | |||
| 87 | GPO-CDOC-112sdoc10 | 112 | 10 | SECRETARY FOR THE MINORITY | R | 7501814.27 | 0.0 | -7501814.27 | GPO-CDOC-112sdoc10.pdf | |||
| 88 | GPO-CDOC-112sdoc10 | 112 | 10 | SECRETARY FOR THE MINORITY | R | 8574292.62 | 0.0 | -8574292.62 | GPO-CDOC-112sdoc10.pdf | |||
| 89 | GPO-CDOC-112sdoc10 | 112 | 10 | SECRETARY FOR THE MINORITY | R | 15437819.24 | 0.0 | -15437819.24 | GPO-CDOC-112sdoc10.pdf | |||
| 90 | GPO-CDOC-112sdoc10 | 112 | 10 | SECRETARY FOR THE MINORITY | R | 20604708.0 | -9790.0 | -19808342.47 | GPO-CDOC-112sdoc10.pdf | |||
| 91 | GPO-CDOC-112sdoc10 | 112 | 10 | SECRETARY FOR THE MINORITY | R | 20020084.0 | 0.0 | -19103115.27 | GPO-CDOC-112sdoc10.pdf | |||
| 92 | GPO-CDOC-112sdoc10 | 112 | 10 | SECRETARY FOR THE MINORITY | R | 7908152.0 | 0.0 | -7615959.38 | GPO-CDOC-112sdoc10.pdf | |||
| 93 | GPO-CDOC-112sdoc10 | 112 | 10 | SECRETARY FOR THE MINORITY | R | 11370214.0 | 0.0 | -10219188.76 | GPO-CDOC-112sdoc10.pdf | |||
| 94 | GPO-CDOC-112sdoc10 | 112 | 10 | SECRETARY FOR THE MINORITY | R | 16296342.0 | 0.0 | -15621422.61 | GPO-CDOC-112sdoc10.pdf | |||
| 95 | GPO-CDOC-112sdoc10 | 112 | 10 | SECRETARY FOR THE MINORITY | R | 19460585.0 | -9843972.7 | -19259803.18 | GPO-CDOC-112sdoc10.pdf | |||
| 96 | GPO-CDOC-112sdoc10 | 112 | 10 | SECRETARY FOR THE MINORITY | R | 19754202.0 | -9988201.76 | -19750342.88 | GPO-CDOC-112sdoc10.pdf | |||
| 97 | GPO-CDOC-112sdoc10 | 112 | 10 | SECRETARY FOR THE MINORITY | R | 7692405.0 | -4201492.76 | -7392724.33 | GPO-CDOC-112sdoc10.pdf | |||
| 98 | GPO-CDOC-112sdoc10 | 112 | 10 | SECRETARY FOR THE MINORITY | R | 10367186.0 | -5173331.7 | -10142610.6 | GPO-CDOC-112sdoc10.pdf | |||
| 99 | GPO-CDOC-112sdoc10 | 112 | 10 | SECRETARY FOR THE MINORITY | R | 15725622.0 | -7648590.24 | -15121232.83 | GPO-CDOC-112sdoc10.pdf | |||
| 100 | GPO-CDOC-112sdoc10 | 112 | 10 | SECRETARY FOR THE MINORITY | R | 13803334.36 | 0.0 | -13803334.36 | GPO-CDOC-112sdoc10.pdf |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE senate_office_totals (
id INTEGER PRIMARY KEY AUTOINCREMENT,
report_id TEXT NOT NULL, -- e.g. 'GPO-CDOC-119sdoc3'
congress_num INTEGER,
session_num INTEGER, -- 1 or 2 (rarely used)
report_seq INTEGER, -- sdoc #
report_period TEXT, -- derived: 'YYYY-MM to YYYY-MM'
office_name TEXT, -- verbatim from PDF
office_party TEXT, -- (D) | (R) | blank
line_category TEXT, -- optional sub-category (e.g. 'POLICY COMMITTEES')
net_funds REAL,
net_expenditures REAL,
total_funding REAL,
source_pdf TEXT
);
CREATE INDEX idx_sot_report ON senate_office_totals(report_id);
CREATE INDEX idx_sot_office ON senate_office_totals(office_name);
CREATE INDEX idx_sot_congress ON senate_office_totals(congress_num);