Posts of German PC Games Online Forum

This SQL-Dump contains linguistic annotated data from the Online-Forum PC Games (https://forum.pcgames.de). All posts (approx. 2.4 mio) where scraped on in April 2019 (details see Kissling 2019 and the github-URL below), resulting in 120 mio tokens of almost 70'000 authors.
In this database you find tokenized, part-of-speech-tagged and party lemmatized information of the posts and metadata like authors and the location of the post in the forum structure. Lastly, in the table infinitives, you will find the results of the API request done with Oxford Dictionary of English.
The order of the words in a post cannot be reconstructed with this database. Usernames were replaced with author_ids.

Additional information:
As this corpus was analyzed in terms of productivity and language contact of German and English (Kissling 2020), there is additional information about German base forms found in present day English, mainly focussing on the formula "German_verb_stem + -en = English verb infinitive". Therefore the API of the Oxford Dictionary of English was used. You will find the results of the API request done with Oxford Dictionary of English in the table infinitives. The corpus can be used without using this information, too.

The scraper is available on github: https://github.com/vizzerdrix55/web-scraping-vBulletin-forum

Calculations were performed at sciCORE (http://scicore.unibas.ch/) scientific computing core facility at University of Basel on 2019-09-10. This database contains all of the primary corpus.

All tables of the database are described in following lines:
- authors: contains a list of all author_ids
- forum_has_subforums: The two columns in this table can be used to assign which subforum belongs to which forum. Use (join) e.g. in combination with the tables forums and subforums.
- forums: Contains the names of the forums.
- infinitives: Contains the ID (inf_id), the German infinitives (lemma), the lemma to be requested in the English Oxford Dictionary ( . . .