Table: canada_disasters
Columns: disaster
type
location
deaths
date

Question: What type of disaster is rms atlantic categorized in that was located in Nova Scotia?
SQL: SELECT "type" FROM canada_disasters WHERE "location" = 'nova scotia' AND "disaster" = 'rms atlantic'

Question: What is the type of disaster that the Arrow Air Flight 1285 categorized in?
SQL: SELECT "type" FROM canada_disasters WHERE "disaster" = 'arrow air flight 1285'

Question: What is the disaster that was located in Ontario with 223 deaths?
SQL: SELECT "disaster" FROM canada_disasters WHERE "location" = 'ontario' AND "deaths" = '223'

Question: How many deaths were there during the shipwreck in 1873?
SQL: SELECT "deaths" FROM canada_disasters WHERE "type" = 'shipwreck' AND "date" = '1873'

Question: Where was the disaster located that took place on 1916?
SQL: SELECT "location" FROM canada_disasters WHERE "date" = '1916'