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-523602026-10-17T11:42:02ZSOFIAGBROWN2003-06-02····N/A2624086601-8770 Lake View RdScottsdaleAZ85247UNKNOWNSELECT-EPO
TPATPA-564492026-07-13T19:33:46ZVASQUEZ—ALEXANDER1951-09-23null-····null4517 Ridge RoadSeattleWA98176-—
TPATPA-537882026-03-07T23:02:47ZTheresa··Munoz06/25/41N/AUNKNOWN8789573749N/A5411 Mountain View DrMinneapolisMN55412—N/A
TPATPA-545012026-05-24T08:56:10ZKarenNMorrison1985-06-12—UNKNOWN9417035798null9358 Mountain View DrFRESNOCA93727-—
TPATPA-501192026-08-26T08:47:59ZEstrada, Walter——1987-03-07—•••-••-5235—null1573 Indian School RdEden PrairieMN·55304NULL—
TPATPA-543192026-01-04T22:36:55ZElijah··—Hanson··2003-03-04——·2764045252—119 Indian School RoadJacksonville··fl32200——
TPATPA-599672026-05-03T03:33:21ZWILLIE—GOMEZ1950-08-17NULL•••-••-0950UNKNOWNnull—N/A··N/A-GRP-2477····
TPATPA-605232026-05-13T15:03:43ZCAMILA—BENNETT1992-08-15-•••-••-5614——NULL—nullnull—MEDICARE-ADV-B
TPATPA-598212026-02-09T20:15:46ZDixon, Martha——27-12-1980NULLN/A——1052 OCEAN AVEChandlerAZ85299N/A—
TPATPA-545332026-02-02T03:41:40ZMatthew—Hunt1964-09-03-NULL·+1 548 511 3418matthew.hunt11@hotmail.com·7991 Sunset BoulevardSCOTTSDALEAZ85263GRP-5793medicare-adv-b
TPATPA-565942026-02-06T22:36:42ZHernandez, George—··1955-03-23—····nullnull6868 Ridge RoadMesaAZ85297-4036GRP-6677—
TPA TPA-519632026-07-20T23:57:04Z Charles—Jones06/21/1950UNKNOWN•••-••-5183—-1193 Ocean AveMesaAZ85209NULLMEDICARE-ADV-B
TPATPA-538592026-05-26T11:40:56ZJFF—GRIFFIN19440813-··•••-••-1749(630) 814-4980UNKNOWNNULL—-UNKNOWNGRP-0134NAVIGATE-HMO
TPATPA-541982026-09-01T07:14:34Z GERALD—NICHOLS1956-12-02null—UNKNOWN—592 BroadwayLos AngelesCalifornia90092nullN/A
TPATPA-569322026-08-16T09:49:11Zjean—russell5/17/1947NULL—277.758.0393UNKNOWN8519 River Rd #721OrlandoFL32896GRP-1782··UNKNOWN
TPATPA-519442026-06-01T18:11:06ZLOGANNBELL1970-08-22UNKNOWNnull(224) 759-8345logan.bell@icloud.com8447 RIVER RDMiamifl33145——
TPATPA-627402026-03-22T13:17:57ZHannah—Santiago1963-03-04—•••-••-197917224772081·NULL4555 Washington StreetEden PrairieMN55362UNKNOWNNAVIGATE-HMO
TPATPA-515092026-08-30T20:31:14ZDavid—Hall1948-06-04—null5856060670—766 CENTRAL AVENUEDenverCO80252··GRP-8437UNKNOWN
TPATPA-519902026-10-03T19:07:23ZDonald—Torres··Dec 14, 1997UHC-22457-76nullNULLdonald.torres@yahoo.com8591 Central AveSan Diego··CA·92186GRP-6488CORE-HMO
TPATPA-603382026-06-27T00:17:58ZLAUREN—COOPER1986-09-13UHC-35857-72-UNKNOWN····——-UNKNOWNGRP-0208—
TPATPA-606332026-03-21T22:59:58ZANGELA····WOODS··1978-01-03UNKNOWN•••-••-2477nullNULL3904 Canyon RoadSCOTTSDALE·AZ85226GRP-5642—
TPATPA-540792026-04-03T20:52:03ZBrandon—Mejia·19941212——9324177N/A3682 Cedar LaneMinneapolis·MN55463··GRP-4049options-ppo
TPATPA-624342026-05-26T19:27:42ZLOGAN—YOUNG1946-04-22—null(288) 359-6938—602 Mesa DriveSan AntonioTX·78222·nullmedicare-adv-a
TPATPA-546162026-07-13T21:21:40ZPerkins, Bradley——2003-08-26UNKNOWN—(405) 590-1924·bradley.perkins@outlook.com616 Lincoln WaySacramentoCA95898GRP-2294null
TPATPA-604122026-02-18T09:14:27Zhelen—woods1975-06-19UNKNOWNUNKNOWN832-957-6026—·9455 CANYON RDAtlantaGA30336··——
TPATPA-585632026-10-18T21:10:36ZKatherine····Jordan1993-09-24nullNULL(851) 234-1751N/A3416 Hillcrest RdMiamiFL33162GRP-0749—
TPATPA-551852026-07-19T07:28:20ZStephanie—Flores1990-11-05—NULL937-605-8985-—N/AUNKNOWN—GRP-2647—
TPATPA-537262026-07-23T22:46:34ZDonald—Fields1981-05-24NULLnull3747885-··7784 BroadwayHOUSTONTX77076UNKNOWNUNKNOWN
TPATPA-567272026-01-23T16:28:46ZBRADLEY—JACKSON8/27/1949—•••-••-0324—bradley.jackson@gmail.com—UNKNOWNNULLNULLNULL—
TPATPA-595502026-04-22T04:18:05ZHELEN—SANTIAGO1959-06-06N/A•••-••-6496NULLUNKNOWN·9467 SPRING STREETHoustonTX77085—SELECT-EPO··
TPATPA-589642026-01-01T01:26:39ZRUTH—WAGNER1979-05-09—•••-••-6775NULLNULL4140 BASELINE ROAD Apt 18SacramentoCA95891GRP-4097MEDICARE-ADV-A
TPATPA-573862026-06-18T20:30:22ZCAROL—HANSEN·06/19/2000null··UNKNOWNNULL4776 Bayshore DriveJacksonvilleFL32282··UNKNOWNCORE-HMO
TPATPA-504832026-08-28T21:02:46ZChapman, Nicole····—Aug 15, 1981UHC-66699-97—--7843 MEADOW LNJacksonvilleFL32263——
TPATPA-632512026-04-18T09:35:39ZCarolyn—Li1947-07-28·NULL—NULL-·6525 Highland AveNashvilleTN37205-4517UNKNOWN-
TPATPA-604752026-09-14T08:10:19ZBryan—HamiltonJun 3, 2002··N/A··•••-••-58303358543351bryan.hamilton@icloud.com2921 OCEAN AVENUE·DenverColorado··80223-—
TPATPA-516622026-06-03T09:16:05ZMason—Marquez1998-12-04—-—null3220 Maple AvenueSacramentoCA95843N/ANULL
TPATPA-62249 2026-06-17T19:42:05ZGARY Z—BURNS11/19/84—··17963136037N/A5738 Meadow LaneMesa···AZ85253—MEDICARE-ADV-B
TPATPA-571472026-01-28T11:21:28ZJason—Montggomery1998-09-24—-(825) 625-2792—8845 Park PlaceOrlandoFL32891-5548null·SELECT-EPO
TPA TPA-550802026-05-25T06:22:06ZDoris—Cox05/05/87NULLUNKNOWNNULL—null——NULLGRP-7082NULL··
TPATPA-571942026-04-18T16:26:08ZHart—Keith1964-11-11UNKNOWN•••-••-1953(854) 396-3265N/A5574 Camelback RdCharlotteNC28254—null
TPATPA-557602026-05-09T21:42:34ZEthan··—Hernadnez1971-06-01—•••-••-2779—NULLN/A—-—GRP-5622MEDICARE-ADV-A
TPATPA-619292026-09-30T03:37:22ZAARONZMURPHYJan 6, 1966····•••-••-6162(957) 732-7505—5832 Mountain View DrChandlerArizonaN/AGRP-8441null
TPATPA-555762026-06-20T14:45:57ZJanet—Carpenter19870509UNKNOWN-NULL—9345 Sunset BoulevardAtlantaGA30390-3946GRP-6907NULL
TPATPA-537742026-08-09T15:04:29ZMurphy, Susan······1996-06-03··NULL•••-••-3532UNKNOWN——UNKNOWNUNKNOWN--null
TPATPA-553842026-08-10T20:23:52ZMontgomery, Joan——6/7/2006——·····UNKNOWN2668 Park Place·GlendaleAZ·85327nullNULL
TPATPA-558722026-01-21T07:06:11Zpaul—patel·11/22/42N/A-——8622 Bayshore DriveTucsonAZ85741GRP-1068·CHOICE-PLUS-PPO
TPA TPA-611752026-09-19T21:34:26ZGlooria··—King19760072UHC-54429-89UNKNOWN—N/A932 OCEAN AVE Apt 5Denver·CO80271——
TPATPA-543332026-07-19T08:57:27ZAlexis—Ruiz1973-05-05NULL•••-••-7317··—3858 HARBOR BOULEVARDSacramentoCANULLUNKNOWN··MEDICARE-ADV-A
TPATPA-615452026-05-12T09:09:58ZERICMANDREWS1969-06-10null—845-789-3306-2279 Park Place·AustinTexas78750GRP-2936NAVIGATE-HMO
TPATPA-583012026-09-27T01:06:19Zethan—reid1958-02-10—null(742) 332-8602ETHAN.REID@YAHOO.COM123 Park PlaceLos AngelesCalifornia··90017GRP-9512-
14,474 rows, page 12 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-19T19:54:25.436Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty