member_stats (view)
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
12,763 rows
This data as json, CSV (advanced)
| bioguide_id | trade_count | speech_count | bills_sponsored | vote_count | fec_total_received |
|---|---|---|---|---|---|
| C000127 | 6 | 1780 | 468 | 8615 | 620082 |
| K000367 | 0 | 1574 | 973 | 6662 | 6467562 |
| S000033 | 0 | 2569 | 531 | 9090 | 2437587 |
| W000802 | 1010 | 2396 | 470 | 6662 | 4294894 |
| B001261 | 1 | 2986 | 344 | 6436 | 11259582 |
| W000437 | 10 | 1181 | 415 | 9759 | 8697001 |
| C001035 | 635 | 3255 | 632 | 9287 | 74808480 |
| C001056 | 2 | 5217 | 803 | 7982 | 42730377 |
| D000563 | 0 | 13210 | 1173 | 9287 | 5891828 |
| G000359 | 19 | 1191 | 425 | 7982 | 29283180 |
| M000355 | 0 | 15935 | 501 | 9287 | 42685689 |
| M001176 | 0 | 1806 | 617 | 6005 | 4978375 |
| R000122 | 0 | 3395 | 552 | 9287 | 4757051 |
| R000584 | 0 | 1189 | 247 | 6005 | 3941717 |
| S001181 | 3 | 1450 | 592 | 6005 | 17027727 |
| W000805 | 115 | 917 | 332 | 6005 | 11472627 |
| G000555 | 0 | 697 | 612 | 7820 | 8160313 |
| C001088 | 34 | 894 | 449 | 5360 | 7629243 |
| A000055 | 3 | 506 | 93 | 14314 | 6102130 |
| B001230 | 0 | 1054 | 490 | 12312 | 100365432 |
| B001267 | 10 | 1184 | 384 | 5995 | 32308392 |
| B001257 | 0 | 957 | 284 | 11886 | 6766246 |
| B000490 | 0 | 1128 | 128 | 14314 | 10424937 |
| B001243 | 0 | 1979 | 496 | 14292 | 38279120 |
| B001277 | 0 | 1416 | 665 | 5309 | 8467088 |
| B001236 | 334 | 1421 | 234 | 11193 | 10058733 |
| B001260 | 152 | 213 | 206 | 11886 | 10683852 |
| C000059 | 0 | 1066 | 232 | 14314 | 17923347 |
| C001047 | 725 | 1072 | 279 | 12859 | 10570792 |
| C001072 | 0 | 476 | 164 | 10637 | 4314782 |
| C001051 | 0 | 736 | 124 | 14300 | 5744894 |
| C001075 | 215 | 800 | 489 | 8630 | 25398324 |
| C001066 | 72 | 626 | 178 | 11886 | 4125181 |
| C001080 | 349 | 575 | 242 | 9537 | 4680421 |
| C001067 | 0 | 451 | 194 | 11886 | 4675481 |
| C001061 | 0 | 551 | 212 | 13094 | 6985456 |
| C000537 | 0 | 908 | 114 | 14314 | 15351699 |
| C001068 | 137 | 1312 | 446 | 11886 | 3832826 |
| C001053 | 0 | 666 | 206 | 14314 | 9098898 |
| C001059 | 0 | 1339 | 173 | 13086 | 9365086 |
| C001069 | 164 | 982 | 168 | 11886 | 6124290 |
| C000880 | 1 | 1460 | 346 | 9287 | 10137509 |
| C001087 | 0 | 267 | 125 | 8430 | 6298250 |
| C001063 | 0 | 801 | 95 | 13094 | 21492072 |
| D000096 | 0 | 2500 | 360 | 14314 | 4498689 |
| D000197 | 0 | 635 | 218 | 14314 | 5594348 |
| D000216 | 0 | 2631 | 566 | 14314 | 6250652 |
| D000616 | 2 | 145 | 52 | 8430 | 3076774 |
| D000600 | 4 | 601 | 101 | 14314 | 8054025 |
| D000399 | 163 | 1180 | 241 | 14314 | 3498379 |
| F000459 | 0 | 158 | 45 | 8430 | 4701576 |
| F000450 | 923 | 2099 | 217 | 13094 | 5592920 |
| G000559 | 7 | 1208 | 182 | 9228 | 5760742 |
| G000565 | 0 | 526 | 241 | 8430 | 4961147 |
| G000386 | 0 | 6372 | 1374 | 9287 | 13001247 |
| G000546 | 0 | 2316 | 236 | 14314 | 11000560 |
| G000553 | 1 | 1084 | 329 | 13094 | 1379758 |
| G000568 | 0 | 413 | 194 | 8430 | 5301820 |
| G000558 | 0 | 498 | 133 | 10085 | 13539361 |
| H001052 | 0 | 258 | 40 | 8430 | 6338416 |
| H001046 | 0 | 601 | 305 | 8083 | 14054849 |
| H001047 | 2 | 319 | 100 | 10085 | 8938239 |
| H001042 | 0 | 1206 | 416 | 9884 | 5542568 |
| H001061 | 225 | 758 | 207 | 5309 | 6528965 |
| H000874 | 0 | 3530 | 335 | 14314 | 19934329 |
| H001058 | 0 | 429 | 142 | 8430 | 9481822 |
| J000288 | 0 | 1088 | 217 | 11886 | 3833577 |
| J000293 | 2 | 629 | 192 | 5309 | 82015908 |
| J000289 | 1 | 452 | 38 | 11886 | 3667143 |
| K000009 | 1 | 2567 | 422 | 14314 | 16386562 |
| K000375 | 186 | 493 | 136 | 8430 | 4779675 |
| K000376 | 56 | 301 | 169 | 8430 | 9653117 |
| L000575 | 0 | 1117 | 289 | 6975 | 6874480 |
| L000560 | 75 | 322 | 158 | 14314 | 9150718 |
| L000557 | 34 | 1035 | 236 | 14314 | 9846868 |
| L000566 | 20 | 590 | 227 | 10800 | 6880134 |
| L000577 | 0 | 2279 | 578 | 5309 | 15287291 |
| L000397 | 463 | 1245 | 323 | 14314 | 4463494 |
| L000491 | 0 | 374 | 106 | 14314 | 7736959 |
| L000570 | 0 | 398 | 341 | 10295 | 9337078 |
| L000562 | 13 | 513 | 213 | 14314 | 5435650 |
| M000133 | 0 | 1900 | 1196 | 12493 | 14910347 |
| M001163 | 39 | 848 | 272 | 13037 | 6476964 |
| M001157 | 0 | 556 | 232 | 13094 | 6836278 |
| M001177 | 0 | 844 | 105 | 10085 | 2487706 |
| M001143 | 0 | 1476 | 151 | 14314 | 5008002 |
| M000312 | 3 | 2215 | 382 | 14314 | 3639513 |
| M001137 | 0 | 479 | 219 | 14309 | 7732459 |
| M001160 | 0 | 829 | 227 | 13094 | 6282595 |
| M000934 | 279 | 1568 | 445 | 11193 | 8716152 |
| M001153 | 0 | 2121 | 599 | 7982 | 19254369 |
| M001169 | 0 | 1201 | 326 | 9884 | 6996209 |
| M001111 | 161 | 3339 | 605 | 9287 | 30543004 |
| N000002 | 0 | 1540 | 409 | 14309 | 4395194 |
| N000015 | 0 | 890 | 211 | 14314 | 18600852 |
| N000147 | 24 | 2805 | 1047 | 1697 | 1902115 |
| P000034 | 12 | 3385 | 491 | 14314 | 18275195 |
| P000603 | 1 | 1215 | 452 | 5309 | 9835595 |
| P000197 | 212 | 2239 | 128 | 9841 | 12672093 |
| P000595 | 197 | 1113 | 555 | 8630 | 78915125 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW member_stats AS
SELECT bioguide_id, trade_count, speech_count, bills_sponsored, vote_count, fec_total_received
FROM congress_members;