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-598382026-09-11T05:21:13ZJackFGarza10/12/1966uhc-71666-67•••-••-1935(551) 242-4663UNKNOWN363 BAYSHORE DR Apt 18Las VegasNV89178GRP-1187—
TPATPA-507242026-05-28T10:09:34Z DANIELLE—HUDSON1991-12-07—•••-••-5083N/A··-9173 Church StSan AntonioTX78269GRP-3550CHOICE-PLUS-PPO
TPA TPA-547152026-05-30T12:11:03ZAshleyNHayyes03/20/70··—null484-280-2916-2850 VALLEY VIEW DRIVEChandlerAZ85230GRP-6002—
TPATPA-505182026-07-31T23:31:33ZLarry—Nguyen1981-11-20··UHC-47290-57•••-••-7097NULLLARRY.NGUYEN@GMAIL.COM7694 Jefferson Ave···Orlando·FL32879—null
TPATPA-519882026-06-11T17:39:53ZBrenda—Warren1960-08-12null•••-••-0826nullbrenda.warren1@aol.com331 Harbor BlvdGLENDALEAZ85398GRP-0427OPTIONS-PPO
TPATPA-511822026-05-28T08:53:53ZTHOMAS—SOTO19070301UHC-25252-21UNKNOWNNULL-3604 Spring St Apt 14TempeAZ85201GRP-5141SELECT-EPO
TPATPA-608332026-06-29T09:10:35ZHoffman, Carlos—··1963-08-01—NULLNULLcarlos.hoffman85@gmail.com559 MESA DRIVE #836AustinTexasnullUNKNOWN—
TPA TPA-516702026-06-11T19:40:06Zyuki—chavez1950-05-21UHC-73006-24nullN/A—4998 Camelback RoadColumbusOH43233——
TPATPA-581642026-05-31T18:56:47ZGuerrero, Lucia··——1979-04-01UHC-85694-87•••-••-97994469197984UNKNOWN8907 Mountain View DrGlendaleAZ85379N/AMEDICARE-ADV-A
TPATPA-53256 2026-02-01T14:05:45ZEmma—West2000-10-12NULLN/A4016245574—4639 HIGHLAND AVENUEColumbusOH43220—null
TPATPA-599142026-05-05T01:48:49Z ryan—harrison19581116—·NULL(570) 361-2668—2325 Washington StATLANTAGeorgia30353--
TPATPA-536182026-07-03T22:00:14ZBradley—·Kim1945-07-19—•••-••-0312+1 488 761 6975null———null—·medicare-adv-b
TPATPA-524922026-02-22T16:58:49ZBRENDA—·MARQUEZ19740324—NULL(707) 990-7062-5518 GRAND AVELAS VEGASNV——-
TPATPA-516132026-06-09T12:14:41Zdiego—george20000614—•••-••-1696null·-4258 SAGE CTMinneapolisMN55424N/AN/A
TPATPA-558602026-04-11T19:49:19ZISABELLA—STEWART1995-11-01—NULL+1 915 976 8851—·9036 Mesa DriveCharlotteNC28239—CORE-HMO
TPATPA-584802026-09-14T16:08:01ZGerald—·Banks1998-10-17—•••-••-3011(651) 366-5118gerald.banks84@hotmail.com1424 Desert Sky BoulevardMesaaz85258GRP-8668—
TPATPA-550602026-05-16T19:58:59ZAlice—Foster5/9/1955UHC-43864-94UNKNOWNN/A—UNKNOWNnullUNKNOWN—N/A—
TPATPA-526152026-09-04T06:20:13ZDorothy—Wagner19530805N/A-·242.497.5538UNKNOWN4345 Market StreetColumbusOH43207GRP-0279MEDICARE-ADV-A
TPATPA-520512026-09-21T11:04:44ZAhmed—Vega2002-10-16null··—(393) 220-6753————N/A—N/A··
TPATPA-507192026-10-11T08:14:10Zlauren—parker10/21/86··-—+1 849 510 8221lauren.parker86@outlook.com4890 OCEAN AVESan AntonioTX··78243GRP-6568—
TPATPA-53398 2026-10-07T03:47:55Z·Peter—Ortiz1975-01-03N/ANULL943.505.9428-·5318 Park PlMinneapolisMN55465-NAVIGATE-HMO
TPATPA-501852026-03-01T02:47:51ZThomas, Ashley——·12-01-1966NULL-312-616-7284-·UNKNOWN—NULLNULLNULLnull
TPATPA-638672026-04-16T05:31:35Zjarry—roberts2005-11-21UHC1989259-15198862869·null8059 Valley View DrScottsdaleAZ85272UNKNOWNOPTIONS-PPO
TPATPA-640502026-01-30T15:02:30Z Peter—Alexander···1961-05-20UHC9510459—3987697238peter.alexander@yahoo.com6695 Market StOrlandoFL···32821—MEDICARE-ADV-A
TPATPA-639542026-08-10T22:33:43ZASHLEY—CARPENTER··15-01-1967N/A—905-600-9029ashley.carpenter@hotmail.com3832 Ocean AveDENVERCO80255N/A—
TPATPA-515722026-01-18T00:52:56ZANNA—FORD2007-09-16N/A-UNKNOWNN/A—N/A——N/Anull
TPATPA-570462026-04-10T11:24:38ZSERAH—SINGH1940-12-15——4785488691sarah.singh32@proton.me220 BROADWAY Apt 20JacksonvilleFL32214UNKNOWN—
TPATPA-623112026-02-28T15:57:33ZSusanUPerezJan 6, 1958UHC-40795-98null·N/A·-N/A—-··—GRP-6452SELECT-EPO
TPA TPA-642482026-08-31T10:26:30ZMills, Denise——3/24/1982UNKNOWNnullnulldenise.mills@yahoo.comUNKNOWN-NULLUNKNOWNN/AN/A
TPATPA-512392026-07-08T04:49:59ZTucker, Randy—····1975-05-03-•••-••-74752662625·randy.tucker@gmail.com8420 CENTRAL AVEJacksonvilleFlorida32248N/A—
TPATPA-544492026-10-11T19:32:41ZBrooks, Alxis——1966-03-25N/AN/AN/AALEXIS.BROOKS@OUTLOOK.COM741 Ridge RdSan AntonioTexas78284GRP-1624—
TPATPA-505882026-04-06T22:55:39ZZachary—RdoriguezOct 9, 1941UHC-03456-11N/A(573) 649-0451zachary.rodriguez28@hotmail.com7339 Jefferson Ave #523·LOS ANGELESCA90091GRP-6116CHOICE-PLUS-PPO
TPATPA-590592026-08-19T18:53:41Z ANN—JONES1966-09-24UNKNOWNN/AN/A—6076 Elm StSan AntonioTX78268GRP-6763—
TPATPA-512332026-07-24T15:36:54ZSANTIAGO—SCHMIDT1970-67-27—•••-••-1064(467) 475-6185santiago.schmidt@hotmail.com5291 Forest Ave··JacksonvilleFL32271—UNKNOWN
TPATPA-529072026-06-11T17:40:44ZDonald—Herrera22-10-1997null—257-452-9558—9786 Central Avenue #996MINNEAPOLISMN55448-—
TPATPA-521482026-07-09T00:31:31Zcerlos—lawrence1949-08-04—UNKNOWN+1 388 490 0900····9012 Mesa Dr #931PlanoTX75035——
TPATPA-561382026-08-11T16:07:51ZMARTHA—BOYD1982-10-10-UNKNOWN-UNKNOWN1811 Spring StreetLas VegasNV89108GRP-1368NULL
TPATPA-608002026-01-03T00:17:59ZNicholas—Burns··1982-06-07UNKNOWN—nullN/A··2447 Grand AveEden PrairieMinnesota55368··NULL··CHOICE-PLUS-PPO
TPATPA-637082026-02-01T17:51:57ZBenjamin—Jones··02/11/1989NULL·-793-647-7754N/A5630 BASELINE ROAD·Plano·Texas75019N/Anull
TPATPA-581352026-10-08T17:24:30Z TriciaPBennett··1940-07-21——UNKNOWNNULL8570 Valley View DriveSan DiegoCA92131-·N/A
TPATPA-538062026-02-03T22:03:17ZGrace—Padilla27-02-1956—-917.954.1768—·9820 JEFFERSON AVENUEDallasTX75266N/A—
TPATPA-617062026-07-11T03:32:04ZThomas—Sims03/19/71-—UNKNOWNnull4750 Grand Avenue Apt 26OrlandoFL32898——
TPATPA-570212026-08-29T00:27:23Zray—thomas··1966-03-27null•••-••-24878274614635raymond.thomas54@gmail.com7605 Harbor BoulevardPhoenixAZ85007GRP-4847-
TPATPA-593782026-05-28T12:55:49ZBenjamin—Andrews2006-02-22————6766 Ocean AveMesaAZ85232null··UNKNOWN
TPATPA-634222026-02-12T02:41:03ZBRANDON—STEVENS··1949-02-14-N/A2057573510UNKNOWNNULLN/A——N/AUNKNOWN
TPA TPA-585592026-03-06T03:37:17ZJeffrey—Wells03/12/92nullnull——6803 Apache BlvdSan Antoniotx··NULLUNKNOWN
TPATPA-636432026-05-05T01:25:45ZMichelleFHenry1947-05-10··—•••-••-3940(404) 309-8227null7331 GRAND AVENUEChandlerAZ85216-5830GRP-7107—
TPATPA-50298 2026-04-28T06:26:23ZFRANCES—DOMINGUEZ1956-08-15—N/A—NULL7201 MOUNTAIN VIEW DR·MINNEAPOLISMinnesota55484—NULL··
TPATPA-546302026-10-17T06:28:31ZMarilynIPatterson01/05/1997nullUNKNOWNN/AUNKNOWN9305 MEADOW LANEOrlandoFL32888GRP-5805NULL
TPATPA-624732026-05-30T18:05:34Zroy—vargas1985-08-04·UHC-67291-40-NULLN/A4832 Canyon RoadLOS ANGELESCA90037GRP-6016N/A
14,474 rows, page 167 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:52.220Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty