Data models¶
How should you design your data model? Which level of details do you plan?
Data model¶
Record name |
---|
Total world statistics |
Cases by country |
Cases by country by day |
Data for all countries |
Mask usage instructions |
Infection histories by country |
India-specific figures |
North American figures |
Data by ISO code |
Testing statistics |
Transportation infection data |
Multilingual applications¶
Twenty percent of the population understand English, sharing a dashboard in English describing an outbreak is of little help for the vast majority of the popuplation.
Note
Build a multilanguage application from day 1.
[WikiLangSpok20] indicates an approximate list of languages by the total number of speakers.
Rank | Language | Speakers (millions) |
---|---|---|
1 | English | 1.268 |
2 | Mandarin Chinese | 1.120 |
3 | Hindi | 637.2 |
4 | Spanish | 537.9 |
5 | French | 276.6 |
6 | Standard Arabic | 274.0 |
7 | Bengali | 265.2 |
8 | Russian | 258.0 |
9 | Portuguese | 252.2 |
10 | Indonesian | 199.0 |
11 | Urdu | 170.6 |
12 | German | 131.6 |
13 | Japanese | 126.4 |
14 | Swahili | 98.5 |
15 | Marathi | 95.3 |
List of locations¶
List of locations consist of several information; e.g., country name, state, county, province, commune, longitude, latitude, post box
- Bing lists countries and states names in a text file; US States are separated by a slash ‘/’
- https://github.com/microsoft/COVID-19-Widget/blob/master/AllLocations.txt