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

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

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

@datacommons.cities.wikidataid_q12396184_wikidataid_q12396184
  • 57.61 kB
  • 7,545 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12396184_wikidataid_q12396184 (
  "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/Q12396258 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q12396319_wikidataid_q12396319
  • 54.07 kB
  • 7,002 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12396319_wikidataid_q12396319 (
  "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/Q12396367 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12396367_wikidataid_q12396367
  • 60.59 kB
  • 8,054 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12396367_wikidataid_q12396367 (
  "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/Q12396378 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12396378_wikidataid_q12396378
  • 60.14 kB
  • 8,054 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12396378_wikidataid_q12396378 (
  "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/Q12396381 - Time Series For Statistical Variables

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

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

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

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

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

@datacommons.cities.wikidataid_q12396442_wikidataid_q12396442
  • 57.37 kB
  • 7,545 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12396442_wikidataid_q12396442 (
  "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/Q12396459 - Time Series For Statistical Variables

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

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

@datacommons.cities.wikidataid_q12396491_wikidataid_q12396491
  • 59.97 kB
  • 8,054 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12396491_wikidataid_q12396491 (
  "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/Q12396523 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q12396539_wikidataid_q12396539
  • 57.38 kB
  • 7,545 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12396539_wikidataid_q12396539 (
  "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/Q12396549 - Time Series For Statistical Variables

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

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

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

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

@datacommons.cities.wikidataid_q12396586_wikidataid_q12396586
  • 60.26 kB
  • 8,054 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12396586_wikidataid_q12396586 (
  "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/Q12396613 - Time Series For Statistical Variables

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

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