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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

@datacommons.cities.wikidataid_q20548102_wikidataid_q20548102
  • 58.06 kB
  • 7,903 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20548102_wikidataid_q20548102 (
  "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/Q20548155 - Time Series For Statistical Variables

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

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

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

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

@datacommons.cities.wikidataid_q20548234_wikidataid_q20548234
  • 46.41 kB
  • 5,964 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20548234_wikidataid_q20548234 (
  "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/Q20548241 - Time Series For Statistical Variables

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