congress-age/congress-terms

18,635 rows sorted by middlename

View and edit SQL

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

Link rowid congress chamber bioguide firstname middlename ▼ lastname suffix birthday state party incumbent termstart age
5 80 house L000296 William   Lewis   1868-09-22 KY R No 1947-01-03 78.3
8 80 house B000565 Sol   Bloom   1870-03-09 NY D Yes 1947-01-03 76.8
9 80 house H000943 Merlin   Hull   1870-12-18 WI R Yes 1947-01-03 76.0
15 80 house C000932 Robert   Crosser   1874-06-07 OH D Yes 1947-01-03 72.6
17 80 house K000039 John   Kee   1874-08-22 WV D Yes 1947-01-03 72.4
18 80 house S000717 Brent   Spence   1874-12-24 KY D Yes 1947-01-03 72.0
34 80 house L000238 William   Lemke   1878-08-13 ND R Yes 1947-01-03 68.4
40 80 house B000940 Paul   Brown   1880-03-31 GA D Yes 1947-01-03 66.8
42 80 house T000001 John   Taber   1880-05-05 NY R Yes 1947-01-03 66.7
43 80 house J000096 John   Jennings Jr. 1880-06-06 TN R Yes 1947-01-03 66.6
48 80 house K000301 Harold   Knutson   1880-10-20 MN R Yes 1947-01-03 66.2
52 80 house Z000009 Orville   Zimmerman   1880-12-31 MO D Yes 1947-01-03 66.0
69 80 house V000105 Carl   Vinson   1883-11-18 GA D Yes 1947-01-03 63.1
72 80 house S000845 Karl   Stefan   1884-03-01 NE R Yes 1947-01-03 62.8
79 80 house L000251 John   Lesinski   1885-01-03 MI D Yes 1947-01-03 62.0
89 80 house T000263 Harve   Tibbott   1885-05-27 PA R Yes 1947-01-03 61.6
90 80 house C000515 Cliff   Clevenger   1885-08-20 OH R Yes 1947-01-03 61.4
92 80 house C000529 Roy   Clippinger   1886-01-13 IL R Yes 1947-01-03 61.0
100 80 house G000332 Martin   Gorski   1886-10-30 IL D Yes 1947-01-03 60.2
108 80 house P000309 John   Phillips   1887-09-11 CA R Yes 1947-01-03 59.3
117 80 house C000264 Emanuel   Celler   1888-05-06 NY D Yes 1947-01-03 58.7
133 80 house F000066 Frank   Fellows   1889-11-07 ME R Yes 1947-01-03 57.2
135 80 house H000036 Robert   Hale   1889-11-29 ME R Yes 1947-01-03 57.1
151 80 house P000002 Stephen   Pace   1891-03-09 GA D Yes 1947-01-03 55.8
169 80 house R000288 Ross   Rizley   1892-07-05 OK R Yes 1947-01-03 54.5
173 80 house S000640 Wint   Smith   1892-10-07 KS R No 1947-01-03 54.2
189 80 house C000755 Jere   Cooper   1893-07-20 TN D Yes 1947-01-03 53.5
192 80 house L000161 Jay   Le Fevre   1893-09-06 NY R Yes 1947-01-03 53.3
232 80 house J000086 Mitchell   Jenkins   1896-01-24 PA R No 1947-01-03 50.9
249 80 house D000094 Clifford   Davis   1897-11-18 TN D Yes 1947-01-03 49.1
252 80 house B000884 Overton   Brooks   1897-12-21 LA D Yes 1947-01-03 49.0
260 80 house T000156 Albert   Thomas   1898-04-12 TX D Yes 1947-01-03 48.7
261 80 house C000113 Gordon   Canfield   1898-04-15 NJ R Yes 1947-01-03 48.7
277 80 house M000991 Toby   Morris   1899-02-28 OK D No 1947-01-03 47.8
307 80 house S000936 Lowell   Stockman   1901-04-12 OR R Yes 1947-01-03 45.7
312 80 house H000310 Ralph   Harvey   1901-08-09 IN R No 1947-01-03 45.4
321 80 house M000094 Carter   Manasco   1902-01-03 AL D Yes 1947-01-03 45.0
334 80 house B001002 Frank   Buchanan   1902-12-01 PA D Yes 1947-01-03 44.1
342 80 house H000197 Porter   Hardy Jr. 1903-06-01 VA D No 1947-01-03 43.6
346 80 house D000007 Thomas   D'Alesandro Jr. 1903-08-01 MD D Yes 1947-01-03 43.4
355 80 house H000249 Oren   Harris   1903-12-20 AR D Yes 1947-01-03 43.0
376 80 house S000156 Max   Schwabe   1905-12-06 MO R Yes 1947-01-03 41.1
379 80 house W000572 Earl   Wilson   1906-04-18 IN R Yes 1947-01-03 40.7
387 80 house D000406 James   Domengeaux   1907-01-06 LA D Yes 1947-01-03 40.0
390 80 house S000172 Hardie   Scott   1907-06-07 PA R No 1947-01-03 39.6
400 80 house S000224 Horace   Seely-Brown Jr. 1908-05-12 CT R No 1947-01-03 38.6
420 80 house I000046 Leo   Isacson   1910-04-20 NY AL No 1947-01-03 36.7
427 80 house E000181 Clair   Engle   1911-09-21 CA D Yes 1947-01-03 35.3
445 80 house M000560 Gregory   McMahon   1915-03-19 NY R No 1947-01-03 31.8
454 80 senate C000133 Arthur   Capper   1865-07-14 KS R Yes 1947-01-03 81.5
462 80 senate T000165 Elmer   Thomas   1876-09-08 OK D Yes 1947-01-03 70.3
473 80 senate M000177 Edward   Martin   1879-09-18 PA R No 1947-01-03 67.3
481 80 senate D000469 Sheridan   Downey   1884-03-11 CA D Yes 1947-01-03 62.8
484 80 senate W000465 Alexander   Wiley   1884-05-26 WI R Yes 1947-01-03 62.6
487 80 senate L000070 William   Langer   1886-09-30 ND R Yes 1947-01-03 60.3
492 80 senate C000338 Dennis   Chavez   1888-04-08 NM D Yes 1947-01-03 58.7
502 80 senate C000774 Guy   Cordon   1890-04-24 OR R Yes 1947-01-03 56.7
511 80 senate S000021 Leverett   Saltonstall   1892-09-01 MA R Yes 1947-01-03 54.3
543 80 senate M000559 Brien   McMahon   1903-10-06 CT D Yes 1947-01-03 43.2
560 81 house B000565 Sol   Bloom   1870-03-09 NY D Yes 1949-01-03 78.8
561 81 house H000943 Merlin   Hull   1870-12-18 WI R Yes 1949-01-03 78.0
564 81 house C000932 Robert   Crosser   1874-06-07 OH D Yes 1949-01-03 74.6
565 81 house K000039 John   Kee   1874-08-22 WV D Yes 1949-01-03 74.4
566 81 house S000717 Brent   Spence   1874-12-24 KY D Yes 1949-01-03 74.0
581 81 house L000238 William   Lemke   1878-08-13 ND R Yes 1949-01-03 70.4
584 81 house B000940 Paul   Brown   1880-03-31 GA D Yes 1949-01-03 68.8
586 81 house T000001 John   Taber   1880-05-05 NY R Yes 1949-01-03 68.7
587 81 house J000096 John   Jennings Jr. 1880-06-06 TN R Yes 1949-01-03 68.6
598 81 house O000053 Barratt   O'Hara   1882-04-28 IL D No 1949-01-03 66.7
607 81 house V000105 Carl   Vinson   1883-11-18 GA D Yes 1949-01-03 65.1
609 81 house S000845 Karl   Stefan   1884-03-01 NE R Yes 1949-01-03 64.8
615 81 house L000251 John   Lesinski   1885-01-03 MI D Yes 1949-01-03 64.0
625 81 house C000515 Cliff   Clevenger   1885-08-20 OH R Yes 1949-01-03 63.4
634 81 house G000332 Martin   Gorski   1886-10-30 IL D Yes 1949-01-03 62.2
640 81 house P000309 John   Phillips   1887-09-11 CA R Yes 1949-01-03 61.3
648 81 house C000264 Emanuel   Celler   1888-05-06 NY D Yes 1949-01-03 60.7
661 81 house F000066 Frank   Fellows   1889-11-07 ME R Yes 1949-01-03 59.2
663 81 house H000036 Robert   Hale   1889-11-29 ME R Yes 1949-01-03 59.1
675 81 house M000606 John   McSweeney   1890-12-19 OH D No 1949-01-03 58.0
679 81 house P000002 Stephen   Pace   1891-03-09 GA D Yes 1949-01-03 57.8
700 81 house S000640 Wint   Smith   1892-10-07 KS R Yes 1949-01-03 56.2
713 81 house C000755 Jere   Cooper   1893-07-20 TN D Yes 1949-01-03 55.5
715 81 house L000161 Jay   Le Fevre   1893-09-06 NY R Yes 1949-01-03 55.3
764 81 house C000259 Anthony   Cavalcante   1897-02-06 PA D No 1949-01-03 51.9
771 81 house D000094 Clifford   Davis   1897-11-18 TN D Yes 1949-01-03 51.1
772 81 house B000884 Overton   Brooks   1897-12-21 LA D Yes 1949-01-03 51.0
780 81 house T000156 Albert   Thomas   1898-04-12 TX D Yes 1949-01-03 50.7
781 81 house C000113 Gordon   Canfield   1898-04-15 NJ R Yes 1949-01-03 50.7
795 81 house M000991 Toby   Morris   1899-02-28 OK D Yes 1949-01-03 49.8
796 81 house M000045 Clare   Magee   1899-03-31 MO D No 1949-01-03 49.8
798 81 house D000198 Edward   deGraffenried   1899-06-30 AL D No 1949-01-03 49.5
829 81 house S000936 Lowell   Stockman   1901-04-12 OR R Yes 1949-01-03 47.7
835 81 house H000310 Ralph   Harvey   1901-08-09 IN R Yes 1949-01-03 47.4
854 81 house B001002 Frank   Buchanan   1902-12-01 PA D Yes 1949-01-03 46.1
863 81 house H000197 Porter   Hardy Jr. 1903-06-01 VA D Yes 1949-01-03 45.6
867 81 house D000402 Isidore   Dollinger   1903-11-13 NY D No 1949-01-03 45.1
872 81 house H000249 Oren   Harris   1903-12-20 AR D Yes 1949-01-03 45.0
902 81 house J000034 Andrew   Jacobs   1906-02-22 IN D No 1949-01-03 42.9
904 81 house M000152 Fred   Marshall   1906-03-13 MN D No 1949-01-03 42.8
907 81 house W000572 Earl   Wilson   1906-04-18 IN R Yes 1949-01-03 42.7

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" REAL,
  "birthday" TEXT,
  "state" TEXT,
  "party" TEXT,
  "incumbent" TEXT,
  "termstart" TEXT,
  "age" REAL
);
Powered by Datasette · Query took 986.443ms