← Runs · ← Label

Export — 2026-06-18T19-39-55_classify-empire-qwen35-397b-a17b-fp8

1 labeled
1 opening notice
0 not opening notice
0 unsure
499 unlabeled

Downloads all candidates (labeled and unlabeled). The verdict column is empty for unlabeled rows.

↓ Download CSV

Postgres query guide

The exported CSV contains article_id (UUID) and candidate_id. Use these to fetch full text and metadata from the Postgres database.

Fetch a single article
SELECT
  "ID"::text    AS article_id,
  "publishDate" AS publish_date,
  "municipality",
  "stateCode"   AS state_code,
  "content"
FROM public.api_article
WHERE "ID"::text = '<article_id>';
Fetch all paragraphs of an article
SELECT
  "paragraphIdx" AS idx,
  "paragraphText" AS text
FROM public.api_article_paragraph_v2
WHERE "articleID" = '<article_id>'::uuid
ORDER BY "paragraphIdx";
Fetch full text for a list of labeled articles
-- Paste article_id values from the exported CSV
SELECT
  a."ID"::text       AS article_id,
  a."publishDate"    AS publish_date,
  a."municipality",
  a."stateCode"      AS state_code,
  p."paragraphIdx"   AS para_idx,
  p."paragraphText"  AS para_text
FROM public.api_article a
JOIN public.api_article_paragraph_v2 p
  ON p."articleID" = a."ID"
WHERE a."ID"::text IN (
  -- paste article_ids here, one per line, quoted
  '<article_id_1>',
  '<article_id_2>'
)
ORDER BY a."publishDate", a."ID", p."paragraphIdx";
Look up article page metadata
SELECT
  "pageNumber",
  "pageText"
FROM public.api_article_page
WHERE "articleID" = '<article_id>'::uuid
ORDER BY "pageNumber";
Find all articles for a municipality in a date range
SELECT
  "ID"::text    AS article_id,
  "publishDate",
  "municipality"
FROM public.api_article
WHERE "municipality" ILIKE '%<municipality_name>%'
  AND "publishDate" BETWEEN '2020-01-01' AND '2023-12-31'
ORDER BY "publishDate";