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-1165482026-01-19T19:07:45ZJESSE—ROSS1940-07-10UHC-10623-58—294.948.2011jesse.ross81@proton.me8651 Jefferson AvenueLos Angeles·CA90020GRP-8215SELECT-EPO
TPATPA-616102026-02-23T11:45:13Z—G—04-02-1978—•••-••-4414—·NULL3675 Sage CtTucsonAZ85780NULL····
ENRENR-1033392026-06-26T15:12:35ZLong, Adam—··2008-07-05UHC-08708-37•••-••-14372146031253adam.long76@icloud.com217 VALLEY VIEW DRIVEPlanoTX75043·GRP-3413CORE-HMO
CLMCLM-4191022026-06-10T14:41:55ZJulia····Alexander08/02/93UHC-68877-99nullUNKNOWNN/ANULLN/AN/A—-NULL
ENRENR-1421512026-08-09T19:01:30ZJULIA····HICKS1983-05-13UHC-00561-02•••-••-0035371-352-7640julia.hicks95@outlook.com4145 Elm StPhoenixAZ·85010-7363GRP-0642MEDICARE-ADV-B
ENRENR-1194132026-04-10T12:20:31ZCynthia··X.Andrews1980-11-24·UHC-70291-44•••-••-9478(558) 549-0738CYNTHIA.ANDREWS@HOTMAIL.COM3509 Canyon RdNASHVILLE··TN··37251GRP-7890NAVIGATE-HMO
ENRENR-1223122026-03-25T06:15:00ZChristopher—Dixon1953-03-19··UHC-08912-57•••-••-7967987-727-6689christopher.dixon@icloud.com2285 HIGHLAND AVECHARLOTTENorth Carolina28298·GRP-1666choice-plus-ppo
ENR ENR-1381502026-04-17T16:48:04ZSaaYGreene1968-00-39UHC-27441-33•••-••-4264319-486-0136NULL8734 WILLOW CTLos AngelesCAN/AGRP-4483OPTIONS-PPO··
ENRENR-1331422026-03-22T04:57:42Zmark—jacobs··1980-06-09UHC-36737-62•••-••-587418449756221··MARK.JACOBS16@PROTON.ME5805 Ridge RoadEden PrairieMN55358GRP-5640MEDICARE-ADV-A
CLMCLM-4249592026-09-26T02:37:17ZJesseJWeaver1958-11-12UHC7684880—749.492.7515··UNKNOWN4153 VALLEY VIEW DRIVEFresnoCA93784GRP-7637MEDICARE-ADV-B
TPATPA-536992026-07-11T06:49:09ZAdams, Jacqueline——1996-06-09NULL—(451) 722-3182jacqueline.adams@hotmail.com5404 Spring StreetHoustonTX77067··NULL—
ENRENR-1179182026-05-06T11:21:03ZCarl—Dunn08/26/2005UHC-36015-71··•••-••-9562902.411.3018carl.dunn25@aol.com4149 Ridge RdMesaAZ85223GRP-5536OPTIONS-PPO
ENRENR-1185722026-04-23T13:41:05ZJessicca··—Wang2003-01-20UHC-04085-61—465.332.5459null··5652 MEADOW LANE·SacramentoCA95839-7206GRP-8313MEDICARE-ADV-A
ENRENR-1278222026-03-25T01:56:10Z·Isabella—Cruz1986-10-24UHC-73824-92•••-••-6989214-561-4888isabella.cruz@yahoo.com4145 Palm DrTampaFL33689·GRP-1845NAVIGATE-HMO
CLMCLM-4244462026-09-02T03:47:05ZWheeler, Angela——1952-02-15UNKNOWN—3758530687-1829 GRAND AVENUE #630Jacksonville··FLNULLGRP-6763—
ENRENR-1349752026-10-01T01:24:35ZCynhiaHStephens1957-04-06UHC-44022-07•••-••-66652173893906cynthia.stephens@gmail.com8209 Bayshore Drive Apt 25Atlanta·GA30364GRP-1614CHOICE-PLUS-PPO
TPATPA-584102026-03-05T17:53:46ZNicole—Carr1961-06-14UNKNOWN•••-••-7392·-NULL7331 Pine DrPhoenixAZ85053nullMEDICARE-ADV-B
CLMCLM-4038372026-03-23T18:41:33ZchristopherHwalsh··Jan 11, 1987UHC-69478-96-(693) 505-5116—5458 Indian School RdScottsdaleAZ85286-3002nullMEDICARE-ADV-A
PRVPRV-204952026-05-20T12:20:22Z MARTHA··SIMMONS2002-02-09NULLUNKNOWN-UNKNOWN··1191 Park PlaceAtlantaGA30306-null
ENRENR-1279072026-07-30T19:53:42ZDiego····HolmesDec 1, 1973UHC-69313-48•••-••-075417772756459diego.holmes62@yahoo.com1427 Palm Drive·TEMPEAZ85241GRP-7461CHOICE-PLUS-PPO
ENRENR-1287912026-04-11T05:49:40ZJESSEABALCK05/08/2001UHC-15116-96•••-••-6593371.393.6198JESSE.BLACK@ICLOUD.COM··9697 Highland AvenueFresnoCA93736GRP-8093SELECT-EPO
TPATPA-566282026-10-04T07:15:04ZCarter, Amanda——2008-02-14———N/A—--NULLGRP-1951—
CLM CLM-4271952026-06-23T18:13:02ZWilliam····Rose1964-03-08····•••-••-3578(855) 312-3142—5030 Cedar LanePhoenixAZ85035··GRP-0887—
ENRENR-1330612026-02-27T15:55:06ZBeverlyE.Nunez··1952-01-05UHC-25845-36null7086295485beverly.nunez@aol.com··8457 Desert Sky BlvdSan DiegoCalifornia92174GRP-6241OPTIONS-PPO··
ENRENR-1268982026-02-27T02:42:52ZArjun—Wrad1947-05-05UHC-36964-14•••-••-1903+1 365 549 2987arjun.ward@proton.me8909 HARBOR BOULEVARDTempeAZ·85298GRP-2443MEDICARE-ADV-A
CLMCLM-4146622026-03-10T15:52:49ZSue—Carr2004-06-19nullUNKNOWNNULLnull8577 Spring Street #711CharlotteNC28263GRP-5326OPTIONS-PPO
CLMCLM-4189362026-03-18T11:46:57ZEUGENE··—FULLER08/22/1947-NULL4076674723UNKNOWN738 Market St #787MinneapolisMN··55473N/Anull
CLMCLM-4001222026-08-27T06:25:44ZSofia—Lawson09/07/63UHC-68415-31NULLNULL·null——NULLUNKNOWNGRP-7674MEDICARE-ADV-B
ENRENR-1327802026-03-02T16:44:06Zwalter—fisherJan 10, 1978UHC-31315-20•••-••-89393272709538walter.fisher@yahoo.com·8228 RIVER RDTucsonAZ85749GRP-1686CHOICE-PLUS-PPO
ENRENR-1416042026-09-20T01:43:16ZArjunBMiller1987-05-08UHC-81052-83•••-••-6844——2069 Washington StreetGilbertAZ··85222GRP-9901SELECT-EPO··
CLMCLM-4163172026-03-15T00:30:29ZCharlotte—Le1980-08-17UHC8822335NULL7436252642UNKNOWN3814 MESA DRIVECharlotteNC28217-2625—-
CLMCLM-4037482026-05-05T22:59:22ZHENRYF···LITTLE26-12-1944·null·N/A-··UNKNOWN266 CAMELBACK ROAD Apt 29AtlantaGA30361-—
PRVPRV-274762026-03-24T02:09:36ZARTHUR—WASHINGTON2000-07-27UHC-09983-59—null-7566 Willow CtGilbertaz·85294·NULL-
CLMCLM-407645 2026-09-24T03:51:58ZDiana—Ryan09/14/1945-NULL(674) 254-3948—5268 Canyon RoadSCOTTSDALEAZ85200··NULL
CLMCLM-4047772026-06-11T02:12:25ZMaria—Ray1984-02-16UHC0246483N/A-—6515 Market StreetGlendaleAZ·85309GRP-7860CORE-HMO
CLMCLM-4094312026-10-04T21:03:40ZAHMEDT.LE2003-06-10UHC-34122-14•••-••-2609—UNKNOWN1420 WASHINGTON ST #228Las VegasNVUNKNOWN··GRP-5547—
TPATPA-550132026-04-10T02:39:53ZBilly—AlexanderApr 5, 1946UHC-77283-87NULL(481) 481-7040—1182 Central AveTampaFL33694-N/A
ENRENR-1222512026-07-01T09:17:12ZSims, TunyN—1943-03-18UHC-91881-23•••-••-0763375-844-6222null4987 MAPLE AVENUEJacksonvilleFL32259GRP-1824OPTIONS-PPO
CLMCLM-4120852026-05-10T23:37:43ZKyle—HarveyOct 27, 1976UHC-55261-28UNKNOWN890.427.1769—4135 Sage CourtSan DiegoCA·92196GRP-2967—
ENRENR-1163402026-10-05T08:15:23ZKen—George10/13/1945UHC-44938-15··•••-••-1006550-761-5240kenneth.george15@outlook.com8887 Pine DrTucsonAZ85749GRP-5899MEDICARE-ADV-A
CLMCLM-4212612026-10-06T06:39:28ZDOROTHY—BRADLEY1952-09-12UHC-61130-89•••-••-38756219104998dorothy.bradley7@proton.me634 Canyon RoadSeattleWashington98100GRP-3375CHOICE-PLUS-PPO
ENRENR-1110872026-05-15T11:36:32Z Patricia··H.Chavez04/09/1998UHC-71200-93•••-••-6229351.509.7804patricia.chavez@aol.com3111 DESERT SKY BLVDDenverCO80237GRP-6401select-epo
PRVPRV-274652026-07-14T19:01:27ZLucia—Williams1996-04-13nullNULL····lucia.williams86@hotmail.com7236 Central AvenueSAN ANTONIOTexas78247NULLN/A
PRVPRV-265002026-10-14T14:29:45ZSaara—WilliamsNov 20, 1983——3034258929NULL5208 Sunset BlvdChandlerAZ85252—null
ENRENR-1310712026-07-14T11:40:48ZAmberF.Hayes1960-03-15UHC-24192-40•••-••-6652828-883-4280amber.hayes19@proton.me·NULLN/AN/A—·GRP-7664SELECT-EPO··
ENRENR-1244802026-08-02T01:06:03ZCYNTHIA··—GRYA1986-06-08UHC-12777-98•••-••-3724451-413-2650cynthia.gray65@icloud.com7290 WASHINGTON STJacksonvilleFlorida··32214GRP-8709NAVIGATE-HMO
TPATPA-544202026-08-30T15:34:29ZRuth—Herrera02/24/1960··NULLUNKNOWNUNKNOWNnull6473 CEDAR LNMinneapolisMN55477—·OPTIONS-PPO
PRVPRV-230492026-04-18T11:00:19Zronald—dominguuez1989-05-26UHC-96584-75•••-••-8755N/ARONALD.DOMINGUEZ@AOL.COMnull—NULL—UNKNOWN—
ENRENR-1277072026-01-21T11:05:29ZMADISON I—FISHER1940-11-14UHC-88122-62•••-••-1653-MADISON.FISHER@AOL.COM2191 River RoadTAMPAFL33675GRP-2307SELECT-EPO
CLMCLM-4298182026-01-14T01:11:32ZGomez, JacobK—19760710uhc-45306-71·null253-237-5044NULL6461 Valley View DrATLANTAGA30380GRP-6772CHOICE-PLUS-PPO
100,000 rows, page 156 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.702Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty