Extend date range for 2016 through August (2016-08-31). This adds:
~46,000 active vessels
~8,000 likely / known-and-likely vessels
Remove extra January 1st from queries. (yyyy-01-01, YYYY-01-01) ➡️ (yyyy-01-01, yyyy-12-31). (Table_date_range is includes the date endpoints, it's not half open like most Python comparison constructs: https://cloud.google.com/bigquery/query-reference#table-date-range). This removes:
Changes
2016-08-31
). This adds:(yyyy-01-01, YYYY-01-01)
➡️(yyyy-01-01, yyyy-12-31)
. (Table_date_range is includes the date endpoints, it's not half open like most Python comparison constructs: https://cloud.google.com/bigquery/query-reference#table-date-range). This removes:CC/ @pwoods25443