[Integrations](https://spiral.ai/integrations) › [opencode](https://spiral.ai/integrations/opencode) › [FEMA OpenFEMA dataset query](https://spiral.ai/integrations/opencode/fema-openfema-dataset-query)

# How to Use FEMA OpenFEMA dataset query in opencode

Returns selected records from an OpenFEMA dataset, including flood insurance, assistance, and mitigation data. Use it for a focused question that needs more than disaster declaration summaries.

|  |  |
| --- | --- |
| Model | FEMA OpenFEMA dataset query |
| Available through | Alexandria |
| Category | Public Records |
| Price | $0.00873 per call. |
| Returns | json |
| Runs | In the background |
| Setup | About 2 minutes, no API key |

## Prompts to try with FEMA OpenFEMA dataset query in opencode

- Use FEMA OpenFEMA dataset query to retrieve Texas declaration records for 2024 and add a table of designated areas to this project's report.
- Use FEMA OpenFEMA dataset query to look this up and give me the result as a table. Save the result in ./assets.
- Pull the latest numbers from FEMA OpenFEMA dataset query and tell me what changed since last week.
- Check FEMA OpenFEMA dataset query and summarize what you find in three bullet points.
- Pull the newest data from FEMA OpenFEMA dataset query and give me the result as a table.

## How to set up FEMA OpenFEMA dataset query in opencode

Pick the way that suits you. Each takes about two minutes.

### Use Spiral's MCP server

1. **Add the server**: Leave out `--global` to add Spiral to the current project only. No header and no client ID or secret: opencode registers itself with Spiral.

```bash
opencode mcp add spiral --global --url https://api.spiral.ai/mcp
```

2. **Sign in**: Your browser opens. Sign in to Spiral, pick the organization and click Authorize, then return to the terminal. No API key. Inside opencode, `/mcps` starts the same sign-in.

```bash
opencode mcp auth spiral
```

3. **Check it**: Spiral shows as connected.

```bash
opencode mcp list
```

### Use the Spiral skill

1. **Send opencode this message**: Your agent reads Spiral's skill and sets itself up.

```
set up https://spiral.ai/SKILL.md
```

2. **Sign in or paste a key**: Approve Spiral in the browser, or give the agent a key from the console.

### Use the Spiral CLI

1. **Install and sign in**: Installs the Spiral CLI, signs you in and adds its skill to your coding agents.

```bash
npx -y spiral-cli@latest init
```

### Call the Spiral API

1. **Create an API key**: In the console, under API keys.

2. **Run FEMA OpenFEMA dataset query**: One request; the result comes back by polling or a webhook.

```bash
curl https://api.spiral.ai/v1/runs \
  -H "Authorization: Bearer $SPIRAL_API_KEY" \
  -H "Content-Type: application/json" \
  -H "Idempotency-Key: $(uuidgen)" \
  -d '{
    "provider": "alexandria",
    "model": "fema-gov/us-disaster-assistance/query_dataset",
    "input": {
      "entity": "<entity>",
      "version": 1
    }
  }'
```

Then paste one of the prompts above: opencode finds FEMA OpenFEMA dataset query on Spiral, shows the price and runs it.

Setup guide in the docs: https://spiral.ai/docs/quickstarts/opencode

## FEMA OpenFEMA dataset query tools and prices

- [FEMA · Query dataset](https://spiral.ai/tools/alexandria/fema-gov/us-disaster-assistance/query_dataset) (Alexandria): $0.00873 per call.

## Settings you can ask for

| Setting | Allowed values | Default | Description |
| --- | --- | --- | --- |
| top | 1 to 1000 | 100 | Rows per page (OpenFEMA $top). |
| skip | 0 to … | 0 | Rows to skip (OpenFEMA $skip); pass the previous page's `next_skip`. |
| filter |  | — | Raw OData $filter, e.g. `disasterNumber eq 4931`, `state eq 'TX' and declarationDate ge '2025-01-01T00:00:00.000Z'`. Strings in single quotes; `and`/`or`/`eq`/`ne`/`gt`/`ge`/`lt`/`le`/`in`/`substringof`/`startswith`. |
| select |  | — | Comma-separated field names to return (OData $select). Pattern: ^[A-Za-z0-9_]+(,\s*[A-Za-z0-9_]+)*$. |

## What can you do with FEMA OpenFEMA dataset query in opencode?

Build a county disaster-history report that keeps designated areas separate from distinct declarations. Add collection updates and publication checks so the project's FEMA evidence can be refreshed when its source data changes.

### County mitigation plan evidence

Build a declaration history for Harris County, Texas, inspect the records behind selected events, and add relevant OpenFEMA program data. Maintain the collection through updates and check dataset and National Risk Index publication status before revising the plan's evidence.

### Public disaster-history dashboard

Create a dashboard of declared events and designated areas for Florida. Collect the historical records, inspect selected rows, incorporate focused program queries, and maintain revisions; show publication checks alongside any separately maintained National Risk Index analysis.

### Regional business continuity review

Prepare a review of declared disasters affecting business locations in Texas and Louisiana. Use historical collections, focused searches, record inspection, and program queries to document the events, then check record revisions and publication changes before the next review.

### Maintain a disaster research collection

Maintain a research collection comparing California declaration history with selected OpenFEMA program records. Collect a baseline, inspect individual observations, apply supported updates, and track dataset and National Risk Index publication changes that could require rerunning the analysis.

### Check a declaration-area claim

Investigate which areas a particular disaster declaration includes. Search by disaster number, retrieve the selected records, and compare their designated areas before citing them in a report.

### Compare declaration history across states

Compare declared events in Texas, Louisiana, and Florida over a defined period. Collect every page and count distinct disaster numbers so declarations with more designated areas do not inflate the comparison.

## Overview

- [Alexandria](https://spiral.ai/providers/alexandria)
- [All opencode guides](https://spiral.ai/integrations/opencode)

## FEMA OpenFEMA dataset query in other agents

- [Amp](https://spiral.ai/integrations/amp/fema-openfema-dataset-query)
- [ChatGPT](https://spiral.ai/integrations/chatgpt/fema-openfema-dataset-query)
- [Claude](https://spiral.ai/integrations/claude-desktop/fema-openfema-dataset-query)
- [Claude Code](https://spiral.ai/integrations/claude-code/fema-openfema-dataset-query)
- [Cline](https://spiral.ai/integrations/cline/fema-openfema-dataset-query)
- [Codex](https://spiral.ai/integrations/codex/fema-openfema-dataset-query)
- [Cursor](https://spiral.ai/integrations/cursor/fema-openfema-dataset-query)
- [Devin](https://spiral.ai/integrations/devin/fema-openfema-dataset-query)
- [dots](https://spiral.ai/integrations/dots/fema-openfema-dataset-query)
- [Factory Droid](https://spiral.ai/integrations/factory-droid/fema-openfema-dataset-query)
- [Gemini](https://spiral.ai/integrations/gemini/fema-openfema-dataset-query)
- [Gemini CLI](https://spiral.ai/integrations/gemini-cli/fema-openfema-dataset-query)
- [Google Antigravity](https://spiral.ai/integrations/antigravity/fema-openfema-dataset-query)
- [goose](https://spiral.ai/integrations/goose/fema-openfema-dataset-query)
- [Grok](https://spiral.ai/integrations/grok/fema-openfema-dataset-query)
- [Grok Build](https://spiral.ai/integrations/grok-build/fema-openfema-dataset-query)
- [Hermes](https://spiral.ai/integrations/hermes/fema-openfema-dataset-query)
- [Instinct](https://spiral.ai/integrations/instinct/fema-openfema-dataset-query)
- [Manus](https://spiral.ai/integrations/manus/fema-openfema-dataset-query)
- [Muse](https://spiral.ai/integrations/muse/fema-openfema-dataset-query)
- [Muse Code](https://spiral.ai/integrations/muse-code/fema-openfema-dataset-query)
- [n8n](https://spiral.ai/integrations/n8n/fema-openfema-dataset-query)
- [Notion](https://spiral.ai/integrations/notion/fema-openfema-dataset-query)
- [OpenClaw](https://spiral.ai/integrations/openclaw/fema-openfema-dataset-query)
- [Perplexity](https://spiral.ai/integrations/perplexity/fema-openfema-dataset-query)
- [Raycast](https://spiral.ai/integrations/raycast/fema-openfema-dataset-query)
- [VS Code](https://spiral.ai/integrations/vscode/fema-openfema-dataset-query)
- [Windsurf](https://spiral.ai/integrations/windsurf/fema-openfema-dataset-query)
- [Zapier](https://spiral.ai/integrations/zapier/fema-openfema-dataset-query)

## More opencode guides

- [FEMA National Risk Index release status](https://spiral.ai/integrations/opencode/fema-national-risk-index-release-status)
- [FEMA OpenFEMA dataset status](https://spiral.ai/integrations/opencode/fema-openfema-dataset-status)
- [FEMA National Risk Index location details](https://spiral.ai/integrations/opencode/fema-national-risk-index-location-details)
- [FEMA OpenFEMA record details](https://spiral.ai/integrations/opencode/fema-openfema-record-details)
- [FEMA National Risk Index location comparisons](https://spiral.ai/integrations/opencode/fema-national-risk-index-location-comparisons)
- [FEMA OpenFEMA record updates](https://spiral.ai/integrations/opencode/fema-openfema-record-updates)

## Questions about FEMA OpenFEMA dataset query in opencode

**Can opencode use FEMA OpenFEMA dataset query?**

Yes. Add Spiral to opencode as an MCP server, and opencode can find and run FEMA OpenFEMA dataset query like any built-in tool.

**How much does FEMA OpenFEMA dataset query cost in opencode?**

$0.00873 per call. You pay from your Spiral balance as you go, with no subscription, and a failed run is not charged. Your opencode plan is separate.

**Do I need an Alexandria account to use FEMA OpenFEMA dataset query in opencode?**

No. Spiral runs FEMA OpenFEMA dataset query on its own Alexandria account. You sign in to Spiral once and never paste a key.

**How long does it take to set up FEMA OpenFEMA dataset query in opencode?**

About two minutes: add the server, then sign in, then check it.

**Does opencode wait while FEMA OpenFEMA dataset query runs?**

FEMA OpenFEMA dataset query runs in the background. opencode starts the run, checks on it and gives you the json when it's ready.

**How far back does FEMA's disaster history go?**

The declaration history starts in 1953. County information is unavailable before 1964, and FEMA describes historical Fire Management records as partial.

**Does one declaration record equal one disaster?**

No. Disaster Declarations Summaries is organized at the county level, so one disaster can appear in multiple records. Count distinct disaster numbers to count declarations.

**What geographic detail does the National Risk Index provide?**

The National Risk Index provides a baseline relative risk measurement for counties and Census tracts across 18 natural hazards. It describes community risk rather than an individual property's assessment.

**Does every OpenFEMA dataset follow the same update schedule?**

OpenFEMA publishes update frequency separately for each dataset. Its dataset metadata also identifies versions and deprecation status, so freshness should be checked against the particular dataset being analyzed.

**Can previously published FEMA records change?**

Yes. FEMA's official collection example checks whether a dataset has refreshed and then retrieves new or refreshed records. A declaration-history collection therefore needs to account for revisions as well as additions.

