Congress Demographics

Demographics of the U.S. Congress Members

@fivethirtyeight.congress_demographics

Table List

1 table(527.01 KB)

Demographic Data On Members Of Congress

@fivethirtyeight.congress_demographics.data_aging_congress

527.01 KB
29120 rows
13 columns

congress Congress	start_date Start Date	chamber Chamber	state_abbrev State Abbrev	party_code Party Code	bioname Bioname	bioguide_id Bioguide Id	birthday Birthday	cmltv_cong Cmltv Cong	cmltv_chamber Cmltv Chamber	age_days Age Days	age_years Age Years	generation Generation
82	Wed Jan 03 1951 00:00:00 GMT+0000 (Coordinated Universal Time)	House	ND	200	AANDAHL, Fred George	A000001	Fri Apr 09 1897 00:00:00 GMT+0000 (Coordinated Universal Time)	1	1	19626	53.7330595482546	Lost
80	Fri Jan 03 1947 00:00:00 GMT+0000 (Coordinated Universal Time)	House	VA	100	ABBITT, Watkins Moorman	A000002	Thu May 21 1908 00:00:00 GMT+0000 (Coordinated Universal Time)	1	1	14106	38.6201232032854	Greatest
81	Mon Jan 03 1949 00:00:00 GMT+0000 (Coordinated Universal Time)	House	VA	100	ABBITT, Watkins Moorman	A000002	Thu May 21 1908 00:00:00 GMT+0000 (Coordinated Universal Time)	2	2	14837	40.621492128679	Greatest
82	Wed Jan 03 1951 00:00:00 GMT+0000 (Coordinated Universal Time)	House	VA	100	ABBITT, Watkins Moorman	A000002	Thu May 21 1908 00:00:00 GMT+0000 (Coordinated Universal Time)	3	3	15567	42.6201232032854	Greatest
83	Sat Jan 03 1953 00:00:00 GMT+0000 (Coordinated Universal Time)	House	VA	100	ABBITT, Watkins Moorman	A000002	Thu May 21 1908 00:00:00 GMT+0000 (Coordinated Universal Time)	4	4	16298	44.621492128679	Greatest
84	Mon Jan 03 1955 00:00:00 GMT+0000 (Coordinated Universal Time)	House	VA	100	ABBITT, Watkins Moorman	A000002	Thu May 21 1908 00:00:00 GMT+0000 (Coordinated Universal Time)	5	5	17028	46.6201232032854	Greatest
85	Thu Jan 03 1957 00:00:00 GMT+0000 (Coordinated Universal Time)	House	VA	100	ABBITT, Watkins Moorman	A000002	Thu May 21 1908 00:00:00 GMT+0000 (Coordinated Universal Time)	6	6	17759	48.621492128679	Greatest
86	Sat Jan 03 1959 00:00:00 GMT+0000 (Coordinated Universal Time)	House	VA	100	ABBITT, Watkins Moorman	A000002	Thu May 21 1908 00:00:00 GMT+0000 (Coordinated Universal Time)	7	7	18489	50.6201232032854	Greatest
87	Tue Jan 03 1961 00:00:00 GMT+0000 (Coordinated Universal Time)	House	VA	100	ABBITT, Watkins Moorman	A000002	Thu May 21 1908 00:00:00 GMT+0000 (Coordinated Universal Time)	8	8	19220	52.621492128679	Greatest
88	Thu Jan 03 1963 00:00:00 GMT+0000 (Coordinated Universal Time)	House	VA	100	ABBITT, Watkins Moorman	A000002	Thu May 21 1908 00:00:00 GMT+0000 (Coordinated Universal Time)	9	9	19950	54.6201232032854	Greatest


CREATE TABLE data_aging_congress (
  "congress" BIGINT,
  "start_date" TIMESTAMP,
  "chamber" VARCHAR,
  "state_abbrev" VARCHAR,
  "party_code" BIGINT,
  "bioname" VARCHAR,
  "bioguide_id" VARCHAR,
  "birthday" TIMESTAMP,
  "cmltv_cong" BIGINT,
  "cmltv_chamber" BIGINT,
  "age_days" BIGINT,
  "age_years" DOUBLE,
  "generation" VARCHAR
);