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
CLM CLM-4001652026-07-17T05:32:31ZCharlotte··—Wheeler··3/13/1964UHC-02876-57—(674) 537-3346NULL·8961 PARK PLACESacramentoCA95844GRP-2235NAVIGATE-HMO
CLMCLM-4070152026-08-01T01:54:03ZjesseR·hudson1973-08-21UHC-83954-38•••-••-7067(800) 692-8238—····UNKNOWN—··GRP-9518OPTIONS-PPO
CLMCLM-4028642026-09-16T13:31:46ZMARILYN—CARPENTER1948-02-24··—•••-••-9457305-527-6415-N/AUNKNOWN··—N/AGRP-5607CHOICE-PLUS-PPO
CLMCLM-4020482026-01-03T15:41:58ZStephanie—Allen1995-11-20UHC-51810-47—·+1 621 371 8519—8645 APACHE BOULEVARDTEMPEaz85210-6293NULLnull
CLMCLM-4190272026-08-29T03:07:29ZReyes—Bradley1994-11-12UHC-33181-94··N/A·2058831363—7930 Harbor BoulevardGlendaleAZ85330—UNKNOWN
CLMCLM-4121272026-10-09T13:10:48ZCarlosHScott··1958-11-07UHC-31563-59N/AUNKNOWNnull—NULL··NULLnullGRP-7670UNKNOWN
CLMCLM-4269172026-05-02T21:01:53ZJUANENUNEZ··1952-05-23UHC-78483-83•••-••-8262—NULL8263 CAMELBACK ROADTempeAZ85266GRP-8364·N/A
CLMCLM-4316082026-06-15T15:31:59ZMaria—Chavez03-06-1990-··(564) 958-6367null·8628 Camelback RdMiamiFL33146···GRP-3269CHOICE-PLUS-PPO
CLMCLM-4036882026-09-09T10:23:59ZVALENTINA—GONZALEZ··19950913——8498772297————UNKNOWNGRP-9579··CHOICE-PLUS-PPO··
CLMCLM-4217962026-10-12T13:15:54ZKatleen—Tran1975-04-20N/ANULLN/Anull—UNKNOWNN/A-N/Anull
CLMCLM-4315662026-01-29T08:14:42ZLawrenceJ.Davis1987-06-12··—null—9021 Highland AvenuePlanoTX75027—null
CLMCLM-4254802026-05-31T14:38:13Z BOBBY—NELSONFeb 11, 1951UHC-69366-19—NULL—1327 Willow Court··Los AngelesCA90060GRP-3132CHOICE-PLUS-PPO
CLMCLM-4136142026-10-05T01:32:51ZGerald··—Gordon2/23/1986-UNKNOWNNULLN/A3242 Washington StORLANDOFL32807GRP-2413··
CLMCLM-4003282026-01-25T14:08:26ZRebecca···Little1/15/1941UHC-55146-08UNKNOWN···(521) 490-9740null7903 DESERT SKY BLVDAUSTINTX78722GRP-6590CHOICE-PLUS-PPO
CLMCLM-4172332026-08-02T03:04:56Z Charles—Butler12/12/1971·UHC-81045-69•••-••-4821(829) 514-6067N/A4407 Harbor BoulevardTucsonAZ85718-1488GRP-9536NAVIGATE-HMO
CLM CLM-4039872026-08-19T15:34:15ZCYNTHIA··—BURTON1960-07-26-NULL5116006211··cynthia.burton13@proton.me-··NULLNULL—GRP-9390null
CLMCLM-4011312026-10-15T21:18:13ZTorres, Adam——1994-02-07UHC-94361-64N/A··—NULL24 Jefferson AvenueFresnoCA93790—core-hmo
CLMCLM-400104 2026-09-17T10:18:08ZCynthia—Ferguson1966-05-13UHC-28004-29null6735586114··884 ELM STSeattleWA98172GRP-7507MEDICARE-ADV-B
CLMCLM-4008642026-10-14T22:03:35ZJOAN··—LANE03/16/1949UHC-13637-61—NULLnull··573 WILLOW CTPlanoTX··75001··GRP-1519CHOICE-PLUS-PPO
CLMCLM-4178792026-08-16T18:58:54ZNathan—Cole27-07-1958·UHC-77282-78•••-••-4633—nathan.cole53@aol.com2325 PARK PLAustinTX··78748GRP-4125NULL
CLMCLM-4175332026-05-31T21:37:06ZSalazar, Walteer—···04-12-1984UHC-43435-44•••-••-5136(732) 925-8370——N/A—-UNKNOWN··SELECT-EPO
CLMCLM-4315732026-05-27T13:20:41ZWright, Catherine——1951-22-03—•••-••-6025····—4260 LAKE VIEW ROADJacksonvilleFL32256GRP-4594-
CLMCLM-4190542026-01-17T11:58:31ZRandy—Flores1949-04-14·UHC-96097-03•••-••-6876+1 887 972 8592null9683 INDIAN SCHOOL RD Apt 4OrlandoFL32876GRP-8784MEDICARE-ADV-A
CLMCLM-4096512026-06-17T06:22:24ZWei—Jenkins1/1/1985UHC-07937-89NULL··625-761-6400UNKNOWN2854 Elm StreetNashvilleTN37253GRP-9392NULL
CLMCLM-4222882026-01-14T07:14:55ZMarthaZParkerSep 26, 1991UHC-73620-42——··236 MARKET STGlendaleArizona85347GRP-3242MEDICARE-ADV-B
CLMCLM-4175102026-01-07T21:09:59ZHiroshi··EMeyer1988-10-03UHC-79807-84N/A5259453638-3492 Willow CtAustinTX78723GRP-9065UNKNOWN
CLMCLM-4188362026-04-04T14:42:18ZDonna····Washington2003-04-25UHC-43146-50——NULL3281 Valley View DrGlendaleAZ85338—OPTIONS-PPO··
CLMCLM-4210172026-09-15T14:59:26ZJoyce—Rodriguez1961-10-22UHC5969327—+1 545 391 2666—1800 River RoadGILBERT··AZ85270—-
CLMCLM-4118792026-06-23T20:08:21ZAmanda—Richards1978-03-09UHC-87362-49UNKNOWN(690) 546-2200UNKNOWN1062 River RdCHANDLERAZ85203——
CLMCLM-4310012026-02-24T02:01:37ZJudyD.··Oliver··1939-04-05UHC-16714-15-(607) 556-4845—9763 HARBOR BLVDPlanoTX75089-2668—MEDICARE-ADV-A
CLMCLM-4211972026-04-02T03:19:51ZMadison····Guzman2008-05-25—NULL345-630-6055null9638 Park PlGlendaleAZ85311GRP-6721navigate-hmo
CLMCLM-4294532026-07-19T05:53:52ZWAYNE—LUCAS03/12/83·UHC-83195-72······—7615 INDIAN SCHOOL ROAD··FRESNOCAnullnullCHOICE-PLUS-PPO
CLMCLM-4109972026-05-30T19:25:53ZMateo, Alvarez——1941-05-08UHC-77283-62•••-••-11805894644929NULL8785 MEADOW LANE··Los AngelesCA90084GRP-1296NAVIGATE-HMO
CLMCLM-4161712026-02-25T21:58:33ZArjun—Torres1986-04-21UHC-50680-83—UNKNOWNNULL·4920 Cedar LaneOrlandoFL32805GRP-8115SELECT-EPO
CLMCLM-4182162026-06-08T02:35:23ZJanet····Reyes1951-06-01UHC-74672-84•••-••-7221UNKNOWN—UNKNOWN-NULLnullGRP-7813MEDICARE-ADV-A
CLMCLM-4087572026-02-26T01:42:23ZTymothy—Weber2001-09-27nullN/A—timothy.weber74@aol.com··3400 PARK PLACEScottsdaleAZ85228—N/A
CLMCLM-4225542026-02-24T23:48:20ZFRANCES—LONG08/23/59··N/AN/A——3267 Park PlaceTucsonAZ85763GRP-5916NAVIGATE-HMO
CLMCLM-4291732026-08-28T20:40:19ZJUDY—MOORE2007-06-13N/A·UNKNOWN—-357 Willow CtCHANDLERAZ85279GRP-5765NULL
CLMCLM-4163752026-08-25T05:45:36ZTHERESA—LITTLE1983-02-08UHC-38411-98NULL316-592-8045-N/AN/AUNKNOWNnull··——
CLMCLM-4205282026-06-02T04:38:10ZFrances—Brown2004-12-05UHC-25113-79NULLUNKNOWN—3236 Washington StAtlantaGA30318—CHOICE-PLUS-PPO
CLMCLM-4043472026-10-10T02:31:41ZJudy—Rose1960-02-14UHC-80661-85-nullnull1226 Highland AveSacramentoCA95865GRP-0944null
CLMCLM-4314452026-01-04T08:27:19ZEMILY—HENDERSON1966-08-08··UHC-81453-36—NULLNULL3328 Church StSan DiegoCA92107null—
CLMCLM-4249142026-06-15T18:40:26ZIsabella—Hart··1975-03-17UHC-19333-94N/A——4604 JEFFERSON AVENUEGlendaleAZ85372UNKNOWNNULL
CLMCLM-4052022026-02-16T07:48:50ZDanielleF.Schultz19460904UHC-69678-97—null—9873 Mesa DrMiamiFL33120GRP-2489··-
CLMCLM-4005372026-02-14T06:31:39ZMariaFChavezOct 15, 1999UHC-84323-11•••-••-7377(228) 628-3880—3624 Union StLas VegasNV89105GRP-6062null
CLMCLM-4048842026-05-14T01:19:00Z Amber—Robinson2006-08-07-—null-nullN/ANULL—-NULL
CLMCLM-4178712026-09-01T12:07:13ZDANIELLE—CARTER·10/04/1959UHC-75129-77nullNULLNULL8020 Highland AveAtlantaGA30358-4324GRP-7294NAVIGATE-HMO
CLMCLM-4085122026-01-02T09:36:15ZBobby—Dominguez·20051221·UHC-26590-88•••-••-0667-··UNKNOWN—null-——····
CLMCLM-403847 2026-08-03T04:41:57ZFatima—Green1971-01-19UHC-56858-96•••-••-8403(897) 585-5235N/A764 River RoadMinneapolis·MN55442GRP-5477·NULL
CLMCLM-4215022026-08-27T17:28:07ZJams—Ruiz1964-01-24UHC-52381-87—536.307.0659N/A7819 Spring StJacksonvilleFL32203nullMEDICARE-ADV-A
32,829 rows, page 198 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:43.416Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty