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

Albany - Time Series For Statistical Variables

@datacommons.cities.albany_geoid_4101000
  • 3.54 MB
  • 366,833 rows
  • 12 columns
Loading... 

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

Albany - Time Series For Statistical Variables

@datacommons.cities.albany_geoid_4801648
  • 3.01 MB
  • 351,427 rows
  • 12 columns
Loading... 

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

Albany - Time Series For Statistical Variables

@datacommons.cities.albany_geoid_5000400
  • 2.8 MB
  • 340,826 rows
  • 12 columns
Loading... 

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

Albany - Time Series For Statistical Variables

@datacommons.cities.albany_geoid_5000475
  • 95.16 kB
  • 15,518 rows
  • 12 columns
Loading... 

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

Albany - Time Series For Statistical Variables

@datacommons.cities.albany_geoid_5500750
  • 3.03 MB
  • 354,435 rows
  • 12 columns
Loading... 

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

Albany - Time Series For Statistical Variables

@datacommons.cities.albany_geoid_5500775
  • 98.16 kB
  • 15,107 rows
  • 12 columns
Loading... 

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

Albany - Time Series For Statistical Variables

@datacommons.cities.albany_geoid_5500800
  • 94.2 kB
  • 15,072 rows
  • 12 columns
Loading... 

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

Albany - Time Series For Statistical Variables

@datacommons.cities.albany_geoid_5600680
  • 2.64 MB
  • 330,688 rows
  • 12 columns
Loading... 

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

Albany Township - Time Series For Statistical Variables

@datacommons.cities.albany_township_geoid_1700529
  • 97.7 kB
  • 15,328 rows
  • 12 columns
Loading... 

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

Albany Township - Time Series For Statistical Variables

@datacommons.cities.albany_township_geoid_2700640
  • 97.18 kB
  • 15,132 rows
  • 12 columns
Loading... 

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

Albany Township, Harlan County, Nebraska - Time Series For Statistical Variables

@datacommons.cities.albany_township_harlan_county_nebraska_wikidataid_q4709402
  • 77.95 kB
  • 12,904 rows
  • 12 columns
Loading... 

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

Albany Township - Time Series For Statistical Variables

@datacommons.cities.albany_township_wikidataid_q1894007
  • 70.09 kB
  • 11,946 rows
  • 12 columns
Loading... 

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

Albany Township - Time Series For Statistical Variables

@datacommons.cities.albany_township_wikidataid_q1894080
  • 95.59 kB
  • 15,195 rows
  • 12 columns
Loading... 

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

Albany Township - Time Series For Statistical Variables

@datacommons.cities.albany_township_wikidataid_q9035955
  • 61.49 kB
  • 11,592 rows
  • 12 columns
Loading... 

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

Albany - Time Series For Statistical Variables

@datacommons.cities.albany_wikidataid_q704257
  • 64.69 kB
  • 9,025 rows
  • 12 columns
Loading... 

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

Albarracín - Time Series For Statistical Variables

@datacommons.cities.albarrac_n_wikidataid_q24015194
  • 34.32 kB
  • 3,752 rows
  • 12 columns
Loading... 

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

Al Batha - Time Series For Statistical Variables

@datacommons.cities.al_batha_wikidataid_q12184507
  • 32.46 kB
  • 3,815 rows
  • 12 columns
Loading... 

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

Alba Township - Time Series For Statistical Variables

@datacommons.cities.alba_township_geoid_1700503
  • 85.31 kB
  • 13,506 rows
  • 12 columns
Loading... 

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

Alba Township - Time Series For Statistical Variables

@datacommons.cities.alba_township_geoid_2700604
  • 82.41 kB
  • 13,047 rows
  • 12 columns
Loading... 

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

Alba - Time Series For Statistical Variables

@datacommons.cities.alba_wikidataid_q24003518
  • 47.45 kB
  • 6,045 rows
  • 12 columns
Loading... 

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

Al Bayda' - Time Series For Statistical Variables

@datacommons.cities.al_bayda_wikidataid_q1752951
  • 10.79 kB
  • 162 rows
  • 12 columns
Loading... 

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

Al Bayda - Time Series For Statistical Variables

@datacommons.cities.al_bayda_wikidataid_q35784
  • 42.52 kB
  • 5,320 rows
  • 12 columns
Loading... 

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

Albbruck - Time Series For Statistical Variables

@datacommons.cities.albbruck_wikidataid_q522404
  • 86.84 kB
  • 11,978 rows
  • 12 columns
Loading... 

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

Albee - Time Series For Statistical Variables

@datacommons.cities.albee_geoid_4600620
  • 1.22 MB
  • 175,362 rows
  • 12 columns
Loading... 

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

Albee Township - Time Series For Statistical Variables

@datacommons.cities.albee_township_geoid_2600920
  • 98.03 kB
  • 15,510 rows
  • 12 columns
Loading... 

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