ED Violence Data Form

[NCIPC] Advancing Violence Epidemiology in Real-Time (AVERT)

Attachment E_Proposed Change_ED Violence data form_Clean_OMB_final.xlsx

AVERT Data Submission Form

OMB: 0920-1414

Document [xlsx]
Download: xlsx | pdf

Overview

Variable Definition
Metadata
ScholAge_Violence
ScholAge_Mental
NCHS_Violence
NCHS_Mental
County Report


Sheet 1: Variable Definition

Variables Definition







Jurisdiction The two-digit state abbreviation (e.g., GA)







Year The four digit calendar year (e.g., 2019)







Month The full name of the month (e.g., January)







Sex Three categories: male, female, missing







Age_Group School Age: 5 categories: 0-4, 5-11, 12-17, 18-24, missing NCHS Age: 9 categories: 0-10, 11-14, 15-24, 25-34, 35-44, 45-54, 55-64, 65+, missing

New categories are highlighted in yellow




Calculated Race and Ethnicity Combined 8 categories: 1) American Indian or Alaska Native and non-Hispanic; 2) Asian and non-Hispanic; 3) Black or African American and non-Hispanic; 4) Native Hawaiian or Other Pacific Islander and non-Hispanic; 5) White and non-Hispanic; 6) Multiracial/Other and non Hispanic; 7)Hispanic or Latino; 8) Unknown

If age groups are not applicable for the syndrome definition, the information will not be collected and will be grey out.




County_name Exact name of the County within each jurisdiction (e.g., Adams). Please exclude the word "county" after the county name (e.g., do not list "Adams County"). Note that county is county of patient residence.







County_FIPS Five character FIPS code for the County within each jurisdication where the first two digits are the state code and the last three digits are the county code (e.g., 12345). Note that county is county of patient residence.
Tab Name Metadata ScholAge_Violence ScholAge_Mental NCHS_Violence NCHS_Mental Total # of Cells
Overall_FA_visits_n The number of ED visits for each required month related to an initial encounter of a firearm injury, including the following types: unintentional, intentional self-directed, assault, legal intervention, terrorism, and undetermined intent.
Original Version 13 0 0 2,970 3,960 6,943
Unintentional_FA_visits_n The number of ED visits for each required month related related to an initial encounter of an unintentional firearm injury and should be a subset of overall_FA_visits_n.
Proposed Version 15 984 1,104 1,584 2,280 5,967
IntentionalSD_FA_visits_n The number of ED visits for each required month related to an initial encounter of an intentional self-directed firearm injury, or a self-harm injury from a firearm and should be a subset of overall_FA_visits_n.







Assault_FA_visits_n The number of ED visits for each required month related to an initial encounter of an assault-related firearm injury and should be a subset of overall_FA_visits_n.







IPV_visits_n The number of ED visits for each required month related to related to intimate partner violence.




Form Approved OMB Control No.: 0920-1414 Exp. Date: 09/30/2026
 OMB NO: 0920-XXXX
 Exp. Date: xx/xx/xxx

SV_visits_n The number of ED visits for each required month related to sexual violence.





YV_visits_n The number of ED visits for each required month related to youth violence.





CAN_visits_n (<18) The number of ED visits for each required month related to suspected child abuse or neglect categorized as visits related to suspected or confirmed physical, sexual, or emotional abuse; and physical or emotional neglect as perpetrated by parents, caregivers, or an authorized custodian of the child.


Public reporting burden of this collection of information is estimated to average 30 minutes per response, including the time for reviewing instructions, searching existing data sources, gathering, and maintaining the data needed, and completing and reviewing the collection of information. An agency may not conduct or sponsor, and a person is not required to respond to a collection of information unless it displays a currently valid OMB control number. Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing this burden to CDC/Information Collection Review Office, 1600 Clifton Road, NE, MS H21-8, Atlanta, GA 30333; Attn: PRA (0920-1414).

Overall_MH_visits_n The number of ED visits for each required month related to mental health conditions, including anxiety-related disorders, depression or depressive disorders, bipolar disorder, schizophrenia spectrum disorders, trauma or stress-related disorders, attention deficit hyperactivity disorder, disruptive behavioral and impulse control disorders, obsessive compulsive disorders, eating disorders, or tic disorders.


Anxiety_MH_visits_n The number of ED visits for each required month identifying visits among persons experiencing anxiety-related disorders and should be a subset of overall_MH_visits_n.







Depressive_MH_visits_n The number of ED visits for each required month identifying visits among persons experiencing depression or depressive disorders and should be a subset of overall_MH_visits_n.







Bipolar_MH_visits_n The number of ED visits for each required month identifying visits among persons experiencing bipolar disorder and should be a subset of overall_MH_visits_n.







Schizophrenia_MH_visits_n The number of ED visits for each required month identifying visits among persons experiencing schizophrenia spectrum disorders and should be a subset of overall_MH_visits_n.







Trauma_MH_visits_n The number of ED visits for each required month identifying visits among persons experiencing trauma or stress-related disorders and should be a subset of overall_MH_visits_n.







ADHD_MH_visits_n The number of ED visits for each required month identifying visits among persons seeking emergent or ambulatory healthcare for attention deficit hyperactivity disorder and should be a subset of overall_MH_visits_n.







DBI_MH_visits_n The number of ED visits for each required month identifying visits among persons experiencing disruptive behavior or impulse control disorders and should be a subset of overall_MH_visits_n.







OC_MH_visits_n The number of ED visits for each required month identifying visits among persons experiencing obsessive compulsive disorders and should be a subset of overall_MH_visits_n.







ED_MH_visits_n The number of ED visits for each required month identifying visits among persons experiencing eating disorders and should be a subset of overall_MH_visits_n.







TD_MH_visits_n The number of ED visits for each required month identifying visits among persons experiencing tic disorders and should be a subset of overall_MH_visits_n.







Total_ED_visits The total number of ED visits for each required month that were included in the analysis.








Sheet 2: Metadata

Describe and provide metadata on this rapid report of ED visits involving firearm injuries, other violence-related injuries, and mental health conditions.

















1. Approximately what percent of ED visits in your state or jurisdiction were included in your analysis? (Enter a percentage such as "75%")












Cells need to fill













Original Version 13













New Version 15















2. Timeliness of ED visits received in NSSP ESSENCE:













2a. % of ED visits received within 24 Hrs












2b. % of ED visits received within 24-48 Hrs












2c. % of ED visits received after 48 Hrs



























3. How many total facilities are included in your analysis for this data submission? (Enter a number such as "22")


























































4. Report the percent of all ED visits in this data submission missing chief complaint data. (Enter a percentage such as "10%")


























































5. Report the median string length of text from chief complaint data. (Enter a number such as "5 words")


























































6. Report the percent of all ED visits in this data submission that have no discharge diagnosis codes (e.g., ICD-10-CM). (Enter a percentage such as "15%")


























































7. What was the maximum number of discharge diagnosis codes (e.g., ICD-10-CM) entered for a single ED visit in this data submission? (Enter a number such "10")


























































8. What was the mean number of diagnosis codes (e.g., ICD-10-CM) that were entered for all ED visits in this data submissions? (Enter a number such as "8")


























































9. Report the percent of all ED visits in this data submission missing race data. (Enter a percentage such as "15%")


























































10. Report the percent of all ED visits in this data submission missing ethnicity data. (Enter a percentage such as "15%")


























































11. Please identify any major issues that impact the quality of data shared during this data submission time period:
















































12. Who should CDC contact with questions about this data report?





























Name:






















Email:






















Sheet 3: ScholAge_Violence

ED visits for firearm injuries, other violence-related injuries by sex and age group and race/ethnicity at the jurisdictional level






















Jurisdiction Year Month Sex Age_Group Calculated Race and Ethnicity Combined Overall_FA_visits_n Unintentional_FA_visits_n IntentionalSD_FA_visits_n Assault_FA_visits_n IPV_visits_n SV_visits_n CAN_visits_n YV_visits_n Total_ED_visits Check_Result





Female 0-4 American Indian or Alaska Native and non-Hispanic








#REF!

Cells need to fill



Female 0-4 Asian and non-Hispanic








#REF!
Original Version 0



Female 0-4 Black or African American and non-Hispanic








#REF!
New Version 3(Ssex)*5(age)*8(R/E)*9(ccdd)-16*3(IPV)-8*3(CAN)-8*3(YV)=1080-48-24-24=984



Female 0-4 Native Hawaiian or Other Pacific Islander and non-Hispanic








#REF!
New-Original 984-0=984



Female 0-4 White and non-Hispanic








#REF!





Female 0-4 Multiracial/Other and non Hispanic








#REF!





Female 0-4 Hispanic or Latino








#REF!





Female 0-4 Unknown








#REF!





Female 05-11 American Indian or Alaska Native and non-Hispanic








#REF!





Female 05-11 Asian and non-Hispanic








#REF!





Female 05-11 Black or African American and non-Hispanic








#REF!





Female 05-11 Native Hawaiian or Other Pacific Islander and non-Hispanic








#REF!





Female 05-11 White and non-Hispanic








#REF!





Female 05-11 Multiracial/Other and non Hispanic








#REF!





Female 05-11 Hispanic or Latino








#REF!





Female 05-11 Unknown








#REF!





Female 12-17 American Indian or Alaska Native and non-Hispanic








#REF!





Female 12-17 Asian and non-Hispanic








#REF!





Female 12-17 Black or African American and non-Hispanic








#REF!





Female 12-17 Native Hawaiian or Other Pacific Islander and non-Hispanic








#REF!





Female 12-17 White and non-Hispanic








#REF!





Female 12-17 Multiracial/Other and non Hispanic








#REF!





Female 12-17 Hispanic or Latino








#REF!





Female 12-17 Unknown








#REF!





Female 18-24 American Indian or Alaska Native and non-Hispanic








#REF!





Female 18-24 Asian and non-Hispanic








#REF!





Female 18-24 Black or African American and non-Hispanic








#REF!





Female 18-24 Native Hawaiian or Other Pacific Islander and non-Hispanic








#REF!





Female 18-24 White and non-Hispanic








#REF!





Female 18-24 Multiracial/Other and non Hispanic








#REF!





Female 18-24 Hispanic or Latino








#REF!





Female 18-24 Unknown








#REF!





Female Missing American Indian or Alaska Native and non-Hispanic








#REF!





Female Missing Asian and non-Hispanic








#REF!





Female Missing Black or African American and non-Hispanic








#REF!





Female Missing Native Hawaiian or Other Pacific Islander and non-Hispanic








#REF!





Female Missing White and non-Hispanic








#REF!





Female Missing Multiracial/Other and non Hispanic








#REF!





Female Missing Hispanic or Latino








#REF!





Female Missing Unknown








#REF!





Male 0-4 American Indian or Alaska Native and non-Hispanic








#REF!





Male 0-4 Asian and non-Hispanic








#REF!





Male 0-4 Black or African American and non-Hispanic








#REF!





Male 0-4 Native Hawaiian or Other Pacific Islander and non-Hispanic








#REF!





Male 0-4 White and non-Hispanic








#REF!





Male 0-4 Multiracial/Other and non Hispanic








#REF!





Male 0-4 Hispanic or Latino








#REF!





Male 0-4 Unknown








#REF!





Male 05-11 American Indian or Alaska Native and non-Hispanic








#REF!





Male 05-11 Asian and non-Hispanic








#REF!





Male 05-11 Black or African American and non-Hispanic








#REF!





Male 05-11 Native Hawaiian or Other Pacific Islander and non-Hispanic








#REF!





Male 05-11 White and non-Hispanic








#REF!





Male 05-11 Multiracial/Other and non Hispanic








#REF!





Male 05-11 Hispanic or Latino








#REF!





Male 05-11 Unknown








#REF!





Male 12-17 American Indian or Alaska Native and non-Hispanic








#REF!





Male 12-17 Asian and non-Hispanic








#REF!





Male 12-17 Black or African American and non-Hispanic








#REF!





Male 12-17 Native Hawaiian or Other Pacific Islander and non-Hispanic








#REF!





Male 12-17 White and non-Hispanic








#REF!





Male 12-17 Multiracial/Other and non Hispanic








#REF!





Male 12-17 Hispanic or Latino








#REF!





Male 12-17 Unknown








#REF!





Male 18-24 American Indian or Alaska Native and non-Hispanic








#REF!





Male 18-24 Asian and non-Hispanic








#REF!





Male 18-24 Black or African American and non-Hispanic








#REF!





Male 18-24 Native Hawaiian or Other Pacific Islander and non-Hispanic








#REF!





Male 18-24 White and non-Hispanic








#REF!





Male 18-24 Multiracial/Other and non Hispanic








#REF!





Male 18-24 Hispanic or Latino








#REF!





Male 18-24 Unknown








#REF!





Male Missing American Indian or Alaska Native and non-Hispanic








#REF!




Male Missing Asian and non-Hispanic








#REF!



Male Missing Black or African American and non-Hispanic








#REF!



Male Missing Native Hawaiian or Other Pacific Islander and non-Hispanic








#REF!



Male Missing White and non-Hispanic








#REF!



Male Missing Multiracial/Other and non Hispanic








#REF!



Male Missing Hispanic or Latino








#REF!



Male Missing Unknown








#REF!



Missing 0-4 American Indian or Alaska Native and non-Hispanic








#REF!



Missing 0-4 Asian and non-Hispanic








#REF!



Missing 0-4 Black or African American and non-Hispanic








#REF!



Missing 0-4 Native Hawaiian or Other Pacific Islander and non-Hispanic








#REF!



Missing 0-4 White and non-Hispanic








#REF!



Missing 0-4 Multiracial/Other and non Hispanic








#REF!



Missing 0-4 Hispanic or Latino








#REF!



Missing 0-4 Unknown








#REF!



Missing 05-11 American Indian or Alaska Native and non-Hispanic








#REF!



Missing 05-11 Asian and non-Hispanic








#REF!



Missing 05-11 Black or African American and non-Hispanic








#REF!



Missing 05-11 Native Hawaiian or Other Pacific Islander and non-Hispanic








#REF!



Missing 05-11 White and non-Hispanic








#REF!



Missing 05-11 Multiracial/Other and non Hispanic








#REF!



Missing 05-11 Hispanic or Latino








#REF!



Missing 05-11 Unknown








#REF!



Missing 12-17 American Indian or Alaska Native and non-Hispanic








#REF!



Missing 12-17 Asian and non-Hispanic








#REF!



Missing 12-17 Black or African American and non-Hispanic








#REF!



Missing 12-17 Native Hawaiian or Other Pacific Islander and non-Hispanic








#REF!



Missing 12-17 White and non-Hispanic








#REF!



Missing 12-17 Multiracial/Other and non Hispanic








#REF!



Missing 12-17 Hispanic or Latino








#REF!



Missing 12-17 Unknown








#REF!



Missing 18-24 American Indian or Alaska Native and non-Hispanic








#REF!



Missing 18-24 Asian and non-Hispanic








#REF!





Missing 18-24 Black or African American and non-Hispanic








#REF!





Missing 18-24 Native Hawaiian or Other Pacific Islander and non-Hispanic








#REF!





Missing 18-24 White and non-Hispanic








#REF!





Missing 18-24 Multiracial/Other and non Hispanic








#REF!





Missing 18-24 Hispanic or Latino








#REF!





Missing 18-24 Unknown








#REF!





Missing Missing American Indian or Alaska Native and non-Hispanic








#REF!





Missing Missing Asian and non-Hispanic








#REF!





Missing Missing Black or African American and non-Hispanic








#REF!





Missing Missing Native Hawaiian or Other Pacific Islander and non-Hispanic








#REF!





Missing Missing White and non-Hispanic








#REF!





Missing Missing Multiracial/Other and non Hispanic








#REF!





Missing Missing Hispanic or Latino








#REF!





Missing Missing Unknown








#REF!



Sheet 4: ScholAge_Mental

ED visits for mental health conditions by sex and age group and race/ethnicity at the jurisdictional level

























Jurisdiction Year Month Sex Age_Group Calculated Race and Ethnicity Combined Overall_MH_visits_n Anxiety_MH_visits_n Depressive_MH_visits_n Bipolar_MH_visits_n Schizophrenia_MH_visits_n Trauma_MH_visits_n ADHD_MH_visits_n DBI_MH_visits_n OC_MH_visits_n ED_MH_visits_n TD_MH_visits_n Total_ED_visits Check_Result





Female 0-4 American Indian or Alaska Native and non-Hispanic











#REF!

Cells need to fill



Female 0-4 Asian and non-Hispanic











#REF!
Original Version 0



Female 0-4 Black or African American and non-Hispanic











#REF!
New Version 3(sex)*[5(age groups)*8(R/E)*12(categories)]-3(sex)[8(R/E)*11(categories)]-3(sex)*24(0-17age)=1440-264-72=1104



Female 0-4 Native Hawaiian or Other Pacific Islander and non-Hispanic











#REF!
New-Original 1104-0= 1104



Female 0-4 White and non-Hispanic











#REF!





Female 0-4 Multiracial/Other and non Hispanic











#REF!





Female 0-4 Hispanic or Latino











#REF!





Female 0-4 Unknown











#REF!





Female 05-11 American Indian or Alaska Native and non-Hispanic











#REF!





Female 05-11 Asian and non-Hispanic











#REF!





Female 05-11 Black or African American and non-Hispanic











#REF!





Female 05-11 Native Hawaiian or Other Pacific Islander and non-Hispanic











#REF!





Female 05-11 White and non-Hispanic











#REF!





Female 05-11 Multiracial/Other and non Hispanic











#REF!





Female 05-11 Hispanic or Latino











#REF!





Female 05-11 Unknown











#REF!





Female 12-17 American Indian or Alaska Native and non-Hispanic











#REF!





Female 12-17 Asian and non-Hispanic











#REF!





Female 12-17 Black or African American and non-Hispanic











#REF!





Female 12-17 Native Hawaiian or Other Pacific Islander and non-Hispanic











#REF!





Female 12-17 White and non-Hispanic











#REF!





Female 12-17 Multiracial/Other and non Hispanic











#REF!





Female 12-17 Hispanic or Latino











#REF!





Female 12-17 Unknown











#REF!





Female 18-24 American Indian or Alaska Native and non-Hispanic











#REF!





Female 18-24 Asian and non-Hispanic











#REF!





Female 18-24 Black or African American and non-Hispanic











#REF!





Female 18-24 Native Hawaiian or Other Pacific Islander and non-Hispanic











#REF!





Female 18-24 White and non-Hispanic











#REF!





Female 18-24 Multiracial/Other and non Hispanic











#REF!





Female 18-24 Hispanic or Latino











#REF!





Female 18-24 Unknown











#REF!





Female Missing American Indian or Alaska Native and non-Hispanic











#REF!





Female Missing Asian and non-Hispanic











#REF!





Female Missing Black or African American and non-Hispanic











#REF!





Female Missing Native Hawaiian or Other Pacific Islander and non-Hispanic











#REF!





Female Missing White and non-Hispanic











#REF!





Female Missing Multiracial/Other and non Hispanic











#REF!





Female Missing Hispanic or Latino











#REF!





Female Missing Unknown











#REF!





Male 0-4 American Indian or Alaska Native and non-Hispanic











#REF!





Male 0-4 Asian and non-Hispanic











#REF!





Male 0-4 Black or African American and non-Hispanic











#REF!





Male 0-4 Native Hawaiian or Other Pacific Islander and non-Hispanic











#REF!





Male 0-4 White and non-Hispanic











#REF!





Male 0-4 Multiracial/Other and non Hispanic











#REF!





Male 0-4 Hispanic or Latino











#REF!





Male 0-4 Unknown











#REF!





Male 05-11 American Indian or Alaska Native and non-Hispanic











#REF!





Male 05-11 Asian and non-Hispanic











#REF!





Male 05-11 Black or African American and non-Hispanic











#REF!





Male 05-11 Native Hawaiian or Other Pacific Islander and non-Hispanic











#REF!





Male 05-11 White and non-Hispanic











#REF!





Male 05-11 Multiracial/Other and non Hispanic











#REF!





Male 05-11 Hispanic or Latino











#REF!





Male 05-11 Unknown











#REF!





Male 12-17 American Indian or Alaska Native and non-Hispanic











#REF!





Male 12-17 Asian and non-Hispanic











#REF!





Male 12-17 Black or African American and non-Hispanic











#REF!





Male 12-17 Native Hawaiian or Other Pacific Islander and non-Hispanic











#REF!





Male 12-17 White and non-Hispanic











#REF!





Male 12-17 Multiracial/Other and non Hispanic











#REF!





Male 12-17 Hispanic or Latino











#REF!





Male 12-17 Unknown











#REF!





Male 18-24 American Indian or Alaska Native and non-Hispanic











#REF!





Male 18-24 Asian and non-Hispanic











#REF!





Male 18-24 Black or African American and non-Hispanic











#REF!





Male 18-24 Native Hawaiian or Other Pacific Islander and non-Hispanic











#REF!





Male 18-24 White and non-Hispanic











#REF!





Male 18-24 Multiracial/Other and non Hispanic











#REF!





Male 18-24 Hispanic or Latino











#REF!





Male 18-24 Unknown











#REF!





Male Missing American Indian or Alaska Native and non-Hispanic











#REF!





Male Missing Asian and non-Hispanic











#REF!





Male Missing Black or African American and non-Hispanic











#REF!





Male Missing Native Hawaiian or Other Pacific Islander and non-Hispanic











#REF!





Male Missing White and non-Hispanic











#REF!





Male Missing Multiracial/Other and non Hispanic











#REF!





Male Missing Hispanic or Latino











#REF!





Male Missing Unknown











#REF!





Missing 0-4 American Indian or Alaska Native and non-Hispanic











#REF!





Missing 0-4 Asian and non-Hispanic











#REF!





Missing 0-4 Black or African American and non-Hispanic











#REF!





Missing 0-4 Native Hawaiian or Other Pacific Islander and non-Hispanic











#REF!





Missing 0-4 White and non-Hispanic











#REF!





Missing 0-4 Multiracial/Other and non Hispanic











#REF!





Missing 0-4 Hispanic or Latino











#REF!





Missing 0-4 Unknown











#REF!





Missing 05-11 American Indian or Alaska Native and non-Hispanic











#REF!





Missing 05-11 Asian and non-Hispanic











#REF!





Missing 05-11 Black or African American and non-Hispanic











#REF!





Missing 05-11 Native Hawaiian or Other Pacific Islander and non-Hispanic











#REF!





Missing 05-11 White and non-Hispanic











#REF!





Missing 05-11 Multiracial/Other and non Hispanic











#REF!





Missing 05-11 Hispanic or Latino











#REF!





Missing 05-11 Unknown











#REF!





Missing 12-17 American Indian or Alaska Native and non-Hispanic











#REF!





Missing 12-17 Asian and non-Hispanic











#REF!





Missing 12-17 Black or African American and non-Hispanic











#REF!





Missing 12-17 Native Hawaiian or Other Pacific Islander and non-Hispanic











#REF!





Missing 12-17 White and non-Hispanic











#REF!





Missing 12-17 Multiracial/Other and non Hispanic











#REF!





Missing 12-17 Hispanic or Latino











#REF!





Missing 12-17 Unknown











#REF!





Missing 18-24 American Indian or Alaska Native and non-Hispanic











#REF!





Missing 18-24 Asian and non-Hispanic











#REF!





Missing 18-24 Black or African American and non-Hispanic











#REF!





Missing 18-24 Native Hawaiian or Other Pacific Islander and non-Hispanic











#REF!





Missing 18-24 White and non-Hispanic











#REF!





Missing 18-24 Multiracial/Other and non Hispanic











#REF!





Missing 18-24 Hispanic or Latino











#REF!





Missing 18-24 Unknown











#REF!





Missing Missing American Indian or Alaska Native and non-Hispanic











#REF!





Missing Missing Asian and non-Hispanic











#REF!





Missing Missing Black or African American and non-Hispanic











#REF!





Missing Missing Native Hawaiian or Other Pacific Islander and non-Hispanic











#REF!





Missing Missing White and non-Hispanic











#REF!





Missing Missing Multiracial/Other and non Hispanic











#REF!





Missing Missing Hispanic or Latino











#REF!





Missing Missing Unknown











#REF!



Sheet 5: NCHS_Violence

ED visits for firearm injuries, other violence-related injuries by sex and age group and race/ethnicity at the jurisdictional level






















Jurisdiction Year Month Sex Age_Group Calculated Race and Ethnicity Combined Overall_FA_visits_n Unintentional_FA_visits_n IntentionalSD_FA_visits_n Assault_FA_visits_n IPV_visits_n SV_visits_n CAN_visits_n YV_visits_n Total_ED_visits Check_Result





Female 0-10 American Indian or Alaska Native and non-Hispanic








#REF!

Cells need to fill



Female 0-10 Asian and non-Hispanic








#REF!
Original Version 3(sex)*11(age groups)*10(race)*9(categories)=2970



Female 0-10 Black or African American and non-Hispanic








#REF!
New Version 3(sex)*[9(age groups)*8(R/E)*8(categories)]-8*3(IPV)-8*5*3(YV)]=1728-24-120=1584



Female 0-10 Native Hawaiian or Other Pacific Islander and non-Hispanic








#REF!
New-Original 1584-2970-= -1386



Female 0-10 White and non-Hispanic








#REF!





Female 0-10 Multiracial/Other and non Hispanic








#REF!





Female 0-10 Hispanic or Latino








#REF!





Female 0-10 Unknown








#REF!





Female 11-14 American Indian or Alaska Native and non-Hispanic








#REF!





Female 11-14 Asian and non-Hispanic








#REF!





Female 11-14 Black or African American and non-Hispanic








#REF!





Female 11-14 Native Hawaiian or Other Pacific Islander and non-Hispanic








#REF!





Female 11-14 White and non-Hispanic








#REF!





Female 11-14 Multiracial/Other and non Hispanic








#REF!





Female 11-14 Hispanic or Latino








#REF!





Female 11-14 Unknown








#REF!





Female 15-24 American Indian or Alaska Native and non-Hispanic








#REF!





Female 15-24 Asian and non-Hispanic








#REF!





Female 15-24 Black or African American and non-Hispanic








#REF!





Female 15-24 Native Hawaiian or Other Pacific Islander and non-Hispanic








#REF!





Female 15-24 White and non-Hispanic








#REF!





Female 15-24 Multiracial/Other and non Hispanic








#REF!





Female 15-24 Hispanic or Latino








#REF!





Female 15-24 Unknown








#REF!





Female 25-34 American Indian or Alaska Native and non-Hispanic








#REF!





Female 25-34 Asian and non-Hispanic








#REF!





Female 25-34 Black or African American and non-Hispanic








#REF!





Female 25-34 Native Hawaiian or Other Pacific Islander and non-Hispanic








#REF!





Female 25-34 White and non-Hispanic








#REF!





Female 25-34 Multiracial/Other and non Hispanic








#REF!





Female 25-34 Hispanic or Latino








#REF!





Female 25-34 Unknown








#REF!





Female 35-44 American Indian or Alaska Native and non-Hispanic








#REF!





Female 35-44 Asian and non-Hispanic








#REF!





Female 35-44 Black or African American and non-Hispanic








#REF!





Female 35-44 Native Hawaiian or Other Pacific Islander and non-Hispanic








#REF!





Female 35-44 White and non-Hispanic








#REF!





Female 35-44 Multiracial/Other and non Hispanic








#REF!





Female 35-44 Hispanic or Latino








#REF!





Female 35-44 Unknown








#REF!





Female 45-54 American Indian or Alaska Native and non-Hispanic








#REF!





Female 45-54 Asian and non-Hispanic








#REF!





Female 45-54 Black or African American and non-Hispanic








#REF!





Female 45-54 Native Hawaiian or Other Pacific Islander and non-Hispanic








#REF!





Female 45-54 White and non-Hispanic








#REF!





Female 45-54 Multiracial/Other and non Hispanic








#REF!





Female 45-54 Hispanic or Latino








#REF!





Female 45-54 Unknown








#REF!





Female 55-64 American Indian or Alaska Native and non-Hispanic








#REF!





Female 55-64 Asian and non-Hispanic








#REF!





Female 55-64 Black or African American and non-Hispanic








#REF!





Female 55-64 Native Hawaiian or Other Pacific Islander and non-Hispanic








#REF!





Female 55-64 White and non-Hispanic








#REF!





Female 55-64 Multiracial/Other and non Hispanic








#REF!





Female 55-64 Hispanic or Latino








#REF!





Female 55-64 Unknown








#REF!





Female 65+ American Indian or Alaska Native and non-Hispanic








#REF!





Female 65+ Asian and non-Hispanic








#REF!





Female 65+ Black or African American and non-Hispanic








#REF!





Female 65+ Native Hawaiian or Other Pacific Islander and non-Hispanic








#REF!





Female 65+ White and non-Hispanic








#REF!





Female 65+ Multiracial/Other and non Hispanic








#REF!





Female 65+ Hispanic or Latino








#REF!





Female 65+ Unknown








#REF!





Female Missing American Indian or Alaska Native and non-Hispanic








#REF!





Female Missing Asian and non-Hispanic








#REF!





Female Missing Black or African American and non-Hispanic








#REF!





Female Missing Native Hawaiian or Other Pacific Islander and non-Hispanic








#REF!





Female Missing White and non-Hispanic








#REF!





Female Missing Multiracial/Other and non Hispanic








#REF!





Female Missing Hispanic or Latino








#REF!





Female Missing Unknown








#REF!





Male 0-10 American Indian or Alaska Native and non-Hispanic








#REF!





Male 0-10 Asian and non-Hispanic








#REF!





Male 0-10 Black or African American and non-Hispanic








#REF!





Male 0-10 Native Hawaiian or Other Pacific Islander and non-Hispanic








#REF!





Male 0-10 White and non-Hispanic








#REF!





Male 0-10 Multiracial/Other and non Hispanic








#REF!





Male 0-10 Hispanic or Latino








#REF!





Male 0-10 Unknown








#REF!





Male 11-14 American Indian or Alaska Native and non-Hispanic








#REF!





Male 11-14 Asian and non-Hispanic








#REF!





Male 11-14 Black or African American and non-Hispanic








#REF!





Male 11-14 Native Hawaiian or Other Pacific Islander and non-Hispanic








#REF!





Male 11-14 White and non-Hispanic








#REF!





Male 11-14 Multiracial/Other and non Hispanic








#REF!





Male 11-14 Hispanic or Latino








#REF!





Male 11-14 Unknown








#REF!





Male 15-24 American Indian or Alaska Native and non-Hispanic








#REF!





Male 15-24 Asian and non-Hispanic








#REF!





Male 15-24 Black or African American and non-Hispanic








#REF!





Male 15-24 Native Hawaiian or Other Pacific Islander and non-Hispanic








#REF!





Male 15-24 White and non-Hispanic








#REF!





Male 15-24 Multiracial/Other and non Hispanic








#REF!





Male 15-24 Hispanic or Latino








#REF!





Male 15-24 Unknown








#REF!





Male 25-34 American Indian or Alaska Native and non-Hispanic








#REF!





Male 25-34 Asian and non-Hispanic








#REF!





Male 25-34 Black or African American and non-Hispanic








#REF!





Male 25-34 Native Hawaiian or Other Pacific Islander and non-Hispanic








#REF!





Male 25-34 White and non-Hispanic








#REF!





Male 25-34 Multiracial/Other and non Hispanic








#REF!





Male 25-34 Hispanic or Latino








#REF!





Male 25-34 Unknown








#REF!





Male 35-44 American Indian or Alaska Native and non-Hispanic








#REF!





Male 35-44 Asian and non-Hispanic








#REF!





Male 35-44 Black or African American and non-Hispanic








#REF!





Male 35-44 Native Hawaiian or Other Pacific Islander and non-Hispanic








#REF!





Male 35-44 White and non-Hispanic








#REF!





Male 35-44 Multiracial/Other and non Hispanic








#REF!





Male 35-44 Hispanic or Latino








#REF!





Male 35-44 Unknown








#REF!





Male 45-54 American Indian or Alaska Native and non-Hispanic








#REF!





Male 45-54 Asian and non-Hispanic








#REF!





Male 45-54 Black or African American and non-Hispanic








#REF!





Male 45-54 Native Hawaiian or Other Pacific Islander and non-Hispanic








#REF!





Male 45-54 White and non-Hispanic








#REF!





Male 45-54 Multiracial/Other and non Hispanic








#REF!





Male 45-54 Hispanic or Latino








#REF!





Male 45-54 Unknown








#REF!





Male 55-64 American Indian or Alaska Native and non-Hispanic








#REF!





Male 55-64 Asian and non-Hispanic








#REF!





Male 55-64 Black or African American and non-Hispanic








#REF!





Male 55-64 Native Hawaiian or Other Pacific Islander and non-Hispanic








#REF!





Male 55-64 White and non-Hispanic








#REF!





Male 55-64 Multiracial/Other and non Hispanic








#REF!





Male 55-64 Hispanic or Latino








#REF!





Male 55-64 Unknown








#REF!





Male 65+ American Indian or Alaska Native and non-Hispanic








#REF!





Male 65+ Asian and non-Hispanic








#REF!





Male 65+ Black or African American and non-Hispanic








#REF!





Male 65+ Native Hawaiian or Other Pacific Islander and non-Hispanic








#REF!





Male 65+ White and non-Hispanic








#REF!





Male 65+ Multiracial/Other and non Hispanic








#REF!





Male 65+ Hispanic or Latino








#REF!





Male 65+ Unknown








#REF!





Male Missing American Indian or Alaska Native and non-Hispanic








#REF!





Male Missing Asian and non-Hispanic








#REF!





Male Missing Black or African American and non-Hispanic








#REF!





Male Missing Native Hawaiian or Other Pacific Islander and non-Hispanic








#REF!





Male Missing White and non-Hispanic








#REF!





Male Missing Multiracial/Other and non Hispanic








#REF!





Male Missing Hispanic or Latino








#REF!





Male Missing Unknown








#REF!





Missing 0-10 American Indian or Alaska Native and non-Hispanic








#REF!





Missing 0-10 Asian and non-Hispanic








#REF!





Missing 0-10 Black or African American and non-Hispanic








#REF!





Missing 0-10 Native Hawaiian or Other Pacific Islander and non-Hispanic








#REF!





Missing 0-10 White and non-Hispanic








#REF!





Missing 0-10 Multiracial/Other and non Hispanic








#REF!





Missing 0-10 Hispanic or Latino








#REF!





Missing 0-10 Unknown








#REF!





Missing 11-14 American Indian or Alaska Native and non-Hispanic








#REF!





Missing 11-14 Asian and non-Hispanic








#REF!





Missing 11-14 Black or African American and non-Hispanic








#REF!





Missing 11-14 Native Hawaiian or Other Pacific Islander and non-Hispanic








#REF!





Missing 11-14 White and non-Hispanic








#REF!





Missing 11-14 Multiracial/Other and non Hispanic








#REF!





Missing 11-14 Hispanic or Latino








#REF!





Missing 11-14 Unknown








#REF!





Missing 15-24 American Indian or Alaska Native and non-Hispanic








#REF!





Missing 15-24 Asian and non-Hispanic








#REF!





Missing 15-24 Black or African American and non-Hispanic








#REF!





Missing 15-24 Native Hawaiian or Other Pacific Islander and non-Hispanic








#REF!





Missing 15-24 White and non-Hispanic








#REF!





Missing 15-24 Multiracial/Other and non Hispanic








#REF!





Missing 15-24 Hispanic or Latino








#REF!





Missing 15-24 Unknown








#REF!





Missing 25-34 American Indian or Alaska Native and non-Hispanic








#REF!





Missing 25-34 Asian and non-Hispanic








#REF!





Missing 25-34 Black or African American and non-Hispanic








#REF!





Missing 25-34 Native Hawaiian or Other Pacific Islander and non-Hispanic








#REF!





Missing 25-34 White and non-Hispanic








#REF!





Missing 25-34 Multiracial/Other and non Hispanic








#REF!





Missing 25-34 Hispanic or Latino








#REF!





Missing 25-34 Unknown








#REF!





Missing 35-44 American Indian or Alaska Native and non-Hispanic








#REF!





Missing 35-44 Asian and non-Hispanic








#REF!





Missing 35-44 Black or African American and non-Hispanic








#REF!





Missing 35-44 Native Hawaiian or Other Pacific Islander and non-Hispanic








#REF!





Missing 35-44 White and non-Hispanic








#REF!





Missing 35-44 Multiracial/Other and non Hispanic








#REF!





Missing 35-44 Hispanic or Latino








#REF!





Missing 35-44 Unknown








#REF!





Missing 45-54 American Indian or Alaska Native and non-Hispanic








#REF!





Missing 45-54 Asian and non-Hispanic








#REF!





Missing 45-54 Black or African American and non-Hispanic








#REF!





Missing 45-54 Native Hawaiian or Other Pacific Islander and non-Hispanic








#REF!





Missing 45-54 White and non-Hispanic








#REF!





Missing 45-54 Multiracial/Other and non Hispanic








#REF!





Missing 45-54 Hispanic or Latino








#REF!





Missing 45-54 Unknown








#REF!





Missing 55-64 American Indian or Alaska Native and non-Hispanic








#REF!





Missing 55-64 Asian and non-Hispanic








#REF!





Missing 55-64 Black or African American and non-Hispanic








#REF!





Missing 55-64 Native Hawaiian or Other Pacific Islander and non-Hispanic








#REF!





Missing 55-64 White and non-Hispanic








#REF!





Missing 55-64 Multiracial/Other and non Hispanic








#REF!





Missing 55-64 Hispanic or Latino








#REF!





Missing 55-64 Unknown








#REF!





Missing 65+ American Indian or Alaska Native and non-Hispanic








#REF!





Missing 65+ Asian and non-Hispanic








#REF!





Missing 65+ Black or African American and non-Hispanic








#REF!





Missing 65+ Native Hawaiian or Other Pacific Islander and non-Hispanic








#REF!





Missing 65+ White and non-Hispanic








#REF!





Missing 65+ Multiracial/Other and non Hispanic








#REF!





Missing 65+ Hispanic or Latino








#REF!





Missing 65+ Unknown








#REF!





Missing Missing American Indian or Alaska Native and non-Hispanic








#REF!





Missing Missing Asian and non-Hispanic








#REF!





Missing Missing Black or African American and non-Hispanic








#REF!





Missing Missing Native Hawaiian or Other Pacific Islander and non-Hispanic








#REF!





Missing Missing White and non-Hispanic








#REF!





Missing Missing Multiracial/Other and non Hispanic








#REF!





Missing Missing Hispanic or Latino








#REF!





Missing Missing Unknown








#REF!



Sheet 6: NCHS_Mental

ED visits for mental health conditions by sex and age group and race/ethnicity at the jurisdictional level



























Jurisdiction Year Month Sex Age_Group Calculated Race and Ethnicity Combined Overall_MH_visits_n Anxiety_MH_visits_n Depressive_MH_visits_n Bipolar_MH_visits_n Schizophrenia_MH_visits_n Trauma_MH_visits_n ADHD_MH_visits_n DBI_MH_visits_n OC_MH_visits_n ED_MH_visits_n TD_MH_visits_n [Threaded comment] Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924 Comment: All ED Visits with sex, age, race/ethnicity Total_ED_visits Check_Result






Female 0-10 American Indian or Alaska Native and non-Hispanic











#REF!


Cells need to fill



Female 0-10 Asian and non-Hispanic











#REF!

Original Version 3(sex)*[11(age groups)*10(race)*12(categories)]=3960



Female 0-10 Black or African American and non-Hispanic











#REF!

New Version 3(sex)*[9(age groups)*8(R/E)*12(categories)-8(0-10age)*11(categories)-16(Sch)]=3[864-88-16]=3*760=2280



Female 0-10 Native Hawaiian or Other Pacific Islander and non-Hispanic











#REF!

New-Original 2280-3960= -1680



Female 0-10 White and non-Hispanic











#REF!






Female 0-10 Multiracial/Other and non Hispanic











#REF!






Female 0-10 Hispanic or Latino











#REF!






Female 0-10 Unknown











#REF!






Female 11-14 American Indian or Alaska Native and non-Hispanic











#REF!






Female 11-14 Asian and non-Hispanic











#REF!






Female 11-14 Black or African American and non-Hispanic











#REF!






Female 11-14 Native Hawaiian or Other Pacific Islander and non-Hispanic











#REF!






Female 11-14 White and non-Hispanic











#REF!






Female 11-14 Multiracial/Other and non Hispanic











#REF!






Female 11-14 Hispanic or Latino











#REF!






Female 11-14 Unknown











#REF!






Female 15-24 American Indian or Alaska Native and non-Hispanic











#REF!






Female 15-24 Asian and non-Hispanic











#REF!






Female 15-24 Black or African American and non-Hispanic











#REF!






Female 15-24 Native Hawaiian or Other Pacific Islander and non-Hispanic











#REF!






Female 15-24 White and non-Hispanic











#REF!






Female 15-24 Multiracial/Other and non Hispanic











#REF!






Female 15-24 Hispanic or Latino











#REF!






Female 15-24 Unknown











#REF!






Female 25-34 American Indian or Alaska Native and non-Hispanic











#REF!






Female 25-34 Asian and non-Hispanic











#REF!






Female 25-34 Black or African American and non-Hispanic











#REF!






Female 25-34 Native Hawaiian or Other Pacific Islander and non-Hispanic











#REF!






Female 25-34 White and non-Hispanic











#REF!






Female 25-34 Multiracial/Other and non Hispanic











#REF!






Female 25-34 Hispanic or Latino











#REF!






Female 25-34 Unknown











#REF!






Female 35-44 American Indian or Alaska Native and non-Hispanic











#REF!






Female 35-44 Asian and non-Hispanic











#REF!






Female 35-44 Black or African American and non-Hispanic











#REF!






Female 35-44 Native Hawaiian or Other Pacific Islander and non-Hispanic











#REF!






Female 35-44 White and non-Hispanic











#REF!






Female 35-44 Multiracial/Other and non Hispanic











#REF!






Female 35-44 Hispanic or Latino











#REF!






Female 35-44 Unknown











#REF!






Female 45-54 American Indian or Alaska Native and non-Hispanic











#REF!






Female 45-54 Asian and non-Hispanic











#REF!






Female 45-54 Black or African American and non-Hispanic











#REF!






Female 45-54 Native Hawaiian or Other Pacific Islander and non-Hispanic











#REF!






Female 45-54 White and non-Hispanic











#REF!






Female 45-54 Multiracial/Other and non Hispanic











#REF!






Female 45-54 Hispanic or Latino











#REF!






Female 45-54 Unknown











#REF!






Female 55-64 American Indian or Alaska Native and non-Hispanic











#REF!






Female 55-64 Asian and non-Hispanic











#REF!






Female 55-64 Black or African American and non-Hispanic











#REF!






Female 55-64 Native Hawaiian or Other Pacific Islander and non-Hispanic











#REF!






Female 55-64 White and non-Hispanic











#REF!






Female 55-64 Multiracial/Other and non Hispanic











#REF!






Female 55-64 Hispanic or Latino











#REF!






Female 55-64 Unknown











#REF!






Female 65+ American Indian or Alaska Native and non-Hispanic











#REF!






Female 65+ Asian and non-Hispanic











#REF!






Female 65+ Black or African American and non-Hispanic











#REF!






Female 65+ Native Hawaiian or Other Pacific Islander and non-Hispanic











#REF!






Female 65+ White and non-Hispanic











#REF!






Female 65+ Multiracial/Other and non Hispanic











#REF!






Female 65+ Hispanic or Latino











#REF!






Female 65+ Unknown











#REF!






Female Missing American Indian or Alaska Native and non-Hispanic











#REF!






Female Missing Asian and non-Hispanic











#REF!






Female Missing Black or African American and non-Hispanic











#REF!






Female Missing Native Hawaiian or Other Pacific Islander and non-Hispanic











#REF!






Female Missing White and non-Hispanic











#REF!






Female Missing Multiracial/Other and non Hispanic











#REF!






Female Missing Hispanic or Latino











#REF!






Female Missing Unknown











#REF!






Male 0-10 American Indian or Alaska Native and non-Hispanic











#REF!






Male 0-10 Asian and non-Hispanic











#REF!






Male 0-10 Black or African American and non-Hispanic











#REF!






Male 0-10 Native Hawaiian or Other Pacific Islander and non-Hispanic











#REF!






Male 0-10 White and non-Hispanic











#REF!






Male 0-10 Multiracial/Other and non Hispanic











#REF!






Male 0-10 Hispanic or Latino











#REF!






Male 0-10 Unknown











#REF!






Male 11-14 American Indian or Alaska Native and non-Hispanic











#REF!






Male 11-14 Asian and non-Hispanic











#REF!






Male 11-14 Black or African American and non-Hispanic











#REF!






Male 11-14 Native Hawaiian or Other Pacific Islander and non-Hispanic











#REF!






Male 11-14 White and non-Hispanic











#REF!






Male 11-14 Multiracial/Other and non Hispanic











#REF!






Male 11-14 Hispanic or Latino











#REF!






Male 11-14 Unknown











#REF!






Male 15-24 American Indian or Alaska Native and non-Hispanic











#REF!






Male 15-24 Asian and non-Hispanic











#REF!






Male 15-24 Black or African American and non-Hispanic











#REF!






Male 15-24 Native Hawaiian or Other Pacific Islander and non-Hispanic











#REF!






Male 15-24 White and non-Hispanic











#REF!






Male 15-24 Multiracial/Other and non Hispanic











#REF!






Male 15-24 Hispanic or Latino











#REF!






Male 15-24 Unknown











#REF!






Male 25-34 American Indian or Alaska Native and non-Hispanic











#REF!






Male 25-34 Asian and non-Hispanic











#REF!






Male 25-34 Black or African American and non-Hispanic











#REF!






Male 25-34 Native Hawaiian or Other Pacific Islander and non-Hispanic











#REF!






Male 25-34 White and non-Hispanic











#REF!






Male 25-34 Multiracial/Other and non Hispanic











#REF!






Male 25-34 Hispanic or Latino











#REF!






Male 25-34 Unknown











#REF!






Male 35-44 American Indian or Alaska Native and non-Hispanic











#REF!




Male 35-44 Asian and non-Hispanic











#REF!



Male 35-44 Black or African American and non-Hispanic











#REF!



Male 35-44 Native Hawaiian or Other Pacific Islander and non-Hispanic











#REF!



Male 35-44 White and non-Hispanic











#REF!



Male 35-44 Multiracial/Other and non Hispanic











#REF!



Male 35-44 Hispanic or Latino











#REF!



Male 35-44 Unknown











#REF!



Male 45-54 American Indian or Alaska Native and non-Hispanic











#REF!



Male 45-54 Asian and non-Hispanic











#REF!



Male 45-54 Black or African American and non-Hispanic











#REF!



Male 45-54 Native Hawaiian or Other Pacific Islander and non-Hispanic











#REF!



Male 45-54 White and non-Hispanic











#REF!



Male 45-54 Multiracial/Other and non Hispanic











#REF!



Male 45-54 Hispanic or Latino











#REF!



Male 45-54 Unknown











#REF!



Male 55-64 American Indian or Alaska Native and non-Hispanic











#REF!



Male 55-64 Asian and non-Hispanic











#REF!



Male 55-64 Black or African American and non-Hispanic











#REF!



Male 55-64 Native Hawaiian or Other Pacific Islander and non-Hispanic











#REF!



Male 55-64 White and non-Hispanic











#REF!



Male 55-64 Multiracial/Other and non Hispanic











#REF!



Male 55-64 Hispanic or Latino











#REF!



Male 55-64 Unknown











#REF!



Male 65+ American Indian or Alaska Native and non-Hispanic











#REF!



Male 65+ Asian and non-Hispanic











#REF!



Male 65+ Black or African American and non-Hispanic











#REF!



Male 65+ Native Hawaiian or Other Pacific Islander and non-Hispanic











#REF!



Male 65+ White and non-Hispanic











#REF!



Male 65+ Multiracial/Other and non Hispanic











#REF!



Male 65+ Hispanic or Latino











#REF!



Male 65+ Unknown











#REF!



Male Missing American Indian or Alaska Native and non-Hispanic











#REF!



Male Missing Asian and non-Hispanic











#REF!



Male Missing Black or African American and non-Hispanic











#REF!



Male Missing Native Hawaiian or Other Pacific Islander and non-Hispanic











#REF!



Male Missing White and non-Hispanic











#REF!



Male Missing Multiracial/Other and non Hispanic











#REF!



Male Missing Hispanic or Latino











#REF!



Male Missing Unknown











#REF!



Missing 0-10 American Indian or Alaska Native and non-Hispanic











#REF!



Missing 0-10 Asian and non-Hispanic











#REF!



Missing 0-10 Black or African American and non-Hispanic











#REF!



Missing 0-10 Native Hawaiian or Other Pacific Islander and non-Hispanic











#REF!



Missing 0-10 White and non-Hispanic











#REF!



Missing 0-10 Multiracial/Other and non Hispanic











#REF!



Missing 0-10 Hispanic or Latino











#REF!



Missing 0-10 Unknown











#REF!



Missing 11-14 American Indian or Alaska Native and non-Hispanic











#REF!



Missing 11-14 Asian and non-Hispanic











#REF!



Missing 11-14 Black or African American and non-Hispanic











#REF!



Missing 11-14 Native Hawaiian or Other Pacific Islander and non-Hispanic











#REF!



Missing 11-14 White and non-Hispanic











#REF!



Missing 11-14 Multiracial/Other and non Hispanic











#REF!



Missing 11-14 Hispanic or Latino











#REF!



Missing 11-14 Unknown











#REF!



Missing 15-24 American Indian or Alaska Native and non-Hispanic











#REF!



Missing 15-24 Asian and non-Hispanic











#REF!



Missing 15-24 Black or African American and non-Hispanic











#REF!



Missing 15-24 Native Hawaiian or Other Pacific Islander and non-Hispanic











#REF!



Missing 15-24 White and non-Hispanic











#REF!



Missing 15-24 Multiracial/Other and non Hispanic











#REF!



Missing 15-24 Hispanic or Latino











#REF!



Missing 15-24 Unknown











#REF!



Missing 25-34 American Indian or Alaska Native and non-Hispanic











#REF!



Missing 25-34 Asian and non-Hispanic











#REF!






Missing 25-34 Black or African American and non-Hispanic











#REF!






Missing 25-34 Native Hawaiian or Other Pacific Islander and non-Hispanic











#REF!






Missing 25-34 White and non-Hispanic











#REF!






Missing 25-34 Multiracial/Other and non Hispanic











#REF!






Missing 25-34 Hispanic or Latino











#REF!






Missing 25-34 Unknown











#REF!






Missing 35-44 American Indian or Alaska Native and non-Hispanic











#REF!






Missing 35-44 Asian and non-Hispanic











#REF!






Missing 35-44 Black or African American and non-Hispanic











#REF!






Missing 35-44 Native Hawaiian or Other Pacific Islander and non-Hispanic











#REF!






Missing 35-44 White and non-Hispanic











#REF!






Missing 35-44 Multiracial/Other and non Hispanic











#REF!






Missing 35-44 Hispanic or Latino











#REF!






Missing 35-44 Unknown











#REF!






Missing 45-54 American Indian or Alaska Native and non-Hispanic











#REF!






Missing 45-54 Asian and non-Hispanic











#REF!






Missing 45-54 Black or African American and non-Hispanic











#REF!






Missing 45-54 Native Hawaiian or Other Pacific Islander and non-Hispanic











#REF!






Missing 45-54 White and non-Hispanic











#REF!






Missing 45-54 Multiracial/Other and non Hispanic











#REF!






Missing 45-54 Hispanic or Latino











#REF!






Missing 45-54 Unknown











#REF!






Missing 55-64 American Indian or Alaska Native and non-Hispanic











#REF!






Missing 55-64 Asian and non-Hispanic











#REF!






Missing 55-64 Black or African American and non-Hispanic











#REF!






Missing 55-64 Native Hawaiian or Other Pacific Islander and non-Hispanic











#REF!






Missing 55-64 White and non-Hispanic











#REF!






Missing 55-64 Multiracial/Other and non Hispanic











#REF!






Missing 55-64 Hispanic or Latino











#REF!






Missing 55-64 Unknown











#REF!






Missing 65+ American Indian or Alaska Native and non-Hispanic











#REF!






Missing 65+ Asian and non-Hispanic











#REF!






Missing 65+ Black or African American and non-Hispanic











#REF!






Missing 65+ Native Hawaiian or Other Pacific Islander and non-Hispanic











#REF!






Missing 65+ White and non-Hispanic











#REF!






Missing 65+ Multiracial/Other and non Hispanic











#REF!






Missing 65+ Hispanic or Latino











#REF!






Missing 65+ Unknown











#REF!






Missing Missing American Indian or Alaska Native and non-Hispanic











#REF!






Missing Missing Asian and non-Hispanic











#REF!






Missing Missing Black or African American and non-Hispanic











#REF!






Missing Missing Native Hawaiian or Other Pacific Islander and non-Hispanic











#REF!






Missing Missing White and non-Hispanic











#REF!






Missing Missing Multiracial/Other and non Hispanic











#REF!






Missing Missing Hispanic or Latino











#REF!






Missing Missing Unknown











#REF!




Sheet 7: County Report

ED visits for firearm injuries, other violence-related injuries, and mental health conditions by county


























Jurisdiction County_name County_FIPS Year Month Overall_FA_visits_n Unintentional_FA_visits_n IntentionalSD_FA_visits_n Assault_FA_visits_n IPV_visits_n SV_visits_n CAN_visits_n YV_visits_n Overall_MH_visits_n Anxiety_MH_visits_n Depressive_MH_visits_n Bipolar_MH_visits_n Schizophrenia_MH_visits_n Trauma_MH_visits_n ADHD_MH_visits_n DBI_MH_visits_n OC_MH_visits_n ED_MH_visits_n TD_MH_visits_n Total_ED_visits Check_Result

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data

























Enter Data
File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00

© 2024 OMB.report | Privacy Policy