johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
79 rows where confirmed = 8376 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 8
- US 72
- Haiti 1
- Italy 1
- Japan 1
- Luxembourg 1
- Mali 1
- Netherlands 1
- Russia 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
295384 | 295384 | 2022-11-15 | US | Virginia | Louisa | 51109 | 8376 | 93 | 0 | 37.97850256 | -77.96274807 | 2022-11-16 04:21:09 | Louisa, Virginia, US | |
3598742 | 3598742 | 2022-11-14 | US | Michigan | Wexford | 26165 | 8376 | 121 | 0 | 44.33853602 | -85.57712739 | 2022-11-15 04:21:16 | Wexford, Michigan, US | |
313600 | 313600 | 2022-11-13 | US | Michigan | Wexford | 26165 | 8376 | 121 | 0 | 44.33853602 | -85.57712739 | 2022-11-14 04:21:09 | Wexford, Michigan, US | |
64761 | 64761 | 2022-11-12 | US | Michigan | Wexford | 26165 | 8376 | 121 | 0 | 44.33853602 | -85.57712739 | 2022-11-13 04:21:14 | Wexford, Michigan, US | |
2928923 | 2928923 | 2022-11-11 | US | Michigan | Wexford | 26165 | 8376 | 121 | 0 | 44.33853602 | -85.57712739 | 2022-11-12 04:20:41 | Wexford, Michigan, US | |
2507759 | 2507759 | 2022-11-10 | US | Michigan | Wexford | 26165 | 8376 | 121 | 0 | 44.33853602 | -85.57712739 | 2022-11-11 04:21:22 | Wexford, Michigan, US | |
2432634 | 2432634 | 2022-11-09 | US | Michigan | Wexford | 26165 | 8376 | 121 | 0 | 44.33853602 | -85.57712739 | 2022-11-10 04:21:16 | Wexford, Michigan, US | |
713950 | 713950 | 2022-11-01 | US | West Virginia | Mason | 54053 | 8376 | 104 | 0 | 38.77071799 | -82.02524219 | 2022-11-02 04:22:09 | Mason, West Virginia, US | |
3995718 | 3995718 | 2022-09-27 | US | Indiana | Daviess | 18027 | 8376 | 156 | 0 | 38.70186039 | -87.07185406 | 2022-09-28 04:23:01 | Daviess, Indiana, US | |
2770046 | 2770046 | 2022-09-26 | US | Indiana | Daviess | 18027 | 8376 | 156 | 0 | 38.70186039 | -87.07185406 | 2022-09-27 04:23:01 | Daviess, Indiana, US | |
2635355 | 2635355 | 2022-09-05 | US | Michigan | Dickinson | 26043 | 8376 | 116 | 0 | 46.00999672 | -87.86961634 | 2022-09-06 04:21:02 | Dickinson, Michigan, US | |
2988919 | 2988919 | 2022-09-04 | US | Michigan | Dickinson | 26043 | 8376 | 116 | 0 | 46.00999672 | -87.86961634 | 2022-09-05 04:21:01 | Dickinson, Michigan, US | |
2714604 | 2714604 | 2022-09-03 | US | Michigan | Dickinson | 26043 | 8376 | 116 | 0 | 46.00999672 | -87.86961634 | 2022-09-04 04:21:22 | Dickinson, Michigan, US | |
1395309 | 1395309 | 2022-09-02 | US | Michigan | Dickinson | 26043 | 8376 | 116 | 0 | 46.00999672 | -87.86961634 | 2022-09-03 04:21:04 | Dickinson, Michigan, US | |
3549138 | 3549138 | 2022-09-01 | US | Michigan | Dickinson | 26043 | 8376 | 116 | 0 | 46.00999672 | -87.86961634 | 2022-09-02 04:21:07 | Dickinson, Michigan, US | |
2345058 | 2345058 | 2022-08-31 | US | Michigan | Dickinson | 26043 | 8376 | 116 | 0 | 46.00999672 | -87.86961634 | 2022-09-01 04:21:03 | Dickinson, Michigan, US | |
2497155 | 2497155 | 2022-08-15 | US | Texas | Hockley | 48219 | 8376 | 164 | 0 | 33.60771256 | -102.3431676 | 2022-08-16 04:20:58 | Hockley, Texas, US | |
973874 | 973874 | 2022-06-01 | US | Tennessee | Henry | 47079 | 8376 | 164 | 0 | 36.33160906 | -88.30121797 | 2022-06-02 05:20:39 | Henry, Tennessee, US | |
2752475 | 2752475 | 2022-04-04 | US | Wisconsin | Trempealeau | 55121 | 8376 | 63 | 0 | 44.30360275 | -91.35893614 | 2022-04-05 04:20:48 | Trempealeau, Wisconsin, US | |
3731739 | 3731739 | 2022-04-03 | US | Louisiana | Evangeline | 22039 | 8376 | 156 | 0 | 30.72985248 | -92.39915924 | 2022-04-04 04:20:51 | Evangeline, Louisiana, US | |
501174 | 501174 | 2022-04-02 | US | Louisiana | Evangeline | 22039 | 8376 | 156 | 0 | 30.72985248 | -92.39915924 | 2022-04-03 04:20:48 | Evangeline, Louisiana, US | |
3352159 | 3352159 | 2022-04-01 | US | Louisiana | Evangeline | 22039 | 8376 | 156 | 0 | 30.72985248 | -92.39915924 | 2022-04-02 04:20:47 | Evangeline, Louisiana, US | |
1541464 | 1541464 | 2022-03-31 | US | Louisiana | Evangeline | 22039 | 8376 | 156 | 0 | 30.72985248 | -92.39915924 | 2022-04-01 04:20:28 | Evangeline, Louisiana, US | |
2479477 | 2479477 | 2022-03-30 | US | Louisiana | Evangeline | 22039 | 8376 | 156 | 0 | 30.72985248 | -92.39915924 | 2022-03-31 04:20:56 | Evangeline, Louisiana, US | |
159518 | 159518 | 2022-03-29 | US | Louisiana | Evangeline | 22039 | 8376 | 156 | 0 | 30.72985248 | -92.39915924 | 2022-03-30 04:20:45 | Evangeline, Louisiana, US | |
1438089 | 1438089 | 2022-03-28 | US | Louisiana | Evangeline | 22039 | 8376 | 156 | 0 | 30.72985248 | -92.39915924 | 2022-03-29 04:20:46 | Evangeline, Louisiana, US | |
877770 | 877770 | 2022-03-27 | US | Louisiana | Evangeline | 22039 | 8376 | 156 | 0 | 30.72985248 | -92.39915924 | 2022-03-28 04:20:33 | Evangeline, Louisiana, US | |
2165053 | 2165053 | 2022-03-26 | US | Louisiana | Evangeline | 22039 | 8376 | 156 | 0 | 30.72985248 | -92.39915924 | 2022-03-27 04:20:47 | Evangeline, Louisiana, US | |
1721989 | 1721989 | 2022-03-25 | US | Louisiana | Evangeline | 22039 | 8376 | 156 | 0 | 30.72985248 | -92.39915924 | 2022-03-26 04:20:23 | Evangeline, Louisiana, US | |
1469606 | 1469606 | 2022-03-24 | US | Louisiana | Evangeline | 22039 | 8376 | 156 | 0 | 30.72985248 | -92.39915924 | 2022-03-25 04:20:46 | Evangeline, Louisiana, US | |
1467579 | 1467579 | 2022-02-10 | US | West Virginia | Marshall | 54051 | 8376 | 145 | 0 | 39.86064362 | -80.66591062 | 2022-02-11 04:21:09 | Marshall, West Virginia, US | |
2835838 | 2835838 | 2022-01-22 | US | Tennessee | Weakley | 47183 | 8376 | 110 | 0 | 36.29896232 | -88.71990865 | 2022-01-23 04:21:13 | Weakley, Tennessee, US | |
1218027 | 1218027 | 2022-01-08 | US | Ohio | Defiance | 39039 | 8376 | 145 | 0 | 41.32398837 | -84.49076944 | 2022-01-09 04:21:46 | Defiance, Ohio, US | |
732844 | 732844 | 2021-12-27 | US | North Carolina | Edgecombe | 37065 | 8376 | 127 | 0 | 35.91230639 | -77.59436892 | 2021-12-28 04:21:47 | Edgecombe, North Carolina, US | |
2114016 | 2114016 | 2021-12-26 | US | North Carolina | Edgecombe | 37065 | 8376 | 127 | 0 | 35.91230639 | -77.59436892 | 2021-12-27 04:21:58 | Edgecombe, North Carolina, US | |
3607388 | 3607388 | 2021-12-25 | US | North Carolina | Edgecombe | 37065 | 8376 | 127 | 0 | 35.91230639 | -77.59436892 | 2021-12-26 04:21:50 | Edgecombe, North Carolina, US | |
2965706 | 2965706 | 2021-12-24 | US | North Carolina | Edgecombe | 37065 | 8376 | 127 | 0 | 35.91230639 | -77.59436892 | 2021-12-25 04:21:37 | Edgecombe, North Carolina, US | |
3818738 | 3818738 | 2021-12-23 | US | North Carolina | Edgecombe | 37065 | 8376 | 127 | 0 | 35.91230639 | -77.59436892 | 2021-12-24 04:21:34 | Edgecombe, North Carolina, US | |
800746 | 800746 | 2021-12-22 | US | North Carolina | Edgecombe | 37065 | 8376 | 127 | 0 | 35.91230639 | -77.59436892 | 2021-12-23 04:21:21 | Edgecombe, North Carolina, US | |
2847366 | 2847366 | 2021-11-10 | US | Ohio | Sandusky | 39143 | 8376 | 167 | 0 | 41.35624126 | -83.137872 | 2021-11-11 04:21:45 | Sandusky, Ohio, US | |
3640674 | 3640674 | 2021-11-08 | US | Indiana | Noble | 18113 | 8376 | 110 | 0 | 41.39672484 | -85.41966713 | 2021-11-09 04:21:36 | Noble, Indiana, US | |
3514588 | 3514588 | 2021-11-01 | US | Texas | Nacogdoches | 48347 | 8376 | 227 | 0 | 31.62017125 | -94.61803994 | 2021-11-02 04:22:03 | Nacogdoches, Texas, US | |
291179 | 291179 | 2021-10-31 | US | Texas | Nacogdoches | 48347 | 8376 | 227 | 0 | 31.62017125 | -94.61803994 | 2021-11-01 04:22:01 | Nacogdoches, Texas, US | |
2724185 | 2724185 | 2021-10-30 | US | Texas | Nacogdoches | 48347 | 8376 | 227 | 0 | 31.62017125 | -94.61803994 | 2021-10-31 04:22:08 | Nacogdoches, Texas, US | |
2047455 | 2047455 | 2021-10-18 | US | Wyoming | Fremont | 56013 | 8376 | 114 | 0 | 43.04183996 | -108.6296893 | 2021-10-19 04:20:54 | Fremont, Wyoming, US | |
604131 | 604131 | 2021-09-23 | US | Ohio | Ashtabula | 39007 | 8376 | 195 | 0 | 41.70860332 | -80.74830218 | 2021-09-24 04:21:44 | Ashtabula, Ohio, US | |
3757837 | 3757837 | 2021-09-21 | US | Alabama | Dale | 1045 | 8376 | 164 | 0 | 31.43037123 | -85.61095742 | 2021-09-22 04:21:45 | Dale, Alabama, US | |
644884 | 644884 | 2021-09-07 | US | Tennessee | Hawkins | 47073 | 8376 | 133 | 0 | 36.44355426 | -82.94885298 | 2021-09-08 04:21:31 | Hawkins, Tennessee, US | |
2177093 | 2177093 | 2021-08-22 | US | Louisiana | Vermilion | 22113 | 8376 | 143 | 0 | 29.83517605 | -92.30292538 | 2021-08-23 04:21:27 | Vermilion, Louisiana, US | |
3557189 | 3557189 | 2021-08-21 | US | Louisiana | Vermilion | 22113 | 8376 | 143 | 0 | 29.83517605 | -92.30292538 | 2021-08-22 04:21:29 | Vermilion, Louisiana, US | |
1855531 | 1855531 | 2021-08-20 | US | Louisiana | Vermilion | 22113 | 8376 | 143 | 0 | 29.83517605 | -92.30292538 | 2021-08-21 04:21:38 | Vermilion, Louisiana, US | |
1127141 | 1127141 | 2021-06-18 | US | Maine | Androscoggin | 23001 | 8376 | 85 | 0 | 44.1664747 | -70.20380627 | 2021-06-19 04:22:33 | Androscoggin, Maine, US | |
1739904 | 1739904 | 2021-06-12 | US | Virginia | Roanoke | 51161 | 8376 | 146 | 0 | 37.26865804 | -80.06396753 | 2021-06-13 04:22:44 | Roanoke, Virginia, US | |
2391857 | 2391857 | 2021-05-18 | US | Indiana | Hancock | 18059 | 8376 | 142 | 0 | 39.82304555 | -85.77566351 | 2021-05-19 04:20:42 | Hancock, Indiana, US | |
2004881 | 2004881 | 2021-05-12 | Russia | Magadan Oblast | 8376 | 102 | 8193 | 81 | 62.48858785 | 153.9903764 | 2021-05-13 04:20:51 | Magadan Oblast, Russia | ||
1570449 | 1570449 | 2021-04-22 | US | North Carolina | Orange | 37135 | 8376 | 101 | 0 | 36.06092947 | -79.12167935 | 2021-04-23 04:20:52 | Orange, North Carolina, US | |
985459 | 985459 | 2021-04-17 | US | Ohio | Tuscarawas | 39157 | 8376 | 245 | 0 | 40.44214695 | -81.47226262 | 2021-04-18 04:20:41 | Tuscarawas, Ohio, US | |
1304956 | 1304956 | 2021-04-01 | US | Tennessee | Anderson | 47001 | 8376 | 165 | 0 | 36.12684348 | -84.19965764 | 2021-04-02 04:20:36 | Anderson, Tennessee, US | |
3456347 | 3456347 | 2021-03-18 | US | West Virginia | Monongalia | 54061 | 8376 | 82 | 0 | 39.63218457 | -80.04766838 | 2021-03-19 05:26:09 | Monongalia, West Virginia, US | |
1580268 | 1580268 | 2021-03-13 | Netherlands | Aruba | 8376 | 78 | 8028 | 270 | 12.5211 | -69.9683 | 2021-03-14 05:25:37 | Aruba, Netherlands | ||
353821 | 353821 | 2021-03-11 | US | Louisiana | St. Landry | 22097 | 8376 | 246 | 0 | 30.59724262 | -92.00135806 | 2021-03-12 05:26:50 | St. Landry, Louisiana, US | |
3962551 | 3962551 | 2021-03-10 | Japan | Okinawa | 8376 | 122 | 7973 | 281 | 25.768923 | 126.668016 | 2021-03-11 05:25:48 | Okinawa, Japan | ||
2367566 | 2367566 | 2021-02-28 | Mali | 8376 | 353 | 6402 | 1621 | 17.570692 | -3.996166000000001 | 2021-03-01 05:23:01 | Mali | |||
1340562 | 1340562 | 2021-02-15 | US | North Carolina | Caldwell | 37027 | 8376 | 62 | 0 | 8314 | 35.95204977 | -81.54799522 | 2021-02-16 05:24:38 | Caldwell, North Carolina, US |
1687512 | 1687512 | 2021-02-02 | US | Texas | Bastrop | 48021 | 8376 | 66 | 0 | 7711 | 30.10370699 | -97.31206354 | 2021-02-03 05:22:52 | Bastrop, Texas, US |
1898909 | 1898909 | 2021-01-29 | US | Minnesota | Sherburne | 27141 | 8376 | 71 | 0 | 8305 | 45.44447208 | -93.77617511 | 2021-01-30 05:22:49 | Sherburne, Minnesota, US |
3308638 | 3308638 | 2021-01-13 | US | Arizona | Apache | 4001 | 8376 | 262 | 0 | 8114 | 35.39465006 | -109.4892383 | 2021-01-14 05:22:32 | Apache, Arizona, US |
1011301 | 1011301 | 2020-12-30 | US | Illinois | Kendall | 17093 | 8376 | 68 | 0 | 8308 | 41.59081014 | -88.42869583 | 2020-12-31 05:22:49 | Kendall, Illinois, US |
3862193 | 3862193 | 2020-12-04 | US | North Carolina | Union | 37179 | 8376 | 76 | 0 | 8300 | 34.98960527 | -80.52955873 | 2020-12-05 05:27:36 | Union, North Carolina, US |
1350656 | 1350656 | 2020-11-24 | US | Alabama | Baldwin | 1003 | 8376 | 84 | 0 | 8292 | 30.72774991 | -87.72207058 | 2020-11-25 05:27:20 | Baldwin, Alabama, US |
822603 | 822603 | 2020-11-19 | US | Illinois | Sangamon | 17167 | 8376 | 81 | 0 | 8295 | 39.75836914 | -89.65872023 | 2020-11-20 05:26:28 | Sangamon, Illinois, US |
894499 | 894499 | 2020-11-05 | US | North Dakota | Burleigh | 38015 | 8376 | 86 | 0 | 7998 | 46.97847375 | -100.4645214 | 2020-11-06 05:24:55 | Burleigh, North Dakota, US |
3481660 | 3481660 | 2020-10-26 | US | Kansas | Wyandotte | 20209 | 8376 | 164 | 0 | 8212 | 39.11727348 | -94.76378225 | 2020-10-27 04:24:45 | Wyandotte, Kansas, US |
9681 | 9681 | 2020-10-25 | US | Kansas | Wyandotte | 20209 | 8376 | 164 | 0 | 8212 | 39.11727348 | -94.76378225 | 2020-10-26 04:25:02 | Wyandotte, Kansas, US |
3802614 | 3802614 | 2020-10-05 | US | Florida | Sarasota | 12115 | 8376 | 265 | 0 | 8111 | 27.18546175 | -82.33174248 | 2020-10-06 04:23:33 | Sarasota, Florida, US |
1515458 | 1515458 | 2020-09-28 | Luxembourg | 8376 | 124 | 7128 | 1124 | 49.8153 | 6.1296 | 2020-09-29 04:23:42 | Luxembourg | |||
1173114 | 1173114 | 2020-09-10 | Haiti | 8376 | 214 | 5991 | 2171 | 18.9712 | -72.2852 | 2020-09-11 04:46:23 | Haiti | |||
1107709 | 1107709 | 2020-09-02 | US | New Jersey | Mercer | 34021 | 8376 | 631 | 0 | 7745 | 40.28047017 | -74.70479631 | 2020-09-03 04:28:22 | Mercer, New Jersey, US |
2748078 | 2748078 | 2020-07-15 | Italy | Lazio | 8376 | 847 | 6631 | 898 | 41.89277044 | 12.48366722 | 2020-07-16 04:44:59 | Lazio, 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]);