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

Third-party administrator only, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
TPATPA-623772026-01-31T19:42:12ZJames, Drew——1939-01-24-——andrew.james@outlook.com7426 Forest AveJacksonvillefl32221-2812·GRP-4376CORE-HMO
TPATPA-514212026-01-03T08:31:24ZMEI—VAZQUEZ1999-12-10NULL•••-••-7442·7283897926MEI.VAZQUEZ95@AOL.COM—N/AUNKNOWNNULL——
TPATPA-53917 2026-05-12T15:43:07Z·Ortiz, Amanda——11/28/71··NULL•••-••-2784null—9163 DESERT SKY BOULEVARD·ATLANTAGA30361GRP-0597N/A
TPATPA-554862026-01-07T12:09:15ZGLORIA—MEYER1998-04-17-N/AN/AN/A1137 Pine DrHouston·TXnull——
TPATPA-564562026-01-22T00:52:25ZWILLIAM—POWELL··13-01-1973——4554792134N/A1719 Ridge RdEden PrairieMN55337——
TPATPA-582412026-08-01T15:21:42ZCarol—SinghFeb 14, 1997UHC-31898-22-·NULL—5749 Canyon RoadLas VegasNV·89107UNKNOWNSELECT-EPO
TPATPA-534222026-01-02T06:32:09ZSteven—Jones01/21/87UNKNOWN——-8824 MAIN STTEMPEAZ85261GRP-6723—
TPATPA-587302026-01-24T07:15:32ZRONALD—FOWLER20010405UNKNOWN·N/A(860) 802-6760—1894 Elm StreetGlendaleAZ85370-8696GRP-8572SELECT-EPO
TPATPA-570852026-02-27T14:55:04Zkimberly—powell1978-12-05NULL—nullnull··2043 SPRING STREETGilbertAZ85205GRP-1529-
TPATPA-556232026-04-06T11:01:23ZJohnnson, Wei——1982-08-04——794-503-4955wei.johnson@outlook.com8648 Spring StreetMiamiFL33183—NULL
TPATPA-528532026-07-19T07:24:30Zralph—nguyen5/12/1958null—-null2076 LAKE VIEW RDSCOTTSDALEAZ85216-3123GRP-5162—
TPATPA-627142026-05-21T07:53:53ZCheryl—·Garza2004-07-18—null3125114372NULL··207 Union StreetTEMPEAZ85203GRP-0464··
TPATPA-601882026-06-26T04:52:15ZFrances—Wong··1997-11-20UHC-71214-60-—FRANCES.WONG@GMAIL.COM6245 BroadwayDenverCO80235null·N/A
TPATPA-584902026-10-16T13:29:46ZKenneth····Bailey2002-01-05——553-616-7156KENNETH.BAILEY@ICLOUD.COM203 CAMELBACK ROAD··PlanoTX75011GRP-8337··
TPATPA-632042026-09-14T05:55:57ZSusan—Perry1946-01-03N/A•••-••-88063296789979NULL8796 Camelback Rd··Eden PrairieMN55309nullnull
TPATPA-576602026-05-15T11:51:34ZSofia—Garcia1962-08-12UNKNOWN—+1 473 998 2609null9463 MEADOW LANE #100JacksonvilleFL32216··OPTIONS-PPO
TPATPA-529232026-04-30T19:32:29Z walter··—patel2005-07-01··UHC-76743-89—(444) 280-0558N/ANULLnull··—NULL—
TPATPA-562252026-04-13T03:08:24Zestrada—walter·03/23/1990-—nullNULL—N/ANULL·nullN/A—
TPATPA-511642026-10-09T16:41:20ZDeborah—Hart1951-04-03UNKNOWNUNKNOWN3194357066NULL4956 Spring StAustinTX78752—SELECT-EPO
TPA TPA-630652026-01-25T10:10:38ZJakeC·Coleman1952-08-26-—2623414306—-NULLN/A——CHOICE-PLUS-PPO··
TPATPA-610002026-07-06T08:34:28ZAdam—Rojas1992-07-15··—UNKNOWNNULLN/A9838 Spring StreetTempeAZ85297——
TPATPA-612252026-10-14T15:38:07ZDenise, Wilson——1987-11-14———NULL420 HILLCREST RD·San DiegoCA92171—UNKNOWN
TPATPA-642042026-05-24T09:52:45ZGreene, Amber——27-06-1990NULL•••-••-3513(266) 740-3546—9432 PARK PLACESan AntonioTX··78204—-
TPATPA-534132026-01-16T12:28:16ZRebecca—Cstillo2003-08-20UHC-65227-54·NULL3907292473rebecca.castillo@aol.com9475 Harbor BoulevardMiamiFL33140GRP-7027CHOICE-PLUS-PPO··
TPATPA-595522026-04-22T13:20:05ZAlan—Bradley1971-09-10--·14495170482-5458 Oak StTampafl33633GRP-2898null
TPATPA-529472026-02-12T01:11:20ZSchultz, Douglas—··05-10-1954N/A—NULLdouglas.schultz@proton.meN/A-UNKNOWN—null··—
TPATPA-600272026-09-07T23:46:31ZEthan··Fernandez2000-08-05N/A•••-••-30339734901084N/A··3381 Church StSan DiegoCA92166-··—
TPA TPA-582962026-03-06T13:38:30ZBRITTANY—LUCAS4/16/1951N/AnullN/ANULL495 Washington StreetSan AntonioTX78269GRP-5336-
TPATPA-506802026-09-03T06:43:19ZPriya····Kelly1959-05-22··NULL•••-••-7748nullNULL6859 Grand AveTucsonAZ85723··UNKNOWNNAVIGATE-HMO
TPATPA-608552026-06-02T03:00:43ZJerry—Thomas1975-09-28nullNULL(485) 425-0951N/ANULL———GRP-6534NULL
TPATPA-587072026-03-13T15:15:01ZAMANDA—THOMPSON02-01-1959-•••-••-2239—UNKNOWN929 Maple Ave·AustinTX78775-—
TPATPA-639632026-01-03T01:04:01Z Flores, Carolyn——1964-05-16———N/A2384 Apache BoulevardLos Angeles·CA90037-null
TPATPA-584112026-01-06T11:03:40Zwei—greene1945-01-21UHC2358088NULLN/AUNKNOWN63 Lincoln WayJACKSONVILLEFL··32221··—N/A
TPATPA-545672026-05-07T19:45:30ZPatterson—Bryan19710418—•••-••-5121230-915-7123UNKNOWN6888 Elm StDenverCO80225····MEDICARE-ADV-B
TPATPA-613232026-08-13T06:16:27ZJENNIFER—CASTRO1950-04-02nullN/A——1633 Sage Court Apt 35JacksonvilleFL32287NULL··CHOICE-PLUS-PPO
TPATPA-616232026-01-22T20:56:50ZMARK—DEAN2/14/2008UHC-46621-13null—mark.dean89@outlook.com—-UNKNOWNNULLGRP-8136—
TPATPA-622302026-06-23T09:38:25ZBenjamin—Mejia1944-06-10-——null2779 Cedar LanePlanoTX—GRP-1179MEDICARE-ADV-A
TPATPA-511862026-03-24T19:51:15Z·NicoleYPark1990-09-14nullN/A768-242-9092UNKNOWN———nullN/A-··
TPATPA-626572026-03-27T17:27:54ZJeffrey—Sandoval1978-12-01NULLUNKNOWN—null1622 LINCOLN WAYColumbus···OH·43226UNKNOWNN/A
TPATPA-595882026-09-02T00:24:35ZashleyL.watkins··1991-02-15-··•••-••-9222(851) 734-5412—35 Central AveSan DiegoCA92165——
TPATPA-598332026-02-04T06:52:05ZGrace—Ryan19730628UNKNOWN•••-••-6151——9392 Highland Avenue·MesaAZ85210—UNKNOWN
TPATPA-599152026-08-17T14:52:28Zjeremy—fernandez1952-09-27··UHC1876876null·8967108812JEREMY.FERNANDEZ25@AOL.COM1634 Market StreetDallasTX75277-8883··GRP-6692UNKNOWN
TPATPA-51210 2026-02-14T22:57:06ZBRUCE—HARPER2006-11-25—null15976391936bruce.harper@hotmail.com2021 River RdFresnoCA93771—-
TPATPA-506272026-06-16T02:02:56Zemily—·rojas1979-04-03··-(599) 305-2438N/A9357 Lake View RoadTampaFL33663—UNKNOWN
TPATPA-540752026-04-12T22:18:22ZAlan—Nichols11/07/64UNKNOWN··nullnull··--UNKNOWN--—null
TPATPA-569292026-01-17T10:19:29Z gerald··—hunter20080704—•••-••-1757N/ANULL5105 Sunset BoulevardCOLUMBUSOH43216nullMEDICARE-ADV-A
TPATPA-521422026-03-26T18:26:18ZGERALD—COX19711005null··•••-••-4262··—5111 CANYON ROADPlanoTexas·75044N/AN/A
TPATPA-625802026-06-23T04:14:17ZANDREW····ARMSTRONGMay 17, 1987NULLN/AUNKNOWNnull7138 MAIN STFresnoCalifornia93766——
TPATPA-594452026-10-03T16:35:36ZNOAH—TORRES9/16/1979N/A•••-••-5855NULLN/A2460 GRAND AVENUEEden PrairieMN55325—N/A
TPATPA-625962026-08-01T14:30:00ZDAVID—ELLIOTT05/20/55—·-—····4394 MAIN STREETNashvilleTN37200nullNAVIGATE-HMO
14,474 rows, page 63 of 290PreviousNext

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