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

Artesian - Time Series For Statistical Variables

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

Artesia Township - Time Series For Statistical Variables

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

Arteta - Time Series For Statistical Variables

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

Arthuna - Time Series For Statistical Variables

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

Arthurdale - Time Series For Statistical Variables

@datacommons.cities.arthurdale_geoid_5402908
  • 1.05 MB
  • 65,342 rows
  • 12 columns
Loading... 
CREATE TABLE arthurdale_geoid_5402908 (
  "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
);

Arthur - Time Series For Statistical Variables

@datacommons.cities.arthur_geoid_1702414
  • 3.13 MB
  • 354,310 rows
  • 12 columns
Loading... 
CREATE TABLE arthur_geoid_1702414 (
  "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
);

Arthur - Time Series For Statistical Variables

@datacommons.cities.arthur_geoid_1802296
  • 806.02 kB
  • 38,884 rows
  • 12 columns
Loading... 
CREATE TABLE arthur_geoid_1802296 (
  "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
);

Arthur - Time Series For Statistical Variables

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

Arthur - Time Series For Statistical Variables

@datacommons.cities.arthur_geoid_3102200
  • 2.76 MB
  • 338,193 rows
  • 12 columns
Loading... 
CREATE TABLE arthur_geoid_3102200 (
  "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
);

Arthur - Time Series For Statistical Variables

@datacommons.cities.arthur_geoid_3803300
  • 2.96 MB
  • 348,171 rows
  • 12 columns
Loading... 
CREATE TABLE arthur_geoid_3803300 (
  "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
);

Arthur - Time Series For Statistical Variables

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

Arthur River - Time Series For Statistical Variables

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

Arthur River - Time Series For Statistical Variables

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

Arthurs Creek - Time Series For Statistical Variables

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

Arthurton - Time Series For Statistical Variables

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

Arthurtown - Time Series For Statistical Variables

@datacommons.cities.arthurtown_geoid_4502665
  • 1.12 MB
  • 68,161 rows
  • 12 columns
Loading... 
CREATE TABLE arthurtown_geoid_4502665 (
  "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
);

Arthur Township - Time Series For Statistical Variables

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

Arthur Township - Time Series For Statistical Variables

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

Arthur Township - Time Series For Statistical Variables

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

Arthur Township - Time Series For Statistical Variables

@datacommons.cities.arthur_township_geoid_3803340
  • 97.04 kB
  • 15,432 rows
  • 12 columns
Loading... 
CREATE TABLE arthur_township_geoid_3803340 (
  "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
);

Arthur Township - Time Series For Statistical Variables

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

Arth - Time Series For Statistical Variables

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

Artica - Time Series For Statistical Variables

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

Artichoke Township - Time Series For Statistical Variables

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

Artigas - Time Series For Statistical Variables

@datacommons.cities.artigas_wikidataid_q712567
  • 48.95 kB
  • 5,763 rows
  • 12 columns
Loading... 
CREATE TABLE artigas_wikidataid_q712567 (
  "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.