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-4308162026-06-14T12:37:51ZMontgomery, Diego——19500608—UNKNOWN—UNKNOWN2865 Main StColumbusOhio43211nullMEDICARE-ADV-A
CLMCLM-4252542026-01-18T12:13:51Z ·SophiaLHunt1997-11-18·UNKNOWNNULL+1 895 826 7404NULL5141 Valley View DrivePhoenixAZ85027GRP-6401UNKNOWN
CLMCLM-4223472026-10-18T00:01:10ZAARON—VAZQUEZ1969-01-16UHC-12265-62•••-••-9260391-678-0884UNKNOWNN/A-N/A--N/A
CLMCLM-4053762026-03-09T08:12:25ZValdez, Jeffrey·B———N/A-null8667 Baseline RoadNashvilleTennessee37240GRP-3588MEDICARE-ADV-A
CLMCLM-4281342026-08-25T11:52:45ZJudith—EspinozaJun 10, 1987-····-··UNKNOWN403 Spring StreetMesaAZ—nullnull
CLMCLM-4055362026-04-02T06:39:26ZCamila—Meyer1971-08-08UHC-63608-27•••-••-9353(452) 930-4374—3788 Main StreetGlendaleAZ85310GRP-3420CHOICE-PLUS-PPO
CLMCLM-4277022026-09-30T11:23:43ZJacqueline—Mitchell1948-06-10UHC-85622-08NULL—N/AN/A··UNKNOWN—nullGRP-0807—
CLMCLM-4287552026-05-28T09:17:12ZgabrielW.sanders2006-05-23UHC-13138-62•••-••-1019964.593.9670N/A1842 BROADWAY··JacksonvilleFL32249GRP-6557—
CLMCLM-4131252026-08-25T21:40:49ZFrankA.Howard1971-07-01·UHC-33748-51•••-••-4981-NULLUNKNOWN———GRP-3469—
CLMCLM-4073072026-10-04T04:00:03ZRachel—Watson09/23/42null—UNKNOWNNULL1928 Camelback RdSan DiegoCA·92132·GRP-6871N/A
CLMCLM-4180902026-07-10T15:41:41ZBRIANMMCCOY19580715UHC-72352-98NULL(220) 492-3173NULL··8242 Union StreetTempeAZ85238GRP-2334OPTIONS-PPO
CLMCLM-4201902026-09-20T21:36:55ZMaria—·Gonzales····UHC-94421-13•••-••-0947--1366 LINCOLN WAYAtlantaGA30321—navigate-hmo
CLMCLM-4182202026-08-08T05:35:29Zstephen—brown1992-11-14—N/A·-—2974 Baseline Road·AustinTexas··78743-1975GRP-0445N/A
CLMCLM-4267782026-01-21T15:44:12ZEllis—Roy2006-02-21UNKNOWN•••-••-4562213-560-6666UNKNOWN2423 Central AveMesa··AZ85234GRP-3074OPTIONS-PPO
CLMCLM-4176292026-07-25T02:34:44ZCarolyn—Campbell02/15/50UHC-91732-23•••-••-5987·8255973022-7292 BroadwayDenver··CO80244GRP-9263N/A
CLMCLM-4092992026-05-18T09:51:10ZRaymondI.Campbell11/15/02UHC-88385-96—7735217027N/A5500 Ocean AveGlendaleAZ85328GRP-7707NULL
CLMCLM-4120632026-02-03T23:23:51ZBradley—Armstrong1938-01-22null•••-••-6267NULL····9526 Park PlaceMinneapolisMinnesota55429GRP-2430—
CLMCLM-4265202026-04-02T03:05:15Z·KELLY··ROBINSONJul 19, 1981—•••-••-6136-NULL—UNKNOWN—nullN/ACORE-HMO
CLMCLM-4135112026-09-21T13:11:03Z·William—Fowler1940-80-11UHC-89221-28··•••-••-7045··-9182 Bayshore DrSan DiegoCA92186UNKNOWNCHOICE-PLUS-PPO
CLMCLM-4324962026-10-01T22:13:57ZCHERYL—GIBSON·1999-05-15UHC-20991-85NULL2944819018··6044 WILLOW CTLos AngelesCA90080—NAVIGATE-HMO
CLMCLM-4083392026-08-21T09:30:53Zbrandon—johnston1993-03-05UHC-18239-79•••-••-75718106611108——UNKNOWNN/AUNKNOWN——
CLMCLM-4182522026-08-07T12:59:35ZSharonK.Mendoaz1971-11-23UHC-45600-90UNKNOWN(739) 427-5559NULL8627 WILLOW COURT #322·JacksonvilleFL32294UNKNOWN—
CLMCLM-4001942026-03-10T11:42:26ZKALYA—MORGAN1972-12-05UHC-94672-93•••-••-8512——UNKNOWN·NULL·nullN/AGRP-5656SELECT-EPO
CLMCLM-4028362026-05-26T19:20:24ZIsabella—Robertson1986-03-18UHC-58329-99·N/A(340) 388-1795—3669 Bayshore DrSan Antoniotx78252—UNKNOWN
CLMCLM-4117222026-09-08T10:04:05Z WILLIAM—BROOKS——•••-••-01999387325918NULL2965 OAK STSan DiegoCalifornia92101GRP-4288NAVIGATE-HMO
CLMCLM-4216312026-07-06T13:22:36ZEMILY··WAGNER14900105UHC-20500-13•••-••-7348(841) 740-0837emily.wagner@gmail.com·956 Pine DrGlendaleAZ85307GRP-2456MEDICARE-ADV-B
CLMCLM-4040522026-08-13T14:21:21Z DANIEL—PALMER03/08/60·UHC-52734-93•••-••-3817—DANIEL.PALMER@GMAIL.COM—-N/AnullNULLNULL
CLMCLM-4062672026-03-15T12:14:04ZJUSTIN—MOORE1990-03-22NULL—(332) 301-0485NULL··9820 Ocean AveEden PrairieMN55379GRP-2559CORE-HMO
CLMCLM-4104792026-03-03T08:24:43ZMarilyn··—Hill1991-04-80UHC-35136-12—NULL—nullnullN/A—GRP-6054—
CLMCLM-4223942026-07-25T18:47:02ZJOSHUA····PAYNE03-09-1938··UHC-40350-50•••-••-7565··N/Anull-····—GRP-4907-
CLMCLM-4110752026-01-17T05:57:41ZTERESA—ARMSTONG19410206UHC-45294-16N/A-null769 Lincoln WayLos AngelesCA90017GRP-5014·-
CLMCLM-420605 2026-09-09T17:11:56ZBillyI.Wong1989-02-21UHC8124057NULL(736) 658-5740null5293 RIDGE RDPlanoTX75096-—
CLMCLM-4064502026-01-26T03:48:39Z·sophia····marquezSep 1, 1986—NULL·UNKNOWN-6786 Meadow Lane··FresnoCA93755GRP-4869NAVIGATE-HMO
CLMCLM-411344 2026-07-22T08:41:26ZEMILY—WARREN2003-05-23UHC-25540-23—8107369388N/A5528 PINE DRIVECharlotteNC28236·NULLNAVIGATE-HMO
CLMCLM-4023712026-06-10T02:38:03ZRay, Debra——11/28/1981NULL——UNKNOWN·2737 Meadow LaneMiamiFL33123—····
CLM CLM-4008972026-03-03T11:07:59ZOlivia—Wells1950-06-10UNKNOWNNULL(789) 703-4604OLIVIA.WELLS72@ICLOUD.COMN/AnullNULLUNKNOWNGRP-9165null
CLMCLM-4239042026-05-23T07:00:46Z Camila—Bennett8/15/1992—NULL266.989.5476UNKNOWN5969 ELM STREETATLANTAGA30337NULLMEDICARE-ADV-B
CLMCLM-4205702026-06-26T12:33:59ZLINDA—MCDONALD4/9/1980UHC-70228-56N/A(655) 655-0558N/A6056 Highland AveATLANTA··ga30385··——
CLMCLM-4294082026-07-02T00:24:31ZEMMA—REYNOLDS1960-11-23·UHC-11149-20UNKNOWNnullnull—NULLnull—····UNKNOWN
CLMCLM-4099652026-02-21T04:48:14ZhenryTespinoza··1959-07-26—··3546701432null1745 Church StAustinTX78795GRP-5548null
CLMCLM-4158482026-02-14T00:48:35ZMarshall, Camila——1956-12-09—•••-••-0190334.702.0523nullUNKNOWN—··UNKNOWNGRP-2221-
CLMCLM-4031692026-08-26T22:01:14ZANN—GILBERTOct 7, 2004UHC-20636-06•••-••-44827011970null2196 SAGE CTChandler··az—-NAVIGATE-HMO
CLMCLM-4056082026-03-22T12:06:28ZdiegoQ.riley1995-07-22UHC0575875null209-679-2870NULL1017 Harbor BoulevardMiamiFL33136——
CLMCLM-4157932026-09-02T12:00:20ZMichelle—Schultz··1971-05-14UHC-74086-57——UNKNOWN4881 Lincoln Way·ScottsdaleAZ85245GRP-5103—
CLMCLM-4187822026-07-30T09:34:21Zwei—ramos25-12-1994UHC-46923-40•••-••-64784415881085—5493 ELM STGilbert·Arizona85205-8550GRP-7428NAVIGATE-HMO
CLM CLM-407932 2026-07-20T22:45:04ZANA—ROGERS·11/20/1973UHC-91684-98····nullUNKNOWN2242 Pine DrMesaAZ85231—CHOICE-PLUS-PPO
CLMCLM-428849 2026-07-08T08:47:15ZDanielle—Diaz1947-03-24UHC-42957-15——NULL2992 Jefferson AvenueMIAMIFL33121UNKNOWNN/A
CLMCLM-4028382026-08-31T15:14:14ZGerald—·Li1954-12-24UHC-76640-91•••-••-3855(791) 321-3625-2913 APACHE BOULEVARDGilbertAZ85201GRP-8190—
CLMCLM-4063502026-07-31T08:22:40ZJoe—Bishop20060916UHC-31239-05•••-••-2502211.534.2399null4760 Canyon RoadPhoenix··AZ—GRP-6032NAVIGATE-HMO
CLMCLM-4106242026-09-08T16:58:15Z KEITHVCAMPBELL19620519UHC-28637-30—-NULL5441 Meadow LnNashvilleTN·37234N/A···NULL
32,829 rows, page 147 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.332Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty