ainali, 7 months ago

@stefan It's far from full, but the goal is that @govdirectory will contain them all. What might make it inconvenient for you is that it also contains all other social media. :)

stefan, 7 months ago

@ainali @govdirectory Very nice, thank you for sharing!

Hawkmoon, 7 months ago

@stefan

NASA is the only one I can think of.

schmubba, 7 months ago

@Hawkmoon @stefan
So can you @ nasa in the reply?
Search here has challenges.

Hawkmoon, 7 months ago

@schmubba @stefan

@nasa

I think that's it.

schmubba, 7 months ago

@Hawkmoon
It’s a bot rather than the actual organization.
Do I understand bots correctly?

NatureMC, 7 months ago

deleted_by_author

stefan, 7 months ago

@NatureMC No worries, thank you for sharing this!

Brendanjones, 7 months ago

@stefan @tchambers Crap, I saw one recently but can’t for the life of me think where. If I think of it I’ll get back to you. (Sorry for the useless response 😅)

stefan, 7 months ago

@Brendanjones @tchambers No worries, I appreciate you reaching out!

I was convinced I saw a list like this myself, but can't seem to find it.

Trying to figure out how to query Wikidata in the meantime. https://stefanbohacek.online/@stefan/111330646018817171

stefan, 7 months ago

If not, one way of getting it would be using #wikidata, I'm just missing a filter for "government" inside the "orgTypeLabel" column.

https://query.wikidata.org/embed.html#%23defaultView%3ATable%0ASELECT%20DISTINCT%20%3Forg%20%3ForgLabel%20%3ForgTypeLabel%20%3FhostAt%20%3FMastName%20%20WHERE%20%7B%20%20%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20%3Forg%20wdt%3AP4033%20%3FMastName.%0A%20%20%3Forg%20wdt%3AP31%20%3ForgType.%0A%20%20%23%3ForgType%20wdt%3AP279*%20wd%3AQ1193236.%0A%20%20FILTER%20(%3ForgType%20!%3D%20wd%3AQ5).%20%23ignore%20individuals%20%0A%20%20BIND%20(strafter(%3FMastName%2C%22%40%22)%20AS%20%3FhostAt).%0A%7D%20ORDER%20BY%20%3FhostAt%20LIMIT%2020000

stefan, 7 months ago

Anyone good with #wikidata #sparql able to help me out?

https://query.wikidata.org/#SELECT%20DISTINCT%20%3Forg%20%3ForgLabel%20%3ForgTypeLabel%20%3FhostAt%20%3FMastName%20%20WHERE%20%7B%20%20%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20%3Forg%20wdt%3AP4033%20%3FMastName.%0A%20%20%3Forg%20wdt%3AP31%20%3ForgType.%0A%20%20%3Forg%20rdfs%3Alabel%20%3ForgTypeLabel.%0A%20%20%23%3ForgType%20wdt%3AP279%2a%20wd%3AQ1193236.%0A%20%20FILTER%20%28%3ForgType%20%21%3D%20wd%3AQ5%29.%20%23ignore%20individuals%20%0A%20%20FILTER%20%28contains%28%3ForgTypeLabel%2C%22government%22%29%29%0A%20%20BIND%20%28strafter%28%3FMastName%2C%22%40%22%29%20AS%20%3FhostAt%29.%0A%7D%20ORDER%20BY%20%3FhostAt%20LIMIT%2020000

beet_keeper, 7 months ago

@stefan if all else fails there's the query request service! https://www.wikidata.org/wiki/Wikidata:Request_a_query 😅

I'd be tempted to try the the other way around, and try and find a broad query giving you govt agencies, then the mastodon instances, e.g.

https://w.wiki/7zCH

Not sure yet though what the best approach is.

beet_keeper, 7 months ago

@stefan with the bind and distinct parts:

https://w.wiki/7zCc

stefan, 7 months ago

@beet_keeper This is even better, thank you so much!

And I am definitely saving the query request service link, this will come in handy!

adafede, 7 months ago

@stefan https://w.wiki/7zpi maybe?

stefan, 7 months ago

@adafede This is great, thank you!