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
ENRENR-1229312026-03-20T00:19:54ZJack··—Hart03/07/2004UHC-04261-60•••-••-9418(662) 353-1282jack.hart28@icloud.com··—··N/ANULLGRP-3643··SELECT-EPO
CLMCLM-4245282026-05-02T09:19:54ZElijah—Clark1945-08-06UHC-88160-82——N/A3415 BroadwayEden PrairieMN55375GRP-4244CORE-HMO
ENRENR-1212632026-05-15T20:39:33ZPriya··—Welch1991-08-20UHC-03974-15··•••-••-2186899-593-6937priya.welch80@yahoo.com8413 Ocean AveNASHVILLETN37244GRP-4390CHOICE-PLUS-PPO
ENRENR-1398812026-09-13T17:42:37ZDorothyR.Reynolds1995-11-10UHC-94896-01•••-••-48648708948654dorothy.reynolds@hotmail.com·649 MESA DRIVEMiamiFL··33164GRP-4723MEDICARE-ADV-A
ENRENR-1343422026-08-26T17:11:58Zjean··franklin1965-09-24UHC-57754-37•••-••-3247396-704-3738null1586 Ridge RoadColumbusOH43237GRP-6170CHOICE-PLUS-PPO
ENRENR-1285392026-05-22T09:08:17Zelijah—collins20-06-1979UHC-12190-69•••-••-70702622537759elijah.collins89@yahoo.com1597 Central AvenueJACKSONVILLEFL32297GRP-3474·NAVIGATE-HMO
ENRENR-1420592026-07-05T18:24:22ZTimothyG··BennettNov 17, 1940UHC-58565-83•••-••-9718(374) 446-0647UNKNOWN1538 Harbor BoulevardTempeAZ85234GRP-8224·NAVIGATE-HMO
PRV PRV-246002026-03-18T06:21:34ZrayRpriya1962-05-28UNKNOWN•••-••-0733UNKNOWN-7268 Cedar LaneGILBERTAZ85287—SELECT-EPO
ENRENR-1383192026-04-14T01:51:57ZNoahKRice06/17/56··UHC-22017-22•••-••-2563—NOAH.RICE67@YAHOO.COM——NULL-GRP-2647CHOICE-PLUS-PPO
ENRENR-1136692026-09-10T11:09:48ZDEBORAHISMITH1955-02-11UHC-06521-05•••-••-94054476415070deborah.smith@yahoo.com805 Market StreetPlano··TX75081GRP-6888OPTIONS-PPO
TPATPA-555062026-02-03T14:48:48Zvirginia—weber1948-05-14NULL——UNKNOWN·6931 Valley View DrDallasTX75268null—
ENRENR-1255352026-05-26T19:23:01ZSHIRLEY—GUTIERREZ1958-08-13UHC-95109-52•••-••-8381(360) 896-3553shirley.gutierrez@aol.com2473 Willow CtSAN ANTONIOTX78276GRP-0163MEDICARE-ADV-B
CLMCLM-418896 2026-07-29T18:21:03ZGraceVHall·2000-05-09UHC2096519•••-••-4908NULL··—2262 BAYSHORE DRTempeAZ85213·GRP-1722CORE-HMO
ENRENR-135705 2026-01-23T20:16:07ZKim—LuacsJun 1, 1954—•••-••-0584·(251) 245-0596kimberly.lucas@yahoo.com3323 BAYSHORE DR #545TucsonAZ85737GRP-7305CHOICE-PLUS-PPO
CLMCLM-4039382026-03-22T21:01:18ZVasquez, Jerry——2000-12-19UHC-81842-70····null-3137 Willow Court·FresnoCA93701··—
ENRENR-1339462026-07-09T18:11:21ZJONSON·Z.AMANDA19460703uhc-06364-64•••-••-220418624656105AMANDA.JOHNSON@GMAIL.COM9444 Cedar LnSacramentoCA—GRP-8411CORE-HMO
ENRENR-1131182026-09-14T22:35:38Z·LUCIATWOODS04/12/1967UHC-04770-46•••-••-2049773-979-1767LUCIA.WOODS25@YAHOO.COMN/AUNKNOWNnullNULLGRP-5150·MEDICARE-ADV-B
ENRENR-1109662026-09-30T03:28:51Z ABIGAILL··MARSHALL1943-09-25UHC-76851-39•••-••-59156475203297ABIGAIL.MARSHALL71@GMAIL.COM8253 Desert Sky Boulevard Apt 3DALLASTX75264GRP-2863SELECT-EPO
TPA TPA-559252026-05-14T18:12:12ZMarshall, Camila——1940-01-08N/A—N/Acamila.marshall51@yahoo.com3494 Ridge RoadMiamiFL33128—null
PRVPRV-254372026-04-09T08:48:18Zdorothy—griffin19441226—null4564782435—3855 Spring StreetOrlando··FL32886N/ANAVIGATE-HMO
ENRENR-1060112026-07-25T06:36:31Z·jacobMgeorgeJul 15, 1965UHC5144605•••-••-4205879.333.0365jacob.george69@icloud.com4378 Market StMesaAZ85286-7749GRP-7071CHOICE-PLUS-PPO
ENRENR-1028742026-09-25T22:24:23ZCharlotte—Alvarez04/04/1978UHC-27907-28•••-••-9869246-380-6005charlotte.alvarez@icloud.com5621 Pine Dr··SacramentoCA·95827·GRP-2069CORE-HMO
ENR ENR-1117922026-10-03T04:15:02ZKeithZSanchez1943-07-08UHC-66808-16•••-••-5816678-932-5429NULL3594 Desert Sky BlvdAustinTX78738GRP-2379MEDICARE-ADV-B
CLMCLM-4037612026-03-04T11:32:58ZCheryl—Sott07/23/71—•••-••-2474—NULL9254 Union StMiamiFL33196UNKNOWNSELECT-EPO
CLMCLM-4108292026-07-26T07:03:47Zjustin—estrada1999-10-01··UHC-08400-52—UNKNOWN-N/Anullnull—GRP-4204OPTIONS-PPO
ENRENR-1103422026-02-02T04:16:57ZkeithPwest2003-12-22UHC4597828•••-••-5905·3428078814keith.west44@yahoo.com··7579 Camelback Rd Apt 23OrlandoFL32860GRP-4466SELECT-EPO
TPA TPA-619872026-04-26T20:14:17ZSantiago—Sandoval1959-10-12N/AUNKNOWN—santiago.sandoval22@proton.me8497 CAMELBACK ROADSan AntonioTX78213-6923—-
ENRENR-1085652026-03-10T00:21:05Z DIEGOJTRAN1977-06-21UHC-63032-49•••-••-08619258975198diego.tran65@yahoo.com8046 GRAND AVENUEScottsdaleAZ85228··GRP-2763MEDICARE-ADV-A
ENRENR-1319332026-02-16T08:28:14ZADAMD.RIVERA··1945-11-13UHC-67662-14•••-••-8631--1591 Spring StLos AngelesCA90001GRP-6283SELECT-EPO
PRVPRV-239812026-01-21T15:30:07ZAndrea—Wilson·01/08/06N/AUNKNOWN·(524) 818-1787andrea.wilson@aol.com4292 PINE DRTempeArizona85282null··—
ENRENR-1294162026-04-22T19:20:11ZChristinaLDominguez19870317UHC-73710-24··•••-••-44835978094287NULL4892 UNION STREETMESAAZ85218GRP-5848CHOICE-PLUS-PPO
TPATPA-631012026-02-28T18:21:03ZChris—Lee··05/13/2000N/A—+1 853 450 6471··-8465 Lake View RdGilbertAZ·85263UNKNOWN—
ENRENR-1038922026-07-13T02:07:07Z GabrielV.Wallace2006-10-22UHC-12749-22•••-••-0828(831) 268-6415gabriel.wallace56@yahoo.com1555 RIVER ROADLas VegasNV89167GRP-1184CORE-HMO
TPATPA-59303 2026-08-19T09:18:19ZDorothy—Riley1986-06-13N/A•••-••-2764NULL··nullnull——·NULLGRP-9346NAVIGATE-HMO
CLM CLM-4326812026-09-08T08:25:18Z Helen—Nguyen11/19/1992·UHC3246591NULL4198476611helen.nguyen66@aol.com9835 Meadow LnNASHVILLETN37205GRP-3434—
CLMCLM-4296272026-07-01T15:28:56ZRUTHHCARPENTER1944-07-27UNKNOWN•••-••-1900901-554-5220null7473 MEADOW LNDALLASTX····-SELECT-EPO
ENRENR-1123822026-03-31T05:23:28ZHAROLD—DANIELS2007-11-13·UHC-82658-55•••-••-2484+1 538 398 3418harold.daniels@yahoo.com3445 Canyon RdSan Antonio·TXN/AGRP-5788·SELECT-EPO
CLMCLM-4198462026-05-18T17:30:24ZAustin—Torrres1941-04-06UHC-31919-33NULLUNKNOWN—5369 Bayshore DrTUCSONAZ—GRP-7007CORE-HMO
CLMCLM-4033412026-02-03T12:36:30Z Rachel—Gonzalez1973-10-17UHC-89828-42UNKNOWN(344) 409-4592·--··UNKNOWN—-UNKNOWNCHOICE-PLUS-PPO
CLM CLM-4244912026-02-08T13:34:54ZFatima—Stephens07/04/95UHC-06221-64-UNKNOWNfatima.stephens@outlook.com1103 Main StSacramentoCA95862N/Anull
ENRENR-1353292026-01-01T12:29:05ZRYAN—DIXON03/03/07UHC-90343-37•••-••-67538795979163RYAN.DIXON@AOL.COM3550 Lake View Rd Apt 27San DiegoCA92195GRP-5879NAVIGATE-HMO
CLMCLM-4011042026-06-15T17:57:16ZKathryn—Li2001-05-09UNKNOWN•••-••-2382-—5526 Central AvenueLos AngelesCA90072GRP-3805null
CLMCLM-4327862026-01-01T18:45:21ZTYLER—RAMIREZ·1985-08-04UHC-12321-25UNKNOWN8174637516··135 CHURCH STREETSan DiegoCA92111GRP-7403—
ENRENR-1018772026-06-05T03:30:54ZFrank—Soto1964-08-20UHC-49015-76•••-••-92605793489442·frank.soto@gmail.com4870 BAYSHORE DRDenverCO80298GRP-1892SELECT-EPO··
ENRENR-1105092026-05-10T21:53:40ZNelson, Priya——1961-02-03UHC-65947-09N/A+1 712 874 6994priya.nelson92@aol.com··9565 Ridge RoadSeattle··wa98154·GRP-8882SELECT-EPO
PRVPRV-251022026-09-12T02:44:23ZKathrynLBurke1952-10-06UHC3772705—18855054340—5009 GRAND AVE #402GLENDALEAZ85394··N/A—
ENRENR-136467 2026-06-26T16:25:12ZSteven—George7/9/1984UHC-26902-16NULL698-692-3791UNKNOWN4931 LINCOLN WAYOrlandoFL32839GRP-8482···MEDICARE-ADV-B
PRVPRV-205392026-09-28T22:17:42ZArmstrong, Jordan——1990-06-22-UNKNOWN722-496-7167JORDAN.ARMSTRONG12@HOTMAIL.COM5162 Bayshore Dr Apt 35San AntonioTX··78276··——
TPATPA-577962026-02-02T20:49:04ZDanielle—Ferguson1945-04-19—NULLNULL—3567 ELM STREETSan AntonioTX78209—SELECT-EPO
CLMCLM-4283002026-02-01T13:49:14Ztheresa—simpson1985-02-21UHC-13034-08—556-585-0121—2552 Maple AveJacksonvilleFL32230—null
100,000 rows, page 223 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-22T12:42:37.733Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty