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-4080092026-06-08T23:31:39ZCOLEMAN—JOE07/16/1952—null(213) 613-2067—--UNKNOWN—GRP-8337null
CLMCLM-4059132026-03-21T18:26:49ZREBECCA—ROBINSON09/09/1980UHC-71751-18•••-••-1503(242) 241-8592null3146 Lincoln WayORLANDOFL32873····NAVIGATE-HMO
CLMCLM-4281152026-03-29T01:45:03ZPriya—Lopez1947-04-09UHC-53383-79—nullNULL6000 Harbor BoulevardChandlerAZ85296N/A·MEDICARE-ADV-B
CLMCLM-4295792026-03-26T19:12:24Zjacob—peters1997-09-09UHC-44382-28•••-••-5658N/Ajacob.peters33@hotmail.com7610 Highland AvenueDenverCOUNKNOWNNULL—
CLMCLM-4276192026-01-02T18:04:04Zsaarah—flores11-11-1965————5323 Elm StreetEden PrairieMN55326NULLOPTIONS-PPO
CLMCLM-4085402026-02-27T19:18:39ZSANTIAGOJFOWLER1946-12-10··UHC-38032-37—297-530-7721·-566 BROADWAY Apt 8·LAS VEGASNV89197GRP-1590MEDICARE-ADV-A
CLMCLM-4134042026-03-05T14:38:38ZLori—Singh6/4/1973··UHC-68004-93•••-••-2928-—2288 Canyon RoadDenverCO··80250GRP-5195N/A
CLMCLM-4089532026-03-13T23:06:22ZPorter, Heather——2004-08-24UHC-28711-83•••-••-0584(487) 973-6505-4648 Baseline RoadCharlotteNC28227GRP-6039N/A
CLMCLM-4210252026-04-14T11:45:22ZJaniceB··Wheeler09/12/1997UHC-26426-40N/A—NULL3263 Central Ave Apt 34·GlendaleAZ85363··GRP-2448OPTIONS-PPO
CLMCLM-4032642026-01-17T05:44:01Zlgan—estrada1945-06-01—•••-••-4224(641) 429-3383——null-NULL—MEDICARE-ADV-A
CLMCLM-4325482026-06-05T07:03:12ZRussellK.Jacobs10-02-1986UHC-03633-88·NULL746-954-2726-3278 Spring StDenverCO80225GRP-9693MEDICARE-ADV-B
CLM CLM-4267542026-02-15T02:22:25ZWALTER—BENNTT1995-10-25·UHC-35632-44N/A15532117517-9390 Spring StreetSan DiegoCA92121GRP-6608core-hmo··
CLMCLM-4183452026-02-10T11:38:15ZCAROL—KELLY1939-10-17UHC-09522-48null·+1 301 834 6050CAROL.KELLY63@ICLOUD.COMNULL--nullGRP-1837CORE-HMO
CLMCLM-4272072026-02-03T06:53:57ZArjun—Griffin··1987-07-03UHC-38394-80NULL304-779-5080—2357 Sunset BoulevardSan DiegoCA92108··GRP-5544··—
CLMCLM-4045602026-03-21T15:54:41ZDavid—·Daniels25-05-2001UHC-45682-55NULL—david.daniels@proton.me9352 MAPLE AVEHoustonTX77043-9070—CHOICE-PLUS-PPO
CLMCLM-4192072026-08-30T18:55:19ZAdam—·Roberts2/27/1976UHC-76557-89-8700372ADAM.ROBERTS@OUTLOOK.COM5241 Lincoln Way·MinneapolisMN55413GRP-2039OPTIONS-PPO
CLMCLM-4199672026-01-22T11:47:50ZDonald—Collins··1989-08-04UHC-39777-23—(932) 276-9898-1234 Pine DrivePlanoTX75040UNKNOWN··—
CLMCLM-4312322026-10-16T16:14:09ZJoan—Rivera1989-12-18UHC-22799-76UNKNOWN—UNKNOWN7244 OAK STREETMiami··FL33179-6183GRP-4230NAVIGATE-HMO
CLMCLM-405842 2026-01-29T20:02:44Z·FRANCES—MOORE2006-04-19UHC-19353-75null—UNKNOWN5127 Baseline Rd #877SacramentoCA95828GRP-3686N/A
CLMCLM-4072342026-09-09T10:27:56ZSEAN—BOWMAN1957-05-18uhc-27509-22—··UNKNOWN4985 CANYON ROADAustinTexas·78724NULLSELECT-EPO
CLMCLM-4253992026-01-22T17:53:52ZIsabella—Lee1954-08-09N/A———4462 MARKET ST·AtlantaGA30368GRP-6660····
CLMCLM-4128492026-07-28T03:50:03ZKathleen—Butler1997-07-03UHC-38547-86•••-••-7814574.341.3084—7271 Jefferson AvenueJacksonvilleFL32263GRP-2014core-hmo
CLMCLM-4196802026-10-11T20:27:52ZEric—Lewis1979-09-26UHC-91782-76NULL—UNKNOWN1644 CEDAR LANEOrlandofl32864NULLSELECT-EPO
CLMCLM-4136232026-06-04T07:07:09ZERIC—SULLIVAN·9/8/1963N/A····(449) 500-5274null—-—NULL—-
CLM CLM-4134222026-06-11T11:44:41ZABIGAIL—WALKER1944-08-21UHC-24452-04-868-331-7783··NULLNULL—null·--·null
CLMCLM-4023742026-04-03T15:25:42ZRalph—Armstrong1591-09-05UHC-84017-34—NULL··—7925 BroadwayTAMPAFL33612GRP-1809NAVIGATE-HMO
CLMCLM-4074992026-08-28T04:06:16ZPeter—Fowler1972-04-02NULL··N/A-null-N/ANULL—GRP-4213CHOICE-PLUS-PPO
CLMCLM-410297 2026-07-09T23:51:58Zwillie—mejia1908-13-98UHC-65942-13—230-293-8681-NULLUNKNOWNN/AnullGRP-7281··CORE-HMO
CLM CLM-4306102026-07-09T01:47:50ZRobertson, Ann——Aug 11, 1968UHC-98509-15•••-••-9334-—2551 Willow CtSeattleWA98154·-CORE-HMO
CLMCLM-4046342026-01-26T07:48:06ZDay, Deborah——1955-06-07UHC-19228-66UNKNOWN····NULL4202 Washington StreetTUCSONAZ85718-4430—SELECT-EPO
CLMCLM-4041712026-01-06T07:28:10ZHannah—Olson1995-07-24UHC-75928-92N/A(735) 637-9285—6531 PALM DRMesaAZ85262—null
CLMCLM-4047172026-01-03T08:02:26ZJohnston, Sam——·1978-02-08null•••-••-80023232751298-1434 Palm DriveLAS VEGASNV89112GRP-7357NULL
CLMCLM-4278352026-02-26T20:47:53Z·Robertson, Roger——2002-05-06-•••-••-9942nullUNKNOWNUNKNOWN-NULLUNKNOWNGRP-8578MEDICARE-ADV-A
CLMCLM-4247272026-03-27T03:58:36ZJerry··JordanJun 11, 1996····9672415441null2771 SPRING STTempe··AZ85244GRP-8055MEDICARE-ADV-B
CLMCLM-4109232026-07-28T04:24:58ZNoah—Scott·1995-03-20UHC-90773-16—7635846302-8854 Mountain View DriveSan DiegoCA92129GRP-1508CORE-HMO
CLMCLM-4142262026-06-08T13:41:02ZPatrickR.Evans1977-02-01-•••-••-1630685-906-8697—1069 WILLOW COURTCharlotte·NC28285GRP-3794SELECT-EPO
CLMCLM-4069502026-03-11T06:33:44ZFatima·X·Holmes1970-05-01UHC-66550-61N/A16189837832—2343 Camelback RdFresnoCA··93758GRP-2152SELECT-EPO
CLMCLM-4249642026-02-02T07:51:34ZMary—Li14-12-1962UHC-75835-27•••-••-4351NULL—3250 CANYON ROADAustinTX78755GRP-4336CORE-HMO
CLMCLM-4089202026-02-27T00:42:56ZLane, Alexis——10/02/1966UHC-83946-95—13509547239—·····nullnull-GRP-5853NULL
CLMCLM-4144232026-03-18T04:48:14ZNicole—Banks1996-12-26UHC-03903-87———2517 MOUNTAIN VIEW DRIVE··MESAAZ85200GRP-5995null
CLMCLM-4054572026-05-10T22:41:55ZPhilip—Lawrecne1991-10-02nullnull——1594 River RoadChandlerAZ85200UNKNOWN····
CLMCLM-414046 2026-09-01T17:41:03ZRandy—Perkins1947-05-07UHC-09073-11•••-••-1641—·NULL1802 Mesa DrNashvilleTN37280N/AOPTIONS-PPO··
CLMCLM-403214 2026-07-09T18:54:19ZSandra—Butler1966-06-19UHC-50637-67•••-••-3214414.803.0789NULL3605 Desert Sky BlvdTucsonAZ85745GRP-3461null
CLMCLM-4175862026-07-17T17:49:00ZHannah—Luna1980-07-17UHC-65080-54•••-••-508719642409671N/A4685 Grand AvenueTampaFloridanullNULLMEDICARE-ADV-B
CLMCLM-4100332026-02-21T07:08:08ZBetty··—Ellis1999-10-26null•••-••-62046475147104UNKNOWN8398 Market StreetMinneapolisMN55437UNKNOWNNAVIGATE-HMO
CLMCLM-4309372026-06-12T03:56:07ZBillyCJacksonNov 23, 1949UHC-87710-73•••-••-73004895489420-5240 SUNSET BLVDDallasTX75252····MEDICARE-ADV-A
CLMCLM-4181322026-04-14T12:15:29ZMegan—Crawford1938-07-24N/A·N/A—N/A6340 UNION STSeattleWA98117GRP-9367MEDICARE-ADV-A
CLMCLM-4045702026-10-08T16:26:13ZPatterson, Diana—·····2002-09-09UHC-03595-51null··—-8120 MAPLE AVENUEScottsdaleAZ85215—null
CLMCLM-4150192026-06-20T04:59:08Z LAURA—STONE1995-02-17UHC-10518-92UNKNOWN861-409-8541UNKNOWN9078 Canyon RdTampaFL··33658·GRP-4536—
CLMCLM-4203152026-04-12T00:55:17ZLAWRENCE—WEBB4/2/1942UHC-93961-29•••-••-1356854.417.1833—-NULL—NULLnull—
32,829 rows, page 211 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:43.435Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty