Midterms American

How does the president's party perform in midterm elections?

@kaggle.willianoliveiragibin_midterms_american

Table List

1 table(6.02 KB)

Midterms Up Midterms

@kaggle.willianoliveiragibin_midterms_american.midterms_up_midterms

6.02 KB
30 rows
6 columns

year Year	potus Potus	party Party	unemployment Unemployment	house_change House.change	unnamed_5 Unnamed: 5
1899	Barack Obama	Democrate	38	-2.659	38Barack Obama
1903	Barack Obama	Democrate	39	-2.423	39Barack Obama
1907	Bill Clinton	Democratic	43	-2.231	43Bill Clinton
1911	Bill Clinton	Democratic	45	-2.156	45Bill Clinton
1915	Calvin Coolidge	Democratic	46	-2.096	46Calvin Coolidge
1919	Calvin Coolidge	Democratic	47	-2.093	47Calvin Coolidge
1923	Dwight David Eisenhower	Democratic	49	-1.926	49Dwight David Eisenhower
1927	Dwight David Eisenhower	Democratic	53	-1.685	53Dwight David Eisenhower
1931	Franklin Delano Roosevelt	Democratic	55	-1.627	55Franklin Delano Roosevelt
1935	Franklin Delano Roosevelt	Democratic	55	-1.354	55Franklin Delano Roosevelt


CREATE TABLE midterms_up_midterms (
  "year" BIGINT,
  "potus" VARCHAR,
  "party" VARCHAR,
  "unemployment" DOUBLE,
  "house_change" DOUBLE,
  "unnamed_5" VARCHAR
);