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-225242026-05-02T19:26:53ZBobby··Gilbert1986-04-01—UNKNOWN··454-386-8857—8022 Ocean AveMesaAZ85230N/ACHOICE-PLUS-PPO
PRVPRV-274672026-10-10T19:25:02ZJEAN—LONG1952-07-08null•••-••-9887+1 222 875 6796null6765 SPRING ST·MesaAZ85238--
PRVPRV-210852026-04-05T13:06:17ZDeborah—Jacobs2005-02-05UHC-75354-55null+1 737 354 6839null3198 APACHE BOULEVARDOrlandofl32809—NULL
PRVPRV-234582026-08-18T07:30:47ZMICHELLE—HAANSEN1952-03-09··uhc-96691-01—(587) 236-4637—4178 BASELINE RDCHARLOTTENorth Carolina28274NULLnull··
PRVPRV-242902026-07-05T00:54:49ZBeverlyU.··Colllins1978-09-17UHC-66499-96··null—beverly.collins@outlook.com2916 Park Place·Scottsdale·AZ85233UNKNOWN—
PRVPRV-274322026-07-27T06:12:08ZMARIANA····CAMPBELL05/15/2008—•••-••-70222895058nullN/AUNKNOWN-NULL—N/A
PRVPRV-209912026-02-15T04:47:20ZTILERWJACKSON1498-07-16UHC-45708-12•••-••-2894(929) 736-3562UNKNOWN7548 Baseline RdAtlantaGA30326——
PRVPRV-241912026-05-07T10:47:40ZStephenB.Hayes03/09/45—·-—null5994 Willow CtSCOTTSDALEArizona85264——
PRVPRV-265072026-02-06T16:57:20ZChristian··YGarrett1955-04-21UHC-16481-13—+1 362 874 1346UNKNOWN3870 CANYON RDJacksonvilleFL32283—UNKNOWN
PRVPRV-242012026-08-11T01:35:16Z·kathryn—nunez19841127N/A··UNKNOWN708.799.4006—3733 MEADOW LANELos AngelesCA90025-—
PRVPRV-290982026-07-06T23:03:09ZAHMEDO·COLEMAN19750303——512-606-5971UNKNOWN4581 FOREST AVENUEColumbusOhio43255UNKNOWNCORE-HMO
PRVPRV-288222026-06-10T23:32:46ZMelissaBMaldonado··1971-06-16UHC-80701-58—6604987788melissa.maldonado45@gmail.com7835 CHURCH STREETSan Antonio·TX78272NULLNAVIGATE-HMO
PRVPRV-259652026-05-05T16:25:22ZDorothyBGreeneNov 1, 1965NULLnullN/Anull1956 INDIAN SCHOOL RDGlendale··AZ85338NULLN/A
PRVPRV-263622026-05-14T23:01:24ZGARY—RODRIGUEZ10/26/2008——+1 656 777 5399NULL3031 Bayshore DrTucsonAZ85773··N/A—
PRVPRV-264782026-08-10T18:39:08ZWHEELER—THOMAS03/02/51-•••-••-3831627-238-2541··THOMAS.WHEELER@PROTON.ME·5073 MARKET STREET #626CHANDLERAZ85280N/AUNKNOWN
PRVPRV-280852026-01-28T08:24:33ZRalph—Peterson19950804UHC5326005—(458) 857-1984null1958 Market StreetSacramentoCA95883NULL····
PRVPRV-205942026-03-11T11:55:49ZRaymond—Hall1978-08-11UHC-66052-13N/A+1 854 764 6325—3690 Elm StreetSan AntonioTX78298··N/A—
PRVPRV-250542026-01-12T09:59:04ZThomas—·Foster1999-05-26null—null—369 Ocean AvenueDenverCO80260—··
PRVPRV-28117 2026-03-20T04:03:04ZSofia—OrtegaOct 7, 1997NULLnull····null5180 Sage CtEden PrairieMN55390—-
PRV PRV-280362026-01-26T05:24:05ZDeborah—Perry1941-09-28UHC-90537-38—(481) 608-5049deborah.perry19@aol.com1929 Oak StFRESNOCalifornia93777——
PRVPRV-215772026-04-21T04:31:26ZJOHN—SNYDER1004-91-49UHC-19895-89—NULL—1460 Church StreetSAN DIEGOCA92181N/A—
PRVPRV-241092026-06-26T11:57:16ZJonathan—Peterson1939-90-22UHC-80951-24—(866) 849-2621·NULL3469 Spring StPlanoTX75019—NULL
PRVPRV-236382026-03-14T03:44:02ZMason, HiroshiS—1963-11-06-UNKNOWN(854) 235-6009null4512 WILLOW CT Apt 27Columbus··OH43243——
PRVPRV-266642026-03-23T06:42:32ZBrittany··Nguyen1987-11-25nullUNKNOWN219-588-7267null579 Harbor BlvdTucsonAZ85760·N/AN/A
PRVPRV-204652026-08-02T17:42:51ZDouglas—Hill1942-09-02UHC-33322-25N/A5324308942UNKNOWN7413 Hillcrest RoadDENVERCO80215-6061-NULL
PRVPRV-284802026-01-03T08:05:39ZDANIELLE—DIAAZMar 24, 1947UHC-42957-15•••-••-55906557210908UNKNOWN2992 Jefferson AveMiamiFL··33121N/A—
PRVPRV-285602026-07-20T13:37:19Z Jacob··Collins26-02-1994—N/A18392977137—null--—····N/A
PRVPRV-22113 2026-04-29T08:48:12ZCHRISTINE··MARSHALLNov 2, 1978N/A•••-••-65665307815623—3165 ELM STHoustonTexas77095—·SELECT-EPO
PRVPRV-229062026-03-02T04:53:10Zpaul—marshall1965-08-08UHC-73694-41N/A8956586819—8380 Ocean AvenueTampaFL33627nullN/A
PRVPRV-225602026-10-12T06:57:27ZBrendaKFerguson1952-03-13UHC-73878-49NULL7465010029N/A7666 HARBOR BLVDSeattleWA98150—NULL
PRVPRV-273482026-09-06T19:45:00Zalexis—hughes2001-06-10·UHC-70657-25··——1856 Union StFresno··CA93718NULLOPTIONS-PPO
PRVPRV-288772026-09-26T20:32:18ZPAMELA—WALLACE3/20/1988UNKNOWN··null687-707-5010pamela.wallace@yahoo.com8337 BAYSHORE DRTempeAZ85298—UNKNOWN
PRVPRV-210642026-07-25T03:01:34ZMei—Matthews1996-06-07uhc-74503-34•••-••-69937293648069mei.matthews@hotmail.com7562 BROADWAYSan DiegoCA92141N/ASELECT-EPO
PRVPRV-268952026-06-22T01:25:34ZJEFFREYSGUTYERREZ2001-02-05nullNULL+1 530 450 6803null8454 Forest AvenueDALLASTX75288N/A-
PRVPRV-246832026-04-11T03:22:52ZHeather··—Jones4/22/1988——(513) 382-0360—7379 Broadway··DallasTX75291··-
PRVPRV-234912026-02-20T03:34:15ZrogerPgilbert04/18/1941··null—6597618400roger.gilbert2@outlook.com7000 DESERT SKY BOULEVARDTampa·FL33684null—
PRVPRV-202512026-05-16T01:47:30ZDEBRA—SIMMONS2005-06-27NULL··—244-332-7255-3226 ELM STTampaFL33653—NULL
PRVPRV-279082026-06-17T17:09:16ZJenny—Weaver1962-11-19UHC-61723-16-884.927.8803nullNULLNULL—null-MEDICARE-ADV-A
PRVPRV-271982026-03-18T12:44:46ZcharlesCreynolds1961-09-26·UHC-64561-81NULL-null6382 Apache BlvdORLANDOFlorida32824··OPTIONS-PPO
PRVPRV-221112026-01-28T05:57:52ZAaronUMason1955-06-21·UHC5352713—·2874515027—7117 Jefferson AvenueGlendaleAZ85385NULL—
PRVPRV-225462026-04-26T16:26:29ZWayneVFerguson06/12/1969—NULL739-778-1136wayne.ferguson@gmail.comnullnull—-——
PRVPRV-251352026-01-13T05:01:05ZKeith—Fod4/21/1947UHC-33594-46—438-241-6892N/A6215 Central Avenue··Orlando·FL32811N/A····
PRVPRV-263832026-01-30T21:11:36ZAHMDE—ALEXANDER1989-05-22NULL•••-••-3859658-310-0140-——N/ANULL··UNKNOWN·null
PRVPRV-202722026-08-27T20:22:02ZJANTE··—WRIGHT19660920UHC-45348-02•••-••-36283153185416NULL4019 MAPLE AVENUEMinneapolisMinnesota55415UNKNOWNNULL
PRVPRV-280592026-07-08T10:27:06ZRUTHLFLORESFeb 18, 1999-—480-777-7238·N/A7256 VALLEY VIEW DRGILBERTAZ85292NULLOPTIONS-PPO
PRVPRV-215682026-04-21T08:38:28Z·JOSHUA····HILL··1990-06-01UHC-62851-11—NULL—1228 Central AvenueSeattleWashington98125··N/Anull
PRVPRV-255272026-03-22T15:50:47ZBRADLEYU.WEAVER19820714UHC-09294-02NULL4022615401—7945 Grand AveATLANTA··GA30318N/ACHOICE-PLUS-PPO
PRVPRV-268822026-04-01T14:06:35ZRoberts, SaraK—·1950-08-19—•••-••-1251538-889-8222—7982 MAPLE AVEFresnoCA93799—NAVIGATE-HMO··
PRVPRV-251872026-04-22T11:52:52ZRICHARDE.KELLEYDec 7, 1963—null250-227-2678richard.kelley@yahoo.com68 Desert Sky Blvd··TUCSONaz85719UNKNOWNnull
PRVPRV-230092026-04-12T19:52:45ZAlbert—Stephens1967-02-04UHC-44227-93····—5794 Ridge RdColumbusoh43213-··—
9,596 rows, page 56 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.630Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty