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-138144 2026-08-01T04:18:30ZjonathanO·mendoza19970120UHC-18541-92•••-••-28576033249527—5911 Meadow LnDallasTX75203-1033GRP-6954·NAVIGATE-HMO
TPATPA-588672026-07-08T09:25:46ZJackie—Ferguson25-09-1974N/A—17605113432··—1854 Ocean Ave··ORLANDOFlorida32806-··
ENRENR-1190632026-03-09T11:02:47ZGEORGEW.LITTLE3/14/2001UHC-78943-67-4195680505george.little80@gmail.com9260 CEDAR LANEOrlandoFL32841GRP-7540OPTIONS-PPO
CLMCLM-4012382026-06-06T01:19:38ZRichards, Dot——1944-08-27··UHC-27953-85·null—-——N/AUNKNOWNGRP-8400MEDICARE-ADV-A
ENRENR-1187302026-07-11T01:30:23ZBryan—Graham1952-04-08UHC-91389-39•••-••-7202+1 773 355 9998bryan.graham87@yahoo.com238 Jefferson AvenueSan AntonioTX78204GRP-2969MEDICARE-ADV-B
ENRENR-1309532026-10-02T18:46:48ZJanice—Banks··1964-06-22UHC-81252-69··•••-••-3679721.618.3607janice.banks9@gmail.com··7977 ELM STOrlandoFL··—GRP-7782NAVIGATE-HMO
CLMCLM-4116942026-02-27T00:10:19Zsantiago—thompson1966-09-08UHC1810193•••-••-5423—UNKNOWN5453 VALLEY VIEW DRIVECharlotteNC28226GRP-9062·NULL
TPATPA-585672026-05-31T00:45:14ZJerry—Lane1949-10-23--NULL———null-—··
ENRENR-1409662026-01-21T13:21:25ZKEITHK.LE1976-05-14UHC-57274-78•••-••-8316(924) 906-7795KEITH.LE@AOL.COM7714 Sunset BoulevardSan Antoniotx78288GRP-4660CHOICE-PLUS-PPO
ENRENR-1383562026-01-11T02:37:38ZGrace··Y—1939-10-05UHC-88944-20•••-••-4974(441) 717-4547—1816 Meadow Ln·ChandlerAZ85261GRP-4564NAVIGATE-HMO
CLMCLM-4301882026-05-23T20:22:05ZBRANDONHPETERSON1965-06-28UHC-21678-78•••-••-9600UNKNOWNNULLUNKNOWNnullUNKNOWNnullGRP-1771SELECT-EPO
CLMCLM-4277362026-09-27T16:11:12ZLucia··—Hughes1939-07-22—•••-••-689113725976654··—3294 LAKE VIEW ROADAtlantaGA30345-1894N/ASELECT-EPO
CLMCLM-4035982026-01-13T19:49:10ZISABELLA—GRIFFIN20-12-1958UHC-44529-74NULL(811) 732-0200·UNKNOWN8641 MAIN STHouston·TX77018NULLnull
CLMCLM-4143202026-05-29T23:13:54ZAngelaE.Woods1977-08-62··UHC-24555-87—·NULLangela.woods@yahoo.com3702 CENTRAL AVELos AngelesCA90047GRP-7760MEDICARE-ADV-A
CLMCLM-403309 2026-09-27T12:49:16ZJudy—Harvey1961-05-25-—9042981881——·nullN/AnullUNKNOWNNULL
TPATPA-629512026-02-02T15:52:41ZETHAN—RUIZ·1968-03-27—UNKNOWN-—9415 Willow Ct·GilbertAZ85215—OPTIONS-PPO
TPATPA-594762026-04-13T22:00:55Zdonald—stewart7/6/2000nullNULL12256334194null——N/AnullN/A-
ENRENR-1325972026-07-17T03:54:24ZkaylaEsimmons07/15/2003UHC-11502-95—N/Akayla.simmons@icloud.com6651 Jefferson AveTAMPAFL33686GRP-6280MEDICARE-ADV-A
CLMCLM-4108282026-01-01T04:34:57ZJustin····Estrada1999-10-01null•••-••-8267—-UNKNOWNnullNULLUNKNOWN··GRP-4204N/A
ENRENR-1393992026-01-29T17:20:19ZMartha—PowellDec 24, 2008UHC-24100-19··•••-••-54772216068204MARTHA.POWELL10@ICLOUD.COM6225 Church StNashvilleTennessee37214GRP-6542OPTIONS-PPO
PRVPRV-248512026-03-02T04:15:35ZTaylor, Madison——1957-08-22-—2967985659madison.taylor24@icloud.com16 Ocean Ave·JacksonvilleFL32299··UNKNOWN
ENRENR-1106512026-07-30T01:18:50ZAlbertS.·Morrison06-12-1992UHC-99651-99··•••-••-8286(770) 301-6775—7326 HARBOR BLVDMESAArizona85235··GRP-5707··SELECT-EPO
TPA TPA-503732026-05-07T14:21:27ZBryan—Turner19510908—•••-••-2182——1071 BASELINE ROADHoustonTX77049null—
ENRENR-1206152026-03-18T11:31:51ZSamanthaZ.··Dunn19380325UHC-02275-68N/A+1 339 353 4169SAMANTHA.DUNN94@YAHOO.COM627 LAKE VIEW RD #972TempeAZ85298··GRP-6173NAVIGATE-HMO
CLMCLM-4048612026-05-14T11:35:01ZAHMED—VAZQUEZ1955-08-09UHC-66130-93•••-••-38029142541272N/A—NULLUNKNOWNnullGRP-5983NAVIGATE-HMO
ENRENR-1369522026-08-09T03:24:10ZJERRY··—MENDEZ1963-06-22UHC-35334-30•••-••-65083300332NULL5505 CANYON RDLas VegasNV89199GRP-8579MEDICARE-ADV-B
CLMCLM-4002342026-08-20T09:40:41ZESPINOZA—ANGELA··19790709—•••-••-4174-angela.espinoza@gmail.com6531 OCEAN AVENUEFresnoCA93743··GRP-5088NAVIGATE-HMO
ENRENR-1310072026-05-29T20:23:49Z·Isabella—Silva1973-11-18·UHC-93649-89null884-318-6465UNKNOWN9728 Harbor BoulevardAustinTX78792GRP-3430MEDICARE-ADV-B
PRVPRV-274702026-04-05T04:45:53ZMason····Edwards·1998-08-27—-(726) 406-6114UNKNOWN··—N/A-NULLNULL
CLMCLM-4187222026-06-14T07:27:35ZRlph—Bell1976-11-03——UNKNOWNRALPH.BELL12@ICLOUD.COM8457 Apache BlvdTempeAZ85201—CORE-HMO
CLMCLM-423870 2026-02-14T23:15:49ZMariana····Peterson·1998-12-07—-—N/A··N/AN/A——N/AOPTIONS-PPO
ENRENR-1171892026-01-19T10:06:40Zaisha·Nperez1985-06-02UHC-74165-04•••-••-4070-aisha.perez59@icloud.com9553 Elm StreetTampaFLNULLGRP-3098NAVIGATE-HMO
ENRENR-1236492026-05-21T18:43:42ZPAUL—MUNOZ1960-07-25UHC-56617-72•••-••-6287UNKNOWN-1878 APACHE BOULEVARDSeattleWA98191GRP-8501SELECT-EPO
CLMCLM-4326852026-03-22T14:41:34ZPATRICK··—·JACOBS1952-01-27nullNULLN/A—NULLN/A——UNKNOWNOPTIONS-PPO
CLMCLM-4132632026-06-03T19:10:18ZSANDRA—GEORGE1951-06-04NULLN/A(905) 646-2311null4220 Willow CourtSACRAMENTOCA95828GRP-8205OPTIONS-PPO
CLMCLM-4259452026-05-14T02:58:46ZDIEGOWTURNERFeb 28, 1988·UHC-92924-96UNKNOWN7302887NULL8225 UNION STTampaFL33644GRP-2014—
ENRENR-1329462026-07-13T04:25:13Z Ryan—Davis7/3/1968UHC-16030-43•••-••-401912329694146ryan.davis94@proton.me3316 Hillcrest RoadSacramentoCA95844GRP-8188SELECT-EPO
ENRENR-1401982026-01-23T01:10:33ZPATRICKPALEXANDER·1967-01-24·UHC0832416—509-923-7315UNKNOWN7838 Ridge RdAustinTX78767GRP-4490CORE-HMO
ENRENR-1212272026-05-24T19:27:10ZFrancesZRogers1953-05-25UHC-18099-21•••-••-163218117742862FRANCES.ROGERS@GMAIL.COM131 LAKE VIEW ROADSACRAMENTOCA95868GRP-9185MEDICARE-ADV-B
PRVPRV-205122026-09-09T12:18:46ZCarl, King—··Feb 6, 1958UHC-56378-01·NULL12633404744—·6441 MESA DRIVEHoustonTX77050null—
CLMCLM-400908 2026-08-15T09:37:55ZRonald—Cooper·1946-10-28UHC-75874-34•••-••-7345NULLronald.cooper@hotmail.com9401 Union Street··LAS VEGASNV89132GRP-7694MEDICARE-ADV-A
CLMCLM-4162632026-06-03T07:07:58ZBrandonRGarciaDec 4, 1945UHC-75549-84—NULLnull3377 Lincoln WaySan AntonioTX78271-1571UNKNOWNCHOICE-PLUS-PPO
ENRENR-1173432026-03-05T10:58:42ZNoahLHawkins·10/12/1975UHC-16115-52•••-••-5218-NOAH.HAWKINS@PROTON.ME3221 Union StreetSan AntonioTX78286-4208GRP-2117SELECT-EPO
ENRENR-1091982026-08-28T18:40:31ZDanielle—Elliott06-11-1987UHC-10138-47•••-••-1331·415-808-9417danielle.elliott@yahoo.com5017 Indian School RoadMiamiFL·UNKNOWNGRP-3687NAVIGATE-HMO
CLMCLM-4131722026-01-25T08:37:59ZAlice——1970-09-28N/A··•••-••-80879418507322null8729 Park PlaceHoustonTX77078-2350····NULL
CLMCLM-4115762026-09-06T15:21:50ZKyle—Ortega1989-09-20nullNULLnullNULL2383 JEFFERSON AVENUEHOUSTONTX·77090GRP-4311SELECT-EPO
ENRENR-1162262026-09-29T19:07:05ZSHIRLEYJ·HARRIS02-07-1994UHC-79852-31•••-••-5080(515) 788-1596shirley.harris81@aol.com··3593 Grand Ave #614PlanoTX75006GRP-1272OPTIONS-PPO
ENRENR-1067792026-01-14T12:49:01ZTYLER—MASON1957-09-23UHC-62457-80null15399177975tyler.mason47@icloud.com7919 Hillcrest RdTampaFL33617-4849GRP-2862··CHOICE-PLUS-PPO
ENRENR-1416232026-08-02T04:58:44ZJessicaLGarza1982-06-01UHC-95765-50•••-••-22953309714000JESSICA.GARZA77@GMAIL.COM4707 LAKE VIEW ROADTempeAZ85278GRP-8025·SELECT-EPO
PRVPRV-208472026-03-15T16:31:37ZMADISON—ROSE1970-12-15UHC-87593-49—5759296150UNKNOWN·8668 Desert Sky BlvdChandlerAZ85292—-
100,000 rows, page 62 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:34.787Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty