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 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

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;