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 Party	writein Writein	candidatevotes Candidatevotes	totalvotes Totalvotes	version Version
1976	Alabama	AL	1	63	41	US President	Carter, Jimmy	democrat		659170	1182850	20171015
1976	Alabama	AL	1	63	41	US President	Ford, Gerald	republican		504070	1182850	20171015
1976	Alabama	AL	1	63	41	US President	Maddox, Lester	american independent party		9198	1182850	20171015
1976	Alabama	AL	1	63	41	US President	Bubar, Benjamin ""Ben""	prohibition		6669	1182850	20171015
1976	Alabama	AL	1	63	41	US President	Hall, Gus	communist party use		1954	1182850	20171015
1976	Alabama	AL	1	63	41	US President	Macbride, Roger	libertarian		1481	1182850	20171015
1976	Alabama	AL	1	63	41	US President	nan	nan	true	308	1182850	20171015
1976	Alaska	AK	2	94	81	US President	Ford, Gerald	republican		71555	123574	20171015
1976	Alaska	AK	2	94	81	US President	Carter, Jimmy	democrat		44058	123574	20171015
1976	Alaska	AK	2	94	81	US President	Macbride, Roger	libertarian		6785	123574	20171015


CREATE TABLE n_19762016usprez (
  "year" BIGINT,
  "state" VARCHAR,
  "state_po" VARCHAR,
  "state_fips" BIGINT,
  "state_cen" BIGINT,
  "state_ic" BIGINT,
  "office" VARCHAR,
  "candidate" VARCHAR,
  "party" VARCHAR,
  "writein" BOOLEAN,
  "candidatevotes" BIGINT,
  "totalvotes" BIGINT,
  "version" BIGINT,
  "notes" VARCHAR
);