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

Abdanan - Time Series For Statistical Variables

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

Abdan - Time Series For Statistical Variables

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

Abdet - Time Series For Statistical Variables

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

Abádszalók - Time Series For Statistical Variables

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

Abdulino - Time Series For Statistical Variables

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

Abel - Time Series For Statistical Variables

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

Abellar - Time Series For Statistical Variables

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

Abena - Time Series For Statistical Variables

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

Abenberg - Time Series For Statistical Variables

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

Abengourou - Time Series For Statistical Variables

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

Abenójar - Time Series For Statistical Variables

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

Abensberg - Time Series For Statistical Variables

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

Abeokuta - Time Series For Statistical Variables

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

Aberaeron - Time Series For Statistical Variables

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

Aberavon - Time Series For Statistical Variables

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

Aberbargoed - Time Series For Statistical Variables

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

Abercarn - Time Series For Statistical Variables

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

Abercorn - Time Series For Statistical Variables

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

Abercorn - Time Series For Statistical Variables

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

Abercrombie - Time Series For Statistical Variables

@datacommons.cities.abercrombie_geoid_3800100
  • 2.81 MB
  • 341,290 rows
  • 12 columns
Loading... 
CREATE TABLE abercrombie_geoid_3800100 (
  "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
);

Abercrombie Township - Time Series For Statistical Variables

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

Abercwmboi - Time Series For Statistical Variables

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

Aberdare - Time Series For Statistical Variables

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

Aberdeen Gardens - Time Series For Statistical Variables

@datacommons.cities.aberdeen_gardens_geoid_5300135
  • 2.79 MB
  • 339,754 rows
  • 12 columns
Loading... 
CREATE TABLE aberdeen_gardens_geoid_5300135 (
  "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
);

Aberdeen - Time Series For Statistical Variables

@datacommons.cities.aberdeen_geoid_1600100
  • 3.13 MB
  • 357,271 rows
  • 12 columns
Loading... 
CREATE TABLE aberdeen_geoid_1600100 (
  "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.