johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
46 rows where confirmed = 11705 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
311400 | 311400 | 2022-12-13 | US | West Virginia | Randolph | 54083 | 11705 | 99 | 0 | 38.769899 | -79.87919615 | 2022-12-14 04:21:04 | Randolph, West Virginia, US | |
2819012 | 2819012 | 2022-12-03 | US | New York | Franklin | 36033 | 11705 | 53 | 0 | 44.59040891 | -74.29926032 | 2022-12-04 04:20:56 | Franklin, New York, US | |
2064086 | 2064086 | 2022-11-19 | Peru | Unknown | 11705 | 37 | 0 | 2022-11-20 04:21:08 | Unknown, Peru | |||||
1755480 | 1755480 | 2022-11-18 | Peru | Unknown | 11705 | 37 | 0 | 2022-11-19 04:21:14 | Unknown, Peru | |||||
1101099 | 1101099 | 2022-08-03 | US | Tennessee | Obion | 47131 | 11705 | 203 | 0 | 36.35732446 | -89.14921589 | 2022-08-04 04:20:58 | Obion, Tennessee, US | |
1648786 | 1648786 | 2022-06-23 | US | Alabama | Tallapoosa | 1123 | 11705 | 236 | 0 | 32.86698258 | -85.79833053 | 2022-06-24 04:20:58 | Tallapoosa, Alabama, US | |
3510894 | 3510894 | 2022-06-05 | US | West Virginia | Ohio | 54069 | 11705 | 172 | 0 | 40.0955451 | -80.62203992 | 2022-06-06 04:20:57 | Ohio, West Virginia, US | |
3530971 | 3530971 | 2022-06-04 | US | West Virginia | Ohio | 54069 | 11705 | 172 | 0 | 40.0955451 | -80.62203992 | 2022-06-05 04:20:55 | Ohio, West Virginia, US | |
3137057 | 3137057 | 2022-06-03 | US | West Virginia | Ohio | 54069 | 11705 | 172 | 0 | 40.0955451 | -80.62203992 | 2022-06-04 04:20:58 | Ohio, West Virginia, US | |
1317129 | 1317129 | 2022-05-27 | US | Tennessee | Cocke | 47029 | 11705 | 222 | 0 | 35.9278914 | -83.11828725 | 2022-05-28 04:21:07 | Cocke, Tennessee, US | |
1112005 | 1112005 | 2022-05-21 | US | North Dakota | Stark | 38089 | 11705 | 86 | 0 | 46.80851182 | -102.6576326 | 2022-05-22 04:20:52 | Stark, North Dakota, US | |
1171629 | 1171629 | 2022-05-20 | US | North Dakota | Stark | 38089 | 11705 | 86 | 0 | 46.80851182 | -102.6576326 | 2022-05-21 04:20:58 | Stark, North Dakota, US | |
3419625 | 3419625 | 2022-04-17 | US | Pennsylvania | Union | 42119 | 11705 | 153 | 0 | 40.96188846 | -77.05996014 | 2022-04-18 04:21:12 | Union, Pennsylvania, US | |
3208512 | 3208512 | 2022-04-11 | US | New York | Livingston | 36051 | 11705 | 115 | 0 | 42.72596275 | -77.77966158 | 2022-04-12 04:20:49 | Livingston, New York, US | |
921933 | 921933 | 2022-03-08 | US | New York | Montgomery | 36057 | 11705 | 199 | 0 | 42.90123494 | -74.44011632 | 2022-03-09 04:20:59 | Montgomery, New York, US | |
732117 | 732117 | 2021-12-27 | US | Maryland | St. Mary's | 24037 | 11705 | 176 | 0 | 38.30058422 | -76.60629279999998 | 2021-12-28 04:21:47 | St. Mary's, Maryland, US | |
553705 | 553705 | 2021-12-08 | US | Tennessee | Cumberland | 47035 | 11705 | 236 | 0 | 35.95271721 | -84.99840585 | 2021-12-09 04:22:49 | Cumberland, Tennessee, US | |
3402351 | 3402351 | 2021-11-30 | US | Hawaii | Hawaii | 15001 | 11705 | 138 | 0 | 19.60121157 | -155.5210167 | 2021-12-01 04:22:29 | Hawaii, Hawaii, US | |
3346155 | 3346155 | 2021-11-16 | US | Wisconsin | Chippewa | 55017 | 11705 | 125 | 0 | 45.06939744 | -91.28068855 | 2021-11-17 04:21:48 | Chippewa, Wisconsin, US | |
3124019 | 3124019 | 2021-11-05 | US | Ohio | Scioto | 39145 | 11705 | 184 | 0 | 38.80270163 | -82.98907345 | 2021-11-06 04:21:51 | Scioto, Ohio, US | |
1911573 | 1911573 | 2021-10-17 | US | North Carolina | Rockingham | 37157 | 11705 | 192 | 0 | 36.39593137 | -79.77504841 | 2021-10-18 04:21:10 | Rockingham, North Carolina, US | |
937162 | 937162 | 2021-10-16 | US | North Carolina | Rockingham | 37157 | 11705 | 192 | 0 | 36.39593137 | -79.77504841 | 2021-10-17 04:21:29 | Rockingham, North Carolina, US | |
2945717 | 2945717 | 2021-10-15 | US | North Carolina | Rockingham | 37157 | 11705 | 192 | 0 | 36.39593137 | -79.77504841 | 2021-10-16 04:21:15 | Rockingham, North Carolina, US | |
636096 | 636096 | 2021-10-13 | US | New Jersey | Hunterdon | 34019 | 11705 | 190 | 0 | 40.56335249 | -74.91284156 | 2021-10-14 04:21:29 | Hunterdon, New Jersey, US | |
2620297 | 2620297 | 2021-09-17 | US | New York | Putnam | 36079 | 11705 | 95 | 0 | 41.42630093 | -73.74965532 | 2021-09-18 04:21:24 | Putnam, New York, US | |
1374859 | 1374859 | 2021-09-15 | US | Alabama | DeKalb | 1049 | 11705 | 220 | 0 | 34.45946862 | -85.80782906 | 2021-09-16 04:22:19 | DeKalb, Alabama, US | |
1855879 | 1855879 | 2021-08-20 | US | Missouri | Cole | 29051 | 11705 | 141 | 0 | 38.50455671 | -92.27860244 | 2021-08-21 04:21:38 | Cole, Missouri, US | |
246500 | 246500 | 2021-08-17 | US | Iowa | Pottawattamie | 19155 | 11705 | 178 | 0 | 41.33640314 | -95.53907776 | 2021-08-18 04:21:35 | Pottawattamie, Iowa, US | |
1605463 | 1605463 | 2021-08-16 | US | Iowa | Pottawattamie | 19155 | 11705 | 178 | 0 | 41.33640314 | -95.53907776 | 2021-08-17 04:21:49 | Pottawattamie, Iowa, US | |
104557 | 104557 | 2021-08-15 | US | Iowa | Pottawattamie | 19155 | 11705 | 178 | 0 | 41.33640314 | -95.53907776 | 2021-08-16 04:21:31 | Pottawattamie, Iowa, US | |
508915 | 508915 | 2021-08-14 | US | Iowa | Pottawattamie | 19155 | 11705 | 178 | 0 | 41.33640314 | -95.53907776 | 2021-08-15 04:21:41 | Pottawattamie, Iowa, US | |
1484787 | 1484787 | 2021-08-13 | US | Iowa | Pottawattamie | 19155 | 11705 | 178 | 0 | 41.33640314 | -95.53907776 | 2021-08-14 04:21:25 | Pottawattamie, Iowa, US | |
2900917 | 2900917 | 2021-08-12 | US | Iowa | Pottawattamie | 19155 | 11705 | 178 | 0 | 41.33640314 | -95.53907776 | 2021-08-13 04:21:24 | Pottawattamie, Iowa, US | |
1343521 | 1343521 | 2021-08-11 | US | Iowa | Pottawattamie | 19155 | 11705 | 178 | 0 | 41.33640314 | -95.53907776 | 2021-08-12 04:21:25 | Pottawattamie, Iowa, US | |
408736 | 408736 | 2021-07-28 | US | Arizona | Apache | 4001 | 11705 | 438 | 0 | 35.39465006 | -109.4892383 | 2021-07-29 04:21:33 | Apache, Arizona, US | |
1571334 | 1571334 | 2021-04-22 | US | Texas | Tom Green | 48451 | 11705 | 269 | 0 | 31.40464436 | -100.462443 | 2021-04-23 04:20:52 | Tom Green, Texas, US | |
36598 | 36598 | 2021-04-12 | Peru | Pasco | 11705 | 717 | 0 | 10988 | -10.39655 | -75.307635 | 2021-04-13 04:20:37 | Pasco, Peru | ||
2983326 | 2983326 | 2021-04-10 | Mali | 11705 | 405 | 7101 | 4199 | 17.570692 | -3.996166000000001 | 2021-04-11 04:20:56 | Mali | |||
615232 | 615232 | 2021-02-08 | US | Maine | Cumberland | 23005 | 11705 | 167 | 0 | 11538 | 43.8370751 | -70.37226999 | 2021-02-09 05:23:30 | Cumberland, Maine, US |
1684432 | 1684432 | 2021-02-02 | Haiti | 11705 | 245 | 9114 | 2231 | 18.9712 | -72.2852 | 2021-02-03 05:22:52 | Haiti | |||
2932976 | 2932976 | 2020-12-19 | US | Minnesota | St. Louis | 27137 | 11705 | 177 | 0 | 11528 | 47.6048407 | -92.46879855 | 2020-12-20 05:27:32 | St. Louis, Minnesota, US |
1602730 | 1602730 | 2020-12-10 | US | Ohio | Warren | 39165 | 11705 | 134 | 0 | 11571 | 39.42581994 | -84.16557457 | 2020-12-11 05:26:59 | Warren, Ohio, US |
3340074 | 3340074 | 2020-11-17 | US | Louisiana | Caddo | 22017 | 11705 | 427 | 0 | 11278 | 32.57991587 | -93.88375652 | 2020-11-18 05:40:31 | Caddo, Louisiana, US |
2195212 | 2195212 | 2020-10-21 | Ukraine | Dnipropetrovsk Oblast | 11705 | 267 | 5277 | 6161 | 48.4647 | 35.0462 | 2020-10-22 04:24:27 | Dnipropetrovsk Oblast, Ukraine | ||
2859656 | 2859656 | 2020-10-16 | US | South Carolina | Horry | 45051 | 11705 | 207 | 0 | 11498 | 33.9212828 | -78.99555293 | 2020-10-17 04:24:12 | Horry, South Carolina, US |
3612506 | 3612506 | 2020-08-06 | Russia | Voronezh Oblast | 11705 | 90 | 9736 | 1879 | 50.9800393 | 40.15065070000001 | 2020-08-07 04:35:11 | Voronezh Oblast, Russia |
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]);