Data·Citizenan agentic layer over NYC Open Data
CatalogExploreAnalyticsMapAsk the agentFindingsGuideStatus
Data from NYC Open Data via the Socrata Discovery API. Quality scores are computed from a sample and are indicative, not authoritative.
← Catalog

DOHMH HIV/AIDS Annual Report

fju2-rdadHealth18 columns
HIV/AIDS data from the HIV Surveillance Annual Report Data reported to the HIV Epidemiology Program by March 31, 2022. All data shown are for people ages 18 and older. Borough-wide and citywide totals may include cases assigned to a borough with an unknown UHF or assigned to NYC with an unknown borough, respectively. Therefore, UHF totals may not sum to borough totals and borough totals may not sum to citywide totals.""
View on NYC Open Data↗

Quality

B84.6 / 100

From a 500-row sample across 18 columns.

completeness100/ 25% weight
consistency64/ 20% weight
accuracy91/ 20% weight
timeliness57/ 15% weight
usability100/ 20% weight
  • · Has geographic keys — joinable to other NYC datasets

Related datasets

  • Pregnancy-Associated Mortality0.33
    joins onyearboroughdeaths
  • HIV/AIDS Diagnoses by Neighborhood, Sex, and Race/Ethnicity (Historical)0.32
    joins onyearboroughrace
  • Recognized Shop Healthy Stores0.32
    joins onborough
  • DOHMH Community Mental Health Survey0.32
    joins onyear
  • Youth Behavior Risk Survey (High School)0.31
    joins onyear

Geography

Has borough codes (`borough`) — joinable, but needs boundary shapes to draw.

Sample rows

yearboroughuhfgenderageracehiv_diagnoseshiv_diagnosis_rateconcurrent_diagnoseslinked_to_care_within_3_monthsaids_diagnosesaids_diagnosis_rate
2011AllAllAllAllAll337948.364066236633.8
2011All

Columns

18 queryable · 18 profiled

The machine field names SoQL needs, with the publisher's own description of each.

FieldTypeDescriptionNullValues
yearcategoricalCalendar year0%202020212022of 11
boroughcategoricalBorough of residence at HIV diagnosis for HIV diagnoses, HIV diagnosis rate, Concurrent diagnoses, and % linked to care within 3 months; Borough of residence at AIDS diagnosis for AIDS diagnoses and AIDS diagnosis rates; Borough of residence at most recent address for PLWDHI prevalence and % viral suppression; Borough of residence at death for Deaths and all death rates.0%BrooklynQueensManhattanof 6
uhftextUnited Hospital Fund neighborhood of residence at HIV diagnosis for HIV diagnoses, HIV diagnosis rates, Concurrent diagnoses, and % Linked to care within 3 months; UHF of residence at AIDS diagnosis for AIDS diagnoses and AIDS diagnosis rates; UHF of residence at most recent address for PLWDHI prevalence and % viral suppression; UHF of residence at death for Deaths and all death rates.0%AllWest Queens

Query this from your own app

GET /api/datasets/fju2-rdad
GET /api/datasets/fju2-rdad/quality
GET /api/datasets/fju2-rdad/related
GET /api/columns?dataset=fju2-rdad
Children Under 6 yrs with Elevated Blood Lead Levels (BLL)0.31
  • NYC Cooling Tower System Inspection Results0.31
    joins onborough
  • New York City Community Health Survey0.31
    joins onyear
    • All
    Male
    All
    All
    2595
    79.1
    480
    66
    1712
    52.2
    2011AllAllFemaleAllAll73321.11536662217.6
    2011AllAllTransgenderAllAll51999997633299999
    2011AllAllFemale13 - 19All4713.6464226.4
    2011AllAllFemale20 - 29All17824.720679613.3
    2011AllAllFemale30 - 39All17626.9316613320.3
    2011AllAllFemale40 - 49All19533.0506221035.5
    2011AllAllFemale50 - 59All13023.5327213324.0
    2011AllAllFemale60+All576.72368607.1

    Showing 12 of 18 columns. All of them are listed below.

    Greenpoint
    gendercategoricalGender: when Borough, UHF, Age, and Race categories are all equal to 'All', Gender is displayed as Male, Female, and Transgender (mutually exclusive categories). In all other rows, Male includes transgender men and Female includes transgender women.0%AllWomenMenof 6
    agecategoricalAge at HIV diagnosis for HIV diagnoses, HIV diagnosis rates, Concurrent diagnoses, and % Linked to care within 3 months; Age at AIDS diagnosis for AIDS diagnoses and AIDS diagnosis rates; Age as of the end of the given year for PLWDHI prevalence and % viral suppression; Age at death for Deaths and all death rates.0%All30 - 3940 - 49of 8
    racecategoricalRace/ethnicity; Other/Unknown category includes people of Native American, multiracial, and unknown races.0%AllWhiteOther/Unknownof 7
    hiv_diagnosesintegerNumber of HIV diagnoses 13 years of age or older, including those concurrent with AIDS, excluding people known to have been diagnosed outside of NYC1%012
    hiv_diagnosis_ratefloatHIV diagnoses per 100,000 NYC population using annual intercensal population estimates *‘99999’ value indicates suppressed cell representing 1-5 person(s) with an underlying denominator of <=500 people or non-zero cell with a denominator <=100.1%0.05.24.9
    concurrent_diagnosesintegerNumber of HIV diagnoses 13 years of age or older with a concurrent AIDS diagnosis (within 31 days)0%012
    linked_to_care_within_3_monthsfloatProportion of new HIV diagnoses with an HIV viral load or CD4 test drawn within 3 months (91 days) of HIV diagnosis, following a 7-day lag *‘99999’ value indicates proportion is not calculated because the underlying denominator is equal to zero or is unknown.43%1999990
    aids_diagnosesintegerNumber of AIDS diagnoses 13 years of age or older. *‘99999’ value indicates suppressed cell representing 1-5 person(s) with an underlying denominator of <=500 people or non-zero cell with a denominator <=100.1%012
    aids_diagnosis_ratefloatAIDS diagnoses per 100,000 NYC population using annual intercensal population estimates. *‘99999’ value indicates rate is not calculated because the underlying denominator is equal to zero or is unknown.1%0.05.65.5
    plwdhi_prevalencefloatEstimated number of people 13 years of age or older living with diagnosed HIV infection (PLWDHI) per 100 NYC population using annual intercensal population estimates. *‘99999’ value indicates rate is not calculated because the underlying denominator is equal to zero or is unknown.11%0.00.10.2
    viral_suppressionfloatProportion of people living with diagnosed HIV infection 13 years of age or older with at least one viral load test during the calendar year whose last HIV viral load value was ≤200 copies/mL. *‘99999’ value indicates proportion is not calculated because the underlying denominator is equal to zero or is unknown.6%10.860.8
    deathsintegerNumber of deaths from any cause among people with HIV/AIDS 13 years of age or older. *‘99999’ value indicates suppressed cell representing 1-5 person(s) with an underlying denominator of <=500 people or non-zero cell with a denominator <=100.0%012
    death_ratefloatDeaths per 1,000 mid-year people living with HIV/AIDS, excluding deaths in which the person was diagnosed with HIV at the time of death or up to 15 days prior to death. Deaths are age-adjusted to the NYC Census 2010 population and include deaths from any cause (including unknown causes).6%0.07.86.4
    hiv_related_death_ratefloatDeath rate for those assigned an HIV-related cause of death. *‘99999’ value indicates rate is not calculated because the underlying denominator is equal to zero or is unknown.6%0.0999992.6
    non_hiv_related_death_ratefloatDeath rate for those assigned a non-HIV-related cause of death. *‘99999’ value indicates rate is not calculated because the underlying denominator is equal to zero or is unknown.6%0.0999994.9