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-517782026-03-01T14:32:11ZBeverly—Fuller02-08-1941UNKNOWNnullNULLN/A1857 Willow CourtMinneapolisMN55416UNKNOWNUNKNOWN
TPATPA-574042026-03-27T21:46:11ZPatel, DanielP—1995-10-17NULLNULL—UNKNOWN8966 Sunset BoulevardLas VegasNV89196GRP-4764UNKNOWN
TPATPA-526072026-07-16T17:37:51ZDeborah—Carter1952-02-25null•••-••-3782······—UNKNOWNN/A———
TPATPA-642582026-10-01T00:31:01ZAnderson—Carlos24-02-1946—•••-••-8669N/A—965 SPRING ST #149SacramentoCA95810··NULL····
TPATPA-626102026-05-11T15:39:34ZJOSEPH—PENA1945-01-07UHC-35846-37null——7383 Church StDenverCOnullGRP-0595NULL
TPATPA-614102026-01-26T20:55:49ZWang, Dorothy——20-07-1974—-4857429dorothy.wang12@icloud.com4129 BAYSHORE DRColumbusOH43268···UNKNOWNOPTIONS-PPO
TPATPA-555972026-05-17T09:09:28ZAMMBERBKENNEDY··1969-02-27———N/A1169 Apache BlvdLos AngelesCA90098-UNKNOWN
TPATPA-572772026-07-21T11:32:41ZSTEPHANIE··—LANE1941-06-10—nullnullNULL7072 Baseline RoadAtlantaGA30315-8394GRP-6948··-
TPATPA-507412026-01-15T17:38:12Zjacqueline—taylor27-10-1976—NULLnullJACQUELINE.TAYLOR@AOL.COMnull—-—GRP-6789CHOICE-PLUS-PPO
TPATPA-569242026-03-26T07:56:12ZRyan—Gordon2000-09-19-—598.834.5854—491 Main StreetFRESNOCA93725NULL—
TPATPA-513152026-08-18T07:25:40ZRamirez, Frank··—09/09/1973··UHC-97290-10N/A3713242989····16 Pine DrFresnoCalifornia93793GRP-0296··—
TPATPA-609742026-04-06T20:07:27ZDiegoQFreeman··1971-12-28NULL—-UNKNOWN3303 Ocean AveGLENDALEAZ85309UNKNOWNUNKNOWN
TPATPA-578902026-05-05T22:18:48ZSARA—JONES1965-11-04—N/A-sara.jones@proton.me5042 Main StreetColumbusOH43243-—
TPATPA-521042026-07-19T21:59:45ZRuth—·Espinoza03/03/85-null(307) 205-6243RUTH.ESPINOZA37@GMAIL.COM3435 WILLOW COURTColumbusOhio43296-1946GRP-3602N/A
TPATPA-608892026-01-17T02:53:18ZKayla··—Willis··N/AUNKNOWN··—N/A—6807 Highland Avenue #992ScottsdaleAZ—UNKNOWNOPTIONS-PPO
TPATPA-541072026-03-28T21:43:28Zbetty—mendez1998-09-03NULL-·(856) 968-5949—5766 Spring StreetDALLAS·TX75216··N/A·N/A
TPATPA-593182026-05-19T15:35:28Z Jesse—Davis02/15/44··UNKNOWN2425160662—·7335 CANYON ROADScottsdaleAZ85248GRP-4025—
TPATPA-575392026-07-26T17:09:07ZMARGARET··MOOREFeb 17, 1965——12875169648margaret.moore@aol.com5409 Canyon Road·SACRAMENTOCA95815——
TPATPA-606752026-10-07T02:03:32ZPhilip—Warren1964-04-26·UNKNOWN•••-••-3025(623) 764-3552··null416 Meadow LaneNashvilleTN37260GRP-4893UNKNOWN
TPATPA-572212026-02-07T23:35:45ZBRANDON—STEVENS1976-11-18·null•••-••-3068UNKNOWNnull4843 Palm DrEden PrairieMN55345—null
TPATPA-591222026-01-23T09:03:10ZAaron—Pierce1942-09-19UHC-91720-52-—AARON.PIERCE@HOTMAIL.COM7423 PARK PLHoustonTX77063·N/A—
TPATPA-557232026-03-13T00:42:36Zmary—powell9/9/2007N/Anullnullmary.powell@hotmail.com2667 INDIAN SCHOOL ROADAtlantaGeorgia30336-6170-NAVIGATE-HMO
TPATPA-553692026-09-21T06:20:55ZRobert—Weaver16-01-1962—null—null9421 Desert Sky BlvdMIAMIfl33162—null
TPATPA-54771 2026-04-07T08:47:49ZCHERYL—KENNEDY1982-09-19—N/AUNKNOWNN/A2547 Washington StPlanotx75005null—
TPATPA-573952026-02-14T05:25:17ZMurphy, Dennis——3/18/1953N/A•••-••-91484807278523··—9734 Bayshore DriveCharlotteNC28277GRP-2383—
TPATPA-602582026-08-04T06:27:52ZHill, Willie——Feb 17, 1954—UNKNOWN—-6950 CAMELBACK RDGilbertAZ85250GRP-0403N/A
TPATPA-516352026-03-24T22:50:49ZMateo·THenderson03/13/47-—UNKNOWNmateo.henderson93@aol.com2138 Central AveChandlerArizona85227—null
TPATPA-589722026-09-26T07:15:36Z·CAMILA—RICHARDSON1972-05-10·UNKNOWN——camila.richardson51@outlook.com—-—NULLNULLCORE-HMO
TPATPA-516212026-06-15T09:21:40ZBryant, Charles——1941-02-14·N/A•••-••-1128+1 383 653 9595····5600 Baseline RoadSAN ANTONIOTX78237UNKNOWN··—
TPATPA-512442026-03-24T11:46:19Z EUGENE—CHAVEZ1944-12-06N/Anull(533) 381-0895eugene.chavez19@icloud.com3313 Ocean Avenue·MinneapolisMinnesota55443—null
TPATPA-526612026-01-03T00:23:54Zlinda—fernandez1982-04-06-•••-••-6865··linda.fernandez@aol.comUNKNOWN·UNKNOWNNULLNULLN/A—
TPATPA-562852026-02-20T20:38:50ZGabrielQShaw1941-11-06NULLN/A——3336 Willow CourtNASHVILLETN37210N/ANULL
TPATPA-54793 2026-09-17T13:39:03Z·SARAH—FERNANDEZ1951-11-24—NULL—NULLN/A———NULLOPTIONS-PPO
TPATPA-577092026-10-12T20:12:37ZBrndon—Shaw11/07/60-null—null7007 OAK STDenverCO-—OPTIONS-PPO
TPATPA-537142026-05-15T18:21:23ZMendez, Roy——·1973-06-03··—7732206513N/A9475 MEADOW LNScottsdaleAZ··—GRP-4999—
TPATPA-595262026-08-12T13:06:34ZWilliam—Olson·23-04-1938—UNKNOWN842-682-3112··2655 PARK PLCharlotteNC··28270··NULL—
TPATPA-609352026-08-01T21:31:32ZAmy—Mendoza1961-09-18·UNKNOWN-UNKNOWN····8440 BroadwayPhoenixAZ85001N/A·CHOICE-PLUS-PPO
TPATPA-534442026-04-19T17:46:02ZLinda—Price2004-11-07—•••-••-1787nullN/A--——GRP-0218CORE-HMO
TPATPA-508882026-10-08T23:57:25Zwayne—·jimenez1962-12-03—nullUNKNOWN····6937 Grand AvenueLas VegasNV89161GRP-7427MEDICARE-ADV-A
TPATPA-590152026-03-09T07:30:02Z·Roger—Howard19811111—•••-••-81125718494467—·8865 Bayshore DriveTampaFL33630··null—
TPATPA-537822026-08-31T04:21:14ZLORI—WANG19720702····•••-••-9663NULLUNKNOWN7791 Meadow LaneAtlantaGA·30384—NULL
TPATPA-519802026-04-21T21:53:29ZLisa—Silva2002-04-16nullN/A··NULLUNKNOWN6174 Willow CourtColumbusOH43235GRP-4998NULL
TPATPA-626502026-08-12T20:06:46ZVALENTINA—SCOTT1893-10-26··UHC-56762-01—nullVALENTINA.SCOTT60@ICLOUD.COM—nullUNKNOWN——-
TPATPA-549012026-01-29T18:43:07ZCharles—Maldonado1949-05-15-—3857732832—4005 Grand AvenueMinneapolis··MN55489N/AN/A
TPATPA-614292026-09-05T15:35:55ZMARIA—GARDNER1995-01-03UNKNOWN•••-••-7978663-535-7128—·4165 Lake View RdNASHVILLETennessee37232UNKNOWNUNKNOWN
TPATPA-643232026-02-13T17:10:32ZSandra·JKennedy12-08-1966-UNKNOWN(356) 760-3043nullN/ANULL—-nullCORE-HMO
TPATPA-557902026-06-14T03:55:12ZLoganAPhillips1966-04-21UHC-58593-18•••-••-8143nullUNKNOWN3710 Mountain View DrOrlandoFlorida32851GRP-9869NAVIGATE-HMO
TPATPA-545832026-07-15T09:53:33ZJery—Alexander1964-01-13—•••-••-57753143674702N/A4329 Cedar LnPHOENIXAZ85044··NULLnull
TPATPA-510032026-05-02T18:19:42ZNatalie—Luuna22-03-1943nullnull(940) 893-8025—9853 River RdGlendaleAZ85323nullnull
TPATPA-520992026-08-08T06:28:47Z·Espinoza, Albert——1962-06-23nullnullN/A—2343 CENTRAL AVE Apt 6PlanoTX75050UNKNOWN-
14,474 rows, page 181 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.111Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty