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-627352026-08-22T00:26:45ZRoger—Ross··2000-12-27UHC-76258-52N/A-null··NULLUNKNOWNnullN/A—N/A
TPATPA-600292026-10-14T20:35:37ZSAMUEL—GARCIA2006-02-21··-·null7815273672—6719 Pine DrMinneapolisMN55443-··N/A
TPATPA-503312026-05-11T15:03:30ZMorales, Douglas——1952-08-19UHC-93164-60-null————NULLGRP-9405MEDICARE-ADV-B
TPATPA-574352026-02-25T13:04:26ZBEVERLY··—BANNETT14-08-1948UHC-99014-61•••-••-3533—BEVERLY.BENNETT@GMAIL.COM··4158 INDIAN SCHOOL ROADDENVERCO80291-9604GRP-5566—
TPATPA-568032026-09-11T08:01:55ZPAUL··LEWIS1972-03-11null—7386045paul.lewis89@outlook.com8134 Harbor BlvdHoustonTX77003——
TPATPA-596442026-08-08T13:47:08Z·Philip—Tucker1951-04-02N/A—N/Anull8795 Spring St·GLENDALEAZ·85359—MEDICARE-ADV-B
TPATPA-619582026-06-09T11:50:40ZSOFIAU.··ANDREWS1996-02-17—·N/Anull—377 Spring Street #447CharlotteNorth Carolina28218UNKNOWN····
TPATPA-593272026-04-01T08:25:58ZWILLIE—ELLIS1995-03-19nullnull15866888363—8597 Cedar Ln··SAN DIEGOCA92186-2309--
TPATPA-540422026-05-23T02:03:19ZJasonKGordon1952-06-05—N/A227.730.6812NULL8596 Desert Sky BoulevardPlanoTX75052··UNKNOWNUNKNOWN
TPATPA-644212026-03-12T07:30:07ZPatrick··Jacobs1952-01-27NULL•••-••-2315nullpatrick.jacobs@gmail.com2015 SAGE COURT #158Las VegasNVUNKNOWNGRP-8749—
TPATPA-594842026-10-08T22:55:45ZAndrea—Foster1965-03-26UNKNOWN··—-4448 Cedar LnNashvilleTN·37237GRP-1693·N/A
TPATPA-542402026-01-30T09:10:49ZBRRYAN—MARTINEZ10/21/2008UNKNOWN•••-••-43738102198850UNKNOWN4682 Washington StreetORLANDOFL—null-
TPATPA-631952026-06-24T05:15:14ZBRENDA—HENDERSON1966-09-27UHC-12811-60—-··4171 Ridge RoadPlanoTX75050-·MEDICARE-ADV-B
TPATPA-636362026-05-02T07:48:22ZWillie····Holmes1977-06-04null——WILLIE.HOLMES47@OUTLOOK.COM6486 PALM DRIVEPhoenixArizona85091——
TPATPA-545372026-07-08T03:20:49ZJEFFREY—MENDEZ05/03/1967—•••-••-03204768792—5599 SAGE COURTDENVERCO80246N/AOPTIONS-PPO
TPATPA-539942026-05-07T14:31:45ZJoseph—Lewis·01/13/46N/A•••-••-5713—N/A2854 CAMELBACK RDLas VegasNV89171GRP-4313N/A
TPATPA-605442026-10-09T16:34:55ZJason—Burns1975-12-26-··—NULL-5434 Camelback RdEden PrairieMN55310——
TPATPA-546372026-01-02T17:20:12Zcharlotte—gordon08/12/1943-•••-••-0576·509.880.6150-9685 ELM STPlanoTexas··75038GRP-9940—
TPATPA-549442026-10-18T19:13:13ZEveyln—Castro1965-08-12UNKNOWN-—evelyn.castro84@icloud.com··1347 Ocean AvenueColumbus··OH43286-2465GRP-6806N/A
TPATPA-619612026-02-11T21:24:42ZJOAN—ROSS1959-10-25··——UNKNOWNjoan.ross10@icloud.com··UNKNOWN··———MEDICARE-ADV-B··
TPATPA-539572026-05-29T15:16:36ZFowler, Jacob····—1940-06-26UNKNOWN—-—·2147 Valley View DriveMiamiFL33140GRP-4604NULL
TPATPA-552802026-03-30T03:39:27ZAnna—Medina1972-05-06N/AUNKNOWN(843) 741-4462NULL7443 Desert Sky BlvdTampaFL33676GRP-1134MEDICARE-ADV-B
TPATPA-629332026-03-20T12:32:50ZWang, Tom——·1942-08-14UNKNOWNnullN/AN/A1523 Sage CtPhoenixAZ85029——
TPATPA-522092026-01-01T17:56:21ZGREGORYCWILLIS1942-12-18-•••-••-7932N/Anull7682 Main StreetMesaAZ85295GRP-1600NAVIGATE-HMO··
TPATPA-542042026-04-12T02:29:44ZJessica·····Grant2004-10-17NULL•••-••-2801—-—·····nullnull——
TPA TPA-541832026-09-28T13:23:07ZMartha····Singh1999-11-70NULL•••-••-8580—N/A3687 PINE DRIVEJACKSONVILLEFL32278—·medicare-adv-b
TPATPA-627572026-02-16T04:11:54ZDONNA—RUSSELL1981-09-22-······nullDONNA.RUSSELL@GMAIL.COM··8815 Sunset BlvdSeattleWA98122-9476N/AN/A··
TPATPA-54189 2026-08-08T03:47:04ZBruceAAdams0825-19-34UHC-22515-20··UNKNOWNUNKNOWN1940 Grand AveAustinTX78733GRP-1488—
TPATPA-623282026-09-30T04:33:10ZKevin—Fernandez19710507——————null—UNKNOWN—
TPATPA-604582026-03-10T01:45:49ZAISHA—CARLSONJun 4, 1971NULL—NULLN/AUNKNOWNNULLNULLN/A—CHOICE-PLUS-PPO
TPATPA-546572026-06-07T10:00:24ZCampbell—Keith05/19/1962—N/A(484) 398-8297-··5441 Meadow LaneNashvilleTN37234-3035GRP-2261-
TPATPA-553722026-08-29T06:36:26ZStephanie—Ruiz9199-01-26—•••-••-5130null·null1752 Main StreetEDEN PRAIRIEMN55329-6912—CORE-HMO
TPATPA-625122026-04-22T05:57:38ZPETER—·SHAW03-03-1945N/AUNKNOWNUNKNOWN—4193 Baseline RoadCharlotteNC28297-2927GRP-8430—
TPATPA-559762026-05-10T13:43:06Z·ARJUN—REID02/05/1965—NULL——UNKNOWNUNKNOWNNULLnullGRP-9247-
TPATPA-570642026-10-15T16:50:01Z·JERRYISALAZAR10-01-1990——UNKNOWNNULL6001 RIDGE RDSan AntonioTX78219nullUNKNOWN
TPATPA-593672026-08-04T09:36:47ZJerryOMcDonald1969-01-06null——-9110 Jefferson AvenueSAN DIEGOca92160NULLUNKNOWN
TPATPA-617202026-01-11T16:52:07ZBrenda—Hughes·1948-10-21—NULL7505772-8393 Market StreetScottsdaleAZ85260··UNKNOWNNAVIGATE-HMO
TPATPA-575252026-01-28T04:34:10ZColeman, EvelynP.—1987-02-14—-2359681318··—1338 Ridge Road #465GilbertAZ85253GRP-1010UNKNOWN
TPATPA-558412026-01-22T21:08:22ZJONATHAN—WANG1939-08-09-N/A—jonathan.wang@gmail.com4103 Mountain View DrOrlandoFL32857-0422-·OPTIONS-PPO
TPATPA-637392026-06-20T07:10:24ZElijah—Owens1953-05-21UNKNOWN•••-••-6522(457) 576-1718—8030 Cedar LaneMESA·AZ·85278—UNKNOWN
TPATPA-567652026-02-15T01:47:53ZKeith—Williamson1976-03-27UNKNOWN··—(300) 877-7832—1299 VALLEY VIEW DRPhoenixAZ85015NULL—
TPATPA-642442026-01-15T08:26:23ZAlexander—Adams1944-06-04UHC-12301-91•••-••-2722N/Aalexander.adams45@proton.me——NULLUNKNOWNGRP-4625·SELECT-EPO
TPATPA-534732026-05-09T09:20:34Z Tyler—Long1981-04-15——(417) 517-7821-277 Jefferson AvenueDallasTX—-NULL
TPATPA-503052026-03-23T21:02:30ZMARIANA—BERRY1988-03-20——-N/A4544 Main St Apt 30DenverCO80294nullnull
TPATPA-522922026-05-28T19:39:31ZHEATHER—WILLIS1980-05-01UNKNOWN•••-••-10572907273339—UNKNOWNUNKNOWNUNKNOWNN/AGRP-6535MEDICARE-ADV-B··
TPATPA-538782026-01-19T00:06:52ZCHRISTIAN—·RAY2008-91-47UNKNOWN•••-••-60617582319477null5974 Grand AveTampaFL33646GRP-6780UNKNOWN
TPATPA-577142026-03-19T04:33:19ZRaymond—Fox2000-10-21——-raymond.fox48@proton.me7089 Mesa DrEden PrairieMN55306GRP-0308-··
TPATPA-501302026-08-29T07:57:53ZDANIELLE—OLIVER1947-05-28N/ANULLNULL-4173 Maple AveDallas··Texas75225GRP-2164—
TPATPA-551972026-05-28T00:51:43ZzacharyZsimpson··1964-12-08—null——5711 CHURCH STREETMiamiFL··33183··——
TPA TPA-598832026-04-28T10:11:42ZDANIELLE··MARTINEZJul 22, 2004null•••-••-4055-—8733 DESERT SKY BLVDORLANDOFlorida32815··GRP-5428null
14,474 rows, page 265 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:43:03.404Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty