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-4072932026-08-13T03:02:25ZKimberly—White1944-07-03null-UNKNOWNnull6560 Camelback Road··San AntonioTX78255—MEDICARE-ADV-B
CLMCLM-4116022026-07-25T01:25:48ZAmanda—Hansen1968-12-11—NULL··+1 392 829 8480N/Anullnull-null—NAVIGATE-HMO
CLMCLM-4164872026-10-11T10:20:33ZBRIAN—BELL1960-31-06UHC-05015-78··N/AnullBRIAN.BELL@HOTMAIL.COM—·N/ANULLNULLGRP-1457MEDICARE-ADV-B
CLMCLM-4280022026-06-04T18:03:44ZGaria, Helen——1/28/1973UNKNOWN—9082605200null8801 Forest AvenueFresnoCA93720nullN/A
CLMCLM-4054002026-07-02T03:43:32Z MarilynWNguyen1982-03-21—•••-••-13719505968736·N/A6415 Broadway Apt 31TempeArizona85256GRP-1167··CORE-HMO
CLMCLM-4110842026-01-29T06:05:34ZGibson, Mei——1977-07-16UHC-57095-09nullN/AUNKNOWN·4459 Mesa DrLos Angeles·California90095GRP-3366OPTIONS-PPO
CLMCLM-4325732026-03-22T10:47:11Zjulie—medina2004-05-05UHC-60078-04•••-••-0733-—7323 Apache BlvdAustin·Texas78743UNKNOWN—
CLMCLM-4092152026-07-30T07:54:54ZPatterson, Nicholas——05-12-1974··UHC-35022-20—973-322-1182—9852 Washington St Apt 19··TempeAZ85259GRP-9384SELECT-EPO
CLMCLM-4138052026-07-26T04:49:17ZHenry—·Johnson5/24/1982N/A··--null·UNKNOWN—N/ANULLGRP-6519UNKNOWN
CLMCLM-4181562026-03-14T04:25:05ZAnthonyO.Simmons12/3/1986UHC-84844-41•••-••-4656455.281.2383-8393 PINE DRIVEPlanoTX75053-5726-··CHOICE-PLUS-PPO
CLMCLM-4220452026-01-28T22:35:53ZCarlos··Campbell1960-06-18UHC-89227-34——carlos.campbell@outlook.com——null—·GRP-9054CORE-HMO
CLMCLM-4147662026-06-18T13:58:16ZAmber—Brown1983-07-08UHC-31542-62NULLN/AUNKNOWN2625 Bayshore DrCHARLOTTEnc28214NULL··NAVIGATE-HMO
CLMCLM-4083692026-05-12T01:13:26Z·Maldonado, MasonA.··—1008-18-92null•••-••-3519272-286-2384MASON.MALDONADO14@PROTON.ME1570 Union StTAMPAFL··33604UNKNOWN·SELECT-EPO
CLMCLM-4090682026-10-04T19:05:37ZKEITH—GEORGE1939-03-06UHC-45910-24UNKNOWNnull··-9710 Baseline RdLos Angeles··CA90048NULLMEDICARE-ADV-A
CLMCLM-4319512026-09-23T01:25:34ZMichael··—Kim1981-08-12UHC-02686-18•••-••-2139-NULL351 Union StAustinTX78787GRP-3885NAVIGATE-HMO
CLMCLM-4223312026-01-12T18:24:12ZJoyceXMendez04/10/1966UHC4194599•••-••-8319NULLnull1468 Sage CourtPhoenixAZ85078GRP-4576-
CLMCLM-4259312026-09-25T12:18:06ZDanielZSnyder·May 24, 1965UHC-45484-10null(553) 674-0787daniel.snyder@icloud.comN/A··UNKNOWN-——
CLMCLM-4180152026-03-29T02:12:00ZMEI—WARDJan 23, 1984UHC-21084-45-——null———GRP-0454MEDICARE-ADV-A
CLMCLM-4191032026-05-23T01:42:51ZJOAN—COOPER1994-06-27UHC-48751-84•••-••-96398585513148—N/A—NULLUNKNOWN—·NULL
CLMCLM-4047642026-08-11T03:22:44ZfrankO.porterDec 27, 1982·UHC-40055-65•••-••-2819NULL··N/A··N/A—UNKNOWNUNKNOWN——
CLMCLM-4168662026-05-16T19:12:55ZAngela—Garrett·May 6, 1948UHC-27727-94NULLN/Aangela.garrett@yahoo.com——-N/AN/Achoice-plus-ppo
CLMCLM-4007412026-10-14T05:52:48ZAdam—Simpson2005-10-07··null816-275-2293—·5333 Harbor BoulevardPhoenixAZ85000-—
CLMCLM-4037002026-07-06T02:51:21Zvictoria—bennett1956-05-07UHC-20682-65-··—N/A9161 Maple AvenueTEMPEAZ85265—MEDICARE-ADV-B
CLMCLM-4212192026-02-03T08:59:34ZAustin—Franklin1944-05-04UHC-70952-25-+1 492 895 5754UNKNOWN8689 Bayshore DrTempeAZ85212GRP-6010NULL
CLM CLM-4298002026-02-01T02:49:40ZGRACE—GARZA··2002-11-10UHC-70601-88—UNKNOWNN/A7828 Maple AveChandlerAZ··85281··UNKNOWNNULL··
CLMCLM-4100152026-01-10T05:55:45Z Noah—Estrada·Apr 15, 2005N/A•••-••-67707749860165—6764 HILLCREST RDScottsdaleAZ85266-6001·UNKNOWNN/A
CLMCLM-4204262026-10-13T03:41:47ZArjun—Lawrence05/05/84·UHC-29118-42—(514) 718-1288NULL6371 Sage CtSAN ANTONIOtx78294NULL-
CLMCLM-4286492026-09-10T09:35:59ZMAON—ARNOLD1955-06-19—•••-••-8402-··5848 Sage CourtFresnoCA93716N/A—
CLMCLM-4161042026-03-04T23:42:56Z Edward—Arnold··22-12-1957UHC-58764-26•••-••-2126515-418-2111N/AUNKNOWN-—null····MEDICARE-ADV-B
CLMCLM-4045782026-02-09T13:52:50ZAMBER—WHITE1962-10-21UHC-86611-68•••-••-030818209117647UNKNOWN-nullnullnullNULLSELECT-EPO
CLMCLM-4028212026-06-17T19:31:34ZAlan—Brown2004-01-08UHC-69982-03•••-••-8397null——UNKNOWN-UNKNOWNNULLOPTIONS-PPO
CLMCLM-4108422026-01-09T22:34:43ZRios, Ann——2030-07-20uhc-55469-74—9004213373—6732 Valley View Dr #284Eden PrairieMinnesota··55331··null—
CLMCLM-4074502026-01-03T13:48:04ZAnnV.Sullivan1992-08-26UHC-58187-57•••-••-4115NULL—5172 JEFFERSON AVEHoustonTX77003··GRP-7101SELECT-EPO
CLMCLM-4168542026-08-15T16:11:31ZJEFFREY—MENDOZA1965-08-12—null637-471-5196—3159 Canyon RoadDallasTX75221GRP-1549CORE-HMO
CLMCLM-4126722026-01-04T19:21:24ZPAMLA—WASHINGTONFeb 15, 1955UHC-44348-23-————nullUNKNOWNGRP-3332NAVIGATE-HMO
CLM CLM-4126252026-09-01T10:05:31ZMICHELLE—SULLIVAN·9/10/1970UHC-84688-80NULL——5469 Union St Apt 2ChandlerAZ85274GRP-9436··—
CLMCLM-4084002026-02-07T15:10:41ZAnthony··Henderson1989-01-09NULL•••-••-2950226.227.0341NULL3140 CENTRAL AVENUETucsonAZ85701-4599GRP-2465—
CLMCLM-4066322026-01-15T08:08:30ZJoe··Stephens20080205—•••-••-6355—UNKNOWN-—UNKNOWN-GRP-4538····
CLMCLM-4291492026-09-22T16:40:14ZCAMILA—RIOS··1963-11-18UHC-12493-59——UNKNOWN··3286 Indian School Road··Tempe···AZ85295GRP-1346—
CLMCLM-4096762026-02-25T06:52:46Z Margaret—Hernandez2008-07-14NULL•••-••-9164——7702 Main StMiamiFL33128NULL-
CLMCLM-4318032026-09-30T15:36:21ZMark—Henry1980-11-23UHC-38838-78··UNKNOWN5085291567null8259 Sunset BlvdSacramento·CA95820GRP-0271NULL
CLM CLM-4249702026-08-28T11:23:01Z JACOB····KELLY12/10/1987-•••-••-5214+1 614 730 2300--nullNULL··UNKNOWNGRP-9832·null
CLMCLM-4042662026-02-11T12:32:55ZCHRISTINAYPHILLIPS10/12/44UHC-66533-38•••-••-3748—N/A5413 Canyon RoadSCOTTSDALEAZ··85230GRP-4305null
CLMCLM-4147402026-07-18T08:57:48Z·OBrien, Sandra——1985-10-07UHC-52659-90··—+1 900 916 6639SANDRA.OBRIEN@PROTON.ME7731 SPRING STREETAtlantaGA30320·GRP-0631MEDICARE-ADV-A
CLMCLM-4199352026-10-02T17:52:10ZArjun····Jones19790619UHC-20049-53•••-••-7388(761) 899-4381—5653 Spring StMesaAZ85223-5650GRP-8336MEDICARE-ADV-A
CLMCLM-4109422026-03-17T19:50:16Zvalentina····ray2000-05-10UHC-34927-03•••-••-05145616824492··-3346 Sunset BlvdFresnoCA93750GRP-4931··OPTIONS-PPO
CLM CLM-4253072026-02-15T17:15:11Z·Gloria—King1976-07-02—null····-932 Ocean AvenueDenverCO80271-7485··GRP-8126NAVIGATE-HMO
CLMCLM-4158192026-10-02T04:41:53Z·Gerald—Hunter04-07-2008UHC-11413-03•••-••-1757-·GERALD.HUNTER18@GMAIL.COM5105 Sunset BlvdColumbus··OH43216GRP-8394—
CLMCLM-4114892026-09-01T09:46:54Z Lucia—Bailey1938-08-26UHC-99380-89nullnulllucia.bailey@aol.com5146 Meadow LanePlanoTX·75054GRP-4492MEDICARE-ADV-B
CLMCLM-4059772026-06-30T14:13:42Z·AHMED—GIBSON2001-11-13UHC-08757-66null324-218-4962ahmed.gibson@outlook.com1726 Valley View DrSAN ANTONIOTX78217GRP-4277MEDICARE-ADV-A
32,829 rows, page 3 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.414Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty