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-1275282026-05-04T03:15:44ZFrancesK.Hudson1954-05-17UHC-60488-02•••-••-8373(837) 483-1360FRANCES.HUDSON@YAHOO.COM9405 Willow Ct Apt 15NashvilleTN37246GRP-0719·MEDICARE-ADV-A
ENRENR-1055012026-03-18T10:59:37Zphiilp—bell1989-06-25UHC-78034-52•••-••-6545(840) 312-1915philip.bell@yahoo.com2564 Palm Drive #240FresnoCA93722GRP-8658MEDICARE-ADV-A
CLMCLM-4239552026-07-13T05:05:50ZTyer—Edwards1988-03-04UHC-69572-78null(842) 508-1422NULL8005 Church St #102Los AngelesCalifornia90056GRP-6863null
CLMCLM-4137972026-06-15T01:43:21ZMatthewHHall···1983-03-09—•••-••-2867——UNKNOWNnullNULLNULL—null··
CLMCLM-4197402026-09-05T19:29:08ZKATHRYN—DAY1982-11-24UHC-37330-92·UNKNOWN4948845985··6913 River RoadCharlotteNC28278·GRP-2857medicare-adv-b
TPATPA-633152026-06-09T15:29:18ZJOHN—MATTHEWS·1957-08-27UNKNOWN•••-••-8653null-5065 Indian School Rd··PlanoTexas75029·GRP-9140-
CLMCLM-4268752026-02-10T20:17:35ZHENRY—WATSON··1/3/1964—null—N/A2496 Valley View DrCharlotteNC28279··GRP-3046··
CLMCLM-4227272026-03-21T00:55:16ZBenjamin—Fuller03/15/1964UHC-11971-67——UNKNOWN4702 Spring St·NASHVILLETN37237GRP-7658NULL
TPATPA-507852026-01-08T12:30:45ZSarah—Lawson9166-05-06—N/AUNKNOWNnull3210 Market StNashvilleTN—-NAVIGATE-HMO
CLMCLM-4211452026-08-31T07:12:15ZTONY··WALSH1957-03-18UHC-21787-35--····7990 VALLEY VIEW DRIVE··SEATTLEWA98169——
PRVPRV-276232026-10-02T09:51:50ZEthan—Chavez09/10/89UHC-17655-21•••-••-6293(719) 930-2937—7974 Lincoln WayDenverCO80250—UNKNOWN
ENRENR-1047872026-09-25T21:54:34ZSean—Clark···Dec 9, 1973UHC-83360-30•••-••-4259nullsean.clark@gmail.com6639 Mountain View DriveSacramentoCA95813··GRP-9850NAVIGATE-HMO
CLMCLM-4162192026-05-08T18:15:31ZRogers, Kyle——1941-02-15UHC-43750-48•••-••-0703(577) 203-8067-—N/A·-—GRP-2942options-ppo
CLMCLM-4119032026-07-01T03:18:41ZElizabeth—Dominguez1974-03-10UHC-35965-93—676.627.4170UNKNOWN4119 CHURCH STREETCharlotteNC28251N/AOPTIONS-PPO
TPATPA-528232026-03-21T13:43:52Z Billy—Hunt1995-07-25N/A··•••-••-5328UNKNOWN————UNKNOWNnull—
ENRENR-1305942026-06-21T17:54:58ZCHARLOTTE—LAWRENCE1946-05-15UHC-14351-68•••-••-8783909-960-7677CHARLOTTE.LAWRENCE23@HOTMAIL.COM8224 Valley View DriveMinneapolisMN55457GRP-6212core-hmo··
CLMCLM-4109042026-07-07T20:30:59ZCharles—Dunn1993-10-24UHC-26801-85-8153372CHARLES.DUNN@ICLOUD.COM4956 MEADOW LNColumbusOhio43288—OPTIONS-PPO
TPATPA-557982026-05-08T06:42:20ZGibson, Roger——Dec 6, 1942null—nullNULL2278 Canyon Rd··San DiegoCA··92154-6728NULLN/A
PRVPRV-29552 2026-10-06T04:30:38ZWei—Mason1982-09-01UNKNOWN-550.437.3701null9839 Palm Dr #990SeattleWashington98103——
PRVPRV-263432026-07-30T08:43:27ZJOEGSTEWARTFeb 11, 1953UHC-21317-80-+1 526 234 6068null··286 Sage CtLos AngelesCA90063-3171—NULL
ENRENR-1199832026-03-09T06:53:44ZANAYGUTIERREZ24-01-1962UHC-95156-71•••-••-5127·807.672.5741ana.gutierrez43@yahoo.com··4154 Valley View DriveColumbusOH43243GRP-9599MEDICARE-ADV-B
PRVPRV-229482026-01-15T21:42:22ZCarool····Kim2007-10-18··UHC-04642-40•••-••-1904——565 Meadow LnTucsonAZ——NULL
CLMCLM-4306562026-08-09T17:29:32ZValentina—White19581018—null·744-200-7947N/A7046 Hillcrest RdMINNEAPOLISMN55412NULLUNKNOWN
TPATPA-576192026-01-22T13:19:25ZArjun—Holmes··11/22/1978-—UNKNOWN··—5851 MAIN STREET #229GlendaleAZ85333N/ACORE-HMO
TPATPA-521922026-03-20T13:55:47ZArthur—ContrerasOct 20, 1943—-333.994.8394null3294 Baseline RoadJacksonville··FL32277nullN/A
ENRENR-1266782026-07-25T20:30:38Z·LoganU.Fields1991-08-03··UHC-12290-95··•••-••-3579+1 978 709 4139logan.fields92@icloud.com5038 Main StreetPhoenixAZ·85031GRP-3093NAVIGATE-HMO
ENRENR-120444 2026-07-26T06:13:41ZJackie····Parker1993-11-17uhc-11243-95•••-••-7018+1 946 521 8534jacqueline.parker8@aol.com4759 Mesa Dr·MesaAZ85254GRP-0979MEDICARE-ADV-B
PRVPRV-262432026-07-08T00:25:46ZJeremy—Sullivan10/18/81UHC-15896-37-523-917-6767jeremy.sullivan@icloud.com5808 Camelback RdColumbusOH43237-null
TPATPA-581682026-09-22T12:15:16ZRalph··—Knight1995-10-12N/A—nullUNKNOWN7040 Palm Dr··DENVERCO80237·GRP-6349—
ENRENR-1223302026-03-03T08:09:50ZLuisYJackson1992-06-25UHC-64643-91•••-••-1772(452) 715-5097luis.jackson9@yahoo.com2919 Park PlaceMinneapolisMinnesota··55476GRP-1528CHOICE-PLUS-PPO
ENRENR-1085352026-02-17T02:51:46ZLawrence E.··Mitchell1940-07-19UHC-30433-13•••-••-05336425815350lawrence.mitchell80@outlook.com5724 Hillcrest Rd Apt 11COLUMBUSOhio43221GRP-8079MEDICARE-ADV-A
ENRENR-1269622026-03-16T05:31:35ZAbigailU.Peters2003-10-20UHC-38914-38•••-••-6956+1 414 530 9293··abigail.peters41@icloud.com8838 Elm StAtlantaGA30373-9201GRP-8040CORE-HMO
TPATPA-588942026-07-15T19:21:13ZHEATHER—FREEMAN1961-09-08-•••-••-35352063831906HEATHER.FREEMAN46@PROTON.ME2537 GRAND AVEOrlandoFL32846—UNKNOWN
CLMCLM-4034292026-06-01T04:09:12ZCole, Aisha——1975-04-01·-····+1 459 341 6989-4922 Cedar LaneMINNEAPOLISMN55410GRP-5066·MEDICARE-ADV-A
ENRENR-1025482026-02-14T18:34:25ZBOBBYCCOOPER1940-02-01uhc-01816-03•••-••-48678540115bobby.cooper6@yahoo.com9529 Hillcrest RdGILBERT·AZ85286-7666GRP-6042MEDICARE-ADV-B
CLMCLM-4176052026-10-11T13:20:32ZArthurT.Gibson25-09-1982UHC-31926-06•••-••-7626—UNKNOWN··UNKNOWN-UNKNOWN—NULLNAVIGATE-HMO
CLMCLM-4099982026-10-17T06:38:46ZPAMELA—·HICKS·09/04/90N/A-(233) 690-0495NULL6514 MOUNTAIN VIEW DRPlanoTX75056-4181GRP-9479-
ENRENR-1020682026-06-23T19:31:31ZSTEPHANIEL··MILLER1992-05-27UHC-50204-08•••-••-9052+1 609 203 9771stephanie.miller26@yahoo.com339 CENTRAL AVENUE #176··JacksonvilleFL32212··GRP-2979OPTIONS-PPO
PRVPRV-252302026-09-16T23:57:46ZBRITTANYX.ROOMERO1966-01-05UNKNOWN—528.938.6055—1928 Maple AveAustinTXUNKNOWN——
PRVPRV-204892026-05-13T20:10:58ZLucia—Perkins1968-10-09UHC6444021NULL6769825008lucia.perkins@gmail.com9799 WASHINGTON STREETDenverCONULL—NULL
ENRENR-1083052026-05-31T00:28:36ZLarson, Donna——10/27/1939UHC-17183-32•••-••-0668245-666-2754-9649 Apache Blvd·AtlantaGA··30362GRP-4394SELECT-EPO··
ENRENR-1013512026-08-23T15:25:54ZWilliam—Knighht1947-04-10UHC-94551-87NULL6167086143william.knight25@proton.me3097 SAGE CTSeattleWA98196GRP-5550CHOICE-PLUS-PPO
TPATPA-561522026-07-12T00:56:29ZJOYCE—REYES2008-12-04—•••-••-0209—joyce.reyes86@proton.me1156 BroadwayDallasTexas-NULLCORE-HMO
ENRENR-1274222026-08-27T03:00:00ZSCOTT—HALL2003-02-18UHC-57013-81•••-••-08297217117160scott.hall84@yahoo.com2441 MAPLE AVENUE #466JACKSONVILLEFL··32208GRP-8169options-ppo
CLMCLM-4105822026-07-31T13:32:45ZWALTERS.GRIFFIN26-02-1960UNKNOWNN/AUNKNOWN—6093 Hillcrest RoadCOLUMBUSOH43295GRP-2295-
PRVPRV-280572026-09-12T03:15:26Z·LisaFEvans5/23/1994—•••-••-0224—null3982 Willow Ct··Los Angelesca·90056N/AN/A
CLMCLM-4265122026-05-18T22:37:40ZBRIAN—CARPENTER09/10/1975UHC-74079-84•••-••-06955332447——nullN/A·UNKNOWNGRP-9712—
ENRENR-1010782026-01-06T21:44:40ZHIROSHIX.ARMSTRONG03-11-1952UHC-54673-76NULL5022261479null9809 LINCOLN WAYScottsdale··AZ85299GRP-1322MEDICARE-ADV-A
TPATPA-579882026-05-25T01:59:07ZLUCIANMONTGMOERY12/09/47NULL—+1 651 739 0159N/A2513 HARBOR BLVDHoustonTX77084-5814—··
ENRENR-1417852026-08-25T18:02:45ZRICHARD··SHAW1996-02-03null•••-••-371319093629129richard.shaw@yahoo.com1104 JEFFERSON AVE·MinneapolisMN·55424GRP-5560MEDICARE-ADV-A
100,000 rows, page 206 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:37.723Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty