About this Dataset

Life Expectancy

Life expectancy is a summary measure of the all-cause mortality rates in an area in a given period. It shows an estimate of the average number of years a newborn baby would survive if he or she experienced the age-specific mortality rates for that area and time period throughout his or her life. Figures reflect mortality among those living in an area in the given time period, not the life expectancy of newborn children. That is because both the mortality rates of the area are likely to change in the future, and because many of those born in the area will live elsewhere for at least some part of their lives. Life expectancy is a summary measure of a population's health. It may be influenced by premature mortalities and health inequalities. Data source: Office for Health Improvement and Disparities (ODHI), indicator 90366.
Publisher name: Lincolnshire County Council
Last updated: 2025-04-13T04:00:03Z

Tables

Life Expectancy

@ukgov.life_expectancy1.life_expectancy

11.85 KB
104 rows
13 columns


CREATE TABLE life_expectancy (
  "organisationlabel" VARCHAR,
  "organisationuri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "durationfrom" TIMESTAMP,
  "durationto" VARCHAR,
  "latestdata" VARCHAR,
  "reportingperiod" VARCHAR,
  "geoentityname" VARCHAR,
  "geocode" VARCHAR,
  "geoname" VARCHAR,
  "geouri" VARCHAR,
  "femalelifeexpectancy" DOUBLE,
  "malelifeexpectancy" DOUBLE
);

Table 2

@ukgov.life_expectancy1.table_2

11.14 KB
13 rows
12 columns


CREATE TABLE table_2 (
  "dataset_id" BIGINT,
  "dataset_name" VARCHAR,
  "field" VARCHAR,
  "type" VARCHAR,
  "mandatory_or_optional_requirement_mor" VARCHAR,
  "field_description" VARCHAR,
  "schema" VARCHAR,
  "lcc_mapping" VARCHAR,
  "schema_comments" VARCHAR,
  "schema_data_rules_comment" VARCHAR,
  "formatreference" VARCHAR,
  "example" VARCHAR
);