Raw sources

Raw sources (bronze)

Rows from every feed, stored exactly as received. Normalisation happens in the silver layer, where each change is flagged.

ENREnrollment
43,101
raw rows
Usable
42,871
Flagged
84%
No member ID
2%
Linked
29,405
First seen
2026-01-01
Last seen
2026-10-18
CLMClaims
32,829
raw rows
Usable
32,674
Flagged
74%
No member ID
35%
Linked
30,209
First seen
2026-01-01
Last seen
2026-10-18
TPAThird-party administrator
14,474
raw rows
Usable
14,404
Flagged
77%
No member ID
85%
Linked
11,671
First seen
2026-01-01
Last seen
2026-10-18
PRVProvider network
9,596
raw rows
Usable
9,546
Flagged
80%
No member ID
50%
Linked
8,676
First seen
2026-01-01
Last seen
2026-10-18

Raw events

Enrollment only, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
ENRENR-1289042026-09-20T10:25:19Zlarry—vazquez1959-03-18·UHC-08267-68•••-••-8450852.338.1378larry.vazquez@aol.com4752 MOUNTAIN VIEW DRMiamiFL33143-1181GRP-7791··MEDICARE-ADV-A
ENRENR-1301852026-05-23T08:53:05ZDoris—Dunn25-06-1967UHC-78929-81··•••-••-88117619890058doris.dunn38@icloud.com5802 Lake View RdSeattleWA···98151GRP-1560NAVIGATE-HMO
ENRENR-1280192026-05-05T03:15:56ZCarl—·Franklin10/1/1965·UHC-42872-40•••-••-1538nullcarl.franklin@icloud.com9562 Washington StSacramentoCA95878GRP-1982CORE-HMO
ENRENR-1429342026-08-19T05:55:22Z·RACHEL·IADAMSMar 26, 1939UHC-34375-78null670.587.9506N/A5892 Oak StTucsonAZ85724GRP-3883SELECT-EPO
ENRENR-1389102026-06-07T04:39:00ZCAMILA··—GREEN12-09-2001UHC-47377-74•••-••-79846993956622—2252 Oak StLas VegasNV89170GRP-2582options-ppo··
ENRENR-1199892026-02-13T04:32:02ZJessicaP.··Green1964-04-06UHC-03645-54N/A(523) 504-5944jessica.green@proton.me3674 Washington StTempeAZnullGRP-7125SELECT-EPO
ENRENR-1289052026-08-04T00:02:26ZSharonVVega1970-01-16·UHC5169903null666-585-9164NULL7508 Church StreetChandlerAZ85271GRP-7509OPTIONS-PPO
ENRENR-1069002026-02-05T16:49:52ZArmstrong, AnnaU—1979-03-02UHC-18999-92•••-••-0678391-812-7209—6965 DESERT SKY BLVDLas VegasNV89124GRP-7935MEDICARE-ADV-B
ENRENR-1124222026-09-11T16:36:10ZCastro—Cynthia1981-10-06UHC-71182-79•••-••-3059nullnull1248 Sunset Boulevard·SeattleWA—GRP-7224OPTIONS-PPO
ENRENR-1068062026-05-05T06:21:00Zjoe·Xcook··Jun 26, 1938UHC-94709-46•••-••-11862326445840joe.cook@hotmail.com8840 Elm StDALLASTX·75206GRP-9645MEDICARE-ADV-A
ENRENR-1292912026-02-09T16:36:54ZPamelaH.Reyes1992-12-03UHC-99188-54•••-••-6443UNKNOWNNULL4311 OAK STEden PrairieMN···55329GRP-8922OPTIONS-PPO
ENRENR-1084612026-05-22T10:21:45ZFRACESPYANG1938-08-16UHC-31346-26•••-••-62267009794856frances.yang23@aol.com88 Church StAustinTX78729GRP-2382medicare-adv-b
ENRENR-1325402026-01-25T01:45:05ZscottDlee1998-05-15UHC-74686-52•••-••-9291NULLUNKNOWN—null-—GRP-8467OPTIONS-PPO
ENRENR-1117772026-06-17T02:17:48ZPeterAHart1968-07-14UHC-61611-95•••-••-1070635-490-2797peter.hart92@gmail.com7329 River RdCHANDLERAZ85233GRP-4652MEDICARE-ADV-A
ENRENR-1276352026-03-23T23:00:31ZLucia—Meyer1997-11-15···UHC-64182-55•••-••-8809(290) 295-8434LUCIA.MEYER5@YAHOO.COM9012 Lake View RoadORLANDOFL32853GRP-1461MEDICARE-ADV-B
ENRENR-1012142026-06-13T05:46:12ZHamilton, SophiaC.—09-04-1950UHC-89129-63•••-••-9669357-320-3423sophia.hamilton90@gmail.com2596 Elm StMiamiFlorida33181GRP-2965OPTIONS-PPO
ENRENR-1333952026-06-10T17:18:00ZScott—Estrada1963-11-20UHC-21355-47null236-840-3536scott.estrada78@gmail.com2065 BAYSHORE DRIVE #739AustinTX78770GRP-2676SELECT-EPO
ENRENR-1409302026-01-31T13:10:03ZElizabethDMyers1981-12-18UHC-25672-92•••-••-7692366-364-2933ELIZABETH.MYERS98@OUTLOOK.COM9332 RIDGE RDDallasTexas75292-9866GRP-2558·select-epo
ENRENR-1220142026-02-02T19:22:08Zaisha·Pbiley·1993-03-09UHC3293020•••-••-4405(672) 396-9448AISHA.BAILEY87@PROTON.ME3532 Highland AvenueAustinTX-GRP-5125MEDICARE-ADV-A
ENRENR-1127602026-08-28T06:40:31ZGARY—STEWART·1979-12-12UHC-82371-38•••-••-88863799574039gary.stewart@gmail.com2034 Valley View Dr···TempeAZ85273-6206GRP-3350medicare-adv-b
ENRENR-1339702026-05-13T01:48:32ZIsabellaR.Ferguson···1995-12-16UHC-91349-72•••-••-3487258.752.9830isabella.ferguson@outlook.com9627 Ocean AvenuePHOENIXAZUNKNOWNGRP-7664CORE-HMO
ENRENR-1414392026-06-16T06:46:04Z DOROTHYIEDWARDSMay 18, 1947UHC-40811-85··•••-••-0560798-480-2331N/A··7794 Oak StSACRAMENTOca95820GRP-4002MEDICARE-ADV-A
ENRENR-1001312026-05-17T23:28:37ZDIANAYRAMOS1979-07-02UHC-92145-59•••-••-76406418418084diana.ramos@gmail.com4025 Elm St Apt 27PlanoTX75050GRP-0874OPTIONS-PPO
ENRENR-1066322026-04-25T00:14:21ZSAMANTHA—MARTINEZ1975-02-15UHC-54468-81•••-••-399217356043698SAMANTHA.MARTINEZ31@ICLOUD.COM6588 Lincoln WayHoustonTX77071··GRP-4333MEDICARE-ADV-A
ENRENR-1227932026-06-02T12:32:59ZmatthewL·robertson1963-04-10UHC-82324-38•••-••-73766315529826MATTHEW.ROBERTSON49@AOL.COM-—null-GRP-3636MEDICARE-ADV-A
ENRENR-1167942026-05-19T13:37:54ZBRADLEYW.BRADLEY·04/08/55UHC-50612-81•••-••-4029781-547-9164—4906 Lake View RdLos AngelesCA90017GRP-6563CHOICE-PLUS-PPO
ENRENR-1075882026-10-02T22:30:18ZKelly··Wong2007-06-01UHC-18814-73•••-••-10115664562492NULL7943 Pine DriveDallasTX—GRP-0328MEDICARE-ADV-B
ENRENR-1179612026-07-14T10:48:55ZJEFFREYCTURNER1954-01-08UHC-25947-09•••-••-6993(819) 621-7032jeffrey.turner@aol.com··5198 Sage CourtFRESNO··ca93751GRP-2923SELECT-EPO
ENRENR-1087002026-09-29T05:16:04ZronaldCcollins1949-05-08UHC-97895-99•••-••-05578446571260NULL·4782 Mountain View DrLos AngelesCA90002-6426GRP-4874··CORE-HMO
ENRENR-141075 2026-07-30T21:03:46ZMATTHEW—BELL·2001-04-16UHC-24569-46•••-••-2166(626) 470-4299—903 Jefferson AveScottsdaleaz85281GRP-9995CORE-HMO
ENR ENR-1093742026-09-06T22:29:14ZLaurenSHanon·19950904UHC-31961-07•••-••-0008+1 439 283 5292lauren.hanson70@gmail.com7391 Hillcrest Road #230San DiegoCA92148··GRP-0615SELECT-EPO
ENRENR-1008322026-05-04T05:31:19Z DennisMMcDonald1988-09-20UHC-13945-40•••-••-8679365-478-2097dennis.mcdonald73@hotmail.com406 Maple AveAustinTX78741·GRP-7521MEDICARE-ADV-A
ENRENR-1280632026-08-06T01:38:23Z·EMILY—BAKER··1967-12-01UHC-95533-24•••-••-0627(354) 664-9408—425 JEFFERSON AVELos Angeles·California—GRP-6386MEDICARE-ADV-A
ENRENR-1055212026-06-14T00:40:09ZMarcus—Little3/28/2001·UHC-92454-63•••-••-8454872-584-1589marcus.little9@gmail.com9687 RIDGE RD·GILBERTAZ85266GRP-7018MEDICARE-ADV-A
ENR ENR-1303312026-09-09T19:19:40ZWong, FrancesA—1997-11-20UHC-71214-60•••-••-1182717-892-1720FRANCES.WONG@GMAIL.COM6245 BroadwayDenver·Colorado80235GRP-9107MEDICARE-ADV-B
ENRENR-1154342026-04-30T03:36:51Z walterAmoreno1976-09-10UHC-70397-76•••-••-91377976920166null6699 Pine DrTempeAZ85286GRP-2293··MEDICARE-ADV-B
ENRENR-1024252026-02-01T21:36:34ZMikeFHarrison1939-02-25UHC-19556-29•••-••-927012267729842MICHAEL.HARRISON14@HOTMAIL.COM935 MAIN ST #964Los AngelesCaliforniaNULLGRP-3233NAVIGATE-HMO
ENRENR-1144452026-07-26T19:50:53ZLuciaRHowell1985-04-07UHC-54508-07•••-••-521312567041228lucia.howell@hotmail.com8793 Highland AveNashvilleTN37294GRP-0169navigate-hmo
ENR ENR-1290312026-02-02T05:48:28ZJason—Delgado1962-06-27UHC-84566-36•••-••-7525—-··3726 GRAND AVETEMPEAZ85233GRP-8473CHOICE-PLUS-PPO
ENRENR-1242132026-03-12T19:06:14ZOmar··Park11/13/1975UHC-01183-85•••-••-8522(482) 804-5607OMAR.PARK54@AOL.COM4331 PALM DRGILBERTArizona·85291GRP-8776CORE-HMO
ENRENR-1350932026-01-26T13:12:59ZKimberly—Stewart··11/18/1998UHC-36132-22•••-••-9322(501) 716-2596kimberly.stewart@gmail.com7738 HARBOR BLVD·DenverCO80243-0465GRP-2761MEDICARE-ADV-B
ENRENR-1008472026-08-02T15:56:05ZSarahD.Howell05/27/66·UHC-08662-71—(237) 355-0725sarah.howell@outlook.com320 Main StreetAustinTX78751-2641·GRP-4557CHOICE-PLUS-PPO
ENRENR-1395812026-06-02T16:13:58ZCHERYLM·TURNER1989-12-14UHC-25286-75•••-••-8147778-466-3036cheryl.turner34@gmail.com150 HARBOR BOULEVARDMinneapolisMN55480GRP-0177SELECT-EPO
ENRENR-1340262026-06-19T09:04:03ZKevin··Knight1/22/1953UHC-45883-68—(889) 979-6016kevin.knight@icloud.com·7111 RIDGE ROADMinneapolisMN55444GRP-4943OPTIONS-PPO
ENRENR-1375172026-05-07T07:04:03ZPrice—David·1938-01-09UHC-55216-20··•••-••-9596(652) 443-4175david.price@icloud.com7458 Bayshore DrColumbusoh43245GRP-1802MEDICARE-ADV-B
ENRENR-1013362026-09-18T06:06:23ZJuanRRodriguez1947-10-09UHC-40583-75•••-••-4008+1 524 224 1743null··7598 Main StColumbusOH43246GRP-6322CHOICE-PLUS-PPO
ENRENR-1027762026-06-12T16:56:57ZAshleySTrner·20-08-1982UHC-15343-73—5857597815ASHLEY.TURNER44@AOL.COM7867 Elm StreetAtlantaGA30390··GRP-9517MEDICARE-ADV-B
ENRENR-1429902026-10-18T17:14:33ZAnaYGutierrez1972-09-20UHC-10479-88—·(342) 941-1580·ana.gutierrez62@icloud.com384 Forest AveAustinTX··78734GRP-7360OPTIONS-PPO
ENRENR-1147422026-03-31T08:07:56ZMichael··McCoy2007-10-14UHC-72849-01•••-••-76845916400898—5136 Ocean AveTAMPAfl33636GRP-3232SELECT-EPO
ENRENR-1253512026-05-31T17:49:18ZroyX.lane12/16/1945UHC-22630-82•••-••-3604(706) 402-2819roy.lane3@hotmail.com9186 Ridge RdChandlerAZ85283GRP-1705MEDICARE-ADV-B
43,101 rows, page 230 of 863PreviousNext

Bronze layer rules

What is guaranteed for downstream layers

  • As received
    Values are stored exactly as the feed delivered them, including whitespace, inconsistent casing and placeholder tokens such as NULL or N/A.
  • No transformation
    Bronze is never edited in place. Every fix lives in silver and is traceable back here by record ID.
  • Line number preserved
    The line number records each row's position in the source file, so a value can be located in the original extract.
  • Load timestamp
    The load timestamp marks when the row landed in the lakehouse; this batch landed 2026-10-22T12:42:40.610Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty