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

@datacommons.cities.wikidataid_q4446192_wikidataid_q4446192
  • 58.45 kB
  • 6,508 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q4446192_wikidataid_q4446192 (
  "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/Q4449159 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q4449159_wikidataid_q4449159
  • 44.23 kB
  • 6,047 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q4449159_wikidataid_q4449159 (
  "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/Q4460407 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q4460407_wikidataid_q4460407
  • 73.22 kB
  • 9,640 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q4460407_wikidataid_q4460407 (
  "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/Q4462226 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q4462226_wikidataid_q4462226
  • 50.56 kB
  • 6,020 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q4462226_wikidataid_q4462226 (
  "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/Q4496127 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q4496127_wikidataid_q4496127
  • 35.3 kB
  • 4,125 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q4496127_wikidataid_q4496127 (
  "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/Q4515627 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q4515627_wikidataid_q4515627
  • 49.75 kB
  • 5,971 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q4515627_wikidataid_q4515627 (
  "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/Q4520563 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q4520563_wikidataid_q4520563
  • 17.34 kB
  • 1,071 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q4520563_wikidataid_q4520563 (
  "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/Q4521360 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q4521360_wikidataid_q4521360
  • 42.08 kB
  • 5,311 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q4521360_wikidataid_q4521360 (
  "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/Q4522480 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q4522480_wikidataid_q4522480
  • 31.57 kB
  • 3,657 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q4522480_wikidataid_q4522480 (
  "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/Q45737082 - Time Series For Statistical Variables

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

WikidataId/Q45805838 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q45805838_wikidataid_q45805838
  • 56.58 kB
  • 7,492 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q45805838_wikidataid_q45805838 (
  "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/Q45921786 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q45921786_wikidataid_q45921786
  • 43.47 kB
  • 5,093 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q45921786_wikidataid_q45921786 (
  "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/Q4630252 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q4630252_wikidataid_q4630252
  • 82.11 kB
  • 11,673 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q4630252_wikidataid_q4630252 (
  "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/Q47045330 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q47045330_wikidataid_q47045330
  • 58.11 kB
  • 7,912 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q47045330_wikidataid_q47045330 (
  "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/Q47184118 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q47184118_wikidataid_q47184118
  • 66.59 kB
  • 9,398 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q47184118_wikidataid_q47184118 (
  "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/Q47529497 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q47529497_wikidataid_q47529497
  • 44.78 kB
  • 5,157 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q47529497_wikidataid_q47529497 (
  "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/Q476985 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q476985_wikidataid_q476985
  • 51.56 kB
  • 6,352 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q476985_wikidataid_q476985 (
  "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/Q4828952 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q4828952_wikidataid_q4828952
  • 72.29 kB
  • 10,414 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q4828952_wikidataid_q4828952 (
  "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/Q4890124 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q4890124_wikidataid_q4890124
  • 55.4 kB
  • 6,811 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q4890124_wikidataid_q4890124 (
  "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/Q48927711 - Time Series For Statistical Variables

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

WikidataId/Q48927724 - Time Series For Statistical Variables

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

WikidataId/Q48977819 - Time Series For Statistical Variables

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

WikidataId/Q48977826 - Time Series For Statistical Variables

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

WikidataId/Q48977831 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q48977831_wikidataid_q48977831
  • 56.69 kB
  • 7,494 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q48977831_wikidataid_q48977831 (
  "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/Q48977845 - Time Series For Statistical Variables

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

Share link

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