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

@datacommons.cities.wikidataid_q2819854_wikidataid_q2819854
  • 43.52 kB
  • 5,156 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2819854_wikidataid_q2819854 (
  "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/Q2819863 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2819863_wikidataid_q2819863
  • 54.57 kB
  • 7,081 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2819863_wikidataid_q2819863 (
  "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/Q2819865 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2819865_wikidataid_q2819865
  • 43.39 kB
  • 5,156 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2819865_wikidataid_q2819865 (
  "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/Q2828161 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2828161_wikidataid_q2828161
  • 50.72 kB
  • 6,336 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2828161_wikidataid_q2828161 (
  "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/Q2828723 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2828723_wikidataid_q2828723
  • 43.92 kB
  • 5,156 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2828723_wikidataid_q2828723 (
  "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/Q2829129 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2829129_wikidataid_q2829129
  • 51.59 kB
  • 6,675 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2829129_wikidataid_q2829129 (
  "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/Q2835510 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2835510_wikidataid_q2835510
  • 51.43 kB
  • 6,336 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2835510_wikidataid_q2835510 (
  "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/Q2836797 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2836797_wikidataid_q2836797
  • 94.85 kB
  • 15,091 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2836797_wikidataid_q2836797 (
  "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/Q2837365 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2837365_wikidataid_q2837365
  • 62.16 kB
  • 8,397 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2837365_wikidataid_q2837365 (
  "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/Q2837827 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2837827_wikidataid_q2837827
  • 92.46 kB
  • 15,127 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2837827_wikidataid_q2837827 (
  "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/Q2837977 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2837977_wikidataid_q2837977
  • 61.92 kB
  • 8,397 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2837977_wikidataid_q2837977 (
  "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/Q2843351 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q28483832_wikidataid_q28483832
  • 50.3 kB
  • 6,336 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q28483832_wikidataid_q28483832 (
  "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/Q2850267 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2850267_wikidataid_q2850267
  • 37.98 kB
  • 4,325 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2850267_wikidataid_q2850267 (
  "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/Q2857696 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2857696_wikidataid_q2857696
  • 50.19 kB
  • 6,336 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2857696_wikidataid_q2857696 (
  "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/Q2858082 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2858082_wikidataid_q2858082
  • 65.77 kB
  • 9,387 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2858082_wikidataid_q2858082 (
  "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/Q2859549 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2859549_wikidataid_q2859549
  • 62.41 kB
  • 8,397 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2859549_wikidataid_q2859549 (
  "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/Q2859643 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2859643_wikidataid_q2859643
  • 56.84 kB
  • 6,879 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2859643_wikidataid_q2859643 (
  "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/Q2861443 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2861443_wikidataid_q2861443
  • 52.98 kB
  • 6,717 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2861443_wikidataid_q2861443 (
  "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/Q2861604 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2861604_wikidataid_q2861604
  • 50.41 kB
  • 6,336 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2861604_wikidataid_q2861604 (
  "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/Q2863566 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q2863613_wikidataid_q2863613
  • 62.33 kB
  • 8,397 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2863613_wikidataid_q2863613 (
  "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/Q2864798 - Time Series For Statistical Variables

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

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

@datacommons.cities.wikidataid_q2866242_wikidataid_q2866242
  • 44.39 kB
  • 5,156 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2866242_wikidataid_q2866242 (
  "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.