2024 Election Coverage For Trump And Harris
analyzing 2024 news coverage and sentiment
@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris
analyzing 2024 news coverage and sentiment
@kaggle.lorrainewheat_2024_election_coverage_for_trump_and_harris
CREATE TABLE political_news_data_2024_10_01 (
"title" VARCHAR,
"date" VARCHAR,
"description" VARCHAR,
"source" VARCHAR,
"link" VARCHAR
);
CREATE TABLE political_news_data_2024_10_09 (
"title" VARCHAR,
"date" VARCHAR,
"description" VARCHAR,
"source" VARCHAR,
"link" VARCHAR
);
CREATE TABLE political_news_data_2024_09_29 (
"title" VARCHAR,
"date" VARCHAR,
"description" VARCHAR,
"source" VARCHAR,
"link" VARCHAR
);
CREATE TABLE political_news_data_2024_09_30 (
"title" VARCHAR,
"date" VARCHAR,
"description" VARCHAR,
"source" VARCHAR,
"link" VARCHAR
);
CREATE TABLE political_news_data_2024_10_02 (
"title" VARCHAR,
"date" VARCHAR,
"description" VARCHAR,
"source" VARCHAR,
"link" VARCHAR
);
CREATE TABLE political_news_data_2024_10_31 (
"title" VARCHAR,
"date" VARCHAR,
"description" VARCHAR,
"source" VARCHAR,
"link" VARCHAR
);
CREATE TABLE political_news_data_2024_10_22 (
"title" VARCHAR,
"date" VARCHAR,
"description" VARCHAR,
"source" VARCHAR,
"link" VARCHAR
);
CREATE TABLE political_news_data_2024_11_04 (
"title" VARCHAR,
"date" VARCHAR,
"description" VARCHAR,
"source" VARCHAR,
"link" VARCHAR
);
CREATE TABLE political_news_data_2024_10_16 (
"title" VARCHAR,
"date" VARCHAR,
"description" VARCHAR,
"source" VARCHAR,
"link" VARCHAR
);
CREATE TABLE political_news_data_20240924 (
"title" VARCHAR,
"date" VARCHAR,
"source" VARCHAR,
"link" VARCHAR,
"description" VARCHAR
);
CREATE TABLE political_news_data_2024_10_14 (
"title" VARCHAR,
"date" VARCHAR,
"description" VARCHAR,
"source" VARCHAR,
"link" VARCHAR
);
CREATE TABLE political_news_data_20240928 (
"title" VARCHAR,
"date" VARCHAR,
"source" VARCHAR,
"link" VARCHAR,
"description" VARCHAR
);
CREATE TABLE political_news_data_2024_10_15 (
"title" VARCHAR,
"date" VARCHAR,
"description" VARCHAR,
"source" VARCHAR,
"link" VARCHAR
);
CREATE TABLE political_news_data_2024_10_21 (
"title" VARCHAR,
"date" VARCHAR,
"description" VARCHAR,
"source" VARCHAR,
"link" VARCHAR
);
CREATE TABLE political_news_data_2024_10_24 (
"title" VARCHAR,
"date" VARCHAR,
"description" VARCHAR,
"source" VARCHAR,
"link" VARCHAR
);
CREATE TABLE political_news_data_2024_11_06 (
"title" VARCHAR,
"date" VARCHAR,
"description" VARCHAR,
"source" VARCHAR,
"link" VARCHAR
);
CREATE TABLE political_news_data_2024_10_26 (
"title" VARCHAR,
"date" VARCHAR,
"description" VARCHAR,
"source" VARCHAR,
"link" VARCHAR
);
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
);
CREATE TABLE political_news_data_2024_10_20 (
"title" VARCHAR,
"date" VARCHAR,
"description" VARCHAR,
"source" VARCHAR,
"link" VARCHAR
);
CREATE TABLE political_news_data_2024_11_02 (
"title" VARCHAR,
"date" VARCHAR,
"description" VARCHAR,
"source" VARCHAR,
"link" VARCHAR
);
CREATE TABLE political_news_data_2024_10_23 (
"title" VARCHAR,
"date" VARCHAR,
"description" VARCHAR,
"source" VARCHAR,
"link" VARCHAR
);
CREATE TABLE political_news_data_2024_10_04 (
"title" VARCHAR,
"date" VARCHAR,
"description" VARCHAR,
"source" VARCHAR,
"link" VARCHAR
);
CREATE TABLE combined_political_news_2024_11_07 (
"title" VARCHAR,
"date" VARCHAR,
"description" VARCHAR,
"source" VARCHAR,
"link" VARCHAR
);
CREATE TABLE political_news_data_20240925 (
"title" VARCHAR,
"date" VARCHAR,
"source" VARCHAR,
"link" VARCHAR,
"description" VARCHAR
);
CREATE TABLE political_news_data_2024_10_07 (
"title" VARCHAR,
"date" VARCHAR,
"description" VARCHAR,
"source" VARCHAR,
"link" VARCHAR
);
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
);
CREATE TABLE political_news_data_2024_10_29 (
"title" VARCHAR,
"date" VARCHAR,
"description" VARCHAR,
"source" VARCHAR,
"link" VARCHAR
);
CREATE TABLE political_news_data_2024_10_17 (
"title" VARCHAR,
"date" VARCHAR,
"description" VARCHAR,
"source" VARCHAR,
"link" VARCHAR
);
CREATE TABLE political_news_data_2024_10_12 (
"title" VARCHAR,
"date" VARCHAR,
"description" VARCHAR,
"source" VARCHAR,
"link" VARCHAR
);
CREATE TABLE political_news_data_20240923 (
"title" VARCHAR,
"date" VARCHAR,
"source" VARCHAR,
"link" VARCHAR,
"description" VARCHAR
);
CREATE TABLE political_news_data_2024_11_05 (
"title" VARCHAR,
"date" VARCHAR,
"description" VARCHAR,
"source" VARCHAR,
"link" VARCHAR
);
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
);
Anyone who has the link will be able to view this.