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-1211822026-08-24T15:45:48ZRyan—Elliott1962-07-01UHC-67565-38•••-••-62128323083910ryan.elliott37@gmail.com5526 SUNSET BOULEVARDSan AntonioTX·78260·GRP-1983NAVIGATE-HMO
ENRENR-106083 2026-01-09T04:49:10ZBRUCE—MATTHEWS··1948-10-15UHC-70940-82•••-••-1491356.487.8906·bruce.matthews@hotmail.com9500 CHURCH STEden PrairieMN55362-3815GRP-1365CORE-HMO··
ENR ENR-1158392026-01-25T15:18:49ZRebeccca—Greene2006-05-05UHC-66153-41•••-••-604719829880967rebecca.greene@gmail.com3070 Palm Dr #726TampaFL33694GRP-7708NAVIGATE-HMO
ENRENR-1099042026-03-17T13:41:21ZMelissa—Valdez1954-02-10UHC-81960-04•••-••-71536816351928melissa.valdez@aol.com962 Valley View Dr·DALLASTX—GRP-9413NAVIGATE-HMO
ENRENR-1075012026-01-25T02:59:25ZDanielleGOliver07/21/55UHC-04683-72•••-••-3658—N/A2802 Grand AvenueChandlerAZ85297GRP-9310MEDICARE-ADV-A
ENRENR-1090042026-03-11T01:19:48Zjack—woood19980714UHC-01115-94•••-••-4238841-791-1610john.wood@icloud.com5326 Jefferson AvenueSacramentoCA··95836GRP-5041CORE-HMO
ENRENR-1207772026-04-07T10:37:04ZHiroshiLMcDonald07/08/1991UHC-32228-83UNKNOWN9036515984UNKNOWN8785 Harbor Boulevard·CharlotteNC28219GRP-7493SELECT-EPO
ENRENR-1183812026-03-10T18:54:40ZJOANA.ALVARADO07/21/1946UHC0008763•••-••-0172—joan.alvarado@yahoo.com··8314 Forest AveMiamiFL33182GRP-2571CORE-HMO
ENRENR-132309 2026-03-12T09:37:41ZMASONK.RAYNOLDS1964-05-27UHC-47917-80•••-••-7151(847) 252-4049mason.reynolds94@proton.me4475 Indian School RoadCharlotteNC28276GRP-9656MEDICARE-ADV-B
ENRENR-132638 2026-05-02T03:47:15Zjoseph—contreras1980-06-14UHC-21100-34•••-••-4560nullJOSEPH.CONTRERAS21@AOL.COM5165 Lincoln WayTampaFL33637GRP-0294OPTIONS-PPO
ENRENR-1126712026-03-14T10:03:03ZLarryYMoore17-07-1979UHC-67568-05•••-••-2779·(636) 534-2508-··399 SAGE COURTSacramentoCA95808GRP-5705CHOICE-PLUS-PPO
ENRENR-1137322026-03-12T06:48:49ZWarren, CharlotteO—12/28/1953UHC-20880-69•••-••-9775864-227-8000charlotte.warren31@proton.me3458 Bayshore DrAustinTX78787GRP-0548MEDICARE-ADV-B
ENRENR-112187 2026-08-22T16:47:43ZARJNUR···ELLIOTT06/07/97UHC-67426-37•••-••-5003579-759-3513ARJUN.ELLIOTT19@AOL.COM6148 Grand AveTAMPAFL33654GRP-3111MEDICARE-ADV-B
ENRENR-1423072026-10-18T05:28:01ZmaldonadoN.john··1986-12-10UHC-85261-86•••-••-620716539165680john.maldonado@hotmail.com4068 PINE DRIVENashvilleTN37278··GRP-0242··SELECT-EPO
ENRENR-1188612026-01-09T02:38:33ZPeters, Gregory——11-04-1955UHC-87115-20•••-••-5354·8178711426gregory.peters@gmail.com··2462 Oak StDallas··TX75200GRP-4796CHOICE-PLUS-PPO··
ENRENR-1160342026-05-04T16:36:50ZalexanderGcox1944-02-13UHC-07045-62•••-••-2518656.987.8367null760 Harbor BlvdORLANDOFL32854GRP-9974OPTIONS-PPO
ENRENR-1076062026-09-03T06:47:52ZDORISLROBERTSON1951-03-03UHC-59682-46•••-••-4230(626) 817-3802doris.robertson@gmail.com1581 Canyon RdHoustonTX··77097GRP-9192·OPTIONS-PPO
ENRENR-1051502026-07-08T15:40:15ZLarryMWelch21-04-2003UHC-16931-54NULLUNKNOWNLARRY.WELCH@HOTMAIL.COM··108 Sunset BlvdATLANTAGA30383GRP-2574MEDICARE-ADV-B
ENRENR-1321182026-07-16T14:29:12ZANNCWHITE06/19/1957UHC-95551-94•••-••-3799977-654-6532ann.white58@gmail.com159 Hillcrest Road Apt 19NashvilleTN·37295GRP-1580MEDICARE-ADV-A
ENRENR-1378612026-10-18T01:55:28Z Johnson, Susan——19450824UHC-21063-76•••-••-4189+1 617 797 0823susan.johnson15@gmail.com8153 Mesa DrGilbertAZ85275GRP-5582SELECT-EPO
ENRENR-1225502026-09-01T02:34:47ZWest, Jesse——1991-03-21UHC-94829-66•••-••-39833066856455jesse.west31@icloud.com7491 Union Street Apt 28Eden PrairieMN55365GRP-4876SELECT-EPO
ENR ENR-1326812026-06-28T03:23:08ZKaren··—·James2001-11-21UHC7006336UNKNOWN329-597-1449KAREN.JAMES@YAHOO.COM2189 Apache BoulevardLas VegasNV—GRP-4108OPTIONS-PPO
ENRENR-1225512026-08-23T17:15:10ZJESSEZWEST1991-03-21UHC-94829-66•••-••-39833066856455jesse.west31@icloud.com7491 Union StreetEden Prairiemn55365GRP-4876SELECT-EPO
ENRENR-1279512026-03-10T19:43:12ZMartha—Silva10/03/99UHC-10223-53•••-••-52984559877433null313 Main Street·Chandler·AZ85257GRP-2564SELECT-EPO
ENRENR-1274092026-03-15T10:41:05ZJeremy··Y.Barnes02/13/88UHC-66920-30•••-••-8810207-248-1591jeremy.barnes@proton.me3426 Market StSAN ANTONIOTX78238GRP-3096OPTIONS-PPO
ENRENR-1194162026-09-11T04:44:19ZBrendaH.Singh1973-12-05UHC-47269-68N/A268-437-8600brenda.singh@proton.me1625 Lake View RdSeattleWashington98123GRP-6353MEDICARE-ADV-B
ENRENR-1153912026-08-30T09:10:43ZTERRY—BLACK1992-02-25NULL•••-••-1034479-581-8032TERRY.BLACK@PROTON.ME7291 Ridge RoadScottsdaleAZ85208GRP-2117NAVIGATE-HMO
ENRENR-1259082026-02-21T18:46:16ZScott·H.Burke1/6/2004UHC-82744-03•••-••-602312824460983N/A1246 Oak StOrlando·FL32872GRP-2092core-hmo
ENRENR-1199222026-06-15T21:46:14ZJULIA····SPENCER1942-06-04UHC-17070-94•••-••-37303426878437··julia.spencer@hotmail.com1651 Market StOrlandoFL·32862GRP-6751MEDICARE-ADV-B
ENRENR-1173692026-09-10T08:10:54ZcharlotteFthomas1985-04-14UHC-46370-05•••-••-09789346024650·charlotte.thomas@gmail.com8922 Spring StreetMesaAZ·85232GRP-4424NAVIGATE-HMO
ENRENR-1373282026-09-23T23:41:54ZAlexander··—Kennedy1962-10-17-•••-••-1532281.866.8900UNKNOWN5630 Forest AveMiamiFlorida—GRP-9959CORE-HMO
ENRENR-1327842026-08-18T08:53:25ZDorothyN.Fuller2/22/1964UHC-65646-39•••-••-01198747096081DOROTHY.FULLER@PROTON.ME3120 UNION STTempeAZ85215··GRP-3576·options-ppo
ENR ENR-1256802026-02-04T15:10:53ZMatthewKKelley·1954-01-02UHC-67263-62—(229) 560-4446matthew.kelley81@aol.com3860 OCEAN AVENUEHoustonTX77011GRP-1475CHOICE-PLUS-PPO
ENRENR-1102632026-10-15T02:20:42ZAmyWPark06/17/81UHC8105731•••-••-6357342-640-6071-·7336 Camelback Rd Apt 11FresnoCA93761GRP-4967navigate-hmo··
ENRENR-1220912026-01-19T19:25:45ZLawrence, DoneldI—05/14/1979UHC-21826-52•••-••-9319460-556-2218·donald.lawrence@gmail.com2558 Cedar LaneLos Angelesca90035GRP-7426CORE-HMO
ENRENR-1158022026-04-13T09:58:07ZAustin—Jordan1939-04-22UHC-48339-03•••-••-207613613331175austin.jordan@gmail.com1593 Market StJacksonvilleFL·32248GRP-3130navigate-hmo
ENRENR-1284762026-05-28T10:09:08ZLORIK.SOTO1956-09-26UHC-93373-56•••-••-7638777.997.7989—9248 Harbor BoulevardTampaFlorida33669GRP-6674SELECT-EPO
ENRENR-1240212026-09-10T09:12:55ZJeffrey—Garrett01/04/1938UHC-19175-98•••-••-8693—jeffrey.garrett76@proton.me1295 SAGE CTChandlerAZ85250GRP-3536SELECT-EPO
ENRENR-1369912026-01-14T10:07:39Z Andrea—·Reyes2030-05-22UNKNOWN··•••-••-2067(659) 377-1365—5494 Church St··TampaFL33666-6862GRP-3320OPTIONS-PPO
ENRENR-1183862026-05-14T10:46:24ZSaraVSimmoonsAug 21, 1954UHC-20159-13··UNKNOWN5439171418UNKNOWN5499 GRAND AVEPLANOTX75073··GRP-8836SELECT-EPO
ENRENR-1057342026-09-10T06:26:09Zbrenda—singh··1998-10-19UHC-87927-23•••-••-6094(436) 890-1966brenda.singh@proton.me7889 UNION STREETSeattleWA98138-4175GRP-1775MEDICARE-ADV-A
ENRENR-1172192026-05-16T18:56:12ZBeckyRFuler1952-05-22·UHC-12980-59—(610) 362-1757REBECCA.FULLER36@OUTLOOK.COM1662 Mesa DriveEDEN PRAIRIEMN55399-4845GRP-3375·CORE-HMO
ENRENR-1211932026-02-13T10:30:18ZDENNY·OMURPHY1954-07-21UHC-42387-26UNKNOWN+1 386 317 0909DENNIS.MURPHY69@ICLOUD.COM3786 Union St #286SeattleWA98106GRP-2323MEDICARE-ADV-A
ENRENR-1278112026-09-22T17:58:46ZKim, Don——09/21/1969UNKNOWN•••-••-6771+1 213 366 8529—4188 Hillcrest RdGilbertAZ85266GRP-8310NAVIGATE-HMO
ENRENR-1399142026-07-30T06:22:00ZJOSHUANBRADLEY1999-10-16UHC-95937-31•••-••-4884682-340-6978·-3257 Park PlFresno·CA93769GRP-3637··choice-plus-ppo
ENRENR-1320422026-07-02T06:03:51ZSTEPHANIEP.FOX1997-11-07UHC-45072-32•••-••-5057(652) 774-9017NULL·6164 Central AveTAMPAfl33652GRP-8183OPTIONS-PPO
ENRENR-1126612026-03-02T16:52:18ZBRADLEY—WILLIAMS1983-10-13UHC1727910•••-••-5689870.452.9068-6914 Desert Sky BoulevardColumbus··OH43232GRP-4561select-epo
ENRENR-1327252026-10-02T22:18:20ZBRYAN—HOLMES2010-07-09uhc-32802-07•••-••-7992(685) 204-8159bryan.holmes@outlook.com4649 BROADWAYSeattleWashington98139GRP-2075MEDICARE-ADV-B
ENRENR-1325542026-02-18T03:37:28ZMelissa·F.Wright1980-07-07·UHC-65821-75•••-••-3253·(777) 729-9307melissa.wright@gmail.com8672 SAGE CT Apt 22TEMPEAZ85219GRP-3767··MEDICARE-ADV-B
ENRENR-1037262026-05-03T18:10:44Z EMILYCROBERTSON19470802UHC-80611-21•••-••-166515042978872EMILY.ROBERTSON@HOTMAIL.COM·5836 Union StMinneapolisMN55491GRP-9398NAVIGATE-HMO
43,101 rows, page 301 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.463Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty