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-1108262026-09-14T15:57:30ZBilly—Olson9174-06-21UHC8727266•••-••-2053—billy.olson@yahoo.com8096 River RoadMesaAZ85259GRP-6840SELECT-EPO
ENRENR-1113762026-04-22T15:00:31Z·Helen—Padilla-UHC-77953-98•••-••-75904198398627·NULL5997 BAYSHORE DRTempeAZ85285GRP-8947MEDICARE-ADV-A
ENRENR-1429222026-05-27T11:03:59ZrogerI.garza19610312UHC-70965-65•••-••-3749794-719-7749ROGER.GARZA@HOTMAIL.COM8262 MARKET STPhoenixAZ—GRP-5989CORE-HMO
ENRENR-1369342026-02-15T17:16:53ZSaraCMoreno1942-09-22UHC-58120-86•••-••-937713826822296—4844 Cedar LnMinneapolisMN55489GRP-1317CHOICE-PLUS-PPO
ENRENR-1176192026-09-18T08:14:05ZMarshall, Linda··——1998-10-09UHC-40406-99•••-••-0340548-306-7867linda.marshall@icloud.com··4299 Jefferson AvenueSacramentoCA··95868·GRP-8566MEDICARE-ADV-B
ENRENR-1232112026-09-24T08:50:47ZRNOALD—BOWMAN1944-07-20UHC-10475-40•••-••-5880+1 867 613 4681·UNKNOWN9323 Willow CtTampaFL33628GRP-4691MEDICARE-ADV-B
ENRENR-1082642026-04-30T10:19:35ZRONALD····OLSON2002-07-09·UHC-08070-86•••-••-35798556989012RONALD.OLSON@ICLOUD.COM1492 Union StreetMiamiFL33142GRP-4826OPTIONS-PPO
ENRENR-105651 2026-01-28T04:09:26ZSUSANBSANCHEZ1984-01-12UHC-49183-97•••-••-5261755-711-6008··NULL8249 Desert Sky BlvdTampaFL33657·GRP-1474NAVIGATE-HMO
ENRENR-1126592026-09-13T02:05:00ZBRYANUROJAS1953-05-19UHC-03515-12•••-••-056415964123625NULL1089 Washington StEden PrairieMN55332GRP-9062SELECT-EPO
ENRENR-1104492026-05-22T19:30:04ZJOYCE—SANDERS07/12/54UHC-76833-52•••-••-847219186999314joyce.sanders@aol.com1135 Harbor Boulevard Apt 16SAN ANTONIOTX78272GRP-6504MEDICARE-ADV-A
ENRENR-136155 2026-07-10T16:32:46ZVasquez, JanetS—15-06-1993UHC-66371-33•••-••-1263695-466-4670—154 Desert Sky BlvdDallasTX75202GRP-3562MEDICARE-ADV-B
ENRENR-1065502026-08-08T05:16:36Z·Julia—Silva1961-06-28UHC-78965-73•••-••-54344274742207JULIA.SILVA26@YAHOO.COM5029 PALM DRTempeAZ85262GRP-1856SELECT-EPO
ENRENR-135117 2026-06-19T00:43:42Z·KATHERINE—BRANT11/11/1946UHC-82369-83•••-••-9150(955) 759-3856—7987 Apache Boulevard Apt 18PHOENIXAZ85032GRP-2077OPTIONS-PPO
ENRENR-1031922026-03-25T06:19:15ZDeborahDLopezAug 23, 1956UHC-90944-87UNKNOWN3793733950··DEBORAH.LOPEZ79@HOTMAIL.COM8762 RIDGE ROADAustinTX··78791-4185GRP-7598··MEDICARE-ADV-B
ENRENR-1267752026-01-09T13:01:40Z Mateo—Thomas1952-06-21UHC-30713-28•••-••-1537633-803-9110mateo.thomas42@yahoo.com5508 Mountain View DrAustinTX78763-6699·GRP-5742CHOICE-PLUS-PPO
ENRENR-1104802026-04-16T04:49:43ZDONRCASTRO1984-06-20UHC6076221•••-••-476815994772484DONALD.CASTRO60@ICLOUD.COM1823 Mountain View DriveTAMPAFL33607GRP-3747MEDICARE-ADV-A
ENRENR-1016282026-01-17T02:56:01Z·Kimberly—Harris·04/24/59·UHC-10041-73·null18328681033-4215 Cedar LaneColumbusOH··43229-6945GRP-4808MEDICARE-ADV-B
ENR ENR-1135932026-03-14T07:46:49Z·CHERYLKBARNES—UHC-40226-91··UNKNOWN3153243991cheryl.barnes@outlook.com6700 MEADOW LANEColumbusOH43238GRP-6897CHOICE-PLUS-PPO
ENRENR-1373682026-04-07T21:51:39ZANGELAY.HAMILTON·1978-09-10UHC-43739-87•••-••-3926(554) 828-9045angela.hamilton@aol.com9542 Bayshore DriveLas VegasNV89162GRP-7429MEDICARE-ADV-A
ENR ENR-1072892026-09-19T10:21:02ZMorrison, Bradley——19821111UHC-89051-37·N/AUNKNOWN··bradley.morrison26@aol.com461 Central AveTucsonAZ85713GRP-3911CORE-HMO
ENRENR-1343342026-04-16T15:33:02ZRoy—ChnAug 24, 1966UHC6422958•••-••-2689(748) 357-1501-6546 Mountain View DrCharlotteNC28219·GRP-3100CHOICE-PLUS-PPO
ENRENR-1055512026-02-11T13:59:45ZMendoza, LoganQ.··07/19/1997UHC8315966•••-••-4330+1 326 456 3054logan.mendoza@hotmail.com5812 JEFFERSON AVETucsonArizona85728GRP-8988CHOICE-PLUS-PPO
ENRENR-1198402026-05-22T02:57:52ZAlexis—·Gilbert1994-07-08·UHC-87690-46•••-••-8054988-814-6547alexis.gilbert29@proton.me9737 Pine DriveFresnoCA93779GRP-1449MEDICARE-ADV-B
ENRENR-1132292026-01-07T22:02:31ZBettyA.·Ellis26-10-1999UHC-91418-45•••-••-6204+1 647 514 7104betty.ellis39@hotmail.com·8398 Market StMinneapolisMN55437··GRP-1383NAVIGATE-HMO
ENRENR-1025942026-02-22T13:19:54Z SANTIAGOXRUIZ—UHC-24348-69··UNKNOWN5946875549santiago.ruiz32@aol.com7526 UNION STREETMiamiflNULLGRP-3025CHOICE-PLUS-PPO
ENRENR-1321242026-06-29T15:13:48ZAisha—Dixon1970-05-02UHC-18503-41•••-••-9857852-815-7086AISHA.DIXON77@ICLOUD.COM81 Park PlTucsonAZ85764GRP-7077NAVIGATE-HMO
ENRENR-1226142026-09-14T11:29:43ZCAROLYNL.COLEMAN1991-03-16UHC-90056-35•••-••-7901(241) 709-8567CAROLYN.COLEMAN@YAHOO.COM8911 Oak StreetChandlerAZ85203GRP-2935OPTIONS-PPO
ENRENR-1204522026-06-02T23:48:33Z ·KEITHT·ANDREWS19971008UHC-08891-75•••-••-3348(556) 333-7891keith.andrews@yahoo.com4640 Main StreetTampaFL33618GRP-3453··CHOICE-PLUS-PPO
ENRENR-1219332026-04-21T22:09:05ZSARA··—RAMIREZ07/10/1991UHC-30553-71•••-••-6346(520) 879-8861·sara.ramirez31@hotmail.com3107 LAKE VIEW ROADGilbertaz85270GRP-1099CORE-HMO
ENRENR-1394642026-06-20T17:16:18ZlindaXgray05/06/91uhc-75175-37•••-••-853514478007522UNKNOWN5491 BroadwaySeattleWA98154GRP-6250CORE-HMO
ENRENR-1240092026-10-08T13:07:06ZJULIA—BENNETT2001-05-11UHC-58409-64•••-••-0559226-424-4663julia.bennett@icloud.com9853 Union StreetTempeAZ85241GRP-8149MEDICARE-ADV-B
ENRENR-1139052026-03-30T13:10:35ZAliceBPierce1941-03-26UHC2476022•••-••-2294+1 380 403 0869alice.pierce@outlook.comUNKNOWN—-NULLGRP-9386CORE-HMO
ENRENR-1412202026-02-11T01:45:57ZJOSHUA—CRAWFORD1966-05-13·UHC-85570-06•••-••-6109865-501-4135joshua.crawford54@proton.me7519 Elm StreetDenverCO—GRP-2079NAVIGATE-HMO
ENR ENR-1152602026-08-10T12:07:31ZDoris—McCoy26-08-1984UHC-58446-73•••-••-2966664-476-0105-7393 River RdGilbertAZ85242GRP-2739NAVIGATE-HMO
ENRENR-1257972026-10-09T12:52:48ZMarianaJArnold1973-01-18UHC-82201-41•••-••-9042(620) 860-9139UNKNOWN7880 Ocean AveTEMPEArizona85216-4757GRP-3586MEDICARE-ADV-A
ENRENR-1336822026-09-26T22:43:40ZRay, Tommy——1942-08-12·UHC-25610-12•••-••-8562437-846-1048—979 BroadwayTucsonAZ85731GRP-9995MEDICARE-ADV-B
ENRENR-1042192026-03-08T15:55:14ZSusn—Schultz1939-11-17··UHC5164266•••-••-22549623369527SUSAN.SCHULTZ1@GMAIL.COM·4292 Highland Ave·SEATTLEWA····GRP-1458MEDICARE-ADV-B
ENR ENR-1218062026-01-24T11:22:06ZJohn—Larson··08/14/79UHC-27245-80•••-••-5781+1 986 974 0126john.larson@icloud.com6872 Palm DrPhoenix··AZ85067GRP-8776CHOICE-PLUS-PPO
ENRENR-1378672026-06-28T12:06:47Z·Donna····Russell9/22/1981UHC-64385-22•••-••-6357(309) 867-3471—8815 Sunset BoulevardSeattleWA·98122GRP-4961·NAVIGATE-HMO
ENRENR-1410292026-10-12T13:52:58ZTheresaASingh1948-04-09UHC-14998-79•••-••-23254599033090theresa.singh76@outlook.com8027 Union StAustinTXUNKNOWNGRP-9550CHOICE-PLUS-PPO
ENRENR-1365762026-10-03T12:33:49ZyukiSstephens1941-11-27UHC-35271-91-(687) 557-2311yuki.stephens@aol.com1860 Cedar LnGilbertAZ··85237GRP-5012MEDICARE-ADV-A
ENRENR-1229572026-02-21T05:19:55ZBaker, MariaH—1972-02-28UHC-25029-78•••-••-7055+1 650 903 8382··5242 HILLCREST ROADNashvilleTNN/AGRP-3196MEDICARE-ADV-B
ENRENR-1088222026-03-10T20:23:59ZWAAYNECTURNER··Sep 1, 1948··UHC-74124-29•••-••-5093NULLwayne.turner13@gmail.com4921 Canyon Rd·LAS VEGASNV89169GRP-6119OPTIONS-PPO
ENRENR-1072172026-07-16T20:59:55ZSHIRLEYPESTRADA1982-10-07·UHC3022274•••-••-890812714414326N/A1380 MOUNTAIN VIEW DRTempeAZ·85202GRP-2403MEDICARE-ADV-B
ENRENR-127045 2026-05-03T03:02:56Zmary E.—prike18-09-1946·UHC-79267-93•••-••-29585314924067N/A4950 Union Street··SAN ANTONIOTX·78285GRP-1045MEDICARE-ADV-A
ENRENR-1124802026-01-02T17:37:25ZChristopher—Coleman10-08-1965UHC-83613-24•••-••-7487458-853-6985christopher.coleman71@icloud.com783 MOUNTAIN VIEW DRAustinTX78738GRP-3637CORE-HMO
ENRENR-1077122026-02-05T14:19:51Z·AlexisQYang19971220UHC-98520-52•••-••-8091—alexis.yang@aol.com6129 Sunset BlvdSan AntonioTX78200GRP-2729MEDICARE-ADV-B
ENRENR-1385162026-02-04T07:43:19Z Beverly··—Ortega16-07-1950UHC-09931-26•••-••-5507575.975.7794N/A830 BAYSHORE DR·DALLASTexas75209GRP-2139CHOICE-PLUS-PPO
ENR ENR-1418432026-01-07T23:12:08ZDorothy····Fulelr20-03-1970UHC-32368-14··•••-••-0693N/A—5100 GRAND AVENUECharlotteNC28272GRP-1708·OPTIONS-PPO
ENRENR-1394272026-03-19T05:42:37ZKyleG.Meyer1976-10-28UHC-64032-36•••-••-56967879715728—5213 Lake View RdTAMPA··FL33615GRP-5548CORE-HMO··
43,101 rows, page 94 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:37.728Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty