johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
155 rows where confirmed = 5301 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3176513 | 3176513 | 2022-12-19 | US | Puerto Rico | Arroyo | 72015 | 5301 | 0 | 0 | 17.998457 | -66.056546 | 2022-12-20 04:21:04 | Arroyo, Puerto Rico, US | |
1986374 | 1986374 | 2022-12-07 | US | Minnesota | Houston | 27055 | 5301 | 24 | 0 | 43.67129565 | -91.49143057 | 2022-12-08 04:21:07 | Houston, Minnesota, US | |
3715897 | 3715897 | 2022-12-06 | US | Minnesota | Houston | 27055 | 5301 | 24 | 0 | 43.67129565 | -91.49143057 | 2022-12-07 04:20:58 | Houston, Minnesota, US | |
2416602 | 2416602 | 2022-12-05 | US | Minnesota | Houston | 27055 | 5301 | 24 | 0 | 43.67129565 | -91.49143057 | 2022-12-06 04:21:03 | Houston, Minnesota, US | |
720210 | 720210 | 2022-12-04 | US | Minnesota | Houston | 27055 | 5301 | 24 | 0 | 43.67129565 | -91.49143057 | 2022-12-05 04:20:58 | Houston, Minnesota, US | |
2818499 | 2818499 | 2022-12-03 | US | Minnesota | Houston | 27055 | 5301 | 24 | 0 | 43.67129565 | -91.49143057 | 2022-12-04 04:20:56 | Houston, Minnesota, US | |
835355 | 835355 | 2022-12-02 | US | Minnesota | Houston | 27055 | 5301 | 24 | 0 | 43.67129565 | -91.49143057 | 2022-12-03 04:21:02 | Houston, Minnesota, US | |
2137885 | 2137885 | 2022-12-01 | US | Minnesota | Houston | 27055 | 5301 | 24 | 0 | 43.67129565 | -91.49143057 | 2022-12-02 04:21:07 | Houston, Minnesota, US | |
2560023 | 2560023 | 2022-11-29 | US | Washington | Asotin | 53003 | 5301 | 78 | 0 | 46.18894415 | -117.2022851 | 2022-11-30 04:21:07 | Asotin, Washington, US | |
1243097 | 1243097 | 2022-11-28 | US | Washington | Asotin | 53003 | 5301 | 78 | 0 | 46.18894415 | -117.2022851 | 2022-11-29 04:21:05 | Asotin, Washington, US | |
3555085 | 3555085 | 2022-11-27 | US | Washington | Asotin | 53003 | 5301 | 78 | 0 | 46.18894415 | -117.2022851 | 2022-11-28 04:21:02 | Asotin, Washington, US | |
2103565 | 2103565 | 2022-11-26 | US | Washington | Asotin | 53003 | 5301 | 78 | 0 | 46.18894415 | -117.2022851 | 2022-11-27 04:21:05 | Asotin, Washington, US | |
491056 | 491056 | 2022-11-25 | US | Washington | Asotin | 53003 | 5301 | 78 | 0 | 46.18894415 | -117.2022851 | 2022-11-26 04:21:11 | Asotin, Washington, US | |
3526885 | 3526885 | 2022-11-24 | US | Washington | Asotin | 53003 | 5301 | 78 | 0 | 46.18894415 | -117.2022851 | 2022-11-25 04:21:06 | Asotin, Washington, US | |
3315668 | 3315668 | 2022-11-23 | US | Washington | Asotin | 53003 | 5301 | 78 | 0 | 46.18894415 | -117.2022851 | 2022-11-24 04:21:09 | Asotin, Washington, US | |
1623126 | 1623126 | 2022-11-22 | US | South Dakota | Beadle | 46005 | 5301 | 64 | 0 | 44.41464384 | -98.27858469 | 2022-11-23 04:21:06 | Beadle, South Dakota, US | |
3463014 | 3463014 | 2022-11-21 | US | South Dakota | Beadle | 46005 | 5301 | 64 | 0 | 44.41464384 | -98.27858469 | 2022-11-22 04:20:47 | Beadle, South Dakota, US | |
1643199 | 1643199 | 2022-11-20 | US | South Dakota | Beadle | 46005 | 5301 | 64 | 0 | 44.41464384 | -98.27858469 | 2022-11-21 04:21:05 | Beadle, South Dakota, US | |
2066756 | 2066756 | 2022-11-19 | US | South Dakota | Beadle | 46005 | 5301 | 64 | 0 | 44.41464384 | -98.27858469 | 2022-11-20 04:21:08 | Beadle, South Dakota, US | |
1758150 | 1758150 | 2022-11-18 | US | South Dakota | Beadle | 46005 | 5301 | 64 | 0 | 44.41464384 | -98.27858469 | 2022-11-19 04:21:14 | Beadle, South Dakota, US | |
3029143 | 3029143 | 2022-11-17 | US | South Dakota | Beadle | 46005 | 5301 | 64 | 0 | 44.41464384 | -98.27858469 | 2022-11-18 04:21:15 | Beadle, South Dakota, US | |
2488854 | 2488854 | 2022-11-16 | US | South Dakota | Beadle | 46005 | 5301 | 64 | 0 | 44.41464384 | -98.27858469 | 2022-11-17 04:21:11 | Beadle, South Dakota, US | |
482365 | 482365 | 2022-11-08 | US | Puerto Rico | Penuelas | 72111 | 5301 | 0 | 0 | 18.059645 | -66.721572 | 2022-11-09 04:21:22 | Penuelas, Puerto Rico, US | |
2652772 | 2652772 | 2022-09-24 | US | Tennessee | Polk | 47139 | 5301 | 86 | 0 | 35.12245443 | -84.52075859 | 2022-09-25 04:23:31 | Polk, Tennessee, US | |
387212 | 387212 | 2022-09-23 | US | Tennessee | Polk | 47139 | 5301 | 86 | 0 | 35.12245443 | -84.52075859 | 2022-09-24 04:21:40 | Polk, Tennessee, US | |
3989714 | 3989714 | 2022-09-15 | US | Texas | Fayette | 48149 | 5301 | 114 | 0 | 29.87788372 | -96.92076062 | 2022-09-16 04:21:19 | Fayette, Texas, US | |
1892231 | 1892231 | 2022-09-14 | US | Texas | Fayette | 48149 | 5301 | 114 | 0 | 29.87788372 | -96.92076062 | 2022-09-15 04:21:02 | Fayette, Texas, US | |
2346954 | 2346954 | 2022-08-31 | US | Wisconsin | Adams | 55001 | 5301 | 65 | 0 | 43.96974651 | -89.76782777 | 2022-09-01 04:21:03 | Adams, Wisconsin, US | |
1878114 | 1878114 | 2022-08-28 | US | Indiana | Perry | 18123 | 5301 | 70 | 0 | 38.07809328 | -86.63741946 | 2022-08-29 04:21:06 | Perry, Indiana, US | |
2097241 | 2097241 | 2022-08-27 | US | Indiana | Perry | 18123 | 5301 | 70 | 0 | 38.07809328 | -86.63741946 | 2022-08-28 04:21:02 | Perry, Indiana, US | |
1533056 | 1533056 | 2022-08-26 | US | Indiana | Perry | 18123 | 5301 | 70 | 0 | 38.07809328 | -86.63741946 | 2022-08-27 04:20:57 | Perry, Indiana, US | |
2832128 | 2832128 | 2022-08-25 | US | Virginia | Buchanan | 51027 | 5301 | 130 | 0 | 37.26818323 | -82.03749726 | 2022-08-26 04:21:02 | Buchanan, Virginia, US | |
2323865 | 2323865 | 2022-08-24 | US | Arkansas | Phillips | 5107 | 5301 | 100 | 0 | 34.43268455 | -90.84800154 | 2022-08-25 04:21:13 | Phillips, Arkansas, US | |
2855933 | 2855933 | 2022-08-22 | US | Texas | Deaf Smith | 48117 | 5301 | 115 | 0 | 34.96522957 | -102.6054267 | 2022-08-23 04:20:56 | Deaf Smith, Texas, US | |
1162143 | 1162143 | 2022-08-18 | US | Illinois | Clay | 17025 | 5301 | 70 | 0 | 38.75388572 | -88.48914513 | 2022-08-19 04:20:54 | Clay, Illinois, US | |
3950866 | 3950866 | 2022-08-17 | US | Alabama | Fayette | 1057 | 5301 | 97 | 0 | 33.72076938 | -87.73886638 | 2022-08-18 04:21:11 | Fayette, Alabama, US | |
991368 | 991368 | 2022-08-16 | US | Alabama | Fayette | 1057 | 5301 | 97 | 0 | 33.72076938 | -87.73886638 | 2022-08-17 04:20:59 | Fayette, Alabama, US | |
2494407 | 2494407 | 2022-08-15 | US | Alabama | Fayette | 1057 | 5301 | 97 | 0 | 33.72076938 | -87.73886638 | 2022-08-16 04:20:58 | Fayette, Alabama, US | |
3647957 | 3647957 | 2022-08-14 | US | Alabama | Fayette | 1057 | 5301 | 97 | 0 | 33.72076938 | -87.73886638 | 2022-08-15 04:20:59 | Fayette, Alabama, US | |
1968963 | 1968963 | 2022-08-13 | US | Alabama | Fayette | 1057 | 5301 | 97 | 0 | 33.72076938 | -87.73886638 | 2022-08-14 04:20:55 | Fayette, Alabama, US | |
2889006 | 2889006 | 2022-08-12 | US | Colorado | Chaffee | 8015 | 5301 | 52 | 0 | 38.74745778 | -106.1926573 | 2022-08-13 04:20:52 | Chaffee, Colorado, US | |
2888772 | 2888772 | 2022-08-12 | US | Alabama | Fayette | 1057 | 5301 | 97 | 0 | 33.72076938 | -87.73886638 | 2022-08-13 04:20:52 | Fayette, Alabama, US | |
3908377 | 3908377 | 2022-08-11 | US | Alabama | Fayette | 1057 | 5301 | 97 | 0 | 33.72076938 | -87.73886638 | 2022-08-12 04:20:54 | Fayette, Alabama, US | |
897615 | 897615 | 2022-07-24 | US | Kentucky | Rockcastle | 21203 | 5301 | 63 | 0 | 37.36642393 | -84.31176452 | 2022-07-25 04:20:51 | Rockcastle, Kentucky, US | |
92609 | 92609 | 2022-07-23 | US | Kentucky | Rockcastle | 21203 | 5301 | 63 | 0 | 37.36642393 | -84.31176452 | 2022-07-24 04:20:47 | Rockcastle, Kentucky, US | |
901631 | 901631 | 2022-07-22 | US | Kentucky | Rockcastle | 21203 | 5301 | 63 | 0 | 37.36642393 | -84.31176452 | 2022-07-23 04:20:53 | Rockcastle, Kentucky, US | |
671767 | 671767 | 2022-07-21 | US | Kentucky | Rockcastle | 21203 | 5301 | 63 | 0 | 37.36642393 | -84.31176452 | 2022-07-22 04:21:15 | Rockcastle, Kentucky, US | |
1609730 | 1609730 | 2022-07-20 | US | Kentucky | Rockcastle | 21203 | 5301 | 63 | 0 | 37.36642393 | -84.31176452 | 2022-07-21 04:21:10 | Rockcastle, Kentucky, US | |
960363 | 960363 | 2022-07-19 | US | Kentucky | Rockcastle | 21203 | 5301 | 63 | 0 | 37.36642393 | -84.31176452 | 2022-07-20 04:20:59 | Rockcastle, Kentucky, US | |
3211750 | 3211750 | 2022-07-18 | US | Kentucky | Rockcastle | 21203 | 5301 | 63 | 0 | 37.36642393 | -84.31176452 | 2022-07-19 04:20:58 | Rockcastle, Kentucky, US | |
3969273 | 3969273 | 2022-07-05 | US | Puerto Rico | Barceloneta | 72017 | 5301 | 0 | 0 | 18.445533 | -66.560531 | 2022-07-06 04:20:58 | Barceloneta, Puerto Rico, US | |
3080784 | 3080784 | 2022-07-04 | US | Puerto Rico | Barceloneta | 72017 | 5301 | 0 | 0 | 18.445533 | -66.560531 | 2022-07-05 04:20:45 | Barceloneta, Puerto Rico, US | |
1770066 | 1770066 | 2022-07-03 | US | Puerto Rico | Barceloneta | 72017 | 5301 | 0 | 0 | 18.445533 | -66.560531 | 2022-07-04 04:20:54 | Barceloneta, Puerto Rico, US | |
2191009 | 2191009 | 2022-06-22 | US | Virginia | Prince Edward | 51147 | 5301 | 76 | 0 | 37.22554789 | -78.43597949 | 2022-06-23 04:20:55 | Prince Edward, Virginia, US | |
231568 | 231568 | 2022-05-31 | US | North Carolina | Madison | 37115 | 5301 | 81 | 0 | 35.85402722 | -82.71346418 | 2022-06-01 04:20:55 | Madison, North Carolina, US | |
3188333 | 3188333 | 2022-05-30 | US | North Carolina | Madison | 37115 | 5301 | 81 | 0 | 35.85402722 | -82.71346418 | 2022-05-31 04:20:51 | Madison, North Carolina, US | |
3200482 | 3200482 | 2022-05-29 | US | North Carolina | Madison | 37115 | 5301 | 81 | 0 | 35.85402722 | -82.71346418 | 2022-05-30 04:20:50 | Madison, North Carolina, US | |
2727360 | 2727360 | 2022-05-28 | US | North Carolina | Madison | 37115 | 5301 | 81 | 0 | 35.85402722 | -82.71346418 | 2022-05-29 04:20:53 | Madison, North Carolina, US | |
1316541 | 1316541 | 2022-05-27 | US | North Carolina | Madison | 37115 | 5301 | 81 | 0 | 35.85402722 | -82.71346418 | 2022-05-28 04:21:07 | Madison, North Carolina, US | |
1852333 | 1852333 | 2022-05-26 | US | North Carolina | Madison | 37115 | 5301 | 81 | 0 | 35.85402722 | -82.71346418 | 2022-05-27 04:20:56 | Madison, North Carolina, US | |
2050209 | 2050209 | 2022-05-25 | US | North Carolina | Madison | 37115 | 5301 | 81 | 0 | 35.85402722 | -82.71346418 | 2022-05-26 04:20:50 | Madison, North Carolina, US | |
624220 | 624220 | 2022-05-22 | US | North Carolina | Madison | 37115 | 5301 | 81 | 0 | 35.85402722 | -82.71346418 | 2022-05-26 04:20:50 | Madison, North Carolina, US | |
1505801 | 1505801 | 2022-05-16 | US | New Mexico | Lincoln | 35027 | 5301 | 67 | 0 | 33.74526079 | -105.4586166 | 2022-05-17 04:20:59 | Lincoln, New Mexico, US | |
3722701 | 3722701 | 2022-04-25 | US | Arkansas | Lawrence | 5075 | 5301 | 77 | 0 | 36.04188196 | -91.10867198 | 2022-04-26 04:20:51 | Lawrence, Arkansas, US | |
2029828 | 2029828 | 2022-04-24 | US | Illinois | Wayne | 17191 | 5301 | 84 | 0 | 38.42955355 | -88.42586459 | 2022-04-25 04:20:56 | Wayne, Illinois, US | |
747403 | 747403 | 2022-04-23 | US | Illinois | Wayne | 17191 | 5301 | 84 | 0 | 38.42955355 | -88.42586459 | 2022-04-24 04:20:56 | Wayne, Illinois, US | |
3437888 | 3437888 | 2022-04-22 | US | Illinois | Wayne | 17191 | 5301 | 84 | 0 | 38.42955355 | -88.42586459 | 2022-04-23 04:20:50 | Wayne, Illinois, US | |
2893473 | 2893473 | 2022-04-21 | US | Illinois | Wayne | 17191 | 5301 | 84 | 0 | 38.42955355 | -88.42586459 | 2022-04-22 04:20:45 | Wayne, Illinois, US | |
502402 | 502402 | 2022-04-02 | US | Puerto Rico | Cidra | 72041 | 5301 | 0 | 0 | 18.173559 | -66.161179 | 2022-04-03 04:20:48 | Cidra, Puerto Rico, US | |
3024206 | 3024206 | 2022-03-23 | US | Missouri | McDonald | 29119 | 5301 | 67 | 0 | 36.62869595 | -94.34867205 | 2022-03-24 04:20:43 | McDonald, Missouri, US | |
697813 | 697813 | 2022-03-17 | US | Virginia | Waynesboro | 51820 | 5301 | 60 | 0 | 38.06451466 | -78.90293905 | 2022-03-18 04:20:55 | Waynesboro, Virginia, US | |
2450115 | 2450115 | 2022-02-22 | US | Virginia | Fredericksburg | 51630 | 5301 | 34 | 0 | 38.2977863 | -77.4922454 | 2022-02-23 04:21:09 | Fredericksburg, Virginia, US | |
2448187 | 2448187 | 2022-02-22 | US | Kentucky | Hart | 21099 | 5301 | 92 | 0 | 37.29943898 | -85.88461055 | 2022-02-23 04:21:09 | Hart, Kentucky, US | |
3878341 | 3878341 | 2022-02-19 | US | Puerto Rico | Moca | 72099 | 5301 | 0 | 0 | 18.377805 | -67.080952 | 2022-02-20 04:21:00 | Moca, Puerto Rico, US | |
3858593 | 3858593 | 2022-02-18 | US | Puerto Rico | Manati | 72091 | 5301 | 0 | 0 | 18.420473 | -66.490461 | 2022-02-19 04:21:11 | Manati, Puerto Rico, US | |
3821392 | 3821392 | 2022-02-16 | US | Idaho | Payette | 16075 | 5301 | 82 | 0 | 44.00545243 | -116.7647695 | 2022-02-17 04:20:56 | Payette, Idaho, US | |
1363170 | 1363170 | 2022-02-08 | US | Georgia | Haralson | 13143 | 5301 | 150 | 0 | 33.79602175 | -85.21005667 | 2022-02-09 04:21:04 | Haralson, Georgia, US | |
73619 | 73619 | 2022-02-07 | US | Ohio | Wyandot | 39175 | 5301 | 100 | 0 | 40.84339621 | -83.30734173 | 2022-02-08 04:21:15 | Wyandot, Ohio, US | |
72005 | 72005 | 2022-02-07 | US | Hawaii | Out of HI | 80015 | 5301 | 12 | 0 | 22.03935037 | 0.0 | 2022-02-08 04:21:15 | Out of HI, Hawaii, US | |
2015725 | 2015725 | 2022-02-06 | US | Texas | Austin | 48015 | 5301 | 64 | 0 | 29.88548725 | -96.27736949 | 2022-02-07 04:21:05 | Austin, Texas, US | |
1230608 | 1230608 | 2022-01-24 | US | Tennessee | Smith | 47159 | 5301 | 68 | 0 | 36.25359775 | -85.95411046 | 2022-01-25 04:21:05 | Smith, Tennessee, US | |
1700480 | 1700480 | 2022-01-03 | Netherlands | Sint Maarten | 5301 | 75 | 0 | 18.0425 | -63.0548 | 2022-01-04 04:22:17 | Sint Maarten, Netherlands | |||
3519563 | 3519563 | 2022-01-02 | Netherlands | Sint Maarten | 5301 | 75 | 0 | 18.0425 | -63.0548 | 2022-01-03 02:22:25 | Sint Maarten, Netherlands | |||
2167693 | 2167693 | 2022-01-01 | Netherlands | Sint Maarten | 5301 | 75 | 0 | 18.0425 | -63.0548 | 2022-01-02 04:20:52 | Sint Maarten, Netherlands | |||
3829605 | 3829605 | 2021-12-21 | US | Indiana | Scott | 18143 | 5301 | 82 | 0 | 38.68672078 | -85.74627859 | 2021-12-22 04:21:54 | Scott, Indiana, US | |
1261572 | 1261572 | 2021-12-18 | US | Puerto Rico | Toa Baja | 72137 | 5301 | 0 | 0 | 18.431445999999998 | -66.213553 | 2021-12-19 04:21:11 | Toa Baja, Puerto Rico, US | |
1233608 | 1233608 | 2021-11-28 | US | Missouri | Warren | 29219 | 5301 | 52 | 0 | 38.76529479 | -91.16124662 | 2021-11-29 04:22:30 | Warren, Missouri, US | |
1360595 | 1360595 | 2021-11-27 | US | New York | Otsego | 36077 | 5301 | 61 | 0 | 42.63492579 | -75.03151402 | 2021-11-28 04:22:43 | Otsego, New York, US | |
1360315 | 1360315 | 2021-11-27 | US | Missouri | Warren | 29219 | 5301 | 52 | 0 | 38.76529479 | -91.16124662 | 2021-11-28 04:22:43 | Warren, Missouri, US | |
760306 | 760306 | 2021-11-26 | US | Missouri | Warren | 29219 | 5301 | 52 | 0 | 38.76529479 | -91.16124662 | 2021-11-27 04:22:45 | Warren, Missouri, US | |
1804723 | 1804723 | 2021-11-25 | US | Missouri | Warren | 29219 | 5301 | 52 | 0 | 38.76529479 | -91.16124662 | 2021-11-26 04:22:33 | Warren, Missouri, US | |
906157 | 906157 | 2021-11-24 | US | Missouri | Warren | 29219 | 5301 | 52 | 0 | 38.76529479 | -91.16124662 | 2021-11-25 04:22:33 | Warren, Missouri, US | |
1325849 | 1325849 | 2021-11-14 | US | Wyoming | Teton | 56039 | 5301 | 14 | 0 | 43.93522482 | -110.5890801 | 2021-11-15 04:21:36 | Teton, Wyoming, US | |
689975 | 689975 | 2021-11-13 | US | Wyoming | Teton | 56039 | 5301 | 14 | 0 | 43.93522482 | -110.5890801 | 2021-11-14 04:21:31 | Teton, Wyoming, US | |
688287 | 688287 | 2021-11-13 | US | Missouri | Marion | 29127 | 5301 | 64 | 0 | 39.80601912 | -91.62203062 | 2021-11-14 04:21:31 | Marion, Missouri, US | |
718084 | 718084 | 2021-11-12 | US | Wyoming | Teton | 56039 | 5301 | 14 | 0 | 43.93522482 | -110.5890801 | 2021-11-13 04:21:38 | Teton, Wyoming, US | |
570597 | 570597 | 2021-10-29 | US | West Virginia | Marshall | 54051 | 5301 | 114 | 0 | 39.86064362 | -80.66591062 | 2021-10-30 04:22:03 | Marshall, West Virginia, US | |
2126250 | 2126250 | 2021-10-21 | US | Ohio | Putnam | 39137 | 5301 | 113 | 0 | 41.02094889 | -84.1336111 | 2021-10-22 04:21:14 | Putnam, Ohio, US | |
444455 | 444455 | 2021-10-20 | US | Indiana | Jasper | 18073 | 5301 | 79 | 0 | 41.02078733 | -87.11553319 | 2021-10-21 04:21:18 | Jasper, Indiana, US | |
2465171 | 2465171 | 2021-09-14 | US | North Carolina | Yadkin | 37197 | 5301 | 58 | 0 | 36.16222629 | -80.66239436 | 2021-09-15 03:22:37 | Yadkin, North Carolina, 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]);