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-1146302026-01-20T00:33:09ZMaryLRiley1961-03-13UHC-59201-69•••-••-55885058560537··mary.riley90@gmail.com8780 Lincoln WayGilbertAZ85238GRP-2214CHOICE-PLUS-PPO
ENRENR-1362372026-06-23T12:27:19ZArthur····Anderson18-05-1938UHC-15121-56•••-••-17727597974036arthur.anderson65@yahoo.com8155 RIDGE RDNashvilleTN37217-0489GRP-4117SELECT-EPO
ENRENR-1391432026-04-06T14:20:21ZSamuelLDaniels1977-11-16UHC-29400-17•••-••-048118727770271·SAMUEL.DANIELS48@OUTLOOK.COM·8484 Meadow LnTampaFL—GRP-7152SELECT-EPO··
ENRENR-1204942026-06-29T15:50:58ZROGER—TAYLOR1969-05-02UHC-56496-62•••-••-4354(471) 372-4496·roger.taylor@yahoo.com586 Maple AveGilbertAZ85263··GRP-4302··MEDICARE-ADV-A
ENRENR-1093102026-07-14T19:35:24ZSARAH—BRYANT10/16/43UHC-10170-91•••-••-09357712815140sarah.bryant@icloud.com3900 Meadow LaneMesaAZ85253GRP-0680CHOICE-PLUS-PPO
ENRENR-1275382026-02-24T11:45:49Z keith···Bburke1994-12-20UHC-65252-24•••-••-0830484-661-9037keith.burke52@aol.com4190 SPRING ST·AUSTINTX··78711-2178GRP-8340MEDICARE-ADV-B
ENRENR-1149622026-10-02T23:56:11Z·Garza, Heather——1983-04-15UHC-85505-93•••-••-8505(627) 948-0819··heather.garza31@aol.com7382 BASELINE RDPhoenix·AZ85013GRP-9935··OPTIONS-PPO
ENRENR-1114312026-07-07T11:18:09Z·MARIANA··RUSSELL4/8/1975UHC-35952-60•••-••-68967172387587—9455 Ridge RdNashvilleTennessee··37277-6793GRP-6519OPTIONS-PPO
ENRENR-1275732026-02-07T15:38:31ZDaivd—·Powell27-04-2004UHC-50609-62•••-••-64289259741002DAVID.POWELL62@AOL.COM1225 Canyon RoadAustinTX—GRP-2688MEDICARE-ADV-A
ENRENR-1175242026-01-11T03:35:43Zjeremy—romeroNov 14, 1954UHC-73018-04··•••-••-2072346-787-1225jeremy.romero@icloud.com4322 BAYSHORE DRIVESacramentoCalifornia95834GRP-6699CORE-HMO
ENR ENR-1425712026-07-06T09:28:07ZRONALD··H.HARRISON04/25/1984UHC-20068-10•••-••-8533UNKNOWNRONALD.HARRISON@HOTMAIL.COM8832 Mountain View DriveSan DiegoCA92193GRP-5992SELECT-EPO
ENRENR-1030472026-04-22T06:33:58ZralphJarmstronng1951-09-05UHC-84017-34•••-••-9429—RALPH.ARMSTRONG87@OUTLOOK.COM7925 BroadwayTampa·FL33612GRP-1809NAVIGATE-HMO
ENRENR-1015472026-08-28T17:25:57Zlarry—nguyen20-11-1981UHC-47290-57•••-••-7097275-641-9448larry.nguyen@gmail.com7694 Jefferson AveOrlandoFL·32879GRP-4465MEDICARE-ADV-A
ENRENR-106905 2026-03-06T06:03:49ZKyle—Holmes2002-09-24—•••-••-5050369-868-5071kyle.holmes@yahoo.com8531 LAKE VIEW ROADLas VegasNV89171GRP-3893MEDICARE-ADV-A
ENRENR-1191832026-03-19T14:13:08ZChristianHBrown·19860921UHC-14944-66•••-••-24014298330214christian.brown79@outlook.com9487 Elm StPlanoTXnullGRP-2448MEDICARE-ADV-B
ENR ENR-1250042026-04-12T07:35:20ZVega····Christopher1941-07-27··UHC-23440-74N/AUNKNOWNchristopher.vega99@outlook.com··5400 Ocean AvenueColumbusOhio43205GRP-6451OPTIONS-PPO
ENRENR-1416892026-07-05T05:51:20ZMICHELLEOLE1978-11-05UHC-85105-06•••-••-3572804.431.7304—6244 Apache BoulevardAustinTX78746GRP-3458NAVIGATE-HMO
ENRENR-1137952026-05-11T13:27:49ZPhilipCRodriuez19530516UHC-24881-73-NULLN/A473 Washington StreetTempeArizona85247-6950··GRP-2123NAVIGATE-HMO
ENRENR-1155552026-01-28T06:43:03ZGloria—George0823-19-95—•••-••-6274316-666-7497GLORIA.GEORGE77@ICLOUD.COM9610 JEFFERSON AVEMinneapolisMN55413GRP-6530··SELECT-EPO
ENRENR-1181962026-05-24T01:10:06ZOLIVIA—KIM1957-10-21UHC-57051-45•••-••-1365(542) 585-9937olivia.kim@icloud.com7629 Bayshore DrTempeAZ85284GRP-8966MEDICARE-ADV-A
ENRENR-1413972026-07-25T20:44:50ZVictoriaYJimenez10/13/2004··UHC-81928-43•••-••-16224733961226victoria.jimenez46@proton.me4112 BASELINE RDSCOTTSDALEAZ··85275···GRP-4545CORE-HMO
ENRENR-1101882026-05-05T12:09:04ZJORDANNALLEN1950-04-10UHC-98523-56•••-••-6721292-944-7650N/A7388 MEADOW LN Apt 3ColumbusOH43212GRP-3415SELECT-EPO
ENRENR-1401882026-10-08T11:25:31Z ·ALAN··PERKINS1961-10-26··UHC-26524-01—4249629011ALAN.PERKINS@ICLOUD.COM3907 Desert Sky BoulevardEden PrairieMN55336GRP-0826CHOICE-PLUS-PPO
ENRENR-1136602026-07-30T04:06:05ZMari—Dunn··20060522UHC-02585-20•••-••-40947264525MARIA.DUNN71@ICLOUD.COM929 Union StreetDALLASTX75273GRP-2286NAVIGATE-HMO
ENRENR-1030522026-09-09T09:31:40ZBailey, Julia——19540506UHC-66212-73•••-••-7322(240) 929-4354julia.bailey38@aol.com9691 Church StCharlotteNorth Carolina28251GRP-7040NAVIGATE-HMO
ENRENR-1235572026-04-02T14:39:37ZJonathanVWang1997-08-12··uhc-87057-53•••-••-56706589890069jonathan.wang@yahoo.com5706 Indian School RoadJacksonvilleFL··32238GRP-6159MEDICARE-ADV-B
ENRENR-1153822026-03-29T06:33:13ZDENISEUREID2001-09-24UHC-33235-06•••-••-25095277088759DENISE.REID@AOL.COM9368 Union StLOS ANGELESCA90003GRP-4894navigate-hmo··
ENRENR-1113052026-01-15T12:40:01ZCHARLOTTE—OWENS19400225UHC-49048-55•••-••-54512747782087CHARLOTTE.OWENS36@ICLOUD.COM1858 Jefferson AveORLANDOFL32867GRP-8046SELECT-EPO
ENRENR-1150892026-10-09T09:37:26ZAmandaFMorris1994-05-17UHC-04270-36•••-••-4588+1 873 736 5875N/A6762 Pine DrColumbusOH43231GRP-6032NAVIGATE-HMO
ENRENR-1024842026-05-20T22:03:27Z·DanielUMendez03/19/84··UHC-44692-67•••-••-8740+1 911 455 2537daniel.mendez9@yahoo.com2559 JEFFERSON AVEGilbertAZ85299GRP-7329··CORE-HMO
ENRENR-1284152026-02-20T18:24:00ZArjunL.Hansen2001-05-27UHC-08942-86•••-••-7782748.854.9079ARJUN.HANSEN@YAHOO.COM4213 SPRING STMINNEAPOLISMN55428-6755GRP-7092··NAVIGATE-HMO
ENRENR-1041022026-09-15T05:46:01ZDiego—Daniels1953-10-13UHC-77752-86•••-••-9543(239) 357-9243DIEGO.DANIELS1@ICLOUD.COM3198 HIGHLAND AVEEDEN PRAIRIEMN55357-7785GRP-7755OPTIONS-PPO
ENRENR-117212 2026-08-14T04:05:58ZWEI—CHAPMAN1956-11-25UHC-75427-53—266-334-9024wei.chapman5@icloud.com606 Spring StreetTAMPAFL33619GRP-3683CHOICE-PLUS-PPO
ENRENR-1249312026-10-14T20:11:40ZRANDY—THOMPON1978-04-02uhc-53827-43•••-••-4711520-439-7747randy.thompson91@gmail.com5569 Oak StSeattleWA98151GRP-9348OPTIONS-PPO
ENRENR-1091892026-09-10T12:50:19Z Mendez, Judith——1952-03-15UHC8721170•••-••-329818339806245judith.mendez@hotmail.com4935 PINE DRAustinTX78774GRP-5470MEDICARE-ADV-A··
ENR ENR-1418932026-06-23T17:53:54ZCHRISTINAT.RUIZ··2005-02-21UHC-49090-52•••-••-9214367-224-4425NULL9270 Park Pl #467CHARLOTTENC28271GRP-6801NAVIGATE-HMO
ENRENR-1090752026-01-07T16:24:10ZDOROTHYS.NUNEZ16-01-1975UHC2758332•••-••-25637503396160dorothy.nunez@icloud.com5049 SPRING STREET Apt 28MinneapolisMN—·GRP-2968CHOICE-PLUS-PPO
ENRENR-1033862026-02-03T08:20:33ZGREGORYH.RICHARDSON04/11/60··UHC-32697-71NULL(290) 966-7947UNKNOWN1687 Palm Drive Apt 34Dallas··TX75271-5001GRP-3090CORE-HMO
ENRENR-1086592026-08-19T20:12:58Z DeniseTHenderson04/06/69UHC-14987-56•••-••-10675205008740DENISE.HENDERSON@PROTON.ME5931 JEFFERSON AVETampaFL33611GRP-3433OPTIONS-PPO
ENR ENR-1007912026-02-17T01:11:07ZJOSECPETERSON2007-07-18UHC-04323-58N/A424-761-0886jose.peterson@gmail.com6822 Baseline RdMesaAZ85247GRP-9365OPTIONS-PPO
ENRENR-1326732026-04-23T19:44:35ZralphQwright1942-07-13UHC-37104-79•••-••-9156(463) 481-7600RALPH.WRIGHT28@ICLOUD.COM9787 River RoadPhoenixAZ85064GRP-3227CHOICE-PLUS-PPO
ENRENR-1335912026-03-31T09:45:53ZMatthewRMedinaApr 15, 1968··UHC-49080-58UNKNOWN—·matthew.medina@gmail.com8294 GRAND AVEChandlerAZ·85250GRP-6250MEDICARE-ADV-A
ENR ENR-1242792026-07-29T16:11:26ZVICTORIAVMEYER12/15/1945UHC-86900-91UNKNOWN2702328115victoria.meyer@yahoo.com2182 Sunset BlvdLas VegasNV89175GRP-3701CORE-HMO
ENRENR-1144902026-06-20T06:38:53ZMARTHA—GOMEZMay 11, 1944UHC-87887-56•••-••-38394663797384—6080 Cedar LanePLANOTX75035GRP-8396MEDICARE-ADV-B
ENRENR-1419682026-08-27T06:34:18ZMatthew—Greene1950-01-01UHC-91766-10•••-••-11855744343927matthew.greene13@outlook.com2954 Willow CourtSeattleWA98128GRP-3082SELECT-EPO
ENRENR-1039222026-03-28T15:42:20ZMaartin, MasonM.—1938-09-20UHC-62733-27•••-••-2870(487) 791-1460MASON.MARTIN19@HOTMAIL.COM·8500 Apache BoulevardTUCSONAZ85718GRP-4013CORE-HMO
ENR ENR-1059132026-02-14T07:00:35ZJonathan··VCunningham1988-01-15UHC-32520-91•••-••-8456NULLjonathan.cunningham@proton.me8972 Union StMinneapolis··MN55470GRP-2576CORE-HMO
ENRENR-1349512026-03-20T06:40:38Z·AlexisU.Freeman1973-06-24UHC-97467-72•••-••-9785(258) 850-9352ALEXIS.FREEMAN3@GMAIL.COM5193 SAGE COURTMinneapolismn55433-6896GRP-8191·CORE-HMO
ENRENR-1077482026-02-21T20:16:23ZAISHAI.GRANT1988-08-19UHC-55008-70•••-••-9151567-420-1497aisha.grant25@outlook.com627 River RoadDENVERCO·80285GRP-4207NAVIGATE-HMO
ENRENR-141374 2026-07-31T17:06:17ZklyeN.gonzalez1940-12-07UHC-63081-75•••-••-8636860.617.2136KYLE.GONZALEZ35@AOL.COM7257 Highland AveLAS VEGASNV89149GRP-3133MEDICARE-ADV-B
43,101 rows, page 17 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:34.771Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty