2c:null 2d:["$","title",null,{"children":"Heaviest Venues in Philadelphia | Matt | Observable"}] 32:[] 30:{"id":"096329605e479372","slug":"heaviest-venues-in-philadelphia","title":"Heaviest Venues in Philadelphia","thumbnail":"001a83c218b93d63abd67dc6f16c39b0d4a46368a692401e2c7c7691957a6422","access_level":"public","create_time":"$D2023-04-12T03:33:55.544Z","update_time":"$D2023-04-13T15:21:35.717Z","view_time":null,"first_public_time":"$D2023-04-13T15:49:11.689Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"3a3bb9304a7e3301","login":"mroumaya","name":"Matt","avatar_url":"https://avatars-next.observableusercontent.com/6fa2a4318689b0bf7cd223287b719913fa410d400656c48a752e33d4cfbf73bb","tier":"starter_2024"},"version":582,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"d4421d7d8404f5b1","login":"mattroumaya","name":"Matt Roumaya","avatar_url":"https://avatars-next.observableusercontent.com/e91ed3ce344cda21e0ad14f12639517ed72f6ee156be8012780f4d6ed715a137","tier":null}],"members":[{"type":"individual","id":"d4421d7d8404f5b1","login":"mattroumaya","name":"Matt Roumaya","avatar_url":"https://avatars-next.observableusercontent.com/e91ed3ce344cda21e0ad14f12639517ed72f6ee156be8012780f4d6ed715a137","tier":null,"role":"editor"},{"type":"team","id":"3a3bb9304a7e3301","login":"mroumaya","name":"Matt","avatar_url":"https://avatars-next.observableusercontent.com/6fa2a4318689b0bf7cd223287b719913fa410d400656c48a752e33d4cfbf73bb","tier":"starter_2024","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Heaviest Venues in Philadelphia","cells":[{"id":0,"value":"# Heaviest Venues in Philadelphia","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":201,"value":"\n

Presented by phillymetal.net

\n\n $\"Philly$ \n","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":197,"value":"The visualization below shows the venues that have held and/or booked the most metal/hardcore/punk/heavy music shows since 04/12/2022, through all events booked in the future that are listed on [phillymetal.net](https://www.phillymetal.net). \n- This should update as new shows are added and/or removed.\n- Some shows haven't happened yet - the visualization represents anything that has happened or will happen (so far) for 2023.\n- Some shows might have been a blend of genres that you might not fully consider metal, hardcore, punk, or generally heavy. Deal with it.\n- Some venues are in New Jersey or Delaware, which kind of pains me, but it's close enough.\n- There might be inconsistencies with venue naming, even though I've tried to be really careful. Please [let me know](mailto: info@phillymetal.net) if you find any issues!\n- **Venues with 10 shows or more are shown in the chart below for legibility. Change the slider to see venues with less shows.**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":357,"value":"viewof minNum = Inputs.range([0, winners[0].count], {value: 10, step: 1, label: \"Minimum # of Shows\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":578,"value":"

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":477,"value":"chart = {\n\n let data = phillymetal.filter(el => el.count >= minNum)\n \n return BarChart(data, {\n x: d => d.count,\n y: d => d.venue,\n yDomain: d3.groupSort(data, ([d]) => -d.count, d => d.venue), // sort by descending frequency\n xLabel: \"# Shows Since 04/12/2022 →\",\n width,\n color: \"black\",\n marginLeft: 110\n})\n \n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":217,"value":"dt.view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":9,"value":"import { createClient } from \"@silentworks/supabase\";","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":92,"value":"import { aq, op } from '@uwdata/arquero'","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":471,"value":"import { BarChart } from \"@d3/horizontal-bar-chart\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":27,"value":"supabase = createClient(\n \"https://itvifawsdgiynkldcfnv.supabase.co\", \n\"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJzdXBhYmFzZSIsInJlZiI6Iml0dmlmYXdzZGdpeW5rbGRjZm52Iiwicm9sZSI6ImFub24iLCJpYXQiOjE2NjU0MDMyNzcsImV4cCI6MTk4MDk3OTI3N30.YvPD_C5yy5ELMJw-jt28uMTfwOoY7WPDeBOUy4JL0_0\"\n); ","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":34,"value":" async function getData() {\n let { data, error } = await supabase\n .from(\"main\")\n .select(\"show_date, description, venue\")\n .eq(\"validated\", \"true\")\n .order(\"show_date\");\n return data;\n }","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":36,"value":"data = getData();","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":97,"value":"dt = aq.from(data)\n.groupby('venue')\n.rollup({shows: op.count('venue')})\n.orderby(aq.desc('shows'))\n.fold()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":239,"value":"//1) combine the arrays:\nphillymetal = {\nlet aggregateData = {venue: dt._data.venue.data, shows: dt._data.shows.data}\nlet list = [];\nfor (var j = 0; j < aggregateData.shows.length; j++)\n list.push({ count: aggregateData.shows[j], venue: aggregateData.venue[j] });\n\nreturn list.sort(function (a, b) {\n return a.count < b.count ? 1 : a.count == b.count ? 0 : -1;\n});\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":288,"value":"winners = {\n let maxShows = Math.max(...phillymetal.map(e => e.count));\n let obj = phillymetal.filter(el => el.count === maxShows);\n \n return obj\n}\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":317,"value":"message = {\n \n let venues = winners.map(el => el.venue);\n let maxValue = winners[0].count\n let v = venues.length > 1 ? 'venues' : 'venue'\n let message = `Congratulations to ${venues.join(\" and \")} for being the heaviest ${v} in Philadelphia \\n ${maxValue} shows since 04/12/2022.`\n \n return message\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":580,"value":"insert = {\n let el = document.querySelector(\".message\")\n el.innerHTML += message;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W32","stdlib":"1"}} 31:"$30:body"