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-203822026-05-04T18:19:22ZJulia—Sanders17-03-1990UHC7522178NULL(988) 904-5241julia.sanders@outlook.com9533 Washington StDENVERCO80232——
PRVPRV-203872026-06-07T04:01:10ZMorrisonH··Carl26-06-1989UHC-22994-76——N/A7763 Hillcrest Rd·TempeAZ85291··N/A—
PRVPRV-207322026-05-16T08:09:24Zgregory—wheeler1949-09-13UHC-48536-70•••-••-8911828-763-2378gregory.wheeler58@aol.comNULL··————CORE-HMO
PRVPRV-285642026-09-17T03:11:09ZMartha—Jacobs1985-12-16··UNKNOWN•••-••-77909062861168—5562 Canyon RdSan DiegoCA92133UNKNOWN—
PRVPRV-224742026-03-19T04:07:09Z·AISHAH.SCOTT·1950-09-05UHC-97838-17•••-••-6786978-908-1586aisha.scott@outlook.com8705 Ridge RdORLANDOFL32885—CORE-HMO
PRVPRV-279212026-08-13T12:02:10ZJessica—Butler1982-09-01UHC-12602-12•••-••-9170427.913.9611JESSICA.BUTLER@AOL.COM2868 MAPLE AVENUEPhoenixAZ85006—null
PRVPRV-263072026-06-27T16:52:56ZNathan—Martin1993-02-17UHC-79747-51null(363) 221-0883NATHAN.MARTIN64@PROTON.ME·3231 Central AvenueLas Vegas··NV89120·nullN/A
PRVPRV-289262026-06-09T19:57:31ZJordan, Robert····—1972-11-19UHC-91338-54null—N/A913 Hillcrest RdCHANDLERAZ85295NULL·MEDICARE-ADV-B
PRVPRV-231422026-08-13T08:09:16ZJacquelineFFlores16-12-1939UHC-03070-53—4285278069—4401 Union StreetLas VegasNV———
PRVPRV-244982026-07-10T14:29:35ZDoris··—Lee··03/07/1970UHC-29225-43-N/AUNKNOWN5764 Lake View RdCharlotte·North Carolina28211······
PRVPRV-274422026-05-03T22:48:07Z Carol—Payne1945-09-02N/A•••-••-61933997799243carol.payne98@icloud.com9850 Mountain View DriveSeattleWA98130——
PRVPRV-273052026-10-08T09:13:56ZBenjamin—Rose2007-04-19N/A··N/A—3350 Maple AvenueScottsdaleAZ85216-··—
PRVPRV-232752026-09-02T13:34:03Z JACOB·VWELCH01/25/58—null-NULL1663 HIGHLAND AVEJacksonville··FL32216-7970-—
PRVPRV-286872026-06-10T15:46:32ZWayne··Ortiz2005-03-01UHC-34770-98•••-••-8038(744) 484-6709wayne.ortiz@outlook.com··8399 Grand AveATLANTAGANULLUNKNOWN-
PRVPRV-204232026-05-15T18:27:03ZMariaWMendez1940-06-16UHC-87975-31N/A(762) 978-3398null2907 CEDAR LANEOrlandofl32848-2338NULL—
PRVPRV-282082026-02-07T07:31:41ZELIJAH—PADILLA2006-09-07UHC-90343-90—428-501-4942-5747 Willow CtGlendaleAZ85381—-
PRVPRV-250022026-06-09T06:03:02ZGary—Larson1962-04-20UNKNOWNNULL544-758-6594N/A·892 Elm StCOLUMBUSOH43279——
PRVPRV-243532026-10-14T13:55:50ZGregory—Palmer1986-02-26UHC-33450-51null314-619-8561UNKNOWN8004 CHURCH STSCOTTSDALEArizona··85256UNKNOWNNULL
PRVPRV-253792026-08-11T07:40:03ZPATRIKKCORTEGA09/09/1990NULL-831-565-4725PATRICK.ORTEGA73@AOL.COM3527 Canyon RoadATLANTAga30306NULLNULL
PRVPRV-230732026-02-13T22:59:08ZSantiago—Snydre10/11/1990—•••-••-4359696.641.1171—7460 Forest AvenueJACKSONVILLEFL32230—null··
PRVPRV-210452026-02-11T02:41:09ZKEIITH I—VAZQUEZNULLUHC-01356-46-·2096682567—6164 GRAND AVEScottsdaleAZ··85299—N/A
PRVPRV-248712026-05-25T14:58:13ZLOGAN—KELLY06/24/1978-—(896) 510-4633logan.kelly54@aol.com6858 CENTRAL AVENashvilleTN37221-7790N/A—
PRV PRV-276462026-03-12T08:34:34ZKARENEROMERO19860319—null(601) 414-5517-6696 Spring StDenverCO80276-8977NULL—
PRVPRV-229642026-02-08T13:55:37ZBRYAN—LYNCH1957-04-19··null+1 844 992 3921—7025 Bayshore DriveChandlerAZ85247null—
PRVPRV-231522026-10-01T17:36:34ZLauraW·Johnsoon1981-01-03nullN/A-N/A184 Meadow LnSan AntonioTX78203··—
PRVPRV-222192026-04-27T01:45:00ZGERALDLSNYDER1967-10-23——649-334-0589—6460 CAMELBACK RDHOUSTONTX··77038NULL-
PRVPRV-263922026-04-29T12:48:23ZLAURENDMONTGOMERY··Dec 10, 1963UHC-09615-90—17428355449LAUREN.MONTGOMERY@PROTON.ME2528 Desert Sky Boulevard Apt 16MinneapolisMN·55495-N/A
PRVPRV-265582026-06-26T15:43:13ZJONATHANB··ALVARADO1956-01-03null-16736043356NULL2769 Desert Sky BlvdSan DiegoCA92185—·-
PRVPRV-210682026-02-12T12:44:47ZMichelle··—Richards03/15/44··N/AN/A3858035714-7612 UNION STREETSan DiegoCA92188—N/A
PRVPRV-233172026-01-12T19:25:22ZKevin—Warren1983-09-19—-5763571395—7739 Broadway·GilbertAZ85220··OPTIONS-PPO··
PRVPRV-215232026-05-10T07:42:05ZBrian—Fox2002-04-21UHC-49916-85—5457475534····9335 Indian School RoadOrlandoFL32846—MEDICARE-ADV-A
PRVPRV-219392026-08-02T01:53:15ZAnthonyD··CollinsFeb 19, 1966null—572-952-5310null1720 Pine DriveCharlotte·NC28251UNKNOWNCORE-HMO
PRVPRV-28969 2026-08-06T02:30:03Z·Edward—Boyd2001-31-09··•••-••-3936+1 717 333 8374edward.boyd@gmail.com··8783 Willow CourtSan DiegoCA92123—N/A
PRVPRV-257352026-03-11T00:56:59ZDIAENN.YANG9/9/2001UHC1144452—2616069814null77 Main StreetSan AntonioTX78208··N/ANULL
PRVPRV-292702026-08-26T21:09:55ZELIZABETH—SCHULTZJun 12, 1981UHC5043256•••-••-7877UNKNOWNN/A·8960 Union StPhoenixAZ85065N/Anull
PRVPRV-27529 2026-01-19T22:51:03ZDOUGLAS······ARNOLD1991-03-01——(918) 725-8361douglas.arnold21@gmail.com4155 LINCOLN WAY #994TAMPAFL33620--
PRV PRV-219952026-09-24T01:44:34ZHunt, Alex——·2003-02-22NULL•••-••-3382NULL—2344 Church St Apt 9··MiamiFlorida33166NULLOPTIONS-PPO
PRVPRV-238172026-03-24T02:31:11ZBryanRSilva19551105-•••-••-8873-—·612 Church StSan Antonio··TX78223——
PRV PRV-259352026-09-07T15:18:31ZPriyaHMcDonald1965-08-04UNKNOWN—(696) 636-3485—5136 Apache Boulevard··TempeAZ85277·NULLnull
PRVPRV-287312026-09-16T04:43:29ZTucker, NoahA—1993-06-02—-N/A··NOAH.TUCKER@ICLOUD.COM2659 Park PlCOLUMBUS··OH43219—UNKNOWN
PRVPRV-260872026-06-12T00:56:11ZBradley—FosterOct 12, 1992——(369) 218-3356—8231 Grand AvenueTempeArizona··85290-2804nullN/A
PRVPRV-259862026-02-24T01:48:43ZHeather—Freeman1961-09-08—•••-••-353512063831906····2537 Grand Avenue Apt 15Orlando··FL32846—null
PRVPRV-284612026-07-15T20:09:12Zchristina—gonzalez23-01-1968····—(208) 443-1625N/A···87 Sage CtJacksonvilleFL32218NULLNULL
PRVPRV-285502026-09-29T07:12:32ZChristineARios09-05-1942null•••-••-4720·(448) 228-3647null··2798 Jefferson AvenueNashvilleTN37216—CORE-HMO
PRVPRV-227482026-05-17T01:12:48ZELIZABETH—CARR19861018·NULL—(779) 433-4987—4100 Ocean AvenueCharlotteNC28226N/AMEDICARE-ADV-A
PRVPRV-290292026-02-25T16:48:01ZBRENDA··HGORDON1965-06-14—N/A(479) 323-8832NULL6342 Harbor Boulevard #846JacksonvilleFL32227-8846·NULL·SELECT-EPO
PRVPRV-220642026-04-12T18:11:55ZAnna··Turneer1974-02-09UHC-90002-73•••-••-8665457-757-4672—6074 WILLOW COURTNashvilleTN37250UNKNOWNnull
PRVPRV-251482026-01-09T18:52:14Zdiane—kim1961-07-22——278-532-2639N/A··7258 SPRING STLOS ANGELESCA90069—MEDICARE-ADV-A
PRVPRV-253222026-09-25T04:12:09ZCunningham, Kvein——1962-09-09—N/A(260) 897-3093—NULLUNKNOWN··NULLN/A··UNKNOWN
PRVPRV-20428 2026-08-01T11:51:55ZSimpson, Nicole——1969-11-11UHC-07493-84—301.610.1518-802 RIDGE ROAD Apt 26NashvilleTN·37233——
9,596 rows, page 107 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:52.207Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty