I added in the private schools for the September 8, 2021 data release about outbreak-associated cases in schools and then mapped it. This map shows Maryland public and private schools with outbreak-associated cases on September 8, 2021, as defined by the Maryland Health Department. Information about the trend of the number of cases at each school from September 1, 2021, is shown in the tooltips. As for the public schools, my Excel “database” should be ready for the next release of data on September 15, 2021. And I should be able to quickly create a number of related maps. I may choose to make a color-coded trend map like I did for the public schools for the September 8, 2021 data.
As with the other map I googled the addresses for the private schools. Then Datawrapper mapped the schools. I assume based on my knowledge of the locations of some of the schools that the locations are generally correct, but I have not checked them. These maps are only for my own learning about the software and data visualization. I am trying to get a sense of which type of data visualizations are most useful and engaging. After I make the maps and visualizations I test interacting with them on my computer, tablet, and phone. I have found that some data visualizations behave differently on different devices.
The Maryland Health Department published updated numbers today, so I decided to see how long it would take me to update the map. Because I set up my spreadsheet properly it did not take very long. I just popped in the new case information and then exported it to the map. I used the NCES School Directory. Two schools were not in the directory, Blue Heron Elementary, which I added to the database, and the Success Program, which I did not add.
Since this map only shows schools with active cases, many of the schools with “decreasing” cases are not shown on the map. The Maryland Health Department list includes private schools. This map only shows public schools because I have a spreadsheet with public school addresses already set up. Private schools could be added if I spent the time to look up each address. I have not fully checked the map yet as I am just experimenting with the capabilities and my database skills.
As a note, some school systems’ first day of school is September 8, 2021.
After my last map that shows public schools that have ever had an active outbreak, I got curious about what it would look like to just show schools with current active cases with trend information. Please see the notes for the data in the previous posts.
My kids return to school in person tomorrow so I have been thinking about public school-associated outbreaks all day and different ways to graph the data available.
This map shows schools that have had a school-associated outbreak on 25 August 2021 or 1 September 2021. The circle shows the max size of the outbreak. I first tried sizing by the 1 September 2021 outbreak size, but that eliminated the schools that had an outbreak on 25 August but had zero cases on 1 September. The color shows if the cases at the particular school are increasing, staying the same, or decreasing. The tooltips show the number of cases on each day and the “type” of school based on the NCES School Directory. The two cases at Success Program on 1 September in Frederick County is not recorded because it does not have an address in the NCES School Directory. I will have to decide whether to add the Success Program or to just footnote it.
I also have to decide if I want to add private schools in the future. I would need to look up the address for each private school.
After I made my post about the percentage of schools with school outbreak-associated cases I was curious about the percentage of students with school outbreak-associated cases. I got the 2021 student enrollment data from the Maryland State Department of Education’s report card. I then divided the county enrollment by the number of outbreak-associated cases in public schools as published by the Maryland Health Department on September 1, 2021. I had previously coded each of the schools from the September 1, 2021 data release as public or private. Then I made a map using Datawrapper.
As a note, many schools systems have not opened as of September 1, 2021, and reporting to the Maryland Health Department may be delayed.
As a parent, it is good to see the number of cases in perspective. Although I know that every person’s risk tolerance is different.
According to the previous map I made, 16% of Frederick County Public Schools have a school outbreak-associated case. That seems like a lot, at least to me. However, when I look at this map, I see that less than one-tenth of a percent of Frederick County public school students, 0.07%, have a school-associated outbreak case. That seems less alarming. As to which portrayal is better, at this point I do not know. I guess I will have to wait and see.
What is also interesting about this map is that it is normalized. Both St. Mary’s County Public Schools and Prince George’s County Public School have 6 school outbreak-associated cases. For St. Mary’s County Public Schools it is 0.03% of the student body. For Prince George’s County Public Schools it is 0.00% of the student body, due to rounding because the student body of Prince George’s County is much larger than that of St. Mary’s County.
UPDATE: The Maryland Health Department numbers include teachers and staff. The denominator in the map below just includes students. I will have to see if I can fix these numbers and create an updated map. This is why checking your data is important.
Notes about the Data
These notes are copied from the Maryland Department of Health website.
Note: This dataset reflects public and non-public K-12 schools in Maryland that have COVID-19 outbreaks. Data are based on local health department reports to MDH, which may be revised if additional information becomes available. This list does not include child care facilities or institutes of higher education. Schools listed meet 1 or more of the following criteria:
Classroom/cohort outbreak definition: 1) At least two confirmed COVID-19 cases among students/teachers/staff within a 14-day period and who are epidemiologically linked, but not household contacts; or
School-wide outbreak definition:
2) Three or more classrooms or cohorts with cases from separate households that meet the classroom/cohort outbreak definition that occurs within 14 days; or 3) Five percent or more unrelated students/teachers/staff have confirmed COVID-19 within a 14 day period (minimum of 10 unrelated students/teachers/staff).
Cases reported reflect the current total number of cases. Schools are removed from the list when health officials determine 14 days have passed with no new cases and no tests pending. Archival data is available through the COVID-19 open data catalogue. These data are updated weekly on Wednesdays during the 10 a.m. hour. MDH is continuously evaluating its data and reporting systems and will make updates as more data becomes available.
I pulled data on September 1, 2021, to make the above map. I provided the information on whether a school is public or private. All errors are my own. This map is not official, it is primarily for the purpose of me exploring the visualization features and keeping track of what I learned.
This is a test of taking HTML code from Amcharts LIVE and embedding it into a post. If this works it might make making some types of maps and charts quicker. Although I like the flexibility of building charts and maps from scratch. I am just exploring all of the ways I can do data visualization so I can choose the best tool for the task at hand.
I made the map in amcharts Live and then I download the HTML code. I uploaded the code into my WordPress media file. Then I referenced the media file in a frame on this post.
I am not sure which treemap style I like the best. I think it will depend on what I want the treemap to show. It might depend on the story I want to tell with the data.
I have found it is a little difficult to read the smaller categories of the treemaps, which might make them less useful. I expanded the height from 300 px to 500 px, but I am thinking of expanding them further to 700 px or 800 px. I also find the smaller categories sort of difficult to click on.
In my previous post, I built my first treemap using Amcharts. Today I built another treemap, this one is 3 levels deep. I am unsure about the presentation of the data in this manner, it may not actually be very useful. However, since I was able to successfully explore building a multi-level treemap using the Amcharts demo I will call it a success.
In this example, I was able to get the level 1 labels to appear, which I was not able to figure out yesterday.
Today I am testing out a treemap that I made in Amcharts. I made a treemap of the students that transfer into the University System of Maryland in 2020. The top layer is the education sector, the second layer is the institution. I am still having a bit of trouble getting it to behave as I would like. I would like the second layer names to appear in the boxes, but I can not seem to get it to work as it does in CodePen. Again I got it to work in CodePen using an Amcharts demo as a model, but again I ran into an internal 500 error when I tried to transfer the code over. So I rewrote the code keeping out the pieces that were not rendering properly.
The treemap clearly shows that there are a large number of transfer students from the US Armed Forces, in part because of the University of Maryland Global Campus. I may make another treemap that excludes transfer students from the University of Maryland Global Campus.
I figured out how to show the size of the institutions before drill down, but not the institution names. There is likely a simple way to show the labels on a treemap in Amcharts, but I have not yet figured out how. I think that I like the first style better, but I will need to test both versions.
I realized while I was digging into the data further that I missed the 16,362 students that transferred from “other” out-of-state institutions and 5 students that transferred from “other” MICUA/MD private institutions. I missed them because the institution details is only provided for the top 15 institutions in each of the drill-down categories.
I have not yet figured out how to make a map with a timeline, so here is a map showing the outbreak-associated cases in schools as reported by the Maryland Department of Health on September 1, 2021. Please refer to my first outbreak map for notes on the data. As with the other map the goal is for me to learn about the mapping software and data visualization using current data. The data and locations have not been checked.
We use cookies to personalize content and ads, to provide social media features and to analyze our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information that you have provided to them or that they have collected from your use of their services. You consent to our cookies if you continue to use our website.
We use cookies to personalize content and ads, to provide social media features and to analyze our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information that you have provided to them or that they have collected from your use of their services. You consent to our cookies if you continue to use our website.
Necessary cookies help make a website usable by enabling basic functions like page navigation and access to secure areas of the website. The website cannot function properly without these cookies.
Preference cookies enable a website to remember information that changes the way the website behaves or looks, like your preferred language or the region that you are in.
Statistic cookies help website owners to understand how visitors interact with websites by collecting and reporting information anonymously.
Marketing cookies are used to track visitors across websites. The intention is to display ads that are relevant and engaging for the individual user and thereby more valuable for publishers and third-party advertisers.
Unclassified cookies are cookies that we are in the process of classifying, together with the providers of individual cookies.
