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
PRVPRV-206262026-05-07T14:37:01ZBobby—Wilson1971-02-25NULL—4152432213N/A633 MEADOW LNMiamiFlorida33117-3715-CORE-HMO
TPATPA-622382026-03-21T08:34:32ZPETERYWEST1975-01-06UHC-81086-81N/AN/A—9360 ELM STLos Angelesca90076—NULL
CLM CLM-4023682026-04-18T02:23:15ZCharlesWSingh1958-07-24—•••-••-2458——1459 PINE DRIVEChandlerAZ85265GRP-4165-
ENRENR-1101232026-08-16T12:40:51ZNOAHMGUZMAN1963-12-02UHC-32384-07•••-••-6110+1 354 354 8161—·4878 OAK STLos AngelesCA90071GRP-4083CORE-HMO
CLM CLM-4230142026-07-27T00:25:54ZIsabella—Watson1977-02-03UHC-11528-25•••-••-0253——·6426 WASHINGTON STHoustonTX77066GRP-5235OPTIONS-PPO··
CLMCLM-4175072026-06-14T04:25:59ZHiroshi—Meyer1988-10-03UHC-79807-84•••-••-5340·-—3492 WILLOW CTAustinTX78723·N/A—
ENRENR-1206072026-05-04T22:51:22ZDEBORAH—HAMILTON1963-03-05UHC-46390-26—18349894965deborah.hamilton11@hotmail.com4385 Highland AveAustintx78721GRP-8570core-hmo
CLM CLM-4288522026-06-18T03:42:38ZDeborah—Richards06/14/1955-—(287) 827-7154—7280 Bayshore DriveAtlantaGA30396GRP-1563OPTIONS-PPO
CLMCLM-4223572026-04-21T19:29:58ZBruce—Bradley2002-03-26UNKNOWNUNKNOWN2014560359UNKNOWN·2156 Ocean AveSan DiegoCA92153GRP-1768medicare-adv-b
ENRENR-1338872026-01-13T04:20:54ZDiane··—Howard1966-04-12UHC-00743-76•••-••-8633-NULL7592 Cedar LnSan DiegoCA92166GRP-5497OPTIONS-PPO
ENRENR-1190782026-01-20T08:32:36Zraymond—harrison19810101UHC-40374-90•••-••-6772·15546340159null5028 ELM STREETDenverCO80298GRP-8251OPTIONS-PPO
TPATPA-527042026-09-05T22:38:49ZCatherine··ETaylor1965-12-12—N/A8284089875N/A7245 Hillcrest RdChandlerAZ85253GRP-5964navigate-hmo
CLMCLM-4322262026-03-13T20:53:20ZNicole—Coleman1951-12-17-N/A5675448071·N/A4557 Ridge RoadScottsdaleAZ85234-3059GRP-2417N/A
CLMCLM-4093002026-09-10T06:42:53ZRaymond—Campbell15-11-2002——7735217027-5500 Ocean AvenueGLENDALEAZ85328GRP-7707—
ENRENR-1330252026-09-21T19:18:17Z Greene, Arthur——19421116··UHC-13551-49•••-••-89424914654923arthur.greene@icloud.com·4951 Canyon Rd·Los AngelesCA90085GRP-9039CHOICE-PLUS-PPO
TPATPA-636142026-05-20T05:02:51ZRyan—Martinez·1951-06-25null-UNKNOWN—7459 MAIN STGilbertAZ—nullMEDICARE-ADV-B
ENRENR-1276342026-07-01T23:50:14Z·SHARONYBURTON1955-02-57UHC-21748-50•••-••-98376674613291sharon.burton@gmail.com5056 PINE DR #333Planotx··75054-6926GRP-1729CHOICE-PLUS-PPO
ENRENR-1349132026-08-22T03:45:26Z JessicaBLarson1977-03-28UHC-49110-84•••-••-9121745-665-1374—8086 MAIN ST··SacramentoCA95887GRP-6837OPTIONS-PPO
CLMCLM-4177212026-06-06T08:16:12ZJoeyVWheeler1991-05-12··•••-••-5995-UNKNOWN3173 WILLOW COURTSacramentoCA95892-2304··GRP-3811—
ENRENR-1382672026-04-29T03:19:25Zcarlos—webb1949-12-20UHC-82977-74•••-••-4832(878) 304-0123···CARLOS.WEBB@ICLOUD.COM7922 Canyon RoadTempeAZ85242GRP-3634SELECT-EPO··
CLMCLM-4023662026-06-26T20:50:17ZROGEER··CRAWFFORD01/21/66nullNULL·309.848.5055——-—nullGRP-0937null··
TPATPA-631772026-08-31T21:19:30ZLisa—Stevens··19860928——+1 647 637 8828··8250 Highland Ave Apt 24ChandlerAZ85205-N/A
ENRENR-1420202026-07-27T19:58:32ZFerguson, Bradley——19571213UHC-58249-92•••-••-60482046318258bradley.ferguson@aol.com329 River RoadHoustonTX77007GRP-5554NAVIGATE-HMO
CLMCLM-4030702026-04-28T08:18:44ZDIEGO—·WEST19620726UHC-45695-22··——3822 Baseline RdDALLASTX75235GRP-5435N/A
ENR ENR-1352922026-09-30T11:04:10ZAaronKVazquez2004-03-06UHC-28889-32•••-••-0670(689) 310-0538NULL1357 MAPLE AVECOLUMBUSOH43230·GRP-8387SELECT-EPO
TPATPA-524692026-03-24T13:59:12Z Gregory—Larson1963-11-18null··•••-••-9760(957) 377-8373null2970 SUNSET BLVDGilbertAZ85293——
CLMCLM-4123912026-06-28T18:53:28ZOmar····Reyes1965-10-23··UHC-05993-47•••-••-2216N/Aomar.reyes@hotmail.com··4469 HARBOR BOULEVARD Apt 33Charlotte·NC28275nullUNKNOWN
ENRENR-1094392026-02-20T13:11:24Znathan—flores··19590618UHC-24961-43··UNKNOWN379-343-5006nathan.flores1@gmail.com8353 Valley View DrLas VegasNV89101GRP-1744CHOICE-PLUS-PPO
PRVPRV-266042026-05-02T08:55:27ZPaul—Arnold2008-11-11-———4396 Jefferson AvenueMiamiFL33145—UNKNOWN
PRVPRV-240692026-06-22T23:34:48ZKelly, Theresa——19500102UHC2610349N/A(687) 656-0179theresa.kelly90@aol.com1014 Hillcrest RdSan DiegoCaliforniaUNKNOWN-MEDICARE-ADV-A
ENRENR-1325802026-06-09T01:10:31ZBradleyPMartinezJul 23, 1970UHC-09904-12•••-••-35349366148NULL6301 Park PlMinneapolisMN55404GRP-9813CORE-HMO
CLMCLM-4248322026-07-21T04:53:24Zjoe—weaver1989-10-27nullnull696-569-8934N/A7990 Jefferson Ave·San AntonioTexas78245GRP-0449··CHOICE-PLUS-PPO
CLMCLM-4075982026-05-14T00:08:02ZBeverly—Phillips1945-08-19—•••-••-51078465817626N/A996 RIVER ROADNashvilleTN37214GRP-0801NULL
ENRENR-1252872026-03-05T14:37:19Zvalentina—thomas1947-05-25UHC-79702-25•••-••-1617324-697-9666valentina.thomas@gmail.com5538 Cedar LaneGilbertAZ85210-5176GRP-7830core-hmo
CLMCLM-4106742026-06-08T15:07:48ZAmanda—Hunt0822-19-46UHC-44646-26—N/AN/A88 BroadwayJACKSONVILLEFLNULLGRP-2855-
ENRENR-1059042026-04-06T18:15:58ZALAN—STOO1994-10-12UHC-84799-55•••-••-25417157709265ALAN.SOTO@HOTMAIL.COM887 River RoadGlendaleAZ··85348GRP-6080SELECT-EPO
CLMCLM-4300362026-01-06T04:41:29ZCarolyn—Moreno05-02-1969UHC-38849-30—433.750.9208NULL9513 Desert Sky BlvdOrlandoFLUNKNOWN-··NAVIGATE-HMO
TPATPA-605952026-01-09T00:13:32ZCARLUBENNETT1968-11-07—UNKNOWNUNKNOWNnull··9430 SAGE CTSan AntonioTX78267UNKNOWN—
CLMCLM-4079142026-05-04T15:51:19ZARTHUR—RYAN19891028UHC-78348-45—····NULL2752 RIVER RDTampaFL33651··—-
TPATPA-640232026-08-08T04:32:00ZColeman, Marcus——1994-10-28N/A—3907759461··—304 Pine DrPlanoTX75045-—
CLMCLM-4040862026-09-06T05:41:31ZJonathan—Reed24-09-1952··UHC-35512-91•••-••-4503946.738.4338NULL6034 JEFFERSON AVETucsonAZ··85714GRP-8975CHOICE-PLUS-PPO
CLMCLM-4318502026-09-18T00:49:36ZJulieJEvans1978-10-16··UHC5113508null320-488-0468NULL-NULL——GRP-7869—
CLMCLM-4264412026-08-08T07:11:20ZSantos, Ryan——02/27/43UHC-94423-25-N/Aryan.santos85@outlook.comUNKNOWNN/A···N/A—GRP-4233UNKNOWN
ENRENR-1099962026-05-25T04:17:41Z LauraIChen2005-07-06UHC-72517-68··•••-••-0085546-339-1224LAURA.CHEN95@YAHOO.COM9250 VALLEY VIEW DRHouston·Texas77068GRP-4209·SELECT-EPO
CLMCLM-4124752026-07-08T18:32:59Z·Cheryl—Pierce1939-01-25UHC-79286-56———null—--·GRP-0555SELECT-EPO
ENRENR-1035192026-10-11T21:35:30ZbenjaminTwebb2003-01-07UHC-05050-82•••-••-6520828-686-0774benjamin.webb@outlook.com6081 CAMELBACK ROADJACKSONVILLEFL32277·GRP-7344OPTIONS-PPO
CLMCLM-4148022026-03-31T05:38:15ZJOHNNY—LYNCH12/18/1985··——(461) 960-6705—4927 Ocean AveCharlotteNorth Carolina28289-OPTIONS-PPO
CLMCLM-4299282026-10-11T13:42:08ZFATIMATKNIGHT09/13/1963UHC-92327-02—(469) 634-5513FATIMA.KNIGHT@YAHOO.COM2657 Market StEDEN PRAIRIEMN55302GRP-7679MEDICARE-ADV-B
CLMCLM-4159692026-01-21T17:25:07ZPatrick—Gardner·20000812UHC-61113-46•••-••-3554-N/A·UNKNOWN—UNKNOWN——SELECT-EPO
ENRENR-1331672026-03-20T05:25:50ZCampbellXJuan··19881221UHC-18810-99—(283) 841-5140JUAN.CAMPBELL@ICLOUD.COM7855 Main Street··HOUSTONTX77045GRP-5364·CHOICE-PLUS-PPO
100,000 rows, page 92 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.802Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty