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

Anju - Time Series For Statistical Variables

@datacommons.cities.anju_wikidataid_q196236
  • 42.25 kB
  • 5,144 rows
  • 12 columns
Loading... 
CREATE TABLE anju_wikidataid_q196236 (
  "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
);

Anjō - Time Series For Statistical Variables

@datacommons.cities.anj_wikidataid_q270806
  • 68.54 kB
  • 8,485 rows
  • 12 columns
Loading... 
CREATE TABLE anj_wikidataid_q270806 (
  "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
);

Ankang - Time Series For Statistical Variables

@datacommons.cities.ankang_wikidataid_q515846
  • 4.76 MB
  • 556,377 rows
  • 12 columns
Loading... 
CREATE TABLE ankang_wikidataid_q515846 (
  "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
);

Ankaran - Time Series For Statistical Variables

@datacommons.cities.ankaran_wikidataid_q387789
  • 52.96 kB
  • 6,415 rows
  • 12 columns
Loading... 
CREATE TABLE ankaran_wikidataid_q387789 (
  "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
);

Ankara - Time Series For Statistical Variables

@datacommons.cities.ankara_wikidataid_q3640
  • 54.59 kB
  • 6,919 rows
  • 12 columns
Loading... 
CREATE TABLE ankara_wikidataid_q3640 (
  "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
);

Ankeny - Time Series For Statistical Variables

@datacommons.cities.ankeny_geoid_1902305
  • 3.51 MB
  • 364,725 rows
  • 12 columns
Loading... 
CREATE TABLE ankeny_geoid_1902305 (
  "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
);

Anklam - Time Series For Statistical Variables

@datacommons.cities.anklam_wikidataid_q488513
  • 81.91 kB
  • 11,368 rows
  • 12 columns
Loading... 
CREATE TABLE anklam_wikidataid_q488513 (
  "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
);

Anklav - Time Series For Statistical Variables

@datacommons.cities.anklav_wikidataid_q589067
  • 35.46 kB
  • 4,172 rows
  • 12 columns
Loading... 
CREATE TABLE anklav_wikidataid_q589067 (
  "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
);

Ankleshwar - Time Series For Statistical Variables

@datacommons.cities.ankleshwar_wikidataid_q588924
  • 57.42 kB
  • 7,671 rows
  • 12 columns
Loading... 
CREATE TABLE ankleshwar_wikidataid_q588924 (
  "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
);

Ankober - Time Series For Statistical Variables

@datacommons.cities.ankober_wikidataid_q557397
  • 9.51 kB
  • 2 rows
  • 12 columns
Loading... 
CREATE TABLE ankober_wikidataid_q557397 (
  "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
);

Anlu - Time Series For Statistical Variables

@datacommons.cities.anlu_wikidataid_q557934
  • 11.71 kB
  • 228 rows
  • 12 columns
Loading... 
CREATE TABLE anlu_wikidataid_q557934 (
  "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
);

Anmoore - Time Series For Statistical Variables

@datacommons.cities.anmoore_geoid_5401900
  • 2.87 MB
  • 342,255 rows
  • 12 columns
Loading... 
CREATE TABLE anmoore_geoid_5401900 (
  "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
);

Anmore - Time Series For Statistical Variables

@datacommons.cities.anmore_wikidataid_q557967
  • 108.11 kB
  • 14,779 rows
  • 12 columns
Loading... 
CREATE TABLE anmore_wikidataid_q557967 (
  "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
);

Annaba - Time Series For Statistical Variables

@datacommons.cities.annaba_wikidataid_q45942
  • 54.45 kB
  • 7,304 rows
  • 12 columns
Loading... 
CREATE TABLE annaba_wikidataid_q45942 (
  "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
);

Anna Bay - Time Series For Statistical Variables

@datacommons.cities.anna_bay_wikidataid_q4766841
  • 71.76 kB
  • 8,419 rows
  • 12 columns
Loading... 
CREATE TABLE anna_bay_wikidataid_q4766841 (
  "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
);

Annabella - Time Series For Statistical Variables

@datacommons.cities.annabella_geoid_4901750
  • 2.87 MB
  • 343,014 rows
  • 12 columns
Loading... 
CREATE TABLE annabella_geoid_4901750 (
  "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
);

Annaberg-Buchholz - Time Series For Statistical Variables

@datacommons.cities.annaberg_buchholz_wikidataid_q57944
  • 85.81 kB
  • 12,044 rows
  • 12 columns
Loading... 
CREATE TABLE annaberg_buchholz_wikidataid_q57944 (
  "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
);

An-Nabk - Time Series For Statistical Variables

@datacommons.cities.an_nabk_wikidataid_q2317068
  • 32.88 kB
  • 4,128 rows
  • 12 columns
Loading... 
CREATE TABLE an_nabk_wikidataid_q2317068 (
  "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
);

Annaburg - Time Series For Statistical Variables

@datacommons.cities.annaburg_wikidataid_q490413
  • 72.99 kB
  • 9,583 rows
  • 12 columns
Loading... 
CREATE TABLE annaburg_wikidataid_q490413 (
  "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
);

Annada - Time Series For Statistical Variables

@datacommons.cities.annada_geoid_2901252
  • 2.67 MB
  • 334,499 rows
  • 12 columns
Loading... 
CREATE TABLE annada_geoid_2901252 (
  "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
);

Anna - Time Series For Statistical Variables

@datacommons.cities.anna_geoid_1701543
  • 3.13 MB
  • 353,984 rows
  • 12 columns
Loading... 
CREATE TABLE anna_geoid_1701543 (
  "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
);

Anna - Time Series For Statistical Variables

@datacommons.cities.anna_geoid_3902092
  • 3.02 MB
  • 352,579 rows
  • 12 columns
Loading... 
CREATE TABLE anna_geoid_3902092 (
  "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
);

Anna - Time Series For Statistical Variables

@datacommons.cities.anna_geoid_4803300
  • 3.2 MB
  • 354,548 rows
  • 12 columns
Loading... 
CREATE TABLE anna_geoid_4803300 (
  "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
);

Annaka - Time Series For Statistical Variables

@datacommons.cities.annaka_wikidataid_q564234
  • 61.81 kB
  • 7,703 rows
  • 12 columns
Loading... 
CREATE TABLE annaka_wikidataid_q564234 (
  "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
);

Anna Maria - Time Series For Statistical Variables

@datacommons.cities.anna_maria_geoid_1201475
  • 2.92 MB
  • 346,798 rows
  • 12 columns
Loading... 
CREATE TABLE anna_maria_geoid_1201475 (
  "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.