hearing_activity (view)

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

105 rows

✎ View and edit SQL

This data as json, CSV (advanced)

congress chamber hearing_count unique_witnesses earliest latest
119 HOUSE 1339 1274 2025-01-14 2026-01-14
119 JOINT 13 6 2025-06-26 2025-12-10
119 SENATE 467 408 2025-01-15 2025-12-02
118 HOUSE 4184 3642 2023-01-03 2025-04-04
118 JOINT 149 123 2023-02-08 2024-12-05
118 SENATE 2055 1723 2022-05-04 2025-09-30
117 HOUSE 4102 3647 2020-10-01 2022-12-15
117 JOINT 158 128 2021-04-14 2022-12-13
117 SENATE 2821 2244 2018-06-05 2022-12-19
116 HOUSE 5182 4603 2019-01-03 2025-09-16
116 JOINT 89 59 2019-01-03 2020-09-30
116 SENATE 1920 1507 2019-01-03 2020-12-16
115 HOUSE 5095 4412 2017-01-03 2018-12-13
115 JOINT 183 104 2017-02-01 2018-12-17
115 SENATE 2618 2061 2017-01-03 2019-11-05
114 HOUSE 6012 5031 2014-02-11 2016-12-08
114 JOINT 96 57 2013-09-17 2016-12-09
114 SENATE 3056 2297 2014-10-15 2018-07-26
113 HOUSE 6407 5372 2012-10-09 2016-03-19
113 JOINT 122 77 2013-02-26 2014-12-17
113 SENATE 3118 2411 2012-08-06 2015-09-30
112 HOUSE 7835 6287 2010-01-12 2013-04-25
112 JOINT 206 145 2011-02-23 2012-12-18
112 SENATE 3265 2449 2011-01-07 2013-09-30
111 HOUSE 8127 6419 2008-03-11 2017-05-23
111 JOINT 153 104 2009-01-16 2010-12-03
111 SENATE 4033 2930 2001-09-11 2011-09-30
110   4 0 2007-01-01 2008-01-01
110 HOUSE 9640 7386 2001-09-11 2010-03-23
110 House 1 0 2008-07-31 2008-07-31
110 JOINT 175 135 2007-01-31 2008-12-12
110 SENATE 4335 3191 2007-01-09 2009-09-30
109   2 0 2005-09-12 2006-03-02
109 HOUSE 4711 3423 2001-09-11 2007-09-28
109 JOINT 71 44 2005-02-07 2006-11-20
109 SENATE 4024 2882 1936-05-26 2007-09-30
108   1 0 2004-01-01 2004-01-01
108 HOUSE 4131 3159 2001-09-11 2004-12-31
108 JOINT 124 80 2003-01-27 2004-12-10
108 SENATE 3514 2411 2001-09-11 2016-10-12
107 HOUSE 3561 2433 2000-03-05 2005-03-04
107 JOINT 38 8 2001-03-20 2002-12-09
107 SENATE 4650 3391 2001-01-04 2003-03-07
106 HOUSE 3394 2280 1999-01-01 2002-06-25
106 JOINT 32 25 1999-03-11 2001-09-01
106 SENATE 2511 1992 1950-08-09 2001-12-14
105 HOUSE 2877 2042 1996-09-18 2007-07-12
105 House 1 0 1997-03-11 1997-03-11
105 JOINT 14 10 1997-03-13 1998-03-24
105 SENATE 996 817 1997-01-09 1999-03-26
104 HOUSE 390 8 1966-07-31 1998-02-26
104 JOINT 8 0 1995-01-12 1998-02-26
104 SENATE 6 0 1995-02-02 1995-03-28
103 HOUSE 193 5 1993-01-27 2005-05-17
102 SENATE 5 0 1991-09-10 1991-10-11
101 HOUSE 5 5 2015-10-22 2015-10-22
100 SENATE 1 0 1987-12-02 1987-12-02
99 SENATE 2 0 1986-07-16 2002-02-28
97 HOUSE 78 0 1980-12-31 1982-08-27
97 SENATE 59 5 1981-01-06 2022-02-02
96 HOUSE 691 0 1978-02-21 1980-12-31
96 JOINT 34 0 1979-03-27 1980-08-22
96 SENATE 681 0 1970-03-26 1981-12-31
95 HOUSE 781 0 1972-02-24 1979-12-31
95 JOINT 15 0 1977-05-25 1978-12-06
95 SENATE 615 4 1977-01-07 2011-12-15
94 HOUSE 712 0 1967-03-22 1978-07-06
94 JOINT 31 0 1975-02-06 1976-12-02
94 SENATE 589 0 1972-10-27 1979-07-28
93 HOUSE 582 0 1972-12-31 1975-12-31
93 JOINT 22 0 1973-01-23 1974-10-11
93 SENATE 530 0 1949-12-10 1975-01-09
92 HOUSE 402 0 1970-12-31 1973-12-31
92 JOINT 38 0 1971-02-03 1972-12-18
92 SENATE 567 0 1970-12-31 1973-12-31
91 HOUSE 406 7 1968-12-31 2003-07-09
91 JOINT 21 0 1969-04-17 1970-07-01
91 SENATE 412 0 1960-07-16 1970-12-31
90 HOUSE 330 0 1965-06-02 1968-12-31
90 JOINT 27 0 1967-01-25 1968-12-03
90 SENATE 347 0 1963-03-13 1969-12-31
89 HOUSE 321 0 1964-02-17 1966-12-31
89 JOINT 22 0 1965-01-27 1966-09-12
89 SENATE 347 6 1964-12-15 2021-05-18
88 HOUSE 311 4 1962-03-19 2019-10-17
88 JOINT 9 0 1963-05-13 1964-02-20
88 SENATE 248 0 1962-06-04 1965-12-31
87 HOUSE 331 11 1960-12-31 2007-06-01
87 JOINT 21 0 1961-01-24 1962-12-10
87 SENATE 286 0 1952-07-01 1962-12-31
86 HOUSE 1 0 1960-02-23 1960-02-23
86 SENATE 3 0 1997-03-20 1999-03-09
85 HOUSE 5 0 1957-04-15 1958-06-30
85 SENATE 3 0 1958-05-20 1958-07-09
84 HOUSE 9 0 1955-05-02 1956-10-03
84 SENATE 15 0 1955-02-25 1956-05-23
83 SENATE 1 0 2006-09-21 2006-09-21
82 HOUSE 1 0 1952-12-31 1952-12-31
82 SENATE 2 0 1972-08-01 1972-08-01
81 SENATE 1 0 2013-09-19 2013-09-19

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW hearing_activity AS
SELECT
    congress,
    chamber,
    COUNT(*) AS hearing_count,
    COUNT(DISTINCT hw.name) AS unique_witnesses,
    MIN(h.date_issued) AS earliest,
    MAX(h.date_issued) AS latest
FROM hearings h
LEFT JOIN hearing_witnesses hw ON hw.package_id = h.package_id
GROUP BY congress, chamber
ORDER BY congress DESC, chamber;