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 8693 620082
K000367 0 1574 979 6740 6467562
S000033 0 2569 562 9168 2437587
W000802 1017 2396 487 6740 4294894
B001261 1 2986 352 6514 11259582
W000437 10 1181 431 9837 8697001
C001035 637 3255 692 9365 74808480
C001056 2 5217 819 8060 42730377
D000563 0 13210 1270 9365 5891828
G000359 19 1191 450 8060 29283180
M000355 0 15935 539 9365 42685689
M001176 0 1806 627 6083 4978375
R000122 0 3395 595 9365 4757051
R000584 0 1189 250 6083 3941717
S001181 3 1450 605 6083 17027727
W000805 115 917 339 6083 11472627
G000555 0 697 619 7898 8160313
C001088 34 894 458 5438 7629243
A000055 3 506 96 14406 6102130
B001230 0 1054 514 12390 100365432
B001267 10 1184 394 6073 32308392
B001257 0 957 289 11978 6766246
B000490 0 1128 137 14406 10424937
B001243 0 1979 508 14370 38279120
B001277 0 1416 672 5387 8467088
B001236 374 1421 239 11271 10058733
B001260 152 213 207 11978 10683852
C000059 0 1066 252 14406 17923347
C001047 740 1072 289 12937 10570792
C001072 0 476 164 10729 4314782
C001051 0 736 125 14392 5744894
C001075 215 800 498 8708 25398324
C001066 72 626 179 11978 4125181
C001080 349 575 246 9629 4680421
C001067 0 451 197 11978 4675481
C001061 0 551 217 13186 6985456
C000537 0 908 120 14406 15351699
C001068 140 1312 447 11978 3832826
C001053 0 666 206 14406 9098898
C001059 0 1339 174 13178 9365086
C001069 164 982 171 11978 6124290
C000880 1 1460 371 9365 10137509
C001087 0 267 127 8522 6298250
C001063 0 801 96 13186 21492072
D000096 0 2500 381 14406 4498689
D000197 0 635 232 14406 5594348
D000216 0 2631 586 14406 6250652
D000616 2 145 52 8522 3076774
D000600 4 601 102 14406 8054025
D000399 169 1180 253 14406 3498379
F000459 0 158 46 8522 4701576
F000450 924 2099 221 13186 5592920
G000559 7 1208 184 9320 5760742
G000565 0 526 243 8522 4961147
G000386 0 6372 1451 9365 13001247
G000546 0 2316 250 14406 11000560
G000553 1 1084 339 13186 1379758
G000568 0 413 197 8522 5301820
G000558 0 498 137 10177 13539361
H001052 0 258 41 8522 6338416
H001046 0 601 314 8161 14054849
H001047 2 319 101 10177 8938239
H001042 0 1206 424 9962 5542568
H001061 225 758 208 5387 6528965
H000874 0 3530 351 14406 19934329
H001058 0 429 148 8522 9481822
J000288 0 1088 218 11978 3833577
J000293 2 629 192 5387 82015908
J000289 1 452 38 11978 3667143
K000009 1 2567 446 14406 16386562
K000375 190 493 138 8522 4779675
K000376 61 301 172 8522 9653117
L000575 0 1117 297 7053 6874480
L000560 86 322 172 14406 9150718
L000557 34 1035 251 14406 9846868
L000566 21 590 228 10892 6880134
L000577 0 2279 589 5387 15287291
L000397 463 1245 344 14406 4463494
L000491 0 374 113 14406 7736959
L000570 0 398 353 10373 9337078
L000562 13 513 224 14406 5435650
M000133 0 1900 1246 12571 14910347
M001163 39 848 276 13129 6476964
M001157 0 556 235 13186 6836278
M001177 0 844 107 10177 2487706
M001143 0 1476 159 14406 5008002
M000312 3 2215 395 14406 3639513
M001137 0 479 231 14401 7732459
M001160 0 829 235 13186 6282595
M000934 279 1568 474 11271 8716152
M001153 0 2121 608 8060 19254369
M001169 0 1201 337 9962 6996209
M001111 161 3339 641 9365 30543004
N000002 0 1540 444 14401 4395194
N000015 0 890 231 14406 18600852
N000147 24 2805 1081 1707 1902115
P000034 12 3385 535 14406 18275195
P000603 1 1215 455 5387 9835595
P000197 212 2239 135 9933 12672093
P000595 200 1113 557 8708 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;