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-1193492026-07-09T09:05:08ZMasonU.Pierce10/14/1970UHC-14486-45•••-••-4084(758) 418-3726mason.pierce75@aol.com··5979 Maple AvenueSAN ANTONIOTX·78271-5569GRP-1146core-hmo
ENRENR-1183072026-06-28T11:37:14ZPAUL—ALVAREZ2000-05-10UHC-03927-36—4082071163—7640 Washington StreetHoustonTX77048GRP-1841navigate-hmo
ENRENR-1286872026-02-15T01:00:13ZEthanLJackson1954-04-10UHC-62313-89•••-••-2749558-301-3069NULL801 Main StSan AntonioTX78269GRP-7394OPTIONS-PPO
ENRENR-1017642026-02-10T00:00:20ZBruce—Guerrero1996-06-27UHC-99039-30•••-••-1323+1 563 807 4867—9173 Desert Sky BoulevardAUSTIN·TX78744GRP-0747MEDICARE-ADV-B
ENRENR-1197862026-04-29T17:25:49ZSEANNSANCHEZ·04/04/2007UHC-49749-55··•••-••-1719(771) 929-4805UNKNOWN533 OAK STREETEden PrairieMN55334GRP-5879CHOICE-PLUS-PPO
ENRENR-1132642026-07-10T15:06:02ZMICHELLEOOWENS··18-04-2006UHC-86216-33•••-••-5731646-641-2475NULL3887 Church StreetATLANTAGA30389GRP-8524CHOICE-PLUS-PPO
ENRENR-1206692026-03-28T05:21:57ZKelly—Montgomery5/24/1962UHC-89838-70•••-••-169513537015695N/A8917 Valley View DriveSacramentoCA·UNKNOWNGRP-8798OPTIONS-PPO
ENRENR-1405552026-04-01T11:40:30Z YUKI··—WHITE10/25/1982UHC-87519-70—(404) 440-3581yuki.white86@hotmail.com7035 Baseline RoadScottsdaleAZ·85293GRP-2252MEDICARE-ADV-A
ENRENR-1335942026-04-08T00:26:19ZAMYMRUIZ1999-10-06·UNKNOWN•••-••-70872805193147AMY.RUIZ@PROTON.ME2277 HIGHLAND AVEEden PrairieMinnesota55333GRP-3913core-hmo
ENRENR-1008302026-09-30T14:26:49ZNICKTLAWSON1958-01-19UHC-16478-62•••-••-8448551.802.9643nicholas.lawson@icloud.com1395 Hillcrest RoadAtlantaGA30321GRP-5674MEDICARE-ADV-A
ENRENR-1365242026-08-01T21:47:18ZSEAN—PATEL06/09/1995uhc-21829-90•••-••-5589+1 813 798 9209SEAN.PATEL94@GMAIL.COM4719 Camelback RoadGlendaleAZ85365GRP-3443MEDICARE-ADV-A
ENRENR-137019 2026-07-08T21:33:58ZKally—Jensen12-03-1954UHC-89135-52•••-••-7086844-779-3181KELLY.JENSEN@GMAIL.COM3420 BASELINE RDNashvilleTN37213GRP-9906MEDICARE-ADV-B
ENRENR-1323612026-05-12T10:39:19ZRaymond—Valdez8/24/2006UHC-28229-93•••-••-1245738-649-4036raymond.valdez40@hotmail.com816 PALM DRIVEOrlandoFL32892GRP-7419NAVIGATE-HMO
ENRENR-1109532026-03-11T15:12:50ZJudithGHughesMay 9, 2000UHC-95465-23—2879309926judith.hughes@gmail.com3039 CENTRAL AVEOrlandoFL32828GRP-8299MEDICARE-ADV-A
ENRENR-1042672026-07-22T06:02:21ZFrancesF.Alvarez19631024UHC-86192-80•••-••-68487766880620FRANCES.ALVAREZ@PROTON.ME9208 Central AvenueMIAMI·FLUNKNOWNGRP-3707·MEDICARE-ADV-A
ENRENR-1078682026-02-13T20:05:28ZMARIA·T.BRYANTJul 28, 1999UHC-92112-28•••-••-28213627878938··989 INDIAN SCHOOL ROADSan DiegoCA92186-8727GRP-0265··NAVIGATE-HMO
ENRENR-1034812026-04-29T17:54:15ZRussellY.Berry1984-01-22UHC-79002-63•••-••-1752+1 988 883 7588—7812 LINCOLN WAYLAS VEGASNV89130-9339GRP-3044NAVIGATE-HMO
ENRENR-1136792026-08-06T04:25:46ZJACQUELINEZBLACK15-01-1972uhc-93592-56•••-••-4193UNKNOWNUNKNOWN1817 Washington StreetSCOTTSDALEAZ85239GRP-5726SELECT-EPO
ENRENR-1079622026-01-14T22:45:02ZBlack, Barbara··P.—1963-04-19UHC-91522-50•••-••-3578605.658.2920nullnullNULL··NULL—GRP-3370··SELECT-EPO
ENRENR-1126452026-08-25T12:09:33ZEvelynRHamiltonMay 27, 1996UHC-19691-51•••-••-5260929-205-1446evelyn.hamilton39@gmail.com5460 Cedar LaneDENVERColorado80268GRP-5438SELECT-EPO
ENRENR-1294242026-10-15T01:43:31ZLarryD.Riley1938-04-13UHC-29158-66•••-••-3185(311) 396-9988N/A4797 Mountain View DriveOrlandoFlorida32834GRP-0740OPTIONS-PPO
ENRENR-1081162026-07-15T19:28:36ZChristinaIMontgomery—UHC-84985-51•••-••-72819184360558christina.montgomery94@gmail.com·3375 CENTRAL AVENUEGilbert·AZ85256-4494GRP-9365·NAVIGATE-HMO
ENRENR-1340242026-02-01T08:24:45ZCamila····Herrera19460108··UHC-53583-98•••-••-6591(476) 541-1019N/A6176 Park PlGlendaleArizona85380GRP-1970·MEDICARE-ADV-B
ENRENR-1184572026-03-01T09:15:41Zpamela—oliver1958-03-01UHC-37383-08•••-••-9548750-835-7016NULL4154 Hillcrest Rd··AtlantaGA30340GRP-4231MEDICARE-ADV-B
ENRENR-1154612026-05-01T08:25:19ZSara—CarpenterSep 17, 1952UHC-10095-60•••-••-0694—-4081 Meadow LaneCOLUMBUSOH43276GRP-6541MEDICARE-ADV-B
ENRENR-1110382026-01-29T20:13:19ZRussellISantiago8/22/1986UHC-79710-30-394-203-3662UNKNOWN6241 Baseline RdOrlandoFL32830-1081GRP-2269select-epo··
ENRENR-1091802026-10-06T23:43:32Z helen—jacobs1969-05-28UHC-51998-52•••-••-08455237834036null3461 GRAND AVEAUSTINTX78792GRP-5202SELECT-EPO
ENRENR-1176882026-10-03T02:46:31ZMARIANAK.ROBERTS1990-11-16UHC-39339-40•••-••-5287+1 312 328 4698mariana.roberts@aol.com1684 Willow Court Apt 39CharlotteNC28201GRP-1741MEDICARE-ADV-A
ENRENR-1170552026-03-14T19:10:17ZJULIA—HOWARD1997-04-16UHC3875290•••-••-39442043204julia.howard@gmail.com2349 Union StAtlantaGA30325GRP-6679CORE-HMO
ENRENR-1075932026-02-22T13:10:15Z ·AnaWAlexander1998-03-14UHC-52420-37•••-••-63777815508348ana.alexander92@hotmail.com9045 SPRING STAustinTXUNKNOWN··GRP-0565NAVIGATE-HMO
ENRENR-1065482026-02-08T00:11:03ZSOFIARHUGHES1957-03-08N/A•••-••-5738231-257-2917sofia.hughes56@outlook.com6276 Bayshore Dr··ColumbusOH43264GRP-1679OPTIONS-PPO
ENRENR-1404812026-02-13T06:40:45ZBrian—Gutierrez19-02-1959··UHC-03540-64•••-••-44004342332282··N/A9615 Willow CtTUCSONAZ85795GRP-5064MEDICARE-ADV-A
ENRENR-1330922026-02-13T02:09:58ZEUGENEXSTONEMay 27, 1959UHC-96194-72•••-••-5280+1 701 439 9972EUGENE.STONE37@GMAIL.COM4202 Valley View DriveOrlandoFL32820GRP-7136··OPTIONS-PPO
ENRENR-1271172026-07-03T10:32:31ZDominguez, LoganE—1955-08-15··UHC-56133-86•••-••-6837+1 271 219 1081logan.dominguez74@outlook.com7287 PINE DRGILBERTArizona—GRP-3757··OPTIONS-PPO
ENRENR-1310342026-02-26T14:54:56Z dorothyB.bennett1975-01-24uhc-49307-33•••-••-9673·726-472-2063NULL6411 Hillcrest RdLos AngelesCA90064GRP-3216··CHOICE-PLUS-PPO
ENRENR-1063302026-09-20T01:58:15ZAlbert—Espinoza1962-06-23UHC-35488-03•••-••-8246—·albert.espinoza90@outlook.com2343 CENTRAL AVENUEPLANOTX··UNKNOWNGRP-1792select-epo
ENRENR-1378462026-01-13T14:21:16ZJeanISchmidt1939-01-14·UHC-37584-31•••-••-32654207295348jean.schmidt@outlook.com944 Sage Court Apt 33LAS VEGASNV89148GRP-8497MEDICARE-ADV-A
ENRENR-1194102026-07-19T22:17:28ZGray—Wood·4/6/1955UHC-61920-93•••-••-4953(441) 923-1344gary.wood@aol.com2564 Washington Street Apt 6COLUMBUSOH43299GRP-5812OPTIONS-PPO
ENR ENR-1252432026-03-11T23:41:54ZAngelaR··Glibert1953-10-11UHC-84008-87null(520) 749-6677angela.gilbert11@outlook.com9437 CENTRAL AVECharlotteNC28277GRP-0941NAVIGATE-HMO
ENRENR-1076872026-08-22T21:44:09ZJUDITH G.—THOMPSON01/17/61UHC-57935-70•••-••-74464412271JUDITH.THOMPSON@PROTON.ME·6875 Valley View DrLos AngelesCA90020GRP-9923MEDICARE-ADV-B
ENRENR-1396502026-04-19T11:38:52ZMasonOWilliams1970-02-26UHC-23935-97•••-••-4902—mason.williams@aol.com4626 Maple AvePhoenixAZ85024GRP-1281CHOICE-PLUS-PPO
ENRENR-1113192026-04-15T16:29:56ZAndrew—·Phillips1946-03-28UHC0880518•••-••-9893907-682-8708UNKNOWN4171 HARBOR BLVDColumbusOH43226GRP-2057MEDICARE-ADV-B
ENRENR-1298852026-08-15T11:45:39ZKathleen—Alvarado2006-09-04—•••-••-3837910.798.6533kathleen.alvarado61@aol.com··1905 SAGE COURTColumbusOH43226GRP-6387CHOICE-PLUS-PPO
ENRENR-1069282026-01-06T08:08:54Z·carlV.kennedy1947-07-22UHC-27655-75•••-••-0008·(664) 312-7574-7406 Ridge RoadColumbusoh43259GRP-9665MEDICARE-ADV-A
ENRENR-1023562026-03-07T22:27:36ZKALA—LEE05/21/1993N/A•••-••-3396(568) 581-5351kayla.lee12@yahoo.com5402 Lincoln WayCharlotteNC··28242GRP-6389OPTIONS-PPO
ENRENR-1045202026-04-11T01:37:15Zhiroshi··A·woodOct 20, 1960UHC-74279-34•••-••-3802(935) 430-1895HIROSHI.WOOD@AOL.COM8320 River RoadEDEN PRAIRIEMN55350GRP-5947OPTIONS-PPO
ENRENR-1211462026-08-10T23:16:36Z ANGELARANDERSON27-06-1967UHC-43281-15•••-••-1696(609) 596-2602—6290 PARK PLACEPhoenixAZ85065GRP-9068SELECT-EPO
ENRENR-1074952026-01-28T08:16:45ZOwens, Michael——1940-08-19UHC0742116•••-••-9970410-848-3787null3292 Valley View DriveAustinTX·78773GRP-5923MEDICARE-ADV-A
ENRENR-1358842026-06-19T07:57:39ZMATEO·BVARGAS1999-11-02UHC-45926-60•••-••-89537497572970mateo.vargas@gmail.com7783 SUNSET BOULEVARDJacksonvillefl32216GRP-6164CORE-HMO
ENR ENR-1181052026-07-25T20:26:40ZLuisN.Burns1975-06-26·UHC-19526-66•••-••-9534(773) 476-7092·luis.burns78@yahoo.com7449 CEDAR LNMesaAZ·85295GRP-1493OPTIONS-PPO
43,101 rows, page 286 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.444Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty