ABCDEFGHIJKLMNOPQRSTUVWXYZAAAB
1
How To Use
2
This project aims to make discovery of Cantonese content on YouTube that is suitable for language learning as simple and accessible as possible. The spreadsheet is broken up into three tabs:

Introduction - (this tab) instructions on how the rest of the spreadsheet is laid out
Videos - the full list of all videos that have been indexed by this project to date
Channels - the full list of channels that have been indexed by this project to date
3
4
StatsFeedback
5
VideosSWC SubsWritten SubsEmail rtveitch@gmail.com or message rtveitch on the Cantonese Refold Discord Server
- new channel and video suggestions
- issues
6
795510457955
7
8
Videos Tab
9
Columns
10
The following columns are available for each video in the Videos tab
11
12
ColumnDescription
13
channel_idthe id of the channel the video belongs to; this column is hidden by default
14
channelthe name of the channel the video belongs to
15
idthe video's id; this column is hidden by default
16
titlethis video's name
17
upload_datethis video's upload date in yyyy-mm-dd format
18
durationthe video's length, in seconds
19
chineseY if the video contains at least one Chinese subtitle track; blank otherwise
20
swcY if the video contains at least one Standard Written Chinese (書面語) subtitle track; blank otherwise
21
writtenY if the video contains at least one Written Cantonese (口語) subtitle track; blank otherwise
22
length_chinesethe length (in characters) for the longest Chinese subtitle track for the video; 0 if no Chinese subtitle track exists
23
percent_chinesethe percentage of the subtitle track that is in Chinese, for the Chinese subtitle track with the highest percentage of Chinese; 0 if no Chinese subtitle track exists
24
subtitlesthe full list of subtitle tracks the video contains; multiple tracks are separated by |, e.g. en|zh-HK|yue
25
26
Common Queries
27
Given that the collection of videos is quite large, most users will wish to browse a subset of the collection based on some filter and sort criteria. A few queries have been pre-created for your convenience:
28
29
Group By Channel, Newest Video First - discover a new channel you didn't know about before
30
Written Cantonese Subs, Longest Sub First - get in some solid reading practice during a longer study session
31
Written Cantonese Subs, Longest Video First - set it and forget it, these videos can easily be played in the background
32
Written Cantonese Subs, Newest Video First - tired of infinite netflix scroll? Use this filter and watch the very first video that shows up, no thinking required
33
34
To access these filter views from the Videos tab, click
Data -> Filter Views -> (Name of Filter View).

To dismiss the filter view and return to the full video listing, click the X in the upper right corner of the filter view header
35
36
Custom Queries
37
To write your own queries, click the "Create a filter" button and select the columns of interest to filter and/or sort. See Sort & filter your data for more details
38
39
Channels Tab
40
Columns
41
The following columns are available for each channel in the Channels tab
42
43
ColumnDescription
44
channel_idthe id of the channel; this column is hidden by default
45
channelthe name of the channel
46
videosthe number of videos indexed for this channel
47
chinesethe number of videos containing at least one Chinese subtitle track for the channel
48
swcthe number of videos containing at least one Standard Written Chinese (書面語) subtitle track for the channel
49
writtenthe number of videos containing at least one Written Cantonese (口語) subtitle track for the channel
50
51
Common Queries
52
Most Videos First - most prolific channel
53
Most Written Cantonese Subs First - channel with the most accesible videos for Cantonese learners
54
55
Sources
56
Cantonese Refold Discord Server
zKing's Cantonese with spoken form soft subtitles/transcript playlist
youglish.com
57
58
Tools
59
yt-dlp - a command line tool for downloading videos/subtitles from YouTube and other sites
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100