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-1010682026-03-21T05:26:19ZStevenUArmstrongSep 3, 1947UHC-37944-44•••-••-03148308514947steven.armstrong64@hotmail.com2077 Grand AvePlanoTX75051GRP-7342CHOICE-PLUS-PPO
CLM CLM-4032492026-05-28T22:09:29ZTERESAP.WANGJan 9, 1980··UHC-66405-35•••-••-3572(965) 542-9232NULL1451 Spring StreetLos AngelesCA90051GRP-0425MEDICARE-ADV-A
CLMCLM-4104622026-09-24T21:03:00ZJoe—Lane01/10/74UHC-01685-47—2367518115—1430 Camelback Road·AUSTINTX78797GRP-5695CHOICE-PLUS-PPO
PRVPRV-201272026-10-10T11:39:37Zlinda—wong1947-02-11UHC-59924-42—·816.505.9028N/A6511 CANYON ROAD···DenverCO80243UNKNOWNOPTIONS-PPO
ENRENR-1110302026-01-19T16:31:21ZAlbertAHerrera1979-02-01UHC-78925-85•••-••-4996267.264.4878·N/A5972 Baseline RoadCharlotteNC28221-0875GRP-6426MEDICARE-ADV-A
ENRENR-1154812026-09-29T08:47:08ZRAYMONDNPATTERSON·1938-09-28UHC-88717-54··•••-••-4808222-799-5434raymond.patterson@icloud.com8662 Sage CtCHANDLERAZ85251GRP-0146·OPTIONS-PPO
ENRENR-1188112026-09-10T21:21:55ZVICTORIAJHARVEY·2002-10-06UHC-56992-35•••-••-2362401-264-9252victoria.harvey27@aol.com3235 Bayshore DrGlendaleAZ85359GRP-4862MEDICARE-ADV-B
TPATPA-524582026-03-21T18:04:57ZMELISSA—·ALEXANDER2002-05-27—•••-••-6201—····6643 BroadwaySCOTTSDALEAZ85233-—
CLMCLM-4285302026-08-03T13:49:45ZEmma····Le2002-11-16N/Anull·5167630412emma.le79@gmail.com··5485 Church StSan DiegoCA92198GRP-5190null
CLMCLM-4293432026-03-07T15:19:57Zfrenk··J.carroll13-04-1958UHC-98820-98•••-••-0995941-679-6873—UNKNOWN··——·NULLGRP-6754—
CLMCLM-4117652026-03-23T13:09:32Z JEFFREY—VAZQUEZ06/12/2007UNKNOWN—5369495497—2458 Lincoln WayHoustonTX—GRP-2814-
TPATPA-642492026-04-25T00:55:49ZAmber—Ruiz1947-11-07—•••-••-5084(828) 841-8858null9109 Union StSCOTTSDALEAZ85281nullnull
TPATPA-628682026-02-27T02:02:44ZOMAR—GONZALES1974-03-09UNKNOWN•••-••-5711NULL———NULL—GRP-1859—
CLMCLM-4242762026-06-16T23:48:29ZDeborah··Vargas1944-06-26UHC-22202-05•••-••-3169NULL—4953 APACHE BLVDMinneapolisMN55473NULL—
CLMCLM-4049132026-03-13T02:37:57ZAustin—Wong1961-03-19UHC-52819-86··NULL(757) 995-6047N/A—N/AUNKNOWN-GRP-0242MEDICARE-ADV-A
ENRENR-133133 2026-05-16T09:56:00ZCynthiaPMoore1943-06-06UHC-70365-62—(808) 201-5226cynthia.moore75@aol.com88 CHURCH STREETLos Angeles·CA90028GRP-3311options-ppo
ENRENR-1387912026-08-25T11:18:46Z Christtopher—Wilson1946-12-07UHC-54608-62•••-••-5020+1 679 595 6001CHRISTOPHER.WILSON81@OUTLOOK.COM5634 WASHINGTON STREETTucsonAZ85776GRP-7179·NAVIGATE-HMO
ENRENR-1247962026-08-11T01:58:09ZJack—Howard9/14/1952UHC-70080-35•••-••-9547669-703-5497N/A3222 Indian School RdOrlando··FL32851GRP-4156OPTIONS-PPO
CLMCLM-4075062026-05-15T03:14:46ZDaniel··—Le1973-04-26N/A•••-••-7375225-327-0364—7309 OAK STTucsonAZ85782NULLNULL
CLMCLM-4146262026-02-15T07:32:06ZKathleenXAndrews1960-05-22UHC-09149-87—-kathleen.andrews77@proton.me—-NULLN/AGRP-7974MEDICARE-ADV-B
TPA TPA-607262026-08-14T19:25:08ZCamila—Harvey1982-04-12··•••-••-21089896133611camila.harvey74@aol.comN/A—UNKNOWN—GRP-5700NULL
CLMCLM-4292892026-05-16T05:43:38ZVIRGINIAYWONGMar 7, 1971——671-435-7218—-····—-nullnull
CLMCLM-4057342026-08-18T03:29:21Zbeverly—hughes1988-06-28N/A•••-••-1537UNKNOWNN/A3148 Cedar LanePLANOTX75003·NULLSELECT-EPO
ENRENR-1415652026-01-11T20:25:04ZPATRICKM.·WELCH-UHC-89309-03•••-••-35936146469836PATRICK.WELCH59@GMAIL.COM4756 Mesa Drive·MesaAZ85289GRP-9346MEDICARE-ADV-A
CLMCLM-4101302026-01-09T10:56:14ZStephanie—Reed1993-01-10N/A··—263-595-0946NULL7427 Church StreetNashvilleTN37269GRP-3167CHOICE-PLUS-PPO
ENRENR-1200902026-09-03T07:51:03ZSamuel—Robinson03/26/1966UHC-35425-74•••-••-9026256-217-9642samuel.robinson@proton.me944 HILLCREST RDLos AngelesCA90080GRP-9388MEDICARE-ADV-A
CLMCLM-4229542026-08-04T07:19:48ZLoganWSimmuns1959-06-11UHC-67698-28—9247951154——NULLNULLN/A-N/A
CLMCLM-4125662026-01-27T17:34:21ZKATHLEEN—LANE2601-20-01UHC-31114-80-null—7643 HIGHLAND AVEMiamiFL33193-CHOICE-PLUS-PPO
ENRENR-1274972026-05-19T12:19:50ZAnnDNguyen1987-01-03UHC-02107-04•••-••-5715+1 356 620 2158ANN.NGUYEN@ICLOUD.COM5519 WASHINGTON STChandlerAZ·85258GRP-4096select-epo
CLMCLM-4274492026-08-29T02:13:45ZJERRY—THOMPSON2002-05-17UHC-11477-88•••-••-6283674.825.6938—8227 Mesa DriveAtlantaGA30338·····UNKNOWN
PRVPRV-202802026-08-29T06:16:15ZLORICDIXON1939-09-23UHC-20645-16——null——-—UNKNOWN··NULL
ENRENR-1268582026-04-03T03:28:44ZTerry—Singh01-11-1977UHC-38201-98•••-••-15144094278879terry.singh76@hotmail.com7403 Sage CtGilbertAZ85235GRP-0735OPTIONS-PPO
ENRENR-1129452026-02-11T02:11:26ZOlivia—Tran1980-03-18UHC-76853-38•••-••-7812·null·OLIVIA.TRAN19@HOTMAIL.COM3305 Indian School RoadMesaArizona85293GRP-5994choice-plus-ppo
PRVPRV-253252026-07-29T23:04:35ZROGERFARNOLD2005-06-25—N/A2925753939——N/A—-··NULLCHOICE-PLUS-PPO
CLMCLM-4049882026-02-23T13:50:46ZKennedy, Christina——1985-08-03UHC-24928-35NULL(212) 834-7188null1803 CENTRAL AVE··TUCSONAZ··85706GRP-2701CHOICE-PLUS-PPO
CLMCLM-4155992026-07-11T08:03:20ZAnnaC.Fox1995-06-05N/A··•••-••-4228·(493) 830-2103null—UNKNOWNNULL—GRP-2501N/A
TPATPA-603942026-04-25T16:25:30ZMEI—CARTER1992-06-24UNKNOWN-NULL··635 Highland Avenue·HoustonTX77055·GRP-3826MEDICARE-ADV-B
ENRENR-1140522026-04-13T06:59:03ZESPINOZAPDYLAN1955-06-26UHC-01683-02•••-••-7240(273) 914-7317N/A2999 Lincoln WayDENVERColorado···80210GRP-9254SELECT-EPO
TPATPA-593632026-04-28T01:34:33ZHelen—Guerrero19910823UHC-70876-54———3231 Baseline RoadGlendale·AZN/A—null
ENRENR-1396452026-06-08T18:41:49ZJuliaR··Hanson5/1/2007UHC-74657-99•••-••-0438·327-753-9320JULIA.HANSON@OUTLOOK.COM6216 Lincoln Way·MinneapolisMN55479-0616GRP-9300·SELECT-EPO
CLMCLM-4020502026-10-14T13:26:54ZNatalie—Palmer19730904NULL—N/A-2173 Forest AveEden PrairieMN·55344-CORE-HMO
ENRENR-1270822026-05-23T18:13:09Znancy—jaames1946-09-07UHC-05876-17•••-••-9360(460) 960-0973nancy.james11@proton.me6049 Bayshore DrHoustonTX77031·GRP-0431MEDICARE-ADV-B
PRVPRV-211772026-01-04T22:06:16ZAllen, Maria——12/8/1963UHC-56210-79•••-••-8923801-201-5427N/A4502 Hillcrest RoadPhoenixAZ85052NULL····
CLMCLM-4075312026-04-04T01:20:42ZRoger—White08/05/1948UHC3807845NULLUNKNOWNN/A1413 Meadow LaneMiamifl33135GRP-5884select-epo
CLMCLM-4029712026-01-04T11:11:55ZYUKI—WHITE1954-11-15UHC-76332-15-——·4932 Maple AveDenverCO80255-6391GRP-6888—
ENRENR-1123262026-05-11T23:34:04ZTIM·CCRAWFORD08/17/70UHC-33870-20•••-••-8908(273) 892-2197timothy.crawford@icloud.com2957 CEDAR LANEGlendaleAZ85395··GRP-8938CHOICE-PLUS-PPO
TPATPA-528042026-02-07T09:56:42ZAlexander··—Yang1993-07-25·UHC-49539-93UNKNOWN—-527 LINCOLN WAYDallasTX75297—····
ENRENR-1125042026-02-28T06:26:21ZSharon P.—Mendez1974-04-01··UHC-87920-25•••-••-9861218.674.8802·····6167 Ocean AvenuePhoenixArizona85080GRP-0152NAVIGATE-HMO
TPATPA-592942026-10-10T17:43:58ZArthur—Parker1971-03-13··NULL(920) 760-8700null--—--—
TPATPA-553192026-07-09T11:46:22Zgreg—moreno1991-02-06null—210-369-2644—·2887 Apache BlvdFresnoCA93727-7767N/Anull
100,000 rows, page 199 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:36.722Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty