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-518772026-09-20T19:20:22ZAngela—Wagner16-05-1951—•••-••-9231NULLUNKNOWN2618 CAMELBACK RD #624San DiegoCA92175nullN/A
TPATPA-637812026-02-09T16:09:47ZArthur—Torres08-05-1997··—6874487N/A··9054 Highland AvenuePhoenixAZ85018··NULL
TPATPA-547862026-09-21T10:56:20Zdoris—syms1987-06-10null-578-935-9821-9430 Grand AvenueChandlerAZ85247-3589nullN/A
TPATPA-572912026-08-12T22:19:34Zgregory··hayes20-07-1975UNKNOWN•••-••-8138null-1498 Forest AveMinneapolisMN55452-—
TPATPA-515992026-01-21T18:53:05ZFATIMAZGRAHAM1939-01-05UNKNOWN———9843 Spring StScottsdaleAZ85223····—
TPATPA-522202026-02-19T13:34:53ZJoyce—Rice1943-05-25——NULL—2028 Baseline RoadMesaAZ85273·GRP-3983OPTIONS-PPO
TPATPA-639662026-02-06T14:33:23ZKathleen—Duncan1977-11-23UNKNOWNUNKNOWNNULLkathleen.duncan@gmail.com8069 Union St·TempeAZ85237null—
TPATPA-608802026-06-02T12:39:46Zarthur··—wright1982-02-07—•••-••-0003——8322 Main StTampaFL33655—·null
TPATPA-606142026-05-02T20:52:17ZNICOLE—GONZALEZ1959-04-24null—NULLnicole.gonzalez@outlook.com·1921 UNION STREETLas VegasNV89106—N/A
TPATPA-640752026-02-14T10:56:58ZIsabella—Rose01/19/91UHC-86613-44··-nullUNKNOWN—-null—UNKNOWNOPTIONS-PPO
TPATPA-524502026-06-22T10:02:55Zharold··—little1943-05-17——null-298 Mountain View DrAustinTX78782-0460-—
TPATPA-529382026-05-14T04:06:06ZArjun—Hunt2002-02-13—•••-••-2071—NULL3349 Spring StEden PrairieMN55309GRP-7774··
TPATPA-595062026-05-27T21:45:00ZMorris, ArjunG—19990221———····3815 Cedar LaneScottsdaleArizona85290GRP-7771-
TPATPA-518832026-02-09T11:27:38Z AnaRBanks1968-01-12UHC-34703-52—(554) 753-6159NULL5264 Elm StreetMinneapolis··MN55474GRP-8002··UNKNOWN
TPATPA-583452026-06-03T01:06:34Z Thompson, Camila——1939-01-12N/A··nullNULL5263 BROADWAYSacramentoCA95880-··MEDICARE-ADV-A
TPATPA-623692026-08-10T10:46:41ZSOPHIIA—JOHNSTON··1970-05-28nullUNKNOWNUNKNOWNN/A5765 Grand AveMinneapolisMN55415—UNKNOWN
TPATPA-58984 2026-08-16T17:30:25ZMartin, Jerry··—1939-03-08—null—N/A8116 RIDGE ROADNashvilleTN37256—N/A
TPA TPA-500622026-08-09T17:57:21ZjenHcole1962-10-12-•••-••-2991nulljennifer.cole90@gmail.com—UNKNOWNNULLUNKNOWN——
TPATPA-505252026-07-21T09:21:16Zjohn—powell1942-04-22—NULL-null2053 Canyon RdLos Angeles··CA90049-NULL
TPA TPA-501042026-05-01T10:30:18ZBlack, Jonathan······1952-12-24UHC-08559-01N/A5861447NULL6042 Forest AveSeattleWA98184—··
TPATPA-592352026-04-15T21:06:54ZRuth—Mills05/13/05-—-UNKNOWN6713 Market StTampaFL33618-5868N/ANAVIGATE-HMO
TPATPA-529662026-01-19T22:54:27ZMARIA—ROBINSON1962-12-03N/ANULL(282) 920-0240null717 Grand Avenue·ColumbusOH43281GRP-5506UNKNOWN
TPATPA-610352026-08-13T02:52:50ZRalph····Morris12/28/71UNKNOWN•••-••-9508·UNKNOWNnull··2055 FOREST AVEAustinTX78718·GRP-3435select-epo
TPATPA-636062026-08-29T08:15:29Zlinda—carpenter1940-10-18UNKNOWNNULL-—N/AUNKNOWN—nullnullNULL
TPATPA-536342026-03-09T22:37:19Zvictoira·Yjames1946-03-05null•••-••-4270——4992 HILLCREST RDDenverCO80219—OPTIONS-PPO
TPATPA-512082026-08-21T23:59:00ZKimberly—Ryan10/07/04—•••-••-7444———·null——N/ASELECT-EPO
TPATPA-529822026-03-29T21:29:01ZBradley—Taylor1977-02-24··-N/AN/AN/A4774 Meadow LanePlanoTX75045·GRP-1858OPTIONS-PPO
TPA TPA-553442026-04-13T12:52:14ZCarl—Cole1962-09-09—N/A331-996-3046—7658 Oak StreetAustinTX78776null··
TPATPA-543342026-01-09T00:49:55ZRussell—Marquez1962-03-11··NULLUNKNOWN291-371-0345nullnull····———MEDICARE-ADV-A
TPATPA-54265 2026-03-01T19:03:28Z·HELEN—ALEXANDERDec 14, 1967··UNKNOWN3625748619helen.alexander22@gmail.com7137 CEDAR LNNashville·TN·37262—UNKNOWN
TPATPA-534782026-07-25T01:18:27ZRandy—Jckson11-02-1947N/AN/A—NULL8583 Central AvenueMiamiFL33133N/A-
TPATPA-607282026-04-08T04:07:30ZTERESA—TOMPSON10/23/1988—•••-••-9821nullnull3780 Mountain View DriveTempeArizona85262—NULL
TPATPA-600972026-03-10T22:56:34ZOmar—Schultz11/10/66UHC-58276-63NULL·null—6554 Park PlAUSTINTX-GRP-7673NAVIGATE-HMO
TPATPA-637792026-10-07T04:24:20ZDEBRA—BENNETT1984-09-06—-nullDEBRA.BENNETT@GMAIL.COM5322 Indian School RoadCOLUMBUSOH43291-MEDICARE-ADV-B
TPA TPA-633242026-04-13T11:32:52ZMichael—George1955-06-24UHC-92579-34null—MICHAEL.GEORGE17@AOL.COM3589 Baseline RoadMiamiFL33173UNKNOWNN/A
TPATPA-500702026-05-21T12:21:55ZCharlutte—Wheeler3/13/1964-N/A-—8691 Spring StMiamiFL33117N/AN/A
TPATPA-624022026-01-16T02:11:29Z Beverly—Romero21-10-1974—UNKNOWN—NULL6971 JEFFERSON AVELas VegasNV89115——
TPATPA-641032026-05-03T10:50:26ZFrances—Williamson12/08/60UHC-12909-32•••-••-0617—frances.williamson4@gmail.com3123 MOUNTAIN VIEW DRIVENashvilleTN37278-4316-—
TPATPA-632742026-09-21T21:50:45ZTaylor, Benjamin····—1965-12-19nullNULL(902) 834-5991—8247 Lake View RdGilbertaz85217GRP-0426-
TPATPA-561412026-03-20T17:57:57ZSEANYTUCKEROct 8, 1984N/ANULL—UNKNOWN4906 Sage CourtGilbertaz85263N/AMEDICARE-ADV-B
TPATPA-60900 2026-05-05T23:19:13ZDianeP.Morales··1958-05-02NULLNULLNULLnull6994 Jefferson AvenueSeattlewa98122GRP-6548··—
TPATPA-507722026-03-17T15:53:02ZKENNETH—MARSHALLMar 20, 2003··null—NULLN/A7655 Camelback RoadLAS VEGASNevada89190GRP-5332-
TPATPA-511712026-04-29T01:55:48ZFRANCES··—BERRRY1944-11-28—UNKNOWN587-818-8656-·1982 Desert Sky Boulevard Apt 8DallasTX75231GRP-8474—
TPATPA-516012026-06-06T12:29:45ZJanice—Ramirez·2/17/1972null—NULL-4673 Sunset BoulevardEDEN PRAIRIEMN55358N/A-
TPATPA-563032026-04-22T08:07:59ZAdam—Harper09/18/95·····-5443457527N/A2959 MOUNTAIN VIEW DRTempeAZ85221null—
TPA TPA-573502026-01-07T03:01:29Zalbert··stephens1949-04-17nullNULL———N/AUNKNOWNNULLGRP-8528—
TPATPA-534912026-02-23T03:14:48ZTHOMAS—·JENKINS1996-01-19—NULLNULLNULL6365 OAK STREETDenverColorado80235—-
TPATPA-501552026-03-04T05:42:49ZBobby—Gilbert2001-02-27N/A•••-••-0321null-6310 Grand Ave #240···DallasTX75253GRP-0914UNKNOWN
TPATPA-53881 2026-01-25T00:17:23ZCAROLN—CLARK2000-02-04UHC2592701——UNKNOWN7512 Meadow LaneTampaFL33629·GRP-1130—
TPATPA-613932026-07-04T16:20:40ZROBERT—GUERRERO1947-06-24—•••-••-0927N/Arobert.guerrero63@aol.com8843 Ocean AvenueSeattleWA98184—SELECT-EPO
14,474 rows, page 121 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:46.063Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty