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-1311792026-10-13T08:17:59ZDorisOWeaver04/04/94UHC-85018-09•••-••-7086UNKNOWNdoris.weaver52@icloud.com1270 SPRING STREETColumbusOH43210·GRP-6411CORE-HMO
ENRENR-1034702026-05-30T21:13:02ZGLORRIAFWOODS2007-03-20·UHC-53226-29•••-••-32789793379147gloria.woods47@hotmail.com1969 Washington StTucsonAZ85774GRP-4412CHOICE-PLUS-PPO
ENRENR-1291642026-01-12T00:36:00ZGabriel H—Bradley3/5/1946UHC0003462•••-••-0002(468) 438-6833GABRIEL.BRADLEY65@ICLOUD.COM1795 Church StreetFresnoCalifornia93742GRP-9062SELECT-EPO
ENRENR-1243472026-02-05T21:26:30ZAlexander—Porter1964-05-26UHC4488309•••-••-0978(232) 280-3488ALEXANDER.PORTER@PROTON.ME5975 Pine Drive··ChandlerAZ85274GRP-9376CORE-HMO
ENRENR-1277952026-10-12T20:18:15ZSOFIA—BOWMAN2001-05-20UHC-97858-75•••-••-5639860-682-0889—8214 Bayshore DriveTempeAZ85285GRP-4735CHOICE-PLUS-PPO
ENRENR-1371262026-03-09T04:31:05ZJONATHAN··ZKENNEDY12/2/1961UHC-96291-49•••-••-8335-JONATHAN.KENNEDY2@GMAIL.COM2767 GRAND AVENUETampaFL33605GRP-8224NAVIGATE-HMO
ENRENR-1283462026-04-03T16:38:50ZTyleer··B.··Peters5/14/1958UHC-27057-83•••-••-09032784234873tyler.peters34@proton.me139 CANYON RDAustinTX78735GRP-8398·NAVIGATE-HMO
ENRENR-1325092026-08-31T16:48:11ZCHRISTINAH·OLSON·1982-04-09UHC-03101-34•••-••-286618576169578christina.olson@aol.com7834 Sage CourtHoustonTX77083GRP-0780CHOICE-PLUS-PPO
ENRENR-1023272026-06-11T23:10:53ZbobbyPkelly1975-04-25UHC-98988-55•••-••-4939·+1 387 583 2552bobby.kelly@proton.me7032 Mesa DrPLANOTX75090-3284GRP-0854NAVIGATE-HMO
ENRENR-1314692026-06-17T23:32:00ZKATHY—CRAWFORD·1964-12-08UHC-91893-76•••-••-5522425.682.5536KATHLEEN.CRAWFORD@OUTLOOK.COM··——-··N/AGRP-3853·CHOICE-PLUS-PPO
ENRENR-1065652026-03-28T16:34:40Z Turner, DiegoO—20-06-1949UHC-55844-12•••-••-0393(512) 746-8412—6968 Harbor BlvdDallasTX75279GRP-9538NAVIGATE-HMO
ENRENR-1297652026-09-02T00:43:05ZRoger··—BennettMar 2, 2000UHC-51537-03—12312656060ROGER.BENNETT80@PROTON.ME6308 Spring StreetAUSTINTX·78757GRP-3828NAVIGATE-HMO
ENRENR-1004542026-08-13T15:41:22ZGary·GCarlson1979-10-28UHC-29071-75•••-••-0152312-428-3236gary.carlson43@proton.me3025 Grand AveDallasTX75249GRP-9320MEDICARE-ADV-A
ENRENR-1239402026-04-10T18:08:45ZMatthew—Patel05/04/96UHC-87617-45•••-••-50414181112matthew.patel@yahoo.com9252 Pine DrSan DiegoCA·92132GRP-7088··OPTIONS-PPO
ENR ENR-1169062026-04-23T00:57:42ZBobby—Powell1965-12-22···uhc-79003-10•••-••-8360(601) 417-9192BOBBY.POWELL@PROTON.ME5887 Ocean AvePhoenixaz··85091GRP-4533MEDICARE-ADV-A
ENRENR-1078652026-04-25T20:43:46ZJANICE—·HILL1944-06-25UHC-52485-49•••-••-7620(695) 368-3730JANICE.HILL@HOTMAIL.COM4290 Mesa DrEden PrairieMN55318GRP-6344NAVIGATE-HMO
ENRENR-1156092026-04-26T22:02:28ZJOHNYSANDERS1999-07-08UHC-07416-24•••-••-9132201-637-6492NULL7846 Mountain View DrivePlanoTexas75075GRP-6734SELECT-EPO
ENRENR-1195752026-02-02T14:36:27ZDennisH.MurphyAug 12, 1962··UHC-72122-15•••-••-94873272899178dennis.murphy83@aol.com1093 Baseline RoadPlanoTX75094··GRP-1348CHOICE-PLUS-PPO
ENRENR-1197792026-01-02T13:06:59ZSueH·Ortega06/13/94UHC-23079-17—6839264413NULL2222 CAMELBACK ROADSCOTTSDALEAZ85260·GRP-5030SELECT-EPO
ENRENR-1247642026-02-19T05:58:24Zkayla A—garrett1993-01-02UHC-84412-04•••-••-8628595-271-1400KAYLA.GARRETT@ICLOUD.COM3765 DESERT SKY BLVDFresnoCA93773GRP-5219NAVIGATE-HMO
ENRENR-1286032026-06-10T15:34:57ZOLIVIAG.··DUNCAN19781022·UHC-53978-39•••-••-4103-—5226 Baseline RdTampaFL33646GRP-8891NAVIGATE-HMO
ENRENR-1377162026-01-02T00:08:35ZPeterHPerry1943-06-26UHC-37323-32•••-••-4525490-577-2387peter.perry18@icloud.com·5594 Elm StreetOrlandoFL·32836GRP-2784SELECT-EPO
ENRENR-1133642026-08-28T15:58:13ZEvelyn—Campbell1999-05-21UHC8892795•••-••-4631374-766-7952EVELYN.CAMPBELL@YAHOO.COM8276 SPRING STREETORLANDOFL—GRP-1243MEDICARE-ADV-A
ENRENR-1226422026-06-29T12:54:21ZRobertK.Sandoval10/28/83·UHC-65139-83•••-••-9880291-744-1160robert.sandoval@hotmail.com1782 MOUNTAIN VIEW DR·FresnoCA93776···GRP-3051MEDICARE-ADV-A
ENRENR-1195302026-03-05T08:20:31ZARJUNLWARD1980-04-04·UHC-23650-47•••-••-6404340-928-7056arjun.ward@proton.me535 Willow Court Apt 26DenverCO80212GRP-0507OPTIONS-PPO
ENRENR-1427242026-02-08T21:45:39ZSophia—Reid19871127UHC-92033-81•••-••-3464·928-313-8042UNKNOWN4481 BAYSHORE DRIVELas VegasNV89121GRP-6536CHOICE-PLUS-PPO
ENRENR-1370602026-10-08T20:36:19ZPatrickBJacoobs1971-01-09UHC-46572-14•••-••-7181921-329-8293patrick.jacobs5@hotmail.com2987 Elm StreetEden PrairieMN55389GRP-2816·SELECT-EPO
ENRENR-1203612026-09-30T00:22:33ZRoes, FrancesV—03/14/1991UHC-35281-32•••-••-4674(364) 607-2891FRANCES.ROSE44@HOTMAIL.COM7938 CHURCH ST·GilbertAZ85260GRP-1876CORE-HMO
ENRENR-113690 2026-05-26T15:16:07ZkaylaJ·diaz·1980-53-20UHC-50759-52•••-••-53542199231856kayla.diaz@hotmail.com3694 Meadow LnJacksonvilleFL32284GRP-0453CORE-HMO
ENRENR-1306052026-04-04T03:45:21Zdavid·Dbarnes·09/09/72UHC-38781-88N/A384.705.3053david.barnes86@yahoo.com8997 Pine DriveCharlotteNC··28203GRP-7394OPTIONS-PPO··
ENRENR-1003052026-07-09T03:12:47ZBRYANS.DUNN2004-10-04UHC-96279-54•••-••-239416666139332BRYAN.DUNN2@HOTMAIL.COM4577 Lake View RoadTempeAZ··85288GRP-9669·OPTIONS-PPO
ENRENR-1208782026-06-13T19:19:28ZCHRIS··OFREEMAN1977-06-08UHC-34571-07•••-••-38293706933421christopher.freeman@hotmail.com8397 Oak StreetChandlerAZ·85260GRP-5426OPTIONS-PPO
ENRENR-1013502026-05-07T04:15:33ZCarlos—Hernandez1965-12-03UHC-02676-94•••-••-8853N/AN/A6976 Cedar LaneNASHVILLETNNULL··GRP-1937core-hmo
ENRENR-1050242026-02-14T13:09:10Z RAYMONDWRAMOS2003-12-14UHC-67665-29•••-••-24525749491412RAYMOND.RAMOS@ICLOUD.COM2185 Church StreetMinneapolismn55488GRP-8439MEDICARE-ADV-B
ENRENR-1286882026-07-28T04:48:05ZJustin—Howard1977-06-18UHC5343772—16199645964·JUSTIN.HOWARD@ICLOUD.COM9252 Highland AveMINNEAPOLISMN55433GRP-3362CORE-HMO
ENRENR-1309672026-03-14T21:47:36ZGraceIWilliams··4/18/1977uhc-70016-34•••-••-5538·(223) 237-4335grace.williams72@hotmail.com9067 Highland AvenueJacksonvilleFL32233GRP-5818NAVIGATE-HMO··
ENRENR-1142972026-09-05T17:04:15ZWEIX.RIOS·5/8/1953UHC-03294-76UNKNOWN2615011null9157 Bayshore DriveChandlerAZ··85248GRP-4135OPTIONS-PPO
ENRENR-1158162026-06-22T04:12:22ZMontgomery, Jordan——01/10/68·UHC-81385-32•••-••-2824355-291-4224UNKNOWN5343 Spring Street #397GILBERTAZ85204GRP-2593SELECT-EPO
ENRENR-1090712026-09-09T05:46:34ZCheryl—Rogers1980-08-20UHC5917636•••-••-9952·(622) 321-1842·cheryl.rogers6@proton.me3543 SAGE CTAustinTX—GRP-5063OPTIONS-PPO
ENRENR-1287672026-09-24T12:28:10ZVirginiaACampbell1996-06-23UHC-50112-68•••-••-9251739-861-5477virginia.campbell@proton.me9298 River RdGilbertAZ85255··GRP-8291NAVIGATE-HMO
ENRENR-1178932026-08-28T21:01:45Z·JANICE—ROBINSON1989-07-16UHC-21270-03•••-••-1396700-387-9475NULL5220 River RdColumbusOH43244GRP-1055MEDICARE-ADV-A
ENRENR-1223922026-03-02T12:02:54ZCHRISTINA··GSTONE1983-04-02UHC-45212-97•••-••-79346774408686christina.stone11@aol.com2805 Highland AvenueFRESNOCA93799GRP-4231SELECT-EPO
ENRENR-1294962026-09-23T19:12:52ZJoey Y—Hamilotn1978-12-24-•••-••-6250472-769-3584joseph.hamilton@aol.com6887 Hillcrest RoadPLANOTX··75052GRP-4097OPTIONS-PPO
ENRENR-1049132026-09-26T23:26:27ZHeatherTWalsh10/11/42UHC-45163-98•••-••-161019213022278N/A6927 OAK STREETEden PrairieMinnesota55365GRP-8956CHOICE-PLUS-PPO
ENRENR-1415072026-02-24T22:21:24Z·PATRICKY.FISHER2008-04-12UHC-39580-82•••-••-5997—patrick.fisher89@gmail.com799 CHURCH STREETDallasTX75206GRP-1419MEDICARE-ADV-B
ENRENR-142364 2026-03-02T14:09:34ZGarrett, DavidP.—Nov 27, 2002UHC-37765-78•••-••-2780293-842-3482david.garrett@outlook.com3962 MARKET STREETSeattleWA98158GRP-2215CORE-HMO
ENRENR-1098012026-09-03T20:57:36ZFernandez, TylerC—08/14/78UHC-64576-92•••-••-2825667-237-6826tyler.fernandez14@proton.me4638 MOUNTAIN VIEW DRIVELos Angelesca90025GRP-9160MEDICARE-ADV-A
ENRENR-1219142026-06-30T18:40:46ZDANIELLE—HILL19951209UHC-74628-55•••-••-6224+1 230 202 9522DANIELLE.HILL@PROTON.ME1649 Desert Sky BlvdORLANDOFL32812GRP-2801MEDICARE-ADV-B
ENRENR-1160682026-03-26T11:49:40Zedward··Znichols19970426UHC2666744N/A923-914-2340EDWARD.NICHOLS@AOL.COM4601 RIDGE ROADDallasTexas75216GRP-5696CHOICE-PLUS-PPO
ENRENR-1416432026-04-20T09:23:23ZsamanthaYthompson1977-08-09UHC-17634-87•••-••-4629777-604-0312··5712 Pine DriveGlendale··AZ85306GRP-4068SELECT-EPO
43,101 rows, page 325 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.620Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty