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-4052932026-01-10T07:10:04Z·Albert—Hall3/18/1980—N/ANULL—nullN/AN/AN/AUNKNOWNSELECT-EPO
CLMCLM-4102822026-09-25T18:18:17ZSantiagoC·WatsonJul 25, 1962·UHC-78715-95——NULL9573 Sage Ct·Los AngelesCalifornia90024GRP-7067·null
CLMCLM-4141532026-02-19T13:18:05ZBenjamin—Mooe··1950-01-08—•••-••-78822456425065UNKNOWN——nullUNKNOWNN/ANULL
CLMCLM-4089892026-08-15T17:29:32ZGRACE—MALDONADO1979-06-18UHC-80617-85N/A····5716 RIDGE ROADTucsonAZ85708GRP-6550MEDICARE-ADV-A
CLMCLM-4160862026-01-20T19:02:59Z·Harris, Arjun——1953-10-27—NULL(514) 757-3995null777 Lake View RdEDEN PRAIRIEmn55398N/A··—
CLMCLM-4069262026-06-04T02:29:17ZMedina, JoseK.——UHC-85752-84•••-••-0112—N/A4922 Sunset BlvdSan DiegoCA92110-4861GRP-2722MEDICARE-ADV-A
CLMCLM-4197092026-05-29T09:56:29ZMarilyn—James1969-10-05UHC-34608-53--MARILYN.JAMES@YAHOO.COM4451 FOREST AVENUESCOTTSDALEAZ85265·GRP-0190—
CLMCLM-4031082026-10-17T13:06:30ZLauraFReyes·1987-02-18UHC-58818-28•••-••-1890—-6236 Spring StDallasTX75216UNKNOWNMEDICARE-ADV-B
CLMCLM-4124952026-05-03T10:57:13ZCYNTHIA····WATKINS··2002-08-03UNKNOWN•••-••-9152(867) 367-3280cynthia.watkins@gmail.com——N/AN/A—·MEDICARE-ADV-A
CLMCLM-4214412026-09-28T19:18:41ZVictoria····Rogers1993-10-14—•••-••-3368--7113 Baseline RdPlano·TX75020GRP-5119null
CLMCLM-4144342026-07-19T00:38:33ZDONNAOJACOBSApr 28, 1980UHC-93706-58•••-••-0462(215) 723-7645-·1474 Hillcrest RdGilbertAZ85224——
CLMCLM-4152442026-05-30T02:46:58ZannKgonzalez1960-10-27UNKNOWNNULL+1 278 836 2292—4617 GRAND AVESacramentoCA··95855NULLNAVIGATE-HMO
CLMCLM-4183502026-03-24T16:30:39ZSteve—RobrtsonJul 21, 1983··—•••-••-7594—UNKNOWN9329 CANYON RDCHARLOTTENC··28263·nullMEDICARE-ADV-A
CLMCLM-4220482026-07-14T00:17:26Z ·Carlos—Campbell1961-06-18UHC8922734null——1159 Bayshore DrAUSTINTX78762··-UNKNOWN
CLMCLM-4101752026-01-13T00:41:40ZDouglas—Cole1985-09-18UHC-11333-58•••-••-5820523-542-6565UNKNOWN9589 MAPLE AVENUEFresnoCA93716UNKNOWN-
CLM CLM-4189002026-09-21T19:37:22ZHEATHER—·VAZQUEZ·1986-11-05——3722273-3112 Grand AvenueORLANDO··FL32823GRP-4855··—
CLMCLM-4055132026-07-12T03:45:53ZkathrynY.lawson9141-09-02UHC-96469-23null··4396118559—-nullNULLN/A·GRP-9399null
CLMCLM-4132672026-03-16T09:14:42ZKATHERINE—GOMEZ2007-07-28-•••-••-8596—katherine.gomez1@gmail.com—N/A-—UNKNOWNCORE-HMO
CLMCLM-4301482026-08-02T16:27:37ZMariana—Lee1985-09-17N/AN/A7968016848-3457 Central AveSan DiegoCA92144GRP-2514SELECT-EPO
CLMCLM-4050052026-01-19T09:56:52ZraymondWgreene1961-03-25UHC-85120-03N/A(967) 742-5859——-—UNKNOWNGRP-1811··—
CLMCLM-4095632026-05-27T17:07:00ZBerry, Carolyn——03/20/1961UHC-09486-83•••-••-3262UNKNOWN—9798 Main StreetSeattleWA98142··NAVIGATE-HMO
CLMCLM-4300422026-07-01T10:22:20ZBLLY—MEDINA1980-05-23UHC-03106-77•••-••-3492—-2742 CHURCH ST #462JacksonvilleFL32293null·UNKNOWN
CLMCLM-431718 2026-01-25T09:09:50ZMARIAMARMSTRONG12/24/1955UHC2289517•••-••-5822NULL··maria.armstrong92@outlook.com9894 Ocean Avenue #236JacksonvilleFL32211UNKNOWNnull
CLMCLM-4200932026-09-16T23:27:08ZJANET—HARRYS1998-10-06UHC-03351-82··N/A-NULLNULLUNKNOWN———
CLMCLM-4327052026-06-17T02:58:28ZpatrickWwells1969-09-19UHC-81827-11———null—nullNULL—MEDICARE-ADV-B
CLMCLM-4120462026-06-09T22:27:13ZMichael—Bishop5/8/1941uhc-40617-39UNKNOWN2478581256·UNKNOWN5310 Lincoln WayTempeAZ85231GRP-1717··CORE-HMO
CLMCLM-4184292026-04-03T09:20:23ZDiegoTSnyder19490827··—·NULL-N/AN/ANULL——GRP-4024·NAVIGATE-HMO
CLMCLM-4125962026-05-26T15:13:35Zkathy—brown14-08-1994NULLN/A—N/A3092 SAGE COURTOrlandoflNULL·GRP-9243—
CLMCLM-4129062026-08-12T02:24:01ZDominguez, Ryan——Sep 20, 1939UHC-98592-45UNKNOWN7269162865UNKNOWN3654 HILLCREST RDTempeAZ·85212—null
CLMCLM-4213042026-09-10T11:30:25ZChristineU.Ferguson2003-09-16UHC-41567-67•••-••-9415NULL—541 Sage CtFresnoCA93728—····
CLMCLM-4138772026-04-05T16:05:07ZHENRY—REYNOLDS19641026·UHC-48672-91•••-••-3992499-248-4591——UNKNOWN—N/A·GRP-5359CORE-HMO
CLMCLM-4275452026-08-26T03:50:55ZJoe—Hicks13-10-1963N/A—+1 271 587 6951null3667 Meadow Ln #746PhoenixAZ·85003—·-
CLMCLM-4203962026-07-07T08:49:37ZChristan—Simons1942-08-17UHC-34681-43—6412799627N/A2759 Main StAtlantaGA··30335UNKNOWNnull
CLMCLM-4156872026-04-12T10:29:56ZJORDAN——16-06-2001-N/A--3494 Elm StSan DiegoCA92135GRP-0489—
CLMCLM-422811 2026-02-01T10:57:56ZCHRISTINAHBURKE20040526UHC-98836-19UNKNOWN—UNKNOWN7100 HIGHLAND AVECharlotteNC···28298····null
CLMCLM-4254712026-06-05T06:19:42ZDIANA—HOWELLSep 28, 1946··UHC-87462-48UNKNOWN+1 782 551 7719NULL6018 APACHE BOULEVARDDallasTX75236GRP-9859·SELECT-EPO
CLMCLM-4185942026-03-04T02:54:26ZJessica—Adams1961-07-22—NULL(436) 955-0598—1007 Oak StreetColumbusOH43251——
CLMCLM-4309502026-09-24T00:13:13Z Timothy—Robinson19840120—•••-••-7997(609) 241-8586-·2406 MAPLE AVEMiamiFL-GRP-4415·-
CLMCLM-4073082026-06-11T06:29:06ZWatson, Rachel——09/23/1942UHC-77213-11•••-••-6057UNKNOWN··1928 CAMELBACK ROADSAN DIEGOCA92132GRP-6871null
CLMCLM-4052012026-06-03T10:30:03ZJohn—Deniels03/14/64UHC-60949-65UNKNOWN(582) 927-2496N/A5533 Central AveSAN ANTONIOTX78225—null
CLMCLM-4265012026-08-12T02:49:30ZGregory—Alvarez1982-03-27UHC-67391-14N/A··-null1067 Oak St #230TempeAZ-UNKNOWN—
CLMCLM-4322672026-03-14T20:35:35ZKyleQWells1988-04-04UHC-72557-18UNKNOWN17323738105—5026 Sage CourtSacramentoCANULL—MEDICARE-ADV-A··
CLMCLM-4163472026-08-01T06:32:02ZArjun—Anderson2006-04-21UHC-43813-38•••-••-7790-····7072 Desert Sky Boulevard Apt 18AUSTINTX—GRP-2226N/A
CLMCLM-4071632026-03-13T22:39:30ZRYANMDUNCAN2002-11-20UHC3065774N/Anull—8674 Willow CtPLANOTX75024GRP-3170CHOICE-PLUS-PPO
CLM CLM-4083012026-03-02T05:12:23ZMichelle—Jensen0205-04-02—•••-••-3961-·N/A311 Park PlNashvilleTN37217·GRP-1901CHOICE-PLUS-PPO
CLMCLM-4033422026-02-28T01:14:00ZRachel····GonzalezOct 17, 1973UHC-89828-42UNKNOWN—-2830 Valley View DriveOrlandoFL·32893-4455GRP-5449—
CLMCLM-4076152026-10-18T11:36:30ZLuis—Ford2007-10-12UHC-53020-24•••-••-8581(769) 363-5383—·nullUNKNOWNN/A—UNKNOWNUNKNOWN
CLMCLM-4106372026-03-26T15:04:14Zshirley—alvarez1998-01-12UHC-08145-31—-NULL8606 LAKE VIEW ROADDALLASTX75218GRP-9264NULL
CLMCLM-4295582026-01-14T04:50:42ZALEIS··ELLIOTT1987-05-15UHC-17159-14null—N/A1711 Canyon RdTempeAZ85260——
CLMCLM-4081282026-08-07T20:44:15ZCHRISTIAN—ROMERO02/08/57—null····-3506 Ridge RoadDallasTX75215-NAVIGATE-HMO
32,829 rows, page 136 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.315Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty