Estimated Prevalence and New Diagnoses of HIV and HIV among Injection Drug Users 2012 - Current County Annual Health
This data set provides an estimate of the number of people living with Human Immunodeficiency Virus (HIV) Disease at the end of each year for 2012 through 2016 and the number of these persons who have injection drug use identified as the primary risk for having acquired the infection. The data sets also provides the number of new diagnoses of HIV Disease by county among all persons and among those with injection drug identified as the primary risk. These data are derived through HIV surveillance activities of the Pennsylvania Department of Health. Laboratories and providers are required to report HIV test results for all individuals with a result that indicates the presence of HIV infection. These include detectable viral load results and CD4 results below 200 cells. These data are reported electronically to the Pennsylvania National Electronic Disease Surveillance System. The most recent patient address information obtained from all reports (both HIV and non-HIV reports) is used to identify last known county of residence in 2016. Cases are also matched to lists that identify individuals who have been reported to be living outside of Pennsylvania by the US Centers for Disease Control and Prevention (CDC) to remove cases that are presumed to have moved from Pennsylvania. Address data for Philadelphia County cases are extracted from the Pennsylvania enhanced HIV/AIDS Reporting System.
IDU: use of non-prescribed injection drugs (e.g., heroin, fentanyl, cocaine, etc.)
HIV Disease: Confirmed infection with the Human Immunodeficiency Virus (HIV). Acquired Immunodeficiency Syndrome (AIDS) is a stage of HIV Disease marked by a low CD4 count and/or certain co-morbid conditions.
Querying over HTTP
Splitgraph serves as an HTTP API that lets you run SQL queries directly on
this data to power Web applications. For example:
curl https://data.splitgraph.com/sql/query/ddn \
-H "Content-Type: application/json" \
-d@-<<EOF
{"sql": "
SELECT *
FROM \"pa-gov/estimated-prevalence-and-new-diagnoses-of-hiv-and-buk2-94cb\".\"estimated_prevalence_and_new_diagnoses_of_hiv_and\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.