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-1394772026-07-10T02:40:44ZWALTERF·BURNS1996-10-24UHC-85668-20•••-••-64473558812378WALTER.BURNS@ICLOUD.COM739 Valley View DriveSeattleWashington98183GRP-5660CORE-HMO
ENRENR-1108272026-09-25T21:14:54ZHiroshi B—Warren2006-07-08UHC-03233-42•••-••-1752(837) 370-0145—1255 HIGHLAND AVESAN DIEGOCA92141GRP-3104CORE-HMO··
ENRENR-1157222026-10-06T18:55:53ZjanetE··ryan19510625UHC-07664-48null(529) 486-2951-1077 Sage CtMinneapolisMN55435GRP-3822CHOICE-PLUS-PPO
ENRENR-1221372026-01-01T23:12:35ZNOAH·EMORGAN1976-03-20UHC-82203-05··•••-••-4716408-309-2344noah.morgan29@hotmail.com5058 PALM DR #214NashvilleTN37274GRP-5781··CORE-HMO
ENRENR-1093962026-01-24T06:02:21ZAndreaT.Gilbetr2001-09-22UHC-60971-03•••-••-2436+1 739 935 4219andrea.gilbert61@gmail.com·2744 Valley View DriveLos AngelesCA90037GRP-2464CORE-HMO
ENRENR-1333392026-03-08T11:54:48ZKellyA.Stephens1994-10-12UHC-33651-42•••-••-38047027217283kelly.stephens41@outlook.com5799 Main StreetFresnoCA93733GRP-3068··MEDICARE-ADV-A
ENRENR-1194662026-10-01T02:38:37ZERICXSANTOS1978-03-04UHC-22547-48•••-••-9001(643) 610-6217eric.santos73@icloud.com·3962 CHURCH STREETTempeAZ85223GRP-7230CORE-HMO
ENRENR-1028302026-05-15T05:02:25ZHAROLDGSINGH19491222UHC-27892-54•••-••-4358581.780.2635harold.singh80@gmail.com7435 Lake View RoadSan AntonioTX78285GRP-2220NAVIGATE-HMO
ENRENR-1086252026-02-10T03:43:51ZEUGENEG.COX1983-02-14UHC-38773-39•••-••-0109920-585-1897EUGENE.COX@YAHOO.COM28 SPRING STREET Apt 20··MIAMIFL33105GRP-8477CHOICE-PLUS-PPO
ENRENR-1323762026-01-24T21:43:04ZSCOTTISOTO9/4/2005UHC-92231-93··•••-••-4672(366) 445-5284··—9832 Sage CourtHoustonTX—GRP-9808·OPTIONS-PPO
ENRENR-1185152026-06-14T20:14:52ZadamRcarlson1957-12-22UHC-63920-72•••-••-5725412-316-1162adam.carlson@proton.me6644 INDIAN SCHOOL ROADHoustonTX77040···GRP-7475OPTIONS-PPO
ENRENR-1253962026-01-11T19:45:24ZETHAN—GILBERT06/26/97UHC-51622-74UNKNOWN18179001392ethan.gilbert@outlook.com3637 Main Street··AtlantaGA30323GRP-6832navigate-hmo
ENRENR-1410242026-03-17T17:13:50ZNancyY.Gordon12/21/1985UHC-69812-77•••-••-0686315-603-1116null1446 FOREST AVENUEDenverCO80201GRP-3358SELECT-EPO
ENRENR-1299292026-08-21T07:53:33ZRANDY—STEWART1955-03-05··UHC0545620•••-••-0727N/Arandy.stewart93@proton.me8689 Grand AvenueSAN DIEGOCalifornia92137GRP-5524MEDICARE-ADV-B
ENRENR-1367192026-05-09T05:51:26ZDeborah—Ray19440203··UHC-55168-60•••-••-7658798-690-7373deborah.ray@proton.me596 Indian School RdSACRAMENTOCA95884GRP-0492MEDICARE-ADV-B
ENRENR-1313132026-06-13T07:22:33ZMarcusI·MyersDec 23, 1949UHC-16071-16•••-••-5189459-745-3607marcus.myers@outlook.com2919 Harbor BlvdScottsdaleArizona85218GRP-2075·CHOICE-PLUS-PPO
ENRENR-1061792026-05-20T10:21:02ZTONY··—WALKER04/20/78UHC-89985-79··—+1 909 790 7975anthony.walker58@aol.com320 Union StGlendaleAZ·85369GRP-9370medicare-adv-a
ENRENR-1312402026-09-22T11:10:29ZCarroll, FatimaT—19450308UHC-54168-90·-6583010002fatima.carroll@hotmail.com8669 MAPLE AVENUE Apt 19TempeAZ85291GRP-5830NAVIGATE-HMO
ENRENR-1000442026-09-21T03:34:52ZRuthJPrice·03-12-1978UHC-48375-18•••-••-5512322-707-8943null5458 Canyon RoadSEATTLEWA98144GRP-8491CORE-HMO
ENRENR-1172252026-07-07T13:31:15ZJose—Robertson1996-01-05UHC-71192-96—(538) 471-8244jose.robertson@gmail.com·3014 BROADWAYGlendaleAZ85360GRP-8099CORE-HMO
ENRENR-1401762026-08-24T03:11:07ZVALENTINAU··MYERS1970-10-13UHC8904881•••-••-5127414-977-9909valentina.myers94@icloud.com··7798 Central AvenueTampaFL33652GRP-6583MEDICARE-ADV-A
ENRENR-1119212026-02-06T07:24:44ZMARIA—KIM1995-11-26UHC-78972-88UNKNOWN5455342079UNKNOWN6098 Baseline RoadAtlantaGA30302GRP-4970MEDICARE-ADV-B
ENRENR-1257312026-01-19T03:12:17ZSTEPHANIE—ROMERO1940-08-03UHC-89724-39•••-••-5292(266) 413-0891NULL8776 Grand AveTucsonAZ85787GRP-5610MEDICARE-ADV-A
ENRENR-1128932026-07-19T17:43:11ZJordan, Jordan——4/4/1940UHC-52030-27•••-••-64702439700jordan.jordan84@outlook.com··4162 Desert Sky Boulevard #622COLUMBUSOhio43234GRP-1639OPTIONS-PPO
ENRENR-1244482026-07-14T04:17:59ZRuthGPalmer··1979-02-26··UHC-18294-15··•••-••-5607(483) 860-0196ruth.palmer@icloud.com906 Pine Drive #180TampaFL33670GRP-6192SELECT-EPO··
ENRENR-1043702026-02-26T20:20:23ZPRIYA—SPENCER1974-11-09UHC-43621-39•••-••-53583186362486—·334 Market StreetDENVERCO80285-9962GRP-4492CHOICE-PLUS-PPO
ENRENR-110229 2026-01-11T20:40:07Z·VICTORIAC.··FOX1985-02-11UHC-83918-84•••-••-2673717-438-7510—·6276 Oak StTampaFL33668GRP-0675OPTIONS-PPO
ENRENR-1056902026-05-16T03:05:16ZTucker, RandyB.—15-03-1981uhc-72020-56•••-••-321212363621547randy.tucker@yahoo.com9264 Mesa Drive Apt 32ORLANDOFL32840GRP-6656OPTIONS-PPO
ENRENR-1028882026-05-11T16:50:21ZGREGX.MCCUY1942-05-15UHC-38818-96•••-••-9728518.279.0967·gregory.mccoy@gmail.com8994 Lake View RoadNashvilletn37293GRP-6001MEDICARE-ADV-A
ENRENR-1079512026-07-01T08:15:56ZWeiRJimenez10/22/1995UHC-80888-58•••-••-2096—N/A··4995 MAIN STREETMESA··AZ85280GRP-0876NAVIGATE-HMO
ENRENR-1326712026-05-12T22:36:42ZKyle··K.Harrison··1947-08-24·UHC-05301-97•••-••-9409+1 469 581 6319N/A3127 Ocean AveTempeAZ85281GRP-5868MEDICARE-ADV-A
ENR ENR-1027222026-01-17T11:08:29ZEVELYN·AFIELDS02/14/1942UHC-07087-25•••-••-18932473025562evelyn.fields@outlook.com7549 Indian School RdPhoenixArizonanullGRP-6680CHOICE-PLUS-PPO
ENRENR-103255 2026-05-25T20:09:26ZAlexis—·Duncan1974-05-28UHC-03463-23•••-••-4871+1 895 271 0364—2572 Union StSAN DIEGOCA·NULLGRP-3565MEDICARE-ADV-B
ENRENR-1265542026-04-08T10:54:13ZALANM.···MURPHY09-05-1973UHC-35889-80•••-••-25449827575alan.murphy@proton.me526 Central AvenueTucsonArizona85793GRP-8379CORE-HMO
ENRENR-109972 2026-09-11T12:48:08ZJacob—Rojas·1939-08-27UHC-05156-98•••-••-2043(759) 853-0750··JACOB.ROJAS38@AOL.COM3308 Bayshore Dr #222ColumbusOH43219GRP-4211MEDICARE-ADV-A
ENRENR-1232732026-02-09T02:53:28ZDanielle—Ferguson1944-04-19UHC-44073-57•••-••-0759467.483.3827N/A3567 Elm StreetSan AntonioTX78209GRP-0219SELECT-EPO
ENRENR-1287062026-08-29T19:35:56ZMurphy, DebraG—06/07/1968uhc-67251-50•••-••-0216498.323.5945debra.murphy@outlook.com5043 Grand AvenueTempeAZ85279GRP-0720CORE-HMO
ENRENR-1399702026-05-31T12:01:37ZSteven—Freeman10/22/1954UHC-21899-72•••-••-93632597895841N/A1021 Lake View RoadPhoenixAZ85085GRP-2168CHOICE-PLUS-PPO
ENRENR-1352872026-01-22T04:36:56Zkevin—gonzallez11/27/43·UHC-63413-26•••-••-0052(490) 381-5909KEVIN.GONZALEZ@HOTMAIL.COM3985 BroadwayMESAAZ85273GRP-0482OPTIONS-PPO
ENRENR-1123452026-03-30T08:02:14ZPierce, Ralph——1962-10-19UHC-49727-75—(206) 344-5570RALPH.PIERCE@HOTMAIL.COM7815 DESERT SKY BOULEVARDNashvilleTN37251·GRP-7342MEDICARE-ADV-A
ENRENR-1387202026-08-23T13:26:23ZVICTORIA—WILSON09/07/91UHC9489407•••-••-1198(349) 929-9962NULL6910 BASELINE ROADJacksonvilleFL32211GRP-8082CHOICE-PLUS-PPO
ENRENR-1165782026-01-05T00:24:30ZVINCENTU.GEORGE1996-04-01UHC-05005-65•••-••-5002(401) 229-4419vincent.george@aol.com1886 Market Street·MiamiFL33147GRP-0549··CORE-HMO
ENRENR-1003192026-07-07T12:17:34ZJOSE—SOTO1957-12-27UHC-35742-05•••-••-0710732.269.0278null3434 Main StreetColumbusOH43290GRP-0126OPTIONS-PPO
ENRENR-1007582026-07-22T21:58:04ZAshley······Sanders1941-09-05UHC-55023-89•••-••-3167945-206-2978ashley.sanders@gmail.com6112 Harbor BoulevardSan Diego·CA92146GRP-0634SELECT-EPO
ENRENR-1012062026-02-05T03:21:46ZTERRYLGIBSON2000-04-08UHC-48195-05•••-••-4443NULLTERRY.GIBSON@YAHOO.COM3151 Forest AveSeattleWashington98157GRP-8796CHOICE-PLUS-PPO
ENRENR-1417812026-06-28T00:26:22ZMartinez, Doris——08/11/1970UHC-96353-84•••-••-9381(883) 716-5670doris.martinez29@proton.me788 MAPLE AVENUEPlanoTX75029GRP-0343CHOICE-PLUS-PPO
ENRENR-1192202026-10-11T05:57:43ZEmily—Boyd1995-12-02UHC-55648-98•••-••-43573022563119NULL3089 Park PlChandler··Arizona-GRP-9420CHOICE-PLUS-PPO
ENRENR-1034212026-08-23T14:43:46ZTaylor, AliceC.—1950-12-28UHC-23398-26•••-••-4021(681) 855-9476N/A··8487 Lake View RoadTucsonAZ85764GRP-5510OPTIONS-PPO
ENRENR-1151212026-04-03T11:48:04ZRUTHB.HICKS1985-02-22UHC-03655-79•••-••-4452+1 364 654 3765ruth.hicks12@aol.com5034 Grand AvenueHoustonTX77090GRP-6686MEDICARE-ADV-A
ENRENR-1280342026-09-09T10:21:01Zsantiago—green1998-04-02UHC-12115-24—813.882.4526·SANTIAGO.GREEN16@YAHOO.COM6800 CANYON RD #512COLUMBUS··OhioN/AGRP-7416CORE-HMO
43,101 rows, page 235 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:40.615Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty