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

Ascot - Time Series For Statistical Variables

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

Ascot - Time Series For Statistical Variables

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

Ascra - Time Series For Statistical Variables

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

Ascutney - Time Series For Statistical Variables

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

Asemanabad - Time Series For Statistical Variables

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

Asenovgrad - Time Series For Statistical Variables

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

Aserrí - Time Series For Statistical Variables

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

Asgaran - Time Series For Statistical Variables

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

Asgharabad, Isfahan - Time Series For Statistical Variables

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

Asgharabad - Time Series For Statistical Variables

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

Asharoken - Time Series For Statistical Variables

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

Ashaway - Time Series For Statistical Variables

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

Asha - Time Series For Statistical Variables

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

Ashbourne - Time Series For Statistical Variables

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

Ashbourne - Time Series For Statistical Variables

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

Ashburn - Time Series For Statistical Variables

@datacommons.cities.ashburn_geoid_1303236
  • 3.07 MB
  • 349,149 rows
  • 12 columns
Loading... 
CREATE TABLE ashburn_geoid_1303236 (
  "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
);

Ashburn - Time Series For Statistical Variables

@datacommons.cities.ashburn_geoid_2902152
  • 2.59 MB
  • 325,504 rows
  • 12 columns
Loading... 
CREATE TABLE ashburn_geoid_2902152 (
  "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
);

Ashburn - Time Series For Statistical Variables

@datacommons.cities.ashburn_geoid_5103320
  • 3.58 MB
  • 369,206 rows
  • 12 columns
Loading... 
CREATE TABLE ashburn_geoid_5103320 (
  "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
);

Ashburnham - Time Series For Statistical Variables

@datacommons.cities.ashburnham_geoid_2501885
  • 110.88 kB
  • 17,159 rows
  • 12 columns
Loading... 
CREATE TABLE ashburnham_geoid_2501885 (
  "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
);

Ashburton, KwaZulu-Natal - Time Series For Statistical Variables

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

Ashburton - Time Series For Statistical Variables

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

Ashburton - Time Series For Statistical Variables

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

Ashby-de-la-Zouch - Time Series For Statistical Variables

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

Ashby - Time Series For Statistical Variables

@datacommons.cities.ashby_geoid_2501955
  • 108.56 kB
  • 17,404 rows
  • 12 columns
Loading... 
CREATE TABLE ashby_geoid_2501955 (
  "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
);

Ashby - Time Series For Statistical Variables

@datacommons.cities.ashby_geoid_2702422
  • 2.99 MB
  • 353,041 rows
  • 12 columns
Loading... 
CREATE TABLE ashby_geoid_2702422 (
  "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.