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

All sources, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
ENRENR-1391282026-07-14T16:55:36ZkathrynYreed1947-09-10UHC-08219-66N/A844.594.1316kathryn.reed@outlook.com9599 Main StDenver··CO80226GRP-5934OPTIONS-PPO
CLMCLM-4199462026-07-25T20:28:52ZBRADLEY D—ARMSTRONG1948-12-15UHC-69711-57·UNKNOWN———-nullUNKNOWNGRP-6187NULL
CLMCLM-4142692026-09-09T10:13:55ZBetty—Pena·10/3/1953UHC-15755-28•••-••-5550588-666-3083betty.pena37@hotmail.com8194 MAPLE AVENUE Apt 5Nashville·TN37272·GRP-5716null
CLMCLM-4058442026-04-08T11:32:41ZRandy—Reid·Jul 28, 1953NULL—-null8551 WASHINGTON STREETLas VegasNV89101·GRP-6501CORE-HMO
CLMCLM-4299852026-07-07T15:53:09ZTheresa—McDonaldSep 28, 1967UHC-35139-46··•••-••-0479N/A—3477 JEFFERSON AVEMESAAZ85242··GRP-2756MEDICARE-ADV-B
ENRENR-1244132026-08-12T03:25:54ZRUSSELL··—BROWN1941-07-27UHC5935998•••-••-2632279.465.9772russell.brown@aol.com654 FOREST AVENUEOrlandoFL32804GRP-7518CHOICE-PLUS-PPO
ENRENR-1031702026-10-14T18:31:19ZRoberts, PeterE—04/11/1988UHC-41456-86•••-••-72684076290973—7569 Church StreetScottsdaleAZ85253-5180GRP-8886NAVIGATE-HMO
CLMCLM-4235442026-09-12T10:55:37ZTYLERZ.LI1950-08-22·-null——nullN/ANULL—-null
ENRENR-1029692026-05-31T08:11:35ZAlan—RiceJan 27, 1989·UHC-29266-34•••-••-0719—alan.rice78@hotmail.com4973 CHURCH STREETTUCSONAZ85721···GRP-5604MEDICARE-ADV-B
PRVPRV-237632026-10-02T23:09:55ZHolmes, Sean··—08/13/03uhc-34874-09NULL307-384-5941-7645 Apache BoulevardDALLASTX75210null··
ENRENR-1212772026-06-18T04:22:32ZPriya—Morris··02/10/45UHC-07834-90•••-••-6131(744) 223-5788priya.morris@yahoo.com96 MESA DREden PrairieMN55385GRP-9699MEDICARE-ADV-A
CLMCLM-4118132026-01-17T08:05:38ZLauren·IJohnston01-03-1940UHC-02841-38•••-••-25624098863695··—5827 WILLOW CTHouston·TX77080UNKNOWN—
ENRENR-1418912026-04-21T19:52:36ZWilliam—Harrison1943-08-23UHC-73581-93•••-••-36843703515817WILLIAM.HARRISON@PROTON.ME5282 Grand AvenueChandlerAZ85284GRP-3760··MEDICARE-ADV-B
ENRENR-1329922026-04-05T18:30:22ZPaul—Lee1963-01-17UHC-95741-07•••-••-10567956322109PAUL.LEE@AOL.COM129 Canyon Road··DALLAStx75244GRP-6275·CORE-HMO
ENRENR-1127712026-05-22T20:06:01ZRobert—Garza1963-11-10··UHC-33869-29—·962-974-9848N/A9800 Oak StAtlantaGA30356GRP-0502MEDICARE-ADV-B
CLMCLM-4157272026-01-12T17:45:13ZRANDY—MARSHALL2007-12-17UHC-21917-14—-—1355 HARBOR BLVDLos AngelesCA90048-4081GRP-2202MEDICARE-ADV-B
ENRENR-1126692026-05-17T10:33:24ZJOANV.GARRETT1950-03-20UHC-30737-02•••-••-5171(436) 956-7098·null9201 CEDAR LNAustinTX78750GRP-9619options-ppo
CLMCLM-4278952026-09-03T12:22:51ZAARON—KNIGHT1983-07-13UHC-95721-09-——8293 SPRING STREETNashvilleTN37219GRP-2556—
ENRENR-1116422026-05-15T06:48:10ZBrooks, KeithJ.—04/21/05UHC-41430-75•••-••-8543371-680-7862-2003 Grand AveMiamiFL33158GRP-9050SELECT-EPO
ENRENR-1088372026-02-10T01:17:21ZLORIJLUCAS91531209UHC-00588-86—2448153512—9365 PALM DRIVEDENVERCO80288-4451GRP-7425··SELECT-EPO
CLM CLM-4111612026-09-05T20:30:24ZBRITTANY—MUNOZ19480417UHC-17677-75•••-••-4368null—1220 Desert Sky BoulevardHOUSTONTX77015N/A··OPTIONS-PPO
ENRENR-1041812026-03-09T01:20:42ZWalter··—Espinoza··10/15/73uhc-26179-57•••-••-07928958443276-7825 Cedar LnORLANDOFL32851-6687GRP-8821CHOICE-PLUS-PPO
ENRENR-1204302026-03-26T04:20:46Z—C.—1941-92-16uhc-84757-69•••-••-6716(572) 803-4951omar.rios79@yahoo.com7108 Park PlaceGILBERTAZ85204GRP-6951MEDICARE-ADV-A··
ENRENR-1273912026-03-24T09:15:13ZJulia··McDonald1990-11-24UHC-03252-20•••-••-7515360-664-3257NULL7526 Hillcrest RdPlanoTX—GRP-2790OPTIONS-PPO
ENRENR-1415962026-03-20T13:43:59ZLauren····James1959-12-23UHC-88606-72•••-••-20016405143845LAUREN.JAMES@PROTON.ME147 OCEAN AVENUEFresnoCA93754GRP-8991CORE-HMO
TPATPA-610822026-01-17T19:31:39ZDaniels, Carolyn··——12/25/46N/A—(786) 779-2967—5483 CEDAR LNAustinTX78716··N/ANAVIGATE-HMO··
CLMCLM-4018222026-08-04T06:56:23ZANDREA—BISHOP19750720··UHC-70074-36•••-••-8821NULL····7664 SUNSET BLVDEDEN PRAIRIEMN·55350GRP-0354null
ENRENR-1272572026-03-13T09:48:52ZAndrew—Bradley···1951-04-22UHC-41862-45•••-••-92028902605677null9405 Washington StreetTempeaz85205-7499GRP-2045·MEDICARE-ADV-A
TPATPA-582052026-05-16T23:39:55ZChuck··James1985-01-01UHC-80457-27—null-6831 DESERT SKY BLVDMiamiFL33107··GRP-0582—
CLM CLM-4170502026-06-26T18:04:27ZANDREA—BELL1940-01-26UHC-37247-96··—(517) 999-1466null9349 Lake View RdGilbertAZ85250··N/AMEDICARE-ADV-A
TPATPA-552432026-08-02T17:04:17ZAlbert—Luna1957-11-14NULL•••-••-3206—N/A908 PINE DRIVEColumbusOH43206GRP-0973—
TPATPA-58035 2026-09-15T07:07:17ZPeter—Santiago1962-08-17—····UNKNOWNNULL8587 Valley View DriveEDEN PRAIRIEMN55337UNKNOWNNULL
CLMCLM-4117772026-01-06T10:03:54ZLaura—Ruiz1990-01-04—•••-••-9555nullnull2480 Elm StreetPlanoTX75030GRP-7996CHOICE-PLUS-PPO
PRVPRV-262272026-05-12T11:50:20ZDick—Lawrence1950-10-16null•••-••-0235627-211-8276RICHARD.LAWRENCE@ICLOUD.COM6026 CHURCH STREETGilbert·AZ85225—NULL
ENRENR-1083532026-03-13T17:10:24ZSarah—Li19451102UHC-74512-30•••-••-928318293356117sarah.li3@yahoo.com8484 JEFFERSON AVENUESacramento··CA95811GRP-3091SELECT-EPO
TPATPA-539342026-08-29T09:40:29ZGomez, MariaO··—20-10-1954····NULL3334758475-6645 APACHE BOULEVARDAtlantaGA30380UNKNOWN—
ENRENR-1110312026-01-28T21:00:14ZSeanVOwens1984-01-05UHC-64788-47•••-••-8180(641) 704-3423sean.owens@yahoo.com5632 Baseline RdSan DiegoCA92137·GRP-8392SELECT-EPO
CLMCLM-4014142026-09-13T14:31:18ZNathan—Montgomery4/18/2000UHC-06179-36UNKNOWN979-550-0880N/A1072 Pine DrivePhoenixArizona85053null—
TPATPA-575972026-02-05T00:44:10ZOmar—Adams1972-10-03N/A•••-••-0966—-··nullUNKNOWN—N/A-
ENRENR-1031772026-09-27T16:52:38ZKATHLEENWCOLE1991-08-26·UHC-27256-01•••-••-0743584-507-2561KATHLEEN.COLE@OUTLOOK.COM·186 Ocean AveMesaAZ85202GRP-0400OPTIONS-PPO
PRVPRV-278312026-02-04T23:01:55ZRuth—Spencer2002-07-12UHC-50944-63nullN/Anull1966 Main StreetTempeAZ85241--
ENRENR-1256342026-04-02T15:39:06ZSanders, Brandon··—Aug 17, 1992UHC7139078•••-••-71982586629641BRANDON.SANDERS@YAHOO.COM9596 Mountain View DrivePhoenix·AZ85027GRP-3547MEDICARE-ADV-B
ENRENR-1146382026-09-12T16:40:02ZAnna—Gordon1949-12-19UHC-99377-53•••-••-1327NULL-4857 Washington StreetNashvilleTN37229GRP-8888NAVIGATE-HMO
TPATPA-567372026-01-02T03:09:11ZMargaret—Burke13-12-1993————2687 Canyon RdNashvilleTN37222——
CLMCLM-4312892026-09-07T09:58:26ZRoyU.Ortiz04/07/95UHC-61154-15•••-••-16077566682215ROY.ORTIZ28@HOTMAIL.COM6507 Bayshore DriveAustinTX78737GRP-7783null
CLMCLM-4132172026-06-19T10:44:29ZMaldonado, MarkF.—6/11/1990··UHC0758891•••-••-7295(533) 513-9184mark.maldonado@icloud.com925 Central AvenueEDEN PRAIRIEMN55325GRP-1135UNKNOWN
ENRENR-1198282026-01-25T03:05:34ZJuliaT.Garcia14-03-1989··UHC-18000-24•••-••-8877386-368-8391julia.garcia54@icloud.com5786 Elm StreetGlendaleaz85387GRP-1380MEDICARE-ADV-A
ENRENR-1265132026-03-28T01:22:05ZSusan—Yang2000-01-13UHC-21009-42•••-••-37884769869935susan.yang@yahoo.com3414 Church StJACKSONVILLEFL-GRP-6365NAVIGATE-HMO
TPATPA-504382026-05-02T00:03:57Zpatricia—le01/08/1963—NULL(743) 608-0593—9221 Sunset BoulevardAtlantaGA30367NULLOPTIONS-PPO
CLMCLM-4190522026-07-30T07:29:50ZBrandonVKennedy2007-03-50··null-·+1 570 418 3417—N/A-··nullN/A—N/A
100,000 rows, page 131 of 2,000PreviousNext

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:36.691Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty