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-4192382026-07-21T14:13:11ZSAMUELKDANIELS1987-06-15UHC-88956-84•••-••-9324—UNKNOWN423 Ocean AveSeattleWA98180N/ANAVIGATE-HMO
CLMCLM-4039772026-03-09T10:47:35Zdaniel—white1994-09-26UHC-97483-98-null—NULL—N/AnullGRP-7334UNKNOWN
CLMCLM-4078762026-03-23T21:59:07Z·Arnold, Mari——19860313UHC-85249-31•••-••-6371——UNKNOWNNULLUNKNOWN—nullNAVIGATE-HMO
CLMCLM-4118052026-10-10T22:59:36ZKeithJBell10-12-1942UHC-34516-56null··——2197 Oak St Apt 8Eden Prairie·MN55370GRP-3984MEDICARE-ADV-B
CLMCLM-4306312026-04-22T17:49:42ZWillie—Soto2006-09-19UHC-53600-87UNKNOWN9745816681-8204 Central AvenueSCOTTSDALEAZ85249—NAVIGATE-HMO
CLMCLM-4265472026-09-24T04:10:29ZDoris—McDonald1956-04-19—-UNKNOWN--——NULLNULLCORE-HMO
CLMCLM-4113942026-03-31T08:40:14ZChristinaIGuzman27-07-2000·UHC-18324-39UNKNOWN304-903-6070-——N/A———
CLMCLM-4234102026-02-07T07:40:34ZNICOLE—SHAW1945-12-13UHC-95009-85—(989) 426-8957N/A·8639 Indian School RoadGilbertArizona85296nullCORE-HMO··
CLMCLM-428689 2026-08-04T02:51:28ZWalterATucker1976-12-11UHC-36982-74•••-••-449618879136632—7362 Desert Sky BoulevardJacksonvilleFL32253-6147·UNKNOWNSELECT-EPO
CLMCLM-4126322026-02-08T11:08:39Z NANCY—RICHARDSON2006-07-04··uhc-90846-48UNKNOWN—·null8986 Willow CtHoustonTX77006-MEDICARE-ADV-A
CLMCLM-4073752026-04-13T22:16:53Zsantiago—elliott1989-06-01UHC-52585-76•••-••-6574UNKNOWN·null5848 ELM STOrlandoFL32832NULLchoice-plus-ppo
CLMCLM-4237072026-03-13T16:52:09Z Joyce—·Montgomery1959-03-09UHC-22282-57··—····UNKNOWN··UNKNOWN-····GRP-8932select-epo
CLMCLM-4076912026-07-09T12:16:25ZEUGENE··HKELLY1976-07-07UHC-59154-82NULL—-1751 VALLEY VIEW DRIVEMiamiFL33148-8748GRP-1415—
CLMCLM-4056382026-07-20T07:30:09ZSnyder, Brandon—··1968-21-04UHC-55662-93-—brandon.snyder@aol.com8063 PINE DRNASHVILLE··TN37248··—-··
CLMCLM-4058472026-01-11T17:13:01ZLori—Allen1972-01-06UHC-66446-36—16232845986NULL8219 Bayshore DriveDenverCO·80213GRP-2314NULL
CLMCLM-4041502026-04-14T01:16:59ZCrawford, Paul··—1973-04-11UHC-49265-38N/AN/A——null-·N/A—UNKNOWN
CLMCLM-4087002026-08-20T00:23:04ZJACQUELYNEN.··PIERCE1939-11-08UHC-89578-74NULLUNKNOWNjacqueline.pierce5@outlook.comN/A-···-——CORE-HMO
CLMCLM-4152002026-09-16T02:36:57ZSantiago—Padilla11/04/82UHC-48047-31•••-••-57557254187784NULL6082 GRAND AVESAN DIEGO·CA—GRP-7280-
CLMCLM-4071602026-05-05T14:04:00ZDYLAN—STEWART11/13/69UHC-17496-87•••-••-6937——1139 WILLOW CTMesaAZ85254·GRP-5312MEDICARE-ADV-B
CLMCLM-4109262026-03-27T09:24:52ZRachel—WillisDec 3, 1975UHC-19492-19-N/AN/A12 Ocean AveCharlottenc28279-1286nullNAVIGATE-HMO
CLMCLM-4264842026-01-21T12:42:42ZJENNIFERZWILLIAMSON1977-00-12··UHC-04711-37•••-••-6995-JENNIFER.WILLIAMSON35@YAHOO.COM5587 Apache BlvdDenverCO80290GRP-0260CORE-HMO
CLMCLM-4127222026-06-09T01:37:15ZSTEVEN—SCHMIDT1986-09-25UHC-10816-62—UNKNOWNNULL5175 Market StLas VegasNV89123NULL—
CLMCLM-4300972026-06-13T11:46:00Zvalentina·Xwilliams·1982-09-21UHC-42568-28NULL9286512546—NULLN/A—NULLGRP-7325NAVIGATE-HMO
CLMCLM-4153922026-07-09T08:35:51ZMariana—Valdeez11/22/1982-—914-266-6728NULL1961 APACHE BLVDDallasTX75267-3106GRP-8742-
CLMCLM-4045062026-06-04T06:44:26ZNathanWClark1967-04-01UHC-59130-67—15022298147UNKNOWN9074 Hillcrest RoadDenverColorado80202——
CLMCLM-4069722026-02-24T17:37:12ZMargaret··—Anderson1995-02-21UHC-40281-84—731-226-4054—4717 Jefferson Avenue #351MiamiFL·33143N/AMEDICARE-ADV-B
CLMCLM-4290982026-04-02T10:50:09ZEmily—Ramirez12/05/59nullN/A····—2364 BROADWAYTempeArizona85294—CORE-HMO
CLM CLM-4103982026-10-09T01:40:56ZAna—Robinson1955-02-02UHC-45904-17•••-••-1224(487) 986-0691ana.robinson@proton.me3989 Indian School RoadSAN DIEGOCA92142—MEDICARE-ADV-B
CLMCLM-4284422026-01-18T20:05:02ZTeresa—Spencer1995-05-10UHC-23682-43•••-••-2505——5215 Grand AveSAN DIEGOCA92120null··UNKNOWN
CLMCLM-4201312026-06-21T06:10:04ZLawrenceHButler01/19/1997NULL—·(523) 651-0574-UNKNOWN-N/AUNKNOWNGRP-7918··OPTIONS-PPO
CLMCLM-4023842026-10-03T16:21:44ZHeather—Boyd19541026UHC-21223-18UNKNOWNNULLnull—N/A—N/AGRP-4502MEDICARE-ADV-A
CLMCLM-4155272026-05-25T01:37:19ZMeanARios1976-08-25·UHC6858964NULL9348243802—3996 Sage CtDENVERCO··nullnullCORE-HMO
CLMCLM-4266942026-06-14T01:02:42Z Lucia—Turres05/24/1981·UHC1026177—8078860849·NULL7826 WILLOW COURT·ChandlerAZ85240··GRP-8950-
CLM CLM-4321812026-03-07T06:58:46Z Delgado, Helen··——1973-02-22UHC-47049-67•••-••-777914605708794—6734 Grand AveJacksonvilleFL32219NULLCORE-HMO
CLMCLM-4137162026-05-19T00:26:26ZDENISE—HAYES04/27/07UHC-92115-37•••-••-3481····—4768 Mountain View DrSAN ANTONIOTX78254——
CLM CLM-4108972026-06-19T03:44:06ZCHERYL—KENNEDY1982-09-19NULL•••-••-8363null—2547 Washington StreetPLANOTX75005GRP-1743NULL
CLM CLM-4020572026-09-16T21:52:00ZRANDY—BARNES2000-03-03uhc-19730-93N/A240-899-1504-429 Union StreetHoustonTX77094GRP-7137—
CLMCLM-4139092026-04-15T11:25:55Z·Lori··Carter1979-12-12N/A•••-••-3362(540) 633-8501-6789 Maple AveSacramentoCA95812-3903GRP-4603SELECT-EPO
CLM CLM-4137072026-07-14T10:35:01ZSANTIAGO—MOURE1963-11-19N/A—NULL—3960 SPRING STNashvilleTNNULLGRP-2818UNKNOWN
CLMCLM-4227072026-05-06T20:33:10ZZACHARY—OLSONSep 6, 1993UHC-00455-39•••-••-0266-null592 JEFFERSON AVENUECharlotteNorth Carolina28281—NAVIGATE-HMO
CLMCLM-4249292026-03-16T11:28:30ZHenry—·Fisher2005-06-18UHC-12256-45NULL··——nullUNKNOWNNULL—N/A
CLMCLM-4057062026-02-13T22:04:58Zjanice—·hall1988-10-26UHC-51449-87-NULLUNKNOWN2256 Union StHOUSTONTX77077GRP-1648—
CLMCLM-4131172026-10-18T01:44:46ZJohnston, Anthony——1976-01-26UHC3980489•••-••-51342375899084·UNKNOWN6353 Cedar Ln #964Tampafl33619GRP-0814medicare-adv-a
CLMCLM-4272492026-01-26T12:38:35ZJOSHUA—ROSE9/22/1961-····(709) 529-9155—7769 RIDGE ROADMinneapolisMN55456-3704GRP-3638UNKNOWN
CLMCLM-4041172026-05-14T00:41:08ZRaymond—WodDec 17, 1977UHC-43430-18null··+1 413 645 8907—409 Cedar LnLas VegasNV89148GRP-5840—
CLMCLM-4162732026-04-22T00:13:38ZSANTIAGO—JENSEN1992-05-26UHC-40660-07•••-••-624917917563574·UNKNOWN8713 MEADOW LANE Apt 26SeattleWA98137GRP-6666·CORE-HMO
CLMCLM-4202822026-05-18T16:07:34ZMaria—Cox9/1/1940UHC-85402-44•••-••-7836·8355198846NULL49 Highland AvenuePlanoTX75044··GRP-5192UNKNOWN
CLMCLM-4129512026-09-02T07:40:43ZJennifer—Watson20400507··—N/AnullJENNIFER.WATSON@AOL.COM9725 HARBOR BLVDTucson·AZ85783GRP-5669MEDICARE-ADV-A
CLMCLM-4135392026-04-12T02:51:01ZKEITH—WOODS03/22/54UHC-83597-46—+1 262 307 3328N/A8189 River Road #873DenverCO80224NULL····
CLMCLM-4046002026-02-15T23:54:24ZDEBORAH—VAZQUEZ4/8/2002N/ANULL·nulldeborah.vazquez96@proton.me7172 Bayshore DriveTUCSONAZ—nullUNKNOWN
32,829 rows, page 32 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:34.806Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty