Table 1 Overview of each of the tables included in the dataset including the name of the table, the number of observations included in the databases, the number of fields or columns, and the file formats provided.

From: A longitudinal dataset of five years of public activity in the Scratch online community

  Table Name Observations Fields File Formats
1 users 1,056,951 4 CSV, RDATA
2 projects 1,928,699 44 CSV, RDATA
3 galleries 120,097 3 CSV, RDATA
4 friends 1,313,200 3 CSV, RDATA
5 downloaders 4,236,575 2 CSV, RDATA
6 favoriters 1,041,387 3 CSV, RDATA
7 lovers 1,487,112 2 CSV, RDATA
8 viewers 30,154,002 2 CSV, RDATA
9 pcomments 7,788,414 5 CSV, RDATA
10 gcomments 2,817,973 5 CSV, RDATA
11 projects_galleries 908,717 3 CSV, RDATA
12 tags_projects 2,905,774 3 CSV, RDATA
13 tags_galleries 222,064 3 CSV, RDATA
14 frontpage_projects 32,208 3 CSV, RDATA
15 featured_projects 1,227 2 CSV, RDATA
16 featured_galleries 252 2 CSV, RDATA
17 studio_galleries 61 2 CSV, RDATA
18 curators 72 2 CSV, RDATA
19 projects_text 1,928,699 3 JSON, RDATA
20 galleries_text 120,097 3 JSON, RDATA
21 pcomments_text 7,788,414 2 JSON, RDATA
22 gcomments_text 2,817,973 2 JSON, RDATA
23 tags_text 353,934 3 JSON, RDATA
24 project_block_stacks 13,219,765 4 JSON, RDATA
25 project_block_stacks_disconnected 2,774,865 3 JSON, RDATA
26 project_strings 44,789,099 4 JSON, RDATA
27 project_blocks 1,925,606 172 CSV, RDATA
28 project_drums 259,663 3 CSV, RDATA
29 project_media 44,205,193 5 CSV, JSON, RDATA
30 project_midi_instruments 128,571 3 CSV, RDATA
31 project_save_history 12,590,095 2 CSV, RDATA
32 project_sprites 12,987,630 4 CSV, RDATA