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-1283072026-01-20T12:25:03ZMaryOCox1991-09-16··UHC9716490•••-••-0087—MARY.COX@ICLOUD.COM7706 Ridge RoadPlanoTX75006GRP-6549medicare-adv-a
ENRENR-1424502026-04-10T07:39:00ZoliviaHrichards1954-07-12UHC-88327-04•••-••-9396·601-855-6690null303 Ocean AvenueTempeAZ85256GRP-5924CHOICE-PLUS-PPO
ENRENR-1209222026-07-21T14:45:05ZJUDITHL··SULLIVAN10/22/2008UHC-27263-13•••-••-64493807746607judith.sullivan@gmail.com3145 Willow CourtTampaFL33674GRP-2861·choice-plus-ppo
ENRENR-1328402026-01-01T00:47:32ZGomez, PatrickA—1989-03-08UHC-18451-51•••-••-0233(310) 412-2600patrick.gomez@proton.me9535 Willow CtCharlotteNC28242GRP-0136MEDICARE-ADV-A
ENRENR-1316022026-09-02T02:36:55ZRice, DorisT····1964-04-25··UHC-90955-10•••-••-4487(266) 667-1217DORIS.RICE71@OUTLOOK.COM9774 Palm DriveSeattleWA98119GRP-3061CHOICE-PLUS-PPO
ENRENR-1278912026-08-13T16:42:06ZSamuelVAguilar10/21/45UHC-17837-77•••-••-1391+1 407 259 4636—·3030 Indian School RdMINNEAPOLISMN55418GRP-1646NAVIGATE-HMO
ENRENR-1087892026-02-02T10:19:40Z·Carol—Montgomery1989-03-10UHC-66751-08•••-••-61355142211318····8749 ELM STREET··TucsonAZ85795GRP-2497·NAVIGATE-HMO
ENRENR-1240732026-05-30T19:05:51ZPamela—Lopez1942-03-06UHC-70393-55—+1 385 298 3272null·1080 RIVER ROADSACRAMENTOCA95824GRP-5455CORE-HMO
ENRENR-1014492026-06-22T05:54:54ZCamilaG.Austin20010525UHC-06304-18•••-••-56252912087511camila.austin@gmail.com3279 SAGE COURTMesaAZ—GRP-3075MEDICARE-ADV-B
ENRENR-1255952026-01-08T15:55:23ZYuki—Harvey1997-05-09UHC1631639•••-••-10552508728767yuki.harvey@aol.com2071 Mesa Drive·TampaFlorida33619GRP-1756SELECT-EPO
ENRENR-1105972026-02-06T18:06:49ZMELISSAEELLIS2008-04-05UHC-92087-18··576-714-0166MELISSA.ELLIS88@PROTON.ME2708 ELM STREETHoustonTX77066GRP-4889medicare-adv-a
ENRENR-141760 2026-01-20T05:43:26Zcharles—burke01/12/44UHC-65217-11•••-••-7435+1 674 649 6741charles.burke49@proton.me7974 MEADOW LNAustinTX78770GRP-5389NAVIGATE-HMO
ENRENR-1114902026-01-31T21:48:11ZJudithU.Roberts2008-06-03UHC-23840-12•••-••-7475(658) 834-0136-3639 Elm StreetJacksonvilleFL32205GRP-5071MEDICARE-ADV-B
ENRENR-1274172026-08-12T15:49:41ZMARY·NDEAN1963-05-04—•••-••-1582(290) 668-4490mary.dean78@yahoo.com···2050 FOREST AVENUEScottsdaleAZ85218GRP-5123SELECT-EPO
ENRENR-1409372026-03-07T05:55:09ZJudith—Soto·1986-06-03UHC-62709-88•••-••-1413+1 816 490 9586··UNKNOWN9373 Sunset BlvdAustinTX78730GRP-1565OPTIONS-PPO
ENRENR-1057462026-04-27T23:56:23ZKenneth—Martinez1954-10-11UHC-28095-14•••-••-5314327-607-7067kenneth.martinez85@gmail.com6419 Cedar LnSeattleWA98101GRP-2734CHOICE-PLUS-PPO
ENRENR-1377632026-06-03T09:42:57Z·BillyZ.Vargas10/23/1955UHC-55865-83•••-••-0864—billy.vargas@icloud.com4649 SAGE CTSAN ANTONIOtx78278GRP-9643NAVIGATE-HMO
ENRENR-1416172026-08-10T21:18:27ZMariaM.Armstrong1955-12-24UHC-22895-17•••-••-5822——9894 Ocean AvenueJacksonvilleFL32211GRP-9533CORE-HMO
ENR ENR-1266872026-01-06T09:09:28ZJefreyKCarter1957-01-25UHC-22659-67•••-••-77306895492969NULL4976 Church StMesaAZ··85247··GRP-7500OPTIONS-PPO
ENRENR-1404192026-03-31T23:06:34ZSimmons, Carolyn——4/5/1960UHC9381096•••-••-9808+1 876 651 6529CAROLYN.SIMMONS@AOL.COM··UNKNOWN-N/A·null·GRP-1151SELECT-EPO
ENRENR-1155242026-01-10T05:40:13ZRuiz, LauraO—1990-01-04UHC-43485-07NULL416-684-7795laura.ruiz@yahoo.com··2480 Elm StreetPLANOTXnullGRP-7996CHOICE-PLUS-PPO
ENRENR-1424272026-03-16T09:20:35ZNathanSWong1994-08-24UHC-51041-73•••-••-6202(377) 408-7632NATHAN.WONG@OUTLOOK.COM1046 Spring StreetChandlerAZ85273GRP-6669NAVIGATE-HMO
ENRENR-1180362026-08-02T14:28:49ZChristina—VasquezFeb 21, 1948UHC-08040-09null601-910-3402—3803 Apache BlvdAtlantaGA30381GRP-7398CORE-HMO
ENRENR-1354282026-01-30T19:24:40Z Lynch, Alexander——1963-07-08UHC-82665-74•••-••-0992·+1 285 649 5559—2382 Market St #594Eden PrairieMN55384GRP-4456OPTIONS-PPO
ENRENR-1254722026-01-10T21:04:05ZVickyOEllis·1988-06-14UHC-96694-67•••-••-6767412-919-3721VICTORIA.ELLIS@YAHOO.COM2315 MARKET STLas VegasNV89118GRP-6328MEDICARE-ADV-B
ENRENR-1231382026-07-05T22:03:27ZKatherineL.Long1943-09-23UHC-36203-34•••-••-62789599584578—903 Market St···TucsonAZ85766GRP-8472CHOICE-PLUS-PPO
ENRENR-1165322026-10-04T08:02:00Z·GREGORYX.PEREZ··May 25, 1972··UHC-27476-32•••-••-8082795-465-9941gregory.perez25@icloud.com7630 BroadwayTucsonArizona85735GRP-0122CORE-HMO··
ENRENR-1151462026-01-23T03:44:39ZALEXANDERJCASTRO07/15/1938UHC-91968-47NULL+1 282 389 8969alexander.castro@proton.me6520 Apache BlvdScottsdaleAZ85242GRP-7418MEDICARE-ADV-B
ENRENR-1350952026-06-27T01:07:31ZKim—Stewart1998-11-18UHC-36132-22•••-••-9322501-716-2596kimberly.stewart@gmail.com7738 Harbor BoulevardDenverCO80243·GRP-2761MEDICARE-ADV-B··
ENRENR-1167722026-04-27T15:20:14ZalanA·morgan1943-03-07UHC-86110-59•••-••-8783(237) 596-9383alan.morgan14@icloud.com1779 Pine DrTucsonArizona85744GRP-6021SELECT-EPO
ENRENR-1026922026-03-11T22:40:10ZERICZEVANS19791117UHC-19665-16•••-••-6176+1 536 659 9517eric.evans82@proton.me8003 Desert Sky BoulevardScottsdaleAZ85243GRP-5903SELECT-EPO
ENRENR-1303922026-02-14T18:00:42ZNicole—Mitchell1993-06-03UHC2387561•••-••-17804124848918NICOLE.MITCHELL@GMAIL.COM5297 BROADWAY··SCOTTSDALEAZ85288GRP-2104CHOICE-PLUS-PPO
ENRENR-1168062026-05-24T07:49:31ZEvans, LoganS.—03/16/1999UHC-46383-50•••-••-0693(453) 427-7399—7167 Valley View Dr Apt 16FresnoCA93766GRP-2041CHOICE-PLUS-PPO
ENRENR-1310302026-03-01T03:30:07ZDotMWalker01/10/1977uhc-49183-67—614-645-2238DOROTHY.WALKER@YAHOO.COM7010 Harbor BoulevardDENVERCO80231GRP-1390SELECT-EPO
ENRENR-1383002026-09-27T09:56:38ZRachelBMorrison9143-02-28UHC-19461-26•••-••-6028+1 746 593 2620rachel.morrison@proton.me9587 Elm StColumbusOH43284GRP-3312NAVIGATE-HMO
ENRENR-1423562026-07-25T19:44:29ZJulieNKnight1989-05-17UHC-71373-79•••-••-5291(762) 996-6026julie.knight@proton.me9298 Lake View RdTUCSONAZ-GRP-1902MEDICARE-ADV-B
ENRENR-1262122026-02-15T15:38:08ZLawrence··—Jacson10/08/72UHC-33336-58•••-••-84274302933514LAWRENCE.JACKSON47@PROTON.ME·3008 Ocean AvenueAustinTX78710GRP-4927CORE-HMO
ENRENR-1148882026-05-20T04:07:43ZJOSEMBOWMAN01-04-1977—•••-••-9847459-779-1437JOSE.BOWMAN52@PROTON.ME1825 Maple Ave #872GilbertAZ85250GRP-3321SELECT-EPO
ENRENR-1068522026-09-12T08:35:50ZbradleyOtran1967-01-22UHC-24626-93•••-••-5960(972) 202-8941bradley.tran67@proton.me1840 Mesa DrNashvilleTN·37257GRP-3216SELECT-EPO
ENRENR-1072482026-05-28T09:41:46Z Vlentina··I.·Perry1980-12-17UHC-78963-08•••-••-5433755-401-1994—7591 Willow Ct Apt 25·GilbertAZ·85231GRP-6130CORE-HMO··
ENRENR-1224442026-01-15T00:11:08ZLori—Nunez2002-06-18UHC-64875-75•••-••-14302807529601lori.nunez@yahoo.com·2267 HARBOR BLVDGlendaleAZ85337GRP-6288··SELECT-EPO
ENRENR-1107312026-02-17T10:31:49ZKelly··—Park1961-01-15UHC-03415-63•••-••-2598+1 500 604 1013kelly.park76@yahoo.com1235 Camelback Road #977DallasTX75231GRP-1200OPTIONS-PPO
ENRENR-1115352026-07-16T23:31:29ZCarol—James05/14/1950UHC3876126•••-••-0210—·CAROL.JAMES91@HOTMAIL.COM7188 Market StCHANDLER··AZ85254GRP-6761MEDICARE-ADV-A
ENRENR-1372062026-10-07T05:35:10Z HelenYGordon1948-02-03UHC-94111-71•••-••-4051921-494-0815NULL7857 Mesa DrAUSTINTXnullGRP-1199MEDICARE-ADV-A
ENRENR-1222312026-09-16T03:57:33Z·LIZ—GORDON··1967-02-14UHC-31740-79•••-••-1520(340) 627-7333ELIZABETH.GORDON24@PROTON.ME4061 Camelback RdMiamiFL33161-8678GRP-7298MEDICARE-ADV-B
ENRENR-1005832026-05-12T15:31:39ZRussellURojas1997-01-15UHC-60967-93•••-••-7426858-942-3947RUSSELL.ROJAS@GMAIL.COM··3909 Spring StreetSacramentoCA95899GRP-5571CORE-HMO
ENRENR-1264262026-04-23T08:58:55ZJamesWWilson1998-04-08UHC-29080-56•••-••-6929(837) 270-2924james.wilson@outlook.com1459 MESA DRFresnoCA93700GRP-5868NAVIGATE-HMO
ENRENR-1197782026-04-28T00:47:38ZReymond—Padilla1948-06-08UHC-70470-12•••-••-8402884-765-7530raymond.padilla@proton.me2094 BroadwayColumbusOhio43299GRP-0600CORE-HMO
ENRENR-1240982026-02-09T20:15:14Z·KeithS.Webb19951016UHC-92115-80•••-••-35434146552867—5609 Elm StreetMiamiFL33185-7072GRP-5311SELECT-EPO
ENRENR-1325672026-04-20T21:42:40ZBettyPWang1977-05-08UHC-94692-83•••-••-7064373-501-9281betty.wang@outlook.com2663 Park PlaceGlendaleAZ85335GRP-6819NAVIGATE-HMO
43,101 rows, page 184 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.320Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty