Baselight

2024 Election Coverage For Trump And Harris

analyzing 2024 news coverage and sentiment

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris

Loading...
Loading...

About this Dataset

2024 Election Coverage For Trump And Harris

A collection of CSV files that include news headlines and YouTube comments and video titles scraped from the web using Python. Scraped from September 2024 to November 2024, it is a look at the reporting on Kamala Harris and Donald Trump to identify the trends and climate.

Tables

Political News Data 2024–10–01

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.political_news_data_2024_10_01
  • 1.2 MB
  • 2000 rows
  • 5 columns
Loading...

CREATE TABLE political_news_data_2024_10_01 (
  "title" VARCHAR,
  "date" VARCHAR,
  "description" VARCHAR,
  "source" VARCHAR,
  "link" VARCHAR
);

Political News Data 2024–10–09

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.political_news_data_2024_10_09
  • 1.24 MB
  • 1992 rows
  • 5 columns
Loading...

CREATE TABLE political_news_data_2024_10_09 (
  "title" VARCHAR,
  "date" VARCHAR,
  "description" VARCHAR,
  "source" VARCHAR,
  "link" VARCHAR
);

Political News Data 2024–09–29

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.political_news_data_2024_09_29
  • 1.21 MB
  • 2003 rows
  • 5 columns
Loading...

CREATE TABLE political_news_data_2024_09_29 (
  "title" VARCHAR,
  "date" VARCHAR,
  "description" VARCHAR,
  "source" VARCHAR,
  "link" VARCHAR
);

Political News Data 2024–09–30

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.political_news_data_2024_09_30
  • 1.21 MB
  • 2002 rows
  • 5 columns
Loading...

CREATE TABLE political_news_data_2024_09_30 (
  "title" VARCHAR,
  "date" VARCHAR,
  "description" VARCHAR,
  "source" VARCHAR,
  "link" VARCHAR
);

Political News Data 2024–10–02

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.political_news_data_2024_10_02
  • 1.22 MB
  • 2002 rows
  • 5 columns
Loading...

CREATE TABLE political_news_data_2024_10_02 (
  "title" VARCHAR,
  "date" VARCHAR,
  "description" VARCHAR,
  "source" VARCHAR,
  "link" VARCHAR
);

Political News Data 2024–10–31

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.political_news_data_2024_10_31
  • 1.25 MB
  • 2005 rows
  • 5 columns
Loading...

CREATE TABLE political_news_data_2024_10_31 (
  "title" VARCHAR,
  "date" VARCHAR,
  "description" VARCHAR,
  "source" VARCHAR,
  "link" VARCHAR
);

Political News Data 2024–10–22

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.political_news_data_2024_10_22
  • 1.23 MB
  • 1997 rows
  • 5 columns
Loading...

CREATE TABLE political_news_data_2024_10_22 (
  "title" VARCHAR,
  "date" VARCHAR,
  "description" VARCHAR,
  "source" VARCHAR,
  "link" VARCHAR
);

Political News Data 2024–11–04

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.political_news_data_2024_11_04
  • 1.23 MB
  • 1993 rows
  • 5 columns
Loading...

CREATE TABLE political_news_data_2024_11_04 (
  "title" VARCHAR,
  "date" VARCHAR,
  "description" VARCHAR,
  "source" VARCHAR,
  "link" VARCHAR
);

Political News Data 2024–10–16

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.political_news_data_2024_10_16
  • 1.21 MB
  • 2003 rows
  • 5 columns
Loading...

CREATE TABLE political_news_data_2024_10_16 (
  "title" VARCHAR,
  "date" VARCHAR,
  "description" VARCHAR,
  "source" VARCHAR,
  "link" VARCHAR
);

Political News Data 20240924

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.political_news_data_20240924
  • 831.6 KB
  • 1291 rows
  • 5 columns
Loading...

CREATE TABLE political_news_data_20240924 (
  "title" VARCHAR,
  "date" VARCHAR,
  "source" VARCHAR,
  "link" VARCHAR,
  "description" VARCHAR
);

Political News Data 2024–10–14

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.political_news_data_2024_10_14
  • 1.23 MB
  • 2002 rows
  • 5 columns
Loading...

CREATE TABLE political_news_data_2024_10_14 (
  "title" VARCHAR,
  "date" VARCHAR,
  "description" VARCHAR,
  "source" VARCHAR,
  "link" VARCHAR
);

Political News Data 20240928

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.political_news_data_20240928
  • 904.8 KB
  • 1404 rows
  • 5 columns
Loading...

CREATE TABLE political_news_data_20240928 (
  "title" VARCHAR,
  "date" VARCHAR,
  "source" VARCHAR,
  "link" VARCHAR,
  "description" VARCHAR
);

Political News Data 2024–10–15

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.political_news_data_2024_10_15
  • 1.21 MB
  • 2004 rows
  • 5 columns
Loading...

CREATE TABLE political_news_data_2024_10_15 (
  "title" VARCHAR,
  "date" VARCHAR,
  "description" VARCHAR,
  "source" VARCHAR,
  "link" VARCHAR
);

Political News Data 2024–10–21

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.political_news_data_2024_10_21
  • 1.23 MB
  • 2001 rows
  • 5 columns
Loading...

CREATE TABLE political_news_data_2024_10_21 (
  "title" VARCHAR,
  "date" VARCHAR,
  "description" VARCHAR,
  "source" VARCHAR,
  "link" VARCHAR
);

Political News Data 2024–10–24

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.political_news_data_2024_10_24
  • 1.21 MB
  • 1997 rows
  • 5 columns
Loading...

CREATE TABLE political_news_data_2024_10_24 (
  "title" VARCHAR,
  "date" VARCHAR,
  "description" VARCHAR,
  "source" VARCHAR,
  "link" VARCHAR
);

Political News Data 2024–11–06

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.political_news_data_2024_11_06
  • 1.22 MB
  • 2010 rows
  • 5 columns
Loading...

CREATE TABLE political_news_data_2024_11_06 (
  "title" VARCHAR,
  "date" VARCHAR,
  "description" VARCHAR,
  "source" VARCHAR,
  "link" VARCHAR
);

Political News Data 2024–10–26

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.political_news_data_2024_10_26
  • 1.25 MB
  • 1999 rows
  • 5 columns
Loading...

CREATE TABLE political_news_data_2024_10_26 (
  "title" VARCHAR,
  "date" VARCHAR,
  "description" VARCHAR,
  "source" VARCHAR,
  "link" VARCHAR
);

Cleaned Combined Political News 2024–11–07

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.cleaned_combined_political_news_2024_11_07
  • 16.13 MB
  • 24242 rows
  • 7 columns
Loading...

CREATE TABLE cleaned_combined_political_news_2024_11_07 (
  "unnamed_0" BIGINT,
  "name" VARCHAR,
  "publish_date" TIMESTAMP,
  "description" VARCHAR,
  "source" VARCHAR,
  "link" VARCHAR,
  "scraper_source" VARCHAR
);

Political News Data 2024–10–20

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.political_news_data_2024_10_20
  • 1.23 MB
  • 1995 rows
  • 5 columns
Loading...

CREATE TABLE political_news_data_2024_10_20 (
  "title" VARCHAR,
  "date" VARCHAR,
  "description" VARCHAR,
  "source" VARCHAR,
  "link" VARCHAR
);

Political News Data 2024–11–02

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.political_news_data_2024_11_02
  • 1.23 MB
  • 2000 rows
  • 5 columns
Loading...

CREATE TABLE political_news_data_2024_11_02 (
  "title" VARCHAR,
  "date" VARCHAR,
  "description" VARCHAR,
  "source" VARCHAR,
  "link" VARCHAR
);

Political News Data 2024–10–23

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.political_news_data_2024_10_23
  • 1.24 MB
  • 2006 rows
  • 5 columns
Loading...

CREATE TABLE political_news_data_2024_10_23 (
  "title" VARCHAR,
  "date" VARCHAR,
  "description" VARCHAR,
  "source" VARCHAR,
  "link" VARCHAR
);

Political News Data 2024–10–04

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.political_news_data_2024_10_04
  • 1.2 MB
  • 2000 rows
  • 5 columns
Loading...

CREATE TABLE political_news_data_2024_10_04 (
  "title" VARCHAR,
  "date" VARCHAR,
  "description" VARCHAR,
  "source" VARCHAR,
  "link" VARCHAR
);

Combined Political News 2024–11–07

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.combined_political_news_2024_11_07
  • 65.77 MB
  • 106828 rows
  • 5 columns
Loading...

CREATE TABLE combined_political_news_2024_11_07 (
  "title" VARCHAR,
  "date" VARCHAR,
  "description" VARCHAR,
  "source" VARCHAR,
  "link" VARCHAR
);

Political News Data 20240925

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.political_news_data_20240925
  • 898.18 KB
  • 1400 rows
  • 5 columns
Loading...

CREATE TABLE political_news_data_20240925 (
  "title" VARCHAR,
  "date" VARCHAR,
  "source" VARCHAR,
  "link" VARCHAR,
  "description" VARCHAR
);

Political News Data 2024–10–07

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.political_news_data_2024_10_07
  • 1.21 MB
  • 1999 rows
  • 5 columns
Loading...

CREATE TABLE political_news_data_2024_10_07 (
  "title" VARCHAR,
  "date" VARCHAR,
  "description" VARCHAR,
  "source" VARCHAR,
  "link" VARCHAR
);

Cleaned Dfs2–2024–12–04

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.cleaned_dfs2_2024_12_04
  • 412.98 KB
  • 3310 rows
  • 10 columns
Loading...

CREATE TABLE cleaned_dfs2_2024_12_04 (
  "unnamed_0" BIGINT,
  "name" VARCHAR,
  "channel_uploader" VARCHAR,
  "author" VARCHAR,
  "publish_date" TIMESTAMP,
  "updated_date" TIMESTAMP,
  "like_count" BIGINT,
  "text_display" VARCHAR,
  "link" VARCHAR,
  "scraper_source" VARCHAR
);

Political News Data 2024–10–29

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.political_news_data_2024_10_29
  • 1.25 MB
  • 2002 rows
  • 5 columns
Loading...

CREATE TABLE political_news_data_2024_10_29 (
  "title" VARCHAR,
  "date" VARCHAR,
  "description" VARCHAR,
  "source" VARCHAR,
  "link" VARCHAR
);

Political News Data 2024–10–17

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.political_news_data_2024_10_17
  • 1.21 MB
  • 2002 rows
  • 5 columns
Loading...

CREATE TABLE political_news_data_2024_10_17 (
  "title" VARCHAR,
  "date" VARCHAR,
  "description" VARCHAR,
  "source" VARCHAR,
  "link" VARCHAR
);

Political News Data 2024–10–12

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.political_news_data_2024_10_12
  • 1.23 MB
  • 2006 rows
  • 5 columns
Loading...

CREATE TABLE political_news_data_2024_10_12 (
  "title" VARCHAR,
  "date" VARCHAR,
  "description" VARCHAR,
  "source" VARCHAR,
  "link" VARCHAR
);

Political News Data 20240923

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.political_news_data_20240923
  • 831.6 KB
  • 1291 rows
  • 5 columns
Loading...

CREATE TABLE political_news_data_20240923 (
  "title" VARCHAR,
  "date" VARCHAR,
  "source" VARCHAR,
  "link" VARCHAR,
  "description" VARCHAR
);

Political News Data 2024–11–05

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.political_news_data_2024_11_05
  • 1.27 MB
  • 2008 rows
  • 5 columns
Loading...

CREATE TABLE political_news_data_2024_11_05 (
  "title" VARCHAR,
  "date" VARCHAR,
  "description" VARCHAR,
  "source" VARCHAR,
  "link" VARCHAR
);

Joined Dfps 24–12–04

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.joined_dfps_24_12_04
  • 16.53 MB
  • 27552 rows
  • 12 columns
Loading...

CREATE TABLE joined_dfps_24_12_04 (
  "unnamed_0" BIGINT,
  "name" VARCHAR,
  "channel_uploader" VARCHAR,
  "author" VARCHAR,
  "publish_date" TIMESTAMP,
  "updated_date" TIMESTAMP,
  "like_count" DOUBLE,
  "text_display" VARCHAR,
  "link" VARCHAR,
  "scraper_source" VARCHAR,
  "description" VARCHAR,
  "source" VARCHAR
);

Share link

Anyone who has the link will be able to view this.