Codebook
Every field, what type it is and what it means
348 fields in 3 tables and 14 views. Definitions come from the database README; 228 fields it does not yet describe are marked as such.
Abbreviations used on this page
- CCN
- CMS Certification Number (provider number)
- CMS
- Centers for Medicare & Medicaid Services
- CON
- certificate of need
- COPN
- Certificate of Public Need (Virginia)
- CT
- computed tomography
- DGSF
- departmental gross square feet
- DoN
- Determination of Need (Massachusetts)
- ED
- emergency department
- EIS
- environmental impact statement (environmental review)
- FTE
- full-time equivalent
- FY
- fiscal year
- GSF
- gross square feet
- HCRIS
- Healthcare Cost Report Information System
- ICU
- intensive care unit
- IMP
- institutional master plan
- MRI
- magnetic resonance imaging
- NICU
- neonatal intensive care unit
- NSF
- net square feet
- OR
- operating room
- PACU
- post-anesthesia care unit
- SNF
- skilled nursing facility
- VA
- Department of Veterans Affairs
documents table
One row per filing, plan or report.
| Field | Type | Definition |
|---|---|---|
doc_id | TEXT | Stable hash of url + facility + project. |
state | TEXT | State of the facility; federal (VA, Department of Defense) records carry the state where the facility sits. |
city | TEXT | Not described in the README yet. |
facility_name | TEXT | Not described in the README yet. |
health_system | TEXT | Not described in the README yet. |
project_name | TEXT | Not described in the README yet. |
source_type | TEXT | Kind of filing: CON (certificate of need), DoN (Massachusetts Determination of Need), COPN (Virginia Certificate of Public Need), state_review, IMP (institutional master plan), EIS (environmental review), zoning, board_item or budget. |
filing_id | TEXT | Not described in the README yet. |
filing_date | TEXT | Not described in the README yet. |
filing_year | INTEGER | Not described in the README yet. |
url | TEXT | Not described in the README yet. |
landing_url | TEXT | Not described in the README yet. |
scope | TEXT | What the document covers: project, building, campus or system. |
project_type | TEXT | Not described in the README yet. |
has_departmental_breakdown | INTEGER | Whether the document has a departmental square footage table. |
verification | TEXT | How the document was read: opened, ocr (text recognition from a scan) or snippet_only (search snippets or news only). |
check_status | TEXT | Result of the second-pass check, for documents in its sample. |
check_notes | TEXT | Not described in the README yet. |
notes | TEXT | Not described in the README yet. |
regime_id | INTEGER | The program (regimes table) the filing was made under. |
research_slice | TEXT | Not described in the README yet. |
metrics table
Long format, one row per figure extracted from a document.
| Field | Type | Definition |
|---|---|---|
metric_id | INTEGER | Not described in the README yet. |
doc_id | TEXT | The document the figure comes from. |
metric | TEXT | Figure name, from the README vocabulary: space (total_gsf, new_construction_gsf, dgsf ...), beds (beds_total, beds_icu ...), rooms and equipment (ors, cath_labs, mri ...), other (floors, project_cost_usd, dgsf_per_unit_standard ...). |
metric_group | TEXT | space, beds, procedural, imaging, ed_obstetric, cost, building or other. |
value | REAL | Not described in the README yet. |
unit | TEXT | Not described in the README yet. |
department | TEXT | The department name as written in the filing. Check it before relying on department_std. |
department_std | TEXT | A rough keyword grouping of department names (Surgery / Perioperative, Imaging / Radiology, Emergency, Intensive Care, Inpatient Nursing Units and so on). Some department rows are unmapped. |
status | TEXT | existing, proposed, new_construction, renovation, resulting (total after the project), net_new (change only), approved, as_built, total. Most figures are proposed, not as-built. Keep net_new and resulting apart when summing. |
note | TEXT | Not described in the README yet. |
check_flag | TEXT | Set where the second-pass check corrected a value or could not find it in the source. |
hcris_reports table
One row per fiscal year 2023 Medicare cost report.
| Field | Type | Definition |
|---|---|---|
rpt_rec_num | INTEGER | The cost report's record number in the CMS file. |
ccn | TEXT | CMS Certification Number (provider number). |
npi | TEXT | Not described in the README yet. |
hospital_name | TEXT | Hospital name from Worksheet S-2 Part I. |
street | TEXT | Address from Worksheet S-2 Part I. |
city | TEXT | Address from Worksheet S-2 Part I. |
state | TEXT | Address from Worksheet S-2 Part I. |
zip | TEXT | Address from Worksheet S-2 Part I. |
county | TEXT | Address from Worksheet S-2 Part I. |
hospital_type | TEXT | Derived from the CCN range: short-term acute, critical access, long-term care hospital, rehabilitation, children's, psychiatric. |
control_type_cd | TEXT | Not described in the README yet. |
report_status_cd | TEXT | Not described in the README yet. |
fy_begin | TEXT | Not described in the README yet. |
fy_end | TEXT | Not described in the README yet. |
is_latest_for_ccn | INTEGER | 1 on the latest report for each CCN. For benchmarking use is_latest_for_ccn = 1 AND sf_quality_flag IS NULL. |
beds_adult_peds | INTEGER | Beds, Worksheet S-3 Part I column 2, line 7 (adults and pediatrics). |
beds_hospital_total | INTEGER | Beds, Worksheet S-3 Part I column 2, line 14 (hospital total). |
beds_facility_total | INTEGER | Beds, Worksheet S-3 Part I column 2, line 27 (facility total). |
building_sf_total | REAL | Square feet: Worksheet B-1, building-and-fixture capital columns 1.00-1.99. It adds up each column's reported total, so space passed between buildings is counted twice in a few reports. |
building_cost_allocated | REAL | Not described in the README yet. |
building_cost_per_sf | REAL | Building capital cost per square foot. A value outside $2-$400 is one reason for sf_quality_flag. |
sf_quality_flag | TEXT | Set on reports whose statistic is not usable as square feet: for example no building statistics, departments not summing to the total, or a capital cost per square foot outside $2-$400. |
sf_warning | TEXT | "over 20,000 sf per hospital bed; check" or "space repeats across B-1 building columns (N% of department space); total overstated"; both joined with " | " when both apply. |
v_department_cost_benchmarks view
One row per hospital type (plus All types) per standard department: number of hospitals, median square feet, and the 25th percentile, median and 75th percentile of direct and fully allocated cost per square foot.
| Field | Type | Definition |
|---|---|---|
hospital_type | TEXT | Derived from the CCN range: short-term acute, critical access, long-term care hospital, rehabilitation, children's, psychiatric. |
standard_line | INTEGER | Cost report standard department line; subscripted Worksheet A lines roll up to these (for example 30 adults & pediatrics, 31 ICU, 50 operating room, 91 emergency). |
standard_name | TEXT | Not described in the README yet. |
category | TEXT | Not described in the README yet. |
hospitals | INTEGER | Not described in the README yet. |
median_sf | REAL | Not described in the README yet. |
p25_direct_cost_per_sf | REAL | Not described in the README yet. |
median_direct_cost_per_sf | REAL | Not described in the README yet. |
p75_direct_cost_per_sf | REAL | Not described in the README yet. |
hospitals_with_allocated_cost | INTEGER | Not described in the README yet. |
p25_fully_allocated_cost_per_sf | REAL | Not described in the README yet. |
median_fully_allocated_cost_per_sf | REAL | Not described in the README yet. |
p75_fully_allocated_cost_per_sf | REAL | Not described in the README yet. |
v_departmental_space view
Every departmental square footage row with its document.
| Field | Type | Definition |
|---|---|---|
state | TEXT | Not described in the README yet. |
facility_name | TEXT | Not described in the README yet. |
project_name | TEXT | Not described in the README yet. |
source_type | TEXT | Not described in the README yet. |
filing_year | INTEGER | Not described in the README yet. |
department | TEXT | Not described in the README yet. |
department_std | TEXT | A rough keyword grouping of department names. Some department rows are unmapped. |
status | TEXT | existing, proposed, new_construction, renovation, resulting (total after the project), net_new (change only), approved, as_built, total. Most figures are proposed, not as-built. Keep net_new and resulting apart when summing. |
dgsf | REAL | Departmental gross square feet. |
note | TEXT | Not described in the README yet. |
url | TEXT | Not described in the README yet. |
doc_id | TEXT | Not described in the README yet. |
v_doc_beds_vs_hcris view
Bed counts in linked documents next to the hospital's fiscal year 2023 cost report beds. Filter on status (usually existing) and department IS NULL before comparing.
| Field | Type | Definition |
|---|---|---|
doc_id | TEXT | Not described in the README yet. |
state | TEXT | Not described in the README yet. |
facility_name | TEXT | Not described in the README yet. |
project_name | TEXT | Not described in the README yet. |
source_type | TEXT | Not described in the README yet. |
filing_year | INTEGER | Not described in the README yet. |
ccn | TEXT | CMS Certification Number (provider number). |
hcris_name | TEXT | Not described in the README yet. |
link_confidence | TEXT | Strength of the document-to-hospital match: high or medium. |
metric | TEXT | Not described in the README yet. |
status | TEXT | existing, proposed, new_construction, renovation, resulting (total after the project), net_new (change only), approved, as_built, total. Most figures are proposed, not as-built. Keep net_new and resulting apart when summing. |
department | TEXT | Not described in the README yet. |
doc_beds | REAL | Not described in the README yet. |
hcris_beds | REAL | Not described in the README yet. |
hcris_fy_end | TEXT | Not described in the README yet. |
url | TEXT | Not described in the README yet. |
v_document_summary view
One wide row per document with headline figures (total, new and renovated square feet, beds, ICU beds, ORs, emergency department spaces, MRI, CT, cost) plus counts of department and metric rows.
| Field | Type | Definition |
|---|---|---|
doc_id | TEXT | Not described in the README yet. |
state | TEXT | Not described in the README yet. |
city | TEXT | Not described in the README yet. |
facility_name | TEXT | Not described in the README yet. |
health_system | TEXT | Not described in the README yet. |
project_name | TEXT | Not described in the README yet. |
source_type | TEXT | Not described in the README yet. |
filing_year | INTEGER | Not described in the README yet. |
project_type | TEXT | Not described in the README yet. |
scope | TEXT | Not described in the README yet. |
has_departmental_breakdown | INTEGER | Not described in the README yet. |
check_status | TEXT | Not described in the README yet. |
url | TEXT | Not described in the README yet. |
total_gsf | REAL | Total gross square feet. |
new_construction_gsf | REAL | Gross square feet of new construction. |
renovation_gsf | REAL | Gross square feet renovated. |
campus_total_gsf | REAL | Gross square feet of the whole campus. |
beds_total | REAL | Total beds. |
beds_icu | REAL | Intensive care unit beds. |
ors | REAL | Operating rooms. |
ed_treatment_spaces | REAL | Emergency department treatment spaces. |
mri | REAL | Magnetic resonance imaging units. |
ct | REAL | Computed tomography units. |
project_cost_usd | REAL | Project cost in US dollars. |
dept_rows | INTEGER | Number of departmental square footage rows in the document. |
metric_rows | INTEGER | Number of figures (metrics rows) in the document. |
v_hcris_building_department_space view
One row per hospital per building per department, with the department's square feet, share of the building and building capital.
| Field | Type | Definition |
|---|---|---|
ccn | TEXT | CMS Certification Number (provider number). |
hospital_name | TEXT | Hospital name from Worksheet S-2 Part I. |
state | TEXT | Not described in the README yet. |
hospital_type | TEXT | Derived from the CCN range: short-term acute, critical access, long-term care hospital, rehabilitation, children's, psychiatric. |
building_seq | INTEGER | Not described in the README yet. |
building_name | TEXT | Not described in the README yet. |
line_num | TEXT | Not described in the README yet. |
standard_line | INTEGER | Cost report standard department line; subscripted Worksheet A lines roll up to these (for example 30 adults & pediatrics, 31 ICU, 50 operating room, 91 emergency). |
standard_name | TEXT | Not described in the README yet. |
cost_center_name | TEXT | Not described in the README yet. |
category | TEXT | Not described in the README yet. |
square_feet | REAL | Not described in the README yet. |
pct_of_building | REAL | Not described in the README yet. |
alloc_building_capital | REAL | Not described in the README yet. |
sf_quality_flag | TEXT | Set on reports whose statistic is not usable as square feet: for example no building statistics, departments not summing to the total, or a capital cost per square foot outside $2-$400. |
v_hcris_buildings view
One row per hospital (latest report) per building with space: square feet and share of the hospital's space, departments, square feet by category, building capital cost per square foot, and double-count checks.
| Field | Type | Definition |
|---|---|---|
ccn | TEXT | CMS Certification Number (provider number). |
hospital_name | TEXT | Hospital name from Worksheet S-2 Part I. |
city | TEXT | Not described in the README yet. |
state | TEXT | Not described in the README yet. |
hospital_type | TEXT | Derived from the CCN range: short-term acute, critical access, long-term care hospital, rehabilitation, children's, psychiatric. |
buildings_with_space | INTEGER | Number of building columns with space, for filtering to hospitals that split their space (two or more). |
pct_hospital_sf_repeated | REAL | Not described in the README yet. |
possible_double_count | INTEGER | 1 when at least 5% of the hospital's space repeats exactly across building columns. |
building_seq | INTEGER | Not described in the README yet. |
building_name | TEXT | Not described in the README yet. |
square_feet | REAL | Not described in the README yet. |
pct_of_hospital_sf | REAL | Not described in the README yet. |
pct_duplicated_in_other_columns | REAL | Not described in the README yet. |
department_lines | INTEGER | Not described in the README yet. |
largest_department | TEXT | Not described in the README yet. |
largest_department_sf | REAL | Not described in the README yet. |
sf_inpatient_routine | REAL | Square feet in the Inpatient routine category. |
sf_ancillary | REAL | Square feet in the Ancillary category. |
sf_outpatient | REAL | Square feet in the Outpatient category. |
sf_general_service | REAL | Square feet in the General service category. |
sf_other_reimbursable | REAL | Not described in the README yet. |
sf_nonreimbursable | REAL | Square feet in the Nonreimbursable category. |
sf_total_reported | REAL | Not described in the README yet. |
sf_to_other_capital | REAL | Not described in the README yet. |
capital_cost | REAL | Not described in the README yet. |
capital_cost_per_unit | REAL | Not described in the README yet. |
sf_quality_flag | TEXT | Set on reports whose statistic is not usable as square feet: for example no building statistics, departments not summing to the total, or a capital cost per square foot outside $2-$400. |
sf_warning | TEXT | "over 20,000 sf per hospital bed; check" or "space repeats across B-1 building columns (N% of department space); total overstated"; both joined with " | " when both apply. |
v_hcris_capacity view
One row per hospital (latest report, all CCNs): beds by unit, occupancy, average length of stay, Medicare and Medicaid day shares, FTEs, residents per bed and teaching intensity, square feet per FTE and per bed by unit, building asset balances and key S-2 flags. Square-foot ratios are blank when sf_quality_flag is set.
| Field | Type | Definition |
|---|---|---|
ccn | TEXT | CMS Certification Number (provider number). |
hospital_name | TEXT | Hospital name from Worksheet S-2 Part I. |
city | TEXT | Not described in the README yet. |
state | TEXT | Not described in the README yet. |
hospital_type | TEXT | Derived from the CCN range: short-term acute, critical access, long-term care hospital, rehabilitation, children's, psychiatric. |
type_hosp | TEXT | Not described in the README yet. |
ownership | TEXT | Not described in the README yet. |
fy_begin | TEXT | Not described in the README yet. |
fy_end | TEXT | Not described in the README yet. |
beds_total | REAL | Total beds. |
beds_adult_peds | REAL | Beds, Worksheet S-3 Part I column 2, line 7 (adults and pediatrics). |
beds_icu | REAL | Intensive care unit beds. |
beds_ccu | REAL | Not described in the README yet. |
beds_burn_icu | REAL | Not described in the README yet. |
beds_surgical_icu | REAL | Not described in the README yet. |
beds_other_special_care | REAL | Not described in the README yet. |
beds_intensive_all | REAL | Not described in the README yet. |
beds_ipf | REAL | Not described in the README yet. |
beds_irf | REAL | Not described in the README yet. |
beds_snf | REAL | Not described in the README yet. |
beds_nf | REAL | Not described in the README yet. |
beds_labor_delivery | REAL | Not described in the README yet. |
beds_facility_total | REAL | Beds, Worksheet S-3 Part I column 2, line 27 (facility total). |
bed_days_available | REAL | Not described in the README yet. |
inpatient_days | REAL | Not described in the README yet. |
discharges | REAL | Not described in the README yet. |
occupancy_pct | REAL | Not described in the README yet. |
avg_length_of_stay | REAL | Not described in the README yet. |
medicare_day_pct | REAL | Not described in the README yet. |
medicaid_day_pct | REAL | Not described in the README yet. |
intensive_days | REAL | Not described in the README yet. |
intensive_occupancy_pct | REAL | Not described in the README yet. |
nursery_days | REAL | Not described in the README yet. |
observation_bed_days | REAL | Not described in the README yet. |
labor_delivery_days | REAL | Not described in the README yet. |
ipf_days | REAL | Not described in the README yet. |
irf_days | REAL | Not described in the README yet. |
snf_days | REAL | Not described in the README yet. |
cah_outpatient_visits | REAL | Not described in the README yet. |
fte_employees_hospital | REAL | Not described in the README yet. |
fte_employees_facility | REAL | Not described in the README yet. |
fte_residents_facility | REAL | Not described in the README yet. |
residents_per_bed | REAL | Not described in the README yet. |
teaching_intensity | TEXT | Not described in the README yet. |
building_sf_total | REAL | Square feet: Worksheet B-1, building-and-fixture capital columns 1.00-1.99. It adds up each column's reported total, so space passed between buildings is counted twice in a few reports. |
sf_per_fte | REAL | Not described in the README yet. |
sf_per_adult_peds_bed | REAL | Not described in the README yet. |
sf_per_intensive_bed | REAL | Not described in the README yet. |
sf_per_ipf_bed | REAL | Not described in the README yet. |
sf_per_irf_bed | REAL | Not described in the README yet. |
sf_per_snf_bed | REAL | Not described in the README yet. |
sf_per_labor_delivery_bed | REAL | Not described in the README yet. |
bldg_assets_beginning | REAL | Not described in the README yet. |
bldg_purchases | REAL | Not described in the README yet. |
bldg_disposals | REAL | Not described in the README yet. |
bldg_assets_ending | REAL | Not described in the README yet. |
bldg_purchases_pct_of_beginning | REAL | Not described in the README yet. |
bldg_assets_per_sf | REAL | Not described in the README yet. |
fixed_equipment_ending | REAL | Not described in the README yet. |
movable_equipment_ending | REAL | Not described in the README yet. |
movable_equipment_purchases | REAL | Not described in the README yet. |
total_capital_assets_ending | REAL | Not described in the README yet. |
teaching_hospital | TEXT | Not described in the README yet. |
critical_access_hospital | TEXT | Not described in the README yet. |
transplant_center | TEXT | Not described in the README yet. |
transplant_programs | TEXT | Not described in the README yet. |
rural_referral_center | TEXT | Not described in the README yet. |
dsh_hospital | TEXT | Not described in the README yet. |
geo_class_end | TEXT | Not described in the README yet. |
multicampus | TEXT | Not described in the README yet. |
campus_count | INTEGER | Not described in the README yet. |
chain_name | TEXT | Not described in the README yet. |
sf_quality_flag | TEXT | Set on reports whose statistic is not usable as square feet: for example no building statistics, departments not summing to the total, or a capital cost per square foot outside $2-$400. |
sf_warning | TEXT | "over 20,000 sf per hospital bed; check" or "space repeats across B-1 building columns (N% of department space); total overstated"; both joined with " | " when both apply. |
v_hcris_department_cost view
One row per hospital (latest report) per cost center: square feet, salaries, direct and fully allocated cost, and charges, plus each per square foot. Per-square-foot figures are blank when sf_quality_flag is set.
| Field | Type | Definition |
|---|---|---|
ccn | TEXT | CMS Certification Number (provider number). |
hospital_name | TEXT | Hospital name from Worksheet S-2 Part I. |
state | TEXT | Not described in the README yet. |
hospital_type | TEXT | Derived from the CCN range: short-term acute, critical access, long-term care hospital, rehabilitation, children's, psychiatric. |
fy_end | TEXT | Not described in the README yet. |
line_num | TEXT | Not described in the README yet. |
standard_line | INTEGER | Cost report standard department line; subscripted Worksheet A lines roll up to these (for example 30 adults & pediatrics, 31 ICU, 50 operating room, 91 emergency). |
standard_name | TEXT | Not described in the README yet. |
cost_center_name | TEXT | Not described in the README yet. |
category | TEXT | Not described in the README yet. |
square_feet | REAL | Not described in the README yet. |
salaries | REAL | Not described in the README yet. |
direct_costs | REAL | Not described in the README yet. |
alloc_building_capital | REAL | Not described in the README yet. |
fully_allocated_costs | REAL | Not described in the README yet. |
inpatient_charges | REAL | Not described in the README yet. |
outpatient_charges | REAL | Not described in the README yet. |
total_charges | REAL | Not described in the README yet. |
cost_to_charge_ratio | REAL | Not described in the README yet. |
salaries_per_sf | REAL | Not described in the README yet. |
direct_cost_per_sf | REAL | Not described in the README yet. |
fully_allocated_cost_per_sf | REAL | Not described in the README yet. |
charges_per_sf | REAL | Not described in the README yet. |
sf_warning | TEXT | "over 20,000 sf per hospital bed; check" or "space repeats across B-1 building columns (N% of department space); total overstated"; both joined with " | " when both apply. |
v_hcris_department_space view
Cost report department rows with share of the hospital's total.
| Field | Type | Definition |
|---|---|---|
ccn | TEXT | CMS Certification Number (provider number). |
hospital_name | TEXT | Hospital name from Worksheet S-2 Part I. |
state | TEXT | Not described in the README yet. |
hospital_type | TEXT | Derived from the CCN range: short-term acute, critical access, long-term care hospital, rehabilitation, children's, psychiatric. |
beds_hospital_total | INTEGER | Beds, Worksheet S-3 Part I column 2, line 14 (hospital total). |
standard_line | INTEGER | Cost report standard department line; subscripted Worksheet A lines roll up to these (for example 30 adults & pediatrics, 31 ICU, 50 operating room, 91 emergency). |
standard_name | TEXT | Not described in the README yet. |
cost_center_name | TEXT | Not described in the README yet. |
category | TEXT | Not described in the README yet. |
square_feet | REAL | Not described in the README yet. |
pct_of_building | REAL | Not described in the README yet. |
v_hcris_hospital_space view
One row per hospital (latest report, usable square footage only): total square feet, beds, square feet per bed, capital cost per square foot, and square feet by category and key departments (OR, emergency, imaging, intensive care).
| Field | Type | Definition |
|---|---|---|
ccn | TEXT | CMS Certification Number (provider number). |
hospital_name | TEXT | Hospital name from Worksheet S-2 Part I. |
city | TEXT | Not described in the README yet. |
state | TEXT | Not described in the README yet. |
hospital_type | TEXT | Derived from the CCN range: short-term acute, critical access, long-term care hospital, rehabilitation, children's, psychiatric. |
fy_end | TEXT | Not described in the README yet. |
beds_hospital_total | INTEGER | Beds, Worksheet S-3 Part I column 2, line 14 (hospital total). |
building_sf_total | REAL | Square feet: Worksheet B-1, building-and-fixture capital columns 1.00-1.99. It adds up each column's reported total, so space passed between buildings is counted twice in a few reports. |
sf_per_bed | REAL | Building square feet per hospital bed (building_sf_total / beds_hospital_total). |
capital_cost_per_sf | REAL | Building capital cost per square foot. |
sf_inpatient_routine | REAL | Square feet in the Inpatient routine category. |
sf_ancillary | REAL | Square feet in the Ancillary category. |
sf_outpatient | REAL | Square feet in the Outpatient category. |
sf_general_service | REAL | Square feet in the General service category. |
sf_nonreimbursable | REAL | Square feet in the Nonreimbursable category. |
sf_operating_room | REAL | Square feet on standard line 50, operating room. |
sf_emergency | REAL | Square feet on standard line 91, emergency. |
sf_imaging | REAL | Square feet on standard lines 54-58 (radiology, CT, MRI and related). |
sf_intensive_care | REAL | Square feet on standard lines 31-35 (intensive care units). |
sf_warning | TEXT | "over 20,000 sf per hospital bed; check" or "space repeats across B-1 building columns (N% of department space); total overstated"; both joined with " | " when both apply. |
v_project_current view
The latest accepted observation per project and field. A tie on date goes to the later stage.
| Field | Type | Definition |
|---|---|---|
project_id | TEXT | Not described in the README yet. |
field | TEXT | Not described in the README yet. |
value_text | TEXT | Not described in the README yet. |
value_num | REAL | Not described in the README yet. |
effective_date | TEXT | Not described in the README yet. |
source_url | TEXT | Not described in the README yet. |
obs_id | TEXT | Not described in the README yet. |
v_project_vs_hospital view
Each linked document's program next to its hospital's fiscal year 2023 reported space, with the project's square footage as a percentage of the hospital's.
| Field | Type | Definition |
|---|---|---|
doc_id | TEXT | Not described in the README yet. |
state | TEXT | Not described in the README yet. |
facility_name | TEXT | Not described in the README yet. |
project_name | TEXT | Not described in the README yet. |
source_type | TEXT | Not described in the README yet. |
filing_year | INTEGER | Not described in the README yet. |
project_type | TEXT | Not described in the README yet. |
ccn | TEXT | CMS Certification Number (provider number). |
hcris_name | TEXT | Not described in the README yet. |
link_confidence | TEXT | Strength of the document-to-hospital match: high or medium. |
total_gsf | REAL | Total gross square feet. |
new_construction_gsf | REAL | Gross square feet of new construction. |
renovation_gsf | REAL | Gross square feet renovated. |
project_beds | REAL | Not described in the README yet. |
project_ors | REAL | Not described in the README yet. |
project_ed_spaces | REAL | Not described in the README yet. |
project_cost_usd | REAL | Project cost in US dollars. |
hospital_sf_fy2023 | REAL | Not described in the README yet. |
hospital_beds_fy2023 | INTEGER | Not described in the README yet. |
sf_per_bed | REAL | Building square feet per hospital bed (building_sf_total / beds_hospital_total). |
sf_operating_room | REAL | Square feet on standard line 50, operating room. |
sf_emergency | REAL | Square feet on standard line 91, emergency. |
sf_imaging | REAL | Square feet on standard lines 54-58 (radiology, CT, MRI and related). |
sf_intensive_care | REAL | Square feet on standard lines 31-35 (intensive care units). |
project_pct_of_hospital_sf | REAL | Not described in the README yet. |
url | TEXT | Not described in the README yet. |
v_proposed_vs_built view
Each proposed, approved or resulting figure in a high-confidence linked filing, next to the same metric for the same CCN in every as-built data year from the filing year on. Only facility totals are compared.
| Field | Type | Definition |
|---|---|---|
doc_id | TEXT | Not described in the README yet. |
state | TEXT | Not described in the README yet. |
facility_name | TEXT | Not described in the README yet. |
project_name | TEXT | Not described in the README yet. |
filing_year | INTEGER | Not described in the README yet. |
ccn | TEXT | CMS Certification Number (provider number). |
metric_id | INTEGER | Not described in the README yet. |
metric | TEXT | Not described in the README yet. |
status | TEXT | existing, proposed, new_construction, renovation, resulting (total after the project), net_new (change only), approved, as_built, total. Most figures are proposed, not as-built. Keep net_new and resulting apart when summing. |
proposed_value | REAL | Not described in the README yet. |
proposed_unit | TEXT | Not described in the README yet. |
data_year | INTEGER | Not described in the README yet. |
built_value | REAL | Not described in the README yet. |
built_unit | TEXT | Not described in the README yet. |
as_built_rows | INTEGER | Not described in the README yet. |
years_after_filing | INTEGER | Not described in the README yet. |
v_state_coverage view
Programs and documents by state.
| Field | Type | Definition |
|---|---|---|
state | TEXT | Not described in the README yet. |
regimes | INTEGER | Not described in the README yet. |
regime_space_data | TEXT | Not described in the README yet. |
documents | INTEGER | Not described in the README yet. |
docs_with_dept_tables | INTEGER | Not described in the README yet. |