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-609492026-05-26T05:09:04ZCarolyn—·Adams2007-05-26--(929) 332-1132—6899 CHURCH STCOLUMBUSOH43297GRP-5632—
TPATPA-544752026-03-23T06:51:00ZEdards—Sarah1940-04-27—•••-••-4662236-977-6893-———N/A-—
TPATPA-541552026-08-23T09:31:55ZRoy—Crawford··1991-07-27UHC-84794-41—N/Aroy.crawford@yahoo.com6673 Oak St·SeattleWA98175-7453—OPTIONS-PPO
TPATPA-601992026-05-12T06:07:21ZSophia—·Evans1947-05-11N/A·null19036455418NULLUNKNOWNNULLNULLN/A—UNKNOWN
TPATPA-581532026-02-06T08:12:08ZValentina—Elliott4/9/1942UHC-96615-50•••-••-4582(725) 600-9301—UNKNOWN—nullNULLnullOPTIONS-PPO
TPATPA-613112026-08-07T16:38:59ZGreen, Luis——1964-04-24UHC-57723-18—575-265-8492null··873 INDIAN SCHOOL RDFresnoCA93783—select-epo
TPATPA-573292026-08-02T13:44:05ZMatthewXCruz1944-06-17··—-213-422-5293UNKNOWN7979 Pine DrEden PrairieMN55374——
TPATPA-587602026-03-19T04:52:12ZJesse—Li04/07/2002UNKNOWN•••-••-9803——9417 Desert Sky BoulevardSan DiegoCA92192—null
TPATPA-511982026-02-25T23:52:48ZMASON—MOORE1984-05-16N/A—(325) 675-4387mason.moore16@outlook.com7231 Indian School RdCHANDLERAZ85220—NULL
TPATPA-549182026-01-18T07:08:23ZDorothy—Spencer·1945-06-17-—(458) 736-3297—8053 Meadow LnAtlantaGA30333N/A—
TPATPA-548852026-06-23T05:50:49ZJoyceNPierce1945-02-01—•••-••-2258(914) 976-1760joyce.pierce@proton.me3413 SPRING STSCOTTSDALEAZ85262N/ACORE-HMO
TPATPA-521392026-10-08T11:29:43ZAnnaZLong——UNKNOWNN/A··anna.long@icloud.com9582 Jefferson AvenueOrlandoFL32833GRP-2261—
TPATPA-612972026-03-20T03:36:01ZMason····Morales1966-12-11null··2416145526—4948 River RdGILBERTAZ85249··-—
TPATPA-514772026-08-13T03:33:29ZLaura—Colilns2007-08-02·UNKNOWN—280-989-2058nullUNKNOWNN/A-—N/A··—
TPATPA-628752026-05-24T10:06:44Zdiego—li1992-02-05N/AnullUNKNOWN—181 Meadow LaneJacksonvilleFLnullnull-
TPATPA-523412026-08-19T01:18:18ZMEGAN—CHAVEZ2006-02-24UHC-30373-18•••-••-4987-··1613 Lincoln Way·Las VegasNV89112NULL—
TPATPA-581992026-06-05T19:44:25ZCharles—Armstrong09/13/1998null-516-492-2414null1851 Maple Ave #602SEATTLEWA98184GRP-1321CHOICE-PLUS-PPO
TPATPA-532002026-08-13T20:24:37ZScott—·Simmons1976-01-09N/ANULL··—scott.simmons43@yahoo.com2254 LAKE VIEW ROADMESAArizona85226—CORE-HMO
TPATPA-570812026-02-03T07:24:48ZKIMBERLYWKNIGHT1974-09-08—null885-634-6035—UNKNOWN··N/A——UNKNOWNUNKNOWN
TPATPA-604182026-09-20T10:55:32ZDAVID—LONG19660407UHC-02750-47—nullNULL———N/A··UNKNOWN—
TPATPA-542762026-08-29T03:19:17ZFrances····Graham1971-04-22—•••-••-7886464.519.3646frances.graham@gmail.com1867 Ocean AveNashvilleTN··37267nullCHOICE-PLUS-PPO
TPATPA-537772026-09-09T18:42:32ZSteven—Holmes02/13/1938—-608-986-3242··N/A6670 Washington StTempeAZ85245——
TPATPA-628792026-09-11T14:10:07ZMei—Griffin1994-03-17N/A—null··UNKNOWN9170 Union StTucsonAZ85775NULL—
TPATPA-634122026-10-09T18:43:18ZMICHAEL—WILSONOct 15, 1955—··2331710—2200 Hillcrest RoadDallastx75248-N/A
TPA TPA-577252026-03-03T02:08:39ZCarolyn—Carter1986-05-27UHC-89438-45——N/A9813 Sunset BoulevardSACRAMENTOCA95811nullNULL
TPATPA-635962026-01-26T16:16:07ZWayne····Spencr1999-12-01UNKNOWN—5534726839··9632 CHURCH STHOUSTONTXN/AUNKNOWNUNKNOWN
TPATPA-575182026-06-22T07:25:32ZJoseph—Stevens6/23/1941-•••-••-4205(986) 417-3783—·7994 Sage CtDenverCO80234N/AUNKNOWN
TPATPA-614832026-01-20T06:59:33Zpaul—murphy11/21/54null•••-••-7377······1988 Mesa DriveAtlantaGA30321GRP-0476··N/A
TPATPA-518022026-02-24T22:37:43ZRyan—Walsh1994-10-22—•••-••-25479449801731N/A7108 BroadwayColumbusOH43204null—
TPATPA-639602026-08-19T07:43:06ZBeverly—Schultz1981-07-09nullUNKNOWN——627 Highland AveDallastx75261NULLnull
TPATPA-547292026-06-19T00:25:07ZKathryn—LittleMar 5, 1995NULL•••-••-3045—null7695 PARK PLMiamiFL33129-6175—OPTIONS-PPO
TPATPA-562762026-02-12T10:21:17ZJeffrey—Payne19850298—•••-••-7528——1553 Palm DriveHouston··TX77090-6042GRP-3989N/A
TPATPA-599812026-08-28T16:02:49ZCharlotte—Matthews6/22/1971NULL··NULLNULL-··4334 Pine DrAtlantaGA30366··NULL-
TPATPA-521352026-02-05T15:39:00ZZachary··SSimpson1941-12-20N/A•••-••-7030—-4120 Lake View RoadMesa·AZ85243····-
TPA TPA-596732026-07-30T13:33:37ZAnrew—·Ryan11/04/1938UHC-80498-57•••-••-2774—UNKNOWN5629 Pine DriveHoustonTX·77089-NULL
TPATPA-614042026-09-10T17:58:14ZLucia—Edwards1957-07-22UNKNOWNNULL·-UNKNOWN8838 Forest AvePhoenixAZ85040-8821null··
TPATPA-569492026-03-26T23:40:18ZLAUREN····DAVIS1980-12-09·NULLUNKNOWN—lauren.davis37@hotmail.com3712 Main StColumbusOH43293·N/A—
TPATPA-630292026-05-12T16:51:55Z·Maartha—·CookJan 4, 1983-··+1 985 329 1648N/A948 Highland AvenuePLANOTX75019—null
TPATPA-630822026-01-04T03:30:13ZBENJAMIN—HUDSON03-11-1960—N/ANULL··—·5758 Mountain View Drive·TucsonAZ85762null-
TPATPA-508942026-09-07T15:15:14ZFrank—Marquez5/1/1977····—(758) 870-6498NULL9017 Hillcrest Road Apt 11COLUMBUSOH43278GRP-0823MEDICARE-ADV-A
TPATPA-519812026-05-07T16:39:15ZRichard··—Little1942-10-15····null3433858richard.little1@aol.com2180 Baseline Rd Apt 37·San AntonioTX78230GRP-6525—
TPATPA-568732026-09-19T02:20:02ZMason—Wong1991-01-03····•••-••-1097N/AN/A7395 PINE DRFresnoCA93714-—
TPATPA-516252026-03-27T17:06:13Zkathryn—wang2007-01-19—N/A3275716684UNKNOWN·7432 Mountain View DriveChandlerAZ85216——
TPATPA-552722026-03-25T19:24:07ZDiane—Gibson05/12/1946UHC-79341-11——N/A8335 Mesa DrEden PrairieMN55387—UNKNOWN
TPATPA-630022026-09-09T07:38:20ZJean—Cule08/07/68—•••-••-8250+1 412 469 4708jean.cole@outlook.com7258 SPRING STScottsdaleaz85234UNKNOWN—
TPATPA-610082026-07-17T09:12:11ZLUISNCOLE··18-05-1976UNKNOWN-5127429601-1216 Grand AveCharlotteNC28279UNKNOWNN/A
TPATPA-563422026-08-31T00:29:52Z Henry—Sullivan01/08/1951null··—NULLHENRY.SULLIVAN@HOTMAIL.COM1538 Harbor Blvd·Los AngelesCA90076nullN/A
TPATPA-599092026-06-30T01:56:39Zgloria—dean19389023—•••-••-6902——7637 BAYSHORE DRIVEGLENDALEArizona85395——
TPATPA-566572026-04-21T04:46:44Z Charles—Hill1993-12-10·UHC-05062-59NULL+1 258 916 2313null··7232 Grand AvenueDenverCO80239—NULL
TPATPA-639202026-03-31T19:55:05ZSARAZ.SPENCER2000-07-13UHC-62855-10•••-••-4108-—9551 Harbor BlvdMesa·AZ85240GRP-8597MEDICARE-ADV-A
14,474 rows, page 168 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.224Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty