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-561032026-07-16T08:40:19Zmargaret—hut1941-10-25-···N/AN/A8780 CAMELBACK RDDenverCO80265··—
TPATPA-522652026-03-03T04:35:13ZRichard—Hudson1974-01-08NULL—(701) 740-0006··-7415 SAGE COURTSEATTLE··WA98183—NULL
TPATPA-560112026-10-13T03:19:50ZBradley—Perkins1970-01-06NULL•••-••-11918269444566-1302 Jefferson AveSacramento·CA95847GRP-4197-
TPATPA-610292026-10-01T05:41:58ZMARK··WEBER03/02/2004-•••-••-3217·nullnull7694 Central Ave·ScottsdaleAZnullN/A··—
TPATPA-523562026-04-28T22:35:58ZDanielleNEllis1990-10-07NULL—4336129016UNKNOWN5780 MEADOW LNSacramentoCA95825—-
TPATPA-615552026-04-19T15:40:21ZGLORIA—SALAZAR1943-01-13———gloria.salazar2@proton.me944 Forest AvenueORLANDOFL32805—OPTIONS-PPO
TPATPA-609772026-01-21T20:09:36Znatalie—hayes11/18/1954NULL•••-••-38279218285903natalie.hayes@outlook.com··5420 Ridge RdPlano··TX·75032····OPTIONS-PPO
TPATPA-539642026-05-11T06:23:10ZWard, Danielle——9/25/2003null—N/Anull8315 Central AvenueScottsdaleAZ85262UNKNOWNCORE-HMO
TPA TPA-505022026-02-12T01:06:34ZRebecca—Gaarza1976-06-04null—UNKNOWN—5159 MOUNTAIN VIEW DR·GilbertAZ85272NULLnull
TPATPA-545662026-10-17T04:20:29ZMichelle—Cunningham··2007-07-25-•••-••-3498—michelle.cunningham2@gmail.com1038 Main St #290GILBERTAZ85250-4004—N/A
TPATPA-503742026-02-27T02:12:26ZLoriQWarren1976-12-09-nullNULL··4758 HIGHLAND AVELos AngelesCA90065null··-
TPATPA-570282026-06-01T15:36:53ZJudithC.·Mills1943-05-28UHC-96992-51nullN/Anull··7674 PINE DRDENVERCO80205—MEDICARE-ADV-B
TPATPA-619502026-05-23T16:23:47ZEUGENE—OLIVER09/23/1980—-(293) 800-7094—3552 Spring StreetCharlotteNC28221GRP-9080core-hmo··
TPATPA-508252026-02-03T12:43:09ZEllis, Virginia—··1954-12-02N/A-··511-509-6230NULL5174 Forest AvenuePhoenix··AZ85032····OPTIONS-PPO
TPATPA-630902026-01-27T02:19:03ZRussell—Kennedy05/20/80—N/Anull—·4980 JEFFERSON AVECharlotteNC28211··UNKNOWN·null
TPATPA-539412026-03-20T19:02:12Zbrittany····hawkins1982-05-12UHC-09960-63UNKNOWNUNKNOWN—2844 Meadow LnLos AngelesCA··90098GRP-6133UNKNOWN
TPATPA-552072026-03-15T07:56:28ZZachary··—·Holmes10-05-1960—•••-••-5357(698) 537-9094zachary.holmes98@icloud.com5767 BroadwaySacramentoCA95856-8963··MEDICARE-ADV-B
TPATPA-608502026-02-16T16:12:46ZluisMhamilton1969-07-08—-null··—7639 BROADWAYGlendaleAZ85340—N/A
TPA TPA-601652026-07-07T22:46:06ZSANDRA—BANKS28-12-2000NULLUNKNOWNN/A—7841 Park PlTucsonAZ85736GRP-3509—
TPATPA-511772026-06-05T18:14:33ZWayne—LarwenceOct 10, 1941N/A—-····6617 HILLCREST ROADChandlerAZ85228——
TPATPA-557882026-03-21T10:50:55ZTimothy—Stnoe1970-03-26UHC-35791-77N/A262-723-8203N/A1872 RIDGE ROADChandler·AZ85237—-
TPATPA-591142026-05-22T01:36:29Zgary—jenkins19809508N/AN/A—-5509 Palm Dr Apt 32·JacksonvilleFL32273GRP-1064MEDICARE-ADV-B
TPATPA-548772026-09-21T22:43:33ZNancy—Davis1976-04-16—N/A7686375785NANCY.DAVIS@AOL.COM487 Pine Drive··MinneapolisMN55480——
TPATPA-618232026-09-06T12:47:13ZWallace, Deborah——20-01-1971NULL—727.366.3553null7441 OCEAN AVENUENashvilleTennessee37227null—
TPATPA-585252026-02-01T15:06:06ZMADISN—RODRIGUEZ20-03-1987null·-——1469 Mountain View DriveSan AntonioTX78215—N/A
TPATPA-508272026-09-17T06:22:12ZPamela—Ruiz1951-01-16UNKNOWN•••-••-9925——2604 BASELINE ROADGILBERTAZ85256UNKNOWN··UNKNOWN
TPATPA-587382026-02-15T00:30:04ZAaron—Ortiz1971-12-01UHC-59807-57•••-••-2054NULL—3890 Baseline RoadTempe··AZ85238-CHOICE-PLUS-PPO
TPATPA-527292026-06-14T00:34:56ZPatricia—Diaz12-12-1988UHC2430439UNKNOWN224-914-3798UNKNOWN1160 Washington StreetMinneapolismn55427—·UNKNOWN
TPATPA-523122026-10-18T08:25:00Z JEFFREY—OLIVER2008-06-11UHC-68483-48NULL5979621331·JEFFREY.OLIVER84@OUTLOOK.COM5314 CAMELBACK ROADMesa···AZ85264N/Anull
TPATPA-589682026-08-10T14:19:59ZAISHA—COOPER3/6/1962——N/A··NULL·7175 BroadwayDENVERColorado80200GRP-1998·UNKNOWN
TPATPA-607232026-01-05T18:47:14ZKIMBERLY—SANDOVAL19-08-1942····•••-••-4748N/ANULL4288 Pine DriveMesaAZ···85282····NULL
TPATPA-604442026-07-22T00:42:42ZTimothy—Bradley1/14/1982——806-890-0272—4594 BASELINE RDNASHVILLETN37285GRP-3292····
TPATPA-532162026-04-02T10:07:42ZPATRICIA—SULLIVAN1960-08-06———·null7284 GRAND AVEPLANOTX··75022UNKNOWN—
TPATPA-597842026-02-28T17:07:14Z·Morgan, Janet——4/24/1968——N/A—2596 Sunset BlvdChandlerAZ—GRP-6584UNKNOWN
TPATPA-600202026-04-30T11:16:54Z Bruce····Wells1977-11-17nullN/ANULL-7373 Pine Drive #846CHARLOTTE··NC28233GRP-1061null
TPATPA-572322026-09-01T14:45:22Zbrian—bell1963-01-06—•••-••-4021723-578-7441brian.bell@hotmail.com784 Camelback RoadSan DiegoCA92192—N/A
TPA TPA-516262026-05-27T03:08:04ZSHIRLEY—PERKINS1945-11-26UNKNOWN•••-••-8470(759) 203-6389—6527 Jefferson AvenueMesaAZ85208-0516——
TPATPA-536542026-02-24T09:11:09Z·Thomas—Richardson1996-01-21null-N/Athomas.richardson@aol.com8105 BAYSHORE DRTucsonAZ85775-1463—NULL
TPATPA-520502026-07-31T12:18:24ZAshley··—Bowman1978-06-17UNKNOWNNULL—ASHLEY.BOWMAN@PROTON.MEN/A—N/AUNKNOWNGRP-9699—
TPATPA-558072026-03-20T09:14:49ZMatthews, Susan—····19-01-1979-N/A201-321-0863··-9469 Ocean AvenueCharlotteNC28232NULL—
TPATPA-601692026-01-05T13:42:25ZOlivia—Tucker1946-05-01······+1 585 601 7147··UNKNOWNN/A·--NULLNULLCHOICE-PLUS-PPO
TPATPA-557522026-04-29T04:39:06ZMoreno, Kathryn——1988-12-02null•••-••-21825587599229—9188 Grand AvenueColumbusOH43239—N/A
TPATPA-564332026-04-09T07:11:15ZTYLER—LAWSON1985-04-24null——·N/Anull—UNKNOWN··—GRP-0637-
TPATPA-530802026-05-09T15:07:03ZJERRY—FIELDS2007-01-11null—null—8454 BAYSHORE DRIVE··NASHVILLETN·37225··MEDICARE-ADV-B
TPATPA-620512026-02-13T01:44:19ZTYLERPCOLE1999-01-20UNKNOWN—(522) 784-8131UNKNOWN-——NULLNULL··MEDICARE-ADV-B
TPATPA-549242026-03-28T22:21:21ZNANCY··—·WHEELER1992-07-20··N/AN/A(283) 864-3586NULL3917 FOREST AVENUEMiamiFL33171-MEDICARE-ADV-A
TPATPA-624252026-05-16T23:50:46ZELIJAH—SPENCER1968-05-13UNKNOWN—N/A—3963 Forest Avenue Apt 35SacramentoCA95892NULL—
TPATPA-584242026-01-05T17:49:34ZNicole—Peterson1940-03-25NULLUNKNOWN—UNKNOWN4591 JEFFERSON AVENUEPHOENIXAZ85095-4913N/Acore-hmo
TPATPA-579622026-06-18T18:14:22ZJORDAN—HOWELL1965-02-13NULLUNKNOWN7936429148NULL8510 Mesa DrSan AntonioTX78250GRP-4794CHOICE-PLUS-PPO
TPATPA-593332026-08-31T21:50:48ZTheresa—Jimenez1982-01-13null-·(875) 690-7220UNKNOWN2263 Bayshore DriveEden PrairieMinnesota··UNKNOWNGRP-9302UNKNOWN
14,474 rows, page 234 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:56.335Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty