johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
127 rows where confirmed = 5898 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
453116 | 453116 | 2022-12-21 | US | Minnesota | Hubbard | 27057 | 5898 | 67 | 0 | 47.10778564 | -94.91693868 | 2022-12-22 04:20:56 | Hubbard, Minnesota, US | |
2953115 | 2953115 | 2022-12-20 | US | Minnesota | Hubbard | 27057 | 5898 | 67 | 0 | 47.10778564 | -94.91693868 | 2022-12-21 04:21:03 | Hubbard, Minnesota, US | |
3175517 | 3175517 | 2022-12-19 | US | Minnesota | Hubbard | 27057 | 5898 | 67 | 0 | 47.10778564 | -94.91693868 | 2022-12-20 04:21:04 | Hubbard, Minnesota, US | |
1630034 | 1630034 | 2022-12-18 | US | Minnesota | Hubbard | 27057 | 5898 | 67 | 0 | 47.10778564 | -94.91693868 | 2022-12-19 04:21:03 | Hubbard, Minnesota, US | |
505413 | 505413 | 2022-12-17 | US | Minnesota | Hubbard | 27057 | 5898 | 67 | 0 | 47.10778564 | -94.91693868 | 2022-12-18 04:21:03 | Hubbard, Minnesota, US | |
3325985 | 3325985 | 2022-12-16 | US | Minnesota | Hubbard | 27057 | 5898 | 67 | 0 | 47.10778564 | -94.91693868 | 2022-12-17 04:21:04 | Hubbard, Minnesota, US | |
544497 | 544497 | 2022-12-15 | US | Minnesota | Hubbard | 27057 | 5898 | 67 | 0 | 47.10778564 | -94.91693868 | 2022-12-16 04:21:01 | Hubbard, Minnesota, US | |
836407 | 836407 | 2022-12-02 | US | Puerto Rico | Sabana Grande | 72121 | 5898 | 0 | 0 | 18.08282 | -66.943758 | 2022-12-03 04:21:02 | Sabana Grande, Puerto Rico, US | |
3280197 | 3280197 | 2022-10-23 | US | Virginia | Colonial Heights | 51570 | 5898 | 107 | 0 | 37.26420587 | -77.39609676 | 2022-10-24 04:22:29 | Colonial Heights, Virginia, US | |
2271235 | 2271235 | 2022-10-22 | US | Virginia | Colonial Heights | 51570 | 5898 | 107 | 0 | 37.26420587 | -77.39609676 | 2022-10-23 04:22:46 | Colonial Heights, Virginia, US | |
1595535 | 1595535 | 2022-10-21 | US | Virginia | Colonial Heights | 51570 | 5898 | 107 | 0 | 37.26420587 | -77.39609676 | 2022-10-22 04:22:53 | Colonial Heights, Virginia, US | |
3215344 | 3215344 | 2022-10-12 | US | Illinois | Richland | 17159 | 5898 | 77 | 0 | 38.71240969 | -88.08475366 | 2022-10-13 04:22:39 | Richland, Illinois, US | |
2263317 | 2263317 | 2022-10-02 | US | Wisconsin | Green Lake | 55047 | 5898 | 66 | 0 | 43.80025981 | -89.04679553 | 2022-10-03 04:23:11 | Green Lake, Wisconsin, US | |
2998843 | 2998843 | 2022-10-01 | US | Wisconsin | Green Lake | 55047 | 5898 | 66 | 0 | 43.80025981 | -89.04679553 | 2022-10-02 04:21:23 | Green Lake, Wisconsin, US | |
857169 | 857169 | 2022-09-30 | US | Wisconsin | Green Lake | 55047 | 5898 | 66 | 0 | 43.80025981 | -89.04679553 | 2022-10-01 04:23:01 | Green Lake, Wisconsin, US | |
2379095 | 2379095 | 2022-09-29 | US | Wisconsin | Green Lake | 55047 | 5898 | 66 | 0 | 43.80025981 | -89.04679553 | 2022-09-30 04:23:09 | Green Lake, Wisconsin, US | |
1373821 | 1373821 | 2022-09-21 | US | Virginia | Colonial Heights | 51570 | 5898 | 106 | 0 | 37.26420587 | -77.39609676 | 2022-09-22 04:22:56 | Colonial Heights, Virginia, US | |
3988129 | 3988129 | 2022-09-15 | US | Louisiana | Concordia | 22029 | 5898 | 91 | 0 | 31.44817835 | -91.63814433 | 2022-09-16 04:21:19 | Concordia, Louisiana, US | |
1879255 | 1879255 | 2022-08-28 | US | New York | Schoharie | 36095 | 5898 | 36 | 0 | 42.58831742 | -74.4433903 | 2022-08-29 04:21:06 | Schoharie, New York, US | |
1164760 | 1164760 | 2022-08-18 | US | Wisconsin | Vilas | 55125 | 5898 | 91 | 0 | 46.05467334 | -89.51719204 | 2022-08-19 04:20:54 | Vilas, Wisconsin, US | |
1087243 | 1087243 | 2022-08-09 | US | Iowa | Bremer | 19017 | 5898 | 84 | 0 | 42.77461496 | -92.31795937 | 2022-08-10 04:20:57 | Bremer, Iowa, US | |
3544658 | 3544658 | 2022-08-08 | US | Iowa | Bremer | 19017 | 5898 | 84 | 0 | 42.77461496 | -92.31795937 | 2022-08-09 04:20:34 | Bremer, Iowa, US | |
1071061 | 1071061 | 2022-08-07 | US | Iowa | Bremer | 19017 | 5898 | 84 | 0 | 42.77461496 | -92.31795937 | 2022-08-08 04:21:08 | Bremer, Iowa, US | |
1941649 | 1941649 | 2022-08-06 | US | Iowa | Bremer | 19017 | 5898 | 84 | 0 | 42.77461496 | -92.31795937 | 2022-08-07 04:20:54 | Bremer, Iowa, US | |
881448 | 881448 | 2022-08-05 | US | Iowa | Bremer | 19017 | 5898 | 84 | 0 | 42.77461496 | -92.31795937 | 2022-08-06 04:20:56 | Bremer, Iowa, US | |
2009859 | 2009859 | 2022-08-04 | US | Iowa | Bremer | 19017 | 5898 | 84 | 0 | 42.77461496 | -92.31795937 | 2022-08-05 04:20:52 | Bremer, Iowa, US | |
1099286 | 1099286 | 2022-08-03 | US | Iowa | Bremer | 19017 | 5898 | 84 | 0 | 42.77461496 | -92.31795937 | 2022-08-04 04:20:58 | Bremer, Iowa, US | |
671254 | 671254 | 2022-07-21 | US | Idaho | Payette | 16075 | 5898 | 87 | 0 | 44.00545243 | -116.7647695 | 2022-07-22 04:21:15 | Payette, Idaho, US | |
1609217 | 1609217 | 2022-07-20 | US | Idaho | Payette | 16075 | 5898 | 87 | 0 | 44.00545243 | -116.7647695 | 2022-07-21 04:21:10 | Payette, Idaho, US | |
3112874 | 3112874 | 2022-07-13 | US | Virginia | Page | 51139 | 5898 | 123 | 0 | 38.61807452 | -78.48797204 | 2022-07-14 04:20:57 | Page, Virginia, US | |
1419807 | 1419807 | 2022-07-08 | US | Puerto Rico | Anasco | 72011 | 5898 | 0 | 0 | 18.287985 | -67.120611 | 2022-07-09 04:20:59 | Anasco, Puerto Rico, US | |
1766368 | 1766368 | 2022-06-20 | US | Texas | Calhoun | 48057 | 5898 | 49 | 0 | 28.47048236 | -96.61633945 | 2022-06-21 04:20:56 | Calhoun, Texas, US | |
3508836 | 3508836 | 2022-06-05 | US | Kentucky | Meade | 21163 | 5898 | 66 | 0 | 37.96163597 | -86.21028219 | 2022-06-06 04:20:57 | Meade, Kentucky, US | |
3528913 | 3528913 | 2022-06-04 | US | Kentucky | Meade | 21163 | 5898 | 66 | 0 | 37.96163597 | -86.21028219 | 2022-06-05 04:20:55 | Meade, Kentucky, US | |
3134999 | 3134999 | 2022-06-03 | US | Kentucky | Meade | 21163 | 5898 | 66 | 0 | 37.96163597 | -86.21028219 | 2022-06-04 04:20:58 | Meade, Kentucky, US | |
3580074 | 3580074 | 2022-06-02 | US | Kentucky | Meade | 21163 | 5898 | 66 | 0 | 37.96163597 | -86.21028219 | 2022-06-03 04:20:58 | Meade, Kentucky, US | |
972367 | 972367 | 2022-06-01 | US | Kentucky | Meade | 21163 | 5898 | 66 | 0 | 37.96163597 | -86.21028219 | 2022-06-02 05:20:39 | Meade, Kentucky, US | |
230674 | 230674 | 2022-05-31 | US | Kentucky | Meade | 21163 | 5898 | 66 | 0 | 37.96163597 | -86.21028219 | 2022-06-01 04:20:55 | Meade, Kentucky, US | |
3268590 | 3268590 | 2022-05-04 | US | Texas | Frio | 48163 | 5898 | 93 | 0 | 28.86751206 | -99.10804207 | 2022-05-05 04:20:55 | Frio, Texas, US | |
306621 | 306621 | 2022-04-16 | US | Puerto Rico | Juncos | 72077 | 5898 | 0 | 0 | 18.223793 | -65.909109 | 2022-04-17 04:20:59 | Juncos, Puerto Rico, US | |
2672566 | 2672566 | 2022-04-15 | US | Puerto Rico | Juncos | 72077 | 5898 | 0 | 0 | 18.223793 | -65.909109 | 2022-04-16 04:20:48 | Juncos, Puerto Rico, US | |
1226351 | 1226351 | 2022-04-14 | US | Puerto Rico | Juncos | 72077 | 5898 | 0 | 0 | 18.223793 | -65.909109 | 2022-04-15 04:20:57 | Juncos, Puerto Rico, US | |
1577518 | 1577518 | 2022-04-10 | US | Kentucky | Adair | 21001 | 5898 | 103 | 0 | 37.10459774 | -85.28129668 | 2022-04-11 04:21:02 | Adair, Kentucky, US | |
1653760 | 1653760 | 2022-04-09 | US | Kentucky | Adair | 21001 | 5898 | 103 | 0 | 37.10459774 | -85.28129668 | 2022-04-10 04:20:52 | Adair, Kentucky, US | |
2117082 | 2117082 | 2022-04-08 | US | Kentucky | Adair | 21001 | 5898 | 103 | 0 | 37.10459774 | -85.28129668 | 2022-04-09 04:20:42 | Adair, Kentucky, US | |
3321606 | 3321606 | 2022-04-07 | US | Kentucky | Adair | 21001 | 5898 | 103 | 0 | 37.10459774 | -85.28129668 | 2022-04-08 04:20:48 | Adair, Kentucky, US | |
2802142 | 2802142 | 2022-04-06 | US | Kentucky | Adair | 21001 | 5898 | 103 | 0 | 37.10459774 | -85.28129668 | 2022-04-07 04:20:53 | Adair, Kentucky, US | |
3868911 | 3868911 | 2022-04-05 | US | Kentucky | Adair | 21001 | 5898 | 103 | 0 | 37.10459774 | -85.28129668 | 2022-04-06 04:20:49 | Adair, Kentucky, US | |
2750253 | 2750253 | 2022-04-04 | US | Kentucky | Adair | 21001 | 5898 | 103 | 0 | 37.10459774 | -85.28129668 | 2022-04-05 04:20:48 | Adair, Kentucky, US | |
2166262 | 2166262 | 2022-03-26 | US | Puerto Rico | Aguada | 72003 | 5898 | 0 | 0 | 18.360255 | -67.17513100000001 | 2022-03-27 04:20:47 | Aguada, Puerto Rico, US | |
1299887 | 1299887 | 2022-02-17 | US | Mississippi | Newton | 28101 | 5898 | 93 | 0 | 32.40021118 | -89.11843336 | 2022-02-18 04:21:04 | Newton, Mississippi, US | |
234178 | 234178 | 2022-02-11 | US | Idaho | Elmore | 16039 | 5898 | 58 | 0 | 43.3507101 | -115.4701578 | 2022-02-12 04:21:06 | Elmore, Idaho, US | |
1466456 | 1466456 | 2022-02-10 | US | North Carolina | Transylvania | 37175 | 5898 | 64 | 0 | 35.20383864 | -82.79638423 | 2022-02-11 04:21:09 | Transylvania, North Carolina, US | |
74222 | 74222 | 2022-02-07 | US | Texas | Jasper | 48241 | 5898 | 170 | 0 | 30.74685667 | -94.02667579 | 2022-02-08 04:21:15 | Jasper, Texas, US | |
982468 | 982468 | 2022-02-01 | US | West Virginia | Upshur | 54097 | 5898 | 77 | 0 | 38.89285061 | -80.23689136 | 2022-02-02 04:21:09 | Upshur, West Virginia, US | |
1115432 | 1115432 | 2022-01-11 | US | Mississippi | Prentiss | 28117 | 5898 | 88 | 0 | 34.61810501 | -88.51986294 | 2022-01-12 04:21:44 | Prentiss, Mississippi, US | |
1282507 | 1282507 | 2022-01-05 | US | Arkansas | Poinsett | 5111 | 5898 | 106 | 0 | 35.57433534 | -90.66268713 | 2022-01-06 04:22:09 | Poinsett, Arkansas, US | |
1718810 | 1718810 | 2021-12-16 | US | Ohio | Coshocton | 39031 | 5898 | 126 | 0 | 40.30096166 | -81.91729018 | 2021-12-17 04:22:14 | Coshocton, Ohio, US | |
550760 | 550760 | 2021-12-08 | Japan | Aomori | 5898 | 38 | 0 | 40.781541 | 140.828896 | 2021-12-09 04:22:49 | Aomori, Japan | |||
1144839 | 1144839 | 2021-12-01 | Grenada | 5898 | 200 | 0 | 12.1165 | -61.678999999999995 | 2021-12-02 04:22:37 | Grenada | ||||
3750277 | 3750277 | 2021-11-22 | US | Indiana | Wabash | 18169 | 5898 | 107 | 0 | 40.84704239 | -85.79328272 | 2021-11-23 04:22:39 | Wabash, Indiana, US | |
165131 | 165131 | 2021-11-19 | US | Texas | Grimes | 48185 | 5898 | 108 | 0 | 30.54579585 | -95.98902499 | 2021-11-20 04:22:17 | Grimes, Texas, US | |
163602 | 163602 | 2021-11-19 | US | Maryland | Calvert | 24009 | 5898 | 101 | 0 | 38.53961642 | -76.56820632 | 2021-11-20 04:22:17 | Calvert, Maryland, US | |
1323602 | 1323602 | 2021-11-14 | US | Kentucky | Bell | 21013 | 5898 | 97 | 0 | 36.73355174 | -83.67766671 | 2021-11-15 04:21:36 | Bell, Kentucky, US | |
1494171 | 1494171 | 2021-10-12 | US | Oklahoma | Logan | 40083 | 5898 | 97 | 0 | 35.91899576 | -97.44352845 | 2021-10-13 04:20:51 | Logan, Oklahoma, US | |
3009904 | 3009904 | 2021-10-11 | US | Oklahoma | Logan | 40083 | 5898 | 97 | 0 | 35.91899576 | -97.44352845 | 2021-10-12 04:21:09 | Logan, Oklahoma, US | |
425920 | 425920 | 2021-10-10 | US | Oklahoma | Logan | 40083 | 5898 | 97 | 0 | 35.91899576 | -97.44352845 | 2021-10-11 04:21:31 | Logan, Oklahoma, US | |
2878777 | 2878777 | 2021-10-09 | US | Oklahoma | Logan | 40083 | 5898 | 97 | 0 | 35.91899576 | -97.44352845 | 2021-10-10 04:21:38 | Logan, Oklahoma, US | |
2961943 | 2961943 | 2021-10-08 | US | Oklahoma | Logan | 40083 | 5898 | 97 | 0 | 35.91899576 | -97.44352845 | 2021-10-09 04:21:34 | Logan, Oklahoma, US | |
469981 | 469981 | 2021-10-07 | US | Oklahoma | Logan | 40083 | 5898 | 97 | 0 | 35.91899576 | -97.44352845 | 2021-10-08 04:21:25 | Logan, Oklahoma, US | |
2461361 | 2461361 | 2021-10-06 | US | Oklahoma | Logan | 40083 | 5898 | 97 | 0 | 35.91899576 | -97.44352845 | 2021-10-07 04:21:36 | Logan, Oklahoma, US | |
1275778 | 1275778 | 2021-10-03 | US | Louisiana | Beauregard | 22011 | 5898 | 120 | 0 | 30.64836518 | -93.34173616 | 2021-10-04 04:21:31 | Beauregard, Louisiana, US | |
3929531 | 3929531 | 2021-10-02 | US | Louisiana | Beauregard | 22011 | 5898 | 120 | 0 | 30.64836518 | -93.34173616 | 2021-10-03 04:21:24 | Beauregard, Louisiana, US | |
2135261 | 2135261 | 2021-10-01 | US | Texas | Upshur | 48459 | 5898 | 122 | 0 | 32.73706798 | -94.93999853 | 2021-10-02 04:21:25 | Upshur, Texas, US | |
2133511 | 2133511 | 2021-10-01 | US | Louisiana | Beauregard | 22011 | 5898 | 120 | 0 | 30.64836518 | -93.34173616 | 2021-10-02 04:21:25 | Beauregard, Louisiana, US | |
3449929 | 3449929 | 2021-09-10 | US | Indiana | Gibson | 18051 | 5898 | 103 | 0 | 38.30393723 | -87.58054938 | 2021-09-11 04:21:30 | Gibson, Indiana, US | |
3448867 | 3448867 | 2021-09-10 | Japan | Miyazaki | 5898 | 34 | 0 | 32.193203999999994 | 131.299374 | 2021-09-11 04:21:30 | Miyazaki, Japan | |||
2279760 | 2279760 | 2021-09-08 | US | Colorado | Broomfield | 8014 | 5898 | 79 | 0 | 39.95998787 | -105.0566324 | 2021-09-09 04:21:27 | Broomfield, Colorado, US | |
3194362 | 3194362 | 2021-09-06 | US | Alabama | Covington | 1039 | 5898 | 150 | 0 | 31.247785399999998 | -86.45050893 | 2021-09-07 04:21:35 | Covington, Alabama, US | |
3892488 | 3892488 | 2021-08-29 | US | California | Mendocino | 6045 | 5898 | 55 | 0 | 39.4381191 | -123.39113130000001 | 2021-08-30 04:21:23 | Mendocino, California, US | |
1855361 | 1855361 | 2021-08-20 | US | Kentucky | Boyd | 21019 | 5898 | 79 | 0 | 38.36176608 | -82.68652187 | 2021-08-21 04:21:38 | Boyd, Kentucky, US | |
591949 | 591949 | 2021-08-08 | US | North Carolina | Halifax | 37083 | 5898 | 116 | 0 | 36.25669272 | -77.6556109 | 2021-08-09 04:21:24 | Halifax, North Carolina, US | |
2205961 | 2205961 | 2021-08-07 | US | North Carolina | Halifax | 37083 | 5898 | 116 | 0 | 36.25669272 | -77.6556109 | 2021-08-08 04:21:33 | Halifax, North Carolina, US | |
1119911 | 1119911 | 2021-08-06 | US | North Carolina | Halifax | 37083 | 5898 | 116 | 0 | 36.25669272 | -77.6556109 | 2021-08-07 04:21:30 | Halifax, North Carolina, US | |
3468199 | 3468199 | 2021-08-03 | Japan | Mie | 5898 | 114 | 5569 | 215 | 34.508018 | 136.376013 | 2021-08-04 04:21:25 | Mie, Japan | ||
3478058 | 3478058 | 2021-07-22 | US | Minnesota | Otter Tail | 27111 | 5898 | 87 | 0 | 46.40846929 | -95.70835255 | 2021-07-23 04:21:29 | Otter Tail, Minnesota, US | |
2423965 | 2423965 | 2021-06-23 | US | Indiana | Dearborn | 18029 | 5898 | 78 | 0 | 39.14647946 | -84.97333539 | 2021-06-24 04:21:55 | Dearborn, Indiana, US | |
564042 | 564042 | 2021-06-22 | US | Indiana | Dearborn | 18029 | 5898 | 78 | 0 | 39.14647946 | -84.97333539 | 2021-06-23 04:21:46 | Dearborn, Indiana, US | |
3359744 | 3359744 | 2021-06-21 | US | Indiana | Dearborn | 18029 | 5898 | 78 | 0 | 39.14647946 | -84.97333539 | 2021-06-22 04:21:34 | Dearborn, Indiana, US | |
2885443 | 2885443 | 2021-06-20 | US | Indiana | Dearborn | 18029 | 5898 | 78 | 0 | 39.14647946 | -84.97333539 | 2021-06-21 04:21:41 | Dearborn, Indiana, US | |
108526 | 108526 | 2021-06-19 | US | Indiana | Dearborn | 18029 | 5898 | 78 | 0 | 39.14647946 | -84.97333539 | 2021-06-20 04:21:48 | Dearborn, Indiana, US | |
2315804 | 2315804 | 2021-06-04 | US | Arkansas | Mississippi | 5093 | 5898 | 109 | 0 | 35.76271485 | -90.05194370000002 | 2021-06-05 04:23:03 | Mississippi, Arkansas, US | |
1416535 | 1416535 | 2021-05-24 | US | West Virginia | Harrison | 54033 | 5898 | 77 | 0 | 39.2853852 | -80.37919577 | 2021-05-25 04:21:08 | Harrison, West Virginia, US | |
2391384 | 2391384 | 2021-05-18 | US | Colorado | Garfield | 8045 | 5898 | 41 | 0 | 39.59921777 | -107.902708 | 2021-05-19 04:20:42 | Garfield, Colorado, US | |
649472 | 649472 | 2021-05-05 | US | Wisconsin | Barron | 55005 | 5898 | 83 | 0 | 45.42372701 | -91.84833627 | 2021-05-06 04:20:38 | Barron, Wisconsin, US | |
2824690 | 2824690 | 2021-05-01 | Gambia | 5898 | 174 | 5357 | 367 | 13.4432 | -15.3101 | 2021-05-02 04:20:48 | Gambia | |||
380098 | 380098 | 2021-04-30 | Gambia | 5898 | 174 | 5357 | 367 | 13.4432 | -15.3101 | 2021-05-01 04:20:47 | Gambia | |||
3705053 | 3705053 | 2021-04-27 | US | Tennessee | Hawkins | 47073 | 5898 | 106 | 0 | 36.44355426 | -82.94885298 | 2021-04-28 04:20:32 | Hawkins, Tennessee, US | |
3085909 | 3085909 | 2021-04-05 | US | Colorado | Eagle | 8037 | 5898 | 23 | 0 | 39.62754308 | -106.6933637 | 2021-04-06 04:20:32 | Eagle, Colorado, US | |
1536791 | 1536791 | 2021-03-28 | US | Georgia | Spalding | 13255 | 5898 | 179 | 0 | 33.26310031 | -84.28013991 | 2021-03-29 04:28:35 | Spalding, Georgia, 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]);