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-261732026-09-21T08:11:21Z·WILLIESPARK21-02-1944UHC-43463-73null2909473765WILLIE.PARK9@PROTON.ME··3730 Elm StreetDenverCO80249-4505-—
PRVPRV-205952026-04-29T02:12:05Z·Vincent—Jimenez21-10-1996UHC-80139-49··-·805.985.0483vincent.jimenez@icloud.com6632 Sage CourtMesaAZ85202NULL-
PRVPRV-275502026-03-08T13:28:09ZPriya—Dean··1945-05-26UHC-97670-53—(682) 368-9397priya.dean@outlook.com9490 CENTRAL AVETempeAZ85220··N/ACHOICE-PLUS-PPO
PRVPRV-292412026-01-19T04:24:05ZSamantha—Meyer1963-07-12UHC-21895-52····3682992468samantha.meyer@aol.com887 Indian School RdDENVERCO80233nullnull
PRVPRV-293262026-09-09T05:17:09ZDIEGO—EVANS6/28/1964UHC-07580-34•••-••-0690448-660-6449—5946 Mountain View DrEden PrairieMN55392—OPTIONS-PPO
PRVPRV-249812026-04-09T08:35:02Z·Brenda—DunnOct 10, 1966—N/A7250756BRENDA.DUNN81@PROTON.ME··5964 Church StreetFresnoCA93745——
PRVPRV-216872026-09-07T16:11:56ZAMANDA—LARSONSep 26, 1946UHC-81514-74•••-••-8352238-476-6490-1439 Desert Sky BlvdTempeAZ··85258UNKNOWN—
PRVPRV-267882026-10-13T02:49:12ZJulie—Dixon··1947-05-03UHC-54209-32—(871) 805-0839—8661 BAYSHORE DRGilbertAZ85249N/A—
PRVPRV-261262026-01-18T16:17:22ZBrandonHHerrera1964-08-28—UNKNOWN16168224671brandon.herrera34@yahoo.com··7494 Meadow LnHoustonTX77047—CHOICE-PLUS-PPO
PRVPRV-23657 2026-10-07T07:05:26ZBverly—Perkins1945-06-28UHC-07200-69NULL(222) 765-0168NULL4683 Main StPlanoTX75021UNKNOWNUNKNOWN
PRVPRV-243292026-01-04T17:32:21ZRogers, Nicole——1957-02-15UHC-41707-94N/ANULLUNKNOWN—N/A-NULLN/AMEDICARE-ADV-A
PRVPRV-225162026-07-29T16:49:04ZVincent—Stvens1975-10-05UHC-60712-59-··+1 472 395 2432-1528 Baseline RdSacramentoCA95845UNKNOWNNAVIGATE-HMO
PRVPRV-281452026-05-18T20:38:21ZRoger····Robinsson1990-04-28UHC-22981-73—629.969.9491N/A2138 Ocean AveTampaFL33617—NAVIGATE-HMO
PRVPRV-267282026-03-28T19:04:06ZRandy—Gonzales06/10/1963——(760) 911-1496NULL·37 Forest AvenueLAS VEGASNV——UNKNOWN
PRVPRV-205852026-05-11T15:56:22ZJesse—Payne1945-07-15—•••-••-57618417245022··-8235 Grand AveNashvilleTN37226—UNKNOWN
PRVPRV-253762026-07-06T23:16:51ZCook, Emma——2/23/1960UHC-78970-78•••-••-1588UNKNOWN·EMMA.COOK@YAHOO.COM2069 Willow CourtHoustonTX77096UNKNOWNNULL
PRVPRV-270022026-02-04T21:29:20ZWalkerDFatima1977-09-21UHC-22421-47——FATIMA.WALKER@OUTLOOK.COM1113 Mesa DriveMesaAZ85266NULL-··
PRVPRV-252662026-10-16T15:51:28ZJose—Scott19790502NULL—7915452789UNKNOWN1716 Ridge RoadNashvilleTN——OPTIONS-PPO
PRVPRV-222202026-07-29T22:56:04ZDennis—Santos··9/18/1998UHC-61268-54•••-••-55177949523340null2748 Sage Ct··TucsonAZ85743—CHOICE-PLUS-PPO
PRVPRV-209082026-04-27T20:32:10Z·Ann—Taylor19450903-—4299117742-7489 Valley View DriveSCOTTSDALEaz85213-9508··nullUNKNOWN
PRVPRV-238852026-02-26T03:42:12ZLogan·Y.Gonzales1986-07-13UHC-19729-25•••-••-60646133580109LOGAN.GONZALES@ICLOUD.COM6025 River RoadOrlandoFL32899——
PRVPRV-233452026-04-06T19:25:12ZAmanda—Allen1954-10-20UHC-89738-84—4779035426null4736 Lake View RoadSAN DIEGOCA92196NULLNAVIGATE-HMO··
PRVPRV-239202026-08-21T00:13:25ZBRADLEYNJOHNSON·8/14/1940UHC-61999-90NULL521-570-6159-5772 Ocean AvenueMesaAZ85292null—
PRVPRV-260172026-06-23T10:14:14ZTylerKLi2/8/1940UHC-35505-93nullN/A-3573 Grand AvenueLas VegasNV89111N/A—
PRVPRV-276072026-10-17T03:43:06ZLUIS—WILLIS1980-11-19UHC-03152-84null14072630254UNKNOWN8903 Desert Sky BlvdDenverCO80210—null
PRVPRV-213272026-08-30T11:47:53ZWeiYSchmidt1974-03-03··N/A3189483940null1246 APACHE BLVD Apt 36··HoustonTX77022UNKNOWNUNKNOWN
PRVPRV-201832026-08-08T22:35:55ZKenneth—Dunn19500315-•••-••-7433·(421) 666-9973UNKNOWN—UNKNOWN-—nullNULL
PRVPRV-282202026-07-18T07:54:51ZJACK··—CHEN1959-04-17UNKNOWNUNKNOWN969.614.7099NULL·1301 Apache BoulevardGilbertAZ·85206-8181N/AUNKNOWN
PRVPRV-266722026-06-02T02:12:40ZArthur—Ryan06/17/1964——(600) 702-5020arthur.ryan55@icloud.com2777 Oak StTampaFL·33672-9283N/A—
PRVPRV-275652026-02-25T01:41:10ZBetty··—Willis1958-07-17-—9513124114betty.willis@icloud.com—-—·NULLNULL-
PRVPRV-222022026-06-03T14:10:02ZElijah—Aguilar1996-12-19UHC-11836-39nullN/A—1294 Sage CtJACKSONVILLEFlorida32292····—
PRVPRV-257882026-06-09T08:30:46ZVincent··Guerrero01-09-1965UHC-79757-63-—VINCENT.GUERRERO@ICLOUD.COM4646 Baseline RoadMinneapolisMN55483nullNULL
PRVPRV-222162026-07-05T22:30:28ZDonna—Ford1941-04-09N/Anull2505944418—6615 Canyon Road Apt 31Las Vegas·NV89157-2734——
PRVPRV-210762026-03-06T18:16:34ZKevin—Foster2005-12-06UHC-75040-45•••-••-3171326-330-5186NULL262 Jefferson AveDallastx75206N/A······
PRVPRV-275012026-03-03T02:48:15ZOBRIENM.LAURA··08/16/00N/A—+1 448 600 1681—3657 Desert Sky Boulevard Apt 36LOS ANGELESCA90029····N/A
PRVPRV-279002026-02-04T13:47:22ZEUGENE—CRAWFORD1954-05-05··NULL·null986-798-9533null6267 BroadwayScottsdaleArizona85277-MEDICARE-ADV-B
PRVPRV-285412026-07-02T21:43:05ZYuki—Maldonedo5/26/1980—null(680) 678-5902—647 Church StOrlando··FL32802-—
PRV PRV-234442026-03-04T21:00:52ZJanetERyan06/25/1951··UHC0766448•••-••-3477+1 529 486 2951null1077 Sage CourtMINNEAPOLISMN··55435—N/A
PRVPRV-260842026-02-09T03:18:31ZKeith—Diaz··1996-11-13—•••-••-6130869-603-7650···UNKNOWN2922 Park PlMinneapolisMN55455N/ANULL
PRVPRV-228052026-07-15T06:52:45Zjeffrey—garza09/09/1979UNKNOWNNULL858.921.4752N/Anull—UNKNOWNNULLnullNULL
PRVPRV-222402026-07-05T14:06:50ZAlice—Murphy9/28/1967UHC-19582-46UNKNOWN3518854451ALICE.MURPHY@HOTMAIL.COM—null··-N/A—UNKNOWN
PRVPRV-207372026-07-04T22:52:15ZJERRYXJOHNSON1966-05-03—•••-••-6663565.339.0096N/A5614 Palm DrSan DiegoCA92125——
PRVPRV-218422026-03-26T19:43:24ZAlexisX··Wheeler1957-05-26NULLNULL3639724297NULL6355 Highland AvenueOrlando··FL32890N/AMEDICARE-ADV-A
PRVPRV-223562026-04-24T13:02:14ZAhmed·J.Phillips1944-01-07UHC-63412-32—986-831-2555-·324 Park PlGilbertAZNULL—-
PRVPRV-203622026-09-20T02:06:41ZTheresa—Alvaraado2002-04-28——6038637157theresa.alvarado@hotmail.com4091 Ridge RdAtlantaGA30371—CHOICE-PLUS-PPO
PRVPRV-254662026-08-10T09:03:05ZMegan—Ford2008-05-18UHC-44478-63•••-••-7006—N/A··1688 BAYSHORE DR #942ColumbusOH··43231——
PRVPRV-232962026-06-03T03:45:43ZANGELA—KING1988-12-23UHC-91366-31—568-937-6706—UNKNOWNnullNULL—N/AMEDICARE-ADV-B
PRVPRV-290272026-04-28T09:15:23ZCHRISTOPHER—ROSS··02/16/90UHC-51132-99NULL(769) 832-6458—5213 SPRING STSeattleWA98152UNKNOWNOPTIONS-PPO
PRVPRV-232392026-06-10T08:41:17ZPETERIMCCOYApr 2, 2000N/A-·+1 879 988 4815NULL3108 DESERT SKY BOULEVARDColumbus··oh43270-—
PRV PRV-252392026-01-12T19:29:56ZJanice—Marquez09/08/38UHC-17144-80•••-••-93499737372—8672 Cedar LaneChandler··az85253UNKNOWNMEDICARE-ADV-A
9,596 rows, page 54 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.617Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty