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-1285292026-01-09T14:31:28ZJACQUELINE—STONE19700424UHC-69765-49•••-••-2404(812) 456-7795··jacqueline.stone84@outlook.com607 Apache BoulevardNASHVILLETN—GRP-3248OPTIONS-PPO
ENRENR-1165622026-05-27T07:27:56Zemma—·baker1968-04-15UHC-96233-40—6517014956emma.baker@proton.me4927 Cedar LnMinneapolis··MN55446-0117GRP-2348CORE-HMO
ENRENR-1380032026-09-08T20:07:24ZArjunMValdez1972-04-27UHC-77194-97•••-••-5529(960) 725-4835ARJUN.VALDEZ15@OUTLOOK.COM2107 Mountain View DriveHoustonTX77069GRP-5386SELECT-EPO
ENRENR-1280322026-01-24T14:52:29Z CHARLESVEVANS10/02/1976UHC-13774-38NULL(740) 208-5591··CHARLES.EVANS56@HOTMAIL.COM2088 BroadwayGLENDALEAZ85375GRP-6666CORE-HMO
ENRENR-1353932026-05-19T14:41:07Z ANN—MARQUEZ·UNKNOWNUHC-61611-49•••-••-9086260-854-8739ANN.MARQUEZ92@YAHOO.COM9841 CENTRAL AVEGilbertAZ85252GRP-2069NAVIGATE-HMO
ENRENR-1135412026-05-09T01:43:12ZSANTIAGO—ORTEGA··1951-03-09UHC-77303-84UNKNOWN7813300830santiago.ortega@proton.me4015 CEDAR LNTampafl33676GRP-0999···MEDICARE-ADV-A
ENRENR-1187092026-05-22T04:45:47Zjason—stephens09/23/1988UHC-81155-29•••-••-1029+1 478 243 5297—4786 Union StreetFresnoCA93780GRP-8026··options-ppo
ENRENR-1213382026-07-20T21:45:30ZAaron—Willis01/26/1992UHC-69925-56•••-••-95753095902243·aaron.willis@proton.me·446 GRAND AVEFresnoCA93747GRP-5951·MEDICARE-ADV-B
ENRENR-1095602026-09-23T10:13:50ZLawrenceDMason1941-12-01UHC-19943-94•••-••-82652963988386lawrence.mason67@aol.com2798 Oak StPhoenixAZ85071GRP-9165medicare-adv-a
ENRENR-1352132026-05-05T20:31:24Zbrittany—collins·2006-12-17UHC-30480-05•••-••-33038444243217brittany.collins62@icloud.com4470 LAKE VIEW ROADChandlerAZ85286·GRP-4790CORE-HMO
ENRENR-1346792026-04-28T10:26:23ZMASONZJACOBS12/28/1988UHC-48090-22•••-••-0167(340) 772-9815mason.jacobs93@aol.com4277 River RoadLos AngelesCA90057GRP-2411SELECT-EPO
ENRENR-1200522026-03-05T12:02:07ZDylan—Butler··9/7/2003UHC-22460-47•••-••-3431+1 509 555 8465··DYLAN.BUTLER@GMAIL.COM8514 RIDGE ROADATLANTAGA30330GRP-8542NAVIGATE-HMO
ENRENR-1302492026-02-27T12:29:31ZLucia—Day··02/11/1980UHC2165093•••-••-3956858.293.5101·LUCIA.DAY44@OUTLOOK.COM—NULL——GRP-5045CORE-HMO
ENRENR-1318592026-10-10T05:16:41ZScott, Linda G——10/28/1987UHC-16616-27N/A(902) 457-8990linda.scott13@proton.me1462 Main StSCOTTSDALEAZ85223GRP-3848MEDICARE-ADV-B
ENRENR-1100012026-04-28T03:46:45ZEDWARDTJONES1980-01-23UHC-95903-88•••-••-6213·(973) 799-6391NULL2430 Canyon RoadGilbertAZ85235GRP-5052NAVIGATE-HMO
ENRENR-1139642026-05-17T08:29:24ZMei··—Chavez1997-10-09uhc-94469-58•••-••-23504282846mei.chavez73@outlook.com3316 MESA DRIVEAustinTX78799-9232GRP-0218CORE-HMO
ENR ENR-1095492026-09-13T21:44:39ZSophia—Edwards1955-10-02UHC-28031-99null524.551.4839SOPHIA.EDWARDS8@OUTLOOK.COM4035 Spring Street Apt 39LOS ANGELESCA90009GRP-6144MEDICARE-ADV-A
ENRENR-1085202026-02-09T04:06:52ZChristopherNJordan1985-08-16UHC-13336-75•••-••-938819089770264NULL6567 ELM STSeattleWA98109GRP-3368CHOICE-PLUS-PPO
ENRENR-1355792026-02-25T23:23:21ZNathanILawrence1955-07-04UHC-42284-52•••-••-67495932962649N/A6668 Park PlEden PrairieMN55393GRP-0378CORE-HMO
ENRENR-1013582026-08-15T03:25:41ZAna—Barnes1956-12-26UHC-78790-02•••-••-8707(260) 467-6948NULL8964 Mesa DrEden PrairieMN55357GRP-6361MEDICARE-ADV-A
ENRENR-1098742026-07-23T05:44:54ZKEVINZ··AGUILAR2007-06-08UHC-46826-88•••-••-4040(930) 659-8326kevin.aguilar@proton.me3903 OAK STDenverCO—GRP-0179CHOICE-PLUS-PPO··
ENRENR-1198862026-09-09T00:48:08ZVIRGINIA—JACKSON1958-05-09UHC-96033-99•••-••-26243025990288—1576 OAK STREETAustinTX78774GRP-1334CHOICE-PLUS-PPO
ENRENR-116043 2026-09-05T18:23:57Zbarbara··gilbert··1983-10-08UHC-97895-36•••-••-6241(574) 991-3684barbara.gilbert7@icloud.com2576 Lake View RdCharlotteNC28221·GRP-2815medicare-adv-b
ENRENR-102445 2026-02-15T18:04:34ZFrances—Ray10/13/1988UHC-36209-53•••-••-9400253-379-5889null··2798 Mesa Drive Apt 34CHARLOTTENC28263GRP-2246MEDICARE-ADV-A
ENRENR-122061 2026-06-13T06:18:43ZTaylor, Logan——1982-08-28UHC4144210•••-••-23184464912602·logan.taylor12@aol.com1147 Valley View DrAustinTX78749GRP-5000·MEDICARE-ADV-A
ENRENR-1305312026-01-29T21:45:15ZSamanthaIMedina06/18/72UHC-82189-05•••-••-79877447157679··—2419 Camelback RdFresnoCA93767GRP-7341NAVIGATE-HMO
ENRENR-1274452026-04-26T07:03:01ZBrittany—Guerrero1992-10-24UHC-24257-81•••-••-24829442937989BRITTANY.GUERRERO47@ICLOUD.COM6190 Spring St··DallasTX75282GRP-0928OPTIONS-PPO
ENRENR-1060482026-04-10T15:58:12ZJacob—Simpson2000-01-24UHC-02926-18-(662) 798-7381jacob.simpson@outlook.com4452 Maple AvenueCharlotteNC28267GRP-8987MEDICARE-ADV-B
ENRENR-1096292026-07-11T05:14:43ZMaryana—Wheeler1971-11-21UHC-14508-74•••-••-44068355094888mariana.wheeler@hotmail.com1448 Baseline RdPlanoTX75094GRP-1669MEDICARE-ADV-A
ENRENR-1337162026-09-30T19:40:32ZJESSICAC.LANE··1954-11-05UHC-34812-69•••-••-54647069957NULL8291 MAIN STEden PrairieMN55378GRP-0844OPTIONS-PPO
ENRENR-1017752026-09-10T21:42:34ZktherineV.grant04/28/08UHC-49702-48··•••-••-013713439782209UNKNOWN7447 VALLEY VIEW DRIVETempe··AZ85289GRP-6993·NAVIGATE-HMO
ENRENR-1247132026-08-17T06:08:37ZronaldV.pierce1938-09-25UHC-99616-62•••-••-6213+1 594 400 9129ronald.pierce@proton.me861 SUNSET BLVDPhoenixaz85034GRP-7843OPTIONS-PPO
ENRENR-1159092026-08-26T18:45:08Z PAMELA—HUNT1955-10-25——955-307-3739pamela.hunt73@aol.com8769 MEADOW LANEDALLASTX75298GRP-6001CORE-HMO
ENRENR-1236742026-09-03T17:36:35ZAdamQLewis·1977-05-17UHC-06334-32•••-••-7772(896) 425-6798ADAM.LEWIS@OUTLOOK.COM5302 Indian School RoadAustinTX78729··GRP-1581MEDICARE-ADV-B
ENRENR-1080662026-05-22T12:43:29Zarjun—ray09/21/1966··UHC-51751-35•••-••-8773(627) 632-2371··ARJUN.RAY46@YAHOO.COM8416 BASELINE ROADNashvilleTN37205·GRP-5351CHOICE-PLUS-PPO
ENRENR-1190412026-01-28T15:46:58ZKELLY··MORALES19491102UHC-07444-28•••-••-1620··kelly.morales@icloud.com820 Main StScottsdaleAZ85237GRP-5430MEDICARE-ADV-A
ENRENR-1355982026-09-11T09:01:02ZRogerX.Bowman05/28/87UHC-86290-80•••-••-056813489247156-328 River RdCharlotteNC·28286GRP-2988MEDICARE-ADV-A
ENRENR-1423592026-01-21T08:21:12ZRACHEL—WALLACE1996-08-06·UHC-99092-84•••-••-4562-RACHEL.WALLACE@PROTON.ME1465 Camelback RoadMinneapolisMN55450-1189GRP-8463CORE-HMO
ENRENR-1388022026-03-07T23:43:49ZJACOB—PETERS1997-09-09UHC-44382-28•••-••-56589577962UNKNOWN··—-nullnullGRP-7804CHOICE-PLUS-PPO
ENRENR-1256752026-03-18T18:56:39ZJenkins, Emily——Mar 1, 1991UHC-63131-22NULL733-785-5742emily.jenkins39@outlook.com3664 CAMELBACK ROADAustinTX·78775GRP-2202CHOICE-PLUS-PPO
ENRENR-1011222026-09-15T00:00:01ZRichard—·Lopez1972-11-08UHC-75423-69-12694546792N/A1443 Pine Drive··HoustonTX77090GRP-4549MEDICARE-ADV-B
ENRENR-1346162026-03-08T14:44:39ZJUILE—ROJAS1950-04-23UHC-51780-16•••-••-8929336-712-6600julie.rojas@proton.me5396 Meadow Lane #617San DiegoCA92139GRP-6578NAVIGATE-HMO
ENRENR-1077592026-06-16T22:48:59ZLauren—Day2008-01-25UHC-29621-19-·215-936-8169UNKNOWN··615 GRAND AVENUEHoustonTX77035GRP-2171NAVIGATE-HMO··
ENRENR-1302462026-01-02T20:40:59ZLittle, EmilyX.—4/14/1996UHC-12266-19•••-••-0998737-540-3603—3165 Sunset BoulevardCHANDLERAZ85292GRP-2595MEDICARE-ADV-B
ENRENR-1261432026-08-09T19:59:56ZMASON—MORALES1999-10-26UHC-64421-02•••-••-80133927661155··nullNULL-—GRP-8335MEDICARE-ADV-A
ENRENR-1366542026-06-28T02:43:22ZAhmedP.··WashingtonOct 4, 1959UHC-72011-30•••-••-8643+1 324 347 2179AHMED.WASHINGTON77@YAHOO.COM580 MAPLE AVENUEMinneapolisMN55437GRP-0106··MEDICARE-ADV-B
ENRENR-1136572026-08-01T17:58:06ZLUCIA—SIMPSON·Jul 6, 2000UHC-91128-71•••-••-73783045690763lucia.simpson@gmail.com7597 Ocean AvenueAtlantaGA30376GRP-6942CORE-HMO
ENRENR-1349872026-04-22T05:30:36ZColeman, Paul—····1939-09-22UHC-62015-28•••-••-6876+1 741 814 6580··—8638 Main StMIAMI··FL33170·GRP-4495OPTIONS-PPO
ENRENR-1135602026-10-14T06:20:26Zkelly··H.austin1968-02-12UHC-69850-74•••-••-8396612-563-4758kelly.austin@aol.com5716 Baseline Road Apt 2MesaAZ85214GRP-0204NAVIGATE-HMO
ENRENR-1070542026-09-09T09:49:53ZWayneOHicks1976-11-16UHC6655172•••-••-34793856043701·wayne.hicks@proton.me7925 Canyon RoadLas VegasNV89126GRP-3087·OPTIONS-PPO
43,101 rows, page 137 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:38.460Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty