ny-sparcs-inpatient/2023-01-01

Source: New York State Department of Health SPARCS; pinned object gs://gavel-mrf-dev-mrf/pubdata/ny-sparcs-inpatient/vintage=2023-01-01/data.parquet#1789446662463015; Discharges are not unique patients. Payer typologies are filed categories, not a payer crosswalk. Public discharge records do not establish OneStep adoption, RTM eligibility, utilization or ROI.. Source vintage: Source vintage 2023-01-01; republished in website build over package vintage 2026-10-01. Grain: One de-identified New York inpatient discharge in the source data year, not a unique patient, encounter outside New York, or current hospital volume.. Snapshot: 7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba.

Source records. NULL means missing; empty text is labelled separately.
Hospital Service Area Utf8	Hospital County Utf8	Operating Certificate Number Utf8	Permanent Facility Id Utf8	Facility Name Utf8	Age Group Utf8	Zip Code - 3 digits Utf8	Gender Utf8	Race Utf8	Ethnicity Utf8	Type of Admission Utf8	Patient Disposition Utf8	Discharge Year Utf8	CCSR Diagnosis Code Utf8	CCSR Diagnosis Description Utf8	CCSR Procedure Code Utf8	CCSR Procedure Description Utf8	APR DRG Code Utf8	APR DRG Description Utf8	APR MDC Code Utf8	APR MDC Description Utf8	APR Severity of Illness Code Utf8	APR Severity of Illness Description Utf8	APR Risk of Mortality Utf8	APR Medical Surgical Description Utf8	Payment Typology 1 Utf8	Payment Typology 2 Utf8	Payment Typology 3 Utf8	Birth Weight Utf8	Emergency Department Indicator Utf8	filename Utf8	vintage Date32	Total Costs Float64	Total Charges Float64	Length of Stay Int32	__row_id Int64
New York City Filter to this value	Bronx Filter to this value	7000006 Filter to this value	003058 Filter to this value	Montefiore Med Center - Jack D Weiler Hosp of A Einstein College Div Filter to this value	50 to 69 Filter to this value	104 Filter to this value	M Filter to this value	White Filter to this value	Not Span/Hispanic Filter to this value	Emergency Filter to this value	Home w/ Home Health Services Filter to this value	2023 Filter to this value	SYM001 Filter to this value	Syncope Filter to this value	IMG006 Filter to this value	COMPUTERIZED TOMOGRAPHY (CT) WITH CONTRAST Filter to this value	204 Filter to this value	SYNCOPE AND COLLAPSE Filter to this value	05 Filter to this value	DISEASES & DISORDERS OF THE CIRCULATORY SYSTEM Filter to this value	1 Filter to this value	Minor Filter to this value	Minor Filter to this value	Medical Filter to this value	Private Health Insurance Filter to this value	Medicare Filter to this value	NULL	NULL	Y Filter to this value	gs://gavel-mrf-dev-mrf/pubdata/ny-sparcs-inpatient/vintage=2023-01-01/_raw/rows.csv Filter to this value	2023-01-01 Filter to this value	3799.63 Filter to this value	30093.53 Filter to this value	2 Filter to this value	0
New York City Filter to this value	Bronx Filter to this value	7000006 Filter to this value	003058 Filter to this value	Montefiore Med Center - Jack D Weiler Hosp of A Einstein College Div Filter to this value	30 to 49 Filter to this value	104 Filter to this value	F Filter to this value	Multi-racial Filter to this value	Not Span/Hispanic Filter to this value	Emergency Filter to this value	Home or Self Care Filter to this value	2023 Filter to this value	CIR006 Filter to this value	Pericarditis and pericardial disease Filter to this value	ADM016 Filter to this value	ADMINISTRATION OF ANTI-INFLAMMATORY AGENTS Filter to this value	207 Filter to this value	OTHER CIRCULATORY SYSTEM DIAGNOSES Filter to this value	05 Filter to this value	DISEASES & DISORDERS OF THE CIRCULATORY SYSTEM Filter to this value	1 Filter to this value	Minor Filter to this value	Minor Filter to this value	Medical Filter to this value	Private Health Insurance Filter to this value	NULL	NULL	NULL	Y Filter to this value	gs://gavel-mrf-dev-mrf/pubdata/ny-sparcs-inpatient/vintage=2023-01-01/_raw/rows.csv Filter to this value	2023-01-01 Filter to this value	4500.07 Filter to this value	30944.67 Filter to this value	1 Filter to this value	1
New York City Filter to this value	Bronx Filter to this value	7000006 Filter to this value	003058 Filter to this value	Montefiore Med Center - Jack D Weiler Hosp of A Einstein College Div Filter to this value	70 or Older Filter to this value	104 Filter to this value	F Filter to this value	Black/African American Filter to this value	Not Span/Hispanic Filter to this value	Emergency Filter to this value	Medicaid Cert Nursing Facility Filter to this value	2023 Filter to this value	CIR008 Filter to this value	Hypertension with complications and secondary hypertension Filter to this value	ADM021 Filter to this value	ADMINISTRATION OF THERAPEUTIC SUBSTANCES, NEC Filter to this value	199 Filter to this value	HYPERTENSION Filter to this value	05 Filter to this value	DISEASES & DISORDERS OF THE CIRCULATORY SYSTEM Filter to this value	1 Filter to this value	Minor Filter to this value	Minor Filter to this value	Medical Filter to this value	Medicare Filter to this value	Medicaid Filter to this value	NULL	NULL	Y Filter to this value	gs://gavel-mrf-dev-mrf/pubdata/ny-sparcs-inpatient/vintage=2023-01-01/_raw/rows.csv Filter to this value	2023-01-01 Filter to this value	7433.56 Filter to this value	41937.07 Filter to this value	3 Filter to this value	2
New York City Filter to this value	Bronx Filter to this value	7000006 Filter to this value	003058 Filter to this value	Montefiore Med Center - Jack D Weiler Hosp of A Einstein College Div Filter to this value	70 or Older Filter to this value	104 Filter to this value	M Filter to this value	Black/African American Filter to this value	Not Span/Hispanic Filter to this value	Emergency Filter to this value	Home or Self Care Filter to this value	2023 Filter to this value	SYM015 Filter to this value	General sensation/perception signs and symptoms Filter to this value	ADM021 Filter to this value	ADMINISTRATION OF THERAPEUTIC SUBSTANCES, NEC Filter to this value	111 Filter to this value	VERTIGO AND OTHER LABYRINTH DISORDERS Filter to this value	03 Filter to this value	DISEASES & DISORDERS OF THE EAR, NOSE, MOUTH & THROAT Filter to this value	3 Filter to this value	Major Filter to this value	Major Filter to this value	Medical Filter to this value	Medicare Filter to this value	NULL	NULL	NULL	Y Filter to this value	gs://gavel-mrf-dev-mrf/pubdata/ny-sparcs-inpatient/vintage=2023-01-01/_raw/rows.csv Filter to this value	2023-01-01 Filter to this value	3305.26 Filter to this value	29303.57 Filter to this value	2 Filter to this value	3
New York City Filter to this value	Bronx Filter to this value	7000006 Filter to this value	003058 Filter to this value	Montefiore Med Center - Jack D Weiler Hosp of A Einstein College Div Filter to this value	70 or Older Filter to this value	104 Filter to this value	F Filter to this value	White Filter to this value	Spanish/Hispanic Filter to this value	Emergency Filter to this value	Home or Self Care Filter to this value	2023 Filter to this value	RSP009 Filter to this value	Asthma Filter to this value	ADM016 Filter to this value	ADMINISTRATION OF ANTI-INFLAMMATORY AGENTS Filter to this value	141 Filter to this value	ASTHMA Filter to this value	04 Filter to this value	DISEASES & DISORDERS OF THE RESPIRATORY SYSTEM Filter to this value	2 Filter to this value	Moderate Filter to this value	Moderate Filter to this value	Medical Filter to this value	Medicare Filter to this value	NULL	NULL	NULL	Y Filter to this value	gs://gavel-mrf-dev-mrf/pubdata/ny-sparcs-inpatient/vintage=2023-01-01/_raw/rows.csv Filter to this value	2023-01-01 Filter to this value	3443.47 Filter to this value	29704.86 Filter to this value	1 Filter to this value	4
New York City Filter to this value	Bronx Filter to this value	7000006 Filter to this value	003058 Filter to this value	Montefiore Med Center - Jack D Weiler Hosp of A Einstein College Div Filter to this value	30 to 49 Filter to this value	104 Filter to this value	F Filter to this value	Black/African American Filter to this value	Spanish/Hispanic Filter to this value	Emergency Filter to this value	Left Against Medical Advice Filter to this value	2023 Filter to this value	RSP002 Filter to this value	Pneumonia (except that caused by tuberculosis) Filter to this value	ADM019 Filter to this value	POTENTIAL COVID-19 THERAPIES Filter to this value	139 Filter to this value	OTHER PNEUMONIA Filter to this value	04 Filter to this value	DISEASES & DISORDERS OF THE RESPIRATORY SYSTEM Filter to this value	3 Filter to this value	Major Filter to this value	Moderate Filter to this value	Medical Filter to this value	Medicaid Filter to this value	NULL	NULL	NULL	Y Filter to this value	gs://gavel-mrf-dev-mrf/pubdata/ny-sparcs-inpatient/vintage=2023-01-01/_raw/rows.csv Filter to this value	2023-01-01 Filter to this value	8316.58 Filter to this value	56544.92 Filter to this value	2 Filter to this value	5
New York City Filter to this value	Bronx Filter to this value	7000006 Filter to this value	001168 Filter to this value	Montefiore Medical Center-Wakefield Hospital Filter to this value	0 to 17 Filter to this value	104 Filter to this value	F Filter to this value	Other Race Filter to this value	Unknown Filter to this value	Newborn Filter to this value	Home or Self Care Filter to this value	2023 Filter to this value	PNL001 Filter to this value	Liveborn Filter to this value	MAM010 Filter to this value	OTHER CARDIOVASCULAR SYSTEM MEASUREMENT AND MONITORING Filter to this value	625 Filter to this value	NEONATE BIRTH WEIGHT 2000-2499 GRAMS WITH OTHER SIGNIFICANT CONDITION Filter to this value	15 Filter to this value	NEWBORNS & OTHER NEONATES WITH CONDTN ORIG IN PERINATAL PERIOD Filter to this value	1 Filter to this value	Minor Filter to this value	Minor Filter to this value	Medical Filter to this value	Medicaid Filter to this value	NULL	NULL	02000 Filter to this value	N Filter to this value	gs://gavel-mrf-dev-mrf/pubdata/ny-sparcs-inpatient/vintage=2023-01-01/_raw/rows.csv Filter to this value	2023-01-01 Filter to this value	26745.03 Filter to this value	211735.47 Filter to this value	12 Filter to this value	6
New York City Filter to this value	Bronx Filter to this value	7000006 Filter to this value	001168 Filter to this value	Montefiore Medical Center-Wakefield Hospital Filter to this value	0 to 17 Filter to this value	104 Filter to this value	F Filter to this value	Other Race Filter to this value	Spanish/Hispanic Filter to this value	Newborn Filter to this value	Home or Self Care Filter to this value	2023 Filter to this value	PNL007 Filter to this value	Hemolytic jaundice and perinatal jaundice Filter to this value	EST002 Filter to this value	PHOTOTHERAPY Filter to this value	640 Filter to this value	NEONATE BIRTH WEIGHT > 2499 GRAMS, NORMAL NEWBORN OR NEONATE WITH OTHER PROBLEM Filter to this value	15 Filter to this value	NEWBORNS & OTHER NEONATES WITH CONDTN ORIG IN PERINATAL PERIOD Filter to this value	1 Filter to this value	Minor Filter to this value	Minor Filter to this value	Medical Filter to this value	Medicaid Filter to this value	NULL	NULL	03100 Filter to this value	N Filter to this value	gs://gavel-mrf-dev-mrf/pubdata/ny-sparcs-inpatient/vintage=2023-01-01/_raw/rows.csv Filter to this value	2023-01-01 Filter to this value	2406.74 Filter to this value	20789.0 Filter to this value	1 Filter to this value	7
New York City Filter to this value	Bronx Filter to this value	7000006 Filter to this value	001168 Filter to this value	Montefiore Medical Center-Wakefield Hospital Filter to this value	50 to 69 Filter to this value	104 Filter to this value	M Filter to this value	Black/African American Filter to this value	Not Span/Hispanic Filter to this value	Emergency Filter to this value	Home w/ Home Health Services Filter to this value	2023 Filter to this value	CIR017 Filter to this value	Cardiac dysrhythmias Filter to this value	ADM021 Filter to this value	ADMINISTRATION OF THERAPEUTIC SUBSTANCES, NEC Filter to this value	201 Filter to this value	CARDIAC ARRHYTHMIA AND CONDUCTION DISORDERS Filter to this value	05 Filter to this value	DISEASES & DISORDERS OF THE CIRCULATORY SYSTEM Filter to this value	3 Filter to this value	Major Filter to this value	Moderate Filter to this value	Medical Filter to this value	Medicaid Filter to this value	NULL	NULL	NULL	Y Filter to this value	gs://gavel-mrf-dev-mrf/pubdata/ny-sparcs-inpatient/vintage=2023-01-01/_raw/rows.csv Filter to this value	2023-01-01 Filter to this value	21004.56 Filter to this value	119509.24 Filter to this value	5 Filter to this value	8
New York City Filter to this value	Bronx Filter to this value	7000006 Filter to this value	001169 Filter to this value	Montefiore Medical Center - Henry & Lucy Moses Div Filter to this value	18 to 29 Filter to this value	104 Filter to this value	M Filter to this value	Black/African American Filter to this value	Not Span/Hispanic Filter to this value	Emergency Filter to this value	Home or Self Care Filter to this value	2023 Filter to this value	BLD005 Filter to this value	Sickle cell trait/anemia Filter to this value	ADM017 Filter to this value	ADMINISTRATION OF NUTRITIONAL AND ELECTROLYTIC SUBSTANCES Filter to this value	662 Filter to this value	SICKLE CELL ANEMIA CRISIS Filter to this value	16 Filter to this value	DISEASES & DISORDERS OF BLOOD, BLOOD FORMING ORGANS, IMMUNOLOG DISORD Filter to this value	3 Filter to this value	Major Filter to this value	Minor Filter to this value	Medical Filter to this value	Medicaid Filter to this value	NULL	NULL	NULL	Y Filter to this value	gs://gavel-mrf-dev-mrf/pubdata/ny-sparcs-inpatient/vintage=2023-01-01/_raw/rows.csv Filter to this value	2023-01-01 Filter to this value	21979.65 Filter to this value	114377.29 Filter to this value	9 Filter to this value	9

Next page, same selection

Evidence receipt r1558

Permanent saved result

Secondary typed Arrow export