> For the complete documentation index, see [llms.txt](https://www.csvpath.org/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://www.csvpath.org/getting-started/the-flightpath-data-examples/lookups.md).

# Lookups

{% hint style="success" %}
**Try these examples yourself.** They are built into FlightPath Data. You can download FlightPath Data free from [Microsoft](https://apps.microsoft.com/detail/9P9PBPKZ4JDF) or [Apple](https://apps.apple.com/us/app/flightpath-data/id6745823097) or [Github](https://github.com/dk107dk/flightpath)[ub](https://github.com/dk107dk/flightpath)
{% endhint %}

These example csvpaths create an index of zipcodes by city and perform lookups against it.

The data comes from [data.gov](https://data.gov): `catalog.data.gov/dataset/boundaries-us-zip-codes`. The extensive geo-coding data was removed for brevity.

<figure><img src="/files/9mUUYlgFyAIrTQDPVOdP" alt="" width="317"><figcaption></figcaption></figure>

To run this example:

1. Stage `Boundaries_US_Zip_Codes.csv` as a named-file called `zips`
2. Load `index_zipcodes.csvpaths` as a named-paths group called `zip_index`
3. Load `zipcoode_looksups.csvpaths` as a named-paths group called `zip_lookups`
4. Run `zip_index` against the named-file `zips`
5. Run `zip_lookups` against the named-file `zips`

Staging named-files and loading named-paths groups are options on the context menu when you right-click a filename in the project directory tree on the left.

To run, right click on either the named-file folder or the named-paths folder in the windows on the right-hand side and select `New run`.

The result is a variable `"a"` with the value of Boston's zipcode<br>