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

Avella - Time Series For Statistical Variables

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

Avellaneda - Time Series For Statistical Variables

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

Avella - Time Series For Statistical Variables

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

Ave Maria - Time Series For Statistical Variables

@datacommons.cities.ave_maria_geoid_1202677
  • 1.09 MB
  • 63,160 rows
  • 12 columns
Loading...
CREATE TABLE ave_maria_geoid_1202677 (
  "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
);

Avena - Time Series For Statistical Variables

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

Avenal - Time Series For Statistical Variables

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

Avena Township - Time Series For Statistical Variables

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

Avenel - Time Series For Statistical Variables

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

Avenel-Hillandale, Maryland - Time Series For Statistical Variables

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

Avenel - Time Series For Statistical Variables

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

Aventoft - Time Series For Statistical Variables

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

Aventura - Time Series For Statistical Variables

@datacommons.cities.aventura_geoid_1202681
  • 3.75 MB
  • 378,880 rows
  • 12 columns
Loading...
CREATE TABLE aventura_geoid_1202681 (
  "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
);

Avenue B And C - Time Series For Statistical Variables

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

Avera - Time Series For Statistical Variables

@datacommons.cities.avera_geoid_1304448
  • 2.8 MB
  • 340,616 rows
  • 12 columns
Loading...
CREATE TABLE avera_geoid_1304448 (
  "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
);

Averasboro Township - Time Series For Statistical Variables

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

Averill - Time Series For Statistical Variables

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

Averill Park - Time Series For Statistical Variables

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

A Ver-o-Mar - Time Series For Statistical Variables

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

Avery Creek - Time Series For Statistical Variables

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

Avery - Time Series For Statistical Variables

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

Avery - Time Series For Statistical Variables

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

Avery Township - Time Series For Statistical Variables

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

Avery Township - Time Series For Statistical Variables

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

Avery Township - Time Series For Statistical Variables

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

Avery - Time Series For Statistical Variables

@datacommons.cities.avery_wikidataid_q761379
  • 93.35 kB
  • 14,680 rows
  • 12 columns
Loading...
CREATE TABLE avery_wikidataid_q761379 (
  "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.