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-1321102026-02-02T21:49:26ZASHLEYGPERYR1968-03-26UHC-37171-05•••-••-2991257.436.5078ashley.perry66@aol.com697 Park Place··FresnoCA93735GRP-3830MEDICARE-ADV-B
ENR ENR-1149662026-01-31T13:26:52ZWilliamson, Adam——21-08-1951UHC-78870-26•••-••-1356nullN/A2585 HARBOR BOULEVARDHoustonTX-·GRP-6135MEDICARE-ADV-A
ENRENR-1411302026-06-18T20:16:55ZbrandonZjohnson1987-01-18UHC-07574-46null228-724-9230brandon.johnson44@aol.com3554 PARK PLACETucsonAZ85738GRP-5984SELECT-EPO
ENRENR-1428852026-01-25T16:15:44ZBobby—Myers05/09/1956UHC-26951-75•••-••-5106+1 573 211 7958bobby.myers26@aol.com4441 MESA DRPhoenix·az·85041GRP-7596options-ppo
ENRENR-1358072026-10-12T13:49:30ZEUGENEJPATTERSON2000-12-14··UHC-13111-90•••-••-7074705-821-4243····7809 Meadow LaneMINNEAPOLISMN55488GRP-9289CHOICE-PLUS-PPO
ENRENR-1411572026-09-01T14:53:09Z DebraHMurray19561101UHC-12492-31•••-••-1922·13434769701·debra.murray58@hotmail.com2639 Market StLas VegasNV89105GRP-2244MEDICARE-ADV-B
ENRENR-1309762026-06-16T18:34:13ZChristine··—Wright03/17/55UHC-12937-89•••-••-3155+1 917 429 2664·christine.wright@outlook.com1177 Hillcrest RoadChandlerAZ85277·GRP-8871NAVIGATE-HMO
ENRENR-1331542026-04-20T07:21:15ZTomQMatthews2002-08-28UHC-58466-91•••-••-5888(847) 319-3831NULL8141 Mountain View DrMiamiFlorida··33161-8137GRP-6530OPTIONS-PPO
ENRENR-1059642026-06-02T23:42:30ZHiroshiEKelley··1950-10-21UHC-53774-63•••-••-5039669.364.8726hiroshi.kelley@outlook.com··2695 INDIAN SCHOOL RDPhoenixAZ85004GRP-7262NAVIGATE-HMO
ENRENR-1321642026-07-24T20:53:40Z HEATHER—MORENO1963-08-07uhc-49093-34•••-••-03848734612717NULL2841 Lake View RdSAN DIEGO··CA92191GRP-1493CHOICE-PLUS-PPO
ENR ENR-1033422026-09-13T22:24:24ZRied, PriyaI—8/4/1939UHC-91776-87•••-••-9197+1 916 620 5494priya.reid94@outlook.com8712 Pine DriveNashvilleTN37212GRP-4244SELECT-EPO
ENRENR-1158892026-05-17T03:58:37ZBradleyIArmstrong1938-10-22UHC-76772-44•••-••-62678344469237··N/A9526 Park PlMINNEAPOLISmn55429GRP-2430MEDICARE-ADV-B
ENRENR-1323732026-06-20T07:56:43ZCamla·QColeman1960-01-21··UHC-30287-02•••-••-4994(810) 571-0688··UNKNOWN2961 Cedar LnTampaFL33609GRP-2341CHOICE-PLUS-PPO··
ENR ENR-1106342026-08-07T07:48:51ZMARY—HUNTER03/07/1948UHC-79113-04•••-••-79467572556514MARY.HUNTER@ICLOUD.COM9548 Palm DrivePLANOTexas75001·GRP-1290OPTIONS-PPO
ENRENR-1189712026-06-28T21:32:26ZWalter—Andrews1962-06-20UHC2599064•••-••-2988972-595-0422walter.andrews@outlook.com7531 OCEAN AVENUEPhoenix·AZ85084GRP-2330·MEDICARE-ADV-A
ENRENR-1132242026-05-28T23:42:29ZLORI··N.AGUILAR12-07-1983UHC-63540-68•••-••-2176·19524124075LORI.AGUILAR15@HOTMAIL.COM1976 SPRING STCharlotteNC28204GRP-2735MEDICARE-ADV-A
ENRENR-1213712026-08-01T20:04:43ZBilly—Roberts·19880214UHC-36394-98NULL2534686789UNKNOWN5135 River RoadMiamiFL33105GRP-9941MEDICARE-ADV-B
ENRENR-1134592026-07-01T13:50:15ZSeanT·Moragn1991-10-17··UHC-68727-11•••-••-1695454-746-5363N/A3479 MAPLE AVENUECharlotteNC28278GRP-7995MEDICARE-ADV-A
ENRENR-1310542026-08-05T10:32:11ZJORDDAN—RICE09/13/1965UHC-17038-94•••-••-3876892-682-8107JORDAN.RICE@YAHOO.COM8671 FOREST AVESacramentoCA95866GRP-2804select-epo
ENRENR-1106302026-04-10T14:11:34ZVirginia—Lynch19501207·UHC-98901-48null·(953) 762-1544virginia.lynch51@yahoo.com2636 Ocean AvenueTucson··AZ85728GRP-1930SELECT-EPO
ENRENR-1218622026-04-29T12:38:13ZLORIS.GRAY2001-05-21UHC-53251-10•••-••-7585N/Alori.gray@hotmail.com5591 Valley View Dr··ColumbusOhio43240GRP-6352CHOICE-PLUS-PPO
ENRENR-1136272026-05-06T08:55:44Z·Terry····Sims1938-08-05UHC-54059-41•••-••-4609387-954-4581terry.sims@aol.com2868 Elm StreetPhoenixAZ85023GRP-3339MEDICARE-ADV-B
ENRENR-1174192026-07-05T04:16:01Z·PamelaG.StephensDec 1, 1945UHC-17231-54NULL2657612pamela.stephens@outlook.com4386 VALLEY VIEW DRIVEMesaAZ85263GRP-3995MEDICARE-ADV-B
ENRENR-1333202026-02-03T00:19:55ZLauraYArmstrong19940610UHC-22568-88•••-••-4422+1 315 423 0269laura.armstrong8@yahoo.com6025 HIGHLAND AVEAtlantaGeorgia30304GRP-3391NAVIGATE-HMO
ENRENR-1082902026-09-28T21:21:56ZSANTIAGO—OLIVER09/27/01UHC-67432-85•••-••-20577523633157··santiago.oliver@icloud.com·2408 CHURCH STREETOrlandoFL32861GRP-1948NAVIGATE-HMO
ENRENR-1326672026-09-24T05:27:16ZSantiago—Johnston11/15/1984UHC-34055-28•••-••-098914182415755··—5722 Spring StreetHoustonTX77026GRP-8281SELECT-EPO
ENRENR-119432 2026-01-02T21:21:35ZWillie—McCoy0123-19-94UHC-22083-44•••-••-302318759847359willie.mccoy60@icloud.com1428 Cedar Lane·FresnoCA93781GRP-6624CHOICE-PLUS-PPO
ENRENR-1001832026-02-15T00:30:41ZRussell, Paul··——04-05-1988UHC5572601•••-••-9551·829-985-0964NULL6403 MOUNTAIN VIEW DRCHANDLERArizona85264GRP-7583SELECT-EPO
ENRENR-1159172026-10-16T04:51:11ZKyle—Harvey27-10-1976UHC-55261-28•••-••-7009·890-427-1769N/A4135 Sage CtSan DiegoCA92196GRP-2967MEDICARE-ADV-A
ENRENR-1330372026-04-17T16:34:04ZBRUCE—PENA1968-03-16UHC7359043•••-••-5903(352) 505-2598bruce.pena@outlook.com6188 River RoadOrlandoFL32805GRP-6658navigate-hmo
ENRENR-1264732026-03-07T11:23:11ZAshleySPark··25-03-1984UHC-77999-99•••-••-74227803178563ashley.park@icloud.com5422 MEADOW LANEMiamiFL33129GRP-6725··CHOICE-PLUS-PPO
ENRENR-1424892026-02-10T19:39:12ZjesseIdaniels1960-11-24UHC-34721-77•••-••-7573(698) 758-2646jesse.daniels27@hotmail.com5751 Elm StreetCharlotteNorth Carolina28238GRP-6093MEDICARE-ADV-A
ENRENR-1293152026-08-19T09:12:16ZRalphYHernandez19400212·UHC-51614-38•••-••-60966264102912ralph.hernandez@aol.com·5088 Main StGilbertAZ85202GRP-7704NAVIGATE-HMO
ENRENR-1402932026-05-03T06:21:27ZJoeJBunrs23-07-1976UHC-31348-39•••-••-5627792-551-3088joe.burns@aol.com7709 Washington StCharlotteNC28247GRP-3334NAVIGATE-HMO
ENRENR-1191762026-06-05T09:34:51ZCarl—Torres2000-05-16UHC-32777-46•••-••-39385384666941—8732 Lake View Rd·GlendaleAZ85342GRP-5846MEDICARE-ADV-B
ENRENR-1230642026-06-21T16:04:48ZJUSTIN··J.REYES1963-09-22UHC-24118-86•••-••-8876669-508-5307NULL4889 Spring StGLENDALEAZ85337·GRP-2977MEDICARE-ADV-B
ENRENR-1421682026-08-15T18:22:41Zmateo—coleman1985-03-04UHC-67652-54··•••-••-7779(449) 468-0986····2214 Central AvenueSacramentoCalifornia·95826GRP-2841··MEDICARE-ADV-A
ENRENR-1330842026-09-24T17:47:43ZvictoriaFgaham12/7/1970UHC-64777-70•••-••-7960(440) 661-0192victoria.graham24@aol.com2255 Cedar LnLas VegasNevada89185GRP-9503SELECT-EPO
ENRENR-1216012026-05-22T03:04:27ZBrenda—Vazquez1994-10-21UHC-38454-59•••-••-5175(978) 419-1947brenda.vazquez@outlook.com·3530 MESA DRIVEFresnoCA93743··GRP-7078core-hmo
ENRENR-1045812026-06-05T11:56:10ZHIROZHI—BAKERAug 14, 1960UHC-46757-39•••-••-71668125123574hiroshi.baker41@outlook.com2396 Hillcrest RdScottsdaleAZ85236GRP-6951SELECT-EPO
ENRENR-1147402026-07-03T17:14:37ZGabriel—Castillo1990-10-01··UHC-46808-96•••-••-9105·396.884.1043gabriel.castillo@proton.me1163 Church St Apt 2PlanoTX75066GRP-7105SELECT-EPO··
ENRENR-1259932026-06-03T13:41:52Z TeresaB.Alvarado··1963-04-16UHC-66432-05•••-••-9070·389-455-1467TERESA.ALVARADO@OUTLOOK.COM7002 Baseline RoadSan Diego··CA··92115GRP-8022NAVIGATE-HMO
ENRENR-1285982026-03-12T20:37:29ZOLIVIA—POWELL1960-07-13UHC-19972-86null481.612.5549-·3983 Bayshore DriveColumbusOhio43273GRP-7389NAVIGATE-HMO
ENRENR-1147842026-01-23T01:34:07ZmargaretZcarpenter··2007-05-05UHC-35414-22··•••-••-3008·890-799-6366·MARGARET.CARPENTER@HOTMAIL.COM9174 Sunset BlvdFRESNOCA93792GRP-9971OPTIONS-PPO
ENRENR-1314062026-07-26T09:31:58ZCarol··Montgomery1967-12-22UHC-63807-77•••-••-96614278898043null793 WASHINGTON STREETAUSTINTX78703·GRP-1373CHOICE-PLUS-PPO
ENRENR-1242732026-09-03T20:51:33ZSOPHIAI.MUNOZ··1980-02-11—•••-••-805812096952786sophia.munoz@icloud.com3607 Mountain View Drive·ChandlerAZ85248GRP-3407choice-plus-ppo
ENRENR-1166962026-04-21T18:17:57ZSanders··Harold1940-10-09UHC-74566-82•••-••-99263062979389HAROLD.SANDERS@OUTLOOK.COM—N/A—····GRP-9609NAVIGATE-HMO
ENRENR-1244872026-09-03T10:40:42ZNICHOLASACHAPMAN1942-02-14·UHC-21609-61•••-••-8537UNKNOWNNICHOLAS.CHAPMAN55@GMAIL.COM9582 Sage CtPhoenixArizona85080GRP-9292CORE-HMO
ENRENR-1008602026-03-28T06:11:37ZYukiE.Berry·1/2/1953UHC-79256-52•••-••-2316(973) 446-8767N/A5752 LINCOLN WAYAtlantaGA-GRP-2907CHOICE-PLUS-PPO
ENRENR-1257472026-06-15T13:39:21ZZACHARY—EVANS09/27/88·UHC-63508-30•••-••-9728434.414.2493zachary.evans@outlook.com724 Forest AveScottsdaleAZ85265GRP-7811MEDICARE-ADV-B
43,101 rows, page 321 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.615Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty