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-52503 2026-08-04T05:05:04ZGrace······Kennedy02/07/52NULL•••-••-9901-UNKNOWN3820 Indian School Road··FresnoCA93754N/AUNKNOWN
TPATPA-535502026-07-12T16:52:38ZLycnh, Virginia····—1950-12-07····•••-••-0662953-762-1544N/A2636 Ocean AvenueTUCSONAZ85728··UNKNOWNNULL
TPATPA-563902026-06-24T16:19:43Zsandra—guzman1941-03-22UHC-31025-05—309.940.3596—1098 Central AvenueCHANDLERAZ85241GRP-8851-
TPATPA-560442026-08-02T03:51:21ZBradley, Aizha——1973-12-24UNKNOWN•••-••-5700N/AUNKNOWN6799 Spring StreetFresnoCA93750—SELECT-EPO
TPATPA-513022026-02-04T02:39:03ZARJN··KIM1946-10-17-UNKNOWNNULL—8237 Meadow LnNASHVILLETN37291GRP-7030UNKNOWN
TPATPA-585172026-07-22T15:27:07ZKayla—Grant1/16/1939··———-3675 Market StreetGlendaleAZ85327··GRP-0792—
TPATPA-634172026-03-04T04:06:12ZJack··—Vasquez1944-12-20——5049181456john.vasquez@outlook.com8102 Meadow LnTampaFL33662——
TPATPA-602532026-06-25T05:03:18ZDot—Phillips1989-06-10null—7893481548NULL701 Sunset BoulevardSAN ANTONIOTX78280N/A—
TPATPA-577002026-03-20T10:05:44Z Nicholas··—Montgomery1976-12-24N/A•••-••-9889274-721-7289UNKNOWN8660 Baseline RoadSan AntonioTexas78250-2360N/ASELECT-EPO
TPATPA-619232026-02-23T01:48:48Zyoung—ruth·2000-10-28-•••-••-091416558933083NULL335 DESERT SKY BLVDGilbertAZ85226··—
TPATPA-50142 2026-02-19T23:03:28ZRUSSELL—DELGADO1987-05-25nullN/A—russell.delgado61@proton.me6154 CHURCH STREETNashville·TN37221GRP-8643··—
TPATPA-50727 2026-02-27T12:59:06ZDonald G—Ross09-12-1996UNKNOWN•••-••-5584—UNKNOWN223 INDIAN SCHOOL RDCHARLOTTENC28201GRP-2032—
TPATPA-569892026-06-27T00:18:08ZNATHAN—ESTRADA·02-10-1946UHC-05405-17•••-••-79705078249746—5744 Washington StreetJacksonvilleFL32273-0493GRP-3098·SELECT-EPO
TPATPA-584452026-10-06T22:48:40ZRoger—Palmer·1996-09-07N/AUNKNOWNUNKNOWN—8924 SAGE COURTNashvilleTN37251GRP-1804NULL
TPATPA-516242026-08-08T06:54:13ZKathryn—Wang··2007-01-19UNKNOWN•••-••-2472-—7432 MOUNTAIN VIEW DRIVEChandlerAZ85216-6763N/AUNKNOWN··
TPATPA-515852026-03-24T17:46:51ZEvelyn—·Ray1941-10-09null—(231) 329-0812evelyn.ray@proton.me1967 CAMELBACK ROADEden PrairieMN55330GRP-1586MEDICARE-ADV-B
TPATPA-575552026-06-06T23:55:57ZLUCIA—WHITE18-07-1991————4563 Lincoln WaySacramentoCA··95853N/ACORE-HMO
TPATPA-639122026-09-13T19:06:38ZBrian—Fox21-05-1940-•••-••-8110+1 577 904 5222UNKNOWN—NULL—N/AGRP-2872OPTIONS-PPO
TPATPA-581272026-04-04T14:11:10ZJoyce—Hernandez2005-09-21-—-JOYCE.HERNANDEZ@OUTLOOK.COM9781 River RoadEDEN PRAIRIEMN55319——
TPATPA-605802026-08-05T01:40:41ZSILVA—JERRYOct 15, 1958-UNKNOWN·9442196523UNKNOWNN/A-NULL-NULL—
TPATPA-603962026-07-15T16:21:53ZAUSTIN··—HARVEY2/2/1988--(620) 301-4517·UNKNOWN8260 Main StDenverCO80245—MEDICARE-ADV-B
TPATPA-563852026-09-24T16:50:04ZKATHRYN—CHAVEZ1983-04-09—•••-••-0708(491) 568-1277UNKNOWN8913 Jefferson Avenue #789MINNEAPOLISMN55454GRP-0350MEDICARE-ADV-B
TPATPA-621562026-01-18T00:15:15ZSmith, Linda——14-12-1960UHC-42244-14-9089252938—6026 Indian School RoadTampaFL33609-6624nullUNKNOWN
TPATPA-603562026-07-20T18:39:22ZEugeen—Harper1961-01-04-UNKNOWN—N/ANULL—·N/AnullGRP-9375null
TPATPA-550292026-09-02T12:18:24Z Ana—Mendoza08-01-1996NULL•••-••-9040918-820-6065—2269 Bayshore DriveSeattleWA98162··N/A-
TPATPA-617442026-06-18T05:00:13ZBarbara··Chen1975-12-11··UNKNOWNnull——454 Spring StSACRAMENTOCA95803·GRP-3127null
TPATPA-621512026-07-04T19:07:53ZBEVERLY G.—SANTOS1984-03-21UNKNOWN•••-••-9950····—7505 Ocean AveFresnoCA93736GRP-8593CORE-HMO
TPATPA-527762026-07-25T15:10:19ZArjun—SandersMay 25, 1961—N/A····-1118 Oak StreetMiamiFL33190GRP-0934—
TPATPA-530392026-01-12T21:15:01ZANNA—·EVANS20050106—NULL··488-775-1985··anna.evans91@hotmail.comNULL—null—-—
TPATPA-587102026-05-17T08:37:59ZJuan—FowlerSep 11, 2002-—·NULL—196 Cedar LnSan AntonioTX78273-0600·GRP-0701OPTIONS-PPO
TPATPA-637592026-07-12T11:26:05ZCastillo, Paul——1988-01-11-NULL735-493-3532N/A5161 Mountain View DriveTUCSONArizona85794GRP-0475··NULL
TPATPA-553252026-08-30T02:07:20ZPhilipPBanks1949-01-18··—UNKNOWN-9150 RIDGE ROAD·MesaAZ85232NULL·UNKNOWN
TPATPA-528132026-09-04T07:46:04ZELIJAH····WEST19671205null•••-••-96265399264164elijah.west@hotmail.com···1172 Mesa DriveTampaFL··33658NULL-
TPATPA-533702026-01-02T11:02:47ZVALENTINA—PRICCE··4/24/2004—-(647) 720-9931—9812 Meadow Ln·PhoenixAZ85032UNKNOWNUNKNOWN
TPATPA-557122026-03-02T06:22:04ZSean—Schmidt03/08/1942UNKNOWN-NULL—1550 PINE DRPlanoTX·75048null—
TPATPA-507442026-08-09T10:59:55ZPriyaEFuller1954-10-08·N/A•••-••-7989—N/A3466 Bayshore DrEden PrairieMN55384GRP-4722—
TPATPA-515802026-04-19T16:56:37ZElijah—Stephens1960-12-16N/AN/A——6193 Cedar Ln Apt 5Eden PrairieMN55393-8714—null
TPATPA-57564 2026-05-30T11:32:25ZSANTIAGO—FERGUSONDec 15, 1970N/A·null646-683-3057null2728 Hillcrest Road·FRESNOCA93741GRP-5539NULL
TPA TPA-541692026-03-03T03:09:03Z DONALD—VAZQUEZ1960-05-26NULL-355-612-6829—1869 MESA DRScottsdaleAZ85210GRP-2910null
TPA TPA-547172026-06-05T10:25:58Z·ASHLEY····HAYAS·1970-03-20-•••-••-0582—null2850 Valley View DriveChandlerAZ85230N/AUNKNOWN
TPATPA-582312026-08-23T00:11:57ZRandy—Burke1948-05-15N/A•••-••-2991—NULL1425 River Road·MinneapolisMN55464··MEDICARE-ADV-B
TPATPA-638552026-09-22T12:05:41ZLOGAN—PORTER··1973-10-07——3147183504logan.porter@aol.com1265 Valley View DriveMesaAZ··85208GRP-2147OPTIONS-PPO
TPATPA-584552026-04-29T10:19:45ZEthan—Morris2002-06-13-•••-••-3515NULL··N/A··1385 Mountain View DrMESAAZ85269-··CHOICE-PLUS-PPO
TPATPA-622682026-02-22T02:42:57ZJeffrey—Harvey1969-10-15NULL—·13353580723-·N/AUNKNOWNN/ANULLUNKNOWNCHOICE-PLUS-PPO
TPATPA-567702026-05-05T08:01:23Z Seean—Li1947-11-05NULL•••-••-5656N/AN/A8935 Cedar LnGilbertAZ85289N/A··MEDICARE-ADV-B
TPATPA-546202026-09-30T07:48:06ZJANET—WOOD1942-01-24NULL•••-••-6279—N/A230 Ocean AvePhoenixAZ85070NULLnull
TPATPA-550882026-01-14T22:46:52ZKathleen—Robertson19750513NULLUNKNOWN3522814693··UNKNOWN7407 Pine DriveTampaFL33685GRP-6444-
TPATPA-574002026-02-14T19:22:34ZKEITH—BURKE1951-08-19N/A•••-••-2422nullN/A9829 DESERT SKY BOULEVARDMiamiFL··33192GRP-7324NAVIGATE-HMO
TPATPA-637302026-06-01T20:43:03ZSHARON—LEWIS1982-06-20-··—null7383 CENTRAL AVEHoustonTX——NAVIGATE-HMO
TPATPA-525432026-02-14T13:42:01ZDiego—Hanson2000-08-03null·UNKNOWNUNKNOWNnull3400 Broadway·MESAAZ85275GRP-1431—
14,474 rows, page 189 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:53.140Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty