<p>If you look at Table UnitData, you can see that it appears to be a unique entity ID. To see this, I joined the distinct values of the the Table AFRNotes with the Table UnitData.</p>
<pre><code>    SELECT DISTINCT AFRNotes.Code, UnitData.UnitName, UnitData.Description
    FROM AFRNotes INNER JOIN UnitData ON AFRNotes.Code = UnitData.Code;
</code></pre>
<p>Which gives the following results:</p>
<p><a href="https://i.sstatic.net/Fm9zt.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/Fm9zt.png" alt="join AFRNotes and UnitData" /></a></p>

CC BY-SA 4.0
2022-11-07T22:05:03.033Z
2022-11-07T22:05:03.033Z
BKay
<p>What does the code field mean in <a href="https://illinoiscomptroller.gov/constituent-services/local-government/local-government-division/financial-databases/?" rel="nofollow noreferrer">the state of Illinois's financial data</a>?</p>
<p><a href="https://i.sstatic.net/t42Gr.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/t42Gr.png" alt="Snapshot of table AFRNotes from 2022 data" /></a></p>

<finance><data-request>
Trouble Understanding Government's Financial Databases
Claire
# Trouble Understanding Government's Financial Databases

(Asked by: username_0 on 2022-11-06)

What does the code field mean in [the state of Illinois's financial data](https://illinoiscomptroller.gov/constituent-services/local-government/local-government-division/financial-databases/?)?

[![Snapshot of table AFRNotes from 2022 data](https://i.sstatic.net/t42Gr.png)](https://i.sstatic.net/t42Gr.png)

**Tags:** finance, data-request


---

## 1 answers

### Answer by username_1 on 2022-11-07. Score: 0

If you look at Table UnitData, you can see that it appears to be a unique entity ID. To see this, I joined the distinct values of the the Table AFRNotes with the Table UnitData.

```
    SELECT DISTINCT AFRNotes.Code, UnitData.UnitName, UnitData.Description
    FROM AFRNotes INNER JOIN UnitData ON AFRNotes.Code = UnitData.Code;

```

Which gives the following results:

[![join AFRNotes and UnitData](https://i.sstatic.net/Fm9zt.png)](https://i.sstatic.net/Fm9zt.png)


---

