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-4255202026-05-26T00:32:07ZELIZABETH····RILEY1980-06-18·uhc-17628-39—+1 594 557 2705———UNKNOWNNULLGRP-6189—
CLMCLM-4240932026-10-09T02:31:20ZNicole—Gonzalez04/24/59—•••-••-90257756832545NULL1921 UNION STLAS VEGASNV89106GRP-5866··
CLMCLM-4251632026-01-31T18:41:57ZNoahJ.Campbell1956-06-22UHC-04344-86··•••-••-86594165646647N/A5297 Forest AvenueChandlerAZ85261GRP-8787CORE-HMO
CLMCLM-4025692026-08-26T15:37:25ZAndrew—·Cox1987-11-22N/A•••-••-7196(856) 262-8295—830 SUNSET BOULEVARDMiamiFL33189·UNKNOWNNAVIGATE-HMO
CLMCLM-4306682026-06-16T17:12:11Zdoris····lynch19460101UHC-46221-83•••-••-077617339846398—905 MOUNTAIN VIEW DRSAN DIEGOCA··92175-0308N/AMEDICARE-ADV-A
CLMCLM-4051402026-10-01T15:55:11ZRAYMOND—SCHMIDT7/1/1954UHC-32279-47•••-••-4650nullUNKNOWN·8835 VALLEY VIEW DRIVE·JacksonvilleFL32261····null
CLMCLM-4181852026-08-05T21:58:20ZWILLIAMCWEAVER··19710706UHC-86260-13··(622) 982-6713-2512 Church StreetHOUSTONTX77015GRP-9789·NAVIGATE-HMO
CLMCLM-425065 2026-07-25T20:27:07ZTerry—Watson1944-11-06··——(945) 915-2615—706 Forest Ave Apt 23San DiegoCalifornia92144GRP-9055—
CLMCLM-4302232026-10-04T16:39:26ZJANICE··—HAWKINS1992-05-19UNKNOWN•••-••-4021null—8314 Jefferson AveJacksonvilleFL32260GRP-1056—
CLMCLM-4054712026-01-15T22:50:06ZKim, RaplhG··2/20/1997UHC7535551•••-••-4992NULL-4191 VALLEY VIEW DRScottsdaleAZ85290GRP-2571CORE-HMO
CLMCLM-4041742026-07-09T20:00:30ZSteevn—Little12/22/1956UHC-14266-65—N/A-5404 MARKET STHouston··tx77069-8422······—
CLMCLM-4106962026-02-03T17:14:04ZEMILY—ANDERSON1953-02-16UHC-77460-19-5059545342—3066 Sage CtMesaAZ85249·GRP-0815-
CLMCLM-4002162026-07-28T20:39:59ZHAROLD—PENA1997-05-15null•••-••-8080+1 415 870 1242····1236 Union StreetCharlotteNorth Carolina28239-null
CLMCLM-4146322026-03-19T02:26:51ZMASON—ELLIS1965-06-19UHC6461874•••-••-9124-null5237 Indian School RdGLENDALEaz85388GRP-9392SELECT-EPO
CLMCLM-4149162026-02-21T21:50:37ZPena, Andrea—····2004-03-16··•••-••-6295—-5974 GRAND AVE #240NashvilleTN37284GRP-9803UNKNOWN
CLMCLM-4110232026-01-09T15:29:33ZAmber—Lawson1966-10-18UHC0648417-—null4988 MEADOW LANE·SACRAMENTOCA95849GRP-0225null
CLMCLM-4070262026-03-27T08:18:47ZAndrew—Woods1973-11-16NULL•••-••-6083·NULLNULL872 Union StGilbertAZ——N/A
CLMCLM-4203972026-07-25T08:45:43ZCarol—Castillo05/18/2004UHC-75924-10———9167 CANYON ROADTampaFlorida-UNKNOWN—
CLMCLM-4245192026-04-27T21:46:35ZCarlos··Kelly1978-01-20··UHC-55263-23NULLN/A—4048 Palm DriveJacksonvilleFlorida32267GRP-8089CORE-HMO
CLMCLM-4043292026-08-13T19:25:28ZAnaRBanks1968-01-12UHC3470352—5547536159ana.banks61@proton.me··5264 Elm StreetMINNEAPOLISMN55474GRP-8002SELECT-EPO
CLMCLM-4151222026-03-15T21:39:41ZTIMOTHY—BROOKS1978-03-15NULLNULL6567818224N/A9727 MAPLE AVETEMPEAZ85257GRP-5416CORE-HMO
CLMCLM-4167612026-05-18T05:48:02ZBrandon—Morris1961-09-27UHC-64581-74•••-••-2377NULL—3009 Maple Avenue··TampaFL33626GRP-3120SELECT-EPO
CLMCLM-4010682026-01-11T14:13:06ZNATHAN—DELGADO··19471217-—2056078663UNKNOWN2913 WILLOW CT·ChandlerAZ--SELECT-EPO
CLMCLM-414259 2026-07-02T22:17:43ZBRYAN—GRAHAM04/08/1952UHC-91389-39N/A+1 773 355 9998N/A238 JEFFERSON AVENUESAN ANTONIOTX78204—NULL
CLMCLM-4274102026-01-13T02:31:01Z·Gloria·····Ward1968-09-02—•••-••-33468924413gloria.ward92@yahoo.com2598 Hillcrest RoadMiamiFL33166N/A—
CLMCLM-4176132026-01-04T14:48:59ZAustin—Thompson09/22/2004UHC-86839-81•••-••-5050—N/A-—NULLNULLUNKNOWN··—
CLMCLM-4327812026-08-21T18:27:32ZBRIEN—VAZQUEZ1956-09-26UHC-89900-10•••-••-6534(354) 260-5010·N/A6606 Oak StreetAustin·TX78766-4628GRP-9532NAVIGATE-HMO
CLMCLM-4304132026-08-07T00:59:28ZBRADLEY—LARSON16-11-1960··UHC-37517-47—(203) 310-7296-9556 Maple AvenuePhoenix··AZ85057—OPTIONS-PPO
CLMCLM-425284 2026-10-10T19:09:31ZDeborahXOwens1996-09-28UHC-36207-21—(854) 292-8872deborah.owens16@icloud.com7234 Highland AveFresnoCA93721GRP-8977MEDICARE-ADV-B
CLMCLM-4242482026-01-29T11:01:31ZRichard—MurphyFeb 22, 1992UHC-66444-91•••-••-0187+1 682 451 4806NULL546 Lincoln WayCHANDLERAZ-GRP-1024NULL
CLMCLM-4157122026-06-18T18:25:25ZGEORGEV.WEAVER1982-06-25UHC-02449-55—NULLN/A1304 Bayshore DrNashvilleTN37281—CORE-HMO
CLMCLM-4058432026-10-04T08:59:52ZFrancesJMoore2006-04-19UHC1935375•••-••-7423····NULL5127 Baseline RdSacramento·CA95828——
CLMCLM-4195312026-06-26T02:09:22ZJESSICA—·YOUNG1985-06-04—•••-••-3139-—6818 HILLCREST RDLas VegasNV89188GRP-5064—
CLM CLM-4002202026-09-20T13:08:23ZCarolB·Munoz19900320UNKNOWN•••-••-0570969.743.3107—-NULL-—GRP-6685OPTIONS-PPO
CLMCLM-4158082026-08-20T05:55:02ZFATIMA—MORENO07/16/57UHC-24101-25NULL758-229-1647—--UNKNOWNUNKNOWN—N/A
CLMCLM-4083332026-03-02T17:26:45ZJessAVega1967-09-05UHC-52643-31UNKNOWN-NULL1661 Indian School RdAtlantaGA··30390-NAVIGATE-HMO
CLMCLM-4257992026-04-02T01:21:52ZJordan—Williamson02-06-2007UHC-39394-42N/A5307968577—8677 Union St Apt 28EDEN PRAIRIEMN55320N/AN/A··
CLMCLM-4103122026-01-26T01:35:24ZBenjamin··—Jones1991-05-27··UHC-38434-13NULLnullNULL4261 Sunset BoulevardColumbusOH43263-1752GRP-5075··N/A
CLMCLM-4084962026-01-24T09:09:37ZVIRGINIA··—JENKINS1985-02-17UHC-21056-21UNKNOWN-N/A3009 Park PlaceDenverCO80290GRP-8981NULL
CLMCLM-4305572026-08-04T11:31:45ZRussellMJackson2001-02-14UHC-04244-26-null—3483 Desert Sky BlvdMesaArizona85242·GRP-4173UNKNOWN
CLMCLM-431370 2026-05-21T06:58:47ZWILLIAM—COLLINS19730109-—·14868085700—·N/A·-N/A-GRP-5135MEDICARE-ADV-A
CLMCLM-4017682026-05-22T20:29:00ZwalterI·washingtonMar 4, 1944UHC-14561-26—+1 432 438 5636null2644 Hillcrest RoadSAN DIEGO··CA92127N/Anull··
CLMCLM-4187312026-04-19T03:38:50ZAbigail—Vasquez19560725UHC2473066•••-••-6494517-425-0119··UNKNOWN·N/AUNKNOWN—·NULL-medicare-adv-b
CLMCLM-4227212026-09-29T03:35:48ZRogerH.Ortega1939-04-19N/ANULLN/A—9312 Market StJacksonvilleFL32210-··NAVIGATE-HMO
CLMCLM-4050612026-07-11T12:32:06ZMICHELLE—SMITH2003-05-10UHC-47865-40—NULL—N/A——UNKNOWNGRP-9198MEDICARE-ADV-A
CLMCLM-4105872026-02-11T05:10:03ZJudy·U.FranklinSep 24, 1978-•••-••-9983NULLN/A·8374 Mountain View DrCharlotteNC-····MEDICARE-ADV-B
CLMCLM-422102 2026-08-01T22:54:50ZJulie—Watkins2000-07-10UHC-82455-86—NULL—3982 Sunset BoulevardMesaAZ85296UNKNOWNNULL
CLMCLM-4087192026-08-26T07:12:41ZSUSAN—CHAVEZ1981-09-21UHC-26482-42—323-361-0184····6323 Camelback RoadCharlotteNC28229—··
CLMCLM-4101022026-08-01T08:12:05Zrebecca—schultz1951-02-20··-null(342) 879-9932N/A765 SUNSET BLVDPLANOTX75033GRP-6508MEDICARE-ADV-B
CLMCLM-4227812026-02-27T10:04:01Z Wang, Judy——1985-04-05··UHC-93720-28null(371) 868-2486—6688 Washington StHoustonTX—GRP-5700—
32,829 rows, page 158 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:40.349Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty