pages/index.md

---
title: 🤗 Hub Stats
---

_Note: The charts are updated daily via the <a class="font-bold text-blue" href="https://huggingface.co/datasets/cfahlgren1/hub-stats" target="_blank" rel="noopener noreferrer">hub-stats dataset</a>. It may take a little while for the data to load as the queries are running entirely in the browser._

```sql hub_growth
-- Hub Growth by Month (using DATE_TRUNC for proper date ordering)
WITH all_data AS (
  SELECT 
    CAST(DATE_TRUNC('month', createdAt) AS DATE) AS month, 
    'model'   AS repo 
  FROM read_parquet('https://huggingface.co/datasets/cfahlgren1/hub-stats/resolve/main/models.parquet?download=true')
  WHERE createdAt IS NOT NULL

  UNION ALL

  SELECT 
    CAST(DATE_TRUNC('month', createdAt) AS DATE) AS month, 
    'dataset' AS repo 
  FROM read_parquet('https://huggingface.co/datasets/cfahlgren1/hub-stats/resolve/main/datasets.parquet')
  WHERE createdAt IS NOT NULL

  UNION ALL

  SELECT 
    CAST(DATE_TRUNC('month', createdAt) AS DATE) AS month, 
    'space'   AS repo 
  FROM read_parquet('https://huggingface.co/datasets/cfahlgren1/hub-stats/resolve/main/spaces.parquet?download=true')
  WHERE createdAt IS NOT NULL
)
SELECT
  month,
  repo,
  COUNT(*) AS creations
FROM all_data
GROUP BY month, repo
ORDER BY month, repo
```

## Cumulative Hub Growth

```sql cumulative_growth_by_repo
-- Cumulative Hub Growth
WITH ordered_data AS (
  SELECT
    month,
    repo,
    creations,
    ROW_NUMBER() OVER (PARTITION BY repo ORDER BY month) AS row_num
  FROM ${hub_growth}
)
SELECT
  month,
  repo,
  SUM(creations) OVER (PARTITION BY repo ORDER BY month) AS cumulative_creations
FROM ordered_data
ORDER BY month, repo
```

<AreaChart 
    data={cumulative_growth_by_repo}
    x=month
    y=cumulative_creations
    series=repo
    yFmt='#,##0.00,,"M"'
    xFmt='MMM yyyy'
/>

## Models, Datasets, Spaces created per month.

<BarChart 
    data={hub_growth}
    x=month
    xFmt='MMM yyyy'
    y=creations
    series=repo
/>

## Models Created Each Month

```sql model_creations_by_month
-- Models Created Each Month
SELECT
  month,
  repo,
  creations
FROM ${hub_growth}
WHERE repo = 'model'
ORDER BY month;
```

<AreaChart 
    data={model_creations_by_month}
    x=month
    xFmt='MMM yyyy'
    labels=true
    y=creations
/>

## Datasets Created Each Month

```sql dataset_creations_by_month
-- Datasets Created Each Month
SELECT
  month,
  repo,
  creations
FROM ${hub_growth}
WHERE repo = 'dataset'
ORDER BY month;
```
<AreaChart 
    data={dataset_creations_by_month}
    x=month
    xFmt='MMM yyyy'
    y=creations
    labels=true
/>

## Spaces Created Each Month

```sql space_creations_by_month
-- Spaces Created Each Month
SELECT
  month,
  repo,
  creations
FROM ${hub_growth}
WHERE repo = 'space'
ORDER BY month;
```

<AreaChart 
    data={space_creations_by_month}
    x=month
    xFmt='MMM yyyy'
    y=creations
    labels=true
/>

# Model Downloads by Pipeline Tag (Last 30 days)

```sql model_pipeline_downloads
SELECT
    pipeline_tag AS name,
    SUM(downloads) AS value
FROM read_parquet('https://huggingface.co/datasets/cfahlgren1/hub-stats/resolve/main/models.parquet?download=true')
GROUP BY pipeline_tag
ORDER BY value DESC
```

<DataTable data={model_pipeline_downloads} search=true>
  <Column id="name" title="Pipeline Tag" />
  <Column id="value" title="Downloads Last 30 Days" fmt='#,##0.00,,"M"' />
</DataTable>


<ECharts config={
    {
        tooltip: {
            formatter: '{b}: {c} ({d}%)'
        },
        series: [
            {
                type: 'pie',
                radius: ['40%', '70%'],
                data: [...model_pipeline_downloads],
                label: {
                    show: true,
                    formatter: '{b}: {c}'
                }
            }
        ]
    }
}
/>

# Model Downloads by Library (Last 30 days)

```sql model_library_downloads
SELECT
    library_name AS name,
    SUM(downloads) AS value
FROM read_parquet('https://huggingface.co/datasets/cfahlgren1/hub-stats/resolve/main/models.parquet?download=true')
GROUP BY library_name
ORDER BY value DESC
```

<DataTable data={model_library_downloads} search=true>
  <Column id="name" title="Library" />
  <Column id="value" title="Downloads Last 30 Days" fmt='#,##0.00,,"M"' />
</DataTable>


<ECharts config={
    {
        tooltip: {
            formatter: '{b}: {c} ({d}%)'
        },
        series: [
            {
                type: 'pie',
                radius: ['40%', '70%'],
                data: [...model_library_downloads],
                label: {
                    show: true,
                    formatter: '{b}: {c}'
                }
            }
        ]
    }
}
/>

# Model Licenses

```sql model_license_ratio
SELECT
    SUBSTRING(name, 9) AS name,
    COUNT(*) as value
FROM read_parquet('https://huggingface.co/datasets/cfahlgren1/hub-stats/resolve/main/models.parquet?download=true'),
    UNNEST(tags) AS t(name)
WHERE name LIKE 'license:%'
GROUP BY name
```

<ECharts config={
    {
        tooltip: {
            formatter: '{b}: {c} ({d}%)'
        },
      series: [
        {
          type: 'pie',
          radius: ['40%', '70%'],
          data: [...model_license_ratio],
        }
      ]
      }
    }
/>

# Dataset Licenses

```sql dataset_license_ratio
SELECT
    SUBSTRING(name, 9) AS name,
    COUNT(*) as value
FROM read_parquet('https://huggingface.co/datasets/cfahlgren1/hub-stats/resolve/main/datasets.parquet?download=true'),
    UNNEST(tags) AS t(name)
WHERE name LIKE 'license:%'
GROUP BY name
```

<ECharts config={
    {
        tooltip: {
            formatter: '{b}: {c} ({d}%)'
        },
      series: [
        {
          type: 'pie',
          radius: ['40%', '70%'],
          data: [...dataset_license_ratio],
        }
      ]
      }
    }
/>

# Space SDKs

```sql space_sdk_ratio
SELECT
    sdk as name,
    COUNT(*) as value
FROM read_parquet('https://huggingface.co/datasets/cfahlgren1/hub-stats/resolve/main/spaces.parquet?download=true')
GROUP BY name
```


<ECharts config={
    {
        tooltip: {
            formatter: '{b}: {c} ({d}%)'
        },
      series: [
        {
          type: 'pie',
          radius: ['40%', '70%'],
          data: [...space_sdk_ratio],
        }
      ]
      }
    }
/>

# Hub Stats Dataset
<iframe
  src="https://huggingface.co/datasets/cfahlgren1/hub-stats/embed/viewer/datasets/train"
  frameborder="0"
  width="100%"
  height="560px"
></iframe>