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-1069452026-06-18T07:27:44ZRogerVJensanApr 21, 1977UHC-86142-77•••-••-1071-ROGER.JENSEN@OUTLOOK.COM8290 Indian School RoadJACKSONVILLEFL32293-1184GRP-4087SELECT-EPO
PRVPRV-207152026-07-28T01:57:36ZETHAN····HUGHES1959-03-09——458-370-1146null3985 Palm DriveTucsonAZ85755··UNKNOWN
CLMCLM-4183572026-01-01T07:16:11ZKelly··Richardson1959-01-18-NULL—··1166 Sunset BlvdATLANTAGA30394——
ENRENR-1428372026-01-23T12:32:40ZMARK—WALSH06/15/1980UHC-70851-53•••-••-8074N/A—9283 Bayshore DrAtlantaGA··30320GRP-2937core-hmo
TPA TPA-550092026-06-14T11:21:20ZCHRISTINA—GUZMAN27-07-1999—-—UNKNOWN3359 Cedar LaneScottsdaleAZ85253GRP-9598CHOICE-PLUS-PPO
ENRENR-1118092026-05-03T15:43:44ZHarper, AishaA—19510320··UHC2180206··——aisha.harper96@icloud.com8721 GRAND AVENUE Apt 24Phoenix··Arizona85040GRP-3764NAVIGATE-HMO
ENRENR-1421802026-03-22T03:41:58ZMATTHEW—BENNETT12/27/1960UHC-23368-20•••-••-64539269975765UNKNOWN4921 Elm StreetAustin·TX78741GRP-2006CHOICE-PLUS-PPO
ENRENR-1210082026-01-05T09:30:29ZJasonM.Thompson1948-08-01UHC-34426-37•••-••-8046(938) 505-7920jason.thompson@icloud.com··1522 MARKET STREETLAS VEGAS··NV89126GRP-0972MEDICARE-ADV-B
CLMCLM-4122992026-01-27T13:34:04ZLAWRENCEJ.WATSON19951004——19029864081··9551 CAMELBACK ROADMinneapolisMN··55483NULLMEDICARE-ADV-B
CLMCLM-4001682026-01-28T01:39:19ZWebbb, Bryan——10/09/1961UHC6189496UNKNOWN12515226792N/A5836 Central AveCharlotteNorth Carolina28269GRP-2431CORE-HMO
PRVPRV-277462026-09-17T09:47:14ZRobertAJrodan1969-07-05UNKNOWNNULL·372-340-8224null8316 Mesa DrFRESNOCA93714N/AOPTIONS-PPO
TPATPA-632452026-10-08T23:56:01Z Diego—Chavez1982-12-14NULL•••-••-79364907143270———UNKNOWN———
ENRENR-1139492026-05-21T05:08:20ZMarcusIRicce1982-08-20·UHC-32796-32—N/Amarcus.rice21@yahoo.com··2730 Market StreetSacramento··CA95865GRP-1546CORE-HMO
ENRENR-1249682026-03-26T00:12:59ZEmily—Jimenez19740109UHC-37262-79•••-••-86929217438580··EMILY.JIMENEZ@YAHOO.COM2840 Spring StMinneapolisMinnesotaNULLGRP-0862CORE-HMO
TPATPA-622662026-07-19T17:59:27ZVALENTINA—ELLIOTT19540517—N/A2326895943·NULL7142 CANYON ROADSan DiegoCA92149nullN/A
TPATPA-520142026-07-19T20:23:32ZKenneth—Jordan19630922···NULL—(355) 855-2864··—3273 Canyon RoadMinneapolisMN55437UNKNOWN·NAVIGATE-HMO
ENRENR-1028312026-08-30T22:24:13ZNICOLE—RYYAN11/06/1991UHC-77194-09•••-••-8614385.595.8388NICOLE.RYAN87@ICLOUD.COM3257 Ocean AvePhoenixAZ85006GRP-7130··NAVIGATE-HMO
TPATPA-520922026-01-14T09:23:55ZSchmidt, Bradley——·04/16/54·-····N/AN/A—-N/A··NULLnull··N/A
ENRENR-1280752026-01-25T01:43:59ZMARILYNE.HERRERA1/20/1950UHC-81602-27•••-••-6736368-546-7433marilyn.herrera60@yahoo.com7170 MEADOW LNPLANOTX75060GRP-5955MEDICARE-ADV-A
CLMCLM-4163482026-08-02T06:36:02Zarjun—anderson2006-04-21-—NULLN/A7072 Desert Sky BoulevardAustinTXnullGRP-2226null
PRVPRV-290002026-04-10T04:44:03ZEdwards, BrandonJ—1948-04-23UHC-65049-62—nullNULL3531 Church Street··SacramentoCA95850-4614-·NULL
CLMCLM-4031872026-05-19T21:51:04ZYukiAHerrera2004-09-05——(220) 917-8255N/A1268 Palm Drive··MinneapolisMN-GRP-0586-
CLMCLM-4045102026-09-27T17:38:11ZDaniel—Allen1944-11-27UHC-80230-70—233-223-8726daniel.allen36@yahoo.com9804 Camelback RoadHoustonTX77018NULLNULL
TPATPA-607782026-05-12T16:13:34ZOlivia—Wheeler1965-10-28—nullNULL-8573 Ridge RoadMesaAZ85217NULLNULL
ENRENR-1009942026-09-06T01:52:15ZGardner, Stephanie—····12/28/1953UHC-33192-03•••-••-0110UNKNOWNstephanie.gardner41@hotmail.com1154 Lincoln WaySeattleWA98159-3094··GRP-6016MEDICARE-ADV-A··
CLMCLM-4310502026-09-16T14:55:15ZLAWRENCEE·HANSEN1988-02-04NULLUNKNOWNN/Alawrence.hansen21@gmail.com2358 Meadow Lane Apt 21MIAMIFlorida33103N/A-
CLMCLM-4109152026-04-13T10:26:37ZBETTY—WILSOON2001-09-19UHC-90824-27null—null4772 Desert Sky BoulevardTampaFL33684—MEDICARE-ADV-B
ENR ENR-1146162026-10-11T09:36:24ZMADISON—RIOS1983-03-13·N/A•••-••-017512314587048madison.rios@icloud.com8428 DESERT SKY BOULEVARDEden PrairieMN55371GRP-3291MEDICARE-ADV-A
CLMCLM-4066142026-03-28T06:33:55ZJose—Roberts1942-07-12UHC-90725-16———1301 ELM STREETJACKSONVILLEFL—GRP-4710OPTIONS-PPO
ENRENR-1179842026-02-19T19:01:10ZCheryl··Peterson1992-11-27··UHC-36242-97•••-••-3353·+1 467 553 4640UNKNOWN3491 GRAND AVEChandlerAZ85253··GRP-3616MEDICARE-ADV-B
ENRENR-1161712026-10-07T03:39:54ZMATTHEWN.HOLMES09/25/2006uhc-18381-60•••-••-7979973.444.5102matthew.holmes@yahoo.com··7504 Meadow Lane·CHARLOTTENC28280GRP-0215SELECT-EPO
ENRENR-1083472026-10-02T18:18:08ZJosephPSanchez····UHC-03075-13•••-••-5117(820) 434-7708joseph.sanchez50@aol.com1777 Central AveSAN ANTONIOTX78272GRP-6842SELECT-EPO
CLMCLM-4142162026-01-20T20:00:41Zanna—kennedy1955-01-20UNKNOWN··•••-••-7453—UNKNOWN—UNKNOWN··N/AN/A-—
ENRENR-1032122026-08-17T15:58:26ZStephen—Perkins02-11-1944UHC7959067•••-••-3356+1 214 826 2899stephen.perkins@yahoo.com6701 Valley View DriveSAN ANTONIOTX·78241·GRP-8850CHOICE-PLUS-PPO
CLM CLM-4276072026-03-07T22:45:50ZRICHARDALAWRENCE1953-06-20··UHC-05636-56UNKNOWN—UNKNOWN7375 SAGE CT #614Eden PrairieMN55371NULL—
ENRENR-1011472026-08-28T23:20:08ZBruceJHarrt1947-11-24UHC-94685-04•••-••-9598225.726.7026—735 Valley View Dr··Charlotte·nc28260GRP-5547MEDICARE-ADV-A
ENRENR-1366942026-06-10T02:33:07ZBarbaraJPadilla··Jul 1, 1957UHC2298671•••-••-0371(431) 211-8886·BARBARA.PADILLA@AOL.COM3337 Hillcrest RdPLANOTX75016GRP-1043·CHOICE-PLUS-PPO
CLMCLM-4262562026-01-05T08:02:39ZMarcKMatthews1990-03-08UHC-28870-27•••-••-1340-—4840 MARKET STAustinTexas78755GRP-0629OPTIONS-PPO
CLMCLM-4169302026-02-20T07:42:54ZGonzales, Nathan——2006-02-18UHC-41893-36N/A6422183948—null-nullNULLN/AN/A
ENR ENR-1269372026-06-25T13:10:16ZJanetT.Hicks1980-06-24UHC-23608-84—N/A-·8500 Apache Boulevard·TucsonAZ85711GRP-7308MEDICARE-ADV-A
CLMCLM-4178632026-06-02T20:25:08ZrogerEblackJul 21, 1992UHC-70794-50N/A—UNKNOWN929 HARBOR BOULEVARDDallas·Texas75217GRP-7634N/A
CLM CLM-4310772026-07-01T08:55:42ZJanet··Lewis19701007UHC-35740-35··(616) 462-4999JANET.LEWIS@OUTLOOK.COM3583 RIVER ROAD·PhoenixAZ85055GRP-3266N/A
CLMCLM-4226882026-01-18T17:01:16ZArthurVLawson··1980-01-04UHC-45410-99NULLN/A··—nullnullUNKNOWNGRP-3970CHOICE-PLUS-PPO
ENRENR-1036852026-01-11T17:38:51ZGARY—SANTIAGO11/24/73UHC-81154-41•••-••-315012312101694gary.santiago15@aol.com8346 Spring StCOLUMBUSOH43297·GRP-3708CORE-HMO
CLMCLM-4094412026-09-26T21:11:19ZCINTHIA—·CASTRO1981-10-06UNKNOWN··——··1248 Sunset BlvdSeattleWashington98189GRP-7224-
PRVPRV-258372026-03-26T12:47:17ZChrs—Morgan01-09-2007NULL—(398) 867-9277UNKNOWN469 PINE DRAustinTX78759UNKNOWNN/A
CLM CLM-4218862026-03-31T08:44:33ZbrittanyP.·fuller1939-10-04-NULL17165006523—1183 Elm St·MesaAZ85254-9075··GRP-3852UNKNOWN
ENRENR-1242952026-10-01T13:22:33ZGabrielFCole1988-03-14UHC-38729-59N/A6563478437gabriel.cole90@proton.me2533 Hillcrest RdEden PrairieMN55350GRP-0660CORE-HMO
CLMCLM-4064672026-10-14T01:31:15ZElizabeth—Fox2005-12-07—nullnull—9575 Ocean AveLos AngelesCalifornia90057-1415GRP-8523··choice-plus-ppo
ENRENR-1026342026-04-02T11:17:06ZMoore—Alan19690217UHC-36244-99•••-••-2452+1 887 234 3858ALAN.MOORE@ICLOUD.COM24 BroadwayOrlandoFL32850GRP-3577NAVIGATE-HMO
100,000 rows, page 155 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.702Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty