location

Standarized Health System Data Tables

Table Columns

field	type	required	phi	phi scrubbing operation
location_id	INTEGER	Yes	No	Not Stable between Data Refreshes
address_1	STRING	No	Yes	Del
address_2	STRING	No	Yes	Del
city	STRING	No	Yes	Del
state	STRING	No	Yes
zip	STRING	No	Yes	RedZip
county	STRING	No	No	Del
location_source_value	STRING	No	Yes	Del
unit_id (Stanford construct for traceability)	STRING	No	No
load_table_id (Stanford construct for traceability)	STRING	No	No
_census_block_group (available only at Stanford)	STRING	No	Yes	Drop
latitude (available only at Stanford)	FLOAT	No	Yes	Drop
longitude (available only at Stanford)	FLOAT	No	Yes	Drop

Columns Description

location_id

A unique identifier for each geographic location.

address_1

The address field 1, typically used for the street address, as it appears in the source data.

address_2

The address field 2, typically used for additional detail such as buildings, suites, floors, as it appears in the source data.

city

The city field as it appears in the source data.

state

The state field as it appears in the source data.

zip

The 5 digit zip or postal code of the locatin address

county

The name of the county.

location_source_value

The MRN|DOB of the person this location corresponds to

unit_id (stanford construct for traceability)

Is a reference for the position in the ETL code responsible for bringing in this row level data

load_table_id (stanford construct for traceability)

A json string with the primary keys of the table in Clarity where most of the information for a given row is sourced

_census_block_group (available only at stanford)

The census block group as indicated by United States Census Bureau API for this address location

latitude (available only at stanford)

latitude of the address if available

longitude (available only at stanford)

longitude of the address if available