ForumAI Cooperative Report

This report lists only what is in cooperative D1 forum_feedback. It is not a census. No generative model is used.

# Cooperative aggregate report (D1 / SQL only)

Generated: 2026-05-28T12:00:05.405Z
Source table: forum_feedback (wiped_at IS NULL)
Comment length cap at ingest: 2000 characters (enforced in Pod)

## Aggregate counts

Total submissions: 6
Distinct participant hashes: 4

### By category
- Watched / read / listened (`media`, behavioral): 2
- Bought something (`purchasing`, behavioral): 2
- Interest / hobby (`interest`, psychographic): 1
- Lifestyle (`lifestyle`, psychographic): 1

### ZIP area prefixes (first 3 digits only)
- 040: 3

## Full submission ledger

### 0F3F7F39
- kind: behavioral
- category: Bought something (`purchasing`)
- zip_code: (not provided)
- submitted: 2026-05-22 21:31:49
- comment (76 chars):

I bought a book about political manipulation today and I felt good about it.

### B23D6CE1
- kind: psychographic
- category: Lifestyle (`lifestyle`)
- zip_code: (not provided)
- submitted: 2026-05-24 11:47:08
- comment (19 chars):

I enjoy waterskiing

### 4F8C42F5
- kind: behavioral
- category: Bought something (`purchasing`)
- zip_code: (not provided)
- submitted: 2026-05-26 17:19:03
- comment (33 chars):

Bought a book called manipulation

### 96A09D7C
- kind: psychographic
- category: Interest / hobby (`interest`)
- zip_code: 04011
- submitted: 2026-05-26 19:10:54
- comment (28 chars):

I like playing table tennis.

### DFD0608D
- kind: behavioral
- category: Watched / read / listened (`media`)
- zip_code: 04005
- submitted: 2026-05-26 22:43:01
- comment (34 chars):

Listened to a conservative podcast

### 059DAE36
- kind: behavioral
- category: Watched / read / listened (`media`)
- zip_code: 04005
- submitted: 2026-05-26 22:43:13
- comment (29 chars):

Listened to a liberal podcast

## SQL queries used

### total
```sql
SELECT COUNT(*) AS n FROM forum_feedback WHERE wiped_at IS NULL
```

### distinctParticipants
```sql
SELECT COUNT(DISTINCT email_hash) AS n FROM forum_feedback WHERE wiped_at IS NULL
```

### byCategory
```sql
SELECT category_code, category_label, kind, COUNT(*) AS n
    FROM forum_feedback WHERE wiped_at IS NULL
    GROUP BY category_code, category_label, kind ORDER BY n DESC
```

### byZip
```sql
SELECT zip_code, COUNT(*) AS n FROM forum_feedback
    WHERE wiped_at IS NULL AND zip_code IS NOT NULL AND zip_code != ''
    GROUP BY zip_code ORDER BY n DESC
```

### ledger
```sql
SELECT receipt_id, kind, category_code, category_label, zip_code, comment, consent_at, created_at
    FROM forum_feedback WHERE wiped_at IS NULL ORDER BY created_at ASC
```

## Faithfulness boundary

This report does not include sentiment scores, bridging indices, trend forecasts, or narrative synthesis. Those are not in D1 and cannot be stated faithfully here.

Only 6 submission(s) are in the ledger. Category-level or geographic conclusions beyond the counts and verbatim comments above would not be faithful.

_Every count and comment above is copied from D1. If you need an answer that is not listed here, the cooperative does not have it in the current ledger._