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-1192872026-05-22T13:57:50ZEmily··Alvarado1961-09-28UHC-66506-48•••-••-7237(830) 485-1618N/A7977 RIVER RDGlendale·AZ85328GRP-0347·MEDICARE-ADV-B
ENRENR-1283982026-07-29T00:03:23Z JoseAMcCoy07/07/91UHC-05379-73•••-••-2616N/AJOSE.MCCOY@GMAIL.COM2234 OCEAN AVEColumbusOH43233GRP-0519CHOICE-PLUS-PPO
ENRENR-1374192026-09-26T15:35:09Zgabriel L—snyder··01/16/01··UHC-62600-65•••-••-7376457-581-3162gabriel.snyder@aol.com8354 River RoadScottsdaleAZ85238GRP-3638MEDICARE-ADV-B
ENRENR-1422042026-05-24T11:16:53ZDianeN··Austin04/23/1964UHC-24235-08•••-••-7866701-671-6236DIANE.AUSTIN35@OUTLOOK.COM4487 Mountain View DrMesaAZ85227GRP-6356MEDICARE-ADV-B··
ENRENR-1226612026-02-24T03:22:45ZCarlosGTorres1970-09-14UHC-33962-64•••-••-1175971-370-8636—1314 Hillcrest RdMesaAZ85220GRP-9904··NAVIGATE-HMO
ENRENR-1300142026-05-16T09:33:34ZSUSAN—WEBB··1952-10-06UHC-58050-50•••-••-00804289285824SUSAN.WEBB74@PROTON.ME2347 LINCOLN WAYEden Prairie··MN55390GRP-2301NAVIGATE-HMO··
ENRENR-1158492026-01-30T05:27:25ZYukiEHunter08-10-1998UHC4333698•••-••-5040889-605-7324yuki.hunter85@aol.com730 Forest AvenueFresnoCA93780-5053GRP-2913CORE-HMO
ENRENR-1382262026-07-03T00:40:09ZBrittany—Robertson·1986-03-12UHC-25847-13•••-••-75278106877112brittany.robertson47@yahoo.com8443 Camelback RoadOrlandoFL32814GRP-1522MEDICARE-ADV-B
ENRENR-1163652026-09-24T06:17:38ZdorothyOphillipsApr 4, 1950UHC-59853-62•••-••-02138883289358dorothy.phillips@outlook.com4321 Jefferson AveDENVERCO80200GRP-9797CHOICE-PLUS-PPO
ENRENR-1381902026-06-27T08:21:46ZJohn—FergusonNov 22, 1972UHC-54117-64•••-••-9563984-711-0020N/A9103 Apache BoulevardSan AntonioTX78235GRP-2427MEDICARE-ADV-A
ENRENR-1403782026-02-12T23:36:53ZBrendaPGrant1974-07-20UHC-59470-91•••-••-80813353922803·brenda.grant@outlook.com6156 Washington StChandlerAZ85211GRP-1925SELECT-EPO
ENRENR-1339172026-04-25T10:05:29ZBETSYLJORDAN1979-02-15UHC-64254-45•••-••-8160(281) 261-6714ELIZABETH.JORDAN@ICLOUD.COM7409 Apache Blvd #439Las VegasNV89180GRP-1483OPTIONS-PPO
ENRENR-1276782026-08-01T16:49:41ZRay, BrendaM—19800509UHC-99155-76•••-••-2438(257) 214-2905brenda.ray@hotmail.com9660 ELM STMesaArizona85232GRP-3612OPTIONS-PPO
ENRENR-1077862026-09-03T19:28:11ZREBECCAQROBINSON09/09/1980UHC-71751-18•••-••-150312422418592—3146 Lincoln WayOrlandoFL32873GRP-5079NAVIGATE-HMO
ENRENR-1083122026-04-01T08:56:49ZkaylaP.dunn1977-12-24UHC-36255-45•••-••-50928398823725NULL4401 RIDGE RDLos AngelesCA·90082-4912GRP-9743OPTIONS-PPO
ENRENR-1422082026-05-28T08:32:09Z OWENSP··ELIZABETH1949-09-17UHC8134030•••-••-6419854.871.1123··163 Oak StHOUSTONTX··77026GRP-8882OPTIONS-PPO
ENRENR-1405742026-10-05T17:54:22ZOwens, Sofia—····19720815··UHC-02113-98•••-••-9135NULLsofia.owens@proton.me3376 CENTRAL AVEDenverCO80219GRP-1788CHOICE-PLUS-PPO
ENRENR-1406872026-08-23T11:24:49ZKARENITHOMAS2005-11-05UHC-47494-97null6962268··UNKNOWN··6718 Mesa DriveHoustonTX77082GRP-7804CHOICE-PLUS-PPO
ENRENR-1038262026-06-18T23:05:51ZAlexanderQ.Hanson08/25/1958···UHC-67625-60•••-••-81136708760966··5407 JEFFERSON AVETampaFL33682GRP-8358core-hmo
ENRENR-1029612026-02-05T02:38:32ZDIANA T—BENNETT08/21/02UHC-57282-50UNKNOWN734-537-1973DIANA.BENNETT91@AOL.COM7975 Church StMinneapolisMN55435GRP-8371CORE-HMO
ENRENR-1128862026-01-13T18:15:22ZJulieG··Dixon1995-10-04UHC-86616-94-5232900144—5575 CAMELBACK ROADHoustonTX77001-7680GRP-4747CHOICE-PLUS-PPO
ENRENR-1176482026-02-15T12:28:31ZEdwards, BarbaraC.—1951-10-01uhc-91524-18•••-••-5287(869) 966-4205barbara.edwards84@proton.me4467 OCEAN AVE·SeattleWA98174GRP-7778·NAVIGATE-HMO
ENRENR-1410302026-08-02T08:57:11ZRaymondCFreeman·1953-01-23UHC-96816-88•••-••-9299482-364-8363raymond.freeman@icloud.com3667 Valley View DrTempeArizona85211GRP-6197NAVIGATE-HMO
ENRENR-1338012026-08-10T20:38:26ZJOSHUAV.RIOS1968-05-18UHC-07268-37•••-••-9041519-957-7640joshua.rios31@hotmail.com6349 Indian School Road Apt 35CHARLOTTENC28263GRP-6889OPTIONS-PPO
ENRENR-1128512026-03-24T20:25:57ZCharlotte F.—Stevens1953-09-18UHC-53541-53•••-••-50717462708052charlotte.stevens13@gmail.com1313 Ridge RoadGilbert·AZ85247GRP-6305SELECT-EPO
ENRENR-124434 2026-05-17T21:59:19ZPRIYA····SANDOVAL1980-02-04UHC-19727-45··•••-••-63913099280704PRIYA.SANDOVAL@PROTON.ME5492 Jefferson AvenueChandlerAZ85237GRP-6267SELECT-EPO
ENRENR-1162152026-03-15T11:01:54ZCHARLOTTE··—LAWSON2/25/1952UHC-42796-35•••-••-5951836-201-0634CHARLOTTE.LAWSON@GMAIL.COM4101 RIVER RDFresnoCA93700GRP-7214CHOICE-PLUS-PPO
ENRENR-1230732026-07-19T08:52:52ZAUSTIN—GREEN1938-03-12UHC-95563-02•••-••-6991-austin.green@outlook.com676 River RoadScottsdaleAZ85281GRP-7176·MEDICARE-ADV-A
ENR ENR-1096722026-08-15T00:00:33ZJuanM.··Pena1994-04-26UHC-44287-88•••-••-96153054839241JUAN.PENA@OUTLOOK.COM1149 Oak StMesaAZ85242GRP-1318··CHOICE-PLUS-PPO
ENRENR-1256182026-04-23T10:37:36Z·Willie—Garcia1939-05-09··UHC-41138-39•••-••-05335952969080—2073 Church StSacramentoCA95855GRP-3309··SELECT-EPO
ENRENR-1285122026-07-09T19:56:01ZHANNAH—BROOKS1990-02-06UHC-39010-28•••-••-6969633-823-4325HANNAH.BROOKS@HOTMAIL.COM137 Harbor BoulevardSan DiegoCA92168GRP-5107CORE-HMO
ENRENR-1373262026-08-02T18:19:16ZMATEOC.PARK04/13/2001UHC-21681-06•••-••-2832874-354-7087mateo.park@icloud.com5295 RIVER ROADDenverCO80259·GRP-4340CHOICE-PLUS-PPO
ENRENR-1161062026-01-04T03:25:37ZMatthews··Ahmed1947-05-11UHC-67757-69•••-••-5769—·ahmed.matthews@proton.me2473 OAK STTAMPAFLNULLGRP-8118CORE-HMO
ENRENR-1392132026-08-26T12:05:26ZChen, Joe——1947-11-23UHC-65483-46•••-••-7206271-484-2503—3130 Camelback RoadEden PrairieMinnesota55358GRP-0476SELECT-EPO
ENRENR-1193992026-02-01T03:09:41Z ·nathanT.watkins19820926UHC-78419-09•••-••-8779(856) 379-0874nathan.watkins60@hotmail.com7109 CENTRAL AVEPhoenixAZ85034GRP-8228SELECT-EPO
ENRENR-1042722026-03-03T21:27:26ZARTHURMHALL11/24/1938UHC8761137·-2655323170ARTHUR.HALL@YAHOO.COM6568 Cedar LnChandlerArizona··85245GRP-8109OPTIONS-PPO
ENRENR-1098702026-05-14T03:35:21ZALICEL.YANG1997-02-18UHC-22171-25··•••-••-845012207826753alice.yang@outlook.com··3250 Forest Ave #936SacramentoCA95866GRP-4470·CORE-HMO
ENRENR-1278342026-08-12T15:53:17ZMichelle··R··Price08/09/83UHC-08987-60null+1 962 400 8270null5625 PINE DRGlendaleArizona85359GRP-6200CORE-HMO
ENRENR-1233152026-01-22T12:51:53Z CamilaNAndrews1983-02-08·UHC-90086-43•••-••-37506097465CAMILA.ANDREWS91@GMAIL.COM6518 Mesa DrHoustonTX77024GRP-0695NAVIGATE-HMO
ENR ENR-1332662026-04-06T17:34:25ZSharonB.Watson1967-08-23UHC-84466-70•••-••-98833796979011SHARON.WATSON@YAHOO.COM6446 MAIN STDallasTX75297GRP-9223MEDICARE-ADV-B
ENRENR-1201012026-02-03T03:31:32ZDORIS—LEE··Mar 7, 1970·UHC2922543-4115754918doris.lee@proton.me5764 Lake View RoadCharlotteNC28211GRP-9815OPTIONS-PPO
ENRENR-1417902026-01-24T04:53:52ZLaurenPTomas10/12/1956UHC-69988-20•••-••-9551522-740-5024lauren.thomas36@yahoo.comnull··—NULLNULLGRP-3405MEDICARE-ADV-A
ENRENR-1008812026-01-03T03:36:25ZRUUTH—MILLERN/AUHC-03583-56•••-••-25125207015238—1269 Canyon RoadSacramentoCA95879GRP-0717SELECT-EPO
ENRENR-1265352026-04-29T22:33:05ZHiroshi—Johnson12/14/1952·UHC-05965-18•••-••-7510533-718-3772HIROSHI.JOHNSON77@HOTMAIL.COM5623 RIVER RDJACKSONVILLEFL32217GRP-4016MEDICARE-ADV-B
ENRENR-1261382026-05-27T11:06:34ZEircH.SnyderJan 27, 1971··UHC-51431-79··667-680-3896eric.snyder@aol.com4671 UNION STREETSCOTTSDALEAZ85283GRP-4118CHOICE-PLUS-PPO
ENRENR-1405512026-07-24T18:21:38ZTurner, ScottV—21-05-1951UHC2965632··•••-••-1718434-583-9565SCOTT.TURNER85@YAHOO.COM3002 Lake View Road Apt 35TampaFL33668GRP-6696··NAVIGATE-HMO
ENRENR-1189662026-03-30T17:42:30ZDENISE—JACKSON1955-09-27UHC5100090•••-••-5789(653) 872-8958DENISE.JACKSON64@AOL.COM··6184 Union Street #847CharlotteNC28282GRP-3028MEDICARE-ADV-A
ENRENR-1147662026-06-29T05:52:31ZZACHARYH.THOMPSON1959-02-24—•••-••-040318112505484ZACHARY.THOMPSON42@PROTON.ME320 WASHINGTON STTampaFL···33695GRP-7988··CORE-HMO
ENRENR-1107362026-06-23T03:11:38ZPadilla, Paul——1957-12-06UHC-43955-02•••-••-2179(653) 578-4633paul.padilla24@proton.me—NULL—N/AGRP-5977MEDICARE-ADV-A
ENRENR-1092862026-07-11T18:22:06ZDABORAH—ROBERTS4/2/1975UHC-29217-76•••-••-0023372-631-1947deborah.roberts@yahoo.com9278 Meadow LaneSan AntonioTX78253GRP-3018MEDICARE-ADV-B
43,101 rows, page 71 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.704Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty