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

WikidataId/Q20545286 - Time Series For Statistical Variables

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

WikidataId/Q20545300 - Time Series For Statistical Variables

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

WikidataId/Q20545364 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20545364_wikidataid_q20545364
  • 21.38 kB
  • 2,214 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20545364_wikidataid_q20545364 (
  "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
);

WikidataId/Q20545369 - Time Series For Statistical Variables

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

WikidataId/Q20545379 - Time Series For Statistical Variables

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

WikidataId/Q20545386 - Time Series For Statistical Variables

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

WikidataId/Q20545405 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20545405_wikidataid_q20545405
  • 52.55 kB
  • 6,670 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20545405_wikidataid_q20545405 (
  "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
);

WikidataId/Q20545435 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20545435_wikidataid_q20545435
  • 53.94 kB
  • 6,670 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20545435_wikidataid_q20545435 (
  "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
);

WikidataId/Q20545465 - Time Series For Statistical Variables

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

WikidataId/Q20545538 - Time Series For Statistical Variables

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

WikidataId/Q20545574 - Time Series For Statistical Variables

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

WikidataId/Q20545591 - Time Series For Statistical Variables

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

WikidataId/Q20545612 - Time Series For Statistical Variables

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

WikidataId/Q20545618 - Time Series For Statistical Variables

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

WikidataId/Q20545633 - Time Series For Statistical Variables

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

WikidataId/Q20545636 - Time Series For Statistical Variables

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

WikidataId/Q20545642 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20545642_wikidataid_q20545642
  • 50.72 kB
  • 6,337 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20545642_wikidataid_q20545642 (
  "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
);

WikidataId/Q20545700 - Time Series For Statistical Variables

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

WikidataId/Q20545741 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20545741_wikidataid_q20545741
  • 50.77 kB
  • 6,337 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20545741_wikidataid_q20545741 (
  "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
);

WikidataId/Q20545746 - Time Series For Statistical Variables

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

WikidataId/Q20545763 - Time Series For Statistical Variables

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

WikidataId/Q20545764 - Time Series For Statistical Variables

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

WikidataId/Q20545770 - Time Series For Statistical Variables

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

WikidataId/Q20545771 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20545771_wikidataid_q20545771
  • 54.25 kB
  • 6,670 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20545771_wikidataid_q20545771 (
  "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
);

WikidataId/Q20545774 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20545774_wikidataid_q20545774
  • 50.32 kB
  • 6,337 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20545774_wikidataid_q20545774 (
  "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.