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

Wilson - Time Series For Statistical Variables

@datacommons.cities.wilson_geoid_3682359
  • 3.04 MB
  • 354,492 rows
  • 12 columns
Loading... 
CREATE TABLE wilson_geoid_3682359 (
  "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
);

Wilson - Time Series For Statistical Variables

@datacommons.cities.wilson_geoid_3774540
  • 3.52 MB
  • 365,998 rows
  • 12 columns
Loading... 
CREATE TABLE wilson_geoid_3774540 (
  "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
);

Wilson - Time Series For Statistical Variables

@datacommons.cities.wilson_geoid_3985834
  • 2.76 MB
  • 338,871 rows
  • 12 columns
Loading... 
CREATE TABLE wilson_geoid_3985834 (
  "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
);

Wilson - Time Series For Statistical Variables

@datacommons.cities.wilson_geoid_4081500
  • 3.04 MB
  • 353,518 rows
  • 12 columns
Loading... 
CREATE TABLE wilson_geoid_4081500 (
  "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
);

Wilson - Time Series For Statistical Variables

@datacommons.cities.wilson_geoid_4285592
  • 3.22 MB
  • 358,453 rows
  • 12 columns
Loading... 
CREATE TABLE wilson_geoid_4285592 (
  "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
);

Wilson - Time Series For Statistical Variables

@datacommons.cities.wilson_geoid_4879612
  • 2.91 MB
  • 345,266 rows
  • 12 columns
Loading... 
CREATE TABLE wilson_geoid_4879612 (
  "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
);

Wilson - Time Series For Statistical Variables

@datacommons.cities.wilson_geoid_5587375
  • 95.34 kB
  • 15,042 rows
  • 12 columns
Loading... 
CREATE TABLE wilson_geoid_5587375 (
  "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
);

Wilson - Time Series For Statistical Variables

@datacommons.cities.wilson_geoid_5587400
  • 94.34 kB
  • 15,043 rows
  • 12 columns
Loading... 
CREATE TABLE wilson_geoid_5587400 (
  "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
);

Wilson - Time Series For Statistical Variables

@datacommons.cities.wilson_geoid_5587425
  • 85.99 kB
  • 13,404 rows
  • 12 columns
Loading... 
CREATE TABLE wilson_geoid_5587425 (
  "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
);

Wilson - Time Series For Statistical Variables

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

Wilson - Time Series For Statistical Variables

@datacommons.cities.wilson_geoid_5587475
  • 2.83 MB
  • 341,825 rows
  • 12 columns
Loading... 
CREATE TABLE wilson_geoid_5587475 (
  "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
);

Wilson - Time Series For Statistical Variables

@datacommons.cities.wilson_geoid_5587500
  • 85.58 kB
  • 13,751 rows
  • 12 columns
Loading... 
CREATE TABLE wilson_geoid_5587500 (
  "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
);

Wilson - Time Series For Statistical Variables

@datacommons.cities.wilson_geoid_5683765
  • 2.86 MB
  • 340,253 rows
  • 12 columns
Loading... 
CREATE TABLE wilson_geoid_5683765 (
  "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
);

Wilsonia - Time Series For Statistical Variables

@datacommons.cities.wilsonia_geoid_0685866
  • 2.49 MB
  • 316,462 rows
  • 12 columns
Loading... 
CREATE TABLE wilsonia_geoid_0685866 (
  "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
);

Wilsons Creek - Time Series For Statistical Variables

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

Wilson's Mills - Time Series For Statistical Variables

@datacommons.cities.wilson_s_mills_geoid_3774580
  • 3.02 MB
  • 348,781 rows
  • 12 columns
Loading... 
CREATE TABLE wilson_s_mills_geoid_3774580 (
  "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
);

Wilson (town), New York - Time Series For Statistical Variables

@datacommons.cities.wilson_town_new_york_wikidataid_q8022965
  • 100.8 kB
  • 15,934 rows
  • 12 columns
Loading... 
CREATE TABLE wilson_town_new_york_wikidataid_q8022965 (
  "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
);

Wilson Township - Time Series For Statistical Variables

@datacommons.cities.wilson_township_geoid_1782140
  • 87.82 kB
  • 14,023 rows
  • 12 columns
Loading... 
CREATE TABLE wilson_township_geoid_1782140 (
  "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
);

Wilson Township - Time Series For Statistical Variables

@datacommons.cities.wilson_township_geoid_1994755
  • 83.23 kB
  • 13,263 rows
  • 12 columns
Loading... 
CREATE TABLE wilson_township_geoid_1994755 (
  "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
);

Wilson Township - Time Series For Statistical Variables

@datacommons.cities.wilson_township_geoid_2079700
  • 91.02 kB
  • 14,347 rows
  • 12 columns
Loading... 
CREATE TABLE wilson_township_geoid_2079700 (
  "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
);

Wilson Township - Time Series For Statistical Variables

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

Wilson Township - Time Series For Statistical Variables

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

Wilson Township - Time Series For Statistical Variables

@datacommons.cities.wilson_township_geoid_2079775
  • 91.65 kB
  • 13,945 rows
  • 12 columns
Loading... 
CREATE TABLE wilson_township_geoid_2079775 (
  "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
);

Wilson Township - Time Series For Statistical Variables

@datacommons.cities.wilson_township_geoid_2687680
  • 91.53 kB
  • 14,565 rows
  • 12 columns
Loading... 
CREATE TABLE wilson_township_geoid_2687680 (
  "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
);

Wilson Township - Time Series For Statistical Variables

@datacommons.cities.wilson_township_geoid_2687700
  • 90.71 kB
  • 14,489 rows
  • 12 columns
Loading... 
CREATE TABLE wilson_township_geoid_2687700 (
  "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.