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
CLM CLM-4133092026-02-19T04:45:38Zdiana—perry-UHC-40741-22——····—NULLNULLN/AGRP-8805UNKNOWN
CLMCLM-4257362026-03-20T06:26:40ZShaaron—Stevens08/04/48-——null··5794 Jefferson AvenueLos AngelesCA··90084GRP-3137options-ppo
CLMCLM-4182932026-06-22T19:58:26ZJONATHANIHUGHES1980-01-09UHC-60893-02•••-••-1877-UNKNOWN-—-UNKNOWNGRP-0450CHOICE-PLUS-PPO
CLMCLM-4168552026-06-03T03:41:36ZJeff—Mendoza··1965-08-12UNKNOWN•••-••-3320——3159 Canyon RoadDallasTexas75221——
CLMCLM-4278482026-01-11T17:27:56ZSean—Mason1981-04-12null··N/A811-500-6873NULL9549 HARBOR BOULEVARDChandlerAZ85230GRP-4277-
CLMCLM-4125912026-06-10T07:06:43ZJordan—Wheeer1976-50-20UHC-68353-50UNKNOWNUNKNOWNUNKNOWN7792 SAGE CTDALLASTX-N/AOPTIONS-PPO
CLMCLM-4324272026-04-12T07:36:03ZJUSTIN—CRUZ19440918UHC-59406-30—419.677.8148—2917 Ridge RdSan AntonioTX··UNKNOWN-CORE-HMO
CLM CLM-4123832026-08-10T05:54:11Z·Mariana—Wagner1966-02-27UHC-61747-82•••-••-6948UNKNOWN—2487 Oak StreetLos Angeles·CA90001GRP-7086—
CLMCLM-4030632026-06-07T07:38:04ZAngela—Franklin··1956-01-13··UHC-82634-27N/ANULLnull8529 Lake View RoadScottsdaleAZN/A—CORE-HMO
CLMCLM-4257692026-09-08T04:13:01ZAdam—Vega1992-02-01UHC-59055-13UNKNOWNNULL—·3499 Canyon RoadChandlerAZ··85205—OPTIONS-PPO
CLMCLM-4291712026-07-11T11:20:03ZTeersa—Sims19700208UHC-19809-99UNKNOWN749-654-2572N/A9686 INDIAN SCHOOL ROADLos AngelesCA90042-8372GRP-8377·N/A
CLMCLM-4215642026-04-05T13:12:56Zjulie·Msingh1975-08-19UHC-47477-34•••-••-9689825.794.4127—4749 MAPLE AVENUEFresnoCA93721-4704GRP-4075—
CLMCLM-432467 2026-01-28T12:59:14ZDonald—Simpson19760723UHC-22050-94•••-••-1514nullNULL2920 Central AvenueDenverCO80253·GRP-8249—
CLMCLM-4032702026-05-16T06:03:09ZSimpson, JulaiJ.—·27-02-1946UHC-55962-37—UNKNOWN—4726 Mesa DrNashvilleTN37231-8836N/Anull
CLMCLM-4093502026-01-14T20:12:34ZTEERSA··—WILLIAMSON1981-01-26UHC-54512-54—N/AN/A2913 LINCOLN WAY Apt 6DallasTX75257GRP-6578SELECT-EPO
CLMCLM-4194252026-09-18T12:41:12ZJDUY—SCHMIDT·11/05/1998UHC-15358-33•••-••-4006826-492-0115NULL····N/A——GRP-2291MEDICARE-ADV-B
CLMCLM-4252772026-09-26T22:09:28ZCarolyn—Flores1999-05-06·UHC-73681-40UNKNOWN843-753-3164-··3976 Camelback RoadGlendaleAZ85375GRP-3510—
CLMCLM-4239252026-07-10T16:37:47ZMarcus—Fuller19671211nullNULL·NULL—9406 INDIAN SCHOOL ROAD··Scottsdale·AZ85291-6301GRP-2573—
CLMCLM-4260692026-07-30T07:05:39ZALEXANDER··MARQUEZ8/1/1978UHC-84217-49N/AnullUNKNOWN8121 Park PlDENVERCON/AN/AUNKNOWN
CLMCLM-4106302026-06-01T09:42:43ZSandra—Murphy1964-09-11UHC-12223-14•••-••-6561null—6365 Highland AvenueSan AntonioTXN/Anull·CHOICE-PLUS-PPO
CLMCLM-410820 2026-06-02T22:13:02ZLINDAI·CARTERJul 16, 1943UHC5479857UNKNOWNNULL—4169 Indian School RoadJacksonvilleFL32277—CHOICE-PLUS-PPO
CLMCLM-4190142026-09-23T13:02:24ZjoyceI·reid1965-10-13UHC-05392-10-NULL—nullnull———MEDICARE-ADV-B
CLMCLM-4011642026-10-05T01:39:05ZGuzman, Sara——1958-06-21UHC-83592-91—NULL—3218 Hillcrest RdEden PrairieMN55354GRP-9282—
CLMCLM-4231332026-05-11T03:59:22ZBruce—JacksonJan 19, 1956·UNKNOWN—N/AN/A8460 Oak StJacksonvilleFLNULLGRP-2844—
CLMCLM-409443 2026-04-06T04:46:11ZAaron—Hunt··2002-12-12UHC-82591-72—UNKNOWN—1069 Lincoln WayNASHVILLE··TN37204—OPTIONS-PPO
CLMCLM-4326012026-04-05T21:02:03ZYuki··QRossAug 22, 1993-———7576 Indian School RdAtlantaGA30325GRP-5106—
CLMCLM-4152832026-07-27T17:36:51ZKEITHICOOK25-07-1957NULL-650-731-6981·null1901 Ocean AvenueTEMPE··AZ85259—null
CLMCLM-4082972026-02-14T13:56:21Z AliceR.Mejia1971-03-07UHC8520505•••-••-270912619044980-6999 Forest AveJacksonvilleFL32267nullUNKNOWN
CLMCLM-4073422026-02-15T16:55:40Z·CarolynKMorales1953-04-20UHC-97852-59NULL—-5595 CANYON ROADATLANTAGA30380NULL··CHOICE-PLUS-PPO
CLMCLM-4023522026-03-18T23:15:15Z·RALPH—WOODS1967-07-26UHC-78850-61N/AUNKNOWN··—6887 Spring StTampaFL···33671-1218——
CLMCLM-4144862026-01-24T00:04:14ZGuzman, Sandra·M—22-03-1941UNKNOWN·UNKNOWN-··-null—nullN/AGRP-8851—
CLMCLM-4106562026-03-31T06:43:37ZAmanda—Foster1970-41-09null•••-••-4160NULL—395 WASHINGTON ST #772San DiegoCalifornia92199GRP-8427—
CLMCLM-4292392026-09-17T15:39:19ZSandra—Brown·2005-02-05UHC-38120-34•••-••-5620N/A—4287 Central AvenueMESAAZ85278··GRP-5227OPTIONS-PPO
CLM CLM-4034602026-02-02T07:08:57ZMason—YangUNKNOWNUHC-23214-93N/A5309965779UNKNOWN5607 BROADWAYSeattleWA98186GRP-8886N/A
CLMCLM-4194882026-04-29T02:14:45Z·HENRYFSHAW1951-06-13UHC-39506-66—+1 353 708 6900UNKNOWN2300 Forest AvenueNashvilleTN37232UNKNOWN—
CLMCLM-4241352026-03-12T22:10:11ZANA··—HARPER1978-05-11UHC-01916-90--NULL3484 Ocean AveSan Diego··CA92194nullMEDICARE-ADV-A
CLM CLM-4133042026-09-23T10:41:47ZMargaret····Kim1992-02-11UHC-98896-19•••-••-1320(595) 628-7335NULL4922 LAKE VIEW ROADMesaAZ·85241GRP-1058MEDICARE-ADV-A··
CLMCLM-4087302026-05-20T09:00:14ZMaria—·Fernandez1962-12-10UHC8560060NULL6428180—9762 Forest AvenueGilbertArizona85255——
CLMCLM-4261222026-03-09T02:56:37ZREBECCA··—DUNN9/20/1945UHC-28867-84NULL(986) 383-1536null3054 Harbor Blvd #205SacramentoCA·95884-····
CLMCLM-4191172026-02-11T21:48:40ZcynthiaB.turner19510910UHC-24518-02-(288) 941-8563-8782 HILLCREST ROADMiamiFlorida33107GRP-1930SELECT-EPO
CLMCLM-4012722026-04-07T00:26:07ZMASON—PORTER··1984-11-16—N/A(292) 775-6233null9563 Ocean AvenueSCOTTSDALEAZ85220GRP-3986N/A
CLMCLM-4238622026-10-03T17:44:59ZHeather—Fuller1938-09-04N/A•••-••-6795NULL····5849 Mesa DriveMinneapolisMN55478GRP-1643null
CLMCLM-4139062026-09-24T07:47:51ZHiroshi—Green1992-07-05UHC-29732-52··•••-••-1486532-600-8943····367 Harbor Boulevard·TempeAZ85249——
CLMCLM-4100842026-09-17T09:07:36ZSAREH—CARRTER1945-05-16UHC-32006-47•••-••-5412N/AN/Anull——NULLN/Anull
CLMCLM-4044272026-04-19T07:21:04ZChristina—·Castro9/16/1973UHC-59692-44•••-••-1102UNKNOWN··N/A1514 CHURCH STJacksonvilleFL32245GRP-3755—
CLMCLM-4283512026-10-14T00:28:08ZDennis—Sims··1988-04-12UHC-61431-40N/AN/AUNKNOWNNULLN/A—N/AGRP-4373MEDICARE-ADV-B
CLMCLM-4246952026-06-11T06:24:28ZBruce—·Garrett1994-08-27UHC-23825-38UNKNOWN2478657612UNKNOWN5655 Church StreetTempeAZ85209-··UNKNOWN
CLMCLM-4088042026-06-10T05:12:28ZMery—Moreno1992-12-28-—(916) 779-1678—2055 Cedar LnPhoenixArizona85050··GRP-7933SELECT-EPO
CLMCLM-4084582026-09-12T12:55:00ZMARIA—WANG4/7/1976UHC-01269-47UNKNOWN8197400242N/A6033 Mesa DrivePhoenixAZ85004GRP-9674—
CLMCLM-428276 2026-01-14T12:47:04ZBEVERLY—ROSS1960-07-26UHC-10564-44UNKNOWN3396899358-UNKNOWN··--·GRP-4069N/A
32,829 rows, page 109 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.468Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty