johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
43 rows where confirmed = 11316 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
260299 | 260299 | 2022-12-10 | US | Tennessee | Lincoln | 47103 | 11316 | 182 | 0 | 35.13738622 | -86.58910106 | 2022-12-11 04:20:50 | Lincoln, Tennessee, US | |
2557889 | 2557889 | 2022-11-29 | US | Kansas | Harvey | 20079 | 11316 | 133 | 0 | 38.04293782 | -97.42747573 | 2022-11-30 04:21:07 | Harvey, Kansas, US | |
1240963 | 1240963 | 2022-11-28 | US | Kansas | Harvey | 20079 | 11316 | 133 | 0 | 38.04293782 | -97.42747573 | 2022-11-29 04:21:05 | Harvey, Kansas, US | |
3552951 | 3552951 | 2022-11-27 | US | Kansas | Harvey | 20079 | 11316 | 133 | 0 | 38.04293782 | -97.42747573 | 2022-11-28 04:21:02 | Harvey, Kansas, US | |
2101431 | 2101431 | 2022-11-26 | US | Kansas | Harvey | 20079 | 11316 | 133 | 0 | 38.04293782 | -97.42747573 | 2022-11-27 04:21:05 | Harvey, Kansas, US | |
488922 | 488922 | 2022-11-25 | US | Kansas | Harvey | 20079 | 11316 | 133 | 0 | 38.04293782 | -97.42747573 | 2022-11-26 04:21:11 | Harvey, Kansas, US | |
3524751 | 3524751 | 2022-11-24 | US | Kansas | Harvey | 20079 | 11316 | 133 | 0 | 38.04293782 | -97.42747573 | 2022-11-25 04:21:06 | Harvey, Kansas, US | |
3313534 | 3313534 | 2022-11-23 | US | Kansas | Harvey | 20079 | 11316 | 133 | 0 | 38.04293782 | -97.42747573 | 2022-11-24 04:21:09 | Harvey, Kansas, US | |
295427 | 295427 | 2022-11-15 | US | Virginia | Smyth | 51173 | 11316 | 193 | 0 | 36.84455636 | -81.53344948 | 2022-11-16 04:21:09 | Smyth, Virginia, US | |
132990 | 132990 | 2022-10-04 | US | New York | Franklin | 36033 | 11316 | 50 | 0 | 44.59040891 | -74.29926032 | 2022-10-05 04:23:06 | Franklin, New York, US | |
2314341 | 2314341 | 2022-06-17 | US | Texas | Burnet | 48053 | 11316 | 172 | 0 | 30.78801353 | -98.181887 | 2022-06-18 04:21:10 | Burnet, Texas, US | |
695469 | 695469 | 2022-03-17 | US | Indiana | DeKalb | 18033 | 11316 | 145 | 0 | 41.39804622 | -84.99906934 | 2022-03-18 04:20:55 | DeKalb, Indiana, US | |
2526772 | 2526772 | 2022-03-02 | US | Kentucky | Graves | 21083 | 11316 | 160 | 0 | 36.72292505 | -88.65143315 | 2022-03-03 04:21:01 | Graves, Kentucky, US | |
1994066 | 1994066 | 2022-03-01 | US | Kentucky | Graves | 21083 | 11316 | 160 | 0 | 36.72292505 | -88.65143315 | 2022-03-02 04:21:07 | Graves, Kentucky, US | |
3915673 | 3915673 | 2022-02-20 | United Kingdom | Bermuda | 11316 | 122 | 0 | 32.3078 | -64.7505 | 2022-02-21 04:21:05 | Bermuda, United Kingdom | |||
3879231 | 3879231 | 2022-02-19 | United Kingdom | Bermuda | 11316 | 122 | 0 | 32.3078 | -64.7505 | 2022-02-20 04:21:00 | Bermuda, United Kingdom | |||
3859487 | 3859487 | 2022-02-18 | United Kingdom | Bermuda | 11316 | 122 | 0 | 32.3078 | -64.7505 | 2022-02-19 04:21:11 | Bermuda, United Kingdom | |||
1301706 | 1301706 | 2022-02-17 | United Kingdom | Bermuda | 11316 | 122 | 0 | 32.3078 | -64.7505 | 2022-02-18 04:21:04 | Bermuda, United Kingdom | |||
3674979 | 3674979 | 2022-02-15 | US | Virginia | Culpeper | 51047 | 11316 | 124 | 0 | 38.48199985 | -77.95630870000002 | 2022-02-16 04:21:10 | Culpeper, Virginia, US | |
3075136 | 3075136 | 2022-02-09 | US | Indiana | Gibson | 18051 | 11316 | 129 | 0 | 38.30393723 | -87.58054938 | 2022-02-10 04:21:14 | Gibson, Indiana, US | |
1363443 | 1363443 | 2022-02-08 | US | Indiana | Gibson | 18051 | 11316 | 129 | 0 | 38.30393723 | -87.58054938 | 2022-02-09 04:21:04 | Gibson, Indiana, US | |
2835289 | 2835289 | 2022-01-22 | US | Ohio | Darke | 39037 | 11316 | 210 | 0 | 40.13412966 | -84.6194517 | 2022-01-23 04:21:13 | Darke, Ohio, US | |
3228152 | 3228152 | 2022-01-19 | US | Minnesota | Benton | 27009 | 11316 | 146 | 0 | 45.69804958 | -93.99514135 | 2022-01-20 04:21:07 | Benton, Minnesota, US | |
1692797 | 1692797 | 2022-01-10 | US | Arkansas | Crittenden | 5035 | 11316 | 194 | 0 | 35.21247318 | -90.30839406 | 2022-01-11 04:22:01 | Crittenden, Arkansas, US | |
30009 | 30009 | 2021-11-11 | US | Maryland | Wicomico | 24045 | 11316 | 227 | 0 | 38.37301947 | -75.62705831 | 2021-11-12 04:22:01 | Wicomico, Maryland, US | |
277269 | 277269 | 2021-11-03 | US | Indiana | Floyd | 18043 | 11316 | 220 | 0 | 38.32117957 | -85.90385377 | 2021-11-04 04:22:20 | Floyd, Indiana, US | |
424417 | 424417 | 2021-10-10 | US | Indiana | Bartholomew | 18005 | 11316 | 177 | 0 | 39.20744865 | -85.89558181 | 2021-10-11 04:21:31 | Bartholomew, Indiana, US | |
1239215 | 1239215 | 2021-09-27 | US | Wisconsin | Ozaukee | 55089 | 11316 | 111 | 0 | 43.38352225 | -87.94625009 | 2021-09-28 04:21:28 | Ozaukee, Wisconsin, US | |
1854030 | 1854030 | 2021-08-20 | Japan | Tochigi | 11316 | 99 | 0 | 36.689912 | 139.819213 | 2021-08-21 04:21:38 | Tochigi, Japan | |||
3479916 | 3479916 | 2021-07-22 | US | Wyoming | Laramie | 56021 | 11316 | 129 | 0 | 41.30702520000001 | -104.6887497 | 2021-07-23 04:21:29 | Laramie, Wyoming, US | |
3146427 | 3146427 | 2021-06-07 | US | Georgia | Newton | 13217 | 11316 | 255 | 0 | 33.55514538 | -83.84547140000002 | 2021-06-08 04:22:35 | Newton, Georgia, US | |
2450854 | 2450854 | 2021-05-02 | Mexico | Colima | 11316 | 1178 | 0 | 10138 | 19.1223 | -104.0072 | 2021-05-03 04:20:39 | Colima, Mexico | ||
3621874 | 3621874 | 2021-03-17 | US | Georgia | Floyd | 13115 | 11316 | 200 | 0 | 34.26268279 | -85.21577392 | 2021-03-18 05:26:22 | Floyd, Georgia, US | |
473929 | 473929 | 2021-02-19 | US | Ohio | Wood | 39173 | 11316 | 176 | 0 | 11140 | 41.36224827 | -83.62285108 | 2021-02-20 05:22:51 | Wood, Ohio, US |
3981222 | 3981222 | 2021-02-10 | US | Pennsylvania | Cambria | 42021 | 11316 | 376 | 0 | 10940 | 40.49527404 | -78.71377428 | 2021-02-11 05:23:55 | Cambria, Pennsylvania, US |
3440709 | 3440709 | 2020-11-11 | France | French Polynesia | 11316 | 52 | 4842 | 6422 | -17.6797 | -149.4068 | 2020-11-12 05:25:55 | French Polynesia, France | ||
2191667 | 2191667 | 2020-10-21 | Maldives | 11316 | 37 | 10284 | 995 | 3.2028 | 73.2207 | 2020-10-22 04:24:27 | Maldives | |||
2292141 | 2292141 | 2020-10-12 | US | Florida | Leon | 12073 | 11316 | 92 | 0 | 11224 | 30.45955727 | -84.27491114 | 2020-10-13 04:24:02 | Leon, Florida, US |
2059866 | 2059866 | 2020-09-01 | Italy | Lazio | 11316 | 878 | 7153 | 3285 | 41.89277044 | 12.48366722 | 2020-09-02 04:28:25 | Lazio, Italy | ||
1481790 | 1481790 | 2020-08-21 | US | New York | Orange | 36071 | 11316 | 493 | 0 | 10823 | 41.40337468 | -74.30240757 | 2020-08-22 04:27:49 | Orange, New York, US |
1557608 | 1557608 | 2020-08-16 | US | Michigan | Macomb | 26099 | 11316 | 955 | 0 | 10361 | 42.69158356 | -82.92752801 | 2020-08-17 04:27:20 | Macomb, Michigan, US |
3205437 | 3205437 | 2020-07-18 | Russia | Rostov Oblast | 11316 | 183 | 8874 | 2259 | 47.6222451 | 40.7957942 | 2020-07-19 04:34:58 | Rostov Oblast, Russia | ||
3415431 | 3415431 | 2020-05-17 | US | Maryland | Prince George's | 24033 | 11316 | 429 | 0 | 10887 | 38.83070039 | -76.8496441 | 2020-05-18 02:32:21 | Prince George's, Maryland, 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]);