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-596352026-10-08T23:16:24ZSHARONWGERGE1959-01-13—•••-••-7841(606) 910-6660UNKNOWN1079 Grand AvenueColumbusOH43236—CORE-HMO
TPATPA-636592026-04-09T05:53:59ZGRACE—RICHARDSON1979-11-01—null(566) 688-7063NULL489 Ocean AvenueScottsdaleArizona85201——
TPATPA-551282026-07-30T13:11:12ZValentina—Otriz1958-09-28··N/A•••-••-3866(343) 261-9680—2148 Willow CourtColumbusOH43285··-··
TPATPA-610062026-09-24T11:13:53ZCok, BruceO—·11/5/1960—•••-••-59264154129145—993 WILLOW CT··MinneapolisMN55471GRP-8306null
TPATPA-509302026-05-08T23:36:26ZAndrea—Yang1984-04-20N/A-352.931.5628—NULL—NULL—GRP-2263MEDICARE-ADV-B
TPATPA-563202026-05-08T15:18:27ZGloria—Williamson1945-03-07—•••-••-2161-gloria.williamson61@yahoo.com··1445 BroadwayAUSTINTX78727NULLNAVIGATE-HMO
TPATPA-556112026-02-28T13:00:50ZKyle—Evans·1946-06-20-····N/A-1017 Spring StSan DiegoCA92170GRP-5233CHOICE-PLUS-PPO
TPATPA-636712026-03-14T07:18:25ZKimberly—Wright1987-09-02N/AN/A929.624.1168—4002 Market StNashvilleTN37271—OPTIONS-PPO
TPATPA-622802026-03-24T00:02:51Zkelly—vazquez1940-03-23—-—KELLY.VAZQUEZ@GMAIL.COM5213 Jefferson AvenueMinneapolisMinnesota55480——
TPATPA-526622026-10-07T08:25:57ZBrian—Perkins1971-11-22UHC-98944-17•••-••-5506UNKNOWNN/A2848 SAGE CTSeattleWAnullNULLNULL
TPATPA-607402026-01-25T19:10:38ZOmar—Perez··05-02-1976N/A——OMAR.PEREZ64@OUTLOOK.COM5497 CANYON RDLas VegasNV89146-—
TPATPA-537952026-02-07T13:58:01ZDebraSChavez1977-11-01null•••-••-9499NULL—1967 Highland AvenueSacramentoCA·95831N/Achoice-plus-ppo
TPATPA-546632026-08-13T10:31:12ZVICORIA—CONTRERAS19740719——NULLnull7228 BASELINE RDOrlandoFL32817——
TPATPA-534812026-10-05T20:35:55ZJoseph····Gardner05/07/02—•••-••-4486—null520 Ocean AveSan DiegoCA92120··—CORE-HMO··
TPATPA-531952026-07-03T14:05:23ZDebra—Jorden10/12/1984UNKNOWNN/A·4698938683·UNKNOWN1275 Lake View RdJacksonvilleFlorida32241GRP-3504N/A
TPATPA-547702026-07-09T13:33:21ZPerry, Julie——1941-11-10——6024678671null7330 Canyon RdSan DiegoCA92139NULLNAVIGATE-HMO
TPATPA-510012026-04-05T21:47:38ZWouds, Sandra——1950-04-09UHC-62281-29··•••-••-7617——2795 BroadwayDenverCO80232—·UNKNOWN
TPATPA-507762026-02-22T13:45:32ZKATHLEEN—NELSON3/19/2002N/AN/A356-548-2555NULL7481 Mesa Dr #742NashvilleTN37287······N/A
TPATPA-620152026-07-23T17:47:44Z·Murrray, Carol——1967-04-06····—+1 875 568 3662N/AnullUNKNOWNN/A·-GRP-8207—
TPA TPA-534072026-05-17T08:58:53ZWashington, Gabriel····—1964-10-07—•••-••-1366N/A·null7013 SPRING STREET Apt 7MesaAZ85252nullnavigate-hmo
TPATPA-633472026-02-20T20:43:46ZLauren—Barnes1993-90-09—•••-••-3740—UNKNOWN9543 Union StreetDenverCO80206··NULL
TPATPA-620192026-08-16T11:59:43Z·EdawrdJHayes01/02/62—NULLnull—4374 Palm DrJACKSONVILLEFL32298GRP-2875·MEDICARE-ADV-B
TPATPA-581832026-09-22T22:28:55ZKayla······Cunningham1964-01-07null•••-••-0274-KAYLA.CUNNINGHAM51@YAHOO.COM8778 Cedar LaneAtlantaGA30356GRP-2006UNKNOWN
TPATPA-613252026-03-27T07:33:44ZTHOMAS····MARSHALL1967-10-28UNKNOWN•••-••-2666NULLthomas.marshall56@aol.com9589 DESERT SKY BOULEVARDEden PrairieMN55397—NULL
TPATPA-616622026-03-21T13:36:28Z DOROTHY—ALEXANDER1946-07-26——nulldorothy.alexander56@proton.me4659 OCEAN AVENUEAtlantaGA30303N/ANULL
TPATPA-517222026-06-01T19:49:33Z·Jonathan—Bennett1968-03-13·-·NULLnullN/AUNKNOWN-··NULL·N/AGRP-9714NULL
TPATPA-640902026-02-19T22:24:20ZAlexis—Reed19550305——·251-688-1975·-5473 Canyon RdMinneapolisMN55426-0110UNKNOWN—
TPATPA-623292026-03-31T10:56:00ZKevin—Fernandez1971-05-07N/A•••-••-2395(808) 752-2104kevin.fernandez81@gmail.com--null-NULL—
TPATPA-610682026-02-07T18:25:48Zscott—knight01-04-1964UNKNOWN··NULLNULL—5464 Oak StreetMIAMIFL33131GRP-5889N/A
TPA TPA-597402026-07-17T18:59:05ZSandra—Robertson1970-03-20UHC-96193-90N/ANULLsandra.robertson@yahoo.com8779 BASELINE ROADMesaAZ85275GRP-4490null
TPATPA-590502026-10-13T02:00:26ZMelissa—·Reed1984-05-20UNKNOWN—+1 369 491 9865melissa.reed33@outlook.com3282 Church Street #660Los AngelesCA90047-UNKNOWN
TPATPA-642572026-05-23T05:40:48ZJACK—GRAHAM03/04/81—nullUNKNOWN—9805 CAMELBACK RDEden PrairieMNnullNULL—
TPATPA-604662026-02-15T18:04:37Zsamantha—reid02/22/77UNKNOWN•••-••-9101—N/A5376 Canyon RdLOS ANGELESCA90092——
TPATPA-576002026-06-24T21:40:49ZFATIMA—REYES1980-05-02-•••-••-4950nullUNKNOWN3893 Meadow LaneCHARLOTTE··NC28204·GRP-8203NULL
TPATPA-52518 2026-03-16T02:05:35Zabigail—little18-10-1976nullNULL··abigail.little13@gmail.com7922 Apache BlvdFRESNOCA93788··GRP-1436·NAVIGATE-HMO
TPATPA-638752026-03-16T04:06:38ZSantos, Priya——1994-05-09—•••-••-4359NULL·priya.santos11@icloud.com686 Canyon RdTampaFlorida··33615GRP-8156OPTIONS-PPO
TPA TPA-570802026-03-08T18:36:25ZWillie—Sanchez1949-01-09N/A•••-••-5759N/AUNKNOWN———UNKNOWN-SELECT-EPO
TPATPA-510792026-09-04T19:10:21ZLucia—Hansen1985-01-22——UNKNOWN—nullN/A··——N/A
TPATPA-559982026-09-25T11:49:27ZFrances—Jacobs1974-02-01null····—-4632 Baseline RoadMinneapolis·Minnesota55474··nullSELECT-EPO
TPATPA-545952026-07-22T10:09:00ZMARILYN—HILL1991-04-08··——NULL····8995 Desert Sky BlvdTucson·Arizona··UNKNOWNUNKNOWN
TPATPA-504282026-09-18T22:23:37ZCarolyn—Lewis1996-08-27UHC-83255-14N/A—carolyn.lewis40@hotmail.com5024 Spring St #381CharlotteNorth Carolina28254—-
TPATPA-536312026-09-24T16:17:06Z·Williams, Isabella——12/04/05··N/AnullN/A—1402 Maple AveMESAAZ85261GRP-4529··—
TPATPA-536902026-06-05T23:37:26ZbobbyPanderson1978-03-09UNKNOWN•••-••-3027853-451-0543BOBBY.ANDERSON@OUTLOOK.COM————N/Anull
TPATPA-526012026-10-10T10:27:39ZEvelyn—Chavez1955-01-09null—NULL—6106 Maple Ave··NashvilleTNN/AGRP-1014UNKNOWN
TPATPA-644092026-06-05T02:22:34ZJOED.SCOTT1961-08-27UNKNOWNN/A(412) 792-2854——·UNKNOWN·UNKNOWN—GRP-2708·N/A
TPATPA-521892026-04-30T00:08:32ZRACHEL····WHEELER1970-12-18null•••-••-3311748-275-8148—N/AN/A-——·N/A
TPATPA-596962026-01-23T13:40:30ZkimberlyGhoffman1949-03-15····—NULLUNKNOWN3254 Jefferson AvenueSAN DIEGOCalifornianull--
TPATPA-594192026-10-13T15:10:23ZYuuki—·Contreras03/01/1997UNKNOWN-UNKNOWNyuki.contreras@icloud.com4549 BroadwayPHOENIXAZ85046GRP-3344—
TPATPA-540982026-07-08T06:32:35ZTERESAUGREENE1966-10-05N/Anull8096719727teresa.greene49@yahoo.com6237 Oak StSan Diego·California92178—NULL
TPATPA-536852026-02-14T10:58:21ZJcqueline—Grant1978-12-02·-—UNKNOWNjacqueline.grant@icloud.com9887 Spring StCharlotteNC28269-5415null-
14,474 rows, page 229 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:56.318Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty