Open data
Everything this site has read from the public records of Detroit Public Schools Community District (contracts, awards, payments and the organizations behind them) as one file, rebuilt every night and checked with the followthemoney library before it is published.
No file has been published yet.
License
The files are published under the Creative Commons Attribution 4.0 International license (CC-BY-4.0). You may share and adapt them for any purpose, including commercially, if you credit "OpenBookSchools (openbookschools.com)" and link to the license. The documents they are drawn from are public records; every record links to its source.
What is in a file
One FollowTheMoney entity per line (JSON lines, gzip): {"id", "schema", "properties", "datasets"}. Every value is a list of strings, as FtM writes them.
| FtM schema | What it is |
|---|---|
PublicBody | The district, its board and the Financial Review Commission. |
Company, Organization | Vendors and organizations in the site's entity registry. |
LegalEntity | A placeholder for a payee or contractor name as the documents print it, when it is not yet resolved to an entity. Always proposed. |
Contract | The contract an award belongs to: its title, number and amount as printed. |
ContractAward | One approval of a contract with a supplier (a Financial Review Commission exhibit row or a board item): amount, period, dates. |
Payment | One check-register row: the district pays the beneficiary an amount on a date. |
UnknownLink | A proposed match between a printed name (its placeholder) and an entity, from the name resolver. |
Directorship | An organization recorded as a director of another (people are never exported). |
Document | A source document every record above cites in `proof`. |
Proposed records
Most of what the site extracts is machine output that no person has reviewed yet. Such a record is never published as a plain fact: it carries summary = review_state: proposed and the dataset openbookschools_dpscd_proposed. Records a steward accepted, and everything they depend on, are in the dataset openbookschools_dpscd and carry no mark. A record is accepted only when every review it rests on is: a payment to an accepted entity through a link nobody has accepted is still proposed.
Ids, proof and sources
- Ids are ours, written in FtM's alphabet:
_and:become., soent_01M…isent.01M…and a paymentpay_ver_01M…:00010788ispay.ver.01M….00010788. ContractAward, Payment and UnknownLink also keep the exact id inrecordId. - A placeholder's id is
name.and the name's match key (name.GDI-SERVICE): the same key the name resolver uses, so every spelling of one name is one placeholder, with the other spellings asalias. proofpoints at theDocumentthe value was read from.sourceUrlholds the link to the quoted words in this site's document viewer (/d/<document>/p/<page>#sel=<start>-<end>) and the document's original address.- Only cited values are exported from documents. Entity details a steward entered (an address, a website) have no
proof. - No
Personentities. Payments to people (names that read as a person's) are left out of the files.
Document metadata
Every document has a metadata record in the format DocumentCloud uses, at /api/docs/<document id>?format=documentcloud: title, source (the publisher), published_at (the document's date), description and canonical_url (the address it was retrieved from), plus id, pages, created_at and updated_at. The description is a fixed sentence built from the publisher, the document type and the retrieval date; it never quotes the document.