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-4274642026-05-25T18:17:05Z Jacqueline—Bennett91770705UHC-63718-39——NULL5967 WASHINGTON STTempeArizona85271GRP-6412OPTIONS-PPO
CLMCLM-4032982026-10-17T03:11:31ZVincent—Hanson1943-12-03——UNKNOWNvincent.hanson@proton.me6526 Camelback Road·Atlanta·GA30302GRP-9473OPTIONS-PPO
CLMCLM-4108502026-02-23T19:26:08ZCharlotte—Kenneedy2008-01-59UHC-67859-40·--charlotte.kennedy28@proton.me1168 Apache BoulevardSan DiegoCA92146N/Anull
CLMCLM-4146242026-02-19T21:22:27ZKATHY—ANDRWS1960-05-22··UHC-09149-87··•••-••-0342(309) 208-0763NULL4573 Baseline RoadPHOENIXAZ85036GRP-7974NULL
CLMCLM-4253672026-08-01T14:41:33ZAaron—Edwards19980207UHC-34450-15NULL8052525027—6545 Pine DrNashville··TN37254GRP-0914—
CLMCLM-4093782026-02-26T01:22:09ZVazquez, Michael——19870309·UHC-05778-78NULL14785078993··null—-UNKNOWNUNKNOWNMEDICARE-ADV-A
CLMCLM-4175952026-03-26T10:49:17ZRAYMOND—REYES··11/14/1971·UHC-12708-34·-—RAYMOND.REYES31@HOTMAIL.COM5870 LINCOLN WAYDenverCO80290GRP-9767CORE-HMO
CLMCLM-4194432026-10-08T00:57:42ZJoe··—Bishop1961-60-26UHC-58513-77•••-••-7231-NULL1154 Forest AvenueEden PrairieMinnesota··55387GRP-5100UNKNOWN
CLMCLM-4184932026-05-01T09:36:42ZALEXANDER—PORTER1964-02-56—-2322803488null5975 Pine DrChandlerAZ85274GRP-9376CORE-HMO··
CLMCLM-4032282026-04-03T16:04:16ZMEAGN—PERKINS1985-09-03UHC-28097-08UNKNOWN966-558-0892—3220 CAMELBACK RDSeattleWA98196GRP-2327UNKNOWN
CLMCLM-4177042026-03-15T07:54:41ZBrandon—Dixon·Jul 20, 1978UHC-95071-91—+1 807 455 6861····9110 Central AveTampa·FloridaUNKNOWN··GRP-0948·CHOICE-PLUS-PPO
CLMCLM-4242592026-02-13T06:59:18ZJeffreyORiley1946-11-14UHC-25017-03UNKNOWN8589427856UNKNOWN7277 PARK PLACEChandlerAZ85234-MEDICARE-ADV-B
CLMCLM-4100182026-06-17T08:43:59ZJOSEPH—FOWLER1950-08-18UHC-38879-72—N/A-7897 Elm StreetMiamiFL··33154GRP-7153-
CLMCLM-4282902026-09-07T09:07:17ZGregory—·Cruz1974-01-27UHC-66888-17•••-••-2655986.584.3553N/A5351 Market St Apt 25JACKSONVILLEFlorida32255—null
CLMCLM-4087502026-03-22T16:12:24Z Patricia—·Gomez10/24/1940UHC-71807-52-2928418674null3964 HIGHLAND AVENUEScottsdaleArizona85299GRP-8072SELECT-EPO
CLMCLM-4260772026-09-08T00:56:22Zlauren—peters1984-07-16UHC-23575-28—N/ANULL1420 OAK ST··GLENDALE·AZ85392-9012GRP-3865UNKNOWN
CLMCLM-4247742026-02-27T10:57:15ZMarianaA·Kennedy1945-03-07UHC-43232-55N/A3472412162MARIANA.KENNEDY@GMAIL.COM6653 OCEAN AVENashvilleTN37240GRP-2504CORE-HMO
CLMCLM-4191232026-02-01T11:10:37ZSOTOMRAYMOND1970-08-18-•••-••-0168(936) 422-0707··9722 Spring StreetTUCSONAZ85765—NULL
CLMCLM-4079442026-05-07T05:29:57ZHill, Jeremy——12/10/1999UHC-25891-17N/A-·NULLNULLNULLNULLnullN/AMEDICARE-ADV-B
CLMCLM-4038522026-05-30T06:09:10ZLarry··Arnold1/1/1978null•••-••-6256NULL—1043 OCEAN AVENUETucsonAZ85745GRP-4286OPTIONS-PPO
CLMCLM-4088632026-09-29T10:00:57Zjerry··—crawford03-07-1980UHC-60376-73•••-••-31729117180729——null···N/A—GRP-6614OPTIONS-PPO
CLMCLM-4104112026-04-30T08:39:26ZTERESA—MYERS19660512—null4334858991teresa.myers46@proton.me3439 Pine DrTucsonAZ85763N/A—
CLMCLM-4158162026-08-29T16:48:30ZpatriciaM.payne2003-11-14UHC-57067-49··NULLNULL—4502 Cedar LaneMinneapolisMN55427-4551—NULL
CLMCLM-4048892026-03-06T15:27:45ZZacharySSimpson1941-12-20——12206057706—4120 Lake View RoadMesa·AZ85243GRP-5525SELECT-EPO
CLMCLM-4188482026-05-31T08:18:04ZJEREMY····HARVEY1996-07-23··—•••-••-8494N/AN/A8130 JEFFERSON AVEHoustontx77040GRP-9006NAVIGATE-HMO
CLMCLM-4050572026-08-13T02:35:13Zashley—morrison09/22/1987UHC-68018-38UNKNOWN-UNKNOWNNULL—UNKNOWNnullGRP-8099SELECT-EPO
CLMCLM-431633 2026-09-20T16:09:04ZRobert—Wager1983-01-15·UHC-47936-01•••-••-6829(339) 811-7142N/A3375 Palm DrSacramentoCA95829N/A·CORE-HMO
CLMCLM-4069842026-01-28T18:41:07ZNatalieC.Greene18-06-1994UHC-30098-68•••-••-89684132333035··2081 APACHE BOULEVARDJacksonville··FL32259GRP-3797select-epo
CLMCLM-4004852026-08-03T02:02:22ZAndrea—Jordan19381218UHC-03898-53··-nullnullUNKNOWNNULL——GRP-6852OPTIONS-PPO
CLMCLM-4046682026-02-09T03:50:26ZMargaret—Smith01/15/76UHC-25071-63•••-••-5006334-259-1824null1446 Ridge RdCHANDLERAZ—GRP-4715OPTIONS-PPO
CLMCLM-4165652026-10-16T09:00:30ZJOSE·N.VEGA20070823UHC-35189-94null-—NULL——·null-CORE-HMO
CLMCLM-4167632026-09-25T21:24:04Z·AISHA—BALEY03/09/93UHC-32930-20•••-••-4405(672) 396-9448-3532 Highland AveAustinTX78703··NULLmedicare-adv-a
CLMCLM-4035622026-06-03T08:27:30ZCheryl·KFernandez1993-06-17UHC-03714-35———6716 FOREST AVENUEMiami·fl33133—CORE-HMO
CLMCLM-4189352026-05-20T13:42:13ZJimenez, Helen—··9175-09-22UHC7326749null——·6644 MESA DRIVEFresnoCA93797GRP-9025null
CLMCLM-4225072026-03-28T09:18:05ZWILLIEV.··HAYES1946-01-27—UNKNOWN928.220.6708—9064 River RoadPhoenixAZ85026N/ANAVIGATE-HMO
CLMCLM-4187842026-04-03T17:10:40ZKATHRYN—COLLINS27-12-1973UHC-56200-39nullN/A—1909 CANYON ROADDenver·CO80250GRP-9651NAVIGATE-HMO
CLMCLM-4238592026-09-08T23:02:55ZBilly—BrownDec 4, 1977UHC-09978-13UNKNOWN-—-UNKNOWNNULL·nullGRP-0136OPTIONS-PPO
CLMCLM-4047072026-02-11T05:17:53ZEspinoza, YukiX.····1951-06-16—UNKNOWN2243679502—387 Harbor BlvdCharlotteNC28206-6961N/ACORE-HMO
CLMCLM-4097922026-04-04T11:59:56ZJacquelineZWebb1940-04-10—•••-••-9367248-268-6027—9796 Washington StColumbusOhio43259NULL—
CLMCLM-4082032026-07-25T17:23:42ZSARAHGBARNES1992-05-16UHC-17925-71—--NULL——N/AGRP-1659MEDICARE-ADV-B
CLMCLM-4302252026-05-12T15:13:29ZJUDITH—DELGADO05/25/1972UHC-80944-63--·UNKNOWN6836 Camelback RdLos AngelesCalifornia·90065—UNKNOWN
CLMCLM-4218332026-06-15T11:53:12Z Larry—Hanson1959-07-28UNKNOWN—-NULL5391 Mountain View DriveSeattleWA98133GRP-2378-
CLMCLM-4282392026-05-07T02:23:34ZVincent—Griffin1961-02-10UHC-89458-72•••-••-3791null—2161 CENTRAL AVEMinneapolisMN55424GRP-3639SELECT-EPO
CLMCLM-4263232026-03-06T04:17:11ZGloria····Guzman1939-05-23··N/A··N/A—5838 PINE DRIVEGlendaleArizona85394nullN/A
CLMCLM-4088812026-07-30T15:08:48ZMARIANADREYNOLDS··1962-01-32UHC-70487-07UNKNOWNN/A····5259 PALM DRPhoenixAZ85038—CORE-HMO
CLMCLM-4245542026-01-08T07:03:43ZSantiago—Franklin1954-10-10null•••-••-3107959-917-9021null6914 OAK STREETMesaArizona85299UNKNOWN—
CLMCLM-4288832026-09-23T10:33:57Z·Austin—Garcia7/16/1972UHC-61676-05•••-••-11985404448463-8689 Meadow Ln Apt 33·SacramentoCA95863GRP-1300··—
CLMCLM-4169732026-06-27T22:13:32Zjose—williamson1947-04-24null•••-••-9150517-724-3856N/A6243 RIDGE ROADTUCSONAZ85751····MEDICARE-ADV-B
CLMCLM-4246102026-04-03T13:32:23ZSAMUEL····BISHOP1973-11-16UHC-34213-31—(763) 821-6000—5173 Desert Sky BoulevardGilbertAZ·85207—UNKNOWN
CLMCLM-4039572026-09-04T23:23:30ZEric—MyersAug 4, 1978UHC-64051-96—NULLUNKNOWN-———GRP-4558—
32,829 rows, page 185 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.626Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty