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

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

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

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

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

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

@datacommons.cities.wikidataid_q12388671_wikidataid_q12388671
  • 51.12 kB
  • 6,162 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12388671_wikidataid_q12388671 (
  "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/Q12388679 - Time Series For Statistical Variables

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

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

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

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

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

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

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

@datacommons.cities.wikidataid_q12388710_wikidataid_q12388710
  • 55.02 kB
  • 7,116 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12388710_wikidataid_q12388710 (
  "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/Q12388726 - Time Series For Statistical Variables

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

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

@datacommons.cities.wikidataid_q12388735_wikidataid_q12388735
  • 43.1 kB
  • 5,224 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12388735_wikidataid_q12388735 (
  "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/Q12388754 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q12388783_wikidataid_q12388783
  • 58.25 kB
  • 7,117 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12388783_wikidataid_q12388783 (
  "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/Q12388808 - Time Series For Statistical Variables

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

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

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

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

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

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