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-1286222026-05-06T05:37:22ZKayla—Bennett1940-09-15UHC-47842-61NULL··(229) 390-0637·kayla.bennett10@aol.comnullUNKNOWN-—GRP-7815SELECT-EPO
ENRENR-1186322026-07-25T15:39:06ZWAYNEAGREEN1/24/1981UHC-81589-49•••-••-2939UNKNOWNUNKNOWN3029 HARBOR BOULEVARDTEMPEAZ85244GRP-2250SELECT-EPO
ENR ENR-1016802026-01-19T09:01:46ZOmar—Diaz—UHC-01138-15•••-••-0925+1 288 509 8407·omar.diaz@gmail.com5356 HARBOR BLVDDallasTX—GRP-6860MEDICARE-ADV-A
ENRENR-138333 2026-04-27T23:00:59Zsamuel—allen06/13/1941UHC-12876-11•••-••-08668054020204null6831 MEADOW LNHoustonTexas77081GRP-4905CORE-HMO
ENR ENR-1100152026-03-18T14:13:10ZPATXJAEMS2007-03-02UHC-29865-88•••-••-48868837176774patrick.james@hotmail.com6916 HILLCREST RDMiami·FL33198GRP-8486CORE-HMO
ENRENR-1093852026-09-06T00:33:02ZLori—Nunez04/10/1987UHC-61380-99•••-••-6408407.914.3330—2512 Canyon RoadOrlandoFL··32892GRP-3952MEDICARE-ADV-A
ENRENR-1184062026-05-01T03:31:45ZMEI—LAEN1963-07-23UHC-15267-96•••-••-647612832281350MEI.LANE@YAHOO.COM6232 HILLCREST RDLas VegasNV89186GRP-1877·MEDICARE-ADV-B
ENRENR-1012312026-10-02T15:00:31ZJonathan··—KingOct 6, 1958UHC3599406•••-••-3108534-231-5110JONATHAN.KING55@YAHOO.COM8496 Indian School RoadAUSTINTX78726GRP-7690SELECT-EPO
ENRENR-1301792026-09-17T09:09:28ZmariaO.crawford02/23/1985UHC-47621-95•••-••-2991(271) 970-7659null130 PARK PLSan AntonioTX78282·GRP-1220OPTIONS-PPO··
ENRENR-1256782026-09-22T15:15:12ZRichard—·Parker1949-09-03UHC-08992-48•••-••-0067583-688-3790richard.parker@hotmail.com640 Camelback RdPLANOTX75048GRP-9893SELECT-EPO
ENRENR-1286242026-07-04T05:58:40ZVincent——·1957-12-21UHC-53779-43•••-••-5264N/Avincent.sullivan83@yahoo.com6662 Valley View DriveSan DiegoCA92194GRP-0916OPTIONS-PPO
ENRENR-116178 2026-10-13T09:49:13ZJacobLEvans··12/02/66UHC-47768-24•••-••-4508·(900) 688-0173jacob.evans24@hotmail.com7447 Baseline RdFresnoCA··93759GRP-3724MEDICARE-ADV-B
ENRENR-1131702026-01-04T22:03:08ZNunez, Gabriel——1953-10-26·UHC-04144-51•••-••-9983(446) 227-8029gabriel.nunez@icloud.com8199 CAMELBACK ROADDenverCO··80291··GRP-1554MEDICARE-ADV-B
ENRENR-1252052026-09-27T03:23:48ZAlbertCFreeman1967-05-03UHC-77185-29•••-••-64515295558836—8885 Desert Sky BoulevardTucsonAZ85707GRP-4853medicare-adv-a
ENRENR-1015152026-02-09T11:58:19ZDennisVCooper1995-04-18UHC0610657•••-••-5291400-859-3520··—9776 Park PlOrlando··FL32804GRP-1656MEDICARE-ADV-B
ENRENR-1095632026-04-20T18:53:45ZGERALDCGOMMEZ2004-12-16UHC-71792-78—838-378-3808gerald.gomez12@aol.com8799 Harbor BoulevardMiamiFL33112GRP-4912NAVIGATE-HMO
ENRENR-1342292026-05-05T09:13:21Z·DOUGLASK.EDWARDS91601222UHC-17771-69•••-••-4050·UNKNOWNdouglas.edwards34@hotmail.com5647 Maple AveScottsdaleAZ85244-6293GRP-3844OPTIONS-PPO
ENRENR-1414012026-04-15T12:04:38ZsaraZ.·spencer2000-07-13UHC-62855-10—+1 935 423 8884sara.spencer82@yahoo.com9551 Harbor BlvdMesaAZ85240GRP-8597MEDICARE-ADV-A··
ENRENR-1030872026-10-02T15:43:37ZJoshuaASimmons1977-04-09UHC-13424-53•••-••-3034(429) 727-1590··—3358 Hillcrest RoadColumbusOH—GRP-2272NAVIGATE-HMO
ENRENR-1231982026-08-24T14:46:34ZMejia, Theresa——3/10/1950UHC-12335-75•••-••-70565379148304·theresa.mejia59@proton.me929 Highland AveSeattleWA98177··GRP-3189medicare-adv-b
ENRENR-1136962026-03-02T16:21:05Z·RoaldJMeier1953-06-23·UHC-86684-74•••-••-8873631-821-4847null3978 Spring StJACKSONVILLEFL32254-4170GRP-1786OPTIONS-PPO
ENRENR-1219602026-08-03T22:35:58ZJerrryYMontgomeryJan 26, 1973UHC6194738•••-••-7936-jerry.montgomery72@icloud.com9637 Valley View Dr·San DiegoCA—GRP-4292NAVIGATE-HMO
ENRENR-1058372026-04-25T13:23:30ZALAN—TORRES1966-05-03UHC3493760•••-••-5521·17945164440ALAN.TORRES33@PROTON.ME2033 Maple Avenue··NashvilleTN37205GRP-5379MEDICARE-ADV-A
ENRENR-1170122026-08-05T04:57:58Z GloriaS.Allen12/08/1976UHC-05703-45•••-••-1753308.470.3302··UNKNOWN·585 River RoadAustinTX78773GRP-7332OPTIONS-PPO
ENRENR-1054342026-09-16T21:11:49ZWAYNE—LUNA06/10/1962UHC-07761-24•••-••-57065749302894wayne.luna@proton.me··9398 Willow CtChandler··AZ—GRP-6888medicare-adv-b
ENRENR-1039852026-10-15T16:07:46ZVINCENT—·VALDEZ1938-06-07UHC-81962-47NULL(474) 758-5843VINCENT.VALDEZ66@HOTMAIL.COM764 Cedar LanePhoenixAZ85092GRP-0242NAVIGATE-HMO
ENRENR-1428872026-04-13T09:53:46Z TERESAA.HOWEL1959-10-07UHC-92058-49•••-••-2036+1 550 215 9435·teresa.howell18@hotmail.com6315 Oak StAustinTexas78713-5753GRP-6736MEDICARE-ADV-A
ENRENR-103740 2026-02-26T04:08:51ZSarahZGreen11/1/1961UHC-24458-91•••-••-8428+1 819 472 1588SARAH.GREEN74@YAHOO.COM1438 BroadwayJacksonvilleFL32271GRP-5777CORE-HMO
ENRENR-1169212026-03-20T16:59:16Z·Sharon—Ray2002-08-08UHC-31560-49•••-••-85134045423475sharon.ray@gmail.com7588 MOUNTAIN VIEW DRSan DiegoCA·92197·GRP-9354navigate-hmo
ENRENR-1154692026-08-13T02:02:26ZGregory—Olievr1968-01-05UHC-84650-99•••-••-694412619167719gregory.oliver@yahoo.com7528 Park PlSan DiegoCA··92149GRP-0969OPTIONS-PPO
ENRENR-1381812026-04-03T02:26:34ZJamesGHerrera2005-03-03UHC-87798-18•••-••-6859286-620-0423james.herrera@gmail.com4491 CHURCH STDenverCO80228GRP-8823OPTIONS-PPO
ENRENR-1291582026-05-25T23:40:56ZAdam, YoungB—1992-07-07UHC-88914-95•••-••-8216(364) 425-9702··adam.young@yahoo.com9456 Mesa DriveTempe·AZ85277GRP-2972NAVIGATE-HMO
ENR ENR-1247242026-03-09T20:18:58ZDot—Allen12/21/1941·UHC-26714-76•••-••-8013·UNKNOWNDOROTHY.ALLEN37@GMAIL.COM6257 Park PlLAS VEGASNVUNKNOWNGRP-5949·SELECT-EPO
ENRENR-1063752026-01-21T12:30:50ZSARAHC.MORALES1938-01-06UHC-00912-75-5206296671—5802 Highland AveSan Diego·CA92128GRP-7010MEDICARE-ADV-B
ENRENR-1327192026-02-23T13:42:06ZWAYNEEOBRYENJan 20, 1973UHC-06710-35•••-••-2764(459) 780-4684wayne.obrien@gmail.com1154 Mountain View Drive #807Denverco80293GRP-2838CORE-HMO
ENRENR-1013332026-06-13T17:12:45ZFrancesS.Williamson1987-05-23UHC-65634-96•••-••-1342+1 511 634 9753FRANCES.WILLIAMSON@ICLOUD.COM128 Desert Sky BoulevardMiami·FL33180-0658··GRP-9228OPTIONS-PPO
ENRENR-1371722026-04-28T05:55:56ZFATIMA G—PENA20030223UHC-87570-72•••-••-39376183729935-6951 Washington StreetCharlotte··NC28285·GRP-9685MEDICARE-ADV-B
ENRENR-1072712026-01-08T12:17:00ZJustin—Sanders19910328UHC-38791-36•••-••-762213358934425·justin.sanders@gmail.com2514 Hillcrest RdSeattleWA98180GRP-6072OPTIONS-PPO
ENRENR-1349562026-06-02T17:43:47ZHannah—Ortiz10/10/1957UHC-87191-37•••-••-8212443.285.2812hannah.ortiz77@gmail.com6790 Harbor BoulevardSan DiegoCANULLGRP-6897CORE-HMO
ENRENR-1024852026-10-17T19:00:00ZGary—Hughes··24-05-1977UHC-90567-68—(492) 951-9669gary.hughes@icloud.com1898 Pine DriveLOS ANGELESCA90000GRP-1181select-epo··
ENRENR-1349012026-08-10T15:17:48ZElizabethGReed1950-03-08UHC5592283•••-••-7921932-566-0609ELIZABETH.REED@HOTMAIL.COM4011 MAPLE AVEHoustonTX77055GRP-9161OPTIONS-PPO
ENRENR-1188032026-08-04T04:23:08ZARTHUR—WAGNER1938-09-25UHC-67545-55•••-••-32524162532653arthur.wagner52@proton.me7311 Baseline RoadSan AntonioTX·78201GRP-5137·SELECT-EPO
ENRENR-1254002026-08-24T05:11:56ZNicoleDHudson9/1/1939UHC-10142-51··•••-••-71172958899NULL-··UNKNOWN-GRP-5389SELECT-EPO
ENRENR-1117392026-01-23T13:14:02ZJacobS.Boyd11-04-1965UHC-72588-96··•••-••-7223431-226-6706jacob.boyd81@proton.me7792 Grand AveMESAAZ85296GRP-5614CHOICE-PLUS-PPO
ENRENR-1376992026-09-30T11:06:39Z·Pamela—Cooper1993-04-16UHC-38311-79•••-••-6706(599) 563-5429PAMELA.COOPER45@PROTON.ME7204 Indian School RdMiamiFL·nullGRP-3246CORE-HMO
ENRENR-1057362026-07-08T17:33:05ZMeiIRoberts1/12/1976UHC-45527-73•••-••-7806—mei.roberts69@icloud.com6782 Spring Street·ChandlerAZ—GRP-9808OPTIONS-PPO
ENRENR-1401472026-10-01T00:05:02ZBryant, Luri——20-08-1998UHC-70153-08•••-••-6622(355) 574-7096lori.bryant@outlook.com6849 Lincoln WaySeattleWashington98103GRP-9307MEDICARE-ADV-A
ENRENR-1187742026-02-28T04:26:56ZChristopher—Schultz-UHC-54551-93•••-••-2289(868) 292-7404christopher.schultz@hotmail.com7314 Bayshore DriveDenverCO··80291GRP-5138MEDICARE-ADV-A
ENRENR-1364522026-02-15T10:22:03ZJessica—Martin1999-01-11UHC-03751-82•••-••-204516482936808··jessica.martin@aol.com1720 Willow CtNashvilleTN37242GRP-7686SELECT-EPO
ENRENR-1360562026-09-20T11:12:02ZBEVERLYGSANTOS19840321UHC-19689-95•••-••-9950745-827-5991BEVERLY.SANTOS21@GMAIL.COM7505 OCEAN AVEFresnoCAUNKNOWNGRP-8593CORE-HMO
43,101 rows, page 202 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.341Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty