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-575802026-07-29T14:18:22ZJudith—Cole2/4/1994null··5374340268N/A4995 MOUNTAIN VIEW DRIVEDENVERColorado80241·-UNKNOWN
TPATPA-576902026-02-05T04:53:50ZJULIE—CARR1985-04-06————6342 SPRING STSan AntonioTX78204——
TPATPA-594662026-10-09T00:56:36ZWeaver, DanielleH.—19750425—•••-••-4776nullN/AUNKNOWNNULL-—·--
TPATPA-527172026-03-26T06:10:31ZMurphy, Hiroshi——1978-01-07—NULL—N/A——NULLUNKNOWNN/ACHOICE-PLUS-PPO
TPATPA-506712026-10-12T16:22:27ZSantiago—Ford19941211—NULL—N/A·179 Apache BlvdTucsonAZ·85720UNKNOWNnull
TPA TPA-526442026-05-14T09:07:30ZDOUGLAS—WALKER24-03-1961nullN/A··N/A4492 Meadow LaneSacramentoCA95824··—NULL
TPATPA-571482026-01-09T13:11:53ZBRYAN—GONZALES09/28/1982··UNKNOWN•••-••-0546(425) 736-0730null·81 Union StMinneapolisMN55449—CORE-HMO
TPATPA-568932026-05-02T23:12:14ZSandoval, Richard——1947-10-27N/A—692.298.6423richard.sandoval@icloud.com7359 Harbor BlvdSAN DIEGOCalifornia92107—N/A
TPATPA-522552026-08-12T08:56:48ZFlores, ElijahX—1966-09-10—NULL——7879 MARKET STLos AngelesCA90040-1617—OPTIONS-PPO
TPATPA-643162026-08-26T14:26:34Zgabriel··day1991-11-24UNKNOWN•••-••-8157—GABRIEL.DAY51@OUTLOOK.COM1249 Indian School RoadAustinTexas78717GRP-7036SELECT-EPO
TPATPA-609312026-08-19T19:16:02Z Marucs—Griffin19550222N/A•••-••-7022——6506 Spring StreetPhoenix···AZ-UNKNOWN—
TPA TPA-600702026-08-24T23:26:42Z ·SEAN—RAY02/01/1970··NULL—(574) 545-2514-8684 Desert Sky BlvdColumbusOH43224UNKNOWNN/A
TPATPA-541172026-01-05T15:21:53ZHawkins, Brian——02/01/90NULL—NULL··-9646 SPRING STREETNashvilleTN37275NULLCHOICE-PLUS-PPO
TPATPA-587312026-01-24T07:15:32ZRONALD—FOWLER20010405UNKNOWN·N/A(860) 802-6760—1894 Elm StreetGlendaleAZ85370-8696GRP-8572SELECT-EPO
TPATPA-642282026-07-07T03:46:37ZGraham, Lisa——1951-12-26N/AN/Anull·NULL4093 RIDGE RDTampa·FLN/AN/A··CORE-HMO
TPATPA-620092026-09-07T02:22:12ZJennifer—Lee1984-05-11nullUNKNOWN241-689-2642-2678 Palm DriveNashville··TN37256UNKNOWNnull
TPATPA-500242026-02-06T17:20:53ZEDDWARD····HARRISON1952-02-27nullNULL··—2915 MARKET STCHARLOTTENC28225UNKNOWN··choice-plus-ppo
TPATPA-555282026-09-23T19:19:37Z ·Elizabeth—Ward8/4/1947—•••-••-9345——NULLN/A—-GRP-1326NULL
TPATPA-564472026-06-29T03:02:44ZNelson, Rayomnd——1955-03-01——N/Anull8292 Sunset Blvd Apt 8HoustonTX77058-0225NULL—
TPATPA-593492026-08-02T04:32:03Zmariana—park07/02/48———--UNKNOWNUNKNOWN—GRP-2297NULL
TPATPA-629082026-03-08T13:06:54Z ThomasPPierce05-03-1948—NULL376-525-4748null··1406 MAPLE AVENUEORLANDOFL32812null-
TPATPA-552342026-06-23T01:35:45ZAHMADDHICKS08/28/1956——(640) 534-3050null6618 Lincoln Way Apt 37SacramentoCA95893GRP-0985MEDICARE-ADV-B
TPATPA-564092026-05-19T22:16:35ZNicoleAMyres1997-10-22NULLUNKNOWNNULL—1400 Union Street #661Eden PrairieMN55355NULL·OPTIONS-PPO
TPATPA-600492026-10-06T14:51:23Z·Matthews, Douglas—···02-06-1976null•••-••-5172—N/A—N/A——GRP-9121··CHOICE-PLUS-PPO
TPATPA-511592026-08-23T11:53:44Zlaryr—myers1944-11-25UHC-51103-97—UNKNOWN—4345 Maple AvenueHoustontx77010—CHOICE-PLUS-PPO
TPATPA-542812026-03-20T16:48:55ZMeiATurner19651004UHC-09846-26null+1 778 967 2297—N/AnullN/A—GRP-6209NAVIGATE-HMO··
TPATPA-644182026-01-13T22:56:52ZGregoryF.···Pea1/5/1992——N/A—8095 Willow CtCharlotteNC28269—MEDICARE-ADV-A
TPA TPA-54917 2026-02-08T22:54:02ZNancy—Wright8/12/1988UNKNOWN··•••-••-9478+1 233 835 4224nancy.wright@yahoo.com7666 OAK STLos Angeles··CA90040—MEDICARE-ADV-A
TPATPA-540912026-07-09T22:12:54ZsophaiI··jenkins23-06-1960NULL•••-••-84616293895354·null1604 River RdOrlandoFL32822·nullMEDICARE-ADV-A
TPATPA-623142026-09-10T09:08:09ZJulie—Watson03/02/82·-N/A289.893.5313··null1294 CAMELBACK RDCharlotteNC28292-1459·UNKNOWNnull
TPATPA-567912026-07-14T10:28:10ZJacob—Greene1984-10-02null——UNKNOWN··9893 Meadow LnJacksonvilleFlorida32211NULLMEDICARE-ADV-B
TPATPA-573042026-03-22T23:43:42ZKELLEY M.····FRANK2/28/1942—•••-••-7532UNKNOWN··—4477 Sunset BlvdJacksonvilleFL32204GRP-5333NULL
TPATPA-513132026-01-10T12:33:55Z Tran, Sharon····—7/21/1968··N/AUNKNOWN—N/A1198 Central AvenueGilbertAZ85215UNKNOWN-
TPATPA-627432026-04-27T23:26:25Zdaniel—marshall19401260—•••-••-5596866-412-1691null··6761 Hillcrest RoadNashvilleTN··37286nullCHOICE-PLUS-PPO
TPATPA-595732026-02-16T01:55:02ZKATHLEEN—TRAN1975-04-20-UNKNOWNN/A-4373 Central AvenueMiamiFL33166—CORE-HMO
TPATPA-532042026-09-09T07:21:58ZLisa······Bryant2/6/1997null•••-••-8829NULL-5893 Meadow LnNashvilleTN37224N/ACORE-HMO
TPATPA-555722026-01-08T18:52:04ZmariaUward1968-05-28NULL——N/A6177 Central AvenueLOS ANGELESCalifornia90025GRP-7056MEDICARE-ADV-B
TPATPA-63994 2026-03-21T18:00:04ZLucas—·MadisonDec 23, 2007—•••-••-1948UNKNOWNN/A9850 BASELINE RDAustinTX78796—SELECT-EPO
TPATPA-636532026-06-09T05:24:05ZNATHAN—SCHMIDT1949-02-10UHC-71347-26-nullN/A9863 Meadow LaneMESAArizona·85249——
TPATPA-548672026-08-18T18:17:11ZAISHA—BARNES··19860505·NULLN/A····aisha.barnes@outlook.com·6083 Main StSan DiegoCA—UNKNOWNNULL
TPATPA-637332026-09-13T05:29:14ZBryan—OrtegaFeb 7, 1959··UNKNOWN•••-••-1470null—6900 UNION STREETSan AntonioTX78226·GRP-3648OPTIONS-PPO
TPATPA-634562026-06-11T13:13:00ZNICK—OLIVER1967-01-18UNKNOWNN/AN/Anull7570 Lake View Rd·HoustonTX77050-7293GRP-3470null
TPATPA-577112026-02-19T16:17:54ZJONATHAN—LOPEZ1975-09-28UHC-56956-03——UNKNOWN9760 Bayshore DrMinneapolisMN55469——
TPATPA-594232026-06-12T03:44:40ZMARI—DELGADO1996-06-14UHC-95248-22null—null9693 HIGHLAND AVENUENashvilleTN37285nullSELECT-EPO
TPATPA-621582026-08-18T08:22:04ZJudith—Guzman1944-02-20—•••-••-0280UNKNOWNN/AUNKNOWNN/AnullNULLGRP-4728CORE-HMO
TPATPA-639112026-07-10T13:27:44ZAhmed··—RayOct 7, 1985——--2795 Meadow LaneJacksonvilleFL·32288··null
TPATPA-500172026-09-29T11:56:19ZHamilton, LoganM.—1967-05-17—•••-••-07528845228072null8066 Canyon RdSacramentoCA·95809null—
TPATPA-633412026-06-02T19:32:18ZPatty—Campbell2/24/1947NULL—(716) 688-6460PATRICIA.CAMPBELL87@AOL.COM——NULLNULL··nullUNKNOWN
TPATPA-553502026-05-06T11:25:52ZRonald—·Alexander1990-01-09—•••-••-3321null—4525 UNION STJacksonvilleFL32229··NULLN/A
TPATPA-511622026-03-14T23:36:36ZJohnRCarter03-02-1961N/A—577.788.9063john.carter@yahoo.com1434 Union StreetTempeAZ85241GRP-1513—
14,474 rows, page 112 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:43.626Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty