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-592812026-05-06T13:47:28ZNoah—Cuoper··2007-08-28null•••-••-3615—NULL3408 Grand AvenueTempeArizona85254-6656—CORE-HMO
TPATPA-600192026-07-04T12:16:28ZJonathan—Johnston1977-03-04N/A•••-••-8747NULL—3559 MEADOW LNOrlando··FL32833NULLnull
TPATPA-515842026-08-27T09:31:11Z EVELYN—·RAY10/09/1941—•••-••-403812313290812—1967 Camelback RoadEDEN PRAIRIEmn55330-3946—-
TPATPA-618642026-09-12T17:37:28ZKathryn—Thompson1988-02-25—-3849909239··NULL9214 FOREST AVENUEMinneapolisMN55416—N/A··
TPATPA-526732026-05-08T23:58:37Z andrea—woood2008-06-21N/A-·UNKNOWN-2241 Desert Sky BoulevardMinneapolisMN55405—N/A
TPATPA-540442026-09-21T09:43:29ZJose—Campbell1993-11-18null•••-••-84906243263156jose.campbell96@aol.com8087 Market StTEMPEAZ85238GRP-7511NAVIGATE-HMO
TPATPA-519872026-04-07T01:33:05ZJOSE··MCDONALD07/13/1986—•••-••-05439897721—7713 Lincoln WayAUSTIN·TX78709-8060UNKNOWNnull
TPATPA-507512026-04-15T08:36:17ZSAMANTHANHUGHES6/15/2003—-6099989792SAMANTHA.HUGHES91@YAHOO.COM·3646 Meadow LaneGilbertAZ85293NULLMEDICARE-ADV-A
TPATPA-567232026-09-18T17:09:36ZDanielle—·Sims1961-10-28UNKNOWN——UNKNOWN3165 Willow CtTampaFL33607GRP-8145CHOICE-PLUS-PPO
TPATPA-634452026-02-09T05:21:48ZJUANM.MUNOZ1945-07-17····UNKNOWNNULL—··NULLN/A—UNKNOWN····
TPATPA-563312026-09-28T07:01:19ZBilly—Parkeer1967-06-08NULL—-—6710 Maple AvenueMesaAZ85220——
TPATPA-563082026-10-11T19:38:12Z·MEGAN—ANDREWS1974-07-14——437.710.3717-·9086 PALM DRColumbusOH43274-7541GRP-8106-
TPATPA-593722026-09-15T20:02:10ZDiana—LaneSep 25, 1990—null—··3391 Indian School RdMESAArizona85265—-
TPATPA-602362026-09-03T06:00:04ZKimberly—Davis2006-07-09NULL•••-••-0129—kimberly.davis@hotmail.comUNKNOWNUNKNOWNNULL—GRP-0723UNKNOWN
TPATPA-523292026-10-17T22:58:29ZJULIAD.SIIMMONS1964-04-28—•••-••-4323—UNKNOWN1215 Washington StPhoenixaz85070—UNKNOWN
TPATPA-580562026-07-25T21:28:15Zbilly—ryan1941-06-01null•••-••-0949NULL—9764 UNION STScottsdaleAZ·85241GRP-1639—
TPATPA-503492026-01-06T20:57:42ZMICHAEL—BUTLER2004-03-21NULL•••-••-7335·NULLN/A3099 Mesa DrSan DiegoCA92145nullMEDICARE-ADV-A
TPATPA-545692026-01-28T06:09:12ZBRAIN—ALLEN07/14/1978··UHC-23222-19•••-••-0075—·brian.allen@icloud.com·5898 WASHINGTON STREETGlendaleAZ85348N/A—
TPATPA-590112026-07-21T13:40:58ZFatima··—Scott1942-06-24UNKNOWNnull15987958688—7415 LAKE VIEW RDPlano··TX75091-9665-—
TPATPA-611852026-02-22T03:25:20ZSAMANTHA—VALDEZ19730402UHC-63204-93NULL18598316933—7008 Washington StDenverCO80273N/A—
TPATPA-62923 2026-04-01T22:47:39Zjohn—moore11-04-1996N/Anull407.206.1847NULL3523 Market StreetSacramentoCA95863-null
TPATPA-539042026-09-05T10:33:15ZMarcus—Gutierrez1963-04-16NULL—295-624-2373NULL··7640 Harbor BoulevardGLENDALEAZ85361N/Anull
TPATPA-633362026-07-07T19:10:36Z·Gary—Ryan·8/20/1965-•••-••-2405—UNKNOWN3177 Canyon RdTucsonAZ85783—NULL
TPATPA-534152026-06-17T03:47:21ZKARENY.·DEANnull-•••-••-7848—·-8850 Ocean AveDENVERCO80204-8074NULLcore-hmo
TPATPA-607192026-02-27T06:50:54ZDominguez, Diane——1946-08-06——(978) 985-8984UNKNOWN9605 Union StSacramentoCA95862N/AN/A
TPATPA-593572026-08-15T00:18:19Zelizabeth—·santiago1974-02-24UHC-79914-44——elizabeth.santiago@aol.com1713 Ridge Road #159MESAAZ85274-6643UNKNOWN-
TPATPA-615542026-05-08T14:05:46ZKAYLA······YAANG06/07/1952UHC-08889-57··•••-••-7309529-509-5466··null7845 Palm DriveFresnoCA93723GRP-6014OPTIONS-PPO
TPATPA-640862026-07-04T17:47:16ZETHAN—GUTIERREZ1991-09-27null•••-••-3014—N/A6400 Pine DrFRESNOCA93757—N/A
TPATPA-619022026-07-27T00:00:29ZJAMES—GARDNER1993-12-01null—NULLjames.gardner@aol.com4528 Desert Sky BoulevardNashvilleTNUNKNOWNN/A—
TPATPA-504502026-02-22T13:14:31ZBOBBYO.GARCIA·1940-10-09·-•••-••-7774(376) 793-3181—3222 Valley View DriveMINNEAPOLISMNnullN/Anull
TPATPA-587362026-08-16T06:58:37ZLinda—Martin09/27/2006NULL—(466) 723-9904UNKNOWN1063 Union StDallasTX75262··-MEDICARE-ADV-B
TPATPA-545302026-06-30T10:18:12Zjanice····dunn04/18/53UNKNOWN··•••-••-3706—janice.dunn@proton.me3591 OAK STREET #418DENVERCO80249-5263nullNAVIGATE-HMO
TPATPA-617342026-08-03T16:57:00ZRUSSELL—JENKINS02/11/1965—•••-••-8674-·N/A7939 Park PlTEMPEAZ85257-5865GRP-3292UNKNOWN
TPATPA-593682026-02-07T12:34:52Zamy·····hamilton19571114UNKNOWN—748.817.8584·UNKNOWN6489 RIVER RDGilbertAZ85229-1108-CORE-HMO
TPATPA-619732026-02-01T03:03:28Z Joyce—Howard05/03/1978null•••-••-0352+1 223 548 1783-6070 MAPLE AVEGLENDALEaz85302··MEDICARE-ADV-A
TPA TPA-506222026-05-03T17:03:33ZJordan, Bobby··——·1994-07-21—NULLNULL··NULL·7850 Market StreetCharlotteNC··GRP-6937OPTIONS-PPO
TPATPA-550282026-06-23T22:01:56ZStevens, Randy——1988-10-24N/A•••-••-6113NULLrandy.stevens59@proton.me7288 Jefferson AveLos AngelesCA90071nullOPTIONS-PPO
TPATPA-605062026-07-03T23:36:37ZAnna··—Carpenter1976-07-20NULLnull2977720124—7255 Ridge RdPHOENIXAZ85098——
TPATPA-599752026-08-18T10:35:30ZHill, Dennis——1956-09-17···---null1492 Ridge RdHoustonTX77057NULLCHOICE-PLUS-PPO
TPATPA-504072026-01-20T05:56:09Zkayla—shaw1986-11-15UHC-04156-50NULL—null—····—N/AGRP-4398—
TPATPA-630082026-10-08T13:19:50ZBrandon—Salazar1984-01-01—N/A—NULLnull—-UNKNOWNN/AMEDICARE-ADV-A
TPATPA-608832026-03-20T03:14:22ZJOYCE—SANCHEZ1966-10-24-··—UNKNOWN—2620 MARKET ST #661Las VegasNV89104·GRP-1779-
TPATPA-541472026-05-31T05:40:22Zstephanie—nichols1973-03-28—•••-••-1551—STEPHANIE.NICHOLS14@ICLOUD.COM6263 Ocean AvenueGILBERTAZ85252GRP-6122-
TPATPA-544452026-04-13T15:15:04ZWilliaam—Contreras··2002-04-08—•••-••-4890—william.contreras@proton.me-null··—UNKNOWNnullUNKNOWN
TPATPA-63878 2026-06-30T07:23:47ZVictoria··—Clark1992-04-16—N/AUNKNOWN—5078 Forest AvenueMesaAZ85297—SELECT-EPO
TPATPA-587982026-08-31T03:21:26ZMATEO··—HANSENJan 23, 1997UHC-39094-52N/A(545) 338-7079—1668 Jefferson AvenueChandlerAZ85243GRP-9170NULL
TPATPA-618392026-08-26T09:47:29ZScott—LeJun 5, 1960UHC-13697-19N/AN/ANULL586 Canyon RoadGilbertAZ85216UNKNOWNmedicare-adv-b
TPATPA-579472026-01-17T14:33:08ZDOUGLAS····GONZALES1991-07-21UHC-51488-52•••-••-7459null·douglas.gonzales@icloud.com3021 Main Street·PlanoTX75026NULLSELECT-EPO
TPATPA-574232026-09-12T22:44:33ZAnna—Lee1960-02-06····—(918) 296-9182-911 OCEAN AVENUENashvilleTN37287GRP-5796NULL
TPATPA-574552026-03-17T08:13:53ZMICHELLE—ANDERWS1994-08-24——····NULL6315 Highland AveORLANDOFL··32874·NULLCORE-HMO
14,474 rows, page 219 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.168Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty