Congress Age: congress-terms.csv

Table actions

This table contains the data behind the story Both Republicans And Democrats Have an Age Problem

congress-terms.csv has an entry for every member of congress who served at any point during a particular congress between January 1947 and Februrary 2014.

House membership data is from the @unitedstates project, with Congress meeting numbers added using code from GovTrack:

  • https://github.com/unitedstates/congress-legislators
  • https://github.com/govtrack/govtrack.us-web/blob/master/us.py#L93

Senate membership data is mostly from the New York Times Congress API combined with birthdays from @unitedstates. (It does not include the birthday of Sen. Elmer Thomas.)

In addition, we added an incumbent field to each record.

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette

18,635 rows

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: chamber, suffix, party, birthday (date), termstart (date)

Link rowid ▼ congress chamber bioguide firstname middlename lastname suffix birthday state party incumbent termstart age
1 1 80 house M000112 Joseph Jefferson Mansfield   1861-02-09 TX D Yes 1947-01-03 85.9
2 2 80 house D000448 Robert Lee Doughton   1863-11-07 NC D Yes 1947-01-03 83.2
3 3 80 house S000001 Adolph Joachim Sabath   1866-04-04 IL D Yes 1947-01-03 80.7
4 4 80 house E000023 Charles Aubrey Eaton   1868-03-29 NJ R Yes 1947-01-03 78.8
5 5 80 house L000296 William   Lewis   1868-09-22 KY R No 1947-01-03 78.3
6 6 80 house G000017 James A. Gallagher   1869-01-16 PA R No 1947-01-03 78.0
7 7 80 house W000265 Richard Joseph Welch   1869-02-13 CA R Yes 1947-01-03 77.9
8 8 80 house B000565 Sol   Bloom   1870-03-09 NY D Yes 1947-01-03 76.8
9 9 80 house H000943 Merlin   Hull   1870-12-18 WI R Yes 1947-01-03 76.0
10 10 80 house G000169 Charles Laceille Gifford   1871-03-15 MA R Yes 1947-01-03 75.8
11 11 80 house B000545 Schuyler Otis Bland   1872-05-04 VA D Yes 1947-01-03 74.7
12 12 80 house R000358 John Marshall Robsion   1873-01-02 KY R Yes 1947-01-03 74.0
13 13 80 house L000501 Louis Leon Ludlow   1873-06-24 IN D Yes 1947-01-03 73.5
14 14 80 house K000138 John Hosea Kerr   1873-12-31 NC D Yes 1947-01-03 73.0
15 15 80 house C000932 Robert   Crosser   1874-06-07 OH D Yes 1947-01-03 72.6
16 16 80 house L000163 Clarence Frederick Lea   1874-07-11 CA D Yes 1947-01-03 72.5
17 17 80 house K000039 John   Kee   1874-08-22 WV D Yes 1947-01-03 72.4
18 18 80 house S000717 Brent   Spence   1874-12-24 KY D Yes 1947-01-03 72.0
19 19 80 house A000257 Homer Daniel Angell   1875-01-12 OR R Yes 1947-01-03 72.0
20 20 80 house N000153 Mary Teresa Norton   1875-03-07 NJ D Yes 1947-01-03 71.8
21 21 80 house P000395 Charles Albert Plumley   1875-04-14 VT R Yes 1947-01-03 71.7
22 22 80 house D000496 Patrick Henry Drewry   1875-05-24 VA D Yes 1947-01-03 71.6
23 23 80 house H000683 Clare Eugene Hoffman   1875-09-10 MI R Yes 1947-01-03 71.3
24 24 80 house R000113 Daniel Alden Reed   1875-09-15 NY R Yes 1947-01-03 71.3
25 25 80 house B001214 William Thomas Byrne   1876-03-06 NY D Yes 1947-01-03 70.8
26 26 80 house W000718 Roy Orchard Woodruff   1876-03-14 MI R Yes 1947-01-03 70.8
27 27 80 house B000515 William Wallace Blackney   1876-08-28 MI R Yes 1947-01-03 70.3
28 28 80 house M000693 Earl Cory Michener   1876-11-30 MI R Yes 1947-01-03 70.1
29 29 80 house C000590 Howard Aldridge Coffin   1877-06-11 MI R No 1947-01-03 69.6
30 30 80 house M000374 Edward Oscar McCowen   1877-06-29 OH R Yes 1947-01-03 69.5
31 31 80 house W000012 James Wolcott Wadsworth Jr. 1877-08-12 NY R Yes 1947-01-03 69.4
32 32 80 house O000016 Thomas Joseph O'Brien   1878-04-30 IL D Yes 1947-01-03 68.7
33 33 80 house W000430 William Madison Whittington   1878-05-04 MS D Yes 1947-01-03 68.7
34 34 80 house L000238 William   Lemke   1878-08-13 ND R Yes 1947-01-03 68.4
35 35 80 house D000212 John Joseph Delaney   1878-08-21 NY D Yes 1947-01-03 68.4
36 36 80 house J000117 Anton Joseph Johnson   1878-10-20 IL R Yes 1947-01-03 68.2
37 37 80 house C000117 Clarence Andrew Cannon   1879-04-11 MO D Yes 1947-01-03 67.7
38 38 80 house T000189 Robert Ewing Thomason   1879-05-30 TX D Yes 1947-01-03 67.6
39 39 80 house A000296 Samuel Washington Arnold   1879-09-21 MO R Yes 1947-01-03 67.3
40 40 80 house B000940 Paul   Brown   1880-03-31 GA D Yes 1947-01-03 66.8
41 41 80 house C000831 Edward Eugene Cox   1880-04-03 GA D Yes 1947-01-03 66.7
42 42 80 house T000001 John   Taber   1880-05-05 NY R Yes 1947-01-03 66.7
43 43 80 house J000096 John   Jennings Jr. 1880-06-06 TN R Yes 1947-01-03 66.6
44 44 80 house G000206 Wilson Darwin Gillette   1880-07-01 PA R Yes 1947-01-03 66.5
45 45 80 house G000360 Louis Edward Graham   1880-08-04 PA R Yes 1947-01-03 66.4
46 46 80 house G000207 George W. Gillie   1880-08-15 IN R Yes 1947-01-03 66.4
47 47 80 house M000574 Rolla Coral McMillen   1880-10-05 IL R Yes 1947-01-03 66.2
48 48 80 house K000301 Harold   Knutson   1880-10-20 MN R Yes 1947-01-03 66.2
49 49 80 house W000683 Charles Anderson Wolverton   1880-10-24 NJ R Yes 1947-01-03 66.2
50 50 80 house J000088 Thomas Albert Jenkins   1880-10-28 OH R Yes 1947-01-03 66.2
51 51 80 house F000241 John Hamlin Folger   1880-12-18 NC D Yes 1947-01-03 66.0
52 52 80 house Z000009 Orville   Zimmerman   1880-12-31 MO D Yes 1947-01-03 66.0
53 53 80 house G000297 Angier Louis Goodwin   1881-01-30 MA R Yes 1947-01-03 65.9
54 54 80 house V000125 Charles Wesley Vursell   1881-02-08 IL R Yes 1947-01-03 65.9
55 55 80 house R000392 Edith Nourse Rogers   1881-03-19 MA R Yes 1947-01-03 65.8
56 56 80 house B001096 Raymond Hugh Burke   1881-11-04 OH R No 1947-01-03 65.2
57 57 80 house R000082 Samuel Taliaferro Rayburn   1882-01-06 TX D Yes 1947-01-03 65.0
58 58 80 house N000135 Fred Barthold Norman   1882-03-21 WA R No 1947-01-03 64.8
59 59 80 house R000056 John Elliott Rankin   1882-03-29 MS D Yes 1947-01-03 64.8
60 60 80 house C000439 Jerome Bayard Clark   1882-04-05 NC D Yes 1947-01-03 64.7
61 61 80 house S000755 Raymond Smiley Springer   1882-04-26 IN R Yes 1947-01-03 64.7
62 62 80 house M000224 Noah Morgan Mason   1882-07-19 IL R Yes 1947-01-03 64.5
63 63 80 house H000356 Franck Roberts Havenner   1882-09-20 CA D Yes 1947-01-03 64.3
64 64 80 house S000554 Howard Worth Smith   1883-02-02 VA D Yes 1947-01-03 63.9
65 65 80 house B001056 Alfred Lee Bulwinkle   1883-04-21 NC D Yes 1947-01-03 63.7
66 66 80 house C000390 Ralph Edwin Church   1883-05-05 IL R Yes 1947-01-03 63.7
67 67 80 house R000209 Robert Fleming Rich   1883-06-23 PA R Yes 1947-01-03 63.5
68 68 80 house K000058 Augustine Bernard Kelley   1883-07-09 PA D Yes 1947-01-03 63.5
69 69 80 house V000105 Carl   Vinson   1883-11-18 GA D Yes 1947-01-03 63.1
70 70 80 house D000411 George Anthony Dondero   1883-12-16 MI R Yes 1947-01-03 63.0
71 71 80 house C000268 E. Wallace Chadwick   1884-01-17 PA R No 1947-01-03 63.0
72 72 80 house S000845 Karl   Stefan   1884-03-01 NE R Yes 1947-01-03 62.8
73 73 80 house G000541 Ralph Waldo Gwinn   1884-03-29 NY R Yes 1947-01-03 62.8
74 74 80 house J000264 Bartel John Jonkman   1884-04-28 MI R Yes 1947-01-03 62.7
75 75 80 house B000750 Willis Winter Bradley   1884-06-28 CA R No 1947-01-03 62.5
76 76 80 house S000536 Frederick Cleveland Smith   1884-07-29 OH R Yes 1947-01-03 62.4
77 77 80 house J000224 Hamilton Chamberlain Jones   1884-09-26 NC D No 1947-01-03 62.3
78 78 80 house M000191 Joseph William Martin Jr. 1884-11-03 MA R Yes 1947-01-03 62.2
79 79 80 house L000251 John   Lesinski   1885-01-03 MI D Yes 1947-01-03 62.0
80 80 80 house S000335 Harry Richard Sheppard   1885-01-10 CA D Yes 1947-01-03 62.0
81 81 80 house B000332 Charles Jasper Bell   1885-01-16 MO D Yes 1947-01-03 62.0
82 82 80 house A000227 James Coats Auchincloss   1885-01-19 NJ R Yes 1947-01-03 62.0
83 83 80 house W000699 John Stephens Wood   1885-02-08 GA D Yes 1947-01-03 61.9
84 84 80 house F000191 John William Flannagan Jr. 1885-02-20 VA D Yes 1947-01-03 61.9
85 85 80 house B000725 Frank William Boykin   1885-02-21 AL D Yes 1947-01-03 61.9
86 86 80 house B000607 Frances Payne Bolton   1885-03-29 OH R Yes 1947-01-03 61.8
87 87 80 house M001081 John Robert Murdock   1885-04-20 AZ D Yes 1947-01-03 61.7
88 88 80 house G000031 Ralph Abernethy Gamble   1885-05-06 NY R Yes 1947-01-03 61.7
89 89 80 house T000263 Harve   Tibbott   1885-05-27 PA R Yes 1947-01-03 61.6
90 90 80 house C000515 Cliff   Clevenger   1885-08-20 OH R Yes 1947-01-03 61.4
91 91 80 house S000029 John Carfield Sanborn   1885-09-28 ID R No 1947-01-03 61.3
92 92 80 house C000529 Roy   Clippinger   1886-01-13 IL R Yes 1947-01-03 61.0
93 93 80 house H000613 William Silas Hill   1886-01-20 CO R Yes 1947-01-03 61.0
94 94 80 house R000369 Robert Fay Rockwell   1886-02-11 CO R Yes 1947-01-03 60.9
95 95 80 house D000158 William Levi Dawson   1886-04-26 IL D Yes 1947-01-03 60.7
96 96 80 house R000132 Edward Herbert Rees   1886-06-03 KS R Yes 1947-01-03 60.6
97 97 80 house S000155 George Blaine Schwabe   1886-07-26 OK R Yes 1947-01-03 60.4
98 98 80 house R000391 Dwight Laing Rogers   1886-08-17 FL D Yes 1947-01-03 60.4
99 99 80 house M000680 Herbert Alton Meyer   1886-08-30 KS R No 1947-01-03 60.3
100 100 80 house G000332 Martin   Gorski   1886-10-30 IL D Yes 1947-01-03 60.2

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "congress-age/congress-terms" (
"congress" INTEGER,
  "chamber" TEXT,
  "bioguide" TEXT,
  "firstname" TEXT,
  "middlename" TEXT,
  "lastname" TEXT,
  "suffix" TEXT,
  "birthday" TEXT,
  "state" TEXT,
  "party" TEXT,
  "incumbent" TEXT,
  "termstart" TEXT,
  "age" REAL
);