README.md

Data from https://www.speechinteraction.org/TNG/index.html loaded into SQLite.

curl 'https://www.speechinteraction.org/TNG/teaearlgreyhotdataset.json' | python3 -c '
import sys
import json

data = json.load(sys.stdin)
processed = []

for episode, moments in data.items():
    for timestamp, details in moments.items():
        processed.append(dict(details, episode=episode, timestamp=int(timestamp)))

print(json.dumps(processed, indent=2))
' | sqlite-utils insert startrek.db interactions -

startrek.db

Try this in Datasette Lite here: https://lite.datasette.io/?url=https%3A%2F%2Fgist.githubusercontent.com%2Fsimonw%2Fdaab211baeebdffba603ca86340ae296%2Fraw%2Fde09d34e72ed0f37c1284b8f7225b21a6da78d59%2Fstartrek.db#/startrek/interactions?_facet_array=type&_facet=char&_facet_array=domain&_facet_array=sub-domain&_facet=pri_type