29:null 2a:["$","title",null,{"children":"Romance book covers exploration | Alice Liang | Observable"}] 2f:T1293,SELECT year, season, case when season = 'Spring' then '1-' else '2-' end as season_prefix, ISBN, title, publisher, case when "Cover URL override" is not null then "Cover URL override" when google_thumbnail is not null then replace(google_thumbnail,'&edge=curl','') else replace(google_smallThumbnail,'&edge=curl','') end as cover_url, "Style", "# of People", "Man Partially Unclothed", "Woman Partially Unclothed", "Two People Touching", "Has POC", "Font Style", case when "Man Partially Unclothed" = true and "Woman Partially Unclothed" = true then 'Man and Woman Both Partially Unclothed' when "Man Partially Unclothed" = true and "Woman Partially Unclothed" = false then 'Only Man Partially Unclothed' when "Man Partially Unclothed" = false and "Woman Partially Unclothed" = true then 'Only Woman Partially Unclothed' else 'Everyone Clothed' end as "Clothing Style", case when "Two People Touching" = true and "Has POC" = true then 'POC with Two People Touching' when "Two People Touching" = true and "Has POC" = false then 'Non-POC with Two People Touching' when "Two People Touching" = false and "Has POC" = true then 'POC with No One Touching' else 'Non-POC with No One Touching' end as "Has POC with Touching", case when "Style" = 'Illustrated' and "Has POC" = true then 'POC on Illustrated Cover' when "Style" = 'Illustrated' and "Has POC" = false then 'Non-POC on Illustrated Cover' when "Style" = 'Photorealistic' and "Has POC" = true then 'POC on Photorealistic Cover' when "Style" = 'Photorealistic' and "Has POC" = false then 'Non-POC on Photorealistic Cover' else 'Unknown' end as "Has POC with Cover Style", case when ("Man Partially Unclothed" = true or "Woman Partially Unclothed" = true) and "Has POC" = true then 'POC with Someone Partially Unclothed' when ("Man Partially Unclothed" = true or "Woman Partially Unclothed" = true) and "Has POC" = false then 'Non-POC with Someone Partially Unclothed' when ("Man Partially Unclothed" = false and "Woman Partially Unclothed" = false) and "Has POC" = true then 'POC with Everyone Clothed' else 'Non-POC with Everyone Clothed' end as "Has POC with Clothing Style", case when "# of People" = 0 and "Style" = 'Illustrated' then TRUE else FALSE end as "Illustrated with No People", -- not sure this publisher override is right... need to do some research case when publisher='Avon' then 'Avon' when publisher='Avon Impulse' then 'Avon' when publisher='Bold Strokes' then 'Bold Strokes' when publisher='Bold Strokes Books' then 'Bold Strokes' when publisher='Kensington' then 'Kensington' when publisher='Kensington/Aphrodisia' then 'Kensington' when publisher='Kensington/Brava' then 'Kensington' when publisher='Kensington/Dafina' then 'Kensington' when publisher='Dafina' then 'Kensington' when publisher='Kensington/Lyrical' then 'Kensington' when publisher='Kensington/Lyrical Shine' then 'Kensington' when publisher='Kensington/Zebra' then 'Kensington' when publisher='Kensington/Zebra Shout' then 'Kensington' when publisher='Kensington/Zebra/Shout' then 'Kensington' when publisher='Harlequin' then 'Harlequin' when publisher='Harlequin Desire' then 'Harlequin' when publisher='Harlequin HQN' then 'Harlequin' when publisher='Harlequin Intrigue' then 'Harlequin' when publisher='Harlequin Kimani' then 'Harlequin' when publisher='Harlequin Kimani Arabesque' then 'Harlequin' when publisher='Harlequin Kimani Romance' then 'Harlequin' when publisher='Harlequin MIRA' then 'Harlequin' when publisher='Harlequin Presents' then 'Harlequin' when publisher='Harlequin Romance' then 'Harlequin' when publisher='Harlequin Special Edition' then 'Harlequin' when publisher='Harlequin/Carina Press' then 'Harlequin' when publisher='Harlequin/HQN' then 'Harlequin' when publisher='Harlequin/Kimani' then 'Harlequin' when publisher='Harlequin/MIRA' then 'Harlequin' when publisher='HQN' then 'Harlequin' when publisher='Hqn' then 'Harlequin' when publisher='Morrow' then 'Morrow' when publisher='Morrow/Dey Street' then 'Morrow' when publisher='Sourcebooks Casablanca' then 'Sourcebooks' when publisher='Sourcebooks Landmark' then 'Sourcebooks' when publisher='St. Martin’s' then 'St. Martin’s' when publisher='St. Martin’s Griffin' then 'St. Martin’s' when publisher='St. Martin’s Paperbacks' then 'St. Martin’s' when publisher='St. Martin’s/Dunne' then 'St. Martin’s' when publisher='Zebra' then 'Zebra' when publisher='Zebra Shout' then 'Zebra' when publisher='Berkley' then 'Berkley' when publisher = 'Forever' then 'Forever' else 'Other' end as publisher_group FROM "listings_with_metadata@4.csv"30:[{"id":"1b679b4cc691d6d05f14e679a4a08c48491cb3803492c7fa609a393e600f53888cddbb8791f7decb413669b29e2642756c5bc06a3d066b27d7b0fc9e59738af2","href":"https://static.observableusercontent.com/files/1b679b4cc691d6d05f14e679a4a08c48491cb3803492c7fa609a393e600f53888cddbb8791f7decb413669b29e2642756c5bc06a3d066b27d7b0fc9e59738af2","name":"listings.csv","type":"text/csv","lastModified":1675893805650.763,"size":361268},{"id":"7e7dc4bf5b621e1ae4231651b0da0b7c5fcd86086214c83e7fea644405ffd052af35ab37a58c7851dce1fb808e19199e3b61e13668a0fc4decf3731330cb5d72","href":"https://static.observableusercontent.com/files/7e7dc4bf5b621e1ae4231651b0da0b7c5fcd86086214c83e7fea644405ffd052af35ab37a58c7851dce1fb808e19199e3b61e13668a0fc4decf3731330cb5d72","name":"listings_with_metadata@1.csv","type":"text/csv","lastModified":1675895112327.614,"size":1615917},{"id":"eaba0029fc7b8ff82988b304861d97370fc9ef8581e2e83378cc1b235bebc6bef5282bd449a157735eb91e9b6b5576571617f6a1deb4d99993da9673b5f5bf2e","href":"https://static.observableusercontent.com/files/eaba0029fc7b8ff82988b304861d97370fc9ef8581e2e83378cc1b235bebc6bef5282bd449a157735eb91e9b6b5576571617f6a1deb4d99993da9673b5f5bf2e","name":"hardcoded_cover_metadata.csv","type":"text/csv","lastModified":1675893848541.963,"size":330942},{"id":"e2f53199c14c21bd442d4c7478a3dd74e5ce34985e52f50022bc2c07731e1795fa6a9e8cb4305b15c929f5d1ba78e24f2bc50240f84f2aca9c5ab4894c5d989d","href":"https://static.observableusercontent.com/files/e2f53199c14c21bd442d4c7478a3dd74e5ce34985e52f50022bc2c07731e1795fa6a9e8cb4305b15c929f5d1ba78e24f2bc50240f84f2aca9c5ab4894c5d989d","name":"listings_with_metadata.csv","type":"text/csv","lastModified":1675894399169.737,"size":1608114},{"id":"ce163d71f21ad38e7c849a654715593574635efa53afced09d40a11d0b3dd56a1fe626bf54b53cd593f3a8bf5cce54c48bb8522b5409c20541f71b1a580dec2e","href":"https://static.observableusercontent.com/files/ce163d71f21ad38e7c849a654715593574635efa53afced09d40a11d0b3dd56a1fe626bf54b53cd593f3a8bf5cce54c48bb8522b5409c20541f71b1a580dec2e","name":"listings_with_metadata@2.csv","type":"text/csv","lastModified":1683643036691.86,"size":743888},{"id":"ca838e70c8543c503611e42aa9bf45b779d611c778c77f041e938b52911d774eb712d4acabc028977a611a4c250ccbc39ff7aac9f8d39f94cc171feaea17a0ff","href":"https://static.observableusercontent.com/files/ca838e70c8543c503611e42aa9bf45b779d611c778c77f041e938b52911d774eb712d4acabc028977a611a4c250ccbc39ff7aac9f8d39f94cc171feaea17a0ff","name":"listings_with_metadata@4.csv","type":"text/csv","lastModified":1687373653075.151,"size":801155},{"id":"ff0224e98908841408130233081929581ea94da7f0dc902c54a7ba416367003a6af58d2cd0c46dbf0c481870b24659b267f07d2f5c4b7a02aa75813cec2b73c9","href":"https://static.observableusercontent.com/files/ff0224e98908841408130233081929581ea94da7f0dc902c54a7ba416367003a6af58d2cd0c46dbf0c481870b24659b267f07d2f5c4b7a02aa75813cec2b73c9","name":"full_pw_database_with_metadata.csv","type":"text/csv","lastModified":1686944997906.784,"size":9280565},{"id":"6da47c117634a00b6c09a0e408338b0f0c751e1ba9c870126d453d356a2f67d88bf830bfadb3144deff68bc16604a9c00998338c6c55eb5d24ac7d11359196b0","href":"https://static.observableusercontent.com/files/6da47c117634a00b6c09a0e408338b0f0c751e1ba9c870126d453d356a2f67d88bf830bfadb3144deff68bc16604a9c00998338c6c55eb5d24ac7d11359196b0","name":"listings_with_metadata@3.csv","type":"text/csv","lastModified":1683650504862.214,"size":770478}] 2d:{"id":"129a71e905f82451","slug":null,"title":"Romance book covers exploration","thumbnail":"fa2ba3959a95bc263bf78178f61a51385a906b6774627c827e2678ab506a092d","access_level":"public","create_time":"$D2023-02-08T22:02:49.007Z","update_time":"$D2023-07-10T19:11:39.760Z","view_time":null,"first_public_time":"$D2023-02-08T22:02:49.007Z","fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"ab85b37fc058d26e","login":"aliceyliang","name":"Alice Liang","avatar_url":"https://avatars-next.observableusercontent.com/42acc11ea71789c6252966d21e8c6eb73a8e1dfab9e61cabc2d0ce101eb15872","tier":"starter_2024"},"version":2281,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"165fa137d45ac6aa","login":"aliceyliang","name":"Alice Liang","avatar_url":"https://avatars-next.observableusercontent.com/42acc11ea71789c6252966d21e8c6eb73a8e1dfab9e61cabc2d0ce101eb15872","tier":null}],"members":[{"type":"individual","id":"165fa137d45ac6aa","login":"aliceyliang","name":"Alice Liang","avatar_url":"https://avatars-next.observableusercontent.com/42acc11ea71789c6252966d21e8c6eb73a8e1dfab9e61cabc2d0ce101eb15872","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"subscribed":null,"forks":2,"collection":null,"type":"notebook","body":{"title":"Romance book covers exploration","cells":[{"id":1158,"value":"# Romance book covers exploration\n\n[This data was scraped](https://github.com/aliceyliang/romance-covers/blob/main/exploration.ipynb) from Publishers Weekly's biannual announcements from 2013-2023 in the Romance & Erotica category, manually coded for metadata, and then imported for visualization.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":785,"value":"---\n## Cover exploration\n\nUse this tool to visually explore book covers by the available dimensions.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":848,"value":"viewof form = Inputs.form({\n yearInterval: interval([2011, 2023], {step: 1, value: [2011, 2023], label: 'Choose years'}),\n season: Inputs.checkbox([\"Spring\", \"Fall\"], {label: \"Season\", value: [\"Spring\", \"Fall\"]}),\n style: Inputs.checkbox([\"Illustrated\", \"Photorealistic\", \"Unknown\"], {label: \"Cover style\", value: [\"Illustrated\", \"Photorealistic\", \"Unknown\"]}),\n has_poc: Inputs.checkbox([true, false], {label: \"Has POC\", value: [true, false]}),\n has_touching: Inputs.checkbox([true, false], {label: \"Has two people touching\", value: [true, false]}),\n clothing_style: Inputs.checkbox(listings.map(d => d['Clothing Style']), {unique: true, value:[\"Only Man Partially Unclothed\",\"Only Woman Partially Unclothed\",\"Everyone Clothed\",\"Man and Woman Both Partially Unclothed\"], label: \"Clothing Style\"}),\n publishers: Inputs.select(listings.map(d => d['publisher_group']), {sort:true, unique: true, multiple: true, value:[\"Avon\",\"Berkley\"], label: \"Select publisher(s)\"})\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1028,"value":"\n#### Legend\n##### 🔸: Has someone partially unclothed\n##### 🔵: Has POC on cover","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":491,"value":"Plot.plot({\n marginLeft: 50,\n y: {type: \"point\", grid: true},\n marks: [\n Plot.image(chart_data, Plot.dodgeX({y:\"year\", src: \"cover_url\", padding: 32, width: 50})),\n Plot.text(chart_data, Plot.dodgeX({y:\"year\", padding:32, textAnchor: \"end\", dx: 5, dy:-25, \n text: d => d['Has POC']===true ? \"🔵\" : \"\" })),\n Plot.text(chart_data, Plot.dodgeX({y:\"year\", padding:32, textAnchor: \"end\", dx: 5, dy:-25, \n text: d => d['Clothing Style']!=='Everyone Clothed' ? \"🔸\" : \"\" }))\n ],\n height: 800,\n width: 1000,\n style: {\n backgroundColor: '#eeeee9'\n }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1160,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":1401,"value":"## Data & Trends\nThree primary trends:\n* Significantly fewer people unclothed on covers\n* More people of color on covers\n* Majority of covers are illustrated rather than photorealistic now\n\n##### Data preview below:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":915,"value":"$2f","pinned":false,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"listings_sql","database":"listings_with_metadata@4.csv"},{"id":1407,"value":"Illustrated covers slowly increased in popularity starting in 2018, increasing rapidly from 2020 on. (Note some 2023 covers are not available yet)\n\nSome thoughts on this in the world:\n* [\"As Illustrated Covers Trend in Romance, What is Being Said About Women's Interests?\"](https://bookriot.com/illustrated-romance-book-covers/) - Aug. 2019\n* [\"How These Instagrammable Book Covers Are Tricking People Into Reading Romance\"](https://www.refinery29.com/en-us/2018/10/213494/romance-novel-cover-trend-modern) - Oct. 2018\n* [\"There is a Major Problem With Modern Book Cover Design\"](https://baos.pub/there-is-a-major-problem-with-modern-book-cover-design-b3c4c45d5bf5) - Nov. 2021","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":69,"value":"plot_percent(listings, \"Style\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1967,"value":"plot_percent(listings, \"# of People\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1419,"value":"Noting that there can be a great deal of error in manually coding POC on covers —\nPOC on covers increase dramatically in early 2020 and hovers around 20% from there.\n\nSome writing on general diversity in the industry: \n* https://www.therippedbodicela.com/state-racial-diversity-romance-publishing-report\n* https://www.seattletimes.com/entertainment/books/why-romance-novels-more-diverse-than-ever-are-having-a-moment/\n* [Diversity in Romance Novels: Race, Sexuality, Neurodivergence, Disability, and Fat Representation](https://link.springer.com/article/10.1007/s12109-022-09881-6)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":195,"value":"plot_percent(listings, \"Has POC\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1428,"value":"With the timeline overlap in these trends, we see more POC on illustrated covers from 2020 onward. As a result, a higher share of covers that have POC on them are illustrated rather than photorealistic.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":1500,"value":"Plot.plot({\n height: 150,\n width: 250,\n padding: 0.05,\n grid: true,\n marginLeft: 100,\n x: {\n label: \"Has POC on cover\"\n },\n y: {\n label: \"Style\"\n },\n color: {\n type: \"linear\",\n scheme: \"YlOrRd\",\n },\n marks: [\n Plot.cell(has_poc_style_count, { // a cell is a rectangle\n x: \"Has POC\", // for each item_a there will be an x position\n y: \"Style\", // for each item_b there will be a y position\n fill: \"count\" // the fill color will correspond to the count\n }),\n Plot.text(has_poc_style_count, {\n x: \"Has POC\",\n y: \"Style\",\n text: \"count\"\n })\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1424,"value":"plot_percent(listings.filter(e => e['Has POC']===true), \"Has POC with Cover Style\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1437,"value":"plot_percent(listings.filter(e => e['Style']===\"Photorealistic\"), \"Has POC with Cover Style\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1560,"value":"Cursory looks at other dimensions such as font style, which is more consistent over time:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":126,"value":"plot_percent(listings, \"Font Style\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1563,"value":"Another trend is how fewer and fewer styles have people on the covers unclothed over time, declining since around 2016 to less than 10% in recent years.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":946,"value":"plot_percent(listings, \"Clothing Style\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1582,"value":"Although whether illustration or photorealism, and clothed or not, romance covers have people touching as ever before:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":192,"value":"plot_percent(listings, \"Two people touching\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1586,"value":"POC on covers are touching as well —","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":944,"value":"plot_percent(listings, \"Has POC with Touching\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1589,"value":"It tends to be that most of the unclothed people on covers are white. The trend split from 2019 Fall to 2020 Spring is particularly notable.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":950,"value":"plot_percent(listings, \"Has POC with Clothing Style\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1592,"value":"#### The next few charts reflect trends from publishers\nThis needs to be amended with a bit more research on what publisher groups belong to others for most effective analysis. In a preliminary grouping, the top 10 are listed below:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":390,"value":"plot_percent(listings, \"publisher_group\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1594,"value":"With Harlequin leading in POC covers, and others following since 2020. Kensington has been a more consistent publisher of POC on covers. Smaller publishers followed in subsequent years (pending if they belong to larger groups?)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":1450,"value":"Plot.plot({\n height: 300,\n padding: 0.05,\n grid: true,\n marginLeft: 100,\n x: {\n label: \"year\"\n },\n y: {\n label: \"Main publishers\"\n },\n color: {\n type: \"linear\",\n scheme: \"GnBu\",\n legend: true,\n label: \"Proportion POC covers\"\n },\n marks: [\n Plot.cell(publisher_summary, { // a cell is a rectangle\n x: \"year\", // for each item_a there will be an x position\n y: \"publisher_group\", // for each item_b there will be a y position\n fill: \"percent_poc_covers\" // the fill color will correspond to the count\n }),\n Plot.text(publisher_summary, {\n x: \"year\",\n y: \"publisher_group\",\n text: d => d.percent_poc_covers?.toFixed(1)\n })\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1352,"value":"Plot.plot({\n y: {\n grid: true,\n label: \"# of publications with POC on the cover, by publisher and year\"\n },\n marks: [\n Plot.barY(publisher_summary, {x: \"year\", y: \"poc_covers\", sort: {x: \"x\"}, fill: \"publisher_group\"})\n ],\n color: {\n legend: true,\n scheme: \"tableau10\"\n }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1597,"value":"Illustrated covers have been led by Berkley and followed by most other publishers.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":1388,"value":"Plot.plot({\n y: {\n grid: true,\n percent: true,\n label: \"% of Listings with Illustrated Cover, by Publisher\"\n },\n marks: [\n Plot.ruleY([0]),\n Plot.line(publisher_summary, {x: \"year\", y: \"percent_illustrated_covers\", z: \"publisher_group\", stroke: \"publisher_group\", marker: \"circle\"})\n ],\n color: {\n legend: true,\n scheme: \"tableau10\"\n }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1166,"value":"----","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":1086,"value":"## Appendix\n\nFunctions & data prep","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":1064,"value":"import {interval} from '@mootari/range-slider@1781'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":788,"value":"chart_data = listings.filter(e => form.publishers.includes(e['publisher_group']))\n .filter(e => form.has_poc.includes(e['Has POC']))\n .filter(e => form.has_touching.includes(e['Two people touching'])) \n .filter(e => form.clothing_style.includes(e['Clothing Style']))\n .filter(e => form.style.includes(e['Style']))\n .filter(e => form.season.includes(e['season']))\n .filter(e => e['year'] >= form.yearInterval[0] && e['year'] <= form.yearInterval[1])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":131,"value":"function addColumn(tableData, newColumnName, newColumnFunction) {\n return tableData.map(row => {\n let returnObject = row;\n returnObject[newColumnName] = newColumnFunction(row)\n return returnObject\n })\n};","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":123,"value":"function plot_percent(data, fill_column) {\n return Plot.plot({\n y: {\n grid: true,\n percent: true,\n label: \"% of Listings by \" + fill_column\n },\n facet: {\n data: data,\n x: \"Year Season\"\n },\n fx: {\n tickRotate: -45,\n label: \"\"\n },\n marks: [\n Plot.barY(data, Plot.groupZ({y: \"proportion-facet\"}, {fill: fill_column})),\n Plot.ruleY([0, 1]),\n ],\n color: {\n legend: true,\n },\n marginBottom: 60\n });\n \n}\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":145,"value":"listings = addColumn(listings_sql.map((d) =>\n Object.fromEntries(\n Object.keys(d).map((key) => [key, d[key] === \"\" ? \"Unknown\" : d[key]])\n )\n).map((d) =>\n Object.fromEntries(\n Object.keys(d).map((key) => [key, d[key] === null ? \"Unknown\" : d[key]])\n )\n), 'Year Season', row => row['year'] + \"-\" + row['season_prefix'] + row['season'])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1188,"value":"select year, publisher_group, \n cast(count(distinct ISBN) as float) as covers, \n cast(count(case when \"Has POC\" = true then ISBN end) as float) as poc_covers, \n cast(count(case when \"Has POC\" = true then ISBN end) as float) / cast(count(distinct ISBN) as float) as percent_poc_covers,\n cast(count(case when \"Style\" = 'Illustrated' then ISBN end) as float) as illustrated_covers, \n cast(count(case when \"Style\" = 'Illustrated' then ISBN end) as float) / cast(count(distinct ISBN) as float) as percent_illustrated_covers,\nfrom listings\ngroup by 1,2\norder by 1,2","pinned":false,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"publisher_summary","database":"var:listings"},{"id":1506,"value":"select \"Has POC\", \"Style\", cast(count(distinct ISBN) as float) as count\nfrom listings\nwhere \"Style\" != 'Unknown'\ngroup by 1,2\n","pinned":false,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"has_poc_style_count","database":"var:listings"},{"id":1950,"value":"listings_with_metadata2 = await FileAttachment(\"listings_with_metadata@4.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1987,"value":"---\n\n## Covers by section for copy\nRefer to charts above for percentages\n\n#### Unclothed","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":1991,"value":"Unclothed / 2011-2013 (83 covers)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":1993,"value":"Plot.plot({\n marginLeft: 100,\n y: {type: \"point\", grid: true},\n marks: [\n Plot.image(listings.filter(e => [\"Only Woman Partially Unclothed\",\"Only Man Partially Unclothed\",\"Man and Woman Both Partially Unclothed\"].includes(e['Clothing Style'])).filter(e => e['year'] >= 2011 && e['year'] <= 2013), Plot.dodgeX({y:\"Year Season\", src: \"cover_url\", padding: 32, width: 50}))\n ],\n height: 500,\n width: 1100 \n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":2022,"value":"Unclothed / 2014-2016 (67 covers)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":2001,"value":"Plot.plot({\n marginLeft: 100,\n y: {type: \"point\", grid: true},\n marks: [\n Plot.image(listings.filter(e => [\"Only Woman Partially Unclothed\",\"Only Man Partially Unclothed\",\"Man and Woman Both Partially Unclothed\"].includes(e['Clothing Style'])).filter(e => e['year'] >= 2014 && e['year'] <= 2016), Plot.dodgeX({y:\"Year Season\", src: \"cover_url\", padding: 32, width: 50}))\n ],\n height: 500,\n width: 1100\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":2027,"value":"Unclothed / 2017-2019 (28 covers)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":2029,"value":"Plot.plot({\n marginLeft: 100,\n y: {type: \"point\", grid: true},\n marks: [\n Plot.image(listings.filter(e => [\"Only Woman Partially Unclothed\",\"Only Man Partially Unclothed\",\"Man and Woman Both Partially Unclothed\"].includes(e['Clothing Style'])).filter(e => e['year'] >= 2017 && e['year'] <= 2019), Plot.dodgeX({y:\"Year Season\", src: \"cover_url\", padding: 32, width: 50}))\n ],\n height: 500,\n width: 1100\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":2036,"value":"Unclothed / 2020-2023 (18 covers and it's an extra year)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":2035,"value":"Plot.plot({\n marginLeft: 100,\n y: {type: \"point\", grid: true},\n marks: [\n Plot.image(listings.filter(e => [\"Only Woman Partially Unclothed\",\"Only Man Partially Unclothed\",\"Man and Woman Both Partially Unclothed\"].includes(e['Clothing Style'])).filter(e => e['year'] >= 2020 && e['year'] <= 2023), Plot.dodgeX({y:\"Year Season\", src: \"cover_url\", padding: 32, width: 50}))\n ],\n height: 500,\n width: 1100\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":2050,"value":"#### Cover style","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":2086,"value":"Style / 2011 - 2015 (21 covers, some seasons didn't even have any)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":2054,"value":"Plot.plot({\n marginLeft: 100,\n y: {type: \"point\", grid: true},\n marks: [\n Plot.image(listings.filter(e => [\"Illustrated\"].includes(e['Style'])).filter(e => e['year'] >= 2011 && e['year'] <= 2015), Plot.dodgeX({y:\"year\", src: \"cover_url\", padding: 32, width: 50}))\n ],\n height: 500,\n width: 1100 \n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":2089,"value":"Style / 2016 - 2019 (58 covers)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":2082,"value":"Plot.plot({\n marginLeft: 100,\n y: {type: \"point\", grid: true},\n marks: [\n Plot.image(listings.filter(e => [\"Illustrated\"].includes(e['Style'])).filter(e => e['year'] >= 2016 && e['year'] <= 2019), Plot.dodgeX({y:\"year\", src: \"cover_url\", padding: 32, width: 50}))\n ],\n height: 500,\n width: 1100 \n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":2092,"value":"Style / 2020-2021 (114 covers) - how do we display? had to switch to seasons AND make it smaller","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":2064,"value":"Plot.plot({\n marginLeft: 100,\n y: {type: \"point\", grid: true},\n marks: [\n Plot.image(listings.filter(e => [\"Illustrated\",\"Unknown\"].includes(e['Style'])).filter(e => e['year'] >= 2020 && e['year'] <= 2021), Plot.dodgeX({y:\"Year Season\", src: \"cover_url\", padding: 32, width: 50}))\n ],\n height: 500,\n width: 1700 \n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":2098,"value":"Style / 2022 - 2023 (X covers)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":2062,"value":"Plot.plot({\n marginLeft: 100,\n y: {type: \"point\", grid: true},\n marks: [\n Plot.image(listings.filter(e => [\"Illustrated\"].includes(e['Style'])).filter(e => e['year'] >= 2022 && e['year'] <= 2023), Plot.dodgeX({y:\"Year Season\", src: \"cover_url\", padding: 32, width: 50}))\n ],\n height: 500,\n width: 1700 \n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":2158,"value":"Plot.plot({\n marginLeft: 100,\n y: {type: \"point\", grid: true},\n marks: [\n Plot.image(listings.filter(e => [\"Illustrated\"].includes(e['Style'])).filter(e => e['year'] >= 2022 && e['year'] <= 2023), Plot.dodgeX({y:\"Year Season\", src: \"cover_url\", padding: 32, width: 50}))\n ],\n height: 500,\n width: 1700 \n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":2134,"value":"#### Representation","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":2190,"value":"Plot.plot({\n marginLeft: 100,\n y: {type: \"point\", grid: true},\n marks: [\n Plot.image(listings.filter(e => e['Has POC']===true).filter(e => e['year'] >= 2011 && e['year'] <= 2019), Plot.dodgeX({y:\"year\", src: \"cover_url\", padding: 32, width: 50}))],\n height: 500,\n width: 1100 \n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":2189,"value":"Plot.plot({\n marginLeft: 100,\n y: {type: \"point\", grid: true},\n marks: [\n Plot.image(listings.filter(e => e['Has POC']===true).filter(e => e['year'] >= 2020 && e['year'] <= 2023), Plot.dodgeX({y:\"year\", src: \"cover_url\", padding: 32, width: 50}))],\n height: 500,\n width: 1100 \n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":2203,"value":"---\n## PW full database 2018-2023","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":2217,"value":"pw_database_raw = await FileAttachment(\"full_pw_database_with_metadata.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":2221,"value":"SELECT distinct title, author, publisher, ISBN, google_smallThumbnail as cover_url, year(publication_date) as year, year(publication_date) + cast(month(publication_date) as float)/100 as year_month, year(publication_date) + cast(week(publication_date) as float)/100 as year_week FROM \"full_pw_database_with_metadata\"","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"pw_database","database":"full_pw_database_with_metadata.csv"},{"id":2220,"value":"Plot.plot({\n marginLeft: 100,\n y: {type: \"point\", grid: true},\n marks: [\n Plot.image(pw_database, Plot.dodgeX({y:\"year_week\", src: \"cover_url\", padding: 32, width: 50}))],\n height: 15000,\n width:1300 \n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":2232,"value":"pw_database.filter(e => e['year'] >= 2020 && e['year'] <= 2023)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"}],"files":"$W30","stdlib":"1","titling":"auto"}} 2e:"$2d:body"