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

@datacommons.cities.wikidataid_q2575209_wikidataid_q2575209
  • 47.8 kB
  • 5,795 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2575209_wikidataid_q2575209 (
  "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/Q25768133 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q25768133_wikidataid_q25768133
  • 39.67 kB
  • 5,567 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q25768133_wikidataid_q25768133 (
  "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/Q2582605 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2582605_wikidataid_q2582605
  • 46.43 kB
  • 5,643 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2582605_wikidataid_q2582605 (
  "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/Q2583188 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2583188_wikidataid_q2583188
  • 63.91 kB
  • 8,464 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2583188_wikidataid_q2583188 (
  "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/Q2589438 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2589438_wikidataid_q2589438
  • 48.23 kB
  • 5,649 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2589438_wikidataid_q2589438 (
  "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/Q2591798 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2591798_wikidataid_q2591798
  • 48.73 kB
  • 6,037 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2591798_wikidataid_q2591798 (
  "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/Q2592210 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2592210_wikidataid_q2592210
  • 49.8 kB
  • 6,158 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2592210_wikidataid_q2592210 (
  "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/Q2595097 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2595097_wikidataid_q2595097
  • 64.73 kB
  • 8,417 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2595097_wikidataid_q2595097 (
  "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/Q2617531 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2617531_wikidataid_q2617531
  • 69.45 kB
  • 10,169 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2617531_wikidataid_q2617531 (
  "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/Q2618569 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2618569_wikidataid_q2618569
  • 65.82 kB
  • 8,552 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2618569_wikidataid_q2618569 (
  "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/Q2618741 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2618741_wikidataid_q2618741
  • 63.62 kB
  • 8,352 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2618741_wikidataid_q2618741 (
  "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/Q2619476 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2619476_wikidataid_q2619476
  • 48.48 kB
  • 6,016 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2619476_wikidataid_q2619476 (
  "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/Q2632888 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2632888_wikidataid_q2632888
  • 49.9 kB
  • 5,781 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2632888_wikidataid_q2632888 (
  "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/Q2643862 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2643862_wikidataid_q2643862
  • 72.18 kB
  • 9,666 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2643862_wikidataid_q2643862 (
  "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/Q2657832 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2657832_wikidataid_q2657832
  • 50.12 kB
  • 6,016 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2657832_wikidataid_q2657832 (
  "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/Q2670443 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2670443_wikidataid_q2670443
  • 48.02 kB
  • 5,911 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2670443_wikidataid_q2670443 (
  "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/Q2678207 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2678207_wikidataid_q2678207
  • 63.33 kB
  • 8,345 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2678207_wikidataid_q2678207 (
  "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/Q2678782 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2678782_wikidataid_q2678782
  • 61.16 kB
  • 8,934 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2678782_wikidataid_q2678782 (
  "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/Q26806490 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q26806490_wikidataid_q26806490
  • 66.11 kB
  • 8,423 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q26806490_wikidataid_q26806490 (
  "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/Q2697255 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2697255_wikidataid_q2697255
  • 72.62 kB
  • 10,374 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2697255_wikidataid_q2697255 (
  "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/Q2698891 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2698891_wikidataid_q2698891
  • 52.97 kB
  • 6,612 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2698891_wikidataid_q2698891 (
  "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/Q2710406 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2710406_wikidataid_q2710406
  • 70.18 kB
  • 10,141 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2710406_wikidataid_q2710406 (
  "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/Q2717657 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2717657_wikidataid_q2717657
  • 50.02 kB
  • 5,970 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2717657_wikidataid_q2717657 (
  "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/Q27189578 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q27189578_wikidataid_q27189578
  • 52.7 kB
  • 7,141 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q27189578_wikidataid_q27189578 (
  "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/Q2747076 - Time Series For Statistical Variables

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