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

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

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

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

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

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

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

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

@datacommons.cities.wikidataid_q12395629_wikidataid_q12395629
  • 53.9 kB
  • 7,002 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12395629_wikidataid_q12395629 (
  "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/Q12395635 - Time Series For Statistical Variables

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

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

@datacommons.cities.wikidataid_q12395668_wikidataid_q12395668
  • 62.38 kB
  • 8,054 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12395668_wikidataid_q12395668 (
  "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/Q12395681 - Time Series For Statistical Variables

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

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

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

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

@datacommons.cities.wikidataid_q12395711_wikidataid_q12395711
  • 50.85 kB
  • 6,337 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12395711_wikidataid_q12395711 (
  "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/Q12395739 - Time Series For Statistical Variables

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

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

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

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

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

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

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

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

@datacommons.cities.wikidataid_q12395856_wikidataid_q12395856
  • 53.82 kB
  • 7,012 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12395856_wikidataid_q12395856 (
  "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.