Questions tagged [data-explorer]
For questions about the functionalities, queries, databases and datamodel of The Stack Exchange Data Explorer (SEDE). SEDE allows you to create and run queries against copies of the databases of popular Stack Exchange sites.
1,574
questions
33
votes
18
answers
1k
views
Don't forget to mention.... SQL injection!
I've thought for a long time that answers that mention SQL injection get upvoted a lot, even if SQL injection is entirely unrelated to the question. It looks like the new data browser supports that ...
- 6,239
11
votes
5
answers
651
views
Most and least dangerous tags to answer (among the tags with 1000+ questions) [closed]
Most and least dangerous tags to answer (among the tags with 1000+ questions)
Turns out that MS-Access answers get a 10% chance of a downvote.
Good thing I steer clear of MS Access!
- 3,671
6
votes
1
answer
125
views
Vanity search: links to my website posted by other people during last 2 months
New query on Data Explorer:
Vanity search: links to my website posted by other people during last 2 months
How it works now:
Takes the website that you provided in your user info
Strips the ...
- 3,671
55
votes
15
answers
3k
views
Can we become our own "Northwind" for teaching SQL / databases?
In the Microsoft ecosystem there are some standard databases like Northwind ...
The Northwind Traders sample database contains the sales data for a fictitious company called Northwind Traders, which ...
- 311k
51
votes
5
answers
1k
views
When am I going to get the generalist badge?
Can anybody muster up a query on Data Explorer that will show me my progress towards the Generalist badge?
- 108k
8
votes
0
answers
162
views
You mean besides ninjas? Recent insightful comments
I made you a list of recent insightful comments. I'm really enjoying reading through it and it's almost Friday anyway.
- 108k
166
votes
31
answers
11k
views
Interesting queries on Data Explorer [closed]
Let's collect some interesting queries for the Stack Exchange Data Explorer here.
How many upvotes do I have for each tag? (how long before tag badges?)
SELECT TOP 20
TagName,
COUNT(*) AS ...
7
votes
1
answer
117
views
Low views, high votes and unanswered
I was just mucking around with the data dump and came up with an interesting query:
Low views, high number of votes yet unanswered. http://odata.stackexchange.com/stackoverflow/q/106
I thought the ...
- 108k
65
votes
8
answers
3k
views
Introducing the Stack Exchange Data Explorer aka SEDE
This is the announcement post of the Stack Exchange Data Explorer. Its answers were meant to iron out the initial glitches 6 to 8 years ago.
If you have found a bug or need support today with any of ...
- 108k
8
votes
4
answers
927
views
What is your ideal Data Dump Sandbox?
I have been thinking about building yet-another data dump sandbox like StackQL or StatOverflow -- both sadly defunct.
The new data dump sandbox will provide, at minimum, an OData endpoint for all "...
- 108k
67
votes
8
answers
11k
views
Implement OData API for Stack Overflow
The request is simple
Implement the OData API for Stack Overflow sites
Benefits:
It's a standard API.
OData allows the Stack Overflow database to be queried and navigated for questions, users, ...
- 1,081
-7
votes
6
answers
332
views
Include user's "Interesting" and "Ignored" tags in the data dump
I added a feature-request earlier that revolves around my use of tagging to draw .NET developers to questions that are language-agnostic (as far as C# and VB.NET are concerned).
The request is based ...
- 708
382
votes
2
answers
124k
views
Database schema documentation for the public data dump and SEDE
Stack Exchange releases "data dumps" of all its publicly available content roughly every three months via archive.org, and also makes that information queryable over the Internet at the ...
19
votes
2
answers
679
views
Why is vote time missing in the SE data dump and SEDE?
Is there a particular reason why vote times are omitted in the data dump?
IMO this could be a very useful data-set. Is this one of the steps that was done to anonymize the data, or does it simply not ...
- 14.7k