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-272742026-08-07T11:35:48ZBenjamin—AlvaradoAug 19, 1960UHC-00426-39—(656) 681-1955UNKNOWN8188 MESA DRSacramentoCA95826-N/A
PRVPRV-211822026-02-01T02:20:05ZJonathan—Richards1986-09-07uhc-51651-96—691-434-2207jonathan.richards84@proton.me4292 Camelback RdCharlotteNC28231—NULL
PRVPRV-252512026-09-06T11:03:15Z·BrendaH.Santiago19950110N/AN/A(563) 732-7961brenda.santiago@gmail.com7882 Washington StreetGLENDALEAZ85377NULLN/A
PRVPRV-292792026-03-03T03:43:24ZSAMANTHAYTHOMPSON1977-08-09UHC-17634-87N/A·777-604-0312samantha.thompson@hotmail.com5712 Pine DriveGLENDALEAZ85306··—null
PRVPRV-206962026-05-17T13:03:07ZCARR P—FATIMA1954-11-23UHC-87958-42UNKNOWN242-461-7953N/A931 Cedar Ln··CharlotteNorth Carolina··28226UNKNOWN·UNKNOWN
PRVPRV-23012 2026-06-07T16:31:10ZANNA··HAMILTON1947-07-28UHC-64350-02•••-••-7935(572) 308-2398—1273 MESA DRCHANDLERAZN/A-CHOICE-PLUS-PPO
PRVPRV-283772026-01-19T11:40:02ZLISA—LANE1949-06-28—•••-••-9880274-652-0307—9503 Meadow LaneLas Vegas·NV89147··—-
PRVPRV-268092026-08-05T23:22:07ZTERESA—CHAVEZ12/08/1980·nullUNKNOWN371-783-3852··UNKNOWN2318 Harbor BoulevardMesaAZnull—NULL
PRV PRV-211742026-08-05T13:25:31ZEMILY—ROJAS1973-08-11-·UNKNOWN+1 454 701 5886emily.rojas22@yahoo.com3791 Baseline RdMesaAZ85242—UNKNOWN
PRVPRV-249902026-09-03T16:30:09ZAnnPBrown1983-09-08UHC-30609-35N/A548-877-9910ANN.BROWN98@YAHOO.COM9844 Meadow LnGilbertAZ85214—NULL
PRVPRV-28483 2026-08-03T06:51:45ZAlice—Parker1952-11-01··—N/A(907) 845-6046alice.parker84@aol.com6250 CAMELBACK RDDALLASTX75234—null
PRVPRV-237602026-10-17T03:21:22ZBobbyT.··Rojas1984-02-72UHC-80225-05•••-••-2987(790) 829-5407—1537 Market StreetDENVERCO80295UNKNOWN····
PRVPRV-265692026-06-01T14:10:03Z·GABRIELH.BRADLEY03/05/1946—•••-••-00024684386833—1795 Church St Apt 24FresnoCA·-UNKNOWN·N/A
PRVPRV-277372026-05-01T18:35:11ZABIGAIL—SPENCER1969-09-15—NULL3175753421ABIGAIL.SPENCER@ICLOUD.COM8550 Lincoln WayDALLASTX75209·null—
PRVPRV-261512026-08-19T18:20:44ZJORDAN··—ROSE09-10-1980UHC-57654-16•••-••-2006816-571-3463jordan.rose@hotmail.com4464 Lincoln Way·GilbertArizona85241—N/A
PRVPRV-265902026-01-21T07:20:10ZHernandez—William2001-09-12UHC-46931-84UNKNOWNN/A-7899 Cedar Lane··DALLASTX75231null—
PRVPRV-277992026-01-13T01:09:34ZGERALDKROBERTSON1945-09-20null—380-790-0615··gerald.robertson@icloud.com2789 PALM DRPhoenixAZ85083··—N/A
PRVPRV-245892026-06-21T22:05:00Zray—martinez··1964-07-23UHC-76339-68UNKNOWN325.658.1547N/AN/ANULLUNKNOWN-N/A···null
PRVPRV-232202026-10-07T10:19:57ZJean—Thomas19420905null•••-••-67942299208257N/A2362 MESA DRIVETempeAZ85209-2728UNKNOWN····
PRVPRV-276662026-06-23T09:48:13ZRojas, Justin———NULLN/A·4103007271·justin.rojas@outlook.com2150 Highland AveAtlantaGA30332—UNKNOWN
PRVPRV-255972026-06-15T03:03:53ZRobertC.Dean1949-03-03NULL•••-••-77928195638371-N/A··UNKNOWN——OPTIONS-PPO
PRVPRV-269492026-05-21T04:57:21Zaaron—rojas19380327--(449) 370-1999·-7749 Mesa DrGilbertAZ85225—··
PRVPRV-284502026-05-05T03:44:36ZBobby—Ward1955-10-01UHC-67393-89UNKNOWN9548406979bobby.ward@outlook.com5410 Ocean AvenueNashvilleTN37255——
PRVPRV-233042026-09-22T06:20:45ZCynthia··MElliott7/15/1990UHC-89870-57--··NULL8525 Sage CourtEden Prairie··MN·55386null··N/A
PRVPRV-279372026-03-02T11:10:23ZTeresa—Porter19480403N/A·N/A12783976616··teresa.porter@hotmail.com9635 MAPLE AVEEden PrairieMinnesota-—CORE-HMO
PRVPRV-201142026-06-02T05:34:24ZRobert C.—Hoffman1980-04-20UHC4194658··null937-778-8548N/A8892 Spring St Apt 21DallasTX75231null··
PRVPRV-273312026-06-06T07:27:11ZLinda·ADixon10/15/1999—•••-••-0994(850) 657-4803N/A705 Washington StFresno··CA93773·-NULL
PRVPRV-252032026-03-25T11:42:02ZMARIANA—GUTIERREZ1999-07-23—UNKNOWN—MARIANA.GUTIERREZ84@HOTMAIL.COM8486 Central AvenueMesaAZ85228UNKNOWN-
PRVPRV-274842026-04-15T08:39:58ZCHRISTINA··U.LEE1954-12-17—NULL5399295509··christina.lee10@icloud.com1174 Oak StMinneapolisMN55419-N/A
PRVPRV-204452026-06-11T21:39:38ZSofia—Padilla20070304—N/A248-762-3563-5934 Elm StreetGilbertAZ85218UNKNOWNMEDICARE-ADV-A
PRVPRV-204172026-06-15T17:35:05Z SARRA—GOMEZ2002-40-12—UNKNOWN6536545230-nullN/A———UNKNOWN
PRVPRV-203032026-03-07T06:25:04ZCamila—Santos11/20/1951UNKNOWN····682.313.6559N/A4386 Lake View RoadSeattleWA98115NULL·NULL
PRVPRV-282022026-01-29T12:32:20ZRUTH··X.JACOBS2004-07-10—null-—6862 SAGE COURTTempeAZ85266-4028——
PRVPRV-205462026-07-18T19:50:38Zhiroshi—reynolds1965-06-21—····3935296025—2054 SUNSET BOULEVARDSACRAMENTOCalifornia95897——
PRVPRV-289742026-10-13T20:50:14Z MARIA—ALEXANDER1979-05-05UHC-74312-70UNKNOWNNULLmaria.alexander55@hotmail.com7164 CAMELBACK RDHoustonTX77037—UNKNOWN
PRVPRV-29560 2026-09-09T11:59:51ZPeterMWang··1989-06-01UHC-50056-32-2403355409··7241 Baseline RoadSeattleWA-N/Anull
PRVPRV-264392026-03-09T08:20:44Z·Billy—Hamilton1962-12-26UHC-77514-16—(546) 901-3469····2692 MEADOW LNPHOENIXAZ85025UNKNOWN—
PRVPRV-261712026-07-09T05:37:52ZDennisCRyvera1996-06-18··—UNKNOWNnull—7168 Forest Avenue Apt 36TempeAZ85298-3093N/AUNKNOWN
PRVPRV-200762026-05-31T01:00:45ZAlexander—Medina10/09/62—NULL·+1 759 848 4612NULL3388 Forest AveAtlantaGA30372NULL—
PRVPRV-267212026-04-26T00:51:08ZHart, Heather—····1960-06-27··UHC-02743-92NULL6385063717heather.hart9@hotmail.com8139 Highland AvenueJacksonvilleFL32212-9659—N/A
PRVPRV-251072026-10-13T19:28:48Zdouglas··rivera1976-07-10UHC-47071-90-15579884573—UNKNOWN—UNKNOWN—··—
PRVPRV-275582026-05-29T20:18:21ZAlexis····Vasquez1968-08-12—-(771) 925-0588N/A6026 Ocean AveChandlerAZ85241NULL—
PRVPRV-273672026-05-28T02:30:42ZCarol—Moore2/19/1991—UNKNOWN+1 540 987 7375carol.moore11@hotmail.com851 Indian School Rd #443ATLANTAGA30344UNKNOWNCORE-HMO
PRVPRV-256612026-01-10T09:54:00ZCarlQWhite19430206—•••-••-1763N/A—8984 Ridge RdOrlandoFL32863-7349N/AN/A
PRVPRV-245202026-04-04T03:19:10ZWeber, Timothy——·1954-08-04——6603250442UNKNOWN3331 MOUNTAIN VIEW DRPlanoTX75003UNKNOWNUNKNOWN
PRVPRV-230602026-02-14T00:39:45ZRachel—Walker1941-06-28UHC-14561-82N/A(509) 472-4333rachel.walker@icloud.com6112 Elm StreetGilbert··AZ········N/A
PRVPRV-242882026-06-30T12:31:10ZKevin—Morris05/10/1938UHC-09232-82UNKNOWN392-387-8287kevin.morris22@gmail.com2441 Forest AvenueTUCSONAZ85707NULL—
PRVPRV-282442026-01-18T19:04:49ZEUGENE·KGYLBERT1987-07-03UHC-27936-75·-702-280-5732N/A3071 MAPLE AVEMinneapolisMN55412-core-hmo
PRVPRV-23347 2026-04-11T17:15:58Z·amanda—hansen1968-12-11UHC-53647-10—392-829-8480amanda.hansen@outlook.com3172 FOREST AVENUE·LOS ANGELESCA90073-UNKNOWN
PRVPRV-241402026-06-25T15:40:30ZChristine—Green1954-06-08N/A—(930) 624-5467christine.green@gmail.com2440 Market StreetLos AngelesCA90072UNKNOWNUNKNOWN
9,596 rows, page 145 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:42:56.171Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty