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-588712026-06-14T22:03:01ZTimothyY.MorenoMay 2, 2005—NULLnullnull700 Baseline RdTempeAZ85265GRP-4500—
TPA TPA-521602026-06-11T01:23:54ZAisha—Berry1976-03-07-——null2814 Oak StCOLUMBUS··OH43226-1920NULL—
TPATPA-597552026-01-13T05:17:48ZBRANDON—JAMES1955-10-27··UNKNOWN•••-••-8843336-645-9875NULL9899 Central AveChandlerArizona85263-0446NULL—
TPA TPA-54346 2026-10-07T18:06:15ZMason—McDonald2003-08-20N/A•••-••-3033—null2210 Cedar LnAtlantaGA30379NULLCHOICE-PLUS-PPO
TPA TPA-624482026-04-05T10:22:50ZDylan—King1938-09-20—•••-••-2124427-649-8907null2534 Market StreetColumbusOhio43275UNKNOWNnull
TPATPA-506542026-10-03T10:53:40ZBeverlyFPerez1958-08-10—null(792) 675-4472null-··UNKNOWNnull—CORE-HMO
TPATPA-52456 2026-06-30T17:07:16ZRAYMOND—BURNS1943-08-03—UNKNOWNN/Anull·2658 Hillcrest RoadAustinTX78700NULLCHOICE-PLUS-PPO
TPATPA-55266 2026-06-07T13:00:28ZHEATHER—GRAAHM1970-05-06··•••-••-3482544-624-3321····3412 MOUNTAIN VIEW DRIVE··HOUSTONTX77073—SELECT-EPO
TPATPA-513842026-05-10T01:58:54ZVINCENT—BROOKS1946-11-09-•••-••-9493NULL—1195 Ridge RoadEden Prairiemn55300N/ANAVIGATE-HMO
TPATPA-579942026-04-25T16:09:05ZPeterson, VictoriaI—20040317———NULL3004 VALLEY VIEW DRDallasTexas75229UNKNOWN—
TPA TPA-585372026-05-20T05:09:10ZPriya—Murrya1978-02-02———-995 Washington StreetMiamiFL33156UNKNOWNnull··
TPATPA-595082026-03-24T18:50:35ZMARK······BRYANT1993-06-04—-N/Amark.bryant1@icloud.com—-nullUNKNOWNN/A—
TPATPA-563972026-01-16T17:32:57ZLAURA—WEAVER1983-03-21N/A····831-313-1212N/A5819 RIDGE ROAD #864Charlottenc··28207null—
TPATPA-561732026-09-19T19:25:04ZPhilip—Gonzalez1948-06-04-··•••-••-3087————-···null-
TPATPA-567582026-05-19T17:38:29ZDouglas—Mattheews26-05-1946null•••-••-1529NULL-3945 BroadwayPLANOTX··75066—CORE-HMO
TPATPA-537912026-03-19T06:33:07ZSusan—Reynolds1966-09-20NULL······UNKNOWNsusan.reynolds6@aol.com2323 Camelback Road··Las VegasNevada·89115GRP-3156—
TPATPA-519252026-07-02T04:50:12ZOrtega, GloriaV—2007-02-20··-UNKNOWN625-664-2450—4707 HIGHLAND AVETEMPEaz85252-7861UNKNOWN-
TPATPA-644522026-08-25T08:13:14ZSEAN—GARDNER1976-11-13—•••-••-9180—NULL6474 Main StAtlantaGA30303—CORE-HMO
TPATPA-572742026-04-03T08:12:23ZMARGARET—TUCKER··1992-08-05—NULL—-··3606 Mesa DrSan DiegoCA92146-N/A
TPATPA-551232026-04-22T22:44:38ZAmanda··—Allen1954-10-20————·4736 Lake View RdSan DiegoCA92196GRP-3617··NAVIGATE-HMO
TPATPA-578162026-08-03T07:27:46Zcamila—andrews·2/8/1983UHC-90086-43NULL-camila.andrews91@gmail.com——·N/A—N/A—
TPATPA-614442026-08-14T21:35:20ZSUSAN—PERRY2003-07-18UHC-84096-55•••-••-8474+1 423 740 5827··NULLNULL··—nullOPTIONS-PPO
TPATPA-615892026-01-15T23:23:41ZArnold, Nicholas——1982-05-18null•••-••-4873··—6306 Indian School RoadGilbertAZ85226null—
TPATPA-60467 2026-04-26T05:05:56ZKeith—Bradley11/17/1990null•••-••-7990—keith.bradley47@icloud.com8921 Cedar LnJacksonvilleFL32227GRP-8201—
TPATPA-587372026-07-15T21:50:43ZBrian—Hart1972-08-20—NULL(638) 512-6569—1729 Highland Avenue Apt 26··San AntonioTX·78258--
TPATPA-579602026-03-17T01:07:03ZJanet—Dixon9/8/2002UHC-87234-89•••-••-5787N/A··NULL··6173 JEFFERSON AVENUEJacksonvilleFL32229GRP-9356-
TPATPA-551962026-07-22T20:48:30ZZachary—Simpson1964-12-08-•••-••-8045—N/A5711 CHURCH STREET·Miamifl33183-8613GRP-8021—
TPATPA-53504 2026-08-01T15:56:25Z———1963-09-01UHC-98430-64NULL(774) 645-4505UNKNOWNUNKNOWNN/A····—-N/A
TPATPA-617912026-04-04T14:39:09ZJose—Harvey1991-04-12NULLN/A5640448NULL8461 Elm StreetSAN DIEGOCA92136NULLMEDICARE-ADV-B
TPATPA-520972026-02-04T04:32:25ZJASON··—GOMEZ1945-04-03—-(376) 378-0539jason.gomez38@outlook.com6458 PARK PLACEDenverCO·80233-6806—N/A
TPATPA-522042026-04-21T17:16:06ZJoyceQGibson19840410-———2946 Ocean AveLas VegasNV89113-0124——
TPATPA-579272026-03-25T03:58:03ZJosephURomero1989-01-14—N/AnullNULLUNKNOWNNULLNULLUNKNOWNGRP-6076·NAVIGATE-HMO
TPATPA-585852026-01-02T17:19:58ZWillie··Garcia09-05-1939N/A•••-••-05332969080—·2073 CHURCH STSACRAMENTOCAUNKNOWNGRP-3309SELECT-EPO
TPATPA-535092026-07-03T18:29:37ZLawrence—Diaz1938-06-03—•••-••-984319309440897··lawrence.diaz@gmail.com———·N/AGRP-7335MEDICARE-ADV-A
TPATPA-56067 2026-09-25T10:00:33ZAlice—Mooe1961-07-01—··—null6180 Lake View RdDenver···CO80227UNKNOWNCORE-HMO··
TPATPA-531552026-07-02T10:41:29ZHenry··—RobertsOct 21, 1969——(685) 607-8523—7955 Sage CourtCHANDLERAZ·NULLN/ASELECT-EPO
TPATPA-505092026-06-13T00:54:53ZDONNA—WEAVER1983-01-05-N/AN/A-8693 Desert Sky BoulevardChandlerAZ85299GRP-6812NULL
TPATPA-555222026-03-04T01:20:44ZCHARLOTTEF.BRYENT2002-04-42UHC-22651-59NULLNULL—null-—-GRP-1336-
TPATPA-61353 2026-03-27T04:07:18Z·Kathryn—Jordan1963-06-15—•••-••-2657—KATHRYN.JORDAN42@OUTLOOK.COM5080 Sunset BlvdCHARLOTTENorth Carolina28215GRP-3231·SELECT-EPO
TPATPA-560782026-06-08T14:32:00ZTyler—GardnerJun 13, 1995nullUNKNOWN6889289513·N/A—NULLnullnullNULLUNKNOWN··
TPATPA-549862026-08-19T09:47:42ZOlivia—Stewart01/24/1941—•••-••-4751—null·2403 Valley View DrGilbertAZ85278GRP-4721·CHOICE-PLUS-PPO
TPATPA-572512026-02-17T05:24:28ZJanet—Dean1989-12-07UNKNOWNUNKNOWN+1 954 817 5249UNKNOWN8717 Palm DrivePhoenixAZ85037··——
TPA TPA-519072026-03-27T15:25:46Z DENISEL.HOLMESMar 12, 1964UNKNOWN•••-••-7534652-392-4269UNKNOWN8668 CENTRAL AVENUEGilbert··AZ85264GRP-2857—
TPATPA-547062026-05-15T09:10:56ZMunoz, Jose——1982-11-23—nullUNKNOWN··N/A7787 MESA DRTampaFL33665GRP-6533·null
TPATPA-545912026-09-11T18:25:56ZMarianaEHerrera1979-09-25N/A····(301) 698-9214-4823 Mountain View DriveSacramentoCA95863—SELECT-EPO
TPATPA-51464 2026-08-04T10:09:30ZGary—Austin04/24/1949null-+1 307 949 9616—2402 Ridge RdAustinTexas78735··UNKNOWNMEDICARE-ADV-A
TPATPA-542052026-10-15T01:36:07ZKevyn—Willis03/08/65····—3349820388kevin.willis90@hotmail.com3862 WASHINGTON STREETDenverCO··80231—NAVIGATE-HMO
TPATPA-569952026-04-18T05:20:40ZJesse—Keley1954-06-03—N/A··—N/A6169 CAMELBACK RDSan AntonioTX78217GRP-4825-
TPATPA-636482026-06-07T07:21:11Zdiana—cruz5/15/1984—nullN/ADIANA.CRUZ@HOTMAIL.COM2273 MAIN STOrlandoFL32808GRP-4448NAVIGATE-HMO
TPATPA-541562026-03-06T06:35:51ZROY—CRAWFORD1991-07-27null—UNKNOWNroy.crawford@yahoo.com6673 Oak StSeattleWashington98175GRP-7045·N/A
14,474 rows, page 131 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.098Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty