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

Alexander Creek, Alaska - Time Series For Statistical Variables

@datacommons.cities.alexander_creek_alaska_geoid_0201655
  • 89.89 kB
  • 12,738 rows
  • 12 columns
Loading...

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

Alexander - Time Series For Statistical Variables

@datacommons.cities.alexander_geoid_0500580
  • 3.02 MB
  • 348,343 rows
  • 12 columns
Loading...

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

Alexander - Time Series For Statistical Variables

@datacommons.cities.alexander_geoid_1700659
  • 1.01 MB
  • 65,354 rows
  • 12 columns
Loading...

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

Alexander - Time Series For Statistical Variables

@datacommons.cities.alexander_geoid_1901090
  • 2.84 MB
  • 343,392 rows
  • 12 columns
Loading...

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

Alexander - Time Series For Statistical Variables

@datacommons.cities.alexander_geoid_2001050
  • 2.73 MB
  • 336,460 rows
  • 12 columns
Loading...

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

Alexander - Time Series For Statistical Variables

@datacommons.cities.alexander_geoid_2300660
  • 86.61 kB
  • 15,030 rows
  • 12 columns
Loading...

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

Alexander - Time Series For Statistical Variables

@datacommons.cities.alexander_geoid_3601154
  • 2.98 MB
  • 351,047 rows
  • 12 columns
Loading...

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

Alexander - Time Series For Statistical Variables

@datacommons.cities.alexander_geoid_3801180
  • 2.83 MB
  • 342,439 rows
  • 12 columns
Loading...

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

Alexander Township - Time Series For Statistical Variables

@datacommons.cities.alexander_township_geoid_2900586
  • 70.64 kB
  • 12,150 rows
  • 12 columns
Loading...

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

Alexander Township - Time Series For Statistical Variables

@datacommons.cities.alexander_township_geoid_3801260
  • 91.15 kB
  • 14,450 rows
  • 12 columns
Loading...

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

Alexander Township - Time Series For Statistical Variables

@datacommons.cities.alexander_township_geoid_3901112
  • 72.26 kB
  • 12,482 rows
  • 12 columns
Loading...

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

Alexander - Time Series For Statistical Variables

@datacommons.cities.alexander_wikidataid_q4718118
  • 108.43 kB
  • 15,679 rows
  • 12 columns
Loading...

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

Alexandra - Time Series For Statistical Variables

@datacommons.cities.alexandra_wikidataid_q2058593
  • 9.62 kB
  • 2 rows
  • 12 columns
Loading...

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

Alexandreia - Time Series For Statistical Variables

@datacommons.cities.alexandreia_wikidataid_q1014285
  • 49.41 kB
  • 5,884 rows
  • 12 columns
Loading...

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

Alexandria Bay - Time Series For Statistical Variables

@datacommons.cities.alexandria_bay_geoid_3601187
  • 3.05 MB
  • 354,375 rows
  • 12 columns
Loading...

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

Alexandria - Time Series For Statistical Variables

@datacommons.cities.alexandria_geoid_0101180
  • 3.08 MB
  • 352,218 rows
  • 12 columns
Loading...

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

Alexandria - Time Series For Statistical Variables

@datacommons.cities.alexandria_geoid_1800910
  • 3.15 MB
  • 355,005 rows
  • 12 columns
Loading...

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

Alexandria - Time Series For Statistical Variables

@datacommons.cities.alexandria_geoid_2100802
  • 3.27 MB
  • 358,537 rows
  • 12 columns
Loading...

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

Alexandria - Time Series For Statistical Variables

@datacommons.cities.alexandria_geoid_2200975
  • 3.49 MB
  • 365,555 rows
  • 12 columns
Loading...

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

Alexandria - Time Series For Statistical Variables

@datacommons.cities.alexandria_geoid_2700928
  • 3.33 MB
  • 358,090 rows
  • 12 columns
Loading...

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

Alexandria - Time Series For Statistical Variables

@datacommons.cities.alexandria_geoid_2900604
  • 2.74 MB
  • 337,483 rows
  • 12 columns
Loading...

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

Alexandria - Time Series For Statistical Variables

@datacommons.cities.alexandria_geoid_3100730
  • 2.79 MB
  • 339,364 rows
  • 12 columns
Loading...

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

Alexandria - Time Series For Statistical Variables

@datacommons.cities.alexandria_geoid_3300580
  • 96.35 kB
  • 15,975 rows
  • 12 columns
Loading...

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

Alexandria - Time Series For Statistical Variables

@datacommons.cities.alexandria_geoid_3901154
  • 2.91 MB
  • 345,585 rows
  • 12 columns
Loading...

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

Alexandria - Time Series For Statistical Variables

@datacommons.cities.alexandria_geoid_4200756
  • 1.54 MB
  • 194,850 rows
  • 12 columns
Loading...

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