Trump's World

Help us map Trump's World

@kaggle.skylord_trumpworld

Table List

1 table(466.92 KB)

Approval Polllist

@kaggle.skylord_trumpworld.approval_polllist

466.92 KB
11579 rows
22 columns

president President	subgroup Subgroup	modeldate Modeldate	startdate Startdate	enddate Enddate	pollster Pollster	grade Grade	samplesize Samplesize	population Population	weight Weight	approve Approve	disapprove Disapprove	adjusted_approve Adjusted Approve	adjusted_disapprove Adjusted Disapprove	multiversions Multiversions	tracking Tracking	url Url	poll_id Poll Id	question_id Question Id	createddate Createddate	timestamp Timestamp
Donald Trump	All polls	Sat Apr 11 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jan 20 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Jan 22 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Gallup	B	1500	a	0.24168201	45	45	45.706924	43.640752	nan	T	http://www.gallup.com/poll/201617/gallup-daily-trump-job-approval.aspx	49253	77265	Mon Jan 23 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	07:55:31 11 Apr 2020
Donald Trump	All polls	Sat Apr 11 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jan 20 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Jan 22 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Morning Consult	B/C	1992	rv	0.69698373	46	37	44.815258	38.230932	nan	nan	http://static.politico.com/9b/13/82a3baf542ae9018e5b6e1008379/170103-topline-politico-v3-kd.pdf	49249	77261	Mon Jan 23 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	07:55:31 11 Apr 2020
Donald Trump	All polls	Sat Apr 11 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Jan 21 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jan 23 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Gallup	B	1500	a	0.22323372	45	46	45.706924	44.640752	nan	T	http://www.gallup.com/poll/201617/gallup-daily-trump-job-approval.aspx	49262	77274	Tue Jan 24 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	07:55:31 11 Apr 2020
Donald Trump	All polls	Sat Apr 11 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jan 20 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Jan 24 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Ipsos	B-	1632	a	0.15078547	42.1	45.2	42.960763	43.990648	nan	T	http://polling.reuters.com/#poll/CP3_2/	49426	77599	Wed Mar 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	07:55:31 11 Apr 2020
Donald Trump	All polls	Sat Apr 11 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jan 20 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jan 25 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Quinnipiac University	B+	1190	rv	1.4944941	36	44	37.587023	42.844535	nan	nan	https://poll.qu.edu/national/release-detail?ReleaseID=2415	49260	77272	Thu Jan 26 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	07:55:31 11 Apr 2020
Donald Trump	All polls	Sat Apr 11 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Jan 21 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jan 25 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Ipsos	B-	1651	a	0.13896677	42.3	45.8	43.160763	44.590648	nan	T	http://polling.reuters.com/#poll/CP3_2/	49425	77598	Wed Mar 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	07:55:31 11 Apr 2020
Donald Trump	All polls	Sat Apr 11 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Jan 22 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Jan 24 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Gallup	B	1500	a	0.20865899	46	45	46.706924	43.640752	nan	T	http://www.gallup.com/poll/201617/gallup-daily-trump-job-approval.aspx	49236	77248	Wed Jan 25 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	07:55:31 11 Apr 2020
Donald Trump	All polls	Sat Apr 11 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Jan 22 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Jan 24 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Rasmussen Reports/Pulse Opinion Research	C+	1500	lv	0.20033478	57	43	51.337958	44.524754	nan	T	http://www.rasmussenreports.com/public_content/politics/trump_administration/trump_approval_index_history	49266	77278	Wed Jan 25 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	07:55:31 11 Apr 2020
Donald Trump	All polls	Sat Apr 11 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jan 23 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jan 25 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Rasmussen Reports/Pulse Opinion Research	C+	1500	lv	0.18577234	59	41	53.337958	42.524754	nan	T	http://www.rasmussenreports.com/public_content/politics/trump_administration/trump_approval_index_history	49247	77259	Thu Jan 26 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	07:55:31 11 Apr 2020
Donald Trump	All polls	Sat Apr 11 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Jan 22 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jan 26 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Ipsos	B-	1678	a	0.1304198	42.6	46.4	43.460763	45.190648	nan	T	http://polling.reuters.com/#poll/CP3_2/	49424	77597	Wed Mar 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	07:55:31 11 Apr 2020


CREATE TABLE approval_polllist (
  "president" VARCHAR,
  "subgroup" VARCHAR,
  "modeldate" TIMESTAMP,
  "startdate" TIMESTAMP,
  "enddate" TIMESTAMP,
  "pollster" VARCHAR,
  "grade" VARCHAR,
  "samplesize" DOUBLE,
  "population" VARCHAR,
  "weight" DOUBLE,
  "influence" DOUBLE,
  "approve" DOUBLE,
  "disapprove" DOUBLE,
  "adjusted_approve" DOUBLE,
  "adjusted_disapprove" DOUBLE,
  "multiversions" VARCHAR,
  "tracking" VARCHAR,
  "url" VARCHAR,
  "poll_id" BIGINT,
  "question_id" BIGINT,
  "createddate" TIMESTAMP,
  "timestamp" VARCHAR
);