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-231012026-01-21T21:20:56Zashley—hayes1970-03-20—N/A484-280-2916··ashley.hayes30@gmail.com2850 Valley View DrChandlerAZUNKNOWNnull··
PRVPRV-241362026-05-05T20:05:46ZDONNA—HOWARD1944-07-27-NULL+1 328 622 2434—5111 BAYSHORE DRIVETampaFL33675—N/A
PRVPRV-279682026-05-22T06:52:09ZMARILYN··R.SULLIVAN··1952-05-20NULLnull274-851-9508marilyn.sullivan5@outlook.com5246 DESERT SKY BLVDMiamiFL33143NULL··—
PRVPRV-231372026-04-19T00:46:35ZMEGAN—ALVAREZMar 13, 1971UNKNOWN•••-••-7122985.399.7516NULL——N/AN/Anull·-
PRVPRV-272882026-06-06T07:38:50ZHart, Martha——08/09/1992UHC-75199-01··•••-••-0366·16112168218UNKNOWN8285 Oak StreetOrlandoFL32874-4856nullNULL
PRVPRV-292432026-08-03T05:10:06ZLauren—Medina1962-06-02N/AUNKNOWN(745) 841-4713null2179 Bayshore DrivePhoenixAZ85086NULL-
PRVPRV-293212026-06-13T08:29:02ZChavez, Diana—····1980-02-02··UHC-06047-05··—(611) 289-4481nullUNKNOWN—————
PRVPRV-243642026-09-04T06:40:18ZDaniels, RyanM.—03/16/49·UHC-67026-83•••-••-2343290-868-2003··ryan.daniels@proton.me2759 Bayshore Dr Apt 13GlendaleAZ85331—CORE-HMO
PRVPRV-277742026-05-08T04:07:36Z Jeremy—Fields·1941-08-04UNKNOWN•••-••-4770606-341-1589JEREMY.FIELDS@YAHOO.COM806 Jefferson AveSan AntonioTX78264-null
PRVPRV-230072026-02-10T15:13:02ZJEREMY····COOK08/19/48··UHC-20902-98—+1 505 571 5690NULL9672 BASELINE RDGilbertAZN/AN/AUNKNOWN
PRVPRV-21999 2026-03-04T20:07:08ZWilie—Brooks1964-08-16UNKNOWN•••-••-6345——1402 Indian School RoadLas VegasNV89178——
PRVPRV-215222026-05-25T06:44:29ZDYLAN·I.HILL01/21/62N/A—(265) 642-3198UNKNOWN5307 Valley View DriveCharlotte·NC28251NULLN/A
PRVPRV-213942026-01-24T15:09:07ZJoe—Anderson1948-09-01··UHC-12753-63•••-••-81499243463238—2779 Baseline Rd··HoustonTX77064··——
PRVPRV-244412026-05-10T18:43:40ZGrace—Jenkins1999-10-08····NULL16244733419grace.jenkins@aol.com·4259 Sage CourtTampaFL33608—null
PRVPRV-286552026-02-28T12:22:01ZJULIA—·LUNA2/15/1971—·N/A403.471.5948UNKNOWN8584 Main StTampaFL33678null-
PRVPRV-285862026-05-06T02:32:25Z·Nicholas—Carr·1989-07-01UHC-93074-69—9738314284··9452 Indian School RdTUCSONAZ85742—N/A
PRVPRV-202012026-09-12T21:15:52Zpaul—jimenez1977-10-17-•••-••-0241NULLpaul.jimenez77@hotmail.com1194 Pine DriveTEMPEAZ85257N/A—
PRVPRV-266082026-03-26T10:59:42ZDANNY··CUNNINGHAM·1943-08-03UHC-00723-22··586-989-5708-2249 Mesa DrGlendaleArizona85325··—null
PRVPRV-201892026-04-24T09:36:58ZBrian—Hughes1973-09-07——+1 467 889 8577··2261 Mesa DriveDALLASTX75287N/AMEDICARE-ADV-A
PRVPRV-212382026-06-10T13:03:14Z Stephen—Vargas1991-11-11UHC-56822-75—nullstephen.vargas@aol.comUNKNOWN—UNKNOWNUNKNOWN—N/A
PRVPRV-206312026-05-10T19:27:31ZSANDRA—FREEMAN1995-01-01——781-596-2100sandra.freeman75@outlook.com3230 PINE DRIVEGilbertAZNULL··null—
PRVPRV-218212026-09-15T07:06:06ZCAMILA—JIMANEZ1975-10-02UHC-71123-92•••-••-37953483648738—9655 MEADOW LANEPlanoTX75028—N/A
PRVPRV-235242026-08-08T02:22:04ZKathrynX.Lopez01/08/2001—•••-••-8918936-331-7270UNKNOWN2249 VALLEY VIEW DRIVE··ScottsdaleAZ85265N/AUNKNOWN
PRVPRV-270522026-03-15T12:13:34ZevelynUcontreras1977-01-11N/A—·(807) 272-4415NULL8517 SUNSET BLVDJacksonvilleFL··32240-1783—options-ppo··
PRV PRV-224712026-06-02T08:57:13ZRonald····Dunn1949-01-14··UHC3878347—794-767-8863RONALD.DUNN@GMAIL.COM1118 Desert Sky BlvdFresnoca93772-NULL
PRVPRV-271882026-06-11T20:42:44ZRaymond—Yeng1964-05-20UHC-67004-66•••-••-0854(859) 544-8822-6038 Market StreetSan AntonioTX78289··null—
PRVPRV-215432026-10-12T09:27:20ZRalph—Castro1969-02-21UNKNOWN··(225) 370-5592—1774 ELM STREET #851MesaAZ85227UNKNOWN—
PRVPRV-272892026-02-03T15:50:08ZMARTHA—·HART08/09/1992nullnull6112168218··—8285 Oak StreetOrlandoFlorida32874—-
PRVPRV-294432026-03-16T15:28:14ZJerry—Weber02-02-2007UHC-25856-59-6985769670jerry.weber78@gmail.com1357 Union StEDEN PRAIRIE·MN55317—UNKNOWN
PRVPRV-203992026-09-12T16:21:59ZMARIA—WASHNGTON1968-08-24——6074832921null1478 BAYSHORE DRSacramentoCAUNKNOWN—UNKNOWN
PRVPRV-264722026-06-13T16:38:12ZPHILIPOTUCKER1951-04-02·N/AUNKNOWN2667523626NULL8795 Spring StGLENDALEAZ··85359-—
PRVPRV-200482026-08-28T14:10:02Zruuth····ferguson1945-10-09UHC-17845-36UNKNOWNUNKNOWN··9177 Jefferson AveMESAAZ85248·UNKNOWNUNKNOWN
PRVPRV-216192026-03-09T13:14:14ZRaymondU.Burns19430803NULL•••-••-68474703169493null2658 HILLCREST RDAUSTINTX·78700-—
PRV PRV-240422026-10-10T09:48:19ZLuisF.Dunn21-11-1950·uhc-69678-10null290-955-9837··luis.dunn@yahoo.com··5311 Desert Sky BoulevardCHARLOTTENC28275—OPTIONS-PPO
PRVPRV-256772026-03-18T10:18:00ZDonna—Stone18-10-1997··—-(329) 611-0299UNKNOWN··8866 Grand AveJacksonvilleFL32259nullMEDICARE-ADV-B
PRVPRV-276792026-05-08T07:49:49ZReed, ValentinaH—1942-04-11—N/A····N/A5582 MAPLE AVENUESan DiegoCA92117-—
PRVPRV-269032026-04-26T23:22:32ZKATHLEENOEDWARDSNULL··-—(964) 825-9461-null———null—
PRVPRV-209172026-07-08T10:34:21ZCarlY.Chavez9/25/1973UHC-14542-94N/A-carl.chavez63@gmail.com5772 Maple AveGilbertAZ85265NULLN/A
PRVPRV-295942026-08-09T22:53:24ZEugeneV.Daniels1994-02-05nullNULL(690) 818-9684—·9891 Oak StreetMesaAZNULL-····
PRVPRV-258382026-08-05T07:47:25ZJEN—GUERRERO·07-11-1942·UHC-50155-20UNKNOWN19665290172NULL8528 Washington StreetFresnoCalifornia93701—NULL
PRVPRV-236882026-05-31T07:29:47ZFRANCES—ELLIOTT1958-02-18UHC-93061-35—(911) 864-9287—2493 MAPLE AVEChandlerAZ85243·--
PRVPRV-215282026-07-22T03:29:30ZSANDRA····WEEBER1963-07-13UHC-22732-27UNKNOWN(790) 944-7106null·525 Canyon RoadMesaAZ85278—null
PRVPRV-223722026-01-09T10:06:41ZVIRGINIA—HUGHES··08/27/1964UHC5229991•••-••-7216348-911-0886VIRGINIA.HUGHES@PROTON.ME8827 Lincoln WayDENVERColorado80238-9321NULLN/A
PRVPRV-247242026-04-19T04:54:26ZTyler—Padilla03/25/1974··UHC-67281-64N/A—-7057 Mesa DrTempe··AZ85297N/ANULL
PRVPRV-270062026-02-12T06:29:09ZDouglasZGuzman04-05-1939·UHC-59096-88•••-••-55174143293966douglas.guzman39@hotmail.com4355 Mountain View DriveTempeAZ··85299—-
PRVPRV-275392026-01-13T10:52:25Zomar—valdaz··1961-04-21NULLnull+1 739 547 5822null6802 Highland AvenueSCOTTSDALEAZ85215——
PRVPRV-271632026-02-26T09:54:57Z Powell, Alan——UNKNOWN··UHC-25780-72-934-605-4319null3127 Washington StPHOENIXAZ85083NULLUNKNOWN
PRVPRV-249572026-09-24T17:31:46Z·Alex—RossAug 23, 1957—N/A9546289856—2466 Harbor BlvdSeattleWA98176·N/Anull
PRVPRV-280972026-02-04T08:27:41ZHiroshi··—MooreSep 8, 1950··-—334-945-6011null952 UNION STGlendaleAZ85388UNKNOWN—
PRVPRV-219662026-04-22T08:22:57ZJessica—Johnson10/05/79·UHC-65449-18—(535) 795-4278jessica.johnson@gmail.com222 Harbor BoulevardLas Vegas··NV·NULL-—
9,596 rows, page 91 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:46.435Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty