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-1164342026-07-10T15:25:43ZWAYNEA.SANCHEZ1962-10-15UHC-45559-54•••-••-1081239-398-7526null3186 Harbor BoulevardLos AngelesCA·90080-4656GRP-8351CORE-HMO
ENRENR-137771 2026-05-18T04:05:07ZBetty··T.Bradley8/20/1969UHC-60903-87•••-••-11958606396274·betty.bradley49@outlook.com8814 Broadway·Orlando·fl·32856GRP-3282CORE-HMO
ENRENR-1185142026-09-24T04:46:59ZJOEJMEDINA1974-12-09UHC-20462-95•••-••-5033(205) 418-2823—4669 Maple AveCharlotteNorth Carolina·28233GRP-7916NAVIGATE-HMO
ENRENR-1224662026-08-31T00:04:22ZGRACEY.ROMERO01/21/2000UHC-22850-73•••-••-6657(570) 551-4475NULL2205 GRAND AVEGlendaleAZ85300GRP-5050NAVIGATE-HMO
ENRENR-1057632026-07-19T13:58:41ZKimberly—Murphy01/22/1992UHC-37472-12•••-••-8443·(487) 306-2774—3584 Pine DrSacramentoCA·95871GRP-2707NAVIGATE-HMO
ENRENR-1120502026-07-06T01:40:04ZCAMILA—GILBERT·1964-06-20UHC-10301-60•••-••-454217723827917camila.gilbert@yahoo.com··3797 Grand AveAtlanta··GA30371GRP-2733MEDICARE-ADV-B
ENRENR-1191572026-09-22T14:14:37ZGRACER.STONE10/07/1991UHC-67144-84•••-••-7803N/A-8990 ELM STREETSan AntonioTXUNKNOWNGRP-2071MEDICARE-ADV-B
ENRENR-1262192026-09-11T04:21:54ZLisa—Dunn1940-11-09UHC-09379-62··•••-••-73576915743293-999 River RdAustinTX·78730GRP-8637SELECT-EPO
ENRENR-1114952026-01-18T04:53:19ZannaIbryant11-08-1956UHC-91893-88•••-••-2855791-285-1692anna.bryant@hotmail.com3534 Grand AveNASHVILLE·TN—GRP-5268OPTIONS-PPO
ENRENR-1147562026-09-14T22:01:07ZIsabellaCJimenez2/4/1993UHC-62078-40•••-••-9404(373) 626-7813isabella.jimenez31@outlook.com·6914 Mesa DriveMinneapolisMN··55470GRP-9585SELECT-EPO
ENRENR-1282202026-10-11T17:22:45ZWANE—WASHINGTON19801120UHC-91813-15··•••-••-77549368187609—1523 BASELINE RDTampa·FL33673GRP-9105MEDICARE-ADV-B
ENRENR-1088362026-04-27T09:34:26ZCarr, Lucia——22-08-1953UHC-41053-35•••-••-3350(240) 834-5807lucia.carr@yahoo.com6548 Pine DriveChandler··AZ85230GRP-3400OPTIONS-PPO
ENRENR-1340112026-09-04T01:28:29ZMcDoneld, GeraldD.—Jun 24, 1983UHC-64643-77N/A475.467.1173gerald.mcdonald@icloud.com4680 Forest AveTUCSONAZ85777-3875GRP-5205OPTIONS-PPO
ENRENR-1386612026-07-29T14:03:27ZKaren—Kim1956-08-16UHC4964852—472-509-9693karen.kim@aol.com1830 BroadwayLas VegasNVNULLGRP-7350CHOICE-PLUS-PPO
ENRENR-120082 2026-10-18T04:28:45Z·Oliver, Diana Q.——2003-10-02UHC-09068-41•••-••-84333282569089diana.oliver@proton.me4633 HILLCREST RDSeattleWA98134GRP-1583·MEDICARE-ADV-A
ENRENR-1073182026-04-07T22:04:25ZGomez, Mason—····1962-04-19UHC-14665-92•••-••-2558795-508-1423··mason.gomez3@proton.me————GRP-0166MEDICARE-ADV-A
ENRENR-1004192026-08-03T11:48:10ZCAROLYN····FERNANDEZ01/27/1976UHC-19740-97•••-••-9399(764) 631-3760carolyn.fernandez84@aol.com6529 Central AveHoustonTX77055GRP-9672CORE-HMO
ENRENR-1145442026-03-01T12:28:54ZKayylaCStevens1955-04-05UHC-87096-87•••-••-6503866-419-6050—4634 BroadwayDenverCO80227GRP-3487CORE-HMO
ENRENR-1272662026-03-28T00:45:00ZYUKI··—GILBERT1979-05-10UHC-46492-88•••-••-2312NULLyuki.gilbert79@outlook.com4855 BroadwayATLANTAGA30389GRP-4285OPTIONS-PPO
ENRENR-1373692026-01-19T14:55:03Z·RachelXRussell1991-04-22UHC-59733-49•••-••-833818517869926—8899 FOREST AVEGlendale··AZ85398-5349GRP-5525MEDICARE-ADV-B
ENRENR-1348522026-02-15T01:22:18ZNATALIE—WOODS01-09-1940·UHC-23619-40•••-••-5564N/Anatalie.woods49@outlook.com··8158 Oak StCOLUMBUSOH43281GRP-9151CHOICE-PLUS-PPO
ENRENR-1073722026-02-24T06:48:31ZAmanda—Alvarez1987-08-08·UHC-52288-81•••-••-0366(318) 303-4512····1468 Apache BlvdHoustonTX77004-8206·GRP-5230NAVIGATE-HMO
ENRENR-1086782026-09-11T23:56:31ZPriyaNAdams05/26/08UHC-46347-96•••-••-0115(321) 860-8794priya.adams82@proton.me2718 Washington StMIAMIFL33122GRP-6573OPTIONS-PPO
ENRENR-1406802026-08-26T19:08:14ZRICHARDTWELLS6/8/1947UHC-81803-04null3956808131richard.wells@icloud.com6092 Camelback RoadFresnoCalifornia·nullGRP-3493·CORE-HMO
ENRENR-1227812026-04-02T06:30:47ZpaulJgarcia·02/09/43UHC-60299-61•••-••-267812393254695paul.garcia47@aol.com267 Indian School RdDenverCO80250·GRP-0492OPTIONS-PPO
ENRENR-1253842026-09-16T02:47:27Z marcus—carroll1943-06-03UHC-73414-40•••-••-18212709835662N/A7067 Grand AveOrlando··FL32832GRP-9445SELECT-EPO
ENRENR-1283992026-07-20T13:42:52ZJUDYJHENDERSON1973-01-23UHC-53252-69•••-••-678518753161429N/A4191 RIDGE RDEDEN PRAIRIEMN55354GRP-4527SELECT-EPO
ENRENR-1067262026-06-29T15:55:51Z·RANDYT·MILLER1965-10-28UHC-14631-72•••-••-84508574042444—6981 SPRING ST #775DallasTX75209GRP-0604core-hmo
ENRENR-1106012026-10-04T09:59:29ZCarlosPStewrt1996-06-01UHC-94711-24•••-••-0629474.748.5153N/A8243 HIGHLAND AVENUEMIAMIFL33144GRP-8093NAVIGATE-HMO
ENRENR-1280072026-04-04T16:44:56ZBaker, Cynthia——1938-09-16UHC-45011-80—(454) 780-1181NULL5643 Park PlacePhoenixArizona85044GRP-1877CORE-HMO··
ENRENR-1348722026-04-15T16:22:10ZSantos, JulieY—5/7/2007UHC-40432-33•••-••-14775427846275julie.santos@outlook.com6524 CANYON ROAD #409San DiegoCA92157GRP-2428CORE-HMO
ENRENR-1401952026-08-12T19:20:34ZPETER—BURTON12/18/1996UHC-38405-46—·(782) 501-9637PETER.BURTON@AOL.COM··9727 Cedar LnHoustonTX77034GRP-4061NAVIGATE-HMO
ENRENR-1314132026-04-13T08:51:19ZMark····MurphySep 16, 1974UHC2009681-··(295) 672-3236mark.murphy76@icloud.com5966 Oak StSeattleWA98175GRP-6726MEDICARE-ADV-B
ENRENR-1188372026-05-21T03:50:52ZWayne—·James1980-49-04UHC-68623-27NULL986-719-9525···WAYNE.JAMES85@OUTLOOK.COM75 WILLOW COURTGilbertAZ··UNKNOWNGRP-2362OPTIONS-PPO
ENRENR-1209992026-01-25T15:17:43ZDANIELKRAMIREZ15-09-1992UHC-57427-66•••-••-8451672.771.5403daniel.ramirez7@icloud.com815 Sunset BoulevardMIAMIFL··33128-9233GRP-8810MEDICARE-ADV-A
ENRENR-1352342026-02-18T22:32:09ZLarry—Singh·07/15/04UHC5536097•••-••-1069228-655-7941··larry.singh90@outlook.com3589 Main Street Apt 37·LOS ANGELESCA90036GRP-5533MEDICARE-ADV-A
ENRENR-1164452026-08-24T03:22:17ZDorothy—Miller1954-02-12UHC-64063-32•••-••-3620—dorothy.miller@outlook.com4955 Mountain View DrOrlandoFL32881GRP-3708CHOICE-PLUS-PPO
ENRENR-1174162026-05-17T18:22:50ZSUSAN—KING1980-11-07UHC-87239-11•••-••-1015521-626-2677susan.king@aol.com7530 APACHE BOULEVARD·ScottsdaleAZNULLGRP-7976CHOICE-PLUS-PPO
ENRENR-1389922026-02-21T07:40:48ZCHRISTINA—JIMENEZ1944-06-26UHC-96348-19•••-••-9342579-492-4252CHRISTINA.JIMENEZ5@ICLOUD.COM1998 Desert Sky BlvdScottsdale·Arizona85279GRP-0510CHOICE-PLUS-PPO
ENRENR-1348012026-03-17T14:26:08Zstephanie····mooreNULLUHC-96480-12•••-••-47225987382091—4646 Ridge Rd Apt 26San AntonioTX78256GRP-2766··SELECT-EPO
ENRENR-1379002026-09-22T16:00:26ZCherryl—·Weaver1965-09-19UHC-95983-89··•••-••-64635348404923cheryl.weaver@hotmail.com5516 LAKE VIEW RDMiamiFL33126GRP-9760MEDICARE-ADV-B
ENRENR-1181122026-09-22T19:00:37ZMeiULee1978-11-25UHC-02340-97•••-••-69277928350936MEI.LEE45@OUTLOOK.COM4010 Central AvenueDenverCO··GRP-6589·NAVIGATE-HMO
ENRENR-137262 2026-05-07T15:33:51ZWaltre B··BowmanApr 16, 1971UHC-06407-48•••-••-27788293895963·UNKNOWN9491 APACHE BLVDHoustonTX77035GRP-4410MEDICARE-ADV-B
ENRENR-1054732026-04-13T19:38:08ZCAROL—PERRY1987-06-27··UHC-00745-17•••-••-70256725718460—2551 Washington StreetPlanoTX75043-9888GRP-8644CHOICE-PLUS-PPO
ENRENR-1016372026-06-01T20:19:51ZParker, JeffreyQ—1957-09-12UHC-89349-27•••-••-36752990320JEFFREY.PARKER17@ICLOUD.COM··408 Oak Street·OrlandoFL32858GRP-7338MEDICARE-ADV-A
ENRENR-1287172026-08-01T03:10:10ZPamela—EspinozaApr 25, 1982UHC-94759-24•••-••-4210+1 726 486 6055pamela.espinoza59@outlook.com7928 Mountain View DriveGilbertAZ85220GRP-3709CORE-HMO
ENRENR-1322422026-05-15T21:16:58ZJEANF.·PEANNov 26, 1952UHC-63144-44•••-••-7573682-522-6386jean.pena@hotmail.com2729 MARKET STSan Antonio··TX78227GRP-2717CHOICE-PLUS-PPO
ENRENR-1005572026-02-01T02:19:54ZJOOHN—GARDNER··1947-11-06UHC-45824-49—7044809229john.gardner47@icloud.com6299 DESERT SKY BLVD Apt 3AustinTexas78722GRP-1189core-hmo
ENRENR-1199342026-08-07T00:53:16ZJACQUELINE··KMUNOZ1961-08-13UHC-96980-74•••-••-5537····jacqueline.munoz@gmail.com9815 Ocean AveChandlerAZ85278GRP-4369SELECT-EPO
ENRENR-1241592026-09-23T20:52:41Z·CHRISTOPHER—SALAZAR1970-03-16UHC-65937-16•••-••-5581·(963) 431-0917christopher.salazar@outlook.com5154 Cedar LaneTempeAZ85239GRP-3188MEDICARE-ADV-A
43,101 rows, page 239 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.620Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty