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-213432026-05-05T08:50:51ZLane, Sofia——8/3/1964N/A·UNKNOWN—UNKNOWN5091 Sage CtSCOTTSDALEAZ85283——
PRVPRV-293022026-10-17T23:51:25ZCAROLYN—CRUZ1942-04-06-—nullnull6979 MARKET STOrlandoFL32876-—
PRVPRV-203492026-08-26T03:38:28ZEugene—Dean10/24/1963—UNKNOWN17625742131eugene.dean80@outlook.com1762 Oak Street #953ScottsdaleAZ85211N/A—
PRVPRV-249112026-04-04T07:06:39ZChristine—Stewart03-01-1946N/A•••-••-046416954879216UNKNOWN412 Palm Dr Apt 12AustinTX78728N/AUNKNOWN
PRVPRV-252482026-04-07T22:02:04ZCARLOS—THOMAS1950-52-15UHC-95358-09—585-643-5143-4110 Camelback RoadMesaAZ85267-UNKNOWN
PRVPRV-226872026-04-05T00:40:28ZNICOLE—CARTER1978-02-06N/A—(292) 219-9419NICOLE.CARTER@GMAIL.COM5698 Grand AvenueHoustonTX77048UNKNOWNMEDICARE-ADV-A
PRVPRV-263562026-01-30T02:42:35ZGEORGEXROBINSON1999-01-11UNKNOWN—(958) 913-8536null4700 Highland AvenueMiamifl33160NULL-
PRVPRV-226042026-01-29T07:56:06ZArnold, EugeneC.····1945-12-07UHC-30243-38-629-605-5945·EUGENE.ARNOLD@GMAIL.COM8379 Valley View DrGilbert·AZ85204NULL—
PRVPRV-206172026-09-20T18:20:19ZOliver—Charlotte4/7/1995UHC-71629-03—289-241-6501—951 Jefferson AveSacramento·CA·95887null-
PRVPRV-20914 2026-07-13T11:41:36Z·vncent—brooks1946-11-09UHC-04330-68—nullvincent.brooks@aol.com1195 Ridge RoadEDEN PRAIRIEMN55300··UNKNOWNN/A
PRVPRV-249412026-01-06T10:02:05ZKAYLA····MURRAY·1988-09-07null—9564426103null6435 Palm Drive··MesaAZ—null-
PRVPRV-249692026-07-15T06:47:26ZDOROTHY—JOHNSON1991-08-11—null-NULL2664 Elm StORLANDOFL32880—NULL
PRVPRV-235302026-04-29T14:21:58ZJUSHUA··ROMERO1947-12-22UHC-88354-80•••-••-1007626-241-2754NULL8508 Harbor BoulevardSACRAMENTOCA95878—·UNKNOWN
PRVPRV-284262026-06-29T11:48:54ZVIRGINIAZ.BOWMAN··1957-09-20····-(318) 766-9881UNKNOWN5826 Hillcrest RdAtlantaGA30346—OPTIONS-PPO
PRVPRV-255072026-06-23T08:02:33ZHowell, Steven——02/19/2008—•••-••-7601482.204.5345steven.howell@aol.com·1820 MAPLE AVE·SACRAMENTOCA95878-7954NULL—
PRVPRV-272572026-08-01T05:46:43ZKaren—Fihser1951-08-16UHC-86096-60•••-••-75872904636058karen.fisher@aol.com6730 BASELINE ROAD #505HoustonTX77092N/ANAVIGATE-HMO
PRVPRV-211812026-05-25T07:46:20ZDEBRA—LAWSON1939-08-19UHC-10156-16null980-429-1247—6946 Market StreetDallas··TX75270——
PRVPRV-207882026-06-24T09:38:29ZLynch, Carl——1955-06-17NULL—412-632-0042null·2173 Highland AvenueCharlotteNC28298null·null
PRVPRV-253702026-07-15T08:31:40ZJOSHUA—HUNTER1956-11-02···UHC-57452-96•••-••-5097(533) 464-6636joshua.hunter@yahoo.com9157 Camelback RdSacramentoCA95833—N/A
PRVPRV-245702026-06-18T17:48:12Z·diegoUschmiidt1989-02-24-UNKNOWN5554641793null····-N/A—null··
PRVPRV-221092026-02-08T23:20:18ZHannah—Rose1969-11-16—N/A(246) 535-5809N/A3727 Sunset Blvd··Denver·CO80280-··N/A
PRVPRV-222912026-08-07T16:34:25Zjulia—·mitchell11/3/1953UHC-66986-06—371-987-5870null9134 Cedar LaneNashvilleTN37211null—
PRVPRV-25264 2026-01-08T23:05:06ZDuncan, Olivia····—·1983-01-27UHC-66759-58—2285278900—894 Mountain View DrTampaFL-·UNKNOWN··
PRV PRV-261152026-06-14T00:16:58ZDONNA—BURNS··19480823UHC3995067NULL(366) 653-8883NULL4001 MEADOW LNSCOTTSDALEAZ85223-3012UNKNOWNN/A
PRV PRV-239022026-04-01T02:55:58ZTYLERXDOMINGUEZ1982-11-27UNKNOWNnull——7545 Canyon RdNashvilleTN37239N/AMEDICARE-ADV-B
PRVPRV-231812026-03-22T09:37:39ZJIMMY—WATKINS0821-59-57UHC-77031-08——NULL3160 Union StAUSTINTX78716··UNKNOWN—
PRVPRV-220692026-02-04T19:23:45ZLarry—Myers2001-02-11UHC-76370-95——LARRY.MYERS34@OUTLOOK.COM6114 Church StATLANTAGA30327nullUNKNOWN
PRVPRV-295232026-08-09T21:39:35ZRALPH—DANIELS2005-10-09N/A•••-••-4690——6510 Lake View RoadMesaAZ85200—UNKNOWN
PRVPRV-209162026-06-19T20:03:39ZPriyaVWest2006-07-03N/A—2154121453·priya.west@proton.me7070 Oak StreetCharlotteNC28252-2871NULLUNKNOWN
PRVPRV-209392026-08-25T09:27:42ZJordan—Jenkins24-07-1964—·NULL478.721.6624NULL1038 Park PlAtlantaGANULL··NULLnull
PRVPRV-237502026-01-11T16:48:28ZRachelIDiaz12/10/1999UHC-34219-67•••-••-3180(526) 652-4855—9301 Highland AvenueNashvilleTN37232-NULL
PRVPRV-242602026-02-10T03:49:27ZPAULZ.COOPER05/19/1984—null··19275331056paul.cooper@outlook.comN/A—N/A··-—·N/A
PRVPRV-240902026-04-17T08:12:53Z Roy—Chavez11/04/39UHC-19953-03•••-••-9551(278) 585-5716roy.chavez50@hotmail.com1429 APACHE BLVDChandlerAZ85295UNKNOWNUNKNOWN
PRV PRV-257382026-01-17T00:30:12ZPATRICK—VALDEZ2004-08-20—•••-••-5939596-324-6416patrick.valdez@gmail.com··UNKNOWNUNKNOWN--NULL
PRVPRV-252822026-01-25T15:12:57ZWei—Rogers11/27/58UHC-04137-54—+1 786 980 5224—4311 MARKET STREETAtlantaGAN/ANULL—
PRVPRV-242562026-06-23T17:35:30ZJULIA—VASQUEZ1956-12-05··UNKNOWNnullNULLNULL7887 Indian School RoadMinneapolisMNN/A——
PRVPRV-248682026-10-12T13:38:11Zraymond—lynch2004-11-18UHC-59681-48•••-••-99548789221490null1709 Union StreetAustin··TX78751nullSELECT-EPO
PRVPRV-266382026-02-19T02:16:18ZZACHARY—GEORGE2/19/1982·UHC-68384-52•••-••-7465N/AZACHARY.GEORGE4@GMAIL.COM8626 RIDGE RDSEATTLEWA··98123UNKNOWN—
PRVPRV-21552 2026-05-09T14:14:22ZELIJAH—SCHULTZ05/16/82null··•••-••-4545588-651-9766null6187 Pine DrTampaFL··null·N/ACORE-HMO
PRVPRV-246952026-03-27T10:30:59ZSantiago····Munoz1974-11-16··UHC-86970-76····843-777-5065santiago.munoz@yahoo.comnullnull—-NULLCHOICE-PLUS-PPO
PRVPRV-256682026-10-11T23:00:54ZmarthaBmoore2008-06-02UHC3538055····9028019585··martha.moore@icloud.comUNKNOWNN/AN/ANULLN/AUNKNOWN
PRVPRV-251242026-08-20T10:48:57Z·Patterson, Michael——07/25/50·UHC-52330-39UNKNOWN534-475-7314··NULL9741 SUNSET BLVDMesaAZ85226—-
PRVPRV-207032026-04-24T04:09:12Z·Randy—Harrison1985-11-20—NULL(712) 455-2893-···5559 SAGE CTChandlerArizona85226-5576NULL—
PRVPRV-231982026-05-20T18:43:43ZBurke—Omar··Feb 3, 1949UHC-25889-13-467-421-7776NULL6704 Washington StreetGlendale··AZ85336UNKNOWNCORE-HMO
PRVPRV-293942026-08-07T22:16:05ZSTEVE····SANTIAGO··1963-04-22UHC-44779-58NULL5734295745UNKNOWN7267 HILLCREST ROADATLANTAGA··30320—MEDICARE-ADV-A
PRVPRV-255772026-02-20T19:21:26ZHELEN—GREEN1982-02-24uhc-73031-46•••-••-82694025457613N/A3097 Maple AveSeattleWashington98186nullN/A
PRVPRV-236082026-10-15T18:56:19ZGloria—Meyer04/17/1997—•••-••-626617262763795gloria.meyer46@hotmail.com1137 PINE DRIVEHoustonTexas77008—UNKNOWN
PRVPRV-250382026-03-07T16:59:42ZJACQUELINE—WALKER1999-08-16nullN/A7758403384null7619 Oak StMesaAZ85255—OPTIONS-PPO
PRVPRV-284742026-09-02T12:26:14ZRoger··Ross12/27/2000UHC-76258-52UNKNOWN··+1 803 959 7753—5420 Valley View Drive #345San AntonioTXN/Anull—
PRVPRV-229762026-02-23T20:48:36ZShirleyNJames1958-03-17NULL—····UNKNOWN—UNKNOWN—·NULL—-
9,596 rows, page 98 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:49.093Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty