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-266502026-07-01T01:35:55Z ·PAMELA····TRANJun 5, 1947NULL•••-••-2858744-934-8201—4889 Spring St #189SacramentoCA95828-··N/A
PRVPRV-239762026-01-30T13:09:28ZBRITTANY—MUNOZ19600402UHC-87830-57—·8025740413—8564 MEADOW LNOrlandofl32831-N/A
PRVPRV-237162026-07-27T05:36:34ZchristianWlane1971-03-19—null(903) 941-9029CHRISTIAN.LANE@AOL.COM5676 Meadow LaneJACKSONVILLEFL32260nullNULL
PRVPRV-202232026-09-05T02:20:03ZDouglas M—Morales19-08-1952—UNKNOWNN/Adouglas.morales@proton.me2023 Maple AvenueGilbertAZ85226-5503null—
PRVPRV-20643 2026-09-07T12:24:18Zbradley—anderson··1976-07-24UHC-50591-26—4063021271bradley.anderson@outlook.com5819 FOREST AVENUELAS VEGASNV89120—-
PRVPRV-234202026-02-05T18:56:15Z·Donald—Vargas·12/28/75--(938) 411-0399·donald.vargas8@yahoo.com4449 Meadow LanePlanoTX·75081--··
PRVPRV-287112026-02-17T13:17:12ZFrances—Lawson1986-07-22-•••-••-9684(709) 813-8335·frances.lawson@aol.com4507 Sage Court··GilbertAZ85245—UNKNOWN
PRVPRV-227012026-01-07T07:57:53ZJustin—Fuller··1981-05-06UHC-95343-24UNKNOWN202.329.7842null4564 Camelback RoadPhoenixArizona85029··—UNKNOWN
PRVPRV-246592026-05-30T01:16:19ZHeatherONelson11/28/1940UHC-84664-95NULLUNKNOWNheather.nelson7@aol.com5571 Oak StAtlanta··GA30361··UNKNOWNMEDICARE-ADV-A
PRVPRV-209992026-08-11T02:13:54ZMARCANICHOLS2004-08-26UHC-44150-48—778-874-9468MARCUS.NICHOLS@PROTON.ME··7644 Ridge RdMINNEAPOLISMNnull——
PRVPRV-207952026-07-01T08:39:18ZMichelle—Rodriguez··1970-02-01··—-616-445-1282—9037 BAYSHORE DRIVEDenverCO··80227——
PRVPRV-220392026-06-09T13:31:00ZDianeDGibsonJan 7, 1978UHC-53548-25··UNKNOWN·728-921-3628null8641 Highland AvenueAustintx78720N/A—
PRVPRV-261782026-06-08T22:49:00Zbeverly··Z.soto1981-80-25UHC3673565N/A282-336-7123—5451 Camelback RoadFresnoCAnullN/ANAVIGATE-HMO
PRVPRV-262682026-05-14T15:25:41ZDIANAPLANE1990-09-25—null+1 824 307 7412null3391 INDIAN SCHOOL RDMesa··AZ85265—-
PRVPRV-200032026-08-18T15:24:15ZShirley—Hernandez1960-51-10--460-773-8796—1513 BASELINE ROADEden PrairieMN55341—MEDICARE-ADV-A
PRVPRV-257972026-07-10T01:31:55ZSARAHSHAWKINS1991-12-19··NULL•••-••-6227836-422-7329—4993 Ocean AvenueCHARLOTTENC·28234—null
PRVPRV-270952026-02-13T17:22:02ZGRACE—ARMSTRONG04/08/1986UHC-94830-93UNKNOWN5378844765—795 BROADWAYSan AntonioTXnullN/Anull
PRVPRV-277362026-07-31T20:38:07ZAshley··Watson1960-12-22UHC-02090-65NULL938.885.8091—4523 Maple AvePhoenixArizona85064UNKNOWNOPTIONS-PPO
PRVPRV-206932026-01-02T14:14:58ZROGER—CRAWFORD19660121UHC-92649-44UNKNOWN—roger.crawford49@hotmail.com8719 OAK STREET·PhoenixAZ85008UNKNOWNUNKNOWN
PRVPRV-287822026-01-10T09:01:07ZBilly—·Hayes1974-05-19-··•••-••-5474206.776.9094NULL3862 Apache BlvdTUCSONAZ85765N/AUNKNOWN
PRVPRV-211462026-05-29T02:18:20ZAbigail—Andrews19800516——8794888751-499 Lincoln WayMinneapolisMinnesota55455—UNKNOWN
PRVPRV-250472026-02-03T07:55:04ZAmy··VEspinoza1996-03-02——+1 638 558 6027NULL3957 Sage Ct #741···DallasTX75233N/AN/A
PRVPRV-258632026-01-25T07:43:16ZTeresa—Lawrence1988-05-24UHC-66781-07NULL—teresa.lawrence19@proton.me5047 Pine Drive··HoustonTX77082-4676—··
PRVPRV-294772026-10-01T18:28:31ZNATHHAN—PALMER2006-09-05·UHC-74591-49UNKNOWN·+1 853 394 3585—4351 Elm StScottsdaleAZ85259-6360··—-
PRVPRV-214182026-07-04T01:40:58ZKayla—Williamson07/14/2008UNKNOWN—+1 443 244 6373kayla.williamson@outlook.com9478 Jefferson AveColumbusOH43221null—
PRVPRV-28701 2026-02-25T20:01:42ZDaniel—Martinez05/21/1964····UNKNOWN9676271166-8883 Forest AvenueChandlerAZ85249nullUNKNOWN
PRVPRV-247692026-08-14T02:07:52Z DONALD—MATTHEWSFeb 5, 1995UHC-95205-05—729-485-0231—1183 GRAND AVENUEEden PrairieMN55352N/A—
PRVPRV-272142026-06-04T16:36:21ZElijah—Payne1957-04-18——4733396—7432 OAK ST Apt 11MiamiFL33160——
PRVPRV-205752026-10-18T15:32:24ZFisher, HeatherM—19610107·-•••-••-1861·15242070320UNKNOWN3767 Market St Apt 25Los AngelesCA90043UNKNOWNOPTIONS-PPO
PRVPRV-237412026-02-21T10:21:24Zchapman—heather19811202—•••-••-3762+1 679 508 1731heather.chapman@aol.com7036 PARK PLACEMINNEAPOLISMN-null-
PRVPRV-251772026-04-14T12:14:39ZJOYCE—SNYDER1961-01-07UHC-38342-05UNKNOWN+1 678 253 9977joyce.snyder@yahoo.com7991 Meadow LnGLENDALEAZ85350UNKNOWNCORE-HMO
PRVPRV-284032026-09-05T00:21:17ZLARRY—BISHOPMay 20, 1967UHC-45766-39•••-••-0903(528) 887-1754··—3231 Mountain View Drive #403MesaAZ85261NULLUNKNOWN
PRV PRV-292452026-08-06T12:58:42ZAbigailIRuiz1976-09-10NULL—9563680218ABIGAIL.RUIZ@AOL.COM5194 LAKE VIEW ROAD #322·MiamiFL33132-0473N/A—
PRVPRV-284412026-06-28T18:00:27Z·Heather—Gardner1996-07-12UHC-30555-67•••-••-62649399547647·-——UNKNOWNN/A··—NULL
PRVPRV-218972026-09-11T15:40:10ZVirginia—Greeene2005-06-22UHC-49687-56•••-••-3329265.552.4091null4747 Willow CourtSan DiegoCA92152-7793null··NULL
PRVPRV-256442026-06-05T15:24:08ZPeter—Harris1953-02-27UHC-36327-95N/Anullnull6807 Hillcrest RdEden PrairieMN55308—OPTIONS-PPO
PRVPRV-266292026-02-19T11:30:17ZChristinaLDominguez1987-03-17UHC-73710-24•••-••-4483(597) 809-4287··null6090 Camelback RdGlendaleAZ85308—null
PRVPRV-278652026-06-29T10:31:49ZRay, CarlO—1963-08-05—null+1 791 361 1233carl.ray87@hotmail.com1930 HARBOR BOULEVARDMesaAZ85208··——
PRVPRV-255232026-07-04T13:32:58ZNATALIEL.RAMOS1987-04-27null—nullnatalie.ramos50@outlook.com926 Spring Street··TEMPEAZ85256-9274-—
PRVPRV-289882026-05-16T21:57:46ZAngelaINelson1947-08-01··——-ANGELA.NELSON91@OUTLOOK.COM982 Harbor BoulevardAtlantaGA30337-····
PRVPRV-295052026-05-06T00:00:47ZBETTY—WANG1985-06-11——N/ABETTY.WANG38@HOTMAIL.COM8453 Washington StMinneapolisMinnesota·55471-NULL
PRVPRV-223322026-09-19T06:49:10ZEVELYN—HERRERA1973-06-03UNKNOWN—(736) 547-5531—2696 Baseline RoadTampaFL33643UNKNOWNNULL
PRVPRV-219062026-05-14T19:28:26Z AaronJOBrien··Oct 21, 1967N/Anull—N/A2467 Central AvenueChandlerAZ85277——
PRVPRV-280072026-10-11T05:50:14ZHaroldNBlack1953-02-20UHC-08811-16null6522416harold.black@outlook.com1814 LINCOLN WAYSan DiegoCalifornia··92187-—
PRVPRV-212482026-06-24T18:28:31ZDAVID—LAWRENCE1940-06-20·UHC-89096-30—487.496.3303·UNKNOWN9104 Washington StreetFRESNOCA93741-UNKNOWN
PRVPRV-289082026-07-29T01:25:26Z RALPH—GARCIA1945-04-22UHC-55034-74UNKNOWN3735784347ralph.garcia45@yahoo.com2592 Forest AveMIAMIFL-N/AUNKNOWN
PRVPRV-229772026-04-18T18:51:10ZRAYMOND—WASHINNGTON1993-04-26NULLNULL··330-492-6594—UNKNOWNN/ANULLnullUNKNOWNN/A
PRVPRV-274252026-01-23T09:56:40ZMartha··Watson1976-12-23UHC-66588-79N/A6966517927UNKNOWN6159 UNION STEden Prairiemn55365-6423-SELECT-EPO
PRVPRV-201572026-08-20T19:27:08Z Chrristian—·Carpenter09/17/1947—·-(493) 657-6516-8062 Canyon RoadLos AngelesCalifornia90082N/AN/A
PRVPRV-215882026-02-26T10:36:29ZJESSICASALEXANDER17-06-1973NULLN/A595-511-6045JESSICA.ALEXANDER@GMAIL.COM5403 Jefferson AvePhoenixArizona85034NULLUNKNOWN
9,596 rows, page 74 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:43.622Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty