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

Ancona - Time Series For Statistical Variables

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

Ancram - Time Series For Statistical Variables

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

Ancuabe - Time Series For Statistical Variables

@datacommons.cities.ancuabe_wikidataid_q3236564
  • 9.4 kB
  • 1 row
  • 12 columns
Loading... 
CREATE TABLE ancuabe_wikidataid_q3236564 (
  "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
);

Ancud - Time Series For Statistical Variables

@datacommons.cities.ancud_wikidataid_q3597
  • 17.19 kB
  • 1,117 rows
  • 12 columns
Loading... 
CREATE TABLE ancud_wikidataid_q3597 (
  "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
);

Andahuaylas - Time Series For Statistical Variables

@datacommons.cities.andahuaylas_wikidataid_q489660
  • 28.48 kB
  • 3,121 rows
  • 12 columns
Loading... 
CREATE TABLE andahuaylas_wikidataid_q489660 (
  "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
);

Andale - Time Series For Statistical Variables

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

Andalgalá - Time Series For Statistical Variables

@datacommons.cities.andalgal_wikidataid_q489679
  • 9.41 kB
  • 1 row
  • 12 columns
Loading... 
CREATE TABLE andalgal_wikidataid_q489679 (
  "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
);

Andalusia - Time Series For Statistical Variables

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

Andalusia - Time Series For Statistical Variables

@datacommons.cities.andalusia_geoid_1701426
  • 2.98 MB
  • 347,471 rows
  • 12 columns
Loading... 
CREATE TABLE andalusia_geoid_1701426 (
  "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
);

Andalusia Township - Time Series For Statistical Variables

@datacommons.cities.andalusia_township_geoid_1701439
  • 96.56 kB
  • 15,331 rows
  • 12 columns
Loading... 
CREATE TABLE andalusia_township_geoid_1701439 (
  "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
);

Andamooka - Time Series For Statistical Variables

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

Anda - Time Series For Statistical Variables

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

Andenne - Time Series For Statistical Variables

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

Anderlecht - Time Series For Statistical Variables

@datacommons.cities.anderlecht_wikidataid_q12886
  • 76.42 kB
  • 10,870 rows
  • 12 columns
Loading... 
CREATE TABLE anderlecht_wikidataid_q12886 (
  "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
);

Andernach - Time Series For Statistical Variables

@datacommons.cities.andernach_wikidataid_q490058
  • 65.35 kB
  • 8,349 rows
  • 12 columns
Loading... 
CREATE TABLE andernach_wikidataid_q490058 (
  "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 Der Schmücke - Time Series For Statistical Variables

@datacommons.cities.an_der_schm_cke_wikidataid_q59775092
  • 73.81 kB
  • 10,129 rows
  • 12 columns
Loading... 
CREATE TABLE an_der_schm_cke_wikidataid_q59775092 (
  "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
);

Anderson Creek - Time Series For Statistical Variables

@datacommons.cities.anderson_creek_geoid_3701340
  • 1.19 MB
  • 69,804 rows
  • 12 columns
Loading... 
CREATE TABLE anderson_creek_geoid_3701340 (
  "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
);

Anderson Creek Township - Time Series For Statistical Variables

@datacommons.cities.anderson_creek_township_wikidataid_q4754056
  • 91.5 kB
  • 15,059 rows
  • 12 columns
Loading... 
CREATE TABLE anderson_creek_township_wikidataid_q4754056 (
  "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
);

Anderson East Township - Time Series For Statistical Variables

@datacommons.cities.anderson_east_township_geoid_2901236
  • 83.64 kB
  • 13,702 rows
  • 12 columns
Loading... 
CREATE TABLE anderson_east_township_geoid_2901236 (
  "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
);

Anderson - Time Series For Statistical Variables

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

Anderson - Time Series For Statistical Variables

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

Anderson - Time Series For Statistical Variables

@datacommons.cities.anderson_geoid_0203220
  • 1.42 MB
  • 184,849 rows
  • 12 columns
Loading... 
CREATE TABLE anderson_geoid_0203220 (
  "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
);

Anderson - Time Series For Statistical Variables

@datacommons.cities.anderson_geoid_0602042
  • 3.3 MB
  • 358,769 rows
  • 12 columns
Loading... 
CREATE TABLE anderson_geoid_0602042 (
  "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
);

Anderson - Time Series For Statistical Variables

@datacommons.cities.anderson_geoid_1801468
  • 3.52 MB
  • 365,074 rows
  • 12 columns
Loading... 
CREATE TABLE anderson_geoid_1801468 (
  "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
);

Anderson - Time Series For Statistical Variables

@datacommons.cities.anderson_geoid_1902035
  • 2.66 MB
  • 330,569 rows
  • 12 columns
Loading... 
CREATE TABLE anderson_geoid_1902035 (
  "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.