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

Cleaned Combined Political News 2024–11–07

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.cleaned_combined_political_news_2024_11_07
  • 16.91 MB
  • 24,242 rows
  • 7 columns
Loading...
CREATE TABLE cleaned_combined_political_news_2024_11_07 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "name" VARCHAR,
  "publish_date" TIMESTAMP,
  "description" VARCHAR,
  "source" VARCHAR,
  "link" VARCHAR,
  "scraper_source" VARCHAR
);

Cleaned Dfs2–2024–12–04

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.cleaned_dfs2_2024_12_04
  • 422.89 kB
  • 3,310 rows
  • 10 columns
Loading...
CREATE TABLE cleaned_dfs2_2024_12_04 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "name" VARCHAR,
  "channel_uploader" VARCHAR,
  "author" VARCHAR,
  "publish_date" TIMESTAMP,
  "updated_date" TIMESTAMP,
  "like_count" BIGINT,
  "text_display" VARCHAR,
  "link" VARCHAR,
  "scraper_source" VARCHAR
);

Combined Political News 2024–11–07

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.combined_political_news_2024_11_07
  • 68.96 MB
  • 106,828 rows
  • 5 columns
Loading...
CREATE TABLE combined_political_news_2024_11_07 (
  "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
  • 17.33 MB
  • 27,552 rows
  • 12 columns
Loading...
CREATE TABLE joined_dfps_24_12_04 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "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
);

Political News Data 20240923

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.political_news_data_20240923
  • 851.56 kB
  • 1,291 rows
  • 5 columns
Loading...
CREATE TABLE political_news_data_20240923 (
  "title" VARCHAR,
  "date" VARCHAR,
  "source" VARCHAR,
  "link" VARCHAR,
  "description" VARCHAR
);

Political News Data 20240924

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.political_news_data_20240924
  • 851.56 kB
  • 1,291 rows
  • 5 columns
Loading...
CREATE TABLE political_news_data_20240924 (
  "title" VARCHAR,
  "date" VARCHAR,
  "source" VARCHAR,
  "link" VARCHAR,
  "description" VARCHAR
);

Political News Data 20240925

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.political_news_data_20240925
  • 919.74 kB
  • 1,400 rows
  • 5 columns
Loading...
CREATE TABLE political_news_data_20240925 (
  "title" VARCHAR,
  "date" VARCHAR,
  "source" VARCHAR,
  "link" VARCHAR,
  "description" VARCHAR
);

Political News Data 20240928

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.political_news_data_20240928
  • 926.51 kB
  • 1,404 rows
  • 5 columns
Loading...
CREATE TABLE political_news_data_20240928 (
  "title" VARCHAR,
  "date" VARCHAR,
  "source" VARCHAR,
  "link" VARCHAR,
  "description" VARCHAR
);

Political News Data 2024–09–29

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.political_news_data_2024_09_29
  • 1.27 MB
  • 2,003 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.27 MB
  • 2,002 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–01

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.political_news_data_2024_10_01
  • 1.26 MB
  • 2,000 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–02

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.political_news_data_2024_10_02
  • 1.28 MB
  • 2,002 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–04

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.political_news_data_2024_10_04
  • 1.26 MB
  • 2,000 rows
  • 5 columns
Loading...
CREATE TABLE political_news_data_2024_10_04 (
  "title" VARCHAR,
  "date" VARCHAR,
  "description" VARCHAR,
  "source" VARCHAR,
  "link" VARCHAR
);

Political News Data 2024–10–07

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.political_news_data_2024_10_07
  • 1.27 MB
  • 1,999 rows
  • 5 columns
Loading...
CREATE TABLE political_news_data_2024_10_07 (
  "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.3 MB
  • 1,992 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–10–12

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.political_news_data_2024_10_12
  • 1.29 MB
  • 2,006 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 2024–10–14

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.political_news_data_2024_10_14
  • 1.29 MB
  • 2,002 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 2024–10–15

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.political_news_data_2024_10_15
  • 1.27 MB
  • 2,004 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–16

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.political_news_data_2024_10_16
  • 1.26 MB
  • 2,003 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 2024–10–17

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.political_news_data_2024_10_17
  • 1.27 MB
  • 2,002 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–20

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.political_news_data_2024_10_20
  • 1.28 MB
  • 1,995 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–10–21

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.political_news_data_2024_10_21
  • 1.29 MB
  • 2,001 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–22

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.political_news_data_2024_10_22
  • 1.29 MB
  • 1,997 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–10–23

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.political_news_data_2024_10_23
  • 1.3 MB
  • 2,006 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–24

@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris.political_news_data_2024_10_24
  • 1.27 MB
  • 1,997 rows
  • 5 columns
Loading...
CREATE TABLE political_news_data_2024_10_24 (
  "title" VARCHAR,
  "date" VARCHAR,
  "description" VARCHAR,
  "source" VARCHAR,
  "link" VARCHAR
);

Share link

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