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

All sources, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
TPATPA-63473 2026-08-31T15:45:42Zkevin—andrews1982-03-06··NULL—-—7867 Ocean Ave #777San DiegoCA92114—OPTIONS-PPO
ENRENR-1001672026-03-08T10:20:37Z·Bobby—Silva06/25/1966UHC-38822-20null5197957190bobby.silva@outlook.com2830 Main St··GlendaleAZ—GRP-8051NAVIGATE-HMO
ENRENR-1050842026-07-24T10:19:04Z·Clark, DotT—1989-03-13UHC-97273-05—851-880-3134dorothy.clark57@icloud.com9671 SUNSET BLVDSan AntonioTX78258GRP-8700OPTIONS-PPO
ENRENR-113203 2026-08-10T16:31:04Zlisa—·henderson12-05-1978UHC-46971-43•••-••-0055+1 754 794 4763·LISA.HENDERSON73@HOTMAIL.COM3644 SPRING STGlendaleAZ85300GRP-8726select-epo
CLMCLM-4201532026-09-26T15:42:46ZRoy—Marquez2003-02-27UHC-81106-25•••-••-55147443027218-UNKNOWNNULLnullNULLNULLUNKNOWN
PRVPRV-247312026-01-23T03:46:55ZJazon—Thompson··1949-08-01UHC-34426-37-938-505-7920·jason.thompson@icloud.com1522 Market StLas VegasNV89126NULLMEDICARE-ADV-B
PRVPRV-203282026-02-12T15:35:58ZOrtega, Sara——02/06/1976null-+1 914 601 9464-5180 Church StreetFresnoCA93729—NAVIGATE-HMO
ENRENR-1399472026-05-08T10:55:44ZDanielJ.Robertson1966-08-04UHC-84921-42•••-••-4849307-597-4977daniel.robertson@icloud.com2584 Sunset BlvdChandlerAZ·85259GRP-5902·OPTIONS-PPO
TPATPA-52071 2026-02-21T04:06:26ZMason, AnnaI.—01/02/1972··-N/AN/ANULLN/AUNKNOWN———·UNKNOWN
ENRENR-1052542026-08-25T09:18:02ZASHLEY—HAYES1993-03-18·UHC-32375-64•••-••-7916(406) 772-9967ASHLEY.HAYES@GMAIL.COM3942 Highland Avenue··PlanoTX75009-1410GRP-5292OPTIONS-PPO
ENRENR-1162212026-09-10T22:08:00Zcarolyn··garrett1989-07-02UHC-02947-44•••-••-75552928452722carolyn.garrett7@hotmail.com··1944 Main StAtlantaGAN/AGRP-9344NAVIGATE-HMO
CLMCLM-4242572026-09-06T06:48:46ZKimberly··Jimenez1952-12-05UHC-97816-87•••-••-1658N/A-9412 OCEAN AVENUEDenverCO80249GRP-6598NAVIGATE-HMO
ENRENR-1276692026-08-23T10:41:57ZDebra·····Gradner1997-08-09UHC-16971-47•••-••-6657(804) 982-8400debra.gardner70@icloud.com1300 CANYON ROADPlanoTX75055GRP-1296NAVIGATE-HMO
CLMCLM-4079892026-02-16T07:51:34Z·camila—sims1950-08-25-•••-••-8324null-6419 CEDAR LANEDENVERCO80222UNKNOWNSELECT-EPO
ENR ENR-1285952026-06-09T02:59:21ZZACHAARY S—SCHMIDT3/3/1956·UHC-39649-87•••-••-4082538-972-4331zachary.schmidt@proton.me9274 CANYON ROADHoustonTX77067··GRP-4206choice-plus-ppo
ENRENR-1267132026-03-04T05:00:22Z MichelleY.Spencer2002-07-28UHC-58399-69•••-••-7842UNKNOWNMICHELLE.SPENCER@GMAIL.COM4328 PINE DR #939PlanoTX75094-3252GRP-3742CORE-HMO
CLMCLM-4027032026-07-07T20:48:10ZDONNA··—RUSSELL1941-05-01—N/AN/Anull1862 Mesa DriveMIAMIFL33125-—
ENRENR-142244 2026-09-13T15:15:53ZMICHAELB.WEBER27-12-1950UHC-63996-85··•••-••-8946(939) 833-7186—2445 Baseline RdTUCSONAZ··85705GRP-0730CHOICE-PLUS-PPO
ENRENR-1226442026-04-02T03:02:02ZAllen, Debra·······1938-06-15UHC4923369•••-••-5584(979) 724-1815debra.allen91@hotmail.com4355 Baseline RdTempeAZ85271GRP-1299··OPTIONS-PPO
ENRENR-1277442026-06-22T04:42:08ZCAROLYN··AWALLACE1997-07-24UHC-71193-56•••-••-2239(399) 791-4383carolyn.wallace35@yahoo.com6953 Ridge RoadTEMPEAZ85237GRP-5966··NAVIGATE-HMO
ENRENR-1171332026-01-09T15:01:52ZJeremyLDean19521202UHC-08912-03•••-••-22846474030656JEREMY.DEAN@AOL.COM6029 CENTRAL AVENUE·Eden Prairie·MN-GRP-9453·NAVIGATE-HMO
PRVPRV-277982026-08-26T07:44:13ZGerald—Robertson20-09-1945UHC5225314—3807900615NULL·2789 Palm Dr Apt 26PhoenixAZ85083UNKNOWNnull
CLMCLM-4010442026-01-09T11:44:21ZCarolyn—Collins2001-07-24UHC8796121•••-••-1358892-903-8071N/A·null—NULL··GRP-0660····
CLMCLM-4313632026-01-19T23:37:21ZNicole—Gonzales1941-02-13UHC-80545-64•••-••-85748182614739NICOLE.GONZALES68@YAHOO.COM4175 Forest AvenueORLANDOFL32880nullMEDICARE-ADV-B
ENRENR-1356432026-07-29T11:27:22ZalbertUjohnston09-05-1961UHC-58242-57•••-••-27655548778504albert.johnston@icloud.com5512 HIGHLAND AVETucsonAZ85750GRP-3804·SELECT-EPO
ENRENR-1409392026-06-28T10:08:23Zpriya—matthews08-05-1962UHC-39612-05•••-••-885217805368504priya.matthews@yahoo.com1255 Grand AveGilbertaz85244GRP-3575CORE-HMO
ENRENR-1021002026-09-30T09:22:22ZAlbert·D·Montgomery01/07/1991UHC-04094-79•••-••-4113823-432-3889—6612 Washington St··Los AngelesCA90063GRP-7717NAVIGATE-HMO
TPATPA-630382026-09-13T11:13:18ZPeter—Patterson03/14/2005UHC-20937-46··NULLNULLUNKNOWN6888 OAK STEDEN PRAIRIEMN·55389NULL·OPTIONS-PPO
ENRENR-1427312026-03-01T18:50:17ZBetty·UWang1985-06-11UHC3116220•••-••-8545211.977.1209betty.wang38@hotmail.com8453 Washington St·MinneapolisMN—GRP-3900NAVIGATE-HMO
CLMCLM-4187352026-06-13T12:24:56ZRandy—Fisher26-01-1984··UHC-09845-24•••-••-1818840-554-7906NULL772 HARBOR BLVDAtlantaGA30393GRP-6206UNKNOWN
PRVPRV-235982026-07-09T15:10:31Z·Ruth Z—Contreras1978-05-04UHC-90999-03—5469929—null-NULLUNKNOWNnull—
CLMCLM-4071402026-10-04T12:27:51ZAliceNSpencer03/01/67··—N/A5442120508null4684 Mountain View DrHOUSTONTexas77017N/AMEDICARE-ADV-B
TPATPA-643152026-07-02T21:18:29ZCARL—SIMMONS2003-03-11UHC-25020-08——null5222 Ocean Avenue··Denver··CO——N/A
TPATPA-592342026-01-15T08:27:48Z·linda··hart12/22/51—•••-••-1640N/A—--·--N/Anull
CLMCLM-4194762026-05-08T20:37:46Zolivia—dunn09/23/1956··—•••-••-6701(250) 511-1244—7987 Central Ave #306ColumbusOhio43235GRP-7109—
CLMCLM-4115802026-04-10T04:56:55ZSAMUEL—WILLIAMSON1960-08-28—-UNKNOWNSAMUEL.WILLIAMSON@YAHOO.COM1245 Sage CtOrlandoFL32837GRP-9790MEDICARE-ADV-A
ENRENR-122796 2026-09-28T20:48:42ZRUSSSELLALONG1993-02-19UHC-26038-09····18278847497russell.long@outlook.com1286 BroadwayGLENDALEAZ—GRP-6691CORE-HMO··
TPATPA-573612026-02-24T08:55:03ZGrace—Hernandez··1950-12-14—•••-••-1760(207) 528-9147—·1280 SUNSET BLVD Apt 5ChandlerAZ85229nullN/A··
ENRENR-1142602026-07-02T15:52:54ZBRENDADROJAS1985-06-14uhc-14306-22N/A(555) 659-2334—1484 GRAND AVENUE··CHANDLERAZ85228GRP-1292SELECT-EPO
ENRENR-1407222026-01-10T16:58:50ZGabriel—SimmonsJun 26, 1986UHC-85429-50•••-••-6974-gabriel.simmons27@gmail.com5181 BAYSHORE DRIVESan DiegoCA92175GRP-1913MEDICARE-ADV-A
CLMCLM-4319432026-09-11T17:48:55ZWilson, Madison··—··1946-10-13UHC-30657-32N/A476.594.7630—1800 Lake View RdATLANTAGA30366··—MEDICARE-ADV-B
ENRENR-1124192026-07-21T03:06:20ZEllis, Jessica····—1997-03-05UHC-51002-75•••-••-38818908184992JESSICA.ELLIS@ICLOUD.COM2135 Mesa DrJacksonvilleFL32280GRP-1759NAVIGATE-HMO
CLMCLM-4015612026-09-19T02:21:45ZElllis, Jessica——1963-07-27UNKNOWNN/A8886321549—2220 CENTRAL AVENUEFresnoCA93781GRP-6053UNKNOWN
CLMCLM-4184882026-09-13T16:03:16Z ·JULIA—PERKINS1945-03-26··N/A•••-••-1691-NULL··5328 Washington StreetTempeAZ85269··nullUNKNOWN
CLMCLM-4237562026-10-16T18:04:43ZBradley—Hughes5/25/1996null—6623825604—6130 LINCOLN WAYSan AntonioTX78234N/AMEDICARE-ADV-A
CLMCLM-4167492026-09-01T07:59:10ZLAUREN—RILEY01/08/1952UHC-01311-77•••-••-1921-null1156 Hillcrest RoadMinneapolisMNnullGRP-6480—
ENRENR-1053292026-01-16T00:17:38ZDiane—Vargas··1974-11-27UHC-50003-24•••-••-3056812.775.7599diane.vargas27@icloud.com2681 Central AvenueMiamiFL33181GRP-2277CORE-HMO
CLMCLM-408745 2026-04-18T17:54:21ZNoah—Carrlol11/02/1986UHC-13848-99•••-••-8968N/AN/A-NULL——N/AN/A
ENRENR-1193572026-03-19T10:33:33Z·MARCUSZWEAVER04/01/2001UHC-34510-39•••-••-94686392871813—·7557 Sage CourtTampaFL33685·GRP-2919·OPTIONS-PPO
PRVPRV-270202026-07-06T06:01:57ZNICHOLAS—GONZALEZ19640411NULL··NULL(643) 615-2977UNKNOWN6958 Lincoln WayLOS ANGELESCA····UNKNOWN—
100,000 rows, page 5 of 2,000PreviousNext

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-19T19:54:25.414Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty