The Corpus of German Speech (CoGS) is a 51-million-word corpus of geolocated automatic speech recognition (ASR) YouTube transcripts from local government channels in Germany, created for the study of lexical, grammatical, and discourse-pragmatic phenomena of spoken language. Annotation includes individual word timings and video IDs of transcripts, making it easy to instantly view the video(s) for any given search. CoGS represents a rich resource for the study of language and communication in Germany, but given the content of the transcripts, may also be of interest to students and researchers in diverse digital humanities and social science fields such as cultural studies, geography, political science, sociology, urban studies and planning, or tourism studies, among others.

Corpus description

The corpus was created from 39,495 ASR transcripts from 1,313 YouTube channels, corresponding to more than 7,223 hours of video. The size of the corpus is 50,514,575 tokens. The channels sampled in the corpus are associated with local government entities, mostly city governments. The transcripts are from a range of video types. Metadata includes exact latitude-longitude coordinates for corresponding municipalities, making geographical analysis of language use possible.


Format and metadata

The corpus exists in two versions: one in which the transcripts have not been annotated, and one in which word tokens have been annotated with part-of-speech tags and timing. Data is in tabular form in csv format (with the pipe character "|" as a separator). The columns of the table are 'Bundesland', 'Gemeinde', 'channel_title', 'channel_url', 'video_title', 'video_id', 'upload_date', 'video_length', 'location','nr_words','text_pos' (or 'text', in the untagged version), and 'latlong'. Each row corresponds to an individual transcript (see excerpt below).

Transcripts are in the 'text_pos' column (or the 'text' column, for the untagged version). Tagging was done with spaCy and the Stuttgart-Tübingen tagset tagset. Tagged tokens have the format "token_POS_10.0", where "token" is the transcribed lexical item, "POS" the tag, and "10.0" the time offset in seconds from the start of the corresponding video.

Bundesland Gemeinde channel_name channel_url video_id video_title upload_date video_length nr_words location latlong text_pos
27062 Nordrhein-Westfalen Krefeld Krefeld https://www.youtube.com/user/stadtkrefeld G2PilMB9-OY Freier Eintritt KinderJugendliche KWMHLHE 20200207 94.140 166 Von-der-Leyen-Platz 147798 Krefeld (51.33262, 6.56238) [Musik]_VVFIN_0.0 wir_PPER_4.46 würden_VAFIN_5.46 uns_PPER_5.819 sehr_ADV_6.089...
1937 Baden-Württemberg Friedrichshafen Stadt Friedrichshafen https://www.youtube.com/user/StadtFN fbKNjM05gN4 KRATZ- UND BISSFEST Nr. 9 Der Holzfisch 20200514 190.560 197 Adenauerplatz 188045 Friedrichshafen (47.654166666667, 9.4791666666667) [Musik]_NN_3.74 ja_ADV_18.38 ja_ADV_20.32 herzlich_ADJD_21.15 willkommen_ADJD_22.15...
6548 Baden-Württemberg Stuttgart Landeshauptstadt Stuttgart https://www.youtube.com/user/stuttgartlhs PiSYYfbGmHs #Futureproofchallenge Aftermovie 20211004 124.949 168 Marktplatz 170173 Stuttgart (48.775555555556, 9.1827777777778) [Musik]_NN_0.0 2021_CARD_1.3 feiern_VVINF_2.3 stuttgart_NE_3.139 und_KON_3.83...
35747 Rheinland-Pfalz Ober-Olm Ober-Olm https://www.youtube.com/channel/UCp9tbm4RFK92G2VVssy-DUA J9TWgS2_JhM Abendgedanken am 16.01.2022 mit Diakon Schmuck _ Ober-Olm 20220116 290.200 699 Pariser Straße 11055268 Nieder-Olm (49.936944444444, 8.1888888888889) die_ART_0.829 schlagzeile_NN_1.829 sonntags_ADV_2.7 jesus_NE_3.47 rettet_VVFIN_4.47...
35077 Rheinland-Pfalz Bad Dürkheim Bad Dürkheim https://www.youtube.com/user/StadtBadDuerkheim fHhjwkkGnoM Bericht über die Sitzung des Bad Dürkheimer Stadtrates am 27. Oktober 2020 20201103 589.370 1493 Mannheimer Straße 2467098 Bad Dürkheim (49.459444444444, 8.1680555555556) ja_PTKANT_0.0 in_APPR_0.48 wunderschönen_NN_0.63 guten_ADJA_1.02 abend_NN_1.079...

Locations

The map below shows the locations, names, and sizes of the sampled channels.


Sample script

Corpus hits can be presented as a table with links to the videos at the times of utterance, permitting quick manual filtering and annotation of audio and video material. This Python script will retrieve all instances of "ach du meine" in the PoS-tagged text in the table cogs_df with the immediate context:


import re
hits = []
pat1 = re.compile("((\\w+_\\S+_\\S+\\s){3}ach_\\w+_\\S+\\sdu_\\w+_\\S+\\smeine_\\w+_\\S+\\s(\\w+_\\S+_\\S+\\s){3})",re.IGNORECASE)
for i,x in cogs_df.iterrows():
	if pat1.search(x["text_pos"]):
		finds1 = pat1.findall(x["text_pos"])[0]
		seq = " ".join([x.split("_")[0] for x in finds1[0].split()])
		time = finds1[0].split()[0].split("_")[-1] 
		hits.append((x["country"],x["channel_name"],x["video_title"],seq,"https://youtu.be/"+x["video_id"]+"?t="+str(round(float(time)-3))))
pd.DataFrame(hits)
       (...)

Access

The corpus is available free of charge for the purposes of research, education, and scholarship. Users may not redistribute the corpus or use the corpus for commercial purposes. The corpus is available through the Harvard Dataverse here. Please also see the Corpus of North American Spoken English and the Corpus of British Isles Spoken English, created using similar methods.


Citation

To cite the corpus, please use

  • Coats, Steven. 2022. Corpus of German Speech (CoGS). https://cc.oulu.fi/~scoats/CoGS.html.