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-4059702026-03-15T11:37:38ZLARRY—BOWMAN10/22/1973UNKNOWN•••-••-3001UNKNOWN—1972 Valley View Dr··San Diego··CA··—CHOICE-PLUS-PPO
CLMCLM-4179252026-06-10T02:36:05ZDixon, SeanH··—10/4/2000UHC-62395-04—UNKNOWN··UNKNOWN3247 Mountain View Dr Apt 13Nashville··TN37264GRP-3261navigate-hmo
CLMCLM-4031372026-01-02T13:39:48ZMei—Brooks1986-10-23UHC-98539-12—986-973-1343-2240 Lake View RdScottsdaleAZ85261-9880··nullSELECT-EPO
CLMCLM-431778 2026-05-01T05:50:07ZCarter, Ashley——25-02-1951—•••-••-1250N/AN/A970 Mesa Drive Apt 36·Dallas·TX75260GRP-8101OPTIONS-PPO
CLMCLM-4105752026-07-28T16:31:38ZWALTER—CRAWFORD2007-03-27UHC-87486-65•••-••-80685239582908-9113 UNION STREETGlendaleAZ85386GRP-8723-
CLMCLM-4302262026-08-30T06:29:47ZAisha—Gray12/18/1983N/ANULL—·NULL8462 Main StreetMinneapolis·MN55488·GRP-0622NAVIGATE-HMO
CLMCLM-4200442026-07-01T05:24:09Zdaniel—·parker1977-04-03UHC-98857-93•••-••-5949····NULL5608 CANYON ROADTUCSONAZ85759N/A······
CLMCLM-4154262026-03-26T05:56:32ZAHMED—HERNANDEZ15-04-1942UHC-21736-01UNKNOWNnull—3347 Jefferson AveSACRAMENTOCA-GRP-4600SELECT-EPO
CLMCLM-4254292026-07-21T12:22:30ZDenise—Wilson11/14/1987uhc-05747-60N/A——420 Hillcrest RdSAN DIEGOCA——NULL
CLMCLM-4196042026-01-12T17:50:13Z ·Amy····Flores1947-08-22UHC-82844-75N/A-··null-NULLNULL—GRP-8824MEDICARE-ADV-B
CLMCLM-4122012026-09-02T03:48:10ZSam—Santos3/4/2005UHC-42300-84····——7827 Church StSEATTLEWA98147UNKNOWNMEDICARE-ADV-B
CLMCLM-4177102026-05-12T11:10:40ZNoah—James··1957-09-12UHC-65636-63-——7565 Meadow LaneAustinTX——NULL
CLMCLM-4154692026-03-07T03:38:12ZNICHOLASTJOHNSON1950-06-24UHC-82744-56UNKNOWN279.731.3619··N/A2844 Cedar Lane··Las VegasNV89171··GRP-3855N/A
CLMCLM-4185212026-03-10T07:55:48ZMichellle··NCarroll··12/26/1980UHC-10245-69•••-••-4435+1 885 281 9163NULL·-——·nullNULL··-
CLM CLM-4099952026-07-28T02:39:33ZJean—Williamson·1954-07-12NULLNULL——5902 Apache BoulevardSEATTLE··WA—GRP-0298NAVIGATE-HMO
CLMCLM-4121562026-09-27T05:04:41Zarjun—cruzJan 12, 1941UHC-83745-64··NULL(280) 922-2156—2005 Indian School RoadDenverCO80240GRP-3790CHOICE-PLUS-PPO
CLMCLM-4293562026-05-28T17:05:23ZWeaver, Janet—··1995-02-05nullnullUNKNOWNJANET.WEAVER16@PROTON.ME9551 LAKE VIEW ROADAtlantaGA30307GRP-4822CORE-HMO
CLMCLM-4255262026-05-29T00:47:24ZZACHARY—WHEELER14-08-1961-•••-••-8002——--N/A—N/A·CHOICE-PLUS-PPO
CLM CLM-4292592026-05-02T22:37:14Z·Frank—Evans1968-12-05null•••-••-9605—NULL1218 OCEAN AVENUEAustinTX78772GRP-8230—
CLMCLM-4031562026-08-07T23:45:02ZEdwaardX.Kinng11/13/1959UHC-04608-19•••-••-0029(648) 570-5403-183 GRAND AVENUESACRAMENTOCA95860··GRP-4758NAVIGATE-HMO
CLMCLM-4251982026-08-04T12:30:24ZDavid—Cooper·1952-10-03UHC-31002-68—+1 212 764 7184N/AnullNULLnullUNKNOWNGRP-1238MEDICARE-ADV-A··
CLMCLM-4037802026-03-08T07:32:36ZDylanD.Arnold3/17/1964UHC-34868-16•••-••-3189—dylan.arnold24@outlook.com·7544 Pine DrJacksonvilleFL32225GRP-5946SELECT-EPO
CLMCLM-402712 2026-06-30T12:42:59ZKAYLA—GARDNER··1964-11-25UHC-98906-09—NULLNULL7259 Sunset Boulevard·PhoenixAZ85005GRP-2418··—
CLMCLM-4193302026-06-07T07:23:04ZSam··Washington1976-07-18UHC-41066-05NULLUNKNOWNUNKNOWN8443 Spring StreetAtlantaGA30357NULLnull
CLMCLM-4180762026-03-16T18:12:52Zsalazar··—niccole23-06-1999UHC-15589-83•••-••-3476-nicole.salazar21@hotmail.com2170 Harbor BlvdSacramentoCA95838-3348GRP-7659NAVIGATE-HMO
CLMCLM-4055602026-07-31T03:47:14ZIsabella—Pena1962-12-23—N/A·(627) 607-1743·isabella.pena@hotmail.com——····UNKNOWNGRP-6844NULL
CLMCLM-4040492026-07-13T23:35:12ZSophia—Dixon2005-06-24—UNKNOWN——6679 Main StreetGlendaleAZ85349GRP-7580MEDICARE-ADV-B
CLMCLM-4286182026-05-25T20:32:28ZJACK—YANG1943-06-04-—3408163035-··2958 CAMELBACK RDLas VegasNV89194GRP-8339NAVIGATE-HMO
CLMCLM-4276982026-09-02T20:02:50Z·SHARON—ROJAS1965-08-23—•••-••-5110NULL—9578 MESA DR·Denverco·80279GRP-0393CORE-HMO
CLMCLM-4227662026-06-02T08:48:26ZAndrea—Gomez19871027··UHC-49598-70NULL——9419 Sunset BlvdTucsonArizona85762——
CLMCLM-4190502026-08-15T05:11:38ZJesse—Wood1995-03-01UNKNOWN—2524971008—·UNKNOWN—NULLN/AGRP-6771null
CLMCLM-4094352026-01-27T01:34:47ZEvelyn—Owens10/17/1967—•••-••-1512747-820-4284evelyn.owens60@aol.com9133 River RoadGilbertAZ85224GRP-7873CHOICE-PLUS-PPO
CLMCLM-4092862026-04-30T09:01:28ZKyle··Webb22-06-1991·UHC-73310-75-N/AUNKNOWN3288 LAKE VIEW RDMesaArizona85270null··
CLMCLM-4121512026-05-09T13:49:30ZLewis, Nancy——·1984-11-14·UHC-97623-93•••-••-9718·NULLnancy.lewis@gmail.com6223 Valley View DrAustin··TX78732GRP-0800-
CLM CLM-4254472026-03-09T13:22:51ZSarah—Bailey1971-09-27UHC-07917-53•••-••-3417-sarah.bailey26@icloud.com5551 WASHINGTON ST #479DALLASTX75228-6913—·MEDICARE-ADV-A
CLMCLM-4240272026-05-20T06:37:39ZYuki—Evans08-12-1984null•••-••-4335NULL—8031 BroadwaySan AntonioTX··—GRP-3116SELECT-EPO
CLMCLM-4019462026-08-13T19:33:31ZChristina—Nguyen2003-04-20UHC-52000-64•••-••-0719—null9150 HARBOR BLVDSan DiegoCA··92182——
CLMCLM-4081632026-05-26T17:42:12ZPHILIPWBLACK1955-02-06—•••-••-4806818-343-1032—UNKNOWNUNKNOWN—N/AUNKNOWNSELECT-EPO
CLMCLM-4272362026-04-11T18:32:58ZJoseph····Turner06/14/1957UHC-12535-13nullnull-··4916 Camelback RdTAMPAFL33682GRP-0928null
CLMCLM-4030952026-07-27T20:41:36ZAdams, Ann——1964-03-09uhc-49487-89•••-••-9781—····4774 BROADWAYScottsdaleAZ85244-2866GRP-9801CORE-HMO
CLMCLM-4317682026-01-31T07:56:27ZhiroshiBday1998-11-02—--NULL9870 APACHE BLVD Apt 30MesaAZ85278-0610GRP-7800UNKNOWN
CLMCLM-4132282026-10-05T14:40:08ZDOT—WALKERJan 28, 1980·UHC-09439-74N/A——3726 Canyon RdChandlerAZ85226—SELECT-EPO
CLMCLM-4088312026-07-10T19:33:33ZGREGORY—·PARKER05-05-1961UHC-82884-11NULLUNKNOWNUNKNOWN2142 Mountain View DrGLENDALEAZNULLGRP-0568—
CLMCLM-4005132026-10-04T09:53:00Zamy—hanson·Oct 8, 1987UHC-09703-59—nullNULL62 Lake View RdTucsonAZ85782GRP-7367······
CLMCLM-4249802026-05-13T19:21:41ZBarbara—Ruiz1976-06-24·UHC-02604-46-787-474-7712UNKNOWN695 Willow CtTempeAZ85228GRP-2555··
CLMCLM-4070442026-06-04T15:32:30ZWayne—Herrera20011126UHC-59812-10UNKNOWN—N/A2047 Central AvenueGILBERTAZ85232··GRP-0262—
CLMCLM-425802 2026-07-09T01:08:48ZROB—GUERRERO1947-06-24·UHC-60022-45•••-••-092714619474350N/A8843 OCEAN AVENUESeattleWA98184-SELECT-EPO
CLMCLM-4116192026-03-13T18:59:07ZOliviaG.Espinoza06/06/1998UHC-99981-18•••-••-157916729738163NULL4233 APACHE BLVD #461FresnoCA93730N/AUNKNOWN
CLMCLM-4130982026-03-31T19:23:48ZStewart, Wayne—····11/25/58UHC-01428-01NULL—UNKNOWN·6154 Indian School RdScottsdaleAZ85288GRP-9469NAVIGATE-HMO
CLMCLM-4212822026-05-28T18:59:54Zterry—hall··1988-07-22UHC-83199-44•••-••-2830(761) 479-6806UNKNOWN9208 MESA DR··SAN ANTONIOTX78288——
32,829 rows, page 21 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.788Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty