The website already offers memorial cards and and an HTML slideshow. The slideshow can be downloaded as a complete webpage, however this is not so portable as a PDF (print to PDF doesn't seem to work).

Is this something we need to look at? Is the website/data safe from malicious attack?

Currently there are two ways to access the data

1. Export as CSV for specific time period from website - export also includes photos, thumbnails (with photo on transgender flag and short description), qr codes in separate folders.
2. Download monthly CSVs from Bitbucket repo.

An R package might

• Have an update for each TDoR period
• Contain combined CSV only? (links to permanent page for each individual)
• Vignette with example code to produce global summaries, e.g. maps etc

Questions

• Does this provide much value over existing facilities?
• Would it be better to wait until/unless website has JSON API and instead write a package to extract using the API for analysis?

Would be good to have a paragraph and link on https://en.wikipedia.org/wiki/Transgender_Day_of_Remembrance

Currently we have data from 2010.

https://transrespect.org/en/trans-murder-monitoring/tmm-resources/ (current main source) goes back to 2009; we have a Python script to extract the data.

https://docs.google.com/spreadsheets/d/10_JeZ7LEIRhvewTCoL5mVkH6MQJzf7fSXl4-P6QJ0v0/edit#gid=0 from https://tdor.info has data from 1970 to 2012.

• has the data since 2009 been merged with the tgeu data?
• can we write a script to extract the pre 2009 data and create monthly csvs?
• has the data since 2012 on https://tdor.info been merged?

A photo and some background information about the person helps us to reflect on their lives, while news reports help us to validate the report of their death and understand more about the reasons behind it.

An on-going task is to fill the gaps in the database, c.f. #2.

Currently there is a Python script to extract data from the official Trans Murder Monitoring report. Is there a script for comparing/merging this data with the monthly CSVs produced during the year?

Is it worth searching Twitter or other sources for reports/pictures/information which can then be checked and easily transferred?

Adding an API is one thing that has been considered as a feature to be added to the website.

If we have people with relevant expertise, this could be something to work on.

It might be useful to have a script to identify records where we are missing information, to make it easy for people who want to contribute by researching and filling in the gaps.

Although TDoR emphasises remembering the individuals, infographics can help to show the scale of the issue and provide some sobering facts.

For 2016 and 2017, TMM have produced some infographics:
https://transrespect.org/wp-content/uploads/2017/11/TvT_TMM_TDoR2017_Infographics_EN.png
https://transrespect.org/wp-content/uploads/2016/11/TvT_TMM_TDoR2016_Infographics_EN.png

Potential areas for exploration

• Trends over time (TMM only look at 2015-2017)
• Causes of death in different regions
• Impact of political/legal changes

The style of graphics could also be something to consider - how suitable is it for sharing on Twitter or Facebook for example?

The following English keywords are helpful for finding new cases to add to the Transgender Day of Remembrance dataset:

Transvestite
Transsexual
Transgender
Trans
Man dressed as woman

Dead
Murdered
Killed
Stabbed
Shot
Mutilated
Dismembered
Suicide
Beaten

We would like to find people to translate these to the following languages (using equivalent keywords rather than direct translation if more relevant):

• Albanian
• Amharic
• Arabic
• Bahasa Indonesia
• Belarussian
• Cantonese
• Farsi
• Hausa
• Hindi
• Hungarian
• Igbo
• Indonesian
• Japanese
• Korean
• Oromo
• Malaysian
• Mandarin
• Polish
• Portugese
• Russian
• Serbo-Croat
• Shona
• Spanish
• Swahili
• Tagalog
• Thai
• Turkish
• Yoruba
• Zulu

See https://github.com/rlgbtq/TDoR2018/tree/master/Data for details on how to contribute.

At the moment the website is quite hard to find by search (our datathon ranks higher if we search for data! https://www.google.co.uk/search?q=transgender+day+of+remembrance+data). Are there things we can do to improve this, by technical means, social media or other actions?

A contact form could be added to the website for people to submit new reports/updates.

Desirable features:

• encryption to keep information private until it is verified
• captcha to avoid spam (should be accessible to visually impaired)
• related to separate email address with good spam protection (I know a provider we can ask who may provide a free one for a cause like this)
• structured to make it easy to merge with existing data files via a script (once verified)

At the moment the global map in the slideshow on the homepage is just updated periodically.

It would be great to have a script that automatically updates the map (or creates a similar map) when the database is re-built.

The website currently allows people to view filtered data as a map.

A dashboard could be created to allow more interactive exploration of the data. Initially this could be based on a static version of the data, potentially in future this could use an API to display the latest data.

c.f. #7 on creating infographics.