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-203432026-01-05T23:13:51ZJAMES—BRYANT16-12-2000N/A——JAMES.BRYANT23@YAHOO.COM8331 MESA DRIVEGLENDALEAZ85377--
PRVPRV-28300 2026-04-15T00:09:39ZBrittany—Moore1952-10-22——677-265-0694brittany.moore@yahoo.com2008 Park PlaceAtlantaGA30323··—CORE-HMO
PRVPRV-284952026-02-19T07:16:13Zjoe—burns14-01-1984uhc-76864-14•••-••-868516398077273null3433 Indian School RoadHoustonTX77076-N/A
PRVPRV-235492026-09-27T01:27:59ZIsabella—Black09/02/1988——(868) 657-4633—521 Spring StSAN DIEGOCalifornia92104NULL—
PRV PRV-207062026-05-25T16:08:52ZPatrick—Carter·1986-11-22UHC-68722-56•••-••-8707(593) 378-6815PATRICK.CARTER11@ICLOUD.COM9383 WASHINGTON STREETSan DiegoCA92101null—
PRVPRV-206922026-07-06T14:59:33ZPeter—Vazquez2002-04-11uhc-44962-11—822-859-7955N/A8624 Cedar LaneTempeAZ85219-5219nullCORE-HMO
PRVPRV-215982026-04-13T04:47:53ZNATHAN—TUCKER1982-07-18—N/A(505) 895-5843-573 Union StreetHoustonTX77009-9182UNKNOWNNAVIGATE-HMO
PRVPRV-281342026-02-02T15:21:59ZKIMBERLY—VEGA1977-08-09UHC-19644-11NULL9145563153-914 Camelback RdGlendaleaz·85367N/A-
PRVPRV-25895 2026-02-11T09:28:33ZKELLY—VASQUEZ02-11-1994nullUNKNOWN8268136UNKNOWN2110 CHURCH STMesaArizona85274UNKNOWN—
PRVPRV-271042026-10-14T12:19:20ZANNEGRANT11/2/2000·UHC-64263-73N/A(618) 500-9961UNKNOWN3438 Hillcrest RoadLos AngelesCalifornia90038··-—
PRVPRV-291682026-05-07T04:20:37ZFowler, DanielA—1974-12-04UNKNOWN•••-••-7345N/AN/A9441 BroadwayAtlantaGA30300N/A—
PRVPRV-256032026-05-14T04:35:30ZCarolyn—Pierce1990-11-13UHC-31172-20··840-942-0975—2381 Mountain View DriveJACKSONVILLEfl32296null—
PRVPRV-277302026-06-30T12:45:15ZHEATHER—RIOS1960-07-24··UHC-67463-23NULL647-295-4779—6475 DESERT SKY BOULEVARDSacramento··CA95827null—
PRVPRV-268522026-04-20T08:04:59ZRachelK.Garza1951-02-09UHC-60032-54·N/A2363283587—4470 Park PlaceFresnoCA93732··NULLUNKNOWN
PRVPRV-212982026-07-19T00:54:54ZJOHN—WAST22-01-1938UHC-39164-01NULL··774-991-9668-8348 Market StAUSTINtx78748—null··
PRVPRV-272032026-04-23T14:19:06ZTYLER—WAGNER1977-08-17UHC-29723-33—4056658474TYLER.WAGNER75@AOL.COM·8116 Willow CtSAN ANTONIO·TX·78239N/ASELECT-EPO
PRVPRV-206242026-05-09T05:00:34ZJustin—CarrMay 17, 1939—null·(747) 818-8871justin.carr4@gmail.com2297 CHURCH STREETHoustonTX77093····—
PRVPRV-205072026-02-10T02:36:24ZBryan—Mitchell05-10-1940———BRYAN.MITCHELL@PROTON.ME--———UNKNOWN
PRVPRV-285632026-10-01T17:42:06Z·Brandon—Andrews04-02-1956UHC6811203null584-802-1755UNKNOWN414 Oak StTUCSON··AZ85712-2024—core-hmo
PRVPRV-226162026-04-16T21:28:05ZMary—Moreno1992-12-28·UHC-34202-75•••-••-9002(916) 779-1678—2055 CEDAR LNPhoenixArizona85050UNKNOWNSELECT-EPO··
PRVPRV-22724 2026-04-03T13:04:39ZWayne—Arnold1964-08-20-UNKNOWN784-529-5243-··—UNKNOWN—null··NULL··—
PRVPRV-234552026-06-18T08:56:10ZDouglas—Gonzales··1954-12-17NULL—+1 377 877 8088null4056 BASELINE RD Apt 19TAMPAfl33641-6704N/AUNKNOWN
PRVPRV-229552026-02-12T05:28:31ZChristine—MoralesJan 19, 2007nullNULL567.467.7874··—8944 Forest AveCharlotteNC·28211·N/AUNKNOWN
PRVPRV-257652026-05-02T06:11:53Z James—Long1972-08-16——2897838844NULL6078 Mountain View DriveNashvilleTN37251-8203-··null
PRVPRV-242302026-04-28T03:01:10ZAISHA—RYAN03/11/06——981-223-8695—7550 Spring StreetGilbert··AZ85220—-··
PRVPRV-277022026-05-21T09:50:19ZMAGGIE—·VALDEZ2003-10-16··•••-••-93015485360070N/A1601 JEFFERSON AVESan AntonioTX78200——
PRVPRV-291942026-07-27T20:51:45ZWALTER—MUNOZ2002-05-12-UNKNOWN+1 502 535 2140····6152 Sage Ct Apt 24SeattleWA98156UNKNOWN—
PRVPRV-200542026-02-03T19:12:51Z·YUKI—FULLER01-01-2003——209-328-2988YUKI.FULLER1@PROTON.ME656 Ridge RoadAustinTX78713UNKNOWN-
PRVPRV-259202026-02-14T04:18:22ZKatlheenYPowell1995-01-16—N/A9098901879KATHLEEN.POWELL23@GMAIL.COM8223 Bayshore DrPlanoTX75085——
PRVPRV-246562026-08-29T13:42:03Zkathryn—ortega07/27/02—NULL19828990969kathryn.ortega42@gmail.com1848 Main StreetAtlantaGA30307N/A—
PRV PRV-253242026-03-30T16:29:45ZLORI—PARKER1989-05-13UNKNOWN—(224) 602-9121LORI.PARKER83@PROTON.MENULLNULL—N/AUNKNOWNnull
PRVPRV-248362026-03-08T17:45:31ZThomas—Ortega1948-10-07--899.819.4723····3281 OCEAN AVESAN ANTONIOTX78234-OPTIONS-PPO
PRVPRV-225502026-01-15T05:50:36ZSTEVE—WATINS1954-12-25UHC-84173-47N/A7594208672steven.watkins@outlook.com860 Hillcrest RoadAustinTX78700UNKNOWNMEDICARE-ADV-A
PRVPRV-227072026-08-28T07:45:47ZTerry—Rvera1993-04-10UHC-56476-05null·2339455683terry.rivera@gmail.com4242 HILLCREST RDMiamiFL33159—CORE-HMO
PRVPRV-28350 2026-03-31T04:00:45ZMichael—Bailey··1962-12-12-—+1 458 241 8069··michael.bailey33@yahoo.com··3103 Lake View RdSan DiegoCA92146—CORE-HMO
PRVPRV-219252026-06-20T07:46:25ZCharles—Ramirez1979-07-08——NULLNULL4626 SAGE CTSacramentoCA95816——
PRVPRV-294182026-07-22T18:14:28ZAlenSLyynch1959-07-02UHC-97250-45•••-••-0860383-922-6600alan.lynch16@outlook.com7020 Elm StORLANDOfl32886··—N/A
PRVPRV-228542026-03-24T17:57:11ZJUSTIN····VARGAS09/15/2004UHC-10790-41•••-••-91805808880906justin.vargas@hotmail.com3263 HILLCREST RDLos AngelesCA90035-0411—UNKNOWN
PRVPRV-237922026-06-19T03:19:57Zkevin—mendoza1943-10-03UHC-89100-76•••-••-024919597701472NULL4415 Lincoln WayChandlerAZ85253-2752--
PRVPRV-275922026-05-21T07:57:54ZBill··Ellis··2002-02-14N/A—9235640002·-8506 SUNSET BLVDGilbertAZ85272··NULL—
PRVPRV-28230 2026-06-16T04:51:46ZSharon—Hoffman1974-03-02UHC-28654-06NULL(979) 391-2008-342 Baseline RdMesaAZ85209NULL—
PRVPRV-249282026-01-18T20:01:22ZRaymond··—Stone1944-04-18UHC-79612-67—12818329464null8000 PARK PLTampa··FL33670null—
PRVPRV-265142026-08-26T01:16:45ZJANET—TRAN1986-08-20UHC-03218-96•••-••-6917+1 670 901 7122null2658 BroadwayPhoenixArizona85018—·null
PRVPRV-233232026-02-16T16:41:39Z·Logan····Collins1944-12-21—UNKNOWN(511) 400-8104logan.collins@outlook.com9814 PINE DRIVE #700LAS VEGASNV89137——
PRVPRV-270862026-07-11T08:53:53ZJessicaI.Dean1966-03-14··UHC3919624•••-••-1293526-748-9559··—·55 Desert Sky BlvdSan DiegoCA——null
PRVPRV-225802026-09-24T08:21:07ZjudithH··lopez1955-12-23UHC-71589-82•••-••-6923(865) 650-4963··7203 Market StreetColumbusOH43283-0200null—
PRVPRV-260112026-10-05T20:13:33ZPaul—Rilye1973-02-14··—NULL(227) 595-1424paul.riley3@yahoo.comUNKNOWN··NULLN/A-null·OPTIONS-PPO
PRVPRV-231102026-03-20T10:04:33ZRussell—Roberts1996-12-25UHC-06483-11-8733474767-6249 Union Street·AtlantaGA30305null—
PRVPRV-233992026-10-14T19:14:04ZDavidYArmstrong1946-07-26UHC-93636-05•••-••-5222NULL—1887 RIDGE ROADGILBERTAZNULLUNKNOWNnull
PRVPRV-269402026-04-21T16:03:15Z·Jessica—Elliott2005-07-04UHC-51147-59•••-••-26997989824634jessica.elliott@gmail.com2452 Maple AveTempeAZ85284null—
9,596 rows, page 39 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:38.504Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty