senate_polls

Table actions

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette

20 rows where url = "https://twitter.com/Crimsontider/status/1242936586565713922"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: question_id, poll_id, start_date, end_date, answer, candidate_id, candidate_name, candidate_party

Link rowid ▼ question_id poll_id cycle state pollster_id pollster sponsor_ids sponsors display_name pollster_rating_id pollster_rating_name fte_grade sample_size population population_full methodology office_type seat_number seat_name start_date end_date election_date sponsor_candidate internal partisan tracking nationwide_batch ranked_choice_reallocated created_at notes url stage race_id answer candidate_id candidate_name candidate_party pct
2329 2329 120532 64997 2020 Georgia 1549 Battleground Connect     Battleground Connect 563 Battleground Connect   1025 lv lv IVR U.S. Senate 2 Class III 3/24/20 3/24/20 11/3/20 Doug Collins 1 REP   0 0 3/26/20 18:08   https://twitter.com/Crimsontider/status/1242936586565713922 jungle primary 7780 Lieberman 13670 Matthew Lieberman DEM 18.4
2330 2330 120532 64997 2020 Georgia 1549 Battleground Connect     Battleground Connect 563 Battleground Connect   1025 lv lv IVR U.S. Senate 2 Class III 3/24/20 3/24/20 11/3/20 Doug Collins 1 REP   0 0 3/26/20 18:08   https://twitter.com/Crimsontider/status/1242936586565713922 jungle primary 7780 Collins 13669 Doug Collins REP 34.1
2331 2331 120532 64997 2020 Georgia 1549 Battleground Connect     Battleground Connect 563 Battleground Connect   1025 lv lv IVR U.S. Senate 2 Class III 3/24/20 3/24/20 11/3/20 Doug Collins 1 REP   0 0 3/26/20 18:08   https://twitter.com/Crimsontider/status/1242936586565713922 jungle primary 7780 Loeffler 13671 Kelly Loeffler REP 13.6
2332 2332 120532 64997 2020 Georgia 1549 Battleground Connect     Battleground Connect 563 Battleground Connect   1025 lv lv IVR U.S. Senate 2 Class III 3/24/20 3/24/20 11/3/20 Doug Collins 1 REP   0 0 3/26/20 18:08   https://twitter.com/Crimsontider/status/1242936586565713922 jungle primary 7780 Tarver 14490 Ed Tarver DEM 5.4
2333 2333 120532 64997 2020 Georgia 1549 Battleground Connect     Battleground Connect 563 Battleground Connect   1025 lv lv IVR U.S. Senate 2 Class III 3/24/20 3/24/20 11/3/20 Doug Collins 1 REP   0 0 3/26/20 18:08   https://twitter.com/Crimsontider/status/1242936586565713922 jungle primary 7780 Warnock 14489 Raphael Warnock DEM 13.3
2334 2334 120531 64996 2020 Georgia 1549 Battleground Connect     Battleground Connect 563 Battleground Connect   1025 lv lv IVR U.S. Senate 2 Class III 3/21/20 3/21/20 11/3/20 Doug Collins 1 REP   0 0 3/26/20 18:08   https://twitter.com/Crimsontider/status/1242936586565713922 jungle primary 7780 Lieberman 13670 Matthew Lieberman DEM 18.9
2335 2335 120531 64996 2020 Georgia 1549 Battleground Connect     Battleground Connect 563 Battleground Connect   1025 lv lv IVR U.S. Senate 2 Class III 3/21/20 3/21/20 11/3/20 Doug Collins 1 REP   0 0 3/26/20 18:08   https://twitter.com/Crimsontider/status/1242936586565713922 jungle primary 7780 Collins 13669 Doug Collins REP 31.8
2336 2336 120531 64996 2020 Georgia 1549 Battleground Connect     Battleground Connect 563 Battleground Connect   1025 lv lv IVR U.S. Senate 2 Class III 3/21/20 3/21/20 11/3/20 Doug Collins 1 REP   0 0 3/26/20 18:08   https://twitter.com/Crimsontider/status/1242936586565713922 jungle primary 7780 Loeffler 13671 Kelly Loeffler REP 14.6
2337 2337 120531 64996 2020 Georgia 1549 Battleground Connect     Battleground Connect 563 Battleground Connect   1025 lv lv IVR U.S. Senate 2 Class III 3/21/20 3/21/20 11/3/20 Doug Collins 1 REP   0 0 3/26/20 18:08   https://twitter.com/Crimsontider/status/1242936586565713922 jungle primary 7780 Tarver 14490 Ed Tarver DEM 4.7
2338 2338 120531 64996 2020 Georgia 1549 Battleground Connect     Battleground Connect 563 Battleground Connect   1025 lv lv IVR U.S. Senate 2 Class III 3/21/20 3/21/20 11/3/20 Doug Collins 1 REP   0 0 3/26/20 18:08   https://twitter.com/Crimsontider/status/1242936586565713922 jungle primary 7780 Warnock 14489 Raphael Warnock DEM 11.9
2349 2349 120530 64995 2020 Georgia 1549 Battleground Connect     Battleground Connect 563 Battleground Connect   1025 lv lv IVR U.S. Senate 2 Class III 3/12/20 3/12/20 11/3/20 Doug Collins 1 REP   0 0 3/26/20 18:08   https://twitter.com/Crimsontider/status/1242936586565713922 jungle primary 7780 Lieberman 13670 Matthew Lieberman DEM 18.2
2350 2350 120530 64995 2020 Georgia 1549 Battleground Connect     Battleground Connect 563 Battleground Connect   1025 lv lv IVR U.S. Senate 2 Class III 3/12/20 3/12/20 11/3/20 Doug Collins 1 REP   0 0 3/26/20 18:08   https://twitter.com/Crimsontider/status/1242936586565713922 jungle primary 7780 Collins 13669 Doug Collins REP 29.7
2351 2351 120530 64995 2020 Georgia 1549 Battleground Connect     Battleground Connect 563 Battleground Connect   1025 lv lv IVR U.S. Senate 2 Class III 3/12/20 3/12/20 11/3/20 Doug Collins 1 REP   0 0 3/26/20 18:08   https://twitter.com/Crimsontider/status/1242936586565713922 jungle primary 7780 Loeffler 13671 Kelly Loeffler REP 19.2
2352 2352 120530 64995 2020 Georgia 1549 Battleground Connect     Battleground Connect 563 Battleground Connect   1025 lv lv IVR U.S. Senate 2 Class III 3/12/20 3/12/20 11/3/20 Doug Collins 1 REP   0 0 3/26/20 18:08   https://twitter.com/Crimsontider/status/1242936586565713922 jungle primary 7780 Tarver 14490 Ed Tarver DEM 4.8
2353 2353 120530 64995 2020 Georgia 1549 Battleground Connect     Battleground Connect 563 Battleground Connect   1025 lv lv IVR U.S. Senate 2 Class III 3/12/20 3/12/20 11/3/20 Doug Collins 1 REP   0 0 3/26/20 18:08   https://twitter.com/Crimsontider/status/1242936586565713922 jungle primary 7780 Warnock 14489 Raphael Warnock DEM 10.2
2364 2364 120529 64994 2020 Georgia 1549 Battleground Connect     Battleground Connect 563 Battleground Connect   1025 lv lv IVR U.S. Senate 2 Class III 3/7/20 3/7/20 11/3/20 Doug Collins 1 REP   0 0 3/26/20 18:08   https://twitter.com/Crimsontider/status/1242936586565713922 jungle primary 7780 Lieberman 13670 Matthew Lieberman DEM 16.4
2365 2365 120529 64994 2020 Georgia 1549 Battleground Connect     Battleground Connect 563 Battleground Connect   1025 lv lv IVR U.S. Senate 2 Class III 3/7/20 3/7/20 11/3/20 Doug Collins 1 REP   0 0 3/26/20 18:08   https://twitter.com/Crimsontider/status/1242936586565713922 jungle primary 7780 Collins 13669 Doug Collins REP 29.1
2366 2366 120529 64994 2020 Georgia 1549 Battleground Connect     Battleground Connect 563 Battleground Connect   1025 lv lv IVR U.S. Senate 2 Class III 3/7/20 3/7/20 11/3/20 Doug Collins 1 REP   0 0 3/26/20 18:08   https://twitter.com/Crimsontider/status/1242936586565713922 jungle primary 7780 Loeffler 13671 Kelly Loeffler REP 20.4
2367 2367 120529 64994 2020 Georgia 1549 Battleground Connect     Battleground Connect 563 Battleground Connect   1025 lv lv IVR U.S. Senate 2 Class III 3/7/20 3/7/20 11/3/20 Doug Collins 1 REP   0 0 3/26/20 18:08   https://twitter.com/Crimsontider/status/1242936586565713922 jungle primary 7780 Tarver 14490 Ed Tarver DEM 4.9
2368 2368 120529 64994 2020 Georgia 1549 Battleground Connect     Battleground Connect 563 Battleground Connect   1025 lv lv IVR U.S. Senate 2 Class III 3/7/20 3/7/20 11/3/20 Doug Collins 1 REP   0 0 3/26/20 18:08   https://twitter.com/Crimsontider/status/1242936586565713922 jungle primary 7780 Warnock 14489 Raphael Warnock DEM 11.6

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "senate_polls" (
"question_id" INTEGER,
  "poll_id" INTEGER,
  "cycle" INTEGER,
  "state" TEXT,
  "pollster_id" INTEGER,
  "pollster" TEXT,
  "sponsor_ids" TEXT,
  "sponsors" TEXT,
  "display_name" TEXT,
  "pollster_rating_id" INTEGER,
  "pollster_rating_name" TEXT,
  "fte_grade" TEXT,
  "sample_size" INTEGER,
  "population" TEXT,
  "population_full" TEXT,
  "methodology" TEXT,
  "office_type" TEXT,
  "seat_number" INTEGER,
  "seat_name" TEXT,
  "start_date" TEXT,
  "end_date" TEXT,
  "election_date" TEXT,
  "sponsor_candidate" TEXT,
  "internal" INTEGER,
  "partisan" TEXT,
  "tracking" TEXT,
  "nationwide_batch" INTEGER,
  "ranked_choice_reallocated" INTEGER,
  "created_at" TEXT,
  "notes" TEXT,
  "url" TEXT,
  "stage" TEXT,
  "race_id" INTEGER,
  "answer" TEXT,
  "candidate_id" INTEGER,
  "candidate_name" TEXT,
  "candidate_party" TEXT,
  "pct" REAL
);