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

Antelope Township - Time Series For Statistical Variables

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

Antelope Valley-Crestview - Time Series For Statistical Variables

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

Antelope Valley Township - Time Series For Statistical Variables

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

Antelope - Time Series For Statistical Variables

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

Antequera - Time Series For Statistical Variables

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

Anthem - Time Series For Statistical Variables

@datacommons.cities.anthem_geoid_0402430
  • 3.27 MB
  • 357,579 rows
  • 12 columns
Loading...
CREATE TABLE anthem_geoid_0402430 (
  "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
);

Anthon - Time Series For Statistical Variables

@datacommons.cities.anthon_geoid_1902350
  • 3.01 MB
  • 351,287 rows
  • 12 columns
Loading...
CREATE TABLE anthon_geoid_1902350 (
  "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
);

Anthony - Time Series For Statistical Variables

@datacommons.cities.anthony_geoid_2001975
  • 3.05 MB
  • 353,848 rows
  • 12 columns
Loading...
CREATE TABLE anthony_geoid_2001975 (
  "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
);

Anthony - Time Series For Statistical Variables

@datacommons.cities.anthony_geoid_3503820
  • 3.18 MB
  • 357,679 rows
  • 12 columns
Loading...
CREATE TABLE anthony_geoid_3503820 (
  "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
);

Anthony - Time Series For Statistical Variables

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

Anthony - Time Series For Statistical Variables

@datacommons.cities.anthony_geoid_4803432
  • 3.15 MB
  • 357,299 rows
  • 12 columns
Loading...
CREATE TABLE anthony_geoid_4803432 (
  "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
);

Anthony Township - Time Series For Statistical Variables

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

Anthony Township - Time Series For Statistical Variables

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

Anthony Township - Time Series For Statistical Variables

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

Anthonyville - Time Series For Statistical Variables

@datacommons.cities.anthonyville_geoid_0501457
  • 1.38 MB
  • 185,564 rows
  • 12 columns
Loading...
CREATE TABLE anthonyville_geoid_0501457 (
  "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
);

Anthoston - Time Series For Statistical Variables

@datacommons.cities.anthoston_geoid_2101720
  • 2.63 MB
  • 299,389 rows
  • 12 columns
Loading...
CREATE TABLE anthoston_geoid_2101720 (
  "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
);

Anthoston, Kentucky - Time Series For Statistical Variables

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

Anthousa - Time Series For Statistical Variables

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

Antibes - Time Series For Statistical Variables

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

Antietam - Time Series For Statistical Variables

@datacommons.cities.antietam_geoid_2401750
  • 2.73 MB
  • 336,367 rows
  • 12 columns
Loading...
CREATE TABLE antietam_geoid_2401750 (
  "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
);

Antigo - Time Series For Statistical Variables

@datacommons.cities.antigo_geoid_5502250
  • 3.24 MB
  • 358,079 rows
  • 12 columns
Loading...
CREATE TABLE antigo_geoid_5502250 (
  "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
);

Antigo - Time Series For Statistical Variables

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

Antigonish - Time Series For Statistical Variables

@datacommons.cities.antigonish_wikidataid_q575483
  • 110.49 kB
  • 20,120 rows
  • 12 columns
Loading...
CREATE TABLE antigonish_wikidataid_q575483 (
  "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
);

Antigua Guatemala - Time Series For Statistical Variables

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

Antigua - Time Series For Statistical Variables

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

Share link

Anyone who has the link will be able to view this.