member_stats (view)

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

12,770 rows

✎ View and edit SQL

This data as json, CSV (advanced)

bioguide_id trade_count speech_count bills_sponsored vote_count fec_total_received fec_ie_for fec_ie_against
C000127 6 1825 491 8825 393510 41758 0
K000367 0 1610 989 6872 6168774 211037 486
S000033 0 2600 572 9307 767055 4426 1666106
W000802 1037 2457 503 6872 3926412 736 265993
B001261 1 3296 357 6646 10143372 1251524 1048
W000437 10 1209 437 10051 8245761 431256 56015
C001035 637 3288 695 9497 10386691 12113001 55855099
C001056 2 5291 839 8192 12316577 13131488 19799714
D000563 0 13553 1285 9497 4979984 23175 799446
M000355 0 15946 540 9497 14068880 4741342 22615372
M001176 0 1878 671 6215 3523270 170435 1359836
R000122 0 3451 603 9497 5054318 198 8295
R000584 0 1335 259 6215 4242890 1553 1621
S001181 3 1540 626 6215 5406294 1393723 10002688
W000805 118 957 362 6215 10943661 249100 531100
G000555 0 702 637 8105 7159686 83726 282401
C001088 35 941 473 5570 7800411 33344 177079
A000055 3 514 97 15180 6310125 14 1611
B001230 0 1116 528 12605 7616789 14397379 75808669
B001267 10 1279 418 6205 7496007 4824454 18534613
B001257 0 1065 297 12745 6675398 556904 861
B000490 0 1177 138 15180 8923351 583271 873289
B001243 0 2041 522 14586 10335817 9414570 17495893
B001277 33 1511 701 5519 4793806 55551 3390571
B001236 483 1447 247 11485 7638076 2471880 861
B001260 152 218 209 12745 9319461 173328 1097882
C000059 0 1078 256 15180 8384740 1980719 8298921
C001047 746 1081 294 13152 10337845 683420 254137
C001072 0 485 165 11421 4482232 2337 16951
C001051 0 764 125 15166 5450422 193884 269936
C001075 215 881 519 8841 11998295 3258871 10851464
C001066 72 645 186 12745 4706446 26447 0
C001080 349 595 255 10321 4731733 71407 0
C001067 0 461 202 12745 4887035 290273 0
C001061 0 562 222 13959 7405286 16651 0
C000537 0 914 121 15180 15674404 1081 0
C001068 147 1325 456 12745 3897744 5386 15685
C001053 0 679 209 15180 9417242 614165 861
C001059 0 1352 175 13951 8371992 583085 637061
C001069 164 1001 176 12745 6154110 14734 11292
C000880 1 1487 375 9497 10143671 109185 861
C001087 0 278 131 9214 4680267 12542 1803362
C001063 0 811 98 13959 9365596 2730763 9716541
D000096 0 2518 386 15180 3844297 568820 0
D000197 0 644 234 15180 6116109 1797770 215821
D000216 0 2653 593 15180 6318105 177371 0
D000616 2 147 52 9214 1920128 239899 966495
D000600 4 611 104 15180 8037336 1283 370785
D000399 176 1190 258 15180 3445316 13719 0
F000459 0 162 47 9214 4886682 34462 60149
F000450 928 2124 228 13959 5668369 20629 229713
G000559 7 1230 187 10012 5702657 6273 101932
G000565 0 529 247 9214 1954332 866050 2059449
G000386 0 6476 1466 9497 9320121 2819916 182615
G000546 0 2330 252 15180 11058119 6031 861
G000553 1 1111 348 13959 1420626 1271 47523
G000568 0 428 201 9214 5667344 135474 1611
G000558 0 552 138 10869 14682879 121686 11804
H001052 0 262 42 9214 4120742 311188 2077714
H001046 0 721 334 8294 8088651 1019792 4287435
H001047 5 328 104 10869 9152366 37973 96286
H001042 0 1267 437 10170 4598393 118179 585000
H001061 225 779 216 5519 6015678 400678 3811
H000874 0 3546 352 15180 19641700 10911 9
H001058 0 435 152 9214 9760196 738290 875845
J000288 0 1095 223 12745 3960447 2070 0
J000293 2 648 195 5519 5181699 27876781 45284487
J000289 1 473 38 12745 3791697 122773 103168
K000009 1 2614 456 15180 7658609 1829576 7172455
K000375 201 500 142 9214 4033840 5637 705668
K000376 74 303 178 9214 8582126 196872 1059323
L000575 0 1171 311 7186 6273419 286841 433365
L000560 90 328 175 15180 8952558 27554 628159
L000557 34 1042 255 15180 10400699 54958 56656
L000566 23 605 233 11584 7227612 9699 2145
L000577 0 2333 611 5519 3944457 6658654 4602713
L000397 463 1263 350 15180 4399476 316608 0
L000491 0 379 114 15180 7997573 67876 1826
L000570 0 469 376 10509 8252750 1548382 404478
L000562 13 518 225 15180 4598023 310506 714939
M000133 0 1930 1280 12786 4953355 6694345 3759123
M001163 39 861 282 13896 6980420 4154 140000
M001157 0 561 240 13959 6384543 217850 116121
M001177 0 854 109 10869 1566754 30145 983015
M001143 0 1500 163 15180 4852451 336520 28481
M000312 3 2267 402 15180 3731853 1982 11205
M001137 0 495 234 15175 8054648 70316 0
M001160 0 843 241 13959 6547457 49728 0
M000934 286 1622 485 11485 8572193 296050 3811
M001153 0 2184 619 8192 9353830 8356346 1510071
M001169 0 1247 354 10170 4809888 1230753 126889
M001111 161 3386 654 9497 10411137 3316378 15103118
N000002 0 1550 447 15175 4316163 77437 0
N000015 0 898 233 15180 17747301 611492 755176
N000147 24 2834 1104 1745 1893587 191 0
P000034 12 3422 537 15180 18774037 10064 125716
P000603 1 1260 462 5519 2735867 1399876 4344618
P000197 221 2248 135 10208 9763308 39192 2453098
P000595 203 1172 572 8841 9683277 16930269 48769538
P000597 26 337 173 10869 2068955 68088 103657

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, fec_ie_for, fec_ie_against
        FROM congress_members;