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-1222852026-04-12T21:19:50ZLori—White2008-09-19UHC-43792-16•••-••-60204026308874lori.white79@icloud.com5964 Washington St Apt 22ColumbusOH43233GRP-9231SELECT-EPO
ENRENR-1308762026-08-31T12:27:26ZTHOMASI.··DAY1983-04-11UHC6403330•••-••-6419·426-652-8716UNKNOWN2133 BroadwayLas VegasNV89109GRP-2373NAVIGATE-HMO
ENRENR-1300412026-05-02T02:01:12ZBRADLEYXBRYANT1990-12-16UHC-99924-03•••-••-1408+1 203 421 1154BRADLEY.BRYANT@HOTMAIL.COM3422 Lake View RdAtlantaGeorgia30370GRP-6895MEDICARE-ADV-B
ENRENR-1396372026-06-10T21:30:49Z Larry··Moreno4/27/1959·UHC7451627•••-••-2942N/Alarry.moreno82@icloud.com6676 Oak StreetTempeAZ85271GRP-7637·MEDICARE-ADV-B
ENRENR-1400652026-02-20T01:25:14Zandrea—deanOct 2, 1939UHC-48771-18•••-••-1477+1 258 749 8256andrea.dean@aol.com1987 Meadow LnTempeAZ85201GRP-8512MEDICARE-ADV-A
ENRENR-1036742026-04-05T05:22:01ZNunez, SantiagoM—1954-08-27UHC-42554-30•••-••-3515+1 659 357 9338—8018 Union StChandlerAZ85236GRP-1288MEDICARE-ADV-B
ENRENR-1289202026-04-03T23:26:24ZRandyOHill19600602UHC-78409-32•••-••-64014766329036RANDY.HILL8@OUTLOOK.COM9664 Washington StFresnoCA-GRP-3212OPTIONS-PPO
ENRENR-1008332026-05-17T16:29:32ZHart, Diane——2008-02-04UHC-90073-96•••-••-9341+1 259 816 6920—7848 Ridge RdMiamiFL····GRP-0700···CORE-HMO
ENRENR-1223572026-07-07T23:09:33ZWILLEI—RAY1962-02-03UHC-57120-48•••-••-73023673968182WILLIE.RAY41@ICLOUD.COM4022 GRAND AVENUE··DenverCON/AGRP-2967CORE-HMO
ENRENR-1313282026-02-05T06:26:23ZCHRISTINA—FRANKLIN1966-05-21UHC-33028-02•••-••-73107653474467christina.franklin17@aol.com8753 Lincoln WayPhoenix··AZ85052GRP-0967SELECT-EPO
ENRENR-1251742026-06-22T11:19:18ZisabellaK.aguiilar1951-12-61NULL•••-••-2043—isabella.aguilar@gmail.com839 Mesa Drive Apt 12AustinTX·78756GRP-9450·NAVIGATE-HMO
ENRENR-1206172026-06-17T09:43:46ZJoyceXHanson19530526UHC-23366-44•••-••-44614508369451joyce.hanson@proton.meUNKNOWN—NULLN/AGRP-5549··MEDICARE-ADV-A
ENRENR-1215122026-06-25T01:51:13ZloriZ.·delgado04/12/74UHC-04696-33•••-••-6840505-502-5368lori.delgado@yahoo.com··2102 Main StreetSacramentoCA95857GRP-1573OPTIONS-PPO
ENRENR-1274612026-06-21T21:57:20ZAUSTIN····MARTINEZ1967-10-23UHC-11479-37•••-••-49098023591004austin.martinez@hotmail.com3253 BASELINE ROADTEMPEAZ85224GRP-6860NAVIGATE-HMO
ENRENR-1268212026-07-16T22:13:11ZJesse—Thomas01/15/68·UHC-48971-29•••-••-3297386.614.8478JESSE.THOMAS9@OUTLOOK.COM1706 Valley View DriveMiamifl33168GRP-1030NAVIGATE-HMO
ENRENR-1137412026-05-18T03:36:30ZLuis—Smith1940-11-24UHC-09878-93•••-••-4902+1 698 292 3154UNKNOWN··4992 Park PlaceLos AngelesCA··90054GRP-1173SELECT-EPO
ENRENR-1302572026-06-15T19:17:21ZAliceL.Marquez08/26/1997UHC-75270-65NULL(753) 567-6148ALICE.MARQUEZ52@PROTON.ME9206 Ridge RdJacksonvilleFL32229GRP-6696MEDICARE-ADV-A··
ENR ENR-1298752026-02-11T22:08:38Z·Paul—·Rivera2004-02-23··UHC-53793-47•••-••-4880+1 519 341 1961paul.rivera@gmail.com9847 CENTRAL AVENUE··NashvilleTN37299GRP-7938MEDICARE-ADV-B
ENRENR-132129 2026-02-04T14:56:47ZBEVERLY—SOTO1948-01-21UHC-14300-46··•••-••-752716436909399beverly.soto80@yahoo.com·3256 Elm StreetORLANDO··FL32869··GRP-6969·MEDICARE-ADV-B
ENRENR-1301982026-04-28T17:06:42Zbrenda—fisher09/15/2003UHC-76248-86•••-••-5670+1 677 705 4262··brenda.fisher@aol.com2415 MAIN STREETJacksonvilleFL32258-5587GRP-2505CHOICE-PLUS-PPO
ENRENR-1171592026-04-12T10:22:13ZTimIDavis1974-07-13UHC-35325-43•••-••-8753683-431-0841—3754 Meadow LnNashvilleTN37260-5562GRP-4650CORE-HMO
ENRENR-1289752026-05-29T12:48:16ZSamanthaWKelly11/24/1991UHC-87446-72•••-••-8539(330) 815-5603null602 MEADOW LNEden PrairieMN55327GRP-3563CHOICE-PLUS-PPO··
ENRENR-1307062026-05-05T19:39:28Z Theresa—Lynch1959-04-14UHC-62297-36•••-••-567113799758159theresa.lynch@aol.com4893 APACHE BOULEVARDChandler··Arizona85267GRP-6799CHOICE-PLUS-PPO
ENRENR-1313672026-03-31T02:33:43ZRandy—Park1976-06-27UHC-28027-27•••-••-4275+1 382 453 8562randy.park21@outlook.com··3567 Cedar LnTampaFL33647GRP-0983medicare-adv-b
ENRENR-140819 2026-09-08T10:11:26ZLauraGHamilton1962-01-16UHC-78229-73•••-••-4126528-669-0950—9630 Mesa DriveMesaArizona85219··GRP-7742NAVIGATE-HMO
ENRENR-1112212026-09-09T12:35:55ZStephanieH.Turner9/22/1972UHC-23822-97—+1 699 462 7787-··4138 Grand AveSan AntonioTX78241GRP-4774OPTIONS-PPO
ENRENR-1176472026-07-07T21:22:05ZPeter—Weaver1988-01-21UHC-91738-96•••-••-2819(670) 979-8253—6620 Main StGLENDALE·AZ85357GRP-2780NAVIGATE-HMO
ENRENR-1026182026-03-24T11:36:30Zalexis—maldonado··1995-03-16UHC-75909-66•••-••-23612553416459ALEXIS.MALDONADO@PROTON.ME12 Hillcrest RoadChandlerAZ85261GRP-4712OPTIONS-PPO
ENRENR-1128612026-07-21T05:18:13ZPatricia—Bryant1958-04-20UHC-32560-43•••-••-71034779234236··patricia.bryant71@outlook.com5637 Hillcrest RoadCHANDLERAZ85294GRP-0974CHOICE-PLUS-PPO
ENRENR-1034582026-01-23T07:49:05ZVirginiaV.·Wells2005-07-25UHC-71578-76•••-••-76685285866virginia.wells@aol.com1805 MARKET STREETDenverCO·80231GRP-4799·OPTIONS-PPO
ENRENR-1058642026-04-17T04:16:11ZGREGORY—WARD22-01-1981·UHC-42600-61•••-••-0852422-714-3570gregory.ward@icloud.com886 Bayshore DriveMiamiFL33159GRP-3364CHOICE-PLUS-PPO
ENRENR-1318712026-07-19T14:33:41ZsofiaKmontgomery1943-11-05UHC-74662-82•••-••-0309327-545-1987SOFIA.MONTGOMERY31@ICLOUD.COM9440 Canyon RoadGlendaleAZ··85329GRP-6469CORE-HMO
ENRENR-1158152026-08-19T00:12:59Z·JERRYYPRICE1957-10-17UHC6220446•••-••-8054432-403-7551JERRY.PRICE96@HOTMAIL.COM563 DESERT SKY BLVDGlendaleAZ85340GRP-2899NAVIGATE-HMO
ENRENR-1326802026-02-14T05:33:43ZLucia—·Daniels1982-11-22··UHC-83430-16•••-••-156812228456416UNKNOWN6113 Market St··LAS VEGASNV·UNKNOWNGRP-2841OPTIONS-PPO
ENRENR-1388182026-06-20T22:15:26ZNancy—HarrisonAug 4, 1980nullN/A··389-609-1109nancy.harrison44@aol.com1411 Ocean Ave #844ColumbusOH43227GRP-7617NAVIGATE-HMO
ENRENR-1280812026-07-04T14:25:24ZGary·CPrker1964-10-13UHC-57560-60•••-••-2592—gary.parker@outlook.com8675 Washington StSan AntonioTX78258GRP-6385CHOICE-PLUS-PPO
ENRENR-1407682026-10-14T12:06:11ZMADISON····ORTEGA2005-08-14UHC-04560-91•••-••-0577608-708-8136madison.ortega@proton.me689 LINCOLN WAYSAN ANTONIOTexas78232GRP-1324MEDICARE-ADV-B··
ENRENR-1255472026-04-11T02:18:27ZBarbara L—Medina··1986-07-03UHC-96837-25•••-••-9689929-611-4552barbara.medina@icloud.com4638 ELM STSeattleWA98164GRP-1830NAVIGATE-HMO
ENRENR-1356612026-07-07T02:39:13ZWILLIAMMHANSAN·1974-02-21UHC-24086-77•••-••-7828·(643) 798-6171william.hansen@hotmail.com201 River RdJacksonvilleFL32247GRP-3766MEDICARE-ADV-B
ENRENR-1113942026-06-28T12:34:19ZanthonyO—1950-11-25UHC-06142-47•••-••-5549569-341-3886—7510 CAMELBACK RDDallasTX····GRP-1012·CORE-HMO
ENRENR-1153152026-08-01T05:41:48ZBRUCE—GORDONN/AUHC-76548-65•••-••-9966912-895-1340··BRUCE.GORDON@OUTLOOK.COM···1965 Apache BlvdAUSTINTexas78712·GRP-6107NAVIGATE-HMO
ENRENR-1241492026-06-19T05:02:37ZElijah··PSalazar1986-09-05UHC-61738-02•••-••-8432+1 935 315 9784null3923 Desert Sky BoulevardHOUSTONTX··77043GRP-1535CORE-HMO
ENRENR-1054272026-08-31T17:44:17ZJUDITH—LONG1942-01-02UHC-26096-75•••-••-9350+1 651 883 2404-1102 Willow CourtTUCSONAZ85768GRP-9037CHOICE-PLUS-PPO
ENR ENR-1290222026-03-26T05:27:58Zashley—ortega1953-02-15UHC-05522-42•••-••-60899684617ashley.ortega45@proton.me6300 MARKET STAustinTX78716GRP-1316navigate-hmo
ENRENR-1100792026-03-09T00:22:36ZPatriciaG.Aguilar1953-02-23UHC-00064-32—(922) 453-4467PATRICIA.AGUILAR65@OUTLOOK.COM5789 RIVER RD·NashvilleTN37202-3756GRP-9269NAVIGATE-HMO
ENRENR-1013482026-04-09T21:05:23Zsofa—·walker1945-03-20UHC-03102-14•••-••-7603·+1 421 452 0773N/A··4802 Oak StAUSTINtx·78761GRP-6767NAVIGATE-HMO
ENRENR-1032192026-06-15T00:36:15ZLawsonHRichard1947-05-12UHC-60766-62•••-••-7709315-649-8280richard.lawson63@outlook.com·560 Maple AvenueDALLASTX75294GRP-7711SELECT-EPO
ENRENR-1329292026-01-20T00:48:16ZJerry····MoralesNov 19, 1965NULL•••-••-77683575506338jerry.morales@yahoo.com4882 Union StreetMesaArizona·85264GRP-4390SELECT-EPO··
ENRENR-1252672026-06-06T12:45:24ZAnthony—Wells1955-06-12UHC4653581-8936221346anthony.wells30@outlook.com8883 Central AvenueGlendaleAZ·85336GRP-8928CHOICE-PLUS-PPO
ENRENR-1283322026-04-18T00:39:36ZbobbyHjonesOct 10, 1985UHC-06669-89•••-••-0739924.381.9937BOBBY.JONES62@HOTMAIL.COM8186 PALM DR··Chandler··AZ85286·GRP-3699MEDICARE-ADV-A
43,101 rows, page 328 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.623Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty