Vaccination Focused Redesign

[reustle]

As we move closer to the vaccination phase here in Japan, I think it's time to have a discussion about how we could redesign the site to focus on this new vaccination information as it becomes available, and not after the fact.

The current iteration of the site is wonderful, but I don’t think it is useful to focus solely on such granular data anymore. By putting high level trends and a few key metrics at the top center of the homepage, we can utilize the rest of the space to focus on the next most important step of the pandemic, getting vaccinated.

Judging by the rollout in the US and in other countries, it seems we should be focusing on the following info. (Inspired by @patio11 's recent https://VaccinateCA.com work)

• Vaccination station locations on a map with a simple “near me” search box
• Eligibility information (i.e., who can get it? front line workers only? elderly only? etc)
• Cost information (will it be free? only with JP health insurance?)
• Appointment scheduling information

In addition to that information on the site, we could also offer a simple newsletter sign up where we send out a weekly update on the vaccine rollout, new testing locations, and regulations around getting it.

Overall, the quick summary of the new site would look like this:

• Title and language picker drop down
• High level spread trend for Japan, Tokyo, Osaka, and maybe one or two others, followed by a link to “further details” which is essentially the current homepage moved to /tracker (or removed?). Inspired by some of @liquidx 's recent experiments.
• Vaccination information listed above
• Helpful links
• The contributor list as it is currently

I’ve put together this high level mockup to help visualize what I have in mind below. I've also got access to development team members to make this happen fairly quickly and cleanly, if we are all in agreement.

Thank you so much for all of your contributions and support over the past year, everyone. I'm sure our 1,436,000 unique visitors appreciate your work too.

(cc @liquidx @Kay-Cube @l15n @mertd )

Related links:

• thread on this topic https://twitter.com/colecameron/status/1391940932191145987
• possible initial data source https://github.com/owid/covid-19-data/blob/master/public/data/vaccinations/country_data/Japan.csv
• gov site https://japan.kantei.go.jp/ongoingtopics/vaccine.html

[mertd]

Thanks for the mention! I like the idea of adding (or moving the focus to) vaccination information.

As far as I know, residents will receive a "vaccination ticket" via mail from their city office. Depending on whether this already includes an assignment of when and where to get the shot, a map of vaccination centers would be more or less useful.

If the data on which vaccination wave we're in (elderly only etc.) is publicly available, it will be very useful info to display. I assume this will depend on how centralized the rollout will be. I would prefer moving instead of removing the current numbers though, as new mutations might prolong the battle and information on both vaccination and spread might be valuable for some more time to come.

[Kay-Cube]

Some visualization ideas

1. simplification of the status. I think we can make the graph the main part of a KPI widget. And some explanations arounds the graph.

   

2. vaccination location map

   

3. regional status section: just redesigned the look

   

[lub-bee]

From what I've heard : There are going to be different phases of vaccinations:

• over 65 years old
  • over 50 years old
  • etc

With priority cases according to certain pathologies:

• respiratory disease
• heart disease
• blood disease
• kidney disease
• liver disease
• neurological disease
• neuromuscular disease
• pediatric disease
• diabetes
• Immunosuppressive conditions.

• However, this may not be general, some cities and regions may opt for a different priority system...

We will normally receive by mail a contact number for a call-center in order to make a reservation. People may be able to choose between different types of vaccine - we are talking about 3 different types for now - each hospital (or temporary vaccination center) may have some, but not necessarily all types of vaccine (e.g. in the countryside). Therefore, people will theoretically have the choice between different vaccination centers, depending on the availability of these centers, and the type of vaccin they are looking for.

I'm not sure what these informations could change in terms of interface, however, keeping a map up to date on what type of treatment is available at which location seems quite complicated. The same goes for the vaccination phases. This is unlikely, but there is a possibility that all cities will have a different schedule, which drastically complicates the display possibilities.

I have access to some informations (some I can't divulge for contractual reason), but some others that can probably be useful here. I will try to follow this discussion.

[ronkorving]

I think it could be great to visualize how many people have been vaccinated so far.

This may provide some inspiration:

https://ig.ft.com/coronavirus-vaccine-tracker/ https://www.mhlw.go.jp/stf/seisakunitsuite/bunya/vaccine_sesshujisseki.html

[ann-kilzer]

Here's an excellent visualization from the NYT:

https://www.nytimes.com/interactive/2020/us/covid-19-vaccine-doses.html

[stalkerg]

probably any design will be good now because we have already some interesting data https://github.com/owid/covid-19-data/blob/master/public/data/vaccinations/country_data/Japan.csv

[stalkerg]

Ok, some data we have here https://www.kantei.go.jp/jp/headline/kansensho/vaccine.html now

[ronkorving]

Aggregated data here, by @Leko: https://github.com/Leko/data-jp-covid19-vaccination

[Leko]

The main purpose of my repository (https://github.com/Leko/data-jp-covid19-vaccination) is to make the Excel files available on the Prime Minister's Office website machine-readable. There're two things that my repository seems to have over OWID's one is that it contains the latest vaccination data by prefecture. Another one is JSON format is available.

[MargauxBarbier]

Hi, I tried to gather a few links I could find lately. I can help with translation / further digging!

Vaccine Stations // コロナワクチンナビ https://v-sys.mhlw.go.jp/ Format: Research Engine per prefecture Update rate: Not clear, every time there is a new vaccine station? Infos: Station’s address, Map, Type of vaccine given, Website, Phone Number, Business hours, Last update date

Number of people vaccinated per day (before 9th of April) https://github.com/owid/covid-19-data/blob/master/public/data/vaccinations/country_data/Japan.csv Format: Github Update rate: Every 2-3 days Infos: URL for source, date, total inoculation, n°1 inoculation, n°2 inoculation, vaccine type, number of locations doing vaccine

Eligibility Schedule // ワクチンの接種スケジュール https://www.kantei.go.jp/jp/headline/kansensho/vaccine_supply.html Format: Text Update rate: based on the government announcements I guess Infos: start date, category, source, priority category

Number of people vaccinated per category // 日別の実績（医療従事者等 (medical staff) / 高齢者等(elderly)) https://www.kantei.go.jp/jp/headline/kansensho/vaccine.html Format : Excel / PDF Update rate: Every week days Infos: date, n°1 inoculation, n°2 inoculation, total vaccinations

Number of people vaccinated per day per prefecture // 都道府県別の実績 https://www.kantei.go.jp/jp/headline/kansensho/vaccine.html Format : Excel / PDF Update rate: Every few days (the last update is the 7th of May) Infos: n°1 inoculation, n°2 inoculation, total

[Leko]

These are in my repository.

Number of people vaccinated per category // 日別の実績（医療従事者等 (medical staff) / 高齢者等(elderly))

• medical staff: data/nationwide/medical_workers/latest.csv
• elderly: data/nationwide/senior_citizen/latest.csv

Number of people vaccinated per day per prefecture // 都道府県別の実績

• medical staff: data/prefecture/medical_workers/latest.csv
• elderly: data/prefecture/senior_citizen/latest.csv

And this is a dashboard for visualizing vaccination progress by using the data in my repository. It uses Google Data Studio to create the dashboard. Although it isn't so beautiful and written in Japanese, it can be an example of a vaccination dashboard. Just FYI https://datastudio.google.com/reporting/b0ef3dff-f6d8-454c-98ff-a3fbdd1aef0f

[ronkorving]

@Leko I love it, thanks for building and sharing that!

[shuuji3]

In addition to the ones MargauxBarbier shared, there are two data sources we could use:

1. three APIs on the government website

API	Format	Sample
Numbers of vaccination by prefecture, gender, and age range (都道府県別接種回数詳細)	NDJSON	{"date":"2021-04-12","prefecture":"01","gender":"F","age":"-64", "medical_worker":false,"status":1,"count":10} {"date":"2021-04-12","prefecture":"01","gender":"F","age":"65-", "medical_worker":false,"status":1,"count":85} {"date":"2021-04-12","prefecture":"01","gender":"M","age":"-64", "medical_worker":false,"status":1,"count":8} {"date":"2021-04-12","prefecture":"01","gender":"M","age":"65-", "medical_worker":false,"status":1,"count":22}
Today's summary of vaccination by date (接種日別接種回数サマリー)	CSV	date,count_first_or_mid_general,count_second_or_full_general 2021-04-12,4812,0 2021-04-13,4286,0 2021-04-14,5151,0 2021-04-15,9347,0
Today's summary of vaccination by prefecture (都道府県別累積接種回数サマリー)	CSV	date,prefecture_code,prefecture_name, count_first_or_mid_general,count_second_or_full_general 2021-08-09,01,北海道,1949396,1463215 2021-08-09,02,青森県,531492,417022 2021-08-09,03,岩手県,472157,345642

• Unfortunately, these APIs provide no data about medical staff.
• This is the same data source that is used on https://www.kantei.go.jp/jp/headline/kansensho/vaccine.html
• Seems not to contains the dataset of the MLHW (before 2021-04-12)
• Summary CSV only provides data except for today and it uses the old Shift_JIS encoding.

2. COVID-19/data_tables/vaccine_data/global_data at master · govex/COVID-19

• Data source repository by Johns Hopkins University.
• Updated daily.
• Well formatted and preserving the past data.
• Seems to combine the dataset of the MLHW and the Government.

Sample:

> head -1 time_series_covid19_vaccine_global.csv; grep 'Japan,' time_series_covid19_vaccine_global.csv | grep 2021-08

Country_Region,Date,Doses_admin,People_partially_vaccinated,People_fully_vaccinated,Report_Date_String,UID,Province_State
Japan,2021-08-01,87381662,50356795,37024867,2021/08/02,392,
Japan,2021-08-02,89111989,51167720,37944269,2021/08/03,392,
Japan,2021-08-03,96854171,51966521,38801896,2021/08/04,392,
Japan,2021-08-04,96854171,52724777,39610318,2021/08/05,392,
Japan,2021-08-05,99651092,58095553,41555539,2021/08/06,392,
Japan,2021-08-06,99651092,58095553,41555539,2021/08/07,392,
Japan,2021-08-07,99651092,58095553,41555539,2021/08/08,392,
Japan,2021-08-08,99651092,58095553,41555539,2021/08/09,392,