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-590782026-07-16T02:47:42ZEmma—Hunt1984-02-17-•••-••-5232NULL·null3835 CENTRAL AVENUEMIAMIFL33161-····
TPATPA-54820 2026-02-19T09:42:10ZCAROLYNKCHEN9/2/2006null•••-••-52552756819734—2822 SUNSET BLVDGlendaleAZ—GRP-1238—
TPATPA-522692026-09-03T14:23:18ZAnna····Luna19990819UNKNOWN··—8103932UNKNOWN5012 Oak StreetJacksonvilleFL32213GRP-9189—
TPATPA-638902026-06-04T19:27:09ZJenkins, Shirley—····1973-05-17nullN/A9095921322N/A7004 Washington Street Apt 11Nashvilletn·37207-2210N/ANULL
TPATPA-637942026-06-28T11:55:33ZArmmstrong, Zachary——1978-01-27··•••-••-9548UNKNOWN·null5977 BroadwayPHOENIXAZ85097NULL—
TPATPA-53418 2026-01-10T07:14:32ZNoah—Milller20-01-2003—•••-••-6224——468 Bayshore DriveSCOTTSDALE·AZN/Anull—
TPATPA-584392026-01-30T12:30:15ZKATHERINE····HUDSON1983-12-15UNKNOWN·NULLNULLUNKNOWN1002 Indian School RdTUCSONAZ85753——
TPATPA-634232026-08-16T04:04:27ZLori—Cruz1941-06-02-•••-••-0809nullnull1354 HARBOR BLVDAtlantaGA30388--
TPATPA-566932026-01-21T01:33:21ZHannah—Carroll6003-20-03-•••-••-7129909.818.1731—nullUNKNOWNN/Anull——
TPATPA-602202026-08-09T13:00:16ZFrances—Guerrero1985-09-19UNKNOWN•••-••-6377(857) 746-5785null5198 Main StreetMESAaz85261GRP-1303N/A··
TPATPA-619322026-03-27T10:10:57ZThomas—Phillips1991-03-10UHC5532289NULL-—175 APACHE BOULEVARDDENVERCO80267UNKNOWN—
TPATPA-589292026-09-15T14:51:26Zgerald—gardner01-06-1952UNKNOWN—(341) 488-2720—2245 Meadow LaneCharlotteNorth Carolina—nullUNKNOWN
TPATPA-542962026-04-13T00:23:50Z STEVEN····GRYA07/02/1969UNKNOWNNULL6799746630—8064 Desert Sky BlvdOrlandoFL32870N/AMEDICARE-ADV-A
TPATPA-548302026-09-06T05:18:21Z·lauaZ.li1952-03-28NULLN/A699-616-5002—6983 Willow CtSCOTTSDALEAZ85213GRP-2082-
TPATPA-558642026-03-01T23:21:01ZAnderson, Lawrence——08/07/2000—null-lawrence.anderson@aol.com6884 Meadow LaneSAN DIEGOCA92130—N/A
TPATPA-609082026-02-17T06:52:03Z BETTY—KENNEDY1966-12-18··•••-••-479119128253165-—N/A——GRP-9024NULL
TPATPA-544462026-10-05T13:50:42Ztheresa—diaz1940-08-20NULL—6303533211theresa.diaz@yahoo.comUNKNOWNNULL—N/AUNKNOWNN/A
TPATPA-572272026-07-27T16:34:41ZGregory—Campbell06/18/03N/A··-6878780418—6371 Mountain View DrAustinTexas78791-8884—N/A
TPATPA-586262026-03-27T18:29:26ZEMMA—RUIZ1990-04-02N/ANULLnull-4087 BroadwayAtlantaGA30376UNKNOWNCHOICE-PLUS-PPO
TPATPA-580592026-06-14T01:36:29ZEVELYN··EVANS1988-03-04-—nullUNKNOWN549 Grand AvenueGilbertArizona85249-2455GRP-9680—
TPATPA-520402026-05-12T21:32:36ZMargaret—Smith·1976-01-15UHC-25071-63-—N/A1446 RIDGE ROADChandlerAZ85248·nullOPTIONS-PPO
TPATPA-578962026-03-27T00:10:04ZCharlie—Mitchell2008-12-26UHC-47452-54•••-••-1046—NULL9763 Hillcrest RdMesaAZ85209—UNKNOWN
TPATPA-541182026-01-22T00:41:03ZBRIAN—HAWKINS2/1/1990nullnullnull—9646 SPRING STNashvilleTN37275-CHOICE-PLUS-PPO
TPATPA-612952026-02-01T17:42:19ZTim—Lawrence1973-06-15UHC-34368-51——TIMOTHY.LAWRENCE38@HOTMAIL.COMnull—nullnullnull·UNKNOWN
TPATPA-565552026-05-27T17:11:37ZDROOTHY—HUDSON1988-11-08UNKNOWN—NULLUNKNOWN3077 MEADOW LANEMinneapolisMN55437NULL—
TPATPA-582382026-10-16T05:55:49Z·Judy—Martin05/09/1991UNKNOWNN/A7503273593·UNKNOWN7674 MAIN STREETPlanoTX75076——
TPATPA-508812026-07-28T23:48:30ZJeffrey—King1951-04-08nullnull2994665423UNKNOWN8238 Camelback RoadLOS ANGELESCalifornia90090null—
TPATPA-505632026-01-21T02:35:42ZKelly—James07/15/1949N/ANULL·UNKNOWNUNKNOWN1768 Maple AveEden PrairieMN55316GRP-0931—
TPATPA-613172026-02-02T08:52:18ZPriya—Berry1967-10-14—nullNULLnull958 Main StreetLos AngelesCA90005-7499-MEDICARE-ADV-B
TPATPA-578142026-03-25T06:07:21ZSchultz, Jason——1989-11-12NULL—6877064246jason.schultz@proton.meN/Anull—NULL—N/A
TPATPA-637562026-09-16T19:13:21ZNathan—Thompson1947-04-04N/AUNKNOWNNULLNULL8222 JEFFERSON AVENUEDenverColoradoN/A—CORE-HMO
TPATPA-507082026-06-26T01:00:07Z Arthur—Barnes1939-09-18UHC-14329-27•••-••-761216919199371arthur.barnes@hotmail.com··4548 Apache BoulevardTUCSONAZ·85735nullNULL
TPA TPA-509452026-05-08T10:07:47ZCooepr, Ryan——07/25/95N/A•••-••-8634—·ryan.cooper56@hotmail.com9896 Sunset BoulevardTampaFL33604N/A—
TPATPA-587742026-10-08T04:46:43ZJacob—Brooks1980-40-10NULL•••-••-9502N/AJACOB.BROOKS@YAHOO.COM——N/A—null—
TPATPA-59222 2026-04-15T13:34:50ZSTEPHANIE··HARPER19640615N/A•••-••-6857nullN/A——NULL—nullUNKNOWN
TPATPA-504622026-02-02T01:34:09Z·Luis—Fernandez2003-04-11UHC-36488-55—····UNKNOWN604 Lake View RdSCOTTSDALEAZ85251GRP-3587NAVIGATE-HMO
TPATPA-528672026-04-02T15:58:55ZJESZE—·PIERCE1960-02-11N/AUNKNOWN··nullNULL8153 BroadwayLas VegasNV89190GRP-5358MEDICARE-ADV-A
TPATPA-626852026-05-26T23:21:12ZAnthony—Clark08/14/86-•••-••-0478··—8696 FOREST AVE··San AntonioTX78208——
TPATPA-541222026-04-18T05:25:35ZJUSTIN—RUSSELL1972-06-26-NULLnullN/A2618 Church Street Apt 35NASHVILLETN—GRP-3817NULL
TPATPA-631142026-08-25T17:16:01ZSteve—KelleyNov 11, 1976··null•••-••-0719(682) 708-9888UNKNOWN3639 CAMELBACK RD···JacksonvilleFL32283-—
TPATPA-539712026-05-17T03:10:24ZCARLOS—NGUYEN1985-03-23UHC-33573-55———4442 DESERT SKY BOULEVARD Apt 30San AntonioTX78285GRP-1172NAVIGATE-HMO
TPATPA-528632026-01-05T02:16:28Z·CARLOS—GRDON·4/28/1983—•••-••-4533(574) 515-5263··—5917 MAPLE AVENUEPlanoTX75040null····
TPATPA-518892026-01-20T10:16:53ZEmmaJJensen11/01/53—•••-••-2425·595-340-7948—6876 Mesa DriveMiamiFL··33166GRP-6875UNKNOWN
TPA TPA-516502026-03-28T05:31:05Z·JOHN—HOWAD1966-05-09UHC-29863-30·-4729471098-6539 Sage CtSAN ANTONIOTX78222GRP-8942UNKNOWN
TPATPA-643882026-01-14T11:01:11ZJacqueline··Rogers1972-07-03··-•••-••-0750—jacqueline.rogers57@outlook.com··8721 Ridge RoadScottsdaleAZ85297N/Anull
TPATPA-593922026-05-10T13:23:13Zmateo—mendoza·19450328nullUNKNOWNnull—3021 Washington Street·COLUMBUSOHNULLN/A—
TPA TPA-599932026-02-15T01:39:30ZEugeneC.Crawford1992-09-17——6168857751-1269 Mesa DrGilbertAZ85205GRP-6130—
TPATPA-593582026-09-07T12:39:07ZELIZABETH—SANTIAGO1974-02-24—•••-••-00054634165665NULL·1713 Ridge RoadMesaAZ85274··GRP-5017··OPTIONS-PPO
TPATPA-540502026-08-08T09:19:50ZGilbert, Joan——19950614—NULL——6266 VALLEY VIEW DR #715AustinTX78702GRP-6612null
TPA TPA-537802026-09-15T11:08:45ZANN—MURPHY1974-11-17UHC-34533-93—NULL—4819 Church StreetCharlotteNC28266··NULL—
14,474 rows, page 130 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:46.094Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty