RSV Trends

data = {
  const co2data = await FileAttachment('https://raw.githubusercontent.com/wf-id/rsv-tracker/main/output/rsv_all_combined_latest.csv')
    .csv({ typed: true });
  return co2data.map(d => { 
    d["Label"] = d["state"] + ' ' + d["percent_positive"];
    return d; 
  });
}

Select the desired state to display. Note that you can select multiple states by clicking with the “ctrl key.”

states_to_select = data.map(d => d.state)

states_to_select_use = {
    if(states_to_select === null){
        return ["NC"]
    } else {
        return states_to_select
    }
}

viewof islands = Inputs.select(["NC"].concat(states_to_select_use), {
  multiple: true, 
  label: "State", 
  value: ["NC"],
  sort: true, 
  unique: true})
  
 //islands

viewof start = Inputs.date({label: "Start date", value: "2022-01-02"})

//#| eval: true
Plot.plot({
  y: {
    grid: true,
    label: "RSV PCR Positivity"
  },
  marks: [
    Plot.line(filtered2, {
    x: "week", 
    y: "percent_positive", 
    stroke: "state"}),
    Plot.text(filtered2, Plot.selectLast({
    x: "week",
    y: "percent_positive",
    z: "state",
    text: "state",
    textAnchor: "CasesCumulativeCNT",
    })
    ),
  ]
});

//#| eval: true
Plot.plot({
  y: {
    grid: true,
    label: "RSV PCR Positivity Yearly Comparisons"
  },
  x: {
    label: "Week Number"
  },
  facet : {
    data: filtered,
    x: "state"
  },
  marks: [
    Plot.frame(),
    Plot.line(filtered, {
    x: "epi_week", 
    y: "percent_positive", 
    stroke: "epi_year"}),
    Plot.text(filtered, Plot.selectLast({
    x: "epi_week",
    y: "percent_positive",
    z: "epi_year",
    text: "epi_year",
    textAnchor: "CasesCumulativeCNT",
    })
    ),
  ]
});

filtered = data.filter(function(data) {
  return islands.includes(data.state);
});

filtered2 = filtered.filter(d => d.week >= start);

Inputs.table(filtered2, {
    columns : [
        "week",
        "state",
        "percent_positive",
        "total_pcr_tests",
        "pcr_detections"
    ],
    header : {
        week: "Reporting Week",
        state: "State",
        percent_positive: "Percent Positive",
        total_pcr_tests: "Total PCR Tests",
        pcr_detections: "Total PCR Positive"

    }
})