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

# DuckDB / SQL

> Consulta archivos Parquet directamente sobre HTTP con SQL

[DuckDB](https://duckdb.org/) puede consultar archivos Parquet directamente sobre HTTP sin necesidad de descarga ni configuración. Esta es la forma más rápida de explorar los datos de manera interactiva.

## Configuración

Instala DuckDB y consulta directamente:

```bash theme={null}
duckdb
```

```sql theme={null}
SELECT sender, COUNT(*) as n
FROM read_parquet('https://data.jmail.world/v1/emails-slim.parquet')
GROUP BY sender ORDER BY n DESC LIMIT 20;
```

## Ejemplos de consultas

### ![](https://mintcdn.com/jmail/F-FAi3RZzojcIyie/images/jmail-app.png?fit=max\&auto=format\&n=F-FAi3RZzojcIyie\&q=85\&s=3d45d0246f3c69c7024d9a467fcfad28) Contar correos por remitente

```sql theme={null}
SELECT sender, COUNT(*) as n
FROM read_parquet('https://data.jmail.world/v1/emails-slim.parquet')
GROUP BY sender ORDER BY n DESC LIMIT 20;
```

### ![](https://mintcdn.com/jmail/F-FAi3RZzojcIyie/images/jmail-app.png?fit=max\&auto=format\&n=F-FAi3RZzojcIyie\&q=85\&s=3d45d0246f3c69c7024d9a467fcfad28) Emails enviados por Epstein

```sql theme={null}
SELECT subject, sent_at, to_recipients
FROM read_parquet('https://data.jmail.world/v1/emails-slim.parquet')
WHERE epstein_is_sender = true
ORDER BY sent_at DESC LIMIT 20;
```

### ![](https://mintcdn.com/jmail/F-FAi3RZzojcIyie/images/jdrive.png?fit=max\&auto=format\&n=F-FAi3RZzojcIyie\&q=85\&s=fbe04f350a6febb5b8e050cba1003c2c) Buscar documentos

```sql theme={null}
SELECT original_filename, document_description, page_count
FROM read_parquet('https://data.jmail.world/v1/documents.parquet')
WHERE document_description ILIKE '%flight%'
LIMIT 20;
```

### ![](https://mintcdn.com/jmail/F-FAi3RZzojcIyie/images/jphotos.png?fit=max\&auto=format\&n=F-FAi3RZzojcIyie\&q=85\&s=e9f59aaa9fa1ebb967916b9d576f6018) Vincular fotos con personas

```sql theme={null}
SELECT p.name, COUNT(*) as appearances
FROM read_parquet('https://data.jmail.world/v1/photo_faces.parquet') pf
JOIN read_parquet('https://data.jmail.world/v1/people.parquet') p
  ON pf.person_id = p.id
GROUP BY p.name ORDER BY appearances DESC;
```

### Conteos de estrellas por tipo de entidad

```sql theme={null}
SELECT entity_type, SUM(count) as total_stars
FROM read_parquet('https://data.jmail.world/v1/star_counts.parquet')
GROUP BY entity_type ORDER BY total_stars DESC;
```

## Uso con Polars

[Polars](https://pola.rs/) también puede leer Parquet a través de HTTP:

```python theme={null}
import polars as pl

df = pl.read_parquet("https://data.jmail.world/v1/emails-slim.parquet")
print(df.group_by("sender").len().sort("len", descending=True).head(20))
```

## Uso con pandas

```python theme={null}
import pandas as pd

df = pd.read_parquet("https://data.jmail.world/v1/emails-slim.parquet")
print(df.groupby("sender").size().sort_values(ascending=False).head(20))
```


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.