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-1320772026-05-15T01:38:21ZBrdleyQBarnes1986-01-18UHC-02728-80•••-••-5499630-550-0274null·1932 Spring StreetGLENDALEAZ85338GRP-7501MEDICARE-ADV-B
ENRENR-1291232026-01-03T08:43:16ZVINCENT—MORGAN1986-08-06UHC-89453-55•••-••-4167·601-975-9013VINCENT.MORGAN54@PROTON.ME6852 Union StPhoenixAZ85097GRP-1015SELECT-EPO
ENRENR-1260732026-07-24T00:17:06Z PATRICIAA··FOX1959-03-21UHC-32104-52•••-••-3324658-947-5791··—2227 MOUNTAIN VIEW DRPhoenixAZ85020GRP-2415NAVIGATE-HMO
ENRENR-1230342026-01-09T06:45:13ZAlice··WBryant1967-08-03uhc-87888-26-(311) 658-0398alice.bryant@icloud.com7231 PALM DRIVEChandlerArizona85265GRP-8488SELECT-EPO
ENRENR-1303842026-07-31T23:43:12ZMarkD.—1950-01-25UHC-83933-09•••-••-9231·7448255384·-4811 Pine DrSEATTLEwa98125GRP-1479CORE-HMO
ENRENR-1037282026-01-24T08:34:13ZMARKVCOLE1958-09-01UHC-08276-88•••-••-51769015803221MARK.COLE34@ICLOUD.COM··9515 Sunset BoulevardNashvilleTN37286GRP-0157·MEDICARE-ADV-A
ENRENR-1243932026-03-28T02:13:18Z·MichelleNCarroll1980-12-26UHC-10245-69··•••-••-4435(885) 281-9163MICHELLE.CARROLL@GMAIL.COM4702 PARK PLLas VegasNV89136GRP-0377·core-hmo
ENRENR-1342872026-03-04T09:47:44ZJoe—Mills1948-12-08UHC-55414-21•••-••-7739845-708-7300JOE.MILLS@PROTON.ME2003 MOUNTAIN VIEW DRMIAMIFL33167GRP-8200·OPTIONS-PPO
ENRENR-1259902026-02-18T04:20:04Z·Evelyn——1943-05-11UHC-35484-18•••-••-7065548-369-1340evelyn.cook@aol.com4609 Desert Sky BoulevardTempeAZ85213-7601GRP-4840OPTIONS-PPO
ENRENR-1134552026-04-26T14:58:38ZLORI—COOOPER05-12-1954··uhc-56472-37•••-••-1474(572) 719-8019LORI.COOPER79@ICLOUD.COM7740 WASHINGTON STREETLas VegasNV89191GRP-6502MEDICARE-ADV-A
ENRENR-1291312026-07-10T13:59:35ZLaren—PayneApr 13, 1946UHC-12594-86—·(326) 204-5091N/A6651 PALM DRIVEPlanoTX75068GRP-4270OPTIONS-PPO
ENRENR-1257712026-01-28T19:49:13ZbarbaraDdiaz·1987-09-17UHC-71696-40•••-••-9168(232) 988-1159barbara.diaz44@aol.com158 Maple Ave··AtlantaGeorgia30328GRP-6033CORE-HMO
ENRENR-1336302026-02-13T12:39:44ZElizabethQ.Soto·2003-08-26UHC-13349-43•••-••-8531·343-385-8673NULL2261 Bayshore Drive #611AtlantaGA30303GRP-2230CORE-HMO
ENRENR-1277452026-06-23T05:55:07ZDoris·MBell09-03-1957UHC-49343-44-(627) 766-0285··N/A3718 FOREST AVENUE··NashvilleTN37265-1835·GRP-4730MEDICARE-ADV-A
ENR ENR-1404302026-08-03T06:20:19ZPriya—Garrett1980-10-02UHC-98075-44•••-••-6646(640) 715-8951UNKNOWN7608 Bayshore DrNashvilletn37292GRP-1258NAVIGATE-HMO
ENRENR-102815 2026-03-13T15:08:19ZturnerYbradley1966-11-05uhc-15560-80•••-••-9518(700) 414-3120bradley.turner@aol.com7038 BASELINE ROADFresnoCA93721GRP-6664CORE-HMO
ENRENR-1002172026-01-07T11:33:07ZKATHERINELJAMES19790809UHC-89876-40•••-••-2614(855) 558-0302katherine.james88@gmail.com8854 Highland AvenueTempeAZ85251GRP-4912MEDICARE-ADV-A
ENRENR-1048202026-04-11T01:50:20Zana—stewart1954-07-21UHC-76709-04•••-••-7943·(620) 402-4044ANA.STEWART@PROTON.ME2654 Sunset BoulevardFresnoca93776-8320GRP-5732SELECT-EPO
ENRENR-1018962026-07-01T09:48:21ZGerald—Andrews1957-01-24UHC-92735-21•••-••-1811·5137568274GERALD.ANDREWS4@ICLOUD.COM7825 Meadow LnATLANTAGA30381GRP-1723MEDICARE-ADV-B
ENRENR-1347152026-03-13T04:32:00ZBOBBY·NDEAN1941-05-26UHC-81117-27•••-••-3823408-333-0786UNKNOWN717 VALLEY VIEW DRIVEJACKSONVILLEFLnullGRP-4668MEDICARE-ADV-A
ENRENR-1233552026-02-21T10:47:54ZAnn—Wagner06/10/2001UHC-43019-25—(579) 938-5292ANN.WAGNER18@PROTON.ME8597 Desert Sky BlvdCharlotteNC28238GRP-1517MEDICARE-ADV-B
ENRENR-1152532026-07-14T19:33:52ZBenjamin—Tran06/02/06UHC-32488-09•••-••-281815707060276benjamin.tran@gmail.com·3043 CHURCH STGlendaleAZ85305GRP-8151OPTIONS-PPO
ENRENR-1198032026-07-21T05:37:04ZAliceKAllen1960-12-27UHC-55870-06•••-••-0117320-339-6157—5936 Elm StreetSan Diego··CA92116·GRP-7497·core-hmo
ENRENR-1147752026-05-12T00:22:57Z LuciaG.Delgado10/28/1939UHC-51359-63—679.851.7787UNKNOWNN/ANULLnullUNKNOWN·GRP-6135SELECT-EPO
ENRENR-1326162026-06-29T09:10:48ZRay—Madison03/18/1985UHC-05187-11•••-••-6365624-600-7806madison.ray@outlook.com···2930 Sage CtMIAMIFL33144GRP-6792NAVIGATE-HMO
ENRENR-1336122026-05-02T20:52:53ZCYNTHIA—PORTER1983-10-11UHC-55361-65•••-••-64879709102·cynthia.porter26@outlook.com——null—GRP-7136CHOICE-PLUS-PPO··
ENRENR-1187312026-03-05T00:13:00ZRyanQDuncan5/26/1971uhc-35024-48•••-••-87744465996390ryan.duncan@gmail.com6813 SPRING STScottsdaleArizona85230GRP-3586SELECT-EPO
ENRENR-1294352026-06-15T13:03:08ZJULIAHCARTER1993-12-09UHC-90536-94•••-••-0316931-767-1667julia.carter15@proton.me7784 Apache BlvdColumbusOH43266GRP-8066CORE-HMO
ENRENR-1332642026-07-19T17:44:25ZAlexanderWGuerrero··Nov 25, 1960·UHC-55391-43•••-••-9715638-569-9871NULL4649 Harbor BoulevardTempeArizona85250GRP-4324CORE-HMO
ENRENR-1295592026-01-03T02:22:07ZKeith—Foster··1973-10-10UHC-88227-23•••-••-1284846-697-1232keith.foster37@hotmail.com3575 OAK STREETPhoenixAZ85043GRP-3388CHOICE-PLUS-PPO
ENRENR-1207042026-09-12T04:32:23ZBenjamin··ZHarper07/26/65UHC-31896-42N/A8666322benjamin.harper16@outlook.com493 Spring StreetMesaaz85224GRP-3265OPTIONS-PPO
ENRENR-1342582026-05-08T11:05:47ZAlexanderSDaniels1957-08-17UHC-31734-73•••-••-3869445.286.5627alexander.daniels@gmail.com7936 Central AveFresno·CA93703GRP-2791select-epo
ENR ENR-1195922026-07-03T00:20:39Z·jeanIwang1960-03-11UHC-24681-22•••-••-9859N/A··jean.wang@aol.com501 CHURCH STREETSAN ANTONIOTX78236GRP-2044MEDICARE-ADV-A
ENRENR-1429852026-01-16T08:36:36ZStephanieIWest1945-04-15UHC9435543•••-••-921612308489536NULL9640 UNION STREET··FresnoCA93733GRP-0680CORE-HMO
ENRENR-1012212026-04-12T03:29:12ZKayla—Harris1946-08-10UHC-45039-62•••-••-1943-··kayla.harris22@outlook.com1704 ELM STSeattleWA····GRP-8535MEDICARE-ADV-A
ENRENR-1359242026-09-22T14:40:04ZNicholasBPark11/01/63UHC-31302-45•••-••-45314787258907··nicholas.park65@proton.me6548 JEFFERSON AVELos AngelesCalifornia90047·GRP-9971OPTIONS-PPO
ENRENR-1219892026-10-11T12:32:02ZTerry—Bell1994-02-26UHC-55981-77•••-••-7760null—4754 Bayshore DrCOLUMBUSOhio43292GRP-2158SELECT-EPO
ENRENR-1290282026-08-20T22:49:06ZJack—Little1989-06-17UHC-33298-06•••-••-890116295780607JACK.LITTLE@AOL.COM7673 PINE DRIVELAS VEGASNV89187GRP-1604CHOICE-PLUS-PPO
ENRENR-1219642026-07-20T13:21:51ZKaylaH··Riley··2003-07-20UHC-81765-33•••-••-39344152342567kayla.riley20@aol.com4542 Lake View RdLas VegasNV89174GRP-0310MEDICARE-ADV-B
ENRENR-115927 2026-09-22T19:03:14ZHanson, HiroshiX—Dec 11, 1939UHC-76924-24•••-••-0527·9484755377HIROSHI.HANSON@ICLOUD.COM6791 Baseline RoadMinneapolisMN55425GRP-7821CORE-HMO
ENRENR-1042712026-05-11T03:26:12Zaustin·Kbanks1963-04-27UHC-18415-36··•••-••-763917513238935austin.banks@icloud.com1022 Baseline RdSan AntonioTX78250GRP-7665NAVIGATE-HMO
ENRENR-1410222026-03-15T09:36:08ZJerryJ.··Maldonaod02/05/1953··UHC-13952-08•••-••-61536558147264·jerry.maldonado52@gmail.com9164 Main StreetTempeAZ—GRP-2427CORE-HMO
ENRENR-1145472026-03-01T21:15:40ZPorter, AdamO.—2006-08-19UHC-24049-89··•••-••-68902663270226adam.porter31@outlook.com9854 Forest Ave··San AntonioTX78230GRP-0657SELECT-EPO
ENR ENR-1106522026-01-26T08:50:21ZDylan—NelsonNov 17, 1994UHC-87086-65•••-••-0283·678.716.4709dylan.nelson@gmail.com3475 HILLCREST ROAD··DenverCO80275GRP-7070NAVIGATE-HMO
ENR ENR-1421462026-07-21T16:51:47ZMargaretM.Stone12/20/39uhc-82602-39•••-••-7490(974) 929-3907··N/A854 RIVER RDPhoenixAZ85041GRP-0424CHOICE-PLUS-PPO
ENRENR-1039572026-06-03T14:19:13ZArjun—Boyd1949-07-26UHC-36009-49•••-••-2334+1 255 810 6436ARJUN.BOYD@HOTMAIL.COM4009 Pine DriveEden PrairieMN55383GRP-2626SELECT-EPO
ENRENR-1244702026-07-13T16:21:02ZHarold H.—Martinez19940103UHC-94658-96•••-••-35676657099300harold.martinez99@yahoo.com2922 Forest AvenuePhoenixaz85029GRP-4136SELECT-EPO
ENRENR-1109382026-01-12T15:07:38ZPaul··Cook···2002-01-25NULL•••-••-22789807039594paul.cook@proton.me5048 Park PlaceJacksonvilleFL32275··GRP-2703MEDICARE-ADV-A
ENRENR-1413282026-08-09T03:08:33Z·Megan—Graham19820309UHC-05022-48•••-••-6393·4328652758MEGAN.GRAHAM@GMAIL.COM8229 RIDGE RDTampaFL33605GRP-7985OPTIONS-PPO··
ENRENR-1088592026-05-21T17:46:27ZROBERT—DUNN··1969-08-27UHC-94097-91•••-••-0305304.496.5421··-4219 Indian School RoadPlanoTX75060GRP-0337CORE-HMO
43,101 rows, page 261 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:43.415Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty