member_stats (view)
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
12,766 rows
This data as json, CSV (advanced)
| bioguide_id | trade_count | speech_count | bills_sponsored | vote_count | fec_total_received |
|---|---|---|---|---|---|
| C000127 | 6 | 1780 | 489 | 8682 | 620082 |
| K000367 | 0 | 1574 | 979 | 6729 | 6467562 |
| S000033 | 0 | 2569 | 561 | 9157 | 2437587 |
| W000802 | 1017 | 2396 | 487 | 6729 | 4294894 |
| B001261 | 1 | 2986 | 351 | 6503 | 11259582 |
| W000437 | 10 | 1181 | 431 | 9826 | 8697001 |
| C001035 | 637 | 3255 | 691 | 9354 | 74808480 |
| C001056 | 2 | 5217 | 813 | 8049 | 42730377 |
| D000563 | 0 | 13210 | 1266 | 9354 | 5891828 |
| G000359 | 19 | 1191 | 449 | 8049 | 29283180 |
| M000355 | 0 | 15935 | 538 | 9354 | 42685689 |
| M001176 | 0 | 1806 | 627 | 6072 | 4978375 |
| R000122 | 0 | 3395 | 595 | 9354 | 4757051 |
| R000584 | 0 | 1189 | 250 | 6072 | 3941717 |
| S001181 | 3 | 1450 | 605 | 6072 | 17027727 |
| W000805 | 115 | 917 | 339 | 6072 | 11472627 |
| G000555 | 0 | 697 | 618 | 7887 | 8160313 |
| C001088 | 34 | 894 | 458 | 5427 | 7629243 |
| A000055 | 3 | 506 | 96 | 14386 | 6102130 |
| B001230 | 0 | 1054 | 514 | 12379 | 100365432 |
| B001267 | 10 | 1184 | 394 | 6062 | 32308392 |
| B001257 | 0 | 957 | 289 | 11958 | 6766246 |
| B000490 | 0 | 1128 | 137 | 14386 | 10424937 |
| B001243 | 0 | 1979 | 508 | 14359 | 38279120 |
| B001277 | 0 | 1416 | 671 | 5376 | 8467088 |
| B001236 | 365 | 1421 | 239 | 11260 | 10058733 |
| B001260 | 152 | 213 | 207 | 11958 | 10683852 |
| C000059 | 0 | 1066 | 252 | 14386 | 17923347 |
| C001047 | 740 | 1072 | 289 | 12926 | 10570792 |
| C001072 | 0 | 476 | 164 | 10709 | 4314782 |
| C001051 | 0 | 736 | 125 | 14372 | 5744894 |
| C001075 | 215 | 800 | 498 | 8697 | 25398324 |
| C001066 | 72 | 626 | 179 | 11958 | 4125181 |
| C001080 | 349 | 575 | 246 | 9609 | 4680421 |
| C001067 | 0 | 451 | 195 | 11958 | 4675481 |
| C001061 | 0 | 551 | 217 | 13166 | 6985456 |
| C000537 | 0 | 908 | 120 | 14386 | 15351699 |
| C001068 | 140 | 1312 | 447 | 11958 | 3832826 |
| C001053 | 0 | 666 | 206 | 14386 | 9098898 |
| C001059 | 0 | 1339 | 174 | 13158 | 9365086 |
| C001069 | 164 | 982 | 171 | 11958 | 6124290 |
| C000880 | 1 | 1460 | 370 | 9354 | 10137509 |
| C001087 | 0 | 267 | 127 | 8502 | 6298250 |
| C001063 | 0 | 801 | 96 | 13166 | 21492072 |
| D000096 | 0 | 2500 | 381 | 14386 | 4498689 |
| D000197 | 0 | 635 | 231 | 14386 | 5594348 |
| D000216 | 0 | 2631 | 585 | 14386 | 6250652 |
| D000616 | 2 | 145 | 52 | 8502 | 3076774 |
| D000600 | 4 | 601 | 102 | 14386 | 8054025 |
| D000399 | 169 | 1180 | 252 | 14386 | 3498379 |
| F000459 | 0 | 158 | 46 | 8502 | 4701576 |
| F000450 | 924 | 2099 | 220 | 13166 | 5592920 |
| G000559 | 7 | 1208 | 184 | 9300 | 5760742 |
| G000565 | 0 | 526 | 243 | 8502 | 4961147 |
| G000386 | 0 | 6372 | 1449 | 9354 | 13001247 |
| G000546 | 0 | 2316 | 250 | 14386 | 11000560 |
| G000553 | 1 | 1084 | 339 | 13166 | 1379758 |
| G000568 | 0 | 413 | 196 | 8502 | 5301820 |
| G000558 | 0 | 498 | 136 | 10157 | 13539361 |
| H001052 | 0 | 258 | 41 | 8502 | 6338416 |
| H001046 | 0 | 601 | 314 | 8150 | 14054849 |
| H001047 | 2 | 319 | 101 | 10157 | 8938239 |
| H001042 | 0 | 1206 | 424 | 9951 | 5542568 |
| H001061 | 225 | 758 | 208 | 5376 | 6528965 |
| H000874 | 0 | 3530 | 351 | 14386 | 19934329 |
| H001058 | 0 | 429 | 147 | 8502 | 9481822 |
| J000288 | 0 | 1088 | 218 | 11958 | 3833577 |
| J000293 | 2 | 629 | 192 | 5376 | 82015908 |
| J000289 | 1 | 452 | 38 | 11958 | 3667143 |
| K000009 | 1 | 2567 | 446 | 14386 | 16386562 |
| K000375 | 190 | 493 | 138 | 8502 | 4779675 |
| K000376 | 61 | 301 | 172 | 8502 | 9653117 |
| L000575 | 0 | 1117 | 295 | 7042 | 6874480 |
| L000560 | 86 | 322 | 171 | 14386 | 9150718 |
| L000557 | 34 | 1035 | 251 | 14386 | 9846868 |
| L000566 | 21 | 590 | 228 | 10872 | 6880134 |
| L000577 | 0 | 2279 | 589 | 5376 | 15287291 |
| L000397 | 463 | 1245 | 344 | 14386 | 4463494 |
| L000491 | 0 | 374 | 113 | 14386 | 7736959 |
| L000570 | 0 | 398 | 351 | 10362 | 9337078 |
| L000562 | 13 | 513 | 223 | 14386 | 5435650 |
| M000133 | 0 | 1900 | 1245 | 12560 | 14910347 |
| M001163 | 39 | 848 | 276 | 13109 | 6476964 |
| M001157 | 0 | 556 | 235 | 13166 | 6836278 |
| M001177 | 0 | 844 | 107 | 10157 | 2487706 |
| M001143 | 0 | 1476 | 159 | 14386 | 5008002 |
| M000312 | 3 | 2215 | 395 | 14386 | 3639513 |
| M001137 | 0 | 479 | 230 | 14381 | 7732459 |
| M001160 | 0 | 829 | 235 | 13166 | 6282595 |
| M000934 | 279 | 1568 | 472 | 11260 | 8716152 |
| M001153 | 0 | 2121 | 608 | 8049 | 19254369 |
| M001169 | 0 | 1201 | 335 | 9951 | 6996209 |
| M001111 | 161 | 3339 | 638 | 9354 | 30543004 |
| N000002 | 0 | 1540 | 444 | 14381 | 4395194 |
| N000015 | 0 | 890 | 231 | 14386 | 18600852 |
| N000147 | 24 | 2805 | 1080 | 1706 | 1902115 |
| P000034 | 12 | 3385 | 535 | 14386 | 18275195 |
| P000603 | 1 | 1215 | 454 | 5376 | 9835595 |
| P000197 | 212 | 2239 | 135 | 9913 | 12672093 |
| P000595 | 197 | 1113 | 557 | 8697 | 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;