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-1103762026-09-06T13:10:01ZAmanda—Riey1976-07-09UHC-52383-08•••-••-39223163693180amanda.riley@aol.com1061 Sunset BoulevardAtlantaGA··30316-5893GRP-2765MEDICARE-ADV-A
CLMCLM-4227902026-02-18T04:30:06ZSHARON····GARZA9194-02-05UHC-74021-28··null4233349UNKNOWN9247 Highland AveColumbusOH43298N/ANULL
TPATPA-533352026-03-11T04:40:24ZnicoleTmunoz·19730626UNKNOWN•••-••-6106(430) 415-3850·NULL7046 OCEAN AVENUELos AngelesCA90027nullNULL
CLMCLM-4222162026-08-29T03:35:57ZYuki··—Smith19950228UHC-02831-95NULL4215542241null8941 Highland AvenuePhoenixAZ——SELECT-EPO
ENRENR-1012882026-02-01T09:07:09Z·WilliamBDaniels1941-08-01·UHC-75567-70•••-••-95825252377028william.daniels77@gmail.com1798 RIDGE ROAD··AustinTX78778GRP-7088OPTIONS-PPO
ENRENR-1220992026-01-20T00:23:02ZCYNTHIAIMASON04/06/1975UHC-56670-99•••-••-1247·13617713380CYNTHIA.MASON65@OUTLOOK.COM8767 Central AveFresnoCA93766GRP-4369SELECT-EPO
CLMCLM-4065182026-07-09T15:21:36Z·SARAH—HUDSSON2007-06-07null——NULL7942 Spring StreetEden PrairieMN55302GRP-4226—
PRVPRV-268482026-04-13T00:13:37ZJean—Lawrence19740303UHC-43612-23•••-••-33096409951893N/A3662 Lincoln WayGILBERTaz85292-—
ENR ENR-1093212026-08-28T22:12:13ZALICEN.SPENCER9167-03-01UHC-71190-27N/ANULL—·4684 Mountain View Drive #932HoustonTX77017-4669GRP-1509MEDICARE-ADV-B
CLMCLM-4224052026-05-21T16:15:05ZMeiINunez4/25/1994-•••-••-27312102499405··UNKNOWN1620 Jefferson AvenueGLENDALEAZ85321—CHOICE-PLUS-PPO
ENRENR-1343732026-02-17T08:16:51ZDebraERyan1963-12-24UHC-49221-41—N/Adebra.ryan18@yahoo.com1623 MOUNTAIN VIEW DRIVEMesaArizona85266GRP-7101·CORE-HMO
CLMCLM-4059662026-08-23T11:55:04ZMegan—Long1996-02-20UHC8386854—··NULL9168 Cedar LaneCharlotteNC28240GRP-6591N/A
ENRENR-1015162026-07-03T15:20:30ZEmma—Vasquez8/5/1986uhc-95934-32•••-••-7290919-307-5499emma.vasquez93@yahoo.com1098 Market StDallas··TX·75249GRP-7268CHOICE-PLUS-PPO
PRVPRV-204852026-08-13T13:41:06ZTerry··—·Hansen10/9/1956—UNKNOWN479.889.8424UNKNOWN9836 Camelback RoadGILBERTAZ85294·N/AOPTIONS-PPO
TPATPA-604252026-03-15T14:26:44ZAlbrt—·Santos1975-05-16··——UNKNOWN—7865 Hillcrest Road··AustinTX78726UNKNOWNN/A
ENRENR-1146622026-05-07T12:06:52ZDYYLAN····PALMER2003-10-15UHC-54824-76•••-••-69068592910532-2321 Mesa DriveChandlerAZ85278GRP-3357··medicare-adv-a
CLMCLM-4004732026-05-28T06:11:44ZRACEHL—STEVES1945-10-14UHC7558592··•••-••-3162(346) 480-6818—7985 Pine DrHOUSTONTX77030-—
TPATPA-612082026-05-15T05:17:00ZCruz, JeremyC··1964-04-15N/ANULL5404480026JEREMY.CRUZ@YAHOO.COM9297 Mountain View DriveTempeAZ85299-5615—navigate-hmo
PRVPRV-20596 2026-05-16T10:30:45ZlisaHpayne06-05-1986nullnull460-918-7364NULL··4985 Sage CtAtlanta·GA30333N/A—
TPATPA-605552026-05-05T18:02:21ZKATHERINE—WILSON··09/03/69—UNKNOWN····-2813 Market StEden PrairieMN55330GRP-4271··N/A
CLMCLM-4155952026-03-29T12:00:43ZJackie—·Wang10/24/77UHC-85294-14·NULLN/ANULL6566 Indian School RdTEMPEAZ85266-0348GRP-9353NAVIGATE-HMO
ENRENR-1166422026-01-18T05:54:01ZWeiY.Willis23-11-1982UHC2240111•••-••-0291(959) 240-1674wei.willis@yahoo.com3743 Willow CtOrlandoFL32865GRP-6405NAVIGATE-HMO
TPATPA-500682026-05-02T14:27:41Zmaria—dvis2007-03-12UHC-35556-52•••-••-8882null··5103 WILLOW CTTempeAZ85247—····
ENRENR-106161 2026-03-07T01:34:25ZOLIVIA··MENDOZA19500820UHC-59927-40•••-••-0440(309) 267-7353OLIVIA.MENDOZA@YAHOO.COM5633 Willow CtMesaAZ85279GRP-8083··core-hmo
CLMCLM-4035702026-08-15T06:45:16ZLarson, DennisH—1965-09-05UHC-54035-72•••-••-381015948665211UNKNOWN·290 Camelback RoadCharlotteNC28272NULLnull
CLMCLM-4053232026-05-20T11:25:32Zfrances—miller1989-06-26UHC-20698-15•••-••-628814282930984N/A2646 River RoadMinneapolisMN—-UNKNOWN
ENRENR-1167302026-09-11T02:33:57Z·HaroldPPatterson2603-19-04UHC-04603-36•••-••-8241+1 375 407 5325—226 Harbor BlvdSan AntonioTX78260GRP-8993SELECT-EPO
PRVPRV-240132026-02-15T06:13:46ZPaul··Millls08/05/00UHC-43060-63—(784) 517-0118null5434 Indian School RdPlanoTX——MEDICARE-ADV-B
CLMCLM-4195042026-05-25T07:58:00ZMichelle····Richardson1954-03-05UHC-62808-50UNKNOWN9092002384—7166 BAYSHORE DRIVEMesaAZ85229GRP-6737MEDICARE-ADV-A
TPATPA-638662026-01-24T05:03:09Zkimberly—mills1955-12-07NULL-·NULLN/A9137 Main StGILBERTAZ85208UNKNOWNnull
TPATPA-513082026-01-29T20:49:17ZDigo—West1962-07-26UHC4569522NULL-null3822 BASELINE ROADDallasTX75235··UNKNOWNOPTIONS-PPO
CLMCLM-4106082026-08-24T09:31:11ZMei—Jones05-01-1960——780-985-5942null4164 Central AvenueSAN DIEGOCA92108GRP-3950OPTIONS-PPO
CLMCLM-4239762026-03-11T10:40:14ZLuis—Hunt1946-03-12UNKNOWN——N/A884 WASHINGTON STREETTucsonAZ··85774GRP-2043NAVIGATE-HMO
ENRENR-1423522026-02-12T02:21:09Zjim··Rthompson1980-11-03UHC3591401•••-••-7493—james.thompson@outlook.com6516 Park PlSacramentoCA95829GRP-9706MEDICARE-ADV-B
ENRENR-1394362026-03-05T02:44:01ZHill, Kimberly——1967-08-28UHC-75001-90•••-••-6954(396) 236-2473KIMBERLY.HILL73@OUTLOOK.COM3576 Spring StreetColumbusOH·43287GRP-2759MEDICARE-ADV-A
TPATPA-598812026-06-02T14:07:11ZBILLY····PARRY1982-09-19—•••-••-2911511.441.7958null1501 Lincoln WayLOS ANGELESCA90067N/AN/A
ENRENR-1070272026-05-22T07:01:04Z Hoffman, TheresaF—08-08-1982UHC-15893-12•••-••-08177088151358THERESA.HOFFMAN48@OUTLOOK.COM··null—UNKNOWNGRP-2584·OPTIONS-PPO
ENRENR-1116782026-07-03T01:17:19ZAhmed—Vasquez1956-06-02UHC-88338-81•••-••-1277(746) 238-3231ahmed.vasquez@yahoo.com6948 Camelback RoadGILBERTAZ85282-6388GRP-9981NAVIGATE-HMO
CLMCLM-4212222026-05-12T15:02:19ZChristianB··Butler04/27/82null•••-••-7647·+1 271 631 7792UNKNOWN9899 River RdGlendaleAZ85372N/AMEDICARE-ADV-B
PRVPRV-280652026-02-17T10:13:58ZLAURENRMURPHY··Aug 21, 1969-—923.729.7088null2578 Lake View RoadOrlandoFL32845UNKNOWNN/A
ENRENR-1399792026-07-22T18:38:18ZHENRYURILLEY1989-05-22UHC-56379-27•••-••-19399583325527UNKNOWN6970 Baseline RoadEden PrairieMN55377GRP-5181MEDICARE-ADV-B
CLMCLM-4031202026-08-20T21:37:09ZANDREW··LITTLE1958-05-10UHC8740919null15946673145-7294 Spring StreetChandlerAZ··85257GRP-7751OPTIONS-PPO
ENRENR-1142012026-10-07T11:57:15ZMason, DorothyQ.—1/28/1997UHC-16584-13•••-••-1130UNKNOWNdorothy.mason71@gmail.com·8937 Desert Sky BoulevardGlendale·AZ85340··GRP-5339CORE-HMO
ENRENR-1184032026-05-16T07:47:40ZMasonKLe1954-04-12UHC-76032-71•••-••-0053(605) 753-1126MASON.LE@GMAIL.COM··1454 Camelback RdGlendaleAZ85361GRP-1147MEDICARE-ADV-B
ENRENR-1365102026-02-06T10:22:55ZJoshua—Maldonado··19830618uhc-40498-61•••-••-443619868314055joshua.maldonado@icloud.com2040 Forest AveLas VegasNV89169GRP-6925NAVIGATE-HMO
TPA TPA-563702026-03-18T09:08:07ZDonna—Jacobs1980-04-28N/A•••-••-0462NULL—————GRP-4786null
CLMCLM-4311232026-03-03T01:35:31ZJacob····Allen02-06-1999—•••-••-95156772157641··N/A·6532 RIDGE ROAD·TampaFlorida33626—UNKNOWN
CLMCLM-4316452026-03-25T01:45:17ZBrianEBurke··10/8/1969··UHC-98758-75NULL-N/A1203 Church StreetSan DiegoCA92196···GRP-0890OPTIONS-PPO
ENRENR-1006002026-02-24T18:45:18ZSHIRLEY—LITTLE14-08-1982UHC-65674-05—(319) 764-6821·UNKNOWN2899 OAK STChandlerAZ85276GRP-5816NAVIGATE-HMO
ENRENR-1156872026-01-04T23:59:20Z ROBERT··—DAYJul 6, 1942UHC-61788-03—+1 303 422 4257ROBERT.DAY@YAHOO.COM5242 River RdScottsdaleAZ85251GRP-9765SELECT-EPO
100,000 rows, page 148 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.698Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty