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-1067602026-07-21T23:32:51ZCarlosIRichardson1953-10-16UHC-10198-33•••-••-1773(532) 540-5981UNKNOWN7392 HIGHLAND AVELas Vegasnv89121GRP-8345MEDICARE-ADV-A
ENRENR-1314262026-04-21T09:14:57ZjordanQlaura1961-07-06UHC-59863-10•••-••-261819824877437NULL7326 ELM STREETPhoenixAZ85020GRP-7322NAVIGATE-HMO
ENR ENR-1393952026-06-20T20:29:53Z·GARYO··HARRIS—UHC-62653-03•••-••-0712(356) 579-1319—1821 Park PlGILBERTAZ85295GRP-7844MEDICARE-ADV-A
ENRENR-1220872026-07-01T04:58:38ZKevinAMarshall4/5/1962UHC-42645-56•••-••-432518177369229KEVIN.MARSHALL@HOTMAIL.COM6674 SAGE COURTTAMPA·FL33694GRP-8519navigate-hmo
ENRENR-1144022026-06-07T09:52:11ZWright, Gerald——·1998-09-24UHC-16903-15•••-••-4959-—223 Church StreetMiamiFL33114·GRP-9975NAVIGATE-HMO
ENR ENR-1105132026-02-03T19:30:26ZHayes, JoshuaR—1956-04-13UHC-85275-22•••-••-48705918584128joshua.hayes2@icloud.com3463 MOUNTAIN VIEW DRSan DiegoCalifornia92149GRP-1321OPTIONS-PPO··
ENRENR-1060802026-02-26T09:45:47Z·Karen M.—Campbell1967-07-12UHC-50459-14•••-••-2417370.447.3086·karen.campbell49@outlook.com3013 Market StreetSan Antonio·tx78271GRP-3254NAVIGATE-HMO
ENRENR-1384672026-08-16T22:10:08ZBETTY—WRIGHT1996-05-07UHC-97501-96•••-••-92086076640120·-6345 Desert Sky Blvd #933Miamifl33102GRP-6455MEDICARE-ADV-B
ENRENR-1160042026-07-27T23:45:42ZRonaldFLopez12/10/1972UHC-48458-09•••-••-31549682469915ronald.lopez49@gmail.com168 CAMELBACK RD··San DiegoCA92132GRP-8088MEDICARE-ADV-A
ENRENR-1125082026-02-13T18:59:13Z OMAR··WCARTER2002-04-05UHC-20223-76•••-••-5844—omar.carter@hotmail.com1110 BASELINE ROADHoustonTX··77090GRP-2290CHOICE-PLUS-PPO
ENRENR-1371362026-05-10T06:04:26ZHowell····Carlos1948-08-05UHC-56086-65•••-••-2299—null4636 Broadway·ORLANDOFL32873GRP-8900OPTIONS-PPO
ENRENR-131247 2026-06-12T15:24:03ZKEVIN··—·HILL1944-10-03UHC-48379-37•••-••-26442326827516kevin.hill@yahoo.com1012 Bayshore DriveLas VegasNV89125GRP-3770MEDICARE-ADV-A
ENRENR-1116092026-07-27T14:06:14ZNANCY—SIMPSON1956-04-01UHC-55422-71•••-••-3431205-958-5506nancy.simpson@proton.me··5617 JEFFERSON AVENUESACRAMENTO·CA95828GRP-8771CHOICE-PLUS-PPO
ENRENR-1098822026-06-30T15:29:47ZVirginia—Yang8/28/1988UHC-41415-62•••-••-3537685-603-9563virginia.yang53@proton.me200 JEFFERSON AVEMesaAZ85287GRP-7669·MEDICARE-ADV-A
ENRENR-1088952026-02-19T08:13:58ZAmaanda—Evans2000-03-03UHC-14543-34··•••-••-0761—amanda.evans@yahoo.com3904 Ocean Avenue Apt 28San DiegoCA92154GRP-8578CHOICE-PLUS-PPO
ENRENR-1229352026-07-18T22:29:10ZDonna—Alvarez1998-03-26UHC-21436-41•••-••-77913057785217··donna.alvarez8@hotmail.com8538 Mountain View DriveFresnoCA93727GRP-2130OPTIONS-PPO
ENRENR-123558 2026-07-16T20:08:54Z·Fisher, Amanad——1970-08-21UHC-11517-28•••-••-4419(253) 444-3613—5090 Willow Court #652PhoenixAZ85007GRP-9920navigate-hmo
ENRENR-1367562026-09-05T11:05:48ZSimmons, BenQ—1971-06-14UHC-86087-23UNKNOWN+1 665 369 1551BENJAMIN.SIMMONS38@PROTON.ME8450 CAMELBACK RDGilbertAZ··85224··GRP-5586MEDICARE-ADV-A
ENRENR-1373732026-03-11T04:44:29ZTYLERY.PETERS2001-11-01UHC-32643-22•••-••-6245NULLnull··1544 Market Street Apt 35FRESNOCalifornia··93738GRP-7412MEDICARE-ADV-B
ENRENR-1358452026-07-29T01:37:19ZWILLIE—GRANT22-07-2006UHC-22936-33•••-••-35645948590091UNKNOWN5784 BAYSHORE DRDallasTX75242GRP-2998CORE-HMO
ENRENR-1170062026-01-06T03:10:18ZpamelaHcollins1942-09-03UHC-20336-22N/A(341) 642-2463pamela.collins@yahoo.com··1992 Meadow LaneMESAAZ85242GRP-0445OPTIONS-PPO
ENRENR-1391282026-07-14T16:55:36ZkathrynYreed1947-09-10UHC-08219-66N/A844.594.1316kathryn.reed@outlook.com9599 Main StDenver··CO80226GRP-5934OPTIONS-PPO
ENRENR-1244132026-08-12T03:25:54ZRUSSELL··—BROWN1941-07-27UHC5935998•••-••-2632279.465.9772russell.brown@aol.com654 FOREST AVENUEOrlandoFL32804GRP-7518CHOICE-PLUS-PPO
ENRENR-1031702026-10-14T18:31:19ZRoberts, PeterE—04/11/1988UHC-41456-86•••-••-72684076290973—7569 Church StreetScottsdaleAZ85253-5180GRP-8886NAVIGATE-HMO
ENRENR-1029692026-05-31T08:11:35ZAlan—RiceJan 27, 1989·UHC-29266-34•••-••-0719—alan.rice78@hotmail.com4973 CHURCH STREETTUCSONAZ85721···GRP-5604MEDICARE-ADV-B
ENRENR-1212772026-06-18T04:22:32ZPriya—Morris··02/10/45UHC-07834-90•••-••-6131(744) 223-5788priya.morris@yahoo.com96 MESA DREden PrairieMN55385GRP-9699MEDICARE-ADV-A
ENRENR-1418912026-04-21T19:52:36ZWilliam—Harrison1943-08-23UHC-73581-93•••-••-36843703515817WILLIAM.HARRISON@PROTON.ME5282 Grand AvenueChandlerAZ85284GRP-3760··MEDICARE-ADV-B
ENRENR-1329922026-04-05T18:30:22ZPaul—Lee1963-01-17UHC-95741-07•••-••-10567956322109PAUL.LEE@AOL.COM129 Canyon Road··DALLAStx75244GRP-6275·CORE-HMO
ENRENR-1127712026-05-22T20:06:01ZRobert—Garza1963-11-10··UHC-33869-29—·962-974-9848N/A9800 Oak StAtlantaGA30356GRP-0502MEDICARE-ADV-B
ENRENR-1126692026-05-17T10:33:24ZJOANV.GARRETT1950-03-20UHC-30737-02•••-••-5171(436) 956-7098·null9201 CEDAR LNAustinTX78750GRP-9619options-ppo
ENRENR-1116422026-05-15T06:48:10ZBrooks, KeithJ.—04/21/05UHC-41430-75•••-••-8543371-680-7862-2003 Grand AveMiamiFL33158GRP-9050SELECT-EPO
ENRENR-1088372026-02-10T01:17:21ZLORIJLUCAS91531209UHC-00588-86—2448153512—9365 PALM DRIVEDENVERCO80288-4451GRP-7425··SELECT-EPO
ENRENR-1041812026-03-09T01:20:42ZWalter··—Espinoza··10/15/73uhc-26179-57•••-••-07928958443276-7825 Cedar LnORLANDOFL32851-6687GRP-8821CHOICE-PLUS-PPO
ENRENR-1204302026-03-26T04:20:46Z—C.—1941-92-16uhc-84757-69•••-••-6716(572) 803-4951omar.rios79@yahoo.com7108 Park PlaceGILBERTAZ85204GRP-6951MEDICARE-ADV-A··
ENRENR-1273912026-03-24T09:15:13ZJulia··McDonald1990-11-24UHC-03252-20•••-••-7515360-664-3257NULL7526 Hillcrest RdPlanoTX—GRP-2790OPTIONS-PPO
ENRENR-1415962026-03-20T13:43:59ZLauren····James1959-12-23UHC-88606-72•••-••-20016405143845LAUREN.JAMES@PROTON.ME147 OCEAN AVENUEFresnoCA93754GRP-8991CORE-HMO
ENRENR-1272572026-03-13T09:48:52ZAndrew—Bradley···1951-04-22UHC-41862-45•••-••-92028902605677null9405 Washington StreetTempeaz85205-7499GRP-2045·MEDICARE-ADV-A
ENRENR-1083532026-03-13T17:10:24ZSarah—Li19451102UHC-74512-30•••-••-928318293356117sarah.li3@yahoo.com8484 JEFFERSON AVENUESacramento··CA95811GRP-3091SELECT-EPO
ENRENR-1110312026-01-28T21:00:14ZSeanVOwens1984-01-05UHC-64788-47•••-••-8180(641) 704-3423sean.owens@yahoo.com5632 Baseline RdSan DiegoCA92137·GRP-8392SELECT-EPO
ENRENR-1031772026-09-27T16:52:38ZKATHLEENWCOLE1991-08-26·UHC-27256-01•••-••-0743584-507-2561KATHLEEN.COLE@OUTLOOK.COM·186 Ocean AveMesaAZ85202GRP-0400OPTIONS-PPO
ENRENR-1256342026-04-02T15:39:06ZSanders, Brandon··—Aug 17, 1992UHC7139078•••-••-71982586629641BRANDON.SANDERS@YAHOO.COM9596 Mountain View DrivePhoenix·AZ85027GRP-3547MEDICARE-ADV-B
ENRENR-1146382026-09-12T16:40:02ZAnna—Gordon1949-12-19UHC-99377-53•••-••-1327NULL-4857 Washington StreetNashvilleTN37229GRP-8888NAVIGATE-HMO
ENRENR-1198282026-01-25T03:05:34ZJuliaT.Garcia14-03-1989··UHC-18000-24•••-••-8877386-368-8391julia.garcia54@icloud.com5786 Elm StreetGlendaleaz85387GRP-1380MEDICARE-ADV-A
ENRENR-1265132026-03-28T01:22:05ZSusan—Yang2000-01-13UHC-21009-42•••-••-37884769869935susan.yang@yahoo.com3414 Church StJACKSONVILLEFL-GRP-6365NAVIGATE-HMO
ENRENR-1345962026-02-21T15:42:17ZALBERTQDOMINGUEZ24-10-1962UHC-79602-45•••-••-659512636157292albert.dominguez@gmail.com299 Bayshore DrHouston··tx77007GRP-2578NAVIGATE-HMO
ENRENR-1266172026-02-02T05:51:31ZJacqueline—Bennett2004-07-10UHC-17708-15•••-••-2064896-286-7056··jacqueline.bennett@aol.com8163 Palm DriveChandlerAZ85258GRP-4846CORE-HMO
ENRENR-1300372026-06-27T10:51:20ZBetty—Evans1998-04-26UHC-40645-66•••-••-39195924058betty.evans81@aol.com5941 Apache BoulevardMiamiFL33166GRP-7514CHOICE-PLUS-PPO
ENRENR-1181572026-05-09T05:44:33Z·jonathan—evans10/24/38UHC-49583-74—8563434896jonathan.evans@proton.me1311 PALM DRAustinTX78722GRP-0696CHOICE-PLUS-PPO
ENRENR-1420612026-05-14T13:27:28ZRALPH··MORALES2006-07-13··UHC-26733-64•••-••-6237+1 944 514 9745—2543 LAKE VIEW ROADGlendaleAZ85327GRP-1601NAVIGATE-HMO
ENRENR-1232672026-06-28T20:10:41Z·JACK—MEYER19960612UHC-47355-03•••-••-90338493974JACK.MEYER@GMAIL.COM8203 Mesa DriveSan DiegoCA92140GRP-9085NAVIGATE-HMO
43,101 rows, page 58 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:36.690Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty