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

@datacommons.cities.wikidataid_q9010272_wikidataid_q9010272
  • 51.85 kB
  • 6,336 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q9010272_wikidataid_q9010272 (
  "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/Q9018294 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q9018294_wikidataid_q9018294
  • 59.85 kB
  • 7,351 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q9018294_wikidataid_q9018294 (
  "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/Q9018367 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q9018367_wikidataid_q9018367
  • 51.27 kB
  • 6,337 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q9018367_wikidataid_q9018367 (
  "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/Q9019012 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q9019012_wikidataid_q9019012
  • 53.71 kB
  • 6,895 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q9019012_wikidataid_q9019012 (
  "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/Q9019715 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q9019715_wikidataid_q9019715
  • 51.2 kB
  • 6,336 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q9019715_wikidataid_q9019715 (
  "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/Q9019755 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q9019755_wikidataid_q9019755
  • 50.55 kB
  • 6,352 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q9019755_wikidataid_q9019755 (
  "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/Q9020506 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q9020506_wikidataid_q9020506
  • 50.81 kB
  • 6,722 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q9020506_wikidataid_q9020506 (
  "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/Q9023277 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q9023277_wikidataid_q9023277
  • 16.19 kB
  • 931 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q9023277_wikidataid_q9023277 (
  "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/Q9024113 - Time Series For Statistical Variables

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

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

@datacommons.cities.wikidataid_q9031510_wikidataid_q9031510
  • 55.44 kB
  • 7,236 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q9031510_wikidataid_q9031510 (
  "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/Q9031521 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q9031521_wikidataid_q9031521
  • 52.13 kB
  • 6,472 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q9031521_wikidataid_q9031521 (
  "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/Q9033815 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q9033815_wikidataid_q9033815
  • 43.27 kB
  • 5,156 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q9033815_wikidataid_q9033815 (
  "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/Q9034148 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q9034148_wikidataid_q9034148
  • 64.08 kB
  • 7,990 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q9034148_wikidataid_q9034148 (
  "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/Q9035809 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q9035809_wikidataid_q9035809
  • 86.02 kB
  • 14,413 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q9035809_wikidataid_q9035809 (
  "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/Q9035830 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q9035830_wikidataid_q9035830
  • 96.32 kB
  • 15,094 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q9035830_wikidataid_q9035830 (
  "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/Q9035850 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q9035850_wikidataid_q9035850
  • 91.57 kB
  • 14,952 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q9035850_wikidataid_q9035850 (
  "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/Q9035981 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q9035981_wikidataid_q9035981
  • 81.84 kB
  • 13,945 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q9035981_wikidataid_q9035981 (
  "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/Q9043995 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q9043995_wikidataid_q9043995
  • 82.14 kB
  • 13,701 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q9043995_wikidataid_q9043995 (
  "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/Q9045318 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q9045318_wikidataid_q9045318
  • 96.08 kB
  • 15,631 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q9045318_wikidataid_q9045318 (
  "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/Q9046620 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q9046620_wikidataid_q9046620
  • 50.17 kB
  • 6,336 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q9046620_wikidataid_q9046620 (
  "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/Q9051956 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q9051956_wikidataid_q9051956
  • 50.4 kB
  • 6,336 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q9051956_wikidataid_q9051956 (
  "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/Q9051958 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q9051958_wikidataid_q9051958
  • 50.45 kB
  • 6,336 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q9051958_wikidataid_q9051958 (
  "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/Q9053458 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q9053458_wikidataid_q9053458
  • 50.55 kB
  • 6,336 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q9053458_wikidataid_q9053458 (
  "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/Q9053544 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q9053544_wikidataid_q9053544
  • 55.04 kB
  • 7,267 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q9053544_wikidataid_q9053544 (
  "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.