There is a newer version of this record available.

Dataset Open Access

SOTorrent Dataset

Baltes, Sebastian; Dumani, Lorik

Stack Overflow (SO) is the most popular question-and-answer website for software developers, providing a large amount of code snippets and free-form text on a wide variety of topics. Like other software artifacts, questions and answers on SO evolve over time, for example when bugs in code snippets are fixed, code is updated to work with a more recent library version, or text surrounding a code snippet is edited for clarity. To be able to analyze how content on SO evolves, we built SOTorrent, an open dataset based on the official SO data dump. SOTorrent provides access to the version history of SO content at the level of whole posts and individual text or code blocks. It connects SO posts to other platforms by aggregating URLs from text blocks and by collecting references from GitHub files to SO posts. Our vision is that researchers will use SOTorrent to investigate and understand the evolution of SO posts and their relation to other platforms such as GitHub.

The dataset is based on the official Stack Overflow data dump released 2018-03-13 (https://archive.org/details/stackexchange) and the Google BigQuery GitHub data set queried 2018-03-31 (https://cloud.google.com/bigquery/public-data/github). Please read the license files (LICENSE.md) before using the dataset. In the previous release of version 2018-03-28, column PostHistoryTypeId of Table PostVersion was missing.
Files (83.2 GB)
Name Size
1_create_database.sql
md5:ff02bdeac68d301ff086d61b93fe6a82
6.5 kB Download
2_load_so_from_xml.sql
md5:ac1e75932c328714c3857fc4d7a0bd8a
1.2 kB Download
3_create_indices.sql
md5:8f1e0ded9ed955a72ff578f946b972ed
501 Bytes Download
4_create_sotorrent_tables.sql
md5:4369e3f59e10df1c32b862b123b6c60d
4.2 kB Download
5_create_sotorrent_user.sql
md5:67d06f44c86b3cce6ac7d6bf896cade6
506 Bytes Download
6_load_sotorrent.sql
md5:ac8d466cc522fd60ba8aca39d80a3b0c
2.5 kB Download
7_load_postreferencegh.sql
md5:c8e532fbbee4ff9c6e02667db57f7c5b
489 Bytes Download
8_create_sotorrent_indices.sql
md5:d192d029bddfc81a637e9c6ba0b1379f
1.1 kB Download
Badges.xml.gz
md5:ebc9944fd1bed0f43cd07afec6da6d16
277.7 MB Download
Comments.xml.gz
md5:3ab64f1bd41940bdf692a5d282507588
5.5 GB Download
LICENSE.md
md5:a342f12af3354b2656da59fda2c8b3cb
38.4 kB Download
PostBlockDiff.csv.gz
md5:e9d03913bd34515483748ea37b9a5b56
8.6 GB Download
PostBlockVersion.csv.gz
md5:bcf3d1d2f4d9ee8a7843696960cf88ae
18.9 GB Download
PostHistory.xml.gz
md5:cc4ca11f111eb17ce43842e145fa9ca0
29.5 GB Download
PostLinks.xml.gz
md5:bc89460a7570723a58c3aa5775b83723
90.6 MB Download
PostReferenceGH.csv.gz
md5:a67923c09e7f0de25266c321bc7fde74
351.2 MB Download
Posts.xml.gz
md5:478708a9cb50c2fd4890e809f02b235d
16.6 GB Download
PostVersion.csv.gz
md5:0979eac97f86125d05b4506ccef43d23
961.5 MB Download
PostVersionUrl.csv.gz
md5:4b5bc347a7ad64ed148dd209c41d526e
720.3 MB Download
README.md
md5:e1a6dc16f4500e0e75ad0fa5915420a4
1.4 kB Download
Tags.xml.gz
md5:72deadfbd3f845780ed1fabb8bc7c537
1.0 MB Download
Users.xml.gz
md5:2676ba441dce5beb1f483be8a8af76cc
541.5 MB Download
Votes.xml.gz
md5:fdf1560e480d2bc8471598178ca72784
1.2 GB Download
1,193
4,741
views
downloads
All versions This version
Views 1,19333
Downloads 4,741252
Data volume 20.8 TB741.9 GB
Unique views 96333
Unique downloads 74729

Share

Cite as