All Questions
Tagged with users data-explorer
16
questions
1
vote
0
answers
40
views
View "people reached" data/trend through time for user
Is there a way to view a trend (graphically or tabulated) in the number of "people reached" per user per site?
E.g., to see how many people a user's posts impacted monthly or annually, etc.
...
- 1,102
4
votes
1
answer
64
views
What is the difference between DisplayName and Id on the Stack Exchange Data Explorer Users table?
I am trying to pull a list of all users who have commented on an answer and tie it back to their User profile, if one exists. However, not all Comments table records have a UserId associated with them ...
5
votes
1
answer
80
views
Missing UserIDs
I'm working on some performance tests for my ORM.
I just noticed this with the 2010; these two queries return results.
SELECT distinct UserId FROM Comments WHERE not UserId in (Select ID From Users) ...
- 151
3
votes
2
answers
103
views
Number of users in a Stack Overflow SEDE query
I tried to run this query on SEDE:
SELECT *
FROM
(
SELECT
ROW_NUMBER() OVER (ORDER BY u.Displayname DESC) AS row,
u.Id, u.Reputation
FROM
Users u
WHERE
...
- 125
7
votes
1
answer
60
views
What can I do to find how many distinct users contribute to all the posts and comments this query seaches for?
I have used the query below to form a result table and now I need to find how many users are contributing to it. Is there any way I can achieve that?
SELECT p.Title,p.Body,c.Text
FROM Posts p
JOIN ...
- 303
6
votes
1
answer
194
views
Is it possible to create a Data Explorer query that returns questions from users who have more answers than questions?
I've found a query that returns questions from users with a certain minimum reputation:
select top 20 p.id as [Post Link], p.score, p.viewcount, p.answercount, p.tags,
u.reputation
from posts p, ...
- 1,763
1
vote
0
answers
31
views
Not able to see Location in Stack Exchange Data Explorer [duplicate]
I am using the following query in Stack Exchange Data Explorer:
SELECT Id, DisplayName, Reputation, Location
FROM users
WHERE Id = '3628106'
ORDER BY Reputation DESC
But I don't see Location in the ...
- 131
5
votes
1
answer
103
views
Is it possible to track the question-to-answer ratio of users on a given site?
I'm trying to run a query which takes the top, say, 50 users on a site (bonus points if you can edit this number when running the query), and outputs a table listing all of the users, how many ...
- 2,312
4
votes
1
answer
97
views
How can I get the summary of questions a user ask from the Stack Overflow data dump?
I need information about how many questions a user asks, how many of them are resolved, and how many of them remain unanswered. Is there any way to get this information from the SO data dump?
- 179
3
votes
1
answer
165
views
Any way to find the ID of a deleted post author?
Is there any way to query the user id of a deleted post author on a Stack Exchange site?
I tried to query the table postswithdeleted from https://data.stackexchange.com/stackoverflow/queries. But the ...
- 113
2
votes
1
answer
104
views
Why does the data explorer say that I'm 28 years old, and then sometimes 15?
I've been fooling around with the Data Explorer for a while, and I was very confused when I ran the following query on Codereview, and got back unexpected results.
SELECT Id, DisplayName, Views Age, ...
- 332
2
votes
1
answer
88
views
Recreate a query for the tags associated with a user based on time filter
I'm looking to recreate a SEDE query that represents the tags associated with a user based on a specific time filter. Consider, for example, the list of users sorted by reputation, filtered by week:
...
- 13.5k
0
votes
0
answers
31
views
Who does the data explorer think I am John.Doe [duplicate]
I logged into data-explorer for the first time 9I have viewed others' queries but have not created one myself). When I log in with the StackExchange Open Id provider, I am shown as john.doe13574.
...
- 103
2
votes
1
answer
368
views
Finding specific users by their location and a tag score
I want to see who has the highest score in a specific tag (for example c#) in my country.
Is there any query or script for that?
I've found this query, but it doesn't work. Can any one take a look at ...
- 131
-2
votes
2
answers
128
views
Data Explorer queries most likely to find dormant users that if engaged are likely to become active users
Currently my thought is the profile of such a user would be that they:
have not visited the site in a month and posted a answer/comment/question
have an answer/comment/question on the site
have been ...
- 1,160