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

All sources, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
ENRENR-1281202026-01-08T09:45:44ZHelenTHowaard1985-07-12UHC-56176-72•••-••-7262862-259-7344HELEN.HOWARD21@YAHOO.COM3755 Mountain View DrFresnoCA··93762GRP-6725··SELECT-EPO
ENRENR-1400952026-08-15T11:07:59ZRichard—Stevens1990-10-09UHC-04926-63null810-577-5724richard.stevens@outlook.com526 APACHE BOULEVARDColumbusOH43274GRP-4419SELECT-EPO··
PRV PRV-207892026-10-18T03:11:46ZEMILY—ROBERTS2006-06-27N/A—+1 256 296 9088emily.roberts@hotmail.com2034 HILLCREST ROAD···Phoenixaz85017UNKNOWN—
TPATPA-547572026-03-03T07:49:32ZPowell, LauraW—1969-05-21N/ANULL768.770.4513-3187 Harbor BoulevardEden PrairieMN·55356N/A-
ENRENR-1120662026-09-06T20:43:05ZEmmaYSpencer1943-06-15UHC-81963-03•••-••-0488662.694.7590EMMA.SPENCER44@OUTLOOK.COM·8003 Market StreetOrlandofl32818GRP-5830NAVIGATE-HMO··
ENRENR-1013452026-07-22T02:14:27Z·sue—taylor08/10/1959UHC-47369-79•••-••-7068·321-212-6844susan.taylor17@gmail.com867 Bayshore DriveGILBERTAZ·85284GRP-2488CHOICE-PLUS-PPO
PRVPRV-237682026-01-15T07:43:40Z Weaver, Camila··E.—·1976-10-02····null15518171644—1120 Spring StTempeAZ85298N/A—
PRVPRV-217072026-08-05T13:52:52Z HiroshiYPrice1975-01-23UHC-21169-37····14393906066·hiroshi.price8@gmail.com--UNKNOWN-UNKNOWNNULL
CLMCLM-4213612026-04-30T14:15:49ZWALTER—·COOK1962-06-25UHC-07206-18•••-••-3814835-367-6991··null4996 Meadow Ln·TampaFL33611-5369NULL—
TPATPA-500272026-02-15T09:52:15ZPatricia—Anderson4/15/1974null··——1229 DESERT SKY BOULEVARDCharlotteNC28235GRP-3065null
ENRENR-1262132026-07-24T08:59:51ZRoss, YukiE.—3/1/1982UHC-58641-49•••-••-2033(889) 689-4210—2922 Park PlLas VegasNV89190GRP-1865··OPTIONS-PPO
ENRENR-1094702026-09-18T03:08:27ZAISHA···PATEL19931106UHC-68868-81•••-••-0964(934) 588-1712·aisha.patel@proton.me6912 Main St #945JACKSONVILLEFlorida32218GRP-9054OPTIONS-PPO··
ENRENR-1357252026-02-19T14:34:02ZCHARLESMWANG03-02-1994UHC-35113-59•••-••-3629nullCHARLES.WANG15@ICLOUD.COM9780 WILLOW COURTLos AngelesCA90031-6154GRP-5183MEDICARE-ADV-B··
ENRENR-1253342026-04-01T11:14:47ZARJUNKMITCHELL1962-08-09··UHC-42645-16—5144424712arjun.mitchell99@gmail.com4173 Ridge Rd·AustinTX78782GRP-9839OPTIONS-PPO
CLMCLM-4084882026-09-10T16:48:05ZDominguez, Austin——1943-02-20UHC-60615-04NULL3860311NULL6619 MAIN STGlendaleArizona85320GRP-2814—
ENRENR-132798 2026-05-13T20:42:12ZpatrickE.park1999-06-11UHC3099467-494-574-7640PATRICK.PARK14@YAHOO.COM200 Harbor BlvdNashvilleTN37223GRP-7745MEDICARE-ADV-A
ENRENR-1396582026-08-16T22:48:12ZVictoria—Howard2008-06-17UHC-48661-29•••-••-85194384164458victoria.howard44@gmail.com8632 Forest AvenueAustinTX78778··GRP-2264MEDICARE-ADV-B
TPATPA-579812026-08-04T13:53:43ZKayla—Perez12/11/1964NULLnullN/Akayla.perez@gmail.com5951 FOREST AVEPlanoTX75025N/ACORE-HMO
PRVPRV-230392026-05-22T20:20:25ZGary—SimpsonnullUHC-25382-23NULL—gary.simpson14@gmail.com963 MEADOW LN·NashvilleTN37238UNKNOWNN/A
CLMCLM-4081602026-08-08T03:15:54ZVincent—Hayes1945-11-04uhc-40423-93•••-••-1578(409) 989-5608—1652 Washington StPhoenixAZ85099UNKNOWNN/A
PRVPRV-268862026-05-06T08:25:00ZMadisn··DKelly1952-05-25—-427-800-3659MADISON.KELLY74@GMAIL.COM5238 Sage Court·NashvilleTN37275-8165—·NAVIGATE-HMO
ENRENR-1001842026-08-16T17:42:02ZPAUL—RUSSELL19880504UHC-55726-01•••-••-9551829-985-0964paul.russell40@icloud.com6403 Mountain View DrCHANDLERAZ85264GRP-7583SELECT-EPO
ENRENR-1400772026-10-02T04:48:36ZRachel··—Turner19900403UHC-13497-80•••-••-29492126527212rachel.turner22@outlook.com3221 CENTRAL AVEPhoenix·AZ85069GRP-8605MEDICARE-ADV-B
ENRENR-134675 2026-09-19T10:21:16ZNANCY—SIMS·Oct 7, 2000UHC-83909-97•••-••-3341772-992-5748UNKNOWN8212 MARKET STREET Apt 7SEATTLEWAnullGRP-7569CHOICE-PLUS-PPO
PRVPRV-272332026-08-01T08:54:29ZCynthia—Bomwan1956-03-14—NULL6612601445cynthia.bowman32@proton.me5228 Market StreetSAN DIEGOCA92123·UNKNOWNNULL··
ENRENR-1308032026-01-07T23:55:23ZJustin—Johnson12/05/06·UHC-50045-93•••-••-5795402.517.2649justin.johnson68@outlook.com1128 Sage CourtTampaFL33669GRP-3148MEDICARE-ADV-A··
PRVPRV-224272026-08-05T07:42:31ZRamirez, Jason——1998-11-21UHC-37350-18-2276145840JASON.RAMIREZ@PROTON.ME6727 Valley View DriveMinneapolis··MN55491N/A-
CLMCLM-4175852026-08-14T00:13:04ZFerguson, Danielle——Oct 12, 1985UHC-82532-02-(317) 669-2769nullnull——NULLGRP-2304-
ENRENR-1085262026-03-28T09:17:56ZLUIS—REED··1944-04-24UHC-97310-50•••-••-10622423077489luis.reed@gmail.com3980 MEADOW LNOrlandoFL····GRP-2640MEDICARE-ADV-A
CLMCLM-4304232026-07-19T17:49:13ZJACQUELINEIMENDOZA19900214UHC-51173-49—6345392198null6121 Cedar LaneLas VegasNV89110·GRP-1741null
TPATPA-558882026-01-25T00:09:04ZERICMJENKINS2004-02-27NULL•••-••-1030null··eric.jenkins@hotmail.com8967 PINE DRIVENASHVILLETN37247-NAVIGATE-HMO
CLMCLM-4279192026-09-18T03:50:01Z·Andrea—·OlsonApr 16, 1990UHC-41097-65—nullnull4035 Forest AveGlendaleAZ—UNKNOWNnull
CLMCLM-4175582026-08-31T09:06:14Zdenise—peterson2006-10-12N/AN/A399-872-2277-—NULL·NULL—GRP-6038—
ENRENR-1103342026-06-04T04:36:57ZCAMILA—·FLORES11/9/1938··UHC-35726-64•••-••-9805·+1 466 690 0426—1245 Apache BoulevardLas VegasNV··89115··GRP-0809MEDICARE-ADV-A··
PRVPRV-246862026-03-07T05:07:33ZSara—·Little1981-10-12—UNKNOWN720.936.1742sara.little55@proton.me5850 JEFFERSON AVENUEPlanotx75086UNKNOWNnull
CLMCLM-4248502026-07-24T21:41:42ZJUDITH—MARTINEZ16-09-1993UHC-48517-88—·(660) 829-4651—9374 HILLCREST RDPhoenixAZ85043NULLNULL
ENRENR-1329792026-07-25T09:38:25Zteresa··—allen1973-07-23UHC-50538-21•••-••-9290209-496-0000N/A·2116 Park PlDallasTX75253GRP-2791NAVIGATE-HMO
CLMCLM-4317312026-09-24T04:37:24ZElizabeth··Pierce19700224·UNKNOWNUNKNOWN874-591-7377···-1754 UNION STREETAtlantaGA30337GRP-8289N/A
ENRENR-1232122026-03-13T20:06:55ZMARIAGPERKINS1947-08-16UHC-13382-61•••-••-3688(374) 508-2876maria.perkins@outlook.com9426 Camelback RdCharlotteNC28202GRP-2404MEDICARE-ADV-B
PRVPRV-207412026-10-04T13:36:53ZJoseph—Padilla1998-06-17··UHC-83928-55•••-••-2268·(757) 924-8202UNKNOWN··8273 Lincoln Way·SAN ANTONIOTX78225null—
ENRENR-1142342026-05-09T07:38:27ZCHARLOTTEE·KENNEDY2008-05-19UHC-67859-40•••-••-4830227.300.3289N/A1168 Apache BlvdSan DiegoCA92146GRP-2721NAVIGATE-HMO
TPATPA-612822026-08-21T14:22:06ZTeresa—Mitchell12-09-2001UHC-68340-13•••-••-5012UNKNOWNUNKNOWN1695 CEDAR LN·San AntonioTX78272—NULL
TPATPA-536922026-05-21T09:09:06ZAnderson, Bobby····—1978-03-09N/A··UNKNOWN—3664 Harbor Blvd #951··MINNEAPOLISMN55491GRP-0391—
CLMCLM-4040572026-04-14T16:52:15ZWATSON—ROGER1948-04-27nullNULLN/Aroger.watson@yahoo.com··6246 Forest AveMinneapolisMN55429GRP-8180MEDICARE-ADV-A··
CLMCLM-4237572026-05-25T19:52:00ZBRADLEYNHUGHES·1996-05-25UHC-90029-18UNKNOWN—UNKNOWN6130 Lincoln WaySan AntonioTX78234—medicare-adv-a
PRVPRV-201302026-07-18T10:05:10ZJseph··Silva1979-05-07uhc-84565-25N/A710-598-2586NULL2092 SPRING STREETMesaAZ85285N/AN/A
ENRENR-1379852026-08-03T10:44:45Zethn—moreno08/18/89UHC-89892-08•••-••-3777(828) 859-2637N/A9029 Oak StGilbert···AZ—·GRP-1116medicare-adv-b
ENRENR-1090672026-07-29T21:34:19ZRobertJ.Tucker14-07-2004UHC1087392•••-••-609916222042561NULL2275 Sunset BoulevardTempeAZ··85284GRP-2764CORE-HMO
CLMCLM-4282212026-03-25T22:24:38ZKelly··Jensen1954-03-12UHC-89135-52•••-••-7086·NULL—3420 Baseline RdNashville··TN37213GRP-9906—
ENRENR-1137942026-03-22T20:05:01ZDiego—Martin2007-10-15UHC-39798-52•••-••-6694681-753-2472diego.martin47@proton.me2849 Apache Blvd·ORLANDOFL32872GRP-0829MEDICARE-ADV-A··
100,000 rows, page 189 of 2,000PreviousNext

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:36.717Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty