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
PRVPRV-228712026-04-26T02:11:44ZBradley, Olivia——1969-04-23—UNKNOWN·7374687565·null3185 Apache Boulevard·Las VegasNV89116··—null··
ENR ENR-1285782026-07-09T07:39:00ZSantiago, CarolynM··—03/10/2007UHC-51828-36N/A···282-626-2585N/A4033 Hillcrest Road··PhoenixArizona85083·GRP-6887medicare-adv-a··
TPATPA-534532026-09-30T10:03:12ZJacquelineI.·Williamson1953-06-01N/A•••-••-4076(399) 691-8034null1442 CANYON RD··Las Vegas··NV89162GRP-3866—
CLMCLM-4116562026-09-28T13:32:00ZANN—WILLIAMSON19630410UHC-19399-24null+1 535 352 3822-402 Elm StMIAMIfl33107-··
TPATPA-591762026-08-26T15:21:47ZDORIS—BRADLEY·19460801NULL--UNKNOWN·158 CEDAR LNOrlandoFLUNKNOWN—null
ENRENR-1020312026-04-16T04:12:07ZSTEPHNIE—TUCKER12/12/1986UHC8576340•••-••-5222803.705.8241stephanie.tucker@outlook.com5732 MEADOW LNChandleraz85288GRP-4543NAVIGATE-HMO
CLMCLM-4045462026-02-24T03:09:11ZKATHERINE—WANG1986-01-14NULL——NULLUNKNOWNN/A—UNKNOWNN/AMEDICARE-ADV-A
PRVPRV-202632026-09-23T13:14:52ZDiana—Ross1985-04-21UHC-68670-46—(466) 467-7953UNKNOWN5464 OAK STREETTempeAZ··85277NULL-
ENRENR-1270132026-09-23T18:39:31ZRyanV.Black08/16/2007UHC-62223-85•••-••-6462436-220-8983ryan.black5@hotmail.com3868 Lincoln WayAtlantaGA30353GRP-3048SELECT-EPO
CLMCLM-4032322026-07-12T14:00:27Z RAYMOND—SALAZAR1996-10-11NULL-—N/A9310 Bayshore DriveJacksonville··FL32238GRP-6978—
PRVPRV-217442026-09-10T21:19:01ZEthan—Li1947-07-13UHC-48504-34-323-205-0702ethan.li@gmail.com2446 MOUNTAIN VIEW DRIVEPhoenixAZ85064NULLnull
TPATPA-511372026-05-07T13:22:02ZNathan—McCoyDec 6, 1970UNKNOWNUNKNOWN+1 826 345 5424N/A·77 SUNSET BLVDTampa·fl33686GRP-1872-
ENRENR-113798 2026-09-21T21:29:57Z·Mariana—Porter1999-10-22UHC-32514-31•••-••-3746(231) 559-8610MARIANA.PORTER52@GMAIL.COM8211 Grand AvenueCHANDLERAZ85261-3036GRP-0862CHOICE-PLUS-PPO
CLMCLM-4186402026-09-27T11:33:19ZNatalie—Hoffman1973-05-14—---NULLnullNULLNULLUNKNOWNCHOICE-PLUS-PPO
ENRENR-1282802026-07-24T23:53:19ZWebb, Diana——1967-05-27UHC-08113-64•••-••-88957994065836—5776 Oak Street Apt 25ScottsdaleAZ85244·GRP-4269OPTIONS-PPO
CLMCLM-4094142026-08-26T12:43:56ZBobby—·Harper1991-12-14-—12702784382N/A516 PARK PLACEFRESNOCA93701GRP-8385—
ENRENR-1339002026-08-17T17:55:09ZRichardZHeernandez4/25/1978UHC-02619-10•••-••-9749(229) 494-6300richard.hernandez72@proton.me4938 Palm DriveGlendaleAZ85332GRP-8381MEDICARE-ADV-B
ENRENR-1046962026-02-22T11:36:47ZMelissa—Park4/21/1982UHC-93563-20•••-••-2244·UNKNOWNmelissa.park@proton.me2042 Camelback Road #829Eden Prairie·MN55373GRP-6046MEDICARE-ADV-B
CLMCLM-4226132026-03-31T14:07:29ZCARLOS—WILLIAMSON1977-07-01-•••-••-1943--5335 HIGHLAND AVETempeAZ85242GRP-9366MEDICARE-ADV-B
TPA TPA-580182026-03-20T22:08:20ZSANTIAGO—WARREN10/01/76——-SANTIAGO.WARREN@PROTON.ME542 Harbor Boulevard Apt 5MesaAZ85248—CHOICE-PLUS-PPO
PRVPRV-242792026-06-05T15:51:36ZSantiagoMWoodsJul 20, 1999—•••-••-1829657-893-5566null8090 Lake View Rd #730CHANDLERAZ85278NULL··choice-plus-ppo
TPATPA-621782026-08-29T14:45:13ZFatima····Warren1943-01-18-····——9247 OAK STREETMinneapolisMN55453-N/A
CLMCLM-419859 2026-04-04T13:27:05ZJULIE—MALDONADOFeb 9, 2003—•••-••-6649——2499 CEDAR LANETAMPAFL33655GRP-4452NULL
ENRENR-134358 2026-08-30T11:39:13ZArmstrong, JoshuaL—·Dec 4, 1990UHC-90508-70•••-••-9903270-889-6520joshua.armstrong@aol.com1069 Central AvenueSacramentoCA95845GRP-3572CHOICE-PLUS-PPO
CLMCLM-4004152026-06-28T01:29:02Zterry—martinez08-10-1970UHC-27731-53··672.386.1608UNKNOWNUNKNOWNNULLNULL—-null
CLMCLM-4042502026-09-28T23:36:55ZJoan—Robertson11/28/1957UHC-80182-89··•••-••-0109nullnull-N/Anull—GRP-0649MEDICARE-ADV-B
TPATPA-53838 2026-06-02T08:56:05ZNATHAN—ROSEMay 5, 1964UNKNOWNUNKNOWN—null·439 Baseline RoadDenverCO··80269nullN/A
CLMCLM-4137572026-01-29T19:33:23Zgeorge····reynolds10/21/1989UNKNOWN··null+1 512 894 9093—7003 VALLEY VIEW DRIVEGlendaleAZ85329—OPTIONS-PPO
CLMCLM-4189552026-06-16T13:13:33ZSara····FordDec 4, 2005UHC-92388-04-(754) 225-6746UNKNOWN2123 Indian School RoadCHARLOTTENC28221—SELECT-EPO
PRVPRV-253192026-07-23T01:13:00ZMARY—COX1974-07-26N/ANULL··-N/A8749 Indian School RdSeattleWA98151null—
ENRENR-1136762026-03-06T15:09:59ZJuan—FernandezNov 25, 1979UHC-75875-17—8404525074JUAN.FERNANDEZ67@GMAIL.COM931 Highland Ave·JacksonvilleFL32294GRP-8346SELECT-EPO
TPA TPA-556892026-04-03T21:12:38ZPamelaHCollins9/3/1942UNKNOWN•••-••-1544—pamela.collins@yahoo.com1992 MEADOW LNMESAAZ85242N/A····
PRVPRV-228192026-06-12T05:11:09ZDONALDEFOX1994-09-09UHC-76516-01•••-••-8427UNKNOWN··null3402 PINE DRIVETampaFL33694—-
CLMCLM-4189602026-08-21T13:57:02ZYuki—Boyd1947-07-04UHC-23434-82•••-••-1816——4553 OAK STREETEden PrairieMN55367GRP-5005MEDICARE-ADV-B
CLMCLM-4224112026-04-28T09:57:53Z·Carter, Joseph——1979-21-15UHC-97279-29··null253-738-3919N/A3938 Desert Sky BoulevardChandlerAZ85231··N/AOPTIONS-PPO
CLMCLM-4257942026-03-02T19:24:30Z·ALAN—MEJIA1962-09-22UHC-23357-93•••-••-7363——8642 Union StGilbertAZ85207—OPTIONS-PPO
TPATPA-554122026-05-20T03:42:26ZChristopher—Rivera1982-06-16—•••-••-4981—-null-null—-NULL
CLMCLM-4076532026-01-04T12:16:23ZEmma—Graham1978-09-13UHC-94336-44nullN/A—6542 CENTRAL AVEGlendaleAZ85306GRP-6956NULL··
ENR ENR-1152882026-05-03T10:45:53ZCHRISTOPHER—SIMMONS1952-06-04UHC-48447-34•••-••-3302558-771-7829christopher.simmons83@hotmail.com2106 Pine DrMesaAZ85262GRP-1235MEDICARE-ADV-B
ENRENR-1109182026-03-10T10:33:33ZsusanDtran19730927UHC-98859-82•••-••-43454749544586SUSAN.TRAN@PROTON.ME5965 Church StreetGILBERTAZ85272GRP-2008CHOICE-PLUS-PPO
PRVPRV-217512026-06-11T18:55:02ZTYLER—MASOON1971-03-26UHC-20831-74NULL+1 557 697 4499·null1085 MEADOW LNAtlantaGA30305UNKNOWN—
ENRENR-1058552026-02-13T23:59:46ZJONATHAN—TURNER1939-06-23··UHC8970854•••-••-75888412467920JONATHAN.TURNER@AOL.COM7967 Lake View RdChandlerAZ85230GRP-1570··options-ppo
CLMCLM-4102712026-06-03T07:05:24ZRebecca—Elliott1951-07-04UHC-15131-53•••-••-30284794127303—1001 Lincoln Way Apt 37ColumbusOH43213GRP-9596—
ENRENR-1068442026-04-24T02:24:27ZThomas····Boyd19804928UHC-64494-34•••-••-7171(478) 926-5496·thomas.boyd14@hotmail.com7546 Sunset BlvdSacramentoCA95883GRP-4685MEDICARE-ADV-B
ENRENR-1210532026-05-11T17:38:07ZJasonW.Vasquez7/6/2007UHC-22579-46··•••-••-50298824809667jason.vasquez78@proton.me4450 SAGE COURT #631LOS ANGELESCA90040-9194GRP-3995OPTIONS-PPO
PRVPRV-291442026-04-21T01:41:58ZTeresa—Munoz··May 17, 1949nullUNKNOWNNULLNULL———NULL—UNKNOWN
PRVPRV-295292026-01-15T20:27:14ZFox, LauraU—1942-12-04N/AN/A254-253-3119NULL3669 Spring StMinneapolisMN55474—CORE-HMO
ENRENR-1279732026-05-12T01:53:04ZHeather····Guzman05-02-1982UHC-72023-79··•••-••-6248538-262-4135UNKNOWN2294 MESA DRMesa··AZ85212GRP-2687MEDICARE-ADV-A
ENRENR-1037102026-03-31T21:55:53ZCatherineZCook06/20/90—·-6793246419catherine.cook44@proton.me3042 Cedar LaneLos AngelesCA90094-4610GRP-6333CHOICE-PLUS-PPO
CLMCLM-4069872026-08-02T08:12:46ZMark····Hunt1984-06-14·UHC-95867-45-17804560399—N/ANULLNULL—·N/A—
100,000 rows, page 246 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:37.748Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty