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-563322026-03-03T12:06:26Zparker—williamJun 8, 1968null—NULLNULL4856 Mountain View DrNashvilleTN37213-1054—MEDICARE-ADV-A
TPATPA-510092026-05-15T22:00:35ZKELLEY—TERRY1963-01-07··UNKNOWN—829-604-5708UNKNOWN5057 Camelback RdFresnoCA93776··UNKNOWN····
TPATPA-579152026-04-08T11:57:06ZLawrence—Garrett06/23/97NULLNULLUNKNOWN-2120 Lake View Rd··Eden PrairieMN55355N/ANAVIGATE-HMO
TPATPA-580892026-02-16T03:06:09ZHarvey, Isabella····—19420102··-•••-••-1671N/A—·3704 HIGHLAND AVEColumbusOH—null—
TPATPA-625682026-10-11T22:18:02ZTyler····Meyer1964-04-20—null538-904-5416—2469 Harbor BoulevardMesaArizona85268——
TPATPA-516682026-08-20T03:53:43ZCAMILA—WALSH1596-04-22UHC-95340-27-577-840-4672NULL·238 Market StMiamiFL33187··—OPTIONS-PPO
TPATPA-608622026-06-01T01:11:08ZWilliam—Estrada1978-11-07N/A·-487-543-4438WILLIAM.ESTRADA48@PROTON.ME1710 Highland AveTAMPAFL··33659····MEDICARE-ADV-A
TPATPA-514072026-07-22T07:14:06ZRuth—Hill1985-12-12UNKNOWN•••-••-2224380-534-9906N/A557 Jefferson Avenue #720PlanoTX75028—MEDICARE-ADV-B
TPATPA-508562026-02-21T19:56:53ZTylre—Gurrero03/25/89N/A•••-••-53902558771204—3570 Park PlacePhoenixAZ--MEDICARE-ADV-B
TPATPA-518062026-06-22T16:46:16ZJOSE··CARPENTER1971-02-23—NULL558-986-1934-5511 ELM STPhoenixAZ85066-6134NULLNULL
TPATPA-548182026-06-29T16:29:04Z·Denise—HarperAug 11, 1985UNKNOWNNULLUNKNOWN··DENISE.HARPER12@YAHOO.COMNULL··nullN/A——MEDICARE-ADV-A
TPATPA-597422026-07-20T22:38:17ZMELISSA····KELLY1967-02-23—-nullmelissa.kelly@outlook.com·7347 CHURCH STREET·FresnoCA93707GRP-6879NAVIGATE-HMO
TPATPA-531582026-04-24T08:50:30ZMunoz, Christine——1994-03-71——221.530.3664UNKNOWN—nullUNKNOWNUNKNOWNNULL-
TPATPA-566432026-05-18T02:46:34ZSarah—Carroll1944-07-24NULL··-516-540-0711null—N/AN/AN/AUNKNOWNNULL
TPATPA-627592026-07-15T02:16:52Z·Diane—George--NULLN/AUNKNOWN6546 SPRING STREETHOUSTONTX77077GRP-3984null
TPATPA-517182026-02-17T17:44:32ZHIROSHI··—DEAN·1990-01-21UHC-65896-87····4137983234hiroshi.dean79@gmail.com8478 LINCOLN WAY Apt 10AUSTINTX78784UNKNOWNnull
TPATPA-530112026-08-13T08:24:13ZAdam—Adams1969-07-05UNKNOWNnull-adam.adams40@hotmail.com87 RIDGE RDLas VegasNV89191—N/A
TPATPA-590992026-09-03T11:25:49ZCarolyn—KennedyAug 6, 1948··UHC-02309-97•••-••-5041-·UNKNOWN5655 Main StreetGlendaleAZ85336UNKNOWN-··
TPATPA-516762026-05-06T12:35:29ZPatrick—Santiago2000-03-24N/A•••-••-9793NULL—3196 Grand AveMINNEAPOLISMinnesota55411GRP-8808CHOICE-PLUS-PPO
TPATPA-594342026-01-28T20:57:19ZRaplh····Jimenez07/12/1989—-402-644-0112··ralph.jimenez@gmail.com5171 DESERT SKY BOULEVARDLos AngelesCA90063—null
TPATPA-526582026-03-20T03:06:25ZIsabellaM··Sanders05/19/1986NULL•••-••-25795649104794-8404 Desert Sky Blvd·SAN ANTONIOTX78221——
TPATPA-614482026-03-23T19:55:40ZAshley—Castro1970-04-21··UNKNOWN8466303477—1834 Jefferson Ave··Austin·TX78730-0857GRP-5653—
TPATPA-559402026-09-19T12:22:02ZKATHERINE—HUNT1961-01-06null—2486344660—6525 Apache BoulevardMesa·Arizona85214GRP-0978-
TPATPA-598662026-09-10T16:50:28ZGeorge—Riley08/20/59-•••-••-8050nullNULL1602 Elm St #416San AntonioTX-GRP-4260UNKNOWN
TPATPA-610812026-09-18T22:24:23ZBruce—Wong02/10/1945NULL•••-••-1055NULLbruce.wong19@outlook.com5043 Apache BoulevardSAN DIEGOCA92128GRP-0843CORE-HMO
TPATPA-602032026-02-05T04:15:42ZGRACE—MONTGOMERY1984-02-21·NULL—·UNKNOWN·UNKNOWN592 MOUNTAIN VIEW DR··FRESNOCA93779·NULL····
TPATPA-619782026-01-27T12:07:19ZLias—Graham1956-08-06UNKNOWN—NULL—····N/ANULL——NAVIGATE-HMO
TPATPA-631732026-10-09T22:17:55ZGABRIEL—SCHMIDT09/05/1950—N/A—N/AN/AUNKNOWN-——UNKNOWN
TPA TPA-531252026-08-25T14:52:41ZHANNAH—ROSE1969-11-16-UNKNOWN·(246) 535-5809UNKNOWN3727 Sunset BoulevardDenverCO80280GRP-0531—
TPATPA-627912026-05-22T08:21:59ZDiane—Hall12/27/1947——9016433981—1106 Willow CtTampafl33641GRP-0836··NAVIGATE-HMO
TPATPA-63691 2026-06-20T14:28:16ZCastro, Ann——1997-07-15—•••-••-0980—ann.castro66@aol.com8768 Washington StCharlotteNC·28237-5948GRP-2460MEDICARE-ADV-A
TPA TPA-620482026-03-25T08:55:06ZCHERYLMPENA1992-06-08—nullN/ANULL2669 PINE DRIVESacramentoCA·95850GRP-3613—
TPATPA-575012026-04-22T06:53:51ZGloria—Robertson1971-03-16null•••-••-0066+1 311 766 5701NULL5042 Spring StSan DiegoCA92129--
TPATPA-635292026-06-03T21:59:45Z Diane—Schultz08/24/48N/A—14099193242—····N/AUNKNOWNNULLN/AOPTIONS-PPO
TPATPA-61778 2026-02-05T22:41:43ZRoger—·Banks05/26/1974nullUNKNOWN5458052054—·4937 Sage CtScottsdaleAZUNKNOWN—MEDICARE-ADV-B··
TPATPA-522482026-08-23T03:05:06ZRichard—Silva2000-07-04·UNKNOWN-NULL—1302 Meadow LnSan Diego·CA92143—MEDICARE-ADV-B··
TPATPA-579122026-01-01T05:04:34ZSean—Dixon2000-10-04———·UNKNOWN3247 Mountain View DrNashvilleTN37264GRP-3261NAVIGATE-HMO
TPATPA-504772026-04-06T13:53:44ZHernandez, Hiroshi—————17585566828hiroshi.hernandez@hotmail.com1528 CENTRAL AVECHANDLERAZ··85298N/ASELECT-EPO
TPATPA-518482026-09-07T15:59:45Z Denise—Patel1993-02-15·N/A·null(946) 482-4612······5609 CAMELBACK ROADTAMPA·FL33635GRP-1225UNKNOWN
TPATPA-643792026-09-14T02:09:25ZEILY—HAMILTON1958-04-24··—N/AUNKNOWN—1869 APACHE BLVD Apt 16SAN ANTONIOTexas78278GRP-4428NAVIGATE-HMO
TPATPA-526522026-04-08T22:03:23ZVictoria—LunaMay 10, 1947—UNKNOWNNULL··victoria.luna84@outlook.com7581 WILLOW COURTMesaAZ—·GRP-6912NULL
TPATPA-57527 2026-02-07T19:07:47Z·Gutirerez, Brian—·····1995-03-11null—NULL—6475 Central AveSacramentoCANULL··NAVIGATE-HMO
TPATPA-616852026-08-30T08:52:49ZMARK—MORGAN··04/13/1981NULL—·--2340 Pine DriveTampaFL··33607-3515——
TPATPA-629792026-01-13T23:23:01ZAna—Vargas02/26/1979—•••-••-5700-—6532 Harbor BlvdAustinTX——null··
TPATPA-530922026-01-29T21:32:44ZBobby····Jordan1/10/1948————8985 Valley View DriveDallasTX75295——
TPATPA-577712026-07-06T10:12:28ZNICOLE—BUTLER01/10/97UHC-48354-10•••-••-8880-nicole.butler@gmail.com··NULLN/A-null·UNKNOWNCHOICE-PLUS-PPO
TPATPA-527392026-05-28T09:13:00ZMitcell, DonnaG··19470801··UHC-84277-54—null-1369 CANYON ROADGilbertAZ85290—null
TPATPA-556402026-09-12T18:02:12ZYuki—Scott1981-05-13—•••-••-8313+1 759 860 3511UNKNOWN·8031 Lake View RdSCOTTSDALEAZ85212—OPTIONS-PPO
TPATPA-509542026-07-27T21:01:13ZSusan·SEvaans1960-06-17NULL•••-••-9433UNKNOWN—7457 Baseline RdScottsdaleAZ85219-7255NULLUNKNOWN
TPATPA-557392026-07-29T23:59:50ZKATHYN—·HENRY2/12/2002—UNKNOWNUNKNOWNUNKNOWN7738 BROADWAYTAMPA·Florida33657GRP-5822N/A··
14,474 rows, page 117 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:43.642Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty