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-4109432026-09-30T16:04:58Z Ray, ValentinaC.—2000-05-10UNKNOWN•••-••-05145616824492NULL3346 SUNSET BLVDFresnoCA93750GRP-4931—
CLMCLM-4266932026-02-05T16:35:59Z·Lucya—Torres1981-05-24UHC-10261-77-(807) 886-0849N/A7826 WILLOW COURTChandler·AZ85240N/AN/A
CLMCLM-4114512026-01-21T03:31:10ZMarcus—Armstrong1950-08-07UNKNOWN-383-952-5702marcus.armstrong@aol.com8701 Meadow Ln·San DiegoCA92132GRP-7991-
CLMCLM-4165992026-03-21T07:14:00ZLawrence···Williams1987-07-11UHC-68040-19-—lawrence.williams@icloud.com7519 Highland AveMinneapolisMN55461GRP-7995MEDICARE-ADV-B
CLM CLM-4014452026-07-29T16:55:42ZAndrea—Soto2004-11-26UHC-05668-40N/A319-237-3196null——NULLN/AGRP-7006MEDICARE-ADV-B
CLMCLM-4066292026-10-17T16:06:09ZHoward, William——1946-05-27··-(632) 215-7771—9694 Bayshore DriveNashvilleTN37277nullCHOICE-PLUS-PPO
CLMCLM-4217202026-03-26T07:00:02ZMATEO—SILVAJan 2, 2008—NULL633.352.3061N/A4577 Camelback RoadCOLUMBUS·OH43210GRP-8433NULL
CLMCLM-4132382026-06-21T14:42:11ZCYNTHIA—·ROBINSON1980-09-09UHC-24600-14———····—NULLGRP-8442choice-plus-ppo
CLMCLM-4028852026-01-01T22:50:40ZChapman, Noah——20020415—•••-••-47299046434—397 Palm DrPHOENIXAZ-GRP-7778OPTIONS-PPO
CLMCLM-4215292026-07-05T23:49:47ZOMAR—WEBB05/23/39UNKNOWN—UNKNOWN·-127 CHURCH ST Apt 11San AntonioTX78272-4898—null··
CLMCLM-4127832026-08-26T19:07:25ZCHRISTINAM.HERRERASep 19, 1954··UHC-81624-09null····—6995 Pine Drive·PlanoTX——OPTIONS-PPO
CLMCLM-4197612026-02-05T18:18:55ZCYNTHIA—CARLSON1994-02-25UHC-58426-35nullUNKNOWNN/A7120 OAK STREET··Las VegasNV89110GRP-0115medicare-adv-a
CLMCLM-4080502026-02-18T00:32:40ZKathleen—CarterOct 28, 2004—•••-••-1834(832) 688-2961kathleen.carter@aol.com2278 PINE DRMiamiFL33160UNKNOWNNULL
CLMCLM-4115902026-06-11T13:41:49ZTeresa—Nguyen··1975-04-20UHC-74299-44N/A(839) 254-9670-5453 Lincoln WayHOUSTONTX77059-0218GRP-4174—
CLMCLM-4166352026-05-17T11:31:54Z·Rayymond—Stone1944-04-18UHC-79612-67•••-••-6115NULL-8000 Park PlaceTampa··FL33670—N/A
CLM CLM-4304332026-04-20T14:34:05ZJoan—Mdeina1968-02-10—•••-••-8635NULL··JOAN.MEDINA@HOTMAIL.COM4462 OAK STOrlandoFL32890-5711GRP-1695MEDICARE-ADV-B
CLMCLM-4279412026-05-12T03:25:21ZChristine—Carroll1964-07-11UHC-73179-44-UNKNOWN-327 Sage CourtMesaAZ85231GRP-9136CORE-HMO
CLMCLM-4019962026-06-08T00:09:02ZMarcus—Bennett1950-06-07UHC-69159-18—574-374-6773marcus.bennett76@outlook.com—UNKNOWN—null-OPTIONS-PPO
CLMCLM-4163862026-03-17T00:54:47ZJanice—Carlson1973-10-08—•••-••-2128NULL—5916 Hillcrest RdSan AntonioTX··78288GRP-6806—
CLMCLM-4077952026-03-20T19:41:54ZZachary—Aguilar1944-03-27·null··396-415-1017··6999 Palm DrJacksonvilleFLUNKNOWNGRP-2660UNKNOWN
CLMCLM-4128452026-03-30T23:06:17Zjerry····romero03/24/1964UHC-98312-99•••-••-6540·-null855 Lake View Road Apt 2TUCSONaz85786GRP-5539N/A
CLMCLM-4041522026-06-21T09:58:45ZOLIVIA—FOX1976-01-11UHC-47212-39N/A··(777) 831-4682—1864 Market StreetAustinTX78750—·-
CLMCLM-4057122026-10-14T06:20:39ZLIS—RICHARDSON10-06-1990UHC-29830-20•••-••-9983UNKNOWNN/A7253 ELM STREET #117··Los AngelesCalifornia90080GRP-3579MEDICARE-ADV-B
CLMCLM-4235522026-01-10T12:42:53ZDoris—Castillo1982-09-17—NULL910.274.5382··—9025 Highland Avenue··Columbus··OH43264·GRP-1494CORE-HMO
CLMCLM-4113932026-06-06T02:59:17ZJordan, Lori——1985-05-24UHC-12979-70NULL7214927607··3367 Ocean AveMESAArizona85209GRP-3687—
CLMCLM-4161972026-04-09T19:50:10ZJUSTIN—JENKINS1957-12-15··—N/AN/AUNKNOWN9632 Palm Dr··ScottsdaleAZnullGRP-0830—
CLMCLM-4199502026-02-07T06:04:03Z evelynL.le1993-12-09··uhc-70727-05N/A-—1620 Central AveGlendaleAZ85349NULL—
CLMCLM-4096862026-05-27T06:04:40ZIsabellaFSandoval19600925UHC-55384-75•••-••-2087UNKNOWN—3929 Mountain View DriveLos AngelesCalifornia90073··—MEDICARE-ADV-B
CLMCLM-4120222026-03-08T19:47:51ZPATRICIAGMUNOZ1947-10-21NULL··•••-••-88099294153586—·3866 UNION STREETTucson··AZ85757·GRP-8628·-
CLMCLM-4105632026-05-24T23:47:42ZNelson, Mei——05/06/1998UHC-81996-09•••-••-44399375833268-6349 INDIAN SCHOOL RD #558San AntonioTX78263-6751null—
CLMCLM-4084102026-06-25T01:31:34ZLUIS····PETERSON9/10/1981UHC-91715-29•••-••-4695636-537-4820-807 Canyon Rd··Los AngelesCAUNKNOWN—NULL
CLMCLM-4269122026-04-26T10:35:14ZSUE—MORRISON1959-02-28UHC-92801-47•••-••-5423UNKNOWN····2746 Apache BlvdDenverCO··80252N/ACHOICE-PLUS-PPO
CLMCLM-4012102026-01-24T17:38:48Z Deborah—Castro1946-08-12NULL•••-••-5330-—2479 Baseline Rd··ChandlerArizona85238··nullNULL
CLMCLM-4041042026-07-27T21:34:36ZZacharyRCarpenter09/12/1946N/A—3255728760—NULL—·null··-OPTIONS-PPO
CLMCLM-4021212026-08-18T08:29:45Z ROGER—LAWSON1951-02-25UHC-16804-72•••-••-2005null·N/A9864 Washington StTempeAZ85210··GRP-8845-
CLMCLM-4073152026-03-12T03:58:15ZEmily—Specer2002-01-14UHC-55914-20•••-••-9818null—7951 Bayshore Dr Apt 15Los AngelesCA90029GRP-3111NULL
CLMCLM-4221032026-01-24T13:45:25Zjean—chavez1965-06-07UHC-97809-22—(767) 331-3354JEAN.CHAVEZ85@OUTLOOK.COMnull—·nullnull—null
CLM CLM-417645 2026-02-14T08:14:28ZDiana—Bailey1999-10-21UHC-96404-93—18945819690diana.bailey74@proton.me7001 Central AveSan AntonioTX78246GRP-8968UNKNOWN
CLMCLM-4060542026-06-14T07:56:04Zlaura—perkins28-09-1956UHC-63015-71•••-••-18068206778065··UNKNOWN5448 BASELINE RDMinneapolisMN55493GRP-9529MEDICARE-ADV-B
CLMCLM-4014942026-07-01T04:03:17ZSofia—Chen1996-09-25UHC1845222NULL(455) 741-9514SOFIA.CHEN@OUTLOOK.COM7943 Washington StPhoenixAZ85006nullUNKNOWN
CLMCLM-4021832026-04-18T00:34:04ZSUSAN—MONTGOMERY1962-01-04·UHC-46842-28·-———NULLNULLnull——
CLMCLM-4064322026-05-08T14:09:40ZBILLY—HUNT1995-07-25NULL··—(397) 993-9228·NULLnull-null—GRP-7818MEDICARE-ADV-B
CLMCLM-4033672026-07-17T03:58:56ZJulieMStephens12/10/1945·UHC-77192-02•••-••-36976194581058——UNKNOWN----
CLMCLM-4300912026-02-25T00:51:27ZYuki—Spencer·6/28/1940UHC-90438-72-8185216253—2541 Cedar Lane #513PlanoTX75002-6312GRP-7087MEDICARE-ADV-A
CLMCLM-4298932026-01-05T09:20:13ZCarlos—Grant·1982-04-25UHC-60171-08··•••-••-6457null—7336 UNION STSACRAMENTOCA95866GRP-4670CHOICE-PLUS-PPO
CLMCLM-4147082026-06-11T21:52:30ZRandy—Simpson·1953-11-15UHC-07224-49•••-••-0310(830) 298-6455N/A4237 Camelback RdSan AntonioTX78258GRP-7946CORE-HMO
CLMCLM-4114302026-09-06T11:35:56ZJOE—TORRES1985-05-16UNKNOWN•••-••-5976UNKNOWN·-7285 Indian School RoadTucsonAZ··85743GRP-5077-
CLMCLM-4228632026-08-29T02:35:30ZALAN—FORD1952-08-28—•••-••-3726—UNKNOWN6670 Baseline RdGilbertAZ85280—NAVIGATE-HMO
CLMCLM-4052242026-02-20T18:41:17ZCharlotte—Snyder1952-11-17UHC-56383-06N/A-N/A···4879 Maple AveSacramentoca95868GRP-8433··—
CLMCLM-414016 2026-09-10T18:08:52Z·Frances—King1988-05-04UHC-31602-81UNKNOWN(506) 582-0088-6888 FOREST AVENUETEMPEAZ85254GRP-6655OPTIONS-PPO
32,829 rows, page 53 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:36.704Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty