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

Auma-Weidatal - Time Series For Statistical Variables

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

Aumsville - Time Series For Statistical Variables

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

Aunglan - Time Series For Statistical Variables

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

Auning - Time Series For Statistical Variables

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

Aunslev - Time Series For Statistical Variables

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

Aurangabad - Time Series For Statistical Variables

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

Aurdal Township - Time Series For Statistical Variables

@datacommons.cities.aurdal_township_geoid_2702836
  • 82.7 kB
  • 13,165 rows
  • 12 columns
Loading... 
CREATE TABLE aurdal_township_geoid_2702836 (
  "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
);

Aurelia - Time Series For Statistical Variables

@datacommons.cities.aurelia_geoid_1903745
  • 2.98 MB
  • 346,564 rows
  • 12 columns
Loading... 
CREATE TABLE aurelia_geoid_1903745 (
  "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
);

Aurelius - Time Series For Statistical Variables

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

Aurelius Township - Time Series For Statistical Variables

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

Aurelius Township - Time Series For Statistical Variables

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

Aurena Township - Time Series For Statistical Variables

@datacommons.cities.aurena_township_geoid_3803820
  • 68.82 kB
  • 11,012 rows
  • 12 columns
Loading... 
CREATE TABLE aurena_township_geoid_3803820 (
  "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
);

Aurich - Time Series For Statistical Variables

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

Auriesville - Time Series For Statistical Variables

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

Auriflama - Time Series For Statistical Variables

@datacommons.cities.auriflama_wikidataid_q268956
  • 24.27 kB
  • 1,607 rows
  • 12 columns
Loading... 
CREATE TABLE auriflama_wikidataid_q268956 (
  "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
);

Aurora Center - Time Series For Statistical Variables

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

Aurora - Time Series For Statistical Variables

@datacommons.cities.aurora_geoid_0804000
  • 4.65 MB
  • 416,094 rows
  • 12 columns
Loading... 
CREATE TABLE aurora_geoid_0804000 (
  "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
);

Aurora - Time Series For Statistical Variables

@datacommons.cities.aurora_geoid_1703012
  • 4.31 MB
  • 401,214 rows
  • 12 columns
Loading... 
CREATE TABLE aurora_geoid_1703012 (
  "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
);

Aurora - Time Series For Statistical Variables

@datacommons.cities.aurora_geoid_1802782
  • 3.16 MB
  • 355,001 rows
  • 12 columns
Loading... 
CREATE TABLE aurora_geoid_1802782 (
  "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
);

Aurora - Time Series For Statistical Variables

@datacommons.cities.aurora_geoid_1903835
  • 2.83 MB
  • 342,477 rows
  • 12 columns
Loading... 
CREATE TABLE aurora_geoid_1903835 (
  "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
);

Aurora - Time Series For Statistical Variables

@datacommons.cities.aurora_geoid_2003425
  • 2.74 MB
  • 338,605 rows
  • 12 columns
Loading... 
CREATE TABLE aurora_geoid_2003425 (
  "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
);

Aurora - Time Series For Statistical Variables

@datacommons.cities.aurora_geoid_2302165
  • 103.22 kB
  • 16,916 rows
  • 12 columns
Loading... 
CREATE TABLE aurora_geoid_2302165 (
  "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
);

Aurora - Time Series For Statistical Variables

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

Aurora - Time Series For Statistical Variables

@datacommons.cities.aurora_geoid_2902548
  • 3.21 MB
  • 356,718 rows
  • 12 columns
Loading... 
CREATE TABLE aurora_geoid_2902548 (
  "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
);

Aurora - Time Series For Statistical Variables

@datacommons.cities.aurora_geoid_3102690
  • 3.17 MB
  • 356,078 rows
  • 12 columns
Loading... 
CREATE TABLE aurora_geoid_3102690 (
  "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.