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-626022026-05-04T02:37:28ZMEI—TORRES22-08-1961UNKNOWNNULL(287) 932-8570NULL·7477 Oak StFresnoCA93730··—
TPATPA-600282026-06-14T20:06:06ZCarpenter, Tiimothy——Apr 7, 1970UHC-24778-33——timothy.carpenter27@outlook.com8987 Hillcrest RdMESAAZ85217··GRP-6865CORE-HMO
TPATPA-623602026-04-28T16:01:37ZSHARONN.GILBERTMay 14, 2003·NULL····686.485.1713NULL1467 Meadow LnGlendaleAZ85332N/A-
TPATPA-548362026-04-23T18:28:02ZANA—DELGADO1953-02-25N/A··•••-••-6208(587) 633-8278—1797 OAK STREETLas VegasNV89167NULLCHOICE-PLUS-PPO
TPATPA-557672026-09-07T00:44:30ZAustinI.Walker04/08/1943-—N/AN/A357 Lake View RdOrlandoFL32816——
TPATPA-618712026-08-11T18:24:52ZStephanie—Cunningham16-03-1953UHC-09872-75N/A402-467-6799··N/A5452 Lincoln WayGlendaleAZ85317N/A··—
TPATPA-557262026-09-23T14:45:14ZBrooks, Kathleen——1987-01-02—N/A344-331-5594kathleen.brooks31@aol.com8400 BroadwayTEMPEAZ85216NULLN/A
TPATPA-568442026-07-01T20:33:25ZLogan—Lawson1992-11-11—•••-••-14232836807393—9216 Mesa Dr··AtlantaGA30313-5628—CORE-HMO
TPATPA-512862026-07-25T20:14:27ZSantos, Mason—··1964-03-21—•••-••-3841N/A—8308 Canyon Rd·GlendaleArizona85385nullNAVIGATE-HMO
TPATPA-61526 2026-03-24T11:00:53ZMartha—Snyder08-05-1990—•••-••-4522796-432-8536N/A6526 BroadwayPlano··Texas75074GRP-2590null
TPATPA-598202026-07-06T10:07:36ZDOROTHYCRICHARDS1979-02-07—N/A·nulldorothy.richards@icloud.comnull-N/A·UNKNOWNGRP-5934NULL
TPATPA-518422026-03-08T15:30:22ZJean··Gonzales1989-11-19—•••-••-31212822104jean.gonzales@hotmail.com6660 Lake View RoadSacramentoCA95853-6345UNKNOWNN/A
TPATPA-535822026-04-03T09:25:05Z·Kathryn—Cook19910701NULLNULL300.914.7958—2631 PARK PL Apt 22Plano··TX··UNKNOWNNULL
TPATPA-521172026-07-25T10:06:11Z·CAROLYN—LANE19651227NULL··UNKNOWN8224920257-9646 Mesa DriveSacramentoCA··95889N/A—
TPATPA-585292026-09-13T05:08:22ZBilly—Hayes2/14/1996····UNKNOWN-billy.hayes35@proton.me2016 Forest AveHoustonTX77031-2380——
TPATPA-53769 2026-02-04T07:47:25ZCYNTHIA—CHEN2008-03-08——-UNKNOWN7374 Lake View RoadCharlottenc28200GRP-3838N/A
TPATPA-522962026-03-07T18:25:43Zanthony—guerrero12/1/1993UHC-84143-49null-—5499 Church StLos AngelesCA90034GRP-9452··NAVIGATE-HMO
TPATPA-591752026-05-20T13:44:47Z Diana—Burns2006-11-17UHC-40188-10•••-••-7438931.742.1158null2843 Jefferson AveMiamiFL33120-7858UNKNOWNNAVIGATE-HMO
TPATPA-57541 2026-06-01T13:14:33Z·Omar—Gardner1953-09-05NULLNULL——2622 SUNSET BOULEVARDNASHVILLETN37271GRP-9648CHOICE-PLUS-PPO
TPATPA-59868 2026-06-22T08:57:18Zdonna—miller1941-04-07—N/AUNKNOWNN/A4906 Canyon RdJACKSONVILLEFL32202UNKNOWNSELECT-EPO
TPATPA-638072026-01-18T18:21:44ZNICHOLAS··—WALSH1996-07-04·NULLUNKNOWNnull-··3420 OAK STTempeAZ—N/AN/A
TPATPA-528792026-03-19T21:04:20ZMichael—Jordan2000-11-24··——212.512.5878-1678 Oak StreetSan AntonioTX78293·NULLN/A
TPATPA-637822026-01-24T12:57:31ZJean—Nunez2008-01-15NULL··-617.640.7823NULL1238 CENTRAL AVENUENashvilleTN37294—null
TPATPA-560992026-06-17T01:33:43ZJAN··—WELCHJan 5, 1959UNKNOWN•••-••-0492—juan.welch@yahoo.com4917 Park PlSan AntonioTX78227-5073GRP-0947—
TPATPA-503832026-08-29T10:54:38ZSARAH··—GARRETT22-06-1982—N/A2517175277SARAH.GARRETT@YAHOO.COM9114 INDIAN SCHOOL RDSAN DIEGOCA92186GRP-2054MEDICARE-ADV-B··
TPATPA-616252026-01-06T00:35:47Zabby—price1964-04-17·····null16542387596—2730 Desert Sky BoulevardTempeAZ85245-N/A
TPATPA-505842026-02-14T05:58:45Z·Linda—Greene1979-07-12—NULL-—655 Central AveLas Vegas·NV89170GRP-7617NAVIGATE-HMO
TPATPA-609932026-02-13T23:33:51ZSTEPHANIE—COLLINS1974-08-04UHC-85615-89—9321986stephanie.collins86@icloud.com7122 Mesa DrAtlantaGA·30315——
TPATPA-615352026-01-31T15:40:21ZRebecca—Dunn1945-09-20NULL—N/A—3054 Harbor BlvdSacramentoCA95884-4385GRP-4538N/A
TPATPA-509632026-08-07T21:25:35ZSTEVE—RUIZ1971-06-18-UNKNOWN—·UNKNOWN860 Bayshore DriveTucsonArizona··85734GRP-4800NULL
TPATPA-637552026-07-03T12:53:48ZBetty—Woods··1992-04-01—·null9419857185N/A3963 Lincoln WayGILBERTAZ85214NULLN/A
TPA TPA-515602026-02-19T07:18:10ZcarolynS.green1994-12-19·NULL—N/A—9765 Bayshore DrAtlantaGA30391——
TPATPA-559002026-03-07T22:51:04ZCamila—Snyder1951-11-11-•••-••-8459—CAMILA.SNYDER@HOTMAIL.COM8443 Valley View DriveAustinTX··78762··-N/A
TPATPA-625872026-08-08T22:40:47ZHannahG.Moore3/27/1963NULL··null——4706 CENTRAL AVENUE·MINNEAPOLISmn55435GRP-8157MEDICARE-ADV-B
TPATPA-615822026-04-22T12:53:35ZRussellJHolmes1969-07-10UHC-68851-64———6297 Sage CourtAtlantaGA30312—CHOICE-PLUS-PPO
TPATPA-53347 2026-04-03T12:33:48ZAbiail—Herrera2007-08-01—null562-526-9774-6743 Central AvenueLas Vegasnv89114——
TPATPA-575812026-03-13T04:00:13ZJudithM.Cole1994-02-04UHC-18901-24—5374340268UNKNOWN·4995 Mountain View DrDenver··CO80241—··
TPATPA-542782026-03-31T21:52:36ZRuth—ColeDec 16, 1966—N/A··—2598 BROADWAYJacksonvilleFL32232GRP-3694null
TPATPA-589912026-09-16T18:56:33ZSharonEHarper2006-12-17nullNULL··UNKNOWN··UNKNOWN——N/AnullGRP-5748—
TPATPA-546332026-07-30T13:59:09ZMargaret··Spencer2/23/1955—NULL—MARGARET.SPENCER15@GMAIL.COM4242 Baseline Rd #886PlanoTX75047GRP-1001NULL
TPATPA-535302026-10-03T01:54:04ZCAROLYNW.KELLEY1991-02-21—•••-••-08668787864914—3821 MARKET STREET·TUCSONAZ85715NULL-
TPATPA-559652026-09-24T11:44:42ZWard, Cheryl——·1986-10-26—null—cheryl.ward@proton.me1170 SPRING STREET··NashvilleTN37258—null
TPATPA-631692026-03-11T22:45:44ZMARK···PARKER1995-01-16—-——5873 MOUNTAIN VIEW DRIVE·AtlantaGeorgia30396——
TPATPA-535702026-03-25T20:33:42ZJESSICA—PATEL2005-06-16—····2145901087jessica.patel@gmail.com—····NULL——null
TPATPA-639162026-08-13T12:41:28ZAndreaXOrtega1958-03-18N/A•••-••-03904767353233andrea.ortega43@icloud.com1887 Grand AvePhoenixArizona85030NULL-
TPATPA-558792026-03-04T12:42:41ZSCOTT—ROSE1985-06-01UNKNOWN-NULL·N/A954 Canyon Road Apt 12·San DiegoCA92102—NAVIGATE-HMO
TPATPA-542332026-05-29T14:32:46ZYUKI—LYNCH19630601NULL•••-••-5423·9205577136yuki.lynch2@proton.me··———·UNKNOWN—CORE-HMO
TPATPA-53892 2026-01-16T04:13:36ZLogan—PattersonJul 22, 1994N/A•••-••-7361—UNKNOWN9605 CANYON ROADMesaAZ·85203NULL—
TPA TPA-560102026-09-24T02:37:19Zanthony—palmer1953-06-21UNKNOWNNULL(640) 743-5110null867 ELM STREETFresnoCA93755-··N/A
TPATPA-514022026-04-10T09:51:07ZLinda··CSpencer1966-09-16——+1 332 848 0395··—6260 RIDGE RDTucsonAZ··85787··—null··
14,474 rows, page 262 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:00.554Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty