Data downloads

Every shown fact, with its source, as files: so this site is not the only copy. The files carry what the pages show, and none of the program's raw reading of names, vote wording or motion sentences.

Independent, unofficial. Daylight is an independent, unofficial site run by gnoshcodes LLC. It is not affiliated with, endorsed by, or operated by the City of Clarksville, Montgomery County, the Clarksville-Montgomery County School System (CMCSS), or the Clarksville-Montgomery County Regional Planning Commission. The official record held by each body controls. The same notice is in README.txt beside these files.

Montgomery County Commission

• facts.json: All shown facts and their sources, in one file.
• officials.csv: One row per official.
• meetings.csv: One row per meeting.
• attendance.csv: Verified attendance, one row per member per meeting.
• roll_calls.csv: One row per roll call, with whether it is confirmed.
• votes.csv: One row per vote in a roll call.
• motions.csv: One row per motion, with its kind.
• items.csv: One row per agenda item.
• item_events.csv: Each appearance of an item at a meeting.
• sources.csv: Every source document, with its address and fetch date.
• seats.csv: Seat holder records: first and last meetings seen in roll calls, or a term as its source prints it.

Clarksville City Council

• city/facts.json: All shown facts and their sources, in one file.
• city/officials.csv: One row per official.
• city/meetings.csv: One row per meeting.
• city/attendance.csv: Verified attendance, one row per member per meeting.
• city/roll_calls.csv: One row per roll call, with whether it is confirmed.
• city/votes.csv: One row per vote in a roll call.
• city/motions.csv: One row per motion, with its kind.
• city/items.csv: One row per agenda item.
• city/item_events.csv: Each appearance of an item at a meeting.
• city/sources.csv: Every source document, with its address and fetch date.
• city/seats.csv: Seat holder records: first and last meetings seen in roll calls, or a term as its source prints it.

Clarksville-Montgomery County Regional Planning Commission

• rpc/facts.json: The meetings, agenda cases, confirmed motions and sources, in one file.
• rpc/meetings.csv: One row per listed meeting, with its agenda and minutes files and how many motions were and were not confirmed.
• rpc/cases.csv: One row per case on an agenda, in the agenda's own words.
• rpc/motions.csv: One row per confirmed motion in the minutes, as printed.
• rpc/sources.csv: Every agenda and minutes file collected, with its address and fetch date.

A motion appears in these files only when it is confirmed: every value read from the minutes' own words. A motion that is not confirmed is left out of them; the meeting's page links the minutes page that prints it.

Bids, awards and budgets

• finance.json: Bids and awards and the budget books, as the pages show them, with every source.
• solicitations.csv: One row per solicitation in the purchasing archive.
• bidders.csv: One row per bidder on a bid tab that was read, in the tab's printed order.
• fin_documents.csv: Every bid and award document, with its address and fetch date.
• budget_lines.csv: One row per budget line per column, as printed.
• budget_checks.csv: Each subtotal and total line per column: the printed total, the sum of its lines and the difference.

Every row names the document that prints it (source_url, page) and when it was fetched. In these files fetched_at is the day in Coordinated Universal Time (UTC), so a file fetched in the evening in Clarksville carries the next day; the pages show the day in Clarksville. A value held back as "Not confirmed" is empty in these files, with the check that held it.

In the Clarksville-Montgomery County Regional Planning Commission's files, a meeting row names the listing page it was taken from and its agenda and minutes files, and a sources row is the fetched file itself. A Clarksville-Montgomery County Regional Planning Commission motion that is not confirmed is not in its files at all; its meeting row counts it (motions_not_confirmed).

A text cell that would begin with =, +, - or @ (or a tab or carriage return) starts with an apostrophe, so a spreadsheet shows it as text; number columns are left as they are.