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-128338 2026-06-04T13:15:29ZGloria—Bowman—UHC-41813-21-774-466-9248N/A9766 Grand Avenue Apt 37Los AngelesCANULLGRP-6629CHOICE-PLUS-PPO
ENRENR-1047902026-04-01T05:50:18ZAmberXTucker19730810UHC-54636-28•••-••-36157297232396amber.tucker@icloud.com5701 Lake View Road··MinneapolisMN55470GRP-2850OPTIONS-PPO
TPATPA-583012026-09-27T01:06:19Zethan—reid1958-02-10—null(742) 332-8602ETHAN.REID@YAHOO.COM123 Park PlaceLos AngelesCalifornia··90017GRP-9512-
TPATPA-632322026-04-27T08:48:05ZKatherineQStephens1973-12-22null•••-••-7619—NULL7018 Valley View DriveMesaAZUNKNOWNGRP-7315—
CLMCLM-4017832026-07-19T18:21:33ZAMY—RICE1991-06-04null•••-••-1350null·amy.rice11@yahoo.comN/A-·N/A-····choice-plus-ppo
ENRENR-1327182026-08-01T00:17:37ZJOSE—PERRY1978-04-04UHC-95995-28•••-••-83768776823698NULL9815 Union StPlano··TX75040GRP-9288·CHOICE-PLUS-PPO
ENRENR-1015082026-08-31T17:45:16ZKaran—Baker06/10/51·UHC-03116-01•••-••-0415478.419.3990karen.baker55@aol.com3263 HILLCREST ROADJacksonvilleFL32238GRP-2439·NAVIGATE-HMO
ENRENR-1405142026-09-26T16:00:22ZDeborah—Chapman1963-03-02UHC-33000-87•••-••-3204942-779-4730deborah.chapman41@icloud.com8478 Lincoln WayChandler··AZ85283GRP-0269CHOICE-PLUS-PPO··
TPATPA-537962026-06-24T11:25:26ZKetherine—Williamson8/27/1999nullNULLNULL—6785 Sunset BlvdTucsonArizonanull····—
ENRENR-1126062026-02-11T21:35:56ZJessica—Bennett02-05-1991UHC-98542-11•••-••-2361——5439 Camelback Rd··DenverColorado80206GRP-1083SELECT-EPO··
ENRENR-1080222026-07-19T18:08:09ZAndrewWHart15-05-1971UHC-05381-28—440-461-8873·ANDREW.HART52@YAHOO.COM8837 PINE DRIVECHANDLERAZ85238GRP-3048SELECT-EPO
TPATPA-616592026-05-27T13:05:59ZPAUL—ESTRADA1981-06-25-·N/AnullNULL-······-nullnull-
PRVPRV-229232026-04-01T13:30:28ZReyes, Melissa——6/10/1989UHC-62424-65•••-••-3004257-967-6112melissa.reyes11@gmail.com8766 Hillcrest RdLOS ANGELESCA90034N/AN/A
ENRENR-1045422026-01-18T17:14:26ZJOHNYCONTRERAS1980-02-28UHC-95942-06··•••-••-0293391.654.5189JOHN.CONTRERAS82@GMAIL.COM·2831 BASELINE RDMiamiFL33140GRP-7833CHOICE-PLUS-PPO
ENRENR-1214302026-09-18T01:20:34ZJORDANOGEORGE1964-11-12UHC-02604-57•••-••-98809548084442jordan.george61@icloud.com384 Union StreetDenverCO80230-6375·GRP-5073·MEDICARE-ADV-B
ENRENR-1060642026-04-12T14:37:18ZSharon—Cunningham9/24/1945UHC-72535-93•••-••-8079273-496-7284sharon.cunningham@aol.com5534 Camelback RdTUCSONAZ85723GRP-5457OPTIONS-PPO
CLMCLM-4194152026-03-28T03:45:45ZCHARLOTTE—WEBER03/02/1964UHC-81561-06null·744-532-8343UNKNOWN6065 SAGE COURTScottsdaleAZ85265-1372GRP-6824null
ENRENR-1381582026-07-31T11:10:38ZShirley····Romero1979-11-11UHC-08052-78•••-••-20102028023745SHIRLEY.ROMERO75@ICLOUD.COM3313 Bayshore DrSeattleWA98136GRP-6423CORE-HMO
TPATPA-504782026-04-05T02:53:59ZHIROSHI—HERNANDEZ11/21/1961··N/AN/A—1528 Central AvenueChandlerAZ-UNKNOWNnull
TPATPA-561642026-09-06T00:05:29ZLUIS—WALKER19800617UNKNOWN———NULL—··—N/ACHOICE-PLUS-PPO
CLMCLM-4041402026-07-18T13:45:50ZSchmidt, Willie——05/12/42UHC-28576-15•••-••-6299UNKNOWNNULL··446 Maple AveHoustonTexas77030null······
TPATPA-512022026-09-26T05:30:59ZLuisWWallace0204-91-39-•••-••-4201—·null6713 Main StreetColumbusOH43232UNKNOWNCHOICE-PLUS-PPO
ENRENR-1162542026-10-14T03:27:09ZHENRYW.NGUYEN1979-04-14·UHC-68744-54•••-••-49824273006444henry.nguyen@outlook.com5257 Market StPlanoTX75027GRP-5876··CHOICE-PLUS-PPO
PRVPRV-201702026-02-23T05:26:38Z STEPHANIE—HAMILTON1986-01-08UHC-85850-81NULL18273998162STEPHANIE.HAMILTON96@GMAIL.COM6645 HIGHLAND AVEPhoenixAZ··85085N/AOPTIONS-PPO
CLMCLM-4051302026-06-16T01:09:38ZSofia—OBrien1967-03-16UHC-11144-41NULL+1 761 360 3371—7485 Ridge RoadJacksonvilleFloridaUNKNOWNnull-
PRVPRV-244442026-04-16T18:29:52ZJannet—Hernandez·Apr 8, 1956UHC-93819-19N/A942.362.5956janet.hernandez@outlook.com5958 MEADOW LNTampaFL·33687-3831NULL—
PRVPRV-206332026-08-21T07:29:03ZLUISRFREEMAN··Jul 1, 1981—····437-813-6234-·147 Central AvenueTucsonaz85797NULLCORE-HMO
ENRENR-1040652026-02-25T15:16:27ZJUDITH—PENA08/25/39UHC-47584-45•••-••-9211(561) 510-5268JUDITH.PENA@OUTLOOK.COM1931 BASELINE ROADDenverCO80265GRP-4982OPTIONS-PPO
CLMCLM-4156212026-02-02T02:57:42ZAna··WalkerJul 26, 1993—•••-••-6807(239) 585-1520—8185 Camelback RoadFresnoCA93783-5451—··
ENRENR-1229162026-10-01T20:28:56ZHELEN—WALLACE2006-03-25UHC-46407-62•••-••-25548436749helen.wallace30@gmail.com8344 MOUNTAIN VIEW DRIVEPhoenixArizona··85029GRP-9702SELECT-EPO
CLMCLM-4120762026-07-02T23:13:32ZNoah—Ray1949-02-28—N/AnullUNKNOWN6992 Harbor BlvdAtlantaGA30348GRP-8430N/A
ENRENR-1281892026-04-13T04:17:24ZReid, HelenM.—2005-11-28UHC-88997-72··•••-••-39507597401091null463 Cedar LaneMesaAZ85254-6886GRP-4472CORE-HMO
ENRENR-1255442026-05-18T10:48:42ZSophia—Moreno··1979-04-16UHC-86788-83•••-••-72869439019688sophia.moreno57@aol.com7487 Ridge RdTucsonAZ85721GRP-1938MEDICARE-ADV-A
ENRENR-1176212026-09-09T21:35:36ZStephanieN··Henry1986-08-02UHC-38840-31•••-••-02076568008160-1435 Meadow LnJACKSONVILLEFL32236GRP-4984NAVIGATE-HMO
CLMCLM-4036892026-03-12T05:03:32ZValentina—Gonzalez09/13/95UHC-08034-63null—-UNKNOWNUNKNOWN—nullGRP-9579—
CLMCLM-4218792026-06-29T17:22:56ZPeterson, Catherine——1954-08-10·UHC-33326-02UNKNOWN+1 625 883 6765null4080 CANYON RDPHOENIXAZ85057GRP-3840—
CLMCLM-4148732026-02-08T04:47:14ZNicole—Banks1949-11-11·UHC-40533-39N/A3984418821—2501 Apache BoulevardTAMPAFL33664GRP-2975-
TPATPA-582742026-08-09T09:21:56ZPaul—WhiteMar 22, 1995—•••-••-4893913-868-4896—3950 ELM STREETSeattleWA··98132-9851GRP-0726—
ENRENR-1118812026-06-27T02:36:26ZSTEPHENOCARLSON09-05-1953UHC-58376-55•••-••-3434774-217-5670stephen.carlson3@hotmail.com655 CENTRAL AVENUEAustinTX78703GRP-4941··CORE-HMO
ENRENR-1118932026-07-03T20:07:09ZBETTY··FIELDSAug 24, 2006NULL•••-••-4070547-873-8985betty.fields@hotmail.com2940 Cedar LnScottsdaleArizona85273GRP-8918··MEDICARE-ADV-B
ENRENR-1373062026-02-27T08:31:52Z·Shirley·YGordon1105-19-45UHC-16318-59•••-••-9816355-573-8550shirley.gordon@icloud.com734 Park PlaceLOS ANGELESca90082GRP-0524CHOICE-PLUS-PPO
TPA TPA-611132026-05-09T15:09:56ZMARY—SMITH1945-00-79-—569-265-6792UNKNOWN1344 Apache Boulevard··AustinTX78704GRP-5726-
TPATPA-624102026-07-26T17:18:55ZJOSHUA—WALLACE1951-01-01——-JOSHUA.WALLACE7@HOTMAIL.COM8108 Ocean AveLAS VEGAS··NV89114NULLN/A
ENRENR-123527 2026-08-01T05:10:09ZVirginiaSHarrisApr 23, 1944UHC-58262-17•••-••-9740+1 869 460 9340virginia.harris34@gmail.com1341 Harbor BlvdSeattleWA98144GRP-5858CORE-HMO
TPATPA-622472026-09-20T01:49:34ZFRANCES····HAWKINS·Jan 24, 1946UNKNOWN··•••-••-5476--1252 Cedar LnFRESNOCA·93711GRP-0831N/A
ENRENR-1234962026-04-20T12:04:50ZBRYAN—SANDOVAL1971-04-14UHC-04047-70•••-••-01473945181348null1005 BAYSHORE DRSEATTLEWashington98195GRP-8454MEDICARE-ADV-B
CLM CLM-4110682026-05-30T00:03:50ZRyan, Beverly——1961-02-18··UNKNOWN•••-••-9387——7221 APACHE BLVDFresnoCalifornia93734GRP-1307CORE-HMO
ENRENR-1428792026-05-17T16:02:06ZStephens—Emily1940-08-13UHC-19912-27NULL··8006667095emily.stephens@icloud.com··7973 Mesa DrScottsdaleAZ85204GRP-2024SELECT-EPO
ENRENR-1326102026-02-24T10:23:12ZKevin··J··Wallace1941-08-01UHC-23571-56•••-••-02732128780265kevin.wallace90@icloud.com1250 DESERT SKY BLVDHOUSTONTexas77022GRP-2676SELECT-EPO
TPATPA-57950 2026-05-10T22:55:29ZMITCHELL——1971-03-02nullN/A-UNKNOWN9358 Jefferson Avenue Apt 37·DENVERCO80204GRP-4438—
100,000 rows, page 83 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.797Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty