Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with data-explorer
Search options not deleted
user 259412
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.
4
votes
My user id doesn't work in a query
Extending @Oded 's answer: If you have account on many sites, or if you want to compare things between different sites, it could be useful to use your network Account Id. It is visible in your network …
- 5,935
17
votes
1
answer
203
views
Network-wide queries don't work on the SEDE
For example, a
SELECT * FROM sysdatabases;
results
maybe some synchronization is running and it is only a temporary situation?
Note, no network-wide query will work, if you make this permanent. …
- 5,935
3
votes
1
answer
91
views
How can I parametrize a query with a database name on the SEDE?
For example, a query fragment what should work:
SELECT
TagName AS Tag,
Count FROM [##Site1:string?StackExchange.Math##].dbo.Tags
UNION
SELECT TagSynonyms.SourceTagName AS Tag, Tags.Count
FROM [## …
- 5,935
2
votes
0
answers
31
views
Please make the data SE queries commentable [duplicate]
Not a dupe, my proposal is not about a contact request to the author, it is about comments, like comments below any SE post (which are visible and are reactable by all the community!).
It would be a …
- 5,935
2
votes
0
answers
76
views
SEDE seems overloaded, is it true?
Most of my queries I've developed worked pretty well while I've developed them, now most of them time out.
Has something uncommon happened, or are we simply overloaded?
Can I get information about t …
- 5,935
2
votes
Is it okay to use Data Explorer as a recruiting tool?
It is probably a violation of the ToS. There is nothing in the ToS, how the scraping can happen. Scraping by the own tool of the SE is exactly so forbidden.
In practice, probably there is no way to a …
- 5,935
2
votes
0
answers
64
views
Please make the "favorites" tab sortable in the SEDE
Ext: of course the best would be if it would be so nicely sortable/searchable like the questions on the ordinary sites.
Currently the only way to remark "my" queries is to favorize them.
However, as …
- 5,935
2
votes
1
answer
98
views
How can I query for StackExchange.* databases on the Data SE?
By default my table names are using the current site to which I am connected on. Thus a query SELECT TOP 100 * FROM Users will list 100 users.
If I wish to select from a different database, in some c …
- 5,935
-8
votes
1
answer
111
views
It is already 11:13 (UTC), but the SO snapshot did not arrive at the SEDE [closed]
It is already 11:13 (UTC) and the weekly SO snapshot is not yet on the SEDE. Last week it could have been synced until 05:09 (UTC)1.
Other sites look fine.
Are your scripts okay?
1This is coming from …
- 5,935
0
votes
1
answer
66
views
Please make the data SE to handle the logins so smartly as the other sites do [duplicate]
If I log in into the data SE, it always forgets my login credentials. I have to log in again and again.
I think, the feature is available in the other SE sites, and maybe it wouldn't be very hard to …
- 5,935
2
votes
1
answer
86
views
There are PostHistory records for deleted posts, but only a very few
Checking for the PostHistory entries in the SEDE for deleted Posts, I get some results, but only a very few.
For example, there is only 33 such records for the whole SO. All of them are from 2018.
I …
- 5,935
2
votes
2
answers
82
views
Please make post lockedness meta-data available in the SEDE
My subjective experience is that the count of the mod-locked questions is growing, and I feel this starts to cause more and more troubles with time.
I think, adding some new columns to the SEDE schema …
- 5,935
1
vote
Please make post lockedness meta-data available in the SEDE
Ok, fortunately the PostHistory table contains the data of the lock/unlock events. This results that the following query can get the list of the locked posts:
SELECT PostId
FROM PostHistory
WHERE
Id …
- 5,935
1
vote
0
answers
87
views
How to identify moderators in Data SE queries? [duplicate]
As I can see, the Data SE doesn't contain data, who are/were the moderator currently, or in the past.
To some queries, I would like to use this data. Currently, I do this by checking the election pag …
- 5,935
-18
votes
2
answers
116
views
Do we want a data.meta.stackexchange.com?
Unfortunately, the data SE doesn't have any meta site.
It could be a very useful feature, people could share their tips and experiences about the site.
- 5,935