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-578812026-09-09T17:54:54ZKELLY—PARK01/04/03uhc-31870-54··null12154662801KELLY.PARK@GMAIL.COM4154 Apache BoulevardLAS VEGASNV89132nullnull
TPATPA-581202026-01-17T23:36:59ZEVELYN··—·RODRIGUEZ1963-06-17--——9796 UNION STREET Apt 26FresnoCA93765null—
TPATPA-621642026-10-03T14:16:42ZKIMBERLY—ELLIOTT1980-04-02UHC-63437-77UNKNOWN—··5434 HILLCREST ROADSEATTLEWA98157-8195—UNKNOWN
TPATPA-560482026-03-15T06:17:31ZMaria—Mills02/20/2002·-•••-••-08909558996113·N/A4692 Park PlaceColumbusOhio43211—MEDICARE-ADV-B
TPATPA-552202026-01-23T03:31:58ZKevin—Armstrong04/16/02NULL•••-••-1434NULLkevin.armstrong79@hotmail.com—N/AUNKNOWN··N/AUNKNOWNUNKNOWN
TPATPA-510462026-03-11T03:11:08ZSHIRLEY—STONE··1987-01-18··UNKNOWN•••-••-3167—shirley.stone70@proton.me-UNKNOWN·-UNKNOWN··GRP-8501SELECT-EPO
TPATPA-572932026-02-10T03:34:13ZEVELYN—BAKER6/8/1953—UNKNOWN—UNKNOWN—NULL——GRP-3462null
TPATPA-59683 2026-06-16T22:56:07ZEdwards, JudyA.—08/01/1992UNKNOWN•••-••-9413—NULL501 Palm DriveGilbertAZ85223N/AN/A
TPATPA-625142026-05-29T09:40:22ZFrances—Hunter4/16/2005N/Anull—null3674 Oak StreetGlendaleAZ85353—-
TPATPA-636742026-01-25T05:00:52ZGraham, Christoppher——·10/28/1994UNKNOWN•••-••-7200·+1 675 934 8647UNKNOWNN/AUNKNOWN——-CORE-HMO
TPATPA-543352026-01-09T00:49:55ZRussell—Marquez1962-03-11··NULLUNKNOWN291-371-0345nullnull····———MEDICARE-ADV-A
TPATPA-510172026-10-04T15:13:44ZSharon—Garza1965-03-01····•••-••-6855null—6519 Union StDENVERColorado80247-5546GRP-8601MEDICARE-ADV-A
TPA TPA-549772026-05-26T04:05:39ZMELISSAU.WONG2007-04-25—•••-••-60324524720809—4112 PARK PLLas VegasNV89145GRP-7943—
TPATPA-500052026-09-06T02:42:44Z beckyV.guerrero19940812UHC7312026·NULLUNKNOWN··REBECCA.GUERRERO@OUTLOOK.COM9512 BroadwaySan AntonioTX78221—MEDICARE-ADV-A
TPATPA-639532026-07-30T10:55:03ZVALENTINA—LARSON··1991-08-25NULLUNKNOWNUNKNOWN—7653 Sage CourtSCOTTSDALEAZ85218GRP-1978-
TPATPA-578242026-03-21T11:55:45ZPalmer, Robert——1977-11-13null-8903221400—5226 Forest Ave #180TUCSONAZ85735——
TPATPA-559882026-07-20T03:43:27ZTyler—Medina1990-10-01—N/A····N/A3212 GRAND AVEMesaAZ85282null·null
TPA TPA-58141 2026-05-16T16:49:30ZJustin··XSchultz09-08-1985··null·UNKNOWNUNKNOWNNULL6556 Mountain View DrGlendaleArizonaUNKNOWN—CHOICE-PLUS-PPO
TPATPA-612232026-06-29T08:18:13ZJonathanGTaylor1981-08-02nullNULL—null34 Market St #982TucsonAZ85764—OPTIONS-PPO
TPATPA-512602026-03-18T18:36:49ZCHRISTINA—CRAWFORD1956-06-26null•••-••-6653——5106 DESERT SKY BLVDEden Prairie··MN55310—null
TPATPA-550002026-05-20T14:52:29ZWei—Young19440903UHC-83500-09•••-••-3276(273) 816-2623wei.young52@outlook.com940 Park PlColumbusOH43268NULL··—
TPATPA-589852026-06-01T01:18:50ZJerryX—1939-03-08——null—8116 RIDGE ROAD·NashvilleTN—NULLUNKNOWN
TPATPA-552062026-06-21T21:39:28ZChristina—Mendoza1999-08-17UNKNOWN·N/ANULLNULL4058 Washington StTEMPEAZ··85259GRP-2075MEDICARE-ADV-A
TPATPA-590382026-06-10T08:29:13ZMcDonald, LindaB—1980-04-09-—UNKNOWN—6056 Highland AvenueAtlantaGeorgia30385NULLUNKNOWN
TPATPA-565792026-09-14T14:25:29ZAndrea—Ruiz04/27/88—UNKNOWN4356946150NULL—-··nullnull-
TPATPA-505342026-01-15T09:30:22ZJulia—Hall1968-12-07—•••-••-1402UNKNOWN—4168 OAK STDenverCO80215·-N/A
TPATPA-535552026-03-09T21:53:58ZTHOMAS·H.ESSPINOZA1980-07-04—N/AN/AN/A·8979 Market StEden PrairieMN55302null··UNKNOWN
TPATPA-637872026-05-02T21:33:04ZCarlos—Payne1977-07-23N/A··UNKNOWN(328) 552-0868-—NULLNULL—nullSELECT-EPO
TPATPA-507022026-07-28T16:39:53ZCynthia—Ryan··19920722UHC4029556NULLUNKNOWNUNKNOWN4288 UNION STMinneapolisMN55457—-··
TPATPA-504352026-05-13T18:37:00ZCHRISTIAN····KNIGHT09/07/1939—•••-••-7495288-482-9234christian.knight76@proton.me·5667 BROADWAYSan AntonioTX78204NULLnull
TPATPA-633652026-06-04T13:10:14Z CRL—SANDOVAL1972-05-01———null4525 Ridge RoadTucsonAZ85760-N/A
TPATPA-528162026-09-01T11:42:26ZALEXIS—WELCH19500521NULL··N/A·-—2207 MEADOW LANEFresnoCA93725GRP-6028null
TPATPA-557032026-09-21T00:33:46ZJeremyNJeensen1950-09-03null—····jeremy.jensen@hotmail.com4076 Spring StScottsdaleaz85241UNKNOWNMEDICARE-ADV-A
TPATPA-532352026-02-21T23:37:16ZRobert—Patel01/08/1998null•••-••-9777—null7450 Lake View RoadSeattleWA98146—SELECT-EPO
TPA TPA-610012026-02-28T18:42:39ZChristopher····Gray2000-08-20UNKNOWN———6500 Elm StreetMinneapolismn55411GRP-6541NULL
TPATPA-641212026-07-23T08:44:16Zroy—stewart18-06-1964—N/A13325233417NULL5599 Willow CtSAN ANTONIOTX78263GRP-8942—
TPATPA-613702026-02-25T22:21:31ZJames—Parker05/11/2002··-2253883390N/A8408 CANYON ROAD #761··PhoenixAZ85040GRP-4625—
TPATPA-642952026-06-14T09:27:14ZBeverlyKCarlson05/25/81-•••-••-2248337.273.7487beverly.carlson43@hotmail.com7248 GRAND AVEAustin·TX78747NULL·MEDICARE-ADV-A
TPATPA-535342026-07-31T09:30:53Z Henry—Espinoza19670819—NULL——5789 Apache BoulevardSEATTLEWA98147—CHOICE-PLUS-PPO
TPATPA-615142026-04-08T10:47:51Zsamuel—alen1998-01-15UNKNOWN---5766 Harbor BoulevardDALLASTX····NULLNULL
TPATPA-565932026-10-06T03:01:45ZEUGENE··—WALLACE06/16/42NULL—220-733-5096N/A8878 BASELINE RDJacksonvilleFL32219GRP-4692MEDICARE-ADV-A
TPATPA-565732026-01-08T03:26:02ZOmarJOBrien16910810nullN/A····N/A8082 Highland Ave·TucsonArizona85760——
TPATPA-637032026-02-19T09:21:22ZPaul—OBrien15-06-1946—•••-••-4220·null—9081 BroadwayDENVERCO80282—CHOICE-PLUS-PPO··
TPATPA-577472026-05-05T04:00:08ZMark—George1938-12-13·UHC-88108-61•••-••-1467+1 933 940 9905null-—-null—-
TPATPA-631932026-01-05T04:10:19ZJacob—PerezJun 12, 1971N/A•••-••-6338—UNKNOWN··NULL-———CHOICE-PLUS-PPO
TPATPA-604802026-01-28T04:54:04Z Justin—Ryan1974-11-04··—-—justin.ryan@proton.me1898 CAMELBACK RDPlanoTX75018GRP-0570··null
TPATPA-502782026-07-09T04:27:24ZGaryJ.Gutierrez1992-12-06—•••-••-8045381.341.8968gary.gutierrez@aol.com2995 Market StreetEden PrairieMN55325-1072N/Anull
TPATPA-531912026-01-25T01:28:13ZTHERESAPSTEVENS1954-10-25N/Anull·UNKNOWNtheresa.stevens@yahoo.com9388 Church StEden PrairieMinnesotaN/A—UNKNOWN
TPATPA-548042026-08-12T02:05:13Zbryan—reynolds1958-08-23—-——1616 DESERT SKY BLVDGlendaleAZ85376GRP-1109SELECT-EPO
TPATPA-556472026-04-11T06:00:31ZMei—Li19531128UNKNOWNnull+1 711 668 4556-9840 PALM DRJacksonvilleFL32255-9196—OPTIONS-PPO
14,474 rows, page 171 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.233Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty