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-246252026-01-29T10:28:48ZRonald—Fuller1939-02-12uhc-85530-87•••-••-98244367727375——UNKNOWN——N/ASELECT-EPO
PRVPRV-203482026-01-30T22:07:34ZMunoz, Sophia——19770522UHC-32629-21—18549995737SOPHIA.MUNOZ@HOTMAIL.COM6455 RIDGE RDScottsdaleAZ85256—NULL
PRVPRV-285702026-06-23T09:59:01ZWallace, AshleyE.—1961-07-08—····8478064359··null2406 CHURCH ST··TucsonAZ85772—null
PRVPRV-284652026-01-10T02:19:46ZRYAN··—WASHINGTON1986-04-02nullNULL4432045515N/A7264 Lincoln WayGLENDALEAZ85361··—··
PRVPRV-217112026-01-24T15:53:56ZRACHAL—CAMPBELL2005-02-19·UHC-11063-31null682.419.6892N/A3867 CEDAR LANELAS VEGASNV89101-7601nullMEDICARE-ADV-B
PRVPRV-248532026-03-10T04:11:49ZJOSHUAMGIBSON·1945-05-01UHC-44042-29null(944) 638-8631joshua.gibson20@gmail.com5857 OAK STNashvilleTennessee37254·nullNULL
PRVPRV-217652026-07-29T14:03:17ZAhmedX.Harper1954-11-08UHC-87526-51NULL+1 426 359 8581-1661 Central AvenueTampa··Florida33665nullN/A
PRVPRV-213442026-02-26T03:52:44ZSANDRA—STONE12-02-1951—null(770) 633-1421UNKNOWN8768 CHURCH STREETSan DiegoCA92150-—
PRVPRV-268422026-06-19T07:28:10ZJames, Ken——1941-08-01——nullUNKNOWN2485 Baseline RoadGilbertAZ85229—N/A··
PRVPRV-229942026-08-13T16:34:15ZPatricia—Hayes1993-05-27null·N/A6194100159patricia.hayes43@yahoo.com6331 Hillcrest RdSacramento··ca95813nullUNKNOWN
PRVPRV-290442026-04-30T19:48:52Z VirginiaNHarvey1955-12-22NULLNULL537.473.0234—4131 Main StColumbusOH43284NULL—
PRVPRV-268722026-01-12T11:54:08ZHughes, Scott——1997-01-24—•••-••-7701(377) 366-9542scott.hughes@icloud.com2208 RIVER RDOrlandoFL32840—null
PRVPRV-238552026-09-04T01:25:25ZJonathan—Wang8/9/1939··——7423288984N/A4103 Mountain View DriveORLANDOFL·32857-··
PRVPRV-201462026-04-06T05:27:34ZBEVERLYM.SOTO1963-07-03UHC-65304-73N/A(212) 955-4114beverly.soto@aol.com4080 Central AveMinneapolisMN55401——
PRVPRV-239562026-09-11T14:20:14ZPatriciaE.Greene1965-08-26——7617988670—4374 Canyon Rd·NASHVILLETN37259-4507null—
PRVPRV-209832026-02-16T06:53:33ZBARBARA—WEBB1981-06-13UNKNOWN•••-••-7299749-432-0532barbara.webb75@proton.me6837 Pine DrTucsonAZ-—NULL
PRVPRV-276722026-09-03T15:33:20ZLISA—HARRISON05-06-1953NULL··•••-••-7354511-687-8355UNKNOWN6571 Ocean AveDALLASTexas75266-8240--
PRVPRV-268072026-06-11T08:46:41ZALAN—ADAMS1967-08-10—•••-••-789212804951766—3569 Meadow Lane··MINNEAPOLISMN55480UNKNOWN—
PRVPRV-231552026-01-21T02:45:03ZKATHERINEOPORTER1983-04-25UHC-44069-86null+1 282 533 3842UNKNOWN—····—N/AN/A·UNKNOWN
PRV PRV-251672026-06-24T04:19:59ZSEEN··CARPENTER1954-10-05UHC2716558—13493704324sean.carpenter@aol.com4917 Lake View RdSeattleWA98103——
PRVPRV-255162026-03-03T14:42:08Z Cunningham, Jesse——·1980-01-08—-(861) 890-8687—8321 MESA DR··DallasTX75224-5537——
PRVPRV-285452026-06-15T12:31:50ZGomez, Walter——May 22, 1945nullNULL(590) 694-3061··2117 Camelback Road #570ChandlerAZ85299—null
PRVPRV-291112026-07-02T16:34:00ZCHRIS—MEYER1997-06-28—•••-••-6272581-242-6596UNKNOWN———NULL—CHOICE-PLUS-PPO
PRVPRV-226682026-05-18T19:36:01ZDoris—Stewart19680304-—619.451.1077UNKNOWN5776 Sage Court #203MinneapolisMN55480—-
PRV PRV-220832026-05-29T11:38:47ZDanielleNPierce11/16/1956-•••-••-29567716846961·N/A5592 Ocean AvenueAtlantaGA30328-MEDICARE-ADV-A
PRVPRV-289322026-08-17T11:37:23ZLori—Espinoza1971-10-10UHC-27604-26null13344635852-7801 Lincoln WayMesaAZ85227N/A—
PRVPRV-21800 2026-06-08T18:02:30ZTERRYA··BERRY·1992-11-05UHC-47331-48N/A6527557565terry.berry@aol.com7774 Maple AveHouston··TX—UNKNOWNCHOICE-PLUS-PPO··
PRVPRV-268272026-08-27T05:51:58ZJonathanV.Santiago1966-04-23··UHC-29521-60N/A+1 482 851 0911null··—--N/AN/A··
PRVPRV-291662026-05-06T18:23:48ZCarl—Sims··1964-06-26uhc-22625-51—(896) 738-6776carl.sims@icloud.com3056 INDIAN SCHOOL ROAD··TUCSONAZNULL—N/A
PRV PRV-205442026-09-01T15:05:23ZVIRGINIA—VAZQUEZ1995-03-27null•••-••-0705—virginia.vazquez77@gmail.com7732 Palm DrMesaAZ85230—MEDICARE-ADV-B
PRVPRV-249062026-10-08T22:07:07ZWAYNE—ROJAS03/11/1963UHC4489751N/A13146244470UNKNOWN6144 Spring StAtlantaGA30361UNKNOWNNULL··
PRV PRV-290562026-04-19T14:57:26ZAlexander, Mike——Apr 27, 1989UHC-07738-35-18776182850MICHAEL.ALEXANDER@PROTON.ME3873 Market StDallasTX75298——
PRVPRV-269692026-07-15T16:45:13ZAustinCKellyOct 18, 1978NULLnullN/AnullUNKNOWN··nullN/A——
PRVPRV-205572026-05-15T23:56:31ZethanTfullerFeb 12, 1964UHC-06353-04-··632.471.9102ethan.fuller@yahoo.com975 Mountain View DriveNashvilleTN37216null—
PRVPRV-278422026-09-09T07:24:50ZElizabethGReed19500308UHC-55922-83N/A+1 932 566 0609—8057 Palm DriveTEMPEAZ85266—NULL
PRVPRV-228732026-07-13T10:01:14Z Christian—Lynch03-12-1948··UHC3724801•••-••-3381234.962.3799N/A8524 Bayshore DrAustinTX78716—UNKNOWN
PRVPRV-201962026-07-02T17:52:02ZDAVID··MEDINA04/26/06··UHC-31366-75-(530) 515-2628·david.medina79@proton.me—UNKNOWNUNKNOWN——-
PRVPRV-289612026-07-22T09:15:56ZSophia—Soto1949-02-25UNKNOWN—·(562) 243-6561SOPHIA.SOTO@OUTLOOK.COM8505 Ridge RoadJacksonvilleFL32287—null
PRVPRV-260242026-10-15T14:43:31ZJeffreyK.··Carter19570125UHC-22659-67N/A16895492969UNKNOWN4976 Church StMesaAZ85247—N/A
PRVPRV-239002026-01-30T08:15:51Z Jordan—Alvarado03/12/1984null·UNKNOWN(443) 406-7287NULL4827 Lake View RoadFresnoca93725—CORE-HMO
PRV PRV-295772026-05-17T15:51:03ZDOROTHYJBROWN1944-01-28nullNULL680-769-5955·DOROTHY.BROWN@ICLOUD.COM8317 Mountain View DrNASHVILLETN37241-NULL
PRVPRV-232712026-04-12T20:27:08ZROYFWATKINS04/27/55UHC-25431-61UNKNOWN-··—NULL--N/AUNKNOWNMEDICARE-ADV-B
PRVPRV-270762026-06-07T10:08:01ZHarrison, KarenN—01/26/87-—(845) 876-5434null718 CANYON RDJACKSONVILLEfl32207-CHOICE-PLUS-PPO
PRVPRV-27809 2026-10-05T15:56:34ZDeborahSBurns19800112—UNKNOWN2202424505····2696 Willow CourtFresnoca93727—UNKNOWN
PRVPRV-208062026-09-15T17:29:06Zfatima—hansen1942-03-02-N/A(736) 369-2591—4295 Elm StFresnoCA93706UNKNOWNNULL
PRVPRV-257892026-08-24T14:13:46ZHENRYCBROOKS08/28/1980UHC-09209-87··—208.698.1397henry.brooks@hotmail.com9799 PINE DRIVEDENVER·CO·80217-6360··OPTIONS-PPO
PRVPRV-260382026-08-12T18:59:03ZSean—Padilla23-08-1952UHC7139804-··280-239-6017sean.padilla25@yahoo.com1293 HARBOR BOULEVARDEden Prairie··MN55346-2810—-
PRVPRV-213132026-01-17T03:06:08ZRichard—Rios1992-02-23UHC-20691-71UNKNOWNN/AUNKNOWN9572 PARK PLGlendaleAZ85330NULL—
PRVPRV-295202026-05-17T12:52:58ZMelissa—Allen2/25/1954N/A·NULL(837) 652-1130NULL9662 MAIN ST Apt 12ChandlerAZ85284UNKNOWNOPTIONS-PPO
PRVPRV-289152026-02-24T03:38:01ZGeorge—Nelson27-04-1941UHC-72655-13-563-654-4348nullNULLNULLnull-——
9,596 rows, page 118 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:53.109Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty