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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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