johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
558 rows where confirmed = 978 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
220188 | 220188 | 2022-12-26 | US | New Mexico | Mora | 35033 | 978 | 22 | 0 | 36.01095101 | -104.9497716 | 2022-12-27 04:21:07 | Mora, New Mexico, US | |
3224645 | 3224645 | 2022-12-25 | US | New Mexico | Mora | 35033 | 978 | 22 | 0 | 36.01095101 | -104.9497716 | 2022-12-26 04:21:06 | Mora, New Mexico, US | |
1020559 | 1020559 | 2022-12-24 | US | New Mexico | Mora | 35033 | 978 | 22 | 0 | 36.01095101 | -104.9497716 | 2022-12-25 04:21:04 | Mora, New Mexico, US | |
692582 | 692582 | 2022-12-23 | US | New Mexico | Mora | 35033 | 978 | 22 | 0 | 36.01095101 | -104.9497716 | 2022-12-24 04:21:02 | Mora, New Mexico, US | |
2181792 | 2181792 | 2022-12-22 | US | New Mexico | Mora | 35033 | 978 | 21 | 0 | 36.01095101 | -104.9497716 | 2022-12-23 04:21:04 | Mora, New Mexico, US | |
309201 | 309201 | 2022-12-13 | US | Kansas | Logan | 20109 | 978 | 13 | 0 | 38.91735806 | -101.148475 | 2022-12-14 04:21:04 | Logan, Kansas, US | |
1150262 | 1150262 | 2022-12-12 | US | Kansas | Logan | 20109 | 978 | 13 | 0 | 38.91735806 | -101.148475 | 2022-12-13 04:21:01 | Logan, Kansas, US | |
870116 | 870116 | 2022-12-11 | US | Kansas | Logan | 20109 | 978 | 13 | 0 | 38.91735806 | -101.148475 | 2022-12-12 04:21:01 | Logan, Kansas, US | |
258646 | 258646 | 2022-12-10 | US | Kansas | Logan | 20109 | 978 | 13 | 0 | 38.91735806 | -101.148475 | 2022-12-11 04:20:50 | Logan, Kansas, US | |
3937360 | 3937360 | 2022-12-09 | US | Kansas | Logan | 20109 | 978 | 13 | 0 | 38.91735806 | -101.148475 | 2022-12-10 04:21:02 | Logan, Kansas, US | |
3378692 | 3378692 | 2022-12-08 | US | Kansas | Logan | 20109 | 978 | 13 | 0 | 38.91735806 | -101.148475 | 2022-12-09 04:21:05 | Logan, Kansas, US | |
1985963 | 1985963 | 2022-12-07 | US | Kansas | Logan | 20109 | 978 | 13 | 0 | 38.91735806 | -101.148475 | 2022-12-08 04:21:07 | Logan, Kansas, US | |
3715502 | 3715502 | 2022-12-06 | US | Kansas | Osborne | 20141 | 978 | 20 | 0 | 39.3503437 | -98.76753828 | 2022-12-07 04:20:58 | Osborne, Kansas, US | |
2416207 | 2416207 | 2022-12-05 | US | Kansas | Osborne | 20141 | 978 | 20 | 0 | 39.3503437 | -98.76753828 | 2022-12-06 04:21:03 | Osborne, Kansas, US | |
719815 | 719815 | 2022-12-04 | US | Kansas | Osborne | 20141 | 978 | 20 | 0 | 39.3503437 | -98.76753828 | 2022-12-05 04:20:58 | Osborne, Kansas, US | |
2818104 | 2818104 | 2022-12-03 | US | Kansas | Osborne | 20141 | 978 | 20 | 0 | 39.3503437 | -98.76753828 | 2022-12-04 04:20:56 | Osborne, Kansas, US | |
834960 | 834960 | 2022-12-02 | US | Kansas | Osborne | 20141 | 978 | 20 | 0 | 39.3503437 | -98.76753828 | 2022-12-03 04:21:02 | Osborne, Kansas, US | |
2137490 | 2137490 | 2022-12-01 | US | Kansas | Osborne | 20141 | 978 | 20 | 0 | 39.3503437 | -98.76753828 | 2022-12-02 04:21:07 | Osborne, Kansas, US | |
1965906 | 1965906 | 2022-11-30 | US | Kansas | Osborne | 20141 | 978 | 20 | 0 | 39.3503437 | -98.76753828 | 2022-12-01 04:21:03 | Osborne, Kansas, US | |
2769570 | 2769570 | 2022-09-26 | US | Colorado | Baca | 8009 | 978 | 15 | 0 | 37.31940883 | -102.5603223 | 2022-09-27 04:23:01 | Baca, Colorado, US | |
1977223 | 1977223 | 2022-09-25 | US | Colorado | Baca | 8009 | 978 | 15 | 0 | 37.31940883 | -102.5603223 | 2022-09-26 04:20:52 | Baca, Colorado, US | |
2650390 | 2650390 | 2022-09-24 | US | Colorado | Baca | 8009 | 978 | 15 | 0 | 37.31940883 | -102.5603223 | 2022-09-25 04:23:31 | Baca, Colorado, US | |
384830 | 384830 | 2022-09-23 | US | Colorado | Baca | 8009 | 978 | 15 | 0 | 37.31940883 | -102.5603223 | 2022-09-24 04:21:40 | Baca, Colorado, US | |
2829464 | 2829464 | 2022-08-25 | US | Colorado | Phillips | 8095 | 978 | 20 | 0 | 40.59414277 | -102.3577703 | 2022-08-26 04:21:02 | Phillips, Colorado, US | |
2323997 | 2323997 | 2022-08-24 | US | Colorado | Phillips | 8095 | 978 | 20 | 0 | 40.59414277 | -102.3577703 | 2022-08-25 04:21:13 | Phillips, Colorado, US | |
1348080 | 1348080 | 2022-08-10 | US | Minnesota | Red Lake | 27125 | 978 | 13 | 0 | 47.87197525 | -96.09561104 | 2022-08-11 04:20:49 | Red Lake, Minnesota, US | |
1087835 | 1087835 | 2022-08-09 | US | Minnesota | Red Lake | 27125 | 978 | 13 | 0 | 47.87197525 | -96.09561104 | 2022-08-10 04:20:57 | Red Lake, Minnesota, US | |
3545250 | 3545250 | 2022-08-08 | US | Minnesota | Red Lake | 27125 | 978 | 13 | 0 | 47.87197525 | -96.09561104 | 2022-08-09 04:20:34 | Red Lake, Minnesota, US | |
1071653 | 1071653 | 2022-08-07 | US | Minnesota | Red Lake | 27125 | 978 | 13 | 0 | 47.87197525 | -96.09561104 | 2022-08-08 04:21:08 | Red Lake, Minnesota, US | |
1942241 | 1942241 | 2022-08-06 | US | Minnesota | Red Lake | 27125 | 978 | 13 | 0 | 47.87197525 | -96.09561104 | 2022-08-07 04:20:54 | Red Lake, Minnesota, US | |
882040 | 882040 | 2022-08-05 | US | Minnesota | Red Lake | 27125 | 978 | 13 | 0 | 47.87197525 | -96.09561104 | 2022-08-06 04:20:56 | Red Lake, Minnesota, US | |
2010451 | 2010451 | 2022-08-04 | US | Minnesota | Red Lake | 27125 | 978 | 13 | 0 | 47.87197525 | -96.09561104 | 2022-08-05 04:20:52 | Red Lake, Minnesota, US | |
1407913 | 1407913 | 2022-08-02 | US | South Dakota | Edmunds | 46045 | 978 | 16 | 0 | 45.41846445 | -99.21545423 | 2022-08-03 04:20:59 | Edmunds, South Dakota, US | |
1405841 | 1405841 | 2022-08-02 | US | Georgia | Echols | 13101 | 978 | 12 | 0 | 30.71101099 | -82.89687287 | 2022-08-03 04:20:59 | Echols, Georgia, US | |
3619951 | 3619951 | 2022-08-01 | US | South Dakota | Edmunds | 46045 | 978 | 16 | 0 | 45.41846445 | -99.21545423 | 2022-08-02 04:20:53 | Edmunds, South Dakota, US | |
3617879 | 3617879 | 2022-08-01 | US | Georgia | Echols | 13101 | 978 | 12 | 0 | 30.71101099 | -82.89687287 | 2022-08-02 04:20:53 | Echols, Georgia, US | |
3874431 | 3874431 | 2022-07-31 | US | South Dakota | Edmunds | 46045 | 978 | 16 | 0 | 45.41846445 | -99.21545423 | 2022-08-01 04:21:03 | Edmunds, South Dakota, US | |
3872359 | 3872359 | 2022-07-31 | US | Georgia | Echols | 13101 | 978 | 12 | 0 | 30.71101099 | -82.89687287 | 2022-08-01 04:21:03 | Echols, Georgia, US | |
677185 | 677185 | 2022-07-30 | US | South Dakota | Edmunds | 46045 | 978 | 16 | 0 | 45.41846445 | -99.21545423 | 2022-07-31 04:21:02 | Edmunds, South Dakota, US | |
675113 | 675113 | 2022-07-30 | US | Georgia | Echols | 13101 | 978 | 12 | 0 | 30.71101099 | -82.89687287 | 2022-07-31 04:21:02 | Echols, Georgia, US | |
1786384 | 1786384 | 2022-07-29 | US | South Dakota | Edmunds | 46045 | 978 | 16 | 0 | 45.41846445 | -99.21545423 | 2022-07-30 04:20:42 | Edmunds, South Dakota, US | |
1784312 | 1784312 | 2022-07-29 | US | Georgia | Echols | 13101 | 978 | 12 | 0 | 30.71101099 | -82.89687287 | 2022-07-30 04:20:42 | Echols, Georgia, US | |
1068747 | 1068747 | 2022-07-28 | US | South Dakota | Edmunds | 46045 | 978 | 16 | 0 | 45.41846445 | -99.21545423 | 2022-07-29 04:20:45 | Edmunds, South Dakota, US | |
1066675 | 1066675 | 2022-07-28 | US | Georgia | Echols | 13101 | 978 | 12 | 0 | 30.71101099 | -82.89687287 | 2022-07-29 04:20:45 | Echols, Georgia, US | |
2338266 | 2338266 | 2022-07-27 | US | South Dakota | Edmunds | 46045 | 978 | 16 | 0 | 45.41846445 | -99.21545423 | 2022-07-28 04:20:56 | Edmunds, South Dakota, US | |
2336194 | 2336194 | 2022-07-27 | US | Georgia | Echols | 13101 | 978 | 12 | 0 | 30.71101099 | -82.89687287 | 2022-07-28 04:20:56 | Echols, Georgia, US | |
3408764 | 3408764 | 2022-07-17 | US | Virginia | Bath | 51017 | 978 | 20 | 0 | 38.05852573 | -79.73912095 | 2022-07-18 04:20:59 | Bath, Virginia, US | |
2154964 | 2154964 | 2022-07-16 | US | Virginia | Bath | 51017 | 978 | 20 | 0 | 38.05852573 | -79.73912095 | 2022-07-17 04:21:15 | Bath, Virginia, US | |
2422197 | 2422197 | 2022-07-15 | US | Virginia | Bath | 51017 | 978 | 20 | 0 | 38.05852573 | -79.73912095 | 2022-07-16 04:21:05 | Bath, Virginia, US | |
631208 | 631208 | 2022-07-12 | US | Kansas | Haskell | 20081 | 978 | 12 | 0 | 37.5620394 | -100.8710738 | 2022-07-13 04:20:58 | Haskell, Kansas, US | |
630829 | 630829 | 2022-07-12 | US | Idaho | Bear Lake | 16007 | 978 | 16 | 0 | 42.28269683 | -111.3289238 | 2022-07-13 04:20:58 | Bear Lake, Idaho, US | |
1212852 | 1212852 | 2022-07-11 | US | Kansas | Haskell | 20081 | 978 | 12 | 0 | 37.5620394 | -100.8710738 | 2022-07-12 04:20:51 | Haskell, Kansas, US | |
1212473 | 1212473 | 2022-07-11 | US | Idaho | Bear Lake | 16007 | 978 | 16 | 0 | 42.28269683 | -111.3289238 | 2022-07-12 04:20:51 | Bear Lake, Idaho, US | |
2790334 | 2790334 | 2022-07-10 | US | Kansas | Haskell | 20081 | 978 | 12 | 0 | 37.5620394 | -100.8710738 | 2022-07-11 04:20:46 | Haskell, Kansas, US | |
143287 | 143287 | 2022-07-09 | US | Kansas | Haskell | 20081 | 978 | 12 | 0 | 37.5620394 | -100.8710738 | 2022-07-10 04:20:54 | Haskell, Kansas, US | |
1418387 | 1418387 | 2022-07-08 | US | Kansas | Haskell | 20081 | 978 | 12 | 0 | 37.5620394 | -100.8710738 | 2022-07-09 04:20:59 | Haskell, Kansas, US | |
2742312 | 2742312 | 2022-07-07 | US | Kansas | Haskell | 20081 | 978 | 12 | 0 | 37.5620394 | -100.8710738 | 2022-07-08 04:20:56 | Haskell, Kansas, US | |
1201107 | 1201107 | 2022-07-06 | US | Kansas | Haskell | 20081 | 978 | 12 | 0 | 37.5620394 | -100.8710738 | 2022-07-07 04:20:55 | Haskell, Kansas, US | |
3269983 | 3269983 | 2022-06-19 | US | Arkansas | Calhoun | 5013 | 978 | 11 | 0 | 33.55598792 | -92.49974403 | 2022-06-20 04:21:01 | Calhoun, Arkansas, US | |
3397895 | 3397895 | 2022-06-18 | US | Arkansas | Calhoun | 5013 | 978 | 11 | 0 | 33.55598792 | -92.49974403 | 2022-06-19 04:20:51 | Calhoun, Arkansas, US | |
2236422 | 2236422 | 2022-06-12 | US | Illinois | Pope | 17151 | 978 | 8 | 0 | 37.41391284 | -88.56152109 | 2022-06-13 04:21:14 | Pope, Illinois, US | |
3142620 | 3142620 | 2022-06-11 | US | Illinois | Pope | 17151 | 978 | 8 | 0 | 37.41391284 | -88.56152109 | 2022-06-12 04:20:53 | Pope, Illinois, US | |
1945536 | 1945536 | 2022-06-10 | US | Illinois | Pope | 17151 | 978 | 8 | 0 | 37.41391284 | -88.56152109 | 2022-06-11 04:21:01 | Pope, Illinois, US | |
1574509 | 1574509 | 2022-05-03 | US | North Carolina | Tyrrell | 37177 | 978 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-05-04 04:20:59 | Tyrrell, North Carolina, US | |
466596 | 466596 | 2022-05-02 | US | Texas | Presidio | 48377 | 978 | 38 | 0 | 29.99954402 | -104.2408079 | 2022-05-03 04:21:00 | Presidio, Texas, US | |
465769 | 465769 | 2022-05-02 | US | North Carolina | Tyrrell | 37177 | 978 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-05-03 04:21:00 | Tyrrell, North Carolina, US | |
3919235 | 3919235 | 2022-05-01 | US | Texas | Presidio | 48377 | 978 | 38 | 0 | 29.99954402 | -104.2408079 | 2022-05-02 04:21:10 | Presidio, Texas, US | |
3918408 | 3918408 | 2022-05-01 | US | North Carolina | Tyrrell | 37177 | 978 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-05-02 04:21:10 | Tyrrell, North Carolina, US | |
2844039 | 2844039 | 2022-04-30 | US | Texas | Presidio | 48377 | 978 | 38 | 0 | 29.99954402 | -104.2408079 | 2022-05-01 04:20:57 | Presidio, Texas, US | |
2843212 | 2843212 | 2022-04-30 | US | North Carolina | Tyrrell | 37177 | 978 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-05-01 04:20:57 | Tyrrell, North Carolina, US | |
1160352 | 1160352 | 2022-04-29 | US | Texas | Presidio | 48377 | 978 | 38 | 0 | 29.99954402 | -104.2408079 | 2022-04-30 04:21:05 | Presidio, Texas, US | |
1159525 | 1159525 | 2022-04-29 | US | North Carolina | Tyrrell | 37177 | 978 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-04-30 04:21:05 | Tyrrell, North Carolina, US | |
1159258 | 1159258 | 2022-04-29 | US | Nebraska | Nuckolls | 31129 | 978 | 13 | 0 | 40.17637905 | -98.04743961 | 2022-04-30 04:21:05 | Nuckolls, Nebraska, US | |
1699534 | 1699534 | 2022-04-28 | US | Texas | Presidio | 48377 | 978 | 38 | 0 | 29.99954402 | -104.2408079 | 2022-04-29 04:20:59 | Presidio, Texas, US | |
1698707 | 1698707 | 2022-04-28 | US | North Carolina | Tyrrell | 37177 | 978 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-04-29 04:20:59 | Tyrrell, North Carolina, US | |
1698440 | 1698440 | 2022-04-28 | US | Nebraska | Nuckolls | 31129 | 978 | 13 | 0 | 40.17637905 | -98.04743961 | 2022-04-29 04:20:59 | Nuckolls, Nebraska, US | |
3855017 | 3855017 | 2022-04-27 | US | Texas | Presidio | 48377 | 978 | 38 | 0 | 29.99954402 | -104.2408079 | 2022-04-28 04:20:47 | Presidio, Texas, US | |
3854190 | 3854190 | 2022-04-27 | US | North Carolina | Tyrrell | 37177 | 978 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-04-28 04:20:47 | Tyrrell, North Carolina, US | |
3853923 | 3853923 | 2022-04-27 | US | Nebraska | Nuckolls | 31129 | 978 | 13 | 0 | 40.17637905 | -98.04743961 | 2022-04-28 04:20:47 | Nuckolls, Nebraska, US | |
1329447 | 1329447 | 2022-04-26 | US | Texas | Presidio | 48377 | 978 | 38 | 0 | 29.99954402 | -104.24080790000001 | 2022-04-27 04:20:52 | Presidio, Texas, US | |
1328353 | 1328353 | 2022-04-26 | US | Nebraska | Nuckolls | 31129 | 978 | 13 | 0 | 40.17637905 | -98.04743961 | 2022-04-27 04:20:52 | Nuckolls, Nebraska, US | |
3725401 | 3725401 | 2022-04-25 | US | Texas | Presidio | 48377 | 978 | 38 | 0 | 29.99954402 | -104.24080790000001 | 2022-04-26 04:20:51 | Presidio, Texas, US | |
2444676 | 2444676 | 2022-04-13 | US | Missouri | Knox | 29103 | 978 | 13 | 0 | 40.12699751 | -92.14780832 | 2022-04-13 23:21:06 | Knox, Missouri, US | |
1950433 | 1950433 | 2022-04-12 | US | Missouri | Knox | 29103 | 978 | 13 | 0 | 40.12699751 | -92.14780832 | 2022-04-13 04:21:03 | Knox, Missouri, US | |
3208186 | 3208186 | 2022-04-11 | US | Missouri | Knox | 29103 | 978 | 13 | 0 | 40.12699751 | -92.14780832 | 2022-04-12 04:20:49 | Knox, Missouri, US | |
1578072 | 1578072 | 2022-04-10 | US | Missouri | Knox | 29103 | 978 | 13 | 0 | 40.12699751 | -92.14780832 | 2022-04-11 04:21:02 | Knox, Missouri, US | |
1654314 | 1654314 | 2022-04-09 | US | Missouri | Knox | 29103 | 978 | 13 | 0 | 40.12699751 | -92.14780832 | 2022-04-10 04:20:52 | Knox, Missouri, US | |
2117636 | 2117636 | 2022-04-08 | US | Missouri | Knox | 29103 | 978 | 13 | 0 | 40.12699751 | -92.14780832 | 2022-04-09 04:20:42 | Knox, Missouri, US | |
3322160 | 3322160 | 2022-04-07 | US | Missouri | Knox | 29103 | 978 | 13 | 0 | 40.12699751 | -92.14780832 | 2022-04-08 04:20:48 | Knox, Missouri, US | |
3731776 | 3731776 | 2022-04-03 | US | Louisiana | Unassigned | 90022 | 978 | 0 | 0 | 32.83121059 | 0.0 | 2022-04-04 04:20:51 | Unassigned, Louisiana, US | |
501211 | 501211 | 2022-04-02 | US | Louisiana | Unassigned | 90022 | 978 | 0 | 0 | 32.83121059 | 0.0 | 2022-04-03 04:20:48 | Unassigned, Louisiana, US | |
3352196 | 3352196 | 2022-04-01 | US | Louisiana | Unassigned | 90022 | 978 | 0 | 0 | 32.83121059 | 0.0 | 2022-04-02 04:20:47 | Unassigned, Louisiana, US | |
1541501 | 1541501 | 2022-03-31 | US | Louisiana | Unassigned | 90022 | 978 | 0 | 0 | 32.83121059 | 0.0 | 2022-04-01 04:20:28 | Unassigned, Louisiana, US | |
2479514 | 2479514 | 2022-03-30 | US | Louisiana | Unassigned | 90022 | 978 | 0 | 0 | 32.83121059 | 0.0 | 2022-03-31 04:20:56 | Unassigned, Louisiana, US | |
159555 | 159555 | 2022-03-29 | US | Louisiana | Unassigned | 90022 | 978 | 0 | 0 | 32.83121059 | 0.0 | 2022-03-30 04:20:45 | Unassigned, Louisiana, US | |
1438126 | 1438126 | 2022-03-28 | US | Louisiana | Unassigned | 90022 | 978 | 0 | 0 | 32.83121059 | 0.0 | 2022-03-29 04:20:46 | Unassigned, Louisiana, US | |
877807 | 877807 | 2022-03-27 | US | Louisiana | Unassigned | 90022 | 978 | 0 | 0 | 32.83121059 | 0.0 | 2022-03-28 04:20:33 | Unassigned, Louisiana, US | |
2165090 | 2165090 | 2022-03-26 | US | Louisiana | Unassigned | 90022 | 978 | 0 | 0 | 32.83121059 | 0.0 | 2022-03-27 04:20:47 | Unassigned, Louisiana, US | |
1722026 | 1722026 | 2022-03-25 | US | Louisiana | Unassigned | 90022 | 978 | 0 | 0 | 32.83121059 | 0.0 | 2022-03-26 04:20:23 | Unassigned, Louisiana, US | |
1469777 | 1469777 | 2022-03-24 | US | Michigan | Ontonagon | 26131 | 978 | 38 | 0 | 46.665226200000006 | -89.31390481 | 2022-03-25 04:20:46 | Ontonagon, Michigan, US |
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]);