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

Andover - Time Series For Statistical Variables

@datacommons.cities.andover_geoid_2501465
  • 111.72 kB
  • 17,819 rows
  • 12 columns
Loading...
CREATE TABLE andover_geoid_2501465 (
  "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
);

Andover - Time Series For Statistical Variables

@datacommons.cities.andover_geoid_2701486
  • 3.36 MB
  • 360,636 rows
  • 12 columns
Loading...
CREATE TABLE andover_geoid_2701486 (
  "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
);

Andover - Time Series For Statistical Variables

@datacommons.cities.andover_geoid_3301460
  • 104.47 kB
  • 16,932 rows
  • 12 columns
Loading...
CREATE TABLE andover_geoid_3301460 (
  "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
);

Andover - Time Series For Statistical Variables

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

Andover - Time Series For Statistical Variables

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

Andover - Time Series For Statistical Variables

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

Andover - Time Series For Statistical Variables

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

Andover - Time Series For Statistical Variables

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

Andover - Time Series For Statistical Variables

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

Andover Township - Time Series For Statistical Variables

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

Andover Township - Time Series For Statistical Variables

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

Andover Township - Time Series For Statistical Variables

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

Andover Township - Time Series For Statistical Variables

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

Andover Township - Time Series For Statistical Variables

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

Andover - Time Series For Statistical Variables

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

Andover - Time Series For Statistical Variables

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

Ando - Time Series For Statistical Variables

@datacommons.cities.ando_wikidataid_q1203680
  • 64.98 kB
  • 8,406 rows
  • 12 columns
Loading...
CREATE TABLE ando_wikidataid_q1203680 (
  "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
);

Andradina - Time Series For Statistical Variables

@datacommons.cities.andradina_wikidataid_q1646937
  • 41.32 kB
  • 4,088 rows
  • 12 columns
Loading...
CREATE TABLE andradina_wikidataid_q1646937 (
  "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
);

Andravida - Time Series For Statistical Variables

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

Andreapol - Time Series For Statistical Variables

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

Andrea Township - Time Series For Statistical Variables

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

Andres - Time Series For Statistical Variables

@datacommons.cities.andres_geoid_1701517
  • 930.86 kB
  • 63,687 rows
  • 12 columns
Loading...
CREATE TABLE andres_geoid_1701517 (
  "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
);

Andrew - Time Series For Statistical Variables

@datacommons.cities.andrew_geoid_1902125
  • 2.89 MB
  • 345,700 rows
  • 12 columns
Loading...
CREATE TABLE andrew_geoid_1902125 (
  "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
);

Andrews AFB - Time Series For Statistical Variables

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

Andrews - Time Series For Statistical Variables

@datacommons.cities.andrews_geoid_1201353
  • 2.76 MB
  • 335,965 rows
  • 12 columns
Loading...
CREATE TABLE andrews_geoid_1201353 (
  "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.