Each row in this table represents a user account that was publicly visible on the Scratch website at the time that these data were collected. Each account on Scratch had a public profile web page that listed a username, a profile image (optional), and the a self-reported country (optional). The profile page also listed several of the account's most recent friends, projects, and galleries using criteria that may have changed over time.
When signing up, users were explicitly required not to use their real names or to reveal other identifiable information. Users whose self-reported age was under 18 years of age were asked to provide their parent or guardian’s email address instead of their own. People were asked to report their email address, gender and age, but this information was never made publicly available and it is not part of this dataset.
Users were not explicitly prohibited from creating multiple accounts unless those accounts were used to circumvent bans or violate other community rules.
The table includes 1,056,951 observations. Each observation describes a single account on the Scratch website and a single public profile page.
| Variable | Type | Description |
|---|---|---|
| user_id | integer | Unique identifier for each user account created. Used in public URLs and in other tables within the database to refer to users. This field is "autoincremented" and increases monotonically over time. |
| date_created | datetime | The date that the user created their account on the Scratch website, as reported in their public user page. |
| country | factor | Self-reported country as displayed on the user's profile page. The value was selected from a list of countries for most of the Scratch website's life. In the earliest period covered by this dataset, there was an option to fill in an unrestricted text box. |
| admin | logical | Boolean that identifies whether each user had administrator rights at the time that these data were collected. Other users may have been administrators at previous periods of time but data on previous terms as administrators were not recorded. |
When Scratch was initially launched, the country field allowed users to enter in their country as a free-form text field. Later, this field was changed to restrict users to enter only options from a list of all countries in the world. As a result, country data is less reliable for users who created their accounts early in Scratch's history.
Although usernames were always made public, we have opted not to include them in dataset to provide an additional level of privacy. In most cases, it will be possible for researchers to identify usernames using public data but doing so is prohibited in the research agreement necessary to gain access to these data.
The following figure shows the distribution of accounts by creation date:

The following table shows the distribution of users across self-reported countries on users' profiles pages. Countries with less than 10,000 users are binned into "Other" in the table but full data is provided in the downloadable datasets.
| Country | Count |
|---|---|
| United States | 402978 |
| Other | 219753 |
| United Kingdom | 124437 |
| Thailand | 40981 |
| Brazil | 39522 |
| Canada | 35862 |
| Australia | 33844 |
| Korea, Republic of | 29981 |
| Taiwan | 29165 |
| Colombia | 18009 |
| China | 17407 |
| Mexico | 15576 |
| Germany | 14884 |
| India | 12160 |
| Spain | 11393 |
| Hong Kong | 10996 |
The only "logical" (i.e., boolean) variable — admin — is distributed as follows:
| variable | TRUE | FALSE | NAs |
|---|---|---|---|
| admin | 22 | 1056929 | 0 |
We limit this table to user accounts whose profile was publicly visible. These are accounts with status set to normal, locked (i.e. manually set to being unable to login due to certain terms of use violation), or blockedtemporarily (i.e. automatically unable to use their account for a limited period of time). The content and profile page of user accounts that were set to delbyadmin (deleted by an administrator), or delbyuser (deleted due to a request by an account's owner) were not publicly visible, hence are not included in this data set. The distribution of accounts in each of these categories is listed in the table below:
| Status | Count |
|---|---|
| EMPTY | 4 |
| blockedtemporarily | 15 |
| delbyadmin | 1244 |
| delbyusr | 3872 |
| locked | 2611 |
| normal | 1060756 |
We also omit an additional 6,430 observations because the creation date is missing in the database as well as 1 additional observation because the database recorded that account was created before 2007 when Scratch was created. In both caes, accounts reflect testing accounts created when the website was under development and testing before launch.
These data are access restricted. Details on gaining access are provided in the "Permission to Use Datasets" section of the overview page.