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

All sources, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
ENRENR-1361372026-09-05T19:28:19ZJeesse·AHart1963-08-19UHC-19507-27•••-••-17748823996834JESSE.HART@AOL.COM9617 Ocean AveAtlantaGA30391GRP-7741SELECT-EPO
ENRENR-1263562026-02-14T08:03:57ZButler, ChristinaS—13-03-1945UHC-65441-35•••-••-7895359-257-6327christina.butler46@proton.me5040 Lincoln WayTampaFL33644GRP-1735MEDICARE-ADV-B··
ENRENR-1417712026-06-30T20:28:46ZBruceS—1979-07-16UHC-57855-96•••-••-7435NULLBRUCE.JOHNSON@PROTON.ME1021 MEADOW LANEPlanoTX75019GRP-1942CORE-HMO
ENRENR-1011702026-01-17T16:07:13ZSOFYA—BANKS2007-10-13UHC-41894-24—8384869026—4043 Main StHoustonTX77071GRP-9570NAVIGATE-HMO
CLMCLM-4202152026-04-02T20:57:31ZKyle··Moore1984-03-11UHC-18856-78—null—N/AN/A—·NULLGRP-3750MEDICARE-ADV-B
CLMCLM-4043522026-03-16T20:50:53ZPAMELA—CONTRERAS1991-04-02UNKNOWN—977.716.6114N/A8748 ELM ST··Las VegasNV89196GRP-4096NULL
TPATPA-562972026-04-01T23:55:51Zamber—wright1939-02-25—UNKNOWN9256935730AMBER.WRIGHT@PROTON.ME5715 Palm DrTucsonaz85718NULLNULL
ENRENR-1392172026-03-14T12:50:09ZKyleMContreras1962-06-10UHC-17396-44•••-••-251015368965463UNKNOWN7575 CANYON ROAD #830DenverCO··80251GRP-5453SELECT-EPO
CLMCLM-4291602026-05-24T05:58:46ZJasonZ.Thompson1994-08-22—•••-••-9236(591) 303-0233—1783 Indian School RoadNashvilleTennessee37241N/AUNKNOWN
TPATPA-620832026-10-17T18:24:15ZRAYMOND—HUNT20-02-1952——nullN/A5972 Lake View RoadCharlotteNC28267——
ENRENR-113111 2026-06-04T02:19:58ZRandy—Aguilar···19470125UHC-67444-11•••-••-9073(405) 681-6139—6009 Elm StTucsonAZnullGRP-2177CHOICE-PLUS-PPO
PRVPRV-210672026-02-05T21:44:15ZChristinaARice1951-10-22UHC-34431-50UNKNOWN5904631125—3889 Mountain View Dr #667GilbertAZ85286—CHOICE-PLUS-PPO
TPATPA-635742026-04-14T08:05:50ZMateo—Salazar1965-05-19—•••-••-8018—null4525 Highland AveMESAAZ85215-2837GRP-3410··
ENRENR-1110252026-07-16T16:10:26ZMATEOIEDWARDS1958-09-14UHC-77692-77•••-••-32842107032080mateo.edwards71@yahoo.com746 Maple Avenue #682NashvilleTN37291GRP-3405CORE-HMO
TPATPA-522562026-01-01T14:14:46ZElijah—Flors1966-09-10NULL—NULL··ELIJAH.FLORES@OUTLOOK.COM2946 WASHINGTON ST #632··SacramentoCA·95869GRP-9932—
CLMCLM-4075482026-01-11T20:47:46ZBRUCE—SANCHEZ1966-12-13UHC-67947-39—NULL-9891 Highland AveTEMPEAZ85216—CHOICE-PLUS-PPO
ENRENR-1011442026-03-16T21:56:36ZZacharyTGeorge7/23/1999UHC-99695-66•••-••-5676938.999.9112ZACHARY.GEORGE@AOL.COM4326 SAGE COURTAustin··TX78784GRP-1841CORE-HMO··
TPATPA-581632026-08-16T16:53:25ZKEITH—SIMPSON2007-11-19UNKNOWN—NULLKEITH.SIMPSON62@GMAIL.COM·6732 CHURCH STREETFresnoCA93776—-
ENRENR-1045302026-10-14T07:46:25ZMARTHAGDAY··1986-10-03UHC-91422-70•••-••-2690+1 686 806 3049martha.day@icloud.com4026 Mesa DriveNashvilleTN37215···GRP-0153CHOICE-PLUS-PPO
PRVPRV-265082026-01-11T16:15:48ZKimberlyGHoffman··03/15/49··N/A•••-••-6907NULLKIMBERLY.HOFFMAN@ICLOUD.COM·1843 MOUNTAIN VIEW DRIVEHoustonTX77025··MEDICARE-ADV-A
TPATPA-586392026-04-19T00:06:12ZJESSE—HARRISON10/28/73··UHC-23309-57-UNKNOWN-8794 Meadow LnNashvilleTN37249N/A··choice-plus-ppo
PRVPRV-209582026-08-11T19:20:30ZDoris—Sullivan1938-05-11UHC-02605-16•••-••-3033(277) 654-4676UNKNOWN2615 Park Place··AtlantaGA30380UNKNOWN—
TPATPA-561132026-05-17T16:54:43ZKATHLEEN—STEVENS1979-02-01UHC-16813-28—559-700-5041N/AUNKNOWNN/A———options-ppo
CLMCLM-4122442026-02-25T02:52:28ZRoss, VictoraO—Jun 16, 1978—•••-••-9640·UNKNOWN—8429 Camelback RdDallasTX75251—NULL
CLMCLM-4297332026-03-05T19:58:07ZRONALD—DANIELS1967-06-11UHC-10524-07null9574886605null·8619 Central AvenueSan DiegoCA92134—-
CLMCLM-4269382026-04-11T00:24:37ZRYAN—DIXON2007-03-03UHC-90343-37UNKNOWN879-597-9163—3550 Lake View RoadSan DiegoCA92195-9817GRP-5879NAVIGATE-HMO
ENRENR-1095022026-01-31T12:41:55ZDanielsCGregory19691006UHC-35145-84•••-••-2197·423-804-8898gregory.daniels69@outlook.com3460 Ridge RdMesaAZN/AGRP-5529CORE-HMO··
CLMCLM-4146862026-01-27T07:54:15Zalice—gutierrez20080202UHC-29633-39•••-••-9344-—8084 Baseline RoadTampaFL33626GRP-8619—
CLMCLM-4060552026-04-01T21:40:59ZHANNAH—GREEN1981-12-16··—UNKNOWN—UNKNOWN9332 Camelback RoadDallas··TX75293UNKNOWNCHOICE-PLUS-PPO··
ENRENR-141716 2026-10-11T02:39:33ZWei—Robinson1983-12-14UHC-07395-64•••-••-2809·289.560.4585wei.robinson@proton.me3560 Mountain View DrMesaAZ85242GRP-8711SELECT-EPO
ENRENR-1265652026-08-24T18:06:33ZMaria—Gonzales05-05-1966UHC-94421-13N/A981-590-2792MARIA.GONZALES72@OUTLOOK.COM8457 CEDAR LNTEMPEAZ85287-4293GRP-5290NAVIGATE-HMO
CLMCLM-4152392026-05-19T10:20:51ZAisha—Owens2002-06-26··UHC8448896•••-••-3521(231) 707-5318null7806 Main StreetORLANDOFlorida32868N/A·MEDICARE-ADV-A
ENRENR-1327322026-04-25T23:11:17ZMARTHAUGORDON11/07/78UHC2647939•••-••-8813+1 686 422 8548MARTHA.GORDON@ICLOUD.COM6440 LINCOLN WAYDallasTexasnull··GRP-7242MEDICARE-ADV-A
PRVPRV-267222026-01-31T16:54:59ZTurner, TerryA—11/01/1971··UNKNOWN-(273) 779-8336-1573 PARK PLACE Apt 38·Eden PrairieMN55331—null
CLMCLM-4216672026-08-22T10:00:59ZRichard—Hamillton2001-10-03UHC-08968-49N/A2156053528UNKNOWN4119 Highland AveColumbusOhio———
CLMCLM-4037292026-03-18T19:55:02Z———1994-01-11UHC-83075-14————NULLN/A—GRP-2045N/A
ENRENR-1195102026-02-19T20:51:55ZRachelBWells··1974-05-08UHC-21071-49•••-••-4201620-489-9009—4991 MARKET STMinneapolisMN55485GRP-9549OPTIONS-PPO
ENRENR-1330902026-06-04T12:54:02Zsantiago—baker1991-02-27UHC-82806-01··•••-••-85138619839SANTIAGO.BAKER87@ICLOUD.COM3643 Park Pl··Los AngelesCA90027GRP-5960OPTIONS-PPO
PRVPRV-228822026-01-11T06:53:54ZJESS—FOXMay 8, 1991··null(493) 229-1787NULL·2148 Apache BlvdJacksonvilleFlorida32241UNKNOWNNULL
ENRENR-1421782026-05-18T14:49:00ZEthanFReyse··19391213uhc-75336-04•••-••-0125(338) 641-0619—5303 BroadwaySeattleWA··98135GRP-7074NAVIGATE-HMO
CLMCLM-4069542026-02-11T17:42:25Zkevin—jacobs1973-08-14—•••-••-9235·N/AUNKNOWN·9820 Harbor BlvdJacksonvilleFL·32202GRP-8723—
TPATPA-503192026-08-15T03:42:45ZCheryl—·Parker09-06-1988null•••-••-0033746-261-6992N/A8286 Bayshore DriveTAMPAFL33649-CORE-HMO
ENRENR-1230462026-10-14T07:18:59ZMendez, DanielQ····11/04/58UHC-21332-78N/A—DANIEL.MENDEZ@AOL.COM1144 Main StColumbusOH43225GRP-5926··CORE-HMO
PRVPRV-233342026-01-28T03:01:29ZJulie—Chen1981-10-26UHC-35660-93UNKNOWN6966381928N/A6058 CHURCH STREET #437Dallas··Texas75259—MEDICARE-ADV-B
CLMCLM-4220952026-04-28T20:15:28Z———09/18/67UHC-42415-03N/A535-505-4321null8889 Bayshore DriveDallastx75201··GRP-1768null
CLMCLM-4200112026-04-19T20:16:00ZGloriaX·Torres1991-11-21UHC6588012•••-••-4607——156 Sunset Blvd #806CharlotteNC28268—OPTIONS-PPO
ENRENR-1215592026-10-07T02:10:35ZTyler—Bryant1947-01-04UHC-47734-38•••-••-72239184828298··TYLER.BRYANT25@OUTLOOK.COM4557 Union StreetChandlerAZ85260GRP-8749MEDICARE-ADV-A
PRVPRV-257242026-01-08T00:10:38ZLisa—Hudson1950-71-10UHC-49171-42—719-276-3236lisa.hudson@yahoo.com19 BroadwayPhoenixAZ85068N/Anull
ENRENR-1250552026-03-20T17:14:14ZMARIA—CASTILLO19520426UHC-23081-93•••-••-17542489942114maria.castillo@gmail.com9239 Elm StreetEden PrairieMN—GRP-3397NAVIGATE-HMO
TPATPA-639192026-03-08T17:48:05ZBRITTANY··——1/8/1968N/A··—N/AUNKNOWNnullUNKNOWN——CHOICE-PLUS-PPO
100,000 rows, page 114 of 2,000PreviousNext

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:36.683Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty