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

Accord - Time Series For Statistical Variables

@datacommons.cities.accord_geoid_3600155
  • 2.86 MB
  • 342,459 rows
  • 12 columns
Loading... 

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

Accoville - Time Series For Statistical Variables

@datacommons.cities.accoville_geoid_5400196
  • 2.78 MB
  • 337,019 rows
  • 12 columns
Loading... 

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

Accoville - Time Series For Statistical Variables

@datacommons.cities.accoville_wikidataid_q4672816
  • 70.77 kB
  • 12,187 rows
  • 12 columns
Loading... 

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

Accra New Town - Time Series For Statistical Variables

@datacommons.cities.accra_new_town_wikidataid_q20644853
  • 40.58 kB
  • 4,878 rows
  • 12 columns
Loading... 

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

Accra - Time Series For Statistical Variables

@datacommons.cities.accra_wikidataid_q3761
  • 41.49 kB
  • 4,914 rows
  • 12 columns
Loading... 

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

Accrington - Time Series For Statistical Variables

@datacommons.cities.accrington_wikidataid_q1622949
  • 72.78 kB
  • 10,350 rows
  • 12 columns
Loading... 

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

Aceguá, Uruguay - Time Series For Statistical Variables

@datacommons.cities.acegu_uruguay_wikidataid_q2093378
  • 16.4 kB
  • 1,039 rows
  • 12 columns
Loading... 

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

Aceguá - Time Series For Statistical Variables

@datacommons.cities.acegu_wikidataid_q913259
  • 20.7 kB
  • 1,306 rows
  • 12 columns
Loading... 

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

Acehúche - Time Series For Statistical Variables

@datacommons.cities.aceh_che_wikidataid_q1613517
  • 43.11 kB
  • 5,046 rows
  • 12 columns
Loading... 

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

Aceitunas Comunidad - Time Series For Statistical Variables

@datacommons.cities.aceitunas_comunidad_geoid_7200186
  • 1.41 MB
  • 180,506 rows
  • 12 columns
Loading... 

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

Acequia - Time Series For Statistical Variables

@datacommons.cities.acequia_geoid_1600280
  • 2.84 MB
  • 342,411 rows
  • 12 columns
Loading... 

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

Acered - Time Series For Statistical Variables

@datacommons.cities.acered_wikidataid_q24016524
  • 53.1 kB
  • 7,334 rows
  • 12 columns
Loading... 

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

Achacachi - Time Series For Statistical Variables

@datacommons.cities.achacachi_wikidataid_q1553175
  • 9.53 kB
  • 2 rows
  • 12 columns
Loading... 

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

Achachi - Time Series For Statistical Variables

@datacommons.cities.achachi_wikidataid_q5870567
  • 21.33 kB
  • 1,710 rows
  • 12 columns
Loading... 

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

Achao - Time Series For Statistical Variables

@datacommons.cities.achao_wikidataid_q3740002
  • 18.81 kB
  • 1,488 rows
  • 12 columns
Loading... 

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

Achern - Time Series For Statistical Variables

@datacommons.cities.achern_wikidataid_q373824
  • 82.06 kB
  • 11,782 rows
  • 12 columns
Loading... 

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

Acheron - Time Series For Statistical Variables

@datacommons.cities.acheron_wikidataid_q2256228
  • 53.96 kB
  • 6,474 rows
  • 12 columns
Loading... 

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

Achille - Time Series For Statistical Variables

@datacommons.cities.achille_geoid_4000100
  • 2.89 MB
  • 344,337 rows
  • 12 columns
Loading... 

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

Achilles - Time Series For Statistical Variables

@datacommons.cities.achilles_geoid_2000150
  • 71.62 kB
  • 12,221 rows
  • 12 columns
Loading... 

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

Achilles Township - Time Series For Statistical Variables

@datacommons.cities.achilles_township_geoid_2000175
  • 72.02 kB
  • 12,249 rows
  • 12 columns
Loading... 

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

Achim - Time Series For Statistical Variables

@datacommons.cities.achim_wikidataid_q16143
  • 80.71 kB
  • 10,327 rows
  • 12 columns
Loading... 

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

Achinsk - Time Series For Statistical Variables

@datacommons.cities.achinsk_wikidataid_q104232
  • 79.87 kB
  • 10,667 rows
  • 12 columns
Loading... 

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

Achiras - Time Series For Statistical Variables

@datacommons.cities.achiras_wikidataid_q11904093
  • 36.09 kB
  • 3,597 rows
  • 12 columns
Loading... 

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

Achterbroek - Time Series For Statistical Variables

@datacommons.cities.achterbroek_wikidataid_q1958445
  • 71.97 kB
  • 9,461 rows
  • 12 columns
Loading... 

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

Ackerly - Time Series For Statistical Variables

@datacommons.cities.ackerly_geoid_4801108
  • 1.38 MB
  • 184,822 rows
  • 12 columns
Loading... 

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