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-259102026-09-01T00:48:49Z·Judy—Willis06/11/1997·N/A—+1 897 256 2951—1681 Highland AvenueNashvilleTN37215——
PRVPRV-253592026-09-13T16:33:06ZSUSAN—MURPHY25-07-1969NULL•••-••-4742(383) 549-2958N/A——null·-—UNKNOWN
PRVPRV-225392026-07-21T18:03:04ZTimothy—George4/3/1951N/AUNKNOWN677.814.1778TIMOTHY.GEORGE@AOL.COM397 Sage CourtDenverCO80240·NULLN/A
PRVPRV-221982026-10-04T12:32:15Z AMANDA—RODRIGUEZ1951-11-11N/A····204.347.4799AMANDA.RODRIGUEZ42@PROTON.ME2060 VALLEY VIEW DRTampaFL33618·UNKNOWN—
PRVPRV-249272026-10-03T22:17:46ZMejia, Ronald——20060314NULL—805-524-8988-7266 Union St··Minneapolis··MN55464NULLSELECT-EPO
PRVPRV-281442026-06-16T14:44:29ZSEAN—CAMPBELL2004-05-09UHC-72935-03NULL17992053462sean.campbell63@yahoo.com1432 Lincoln WayOrlandoFL···32803N/AN/A
PRVPRV-226072026-03-31T19:03:24ZSantiagoS.Moore1962-07-03UHC-27250-83NULL····santiago.moore@hotmail.com7197 INDIAN SCHOOL ROADGlendale··AZ85371-CORE-HMO
PRVPRV-248932026-06-13T20:07:29ZGary—·Vazquez1974-01-17NULL•••-••-12299332571941UNKNOWN———N/Anull··N/A
PRVPRV-239432026-05-07T05:07:42ZYuki···N.Patel··Mar 23, 1970-—877.640.3575-4070 Baseline RoadChandlerAZ85210N/Anull
PRVPRV-248422026-08-07T21:24:45ZWillie—Moreno1965-07-25····NULL284-532-2100willie.moreno20@aol.com—-—··—-
PRVPRV-284592026-07-01T05:41:46ZDiego—Willis1945-11-19UHC5535342—288-790-2287—7121 Elm StTucsonAZ85707null—
PRV PRV-214952026-05-11T05:42:18ZCAROLYN—HANSEN11-10-1986UHC-55770-24null(938) 836-5226··N/A·9510 Mesa DrDallasTX75268·UNKNOWN·CHOICE-PLUS-PPO
PRVPRV-244162026-09-06T19:30:11ZHarvey, MeiS—19-04-1985UHC-52374-70•••-••-30479858983921mei.harvey22@icloud.com7910 Cedar Ln··HoustonTX77043nullUNKNOWN
PRVPRV-288932026-03-20T08:32:34ZElliott, Anthony——1979-10-12·-•••-••-3003316.518.7063anthony.elliott13@yahoo.com9411 Cedar Lane·PlanoTX75072—N/A
PRVPRV-237582026-07-02T03:24:04ZStephanie—Chavez1946-04-09UHC-88000-54—9625728887stephanie.chavez44@aol.com5606 CEDAR LNFresnoCA·93729UNKNOWN·null
PRVPRV-28277 2026-07-02T09:24:14ZBRYANYFOSTER·2001-12-01UNKNOWN•••-••-2391451-349-6968··—636 OCEAN AVENUEFresnoCA··—--
PRVPRV-242922026-03-02T20:29:16ZGrace—Sandoval1994-07-17UHC-09986-75N/A16049814588··NULL3704 CANYON ROADGLENDALEAZ85331—NAVIGATE-HMO
PRVPRV-232972026-07-24T09:40:12ZJacobX.Rios04/24/08UHC-73234-71UNKNOWN3502545508UNKNOWN3158 Canyon RoadOrlandoFL32863N/ANULL
PRVPRV-263232026-08-16T16:40:29ZPeterson, Bobby——1965-06-27UHC-08242-63•••-••-52338943771501N/A9031 Jefferson AvenueAustinTX78757UNKNOWN—
PRVPRV-265952026-09-02T00:21:29ZJessica—Duncan2003-02-01——5967665166jessica.duncan99@gmail.com8245 Oak Street Apt 34Mesaaz··85213····OPTIONS-PPO
PRVPRV-250812026-06-10T04:13:51ZKayla—Gibson11/11/1942UHC-77064-16NULL612-625-7015N/A··UNKNOWN———null
PRVPRV-268432026-02-06T01:40:51ZGuerrero, Dennis··I.—Feb 16, 1999UHC-15583-27-12174740533—6401 Mountain View DrMesaAZ85229—null
PRVPRV-242402026-08-25T16:56:01Z Emma—McDonald2004-12-11UHC-13241-25•••-••-0316347-309-4169NULL2008 CENTRAL AVENUEJacksonvilleFL32217—-··
PRVPRV-23970 2026-02-26T18:08:22ZMary—Marquez1981-01-20····N/A6229091859UNKNOWN9126 UNION STATLANTAGA30314-2455—UNKNOWN
PRVPRV-273472026-04-21T22:37:29ZGonzales, SamanthaR··—2008-03-06UHC-82018-07UNKNOWN(526) 230-6122samantha.gonzales8@yahoo.com1965 Meadow LnSan DiegoCA92159NULLUNKNOWN
PRVPRV-231612026-09-17T22:08:11ZMadison—Ellis1974-10-12·N/AN/A639-311-6193madison.ellis12@outlook.com5893 CENTRAL AVE #221AtlantaGA30385—null
PRVPRV-272952026-02-10T04:26:35Z Michelle—Gutierrez1998-01-28··UHC-25707-51····6387680342NULL6253 Grand Ave··ORLANDOFL32870—MEDICARE-ADV-B
PRVPRV-287062026-01-19T18:49:13Zahmed—campbell1939-09-19····•••-••-0193409-884-6877—1367 Cedar LnSan AntonioTX78215—N/A
PRVPRV-203862026-08-23T22:35:50ZHarris, AnnI—1962-11-20UHC-28678-48—18888840099ANN.HARRIS@ICLOUD.COM2246 RIDGE RD··CharlotteNorth Carolina28243--
PRVPRV-231732026-10-11T19:28:08ZMateoI.Weber1955-04-19··null—6529616—3648 Elm StreetMiamiFL33184UNKNOWNNULL
PRVPRV-270112026-05-30T01:52:09ZMatthews, Michael——09/14/98N/AUNKNOWN··3932932161NULL9134 GRAND AVEGlendaleAZ85374—·N/A
PRVPRV-201362026-04-16T12:30:37Z Vincent····Espinoza1986-11-16N/ANULL7908805643··NULL6278 Apache BlvdColumbusOH43266-1402null—
PRVPRV-221992026-03-22T01:54:32ZPatricia—Hayes2000-07-03······•••-••-9727912-889-0503NULL5615 GRAND AVEJacksonvilleFL32275UNKNOWN—
PRVPRV-210422026-07-10T17:33:09ZMICHELLEALANE12/15/1940UHC-28177-51—581-617-4089null7817 LAKE VIEW RDPhoenixAZ85050null—
PRVPRV-240222026-08-15T07:58:50Zmarcus—west1999-09-26UNKNOWNN/A··12306747644··7751 UNION STMesaArizona85222-5317·nullnull
PRVPRV-220782026-06-02T02:34:42ZNathan—Reid2006-12-04————7874 Bayshore DrTAMPAFL33610NULL—
PRVPRV-233022026-04-26T21:37:12ZALICE··—SIMPSON2004-09-19UHC-94887-78UNKNOWN-alice.simpson22@hotmail.com2454 Spring StSacramentoCA95825UNKNOWN····
PRVPRV-262592026-06-20T15:51:01Zbrittany—mendez1946-05-27UHC-75234-10null(982) 501-7689UNKNOWN5701 BASELINE ROADColumbus··oh43234-2724null-
PRVPRV-216092026-07-22T12:03:07ZTimothyTSoto11/09/05··UNKNOWN+1 370 673 0342NULL5441 Sunset BlvdPhoenixAZ85068N/AOPTIONS-PPO
PRVPRV-244552026-08-08T16:40:42ZWei—Carr1977-01-10UHC-15206-89NULLUNKNOWNWEI.CARR77@PROTON.ME——UNKNOWN--N/A
PRVPRV-226712026-08-05T06:18:57ZROBERT—TRAN12-03-1978UNKNOWN—(489) 736-6986··-6155 SPRING STPlano··TX75008-8596—core-hmo
PRVPRV-260572026-07-18T14:34:19Zjessica—miller2/8/1952UHC-28040-04·-582-546-5213—8223 Jefferson AveJacksonvilleFL32252—N/A
PRVPRV-210402026-02-21T10:32:23ZRamirez, Janice——2/17/1973UHC-60736-65•••-••-52842633376732JANICE.RAMIREZ38@AOL.COM4673 SUNSET BOULEVARD·Eden PrairieMN55358N/A—
PRVPRV-202992026-01-19T04:42:06ZBrenda—Weaver1950-07-25··NULL9596460310—5530 GRAND AVENUE Apt 35TampaFL33617NULLnull
PRVPRV-288252026-04-13T21:58:08Z douglas—flores19610708UHC-54916-59•••-••-352513644005721DOUGLAS.FLORES90@OUTLOOK.COM8010 Maple AveFresnoCA93704——
PRVPRV-267672026-09-07T14:41:41ZStewart, Rendy——1955-03-05UHC-05456-20UNKNOWN2529828935··——N/A····-UNKNOWN
PRVPRV-232572026-09-16T23:39:57ZFrannk—Lawrence1979-09-09UHC-94025-69•••-••-37516703725··—·8715 Grand AveAtlantaGA30364UNKNOWNnull
PRVPRV-257332026-06-12T22:04:21ZJordan—Watson05-10-1999UHC-22725-60—825-546-5233—9846 Sunset Blvd··FresnoCA··93708—-
PRVPRV-234592026-03-02T02:35:24ZMichelle—Hansen19520309UHC-96691-01—587-236-4637—4178 Baseline RdCharlotteNC28274····NULL
PRVPRV-227212026-06-23T06:24:28ZDonna··Kim19790312UHC-65496-71•••-••-3452(764) 761-9723-6864 Apache Blvd··Seattle··WA98125null—
9,596 rows, page 30 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:38.454Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty