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-1183412026-10-17T10:43:14ZSeanFWong19851007UHC-61691-35•••-••-10876413748096sean.wong@hotmail.com9582 Cedar LaneCHARLOTTENC·28250·GRP-6353CORE-HMO
ENRENR-1392762026-07-02T17:09:23ZDANIELLE····AUSTIN·08/11/1971UHC-75102-81•••-••-76873442004802danielle.austin91@gmail.com8500 CANYON ROADMINNEAPOLISMN55406-1542GRP-5513CHOICE-PLUS-PPO
ENRENR-1166232026-09-21T06:42:52ZKATHERINEBSNYDER19820512UHC-79450-77•••-••-15214411543katherine.snyder@gmail.com9191 Broadway··FRESNOCA93754GRP-2071MEDICARE-ADV-A
ENRENR-1261092026-02-24T19:06:46Zcheryl—·harper1996-10-02UHC-35989-19•••-••-0345·(564) 993-3179·cheryl.harper85@yahoo.com404 LINCOLN WAYSAN ANTONIOTX··78233GRP-2770CORE-HMO
ENRENR-1387432026-01-22T14:56:24ZCarol—Duncan1943-10-11—•••-••-33016039047913N/A9468 FOREST AVE·ScottsdaleAZ85254GRP-5927CORE-HMO
ENRENR-1117992026-08-26T16:34:55ZPamela—Warren03/22/1990UHC-00901-01··•••-••-11907324083095pamela.warren@aol.com3176 Park PlaceGilbertAZ85246··GRP-3914MEDICARE-ADV-A
ENRENR-1209792026-10-17T11:15:37ZMichelle—Nguyen··2003-03-17UHC-02324-74•••-••-9303612-266-3828MICHELLE.NGUYEN89@YAHOO.COM·8672 Canyon RdLos AngelesCA90064GRP-7364CORE-HMO
ENRENR-1234012026-09-04T06:19:29ZJordan····Mitchell19990113UHC-41287-90•••-••-23419138838022—882 LAKE VIEW ROADDallasTX·75281GRP-0503OPTIONS-PPO
ENRENR-1187822026-07-04T17:55:26Zamy—castro1983-12-12UHC-26944-46•••-••-3200(254) 252-2709amy.castro@proton.me4080 Canyon RoadMesaAZ··GRP-9807CORE-HMO
ENRENR-1256762026-02-17T20:54:25ZBRITTANY—TURNER··1961-11-15UHC-11003-49····595-710-1585brittany.turner@hotmail.com2023 Pine DriveJACKSONVILLEFL32206GRP-8718CHOICE-PLUS-PPO
ENR ENR-1015502026-09-21T08:55:09ZJohnstonH··Dennis5/19/1972UHC-69425-36•••-••-3368698-730-8122dennis.johnston@aol.com7985 RIDGE RDMiamiFL··33173GRP-1519SELECT-EPO··
ENRENR-1335962026-07-16T23:05:53ZDaniel—Yang1997-09-21UHC-36268-56··•••-••-3100378.516.4732DANIEL.YANG@GMAIL.COM9639 Union StTampaFL33698GRP-9690·CHOICE-PLUS-PPO
ENR ENR-1096872026-09-24T14:36:27ZArthurALuces1954-04-24UHC-21109-17•••-••-0418(651) 741-3344··9504 River RdATLANTAGA30300··GRP-4570MEDICARE-ADV-B
ENRENR-1054022026-05-07T22:08:53ZAARONS.·LARSON05/07/1996UHC8183384··•••-••-0553683-991-9805NULL3534 UNION STREETNashvilleTennessee37256GRP-9922OPTIONS-PPO
ENRENR-1187372026-07-01T10:51:44ZRachel—Kelly1944-02-27UHC-94298-23•••-••-432518564026237rachel.kelly80@aol.com572 Market StreetChandlerAZ85231·GRP-6592CHOICE-PLUS-PPO
ENRENR-1131752026-04-24T08:18:03ZKATHERINEEMILLER1984-12-02··UHC-58586-85NULL15384945333KATHERINE.MILLER@YAHOO.COM1585 INDIAN SCHOOL RDMESAAZ85204GRP-7166CORE-HMO
ENRENR-1271112026-01-07T22:51:46Z·albertRramos03/19/44UHC-72345-89•••-••-5449433-235-6686albert.ramos14@icloud.com1251 Lincoln WayJacksonvilleFL··32291GRP-6986CORE-HMO
ENRENR-1207672026-06-04T01:24:45Z HenryTColeman1964-07-19UHC-30616-62•••-••-5851261-864-6183·henry.coleman@yahoo.com2120 Lincoln WayAtlantaGA30382GRP-6994MEDICARE-ADV-B
ENRENR-1279972026-03-29T11:54:20ZNickYJacobs1984-09-18UHC-63369-61•••-••-7193+1 334 656 4488nicholas.jacobs71@outlook.com3122 Bayshore Drive·SacramentoCA95821GRP-3679SELECT-EPO
ENRENR-1179112026-01-29T05:38:26Z WalterC.Scott11-07-1973UHC-43191-42•••-••-54869597036053··walter.scott6@yahoo.com6354 Canyon RoadLas VegasNevada89166GRP-6849NAVIGATE-HMO
ENRENR-1146832026-07-15T19:13:19ZJoseW·Fulleer2001-03-22UHC-64364-99··•••-••-2560(364) 220-8307jose.fuller@aol.com5346 BASELINE RDHouston··TX77005-1297GRP-1519CHOICE-PLUS-PPO
ENRENR-1208312026-03-13T17:53:45ZEllis, Julie——1/14/2004·uhc-65562-64•••-••-99575219071440julie.ellis@yahoo.com4689 HIGHLAND AVEAtlantaGA30302GRP-2633OPTIONS-PPO
ENRENR-1192432026-05-16T13:12:41ZSharonYGuzman1994-07-20UHC-16998-40•••-••-6360562-607-9599sharon.guzman26@aol.com2875 Harbor BoulevardGILBERTAZ—GRP-3627NAVIGATE-HMO
ENRENR-1160052026-01-19T19:48:06ZAna—Washington1971-05-28·UHC-81270-94•••-••-560819269385747ANA.WASHINGTON87@OUTLOOK.COM1462 Market StreetCharlotteNC28267GRP-7244·MEDICARE-ADV-B
ENRENR-1420472026-02-22T11:24:30Z RandyW.Scutt··1973-03-08UHC-99947-20•••-••-09114326178920randy.scott2@proton.me2010 SUNSET BOULEVARDTAMPA·Florida33625GRP-0945NAVIGATE-HMO
ENRENR-1335202026-02-08T15:27:11ZOliver, JustinK—Aug 14, 1964UHC-86048-11•••-••-0133535.443.6709-7132 Church StLAS VEGASNV89195GRP-3453OPTIONS-PPO
ENRENR-1192552026-01-09T22:18:12Z Alex—Vasquez1951-09-23UHC-55510-39•••-••-6028(797) 362-5493alexander.vasquez@gmail.com··4517 RIDGE ROADSEATTLEWA98176-5432GRP-4398OPTIONS-PPO
ENRENR-1260482026-04-24T07:44:50ZChrisEMeyer2004-02-28UHC-40579-79•••-••-7441517-883-8557N/A—NULL··-N/AGRP-0386OPTIONS-PPO··
ENRENR-1335232026-05-14T02:54:29ZRaymondBCastro1983-01-07UHC-76265-21•••-••-1075(811) 534-1207NULL6579 Palm DriveCHARLOTTE··NC28275GRP-6630NAVIGATE-HMO
ENRENR-1429062026-08-28T03:02:10ZBruce—Bennett1966-04-06UHC-40458-10•••-••-64592022203023NULL1262 Union StreetMiamiFL33108GRP-7113CHOICE-PLUS-PPO··
ENRENR-1217322026-03-03T14:34:01ZAMY—THOMPSON1987-11-09UHC-57787-63•••-••-0394(899) 794-9203null··364 PINE DRPHOENIX·AZ85006GRP-7975MEDICARE-ADV-A
ENRENR-1356682026-08-16T03:24:47ZKein X··—Wilson1960-09-02UHC-38865-86•••-••-9652—kevin.wilson@hotmail.com2872 WILLOW CTPhoenixAZ85095GRP-3606MEDICARE-ADV-B
ENRENR-1143202026-07-23T10:49:03ZJoseVHenry11/15/1970UHC-69072-64•••-••-72508526459556-4364 Willow CourtSEATTLE··Washington98100GRP-1528MEDICARE-ADV-A
ENRENR-1331382026-07-26T21:56:25ZDIEGOZ··CASTRO··1991-08-10UHC-19074-97•••-••-0129(728) 476-0478diego.castro46@outlook.com126 Central AveLOS ANGELESCA90070GRP-5688CORE-HMO
ENRENR-1361682026-08-16T16:03:24Z·BarbaraIHill1960-06-04UHC-19938-69•••-••-9607+1 608 666 0712N/A·1519 UNION STREETAtlantaGA30317GRP-7581CORE-HMO
ENRENR-1065112026-10-03T15:36:27ZARJUUNFLOPEZ1959-11-20UHC-85521-93•••-••-90102255641562arjun.lopez@aol.com5286 Highland AveLOS ANGELESCA90011GRP-9325CORE-HMO
ENRENR-1026222026-04-17T08:19:57ZYuki—Weber2002-03-09UHC-48105-66•••-••-72235746795371null4223 HARBOR BLVDLos AngelesCalifornia90071GRP-2144CORE-HMO
ENRENR-1260952026-10-12T19:23:39ZAdamT.Dixon07/03/74UHC-43173-48•••-••-88473246179309adam.dixon@gmail.com1990 Mesa DrTempeAZ85257GRP-9698··SELECT-EPO
ENRENR-1251032026-07-11T06:59:44ZWeaver, Timothy——05-06-1963UHC-19209-26•••-••-4814+1 547 690 5622timothy.weaver26@hotmail.com5192 Park PlPLANOTX75064GRP-4094CHOICE-PLUS-PPO
ENRENR-1409572026-03-15T17:20:44ZEvelynKHerrera1951-07-16UHC-76171-21•••-••-2624—evelyn.herrera14@gmail.com5146 Baseline RoadJacksonvillefl32213GRP-4000·SELECT-EPO
ENRENR-1308742026-09-14T11:16:51ZAaron—Rojjas3/27/1938··UHC-10065-30•••-••-7345(449) 370-1999AARON.ROJAS95@GMAIL.COM7749 Mesa DrGilbertAZ85225GRP-6329NAVIGATE-HMO··
ENRENR-1413452026-06-20T18:13:45ZAmy····Turner·1980-07-11UHC-57975-21•••-••-7164UNKNOWNnull7126 UNION STGilbertAZ85227GRP-2371SELECT-EPO
ENRENR-1165852026-03-30T14:20:25ZPatrick—Welch1952-01-17UHC3232336•••-••-1187·371-251-9067patrick.welch@aol.com8468 Indian School Road #230TampaFLNULLGRP-8810CORE-HMO
ENRENR-1063662026-07-12T10:18:35ZHEATHERY.KIM·1963-12-23UHC-34790-91•••-••-32434565647871heather.kim11@outlook.com210 Elm StFresnoCA93707GRP-0598SELECT-EPO
ENRENR-1165422026-08-06T10:19:23ZLoriQ.Vargas12/18/1997UHC-17687-76•••-••-915719589706145-7352 River RoadHOUSTONTX77015GRP-5093MEDICARE-ADV-B
ENRENR-1078912026-02-27T19:18:00ZElijah—Moore20020106UHC-84075-79•••-••-7032(962) 985-5846elijah.moore@proton.me9244 Sunset BoulevardSeattleWA98185-5666GRP-4879OPTIONS-PPO
ENRENR-1307162026-08-06T18:06:06ZDANIELLENBURNS1965-08-03UHC-52250-99•••-••-9843+1 822 719 3032DANIELLE.BURNS@ICLOUD.COM5746 OAK STNashvilleTennessee37224GRP-5411SELECT-EPO
ENRENR-1062982026-07-05T11:54:12ZMateo—Jensen1951-05-24·UHC-06843-43•••-••-91035768673999mateo.jensen65@aol.com6887 BROADWAYSan DiegoCA92148GRP-8844SELECT-EPO
ENRENR-127213 2026-03-19T08:52:59ZDYLNA—MORRISONOct 20, 1988UHC-65054-17—(662) 649-5574··dylan.morrison48@yahoo.com40 Apache BlvdTucsonAZ85716GRP-5271medicare-adv-b
ENRENR-1360152026-09-11T00:13:27Z·RICHARDV.JORDAN2005-03-20UHC-30947-21•••-••-37457356244395richard.jordan98@outlook.com·7025 Market StreetCOLUMBUSOH43230GRP-0279NAVIGATE-HMO
43,101 rows, page 316 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.610Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty