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-268232026-10-05T09:07:42ZMEGAN—RIOSNULLUHC-47867-27—18323654987··—9068 Central AvenueAtlantaGA30361nullN/A
PRVPRV-289202026-09-19T02:01:09ZLinda·D.Ross1956-08-11NULL—449.499.3190linda.ross@outlook.com3198 SUNSET BOULEVARD··San AntonioTX78280UNKNOWNnull
PRVPRV-258402026-05-09T04:22:35ZOLIVYAZARNOLDMay 23, 1940UHC-48489-95•••-••-8546800-604-6003olivia.arnold11@icloud.com5441 Willow CourtScottsdaleAZ85216—N/A
PRVPRV-240032026-03-31T15:42:20ZTucker—Pamela1974-08-08—UNKNOWN+1 218 907 5748pamela.tucker62@yahoo.com7360 JEFFERSON AVEATLANTAGA30385UNKNOWN···NULL
PRVPRV-234252026-05-26T07:19:37ZANNA—PHILLIPS1969-09-13UHC-63056-45·-+1 501 551 2182N/A·7473 Camelback Rd #928AUSTINTX78794——
PRVPRV-266952026-07-20T20:57:09ZBilly—Bradley19980518UHC-31626-51•••-••-5033(841) 383-4471—2621 Palm DriveAtlantaGA30374NULL··UNKNOWN
PRVPRV-279482026-06-29T07:43:17ZMaryT.Gibson2003-10-10UHC-23222-22··2763901042—4420 DESERT SKY BLVDAtlantaGeorgia30339——
PRVPRV-295282026-05-30T19:05:58ZGEORGE—RAMOS03/15/1962NULL•••-••-9934692-601-1459-2114 WILLOW COURTSeattleWA·98113UNKNOWNCHOICE-PLUS-PPO
PRVPRV-253712026-03-08T07:31:15ZJulie—Hughes1993-02-08N/A·null15419353243—5616 Central AvenueOrlandoFL··32819NULLN/A
PRVPRV-277452026-10-08T23:29:43ZPamelaNReid7/6/1986UHC-83233-52UNKNOWNUNKNOWNpamela.reid@proton.me8710 Sunset BlvdHoustonTXN/A··—
PRVPRV-218302026-01-14T20:00:05ZSanchez, Andrea——Jan 3, 1951··UHC-98290-98•••-••-8651+1 312 897 5630··UNKNOWNnull—UNKNOWNUNKNOWNN/AOPTIONS-PPO
PRVPRV-263102026-09-08T09:09:57ZPhilip—Rodriguez1939-08-18N/A•••-••-363312717791205—4856 Desert Sky BlvdAtlanta·GAnull-—
PRVPRV-218042026-01-01T05:12:50ZCamila—Webb1977-10-18UHC-57634-72—(886) 477-9404··4854 BAYSHORE DRIVEScottsdaleAZUNKNOWN-NAVIGATE-HMO
PRVPRV-257372026-02-07T05:53:21ZAmber····Munoz1984-08-17UHC-03266-71null(558) 527-3189AMBER.MUNOZ@HOTMAIL.COM9780 Maple AveCHANDLERAZ85275··N/A··MEDICARE-ADV-A
PRVPRV-228832026-06-07T12:00:23ZRyan—Contreras2005-06-09UHC-89560-36·null210.722.8461RYAN.CONTRERAS69@GMAIL.COM3154 Elm StreetSeattleWA·98117null-
PRVPRV-224052026-03-12T08:10:34ZVirginia—Freeman2005-02-19-—795-248-7698virginia.freeman44@hotmail.com2185 Mountain View DrMinneapolisMN55465N/A-
PRVPRV-206752026-10-14T13:23:03ZnicoleItorresJan 12, 1982N/Anull631-392-2199nicole.torres14@aol.com6945 Market StSan Diegoca92103——
PRVPRV-209372026-03-24T17:44:02ZGARY—PALMER1948-08-24UHC-85894-33—17318882464gary.palmer48@hotmail.com342 Washington StEden PrairieMN55395—NAVIGATE-HMO
PRVPRV-267432026-01-31T09:25:36ZTyler—Davis07/28/80null—(361) 289-0257UNKNOWN3924 Bayshore Dr·NashvilleTN37267·null—
PRV PRV-249772026-05-13T05:17:39Zbilly—aguilarApr 2, 1961nullN/A6865545261—4931 Lincoln WayLas Vegas·NV89123—CHOICE-PLUS-PPO
PRVPRV-238392026-03-19T10:25:49ZJORDANQELLIOTT24-03-1991··UNKNOWNNULL248-927-3796NULLN/A—NULLUNKNOWNNULLOPTIONS-PPO
PRVPRV-249432026-03-12T07:56:04ZMELISSA—HOLMES25-12-1950N/A—·NULLmelissa.holmes@proton.me7566 Spring StSan AntonioTX78203—N/A
PRVPRV-213732026-02-27T07:28:52ZPATRICCIA—SIMMONS1963-12-19UHC-34156-49··UNKNOWN(684) 293-5793—320 Sage CtLos Angeles·CA90029··-
PRVPRV-27766 2026-07-09T04:07:44ZcarlQ.porter··Sep 9, 1982—-(971) 283-0586carl.porter@icloud.com7075 Willow CourtMiamiFL33172—null
PRVPRV-20777 2026-04-22T15:35:22ZRalphKCunningham1969-04-16N/A—974-419-4940—3821 Spring StreetORLANDOFL32833null··—
PRVPRV-275222026-09-28T03:01:58ZStephenYWebb·06/21/1950——(702) 864-1262·N/A3827 Camelback RdMesaAZ85215-—
PRVPRV-250842026-07-10T13:16:13ZYUKI—OLSON1963-11-14UHC-91705-70—·15208408983N/A2544 Forest AveFresnoCA93788null—
PRVPRV-250642026-09-11T20:08:58ZTorres, Kelly——1948-09-25N/A—4958807345-4174 Ocean AvenueEden PrairieMinnesota55304·UNKNOWNNULL
PRVPRV-242662026-04-03T13:54:52Zdiana—mendez·1997-04-20—-3518197282-··—-·-—UNKNOWNNULL
PRVPRV-234372026-02-08T18:31:44ZZacahry··Knight7/23/1959NULL-+1 221 346 6053UNKNOWN6436 Grand AveCharlotte··NC28290UNKNOWN····
PRVPRV-200102026-02-13T20:12:58ZCollins, Sarah——1940-09-18UHC-06515-42·-(647) 327-2512··N/A6195 Camelback Rd #834MesaAZ85275——
PRVPRV-234722026-04-20T09:15:21Z OBrien, Douglas——1966-08-26UHC-37735-01•••-••-24272259087231—6471 Church StChandlerAZ85231nullCHOICE-PLUS-PPO
PRVPRV-258042026-02-05T02:54:18ZBRADLEYFPATTERSON1990-01-05··—UNKNOWN205-918-6356-NULL··—····—NULL—
PRVPRV-219602026-04-28T06:14:48ZCastillo, Donald——1942-07-26UNKNOWN•••-••-39205183424288donald.castillo64@proton.me2970 Market StPhoenix·AZ—····—
PRVPRV-227962026-04-12T19:54:50ZBradley—Austin1938-00-57UHC-84381-58-411-675-3479N/A7207 Washington Street··FresnoCA93738—null
PRVPRV-201122026-01-05T14:30:02ZDIEGO—·PAYNE04/18/62—NULL+1 757 806 7166-9440 Mountain View DrScottsdaleAZ85213-3238—-
PRVPRV-202952026-04-09T03:52:41Z·Kathryn L.—Vasquez1985-08-26UHC1618262null831-670-4889KATHRYN.VASQUEZ@ICLOUD.COM1861 Cedar LnLos Angeles··CA90060-OPTIONS-PPO
PRV PRV-210772026-08-10T18:46:13ZOmar—Knight1954-03-18UHC-76996-54null(719) 529-3740—6084 Grand AvePhoenixAZ85090-·-
PRVPRV-271122026-06-07T01:34:53Z·SARAH—REED1945-11-23UHC-93227-26—4773336920null5662 Oak StLos Angeles··CA90052null··OPTIONS-PPO
PRVPRV-267152026-05-18T23:30:22Z·Pamela—Hayes25-02-1964UHC-52829-16•••-••-69968894170874pamela.hayes@yahoo.com2372 ELM STSan DiegoCA92174—UNKNOWN
PRV PRV-287442026-07-21T18:27:31ZedwardEdavis1969-12-02UHC-71730-05UNKNOWN+1 221 570 9716edward.davis@proton.me3287 River RdSacramentoCA95816—MEDICARE-ADV-B
PRV PRV-288192026-09-16T15:21:55ZFrank··Yang1954-06-13UHC-01242-71—(614) 745-2696-4140 Jefferson AvenueNashvilleTN·37272NULL-
PRVPRV-26759 2026-05-04T09:54:12ZKATHLEEN··—ALVARAADO20060904UHC-63954-89-19107986533kathleen.alvarado61@aol.com1905 Sage CtColumbusOH43226NULLCHOICE-PLUS-PPO
PRVPRV-217572026-07-21T14:45:14ZRuiz, Josse——9139-09-22——9006602747—1145 Mountain View DrSacramentoCA95899····MEDICARE-ADV-A
PRV PRV-291162026-05-27T02:12:05ZJohn—Austin1939-07-15UHC-44139-94N/A4877941078null··6587 Bayshore DrEden PrairieMN55331NULL····
PRVPRV-250332026-07-12T15:09:42ZWalter—Washington1981-12-16UHC-34661-92•••-••-80385097985418··walter.washington@icloud.com6312 PARK PLACENashville·TN37285—NULL
PRVPRV-270772026-09-30T18:16:15ZBradley—Rivera1986-01-09UHC-14146-70—928.709.2307NULL1580 Willow CtJACKSONVILLEFL32239-CHOICE-PLUS-PPO
PRVPRV-209272026-01-20T22:52:06ZRAYMOND····MURPHYDec 8, 1991null•••-••-0539nullraymond.murphy@aol.com9534 Lincoln WaySCOTTSDALEAZ85243—UNKNOWN
PRVPRV-233422026-03-06T10:13:59Z·McCoy, Doris——1984-08-26——(664) 476-0105doris.mccoy@icloud.com7393 River RoadGilbert···AZ——NULL
PRVPRV-245802026-03-25T22:00:12ZMaria····Vazquez1954-10-10··null—238-550-6675—6910 JEFFERSON AVEMIAMIFL33150——
9,596 rows, page 81 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:46.066Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty