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

Baden Bei Wien - Time Series For Statistical Variables

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

Baden - Time Series For Statistical Variables

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

Baden - Time Series For Statistical Variables

@datacommons.cities.baden_geoid_4203736
  • 3.14 MB
  • 356,878 rows
  • 12 columns
Loading... 
CREATE TABLE baden_geoid_4203736 (
  "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
);

Baden Township - Time Series For Statistical Variables

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

Baden - Time Series For Statistical Variables

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

Baden - Time Series For Statistical Variables

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

Bad Fallingbostel - Time Series For Statistical Variables

@datacommons.cities.bad_fallingbostel_wikidataid_q501609
  • 74.32 kB
  • 9,795 rows
  • 12 columns
Loading... 
CREATE TABLE bad_fallingbostel_wikidataid_q501609 (
  "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
);

Bad Frankenhausen - Time Series For Statistical Variables

@datacommons.cities.bad_frankenhausen_wikidataid_q151876
  • 70.96 kB
  • 9,390 rows
  • 12 columns
Loading... 
CREATE TABLE bad_frankenhausen_wikidataid_q151876 (
  "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
);

Bad Freienwalde - Time Series For Statistical Variables

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

Bad Friedrichshall - Time Series For Statistical Variables

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

Bad Gandersheim - Time Series For Statistical Variables

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

Badger Creek - Time Series For Statistical Variables

@datacommons.cities.badger_creek_wikidataid_q4840842
  • 69.5 kB
  • 9,516 rows
  • 12 columns
Loading... 
CREATE TABLE badger_creek_wikidataid_q4840842 (
  "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
);

Badger - Time Series For Statistical Variables

@datacommons.cities.badger_geoid_0205000
  • 1.87 MB
  • 202,600 rows
  • 12 columns
Loading... 
CREATE TABLE badger_geoid_0205000 (
  "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
);

Badger - Time Series For Statistical Variables

@datacommons.cities.badger_geoid_1904195
  • 2.9 MB
  • 343,946 rows
  • 12 columns
Loading... 
CREATE TABLE badger_geoid_1904195 (
  "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
);

Badger - Time Series For Statistical Variables

@datacommons.cities.badger_geoid_2703160
  • 2.95 MB
  • 349,724 rows
  • 12 columns
Loading... 
CREATE TABLE badger_geoid_2703160 (
  "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
);

Badger - Time Series For Statistical Variables

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

Badger Lee - Time Series For Statistical Variables

@datacommons.cities.badger_lee_geoid_4003815
  • 2.65 MB
  • 330,836 rows
  • 12 columns
Loading... 
CREATE TABLE badger_lee_geoid_4003815 (
  "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
);

Badger Lee - Time Series For Statistical Variables

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

Badger Township - Time Series For Statistical Variables

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

Badger Township - Time Series For Statistical Variables

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

Badger Township - Time Series For Statistical Variables

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

Badger Township - Time Series For Statistical Variables

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

Badger Township - Time Series For Statistical Variables

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

Badger Township - Time Series For Statistical Variables

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

Badger - Time Series For Statistical Variables

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