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

@datacommons.cities.wikidataid_q28662710_wikidataid_q28662710
  • 57.13 kB
  • 7,792 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q28662710_wikidataid_q28662710 (
  "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/Q28663309 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q28663309_wikidataid_q28663309
  • 12.23 kB
  • 324 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q28663309_wikidataid_q28663309 (
  "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/Q28663323 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q28663323_wikidataid_q28663323
  • 10.06 kB
  • 28 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q28663323_wikidataid_q28663323 (
  "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/Q2868451 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2868451_wikidataid_q2868451
  • 63.56 kB
  • 8,397 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2868451_wikidataid_q2868451 (
  "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/Q28692892 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q28692892_wikidataid_q28692892
  • 68.49 kB
  • 9,728 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q28692892_wikidataid_q28692892 (
  "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/Q28710622 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q28710622_wikidataid_q28710622
  • 66.35 kB
  • 9,381 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q28710622_wikidataid_q28710622 (
  "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/Q28710637 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q28710637_wikidataid_q28710637
  • 66.52 kB
  • 9,372 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q28710637_wikidataid_q28710637 (
  "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/Q28710721 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q28710721_wikidataid_q28710721
  • 66.9 kB
  • 9,381 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q28710721_wikidataid_q28710721 (
  "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/Q28710726 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q28710726_wikidataid_q28710726
  • 69 kB
  • 9,381 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q28710726_wikidataid_q28710726 (
  "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/Q28710745 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q28710745_wikidataid_q28710745
  • 65.86 kB
  • 9,381 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q28710745_wikidataid_q28710745 (
  "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/Q2873466 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2873466_wikidataid_q2873466
  • 54.54 kB
  • 7,081 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2873466_wikidataid_q2873466 (
  "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/Q2875185 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2875185_wikidataid_q2875185
  • 62.08 kB
  • 8,397 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2875185_wikidataid_q2875185 (
  "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/Q2876205 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q2876544_wikidataid_q2876544
  • 94.96 kB
  • 15,091 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2876544_wikidataid_q2876544 (
  "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/Q2877425 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q2878774_wikidataid_q2878774
  • 20.69 kB
  • 1,686 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2878774_wikidataid_q2878774 (
  "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/Q2885623 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q2887425_wikidataid_q2887425
  • 10.39 kB
  • 122 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2887425_wikidataid_q2887425 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" BIGINT,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

WikidataId/Q2893659 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2893659_wikidataid_q2893659
  • 77.83 kB
  • 13,259 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2893659_wikidataid_q2893659 (
  "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/Q28976219 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q28976219_wikidataid_q28976219
  • 47.91 kB
  • 6,095 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q28976219_wikidataid_q28976219 (
  "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/Q28976366 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q28976366_wikidataid_q28976366
  • 45.11 kB
  • 5,761 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q28976366_wikidataid_q28976366 (
  "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/Q29016316 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q29016316_wikidataid_q29016316
  • 45.49 kB
  • 5,689 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q29016316_wikidataid_q29016316 (
  "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/Q2911089 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2911089_wikidataid_q2911089
  • 46.22 kB
  • 5,524 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2911089_wikidataid_q2911089 (
  "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/Q2918113 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2918113_wikidataid_q2918113
  • 41.48 kB
  • 4,669 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2918113_wikidataid_q2918113 (
  "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/Q2924202 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2924202_wikidataid_q2924202
  • 28.02 kB
  • 2,557 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2924202_wikidataid_q2924202 (
  "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.