> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dune.com/llms.txt
> Use this file to discover all available pages before exploring further.

# dune.neynar.dataset_farcaster_profile_with_addresses

> Farcaster profiles with verified addresses — user profiles linked to Ethereum addresses.

export const TableSample = ({tableName, tableSchema}) => <>
    <div className="hidden dark:block">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}&darkMode=true`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
    <div className="dark:hidden">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
  </>;

## Table description

The `dune.neynar.dataset_farcaster_profile_with_addresses` table contains Farcaster user profile data combined with their connected wallet addresses. It provides a convenient denormalized view for querying user identity alongside on-chain addresses.

## Table Schema

| Column Name          | Type        | Description                                                                  |
| -------------------- | ----------- | ---------------------------------------------------------------------------- |
| `fid`                | `BIGINT`    | Farcaster user ID                                                            |
| `fname`              | `VARCHAR`   | Farcaster username                                                           |
| `display_name`       | `VARCHAR`   | Display name chosen by the user                                              |
| `avatar_url`         | `VARCHAR`   | URL to the user's profile picture                                            |
| `bio`                | `VARCHAR`   | User's profile biography text                                                |
| `verified_addresses` | `VARCHAR`   | JSON-encoded array of verified EVM wallet addresses connected to the profile |
| `updated_at`         | `TIMESTAMP` | Timestamp when the profile data was last updated                             |

## Table Sample

<TableSample tableSchema="dune.neynar" tableName="dataset_farcaster_profile_with_addresses" />
