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-26112 2026-09-21T01:15:11ZMelissa—Hansen1996-03-18UNKNOWNN/A710-965-0472—5176 Lincoln WayLas VegasNV89109—N/A
PRVPRV-239182026-07-06T09:10:29ZEDWARD—COOK1976-03-25UHC-04537-80•••-••-6867(504) 735-0885—39 Mesa DrEden PrairieMN55302-1024null·CORE-HMO
PRVPRV-237342026-10-16T07:30:05ZBradlay, Robert—····19770708UNKNOWN——ROBERT.BRADLEY36@YAHOO.COM———··——
PRVPRV-286262026-06-15T21:26:03ZALEXIS—·ORTIZ19690806UNKNOWN··•••-••-8816216-546-7010NULL9086 Hillcrest RdSan DiegoCA92184··NULLOPTIONS-PPO
PRVPRV-245172026-02-11T12:02:53ZMarianaHHarrison2007-03-03··UHC-02249-15·null5877232833mariana.harrison37@gmail.com5365 UNION STGlendaleaz85337NULL—
PRVPRV-24824 2026-05-17T18:31:40ZHanson, JoyceE··—1944-01-14—---2684 Grand AvenuePlanoTX75062N/Anull
PRVPRV-205672026-04-15T09:32:15ZSaraRHolmes1941-12-28··UNKNOWN—439.437.9229—31 Cedar LnFresno··ca93736N/A—
PRVPRV-287482026-07-08T02:26:34ZKevin—Guzman2507-16-93—null(278) 880-8571NULLUNKNOWN—··-N/ANULL
PRVPRV-241472026-02-27T18:24:47ZDiego—Cole10/23/2004null•••-••-3122754-832-7846diego.cole16@proton.me2462 SAGE CT··SACRAMENTOCA95810-··-
PRVPRV-288872026-10-08T10:21:30ZEmily—Garcia1950-12-25nullUNKNOWN—EMILY.GARCIA@HOTMAIL.COM9327 Union StreetCHANDLERAZ85283-9788——
PRVPRV-267942026-08-27T09:08:24Zbobby—powell1941-09-10UNKNOWN—15786488115-N/AN/A——N/A-
PRVPRV-261652026-01-22T09:03:48ZCastro, WilliamC.··1978-30-24UHC-34758-35null(862) 823-8259william.castro@yahoo.com·5084 Park Pl Apt 2EDEN PRAIRIEMN55342—NULL
PRVPRV-292272026-07-09T19:00:39ZLARRY—·WONG10/2/2001·UHC-68223-92•••-••-01467385895507·-5452 Ridge RdOrlandoFlorida·32886NULLchoice-plus-ppo
PRVPRV-234822026-03-02T15:33:29ZBILLY··LAWSON05/13/89N/A—(320) 798-4306·UNKNOWN2366 OAK STColumbusOHUNKNOWN——
PRVPRV-262832026-08-02T12:05:48ZHiroshi·ZPierce2005-12-01UHC-54268-51—444.461.9104hiroshi.pierce75@proton.me3552 Apache BoulevardDENVERCO80228—UNKNOWN
PRVPRV-207782026-04-20T19:16:40Z THOMPSON—ROBERT17-07-1976UHC-19770-53——ROBERT.THOMPSON@YAHOO.COM6258 Camelback Rd #108HoustonTX77022—·OPTIONS-PPO
PRVPRV-252322026-08-27T16:43:44ZJACKEMEYER1996-06-12N/A•••-••-90338928493974N/A8203 MESA DRIVE··San DiegoCalifornia92140·NULL—
PRVPRV-237902026-01-09T10:23:34ZPatrickESchultz2006-01-59·N/ANULL4855623762patrick.schultz19@aol.comnullN/A——N/Anull
PRVPRV-215592026-03-30T20:57:01ZWarren, RyanZ—1946-08-13UHC-88581-01—(219) 583-5859NULL243 Sunset Blvd Apt 12··Nashville·TNnullNULLCORE-HMO
PRVPRV-224002026-05-01T01:04:00ZSofia·····Porter2002-07-04UNKNOWN•••-••-7247230-434-9910N/A1396 Apache BlvdAustintx78708—UNKNOWN
PRVPRV-280392026-07-02T09:26:49Zphilip····wellsN/A-—609-201-2456UNKNOWN·5226 Baseline RoadSAN ANTONIOTX78229NULL-
PRVPRV-207122026-03-10T03:00:41ZAUSTINZPALMER1405-91-87UHC-12179-42—·9546747694N/A8866 Hillcrest Rd·MinneapolisMN55498null-
PRVPRV-247182026-02-16T05:34:00ZJORDAN—YOUUNG·2006-12-19-·UNKNOWN2956700581JORDAN.YOUNG@ICLOUD.COM4637 Highland AveFresnoCA93791N/A-··
PRVPRV-235332026-10-18T09:56:51ZKatherineU.Howell04/08/06UHC-24751-04•••-••-9892+1 736 640 8835—·6115 INDIAN SCHOOL RDLOS ANGELESCA··90004——
PRVPRV-247782026-09-02T10:43:02ZLe, AustinA—Mar 20, 1972UHC-07743-05-(513) 514-7533null8887 SAGE COURTMesaAZ85247——
PRVPRV-200832026-05-25T21:58:47ZJACK—BROOKS1995-06-08UHC-96259-40UNKNOWN872-288-2723N/A2490 BroadwayMESAAZ85275—OPTIONS-PPO
PRVPRV-202182026-02-08T14:32:13ZJake—OBrien1952-12-07UHC3581935N/A897-439-2985N/A6666 Mountain View Dr Apt 37·DALLASTX75200N/A-
PRVPRV-248132026-02-24T15:59:09ZTimothy—Freeman1992-07-09UHC3402560•••-••-1458(931) 696-6389······5657 Market StreetSeattleWA———
PRVPRV-241692026-08-16T11:51:21Z·Adam··Chapman1985-07-19nullUNKNOWN573-961-9826N/A8709 Sage Ct·Eden PrairieMN55360—N/A
PRVPRV-282102026-01-14T10:06:27ZRAYMONDQ.··REED1997-07-04UNKNOWN--raymond.reed@proton.me8798 Lincoln WayOrlandoFL32856-0057——
PRVPRV-237742026-03-16T10:12:54ZAlexis··IWillis5/20/1980NULLnull··13188242364null··2662 Valley View DrTempeAZ85267UNKNOWN-
PRVPRV-216002026-07-30T06:13:14ZLarryW.Spencer9176-10-23UHC-16960-57··•••-••-91304263912larry.spencer@proton.me5830 Lake View Rd #488·MiamiFL33139—-
PRVPRV-236912026-03-28T15:45:48ZEmily—Murray02/20/92UHC-96474-99—676-758-6829emily.murray@gmail.comnullnull—NULL—·N/A
PRVPRV-251722026-01-03T11:55:51ZKenneth—Masun1962-08-27UHC-03925-28null270-754-6714KENNETH.MASON10@OUTLOOK.COM8342 WASHINGTON STREETCharlotteNC28233N/A—
PRVPRV-243392026-09-18T12:05:00ZWeber, Julia··——1984-11-10N/A—8412412678—7153 LAKE VIEW ROADLas VegasNV89124-MEDICARE-ADV-B
PRVPRV-236602026-08-30T07:17:27Zolivia—dominguez1977-08-09UNKNOWN•••-••-5419(439) 961-4950N/A7574 Bayshore DriveScottsdaleAZ—UNKNOWN-
PRVPRV-217372026-01-10T11:05:57ZJimenez, Lawrence W.——9/25/2008UHC-86182-19NULL+1 929 321 8124UNKNOWN8191 Valley View DriveSan AntonioTX78280null—
PRVPRV-218322026-03-07T16:02:57ZANDREAZMORGAN19360221--3905179077N/A··125 Apache Boulevard··TempeAZ85201UNKNOWNN/A
PRVPRV-230672026-03-06T22:33:17ZSTEPHEN··—SMITH12/5/1942UHC-26563-91•••-••-6590710-312-9215STEPHEN.SMITH@GMAIL.COM2624 Mountain View DrSAN DIEGOCA92113··N/AUNKNOWN
PRVPRV-202832026-04-29T05:00:44ZMASONNREYNOLDS1978-09-19NULLnull471-389-0386N/A4261 OCEAN AVE Apt 11··DallasTX75209—CORE-HMO
PRV PRV-240182026-04-08T19:41:29ZJuan··—Welhc1959-01-05UHC-99208-18•••-••-04923478201851null4917 PARK PL··San AntonioTexas78227NULL—
PRVPRV-235392026-09-06T06:46:14ZGuerrero, Ralph K··——19910408UNKNOWNN/A(891) 598-9226ralph.guerrero61@gmail.com3786 Palm DrivePlanoTX··75010null—
PRVPRV-282032026-01-06T11:26:36ZMaetoQMiller2000-08-15UHC-99133-72null7718582429mateo.miller58@yahoo.com1423 Spring St #916NASHVILLETN37299N/AOPTIONS-PPO
PRV PRV-281712026-01-20T20:52:28ZDanielle··U.Wood1995-10-05--N/AN/A2117 Washington StMinneapolisMN55443—NULL
PRVPRV-267422026-03-22T16:13:20ZRussellF.Lee1966-02-19uhc-71483-82—(572) 318-2318RUSSELL.LEE1@YAHOO.COM336 Forest AveDenverCO·80279—SELECT-EPO
PRVPRV-259152026-09-01T23:00:22ZWayne—Ray1973-12-03UNKNOWNUNKNOWN929-700-3107—7029 Cedar LnJacksonvilleFLN/A-MEDICARE-ADV-B
PRVPRV-276542026-09-29T16:41:45Z AishaVWilson02/01/1964UNKNOWNnull(658) 331-7945aisha.wilson13@hotmail.com2473 Bayshore DriveNashvilleTN··37229NULLN/A
PRVPRV-26755 2026-06-27T00:27:12ZAMBER—·NICHOLS2004-09-27UHC9627449—(405) 310-9992··2520 River RoadScottsdaleAZ85269—null
PRVPRV-211302026-02-10T04:43:52ZMartha—Hall1974-09-23——+1 804 715 7691martha.hall@hotmail.com1786 GRAND AVEOrlandoFL32848NULLnull
PRVPRV-221872026-10-14T14:27:41ZtimoothyQ.howell1992-10-18—·null(415) 570-4020timothy.howell@proton.me4080 Meadow LnCHANDLERAZ85297—N/A··
9,596 rows, page 124 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.142Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty