House pre-2016 member office totals

Member-office OFFICE TOTALS for 2009Q3–2015Q4, deduplicated (OCR continuation pages collapsed).

Custom SQL query returning 200 rows (hide) 

SELECT office_name, quarter, ROUND(quarter_amount,2) AS quarter_amount
FROM house_pre2016_office_totals_dedup
WHERE office_type='member' AND category='OFFICE TOTALS'
ORDER BY quarter_amount DESC
LIMIT 200

Edit SQL

This data as json, CSV

office_namequarterquarter_amount
HON. TODD C. YOUNG 2013Q4 1530367.21
HON. TODD C. YOUNG 2011Q2 757439.02
HON. PEDRO R. PIERLUISI 2012Q3 710764.86
HON. ANH ″JOSEPH″ CAO 2010Q2 594845.87
HON. PEDRO R. PIERLUISI 2011Q3 592124.29
HON. DEVIN NUNES 2010Q4 572009.84
HON. VERN BUCHANAN 2010Q2 569046.83
HON. NANCY PELOSI 2010Q3 564698.39
HON. DEBORAH L. HALVORSON 2010Q3 554184.22
HON. SUZANNE M. KOSMAS 2010Q2 550866.79
HON. RICK BERG 2011Q4 544538.46
HON. KATHLEEN A. DAHLKEMPER 2010Q4 541810.99
HON. MARION BERRY 2010Q4 540385.54
HON. BILL FOSTER 2010Q3 537786.96
HON. SEAN P. DUFFY 2012Q2 537710.1
HON. BRAD SHERMAN 2010Q3 536659.89
HON. PEDRO R. PIERLUISI 2014Q3 535339.98
HON. KENDRICK B. MEEK 2010Q4 533766.55
HON. DEVIN NUNES 2009Q4 532941.19
HON. PETER J. ROSKAM 2010Q3 525698.45
HON. MIKE THOMPSON 2011Q4 522243.34
HON. CAROLYN C. KILPATRICK 2010Q2 516565.86
HON. CHRIS VAN HOLLEN 2009Q4 515169.92
HON. CHET EDWARDS 2010Q3 514958.19
HON. MARK H. SCHAUER 2010Q2 514322.63
HON. PEDRO R. PIERLUISI 2013Q3 509090.08
HON. DORIS MATSUI 2009Q4 507331.29
HON. XAVIER BECERRA 2009Q4 506379.78
HON. JUDY BIGGERT 2010Q3 506270.12
HON. JOHN H. ADLER 2010Q3 503911.96
HON. DAVID WU 2010Q3 503318.95
HON. DORIS MATSUI 2010Q4 499830.92
HON. JAMES P. MORAN 2011Q4 499423.4
HON. DEVIN NUNES 2011Q4 498817.14
HON. RON KLEIN 2010Q2 498314.78
HON. NANCY PELOSI 2009Q4 496891.11
HON. BILL FOSTER 2009Q4 495650.64
HON. DAVID G. REICHERT 2010Q2 494795.62
HON. JIM COSTA 2010Q3 493464.49
HON. GINNY BROWN-WAITE 2009Q4 492148.18
HON. TOM MCCLINTOCK 2009Q4 491470.21
HON. PEDRO R. PIERLUISI 2010Q3 490088.42
HON. STEVE KAGEN 2010Q2 489386.46
HON. LAMAR SMITH 2009Q4 488988.44
HON. RUSS CARNAHAN 2010Q2 488508.33
HON. LAMAR SMITH 2010Q3 488430.98
HON. SCOTT MURPHY 2010Q3 487938.85
HON. PEDRO R. PIERLUISI 2010Q1 487388.44
HON. JOHN L MICA 2010Q3 486544.42
HON. HENRY CUELLAR 2010Q3 486028.14
HON. BARON P. HILL 2010Q4 484252.66
HON. CHRISTOPHER J. LEE 2010Q2 483298.74
HON. JAMES P MORAN JR 2010Q3 482303.37
HON. DANIEL LIPINSKI 2009Q4 480983.63
HON. JIM MARSHALL 2010Q4 477843.27
HON. FORTNEY PETE STARK 2009Q4 476935.05
HON. CIRO RODRIGUEZ 2010Q3 476475.43
HON. FORTNEY PETE STARK 2011Q4 476050.49
HON. DINA TITUS 2010Q3 475386.01
HON. JOHN M. SPRATT, JR 2010Q4 474341.88
HON. ALAN GRAYSON 2010Q4 474261.79
HON. TED POE 2009Q4 473360.52
HON. JAMES L. OBERSTAR 2010Q4 473267.51
HON. EMANUEL CLEAVER 2010Q3 472742.91
HON. DAN BOREN 2009Q4 472714.59
HON. DON YOUNG 2009Q4 472077.72
HON. GINNY BROWN-WAITE 2010Q4 471914.1
HON. KEN CALVERT 2010Q4 471169.86
HON. ANDRE CARSON 2012Q4 470818.77
HON. JOHN A. BOCCIERI 2010Q3 470498.69
HON. DEVIN NUNES 2012Q4 470270.33
HON. GUS M. BILIRAKIS 2009Q4 470149.96
HON. JUDY BIGGERT 2009Q4 470016.09
HON. JIM MATHESON 2010Q4 469727.77
HON. CATHY MCMORRIS RODGERS 2010Q2 468253.7
HON. MELISSA L. BEAN 2010Q3 467962.98
HON. ROSCOE G. BARTLETT 2012Q4 467537.7
HON. HANSEN CLARKE 2011Q4 467146.83
HON. DON YOUNG 2010Q4 467116.93
HON. MELISSA L. BEAN 2010Q4 466909.06
HON. JANICE D. SCHAKOWSKY 2009Q4 466730.18
HON. CAROLYN B MALONEY 2010Q3 466411.64
HON. DAVID SCOTT 2010Q2 465286.46
HON. JOHN LINDER 2010Q4 464738.65
HON. DAVID E PRICE 2009Q4 462242.37
HON. DON YOUNG 2012Q4 460964.21
HON. LEONARD L. BOSWELL 2009Q4 460879.32
HON. LYNN C WOOLSEY 2010Q3 459921.39
HON. DANIEL B. MAFFEI 2010Q4 459805.44
HON. DAN BOREN 2011Q4 459511.95
HON. DAN BOREN 2010Q4 459123.42
HON. CHARLES A. GONZALEZ 2011Q4 459035.06
HON. TED POE 2010Q3 458772.96
HON. JOE COURTNEY 2010Q3 458665.71
HON. MICHAEL T. MCCAUL 2011Q4 458127.61
HON. ZACHARY T. SPACE 2010Q3 457935.95
HON. JOE WALSH 2011Q4 457485.88
HON. DAN BENISHEK 2011Q4 457182.26
HON. ANTHONY D. WEINER 2010Q3 456971.07
HON. LUIS V. GUTIERREZ 2010Q4 456913.77
HON. RUSS CARNAHAN 2011Q4 456245.83
HON. BILL PASCRELL, JR 2010Q3 456052.43
HON. DANNY K. DAVIS 2010Q3 455458.32
HON. COLLEEN W. HANABUSA 2012Q4 455364.43
HON. GWEN MOORE 2011Q4 455035.9
HON. PEDRO R. PIERLUISI 2010Q4 454241.58
HON. ZOE LOFGREN 2009Q4 453357.7
HON. JESSE L JACKSON JR 2009Q4 453092.06
HON. CLIFF STEARNS 2010Q2 452753.31
HON. ADAM B. SCHIFF 2010Q3 452735.5
HON. JEFF DENHAM 2011Q4 452340.63
HON. STEVE KAGEN 2009Q3 452306.51
HON. DENNIS R. REHBERG 2011Q4 452304.66
HON. MICHAEL F DOYLE 2010Q3 452176.27
HON. FRANK D LUCAS 2009Q4 451608.03
HON. CHARLIE MELANCON 2010Q2 451487.87
HON. TIMOTHY H. BISHOP 2010Q3 451377.09
HON. HOWARD BERMAN 2010Q4 451264.62
HON. GABRIELLE GIFFORDS 2010Q2 451020.07
HON. DAVID LOEBSACK 2010Q3 450925.18
HON. GEORGE MILLER 2009Q4 450890.72
HON. AARON SCHOCK 2010Q3 450832.05
HON. J. RANDY FORBES 2010Q3 450480.65
HON. JANICE D. SCHAKOWSKY 2011Q4 450187.39
HON. MAXINE WATERS 2011Q4 449950.96
HON. RYAN K. ZINKE 2015Q4 449842.98
HON. SUSAN A. DAVIS 2009Q4 449616.42
HON. ALAN GRAYSON 2009Q3 449330.75
HON. JOHN LEWIS 2012Q1 449065.51
HON. FORTNEY PETE STARK 2010Q4 448391.6
HON. FRED UPTON 2010Q4 447458.8
HON. WILLIAM D. DELAHUNT 2010Q4 447354.37
HON. ROBERT J. DOLD 2011Q4 447353.01
HON. JERRY LEWIS 2010Q4 447129.91
HON. JOHN KLINE 2012Q2 447115.17
HON. BART GORDON 2009Q3 445671.98
HON. LOIS CAPPS 2009Q4 445231.75
HON. AARON SCHOCK 2014Q4 445133.09
HON. ERIK PAULSEN 2010Q2 444980.38
HON. GERALD E. ″GERRY″ CONNOLLY 2010Q4 444767.72
HON. DANA ROHRABACHER 2010Q4 443518.79
HON. JOHN SHADEGG 2009Q4 443295.12
HON. EARL BLUMENAUER 2012Q4 442674.75
HON. RODNEY ALEXANDER 2009Q4 442629.08
HON. PATRICK J. MURPHY 2010Q3 442543.46
HON. MARTIN HEINRICH 2010Q3 442502.97
HON. MAXINE WATERS 2010Q3 442209.16
HON. DON YOUNG 2011Q4 442059.78
HON. GARY L. ACKERMAN 2012Q4 441501.89
HON. JOHN KLINE 2010Q2 441482.38
HON. JANICE D. SCHAKOWSKY 2010Q4 441090.38
HON. GARY G. MILLER 2010Q3 440116.92
HON. SCOTT GARRETT 2010Q3 439193.22
HON. ROBERT T. SCHILLING 2011Q4 439162.34
HON. KEITH ELLISON 2010Q2 438943.85
HON. WILLIAM L. OWENS 2010Q2 438825.48
HON. BETTY MCCOLLUM 2009Q4 438754.46
HON. MARTIN HEINRICH 2011Q4 438500.52
HON. JOHN D DINGELL 2009Q4 438361.52
HON. RODNEY ALEXANDER 2011Q4 438315.96
HON. JERRY LEWIS 2011Q4 438165.55
HON. C. A. DUTCH RUPPERSBERGER 2010Q4 438163.55
HON. WILLIAM D. DELAHUNT 2009Q4 438022.2
HON. GEOFF DAVIS 2010Q3 438000.69
HON. TIM HOLDEN 2010Q3 437579.55
HON. LUCILLE ROYBAL-ALLARD 2010Q4 437495.41
HON. JIM MATHESON 2009Q4 437480.69
HON. SOLOMON P ORTIZ 2010Q3 437475.92
HON. CHRISTOPHER P. CARNEY 2010Q3 437402.53
HON. JOHN D. DINGELL 2010Q4 437129.4
HON. ROBERT L. TURNER 2012Q4 436998.2
HON. PEDRO R. PIERLUISI 2014Q4 436942.07
HON. BEN RAY LUJAN 2010Q4 436538.12
HON. BEN RAY LUJAN 2011Q4 436495.32
HON. DINA TITUS 2010Q4 436167.93
HON. WALTER MINNICK 2010Q4 436001.43
HON. STEVEN R. ROTHMAN 2010Q4 435858.44
HON. PAUL A. GOSAR 2012Q2 435843.53
HON. WILLIAM LACY CLAY 2010Q2 435708.39
HON. LEONARD L. BOSWELL 2011Q4 435511.55
HON. EDWARD J. MARKEY 2011Q4 435231.11
HON. MARK S. CRITZ 2010Q3 435193.77
HON. MICHAEL N CASTLE 2009Q4 435103.14
HON. DEBORAH L. HALVORSON 2009Q4 434981.5
HON. MICHAEL M. HONDA 2010Q4 434878.04
HON. STEVE BUYER 2009Q4 434796.53
HON. THOMAS J. ROONEY 2010Q3 434622.54
HON. FORTNEY PETE STARK 2012Q4 434220.48
HON. JERRY MCNERNEY 2010Q3 434033.09
HON. BOB FILNER 2011Q4 433617.85
HON. TRENT FRANKS 2010Q2 433549.72
HON. LARRY KISSELL 2010Q3 433527.25
HON. PHIL GINGREY 2009Q4 433515.43
HON. BARBARA LEE 2010Q4 433505.13
HON. GEORGE MILLER 2010Q4 433457.15
HON. RUSH D. HOLT 2010Q3 433450.12
HON. ALCEE L HASTINGS 2009Q4 433443.2
HON. JOE WILSON 2010Q2 433328.19
HON. RON PAUL 2009Q4 433221.56
HON. TIM RYAN 2011Q4 433030.5