johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
130 rows where confirmed = 5840 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2557729 | 2557729 | 2022-11-29 | US | Indiana | Spencer | 18147 | 5840 | 62 | 0 | 38.01519732 | -87.0079644 | 2022-11-30 04:21:07 | Spencer, Indiana, US | |
1240803 | 1240803 | 2022-11-28 | US | Indiana | Spencer | 18147 | 5840 | 62 | 0 | 38.01519732 | -87.0079644 | 2022-11-29 04:21:05 | Spencer, Indiana, US | |
3552791 | 3552791 | 2022-11-27 | US | Indiana | Spencer | 18147 | 5840 | 62 | 0 | 38.01519732 | -87.0079644 | 2022-11-28 04:21:02 | Spencer, Indiana, US | |
2101271 | 2101271 | 2022-11-26 | US | Indiana | Spencer | 18147 | 5840 | 62 | 0 | 38.01519732 | -87.0079644 | 2022-11-27 04:21:05 | Spencer, Indiana, US | |
488762 | 488762 | 2022-11-25 | US | Indiana | Spencer | 18147 | 5840 | 62 | 0 | 38.01519732 | -87.0079644 | 2022-11-26 04:21:11 | Spencer, Indiana, US | |
3524591 | 3524591 | 2022-11-24 | US | Indiana | Spencer | 18147 | 5840 | 62 | 0 | 38.01519732 | -87.0079644 | 2022-11-25 04:21:06 | Spencer, Indiana, US | |
3313374 | 3313374 | 2022-11-23 | US | Indiana | Spencer | 18147 | 5840 | 62 | 0 | 38.01519732 | -87.0079644 | 2022-11-24 04:21:09 | Spencer, Indiana, US | |
1758261 | 1758261 | 2022-11-18 | US | Tennessee | Johnson | 47091 | 5840 | 106 | 0 | 36.4552395 | -81.84886538 | 2022-11-19 04:21:14 | Johnson, Tennessee, US | |
292406 | 292406 | 2022-11-15 | US | Alabama | Marengo | 1091 | 5840 | 114 | 0 | 32.24767634 | -87.78796182 | 2022-11-16 04:21:09 | Marengo, Alabama, US | |
3597436 | 3597436 | 2022-11-14 | US | Alabama | Marengo | 1091 | 5840 | 114 | 0 | 32.24767634 | -87.78796182 | 2022-11-15 04:21:16 | Marengo, Alabama, US | |
312294 | 312294 | 2022-11-13 | US | Alabama | Marengo | 1091 | 5840 | 114 | 0 | 32.24767634 | -87.78796182 | 2022-11-14 04:21:09 | Marengo, Alabama, US | |
63455 | 63455 | 2022-11-12 | US | Alabama | Marengo | 1091 | 5840 | 114 | 0 | 32.24767634 | -87.78796182 | 2022-11-13 04:21:14 | Marengo, Alabama, US | |
2927617 | 2927617 | 2022-11-11 | US | Alabama | Marengo | 1091 | 5840 | 114 | 0 | 32.24767634 | -87.78796182 | 2022-11-12 04:20:41 | Marengo, Alabama, US | |
2506453 | 2506453 | 2022-11-10 | US | Alabama | Marengo | 1091 | 5840 | 114 | 0 | 32.24767634 | -87.78796182 | 2022-11-11 04:21:22 | Marengo, Alabama, US | |
322704 | 322704 | 2022-10-30 | US | Puerto Rico | Orocovis | 72107 | 5840 | 0 | 0 | 18.215046 | -66.433604 | 2022-10-31 04:21:36 | Orocovis, Puerto Rico, US | |
2770556 | 2770556 | 2022-09-26 | US | Maryland | Somerset | 24039 | 5840 | 77 | 0 | 38.1163542 | -75.75118623 | 2022-09-27 04:23:01 | Somerset, Maryland, US | |
1373972 | 1373972 | 2022-09-21 | US | West Virginia | Brooke | 54009 | 5840 | 106 | 0 | 40.27367263 | -80.57915332 | 2022-09-22 04:22:56 | Brooke, West Virginia, US | |
1163437 | 1163437 | 2022-08-18 | US | New York | Schoharie | 36095 | 5840 | 36 | 0 | 42.58831742 | -74.4433903 | 2022-08-19 04:20:54 | Schoharie, New York, US | |
2497131 | 2497131 | 2022-08-15 | US | Texas | Gillespie | 48171 | 5840 | 110 | 0 | 30.31824095 | -98.94676915 | 2022-08-16 04:20:58 | Gillespie, Texas, US | |
1099925 | 1099925 | 2022-08-03 | US | Mississippi | Grenada | 28043 | 5840 | 132 | 0 | 33.77036166 | -89.80245083 | 2022-08-04 04:20:58 | Grenada, Mississippi, US | |
1406850 | 1406850 | 2022-08-02 | US | Mississippi | Grenada | 28043 | 5840 | 132 | 0 | 33.77036166 | -89.80245083 | 2022-08-03 04:20:59 | Grenada, Mississippi, US | |
3618888 | 3618888 | 2022-08-01 | US | Mississippi | Grenada | 28043 | 5840 | 132 | 0 | 33.77036166 | -89.80245083 | 2022-08-02 04:20:53 | Grenada, Mississippi, US | |
3873368 | 3873368 | 2022-07-31 | US | Mississippi | Grenada | 28043 | 5840 | 132 | 0 | 33.77036166 | -89.80245083 | 2022-08-01 04:21:03 | Grenada, Mississippi, US | |
676122 | 676122 | 2022-07-30 | US | Mississippi | Grenada | 28043 | 5840 | 132 | 0 | 33.77036166 | -89.80245083 | 2022-07-31 04:21:02 | Grenada, Mississippi, US | |
1785321 | 1785321 | 2022-07-29 | US | Mississippi | Grenada | 28043 | 5840 | 132 | 0 | 33.77036166 | -89.80245083 | 2022-07-30 04:20:42 | Grenada, Mississippi, US | |
1067684 | 1067684 | 2022-07-28 | US | Mississippi | Grenada | 28043 | 5840 | 132 | 0 | 33.77036166 | -89.80245083 | 2022-07-29 04:20:45 | Grenada, Mississippi, US | |
2337203 | 2337203 | 2022-07-27 | US | Mississippi | Grenada | 28043 | 5840 | 132 | 0 | 33.77036166 | -89.80245083 | 2022-07-28 04:20:56 | Grenada, Mississippi, US | |
1489393 | 1489393 | 2022-07-26 | US | Mississippi | Grenada | 28043 | 5840 | 132 | 0 | 33.77036166 | -89.80245083 | 2022-07-27 04:21:04 | Grenada, Mississippi, US | |
2595839 | 2595839 | 2022-07-25 | US | Mississippi | Grenada | 28043 | 5840 | 132 | 0 | 33.77036166 | -89.80245083 | 2022-07-26 04:20:58 | Grenada, Mississippi, US | |
3081244 | 3081244 | 2022-07-04 | US | Texas | Moore | 48341 | 5840 | 111 | 0 | 35.83769242 | -101.8930281 | 2022-07-05 04:20:45 | Moore, Texas, US | |
1770526 | 1770526 | 2022-07-03 | US | Texas | Moore | 48341 | 5840 | 111 | 0 | 35.83769242 | -101.8930281 | 2022-07-04 04:20:54 | Moore, Texas, US | |
3368512 | 3368512 | 2022-07-02 | US | Texas | Moore | 48341 | 5840 | 111 | 0 | 35.83769242 | -101.8930281 | 2022-07-03 04:20:59 | Moore, Texas, US | |
596841 | 596841 | 2022-07-01 | US | Texas | Moore | 48341 | 5840 | 111 | 0 | 35.83769242 | -101.8930281 | 2022-07-02 04:21:16 | Moore, Texas, US | |
596376 | 596376 | 2022-07-01 | US | Puerto Rico | Aguas Buenas | 72007 | 5840 | 0 | 0 | 18.251619 | -66.126806 | 2022-07-02 04:21:16 | Aguas Buenas, Puerto Rico, US | |
3943242 | 3943242 | 2022-06-30 | US | Texas | Moore | 48341 | 5840 | 111 | 0 | 35.83769242 | -101.8930281 | 2022-07-01 04:21:10 | Moore, Texas, US | |
623413 | 623413 | 2022-05-22 | US | Louisiana | St. James | 22093 | 5840 | 77 | 0 | 30.02531716 | -90.80212061 | 2022-05-26 04:20:50 | St. James, Louisiana, US | |
1111109 | 1111109 | 2022-05-21 | US | Louisiana | St. James | 22093 | 5840 | 77 | 0 | 30.02531716 | -90.80212061 | 2022-05-22 04:20:52 | St. James, Louisiana, US | |
1170733 | 1170733 | 2022-05-20 | US | Louisiana | St. James | 22093 | 5840 | 77 | 0 | 30.02531716 | -90.80212061 | 2022-05-21 04:20:58 | St. James, Louisiana, US | |
2084602 | 2084602 | 2022-05-15 | US | Colorado | Morgan | 8087 | 5840 | 138 | 0 | 40.2627981 | -103.8093302 | 2022-05-16 04:20:47 | Morgan, Colorado, US | |
3854956 | 3854956 | 2022-04-27 | US | Texas | Karnes | 48255 | 5840 | 70 | 0 | 28.90705334 | -97.85960149 | 2022-04-28 04:20:47 | Karnes, Texas, US | |
1908122 | 1908122 | 2022-03-22 | US | Tennessee | Chester | 47023 | 5840 | 96 | 0 | 35.42527478 | -88.6095842 | 2022-03-23 04:20:48 | Chester, Tennessee, US | |
2320441 | 2320441 | 2022-03-16 | US | Indiana | LaGrange | 18087 | 5840 | 100 | 0 | 41.64232188 | -85.42674232 | 2022-03-17 04:20:56 | LaGrange, Indiana, US | |
262641 | 262641 | 2022-03-15 | US | Indiana | LaGrange | 18087 | 5840 | 100 | 0 | 41.64232188 | -85.42674232 | 2022-03-16 04:20:50 | LaGrange, Indiana, US | |
2265000 | 2265000 | 2022-03-14 | US | Indiana | LaGrange | 18087 | 5840 | 100 | 0 | 41.64232188 | -85.42674232 | 2022-03-15 04:20:47 | LaGrange, Indiana, US | |
1995523 | 1995523 | 2022-03-01 | US | South Dakota | Davison | 46035 | 5840 | 77 | 0 | 43.67490933 | -98.14458906 | 2022-03-02 04:21:07 | Davison, South Dakota, US | |
944256 | 944256 | 2022-02-28 | US | Kentucky | Johnson | 21115 | 5840 | 95 | 0 | 37.85106355 | -82.8264322 | 2022-03-01 04:21:09 | Johnson, Kentucky, US | |
2735078 | 2735078 | 2022-02-27 | US | Nebraska | Cass | 31025 | 5840 | 16 | 0 | 40.90899107 | -96.13971217 | 2022-02-28 04:21:05 | Cass, Nebraska, US | |
3048231 | 3048231 | 2022-02-26 | US | Nebraska | Cass | 31025 | 5840 | 16 | 0 | 40.90899107 | -96.13971217 | 2022-02-27 04:21:04 | Cass, Nebraska, US | |
576886 | 576886 | 2022-02-25 | US | Nebraska | Cass | 31025 | 5840 | 16 | 0 | 40.90899107 | -96.13971217 | 2022-02-26 04:21:12 | Cass, Nebraska, US | |
1059903 | 1059903 | 2022-02-23 | US | Nebraska | Cass | 31025 | 5840 | 16 | 0 | 40.90899107 | -96.13971217 | 2022-02-24 04:21:14 | Cass, Nebraska, US | |
188983 | 188983 | 2022-02-13 | US | South Dakota | Yankton | 46135 | 5840 | 51 | 0 | 43.00924485 | -97.39467635 | 2022-02-14 04:20:51 | Yankton, South Dakota, US | |
318829 | 318829 | 2022-02-12 | US | South Dakota | Yankton | 46135 | 5840 | 51 | 0 | 43.00924485 | -97.39467635 | 2022-02-13 04:21:00 | Yankton, South Dakota, US | |
236155 | 236155 | 2022-02-11 | US | South Dakota | Yankton | 46135 | 5840 | 51 | 0 | 43.00924485 | -97.39467635 | 2022-02-12 04:21:06 | Yankton, South Dakota, US | |
3076334 | 3076334 | 2022-02-09 | US | North Carolina | Ashe | 37009 | 5840 | 68 | 0 | 36.43296207 | -81.49862729 | 2022-02-10 04:21:14 | Ashe, North Carolina, US | |
462480 | 462480 | 2022-02-02 | US | Texas | Gray | 48179 | 5840 | 110 | 0 | 35.40081878 | -100.8129222 | 2022-02-03 04:21:21 | Gray, Texas, US | |
1695780 | 1695780 | 2022-01-10 | US | Washington | Stevens | 53065 | 5840 | 116 | 0 | 48.40035475 | -117.8542701 | 2022-01-11 04:22:01 | Stevens, Washington, US | |
127123 | 127123 | 2022-01-09 | US | Alabama | Marion | 1093 | 5840 | 132 | 0 | 34.13697363 | -87.88704173 | 2022-01-10 04:22:07 | Marion, Alabama, US | |
1702093 | 1702093 | 2022-01-03 | US | Minnesota | Mille Lacs | 27095 | 5840 | 93 | 0 | 45.93705297 | -93.63236823 | 2022-01-04 04:22:17 | Mille Lacs, Minnesota, US | |
732767 | 732767 | 2021-12-27 | US | New York | Greene | 36039 | 5840 | 95 | 0 | 42.275797 | -74.12384884 | 2021-12-28 04:21:47 | Greene, New York, US | |
3499776 | 3499776 | 2021-12-15 | US | Wisconsin | Trempealeau | 55121 | 5840 | 52 | 0 | 44.30360275 | -91.35893614 | 2021-12-16 04:22:11 | Trempealeau, Wisconsin, US | |
3497754 | 3497754 | 2021-12-15 | US | Maine | Somerset | 23025 | 5840 | 67 | 0 | 45.51229767 | -69.95995554 | 2021-12-16 04:22:11 | Somerset, Maine, US | |
784894 | 784894 | 2021-12-13 | US | Ohio | Perry | 39127 | 5840 | 92 | 0 | 39.73508655 | -82.23804971 | 2021-12-14 04:22:38 | Perry, Ohio, US | |
1081354 | 1081354 | 2021-12-09 | US | Virginia | York | 51199 | 5840 | 83 | 0 | 37.24374789 | -76.54412815 | 2021-12-10 04:22:28 | York, Virginia, US | |
1233996 | 1233996 | 2021-11-28 | US | North Carolina | Scotland | 37165 | 5840 | 109 | 0 | 34.8386299 | -79.4757978 | 2021-11-29 04:22:30 | Scotland, North Carolina, US | |
1360703 | 1360703 | 2021-11-27 | US | North Carolina | Scotland | 37165 | 5840 | 109 | 0 | 34.8386299 | -79.4757978 | 2021-11-28 04:22:43 | Scotland, North Carolina, US | |
760694 | 760694 | 2021-11-26 | US | North Carolina | Scotland | 37165 | 5840 | 109 | 0 | 34.8386299 | -79.4757978 | 2021-11-27 04:22:45 | Scotland, North Carolina, US | |
1805111 | 1805111 | 2021-11-25 | US | North Carolina | Scotland | 37165 | 5840 | 109 | 0 | 34.8386299 | -79.4757978 | 2021-11-26 04:22:33 | Scotland, North Carolina, US | |
906545 | 906545 | 2021-11-24 | US | North Carolina | Scotland | 37165 | 5840 | 109 | 0 | 34.8386299 | -79.4757978 | 2021-11-25 04:22:33 | Scotland, North Carolina, US | |
2290379 | 2290379 | 2021-11-15 | US | Tennessee | Carroll | 47017 | 5840 | 104 | 0 | 35.97366108 | -88.45189331 | 2021-11-16 04:21:10 | Carroll, Tennessee, US | |
699914 | 699914 | 2021-11-04 | US | Louisiana | Iberville | 22047 | 5840 | 125 | 0 | 30.25734305 | -91.3499598 | 2021-11-05 04:21:54 | Iberville, Louisiana, US | |
287906 | 287906 | 2021-10-31 | Grenada | 5840 | 198 | 0 | 12.1165 | -61.678999999999995 | 2021-11-01 04:22:01 | Grenada | ||||
2720912 | 2720912 | 2021-10-30 | Grenada | 5840 | 198 | 0 | 12.1165 | -61.678999999999995 | 2021-10-31 04:22:08 | Grenada | ||||
684793 | 684793 | 2021-10-24 | US | Ohio | Clinton | 39027 | 5840 | 108 | 0 | 39.41485808 | -83.80852286 | 2021-10-25 04:22:31 | Clinton, Ohio, US | |
1912550 | 1912550 | 2021-10-17 | US | Virginia | Franklin | 51067 | 5840 | 98 | 0 | 36.99536167 | -79.88023649 | 2021-10-18 04:21:10 | Franklin, Virginia, US | |
938139 | 938139 | 2021-10-16 | US | Virginia | Franklin | 51067 | 5840 | 98 | 0 | 36.99536167 | -79.88023649 | 2021-10-17 04:21:29 | Franklin, Virginia, US | |
2946694 | 2946694 | 2021-10-15 | US | Virginia | Franklin | 51067 | 5840 | 98 | 0 | 36.99536167 | -79.88023649 | 2021-10-16 04:21:15 | Franklin, Virginia, US | |
1493984 | 1493984 | 2021-10-12 | US | North Carolina | Yadkin | 37197 | 5840 | 70 | 0 | 36.16222629 | -80.66239436 | 2021-10-13 04:20:51 | Yadkin, North Carolina, US | |
3833497 | 3833497 | 2021-10-05 | US | Illinois | Livingston | 17105 | 5840 | 97 | 0 | 40.89188292 | -88.55784752 | 2021-10-06 04:21:33 | Livingston, Illinois, US | |
1817214 | 1817214 | 2021-09-19 | US | Ohio | Ashland | 39005 | 5840 | 121 | 0 | 40.84772277 | -82.27280781 | 2021-09-20 04:21:22 | Ashland, Ohio, US | |
1388056 | 1388056 | 2021-09-13 | US | North Dakota | Stark | 38089 | 5840 | 52 | 0 | 46.80851182 | -102.65763259999999 | 2021-09-14 04:21:41 | Stark, North Dakota, US | |
2519083 | 2519083 | 2021-08-18 | US | Hawaii | Hawaii | 15001 | 5840 | 59 | 0 | 19.60121157 | -155.5210167 | 2021-08-19 04:21:15 | Hawaii, Hawaii, US | |
2353657 | 2353657 | 2021-08-10 | US | New York | Cattaraugus | 36009 | 5840 | 93 | 0 | 42.24778241 | -78.67923096 | 2021-08-11 04:21:58 | Cattaraugus, New York, US | |
2352441 | 2352441 | 2021-08-10 | US | Illinois | Knox | 17095 | 5840 | 157 | 0 | 40.93148779 | -90.21330340000002 | 2021-08-11 04:21:58 | Knox, Illinois, US | |
3744374 | 3744374 | 2021-07-12 | US | Virginia | Albemarle | 51003 | 5840 | 85 | 0 | 38.02080697 | -78.55481085 | 2021-07-13 04:21:18 | Albemarle, Virginia, US | |
3662887 | 3662887 | 2021-07-11 | US | Virginia | Albemarle | 51003 | 5840 | 85 | 0 | 38.02080697 | -78.55481085 | 2021-07-12 04:21:34 | Albemarle, Virginia, US | |
3662219 | 3662219 | 2021-07-11 | US | Oregon | Linn | 41043 | 5840 | 81 | 0 | 44.48899494 | -122.5373154 | 2021-07-12 04:21:34 | Linn, Oregon, US | |
628503 | 628503 | 2021-07-10 | US | Oregon | Linn | 41043 | 5840 | 81 | 0 | 44.48899494 | -122.5373154 | 2021-07-11 04:21:43 | Linn, Oregon, US | |
832222 | 832222 | 2021-07-09 | US | Oregon | Linn | 41043 | 5840 | 81 | 0 | 44.48899494 | -122.5373154 | 2021-07-10 04:21:25 | Linn, Oregon, US | |
779901 | 779901 | 2021-07-08 | US | Louisiana | Vermilion | 22113 | 5840 | 126 | 0 | 29.83517605 | -92.30292538 | 2021-07-09 04:21:21 | Vermilion, Louisiana, US | |
2764704 | 2764704 | 2021-07-01 | Canada | Nova Scotia | 5840 | 92 | 5697 | 51 | 44.682 | -63.7443 | 2021-07-02 04:21:47 | Nova Scotia, Canada | ||
3959751 | 3959751 | 2021-06-26 | US | Iowa | Warren | 19181 | 5840 | 92 | 0 | 41.33559454 | -93.56007641 | 2021-06-27 04:21:39 | Warren, Iowa, US | |
2424134 | 2424134 | 2021-06-23 | US | Iowa | Warren | 19181 | 5840 | 91 | 0 | 41.33559454 | -93.56007641 | 2021-06-24 04:21:55 | Warren, Iowa, US | |
3359913 | 3359913 | 2021-06-21 | US | Iowa | Warren | 19181 | 5840 | 91 | 0 | 41.33559454 | -93.56007641 | 2021-06-22 04:21:34 | Warren, Iowa, US | |
2392379 | 2392379 | 2021-05-18 | US | Michigan | Barry | 26015 | 5840 | 65 | 0 | 42.59513984 | -85.30834519 | 2021-05-19 04:20:42 | Barry, Michigan, US | |
2823774 | 2823774 | 2021-05-10 | US | Texas | Anderson | 48001 | 5840 | 121 | 0 | 31.81534745 | -95.65354823 | 2021-05-11 04:20:41 | Anderson, Texas, US | |
1428106 | 1428106 | 2021-05-09 | US | Texas | Anderson | 48001 | 5840 | 121 | 0 | 31.81534745 | -95.65354823 | 2021-05-10 04:20:38 | Anderson, Texas, US | |
1554974 | 1554974 | 2021-05-08 | US | Texas | Anderson | 48001 | 5840 | 121 | 0 | 31.81534745 | -95.65354823 | 2021-05-09 04:20:35 | Anderson, Texas, US | |
3115185 | 3115185 | 2021-05-06 | US | Minnesota | Chisago | 27025 | 5840 | 51 | 0 | 45.5021011 | -92.90861945 | 2021-05-07 04:20:40 | Chisago, Minnesota, US | |
958385 | 958385 | 2021-04-25 | US | Wisconsin | Barron | 55005 | 5840 | 77 | 0 | 45.42372701 | -91.84833627 | 2021-04-26 04:21:04 | Barron, Wisconsin, US | |
3926729 | 3926729 | 2021-04-24 | US | Puerto Rico | Caguas | 72025 | 5840 | 0 | 0 | 18.211615 | -66.050779 | 2021-04-25 04:20:32 | Caguas, Puerto Rico, 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]);