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-4224392026-08-07T16:54:35ZEMMA—SILVA1977-06-11NULL··-——6272 Church Street Apt 4PlanoTX75038GRP-8265MEDICARE-ADV-A
CLMCLM-4014212026-09-01T14:51:42ZHeather—Le··1960-09-15—•••-••-4809—heather.le44@icloud.com5299 Desert Sky BlvdAustinTX··78740—SELECT-EPO
CLMCLM-4071412026-07-30T17:59:09ZMETEO—KELLY7/10/1947NULL•••-••-7183——9270 ELM STREETSan Diego·CA92165—·NULL
CLMCLM-4164382026-06-13T11:58:32ZAnnaFBaker27-10-1944UHC-10154-58-(722) 788-7847UNKNOWN3705 Palm DrCHANDLERAZ85289GRP-3642—
CLMCLM-4150472026-10-15T08:06:59Zalbert—tran2004-12-08NULL•••-••-4216NULL—2632 Cedar LaneAustinTX78779NULL—
CLMCLM-4142752026-01-10T11:10:09ZGeorge—Clark1957-12-20UHC-07697-40UNKNOWN·12129920029--UNKNOWNNULLnullGRP-7870NULL
CLMCLM-4211772026-07-15T10:31:34ZWLLIE—LESep 17, 1969—•••-••-2921NULL—6908 Oak StSacramentoCA95814GRP-6191CHOICE-PLUS-PPO
CLMCLM-4208772026-07-14T03:34:29ZKenneth—Gonzales1994-09-09nullN/A-N/A2617 CEDAR LN Apt 26ChandlerAZ··85216GRP-0630NAVIGATE-HMO
CLMCLM-4195982026-06-09T14:44:48ZValentia—Santiago1993-10-02UHC-48471-74•••-••-3885UNKNOWN—-UNKNOWN····——NULL
CLMCLM-4042832026-06-02T06:51:06ZAISHA—FOWLER··Apr 20, 1946·UHC-20279-26UNKNOWN355-758-6805——N/A-···-NULL··OPTIONS-PPO
CLMCLM-4023912026-04-21T15:34:13ZJustinSRoss09-06-1967··nullN/A-3558 MARKET STSacramentoCAnullGRP-6797null
CLMCLM-4040082026-03-11T20:40:44ZEugene·H.Young1983-07-25·UHC-39535-18null253.870.0296—4495 River RdDallasTX75204GRP-6838—
CLM CLM-4309792026-08-30T02:42:00Z KarenIThomas11/05/2005UNKNOWN•••-••-47603516962268—6718 Mesa DrHoustontx77082····UNKNOWN
CLMCLM-4137312026-02-04T09:25:06ZSara—Franklin19550904UHC-76769-82•••-••-6753—UNKNOWN··3518 Central AveLas VegasNevada89141GRP-6375CORE-HMO
CLMCLM-4271732026-09-18T18:29:10ZBlack, Bryan——1940-01-26null-·-—985 Apache BlvdMinneapolisMN55412-—
CLMCLM-4266672026-06-30T20:12:51Zana—·leeDec 22, 1945UNKNOWN•••-••-1253UNKNOWNnull·8520 WASHINGTON STFresnoCA93791——
CLMCLM-4228152026-02-28T13:06:15ZFerguson, Natalie——19420516UHC-75951-23•••-••-7415———nullnullN/A—-
CLMCLM-4094642026-08-10T21:34:54ZHAROLD····WEST1962-03-24··UHC-71442-08N/A··965-288-6532NULL·2674 Spring StreetAtlantaGA30353nullCORE-HMO
CLMCLM-4248892026-08-12T03:21:02Zaisha—·moore1017-19-96··—•••-••-0971784-826-9253——null———MEDICARE-ADV-A
CLMCLM-4117312026-07-11T05:45:52ZRAYMOND—PATTERSON1938-09-28UHC-88717-54•••-••-4808—NULL8662 SAGE COURTChandlerAZ85251GRP-0146OPTIONS-PPO
CLMCLM-4001022026-08-27T12:48:05Z ANNA—MCDONALDMar 16, 1972UHC-61383-31UNKNOWN783.759.4369NULL5798 UNION STREET··LOS ANGELESCA90015-9442-N/A
CLMCLM-4256072026-03-16T23:02:21ZJessicaABishop1984-09-18UHC4841913N/A8856276134—NULLUNKNOWN·N/A··—MEDICARE-ADV-B
CLMCLM-4029402026-01-27T02:10:34ZPatrick—McDonald1916-09-01UHC-20249-57—5500728—8384 Baseline RoadJacksonvilleFL32286GRP-6892·MEDICARE-ADV-B
CLMCLM-4142342026-05-17T11:23:14ZAdam—Green2003-05-12UHC-08215-14null9595158897———UNKNOWN—UNKNOWNNULL
CLMCLM-4086692026-08-23T04:12:09ZRUTH—FISHER1968-10-20N/ANULL875-256-7430—5096 BROADWAYLos AngelesCA·90091GRP-2348—
CLMCLM-4110952026-02-26T07:45:09ZBrittany—·Stephens14-01-1945UHC-39290-82—979.577.7865-3384 Oak Street·ColumbusOH···43201—NAVIGATE-HMO
CLMCLM-4122162026-04-21T03:37:14ZNoah—Welhc1978-12-12UHC-89604-28UNKNOWN889-360-5124NULL·4394 Pine DrDenverColorado80245GRP-3807—
CLMCLM-4324112026-04-17T18:28:04ZMichell, Edward——2000-06-12UHC-60479-18nullN/A—6374 Park Place··Mesa··Arizona85219-1572··GRP-9899MEDICARE-ADV-B
CLMCLM-4108182026-09-14T20:23:36Z·MarkTHarvey1969-12-23UHC-89999-98—N/A—7633 Bayshore DrLos AngelesCAnull·GRP-5700SELECT-EPO
CLMCLM-4135542026-06-08T11:18:20ZDEBORAH····ROSE1998-08-11null··•••-••-3595—UNKNOWN1463 MOUNTAIN VIEW DRIVE··PhoenixAZ85039—NAVIGATE-HMO
CLMCLM-4232382026-09-20T03:32:21ZJacqueline—Diaz28-12-1955UHC1500991•••-••-1261UNKNOWNnull5150 Central AvenueSan AntonioTX78205-—
CLMCLM-4042272026-05-22T22:34:42ZGonzales, Jean—··19891119UNKNOWN-—UNKNOWN6660 Lake View RoadSacramento··CA··95853GRP-0709—
CLMCLM-4036092026-04-11T09:54:19ZRobertF.Jordan1974-09-10NULLN/A—null··6722 Meadow LnMiamiFL-GRP-6745null
CLMCLM-4230922026-05-23T19:49:28ZAmberNWatkins1976-10-16··•••-••-95242954610659—9383 Baseline Rd·TempeAZ85292UNKNOWNMEDICARE-ADV-B
CLMCLM-4050692026-06-10T15:36:18ZAlan····Aguilar1941-11-05—null594-360-6724UNKNOWN7777 HILLCREST ROADMIAMIFL33170GRP-0856··—
CLMCLM-4191592026-04-03T17:45:13ZJANICE—MCCOY2004-03-02UHC-72128-31•••-••-4210N/A··N/A··7802 Oak StNashvilleTN37293-2897··—null
CLMCLM-4274452026-01-29T00:20:56ZMichelleNCarr1968-12-25UHC8844175null(327) 729-8800·N/A3407 Mountain View Drive·GlendaleAZ85366GRP-4728·SELECT-EPO
CLMCLM-4041362026-05-05T16:20:12ZEmiyl··—Valdez17-11-1942UHC-53364-70··N/AUNKNOWN-N/A—-nullGRP-5565MEDICARE-ADV-B
CLMCLM-4049122026-09-22T04:08:26ZBruceP.Ferguson1977-04-10··null—3388534845UNKNOWNUNKNOWNnullNULL——CHOICE-PLUS-PPO
CLM CLM-4221292026-05-19T12:26:38ZCarlosV·Gonzalez05-02-1969··UNKNOWN4072734178—2079 Valley View DrivePhoenix·AZ·85086GRP-7116OPTIONS-PPO
CLMCLM-4019482026-09-07T03:43:07Zralph—perryJul 19, 2003—null8495004457nullN/A-UNKNOWN--CHOICE-PLUS-PPO
CLMCLM-4118582026-10-16T10:16:04ZannaS.long1976-05-06UHC-85185-56—(635) 994-0133UNKNOWN8406 Elm StLas VegasNV89115GRP-8474—
CLMCLM-4257422026-04-24T02:36:06ZEmmaQNelson1966-03-09··UHC-24962-50•••-••-4072—-2058 Central AvenueCHANDLERAZ85287nullCHOICE-PLUS-PPO
CLMCLM-404783 2026-08-31T05:18:45ZARTHUR····ALEXANDER1956-08-20UHC-11557-51•••-••-1424—-4818 Market StreetNashvilleTN37273-4958GRP-8607SELECT-EPO
CLMCLM-416675 2026-04-19T13:57:55Zdbera—wilson6/22/1992uhc-67369-44•••-••-9714—-5727 RIVER ROAD··GlendaleAZ85358-4503GRP-3392-
CLMCLM-4236982026-02-11T08:14:33ZJohn—Maldonado09/17/1952-UNKNOWN8573189535··john.maldonado@hotmail.com5314 RIDGE ROADMinneapolis·MN55481·GRP-0621CHOICE-PLUS-PPO
CLMCLM-4237652026-06-16T02:37:15Z Margaret—·Stevens12-12-1981null•••-••-8772506-626-2864N/A·7419 BASELINE RDATLANTAGA—UNKNOWNNULL
CLMCLM-4320362026-05-09T09:29:10ZRANDY—SCOTT·1973-03-08UHC-99947-20•••-••-0911432-617-8920null2010 Sunset BoulevardTampa·FL33625NULL—
CLMCLM-4009672026-06-05T08:43:46ZjosephI.·gibert19460721····—3513213461-2818 Bayshore DriveTucson··AZ··85738UNKNOWN-
CLMCLM-4313952026-04-03T02:07:50ZDiana—Williamson1977-08-15·uhc-93292-52-(526) 824-5957··UNKNOWN9849 Highland Ave··MesaAZ85276NULLMEDICARE-ADV-B
32,829 rows, page 69 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:37.725Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty