project_save_history Table

Overview

Each row in this table represents a time when a user saved a project to their local storage device (e.g., hard drive) in the most recent version of a project shared publicly on the Scratch website at the point of data collection. This data was generated from a log of save "events" that was included in each project. If a project was a remix, its log included the full log of the project (or projects) on which the current project was based.

Description of Fields

This table includes 12,590,095 observations. Each row of this table corresponds to a single event when the project was saved.

Variable Type Description
project_id integer Unique identifier for the project (see the projects table).
date datetime Date when the project was saved by the user on their local storage device. This date comes from the user's own computer.

Summary

The following figure shows the distribution of save events by date:

plot of chunk unnamed-chunk-2

The range of the figure above is limited to the period of data collection. Because the date field reflects the date and time on users' computer, it may be inaccurate due to users' misconfigured computer clocks. Although the vast majority of timestamps fall within the range of data collection, the range of values is from "1901-01-07 12:31:34" to "2035-09-22 04:03:09".

Omitted Observations

We omit 7,592,895 observations because they refer to observations in older, non-public, versions of projects that were replaced on the site. Additionally, we omit 3,691,870 observations from projects which are not included in our projects table (e.g., they were removed from the site by their creators).

Download Datasets

These data are access restricted. Details on gaining access are provided in the "Permission to Use Datasets" section of the overview page.