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

@datacommons.cities.wikidataid_q8345396_wikidataid_q8345396
  • 43.73 kB
  • 4,948 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q8345396_wikidataid_q8345396 (
  "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/Q8346156 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q8346156_wikidataid_q8346156
  • 62.17 kB
  • 8,388 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q8346156_wikidataid_q8346156 (
  "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/Q8350973 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q8352758_wikidataid_q8352758
  • 16.06 kB
  • 931 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q8352758_wikidataid_q8352758 (
  "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/Q83630421 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q83630421_wikidataid_q83630421
  • 13.95 kB
  • 729 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q83630421_wikidataid_q83630421 (
  "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/Q83707606 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q8465587_wikidataid_q8465587
  • 57.09 kB
  • 6,895 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q8465587_wikidataid_q8465587 (
  "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/Q848502 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q848502_wikidataid_q848502
  • 81.41 kB
  • 11,527 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q848502_wikidataid_q848502 (
  "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/Q84869202 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q84907516_wikidataid_q84907516
  • 47.2 kB
  • 5,429 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q84907516_wikidataid_q84907516 (
  "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/Q84908318 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q84908318_wikidataid_q84908318
  • 46.34 kB
  • 5,429 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q84908318_wikidataid_q84908318 (
  "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/Q849154 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q849154_wikidataid_q849154
  • 49.1 kB
  • 6,069 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q849154_wikidataid_q849154 (
  "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/Q85117419 - Time Series For Statistical Variables

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

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

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

@datacommons.cities.wikidataid_q85602718_wikidataid_q85602718
  • 56.36 kB
  • 7,493 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q85602718_wikidataid_q85602718 (
  "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/Q85838037 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q85838037_wikidataid_q85838037
  • 58.69 kB
  • 7,493 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q85838037_wikidataid_q85838037 (
  "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/Q85838484 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q86100051_wikidataid_q86100051
  • 9.61 kB
  • 1 row
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q86100051_wikidataid_q86100051 (
  "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/Q86523548 - Time Series For Statistical Variables

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

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

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

@datacommons.cities.wikidataid_q86637_wikidataid_q86637
  • 62.09 kB
  • 8,388 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q86637_wikidataid_q86637 (
  "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/Q86896412 - Time Series For Statistical Variables

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

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