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

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

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

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

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

@datacommons.cities.wikidataid_q12401757_wikidataid_q12401757
  • 46.42 kB
  • 5,629 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12401757_wikidataid_q12401757 (
  "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/Q12401760 - Time Series For Statistical Variables

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

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

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

@datacommons.cities.wikidataid_q12401793_wikidataid_q12401793
  • 50.58 kB
  • 6,223 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12401793_wikidataid_q12401793 (
  "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/Q12401806 - Time Series For Statistical Variables

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

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

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

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

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

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

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

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

@datacommons.cities.wikidataid_q12401895_wikidataid_q12401895
  • 54.26 kB
  • 7,021 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12401895_wikidataid_q12401895 (
  "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/Q12401906 - Time Series For Statistical Variables

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

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

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

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

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

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

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