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-253802026-09-21T21:29:01ZsantiagoQ.warren—-—12874099329-542 Harbor BoulevardMesaAZ85248—UNKNOWN
PRVPRV-263782026-08-07T02:45:02ZDeb—Arnold1957-02-20——617-448-8317··DEBORAH.ARNOLD@GMAIL.COM4570 WILLOW CTMesa··AZ85228-—
PRVPRV-247402026-01-02T12:23:42ZCHARLESV.MURPHY02/10/53UHC-98759-52•••-••-9974+1 308 676 5729charles.murphy61@aol.com2992 Market StSEATTLEWA98162······options-ppo
PRVPRV-293972026-04-02T14:17:08ZELIZABETHPOWENS9/17/1949·UHC-81340-30NULL854.871.1123ELIZABETH.OWENS23@PROTON.ME··163 Oak StreetHOUSTONTX·77026NULL—
PRVPRV-235862026-02-18T06:12:43ZJeffreyKSimmons1979-02-02UHC-58774-62—·316-703-5601-5421 BAYSHORE DRIVEChandlerAZ85295-5485—····
PRVPRV-208252026-06-08T01:14:52ZCynthia—Gibson9152-11-09—•••-••-34572595105991··—7483 CHURCH STSan DiegoCA92144N/AOPTIONS-PPO
PRVPRV-284202026-01-25T02:24:12ZCHRISTINA—DUNN1942-03-01——647-611-4354NULL6848 Market StreetAtlantaGA30334—UNKNOWN
PRVPRV-294902026-05-09T23:46:11Zdiego—lawrence·19781127UHC-74911-24N/A(847) 646-9423N/A4864 River RoadDenverCO80200-NULL
PRVPRV-217782026-01-05T22:36:14ZGeorge—Fernandez·03/23/59—UNKNOWN818-996-0415-5931 Union StreetColumbusOHUNKNOWN——
PRV PRV-252232026-04-30T13:58:46ZjenniferFhenryJan 17, 1980-—+1 819 693 6019—2409 Oak StJacksonvilleFlorida32216NULL—
PRVPRV-252332026-01-01T03:50:39ZCynthiaW.Ford·1986-06-11UNKNOWNnull····—3753 Lincoln Way··FresnoCA93791—NAVIGATE-HMO
PRVPRV-234952026-10-04T00:03:36Z KYLE—HARVEY1976-10-27UHC-55261-28—8904271769-4135 SAGE COURTSan Diego··CA92196nullCORE-HMO
PRVPRV-212662026-07-31T09:23:50ZGLORIA—·ORTEGA2007-02-20UHC-54492-82•••-••-2414(625) 664-2450-4707 Highland AvenueTempeAZ85252—OPTIONS-PPO
PRVPRV-283212026-01-14T07:02:44Zkelly—berry1991-01-10UHC7528665·null12639848063UNKNOWN4490 Hillcrest RdEden PrairieMN55361—CHOICE-PLUS-PPO
PRVPRV-226802026-08-31T11:41:31ZMariana—Williamson12/27/1971UHC-03230-89N/A247-974-5300mariana.williamson60@icloud.com1598 Desert Sky BoulevardPhoenixAZ85048N/A—
PRVPRV-234752026-05-07T05:01:13ZAndrea—Weaver2004-09-02UHC-37102-61UNKNOWN5337471380··—7005 Union StreetColumbusOH43295—null
PRVPRV-213512026-04-17T23:09:11ZBruce—Jensen1946-11-15UNKNOWNN/A+1 354 381 5379··NULL2311 Lincoln WayChandlerAZ85210null·-
PRVPRV-265322026-04-23T19:33:40ZBEVERLYRVEGA1973-12-09UHC-03703-82null+1 820 519 5728BEVERLY.VEGA@PROTON.ME1150 PINE DRGlendaleAZ85350—-
PRVPRV-203402026-01-13T02:28:15ZElizebethGWest19640701—•••-••-52923665091188elizabeth.west@gmail.com·9763 Apache Boulevard·San AntonioTX78294—·UNKNOWN
PRVPRV-238242026-08-11T05:42:04ZMELISSA—ROSE7/10/1954·UHC-51916-72—(874) 871-4040-6028 Maple AvenuePhoenixAZ85084-OPTIONS-PPO
PRVPRV-292222026-06-28T19:24:11Zmelissa—dominguez1955-10-15—NULL985-530-4738··953 Baseline RoadSACRAMENTOCAnull-N/A
PRVPRV-291822026-02-03T11:02:51ZDeniseY.GibsonJun 15, 1973NULL-(572) 700-6996NULL3493 Elm St··CHARLOTTENorth Carolina28256-MEDICARE-ADV-B
PRVPRV-227772026-05-15T23:14:08ZMICHAEL—LUNA11/16/2003NULLUNKNOWN+1 552 282 0674michael.luna@hotmail.com1256 BroadwayAtlantaGA30306—····
PRVPRV-29267 2026-07-07T19:57:59ZLawrence··—McDonald07/03/1941UHC-88707-71•••-••-7965UNKNOWNLAWRENCE.MCDONALD@ICLOUD.COM970 Main StreetFresnoCAN/AUNKNOWN···NULL
PRVPRV-222592026-09-18T04:56:35ZTyler—Ellis1964-06-11UHC-57220-44•••-••-8914831-668-7261—9799 MAPLE AVENUELas VegasNV89140—MEDICARE-ADV-A
PRVPRV-209532026-06-08T00:22:18Z·LAWRENCEMBURKE1951-03-07UHC-58705-65—488.783.5554—1137 Palm DrGILBERTAZ85259-NULL
PRVPRV-27584 2026-08-31T16:36:08ZWalker, Betsy——11/19/1958N/A—4463139190elizabeth.walker86@hotmail.com8507 Harbor BlvdDenverCO80260UNKNOWN—
PRVPRV-236132026-04-13T23:23:50ZLaura—Watkins1995-07-08null··226-731-4736-9483 Elm StreetTucsonAZ85710N/A-
PRVPRV-205562026-02-14T16:49:06ZOBRIEN—VALENTINA06/13/65UHC-50153-59•••-••-9746857.841.2143nullNULL··NULL-null-choice-plus-ppo
PRVPRV-209242026-09-28T13:57:50ZMEGAN—PERKINS1985-09-03nullN/A966-558-0892··3220 CAMELBACK ROADSeattleWA98196—N/A
PRVPRV-29218 2026-09-28T19:48:27ZVALENTINA—CASTILLO1975-01-19nullnull--2097 Sunset BoulevardSAN ANTONIOTX78268—N/A
PRVPRV-293062026-03-26T01:53:08ZDavid—·Hunter1957-02-20UNKNOWN—816-313-3970N/A9047 Harbor BlvdLas VegasNV89153NULLCHOICE-PLUS-PPO
PRV PRV-220382026-05-17T11:45:48Zrobert—tucker20040714UHC-10873-92NULL622-204-2561—NULL——N/Anull····
PRVPRV-265412026-05-16T21:35:39ZDanielle—Gutierrez1939-05-01UHC-79211-66·N/A6052483731··-487 Forest AveTAMPAFL·33626nullNULL
PRVPRV-266752026-03-30T05:38:14Ztommy—day19440221—null·+1 782 912 5892—1025 Mesa Dr Apt 24MIAMIFL33171NULLNAVIGATE-HMO
PRVPRV-257392026-08-28T14:01:14ZALBERT—VAZQUEZ1962-10-05UHC-98681-94NULL·902.690.7527albert.vazquez51@yahoo.com7251 Central Avenue··Austin··TX78754——
PRVPRV-281882026-07-03T14:42:49ZMontgoery, Marcus··—1966-02-07UHC-94734-12—-··1942 Meadow LaneChandlerAZ85203N/AMEDICARE-ADV-A
PRVPRV-231462026-04-13T04:32:33Z·priya—jimenez19621210uhc-55791-82—708-557-4452N/A1209 Central AveDallasTX··75242—UNKNOWN
PRVPRV-287302026-10-06T15:31:29Z·Marilyn—Simmons1973-12-07UHC-99209-98-2787021808marilyn.simmons62@aol.com9393 Harbor BlvdLOS ANGELESCA90020····—
PRVPRV-240412026-07-07T07:50:47ZFATIMA—JAMES1988-09-04—-218.814.3101fatima.james@outlook.com5401 MARKET STREETFresno·California93774N/ACORE-HMO
PRVPRV-201732026-09-29T08:25:03ZjoseCpeterson2007-07-18···UHC-04323-58N/A—N/A6822 BASELINE ROAD Apt 27MesaAZ85247-7087null—
PRVPRV-258892026-06-11T14:43:31ZWhite, Mei——·1958-08-20UHC-19755-67-7335976534—3997 CENTRAL AVENUEEden PrairieMN55329NULL—
PRVPRV-289062026-09-13T07:37:42ZDANIELJ.ROBERTSON1966-08-04UNKNOWNNULL·307-597-4977NULL2584 Sunset BlvdChandlerAZ85259——
PRVPRV-223802026-02-28T22:43:31ZThomas—Espinoza··1980-07-04UHC-83698-81null8783533-8979 Market StEden PrairieMinnesota55302—·UNKNOWN
PRVPRV-264252026-09-08T23:09:31ZNancyJGrahamnullUHC-43007-22—(709) 460-5128N/A4350 Apache Boulevard #543Seattle·WA98197—UNKNOWN··
PRVPRV-206282026-07-30T13:24:51ZMary—Hansen1961-11-20--19885051853UNKNOWN263 Lincoln Way #695OrlandoFL··32884—-
PRVPRV-207992026-09-23T18:15:35ZHIROSHIS.RICHARDS·1983-02-20UHC-72946-18•••-••-6865(583) 234-7104—7384 Valley View Drive #899GlendaleAZ85353UNKNOWNNULL
PRVPRV-290052026-01-05T10:04:52ZMARK—BANKS12/28/1986UHC-06187-42•••-••-7586(288) 604-9707mark.banks28@icloud.com2326 Meadow LaneCHANDLERArizona85254nullNAVIGATE-HMO
PRVPRV-218132026-04-10T23:45:55ZPAMELA—·HILL2/1/1943UHC-49585-16-··611.992.7648NULL2806 FOREST AVEFRESNO··CA93749·NULL-
PRVPRV-246462026-08-08T23:47:01ZMason··—Wong1991-01-03—UNKNOWN677-602-2117N/A4234 Willow CourtLOS ANGELESCA90028—CORE-HMO
9,596 rows, page 82 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.070Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty