2c:null 2d:["$","title",null,{"children":"Table 2: YouTube entry points for Political Content | Computational Social Science Lab | Observable"}] 32:T577,viewof tbl2t3_7k_processed = tbl2t3_7k_raw_data .rename({ aggregated_label: "label" }) .derive({ label: (d) => (d.label == "IDW" ? "AW" : d.label), y: (d) => op.parse_float(d.percentge), x: (d) => op.parse_date(d.year + "-" + (d.month < 10 ? "0" + d.month : d.month)), subvalue: (d) => op.parse_int(d.counts), category: (d) => op.parse_int(d.cases) }) .select("label", "x", "y", "subvalue", "category") .groupby("label", "category") .orderby("x") .derive({ rolling_y: aq.rolling((d) => op.mean(d.y), [-2, 0]), category: (d) => d.category == 1 ? "YT Homepage" : d.category == 2 ? "Search" : d.category == 3 ? "YT Channel" : d.category == 4 ? "YT Video" : d.category == 5 ? "External URLs" : d.category == 6 ? "Other" : "ERROR: id not known" }) .orderby("x") .derive({ temporal: `d => { return {x: d.x, y: d.y, rolling_y: d.rolling_y, subvalue: d.subvalue, label: d.label, category: d.category}}` }) .groupby("label", "category") .rollup({ avg_value: op.mean("y"), avg_subvalue: op.mean("subvalue"), temporal: op.array_agg("temporal") }) .derive({ avg_value: (d) => op.round(d.avg_value * 100) / 100, avg_subvalue: (d) => op.round(d.avg_value * 100) / 100 }) .rename({ label: "y", category: "x" }) .view()33:T543,viewof tbl2t3_processed = tbl2t3_raw .derive({ label: (d) => (d.label == "IDW" ? "AW" : d.label), y: (d) => op.parse_float(d.percentge), x: (d) => op.parse_date(d.year + "-" + (d.month < 10 ? "0" + d.month : d.month)), subvalue: (d) => op.parse_int(d.counts), category: (d) => op.parse_int(d.cases) }) .select("label", "x", "y", "subvalue", "category") .groupby("label", "category") .orderby("x") .derive({ rolling_y: aq.rolling((d) => op.mean(d.y), [-2, 0]), category: (d) => d.category == 1 ? "YT Homepage" : d.category == 2 ? "Search" : d.category == 3 ? "YT Channel" : d.category == 4 ? "YT Video" : d.category == 5 ? "External URLs" : d.category == 6 ? "Other" : "ERROR: id not known" }) .orderby("x") .derive({ temporal: `d => { return {x: d.x, y: d.y, rolling_y: d.rolling_y, subvalue: d.subvalue, label: d.label, category: d.category}}` }) .groupby("label", "category") .rollup({ avg_value: op.mean("y"), avg_subvalue: op.mean("subvalue"), temporal: op.array_agg("temporal") }) .derive({ avg_value: (d) => op.round(d.avg_value * 100) / 100, avg_subvalue: (d) => op.round(d.avg_value * 100) / 100 }) .rename({ label: "y", category: "x" }) .view()34:[{"id":"072e5dbbfb06732f477b463fb77664eb71ef5d355ad1689b0649506a63ad0ea4ad919585c4ea4569b22dd67a326208e7872322a105eec5dfcf45a32d9bd2e647","href":"https://static.observableusercontent.com/files/072e5dbbfb06732f477b463fb77664eb71ef5d355ad1689b0649506a63ad0ea4ad919585c4ea4569b22dd67a326208e7872322a105eec5dfcf45a32d9bd2e647","name":"tbl2_temporal_v3.csv","type":"text/csv","lastModified":1652769440001.26,"size":116222},{"id":"feddb353f6d2f789a008d7d5252842c307ac1b7f2e8180a8f619b223c00ba459f4a50f8834833976f08bddb1719a63b08e45a328be4e2cc771a1851b33563685","href":"https://static.observableusercontent.com/files/feddb353f6d2f789a008d7d5252842c307ac1b7f2e8180a8f619b223c00ba459f4a50f8834833976f08bddb1719a63b08e45a328be4e2cc771a1851b33563685","name":"tbl2_barchart.csv","type":"text/csv","lastModified":1652770088636.954,"size":1170},{"id":"260142838d8a6c9f8074268aaca9aac216871907da46c9210aeb5641bd666c071bc759996a39c932515a9aca509bf4f2f76d59dc8db8d2d6cc20c3cba189d4b7","href":"https://static.observableusercontent.com/files/260142838d8a6c9f8074268aaca9aac216871907da46c9210aeb5641bd666c071bc759996a39c932515a9aca509bf4f2f76d59dc8db8d2d6cc20c3cba189d4b7","name":"table2_ledwich.csv","type":"text/csv","lastModified":1657304639196.49,"size":120677},{"id":"6b78ad2e3af85ceb5e1c7aa604a5fce12052c888646e477a7d85dc60045ddb06d2b3923d370b44755cd8bd878c0ccc6bea435cd9e8646b6fe51be4f8e4659878","href":"https://static.observableusercontent.com/files/6b78ad2e3af85ceb5e1c7aa604a5fce12052c888646e477a7d85dc60045ddb06d2b3923d370b44755cd8bd878c0ccc6bea435cd9e8646b6fe51be4f8e4659878","name":"table2_ledwich_tempral.csv","type":"text/csv","lastModified":1657304639196.244,"size":120592}] 30:{"id":"f735015ddfbbc2df","slug":"homa-table2","title":"Table 2: YouTube entry points for Political Content","thumbnail":"1107adee936a6242a8e33af18934e764fddd6d8eb0eaff0fe61be4381d28520e","access_level":"public","create_time":"$D2022-05-17T06:32:28.592Z","update_time":"$D2022-07-08T18:34:59.467Z","view_time":null,"first_public_time":"$D2022-05-17T14:05:05.498Z","has_unpublished_edits":null,"fork":false,"stars":1,"starred":false,"owner":{"type":"team","id":"ecc432f62c173a15","login":"wattslab","name":"Computational Social Science Lab","avatar_url":"https://avatars-next.observableusercontent.com/4cc949e746aa79aa4ecb9f0babaa098c3c5dbf10834c1e61e97aca8ee6aa5829","tier":"education_2026"},"version":165,"publish_version":165,"role":null,"authored":false,"authors":[{"type":"individual","id":"98d56a983fac65e1","login":"ghenry","name":"Henry Ge","avatar_url":"https://avatars-next.observableusercontent.com/61254385c8834287fc95d194b8416135cf35af836d15e78cafe4eaede11fea43","tier":null}],"members":[{"type":"individual","id":"98d56a983fac65e1","login":"ghenry","name":"Henry Ge","avatar_url":"https://avatars-next.observableusercontent.com/61254385c8834287fc95d194b8416135cf35af836d15e78cafe4eaede11fea43","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":true,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":{"id":"38f5db8cc12fbc44","slug":"youtube-politics","title":"YouTube Politics","owner":{"id":"ecc432f62c173a15","login":"wattslab","name":"Computational Social Science Lab"}},"type":"notebook","body":{"titling":"auto","title":"Table 2: YouTube entry points for Political Content","cells":[{"id":0,"value":"# Table 2: YouTube entry points for Political Content","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":49,"value":"## D3 Renders","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":88,"value":"tbl2_final = html`

${viewof table2Show}

${\n table2Show == \"tem\" ? tabel2_temporal : table2\n}

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":163,"value":"tbl2_final_7k = html`

${viewof table2Show_7k}

${\n table2Show == \"tem\" ? tabel2_temporal_7k : table2_7k\n}

`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":153,"value":"#### Selection","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":100,"value":"viewof table2Show = radio({\n title: \"Table 2 Version\",\n options: [\n { label: \"Summary\", value: \"bar\" },\n { label: \"Temporal\", value: \"tem\" }\n ],\n value: \"tem\"\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":161,"value":"viewof table2Show_7k = radio({\n title: \"Table 2 Version\",\n options: [\n { label: \"Summary\", value: \"bar\" },\n { label: \"Temporal\", value: \"tem\" }\n ],\n value: \"tem\"\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":63,"value":"#### Barchart Heatmap","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":81,"value":"table2 = barheatmap(\n tbl2_data.objects(),\n \"Video Location Method\",\n \"Political Label\",\n [\"YT Homepage\", \"Search\", \"YT Channel\", \"YT Video\", \"External URLs\", \"Other\"],\n [\"fL\", \"L\", \"C\", \"AW\", \"R\", \"fR\"]\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":155,"value":"table2_7k = barheatmap(\n tbl2_7k_processed_data.objects(),\n \"Video Location Method\",\n \"Political Label\",\n [\"YT Homepage\", \"Search\", \"YT Channel\", \"YT Video\", \"External URLs\", \"Other\"],\n [\"fL\", \"L\", \"C\", \"AW\", \"R\", \"fR\"]\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":59,"value":"#### Temporal Heatmap","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":53,"value":"tabel2_temporal = timesHeatMap(\n tbl2t3_processed.objects(),\n \"Access Point\",\n \"Political Label\",\n \"Percent of Videos\",\n [\"#ff1100\", \"#ffe100\", \"#26ff00\", \"#0040ff\", \"#ae00ff\", \"black\"],\n [\"#2166AC\", \"#92C5DE\", \"#7FC97F\", \"gray\", \"#F4A582\", \"#B2182B\"],\n [\"YT Homepage\", \"Search\", \"YT Channel\", \"YT Video\", \"External URLs\", \"Other\"],\n [\"fL\", \"L\", \"C\", \"AW\", \"R\", \"fR\"],\n [\"Far Left\", \"Left\", \"Center\", \"Anti-Woke\", \"Right\", \"Far Right\"],\n null\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":158,"value":"tabel2_temporal_7k = timesHeatMap(\n tbl2t3_7k_processed.objects(),\n \"Access Point\",\n \"Political Label\",\n \"Percent of Videos\",\n [\"#ff1100\", \"#ffe100\", \"#26ff00\", \"#0040ff\", \"#ae00ff\", \"black\"],\n [\"#2166AC\", \"#92C5DE\", \"#7FC97F\", \"gray\", \"#F4A582\", \"#B2182B\"],\n [\"YT Homepage\", \"Search\", \"YT Channel\", \"YT Video\", \"External URLs\", \"Other\"],\n [\"fL\", \"L\", \"C\", \"AW\", \"R\", \"fR\"],\n [\"Far Left\", \"Left\", \"Center\", \"Anti-Woke\", \"Right\", \"Far Right\"],\n null\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":44,"value":"## Data Tables","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":74,"value":"#### Table 2 barchart processed data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":78,"value":"viewof tbl2_data = tbl2t3_processed\n .rename({\n avg_value: \"value\",\n avg_subvalue: \"avg_subvalue\"\n })\n .select(aq.not(\"temporal\"))\n .view()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":70,"value":"#### Table 2 barchart raw data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":67,"value":"viewof tbl2_raw_data = aq\n .from(await FileAttachment(\"tbl2_barchart.csv\").csv())\n .view()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":134,"value":"#### Table 2 barchart processed new data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":136,"value":"viewof tbl2_7k_processed_data = tbl2t3_7k_processed\n .rename({\n avg_value: \"value\",\n avg_subvalue: \"subvalue\"\n })\n .select(aq.not(\"temporal\"))\n .view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":127,"value":"#### Table 2 barchart new raw data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":131,"value":"viewof tbl2_7k_raw_data = aq\n .from(await FileAttachment(\"table2_ledwich.csv\").csv())\n .view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":148,"value":"#### Table 2 temporal 7k processed data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":142,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":146,"value":"#### Table 2 temporal 7k raw data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":139,"value":"viewof tbl2t3_7k_raw_data = aq\n .from(await FileAttachment(\"table2_ledwich_tempral.csv\").csv())\n .view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":30,"value":"#### Table 2 temporal processed data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":26,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":36,"value":"#### Table 2 temporal raw data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":16,"value":"viewof tbl2t3_raw = aq\n .from(await FileAttachment(\"tbl2_temporal_v3.csv\").csv())\n .view()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":40,"value":"## Imports","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":19,"value":"import { aq, op } from \"@uwdata/arquero\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":21,"value":"d3 = require(\"d3@v6\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":56,"value":"import { barheatmap } from \"@wattslab/barheatmap\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6,"value":"import { basicLegend } from \"@wattslab/temporal-heatmap\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":11,"value":"import { timesHeatMap } from \"@wattslab/temporal-heatmap\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":103,"value":"import { radio, select, slider } from \"@jashkenas/inputs\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W34","stdlib":"1"}} 31:"$30:body"