HL7 v2 ADT Feed → Patient Roster¶
What
Pull a flat patient roster (MRN, name, birth date, sex) out of a feed
of HL7 v2 ADT messages — keeping only the PID segments, splitting the
^-delimited name components, and reformatting the birth date — with no HL7
parser library.
Why interesting¶
HL7 v2 is the messaging standard that runs hospitals, and it is awkward for
tabular tools: a feed is a stream of pipe-delimited messages, each a stack
of segments (MSH, EVN, PID, PV1, OBX, …) on their own lines, with
^-delimited sub-components nested inside fields. The patient demographics you
usually want live only in the PID segment, scattered among a dozen other
segment types. Extracting them is normally a job for a dedicated HL7 library;
bxp does it as a row filter plus a few field splits.
Edge cases sourced from.
- HL7 v2 segment/field structure (pipe field separator,
^component separator, thePIDsegment, XPN name type) is defined by the HL7 v2 standard. - Real names carry sub-components:
EVERYMAN&&&&Aniston^ADAM^…(the family field itself has&-subcomponents). - Birth dates appear as bare
YYYYMMDDand as full timestamps (198808181126+0215); some patients are born before 1970.
Data source. Real published HL7 v2 sample messages from
Microsoft's open-source FHIR-Converter
(data/SampleData/Hl7v2/ADT-*.hl7, MIT licence) — a project documenting the
HL7-v2→FHIR conversion problem. The patient values are example data (real PHI
can't be published), but the message files are real published reference
artifacts, not fabricated. (This slice: five messages with distinct patients —
incl. Donald Duck, born 1924.)
The trick¶
(see sample.json):
- Headerless input:
csv_delimiter_in: "|"makes each segment a row, andcsv_header_line: 0says the file has no header line at all — nothing is consumed as column names, so the very firstMSHsegment stays a data row. With no header names to look up, fields are addressed positionally with theFIELDS(n)accessor ([Name]in bxp is always a by-header lookup, never an index). - Row filter:
row_ruleswithwhen: "FIELDS(1) = 'PID'"— emit a row only forPIDsegments;MSH/EVN/PV1/OBX/… produce nothing. - Name components:
SPLIT_PART(FIELDS(6), '^', N)for family/given, then a secondSPLIT_PART(…, '&', 1)to peel the surname out of its sub-components. - Birth date — string slice. This is a pure
YYYYMMDD→ISO reformat, soLEFT(FIELDS(8),4) & '-' & SUBSTR(FIELDS(8),5,2) & '-' & SUBSTR(FIELDS(8),7,2)does the job directly — no format tokens to get right, no date validation.DATE_CONVERT(FIELDS(8), 'YYYYMMDD', 'YYYY-MM-DD')works equally well here (including the 1924 birth date, and it ignores the trailing time on198808181126+0215—DATE_CONVERTis a pure parse→format reshuffle with no lower-year limit); string slicing is shown as the leaner idiom for a fixed-width layout.
At full scale¶
bash fetch-full.sh # downloads every ADT-*.hl7 (~57 messages), concatenated
bxp-cli --config full.json # one roster row per PID segment (~60)
Final result¶
A 53-line feed carrying 22 different segment types reduces to the five patient rows that matter, and the pre-1970 birth date survives intact:
mrn,family,given,dob,sex
PATID1234,EVERYMAN,ADAM,1988-08-18,M
12345,Test,Test,2018-02-05,F
10006579,DUCK,DONALD,1924-10-10,M
MRN12345,Doe,Jane,1978-01-01,F
0000000001,Bixby,Timothy,2008-01-06,M
That roster drops straight into a spreadsheet or a master-patient-index load — no HL7 toolkit, no per-segment bookkeeping.
Sample data¶
Run it with bxp-cli --config ./sample.json --template hl7_adt_patient_roster:
{
// HL7 v2 ADT messages — the lingua franca of hospital systems. A feed is a
// stream of pipe-delimited messages, each a stack of segments (MSH, EVN, PID,
// PV1, OBX, …); the patient demographics live in the PID segment, with
// ^-delimited sub-components inside fields. This template pulls a flat patient
// roster out of the feed: keep only PID segments, split out the name
// components, and reformat the birthdate — no HL7 parser library.
conversion_templates: {
hl7_adt_patient_roster: {
data_dir: ".",
file_pattern_in: ".hl7",
file_pattern_out: ".csvx",
// TRICK 0 — HL7's field separator is the pipe. Each segment is one line;
// read the whole feed as pipe-delimited rows.
csv_delimiter_in: "|",
csv_delimiter_out: ",",
// TRICK 0b — an HL7 feed has NO header row: the first line is an MSH
// segment, not column names. csv_header_line: 0 says "headerless" — no
// line is consumed as headers, every segment (including the first) is a
// data row, and fields are addressed by position via FIELDS(n). Without
// it the first MSH line would be silently eaten as a bogus header.
csv_header_line: 0,
input_schema: {
// TRICK 1 — PID field layout (positional): FIELDS(1)=segment id, FIELDS(4)=PID-3
// identifier list, FIELDS(6)=PID-5 patient name, FIELDS(8)=PID-7 birth date,
// FIELDS(9)=PID-8 sex. (Positional refs because HL7 segments have no header.)
$mrn: "SPLIT_PART(FIELDS(4), '^', 1)",
// TRICK 2 — PID-5 is an XPN: family^given^middle^… and the family
// component can itself carry &-subcomponents (e.g. "EVERYMAN&&&&Aniston").
// Split on '^' for family/given, then on '&' for the surname proper.
$family: "SPLIT_PART(SPLIT_PART(FIELDS(6), '^', 1), '&', 1)",
$given: "SPLIT_PART(FIELDS(6), '^', 2)",
// TRICK 3 — PID-7 birth date is YYYYMMDD (sometimes a full timestamp
// like "198808181126+0215"). This is a pure REFORMAT, so slice the
// first 8 chars with string ops rather than DATE_CONVERT: slicing
// ignores whatever trails the date, so both the bare and the
// timestamped form need one expression instead of two formats.
// (DATE_CONVERT would also work — pre-1970 dates are fully supported,
// 1924 converts fine — it just has to be told which shape to expect.)
// Guard the empty case.
$dob: "IF(ISEMPTY(FIELDS(8)), '', LEFT(FIELDS(8), 4) & '-' & SUBSTR(FIELDS(8), 5, 2) & '-' & SUBSTR(FIELDS(8), 7, 2))",
$sex: "FIELDS(9)"
},
// TRICK 4 — ROW FILTER. Each message has many segment types; emit a row
// ONLY for PID segments (`when` is false for MSH/EVN/PV1/OBX/… → those
// rows produce no output). One PID per message → one patient per message.
row_rules: [ { when: "FIELDS(1) = 'PID'", rows: [ {} ] } ],
output_schema: {
mrn: "$mrn",
family: "$family",
given: "$given",
dob: "$dob",
sex: "$sex"
}
}
}
}
MSH|^~\&|ADTApp|GHHSFacility^2.16.840.1.122848.1.30^ISO|EHRApp^1.Edu^ISO|GHHRFacility^2.16.840.1.1122848.1.32^ISO|198908181126+0215|SECURITY|ADT^A01^ADT_A01|MSG00001|P|2.8|||||USA||en-US|||22 GHH Inc.|23 GHH Inc.|24GHH^2.16.840.1.114884.10.20^ISO|25GHH^2.16.840.1.114884.10.23^ISO
SFT|Orion|2.4.3.52854|Rhapsody|2.4.3|Testactivity|20070725111624
EVN|A01|20290801070624+0115|20290801070724|01^Patient request^HL70062|C08^Woolfson^Kathleen^2ndname^Jr^Dr^MD^^DRNBR&1.3.6.1.4.1.44750.1.2.2&ISO^L^^^ANON|20210817151943.4+0200|Cona_Health^1.3.6.1.4.1.44750.1.4^ISO
PID|1|1234567^4^M11^test^MR^University Hospital^19241011^19241012|PATID1234^5^M11^test1&2.16.1&HCD^MR^GOOD HEALTH HOSPITAL~123456789^^^USSSA^SS|PATID567^^^test2|EVERYMAN&&&&Aniston^ADAM^A^III^Dr.^MD^D^^^19241012^^^^PF^Addsm~Josh&&&&Bing^^stanley^^^^L^^^^^19241010^19241015|SMITH^Angela^L|198808181126+0215|M|elbert^Son|2106-3^White^HL70005~2028-9^Asian^HL70005|1000&Hospital Lane^Ste. 123^Ann Arbor ^MI^99999^USA^M^^&W^^^20000110&20000120^^^^^^^Near Highway|GL|78788788^^CP^5555^^^1111^^^^^2222^20010110^20020110^^^^18~12121212^^CP|7777^^CP~1111^^TDD|ara^^HL70296^eng^English-us^HL70296^v2^v2.1^TextInEnglish|M^Married|AME|4000776^^^AccMgr&1.3.6.1.4.1.44750.1.2.2&ISO^VN^1^19241011^19241012|PSSN123121234|DLN-123^US^20010123|1212121^^^NTH&rt23&HCD^AND^^19241011^19241012|N^NOT HISPANIC OR LATINO^HL70189|St. Francis Community Hospital of Lower South Side|N|2|US^United States of America^ISO3166_1|Vet123^retired^ART|BT^Bhutan^ISO3166_1|20080825111630+0115|Y|||20050110015014+0315||125097000^Goat^SCT|4880003^Beagle^SCT|||CA^Canada^ISO3166_1|89898989^WPN^Internet
PD1|S^^ACR||LINDAS TEST ORGANIZATION^^SIISCLIENT818|88^Hippo^rold^H^V^Dr^MD^^TE^^^M10^DN^^||||||||||Methodist Church|||20150202^20150202
ARV|1|A|DEM|PAT|Access restricted to clinicians other than the consulting clinician|20211118103000+0215^20221118103000+0215
ROL|1|AD|PP^Primary Care Provider^HL70443|12377H87^Smith^John^A^III^DR^PHD^^PERSONNELt&1.23&HCD^B^^^BR^^^^^^19241010^19241015^Al|20220101000000|20220202000000|||408443003^General practice^SNOMED|2^Physician Clinic^HL70406|1234 Magnolia Lane, Ste. 231^^Houston^TX^33612^USA|^^Internet^fred@nnnn.com^111^813^8853999^1234|HUH AE OMU&9.8&ISO^OMU B^Bed 03^HOMERTON UNIVER^^C^Homerton UH^Floor5|Good Health Hospital^L^^^^CMS^XX^^A|
NK1|1|Evan&&&&Aniston^ADAM^A^III^Dr.^MD^D|EMC^test^ACR^CHD^^^9.0^10.0|2222&HOME&STREET^Highway^GREENSBORO^NC^27401-1020^US^BI^^jkdha&test^^^^20000110^20050111~111&Duck ST^^Fowl|78788788^WPN^Internet^5555^^^^^^^^^20010110^20020110^^^^18~121111^PRN^CP|88888888^PRN^CP^5555^^^^^^^^878777^20010110^20020110^^^^18~6666666^^BP|O|20210818|20211218|||12345567^4^M11^T1&2.16.840.1.113883.19&HCD^MR^University Hospital^19241011^19241012|TestOrg^^O12^^^^EI^^^Org12||F^^^M|19620110045504||||ara||||||||||Green^John^A^II^DR^MD^D^^^19241012^G~Josh&&&&Bing^^stanley^^^^L|898989898^^FX~88888888^^CP|Street1&Palkstreet~ST-2|I-123^^^^BA~I-222^^^^DI||2106-3^test^FDDC||Security no-23|||1515151515^WPN^CP^555544^^^^^^^^777^20010110^20020110^^^^1|444444^^CP
PV1|1|P|HUH AE OMU&9.8&ISO^OMU B^Bed 03^HOMERTON UNIVER^^C^Homerton UH^Floor5|E|1234567^4^M11^t&2.16.840.1.113883.19&HCD^ANON^University Hospital^19241011^19241012|4 East, room 136, bed B 4E^136^B^CommunityHospital^^N^^^|1122334^Alaz^Mohammed^Mahi^JR^Dr.^MD^^PERSONNELt&1.23&HCD^B^^^BR^^^^^^19241010^19241015^Al|C006^Woolfson^Kathleen^^^Dr^^^TEST&23.2&HCD^MSK^^^BA|C008^Condoc^leen^^^Dr^^^&1.3.6.1.4.1.44750.1.2.2&ISO^NAV^^^BR|SUR|Internal Medicine^^^UH Hospitals^^D^Briones Bone^3b^||R|NHS Provider-General (inc.A\T\E-this Hosp)||VIP^Very Important Person^L^IMP^^DCM^v1.1^v1.2^Inportant Person|37^DISNEY^WALT^^^^^^AccMgr^^^^ANC|Inpatient|40007716^^^AccMng&1.2&HCD^AM|||||||||||||||||Admitted as Inpatient^Sample^ACR|22&Homes&FDK|Vegan^Vegetarian|HOMERTON UNIVER||Active|POC^Room-2^Bed-103^^^C^Greenland|Nursing home^^^^^^Rosewood|20150208113419+0110||||||50^^^T123&1.3.6.1.4.1.44750.1.2.2&ISO^MR||Othhel^^^^^^^^testing&&HCD||EOC124^5^M11^Etest&2.16.1&HCD^MR^CommunityHospital
PV2|^ROOM1&2.16.840.1.113883.4.642.1.1108&ISO^BED1^FACILITY1^^^BUILDING1^FLOOR1^^^||140004^Chronic pharyngitis^SCT||||||||2|Health Checkup|12188^Hippocrates^Harold^H^IV^Dr^MD^^TE&Provider Master.Community Health and Hospitals&DNS^^^M10^DN^^|||||||||N|||2^^^3^^^V1.2^V1.3|||||||||||||C
ARV|1|X|LOC|PHY|No disclosure of patient location|20211118103000+0215^20221118103000+0215
ROL|1|AD|PP^Primary Care Provider^HL70443|12377H87^Smith^John^A^III^DR^PHD^^PERSONNELt&1.23&HCD^B^^^BR^^^^^^19241010^19241015^Al|20220101000000|20220202000000|||408443003^General practice^SNOMED|2^Physician Clinic^HL70406|1234 Magnolia Lane, Ste. 231^^Houston^TX^33612^USA|^^Internet^fred@nnnn.com^111^813^8853999^1234|HUH AE OMU&9.8&ISO^OMU B^Bed 03^HOMERTON UNIVER^^C^Homerton UH^Floor5|Good Health Hospital^L^^^^CMS^XX^^A|
DB1|1|PT|DB123^4^M11^t&1.3.6.1.4.1.44750.1.2.2&ISO^MR^UH^19241011^19241012|Y|20210830|20210930|
OBX|27|NM|8867-4^heartrate^LN||60~120|beats/min^^ISO|70-80|A^A^HL7nnnn~B^B|||S|||19990702|Org15^ID of producer^CAS|1134^Aly^Zafar^Mahendra^JR^Dr.^MD^^PERSt&1.23&HCD^B^^^BR^^^^^^19241010^19241015^Al~2234^Pauly^Berrie^Raud|OBS^This is test method^AS4|EI12.3^NI2^426d2726-51fc-89fe-a946-8596e80a80eb^GUID~^^1.3.6.1.4.1.44750.1.2.2^ISO|19990702|BU^Observation site^E5|EI21^OII||FairOaks Hspital|Research Park^Fairfax^VA^22031^USA|MD-25^Atchinson^Christopher^^MD|||||||PAI-1^FAI-1
AL1|1|EA|P^PENICILLIN^ICDO|MI|CODE16|20210824
DG1|1|I9|422504002^Ischemic stroke(disorder)^SCT|Stroke|20040125114025+0420|A|||||||||1|005454^DIAG^ROBIN^B|||20200501133015+0215|DI20^Diagnosis^1.3.6.1.4.1.44750.1.2.2^CLIP|A|^^1.3.6.1.4.1.44750.1.2.2^CLIP
PR1|1||76164006^Biopsy of colon (procedure)^SCT|Biopsy of colon, which was part of colonoscopy|200501251140+0100|D^Diagnostic Procedure^HL70230|2|1210^ANES^MARK^B|||121188^Patrick^Harold^H^IV^Dr^MD^^&Provider Master.Community Health and Hospitals&L^L^9^M10^DN^&Good Health Hospital.Community Health and Hospitals&L^A|12345689^Everyman2^Adam2^A^III^DR^PHD^ADT01^^L^4^M11^MR|||799008^Sigmoid colon ulcer^SCT||||PR1006||||OT^201||PR1001
ROL|1|AD|PP^Primary Care Provider^HL70443|121^Phoeb^Harold^H|20220101000000|20220202000000|||408443003^General practice^SNOMED|2^Physician Clinic^HL70406||^^Internet^Pheob@nnnn.com^|InternalMedicine^^^UniversityHospitals^^C^Briones^3^|L Multispeciality Hospital^L^^^^CMS^XX^^A|
GT1|1|1516^4^M11^test^MR^Unity Hospital^19241011^19241012|RADIANT^LUCY^^|Rebecca^Jonas|1619 SOUTH UNIVERSITY^^MADISON^WI^53703^US|6082517777^^Internet^8484~717171^^PH|021212^^MD|20010412|M|P/F|SEL|G-SSN-12|20010410|20010415|2|EHS GENERIC EMPLOYER|1979 MILKY WAY^^VERONA^WI^53593^US|082719000^^PH|55121^^^^FI|3||N|SLF|20080825111630+0115|Y||||1231^^^^BC|M|20091010|20101010||||ger||||||MothersMaiden|BT^Bhutan^ISO3166_1||Ben^Charles~Ben2|000352^^CP~00121^^FX|Urgent requirement||||GEOrg|||||Germany
IN1|1|BAV^Blue Advantage HMO|IC-1.31^24^BCV^&2.16.840.1.113883.1.1&ISO^NIIP^^19291011^19291012|Blue Cross Blue Shield of Texas|1979 MILKY WAY^^VERONA^WI^53593^US|Henry&&&&Roth^Rony^A^III^Dr.^MD^D^^^19251012|(555)555-5555^BPN^PH|PUBSUMB|SelfPay||Sam P. Hil|19891001|20501001||HMO^health maintenance organization policy|Doe^Rosallie^John^III^Mrs.^Bachelors^R|SPO^Spouse|19750228|3857 Velvet Treasure Terrace^^Midnight^NC^27878^US|||||||||||||||||PN-145|150&USD^DC||||||F^Female|2000 MILKY WAY^^VERONA^WI^53593^US|||B||HMO-12345^^^&2.16.840.1.113883.1.3&ISO^NI
IN2|1117^4^M11^&2.16.840.1.113883.1.4&ISO^EI^University Hospital~1118^^^^BC|425-57-9745|||I^Insurance company|Medicare-12345|Jack&&&&Aniston^ADAM^A^III^Dr.^MD^D^^^19241012^^^^PF^Addsm|MCN-008||MI-12345||||||||||||||||||||||||eng^English|||||||||||||||Richard^Paul|254622222^^PH|||||||||||PNM1234^4^M11^PM&2.6.1&HCD^MR^University Hospital^19241011^19241012||0005245^WPN^Internet~^^CP|555777888^^FX~^^PH||||||Max Life Insurance||02^Spouse
RF1|P^Pending^HL7283|A^ASAP^HL7280|EXTERNAL|||123-1^name|||19900501120100+0515|R-1^Reason^C4|123-2^Testname|||Patient has a spinal fracture|||||AuthProvider^L^4.4^3^M10^CMS^LR^^^A|114^Beverly^Crusher^An^Mr^Dr.^AHP^^2.3^B^^^BR^^^^^^19241010^19241015^Al||||Check for metastatic disease|U
ACC|20140317||Route 50 intersection||Y|N|10535^Goldbergn&van^Ludwig^A^III^Dr^PHD^^&MPI.Community Health and Hospitals&L^L^3^M10^MR^& Good Health Hospital.Community Health and Hospitals&L^A|vehicle acident||Y|Route 50&Fairfax^VA^^^20324||5348
PDA|I21^Acute myocardial infarction^I10|ICCU^Room1^Bed25^GHH|Y|20211102123000+0115|005454^DeathCert^Robin^B|Y|20211102103000+0115^20211102113000+0115|002324^Autopsy^John^K|N
MSH|^~\&|Ntierprise|Ntierprise Clinic|Healthmatics EHR|Healthmatics Clinic|20190423150137+0215||ADT^A40^ADT_A40|8919-40|P|2.8|||NE|NE
EVN|A40|20190423150137+0215||01|13^Berry
PID|1||12345^^^BCBS^MR||Test^Test^A||20180205|F|||123 Any Street^^Raleigh^NC^27615||(111)111-1111^^PH^^^111^1111111|||||5027440^^^^AN
MRG|56789^^^BCBS^MR
MSH|^~\&|AccMgr|1|||20050110045504+0700||ADT^A01|599102|P|2.3|||
EVN|A01|20050110045502+0700|||||
PID|1||10006579^^^1^MR^1||DUCK^DONALD^D||19241010|M||1|111 DUCK ST^^FOWL^CA^999990000^^M|1|8885551212|8885551212|1|2||40007716^^^AccMgr^VN^1|123121234|||||||||||NO
NK1|1|DUCK^HUEY|SO|3583 DUCK RD^^FOWL^CA^999990000|8885552222||Y||||||||||||||
PV1|1|I|PREOP^101^1^1^^^S|3|||37^DISNEY^WALT^^^^^^AccMgr^^^^CI|||01||||1|||37^DISNEY^WALT^^^^^^AccMgr^^^^CI|2|40007716^^^AccMgr^VN|4|||||||||||||||||||1||G|||20050110045502+0700||||||
GT1|1|8291|DUCK^DONALD^D||111^DUCK ST^^FOWL^CA^999990000|8885551212||19241010|M||1|123121234||||#Cartoon Ducks Inc|111^DUCK ST^^FOWL^CA^999990000|8885551212||PT|
DG1|1|I9|71596^OSTEOARTHROS NOS-L/LEG ^I9|OSTEOARTHROS NOS-L/LEG ||A|
IN1|1|MEDICARE|3|MEDICARE|||||||Cartoon Ducks Inc|19891001|||4|DUCK^DONALD^D|1|19241010|111^DUCK ST^^FOWL^CA^999990000|||||||||||||||||123121234A||||||PT|M|111 DUCK ST^^FOWL^CA^999990000|||||8291
IN2|1||123121234|Cartoon Ducks Inc|||123121234A|||||||||||||||||||||||||||||||||||||||||||||||||||||||||8885551212
IN1|2|NON-PRIMARY|9|MEDICAL MUTUAL CALIF.|PO BOX 94776^^HOLLYWOOD^CA^441414776||8003621279|PUBSUMB|||Cartoon Ducks Inc||||7|DUCK^DONALD^D|1|19241010|111 DUCK ST^^FOWL^CA^999990000|||||||||||||||||056269770||||||PT|M|111^DUCK ST^^FOWL^CA^999990000|||||8291
IN2|2||123121234|Cartoon Ducks Inc||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||8885551212
IN1|3|SELF PAY|1|SELF PAY|||||||||||5||1
MSH|^~\&|REDOX|RDX|||20190504181205+0700||ADT^A04|1270326314|T|2.3|||||||||
PID|||MRN12345^5^M11^^MR^Special Hospital||Doe^Jane||19780101|F||2106-3||||||||123456789
NK1|1|JOHNSON^CONWAY^^^^^L|SPOUS||(130) 724-0433^PRN^PH^^^431^2780404~(330) 274-8214^ORN^PH^^^330^2748214||EMERGENCY
PV1||E|||||12345^Johnson^Peter|||||||||||||||||||||||||||||||||||||20190504181205+0700
MSH|^~\&|REDOX|RDX|||20190504181205+0700||ADT^A04|1270326314|T|2.3|||||||||
EVN|A04|20181017025543+0700|||||
PID|||0000000001^^^MR~e167267c-16c9-4fe3-96ae-9cff5703e90a^^^EHRID~a1d4ee8aba494ca^^^NIST||Bixby^Timothy^Paul||20080106|M|||4762 Hickory Street^^Monroe^WI^53566^US|Green|8088675301^^^|||Married||1234|101-01-0001||||||||||||||||||||
PD1||||4356789876^Granite^Pat^^^^MD^^NPI|||||||||||||||||
NK1||Bixby^Barbara^|Mother|4762 Hickory Street^^Monroe^WI^53566^US^^^Green|+19189368865||Emergency Contact||||||||||||||||||||||||||||||||
PV1||I|3N^136^B^RES General Hospital^^Inpatient||||4356789876^Granite^Pat^^^^^^NPI|^^^^^^^^|||||||||||1234|||||||||||||||||||||||||20181017222805+0700||||||||
GT1|1||Bixby^Kent|Bixby^Barbara|4762 Hickory Street^^Monroe^WI^53566^USA^^^Green||||||Father|||||Accelerator Labs|1456 Old Sauk Road^^Madison^WI^53719^USA^^^Dane|8083451121|||||||||||||||||||||||||||||||||||||||
IN1||31572^HMO Deductable Plan^Payor ID|60054^^^^|aetna (60054 0131)|PO Box 14080^^Lexington^KY^40512-4079^US^^^Fayette||8089541123|847025-024-0009|Accelerator Labs|||20150101|20201231|||^|||^^^^^^^^|||||||||||||||||9140860055|||||||||||||||||
Full-scale & binary files (run it on the complete dataset): fetch-full.sh · full.json.