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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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