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-4049422026-05-03T03:22:27ZRUSSELLF.MORALES1969-02-22-•••-••-3222254-322-8009-4402 Desert Sky Boulevard #269TucsonAZ85744—N/A
CLM CLM-4063752026-07-13T17:54:36ZARJUN—CONTRERAS10/11/1953UNKNOWNN/A·461-354-8235UNKNOWN7886 Willow CtFresnoCA93758-7809-MEDICARE-ADV-A
CLMCLM-4027072026-03-10T14:00:12ZTeresa··—Freeman1960-04-11UHC-86980-83•••-••-5302——6947 ELM STREETMiamiFL33116NULLNAVIGATE-HMO
CLMCLM-4053892026-07-16T01:55:09Z ANDREW—GUTIERREZ1981-04-13UHC3034883—-···NULL·7873 CEDAR LN Apt 28Los AngelesCA90061GRP-8130—
CLMCLM-4013912026-04-28T14:58:17ZScottI.Evans·1939-08-08UHC-99603-38—··UNKNOWN·9001 Union StreetNashvilleTN37274GRP-5512—
CLMCLM-4304572026-06-02T19:50:01Zbenjamin—ferguson19480220NULLnullUNKNOWNN/A6269 Willow Ct··Eden PrairieMN··55325-4587GRP-8177-
CLMCLM-4221212026-09-02T18:37:03ZLISA—STEWART1976-12-24UHC-90359-21•••-••-9359608-779-5089····8323 Harbor BlvdHOUSTONTX77005nullCORE-HMO
CLMCLM-4226762026-03-25T11:50:05ZSophia··Foster·1990-08-12UHC-38594-20•••-••-5473236-425-6732UNKNOWN6771 FOREST AVEOrlandoFL32893-MEDICARE-ADV-A
CLMCLM-4033402026-02-28T23:56:36Zpaul—little1984-11-06UHC-44878-82··-(212) 798-1973—·3698 BAYSHORE DRLos AngelesCA·90010GRP-1552—
CLMCLM-420030 2026-03-10T19:00:45ZFoster—·Doris1950-02-27UHC-91756-79N/A7875584993NULL5527 Pine DriveLas Vegas·NV89154GRP-7862OPTIONS-PPO
CLMCLM-4155322026-03-27T08:49:09ZLAURA—RAMOS1995-07-22UHC-35531-48null··8625474N/AUNKNOWN———GRP-8909N/A··
CLMCLM-4167072026-08-22T00:59:36ZROMERO—CAMILA1941-04-20UHC-45685-14—(396) 804-7708··-—nullUNKNOWNGRP-3049N/A
CLMCLM-4162962026-01-22T11:46:20ZJerry—Watkins1957-07-07UHC-20153-72··—+1 940 770 3748—2207 Washington Street #434Los AngelesCalifornia90098GRP-3716—
CLMCLM-4242102026-08-31T12:04:44ZAnna··—Hamilton1982-06-21NULL•••-••-5723—N/A··6670 Apache BlvdAtlantaGA·30326GRP-1207null
CLMCLM-428048 2026-04-26T07:34:47ZJACQUELINE··YOUNG1998-06-17··UHC-15249-84—6488046528-3079 Oak StFRESNOCA93739UNKNOWNCORE-HMO··
CLMCLM-4040812026-03-19T06:52:29ZAna—Fuller1978-10-18UHC-64825-97··———9872 SPRING STREETPhoenixAZ85042GRP-8602NAVIGATE-HMO
CLMCLM-4305402026-10-09T19:55:22ZSandraQ.White2005-05-03—UNKNOWN··948-544-9274—2142 Indian School RdAtlantaga30380NULLOPTIONS-PPO
CLMCLM-4317402026-01-02T14:22:42ZLidaJWite1948-03-14———LINDA.WHITE@GMAIL.COM·UNKNOWN—UNKNOWNNULL··—null
CLMCLM-4182072026-01-26T22:29:32Z·JANICE··VALDEZ01/23/1979UHC7178060•••-••-8923—JANICE.VALDEZ@PROTON.MENULL—-UNKNOWN—UNKNOWN
CLMCLM-4149932026-03-19T10:41:44ZKiethLJones1987-01-29UHC-95396-91N/A2474192342··5349 Palm DrORLANDOFlorida32884N/Amedicare-adv-a
CLM CLM-4294792026-08-11T08:15:57ZDenise—OBiren1947-05-13····•••-••-6674——9137 INDIAN SCHOOL ROADNASHVILLETN37280GRP-4742NAVIGATE-HMO
CLMCLM-4106642026-07-21T00:50:38Z Carolyn—King1957-07-13nullnull—null2064 PARK PLSan AntonioTX78271GRP-8830N/A
CLMCLM-4076162026-07-19T08:01:14ZBARBARA—ROJAS05/22/74—•••-••-8484+1 311 689 6591NULL8037 CHURCH STREET·MIAMIFL33161··—CHOICE-PLUS-PPO
CLMCLM-4046742026-06-15T16:35:06ZSophia—Hill12/15/60NULL•••-••-6183—sophia.hill@hotmail.comN/A·N/A—nullnullCORE-HMO
CLMCLM-4015702026-04-23T01:22:23Z DavidXGraham20030912—UNKNOWNNULLNULL2470 LINCOLN WAYPlanoTX75031GRP-8526OPTIONS-PPO
CLMCLM-4040702026-01-04T00:02:59ZAbby—Hunt··1979-11-28UHC-64284-36•••-••-9360·+1 983 476 1383UNKNOWN8501 PARK PLACEHOUSTONTX77002GRP-3245··CORE-HMO
CLMCLM-4099412026-08-21T11:30:00Z GERALD··—CARPENTER1978-50-07UHC-74053-63•••-••-0692(594) 902-8540NULLN/AnullNULLN/AGRP-7822—
CLMCLM-4194222026-07-18T11:51:03ZSanchez, Sharon——1996-03-09UHC-45305-19—nullNULL6949 Canyon RdTempeAZ85271-8978GRP-7597OPTIONS-PPO
CLMCLM-4204122026-06-17T02:01:21ZEspinoza, Jason——09/06/59UHC-11220-61•••-••-1773nullN/A7502 Central AveMiamiFlorida33109NULL-
CLMCLM-4247312026-08-26T12:47:48ZWillis, Philip——Feb 27, 1968N/A•••-••-8559UNKNOWN—8286 Bayshore DrSeattleWA98134GRP-3858UNKNOWN
CLMCLM-4012252026-09-05T22:19:37ZANNSLOPEZ1940-11-23-•••-••-7435860-959-6207—61 Sunset Boulevard··PlanoTexas75061UNKNOWNNAVIGATE-HMO
CLMCLM-4304392026-07-23T16:40:41Zgerald—anderson··1999-08-03UHC-60914-75—(780) 908-5422—6481 Lake View RdMesaAZ··85283GRP-3457-
CLMCLM-4063812026-04-13T17:31:30ZWillVSnyder1941-06-07UHC-46716-69—UNKNOWN-1256 Baseline RoadMesaAZ85266——
CLMCLM-4324902026-08-12T05:28:27ZMartinez, RogerG.—·1990-03-15UHC-40330-54—null··—-null—UNKNOWNGRP-9256—
CLMCLM-4057182026-02-01T19:03:58ZEdward—Vazquez1995-04-15UHC-56813-67•••-••-1086(484) 561-2350-121 WILLOW CTChandlerAZ85228GRP-1919CORE-HMO
CLMCLM-4162612026-04-05T15:33:37ZBurton, Heather——06/15/2002UHC-68676-39N/A(853) 423-9768heather.burton@icloud.com308 Central Ave··MiamiFL33113GRP-7653CORE-HMO
CLMCLM-4140092026-10-07T21:59:31ZSEAN—VARRGAS6/5/1992——····N/A1611 LINCOLN WAYMesaAZ85267—·MEDICARE-ADV-B
CLMCLM-4043582026-08-07T20:58:56ZBobby—·Garcia03/16/2005N/A··UNKNOWN-7314 Valley View DriveDenver··CO80273NULL—
CLMCLM-4037302026-02-21T01:11:14ZJSESICA—BERRY1982-06-25null•••-••-1122219-362-2562-UNKNOWN····nullnullGRP-8117NULL
CLMCLM-4270572026-04-26T11:26:09ZJason··—Jacobs1948-11-06··UNKNOWN•••-••-5472938.829.9196N/A—UNKNOWNUNKNOWN—NULLNAVIGATE-HMO
CLMCLM-4305112026-06-18T06:12:49ZRUTH—SCHULTZ2/4/2007UHC-03534-70null(746) 528-0856ruth.schultz71@proton.me1937 Bayshore DrSan AntonioTXnullGRP-7564CORE-HMO
CLMCLM-4312702026-04-06T12:04:59ZAliceTOrtiz19710413UHC-15710-14NULLNULL-152 Maple AveSeattleWA98195——
CLMCLM-4273162026-06-25T20:07:46ZBARB—LE1992-08-02UHC-98952-77UNKNOWN··5407524069—7733 Mesa DrSacramentoCA95861GRP-0213-
CLMCLM-4159232026-03-10T05:44:17ZMarcusB.Alexander11/15/1987UHC-89293-82•••-••-1436NULL—1390 Valley View Drive Apt 6TempeAZ85294GRP-8225CORE-HMO
CLMCLM-4271172026-01-21T16:33:25ZGabriel—Gonzalez1939-10-10UHC-48725-02—(755) 603-9946—2465 Central Avenue #885OrlandoFL32877NULL··
CLM CLM-4189772026-03-09T13:43:06Zsarah—·lna1994-12-16—•••-••-4601UNKNOWN—7313 Bayshore DriveSacramentoCA95800GRP-8505OPTIONS-PPO
CLMCLM-4084712026-06-03T15:40:40ZMark—Gonzalez1967-09-04UHC-02868-86-(507) 220-0436—3768 Baseline RdHoustonTX77055UNKNOWN—
CLMCLM-4243082026-09-27T03:21:44ZMORRISON—WEI07/26/56—-9546831872UNKNOWN—nullN/ANULLGRP-2605MEDICARE-ADV-A
CLMCLM-4291302026-07-01T19:44:10ZMaryHMaldonado05/10/62UHC-19356-27•••-••-6366+1 781 547 9834UNKNOWN2125 WILLOW COURTNashvilleTennessee37207-1301UNKNOWNSELECT-EPO
CLMCLM-4302062026-09-26T04:16:45ZAustinYSingh1955-12-07uhc-58954-14•••-••-5551+1 880 443 6920-8652 Indian School RdPhoenix·AZ85054····null
32,829 rows, page 141 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:40.322Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty