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

Enrollment only, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
ENRENR-1366592026-07-05T16:58:32ZRalph—Harper2008-03-13UHC-54586-42•••-••-75616028804067RALPH.HARPER3@OUTLOOK.COM1648 CANYON RDDallasTX75283GRP-3520··MEDICARE-ADV-B
ENRENR-1309032026-06-29T09:54:44Z Dvaid—Coleman1961-05-27UHC-19416-38•••-••-2701333-262-0984david.coleman16@proton.me8553 Hillcrest RdMESAAZ85295GRP-3025NAVIGATE-HMO
ENRENR-1254952026-07-24T00:33:56ZCARLOS—HOWARD05/04/59UHC-62694-54•••-••-2442(979) 703-7808—3073 SAGE COURTFresnoCA····GRP-6163NAVIGATE-HMO
ENRENR-1380242026-01-27T07:46:56ZVirginia—Johnstoon09/20/1978UHC-69226-82•••-••-9281(852) 367-5057—6385 RIDGE RDNashvilleTN37271GRP-2811·SELECT-EPO
ENRENR-1113432026-08-21T20:34:51ZMunoz, Sephen——04/11/71UHC-44645-89•••-••-8173(583) 855-6176NULL4303 Maple AveScottsdaleAZ85280GRP-6726MEDICARE-ADV-B
ENRENR-1080982026-05-11T03:49:57ZJanVFord1961-06-01UHC-81103-79UNKNOWN·18266112575joan.ford85@aol.com1232 Sage CourtTucsonAZ85756GRP-6280MEDICARE-ADV-B
ENRENR-1166762026-03-11T14:08:29Z CARL··V.··PEA19910322UHC-76006-41null(412) 885-1476carl.pena79@hotmail.com2590 Church StLas VegasNVN/AGRP-3888CORE-HMO
ENRENR-1292032026-05-17T14:00:29ZBENJAMINE.SANTOS1967-09-27UHC-77350-11—5217342562NULL6844 Main StreetTampaFL33656GRP-1673SELECT-EPO
ENRENR-1020372026-06-22T22:16:48ZJohn—Graham1982-06-14UHC-03219-23•••-••-22383267854971john.graham79@gmail.com719 Central AveTampaFL33657··GRP-2838CHOICE-PLUS-PPO
ENRENR-1308272026-09-07T05:13:59ZharoldU··marquez19430927N/A•••-••-2536727-881-3823harold.marquez@hotmail.com1701 Lake View RoadTEMPE··AZ85241··GRP-2147MEDICARE-ADV-B
ENR ENR-1093022026-09-09T08:31:15ZSAMANTHA—FREEMAN1977-05-08UHC-78622-78•••-••-5424(755) 511-5205samantha.freeman98@aol.com1512 Camelback RdScottsdale·AZ85243GRP-1739CORE-HMO
ENRENR-1281952026-03-12T15:46:34ZGREGORYMWILLIS1952-09-13UHC-20155-17•••-••-5051—GREGORY.WILLIS3@ICLOUD.COM6901 Pine Drive··AtlantaGA·30391GRP-2079OPTIONS-PPO
ENRENR-1027082026-02-01T03:40:53ZJOYCESCUNNINGHAM1953-08-27—•••-••-77354667893731joyce.cunningham@aol.com6191 Baseline RdDallasTX75242GRP-0938MEDICARE-ADV-B
ENRENR-1385492026-03-30T03:52:22ZJoyceSWalsh··2005-05-05UHC-32807-99•••-••-78348707354629-3039 Ocean AveTampaFlorida33641GRP-1372SELECT-EPO
ENRENR-1069452026-06-18T07:27:44ZRogerVJensanApr 21, 1977UHC-86142-77•••-••-1071-ROGER.JENSEN@OUTLOOK.COM8290 Indian School RoadJACKSONVILLEFL32293-1184GRP-4087SELECT-EPO
ENRENR-1428372026-01-23T12:32:40ZMARK—WALSH06/15/1980UHC-70851-53•••-••-8074N/A—9283 Bayshore DrAtlantaGA··30320GRP-2937core-hmo
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
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
ENRENR-1028312026-08-30T22:24:13ZNICOLE—RYYAN11/06/1991UHC-77194-09•••-••-8614385.595.8388NICOLE.RYAN87@ICLOUD.COM3257 Ocean AvePhoenixAZ85006GRP-7130··NAVIGATE-HMO
ENRENR-1280752026-01-25T01:43:59ZMARILYNE.HERRERA1/20/1950UHC-81602-27•••-••-6736368-546-7433marilyn.herrera60@yahoo.com7170 MEADOW LNPLANOTX75060GRP-5955MEDICARE-ADV-A
ENRENR-1009942026-09-06T01:52:15ZGardner, Stephanie—····12/28/1953UHC-33192-03•••-••-0110UNKNOWNstephanie.gardner41@hotmail.com1154 Lincoln WaySeattleWA98159-3094··GRP-6016MEDICARE-ADV-A··
ENR ENR-1146162026-10-11T09:36:24ZMADISON—RIOS1983-03-13·N/A•••-••-017512314587048madison.rios@icloud.com8428 DESERT SKY BOULEVARDEden PrairieMN55371GRP-3291MEDICARE-ADV-A
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
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
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
ENR ENR-1269372026-06-25T13:10:16ZJanetT.Hicks1980-06-24UHC-23608-84—N/A-·8500 Apache Boulevard·TucsonAZ85711GRP-7308MEDICARE-ADV-A
ENRENR-1036852026-01-11T17:38:51ZGARY—SANTIAGO11/24/73UHC-81154-41•••-••-315012312101694gary.santiago15@aol.com8346 Spring StCOLUMBUSOH43297·GRP-3708CORE-HMO
ENRENR-1242952026-10-01T13:22:33ZGabrielFCole1988-03-14UHC-38729-59N/A6563478437gabriel.cole90@proton.me2533 Hillcrest RdEden PrairieMN55350GRP-0660CORE-HMO
ENRENR-1026342026-04-02T11:17:06ZMoore—Alan19690217UHC-36244-99•••-••-2452+1 887 234 3858ALAN.MOORE@ICLOUD.COM24 BroadwayOrlandoFL32850GRP-3577NAVIGATE-HMO
ENRENR-1165482026-01-19T19:07:45ZJESSE—ROSS1940-07-10UHC-10623-58—294.948.2011jesse.ross81@proton.me8651 Jefferson AvenueLos Angeles·CA90020GRP-8215SELECT-EPO
ENRENR-1033392026-06-26T15:12:35ZLong, Adam—··2008-07-05UHC-08708-37•••-••-14372146031253adam.long76@icloud.com217 VALLEY VIEW DRIVEPlanoTX75043·GRP-3413CORE-HMO
ENRENR-1421512026-08-09T19:01:30ZJULIA····HICKS1983-05-13UHC-00561-02•••-••-0035371-352-7640julia.hicks95@outlook.com4145 Elm StPhoenixAZ·85010-7363GRP-0642MEDICARE-ADV-B
ENRENR-1194132026-04-10T12:20:31ZCynthia··X.Andrews1980-11-24·UHC-70291-44•••-••-9478(558) 549-0738CYNTHIA.ANDREWS@HOTMAIL.COM3509 Canyon RdNASHVILLE··TN··37251GRP-7890NAVIGATE-HMO
ENRENR-1223122026-03-25T06:15:00ZChristopher—Dixon1953-03-19··UHC-08912-57•••-••-7967987-727-6689christopher.dixon@icloud.com2285 HIGHLAND AVECHARLOTTENorth Carolina28298·GRP-1666choice-plus-ppo
ENR ENR-1381502026-04-17T16:48:04ZSaaYGreene1968-00-39UHC-27441-33•••-••-4264319-486-0136NULL8734 WILLOW CTLos AngelesCAN/AGRP-4483OPTIONS-PPO··
ENRENR-1331422026-03-22T04:57:42Zmark—jacobs··1980-06-09UHC-36737-62•••-••-587418449756221··MARK.JACOBS16@PROTON.ME5805 Ridge RoadEden PrairieMN55358GRP-5640MEDICARE-ADV-A
ENRENR-1179182026-05-06T11:21:03ZCarl—Dunn08/26/2005UHC-36015-71··•••-••-9562902.411.3018carl.dunn25@aol.com4149 Ridge RdMesaAZ85223GRP-5536OPTIONS-PPO
ENRENR-1185722026-04-23T13:41:05ZJessicca··—Wang2003-01-20UHC-04085-61—465.332.5459null··5652 MEADOW LANE·SacramentoCA95839-7206GRP-8313MEDICARE-ADV-A
ENRENR-1278222026-03-25T01:56:10Z·Isabella—Cruz1986-10-24UHC-73824-92•••-••-6989214-561-4888isabella.cruz@yahoo.com4145 Palm DrTampaFL33689·GRP-1845NAVIGATE-HMO
ENRENR-1349752026-10-01T01:24:35ZCynhiaHStephens1957-04-06UHC-44022-07•••-••-66652173893906cynthia.stephens@gmail.com8209 Bayshore Drive Apt 25Atlanta·GA30364GRP-1614CHOICE-PLUS-PPO
ENRENR-1279072026-07-30T19:53:42ZDiego····HolmesDec 1, 1973UHC-69313-48•••-••-075417772756459diego.holmes62@yahoo.com1427 Palm Drive·TEMPEAZ85241GRP-7461CHOICE-PLUS-PPO
ENRENR-1287912026-04-11T05:49:40ZJESSEABALCK05/08/2001UHC-15116-96•••-••-6593371.393.6198JESSE.BLACK@ICLOUD.COM··9697 Highland AvenueFresnoCA93736GRP-8093SELECT-EPO
ENRENR-1330612026-02-27T15:55:06ZBeverlyE.Nunez··1952-01-05UHC-25845-36null7086295485beverly.nunez@aol.com··8457 Desert Sky BlvdSan DiegoCalifornia92174GRP-6241OPTIONS-PPO··
ENRENR-1268982026-02-27T02:42:52ZArjun—Wrad1947-05-05UHC-36964-14•••-••-1903+1 365 549 2987arjun.ward@proton.me8909 HARBOR BOULEVARDTempeAZ·85298GRP-2443MEDICARE-ADV-A
43,101 rows, page 68 of 863PreviousNext

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.701Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty