OpenBookSchools

Show Your Work

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 schemaWhat it is
PublicBodyThe district, its board and the Financial Review Commission.
Company, OrganizationVendors and organizations in the site's entity registry.
LegalEntityA placeholder for a payee or contractor name as the documents print it, when it is not yet resolved to an entity. Always proposed.
ContractThe contract an award belongs to: its title, number and amount as printed.
ContractAwardOne approval of a contract with a supplier (a Financial Review Commission exhibit row or a board item): amount, period, dates.
PaymentOne check-register row: the district pays the beneficiary an amount on a date.
UnknownLinkA proposed match between a printed name (its placeholder) and an entity, from the name resolver.
DirectorshipAn organization recorded as a director of another (people are never exported).
DocumentA 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

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.