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/Q12395863 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12395863_wikidataid_q12395863
  • 53.39 kB
  • 6,670 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12395863_wikidataid_q12395863 (
  "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/Q12395866 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12395866_wikidataid_q12395866
  • 56.91 kB
  • 7,659 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12395866_wikidataid_q12395866 (
  "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/Q12395885 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12395885_wikidataid_q12395885
  • 56.09 kB
  • 7,116 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12395885_wikidataid_q12395885 (
  "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/Q12395906 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12395906_wikidataid_q12395906
  • 55.3 kB
  • 6,670 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12395906_wikidataid_q12395906 (
  "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/Q12395936 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12395936_wikidataid_q12395936
  • 54.76 kB
  • 7,116 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12395936_wikidataid_q12395936 (
  "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/Q12395957 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12395957_wikidataid_q12395957
  • 52.49 kB
  • 6,670 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12395957_wikidataid_q12395957 (
  "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/Q12395972 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12395972_wikidataid_q12395972
  • 42.36 kB
  • 5,092 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12395972_wikidataid_q12395972 (
  "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/Q12395984 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12395984_wikidataid_q12395984
  • 59.58 kB
  • 7,925 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12395984_wikidataid_q12395984 (
  "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/Q12395988 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12395988_wikidataid_q12395988
  • 58.92 kB
  • 7,925 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12395988_wikidataid_q12395988 (
  "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/Q12395996 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12395996_wikidataid_q12395996
  • 59.28 kB
  • 7,925 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12395996_wikidataid_q12395996 (
  "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/Q12396000 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12396000_wikidataid_q12396000
  • 42.27 kB
  • 5,092 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12396000_wikidataid_q12396000 (
  "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/Q12396008 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12396008_wikidataid_q12396008
  • 57.64 kB
  • 7,545 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12396008_wikidataid_q12396008 (
  "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/Q12396009 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12396009_wikidataid_q12396009
  • 52.22 kB
  • 6,670 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12396009_wikidataid_q12396009 (
  "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/Q12396010 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12396010_wikidataid_q12396010
  • 59.32 kB
  • 7,925 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12396010_wikidataid_q12396010 (
  "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/Q12396019 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12396019_wikidataid_q12396019
  • 59.24 kB
  • 7,925 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12396019_wikidataid_q12396019 (
  "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/Q12396027 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12396027_wikidataid_q12396027
  • 57.06 kB
  • 7,659 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12396027_wikidataid_q12396027 (
  "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/Q12396030 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12396030_wikidataid_q12396030
  • 56.85 kB
  • 7,659 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12396030_wikidataid_q12396030 (
  "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/Q12396047 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12396047_wikidataid_q12396047
  • 59.84 kB
  • 7,925 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12396047_wikidataid_q12396047 (
  "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/Q12396053 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12396053_wikidataid_q12396053
  • 59.22 kB
  • 7,925 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12396053_wikidataid_q12396053 (
  "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/Q12396074 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12396074_wikidataid_q12396074
  • 54.06 kB
  • 7,012 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12396074_wikidataid_q12396074 (
  "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/Q12396108 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12396108_wikidataid_q12396108
  • 59.39 kB
  • 7,925 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12396108_wikidataid_q12396108 (
  "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/Q12396130 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12396130_wikidataid_q12396130
  • 57.55 kB
  • 7,545 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12396130_wikidataid_q12396130 (
  "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/Q12396131 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12396131_wikidataid_q12396131
  • 59.21 kB
  • 7,925 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12396131_wikidataid_q12396131 (
  "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/Q12396139 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12396139_wikidataid_q12396139
  • 57.67 kB
  • 7,545 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12396139_wikidataid_q12396139 (
  "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/Q12396143 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12396143_wikidataid_q12396143
  • 59.89 kB
  • 7,925 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12396143_wikidataid_q12396143 (
  "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.