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-642822026-04-12T18:03:13ZRoy··—James08/14/67—null(208) 317-1681—————N/A·null
TPATPA-559792026-05-17T20:17:10ZSTEVENG·CARR12/4/1967····--····3232 Willow CtHoustonTX·77057UNKNOWNUNKNOWN
TPATPA-561912026-08-01T18:33:25ZHaroldIAllen1982-05-24UHC-32188-32•••-••-317717466087016—4801 MOUNTAIN VIEW DRAtlantaGA··30350——
TPATPA-61801 2026-10-06T14:10:22ZMateo—Lee2/24/1944··————9241 Baseline RdSeattleWA98157NULLnull
TPATPA-582032026-09-02T09:31:20ZGloria—Bery08/04/2008UNKNOWN•••-••-6776+1 764 449 9555—5979 Sage CtMesaAZ85216-5076GRP-4121N/A
TPATPA-580742026-07-12T01:12:15ZWard, Denise——7/6/1959NULL•••-••-03999694374772denise.ward17@yahoo.com8358 Lake View RdMiamiFL33113GRP-0105NULL
TPATPA-566842026-10-18T20:49:37ZTerryZDiaz2005-09-08UNKNOWNUNKNOWN-—1888 LINCOLN WAYSan DiegoCA92166-5834-—
TPATPA-514052026-04-09T13:00:29ZKayla—Ferguson2005-06-19null·N/A653-495-7506NULL3533 Grand AveLAS VEGASNV··89118UNKNOWNUNKNOWN
TPATPA-611772026-08-01T14:07:53Z·Arthur—Carter1953-09-20-•••-••-3017—ARTHUR.CARTER@YAHOO.COM7582 Washington StreetChandlerAZ85272N/Anull
TPATPA-624972026-05-16T05:19:33ZANA—ADAMS1944-07-09N/A····9096894—9369 Ocean AvePhoenixAZ85085—NAVIGATE-HMO
TPATPA-585642026-09-02T13:29:21ZCHARLOTTE—VASQUEZ1989-12-02UHC-33932-81—N/AN/A6142 CEDAR LANEJacksonville·Florida32226-3684—null
TPATPA-551222026-02-09T15:14:51ZKimberly—Webb2001-10-11N/A··UNKNOWN·N/AKIMBERLY.WEBB67@YAHOO.COM1437 Grand AvenueNashvilleTN37292GRP-9621—
TPATPA-638712026-07-04T02:41:46ZJosh—Crawford1966-05-13N/A•••-••-6109(865) 501-4135—7519 Elm StreetDenverCO-GRP-2079·N/A
TPATPA-593482026-07-11T20:36:17ZMelissa—Ortiiz1987-02-24UNKNOWN··16598508939—3048 Forest Ave #967SCOTTSDALEAZ85216GRP-0468NAVIGATE-HMO
TPATPA-630532026-05-21T05:51:28ZCarol—Shaw2002-10-06··UNKNOWN—5447173992UNKNOWN1968 Willow CourtOrlando·FL32826——
TPATPA-604112026-02-18T21:46:00ZEugene—Morales1976-03-11——555-993-4176N/A7390 Bayshore DriveAustinTX78766UNKNOWN—
TPATPA-55618 2026-04-03T03:28:40ZChristina—Herrera·19504919N/A•••-••-4872—UNKNOWN6995 Pine DrivePlanoTX75052·GRP-3765N/A
TPATPA-570082026-08-09T23:45:10Zaaron—hoffman2008-10-12UHC-55595-67UNKNOWNNULLaaron.hoffman@outlook.com9350 Market St Apt 20TUCSON·AZ85758-—
TPA TPA-556822026-01-13T19:46:07ZLUCIA—LITTLEJan 4, 2008—null9542185645UNKNOWN5507 Mesa DrMiamiFL33115··UNKNOWN—
TPATPA-58620 2026-02-20T05:24:38ZNick—Bailey1999-12-18·nullNULL6383214UNKNOWN—N/ANULL—GRP-5338—
TPATPA-620392026-06-10T03:34:20ZJohn··—·Freeman1946-07-23nullUNKNOWN—-2736 Lake View RoadSAN ANTONIOTX78294—UNKNOWN
TPATPA-533812026-02-22T08:57:36ZROGER—GEORGE·1983-01-10UNKNOWNNULL—UNKNOWN1902 WASHINGTON STAtlantaGA30362-CORE-HMO
TPATPA-502202026-06-23T02:45:31ZBobby—Rios1977-09-18—•••-••-8764-NULL6800 Mesa Dr Apt 10San Antonio·TX78216N/AUNKNOWN
TPATPA-509192026-01-28T05:33:36ZBenjamin—CruzJun 5, 2007—null-null3939 Pine DriveJacksonvilleFL32265GRP-4423OPTIONS-PPO
TPATPA-600622026-02-27T17:08:42ZWILLIAM····REYES1940-08-06····UNKNOWN231-436-9033william.reyes@yahoo.com6141 Union Street·JacksonvilleFL32256—NULL
TPATPA-63940 2026-06-04T11:44:14Z·Emma—RichardsonOct 14, 1980UHC-65412-76N/A(718) 820-4004null2907 SAGE COURTChandlerAZ85254-SELECT-EPO
TPATPA-530302026-03-14T08:23:06ZLAUREN—MOORE1988-05-28nullN/A-··UNKNOWN8085 SPRING STTempeAZ85217GRP-3429-
TPATPA-512932026-08-24T02:26:21ZBetsy—Allen1941-02-01··NULLUNKNOWN-N/A6838 WASHINGTON ST··MiamiFL33105GRP-6911N/A
TPATPA-560122026-02-18T20:54:00Zvirginia··roberts19920118—•••-••-8045526.974.8664·null1146 Sunset BoulevardLos AngelesCA90079GRP-3358CORE-HMO
TPATPA-570652026-04-03T16:48:58ZVargas, Albert——1995-09-27—•••-••-5242····albert.vargas93@outlook.com113 Willow CtMinneapolisMN55444-CORE-HMO
TPATPA-552292026-07-28T12:36:50Zaisha—kelley··1946-11-03N/A•••-••-94902508349··—5803 SPRING STLas VegasNV89131-—
TPATPA-637222026-06-01T09:54:44Zemma—willis1983-08-20·NULL•••-••-066419309912109—·2116 Pine DriveLos AngelesCA90054—null
TPA TPA-631212026-07-24T04:49:49ZROBERT—BROOKS02/24/1999UNKNOWN•••-••-6367(580) 559-5575robert.brooks33@hotmail.com5314 PALM DRIVEFresnoCA··N/ACHOICE-PLUS-PPO
TPATPA-506332026-03-10T10:18:37ZAisha—Allen19381020—·UNKNOWN—····6490 BASELINE ROADMINNEAPOLISMN55470--
TPATPA-522022026-02-22T04:19:27ZpaulUgarza1981-06-15NULL•••-••-4166—paul.garza@outlook.com1297 CENTRAL AVESan Antoniotx78286N/ASELECT-EPO
TPATPA-506502026-05-02T13:44:17ZRussell, Kimberly——05/06/1995—NULL····NULL454 Jefferson AvenueTempeAZ—GRP-1749—
TPATPA-583372026-09-24T05:01:56Z·SOPHIA—HILL1996-03-13··—UNKNOWNN/A··null—NULL——nullnull
TPATPA-551782026-06-17T16:16:32ZAshley—Perry1987-02-07nullnull-UNKNOWN3205 RIDGE RDAtlantaGA··30359—-
TPATPA-626052026-09-07T10:47:45Z·JORDAN—MOORE03/02/1991UNKNOWN··8302500727····8323 Union StTampaFL33690-1480GRP-0721null
TPATPA-507232026-02-01T18:11:20ZMARTHA··—HARRISON03/26/80N/A—NULLUNKNOWN7138 LINCOLN WAYDenverColorado80288NULLSELECT-EPO
TPATPA-513212026-06-06T05:30:12ZFATIMA—RYAN8/24/1959—•••-••-6038N/AN/A9612 Ridge Road··AUSTINTX78767—CORE-HMO
TPATPA-569032026-10-03T21:24:26ZPAMELA—LUCAS1941-05-22null—N/A·pamela.lucas22@icloud.com—NULL····—NULLNULL
TPATPA-511872026-02-23T13:37:19Zlucia—bryant1975-06-09null··UNKNOWNnull7161 Canyon RoadHoustonTXNULL-—
TPA TPA-618612026-01-04T10:55:01ZCarl—Dominguez9167-05-10UHC-67933-51NULL—carl.dominguez72@aol.com1514 Baseline Rd #279GilbertAZ85224-6866GRP-7245UNKNOWN
TPATPA-503702026-01-16T12:53:53ZBrittanyXEstrada12-02-1967—null—BRITTANY.ESTRADA74@AOL.COM908 FOREST AVENUETucsonArizona85701GRP-3927OPTIONS-PPO
TPATPA-513642026-08-28T12:05:11ZTIMOTHY—ARNOLD··9/15/1943UNKNOWNNULL—N/A-UNKNOWNUNKNOWNNULLNULLNAVIGATE-HMO
TPATPA-562172026-03-09T11:23:00ZEvelyn··NguyenUNKNOWN······•••-••-7584206-735-8821NULL5532 UNION STREET Apt 14TucsonAZ85739-1740NULLCORE-HMO
TPATPA-554552026-03-27T02:19:45ZAmanda—Powell·1958-02-20UHC-15061-46NULL·324-403-2591—5353 MEADOW LNTempeAZ85251N/AN/A
TPATPA-628292026-01-02T07:31:48ZRuiz, Sharon——1996-02-26UHC-05868-02•••-••-0952(666) 885-6260null·2788 Washington StTampaFLUNKNOWN-NAVIGATE-HMO
TPATPA-548282026-10-03T13:28:02ZDAIVD··—KNIGHT12/18/81UNKNOWNN/A—UNKNOWN5178 Baseline Road Apt 32Planotx75012··NULLUNKNOWN
14,474 rows, page 191 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.147Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty