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-1208112026-09-06T05:44:57ZJOE—DIAZ2001-03-25UHC-07594-37•••-••-3910601-620-1229··JOE.DIAZ@YAHOO.COM3111 Maple AvenueGlendaleAZ·85353GRP-6844CORE-HMO
ENR ENR-1272422026-03-16T15:03:09ZRussell—Fernandez1977-05-25UHC-14589-20•••-••-59095935565458russell.fernandez17@hotmail.com1840 Camelback Road #324DallasTX···75281GRP-4027CHOICE-PLUS-PPO··
ENRENR-1035102026-09-07T21:32:50ZGeraldCJones1951-11-21UHC-35765-08•••-••-4951(580) 422-1517null5976 HARBOR BLVDAtlanta··GA30337·GRP-3988SELECT-EPO
ENRENR-1290332026-09-16T19:50:47ZJamesZEllis1940-10-02UHC-89459-12•••-••-6739UNKNOWNjames.ellis64@yahoo.com5613 OAK STSeattleWA98150GRP-1265·MEDICARE-ADV-A
ENRENR-104081 2026-01-29T04:00:41ZANDREAK.JIMENEZ3/10/1972UHC-34741-89•••-••-3493(523) 511-3994·-6052 JEFFERSON AVENUESeattleWA-GRP-0335MEDICARE-ADV-B
ENRENR-1296002026-03-31T00:31:24ZMateo··—Hunter1996-02-07UHC-25062-14··•••-••-3315(232) 248-8301MATEO.HUNTER65@ICLOUD.COMnull——-GRP-8126OPTIONS-PPO
ENRENR-1402662026-09-19T21:41:04Zbetty—sims1986-11-10UHC-31372-63•••-••-9062(962) 731-0365BETTY.SIMS83@PROTON.ME·1868 Ridge RoadLos AngelesCA90017GRP-4797NAVIGATE-HMO
ENRENR-1184992026-04-21T14:26:05ZWaterL.Estrada1990-03-23UHC6009629•••-••-16025776742038walter.estrada@proton.me4182 Main StreetSan AntonioTX78217GRP-7636OPTIONS-PPO
ENRENR-1132162026-02-02T23:01:17ZScottT.Castillo1945-07-07UHC-06779-38•••-••-2992398-552-3872scott.castillo14@yahoo.com7586 Valley View DriveSacramento··CA95814GRP-8404SELECT-EPO
ENRENR-1196632026-04-27T17:28:59ZDonna—Austin1956-02-08UHC-08695-42··•••-••-9772N/A—3198 Maple Avenue··FresnoCA93784GRP-2673CHOICE-PLUS-PPO
ENRENR-1057452026-08-03T21:28:11ZRACHEL—PAYNE01/22/1957UHC-90679-12•••-••-752119846895957rachel.payne46@proton.me6941 Baseline RoadGilbertAZ····GRP-1090·MEDICARE-ADV-A
ENRENR-1164312026-01-20T22:46:09ZGeorgeJ.Larson08/18/64UHC-26066-39•••-••-53064079564256george.larson73@aol.com4673 Park PlLos Angeles·California90047GRP-2849MEDICARE-ADV-A
ENR ENR-1330092026-01-30T18:53:02ZJremy—Dunn·2002-08-04UHC-68007-89•••-••-0815-—5789 APACHE BLVD Apt 5··CharlotteNC28244GRP-6251OPTIONS-PPO
ENRENR-1275202026-09-25T07:00:44ZRobinson, Joran——6/15/1979UHC-00837-84•••-••-52193715609N/A1116 Washington StreetTucsonAZ85785GRP-3972MEDICARE-ADV-B
ENRENR-125884 2026-02-10T13:41:42ZShirley—·Stone1970-03-01UHC-61879-34null9232764399shirley.stone90@proton.me8594 Elm StreetPhoenixAZ-GRP-1796MEDICARE-ADV-B
ENRENR-1416352026-02-28T04:31:55ZhenryU.lopez1968-10-24UHC-84906-58•••-••-4613+1 218 356 1751NULL1854 Central AveMinneapolis·MN—GRP-3738CHOICE-PLUS-PPO
ENRENR-1142522026-08-18T02:33:59ZGeraldI.Bennett·08/07/78UHC-84632-41•••-••-1705510.806.5193-4382 Canyon RdColumbusOH43234-7168GRP-7931NAVIGATE-HMO
ENRENR-1254762026-01-13T05:37:44ZCHERYLMGARCIA19891119UHC-54283-43•••-••-84384237356103—210 Mesa Dr··ORLANDOFL32829GRP-4173medicare-adv-a··
ENRENR-1410262026-10-14T22:50:58ZjordanRburns09/10/1953UHC-92287-05null(933) 778-2106NULL5530 Lake View RdFRESNOca93709GRP-0876MEDICARE-ADV-A
ENRENR-1171952026-01-25T23:20:27ZJames····Greene1990-01-18UHC-27397-40•••-••-33196919629155UNKNOWN1148 Main StreetColumbusOH43218GRP-2003CORE-HMO
ENRENR-1230522026-05-06T14:54:45ZJean··J··Rodriguez1968-06-06UHC-48421-22•••-••-6740(380) 888-3158jean.rodriguez@aol.com4344 Apache Boulevard··TucsonAZ··85788GRP-1251NAVIGATE-HMO
ENRENR-1217692026-04-06T15:56:47ZJACOB—HALL06/06/2001uhc-90583-09null911-998-5675jacob.hall@yahoo.com2618 RIDGE RDPhoenixAZ·85094GRP-1696NAVIGATE-HMO
ENRENR-118235 2026-06-13T01:47:07ZAlbert—Marshall·Jul 4, 1991UHC-01330-32•••-••-8078219-670-5939—8011 Maple AvenuePLANOTX75058GRP-2688OPTIONS-PPO
ENRENR-1347932026-07-02T15:42:09ZJoseph—Spencer1986-06-21UHC-96572-28•••-••-9793(615) 921-4378joseph.spencer@yahoo.com··8039 Central AveOrlandoFL32892-2924GRP-1880MEDICARE-ADV-A
ENRENR-1376622026-04-29T05:30:41ZPriyaT.Wallace1976-03-25UHC-67155-68•••-••-5863null····1256 PARK PLACEOrlandoFL32801··GRP-9858NAVIGATE-HMO
ENRENR-1257942026-04-14T11:59:41ZBRUCE—BRYANT2000-02-16UHC-90920-70•••-••-6355(584) 992-7490BRUCE.BRYANT11@OUTLOOK.COM2016 Grand Avenue Apt 13Eden PrairieMN55361-9147GRP-3835MEDICARE-ADV-A··
ENRENR-1285402026-02-18T22:16:23ZNicoleACooperUNKNOWNUHC-91874-56•••-••-961315788690100NICOLE.COOPER36@ICLOUD.COM3515 Pine DriveEden Prairie·mn55302GRP-9049MEDICARE-ADV-B
ENRENR-1224082026-05-30T15:35:15Z—F—1958-08-17UHC-62486-62•••-••-22542114088397juan.mccoy@aol.com8094 Market StreetChandlerAZ85237GRP-4114SELECT-EPO
ENRENR-1129052026-03-29T17:15:23ZCharlotte P.—Parker9/7/1998UHC1536754•••-••-0940(648) 942-4426charlotte.parker@icloud.com15 HIGHLAND AVENUE #871·GilbertAZ85272GRP-5379MEDICARE-ADV-B
ENR ENR-1181412026-08-22T05:08:33Z———1975-03-14·UHC-69692-68•••-••-5943+1 808 909 2634carlos.phillips54@yahoo.com3989 Canyon RdATLANTAGA30345··GRP-9857CORE-HMO
ENRENR-1116802026-08-21T22:21:18ZBerb S—Weaver1958-06-24UHC-62451-86•••-••-21025819129100null4612 Cedar LanePHOENIXAZ85009··GRP-4951navigate-hmo
ENRENR-1069122026-09-06T03:28:04Zsophai—rojas··7/8/1998UHC-02551-98•••-••-9035(863) 544-0636sophia.rojas14@gmail.com2983 CANYON RDColumbusOH43274GRP-5451OPTIONS-PPO
ENRENR-1392352026-08-18T09:14:58ZRichardEHall1969-05-12UHC-23913-30•••-••-469819137518973richard.hall@gmail.com9227 Camelback RoadLas Vegasnv89122GRP-2809··MEDICARE-ADV-A
ENRENR-1277612026-10-01T13:38:04ZAmy—Palmer1983-04-08UHC-94950-79•••-••-0033543-604-8804··amy.palmer@yahoo.com1323 Sage CourtEden PrairieMN55319GRP-1140OPTIONS-PPO
ENRENR-1046352026-09-06T15:23:54ZMargaret—Long1942-10-12UHC-58275-24•••-••-5899857-363-1721MARGARET.LONG95@YAHOO.COM3638 LAKE VIEW ROADFresnoCA93736GRP-2263CORE-HMO
ENRENR-128602 2026-01-06T04:36:06ZERIC—PERKINS·1970-07-17UHC-30832-44··—737-887-3712null3134 MOUNTAIN VIEW DRIVEFRESNOCA93767GRP-5473CORE-HMO
ENRENR-1162552026-08-18T03:03:12Z·charlie—soto·10/08/1980UHC-26975-03•••-••-7827376.424.6105N/A833 Jefferson AvenueEden PrairieMN·55352GRP-4512CHOICE-PLUS-PPO
ENRENR-1132022026-05-18T16:00:43Z—P—1985-01-23UHC-31708-64•••-••-3191(941) 337-2476ann.thompson25@outlook.com·2064 Pine DrTempeAZ··85218GRP-1207CHOICE-PLUS-PPO
ENRENR-1120582026-09-30T11:27:09Zsteve·H.miller1998-05-04UHC-10946-99•••-••-2273—stephen.miller@gmail.com7418 MOUNTAIN VIEW DRIVETempeAZ85204·GRP-7393OPTIONS-PPO
ENRENR-103660 2026-06-18T21:27:50ZGeraldPLi1954-12-24UHC-76640-91•••-••-38557913213625gerald.li@icloud.com2913 APACHE BLVDGilbert·AZ85201GRP-8190options-ppo
ENRENR-1406262026-01-24T05:55:06ZLORIM··MURRYA1987-04-03·UHC-21186-90•••-••-23292936997863—1860 Cedar LnSan DiegoCalifornia92120GRP-1954MEDICARE-ADV-B
ENR ENR-1345502026-01-01T23:50:51ZRomeroP.Benjamin1982-12-03UHC-80111-58•••-••-0561+1 326 557 8756·NULL8212 CHURCH STREET··GilbertAZ85295GRP-2900MEDICARE-ADV-A
ENRENR-119769 2026-06-07T23:26:08ZRobert—Bowman24-09-2000uhc-35458-67•••-••-85136237052192robert.bowman@yahoo.com899 ELM STREETPhoenixArizona85024GRP-6701··CORE-HMO
ENRENR-1411422026-02-03T00:53:03ZRebeccaA·Stewart1941-09-21UHC-12215-27•••-••-87825966087482rebecca.stewart32@icloud.com378 Willow CtPLANOTX·75059GRP-1751OPTIONS-PPO
ENRENR-1175182026-10-09T22:03:02ZTorres, Wayne——·1994-02-66UHC-04022-43•••-••-4806NULLN/A5701 Willow CtJacksonvilleFL32236·GRP-6989MEDICARE-ADV-B
ENRENR-1196172026-05-28T18:01:29ZJEREMY—·FERNANDEZ19430617UHC-82545-81—14697208333·jeremy.fernandez79@yahoo.com842 Church Street #661CharlotteNC28265GRP-0714OPTIONS-PPO
ENRENR-1339142026-05-21T11:57:07Z BruceT.Owens··1947-01-12UHC-85462-64•••-••-5716931-717-2731BRUCE.OWENS@GMAIL.COM2822 Cedar LanePhoenix·AZ85080GRP-1537SELECT-EPO
ENRENR-1071502026-06-10T16:59:04ZdianaGhannson01/07/1989··UHC-23006-28•••-••-6345(668) 489-1550N/A2739 HILLCREST RDFresnoCA93730-2141GRP-6143·CHOICE-PLUS-PPO
ENRENR-1192352026-02-03T01:36:54Zdiego—castillo1949-12-03UHC-99368-85•••-••-5528—N/A5556 Central Avenue Apt 4COLUMBUSOH43285GRP-2311MEDICARE-ADV-A
ENRENR-1310562026-04-09T15:01:37ZJanetGMedina1969-11-27UHC-08466-39—+1 825 630 2595janet.medina@proton.me9565 LAKE VIEW ROADScottsdaleAZ85226-0554GRP-9184SELECT-EPO
43,101 rows, page 198 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:40.336Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty