A | B | C | D | E | |
---|---|---|---|---|---|
1 | file name: | facilities.csv | |||
2 | file purpose: | This file lists all physical locations where a healthcare organization has facilities that participate in testing and/or treatment of COVID-19. | |||
3 | record granularity: | Create one record for each facility. A facility is defined as any physical location where tests and/or treatments occur. | |||
4 | unknown values: | Unknown values for non-required fields should be left blank; however, a column for each field specified below should be provided, even if no values for that field are available. | |||
5 | field order: | fields should be ordered left-to-right in the order presented in the table below | |||
6 | record order: | Ignored | |||
7 | header row: | Please include a 1-line header with each of the field names listed below | |||
8 | notes: | Each record in the "metrics" file should relate to a facility_id from this file. Facilities in this file which do not relate to records in the "metrics" file will be ignored. | |||
9 | |||||
10 | file schema: | ||||
11 | field name | req | data type | description | notes |
12 | extract_timestamp | y | string | timestamp when this extract file was generated | please follow W3C standard for timestamp, e.g., 2020-03-16T19:20:30.45+01:00, per https://www.w3.org/TR/NOTE-datetime |
13 | facility_id | y | string | unique identifier for the facility where the patient was physically encountered | must be unique across the HCO; must not change between data loads |
14 | facility_cms_id | n | string | CMS ID associated with the facility | if applicable |
15 | facility_name | y | string | public-facing name of the facility | will be displayed on maps |
16 | facility_address | y | string | street address of facility | no floor numbers, room numbers, or delivery instructions |
17 | facility_city | y | string | city of facility | |
18 | facility_state | y | string | state of facility | can be two-character postal format or full state name |
19 | facility_zipcode | y | string | zip code of facility | 5- or 9-digit zip acceptable. Hyphenation will be ignored. |
20 | place_of_service_code | n | string | one of the two-digit place of service codes as defined by CMS: https://www.cms.gov/Medicare/Coding/place-of-service-codes/Place_of_Service_Code_Set | if facility_cms_id is supplied, this field can be left blank |
21 | facility_longitude | y | double | (depracated) longitude of physical location of the facility | will be ignored |
22 | facility_latitude | y | double | (depracated) latitude of physical location of the facility | will be ignored |
23 | |||||
24 | |||||
25 | |||||
26 | |||||
27 | |||||
28 | |||||
29 | |||||
30 | |||||
31 | |||||
32 | |||||
33 | |||||
34 | |||||
35 | |||||
36 | |||||
37 | |||||
38 | |||||
39 | |||||
40 | |||||
41 | |||||
42 | |||||
43 | |||||
44 | |||||
45 | |||||
46 | |||||
47 | |||||
48 | |||||
49 | |||||
50 | |||||
51 | |||||
52 | |||||
53 | |||||
54 | |||||
55 | |||||
56 | |||||
57 | |||||
58 | |||||
59 | |||||
60 | |||||
61 | |||||
62 | |||||
63 | |||||
64 | |||||
65 | |||||
66 | |||||
67 | |||||
68 | |||||
69 | |||||
70 | |||||
71 | |||||
72 | |||||
73 | |||||
74 | |||||
75 | |||||
76 | |||||
77 | |||||
78 | |||||
79 | |||||
80 | |||||
81 | |||||
82 | |||||
83 | |||||
84 | |||||
85 | |||||
86 | |||||
87 | |||||
88 | |||||
89 | |||||
90 | |||||
91 | |||||
92 | |||||
93 | |||||
94 | |||||
95 | |||||
96 | |||||
97 | |||||
98 | |||||
99 | |||||
100 |