johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
63 rows where confirmed = 9067 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2754720 | 2754720 | 2022-12-29 | US | Mississippi | Itawamba | 28057 | 9067 | 147 | 0 | 34.27993475 | -88.3606733 | 2022-12-30 04:21:04 | Itawamba, Mississippi, US | |
1075726 | 1075726 | 2022-12-28 | US | Mississippi | Itawamba | 28057 | 9067 | 147 | 0 | 34.27993475 | -88.3606733 | 2022-12-29 04:21:01 | Itawamba, Mississippi, US | |
329723 | 329723 | 2022-12-27 | US | Mississippi | Itawamba | 28057 | 9067 | 147 | 0 | 34.27993475 | -88.3606733 | 2022-12-28 04:21:04 | Itawamba, Mississippi, US | |
3217700 | 3217700 | 2022-10-12 | US | Virginia | Pulaski | 51155 | 9067 | 144 | 0 | 37.06474963 | -80.71229738 | 2022-10-13 04:22:39 | Pulaski, Virginia, US | |
1891651 | 1891651 | 2022-09-14 | US | Ohio | Pike | 39131 | 9067 | 128 | 0 | 39.07634001 | -83.06769584 | 2022-09-15 04:21:02 | Pike, Ohio, US | |
374706 | 374706 | 2022-09-13 | US | Ohio | Pike | 39131 | 9067 | 128 | 0 | 39.07634001 | -83.06769584 | 2022-09-14 04:20:44 | Pike, Ohio, US | |
2397308 | 2397308 | 2022-09-12 | US | Ohio | Pike | 39131 | 9067 | 128 | 0 | 39.07634001 | -83.06769584 | 2022-09-13 04:20:57 | Pike, Ohio, US | |
3768386 | 3768386 | 2022-09-11 | US | Ohio | Pike | 39131 | 9067 | 128 | 0 | 39.07634001 | -83.06769584 | 2022-09-12 04:20:58 | Pike, Ohio, US | |
3826961 | 3826961 | 2022-09-10 | US | Ohio | Pike | 39131 | 9067 | 128 | 0 | 39.07634001 | -83.06769584 | 2022-09-11 04:20:50 | Pike, Ohio, US | |
965418 | 965418 | 2022-09-09 | US | Ohio | Pike | 39131 | 9067 | 128 | 0 | 39.07634001 | -83.06769584 | 2022-09-10 04:21:10 | Pike, Ohio, US | |
255820 | 255820 | 2022-09-08 | US | Ohio | Pike | 39131 | 9067 | 128 | 0 | 39.07634001 | -83.06769584 | 2022-09-09 04:21:11 | Pike, Ohio, US | |
3953447 | 3953447 | 2022-08-17 | US | Tennessee | Henry | 47079 | 9067 | 165 | 0 | 36.33160906 | -88.30121797 | 2022-08-18 04:21:11 | Henry, Tennessee, US | |
1068658 | 1068658 | 2022-07-28 | US | Puerto Rico | San Lorenzo | 72129 | 9067 | 0 | 0 | 18.147987 | -65.976392 | 2022-07-29 04:20:45 | San Lorenzo, Puerto Rico, US | |
903247 | 903247 | 2022-07-22 | US | Texas | Erath | 48143 | 9067 | 124 | 0 | 32.23602653 | -98.21773417 | 2022-07-23 04:20:53 | Erath, Texas, US | |
2422060 | 2422060 | 2022-07-15 | US | Texas | Matagorda | 48321 | 9067 | 177 | 0 | 28.81955746 | -96.01230294 | 2022-07-16 04:21:05 | Matagorda, Texas, US | |
1766448 | 1766448 | 2022-06-20 | US | Texas | Hill | 48217 | 9067 | 192 | 0 | 31.99045053 | -97.13423143 | 2022-06-21 04:20:56 | Hill, Texas, US | |
3272634 | 3272634 | 2022-06-19 | US | Texas | Hill | 48217 | 9067 | 192 | 0 | 31.99045053 | -97.13423143 | 2022-06-20 04:21:01 | Hill, Texas, US | |
2750607 | 2750607 | 2022-04-04 | US | Minnesota | Freeborn | 27047 | 9067 | 74 | 0 | 43.67385583 | -93.34884422 | 2022-04-05 04:20:48 | Freeborn, Minnesota, US | |
2479716 | 2479716 | 2022-03-30 | US | Minnesota | Morrison | 27097 | 9067 | 104 | 0 | 46.01265363 | -94.27341528 | 2022-03-31 04:20:56 | Morrison, Minnesota, US | |
1647315 | 1647315 | 2022-03-03 | US | Tennessee | Henderson | 47077 | 9067 | 147 | 0 | 35.65581134 | -88.38600175 | 2022-03-04 04:21:09 | Henderson, Tennessee, US | |
2113857 | 2113857 | 2021-12-26 | US | New Hampshire | Grafton | 33009 | 9067 | 44 | 0 | 43.93779815 | -71.82057197 | 2021-12-27 04:21:58 | Grafton, New Hampshire, US | |
3607229 | 3607229 | 2021-12-25 | US | New Hampshire | Grafton | 33009 | 9067 | 44 | 0 | 43.93779815 | -71.82057197 | 2021-12-26 04:21:50 | Grafton, New Hampshire, US | |
2965547 | 2965547 | 2021-12-24 | US | New Hampshire | Grafton | 33009 | 9067 | 44 | 0 | 43.93779815 | -71.82057197 | 2021-12-25 04:21:37 | Grafton, New Hampshire, US | |
3818579 | 3818579 | 2021-12-23 | US | New Hampshire | Grafton | 33009 | 9067 | 44 | 0 | 43.93779815 | -71.82057197 | 2021-12-24 04:21:34 | Grafton, New Hampshire, US | |
2400238 | 2400238 | 2021-12-17 | US | Kentucky | Jessamine | 21113 | 9067 | 110 | 0 | 37.87119786 | -84.58252003 | 2021-12-18 02:22:20 | Jessamine, Kentucky, US | |
2090991 | 2090991 | 2021-12-14 | US | Texas | Atascosa | 48013 | 9067 | 209 | 0 | 28.89333001 | -98.52730485 | 2021-12-15 03:22:16 | Atascosa, Texas, US | |
1324366 | 1324366 | 2021-11-14 | US | Nevada | Carson City | 32510 | 9067 | 161 | 0 | 39.15509045 | -119.7480219 | 2021-11-15 04:21:36 | Carson City, Nevada, US | |
688492 | 688492 | 2021-11-13 | US | Nevada | Carson City | 32510 | 9067 | 161 | 0 | 39.15509045 | -119.7480219 | 2021-11-14 04:21:31 | Carson City, Nevada, US | |
716601 | 716601 | 2021-11-12 | US | Nevada | Carson City | 32510 | 9067 | 161 | 0 | 39.15509045 | -119.7480219 | 2021-11-13 04:21:38 | Carson City, Nevada, US | |
987425 | 987425 | 2021-10-04 | US | Arizona | Gila | 4007 | 9067 | 262 | 0 | 33.80190085 | -110.8132779 | 2021-10-05 04:21:27 | Gila, Arizona, US | |
2776651 | 2776651 | 2021-09-30 | Yemen | 9067 | 1721 | 0 | 15.552726999999999 | 48.516388 | 2021-10-01 04:21:35 | Yemen | ||||
2620995 | 2620995 | 2021-09-17 | US | Tennessee | Jefferson | 47089 | 9067 | 134 | 0 | 36.04818632 | -83.45148924 | 2021-09-18 04:21:24 | Jefferson, Tennessee, US | |
514059 | 514059 | 2021-08-19 | US | North Carolina | Sampson | 37163 | 9067 | 115 | 0 | 34.98820368 | -78.36914061 | 2021-08-20 04:21:33 | Sampson, North Carolina, US | |
3686361 | 3686361 | 2021-08-02 | US | Tennessee | Anderson | 47001 | 9067 | 178 | 0 | 36.12684348 | -84.19965764 | 2021-08-03 04:21:39 | Anderson, Tennessee, US | |
2949319 | 2949319 | 2021-07-16 | US | Missouri | St. Francois | 29187 | 9067 | 116 | 0 | 37.81214171 | -90.47598685 | 2021-07-17 04:22:22 | St. Francois, Missouri, US | |
580710 | 580710 | 2021-07-13 | US | Missouri | Cape Girardeau | 29031 | 9067 | 140 | 0 | 37.38489388 | -89.6843587 | 2021-07-14 04:21:35 | Cape Girardeau, Missouri, US | |
579198 | 579198 | 2021-07-13 | US | Alabama | DeKalb | 1049 | 9067 | 191 | 0 | 34.45946862 | -85.80782906 | 2021-07-14 04:21:35 | DeKalb, Alabama, US | |
3741447 | 3741447 | 2021-07-12 | US | Alabama | DeKalb | 1049 | 9067 | 191 | 0 | 34.45946862 | -85.80782906 | 2021-07-13 04:21:18 | DeKalb, Alabama, US | |
1934779 | 1934779 | 2021-07-05 | US | North Carolina | Moore | 37125 | 9067 | 194 | 0 | 35.30885257 | -79.48474178 | 2021-07-06 04:21:32 | Moore, North Carolina, US | |
1167510 | 1167510 | 2021-07-04 | US | North Carolina | Moore | 37125 | 9067 | 194 | 0 | 35.30885257 | -79.48474178 | 2021-07-05 04:21:28 | Moore, North Carolina, US | |
1497944 | 1497944 | 2021-07-03 | US | North Carolina | Moore | 37125 | 9067 | 194 | 0 | 35.30885257 | -79.48474178 | 2021-07-04 04:21:38 | Moore, North Carolina, US | |
2074259 | 2074259 | 2021-07-02 | US | North Carolina | Moore | 37125 | 9067 | 194 | 0 | 35.30885257 | -79.48474178 | 2021-07-03 04:21:37 | Moore, North Carolina, US | |
563005 | 563005 | 2021-06-22 | Japan | Shizuoka | 9067 | 148 | 8589 | 330 | 34.916975 | 138.40778400000002 | 2021-06-23 04:21:46 | Shizuoka, Japan | ||
2339886 | 2339886 | 2021-06-15 | US | Arkansas | Jefferson | 5069 | 9067 | 170 | 0 | 34.26767081 | -91.92619839 | 2021-06-16 04:22:32 | Jefferson, Arkansas, US | |
3577980 | 3577980 | 2021-05-17 | US | Virginia | Portsmouth | 51740 | 9067 | 196 | 0 | 36.85914825 | -76.35971629 | 2021-05-18 04:20:33 | Portsmouth, Virginia, US | |
3956652 | 3956652 | 2021-05-11 | US | New Jersey | Cape May | 34009 | 9067 | 202 | 0 | 39.15008829 | -74.80170244 | 2021-05-12 04:21:29 | Cape May, New Jersey, US | |
3956499 | 3956499 | 2021-05-11 | US | Montana | Missoula | 30063 | 9067 | 93 | 0 | 47.03728583 | -113.92135079999998 | 2021-05-12 04:21:29 | Missoula, Montana, US | |
648237 | 648237 | 2021-05-05 | US | North Carolina | Brunswick | 37019 | 9067 | 152 | 0 | 34.070565 | -78.22814204 | 2021-05-06 04:20:38 | Brunswick, North Carolina, US | |
1412606 | 1412606 | 2021-04-23 | US | Wisconsin | Ozaukee | 55089 | 9067 | 91 | 0 | 43.38352225 | -87.94625009 | 2021-04-24 04:20:38 | Ozaukee, Wisconsin, US | |
3130793 | 3130793 | 2021-04-18 | US | Kansas | Douglas | 20045 | 9067 | 82 | 0 | 38.88503636 | -95.2925121 | 2021-04-19 04:20:57 | Douglas, Kansas, US | |
984221 | 984221 | 2021-04-17 | US | Kansas | Douglas | 20045 | 9067 | 82 | 0 | 38.88503636 | -95.2925121 | 2021-04-18 04:20:41 | Douglas, Kansas, US | |
171316 | 171316 | 2021-04-16 | US | Kansas | Douglas | 20045 | 9067 | 82 | 0 | 38.88503636 | -95.2925121 | 2021-04-17 04:20:40 | Douglas, Kansas, US | |
2648581 | 2648581 | 2021-04-08 | US | South Carolina | Oconee | 45073 | 9067 | 131 | 0 | 34.75225169 | -83.06742317 | 2021-04-09 04:21:13 | Oconee, South Carolina, US | |
1204112 | 1204112 | 2021-03-22 | Suriname | 9067 | 177 | 8560 | 330 | 3.9193 | -56.0278 | 2021-03-23 05:26:18 | Suriname | |||
2058211 | 2058211 | 2021-03-15 | US | North Carolina | Lincoln | 37109 | 9067 | 75 | 0 | 35.48508185 | -81.21740317 | 2021-03-16 05:25:13 | Lincoln, North Carolina, US | |
768962 | 768962 | 2020-12-29 | US | Pennsylvania | Butler | 42019 | 9067 | 179 | 0 | 8888 | 40.91152759 | -79.91351055 | 2020-12-30 05:22:34 | Butler, Pennsylvania, US |
3779511 | 3779511 | 2020-12-27 | US | Michigan | Berrien | 26021 | 9067 | 178 | 0 | 8889 | 41.95447397 | -86.41313079999998 | 2020-12-28 05:22:06 | Berrien, Michigan, US |
2225116 | 2225116 | 2020-12-26 | US | Michigan | Berrien | 26021 | 9067 | 178 | 0 | 8889 | 41.95447397 | -86.41313079999998 | 2020-12-27 05:22:55 | Berrien, Michigan, US |
786568 | 786568 | 2020-10-15 | Russia | Chuvashia Republic | 9067 | 109 | 7621 | 1337 | 55.4259922 | 47.0849429 | 2020-10-16 04:24:01 | Chuvashia Republic, Russia | ||
2514356 | 2514356 | 2020-10-03 | Russia | Belgorod Oblast | 9067 | 58 | 8161 | 848 | 50.7080119 | 37.5837615 | 2020-10-04 04:23:44 | Belgorod Oblast, Russia | ||
1209544 | 1209544 | 2020-06-09 | US | California | Orange | 6059 | 9067 | 185 | 0 | 8882 | 33.70147516 | -117.76459979999998 | 2020-06-10 04:07:00 | Orange, California, US |
1431866 | 1431866 | 2020-05-20 | Spain | Galicia | 9067 | 607 | 0 | 8460 | 42.5751 | -8.1339 | 2020-05-21 02:32:48 | Galicia, Spain | ||
1829418 | 1829418 | 2020-05-16 | US | Massachusetts | Worcester | 25027 | 9067 | 554 | 0 | 8513 | 42.35026951 | -71.90493363 | 2020-05-17 02:32:32 | Worcester, Massachusetts, 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]);