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-4032922026-10-08T14:38:33Z·SHIRLEY—FERGUSON1947-05-22UHC-88576-07•••-••-8021879-712-1611····6610 PARK PLACEMiami··FL33198GRP-3171SELECT-EPO
CLMCLM-4239082026-07-31T20:55:42ZRyan—Myers1951-06-28UHC2289068NULL··nullUNKNOWNUNKNOWNnullUNKNOWN-·N/A
CLMCLM-4055452026-03-30T20:07:35Z bradley—morrison11/11/1982UHC-89051-37—419-712-7965—461 Central AveTucsonArizona·85713GRP-3911CORE-HMO
CLMCLM-4169372026-08-19T00:09:22ZAmber——May 3, 1950UHC-16493-18UNKNOWN2847358059—3362 Pine Drive #516San AntonioTX78252nullN/A··
CLMCLM-4276802026-07-03T18:47:52ZFRANK—HANSEN1998-04-09UHC-07640-62null+1 921 899 3113—1390 MESA DRIVELos AngelesCA90080-0160··GRP-0318CORE-HMO
CLMCLM-4255852026-02-08T17:26:09ZBetty—Griffin1981-06-15UHC-94146-50•••-••-5587··UNKNOWN3605 WASHINGTON STREET··HoustonTX77096·GRP-1110SELECT-EPO
CLMCLM-4126972026-06-23T04:19:11Zvirginia·····porter19591212N/Anull(888) 473-0181virginia.porter30@icloud.com·7329 MESA DRIVECharlotteNC28276GRP-3222SELECT-EPO··
CLM CLM-4268982026-10-03T17:32:38ZethanM.··rogers12/18/1938-N/A18694389533—1672 Spring StSan AntonioTX78251GRP-1367UNKNOWN
CLMCLM-4181702026-01-20T10:39:20ZGeraldCHenderson1955-08-11—•••-••-9396nullNULL7915 Forest AveGilbertArizona85218GRP-8662··SELECT-EPO
CLMCLM-4098572026-05-16T19:04:57ZEric····FisherOct 10, 1942nullUNKNOWN7144123803NULL799 LAKE VIEW ROADChandlerAZ85244GRP-9945—
CLMCLM-4199072026-08-17T18:14:08ZLisa—Dunn1940-11-09—•••-••-7357UNKNOWN—999 River RdAUSTINTX78730GRP-8637—
CLMCLM-4105372026-01-29T01:59:45ZAdam—Bailey-null•••-••-9140--6587 Jefferson Ave Apt 36ScottsdaleAZ85222GRP-1378CORE-HMO
CLMCLM-4225552026-09-01T07:52:04ZRandy··Green2005-06-07—•••-••-3818(248) 998-0247NULLnullN/A·nullNULLGRP-2546select-epo
CLMCLM-4209072026-08-09T14:10:28Z·NOAH—MENDEZ12-04-1984UHC-58028-49•••-••-6173—·NULL7772 RIDGE ROADGLENDALEAZ85382-6270GRP-0453—
CLMCLM-4130352026-08-07T19:35:00ZChristian··Hernandez1951-03-27UHC4109213•••-••-0279UNKNOWN—1662 PINE DR·LAS VEGASNV89171-5129—UNKNOWN
CLMCLM-4315362026-08-19T09:13:41ZAMANDAOLIMar 22, 1968———UNKNOWN8177 RIDGE ROADGILBERTAZ85282GRP-3121—
CLMCLM-4262792026-07-27T03:55:50ZDonald—Morales1965-12-15——··—9049 Ridge RdAtlantaGA30395-4031GRP-9075CORE-HMO
CLMCLM-4291052026-01-08T23:55:49Z Gomez, Walter——05/22/45UHC-83989-37—590-694-3061-2117 Camelback RoadChandlerAZ85299GRP-6832CHOICE-PLUS-PPO
CLMCLM-4261862026-08-09T05:29:16ZABBY—NGUYEN·19830814UHC-73153-32•••-••-3043-—N/A—·null———
CLMCLM-4271332026-05-27T04:17:15ZSTEVEN—WELCH2002-11-08·UHC-34050-08null819-314-9122-4193 MARKET STREETLos AngelesCalifornia·90037—medicare-adv-a
CLMCLM-4184352026-02-07T17:28:18ZMichelle··—Kennedy05/17/50UHC-09693-82•••-••-15986354812881null5675 CEDAR LANEAustinTX78780GRP-8331NULL
CLMCLM-420039 2026-04-12T09:33:03ZKAYLAICOLE1978-01-06UNKNOWN·-—kayla.cole@icloud.com—N/A—N/AGRP-8278—
CLMCLM-4148742026-09-13T10:57:49ZWei—Romero1986-01-19UNKNOWNnull12228584516··NULL8922 Willow CourtScottsdaleAZ85280GRP-4394NULL
CLMCLM-4105922026-01-19T16:33:35Zjennifer—scott1990-10-11UHC-43086-65·NULL—jennifer.scott12@icloud.com3029 Market StreetSACRAMENTOCA95839NULLCORE-HMO
CLMCLM-421728 2026-02-25T05:22:02Zeric—reed··1986-07-19UHC-40907-39•••-••-1756UNKNOWN—9178 Sunset BoulevardAustinTX··78728-CHOICE-PLUS-PPO
CLMCLM-4278392026-01-19T08:21:56Zpatricia Z—lawson01/04/1963UHC-61632-44—N/A··null2289 BroadwaySAN ANTONIO·TX78251N/A—
CLMCLM-4244882026-03-01T02:37:32ZDouglas E.—Stephens1969-06-24UNKNOWN-(271) 719-2326····2790 Desert Sky BlvdHoustonTexas77022—NULL
CLMCLM-4255832026-01-22T06:47:10ZHernandez, Mark——2000-11-13UHC-59408-49-·(922) 751-8837NULL-—NULL-GRP-9305·-
CLMCLM-4260782026-01-31T08:02:58ZLAUREN—PETERS1984-07-16—··nulllauren.peters@proton.me··1420 Oak StreetGlendaleaz85392··CHOICE-PLUS-PPO
CLMCLM-4041082026-04-12T22:25:37Z STEVENS—CAROL1942-04-05··—•••-••-1151(720) 605-6203····———··GRP-0733MEDICARE-ADV-A··
CLMCLM-4194052026-06-09T00:37:01ZRivera, Cheryl——·1943-05-15uhc-22669-61—564-215-4559UNKNOWN2517 Baseline RdTempeAZ85257—UNKNOWN
CLMCLM-4129192026-08-15T21:39:18ZDonna—Edwards1999-01-16UHC-67089-11•••-••-6348824-536-1463·-6844 UNION STREETAustinTX78737-7312GRP-8220medicare-adv-a
CLMCLM-4314602026-09-05T10:33:36ZJesse—Bennett1940-12-16UHC-57219-23-····—·NULL————null
CLM CLM-4264612026-04-02T13:02:06ZHeather·XLongNov 19, 1969NULLnull810-582-1362-··1715 Camelback RoadSan AntonioTX78264GRP-1724NULL
CLMCLM-4000802026-08-31T11:55:49ZPrice, JonathanX—05/14/80UHC-44743-32—19039211408NULL6450 Jefferson AvenueEden PrairieMN55369GRP-1621—
CLMCLM-4232202026-03-03T11:16:28ZRACHEL—COLEMAN19711227N/AN/A··N/A—NULL····—··N/A-
CLMCLM-4183672026-03-25T13:12:39ZPhilip—Larson·11/19/1953UHC3228028N/A··460-946-5524··——nullnull—GRP-8145···CHOICE-PLUS-PPO
CLMCLM-4291182026-03-04T08:31:50ZRoy··Wood1950-08-01··UHC-79301-86NULL(765) 575-4581ROY.WOOD@OUTLOOK.COM5991 CHURCH STREETSACRAMENTOCalifornia95881GRP-9379—
CLMCLM-4197952026-04-12T08:56:31ZPATRICIA··—FOX··1959-03-21—•••-••-3324——2227 Mountain View Dr Apt 15PhoenixAZ85020GRP-2415NAVIGATE-HMO
CLMCLM-4166592026-01-31T21:47:46ZSnyder, Laura··—9/9/1995UHC-48867-39•••-••-1742(263) 220-1636NULL1028 Canyon Road Apt 5SeattleWA-GRP-1547·CHOICE-PLUS-PPO
CLMCLM-4221412026-05-07T10:43:47ZJOAN—EDWARDSJul 6, 1956UHC-88614-34N/A14917616897N/A-··UNKNOWN—NULLGRP-2620MEDICARE-ADV-B
CLMCLM-4128552026-05-11T18:30:38Z Phillips, Danielle·Z—06/04/1992UHC-60897-94null736-825-4868null8140 CANYON RDSCOTTSDALEAZ85256GRP-0807OPTIONS-PPO
CLMCLM-4246682026-03-31T03:02:07ZLarry—Crawford1982-09-02-•••-••-095117209259162NULL8183 MESA DR #601Scottsdale·AZ85264·GRP-1428MEDICARE-ADV-A
CLMCLM-4326182026-04-15T03:04:17ZSHARON—JIMENEZ11-11-1971UHC-43667-01nullNULL-··UNKNOWN-UNKNOWN·UNKNOWNGRP-7888—
CLMCLM-4015212026-02-20T16:50:49ZGloria—PerryN/A—•••-••-4391+1 638 341 2876····nullN/A——GRP-3273SELECT-EPO
CLMCLM-4080972026-02-07T04:57:22ZRyna—Richards09-05-1980uhc-91216-27NULL737-830-8796—nullnull--—null
CLMCLM-4110312026-01-13T19:16:07ZHelen····McCyoApr 17, 2004UHC-96672-11UNKNOWN··—-—null—nullUNKNOWNMEDICARE-ADV-A
CLMCLM-4168462026-06-25T19:24:05ZPHILIP—JOHNSTON1972-10-23UHC-34953-10•••-••-5659+1 686 330 4807philip.johnston98@outlook.com·9180 Main StColumbusOH43205GRP-8115CHOICE-PLUS-PPO
CLMCLM-4030872026-08-04T00:39:42Z Valentina··—Banks1954-05-17··——NULLUNKNOWN7203 Palm DrAtlantaGA30397-null
CLMCLM-4092712026-04-02T07:00:13Zgabriel—murray06/20/1953UHC-77098-33NULL—UNKNOWN3949 Forest AvenueMesaAZ85235N/ANULL
32,829 rows, page 182 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:40.621Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty