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-562552026-05-12T08:52:18ZJOHNJLAWSON1986-10-27UHC-24203-26—null—3416 Washington StreetTEMPE·AZ85289-CHOICE-PLUS-PPO
TPATPA-588862026-06-18T17:56:00ZEstrada, Diana····—1987-06-14-•••-••-5523NULLN/A···6741 Cedar LaneFresnoCA93706null—
TPATPA-599012026-10-06T05:44:31ZSsanQSandoval02/16/87—•••-••-5792—susan.sandoval@hotmail.com5988 River RdTempeArizona85250-CHOICE-PLUS-PPO
TPATPA-625292026-06-22T18:53:49ZJUAN—MARSHALL1938-10-26—··-·nullNULLnull——GRP-4061MEDICARE-ADV-A
TPATPA-567742026-09-25T04:26:57Z Gilbert, Hiroshi——1/9/1958—nullNULL—1631 Sunset Boulevard Apt 3San AntonioTX78207null—
TPATPA-588052026-05-02T05:51:28Zemma—gardner19-08-1951—•••-••-5075(749) 954-9025—6009 MAPLE AVEMiamiFL33192·NULLSELECT-EPO
TPATPA-623812026-08-31T21:13:35ZAnthony—GuerreroDec 24, 1953UHC-05111-02•••-••-3970356.778.5681anthony.guerrero@gmail.com1641 Central Avenue #871Los AngelesCA90081—SELECT-EPO
TPATPA-620922026-08-02T19:41:30ZHIROSHI—MATTHEWS1980-11-17null-N/AN/A··3697 Sunset BlvdMESAAZ85243GRP-8380null
TPATPA-605842026-01-10T08:52:40ZMariana—Dixon10/07/90null•••-••-3976393.257.7303N/A·6216 Camelback Rd·ScottsdaleAZ85224-1833—NAVIGATE-HMO··
TPATPA-605042026-01-14T11:18:26ZASHLEY—NUNEZ1990-04-28UNKNOWN—N/A—-·null——GRP-4718MEDICARE-ADV-A··
TPATPA-537852026-09-11T10:58:13ZAliceX.Ellis·Jul 19, 1994UNKNOWN—4705169561—7963 PARK PLCharlotteNC28299GRP-1513—
TPATPA-583142026-01-19T08:31:13ZJuan—Lane·02-04-1965N/A-711-289-3968—7809 Lake View RoadMesaaz··85200GRP-7109null
TPATPA-603092026-01-27T11:33:33ZHannah—Vazquez07/21/08—NULLUNKNOWN··—5714 River Road #643·DallasTX75295——
TPATPA-592572026-09-24T17:34:50ZJORDAN—MURPHY1986-12-16NULLN/Anulljordan.murphy43@aol.com621 Indian School RoadGilbertArizona-N/AUNKNOWN
TPATPA-50685 2026-02-21T05:53:49ZJohnny—SantiagoOct 4, 2005··null-NULL-·NULLNULL—-CORE-HMO
TPATPA-540612026-08-08T21:27:59Zsophia—morris2002-02-22UNKNOWN—(774) 456-8719sophia.morris@icloud.com·1447 BroadwayJacksonvilleFL—nullCORE-HMO
TPATPA-644262026-03-29T01:08:01ZMadison—Hunt1993-05-07—nullUNKNOWN-2547 Mesa DriveTucsonAZ85736—MEDICARE-ADV-A
TPATPA-558102026-10-05T07:03:55ZDANIELLE—PETERSON1989-06-24NULL·null··null863 Camelback RdNashvilleTN37229—null
TPATPA-596602026-09-13T08:08:45ZRebecca—Fox2000-04-23null—+1 787 298 3107NULL9718 Main StFresnoCA93789GRP-6836CHOICE-PLUS-PPO
TPATPA-529052026-03-02T16:37:27ZNency—Andrews26-12-1983—UNKNOWN—nancy.andrews55@proton.me627 Grand AvenueGlendaleAZ85355GRP-2685MEDICARE-ADV-B
TPATPA-605032026-08-11T10:00:59Z Angela—Miller1961-12-22UNKNOWN—UNKNOWN—1693 Sage CtEden PrairieMN55341—CHOICE-PLUS-PPO
TPATPA-582932026-04-27T04:11:55ZETHAN····WEAVER06/05/1967NULL—NULL—8731 Washington StreetMesaAZ85268-7172GRP-6773NULL
TPATPA-593992026-08-07T20:40:12ZRebecca··FMurray9/21/2002null———6746 Lake View RoadSan Antoniotx78273nullUNKNOWN
TPATPA-566862026-09-10T19:49:31ZFatima—Maldonado1960-05-25N/A-NULL—1172 APACHE BLVDDallasTX75244N/A·MEDICARE-ADV-A
TPATPA-50286 2026-01-10T10:02:50ZHughes, BrianW—1973-09-07·UHC-74866-18—NULLN/A2261 Mesa DrDallasTX75287GRP-7924NULL
TPATPA-566132026-02-20T18:23:45ZStone, Laura··——17-02-1995null—861.409.8541NULL9078 CANYON ROADTampafl33658N/ANAVIGATE-HMO··
TPATPA-640372026-01-07T05:41:12ZLogan—Lnch08/25/67UNKNOWN——UNKNOWN6009 PALM DRIVEFresnoCA93755-3731nullnull
TPATPA-644712026-09-25T10:24:24ZMargaret—·Patel06/28/91——+1 259 551 6968-6042 HILLCREST ROADAustinTX78791-1829—OPTIONS-PPO
TPATPA-502922026-09-05T16:26:37ZYuki··E.·Berry01/02/1953N/A--—5752 LINCOLN WAYAtlantaGeorgia30354N/ACHOICE-PLUS-PPO
TPATPA-570482026-07-20T20:08:30Zyuki—marquez11/13/1975NULL--—5165 Mountain View DriveHoustonTX—null—
TPATPA-555592026-09-02T18:30:40ZOmar—Baker1982-12-17NULL•••-••-2095——5030 Desert Sky BoulevardOrlandoFL32808GRP-6402MEDICARE-ADV-A
TPATPA-527332026-08-14T09:07:53ZLUIS—NGUYEN1977-04-15UNKNOWN—-N/A7453 Market StOrlandofl32833—UNKNOWN
TPATPA-554382026-06-02T22:37:54ZRalphZLunaDec 5, 1978————·3844 Forest AveHoustonTX77070—CHOICE-PLUS-PPO
TPATPA-522062026-05-21T02:23:05ZJonathan··Dunn1982-02-24UHC-83711-02•••-••-9424—jonathan.dunn99@outlook.com6904 Forest AveMIAMIFL33149-NULL
TPATPA-534412026-03-03T14:37:37ZJordan—Ferguson1969-08-05UNKNOWN··null19746705648-5600 Palm DriveEden PrairieMN55336-6535—OPTIONS-PPO
TPATPA-514262026-03-31T20:32:23ZJudithE.Gilbert1955-10-23UHC-52805-66•••-••-9587N/AUNKNOWN—·NULLNULLNULLNULLMEDICARE-ADV-B
TPATPA-570792026-05-18T16:34:53ZAlice—·Bailey1980-08-28UNKNOWN··•••-••-4037—UNKNOWN9752 WILLOW COURTGlendaleAZ···85322N/AN/A
TPATPA-51630 2026-04-08T03:39:55ZJennifer—Perez1498-07-18-UNKNOWN·null—6039 GRAND AVETucsonAZ85749GRP-8406null
TPATPA-503672026-01-30T00:56:02ZSofia—Chavez12/23/1996-—481-667-2397—3709 SUNSET BLVDLos AngelesCA90067N/AUNKNOWN
TPATPA-624792026-09-23T07:13:02ZWelch, Austin——23-04-1963-NULL--278 Palm DrGilbertAZ85277GRP-7966NULL
TPATPA-546772026-03-27T05:07:29ZAMANDA—FOSTER1974-01-09—UNKNOWNnullN/A395 Washington StSan DiegoCalifornia92199-null
TPATPA-63145 2026-01-02T22:28:01ZERICABURKEJun 20, 1976UNKNOWN—UNKNOWN—5360 Valley View DrSan DiegoCA92194—-
TPATPA-57540 2026-06-01T13:14:33Z·Omar—Gardner1953-09-05NULLNULL——2622 SUNSET BOULEVARDNASHVILLETN37271GRP-9648CHOICE-PLUS-PPO
TPATPA-577042026-01-03T23:09:43ZChristopher—Ellis1986-04-05UHC-61611-07•••-••-8219·NULLN/A3925 BroadwaySan DiegoCalifornia92178GRP-7465··N/A
TPATPA-596452026-07-25T15:02:02ZGeorge—Crawford1968-03-12null··———2808 Oak StPhoenixAZ85032nullNULL
TPATPA-558582026-01-26T14:56:27ZDiego—Guerrero03/05/43UNKNOWNN/Anull—4725 Willow CtSAN DIEGOCA92183GRP-6083NULL
TPATPA-568572026-08-07T14:27:42ZCharles—Matthews12-05-1952-—-charles.matthews89@icloud.com8323 Market StLos AngelesCA90080null·CHOICE-PLUS-PPO
TPATPA-629632026-05-19T03:38:29ZVALENTINA—STEVENS1943-01-26—NULLN/A··8592 Mountain View DriveHoustonTX77011null-
TPATPA-530132026-06-26T06:22:37ZJASON—ROBERTSON1/11/1950UNKNOWN-(350) 784-6631—4486 BASELINE ROADDALLASTX75223--
TPATPA-521242026-06-04T17:07:51ZKyle—Cruz1970-07-28—•••-••-4170(742) 732-6030UNKNOWN4360 BROADWAYGlendaleAZ85354-3885GRP-6561UNKNOWN
14,474 rows, page 7 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-19T19:54:25.425Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty