America Population Data 1955-2020
USA historical population data
@kaggle.haseebchohan_america_population_data_1955_2020
USA historical population data
@kaggle.haseebchohan_america_population_data_1955_2020
CREATE TABLE america_population_data_1955_2020 (
"year" BIGINT,
"population" BIGINT,
"yearly_change" VARCHAR,
"yearly_change_edbbdd" BIGINT,
"migrants_net" BIGINT,
"median_age" DOUBLE,
"fertility_rate" DOUBLE,
"density_p_km" BIGINT,
"urban_pop" VARCHAR,
"urban_population" BIGINT,
"country_s_share_of_world_pop" VARCHAR,
"world_population" BIGINT,
"u_s_global_rank" BIGINT
);
CREATE TABLE america_population_forecast (
"year" BIGINT,
"population" BIGINT,
"yearly_change" VARCHAR,
"yearly_change_edbbdd" BIGINT,
"migrants_net" BIGINT,
"median_age" DOUBLE,
"fertility_rate" DOUBLE,
"density_p_km" BIGINT,
"urban_pop" VARCHAR,
"urban_population" BIGINT,
"country_s_share_of_world_pop" VARCHAR,
"world_population" BIGINT,
"u_s_global_rank" BIGINT
);
CREATE TABLE cities_by_population (
"n" BIGINT,
"city_name" VARCHAR,
"population" BIGINT,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR
);
Anyone who has the link will be able to view this.