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

@datacommons.cities.wikidataid_q2522802_wikidataid_q2522802
  • 64.2 kB
  • 8,492 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2522802_wikidataid_q2522802 (
  "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/Q2523542 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2523542_wikidataid_q2523542
  • 47.3 kB
  • 5,768 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2523542_wikidataid_q2523542 (
  "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/Q2524659 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q2525476_wikidataid_q2525476
  • 56.8 kB
  • 6,845 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2525476_wikidataid_q2525476 (
  "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/Q2526371 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2526371_wikidataid_q2526371
  • 46.83 kB
  • 5,694 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2526371_wikidataid_q2526371 (
  "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/Q2538030 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2538030_wikidataid_q2538030
  • 64.15 kB
  • 8,492 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2538030_wikidataid_q2538030 (
  "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/Q25397474 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q25397474_wikidataid_q25397474
  • 24.08 kB
  • 2,239 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q25397474_wikidataid_q25397474 (
  "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/Q25421574 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q25421574_wikidataid_q25421574
  • 66.11 kB
  • 9,380 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q25421574_wikidataid_q25421574 (
  "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/Q25423532 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q25424316_wikidataid_q25424316
  • 66.54 kB
  • 9,380 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q25424316_wikidataid_q25424316 (
  "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/Q25424331 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q25424331_wikidataid_q25424331
  • 37.17 kB
  • 4,615 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q25424331_wikidataid_q25424331 (
  "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/Q2542970 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2542970_wikidataid_q2542970
  • 73.14 kB
  • 10,336 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2542970_wikidataid_q2542970 (
  "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/Q25432815 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q25432815_wikidataid_q25432815
  • 33.42 kB
  • 3,948 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q25432815_wikidataid_q25432815 (
  "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/Q2547817 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2547817_wikidataid_q2547817
  • 49.7 kB
  • 6,097 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2547817_wikidataid_q2547817 (
  "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/Q2548002 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2548002_wikidataid_q2548002
  • 52.58 kB
  • 5,893 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2548002_wikidataid_q2548002 (
  "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/Q25510077 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q25510077_wikidataid_q25510077
  • 54.22 kB
  • 6,570 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q25510077_wikidataid_q25510077 (
  "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/Q25510853 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q2552249_wikidataid_q2552249
  • 63.16 kB
  • 8,279 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2552249_wikidataid_q2552249 (
  "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/Q25530748 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q25530748_wikidataid_q25530748
  • 110.39 kB
  • 15,884 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q25530748_wikidataid_q25530748 (
  "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/Q25530765 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q25530765_wikidataid_q25530765
  • 99.32 kB
  • 14,364 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q25530765_wikidataid_q25530765 (
  "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/Q2554189 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2554189_wikidataid_q2554189
  • 65.5 kB
  • 8,499 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2554189_wikidataid_q2554189 (
  "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/Q25591446 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q25591446_wikidataid_q25591446
  • 73.89 kB
  • 12,628 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q25591446_wikidataid_q25591446 (
  "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/Q25591451 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q25591451_wikidataid_q25591451
  • 95.13 kB
  • 15,239 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q25591451_wikidataid_q25591451 (
  "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/Q2566031 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2566031_wikidataid_q2566031
  • 50.8 kB
  • 6,229 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2566031_wikidataid_q2566031 (
  "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/Q2574391 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2574391_wikidataid_q2574391
  • 63.52 kB
  • 8,381 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2574391_wikidataid_q2574391 (
  "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.