Skip to content

Latest commit

 

History

History
123 lines (86 loc) · 2.99 KB

CHANGELOG.md

File metadata and controls

123 lines (86 loc) · 2.99 KB
Raw

2021-05-28.01

  • Items: add primary_item_link_confirmed_by

2021-05-27.01

  • Items: rename item_list1 to folder.
  • Items: update query. item-list relation is now many-to-one, not many-to-many.
  • ID columns: format without commas (thanks to Workbench's new Arrow API v1).

2021-03-26.01

  • Conversations: add conversation_language column.

2021-01-13.01

  • Items: add primary_item_link_updated_at, to (temporarily) distinguish between machine-confirmed and human-confirmed. confirmed-sibling and suggested-sibling relationships.
  • Items: add facebook_share_count, facebook_comment_count, facebook_reaction_count.

2021-01-13.01

  • Items: enforce at-most-one primary item, and filter for only confirmed-sibling and suggested-sibling relationships.
  • Items: add facebook_share_count, facebook_comment_count, facebook_reaction_count.

2021-01-07.01

  • Conversations: fix outcome for post-2020-12-23 conversations (which are stored differently).
  • Conversations: add billable_conversation_id, to help evaluate costs

2020-12-23.01

  • Items: add primary_item_relationship_type column

2020-11-19.01

  • Allow querying items even when the team has no verification statuses.
  • Allow querying items whose status IDs are invalid.

2020-10-29.01

  • Tasks: make "image" answers URLs

2020-10-28.01

  • Tasks and metadata: add first_note column
  • Items: add item_notes column (all notes, newline-separated)
  • Items: add item_language column
  • Nix "Submissions and Claims" query
  • Dictionary-encode columns like "item_language". Should lead to smaller Parquet files (because columns can be encoded to be tiny).

2020-10-27.01

  • Conversations: add resource_title column

2020-10-19.01

  • Items: look up item_status label.
  • [dev-mode] allow running from the command line.
  • [internal] dictionary-encode username and status columns.

2020-10-15.01

  • Items: add item_analysis_title, item_analysis_content
  • Items: change item_url to media_url and item_derived_*** to media_***
  • Items: add item_created_at, item_created_by
  • Items: add item_tags
  • Tasks: hide JSON characters in image filenames, so they look nice

2020-10-14.01

  • Tasks: hide JSON characters in multiple-choice task/metadata responses, so they look nice.
  • Conversations: prevent duplicate rows.
  • Items: add item_derived_published_at, item_archive_org_url, item_derived_description, item_derived_author_name, item_derived_author_url.

2020-10-13.01

  • Tasks: Hide most JSON characters in task/metadata answers, so they look nice.

2020-09-25.01

  • Add Conversations query
  • Add Items query

2020-08-25.01

  • Rename "Tasks", "Tasks and Metadata"

2020-08-17.01

  • Add Tasks query

2020-07-28.01

  • Initial deploy. "Requests and Claims" sheet, alpha version.