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-1071942026-01-14T08:27:17ZSTEVEN—WEBERJun 16, 1994UHC-54394-70··•••-••-87855059510649steven.weber37@proton.me4073 Main StMesaAZ85228-1134GRP-6553MEDICARE-ADV-B
ENRENR-1145742026-09-29T07:13:28ZMatthewWOwens1951-07-21UHC-15205-95•••-••-7499918.845.4349N/A54 Park PlaceColumbus··OH43232GRP-2801CORE-HMO
ENRENR-1067592026-03-12T16:51:22Z·Chapman, AndrewP··—1954-12-22UHC3814617•••-••-319716819272897—3398 Grand AvePlanoTX75005GRP-7570MEDICARE-ADV-A
ENRENR-1065962026-06-07T20:00:53ZLinda··Martinez1963-12-01UHC-92819-03•••-••-425818219915407·LINDA.MARTINEZ@GMAIL.COM9442 Lake View RdLas VegasNV89148GRP-3305MEDICARE-ADV-B
ENRENR-1380382026-03-03T18:24:46ZFrankF··Scott1988-11-22··UHC4457096•••-••-527619323558609NULL2437 Highland AveDallas··TX75249GRP-6926OPTIONS-PPO
ENRENR-1179522026-02-25T10:37:29ZAlexiis—Stephens1946-11-14UHC-11918-64•••-••-940217038447839alexis.stephens10@yahoo.com7276 Harbor BlvdDenverCO80295GRP-4864OPTIONS-PPO
ENRENR-122495 2026-07-07T08:55:45ZAlice—Graham10/08/02UHC-35055-31•••-••-47804902038393alice.graham@icloud.com1877 Forest AvenueSeattle·WA98129GRP-9260SELECT-EPO··
ENRENR-1405962026-01-08T06:07:42ZMegan—Vargas2001-01-27UHC-36979-26•••-••-2335543-314-7627megan.vargas86@aol.com7543 Grand Ave··San AntonioTX78266GRP-9044NAVIGATE-HMO
ENRENR-1256552026-03-03T20:35:08ZAlbertUPark2006-06-08UHC-40288-97UNKNOWN13174560268·ALBERT.PARK57@GMAIL.COM7915 Sunset BlvdSEATTLEWA98128-8754GRP-7105MEDICARE-ADV-B
ENRENR-1306942026-04-25T07:27:17ZAishaDPatterson1988-02-14UHC-02136-81UNKNOWN(707) 583-3705—2577 Meadow LnPhoenix··az85006-2325GRP-0486·SELECT-EPO
ENRENR-1030932026-09-12T03:23:39ZMariana—·Nelson1954-02-04UHC-45506-94•••-••-70498145800676mariana.nelson@hotmail.com5038 Mountain View DrNashvilleTN37224GRP-2080OPTIONS-PPO
ENRENR-1205312026-06-03T12:48:16ZEUGENE··HWALLACE1955-12-10UHC-88680-26•••-••-3934714-924-0459eugene.wallace@yahoo.com7384 Church StMiamiFL33106GRP-6282MEDICARE-ADV-A
ENRENR-1316612026-04-12T01:34:51ZRoy—Campbell·1965-02-19UHC-44341-02•••-••-2283·nullROY.CAMPBELL@HOTMAIL.COM4888 Union StPhoenixAZ-GRP-8562CHOICE-PLUS-PPO
ENRENR-1089562026-09-18T14:36:08Z·DIEOH.GONZALES··—UHC-87150-98•••-••-2343(423) 602-1525diego.gonzales@gmail.com3904 Market StMINNEAPOLISMN55408GRP-7605OPTIONS-PPO
ENRENR-107682 2026-03-01T12:26:30ZFrancesJMoore2006-04-19UHC-19353-75•••-••-7423UNKNOWNN/A5127 Baseline RoadSacramentoCA95828GRP-3686OPTIONS-PPO
ENRENR-1102072026-02-28T20:35:10ZAnderson, FarnkB—·10/02/41UHC-34079-95•••-••-117917088392899··3969 APACHE BLVDTucsonArizona85784GRP-3369NAVIGATE-HMO
ENRENR-1279712026-02-23T20:55:17ZAnthonyNWeber1958-05-09UHC-55390-78•••-••-0363UNKNOWNanthony.weber@yahoo.com5356 Indian School RdPhoenixAZ-·GRP-0308CHOICE-PLUS-PPO
ENRENR-1388072026-03-17T00:01:11ZCatherine—Salazar6/26/1958UHC-84425-07•••-••-4839-null-····——GRP-4910MEDICARE-ADV-B
ENRENR-1377442026-04-15T20:37:00ZArthur—MartinnezNov 14, 1945UHC-13234-84•••-••-357715188424917ARTHUR.MARTINEZ@GMAIL.COM5903 Apache BlvdPhoenixAZ85017GRP-7162CHOICE-PLUS-PPO
ENRENR-1170722026-06-30T01:02:30ZJean·BGraham15-08-1961UHC-91965-70•••-••-4525205.676.1681·JEAN.GRAHAM77@ICLOUD.COM1653 Ridge RdTampa·FL33658GRP-6270MEDICARE-ADV-A
ENRENR-1303562026-10-08T16:02:26ZWILLIE··MUNOZ1960-01-08UHC-92535-52•••-••-4963·6597207005willie.munoz18@aol.com··1335 Willow CtJacksonville·FL·32259·GRP-0789·CHOICE-PLUS-PPO
ENRENR-1166772026-10-04T15:52:26Z·JoshuaJPerry4/17/1941UHC-19812-26··•••-••-2245—··3898 Grand AvePlano···TX75094GRP-0319choice-plus-ppo
ENRENR-1277392026-03-17T10:11:59ZMariaITran··1962-01-03UHC-91217-99•••-••-00327703936409MARIA.TRAN75@AOL.COM6940 Forest AvenueSACRAMENTOCA95826GRP-3697MEDICARE-ADV-A
ENR ENR-1373602026-05-01T04:00:21ZDouglasK.Perez1946-12-16UHC-09660-92•••-••-0048208-844-2455—4022 Spring StreetMinneapolisMN—GRP-1463OPTIONS-PPO
ENRENR-1099922026-04-03T00:05:33ZDIANAI.OLIVER2002-03-10UHC-03540-75•••-••-69755452654diana.oliver@outlook.com7663 Maple AvenueColumbusOH43222GRP-0399OPTIONS-PPO
ENRENR-127018 2026-03-04T12:35:57ZMARCUS—BURTONAug 27, 1943UHC-55090-52··•••-••-3913·15403331117marcus.burton@icloud.com2437 Maple Avenue #190·AtlantaGA30371GRP-8976OPTIONS-PPO
ENRENR-1386112026-07-13T10:49:03ZPerry, Carl——03/05/50UHC-98328-67•••-••-7367+1 799 625 6221carl.perry67@icloud.com9077 Spring St·MiamiFL33195GRP-8904MEDICARE-ADV-A
ENRENR-1364462026-09-30T04:25:03ZSOPHIAANGUEN10/14/79UHC-35591-59•••-••-97529916234SOPHIA.NGUYEN@PROTON.ME·1745 Highland AveMiami··FL33119GRP-3414OPTIONS-PPO
ENRENR-1238582026-02-18T10:00:43ZMontgomery, Thomas——May 6, 1957UHC2554441•••-••-84644043746301THOMAS.MONTGOMERY1@YAHOO.COM6635 Washington StMIAMIFL33118GRP-0519NAVIGATE-HMO
ENRENR-1009552026-06-08T11:07:50ZBryanV.Weber10/19/87UHC-91647-58N/A966.262.6528bryan.weber87@hotmail.com·3394 Lake View RdMINNEAPOLISMN55414-8771GRP-5476CHOICE-PLUS-PPO
ENRENR-1393032026-03-07T16:28:06Zjames—carrr1972-06-13uhc-63999-89•••-••-30744798390086NULL6601 Washington StAtlantaGA30369GRP-6005CHOICE-PLUS-PPO
ENRENR-1039642026-04-24T04:20:54ZLane, TerryD····1969-03-27UHC-59619-27—·742-324-5453—2703 HILLCREST ROADLos AngelesCA·90071-4911GRP-9114SELECT-EPO
ENRENR-1322882026-05-17T21:08:46ZDANIELUJORDAN07-02-1970UHC-15360-01null555.695.9470daniel.jordan@hotmail.com·2166 Mountain View Dr #335PlanoTexas75015-5358GRP-7768CHOICE-PLUS-PPO
ENRENR-1216122026-05-26T21:41:25ZVirginia··Morgan·19980903UHC-03695-08—····virginia.morgan@gmail.com··337 Elm StMesaAZ85252GRP-9346MEDICARE-ADV-A
ENRENR-1351512026-07-23T01:08:25ZKennethEWashington1960-10-01UHC-66958-89•••-••-6026(803) 902-1488kenneth.washington11@proton.me9528 Desert Sky BoulevardTucsonAZ85758GRP-8775NAVIGATE-HMO
ENRENR-1354432026-01-22T04:17:04ZTOM—PHILLIPS1991-03-10UHC-55322-89•••-••-7315219-670-5701thomas.phillips@yahoo.com-nullN/A—GRP-1703NAVIGATE-HMO
ENRENR-1059812026-03-15T20:20:47ZTran, TimothyM—·04/25/1958UHC-04978-95··•••-••-44304657645355UNKNOWN5906 Apache BlvdGlendaleAZ85384··GRP-2761CORE-HMO
ENRENR-1362322026-02-21T23:20:42ZKenneth—Dixon17-05-1964UHC-00844-88N/A+1 468 932 3258kenneth.dixon@aol.com6482 Indian School RoadTampaFL33693GRP-8816MEDICARE-ADV-A
ENRENR-1040822026-04-28T00:00:47ZMARGARETSJAMESSep 4, 1943UHC-23284-60•••-••-6134—MARGARET.JAMES@PROTON.ME831 Grand Avenue··TEMPEAZ85240GRP-7770OPTIONS-PPO
ENRENR-1313112026-05-06T16:41:47ZDavidL.Adams08-10-1944UHC-00993-52•••-••-8013831-699-7194david.adams@icloud.com5254 Canyon RoadJacksonville·Florida32296GRP-0992SELECT-EPO
ENRENR-1300442026-06-29T16:53:07ZNANCY·PSOTO··1954-12-24UHC7444237•••-••-37459115693nancy.soto@icloud.com437 Maple AvenueLOS ANGELESCA90039GRP-3475CHOICE-PLUS-PPO
ENRENR-1230312026-03-26T20:08:33Z·Charlotte—Gomez22-04-1991UHC-77224-36•••-••-19316303645424NULL2616 Harbor BoulevardLos AngelesCalifornia·90095GRP-5142OPTIONS-PPO
ENRENR-1054562026-08-02T17:20:13ZchristinaEaustin19680512UHC-18686-11•••-••-8032(734) 854-6609christina.austin@hotmail.com1879 Forest AvenueOrlandoFL32880GRP-8110NAVIGATE-HMO
ENRENR-1046052026-09-13T13:54:38ZTommy—Fowler02/20/98UHC-84561-07•••-••-3788+1 323 455 9978·thomas.fowler@gmail.com4295 Lincoln WayChandlerAZ··85237GRP-4998MEDICARE-ADV-A
ENRENR-1261102026-07-08T06:38:40ZBenjamin—Miller1975-05-18UHC-93960-60•••-••-1624895-999-3321NULL··778 RIDGE ROADSan DiegoCA-GRP-7346NAVIGATE-HMO
ENRENR-1008632026-07-06T23:29:02ZAnthony—Alexander1958-06-19UHC-59278-32•••-••-73335169756801NULL5829 Mountain View DriveSacramentoCA95830GRP-1033CHOICE-PLUS-PPO
ENRENR-1225292026-09-18T01:03:57Z·Martinez, StephenM—1989-02-03UHC6780297•••-••-6889852-357-4147··—6738 Indian School Rd·Tampa·FL33665GRP-8584MEDICARE-ADV-B
ENRENR-1399292026-02-12T09:15:14ZOmar—Fisher1995-03-19UHC-39161-40•••-••-8070428-715-0689omar.fisher40@icloud.com8386 OCEAN AVELas VegasNV··89106GRP-2773NAVIGATE-HMO
ENRENR-1398592026-04-21T17:14:37ZFRANCES—RICEN/AUHC-56562-77•••-••-32353756557059frances.rice@aol.com817 Washington StLas VegasNV89154GRP-6214MEDICARE-ADV-B
ENRENR-1189612026-07-18T22:33:31ZAguilar, Doris——19451208UHC-72012-88•••-••-1499815.660.0352—7409 MESA DRIVEJacksonvilleFlorida32263GRP-9569SELECT-EPO
43,101 rows, page 196 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.334Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty