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-1029032026-02-28T19:59:05ZTorres, NicoleI—1982-01-12UHC-96313-13•••-••-3391·6313922199nicole.torres14@aol.com6945 Market StSan DiegoCA92103GRP-0202CHOICE-PLUS-PPO
ENRENR-1414772026-06-17T04:42:46ZPAULN.KNIGHT1963-09-22··UHC-30214-82•••-••-0292·3196975331PAUL.KNIGHT@OUTLOOK.COM2690 Church StGlendale·AZ85329GRP-0781SELECT-EPO
ENRENR-1135272026-01-02T05:50:23ZElijah—James9/11/2004UHC-35910-40•••-••-5586+1 963 850 8164elijah.james@aol.com4449 Valley View DrSAN DIEGOCA92168GRP-5259CORE-HMO
ENRENR-1430742026-07-03T05:21:59ZMatthewCPatterson03/22/1956UHC-86013-44•••-••-6004UNKNOWNmatthew.patterson@outlook.com492 Lake View RoadDallasTX75290GRP-9244NAVIGATE-HMO
ENRENR-1232052026-01-24T19:47:21ZKathryn··—Castro1961-04-17UHC-93759-64•••-••-8522989-727-9029kathryn.castro76@outlook.com8508 INDIAN SCHOOL RDSeattleWA98180GRP-8509·OPTIONS-PPO
ENRENR-1292432026-10-04T14:48:39ZFRANKAPAYNE·1995-07-16UHC-69731-21•••-••-5612+1 722 411 1339null1501 Washington StGlendaleAZ85300GRP-4923MEDICARE-ADV-A
ENRENR-1331062026-03-27T16:53:09Z·Martinez—Sophia3/4/1974··UHC-48031-90•••-••-46266333259663—7835 Ridge RoadSan Antonio··TX78273GRP-3192·CORE-HMO
ENRENR-1012472026-10-18T00:30:40ZAmber—Walker1993-08-19UHC-76429-95•••-••-5527(778) 505-3188AMBER.WALKER77@YAHOO.COM6562 Elm StreetOrlandoFL32846GRP-9282OPTIONS-PPO
ENRENR-1331652026-05-26T00:24:38ZWilliams, Lucia——1996-04-13UHC-28425-11•••-••-999515544000611—7236 Central AveSan AntonioTX78247GRP-6636medicare-adv-b
ENRENR-1290032026-05-15T13:27:16ZPamela—Lucas19701201UHC-69945-87•••-••-1121+1 292 782 8982pamela.lucas34@outlook.com5302 Mesa DrORLANDOFL32874GRP-6042MEDICARE-ADV-A
ENRENR-1194232026-10-09T15:03:46ZCARLOSURAMOS1967-06-90UHC-80608-77•••-••-2750634-762-4987NULL2238 INDIAN SCHOOL RDTempeAZ85255GRP-8156··NAVIGATE-HMO
ENRENR-1215682026-08-18T23:19:11ZRebeccaPArmstrong1941-01-17UHC-21586-51•••-••-4284(608) 843-3273REBECCA.ARMSTRONG49@YAHOO.COM4269 Jefferson AveSan Diegoca92152·GRP-0740MEDICARE-ADV-A
ENRENR-1402282026-01-26T21:44:08ZDorisKEvans1982-09-21UHC-13778-68•••-••-2944(397) 222-9245doris.evans88@icloud.com7374 Central AvenueTucsonAZNULLGRP-3669OPTIONS-PPO
ENRENR-1210422026-02-15T04:30:34Z·DianeAHunter01/01/1964UHC-50127-49•••-••-62138983774826diane.hunter@icloud.com8372 Lake View Road Apt 30PLANOTX75012GRP-7873··OPTIONS-PPO
ENRENR-1006262026-03-08T10:29:30Z·EMILY—OLIVER1996-10-02UHC-20709-15•••-••-4227(445) 379-9601EMILY.OLIVER@PROTON.ME6515 Broadway·PhoenixAZ85045GRP-3718CHOICE-PLUS-PPO
ENRENR-1329232026-04-08T04:48:59ZNATHANW··DOMINGUEZ1983-07-10UHC-21901-45•••-••-2304(317) 957-1630nathan.dominguez@icloud.com5084 Cedar Ln··JACKSONVILLEFL32221GRP-7649CHOICE-PLUS-PPO
ENRENR-1074172026-05-23T21:53:11ZGrace—SinghAug 17, 1980UHC-75793-12•••-••-6333(592) 882-9805GRACE.SINGH17@OUTLOOK.COM3869 CENTRAL AVENUEMiamiFL33192GRP-4191CORE-HMO
ENRENR-1142142026-03-26T19:43:59ZstevenNgren20070526UHC-83463-90··•••-••-7828916-633-9086STEVEN.GREEN80@ICLOUD.COM17 Oak StPlanoTX-GRP-8644MEDICARE-ADV-B
ENRENR-1133972026-03-11T08:05:57Z WilliamHRobinson··1980-09-06UHC-37175-59•••-••-3976(221) 204-0597—1200 Valley View DrNashvilleTN37228-4649GRP-0645CHOICE-PLUS-PPO
ENRENR-1229542026-01-19T09:33:04ZJEAN—REED1949-09-15UHC-11553-95•••-••-4126+1 357 920 7839jean.reed@icloud.com5322 Sage Court·FresnoCA93714GRP-1859NAVIGATE-HMO
ENRENR-1370552026-10-07T23:17:34ZDanielle—Gray19-07-1950UHC-63137-19•••-••-8787+1 841 969 5469NULL9044 Lake View RdNashvilleTN37242GRP-7375·MEDICARE-ADV-A
ENRENR-1314032026-04-27T05:22:31ZKYLE—CRUZ1947-05-02UHC-16666-64•••-••-0721(281) 292-8045kyle.cruz3@hotmail.com2342 CHURCH STJacksonville··FL32226GRP-8315MEDICARE-ADV-A
ENRENR-1119842026-08-11T13:40:29ZKeith—George1939-03-06UHC-45910-24•••-••-7005816-988-5478KEITH.GEORGE@OUTLOOK.COM167 Elm StreetAtlanta··GA30399GRP-3488MEDICARE-ADV-A
ENRENR-102698 2026-08-20T03:09:09ZJUAN·Q·RILEY1948-01-60·UHC-79569-94•••-••-60049857441546JUAN.RILEY@ICLOUD.COM4389 Canyon RdTAMPAFL33697-4312GRP-3628options-ppo
ENRENR-1270252026-01-02T06:20:13ZWilliamson, JesseA—1961-10-13·UHC-57888-13•••-••-69186374045349jesse.williamson@proton.me5866 PINE DRIVEAustinTX78771GRP-0926··NAVIGATE-HMO
ENR ENR-1040542026-08-10T09:32:54ZJoseERichardson19600827UHC-61622-11•••-••-4365+1 604 618 6708jose.richardson78@icloud.com9388 Cedar LnNashvilleTN37275·GRP-3840NAVIGATE-HMO
ENRENR-1094182026-07-22T23:45:15ZHENRY—ROBERTS1969-10-21UHC-17992-75•••-••-727016856078523UNKNOWN7955 SAGE CTChandlerAZ85285-7515GRP-9318SELECT-EPO
ENRENR-1404092026-02-16T04:12:31Z·Bryan—Carroll2002-08-20UHC-98480-46•••-••-92213246018123·bryan.carroll49@gmail.com5076 Indian School RoadJacksonvilleFL··32221GRP-5135SELECT-EPO
ENRENR-1309482026-02-04T09:06:24ZWilson, Goria——19841123UHC-54456-13•••-••-98519643140894··gloria.wilson@gmail.com4217 River RoadAustinTX78785GRP-5938MEDICARE-ADV-B
ENRENR-138565 2026-10-06T19:15:18ZMorgan, Dennis——Mar 2, 1955UHC-75155-83•••-••-90594102844841null7311 Washington StGlendaleArizona85386GRP-3982NAVIGATE-HMO
ENRENR-1053092026-05-07T02:58:38ZAbbbyJ.·Andrews1890-05-16UHC-48013-48•••-••-3305·8794888751—499 Lincoln WayMinneapolisMNUNKNOWNGRP-9367MEDICARE-ADV-A
ENRENR-1175442026-07-02T08:35:51ZAnthonyG.LeeN/AUHC3311368•••-••-0825(787) 465-3933ANTHONY.LEE65@HOTMAIL.COM··276 Hillcrest Road Apt 13CHARLOTTENC28262GRP-2977CORE-HMO
ENRENR-138905 2026-03-08T23:45:46ZZACHARYD·ELLISJun 7, 2001UHC-48764-80•••-••-9048N/Azachary.ellis@icloud.com··9868 Forest AvenuePlanoTX75029GRP-1890OPTIONS-PPO
ENRENR-1257162026-06-20T20:13:33ZABIGAIL—BLACK2003-09-09UHC-48689-98•••-••-81668405843147ABIGAIL.BLACK88@OUTLOOK.COM3527 PINE DRIVE·ScottsdaleAZ85270·GRP-2932·SELECT-EPO
ENRENR-140371 2026-04-10T09:46:55ZFRANK—ALLEN2007-06-15UHC-12886-83null13366230804frank.allen@aol.com770 Sage CourtLas VegasNV89139GRP-9401CORE-HMO
ENRENR-1061692026-01-19T16:16:10Z·VincentBContreras1992-05-18UHC-10042-28•••-••-8369·(920) 216-5594—5174 Forest AveTucsonAZ85732GRP-6992MEDICARE-ADV-B
ENRENR-1146692026-08-07T20:39:59ZAndrea··E.Jacobs10/23/1953UHC-76822-98•••-••-8418(957) 602-0665—3518 Union StNASHVILLETN37225GRP-5500SELECT-EPO
ENRENR-1123322026-08-02T15:43:42ZAlexisZArmstrong·1959-01-26UHC-76727-59•••-••-0350—alexis.armstrong61@hotmail.com8444 RIDGE RD #344FresnoCA93723GRP-1662CHOICE-PLUS-PPO
ENRENR-1138552026-09-27T08:41:52ZCHRISTOPHER····PATTERSON03/24/05UHC5761754•••-••-38717755465106··UNKNOWN6861 GRAND AVEJacksonvilleFL32221GRP-1704OPTIONS-PPO
ENRENR-1263472026-01-27T03:28:31ZDebrra—Colemannull··UHC-55489-25•••-••-9215·545-281-7895debra.coleman@hotmail.com6947 Ocean Ave Apt 28TempeAZ85277GRP-7972··CHOICE-PLUS-PPO
ENRENR-1179632026-01-07T17:25:19Z·Frank—·Austin1964-07-03UHC-35904-15•••-••-9212·16456536564frank.austin59@icloud.com93 OAK STREETAUSTINtx78751GRP-7306SELECT-EPO··
ENRENR-1026242026-06-25T18:46:15ZDEBRAB.MORRIS1964-10-10UHC-26501-75•••-••-4325N/Adebra.morris73@icloud.com8802 GRAND AVESan DiegoCA92102GRP-7410MEDICARE-ADV-A
ENRENR-1094822026-06-16T19:52:11ZSusan—Estrada1958-05-10·UHC6524752•••-••-6060835-609-4075··susan.estrada@yahoo.com··UNKNOWN——NULLGRP-2504·CHOICE-PLUS-PPO
ENR ENR-1350002026-09-07T14:16:27ZEric—Fosteer1953-07-26·UHC-04955-08•••-••-6781358-571-8910eric.foster87@gmail.com4997 Elm StTempe··Arizona85241·GRP-9005NAVIGATE-HMO
ENRENR-1192182026-08-12T22:54:51ZPamela···Pena17-10-2006UHC-79279-68N/A704.384.6128pamela.pena@icloud.com6711 Mesa DrHoustonTX77068GRP-4278SELECT-EPO
ENRENR-1012972026-03-27T06:38:23ZKennethIWong06/21/94··UHC-77202-56•••-••-5574—KENNETH.WONG96@GMAIL.COM6751 Central AveChandler·Arizona·85250-4574·GRP-1096CORE-HMO
ENRENR-1073302026-02-04T22:10:36ZMARIANA··—GRAHAMMay 27, 1963UHC-39527-55•••-••-7439557.657.6272mariana.graham@hotmail.com2047 Sage CourtCHARLOTTENC28243GRP-1150SELECT-EPO
ENRENR-1342662026-09-02T15:38:19ZTurner, Frank L——1989-06-15···UHC-62017-64•••-••-4091(362) 744-7334frank.turner90@proton.me9015 Market StSacramentoCA··95801GRP-3026NAVIGATE-HMO
ENRENR-1123982026-06-10T11:53:57ZHarper, Bobby——1991-12-14UHC-24069-93null·270-278-4382BOBBY.HARPER@AOL.COM516 PARK PLACEFresnoCA—GRP-8385MEDICARE-ADV-A
ENRENR-1362872026-05-27T03:18:29ZLawrence, BradleyE—1991-06-06UHC-86126-65null(823) 532-3645—4747 DESERT SKY BLVDJacksonvilleFLNULLGRP-0476SELECT-EPO
43,101 rows, page 229 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.609Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty