Questions tagged [community-data]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2
votes
0answers
45 views

How to create query to fetch all iOS Developers in my city? [duplicate]

Currently I am doing: SELECT ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS Rank, Id AS [User Link], Reputation FROM Users WHERE LOWER(Location) LIKE '%krak%' AND LOWER(AboutMe) LIKE '%ios%' AND ...
-5
votes
3answers
154 views

When comments are moved to chat and removed from the database, why provide a useless link about it?

When I do a Google search I'll often find an on-point question answer from 5 years ago or more. That's good. This database is great for that. As a practical matter, as I work and get stumped by ...
-9
votes
3answers
72 views

How to get data on who viewed questions and profiles?

I am working with the Stack Overflow datadump and have a general question. I would like to obtain more detailed data on the "views" attribute, pertaining both to question views and profile views. ...
10
votes
0answers
63 views

Download my voting data

For my own data analysis reasons, it would be useful to have a dump of votes that I've cast on a particular site. I would normally use the SEDE and/or the data dumps, but voting data has been ...
2
votes
2answers
100 views

Count all users on StackExchange

Is there a simple way to see the total amount of users on StackExchange? I ran a query on data explorer but it looks like it's only StackOverflow. Adding up every community would be tedious and I ...
12
votes
0answers
164 views

Create example, reference queries on Data Explorer

Could we have some example queries, generated by the Stack Exchange team themselves, to use as a reference for the Data Explorer? Edit: Based on the comments, I need to clarify that I am suggesting ...
11
votes
0answers
78 views

Please make close vote review data public [duplicate]

I'd like to play around with the close vote review data to do some basic analysis. Can the review data from the close vote queue please be made public? User IDs should be included in the data dump, ...
6
votes
3answers
190 views

When is the ideal time to hold a chat room event to accommodate the most users, in particular users with close vote privileges?

I wanted to run a weekly, 1-hour event, and initially set the time, somewhat haphazardly, to my lunch hour, 9:00pm UTC (as I expected to be alone in participation at first anyway). However, several ...
6
votes
1answer
61 views

Does upvote rollback when question is removed from community wiki?

I added one of my answer to community wiki by mistake. And asked moderator to remove it. If a moderator removes CW, is the reputation earned from upvotes while the answer was CW preserved, or is it ...
24
votes
4answers
759 views

Options for community data dump

We are in the process of automating the community data dump process and have reached the stage where we need to decide how and where to host the exported files. We expect to have one data dump for ...
0
votes
1answer
48 views

How can I get generalized statistics of the StackExchange user base?

I'd like to get some statistics, anonymized, about the StackExchange userbase--at this point, mainly where people are located, but eventually other information. Is this possible?
7
votes
0answers
79 views

What are participation rates for Stack Overflows “was this post useful to you” button?

I just asked this question on stackexchange (webmasters) and @danlefree suggested that I try asking meta if it was possible to access some general statistics (even partial) about how high a % of ...
-7
votes
3answers
106 views

Make a “Closed Questions Count” easily available, per-site?

On the all sites page, there's statistics on questions asked, answered, etc. I'd like to see a number (or percentage) of questions closed for each site. Update - I don't know the best place to put ...
3
votes
3answers
168 views

Plot of question growth on Stack Overflow

With Stack Overflow approaching 1.5 million questions, I wonder: Has anyone been collecting a history of the question count? Maybe Jeff has this saved somewhere. ;) I'm interested because I'd like to ...
0
votes
1answer
134 views

Any plans to load the community data dumps to a data warehouse?

So you'd have point in time and all the other things you might get out of a data warehouse. I can see where this relates to using the dump(s) for an AdventureWorks replacement, with the additional ...
11
votes
4answers
262 views

What are the causal relationships on the Stack Overflow website?

I am working on a quantitative analysis of Stack Overflow. I am particularly interested in the causal relationships in the system. Examples of causal questions that I can think of are: Does ...
8
votes
4answers
249 views

What events/policy changes etc. in SO have exogenously manipulated things like views, answers, votes etc.?

I'm doing some quantitative research on SO and I'm trying to find good "natural" or quasi-experiments that have occurred or will occur in SO. What I mean by a natural experiment is some policy change,...
11
votes
1answer
224 views

Data Dump Sandboxen

It appears that http://statoverflow.com/sandbox/ is not in good working order. Any other SQL data-dump sandboxes available?
1
vote
1answer
69 views

Linking to other web pages through stack overflow questions

Thinking of a title for this question was difficult, but I here is the scenario, Someone asks a question, and the answer to said question is in an article that is linked to in another stackoverflow ...
2
votes
1answer
72 views

Most interesting tags?

Has anyone done the data mining to discover which tags the most users have marked 'interesting' (or 'interesting' minus 'ignored') for the stacker sites?
4
votes
3answers
105 views

What information is missing from the SO community dump?

What information do you think is missing from the community data dump? As it stands I think the current data dump contains most of the information we need.