Importing my spreadsheet was easy, but when I used the query wizard, I asked to see records where year =1911 (or "1911" in case someone was confused about its type), I got all records. Here is the SQL the wizard created: