99of9
Joined 7 November 2012
| Babel user information | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||
| Users by language |
If you use Chrome or Firefox, please consider using Wikidata:Entity Explosion.
If you're from Australia, please consider joining Wikidata:WikiProject Australia.
Useful links edit
- wikishootme then click through to wdfist
- reasonator for pretty wiki-like view of wikidata
- mix'n'match to connect identical items
- wikimap wikidata + commons items
- wikidata game
- QuickStatements
- Quickstatements 2
- Wikidata down under resources Wiki for researchers by Thomas Shafee
- Books: sources, work vs edition, Wikidata:WikiProject_Books
- Resolve authors link works
- Wikidata content monitor (stats)
- vandalism dashboard
- my pawsPAWS dashboard example Egonw's github query display
- finding related properties
- Quarry for SQL queries
- Tabernacle for tables comparing the properties and labels of a set of items. Properties without he labels
- Knowledge Grapher for visual relationships between lists of items
- images for enwiki
- Wikidata Concept Tree tree visualisation
- GLAM resources
- DataCite USyd
- Depictor
- OSM Overpass-Turbo try query wizard "name=* and wikidata!=* and type:relation and route!=*" to find named relations which don't have a wikidata ID
- Histropedia from SPARQL
- NavelGazer edit count categorizer
- User:99of9/notes other notes
Show edit
Queries edit
All queries written by me are released under a CC-0 license.
WDQS edit
- properties which are instances of a particular item, here "Wikidata property for items about works"
- parent taxa of komodo dragon, frog family referenced in Rdmpage's twdg talk
- Schools in Australia ... now recursive? better
- subclasses of schools
- children of clergy
- Sydney Archbishops inc wiki article
- Prime Ministers, dates & spouses
- birth and death locations of a group of people rugby/AFL birth map
- all instances of subclasses* of volcanoes
- Minerals all subclasses of mineral all instances of mineral instances of subclasses of mineral
- country of origin !Australia but citizenship is, citizenship=Australia but not born here
- states and highest offices (many missing)
- Given names born in Australia containing T
- Genders born in Australia
- Australian-born politician cast-members or members of Australian state or federal parliaments who are also cast members
- statues in Manhattan
- powerplants in Australia
- Cast ages gender histogram
- books by publisher
- books per year by publisher
- elements named after
- confederate depiction timeline attempt to reproduce [1]
- Australian things named after
- timeline of a person (Krebs)
- university pageranking
- named after chain
- Australian philosophers Australian musicians
- SUCS near elements test test 2 test 3 best?
- Scientific article gender-age distribution
- Chemical compounds with the least, most statements
- mass vs boiling point (ignores units) with units Celsius only
- copublishers COE journals
- author name
- properties for diseases
- properties for compounds full count for a specific property
- Aussie OSM relations for use with Kartographer maps example: w:Coburg, Victoria
- USA newspapers missing USNPL ID map global map by sitelinks en-wiki infoboxes infoboxes joined to USNPL in a 150 km circle
- Trove Australia newspaper wiki coverage
- Australia a signatory all treaties
- ChemID counts h/t Egonw here
- chemistry topics
- Award winners age with time h/t
- USyd graduate birthdates h/t with pics
- vice chancellors
- locality table
- isotope halflives and abundance
- indigenous politicians
- famous old people gallery
- WA coast types
- sibling birth gap histogram
- colourful ScOT more colourful snippet around chemical element (Q11344), snippet around water (with node sizes by sitelinks) combination query with Scholia co-occurring topics, around water
- Chemistry journal articles per capita published by month plotted for each country an author can be identified with via their citizenship or employment, linechart
- monarchs with the most monarch-kids
- female pre-1900 botanists/botanical collectors
- mapped birthplaces within small time range
- cemetery map
- ford map, NSW rules the world
- converts arbitrary URLs to WD items
- check for a specific URL faster
- railway map with lines between points better railway map
- cluster map from Simon Cobb tinyurl.com ycnjsylv
- Hollywood partners
- Federal Department of Health history
- NZ anniversaries mine disaster anniversaries
- ANMM sea muesum creators pictures
- WikiSource items with Wikidata items with OCLC control numbers, validated only (by badge) validated only (by wmapi)
- worldwide disasters map h/t Daniel Mietchen
- articles missing descriptions (for auto-labels?)
- languages using words for planet h/t Denny V
- first librarian (filtering out "unknown value")
- earliest scientific papers (sorting a massive set with range safe h/t)
- song data
- Lontar part of [2] presented at WOW2022
- world map according to borders shared
- New Zealanders citizenship/place of birth
- NZ Public Domain Day
- NZ thesis main subject frequency histogram with exploding links for details
WCQS edit
- Depictions of axes including subcategories.
Dashboards edit
(see InteGraality)
Keep clean edit
- items near Australia with no admin district, in SA, NT, WA, QLDNSW VIC TAS
- items with admin* Australia, but no country (not even "no value")
- Geonames duplicates: in Australia
- Geonames duplicates: islands
- protein families which are not subclasses of protein
- families of XX which are not subclasses of XX
- populations with determination method with a date which don't have a date
- nearby island merge candidates
- geonames merge candidates with multiple check no country no check
- types of Australian items with no identifiers query inside a query to give list of each type
- ceb suburbs with no ssc
- populations from different years merged into one statement by quickstatements
- differences between Geonames IDs and Openweather IDs
Properties edit
- country trajectories
- language translations, as a bar chart
- P4014 ASGS2011 duplicates lookup code items with multiple SSCs Petscan Mismatches SSC aliases missing descriptions missing instances
- P4093 ASGS2016 duplicates lookup code items with multiple SSCs state map
- Maybe we need a qualifier like confidence value (Q31834028) with possible values very good (according to the Australian Bureau of Statistics) (Q31833890), good (Q31833911), acceptable (Q31833947), poor (Q31833979), very poor (Q31833994)
- Indonesian Small Islands Directory ID (P4227) all islands merge candidates references to DPKI URL
- Commlaw IDs responsible departments amendment network colourful amendment network filtered by age both with depts mismatched titles
to propose edit
- harmonized tariff schedule
- WHO clinical trials
- wood database
- NSW Beach Profile Database (Q65455527), only 150 items
- MolluscaBase = Magallana (Q47463935)
- Tropical Lichens
- iNaturalist user
- individual research vocabularies, find them from Wikidata:Property proposal/Research Vocabularies Australia ID
- academic sexual misconduct (USA)
- Sketchfab (Q7534755) creators, e.g. Queensland Museum
- histHub ID (Q109382927) new user attempted to create property
Mix'n'Match notes edit
To catch each table row using "RegEx block" <tr(([^<]|<(?!/tr>))*)</tr>
others edit
Australian constraint violations edit
Wikidata data on the wall... edit
- Tell me all the phrases in common use that first originated in works by: all authors, Shakespeare ... broader catch phrase/quote/idiom query
- Tell me all the prizes won by Australian citizens who were not born in Australia: answer
edit
Items edit
 | This user is a property creator on Wikidata. (verify) |