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

WikidataId/Q6026806 - Time Series For Statistical Variables

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

WikidataId/Q6026809 - Time Series For Statistical Variables

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

WikidataId/Q6026812 - Time Series For Statistical Variables

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

WikidataId/Q6026815 - Time Series For Statistical Variables

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

WikidataId/Q6026818 - Time Series For Statistical Variables

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

WikidataId/Q6026825 - Time Series For Statistical Variables

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

WikidataId/Q6026829 - Time Series For Statistical Variables

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

WikidataId/Q6026832 - Time Series For Statistical Variables

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

WikidataId/Q6026835 - Time Series For Statistical Variables

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

WikidataId/Q6026838 - Time Series For Statistical Variables

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

WikidataId/Q6026849 - Time Series For Statistical Variables

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

WikidataId/Q6026851 - Time Series For Statistical Variables

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

WikidataId/Q6026855 - Time Series For Statistical Variables

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

WikidataId/Q6026861 - Time Series For Statistical Variables

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

WikidataId/Q6026864 - Time Series For Statistical Variables

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

WikidataId/Q6026866 - Time Series For Statistical Variables

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

WikidataId/Q6026869 - Time Series For Statistical Variables

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

WikidataId/Q6026910 - Time Series For Statistical Variables

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

WikidataId/Q6026924 - Time Series For Statistical Variables

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

WikidataId/Q6027080 - Time Series For Statistical Variables

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

WikidataId/Q6027082 - Time Series For Statistical Variables

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

WikidataId/Q6027613 - Time Series For Statistical Variables

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

WikidataId/Q6027750 - Time Series For Statistical Variables

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

WikidataId/Q6027794 - Time Series For Statistical Variables

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

WikidataId/Q6027822 - Time Series For Statistical Variables

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