Wikidata:Property proposal/Bechdeltest-ID

Bechdel Test Movie List ID edit

Originally proposed at Wikidata:Property proposal/Authority control

DescriptionFilm-ID on http://bechdeltest.com/
RepresentsBechdel test (Q4165246)
Data typeExternal identifier
Domainfilm (Q11424)
Allowed values[1-9]\d*
Example
Sourcehttp://bechdeltest.com/
External linksUse in sister projects: [ar][de][en][es][fr][he][it][ja][ko][nl][pl][pt][ru][sv][vi][zh][commons][species][wd][en.wikt][fr.wikt].
Formatter URLhttp://bechdeltest.com/view/$1/
Motivation

Verlinkungen der Bechdeltest-DB.  – The preceding unsigned comment was added by Ogmios (talk • contribs) at 20:39, 3 December 2017‎ (UTC).[reply]

Discussion
Jane023 (talk) 14:40, 16 October 2017 (UTC), focus on artists and artists' sitters/models[reply]
Exilexi (talk) 15:57, 16 October 2017 (UTC), focus on women in gaming[reply]
Rosiestep (talk) 18:43, 16 October 2017 (UTC), focus on: (a) learning!, (b) data visualization, (c) community organizer[reply]
Daniel Mietchen (talk) 23:36, 16 October 2017 (UTC), focus on researchers[reply]
Checkingfax (talk) 09:19, 17 October 2017 (UTC)[reply]
Anthere (talk) 17 October 2017 (UTC), focus on African women
Shani Evenstein (talk) 13:52, 17 October 2017 (UTC)[reply]
Armineaghayan (talk) 19:55, 17 October 2017 (UTC)[reply]
MartinPoulter (talk) focus on awards, e.g. Carolyn Shaw Bell Award (Q28826510)
Ambrosia10 (talk) 18:34, 8 December 2017 (UTC), focus on women scientists and artists.[reply]
Spinster 💬 20:12, 11 January 2018 (UTC), quite interested in creative women, and much more.[reply]
Ohmyerica talk 01:33, 26 January 2018 (UTC)[reply]
Geraki (talk) 19:00, 2 April 2018 (UTC)[reply]
Bodhisattwa (talk) 07:32, 3 April 2018 (UTC)[reply]
Mlemusrojas (talk) 19:33, 12 June 2018 (UTC), focus on artists and researchers[reply]
Alexmar983 (talk) 22:18, 22 August 2018 (UTC)[reply]
Camelia (talk) 15:23, 31 August 2018 (UTC)[reply]
Wallacegromit1 (talk) 08:30, 12 March 2020 (UTC), focus on works by historical women (mostly Ancient to Medieval)[reply]
Mathieu Kappler (talk) 15:15, 12 December 2020 (UTC)[reply]
Patafisik (talk) 13:38, 25 November 2021 (UTC)[reply]
Idieh3 (talk) 11:05, 8 March 2022 (UTC)[reply]
Daieuxetdailleurs (talk) 19:44, 9 November 2022 (UTC)[reply]
Marianne Casamance (talk) 15:40, 18 February 2023 (UTC)[reply]
Thepresidentess (talk) 10:16, 24 September 2023 (UTC), I focus on female authors and women in STEM.[reply]
Dactylantha (talk), focus on historical women within existing archives and manuscript collections within GLAM Kitty Jonk (talk) 17:27, 30 January 2024 (UTC)[reply]
  Notified participants of WikiProject Women. So that you know it exists. Thierry Caro (talk) 03:15, 10 December 2017 (UTC)[reply]

I created Q45171911 and Q45172088 so that we can use has characteristic (P1552) to indicate the status. Example: Nothing Left to Do But Cry (Q19311). − Pintoch (talk) 11:41, 10 December 2017 (UTC)[reply]

I've imported most of the database by reconciling via the IMDB ids they provide. And here is a query to have an idea of the data:

#defaultView:LineChart
SELECT ?year (COUNT(?film) AS ?nb_films) ?statusLabel WHERE {
  ?film wdt:P31/wdt:P279* wd:Q11424 ;
            wdt:P577 ?date ;
            wdt:P1552 ?status.
  BIND(STR(YEAR(?date)) AS ?year)
  VALUES ?status { wd:Q45171911 wd:Q45172088   }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY ?year ?statusLabel
Try it!

.

I'm sure there's plenty of interesting queries to do with the data! − Pintoch (talk) 13:05, 11 December 2017 (UTC)[reply]