johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
107 rows where confirmed = 5381 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2953680 | 2953680 | 2022-12-20 | US | North Carolina | Avery | 37011 | 5381 | 48 | 0 | 36.07569796 | -81.92308483 | 2022-12-21 04:21:03 | Avery, North Carolina, US | |
3176082 | 3176082 | 2022-12-19 | US | North Carolina | Avery | 37011 | 5381 | 48 | 0 | 36.07569796 | -81.92308483 | 2022-12-20 04:21:04 | Avery, North Carolina, US | |
1630599 | 1630599 | 2022-12-18 | US | North Carolina | Avery | 37011 | 5381 | 48 | 0 | 36.07569796 | -81.92308483 | 2022-12-19 04:21:03 | Avery, North Carolina, US | |
505978 | 505978 | 2022-12-17 | US | North Carolina | Avery | 37011 | 5381 | 48 | 0 | 36.07569796 | -81.92308483 | 2022-12-18 04:21:03 | Avery, North Carolina, US | |
3326550 | 3326550 | 2022-12-16 | US | North Carolina | Avery | 37011 | 5381 | 48 | 0 | 36.07569796 | -81.92308483 | 2022-12-17 04:21:04 | Avery, North Carolina, US | |
545062 | 545062 | 2022-12-15 | US | North Carolina | Avery | 37011 | 5381 | 48 | 0 | 36.07569796 | -81.92308483 | 2022-12-16 04:21:01 | Avery, North Carolina, US | |
350590 | 350590 | 2022-12-14 | US | North Carolina | Avery | 37011 | 5381 | 48 | 0 | 36.07569796 | -81.92308483 | 2022-12-15 04:20:58 | Avery, North Carolina, US | |
1965547 | 1965547 | 2022-11-30 | US | Illinois | Cass | 17017 | 5381 | 37 | 0 | 39.96991073 | -90.24734436 | 2022-12-01 04:21:03 | Cass, Illinois, US | |
1241456 | 1241456 | 2022-11-28 | US | Mississippi | Calhoun | 28013 | 5381 | 77 | 0 | 33.93683395 | -89.33686647 | 2022-11-29 04:21:05 | Calhoun, Mississippi, US | |
483080 | 483080 | 2022-11-08 | US | West Virginia | Hardy | 54031 | 5381 | 51 | 0 | 39.00683177 | -78.85855301 | 2022-11-09 04:21:22 | Hardy, West Virginia, US | |
2442230 | 2442230 | 2022-11-07 | US | West Virginia | Hardy | 54031 | 5381 | 51 | 0 | 39.00683177 | -78.85855301 | 2022-11-08 04:21:21 | Hardy, West Virginia, US | |
434863 | 434863 | 2022-11-03 | US | West Virginia | Monroe | 54063 | 5381 | 49 | 0 | 37.56274716 | -80.54577965 | 2022-11-04 04:22:11 | Monroe, West Virginia, US | |
1369466 | 1369466 | 2022-10-28 | US | Tennessee | Polk | 47139 | 5381 | 88 | 0 | 35.12245443 | -84.52075859 | 2022-10-29 04:21:13 | Polk, Tennessee, US | |
198639 | 198639 | 2022-10-19 | US | Alabama | Hale | 1065 | 5381 | 109 | 0 | 32.76039258 | -87.63284988 | 2022-10-20 04:22:59 | Hale, Alabama, US | |
2757300 | 2757300 | 2022-10-18 | US | Alabama | Hale | 1065 | 5381 | 109 | 0 | 32.76039258 | -87.63284988 | 2022-10-19 04:22:26 | Hale, Alabama, US | |
2025134 | 2025134 | 2022-10-17 | US | Alabama | Hale | 1065 | 5381 | 109 | 0 | 32.76039258 | -87.63284988 | 2022-10-18 04:22:42 | Hale, Alabama, US | |
2159912 | 2159912 | 2022-10-16 | US | Alabama | Hale | 1065 | 5381 | 109 | 0 | 32.76039258 | -87.63284988 | 2022-10-17 04:20:31 | Hale, Alabama, US | |
516109 | 516109 | 2022-10-15 | US | Alabama | Hale | 1065 | 5381 | 109 | 0 | 32.76039258 | -87.63284988 | 2022-10-16 04:22:39 | Hale, Alabama, US | |
2033166 | 2033166 | 2022-10-14 | US | Alabama | Hale | 1065 | 5381 | 109 | 0 | 32.76039258 | -87.63284988 | 2022-10-15 04:22:00 | Hale, Alabama, US | |
3753854 | 3753854 | 2022-10-13 | US | Alabama | Hale | 1065 | 5381 | 109 | 0 | 32.76039258 | -87.63284988 | 2022-10-14 04:22:28 | Hale, Alabama, US | |
3766970 | 3766970 | 2022-09-11 | US | Indiana | Fulton | 18049 | 5381 | 109 | 0 | 41.0469907 | -86.26252745 | 2022-09-12 04:20:58 | Fulton, Indiana, US | |
3825545 | 3825545 | 2022-09-10 | US | Indiana | Fulton | 18049 | 5381 | 109 | 0 | 41.0469907 | -86.26252745 | 2022-09-11 04:20:50 | Fulton, Indiana, US | |
964002 | 964002 | 2022-09-09 | US | Indiana | Fulton | 18049 | 5381 | 109 | 0 | 41.0469907 | -86.26252745 | 2022-09-10 04:21:10 | Fulton, Indiana, US | |
3746831 | 3746831 | 2022-09-07 | US | Minnesota | Fillmore | 27045 | 5381 | 27 | 0 | 43.67394126 | -92.08980382 | 2022-09-08 04:21:02 | Fillmore, Minnesota, US | |
116471 | 116471 | 2022-09-06 | US | Minnesota | Fillmore | 27045 | 5381 | 27 | 0 | 43.67394126 | -92.08980382 | 2022-09-07 04:20:59 | Fillmore, Minnesota, US | |
2635443 | 2635443 | 2022-09-05 | US | Minnesota | Fillmore | 27045 | 5381 | 27 | 0 | 43.67394126 | -92.08980382 | 2022-09-06 04:21:02 | Fillmore, Minnesota, US | |
2989007 | 2989007 | 2022-09-04 | US | Minnesota | Fillmore | 27045 | 5381 | 27 | 0 | 43.67394126 | -92.08980382 | 2022-09-05 04:21:01 | Fillmore, Minnesota, US | |
2714692 | 2714692 | 2022-09-03 | US | Minnesota | Fillmore | 27045 | 5381 | 27 | 0 | 43.67394126 | -92.08980382 | 2022-09-04 04:21:22 | Fillmore, Minnesota, US | |
1395397 | 1395397 | 2022-09-02 | US | Minnesota | Fillmore | 27045 | 5381 | 27 | 0 | 43.67394126 | -92.08980382 | 2022-09-03 04:21:04 | Fillmore, Minnesota, US | |
3549226 | 3549226 | 2022-09-01 | US | Minnesota | Fillmore | 27045 | 5381 | 27 | 0 | 43.67394126 | -92.08980382 | 2022-09-02 04:21:07 | Fillmore, Minnesota, US | |
1086956 | 1086956 | 2022-08-09 | US | Georgia | Tattnall | 13267 | 5381 | 135 | 0 | 32.04785085 | -82.05539188 | 2022-08-10 04:20:57 | Tattnall, Georgia, US | |
3544371 | 3544371 | 2022-08-08 | US | Georgia | Tattnall | 13267 | 5381 | 135 | 0 | 32.04785085 | -82.05539188 | 2022-08-09 04:20:34 | Tattnall, Georgia, US | |
1070774 | 1070774 | 2022-08-07 | US | Georgia | Tattnall | 13267 | 5381 | 135 | 0 | 32.04785085 | -82.05539188 | 2022-08-08 04:21:08 | Tattnall, Georgia, US | |
1941362 | 1941362 | 2022-08-06 | US | Georgia | Tattnall | 13267 | 5381 | 135 | 0 | 32.04785085 | -82.05539188 | 2022-08-07 04:20:54 | Tattnall, Georgia, US | |
881161 | 881161 | 2022-08-05 | US | Georgia | Tattnall | 13267 | 5381 | 135 | 0 | 32.04785085 | -82.05539188 | 2022-08-06 04:20:56 | Tattnall, Georgia, US | |
2009572 | 2009572 | 2022-08-04 | US | Georgia | Tattnall | 13267 | 5381 | 135 | 0 | 32.04785085 | -82.05539188 | 2022-08-05 04:20:52 | Tattnall, Georgia, US | |
1098999 | 1098999 | 2022-08-03 | US | Georgia | Tattnall | 13267 | 5381 | 135 | 0 | 32.04785085 | -82.05539188 | 2022-08-04 04:20:58 | Tattnall, Georgia, US | |
142452 | 142452 | 2022-07-09 | US | Arkansas | Ashley | 5003 | 5381 | 69 | 0 | 33.19153461 | -91.7698471 | 2022-07-10 04:20:54 | Ashley, Arkansas, US | |
2742151 | 2742151 | 2022-07-07 | US | Indiana | Spencer | 18147 | 5381 | 61 | 0 | 38.01519732 | -87.0079644 | 2022-07-08 04:20:56 | Spencer, Indiana, US | |
1200946 | 1200946 | 2022-07-06 | US | Indiana | Spencer | 18147 | 5381 | 61 | 0 | 38.01519732 | -87.0079644 | 2022-07-07 04:20:55 | Spencer, Indiana, US | |
1770346 | 1770346 | 2022-07-03 | US | Tennessee | Unicoi | 47171 | 5381 | 97 | 0 | 36.10890856 | -82.43709629 | 2022-07-04 04:20:54 | Unicoi, Tennessee, US | |
1424498 | 1424498 | 2022-06-08 | US | Virginia | Powhatan | 51145 | 5381 | 59 | 0 | 37.55016038 | -77.91267882 | 2022-06-09 04:20:54 | Powhatan, Virginia, US | |
1185218 | 1185218 | 2022-05-18 | US | Arkansas | Clark | 5019 | 5381 | 80 | 0 | 34.04613432 | -93.17484713 | 2022-05-19 04:20:54 | Clark, Arkansas, US | |
466139 | 466139 | 2022-05-02 | US | Puerto Rico | Guayama | 72057 | 5381 | 0 | 0 | 18.007516 | -66.133908 | 2022-05-03 04:21:00 | Guayama, Puerto Rico, US | |
3852871 | 3852871 | 2022-04-27 | US | Illinois | Union | 17181 | 5381 | 64 | 0 | 37.47119609 | -89.25548938 | 2022-04-28 04:20:47 | Union, Illinois, US | |
3241608 | 3241608 | 2022-03-21 | US | Vermont | Addison | 50001 | 5381 | 15 | 0 | 44.03217337 | -73.14130877 | 2022-03-22 04:20:54 | Addison, Vermont, US | |
1548833 | 1548833 | 2022-03-07 | US | Georgia | Pike | 13231 | 5381 | 88 | 0 | 33.09310242 | -84.38790389 | 2022-03-08 04:20:54 | Pike, Georgia, US | |
2202421 | 2202421 | 2022-03-06 | US | Puerto Rico | San Sebastian | 72131 | 5381 | 0 | 0 | 18.328646 | -66.971214 | 2022-03-07 04:20:47 | San Sebastian, Puerto Rico, US | |
2527215 | 2527215 | 2022-03-02 | US | Mississippi | Stone | 28131 | 5381 | 70 | 0 | 30.79187949 | -89.11547539 | 2022-03-03 04:21:01 | Stone, Mississippi, US | |
319009 | 319009 | 2022-02-12 | US | Texas | Frio | 48163 | 5381 | 84 | 0 | 28.86751206 | -99.10804207 | 2022-02-13 04:21:00 | Frio, Texas, US | |
1963295 | 1963295 | 2022-01-20 | US | Puerto Rico | Dorado | 72051 | 5381 | 0 | 0 | 18.436115 | -66.278669 | 2022-01-21 04:21:09 | Dorado, Puerto Rico, US | |
2610362 | 2610362 | 2022-01-06 | Sweden | Gotland | 5381 | 54 | 0 | 57.4684 | 18.4867 | 2022-01-07 04:22:09 | Gotland, Sweden | |||
1282304 | 1282304 | 2022-01-05 | Sweden | Gotland | 5381 | 54 | 0 | 57.4684 | 18.4867 | 2022-01-06 04:22:09 | Gotland, Sweden | |||
1286654 | 1286654 | 2022-01-04 | US | Colorado | Pitkin | 8097 | 5381 | 6 | 0 | 39.21720112 | -106.9310027 | 2022-01-05 04:21:59 | Pitkin, Colorado, US | |
1670058 | 1670058 | 2021-12-29 | US | Massachusetts | Franklin | 25011 | 5381 | 91 | 0 | 42.58119713 | -72.58602547 | 2021-12-30 04:21:25 | Franklin, Massachusetts, US | |
141030 | 141030 | 2021-12-04 | US | Texas | Cooke | 48097 | 5381 | 105 | 0 | 33.63979567 | -97.21240912 | 2021-12-05 04:22:25 | Cooke, Texas, US | |
724953 | 724953 | 2021-11-20 | US | Ohio | Coshocton | 39031 | 5381 | 108 | 0 | 40.30096166 | -81.91729018 | 2021-11-21 04:22:13 | Coshocton, Ohio, US | |
722888 | 722888 | 2021-11-20 | US | Alabama | Marion | 1093 | 5381 | 129 | 0 | 34.13697363 | -87.88704173 | 2021-11-21 04:22:13 | Marion, Alabama, US | |
89077 | 89077 | 2021-11-09 | US | Missouri | Pulaski | 29169 | 5381 | 80 | 0 | 37.82462075 | -92.20783203 | 2021-11-10 04:21:38 | Pulaski, Missouri, US | |
2003651 | 2003651 | 2021-11-07 | US | Tennessee | Scott | 47151 | 5381 | 61 | 0 | 36.42325673 | -84.50360494 | 2021-11-08 04:21:43 | Scott, Tennessee, US | |
287984 | 287984 | 2021-10-31 | Japan | Ehime | 5381 | 82 | 0 | 33.624835 | 132.856842 | 2021-11-01 04:22:01 | Ehime, Japan | |||
3795044 | 3795044 | 2021-10-25 | US | Indiana | Wabash | 18169 | 5381 | 104 | 0 | 40.84704239 | -85.79328272 | 2021-10-26 04:22:09 | Wabash, Indiana, US | |
601102 | 601102 | 2021-10-19 | US | Virginia | York | 51199 | 5381 | 73 | 0 | 37.24374789 | -76.54412815 | 2021-10-20 04:21:00 | York, Virginia, US | |
636755 | 636755 | 2021-10-13 | US | South Carolina | Marion | 45067 | 5381 | 134 | 0 | 34.07859748 | -79.36400756 | 2021-10-14 04:21:29 | Marion, South Carolina, US | |
1335047 | 1335047 | 2021-09-28 | US | Georgia | Chattahoochee | 13053 | 5381 | 17 | 0 | 32.34341231 | -84.78809239 | 2021-09-29 04:21:45 | Chattahoochee, Georgia, US | |
812387 | 812387 | 2021-09-20 | US | South Carolina | Colleton | 45029 | 5381 | 173 | 0 | 32.87582989 | -80.67641292 | 2021-09-21 04:21:26 | Colleton, South Carolina, US | |
1265227 | 1265227 | 2021-09-09 | US | Ohio | Ashland | 39005 | 5381 | 116 | 0 | 40.84772277 | -82.27280781 | 2021-09-10 04:21:20 | Ashland, Ohio, US | |
2280076 | 2280076 | 2021-09-08 | US | Idaho | Bingham | 16011 | 5381 | 80 | 0 | 43.21672879999999 | -112.3978437 | 2021-09-09 04:21:27 | Bingham, Idaho, US | |
2796009 | 2796009 | 2021-08-28 | US | Tennessee | Obion | 47131 | 5381 | 100 | 0 | 36.35732446 | -89.14921589 | 2021-08-29 04:21:14 | Obion, Tennessee, US | |
2923697 | 2923697 | 2021-08-27 | US | Arkansas | Miller | 5091 | 5381 | 39 | 0 | 33.31403423 | -93.89285258 | 2021-08-28 04:21:28 | Miller, Arkansas, US | |
3107830 | 3107830 | 2021-08-24 | US | North Carolina | Watauga | 37189 | 5381 | 33 | 0 | 36.23103603 | -81.70033724 | 2021-08-25 04:21:41 | Watauga, North Carolina, US | |
247567 | 247567 | 2021-08-17 | US | North Carolina | Chatham | 37037 | 5381 | 89 | 0 | 35.70394416 | -79.25541492 | 2021-08-18 04:21:35 | Chatham, North Carolina, US | |
246735 | 246735 | 2021-08-17 | US | Kentucky | Shelby | 21211 | 5381 | 79 | 0 | 38.21476019 | -85.194223 | 2021-08-18 04:21:35 | Shelby, Kentucky, US | |
3471774 | 3471774 | 2021-08-03 | US | Wyoming | Campbell | 56005 | 5381 | 64 | 0 | 44.24886082 | -105.5474404 | 2021-08-04 04:21:25 | Campbell, Wyoming, US | |
3476874 | 3476874 | 2021-07-22 | US | California | Nevada | 6057 | 5381 | 72 | 0 | 39.30394768 | -120.7627281 | 2021-07-23 04:21:29 | Nevada, California, US | |
781467 | 781467 | 2021-07-08 | US | Texas | Hardin | 48199 | 5381 | 116 | 0 | 30.33364686 | -94.38931817 | 2021-07-09 04:21:21 | Hardin, Texas, US | |
2694464 | 2694464 | 2021-07-06 | US | Georgia | Coffee | 13069 | 5381 | 179 | 0 | 31.54892966 | -82.85492059999999 | 2021-07-07 04:21:20 | Coffee, Georgia, US | |
2590280 | 2590280 | 2021-06-27 | Sierra Leone | 5381 | 94 | 3439 | 1848 | 8.460555000000001 | -11.779889 | 2021-06-28 04:21:29 | Sierra Leone | |||
108002 | 108002 | 2021-06-19 | US | California | Lassen | 6035 | 5381 | 19 | 0 | 40.67311306 | -120.59350990000002 | 2021-06-20 04:21:48 | Lassen, California, US | |
1954963 | 1954963 | 2021-05-21 | US | Ohio | Darke | 39037 | 5381 | 129 | 0 | 40.13412966 | -84.6194517 | 2021-05-22 04:20:45 | Darke, Ohio, US | |
2392385 | 2392385 | 2021-05-18 | US | Michigan | Cass | 26027 | 5381 | 76 | 0 | 41.91522292 | -85.99405727 | 2021-05-19 04:20:42 | Cass, Michigan, US | |
3957596 | 3957596 | 2021-05-11 | US | Texas | Harrison | 48203 | 5381 | 109 | 0 | 32.54935988 | -94.36934071 | 2021-05-12 04:21:29 | Harrison, Texas, US | |
383643 | 383643 | 2021-04-30 | US | Washington | Skagit | 53057 | 5381 | 67 | 0 | 48.48171488 | -121.766131 | 2021-05-01 04:20:47 | Skagit, Washington, US | |
38664 | 38664 | 2021-04-12 | US | New York | Jefferson | 36045 | 5381 | 63 | 0 | 44.04200959 | -75.94653457 | 2021-04-13 04:20:37 | Jefferson, New York, US | |
1222078 | 1222078 | 2021-03-27 | US | Ohio | Union | 39159 | 5381 | 47 | 0 | 40.30016061 | -83.37239023 | 2021-03-28 05:28:10 | Union, Ohio, US | |
354608 | 354608 | 2021-03-11 | US | North Carolina | Granville | 37077 | 5381 | 76 | 0 | 36.30337451 | -78.65184241 | 2021-03-12 05:26:50 | Granville, North Carolina, US | |
1619208 | 1619208 | 2021-03-05 | US | Tennessee | Monroe | 47123 | 5381 | 90 | 0 | 5279 | 35.44550387 | -84.24902965 | 2021-03-06 04:23:41 | Monroe, Tennessee, US |
533235 | 533235 | 2021-02-22 | US | Oklahoma | Cherokee | 40021 | 5381 | 40 | 0 | 5341 | 35.90692775 | -94.99980896 | 2021-02-23 05:23:41 | Cherokee, Oklahoma, US |
343228 | 343228 | 2021-02-03 | US | Tennessee | Lawrence | 47099 | 5381 | 75 | 0 | 5324 | 35.21675201 | -87.39787695 | 2021-02-04 05:22:26 | Lawrence, Tennessee, US |
239057 | 239057 | 2021-01-18 | US | Mississippi | Lowndes | 28087 | 5381 | 116 | 0 | 5265 | 33.47386518 | -88.44191529999998 | 2021-01-19 05:22:15 | Lowndes, Mississippi, US |
3504633 | 3504633 | 2021-01-17 | US | Kansas | Ford | 20057 | 5381 | 49 | 0 | 5332 | 37.69200114 | -99.88825298 | 2021-01-18 05:22:34 | Ford, Kansas, US |
3102716 | 3102716 | 2021-01-16 | US | Kansas | Ford | 20057 | 5381 | 49 | 0 | 5332 | 37.69200114 | -99.88825298 | 2021-01-17 05:22:17 | Ford, Kansas, US |
3516678 | 3516678 | 2021-01-15 | US | Kansas | Ford | 20057 | 5381 | 49 | 0 | 5332 | 37.69200114 | -99.88825298 | 2021-01-16 05:22:40 | Ford, Kansas, US |
2628225 | 2628225 | 2021-01-10 | US | North Carolina | Sampson | 37163 | 5381 | 69 | 0 | 5312 | 34.98820368 | -78.36914061 | 2021-01-11 05:21:50 | Sampson, North Carolina, US |
3036984 | 3036984 | 2021-01-05 | US | Pennsylvania | Northumberland | 42097 | 5381 | 241 | 0 | 5140 | 40.84785433 | -76.70798222 | 2021-01-06 05:22:16 | Northumberland, Pennsylvania, US |
1065239 | 1065239 | 2021-01-04 | US | Virginia | Roanoke City | 51770 | 5381 | 101 | 0 | 5280 | 37.27791025 | -79.96189766 | 2021-01-05 05:21:49 | Roanoke City, Virginia, US |
3232256 | 3232256 | 2021-01-03 | US | Mississippi | Jones | 28067 | 5381 | 98 | 0 | 5283 | 31.62257767 | -89.16896899999998 | 2021-01-04 05:22:02 | Jones, Mississippi, US |
3772588 | 3772588 | 2020-12-22 | US | Puerto Rico | Bayamon | 72021 | 5381 | 0 | 0 | 5381 | 18.34946 | -66.168435 | 2020-12-23 05:22:03 | Bayamon, Puerto Rico, US |
1034678 | 1034678 | 2020-12-15 | Suriname | 5381 | 117 | 5231 | 33 | 3.9193 | -56.0278 | 2020-12-16 05:28:04 | Suriname | |||
1818776 | 1818776 | 2020-12-08 | Italy | Molise | 5381 | 144 | 2711 | 2526 | 41.55774754 | 14.65916051 | 2020-12-09 05:28:01 | Molise, Italy |
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]);