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/Q12388445 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12388445_wikidataid_q12388445
  • 47.21 kB
  • 5,629 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12388445_wikidataid_q12388445 (
  "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/Q12388450 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12388450_wikidataid_q12388450
  • 59.18 kB
  • 7,903 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12388450_wikidataid_q12388450 (
  "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/Q12388460 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12388460_wikidataid_q12388460
  • 59.38 kB
  • 7,925 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12388460_wikidataid_q12388460 (
  "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/Q12388510 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12388510_wikidataid_q12388510
  • 42.64 kB
  • 5,092 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12388510_wikidataid_q12388510 (
  "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/Q12388522 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12388522_wikidataid_q12388522
  • 56.77 kB
  • 7,659 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12388522_wikidataid_q12388522 (
  "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/Q12388523 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12388523_wikidataid_q12388523
  • 59.77 kB
  • 7,925 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12388523_wikidataid_q12388523 (
  "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/Q12388534 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12388534_wikidataid_q12388534
  • 59.45 kB
  • 7,925 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12388534_wikidataid_q12388534 (
  "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/Q12388545 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12388545_wikidataid_q12388545
  • 59.61 kB
  • 7,925 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12388545_wikidataid_q12388545 (
  "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/Q12388546 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12388546_wikidataid_q12388546
  • 58.95 kB
  • 7,925 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12388546_wikidataid_q12388546 (
  "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/Q12388548 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12388548_wikidataid_q12388548
  • 59.34 kB
  • 7,925 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12388548_wikidataid_q12388548 (
  "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/Q12388549 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12388549_wikidataid_q12388549
  • 54.3 kB
  • 7,021 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12388549_wikidataid_q12388549 (
  "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/Q12388552 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12388552_wikidataid_q12388552
  • 59.29 kB
  • 7,925 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12388552_wikidataid_q12388552 (
  "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/Q12388554 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12388554_wikidataid_q12388554
  • 54.6 kB
  • 7,021 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12388554_wikidataid_q12388554 (
  "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/Q12388555 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12388555_wikidataid_q12388555
  • 52.69 kB
  • 6,670 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12388555_wikidataid_q12388555 (
  "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/Q12388558 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12388558_wikidataid_q12388558
  • 42.56 kB
  • 5,092 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12388558_wikidataid_q12388558 (
  "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/Q12388561 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12388561_wikidataid_q12388561
  • 59.54 kB
  • 7,925 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12388561_wikidataid_q12388561 (
  "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/Q12388569 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12388569_wikidataid_q12388569
  • 56.91 kB
  • 7,659 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12388569_wikidataid_q12388569 (
  "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/Q12388571 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12388571_wikidataid_q12388571
  • 52.27 kB
  • 6,670 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12388571_wikidataid_q12388571 (
  "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/Q12388572 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12388572_wikidataid_q12388572
  • 54.28 kB
  • 7,012 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12388572_wikidataid_q12388572 (
  "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/Q12388585 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12388585_wikidataid_q12388585
  • 42.47 kB
  • 5,092 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12388585_wikidataid_q12388585 (
  "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/Q12388586 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12388586_wikidataid_q12388586
  • 59.28 kB
  • 7,925 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12388586_wikidataid_q12388586 (
  "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/Q12388611 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12388611_wikidataid_q12388611
  • 59.57 kB
  • 7,925 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12388611_wikidataid_q12388611 (
  "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/Q12388612 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12388612_wikidataid_q12388612
  • 58.86 kB
  • 7,925 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12388612_wikidataid_q12388612 (
  "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/Q12388632 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12388632_wikidataid_q12388632
  • 42.75 kB
  • 5,092 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12388632_wikidataid_q12388632 (
  "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/Q12388646 - Time Series For Statistical Variables

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