johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
73 rows where confirmed = 7514 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3379804 | 3379804 | 2022-12-08 | US | North Dakota | Rolette | 38079 | 7514 | 43 | 0 | 48.77245354 | -99.84097493 | 2022-12-09 04:21:05 | Rolette, North Dakota, US | |
711399 | 711399 | 2022-11-01 | US | Idaho | Latah | 16057 | 7514 | 54 | 0 | 46.81587887 | -116.7113698 | 2022-11-02 04:22:09 | Latah, Idaho, US | |
3285848 | 3285848 | 2022-10-31 | US | Idaho | Latah | 16057 | 7514 | 54 | 0 | 46.81587887 | -116.7113698 | 2022-11-01 04:22:36 | Latah, Idaho, US | |
320881 | 320881 | 2022-10-30 | US | Idaho | Latah | 16057 | 7514 | 54 | 0 | 46.81587887 | -116.7113698 | 2022-10-31 04:21:36 | Latah, Idaho, US | |
913157 | 913157 | 2022-10-29 | US | Idaho | Latah | 16057 | 7514 | 54 | 0 | 46.81587887 | -116.7113698 | 2022-10-30 04:22:14 | Latah, Idaho, US | |
1367426 | 1367426 | 2022-10-28 | US | Idaho | Latah | 16057 | 7514 | 54 | 0 | 46.81587887 | -116.7113698 | 2022-10-29 04:21:13 | Latah, Idaho, US | |
3039281 | 3039281 | 2022-10-27 | US | Idaho | Latah | 16057 | 7514 | 54 | 0 | 46.81587887 | -116.7113698 | 2022-10-28 04:22:31 | Latah, Idaho, US | |
539701 | 539701 | 2022-10-26 | US | Idaho | Latah | 16057 | 7514 | 54 | 0 | 46.81587887 | -116.7113698 | 2022-10-27 04:22:01 | Latah, Idaho, US | |
3100873 | 3100873 | 2022-10-09 | US | Virginia | Winchester | 51840 | 7514 | 90 | 0 | 39.17054517 | -78.17325058 | 2022-10-10 04:22:32 | Winchester, Virginia, US | |
4006098 | 4006098 | 2022-10-08 | US | Virginia | Winchester | 51840 | 7514 | 90 | 0 | 39.17054517 | -78.17325058 | 2022-10-09 04:21:16 | Winchester, Virginia, US | |
399695 | 399695 | 2022-10-07 | US | Virginia | Winchester | 51840 | 7514 | 90 | 0 | 39.17054517 | -78.17325058 | 2022-10-08 04:22:56 | Winchester, Virginia, US | |
1407811 | 1407811 | 2022-08-02 | US | Puerto Rico | Naranjito | 72105 | 7514 | 0 | 0 | 18.288019 | -66.252703 | 2022-08-03 04:20:59 | Naranjito, Puerto Rico, US | |
169193 | 169193 | 2022-06-21 | US | Texas | Kleberg | 48273 | 7514 | 147 | 0 | 27.42435506 | -97.69894948 | 2022-06-22 04:20:54 | Kleberg, Texas, US | |
2981882 | 2981882 | 2022-06-13 | US | Oregon | Jefferson | 41031 | 7514 | 95 | 0 | 44.62806839 | -121.17832 | 2022-06-14 04:20:52 | Jefferson, Oregon, US | |
2981002 | 2981002 | 2022-06-13 | US | Minnesota | Mille Lacs | 27095 | 7514 | 116 | 0 | 45.93705297 | -93.63236823 | 2022-06-14 04:20:52 | Mille Lacs, Minnesota, US | |
1424406 | 1424406 | 2022-06-08 | US | Virginia | Amherst | 51009 | 7514 | 89 | 0 | 37.60308293 | -79.14548696 | 2022-06-09 04:20:54 | Amherst, Virginia, US | |
3584791 | 3584791 | 2022-05-17 | US | Nevada | Nye | 32023 | 7514 | 241 | 0 | 38.04264256 | -116.4722702 | 2022-05-18 04:20:50 | Nye, Nevada, US | |
1505748 | 1505748 | 2022-05-16 | US | Nevada | Nye | 32023 | 7514 | 241 | 0 | 38.04264256 | -116.4722702 | 2022-05-17 04:20:59 | Nye, Nevada, US | |
2086107 | 2086107 | 2022-05-15 | US | Nevada | Nye | 32023 | 7514 | 241 | 0 | 38.04264256 | -116.4722702 | 2022-05-16 04:20:47 | Nye, Nevada, US | |
3356817 | 3356817 | 2022-05-14 | US | Nevada | Nye | 32023 | 7514 | 241 | 0 | 38.04264256 | -116.4722702 | 2022-05-15 04:20:53 | Nye, Nevada, US | |
660462 | 660462 | 2022-05-13 | US | Nevada | Nye | 32023 | 7514 | 241 | 0 | 38.04264256 | -116.4722702 | 2022-05-14 04:20:48 | Nye, Nevada, US | |
2535545 | 2535545 | 2022-05-12 | US | Nevada | Nye | 32023 | 7514 | 241 | 0 | 38.04264256 | -116.4722702 | 2022-05-13 04:20:51 | Nye, Nevada, US | |
3446991 | 3446991 | 2022-05-11 | US | Nevada | Nye | 32023 | 7514 | 241 | 0 | 38.04264256 | -116.4722702 | 2022-05-12 04:20:54 | Nye, Nevada, US | |
1575565 | 1575565 | 2022-05-03 | US | Virginia | Wythe | 51197 | 7514 | 148 | 0 | 36.91582035 | -81.07834059 | 2022-05-04 04:20:59 | Wythe, Virginia, US | |
467069 | 467069 | 2022-05-02 | Vanuatu | 7514 | 13 | 0 | -15.3767 | 166.9592 | 2022-05-03 04:21:00 | Vanuatu | ||||
2321945 | 2321945 | 2022-03-16 | US | Oregon | Columbia | 41009 | 7514 | 77 | 0 | 45.94464254 | -123.08908980000001 | 2022-03-17 04:20:56 | Columbia, Oregon, US | |
262753 | 262753 | 2022-03-15 | US | Iowa | Marion | 19125 | 7514 | 120 | 0 | 41.33445101 | -93.09934783 | 2022-03-16 04:20:50 | Marion, Iowa, US | |
2265112 | 2265112 | 2022-03-14 | US | Iowa | Marion | 19125 | 7514 | 120 | 0 | 41.33445101 | -93.09934783 | 2022-03-15 04:20:47 | Marion, Iowa, US | |
3629178 | 3629178 | 2022-03-13 | US | Iowa | Marion | 19125 | 7514 | 120 | 0 | 41.33445101 | -93.09934783 | 2022-03-14 04:20:46 | Marion, Iowa, US | |
952086 | 952086 | 2022-03-12 | US | Iowa | Marion | 19125 | 7514 | 120 | 0 | 41.33445101 | -93.09934783 | 2022-03-13 04:20:49 | Marion, Iowa, US | |
357547 | 357547 | 2022-03-11 | US | Iowa | Marion | 19125 | 7514 | 120 | 0 | 41.33445101 | -93.09934783 | 2022-03-12 04:20:50 | Marion, Iowa, US | |
1866699 | 1866699 | 2022-03-10 | US | Iowa | Marion | 19125 | 7514 | 120 | 0 | 41.33445101 | -93.09934783 | 2022-03-11 04:20:50 | Marion, Iowa, US | |
2141394 | 2141394 | 2022-03-09 | US | Iowa | Marion | 19125 | 7514 | 120 | 0 | 41.33445101 | -93.09934783 | 2022-03-10 04:20:48 | Marion, Iowa, US | |
2526002 | 2526002 | 2022-03-02 | US | Colorado | Logan | 8075 | 7514 | 109 | 0 | 40.7249637 | -103.110817 | 2022-03-03 04:21:01 | Logan, Colorado, US | |
1993296 | 1993296 | 2022-03-01 | US | Colorado | Logan | 8075 | 7514 | 109 | 0 | 40.7249637 | -103.110817 | 2022-03-02 04:21:07 | Logan, Colorado, US | |
3912139 | 3912139 | 2022-02-20 | Netherlands | Bonaire, Sint Eustatius and Saba | 7514 | 31 | 0 | 12.1784 | -68.2385 | 2022-02-21 04:21:05 | Bonaire, Sint Eustatius and Saba, Netherlands | |||
1230117 | 1230117 | 2022-01-24 | US | Ohio | Perry | 39127 | 7514 | 114 | 0 | 39.73508655 | -82.23804971 | 2022-01-25 04:21:05 | Perry, Ohio, US | |
3465638 | 3465638 | 2022-01-18 | US | Kentucky | Perry | 21193 | 7514 | 137 | 0 | 37.25023553 | -83.22922731 | 2022-01-19 04:21:23 | Perry, Kentucky, US | |
732018 | 732018 | 2021-12-27 | US | Louisiana | Avoyelles | 22009 | 7514 | 181 | 0 | 31.07796211 | -92.00079449 | 2021-12-28 04:21:47 | Avoyelles, Louisiana, US | |
1261824 | 1261824 | 2021-12-18 | US | Texas | Brown | 48049 | 7514 | 175 | 0 | 31.77430356 | -98.99907113 | 2021-12-19 04:21:11 | Brown, Texas, US | |
1743476 | 1743476 | 2021-12-05 | US | Tennessee | Fayette | 47047 | 7514 | 112 | 0 | 35.19615831 | -89.41399032 | 2021-12-06 04:22:34 | Fayette, Tennessee, US | |
1148224 | 1148224 | 2021-12-01 | US | Virgin Islands | 78 | 7514 | 87 | 0 | 18.3358 | -64.8963 | 2021-12-02 04:22:37 | Virgin Islands, US | ||
1146335 | 1146335 | 2021-12-01 | US | Kentucky | Graves | 21083 | 7514 | 131 | 0 | 36.72292505 | -88.65143315 | 2021-12-02 04:22:37 | Graves, Kentucky, US | |
278063 | 278063 | 2021-11-03 | US | Missouri | Callaway | 29027 | 7514 | 71 | 0 | 38.83674754 | -91.92186505 | 2021-11-04 04:22:20 | Callaway, Missouri, US | |
1910284 | 1910284 | 2021-10-17 | US | Indiana | Cass | 18017 | 7514 | 119 | 0 | 40.76135835 | -86.34830753 | 2021-10-18 04:21:10 | Cass, Indiana, US | |
1237013 | 1237013 | 2021-09-27 | US | Kentucky | Barren | 21009 | 7514 | 118 | 0 | 36.96469836 | -85.93338945 | 2021-09-28 04:21:28 | Barren, Kentucky, US | |
2077751 | 2077751 | 2021-09-26 | US | Mississippi | Hancock | 28045 | 7514 | 112 | 0 | 30.41830223 | -89.48851033 | 2021-09-27 04:21:16 | Hancock, Mississippi, US | |
1726303 | 1726303 | 2021-09-25 | US | Mississippi | Hancock | 28045 | 7514 | 112 | 0 | 30.41830223 | -89.48851033 | 2021-09-26 04:21:29 | Hancock, Mississippi, US | |
1923023 | 1923023 | 2021-09-24 | US | Mississippi | Hancock | 28045 | 7514 | 112 | 0 | 30.41830223 | -89.48851033 | 2021-09-25 04:21:31 | Hancock, Mississippi, US | |
603417 | 603417 | 2021-09-23 | US | Minnesota | Kandiyohi | 27067 | 7514 | 91 | 0 | 45.1526059 | -95.00586446 | 2021-09-24 04:21:44 | Kandiyohi, Minnesota, US | |
601987 | 601987 | 2021-09-23 | Spain | Ceuta | 7514 | 127 | 0 | 35.8894 | -5.3213 | 2021-09-24 04:21:44 | Ceuta, Spain | |||
3759410 | 3759410 | 2021-09-21 | US | Missouri | Newton | 29145 | 7514 | 117 | 0 | 36.90519407 | -94.3394104 | 2021-09-22 04:21:45 | Newton, Missouri, US | |
2463297 | 2463297 | 2021-09-14 | US | Arkansas | Mississippi | 5093 | 7514 | 123 | 0 | 35.76271485 | -90.05194370000002 | 2021-09-15 03:22:37 | Mississippi, Arkansas, US | |
1775833 | 1775833 | 2021-08-30 | US | Arkansas | Crittenden | 5035 | 7514 | 109 | 0 | 35.21247318 | -90.30839406 | 2021-08-31 04:21:46 | Crittenden, Arkansas, US | |
334096 | 334096 | 2021-08-04 | US | New Mexico | Eddy | 35015 | 7514 | 145 | 0 | 32.47167456 | -104.3053527 | 2021-08-05 04:21:51 | Eddy, New Mexico, US | |
828405 | 828405 | 2021-06-06 | US | South Carolina | Laurens | 45059 | 7514 | 171 | 0 | 34.48244419 | -82.00490796 | 2021-06-07 04:22:51 | Laurens, South Carolina, US | |
1913239 | 1913239 | 2021-05-20 | Japan | Nara | 7514 | 100 | 6750 | 664 | 34.317451 | 135.871644 | 2021-05-21 04:20:43 | Nara, Japan | ||
2393590 | 2393590 | 2021-05-18 | US | South Carolina | Kershaw | 45055 | 7514 | 141 | 0 | 34.33988254 | -80.58763164 | 2021-05-19 04:20:42 | Kershaw, South Carolina, US | |
1425983 | 1425983 | 2021-05-09 | US | Georgia | Troup | 13285 | 7514 | 225 | 0 | 33.03349196 | -85.02812115 | 2021-05-10 04:20:38 | Troup, Georgia, US | |
3131880 | 3131880 | 2021-04-18 | US | North Carolina | Stanly | 37167 | 7514 | 112 | 0 | 35.31647813 | -80.25093221 | 2021-04-19 04:20:57 | Stanly, North Carolina, US | |
985308 | 985308 | 2021-04-17 | US | North Carolina | Stanly | 37167 | 7514 | 112 | 0 | 35.31647813 | -80.25093221 | 2021-04-18 04:20:41 | Stanly, North Carolina, US | |
172403 | 172403 | 2021-04-16 | US | North Carolina | Stanly | 37167 | 7514 | 112 | 0 | 35.31647813 | -80.25093221 | 2021-04-17 04:20:40 | Stanly, North Carolina, US | |
3884326 | 3884326 | 2021-04-11 | US | Florida | Walton | 12131 | 7514 | 85 | 0 | 30.64204028 | -86.16935664 | 2021-04-12 04:21:00 | Walton, Florida, US | |
3052133 | 3052133 | 2021-02-16 | US | Missouri | St. Francois | 29187 | 7514 | 96 | 0 | 7418 | 37.81214171 | -90.47598685 | 2021-02-17 05:23:10 | St. Francois, Missouri, US |
2214493 | 2214493 | 2021-01-30 | US | South Carolina | Oconee | 45073 | 7514 | 95 | 0 | 7419 | 34.75225169 | -83.06742317 | 2021-01-31 05:22:42 | Oconee, South Carolina, US |
928799 | 928799 | 2020-12-21 | US | Indiana | Monroe | 18105 | 7514 | 96 | 0 | 7418 | 39.16130004 | -86.52414358 | 2020-12-22 05:22:33 | Monroe, Indiana, US |
2129563 | 2129563 | 2020-12-17 | US | Maryland | Harford | 24025 | 7514 | 129 | 0 | 7385 | 39.55010644 | -76.30775940000002 | 2020-12-18 05:28:18 | Harford, Maryland, US |
2917335 | 2917335 | 2020-11-14 | US | New Jersey | Atlantic | 34001 | 7514 | 273 | 0 | 7241 | 39.47538693 | -74.65848483 | 2020-11-15 05:26:53 | Atlantic, New Jersey, US |
3441624 | 3441624 | 2020-11-11 | US | Georgia | Henry | 13151 | 7514 | 130 | 0 | 7384 | 33.4533428 | -84.14814659999998 | 2020-11-12 05:25:55 | Henry, Georgia, US |
3117687 | 3117687 | 2020-10-06 | Russia | Karachay-Cherkess Republic | 7514 | 29 | 4921 | 2564 | 43.7368326 | 41.7267991 | 2020-10-07 04:23:40 | Karachay-Cherkess Republic, Russia | ||
3805340 | 3805340 | 2020-10-05 | US | Washington | Spokane | 53063 | 7514 | 169 | 0 | 7345 | 47.62113146 | -117.4046494 | 2020-10-06 04:23:33 | Spokane, Washington, US |
3316596 | 3316596 | 2020-09-22 | US | Alabama | Madison | 1089 | 7514 | 75 | 0 | 7439 | 34.76327133 | -86.55069633 | 2020-09-23 04:23:00 | Madison, Alabama, US |
177112 | 177112 | 2020-07-27 | France | French Guiana | 7514 | 42 | 6047 | 1425 | 4.0 | -53.0 | 2020-07-28 04:58:43 | French Guiana, France |
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]);