member_stats (view)

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

12,766 rows

✎ View and edit SQL

This data as json, CSV (advanced)

bioguide_id trade_count speech_count bills_sponsored vote_count fec_total_received
C000127 6 1780 486 8674 620082
K000367 0 1574 973 6721 6467562
S000033 0 2569 555 9149 2437587
W000802 1016 2396 470 6721 4294894
B001261 1 2986 344 6495 11259582
W000437 10 1181 427 9818 8697001
C001035 637 3255 687 9346 74808480
C001056 2 5217 803 8041 42730377
D000563 0 13210 1244 9346 5891828
G000359 19 1191 445 8041 29283180
M000355 0 15935 538 9346 42685689
M001176 0 1806 617 6064 4978375
R000122 0 3395 588 9346 4757051
R000584 0 1189 247 6064 3941717
S001181 3 1450 592 6064 17027727
W000805 115 917 332 6064 11472627
G000555 0 697 612 7879 8160313
C001088 34 894 449 5419 7629243
A000055 3 506 96 14368 6102130
B001230 0 1054 504 12371 100365432
B001267 10 1184 384 6054 32308392
B001257 0 957 284 11940 6766246
B000490 0 1128 133 14368 10424937
B001243 0 1979 496 14351 38279120
B001277 0 1416 665 5368 8467088
B001236 362 1421 236 11252 10058733
B001260 152 213 206 11940 10683852
C000059 0 1066 249 14368 17923347
C001047 737 1072 287 12918 10570792
C001072 0 476 164 10691 4314782
C001051 0 736 124 14354 5744894
C001075 215 800 489 8689 25398324
C001066 72 626 178 11940 4125181
C001080 349 575 242 9591 4680421
C001067 0 451 194 11940 4675481
C001061 0 551 212 13148 6985456
C000537 0 908 119 14368 15351699
C001068 139 1312 446 11940 3832826
C001053 0 666 206 14368 9098898
C001059 0 1339 173 13140 9365086
C001069 164 982 168 11940 6124290
C000880 1 1460 369 9346 10137509
C001087 0 267 125 8484 6298250
C001063 0 801 95 13148 21492072
D000096 0 2500 381 14368 4498689
D000197 0 635 230 14368 5594348
D000216 0 2631 581 14368 6250652
D000616 2 145 52 8484 3076774
D000600 4 601 101 14368 8054025
D000399 168 1180 251 14368 3498379
F000459 0 158 45 8484 4701576
F000450 924 2099 217 13148 5592920
G000559 7 1208 182 9282 5760742
G000565 0 526 241 8484 4961147
G000386 0 6372 1438 9346 13001247
G000546 0 2316 249 14368 11000560
G000553 1 1084 329 13148 1379758
G000568 0 413 194 8484 5301820
G000558 0 498 133 10139 13539361
H001052 0 258 40 8484 6338416
H001046 0 601 305 8142 14054849
H001047 2 319 100 10139 8938239
H001042 0 1206 416 9943 5542568
H001061 225 758 207 5368 6528965
H000874 0 3530 351 14368 19934329
H001058 0 429 142 8484 9481822
J000288 0 1088 217 11940 3833577
J000293 2 629 192 5368 82015908
J000289 1 452 38 11940 3667143
K000009 1 2567 444 14368 16386562
K000375 190 493 136 8484 4779675
K000376 61 301 169 8484 9653117
L000575 0 1117 289 7034 6874480
L000560 86 322 170 14368 9150718
L000557 34 1035 246 14368 9846868
L000566 21 590 227 10854 6880134
L000577 0 2279 578 5368 15287291
L000397 463 1245 340 14368 4463494
L000491 0 374 112 14368 7736959
L000570 0 398 341 10354 9337078
L000562 13 513 221 14368 5435650
M000133 0 1900 1225 12552 14910347
M001163 39 848 272 13091 6476964
M001157 0 556 232 13148 6836278
M001177 0 844 105 10139 2487706
M001143 0 1476 158 14368 5008002
M000312 3 2215 395 14368 3639513
M001137 0 479 226 14363 7732459
M001160 0 829 227 13148 6282595
M000934 279 1568 468 11252 8716152
M001153 0 2121 599 8041 19254369
M001169 0 1201 326 9943 6996209
M001111 161 3339 634 9346 30543004
N000002 0 1540 442 14363 4395194
N000015 0 890 230 14368 18600852
N000147 24 2805 1071 1697 1902115
P000034 12 3385 534 14368 18275195
P000603 1 1215 452 5368 9835595
P000197 212 2239 135 9895 12672093
P000595 197 1113 555 8689 78915125

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW member_stats AS
        SELECT bioguide_id, trade_count, speech_count, bills_sponsored, vote_count, fec_total_received
        FROM congress_members;