Import Wizard Troubleshooting Guide

The Import Wizard Troubleshooting Guide is designed to help users navigate and resolve issues that may arise during the data import process in Health Data Explorer. This guide provides a comprehensive breakdown of each field involved in the import process, including detailed descriptions, information on optional fields, field types, supported formats/values, and examples.

By referencing this guide, users can ensure that their data is correctly formatted and aligns with the platform's requirements, minimizing errors and warnings during import.

XLSX & CSV Case fields

See below the different case related fields we support along with the type of the field.

Field name	Description	Optional field	Field Type	Supported Format/Value	Example

Field name	Description	Field Type	Supported Format/Value	Example
Case ID	Unique case ID in existing CMS for the decedent.	text	Letters, symbols and numbers	20183837, ME2024-2378
First Name	First name of the decedent.	text	Letters and numbers	Mary
Middle Name	Middle name of the decedent.	text	Letters and numbers	Jay Olivia
Last Name	Last name of the decedent.	text	Letters and numbers	Smith
Date of Birth	Date of birth of the decedent.	text	MM/DD/YYYY	03/04/1955
Date of Death	Date of death of the decedent.	text	MM/DD/YYYY	11/08/2018
Time of Death	Time of death of the decedent.	text	hhmm	0923
Age	Age of the decedent.	number	# OR #.##	63 OR 63.68
Race	Race of the decedent.	text	We match the first letter of the set value to find the race, so if the value starts with: A → Asian B → Black or African American H → Hispanic or Latino I → Indian O → Other P → Pacific Islander including Native Hawaiian U → Unknown W → White If there is no match, it will be set as Unknown	Black or African American
Sex	Sex of the decedent.	text	F, M, Male or Female If there is no match, it will be set as Unknown	F
Home Address - Zip Code	Zip code for the home address of the decedent.	object	##### Only United States Zip Codes are accepted for trial accounts	30339
Cause of Death	Cause of Death of the decedent.	text	Any combination of letters and numbers	Arteriosclerotic cardiovascular disease
Contributing Factors	Contributing factors to the cause of death of the decedent.	text	Any combination of letters and numbers	smoker
Manner Of Death	Manner of Death of the decedent.	text	Any combination of letters and numbers	Natural
Pathologist	Full name of the pathologist assigned to the case.	text	Any combination of letters and numbers	Jonathan Meyers
Type Of Exam	Type of examination conduced on the decedent.	text	Aut → Autopsy OR Ext → External Examination	Ext
Height	Height of the decedent.	number	## Inches (in) is the only unit of measure accepted for trial accounts	70
Weight	Weight of the decedent.	number	### Pounds (lbs) is the only unit of measure accepted for trial accounts	199
Brain Autopsy	Brain mass of the decedent.	number	#### Grams (gm) is the only unit of measure accepted for trial accounts	1,250
Heart Autospy	Heart mass of the decedent.	number	### Grams (gm) is the only unit of measure accepted for trial accounts	289
Left Kidney Autopsy	Left kidney mass of the decedent.	number	### Grams (gm) is the only unit of measure accepted for trial accounts	133
Right Kidney Autopsy	Right kidney mass of the decedent.	number	### Grams (gm) is the only unit of measure accepted for trial accounts	132
Liver Autopsy	Liver mass of the decedent.	number	#### Grams (gm) is the only unit of measure accepted for trial accounts	1705
Left Lung Autopsy	Left lung mass of the decedent.	number	### Grams (gm) is the only unit of measure accepted for trial accounts	575
Right Lung Autopsy	Right lung mass of the decedent.	number	### Grams (gm) is the only unit of measure accepted for trial accounts	535
Spleen Autopsy	Spleen mass of the decedent.	number	### Grams (gm) is the only unit of measure accepted for trial accounts	167
Thymus Autopsy	Thymus mass of the decedent.	number	## Grams (gm) is the only unit of measure accepted for trial accounts	13
Organ Donor	Indication if the decedent was an organ donor.	text	Yes OR No	Yes
Eye Donor	Indication if the decedent was an eye donor.	text	Yes OR No	No
Deputy Coroner	Full name of the deputy coroner assigned to the case.	text	Letters and numbers	Sarah Knowles
Scene	Notes regarding the scene where the incident happened.	text	Letters and numbers	Yes, photos taken.
Identified Method	Method used to identify the decedent, if applicable.	text	Letters and numbers	Fingerprints
Police Agency	Police Agency that originally handled the case.	text	Letters and numbers	New Connecticut PD
Incident	Notes regarding the incident.	text	Letters and numbers	Sleepery slope
Means Of Death	Means of death.	text	Letters and numbers	Arteriosclerotic cardiovascular disease
Weapon Type	Weapon type used.	text	Letters and numbers	Gun
On The Job	Indication if the incident happened on the job.	text	Yes or No	Yes
Place Of Injury	Place of Injury address.	object	Street address, City, State	7169 West Broad Avenue, Jamaica, NY
Place of Injury Zip Code	Zip code for the place of injury address.	text	#####	27292
Place of Injury Date	Date when the injury happened.	text	MM/DD/YYYY	9/20/2023
Place of Injury Time	Time when the injury happened.	text	hhmm	1414
Place Of Death	Place of death address.	object	Street address, City, State	One Healthy Way, Oceanside, NY
Place of Death Zip	Zip code for the place of injury address.	text	#####	11572
Exam Date	Date when the examination took place.	text	MM/DD/YYYY	11/09/2018
Death Certificate To Health Department Date	Date when the death certificate was sent to corresponding Health Department.	text	MM/DD/YYYY	12/10/2018
Transcription Log Sign Out	Date when the transcription log was signed out.	text	MM/DD/YYYY	12/10/2018
Companion Cases	List of any other case IDs related to this case.	list	#, #	20236791, 20238422
Agency Case Number	Original case ID created by the police agency.	text	#	2023-0009