Baselight

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

Adelphi - Time Series For Statistical Variables

@datacommons.cities.adelphi_wikidataid_q15667476
  • 41.52 kB
  • 4,920 rows
  • 12 columns
Loading...

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

Adelphi - Time Series For Statistical Variables

@datacommons.cities.adelphi_wikidataid_q4682057
  • 82.28 kB
  • 13,845 rows
  • 12 columns
Loading...

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

Adelsheim - Time Series For Statistical Variables

@datacommons.cities.adelsheim_wikidataid_q355435
  • 78.55 kB
  • 10,331 rows
  • 12 columns
Loading...

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

Adel Township - Time Series For Statistical Variables

@datacommons.cities.adel_township_geoid_1990018
  • 100.7 kB
  • 15,224 rows
  • 12 columns
Loading...

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

Adena - Time Series For Statistical Variables

@datacommons.cities.adena_geoid_3900464
  • 2.91 MB
  • 344,272 rows
  • 12 columns
Loading...

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

Adenau - Time Series For Statistical Variables

@datacommons.cities.adenau_wikidataid_q183485
  • 79.61 kB
  • 10,920 rows
  • 12 columns
Loading...

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

Adendorp - Time Series For Statistical Variables

@datacommons.cities.adendorp_wikidataid_q11051321
  • 48.63 kB
  • 5,707 rows
  • 12 columns
Loading...

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

Adendro - Time Series For Statistical Variables

@datacommons.cities.adendro_wikidataid_q3566838
  • 48.98 kB
  • 5,884 rows
  • 12 columns
Loading...

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

Adenta - Time Series For Statistical Variables

@datacommons.cities.adenta_wikidataid_q4682309
  • 40.93 kB
  • 4,898 rows
  • 12 columns
Loading...

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

Adet - Time Series For Statistical Variables

@datacommons.cities.adet_wikidataid_q2824323
  • 38.48 kB
  • 4,659 rows
  • 12 columns
Loading...

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

Adger - Time Series For Statistical Variables

@datacommons.cities.adger_geoid_0100508
  • 89.75 kB
  • 14,783 rows
  • 12 columns
Loading...

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

Adhartal - Time Series For Statistical Variables

@datacommons.cities.adhartal_wikidataid_q24951803
  • 59.48 kB
  • 7,687 rows
  • 12 columns
Loading...

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

Adigrat - Time Series For Statistical Variables

@datacommons.cities.adigrat_wikidataid_q357101
  • 9.46 kB
  • 1 row
  • 12 columns
Loading...

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

Adi Gudem - Time Series For Statistical Variables

@datacommons.cities.adi_gudem_wikidataid_q18350230
  • 30.47 kB
  • 3,657 rows
  • 12 columns
Loading...

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

Adi Keyh - Time Series For Statistical Variables

@datacommons.cities.adi_keyh_wikidataid_q356811
  • 10.58 kB
  • 120 rows
  • 12 columns
Loading...

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

Adilabad - Time Series For Statistical Variables

@datacommons.cities.adilabad_wikidataid_q494281
  • 24.76 kB
  • 2,533 rows
  • 12 columns
Loading...

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

Adi Mehameday - Time Series For Statistical Variables

@datacommons.cities.adi_mehameday_wikidataid_q20982405
  • 30.57 kB
  • 3,658 rows
  • 12 columns
Loading...

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

Adimi - Time Series For Statistical Variables

@datacommons.cities.adimi_wikidataid_q2422726
  • 34.61 kB
  • 4,235 rows
  • 12 columns
Loading...

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

Adin - Time Series For Statistical Variables

@datacommons.cities.adin_geoid_0600310
  • 2.74 MB
  • 336,079 rows
  • 12 columns
Loading...

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

Adipur - Time Series For Statistical Variables

@datacommons.cities.adipur_wikidataid_q4682951
  • 60.74 kB
  • 7,641 rows
  • 12 columns
Loading...

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

Adi Quala - Time Series For Statistical Variables

@datacommons.cities.adi_quala_wikidataid_q356816
  • 10.36 kB
  • 64 rows
  • 12 columns
Loading...

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

Adityapur - Time Series For Statistical Variables

@datacommons.cities.adityapur_wikidataid_q490645
  • 66.22 kB
  • 7,450 rows
  • 12 columns
Loading...

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

Adjala–Tosorontio - Time Series For Statistical Variables

@datacommons.cities.adjala_tosorontio_wikidataid_q4116597
  • 9.46 kB
  • 1 row
  • 12 columns
Loading...

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

Adjungbilly - Time Series For Statistical Variables

@datacommons.cities.adjungbilly_wikidataid_q963672
  • 48.14 kB
  • 5,883 rows
  • 12 columns
Loading...

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

Adjuntas Zona Urbana - Time Series For Statistical Variables

@datacommons.cities.adjuntas_zona_urbana_geoid_7200358
  • 1.59 MB
  • 191,096 rows
  • 12 columns
Loading...

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