johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
15,842 rows where country_or_region = "Netherlands" sorted by last_update
This data as json, yaml, Notebook, copyable, CSV (advanced)
day (date) >30 ✖
- 2020-07-17 17
- 2020-07-18 17
- 2020-07-19 17
- 2020-07-20 17
- 2020-07-21 17
- 2020-07-22 17
- 2020-07-23 17
- 2020-07-24 17
- 2020-07-25 17
- 2020-07-26 17
- 2020-07-27 17
- 2020-07-28 17
- 2020-07-29 17
- 2020-07-30 17
- 2020-07-31 17
- 2020-08-01 17
- 2020-08-02 17
- 2020-08-03 17
- 2020-08-04 17
- 2020-08-05 17
- 2020-08-06 17
- 2020-08-07 17
- 2020-08-08 17
- 2020-08-09 17
- 2020-08-10 17
- 2020-08-11 17
- 2020-08-12 17
- 2020-08-13 17
- 2020-08-14 17
- 2020-08-15 17
- …
province_or_state 17
- Curacao 999
- Sint Maarten 999
- Aruba 998
- Bonaire, Sint Eustatius and Saba 995
- Drenthe 896
- Flevoland 896
- Friesland 896
- Gelderland 896
- Groningen 896
- Limburg 896
- Noord-Brabant 896
- Noord-Holland 896
- Overijssel 896
- Unknown 896
- Utrecht 896
- Zeeland 896
- Zuid-Holland 896
country_or_region 1
- Netherlands · 15,742 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update ▼ | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2578105 | 2578105 | 2020-04-12 | Netherlands | Bonaire, Sint Eustatius and Saba | 3 | 0 | 0 | 3 | 12.1784 | -68.2385 | 2020-04-12 23:17:00 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
2578111 | 2578111 | 2020-04-12 | Netherlands | Curacao | 14 | 1 | 8 | 5 | 12.1696 | -68.99 | 2020-04-12 23:17:00 | Curacao, Netherlands | ||
2578174 | 2578174 | 2020-04-12 | Netherlands | Sint Maarten | 50 | 9 | 5 | 36 | 18.0425 | -63.0548 | 2020-04-12 23:17:00 | Sint Maarten, Netherlands | ||
2578304 | 2578304 | 2020-04-12 | Netherlands | 25587 | 2737 | 250 | 22600 | 52.1326 | 5.2913 | 2020-04-12 23:17:00 | Netherlands | |||
43075 | 43075 | 2020-04-13 | Netherlands | Aruba | 92 | 0 | 32 | 60 | 12.5211 | -69.9683 | 2020-04-13 23:07:34 | Aruba, Netherlands | ||
43079 | 43079 | 2020-04-13 | Netherlands | Bonaire, Sint Eustatius and Saba | 3 | 0 | 0 | 3 | 12.1784 | -68.2385 | 2020-04-13 23:07:34 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
43085 | 43085 | 2020-04-13 | Netherlands | Curacao | 14 | 1 | 8 | 5 | 12.1696 | -68.99 | 2020-04-13 23:07:34 | Curacao, Netherlands | ||
43148 | 43148 | 2020-04-13 | Netherlands | Sint Maarten | 50 | 9 | 5 | 36 | 18.0425 | -63.0548 | 2020-04-13 23:07:34 | Sint Maarten, Netherlands | ||
43278 | 43278 | 2020-04-13 | Netherlands | 26551 | 2823 | 250 | 23478 | 52.1326 | 5.2913 | 2020-04-13 23:07:34 | Netherlands | |||
3337978 | 3337978 | 2020-04-14 | Netherlands | Aruba | 92 | 0 | 32 | 60 | 12.5211 | -69.9683 | 2020-04-14 23:33:12 | Aruba, Netherlands | ||
3337982 | 3337982 | 2020-04-14 | Netherlands | Bonaire, Sint Eustatius and Saba | 3 | 0 | 0 | 3 | 12.1784 | -68.2385 | 2020-04-14 23:33:12 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
3337988 | 3337988 | 2020-04-14 | Netherlands | Curacao | 14 | 1 | 10 | 3 | 12.1696 | -68.99 | 2020-04-14 23:33:12 | Curacao, Netherlands | ||
3338051 | 3338051 | 2020-04-14 | Netherlands | Sint Maarten | 52 | 9 | 5 | 38 | 18.0425 | -63.0548 | 2020-04-14 23:33:12 | Sint Maarten, Netherlands | ||
3338181 | 3338181 | 2020-04-14 | Netherlands | 27419 | 2945 | 250 | 24224 | 52.1326 | 5.2913 | 2020-04-14 23:33:12 | Netherlands | |||
860062 | 860062 | 2020-04-15 | Netherlands | Aruba | 93 | 1 | 39 | 53 | 12.5211 | -69.9683 | 2020-04-15 22:56:32 | Aruba, Netherlands | ||
860066 | 860066 | 2020-04-15 | Netherlands | Bonaire, Sint Eustatius and Saba | 3 | 0 | 0 | 3 | 12.1784 | -68.2385 | 2020-04-15 22:56:32 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
860072 | 860072 | 2020-04-15 | Netherlands | Curacao | 14 | 1 | 10 | 3 | 12.1696 | -68.99 | 2020-04-15 22:56:32 | Curacao, Netherlands | ||
860135 | 860135 | 2020-04-15 | Netherlands | Sint Maarten | 53 | 9 | 5 | 39 | 18.0425 | -63.0548 | 2020-04-15 22:56:32 | Sint Maarten, Netherlands | ||
860265 | 860265 | 2020-04-15 | Netherlands | 28153 | 3134 | 250 | 24769 | 52.1326 | 5.2913 | 2020-04-15 22:56:32 | Netherlands | |||
934168 | 934168 | 2020-04-16 | Netherlands | Aruba | 95 | 2 | 39 | 54 | 12.5211 | -69.9683 | 2020-04-16 23:30:31 | Aruba, Netherlands | ||
934172 | 934172 | 2020-04-16 | Netherlands | Bonaire, Sint Eustatius and Saba | 3 | 0 | 0 | 3 | 12.1784 | -68.2385 | 2020-04-16 23:30:31 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
934178 | 934178 | 2020-04-16 | Netherlands | Curacao | 14 | 1 | 10 | 3 | 12.1696 | -68.99 | 2020-04-16 23:30:31 | Curacao, Netherlands | ||
934241 | 934241 | 2020-04-16 | Netherlands | Sint Maarten | 57 | 9 | 12 | 36 | 18.0425 | -63.0548 | 2020-04-16 23:30:31 | Sint Maarten, Netherlands | ||
934371 | 934371 | 2020-04-16 | Netherlands | 29214 | 3315 | 250 | 25649 | 52.1326 | 5.2913 | 2020-04-16 23:30:31 | Netherlands | |||
50174 | 50174 | 2020-04-17 | Netherlands | Aruba | 96 | 2 | 43 | 51 | 12.5211 | -69.9683 | 2020-04-17 23:30:32 | Aruba, Netherlands | ||
50178 | 50178 | 2020-04-17 | Netherlands | Bonaire, Sint Eustatius and Saba | 3 | 0 | 0 | 3 | 12.1784 | -68.2385 | 2020-04-17 23:30:32 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
50184 | 50184 | 2020-04-17 | Netherlands | Curacao | 14 | 1 | 10 | 3 | 12.1696 | -68.99 | 2020-04-17 23:30:32 | Curacao, Netherlands | ||
50247 | 50247 | 2020-04-17 | Netherlands | Sint Maarten | 57 | 9 | 12 | 36 | 18.0425 | -63.0548 | 2020-04-17 23:30:32 | Sint Maarten, Netherlands | ||
50377 | 50377 | 2020-04-17 | Netherlands | 30449 | 3459 | 250 | 26740 | 52.1326 | 5.2913 | 2020-04-17 23:30:32 | Netherlands | |||
418702 | 418702 | 2020-04-18 | Netherlands | Aruba | 96 | 2 | 44 | 50 | 12.5211 | -69.9683 | 2020-04-18 22:32:28 | Aruba, Netherlands | ||
418706 | 418706 | 2020-04-18 | Netherlands | Bonaire, Sint Eustatius and Saba | 3 | 0 | 0 | 3 | 12.1784 | -68.2385 | 2020-04-18 22:32:28 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
418712 | 418712 | 2020-04-18 | Netherlands | Curacao | 14 | 1 | 11 | 2 | 12.1696 | -68.99 | 2020-04-18 22:32:28 | Curacao, Netherlands | ||
418775 | 418775 | 2020-04-18 | Netherlands | Sint Maarten | 64 | 9 | 12 | 43 | 18.0425 | -63.0548 | 2020-04-18 22:32:28 | Sint Maarten, Netherlands | ||
418905 | 418905 | 2020-04-18 | Netherlands | 31589 | 3601 | 250 | 27738 | 52.1326 | 5.2913 | 2020-04-18 22:32:28 | Netherlands | |||
1385014 | 1385014 | 2020-04-19 | Netherlands | Aruba | 97 | 2 | 49 | 46 | 12.5211 | -69.9683 | 2020-04-19 23:40:41 | Aruba, Netherlands | ||
1385018 | 1385018 | 2020-04-19 | Netherlands | Bonaire, Sint Eustatius and Saba | 5 | 0 | 0 | 5 | 12.1784 | -68.2385 | 2020-04-19 23:40:41 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
1385024 | 1385024 | 2020-04-19 | Netherlands | Curacao | 14 | 1 | 11 | 2 | 12.1696 | -68.99 | 2020-04-19 23:40:41 | Curacao, Netherlands | ||
1385087 | 1385087 | 2020-04-19 | Netherlands | Sint Maarten | 67 | 10 | 12 | 45 | 18.0425 | -63.0548 | 2020-04-19 23:40:41 | Sint Maarten, Netherlands | ||
1385217 | 1385217 | 2020-04-19 | Netherlands | 32655 | 3684 | 250 | 28721 | 52.1326 | 5.2913 | 2020-04-19 23:40:41 | Netherlands | |||
2473322 | 2473322 | 2020-04-20 | Netherlands | Aruba | 97 | 2 | 49 | 46 | 12.5211 | -69.9683 | 2020-04-20 23:36:27 | Aruba, Netherlands | ||
2473326 | 2473326 | 2020-04-20 | Netherlands | Bonaire, Sint Eustatius and Saba | 5 | 0 | 0 | 5 | 12.1784 | -68.2385 | 2020-04-20 23:36:27 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
2473332 | 2473332 | 2020-04-20 | Netherlands | Curacao | 14 | 1 | 11 | 2 | 12.1696 | -68.99 | 2020-04-20 23:36:27 | Curacao, Netherlands | ||
2473395 | 2473395 | 2020-04-20 | Netherlands | Sint Maarten | 67 | 10 | 12 | 45 | 18.0425 | -63.0548 | 2020-04-20 23:36:27 | Sint Maarten, Netherlands | ||
2473525 | 2473525 | 2020-04-20 | Netherlands | 33405 | 3751 | 250 | 29404 | 52.1326 | 5.2913 | 2020-04-20 23:36:27 | Netherlands | |||
522240 | 522240 | 2020-04-21 | Netherlands | Aruba | 97 | 2 | 51 | 44 | 12.5211 | -69.9683 | 2020-04-21 23:30:30 | Aruba, Netherlands | ||
522244 | 522244 | 2020-04-21 | Netherlands | Bonaire, Sint Eustatius and Saba | 5 | 0 | 0 | 5 | 12.1784 | -68.2385 | 2020-04-21 23:30:30 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
522250 | 522250 | 2020-04-21 | Netherlands | Curacao | 14 | 1 | 11 | 2 | 12.1696 | -68.99 | 2020-04-21 23:30:30 | Curacao, Netherlands | ||
522313 | 522313 | 2020-04-21 | Netherlands | Sint Maarten | 67 | 10 | 12 | 45 | 18.0425 | -63.0548 | 2020-04-21 23:30:30 | Sint Maarten, Netherlands | ||
522443 | 522443 | 2020-04-21 | Netherlands | 34134 | 3916 | 0 | 30218 | 52.1326 | 5.2913 | 2020-04-21 23:30:30 | Netherlands | |||
1199175 | 1199175 | 2020-04-22 | Netherlands | Aruba | 100 | 2 | 68 | 30 | 12.5211 | -69.9683 | 2020-04-22 23:30:32 | Aruba, Netherlands | ||
1199179 | 1199179 | 2020-04-22 | Netherlands | Bonaire, Sint Eustatius and Saba | 5 | 0 | 0 | 5 | 12.1784 | -68.2385 | 2020-04-22 23:30:32 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
1199185 | 1199185 | 2020-04-22 | Netherlands | Curacao | 14 | 1 | 11 | 2 | 12.1696 | -68.99 | 2020-04-22 23:30:32 | Curacao, Netherlands | ||
1199247 | 1199247 | 2020-04-22 | Netherlands | Sint Maarten | 71 | 11 | 22 | 38 | 18.0425 | -63.0548 | 2020-04-22 23:30:32 | Sint Maarten, Netherlands | ||
1199377 | 1199377 | 2020-04-22 | Netherlands | 34842 | 4054 | 0 | 30788 | 52.1326 | 5.2913 | 2020-04-22 23:30:32 | Netherlands | |||
2524732 | 2524732 | 2020-04-23 | Netherlands | Aruba | 100 | 2 | 68 | 30 | 12.5211 | -69.9683 | 2020-04-24 03:30:31 | Aruba, Netherlands | ||
2524735 | 2524735 | 2020-04-23 | Netherlands | Bonaire, Sint Eustatius and Saba | 5 | 0 | 0 | 5 | 12.1784 | -68.2385 | 2020-04-24 03:30:31 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
2524741 | 2524741 | 2020-04-23 | Netherlands | Curacao | 14 | 1 | 11 | 2 | 12.1696 | -68.99 | 2020-04-24 03:30:31 | Curacao, Netherlands | ||
2524801 | 2524801 | 2020-04-23 | Netherlands | Sint Maarten | 73 | 12 | 22 | 39 | 18.0425 | -63.0548 | 2020-04-24 03:30:31 | Sint Maarten, Netherlands | ||
2524927 | 2524927 | 2020-04-23 | Netherlands | 35729 | 4177 | 0 | 31552 | 52.1326 | 5.2913 | 2020-04-24 03:30:31 | Netherlands | |||
1459146 | 1459146 | 2020-04-24 | Netherlands | Aruba | 100 | 2 | 69 | 29 | 12.5211 | -69.9683 | 2020-04-25 06:30:33 | Aruba, Netherlands | ||
1459149 | 1459149 | 2020-04-24 | Netherlands | Bonaire, Sint Eustatius and Saba | 5 | 0 | 0 | 5 | 12.1784 | -68.2385 | 2020-04-25 06:30:33 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
1459155 | 1459155 | 2020-04-24 | Netherlands | Curacao | 16 | 1 | 11 | 4 | 12.1696 | -68.99 | 2020-04-25 06:30:33 | Curacao, Netherlands | ||
1459212 | 1459212 | 2020-04-24 | Netherlands | Sint Maarten | 73 | 12 | 22 | 39 | 18.0425 | -63.0548 | 2020-04-25 06:30:33 | Sint Maarten, Netherlands | ||
1459338 | 1459338 | 2020-04-24 | Netherlands | 36535 | 4289 | 0 | 32246 | 52.1326 | 5.2913 | 2020-04-25 06:30:33 | Netherlands | |||
3502745 | 3502745 | 2020-04-25 | Netherlands | Aruba | 100 | 2 | 69 | 29 | 12.5211 | -69.9683 | 2020-04-26 02:30:31 | Aruba, Netherlands | ||
3502748 | 3502748 | 2020-04-25 | Netherlands | Bonaire, Sint Eustatius and Saba | 5 | 0 | 0 | 5 | 12.1784 | -68.2385 | 2020-04-26 02:30:31 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
3502754 | 3502754 | 2020-04-25 | Netherlands | Curacao | 16 | 1 | 11 | 4 | 12.1696 | -68.99 | 2020-04-26 02:30:31 | Curacao, Netherlands | ||
3502811 | 3502811 | 2020-04-25 | Netherlands | Sint Maarten | 73 | 12 | 22 | 39 | 18.0425 | -63.0548 | 2020-04-26 02:30:31 | Sint Maarten, Netherlands | ||
3502937 | 3502937 | 2020-04-25 | Netherlands | 37190 | 4409 | 0 | 32781 | 52.1326 | 5.2913 | 2020-04-26 02:30:31 | Netherlands | |||
3592396 | 3592396 | 2020-04-26 | Netherlands | Aruba | 100 | 2 | 73 | 25 | 12.5211 | -69.9683 | 2020-04-27 02:30:33 | Aruba, Netherlands | ||
3592399 | 3592399 | 2020-04-26 | Netherlands | Bonaire, Sint Eustatius and Saba | 5 | 0 | 0 | 5 | 12.1784 | -68.2385 | 2020-04-27 02:30:33 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
3592405 | 3592405 | 2020-04-26 | Netherlands | Curacao | 16 | 1 | 11 | 4 | 12.1696 | -68.99 | 2020-04-27 02:30:33 | Curacao, Netherlands | ||
3592462 | 3592462 | 2020-04-26 | Netherlands | Sint Maarten | 74 | 13 | 33 | 28 | 18.0425 | -63.0548 | 2020-04-27 02:30:33 | Sint Maarten, Netherlands | ||
3592588 | 3592588 | 2020-04-26 | Netherlands | 37845 | 4475 | 0 | 33370 | 52.1326 | 5.2913 | 2020-04-27 02:30:33 | Netherlands | |||
3589214 | 3589214 | 2020-04-27 | Netherlands | Aruba | 100 | 2 | 73 | 25 | 12.5211 | -69.9683 | 2020-04-28 02:30:32 | Aruba, Netherlands | ||
3589217 | 3589217 | 2020-04-27 | Netherlands | Bonaire, Sint Eustatius and Saba | 5 | 0 | 0 | 5 | 12.1784 | -68.2385 | 2020-04-28 02:30:32 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
3589223 | 3589223 | 2020-04-27 | Netherlands | Curacao | 16 | 1 | 11 | 4 | 12.1696 | -68.99 | 2020-04-28 02:30:32 | Curacao, Netherlands | ||
3589284 | 3589284 | 2020-04-27 | Netherlands | Sint Maarten | 74 | 13 | 33 | 28 | 18.0425 | -63.0548 | 2020-04-28 02:30:32 | Sint Maarten, Netherlands | ||
3589410 | 3589410 | 2020-04-27 | Netherlands | 38245 | 4518 | 0 | 33727 | 52.1326 | 5.2913 | 2020-04-28 02:30:32 | Netherlands | |||
271551 | 271551 | 2020-04-28 | Netherlands | Aruba | 100 | 2 | 73 | 25 | 12.5211 | -69.9683 | 2020-04-29 02:32:29 | Aruba, Netherlands | ||
271555 | 271555 | 2020-04-28 | Netherlands | Bonaire, Sint Eustatius and Saba | 5 | 0 | 0 | 5 | 12.1784 | -68.2385 | 2020-04-29 02:32:29 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
271561 | 271561 | 2020-04-28 | Netherlands | Curacao | 16 | 1 | 11 | 4 | 12.1696 | -68.99 | 2020-04-29 02:32:29 | Curacao, Netherlands | ||
271625 | 271625 | 2020-04-28 | Netherlands | Sint Maarten | 75 | 13 | 33 | 29 | 18.0425 | -63.0548 | 2020-04-29 02:32:29 | Sint Maarten, Netherlands | ||
271755 | 271755 | 2020-04-28 | Netherlands | 38416 | 4566 | 0 | 33850 | 52.1326 | 5.2913 | 2020-04-29 02:32:29 | Netherlands | |||
137337 | 137337 | 2020-04-29 | Netherlands | Aruba | 100 | 2 | 73 | 25 | 12.5211 | -69.9683 | 2020-04-30 02:32:27 | Aruba, Netherlands | ||
137341 | 137341 | 2020-04-29 | Netherlands | Bonaire, Sint Eustatius and Saba | 5 | 0 | 0 | 5 | 12.1784 | -68.2385 | 2020-04-30 02:32:27 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
137347 | 137347 | 2020-04-29 | Netherlands | Curacao | 16 | 1 | 13 | 2 | 12.1696 | -68.99 | 2020-04-30 02:32:27 | Curacao, Netherlands | ||
137411 | 137411 | 2020-04-29 | Netherlands | Sint Maarten | 75 | 13 | 33 | 29 | 18.0425 | -63.0548 | 2020-04-30 02:32:27 | Sint Maarten, Netherlands | ||
137541 | 137541 | 2020-04-29 | Netherlands | 38802 | 4711 | 0 | 34091 | 52.1326 | 5.2913 | 2020-04-30 02:32:27 | Netherlands | |||
228590 | 228590 | 2020-04-30 | Netherlands | Aruba | 100 | 2 | 79 | 19 | 12.5211 | -69.9683 | 2020-05-01 02:32:28 | Aruba, Netherlands | ||
228594 | 228594 | 2020-04-30 | Netherlands | Bonaire, Sint Eustatius and Saba | 5 | 0 | 0 | 5 | 12.1784 | -68.2385 | 2020-05-01 02:32:28 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
228600 | 228600 | 2020-04-30 | Netherlands | Curacao | 16 | 1 | 13 | 2 | 12.1696 | -68.99 | 2020-05-01 02:32:28 | Curacao, Netherlands | ||
228664 | 228664 | 2020-04-30 | Netherlands | Sint Maarten | 75 | 13 | 33 | 29 | 18.0425 | -63.0548 | 2020-05-01 02:32:28 | Sint Maarten, Netherlands | ||
228795 | 228795 | 2020-04-30 | Netherlands | 39316 | 4795 | 0 | 34521 | 52.1326 | 5.2913 | 2020-05-01 02:32:28 | Netherlands | |||
1184109 | 1184109 | 2020-05-01 | Netherlands | Aruba | 100 | 2 | 81 | 17 | 12.5211 | -69.9683 | 2020-05-02 02:32:27 | Aruba, Netherlands | ||
1184113 | 1184113 | 2020-05-01 | Netherlands | Bonaire, Sint Eustatius and Saba | 6 | 0 | 0 | 6 | 12.1784 | -68.2385 | 2020-05-02 02:32:27 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
1184119 | 1184119 | 2020-05-01 | Netherlands | Curacao | 16 | 1 | 13 | 2 | 12.1696 | -68.99 | 2020-05-02 02:32:27 | Curacao, Netherlands | ||
1184183 | 1184183 | 2020-05-01 | Netherlands | Sint Maarten | 76 | 13 | 44 | 19 | 18.0425 | -63.0548 | 2020-05-02 02:32:27 | Sint Maarten, Netherlands | ||
1184314 | 1184314 | 2020-05-01 | Netherlands | 39791 | 4893 | 0 | 34898 | 52.1326 | 5.2913 | 2020-05-02 02:32:27 | Netherlands | |||
2043215 | 2043215 | 2020-05-02 | Netherlands | Aruba | 100 | 2 | 81 | 17 | 12.5211 | -69.9683 | 2020-05-03 02:32:28 | Aruba, Netherlands |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);