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

All sources, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
CLMCLM-4307132026-03-01T12:29:39ZBrittany—Banks1948-07-03UHC-86957-86•••-••-308019155051099null493 CAMELBACK ROADOrlandoFL32858N/A—
PRVPRV-268282026-07-30T12:40:22ZJon—Santiago1966-04-23UHC-29521-60N/A482-851-0911jonathan.santiago8@hotmail.com3230 Market StSan DiegoCA92185NULL—
CLMCLM-4276222026-07-27T20:52:06ZJoes—Bradley·2004-11-02—•••-••-4894nullUNKNOWN2268 Ocean AveMinneapolisMN—GRP-7052CORE-HMO
ENRENR-1228882026-04-11T12:25:35Z ·patriciaI.··austin08/10/74UHC-85341-11•••-••-3918697-509-4085UNKNOWN829 BROADWAYColumbusOH43210GRP-6680OPTIONS-PPO
ENRENR-1380422026-05-23T20:21:55ZJustin—Sms10/22/1938UHC-97386-84•••-••-5792·613-983-2805justin.sims@aol.com5124 Highland Ave Apt 36··FresnoCA93787GRP-7248CHOICE-PLUS-PPO
CLMCLM-4138232026-10-16T14:57:04ZMadison—Jenkins05-01-1983-UNKNOWN4434743157N/Anull—NULL··—·GRP-9272·MEDICARE-ADV-B
ENRENR-1326782026-03-25T13:47:10ZJULIEHLI9/20/1972·UHC-87775-74•••-••-7285674-569-5156JULIE.LI41@HOTMAIL.COM5776 Willow Ct··Los AngelesCA90003GRP-1591CORE-HMO
CLMCLM-4130532026-01-22T14:32:48ZDeborahO.Godron1941-05-26·UHC-25069-01•••-••-26823398306272·DEBORAH.GORDON91@PROTON.ME6829 RIDGE RDHoustonTexas77007GRP-0932CORE-HMO
CLMCLM-4179612026-06-18T21:09:52ZJean—Bell1964-07-22UHC-53803-37UNKNOWNnull-—NULL——··null
ENRENR-1305152026-08-08T20:15:33ZRachel—Schmidt1990-01-10UHC-48968-94•••-••-13654023757404RACHEL.SCHMIDT@ICLOUD.COM4772 Sage Court #163SAN ANTONIOtx78254GRP-1340CHOICE-PLUS-PPO
ENRENR-103337 2026-07-15T17:12:08ZSofiaBLiDec 18, 1948UHC-51465-50··•••-••-1440321-358-5049sofia.li@gmail.com1674 RIDGE ROAD··JacksonvilleFL·32294GRP-1949CORE-HMO
ENRENR-1281742026-04-23T01:04:50ZCHRISIJACKSON1958-04-13UHC-69793-47•••-••-8404323-382-5689christopher.jackson@yahoo.com4347 MEADOW LANEAustinTX78768GRP-5651CHOICE-PLUS-PPO
CLMCLM-4297142026-09-24T23:53:15ZGloria—Martin1989-09-15UHC-38570-43--—6216 Canyon RdMiamiFL33155GRP-6616MEDICARE-ADV-B
ENRENR-1340982026-04-11T14:33:19ZsarahE.carlson20-02-1943UHC-61080-99•••-••-039116876115975sarah.carlson2@yahoo.com·9655 RIVER ROADGilbertAZ85275-7370GRP-3290SELECT-EPO
PRVPRV-264622026-05-05T20:36:38ZRyan—Garrett2005-04-05NULLN/A449-781-2983—7441 Market StMinneapolisMN55455null-
CLMCLM-4250952026-08-14T15:21:53Z PaulGLuna·1974-05-11UHC-71549-96•••-••-73029529945118UNKNOWN——N/AUNKNOWNN/A—
ENRENR-1384882026-04-06T23:35:22Zdenise··knight13-01-1979UHC-67464-26—+1 212 836 6084DENISE.KNIGHT96@OUTLOOK.COM2302 Canyon RdPhoenixAZ85008GRP-7505CHOICE-PLUS-PPO
CLMCLM-4309282026-03-25T11:41:41Zjason—meyer·20021220UNKNOWNUNKNOWN3083924589—N/ANULL········null··N/A
ENRENR-1039662026-08-12T07:43:33ZClark, Dennis——08/01/59UHC-72319-78•••-••-19848089742295UNKNOWN1277 Indian School RoadFresnoCA93731GRP-1038MEDICARE-ADV-A
ENRENR-1314682026-05-08T02:12:23ZKathleenACrawford1964-12-08UHC-91893-76•••-••-5522(425) 682-5536kathleen.crawford@outlook.com6694 Maple AvenueChandlerAZ85283GRP-3853CHOICE-PLUS-PPO··
ENRENR-1286772026-07-30T17:41:04ZCAMILAV··WANG02/18/1964··UHC-11506-03•••-••-6314+1 566 926 0162camila.wang40@gmail.com1186 Elm StSacramentoCalifornia·95806GRP-1133··SELECT-EPO
PRVPRV-212772026-01-11T11:59:39ZPRIYA—DIXON1998-08-21N/A—13209531958N/A4608 Desert Sky BoulevardColumbusoh43261-N/A
CLM CLM-4167742026-06-26T13:39:11ZMelissa—Guzman1940-11-15—-16897151731NULL·998 BROADWAYMinneapolis··MN55459—MEDICARE-ADV-B
PRVPRV-227222026-09-13T09:33:40ZRAYMOND—CAMPBELL2002-11-15UHC-88385-96—+1 773 521 7027··—5500 OCEAN AVE··GlendaleAZ85328nullCHOICE-PLUS-PPO
ENRENR-1019992026-07-10T23:43:51ZBell, JeanE.····2006-05-09UHC-44976-64•••-••-7060939-933-9866N/A5048 PALM DRChandlerAZ85209GRP-1278medicare-adv-a
ENRENR-1135362026-09-30T19:13:48ZAndrewXMcDonald21-08-2000UHC-38489-91•••-••-0776(437) 434-2555andrew.mcdonald44@aol.com···4462 CAMELBACK RDOrlandoFL32836-6267GRP-6366MEDICARE-ADV-A
ENRENR-1383922026-04-21T21:52:34ZIsebellaBJordan27-09-1988UHC-55243-09N/A17465040423—4855 Spring StreetPhoenixAZ85093GRP-6027CHOICE-PLUS-PPO
CLMCLM-4002922026-10-04T09:56:46ZEmma—Hill1974-02-09··UHC-72136-54•••-••-218319835648155-5231 Central Ave·TempeAZ85242-4088GRP-4024MEDICARE-ADV-A
TPATPA-640192026-03-31T12:29:58ZHiroshi—·Day11/2/1998··———HIROSHI.DAY@AOL.COM9870 Apache Blvd·MesaAZ85278——
CLMCLM-4063532026-01-07T03:09:20ZJanice—·Hunt1974-12-06··UHC-70664-95•••-••-9721544-815-4823N/A3006 Pine DriveCHANDLERAZ85247null··SELECT-EPO
ENRENR-1351782026-02-25T07:48:02ZLori—Guzman··1/14/1957UHC-40801-21NULL(924) 971-6506lori.guzman26@yahoo.com8493 Washington StSan DiegoCA92122GRP-3934CHOICE-PLUS-PPO
ENRENR-1383502026-03-21T00:33:42ZMartha—Wood1989-02-23uhc-19861-21•••-••-0706(630) 762-6643martha.wood14@aol.com·9595 Bayshore DriveSeattleWA98166GRP-1306medicare-adv-a
CLMCLM-4245382026-01-05T03:53:58ZScott, MarkE—1987-01-02—N/A(743) 839-7420··4446 WASHINGTON STREET··TucsonAZ85792GRP-6868MEDICARE-ADV-A
CLMCLM-4180002026-09-14T03:54:58Z·Hiroshi—Little19730728UNKNOWN•••-••-24292134738946null1360 RIVER RDAtlantaGA··30305—NULL
CLM CLM-4058092026-08-28T01:59:14Z·NANCY—DELGADO06/14/53UHC-60245-45——·N/A452 Harbor BlvdNashvilleTN37208·-OPTIONS-PPO
ENRENR-1355852026-05-05T11:20:36ZBRANDON—SHAW2007-05-20UHC-41262-36•••-••-8175—-9042 Desert Sky BoulevardCharlotteNC28263GRP-1558CORE-HMO
ENRENR-1212292026-03-03T04:53:10ZRandy—Hunt19900404UHC-06808-42•••-••-7568940-665-3056UNKNOWN5547 Baseline RdHoustonTX77024GRP-6816NAVIGATE-HMO
PRVPRV-217062026-09-07T12:42:29ZPaul—Patel1940-45-19UHC-58061-85—264-913-8217PAUL.PATEL48@AOL.COM3976 Park PlaceTampaFlorida33646UNKNOWNUNKNOWN
ENRENR-1076112026-06-13T14:29:01ZSTEPHEN—LEWIS1958-03-04UHC-80754-67•••-••-9001-stephen.lewis26@yahoo.com7899 Church StreetMiamiFlorida33177GRP-5956MEDICARE-ADV-B
ENRENR-130788 2026-05-04T18:27:29ZAlexander—Montgomery0248-19-40UHC7896667··•••-••-26875316762901ALEXANDER.MONTGOMERY94@HOTMAIL.COM6536 Washington StCharlotteNC28230GRP-2802CHOICE-PLUS-PPO
CLMCLM-4039982026-05-26T12:14:34Z·AMBER—RICHARDS07/21/78UHC-43880-34UNKNOWNNULLNULLnullN/A—NULLGRP-2553N/A
ENRENR-1115902026-02-21T04:50:42ZJean··Q.·Burton2005-12-17UHC-63224-77•••-••-77569776738027jean.burton70@yahoo.com8348 BAYSHORE DRIVEOrlandofl32888GRP-4359CHOICE-PLUS-PPO
PRVPRV-256722026-04-30T19:54:21ZARTHUR—MORRISON1988-09-03UHC-75672-61··3417974398··—3735 MEADOW LANEMIAMIFL33105N/ANULL
ENRENR-1239232026-05-19T14:42:54ZEstrada, DeborahW—·10-03-1991UHC-65814-20•••-••-2501731.852.7594deborah.estrada@icloud.com5054 Park PlaceSan AntonioTX78210GRP-9158MEDICARE-ADV-B
ENRENR-1069042026-05-03T06:03:50Z·WillieIPierce1980-10-02UHC-53272-81N/A(241) 458-7667WILLIE.PIERCE8@HOTMAIL.COM7239 BroadwayNASHVILLETN37230GRP-8817MEDICARE-ADV-B
TPATPA-563842026-04-10T04:00:31Zdavid—simmons8/6/1959UNKNOWN•••-••-1300nulldavid.simmons90@aol.com1491 Lake View RoadFresnoCA-—-
CLMCLM-4098622026-07-26T05:33:40ZABIGAIL—VARGAS2005-06-26null-NULLabigail.vargas56@gmail.com3980 Willow CourtCharlotte·North Carolina28296·GRP-6919—
ENRENR-1011412026-02-06T03:02:47ZJoanI.—1949-03-16NULL-N/Ajoan.lane@outlook.com573 WILLOW COURTPlanoTX75001-8032GRP-1519CHOICE-PLUS-PPO
CLMCLM-4106852026-09-15T15:57:39ZTHOMAS—MYERS1988-01-26·UHC-75619-36•••-••-7674798-444-6750thomas.myers27@aol.com4476 Desert Sky BlvdATLANTAGA30353GRP-8160—
ENRENR-1144372026-03-05T09:23:37ZRALPHX·STEVENS·1970-01-07UHC-93694-52•••-••-4587+1 248 543 2346RALPH.STEVENS51@PROTON.ME5840 BASELINE ROADSan AntonioTX··78267··GRP-9217MEDICARE-ADV-A
100,000 rows, page 74 of 2,000PreviousNext

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:34.793Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty