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-583662026-07-09T03:54:34ZKathryn—Duncan07/24/66··UHC-43519-95—8957558703NULL8671 FOREST AVEAtlanta··GA30336—-
TPA TPA-500632026-07-20T16:57:39ZJENNIFER··HCOLE1962-10-12—•••-••-29916396572717jennifer.cole90@gmail.com·5396 Elm StreetCharlotteNorth CarolinaNULLUNKNOWN····
TPATPA-543742026-07-08T21:14:18ZTerry—Rojas·22-04-1939—UNKNOWN2036433507··UNKNOWN··6182 MAPLE AVE··ScottsdaleAZ85200··GRP-6675CHOICE-PLUS-PPO
TPATPA-520782026-08-13T05:29:51ZNICOLE—BOWMAN12/16/78N/A—8355351763—3795 LINCOLN WAYTAMPAFL33683-5961GRP-5833N/A
TPATPA-603232026-02-26T11:39:02Z·Joseph—Kim·19520104—UNKNOWN642-658-4513joseph.kim47@hotmail.com-N/AUNKNOWNNULLNULL—
TPATPA-596842026-09-06T23:37:13ZCarlos—Campbell1961-06-18—-548-212-6607····1159 Bayshore DrAustintx78762UNKNOWNCORE-HMO
TPATPA-601982026-06-24T06:04:32ZAndrea—Stewart1963-09-05NULL··•••-••-1573-UNKNOWN9243 Pine DrChandler··AZ·UNKNOWNnull—
TPATPA-638822026-03-15T17:20:52ZWAALTER—MUNOZ2001-05-12UHC-46892-79NULLNULLNULL6152 SAGE CTSeattlewa··98156—CHOICE-PLUS-PPO
TPATPA-523522026-10-07T01:21:21ZRALPH—CASTRO1969-02-21—N/A—N/A1774 Elm StreetMesaAZ85227——
TPATPA-532442026-09-23T07:43:28ZHenry—·Chhen19691015—•••-••-9244UNKNOWNnull7153 Indian School RdHoustonTX77027GRP-0864UNKNOWN
TPATPA-565692026-09-17T15:51:30Z Wayne—Aguilar1998-01-22NULL··•••-••-0888NULLwayne.aguilar@outlook.com8546 Hillcrest RoadColumbusoh43204··null—
TPATPA-640412026-09-09T13:02:28ZJuanYWilliams08/04/81UNKNOWN•••-••-00698432327017—7824 Sunset BoulevardLos AngelesCA90049·UNKNOWNnull
TPATPA-641112026-09-27T09:35:27Z·AMBER—GARRETT1965-02-08—•••-••-6310(382) 419-0602—null—NULL··N/A-
TPATPA-568052026-09-09T19:26:32ZGabriel—Hnut19740723UNKNOWN—491-526-9389—NULL—UNKNOWN—NULL-
TPATPA-598542026-04-03T04:46:36ZWAYNE··—THOMAS1954-02-10-—N/A-4016 Jefferson AvenueSEATTLEWA98168—CHOICE-PLUS-PPO
TPATPA-613592026-03-08T13:02:29ZAMBER—JORDAN1985-02-17————1088 Sunset BlvdSeattleWashington98186-null
TPATPA-587002026-08-31T13:26:56ZAmber—Bradley1985-11-09—•••-••-2539N/AN/A61 Market StHoustonTX77043GRP-8423UNKNOWN
TPATPA-505532026-03-04T16:23:17ZJean—Ortiz1969-08-16NULLnull7277886712—9151 Pine DriveFresno··CA93768nullUNKNOWN
TPATPA-619402026-08-14T06:31:13ZChristina—Lynch1942-03-08N/A——null8964 Maple AveCharlotteNC28230-5942NULLOPTIONS-PPO
TPATPA-555362026-04-20T16:30:31ZLori··Varags19971218————7352 River Rd Apt 20··HoustonTX77015—MEDICARE-ADV-B
TPATPA-637902026-03-24T17:45:51ZMark—Brown20040915-—NULLUNKNOWNNULL··nullNULL—····N/A
TPATPA-617612026-10-16T16:06:03ZCHARLOTTE—ROGERS3/20/1996—····972-357-4202N/A7069 Cedar LaneHoustonTX77038-3553N/ANAVIGATE-HMO
TPATPA-596292026-02-21T07:31:54ZSANDRA—STEVENS1963-08-22—•••-••-4092(385) 386-5840—6300 Lake View RoadTempe··AZ85255GRP-2974··UNKNOWN
TPA TPA-526532026-03-26T20:05:05ZJudy—Wells1938-01-11—UNKNOWN—-9036 Valley View DriveTempeArizona85211UNKNOWNNAVIGATE-HMO
TPATPA-552492026-01-31T07:13:08ZNATHAN—ROBERTSON1995-01-26—NULLnullnathan.robertson@yahoo.com1798 Desert Sky Boulevard··FresnoCA93744GRP-9571-
TPATPA-54007 2026-03-30T07:47:39ZLOGAN—HAMILTON1972-01-12NULLnull7825010NULL7925 Pine DriveCharlotteNCUNKNOWNNULL—
TPATPA-573732026-05-18T21:20:11Zcharles—watson1952-06-16··null··—17102090425-·2196 Spring StTempeArizona85221··—
TPATPA-617992026-09-25T22:11:46ZCharles—Robinson1973-01-24nullUNKNOWN(455) 531-4087—3748 OCEAN AVETempeArizona·85277GRP-2008MEDICARE-ADV-A
TPATPA-548062026-03-19T11:20:02ZLAURENAPEREZ1949-06-06UNKNOWNN/AN/AN/A7080 Main StFresnoCA93700UNKNOWN··—
TPATPA-548532026-05-09T15:53:33ZAlbert—Burton·1982-06-17—•••-••-5447N/Aalbert.burton@hotmail.com—-——GRP-9191UNKNOWN
TPATPA-525372026-05-09T05:46:13Zelijah—sims05/19/1991-•••-••-1347-—2636 Highland AvenueSacramentoCA95889GRP-1544MEDICARE-ADV-A
TPATPA-518552026-09-14T18:27:42ZThompson, Melissa——19760210UNKNOWN··-——-NULLNULLnull—
TPATPA-628392026-06-01T07:22:11ZMORRISON—RUSSELL·1952-07-14··UNKNOWN-UNKNOWN6556 SPRING STREETHoustonTX·77089··—
TPATPA-591502026-01-02T14:52:56ZGary—Stewart7/21/2004UHC-03014-10····(691) 915-4393gary.stewart@proton.me4203 APACHE BLVDPlanoTX-UNKNOWN··—
TPATPA-535262026-02-07T20:24:46ZGary—Sandoval1987-07-20—--N/A2024 Valley View DrLos AngelesCA90081GRP-7856-
TPATPA-559192026-03-07T16:19:06ZJason—Johnston21-07-1987UNKNOWNUNKNOWN965.565.5802·NULL5392 Highland AveSan DiegoCA92102··null—
TPATPA-552562026-02-10T23:15:30ZChristine—Scott07/27/1955UNKNOWN··NULL———————
TPA TPA-561462026-09-19T12:23:06ZMAGGIE—SCHMIDT1942-04-03N/A•••-••-6633(541) 471-8299—-——NULL—MEDICARE-ADV-B
TPATPA-555442026-10-07T20:15:34ZSADRA—NELSON05/01/65—-N/AN/A··699 Desert Sky BoulevardFresno·California93771-NULL
TPATPA-508952026-09-17T17:04:57ZEric—Evans1979-11-17N/A•••-••-6176——N/A-——NULL—
TPATPA-50549 2026-03-14T22:23:33Z·CHARLOTTE—GUZMAN19850517··UHC-77788-73NULL(560) 530-3999N/AUNKNOWN··——null—null
TPATPA-598262026-01-04T07:50:26ZJackARiley1986-05-12··null•••-••-7917UNKNOWNNULL9899 Park Pl #841PhoenixArizona85010—-
TPATPA-541492026-06-12T07:56:07Zangela—hawkins20030413N/AUNKNOWN18632020678··UNKNOWN8940 CHURCH STREETMesaAZ··85276UNKNOWN—
TPATPA-572012026-01-11T08:34:35Zvalentina—peters1959-03-02UHC8819384•••-••-123919455041028—9631 Harbor BoulevardLas VegasNV89122null-
TPATPA-520182026-09-05T21:56:57ZCarpenter, PhilipO—3/23/1952-··•••-••-5371NULL—null··UNKNOWNN/ANULLNULLUNKNOWN
TPATPA-540002026-06-01T04:08:29ZEugeneIJones2/20/1966——-eugene.jones@aol.com1907 BROADWAYChandlerAZ85295··——
TPATPA-592562026-01-11T20:20:48ZJordan—Murphy19861216—null937-458-7240-621 Indian School RdGilbertAZ85230GRP-3144MEDICARE-ADV-A
TPATPA-550522026-07-07T01:33:48ZMarcus··—Arnold————MARCUS.ARNOLD@YAHOO.COM9643 Cedar LnSan DiegoCA92118GRP-8834CORE-HMO
TPATPA-585962026-05-29T11:29:54ZParker—Richard1949-09-03····—5836883790—N/ANULLN/AUNKNOWN·nullNULL
TPATPA-515952026-09-25T13:37:10ZSARAH—ALVARADO··16-04-1963——209-558-1648sarah.alvarado@outlook.com-—-—N/A—
14,474 rows, page 102 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:43.461Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty