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-1035822026-09-24T14:44:25ZCharles··MFernandez1/10/1944UHC-62270-60•••-••-58023236828782charles.fernandez38@proton.me8171 Canyon RoadTampaFL33653-0443GRP-5911CORE-HMO
ENRENR-1167172026-04-24T08:37:39ZMariaYEspinoza05/18/89UHC-50637-70•••-••-2752(328) 210-6202maria.espinoza@outlook.com5128 Spring StreetMiami··FL33122··GRP-3705CORE-HMO
ENRENR-1362242026-08-26T01:00:16Z·justin—barnes1967-11-25UHC1954278—7253477336JUSTIN.BARNES47@HOTMAIL.COM7470 Valley View DriveSeattleWA··98115GRP-9912SELECT-EPO
ENRENR-1043212026-01-09T21:42:35ZChristine—Carr1989-06-21··UHC-75442-40UNKNOWN(938) 575-7684—6423 Jefferson AvenueNashvilleTN37272GRP-0723MEDICARE-ADV-B
ENRENR-1296102026-07-18T14:34:08ZBRITTANYFSANDOVAL1963-09-13UHC4693278•••-••-93793088895811brittany.sandoval84@proton.me9865 Desert Sky BoulevardEden PrairieMN55339GRP-5457CHOICE-PLUS-PPO
ENRENR-1380062026-03-21T18:38:50ZALBERT—WALLACE1972-01-72UHC-61755-91—680-474-2954··albert.wallace42@icloud.com··553 Park PlaceChandlerAZ85209GRP-5494MEDICARE-ADV-B
ENRENR-1084572026-09-21T06:49:53ZHicks, Samantha——1955-07-24UHC2755825•••-••-1445nullnull3610 Valley View Dr···EDEN PRAIRIEMN55346-4582GRP-2372MEDICARE-ADV-A
ENRENR-1139702026-04-24T03:07:09ZEvelynV··Coleman19821113·UHC-59991-62•••-••-470717553933108evelyn.coleman@yahoo.com5757 Main StTAMPAFL·33672GRP-1530OPTIONS-PPO
ENR ENR-1215172026-07-16T14:30:23ZMaryWJordan1992-10-08··UHC-43821-91•••-••-67376645600559MARY.JORDAN83@AOL.COM1326 BROADWAYTampaFL33692GRP-5351··NAVIGATE-HMO
ENRENR-1027072026-04-23T11:13:09ZAustin—CookJul 22, 1959UHC-55723-65•••-••-5435641-468-2455·austin.cook33@icloud.com4599 SUNSET BOULEVARDDenverCO80296GRP-8590MEDICARE-ADV-B
ENR ENR-1007132026-02-25T20:27:32ZAmandaO.··Rice1982-08-02UHC-69443-51•••-••-4463(655) 535-7007AMANDA.RICE83@AOL.COM6243 Lake View RdMinneapolisMN55444GRP-1815CHOICE-PLUS-PPO
ENRENR-1194452026-07-05T23:20:41Z·ABIGAIL·GDAY1954-10-15UHC-60035-57•••-••-43635772110160ABIGAIL.DAY40@HOTMAIL.COM4013 Spring StreetMiamifl33127··GRP-4361NAVIGATE-HMO
ENRENR-1058902026-08-14T11:25:39ZJORDANTJACOBS1978-10-19·UHC6394859null3977859589jordan.jacobs@outlook.com4718 Desert Sky BlvdTempeAZ85211GRP-5857··NAVIGATE-HMO··
ENRENR-1073912026-05-17T01:54:49ZLaurenQ.HakinsUNKNOWNUHC-71458-08•••-••-37146494807881lauren.hawkins@outlook.com6596 Elm StreetDenverColorado80298GRP-8544MEDICARE-ADV-B
ENRENR-1381492026-05-27T18:10:57ZBrenda—Phillips1961-06-05UHC-75690-49null(804) 353-7023brenda.phillips@gmail.com··1876 CENTRAL AVEMiamiFL33110GRP-1910OPTIONS-PPO
ENRENR-1016622026-02-22T19:40:58ZFrankPNunez1989-00-55UHC-16151-75•••-••-5402—FRANK.NUNEZ15@HOTMAIL.COM8405 MAPLE AVENUE Apt 12TampaFlorida33658GRP-8379NAVIGATE-HMO
ENR ENR-1363472026-09-07T14:05:08ZDebraURiley1972-01-01UHC-50659-18NULL4483737672debra.riley@gmail.com6684 Broadway Apt 18HoustonTX77005GRP-3835CHOICE-PLUS-PPO
ENRENR-1224232026-02-07T19:03:27ZWong, EricX—1985-04-05uhc-55149-77•••-••-1522561-513-7113eric.wong91@yahoo.com6146 Meadow LnOrlandoFL32878GRP-5332MEDICARE-ADV-A
ENRENR-1275292026-10-09T16:51:52Zvirginia··Mjordan06/18/74UHC-40489-77•••-••-03363566574341VIRGINIA.JORDAN@OUTLOOK.COM585 Ocean AvenueFresnoCalifornia·93792GRP-8554select-epo
ENRENR-1387132026-06-19T22:13:37ZAndy—Lynch··1967-09-02UHC5220615•••-••-6080449.750.9769andrew.lynch@yahoo.com7076 Grand AveScottsdale··AZ·85279GRP-5303MEDICARE-ADV-B
ENRENR-1301972026-04-06T16:37:56Zchristina—contreras06-07-1967UHC-62827-35··UNKNOWN9404286373null5299 Canyon RdTucson··AZ85796GRP-3510options-ppo
ENRENR-1358502026-10-11T23:25:29ZNathan—Gilbert2008-01-10UHC-54667-70•••-••-28175297456638nathan.gilbert89@aol.com9116 SUNSET BOULEVARDCHARLOTTENC28217GRP-3357NAVIGATE-HMO
ENRENR-1132512026-09-29T04:07:35ZWILLIEGESPINOZA19309922UHC-99098-64··•••-••-8462(394) 337-1897—6665 Harbor BoulevardChandlerAZ85275-7602GRP-5383NAVIGATE-HMO
ENRENR-1067292026-07-25T20:07:12ZKimberly—Harvey··—UHC-92279-14··•••-••-0128(850) 499-3068····8206 CEDAR LNFresno·CA93766GRP-0168medicare-adv-a
ENRENR-1278182026-06-07T12:50:58ZHelan—Morrison05/18/91··UHC-00390-60—nullhelen.morrison60@yahoo.com5356 Oak StreetDALLASTX·75217GRP-5997SELECT-EPO
ENRENR-1295492026-04-06T22:24:10ZPayne, BenjaminV.—1991-12-09UHC-66516-34•••-••-8846330-494-2626benjamin.payne82@gmail.com9168 Ocean AvenueAustin·TX78779GRP-8652medicare-adv-a
ENRENR-1136362026-09-14T17:12:45ZAARONMLARSON1995-06-15UHC-25525-72•••-••-68393493046AARON.LARSON62@HOTMAIL.COM··7090 Union StMinneapolisMN55418GRP-0415·MEDICARE-ADV-A
ENRENR-1155322026-09-06T14:33:44Z NATALIEHMORRIS2000-10-13UHC-66123-66—9424300014NATALIE.MORRIS@AOL.COM8480 Desert Sky BoulevardSeattle·WA98125GRP-2324CORE-HMO
ENRENR-1392752026-10-17T17:59:11ZBETTYQSANDOVAL1944-09-25UHC-13305-47UNKNOWN14354236348N/A1080 DESERT SKY BLVDDallasTX75227GRP-5419SELECT-EPO
ENRENR-1073652026-01-18T16:48:52ZMadison·E.Simmmons1970-06-11UHC-47808-51•••-••-3036611-380-2927··UNKNOWN1841 LAKE VIEW RDSacramentoCA95862GRP-9662·CHOICE-PLUS-PPO
ENRENR-1051122026-10-10T15:46:25ZThomas—Welch2004-12-10UHC-87160-11•••-••-4694(428) 445-0782thomas.welch@icloud.com··7503 BROADWAYPlanoTX75050GRP-5371CHOICE-PLUS-PPO
ENRENR-1384662026-09-03T15:58:29ZBETTY—WRIGHT1996-05-07UHC-97501-96··-+1 607 664 0120BETTY.WRIGHT9@PROTON.ME·6345 DESERT SKY BLVDMiamiFL—GRP-6455MEDICARE-ADV-B
ENRENR-1058282026-06-14T17:51:15ZLisa—Campell—UHC-87281-93•••-••-669816732717388lisa.campbell@icloud.com1629 Pine Dr #601DenverCO80275GRP-5830OPTIONS-PPO
ENRENR-1254422026-09-20T11:36:31ZMARILYN—CARR1960-12-19UHC-90566-07•••-••-23604926232397MARILYN.CARR89@ICLOUD.COM3588 Jefferson AveTampaFL—GRP-3245OPTIONS-PPO
ENRENR-1333072026-06-03T17:50:00ZASHLEYWRICHARDSON1965-01-18uhc-96287-84··18412204558ASHLEY.RICHARDSON@AOL.COM5796 SAGE CTOrlandoFL·nullGRP-7020CORE-HMO
ENRENR-1323642026-01-25T21:04:01ZGABRIELCPTTERSON1980-06-05UHC-73125-87•••-••-4021964.225.2123gabriel.patterson11@yahoo.com2762 Elm St··GlendaleAZ85393GRP-7731MEDICARE-ADV-B
ENRENR-1158862026-07-04T14:20:01Z ANDREW P.—LEE1991-10-06UHC-17562-92··-2407658201andrew.lee47@proton.me9648 Grand Avenue···Eden PrairieMN55342·GRP-8410MEDICARE-ADV-A
ENRENR-1375582026-09-04T10:58:43ZJack—Yang1943-60-04UHC-59751-23•••-••-07673408163035JACK.YANG27@AOL.COM2958 CAMELBACK ROADLAS VEGASNV89194GRP-8339NAVIGATE-HMO
ENRENR-1213862026-09-19T15:25:29ZChristinaECarr1967-05-17UHC-12488-39•••-••-1106NULLCHRISTINA.CARR58@GMAIL.COM805 Mountain View Drive··AustinTexas78705GRP-5205CHOICE-PLUS-PPO
ENRENR-1221232026-09-11T21:22:34ZLUCIAJREYES··1983-01-25UHC9655565—875-663-7893UNKNOWN5902 Canyon RdCharlotteNC28222GRP-8501CORE-HMO
ENRENR-1263462026-08-29T22:50:47ZbetyM.johnston·24-07-2007uhc-34962-06•••-••-15265288246414betty.johnston@outlook.com5310 Maple AvenueAtlantaGA30368·GRP-9799MEDICARE-ADV-A
ENR ENR-1018632026-04-09T08:33:38Z·Black, StephhanieA—2/20/1984UHC-71521-26··•••-••-55718072891271STEPHANIE.BLACK@ICLOUD.COM3602 MEADOW LNMesa·AZ85278-2352GRP-9323·MEDICARE-ADV-A
ENRENR-1199612026-04-28T09:44:28ZJenniferQ··Vezquez28-12-1950UHC-17096-95··•••-••-50622812764051JENNIFER.VAZQUEZ88@YAHOO.COM7536 SPRING STREET··GlendaleAZ85393-9049GRP-1066CHOICE-PLUS-PPO
ENRENR-1033792026-08-20T20:18:27Z ·Thomas—Fisher4/20/1970UHC-17387-81-3872317487··THOMAS.FISHER46@YAHOO.COM8770 Washington St·Eden PrairieMN55311GRP-8305NAVIGATE-HMO
ENRENR-1051002026-08-21T14:58:34ZKevinORios1971-10-18UHC-45153-34•••-••-4610+1 440 371 8098KEVIN.RIOS3@ICLOUD.COM3291 BROADWAYTempe··AZ85204GRP-5232MEDICARE-ADV-B
ENRENR-123677 2026-06-20T08:27:50ZhiroshiTlittle·1973-07-28UHC7381685•••-••-242912134738946hiroshi.little19@aol.com1360 RIVER RDAtlantaGA30305GRP-1002options-ppo
ENRENR-1426672026-05-07T04:16:41ZDiego—Lawrence1978-11-27UHC-74911-24•••-••-239718476469423diego.lawrence@outlook.com4864 River RoadDENVERco80200GRP-1840CHOICE-PLUS-PPO
ENRENR-1140352026-03-26T15:18:17ZMendezJGregory1948-05-01UHC-06732-77•••-••-3726+1 578 628 3318gregory.mendez@aol.com3310 Pine DrivePhoenixAZ85064GRP-2052CORE-HMO
ENRENR-1309472026-04-02T03:42:38ZOrtega, CarlosZ—May 15, 1985UHC-86655-27•••-••-1640—CARLOS.ORTEGA@YAHOO.COM·8554 HARBOR BOULEVARD·SacramentoCA95837GRP-7313MEDICARE-ADV-A··
ENRENR-1119652026-05-12T20:03:51ZJEREMY—WASHINGTON2007-06-13·UHC-82006-63•••-••-5309—jeremy.washington@icloud.com173 Bayshore DriveCharlotteNC28284GRP-8265OPTIONS-PPO
43,101 rows, page 103 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:37.740Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty