Output Formats

{
  "columns": ["country", "year", "value"],
  "types": ["string", "integer", "float"],
  "rows": [
    ["United States", 2023, 13473],
    ["Japan", 2023, 5365]
  ],
  "total_rows": 4869,
  "row_count": 2
}

{
  "data": [
    {"country": "United States", "year": 2023, "value": 13473},
    {"country": "Japan", "year": 2023, "value": 5365}
  ]
}

# JSON (default)
curl 'https://api.tryopendata.ai/v1/datasets/nces/naep?limit=10'

# CSV download
curl 'https://api.tryopendata.ai/v1/datasets/nces/naep?format=csv&limit=1000' -o naep.csv

# TSV
curl 'https://api.tryopendata.ai/v1/datasets/nces/naep?format=tsv&limit=1000'

# XLSX
curl 'https://api.tryopendata.ai/v1/datasets/nces/naep?format=xlsx&limit=1000' -o naep.xlsx

# Using Accept header
curl -H 'Accept: text/csv' 'https://api.tryopendata.ai/v1/datasets/nces/naep?limit=1000'

# Only year and score
curl '.../nces/naep?fields=year,score&limit=10'

# Combined with filters
curl '.../nces/naep?fields=year,score,jurisdiction_name&filter%5Bjurisdiction_name%5D=Illinois&sort=-year'

# CSV with specific columns
curl '.../nces/naep?fields=year,score&format=csv&limit=1000' -o subset.csv

curl '.../census/state-population?include_sources=true&limit=5'

curl '.../nces/naep?filter%5Bjurisdiction_name%5D=Illinois&sort=-year&fields=year,score&debug=true'

{
  "columns": [...],
  "rows": [...],
  "debug": {
    "query": {
      "filters": {"jurisdiction_name": {"eq": "Illinois"}},
      "sort": "-year",
      "fields": ["year", "score"]
    },
    "sql": "SELECT \"year\", \"score\" FROM read_parquet('...') WHERE \"jurisdiction_name\" = 'Illinois' ORDER BY \"year\" DESC LIMIT 100 OFFSET 0"
  }
}