charts: 5223

This table contains the information used by our Grapher datavisualisation tool to render charts.

The most relevant field is the config field that contains json stored as text. A JSON Schema is available that describes the content of this json data. The SQLite JSON_EXTRACT function can be used in SQL queries to extract the content of this JSON data into columns in a result table.

Data license: CC-BY

This data as json

rowid id configId isInheritanceEnabled createdAt updatedAt lastEditedAt publishedAt lastEditedByUserId publishedByUserId isIndexable config slug type title subtitle note title_plus_variant isPublished
5223
 8551
 0195a40b-48f7-729b-bcba-8ea5bb51b60d
 True
 2025-03-17 12:19:17
   2025-03-17 12:19:18
   79
   False
 
{"id": 8551, "note": "Activities such as sleeping, grooming, and personal care are not included in the data. Relationships used to categorize people are not exhaustive and time spent with multiple people counts toward all (e.g., attending a party with friends and partner counts toward both \"friends\" and \"partner\").", "slug": "who-americans-spend-their-time-with", "title": "Who Americans spend their time with, by age group", "yAxis": {"min": 0, "facetDomain": "independent"}, "$schema": "https://files.ourworldindata.org/schemas/grapher-schema.007.json", "version": 106, "subtitle": "Measured in hours per day, based on annual averages from surveys in the United States.", "originUrl": "ourworldindata.org/time-use", "chartTypes": ["LineChart", "SlopeChart"], "dimensions": [{"display": {"name": "Alone", "includeInTable": true}, "property": "y", "variableId": 1015573}, {"display": {"name": "With friends", "unit": "Hours", "includeInTable": true}, "property": "y", "variableId": 1015585}, {"display": {"name": "With children", "includeInTable": true}, "property": "y", "variableId": 1015576}, {"display": {"name": "With family", "includeInTable": true}, "property": "y", "variableId": 1015582}, {"display": {"name": "With partner", "unit": "Hours", "includeInTable": true}, "property": "y", "variableId": 1015594}, {"display": {"name": "With co-workers", "includeInTable": true}, "property": "y", "variableId": 1015579}], "entityType": "age group", "isPublished": false, "variantName": "Over time", "internalNotes": "This chart is too complex to publish, but we should keep it as a draft because it is very useful for coming up with data insights.", "timelineMinTime": 2010, "entityTypePlural": "age groups", "relatedQuestions": [{"url": "https://ourworldindata.org/time-with-others-lifetime", "text": "Who do we spend time with across our lifetime?"}], "selectedEntityNames": ["15-29 years", "30-44 years", "45-59 years", "60+ years"], "selectedFacetStrategy": "metric", "hideAnnotationFieldsInTitle": {"time": true, "entity": true, "changeInPrefix": true}}
 who-americans-spend-their-time-with
 LineChart
 Who Americans spend their time with, by age group
 Measured in hours per day, based on annual averages from surveys in the United States.
 Activities such as sleeping, grooming, and personal care are not included in the data. Relationships used to categorize people are not exhaustive and time spent with multiple people counts toward all (e.g., attending a party with friends and partner counts toward both "friends" and "partner").
 Who Americans spend their time with, by age group (Over time)
 False