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-271502026-04-08T16:16:53ZCharlesPMurray1952-01-15—UNKNOWN—charles.murray@icloud.com8544 Apache BlvdNashvilleTN37208N/ACHOICE-PLUS-PPO
PRVPRV-236112026-03-14T06:18:13Z·Helen—Torres·Mar 23, 1995UHC-80874-52UNKNOWN615-513-6040N/A-———N/A-
PRVPRV-248432026-05-12T19:06:09ZMreno, WillieG—07/25/65——284-532-2100-nullN/A—UNKNOWN-null
PRVPRV-209702026-02-03T03:17:02ZDOROTHY—ROGERS1976-08-24nullUNKNOWN340-719-9887DOROTHY.ROGERS78@OUTLOOK.COM5012 ELM STDallas··TX75238—-
PRVPRV-235902026-07-10T19:21:06ZVirginia F—Smith1963-08-07·UHC-21841-47•••-••-8007-null··4860 CANYON ROADLas VegasNevada89153N/A—
PRVPRV-246902026-07-27T00:25:46ZKENNETH—·THOMPSON1952-02-21-—(476) 547-2424KENNETH.THOMPSON85@OUTLOOK.COM··2624 Central AvenueSan AntonioTX78270—N/A
PRVPRV-287552026-05-31T02:18:15Z·LarryZRamos1943-02-14null•••-••-3796538-262-2198-—nullN/AN/A—CORE-HMO
PRVPRV-232092026-05-07T17:38:10ZAlan—Morgan06/02/1975-—284-511-6754alan.morgan95@hotmail.comnullNULLUNKNOWNnull—··
PRVPRV-278002026-03-05T17:07:28ZGeraldK.Robertson09/20/45··UHC5225314UNKNOWNN/A··gerald.robertson@icloud.com2789 Palm DrPhoenixAZ··——MEDICARE-ADV-B
PRVPRV-269062026-10-16T21:36:29ZScott—Duncan10/26/1997UHC-47476-28—5253736120NULL4543 Indian School Road··GilbertAZ85261—-
PRVPRV-280822026-02-04T13:08:50Z·JOSHIGYBSON05-11-1987··UHC-80149-44N/A(398) 345-3076joshua.gibson87@proton.me4752 Washington Street·TempeAZ85232-2037N/AMEDICARE-ADV-A
PRVPRV-227502026-06-07T18:53:27ZRalph—Simmons·05/14/62N/AN/A5336064870····6693 Washington StSan DiegoCA92176NULLnull
PRV PRV-253122026-10-02T20:20:36ZFatimaKGrant··1940-04-28·UHC-54519-79—-N/Anull—N/A—UNKNOWN—
PRVPRV-263192026-02-22T08:33:50ZDeniseRWang20050713UHC-08918-74null19452834407—1095 Bayshore DriveSACRAMENTOCA95863——
PRVPRV-239972026-09-28T14:17:46ZSarahIOliver1996-07-24UHC3290231N/A··+1 228 513 6446··-4779 Union StreetMinneapolisMN55405——
PRVPRV-238182026-03-23T23:03:44ZRichard··Alvarez23-07-1969—null816-292-9878NULL5615 Oak StreetTampaFlorida33653-1805——
PRVPRV-235722026-08-08T05:06:39ZNATALIE—TURNER1989-06-07UNKNOWNUNKNOWN(403) 424-4528natalie.turner@proton.me9798 Spring StSan AntonioTX78202—-
PRVPRV-229532026-07-06T04:54:26ZChristine—Morales··2007-01-19UHC-18121-75•••-••-64305674677874UNKNOWN9879 Lincoln WayFresnoCA———
PRVPRV-251332026-06-13T04:30:10ZAndrewCJohnson1988-02-15··NULLNULL366.512.9442null845 Pine DrPlanoTX··75013N/AUNKNOWN
PRVPRV-270612026-06-17T23:01:53ZGloria—Brown05/04/05··nullUNKNOWN839-767-7849null3815 Church StSCOTTSDALEAZUNKNOWN—N/A
PRVPRV-268462026-07-27T11:26:56Z·Campbell, KarenV—1942-01-28·NULL—(970) 641-3040null4437 RIVER RDColumbusOH43264nullMEDICARE-ADV-A
PRVPRV-251682026-10-16T01:02:30ZJames—Crawford1974-01-28UHC-30066-13-··922.556.8912—3463 Washington StreetTampa·Florida33670-7367N/AMEDICARE-ADV-A
PRVPRV-228412026-02-24T10:56:16ZElijah—·Clark2002-10-25UHC-58917-79—3834939299N/A7887 Market StGilbertAZ85208—NULL
PRVPRV-276252026-09-05T06:07:14ZRaymond—Jenkins3/16/2004-NULL+1 919 913 1442-·669 Washington StPlanoTX75097N/Anull
PRVPRV-203772026-01-14T14:08:41ZMaria—Simpson1939-09-04null·null5755528maria.simpson@aol.com9735 Canyon RdCharlotteNC··28269NULLUNKNOWN
PRVPRV-225712026-07-07T01:10:38ZJohn—Lee12/10/80-UNKNOWN278-519-2062·N/A7726 Mesa DriveNashvilleTN37298null—
PRVPRV-277642026-02-04T09:10:50ZSAM—PALMER01-08-2000UHC-81616-47null6529075080—7508 Cedar LnChandlerAZ85208—null
PRVPRV-240462026-08-09T01:27:43ZOmar—Jones1945-07-03UHC-47663-26—5794713525omar.jones@hotmail.com8618 Bayshore DrTucsonAZ85700—MEDICARE-ADV-A
PRVPRV-204572026-04-20T11:38:08ZShaw, Mateo——1955-06-19—•••-••-6510938.557.0806—1818 Church Street #860San AntonioTX78281UNKNOWN—
PRVPRV-210992026-01-08T10:40:07ZThomas··Welch12/10/2004·UHC-87160-11—4284450782—7503 Broadway Apt 19PlanoTX75050N/A··CHOICE-PLUS-PPO
PRVPRV-288802026-10-16T19:30:11ZSofia····Bowman1964-11-20·UHC-32544-49•••-••-2619NULLNULL3843 Baseline RoadScottsdaleAZ85229-··-
PRVPRV-220122026-03-22T15:32:10ZDENISE—RYAN07/02/76UHC-47417-64—(730) 201-7277NULL·5141 Baseline RoadEden PrairieMNnull——
PRVPRV-246652026-06-18T13:50:30ZEric—BellOct 3, 1943UNKNOWN—734-973-8013N/A6105 Bayshore DrDenverColorado··80258nullOPTIONS-PPO
PRVPRV-213762026-08-20T14:30:17ZSofia—Fernandez1968-12-20—UNKNOWN(976) 527-6749··UNKNOWN2511 Grand AvenuePlanoTX75046UNKNOWNN/A
PRV PRV-200192026-10-09T22:46:14ZLAURA—HAMILTON1957-01-17UHC-53829-66-NULL—7386 RIVER ROADLAS VEGASNV89191—MEDICARE-ADV-B
PRVPRV-251862026-01-23T06:17:48ZCarolyn—Luna27-11-1999UHC-24535-03—(428) 669-9356—9464 Maple AvenueSan AntonioTX78248····N/A
PRVPRV-284972026-04-14T07:50:16Z·KATHRNY··COOPER2000-07-27N/AUNKNOWNUNKNOWNkathryn.cooper@proton.me·2987 SPRING STSan Antonio·TX78236-1178—CHOICE-PLUS-PPO
PRVPRV-25118 2026-08-28T18:50:17Z·KennethZ.Peeters1991-09-06UNKNOWN-··846-405-5697—2744 Hillcrest RoadHoustonTX77004N/AMEDICARE-ADV-B
PRVPRV-219162026-09-17T23:08:28ZBobby—Matthews1973-05-04UHC-97499-90nullnull··NULL5402 Grand AvenueTempeAZ85253-—
PRVPRV-277122026-05-24T20:06:52Z Sims, Carl——5/5/1953-•••-••-2756N/ACARL.SIMS21@YAHOO.COM2766 DESERT SKY BOULEVARD·PlanoTX75078N/ACHOICE-PLUS-PPO··
PRVPRV-220472026-04-05T16:06:06ZMatt—Montgomery1972-10-03UNKNOWN··(907) 944-6751matthew.montgomery96@proton.me4920 LAKE VIEW ROADCharlotteNCNULLUNKNOWNNULL
PRVPRV-228952026-08-27T09:26:57ZstephenAharrison08/13/63··N/A—(829) 400-7719null5551 Grand Avenue··SeattleWA98188N/Anull
PRVPRV-205732026-09-14T22:01:12ZSarahD.Grant1999-01-04UHC-93690-53—3543233551·N/A4672 Canyon RoadMinneapolisMN55413-—
PRVPRV-295712026-01-17T10:58:06ZJACOB—THOMPSUN1991-50-07UHC-30058-05N/A519-254-1939N/A5028 SUNSET BLVD·ScottsdaleAZ··85244—null
PRVPRV-289662026-01-25T17:29:17ZJack—Torres1949-02-10-—+1 355 899 5888N/A110 Spring StNashvilleTN37271N/AUNKNOWN··
PRVPRV-235952026-07-12T15:17:31ZMARIA—·MCDONALD24-06-2008-UNKNOWN(788) 894-1751··nullN/A—N/AUNKNOWN-··
PRVPRV-273552026-04-24T14:54:49ZPatrick H—Jordan1948-08-20UHC-27638-29—N/A—N/A—N/A-UNKNOWN—
PRVPRV-201422026-07-20T02:51:57ZSamuelXAllen02/16/43NULLUNKNOWN(208) 781-4263SAMUEL.ALLEN@AOL.COM··7372 Washington StMinneapolisMN55438—UNKNOWN
PRVPRV-217392026-02-02T23:01:28ZMari—Daniels1982-10-09—-(988) 275-1065maria.daniels@gmail.com5183 Sunset BoulevardFRESNO·CA93783N/AN/A
PRVPRV-280552026-04-01T05:14:15ZKathryn—Hart1947-01-10N/A—463-616-7714NULL1306 Pine Drive·AtlantaGA30303UNKNOWNUNKNOWN
9,596 rows, page 146 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:56.285Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty