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-424569 2026-01-08T21:01:39ZEugeneTNichols1980-03-11UHC-77317-26•••-••-2274——1911 Palm DrPhoenixAZ85031—-
CLMCLM-4041232026-01-22T05:39:54ZPEGGY—PETERSON1949-08-05UHC-10133-58•••-••-4016N/A—1149 Apache BlvdMesaAZ85290NULLN/A
CLMCLM-4223252026-01-05T13:01:02ZLawrence····Fox1941-09-28—•••-••-2924—N/A4708 Park PlaceMesaAZ85233·GRP-1062null
CLMCLM-420283 2026-05-13T17:18:32ZEvelyn··—Vega·1982-12-09UHC-27495-63•••-••-5804—NULL··9814 River Road #145ScottsdaleAZ85234nullUNKNOWN
CLMCLM-4083422026-05-30T05:28:10ZGloriaGLe1940-08-28UHC-26291-93•••-••-7556UNKNOWN—nullN/A—NULL··GRP-9468N/A
CLMCLM-4067772026-10-18T12:42:57ZBradleyBRussell2000-07-16uhc-45171-11•••-••-7502274.992.2193—5244 VALLEY VIEW DRMINNEAPOLISMinnesota55446-1104N/A·N/A
CLMCLM-4047232026-07-13T21:59:03ZArthru—Howell19700815N/A•••-••-2602·nullARTHUR.HOWELL@OUTLOOK.COM5457 MEADOW LANELos AngelesCA90003GRP-6508NULL
CLMCLM-4212422026-07-18T15:20:43ZSamuel—Hart1982-03-15UHC-45207-32-—NULL3954 DESERT SKY BLVD Apt 8·TucsonAZ··85744GRP-1637N/A
CLMCLM-4074752026-04-03T22:44:13ZSara—Reyes1971-04-01UHC-63528-39———7738 Ocean AvenueCharlotteNC28224—MEDICARE-ADV-A
CLMCLM-4124382026-10-16T02:12:45ZAHMED—WRIGHT1972-11-22—•••-••-0806NULLahmed.wright@proton.meN/AN/A-NULLGRP-6175NAVIGATE-HMO
CLMCLM-4194562026-10-03T02:36:24ZMatthews, Sofia U——1948-02-23UHC-59775-17—17109726382—6116 Harbor BlvdScottsdaleAZ85244GRP-2975MEDICARE-ADV-A
CLMCLM-4295732026-08-20T06:22:48ZBrittany—Patel2007-11-28UHC-64753-20NULL7217012571—7747 Apache Blvd Apt 10MesaAZ85280-3908N/AUNKNOWN
CLMCLM-4294142026-09-09T05:45:39ZLewis, Douglas·X—·1967-09-08UHC-76690-56nullN/ANULL560 Spring Street Apt 6··DallasTexas75254-··OPTIONS-PPO
CLMCLM-4029682026-01-22T07:21:10ZKIMBERLYABUTLER1938-02-21UHC-78911-70•••-••-8232-—8151 Mesa DriveSeattleWA98180GRP-2589···OPTIONS-PPO
CLMCLM-4211342026-06-08T07:10:12ZAmber—·Larsson1943-12-22—·UNKNOWN370-720-4126—UNKNOWNnullnull—·nullnull
CLMCLM-4043002026-01-08T01:59:10ZEUGENE—DELGADO1970-03-25UHC-54477-15•••-••-24875409742302NULL4758 Main StreetTampaFL33684GRP-7181CORE-HMO
CLMCLM-4096932026-03-24T23:55:25ZCHRISTIAN····WOODS1949-11-26null—4828551573null·9237 Main StreetPlanoTX75076-8952GRP-6281UNKNOWN
CLMCLM-4241252026-04-16T14:41:09ZAnn—Grent2000-11-02UHC-64263-73•••-••-6846(618) 500-9961ann.grant90@proton.me··UNKNOWNnull—·nullnull
CLMCLM-408783 2026-04-11T03:53:32ZEUGENE··ARNOLD1945-12-07—•••-••-6661N/A··null8379 VALLEY VIEW DRGilbertAZ-GRP-8163CORE-HMO
CLMCLM-4268072026-06-23T10:18:05Z Williamson, Jessica——19-09-1963UHC-41493-30UNKNOWN442.933.8171NULL832 CANYON RDJacksonvillefl32255··GRP-2153SELECT-EPO
CLMCLM-4251782026-08-14T02:21:21ZReynolds, Linda——2004-10-19UHC-41436-28•••-••-2908UNKNOWNN/A900 Ocean AveTempeAZ85282-OPTIONS-PPO
CLMCLM-4037342026-04-15T10:25:02ZGbariel—Gonzalez1997-11-09——6343952193N/A7576 VALLEY VIEW DRJACKSONVILLEFL32236-4202GRP-3687UNKNOWN
CLMCLM-421353 2026-01-02T05:05:52ZClark, Elijah——1966-03-23UHC-01209-61•••-••-5760+1 291 699 8180··—3071 OAK STChandlerAZ·85295GRP-6039UNKNOWN
CLMCLM-430284 2026-06-19T09:18:51ZAlexisXMorrison1981-10-24UHC-67872-19•••-••-5829UNKNOWN—9552 Forest Ave #901AUSTINTX78712GRP-3014MEDICARE-ADV-B
CLMCLM-4209732026-10-06T09:42:34ZBrittany··Hudson1966-07-21UHC-45710-24—nullnull1462 Canyon RdMinneapolisMN55447—NULL
CLMCLM-4208412026-04-12T01:46:55ZHeather—Peterson1980-07-21··UHC-87939-62•••-••-5641223-924-9434null7025 Bayshore DriveCharlotteNCNULLGRP-1081MEDICARE-ADV-A
CLMCLM-4029932026-06-14T12:40:31ZGregory—Lee1971-11-13UHC-72345-25•••-••-0012·7274827948····3487 Ocean AveATLANTAGA30326GRP-8238NULL
CLMCLM-4265732026-03-30T20:57:31ZterryAbutlr2008-10-10UHC-98914-41··(258) 664-1575—5887 JEFFERSON AVE Apt 16PlanoTX75041··MEDICARE-ADV-A
CLMCLM-4056302026-03-16T11:16:20Z·JUDITH—MEYER2002-04-23UHC-98459-56—7408426301judith.meyer92@proton.me6103 RIDGE ROAD·OrlandoFL·32872—NULL
CLMCLM-4037862026-05-11T22:21:19ZWALTER—LUNA04-12-1983N/Anull5946404747—97 Highland AveMinneapolisMN55496GRP-9423MEDICARE-ADV-A
CLM CLM-4298372026-07-05T14:53:11Zteresa—james1987-06-15UHC3622789•••-••-7987620-845-8818—5550 JEFFERSON AVENUEPLANOTX·75084GRP-5099—
CLMCLM-4040302026-01-09T19:10:10ZMartha—Bell1965-09-21··UHC-05322-98•••-••-69565259835256—1624 Palm DriveMesaAZ85222—select-epo
CLMCLM-4135252026-05-07T11:46:23ZBenjamin··—Peters2006-10-23UHC-96567-22—5195001-8029 Mesa DriveHoustonTexas77014··GRP-4263null
CLMCLM-4106502026-05-14T05:45:02ZHiroshi·····Lynch1025-91-65UHC-75411-44•••-••-1402—hiroshi.lynch@aol.com581 CEDAR LNTampaFL33626UNKNOWN·NULL
CLMCLM-4029582026-01-26T12:23:42Zkayla—romero6/11/1997UHC-53695-41•••-••-5126557.617.7259NULL18 Central AveGlendaleAZ85309—OPTIONS-PPO
CLMCLM-4067372026-01-21T13:46:07Z Barb—Warren1979-06-15UHC-54834-89····—·UNKNOWN9804 Ocean AveAustin·TX78763-0734GRP-4001—
CLMCLM-4166222026-07-08T08:13:18ZWAYNE—BAILEY7/10/2007UNKNOWN—707-729-0054—8816 FOREST AVENUE Apt 19PHOENIXAZN/A—····
CLMCLM-4284692026-04-03T17:02:37ZJoan—Allen19671222UHC-42345-40——-7075 Harbor BlvdOrlandoFlorida32822GRP-3215MEDICARE-ADV-B
CLMCLM-4269102026-03-21T06:45:23Z·Patricia—Hicks1966-10-27UHC-31171-67•••-••-93493523526443—3016 Palm DriveMinneapolisMN55461-—
CLMCLM-4267512026-07-05T15:47:40ZSandra—Patel2000-12-07UHC4224289N/A8219423767——UNKNOWN····NULLGRP-7780—
CLMCLM-4151382026-10-07T19:29:53ZMei—Jordan06/14/1974—•••-••-399217322813810-8501 Canyon RoadTampaFL33632nullOPTIONS-PPO
CLMCLM-4132152026-06-10T09:56:34ZAlbret—Mendez1972-10-21NULL•••-••-8315—UNKNOWN2542 BASELINE ROADMinneapolisMN55442GRP-0249MEDICARE-ADV-A
CLMCLM-4016862026-03-31T17:13:13ZBRYEN—WALSH1980-07-19-•••-••-0637null—5966 Central AvePhoenix·AZ85035GRP-3469—
CLMCLM-4057572026-07-27T03:28:13ZValentina·IThomas1972-06-05UHC-90800-20—NULLvalentina.thomas84@proton.me8837 Hillcrest RdGilbertAZ··85228null—
CLMCLM-4283562026-06-08T21:58:42ZPamela—Ferguson1963-03-09··UHC-65919-52UNKNOWN859-688-4727-8040 Bayshore DrGilbertAZ85218NULL·-
CLMCLM-4259772026-06-01T11:12:07Z·PeterS.Diaz1938-01-23UHC-02885-51UNKNOWN—nullnull———GRP-6217··
CLMCLM-4106582026-02-12T08:29:20Z Jenkins, Jacqueline····—1954-01-08UHC-69211-43N/A+1 824 937 5053—995 Baseline RoadMINNEAPOLIS··mn··55452GRP-0661··
CLMCLM-4146282026-03-21T13:13:15ZAlanJEllis1946-01-13null•••-••-3448UNKNOWN-491 Mesa DrGilbertAZ85284N/AN/A
CLMCLM-4227692026-05-13T07:16:20ZJoe—OBrien6/20/1938UHC-91026-53•••-••-8343(261) 595-3563UNKNOWN—UNKNOWNN/AUNKNOWNGRP-7700·UNKNOWN
CLMCLM-4279112026-02-21T12:57:01ZAARON—REID04/25/1968UHC-10885-76null-NULL1642 Apache BoulevardMiamiFL33146GRP-3197MEDICARE-ADV-A
32,829 rows, page 4 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-19T19:54:25.415Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty