Baselight
Sign In

Cities

Urban Statistics and Key Metrics

@datacommons.cities

Loading...
Loading...

About this Dataset

Cities

This dataset includes key statistical variables for worldwide cities, providing data on population, infrastructure, economy, and urban development.

Tables

Addis - Time Series For Statistical Variables

@datacommons.cities.addis_wikidataid_q2429127
  • 71.3 kB
  • 13,521 rows
  • 12 columns
Loading... 

CREATE TABLE addis_wikidataid_q2429127 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Ad Dis - Time Series For Statistical Variables

@datacommons.cities.ad_dis_wikidataid_q4678136
  • 9.56 kB
  • 1 row
  • 12 columns
Loading... 

CREATE TABLE ad_dis_wikidataid_q4678136 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" BIGINT,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Addlestone - Time Series For Statistical Variables

@datacommons.cities.addlestone_wikidataid_q353307
  • 59.34 kB
  • 7,858 rows
  • 12 columns
Loading... 

CREATE TABLE addlestone_wikidataid_q353307 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Addo, Eastern Cape - Time Series For Statistical Variables

@datacommons.cities.addo_eastern_cape_wikidataid_q4681358
  • 60.76 kB
  • 7,590 rows
  • 12 columns
Loading... 

CREATE TABLE addo_eastern_cape_wikidataid_q4681358 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Addu City - Time Series For Statistical Variables

@datacommons.cities.addu_city_wikidataid_q4681407
  • 29.93 kB
  • 3,421 rows
  • 12 columns
Loading... 

CREATE TABLE addu_city_wikidataid_q4681407 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Addy - Time Series For Statistical Variables

@datacommons.cities.addy_geoid_5300380
  • 2.64 MB
  • 329,061 rows
  • 12 columns
Loading... 

CREATE TABLE addy_geoid_5300380 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Addyston - Time Series For Statistical Variables

@datacommons.cities.addyston_geoid_3900436
  • 2.91 MB
  • 345,672 rows
  • 12 columns
Loading... 

CREATE TABLE addyston_geoid_3900436 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Addy - Time Series For Statistical Variables

@datacommons.cities.addy_wikidataid_q3474840
  • 81.29 kB
  • 13,140 rows
  • 12 columns
Loading... 

CREATE TABLE addy_wikidataid_q3474840 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Adelaide Lead - Time Series For Statistical Variables

@datacommons.cities.adelaide_lead_wikidataid_q4681743
  • 53.74 kB
  • 6,287 rows
  • 12 columns
Loading... 

CREATE TABLE adelaide_lead_wikidataid_q4681743 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Adelaide Metcalfe - Time Series For Statistical Variables

@datacommons.cities.adelaide_metcalfe_wikidataid_q3525341
  • 9.47 kB
  • 1 row
  • 12 columns
Loading... 

CREATE TABLE adelaide_metcalfe_wikidataid_q3525341 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" BIGINT,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Adelaide River - Time Series For Statistical Variables

@datacommons.cities.adelaide_river_wikidataid_q17903
  • 48.53 kB
  • 6,096 rows
  • 12 columns
Loading... 

CREATE TABLE adelaide_river_wikidataid_q17903 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Adelaide Township - Time Series For Statistical Variables

@datacommons.cities.adelaide_township_geoid_3800540
  • 75.36 kB
  • 12,219 rows
  • 12 columns
Loading... 

CREATE TABLE adelaide_township_geoid_3800540 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Adelaide - Time Series For Statistical Variables

@datacommons.cities.adelaide_wikidataid_q353952
  • 49.27 kB
  • 5,399 rows
  • 12 columns
Loading... 

CREATE TABLE adelaide_wikidataid_q353952 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Adelaide - Time Series For Statistical Variables

@datacommons.cities.adelaide_wikidataid_q4681658
  • 76.47 kB
  • 13,873 rows
  • 12 columns
Loading... 

CREATE TABLE adelaide_wikidataid_q4681658 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Adelaide - Time Series For Statistical Variables

@datacommons.cities.adelaide_wikidataid_q5112
  • 99.34 kB
  • 13,548 rows
  • 12 columns
Loading... 

CREATE TABLE adelaide_wikidataid_q5112 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Adelanto - Time Series For Statistical Variables

@datacommons.cities.adelanto_geoid_0600296
  • 3.38 MB
  • 361,103 rows
  • 12 columns
Loading... 

CREATE TABLE adelanto_geoid_0600296 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Adel - Time Series For Statistical Variables

@datacommons.cities.adel_geoid_1300576
  • 3.16 MB
  • 356,859 rows
  • 12 columns
Loading... 

CREATE TABLE adel_geoid_1300576 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Adel - Time Series For Statistical Variables

@datacommons.cities.adel_geoid_1900505
  • 3.19 MB
  • 357,080 rows
  • 12 columns
Loading... 

CREATE TABLE adel_geoid_1900505 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Adeline - Time Series For Statistical Variables

@datacommons.cities.adeline_geoid_1700295
  • 2.77 MB
  • 341,731 rows
  • 12 columns
Loading... 

CREATE TABLE adeline_geoid_1700295 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Adelino - Time Series For Statistical Variables

@datacommons.cities.adelino_geoid_3500940
  • 2.84 MB
  • 341,113 rows
  • 12 columns
Loading... 

CREATE TABLE adelino_geoid_3500940 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Adell - Time Series For Statistical Variables

@datacommons.cities.adell_geoid_5500450
  • 2.88 MB
  • 345,251 rows
  • 12 columns
Loading... 

CREATE TABLE adell_geoid_5500450 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Adell Township - Time Series For Statistical Variables

@datacommons.cities.adell_township_geoid_2000300
  • 93.03 kB
  • 13,871 rows
  • 12 columns
Loading... 

CREATE TABLE adell_township_geoid_2000300 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Adelong - Time Series For Statistical Variables

@datacommons.cities.adelong_wikidataid_q964970
  • 46.26 kB
  • 5,850 rows
  • 12 columns
Loading... 

CREATE TABLE adelong_wikidataid_q964970 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Adelphi - Time Series For Statistical Variables

@datacommons.cities.adelphi_geoid_2400400
  • 3.4 MB
  • 367,001 rows
  • 12 columns
Loading... 

CREATE TABLE adelphi_geoid_2400400 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Adelphi - Time Series For Statistical Variables

@datacommons.cities.adelphi_geoid_3900450
  • 2.84 MB
  • 341,444 rows
  • 12 columns
Loading... 

CREATE TABLE adelphi_geoid_3900450 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Share link

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