Skip to main content
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
Search options not deleted user 200117

This tag is about the quarterly creative commons data dumps of all public data in the Stack Exchange network Q&A sites.

7 votes
1 answer
4k views

"Data Error Sub items Errors: 1" when decompressing stackoverflow.com-Posts.7z from the Stac...

I've downloaded the Torrent version of https://archive.org/details/stackexchange and selected only the files that I need with Transmission. I then tried to extract with: sudo apt-get install p7zip-f …
Ciro Santilli OurBigBook.com's user avatar
7 votes
Accepted

When was the last data dump uploaded to archive.org?

A good way to estimate the age of the data (true, not the same as upload date, maybe some format changed, but likely what most people want), is to download Votes.xml ("only" 400M compressed) and: tai …
Ciro Santilli OurBigBook.com's user avatar
3 votes

"Data Error Sub items Errors: 1" when decompressing stackoverflow.com-Posts.7z from the Stac...

OK, false alarm. I downloaded the file again and it worked. The first time I downloaded, the last 1% was very slow, maybe there is a relation? I didn't know torrents could be so unreliable.
Ciro Santilli OurBigBook.com's user avatar
1 vote
0 answers
66 views

Add the DeletionDate column to the archiv.org data dump or create a PostsWithDeleted table [duplicate]

The latest data dump has: no DeletionDate column no PostsWithDeleted table but it does contain deleted posts. This makes it hard to decide if posts are deleted or not. I think I could extract th …
Ciro Santilli OurBigBook.com's user avatar
1 vote

Does the public data dump contain user names or not?

So far I've found the following columns that show on the public dump that differ from the presumed original internal SE values: Votes.UserId is NULL for most vote types, including upvotes or downvot …
Ciro Santilli OurBigBook.com's user avatar