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-260822026-03-27T13:58:25ZSARA—HANSON1993-07-16··UHC-23621-71null626-527-9615··sara.hanson86@icloud.com2711 SAGE CTCharlotteNC28237-9217NULLUNKNOWN
TPA TPA-559202026-09-11T17:50:58ZNatalie—Wang05/17/1942—NULLNULLNULL5516 Market StAUSTINTX78786—NULL
TPA TPA-601092026-06-05T00:06:48Z·Amanda—Kelly2001-05-04—NULL5352352423null2294 SUNSET BOULEVARDPHOENIXAZ85090——
CLM CLM-4103982026-10-09T01:40:56ZAna—Robinson1955-02-02UHC-45904-17•••-••-1224(487) 986-0691ana.robinson@proton.me3989 Indian School RoadSAN DIEGOCA92142—MEDICARE-ADV-B
ENRENR-1124632026-01-08T11:59:42ZEMILYTLITLTE02/24/1940UHC-13577-79•••-••-9844242.551.1162EMILY.LITTLE@YAHOO.COM6250 Willow CtLAS VEGASNV89138·GRP-1041MEDICARE-ADV-B
ENRENR-1296482026-07-17T12:06:19ZWheeler, TimothyN—1939-02-03UHC-43507-18•••-••-3464·2362790687timothy.wheeler36@gmail.com3238 Jefferson AveSan AntonioTX78239·GRP-7896·CORE-HMO
ENRENR-1254272026-10-03T10:12:01ZCunningham, Mason——19940609UHC-61288-67•••-••-52785032429mason.cunningham@aol.com5701 APACHE BLVDSan DiegoCA92112-1479GRP-4572···options-ppo
ENRENR-1132382026-05-06T21:27:43ZAngelaJNelson1952-06-24UHC-53462-83•••-••-3900—ANGELA.NELSON19@ICLOUD.COM9254 Forest AveMinneapolisMN55497GRP-0955··options-ppo
CLMCLM-4284422026-01-18T20:05:02ZTeresa—Spencer1995-05-10UHC-23682-43•••-••-2505——5215 Grand AveSAN DIEGOCA92120null··UNKNOWN
ENRENR-1417152026-03-12T03:08:20ZSAMANTHA—GIBSON1957-09-02··UHC-11351-96•••-••-9421821-201-5556SAMANTHA.GIBSON41@OUTLOOK.COM6973 Camelback RdPlanoTX··N/AGRP-1705CORE-HMO
TPATPA-554592026-06-16T18:31:59ZMunoz··Brandon·Aug 13, 1954—•••-••-6662—null7696 Highland AveTEMPEAZ——CORE-HMO
CLMCLM-4201312026-06-21T06:10:04ZLawrenceHButler01/19/1997NULL—·(523) 651-0574-UNKNOWN-N/AUNKNOWNGRP-7918··OPTIONS-PPO
ENRENR-1085372026-03-21T16:25:40ZOliver, WayneP—1976-04-07UHC-87651-90··•••-••-463417625235720wayne.oliver@yahoo.com365 Church Street··SacramentoCA95831GRP-8343MEDICARE-ADV-B
ENRENR-1266722026-05-29T11:49:41ZETHANBMARQUEZ2/26/1940UHC-16341-34•••-••-6602-ethan.marquez60@outlook.com··513 WASHINGTON STREETPHOENIXAZ85008GRP-0137NAVIGATE-HMO
ENRENR-1081972026-09-30T08:55:46ZVictoriaZSchmidt1988-06-12UHC-00189-24•••-••-44885377627244-4939 Church StGilbertArizona85276GRP-5352MEDICARE-ADV-A
CLMCLM-4023842026-10-03T16:21:44ZHeather—Boyd19541026UHC-21223-18UNKNOWNNULLnull—N/A—N/AGRP-4502MEDICARE-ADV-A
CLMCLM-4155272026-05-25T01:37:19ZMeanARios1976-08-25·UHC6858964NULL9348243802—3996 Sage CtDENVERCO··nullnullCORE-HMO
TPATPA-577502026-07-26T15:55:37ZAlexis—Tran01/26/1938UHC-80596-07•••-••-0444(634) 916-6724null238 Apache Blvd··SacramentoCA95836··NULL··N/A
ENRENR-1296312026-03-21T09:58:30ZMEGANVCARTER09/14/53UHC-16129-53·null467.407.1961megan.carter@yahoo.com2354 Canyon RdTUCSONArizona-GRP-0695CORE-HMO
ENRENR-1151332026-06-21T22:07:53ZJUANPBELL1953-01-03UHC-73306-19•••-••-2546·661-791-3840juan.bell@hotmail.com8862 HILLCREST ROADPHOENIX··AZ85021GRP-5579NAVIGATE-HMO
ENRENR-1329612026-05-01T09:55:22ZJulia—Hudson1988-05-01UHC-12835-65··•••-••-7331UNKNOWNJULIA.HUDSON18@AOL.COM3484 Maple AveEden Prairie··MN55357GRP-6656SELECT-EPO
ENRENR-1197902026-10-10T13:13:09Z·Benjamin—Garcia1939-10-07UHC6256650··•••-••-3849·7166680938BENJAMIN.GARCIA65@ICLOUD.COM5928 Market StJacksonvilleFL32254··GRP-1465NAVIGATE-HMO
TPATPA-510312026-03-15T04:54:38ZJAMES—·CHEN1961-02-13N/AnullUNKNOWNNULL2201 RIVER ROAD··TucsonAZ85704N/AUNKNOWN
CLMCLM-4266942026-06-14T01:02:42Z Lucia—Turres05/24/1981·UHC1026177—8078860849·NULL7826 WILLOW COURT·ChandlerAZ85240··GRP-8950-
ENRENR-1313752026-01-23T06:12:43ZMikeCHowell··1957-08-13UHC-32931-18•••-••-77048265136717michael.howell@outlook.com9001 Washington StreetJacksonvilleFLUNKNOWNGRP-3760MEDICARE-ADV-A
ENRENR-1162642026-09-02T12:44:20Z·AmebrGLawson09/26/62UHC-27031-71•••-••-57439679214070amber.lawson45@yahoo.com2988 Sunset BoulevardOrlandoFL32837GRP-9520MEDICARE-ADV-A
ENRENR-1233002026-07-27T03:28:44ZJackFLawson03/07/1992UHC-45514-20•••-••-8340205-940-5754JACK.LAWSON4@OUTLOOK.COM5849 CEDAR LN·ColumbusOhio43207GRP-0708MEDICARE-ADV-A
TPATPA-58159 2026-02-12T22:25:13Z·Elliott, Charlotte——1996-01-01—•••-••-7755—null7422 Market StreetGLENDALEAZ85322GRP-0750CORE-HMO
ENRENR-1241322026-05-21T08:37:54ZGregory—Campbell19-07-1994·UHC-68048-71UNKNOWN563-879-1987GREGORY.CAMPBELL79@GMAIL.COM3056 Lincoln WayScottsdaleAZ··85298GRP-2823CHOICE-PLUS-PPO
ENRENR-1097512026-04-04T19:37:56ZBRANDON—VARGAS1940-09-03UHC-62219-78•••-••-0956UNKNOWNUNKNOWN1647 Maple AveDallasTX75242GRP-9277·CHOICE-PLUS-PPO
ENRENR-1091422026-01-28T08:05:26ZCAROLR.CLARKUNKNOWNUHC-30064-04•••-••-87638272257839carol.clark93@hotmail.com··6078 LINCOLN WAYColumbusOH43226GRP-9795SELECT-EPO
TPATPA-526972026-06-28T23:21:55ZMariana—Peters1948-07-02UHC-46297-05—N/AMARIANA.PETERS@PROTON.ME210 Highland AveSEATTLEWA98129—N/A
TPATPA-592332026-05-31T04:38:39Z·Jesse—Perkins04/16/85—-(732) 969-1671NULL6341 WILLOW COURTNashvilleTN37225N/A—
TPATPA-542372026-04-10T23:10:45ZPatricia—Phillips1963-07-20———N/A3971 Jefferson Avenue #862Los AngelesCA90010··nullnull
CLM CLM-4321812026-03-07T06:58:46Z Delgado, Helen··——1973-02-22UHC-47049-67•••-••-777914605708794—6734 Grand AveJacksonvilleFL32219NULLCORE-HMO
ENRENR-1136162026-04-28T22:21:49ZLindaVMartin—UHC-10140-61•••-••-9398(218) 880-8792linda.martin27@gmail.com318 VALLEY VIEW DRIVEAUSTINTX78783GRP-1263MEDICARE-ADV-B
CLMCLM-4137162026-05-19T00:26:26ZDENISE—HAYES04/27/07UHC-92115-37•••-••-3481····—4768 Mountain View DrSAN ANTONIOTX78254——
ENRENR-1405982026-04-30T15:55:08ZJeanG.Scott7/28/2008UHC-21473-47•••-••-6776824-350-1357·jean.scott@outlook.com8015 River RdMinneapolisMN55419GRP-9630core-hmo
CLM CLM-4108972026-06-19T03:44:06ZCHERYL—KENNEDY1982-09-19NULL•••-••-8363null—2547 Washington StreetPLANOTX75005GRP-1743NULL
CLM CLM-4020572026-09-16T21:52:00ZRANDY—BARNES2000-03-03uhc-19730-93N/A240-899-1504-429 Union StreetHoustonTX77094GRP-7137—
ENRENR-1320962026-01-19T17:44:05Zbarbara··—bell··1978-10-25UHC-53380-72•••-••-16845579080129barbara.bell@yahoo.com9869 Lincoln WayMIAMI··FL33119GRP-5279OPTIONS-PPO
TPATPA-570602026-01-05T06:02:04ZCAMILAWWALSH01/13/60N/A•••-••-4489(771) 688-5768—2775 Harbor BoulevardTempeAZ85215··N/ACHOICE-PLUS-PPO
ENRENR-1384572026-01-19T16:51:14Z Julia···HThomas15-07-1956UHC-31006-41•••-••-2622(391) 323-8352julia.thomas@yahoo.com8342 Hillcrest RoadGlendaleAZ85348GRP-2264NAVIGATE-HMO
ENRENR-1079562026-09-14T22:58:03ZGary·AHernandez1973-05-06UHC-48744-09•••-••-9279(336) 971-1247gary.hernandez90@icloud.com8374 Central AveTempeAZ85208GRP-7317·OPTIONS-PPO
ENRENR-1108772026-01-13T16:54:26Zroy—ryan19971127NULL•••-••-2710(978) 704-6584roy.ryan@icloud.com4248 Union StGLENDALEAZ85310GRP-6103CORE-HMO··
PRVPRV-252792026-02-26T16:37:24ZJustinLGordn1958-09-10··UHC-93719-60N/AUNKNOWNjustin.gordon94@yahoo.com8913 Mountain View DrivePhoenixAZ85069-3667··-NULL
CLMCLM-4139092026-04-15T11:25:55Z·Lori··Carter1979-12-12N/A•••-••-3362(540) 633-8501-6789 Maple AveSacramentoCA95812-3903GRP-4603SELECT-EPO
CLM CLM-4137072026-07-14T10:35:01ZSANTIAGO—MOURE1963-11-19N/A—NULL—3960 SPRING STNashvilleTNNULLGRP-2818UNKNOWN
CLMCLM-4227072026-05-06T20:33:10ZZACHARY—OLSONSep 6, 1993UHC-00455-39•••-••-0266-null592 JEFFERSON AVENUECharlotteNorth Carolina28281—NAVIGATE-HMO
ENRENR-1291412026-09-14T09:01:36Z PATRICK—ORTEGAJul 20, 2001UHC-45462-68•••-••-16132622405NULL··348 Cedar LnAtlantaGeorgia30305GRP-5629CHOICE-PLUS-PPO
100,000 rows, page 101 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:36.676Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty