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-545852026-10-08T16:51:36ZSean—Daniels1986-05-18——UNKNOWN—6525 Sunset BlvdLos AngelesCA90020UNKNOWN—
TPATPA-544992026-02-07T19:36:47ZDanielD.Alvarez1943-05-25N/A—4276742153-6848 Grand AvenueAustintx78790UNKNOWN—
TPATPA-592662026-08-09T14:04:58ZLUCIA—SMITH1/3/1964nullN/A·-—980 RIDGE RDAustinTX—GRP-8568—
TPATPA-644472026-03-11T07:07:48ZSraa—Burton1983-02-21-—nullsara.burton43@outlook.com5709 Sage CtSan DiegoCA92157GRP-0730N/A
TPATPA-58511 2026-02-25T09:34:37Zchristopher—perkins12/20/80UHC-86844-01null—N/A262 Ridge Rd··AtlantaGA30392N/A·N/A
TPATPA-561112026-09-04T22:15:32Zcarol—crawford9/14/1980UHC-16231-67•••-••-2881NULLN/ANULLNULL····—-MEDICARE-ADV-B··
TPATPA-637152026-02-23T14:37:39Zanthony—gibson1963-06-08nullnull570-464-3442anthony.gibson@outlook.com2139 Forest AvenueMinneapolisMN55428GRP-8061··UNKNOWN
TPATPA-503812026-10-02T12:33:41ZMedina, Sandra——·2010-19-49—UNKNOWN··367.833.6241UNKNOWN2837 Willow CourtLas VegasNV89158nullUNKNOWN
TPATPA-561672026-06-25T08:28:48Z Kenneth—Gibbson05/01/1983NULL-3448820472null9424 Central AveSan AntonioTX78266GRP-5324—
TPATPA-555912026-07-25T23:14:54ZRomero, Jacob—····19541010NULL•••-••-3994nulljacob.romero47@icloud.com7038 APACHE BLVDNashvilleTN37209·-medicare-adv-a
TPATPA-603732026-10-06T06:40:32ZBrittany—Schmidt1942-06-10UHC-24552-67———7006 Elm StreetGlendaleAZ85381GRP-7978—
TPATPA-598312026-06-02T07:48:53ZBetty····Rilley2003-08-15—•••-••-3576N/ABETTY.RILEY13@YAHOO.COM9568 GRAND AVENUESacramentoCA95862GRP-4654OPTIONS-PPO··
TPATPA-598392026-01-27T10:48:13Zisabella—lopez1960-01-05nullUNKNOWNN/A-·NULLN/AN/A——CHOICE-PLUS-PPO
TPATPA-619222026-05-19T12:19:43ZEvelynPBakker1944-08-11UNKNOWN•••-••-1314-EVELYN.BAKER57@HOTMAIL.COM2191 Desert Sky Boulevard #394·Eden PrairieMN55302··—··
TPATPA-519722026-02-05T07:45:41ZRichard—Campbell1995-06-22—nullnullrichard.campbell@proton.me9162 Valley View Drive·MiamiFL33159GRP-9436NAVIGATE-HMO
TPATPA-547222026-01-07T19:07:20ZHelen—Willis1993-04-11NULLNULL4287838490—·8613 Meadow LnATLANTAGA30394GRP-5854—
TPATPA-558132026-09-13T10:34:11Z Hawkins, Noah——1976-10-12NULL—470-377-7460NOAH.HAWKINS@PROTON.ME3221 UNION STSan AntonioTX78286-5932null—
TPATPA-63434 2026-01-21T01:27:25ZDianeVCastillo·Jun 8, 1968nullNULL··nullN/A8444 Camelback RdMiamiFL33141N/Anull
TPATPA-580472026-03-09T21:17:31ZTerry—Medina1965-02-08——5184330047—nullN/AUNKNOWN——UNKNOWN
TPATPA-583632026-01-25T21:39:58ZAlice—Sims1996-12-15null-666-427-6654UNKNOWN3652 Washington StreetDALLAS··TX75282GRP-0626-
TPATPA-595642026-07-24T00:40:33ZAHMED—LYNCH04/21/88·-N/A—null—NULLN/A——null
TPATPA-639972026-10-06T03:55:13ZGABRIEL—GILBERT1987-01-10··—•••-••-1210(691) 319-9613NULL9797 RIVER ROADTucsonAZ85723-0988··—·MEDICARE-ADV-B
TPATPA-551612026-07-21T21:53:37ZWeiR.Robinson07/06/1985—•••-••-17392025315396-·5506 Desert Sky BlvdLos AngelesCA90005··GRP-2994—
TPATPA-530622026-03-26T14:10:34ZSARAH—WARREN1958-09-27N/A—-—9367 CHURCH STREETSeattle·WA-—MEDICARE-ADV-B
TPATPA-538012026-03-31T08:16:35ZRalph—Gonzalez1942-03-16UNKNOWN———6584 BAYSHORE DRDallastx75218GRP-1497—
TPATPA-61061 2026-01-12T13:09:00Zjoseph··day1967-04-14—null+1 558 379 9198N/A8532 Palm DrLos AngelesCA90076GRP-0629UNKNOWN
TPATPA-616922026-06-13T14:13:14ZDixon, Rebecca——04/13/1938——·nullNULL8865 Maple AvenueEden PrairieMN55387UNKNOWN·NAVIGATE-HMO
TPATPA-515542026-09-22T02:41:26Zdennis—powell··Jul 24, 1977-•••-••-9745931.625.0254··-8141 MAIN STREETTUCSONAZ85765-7827N/AN/A
TPATPA-543152026-10-03T09:17:55ZVINCENT—BAILEY1979-04-26NULLnull—VINCENT.BAILEY@ICLOUD.COM558 Cedar LnLos AngelesCA90027-NULL
TPATPA-583212026-07-05T01:02:08ZBOBBYWRODRIGUEZ1940-03-22····nullUNKNOWN—9029 Main StAustinTX78743—core-hmo
TPATPA-588632026-01-12T10:43:48ZZacharyTMarshall2001-11-21-NULLNULLN/A7657 Lake View RoadAtlantaGA30340null-
TPATPA-537232026-03-23T00:33:19ZAlice—SalazarFeb 23, 2002NULL—·2086741031—7779 Maple AveMesaAZ85223GRP-8964MEDICARE-ADV-B
TPATPA-509342026-04-08T05:44:10ZGary—Munoz1965-10-25—•••-••-81797376018815gary.munoz11@yahoo.com8538 Ocean AvenueNashvilleTN37225GRP-2093UNKNOWN
TPATPA-611632026-08-26T16:03:35ZPHILIP—BAILEY02/08/2006UHC-50588-65—nullNULL4686 Ocean AveMiamiFL33118UNKNOWNnull
TPATPA-576142026-09-30T17:11:52Z·Charlotte—Gibson07/04/48UNKNOWN•••-••-3034null—7647 Baseline Road··GLENDALEAZ85302N/A··N/A
TPATPA-618062026-05-01T15:52:05Z Amy····Aguilar9/13/1975UHC3797820··N/A376-758-9728NULL··6164 SAGE CTColumbusOH43208-OPTIONS-PPO
TPATPA-586082026-01-13T22:52:41ZJack—Vazquez2006-09-18——+1 723 743 7229jack.vazquez@hotmail.com7549 BroadwaySan AntonioTX·UNKNOWNGRP-2673—
TPATPA-51785 2026-08-01T15:09:14ZNACNY—PALMER12/11/75——-UNKNOWN4573 ELM STREETDallasTX75273nullSELECT-EPO
TPATPA-529572026-08-07T03:38:51ZMADISON—HAMILTON1990-02-09-•••-••-6211221.790.2733madison.hamilton@gmail.com——NULL-UNKNOWN—
TPATPA-527132026-10-16T06:19:45ZJUDITH—RIVERA1953-09-08NULL——JUDITH.RIVERA95@OUTLOOK.COM7771 Lake View RoadNashvilleTN37239-—
TPATPA-508532026-05-25T04:18:52ZBrrittany··Warren2008-09-09UHC-22159-07•••-••-3782——4501 PARK PLAustinTX··78721UNKNOWNN/A
TPATPA-540962026-08-28T08:13:32ZJAMES··HUNTER1991-12-20—•••-••-1161(970) 878-8232-1586 Grand AvenueTucsonAZ85774-3653-UNKNOWN
TPATPA-539552026-05-11T11:00:05ZDavid··Cole1986-07-26null•••-••-3908(762) 320-4614——null——GRP-5761—
TPATPA-596162026-06-21T01:05:33ZMelissaE.Kennedy·11/3/1998—NULL(464) 340-5080—·7833 PARK PLFresnoCA93785—CORE-HMO
TPA TPA-552782026-05-11T08:48:53ZBRIAN—HOFFMAN··1965-06-22-····UNKNOWN—3389 Baseline RoadGilbertAZ85245··NULL··—
TPATPA-582402026-04-05T02:40:54ZBilly—Weaver·1953-05-24—null16538022577—1760 Pine Dr Apt 32SacramentoCA95874—CORE-HMO
TPATPA-513102026-07-10T20:30:14ZAlbert··Lawson2001-01-12—•••-••-4722N/A—7179 RIVER RD·Denverco80213GRP-2912—
TPATPA-551632026-01-03T23:44:14ZAlexander—Bradley9/17/1945-•••-••-342819398779006—4988 Mountain View DrDenver·CO80288NULL—
TPATPA-609532026-04-25T19:17:32ZElizabeth—Meyr1961-06-14-•••-••-3854-—6250 Grand AveSCOTTSDALEAZ85278UNKNOWNN/A
TPATPA-602252026-06-18T22:53:24ZVargas, Denise—··1949-10-23—•••-••-6609(614) 673-0135UNKNOWN····N/A—·NULL—SELECT-EPO··
14,474 rows, page 248 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.254Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty