# WHO COVID-19 Minimum Reporting Form **URL:** \ **Category:** Showcase\ **Tags:** covid-19, health, form-design\ **Created:** [March 24, 2020, 3:23pm UTC](https://forum.getodk.org/t/who-covid-19-minimum-reporting-form/25647 "2020-03-24T15:23:04Z")\ **Posts on this page:** 17\ **Page:** 1
**Author:** ![yanokwa](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/yanokwa/32/1695_2.png) [@yanokwa](https://forum.getodk.org/u/yanokwa)\ **Post date:** [March 24, 2020, 3:23pm UTC](https://forum.getodk.org/t/who-covid-19-minimum-reporting-form/25647/1 "2020-03-24T15:23:05Z")
The World Health Organization (WHO) has provided a protocol for investigating the [first few cases and contact investigation for COVID-19](https://www.who.int/publications-detail/the-first-few-x-(ffx)-cases-and-contact-investigation-protocol-for-2019-novel-coronavirus-(2019-ncov)-infection). By using a standardized protocol, WHO says: > epidemiological exposure data and biological samples can be systematically collected and shared rapidly in a format that can be easily aggregated, tabulated and analyzed across many different settings globally for timely estimates of 2019-nCoV infection severity and transmissibility, as well as to inform public health responses and policy decisions. @LN and I have made the minimum reporting form into a downloadable [WHO COVID-19 A0 XLSForm](https://docs.google.com/spreadsheets/d/1AU1Da7866TxHp9DKNFZNFzwC36-2plUCwuqMyH9BHJc/edit) that anyone can use and leave feedback on. This form should be a good model for a number of other applications. When converting a paper form into an ODK form, there are always many decisions to make about how it should look and feel. Here are some that we made in this case: - Questions are grouped on screens to minimize vertical scrolling and help the data collector focus on what is related and important - Screen breaks are designed to be comfortable on 5-inch 1920x1080 screen (e.g. Pixel 2) or 8-inch 1024x768 screen (e.g. Galaxy Tab A) - Every yes/no/unknown question is horizontal so more questions fit on a screen. They are represented consistently so that data collectors can respond from muscle memory - Select questions are always required - Logic is used to hide questions that aren’t relevant **It’s important to test a form definition and make sure it is appropriate for any new context it is used in**. We have added several comments labeled “Review and customize” in the form definition to highlight changes that you should consider. We will update the form as we get feedback from users. Watch this topic ([learn how here](https://forum.getodk.org/t/how-to-receive-notifications-about-a-category-or-topic/9066)) for updates or check the changelog sheet in the Google Sheet. If you need help using or deploying this form, @LN, myself, and the rest of team at Nafundi can help for free. Fill out the form at [https://forms.gle/xMJZPAzKQwgeMzE17](https://forms.gle/xMJZPAzKQwgeMzE17). ---
**Author:** ![Xiphware](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/xiphware/32/2587_2.png) [@Xiphware](https://forum.getodk.org/u/Xiphware)\ **Post date:** [March 24, 2020, 8:07pm UTC](https://forum.getodk.org/t/who-covid-19-minimum-reporting-form/25647/2 "2020-03-24T20:07:14Z")
Looks great. Very intuitive. Some quick observations: - ${symtom\_existence} should probably be required (oversight?) - any reason not to make ${symtom\_existence} and ${onset\_known} also columns-pack appearance, to match the rest of yes/no type questions in the form? - in some cases, with dates, there's a "Is x Date known?" followed by dependent mandatory date question, in other cases a dependent show/hide date its not mandatory, ... Might want to go thru all these dates carefully and confirm the required logic - I could see _region_(s) visited being mandatory but potentially travel may not involve specific _cities_ per se (ie make city questions non-mandatory?). - You could probably add "`. < today()`" constraint on almost all date questions ---
**Author:** ![LN](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/ln/32/1605_2.png) [@LN](https://forum.getodk.org/u/LN)\ **Post date:** [March 25, 2020, 4:23am UTC](https://forum.getodk.org/t/who-covid-19-minimum-reporting-form/25647/3 "2020-03-25T04:23:40Z")
Thanks so much for the thorough review, @Xiphware! > [@Xiphware](#): > > ${symtom\_existence} should probably be required (oversight?) Absolutely, thank you! I did a check where I filtered all select columns and checked their required status but this must have slipped. > [@Xiphware](#): > > any reason not to make ${symtom\_existence} and ${onset\_known} also columns-pack This is largely a matter of preference. In general, I think vertical choices are easier to scan and so I tend to favor them unless the same options are repeated over and over again. That said, what really pushed me in that direction is that there's a visual bug with the `columns-pack` appearance in Collect that makes the alignment look strange in that case: [https://github.com/opendatakit/collect/issues/3744](https://github.com/opendatakit/collect/issues/3744). > [@Xiphware](#): > > in some cases, with dates, there's a "Is x Date known?" followed by dependent mandatory date question, in other cases a dependent show/hide date its not mandatory I followed the source form on that one. Some dates have an unknown options while others don't. Certainly that's something folks deploying this form should consider based on the analysis they plan to do. > [@Xiphware](#): > > I could see _region_ (s) visited being mandatory but potentially travel may not involve specific _cities_ per se (ie make city questions non-mandatory?). That's fair. > [@Xiphware](#): > > You could probably add " `. < today()` " constraint on almost all date questions Done. I used the enumerator-confirmed date of form completion in case the device time is off or the form contents are digitized after the form filling date. ---
**Author:** ![LN](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/ln/32/1605_2.png) [@LN](https://forum.getodk.org/u/LN)\ **Post date:** [March 28, 2020, 10:02pm UTC](https://forum.getodk.org/t/who-covid-19-minimum-reporting-form/25647/5 "2020-03-28T22:02:04Z")
@mathieubossaert got in touch with me about contributing French translations and we just added them. Thanks so much, @mathieubossaert! 🎉 While I am a native speaker, have reviewed them carefully, and think they are excellent, **the French translations have not yet been reviewed by a health professional**. If you are a French-speaking health professional, we would deeply appreciate your review. In particular, neither of us is sure how to translate "baseline serum." I see a lot of activity in the form document. If you are using this form in whole, part, or even just as inspiration, we'd really appreciate hearing about it and learning what additional support we can offer. Are there other COVID-19 forms (e.g. from WHO, CDC, etc) that would be helpful to have ODK versions of? ---
**Author:** ![LN](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/ln/32/1605_2.png) [@LN](https://forum.getodk.org/u/LN)\ **Post date:** [March 30, 2020, 3:45am UTC](https://forum.getodk.org/t/who-covid-19-minimum-reporting-form/25647/6 "2020-03-30T03:45:03Z")
2 posts were split to a new topic: [Problem loading WHO COVID-19 form from Google Drive](https://forum.getodk.org/t/problem-loading-who-covid-19-form-from-google-drive/25755) ---
**Author:** ![KAMPEMPE](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/kampempe/32/10390_2.png) [@KAMPEMPE](https://forum.getodk.org/u/KAMPEMPE)\ **Post date:** [March 31, 2020, 8:32am UTC](https://forum.getodk.org/t/who-covid-19-minimum-reporting-form/25647/7 "2020-03-31T08:32:39Z")
merci pour le model mais pour les analyses journalière je cherche le statistique covid 19 jour pour jour ou puis je trouver une base de donnée comme ca. ---
**Author:** ![paul\_macharia](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/paul_macharia/32/8094_2.png) [@paul\_macharia](https://forum.getodk.org/u/paul_macharia)\ **Post date:** [March 31, 2020, 12:28pm UTC](https://forum.getodk.org/t/who-covid-19-minimum-reporting-form/25647/8 "2020-03-31T12:28:14Z")
Good work @LN @yanokwa @Xiphware This will definitely positively impact lives, I will try to work on the Swahili version of the tool from the latest xls file ---
**Author:** ![LN](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/ln/32/1605_2.png) [@LN](https://forum.getodk.org/u/LN)\ **Post date:** [March 31, 2020, 3:30pm UTC](https://forum.getodk.org/t/who-covid-19-minimum-reporting-form/25647/9 "2020-03-31T15:30:41Z")
> [@KAMPEMPE](#): > > pour les analyses journalière je cherche le statistique covid 19 jour pour jour ou puis je trouver une base de donnée comme ca Est-ce que vous cherchez des données déjà collectées? Ce que nous vous proposons ici sont les formulaires pour faire la collecte de données. L'OMS publie chaque jours un [rapport avec les statistiques mondiales](https://www.who.int/emergencies/diseases/novel-coronavirus-2019/situation-reports) et beaucoup de pays font la même chose pour leurs régions. John Hopkins essaye de tout mettre ensemble et publie le tout [en format facile a analyser](https://github.com/CSSEGISandData/COVID-19/tree/master/csse_covid_19_data/csse_covid_19_daily_reports). Entre autre, ces données sont utilisées pour la carte à jours de tous les cas: > **[COVID-19 Map - Johns Hopkins Coronavirus Resource Center](https://coronavirus.jhu.edu/map.html)** > > Coronavirus COVID-19 Global Cases by the Center for Systems Science and Engineering (CSSE) at Johns Hopkins University (JHU) > [@paul\_macharia](#): > > I will try to work on the Swahili version of the tool from the latest xls file That sounds great, @paul_macharia. How about making a copy, adding the translation columns and sharing with me when it's ready? I can then copy the translations into the master document. If you have insights into how this form could be or does get used in East Africa, please share. ---
**Author:** ![paul\_macharia](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/paul_macharia/32/8094_2.png) [@paul\_macharia](https://forum.getodk.org/u/paul_macharia)\ **Post date:** [March 31, 2020, 3:31pm UTC](https://forum.getodk.org/t/who-covid-19-minimum-reporting-form/25647/10 "2020-03-31T15:31:31Z")
Just finished, This could be merged with the existing xls file [WHO COVID-19 Form A0\_ Minimum data reporting form\_Swa.xlsx](https://forum.getodk.org/uploads/short-url/u37wscUUtCx5nl1m7Zo71ItHCFQ.xlsx) (39.7 KB) ---
**Author:** ![paul\_macharia](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/paul_macharia/32/8094_2.png) [@paul\_macharia](https://forum.getodk.org/u/paul_macharia)\ **Post date:** [March 31, 2020, 3:34pm UTC](https://forum.getodk.org/t/who-covid-19-minimum-reporting-form/25647/11 "2020-03-31T15:34:24Z")
@LN A large part of East, Central and Southern Africa uses Swahili. At this stage, it's just preparing anything and everything that may be needed depending on how the pandemic turns out in this part of the world. ---
**Author:** ![LN](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/ln/32/1605_2.png) [@LN](https://forum.getodk.org/u/LN)\ **Post date:** [March 31, 2020, 5:30pm UTC](https://forum.getodk.org/t/who-covid-19-minimum-reporting-form/25647/12 "2020-03-31T17:30:30Z")
Thank you so much, @paul_macharia, your translations are now in the master document. The WHO has also published a Spanish translation of the form which I have also added. @Daniel_Alvarado this may be of interest to you. ---
**Author:** ![aurdipas](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/aurdipas/32/1785_2.png) [@aurdipas](https://forum.getodk.org/u/aurdipas)\ **Post date:** [March 25, 2020, 8:32am UTC](https://forum.getodk.org/t/who-covid-19-minimum-reporting-form/25647/13 "2020-03-25T08:32:40Z")
> **[COVID-19-resources-for-contact-tracing-2-March-2020.pdf](https://www.ecdc.europa.eu/sites/default/files/documents/COVID-19-resources-for-contact-tracing-2-March-2020.pdf)** > > 0 B ---
**Author:** ![LN](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/ln/32/1605_2.png) [@LN](https://forum.getodk.org/u/LN)\ **Post date:** [April 15, 2020, 8:38pm UTC](https://forum.getodk.org/t/who-covid-19-minimum-reporting-form/25647/14 "2020-04-15T20:38:12Z")
2 posts were split to a new topic: [Contact tracing for COVID-19](https://forum.getodk.org/t/contact-tracing-for-covid-19/26048) ---
**Author:** ![Daniel\_SalazarR](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/daniel_salazarr/32/2048_2.png) [@Daniel\_SalazarR](https://forum.getodk.org/u/Daniel_SalazarR)\ **Post date:** [April 30, 2020, 3:40pm UTC](https://forum.getodk.org/t/who-covid-19-minimum-reporting-form/25647/15 "2020-04-30T15:40:33Z")
We tested this questionnaire on our GIC Collect app on the iPhone and it works with some small changes. - We do not manage the variables or formulas in the form data/@version. - We do not manage the last-saved type variables. - In the date of birth and respondent date of birth questions on the iPhone it would be better to use the no-calendar appearance to make it easy to select the year. - We do not yet manage the columns-pack appearance. ---
**Author:** ![fhas33](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/fhas33/32/12478_2.png) [@fhas33](https://forum.getodk.org/u/fhas33)\ **Post date:** [August 3, 2020, 10:08pm UTC](https://forum.getodk.org/t/who-covid-19-minimum-reporting-form/25647/16 "2020-08-03T22:08:48Z")
Hello everyone, first I should tell you that the work is very helpful! Also, I can comment that I have been able to download the file and consult it directly from the XLSX format but I am interested to know is there a way to open this form in [build.getodk.org](http://build.getodk.org) to see its programming? My problem is that [build.getodk.org](http://build.getodk.org) only load .odkbuild format. ![image](https://getodk.b-cdn.net/uploads/default/original/2X/4/4001827e652933ec5ed67c9a1b8ed7bb09a55b9a.png) Thanks for the help ---
**Author:** ![Grzesiek2010](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/grzesiek2010/32/2881_2.png) [@Grzesiek2010](https://forum.getodk.org/u/Grzesiek2010)\ **Post date:** [August 3, 2020, 10:18pm UTC](https://forum.getodk.org/t/who-covid-19-minimum-reporting-form/25647/17 "2020-08-03T22:18:01Z")
> [@fhas33](#): > > is there a way to open this form in [build.getodk.org](http://build.getodk.org) no, the form wasn't even created using ODK Build so there is no .odkbuild file you could load. > [@fhas33](#): > > to see its programming? you can open the xls file and investigate how the form is structured. ---
**Author:** ![Grzesiek2010](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/grzesiek2010/32/2881_2.png) [@Grzesiek2010](https://forum.getodk.org/u/Grzesiek2010)\ **Post date:** [December 16, 2020, 1:00pm UTC](https://forum.getodk.org/t/who-covid-19-minimum-reporting-form/25647/18 "2020-12-16T13:00:22Z")
A post was split to a new topic: [Creating ODK form](https://forum.getodk.org/t/creating-odk-form/31681)