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

All sources, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
ENRENR-1221362026-09-15T20:29:22ZNohaEMorgan1976-03-20UHC-82203-05•••-••-4716(408) 309-2344NOAH.MORGAN29@HOTMAIL.COM5058 Palm DrNashvilleTN37274GRP-5781·CORE-HMO
ENRENR-1084692026-01-31T12:18:18Z JoanX.Bryant01/01/1976··UHC-90182-19•••-••-8070347-778-1633joan.bryant@icloud.com7618 MEADOW LANETucsonAZ85726GRP-6040OPTIONS-PPO
PRVPRV-291122026-01-14T20:37:38ZBrian—Montgomery1997-04-14UHC-99370-99N/A12522811562—1387 Hillcrest RdMIAMIFL33116-3888—NULL
PRVPRV-275082026-01-05T23:31:16ZEmily—Schultz1998-07-07··-19193993464··—2386 Apache BlvdSacramentoCA95829—NAVIGATE-HMO
CLMCLM-4126282026-07-21T18:24:49ZPatriciaZWheeler05/13/1939UHC-82575-80•••-••-3591NULL—3054 Oak StSAN DIEGOCA92195GRP-6649·null
CLMCLM-4287412026-05-22T09:55:21ZHenry····Roberts1978-07-12—•••-••-7925—-2952 MOUNTAIN VIEW DRIVESan DiegoCA92112——
CLMCLM-4133062026-02-23T06:27:59ZLisa—Hicks1984-01-14UHC-45936-13•••-••-8029——8771 Apache BoulevardSeattleWA98161··GRP-1397MEDICARE-ADV-B
TPATPA-604962026-01-18T15:13:47ZHEATHER—FULLER09/04/38-null-UNKNOWN5849 MESA DRMinneapolisMN55478GRP-1643UNKNOWN··
CLMCLM-4158512026-10-12T06:30:56ZSean—Olson1989-11-15UHC9246420null-—9155 BROADWAYDallasTX—GRP-5645CORE-HMO
CLMCLM-4021842026-07-06T02:55:04ZBilly—Cunningham24-08-1973UHC-53069-58UNKNOWN904-464-2670NULL7671 Jefferson AvenueMiami··FL33140—UNKNOWN
CLMCLM-4020002026-03-20T05:16:07ZAnnaU.—1956-08-26UHC4436931··•••-••-6801507.441.5820UNKNOWN8585 Desert Sky Boulevard··San Antoniotx78276GRP-1713-
TPATPA-581342026-03-17T06:44:12ZHunter—·Carolyn1944-06-06—N/A3716845-2682 Willow CtJacksonvilleFlorida32284——
ENRENR-1145492026-05-22T11:48:47ZJosshuaBWillias20080312UHC-99131-33—(550) 472-9057joshua.williams@hotmail.com8376 Union StDallasTexas75220GRP-6366NAVIGATE-HMO
ENRENR-1112662026-09-18T15:23:12ZRonaldB··Lawrence5/22/1981UHC-29293-43•••-••-4885NULL-3578 Central Avenue Apt 6ScottsdaleAZ··85283GRP-4484CORE-HMO
TPA TPA-519492026-05-18T02:52:22ZCynthia—Rojas1979-06-02—-UNKNOWN—5677 Mesa DriveCharlottenc28264NULLnull··
CLMCLM-4325542026-08-20T01:02:22ZSandra—Sccott··1974-11-01·UNKNOWN•••-••-9878—·NULL3389 HARBOR BLVD·Las VegasNevada·89158GRP-3178—
CLMCLM-4247872026-10-14T02:50:44ZCAMILA····COLEEMAN1960-01-21UHC3028702····(810) 571-0688N/A2961 Cedar LnTampa··FL33609——
ENRENR-1271772026-09-02T13:23:10ZTeresa····Simpson1942-02-26UHC-93574-65•••-••-770312669241937··teresa.simpson@aol.com5990 Highland AvenuePHOENIXAZ85050GRP-1387SELECT-EPO
CLMCLM-4111532026-06-09T12:56:42ZMegan—Burrke11-06-1940UHC-10284-69NULL+1 524 584 4456null5123 Camelback RdPhoenixAZ85099GRP-5754··UNKNOWN
ENRENR-110085 2026-09-29T08:23:49ZMeganZ.··Carr1962-08-16UHC-74416-41•••-••-85598856608089N/A2579 Meadow LnLos Angeles·ca90003·GRP-3562CHOICE-PLUS-PPO
CLMCLM-4252292026-06-16T14:11:58ZJoseEPalmer1955-11-10UHC-11588-68•••-••-1741null—61 Meadow LaneLos AngelesCA90084nullOPTIONS-PPO
CLMCLM-4043592026-08-27T09:46:17ZRachel··—Payne1597-01-22null•••-••-7521N/AUNKNOWNN/AUNKNOWN——nullMEDICARE-ADV-A
ENRENR-1087722026-05-05T15:02:23ZSARAHGJAMES20-12-1984UHC-76376-81•••-••-3903379-246-9344sarah.james@outlook.com··3221 Spring StreetATLANTA··GA30381GRP-4143NAVIGATE-HMO
PRVPRV-216112026-03-12T21:10:53ZNguyen, Maria——2003-04-02N/A—18202037758—4081 Willow CourtPhoenixAZ85030NULLOPTIONS-PPO
CLMCLM-4037912026-07-23T08:53:54ZWilliamOWard19840517UHC-96074-07•••-••-9851(743) 422-0103WILLIAM.WARD@ICLOUD.COM··5716 Mountain View DrHoustonTXNULLGRP-7332N/A
CLMCLM-4064542026-01-15T12:23:08ZGrace—Medina2001-09-27——691-986-3663-—N/A—null—null
ENRENR-1237112026-01-09T18:22:47ZMARIANAOHENDERSON1975-11-21UHC-66782-51•••-••-3439+1 245 787 2277—3178 Church StreetGilbertAZ85281··GRP-2021NAVIGATE-HMO
ENRENR-1162872026-05-12T14:13:38ZMariana—Wagner··1966-02-27UHC-61747-82•••-••-6948N/A··mariana.wagner@hotmail.com··2487 Oak StreetLos Angeles·CA90001GRP-7086CHOICE-PLUS-PPO
ENRENR-1357032026-09-30T10:14:57Z·CharlieJ.·WarrenNov 7, 1977··UHC-92700-93•••-••-2248+1 904 425 0565charles.warren57@hotmail.com2998 Meadow LnSan DiegoCA92154·GRP-3517CHOICE-PLUS-PPO
CLMCLM-4046552026-08-13T11:33:39ZALEXANDER—ALLEN1972-06-07UHC-21630-34UNKNOWNNULLalexander.allen@outlook.com6316 SPRING STTUCSONAZ85713GRP-2594MEDICARE-ADV-A
TPA TPA-610672026-02-20T02:47:17ZSARAH—JACOBS1957-10-18NULL————nullUNKNOWNUNKNOWNN/A··NAVIGATE-HMO
CLMCLM-4255222026-04-08T07:33:26Z·JEANL.KENNEDY·1943-08-20UHC4123429null19806639181NULL3458 Maple AvenuePhoenixAZ85033GRP-4644core-hmo
ENRENR-140327 2026-09-28T19:39:42ZAMANDA—RILEY1944-02-03UHC-25526-24•••-••-9292(984) 424-2836AMANDA.RILEY@OUTLOOK.COM3827 OCEAN AVEPLANOTX-GRP-1356··MEDICARE-ADV-B
PRVPRV-238022026-05-14T09:05:13ZSEAN—HUNTER7/21/1963UHC-31403-34··N/A921.687.4431sean.hunter@hotmail.com4045 Market StSacramentoCA95809—UNKNOWN
TPATPA-556002026-05-28T00:45:52ZZACHARY—GONZALEZ03/17/94—•••-••-35379378045143—6204 Hillcrest RoadLas VegasNVnullNULL···MEDICARE-ADV-B
ENRENR-1002792026-06-29T03:41:23ZFlores, AnnN—10/19/78UHC-43456-24•••-••-8550UNKNOWNann.flores@icloud.com5599 BroadwayNashvilleTN37234GRP-5764·MEDICARE-ADV-B
CLMCLM-419515 2026-08-31T04:50:40ZCAMILA—·JENSEN11/25/1949UHC-66295-51--N/A-—null-GRP-2498CORE-HMO
TPATPA-596222026-08-04T10:53:43ZTyler··—Morris1966-01-12—N/A2513403tyler.morris@aol.com133 Washington StreetAtlantaGA30300——
TPATPA-561162026-05-30T23:33:21Zjonathan—evans·1938-10-24——8563434896—null-N/A—GRP-0696CHOICE-PLUS-PPO
TPATPA-522982026-08-12T11:38:22ZKeith····Hernandez1998-11-21——4353518061··UNKNOWN1394 Apache Boulevard #931ScottsdaleAZ85239GRP-1319—
PRVPRV-277772026-05-16T07:30:49ZJudy—Delgado2005-03-05·UHC-10925-71-UNKNOWN—9895 Jefferson AveLos AngelesCA90053N/ANULL
PRVPRV-244972026-05-15T17:54:48ZJudy··—Ortega·19971123—UNKNOWN234-228-3457—2089 CAMELBACK RD #529San Diego·CA92136null—
ENRENR-1386912026-09-14T12:09:42Zpat—wilson1962-09-25UHC-11066-40•••-••-0096-patricia.wilson@aol.com7558 Mesa DrColumbusOH43220-4688GRP-6763NAVIGATE-HMO
CLMCLM-4113202026-10-11T23:07:07Z·Betty—Rojas12/27/76UHC-59588-79····N/Abetty.rojas@yahoo.comN/AUNKNOWNUNKNOWNNULLGRP-2268UNKNOWN
PRVPRV-294332026-07-15T01:25:52Z Jesse··—HillOct 7, 1960UHC-84855-30—942-606-4653UNKNOWN9848 Indian School RoadJacksonville··FL··32219UNKNOWN-
ENRENR-1349952026-02-24T07:31:51ZISABELLAQFULLER06/26/2002·UHC-89963-39•••-••-2015—isabella.fuller@aol.com6088 PINE DRNashville·TN37284GRP-9655CHOICE-PLUS-PPO
CLMCLM-4239422026-03-27T02:35:11ZHANNAH—WARD1997-01-01UHC-07354-59—+1 485 594 7776NULL4451 MESA DRFresnoCA93701GRP-6689—
ENRENR-1132412026-02-26T13:48:48Z Murphy, KarenE.—1960-01-28UHC-64792-24··•••-••-5560·375-469-5202KAREN.MURPHY@AOL.COM8224 Willow CourtSeattleWA98116·GRP-9652SELECT-EPO
CLMCLM-4218022026-01-22T08:03:28ZNatalie—·Mason1992-08-24UHC-07376-13-NULLN/A3166 Market StLas VegasNV89179NULLCHOICE-PLUS-PPO
ENRENR-1266432026-10-05T03:34:00ZHanson, Dorothy——1997-02-23UHC-77636-60NULL(568) 947-5987—·4663 Harbor BoulevardSacramentoCA95814·GRP-3205MEDICARE-ADV-B
100,000 rows, page 133 of 2,000PreviousNext

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:36.691Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty