Python Data Visualization Essentials Guide

year Year	state State	state_po State Po	state_fips State Fips	state_cen State Cen	state_ic State Ic	office Office	candidate Candidate	party_detailed Party Detailed	writein Writein	candidatevotes Candidatevotes	totalvotes Totalvotes	version Version	party_simplified Party Simplified
1976	ALABAMA	AL	1	63	41	US PRESIDENT	CARTER, JIMMY	DEMOCRAT	False	659170	1182850	20210113	DEMOCRAT
1976	ALABAMA	AL	1	63	41	US PRESIDENT	FORD, GERALD	REPUBLICAN	False	504070	1182850	20210113	REPUBLICAN
1976	ALABAMA	AL	1	63	41	US PRESIDENT	MADDOX, LESTER	AMERICAN INDEPENDENT PARTY	False	9198	1182850	20210113	OTHER
1976	ALABAMA	AL	1	63	41	US PRESIDENT	BUBAR, BENJAMIN ""BEN""	PROHIBITION	False	6669	1182850	20210113	OTHER
1976	ALABAMA	AL	1	63	41	US PRESIDENT	HALL, GUS	COMMUNIST PARTY USE	False	1954	1182850	20210113	OTHER
1976	ALABAMA	AL	1	63	41	US PRESIDENT	MACBRIDE, ROGER	LIBERTARIAN	False	1481	1182850	20210113	LIBERTARIAN
1976	ALABAMA	AL	1	63	41	US PRESIDENT	nan	nan	True	308	1182850	20210113	OTHER
1976	ALASKA	AK	2	94	81	US PRESIDENT	FORD, GERALD	REPUBLICAN	False	71555	123574	20210113	REPUBLICAN
1976	ALASKA	AK	2	94	81	US PRESIDENT	CARTER, JIMMY	DEMOCRAT	False	44058	123574	20210113	DEMOCRAT
1976	ALASKA	AK	2	94	81	US PRESIDENT	MACBRIDE, ROGER	LIBERTARIAN	False	6785	123574	20210113	LIBERTARIAN


CREATE TABLE n_1976_2020_president (
  "year" BIGINT,
  "state" VARCHAR,
  "state_po" VARCHAR,
  "state_fips" BIGINT,
  "state_cen" BIGINT,
  "state_ic" BIGINT,
  "office" VARCHAR,
  "candidate" VARCHAR,
  "party_detailed" VARCHAR,
  "writein" VARCHAR,
  "candidatevotes" BIGINT,
  "totalvotes" BIGINT,
  "version" BIGINT,
  "notes" VARCHAR,
  "party_simplified" VARCHAR
);