johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,379 rows where confirmed = 190 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 23
- US 1,085
- China 232
- France 11
- Japan 7
- Barbados 6
- United Kingdom 6
- Malaysia 5
- Russia 5
- Canada 4
- Antigua and Barbuda 2
- Colombia 2
- Netherlands 2
- Sri Lanka 2
- Australia 1
- Brunei 1
- Cote d'Ivoire 1
- El Salvador 1
- Eswatini 1
- Fiji 1
- Greece 1
- Mainland China 1
- Senegal 1
- Ukraine 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755023 | 2755023 | 2022-12-29 | US | Nebraska | Rock | 31149 | 190 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-12-30 04:21:04 | Rock, Nebraska, US | |
1076029 | 1076029 | 2022-12-28 | US | Nebraska | Rock | 31149 | 190 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-12-29 04:21:01 | Rock, Nebraska, US | |
330026 | 330026 | 2022-12-27 | US | Nebraska | Rock | 31149 | 190 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-12-28 04:21:04 | Rock, Nebraska, US | |
220099 | 220099 | 2022-12-26 | US | Nebraska | Rock | 31149 | 190 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-12-27 04:21:07 | Rock, Nebraska, US | |
3224556 | 3224556 | 2022-12-25 | US | Nebraska | Rock | 31149 | 190 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-12-26 04:21:06 | Rock, Nebraska, US | |
1020470 | 1020470 | 2022-12-24 | US | Nebraska | Rock | 31149 | 190 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-12-25 04:21:04 | Rock, Nebraska, US | |
692493 | 692493 | 2022-12-23 | US | Nebraska | Rock | 31149 | 190 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-12-24 04:21:02 | Rock, Nebraska, US | |
2181703 | 2181703 | 2022-12-22 | US | Nebraska | Rock | 31149 | 190 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-12-23 04:21:04 | Rock, Nebraska, US | |
453507 | 453507 | 2022-12-21 | US | Nebraska | Rock | 31149 | 190 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-12-22 04:20:56 | Rock, Nebraska, US | |
2954598 | 2954598 | 2022-12-20 | US | Texas | Roberts | 48393 | 190 | 2 | 0 | 35.83809685 | -100.813175 | 2022-12-21 04:21:03 | Roberts, Texas, US | |
2953506 | 2953506 | 2022-12-20 | US | Nebraska | Rock | 31149 | 190 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-12-21 04:21:03 | Rock, Nebraska, US | |
3177000 | 3177000 | 2022-12-19 | US | Texas | Roberts | 48393 | 190 | 2 | 0 | 35.83809685 | -100.813175 | 2022-12-20 04:21:04 | Roberts, Texas, US | |
3175908 | 3175908 | 2022-12-19 | US | Nebraska | Rock | 31149 | 190 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-12-20 04:21:04 | Rock, Nebraska, US | |
1631517 | 1631517 | 2022-12-18 | US | Texas | Roberts | 48393 | 190 | 2 | 0 | 35.83809685 | -100.813175 | 2022-12-19 04:21:03 | Roberts, Texas, US | |
1630425 | 1630425 | 2022-12-18 | US | Nebraska | Rock | 31149 | 190 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-12-19 04:21:03 | Rock, Nebraska, US | |
506896 | 506896 | 2022-12-17 | US | Texas | Roberts | 48393 | 190 | 2 | 0 | 35.83809685 | -100.813175 | 2022-12-18 04:21:03 | Roberts, Texas, US | |
505804 | 505804 | 2022-12-17 | US | Nebraska | Rock | 31149 | 190 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-12-18 04:21:03 | Rock, Nebraska, US | |
3327468 | 3327468 | 2022-12-16 | US | Texas | Roberts | 48393 | 190 | 2 | 0 | 35.83809685 | -100.813175 | 2022-12-17 04:21:04 | Roberts, Texas, US | |
3326376 | 3326376 | 2022-12-16 | US | Nebraska | Rock | 31149 | 190 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-12-17 04:21:04 | Rock, Nebraska, US | |
545980 | 545980 | 2022-12-15 | US | Texas | Roberts | 48393 | 190 | 2 | 0 | 35.83809685 | -100.813175 | 2022-12-16 04:21:01 | Roberts, Texas, US | |
544888 | 544888 | 2022-12-15 | US | Nebraska | Rock | 31149 | 190 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-12-16 04:21:01 | Rock, Nebraska, US | |
351508 | 351508 | 2022-12-14 | US | Texas | Roberts | 48393 | 190 | 2 | 0 | 35.83809685 | -100.813175 | 2022-12-15 04:20:58 | Roberts, Texas, US | |
350416 | 350416 | 2022-12-14 | US | Nebraska | Rock | 31149 | 190 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-12-15 04:20:58 | Rock, Nebraska, US | |
311096 | 311096 | 2022-12-13 | US | Texas | Roberts | 48393 | 190 | 2 | 0 | 35.83809685 | -100.813175 | 2022-12-14 04:21:04 | Roberts, Texas, US | |
310004 | 310004 | 2022-12-13 | US | Nebraska | Rock | 31149 | 190 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-12-14 04:21:04 | Rock, Nebraska, US | |
1152157 | 1152157 | 2022-12-12 | US | Texas | Roberts | 48393 | 190 | 2 | 0 | 35.83809685 | -100.813175 | 2022-12-13 04:21:01 | Roberts, Texas, US | |
1151065 | 1151065 | 2022-12-12 | US | Nebraska | Rock | 31149 | 190 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-12-13 04:21:01 | Rock, Nebraska, US | |
872011 | 872011 | 2022-12-11 | US | Texas | Roberts | 48393 | 190 | 2 | 0 | 35.83809685 | -100.813175 | 2022-12-12 04:21:01 | Roberts, Texas, US | |
870919 | 870919 | 2022-12-11 | US | Nebraska | Rock | 31149 | 190 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-12-12 04:21:01 | Rock, Nebraska, US | |
260541 | 260541 | 2022-12-10 | US | Texas | Roberts | 48393 | 190 | 2 | 0 | 35.83809685 | -100.813175 | 2022-12-11 04:20:50 | Roberts, Texas, US | |
259449 | 259449 | 2022-12-10 | US | Nebraska | Rock | 31149 | 190 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-12-11 04:20:50 | Rock, Nebraska, US | |
3939255 | 3939255 | 2022-12-09 | US | Texas | Roberts | 48393 | 190 | 2 | 0 | 35.83809685 | -100.813175 | 2022-12-10 04:21:02 | Roberts, Texas, US | |
3938163 | 3938163 | 2022-12-09 | US | Nebraska | Rock | 31149 | 190 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-12-10 04:21:02 | Rock, Nebraska, US | |
3380587 | 3380587 | 2022-12-08 | US | Texas | Roberts | 48393 | 190 | 2 | 0 | 35.83809685 | -100.813175 | 2022-12-09 04:21:05 | Roberts, Texas, US | |
3379495 | 3379495 | 2022-12-08 | US | Nebraska | Rock | 31149 | 190 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-12-09 04:21:05 | Rock, Nebraska, US | |
1987858 | 1987858 | 2022-12-07 | US | Texas | Roberts | 48393 | 190 | 2 | 0 | 35.83809685 | -100.813175 | 2022-12-08 04:21:07 | Roberts, Texas, US | |
1986766 | 1986766 | 2022-12-07 | US | Nebraska | Rock | 31149 | 190 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-12-08 04:21:07 | Rock, Nebraska, US | |
3717057 | 3717057 | 2022-12-06 | US | South Dakota | Jones | 46075 | 190 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-12-07 04:20:58 | Jones, South Dakota, US | |
3716289 | 3716289 | 2022-12-06 | US | Nebraska | Rock | 31149 | 190 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-12-07 04:20:58 | Rock, Nebraska, US | |
2417762 | 2417762 | 2022-12-05 | US | South Dakota | Jones | 46075 | 190 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-12-06 04:21:03 | Jones, South Dakota, US | |
2416994 | 2416994 | 2022-12-05 | US | Nebraska | Rock | 31149 | 190 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-12-06 04:21:03 | Rock, Nebraska, US | |
721370 | 721370 | 2022-12-04 | US | South Dakota | Jones | 46075 | 190 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-12-05 04:20:58 | Jones, South Dakota, US | |
720602 | 720602 | 2022-12-04 | US | Nebraska | Rock | 31149 | 190 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-12-05 04:20:58 | Rock, Nebraska, US | |
2819659 | 2819659 | 2022-12-03 | US | South Dakota | Jones | 46075 | 190 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-12-04 04:20:56 | Jones, South Dakota, US | |
2818891 | 2818891 | 2022-12-03 | US | Nebraska | Rock | 31149 | 190 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-12-04 04:20:56 | Rock, Nebraska, US | |
836515 | 836515 | 2022-12-02 | US | South Dakota | Jones | 46075 | 190 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-12-03 04:21:02 | Jones, South Dakota, US | |
835747 | 835747 | 2022-12-02 | US | Nebraska | Rock | 31149 | 190 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-12-03 04:21:02 | Rock, Nebraska, US | |
2139045 | 2139045 | 2022-12-01 | US | South Dakota | Jones | 46075 | 190 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-12-02 04:21:07 | Jones, South Dakota, US | |
2138277 | 2138277 | 2022-12-01 | US | Nebraska | Rock | 31149 | 190 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-12-02 04:21:07 | Rock, Nebraska, US | |
1967461 | 1967461 | 2022-11-30 | US | South Dakota | Jones | 46075 | 190 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-12-01 04:21:03 | Jones, South Dakota, US | |
1966693 | 1966693 | 2022-11-30 | US | Nebraska | Rock | 31149 | 190 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-12-01 04:21:03 | Rock, Nebraska, US | |
2558707 | 2558707 | 2022-11-29 | US | Nebraska | Rock | 31149 | 190 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-11-30 04:21:07 | Rock, Nebraska, US | |
1241781 | 1241781 | 2022-11-28 | US | Nebraska | Rock | 31149 | 190 | 3 | 0 | 42.42252217 | -99.44832069 | 2022-11-29 04:21:05 | Rock, Nebraska, US | |
3773711 | 3773711 | 2022-08-30 | China | Qinghai | 190 | 0 | 0 | 35.7452 | 95.9956 | 2022-08-31 04:20:57 | Qinghai, China | |||
990784 | 990784 | 2022-08-16 | China | Guizhou | 190 | 2 | 0 | 26.8154 | 106.8748 | 2022-08-17 04:20:59 | Guizhou, China | |||
2493823 | 2493823 | 2022-08-15 | China | Guizhou | 190 | 2 | 0 | 26.8154 | 106.8748 | 2022-08-16 04:20:58 | Guizhou, China | |||
3872190 | 3872190 | 2022-07-31 | US | Colorado | Jackson | 8057 | 190 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-08-01 04:21:03 | Jackson, Colorado, US | |
674944 | 674944 | 2022-07-30 | US | Colorado | Jackson | 8057 | 190 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-07-31 04:21:02 | Jackson, Colorado, US | |
1784143 | 1784143 | 2022-07-29 | US | Colorado | Jackson | 8057 | 190 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-07-30 04:20:42 | Jackson, Colorado, US | |
1066506 | 1066506 | 2022-07-28 | US | Colorado | Jackson | 8057 | 190 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-07-29 04:20:45 | Jackson, Colorado, US | |
2336025 | 2336025 | 2022-07-27 | US | Colorado | Jackson | 8057 | 190 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-07-28 04:20:56 | Jackson, Colorado, US | |
1488215 | 1488215 | 2022-07-26 | US | Colorado | Jackson | 8057 | 190 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-07-27 04:21:04 | Jackson, Colorado, US | |
3268659 | 3268659 | 2022-05-04 | US | Texas | Loving | 48301 | 190 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-05-05 04:20:55 | Loving, Texas, US | |
2732815 | 2732815 | 2022-02-27 | China | Hainan | 190 | 6 | 0 | 19.1959 | 109.7453 | 2022-02-28 04:21:05 | Hainan, China | |||
3045968 | 3045968 | 2022-02-26 | China | Hainan | 190 | 6 | 0 | 19.1959 | 109.7453 | 2022-02-27 04:21:04 | Hainan, China | |||
574623 | 574623 | 2022-02-25 | China | Hainan | 190 | 6 | 0 | 19.1959 | 109.7453 | 2022-02-26 04:21:12 | Hainan, China | |||
1511199 | 1511199 | 2022-02-24 | China | Hainan | 190 | 6 | 0 | 19.1959 | 109.7453 | 2022-02-25 04:21:11 | Hainan, China | |||
1057640 | 1057640 | 2022-02-23 | China | Hainan | 190 | 6 | 0 | 19.1959 | 109.7453 | 2022-02-24 04:21:14 | Hainan, China | |||
2446563 | 2446563 | 2022-02-22 | China | Hainan | 190 | 6 | 0 | 19.1959 | 109.7453 | 2022-02-23 04:21:09 | Hainan, China | |||
3717976 | 3717976 | 2022-02-21 | China | Hainan | 190 | 6 | 0 | 19.1959 | 109.7453 | 2022-02-22 04:21:01 | Hainan, China | |||
3911810 | 3911810 | 2022-02-20 | China | Hainan | 190 | 6 | 0 | 19.1959 | 109.7453 | 2022-02-21 04:21:05 | Hainan, China | |||
3875368 | 3875368 | 2022-02-19 | China | Hainan | 190 | 6 | 0 | 19.1959 | 109.7453 | 2022-02-20 04:21:00 | Hainan, China | |||
3855624 | 3855624 | 2022-02-18 | China | Hainan | 190 | 6 | 0 | 19.1959 | 109.7453 | 2022-02-19 04:21:11 | Hainan, China | |||
1297843 | 1297843 | 2022-02-17 | China | Hainan | 190 | 6 | 0 | 19.1959 | 109.7453 | 2022-02-18 04:21:04 | Hainan, China | |||
3820229 | 3820229 | 2022-02-16 | China | Hainan | 190 | 6 | 0 | 19.1959 | 109.7453 | 2022-02-17 04:20:56 | Hainan, China | |||
3671443 | 3671443 | 2022-02-15 | China | Hainan | 190 | 6 | 0 | 19.1959 | 109.7453 | 2022-02-16 04:21:10 | Hainan, China | |||
2641544 | 2641544 | 2022-02-14 | China | Hainan | 190 | 6 | 0 | 19.1959 | 109.7453 | 2022-02-15 04:21:09 | Hainan, China | |||
185861 | 185861 | 2022-02-13 | China | Hainan | 190 | 6 | 0 | 19.1959 | 109.7453 | 2022-02-14 04:20:51 | Hainan, China | |||
315707 | 315707 | 2022-02-12 | China | Hainan | 190 | 6 | 0 | 19.1959 | 109.7453 | 2022-02-13 04:21:00 | Hainan, China | |||
233033 | 233033 | 2022-02-11 | China | Hainan | 190 | 6 | 0 | 19.1959 | 109.7453 | 2022-02-12 04:21:06 | Hainan, China | |||
1463875 | 1463875 | 2022-02-10 | China | Hainan | 190 | 6 | 0 | 19.1959 | 109.7453 | 2022-02-11 04:21:09 | Hainan, China | |||
3073836 | 3073836 | 2022-02-09 | China | Hainan | 190 | 6 | 0 | 19.1959 | 109.7453 | 2022-02-10 04:21:14 | Hainan, China | |||
1362143 | 1362143 | 2022-02-08 | China | Hainan | 190 | 6 | 0 | 19.1959 | 109.7453 | 2022-02-09 04:21:04 | Hainan, China | |||
70881 | 70881 | 2022-02-07 | China | Hainan | 190 | 6 | 0 | 19.1959 | 109.7453 | 2022-02-08 04:21:15 | Hainan, China | |||
2012497 | 2012497 | 2022-02-06 | China | Hainan | 190 | 6 | 0 | 19.1959 | 109.7453 | 2022-02-07 04:21:05 | Hainan, China | |||
1293826 | 1293826 | 2022-02-05 | China | Hainan | 190 | 6 | 0 | 19.1959 | 109.7453 | 2022-02-06 04:21:00 | Hainan, China | |||
2327154 | 2327154 | 2022-02-04 | China | Hainan | 190 | 6 | 0 | 19.1959 | 109.7453 | 2022-02-05 04:21:05 | Hainan, China | |||
2473745 | 2473745 | 2022-02-03 | China | Hainan | 190 | 6 | 0 | 19.1959 | 109.7453 | 2022-02-04 04:21:10 | Hainan, China | |||
459170 | 459170 | 2022-02-02 | China | Hainan | 190 | 6 | 0 | 19.1959 | 109.7453 | 2022-02-03 04:21:21 | Hainan, China | |||
978739 | 978739 | 2022-02-01 | China | Hainan | 190 | 6 | 0 | 19.1959 | 109.7453 | 2022-02-02 04:21:09 | Hainan, China | |||
2657581 | 2657581 | 2022-01-31 | China | Hainan | 190 | 6 | 0 | 19.1959 | 109.7453 | 2022-02-01 04:21:11 | Hainan, China | |||
3299998 | 3299998 | 2022-01-30 | China | Hainan | 190 | 6 | 0 | 19.1959 | 109.7453 | 2022-01-31 04:21:09 | Hainan, China | |||
3061789 | 3061789 | 2022-01-29 | China | Hainan | 190 | 6 | 0 | 19.1959 | 109.7453 | 2022-01-30 04:21:26 | Hainan, China | |||
3809723 | 3809723 | 2022-01-28 | China | Hainan | 190 | 6 | 0 | 19.1959 | 109.7453 | 2022-01-29 04:21:10 | Hainan, China | |||
1779177 | 1779177 | 2022-01-27 | China | Hainan | 190 | 6 | 0 | 19.1959 | 109.7453 | 2022-01-28 04:21:09 | Hainan, China | |||
1321357 | 1321357 | 2022-01-26 | US | Texas | Kent | 48263 | 190 | 3 | 0 | 33.18104136 | -100.7780939 | 2022-01-27 04:21:19 | Kent, Texas, US | |
1318870 | 1318870 | 2022-01-26 | US | Colorado | San Juan | 8111 | 190 | 0 | 0 | 37.76248981 | -107.67632890000002 | 2022-01-27 04:21:19 | San Juan, Colorado, US | |
1318005 | 1318005 | 2022-01-26 | China | Hainan | 190 | 6 | 0 | 19.1959 | 109.7453 | 2022-01-27 04:21:19 | Hainan, China | |||
2051673 | 2051673 | 2022-01-25 | China | Hainan | 190 | 6 | 0 | 19.1959 | 109.7453 | 2022-01-26 04:21:07 | Hainan, China | |||
1227404 | 1227404 | 2022-01-24 | China | Hainan | 190 | 6 | 0 | 19.1959 | 109.7453 | 2022-01-25 04:21:05 | Hainan, China |
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]);