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-22019 2026-06-06T15:53:11Z·Cynthia—Flores03/20/1953—NULL(285) 701-5766N/A7392 PINE DRMinneapolisMN55481-8213N/ANULL··
PRVPRV-279252026-01-09T23:57:38ZCarol—Berry08/25/1986UHC-30702-83null(245) 908-8555—NULL—NULLN/A—NULL
PRVPRV-244022026-08-02T19:50:15ZDenise—Wells1998-09-06null····(464) 858-8774····8604 Lincoln WayCOLUMBUSOhio43232···NULL
PRVPRV-261032026-08-05T08:46:59ZWillie—Yang1983-02-18NULLUNKNOWN7384718551willie.yang@hotmail.com3924 Jefferson AvenueMiamiFlorida33137——
PRVPRV-289012026-08-05T21:56:44Z Christina V—Mills1968-09-02-—722-730-1526UNKNOWN2856 Grand AveFresno··CA93737···NULL—
PRVPRV-292192026-09-30T14:07:24ZCHRIS—RICHARDS1960-12-12UHC-05977-75null845-452-8539christopher.richards45@yahoo.com5798 Ocean AvenueEden PrairieMN55304—UNKNOWN
PRVPRV-233302026-05-07T19:16:03ZShultz, Alexander——1967-11-05nullnull(241) 695-2655··NULL7629 DESERT SKY BOULEVARDTucsonAZN/ANULLSELECT-EPO
PRVPRV-208402026-09-10T04:18:01ZWilliamson, Willie——1980-02-11UHC-87207-77———7994 CANYON RDSan AntonioTX78239—NULL
PRVPRV-228692026-10-02T12:05:13ZBradley, Tyler——1984-12-11··—UNKNOWN557-284-7149-3905 Cedar LnSeattleWA98178N/AN/A··
PRVPRV-241082026-05-21T04:57:57Z·JesseM.Sandoval1962-10-14—-18762674493jesse.sandoval55@gmail.com2084 Jefferson AvenueJACKSONVILLEFL32286—OPTIONS-PPO
PRVPRV-260362026-02-16T23:26:22Zmelissa—ramos2002-06-10NULL—(876) 376-9108melissa.ramos@aol.com7751 Bayshore DriveChandlerAZ85233null··NULL
PRVPRV-205022026-02-10T07:21:02Z·AUSTIN—TORRES1970-06-15N/A•••-••-5611324-360-2250-6803 CANYON ROADJACKSONVILLEFL32268null—
PRVPRV-204462026-02-05T21:49:48ZStephan—Murphy1992-11-09UHC-54490-83—234-538-4671—2604 River RoadEden Prairie·MN55392—null
PRVPRV-266992026-05-08T06:31:41ZWei—Morris1970-02-14——(213) 973-7646··9555 CENTRAL AVENUEMesa··AZ85253-8522NULL-
PRVPRV-216502026-08-28T12:59:56Z Linda—Garrett1940-12-15··null•••-••-3120UNKNOWNnull2449 Broadway··GILBERTAZ85229--
PRVPRV-216142026-04-18T20:46:45ZAlbert—Mason03/14/53—•••-••-2220+1 769 593 6039albert.mason@icloud.com2440 DESERT SKY BOULEVARD··GlendaleAZ85355—OPTIONS-PPO
PRVPRV-291932026-01-29T06:02:50ZWalter—Munoz2002-05-12UHC-46892-79•••-••-2140(502) 535-2140WALTER.MUNOZ86@ICLOUD.COM6152 Sage CtSeattleWA98156-—
PRVPRV-237982026-06-12T18:45:15ZThomas—Washington··1951-03-13N/A—(527) 623-2503——N/AN/A——-
PRVPRV-250462026-02-27T21:01:57ZAMY··VESPINOZA1996-03-02—NULL638-558-6027—3957 SAGE CTDALLASTX75233UNKNOWNNULL
PRVPRV-200172026-09-25T14:48:33ZWayne—Hamilton1947-06-25N/A•••-••-4015606.589.1337wayne.hamilton@outlook.comNULLN/A··UNKNOWN—N/A-
PRVPRV-239742026-03-19T13:42:00ZChristineV.Martinez1999-08-16UHC-53553-34——-4871 Mountain View Drive #113TampaFlorida33616-NULL
PRVPRV-218162026-09-19T01:29:19Zjessica—mendez1958-11-24UHC-94335-21N/A(274) 222-7518-1455 MEADOW LANEPhoenixAZ85016UNKNOWNUNKNOWN
PRVPRV-247132026-10-01T05:23:25ZTimothy—Robertson1952-01-06UHC-04478-97—+1 424 951 5029—2331 VALLEY VIEW DRIVEOrlandoFL32820null—
PRVPRV-236092026-07-30T06:19:54Z Brandon—Banks4/16/1955UHC-97066-54UNKNOWN590-417-7591null41 Central Avenue·HOUSTONTX77073-5657N/A-
PRVPRV-290682026-10-10T14:05:05ZAmanda··GGibson02/15/38—null750-829-2181null6501 Meadow LanePlanoTXUNKNOWNnull-
PRV PRV-295242026-04-14T21:54:56ZSamanthaEJohnston6/25/1973·UHC-14942-21—8578481142SAMANTHA.JOHNSTON93@AOL.COMNULL······NULL—NULLN/A
PRVPRV-245212026-04-18T20:09:17ZTIMOTHY····WEBER1594-08-04··—N/A-N/A3331 Mountain View DrivePlanoTX75003······NULL
PRV PRV-259682026-05-21T05:45:40ZCatherine—Sanders2/6/1942NULLUNKNOWN····—6972 Apache BlvdMinneapolisMN55418-8894NULL··N/A
PRVPRV-233772026-09-02T10:20:14ZBobby—Larson1962-09-04UHC-61479-77•••-••-4662497-942-8180—·1609 Pine DrFresnoCA93785··nullUNKNOWN
PRVPRV-284302026-09-16T18:51:22ZTucker, Walter——·1976-12-11N/A•••-••-449618879136632—7362 Desert Sky BoulevardJACKSONVILLEFL32253UNKNOWNnull
PRVPRV-211232026-06-03T05:18:21ZEugene—Young··25-07-1983UHC-39535-18null253-870-0296—UNKNOWN-N/A-····NULL
PRVPRV-243022026-10-08T17:06:47ZFRANK—WALKER01/25/52nullnull7333134220··null9876 Spring StMESAAZ85228nullN/A
PRVPRV-279972026-05-02T05:01:07ZTeresa—Sism1981-01-25UNKNOWNnull(384) 718-5091teresa.sims@outlook.com9302 Meadow LaneHoustonTX77045—null
PRVPRV-254432026-06-11T20:26:43ZsandraW.alexander2008-02-26·UNKNOWNNULL·+1 683 375 0889SANDRA.ALEXANDER@ICLOUD.COMNULL—N/Anull—·UNKNOWN
PRVPRV-206572026-03-04T02:59:03ZSTEPHEN—MASON1949-01-20··UNKNOWN•••-••-9607726.744.2355null5037 OCEAN AVEColumbusoh43224-0049-·N/A
PRVPRV-200232026-09-04T18:40:26Z vincent—hansen1953-05-26NULLnull7005908077vincent.hansen82@yahoo.com2218 PARK PLACELAS VEGASNV89138—-
PRV PRV-29286 2026-01-28T18:55:04ZRebecca—Espinoza19541227nullNULL(905) 543-2749null8352 MAIN STPhoenixAZ—nullN/A
PRVPRV-245102026-08-07T18:52:21ZVIRGINIA—THOMASMar 16, 1979UNKNOWN—240-676-1093virginia.thomas5@outlook.com···7410 Union StreetMiamiFL-—null
PRVPRV-273982026-01-06T09:56:10ZLarry—DuncanApr 28, 1989UNKNOWNNULL——9313 BASELINE RD Apt 31Eden PrairieMN55346—N/A
PRVPRV-211492026-06-23T03:23:39ZJudith—Myers1946-09-27UNKNOWNNULL536-383-2327JUDITH.MYERS68@ICLOUD.COM7974 Ocean Ave··AustinTX78758UNKNOWN··CHOICE-PLUS-PPO
PRVPRV-224372026-02-17T04:57:56Z aaron··chapman··1980-11-08·UHC-51747-57UNKNOWN819-656-7354NULL··8489 Sunset BlvdOrlando·FL32869UNKNOWNNULL
PRVPRV-244692026-04-11T05:36:48ZJOSHUA··GORDON1958-12-25nullnull9116152joshua.gordon99@proton.me4104 UNION STREETJacksonvilleFlorida32286——
PRVPRV-262752026-04-18T08:42:01ZDOUGLAS—PADILLA1983-05-27UHC-70673-95··UNKNOWN16709213908—6987 Park PlaceAtlantaGA30312·-·N/A
PRVPRV-249312026-02-03T01:01:59ZMARGARET—COLE·1973-09-02UHC-65282-20UNKNOWN14333174026margaret.cole@yahoo.com6556 Lake View RoadLas VegasNVN/A——
PRVPRV-288862026-09-19T23:34:46ZKaylaO.Williamson1993-02-05UNKNOWN—9517136921kayla.williamson3@yahoo.com5310 Indian School RdSan DiegoCalifornia92184·null—
PRVPRV-270622026-08-31T07:55:15Z ·WALLACEISARA1992-04-20N/A—940.761.4454null1117 BASELINE RDTempe··AZ85202-4981—null
PRVPRV-249822026-07-22T20:32:20ZJNOATHAN—ALVAREZ2005-09-12UHC-37217-80—585.381.8945UNKNOWN7872 Meadow LaneEden PrairieMN55392-—
PRVPRV-270242026-03-29T20:08:45ZCHRISTINE—POWELLNov 14, 1984··UNKNOWN•••-••-5543961.984.4221—1042 Maple AveHoustonTX77000-MEDICARE-ADV-B
PRVPRV-223412026-06-23T23:25:19ZMICHELLE—LEE1952-02-03UHC-44850-78-NULL··—88 Highland AvenueCharlotte··NC28211—UNKNOWN··
PRVPRV-289462026-08-09T02:04:02ZRojas, WeiV.—03/01/59—····4474536178WEI.ROJAS@OUTLOOK.COM9644 Apache Blvd··GlendaleAZ85394—N/A
9,596 rows, page 35 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.481Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty