National Response Portal HCO Data Schema 1.1

	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