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

Afton - Time Series For Statistical Variables

@datacommons.cities.afton_geoid_5600245
  • 3.08 MB
  • 354,192 rows
  • 12 columns
Loading...

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

Afton Township - Time Series For Statistical Variables

@datacommons.cities.afton_township_geoid_1700386
  • 93.44 kB
  • 14,887 rows
  • 12 columns
Loading...

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

Afton Township - Time Series For Statistical Variables

@datacommons.cities.afton_township_geoid_1990021
  • 91.1 kB
  • 13,779 rows
  • 12 columns
Loading...

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

Afton Township - Time Series For Statistical Variables

@datacommons.cities.afton_township_geoid_1990024
  • 75.84 kB
  • 12,623 rows
  • 12 columns
Loading...

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

Afton Township - Time Series For Statistical Variables

@datacommons.cities.afton_township_geoid_2000425
  • 95.98 kB
  • 15,303 rows
  • 12 columns
Loading...

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

Afton Township - Time Series For Statistical Variables

@datacommons.cities.afton_township_geoid_3800740
  • 94.52 kB
  • 14,576 rows
  • 12 columns
Loading...

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

Afton Township - Time Series For Statistical Variables

@datacommons.cities.afton_township_geoid_4600380
  • 79.81 kB
  • 13,107 rows
  • 12 columns
Loading...

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

Afton Township - Time Series For Statistical Variables

@datacommons.cities.afton_township_geoid_4600420
  • 98.31 kB
  • 15,427 rows
  • 12 columns
Loading...

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

Afton Township - Time Series For Statistical Variables

@datacommons.cities.afton_township_wikidataid_q9035943
  • 63.52 kB
  • 11,676 rows
  • 12 columns
Loading...

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

Afton - Time Series For Statistical Variables

@datacommons.cities.afton_wikidataid_q1895518
  • 94.33 kB
  • 14,844 rows
  • 12 columns
Loading...

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

Afula - Time Series For Statistical Variables

@datacommons.cities.afula_wikidataid_q152462
  • 56.74 kB
  • 7,435 rows
  • 12 columns
Loading...

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

Afus - Time Series For Statistical Variables

@datacommons.cities.afus_wikidataid_q4365366
  • 9.38 kB
  • 1 row
  • 12 columns
Loading...

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

Afyonkarahisar - Time Series For Statistical Variables

@datacommons.cities.afyonkarahisar_wikidataid_q166824
  • 51.04 kB
  • 6,462 rows
  • 12 columns
Loading...

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

Agadir - Time Series For Statistical Variables

@datacommons.cities.agadir_wikidataid_q170525
  • 44.53 kB
  • 5,836 rows
  • 12 columns
Loading...

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

Agaete - Time Series For Statistical Variables

@datacommons.cities.agaete_wikidataid_q24013887
  • 42.13 kB
  • 5,590 rows
  • 12 columns
Loading...

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

Agano - Time Series For Statistical Variables

@datacommons.cities.agano_wikidataid_q390466
  • 58.93 kB
  • 7,503 rows
  • 12 columns
Loading...

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

Agara, Bangalore - Time Series For Statistical Variables

@datacommons.cities.agara_bangalore_wikidataid_q4691274
  • 61.13 kB
  • 7,161 rows
  • 12 columns
Loading...

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

Agarak - Time Series For Statistical Variables

@datacommons.cities.agarak_wikidataid_q1647453
  • 40.33 kB
  • 4,494 rows
  • 12 columns
Loading...

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

Agar - Time Series For Statistical Variables

@datacommons.cities.agar_geoid_4600460
  • 2.71 MB
  • 334,545 rows
  • 12 columns
Loading...

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

Agar, Madhya Pradesh - Time Series For Statistical Variables

@datacommons.cities.agar_madhya_pradesh_wikidataid_q28153702
  • 25.64 kB
  • 2,521 rows
  • 12 columns
Loading...

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

Agaro - Time Series For Statistical Variables

@datacommons.cities.agaro_wikidataid_q1110037
  • 40.07 kB
  • 4,877 rows
  • 12 columns
Loading...

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

Agartala - Time Series For Statistical Variables

@datacommons.cities.agartala_wikidataid_q170454
  • 60.32 kB
  • 7,550 rows
  • 12 columns
Loading...

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

Agassiz Township - Time Series For Statistical Variables

@datacommons.cities.agassiz_township_geoid_2700352
  • 75.69 kB
  • 12,368 rows
  • 12 columns
Loading...

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

Agawam - Time Series For Statistical Variables

@datacommons.cities.agawam_geoid_2500765
  • 101.52 kB
  • 16,020 rows
  • 12 columns
Loading...

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

Agawam Town - Time Series For Statistical Variables

@datacommons.cities.agawam_town_geoid_2500840
  • 3.44 MB
  • 365,053 rows
  • 12 columns
Loading...

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