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-1001652026-07-30T20:38:05ZSAMUELAREYES19420926UHC-96397-53•••-••-4522-samuel.reyes@gmail.com·7713 Park PlaceEDEN PRAIRIEMNnullGRP-3770CORE-HMO
ENR ENR-1246472026-03-19T20:32:12ZVasquez, Abigail——1956-07-25UHC-24730-66•••-••-6494(517) 425-0119—8456 Ocean Avenue #272DallasTX75211-4878GRP-1498MEDICARE-ADV-A
ENRENR-1356242026-02-24T17:18:05ZRonald—Bennett··1988-11-01UHC-78608-57•••-••-8621(568) 489-9375ronald.bennett28@outlook.com3179 CAMELBACK RDFresnoCA93794GRP-2850OPTIONS-PPO
ENRENR-1402192026-01-17T01:31:46ZHicks, Edward——1989-04-06·UHC-50339-17•••-••-4861654-548-4363NULL3192 MESA DRCOLUMBUSOHN/AGRP-4342··NAVIGATE-HMO
ENRENR-1245942026-10-08T00:22:36ZsamJoliver1968-03-01UHC-41801-41•••-••-5021N/ASAMUEL.OLIVER@HOTMAIL.COM·3743 Church StreetHoustonTexas77089··GRP-7258CORE-HMO
ENRENR-1423632026-01-10T04:17:29ZDbera··Duncan1963-00-37UHC-31605-54—482-721-6842—5984 Canyon Road··AtlantaGA30368GRP-9465MEDICARE-ADV-A
ENRENR-1367542026-05-10T09:51:25ZCarl—Russell1970-11-28UHC-40882-68•••-••-21889883728663carl.russell@proton.me3970 Palm DrDallasTX75204GRP-1920OPTIONS-PPO··
ENRENR-1158122026-04-25T14:47:05ZLAUREN—OLSNO1990-03-18UHC2168125•••-••-6585(644) 276-1521lauren.olson63@proton.me3523 INDIAN SCHOOL ROADJacksonvilleFlorida32260GRP-8968OPTIONS-PPO
ENRENR-1099232026-03-19T16:53:49Z·FRANCESEROBINSON1992-08-27UHC-20083-97•••-••-9229—FRANCES.ROBINSON54@ICLOUD.COM1758 Ridge RdAustinTX78773··GRP-4061CORE-HMO
ENRENR-1367982026-06-27T11:37:32ZcarlosSclark2005-07-27UHC-76628-32N/A921-886-6975CARLOS.CLARK@GMAIL.COM8641 Maple Ave Apt 36DenverCO80230GRP-4390MEDICARE-ADV-B
ENR ENR-1102502026-01-26T15:09:40ZjesseHmccoy1975-02-20UHC-92772-95··•••-••-29039342804051JESSE.MCCOY69@AOL.COM7398 Oak StreetCHARLOTTE··North Carolina28246GRP-6383OPTIONS-PPO
ENRENR-1414922026-05-25T17:02:51ZHiroshi C—Marshall1984-03-07··UHC-00465-86NULL7419837417UNKNOWN6890 Park PlaceEden PrairieMN55388GRP-2899MEDICARE-ADV-A
ENRENR-1290732026-07-27T14:02:43ZMARIANA··—FRANKLIN1954-12-15UHC-03542-90NULL813-506-3873MARIANA.FRANKLIN@HOTMAIL.COM4917 Oak StreetGlendaleAZ85365GRP-9039CHOICE-PLUS-PPO
ENRENR-1196602026-07-16T11:43:50ZdonaldM·riley2004-07-23UHC-81912-39··•••-••-2550311.663.9829null5391 PALM DRIVEEden Prairiemn55397GRP-2146OPTIONS-PPO
ENRENR-1031532026-09-19T07:15:23ZStevenBCooper··15-01-1985UHC-31544-31•••-••-1659696.903.4875-1196 Grand AvePlanoTX75050GRP-9212MEDICARE-ADV-B
ENRENR-1108072026-03-10T17:49:26Zkathleen—wganer17-12-1990UHC-97845-16•••-••-795517716306860··KATHLEEN.WAGNER@PROTON.ME9711 Spring Street #709Tampa··FL33653-0931GRP-1253CORE-HMO
ENRENR-1325902026-06-21T17:19:26ZNOAHPALLEN6/27/1981UHC-20780-46—(371) 545-8593noah.allen58@outlook.com2225 Market StreetSAN DIEGOCalifornia92187GRP-2493NAVIGATE-HMO
ENRENR-1359892026-04-14T00:05:57Zwilliam—rodriguez1997-06-02UHC9562722•••-••-1700(481) 340-0407WILLIAM.RODRIGUEZ27@OUTLOOK.COM4328 Willow CtScottsdaleAZ85205·GRP-6583CORE-HMO
ENRENR-1030862026-04-06T21:40:45ZAnnRHarris1985-01-28UHC-15134-26•••-••-30135869920894ann.harris75@gmail.com2557 Willow CtDALLASTX75206GRP-1744OPTIONS-PPO
ENRENR-1291102026-05-17T19:32:17ZAARON—·COLEMAN1950-11-02UHC-13209-74•••-••-1501+1 468 471 6438aaron.coleman18@proton.me5871 Forest AveLas VegasNevada89192GRP-4692MEDICARE-ADV-B
ENRENR-1382032026-02-18T05:08:32ZRogerJLawrence28-10-1963UHC-53970-06··•••-••-8119(371) 357-4526roger.lawrence@aol.com305 Pine DriveLas VegasNV89108GRP-4409CHOICE-PLUS-PPO
ENRENR-1053762026-05-03T22:26:11ZEmilyXJenkins17-03-2001UHC-79681-97•••-••-74988436494979NULL7216 CANYON ROADAUSTINTX78700GRP-6247CHOICE-PLUS-PPO
ENRENR-1039932026-07-06T02:49:02ZChavez, Gregory··——1968-05-15UHC-38992-27•••-••-5102(627) 520-8019—7768 Elm StreetColumbusOH43258-8997GRP-7697NAVIGATE-HMO
ENRENR-1321192026-05-05T23:31:48ZannCwhite06/19/1957UHC9555194•••-••-3799(977) 654-6532—159 Hillcrest RoadNashvilleTN37295GRP-1580MEDICARE-ADV-A
ENR ENR-1176352026-03-30T09:38:23Zdianne—martin1970-07-05UHC-70579-10•••-••-1802(779) 815-6909-1379 Market St··MinneapolisMinnesota··55407GRP-4684MEDICARE-ADV-B··
ENRENR-1259332026-02-11T13:22:01ZDEBRA—STEVENS19620225UHC-01935-34—19022950199DEBRA.STEVENS@GMAIL.COM··2374 CEDAR LNPhoenixAZ85009GRP-2744MEDICARE-ADV-B
ENRENR-1107112026-02-28T17:30:52ZDanielRMeyer1946-12-24-null353-430-4050daniel.meyer@outlook.com2902 Oak StTUCSONAZ85705GRP-8332MEDICARE-ADV-A
ENRENR-1149762026-07-11T03:24:56ZMateo—Medina03/15/50UHC-80796-72··N/A+1 774 953 0209MATEO.MEDINA@AOL.COM5639 Willow CourtSACRAMENTOCalifornia95805GRP-7214CHOICE-PLUS-PPO
ENRENR-1201682026-06-07T01:24:43ZMarcus—Fisher1994-01-18uhc-86068-78•••-••-113019729750546—6193 Ridge RoadMinneapolisMN55458GRP-3247NAVIGATE-HMO
ENRENR-1389292026-07-11T06:15:13ZRachelU.Baker2006-10-24UHC-32037-03··•••-••-5710(732) 751-1313UNKNOWN4703 Ocean AveTucson·AZ85707GRP-1941CORE-HMO··
ENRENR-1248322026-05-10T10:00:44ZArthrWGreene6/27/1988UHC-95001-21•••-••-35459006830550arthur.greene@aol.com5078 Indian School RdMiamiFL33106GRP-8932MEDICARE-ADV-A
ENRENR-1213182026-03-18T00:23:23ZBrooks, StevenO.—1991-05-11UHC-72425-74•••-••-2314+1 353 498 0855·-6614 Camelback Road·TampaFLnullGRP-5556OPTIONS-PPO
ENRENR-1392742026-09-27T03:52:38ZnoahL.lee1962-08-09UHC-69395-54•••-••-4404406-892-3941null4182 River RdMinneapolisMN55471GRP-1417CORE-HMO
ENRENR-1260882026-03-27T22:59:47ZLinda—MartinSep 27, 2006UHC-16338-39•••-••-9986+1 466 723 9904N/A··1063 Union StreetDALLASTexas75262GRP-1833MEDICARE-ADV-B
ENRENR-1255122026-03-11T06:05:22ZAhmedOMendez1973-10-11UHC-82391-46•••-••-2040951-915-5498ahmed.mendez51@outlook.com9108 MARKET STREETTucsonAZ85713GRP-0221CORE-HMO
ENRENR-1104392026-05-18T12:24:39ZRandyLMurphy1944-02-26UHC-31162-50•••-••-2250+1 849 661 4340randy.murphy@outlook.com243 Central AvenueCHARLOTTENorth Carolina28250GRP-1374SELECT-EPO
ENRENR-1349832026-09-09T18:22:22ZCamilaJ·Garrett05-02-1944UHC-62745-81•••-••-8570(462) 277-7860camila.garrett78@hotmail.com5393 JEFFERSON AVENUEScottsdaleAZ85226GRP-0270NAVIGATE-HMO
ENRENR-1316282026-07-23T19:13:06Z AISHA—HARVEY1979-02-02·UHC-39601-09•••-••-4763229-298-8233·AISHA.HARVEY@YAHOO.COM4208 Main StreetDallasTexas75211-0731GRP-4357NAVIGATE-HMO
ENRENR-1367932026-04-16T11:52:39ZJoyceMRamirez1983-06-25UHC-92711-12•••-••-5972825-837-3093—5983 PARK PLACEORLANDOfl32899GRP-8380SELECT-EPO
ENRENR-1064352026-06-26T10:56:05ZnancyWestrada03/22/76UHC-01826-54•••-••-2102791-636-5612··nancy.estrada@gmail.com7743 Oak StPhoenixAZ85092··GRP-0684MEDICARE-ADV-A
ENRENR-1240662026-03-15T01:51:05ZBILLYK.GARDNER12/14/91UHC-78599-36•••-••-0191395.881.6545—4565 Ocean AvenueSan AntonioTexas78286-2432GRP-8544··CHOICE-PLUS-PPO
ENRENR-1106332026-02-08T22:17:10ZEvans, Kelly——1967-07-23UHC-44014-05•••-••-7237323-490-3918KELLY.EVANS@OUTLOOK.COM4597 Sunset BlvdHoustonTexas77093GRP-9915··CHOICE-PLUS-PPO
ENRENR-1283312026-03-22T07:15:36Z WillieBWang05-12-1997·UHC-59116-79•••-••-01797644344853willie.wang61@yahoo.com4236 Washington StreetEden PrairieMN55390GRP-9877MEDICARE-ADV-A
ENRENR-1032982026-03-09T22:29:54ZAndrew—Cox1987-11-22UHC5318013•••-••-7196(856) 262-8295·andrew.cox@proton.me830 Sunset Boulevard Apt 18MiamiFL33189GRP-4645NAVIGATE-HMO
ENRENR-1327852026-07-13T07:26:24ZWilliams, Elijah··X—10/23/1959UHC-93427-23•••-••-0416(593) 326-0049ELIJAH.WILLIAMS62@PROTON.ME6333 HARBOR BLVDSEATTLEWAnullGRP-1912CORE-HMO
ENRENR-1405352026-01-14T23:08:37ZBOYD····SARANov 16, 1989UHC-00830-94•••-••-5591(882) 835-6136—3848 Bayshore DriveLas Vegas·Nevada89101GRP-8573MEDICARE-ADV-A
ENRENR-1420052026-03-05T11:55:36Z HeatherL··Stone1945-02-20UHC-64928-06•••-••-270613208411813heather.stone@outlook.com2130 Mesa DrJacksonvilleFL32213GRP-4456CHOICE-PLUS-PPO··
ENRENR-1157412026-06-30T19:59:57ZSophiaS.Vasquez19471215UHC-21463-60•••-••-9036-—5478 Canyon Road Apt 20··TUCSONArizona85761GRP-1080MEDICARE-ADV-A
ENRENR-1316182026-02-21T09:47:48ZTeresaY.Murphy···10/09/1967UHC7293967•••-••-4548(318) 223-6218null4268 BROADWAYMesaArizona85269GRP-8031NAVIGATE-HMO
ENR ENR-1404672026-02-17T14:15:47ZBRITTANYE.··WELLS2001-01-14UHC-87523-64•••-••-4574UNKNOWNBRITTANY.WELLS38@HOTMAIL.COM1690 Jefferson AvenueAustinTX78737GRP-8307OPTIONS-PPO
43,101 rows, page 208 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.349Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty