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

All sources, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
ENRENR-1267032026-07-19T21:36:52Z·Gregory—Smith1987-10-09UHC-05181-14•••-••-8210402-660-4922null2142 Indian School RoadCharlottenc28207GRP-0109SELECT-EPO
ENRENR-1133922026-07-24T20:00:08ZHenryNMcDonaldMay 19, 2007UHC-49111-77•••-••-1754(700) 779-5185henry.mcdonald85@aol.com2866 Grand AveOrlandoFL32829GRP-9154MEDICARE-ADV-B
ENRENR-1354122026-08-11T14:13:51ZTerryV.Le1984-03-25UHC-38720-12··•••-••-12472108168784terry.le42@aol.com825 Union StDenverCO80279GRP-4896NAVIGATE-HMO
TPATPA-540802026-05-31T22:41:11ZEthan—·Dixon14-11-1987N/A——null7408 Desert Sky BlvdSeattleWashington98143GRP-7479NAVIGATE-HMO
CLMCLM-4320262026-08-28T20:56:33ZjoseKcarpenter1943-04-07UHC-84499-49•••-••-5960NULLnull4048 WILLOW CT Apt 2PlanoTX75049GRP-0512MEDICARE-ADV-B
TPA TPA-511742026-10-04T04:23:44ZChris—Fox19500428--NULLCHRISTOPHER.FOX14@ICLOUD.COM3691 Hillcrest RoadATLANTAGA30320GRP-4425-
ENRENR-110504 2026-05-06T21:10:09ZWeaver, Juan——·1948-10-15UHC-49719-35•••-••-7229329.502.6983juan.weaver98@icloud.com9101 Harbor BoulevardHOUSTONTX77021GRP-5110·SELECT-EPO
CLMCLM-4251582026-07-12T16:17:53ZVictoria—Patel08-09-1938UHC5640053NULL218.637.4578-4249 Maple AvenueOrlandoFL32819—NAVIGATE-HMO
CLMCLM-4083882026-05-24T12:28:30ZCHRISTOPHERSANDREWS·19911014-NULLNULL—·-N/AUNKNOWNUNKNOWN-CHOICE-PLUS-PPO
TPATPA-611532026-06-12T07:50:47ZAlanXWheeler1941-03-09—··NULLUNKNOWN——N/AnullNULL·NULL
ENRENR-1181602026-01-17T11:07:30ZAMBER··—BYD1950-04-27UHC-22070-97•••-••-7995(466) 515-2046UNKNOWN93 Park PlLos AngelesCA90092·GRP-5949MEDICARE-ADV-A
CLMCLM-4167112026-05-09T11:41:48ZAmber—Graene07/14/65UHC-66959-32•••-••-8776—-5664 MARKET STGLENDALEAZ·85302GRP-8968—
ENRENR-1423292026-05-09T12:31:38ZRonaldR.Ford19631011UHC-97301-31•••-••-21013682391657N/A137 Hillcrest RoadAtlanta·GA30351GRP-7807·CHOICE-PLUS-PPO
ENRENR-1313432026-04-30T16:25:54ZIsabellaIEdwards19480923UHC-90465-53•••-••-01328766377116··ISABELLA.EDWARDS87@ICLOUD.COM2003 Washington StTucsonAZ85704GRP-2332OPTIONS-PPO
ENRENR-1372792026-08-06T04:51:08ZMarilynNVazquez1941-05-20UHC-02087-63•••-••-06807948827844UNKNOWN8011 Meadow LaneGilbertAZ85241GRP-1165CHOICE-PLUS-PPO
ENRENR-1390782026-09-05T16:21:57Z ZacharyLReyes1977-04-28UHC-41213-20•••-••-901019016106841-2144 Church Street Apt 15MiamiFL33175GRP-2374CHOICE-PLUS-PPO
CLMCLM-4142972026-01-30T20:38:23ZSarah—·Tucker03/06/98UHC-97286-29—836-955-0609—·3680 Central AvePhoenixAZ·85036·GRP-8316—
PRVPRV-230382026-06-23T07:21:21ZAhmed—Burke··19580622UHC-38144-72null387-764-7745NULL2720 Spring StreetMinneapolisMN55435UNKNOWN—
TPATPA-611202026-08-11T11:00:55Z Reed—Ronald7/28/1957null··—NULL··——nullNULLnullGRP-9916N/A
ENRENR-1253902026-05-20T23:46:34Zchristopher—perkins1980-12-20UHC-86844-01··null9087919382christopher.perkins@aol.com8198 BASELINE RDScottsdaleAZ85256-8600GRP-4849choice-plus-ppo
PRVPRV-206772026-07-08T12:53:52ZMIKEW.REYES1945-11-25UHC-84549-13•••-••-3023(348) 384-9828michael.reyes97@outlook.com··N/A——····NULL··
ENRENR-1416332026-05-26T15:28:33ZYuki·XWilliamson2000-03-19UHC-67835-34•••-••-3277259-848-9270YUKI.WILLIAMSON@ICLOUD.COM4914 SAGE CTJACKSONVILLEFL32270GRP-5116NAVIGATE-HMO
ENRENR-1191492026-01-30T18:33:37ZKatherineWMitchell1964-03-04UHC-07605-24•••-••-8390(648) 955-2005katherine.mitchell94@yahoo.com···40 Elm StMesaAZ85274GRP-4236MEDICARE-ADV-B
ENRENR-1077942026-03-04T07:37:41Zwalter—rivera1994-12-28UHC9762467•••-••-89966347227260walter.rivera17@outlook.com2298 MAIN STREETMinneapolisMN55425GRP-9740medicare-adv-a
ENRENR-1235672026-03-10T19:45:03ZScottHKelley19461218UHC-55410-23•••-••-4595(676) 918-5708scott.kelley59@proton.me8103 RIDGE RDGilbertAZ85245GRP-8233·select-epo
ENRENR-1143722026-03-01T18:33:10Z NOAH—ROBERTS1962-03-21UHC-53705-72·UNKNOWN+1 739 783 6496noah.roberts@outlook.com3264 Sunset BlvdHoustonTX77093GRP-0810CHOICE-PLUS-PPO
ENRENR-1412752026-05-16T02:47:21ZJeremy—Roberts08/08/02UHC-15499-53•••-••-36922922886180—1986 CHURCH STREET··AtlantaGA30319-3958GRP-2215CHOICE-PLUS-PPO
TPATPA-512272026-09-06T04:42:46ZJOSEPH·····JORDAN1945-09-27UNKNOWN•••-••-5298—nullnullN/A—nullGRP-3983—
ENRENR-100786 2026-05-21T05:29:29ZJacob··N.WashingtonFeb 4, 1973UHC-73966-23•••-••-70647009054219UNKNOWN3679 BroadwayDallasTX75297·GRP-6191NAVIGATE-HMO
TPATPA-598922026-05-14T07:48:22ZhelenUwylliams1978-04-25··—-381.427.1921N/A1803 BAYSHORE DRSAN ANTONIOTX78208NULL—
ENRENR-1302372026-07-23T05:36:29Zjean—lawzon1973-10-24UHC-32919-07•••-••-5205339-262-7553JEAN.LAWSON64@HOTMAIL.COM5880 Highland AveNashvilleTN37241GRP-9412CHOICE-PLUS-PPO
CLMCLM-4248882026-07-20T04:06:40ZDENNISUHERNANDEZ1969-10-08-•••-••-4742UNKNOWNUNKNOWN8695 Mountain View DrSACRAMENTOCA·95836GRP-7157NULL
ENRENR-1283152026-01-10T06:16:31ZOilviaM.Gonzales1943-12-80··UHC-00411-18•••-••-60939682994643olivia.gonzales49@hotmail.com8846 Apache BoulevardSeattleWA98151GRP-4122·SELECT-EPO
ENRENR-1009782026-05-22T04:35:06ZWAYNEUDUNCAN15-04-1946UHC-81346-56•••-••-48953663589837—7593 Market St Apt 32MesaAZ85293·GRP-0967MEDICARE-ADV-B
TPATPA-523312026-06-12T02:28:37ZCHRISTINE··HICKS1996-10-24NULL··—NULL—4361 Canyon RoadScottsdaleAZ85277··NULL—
TPATPA-624942026-05-25T04:50:10ZBeverly··Ross26-07-1960null—3396899358UNKNOWN·8373 HILLCREST ROADEden PrairieMN55370null—
ENRENR-1369662026-07-19T04:26:28ZJEANO·GEORGE10/26/81UHC-52843-78•••-••-6176·15964563520jean.george77@outlook.com4731 JEFFERSON AVENUEHoustonTX77030GRP-5460CHOICE-PLUS-PPO
ENRENR-1404972026-05-17T11:55:40ZSandraXJackson1946-04-25·UHC-53077-56•••-••-60404792888883sandra.jackson@aol.com··3183 Union StreetFRESNOCA93728GRP-3340OPTIONS-PPO
ENRENR-113753 2026-05-04T19:40:08Z·MARIANAE.HERRERA09/25/79UHC-47508-09•••-••-4583·N/Amariana.herrera@icloud.com4823 MOUNTAIN VIEW DRIVESACRAMENTO·CA95863GRP-6363OPTIONS-PPO
ENRENR-1174562026-04-11T02:09:23ZSantiagoL.Olivia2005-05-15UHC-85487-41•••-••-8460963-964-1046OLIVIA.SANTIAGO@HOTMAIL.COM842 Canyon RdMesaAZ85256GRP-5281MEDICARE-ADV-A
ENRENR-1324352026-09-28T02:43:25ZCHRISTOPHERICONTRERAS1951-12-19··UHC-60511-18UNKNOWN420-975-3682N/A8960 MAIN STLas VegasNV89176GRP-7550CHOICE-PLUS-PPO
ENRENR-1164962026-08-29T16:46:34ZSetwart, GabrielJ—2001-05-26UHC-98340-36•••-••-4505925-287-8598gabriel.stewart@gmail.com6498 Palm DrDenver··CO80274GRP-3174SELECT-EPO
ENRENR-1120442026-06-13T04:27:05ZGreen, Omar——1975-11-18UHC-55015-60•••-••-14817545319554··OMAR.GREEN@OUTLOOK.COM6592 Hillcrest RdMiamiFL33193GRP-5616OPTIONS-PPO
CLMCLM-4175762026-05-24T16:11:03Z·BETYS—BAKERSep 4, 1994UHC-60905-95null+1 205 433 3934···NULL·9587 Park PlaceSan AntonioTX78237UNKNOWN—
TPATPA-591462026-03-24T17:41:12ZJACOB—JENSEN19420119UHC-74692-41——jacob.jensen@outlook.com5608 Meadow LaneDENVERCO80260-4622——
CLMCLM-4174152026-03-21T00:47:27Zangela—martin02/23/06UHC-26771-60•••-••-9271(563) 227-4890—-NULL—nullNULLnull
ENRENR-1111412026-05-16T13:27:03ZTIMOTHYU.LYNCHOct 20, 1976··UHC-17134-18•••-••-14732686015298TIMOTHY.LYNCH@AOL.COM5599 HIGHLAND AVE··MIAMIFL33124GRP-7726MEDICARE-ADV-A
CLMCLM-4315252026-08-25T16:15:34ZMelissaMDominguez1955-10-15UHC-07165-11•••-••-1754(985) 530-4738—UNKNOWNN/AN/A-··GRP-2322NAVIGATE-HMO
CLMCLM-4006102026-05-06T04:41:44ZROGERP.TRAN-UHC-00583-18NULL7616571574—2965 Camelback RdSan AntonioTX78238—SELECT-EPO
ENRENR-1282782026-10-01T05:42:03ZRichardson, BrittanyC··—Apr 8, 1992UHC8555072•••-••-9863+1 365 294 0002BRITTANY.RICHARDSON@YAHOO.COM4591 Lincoln WayTucsonAZ85731GRP-7038MEDICARE-ADV-A
100,000 rows, page 247 of 2,000PreviousNext

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