getus_all: get COVID-19 and other metrics
In c1au6i0/covid19census_dev: Extracts Covid-19 and other demographic metrics regarding U.S.A and Italy
Description
Usage
Arguments
Details
Value
Source
See Also
View source: R/getus_functions.R
Description
extracts/joins COVID-19 info with other demographic metrics at the county level and tests and hospitalizations from
the COVID Tracking Project
Usage
1
getus_all(repo = "jhu")
Arguments
repo
repository of COVID-19 data, one of c("nyt", "jhu")
Details
For details regarding some specific datasets refer to: Subject Definitions of the American Community Survey,
Medicare and Medicaid Medical Services Technical Documentation,
COVIDExposureIndices
Value
A dataframe with 330 variables. Data regarding the household composition, population sex, age, race, ancestry and poverty levels,
were scraped from the 2018 American Community Survey (ACS). Poverty was defined at the family level and not the household level in
the ACS. Medical conditions, tobacco use, cancer and, data relative to the number of medical and emergency visits
was obtained from the 2017 Mapping Medicare Disparities. From relative documentation listed in the source: "Prevalence rates are calculated
by searching for certain diagnosis codes in Medicare beneficiaries’ claims. The admission rate by admission type is the frequency of
a specific type of inpatient admission per 1,000 inpatient admissions in a year."
The number of hospital beds per county was calculated from data of the2020 Homeland Infrastructure Foundation.
Emissions of particulate 2.5 in micro g/m3 (2000-2016) and seasonal temperature (2000-2016) were reported by Atmoshpheric Composition Analysis Group and
aggregate by Ista Zahn and Ben Sabath.
The following list of variables is divided in sections COVID-19 VARS, HOUSEHOLDS MARITAL STATUS AND COMPOSITION, HOUSEHOLDS EDUCATION DEGREES,
ANCESTRY, COMPUTER OR INTERNET, POPULATION AND SEX, POPULATION AND RACE, MEDICAL AND VACCINES, POVERTY, ACTIVITY, POLLUTIONS AND TEMPERATURE, STATE LEVEL TESTS AND HOSPITALIZATIONS.
Note that data on test and hospitalizations are at the state level!
- date
formatted ISO 8601
- county
county
- state
state
- fips
federal information processing standard, a unique numeric identifier of a county.
Unknown fips are coded as 00000. Note that in the nyt repository a lot of deaths
and confirmed cases are no categorized
at the county level
- urban
urban or rural (not sure about the definition)
- COVID-19 VARS
—————
- cases
confirmed COVID-19 cases (cumulates with date)
- deaths
number of deaths attributed to COVID-19
- cmr
case-mortality rate (deaths / confirmed cases * 100)
- HOUSEHOLDS MARITAL STATUS AND COMPOSITION
—————
- total_households
total number of households (occupy a housing unit) in that county. People not living in households are classified as living in group quarters
- perc_families
percent of households that are defined as family. A family consists of a householder and one or more other people living in the same household who are related to the householder by birth, marriage, or adoption
- perc_families_18childereen
percentfamilies with at least a child <= 18 years old
- perc_married_couples
percent families consisting of married couples
- perc_married_couples_u18ychildreen
percent families consisting of married couples at least a child 18 years old or less
- perc_families_only_male
percent of family with a male householder and no spouse of householder present
- perc_families_only_male_18ychildreen
percent families with male householder and no spouse of householder present and with at least a child under 18 years old
- perc_families_only_female
percent families with female householder
- perc_families_only_female_18ychildreen
percent families with female householder with at least a child under 18 years old
- perc_non_families
percent of non-family households. A family consists of a householder and one or more other people living in the same household who are related to the householder by birth, marriage, or adoption
- perc_non_families_alone
percent of non-family households with householder living alone
- perc_non_families_alone65y
percent of non-family households with householder living alone, age 65 years and older
- perc_non_families_u18y
percent of non-family households with one or more people under 18 years
- perc_non_families_65y
percent of non-family households with with one or more people 65 years and older
- total_relationship_in_households
total number of people that responded to the question regarding relationship
- perc_relationship_spouse
households including person married to and living with the householder
- perc_relationship_child
households including a son or daughter by birth, a stepchild, or adopted child of the householder
- perc_relationship_other_relatives
percent households including other relatives
- perc_relationship_other_nonrelatives
percent households including foster children, not related to the householder by birth, marriage, or adoption
- perc_relationship_other_unmaried_part
percent households containing members other than a “married-couple household” that includes a householder and an “unmarried partner.”
- total_marital_status_male
total males that responded to the marital status question
- perc_marital_status_male_nevermaried
percent males never married
- perc_marital_status_male_maried
percent males married
- perc_marital_status_male_separated
percent of males separate
- perc_marital_status_male_
percent of males widowed
- perc_marital_status_male_divorced
percent of males divorced
- perc_marital_status_female_nevermaried
perent of female never married
- perc_marital_status_female_maried
perent of female married
- perc_marital_status_female_separated
perent of female separated
- perc_marital_status_female_widowed
perent of female widowed
- perc_marital_status_female_divorced
perent of female divorced
- HOUSEHOLDS EDUCATION DEGREES
—————
- total_enrolled_school
total people enrolled in school
- perc_enrolled_preschool
percent in preschool
- perc_enrolled_kindergarden
percent in kindergarden
- perc_enrolled_elementary
percent in elementary
- perc_enrolled_highschool
percent in highschool
- perc_enrolled_college
percent college
- total_edu
total number of people 25 years old or more that responded to the question regarding education (?)
- perc_edu_9grade
percent that went up to 9th grade
- perc_edu_nodiploma
percent that went up to 9th grade
- perc_edu_highshool
percent with highschool
- perc_edu_somecollege
percent with some college
- perc_edu_associate
percent that obtaibed an associate degree
- perc_edu_bachelor
percent with batchelor
- perc_edu_gradprofess
percent that graduated or with a professional degree
- perc_edu_batchelor_higher
percent with batchelor or higher
- ANCESTRY
—————
- total_ancestry
total population
- perc_ anchestry
percent estimated specific ancestry (27)
- COMPUTER OR INTERNET
—————
- total_withcomputer
total that own or use a computer
- perc_withcomputer
percent that owns or use computer
- perc_withinternet
percet that has acces to internet
- POPULATION AND SEX
—————
- total_pop
total population
- total_male
total male
- total_female
total female
- total_ age_sex
total population by age bin and sex
- perc_ age_sex
percent population by age bin and sex
- POPULATION AND RACE
—————
- total_nlat
total not hispanic or latinos. It can be normalized using total_population
- total_nlat_white_alone
total white in that category
- total_nlat_blackaa_alone
total black or african american
- total_nlat_native_alone
total american indian and alaska native
- total_nlat_asian_alone
total asian
- total_nlat_island_alone
total native hawaiaian and other pacific islander
- total_nlat_other_race
total other race
- total_nlat_2ormore
total 2 or more race
- total_nlat2ormore_io
total 2 or more race including other races
- total_nlat_3ormore_io
total 3 or more race including other races
- total_lat
total hispanic or latinos. It can be normalized using total_population
- total_lat_white_alone
total white in that category
- total_lat_blackaa_alone
total black or african american
- total_lat_native_alone
total american indian and alaska native
- total_lat_asian_alone
total asian
- total_lat_island_alone
total native hawaiaian and other pacific islander
- total_lat_other_race
total other race
- total_lat_2ormore
total 2 or more race
- total_lat2ormore_io
total 2 or more race including other races
- total_lat_3ormore_io
total 3 or more race including other races
- MEDICAL AND VACCINES
—————
- perc_imm65
percentage of fee-for-service (FFS) Medicare enrollees that had an annual flu vaccination.
- total_beds
total number of hospital beds
- acute_myocardial_infarction
percent medicare with acute myocardial infarction
- alzheimer_dementia
percent medicare with Alzheimer’s Disease, Related Disorders, or Senile Dementia
- asthma
percent medicare with asthma
- atrial_fibrillation
percent medicare with Atrial Fibrillation
- cancer_breast
percent medicare with Breast Cancer
- cancer_colorectal
percent medicare with Colorectal Cancer
- cancer_lung
percent medicare withLung Cancer
- cancer_all
percent medicare with Cancer (breast, colorectal, lung, and/or prostate)
- ch_obstructive_pulm
percent medicare with Chronic Obstructive Pulmonary Disease (COPD)
- chronic_kidney_disease
percent medicare with Chronic Kidney Disease
- depression
percent medicare with Depression
- diabetes
percent medicare beneficiaries with Diabetes
- hypertension
percent medicare beneficiaries with Hypertension
- ischemic_heart_disease
percent medicare beneficiaries with Ischemic Heart Disease
- obesity
percent medicare beneficiaries with Obesity
- osteoporosis
percent medicare beneficiaries with Osteoporosis
- rheumatoid_arthritis
percent medicare beneficiaries with Rheumatoid Arthritis
- schizophrenia_psychotic_dis
percent medicare beneficiaries with Schizophrenia/Other Psychotic Disorders
- stroke
percent medicare beneficiaries with Stroke Transient Ischemic Attack
- tobacco_use
- urgent_admission
urgent care admission rate
- annual_wellness_visit
number of annual wellness visits
- elective_admission
elective admission rate
- emergent_admission
ER admission rate
- other_admission
other admission rates
- pneumococcal_vaccine
percent pneumococcal vaccine
- POVERTY
—————
- total_poverty_determination
number of people evaluated for poverty
- total_poverty
total people that met the definition of below poverty level
- perc_poverty
percent people that met the definition of below poverty level
- total_determination age
total people evaluated in that age bin
- total_poverty age
total people that met the definition of below poverty level in that age bin
- perc_poverty age
percent people that met the definition of below poverty level in that age bin
- total_determination sex
total people evaluated for poverty in that sex
- total_poverty sex
total people that met the definition of below poverty level in that sex
- perc_poverty sex
perc people that met the definition of below poverty level in that sex
- total_determination race
total people evaluated for poverty in that race
- total_poverty race
total people that met the definition of below poverty level in that race
- perc_poverty race
perc people that met the definition of below poverty level in that race
- median_income)
median household income
- ACTIVITY
—————
- dex_a
activity index
- POLLUTIONS AND TEMPERATURE
—————
- pm2.5
pm2.5 in micro g per m3
- summer_temp
mean temperature in summer, F
- summer_hum
mean humity in summer, mixing ratio
- winter_temp
mean temperature in winter, F
- winter_hum
mean humity in winter, mixing ratio
- STATE LEVEL TESTS AND HOSPITALIZATIONS
—————
- positive
total cumulative positive test results
- negative
total cumulative negative test results
- pending
tests that have been submitted to a lab but no results have been reported yet
- hospitalized_curr
current people hospitalized
- hospitalized_cumul
cumulative people hospitalized
- icu_curr
current people in ICU
- icu_cumul
cumulative people in ICU
- ventilator_curr
current people using ventilator
- ventilator_cumul
cumulativepeople using ventilator
- recovered
total people recoverd
- death_increase
increase in deaths from day before
- hospitalized_increase
increase in hospitalization from day before
- negative_increase
increase in negative results from day before
- positive_increase
increase in positive results from day before
- total_test_increase
increase from the day before
Source
Center for Medicare and Medicaid Services,
Homeland Infrastructure Foundation-Level Data,
American Community Survey tables,
Mapping Medicare Disparities,
COVIDExposureIndices,
Atmoshpheric Composition Analysis Group
See Also
getus_covid,getus_tests, getus_dex,
c1au6i0/covid19census_dev documentation built on May 8, 2020, 1:01 a.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Description Usage Arguments Details Value Source See Also
View source: R/getus_functions.R
Description
extracts/joins COVID-19 info with other demographic metrics at the county level and tests and hospitalizations from the COVID Tracking Project
Usage
1 | getus_all(repo = "jhu")
|
Arguments
repo |
repository of COVID-19 data, one of |
Details
For details regarding some specific datasets refer to: Subject Definitions of the American Community Survey, Medicare and Medicaid Medical Services Technical Documentation, COVIDExposureIndices
Value
A dataframe with 330 variables. Data regarding the household composition, population sex, age, race, ancestry and poverty levels,
were scraped from the 2018 American Community Survey (ACS). Poverty was defined at the family level and not the household level in
the ACS. Medical conditions, tobacco use, cancer and, data relative to the number of medical and emergency visits
was obtained from the 2017 Mapping Medicare Disparities. From relative documentation listed in the source: "Prevalence rates are calculated
by searching for certain diagnosis codes in Medicare beneficiaries’ claims. The admission rate by admission type is the frequency of
a specific type of inpatient admission per 1,000 inpatient admissions in a year."
The number of hospital beds per county was calculated from data of the2020 Homeland Infrastructure Foundation.
Emissions of particulate 2.5 in micro g/m3 (2000-2016) and seasonal temperature (2000-2016) were reported by Atmoshpheric Composition Analysis Group and
aggregate by Ista Zahn and Ben Sabath.
The following list of variables is divided in sections COVID-19 VARS, HOUSEHOLDS MARITAL STATUS AND COMPOSITION, HOUSEHOLDS EDUCATION DEGREES,
ANCESTRY, COMPUTER OR INTERNET, POPULATION AND SEX, POPULATION AND RACE, MEDICAL AND VACCINES, POVERTY, ACTIVITY, POLLUTIONS AND TEMPERATURE, STATE LEVEL TESTS AND HOSPITALIZATIONS.
Note that data on test and hospitalizations are at the state level!
- date
formatted
ISO 8601- county
county
- state
state
- fips
federal information processing standard, a unique numeric identifier of a county. Unknown fips are coded as 00000. Note that in the nyt repository a lot of deaths and confirmed cases are no categorized at the county level
- urban
urban or rural (not sure about the definition)
- COVID-19 VARS
—————
- cases
confirmed COVID-19 cases (cumulates with date)
- deaths
number of deaths attributed to COVID-19
- cmr
case-mortality rate (deaths / confirmed cases * 100)
- HOUSEHOLDS MARITAL STATUS AND COMPOSITION
—————
- total_households
total number of households (occupy a housing unit) in that county. People not living in households are classified as living in group quarters
- perc_families
percent of households that are defined as family. A family consists of a householder and one or more other people living in the same household who are related to the householder by birth, marriage, or adoption
- perc_families_18childereen
percentfamilies with at least a child <= 18 years old
- perc_married_couples
percent families consisting of married couples
- perc_married_couples_u18ychildreen
percent families consisting of married couples at least a child 18 years old or less
- perc_families_only_male
percent of family with a male householder and no spouse of householder present
- perc_families_only_male_18ychildreen
percent families with male householder and no spouse of householder present and with at least a child under 18 years old
- perc_families_only_female
percent families with female householder
- perc_families_only_female_18ychildreen
percent families with female householder with at least a child under 18 years old
- perc_non_families
percent of non-family households. A family consists of a householder and one or more other people living in the same household who are related to the householder by birth, marriage, or adoption
- perc_non_families_alone
percent of non-family households with householder living alone
- perc_non_families_alone65y
percent of non-family households with householder living alone, age 65 years and older
- perc_non_families_u18y
percent of non-family households with one or more people under 18 years
- perc_non_families_65y
percent of non-family households with with one or more people 65 years and older
- total_relationship_in_households
total number of people that responded to the question regarding relationship
- perc_relationship_spouse
households including person married to and living with the householder
- perc_relationship_child
households including a son or daughter by birth, a stepchild, or adopted child of the householder
- perc_relationship_other_relatives
percent households including other relatives
- perc_relationship_other_nonrelatives
percent households including foster children, not related to the householder by birth, marriage, or adoption
- perc_relationship_other_unmaried_part
percent households containing members other than a “married-couple household” that includes a householder and an “unmarried partner.”
- total_marital_status_male
total males that responded to the marital status question
- perc_marital_status_male_nevermaried
percent males never married
- perc_marital_status_male_maried
percent males married
- perc_marital_status_male_separated
percent of males separate
- perc_marital_status_male_
percent of males widowed
- perc_marital_status_male_divorced
percent of males divorced
- perc_marital_status_female_nevermaried
perent of female never married
- perc_marital_status_female_maried
perent of female married
- perc_marital_status_female_separated
perent of female separated
- perc_marital_status_female_widowed
perent of female widowed
- perc_marital_status_female_divorced
perent of female divorced
- HOUSEHOLDS EDUCATION DEGREES
—————
- total_enrolled_school
total people enrolled in school
- perc_enrolled_preschool
percent in preschool
- perc_enrolled_kindergarden
percent in kindergarden
- perc_enrolled_elementary
percent in elementary
- perc_enrolled_highschool
percent in highschool
- perc_enrolled_college
percent college
- total_edu
total number of people 25 years old or more that responded to the question regarding education (?)
- perc_edu_9grade
percent that went up to 9th grade
- perc_edu_nodiploma
percent that went up to 9th grade
- perc_edu_highshool
percent with highschool
- perc_edu_somecollege
percent with some college
- perc_edu_associate
percent that obtaibed an associate degree
- perc_edu_bachelor
percent with batchelor
- perc_edu_gradprofess
percent that graduated or with a professional degree
- perc_edu_batchelor_higher
percent with batchelor or higher
- ANCESTRY
—————
- total_ancestry
total population
- perc_ anchestry
percent estimated specific ancestry (27)
- COMPUTER OR INTERNET
—————
- total_withcomputer
total that own or use a computer
- perc_withcomputer
percent that owns or use computer
- perc_withinternet
percet that has acces to internet
- POPULATION AND SEX
—————
- total_pop
total population
- total_male
total male
- total_female
total female
- total_ age_sex
total population by age bin and sex
- perc_ age_sex
percent population by age bin and sex
- POPULATION AND RACE
—————
- total_nlat
total not hispanic or latinos. It can be normalized using total_population
- total_nlat_white_alone
total white in that category
- total_nlat_blackaa_alone
total black or african american
- total_nlat_native_alone
total american indian and alaska native
- total_nlat_asian_alone
total asian
- total_nlat_island_alone
total native hawaiaian and other pacific islander
- total_nlat_other_race
total other race
- total_nlat_2ormore
total 2 or more race
- total_nlat2ormore_io
total 2 or more race including other races
- total_nlat_3ormore_io
total 3 or more race including other races
- total_lat
total hispanic or latinos. It can be normalized using total_population
- total_lat_white_alone
total white in that category
- total_lat_blackaa_alone
total black or african american
- total_lat_native_alone
total american indian and alaska native
- total_lat_asian_alone
total asian
- total_lat_island_alone
total native hawaiaian and other pacific islander
- total_lat_other_race
total other race
- total_lat_2ormore
total 2 or more race
- total_lat2ormore_io
total 2 or more race including other races
- total_lat_3ormore_io
total 3 or more race including other races
- MEDICAL AND VACCINES
—————
- perc_imm65
percentage of fee-for-service (FFS) Medicare enrollees that had an annual flu vaccination.
- total_beds
total number of hospital beds
- acute_myocardial_infarction
percent medicare with acute myocardial infarction
- alzheimer_dementia
percent medicare with Alzheimer’s Disease, Related Disorders, or Senile Dementia
- asthma
percent medicare with asthma
- atrial_fibrillation
percent medicare with Atrial Fibrillation
- cancer_breast
percent medicare with Breast Cancer
- cancer_colorectal
percent medicare with Colorectal Cancer
- cancer_lung
percent medicare withLung Cancer
- cancer_all
percent medicare with Cancer (breast, colorectal, lung, and/or prostate)
- ch_obstructive_pulm
percent medicare with Chronic Obstructive Pulmonary Disease (COPD)
- chronic_kidney_disease
percent medicare with Chronic Kidney Disease
- depression
percent medicare with Depression
- diabetes
percent medicare beneficiaries with Diabetes
- hypertension
percent medicare beneficiaries with Hypertension
- ischemic_heart_disease
percent medicare beneficiaries with Ischemic Heart Disease
- obesity
percent medicare beneficiaries with Obesity
- osteoporosis
percent medicare beneficiaries with Osteoporosis
- rheumatoid_arthritis
percent medicare beneficiaries with Rheumatoid Arthritis
- schizophrenia_psychotic_dis
percent medicare beneficiaries with Schizophrenia/Other Psychotic Disorders
- stroke
percent medicare beneficiaries with Stroke Transient Ischemic Attack
- tobacco_use
- urgent_admission
urgent care admission rate
- annual_wellness_visit
number of annual wellness visits
- elective_admission
elective admission rate
- emergent_admission
ER admission rate
- other_admission
other admission rates
- pneumococcal_vaccine
percent pneumococcal vaccine
- POVERTY
—————
- total_poverty_determination
number of people evaluated for poverty
- total_poverty
total people that met the definition of below poverty level
- perc_poverty
percent people that met the definition of below poverty level
- total_determination age
total people evaluated in that age bin
- total_poverty age
total people that met the definition of below poverty level in that age bin
- perc_poverty age
percent people that met the definition of below poverty level in that age bin
- total_determination sex
total people evaluated for poverty in that sex
- total_poverty sex
total people that met the definition of below poverty level in that sex
- perc_poverty sex
perc people that met the definition of below poverty level in that sex
- total_determination race
total people evaluated for poverty in that race
- total_poverty race
total people that met the definition of below poverty level in that race
- perc_poverty race
perc people that met the definition of below poverty level in that race
- median_income)
median household income
- ACTIVITY
—————
- dex_a
activity index
- POLLUTIONS AND TEMPERATURE
—————
- pm2.5
pm2.5 in micro g per m3
- summer_temp
mean temperature in summer, F
- summer_hum
mean humity in summer, mixing ratio
- winter_temp
mean temperature in winter, F
- winter_hum
mean humity in winter, mixing ratio
- STATE LEVEL TESTS AND HOSPITALIZATIONS
—————
- positive
total cumulative positive test results
- negative
total cumulative negative test results
- pending
tests that have been submitted to a lab but no results have been reported yet
- hospitalized_curr
current people hospitalized
- hospitalized_cumul
cumulative people hospitalized
- icu_curr
current people in ICU
- icu_cumul
cumulative people in ICU
- ventilator_curr
current people using ventilator
- ventilator_cumul
cumulativepeople using ventilator
- recovered
total people recoverd
- death_increase
increase in deaths from day before
- hospitalized_increase
increase in hospitalization from day before
- negative_increase
increase in negative results from day before
- positive_increase
increase in positive results from day before
- total_test_increase
increase from the day before
Source
Center for Medicare and Medicaid Services, Homeland Infrastructure Foundation-Level Data, American Community Survey tables, Mapping Medicare Disparities, COVIDExposureIndices, Atmoshpheric Composition Analysis Group
See Also
getus_covid,getus_tests, getus_dex,
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.