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-634082026-05-04T05:50:17Z·KEITH—KENNEDY2007-04-08—NULL4048591532keith.kennedy@aol.com8920 PALM DRIVEHOUSTONTX···77003GRP-6607·NAVIGATE-HMO
TPATPA-531492026-04-10T20:34:37Zana—price19491207NULL•••-••-7138551-203-1933—605 BroadwayJacksonvilleFL32257--
TPATPA-629242026-09-11T00:47:53ZHiroshi—Holmes1973-11-23-—····N/A·1266 LINCOLN WAYPhoenixAZ·85051N/A·SELECT-EPO
TPATPA-603452026-09-15T01:51:08ZAdam—·Morgan1970-12-26—null—null7848 Bayshore DriveChandlerAZ85268··—N/A
TPATPA-500102026-02-07T07:47:34ZJulieGCarter1979-07-02nullnull——1136 Desert Sky BlvdCHARLOTTENC28292GRP-1112—
TPATPA-590532026-03-12T12:14:13ZSandra—Bell1952-11-28—•••-••-7145·2329043078·NULL3064 OAK STREETMIAMIFlorida33185NULLUNKNOWN··
TPATPA-553702026-09-25T05:40:11ZJULIE—ALEXANDER···19900115-—N/Anull8043 Pine DriveSAN DIEGOCA92164UNKNOWNOPTIONS-PPO
TPATPA-609372026-01-31T02:55:27ZJUSTIN—GORDON1988-03-01--378.391.3676UNKNOWN2293 Union StDenverCO80284—MEDICARE-ADV-A
TPATPA-641052026-07-16T13:22:08ZYuki—Freeman19800509—•••-••-85989495709197NULL7721 Camelback RoadNashvilleTN37292UNKNOWNnull
TPATPA-599372026-01-13T13:22:38ZTommy—Day1944-02-21UHC-61347-18•••-••-43909125892thomas.day@yahoo.com1025 Mesa DriveMiamiFL33171····N/A
TPATPA-566272026-09-08T04:29:38ZAmanda—Carter2008-02-14NULL——null·4036 Valley View DriveCHANDLERArizona85274—UNKNOWN
TPA TPA-522352026-09-01T08:25:08ZARTHUR—GREENE2006-06-20NULLnull370-359-8162—4014 Cedar LnAtlantaGA30392UNKNOWNNULL
TPATPA-64032 2026-02-27T14:00:48ZLinda—Munoz1982-10-07····—--··5984 Harbor BlvdCOLUMBUSOH43261UNKNOWNCHOICE-PLUS-PPO
TPATPA-529252026-02-19T04:01:55ZCynthia—Owens1961-04-27—•••-••-6479N/Acynthia.owens75@aol.com9409 MAIN STREET··PHOENIXAZ85051GRP-1358null
TPATPA-621282026-07-07T18:39:56ZSHARON—COLLINS19740403nullNULL·null-3328 Camelback RdCharlotteNC——NULL
TPATPA-511142026-09-20T08:10:23ZEricJWarren2007-08-06nullUNKNOWN3673081573··—8057 UNION STREETNashvilleTN37280··—CHOICE-PLUS-PPO
TPATPA-540922026-06-30T03:05:58ZNANCY··CARR1992-05-05—NULL——8493 OAK STREETSEATTLEWA98158GRP-1082-
TPATPA-613372026-07-13T13:40:10ZScottB·Moreno1943-03-17-•••-••-36276264149N/A2645 Park PlSACRAMENTO·CA95841nullNULL
TPATPA-640622026-05-19T11:05:55ZCHARLES—STEVENS··01/25/2004——·358.615.2962CHARLES.STEVENS@ICLOUD.COM9425 Jefferson AvenueATLANTAGA30382N/A—
TPATPA-506152026-05-09T10:43:45ZbenjaminBharrisNov 2, 1978—•••-••-7667741-428-9056BENJAMIN.HARRIS@ICLOUD.COM1764 Mountain View DriveLas Vegas··NV89190UNKNOWN-
TPATPA-627552026-06-11T20:56:42ZAisha—Hudson1969-07-28NULLNULL3515930306—7330 Sunset Boulevard #237TucsonAZ—····NULL··
TPATPA-580732026-08-07T20:45:37ZDenise—Ward07/06/1959—•••-••-0399—UNKNOWN8358 Lake View RoadMiamiFlorida33113GRP-0105—
TPATPA-506252026-06-05T12:44:53ZDANIEL—LEE1956-02-05UNKNOWN—+1 579 749 9867—8813 Palm DriveTempeAZ85224··UNKNOWN
TPATPA-518182026-09-09T06:51:15ZWILLIAM—GARRETT1993-12-01—•••-••-1944(631) 843-1022-368 Desert Sky BoulevardTucsonAZN/A—CORE-HMO
TPATPA-502662026-08-10T20:36:43ZDanielUCox1941-11-23····—UNKNOWNNULL7426 River RdDallasTX75215·-SELECT-EPO
TPATPA-506302026-04-29T10:02:56ZJordan—Hoffman02-05-1952UNKNOWNUNKNOWN——5062 Desert Sky BoulevardLas Vegas·Nevada89113—null
TPATPA-544722026-03-26T18:18:01Z·Ralph—Hicks04/09/42—··406.308.8132———····N/A—CORE-HMO
TPATPA-523542026-04-12T13:03:32ZSandra—DixonNov 8, 1966·UNKNOWN—(646) 202-9251SANDRA.DIXON59@GMAIL.COM—UNKNOWNN/ANULLGRP-6857-
TPATPA-591452026-10-03T09:24:22ZRaymond—Munoz05/13/76null—NULL—8454 Apache Boulevard··ScottsdaleAZ85248NULL-
TPATPA-591912026-06-03T14:33:50ZPatrickQ.Henderson1968-09-17uhc-63091-04UNKNOWNNULL·NULLUNKNOWN·UNKNOWNnull—GRP-1048··NULL
TPATPA-541972026-03-06T06:54:13ZPAUL··—LONG·8/14/1994—NULL·null—231 Elm StreetDENVERCO80225N/A—
TPATPA-591702026-04-05T19:34:37ZBarbara—Thompson10/28/67—UNKNOWN+1 627 353 4245—NULLnull—null··——
TPATPA-555142026-02-19T11:34:21ZCastro, Amber——1997-08-04——-N/A6391 ELM STREETAtlantaGA30358null-
TPATPA-589732026-06-01T07:11:09ZJESSICA—MILLER08-02-1952null-·NULLN/A8223 Jefferson AvenueJacksonvilleFlorida32252—MEDICARE-ADV-B
TPATPA-580602026-08-17T22:59:09ZKENNETH—·SIMS1999-06-16UHC-30731-18—247-306-0141—392 INDIAN SCHOOL ROADPhoenixAZ85096—N/A
TPATPA-576302026-04-27T14:47:45ZCarlTWeber1999-04-18——nullUNKNOWN2535 MARKET STCharlotteNC28221··—N/A
TPATPA-539012026-01-05T20:22:53ZKevin—Rice19990086NULL—N/A—8670 Main StCHANDLERAZ85265GRP-0267NULL
TPATPA-533662026-03-09T02:59:58Z Knight, Brittany——1950-10-10NULL•••-••-7806null—3394 MESA DRIVEColumbusOH43281-1392UNKNOWNMEDICARE-ADV-A
TPATPA-631512026-03-06T22:40:28Zcarolyn··—·rose-—•••-••-93345486321—6101 Park PlaceGilbertAZ——null
TPATPA-542682026-05-07T13:13:45ZPriya—RobertsUNKNOWN—UNKNOWN575-538-8631priya.roberts31@hotmail.com7499 MARKET STREETLas VegasNV89101—NAVIGATE-HMO
TPATPA-541162026-01-11T17:17:52ZBRIAN—·HAWKINS1990-20-01UNKNOWN•••-••-4322——9646 Spring StreetNashvilleTN37275GRP-5360choice-plus-ppo
TPATPA-626712026-04-26T20:28:48ZREBECCA—ESTRADA1998-01-03UHC-94735-59•••-••-8069——9541 JEFFERSON AVEAtlantaGA30310UNKNOWN-
TPATPA-620502026-07-19T16:38:16ZVargas, LoganR.—19650607N/A—811-928-7403-NULL———GRP-7640UNKNOWN
TPATPA-643782026-09-15T02:50:54ZEMILY—HAMILTON1985-04-24—-UNKNOWNemily.hamilton14@gmail.com1869 Apache BoulevardSan AntonioTX78278··-NAVIGATE-HMO
TPATPA-586612026-09-14T15:59:58ZElijah—White3/16/1986nullNULLNULLelijah.white72@outlook.com3199 Maple AveMiamiFL33199··-NAVIGATE-HMO
TPATPA-562342026-06-01T20:15:24ZKathleen—Morris1962-10-27N/A—N/ANULL3402 HIGHLAND AVENUEDallasTX75236·N/A··
TPATPA-637502026-10-09T01:53:51ZJoe—Vargas1973-02-28null—(774) 517-5459null4634 LAKE VIEW RDDallasTX75214GRP-4526-
TPATPA-54629 2026-03-25T14:26:46ZMarilyn—Patterson19970105——·(568) 874-4256UNKNOWN9305 Meadow LaneOrlandoFL32888GRP-5805N/A
TPATPA-622082026-07-17T00:29:20ZJORDAN··BANKS1980-04-06·null-—UNKNOWNN/Anull·null—nullCHOICE-PLUS-PPO
TPATPA-562132026-07-05T17:33:32ZMICHAEL—LUCAS1965-08-11UHC-72265-16—·nullmichael.lucas@aol.com1524 Highland AveEden PrairieMN55329GRP-8299-
14,474 rows, page 220 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:56.280Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty