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

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

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

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

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

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

@datacommons.cities.wikidataid_q6166074_wikidataid_q6166074
  • 92.27 kB
  • 15,375 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6166074_wikidataid_q6166074 (
  "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/Q61678399 - Time Series For Statistical Variables

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

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

@datacommons.cities.wikidataid_q61695724_wikidataid_q61695724
  • 31.35 kB
  • 3,318 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q61695724_wikidataid_q61695724 (
  "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/Q6171878 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6171878_wikidataid_q6171878
  • 60.96 kB
  • 7,236 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6171878_wikidataid_q6171878 (
  "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/Q6173797 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6173797_wikidataid_q6173797
  • 36.52 kB
  • 4,356 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6173797_wikidataid_q6173797 (
  "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/Q61907872 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q619594_wikidataid_q619594
  • 35.15 kB
  • 3,941 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q619594_wikidataid_q619594 (
  "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/Q61978879 - Time Series For Statistical Variables

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

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

@datacommons.cities.wikidataid_q61992039_wikidataid_q61992039
  • 60.27 kB
  • 10,108 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q61992039_wikidataid_q61992039 (
  "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/Q61995706 - Time Series For Statistical Variables

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

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

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

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

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

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

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

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

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