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-205692026-02-02T14:56:29ZKayla—Berry1951-03-20UHC-74190-66—426-207-0632-null-—N/AN/A—
PRVPRV-294682026-06-06T13:44:23ZJeffJ.Edwards1993-02-09UNKNOWNN/A(971) 893-7258····4979 BAYSHORE DRIVE··PlanoTX75032—N/A
PRVPRV-218672026-10-09T07:23:02ZBRANDON—COOPERFeb 17, 1971—•••-••-2415NULLNULL647 JEFFERSON AVEOrlandoFL32818—null
PRVPRV-217492026-07-07T10:03:50ZJoe—Luna1974-05-18UHC-06718-95—+1 584 500 0809UNKNOWN7625 River RdColumbusOH43216··—null··
PRVPRV-203902026-06-15T15:07:05ZSTEVENYLEWIS1941-11-08N/A—(961) 469-2590steven.lewis@aol.com5512 Ridge RdGLENDALEArizona85379··NULLNULL
PRVPRV-239522026-03-26T09:54:20ZAhmed··—Ryan1980-04-17UNKNOWN—403.340.4537——N/A—NULLN/A—
PRVPRV-289162026-02-24T03:38:01ZGeorge—Nelson27-04-1941UHC-72655-13-563-654-4348nullNULLNULLnull-——
PRVPRV-290492026-10-16T14:03:06ZPatricia··PKing··1967-06-23UNKNOWN—(487) 278-1868patricia.king89@hotmail.com5936 Willow CourtDALLASTX75246N/AUNKNOWN
PRVPRV-227322026-09-29T04:43:43ZJOSE·YCAMPBELL···1993-11-18UNKNOWN•••-••-8490UNKNOWNJOSE.CAMPBELL96@AOL.COM—null-·N/A—N/A
PRVPRV-263302026-01-15T00:19:57ZBARBARA—JOHNSTON1974-09-16UHC-72209-44—UNKNOWN—·-····UNKNOWN-UNKNOWNN/A
PRVPRV-224842026-03-06T13:46:36ZWAYNE—WARD1966-08-17UNKNOWN-16754164628UNKNOWN503 Ridge RdSan AntonioTX·····-····
PRVPRV-241132026-01-07T10:26:40Z———·11/27/04UNKNOWN-15989373221JONATHAN.ESTRADA10@OUTLOOK.COM1699 Hillcrest RdMIAMIFL33123—N/A
PRVPRV-231162026-10-16T05:58:50ZLuciaFEdwards17-06-1970NULLnull437-475-1530LUCIA.EDWARDS@GMAIL.COM6382 Jefferson AvenueDallasTX75299-8685·null-
PRVPRV-214672026-03-22T12:30:33ZJason····Waker··1958-07-11UHC-52858-40··NULL(919) 829-9272-8763 Lincoln WayORLANDOFlorida32826—UNKNOWN
PRVPRV-227832026-08-28T03:45:10ZRios, Valentina——10/21/1989—•••-••-65974517771817NULL2665 Harbor Boulevard··ORLANDOFlorida32887UNKNOWN—
PRVPRV-252382026-10-06T07:18:12ZHarris, WeiG—16-03-1954UHC-52056-94—(539) 474-8760N/A5028 Ridge RoadColumbusOH43212UNKNOWNN/A
PRVPRV-216822026-05-01T11:14:19ZEugene—Weber1996-02-13UHC-24096-95•••-••-5077NULLeugene.weber17@aol.com—N/ANULLUNKNOWNnullN/A
PRVPRV-266512026-02-13T11:34:38ZAisha—Peterson1964-06-27—•••-••-1019····NULL722 Church StreetHouston·TX77035——
PRVPRV-287752026-06-29T19:03:28ZMarquez, Ashley——1939-01-03NULL—14835801301N/A384 LAKE VIEW ROADNashvilleTN37279N/A—
PRVPRV-25770 2026-04-22T16:19:17ZDylan—Morgan1981-01-19UNKNOWNNULL13859932206NULL790 Broadway··SeattleWA··98119nullOPTIONS-PPO
PRVPRV-226312026-01-08T20:43:00Zwillie—graham2001-04-23UHC-19939-09UNKNOWN··4168641075null7899 WILLOW CTMINNEAPOLISMN··55468UNKNOWN··UNKNOWN
PRVPRV-204662026-08-02T17:42:51ZDouglas—Hill1942-09-02UHC-33322-25N/A5324308942UNKNOWN7413 Hillcrest RoadDENVERCO80215-6061-NULL
PRVPRV-212322026-09-22T16:27:33Z·BellM.Emily2008-06-26--888-600-1377—1694 HARBOR BLVDNashvilleTN37238NULLNAVIGATE-HMO
PRVPRV-250292026-04-15T04:42:56Z·Woods, Ana——1999-12-10····—3853935205—9524 Broadway··Las VegasNV89124N/ACHOICE-PLUS-PPO
PRVPRV-234012026-01-30T02:59:40ZSTEPHANIE—FLORES1990-11-05uhc-94918-95··—19376058985stephanie.flores35@outlook.com1443 Elm StreetLos AngelesCA90020-N/A
PRVPRV-247572026-10-05T17:00:00ZMELISSA—RODRIGUEZMar 11, 1943·UHC-87826-91UNKNOWN6044501001melissa.rodriguez69@hotmail.com2585 OCEAN AVECHARLOTTENC28287·UNKNOWN—
PRVPRV-237152026-01-06T01:57:01ZJUDITH··VASQUEZ·1995-12-01UHC-02361-56-——3739 Lake View Rd #669AustinTX78717—OPTIONS-PPO
PRVPRV-238942026-06-01T15:46:37ZJanet—Stone1961-10-04——702-225-0285NULL7317 Ocean AveMesaAZ85212NULL··null··
PRVPRV-200142026-05-01T20:37:36ZOLIVIAHMEJIA1996-01-27N/A—NULL—1802 Forest AvenueAtlantaGA30389—UNKNOWN
PRVPRV-291232026-09-19T07:21:16Z·Nathan—·LewisJun 10, 1952UHC-96932-40··-+1 803 696 7538-8798 PARK PLSacramentoCA95848NULLN/A
PRVPRV-227692026-06-15T20:59:17ZMARIANA—JOHNSON3/21/1997UNKNOWNN/A440-482-1064—1867 Mountain View DriveDallasTX75206—null
PRVPRV-281352026-10-05T15:41:51Z·Harold····Morales11/19/1967UNKNOWN•••-••-4303(349) 687-3951—9344 Main StreetGlendaleAZ85364NULL—
PRVPRV-249122026-02-23T17:47:54ZChristine—Stewart1946-01-03UHC-62819-22NULL—NULL412 PALM DRAustinTX78728NULL-
PRVPRV-255472026-04-22T11:42:22ZPAUL··E.··WHITE1995-03-22··NULLN/A(913) 868-4896——null—null··N/A
PRVPRV-270642026-03-06T11:51:47ZSAMANTHA—ROSE1967-01-14NULL•••-••-6075(339) 355-3725—3541 PINE DRPlanoTX75004-NAVIGATE-HMO
PRVPRV-281982026-08-30T14:17:16ZStephanie—Lewis23-06-1946UHC3126399null18395851189—8137 Desert Sky BoulevardTampaFL33617-2106UNKNOWN-
PRV PRV-265202026-09-03T09:39:33ZDaniel····Sanchez03/01/1968·UHC-00966-58—880-969-6915UNKNOWN1280 Mesa DrEden PrairieMN55396—-
PRVPRV-246152026-09-16T14:47:34ZTheresa—Payne1978-09-05——(590) 767-7118UNKNOWN9004 Sage CourtCHARLOTTENC28269NULLN/A
PRVPRV-200822026-10-17T21:14:56ZBrian—Guerrero1957-04-21UHC-34537-90•••-••-1010958-614-8168··8900 Sunset BlvdLos AngelesCA90067-UNKNOWN
PRVPRV-28010 2026-03-29T19:26:57ZTheresa—King19610713UHC-01570-93·NULL—theresa.king55@outlook.com8709 Main StAtlantaGA30319—-
PRVPRV-215622026-04-27T05:08:04Z·JUDITH—COOPER1957-01-28·-null—JUDITH.COOPER@PROTON.ME6211 Palm DriveEden PrairieMinnesota55331-—
PRVPRV-240872026-02-26T19:55:24ZADAM··ELLIS26-09-1958··-NULL—8930 Cedar LnGlendaleAZ85301-4097nullUNKNOWN
PRVPRV-247892026-07-16T08:27:36ZHAROLD—GREANE1994-12-16UNKNOWN———nullN/AN/ANULL··null
PRVPRV-254062026-08-26T08:10:37Z Sharon—ColeN/Anullnull741-267-5111NULL3762 Cedar LaneTempeAZ85229—-
PRVPRV-283592026-03-14T12:24:12Z LINDA—BOYD1993-03-26UHC-33993-62NULL9213191642-·3073 HIGHLAND AVENUEJacksonvilleFL32282—MEDICARE-ADV-B
PRVPRV-278702026-10-09T04:53:06ZCHARLOTTEX.JORDAN7/23/1983UHC-36937-84—(716) 951-5293charlotte.jordan56@yahoo.com4790 BAYSHORE DRIVESan DiegoCA—-—
PRVPRV-249782026-10-03T21:03:41ZSANTIAGO·DJAAMES2005-11-18NULL—(547) 894-3567null2035 Indian School RdGlendaleAZ85338null-
PRVPRV-220462026-02-04T10:50:02ZMATTHEWK.MONTGOMERY1972-10-03··—UNKNOWN907-944-6751—4920 Lake View Road Apt 31CharlotteNC28279——
PRVPRV-279882026-03-25T11:04:17ZBilly··HansenFeb 21, 1974UHC-24086-77—6437986171null201 River RdJACKSONVILLEfl32247-N/A
PRVPRV-221382026-09-19T06:37:46ZHarper—Mason1996-05-08····-462-998-9619—6142 Hillcrest Rd·FRESNO·CA93764—NULL
9,596 rows, page 44 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:40.335Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty