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

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

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

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

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

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

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

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

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

@datacommons.cities.wikidataid_q49130570_wikidataid_q49130570
  • 9.61 kB
  • 2 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q49130570_wikidataid_q49130570 (
  "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/Q49130630 - Time Series For Statistical Variables

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

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

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

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

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

@datacommons.cities.wikidataid_q49278237_wikidataid_q49278237
  • 79.8 kB
  • 10,996 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q49278237_wikidataid_q49278237 (
  "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/Q49279284 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q49279284_wikidataid_q49279284
  • 37.58 kB
  • 4,297 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q49279284_wikidataid_q49279284 (
  "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/Q49291021 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q49291021_wikidataid_q49291021
  • 40.52 kB
  • 4,838 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q49291021_wikidataid_q49291021 (
  "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/Q49755148 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q49755148_wikidataid_q49755148
  • 76.86 kB
  • 10,163 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q49755148_wikidataid_q49755148 (
  "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/Q50293544 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q50293544_wikidataid_q50293544
  • 47.17 kB
  • 5,493 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q50293544_wikidataid_q50293544 (
  "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/Q50331103 - Time Series For Statistical Variables

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

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

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

@datacommons.cities.wikidataid_q53314634_wikidataid_q53314634
  • 63.03 kB
  • 7,557 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q53314634_wikidataid_q53314634 (
  "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/Q538366 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q538366_wikidataid_q538366
  • 73.17 kB
  • 10,405 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q538366_wikidataid_q538366 (
  "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/Q5391007 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q5391007_wikidataid_q5391007
  • 72.22 kB
  • 12,570 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5391007_wikidataid_q5391007 (
  "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.