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-4090582026-05-15T03:50:54ZAisha—Long1986-12-18—null—AISHA.LONG@PROTON.ME4700 Desert Sky BlvdTempeAZ85259GRP-0601OPTIONS-PPO
CLMCLM-4260402026-02-10T13:53:15ZLISA—HARRISN1953-06-05UHC-11790-15-NULLUNKNOWN6571 OCEAN AVENUE·DallasTX75266GRP-6109—
CLMCLM-4160042026-07-27T11:45:44ZAmanda··Mnedoza1941-02-24—NULL9422303—11 Bayshore DrGILBERTAZ···85248—MEDICARE-ADV-B
CLMCLM-4174132026-02-23T07:40:42ZJean—Reed1949-09-15UHC-11553-95-357.920.7839null5322 Sage CtFresno··CA93714-NAVIGATE-HMO··
CLMCLM-4214122026-02-03T10:15:08Zstephen—jimenez··20060927nullNULLNULL··—3249 BAYSHORE DRDenverCO80254GRP-4656NULL
CLMCLM-4206882026-05-31T01:24:39ZJamesQMorgan1951-05-14··UHC-01721-27N/A249-327-9222·-3470 Canyon RdNashville··TN37292UNKNOWN—
CLMCLM-4012382026-06-06T01:19:38ZRichards, Dot——1944-08-27··UHC-27953-85·null—-——N/AUNKNOWNGRP-8400MEDICARE-ADV-A
CLMCLM-4116942026-02-27T00:10:19Zsantiago—thompson1966-09-08UHC1810193•••-••-5423—UNKNOWN5453 VALLEY VIEW DRIVECharlotteNC28226GRP-9062·NULL
CLMCLM-4301882026-05-23T20:22:05ZBRANDONHPETERSON1965-06-28UHC-21678-78•••-••-9600UNKNOWNNULLUNKNOWNnullUNKNOWNnullGRP-1771SELECT-EPO
CLMCLM-4277362026-09-27T16:11:12ZLucia··—Hughes1939-07-22—•••-••-689113725976654··—3294 LAKE VIEW ROADAtlantaGA30345-1894N/ASELECT-EPO
CLMCLM-4035982026-01-13T19:49:10ZISABELLA—GRIFFIN20-12-1958UHC-44529-74NULL(811) 732-0200·UNKNOWN8641 MAIN STHouston·TX77018NULLnull
CLMCLM-4143202026-05-29T23:13:54ZAngelaE.Woods1977-08-62··UHC-24555-87—·NULLangela.woods@yahoo.com3702 CENTRAL AVELos AngelesCA90047GRP-7760MEDICARE-ADV-A
CLMCLM-403309 2026-09-27T12:49:16ZJudy—Harvey1961-05-25-—9042981881——·nullN/AnullUNKNOWNNULL
CLMCLM-4108282026-01-01T04:34:57ZJustin····Estrada1999-10-01null•••-••-8267—-UNKNOWNnullNULLUNKNOWN··GRP-4204N/A
CLMCLM-4048612026-05-14T11:35:01ZAHMED—VAZQUEZ1955-08-09UHC-66130-93•••-••-38029142541272N/A—NULLUNKNOWNnullGRP-5983NAVIGATE-HMO
CLMCLM-4002342026-08-20T09:40:41ZESPINOZA—ANGELA··19790709—•••-••-4174-angela.espinoza@gmail.com6531 OCEAN AVENUEFresnoCA93743··GRP-5088NAVIGATE-HMO
CLMCLM-4187222026-06-14T07:27:35ZRlph—Bell1976-11-03——UNKNOWNRALPH.BELL12@ICLOUD.COM8457 Apache BlvdTempeAZ85201—CORE-HMO
CLMCLM-423870 2026-02-14T23:15:49ZMariana····Peterson·1998-12-07—-—N/A··N/AN/A——N/AOPTIONS-PPO
CLMCLM-4326852026-03-22T14:41:34ZPATRICK··—·JACOBS1952-01-27nullNULLN/A—NULLN/A——UNKNOWNOPTIONS-PPO
CLMCLM-4132632026-06-03T19:10:18ZSANDRA—GEORGE1951-06-04NULLN/A(905) 646-2311null4220 Willow CourtSACRAMENTOCA95828GRP-8205OPTIONS-PPO
CLMCLM-4259452026-05-14T02:58:46ZDIEGOWTURNERFeb 28, 1988·UHC-92924-96UNKNOWN7302887NULL8225 UNION STTampaFL33644GRP-2014—
CLMCLM-400908 2026-08-15T09:37:55ZRonald—Cooper·1946-10-28UHC-75874-34•••-••-7345NULLronald.cooper@hotmail.com9401 Union Street··LAS VEGASNV89132GRP-7694MEDICARE-ADV-A
CLMCLM-4162632026-06-03T07:07:58ZBrandonRGarciaDec 4, 1945UHC-75549-84—NULLnull3377 Lincoln WaySan AntonioTX78271-1571UNKNOWNCHOICE-PLUS-PPO
CLMCLM-4131722026-01-25T08:37:59ZAlice——1970-09-28N/A··•••-••-80879418507322null8729 Park PlaceHoustonTX77078-2350····NULL
CLMCLM-4115762026-09-06T15:21:50ZKyle—Ortega1989-09-20nullNULLnullNULL2383 JEFFERSON AVENUEHOUSTONTX·77090GRP-4311SELECT-EPO
CLMCLM-4315352026-07-23T04:08:21ZAmanda—Li1968-03-22N/A—--8177 Ridge Road·GilbertAZ85282—·NAVIGATE-HMO
CLMCLM-4120542026-05-10T11:41:47ZStephen··Espinoza08/17/1979UHC-47877-57··•••-••-8648+1 598 332 0920—3946 Pine DrTucsonAZ85748GRP-6276null
CLMCLM-431354 2026-03-20T16:31:00ZSchmidt, Pamela——1948-08-12UHC-00388-35•••-••-4472··-2097 Lake View RoadTampaFL33670GRP-0312MEDICARE-ADV-B
CLM CLM-4127402026-10-15T00:55:40ZHaroldP··Patterson03/26/40UHC-04603-36•••-••-8241375-407-5325NULL——NULLN/A—null
CLMCLM-4300402026-05-30T15:20:56ZADAM—·BURNS1964-04-28UHC6543992•••-••-6422698.226.9928-7744 Willow CourtAtlantaGA30395GRP-4434··NAVIGATE-HMO
CLMCLM-4249722026-05-03T18:59:16ZLuis··Cole1976-05-18UHC-54865-68•••-••-2515N/Anull1216 Grand AveCharlotteNorth CarolinaUNKNOWNGRP-1594CHOICE-PLUS-PPO
CLMCLM-4065802026-07-19T10:47:12ZPerkins, Denise——2003-07-02·UHC-99174-55UNKNOWN··—NULL6478 Meadow LaneJacksonvilleFL32291GRP-3199—
CLMCLM-4130932026-06-18T06:18:26ZCYNTHIA—MEJIAUNKNOWNUHC-80006-11•••-••-9073NULLcynthia.mejia15@icloud.com8021 Spring StreetAustin··TX78792—UNKNOWN
CLM CLM-4008352026-02-12T17:57:03ZJulie—Webb1951-02-14N/A•••-••-6160844-915-3139NULLnull———GRP-8922··N/A
CLMCLM-4090842026-07-11T10:18:52Z Kathryn—Knight1952-12-09UHC-61419-84UNKNOWN(609) 965-0648—8540 LAKE VIEW ROADDallasTX75238—UNKNOWN
CLMCLM-4201652026-04-19T01:02:02Zchris—jimenez··08/25/00UHC-90658-11•••-••-5684N/A—·-——nullGRP-2075MEDICARE-ADV-A
CLMCLM-4325872026-06-24T00:38:54ZJoseZ··Walker19670902UHC-06820-75•••-••-4869UNKNOWN—3288 Apache BlvdDallasTX75287GRP-6531UNKNOWN
CLMCLM-4025872026-03-12T23:33:23ZJennifer—Oliver06/16/72—N/A(660) 692-0658NULL9553 Highland AvenueSeattle··wa98153GRP-8813OPTIONS-PPO
CLMCLM-4219762026-03-28T18:27:53ZWheeler, Thomas——1951-03-02·UNKNOWN•••-••-3831627.238.2541N/A5073 MARKET STREETCHANDLER··AZ85280—null
CLMCLM-4269952026-05-28T16:04:10ZHarold—Matthews1967-11-23UHC-47451-76NULL·null—·1371 Elm StNashvilleTN··37212-1094GRP-1782CORE-HMO
CLMCLM-4001752026-04-25T08:10:31Z·Anthony—Maldonado1958-06-17UHC-57454-98•••-••-6425881-629-8459N/A7136 Sage CourtDallasTX75246—·UNKNOWN
CLMCLM-4149412026-02-16T22:51:01ZBenjaminIContreras··1980-06-23-NULL(946) 455-5695UNKNOWNnull-N/A··—GRP-9082navigate-hmo
CLMCLM-4327762026-04-08T08:32:07ZMASONMWASHINGTONAug 16, 1965UHC-11018-53··•••-••-4600-NULL5155 Ridge RdMinneapolismn55467-7826N/ASELECT-EPO
CLMCLM-4169792026-09-03T07:04:37Z ·Aisha····Santos1981-12-07UHC-20680-09—·(863) 205-1547—8512 Bayshore DrMiamiFlorida33184GRP-5924SELECT-EPO
CLM CLM-4232302026-08-19T18:44:08ZJUDITH—HICKS1972-05-26UHC-95621-67NULL——7709 Desert Sky BoulevardSACRAMENTOCA95801-6010GRP-5393MEDICARE-ADV-B
CLMCLM-4258982026-08-03T23:17:11ZMARK····JIMENEZ2002-11-16UHC-49159-10•••-••-69416236480630-—-—NULL——
CLMCLM-4224742026-06-30T03:43:46Zalxis—ross·2001-04-24UHC-76669-06•••-••-6669—··2335 Baseline RdAtlantaGA30386GRP-9434··OPTIONS-PPO
CLMCLM-4233112026-01-09T18:15:44ZJuan—Graham··1594-01-27—•••-••-2118--8033 JEFFERSON AVENUEJACKSONVILLEFL32207N/A··CHOICE-PLUS-PPO
CLMCLM-4124792026-04-12T18:40:48Zsamuel··kelley1955-07-10-•••-••-7289704-611-0385null5846 Mountain View DrivePhoenixAZ85012nullNAVIGATE-HMO
CLMCLM-4119602026-07-15T09:07:37ZPAMELA—·ORTEGA1956-08-27NULL—UNKNOWNNULL871 Baseline RoadSEATTLEWA··98157··GRP-4826N/A
32,829 rows, page 20 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.787Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty