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-520172026-06-12T04:47:09ZBarnes, Larry——1983-06-16null•••-••-5087(340) 463-5782null7235 WASHINGTON STREETLas VegasNV89182··-N/A
TPATPA-619182026-03-31T15:42:14ZHunter, Christine——1950-77-13NULL•••-••-75574334537850··7386 Forest Ave·JacksonvilleFL32228····CORE-HMO
TPATPA-571512026-06-09T15:14:09ZDylan—RogersJul 20, 1953N/AN/A(810) 943-4477UNKNOWN9893 Sunset BlvdDenverconull—··
TPATPA-526672026-08-28T14:07:10ZSTEVEN—SANTIAGO1984-01-24UNKNOWNnull·UNKNOWN-3471 Market StreetChandlerAZ85281——
TPA TPA-547872026-08-28T01:43:47ZJesse—Warren2008-11-17—•••-••-7033(463) 830-1687—·7100 Hillcrest RoadGilbertAZ85243-4930··——
TPATPA-512012026-05-20T05:06:48Z Justin—Ramos01/11/1962NULLnullUNKNOWNjustin.ramos@aol.com4154 Valley View DriveGlendaleAZ85327—NULL
TPATPA-569382026-08-04T23:42:59ZJACOB—GEORGE6/2/1957——4223889938N/A1133 Lincoln WayEden PrairieMN·55383·N/ASELECT-EPO··
TPATPA-602472026-01-05T22:58:58ZLuis—Nunez1978-02-27-•••-••-0513——967 Bayshore DrTampaFL33601-0018UNKNOWNCHOICE-PLUS-PPO
TPATPA-505392026-09-30T20:03:05Z Lisa—Hawkins1973-04-02UNKNOWN-——910 PINE DR·San AntonioTX78212··GRP-4335OPTIONS-PPO
TPA TPA-521442026-04-23T18:10:51Z CATHERINE—FOSTEER··10/10/98-—NULL—6272 River RdMiamiFL33115-CORE-HMO
TPA TPA-595572026-08-05T22:33:46ZLINDATJOHNSON1994-09-18··UNKNOWN·NULL(878) 724-5719-3980 Baseline RdColumbusOH43215UNKNOWN··-
TPATPA-513742026-07-20T02:18:10Zsamantha··sandoval06/18/2000UNKNOWN•••-••-1082nullUNKNOWN··—·-—GRP-7446UNKNOWN
TPATPA-564402026-02-05T22:16:52ZLong, Nicole—··1966-04-13—•••-••-8201NULLN/A200 Grand AveChandlerAZ85203·N/ACORE-HMO
TPATPA-540512026-07-01T18:41:54ZBRYYAN—BOYD1956-09-28—•••-••-661019749855522—·4755 CENTRAL AVENashvilleTN37288N/A—
TPATPA-560902026-07-18T18:53:43ZRaymond—Sullivan1998-06-15··--+1 844 630 8632—9095 Bayshore DriveOrlandoFL32810GRP-5461CORE-HMO
TPATPA-511702026-03-01T12:03:00ZMARCUS—RICHARDS2008-01-28UNKNOWNnullnullmarcus.richards37@outlook.com8720 MARKET STAtlantaGeorgia30382GRP-8703N/A
TPATPA-635462026-04-02T21:13:08ZOlivia—·Hawkins1955-07-12NULLnull553-515-1907olivia.hawkins@icloud.com3492 MAPLE AVEColumbusOH43217GRP-1121—
TPATPA-541902026-03-26T02:20:24ZANA····MARTIN28-02-1951UNKNOWN—6886228454—4551 Lake View RoadColumbusOH43213nullNAVIGATE-HMO
TPA TPA-606232026-03-08T11:11:55ZGrant, Ann E——11/2/2000null•••-••-6846—null3438 HILLCREST RDLos AngelesCalifornia90038——
TPATPA-608872026-08-26T00:12:20Z·Joseph—Murray1957-08-06··NULLnull-—3641 UNION STREETEden PrairieMN55350-5665N/A-
TPATPA-620952026-02-11T18:50:07ZPaul—Hudson0505-91-92—•••-••-3655UNKNOWNPAUL.HUDSON@PROTON.MEnullN/A··UNKNOWNNULLGRP-3271MEDICARE-ADV-B
TPATPA-501812026-05-11T08:13:55ZHeather··—Hunt05/18/2001—N/A··null··heather.hunt35@icloud.com4288 Baseline RoadSACRAMENTOCA95890GRP-6621—
TPATPA-595142026-04-24T04:54:45ZWalsh, Robert——1970-02-25uhc-24675-76NULL952-349-0553null984 Forest AvenueSACRAMENTOCA95812···UNKNOWN
TPATPA-531342026-10-11T03:02:50ZNICHOLAS—GIBSON19480611NULL•••-••-1300(821) 976-9250NICHOLAS.GIBSON92@ICLOUD.COM6030 Camelback RoadMinneapolisMN55489-2416—CHOICE-PLUS-PPO
TPATPA-604372026-08-20T20:22:36ZMaldonado, John——1952-09-17null•••-••-6669null—5314 Ridge RdMinneapolisMN55481N/ACHOICE-PLUS-PPO
TPATPA-603372026-06-27T00:17:58ZLAUREN—COOPER1986-09-13UHC-35857-72-UNKNOWN····——-UNKNOWNGRP-0208—
TPA TPA-584052026-01-03T19:02:45Zsandra—white1941-03-24-—(206) 915-2864sandra.white9@icloud.com498 MAIN STSan AntonioTX78253N/AOPTIONS-PPO
TPATPA-549732026-03-06T11:54:53ZSamuel——19670712UHC-19679-79•••-••-9470null—6855 Church StreetTucsonAZN/Anull··
TPATPA-544412026-02-19T01:10:44ZETHAN—GREEN1996-12-01null•••-••-0084(794) 529-4957-714 CANYON RDJacksonvilleFL32212NULL—
TPATPA-582992026-09-25T11:04:26ZANTHONY—TAYLOR02/11/2004UHC-75125-22N/A—UNKNOWN1177 Sage CtSan AntonioTX78208GRP-3117—
TPATPA-608932026-01-28T19:12:55ZLawrence, Jerry——1950-12-23··UHC-09319-18•••-••-8397-null1879 Lincoln WayHoustonTX77085UNKNOWNN/A
TPATPA-532382026-07-08T04:06:00Z Arthur—Gilbert09/27/1963—UNKNOWN14344045344arthur.gilbert54@proton.meUNKNOWNUNKNOWN—nullNULL-
TPATPA-512802026-07-17T03:59:42Z VIRGGINIAFDELGADO1962-04-03UHC2562524—567-639-2000—8879 OCEAN AVENUEDENVERCO80215UNKNOWN—
TPATPA-50243 2026-10-17T11:11:59Z·Bryan—·Valdez09/17/86—•••-••-3524UNKNOWN—5624 Canyon RoadCOLUMBUSOH43273GRP-0665CHOICE-PLUS-PPO
TPATPA-608512026-05-14T14:48:39ZluisMhamilton07/08/1969UHC-40559-32•••-••-9957-N/A7639 BROADWAYGlendaleAZ85340·N/AMEDICARE-ADV-A
TPATPA-563582026-02-26T16:43:34ZJulie—Ellis19-11-1997UHC-11000-88NULL··5647612JULIE.ELLIS75@ICLOUD.COM444 Baseline RdCharlotteNC28247GRP-8162NULL··
TPATPA-610202026-05-18T18:21:20ZCarol·CMeyer1979-07-21UHC-67181-84•••-••-7702——3897 Camelback RoadNashvilleTN··37265GRP-6053····
TPATPA-584952026-09-04T22:29:03ZALICE—GORDON·2/17/1961—NULL·-UNKNOWN9363 LINCOLN WAYSeattleWashington98122··UNKNOWN·OPTIONS-PPO
TPATPA-548012026-06-22T21:21:07ZSofia··—Li2003-01-08NULL•••-••-5613-—303 Palm DriveSacramentoCA95850UNKNOWN-··
TPATPA-523642026-07-21T02:23:59ZKathleen—Torres1993-09-19-•••-••-8949—NULL···6571 DESERT SKY BLVDScottsdaleAZ·85200GRP-4028·null
TPATPA-602072026-09-23T08:26:47Z JOSE—·COOK1954-04-10UNKNOWNUNKNOWNNULL—7755 Union StreetLas VegasNevada89104N/Anull
TPATPA-504082026-08-08T07:26:25ZCatherine—Anderson—UNKNOWN-9527434729catherine.anderson9@proton.me2226 OAK STREETSan AntonioTX·78272·null—
TPATPA-631912026-06-08T01:57:17ZCATHERINE—LARSON1971-12-20-—N/A-··2721 Sunset BlvdSan DiegoCA92109—N/A
TPATPA-540772026-01-06T17:45:45Zisabella—berry04/01/45UHC1094947··686-392-8550—8659 Sage CourtTucsonaz85722-null··
TPATPA-59286 2026-03-09T07:47:04ZMateo—HughesMay 14, 1965—null—-—————core-hmo
TPATPA-634402026-01-11T06:15:50ZMatthew—Ellis12/06/67N/AUNKNOWNNULL—UNKNOWNNULLNULLN/A····NULL
TPATPA-515492026-03-30T01:49:18ZArjn—Dunn1987-02-05·UNKNOWN—987-260-7355arjun.dunn79@proton.me3720 Indian School RoadMiamifl33165GRP-2277-
TPATPA-583572026-05-01T19:25:50ZDOGLAS—MCDONALD11/11/1959N/A•••-••-8686N/AUNKNOWN6907 Valley View DriveAustinTX78704GRP-9482-
TPATPA-589552026-03-02T16:06:51ZMARY—GARRETT2007-12-22N/AUNKNOWN13962112281—2645 Lake View RdPHOENIXAZ85018··——
TPATPA-567772026-01-17T10:46:30Zbetty—howell1945-07-07UHC-85571-97-UNKNOWN—7429 CANYON RDFresnoCA93723-CORE-HMO
14,474 rows, page 178 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:53.098Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty