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

Adrian - Time Series For Statistical Variables

@datacommons.cities.adrian_geoid_5400460
  • 957.59 kB
  • 64,208 rows
  • 12 columns
Loading... 

CREATE TABLE adrian_geoid_5400460 (
  "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
);

Adrian - Time Series For Statistical Variables

@datacommons.cities.adrian_geoid_5500475
  • 91.08 kB
  • 14,155 rows
  • 12 columns
Loading... 

CREATE TABLE adrian_geoid_5500475 (
  "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
);

Adrian Township - Time Series For Statistical Variables

@datacommons.cities.adrian_township_geoid_2000350
  • 94.53 kB
  • 14,935 rows
  • 12 columns
Loading... 

CREATE TABLE adrian_township_geoid_2000350 (
  "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
);

Adrian Township - Time Series For Statistical Variables

@datacommons.cities.adrian_township_geoid_2700280
  • 75.79 kB
  • 12,227 rows
  • 12 columns
Loading... 

CREATE TABLE adrian_township_geoid_2700280 (
  "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
);

Adrian Township - Time Series For Statistical Variables

@datacommons.cities.adrian_township_geoid_3800660
  • 90.35 kB
  • 14,487 rows
  • 12 columns
Loading... 

CREATE TABLE adrian_township_geoid_3800660 (
  "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
);

Adrian Township - Time Series For Statistical Variables

@datacommons.cities.adrian_township_geoid_4600340
  • 70.88 kB
  • 12,074 rows
  • 12 columns
Loading... 

CREATE TABLE adrian_township_geoid_4600340 (
  "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
);

Adrogué - Time Series For Statistical Variables

@datacommons.cities.adrogu_wikidataid_q749623
  • 57.81 kB
  • 7,124 rows
  • 12 columns
Loading... 

CREATE TABLE adrogu_wikidataid_q749623 (
  "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
);

Adré - Time Series For Statistical Variables

@datacommons.cities.adr_wikidataid_q2570307
  • 22.42 kB
  • 2,254 rows
  • 12 columns
Loading... 

CREATE TABLE adr_wikidataid_q2570307 (
  "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
);

Ad Salices - Time Series For Statistical Variables

@datacommons.cities.ad_salices_wikidataid_q11904142
  • 52.23 kB
  • 6,160 rows
  • 12 columns
Loading... 

CREATE TABLE ad_salices_wikidataid_q11904142 (
  "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
);

Adulis - Time Series For Statistical Variables

@datacommons.cities.adulis_wikidataid_q378940
  • 21.73 kB
  • 2,154 rows
  • 12 columns
Loading... 

CREATE TABLE adulis_wikidataid_q378940 (
  "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
);

Adutiškis - Time Series For Statistical Variables

@datacommons.cities.aduti_kis_wikidataid_q2509638
  • 55.74 kB
  • 7,042 rows
  • 12 columns
Loading... 

CREATE TABLE aduti_kis_wikidataid_q2509638 (
  "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
);

Advance - Time Series For Statistical Variables

@datacommons.cities.advance_geoid_1800640
  • 2.9 MB
  • 346,142 rows
  • 12 columns
Loading... 

CREATE TABLE advance_geoid_1800640 (
  "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
);

Advance - Time Series For Statistical Variables

@datacommons.cities.advance_geoid_2600480
  • 2.81 MB
  • 341,353 rows
  • 12 columns
Loading... 

CREATE TABLE advance_geoid_2600480 (
  "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
);

Advance - Time Series For Statistical Variables

@datacommons.cities.advance_geoid_2900262
  • 3.01 MB
  • 352,621 rows
  • 12 columns
Loading... 

CREATE TABLE advance_geoid_2900262 (
  "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
);

Advance - Time Series For Statistical Variables

@datacommons.cities.advance_geoid_3700440
  • 2.91 MB
  • 342,609 rows
  • 12 columns
Loading... 

CREATE TABLE advance_geoid_3700440 (
  "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
);

Advance Township - Time Series For Statistical Variables

@datacommons.cities.advance_township_geoid_3800700
  • 84.36 kB
  • 13,474 rows
  • 12 columns
Loading... 

CREATE TABLE advance_township_geoid_3800700 (
  "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
);

Advance - Time Series For Statistical Variables

@datacommons.cities.advance_wikidataid_q2513068
  • 97.74 kB
  • 15,740 rows
  • 12 columns
Loading... 

CREATE TABLE advance_wikidataid_q2513068 (
  "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
);

Adventure Bay - Time Series For Statistical Variables

@datacommons.cities.adventure_bay_wikidataid_q2184923
  • 64.99 kB
  • 8,154 rows
  • 12 columns
Loading... 

CREATE TABLE adventure_bay_wikidataid_q2184923 (
  "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
);

Adwolf - Time Series For Statistical Variables

@datacommons.cities.adwolf_geoid_5100468
  • 2.88 MB
  • 341,633 rows
  • 12 columns
Loading... 

CREATE TABLE adwolf_geoid_5100468 (
  "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
);

Adıyaman - Time Series For Statistical Variables

@datacommons.cities.ad_yaman_wikidataid_q168197
  • 20.64 kB
  • 1,536 rows
  • 12 columns
Loading... 

CREATE TABLE ad_yaman_wikidataid_q168197 (
  "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
);

Adygeysk - Time Series For Statistical Variables

@datacommons.cities.adygeysk_wikidataid_q102521
  • 69.6 kB
  • 8,974 rows
  • 12 columns
Loading... 

CREATE TABLE adygeysk_wikidataid_q102521 (
  "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
);

Adzopé - Time Series For Statistical Variables

@datacommons.cities.adzop_wikidataid_q1270691
  • 9.41 kB
  • 1 row
  • 12 columns
Loading... 

CREATE TABLE adzop_wikidataid_q1270691 (
  "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
);

Aegina - Time Series For Statistical Variables

@datacommons.cities.aegina_wikidataid_q3720429
  • 51.59 kB
  • 6,546 rows
  • 12 columns
Loading... 

CREATE TABLE aegina_wikidataid_q3720429 (
  "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
);

Aeginio - Time Series For Statistical Variables

@datacommons.cities.aeginio_wikidataid_q3564053
  • 47.51 kB
  • 5,802 rows
  • 12 columns
Loading... 

CREATE TABLE aeginio_wikidataid_q3564053 (
  "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
);

Aegys - Time Series For Statistical Variables

@datacommons.cities.aegys_wikidataid_q15872679
  • 47.51 kB
  • 5,858 rows
  • 12 columns
Loading... 

CREATE TABLE aegys_wikidataid_q15872679 (
  "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.