home / openregs

Congressional Record by Congress

Volume of floor activity per Congress — speeches, proceedings, and extensions of remarks.

Custom SQL query returning 51 rows (hide)

SELECT congress, chamber, COUNT(*) AS entries, COUNT(DISTINCT date) AS session_days FROM congressional_record WHERE congress IS NOT NULL GROUP BY congress, chamber ORDER BY congress DESC, chamber

Edit SQL

This data as json, CSV

congresschamberentriessession_days
119   257 252
119 HOUSE 21205 252
119 SENATE 15352 252
118   406 400
118 HOUSE 34227 400
118 SENATE 19362 400
117   427 417
117 HOUSE 31298 418
117 SENATE 24645 418
116   442 432
116 HOUSE 33193 432
116 SENATE 20946 432
115   430 417
115 HOUSE 37506 418
115 SENATE 22754 418
114   376 372
114 HOUSE 34910 372
114 SENATE 21080 372
113   348 338
113 HOUSE 33873 339
113 SENATE 20201 340
112   351 346
112 HOUSE 37342 372
112 SENATE 20079 372
111   305 298
111 HOUSE 38254 374
111 SENATE 24834 374
110   284 280
110 HOUSE 36582 392
110 SENATE 26618 392
109   243 239
109 HOUSE 32150 305
109 SENATE 24089 305
108   251 243
108 HOUSE 31359 317
108 SENATE 23355 317
107   258 256
107 HOUSE 27866 332
107 SENATE 20410 333
106   260 256
106 HOUSE 30820 320
106 SENATE 19373 320
105   241 240
105 HOUSE 28970 312
105 SENATE 18783 312
104   335 278
104 HOUSE 32573 356
104 SENATE 19739 356
103   45 41
103 HOUSE 5988 58
103 SENATE 3588 58
Powered by Datasette · Queries took 4087.334ms