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-4185772026-08-04T08:01:50Zkeith—hicks1951-08-22null•••-••-12086464051005—3052 Canyon RdMinneapolis··Minnesota-··—N/A
CLMCLM-4227242026-01-09T05:57:51ZWatkins, Catherine——09/07/1940——-null2262 Canyon RoadGILBERTAZ85221··GRP-9326·NULL
CLMCLM-4203932026-07-31T11:07:45ZNichols, Brittany——1984-08-18UHC-42580-56NULLN/A··4311 Sage Ct··EDEN PRAIRIEMN55357GRP-0414NAVIGATE-HMO
CLM CLM-4060322026-01-25T07:43:01ZWei····JimenezOct 22, 1995UNKNOWN·--·-4995 Main St·MesaAZ85280—NAVIGATE-HMO
CLMCLM-4231712026-02-13T18:09:58Zmei—sanchez1988-09-11UHC-00404-61—null··NULL4230 Lincoln WayJACKSONVILLEFL32225GRP-1108null
CLMCLM-4312312026-04-14T21:04:49ZJeremySGarrettOct 22, 1946··UHC-79001-22•••-••-2232618-879-0007null1633 Indian School Rd·GilbertAZ85240——
CLMCLM-4044442026-02-28T14:53:24ZSANDRA··KIM1996-01-07—•••-••-8404-—··UNKNOWNnull··—N/A··MEDICARE-ADV-A
CLMCLM-4124152026-02-14T05:18:09ZSmith, Virginia——07-08-1963NULL•••-••-8007NULLUNKNOWNN/AUNKNOWNnull-·nullSELECT-EPO
CLMCLM-4168192026-08-07T18:59:20ZDiana—Chen13-06-1971UHC-87642-81—399.818.0006-3556 Meadow LaneEden PrairieMinnesota55313-3818—OPTIONS-PPO
CLM CLM-428055 2026-09-17T11:32:53ZRojas, BarbaraD—19890104UHC-46818-78-UNKNOWN-5644 FOREST AVENashvilleTN37287GRP-5717—
CLMCLM-4279502026-07-31T21:30:12ZElijah—Gilbert1998-08-12UHC-00785-53N/AUNKNOWN-7681 CANYON RD Apt 30Charlotte·North Carolina28207GRP-4048OPTIONS-PPO
CLMCLM-4327482026-07-25T10:07:06Z Maria—Fields03/23/44-N/ANULLMARIA.FIELDS15@ICLOUD.COM7659 HILLCREST RD·MinneapolisMN55489GRP-9250SELECT-EPO
CLMCLM-4276012026-05-05T11:30:52Z Timothy····Rios1981-09-26UHC-27057-19•••-••-7695(228) 599-2592—2391 DESERT SKY BLVDFresnoCA93766GRP-7410MEDICARE-ADV-A
CLMCLM-4080872026-04-30T05:46:16ZPAMELA—PHILLIPS1971-11-10·UHC-63688-70•••-••-2861—null8055 Hillcrest RdGILBERTAZ85294GRP-2023CORE-HMO
CLMCLM-4058782026-01-08T19:25:22Z·RmaosL.Deborah05/03/96UHC-13452-14———NULLNULL—N/AGRP-9860SELECT-EPO
CLMCLM-4137362026-08-15T23:24:14ZSantiagoNHudson1951-09-25UHC-21919-41•••-••-94342827546907N/A6607 Meadow LnHoustonTX—GRP-9034·N/A
CLMCLM-4128002026-04-10T01:43:50ZKeith—Burns1988-09-16—•••-••-98383388309775··N/A··9209 Lake View RoadPHOENIXAZ85010GRP-3119CORE-HMO
CLMCLM-4022352026-03-28T18:02:55Zjack—jimenez1965-07-22UHC-31944-66—4069170-1751 Apache Boulevard #717··TucsonAZ85725GRP-7682—
CLMCLM-4071042026-10-05T06:14:44Zemmma—harrison1966-03-10UHC-63140-98NULL4115652emma.harrison@aol.com344 Grand AveTAMPAFL33626GRP-8918SELECT-EPO
CLMCLM-4149002026-09-28T14:52:25ZWAYNE—AGUILAR1998-01-22-··•••-••-088813359284877-8546 HILLCREST RDColumbusOH··43204N/ACORE-HMO
CLMCLM-4306082026-04-03T11:12:11Z Patel, Mateo——1961-03-05UHC-36080-99—·nullNULL·8109 Canyon RoadSan AntonioTX78253GRP-1270····
CLMCLM-4117872026-06-01T15:00:41ZAISHA···HARRIS1989-08-24UHC-57458-76-772-925-9177NULLUNKNOWN——NULL····null
CLMCLM-4070882026-09-16T04:06:45ZAlexander—Allen01-08-1948uhc-46570-79•••-••-1393UNKNOWN··—NULL-UNKNOWN··null-NAVIGATE-HMO
CLMCLM-4261692026-09-09T09:27:46ZJoan··—Long1997-02-41UHC-83158-92•••-••-0939N/ANULL6094 Apache BoulevardAtlantaGA30390null—
CLMCLM-4097362026-02-13T23:28:59ZChristina··Sullivan1970-12-19NULL•••-••-0499N/A—N/AUNKNOWNNULLN/AGRP-2119MEDICARE-ADV-A
CLMCLM-4140432026-05-09T10:03:29ZSTEPHEN—LAWSON1974-09-03UNKNOWN•••-••-1754——5405 Valley View DriveDenverCO80244-5881··NAVIGATE-HMO
CLMCLM-4014482026-09-03T10:33:08ZCruz, Melissa······9/15/1996UHC-43441-53—·UNKNOWN—8804 Mesa DrGilbertAZ85249··GRP-8548OPTIONS-PPO
CLMCLM-4124772026-02-05T18:16:27ZJONATHAN—MORGAN3/23/1982UHC-47882-59—849-887-2973—3903 Mesa DrFresno·CA93738GRP-9129NAVIGATE-HMO
CLMCLM-4145492026-01-27T13:31:08ZDianaS.MendezApr 20, 1997UHC-96329-81—-UNKNOWN9376 Pine DriveJacksonvilleFL32260—medicare-adv-a
CLM CLM-4060092026-06-08T22:38:34ZGerald—Richardson4/11/1957uhc-52791-35—·299-882-5660gerald.richardson@proton.me1747 SAGE COURT #324GILBERTAZ85254GRP-3281-
CLMCLM-413472 2026-07-23T02:02:45Zjonathan—dunn1997-09-20NULLnull-UNKNOWN6111 MOUNTAIN VIEW DRIVEMIAMIFL33188GRP-7784CHOICE-PLUS-PPO
CLMCLM-4061882026-08-05T12:56:02ZJerry—Meyer1954-02-05——681.880.3780N/A6076 Pine DrivePlanoTX-GRP-2774NAVIGATE-HMO
CLMCLM-4116972026-04-04T21:47:22ZJeanG.Oliver1943-02-20··UHC-69298-44-—UNKNOWN6181 Sunset BoulevardNashvilleTNN/A····—
CLMCLM-4265712026-03-21T04:40:01ZTERRY··A··BUTLER10/10/2008-•••-••-9914-—NULL——nullGRP-5125UNKNOWN
CLMCLM-4302182026-04-07T13:06:52ZBryant, Noah——03/10/67UHC-41330-62—(393) 823-0395·NULL5903 Palm Dr #428AtlantaGA30343GRP-7111N/A
CLMCLM-4064292026-08-21T00:42:45ZASHLEY—·MASON1971-10-05—•••-••-0212675-969-3063N/A8239 MESA DRIVE·Los AngelesCA90068··GRP-9486—
CLMCLM-404129 2026-10-10T06:20:24ZCHERYL—·SIMMONS12/17/02UHC-92867-01——-3156 Baseline RoadSACRAMENTOCA95896UNKNOWNCHOICE-PLUS-PPO
CLMCLM-4289122026-06-04T06:06:01Z·Keith··Davis1989-08-12UNKNOWNNULL—N/A975 Bayshore DrScottsdaleAZ85240UNKNOWNN/A··
CLMCLM-4206142026-02-23T04:27:43ZSandra—Bell1952-11-28UNKNOWN··—232-904-3078SANDRA.BELL@AOL.COM·-—····—GRP-9402null
CLMCLM-4298212026-02-05T02:22:16ZLucia··Lewis1969-06-11UHC-36306-59•••-••-4085-—4823 Forest AveGilbertAZ85277GRP-3180NULL
CLM CLM-4260312026-05-24T13:09:41ZEliijah—MitchellNov 18, 1998null-··—N/A4345 MESA DRIVEEDEN PRAIRIEMN55386NULL—
CLMCLM-4282652026-01-17T12:02:35ZLaura—Thomas1940-04-21UHC-63477-40··•••-••-1006(810) 480-4448-2534 Central AveColumbusOH43227GRP-1130OPTIONS-PPO
CLMCLM-4012172026-05-01T01:01:20Zmateo—snyder1984-08-13··UHC-26840-16•••-••-3846——7355 Pine Drive··DallasTX75240GRP-7832MEDICARE-ADV-B
CLMCLM-4246002026-01-21T09:31:50Z·Philip—Maldonado19950107UNKNOWN•••-••-9664282.477.3887—7707 Palm DriveTempeAZ··85228GRP-4713—
CLMCLM-4078032026-03-17T23:41:10ZErric—Laane1952-05-20UHC-48704-64NULL(535) 668-4609-N/AN/AUNKNOWN—GRP-0640OPTIONS-PPO
CLMCLM-4083732026-08-04T06:15:40ZPierce, Carl——2006-11-15·NULL—UNKNOWNN/A8360 Sage CtLas VegasNevada89145·GRP-2751-
CLMCLM-4159332026-04-15T15:57:20ZDIAZ····FRANCES1971-11-09UHC-59919-29····381.463.3888N/A673 Mountain View DrCOLUMBUSOH43217GRP-0331—
CLMCLM-4185682026-03-09T18:55:26ZSteven··—Howell02/19/08UHC-92754-01N/A-UNKNOWN1820 MAPLE AVENUE Apt 37SacramentoCA95878GRP-1298CHOICE-PLUS-PPO
CLMCLM-4162452026-04-19T03:44:55ZAlexander, Nicholas——·1989-04-25UHC-55928-14•••-••-9411—-UNKNOWN-····—-—
CLMCLM-4137392026-06-18T16:27:28ZFerguson, Brian——1977-11-06null•••-••-5297-nullN/AN/A—-GRP-2075CHOICE-PLUS-PPO
32,829 rows, page 107 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:38.465Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty