departments or agencies? adding new ones?

The narrative text describes these as agencies. But the table column head says "Department". Which is this a list of?

You have both "agency" and "name" in the data.json file. Is this "department name" of the department that the "agency" is in?

It makes more sense to me that "agency" would be a name of an agency and that "department" would be the name of the department that the agency is in. And there should be both an "Agency" and "Department" column.

Does this make sense?

And I have an additional source of data.

You all have 106 agencies in here. There is a state site, the list of agencies of which reports are required by the legislature (http://agencyreports.ca.gov/reportdue) and this list contains 392 agencies. I already have MySQL tables which contain this list and a table for the reports required of each agency. I can add these without adding duplicates. Reportees are usually the legislative committee that is asking for the report, or the Governor, or such as that. Let me me what might be best done here.

```
CREATE TABLE `agencies` (
`pk` int NOT NULL,
`id` int DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
PRIMARY KEY (`pk`)
);

CREATE TABLE `reportee_joins` (
`report_pk` int NOT NULL DEFAULT '0',
`reportee_pk` int NOT NULL DEFAULT '0',
PRIMARY KEY (`report_pk`,`reportee_pk`)
);

CREATE TABLE `reportees` (
`pk` int NOT NULL,
`name` varchar(255) DEFAULT NULL,
PRIMARY KEY (`pk`)
);

CREATE TABLE `reports` (
`pk` int NOT NULL,
`agency_pk` int DEFAULT NULL,
`title` varchar(255) DEFAULT NULL,
`authority` varchar(255) DEFAULT NULL,
`descrip` varchar(255) DEFAULT NULL,
`duedatedesc` varchar(255) DEFAULT NULL,
`duedate` char(10) DEFAULT NULL,
PRIMARY KEY (`pk`)
);

select count(*) from agencies;
+----------+
| count(*) |
+----------+
| 392 |
+----------+

select count(*) from reportees;
+----------+
| count(*) |
+----------+
| 115 |
+----------+

select count(*) from reports;
+----------+
| count(*) |
+----------+
| 1823 |
+----------+
```