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

Third-party administrator only, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
TPATPA-593382026-09-17T00:52:40ZNathan—Nelson1980-02-19null—·714-857-0254—2023 PARK PLACETampaFL33608-2268GRP-1931-
TPATPA-623832026-09-10T15:42:06ZBenjamin—SimmonsJun 14, 1971—null——8450 Camelback RoadGilbertAZ85224——
TPA TPA-525522026-09-05T19:57:29ZChristina···REstrada1992-01-23····•••-••-3011—NULL2304 Washington StreetAtlantaga30317—····
TPATPA-551762026-06-30T11:52:07ZKevinWAndrews10-12-1969····—--3176 Washington StreetSan DiegoCA92141UNKNOWN··—
TPATPA-506572026-08-09T02:21:44ZAmanda—Lee1944-07-18UNKNOWN—nullNULL114 MESA DRIVEAtlantaGA30338N/ASELECT-EPO
TPATPA-621092026-01-08T13:46:54Z·Wiliam—Colemen02/20/69-NULL—WILLIAM.COLEMAN@AOL.COM8040 Baseline Rd··Houstontx77056—null
TPATPA-586622026-02-08T19:04:08ZRyan—Smith1942-09-01NULL•••-••-9340·N/AN/A5462 Indian School RoadGilbertAZ85299UNKNOWNNULL
TPATPA-511952026-08-05T20:40:21ZJoseph··Alexander26-07-1951nullnull12196123030UNKNOWN9203 Camelback RoadSan AntonioTX78275—-
TPATPA-504342026-09-21T17:37:06ZHeather—Lopez19411208—N/A(540) 631-6183heather.lopez@yahoo.com2352 RIDGE RDSeattleWA98122··—·OPTIONS-PPO
TPATPA-515682026-09-20T13:05:36Zbrandon··—lopez1955-02-03null··—NULL4254 Desert Sky BlvdSEATTLEWAUNKNOWNNULLnull
TPATPA-60178 2026-01-13T08:05:59ZSantiago—Foster03/15/87N/AN/A-UNKNOWN6861 Ridge RdEden Prairiemn55302GRP-0489N/A
TPATPA-576362026-07-03T17:13:43ZJacob—Russell3/27/1961null··NULL5020664null2233 BROADWAYDallastx75284GRP-6727—
TPATPA-504952026-01-07T08:56:29ZTimothy—Hernandez1991-07-06-•••-••-0619———-—··NULL·N/A
TPATPA-578832026-07-17T12:37:05ZHanson, Andrea——11/09/1971-—UNKNOWN—8510 CAMELBACK RDPLANOTX75012GRP-7933—
TPATPA-510412026-10-02T23:43:59ZAiishaE.Snyder··10/25/1988NULL•••-••-7974(688) 772-0113AISHA.SNYDER@OUTLOOK.COM652 Desert Sky BlvdMiamiFL33137N/AMEDICARE-ADV-B
TPATPA-634532026-01-22T07:53:17ZSTEPHEEN—HERRERA1950-05-18·null—UNKNOWN—1373 PARK PLACEMinneapolisMN55449-—
TPATPA-556042026-08-10T04:34:35ZChristian··—West1982-01-14—N/ANULL-7534 Sage CourtLos AngelesCalifornia90037··nullOPTIONS-PPO
TPATPA-596472026-03-31T01:27:50ZOmar—Grant9/21/1979NULL—UNKNOWNNULL3168 Baseline RdColumbusOH43288NULL-
TPATPA-589822026-01-25T18:15:19ZDonald—Elllis1939-01-25——2809011502—9268 Union StreetTempeArizona85269N/AMEDICARE-ADV-A
TPATPA-582612026-07-19T00:54:29ZSAMJ.OLIVER1968-03-01·-•••-••-5021+1 580 929 4918N/A·3743 Church StHoustonTX77089—CORE-HMO
TPATPA-559122026-01-26T08:24:34Z·Black, Alice——1995-09-01—-14887427255UNKNOWN8121 Ocean AvenueLos AngelesCA90040——
TPATPA-612152026-05-04T10:01:42ZFranklin, Lauren——1961-08-23null-null··2015 Lake View RdJacksonvilleFL32203N/A··
TPATPA-550072026-05-03T20:40:20Z·HEATHER—GARZA1983-04-15———-7382 BASELINE RDPhoenixAZ85013UNKNOWNOPTIONS-PPO
TPATPA-595862026-01-27T16:48:20ZKAEN—MILLS1992-07-13UNKNOWN—+1 416 990 9506····4749 Highland AvenueDenverCO80234nullNULL
TPATPA-58408 2026-06-26T12:47:16ZAshley—Hall3/15/2002UNKNOWN—UNKNOWN····5373 JEFFERSON AVENashvilleTN37281N/AN/A
TPATPA-511932026-09-06T20:11:20ZWei—Ferguson··1953-09-09null•••-••-0419-NULLnull——UNKNOWN—NULL
TPATPA-613882026-07-15T13:16:57ZBILL—ELLIS02/14/01—NULL··—·8506 SUNSET BLVDGilbertAZ·85272GRP-1983UNKNOWN
TPATPA-620432026-06-02T05:26:08ZLynch, Olivia··—1991-07-18—nullNULLN/A4811 CENTRAL AVENUEDallasTX75243NULLMEDICARE-ADV-B
TPATPA-586932026-03-22T09:01:07ZCarlos—Stephens1956-08-03-NULL8574139303NULLN/A--UNKNOWNUNKNOWNUNKNOWN
TPATPA-501992026-04-22T15:58:38ZCooper, Theresa——Jan 11, 1980UHC-54625-21•••-••-0348nullUNKNOWN2097 CENTRAL AVELOS ANGELESCA90040-—
TPATPA-581112026-08-14T04:34:59ZBrian··Ford1997-05-10null•••-••-4066866-532-1931NULL········-NULLGRP-3259—
TPA TPA-553332026-07-29T16:04:58ZAustin—Mendoza1981-06-10-•••-••-44217504889876—2394 Willow CtMiamiFL33191-null
TPATPA-614212026-10-03T05:27:57ZLori—Arnold02/13/61N/AN/AnullN/A-—nullnull—MEDICARE-ADV-B
TPATPA-527322026-09-24T15:26:41ZBeverly—Freeman·19630723····•••-••-8124N/A—8881 Mountain View DrTUCSONAZ85774GRP-4862··NAVIGATE-HMO
TPATPA-562562026-07-25T03:22:36ZEMMA··—·HUDSON1975-12-12N/A•••-••-7947—N/A5153 Sunset BlvdPhoenixaz85085—-
TPATPA-621382026-05-26T12:27:03ZSusan—Diaz1968-04-05—•••-••-86078946174429N/A5538 Grand AvenueScottsdaleAZ85299-6024—-
TPATPA-632712026-08-29T10:48:55ZangelaG.martinez9/13/1942UNKNOWNUNKNOWN-—null——UNKNOWN—NULL
TPATPA-505772026-06-12T05:20:56ZVIRGINIA—RUIZ2002-06-11N/A—N/A—2822 Elm StLas Vegas··NV89175null-
TPATPA-523652026-02-15T16:17:26ZTimothy—Rice9184-10-08—•••-••-09377588355UNKNOWN7784 Canyon RdFresnoCA·93714GRP-2574MEDICARE-ADV-B
TPATPA-509032026-03-28T23:07:36ZPhilip—White1989-07-21NULL—7574741676—-null——UNKNOWNMEDICARE-ADV-B
TPATPA-610192026-01-08T21:32:48Z·CarolCMeyer1979-07-21——9489581N/A3897 Camelback Rd·NASHVILLETN··37265—··
TPATPA-583392026-05-26T12:07:47Z·Joseph—Evans1996-07-02NULL—--7198 Oak StTempeAZ85236NULL—
TPATPA-593692026-05-17T11:34:46ZSean—Le1990-55-23null•••-••-0669NULL—465 WILLOW COURTAustinTX78743N/ACHOICE-PLUS-PPO
TPATPA-581322026-05-11T09:25:55ZKATHERINE—FERGUSON08/13/1952—null367.635.7146—7839 Elm StSAN DIEGOCA92116GRP-6806··—
TPATPA-621652026-01-22T19:58:31Z·Nancy—Alexander1950-80-14UHC-02077-35UNKNOWNnull—4505 SPRING STREETDallasTX··75253··—null
TPATPA-528692026-03-27T20:17:38Z·Melissa—MontgomeryFeb 11, 1985—•••-••-18703985284849—1611 Spring StreetPlanoTX75087-N/A
TPATPA-613382026-07-24T10:37:08ZALEXANDER—MASON1941-06-17--8495998562—1686 Oak StMesa··AZN/AN/A-
TPATPA-617292026-10-07T01:41:11Z·Elijah—Moorales3/8/1950N/A—-N/A7332 FOREST AVE #968Columbusoh43216·N/A—
TPATPA-517492026-06-19T23:55:06Zjeremy—snyder1997-11-27N/Anullnull—4178 Park PlaceJacksonvilleFL32209N/AMEDICARE-ADV-B
TPATPA-510562026-03-03T23:59:39ZMary—Allen10/02/74UHC-94733-16—UNKNOWNnull4111 Grand Avenue #224Eden PrairieMN55368GRP-2988NULL
14,474 rows, page 123 of 290PreviousNext

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