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-276512026-08-23T15:36:25ZEthan—Sancehz1971-12-04—·NULL+1 562 327 9904ETHAN.SANCHEZ@GMAIL.COM1217 Oak St·San Antoniotx78252·nullnull
PRVPRV-292692026-02-06T09:16:53ZLARRYNHAMILTONNov 20, 1963UHC-53343-08—+1 816 787 6758UNKNOWN890 APACHE BOULEVARDGilbertAZ85264—UNKNOWN
PRVPRV-216802026-04-20T01:40:29ZJack—Armstrong1965-07-16NULLnull2577559969jack.armstrong@icloud.com9598 Oak StAtlanta·ga30356—UNKNOWN
PRVPRV-260882026-01-02T09:34:25Z JudithLFord1949-12-12N/ANULL18073744480judith.ford62@icloud.com4967 Cedar LaneChandlerAZ85263-8936UNKNOWNUNKNOWN
PRVPRV-255952026-02-04T22:46:16Z·jamesQmartin1966-02-17nullUNKNOWN16408622575james.martin@proton.me5807 Lincoln WayTampaFL33651NULLUNKNOWN
PRVPRV-290432026-01-16T00:47:46ZValentina—ReidApr 6, 1965UHC-92970-85—9096548valentina.reid8@aol.com6406 Camelback RoadNashvilleTN37267nullN/A
PRVPRV-260982026-06-08T16:38:52ZBarbaraZFields··UNKNOWNUNKNOWN—3183196559null5933 OAK STREETGlendaleAZ—UNKNOWN·UNKNOWN
PRVPRV-215702026-03-04T00:32:57ZDIGO—BRADLEY1981-06-15N/A-9405948889—N/A-NULL··UNKNOWN——
PRVPRV-256792026-05-15T21:26:13Zwayne—lopez09/08/88——+1 484 632 6261—·1771 Canyon RoadJacksonvilleFL32218··NULLCHOICE-PLUS-PPO
PRVPRV-244402026-08-28T06:33:52ZDoris—Ramirez1991-07-19·nullNULL427-443-1939doris.ramirez@proton.meNULL—null-UNKNOWNN/A
PRVPRV-225312026-07-11T10:04:07ZDIANEABUTLER·Feb 5, 1984UHC-36876-56null14077191224diane.butler@yahoo.com309 Hillcrest RdCHARLOTTENC28299null·N/A
PRV PRV-211882026-01-06T02:30:43ZColeman, Christine——1988-07-15—-··—·null3974 Desert Sky BlvdTampaFLNULLnullmedicare-adv-b
PRVPRV-287032026-08-12T13:37:59ZAustinLNguyen12/26/1940UHC-66691-05—3168952643—7868 Highland AveJacksonvilleFL32279UNKNOWN·N/A
PRV PRV-208722026-02-22T16:22:48ZRuth—Black19621109UHC-63053-46N/AN/Aruth.black86@yahoo.com3100 Washington StPlanoTX··75023—MEDICARE-ADV-B
PRVPRV-238102026-01-19T08:57:55ZJOHN—HICKS23-02-1993UHC-25546-25··-—john.hicks61@hotmail.com··4101 Hillcrest RoadCharlotteNC28299N/ACHOICE-PLUS-PPO
PRVPRV-229192026-06-14T07:52:19ZSophia—Richardson·1964-07-02N/AN/A+1 720 323 7001UNKNOWN2328 Church StPlanoTX··75004UNKNOWN··N/A
PRVPRV-292142026-10-02T18:25:17Zana—wilson9174-04-25——(957) 268-7427NULL6492 Jefferson AvenueCHANDLERAZ85258——
PRVPRV-293482026-02-14T18:28:56ZMadisonQ.Wilson1946-10-13UHC-30657-32—(476) 594-7630—1800 LAKE VIEW RDAtlanta·GA·30366—-
PRVPRV-245732026-08-08T04:44:18ZREBECCAUHART1962-03-15N/A·null+1 444 289 3304N/A2012 JEFFERSON AVENUEDALLASTX75284—NULL
PRVPRV-288552026-05-10T14:03:06ZAdam—Sanders·1948-02-04UHC-93095-79··-—-1697 Broadway··TempeAZ85279NULLCORE-HMO
PRVPRV-248842026-04-06T12:00:16ZRuth—Mills1958-02-08UHC-76487-98—7223504715-6603 Elm StNashvilleTN37205—N/A
PRVPRV-251052026-02-24T16:48:57ZMARIANA—TAYLOR04/02/2005UHC-39730-46•••-••-7100(203) 677-9596MARIANA.TAYLOR@ICLOUD.COM·-—N/A··null-—
PRVPRV-202402026-05-15T06:53:49ZBILLY—THOMAS1961-12-16UHC-23266-84•••-••-9521718-403-2127N/A394 Cedar LnMESAAZN/AUNKNOWN—
PRVPRV-293802026-03-29T14:26:07ZRose, Karen——1993-11-16UHC-41271-45-··877-648-6886NULL1976 Willow CtLas VegasNV89101--
PRVPRV-232292026-10-16T23:14:12Z—B—08/14/62UHC7474125—(624) 231-2131··-3629 Park PlTucsonAZ85771-6005N/ACHOICE-PLUS-PPO
PRVPRV-283292026-04-08T09:59:12ZThomas, Wallace——02/12/1978UHC-19625-02NULL··4596317662-4115 Market StreetLAS VEGASNV—null···SELECT-EPO
PRVPRV-21416 2026-08-10T06:20:36ZNancyWEstrada1976-03-22—•••-••-2102(791) 636-5612NANCY.ESTRADA@GMAIL.COM7743 Oak Street··PhoenixAZnull·-—
PRVPRV-292722026-05-19T11:54:43ZKEVIN—·WASHINGTON20080928null—(496) 772-5739kevin.washington@hotmail.com7626 Ridge Road Apt 10Plano·TX75046—NAVIGATE-HMO··
PRVPRV-273332026-08-03T09:16:52ZAaron—Alexander2030-19-56-NULL+1 494 312 9111—6261 Highland AveDenverCO··N/A—N/A
PRVPRV-223342026-04-30T10:00:24ZAngela—Park20040102UHC-74100-67NULL+1 427 729 2616UNKNOWN·2773 RIVER RDColumbusOH43217UNKNOWNNULL
PRVPRV-202292026-08-25T09:56:54ZAnnaSFisher1990-09-28NULL—938-446-6330····6576 Camelback RdLos AngelesCA—UNKNOWN·MEDICARE-ADV-A
PRVPRV-280812026-06-10T06:47:30Z·Josh—Gbison1987-11-05·nullN/ANULL—4752 Washington StTempeAZ85232-5506—MEDICARE-ADV-A
PRVPRV-269272026-07-16T19:49:43ZTYLER—TAYLOR10/27/1957—····(429) 629-8195··UNKNOWN4037 Indian School RoadLas Vegas···NV89163N/A-
PRVPRV-26491 2026-03-24T21:38:40ZSofia—Lawrence24-04-2001UNKNOWN•••-••-30409837878960NULL3103 Apache BoulevardLos AngelesCA90044—UNKNOWN
PRVPRV-276132026-08-03T05:30:17ZWilliam—·Olson1940-07-18N/AUNKNOWN··7209613519william.olson@icloud.com5935 Main St #980GilbertAZ85208——
PRVPRV-290132026-08-25T14:33:54ZGARY—WALSH1981-08-23UHC-49344-04—2243017533gary.walsh91@proton.me3763 CHURCH STTampa··FL33670-5266——
PRVPRV-263052026-02-26T16:03:32ZMasonLMiller12/23/1955·NULLnullUNKNOWN-825 MOUNTAIN VIEW DRHoustonTX77005NULL-
PRVPRV-289532026-07-28T06:53:17ZMATEOK.PATEL3/5/1961UHC-36080-99UNKNOWN507.609.2351—8109 Canyon RdSan AntonioTX78253-6015——
PRVPRV-208512026-01-27T10:06:16ZJoshua—Andrews1958-05-24—N/A886.686.2802—2045 Market StLOS ANGELESca90098····N/A
PRVPRV-248212026-03-21T04:01:20ZWEI—COOK·1991-12-07UHC-33024-75N/A639-959-9575NULL6459 Ocean AvenueGilbertAZ——-
PRV PRV-275712026-04-16T11:49:48ZKATHLEEN—DAY1966-11-21UHC-04206-33null4146753098-·3932 Meadow LnTampaFL33660—null
PRVPRV-237512026-08-11T08:59:31ZHarper, Luis——2/19/1954UHC-25060-78•••-••-92232319227326—NULLN/A——UNKNOWN····
PRVPRV-277142026-09-11T23:13:26ZMARQUEZNJUDITH1949-05-07N/A—17203739346null·null-—UNKNOWNUNKNOWNNULL··
PRVPRV-291002026-05-19T04:11:47ZLAWRENCE—BERRY··Jun 24, 1995—•••-••-8438467-204-1352······4585 Canyon RdMiamiFL33162nullCHOICE-PLUS-PPO··
PRV PRV-203972026-04-06T16:17:51ZThomasJGriffin1986-12-03UNKNOWNNULL(824) 942-0572N/A3794 Mountain View DriveCharlotteNC28247N/ANULL
PRVPRV-288322026-05-30T20:29:52ZJesseDWang1951-05-04UHC-64399-80•••-••-4468-N/A4970 GRAND AVECHANDLERArizona85245—-
PRVPRV-286242026-02-07T18:37:25ZCamilaO.Franklin1979-11-17UHC-02351-86N/A+1 419 487 1252—5533 Main StreetSan DiegoCA92122-·null
PRVPRV-226382026-09-29T01:07:43ZTheresa·TMorrison·1942-12-17UHC-09600-88UNKNOWN4987511810—9222 Baseline RdLas VegasNV89165null—
PRVPRV-253162026-05-03T03:24:56ZRogers··LarryFeb 10, 1970UHC-32272-09-+1 418 949 3983null7957 Highland AveEden PrairieMN55349NULL—
PRVPRV-268022026-08-22T12:08:39ZDAVIDASINGH1940-09-12·UHC-97681-49-7966927775—6257 Canyon Rd #356HoustonTX77051N/A—
9,596 rows, page 72 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:43.613Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty