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-517932026-02-23T23:37:16ZCamilaDAlvarado··Jul 19, 1977-—NULLcamila.alvarado@aol.com2575 Park PlaceCharlotteNC28201GRP-0380··
TPATPA-516532026-04-10T04:17:14ZFRANCESEJACOBS1986-09-08N/A—14924269107—9439 Baseline RdAtlantaGA30373GRP-9791-
TPATPA-580502026-03-31T14:51:11ZEdward—Peterson5/18/1965UHC-86064-90•••-••-7703(254) 788-0228EDWARD.PETERSON13@GMAIL.COM1428 Maple AveOrlandoFL32889—-
TPATPA-559582026-07-19T01:17:11ZAnn—Simpson1984-06-28NULL··—5474210818ann.simpson@gmail.com9591 Camelback RdAtlantaGA30397NULLN/A
TPATPA-536512026-05-02T09:19:22ZEstrada, Susn——02-10-1995nullUNKNOWN—susan.estrada@gmail.com4654 Bayshore DrGilbert··AZ85263UNKNOWNUNKNOWN
TPATPA-549892026-08-19T16:56:12ZNicholas—Sanders1987-06-19NULL•••-••-9392-·UNKNOWN7213 Pine Dr··Houston··TX77036GRP-8393MEDICARE-ADV-B··
TPATPA-632572026-08-09T13:51:19ZSHARONBDIAZJul 25, 1957-N/ANULLUNKNOWN4651 Sage CtNashvilleTN37266GRP-7295null
TPATPA-644222026-04-01T22:57:50ZMARY—MCCOY02/19/02--UNKNOWN—52 HARBOR BOULEVARDPHOENIX··AZ··85079GRP-0588—
TPATPA-629992026-01-28T13:19:53ZCarter, Theresa——19681213—•••-••-9945—UNKNOWN4683 Palm Drive··CHANDLERAZ85262NULLnull
TPATPA-510052026-02-03T10:53:11Zmatt—allen07/11/89UNKNOWN•••-••-2517(230) 651-5265null558 Forest AveEden PrairieMN55396null-
TPATPA-610212026-10-09T21:10:05ZASHA—MEDINA1999-02-06N/Anullnull-7802 Ocean Ave #473San AntonioTX78270—N/A
TPATPA-548382026-09-23T06:51:03Zbarbara—espinoza10/25/2001··--N/Abarbara.espinoza@proton.me4396 VALLEY VIEW DRTempeAZ85224GRP-9236—
TPATPA-560142026-07-19T18:23:36Z Walter—Scott19730711·nullNULL9597036053NULL·6354 CANYON RDLAS VEGASNV89166nullUNKNOWN
TPATPA-505472026-02-23T05:32:23ZALBERTP·CLAARK1977-05-15UNKNOWNN/A(886) 253-2948NULL7039 APACHE BOULEVARDEDEN PRAIRIEMN55330GRP-6361—
TPATPA-578072026-03-23T04:35:35Z George—Fernandez1972-09-21UHC-36073-65•••-••-7609—UNKNOWN7541 Park PlaceColumbusOH··43244null··—
TPATPA-560962026-09-27T20:26:15ZVINCENT··BERRY04/10/1966NULL-357-539-3670-8119 Market St··MiamiFL33187NULL··NAVIGATE-HMO
TPA TPA-574712026-06-16T16:19:40ZAhmed—Singh1979-01-17—nullN/AAHMED.SINGH1@ICLOUD.COM1917 Grand Ave··MiamiFLUNKNOWN——
TPATPA-634502026-03-12T16:41:48ZRalph—GarciaApr 22, 1945nullN/AN/A··-2592 Forest Avenue #444MiamiFL33115-7528——
TPATPA-519842026-01-19T19:44:23ZBrenda—Collins19810504null•••-••-0845217-968-8368NULL4472 BAYSHORE DRIVEGILBERTAZ85208—SELECT-EPO
TPATPA-545542026-06-02T15:16:40ZNathanERamirez1594-03-17—•••-••-2168N/Anathan.ramirez@icloud.com6336 Canyon RoadColumbusOH43227··UNKNOWNUNKNOWN
TPATPA-608422026-09-11T13:07:38ZEugene—Nichols3/11/1980UHC-77317-26——NULL1911 Palm DrPhoenixAZ85031—NULL
TPATPA-584872026-04-24T08:26:44ZKEVIN—ROBERTS19620324·····null——4395 MAPLE AVELas VegasNV89156GRP-1218—
TPATPA-585922026-10-06T17:31:35Z·Gerald—Gerrero1960-07-06UNKNOWN··—8975114249··—9677 SUNSET BOULEVARDLAS VEGASNV89135GRP-6651choice-plus-ppo
TPATPA-610442026-09-09T05:09:03ZKyle—Miller9172-10-17UNKNOWN·null—kyle.miller@yahoo.com436 Union StreetMINNEAPOLISMN55458NULL—
TPATPA-505742026-07-16T21:18:41Z·ANDREW—FIELDS03/23/1995—•••-••-1926—NULL3129 Main StJACKSONVILLEFL··32261—CORE-HMO
TPATPA-516002026-06-15T05:16:59ZHarris, IsabellaN—Jan 27, 1996—•••-••-79544905638104UNKNOWN3768 Mesa DriveEDEN PRAIRIEMinnesota55346GRP-3586-
TPATPA-560662026-09-22T22:54:22ZAlice, Moore——1961-07-01N/A··null+1 261 582 2785—6180 LAKE VIEW RDDenverCO80227-8906··-
TPATPA-562692026-02-19T06:04:56ZFrank—Patel19730225··——NULL755 Jefferson AveColumbusOH43208—MEDICARE-ADV-B
TPATPA-511472026-07-04T14:12:26ZKENNETH—PERKINS·1996-07-07null•••-••-19479846081911—UNKNOWN·null—nullN/AN/A
TPATPA-546722026-07-21T09:41:16ZHiroshi—Lynch10/25/1965null•••-••-14026435216019hiroshi.lynch@aol.com··581 Cedar LnTampaFL33626null··
TPATPA-569082026-10-07T19:44:54Z·CHRISTINAWPIERCE1964-06-24null-UNKNOWN—4130 Maple Avenue·Los AngelesCA90060—-
TPATPA-500202026-07-10T18:14:21Z ·Jack—Sims··19881207UHC-53521-04null—·null580 Lincoln Way #909Gilbertaz85258GRP-6324—
TPATPA-546262026-03-03T15:42:46Z·Sean—Silva19590503UHC-15160-88—3356525UNKNOWN7819 Church StChandlerAZ85221·GRP-0782—
TPATPA-606422026-07-14T23:24:22ZBRIANNROGERS1954-09-25NULLnullN/AN/A2114 MAPLE AVEGLENDALEAZ··85367—null
TPATPA-526032026-01-13T19:17:35ZAnna··Gonzalez1984-04-25N/A•••-••-8087—UNKNOWN425 ELM STDenverCO·80241GRP-4171OPTIONS-PPO
TPATPA-532852026-08-12T01:57:27Z DORIS—MURPY·1953-03-22-UNKNOWN—doris.murphy51@icloud.com9130 LINCOLN WAYTampaFL33687——
TPATPA-579322026-10-15T00:46:36ZArnold, Roger··—20050625—•••-••-2607-N/A2065 Lake View RdDenverCO80213-1321UNKNOWNNULL
TPATPA-514372026-01-11T16:13:18Z·Flores, BeverlyH.—09/02/1948——4573299529··UNKNOWN107 Pine DriveLas VegasNV·89148-—
TPATPA-510762026-04-13T11:51:25ZPETER—SCOTT1950-11-02null•••-••-8572—PETER.SCOTT62@PROTON.ME2722 MESA DRIVEScottsdaleAZ85217NULL—
TPATPA-599592026-05-03T09:49:11ZEdward—Duncan1961-06-25UNKNOWN-854.519.3167—619 MARKET STDENVERCO80280N/Anull
TPA TPA-532102026-03-01T02:01:12ZBRYAN··—BRADLEY1941-10-26UHC1164527-N/AN/A-N/A—·N/AnullMEDICARE-ADV-B
TPATPA-527402026-07-21T17:19:24ZJean····Kelly2007-01-26UHC-07294-32——N/A1655 CEDAR LNCHANDLERAZ85271-NAVIGATE-HMO
TPATPA-502382026-10-17T10:43:34Zmaria—chavez10/15/1999—N/Anull··-3624 Union StreetLas VegasNevada89105nullMEDICARE-ADV-A
TPATPA-507342026-01-24T06:25:52ZArthur—Mason··1975-07-11—•••-••-9442(337) 397-4367NULL5652 Jefferson AveSAN ANTONIOTX78266UNKNOWNCHOICE-PLUS-PPO
TPATPA-630452026-03-28T18:45:35ZJAMES—MITCHELL27-05-1940——--8842 Highland AvenueSacramentoCA95895—UNKNOWN··
TPA TPA-626752026-08-23T08:56:27ZBetty··—Myers2000-12-11N/A·NULL·UNKNOWNUNKNOWN·nullnullnull—··null
TPATPA-570322026-01-28T01:50:58ZColeman, Rachel——19811228—-(660) 953-5067null93 Ocean Ave··JacksonvilleFL32262GRP-1653CORE-HMO
TPATPA-561372026-08-16T12:31:51ZWILLIAM—THOMAS··1963-02-12null—(489) 312-4310WILLIAM.THOMAS@PROTON.ME·6444 RIDGE ROADScottsdaleAZ85280-null
TPA TPA-619382026-08-29T15:46:36ZAisha—Cunningham1996-12-02-—2372707273UNKNOWN764 VALLEY VIEW DRTampaFL33683—CORE-HMO··
TPATPA-538372026-05-09T16:35:58Z RichardQ.··Perkins1996-10-09UHC-20022-04•••-••-7768UNKNOWN·NULL5545 GRAND AVE··JacksonvilleFL32224—MEDICARE-ADV-A
14,474 rows, page 116 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:43.638Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty