johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
123 rows where confirmed = 5935 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1620741 | 1620741 | 2022-11-22 | US | Arkansas | Ashley | 5003 | 5935 | 80 | 0 | 33.19153461 | -91.7698471 | 2022-11-23 04:21:06 | Ashley, Arkansas, US | |
3027336 | 3027336 | 2022-11-17 | US | Illinois | Richland | 17159 | 5935 | 77 | 0 | 38.71240969 | -88.08475366 | 2022-11-18 04:21:15 | Richland, Illinois, US | |
434685 | 434685 | 2022-11-03 | US | Virginia | Colonial Heights | 51570 | 5935 | 107 | 0 | 37.26420587 | -77.39609676 | 2022-11-04 04:22:11 | Colonial Heights, Virginia, US | |
2968911 | 2968911 | 2022-10-10 | US | Louisiana | Concordia | 22029 | 5935 | 91 | 0 | 31.44817835 | -91.63814433 | 2022-10-11 04:23:05 | Concordia, Louisiana, US | |
3098947 | 3098947 | 2022-10-09 | US | Louisiana | Concordia | 22029 | 5935 | 91 | 0 | 31.44817835 | -91.63814433 | 2022-10-10 04:22:32 | Concordia, Louisiana, US | |
4004172 | 4004172 | 2022-10-08 | US | Louisiana | Concordia | 22029 | 5935 | 91 | 0 | 31.44817835 | -91.63814433 | 2022-10-09 04:21:16 | Concordia, Louisiana, US | |
397769 | 397769 | 2022-10-07 | US | Louisiana | Concordia | 22029 | 5935 | 91 | 0 | 31.44817835 | -91.63814433 | 2022-10-08 04:22:56 | Concordia, Louisiana, US | |
3989725 | 3989725 | 2022-09-15 | US | Texas | Gillespie | 48171 | 5935 | 113 | 0 | 30.31824095 | -98.94676915 | 2022-09-16 04:21:19 | Gillespie, Texas, US | |
1892242 | 1892242 | 2022-09-14 | US | Texas | Gillespie | 48171 | 5935 | 113 | 0 | 30.31824095 | -98.94676915 | 2022-09-15 04:21:02 | Gillespie, Texas, US | |
3767022 | 3767022 | 2022-09-11 | US | Indiana | Sullivan | 18153 | 5935 | 77 | 0 | 39.08952258 | -87.41414469 | 2022-09-12 04:20:58 | Sullivan, Indiana, US | |
3825597 | 3825597 | 2022-09-10 | US | Indiana | Sullivan | 18153 | 5935 | 77 | 0 | 39.08952258 | -87.41414469 | 2022-09-11 04:20:50 | Sullivan, Indiana, US | |
964054 | 964054 | 2022-09-09 | US | Indiana | Sullivan | 18153 | 5935 | 77 | 0 | 39.08952258 | -87.41414469 | 2022-09-10 04:21:10 | Sullivan, Indiana, US | |
2635992 | 2635992 | 2022-09-05 | US | New York | Schoharie | 36095 | 5935 | 36 | 0 | 42.58831742 | -74.4433903 | 2022-09-06 04:21:02 | Schoharie, New York, US | |
2989556 | 2989556 | 2022-09-04 | US | New York | Schoharie | 36095 | 5935 | 36 | 0 | 42.58831742 | -74.4433903 | 2022-09-05 04:21:01 | Schoharie, New York, US | |
2831818 | 2831818 | 2022-08-25 | US | Tennessee | Unicoi | 47171 | 5935 | 98 | 0 | 36.10890856 | -82.43709629 | 2022-08-26 04:21:02 | Unicoi, Tennessee, US | |
3213498 | 3213498 | 2022-07-18 | US | Texas | San Jacinto | 48407 | 5935 | 103 | 0 | 30.57933681 | -95.16260304 | 2022-07-19 04:20:58 | San Jacinto, Texas, US | |
2154665 | 2154665 | 2022-07-16 | US | Tennessee | Wayne | 47181 | 5935 | 72 | 0 | 35.23868267 | -87.78644456 | 2022-07-17 04:21:15 | Wayne, Tennessee, US | |
2421898 | 2421898 | 2022-07-15 | US | Tennessee | Wayne | 47181 | 5935 | 72 | 0 | 35.23868267 | -87.78644456 | 2022-07-16 04:21:05 | Wayne, Tennessee, US | |
3079534 | 3079534 | 2022-07-04 | US | Kentucky | Simpson | 21213 | 5935 | 95 | 0 | 36.74058474 | -86.58047435 | 2022-07-05 04:20:45 | Simpson, Kentucky, US | |
1768816 | 1768816 | 2022-07-03 | US | Kentucky | Simpson | 21213 | 5935 | 95 | 0 | 36.74058474 | -86.58047435 | 2022-07-04 04:20:54 | Simpson, Kentucky, US | |
3366802 | 3366802 | 2022-07-02 | US | Kentucky | Simpson | 21213 | 5935 | 95 | 0 | 36.74058474 | -86.58047435 | 2022-07-03 04:20:59 | Simpson, Kentucky, US | |
595131 | 595131 | 2022-07-01 | US | Kentucky | Simpson | 21213 | 5935 | 95 | 0 | 36.74058474 | -86.58047435 | 2022-07-02 04:21:16 | Simpson, Kentucky, US | |
3941532 | 3941532 | 2022-06-30 | US | Kentucky | Simpson | 21213 | 5935 | 95 | 0 | 36.74058474 | -86.58047435 | 2022-07-01 04:21:10 | Simpson, Kentucky, US | |
2491490 | 2491490 | 2022-06-29 | US | Kentucky | Simpson | 21213 | 5935 | 95 | 0 | 36.74058474 | -86.58047435 | 2022-06-30 04:21:01 | Simpson, Kentucky, US | |
2240872 | 2240872 | 2022-06-28 | US | Kentucky | Simpson | 21213 | 5935 | 95 | 0 | 36.74058474 | -86.58047435 | 2022-06-29 04:20:59 | Simpson, Kentucky, US | |
2149114 | 2149114 | 2022-06-27 | US | Kentucky | Simpson | 21213 | 5935 | 95 | 0 | 36.74058474 | -86.58047435 | 2022-06-28 04:20:58 | Simpson, Kentucky, US | |
3985628 | 3985628 | 2022-06-15 | US | Texas | Austin | 48015 | 5935 | 74 | 0 | 29.88548725 | -96.27736949 | 2022-06-16 04:20:55 | Austin, Texas, US | |
3728542 | 3728542 | 2022-06-07 | US | North Carolina | Greene | 37079 | 5935 | 67 | 0 | 35.48544173 | -77.67578087 | 2022-06-08 04:20:55 | Greene, North Carolina, US | |
3889944 | 3889944 | 2022-06-06 | US | North Carolina | Greene | 37079 | 5935 | 67 | 0 | 35.48544173 | -77.67578087 | 2022-06-07 04:21:08 | Greene, North Carolina, US | |
3509713 | 3509713 | 2022-06-05 | US | North Carolina | Greene | 37079 | 5935 | 67 | 0 | 35.48544173 | -77.67578087 | 2022-06-06 04:20:57 | Greene, North Carolina, US | |
3529790 | 3529790 | 2022-06-04 | US | North Carolina | Greene | 37079 | 5935 | 67 | 0 | 35.48544173 | -77.67578087 | 2022-06-05 04:20:55 | Greene, North Carolina, US | |
3135876 | 3135876 | 2022-06-03 | US | North Carolina | Greene | 37079 | 5935 | 67 | 0 | 35.48544173 | -77.67578087 | 2022-06-04 04:20:58 | Greene, North Carolina, US | |
3580951 | 3580951 | 2022-06-02 | US | North Carolina | Greene | 37079 | 5935 | 67 | 0 | 35.48544173 | -77.67578087 | 2022-06-03 04:20:58 | Greene, North Carolina, US | |
973244 | 973244 | 2022-06-01 | US | North Carolina | Greene | 37079 | 5935 | 67 | 0 | 35.48544173 | -77.67578087 | 2022-06-02 05:20:39 | Greene, North Carolina, US | |
230360 | 230360 | 2022-05-31 | US | Indiana | Randolph | 18135 | 5935 | 148 | 0 | 40.15734772 | -85.01139319 | 2022-06-01 04:20:55 | Randolph, Indiana, US | |
3187125 | 3187125 | 2022-05-30 | US | Indiana | Randolph | 18135 | 5935 | 148 | 0 | 40.15734772 | -85.01139319 | 2022-05-31 04:20:51 | Randolph, Indiana, US | |
3199274 | 3199274 | 2022-05-29 | US | Indiana | Randolph | 18135 | 5935 | 148 | 0 | 40.15734772 | -85.01139319 | 2022-05-30 04:20:50 | Randolph, Indiana, US | |
2726152 | 2726152 | 2022-05-28 | US | Indiana | Randolph | 18135 | 5935 | 148 | 0 | 40.15734772 | -85.01139319 | 2022-05-29 04:20:53 | Randolph, Indiana, US | |
1315333 | 1315333 | 2022-05-27 | US | Indiana | Randolph | 18135 | 5935 | 148 | 0 | 40.15734772 | -85.01139319 | 2022-05-28 04:21:07 | Randolph, Indiana, US | |
661407 | 661407 | 2022-05-13 | US | Texas | Frio | 48163 | 5935 | 93 | 0 | 28.86751206 | -99.10804207 | 2022-05-14 04:20:48 | Frio, Texas, US | |
3266025 | 3266025 | 2022-05-04 | US | Arkansas | Sevier | 5133 | 5935 | 75 | 0 | 33.99780401 | -94.2424869 | 2022-05-05 04:20:55 | Sevier, Arkansas, US | |
923274 | 923274 | 2022-03-08 | US | Wisconsin | Vernon | 55123 | 5935 | 90 | 0 | 43.59422667 | -90.8324691 | 2022-03-09 04:20:59 | Vernon, Wisconsin, US | |
1551561 | 1551561 | 2022-03-07 | US | Wisconsin | Vernon | 55123 | 5935 | 90 | 0 | 43.59422667 | -90.8324691 | 2022-03-08 04:20:54 | Vernon, Wisconsin, US | |
1994521 | 1994521 | 2022-03-01 | US | Mississippi | Wayne | 28153 | 5935 | 84 | 0 | 31.64135687 | -88.69573913 | 2022-03-02 04:21:07 | Wayne, Mississippi, US | |
462899 | 462899 | 2022-02-02 | US | West Virginia | Upshur | 54097 | 5935 | 77 | 0 | 38.89285061 | -80.23689136 | 2022-02-03 04:21:21 | Upshur, West Virginia, US | |
1780649 | 1780649 | 2022-01-27 | US | Kansas | Barton | 20009 | 5935 | 76 | 0 | 38.47889676 | -98.75636726 | 2022-01-28 04:21:09 | Barton, Kansas, US | |
1319477 | 1319477 | 2022-01-26 | US | Kansas | Barton | 20009 | 5935 | 76 | 0 | 38.47889676 | -98.75636726 | 2022-01-27 04:21:19 | Barton, Kansas, US | |
129695 | 129695 | 2022-01-09 | US | Tennessee | Lauderdale | 47097 | 5935 | 79 | 0 | 35.75893438 | -89.63015909999999 | 2022-01-10 04:22:07 | Lauderdale, Tennessee, US | |
1218031 | 1218031 | 2022-01-08 | US | Ohio | Fayette | 39047 | 5935 | 101 | 0 | 39.56021306 | -83.4562016 | 2022-01-09 04:21:46 | Fayette, Ohio, US | |
3520445 | 3520445 | 2022-01-02 | US | Illinois | Lee | 17103 | 5935 | 69 | 0 | 41.74583951 | -89.29977132 | 2022-01-03 02:22:25 | Lee, Illinois, US | |
2168575 | 2168575 | 2022-01-01 | US | Illinois | Lee | 17103 | 5935 | 69 | 0 | 41.74583951 | -89.29977132 | 2022-01-02 04:20:52 | Lee, Illinois, US | |
2778006 | 2778006 | 2021-12-31 | US | Illinois | Lee | 17103 | 5935 | 69 | 0 | 41.74583951 | -89.29977132 | 2022-01-01 04:22:14 | Lee, Illinois, US | |
3999663 | 3999663 | 2021-12-30 | US | Illinois | Lee | 17103 | 5935 | 69 | 0 | 41.74583951 | -89.29977132 | 2021-12-31 04:21:50 | Lee, Illinois, US | |
1261244 | 1261244 | 2021-12-18 | US | Ohio | Coshocton | 39031 | 5935 | 128 | 0 | 40.30096166 | -81.91729018 | 2021-12-19 04:21:11 | Coshocton, Ohio, US | |
1033006 | 1033006 | 2021-12-06 | US | Oregon | Malheur | 41045 | 5935 | 92 | 0 | 43.1937027 | -117.62273950000001 | 2021-12-07 04:22:34 | Malheur, Oregon, US | |
1147262 | 1147262 | 2021-12-01 | US | North Carolina | Jackson | 37099 | 5935 | 72 | 0 | 35.28814273 | -83.14093385 | 2021-12-02 04:22:37 | Jackson, North Carolina, US | |
3404135 | 3404135 | 2021-11-30 | US | Pennsylvania | Perry | 42099 | 5935 | 133 | 0 | 40.40206612 | -77.26297447 | 2021-12-01 04:22:29 | Perry, Pennsylvania, US | |
151457 | 151457 | 2021-11-29 | US | Kentucky | Taylor | 21217 | 5935 | 89 | 0 | 37.3677562 | -85.3329931 | 2021-11-30 04:22:53 | Taylor, Kentucky, US | |
3751635 | 3751635 | 2021-11-22 | US | Ohio | Putnam | 39137 | 5935 | 124 | 0 | 41.02094889 | -84.1336111 | 2021-11-23 04:22:39 | Putnam, Ohio, US | |
450839 | 450839 | 2021-11-17 | US | Washington | Whitman | 53075 | 5935 | 82 | 0 | 46.90022523 | -117.52417630000001 | 2021-11-18 04:21:33 | Whitman, Washington, US | |
2290066 | 2290066 | 2021-11-15 | US | Oregon | Benton | 41003 | 5935 | 35 | 0 | 44.49167306 | -123.4316987 | 2021-11-16 04:21:10 | Benton, Oregon, US | |
2289155 | 2289155 | 2021-11-15 | US | Minnesota | Becker | 27005 | 5935 | 69 | 0 | 46.93479392 | -95.67158144 | 2021-11-16 04:21:10 | Becker, Minnesota, US | |
2723246 | 2723246 | 2021-10-30 | US | New York | Livingston | 36051 | 5935 | 71 | 0 | 42.72596275 | -77.77966158 | 2021-10-31 04:22:08 | Livingston, New York, US | |
3492803 | 3492803 | 2021-10-26 | US | Colorado | La Plata | 8067 | 5935 | 56 | 0 | 37.28632032 | -107.8429014 | 2021-10-27 04:22:32 | La Plata, Colorado, US | |
2126125 | 2126125 | 2021-10-21 | US | North Carolina | Yadkin | 37197 | 5935 | 73 | 0 | 36.16222629 | -80.66239436 | 2021-10-22 04:21:14 | Yadkin, North Carolina, US | |
1909584 | 1909584 | 2021-10-17 | US | Alabama | Franklin | 1059 | 5935 | 105 | 0 | 34.44235334 | -87.84289505 | 2021-10-18 04:21:10 | Franklin, Alabama, US | |
1336789 | 1336789 | 2021-09-28 | US | Ohio | Shelby | 39149 | 5935 | 115 | 0 | 40.33163494 | -84.20258189 | 2021-09-29 04:21:45 | Shelby, Ohio, US | |
1336420 | 1336420 | 2021-09-28 | US | Nevada | Lyon | 32019 | 5935 | 89 | 0 | 39.01777974 | -119.18704790000001 | 2021-09-29 04:21:45 | Lyon, Nevada, US | |
604499 | 604499 | 2021-09-23 | US | South Carolina | Chester | 45023 | 5935 | 97 | 0 | 34.69249168 | -81.1583216 | 2021-09-24 04:21:44 | Chester, South Carolina, US | |
2465167 | 2465167 | 2021-09-14 | US | North Carolina | Watauga | 37189 | 5935 | 34 | 0 | 36.23103603 | -81.70033724 | 2021-09-15 03:22:37 | Watauga, North Carolina, US | |
642299 | 642299 | 2021-09-07 | US | Alabama | Covington | 1039 | 5935 | 150 | 0 | 31.247785399999998 | -86.45050893 | 2021-09-08 04:21:31 | Covington, Alabama, US | |
33523 | 33523 | 2021-08-25 | US | Indiana | Lawrence | 18093 | 5935 | 135 | 0 | 38.84112637 | -86.48361629 | 2021-08-26 04:21:28 | Lawrence, Indiana, US | |
2518970 | 2518970 | 2021-08-18 | US | Georgia | Effingham | 13103 | 5935 | 79 | 0 | 32.36616021 | -81.34280942 | 2021-08-19 04:21:15 | Effingham, Georgia, US | |
1117954 | 1117954 | 2021-08-06 | US | Alabama | Dale | 1045 | 5935 | 119 | 0 | 31.43037123 | -85.61095742 | 2021-08-07 04:21:30 | Dale, Alabama, US | |
3686631 | 3686631 | 2021-08-02 | US | Texas | Nacogdoches | 48347 | 5935 | 176 | 0 | 31.62017125 | -94.61803994 | 2021-08-03 04:21:39 | Nacogdoches, Texas, US | |
582364 | 582364 | 2021-07-13 | US | Wisconsin | Columbia | 55021 | 5935 | 73 | 0 | 43.46492199 | -89.33589004 | 2021-07-14 04:21:35 | Columbia, Wisconsin, US | |
2694193 | 2694193 | 2021-07-06 | US | Arkansas | Mississippi | 5093 | 5935 | 110 | 0 | 35.76271485 | -90.05194370000002 | 2021-07-07 04:21:20 | Mississippi, Arkansas, US | |
1714295 | 1714295 | 2021-06-25 | US | Missouri | Taney | 29213 | 5935 | 99 | 0 | 36.65465345 | -93.04075153 | 2021-06-26 04:21:43 | Taney, Missouri, US | |
2318599 | 2318599 | 2021-06-04 | US | Virginia | Augusta | 51015 | 5935 | 74 | 0 | 38.16404586 | -79.12461614 | 2021-06-05 04:23:03 | Augusta, Virginia, US | |
2316911 | 2316911 | 2021-06-04 | US | Michigan | Barry | 26015 | 5935 | 67 | 0 | 42.59513984 | -85.30834519 | 2021-06-05 04:23:03 | Barry, Michigan, US | |
1188530 | 1188530 | 2021-05-31 | Chile | Aysen | 5935 | 35 | 5420 | 480 | -45.9864 | -73.7669 | 2021-06-01 04:23:09 | Aysen, Chile | ||
1773004 | 1773004 | 2021-05-23 | US | Michigan | Montcalm | 26117 | 5935 | 109 | 0 | 43.31082541 | -85.15252824 | 2021-05-24 04:20:53 | Montcalm, Michigan, US | |
1771956 | 1771956 | 2021-05-23 | US | Colorado | Garfield | 8045 | 5935 | 43 | 0 | 39.59921777 | -107.902708 | 2021-05-24 04:20:53 | Garfield, Colorado, US | |
728159 | 728159 | 2021-05-22 | US | Michigan | Montcalm | 26117 | 5935 | 109 | 0 | 43.31082541 | -85.15252824 | 2021-05-23 04:20:51 | Montcalm, Michigan, US | |
1874872 | 1874872 | 2021-05-15 | US | Missouri | Lincoln | 29113 | 5935 | 42 | 0 | 39.05345619 | -90.95588181 | 2021-05-16 04:20:49 | Lincoln, Missouri, US | |
3957038 | 3957038 | 2021-05-11 | US | Oklahoma | Grady | 40051 | 5935 | 121 | 0 | 35.0167709 | -97.88339847 | 2021-05-12 04:21:29 | Grady, Oklahoma, US | |
2823317 | 2823317 | 2021-05-10 | US | Oklahoma | Grady | 40051 | 5935 | 121 | 0 | 35.0167709 | -97.88339847 | 2021-05-11 04:20:41 | Grady, Oklahoma, US | |
1427649 | 1427649 | 2021-05-09 | US | Oklahoma | Grady | 40051 | 5935 | 121 | 0 | 35.0167709 | -97.88339847 | 2021-05-10 04:20:38 | Grady, Oklahoma, US | |
1554517 | 1554517 | 2021-05-08 | US | Oklahoma | Grady | 40051 | 5935 | 121 | 0 | 35.0167709 | -97.88339847 | 2021-05-09 04:20:35 | Grady, Oklahoma, US | |
2504575 | 2504575 | 2021-05-07 | US | Oklahoma | Grady | 40051 | 5935 | 121 | 0 | 35.0167709 | -97.88339847 | 2021-05-08 04:21:04 | Grady, Oklahoma, US | |
3116031 | 3116031 | 2021-05-06 | US | Oklahoma | Grady | 40051 | 5935 | 121 | 0 | 35.0167709 | -97.88339847 | 2021-05-07 04:20:40 | Grady, Oklahoma, US | |
648498 | 648498 | 2021-05-05 | US | Oklahoma | Grady | 40051 | 5935 | 121 | 0 | 35.0167709 | -97.88339847 | 2021-05-06 04:20:38 | Grady, Oklahoma, US | |
382890 | 382890 | 2021-04-30 | US | Pennsylvania | Union | 42119 | 5935 | 86 | 0 | 40.96188846 | -77.05996014 | 2021-05-01 04:20:47 | Union, Pennsylvania, US | |
3704828 | 3704828 | 2021-04-27 | US | Puerto Rico | Caguas | 72025 | 5935 | 0 | 0 | 18.211615 | -66.050779 | 2021-04-28 04:20:32 | Caguas, Puerto Rico, US | |
3887091 | 3887091 | 2021-04-11 | US | West Virginia | Raleigh | 54081 | 5935 | 75 | 0 | 37.76936795 | -81.2456041 | 2021-04-12 04:21:00 | Raleigh, West Virginia, US | |
3665852 | 3665852 | 2021-03-09 | US | New York | Ontario | 36069 | 5935 | 90 | 0 | 42.85145728 | -77.30874425 | 2021-03-10 05:24:35 | Ontario, New York, US | |
1090774 | 1090774 | 2021-03-03 | US | Florida | Jackson | 12063 | 5935 | 151 | 0 | 5784 | 30.7954597 | -85.21500423 | 2021-03-04 05:24:24 | Jackson, Florida, US |
282430 | 282430 | 2021-02-24 | US | New York | Oswego | 36075 | 5935 | 89 | 0 | 5846 | 43.42778894 | -76.14635194 | 2021-02-25 05:24:57 | Oswego, New York, US |
1156644 | 1156644 | 2021-02-18 | US | Wisconsin | Calumet | 55015 | 5935 | 45 | 0 | 5890 | 44.0816316 | -88.21780273 | 2021-02-19 05:24:16 | Calumet, Wisconsin, US |
3980053 | 3980053 | 2021-02-10 | US | Louisiana | Acadia | 22001 | 5935 | 177 | 0 | 5758 | 30.2950649 | -92.41419698 | 2021-02-11 05:23:55 | Acadia, Louisiana, 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]);