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-4117772026-01-06T10:03:54ZLaura—Ruiz1990-01-04—•••-••-9555nullnull2480 Elm StreetPlanoTX75030GRP-7996CHOICE-PLUS-PPO
CLMCLM-4014142026-09-13T14:31:18ZNathan—Montgomery4/18/2000UHC-06179-36UNKNOWN979-550-0880N/A1072 Pine DrivePhoenixArizona85053null—
CLMCLM-4312892026-09-07T09:58:26ZRoyU.Ortiz04/07/95UHC-61154-15•••-••-16077566682215ROY.ORTIZ28@HOTMAIL.COM6507 Bayshore DriveAustinTX78737GRP-7783null
CLMCLM-4132172026-06-19T10:44:29ZMaldonado, MarkF.—6/11/1990··UHC0758891•••-••-7295(533) 513-9184mark.maldonado@icloud.com925 Central AvenueEDEN PRAIRIEMN55325GRP-1135UNKNOWN
CLMCLM-4190522026-07-30T07:29:50ZBrandonVKennedy2007-03-50··null-·+1 570 418 3417—N/A-··nullN/A—N/A
CLMCLM-4233832026-04-16T23:58:43ZSean·IGuerrero1950-04-09·UHC7819888—366-936-1407UNKNOWN86 Market StreetTampa··FL··33617—NAVIGATE-HMO
CLMCLM-4155132026-08-17T04:11:27ZOLIVIA—PARKER1982-07-27—UNKNOWN+1 607 977 7656———N/A··GRP-4741NAVIGATE-HMO
CLMCLM-4213382026-02-23T11:29:22ZSTEPHANIE—ALVARADO1994-11-24—•••-••-2016921-791-9909—7956 CAMELBACK RDLAS VEGASNV89197GRP-6826····
CLMCLM-4170092026-02-02T08:10:42ZCharles—Porter2004-04-09UHC-37973-20··-·NULLN/A9313 Forest AvenueSacramentoCalifornia95829—OPTIONS-PPO
CLMCLM-4013872026-06-02T02:24:49ZGrant, Katherine——Apr 28, 2008N/A··—(343) 978-2209null7447 Valley View DriveTempeAZ·85289GRP-6993-
CLMCLM-4282132026-04-30T22:46:44ZCarlGMurray1/19/1998UHC-43401-37—(885) 787-4803—1170 ELM STREETPhoenixAZ85048GRP-7951CHOICE-PLUS-PPO
CLMCLM-4274602026-04-05T15:26:28ZLoriU.Ellis10/21/1947UHC-66036-03null664-784-1979··—7470 Bayshore DriveScottsdaleAZUNKNOWNnull—
CLMCLM-405381 2026-05-12T10:20:02ZAnthony····Banks1996-05-13UHC-83550-98UNKNOWN———··—-GRP-4419MEDICARE-ADV-B
CLMCLM-4128262026-07-27T14:25:05ZTHOMAS··LRSOE1951-06-06UHC-81794-28—935-235-9096——·-—··GRP-6828CORE-HMO
CLMCLM-4297192026-09-13T03:00:47ZDaniel··Martinez··May 21, 1964nullnull9676271166—NULL——null—MEDICARE-ADV-A
CLMCLM-4222332026-03-30T05:35:23ZPatrick··—Phillips08-04-2007-•••-••-81607923964622-1604 Church StreetChandlerAZ85262—CORE-HMO
CLMCLM-4221652026-06-29T13:31:30ZBILLYRCOLLINS19410606NULL•••-••-0654UNKNOWNnull1834 MOUNTAIN VIEW DRAustinTX78762GRP-1665MEDICARE-ADV-A··
CLMCLM-4142992026-04-04T18:09:36Z MARILYN—HICKS02/26/43UHC-38790-56•••-••-4656·202-989-0959null·4833 Mountain View Drive Apt 30Austin·TX78799—CHOICE-PLUS-PPO
CLMCLM-4073862026-04-09T01:32:21ZKatherine—James2001-09-14·UHC-01774-66•••-••-5880-UNKNOWN6636 Highland AvenueMiamiFL33180-7593nullnull
CLMCLM-4177002026-01-18T12:33:46ZNOAH—ROGERS1958-04-08——8824235999—NULL———nulloptions-ppo··
CLMCLM-4123082026-08-01T16:34:55ZRichardson, AngelaT—1947-10-24UHC-54092-76-—null7082 Oak StreetHoustonTexas77046GRP-8505·NULL
CLMCLM-4304152026-08-17T00:38:46ZValentina—Guerrero··1977-09-18—•••-••-1057(568) 666-8856—7765 Grand AvenueColumbusOH43232GRP-1522OPTIONS-PPO
CLM CLM-4036592026-09-21T06:21:47ZMelissa—Kennedy10-04-1958uhc-01988-89N/A568-277-1981melissa.kennedy@yahoo.com————NULLMEDICARE-ADV-B
CLMCLM-4105202026-06-18T06:04:11ZEvelyn··—West12/24/1995UHC-84463-14•••-••-6952NULLUNKNOWN1337 FOREST AVENUETempeArizonaNULLGRP-5684—
CLMCLM-4142412026-03-26T09:06:53ZGabrielB.·Roberts20-03-1981UHC7071512•••-••-7165NULLNULL5611 MAPLE AVENashvilleTN—GRP-6060NAVIGATE-HMO
CLMCLM-4126282026-07-21T18:24:49ZPatriciaZWheeler05/13/1939UHC-82575-80•••-••-3591NULL—3054 Oak StSAN DIEGOCA92195GRP-6649·null
CLMCLM-4287412026-05-22T09:55:21ZHenry····Roberts1978-07-12—•••-••-7925—-2952 MOUNTAIN VIEW DRIVESan DiegoCA92112——
CLMCLM-4133062026-02-23T06:27:59ZLisa—Hicks1984-01-14UHC-45936-13•••-••-8029——8771 Apache BoulevardSeattleWA98161··GRP-1397MEDICARE-ADV-B
CLMCLM-4158512026-10-12T06:30:56ZSean—Olson1989-11-15UHC9246420null-—9155 BROADWAYDallasTX—GRP-5645CORE-HMO
CLMCLM-4021842026-07-06T02:55:04ZBilly—Cunningham24-08-1973UHC-53069-58UNKNOWN904-464-2670NULL7671 Jefferson AvenueMiami··FL33140—UNKNOWN
CLMCLM-4020002026-03-20T05:16:07ZAnnaU.—1956-08-26UHC4436931··•••-••-6801507.441.5820UNKNOWN8585 Desert Sky Boulevard··San Antoniotx78276GRP-1713-
CLMCLM-4325542026-08-20T01:02:22ZSandra—Sccott··1974-11-01·UNKNOWN•••-••-9878—·NULL3389 HARBOR BLVD·Las VegasNevada·89158GRP-3178—
CLMCLM-4247872026-10-14T02:50:44ZCAMILA····COLEEMAN1960-01-21UHC3028702····(810) 571-0688N/A2961 Cedar LnTampa··FL33609——
CLMCLM-4111532026-06-09T12:56:42ZMegan—Burrke11-06-1940UHC-10284-69NULL+1 524 584 4456null5123 Camelback RdPhoenixAZ85099GRP-5754··UNKNOWN
CLMCLM-4252292026-06-16T14:11:58ZJoseEPalmer1955-11-10UHC-11588-68•••-••-1741null—61 Meadow LaneLos AngelesCA90084nullOPTIONS-PPO
CLMCLM-4043592026-08-27T09:46:17ZRachel··—Payne1597-01-22null•••-••-7521N/AUNKNOWNN/AUNKNOWN——nullMEDICARE-ADV-A
CLMCLM-4037912026-07-23T08:53:54ZWilliamOWard19840517UHC-96074-07•••-••-9851(743) 422-0103WILLIAM.WARD@ICLOUD.COM··5716 Mountain View DrHoustonTXNULLGRP-7332N/A
CLMCLM-4064542026-01-15T12:23:08ZGrace—Medina2001-09-27——691-986-3663-—N/A—null—null
CLMCLM-4046552026-08-13T11:33:39ZALEXANDER—ALLEN1972-06-07UHC-21630-34UNKNOWNNULLalexander.allen@outlook.com6316 SPRING STTUCSONAZ85713GRP-2594MEDICARE-ADV-A
CLMCLM-4255222026-04-08T07:33:26Z·JEANL.KENNEDY·1943-08-20UHC4123429null19806639181NULL3458 Maple AvenuePhoenixAZ85033GRP-4644core-hmo
CLMCLM-419515 2026-08-31T04:50:40ZCAMILA—·JENSEN11/25/1949UHC-66295-51--N/A-—null-GRP-2498CORE-HMO
CLMCLM-4113202026-10-11T23:07:07Z·Betty—Rojas12/27/76UHC-59588-79····N/Abetty.rojas@yahoo.comN/AUNKNOWNUNKNOWNNULLGRP-2268UNKNOWN
CLMCLM-4239422026-03-27T02:35:11ZHANNAH—WARD1997-01-01UHC-07354-59—+1 485 594 7776NULL4451 MESA DRFresnoCA93701GRP-6689—
CLMCLM-4218022026-01-22T08:03:28ZNatalie—·Mason1992-08-24UHC-07376-13-NULLN/A3166 Market StLas VegasNV89179NULLCHOICE-PLUS-PPO
CLMCLM-4098802026-05-13T15:18:54ZBRUCE—ALVAREZ1981-05-04UHC-31238-59N/A242-583-6681—····nullNULLN/AGRP-6343null
CLMCLM-4002322026-03-12T01:58:46ZAustin—Stone··1949-11-17—•••-••-5740·462.553.0574—4169 JEFFERSON AVENUEChandlerAZ85252——
CLMCLM-4019332026-06-06T05:05:35Zkyle—guzman1996-03-24UHC-29349-66•••-••-7159N/A—9740 Valley View DrDenverCO80268··GRP-9547—
CLMCLM-406898 2026-09-06T07:18:36ZBARBARA—HANSON1953-04-02UHC-41769-76···368-536-7118—4855 Willow CtAustinTX—GRP-1211—
CLMCLM-4247212026-05-08T04:53:38ZJoan—Weber1940-06-07UHC-41593-57null—joan.weber@outlook.com2151 Canyon RdLos AngelesCA90083GRP-5854····
CLMCLM-4051612026-06-15T13:16:07ZGeorge—Franklin·06/09/64UHC-98768-47•••-••-7913587-368-4956—4658 Indian School RdSan DiegoCANULLnull—
32,829 rows, page 43 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:36.691Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty