Correct spelling of "spreadsheet" in API.md

Correct spelling of "spreadsheet"

Add sumlevels 252 and 254 to SUMLEV_NAMES

Change certain error codes from 400 to 404

Add sumlevels 252 and 254 to the list of valid sumlevels. This is
related to censusreporter/cens...

Changed certain error codes from 400 to 404 to better reflect what
is actually happening (i.e., ...

This script now reads the annotations next to each table code (thanks
to the modifications to to...

Modify topic_scraper.py to detect annotations to table codes. This
searches the characters after...

The HTMLStripper class removes HTML tags from a page, leaving only
the contents of those tags (i...

table_tester scrapes all topic pages and checks every table referenced
on those pages for existe...

Table scraping now happens when the TopicPageParser is initialized,
using a regex search for tab...

Add a note that if the search_metadata table is rebuilt, the topic
scraper must be run again as ...

Group score computation logic into one block, rather than having
three separate blocks for each ...

The profile URLs returned only use the geoid now, rather than the
geoid and display name earlier...

Refactor compute_profile_score() and compute_table_score() into
one function, compute_score(). T...

Refactor table_search(), profile_search(), and topic_search() into
one function to make more sen...

The full text search endpoint now returns topics as well as profiles
and tables. There is work t...

topic_scraper.py now adds the URL to search_metadata. It was necessary
to include this in the da...

Removed query_script.py, as there have been many changes to the API
and to the database that wer...

The glossary page on Census Reporter is now scraped as well, and
it is indexed as a topic page a...

The functions created before now update search_metadata with topic
page entries. Data for the to...

Add functions to remove old topics from search_metadata (it should
be cleaned every time the scr...

Minor bugfixes; a couple of words were getting concatenated together,
which I took care of. The ...

TopicPageParser now scrapes individual topics pages, and it gets both
the relevant text on the p...

Topic scraper builds a list of topic pages and their URLs. The next
step is to scrape each page.

For local testing purposes, the app.S3 connection initialization block
is now inside a try excep...

Replacing apostrophes with spaces in the query string, which is
what postgres did when building ...

Sumlevel exclusion vetos were written as numbers when they should have
been strings.

Remove full text table search and profile search functions that are
entirely obsolete after the ...

The 'topics' field is now a list rather than a string, to stay
faithful to the original API format.

Removed pagination functionality added in the last commit. Removed
the PositiveInteger validatio...

Added another qwarg, "page", to api.py, which allows for one to obtain
more results. Different v...

Added functionality to search for only profiles or only tables (or,
by default, both). This was ...

This support is implemented on the database end. Refer to
abbreviations.md for instructions on h...

When there are multiple tables represented by a tabulation, we
need to choose one to link to tha...

The Python scripts now search tabulations, reflecting the changes to
the metadata search table. ...

The search_metadata table will now include tabulations, not tables.
This is done in an effort to...

Eliminated removal of stopwords on profiles, so that names such as
"Columbus, IN" did not get pa...

api.py now includes a function to search both tables and profiles,
implementing the functionalit...

In addition, modified query_script.py to take into account the
new data shapes from table_ and p...

In addition, modified the table querying script to target the combined
metadata table, simplifyi...

The first change is that profile_query_script.py and table_query_script.py
were refactored to ha...

Also begin commenting score.py script.

score.py takes the query 'ithaca' and shows the expected search results
alongside their custom c...

Also added minor clarification in full-text guide file and refactored a
few lines in api.py

The metadata_profile_script and metadata_table_script files were
updated with additional documen...

Add the line "add2virtualenv ." to the install instructions. Otherwise
locally running environme...

For local testing purposes, the app.S3 connection initialization block
is now inside a try excep...

The route is 2.1/geo/search. The query output still needs to be verified
to match the previous v...

The route is under /2.1/geo/search and the create script may be
incomplete in the information it...

Added a "alter table" statement to change the owner of
table_search_metadata to census.

/2.1/table/search now functions as a basic route for the full-text
search tabulation data.

Wrote a script that creates a table, table_search_metadata,
which stores information about the a...

The INSTALL.md was also edited to better reflect an OS X pylibmc
install.