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.
Read the method for this source
Explore this source with typed OData queries · Filtering, grouping and evidence method
Schema and filter instructions · Count this selection · First records
Filters: eq.column, lt.column, le.column, gt.column, ge.column; isnull.column=true|false. Values are cast to the source type. Projection: columns=a,b. Order: order=a:asc,b:desc with stable physical row identity as final tie-breaker. OData uses the property names in the last column; RowId identifies the same physical source record.
| Column | Type | OData property |
|---|---|---|
| Hospital Service Area | VARCHAR | _x486f73706974616c20536572766963652041726561 |
| Hospital County | VARCHAR | _x486f73706974616c20436f756e7479 |
| Operating Certificate Number | VARCHAR | _x4f7065726174696e67204365727469666963617465204e756d626572 |
| Permanent Facility Id | VARCHAR | _x5065726d616e656e7420466163696c697479204964 |
| Facility Name | VARCHAR | _x466163696c697479204e616d65 |
| Age Group | VARCHAR | _x4167652047726f7570 |
| Zip Code - 3 digits | VARCHAR | _x5a697020436f6465202d203320646967697473 |
| Gender | VARCHAR | Gender |
| Race | VARCHAR | Race |
| Ethnicity | VARCHAR | Ethnicity |
| Type of Admission | VARCHAR | _x54797065206f662041646d697373696f6e |
| Patient Disposition | VARCHAR | _x50617469656e7420446973706f736974696f6e |
| Discharge Year | VARCHAR | _x4469736368617267652059656172 |
| CCSR Diagnosis Code | VARCHAR | _x4343535220446961676e6f73697320436f6465 |
| CCSR Diagnosis Description | VARCHAR | _x4343535220446961676e6f736973204465736372697074696f6e |
| CCSR Procedure Code | VARCHAR | _x434353522050726f63656475726520436f6465 |
| CCSR Procedure Description | VARCHAR | _x434353522050726f636564757265204465736372697074696f6e |
| APR DRG Code | VARCHAR | _x4150522044524720436f6465 |
| APR DRG Description | VARCHAR | _x41505220445247204465736372697074696f6e |
| APR MDC Code | VARCHAR | _x415052204d444320436f6465 |
| APR MDC Description | VARCHAR | _x415052204d4443204465736372697074696f6e |
| APR Severity of Illness Code | VARCHAR | _x415052205365766572697479206f6620496c6c6e65737320436f6465 |
| APR Severity of Illness Description | VARCHAR | _x415052205365766572697479206f6620496c6c6e657373204465736372697074696f6e |
| APR Risk of Mortality | VARCHAR | _x415052205269736b206f66204d6f7274616c697479 |
| APR Medical Surgical Description | VARCHAR | _x415052204d65646963616c20537572676963616c204465736372697074696f6e |
| Payment Typology 1 | VARCHAR | _x5061796d656e74205479706f6c6f67792031 |
| Payment Typology 2 | VARCHAR | _x5061796d656e74205479706f6c6f67792032 |
| Payment Typology 3 | VARCHAR | _x5061796d656e74205479706f6c6f67792033 |
| Birth Weight | VARCHAR | _x426972746820576569676874 |
| Emergency Department Indicator | VARCHAR | _x456d657267656e6379204465706172746d656e7420496e64696361746f72 |
| filename | VARCHAR | filename |
| vintage | DATE | vintage |
| Total Costs | DOUBLE | _x546f74616c20436f737473 |
| Total Charges | DOUBLE | _x546f74616c2043686172676573 |
| Length of Stay | INTEGER | _x4c656e677468206f662053746179 |