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-1145252026-06-05T04:06:09ZBetty—Cawford2007-09-01UHC-84431-58•••-••-30333619209883betty.crawford43@aol.com6746 BASELINE ROADSACRAMENTOCA-GRP-2144CORE-HMO
ENRENR-1255522026-07-31T18:27:38ZDORISKFERNANDEZ20030204UHC9836955•••-••-9642248-509-1224··doris.fernandez71@icloud.com5596 Bayshore DrJacksonvilleFL32268··GRP-9789CORE-HMO
ENRENR-1068682026-05-09T13:50:57Z·DorothyKMoreno6/7/1944UHC-95806-45•••-••-6095+1 803 365 8210—UNKNOWN——N/AGRP-3874CORE-HMO
ENRENR-1198892026-08-03T17:15:47ZMARIANMOTGOMERY7/3/1962UHC-29751-78•••-••-3932—maria.montgomery16@aol.com·1044 RIDGE RDPhoenixaz85096GRP-0111medicare-adv-b
ENRENR-1417282026-09-30T08:06:10ZNathan—Day03/20/04UHC-18540-15•••-••-6916614-562-5518·nathan.day88@hotmail.com4425 BROADWAYDallasTX75238GRP-1257NAVIGATE-HMO
ENRENR-1307962026-08-13T20:14:54ZANN··—LAWRENCE1993-12-14UHC-40605-61•••-••-4426NULLann.lawrence69@aol.com8405 Apache BoulevardMiamifl—GRP-4223SELECT-EPO
ENRENR-1208922026-03-04T05:12:34ZJULIEZ··FERNANDEZ1941-10-24UHC-13018-79•••-••-9996—julie.fernandez84@yahoo.com6804 Harbor BoulevardChandler·AZ85295··GRP-6753SELECT-EPO
ENRENR-1046592026-03-11T03:46:27ZLuisWRamos2006-08-19UHC-23311-92•••-••-0105716-703-4310luis.ramos21@aol.com3844 Ridge RdSan AntonioTX78248GRP-1328·CHOICE-PLUS-PPO
ENRENR-1322362026-07-10T10:16:03Z·Karen—Montogmery09/14/1963·UHC-47610-46•••-••-6714231-855-0598karen.montgomery@outlook.com8807 Highland AveColumbusOH·43278GRP-2825OPTIONS-PPO··
ENRENR-1047282026-01-26T19:34:33ZLe, Emily··V.—Dec 9, 1997uhc-71304-15•••-••-61489219277847·EMILY.LE@AOL.COM7478 OAK STMinneapolis·MN55479GRP-8368NAVIGATE-HMO
ENRENR-1153622026-01-12T19:28:09Z·Gilbert, Margaret——2005-80-24UHC-60344-23•••-••-8107395-570-5572margaret.gilbert@hotmail.com6590 Canyon RdMinneapolisMN55486GRP-2736NAVIGATE-HMO
ENRENR-1341722026-06-10T04:29:27ZStephen X—Nichols··1963-04-21UHC-02707-02•••-••-16123743127050STEPHEN.NICHOLS@OUTLOOK.COM3131 WILLOW CTGlendaleAZ85389GRP-0577CORE-HMO
ENRENR-1010612026-01-18T13:09:18ZRogerD.Mason04/28/1964UHC-97852-83—848-939-2124roger.mason@gmail.com·5276 River RdSACRAMENTOCA95819GRP-3147OPTIONS-PPO
ENRENR-1337882026-07-09T06:58:31ZDONNAA.SILVAOct 6, 1989UHC-90917-79•••-••-22306128482262NULL9374 Sage CourtLas VegasNV89168·GRP-6139MEDICARE-ADV-B
ENRENR-1369302026-05-21T01:54:13ZScott—Li2004-10-06UHC-59649-06NULL15379180650UNKNOWN5197 Ocean AvenuePhoenix··AZ··85086GRP-5590·MEDICARE-ADV-A
ENRENR-1077272026-09-09T06:49:48ZEmilyOPerez1997-04-28UHC9161698•••-••-92054075598766EMILY.PEREZ@GMAIL.COM74 JEFFERSON AVEColumbusOH43244GRP-5344NAVIGATE-HMO
ENR ENR-1382592026-09-24T22:47:58Zkalya—harrison1980-10-19UHC-68830-67•••-••-6162+1 315 669 1585kayla.harrison75@gmail.com··5169 BroadwayPlanoTX75043GRP-0789CORE-HMO
ENRENR-1067712026-10-09T19:41:32ZAlexis··—Fox2007-04-26UHC-32649-36nullUNKNOWNalexis.fox@outlook.com7627 Indian School RoadGilbertAZ85200GRP-0870CHOICE-PLUS-PPO
ENRENR-1179642026-02-26T12:01:33ZJACOB—WEBB·05/07/58UHC-07880-02•••-••-16032649216587jacob.webb81@gmail.com6904 BroadwayHoustonTX77048GRP-4473MEDICARE-ADV-A
ENRENR-1383302026-07-01T03:56:13ZGilbert, JeremyX—1986-01-02UHC-89474-15•••-••-687716106299365UNKNOWN8011 Jefferson AvenueTucsonAZ85748GRP-8175OPTIONS-PPO··
ENRENR-1344562026-10-02T12:09:36ZLaura··Castillo04/24/1962UHC-96050-09•••-••-74532313801821laura.castillo77@gmail.com4454 Valley View DriveSan DiegoCA92164GRP-1251··MEDICARE-ADV-B
ENRENR-1100222026-08-24T23:48:00ZfrankMtarn1951-05-03UHC0699533··•••-••-0023·688.303.8399frank.tran29@hotmail.com1692 Sunset Boulevard Apt 27SAN DIEGOCA·92149GRP-0565SELECT-EPO
ENRENR-1149102026-03-23T21:33:22ZPAMELAUPADILLA1964-02-16UHC-75119-62•••-••-9623+1 620 571 9342PAMELA.PADILLA@PROTON.ME8048 Mountain View DrCHANDLERArizona85206GRP-3423core-hmo
ENRENR-1296132026-05-02T14:04:49ZEdwardKLee1994-11-09UHC-85828-24•••-••-67172384791538edward.lee@icloud.com1320 River RdSEATTLEWA98154GRP-1095OPTIONS-PPO
ENRENR-1273452026-06-01T01:29:35ZJulia—Garza12/7/1951uhc-69609-77•••-••-7890287.918.0689julia.garza75@aol.com9030 Indian School RdLas VegasNV89162·GRP-7255SELECT-EPO··
ENRENR-1338712026-07-30T19:40:30Z·Morris, BettyE.—Dec 10, 1960UHC-99383-58•••-••-52536053676betty.morris@aol.com3269 GRAND AVEEden PrairieMinnesota55342GRP-9806core-hmo
ENRENR-1112602026-01-26T15:49:07Z Wright, Philip——4/12/1998··UHC-98948-34•••-••-55366736256120philip.wright37@icloud.com1137 Hillcrest RdLas VegasNV89166-2630GRP-2333··MEDICARE-ADV-A
ENRENR-1085422026-05-25T19:10:01Z ·kaylaS··henry11-11-1969UHC-88085-99··•••-••-2236+1 729 834 8501NULL—nullN/A—GRP-6746MEDICARE-ADV-A
ENRENR-1210652026-08-21T14:30:03ZLawrrence—Padilla2007-01-14UHC-99915-26•••-••-3570-lawrence.padilla35@yahoo.com5342 Lake View Rd·TucsonAZ85749GRP-7675MEDICARE-ADV-A
ENRENR-1186542026-04-20T23:44:56ZMarthaE.Coleman··7/23/1957UHC-19978-55—471-616-3793MARTHA.COLEMAN95@ICLOUD.COM3597 Oak StJACKSONVILLEFL32270GRP-2563SELECT-EPO
ENRENR-1239012026-07-25T01:46:20ZMichael·NDiaz··02/07/67UHC-32363-72•••-••-73462107590533michael.diaz81@aol.com7862 Indian School RoadEden PrairieMN55318··GRP-9224NAVIGATE-HMO
ENRENR-1411172026-07-21T06:21:04ZBEVERLYHALEXANDER1957-10-27UHC-95042-21•••-••-27544488131123BEVERLY.ALEXANDER49@AOL.COM8544 Cedar LnSeattleWA98185GRP-6310NAVIGATE-HMO
ENRENR-1288222026-08-10T18:15:14ZScott—Bell1976-09-05UHC-21307-72•••-••-7756967-740-2548scott.bell63@gmail.com5175 Union StreetCOLUMBUSOH43267GRP-1842OPTIONS-PPO
ENRENR-1110602026-08-12T12:46:05ZWALTER—CREWFORD10/02/1999uhc-83187-18N/A641-508-9019·UNKNOWN6940 Oak StGILBERTaz85240-0512GRP-2823OPTIONS-PPO
ENRENR-1390992026-09-13T08:08:52ZJACOBK··GOMEZ1976-07-10UHC-45306-71-253.237.5044—6461 Valley View DrAtlantaGA30380GRP-6772··CHOICE-PLUS-PPO
ENRENR-1372182026-01-18T07:41:47ZRaymondTGzman19910202UHC-14684-42-360-651-1435RAYMOND.GUZMAN@PROTON.ME·2259 UNION STREETSeattleWA98173GRP-5641OPTIONS-PPO
ENRENR-1373742026-08-15T11:35:48ZPriyaGShaw1955-04-20UHC-27495-29NULL840-422-0769PRIYA.SHAW@AOL.COM2837 Sage Court Apt 10MIAMIFlorida·33173GRP-5326OPTIONS-PPO
ENRENR-1294062026-01-18T10:33:20ZMARILYN—FRANKLIN1993-01-24UHC-92243-38•••-••-2438+1 371 664 4703marilyn.franklin@aol.com1083 Ridge RoadMinneapolisMN55470GRP-9608CORE-HMO
ENRENR-1249292026-05-16T17:42:10ZAmber I—Fernandez1970-08-14·UHC7171281•••-••-0026608-557-4480amber.fernandez40@outlook.com1598 CENTRAL AVENUE··MinneapolisMinnesota55493GRP-3969·CORE-HMO
ENRENR-1367452026-10-04T07:45:38ZAnthony··DGuerrero1953-12-24··UHC-05111-02NULL356-778-5681anthony.guerrero@gmail.com·1641 Central AvenueLos Angeles··CAUNKNOWNGRP-5617SELECT-EPO
ENRENR-1427072026-01-07T16:53:41ZDonald—Wallace1966-05-22UHC1588867•••-••-9862(214) 385-3591—3382 Main StreetAustinTexas78763GRP-3980··NAVIGATE-HMO
ENRENR-1386252026-01-02T05:55:44Zluis—hicks1963-12-07UHC-24118-33•••-••-6062225.898.4724NULL7581 LINCOLN WAYTempeArizona85219GRP-3891CORE-HMO
ENRENR-1273322026-03-15T15:47:15ZJan—Hill12/26/1962UHC-76210-92•••-••-83553955796746jean.hill33@outlook.com8614 OCEAN AVENUE Apt 30Las VegasNV89198GRP-5952navigate-hmo
ENRENR-1395372026-08-20T12:40:42ZSAMANTHANHOWARDNov 11, 1955UHC-54388-27•••-••-3204419-804-1104samantha.howard54@aol.com9210 PARK PLACEPhoenixArizona85042GRP-8627CORE-HMO
ENRENR-1246882026-05-03T11:19:47ZHelen—Green1982-02-24UHC-73031-46•••-••-8269+1 402 545 7613helen.green85@aol.com3097 Maple AvenueSEATTLEWA98186GRP-6897CORE-HMO
ENRENR-1023222026-08-21T08:57:20ZGABRIEL—WALKER1976-02-08UHC-80576-44-+1 871 711 9502gabriel.walker@yahoo.com5984 Mesa DriveNashvilleTennessee37205GRP-4907CORE-HMO··
ENRENR-1139622026-03-05T09:34:22Zalbert—delgadoApr 25, 1952UHC-21429-15•••-••-9933—ALBERT.DELGADO33@OUTLOOK.COM1506 BroadwaySan Diegoca92115GRP-7518·navigate-hmo
ENRENR-1421452026-06-12T21:07:59ZMARGARET··M.STONE19391220UHC-82602-39•••-••-74909749293907margaret.stone52@proton.me854 River RdPhoenixAZ85041GRP-0424CHOICE-PLUS-PPO
ENRENR-1040152026-06-20T11:30:44ZJohnston, Joan··P—2008-05-11UHC-22526-84—682.490.3204JOAN.JOHNSTON@ICLOUD.COM7583 Elm StreetPhoenixAZ85002GRP-4788SELECT-EPO··
ENRENR-1033522026-08-06T16:26:43ZAshley—Jacobs1989-01-15UHC-53490-56•••-••-3954(487) 514-0250ashley.jacobs20@icloud.com9812 PINE DRORLANDOFL32814GRP-0421OPTIONS-PPO
43,101 rows, page 185 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.322Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty