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-287812026-10-14T14:47:17ZNoah··—EspinozaAug 14, 1950-····684.689.5040·NOAH.ESPINOZA@PROTON.ME·-N/A—-NULLNULL
PRVPRV-202522026-05-24T22:10:07ZAmandaP.Williams1987-12-15UHC-27644-83-nullN/A3506 Hillcrest RoadHOUSTONTX77093-NULL
PRVPRV-285472026-06-18T06:38:25ZJose—Jensen1939-09-04UNKNOWNnullnulljose.jensen@aol.com4470 Church StMesa··AZ85243—UNKNOWN
PRV PRV-210882026-08-28T23:15:39ZADREAU.BROWN·22-01-1977UHC3834041—344-757-7223ANDREA.BROWN35@AOL.COM2828 Desert Sky BlvdSan DiegoCA92105NULLCHOICE-PLUS-PPO
PRVPRV-293142026-04-13T08:10:50ZRandy—Ross1940-01-07UNKNOWNnull(317) 448-7162null728 SPRING STREETOrlandoFL32893nullMEDICARE-ADV-A
PRVPRV-223132026-06-05T14:57:11ZWILLIE—MATTHEWS1983-07-16-•••-••-3458+1 987 658 6293UNKNOWN3649 MOUNTAIN VIEW DRJacksonvilleFL32209-2382——
PRVPRV-248972026-01-07T13:46:10ZYuki—Aguilar12/19/1986—NULL278-997-0779yuki.aguilar16@aol.com2651 Ocean Avenue··DenverCO80231nullUNKNOWN
PRV PRV-238602026-02-26T00:23:08Z·James, DorothyF.····1987-02-16UHC-93469-77•••-••-3092(401) 611-1175N/A8094 Indian School Rd···Eden PrairieMinnesota55392-9882—OPTIONS-PPO
PRVPRV-289452026-04-25T23:00:55ZJANET—GRANT··1991-05-18—•••-••-78804312737256UNKNOWN7089 Willow CourtLOS ANGELESCA90080··—
PRVPRV-207022026-08-03T23:47:26ZCarl—Morales1979-12-15—-6095466523carl.morales@proton.me5098 MARKET STOrlandoFL32800—N/A··
PRVPRV-292732026-01-03T14:22:18ZYuki—Williamson2000-03-19N/AN/A—YUKI.WILLIAMSON@ICLOUD.COM4914 SAGE CTJacksonvilleFL32270-—
PRVPRV-257222026-05-22T01:38:07ZLisa—Hudson1957-01-10UHC-49171-42NULL(719) 276-3236null19 BroadwayPhoenix··AZ85068—null
PRVPRV-245562026-06-09T10:03:14Z·RandyK·SotoMar 3, 1969NULLNULL·7264909914—368 RIDGE ROADTucsonAZ85782··-null
PRVPRV-273842026-05-07T16:16:09Zgerald—watson1959-09-14N/ANULL3675314555—9473 Palm DriveCHANDLERAZ85276NULL—
PRVPRV-218252026-09-08T00:14:40ZSOPHIA—LYNCH1967-10-21UHC-01980-86•••-••-70487369644069-UNKNOWN··UNKNOWN··—·nullUNKNOWNUNKNOWN
PRVPRV-278722026-04-04T02:11:52ZRobert—Harper1995-09-18··UHC-35694-15—628-313-9197—4989 MAIN STChandlerAZ85219N/Anull
PRVPRV-277202026-03-01T18:05:16Zlsa I—wood1938-11-08UHC2023858··—951-831-9663LISA.WOOD@HOTMAIL.COM7709 Meadow LaneGLENDALEAZ85369—N/A
PRVPRV-248302026-01-16T16:05:35ZJerryPWeaver7/21/1993··UHC-19409-86—333-988-7182-1888 UNION STREETCharlotteNC28240null—
PRVPRV-263652026-07-30T10:54:21ZJacob—Ramirez1979-06-01—NULL(207) 207-0968UNKNOWN··6959 WILLOW CTTEMPEAZ85296··—-
PRVPRV-259492026-08-26T10:04:21ZMADISON··—HENDERSONDec 16, 1985UHC6360778-5004203551NULL2197 Highland AveSan DiegoCA92140—UNKNOWN··
PRVPRV-242552026-05-08T03:24:05ZEthan—Ramirez19700710—UNKNOWN(876) 644-5604—5724 MOUNTAIN VIEW DRIVETucson·AZ85711-1283NULL—
PRVPRV-248082026-03-27T12:46:26Z·Aaron—Willis1/26/1992UHC-69925-56null·309-590-2243AARON.WILLIS@PROTON.ME446 GRAND AVENUEFresnoCalifornia93747null-
PRVPRV-268152026-10-16T18:31:34ZDennis—Phillips12/07/96——7066237718null725 Grand AvenueOrlandoFL32822N/ASELECT-EPO
PRVPRV-273912026-03-08T12:53:49ZSofiaA.Ortiz1995-11-04UHC-16134-88NULL439-981-6570····-N/AN/AN/AN/ACORE-HMO
PRVPRV-286502026-07-17T13:23:15ZChristopher—Davis1986-04-14N/A—3032139christopher.davis@outlook.com6306 JEFFERSON AVEAtlantaGeorgia·30301—NULL
PRVPRV-269712026-09-22T04:49:38ZOliviaQWang1971-01-19UHC-18220-29N/A570.872.0991null5888 LINCOLN WAYGilbertAZ85259NULLnavigate-hmo
PRVPRV-244092026-09-15T09:10:58ZJanet—Jones1955-05-14NULLNULL3788306660-2586 River RdEden PrairieMN55337-—
PRVPRV-231532026-10-03T05:14:03Z·CAROL—HUGHS1979-02-28NULL•••-••-6328(337) 547-7490NULL2280 Bayshore DriveSeattleWA98128NULL····
PRVPRV-22089 2026-03-16T23:13:00ZKatherine—Hernandez11/01/1940UHC-76710-68UNKNOWN947-916-7005katherine.hernandez27@outlook.com3537 Broadway Apt 38GlendaleAZ85349nullnull
PRV PRV-230222026-07-28T01:19:46Z·heatherQ··crawford1966-01-27NULL•••-••-6863UNKNOWN-5137 Ridge Rd Apt 5ChandlerAZ·85286—-··
PRVPRV-253312026-04-02T09:49:33ZDylan—Watkins·02/07/57-null626-329-7888dylan.watkins14@proton.me··7577 HIGHLAND AVEGlendaleAZ85378nullN/A
PRVPRV-253182026-02-11T08:36:06ZHeather—Reid1963-12-13UHC-28309-78—894-504-6104HEATHER.REID94@OUTLOOK.COM2510 Apache BlvdTucsonAZ85735UNKNOWNSELECT-EPO
PRVPRV-219642026-09-21T11:25:21ZDouglasQ··Schultz·1954-10-05——350-604-4122—3506 BASELINE RDMiamiFL33103-0892—NULL
PRVPRV-295642026-08-10T10:12:51ZSusan—Hart1938-10-02UHC-24309-19•••-••-9061355-600-6318—2889 Maple Avenue Apt 21FresnoCA-·N/A—
PRVPRV-266212026-07-01T06:46:48ZJudy—Carroll2006-05-24UHC-24401-98null(904) 829-2620—2492 Mountain View DrSAN DIEGOCA92157-1467——
PRVPRV-294362026-09-17T06:48:02ZDanielXPena··01/08/71·UHC-54987-16··——7245 CAMELBACK ROADMiamiFL33108NULLUNKNOWN
PRVPRV-229052026-04-18T19:29:13ZMariana—Chavez11/1/2005—•••-••-4114955-552-7673MARIANA.CHAVEZ73@OUTLOOK.COM3008 SUNSET BOULEVARDHOUSTONTX·77018-MEDICARE-ADV-B
PRVPRV-229442026-09-11T08:11:25ZRonaldAScott1982-04-26UHC-68475-54—7644384206—9242 Grand AvePHOENIXAZ85010NULL—
PRVPRV-279282026-03-22T04:45:15ZBARBARA—CARR2000-03-19N/A•••-••-9518(595) 388-7054barbara.carr@gmail.com4270 Jefferson Ave·OrlandoFlorida32845UNKNOWNnull
PRV PRV-289002026-05-10T13:28:40ZChristinaVMills··1968-09-02UHC6487791•••-••-7905722-730-1526N/A2856 GRAND AVENUEFresnoCA93737-NULL
PRVPRV-274562026-06-21T01:01:35ZArthurP.Carter···1953-09-20—NULLNULLarthur.carter@yahoo.com7582 Washington St·ChandlerAZ85272—N/A
PRVPRV-283352026-03-13T19:16:37ZPATRICIA—RODRIGUEZ1970-07-28--—PATRICIA.RODRIGUEZ@AOL.COM8202 Willow CourtGilbert··AZ85200··N/A
PRVPRV-201682026-08-22T01:34:23ZDIEGO—·SANCHEZ02/07/1965UHC1336528null590-547-5100diego.sanchez14@hotmail.com9567 Park PlCharlotteNorth Carolina28231NULL·-
PRVPRV-250802026-08-03T18:56:58ZKaylaLGibson1942-11-11UHC-77064-16—16126257015···522 Washington StEden PrairieMN55391-·-
PRVPRV-248222026-08-10T16:51:52ZEDWARDKCOX19780711··UNKNOWN·4298913946—8251 Sage CourtHOUSTONTX77023-2491--
PRVPRV-251742026-10-15T17:51:15ZSantiago—Romero1978-11-20nullnull882-972-3793santiago.romero29@proton.me2666 Forest AvenueHoustontx77076—NAVIGATE-HMO
PRVPRV-242162026-08-18T20:23:30ZABIGAILZGRIFFIN10/20/1998UHC9617084NULL··453.976.8681N/A7618 Ridge Rd Apt 6MinneapolisMN55446N/A—
PRVPRV-284122026-04-18T03:29:04ZwilliamTwongMay 15, 1980null—(420) 745-5743NULL··7700 Palm Drive·ScottsdaleAZ85254-·UNKNOWN
PRVPRV-255522026-10-12T05:57:55ZAustin—Smith2006-09-13··UHC9597184•••-••-1072·nullaustin.smith@outlook.com8639 LINCOLN WAYJacksonville··FL··32272NULLMEDICARE-ADV-B
PRV PRV-217592026-07-02T16:33:21ZScott—Santos1961-01-22N/ANULL449-265-2066N/A9274 Maple Avenue·ChandlerArizona85287-4974··null
9,596 rows, page 36 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.489Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty