COVID 19 Statistics San Diego County

Official COVID-19 statistics for San Diego County.

sandiegocounty.gov-covid19-1.1.40. Modified 2020-08-14T18:09:29

Resources | Packages | Documentation| Contacts| Data Dictionary

Resources

Documentation

Contacts

  • Wrangler

    Eric Busboom, Civic Knowledge

  • Origin

    County of San Diego, Health and Human Services Agency, Public Health Services, Epidemiology and Immunization Services Branch

Data Dictionary

covid_stats | covid_jurisdiction | covid_jurisdiction_geo | covid_zip | covid_zip_geo

covid_stats

Column NameData TypeDescription
xnumber
ynumber
fidinteger
datedatetime
testsinteger
positivesinteger
hospitalizedinteger
icuinteger
deathsinteger
newcasesinteger
age_9integer
age10_19integer
age40_49integer
age50_59integer
age60_69integer
age70_79integer
age80_plusinteger
ageunknowinteger
age20_29integer
genderfemaleinteger
gendermaleinteger
gendeunkinteger
age30_39integer
globalidstring
newtestsinteger

covid_jurisdiction

Column NameData TypeDescription
xnumber
ynumber
fidinteger
namestring
loctypestring
lastupdatedatetime
confirmedcasesinteger
globalidstring

covid_jurisdiction_geo

Column NameData TypeDescription
idinteger
fidinteger
namestring
loctypestring
lastupdatedate
confirmedcinteger
globalidstring
geometrystring

covid_zip

Column NameData TypeDescription
xnumber
ynumber
fidinteger
zipcode_zipinteger
ziptextinteger
case_countinteger
updatedatedatetime
created_datedatetime
created_userstring
last_edited_datedatetime
last_edited_userstring
globalidstring

covid_zip_geo

Column NameData TypeDescription
idinteger
fidinteger
zipcode_ziinteger
ziptextinteger
case_countinteger
updatedatedate
created_dadate
created_usstring
last_editedate
last_edi_1string
globalidstring
geometrystring

Packages

Accessing Data in Vanilla Pandas

import pandas as pd


covid_stats_df =  pd.read_csv('http://library.metatab.org/sandiegocounty.gov-covid19-1.1.40/data/covid_stats.csv')
covid_jurisdiction_df =  pd.read_csv('http://library.metatab.org/sandiegocounty.gov-covid19-1.1.40/data/covid_jurisdiction.csv')
covid_jurisdiction_geo_df =  pd.read_csv('http://library.metatab.org/sandiegocounty.gov-covid19-1.1.40/data/covid_jurisdiction_geo.csv')
covid_zip_df =  pd.read_csv('http://library.metatab.org/sandiegocounty.gov-covid19-1.1.40/data/covid_zip.csv')
covid_zip_geo_df =  pd.read_csv('http://library.metatab.org/sandiegocounty.gov-covid19-1.1.40/data/covid_zip_geo.csv')

Accessing Package in Metapack

import metapack as mp
pkg = mp.open_package('http://library.metatab.org/sandiegocounty.gov-covid19-1.1.40.csv')

# Create Dataframes
covid_stats_df = pkg.resource('covid_stats').dataframe()
covid_jurisdiction_df = pkg.resource('covid_jurisdiction').dataframe()
covid_jurisdiction_geo_gdf = pkg.resource('covid_jurisdiction_geo').geoframe()
covid_zip_df = pkg.resource('covid_zip').dataframe()
covid_zip_geo_gdf = pkg.resource('covid_zip_geo').geoframe()