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-573412026-01-09T11:44:40ZDANIELLE—HILL1995-12-09N/A—NULLnull1649 DESERT SKY BOULEVARDORLANDOFL32812NULLMEDICARE-ADV-B
TPATPA-620692026-09-20T00:16:52ZGregory—Sandoval21-02-1979UHC-93440-38—nullUNKNOWN1634 Mesa DrJacksonvilleFL32266NULL-
TPATPA-505282026-05-28T02:31:48Zbob—anderson1993-09-12——NULLnull7064 Sunset BoulevardDenverCO80294GRP-9440null
TPATPA-501862026-02-13T03:48:28Zharold—sullivan06/21/1988—nullUNKNOWN··UNKNOWN7597 Pine DriveSan AntonioTXNULLGRP-4431OPTIONS-PPO
TPATPA-571152026-05-25T00:09:38ZAndrew—Dominguez·2008-06-06UNKNOWNnull··UNKNOWN2936 BroadwayCOLUMBUSOH43250-4136NULLSELECT-EPO
TPA TPA-640782026-02-04T21:15:27ZAbby—Carlson19900413··UNKNOWN—512-855-9598N/A1325 OCEAN AVENUELos AngelesCalifornia90089—OPTIONS-PPO
TPATPA-540412026-02-25T08:59:25ZJason—Gordon06/05/1952—null12277306812—N/A—N/A—UNKNOWNnull
TPATPA-601822026-07-17T17:15:58Z Matthew—Sims1950-01-14UHC-92965-60—506-764-8001—nullNULL-NULL-··NULL
TPATPA-643352026-08-16T09:00:43ZEvelyn—Franklin10/02/1956N/A—7313852638UNKNOWN—UNKNOWNnull·null—MEDICARE-ADV-B
TPATPA-613222026-09-12T04:14:57Z·MASON—BAKER1942-12-28N/Anull·9625822416null3296 BROADWAYDENVERCO80249NULLCHOICE-PLUS-PPO
TPATPA-593012026-09-02T10:38:55ZJoseph··—Bradley05/12/97N/A··NULLNULL·joseph.bradley49@aol.com-·UNKNOWN····UNKNOWNGRP-9397choice-plus-ppo
TPATPA-624462026-06-24T20:56:35ZGarza, Gerald——04/09/1945··•••-••-3668—gerald.garza68@icloud.com3829 Main StDenver··co80234-2047N/A-
TPATPA-563012026-04-22T00:59:31ZADAM—CHAPMAN1985-07-19NULL··null—-8709 SAGE CTEden PrairieMN55360——
TPATPA-522782026-08-22T14:20:34ZDanielle—Schultz09/04/1946N/A··null··3744703471··—9873 Mesa DrMiamiFL·33120—CORE-HMO
TPATPA-636262026-06-28T03:46:30Z RONALD—WHEELERFeb 14, 2001NULL•••-••-8028N/A····1587 Park PlPLANOTX75076UNKNOWN—
TPATPA-62167 2026-03-18T10:34:21ZANTHONY—·OLIVER1962-09-24-•••-••-0626—UNKNOWN697 Meadow Ln Apt 9PhoenixAZ85026-choice-plus-ppo
TPA TPA-534632026-08-22T10:18:02Zalexander—perry1975-08-25——UNKNOWN··—UNKNOWN—-nullNULL—
TPATPA-506892026-05-19T14:23:04ZLUIS—MEJIA02/19/1977nullUNKNOWN-·NULL—N/ANULL—-SELECT-EPO
TPATPA-52377 2026-05-04T09:38:42Zlucia····king1947-06-23UNKNOWN•••-••-4090nullUNKNOWN1729 CEDAR LANESEATTLE··WA98174-UNKNOWN
TPA TPA-521402026-05-03T04:16:11ZGabriel—Medina05-08-1972—null——5361 Ocean AvenueTempeAZ85262-3735-N/A
TPATPA-560402026-10-13T04:25:29ZKayla—Perkins·1973-20-10N/A—(895) 365-4751kayla.perkins67@aol.com·9256 Sunset BlvdSeattleWA98168UNKNOWNNAVIGATE-HMO
TPATPA-529012026-01-03T16:59:13Zchristina—fox1919-04-09N/Anull·(597) 904-3437—873 Spring StreetTempeAZ85245GRP-6964N/A
TPATPA-524762026-01-20T10:01:26ZDiego—Bradley04/22/1978NULL-··——1851 Ridge RoadPLANOTX75001—CHOICE-PLUS-PPO
TPATPA-637512026-02-10T23:38:28Zjoe—vargas19703228—•••-••-2860—-4634 Lake View RoadDallasTX75214GRP-4526-
TPATPA-568512026-06-29T19:49:48ZMaria—RyosNULLUHC-61386-44null(429) 691-5838NULL9019 Cedar LaneSacramento··CA95803GRP-1895NAVIGATE-HMO
TPATPA-629422026-01-23T12:46:21ZDenny—Meyer1988-09-15UHC-24695-90null(287) 404-5819—9097 Spring StreetSeattleWA98166·null—
TPATPA-630952026-10-15T14:08:16ZScott—Mason01-04-1974null•••-••-9396null··scott.mason@gmail.com6312 Grand AveColumbusOH43228-null
TPATPA-604382026-09-19T11:42:03ZDiegoXMorales1963-05-24-•••-••-8131UNKNOWNN/A890 Hillcrest RoadTampafl-——
TPATPA-575692026-02-10T13:00:12ZTYLER····SINGH2002-04-12—····null·TYLER.SINGH14@AOL.COM7305 Valley View DrLAS VEGASNV89124UNKNOWN—
TPATPA-607672026-06-20T23:47:14Zdoris——19620427—•••-••-0494UNKNOWN—3850 Bayshore DriveDallasTX75270—CORE-HMO
TPATPA-608342026-04-04T06:46:11Z·CARLOS··HOFFMAN08/01/63——null—·N/A——UNKNOWNGRP-4504—
TPATPA-618382026-02-10T02:48:27ZELLIJAHLMONTGOMERY·1993-03-04—-(249) 907-7765ELIJAH.MONTGOMERY63@OUTLOOK.COM7134 Jefferson AveNashvilleTennessee37234··nullnull
TPATPA-549832026-05-19T10:32:26Z·Margaret—Roberts··19620520—····NULL—6363 Highland AveLos Angeles·CA90039GRP-8307SELECT-EPO
TPATPA-571302026-07-17T02:22:40ZANDREAXCOLLINS19940303null——·UNKNOWN4578 Market StreetSacramentoCAnull—OPTIONS-PPO
TPA TPA-579012026-03-22T05:03:30ZMarianaCRay14-12-1981··—N/A(443) 506-3290mariana.ray79@gmail.com5557 Hillcrest RdMinneapolisMN55417GRP-0700NULL
TPATPA-615712026-07-10T18:53:01ZLucia—Morrrison08-08-1949—UNKNOWNnullNULL3272 Forest AveDallasTX75243-··NULL
TPATPA-562012026-02-01T12:16:02ZDavid·IHernandez1987-06-28null-NULL-·UNKNOWNNULLUNKNOWN—·GRP-5652NULL
TPATPA-621732026-05-23T12:01:25Z Patel, Brian——1955-12-13UNKNOWN·UNKNOWN-null—UNKNOWN—N/AGRP-4893—
TPATPA-529782026-05-14T22:34:03ZDiana—James··1952-05-22—N/A—null3640 Sage CtGlendaleArizona85358NULLCORE-HMO
TPATPA-513092026-10-12T14:25:27Zjose··—howell··11/01/79uhc-12973-72N/AnullN/A6267 Camelback RoadNashvilleTN37265··CORE-HMO
TPATPA-636282026-06-28T09:37:11ZJulieCWalsh·09/08/1980UNKNOWN•••-••-7863785-313-6471julie.walsh@icloud.com4721 Meadow LnFresnoCalifornia93756N/AMEDICARE-ADV-B
TPATPA-529592026-05-25T03:42:08ZWillieL.Martin1951-09-19nullUNKNOWN(332) 987-4066—8414 WILLOW COURTNASHVILLETennessee37262-CORE-HMO
TPATPA-617482026-06-20T09:06:44Z BRITTANYMGONZALEZJul 9, 2006N/A—N/A-··694 CEDAR LANEAustinTX78745-OPTIONS-PPO
TPATPA-536002026-10-18T17:24:19ZPark, Mark——1959-03-08——UNKNOWN-8718 CHURCH STREETGilbertAZ-—-
TPATPA-529482026-05-31T13:03:05ZJacqueline··—Nunez06/14/47—-——2269 Sage CourtGlendaleAZ85342GRP-2463SELECT-EPO
TPATPA-611882026-03-20T06:54:02ZBETTYVWATKINS·07/17/1994NULL•••-••-6585N/A··-NULLNULLUNKNOWN——CORE-HMO
TPATPA-589412026-03-14T13:15:57Z Mason—Foster1975-03-14UHC-91690-75NULLnull-··3701 Harbor BoulevardNASHVILLETN37229GRP-1301core-hmo
TPATPA-630732026-09-15T11:30:14ZStephanie—YangSep 3, 2002N/A•••-••-4847—·UNKNOWN6020 Ocean AveCharlotteNC28250NULLMEDICARE-ADV-A
TPATPA-505602026-06-03T23:38:21ZJohnson, Anthony——1959-04-12—nullUNKNOWNNULL4195 MEADOW LNOrlandoFL32872N/A··-
TPATPA-501522026-10-16T01:55:41ZSoto, GraceB—1946-03-03NULL—-NULL4634 Forest AveOrlandoFL32819—MEDICARE-ADV-B
14,474 rows, page 241 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:43:00.220Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty