johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
977 rows where confirmed = 291 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 907
- China 16
- Japan 10
- Canada 9
- Malaysia 6
- United Kingdom 6
- Mongolia 4
- Cambodia 3
- Ukraine 2
- Angola 1
- Australia 1
- Barbados 1
- Burma 1
- Denmark 1
- Guyana 1
- Mainland China 1
- Mexico 1
- Nepal 1
- Netherlands 1
- New Zealand 1
- Russia 1
- Senegal 1
- Sierra Leone 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2951525 | 2951525 | 2022-12-20 | New Zealand | Niue | 291 | 0 | 0 | -19.0544 | -169.8672 | 2022-12-21 04:21:03 | Niue, New Zealand | |||
2505864 | 2505864 | 2022-11-10 | China | Qinghai | 291 | 0 | 0 | 35.7452 | 95.9956 | 2022-11-11 04:21:22 | Qinghai, China | |||
2432750 | 2432750 | 2022-11-09 | US | Mississippi | Issaquena | 28055 | 291 | 9 | 0 | 32.72531359 | -90.97392828 | 2022-11-10 04:21:16 | Issaquena, Mississippi, US | |
2430739 | 2430739 | 2022-11-09 | China | Qinghai | 291 | 0 | 0 | 35.7452 | 95.9956 | 2022-11-10 04:21:16 | Qinghai, China | |||
481406 | 481406 | 2022-11-08 | US | Mississippi | Issaquena | 28055 | 291 | 9 | 0 | 32.72531359 | -90.97392828 | 2022-11-09 04:21:22 | Issaquena, Mississippi, US | |
2440556 | 2440556 | 2022-11-07 | US | Mississippi | Issaquena | 28055 | 291 | 9 | 0 | 32.72531359 | -90.97392828 | 2022-11-08 04:21:21 | Issaquena, Mississippi, US | |
1051654 | 1051654 | 2022-11-06 | US | Mississippi | Issaquena | 28055 | 291 | 9 | 0 | 32.72531359 | -90.97392828 | 2022-11-07 04:21:26 | Issaquena, Mississippi, US | |
619678 | 619678 | 2022-11-05 | US | Mississippi | Issaquena | 28055 | 291 | 9 | 0 | 32.72531359 | -90.97392828 | 2022-11-06 04:21:24 | Issaquena, Mississippi, US | |
1024182 | 1024182 | 2022-11-04 | US | Mississippi | Issaquena | 28055 | 291 | 9 | 0 | 32.72531359 | -90.97392828 | 2022-11-05 04:21:52 | Issaquena, Mississippi, US | |
434596 | 434596 | 2022-11-03 | US | Texas | Throckmorton | 48447 | 291 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-11-04 04:22:11 | Throckmorton, Texas, US | |
433173 | 433173 | 2022-11-03 | US | Mississippi | Issaquena | 28055 | 291 | 9 | 0 | 32.72531359 | -90.97392828 | 2022-11-04 04:22:11 | Issaquena, Mississippi, US | |
852838 | 852838 | 2022-11-02 | US | Texas | Throckmorton | 48447 | 291 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-11-03 04:22:05 | Throckmorton, Texas, US | |
851415 | 851415 | 2022-11-02 | US | Mississippi | Issaquena | 28055 | 291 | 9 | 0 | 32.72531359 | -90.97392828 | 2022-11-03 04:22:05 | Issaquena, Mississippi, US | |
713689 | 713689 | 2022-11-01 | US | Texas | Throckmorton | 48447 | 291 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-11-02 04:22:09 | Throckmorton, Texas, US | |
712266 | 712266 | 2022-11-01 | US | Mississippi | Issaquena | 28055 | 291 | 9 | 0 | 32.72531359 | -90.97392828 | 2022-11-02 04:22:09 | Issaquena, Mississippi, US | |
3288138 | 3288138 | 2022-10-31 | US | Texas | Throckmorton | 48447 | 291 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-11-01 04:22:36 | Throckmorton, Texas, US | |
3286715 | 3286715 | 2022-10-31 | US | Mississippi | Issaquena | 28055 | 291 | 9 | 0 | 32.72531359 | -90.97392828 | 2022-11-01 04:22:36 | Issaquena, Mississippi, US | |
323171 | 323171 | 2022-10-30 | US | Texas | Throckmorton | 48447 | 291 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-10-31 04:21:36 | Throckmorton, Texas, US | |
321748 | 321748 | 2022-10-30 | US | Mississippi | Issaquena | 28055 | 291 | 9 | 0 | 32.72531359 | -90.97392828 | 2022-10-31 04:21:36 | Issaquena, Mississippi, US | |
320575 | 320575 | 2022-10-30 | US | Colorado | Mineral | 8079 | 291 | 3 | 0 | 37.66954283 | -106.9281698 | 2022-10-31 04:21:36 | Mineral, Colorado, US | |
915447 | 915447 | 2022-10-29 | US | Texas | Throckmorton | 48447 | 291 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-10-30 04:22:14 | Throckmorton, Texas, US | |
914024 | 914024 | 2022-10-29 | US | Mississippi | Issaquena | 28055 | 291 | 9 | 0 | 32.72531359 | -90.97392828 | 2022-10-30 04:22:14 | Issaquena, Mississippi, US | |
912851 | 912851 | 2022-10-29 | US | Colorado | Mineral | 8079 | 291 | 3 | 0 | 37.66954283 | -106.9281698 | 2022-10-30 04:22:14 | Mineral, Colorado, US | |
1369716 | 1369716 | 2022-10-28 | US | Texas | Throckmorton | 48447 | 291 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-10-29 04:21:13 | Throckmorton, Texas, US | |
1368293 | 1368293 | 2022-10-28 | US | Mississippi | Issaquena | 28055 | 291 | 9 | 0 | 32.72531359 | -90.97392828 | 2022-10-29 04:21:13 | Issaquena, Mississippi, US | |
1367120 | 1367120 | 2022-10-28 | US | Colorado | Mineral | 8079 | 291 | 3 | 0 | 37.66954283 | -106.9281698 | 2022-10-29 04:21:13 | Mineral, Colorado, US | |
3041571 | 3041571 | 2022-10-27 | US | Texas | Throckmorton | 48447 | 291 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-10-28 04:22:31 | Throckmorton, Texas, US | |
3040148 | 3040148 | 2022-10-27 | US | Mississippi | Issaquena | 28055 | 291 | 9 | 0 | 32.72531359 | -90.97392828 | 2022-10-28 04:22:31 | Issaquena, Mississippi, US | |
3038975 | 3038975 | 2022-10-27 | US | Colorado | Mineral | 8079 | 291 | 3 | 0 | 37.66954283 | -106.9281698 | 2022-10-28 04:22:31 | Mineral, Colorado, US | |
541991 | 541991 | 2022-10-26 | US | Texas | Throckmorton | 48447 | 291 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-10-27 04:22:01 | Throckmorton, Texas, US | |
540568 | 540568 | 2022-10-26 | US | Mississippi | Issaquena | 28055 | 291 | 9 | 0 | 32.72531359 | -90.97392828 | 2022-10-27 04:22:01 | Issaquena, Mississippi, US | |
539395 | 539395 | 2022-10-26 | US | Colorado | Mineral | 8079 | 291 | 3 | 0 | 37.66954283 | -106.9281698 | 2022-10-27 04:22:01 | Mineral, Colorado, US | |
1833392 | 1833392 | 2022-10-25 | US | Texas | Throckmorton | 48447 | 291 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-10-26 04:22:19 | Throckmorton, Texas, US | |
1830796 | 1830796 | 2022-10-25 | US | Colorado | Mineral | 8079 | 291 | 3 | 0 | 37.66954283 | -106.9281698 | 2022-10-26 04:22:19 | Mineral, Colorado, US | |
797653 | 797653 | 2022-10-24 | US | Texas | Throckmorton | 48447 | 291 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-10-25 04:21:53 | Throckmorton, Texas, US | |
795057 | 795057 | 2022-10-24 | US | Colorado | Mineral | 8079 | 291 | 3 | 0 | 37.66954283 | -106.9281698 | 2022-10-25 04:21:53 | Mineral, Colorado, US | |
3280108 | 3280108 | 2022-10-23 | US | Texas | Throckmorton | 48447 | 291 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-10-24 04:22:29 | Throckmorton, Texas, US | |
3277512 | 3277512 | 2022-10-23 | US | Colorado | Mineral | 8079 | 291 | 3 | 0 | 37.66954283 | -106.9281698 | 2022-10-24 04:22:29 | Mineral, Colorado, US | |
2271146 | 2271146 | 2022-10-22 | US | Texas | Throckmorton | 48447 | 291 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-10-23 04:22:46 | Throckmorton, Texas, US | |
2268550 | 2268550 | 2022-10-22 | US | Colorado | Mineral | 8079 | 291 | 3 | 0 | 37.66954283 | -106.9281698 | 2022-10-23 04:22:46 | Mineral, Colorado, US | |
1595446 | 1595446 | 2022-10-21 | US | Texas | Throckmorton | 48447 | 291 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-10-22 04:22:53 | Throckmorton, Texas, US | |
1592850 | 1592850 | 2022-10-21 | US | Colorado | Mineral | 8079 | 291 | 3 | 0 | 37.66954283 | -106.9281698 | 2022-10-22 04:22:53 | Mineral, Colorado, US | |
2275162 | 2275162 | 2022-10-20 | US | Texas | Throckmorton | 48447 | 291 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-10-21 04:22:23 | Throckmorton, Texas, US | |
2272566 | 2272566 | 2022-10-20 | US | Colorado | Mineral | 8079 | 291 | 3 | 0 | 37.66954283 | -106.9281698 | 2022-10-21 04:22:23 | Mineral, Colorado, US | |
201497 | 201497 | 2022-10-19 | US | Texas | Throckmorton | 48447 | 291 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-10-20 04:22:59 | Throckmorton, Texas, US | |
198901 | 198901 | 2022-10-19 | US | Colorado | Mineral | 8079 | 291 | 3 | 0 | 37.66954283 | -106.9281698 | 2022-10-20 04:22:59 | Mineral, Colorado, US | |
2760158 | 2760158 | 2022-10-18 | US | Texas | Throckmorton | 48447 | 291 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-10-19 04:22:26 | Throckmorton, Texas, US | |
2757562 | 2757562 | 2022-10-18 | US | Colorado | Mineral | 8079 | 291 | 3 | 0 | 37.66954283 | -106.9281698 | 2022-10-19 04:22:26 | Mineral, Colorado, US | |
2027992 | 2027992 | 2022-10-17 | US | Texas | Throckmorton | 48447 | 291 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-10-18 04:22:42 | Throckmorton, Texas, US | |
2025396 | 2025396 | 2022-10-17 | US | Colorado | Mineral | 8079 | 291 | 3 | 0 | 37.66954283 | -106.9281698 | 2022-10-18 04:22:42 | Mineral, Colorado, US | |
2162770 | 2162770 | 2022-10-16 | US | Texas | Throckmorton | 48447 | 291 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-10-17 04:20:31 | Throckmorton, Texas, US | |
2160174 | 2160174 | 2022-10-16 | US | Colorado | Mineral | 8079 | 291 | 3 | 0 | 37.66954283 | -106.9281698 | 2022-10-17 04:20:31 | Mineral, Colorado, US | |
518967 | 518967 | 2022-10-15 | US | Texas | Throckmorton | 48447 | 291 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-10-16 04:22:39 | Throckmorton, Texas, US | |
516371 | 516371 | 2022-10-15 | US | Colorado | Mineral | 8079 | 291 | 3 | 0 | 37.66954283 | -106.9281698 | 2022-10-16 04:22:39 | Mineral, Colorado, US | |
2036024 | 2036024 | 2022-10-14 | US | Texas | Throckmorton | 48447 | 291 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-10-15 04:22:00 | Throckmorton, Texas, US | |
2033428 | 2033428 | 2022-10-14 | US | Colorado | Mineral | 8079 | 291 | 3 | 0 | 37.66954283 | -106.9281698 | 2022-10-15 04:22:00 | Mineral, Colorado, US | |
3756712 | 3756712 | 2022-10-13 | US | Texas | Throckmorton | 48447 | 291 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-10-14 04:22:28 | Throckmorton, Texas, US | |
3754116 | 3754116 | 2022-10-13 | US | Colorado | Mineral | 8079 | 291 | 3 | 0 | 37.66954283 | -106.9281698 | 2022-10-14 04:22:28 | Mineral, Colorado, US | |
3217537 | 3217537 | 2022-10-12 | US | Texas | Throckmorton | 48447 | 291 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-10-13 04:22:39 | Throckmorton, Texas, US | |
3214941 | 3214941 | 2022-10-12 | US | Colorado | Mineral | 8079 | 291 | 3 | 0 | 37.66954283 | -106.9281698 | 2022-10-13 04:22:39 | Mineral, Colorado, US | |
3253386 | 3253386 | 2022-10-11 | US | Texas | Throckmorton | 48447 | 291 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-10-12 04:22:51 | Throckmorton, Texas, US | |
3250790 | 3250790 | 2022-10-11 | US | Colorado | Mineral | 8079 | 291 | 3 | 0 | 37.66954283 | -106.9281698 | 2022-10-12 04:22:51 | Mineral, Colorado, US | |
2970645 | 2970645 | 2022-10-10 | US | Texas | Throckmorton | 48447 | 291 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-10-11 04:23:05 | Throckmorton, Texas, US | |
3100681 | 3100681 | 2022-10-09 | US | Texas | Throckmorton | 48447 | 291 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-10-10 04:22:32 | Throckmorton, Texas, US | |
4005906 | 4005906 | 2022-10-08 | US | Texas | Throckmorton | 48447 | 291 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-10-09 04:21:16 | Throckmorton, Texas, US | |
399503 | 399503 | 2022-10-07 | US | Texas | Throckmorton | 48447 | 291 | 10 | 0 | 33.17751417 | -99.21226795 | 2022-10-08 04:22:56 | Throckmorton, Texas, US | |
2376184 | 2376184 | 2022-09-29 | US | Colorado | Mineral | 8079 | 291 | 3 | 0 | 37.66954283 | -106.9281698 | 2022-09-30 04:23:09 | Mineral, Colorado, US | |
1560735 | 1560735 | 2022-09-28 | US | Colorado | Mineral | 8079 | 291 | 3 | 0 | 37.66954283 | -106.9281698 | 2022-09-29 04:22:34 | Mineral, Colorado, US | |
3995278 | 3995278 | 2022-09-27 | US | Colorado | Mineral | 8079 | 291 | 3 | 0 | 37.66954283 | -106.9281698 | 2022-09-28 04:23:01 | Mineral, Colorado, US | |
2769606 | 2769606 | 2022-09-26 | US | Colorado | Mineral | 8079 | 291 | 3 | 0 | 37.66954283 | -106.9281698 | 2022-09-27 04:23:01 | Mineral, Colorado, US | |
1977259 | 1977259 | 2022-09-25 | US | Colorado | Mineral | 8079 | 291 | 3 | 0 | 37.66954283 | -106.9281698 | 2022-09-26 04:20:52 | Mineral, Colorado, US | |
2650426 | 2650426 | 2022-09-24 | US | Colorado | Mineral | 8079 | 291 | 3 | 0 | 37.66954283 | -106.9281698 | 2022-09-25 04:23:31 | Mineral, Colorado, US | |
384866 | 384866 | 2022-09-23 | US | Colorado | Mineral | 8079 | 291 | 3 | 0 | 37.66954283 | -106.9281698 | 2022-09-24 04:21:40 | Mineral, Colorado, US | |
1624932 | 1624932 | 2022-09-22 | US | Colorado | Mineral | 8079 | 291 | 3 | 0 | 37.66954283 | -106.9281698 | 2022-09-23 04:23:13 | Mineral, Colorado, US | |
1371136 | 1371136 | 2022-09-21 | US | Colorado | Mineral | 8079 | 291 | 3 | 0 | 37.66954283 | -106.9281698 | 2022-09-22 04:22:56 | Mineral, Colorado, US | |
2017366 | 2017366 | 2022-09-20 | US | Colorado | Mineral | 8079 | 291 | 3 | 0 | 37.66954283 | -106.9281698 | 2022-09-21 04:23:22 | Mineral, Colorado, US | |
3571239 | 3571239 | 2022-09-19 | US | Colorado | Mineral | 8079 | 291 | 3 | 0 | 37.66954283 | -106.9281698 | 2022-09-20 04:22:48 | Mineral, Colorado, US | |
375057 | 375057 | 2022-09-13 | US | South Dakota | Campbell | 46021 | 291 | 7 | 0 | 45.77074915 | -100.0510181 | 2022-09-14 04:20:44 | Campbell, South Dakota, US | |
2397659 | 2397659 | 2022-09-12 | US | South Dakota | Campbell | 46021 | 291 | 7 | 0 | 45.77074915 | -100.0510181 | 2022-09-13 04:20:57 | Campbell, South Dakota, US | |
3768737 | 3768737 | 2022-09-11 | US | South Dakota | Campbell | 46021 | 291 | 7 | 0 | 45.77074915 | -100.0510181 | 2022-09-12 04:20:58 | Campbell, South Dakota, US | |
3827312 | 3827312 | 2022-09-10 | US | South Dakota | Campbell | 46021 | 291 | 7 | 0 | 45.77074915 | -100.0510181 | 2022-09-11 04:20:50 | Campbell, South Dakota, US | |
965769 | 965769 | 2022-09-09 | US | South Dakota | Campbell | 46021 | 291 | 7 | 0 | 45.77074915 | -100.0510181 | 2022-09-10 04:21:10 | Campbell, South Dakota, US | |
256541 | 256541 | 2022-09-08 | US | Texas | Sterling | 48431 | 291 | 9 | 0 | 31.82781912 | -101.0500746 | 2022-09-09 04:21:11 | Sterling, Texas, US | |
256171 | 256171 | 2022-09-08 | US | South Dakota | Campbell | 46021 | 291 | 7 | 0 | 45.77074915 | -100.0510181 | 2022-09-09 04:21:11 | Campbell, South Dakota, US | |
3748339 | 3748339 | 2022-09-07 | US | Texas | Sterling | 48431 | 291 | 9 | 0 | 31.82781912 | -101.0500746 | 2022-09-08 04:21:02 | Sterling, Texas, US | |
3747969 | 3747969 | 2022-09-07 | US | South Dakota | Campbell | 46021 | 291 | 7 | 0 | 45.77074915 | -100.0510181 | 2022-09-08 04:21:02 | Campbell, South Dakota, US | |
117979 | 117979 | 2022-09-06 | US | Texas | Sterling | 48431 | 291 | 9 | 0 | 31.82781912 | -101.0500746 | 2022-09-07 04:20:59 | Sterling, Texas, US | |
2636951 | 2636951 | 2022-09-05 | US | Texas | Sterling | 48431 | 291 | 9 | 0 | 31.82781912 | -101.0500746 | 2022-09-06 04:21:02 | Sterling, Texas, US | |
2990515 | 2990515 | 2022-09-04 | US | Texas | Sterling | 48431 | 291 | 9 | 0 | 31.82781912 | -101.0500746 | 2022-09-05 04:21:01 | Sterling, Texas, US | |
2716200 | 2716200 | 2022-09-03 | US | Texas | Sterling | 48431 | 291 | 9 | 0 | 31.82781912 | -101.0500746 | 2022-09-04 04:21:22 | Sterling, Texas, US | |
1396905 | 1396905 | 2022-09-02 | US | Texas | Sterling | 48431 | 291 | 9 | 0 | 31.82781912 | -101.0500746 | 2022-09-03 04:21:04 | Sterling, Texas, US | |
3550734 | 3550734 | 2022-09-01 | US | Texas | Sterling | 48431 | 291 | 9 | 0 | 31.82781912 | -101.0500746 | 2022-09-02 04:21:07 | Sterling, Texas, US | |
2346654 | 2346654 | 2022-08-31 | US | Texas | Sterling | 48431 | 291 | 9 | 0 | 31.82781912 | -101.0500746 | 2022-09-01 04:21:03 | Sterling, Texas, US | |
3777134 | 3777134 | 2022-08-30 | US | Texas | Sterling | 48431 | 291 | 9 | 0 | 31.82781912 | -101.0500746 | 2022-08-31 04:20:57 | Sterling, Texas, US | |
1683730 | 1683730 | 2022-08-29 | US | Texas | Sterling | 48431 | 291 | 9 | 0 | 31.82781912 | -101.0500746 | 2022-08-30 04:21:03 | Sterling, Texas, US | |
1066534 | 1066534 | 2022-07-28 | US | Colorado | San Juan | 8111 | 291 | 0 | 0 | 37.76248981 | -107.6763289 | 2022-07-29 04:20:45 | San Juan, Colorado, US | |
3077852 | 3077852 | 2022-07-04 | China | Hainan | 291 | 6 | 0 | 19.1959 | 109.7453 | 2022-07-05 04:20:45 | Hainan, China | |||
1767134 | 1767134 | 2022-07-03 | China | Hainan | 291 | 6 | 0 | 19.1959 | 109.7453 | 2022-07-04 04:20:54 | Hainan, China | |||
3365120 | 3365120 | 2022-07-02 | China | Hainan | 291 | 6 | 0 | 19.1959 | 109.7453 | 2022-07-03 04:20:59 | Hainan, China | |||
593449 | 593449 | 2022-07-01 | China | Hainan | 291 | 6 | 0 | 19.1959 | 109.7453 | 2022-07-02 04:21:16 | 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]);