Baselight

Counties

County-Level Data for Regional Insights

@datacommons.counties

Loading...
Loading...

About this Dataset

Counties

This dataset comprises worldwide county-level statistical variables, covering a wide range of metrics such as demographics, economic activity, health, and education.

Tables

County Kildare - Time Series For Statistical Variables

@datacommons.counties.county_kildare_wikidataid_q173332
  • 14.67 KB
  • 551 rows
  • 12 columns
Loading...

CREATE TABLE county_kildare_wikidataid_q173332 (
  "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
);

County Kilkenny - Time Series For Statistical Variables

@datacommons.counties.county_kilkenny_wikidataid_q180231
  • 13.1 KB
  • 412 rows
  • 12 columns
Loading...

CREATE TABLE county_kilkenny_wikidataid_q180231 (
  "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
);

County Laois - Time Series For Statistical Variables

@datacommons.counties.county_laois_wikidataid_q55299
  • 14.04 KB
  • 487 rows
  • 12 columns
Loading...

CREATE TABLE county_laois_wikidataid_q55299 (
  "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
);

County Leitrim - Time Series For Statistical Variables

@datacommons.counties.county_leitrim_wikidataid_q107397
  • 14.89 KB
  • 640 rows
  • 12 columns
Loading...

CREATE TABLE county_leitrim_wikidataid_q107397 (
  "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
);

County Limerick - Time Series For Statistical Variables

@datacommons.counties.county_limerick_wikidataid_q178283
  • 15.09 KB
  • 632 rows
  • 12 columns
Loading...

CREATE TABLE county_limerick_wikidataid_q178283 (
  "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
);

County Longford - Time Series For Statistical Variables

@datacommons.counties.county_longford_wikidataid_q186220
  • 14.19 KB
  • 551 rows
  • 12 columns
Loading...

CREATE TABLE county_longford_wikidataid_q186220 (
  "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
);

County Louth - Time Series For Statistical Variables

@datacommons.counties.county_louth_wikidataid_q183539
  • 14.33 KB
  • 527 rows
  • 12 columns
Loading...

CREATE TABLE county_louth_wikidataid_q183539 (
  "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
);

County Mayo - Time Series For Statistical Variables

@datacommons.counties.county_mayo_wikidataid_q178626
  • 16.05 KB
  • 728 rows
  • 12 columns
Loading...

CREATE TABLE county_mayo_wikidataid_q178626 (
  "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
);

County Meath - Time Series For Statistical Variables

@datacommons.counties.county_meath_wikidataid_q183544
  • 15.06 KB
  • 637 rows
  • 12 columns
Loading...

CREATE TABLE county_meath_wikidataid_q183544 (
  "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
);

County Monaghan - Time Series For Statistical Variables

@datacommons.counties.county_monaghan_wikidataid_q184760
  • 14.35 KB
  • 525 rows
  • 12 columns
Loading...

CREATE TABLE county_monaghan_wikidataid_q184760 (
  "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
);

County Offaly - Time Series For Statistical Variables

@datacommons.counties.county_offaly_wikidataid_q184445
  • 14.62 KB
  • 566 rows
  • 12 columns
Loading...

CREATE TABLE county_offaly_wikidataid_q184445 (
  "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
);

County Roscommon - Time Series For Statistical Variables

@datacommons.counties.county_roscommon_wikidataid_q179437
  • 15.22 KB
  • 665 rows
  • 12 columns
Loading...

CREATE TABLE county_roscommon_wikidataid_q179437 (
  "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
);

County Sligo - Time Series For Statistical Variables

@datacommons.counties.county_sligo_wikidataid_q179325
  • 15.01 KB
  • 650 rows
  • 12 columns
Loading...

CREATE TABLE county_sligo_wikidataid_q179325 (
  "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
);

County Tipperary - Time Series For Statistical Variables

@datacommons.counties.county_tipperary_wikidataid_q184618
  • 14.48 KB
  • 514 rows
  • 12 columns
Loading...

CREATE TABLE county_tipperary_wikidataid_q184618 (
  "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
);

County Westmeath - Time Series For Statistical Variables

@datacommons.counties.county_westmeath_wikidataid_q182633
  • 15.14 KB
  • 669 rows
  • 12 columns
Loading...

CREATE TABLE county_westmeath_wikidataid_q182633 (
  "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
);

County Wicklow - Time Series For Statistical Variables

@datacommons.counties.county_wicklow_wikidataid_q182591
  • 15.19 KB
  • 671 rows
  • 12 columns
Loading...

CREATE TABLE county_wicklow_wikidataid_q182591 (
  "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
);

Covasna County - Time Series For Statistical Variables

@datacommons.counties.covasna_county_wikidataid_q188959
  • 10.81 KB
  • 159 rows
  • 12 columns
Loading...

CREATE TABLE covasna_county_wikidataid_q188959 (
  "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
);

Covington County - Time Series For Statistical Variables

@datacommons.counties.covington_county_geoid_01039
  • 37.31 MB
  • 4006233 rows
  • 12 columns
Loading...

CREATE TABLE covington_county_geoid_01039 (
  "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
);

Covington County - Time Series For Statistical Variables

@datacommons.counties.covington_county_geoid_28031
  • 35.83 MB
  • 3774448 rows
  • 12 columns
Loading...

CREATE TABLE covington_county_geoid_28031 (
  "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
);

Covington - Time Series For Statistical Variables

@datacommons.counties.covington_geoid_51580
  • 35.43 MB
  • 3735724 rows
  • 12 columns
Loading...

CREATE TABLE covington_geoid_51580 (
  "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
);

Coweta County - Time Series For Statistical Variables

@datacommons.counties.coweta_county_geoid_13077
  • 39.87 MB
  • 4326374 rows
  • 12 columns
Loading...

CREATE TABLE coweta_county_geoid_13077 (
  "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
);

Cowley County - Time Series For Statistical Variables

@datacommons.counties.cowley_county_geoid_20035
  • 37.35 MB
  • 3972234 rows
  • 12 columns
Loading...

CREATE TABLE cowley_county_geoid_20035 (
  "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
);

Cowlitz County - Time Series For Statistical Variables

@datacommons.counties.cowlitz_county_geoid_53015
  • 39.92 MB
  • 4410747 rows
  • 12 columns
Loading...

CREATE TABLE cowlitz_county_geoid_53015 (
  "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
);

Craig County - Time Series For Statistical Variables

@datacommons.counties.craig_county_geoid_40035
  • 35.85 MB
  • 3771685 rows
  • 12 columns
Loading...

CREATE TABLE craig_county_geoid_40035 (
  "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
);

Craig County - Time Series For Statistical Variables

@datacommons.counties.craig_county_geoid_51045
  • 34.61 MB
  • 3626628 rows
  • 12 columns
Loading...

CREATE TABLE craig_county_geoid_51045 (
  "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.