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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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