# View: int_dbt_prod_artist_demographics

**View Name:** int_dbt_prod_artist_demographics
**Table Source:** `Derived from: Dbt_Prod.Artist_Demographics, Intelligence.Dbt_Prod`
**File Path:** `views/int_dbt_prod_artist_demographics.view.lkml`

## Overview

- **File Size:** 9496 bytes
- **Lines of Code:** 316
- **Dimensions:** 36
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

- dimension: artist_id {
- description: "Unique Orchard ID for each Artist"
- type: number

## Dimensions

| Name | Type |
|------|------|
| `artist_name` | string |
| `youtube_channel_id` | string |
| `total_followers` | number |
| `ages_13_17_followers` | number |
| `ages_18_24_followers` | number |
| `ages_25_34_followers` | number |
| `ages_35_44_followers` | number |
| `ages_45_64_followers` | number |
| `ages_65_followers` | number |
| `male_followers` | number |
| `male_13_17_followers` | number |
| `male_18_24_followers` | number |
| `male_25_34_followers` | number |
| `male_35_44_followers` | number |
| `male_45_64_followers` | number |
| `male_65_followers` | number |
| `female_followers` | number |
| `female_13_17_followers` | number |
| `female_18_24_followers` | number |
| `female_25_34_followers` | number |
| `female_35_44_followers` | number |
| `female_45_64_followers` | number |
| `female_65_followers` | number |
| `german_speaking_followers` | number |
| `english_speaking_followers` | number |
| `spanish_speaking_followers` | number |
| `fench_speaking_followers` | number |
| `japanese_speaking_followers` | number |
| `portuguese_speaking_followers` | number |
| `russian_speaking_followers` | number |
| `chinese_speaking_followers` | number |
| `instagram_total_followers` | number |
| `white_followers` | number |
| `african_american_followers` | number |
| `asian_followers` | number |
| `hispanic_followers` | number |

## Derived Table

```sql
sql:
        select distinct
    ad.orch_artist_name,
    ad.total_followers,
    ad.ages_13_17_followers,
    ad.ages_18_24_followers,
    ad.ages_25_34_followers,
    ad.ages_35_44_followers,
    ad.ages_45_64_followers,
    ad.ages_65_followers,
    ad.female_followers,
    ad.female_13_17_followers,
    ad.female_18_24_followers,
    ad.female_25_34_followers,
    ad.female_35_44_followers,
    ad.female_45_64_followers,
    ad.female_65_followers,
    ad.male_followers,
    ad.male_13_17_followers,
    ad.male_18_24_followers,
    ad.male_25_34_followers,
    ad.male_35_44_followers,
    ad.male_45_64_followers,
    ad.male_65_followers,
    ad.followers_lang_de,
    ad.followers_lang_en,
    ad.followers_lang_es,
    ad.followers_lang_fr,
    ad.followers_lang_ja,
    ad.followers_lang_pt,
    ad.followers_lang_ru,
    ad.followers_lang_zh,
    ad.ig_total_followers,
    ad.ig_followers_white,
    ad.ig_followers_african_american,
    ad.ig_followers_asian,
    ad.ig_followers_hispanic
from intelligence.dbt_prod.artist_demographics ad
    ;;
```