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

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

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

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

@datacommons.cities.wikidataid_q12401995_wikidataid_q12401995
  • 43.41 kB
  • 5,156 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12401995_wikidataid_q12401995 (
  "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/Q12401999 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q12402004_wikidataid_q12402004
  • 52.32 kB
  • 6,506 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12402004_wikidataid_q12402004 (
  "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/Q12402008 - Time Series For Statistical Variables

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

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

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

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

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

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

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

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

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

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

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

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

@datacommons.cities.wikidataid_q12402058_wikidataid_q12402058
  • 43.26 kB
  • 5,224 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12402058_wikidataid_q12402058 (
  "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/Q12402088 - Time Series For Statistical Variables

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

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

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

@datacommons.cities.wikidataid_q12402117_wikidataid_q12402117
  • 45.78 kB
  • 5,629 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12402117_wikidataid_q12402117 (
  "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/Q12402118 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q12402123_wikidataid_q12402123
  • 42.88 kB
  • 5,092 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12402123_wikidataid_q12402123 (
  "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.