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

Provider network only, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
PRVPRV-295432026-10-05T18:37:11ZCatherineL·Bennett01/12/80UHC-58898-70UNKNOWN(258) 712-4462—939 Ocean AveAustinTX78790--··
PRVPRV-229022026-04-10T01:46:26ZAustin—Domynguez04/10/1954·N/ANULLnullaustin.dominguez@proton.me7136 Cedar LnTAMPAfl·33601-2769NULL··
PRVPRV-204202026-07-24T04:08:29Z JUSTIN····RODRIGUEZ·06/15/53-—+1 838 452 9521-8205 Baseline Road··CHANDLERAZ85267—·CORE-HMO
PRVPRV-269632026-05-14T11:49:38ZShirley·L.HarrisonApr 24, 1940UNKNOWN-17475212037——····UNKNOWNNULL—N/A
PRVPRV-239532026-07-23T17:54:04ZDiana—·Weaver2001-11-18UHC-47288-85•••-••-2305362-764-3940diana.weaver@proton.meN/A—-———
PRVPRV-240842026-09-20T13:42:10Z·Lupez, MadisonP.—1945-02-18N/AnullN/A—673 Grand AvenueLas VegasNV89177NULL—
PRV PRV-254792026-09-26T16:08:38ZJustin—Schultz1985-08-09UHC-07089-67UNKNOWN(428) 609-4867N/A6556 MOUNTAIN VIEW DRIVEGlendaleaz·85309—NULL
PRVPRV-244272026-09-01T10:20:58ZMariana—Robertson2004-08-20UHC-59750-05null841-708-5404MARIANA.ROBERTSON@HOTMAIL.COM5340 Desert Sky BlvdDenverCO80211N/AUNKNOWN
PRVPRV-273112026-04-30T03:19:58ZANA—MENDEZ2008-07-28UHC-82946-68•••-••-6785975-284-4269UNKNOWN5210 Jefferson AvenueColumbusOH43294···N/ANAVIGATE-HMO
PRVPRV-248022026-02-15T10:29:32ZJose—Morrison27-08-1953UHC-06840-28··NULL7077132703JOSE.MORRISON56@YAHOO.COM8493 HARBOR BOULEVARD Apt 20GlendaleAZ85334-null
PRVPRV-205292026-02-11T16:16:09ZEthan—Le1939-11-24——(925) 358-9039N/A··3103 Mesa Dr #503PhoenixAZ85048N/AN/A
PRVPRV-273522026-02-23T03:14:42ZMejia, Kathryn——1938-02-19UHC-64570-80—UNKNOWN—3998 LAKE VIEW ROADSEATTLEWashington·nullnullN/A
PRVPRV-256742026-01-16T21:44:56ZPATIHOWARD1960-84-16UHC2880793null930-868-6400patrick.howard86@aol.com7671 Sunset BlvdMinneapolisMN55499-—
PRVPRV-203102026-04-27T04:08:18ZMASONHSANCHEZ03/12/2001uhc-57803-79•••-••-0959(442) 334-6851MASON.SANCHEZ@ICLOUD.COM9677 CAMELBACK ROADTempeAZ··85240—N/A
PRVPRV-260642026-09-06T03:57:44ZNathanABennett1998-08-28····•••-••-1820N/Anathan.bennett@gmail.com1469 SPRING STREETEDEN PRAIRIEMN55313—NULL
PRVPRV-261392026-03-09T07:58:59ZTeresa—Dlgado1950-02-04UHC-40854-32··N/A(540) 565-0622—3500 Valley View DrivePhoenixAZ85009··NULL··UNKNOWN
PRVPRV-242532026-02-23T19:03:55ZPERRY····NICOLE1952-01-17—-5883150375—7253 OCEAN AVENUETampaFL———
PRVPRV-263972026-05-26T05:18:29Z·Aaron—Soto··1985-01-05UHC-84486-65—(354) 358-6621··505 Washington Street··FresnoCalifornia93711UNKNOWN··
PRVPRV-26407 2026-10-09T21:03:06ZOrtega, CynthiaQ—1943-02-04NULLnull·(438) 757-0627cynthia.ortega24@icloud.com8531 Mountain View Dr··Atlanta·GA·N/AN/A—
PRVPRV-237842026-04-23T21:10:55Zmaria—owensNov 7, 1962NULLnull9284739575maria.owens13@proton.me—N/A——UNKNOWNMEDICARE-ADV-B
PRVPRV-287802026-03-01T04:02:48ZAguilar, ChristopherL—1967-09-11·UHC-33800-17——N/A3042 Sage CourtPlanoTX75014-2946—-
PRVPRV-246992026-04-03T10:42:48Z·ABIGAILP.HARRISON1940-04-21UHC-99217-26•••-••-4927(406) 845-3285····UNKNOWN——-null-
PRVPRV-202812026-09-26T12:52:01Zryan—barbara1964-05-01UHC-96763-42—323-240-3800NULL6299 Sunset BlvdSan DiegoCA92148—UNKNOWN
PRVPRV-279622026-07-01T16:51:49ZMargaret—FosterNULLUHC-01099-35-····—9550 Highland AvePhoenixArizona-—MEDICARE-ADV-A
PRVPRV-257782026-10-03T09:49:52ZTheresa—Phillips··2001-12-07UHC-41602-41null499-319-2275—942 PINE DRHoustonTX77071null—
PRVPRV-240972026-04-16T06:23:10Zkyle—young1957-11-24NULL•••-••-0965(211) 703-4491N/A5907 Harbor BoulevardSAN ANTONIOTX78231——
PRVPRV-228902026-03-15T04:58:14ZMARIA—BAILEY5/28/1990UNKNOWN—(490) 949-0878N/A····UNKNOWN—--NULL
PRVPRV-245222026-03-03T05:34:20ZJackson, Wayne····—12/22/1951null—284-492-1848—4411 Willow CourtDallasTX75290—UNKNOWN
PRV PRV-224222026-09-05T14:42:29Z Sarah—Spencer2001-06-11UHC-56619-38•••-••-0834+1 729 682 2004—1763 Ridge RdEden PrairieMN55316-UNKNOWN
PRVPRV-278642026-10-06T11:32:35ZCarl—Ray08/05/63UNKNOWN•••-••-5863——1930 HARBOR BOULEVARDMesaAZ85208—UNKNOWN
PRVPRV-201512026-05-24T01:45:39ZRios, Bobby——18-09-1977UNKNOWN··—862-548-4940UNKNOWN6800 Mesa DrSan AntonioTX78216N/AN/A
PRVPRV-230172026-09-29T06:30:53Z·MELISSAP.STEVENS·2/18/1956UHC-08975-82N/A293-593-4937—4400 BROADWAYPLANOTX75091N/AN/A
PRVPRV-267362026-04-20T05:01:41ZVincent—RussllJul 1, 1998··N/A·-728-381-0394—1656 Maple AvenueEden PrairieMinnesota55319null—
PRVPRV-251462026-07-06T01:31:47ZROGER—EDWARDS2002-10-01UHC-27243-62-(878) 219-9861ROGER.EDWARDS@PROTON.ME7296 Union StTempeAZ85298—N/A
PRVPRV-250092026-06-06T23:13:41Zemily··Ghunt1961-05-13UHC-56348-80•••-••-2989(538) 998-9523emily.hunt18@icloud.com1311 Indian School RdAtlantaGA30392UNKNOWNMEDICARE-ADV-B
PRVPRV-210082026-08-08T09:23:56ZRobert—Holmes2006-04-09—•••-••-1913(953) 601-5335robert.holmes40@outlook.comUNKNOWN-NULL·-N/ACHOICE-PLUS-PPO
PRVPRV-254932026-07-08T11:56:26ZWayne—Bishop19991026UHC-11867-64N/A733-856-2727wayne.bishop20@aol.com8020 Spring StreetSCOTTSDALEArizona85252——
PRVPRV-241192026-04-24T12:26:07ZMARIA—LITTLE1995-08-17·NULLN/ANULL—8543 Ridge RoadCharlotteNC28284UNKNOWNNULL
PRVPRV-213402026-03-28T02:35:39ZWood, Hannah—····Oct 2, 1982UHC-77455-70··•••-••-0747·N/A—8882 Harbor BlvdHoustonTX77005—··
PRV PRV-279832026-05-19T22:26:58ZAlbertUJohnston1961-05-09UHC-58242-57NULL··554-877-8504—5512 Highland AvenueTucsonaz85750-6319—-
PRVPRV-246092026-08-29T17:48:02ZFrank—Bishop1987-09-21N/Anull(308) 663-6932—5597 Willow CourtLas VegasNV89124NULLNULL
PRVPRV-211692026-04-07T10:47:19ZKahtleen—Carpenter1965-06-13UHC-24892-68UNKNOWN258.645.4641NULL3201 Park PlaceDenver··CO80239NULL-
PRVPRV-218532026-06-03T15:59:07ZJoe—Bishop··9/16/2006N/A•••-••-2502211.534.2399joe.bishop@gmail.com4760 Canyon RdPhoenixAZ85094—UNKNOWN
PRVPRV-247382026-10-08T21:15:32ZWalker, MarilynL.—12/9/1999··nullN/A··523-651-7965—721 River RoadMinneapolisMN55443——
PRVPRV-245252026-07-06T23:53:54Z·SoofiaILopez19970409··N/A•••-••-1772667-277-2546—N/AN/A—N/A——
PRVPRV-238432026-07-10T12:36:54ZRoy····Patl1990-10-21UHC-86246-70N/A—-567 ELM STREETDallasTX··75291-0320null—
PRVPRV-249402026-09-13T10:38:35ZDotW.Wagner1999-11-07N/AN/Anull··-1607 FOREST AVENUETucsonArizona85733nullN/A
PRVPRV-219242026-05-22T07:21:48ZEVELYNKGREEN05/03/06UHC7888243•••-••-7779—-——N/AN/AnullUNKNOWN
PRVPRV-200212026-04-09T01:47:13ZJeremyG.Frnklin1974-09-25UHC-69691-36UNKNOWNnullJEREMY.FRANKLIN@OUTLOOK.COM3588 Jefferson AvenueHOUSTONTX77063nullN/A
PRVPRV-281232026-04-29T09:28:49ZAMY—FERNANDEZ1948-03-16UHC-54769-51UNKNOWN2897204760amy.fernandez@proton.me3078 Lake View RdLos AngelesCA90029NULL—
9,596 rows, page 163 of 192PreviousNext

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