johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
30 rows where active = 5874 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3254501 | 3254501 | 2021-03-02 | US | Alabama | Colbert | 1033 | 5993 | 119 | 0 | 5874 | 34.69847452 | -87.80168544 | 2021-03-03 05:23:28 | Colbert, Alabama, US |
1861100 | 1861100 | 2021-02-25 | US | Texas | Hale | 48189 | 2472 | 152 | 0 | 5874 | 34.07044901 | -101.8268114 | 2021-02-26 05:22:40 | Hale, Texas, US |
281659 | 281659 | 2021-02-24 | US | Louisiana | Acadia | 22001 | 6057 | 183 | 0 | 5874 | 30.2950649 | -92.41419698 | 2021-02-25 05:24:57 | Acadia, Louisiana, US |
472521 | 472521 | 2021-02-19 | US | Indiana | Morgan | 18109 | 5998 | 124 | 0 | 5874 | 39.47899078 | -86.44573375 | 2021-02-20 05:22:51 | Morgan, Indiana, US |
2286245 | 2286245 | 2021-02-14 | US | South Carolina | Laurens | 45059 | 6023 | 149 | 0 | 5874 | 34.48244419 | -82.00490796 | 2021-02-15 05:24:49 | Laurens, South Carolina, US |
1675914 | 1675914 | 2021-02-07 | US | Washington | Whatcom | 53073 | 5943 | 69 | 0 | 5874 | 48.82227976 | -121.7490018 | 2021-02-08 05:22:39 | Whatcom, Washington, US |
978375 | 978375 | 2021-02-06 | US | Washington | Whatcom | 53073 | 5943 | 69 | 0 | 5874 | 48.82227976 | -121.7490018 | 2021-02-07 05:23:00 | Whatcom, Washington, US |
1591177 | 1591177 | 2021-02-05 | US | Texas | Anderson | 48001 | 5636 | 92 | 0 | 5874 | 31.81534745 | -95.65354823 | 2021-02-06 05:23:55 | Anderson, Texas, US |
1459791 | 1459791 | 2021-01-31 | Japan | Osaka | 43756 | 926 | 36956 | 5874 | 34.620965000000005 | 135.507481 | 2021-02-01 05:22:53 | Osaka, Japan | ||
2568133 | 2568133 | 2021-01-25 | US | Arkansas | Crawford | 5033 | 5959 | 85 | 0 | 5874 | 35.58928601 | -94.2446814 | 2021-01-26 05:22:02 | Crawford, Arkansas, US |
769906 | 769906 | 2020-12-29 | US | Wisconsin | Wood | 55141 | 5927 | 53 | 0 | 5874 | 44.45537896 | -90.04158336 | 2020-12-30 05:22:34 | Wood, Wisconsin, US |
768826 | 768826 | 2020-12-29 | US | Ohio | Tuscarawas | 39157 | 6047 | 173 | 0 | 5874 | 40.44214695 | -81.47226262 | 2020-12-30 05:22:34 | Tuscarawas, Ohio, US |
1633060 | 1633060 | 2020-12-05 | US | Georgia | Carroll | 13045 | 5973 | 99 | 0 | 5874 | 33.58138199 | -85.07976677 | 2020-12-06 05:26:18 | Carroll, Georgia, US |
3863308 | 3863308 | 2020-12-04 | US | West Virginia | Kanawha | 54039 | 6023 | 149 | 0 | 5874 | 38.33860077 | -81.52857054 | 2020-12-05 05:27:36 | Kanawha, West Virginia, US |
3862484 | 3862484 | 2020-12-04 | US | Pennsylvania | Cumberland | 42041 | 6035 | 161 | 0 | 5874 | 40.1625372 | -77.26130755 | 2020-12-05 05:27:36 | Cumberland, Pennsylvania, US |
3859973 | 3859973 | 2020-12-04 | Pakistan | Islamabad | 31992 | 334 | 25784 | 5874 | 33.665087 | 73.121219 | 2020-12-05 05:27:36 | Islamabad, Pakistan | ||
1974467 | 1974467 | 2020-11-25 | US | Missouri | Cole | 29051 | 5923 | 49 | 0 | 5874 | 38.50455671 | -92.27860244 | 2020-11-26 05:27:44 | Cole, Missouri, US |
2785521 | 2785521 | 2020-11-13 | US | Arkansas | Sebastian | 5131 | 5984 | 110 | 0 | 5874 | 35.19605503 | -94.27162713 | 2020-11-14 05:25:37 | Sebastian, Arkansas, US |
3306983 | 3306983 | 2020-11-02 | US | South Carolina | Anderson | 45007 | 6083 | 209 | 0 | 5874 | 34.51828081 | -82.63959517 | 2020-11-03 06:00:16 | Anderson, South Carolina, US |
1453261 | 1453261 | 2020-10-27 | US | Florida | Clay | 12019 | 5993 | 119 | 0 | 5874 | 29.98319144 | -81.85609986 | 2020-10-28 04:24:39 | Clay, Florida, US |
3802897 | 3802897 | 2020-10-05 | US | Illinois | Madison | 17119 | 6021 | 147 | 0 | 5874 | 38.83042506 | -89.90422563 | 2020-10-06 04:23:33 | Madison, Illinois, US |
1515362 | 1515362 | 2020-09-28 | India | Tripura | 25353 | 276 | 19203 | 5874 | 23.746783 | 91.743565 | 2020-09-29 04:23:42 | Tripura, India | ||
427636 | 427636 | 2020-09-07 | Sudan | 13437 | 833 | 6730 | 5874 | 12.8628 | 30.2176 | 2020-09-08 04:28:25 | Sudan | |||
3161921 | 3161921 | 2020-09-06 | Sudan | 13437 | 833 | 6730 | 5874 | 12.8628 | 30.2176 | 2020-09-07 04:28:30 | Sudan | |||
1555831 | 1555831 | 2020-08-16 | Colombia | Santander | 10018 | 397 | 3747 | 5874 | 6.6437 | -73.6536 | 2020-08-17 04:27:20 | Santander, Colombia | ||
2563650 | 2563650 | 2020-07-24 | Netherlands | Gelderland | 6681 | 686 | 0 | 5874 | 52.061738 | 5.939114 | 2020-07-25 04:47:39 | Gelderland, Netherlands | ||
3433240 | 3433240 | 2020-07-11 | US | Florida | Collier | 12021 | 5968 | 94 | 0 | 5874 | 26.11091986 | -81.34687065 | 2020-07-12 04:34:30 | Collier, Florida, US |
1270935 | 1270935 | 2020-06-11 | US | Colorado | Denver | 8031 | 6844 | 376 | 0 | 5874 | 39.76018276 | -104.8725695 | 2020-06-12 05:09:52 | Denver, Colorado, US |
214626 | 214626 | 2020-06-08 | US | Tennessee | Davidson | 47037 | 5983 | 73 | 0 | 5874 | 36.17007426 | -86.78646056 | 2020-06-09 03:33:03 | Davidson, Tennessee, US |
3416504 | 3416504 | 2020-05-17 | Romania | 16871 | 1107 | 9890 | 5874 | 45.9432 | 24.9668 | 2020-05-18 02:32:21 | Romania |
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]);