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-4148722026-03-30T05:06:56ZElizabeth··George1960-05-24··null•••-••-1911·6874665661elizabeth.george@hotmail.com2879 SUNSET BOULEVARDCHANDLERaz85210GRP-4558OPTIONS-PPO
CLMCLM-4000872026-05-15T22:26:09ZWei—Garza1973-05-15UHC-61834-78——-1790 Maple AvenueSeattlewa98131GRP-5121·null
CLMCLM-4191672026-07-21T09:56:27ZAlbert—Carr1966-02-09UHC-81559-93—·NULL—·-NULLN/A··nullNULLOPTIONS-PPO
CLMCLM-4295272026-03-19T03:24:03ZFrances—Bryant1943-02-02—NULLNULL-1254 JEFFERSON AVETAMPAFL33688-6299GRP-1707N/A
CLMCLM-4311912026-03-24T15:58:20ZAustin—Lucas09/07/1968nullnull··UNKNOWNNULL-NULLN/A—GRP-8964NAVIGATE-HMO
CLMCLM-4061032026-09-19T23:22:10ZSantiagoJ.Crawford20050522—•••-••-4823N/A—3072 MAIN STREETColumbusoh43203——
CLMCLM-4038482026-06-07T12:40:53ZCatherineI·Richardson2005-08-26UHC-15592-78•••-••-48158617857017CATHERINE.RICHARDSON24@ICLOUD.COM2274 CHURCH STREETScottsdaleAZ85238-4162UNKNOWNCORE-HMO
CLMCLM-4047182026-04-03T11:29:22ZSamuel—Johnston1978-02-08NULL———null————-
CLMCLM-4043412026-04-07T07:20:45ZDENNIS····MURHY1974-07-05UHC-83602-05—2563532—8539 Oak Street Apt 18MinneapolisMinnesota··55417GRP-1217null
CLMCLM-412345 2026-09-17T19:57:48ZFrances—Harvey1985-03-28null•••-••-83677026477439N/A3719 MESA DRIVEMinneapolisMN··55414GRP-1326-
CLMCLM-4292132026-05-24T13:13:29Z Betty—MorenoNov 17, 1952UHC-41237-68•••-••-4812-··betty.moreno@yahoo.com4291 WASHINGTON STREETHoustonTX77063GRP-1341NAVIGATE-HMO
CLMCLM-4301502026-09-07T11:40:38ZHoward, Samantha—····1955-11-11UHC-54388-27—N/A—7572 Cedar LnGilbertAZ85280UNKNOWN-
CLMCLM-4250212026-07-28T20:44:23ZMARIA—HENRY··1981-02-04NULL··——····4187 CENTRAL AVENUEPlanoTX75053-1212GRP-1023CORE-HMO
CLMCLM-4317662026-08-28T09:33:30ZHeather—Carpenter21-04-1995UHC2599183-(709) 459-0704N/A7891 Forest AvenueSan DiegoCA·92173NULL—
CLMCLM-4003112026-08-02T01:42:54ZKENNETH····FLORES1991-11-17UHC-45261-61—8689873126—456 MEADOW LANE·GLENDALEAZ85337GRP-9452OPTIONS-PPO
CLMCLM-4178652026-05-12T10:11:14ZJACQUELINECMALDONADO1983-10-05—•••-••-4569NULLN/AUNKNOWN····——N/AN/A
CLMCLM-4195352026-02-09T13:38:59ZVincent—Guerrero09/01/1965UHC-79757-63-N/AN/A4646 Baseline Rd··MinneapolisMN55483GRP-5970MEDICARE-ADV-B
CLMCLM-4211992026-09-11T03:44:28ZGuzman, Madison——2008-05-25UHC-78690-13—N/A—9638 Park PlGLENDALEAZ85311-NAVIGATE-HMO
CLMCLM-4252972026-06-13T22:29:07ZLe, Roger····—19871214UHC-84334-48—N/A—9800 Cedar LaneAustinTX78739N/ACHOICE-PLUS-PPO
CLMCLM-4184022026-10-04T01:42:29ZLane, Eugene——1976-10-05UHC-40068-81N/A(513) 688-1153N/A8792 Main StCharlotteNC28286GRP-7461SELECT-EPO
CLMCLM-4191952026-04-26T15:27:01ZSantos, Bruce——1996-02-23N/ANULL(360) 236-2372—4163 OCEAN AVENUEMiami·FL33122-4028··—CORE-HMO
CLMCLM-4005002026-08-11T10:42:35ZARTHUR—WRYGHT19431218UHC-32304-69-17375308335··-7348 Baseline RdLas VegasNV89112GRP-9097OPTIONS-PPO
CLMCLM-4273952026-09-05T20:27:38ZJustin—Ruiz1979-04-22UNKNOWN-NULL-6445 JEFFERSON AVENUE Apt 32AustinTX78715·GRP-5991N/A
CLMCLM-4097442026-10-09T23:33:36ZJennifer—Carr9164-06-16—-——UNKNOWN——nullGRP-3562MEDICARE-ADV-B
CLMCLM-4058362026-07-19T20:38:00ZvincentN.·diaz11/18/1982—•••-••-4920-null8142 Oak Street #687·FRESNOCA·93735-5560GRP-1735-
CLMCLM-4208992026-05-13T19:03:46ZElizabeth—SchultzDec 24, 1967UHC-01992-56•••-••-3184—elizabeth.schultz@outlook.com9384 Pine Drive Apt 34FresnoCA93758GRP-2040CORE-HMO
CLMCLM-4208032026-07-22T06:12:39ZJuliaZ.Garza—UHC-69609-77·NULL—-nullUNKNOWN—nullUNKNOWN·SELECT-EPO
CLMCLM-4208852026-07-15T01:33:46Zbrtitany—guerrero24-10-1991UHC-24257-81—944-293-7989UNKNOWN6190 Spring Street·DallasTX75282GRP-0928OPTIONS-PPO
CLMCLM-4050952026-03-25T20:32:24ZVALENTINA—ALVARADO06/20/1953UNKNOWN•••-••-5447+1 249 460 3363-2353 Palm DrOrlando·FL32831—OPTIONS-PPO
CLMCLM-4174932026-03-20T12:24:57ZAliceWBryant19670803UHC-87888-26UNKNOWNnull—7231 Palm DrChandler·AZ85265GRP-8488NULL
CLMCLM-4255142026-05-23T06:09:29ZWalter—Morrsi1945-08-18UNKNOWN··•••-••-5360752-855-2367NULL9310 FOREST AVENUELAS VEGASNevada89124null—
CLMCLM-4164692026-07-25T21:59:05ZRAYMONDCSANTOS1959-02-12UHC-31261-86—NULL—1830 SPRING STATLANTAGeorgia30311GRP-4600·MEDICARE-ADV-A
CLMCLM-4029142026-07-28T07:54:27Z DENNIS—GUTIERREZ1984-04-08UHC4152439•••-••-5892—-———N/Anull—
CLMCLM-4074842026-07-15T22:07:21ZABIGAILN.HICKS20010405UHC-46842-79NULL19654116494NULL··251 HILLCREST RDSEATTLE·WA98176GRP-2410-
CLMCLM-4053392026-05-13T17:23:00ZLuis—Hill1942-10-27UHC-27600-40•••-••-7985UNKNOWNUNKNOWN7828 Meadow LnGILBERT·AZ·85271-N/A
CLMCLM-4150922026-02-26T01:59:16ZDANIEL—REID·1939-01-23—•••-••-6348477.524.0045null8395 Camelback RoadColumbusOH43209··GRP-1246N/A··
CLMCLM-4108272026-03-13T14:07:04ZDorothy—Garcia1949-05-15·UHC-92624-48•••-••-7755—DOROTHY.GARCIA37@OUTLOOK.COM6761 Sunset BlvdDenver·CO80299UNKNOWN··N/A
CLM CLM-4224162026-10-06T00:17:56ZGary—Espinoza1941-02-25UHC-09582-44•••-••-5991423-466-5072N/A1967 Union StreetSCOTTSDALEAZ85237GRP-3386UNKNOWN
CLMCLM-4179932026-06-27T12:32:39Z ·katherine—holmes10-04-1985UHC-14243-68··N/A——3359 Jefferson AveHoustonTX77016GRP-1495MEDICARE-ADV-A
CLMCLM-4026452026-09-29T05:12:19ZRoy—Payne1987-01-02N/AN/AnullNULL·NULLnullUNKNOWNnullnull·NAVIGATE-HMO
CLMCLM-4294972026-05-17T19:20:51ZMARIALMORENO2007-11-28UHC-61343-62N/A306-788-1041N/A9319 Apache BoulevardTampaFLN/A·GRP-8292options-ppo
CLMCLM-4001732026-03-05T10:19:44Z Janice··Rivera1975-04-23UHC-27879-12—(812) 538-0707—708 BASELINE RDDenverCO80257GRP-8668—
CLMCLM-4027002026-04-28T21:23:48ZArthurSBurton1996-05-21UHC-20218-65•••-••-5957N/AN/A8899 Cedar LnJacksonvilleFL32238—navigate-hmo
CLMCLM-4245512026-08-26T09:44:13ZJoan—Mendoza02/17/1951UHC-92655-07-16072545982··N/A—UNKNOWN··NULLGRP-4832CHOICE-PLUS-PPO
CLMCLM-4166502026-06-30T23:31:50ZChristine—Smipson··1943-05-14NULL•••-••-2355-·nullNULL——nullGRP-1933MEDICARE-ADV-A
CLMCLM-4085512026-09-07T09:07:55ZAnderson, MarianaD.—20001014UNKNOWN•••-••-3369—N/A340 Ocean AveCOLUMBUSOH43274null·CORE-HMO
CLMCLM-4278502026-01-24T02:16:49Zdlyan—cole01-07-2004UHC9358847—--6513 Cedar LanePhoenixAZ85086-7915NULL—
CLMCLM-4016022026-04-03T20:49:31ZDouglas—Carr0301-91-67UHC-34967-07-UNKNOWN—8779 HIGHLAND AVEPhoenixAZ85020—·NAVIGATE-HMO
CLMCLM-4167962026-06-06T12:10:16ZNICHOLAS—·JACKSON1974-02-26UHC-76666-47•••-••-3341-—-NULLUNKNOWN—N/A—
CLMCLM-4018852026-04-14T17:05:36ZBRANDONMFOX2005-04-28UHC-96771-85——-——--N/AUNKNOWN
32,829 rows, page 7 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.418Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty