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

Athol - Time Series For Statistical Variables

@datacommons.cities.athol_wikidataid_q2560090
  • 101.58 kB
  • 15,466 rows
  • 12 columns
Loading... 
CREATE TABLE athol_wikidataid_q2560090 (
  "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
);

Athus - Time Series For Statistical Variables

@datacommons.cities.athus_wikidataid_q653845
  • 64.38 kB
  • 8,388 rows
  • 12 columns
Loading... 
CREATE TABLE athus_wikidataid_q653845 (
  "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
);

Ath - Time Series For Statistical Variables

@datacommons.cities.ath_wikidataid_q31469957
  • 71.47 kB
  • 10,266 rows
  • 12 columns
Loading... 
CREATE TABLE ath_wikidataid_q31469957 (
  "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
);

Ath - Time Series For Statistical Variables

@datacommons.cities.ath_wikidataid_q95096
  • 71.73 kB
  • 10,267 rows
  • 12 columns
Loading... 
CREATE TABLE ath_wikidataid_q95096 (
  "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
);

Athy - Time Series For Statistical Variables

@datacommons.cities.athy_wikidataid_q251091
  • 47.59 kB
  • 5,240 rows
  • 12 columns
Loading... 
CREATE TABLE athy_wikidataid_q251091 (
  "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
);

Atibaia - Time Series For Statistical Variables

@datacommons.cities.atibaia_wikidataid_q1637405
  • 59.05 kB
  • 6,752 rows
  • 12 columns
Loading... 
CREATE TABLE atibaia_wikidataid_q1637405 (
  "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
);

Atikameg - Time Series For Statistical Variables

@datacommons.cities.atikameg_wikidataid_q4815782
  • 9.46 kB
  • 1 row
  • 12 columns
Loading... 
CREATE TABLE atikameg_wikidataid_q4815782 (
  "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
);

Atil - Time Series For Statistical Variables

@datacommons.cities.atil_undata_geo_c16801722
  • 9.19 kB
  • 1 row
  • 12 columns
Loading... 
CREATE TABLE atil_undata_geo_c16801722 (
  "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
);

Ati - Time Series For Statistical Variables

@datacommons.cities.ati_wikidataid_q755791
  • 25.5 kB
  • 2,913 rows
  • 12 columns
Loading... 
CREATE TABLE ati_wikidataid_q755791 (
  "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
);

Atizapán De Zaragoza - Time Series For Statistical Variables

@datacommons.cities.atizap_n_de_zaragoza_undata_geo_c16800666
  • 9.31 kB
  • 1 row
  • 12 columns
Loading... 
CREATE TABLE atizap_n_de_zaragoza_undata_geo_c16800666 (
  "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
);

Atizapán - Time Series For Statistical Variables

@datacommons.cities.atizap_n_undata_geo_c16800665
  • 9.22 kB
  • 1 row
  • 12 columns
Loading... 
CREATE TABLE atizap_n_undata_geo_c16800665 (
  "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
);

Atka - Time Series For Statistical Variables

@datacommons.cities.atka_geoid_0204210
  • 1.21 MB
  • 172,099 rows
  • 12 columns
Loading... 
CREATE TABLE atka_geoid_0204210 (
  "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
);

Atkarsk - Time Series For Statistical Variables

@datacommons.cities.atkarsk_wikidataid_q104143
  • 71.43 kB
  • 9,320 rows
  • 12 columns
Loading... 
CREATE TABLE atkarsk_wikidataid_q104143 (
  "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
);

Atkins - Time Series For Statistical Variables

@datacommons.cities.atkins_geoid_0502590
  • 3.12 MB
  • 351,652 rows
  • 12 columns
Loading... 
CREATE TABLE atkins_geoid_0502590 (
  "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
);

Atkins - Time Series For Statistical Variables

@datacommons.cities.atkins_geoid_1903475
  • 3.02 MB
  • 348,505 rows
  • 12 columns
Loading... 
CREATE TABLE atkins_geoid_1903475 (
  "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
);

Atkins - Time Series For Statistical Variables

@datacommons.cities.atkins_geoid_5103512
  • 2.95 MB
  • 348,499 rows
  • 12 columns
Loading... 
CREATE TABLE atkins_geoid_5103512 (
  "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
);

Atkinson And Gilmanton Academy Grant - Time Series For Statistical Variables

@datacommons.cities.atkinson_and_gilmanton_academy_grant_geoid_3302420
  • 78.28 kB
  • 12,469 rows
  • 12 columns
Loading... 
CREATE TABLE atkinson_and_gilmanton_academy_grant_geoid_3302420 (
  "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
);

Atkinson - Time Series For Statistical Variables

@datacommons.cities.atkinson_geoid_1702726
  • 3.01 MB
  • 350,483 rows
  • 12 columns
Loading... 
CREATE TABLE atkinson_geoid_1702726 (
  "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
);

Atkinson - Time Series For Statistical Variables

@datacommons.cities.atkinson_geoid_3102550
  • 3.03 MB
  • 351,254 rows
  • 12 columns
Loading... 
CREATE TABLE atkinson_geoid_3102550 (
  "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
);

Atkinson - Time Series For Statistical Variables

@datacommons.cities.atkinson_geoid_3302340
  • 109.28 kB
  • 17,766 rows
  • 12 columns
Loading... 
CREATE TABLE atkinson_geoid_3302340 (
  "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
);

Atkinson - Time Series For Statistical Variables

@datacommons.cities.atkinson_geoid_3702460
  • 2.88 MB
  • 344,514 rows
  • 12 columns
Loading... 
CREATE TABLE atkinson_geoid_3702460 (
  "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
);

Atkinson Mills - Time Series For Statistical Variables

@datacommons.cities.atkinson_mills_geoid_4203424
  • 2.76 MB
  • 339,107 rows
  • 12 columns
Loading... 
CREATE TABLE atkinson_mills_geoid_4203424 (
  "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
);

Atkinson Mills - Time Series For Statistical Variables

@datacommons.cities.atkinson_mills_wikidataid_q4815924
  • 93.3 kB
  • 14,265 rows
  • 12 columns
Loading... 
CREATE TABLE atkinson_mills_wikidataid_q4815924 (
  "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
);

Atkinson Township - Time Series For Statistical Variables

@datacommons.cities.atkinson_township_geoid_1702739
  • 100.04 kB
  • 15,328 rows
  • 12 columns
Loading... 
CREATE TABLE atkinson_township_geoid_1702739 (
  "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
);

Atkinson Township - Time Series For Statistical Variables

@datacommons.cities.atkinson_township_geoid_2702656
  • 96.41 kB
  • 14,921 rows
  • 12 columns
Loading... 
CREATE TABLE atkinson_township_geoid_2702656 (
  "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.