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-4109832026-06-22T01:26:18ZLAURAX.DANIELS1978-04-28UNKNOWN———2172 Lincoln WayChandlerAZ85281GRP-8240CORE-HMO
CLMCLM-4041622026-06-04T23:46:17ZKenneth—OBrien··1948-04-17UHC1710944•••-••-0961UNKNOWN—8106 CEDAR LNCharlotteNC28212GRP-5298CHOICE-PLUS-PPO
CLMCLM-4053822026-10-03T17:48:11ZARJUN—BRADLEY1959-04-16UNKNOWN•••-••-88197419573764null1459 Ocean AvenueDALLASTXUNKNOWN——
CLMCLM-4111502026-07-08T17:21:01ZPark, Austin····—1987-07-24uhc-57701-65UNKNOWN··(976) 870-3257—8843 Forest AveSeattleWA·98131nullMEDICARE-ADV-B
CLM CLM-4084792026-10-04T19:36:24ZMaldonado, Sharon——1972-08-13UHC-56381-23N/AN/Asharon.maldonado@hotmail.com3759 Maple AvenueMESAAZ85281GRP-4100—
CLMCLM-4151872026-08-02T23:00:15ZGabrielH··Taylor1973-05-24UHC-69788-78-(207) 286-1977null916 APACHE BOULEVARDEDEN PRAIRIEMN·55345GRP-0292N/A
CLM CLM-4153862026-06-15T18:02:10Zsara—wlech1959-09-27UHC-01909-90null961.336.3370—8470 Pine DrMiamiFLN/A-medicare-adv-b
CLMCLM-4090362026-06-01T23:05:35ZJoyceH··Patterson1973-07-17—•••-••-7517-—4507 HIGHLAND AVENUE·San AntonioTX78278null-
CLMCLM-407184 2026-09-19T22:00:41ZhelenN·kelley1996-05-12UHC-08411-81•••-••-9739—NULL9444 VALLEY VIEW DR·COLUMBUSOH43248GRP-8653-
CLMCLM-4000932026-01-19T00:36:05ZChristian—Contreras26-07-1983null—961.251.6939christian.contreras84@hotmail.com5376 DESERT SKY BOULEVARDMiamiFL33172·GRP-8330UNKNOWN
CLMCLM-411635 2026-04-24T12:27:50ZOLIVIA····VASQUEZ···1942-03-27-N/A-N/A1875 MAPLE AVEJacksonvilleFL32297GRP-9330-
CLMCLM-4287272026-04-28T01:47:01ZJulie—Simmons1983-02-16·-NULL15817213191··null1667 Canyon RoadMiamiFL33192GRP-4334null
CLMCLM-4104252026-06-11T13:24:35ZDianaGOBrien1971-09-07UHC-82105-09•••-••-3674N/AN/A5504 Indian School RdFresnoCA93792GRP-9836SELECT-EPO
CLMCLM-4061542026-01-20T00:55:00ZAustin—RobertsonApr 21, 1968null•••-••-4901nullaustin.robertson@proton.me8721 Palm DriveLas VegasNV89127GRP-3089—
CLMCLM-4081722026-10-17T15:12:20ZVirginia—Hanson12-08-1953—•••-••-5165UNKNOWNUNKNOWN2261 WILLOW COURTJacksonvilleFL—N/A-
CLMCLM-4094152026-08-10T06:16:07ZKENNNETHFSTEWATR2003-04-08··—UNKNOWN253.924.7268null333 Jefferson AvenueATLANTAGA30389N/A-··
CLMCLM-4175362026-04-03T09:47:34ZALEXIS—TRAN1938-01-26—null6349166724nullnullNULL·NULLNULLNULL··—
CLMCLM-4327882026-06-17T05:44:46ZbenjaminS··lane1985-01-05UHC-09486-02——null6981 CEDAR LANEMiamiFL·33114-2614·--
CLMCLM-417887 2026-07-23T20:35:09ZLucas, Paul——06/15/1946——(779) 659-7606N/A3616 CAMELBACK RDJacksonville·FL32262GRP-1550NAVIGATE-HMO
CLMCLM-4076672026-02-15T08:26:22ZKEVINR.SOTT19770905—-—UNKNOWN4444 WILLOW COURT Apt 33NashvilleTN37251nullnull
CLMCLM-4098582026-05-28T23:58:36ZGrace—Harper12-06-1981UHC-75926-22··(798) 978-4285-6965 Sunset BoulevardMESAAZ85251··null-
CLMCLM-429403 2026-08-27T04:29:20ZJean—·Cole1968-08-07··UHC-91000-09•••-••-82504124694708—UNKNOWNN/A—NULLGRP-9987—
CLMCLM-4017272026-01-25T18:28:19Zdavid····elliott1994-06-10UHC-64957-16UNKNOWN(888) 770-4819NULL8120 SPRING STMesaArizona85201-NAVIGATE-HMO
CLMCLM-4290772026-10-15T17:33:35ZMariana—Arnold1982-03-14UHC-39533-22—N/Amariana.arnold@aol.com··UNKNOWN—UNKNOWNUNKNOWNGRP-4128null··
CLMCLM-417660 2026-06-01T17:57:05ZLAUREN—SCOTT2001-02-27UHC-72511-19null2774887011-·4131 CENTRAL AVENUESan AntonioTX78235GRP-2654UNKNOWN
CLMCLM-4256842026-07-09T03:03:38ZscottB.moreno·17-03-1943N/ANULL9416264149··2645 Park Place·SacramentoCA95841··UNKNOWN
CLMCLM-4239942026-05-11T08:19:58ZJoshua—Simpson09/01/1998UHC-82445-32UNKNOWN——1726 MOUNTAIN VIEW DRDenverCO80267——
CLMCLM-4273752026-09-29T05:23:44ZAnaA.··Cox1981-07-08—•••-••-0321—N/A8684 MAIN STTempeAZ85216-··null
CLMCLM-422033 2026-10-15T22:29:23ZBrian—Coleman··1948-01-28UHC-17963-76null(849) 786-0912NULL4479 Ocean AvenueSan AntonioTX78252—OPTIONS-PPO
CLMCLM-4156692026-04-07T12:27:18ZSHARON—STEVENS1985-05-24UHC-10278-31—(762) 809-4049N/A—NULLN/A··NULL—N/A
CLMCLM-4221602026-05-16T01:31:34ZPAUL—ROMARO1971-11-27··UHC-28842-64—UNKNOWNN/A8261 Harbor Blvd·MiamiFL—GRP-3479NULL
CLM CLM-4242532026-06-17T07:04:11ZKELLY—EVANS1943-06-21UHC-73587-33—18762546708—4317 Grand AvenueMiami·FL33188GRP-8370UNKNOWN
CLMCLM-4131702026-04-20T17:16:40ZBRYAN—SILVA1955-11-05N/A—391-606-1515-·612 Church StreetSan Antonio··TX78223GRP-0529MEDICARE-ADV-A
CLMCLM-4208432026-08-07T14:13:16Zkyle—silva··1968-07-18UHC-98556-49··UNKNOWN8197027654null4890 Bayshore Drive Apt 25PhoenixAZ··85019-CORE-HMO
CLMCLM-4252652026-03-18T13:08:48ZwayneYallenSep 4, 1970UHC8805422null602.376.0712-5414 Spring StreetTampaFL33698-2311GRP-5747·null
CLMCLM-4173242026-10-06T23:56:19Z Emily—·Bryant2003-02-21UHC-96529-14•••-••-0398—··6820 BroadwayMESAArizona85277GRP-2202SELECT-EPO
CLMCLM-4134372026-01-29T18:01:09ZAlan—Sanchez19661125UHC-35719-69•••-••-6013—-5421 HILLCREST RDPhoenixAZ··85064-9949··GRP-2042null··
CLMCLM-4127382026-09-25T20:48:56ZHaroldP.Patterson03/26/1940UHC-04603-36•••-••-8241-—226 Harbor BlvdSan AntonioTX78260—SELECT-EPO
CLMCLM-414182 2026-06-16T22:30:40ZSophia—Cole1991-04-15—•••-••-0203(484) 370-2581UNKNOWNUNKNOWNUNKNOWN····N/A·NULLnull
CLMCLM-4071162026-04-19T18:32:32ZJESSE—SPENCER·19431124N/A•••-••-9852577-770-4546—5080 Harbor BlvdSeattleWA98107GRP-3780··CORE-HMO
CLMCLM-4051582026-10-13T09:37:27ZAlexis—Fox2007-04-26UHC-32649-36•••-••-6417NULL—7627 Indian School RoadGilbertAZ85200—CHOICE-PLUS-PPO
CLMCLM-4001582026-02-12T00:19:01ZElizabeth··Castro19950522—N/A443-409-7676ELIZABETH.CASTRO@ICLOUD.COM2577 HIGHLAND AVENUEAtlantaGeorgia30314GRP-9959MEDICARE-ADV-B
CLMCLM-4312392026-09-01T02:00:00Z Nick—Walsh1996-07-04null•••-••-3189N/A—3420 OAK STREETTempeAZ85261-····
CLMCLM-4013222026-05-07T16:29:28ZANTHONY—SIMPSON1952-11-27UHC-67870-89———NULL-··UNKNOWN—NULLOPTIONS-PPO
CLM CLM-4287542026-09-02T08:48:03ZJOAN—COLEMAN2003-05-25UHC-76680-53—551-424-6119UNKNOWN6592 Willow Court·TAMPAFL33636N/A—
CLMCLM-4019752026-09-14T02:45:51ZBrittany—Warren2008-09-09UHC2215907—611-730-4680—4501 Park PlAustinTX78721·-UNKNOWN
CLMCLM-4193292026-06-01T17:53:01ZAnn—HudsonSep 6, 1947N/AN/A—UNKNOWN·2748 Palm DrEden PrairieMN55320GRP-8152CHOICE-PLUS-PPO
CLMCLM-4024812026-03-17T07:32:51ZAlexander—Gonzales1989-02-09UHC1125710•••-••-5705-alexander.gonzales12@hotmail.comN/AUNKNOWN····—GRP-3802MEDICARE-ADV-A
CLMCLM-4278632026-08-17T19:19:38ZWAYNE····WRIGHT1941-11-15-UNKNOWN—NULL6124 Bayshore DriveTucsonAZ85720-CORE-HMO
CLMCLM-4135882026-01-29T06:16:35ZMelissa—White5/10/2000UNKNOWN--UNKNOWN··UNKNOWN—NULL··NULLGRP-1135NAVIGATE-HMO
32,829 rows, page 74 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:37.734Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty