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
ENR ENR-1230082026-03-08T09:41:48ZCAROLYNU.CARTER1986-05-27UHC-89438-45———9813 SUNSET BLVDSacramentoCA95811GRP-3031CHOICE-PLUS-PPO
ENRENR-1000602026-06-17T05:15:49ZKaylaK.Chapman19441214UHC-36701-02•••-••-6920·678-840-8311-713 Harbor BoulevardScottsdaleArizona85255GRP-9566MEDICARE-ADV-B
ENRENR-1363152026-04-10T00:24:49Znatalie—cooper·Nov 25, 1985UHC-86630-74•••-••-0059618-731-7542natalie.cooper@outlook.com8026 SUNSET BOULEVARDColumbusOH43200GRP-4622NAVIGATE-HMO
ENRENR-118527 2026-06-13T03:23:56ZRobert Z—·Jensen2007-07-06UHC-59264-90•••-••-8892+1 496 255 1741ROBERT.JENSEN@AOL.COM396 Apache BoulevardNASHVILLETN37228GRP-5845MEDICARE-ADV-B
ENRENR-1261562026-09-16T05:44:49ZJeffrey—Welch1951-02-23UHC-71131-82•••-••-6110UNKNOWN—441 Ocean AvenueCharlotteNC28264-1204GRP-6409MEDICARE-ADV-B
ENRENR-1316692026-09-07T23:28:52ZGregory—Lane1987-09-19UHC-18658-29•••-••-93307678033GREGORY.LANE5@HOTMAIL.COM9210 Lincoln WayOrlandoFL32824GRP-4204CHOICE-PLUS-PPO
ENRENR-1160182026-04-20T01:50:18ZDebNHarper9/28/1973UHC-63588-98•••-••-6847N/A—4799 River RoadCharlotteNC28291-5756GRP-2891·CORE-HMO
ENRENR-1279112026-10-02T22:54:38ZMARILYNYSOTO1943-08-15UHC-68446-58··•••-••-39814214375553marilyn.soto@outlook.com··NULLN/A··N/AN/A··GRP-8375CORE-HMO
ENRENR-1243812026-02-03T04:43:00ZRalphUKnight1995-10-12UHC-94711-16•••-••-6213(923) 967-8910ralph.knight@icloud.com7040 PALM DRIVE Apt 2DenverCOnullGRP-6349··OPTIONS-PPO
ENRENR-1013322026-06-03T07:03:10Z frances—williamson1987-05-23UHC-65634-96•••-••-1342511-634-9753FRANCES.WILLIAMSON@ICLOUD.COM128 Desert Sky BlvdMiamiFL33180GRP-9228OPTIONS-PPO
ENRENR-142502 2026-06-18T19:40:38Z·JACK····—7/24/1970UHC-08046-24•••-••-2410(816) 744-2788jack.clark@hotmail.com5407 Camelback RoadDenverCO80236GRP-0226CHOICE-PLUS-PPO
ENRENR-1274522026-02-08T21:30:11ZEvelyn—·Franklin11/10/1992UHC-62449-06•••-••-9119+1 278 280 4867EVELYN.FRANKLIN@AOL.COM1489 Hillcrest RdEden PrairieMN55380GRP-3421CORE-HMO
ENR ENR-1219262026-04-25T01:29:23ZAhmedU··Murray1963-10-28UHC-26335-97•••-••-6284623-444-5280ahmed.murray@yahoo.com4448 Grand Avenue··ColumbusOH43239··GRP-0129·OPTIONS-PPO
ENRENR-1039582026-02-07T13:22:40ZSANDRAZ.RIVERA1996-09-23UHC-18302-61•••-••-6386460.721.7878··sandra.rivera29@hotmail.com687 Central AvePlanoTX75058·GRP-3019CHOICE-PLUS-PPO
ENRENR-1233662026-07-04T03:11:40ZCHARLESA.··RIHARDSON·1963-11-23UHC-92117-87•••-••-3000334.624.8187··—6611 Ridge Rd Apt 6·Los AngelesCA90036GRP-9739·CORE-HMO
ENRENR-1371392026-07-05T14:41:16ZJohnson, James——1955-03-03UHC-45826-69NULL4376326N/A4782 MAIN STREETSAN ANTONIOTX78236GRP-6455·core-hmo
ENRENR-1052122026-03-03T05:11:30ZPHILIPNMEDINA2003-02-28UHC-63408-18•••-••-77865850150PHILIP.MEDINA56@OUTLOOK.COM26 BROADWAYHoustonTX77040GRP-2053MEDICARE-ADV-A
ENRENR-1264602026-09-17T15:41:43Zjanet—harris1998-10-06UHC-03351-82•••-••-2795+1 444 618 6400janet.harris@yahoo.com1529 HIGHLAND AVETempeAZ85248GRP-0841··SELECT-EPO
ENRENR-1066042026-06-01T09:16:43Zcatherine—alexander1944-04-27UHC-81631-23•••-••-9460757-805-0801—8711 BASELINE ROADNASHVILLETN·37267GRP-7576MEDICARE-ADV-A
ENRENR-1211362026-08-24T20:29:07ZDonald—Matthews1995-02-05UHC-95205-05•••-••-074317294850231donald.matthews@hotmail.com1183 Grand AveEden PrairieMinnesota55352GRP-7958·NAVIGATE-HMO
ENRENR-1410842026-01-05T16:52:47ZSTEPHANIE—BROWN1980-11-02UHC-58523-40•••-••-4153662-560-5636—7753 Desert Sky Blvd Apt 1JacksonvilleFL32297GRP-9462CORE-HMO
ENRENR-1403302026-05-07T11:35:46ZLauren—Peterson1/26/2006UHC-33510-48•••-••-4124958.729.0046null3468 Church StFresnoCalifornia93784··GRP-9086··MEDICARE-ADV-A
ENRENR-1226722026-09-12T07:48:52ZAshleyWSynder10/24/1941UHC-84216-89•••-••-0072·UNKNOWNashley.snyder@gmail.com3146 Sage CourtNashvilleTN37209GRP-9956CORE-HMO
ENRENR-1101482026-03-08T08:39:16Z LARRY—BAILEY1965-05-13··UHC-96579-31•••-••-0123+1 794 801 6128LARRY.BAILEY@HOTMAIL.COM6700 Highland AvenueMiamiFL33116GRP-7157OPTIONS-PPO
ENRENR-1050972026-06-08T14:37:11ZJones, SofiaQ··—·2001-11-04UHC-63162-84•••-••-0141901-735-0749sofia.jones76@proton.me4940 CANYON ROAD··JacksonvilleFL32221GRP-6003MEDICARE-ADV-B
ENRENR-1026492026-10-17T23:48:44Z———1980-06-16uhc-06610-99•••-••-8481(398) 832-7616ann.burns75@aol.com4070 Apache BlvdJacksonvillefl32247GRP-4195OPTIONS-PPO
ENRENR-1069732026-10-15T10:32:19ZBobbyIGonzalez05/01/07UHC-49663-87•••-••-6850(599) 462-3578UNKNOWN6407 Main StNashvilleTN37231GRP-1461MEDICARE-ADV-A
ENRENR-1095582026-03-03T10:32:15ZChavez, Megan——1992-11-03UHC-87398-86•••-••-90028858132860NULL6723 Grand AvenueDallas··TX75245GRP-5545MEDICARE-ADV-A
ENRENR-1342062026-08-20T16:39:57ZRachelW··Wagner08/17/1998UHC-27206-41•••-••-93599171752rachel.wagner@gmail.com·6652 Meadow LaneEden Prairiemn·55337GRP-5637·MEDICARE-ADV-B
ENRENR-1000952026-08-03T17:28:42ZEddieC.Harrison1952-02-27UHC-39886-31•••-••-39545915060791EDWARD.HARRISON@ICLOUD.COM2915 MARKET STCharlotteNC28225GRP-5407CHOICE-PLUS-PPO
ENRENR-1135762026-04-07T13:56:41ZJessicaMSoto·1971-04-14UHC-25170-42•••-••-9158—jessica.soto@aol.com295 SPRING STOrlandoFL32848GRP-5720NAVIGATE-HMO
ENRENR-1226372026-09-20T14:28:27ZLuisGJohnson07/02/1965UHC0563979•••-••-56844345598784luis.johnson@outlook.com6988 Valley View DrJacksonvilleFL—GRP-1530NAVIGATE-HMO
ENRENR-1161542026-07-31T16:07:49ZJamesEWatkinsN/AUHC-32087-19•••-••-05405792920257NULL4317 Union StTucsonArizona-GRP-3504OPTIONS-PPO··
ENRENR-138365 2026-04-14T15:41:03ZGEORGEQHOWELL03/09/84UHC-38278-48•••-••-1478(261) 897-4828george.howell18@gmail.com9286 BASELINE RDMesaAZ85207-3966GRP-9778CORE-HMO
ENRENR-1296282026-08-12T20:10:32ZThomas—Day1944-02-21UHC-61347-18•••-••-43907829125892thomas.day@yahoo.com1025 Mesa DriveMIAMIFL33171GRP-0171NAVIGATE-HMO
ENRENR-1363492026-03-26T19:03:56ZRonaldC.Hernandez19631228UHC-59399-26•••-••-81148649458497RONALD.HERNANDEZ77@YAHOO.COM1684 Union StreetTempeAZ85252-8559GRP-2903MEDICARE-ADV-A
ENRENR-1365922026-05-19T16:03:44ZPamela—Thompson21-01-1997UHC-25513-16•••-••-23864082124357—4065 Valley View DriveGlendaleAZ85353GRP-1522OPTIONS-PPO
ENRENR-1352822026-03-24T23:07:24ZJamesR·Ross1955-08-13UHC5503239—840-410-5451james.ross@proton.me9009 Market StHoustonTX77048GRP-2036CORE-HMO
ENRENR-1264622026-06-05T16:24:21ZIsabella··—Barnes2006-03-11UHC-66242-93•••-••-0688408-671-5531NULL1853 Oak StreetMesaAZ—GRP-8905MEDICARE-ADV-A
ENRENR-1316652026-04-26T19:33:05ZASHLEY··JORTEGA2007-06-20UHC-13854-74•••-••-3117602-424-7449N/A1726 GRAND AVENUE··San DiegoCA92170GRP-2677MEDICARE-ADV-B
ENRENR-1371282026-06-22T03:53:22ZMARI—LITTLEJun 21, 1941UHC-24075-34•••-••-2894420-917-8852··N/A1334 Harbor BoulevardPhoenixAZ—GRP-7733··MEDICARE-ADV-A
ENRENR-1041252026-05-21T15:47:54ZHeaherJ.HudsonDec 23, 1979UHC-98182-23•••-••-9472—heather.hudson21@aol.com1662 Baseline RdScottsdaleAZ85253GRP-6732OPTIONS-PPO
ENRENR-1407852026-02-26T08:31:35ZAlexander, BobbyS—1979-07-27UHC-60752-33•••-••-51016029723371bobby.alexander61@yahoo.com4516 BAYSHORE DRORLANDOFL32858GRP-4616CORE-HMO
ENRENR-1173032026-09-19T01:13:30Znathan—fernandez3/22/1993UHC-35679-26•••-••-5277(591) 992-3960nathan.fernandez23@proton.me5278 River Rd·JACKSONVILLEFL32247GRP-9436SELECT-EPO
ENRENR-1321232026-02-16T15:44:51ZRussellTGeorge2005-01-25··UHC-35845-96UNKNOWN(517) 532-7379RUSSELL.GEORGE16@YAHOO.COM613 Apache BoulevardCharlotteNCN/AGRP-6833NAVIGATE-HMO
ENRENR-1265872026-09-24T12:54:47ZRUTHMPIERCE2002-09-13UHC-19964-20•••-••-2983UNKNOWN··640 Pine DriveNashvilleTennessee37252GRP-7654CHOICE-PLUS-PPO
ENRENR-1312022026-05-14T10:15:28Zheather—hicks1952-03-28UHC-56539-60•••-••-4355—heather.hicks34@yahoo.com7765 Elm StreetDallasTX75298GRP-3381SELECT-EPO
ENRENR-1092382026-04-03T06:17:19Zalexander—yang2004-01-15UHC-49686-06•••-••-1960·235.651.2565-9877 Lake View RdSEATTLEWashington98168GRP-7038MEDICARE-ADV-B
ENRENR-1084372026-05-16T18:29:55ZAshleyB.Mason1971-10-05UHC4554239•••-••-02126759693063NULL··8239 Mesa Dr Apt 7Los AngelesCA90068GRP-9486OPTIONS-PPO
ENRENR-1179502026-08-16T12:37:16ZHiroshiHVega1979-07-03··UHC-90314-71•••-••-7530nullhiroshi.vega60@icloud.com4291 Valley View DrColumbus··OH43275GRP-3467··NAVIGATE-HMO
43,101 rows, page 319 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:43.613Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty