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
TPA TPA-577432026-10-18T03:43:14ZHIROSHI—·MEYER1988-10-03-——hiroshi.meyer56@hotmail.com3492 Willow CtAustinTX78723——
TPATPA-510112026-03-03T12:47:54Zcarl—morales1979-12-15-UNKNOWN·6095466523—5098 Market StreetOrlandoFL32800GRP-7452UNKNOWN
ENRENR-1220152026-06-03T11:25:19ZJANICE——01/11/1981UHC-29648-88•••-••-7337-JANICE.MEDINA99@PROTON.ME8146 LINCOLN WAYTucson·az85736GRP-3420MEDICARE-ADV-B
PRVPRV-209122026-02-22T12:36:34ZBETTY—ALLEN1956-09-12·-—965.963.5693betty.allen22@icloud.com8596 BroadwayTempeAZ85248NULLCHOICE-PLUS-PPO
PRVPRV-231742026-09-28T15:07:37ZDaniels, Laura——·04/28/78N/A•••-••-2546716-589-5063—2172 Lincoln WayChandlerAZ-—CORE-HMO
CLMCLM-4013862026-03-03T12:28:03ZJEANM.BENNETT19880722·uhc-16157-76•••-••-8525—NULL—UNKNOWNN/AUNKNOWNGRP-8567NULL
ENRENR-1128192026-05-17T04:26:47ZYuki—Lynch1963-06-01UHC-60388-32··-N/AN/A1153 CANYON ROAD Apt 20Gilbert·AZ85223-3423GRP-2983CORE-HMO
CLMCLM-4171722026-03-31T02:18:43ZHarold—Simmons1948-07-21UHC-09892-81N/A921-867-4345null1157 Desert Sky Boulevard·GILBERTAZ85227-1237·GRP-9120··
ENRENR-1210222026-01-02T14:24:28ZRYANJ.HILL··09/13/1966UHC-71857-40•••-••-6081359-397-3007ryan.hill44@outlook.com5138 HARBOR BLVD #202AustinTX78793GRP-3908medicare-adv-a
CLMCLM-4153532026-05-03T16:37:47ZKen—Kennedy1997-07-03UHC-75623-35•••-••-3238NULL-2830 Valley View Drive··MinneapolisMN55413GRP-6252NULL
PRVPRV-271822026-10-01T13:05:30ZKing, Valentina——1989-03-28nullNULL—-8497 Palm DrORLANDOFL32882N/AUNKNOWN
ENRENR-1193172026-02-20T02:54:20ZSophia—Sandoval1964-05-26UHC-72940-64—265.704.9567N/A5489 Jefferson AvenueSAN DIEGOCAnullGRP-3712CHOICE-PLUS-PPO
CLMCLM-4007712026-05-24T11:31:05ZAngela—Yang1970-01-18··—•••-••-8894+1 981 601 9278—7662 OAK STREETAustintx78702GRP-5036N/A
CLMCLM-4130322026-08-15T13:02:14ZBrittany—Lucas03/27/2000null•••-••-4458—N/A1258 PARK PLPlanoTexas75017GRP-2696UNKNOWN
ENRENR-1416082026-04-22T12:49:40ZCatherineISanchez·05-07-1993·UHC-57995-64•••-••-0208734-228-6549catherine.sanchez85@gmail.com3195 Valley View DrCharlotteNC··28257GRP-1238SELECT-EPO
ENRENR-1217962026-02-13T01:37:02Z Philip—Perez1975-01-14UHC-11905-66-8659910—8397 SAGE COURTPHOENIXArizona85084·GRP-2935CHOICE-PLUS-PPO
ENRENR-1286292026-04-16T13:21:15ZAbigail—Robinson1993-03-10UHC-18333-66•••-••-5748NULLabigail.robinson@proton.me6251 Oak Street··ScottsdaleAZ85292GRP-2647CORE-HMO
ENRENR-1399502026-03-02T10:53:01ZBRANDONMHAMILTON···1965-04-13·UHC-11844-80null667.928.3938BRANDON.HAMILTON69@PROTON.ME8869 MOUNTAIN VIEW DRIVETucsonAZ··GRP-7321NAVIGATE-HMO
TPATPA-608492026-06-08T19:46:31ZCollins, Amy——1970-09-28-·UNKNOWNUNKNOWNamy.collins61@icloud.com4997 MAPLE AVENUE #315·MinneapolisMN55493GRP-1690null
PRVPRV-22003 2026-05-29T02:38:19ZJulie—Pena1989-12-02UHC-02461-38—12948505111···N/A59 MOUNTAIN VIEW DRIVETUCSONAZ85739—null
TPATPA-583592026-04-30T08:09:58ZLawrence····Burke1981-07-17NULL•••-••-5867nullN/A6947 Apache BoulevardMESAAZ85251-8239····-
ENRENR-1422362026-05-13T15:41:02ZTheresaIGarza1953-06-11·UHC4803418•••-••-7974——7635 River RoadAustinTX78770GRP-0279SELECT-EPO
ENRENR-1015862026-03-14T08:56:36ZKevin I—Riley·06/19/03UHC9253773•••-••-5623+1 472 620 5862··kevin.riley@proton.me7589 Jefferson AveEDEN PRAIRIEMN55366GRP-9310NAVIGATE-HMO
CLMCLM-4174192026-03-02T13:38:17ZBRANDUN··SHAWNov 7, 1960NULL····N/Anull7007 OAK STREETDenverCO80237GRP-0327OPTIONS-PPO
TPATPA-524712026-09-16T03:57:48Zedward··robertson1995-11-16—•••-••-743819648396355edward.robertson@proton.meN/A-null····GRP-2079·CORE-HMO
ENR ENR-1324712026-05-27T03:34:05ZSofiaT.Lucas·1969-04-12UHC-89122-72•••-••-4505660-644-2234—9873 UNION STREETAustin··TX78744-8104GRP-9903CORE-HMO
ENRENR-1143642026-07-21T13:58:39ZANNAH.WALLACEJul 17, 2008··UHC-41587-11··N/A8387675417anna.wallace58@yahoo.com9684 Camelback Road··ScottsdaleAZ85254GRP-3553MEDICARE-ADV-A··
ENRENR-142863 2026-04-15T12:45:39ZRay, RobertT.—·1986-11-19·UHC-38009-75•••-••-1271701.850.1011robert.ray@aol.com·9442 Pine Drive #634·SeattleWA98128-8497GRP-1197MEDICARE-ADV-B
CLMCLM-4123052026-04-28T04:29:49ZDavis, Sharon——1692-12-16—•••-••-0017+1 539 425 1076—·5576 HIGHLAND AVENUEFresnoCAN/AUNKNOWN-
ENRENR-1422242026-03-31T01:03:30ZChristianG.Medina1970-02-20UHC3228716•••-••-2425(299) 239-7827CHRISTIAN.MEDINA52@OUTLOOK.COM··4608 Pine DriveCharlotteNC28247GRP-8971CORE-HMO
ENRENR-1367272026-01-01T18:24:28ZLucia—Jimenez19400102UHC-40065-64•••-••-8668—·LUCIA.JIMENEZ78@PROTON.ME3658 Desert Sky Blvd··AUSTINTX78730GRP-2958NAVIGATE-HMO
CLMCLM-4020262026-07-11T20:59:52ZDENISE—JOHNSTON2008-03-09UHC-49425-51-··N/AN/A6538 PALM DRGilbertAZ85210GRP-8477SELECT-EPO
ENR ENR-1112152026-07-09T09:18:17ZsamuelApayne2125-19-76UHC-26523-27•••-••-19226540118··samuel.payne67@proton.me·3658 Highland AvenuePlano··Texas·75059GRP-6215CHOICE-PLUS-PPO
CLMCLM-4204482026-08-27T09:26:45ZPatrick—Boyd1977-05-24—·-N/A—7545 Mesa DriveMesa··AZ85230GRP-2893MEDICARE-ADV-A
CLM CLM-4234332026-08-30T10:47:06ZVALENTINA—FREEMANJan 26, 1967UHC-64211-41•••-••-850116844721103—5602 Harbor BoulevardLas VegasNV89139··NAVIGATE-HMO
ENRENR-1154642026-05-30T16:47:53ZDENISEH.ROSS1975-07-10UHC-51808-48•••-••-7668305.646.9510-··9734 APACHE BLVD #314COLUMBUSOH43223GRP-9451SELECT-EPO
ENRENR-1337212026-06-14T02:46:51ZDANIELE—BRADLEY1998-02-18UHC-78142-72•••-••-9124UNKNOWNdanielle.bradley@proton.me670 Pine DriveDenverColorado80201GRP-9610CHOICE-PLUS-PPO
CLMCLM-421009 2026-02-26T06:25:25ZMargaret—Dean2000-06-07UHC-39451-79NULL(514) 961-1106UNKNOWN2873 Maple AveTampaFL33674—·MEDICARE-ADV-B
ENRENR-1011302026-02-20T00:28:25ZjacobFgraham1964-11-25··UHC-21342-67•••-••-65398968297242null3500 Hillcrest RdSan AntonioTX78284·GRP-1887MEDICARE-ADV-A··
ENRENR-1393042026-01-20T12:47:59ZAllen—Stephanie1996-11-20UHC-14842-48··•••-••-2196775-964-4173stephanie.allen@hotmail.com2928 MAIN STTucsonAZ85715GRP-0308SELECT-EPO
ENRENR-1425252026-07-11T07:59:08ZBrandon—Long01/17/68UHC-80661-39•••-••-61488424375711brandon.long81@gmail.com2256 Desert Sky BlvdFresnoCA93749GRP-8651SELECT-EPO
ENRENR-1214712026-05-22T05:13:50ZCHARLOTTE—·LE1980-08-17UHC-88223-35•••-••-1842(743) 625-2642—3814 MESA DRIVECharlotteNC28217GRP-8390OPTIONS-PPO
CLMCLM-4091092026-07-12T11:09:45ZDonald—Wlaker2002-06-26UHC2325048NULL12969652931—6076 PALM DRIVETEMPEAZ-GRP-3131CORE-HMO
ENRENR-110627 2026-07-16T16:31:45ZEmilyJMartin1997-05-14UHC-23423-50•••-••-6236·966.613.6576EMILY.MARTIN@AOL.COM3958 ELM STREETMiamiFL33109··GRP-6290CHOICE-PLUS-PPO
CLMCLM-4064412026-01-05T08:46:36ZPriya—Stone06/10/1946UHC-32131-64•••-••-2973(971) 223-0293N/A8768 Bayshore DriveEDEN PRAIRIEMN··55373GRP-2463UNKNOWN
ENRENR-1350962026-09-17T05:44:32ZDanielWBennett1976-03-28·UHC-68092-51•••-••-66113526396—1864 MARKET STREETAustinTX78761GRP-7616·SELECT-EPO
ENRENR-1012612026-08-02T14:37:57Znathan—cunninghma1958-01-07UHC-29480-48•••-••-1986291-953-9928nathan.cunningham@yahoo.com2045 Sage CtTempeAZ85204GRP-6692MEDICARE-ADV-B
ENRENR-1186182026-06-13T11:59:45ZSantiagoQBlack03/02/82UHC-79415-28··•••-••-46956048707858santiago.black@yahoo.com1674 Meadow LaneMiamiFL33126·GRP-4080CHOICE-PLUS-PPO
CLMCLM-4120932026-02-09T17:50:15Z miller—billy··28-04-1959-•••-••-0985NULLnull3528 Baseline Road·ScottsdaleAZ85202GRP-4533·MEDICARE-ADV-A
CLMCLM-4083792026-01-15T20:01:23ZRalph—Graham27-01-1981NULL•••-••-0229(401) 440-9012UNKNOWN3792 Palm Drive Apt 22San DiegoCA92127GRP-8922—
100,000 rows, page 49 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:34.778Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty