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-1302362026-09-10T08:24:14ZJUSTINGWEST1958-04-09UHC0239841•••-••-2901477-720-1257··N/A9666 Grand AveDallasTexas75247GRP-1726··SELECT-EPO
ENRENR-1282772026-01-09T18:26:35ZAndrewH.··Henry1966-11-20·UHC2858716•••-••-9930252.399.3353andrew.henry@aol.com2072 Maple Ave··Las VegasNV89105GRP-8093··MEDICARE-ADV-A
ENRENR-1058192026-05-10T02:49:50ZRian—Rojas3/17/1967UHC-73873-93•••-••-5243915.767.4523RYAN.ROJAS24@OUTLOOK.COM3825 APACHE BLVDSan DiegoCA92125-1376GRP-2161CHOICE-PLUS-PPO
ENRENR-100387 2026-04-01T11:06:05ZVargas, Jean——1994-08-16UHC-52195-58•••-••-4642299-569-8899JEAN.VARGAS@OUTLOOK.COM8065 Meadow LnChandlerAZ85265GRP-7330MEDICARE-ADV-A
ENRENR-1063692026-09-15T22:32:38ZDonna—Crafword1976-04-07UHC1583260•••-••-7333(595) 231-7804DONNA.CRAWFORD@GMAIL.COM1081 CANYON ROADTampaFL33679GRP-8891MEDICARE-ADV-B
ENRENR-1035172026-03-02T12:46:50ZSofia—Lucas19530125UHC-18083-05•••-••-6691+1 606 234 2622SOFIA.LUCAS23@GMAIL.COM3179 Ridge RoadSan AntonioTX78279GRP-8556NAVIGATE-HMO
ENRENR-1163342026-09-14T00:58:04ZJuan—Cooper1957-12-25UHC-84981-77•••-••-99482476641286—4091 Indian School Rd·FRESNOCalifornia93762GRP-3246MEDICARE-ADV-A
ENRENR-1171312026-04-15T07:30:23ZDanielle—Thompson1993-05-12UHC-07773-71··•••-••-8951UNKNOWNDANIELLE.THOMPSON61@HOTMAIL.COM5664 Ridge RdColumbusOH43221GRP-9417CHOICE-PLUS-PPO
ENRENR-1154922026-03-14T11:36:23ZOmarO.Simppson1999-11-26UHC-59095-99UNKNOWN(347) 563-8475omar.simpson@outlook.com7949 Central AvenueCHARLOTTENC28273GRP-0315MEDICARE-ADV-B
ENRENR-1284222026-06-19T20:12:55Z·Arnold, Frank——Mar 10, 1969UHC-80971-82•••-••-16916813421805FRANK.ARNOLD@AOL.COM··2031 Central AveSan AntonioTX·78298GRP-3954CHOICE-PLUS-PPO
ENRENR-1105332026-10-01T09:20:58Zcarol A—chapman8/20/1988UHC-63066-66•••-••-1353616-966-6703null5400 Broadway #712San DiegoCA92153GRP-8336OPTIONS-PPO
ENRENR-127299 2026-03-22T08:53:48ZDebra—Cruz1962-01-28UHC-87928-93•••-••-5689+1 306 535 7595null607 Palm DriveTUCSONaz·85769GRP-5028MEDICARE-ADV-B
ENRENR-1246502026-08-19T01:50:08ZLaurenPMartinez1942-11-03UHC-67061-31•••-••-5559(584) 619-3713lauren.martinez65@yahoo.com··4549 BASELINE ROADFresnoCA93774··GRP-9791CORE-HMO
ENRENR-1205272026-01-14T12:07:52ZcharlesGrussell23-03-1956UHC-91688-49-295.672.9951charles.russell45@icloud.com5776 Indian School RoadGilbertAZ85293GRP-7949CORE-HMO
ENRENR-1409632026-03-29T07:08:47ZaustinWlucas··Sep 7, 1968uhc-75664-62—7307951543····4175 BroadwaySeattleWA98137GRP-8964NAVIGATE-HMO
ENRENR-1410102026-01-12T16:52:16ZDIEGO—MORENO1957-09-05UHC-06269-70•••-••-1853586-911-9057—8878 Central AvenueChandlerAZ85268GRP-6139·OPTIONS-PPO
ENRENR-1294822026-05-20T09:53:59ZVincent—Gilbert19830908UHC8325966•••-••-1782(369) 959-7410·UNKNOWN1714 Indian School RoadPlanoTX75089GRP-9350SELECT-EPO
ENRENR-1312902026-04-21T21:00:21ZPaulHRivera09-04-1952UHC-98525-45•••-••-617314516979720PAUL.RIVERA82@ICLOUD.COM·3936 Elm StMesaAZ85283-2498GRP-2395NAVIGATE-HMO
ENRENR-1247262026-09-17T09:47:10ZAlanQ.Payne1964-12-24UHC-18612-39··•••-••-13013796743963—7885 Church St···OrlandoFL32874GRP-0340MEDICARE-ADV-B
ENRENR-1220592026-03-17T23:01:13Zfrank—weber19560302UHC-60254-75•••-••-5769(802) 817-0414frank.weber@hotmail.com3595 VALLEY VIEW DRGLENDALEaz85311GRP-0667MEDICARE-ADV-A
ENRENR-1261832026-01-03T08:19:10ZBanks, BryanG—1985-07-06··UHC-29398-59•••-••-8839+1 411 761 6199N/A·1805 Palm Dr·PhoenixAZ85090GRP-9490MEDICARE-ADV-B
ENRENR-1208262026-09-29T20:02:28Zkeith—white05/09/50UHC-00331-85··•••-••-1972·(522) 931-7985keith.white@hotmail.com5603 Jefferson AvenueDenverCO·80215-4222GRP-3012CHOICE-PLUS-PPO
ENRENR-1215572026-05-09T04:28:02ZHenry—Williamson1957-07-06·UHC-61283-79•••-••-3371(907) 257-4414HENRY.WILLIAMSON40@PROTON.ME989 Main StMesaAZ85239··GRP-6991MEDICARE-ADV-A
ENRENR-1273782026-02-08T22:28:30ZEmily—Jones1983-03-02UHC-01142-45•••-••-30846574925047emily.jones@outlook.com9687 Valley View Drive·ORLANDOFL32808GRP-8621NAVIGATE-HMO··
ENRENR-1305202026-02-11T19:28:34ZROBERTO··WATKINS2001-07-07·UHC-29270-37•••-••-6205640.987.0505—8144 GRAND AVENUE Apt 4DallasTX75245GRP-4967NAVIGATE-HMO
ENRENR-1222092026-08-19T14:24:30ZDebra—Washington··1942-11-07UHC-53809-30•••-••-8523(230) 561-9338debra.washington23@gmail.com9532 RIDGE ROADMinneapolisMN55411GRP-5616·NAVIGATE-HMO
ENRENR-1227692026-01-14T20:30:40Zolivia—morgan1954-04-18UHC-69683-92•••-••-9319+1 651 695 9529—4590 Grand AvenueLas VegasNV89113GRP-8288CORE-HMO
ENRENR-1246612026-03-05T16:23:42Z Willie—Walsh19860201UHC-20447-25•••-••-097615423626204-408 Sage CtScottsdaleAZ85249GRP-5271MEDICARE-ADV-A
ENRENR-1181202026-03-26T07:42:05ZHEATHERQSCHULTZ··2003-12-09UHC-31606-78•••-••-22042327998915null8354 Baseline RoadTucsonAZnullGRP-6099CORE-HMO
ENRENR-1244652026-06-23T05:33:23ZArjunJ.WardFeb 24, 1958UHC-59588-89•••-••-25126322238562—5039 Washington StreetMinneapolisMN55449GRP-6779medicare-adv-b
ENRENR-1025022026-09-18T18:48:47Z KyleZ.Phillips1946-08-19UHC-74042-16•••-••-36277132362744kyle.phillips75@hotmail.com4114 Cedar LaneChandleraz·85235GRP-7078SELECT-EPO
ENRENR-1062832026-07-07T02:06:03Z·Lori—Payne05-12-1983UHC0108543•••-••-39899366677228LORI.PAYNE69@OUTLOOK.COM···6318 Sage CourtLas VegasNV89122GRP-1169CHOICE-PLUS-PPO
ENRENR-1375522026-08-04T13:10:13Zstephen—gordon··1988-03-22uhc-82600-06•••-••-2833724-422-1938-5705 Meadow LaneSeattleWA98145GRP-6493NAVIGATE-HMO
ENRENR-1064772026-04-29T06:55:59ZCATHERINEZFOSTER19981010UHC-39548-62•••-••-31416687093722CATHERINE.FOSTER44@AOL.COM6272 River RoadMIAMIFL33115GRP-1225CORE-HMO
ENRENR-1142442026-10-11T10:52:51ZJacquelineFFlorres1938-12-16UHC0307053•••-••-8271428-527-8069null8553 Spring StreetTampa··FL·33668-7898GRP-6920··NAVIGATE-HMO
ENRENR-1409502026-05-25T23:06:14ZAustin, Jon——1939-07-15UHC-44139-94•••-••-7940(487) 794-1078john.austin@hotmail.com6587 Bayshore DrEden PrairieMN55331GRP-9326CORE-HMO
ENRENR-119569 2026-05-23T08:54:50ZJackieLAlvarado1946-02-10UHC-56970-49NULL956-715-6934jacqueline.alvarado@icloud.com9838 Lake View RoadSan DiegoCA··92157GRP-7172SELECT-EPO
ENRENR-1129612026-01-08T18:07:42ZRUSSELLIWAGNNER1970-49-25UHC-45718-66•••-••-4503414.322.8396RUSSELL.WAGNER33@OUTLOOK.COM··1814 Grand AvenueTampaFL33650·GRP-8072·OPTIONS-PPO
ENRENR-1097842026-08-14T20:12:00ZBARBARAR··BELL1995-02-17UHC-39735-08··•••-••-75039838985372barbara.bell@icloud.com6067 Apache BlvdSan DiegoCA92101··GRP-3905MEDICARE-ADV-B
ENRENR-1084092026-08-21T04:05:43ZAlexisCWelch1950-05-21UHC-42203-08•••-••-2017—alexis.welch85@outlook.com2207 Meadow LnFresnoCA··93725·GRP-6028CORE-HMO
ENRENR-1147302026-09-14T14:12:29ZOlson, Roy······1956-12-13UHC-80127-17—2272189033··UNKNOWN6965 INDIAN SCHOOL ROADHoustonTexasNULLGRP-7239MEDICARE-ADV-B
ENRENR-1015692026-09-28T11:05:11Z·RogerDContreras05/08/1953UHC-61538-70··—372-559-3524—9275 UNION STGlendaleAZ85331GRP-1790SELECT-EPO
ENRENR-1297902026-04-07T03:36:44ZARJUNVANDERSON1985-07-05UHC-56313-59•••-••-89836009315274-9629 MESA DRIVEPLANOTX75045GRP-4067MEDICARE-ADV-A
ENRENR-129733 2026-05-05T22:14:56ZJoanJButler··2006-06-05UHC-23317-80•••-••-617915407941501joan.butler@proton.me3014 Washington Street··HoustonTX77093·GRP-1565CHOICE-PLUS-PPO
ENRENR-1338852026-01-30T07:06:15ZnoahXhoffman1940-05-18UHC-83947-97•••-••-8993630-218-8321noah.hoffman61@yahoo.com··7143 GRAND AVENUEMesaAZ85250-1547GRP-1600··CHOICE-PLUS-PPO
ENRENR-1293682026-04-16T13:14:31ZColeman, Kyala··—1950-08-25UHC-25788-16•••-••-8429468-415-1321kayla.coleman@proton.me9747 Main StreetScottsdale·Arizona85213GRP-2195NAVIGATE-HMO
ENRENR-1360862026-03-23T20:24:57ZMargaret—Butler25-11-1944UHC-48996-47•••-••-91792028951—4150 Ridge RdEDEN PRAIRIEMN··GRP-6140MEDICARE-ADV-B
ENRENR-1338022026-03-28T12:19:35Z JULIA··RUIZ8/20/1994·UHC-49539-71•••-••-1458522.929.9885—1868 River Rd #410MIAMIFL33195GRP-1658MEDICARE-ADV-A
ENRENR-1179772026-10-01T06:40:21ZMARCUSWBURKE1950-03-16UHC-63752-52•••-••-56448654517550—·6174 Cedar LnTucsonAZ85767GRP-6574MEDICARE-ADV-B
ENRENR-1374522026-05-10T10:00:56ZVictoriaP··Ramos0806-91-96·UHC-08939-34•••-••-7222+1 769 403 8682victoria.ramos69@outlook.com6219 Lincoln WayFresnoCA93783GRP-3555SELECT-EPO
43,101 rows, page 231 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.611Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty