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

Enrollment only, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
ENRENR-1269502026-03-02T10:03:53ZBETTYFWALLACE1956-10-16UHC-43761-16—455-839-2726BETTY.WALLACE84@HOTMAIL.COM7130 Union StreetLos AngelesCA90013-4132GRP-0449CHOICE-PLUS-PPO··
ENR ENR-1377752026-07-01T12:37:23ZRUSSLL··LWEAVER1962-04-14UHC-60979-31•••-••-594018425905281null·nullUNKNOWNUNKNOWN—GRP-2916CHOICE-PLUS-PPO
ENRENR-1105342026-06-27T19:56:23ZSharonSVargas19480513UHC-88338-95··2778867865sharon.vargas@yahoo.com6258 BASELINE RDSeattleWA98102·GRP-9644CHOICE-PLUS-PPO
ENRENR-1394042026-01-04T13:42:04ZSara—Little1950-40-16UHC3543169-7267674899sara.little@icloud.com6080 MESA DRAtlantaGeorgia30327GRP-1970OPTIONS-PPO
ENRENR-1191082026-04-24T11:31:49ZJANIICE··MHENRY2003-05-27UHC-41645-82null(322) 941-9839janice.henry22@outlook.com·4920 OCEAN AVEMiamiFL33190GRP-0509MEDICARE-ADV-B
ENRENR-1333792026-03-06T00:05:17ZArthur—Perry··20070708UHC-93352-56•••-••-9886(277) 400-2947arthur.perry@icloud.com1538 Forest AveMesaAZ85270GRP-5553MEDICARE-ADV-B
ENRENR-1387502026-08-26T14:40:39ZGloria—Harrt1993-10-17UHC-13895-96•••-••-7557+1 296 602 0815gloria.hart@icloud.com7780 MESA DRIVEDallasTX75221GRP-8932OPTIONS-PPO
ENRENR-1111892026-05-18T21:44:28ZRICHARDI·OLIVER1966-04-09UHC-53963-27•••-••-90033038586680richard.oliver31@yahoo.com·4100 Valley View DrCharlotteNorth Carolina28285-6132GRP-5317MEDICARE-ADV-B
ENRENR-1057852026-02-16T13:50:32Z·noahN.weber1956-12-23··UHC-61800-97•••-••-2005298-465-4134N/A9454 CHURCH STDENVERCO·80243GRP-0835OPTIONS-PPO
ENRENR-1215062026-02-18T13:35:21ZMaryOHiccks1964-01-18UHC-62149-64NULLnull··-4649 Camelback RdChandlerAZ85217GRP-4496CORE-HMO
ENRENR-1236972026-10-13T00:35:37ZCARLOSY.GREENE1985-01-11UHC-83628-08N/A(476) 630-6769—8295 Union St··NashvilleTN37205GRP-4463CHOICE-PLUS-PPO
ENRENR-1054402026-01-06T05:29:19Z·JimPLaane2003-06-20UHC-42402-75•••-••-4112·6565527790—8488 BASELINE ROADLas Vegas·NV—GRP-7613SELECT-EPO
ENRENR-1304952026-09-08T06:37:06Z·MATTHEWKFERNANDEZ23-01-1973UHC-58401-45•••-••-66103693712937N/A9597 Ridge RoadSACRAMENTOCA95807GRP-3817MEDICARE-ADV-A··
ENRENR-1198822026-07-23T15:25:32ZGLORIAGWAGNER1996-10-14UHC-43173-28•••-••-6223296-950-7994GLORIA.WAGNER21@YAHOO.COM928 FOREST AVEPlanoTexas·75051GRP-7655MEDICARE-ADV-B
ENRENR-109000 2026-07-17T00:08:46ZMARCUSULEE19730119UHC-68026-96-NULLmarcus.lee67@icloud.com8291 River RdGlendaleAZ85341GRP-3179NAVIGATE-HMO
ENRENR-1228872026-06-03T01:38:30ZGarrett, LindaZ—03/06/1979UHC-28085-18•••-••-3768(367) 913-4093LINDA.GARRETT79@OUTLOOK.COM8977 HILLCREST RDTempe··Arizona85255GRP-1038CHOICE-PLUS-PPO
ENRENR-1354852026-03-07T07:07:26ZParker, EmilyR—12-12-2008·UHC-78781-60•••-••-1613·5744718767emily.parker88@proton.me4293 Lake View RoadJacksonvilleFL32200GRP-3101NAVIGATE-HMO
ENRENR-1401122026-01-15T19:17:35ZJulie—Wilson1948-09-17UHC-32209-85•••-••-5773334-342-1054·julie.wilson@proton.me6180 Canyon RdOrlandoFL32839GRP-7061MEDICARE-ADV-B
ENRENR-1148112026-06-03T01:11:16Zjudy—richardson2004-04-17UHC-53962-08•••-••-554419666664839judy.richardson10@hotmail.com7855 Bayshore DrColumbusOH43226GRP-5049MEDICARE-ADV-A
ENRENR-1280732026-03-29T12:21:45ZROBERTCPETERSON06/27/1965UHC0824263•••-••-5233(894) 377-1501ROBERT.PETERSON@ICLOUD.COM9031 Jefferson AveAustinTX··—GRP-3165·NAVIGATE-HMO
ENRENR-1149432026-01-25T16:19:07ZCHARLOTTEJWATSON27-08-1969UHC-45410-02•••-••-2647458-948-2383—429 Pine DriveATLANTAga30356GRP-4003CORE-HMO
ENRENR-1394672026-02-16T14:44:21Z HANNAH—HOWELL1938-12-24UHC3314204··•••-••-773719762549223—550 Palm Drive··Plano··Texas75033GRP-9213CORE-HMO
ENRENR-1323152026-01-06T08:59:07ZRebeccaLPalmer19610118UHC-84842-07··•••-••-064415843950447rebecca.palmer@gmail.com5599 Market St #674LAS VEGASNV89143GRP-2226OPTIONS-PPO
ENRENR-1078692026-03-29T12:14:34ZKayla—·Vega1974-12-11UHC-33581-29•••-••-9628—kayla.vega@proton.me6625 VALLEY VIEW DRChandlerAZ·85200GRP-0625OPTIONS-PPO
ENRENR-1086562026-03-02T11:10:27ZJOSEOROBERTS12-07-1942UHC-90725-16•••-••-7900925-351-2221-1301 Elm St #711JacksonvilleFL-GRP-4710MEDICARE-ADV-A
ENRENR-1364632026-04-24T07:07:25Z·Joan—·Clark1944-05-16UHC-71989-42UNKNOWN405-533-7590null1521 Lake View RdCOLUMBUSOhio43206GRP-6688SELECT-EPO
ENRENR-1112282026-06-16T01:38:19ZLARRY—SPENCER19610401UHC-08518-76··•••-••-2081671-959-7345-3145 Sunset BoulevardAustin·TX78795·GRP-1690MEDICARE-ADV-B
ENRENR-1031632026-02-17T09:34:40ZJoyce—Carr1976-08-01UHC-88883-33null8094062738null··UNKNOWNN/Anull—GRP-1849SELECT-EPO
ENRENR-1265672026-08-27T09:26:50ZBenW.Wood1948-01-20UHC-35372-72-+1 598 558 8953benjamin.wood78@outlook.com4794 Elm StreetDallasTX75244GRP-7491SELECT-EPO
ENRENR-1329502026-06-24T01:20:36ZHeenGPatel1995-03-27UHC-69833-28•••-••-6045(778) 379-0438HELEN.PATEL49@AOL.COM3185 VALLEY VIEW DRNashvilleTN37228-9928GRP-5659SELECT-EPO
ENRENR-1401362026-05-28T12:54:01ZAlbertEStephens1990-04-16UHC-75807-75•••-••-10315686903294—5158 VALLEY VIEW DRSeattleWAnullGRP-5602MEDICARE-ADV-A
ENRENR-1036382026-07-27T11:00:56ZKIMBERLY—STEWART2000-06-04UHC-59591-67•••-••-6585(225) 820-5088KIMBERLY.STEWART23@ICLOUD.COM6267 Forest Ave··SACRAMENTOCA95806GRP-5592core-hmo
ENRENR-1002262026-09-07T19:09:11ZHarold—Lna1988-01-19·UHC-54634-39•••-••-0664(952) 706-6738····3319 Washington StreetJacksonvilleFL32225GRP-7032MEDICARE-ADV-A
ENRENR-1047272026-06-14T09:15:57Z BETY·SGUTIERREZ1976-01-26··UHC-29030-63•••-••-6308—N/A6971 Union StPlanoTX·75024GRP-3072SELECT-EPO
ENRENR-1365062026-09-06T17:31:34ZMaria—Wells19710317UHC0004714—(698) 738-6165··MARIA.WELLS@HOTMAIL.COM5314 Apache BoulevardSan DiegoCA-GRP-1985NAVIGATE-HMO
ENRENR-1147172026-08-06T17:55:03ZBrandonMBennett1950-02-23UHC-33676-78NULL·673-220-8340brandon.bennett35@aol.com3332 Bayshore DrSacramentoCA95871GRP-6214NAVIGATE-HMO
ENRENR-1396162026-08-12T22:22:18Zphilip—olson09/07/2007UHC-22797-90•••-••-2825(885) 808-6728PHILIP.OLSON@OUTLOOK.COM··4297 Indian School RdNashvilleTN37257-1568GRP-7255MEDICARE-ADV-A
ENRENR-1259722026-08-25T12:27:38ZNancy—Wheeler1954-10-17··UHC-30050-23-404-617-8912nancy.wheeler@aol.com7227 Pine DriveEden PrairieMN55390GRP-2838MEDICARE-ADV-A
ENRENR-1254872026-02-20T17:44:12Znicholas·Echapman12/16/89··UHC-54420-73•••-••-55542955851963··nicholas.chapman38@outlook.com9856 Elm StDallasTX75235GRP-9810MEDICARE-ADV-A
ENRENR-1384272026-04-26T08:23:24Z JOSEPHIRILEY1974-11-28UHC-21875-34•••-••-0012(514) 550-2294··joseph.riley@yahoo.com6915 Hillcrest RoadGilbertAZ··85223-1789GRP-3234CHOICE-PLUS-PPO
ENRENR-1411452026-08-10T21:45:37ZJAMESPNGUYEN1974-02-28UHC0890410•••-••-2377(419) 694-3278james.nguyen50@proton.me3516 Park PlaceAtlantaGA·30314GRP-7814CORE-HMO
ENRENR-1055282026-05-27T14:56:42ZMARY—PORTER1999-04-07··UHC-89619-36•••-••-59817577122MARY.PORTER@AOL.COM2549 Spring Street Apt 22HoustonTX··77090-4835GRP-7030OPTIONS-PPO
ENRENR-1036232026-03-13T00:41:13ZSamanthaIPrice1999-10-01UHC-90282-61•••-••-3042947-254-4690··—3739 Maple AvenueTucsonAZ85799GRP-6695CHOICE-PLUS-PPO
ENRENR-1252762026-06-08T04:40:31ZfrankYramos1962-04-07UHC-76600-57-—N/A8980 Ridge RdLos AngelesCA90072GRP-4204CHOICE-PLUS-PPO
ENRENR-1169872026-04-10T06:25:22ZMEGAN—·BOYD1991-11-04UHC-11001-98N/A(417) 613-1011megan.boyd28@hotmail.com4484 Bayshore Drive Apt 25ColumbusOH43238GRP-5237NAVIGATE-HMO
ENRENR-1200632026-06-03T08:10:35ZRiceQLawrenceNov 14, 1963UHC-04124-95•••-••-44392524895991LAWRENCE.RICE20@ICLOUD.COM7553 Harbor BoulevardTampaFL33632GRP-1729SELECT-EPO
ENR ENR-1079172026-10-04T19:16:07ZScott—Santos01/22/61·UHC-47962-91•••-••-244314492652066scott.santos56@aol.com4540 Jefferson Ave·San AntonioTX-GRP-8483·MEDICARE-ADV-B
ENRENR-1347732026-08-14T17:48:51ZdeniseDsmtih1962-02-23UHC-92718-75•••-••-6685(772) 246-4564denise.smith@outlook.com3876 Baseline RdTucsonAZ85705GRP-9201MEDICARE-ADV-A
ENRENR-1090692026-08-01T21:50:49ZREBECCA—RICHARDSONSep 23, 1998UHC-74913-63•••-••-8067—rebecca.richardson@yahoo.com5170 LAKE VIEW RD·Eden PrairieMinnesota·55316GRP-5862CORE-HMO
ENRENR-1242992026-07-12T14:14:02ZLawrenceP··RussellAug 5, 1987UHC-94134-10•••-••-756612872850074lawrence.russell38@hotmail.com1418 River RdDallas··TXUNKNOWNGRP-8287CORE-HMO
43,101 rows, page 121 of 863PreviousNext

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