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-261872026-03-25T05:03:01ZStephanie—Harper1964-06-15··UHC7422077—14434033199—2829 Cedar LaneOrlandoFLnull—CHOICE-PLUS-PPO
PRVPRV-208352026-04-02T23:40:18Zjames··reid··20081013UHC-04022-72—8103721681JAMES.REID@HOTMAIL.COM5685 Sage Ct·ScottsdaleAZ—NULLNAVIGATE-HMO
PRVPRV-228992026-06-28T17:55:54ZPHILIP—·MONTGOMERY1947-11-16UHC-95197-13•••-••-5414(972) 455-0747N/A·2672 Spring StreetSAN ANTONIOTX78211NULLNULL
PRVPRV-220902026-03-01T12:57:21ZHannahQ.Tucker··19571108UHC-11072-98-7217963172—7083 MARKET ST·SAN DIEGOCA92120null-
PRVPRV-288892026-06-28T06:03:28ZCHARLES····BUTLER19-10-1963UHC-33196-93NULL846-280-1030··CHARLES.BUTLER62@ICLOUD.COM7058 Central AveMIAMIFlorida33187NULLN/A
PRVPRV-260852026-05-11T03:10:56ZAnn—Nunez1988-07-19UHC-74358-70—UNKNOWNnull2786 Hillcrest RoadAtlantaGAUNKNOWN—NULL
PRVPRV-286522026-03-31T08:38:47ZmasonR.perkins1988-11-23UNKNOWN··(500) 262-7692mason.perkins98@gmail.com7401 Forest AveSeattleWA··98133UNKNOWNNULL
PRVPRV-243842026-04-19T22:15:00ZAmanda—Parker02/27/1947UHC-47167-27—293-829-8489NULLnull··——nullUNKNOWN—
PRVPRV-213722026-05-10T10:11:01ZGarrett, Brandon··—1/28/1991N/A-740-379-1532null·1797 Park PlaceHOUSTONTX77087-NULL
PRVPRV-278852026-07-09T22:21:22ZSandraFRoberts1941-06-03UHC-36051-31-+1 493 791 9974N/A·2636 Union StAustinTexas·78751——
PRVPRV-237762026-03-16T03:32:46Zjudy—stevens1962-08-11UHC-82487-20•••-••-3696·-JUDY.STEVENS58@HOTMAIL.COM3652 Palm DrLos AngelesCA90041··—-
PRVPRV-242372026-04-12T07:01:25ZashleyOvaldez1999-02-10····—235-862-3232ashley.valdez@hotmail.com483 Hillcrest RoadGlendaleAZ·85388N/AN/A
PRVPRV-277472026-02-26T12:23:58ZDorothy—Smiht·10/07/2003UHC-01581-36—UNKNOWNdorothy.smith84@icloud.com624 Central Ave·GilbertAZ····——
PRVPRV-252432026-09-09T03:43:34ZEugene··Graham2004-10-26UNKNOWNUNKNOWN·274-253-0457-1088 Maple AvenueFresnoca93725—-
PRVPRV-218602026-01-27T05:38:06ZWILLIAMVSNYDERJun 7, 1941—null19102846823N/A··1256 BASELINE RDMESAAZ·85266··—
PRVPRV-254272026-08-06T18:21:03ZLarwenceW.Lanne2006-08-09··-—NULL—2237 CAMELBACK RDLOS ANGELESCA90083NULL····
PRVPRV-268622026-08-23T19:22:27ZAan—Rios1956-06-13··UHC-34823-98•••-••-8437(779) 299-4397—7829 Union Street··NashvilleTN37200-OPTIONS-PPO
PRVPRV-228782026-04-09T07:05:11ZHANSON··ELIJAH03/04/2003UHC1170839N/A··4045252elijah.hanson@outlook.com119 Indian School RdJacksonvilleFL32200UNKNOWNnull
PRVPRV-230812026-08-27T07:38:50ZHarper, WayneF—1947-08-10UHC-60257-75N/A(338) 940-2227—6090 Church St··ColumbusOH—UNKNOWNUNKNOWN
PRVPRV-23424 2026-08-27T12:38:38ZDominguez, MariaS·····1985-05-22UHC-32345-88•••-••-1164(870) 894-5614—6206 LINCOLN WAYDallasTX··75254--
PRVPRV-246382026-09-30T16:27:45Z Diego—Jimenez1957-09-14UNKNOWN·····720-452-0066N/A—null——-UNKNOWN
PRVPRV-288162026-06-21T18:23:59ZJoshua—Stewart19880215··NULL-6618979534joshua.stewart@aol.com1223 Sunset BlvdSeattle·WAN/AN/A-
PRVPRV-276242026-02-10T03:16:40ZEllis, Donna——1965-07-03UHC-56478-17•••-••-7670(377) 693-4209donna.ellis@hotmail.com·4083 Desert Sky BoulevardJacksonvilleFL32293——
PRVPRV-230152026-04-17T09:57:23ZRojas, Gary——1962-07-15UHC-95184-37•••-••-0673(202) 739-6086·gary.rojas@outlook.com350 Union StreetGilbertAZ85259N/Anull
PRVPRV-231602026-07-26T13:18:55ZEllis, Madison——·1974-10-12UHC-31543-85-639.311.6193UNKNOWN5893 Central Ave·ATLANTAGeorgia30385··—-
PRVPRV-218232026-08-27T05:01:26ZWalker, Jeremy—··1958-05-11UHC-68255-89UNKNOWN(403) 760-6114jeremy.walker59@gmail.com7404 Lincoln WaySeattleWAnull··NULL····
PRVPRV-23224 2026-06-01T17:44:49ZJUAN—GILBERT·2007-03-14UHC-46118-29N/A——354 Baseline RoadJacksonvilleFL32286N/AUNKNOWN
PRV PRV-266492026-06-15T20:39:33ZRalphAMendoza11/3/1977UHC-00344-49—(779) 309-2735-NULL—-—null—
PRVPRV-224202026-03-20T09:33:10ZPriya··Z.Clark1940-07-26UHC-40047-74UNKNOWN7576815457priya.clark96@aol.com-N/ANULL——UNKNOWN
PRVPRV-217032026-06-22T22:41:51ZBenjamin—Harvey1949-06-01—UNKNOWN619-605-2892N/A2760 APACHE BOULEVARDTucsonAZ85744—NULL
PRV PRV-29437 2026-01-03T20:33:00Z·DianePPerkins1983-03-17UHC-00538-27—5653158527—4580 Hillcrest RoadGlendaleAZN/AN/A—
PRVPRV-261012026-05-30T04:09:42ZcarlMsantos1997-03-31NULLUNKNOWN··—carl.santos47@gmail.comUNKNOWNnullN/ANULLUNKNOWNnull
PRVPRV-292962026-02-11T10:59:40ZBeverly··Warren1949-07-15UHC-50109-81—7195317beverly.warren@proton.me·null—UNKNOWN--··-
PRVPRV-291212026-08-21T20:01:15ZELLIOTT—ALEXIS1965-02-04N/ANULL900-874-5288NULL9576 CEDAR LANE·AtlantaGA30344nullNULL
PRVPRV-244872026-04-20T14:37:29ZFRANK—GREEN1939-11-11··N/ANULL13679155748—7747 HILLCREST RDSAN ANTONIOTX78260—OPTIONS-PPO
PRVPRV-233372026-07-10T00:54:15ZAhmedIPatel2005-02-09UHC-86063-13null(612) 397-0918-7258 Apache BoulevardAustinTexas78766NULL-
PRVPRV-259042026-02-07T21:33:29ZChristopher—Bishop··09/28/81·N/A—7563258032—9509 Forest AvenueHOUSTONTX77078-1335NULLnull
PRV PRV-281842026-09-16T21:53:45ZWei··Johnson11/23/1980UHC-52953-76NULL+1 826 342 5733—9776 FOREST AVESacramentoCA95855—NULL
PRVPRV-218962026-02-02T13:24:32ZHIROSHIPNUNEZ1976-12-20—N/A+1 490 907 2204··—9881 Forest AvenueGilbertAZ85215—-
PRVPRV-235432026-07-14T10:20:31ZJACOB—CAMPBELL1958-03-04UHC-01919-31N/A2478013UNKNOWN9605 PARK PLACEJacksonvilleFL32246UNKNOWNNAVIGATE-HMO
PRVPRV-288462026-04-14T10:11:46ZHANNAH—FLORES1954-07-12··UNKNOWN•••-••-98065977160199—7702 Main Street #610MinneapolisMN55432—NULL
PRVPRV-205132026-01-14T23:23:33ZDorothy··—Jacobs02/04/1942—NULL432-201-1656····2626 River RoadFresnoCA93771UNKNOWNN/A
PRVPRV-217692026-06-06T03:03:24ZKATHLEEN—DANEILS19390311UHC-48830-22N/A7426086699kathleen.daniels@hotmail.com5667 LAKE VIEW RDMesa·Arizona85201nullNULL··
PRVPRV-232432026-08-09T15:32:43ZRebecca—Wagner11/21/2004··N/A·-——451 MOUNTAIN VIEW DRMESAAZ85270NULLMEDICARE-ADV-A··
PRVPRV-289572026-05-19T13:09:25ZPETER—·BURTN1996-12-18-NULL+1 782 501 9637—9727 Cedar LnHoustonTX77034——
PRVPRV-200162026-06-16T05:16:31ZSMAANTHA—YOUNG04/28/90UHC-43942-38··•••-••-3842--5157 HARBOR BOULEVARDSan AntonioTX·78231—NULL
PRVPRV-29183 2026-04-24T02:47:39Zdenise—gibson1973-06-15—UNKNOWN572.700.6996····3493 Elm StreetCharlotteNC28256··UNKNOWNmedicare-adv-b
PRVPRV-282132026-10-09T08:19:42ZChapman, JesseQ··1968-06-27null··UNKNOWN(622) 524-4840—2417 Willow CtDenverCO80227N/AOPTIONS-PPO
PRVPRV-287662026-04-04T06:52:42ZBettyQSandoval1944-09-25UHC-13305-47-435-423-6348N/A1080 Desert Sky BlvdDallasTX75227nullselect-epo
PRVPRV-294872026-05-25T06:17:32ZCastillo, Lucia——1989-12-02-•••-••-5515—LUCIA.CASTILLO@ICLOUD.COM413 Ocean AvenueMiami··FL33108UNKNOWNUNKNOWN
9,596 rows, page 139 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:56.140Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty