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
ENRENR-1287722026-01-12T03:56:24Z Jonathan—Gibson1978-02-08UHC-88509-08•••-••-9273UNKNOWN·jonathan.gibson45@outlook.com3380 LAKE VIEW ROADSeattleWA98175GRP-4927SELECT-EPO
PRVPRV-260402026-06-09T14:24:50Z donna—·greeneUNKNOWN··UHC-31782-23NULL856-860-9815donna.greene81@proton.me5500 HILLCREST RDSan DiegoCA92179—NULL
TPATPA-571692026-10-12T06:25:36ZJames—Myers·Apr 20, 1980UHC-80186-79nullN/Anull493 MARKET STMIAMIFL33185NULL-
CLMCLM-4012662026-10-07T15:38:38Z MARILYN—LONG1982-08-17null•••-••-7168469-651-5047-··4829 Oak Street·Atlantaga30357-N/A
ENRENR-1384632026-01-17T10:51:30Z CAROLYN····ORTEGA1998-06-15UHC-89704-73•••-••-4856(249) 582-6222—8513 Sage CtCharlotteNC-GRP-3677MEDICARE-ADV-B
ENRENR-1082042026-10-15T00:58:39ZMARTHAC·RODRIGUEZ1977-06-11··UHC-02773-73•••-••-4257+1 824 631 3228—5909 Elm StreetDENVERCO80232GRP-4456CHOICE-PLUS-PPO
CLMCLM-4312562026-08-25T14:22:00ZAndrew—Lopez2007-07-26-NULL5186699UNKNOWN6398 SPRING STREET Apt 26·ScottsdaleAZ85251GRP-1241MEDICARE-ADV-A··
TPATPA-529842026-03-15T14:27:33ZJULIE··PENA1988-12-02null•••-••-0880294-850-5111UNKNOWN59 MOUNTAIN VIEW DRTucson·AZ85739—MEDICARE-ADV-A
CLMCLM-412031 2026-01-09T13:06:08ZLopez, Keith——1954-12-07UHC8581938null4926077912null—UNKNOWN——·GRP-1382OPTIONS-PPO
ENRENR-1202612026-08-04T08:52:49ZGeradlBWilliamson··1969-04-02UHC-64851-72•••-••-19577924087144null5401 HARBOR BOULEVARDHOUSTONTX··77064GRP-8813SELECT-EPO
ENRENR-1130802026-04-13T18:05:33ZJudith—Bishop1958-09-24UHC-74677-31•••-••-0631(611) 861-7870judith.bishop@icloud.com4725 Willow CourtMinneapolisMN55458GRP-2987SELECT-EPO
PRVPRV-238952026-02-04T19:33:26ZCamila—Snyder19511111—-325-553-1780CAMILA.SNYDER@HOTMAIL.COM8443 VALLEY VIEW DRAustinTX78762NULL—
ENRENR-1068292026-01-28T08:33:53ZKimberlyNOliver04/05/08UHC-97879-20•••-••-750516694709487kimberly.oliver@aol.com·1498 Hillcrest RdSan AntonioTX78244GRP-1792NAVIGATE-HMO
PRVPRV-244942026-02-09T20:18:16ZAndrew—Larson1994-01-10UHC-19155-72null2022588null7764 HIGHLAND AVENUEAUSTINTX78710nullNULL
ENRENR-1062462026-02-03T05:45:58ZClark, Peter——08-06-1947UHC-99363-17•••-••-719616056117774PETER.CLARK46@PROTON.ME275 Cedar Lane #858DenverCO80294GRP-6727SELECT-EPO
ENRENR-1055632026-07-27T00:03:23Z carlYli9/6/1956UHC-41105-72··•••-••-6429+1 517 912 2797carl.li@icloud.com8507 Highland AvenueHoustontxNULLGRP-4984SELECT-EPO
ENRENR-1364592026-01-29T17:54:46ZomarFobrien1988-03-08UHC-69499-80•••-••-04912582826694omar.obrien12@gmail.com8999 Main StDallasTX··75298GRP-7576CHOICE-PLUS-PPO
CLMCLM-4133152026-09-15T17:09:23Zpaul—garza02/09/96UHC-07864-19•••-••-7516NULL—-N/A—N/A—CHOICE-PLUS-PPO
ENRENR-1000092026-08-15T06:09:50ZShirley—Hernandez1964-01-10UHC6016588•••-••-1341·460-773-8796shirley.hernandez93@hotmail.com——null····GRP-5397MEDICARE-ADV-A
ENRENR-1381522026-03-02T01:57:49ZWalter—GomezMay 22, 1946UHC-83989-37•••-••-44685906943061NULL··2117 CAMELBACK ROADChandlerArizona85299··GRP-6832··CHOICE-PLUS-PPO
CLMCLM-4160272026-08-27T14:50:43ZNguyen, Brenda··——19501010UHC-96686-39null——5028 Harbor BoulevardSan DiegoCalifornia92146··CORE-HMO
ENR ENR-1297052026-02-12T02:26:42ZSophiaHFosterAug 12, 1990UHC-38594-20•••-••-5473236-425-6732SOPHIA.FOSTER50@YAHOO.COM6771 Forest AvenueOrlandoFL32893GRP-0992MEDICARE-ADV-A
CLMCLM-4269182026-05-22T03:35:07ZCamilaERodriguez1945-09-18uhc-63430-90•••-••-66052476351402·null4784 Baseline RdPhoenixAZ85088·null·NULL
CLMCLM-4292722026-01-01T22:42:39ZDONNA—MOREENO3/17/1950UHC-42001-77•••-••-66952593735032donna.moreno38@icloud.com7910 Indian School RdGlendaleAZ85316—CHOICE-PLUS-PPO
ENRENR-1255492026-09-07T01:06:52ZKATHRYN—ROBINSON1940-03-02UHC-31863-09—644.880.5619N/A——-NULLGRP-2256NAVIGATE-HMO
CLMCLM-4036782026-10-13T20:56:06ZWilliamson, FrankP—13-10-1938··N/ANULL··5825 Forest Ave #233··Los AngelesCA90091GRP-9460OPTIONS-PPO
ENRENR-121631 2026-05-18T03:12:46ZLISA—LEWIS·1951-03-27UHC-05664-71•••-••-16983463681261null·2672 Park PlJacksonvilleFL32202GRP-8345options-ppo··
TPATPA-521052026-03-30T07:57:04Z James, Lauren——4/5/1965UNKNOWN—389.759.0217UNKNOWN9798 Main StTucsonAZ85732—····
ENRENR-1033742026-01-17T10:18:45ZNichols, Madison——19991021UHC-83753-93•••-••-3719267.353.2181—2676 Ridge Rd··JACKSONVILLEFL32288GRP-2748OPTIONS-PPO
CLMCLM-4144972026-01-24T06:26:53Zphilip—vazquez6/27/1996UHC-46410-96null—UNKNOWN5436 Union StreetCOLUMBUSOH43262NULL—
CLMCLM-4266482026-05-12T17:38:51ZOlivia··G··Berry2/17/1949N/A—--5276 BroadwaySEATTLEWA98120·-—
ENRENR-1079742026-07-22T10:59:15ZDebraVCollisn·1980-11-19UHC-86010-85•••-••-8841—·DEBRA.COLLINS@YAHOO.COM6116 Market StSACRAMENTOCA··95866GRP-9288NAVIGATE-HMO
TPATPA-554232026-03-18T11:27:52Zlisa—hawkins··Mar 27, 2004—•••-••-2812UNKNOWN-6779 BROADWAYCHARLOTTENC28250-6942GRP-3036N/A
ENRENR-1027102026-04-02T07:03:44ZBrian··GHamiltonAug 14, 1940UHC-68025-63•••-••-0433-NULL7947 River Road #235ScottsdaleAZ85227GRP-6616NAVIGATE-HMO
ENRENR-1308562026-08-13T03:36:40ZARTHUR—GARRETTFeb 17, 1991UHC-98433-73•••-••-7671(760) 455-5393NULL4997 Camelback Road··MiamiFlorida33122-2121GRP-1843NAVIGATE-HMO
ENRENR-1260942026-07-20T18:04:52Z ·JohnnyOStephens2002-01-16UHC-11327-76•••-••-85234467018786JOHN.STEPHENS@ICLOUD.COM2468 Pine Drive #206MiamiFL33102GRP-3369CHOICE-PLUS-PPO
ENRENR-1383692026-10-08T01:16:31Zyuki—harris10-05-1949UHC-35598-38•••-••-3306—YUKI.HARRIS@AOL.COM7770 Canyon Rd #727··Austin··TX78755GRP-9528CORE-HMO
ENRENR-1305482026-06-24T09:29:49ZPriyaNReed1957-04-23UHC-98300-62•••-••-6429(238) 877-7405NULL3163 LAKE VIEW RDSan AntonioTX78215GRP-5732MEDICARE-ADV-A
CLMCLM-404838 2026-07-30T16:18:03ZELIZABETH—SIMMONS1938-07-15NULLnull+1 699 270 4178—6495 Harbor BlvdHoustonTexas77097-7121GRP-3992··
ENRENR-1346702026-07-28T17:54:11ZChristopher—Burke9160-05-08UHC-49095-58•••-••-8823807-981-6504christopher.burke99@icloud.com9054 Cedar Lane··Denver·CO80243GRP-6170··NAVIGATE-HMO
ENR ENR-1192372026-03-11T19:55:00ZSandoval, SeanN—May 28, 1955UHC-11554-69UNKNOWN(651) 378-2669sean.sandoval@yahoo.com··4121 Hillcrest RdDallastx75205GRP-5778SELECT-EPO
TPATPA-614422026-08-04T20:26:26Zmaria—rojas1943-08-21UNKNOWN•••-••-46065245561709—-UNKNOWNN/A-··N/A·-
PRVPRV-262632026-06-02T22:18:27ZJosaph—Stephens5/21/1975UNKNOWN-13204081111——N/ANULLnull—UNKNOWN
PRVPRV-278392026-10-09T16:48:30ZTHERESA····RIOS07/20/08UHC-59751-66nullnull—3083 Sage CtHouston··TX77063—-
ENRENR-1017882026-04-30T09:19:32ZDouglas—Carlson01/28/39UHC-97519-33•••-••-5478——3127 Washington St Apt 34AustinTX78718GRP-7892MEDICARE-ADV-A
TPATPA-602862026-08-06T18:37:04ZPATRICK—HAWKINS2007-10-27UHC-18890-29•••-••-0746—N/A4154 Baseline RdCharlotteNorth Carolina28207-3023UNKNOWNNULL
CLMCLM-4184972026-06-09T21:18:35ZMcDonald, IsabellaP—1967-08-02UHC-60298-72·N/A481-626-2445isabella.mcdonald35@aol.com7667 Pine Drive Apt 20ColumbusOH··43247GRP-8995NULL
PRVPRV-242492026-06-02T11:08:47Z·Porter, Jordan——2001-04-17UNKNOWN---2631 HIGHLAND AVENUEAustinTX78707——
ENR ENR-1225832026-04-07T04:53:45ZPeter—Siva07/15/64UHC-85660-24•••-••-6992+1 851 612 0948PETER.SILVA90@OUTLOOK.COM5964 River RoadTAMPAFL33621GRP-1163SELECT-EPO
CLMCLM-4207742026-05-09T04:52:49ZCarol—Jacobs2004-10-14··UHC-65981-16nullnull--N/A—NULLGRP-6695NULL··
100,000 rows, page 233 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:37.738Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty