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-53271 2026-02-03T09:24:09Znicole—perez1957-11-16UHC-65117-46-·nullnull4434 INDIAN SCHOOL ROADSAN DIEGOCA92169·GRP-4595NAVIGATE-HMO
TPATPA-575312026-09-21T15:23:23ZGary—Carr··05/06/57·UHC-25634-04—UNKNOWNnull9019 Washington StreetSCOTTSDALEAZ85209GRP-1009N/A
TPATPA-635822026-08-27T21:03:41ZJesse—Bryant1948-07-25-—5714282738N/A·9551 Sunset Blvd #549Los AngelesCA90089nullCORE-HMO
TPATPA-591902026-02-07T20:17:00ZMichelleR.Carpenter1960-07-18null—(654) 511-1132UNKNOWN8637 Ocean Ave··CHANDLER·AZ85278null-
TPATPA-588912026-07-16T09:24:16ZweiB.miller1949-03-27UNKNOWN•••-••-8601UNKNOWNN/A3062 CAMELBACK ROADPhoenixAZ85010GRP-6579CORE-HMO
TPATPA-582832026-02-16T13:42:03ZStephen—Alexander1977-05-25—•••-••-0669916.563.6371null1435 INDIAN SCHOOL ROAD·Austin·TX78701N/A··
TPATPA-601312026-10-15T14:45:11Zralph—washington7/6/1977N/A—N/A—3498 MEADOW LANEPlanoTX·75077·NULL··
TPATPA-541102026-09-16T00:42:54ZDOUGLAS—·ROBINSON11/27/1974null—·542-681-9497····9031 APACHE BOULEVARDNASHVILLETN37242GRP-2881MEDICARE-ADV-B
TPATPA-608992026-03-22T18:44:17ZMARILYN—GARRETT2001-04-05NULL—+1 505 910 5727—9623 Hillcrest RdCharlotte·NC28267—N/A
TPATPA-630102026-05-25T00:02:26ZRogers, Austin——1986-07-06—•••-••-0929—UNKNOWN7743 SAGE COURTSAN ANTONIOTX78273-null
TPATPA-576622026-08-13T09:21:02ZAustin·CRichards1989-08-07··NULL•••-••-1655NULL-9292 FOREST AVENUESeattleWA98168-1048UNKNOWN—
TPATPA-53029 2026-03-15T03:10:20ZJOSHUA—WHITE1984-09-10N/ANULLnull—8849 Harbor BlvdTempeAZ85238NULL—
TPATPA-586042026-08-15T21:57:49ZPhilip—·Ferguson1991-08-82N/A•••-••-5834348-267-0324PHILIP.FERGUSON74@PROTON.ME8344 Park PlaceHoustonTX77036-UNKNOWN
TPATPA-540312026-02-12T15:58:23ZAishaCBoyd01-06-1976UNKNOWN•••-••-0224null-418 Palm DriveMiamiFL33165UNKNOWN·SELECT-EPO
TPATPA-518712026-04-04T18:04:39ZJoseph—Porter1950-10-08UHC-81208-98NULL—NULL6339 VALLEY VIEW DRIVECHANDLERAZ85245UNKNOWN—
TPATPA-601952026-07-04T14:25:22ZBarbara··Simmons1958-11-02—NULL-BARBARA.SIMMONS28@OUTLOOK.COM5646 Indian School RoadLas VegasNV89124——
TPATPA-509802026-09-23T00:46:52ZLUCIA—ESPINOZA1971-11-16—NULLN/AN/A2739 UNION STREETColumbusOH43207—MEDICARE-ADV-B
TPATPA-533852026-08-15T19:32:56Z·MARCUS—JONES1952-02-04——nullmarcus.jones@icloud.com9174 Indian School RoadTampaFL33621·GRP-9962—
TPATPA-575932026-03-22T18:55:36ZMaria—Ryan3/1/1965N/A-·NULLMARIA.RYAN@ICLOUD.COM8437 Lake View RdAtlantaGA30370—CHOICE-PLUS-PPO
TPATPA-523572026-05-15T05:55:08ZMery—Ramirez1961-03-28UNKNOWNnull(684) 620-5137N/A1794 Cedar LnJACKSONVILLEFL32277··NULLCHOICE-PLUS-PPO
TPA TPA-600802026-01-04T15:19:55ZMendoza, Arthur——1978-08-19--—····4435 Sage CtTampaFlorida33615—UNKNOWN
TPATPA-556322026-04-26T07:31:56ZBaker, Camila····—1946-03-09—•••-••-6227900-957-8885··NULL815 Ocean AveLas Vegasnv89195—··
TPATPA-638812026-01-20T04:12:30ZCHRISTINA—MALDONADO1968-01-13UHC-10398-30—(641) 550-0800UNKNOWN7835 GRAND AVENUE Apt 31AUSTIN··Texas78763null—
TPATPA-589012026-03-11T07:42:55ZDiego—Lawrence2005-03-13UHC-68548-08N/A—DIEGO.LAWRENCE91@AOL.COM1001 HILLCREST ROADTempeAZ85203—OPTIONS-PPO
TPATPA-500502026-10-11T19:30:18ZDylaan—Reed1950-04-23N/A—540-981-8923N/A5538 PARK PLACEGILBERTAZ85209—NULL
TPATPA-502282026-02-20T07:30:32Z heather—hawkins1980-04-27·-•••-••-2045null-9203 Church StEden PrairieMN55316—····
TPATPA-583702026-08-19T00:31:56ZLius··—Murphy20-02-1981··UHC0129890··null2797178··LUIS.MURPHY25@AOL.COM299 Sage CtJacksonville··Florida32278nullNAVIGATE-HMO
TPATPA-506112026-09-26T02:24:28ZBanks, ArthurB—1955-09-13—•••-••-4984NULLUNKNOWN5876 BAYSHORE DRSEATTLEWA98111-—
TPATPA-564382026-07-03T02:39:57ZJoshua··Ford1972-90-26UNKNOWN-(477) 436-4619—7167 Camelback RoadTampaFL33641——
TPATPA-613192026-09-25T18:01:48ZMadison—Rse·16-11-1966·nullnull3446203431NULL3811 Bayshore DrScottsdale·AZ85291GRP-2831MEDICARE-ADV-A
TPATPA-561182026-09-09T07:14:22ZCAROL—BURTON02/02/84UNKNOWN··——N/A5385 BROADWAYOrlando·FL32807NULLCHOICE-PLUS-PPO
TPATPA-570992026-06-06T03:48:43ZYang, Gerald—··07/07/63UNKNOWN··—(245) 927-6170—533 Baseline RoadColumbusOH43261——
TPATPA-545152026-05-20T09:41:04ZDebra—Green2007-10-20·NULL•••-••-5139UNKNOWNNULL4502 Spring StMiamiFL33199GRP-8166··NULL
TPATPA-548782026-07-16T14:45:01ZDavid—HarveyDec 3, 1944NULL——null9718 Harbor Boulevard #891DENVERCO80218—-
TPATPA-511922026-02-28T06:35:47ZWei—Ferguson1953-09-09—····+1 769 422 6581WEI.FERGUSON@HOTMAIL.COM1093 VALLEY VIEW DRIVESacramentoCAnull—-
TPATPA-573322026-10-02T00:45:04ZNoahW.Hall05/18/46UHC-25198-97•••-••-1258—noah.hall@outlook.com7972 Forest AvenueSeattleWashington98119GRP-8248options-ppo
TPATPA-600042026-05-13T16:40:50ZMICHELLE—·BURNSJun 3, 1938·UNKNOWN•••-••-0000nullmichelle.burns@hotmail.com4095 Park PlDallasTX75205-4475GRP-2057—
TPATPA-565462026-07-11T16:44:33Z·Betty—PetesrJan 10, 1990UHC-55125-01—N/A—143 DESERT SKY BOULEVARDChandlerAZ85232NULL—
TPA TPA-625222026-01-05T17:29:25ZHELEN—GORDON19480203-·N/A(921) 494-0815helen.gordon40@icloud.com7857 Mesa DriveAustin·TX78730N/Anull
TPATPA-611572026-10-16T21:41:35ZAHMED—HOFFMAN1979-12-22-··•••-••-45333979756989—1307 Pine DriveDallas·TX75200GRP-3762N/A
TPATPA-513242026-06-09T12:47:25ZHerrera, Jacqueline——1969-10-14NULL—nullNULL8269 PALM DRIVESAN DIEGOCA92141··GRP-2917null
TPATPA-519312026-08-08T16:16:22ZHannah—Pierce1997-06-26—NULL-UNKNOWN·340 INDIAN SCHOOL ROADOrlandoFL32857NULLNULL
TPATPA-542212026-07-03T22:04:35ZSamantha—Patterson1974-10-20——19198602559SAMANTHA.PATTERSON@GMAIL.COM1608 Sage Ct·SCOTTSDALEAZ85290UNKNOWN·null
TPATPA-515562026-07-27T06:27:07ZBradley—Freeman1962-05-01UHC-66492-18NULL842.325.7375null7726 Union StPhoenixArizona85034N/A—
TPATPA-533352026-03-11T04:40:24ZnicoleTmunoz·19730626UNKNOWN•••-••-6106(430) 415-3850·NULL7046 OCEAN AVENUELos AngelesCA90027nullNULL
TPATPA-604252026-03-15T14:26:44ZAlbrt—·Santos1975-05-16··——UNKNOWN—7865 Hillcrest Road··AustinTX78726UNKNOWNN/A
TPATPA-612082026-05-15T05:17:00ZCruz, JeremyC··1964-04-15N/ANULL5404480026JEREMY.CRUZ@YAHOO.COM9297 Mountain View DriveTempeAZ85299-5615—navigate-hmo
TPATPA-605552026-05-05T18:02:21ZKATHERINE—WILSON··09/03/69—UNKNOWN····-2813 Market StEden PrairieMN55330GRP-4271··N/A
TPATPA-500682026-05-02T14:27:41Zmaria—dvis2007-03-12UHC-35556-52•••-••-8882null··5103 WILLOW CTTempeAZ85247—····
TPATPA-638662026-01-24T05:03:09Zkimberly—mills1955-12-07NULL-·NULLN/A9137 Main StGILBERTAZ85208UNKNOWNnull
14,474 rows, page 21 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:36.695Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty