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-4203132026-04-13T18:51:40ZSmith, Gregory——1987-10-09null•••-••-8210402.660.4922UNKNOWN2142 Indian School RoadCharlotteNC28207··GRP-0109UNKNOWN
CLMCLM-4207752026-06-28T13:42:18ZCarol—Jacobs10/14/2004UNKNOWN•••-••-8100-NULL3789 Ridge RoadSEATTLEWA98136UNKNOWN—
CLMCLM-4258682026-02-23T18:27:43ZBobby—·Schultz1941-02-26-··null14404742418bobby.schultz82@outlook.com2048 River RoadCHANDLERAZ85289nullMEDICARE-ADV-A
CLMCLM-4280272026-01-04T08:56:40Zcarl—russell11/28/70UHC-40882-68NULLNULLN/A3970 Palm DriveDallasTX75204-1962GRP-1920OPTIONS-PPO
CLMCLM-429049 2026-02-15T13:13:07Z———1997-07-05··N/A19878415044—9217 Church StreetTampaFL—-UNKNOWN
CLMCLM-4293502026-01-22T00:29:51ZOrtega, Beverly——1950-07-16UHC-09931-26·null——830 Bayshore DriveDallasTX75209GRP-2139··
CLMCLM-4317972026-04-23T04:53:13ZCarroll, Catherine——09/27/1972NULL··•••-••-5124(429) 308-7050catherine.carroll70@outlook.com1286 BroadwayCHANDLERAZ··85236-9496GRP-2385CORE-HMO
CLMCLM-4136832026-01-27T22:53:18ZDANIEL—MYERS··2000-04-01UHC-98359-04nullnullDANIEL.MYERS@YAHOO.COM·3748 CANYON ROADTempeArizona85248GRP-9933—
CLMCLM-4205262026-04-03T10:13:11ZGeorge—Lopez13-11-1951NULL-—-9472 Sunset BoulevardSan Diego··CA92182GRP-4301MEDICARE-ADV-B
CLMCLM-4249862026-03-01T01:48:11Zlawrence—klly-UHC-38369-92•••-••-8656····lawrence.kelly@outlook.com9622 Central AvenueFresnoCA93798GRP-1596MEDICARE-ADV-A
CLMCLM-416446 2026-05-04T18:08:52ZCHARLOTE—LOPEZ27-09-1983uhc-22887-94-513-733-6497——N/AN/A—GRP-3267null
CLMCLM-4028982026-09-17T19:09:25ZWayne—Coleman12/22/1961UNKNOWN•••-••-2659360-366-4726N/Anull—··UNKNOWN--
CLMCLM-4259302026-03-31T21:49:02ZDanel—Snyder05/24/65UNKNOWN•••-••-59565536740787-2733 Grand Avenue Apt 21MinneapolisMN··55474GRP-6016—
CLMCLM-4246502026-04-04T12:13:30ZLarry····Watson11/17/1964UHC-48101-50•••-••-1811(825) 653-3324—2006 Valley View DrDenverColorado80219NULLnull
CLMCLM-4053882026-01-27T19:56:41ZMariaPRamso1947-07-08UHC-85846-50—4622716464N/A4261 Maple AvenueTUCSONAZ85707-1429UNKNOWN—
CLMCLM-4216962026-01-05T00:50:10ZEric—Morgan1995-05-07UHC-37404-89•••-••-67347144826159—798 Ocean AveMiamiFL33186—MEDICARE-ADV-A
CLMCLM-4163622026-10-02T17:08:32ZBradleyD.Burton19960928····•••-••-3897N/A-2223 VALLEY VIEW DR··TucsonAZ85775GRP-2788MEDICARE-ADV-A
CLMCLM-4116562026-09-28T13:32:00ZANN—WILLIAMSON19630410UHC-19399-24null+1 535 352 3822-402 Elm StMIAMIfl33107-··
CLMCLM-4045462026-02-24T03:09:11ZKATHERINE—WANG1986-01-14NULL——NULLUNKNOWNN/A—UNKNOWNN/AMEDICARE-ADV-A
CLMCLM-4032322026-07-12T14:00:27Z RAYMOND—SALAZAR1996-10-11NULL-—N/A9310 Bayshore DriveJacksonville··FL32238GRP-6978—
CLMCLM-4186402026-09-27T11:33:19ZNatalie—Hoffman1973-05-14—---NULLnullNULLNULLUNKNOWNCHOICE-PLUS-PPO
CLMCLM-4094142026-08-26T12:43:56ZBobby—·Harper1991-12-14-—12702784382N/A516 PARK PLACEFRESNOCA93701GRP-8385—
CLMCLM-4226132026-03-31T14:07:29ZCARLOS—WILLIAMSON1977-07-01-•••-••-1943--5335 HIGHLAND AVETempeAZ85242GRP-9366MEDICARE-ADV-B
CLMCLM-419859 2026-04-04T13:27:05ZJULIE—MALDONADOFeb 9, 2003—•••-••-6649——2499 CEDAR LANETAMPAFL33655GRP-4452NULL
CLMCLM-4004152026-06-28T01:29:02Zterry—martinez08-10-1970UHC-27731-53··672.386.1608UNKNOWNUNKNOWNNULLNULL—-null
CLMCLM-4042502026-09-28T23:36:55ZJoan—Robertson11/28/1957UHC-80182-89··•••-••-0109nullnull-N/Anull—GRP-0649MEDICARE-ADV-B
CLMCLM-4137572026-01-29T19:33:23Zgeorge····reynolds10/21/1989UNKNOWN··null+1 512 894 9093—7003 VALLEY VIEW DRIVEGlendaleAZ85329—OPTIONS-PPO
CLMCLM-4189552026-06-16T13:13:33ZSara····FordDec 4, 2005UHC-92388-04-(754) 225-6746UNKNOWN2123 Indian School RoadCHARLOTTENC28221—SELECT-EPO
CLMCLM-4189602026-08-21T13:57:02ZYuki—Boyd1947-07-04UHC-23434-82•••-••-1816——4553 OAK STREETEden PrairieMN55367GRP-5005MEDICARE-ADV-B
CLMCLM-4224112026-04-28T09:57:53Z·Carter, Joseph——1979-21-15UHC-97279-29··null253-738-3919N/A3938 Desert Sky BoulevardChandlerAZ85231··N/AOPTIONS-PPO
CLMCLM-4257942026-03-02T19:24:30Z·ALAN—MEJIA1962-09-22UHC-23357-93•••-••-7363——8642 Union StGilbertAZ85207—OPTIONS-PPO
CLMCLM-4076532026-01-04T12:16:23ZEmma—Graham1978-09-13UHC-94336-44nullN/A—6542 CENTRAL AVEGlendaleAZ85306GRP-6956NULL··
CLMCLM-4102712026-06-03T07:05:24ZRebecca—Elliott1951-07-04UHC-15131-53•••-••-30284794127303—1001 Lincoln Way Apt 37ColumbusOH43213GRP-9596—
CLMCLM-4069872026-08-02T08:12:46ZMark····Hunt1984-06-14·UHC-95867-45-17804560399—N/ANULLNULL—·N/A—
CLMCLM-4320262026-08-28T20:56:33ZjoseKcarpenter1943-04-07UHC-84499-49•••-••-5960NULLnull4048 WILLOW CT Apt 2PlanoTX75049GRP-0512MEDICARE-ADV-B
CLMCLM-4251582026-07-12T16:17:53ZVictoria—Patel08-09-1938UHC5640053NULL218.637.4578-4249 Maple AvenueOrlandoFL32819—NAVIGATE-HMO
CLMCLM-4083882026-05-24T12:28:30ZCHRISTOPHERSANDREWS·19911014-NULLNULL—·-N/AUNKNOWNUNKNOWN-CHOICE-PLUS-PPO
CLMCLM-4167112026-05-09T11:41:48ZAmber—Graene07/14/65UHC-66959-32•••-••-8776—-5664 MARKET STGLENDALEAZ·85302GRP-8968—
CLMCLM-4142972026-01-30T20:38:23ZSarah—·Tucker03/06/98UHC-97286-29—836-955-0609—·3680 Central AvePhoenixAZ·85036·GRP-8316—
CLMCLM-4248882026-07-20T04:06:40ZDENNISUHERNANDEZ1969-10-08-•••-••-4742UNKNOWNUNKNOWN8695 Mountain View DrSACRAMENTOCA·95836GRP-7157NULL
CLMCLM-4175762026-05-24T16:11:03Z·BETYS—BAKERSep 4, 1994UHC-60905-95null+1 205 433 3934···NULL·9587 Park PlaceSan AntonioTX78237UNKNOWN—
CLMCLM-4174152026-03-21T00:47:27Zangela—martin02/23/06UHC-26771-60•••-••-9271(563) 227-4890—-NULL—nullNULLnull
CLMCLM-4315252026-08-25T16:15:34ZMelissaMDominguez1955-10-15UHC-07165-11•••-••-1754(985) 530-4738—UNKNOWNN/AN/A-··GRP-2322NAVIGATE-HMO
CLMCLM-4006102026-05-06T04:41:44ZROGERP.TRAN-UHC-00583-18NULL7616571574—2965 Camelback RdSan AntonioTX78238—SELECT-EPO
CLMCLM-4028062026-07-18T06:24:27ZLaura····Harper1954-08-11—··8494369446··null7036 Lake View RdLos AngelesCA—GRP-6418SELECT-EPO
CLM CLM-4266292026-01-16T18:44:51ZJACQUELINE—WANG09/15/39UHC-08240-16—NULL—2150 Bayshore DrOrlandoFL32882··NULLSELECT-EPO
CLMCLM-4230452026-01-05T20:55:08ZAmy—·Andrews1944-02-27UHC-03390-19•••-••-1802543.688.2075—3903 Bayshore Drive··Jacksonvillefl32265null·SELECT-EPO
CLMCLM-4241092026-04-24T22:37:09ZOmar····Ferguson11/04/50·-····7145674UNKNOWN7551 Harbor BlvdLos AngelesCA90022GRP-3486MEDICARE-ADV-B
CLMCLM-4213652026-03-18T06:25:49ZSantiago, Lori——02/12/1993UHC-83318-54•••-••-13584878488971-3583 Hillcrest RdTempeAZ85206N/ASELECT-EPO
CLMCLM-4318882026-08-16T19:56:16ZDiiego—Evans1964-06-28N/A•••-••-06904486606449NULL5946 Mountain View DrEden PrairieMinnesota55392-0605GRP-4590OPTIONS-PPO
32,829 rows, page 80 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:37.747Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty