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
PRV PRV-295742026-03-24T19:20:20ZOlivia—Roes1987-06-10UHC-89527-37—8838448UNKNOWN483 Mesa DriveMiamiFL33161NULLUNKNOWN
PRV PRV-254392026-04-16T17:14:43ZBOBBY—WRIGHT·19950403-—null—8097 CENTRAL AVEEden PrairieMN55323—null
PRVPRV-225992026-07-12T11:10:00ZMitchell, Jack——1965-09-25··—NULL17042190444nullnullUNKNOWN-NULL—-
PRVPRV-231142026-05-27T14:18:45Z·KennethGWells1941-09-05nullNULL+1 967 709 2475-6601 Highland AvenueCHANDLERAZ85284——
PRVPRV-221362026-06-17T10:52:40ZGLORIA—ROGERS1984-03-18UHC-45329-47····UNKNOWNN/A5350 Desert Sky BoulevardATLANTAGA30347NULL—
PRVPRV-219972026-04-12T11:21:41Z MASONXPATTERSON··12/27/1938UNKNOWN•••-••-4570(214) 438-1962MASON.PATTERSON74@HOTMAIL.COM··1492 Willow Ct·Los AngelesCA90039NULL—
PRVPRV-269742026-07-15T11:46:46ZDENNIS—MORRIS1956-08-01UHC-52301-44—452-929-1801dennis.morris48@outlook.com1163 Willow Court Apt 1Minneapolis··mn55485N/A—
PRVPRV-279092026-04-18T22:37:09ZSUSAN—MORRISONFeb 28, 1959··•••-••-5423874-233-4613··—2746 Apache Boulevard·DenverCO80252——
PRVPRV-257022026-04-30T04:10:22ZFrank—Ramos1962-04-07UHC-76600-57··null(638) 748-2280frank.ramos@outlook.comnull—NULL—-·UNKNOWN
PRVPRV-248522026-02-28T14:38:25ZTHERESA—LITTLEFeb 8, 1983uhc-38411-98—3165928045THERESA.LITTLE24@YAHOO.COM5346 SUNSET BOULEVARDDenver·CO·80283-5360—N/A
PRVPRV-220402026-09-20T12:03:47ZDIANE—GIBSON01/07/1978UNKNOWN•••-••-2885+1 728 921 3628DIANE.GIBSON@ICLOUD.COM8641 HIGHLAND AVEAustinTX78720—NULL
PRVPRV-293292026-03-30T17:27:37ZOliviaMAdams19611226uhc-25800-62·-+1 261 275 1520UNKNOWN6363 Hillcrest RoadMinneapolisMN55402N/A·UNKNOWN
PRVPRV-272482026-01-19T17:12:03ZWeclh, HelenG—04/03/1953—N/A895-570-9808helen.welch54@icloud.com2008 Jefferson AveTucsonAZ85766nullselect-epo
PRVPRV-25501 2026-03-23T18:22:08ZKIMBERLY—PIERCE1978-12-17——17875141647KIMBERLY.PIERCE@PROTON.ME8849 Valley View DrColumbusOH43253-·NULL
PRVPRV-279902026-09-29T12:20:58ZOLIVIA—MEDINA1968-07-12UHC-41565-81N/A·3089282390NULL9683 Canyon RoadOrlandoFL32802NULLUNKNOWN
PRVPRV-274492026-01-10T07:35:38ZLe, Roger··Z.—1987-12-14N/A-14346333773roger.le63@yahoo.com9800 Cedar Ln·AustinTX·78739——
PRVPRV-267712026-02-27T00:56:37Zsteve—mcdonald2000-11-28-··•••-••-90513519482263·nullN/AN/A——-UNKNOWN
PRVPRV-268012026-03-23T04:25:11ZMARIA····SCOTT1942-07-07null—(433) 360-8499N/A7104 Church StAustinTX78779NULLNULL
PRVPRV-208332026-01-06T06:01:43ZSARAH—REED17-11-1980—UNKNOWN(428) 882-6213——NULL-—nullN/A
PRVPRV-250502026-02-21T16:04:32ZJEFFREY··NSMITH1979-05-28UHC-31864-23—2968655721UNKNOWN—N/AUNKNOWN—UNKNOWN—
PRVPRV-259742026-07-22T13:51:07ZChristine—Jimenez0822-50-00UHC-90658-11—+1 477 279 7465—7936 Mountain View DriveEden PrairieMN55324-N/A··
PRVPRV-227442026-04-20T11:42:05Z·CAROL—CASTRO07/18/1957UHC-89014-71UNKNOWN(836) 202-4736—7259 MEADOW LNOrlandoFL32837—UNKNOWN
PRVPRV-276842026-01-10T02:54:59ZJean··—Campbell11/22/44—•••-••-7742+1 787 237 0494null3206 Sage CourtDallasTexas75214—MEDICARE-ADV-B··
PRVPRV-261272026-09-27T19:36:00Z·Hill, Cynthia——·Aug 21, 2006UHC-85055-61—203.604.7667cynthia.hill81@yahoo.com3680 Indian School RdTucsonAZ85754—UNKNOWN
PRVPRV-271492026-02-07T16:15:40Z·KELLY—EVANS1943-06-21—·-—null4317 Grand AveMIAMIFL33188N/A·N/A
PRVPRV-204002026-08-21T12:52:48ZSARAY.BRYANT2008-07-23UHC-95119-03NULL890-753-6979-2128 Maple AvenueJacksonvilleFL32211····N/A
PRVPRV-242692026-06-14T18:43:37ZMATEO—ELLIOTT1995-02-27NULLNULL—mateo.elliott@hotmail.com5947 Valley View DriveOrlandoFL32817UNKNOWN—
PRVPRV-276142026-03-15T15:07:18ZNatalie—Reid1987-10-19UHC-17980-94—870-811-1811N/A——NULL-NULLOPTIONS-PPO
PRVPRV-285392026-03-12T22:09:58ZCarlson, Peter——1949-05-26UHC-51214-95UNKNOWN(259) 270-1194PETER.CARLSON@AOL.COM206 Maple AvenueTempeAZ85230··—MEDICARE-ADV-B
PRVPRV-238002026-07-01T05:37:11ZPatriciaWWilliams1987-06-02N/A—641-327-2824-2330 Washington StSan Diegoca92174·UNKNOWNMEDICARE-ADV-B
PRVPRV-217002026-03-11T08:26:41ZMurphy, Scott——1972-02-20UHC-06778-81··•••-••-6836956-658-6171-6185 Church Street··TampaFL33694UNKNOWN—
PRVPRV-227462026-06-22T18:47:46ZElijah—Gray2003-07-26UHC-73436-77•••-••-1636+1 638 296 9891—1329 Elm Street··MinneapolisMN—N/A—
PRVPRV-214442026-08-21T12:27:20ZEMMALCARPENTER06/28/87UNKNOWN—410.900.2257N/A286 Market Street·JacksonvilleFlorida32295N/AMEDICARE-ADV-A
PRVPRV-206342026-01-04T14:40:51ZHamilton, Sara——Jan 11, 1977UHC-62889-75-5066014372UNKNOWN1559 BROADWAYSeattleWA98113-9228——
PRVPRV-247722026-01-04T09:07:36ZElijahRPrice1986-12-26UHC-50102-32—232-315-9074null3333 PALM DRIVEPHOENIXArizona85024—UNKNOWN
PRVPRV-285752026-01-16T15:45:58ZHunter, Camila——1984-09-23N/A•••-••-3520nullCAMILA.HUNTER@PROTON.ME8591 LINCOLN WAYSan DiegoCA92110-—
PRV PRV-221782026-01-28T04:25:40ZJordan—Harris12/25/51UHC-98759-35nullN/A-1233 FOREST AVELAS VEGASNV89120—CHOICE-PLUS-PPO
PRVPRV-205892026-03-08T20:24:48ZCHARLES—ALVARADO19820616-UNKNOWN·908-634-3767—2654 Cedar LnMinneapolisMN55448NULL—
PRVPRV-283462026-01-30T15:18:14ZBRIITTANY—JACOBS1952-07-13·UHC-43748-69—(489) 483-4848null1326 Elm Street··Los AngelesCA90006—NULL
PRVPRV-209512026-03-14T15:15:33ZMontgomery, EvelynA··1980-09-25UHC-11441-18null13807102392—·3702 VALLEY VIEW DR·Eden PrairieMN55379UNKNOWN—
PRVPRV-256222026-04-02T03:42:57ZRussell—Valedz04/09/68UHC-94337-10NULL6368216455russell.valdez24@gmail.com1589 WILLOW CTTampafl33652-5356-N/A
PRVPRV-246372026-09-10T13:19:46Z———1969-06-02UHC-33144-52UNKNOWN18066566365NULL1367 Mountain View Drive Apt 31GLENDALEAZ·85340··N/A
PRVPRV-248652026-08-17T20:23:41ZMELISSA—ANDERSON1981-07-02null·N/A327-603-5760NULL8861 CANYON ROADAtlanta·GA·30362-6631NULLNULL
PRVPRV-243132026-01-01T21:34:53ZBrandonS.Fernandez1986-09-06UHC5840280—(709) 987-5160····4574 Canyon RdSeattle·WA98186—SELECT-EPO
PRVPRV-241372026-01-19T16:38:38ZKelly—Brooks1986-08-21null-+1 537 501 4455—8921 Mountain View DrChandlerAZ85207UNKNOWNOPTIONS-PPO
PRVPRV-216732026-03-08T09:42:52ZJACOBM.··OBRIEN1949-07-03UHC-92455-51NULL···+1 679 433 1722·null9669 Mountain View Dr Apt 37JacksonvilleFlorida32281nullUNKNOWN
PRVPRV-283372026-01-06T12:48:34ZElijahZLe1964-09-23NULLUNKNOWN533.838.9722elijah.le@outlook.com9800 ELM STFRESNOCA93709—NULL
PRVPRV-244812026-08-12T15:32:22Zjordan—bishop2008-09-23nullUNKNOWN7322546561N/A5429 MEADOW LANEPhoenixAZ85083UNKNOWNNAVIGATE-HMO
PRVPRV-271422026-04-20T15:42:00ZSnyder, Judith··—1983-01-13—NULL946.615.8800N/A7887 BAYSHORE DRIVEMesaAZ85282-·UNKNOWN
PRVPRV-25483 2026-03-03T09:43:20ZBrittny—Rios1947-01-13UHC-10619-92—249-612-4145brittany.rios@hotmail.com5474 Hillcrest RdDALLASTX75229nullNULL
9,596 rows, page 55 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:40.623Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty