johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
453 rows where confirmed = 1514 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1074960 | 1074960 | 2022-12-28 | US | Illinois | Scott | 17171 | 1514 | 14 | 0 | 39.6429169 | -90.47814431 | 2022-12-29 04:21:01 | Scott, Illinois, US | |
452438 | 452438 | 2022-12-21 | US | Illinois | Scott | 17171 | 1514 | 14 | 0 | 39.6429169 | -90.47814431 | 2022-12-22 04:20:56 | Scott, Illinois, US | |
351685 | 351685 | 2022-12-14 | US | Virginia | Norton | 51720 | 1514 | 20 | 0 | 36.93357076 | -82.62750411 | 2022-12-15 04:20:58 | Norton, Virginia, US | |
311273 | 311273 | 2022-12-13 | US | Virginia | Norton | 51720 | 1514 | 20 | 0 | 36.93357076 | -82.62750411 | 2022-12-14 04:21:04 | Norton, Virginia, US | |
1152334 | 1152334 | 2022-12-12 | US | Virginia | Norton | 51720 | 1514 | 20 | 0 | 36.93357076 | -82.62750411 | 2022-12-13 04:21:01 | Norton, Virginia, US | |
2442349 | 2442349 | 2022-11-07 | US | Wyoming | Crook | 56011 | 1514 | 30 | 0 | 44.58855102 | -104.5697705 | 2022-11-08 04:21:21 | Crook, Wyoming, US | |
2441154 | 2441154 | 2022-11-07 | US | North Dakota | McHenry | 38049 | 1514 | 31 | 0 | 48.23104458 | -100.6324822 | 2022-11-08 04:21:21 | McHenry, North Dakota, US | |
1053447 | 1053447 | 2022-11-06 | US | Wyoming | Crook | 56011 | 1514 | 30 | 0 | 44.58855102 | -104.5697705 | 2022-11-07 04:21:26 | Crook, Wyoming, US | |
621471 | 621471 | 2022-11-05 | US | Wyoming | Crook | 56011 | 1514 | 30 | 0 | 44.58855102 | -104.5697705 | 2022-11-06 04:21:24 | Crook, Wyoming, US | |
1025975 | 1025975 | 2022-11-04 | US | Wyoming | Crook | 56011 | 1514 | 30 | 0 | 44.58855102 | -104.5697705 | 2022-11-05 04:21:52 | Crook, Wyoming, US | |
434966 | 434966 | 2022-11-03 | US | Wyoming | Crook | 56011 | 1514 | 30 | 0 | 44.58855102 | -104.5697705 | 2022-11-04 04:22:11 | Crook, Wyoming, US | |
853208 | 853208 | 2022-11-02 | US | Wyoming | Crook | 56011 | 1514 | 30 | 0 | 44.58855102 | -104.5697705 | 2022-11-03 04:22:05 | Crook, Wyoming, US | |
714059 | 714059 | 2022-11-01 | US | Wyoming | Crook | 56011 | 1514 | 30 | 0 | 44.58855102 | -104.5697705 | 2022-11-02 04:22:09 | Crook, Wyoming, US | |
1591990 | 1591990 | 2022-10-21 | China | Anhui | 1514 | 6 | 0 | 31.8257 | 117.2264 | 2022-10-22 04:22:53 | Anhui, China | |||
2271706 | 2271706 | 2022-10-20 | China | Anhui | 1514 | 6 | 0 | 31.8257 | 117.2264 | 2022-10-21 04:22:23 | Anhui, China | |||
198041 | 198041 | 2022-10-19 | China | Anhui | 1514 | 6 | 0 | 31.8257 | 117.2264 | 2022-10-20 04:22:59 | Anhui, China | |||
2756702 | 2756702 | 2022-10-18 | China | Anhui | 1514 | 6 | 0 | 31.8257 | 117.2264 | 2022-10-19 04:22:26 | Anhui, China | |||
2024536 | 2024536 | 2022-10-17 | China | Anhui | 1514 | 6 | 0 | 31.8257 | 117.2264 | 2022-10-18 04:22:42 | Anhui, China | |||
2159314 | 2159314 | 2022-10-16 | China | Anhui | 1514 | 6 | 0 | 31.8257 | 117.2264 | 2022-10-17 04:20:31 | Anhui, China | |||
3776815 | 3776815 | 2022-08-30 | US | South Dakota | Tripp | 46123 | 1514 | 26 | 0 | 43.34459388 | -99.8854891 | 2022-08-31 04:20:57 | Tripp, South Dakota, US | |
1683411 | 1683411 | 2022-08-29 | US | South Dakota | Tripp | 46123 | 1514 | 26 | 0 | 43.34459388 | -99.8854891 | 2022-08-30 04:21:03 | Tripp, South Dakota, US | |
1879895 | 1879895 | 2022-08-28 | US | South Dakota | Tripp | 46123 | 1514 | 26 | 0 | 43.34459388 | -99.8854891 | 2022-08-29 04:21:06 | Tripp, South Dakota, US | |
2099022 | 2099022 | 2022-08-27 | US | South Dakota | Tripp | 46123 | 1514 | 26 | 0 | 43.34459388 | -99.8854891 | 2022-08-28 04:21:02 | Tripp, South Dakota, US | |
1534837 | 1534837 | 2022-08-26 | US | South Dakota | Tripp | 46123 | 1514 | 26 | 0 | 43.34459388 | -99.8854891 | 2022-08-27 04:20:57 | Tripp, South Dakota, US | |
2831724 | 2831724 | 2022-08-25 | US | South Dakota | Tripp | 46123 | 1514 | 26 | 0 | 43.34459388 | -99.8854891 | 2022-08-26 04:21:02 | Tripp, South Dakota, US | |
2326257 | 2326257 | 2022-08-24 | US | South Dakota | Tripp | 46123 | 1514 | 26 | 0 | 43.34459388 | -99.8854891 | 2022-08-25 04:21:13 | Tripp, South Dakota, US | |
2406012 | 2406012 | 2022-08-21 | US | Texas | Mills | 48333 | 1514 | 37 | 0 | 31.49557106 | -98.59272068 | 2022-08-22 04:20:38 | Mills, Texas, US | |
3801090 | 3801090 | 2022-08-20 | US | Texas | Mills | 48333 | 1514 | 37 | 0 | 31.49557106 | -98.59272068 | 2022-08-21 04:20:44 | Mills, Texas, US | |
2366676 | 2366676 | 2022-08-19 | US | Texas | Mills | 48333 | 1514 | 37 | 0 | 31.49557106 | -98.59272068 | 2022-08-20 04:21:01 | Mills, Texas, US | |
1164347 | 1164347 | 2022-08-18 | US | Texas | Mills | 48333 | 1514 | 37 | 0 | 31.49557106 | -98.59272068 | 2022-08-19 04:20:54 | Mills, Texas, US | |
2891189 | 2891189 | 2022-08-12 | US | Puerto Rico | Vieques | 72147 | 1514 | 0 | 0 | 18.123276 | -65.440971 | 2022-08-13 04:20:52 | Vieques, Puerto Rico, US | |
3909874 | 3909874 | 2022-08-11 | US | Missouri | Atchison | 29005 | 1514 | 23 | 0 | 40.43238737 | -95.42970639 | 2022-08-12 04:20:54 | Atchison, Missouri, US | |
1348191 | 1348191 | 2022-08-10 | US | Missouri | Atchison | 29005 | 1514 | 23 | 0 | 40.43238737 | -95.42970639 | 2022-08-11 04:20:49 | Atchison, Missouri, US | |
1087946 | 1087946 | 2022-08-09 | US | Missouri | Atchison | 29005 | 1514 | 23 | 0 | 40.43238737 | -95.42970639 | 2022-08-10 04:20:57 | Atchison, Missouri, US | |
3545361 | 3545361 | 2022-08-08 | US | Missouri | Atchison | 29005 | 1514 | 23 | 0 | 40.43238737 | -95.42970639 | 2022-08-09 04:20:34 | Atchison, Missouri, US | |
1071764 | 1071764 | 2022-08-07 | US | Missouri | Atchison | 29005 | 1514 | 23 | 0 | 40.43238737 | -95.42970639 | 2022-08-08 04:21:08 | Atchison, Missouri, US | |
1942352 | 1942352 | 2022-08-06 | US | Missouri | Atchison | 29005 | 1514 | 23 | 0 | 40.43238737 | -95.42970639 | 2022-08-07 04:20:54 | Atchison, Missouri, US | |
882151 | 882151 | 2022-08-05 | US | Missouri | Atchison | 29005 | 1514 | 23 | 0 | 40.43238737 | -95.42970639 | 2022-08-06 04:20:56 | Atchison, Missouri, US | |
3213608 | 3213608 | 2022-07-18 | US | Virginia | Covington | 51580 | 1514 | 28 | 0 | 37.7824656 | -79.98631446 | 2022-07-19 04:20:58 | Covington, Virginia, US | |
2744537 | 2744537 | 2022-07-07 | US | West Virginia | Wirt | 54105 | 1514 | 25 | 0 | 39.02775007 | -81.37473928 | 2022-07-08 04:20:56 | Wirt, West Virginia, US | |
2742909 | 2742909 | 2022-07-07 | US | Missouri | Dade | 29057 | 1514 | 43 | 0 | 37.431814 | -93.8503345 | 2022-07-08 04:20:56 | Dade, Missouri, US | |
1201704 | 1201704 | 2022-07-06 | US | Missouri | Dade | 29057 | 1514 | 43 | 0 | 37.431814 | -93.8503345 | 2022-07-07 04:20:55 | Dade, Missouri, US | |
3968447 | 3968447 | 2022-07-05 | US | Missouri | Dade | 29057 | 1514 | 43 | 0 | 37.431814 | -93.8503345 | 2022-07-06 04:20:58 | Dade, Missouri, US | |
3079958 | 3079958 | 2022-07-04 | US | Missouri | Dade | 29057 | 1514 | 43 | 0 | 37.431814 | -93.8503345 | 2022-07-05 04:20:45 | Dade, Missouri, US | |
3079431 | 3079431 | 2022-07-04 | US | Kentucky | Ballard | 21007 | 1514 | 31 | 0 | 37.05842757 | -88.99427697 | 2022-07-05 04:20:45 | Ballard, Kentucky, US | |
1769240 | 1769240 | 2022-07-03 | US | Missouri | Dade | 29057 | 1514 | 43 | 0 | 37.431814 | -93.8503345 | 2022-07-04 04:20:54 | Dade, Missouri, US | |
1768713 | 1768713 | 2022-07-03 | US | Kentucky | Ballard | 21007 | 1514 | 31 | 0 | 37.05842757 | -88.99427697 | 2022-07-04 04:20:54 | Ballard, Kentucky, US | |
3367226 | 3367226 | 2022-07-02 | US | Missouri | Dade | 29057 | 1514 | 43 | 0 | 37.431814 | -93.8503345 | 2022-07-03 04:20:59 | Dade, Missouri, US | |
3366699 | 3366699 | 2022-07-02 | US | Kentucky | Ballard | 21007 | 1514 | 31 | 0 | 37.05842757 | -88.99427697 | 2022-07-03 04:20:59 | Ballard, Kentucky, US | |
595555 | 595555 | 2022-07-01 | US | Missouri | Dade | 29057 | 1514 | 43 | 0 | 37.431814 | -93.8503345 | 2022-07-02 04:21:16 | Dade, Missouri, US | |
595028 | 595028 | 2022-07-01 | US | Kentucky | Ballard | 21007 | 1514 | 31 | 0 | 37.05842757 | -88.99427697 | 2022-07-02 04:21:16 | Ballard, Kentucky, US | |
3941429 | 3941429 | 2022-06-30 | US | Kentucky | Ballard | 21007 | 1514 | 31 | 0 | 37.05842757 | -88.99427697 | 2022-07-01 04:21:10 | Ballard, Kentucky, US | |
2491387 | 2491387 | 2022-06-29 | US | Kentucky | Ballard | 21007 | 1514 | 31 | 0 | 37.05842757 | -88.99427697 | 2022-06-30 04:21:01 | Ballard, Kentucky, US | |
2240769 | 2240769 | 2022-06-28 | US | Kentucky | Ballard | 21007 | 1514 | 31 | 0 | 37.05842757 | -88.99427697 | 2022-06-29 04:20:59 | Ballard, Kentucky, US | |
2149011 | 2149011 | 2022-06-27 | US | Kentucky | Ballard | 21007 | 1514 | 31 | 0 | 37.05842757 | -88.99427697 | 2022-06-28 04:20:58 | Ballard, Kentucky, US | |
1763955 | 1763955 | 2022-06-20 | US | Colorado | Huerfano | 8055 | 1514 | 36 | 0 | 37.68473101 | -104.9612585 | 2022-06-21 04:20:56 | Huerfano, Colorado, US | |
559399 | 559399 | 2022-06-16 | US | California | Trinity | 6105 | 1514 | 20 | 0 | 40.6491767 | -123.114713 | 2022-06-17 04:20:56 | Trinity, California, US | |
950402 | 950402 | 2022-06-14 | US | Wisconsin | Iron | 55051 | 1514 | 48 | 0 | 46.26302338 | -90.24295041 | 2022-06-15 04:20:54 | Iron, Wisconsin, US | |
3509205 | 3509205 | 2022-06-05 | US | Mississippi | Jefferson | 28063 | 1514 | 37 | 0 | 31.73397872 | -91.03764977 | 2022-06-06 04:20:57 | Jefferson, Mississippi, US | |
3529282 | 3529282 | 2022-06-04 | US | Mississippi | Jefferson | 28063 | 1514 | 37 | 0 | 31.73397872 | -91.03764977 | 2022-06-05 04:20:55 | Jefferson, Mississippi, US | |
3135368 | 3135368 | 2022-06-03 | US | Mississippi | Jefferson | 28063 | 1514 | 37 | 0 | 31.73397872 | -91.03764977 | 2022-06-04 04:20:58 | Jefferson, Mississippi, US | |
3580443 | 3580443 | 2022-06-02 | US | Mississippi | Jefferson | 28063 | 1514 | 37 | 0 | 31.73397872 | -91.03764977 | 2022-06-03 04:20:58 | Jefferson, Mississippi, US | |
972736 | 972736 | 2022-06-01 | US | Mississippi | Jefferson | 28063 | 1514 | 37 | 0 | 31.73397872 | -91.03764977 | 2022-06-02 05:20:39 | Jefferson, Mississippi, US | |
231043 | 231043 | 2022-05-31 | US | Mississippi | Jefferson | 28063 | 1514 | 37 | 0 | 31.73397872 | -91.03764977 | 2022-06-01 04:20:55 | Jefferson, Mississippi, US | |
230549 | 230549 | 2022-05-31 | US | Kansas | Morris | 20127 | 1514 | 30 | 0 | 38.68827511 | -96.65128437 | 2022-06-01 04:20:55 | Morris, Kansas, US | |
3187808 | 3187808 | 2022-05-30 | US | Mississippi | Jefferson | 28063 | 1514 | 37 | 0 | 31.73397872 | -91.03764977 | 2022-05-31 04:20:51 | Jefferson, Mississippi, US | |
3187314 | 3187314 | 2022-05-30 | US | Kansas | Morris | 20127 | 1514 | 30 | 0 | 38.68827511 | -96.65128437 | 2022-05-31 04:20:51 | Morris, Kansas, US | |
3199957 | 3199957 | 2022-05-29 | US | Mississippi | Jefferson | 28063 | 1514 | 37 | 0 | 31.73397872 | -91.03764977 | 2022-05-30 04:20:50 | Jefferson, Mississippi, US | |
3199463 | 3199463 | 2022-05-29 | US | Kansas | Morris | 20127 | 1514 | 30 | 0 | 38.68827511 | -96.65128437 | 2022-05-30 04:20:50 | Morris, Kansas, US | |
2726835 | 2726835 | 2022-05-28 | US | Mississippi | Jefferson | 28063 | 1514 | 37 | 0 | 31.73397872 | -91.03764977 | 2022-05-29 04:20:53 | Jefferson, Mississippi, US | |
2726341 | 2726341 | 2022-05-28 | US | Kansas | Morris | 20127 | 1514 | 30 | 0 | 38.68827511 | -96.65128437 | 2022-05-29 04:20:53 | Morris, Kansas, US | |
1316259 | 1316259 | 2022-05-27 | US | Nebraska | Clay | 31035 | 1514 | 24 | 0 | 40.52439441 | -98.05126296 | 2022-05-28 04:21:07 | Clay, Nebraska, US | |
1316016 | 1316016 | 2022-05-27 | US | Mississippi | Jefferson | 28063 | 1514 | 37 | 0 | 31.73397872 | -91.03764977 | 2022-05-28 04:21:07 | Jefferson, Mississippi, US | |
1315522 | 1315522 | 2022-05-27 | US | Kansas | Morris | 20127 | 1514 | 30 | 0 | 38.68827511 | -96.65128437 | 2022-05-28 04:21:07 | Morris, Kansas, US | |
1852051 | 1852051 | 2022-05-26 | US | Nebraska | Clay | 31035 | 1514 | 24 | 0 | 40.52439441 | -98.05126296 | 2022-05-27 04:20:56 | Clay, Nebraska, US | |
1851808 | 1851808 | 2022-05-26 | US | Mississippi | Jefferson | 28063 | 1514 | 37 | 0 | 31.73397872 | -91.03764977 | 2022-05-27 04:20:56 | Jefferson, Mississippi, US | |
1851314 | 1851314 | 2022-05-26 | US | Kansas | Morris | 20127 | 1514 | 30 | 0 | 38.68827511 | -96.65128437 | 2022-05-27 04:20:56 | Morris, Kansas, US | |
2049927 | 2049927 | 2022-05-25 | US | Nebraska | Clay | 31035 | 1514 | 24 | 0 | 40.52439441 | -98.05126296 | 2022-05-26 04:20:50 | Clay, Nebraska, US | |
2049684 | 2049684 | 2022-05-25 | US | Mississippi | Jefferson | 28063 | 1514 | 37 | 0 | 31.73397872 | -91.03764977 | 2022-05-26 04:20:50 | Jefferson, Mississippi, US | |
2049190 | 2049190 | 2022-05-25 | US | Kansas | Morris | 20127 | 1514 | 30 | 0 | 38.68827511 | -96.65128437 | 2022-05-26 04:20:50 | Morris, Kansas, US | |
3001122 | 3001122 | 2022-05-24 | US | Mississippi | Jefferson | 28063 | 1514 | 37 | 0 | 31.73397872 | -91.03764977 | 2022-05-25 04:20:56 | Jefferson, Mississippi, US | |
3000656 | 3000656 | 2022-05-24 | US | Kansas | Sherman | 20181 | 1514 | 22 | 0 | 39.35147699 | -101.7197624 | 2022-05-25 04:20:56 | Sherman, Kansas, US | |
3594843 | 3594843 | 2022-05-23 | US | Mississippi | Jefferson | 28063 | 1514 | 37 | 0 | 31.73397872 | -91.03764977 | 2022-05-24 04:20:57 | Jefferson, Mississippi, US | |
3594377 | 3594377 | 2022-05-23 | US | Kansas | Sherman | 20181 | 1514 | 22 | 0 | 39.35147699 | -101.7197624 | 2022-05-24 04:20:57 | Sherman, Kansas, US | |
623938 | 623938 | 2022-05-22 | US | Nebraska | Clay | 31035 | 1514 | 24 | 0 | 40.52439441 | -98.05126296 | 2022-05-26 04:20:50 | Clay, Nebraska, US | |
623695 | 623695 | 2022-05-22 | US | Mississippi | Jefferson | 28063 | 1514 | 37 | 0 | 31.73397872 | -91.03764977 | 2022-05-26 04:20:50 | Jefferson, Mississippi, US | |
623201 | 623201 | 2022-05-22 | US | Kansas | Morris | 20127 | 1514 | 30 | 0 | 38.68827511 | -96.65128437 | 2022-05-26 04:20:50 | Morris, Kansas, US | |
1110925 | 1110925 | 2022-05-21 | US | Kansas | Sherman | 20181 | 1514 | 22 | 0 | 39.35147699 | -101.7197624 | 2022-05-22 04:20:52 | Sherman, Kansas, US | |
1170549 | 1170549 | 2022-05-20 | US | Kansas | Sherman | 20181 | 1514 | 22 | 0 | 39.35147699 | -101.7197624 | 2022-05-21 04:20:58 | Sherman, Kansas, US | |
3897312 | 3897312 | 2022-05-19 | US | Kansas | Sherman | 20181 | 1514 | 22 | 0 | 39.35147699 | -101.7197624 | 2022-05-20 04:20:57 | Sherman, Kansas, US | |
1186096 | 1186096 | 2022-05-18 | US | Kansas | Sherman | 20181 | 1514 | 22 | 0 | 39.35147699 | -101.7197624 | 2022-05-19 04:20:54 | Sherman, Kansas, US | |
3583993 | 3583993 | 2022-05-17 | US | Kansas | Sherman | 20181 | 1514 | 22 | 0 | 39.35147699 | -101.7197624 | 2022-05-18 04:20:50 | Sherman, Kansas, US | |
1504950 | 1504950 | 2022-05-16 | US | Kansas | Sherman | 20181 | 1514 | 22 | 0 | 39.35147699 | -101.7197624 | 2022-05-17 04:20:59 | Sherman, Kansas, US | |
2085309 | 2085309 | 2022-05-15 | US | Kansas | Sherman | 20181 | 1514 | 22 | 0 | 39.35147699 | -101.7197624 | 2022-05-16 04:20:47 | Sherman, Kansas, US | |
3356019 | 3356019 | 2022-05-14 | US | Kansas | Sherman | 20181 | 1514 | 22 | 0 | 39.35147699 | -101.7197624 | 2022-05-15 04:20:53 | Sherman, Kansas, US | |
659664 | 659664 | 2022-05-13 | US | Kansas | Sherman | 20181 | 1514 | 22 | 0 | 39.35147699 | -101.7197624 | 2022-05-14 04:20:48 | Sherman, Kansas, US | |
1575596 | 1575596 | 2022-05-03 | US | Washington | Skamania | 53059 | 1514 | 13 | 0 | 46.02408726 | -121.9164403 | 2022-05-04 04:20:59 | Skamania, Washington, US | |
1575266 | 1575266 | 2022-05-03 | US | Texas | Jack | 48237 | 1514 | 28 | 0 | 33.23377248 | -98.17283469 | 2022-05-04 04:20:59 | Jack, Texas, US | |
466856 | 466856 | 2022-05-02 | US | Washington | Skamania | 53059 | 1514 | 13 | 0 | 46.02408726 | -121.9164403 | 2022-05-03 04:21:00 | Skamania, Washington, US | |
466526 | 466526 | 2022-05-02 | US | Texas | Jack | 48237 | 1514 | 28 | 0 | 33.23377248 | -98.17283469 | 2022-05-03 04:21:00 | Jack, Texas, 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]);