Stack Exchange — dba.stackexchange.com

The content of dba.stackexchange.com (https://dba.stackexchange.com/), a Stack Exchange question-and-answer site, as published in the Stack Exchange Data Dump of April 2024 on the Internet Archive. The posts table holds 591,248 rows: 243,410 posts (103,026 questions, 138,650 answers, 853 tag wiki excerpts, 853 tag wikis, 24 posts of type 6 and 4 posts of type 7) and 347,838 comments, written between 16 September 2008 and 31 March 2024. Beside it are 248,141 user accounts, 911,783 votes, 429,421 badges awarded, 1,242 tags, 833,657 post revisions and 20,194 links between posts. Every answer keeps the question it answers and every comment the post it was written on, so the threads can be rebuilt. The Internet Archive item describes the dump as anonymised; the votes table names the voter in only 1,454 rows.

#Database#Expertise network#Reputation#Stack exchange data dump

Download data package README Original files as received BibTeX JSONSimilar datasets

Analytics

The interactive network needs JavaScript.

· graph.json

The full graph has 56,315 nodes; this view shows the 1,000-node sample the pipeline drew for display. Node size is centrality, colour is community.

56.3K
Nodes
109.4K
Edges
3.45e-05
Density
1.2K
Components
-0.1135
Assortativity
0.2%
Reciprocity
32.4K
Bridges
Most central nodes
560500.00368
223360.00337
26390.00217
1624830.0021
1360.00178
37870.00172
129710.0017
1500110.00167
9720.00167
307630.00158
Content metrics

591,248 records scored · min–maxmean ± 0.675 σ (the interquartile range if the values are roughly normal)mean

x scoreμ 1.325 ± 6.345
min -12max 2K
x view countμ 4.4K ± 21.1K
min 4max 3.2M
x answer countμ 1.346 ± 0.999
min 0max 22
x comment countμ 1.429 ± 2.174
min 0max 37
x favorite count0.1% true
true 0.1%false 99.9%
8.9
Flesch–Kincaid grade
US school grade level
10.1
Automated readability index
Frequent terms
tableselectserversqldatabasedatanullqueryusecreatemysqlindexsetliketimerowsneedkeytablesjoinusererrorfilecolumnloginsertwantvaluesnewvalueorderwayupdatecaserowdefaultendprimaryintdonrunquestionvarchardbodatebackuptypecolumnsproblemadd
Topic clusters

Topic 0

server
sql
user
database
login
grant
permission
connect

Topic 1

replication
slave
master
node
replica
cluster
failover
server

Topic 2

backup
restore
database
file
log
recovery
server
disk

Topic 3

memory
server
ram
tempdb
cpu
size
file
mysql

Topic 4

thank
answer
work
help
solution
glad
appreciate
reply

Topic 5

mysql
innodb
file
error
note
mysqld
install
package

Topic 6

answer
question
post
ask
edit
add
comment
think

Topic 7

postgre
postgresql
psql
user
run
connection
database
role

Topic 8

lock
transaction
deadlock
commit
isolation
block
gmt
update

Topic 9

column
table
row
value
select
query
record
multiple

Topic 10

table
key
relationship
product
entity
model
design
type

Topic 11

datum
date
value
select
table
code
query
need
Show all 21 topics

Topic 12

join
select
union
left
group
inner
outer
query

Topic 13

date
month
day
year
timezone
time
zone
datetime

Topic 14

key
foreign
primary
table
constraint
unique
null
references

Topic 15

index
query
row
scan
join
cluster
order
table

Topic 16

mongodb
mongo
shard
mongod
collection
chunk
document
replica

Topic 17

index
query
estimate
statistic
plan
update
performance
slow

Topic 18

function
select
create
insert
table
value
return
sql

Topic 19

trigger
insert
update
end
begin
create
table
delete

Topic 20

collation
character
field
collate
default
varchar
byte
string
Top hashtags
#12.5K
#22.2K
#temp1.8K
#t936
#3927
#tmp635
#test470
#sql403
#temptable379
#4339
#results257
#temp1238
#t1236
#0230
#temp2224
#x221
#table218
#5194
#define194
#mytable180
Top emoji
😸3
🙃3
😺2
🍩1
🐘1
😁1
😎1
🙀1
🛈1
򃓉1
󛄅1

Computed over the full corpus.

Record

Catalog key
stackexchange-dba-stackexchange-com
Authors
Stack Exchange, Inc.
Year
2024
Source paper
Stack Exchange Data Dump
License
CC BY-SA 2.5 / 3.0 / 4.0 (by contribution date) (CC-BY-SA-2.5 AND CC-BY-SA-3.0 AND CC-BY-SA-4.0)
Records
695,165
Nodes
56,315
Edges
109,435 (directed)
Nodes are
user (Stack Exchange account)
Edges are
answer collaboration (A answered B's question)
Attributes
nodes have attributes; edges have attributes
Text corpus
question titles, post bodies, comment text, tag names
Languages
en
Collected
2008/2024 (2000s, 2010s, 2020s)
Tasks
From the graph: link prediction, community detection
Region
Global (inferred: the platform is used worldwide)

Provenance

Originally published at
https://archive.org/details/stackexchange link checked
Original files as received
The source files, unconverted, kept for reference: mirrored on echo.directory on 2026-10-09, 304.6 MB across 1 files. Checksums in MANIFEST.json. For use, start with the data package below.
Data package
Version 1.0.0 of this dataset as an ECHO Data Package: posts (591,248 rows), users (248,141 rows), x_votes (911,783 rows), x_badges (429,421 rows), x_tags (1,242 rows), x_post_history (833,657 rows), x_post_links (20,194 rows).
Structure
Temporal (timestamped), Node attributes, Text, Threaded conversations

How to cite

BibTeX

@misc{echo2026,
  title  = {ECHO: Exploratory Compendium of Humanity Online},
  author = {Switzer, Braden and Zafarani, Reza},
  year   = {2026},
  url    = {https://echo.directory},
  note   = {Syracuse University}
}

@misc{stackexchange_2024,
  title     = {Stack Exchange Data Dump},
  author    = {{Stack Exchange, Inc.}},
  year      = {2024},
  month     = {apr},
  publisher = {Internet Archive},
  url       = {https://archive.org/details/stackexchange}
}

APA

Switzer, B., & Zafarani, R. (2026). ECHO: Exploratory Compendium of Humanity Online [Data repository]. Syracuse University. https://echo.directory

Stack Exchange, Inc. (2024). Stack Exchange — dba.stackexchange.com [Data set]. https://stackexchange-dba.echo.directory/

MLA

Switzer, Braden, and Reza Zafarani. ECHO: Exploratory Compendium of Humanity Online. Syracuse University, 2026, echo.directory.

Stack Exchange, Inc. Stack Exchange — dba.stackexchange.com. 2024, stackexchange-dba.echo.directory/.

BibTeX · RIS · CSL-JSON

Similar datasets 10 all with scores →