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

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

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

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

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

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

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

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

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

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

@datacommons.cities.wikidataid_q12392649_wikidataid_q12392649
  • 58.54 kB
  • 7,903 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12392649_wikidataid_q12392649 (
  "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/Q12392653 - Time Series For Statistical Variables

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

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

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

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

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

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

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

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

@datacommons.cities.wikidataid_q12393008_wikidataid_q12393008
  • 58.35 kB
  • 7,903 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12393008_wikidataid_q12393008 (
  "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/Q12393024 - Time Series For Statistical Variables

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

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

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

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

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

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