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-281632026-06-28T06:47:15ZKyle—Cunningham19880105UHC-72150-81null—null-N/A—N/Anullnull
PRVPRV-254082026-09-14T08:27:01Z·Mark—Green09/03/1989N/AUNKNOWN8669707947—9414 Pine DriveSacramentoCA95881——
PRVPRV-25256 2026-09-13T16:21:30ZEthanNGibson1948-05-01··N/A•••-••-4608(271) 300-9067—6002 Market StDenverCO80237····—
PRVPRV-282622026-02-25T22:51:08Zmarilyn—kellyJun 28, 1971—-9675299588———N/AUNKNOWNNULLnull
PRVPRV-212752026-08-16T05:22:34Zlucia—wood1943-05-22UHC-17073-62NULL—-8150 PINE DRFRESNOCA··——··
PRVPRV-203942026-03-12T09:22:05ZPATRICIA—WALSH03/07/1973UHC-68799-69—(949) 538-6870-882 HIGHLAND AVENUEScottsdale·AZ85241UNKNOWN—
PRVPRV-214072026-07-25T18:46:25ZStevens, ScottX···01/08/94·UHC-77093-82—N/AN/A4455 Main StAustin··TX78723UNKNOWN·UNKNOWN
PRVPRV-202172026-07-05T22:17:40Z Jacob—OBrien1953-12-07NULL•••-••-12708974392985··—NULLnullUNKNOWNNULLnull
PRVPRV-214662026-09-12T17:05:41Zwilliam—ross1984-03-20UNKNOWNN/A(351) 775-3659null9411 Hillcrest RdTAMPAFL··33647null-
PRVPRV-275282026-07-31T21:35:45ZMARILYN··—RICE09/13/41UHC-69910-24··null·4712389955—1406 Ocean Ave·NASHVILLETN37235N/AMEDICARE-ADV-B
PRVPRV-226292026-09-06T12:34:31Zwalter—clark3/6/1980—UNKNOWN—walter.clark28@proton.me·3926 Lincoln WayJacksonvilleFL32298nullNULL
PRVPRV-274512026-02-08T20:22:31ZGLORIA—CLARK08/27/76null—(797) 678-7660-—————NULL
PRVPRV-216492026-08-31T11:29:45ZChristopher—Payne05/20/2000UHC9502302N/A6947650155—6425 Desert Sky BlvdMiami·FL33151····CORE-HMO
PRVPRV-216462026-10-02T02:43:36Zhelen··lynch1940-04-19null•••-••-145217927927574··465 Highland AveFresnoCA93721NULL—
PRVPRV-209742026-09-26T23:56:53ZDOUGLAS··—RUIZ1997-09-11UHC-49143-85•••-••-82186872030382UNKNOWN··4282 Meadow LnTempeAZ·85246—OPTIONS-PPO
PRVPRV-204152026-05-14T15:55:34ZAdam—Saners19981216—NULL(901) 396-8821adam.sanders90@yahoo.com8671 Valley View DrFresnoCA93713—NULL
PRVPRV-294002026-08-03T18:52:15ZRogerS··Wang2/4/1950——15287310709—5745 JEFFERSON AVENUECharlotteNC28271—·MEDICARE-ADV-A
PRVPRV-247792026-04-13T06:48:25ZJOSHUA—PORTER·Aug 5, 1966—N/A—-6813 Maple AvenueSCOTTSDALEAZ85226-5156—NAVIGATE-HMO
PRVPRV-216352026-06-21T18:31:35Z JACK—ORTIZ·1957-12-15uhc-23081-51•••-••-7576945.482.0627N/A—NULL—NULL-·UNKNOWN
PRVPRV-265222026-07-19T23:45:19ZJames··E·Williams1985-08-22UHC-59391-53N/A9468850124NULL1733 Canyon RoadMinneapolis·MN55431-8565—null
PRVPRV-222342026-09-23T01:57:54ZLarry—Ortega··19670218··—•••-••-6306846-290-4302UNKNOWN2939 SAGE CT·PlanoTX75014··—-
PRVPRV-270682026-01-30T04:28:53ZDanielle—Lee1963-06-15—-··6169152305··danielle.lee@yahoo.com5751 Desert Sky BlvdDallasTXUNKNOWNN/A····
PRVPRV-264652026-07-05T13:21:13ZRachelYFlores2001-04-19null•••-••-7269-rachel.flores@proton.me·3695 Maple AveHouston·Texas77045-1280··UNKNOWNMEDICARE-ADV-B
PRVPRV-200992026-03-14T11:01:53ZAna—George1976-08-11UNKNOWNnull539-347-6904—610 Maple AvenueMinneapolisMinnesota55469NULLN/A
PRVPRV-20766 2026-01-18T04:28:22ZSEAN·VSTEVENS1989-01-21N/A—(972) 843-2516sean.stevens50@gmail.com··7458 Grand AvenueChandlerAZ85227—N/A
PRVPRV-228912026-08-30T21:08:51ZKeith—Day1998-05-16UHC-81898-71UNKNOWN2253257916keith.day1@gmail.com6826 Sunset BoulevardSan AntonioTexas78232UNKNOWNCORE-HMO
PRVPRV-279932026-01-02T10:01:34Z·Lawrence—Fuller12/09/2000UHC-49156-23•••-••-67119783604569—UNKNOWNN/A·NULL——null
PRVPRV-240532026-06-08T11:04:17ZGrace—Elliott1991-04-24UHC-39662-05null424-318-0936—8435 Grand AvenueDallasTX75264—MEDICARE-ADV-A
PRVPRV-283132026-01-22T05:16:04ZJaetYGuerrero·07/16/43—•••-••-6019NULLjanet.guerrero92@yahoo.com2649 Elm StSacramentoCA95839—CORE-HMO
PRVPRV-255982026-09-29T18:02:21ZArjun—Rojas12/11/1990--459-454-1601ARJUN.ROJAS@PROTON.ME9833 Jefferson AvenueChandlerAZ·85299——
PRVPRV-250172026-04-05T02:33:12Zgonzales—·nathan2006-02-18UHC-41893-36UNKNOWN16422183948nathan.gonzales53@aol.com4173 Desert Sky BlvdOrlandoFL32875NULL—
PRVPRV-292852026-04-27T17:44:24ZloganWclark08/06/96UHC-45189-88-(341) 568-7063N/A3642 Meadow Ln·Las VegasNevadaUNKNOWNUNKNOWNCORE-HMO
PRVPRV-239832026-06-03T01:58:13ZAaron—Bailey1938-10-12UHC-83010-96•••-••-2289+1 341 445 6706·AARON.BAILEY@ICLOUD.COM3294 Elm Street·EDEN PRAIRIEMN55325null—
PRVPRV-204972026-04-26T11:08:45ZRalphC··Harper06/14/50··NULL—822-426-6008—712 Elm StreetPlanoTX75055-··—
PRVPRV-249072026-01-30T13:57:54ZBowman, Jerry··——1954-04-03UHC-10796-06—·(215) 755-2230—5417 OAK STREETEden PrairieMN55347-··
PRVPRV-206992026-03-24T01:30:46ZAustinMYang19830718·-—18615822064-9563 River RdLos AngelesCA90099-null
PRVPRV-246802026-10-08T08:55:32ZLISAY.·GRAY·2004-05-26UHC-96835-03—5925444149N/A··1231 Hillcrest RdChandlerArizona85212——
PRVPRV-214022026-04-06T06:19:38ZTHOMAS—KELLY01/02/07N/A—(229) 706-9126N/A5871 Highland AveCharlotte··North Carolina28261-—
PRVPRV-277582026-03-27T16:37:26ZBrittany—Walsh1984-05-09·UHC-72666-02—(966) 401-3822—6263 Forest AveDenverCO80220N/AUNKNOWN
PRV PRV-226142026-02-15T07:22:48ZJames—Park2008-04-11UHC6755444UNKNOWN+1 829 499 5123UNKNOWN5255 Church StSeattle··WA·98113—-
PRVPRV-276292026-05-11T15:34:30ZRobertson, Eric——20080710UHC-01745-78—2186271767—3096 UNION STREETFRESNOCA93766··N/AUNKNOWN
PRV PRV-292162026-09-07T21:25:13ZRoger—Reid1961-06-04··UHC-97347-56—(315) 712-7510roger.reid@yahoo.com9877 Valley View DriveSacramentoCA95880—·UNKNOWN
PRVPRV-226622026-01-26T11:56:12Z JOYCE—PATTERSON1973-07-17··UHC-06691-69-12577197097N/A4507 HIGHLAND AVESan Antoniotx78278-5111N/A—
PRVPRV-254422026-03-23T12:54:55ZisabellaNguerrero10/01/93UHC-86915-27•••-••-2296414-811-8317—1635 Church StreetSacramentoCA95841··nullUNKNOWN
PRVPRV-211702026-09-04T01:08:59ZHELEN—HICKS1962-07-12UHC-81077-42—7554680846null6150 CEDAR LANEDALLASTX75280NULLnull
PRVPRV-285202026-08-01T09:31:29ZEmily····Nichols—NULL——null-—N/Anull—NULL
PRVPRV-222632026-07-08T05:53:36ZJacobUMills1972-01-05—-16163873521N/A4896 Mountain View DrHOUSTONTX77034-8536nullN/A
PRVPRV-223742026-02-13T07:32:49Z·JOSE—MALDONADO1953-02-07UHC-41703-31—766-348-2447jose.maldonado6@hotmail.com5368 Camelback RdLos Angeles··California90014-4305—NULL
PRV PRV-294132026-05-28T13:54:30ZMichelle—Ramos07/08/1976UHC-95677-22UNKNOWN5908119462···7537 PARK PLCharlotteNC28246N/AUNKNOWN
PRVPRV-202162026-04-19T10:30:15ZkarenT.rojas1996-05-21·UHC-95344-65—903-838-4737NULL6039 Sage Court #528MiamiFL33184—NULL
9,596 rows, page 60 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:43.420Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty