Query: Age of members of congress by hmz

Loading chart...

1select 
2  congress,
3  datepart('year', termstart) as year,
4  party,
5  ROUND(median(age), 1) as "median age", 
6  ROUND(mean(age), 1) as "mean age"
7from @fivethirtyeight.congress_age.congress_terms
8where year >= 1980 and party = 'R'
9group by congress, year, party
10order by year

congress	year	party	median age	mean age
97	1981	R	49	48.3
98	1983	R	50.4	49.7
99	1985	R	51.7	50.5
100	1987	R	51.9	51.3
101	1989	R	52.9	52.5
102	1991	R	54.7	54
103	1993	R	52.8	53
104	1995	R	51.6	51.8
105	1997	R	51.6	52.3
106	1999	R	53.1	54
107	2001	R	53.6	54.2
108	2003	R	54.3	54.7
109	2005	R	55.3	55.8
110	2007	R	56.3	56.9
111	2009	R	56.6	56.9
112	2011	R	55.4	55.3
113	2013	R	56.1	55.8