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-504932026-10-13T23:44:28ZSARA—JAES06/24/1964—null(515) 208-7217sara.james67@proton.me2639 Sage CourtTempeArizonaNULL-null
ENRENR-1411362026-03-03T03:13:32Zharold—nichols1968-04-05UHC-60495-13•••-••-5697388-517-0909UNKNOWN4690 CEDAR LNMesaAZ85289GRP-1624MEDICARE-ADV-A
TPA TPA-593042026-04-25T19:57:52Z·Elijah··Carlson7/25/1990—•••-••-6231NULLELIJAH.CARLSON@OUTLOOK.COM7199 BROADWAY Apt 31MIAMIFL33181——
TPATPA-613662026-01-10T19:01:51ZRobertson, Sara——1962-04-12—•••-••-6258586-972-0474—910 FOREST AVENUEPHOENIXAZ85005N/ANULL
CLMCLM-4266872026-05-24T07:05:06ZFrancesBRoss12/11/87—•••-••-8404nullfrances.ross21@icloud.com379 WASHINGTON STLas VegasNV89188nullNULL
CLMCLM-4151072026-06-11T11:20:54Z·EmmaRWhite1975-07-18—•••-••-9977(573) 232-2798—8102 SAGE CTNashvilleTN37263GRP-3934OPTIONS-PPO
TPATPA-510842026-02-04T05:40:40Zrussell—walkre1991-03-18—•••-••-2366UNKNOWNN/A3949 MAIN STREET··OrlandoFL32835GRP-1845NULL
CLMCLM-4264122026-03-20T18:15:22ZRachel—Kenneedy1975-07-09UHC-76272-44•••-••-6888N/AUNKNOWN8703 Park PlacePhoenixAZ85029··—CORE-HMO
ENRENR-1416712026-03-05T09:48:45ZRodriguez, JoseQ.—1970-01-05UHC-27459-40•••-••-79525206882218jose.rodriguez@icloud.com6126 Camelback RoadHOUSTONTX77074GRP-2553MEDICARE-ADV-B
CLMCLM-423788 2026-01-23T02:57:49ZMIKE··—MATTHEWS1998-09-14UHC-27533-36·null(393) 293-2161NULL·9134 Grand AvenueGLENDALE··AZ85374nullN/A
ENRENR-1018542026-08-16T16:13:18Z Bruce—Cruz·1996-10-04UHC-96984-10N/A361.639.8856··622 MARKET STEden PrairieMN55324GRP-5316CHOICE-PLUS-PPO
ENRENR-1361952026-01-02T07:12:46ZRichardALawrence1953-06-20UHC-05636-56NULL679-813-8722richard.lawrence99@gmail.com7375 SAGE CTEden PrairieMN55371GRP-7594MEDICARE-ADV-A
TPATPA-623802026-08-22T19:55:55ZandreaQgarcia1952-09-28——N/Anull7817 Washington StreetHoustonTX77059-4244-··MEDICARE-ADV-A
TPATPA-63886 2026-04-26T19:52:23Zjason—banks1980-09-01—•••-••-0100735-422-1150—5769 Park PlSacramentoCA95810—null
PRVPRV-280192026-10-13T14:16:30ZEmily—Reynolds19620406UHC-54398-28··N/A(890) 339-2682UNKNOWN5254 MOUNTAIN VIEW DRAustinTX·78712—SELECT-EPO
ENRENR-1293282026-09-26T02:35:51ZRIOS—RALPH19580916UHC-33129-05•••-••-26862778450487NULL9132 Desert Sky BoulevardGilbertAZ85299GRP-5891·CHOICE-PLUS-PPO
ENRENR-1026472026-06-12T13:55:15ZAaron·IWelch1/19/1960UHC-90955-29•••-••-5455615-509-2153aaron.welch44@gmail.com··2218 Harbor BoulevardTempeAZnullGRP-1340CHOICE-PLUS-PPO··
ENRENR-1167162026-02-21T06:54:55Zmateo··Q.flores1975-04-04UHC-34251-40—3226007276mateo.flores60@icloud.com486 Highland Avenue··JacksonvilleFL32249GRP-2115OPTIONS-PPO
ENR ENR-1353742026-10-12T11:04:15ZthomasManderson1965-04-13UHC-56943-80•••-••-7690(539) 297-8987thomas.anderson@outlook.com4269 Oak StTucsonArizonanullGRP-0883navigate-hmo
ENRENR-1231562026-07-31T12:54:20ZLopez, ChristinaT—19771124UHC-93022-02•••-••-3382(458) 733-3626··christina.lopez@yahoo.com8112 Maple AveMESAAZ··85290·GRP-6310CHOICE-PLUS-PPO
ENRENR-1247062026-07-09T07:40:25ZHicks, Dick——1987-02-15UHC-29945-79•••-••-6512351-496-9043·richard.hicks@outlook.com6440 River RdEden PrairieMN55321·GRP-8462CHOICE-PLUS-PPO··
TPATPA-577272026-03-19T16:21:32ZAmber—Hicks··20021204······UNKNOWN·NULLUNKNOWN737 Sunset BlvdHoustonTX77001GRP-4104CORE-HMO
CLMCLM-4093592026-08-15T22:26:37ZSusan—Scott1971-09-12—N/A7159685927UNKNOWN6472 Main StSan DiegoCA-NULL—
ENRENR-1253532026-07-24T13:36:41ZWayne K—Collins1983-12-03UHC-90077-22•••-••-4187442.599.3236·null73 UNION STREETSeattleWA98188GRP-6454MEDICARE-ADV-B
ENRENR-1261602026-09-15T12:56:57Z·Gery Q—Nelson1968-12-10UHC-97451-67•••-••-17519166121182gary.nelson41@icloud.com1869 Oak StreetSan DiegoCalifornia92156GRP-3489NAVIGATE-HMO
TPATPA-622562026-05-29T11:59:14ZAbigail—Daniels05/18/69UHC-73907-78•••-••-1113——6875 Indian School RoadLos AngelesCA90059—null
CLMCLM-4256392026-07-18T08:15:33ZHEATHER—MEYER1980-55-19UHC-17486-97•••-••-8751—heather.meyer@proton.me9200 HARBOR BOULEVARDCharlotteNC28252nullNULL
ENRENR-1006822026-05-24T18:47:25ZRACHEL—MARTINEZ04/19/1967uhc-62495-82•••-••-2097(956) 497-5888··rachel.martinez@icloud.com5776 CHURCH STTampaFL33668GRP-8750SELECT-EPO
CLMCLM-4192882026-06-09T14:56:05ZMADISON··—KNIGHT1984-02-05UHC-85507-79··NULLnullUNKNOWN·8677 Baseline Road Apt 18AtlantaGA30319-0712GRP-6935NULL
CLMCLM-4189862026-05-02T10:00:17ZAHMED—SANDERSUNKNOWNUHC-07701-06N/A4209977132—2821 Sunset BlvdSacramentoCA95877GRP-0541OPTIONS-PPO
ENRENR-1223912026-06-11T08:57:16ZRobert—Torres1943-03-26UHC-72833-91•••-••-14967008206814robert.torres39@outlook.com··6352 Cedar LaneChandlerAZ85263GRP-9145CHOICE-PLUS-PPO
ENRENR-1078262026-08-10T23:04:36ZJANICE—PHILLIPS1982-07-19·UHC-17792-86•••-••-0026(821) 670-8173janice.phillips12@gmail.com5098 PINE DRDallasTexas75203GRP-2723MEDICARE-ADV-A
ENRENR-1006392026-09-06T07:01:06ZPatrickVNelson06/21/94UHC-19242-69•••-••-1152554.671.5741PATRICK.NELSON@ICLOUD.COM7564 Maple Ave #448GilbertAZ85291GRP-5909MEDICARE-ADV-A
CLMCLM-4071262026-06-30T18:46:28ZValentina—Wheeler1944-03-26N/A•••-••-9595UNKNOWNUNKNOWN7039 BroadwayAtlantaGAUNKNOWNNULLSELECT-EPO
CLMCLM-4126522026-01-28T02:05:37ZevelynIstewart3/4/1997UHC-37643-23UNKNOWN4851253··—8320 UNION STREETAtlantaGA30332·N/A·NULL
ENRENR-1276612026-02-04T01:48:59ZKATHERINEWADAMS1942-07-08UHC2838312•••-••-23616486388366katherine.adams@outlook.com554 PARK PLLOS ANGELESCA—GRP-7411NAVIGATE-HMO
ENRENR-1117782026-10-15T17:11:00Z·JSAONZCRUZ12/25/78UHC-52777-98•••-••-0840942-664-3947jason.cruz@gmail.com3700 Baseline RoadNASHVILLE··TN37278GRP-6955NAVIGATE-HMO
ENRENR-1314582026-06-07T15:53:50ZJason—Hansen1997-01-02UHC3293416N/A8988894308··JASON.HANSEN@HOTMAIL.COM4063 BROADWAYSacramento·CA95866GRP-0926NAVIGATE-HMO
TPATPA-599882026-05-23T07:24:19ZBennett, Roger——3/2/2000UHC-51537-03UNKNOWN·231-265-6060N/A··6308 SPRING STAUSTINTX78757GRP-3828··null
ENRENR-1005902026-06-27T07:19:36ZANNAPWEST1992-12-07UHC-73605-83•••-••-1722+1 204 492 4905·N/A4679 Harbor Boulevard··ScottsdaleAZ85260-8823GRP-9725OPTIONS-PPO
CLMCLM-4282262026-08-12T21:31:38ZJOAN—VAZQUEZ1958-10-06——395-964-8074-2813 Valley View DrChandlerAZ·85283GRP-0351N/A
PRVPRV-247932026-04-04T04:42:27ZANTHONY—REED1942-05-02-•••-••-3188+1 833 275 1534··UNKNOWN6410 Cedar LnNASHVILLETennessee37221··null-··
CLMCLM-4273832026-04-08T10:07:09ZLori—Armstrong1939-08-17uhc-85173-78—NULL-N/Anull—UNKNOWNGRP-8696OPTIONS-PPO
ENRENR-1050472026-09-05T22:08:09ZALEXISK.ALLENJul 5, 1982UHC-33958-06•••-••-09623436895935—2419 BroadwayLas VegasNV89111GRP-9815OPTIONS-PPO
CLMCLM-4174522026-06-05T17:56:15ZRachel—Webb2001-04-13UNKNOWN•••-••-1857312-762-5131—5298 Maple AvenueAtlantaGA30378··GRP-2919··NULL
ENRENR-1073102026-01-02T01:18:44ZChristineTWard19991210UHC-46328-06•••-••-8597447-570-6677··CHRISTINE.WARD@OUTLOOK.COM1291 Lincoln WayMesaArizona85216-5074·GRP-4661SELECT-EPO
ENRENR-105132 2026-08-12T16:03:19ZSadra··Saalzar2007-03-05UHC-10794-72•••-••-81888435790872sandra.salazar22@icloud.com8418 Church St Apt 30Plano··TX75095GRP-8625SELECT-EPO
CLMCLM-4024032026-08-25T14:46:48Zsantiago—green2008-06-06UHC-37513-76···N/A8392941285-7039 CHURCH STLos Angeles·CA90075NULL··
TPATPA-525532026-06-27T21:00:47ZAstinGRiley1992-12-27N/A·NULL—nullUNKNOWN——·UNKNOWNNULLCHOICE-PLUS-PPO
ENRENR-1334132026-01-21T15:23:30ZJASONIROSE1967-10-22UHC-44955-22•••-••-69224399997437jason.rose50@icloud.com4069 Pine DrMESAAZ85230GRP-4386SELECT-EPO
100,000 rows, page 17 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:34.760Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty