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

Aurora - Time Series For Statistical Variables

@datacommons.cities.aurora_geoid_3603188
  • 3.01 MB
  • 352,049 rows
  • 12 columns
Loading... 
CREATE TABLE aurora_geoid_3603188 (
  "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
);

Aurora - Time Series For Statistical Variables

@datacommons.cities.aurora_geoid_3702620
  • 2.96 MB
  • 352,394 rows
  • 12 columns
Loading... 
CREATE TABLE aurora_geoid_3702620 (
  "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
);

Aurora - Time Series For Statistical Variables

@datacommons.cities.aurora_geoid_3903086
  • 3.33 MB
  • 359,804 rows
  • 12 columns
Loading... 
CREATE TABLE aurora_geoid_3903086 (
  "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
);

Aurora - Time Series For Statistical Variables

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

Aurora - Time Series For Statistical Variables

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

Aurora - Time Series For Statistical Variables

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

Aurora - Time Series For Statistical Variables

@datacommons.cities.aurora_geoid_4902740
  • 2.88 MB
  • 342,932 rows
  • 12 columns
Loading... 
CREATE TABLE aurora_geoid_4902740 (
  "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
);

Aurora - Time Series For Statistical Variables

@datacommons.cities.aurora_geoid_5403460
  • 2.74 MB
  • 336,726 rows
  • 12 columns
Loading... 
CREATE TABLE aurora_geoid_5403460 (
  "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
);

Aurora - Time Series For Statistical Variables

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

Aurora - Time Series For Statistical Variables

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

Aurora - Time Series For Statistical Variables

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

Aurora Springs - Time Series For Statistical Variables

@datacommons.cities.aurora_springs_geoid_2902584
  • 961.17 kB
  • 62,979 rows
  • 12 columns
Loading... 
CREATE TABLE aurora_springs_geoid_2902584 (
  "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
);

Aurora Township - Time Series For Statistical Variables

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

Aurora Township - Time Series For Statistical Variables

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

Aurora Township - Time Series For Statistical Variables

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

Aurora Township - Time Series For Statistical Variables

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

Aurora Township - Time Series For Statistical Variables

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

Aurora Township - Time Series For Statistical Variables

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

Aurora Township - Time Series For Statistical Variables

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

Aurora, Western Cape - Time Series For Statistical Variables

@datacommons.cities.aurora_western_cape_wikidataid_q493459
  • 48.73 kB
  • 6,079 rows
  • 12 columns
Loading... 
CREATE TABLE aurora_western_cape_wikidataid_q493459 (
  "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
);

Aurora - Time Series For Statistical Variables

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

Aurora - Time Series For Statistical Variables

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

Aurora - Time Series For Statistical Variables

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

Auroville - Time Series For Statistical Variables

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

Aurukun - Time Series For Statistical Variables

@datacommons.cities.aurukun_wikidataid_q1879882
  • 31.29 kB
  • 3,618 rows
  • 12 columns
Loading... 
CREATE TABLE aurukun_wikidataid_q1879882 (
  "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.