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-277152026-07-23T08:33:16Z JOSE—HUNTER2001-02-17UHC2622470NULLnulljose.hunter87@hotmail.com9111 MAPLE AVESeattleWA98100nullN/A
PRVPRV-260722026-03-21T11:06:27ZWei—Alvarez15-10-1986··UNKNOWN····(864) 330-0786—5127 Elm StHoustonTX77039null··CORE-HMO
PRVPRV-224592026-07-24T10:04:51ZCAROLU·VAZQUEZ19490112null·UNKNOWN9268387556·CAROL.VAZQUEZ64@AOL.COMNULLnull—NULL·NULL-
PRVPRV-201622026-10-09T19:25:09ZRalphP··Weaver·1957-09-18——537.610.3292ralph.weaver@yahoo.com4786 RIDGE ROADCharlotteNC28232NULLoptions-ppo
PRVPRV-242682026-02-03T09:53:18ZMateo—Ellliott1996-02-27·NULL-554-852-5222UNKNOWN8436 HIGHLAND AVESAN DIEGOCA92196—-
PRVPRV-21048 2026-08-20T12:03:05ZDIEGO—GEORGE06/14/2000UHC-74759-55UNKNOWN·(267) 509-1606—4258 SAGE CTMINNEAPOLISMNUNKNOWNnull·null
PRVPRV-289772026-02-09T14:27:31Z Dunn, MariaM—1994-05-25——(427) 666-8119nullNULL—N/A--N/A··
PRVPRV-290332026-05-25T06:00:14ZJosephILucas1963-11-28UHC-13804-58—630-268-9018—4555 LINCOLN WAYAtlanta·GA30345-3962····NAVIGATE-HMO
PRVPRV-238682026-03-12T17:47:00ZGloriaYBowman19930705UHC-30916-26-727.744.2396-224 Forest AveOrlandoFL32819··N/A
PRVPRV-253742026-04-01T22:43:49Z Kimberly—Burns1982-01-20UNKNOWNNULL+1 230 548 7241—3423 Camelback RdTEMPEAZ—nullUNKNOWN
PRVPRV-278052026-06-19T19:42:48ZMichael—Schmidt28-10-2004UHC-23738-80UNKNOWN(579) 956-6239—7258 HARBOR BOULEVARDDallasTX·75268-·NAVIGATE-HMO
PRVPRV-229812026-02-07T04:29:42ZAlexander—Jordan1979-06-22N/A•••-••-6342+1 652 795 7318alexander.jordan@icloud.com8019 Church StCharlotteNC28263nullN/A
PRVPRV-290232026-02-24T11:27:57ZMATTHEW—COX1952-01-15UHC-62478-86UNKNOWN850-983-4923··N/A·6971 Park PlaceAtlantaGA30377—UNKNOWN
PRVPRV-252312026-05-16T18:03:41ZCARLOSSMCCOY1981-10-23····•••-••-873112367526035CARLOS.MCCOY55@YAHOO.COM4191 Grand AvenuePLANOTexas75061—NULL
PRVPRV-218202026-09-19T10:09:38Z·Timothy O.—Flores··1980-10-14UNKNOWN•••-••-4130UNKNOWN-2143 APACHE BLVDGlendaleAZ85350——
PRVPRV-245472026-01-17T18:46:56ZCarolyn—Jordan10/12/1952·NULL-9293703365NULL3878 Market StCHARLOTTENCN/A·UNKNOWNN/A
PRVPRV-276152026-09-21T12:56:24ZGRACE—ORTIZSep 27, 1939—•••-••-8730418-687-9812-7871 Spring StORLANDOFlorida32872-9833N/A—
PRVPRV-263802026-06-20T03:38:50ZBobby··R.TurnerDec 25, 1943UHC-32889-50null2087869270bobby.turner77@icloud.com484 Washington StHoustonTX-N/A··—
PRVPRV-287192026-07-08T15:09:13ZCarolyyn—BennettFeb 8, 1940UHC-56432-79null2295118147··—·8185 LINCOLN WAYHoustonTX··77073nullN/A
PRVPRV-220272026-02-08T18:03:33ZLAURA—KELLY1956-02-22UHC-41118-16•••-••-2039+1 572 881 5057—9767 BroadwayMinneapolisMN55477—·NULL
PRVPRV-294782026-06-29T23:25:54ZKeith—Jensen2004-11-19—UNKNOWN··(261) 762-2851keith.jensen@icloud.comN/ANULL····-—null
PRVPRV-211222026-10-08T00:46:19Zjeremy····wagner··1995-05-10UHC-69263-65null394.828.8733—5862 Oak StreetEDEN PRAIRIE··MN55305——
PRVPRV-276822026-07-20T12:40:35ZLAURENUPETERS1984-07-16·-N/A(225) 285-7791lauren.peters@proton.me1420 OAK STREETGlendaleAZ85392N/Achoice-plus-ppo
PRVPRV-201152026-04-08T09:53:32ZJohn—Gardner1947-11-06UNKNOWN-7044809229——-N/A-——
PRV PRV-241592026-05-20T16:00:38Z·Nguyen, Gerald····—1995-06-26UHC5537989null—·gerald.nguyen@gmail.com7182 CANYON ROADChandlerAZ85204—N/A
PRVPRV-229652026-04-06T04:54:07ZNathan—Cunningham1952-05-27NULL•••-••-8741984.788.3848UNKNOWN789 Apache BoulevardTempeAZ85270null-
PRVPRV-259132026-09-12T00:24:48ZOmar—Bell···-UNKNOWN•••-••-8583791-394-2176omar.bell69@hotmail.comN/AN/AN/AN/AUNKNOWNoptions-ppo
PRVPRV-21350 2026-08-21T00:07:27ZALBERT—MURPHYNov 18, 1953UHC-70792-68UNKNOWN(925) 681-1998null3133 LINCOLN WAY Apt 27MiamiFL33132NULL··-
PRVPRV-255762026-08-04T20:55:57ZRAYMOND—·HERRERA1954-06-02—UNKNOWN—RAYMOND.HERRERA@ICLOUD.COM9418 Indian School Road·ColumbusOH43290nullN/A
PRVPRV-251952026-01-19T11:18:38ZJANICE—JOHNSON1997-04-24UHC-76647-45-(742) 340-3610··7828 HIGHLAND AVENUEEDEN PRAIRIEMN55363······—
PRVPRV-206122026-03-17T12:56:55ZTHOMAS—JOHNSTONJan 26, 1982·UNKNOWN—19517046677thomas.johnston24@icloud.com2797 Market Street·ScottsdaleAZ85273UNKNOWNNULL
PRVPRV-268032026-10-13T15:59:48ZDominguez, Keith——02/08/1941UHC-93982-60—345.797.0629—null-UNKNOWN—N/ANULL
PRVPRV-278872026-03-23T00:25:26ZWatson, Keith······08-02-1991UHC-99757-95•••-••-7116+1 710 468 8661null·907 Central AvenueSAN ANTONIOTX78265—UNKNOWN
PRVPRV-265562026-05-15T01:15:27ZAARON—COLEMAN02-11-1950UNKNOWN•••-••-1501(468) 471-6438NULL5871 Forest AvenueLas VegasNV89192N/A—
PRVPRV-220802026-03-12T22:24:24ZDonna—Garza1997-09-22··NULL··—337-566-3352donna.garza@outlook.com8852 Maple AveColumbusOH43299-8470—-
PRVPRV-24953 2026-04-17T23:18:28ZMark··Mills1962-04-06—-647-742-3538mark.mills89@outlook.com5792 BroadwayGlendaleAZNULLnull-
PRVPRV-202142026-05-24T04:46:49ZDieo—Holmes05/21/1965—NULL5844510758null5512 Sage Court #596··ScottsdaleArizona85238-2937nullUNKNOWN
PRVPRV-285442026-08-04T18:09:46ZAMBER—OLSON1965-06-20—•••-••-533216602446586null1119 Mesa DrTempeArizona85254··UNKNOWN
PRV PRV-23521 2026-07-02T11:52:04ZBeverly Z—HarrisonMar 11, 1962·UHC7608744null·14336407608—8994 Cedar LaneSacramentoCalifornia95836····N/A
PRVPRV-213952026-05-12T05:32:18ZMichelleI.Fowler··1981-09-08—UNKNOWN(500) 364-6441—2988 Central AvenuePHOENIXAZ85015—N/A
PRVPRV-273232026-06-11T02:12:57ZDeborah—Luna12/05/53UHC-71000-23NULL932-791-2460UNKNOWN——NULL——SELECT-EPO
PRVPRV-265212026-05-13T09:54:04Z Williams, James——22-08-1985NULLN/A946.885.0124james.williams@proton.me1733 Canyon RdMinneapolisMN55431-2456—N/A
PRVPRV-221742026-02-22T13:39:42ZFowler, Jason——8/26/1941UHC-57273-87—(943) 724-5381jason.fowler@gmail.com7152 WILLOW CTDallasTX··75239·····OPTIONS-PPO
PRVPRV-279142026-10-04T19:39:07ZCampbell, Elijah——22-10-1959null—3409678447··elijah.campbell90@gmail.com6580 CENTRAL AVESacramento··CA·95886-1616UNKNOWNUNKNOWN
PRVPRV-272512026-06-16T14:07:23Zmei—alexander1941-04-04UHC-21643-14—2715819mei.alexander@icloud.com968 RIDGE ROADSacramentoCA95820NULLSELECT-EPO
PRVPRV-249752026-05-27T07:11:46Z Elliott, Isabella——1942-04-03UNKNOWN—(947) 830-0276—·-——nullUNKNOWNCORE-HMO
PRVPRV-268282026-07-30T12:40:22ZJon—Santiago1966-04-23UHC-29521-60N/A482-851-0911jonathan.santiago8@hotmail.com3230 Market StSan DiegoCA92185NULL—
PRVPRV-264622026-05-05T20:36:38ZRyan—Garrett2005-04-05NULLN/A449-781-2983—7441 Market StMinneapolisMN55455null-
PRVPRV-212772026-01-11T11:59:39ZPRIYA—DIXON1998-08-21N/A—13209531958N/A4608 Desert Sky BoulevardColumbusoh43261-N/A
PRVPRV-227222026-09-13T09:33:40ZRAYMOND—CAMPBELL2002-11-15UHC-88385-96—+1 773 521 7027··—5500 OCEAN AVE··GlendaleAZ85328nullCHOICE-PLUS-PPO
9,596 rows, page 7 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-19T19:54:25.432Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty