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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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