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

Claims only, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
CLMCLM-4138602026-01-11T10:50:13ZJuan····Welch1959-01-05UHC-99208-18UNKNOWN(347) 820-1851null4917 Park PlSan AntonioTX78227GRP-0947NAVIGATE-HMO
CLMCLM-4324822026-03-02T05:02:26ZLUIS—JONEES··16-05-1948UHC-28777-79•••-••-8431(977) 804-7251NULL2298 Sage CourtPhoenixArizona·85096NULL—
CLMCLM-4201062026-10-11T04:27:48ZZachary—Marshall2001-11-21-—-ZACHARY.MARSHALL95@OUTLOOK.COM7657 LAKE VIEW ROADAtlantaGA30340·GRP-9656UNKNOWN
CLMCLM-4135312026-09-27T18:57:14ZBrian—Parker03/04/83··—(452) 586-4470NULL5116 Ocean AvenueMinneapolisMN55460GRP-3210CHOICE-PLUS-PPO
CLMCLM-4077482026-05-19T12:11:47ZCharlotte—Reyes1943-10-20UHC-26687-68-+1 624 293 6807—2567 Canyon RdCharlotte··North Carolina28296··null
CLMCLM-4198382026-05-14T16:39:10Zteresa··—dixon1970-04-03·UHC7829480•••-••-8404nullUNKNOWNNULLUNKNOWNNULLnullGRP-9967MEDICARE-ADV-A··
CLMCLM-4161532026-06-08T10:52:05ZNICOLE—BUTLER2003-01-13UHC-66546-83—571-612-2806—1374 Spring StreetTucsonAZ85776GRP-9901—
CLMCLM-404598 2026-07-25T11:50:55ZBrian—McCoy1948-03-27UHC-41653-53•••-••-1240-NULL5981 HILLCREST ROADSEATTLE·WA98102-1713GRP-0902N/A
CLMCLM-4155382026-01-14T20:42:28ZMEI—HART1961-06-13UHC-61106-25—4926784584NULL6536 Mesa DriveSacramentoCA95843N/ANULL··
CLMCLM-4188272026-02-02T18:07:24ZTRAN—NATALIE·5/17/1970·UHC-79922-12null(422) 319-5655UNKNOWNUNKNOWNUNKNOWN—N/AGRP-2585—
CLMCLM-428454 2026-03-27T12:11:23ZANDREWO.WILLIS1973-09-13UHC-17110-53•••-••-9154876-898-2209nullUNKNOWN··N/ANULL-GRP-9246null
CLMCLM-4072452026-07-06T08:41:30ZPamela—Long1972-04-14UHC-15298-23•••-••-2634(505) 360-4119-4895 Pine DriveAtlantaGA30312··GRP-0377null
CLMCLM-4005732026-10-16T13:41:16ZJESSE—KIM1967-01-14UHC-45304-40—335.748.8814jesse.kim70@icloud.com3377 Market StFresnoCA··93709GRP-0127MEDICARE-ADV-B
CLMCLM-4169092026-06-15T12:41:09Z·Angela—Perez05-05-1955UHC-27456-12•••-••-1624·9420855—2789 Valley View DriveAtlantaGA30331-3798GRP-3952NULL
CLMCLM-4280972026-03-22T00:45:13ZMelisas—Hawkins1975-06-26UHC-87638-87—4386689792-9255 Harbor BlvdCHANDLERAZ85225-2831··NAVIGATE-HMO
CLMCLM-4093332026-02-23T01:04:16ZSullivan, Lauren——10/9/1986uhc-92701-44•••-••-193218836385689UNKNOWN381 Park PlaceTampaFL33697—CHOICE-PLUS-PPO
CLMCLM-4081482026-06-17T15:39:51ZSofia—Porter2002-07-04UHC-53417-68··—nullNULL1396 Apache BoulevardAustinTX78708-0092GRP-8834CHOICE-PLUS-PPO
CLMCLM-4230002026-02-05T02:59:38Zashley—castro07/15/1952—•••-••-4544—N/AN/ANULL—UNKNOWNGRP-8450-
CLMCLM-4272652026-09-05T02:23:45ZRyan, Doris——1981-08-24NULL•••-••-3346359-690-9950null2666 Sage CourtMinneapolisMN55480··GRP-1211SELECT-EPO
CLMCLM-4031982026-05-13T10:18:01ZBRENDA—ESTRADA1963-12-15UHC-89999-03•••-••-5231—null8397 Canyon RdTucsonAZN/AGRP-7955MEDICARE-ADV-A
CLMCLM-4233302026-02-01T23:04:02ZCAROLYN··—DAY07/25/42UHC-23740-64N/A591-540-3919———NULLNULLGRP-0276SELECT-EPO
CLMCLM-4269072026-05-08T20:31:24ZGarcia, Frank——1940-07-01UHC-99822-51N/AUNKNOWNN/A9059 Market StreetDenver·CO80268-1300··GRP-0844UNKNOWN
CLMCLM-4249912026-05-01T13:42:02ZSAMUELA.RUSSELL2002-08-26··UHC-79322-77··•••-••-2773-———UNKNOWN··—GRP-1397··NAVIGATE-HMO
CLMCLM-4120342026-05-24T23:49:14ZYuuki—Hunter1998-10-08—··NULLNULL730 FOREST AVENUEFRESNOCA93780GRP-2913CORE-HMO
CLMCLM-4281312026-08-22T11:34:54ZJoseph—Murray·1967-12-08UHC-30365-32····—joseph.murray@proton.me··—-·nullGRP-9001··NAVIGATE-HMO
CLMCLM-4026462026-08-23T16:34:22Z·Joyce—Armstrong1968-01-03—NULL··joyce.armstrong34@proton.me7518 Desert Sky Boulevard #468·HOUSTONTX77024-5759—CHOICE-PLUS-PPO
CLMCLM-4179502026-03-06T00:48:03ZWeber—Laura09/22/1944UHC0761110—null-5370 Sage CourtSacramentoCalifornia95842GRP-6926UNKNOWN
CLMCLM-4322192026-06-26T06:41:00ZDorisSSalazar·1956-03-05UHC0643267•••-••-8065856-257-7470UNKNOWN8525 Main StreetLos AngelesCA··90051GRP-5981NAVIGATE-HMO
CLMCLM-4269432026-05-08T00:21:39ZKatherineEButler05-10-1938—null7905444668—7504 Desert Sky BlvdHoustonTX77099·NULLCORE-HMO··
CLMCLM-4298352026-05-05T10:44:08ZBrian—·Ramos1971-08-15·UHC-78407-36-17093802338BRIAN.RAMOS25@OUTLOOK.COM134 MARKET STFresnoCA93714NULLNAVIGATE-HMO
CLMCLM-400534 2026-01-30T00:39:50ZCarl—JacobsMar 2, 1989··•••-••-8847nullCARL.JACOBS@YAHOO.COM3975 Canyon Road #837Gilbert·Arizona85296·UNKNOWNOPTIONS-PPO
CLMCLM-4199472026-06-03T19:49:56ZArmstrongDBradley1947-12-15UHC-69711-57•••-••-1702(495) 881-8317—7778 Willow CourtEDEN PRAIRIEMN55331GRP-6187MEDICARE-ADV-B
CLMCLM-4209942026-08-06T20:21:54ZRUTHD··MILLS2005-05-13····—··UNKNOWN6713 MARKET STTAMPAFL33618GRP-2449NAVIGATE-HMO
CLMCLM-4185842026-06-25T23:22:05ZChristian—Chavez1996-01-20UHC-18389-73NULL503-792-0366—7834 Oak Street #917SeattleWashington98113GRP-1911OPTIONS-PPO
CLMCLM-4273122026-09-22T05:31:59Z Douglas—Edwards1996-09-28UHC-70622-63—N/AUNKNOWN1861 BAYSHORE DRSacramentoCA—N/ACHOICE-PLUS-PPO
CLMCLM-4164282026-06-14T21:19:17ZRALPH····DUNN2001-10-20NULL•••-••-6855N/A—8136 Union Street #920Eden PrairieMN55308GRP-2549··CHOICE-PLUS-PPO
CLMCLM-4259592026-10-17T03:10:07Z Aisha—Sulivan1941-02-07NULLNULLNULL—4715 GRAND AVE··GilbertAZ85222GRP-8318OPTIONS-PPO
CLMCLM-4190632026-03-11T09:39:04ZWAYNE····LOPEZSep 8, 1988··—•••-••-50414846326261null1771 Canyon RoadJacksonvilleFL··32218GRP-3383SELECT-EPO
CLMCLM-4047612026-10-03T14:00:36ZROBERT—PERKINS1968-11-24UHC-38217-24—+1 695 527 3693N/A7520 OCEAN AVEJACKSONVILLEFL32240GRP-3467SELECT-EPO
CLMCLM-4048322026-09-23T21:24:47ZwillieHgreene1988-07-26null——-null—N/ANULL·GRP-2720CORE-HMO
CLMCLM-4136522026-02-21T00:46:40ZJacobs, Sharon——1947-12-18UHC-99106-80•••-••-666112762082166null9453 Desert Sky BlvdLos AngelesCA90091·GRP-9240—
CLMCLM-4285612026-03-17T01:03:35ZSamuel—Medina1943-08-15UHC-51145-14•••-••-77818734718945N/A1746 GRAND AVENUESacramentoCA95807GRP-1601MEDICARE-ADV-A
CLMCLM-4068502026-01-11T06:14:40ZDIEGO—GONZALES03/26/82-——····3904 Market StreetMINNEAPOLIS··MN55408NULL-
CLMCLM-427525 2026-02-03T05:27:58ZMariaC.··Dixon1997-08-12UHC-30547-99null·18058985846UNKNOWN7386 Pine Dr··TempeAZ85219GRP-9396-··
CLMCLM-4243162026-03-09T21:29:48ZEmily—Ortega1946-07-20UNKNOWN•••-••-2603(942) 578-5381—5771 Grand AvenueLas VegasNevada89179GRP-3289NAVIGATE-HMO
CLMCLM-4288872026-04-13T06:41:12Zjudith—carlson1962-08-13··uhc-82292-64NULL(636) 955-5002null9441 Canyon RdSan DiegoCA·92110GRP-6589OPTIONS-PPO
CLMCLM-4170052026-02-09T21:54:33Zjoshua····crawford—UHC-22291-10•••-••-3025(244) 547-4690-1591 Bayshore DrGLENDALE·Arizona85314GRP-3218—
CLMCLM-4248162026-04-18T17:44:47ZAmy—Mendoza1961-09-18N/A•••-••-4226768-446-4749—4346 Hillcrest Road·OrlandoFL32861GRP-9806··
CLMCLM-4229792026-07-14T21:23:13Zkayla—greene1982-03-06—·N/A9838161585·UNKNOWN--—UNKNOWNGRP-0388NAVIGATE-HMO
CLM CLM-4299572026-03-17T01:32:22ZAshley—Edwards22-10-1970—··N/ANULL6246 River Road··San AntonioTX78245N/A—
32,829 rows, page 122 of 657PreviousNext

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