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-1234292026-06-18T21:02:07Zralph—gibson1987-03-21UHC-51268-55-—null2194 Baseline RdMiamiFL33143GRP-6802MEDICARE-ADV-B
ENRENR-1314442026-05-20T10:40:37ZNICCOLEY·MASON·10/14/1947UHC-61409-91•••-••-4940(257) 916-8716nicole.mason57@yahoo.com182 JEFFERSON AVEChandlerAZ85237GRP-8002SELECT-EPO
ENRENR-1327672026-02-27T09:56:06ZMARIA—TAYLOR1987-06-06UHC-04823-97•••-••-7832929-282-6749MARIA.TAYLOR85@ICLOUD.COM2393 Valley View Drive···FresnoCA93732GRP-6292SELECT-EPO
ENRENR-1414162026-06-01T03:46:02ZMARY·MFREEMAN1989-10-16UHC-37577-98•••-••-2076+1 880 500 1708mary.freeman72@yahoo.com2156 Highland AvenueSACRAMENTOca95892GRP-2282MEDICARE-ADV-A
ENRENR-1046162026-04-14T03:08:28ZDorothy L.—Holmes2006-10-05UHC-62284-90•••-••-5072741.937.7608dorothy.holmes@aol.com6486 Palm DriveJacksonvillefl··32266GRP-4850CORE-HMO
ENRENR-1419752026-10-05T14:04:13ZRUSSELL—SCOTT2006-07-06UHC6206874•••-••-3008582-215-7597—nullnull-—·GRP-9322MEDICARE-ADV-A
ENRENR-1324372026-07-04T11:53:17ZALANVDEAN1956-02-21UHC-46690-93UNKNOWN942-768-4964alan.dean17@gmail.com·8424 Central AvenueChandlerAZ85266GRP-0876CHOICE-PLUS-PPO
ENRENR-1032082026-03-02T10:55:22ZBrandonN.··Jenkins19940801UHC-34796-81··•••-••-76316559348279brandon.jenkins@yahoo.com1660 PALM DRSCOTTSDALEArizona85209·GRP-8564OPTIONS-PPO
ENRENR-1061382026-07-06T13:37:28ZSandra··—Lwis1994-04-02UHC-69787-06•••-••-2438(956) 532-9294UNKNOWN2873 Maple Avenue Apt 22JACKSONVILLE·FLNULLGRP-3276CORE-HMO
ENRENR-1104832026-07-31T13:45:15ZBowmanB.Carol1957-09-26UHC-30482-16•••-••-3112309-739-3297CAROL.BOWMAN84@YAHOO.COM1679 BAYSHORE DRLas VegasNV89196GRP-6357MEDICARE-ADV-A
ENRENR-1025562026-05-23T00:44:43ZStephanieW.·Berry19450506UHC-73453-17•••-••-5967606.440.4132—7425 MAIN STREETTucsonAZ85748-8739GRP-9065CHOICE-PLUS-PPO
ENRENR-1064712026-06-24T13:09:18ZNANCYEKENNEDY22-04-1980UHC-57453-80UNKNOWN··NULL—6832 Park PlacePhoenix··AZ85089GRP-0684CHOICE-PLUS-PPO
ENRENR-1171002026-08-28T09:36:13ZBRITTANY—LUCAS2000-03-27··UHC-42291-53•••-••-4458·540-848-3129—1258 Park PlPlanoTX75017GRP-2696CORE-HMO··
ENRENR-1052002026-04-25T19:17:33ZCynthia····Burton19600726UHC-26454-12•••-••-0797511-600-6211CYNTHIA.BURTON13@PROTON.ME7275 APACHE BOULEVARD··CharlotteNorth Carolina28216GRP-9390CORE-HMO
ENRENR-1405342026-10-05T13:37:22ZBENJAMINK.VASQUEZ··2006-04-10·UHC-82637-55·N/A3042095884benjamin.vasquez80@proton.me5631 Mountain View DrOrlandoFL32879··GRP-8235options-ppo
ENRENR-1074812026-08-11T11:48:26ZHiroshi—Woods03-09-1942UHC-03483-36•••-••-47949445652071hiroshi.woods@aol.com··5837 CANYON RDMESAAZ85256GRP-0499NAVIGATE-HMO
ENRENR-1139672026-05-30T12:59:22ZHiroshi—Lynch1965-10-25UHC-75411-44•••-••-1402NULLhiroshi.lynch@aol.com581 Cedar Lane·TAMPAFL33626··GRP-4345OPTIONS-PPO
ENRENR-1372992026-03-19T23:37:04ZFernandez, RogerR—1950-07-03UHC-87047-92—8934818059roger.fernandez3@gmail.com3486 BroadwayDALLASTX75214GRP-9451MEDICARE-ADV-A
ENRENR-1201692026-07-13T10:57:53ZBrenda—Harris1982-06-13UHC-10906-79•••-••-2999(852) 530-5311brenda.harris88@proton.me7288 Elm Street Apt 21PlanoTX75033GRP-4284SELECT-EPO
ENRENR-1237772026-02-14T16:48:15ZLUCIA·NMONTGOMERY09-12-1947UHC-00748-41•••-••-3989(651) 739-0159lucia.montgomery@gmail.com2513 Harbor BoulevardHoustonTX77084GRP-1110CORE-HMO
ENRENR-111516 2026-08-07T18:37:36ZkathyXharris19960502UHC-29359-29•••-••-4917+1 533 252 6689·KATHLEEN.HARRIS@PROTON.ME7651 OCEAN AVENUECharlotte··NC—GRP-0292NAVIGATE-HMO
ENRENR-1182072026-02-18T20:49:26ZDianeR.Taylor5/21/1976·UHC-64723-69•••-••-9302206.249.4213N/A7365 PALM DRIVEPLANOTX75079GRP-6313CHOICE-PLUS-PPO
ENRENR-1394422026-05-14T12:56:37ZLindaGGibson19381219··UHC-03410-41•••-••-00117439262694linda.gibson@icloud.com1880 MOUNTAIN VIEW DRIVEFresnoCA93791GRP-9972core-hmo
ENRENR-1043482026-07-20T20:15:36ZVargas, Sofia——16-02-1954UHC-72868-40•••-••-78095342142508··2814 Central AveTucsonAZ85706GRP-0581select-epo
ENR ENR-1268322026-07-18T12:05:01ZSARAZHARVEY··2/18/1984UHC-26372-60•••-••-36426245431462SARA.HARVEY@GMAIL.COM8811 Church StreetDenverCO80257···GRP-9521MEDICARE-ADV-B
ENRENR-1315582026-05-20T06:07:51ZLAURA—MASONOct 26, 1977UHC-86903-57•••-••-19625113372559laura.mason36@proton.me4702 Highland AveSeattleWANULL·GRP-0316SELECT-EPO
ENRENR-1211452026-02-23T09:30:12ZAngela··R.Anderson1967-06-27UHC-43281-15•••-••-1696+1 609 596 2602angela.anderson@hotmail.com6290 Park PlacePhoenixAZ85065GRP-9068SELECT-EPO
ENRENR-1408592026-02-20T07:39:34ZJANICE—CARR1938-10-26uhc-20307-50•••-••-4481(766) 906-5071—7647 Park PlTEMPEAZ··85268GRP-3026OPTIONS-PPO
ENRENR-1061282026-01-10T22:07:03ZRomero, CamilaK.—02-07-1996UHC-72971-80•••-••-43713838850653·camila.romero@outlook.com9641 Forest AveGlendale··AZ85326GRP-4564SELECT-EPO
ENRENR-1206732026-05-03T10:27:00ZBurns, Judy——12/9/1980UHC-13174-98•••-••-4435—JUDY.BURNS92@ICLOUD.COM3367 Maple AvenueSeattleWA98109··GRP-1473··CHOICE-PLUS-PPO
ENRENR-1230042026-03-14T00:07:16ZChristopherEGuerrero1990-08-04UHC-94197-05•••-••-4202586-383-9700christopher.guerrero61@proton.me7502 FOREST AVENUE··ScottsdaleAZ—GRP-5723CHOICE-PLUS-PPO
ENRENR-1316232026-04-08T01:29:16ZBryan—Welch1951-12-16UHC9049968··•••-••-8643(848) 455-0065bryan.welch@outlook.com9202 Palm DrSeattleWA—GRP-8115OPTIONS-PPO
ENRENR-1285512026-08-29T03:07:06ZJEFFREYTMARTIN1952-12-20UHC1121495•••-••-8573—jeffrey.martin@yahoo.com4549 HARBOR BOULEVARDAustintx78766GRP-2507··OPTIONS-PPO
ENRENR-1314512026-10-08T10:46:42ZDebraEPatterson2001-04-19UHC-45467-76··•••-••-5648657-656-5795debra.patterson30@aol.com2991 Meadow LnTAMPAFL33648GRP-3753CHOICE-PLUS-PPO
ENRENR-1178832026-08-02T20:55:37ZAnaFMoore3/2/1962UHC-21546-91•••-••-48323243232ANA.MOORE@HOTMAIL.COM7032 Main StLos Angelesca90017GRP-1111MEDICARE-ADV-A
ENRENR-1112712026-01-18T21:42:22ZLarryYPayne07/14/1969···UHC-85781-09•••-••-8832648.342.6301LARRY.PAYNE@AOL.COM2134 Pine DrSacramentoCAnullGRP-7825OPTIONS-PPO
ENRENR-1084652026-04-24T11:02:04ZBRIANEFLORES2001-06-10UHC-95145-33•••-••-4123+1 256 622 8454-438 BASELINE ROADTucsonAZ85741GRP-2096MEDICARE-ADV-A
ENRENR-1346452026-09-25T08:31:57Z·ZacharyVSullivaan1967-01-19UHC-50266-48•••-••-1551628.974.6065ZACHARY.SULLIVAN@ICLOUD.COM7407 Valley View Drive·AtlantaGA30306GRP-8439·MEDICARE-ADV-B
ENRENR-1352682026-10-02T08:58:30Zkimberly—fox1899-06-07UHC-78140-79··•••-••-62228758928832—3661 Bayshore DrHoustonTX77087·GRP-8691CHOICE-PLUS-PPO
ENRENR-1215052026-01-24T08:55:34ZJamse, DeborahK····12/13/1944·UHC-46277-47•••-••-4403523.307.4985UNKNOWN335 Indian School RoadTempeAZ·85285GRP-6563NAVIGATE-HMO
ENRENR-1026032026-02-02T15:36:26ZLINDA—CRAWFORD··1993-12-72UHC-89035-43•••-••-7378+1 554 527 9805··LINDA.CRAWFORD27@PROTON.ME·8402 Washington StDENVERCO·80274GRP-8871OPTIONS-PPO
ENRENR-1239792026-04-20T18:45:41ZRussellORobinson19600326UHC-60313-10•••-••-69592680438N/A4046 LAKE VIEW RDEden PrairieMN-GRP-8119MEDICARE-ADV-B
ENRENR-1321462026-08-09T15:35:34ZMaryHNguyen1990-03-12UHC-55840-85•••-••-3127NULL··mary.nguyen@icloud.com7858 River RoadLos AngelesCA-GRP-1321SELECT-EPO
ENRENR-1422132026-07-13T21:41:51ZFrank—Owens1799-11-28UHC6684215NULL(277) 732-1620frank.owens87@yahoo.com7234 Washington StreetSacramentoCA95800GRP-6496NAVIGATE-HMO
ENRENR-1081962026-06-16T20:04:27ZTimothy—FloresOct 14, 1980uhc-53330-02•••-••-4130—null2143 Apache BlvdGlendaleAZ·85350GRP-0638MEDICARE-ADV-B
ENRENR-1109692026-08-26T12:47:50Z DEBRAS.GUERRERO—UHC-79292-33•••-••-0578(465) 800-6169··6541 Willow CtPlanoTX75018GRP-5085NAVIGATE-HMO
ENRENR-1264932026-04-09T02:30:42ZGerald—Hayes1989-05-12UHC-56156-16•••-••-7649-—6065 Oak StreetCHARLOTTENC28248GRP-2290MEDICARE-ADV-B
ENRENR-1040232026-08-01T05:39:29ZWillie—Johnson2000-09-26UHC-99714-66•••-••-9105(355) 268-6917-7432 CENTRAL AVENUEHoustonTX77081GRP-7785CHOICE-PLUS-PPO
ENRENR-1156652026-07-18T08:14:01ZDinaa—Santiago12/23/1970···UHC-54379-94•••-••-0741243-213-6066DIANA.SANTIAGO@HOTMAIL.COM9561 Canyon RdLos AngelesCA··90098GRP-1892CORE-HMO
ENRENR-1199682026-01-17T20:44:39ZJudith—Gutieerrez1991-04-19UHC5956029•••-••-0185—JUDITH.GUTIERREZ@ICLOUD.COM2662 Indian School RoadTempeAZ85255GRP-3070OPTIONS-PPO
43,101 rows, page 14 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:34.767Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty