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-4050852026-06-04T21:19:10ZJudith—Lopez2002-05-16—•••-••-0967——9047 BroadwayGlendaleAZ85316GRP-1165N/A
CLMCLM-4073002026-02-15T09:56:15ZRachel S—Crawford04-05-1987null··UNKNOWN820-933-2221UNKNOWNNULL—-—GRP-3349CORE-HMO
CLMCLM-4161412026-09-30T01:46:51Zkaren—cook1983-02-04UHC6168099-604-695-8693UNKNOWN-UNKNOWN·null—nullUNKNOWN
CLMCLM-4183352026-09-28T15:22:27ZRamos, Camila——1952-05-01·UHC-23396-60—315-681-5432N/A8909 Market StCharlotteNCnull··GRP-1035null
CLMCLM-4220812026-04-24T23:54:28ZKeith—Hudson1997-11-14UHC-69245-17—722.472.9488UNKNOWNnull—NULLUNKNOWNnull-
CLMCLM-4242372026-02-10T19:34:38ZBecky—Myers-—•••-••-4718NULLNULL2515 PALM DRTucsonAZ····nullnull··
CLMCLM-4094692026-05-21T00:37:57ZLauraSDunn19760222·UHC-44881-02•••-••-6800+1 616 655 7095N/A8838 Park Place #812Mesa·AZN/A·GRP-9161MEDICARE-ADV-A
CLMCLM-4214592026-05-28T08:15:48ZSamantha—Ray··1990-09-03UHC-10409-87•••-••-5484UNKNOWN—UNKNOWNN/ANULL····——
CLMCLM-4328122026-03-14T01:15:19ZValentinaHJacobs1974-08-06-UNKNOWNUNKNOWN—null———N/AUNKNOWN
CLMCLM-4133882026-02-23T06:09:08ZKAYLA—RICHARDS··1963-04-10—•••-••-1030——-····-N/AnullSELECT-EPO
CLMCLM-4030022026-01-12T03:04:11ZBarnes, GaryB—21-08-1955UHC-36095-57•••-••-3724+1 605 761 2471NULL4992 Ridge RoadMESAAZ85265UNKNOWNSELECT-EPO
CLMCLM-4166602026-07-14T01:06:05ZIsabella—Wallace1940-01-09UHC-21839-17NULL··—·N/A8907 BroadwayNashvilleTN37232nullCHOICE-PLUS-PPO··
CLMCLM-4235082026-05-22T16:53:42ZTAYLOR··TYLER10/27/1957UHC-30471-03--—4037 INDIAN SCHOOL RDLAS VEGASNV89163GRP-8914NULL
CLMCLM-4214512026-01-13T14:29:25ZArjun····Williams1947-70-11UHC-60834-44null940-444-5698-8526 Bayshore DrMiamiFL33173GRP-4093-
CLMCLM-4046542026-03-11T03:28:55ZFowler, Jesse——1998-12-11UHC-13704-87•••-••-1591(513) 460-5829N/A4715 Sage CtMiamiFL33199—CORE-HMO
CLMCLM-4066992026-10-02T23:03:32ZDonald—CastilloJul 26, 1942UHC-10489-73NULL(518) 342-4288NULL2970 MARKET STPHOENIXAZ85095GRP-4492CORE-HMO
CLMCLM-4141932026-07-25T19:33:14Z·HENRYFHOLMES05/23/99—····631-791-6123null2925 CAMELBACK ROADMesaAZ85226—-
CLMCLM-4166452026-05-01T11:49:35ZMARCUS····JOHNSTON1957-01-12UHC-13149-50•••-••-2632(423) 430-5655—7914 MEADOW LN··Las VegasNV89167GRP-8869NAVIGATE-HMO
CLMCLM-4039832026-06-04T15:47:54ZSandra—Price1965-04-25——269-710-4186-··1307 LINCOLN WAYAtlantaGA30338-N/A
CLMCLM-4101122026-02-25T00:01:35ZJOSE—WATKINS1970-10-12—NULL416-774-3291null4524 Apache BlvdGlendaleAZ85369-9974GRP-6125—
CLMCLM-427283 2026-09-20T19:21:18Zmdaison—adams1977-04-24UHC-85490-31•••-••-4673(613) 613-2644madison.adams@proton.me7892 Maple AveMesaAZ85280-9114GRP-6598—
CLM CLM-4310452026-04-16T15:15:05ZChristine—Sullivan09/24/07———NULL4856 INDIAN SCHOOL ROADEden Prairiemn55332··GRP-4686MEDICARE-ADV-A
CLMCLM-4231842026-05-19T16:36:03ZDelgado, Megan——1964-02-15UHC-77498-46•••-••-8533UNKNOWN—8796 BAYSHORE DRSan DiegoCA92159—SELECT-EPO
CLMCLM-4004302026-03-02T13:00:55ZBRADLEY—CARROLL2004-12-02NULLUNKNOWN(694) 762-0897NULL1790 Highland Avenue Apt 26Columbusoh43233UNKNOWNMEDICARE-ADV-A
CLMCLM-4276442026-07-06T18:49:52ZLuis—Wang1957-08-16—····null-2970 Jefferson AvePhoenixAZ85014-5232GRP-5136NAVIGATE-HMO
CLMCLM-4055552026-06-27T20:04:44Z Heather····Austin11-10-1990UHC-98318-39•••-••-4853UNKNOWN—6047 LINCOLN WAYAUSTINTX78774·GRP-3524MEDICARE-ADV-B
CLMCLM-4207662026-09-08T00:17:46ZFrances—Stevens1958-06-16··UHC-72258-94—N/A—6045 Washington StChandlerAZ85201—null
CLMCLM-4054752026-03-28T10:35:02ZAlbert—Olson1947-11-08UHC-39661-50•••-••-7578(817) 879-4171NULLnull—UNKNOWN—GRP-6202—
CLMCLM-4014962026-01-12T00:27:31ZALANA.··MAATTHEWS20000724UHC-27608-39·NULL(484) 413-2956-148 Pine DrTucsonArizonanullGRP-9632-
CLMCLM-4270852026-10-14T19:56:57ZKimberly—Hernandez1945-12-13UHC-62431-46NULLN/A-·4884 PINE DRPhoenixAZ85023-medicare-adv-a
CLMCLM-4048422026-09-06T08:53:48Zyuki—·nguyen01/22/1955NULL-868-630-6366—N/ANULL·NULL—null—
CLMCLM-4253462026-01-29T11:27:27Z Campbell, Juan——1988-12-21——N/Anull7855 Main StHoustonTX77045GRP-5364N/A
CLMCLM-4093562026-05-13T07:30:14ZCsatro, Carol——07/18/1957UHC-89014-71UNKNOWNUNKNOWN··N/AnullN/A-—GRP-6943··MEDICARE-ADV-B
CLMCLM-4118262026-06-09T13:15:58ZSEAN—CAMPBELL27-07-1961UHC-42877-94•••-••-9426N/A-8834 MOUNTAIN VIEW DR·TampaFL33614GRP-6044NULL
CLMCLM-4075442026-02-08T04:34:15ZEVELYNOWOODS1980-12-02UHC-04940-63—819-538-9686EVELYN.WOODS@ICLOUD.COM7917 Central Avenue #702TampaFL33653GRP-0376CORE-HMO
CLMCLM-4105382026-08-12T09:52:01ZAdam—Bailey20000810——(680) 404-2855-6587 Jefferson AveScottsdaleAZ85222GRP-1378CORE-HMO
CLMCLM-4265042026-04-26T11:41:45ZJordan····Walker1988-02-19UHC-96381-04·N/A252-450-9237-3465 UNION STREETColumbus·OH43291GRP-8224CHOICE-PLUS-PPO
CLMCLM-4038572026-07-30T19:33:34ZMei··RogersFeb 16, 1954null———4173 Pine DrSan Antonio··TX··-GRP-8623—
CLMCLM-4012082026-09-15T20:19:24ZANA—KNIGTH03/25/91—•••-••-8018····—3627 Lincoln Way #531GilbertAZ85236GRP-5962·MEDICARE-ADV-A
CLMCLM-4282612026-08-22T00:06:19ZBryan··Parry1991-09-11—•••-••-7813883-611-7091-3050 OCEAN AVENUEAustinTX78733GRP-9886—
CLMCLM-4162282026-02-12T02:37:10ZMendez, FatimaT··—07/18/45·UHC-89648-48-986-850-5073—4395 Union StOrlandoFL32809GRP-5492MEDICARE-ADV-B
CLMCLM-4055882026-08-02T18:09:23ZOMAR—RCHARDSON19410613—null·772-540-3106omar.richardson42@aol.com8804 Baseline RdChandlerAZ85250GRP-3982—
CLMCLM-4257592026-02-09T19:53:39Z Douglas—Stewart20060614UHC1883070•••-••-3034NULLN/A·7629 CHURCH STREETGlendaleAZ85353GRP-7371N/A
CLMCLM-4064262026-03-23T16:35:30ZELIJAH—LAWRENCE1960-10-13N/A——UNKNOWN—NULLN/AnullGRP-9378-
CLM CLM-4142742026-06-30T09:52:06ZJeremy—Ortega2002-08-07··UHC-18231-87UNKNOWNNULL—4675 INDIAN SCHOOL ROAD··CharlotteNC28278GRP-2477SELECT-EPO
CLMCLM-4133472026-08-13T19:21:07ZDennis—Boyd··1990-02-09UHC-62213-03•••-••-0328—····N/A—UNKNOWNnullGRP-3209—
CLMCLM-4294542026-09-18T11:59:25ZJOSE····YANG1996-12-24··UHC-79343-17•••-••-6510—·null6764 Ridge Road Apt 25Tampa·FL33657GRP-5425··null
CLMCLM-4155162026-04-05T12:18:52ZJeanJ.Robertson1961-11-09··UHC-13490-71•••-••-82296967203498null7484 Camelback RoadCOLUMBUSOH43234GRP-9241CORE-HMO
CLMCLM-4084172026-06-26T18:17:47ZBurke, James——1947-01-12UHC-47425-07•••-••-2055null——NULLnull—GRP-4283NAVIGATE-HMO
CLMCLM-4055842026-10-16T17:37:37Z Jacqueline—Brooks1964-10-04UHC-71813-52-410-224-6758—6927 PARK PL Apt 39ColumbusOhio43278——
32,829 rows, page 183 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.622Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty