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-585062026-09-11T02:36:26ZRoger—Burton1957-03-22-—NULLroger.burton61@proton.me9068 Hillcrest RoadScottsdaleAZ85243·nullNAVIGATE-HMO
TPATPA-608012026-10-15T13:37:28ZNICK··—BURNS1982-06-07-UNKNOWN—UNKNOWN2447 Grand AveEden PrairieMN55368GRP-1841-
TPATPA-592712026-05-27T05:30:43ZDean, Elizabeth——1989-06-12—NULL··+1 693 504 7284N/A4310 Church StreetAustinTX78747NULLN/A
TPATPA-520842026-09-13T23:34:59ZCruz, Helen····11/02/88nullUNKNOWN-—756 CENTRAL AVEOrlandoFL32889—null
TPATPA-624122026-02-16T16:52:04ZKathleen—Hudson1949-01-18·N/A-—KATHLEEN.HUDSON@HOTMAIL.COM7360 Church StMiamiFL33100—-
TPATPA-592742026-08-18T05:10:47ZKaren··—Niichols1944-07-15—•••-••-9154null-8450 Indian School RdLos AngelesCA90035—MEDICARE-ADV-A
TPATPA-585782026-09-11T21:00:55ZChristine—Stevens0613-91-83-···415-944-1739UNKNOWN9540 BROADWAYSan AntonioTX78215NULLNULL
TPA TPA-584942026-03-18T01:47:35Z HANNAH··KLANE1981-02-02null•••-••-5445N/A—4374 Grand AveJacksonvilleFL32203GRP-3205OPTIONS-PPO
TPATPA-517942026-03-11T06:10:57ZBrenda—Cook1969-08-03·NULLNULLnullUNKNOWN-N/AN/A····N/A—
TPATPA-516182026-01-14T04:03:41ZKEVINE.AUSTIN1995-06-19—NULLnull—-nullnullNULLN/AN/A
TPATPA-614462026-04-05T02:40:59ZMark—Jimenez16-11-2002———NULL6303 Oak StPHOENIXAZ85071NULL-
TPATPA-593842026-04-27T00:10:30ZBen—Dean1952-07-17NULLUNKNOWN(603) 956-1652——NULLnull——NULL
TPATPA-562622026-07-24T05:24:17ZHenry—Holmes19990523UHC-19695-21—UNKNOWN—2925 Camelback RoadMESAAZ··85226-N/A
TPATPA-609612026-09-03T21:49:19ZJohnCSanders1938-09-06·UHC-51054-48NULL··—null1497 BroadwayTempeAZ85230NULLUNKNOWN
TPATPA-614822026-09-28T07:08:20ZMADISON—COOPRE2001-05-26—null——300 Church StLas VegasNVN/AGRP-5635-
TPATPA-624992026-04-18T12:02:48ZPrice—BrendaJul 23, 1950null—N/AUNKNOWN553 FOREST AVENUEAtlantaGA30397GRP-1199—
TPATPA-641502026-02-14T02:56:58ZJAK—YANG1992-01-27—•••-••-3688NULL··1847 Central AvenueGilbertAZ85209-CHOICE-PLUS-PPO
TPATPA-537552026-10-14T22:33:19ZBENJAMIN—HOWARD1960-01-14null—UNKNOWNNULL4281 Cedar LnCHARLOTTENC28219NULL··NAVIGATE-HMO
TPATPA-580682026-08-17T04:17:35ZMariana—James1986-07-14null———5211 Maple AveAustinTX78786nullUNKNOWN
TPATPA-618522026-02-21T19:59:40Zjacob··—harris1938-07-16NULLnull(507) 954-5295N/A3560 Indian School RoadTempeArizona85226nullCORE-HMO
TPATPA-601292026-07-04T19:03:23ZKATHLEEN—HUGHESDec 20, 1949-•••-••-56856968408950-5289 OAK STREETPhoenixAZ85065NULLUNKNOWN
TPATPA-592242026-01-21T05:05:15ZBRITTAYN—HUDSON·1966-07-21N/A-NULLnull1462 Canyon Road #775MinneapolisMN55447-6522—N/A
TPATPA-572252026-01-10T22:00:48ZLee, Lori——1943-09-07—null-null7843 Sunset BlvdSCOTTSDALE·AZ85261···GRP-3672MEDICARE-ADV-B
TPATPA-580462026-02-07T06:27:48ZISABELLA—HARPER1952-12-28UNKNOWN-null·UNKNOWNnullnull··UNKNOWN·NULLN/AUNKNOWN
TPATPA-621122026-02-22T15:44:37Znicholas—park11/01/1963-UNKNOWN(478) 725-8907nicholas.park65@proton.me6548 Jefferson AveLos AngelesCA90047——
TPATPA-578582026-01-27T00:44:43ZVirginiaY.WagnerFeb 14, 1996N/A··•••-••-6691——992 CEDAR LANETucsonAZ85721nullNAVIGATE-HMO
TPATPA-532092026-08-05T23:17:07ZBRYAN—BRADLEY1941-10-26—·-+1 873 663 6682-8041 Park PlaceFRESNOCA93764UNKNOWNMEDICARE-ADV-B
TPATPA-634272026-08-24T06:08:50Z MatthewT.Guerrero1957-02-20UHC-41469-99•••-••-5062N/Amatthew.guerrero@yahoo.com1771 APACHE BLVDDallasTX75246-N/A
TPATPA-561582026-08-22T15:38:29ZJulie—Morgan··1943-06-26N/A-UNKNOWNN/A1606 Baseline RoadGilbertAZ85223GRP-6027OPTIONS-PPO
TPATPA-515692026-01-15T12:29:08ZBrandonV.Lopez···1955-02-03UHC-50184-15-329-316-7866NULL1851 Market St #764MesaAZ85285GRP-0844OPTIONS-PPO
TPATPA-619592026-07-18T17:35:52ZHernandez, Kim——12/13/1945UHC6243146•••-••-4454NULLKIMBERLY.HERNANDEZ@HOTMAIL.COM4884 Pine Drive #316Phoenix·AZ85023GRP-4722NAVIGATE-HMO
TPATPA-611802026-06-14T20:29:22ZJennifer—Payne12/18/1968-UNKNOWN937-537-7924UNKNOWN8320 Willow Ct #279·GLENDALEAZ-—UNKNOWN
TPATPA-533212026-08-21T11:23:39Z COLLINS—HEATHERNov 25, 2000··NULLUNKNOWN+1 393 307 2402heather.collins@hotmail.com7770 Meadow Lane··Eden PrairieMN55357GRP-7238SELECT-EPO
TPATPA-553682026-04-09T20:21:29ZKayla····Young19930802N/A—(365) 662-0510kayla.young67@outlook.com2718 Highland Ave··NashvilleTN37245NULLN/A
TPA TPA-507702026-01-23T05:47:07ZTIMOTHYTHILL2008-11-08--6784218798timothy.hill94@icloud.com4849 SPRING ST Apt 19HoustonTX77072—-
TPATPA-553032026-09-06T22:17:14ZKenneth····Harrison1961-04-04—null——1680 LAKE VIEW RDLas VegasNV89177··—null··
TPATPA-624692026-05-21T16:31:09ZTIM····WALKER09/04/87NULL•••-••-7514(583) 302-8834———NULL—-CORE-HMO
TPATPA-615502026-07-03T03:13:05ZAnnUBailey2005-01-06—-—N/A6633 OAK ST··ChandlerAZ85210N/A—
TPATPA-545482026-07-10T21:51:11ZMyers, Terresa····19660512UHC-67569-91UNKNOWNUNKNOWN—3439 Pine Dr #322TucsonAZ··85763—null
TPATPA-55096 2026-05-30T03:13:59ZMICHAEL—PARKER·1942-08-22—nullN/A—2195 Church StSeattleWA98158GRP-8729····
TPATPA-524382026-04-06T18:13:02ZAlexisA.Johnsson05/11/80·-····—-6585 Church StreetDallasTexas75230GRP-3657··—
TPATPA-545002026-01-30T04:02:40ZRACHEL—SANTOS1994-01-24··UHC-46766-18NULL870.699.2372UNKNOWN7609 Union StreetDallasTX75290nullN/A
TPATPA-544122026-05-23T14:13:15Z·JULIE—SIMS1980-02-25··UNKNOWNUNKNOWNN/A—4819 VALLEY VIEW DRIVE··San Antonio··TX78220-2489null—
TPATPA-638572026-01-31T05:55:53ZROBERT—MILLER··1984-11-03NULL·nullnullN/A4044 Market StMinneapolisMN55403·GRP-2804null
TPATPA-590462026-02-19T22:21:33ZBeverly—Chapman1975-07-20null•••-••-3178nullUNKNOWN··2771 Lake View RoadLas Vegas·Nevada89180—UNKNOWN
TPATPA-629582026-03-22T02:39:17ZGABRIEL··FERGUSON20070914UNKNOWN—17222377414—74 Bayshore DriveDENVER·CO80231GRP-8716MEDICARE-ADV-A
TPA TPA-567122026-07-30T14:45:17ZPamela—Varags1976-01-23N/AN/AnullNULL··366 Willow CourtSan DiegoCA92145NULL·-
TPATPA-523152026-09-20T18:45:17ZANA—WHITE1980-04-08N/A··•••-••-3297-—7235 Lake View RdNASHVILLE···TN37290NULLCORE-HMO
TPATPA-588552026-08-01T10:32:15ZPaul—Medina1979-09-11NULL—null-6454 Forest AvenueOrlandoFLNULLGRP-0888-
TPATPA-572152026-05-29T12:10:13ZBeverly—Aguilar1992-04-15N/A—889-372-6618NULL·5561 MAIN STMINNEAPOLISMN55480··—NAVIGATE-HMO
14,474 rows, page 162 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:49.139Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty