ny-sparcs-inpatient/2024-01-01

Source: New York State Department of Health SPARCS; pinned object gs://gavel-mrf-dev-mrf/pubdata/ny-sparcs-inpatient/vintage=2024-01-01/data.parquet#1789446715111065; 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 2024-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.
Health Service Area Utf8	Hospital County Utf8	Operating Certificate Number Utf8	Permanent Facility Id Utf8	Facility Name Utf8	Age Group Utf8	Zip Code 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
Hudson Valley Filter to this value	Westchester Filter to this value	5957001 Filter to this value	001139 Filter to this value	WESTCHESTER MEDICAL CENTER Filter to this value	0-17 Filter to this value	OOS Filter to this value	F Filter to this value	White Filter to this value	Not Span/Hispanic Filter to this value	Emergency Filter to this value	Home or Self Care Filter to this value	2024 Filter to this value	SYM002 Filter to this value	FEVER Filter to this value	NULL	NULL	722 Filter to this value	FEVER AND INFLAMMATORY CONDITIONS Filter to this value	18 Filter to this value	INFECTIOUS AND PARASITIC DISEASES, SYSTEMIC OR UNSPECIFIED SITES Filter to this value	2 Filter to this value	Moderate 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=2024-01-01/_raw/rows.csv Filter to this value	2024-01-01 Filter to this value	6772.07 Filter to this value	46814.0 Filter to this value	1 Filter to this value	0
New York City Filter to this value	Queens Filter to this value	7003001 Filter to this value	001628 Filter to this value	FLUSHING HOSPITAL MEDICAL CENTER Filter to this value	0-17 Filter to this value	113 Filter to this value	M 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	2024 Filter to this value	SYM002 Filter to this value	FEVER Filter to this value	NULL	NULL	722 Filter to this value	FEVER AND INFLAMMATORY CONDITIONS Filter to this value	18 Filter to this value	INFECTIOUS AND PARASITIC DISEASES, SYSTEMIC OR UNSPECIFIED SITES Filter to this value	2 Filter to this value	Moderate 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=2024-01-01/_raw/rows.csv Filter to this value	2024-01-01 Filter to this value	15464.3 Filter to this value	13490.0 Filter to this value	2 Filter to this value	1
New York City Filter to this value	New York Filter to this value	7002054 Filter to this value	001458 Filter to this value	NEW YORK-PRESBYTERIAN HOSPITAL - NEW YORK WEILL CORNELL CENTER Filter to this value	70 or Older Filter to this value	100 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 or Self Care Filter to this value	2024 Filter to this value	SYM002 Filter to this value	FEVER Filter to this value	ADM012 Filter to this value	CHEMOTHERAPY Filter to this value	722 Filter to this value	FEVER AND INFLAMMATORY CONDITIONS Filter to this value	18 Filter to this value	INFECTIOUS AND PARASITIC DISEASES, SYSTEMIC OR UNSPECIFIED SITES 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	Private Health Insurance Filter to this value	NULL	NULL	Y Filter to this value	gs://gavel-mrf-dev-mrf/pubdata/ny-sparcs-inpatient/vintage=2024-01-01/_raw/rows.csv Filter to this value	2024-01-01 Filter to this value	9324.77 Filter to this value	49503.16 Filter to this value	2 Filter to this value	2
New York City Filter to this value	New York Filter to this value	7002054 Filter to this value	001464 Filter to this value	NEW YORK-PRESBYTERIAN HOSPITAL - COLUMBIA PRESBYTERIAN CENTER Filter to this value	0-17 Filter to this value	100 Filter to this value	F Filter to this value	Other Race Filter to this value	Not Span/Hispanic Filter to this value	Emergency Filter to this value	Home or Self Care Filter to this value	2024 Filter to this value	SYM002 Filter to this value	FEVER Filter to this value	CNS002 Filter to this value	LUMBAR PUNCTURE Filter to this value	722 Filter to this value	FEVER AND INFLAMMATORY CONDITIONS Filter to this value	18 Filter to this value	INFECTIOUS AND PARASITIC DISEASES, SYSTEMIC OR UNSPECIFIED SITES 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	2700 Filter to this value	Y Filter to this value	gs://gavel-mrf-dev-mrf/pubdata/ny-sparcs-inpatient/vintage=2024-01-01/_raw/rows.csv Filter to this value	2024-01-01 Filter to this value	7304.27 Filter to this value	27827.66 Filter to this value	1 Filter to this value	3
New York City Filter to this value	New York Filter to this value	7002032 Filter to this value	001466 Filter to this value	MOUNT SINAI WEST Filter to this value	18-29 Filter to this value	100 Filter to this value	F Filter to this value	Other Race Filter to this value	Spanish/Hispanic Filter to this value	Emergency Filter to this value	Home or Self Care Filter to this value	2024 Filter to this value	SYM002 Filter to this value	FEVER Filter to this value	ADM021 Filter to this value	ADMINISTRATION OF THERAPEUTIC SUBSTANCES, NEC Filter to this value	722 Filter to this value	FEVER AND INFLAMMATORY CONDITIONS Filter to this value	18 Filter to this value	INFECTIOUS AND PARASITIC DISEASES, SYSTEMIC OR UNSPECIFIED SITES Filter to this value	2 Filter to this value	Moderate Filter to this value	Minor 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=2024-01-01/_raw/rows.csv Filter to this value	2024-01-01 Filter to this value	7948.1 Filter to this value	32798.29 Filter to this value	1 Filter to this value	4
New York City Filter to this value	Bronx Filter to this value	7000001 Filter to this value	001178 Filter to this value	BRONXCARE HOSPITAL CENTER Filter to this value	30-49 Filter to this value	100 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	Left Against Medical Advice Filter to this value	2024 Filter to this value	RSP009 Filter to this value	ASTHMA Filter to this value	NULL	NULL	141 Filter to this value	ASTHMA Filter to this value	04 Filter to this value	DISEASES AND DISORDERS OF THE RESPIRATORY SYSTEM Filter to this value	2 Filter to this value	Moderate Filter to this value	Minor Filter to this value	Medical Filter to this value	Medicaid 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=2024-01-01/_raw/rows.csv Filter to this value	2024-01-01 Filter to this value	43136.54 Filter to this value	21902.26 Filter to this value	1 Filter to this value	5
Long Island Filter to this value	Suffolk Filter to this value	5151001 Filter to this value	000245 Filter to this value	STONY BROOK UNIVERSITY HOSPITAL Filter to this value	0-17 Filter to this value	119 Filter to this value	F Filter to this value	White Filter to this value	Not Span/Hispanic Filter to this value	Emergency Filter to this value	Home or Self Care Filter to this value	2024 Filter to this value	RSP009 Filter to this value	ASTHMA Filter to this value	NULL	NULL	141 Filter to this value	ASTHMA Filter to this value	04 Filter to this value	DISEASES AND 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	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=2024-01-01/_raw/rows.csv Filter to this value	2024-01-01 Filter to this value	6962.31 Filter to this value	25566.53 Filter to this value	2 Filter to this value	6
New York City Filter to this value	Queens Filter to this value	7003004 Filter to this value	003376 Filter to this value	COHEN'S CHILDREN MEDICAL CENTER W/ LIJ Filter to this value	0-17 Filter to this value	113 Filter to this value	M Filter to this value	Other Race Filter to this value	Not Span/Hispanic Filter to this value	Emergency Filter to this value	Home or Self Care Filter to this value	2024 Filter to this value	RSP009 Filter to this value	ASTHMA Filter to this value	ESA004 Filter to this value	NON-INVASIVE VENTILATION Filter to this value	141 Filter to this value	ASTHMA Filter to this value	04 Filter to this value	DISEASES AND 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	Medicaid Filter to this value	Self-Pay Filter to this value	NULL	Y Filter to this value	gs://gavel-mrf-dev-mrf/pubdata/ny-sparcs-inpatient/vintage=2024-01-01/_raw/rows.csv Filter to this value	2024-01-01 Filter to this value	28924.19 Filter to this value	90467.51 Filter to this value	3 Filter to this value	7
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	50-69 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	Emergency Filter to this value	Home or Self Care Filter to this value	2024 Filter to this value	RSP009 Filter to this value	ASTHMA Filter to this value	ESA004 Filter to this value	NON-INVASIVE VENTILATION Filter to this value	141 Filter to this value	ASTHMA Filter to this value	04 Filter to this value	DISEASES AND DISORDERS OF THE RESPIRATORY SYSTEM Filter to this value	2 Filter to this value	Moderate 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=2024-01-01/_raw/rows.csv Filter to this value	2024-01-01 Filter to this value	5505.13 Filter to this value	32364.56 Filter to this value	1 Filter to this value	8
Hudson Valley Filter to this value	Westchester Filter to this value	7002054 Filter to this value	001122 Filter to this value	NEW YORK-PRESBYTERIAN WESTCHESTER Filter to this value	0-17 Filter to this value	NULL	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	2024 Filter to this value	RSP009 Filter to this value	ASTHMA Filter to this value	ADM015 Filter to this value	ADMINISTRATION OF ANTIBIOTICS Filter to this value	141 Filter to this value	ASTHMA Filter to this value	04 Filter to this value	DISEASES AND DISORDERS OF THE RESPIRATORY 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=2024-01-01/_raw/rows.csv Filter to this value	2024-01-01 Filter to this value	7266.32 Filter to this value	36276.87 Filter to this value	2 Filter to this value	9

Next page, same selection

Evidence receipt r1556

Permanent saved result

Secondary typed Arrow export