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-1327732026-10-02T19:08:29ZAmber—Davis1986-12-09UHC-69598-56•••-••-8094·(862) 767-5311—6588 Main StChandlerAZ85203GRP-6355SELECT-EPO
ENRENR-1016782026-09-21T07:30:47ZVINCET—SANDERS1986-02-25·UHC-33261-46•••-••-0578+1 552 981 9291—·811 CEDAR LN·ChandlerAZ85248-4126GRP-9863SELECT-EPO
ENRENR-1350292026-01-29T20:51:13ZCHARLES—ROBINSSON1793-01-24UHC-14595-20•••-••-1068UNKNOWNcharles.robinson27@outlook.com3748 Ocean AvenueTempeArizona85277GRP-2008MEDICARE-ADV-A
ENRENR-112566 2026-07-11T05:53:04ZAndrewOVargas·2000-03-18UHC-80697-36•••-••-5728—andrew.vargas73@outlook.com1220 Baseline RoadLOS ANGELESCA90065GRP-5813MEDICARE-ADV-A
ENRENR-1022282026-02-28T14:16:55Z·Kenneth—·Woods1957-01-16UHC9467757•••-••-227219476207271kenneth.woods20@gmail.com2537 Pine DrLos AngelesCA90097GRP-9767CHOICE-PLUS-PPO
ENR ENR-1106282026-06-07T20:24:48ZMateo—·Ortiz2008-03-27UHC-00765-02•••-••-34489367550311-4680 Forest AveMiamiFlorida33158GRP-0183CHOICE-PLUS-PPO
ENRENR-1387002026-05-04T01:45:03Zangela—simpson03/28/41UHC-88361-45•••-••-20425523173174angela.simpson36@hotmail.com7681 Spring St Apt 39TucsonAZ85740GRP-3763NAVIGATE-HMO
ENRENR-1394292026-01-10T23:40:12ZLukiaU··Anderson19780403UHC-24339-08•••-••-40728919293647null1049 DESERT SKY BLVDNashvilleTN37206GRP-6800OPTIONS-PPO
ENRENR-1233282026-04-10T17:57:11ZChristine—Medina1982-05-25UHC-95954-29•••-••-8448(594) 224-0131UNKNOWN—-nullNULLGRP-1273CHOICE-PLUS-PPO
ENRENR-1227982026-04-21T09:35:28Ztheresa··Kburns1961-08-13UHC4945691•••-••-2967867-765-1239—6374 River RoadMiamiFL33146GRP-1749··core-hmo
ENRENR-1026692026-03-05T11:19:50ZHarvey, Thomas——1944-03-05UHC-88323-46•••-••-3403640.206.0091THOMAS.HARVEY@PROTON.ME7820 Bayshore DrLas VegasNV89123GRP-0962CHOICE-PLUS-PPO
ENRENR-1206292026-03-09T18:12:57ZPeterVBaker2001-04-28UHC9998131•••-••-62229817670571PETER.BAKER61@GMAIL.COM9241 Sunset BlvdFresnoCA93757GRP-0156·MEDICARE-ADV-A
ENRENR-1382392026-08-13T20:52:11Zcarolyn K.—fuller12/10/1996·UHC-10166-76•••-••-4941(923) 485-2955—5749 Mountain View DrAUSTINTX78736GRP-5712MEDICARE-ADV-A
ENRENR-1046912026-07-07T04:21:01Zgary—jimennez1954-03-21uhc-18639-93•••-••-3799959-688-5709gary.jimenez88@proton.me302 Elm StreetPLANOTX75041GRP-9949MEDICARE-ADV-B
ENRENR-1264302026-04-10T23:45:57ZRonald—CollinsAug 25, 1940UHC-11953-53•••-••-9542nullRONALD.COLLINS51@OUTLOOK.COM7802 Central AveTAMPAFL33616GRP-0600CORE-HMO
ENRENR-1214732026-10-14T22:16:05ZOrtizTStephanie1980-68-02UHC-92874-74•••-••-0318571-287-3717stephanie.ortiz@gmail.com5481 Washington StreetMiami·FL33191GRP-1132MEDICARE-ADV-A
ENRENR-114045 2026-05-02T16:53:56ZJustinYWrightMar 15, 1949UHC-64046-67•••-••-1641·+1 987 861 7076justin.wright84@icloud.com1629 Main StreetNashvilleTN37204GRP-6278MEDICARE-ADV-A
ENRENR-1184882026-09-26T21:16:07ZAmanda··—ShawUNKNOWNUHC-91321-72N/A863-991-1050amanda.shaw@aol.com7331 Washington StreetColumbusOH43256GRP-9009NAVIGATE-HMO
ENRENR-1086862026-09-11T12:18:58ZDENISET·KING06/10/1989UHC-24696-32··•••-••-4848964.425.6435N/A··1882 FOREST AVEMesaAZ85234GRP-0647MEDICARE-ADV-A
ENRENR-1248012026-07-14T08:30:18ZJohnCBoyd19550801UHC-18966-41•••-••-2201·(740) 703-1968NULL··4588 Central AvenueMinneapolisMN55485GRP-0889MEDICARE-ADV-B
ENRENR-1223512026-03-23T18:01:53ZDIANER.MALDONADO07/17/1965UHC-17511-15•••-••-15796149673335DIANE.MALDONADO@YAHOO.COM3768 Cedar LnGilbertAZ—GRP-2700NAVIGATE-HMO
ENRENR-1415262026-04-05T00:01:29ZFerguson, SharonI—1959-06-22UHC-64402-07null(835) 688-6134·NULL4479 OCEAN AVECOLUMBUSOH43204·GRP-2882navigate-hmo
ENRENR-1151622026-04-11T08:16:49ZJose—Barnes7/16/1979··UHC-53140-13•••-••-48364606618jose.barnes30@proton.me7290 Cedar LaneAustinTexas78722GRP-6060OPTIONS-PPO
ENRENR-1056302026-08-12T03:08:23ZBENJAMINDRICHARDSON17-04-1958NULL•••-••-7061(560) 644-6879—6480 Indian School RoadDALLASTX75277-6724··GRP-1567MEDICARE-ADV-B
ENRENR-1201592026-08-26T04:56:50ZJack—Jordan1948-03-11UHC-62945-41-+1 736 852 1414jack.jordan14@icloud.com622 Mountain View Drive #656GilbertAZ85264GRP-6837CHOICE-PLUS-PPO
ENRENR-1072442026-04-06T02:25:48ZAHMEDBBILEYMay 10, 1978UHC-12383-43•••-••-38092294154N/A5091 BroadwayAtlantaGA—GRP-4770·CORE-HMO
ENRENR-1356802026-01-21T23:01:43ZAshleyMBowmanJul 27, 1954UHC-55178-78UNKNOWN(427) 780-1336ashley.bowman50@icloud.com5161 MEADOW LANESan Antonio··TX78219GRP-6238NAVIGATE-HMO
ENRENR-1116042026-09-23T01:11:00ZAnnaO.Bell04/12/1938UHC-14422-58null·919.213.7331—957 Baseline RoadDallasTX75259-0399GRP-1882CHOICE-PLUS-PPO
ENRENR-1028872026-09-24T19:27:16ZMARGARETXREED1963-05-01UHC-06116-42•••-••-86462727099084MARGARET.REED70@GMAIL.COM8171 Ocean AveLas VegasNV89167GRP-1998select-epo
ENR ENR-1386992026-01-23T01:00:37ZLittle, Cheryl——1992-09-28UHC-89021-43•••-••-7305(521) 609-3799CHERYL.LITTLE32@HOTMAIL.COM4835 Hillcrest Rd Apt 33Eden PrairieMN55390GRP-7057NAVIGATE-HMO
ENR ENR-1033362026-07-22T20:07:06Zlarry··—vaquez2003-04-24UHC-17161-28•••-••-8194+1 450 964 6317—5326 Lincoln WayJacksonvilleFL32248··GRP-4457CHOICE-PLUS-PPO
ENRENR-1346932026-10-15T12:02:10ZHenry—Rios07/25/1989UHC-91003-95•••-••-9179611-930-7857henry.rios23@aol.com··2185 Palm Drive Apt 24SAN ANTONIOTX—GRP-2533CORE-HMO
ENRENR-1256932026-02-15T14:20:36ZAndrew··LFreeman1985-08-02UHC-76276-79•••-••-35784145201517··—8606 CHURCH STDenverCO80221GRP-0888SELECT-EPO
ENRENR-1191282026-09-05T07:08:37ZNicoleAMyers··0122-19-97UHC-92949-48•••-••-118617088366593NICOLE.MYERS@YAHOO.COM1400 Union StEDEN PRAIRIEMN55355GRP-7334OPTIONS-PPO
ENRENR-1429352026-02-09T17:32:16ZDonaldGKennedyAug 24, 1959uhc-80692-79•••-••-3560609-552-9694DONALD.KENNEDY@HOTMAIL.COM7544 CANYON ROADJacksonville·FL32293GRP-7003SELECT-EPO
ENRENR-1302682026-05-16T11:24:33Z·JeffreyP.Delgado1978-01-06··—•••-••-511119054808362jeffrey.delgado28@gmail.com1110 Washington StreetDenverCONULLGRP-0178OPTIONS-PPO
ENRENR-1221392026-05-05T08:01:14ZJEANZ··COLLINS1971-03-07UHC-75899-09··•••-••-7695(341) 552-8863jean.collins@hotmail.com4646 Main StTucsonArizona85755GRP-3550··NAVIGATE-HMO
ENRENR-1404492026-07-22T03:54:44ZJASON··NMEJIA1973-01-28UHC-68953-11··•••-••-9499481-296-0187JASON.MEJIA99@YAHOO.COM4774 RIVER RDDALLAS·TX75261·GRP-9562CORE-HMO
ENRENR-1109682026-01-31T17:22:14ZJESSICAYHOFFMAN1993-06-01UHC-38803-96•••-••-47894853525434JESSICA.HOFFMAN@AOL.COM3037 Palm DrJACKSONVILLEFL32243GRP-8503MEDICARE-ADV-A
ENRENR-1271832026-01-31T21:34:36Zpatrick—murphy1956-03-05UHC-80947-87•••-••-79564739219594PATRICK.MURPHY10@PROTON.ME1182 DESERT SKY BOULEVARD···HoustonTX77009GRP-6755MEDICARE-ADV-A
ENRENR-1186852026-07-28T05:12:10ZJEFFREYIPAYNE··1985-09-28uhc-22064-20•••-••-7528N/A—1553 Palm DriveHoustonTX77090GRP-3989MEDICARE-ADV-A
ENRENR-1346082026-07-07T05:56:30ZWillieY.··Murray2008-06-04-•••-••-89298744417259··willie.murray@yahoo.com5493 Sage CourtSan AntonioTX78287GRP-1834CORE-HMO
ENRENR-1301732026-06-01T07:03:22ZRALPH···WASHINGTON1977-07-06—•••-••-8321(450) 891-3008UNKNOWN3498 Meadow LanePlanoTX75077GRP-5453CORE-HMO
ENRENR-1082112026-07-10T14:44:17Zsophia··—lynch1967-10-21UHC-01980-86—(736) 964-4069UNKNOWN2211 Harbor Boulevard··MESA··AZ85279GRP-9630MEDICARE-ADV-B
ENRENR-1154832026-04-26T01:04:57ZJuanFKelly2001-07-25UHC-79297-20—205-858-8693juan.kelly@hotmail.com1899 MAPLE AVENUE Apt 20DallasTX75268GRP-8846MEDICARE-ADV-A
ENRENR-1189162026-02-19T10:59:45ZDeniseNHughes09/28/1952UHC4713347•••-••-3391574.407.6369—4650 MARKET STREETJacksonville··FL32249GRP-7955CHOICE-PLUS-PPO
ENR ENR-1302882026-06-29T05:56:03ZOliviaRTucker5/1/1946UHC3676481•••-••-8631585.601.7147olivia.tucker@hotmail.com·6613 Highland AveTucsonAZ85780GRP-7041CHOICE-PLUS-PPO··
ENRENR-1324132026-04-14T20:57:55Z—I—02/06/07UHC-55057-05•••-••-9393676-518-4352-7501 APACHE BLVDSeattleWA98163GRP-5859·SELECT-EPO
ENRENR-122839 2026-04-26T06:58:11Zanna··NortizSep 17, 1990nullnullNULL-1073 CANYON RDGilbertArizona··85298··GRP-9137CORE-HMO
ENRENR-1217382026-09-19T14:32:28ZMARTHA—HAWKINS·12/4/2004UHC-77244-10•••-••-6938(618) 753-2603martha.hawkins38@outlook.com3240 Baseline RoadHoustonTX-GRP-1714CORE-HMO
43,101 rows, page 35 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.795Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty