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-1095692026-04-14T14:42:12ZTHOMASHESPINOZA2002-10-08UHC-00130-55N/A··8288912604thomas.espinoza@outlook.com1690 Willow Ct·NashvilleTennessee37229GRP-7392MEDICARE-ADV-A
ENRENR-1014922026-09-30T00:54:01ZLewis, Soifa····—03/02/68UHC-63635-58•••-••-2377(962) 792-7290sofia.lewis21@proton.me9224 BAYSHORE DRIVE·MesaAZ85214GRP-5218SELECT-EPO
ENRENR-1250202026-08-21T14:08:06ZSOFIA··I.RIOS9192-06-06UHC-21043-75NULL8688752423sofia.rios@yahoo.com5680 Desert Sky BlvdDALLASTX-GRP-9972navigate-hmo
ENRENR-1217572026-03-21T02:22:59Z Jack—BowmanApr 17, 1940UHC-69037-54•••-••-3454+1 306 290 9753JACK.BOWMAN67@GMAIL.COM8293 Washington StGilbertAZ—GRP-7600CHOICE-PLUS-PPO
ENRENR-1279702026-04-13T13:45:45ZstephanieBalvarado1994-11-24UHC-14676-12•••-••-2016NULLnull··7956 CAMELBACK ROADLas VegasNV89197-2485GRP-6826SELECT-EPO
ENRENR-1018332026-07-29T13:18:45ZROBERTSCAMPBELL06/02/72UHC-60444-57•••-••-3779429-396-0584—2785 Willow CourtCharlotteNC·28253GRP-8013NAVIGATE-HMO
ENRENR-1049182026-02-05T00:36:03ZMATEOV.MYERS1976-07-16UHC-90347-43N/A636-934-4236··N/A5802 Ridge Rd #179GlendaleAZ85308GRP-4407NAVIGATE-HMO
ENRENR-1173922026-07-13T20:15:31ZLawson, Kimberly——1977-01-25UHC-30977-89•••-••-878919074303047kimberly.lawson@outlook.com4007 River RdDenverColorado80298··GRP-3638NAVIGATE-HMO
ENRENR-1149842026-05-16T16:10:41ZsusanNhoward··1995-01-09UHC-23868-31•••-••-772513035682945SUSAN.HOWARD@AOL.COM9163 Willow CourtPLANOTX75089GRP-0634·MEDICARE-ADV-A
ENRENR-1020122026-07-05T19:26:51ZBradley··Silva1939-08-03UHC-51034-94-(520) 375-5068UNKNOWN8829 PARK PL·GlendaleAZ85364GRP-9515OPTIONS-PPO
ENRENR-1318632026-04-13T01:09:55ZNicoleG.Bryant3/24/1973UHC-87960-16•••-••-1821418-668-6351—null—UNKNOWN-GRP-1045··MEDICARE-ADV-A
ENRENR-1095282026-08-03T14:02:41ZKathrynOPayneAug 7, 2002UHC-83541-95•••-••-8865621-885-2238kathryn.payne49@yahoo.com156 Hillcrest RdScottsdaleAZ85274GRP-3087··MEDICARE-ADV-B
ENRENR-1206262026-01-21T11:41:03Z Joseph—Cook1969-01-22UHC6659441•••-••-16793558100525JOSEPH.COOK77@GMAIL.COM3788 Pine DrFresnoCalifornia93788GRP-2657SELECT-EPO
ENRENR-1066032026-06-01T09:16:43Zcatherine—alexander1944-04-27UHC-81631-23•••-••-9460757-805-0801—8711 BASELINE ROADNASHVILLETN·37267GRP-7576MEDICARE-ADV-A
ENRENR-1411992026-10-16T10:34:23ZNicole—Mejia·07/11/66UHC-30177-12•••-••-56268377615976··NICOLE.MEJIA94@YAHOO.COM·3801 Harbor BoulevardJacksonvilleFL32201·GRP-8263MEDICARE-ADV-A
ENRENR-1081702026-08-07T10:41:54Z Judith—Arnold1961-05-18UHC-06641-50•••-••-32879508834403null5777 PALM DRLas VegasNV89187GRP-5283CHOICE-PLUS-PPO
ENRENR-1244942026-09-10T07:03:01ZNATALIE—RAMOS4/27/1987uhc-03397-06•••-••-3756(269) 917-1269—8649 BROADWAYSeattle·WA98156GRP-5866NAVIGATE-HMO
ENRENR-1285732026-05-16T03:19:45ZKathryn—Sanders1984-05-23UHC0742463null+1 485 573 7664—452 BAYSHORE DR #126Las VegasNV89106GRP-7774SELECT-EPO
ENRENR-1408502026-05-07T11:24:21ZsarahApeterson20030915UHC-16432-33•••-••-8102+1 271 446 9812SARAH.PETERSON93@AOL.COM6100 Lincoln WayMinneapolisMNNULLGRP-5614SELECT-EPO
ENRENR-1426002026-05-12T23:40:12ZCarl··C.Simmons0202-03-11UHC-25020-08•••-••-42718942338595CARL.SIMMONS@ICLOUD.COM5222 Ocean AvenueDENVER·Colorado80290GRP-6123SELECT-EPO
ENRENR-1058652026-01-31T08:57:55ZHannah—Dunn1997-04-14·UHC-06542-72•••-••-9249+1 816 795 5693HANNAH.DUNN60@GMAIL.COM7528 WILLOW COURTPLANOTX··75065GRP-3689CHOICE-PLUS-PPO
ENRENR-1300362026-07-31T07:01:18Z Mitchell, NicoleB.—2003-03-23uhc-19620-71•••-••-1763(237) 413-6517NICOLE.MITCHELL22@HOTMAIL.COM8191 Sunset BlvdColumbus··Ohio43292·GRP-8775MEDICARE-ADV-A
ENRENR-1316702026-02-08T21:45:40ZgraceZjimenez1949-02-21UHC-20386-06UNKNOWN····GRACE.JIMENEZ@PROTON.ME2343 Mountain View DriveNashvilletn37229GRP-7444·MEDICARE-ADV-A
ENRENR-1259942026-09-03T16:31:17ZSTEVEN—WEAVER1963-06-02UHC-01879-06•••-••-38686462546354null4330 Harbor BlvdHoustonTX77080-8791GRP-9178medicare-adv-b
ENRENR-1200262026-05-09T22:35:35ZkimSizabella1966-10-27UHC-99842-15•••-••-8920899.296.5732isabella.kim52@proton.me8041 Palm DrSacramentoCalifornia95883GRP-3375OPTIONS-PPO
ENRENR-1236022026-03-10T02:38:24ZadamQpierce2008-01-22UHC4667245•••-••-5336921.478.8114adam.pierce46@aol.com·9756 Park PlaceTEMPEAZ85205GRP-1018CORE-HMO··
ENRENR-1169002026-03-26T17:05:18ZMarcus····Burke2008-04-17··UHC-79080-92—8573819812marcus.burke@yahoo.com4628 RIVER ROAD··San AntonioTX·78278GRP-8715MEDICARE-ADV-A
ENRENR-1297772026-02-26T05:33:17ZEugeneCCrawfordSep 17, 1992UHC-14965-59•••-••-1469616.885.7751EUGENE.CRAWFORD@GMAIL.COM1269 MESA DRGilbertAZ85205GRP-6130··MEDICARE-ADV-B
ENRENR-1252842026-03-15T10:09:16ZJordanPFlores08/10/1964uhc-95164-43•••-••-1535(803) 713-3806jordan.flores@aol.com8436 JEFFERSON AVENUETempeAZN/AGRP-6384OPTIONS-PPO··
ENRENR-1048312026-10-05T00:33:07Z MATTHEW—SNYDER2004-11-13UHC-33098-14—(603) 944-5723··7898 SAGE COURTMiamiFL33143GRP-7621OPTIONS-PPO
ENRENR-1350062026-01-06T05:15:37ZLuca—Torres1981-05-24UHC-10261-77•••-••-6565(807) 886-0849null7826 Willow CtChandlerAZ85240GRP-8950CHOICE-PLUS-PPO
ENRENR-1148062026-06-01T16:07:26ZEmilyBBurns1952-07-12UHC-83733-14··•••-••-6711·7449573134emily.burns@outlook.com··2466 GRAND AVENUE Apt 36·ColumbusOH43203GRP-0196CORE-HMO
ENRENR-138944 2026-09-22T11:16:17ZGreene, Roger—····1994-06-19UHC-35717-11•••-••-82149328488808ROGER.GREENE74@GMAIL.COM1194 Central AvenueSeattleWA98114GRP-9261options-ppo
ENRENR-1232852026-02-19T20:19:57ZDONALD··ROSE7/28/1965UHC-31390-71•••-••-05629668596663DONALD.ROSE@YAHOO.COM··8105 Ridge RoadHoustonTX77043GRP-0543MEDICARE-ADV-A
ENRENR-1412962026-01-06T02:36:39ZKEVIN N··—FULLER1974-01-20··UHC-89175-90•••-••-1426+1 820 515 2479kevin.fuller@hotmail.com·8360 Washington StreetSacramento··CA95831GRP-0667SELECT-EPO
ENRENR-1270232026-05-15T06:02:25ZfrankJburton1964-11-25·UHC-35602-95•••-••-2651(582) 691-0621·FRANK.BURTON15@PROTON.ME7178 Indian School RdMinneapolisMNNULLGRP-3189OPTIONS-PPO
ENRENR-1166472026-03-09T01:21:05ZtimothyG.estrada07/27/1968·UHC-49784-72•••-••-2171391-796-2574timothy.estrada14@aol.com5314 Elm St··ColumbusOH43236GRP-1251MEDICARE-ADV-B
ENRENR-1135702026-08-05T07:44:53ZEmma—Wagner08/22/44UHC-58060-51•••-••-54615219507268emma.wagner@yahoo.com5589 BROADWAY·ORLANDOFlorida32855GRP-5757OPTIONS-PPO
ENRENR-1210512026-04-05T10:49:57Zbily—ortiz··10/20/2006UHC-78085-15•••-••-6785+1 794 807 8515BILLY.ORTIZ@AOL.COM3156 BAYSHORE DRIVEEDEN PRAIRIE·Minnesota55357·GRP-3841SELECT-EPO
ENRENR-1371142026-06-19T00:40:18ZBrendaKPriceUNKNOWNUHC-49836-10•••-••-21226976710815—8415 SPRING STREETCharlotteNC28299GRP-1199··NAVIGATE-HMO
ENRENR-1420712026-08-19T19:28:07ZRANDYMGONZALEZMay 2, 1951UHC-84958-95•••-••-859417466478219-7743 Meadow Lane Apt 16DenverColorado80213GRP-4935SELECT-EPO
ENRENR-1273842026-05-19T02:52:45ZJacquelineN.Vargas26-07-1983UHC-67158-75•••-••-5883227.498.0011jacqueline.vargas@gmail.com9060 Mesa DrHOUSTONTexas-GRP-6619choice-plus-ppo
ENRENR-1187552026-01-03T23:15:57ZAlbert·RWatson1984-01-26UHC-54144-28UNKNOWN2924054334albert.watson@gmail.com8403 SAGE COURTLas VegasNevada89182··GRP-6048SELECT-EPO
ENRENR-1192572026-10-17T00:21:31ZARTHUR··NMYES··1979-05-10UHC-40907-37—264-744-8277arthur.myers@gmail.com3245 Indian School Road··JACKSONVILLEFL···32298GRP-8805NAVIGATE-HMO
ENRENR-1321612026-03-25T16:03:35ZPatel, Peter——·20-04-1945UHC-99963-63•••-••-0357(685) 798-7644peter.patel28@outlook.com··981 UNION STChandlerAZ85264GRP-9578CHOICE-PLUS-PPO
ENRENR-1083162026-05-14T20:24:51ZFrank····Guzman2006-10-09UHC-66444-28•••-••-4814(438) 318-0685frank.guzman95@hotmail.com1500 Spring StreetFRESNO·CA93723GRP-6059CORE-HMO
ENRENR-1425482026-01-16T18:16:59ZbryanIalvarado1985-02-05UHC-99451-22•••-••-9544687-466-0252null7297 Meadow LnScottsdaleAZ··85295-4229··GRP-9026CHOICE-PLUS-PPO
ENRENR-1350562026-09-06T01:08:00ZCatherineWSullivan2006-11-23UHC-40306-36•••-••-2483(741) 491-6830N/A8198 Valley View Drive·ORLANDO·FL32864GRP-3712CHOICE-PLUS-PPO
ENRENR-1296492026-08-19T03:02:40ZdianeZ.simmons2005-12-01UHC-25483-47•••-••-8758327-453-7681NULL9221 Maple AveFresnoCA93766GRP-3311SELECT-EPO
ENRENR-1420272026-06-18T12:39:47ZAlex—Woods1950-12-07UHC-66071-50N/A(475) 213-6315UNKNOWN6525 Willow CourtDallasTX75237GRP-3019OPTIONS-PPO
43,101 rows, page 281 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:43.438Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty