johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
61 rows where active = 2737 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2107760 | 2107760 | 2021-06-01 | Ukraine | Lviv Oblast | 136016 | 3568 | 129711 | 2737 | 49.8397 | 24.0297 | 2021-06-02 04:24:34 | Lviv Oblast, Ukraine | ||
2410703 | 2410703 | 2021-04-19 | Colombia | Santander | 98671 | 3569 | 92365 | 2737 | 6.6437 | -73.6536 | 2021-04-20 04:20:41 | Santander, Colombia | ||
2646087 | 2646087 | 2021-04-08 | Togo | 11649 | 115 | 8797 | 2737 | 8.6195 | 0.8248 | 2021-04-09 04:21:13 | Togo | |||
2056186 | 2056186 | 2021-03-15 | Sri Lanka | 88238 | 532 | 84969 | 2737 | 7.873054 | 80.77179699999998 | 2021-03-16 05:25:13 | Sri Lanka | |||
2209173 | 2209173 | 2021-03-04 | US | Louisiana | Sabine | 22085 | 2792 | 55 | 0 | 2737 | 31.56388699 | -93.55433981 | 2021-03-05 05:26:29 | Sabine, Louisiana, US |
3254635 | 3254635 | 2021-03-02 | US | Arkansas | Johnson | 5071 | 2767 | 30 | 0 | 2737 | 35.56759135 | -93.46036368 | 2021-03-03 05:23:28 | Johnson, Arkansas, US |
2183791 | 2183791 | 2021-02-26 | Russia | Khabarovsk Krai | 48776 | 283 | 45756 | 2737 | 51.6312684 | 136.121524 | 2021-02-27 05:22:28 | Khabarovsk Krai, Russia | ||
1937143 | 1937143 | 2021-02-23 | US | Florida | Hardee | 12049 | 2766 | 29 | 0 | 2737 | 27.49293939 | -81.80956574 | 2021-02-24 05:29:16 | Hardee, Florida, US |
1154312 | 1154312 | 2021-02-18 | US | Iowa | Henry | 19087 | 2772 | 35 | 0 | 2737 | 40.98767962 | -91.54436349 | 2021-02-19 05:24:16 | Henry, Iowa, US |
3602232 | 3602232 | 2021-02-17 | US | Iowa | Henry | 19087 | 2772 | 35 | 0 | 2737 | 40.98767962 | -91.54436349 | 2021-02-18 05:22:58 | Henry, Iowa, US |
3051244 | 3051244 | 2021-02-16 | US | Indiana | Daviess | 18027 | 2829 | 92 | 0 | 2737 | 38.70186039 | -87.07185406 | 2021-02-17 05:23:10 | Daviess, Indiana, US |
2285328 | 2285328 | 2021-02-14 | US | Missouri | Howell | 29091 | 2779 | 42 | 0 | 2737 | 36.77383887 | -91.88683935 | 2021-02-15 05:24:49 | Howell, Missouri, US |
2284928 | 2284928 | 2021-02-14 | US | Louisiana | Jefferson Davis | 22053 | 2819 | 82 | 0 | 2737 | 30.26896765 | -92.81210004 | 2021-02-15 05:24:49 | Jefferson Davis, Louisiana, US |
3542361 | 3542361 | 2021-02-12 | US | South Dakota | Yankton | 46135 | 2765 | 28 | 0 | 2737 | 43.00924485 | -97.39467635 | 2021-02-13 05:22:12 | Yankton, South Dakota, US |
3542335 | 3542335 | 2021-02-12 | US | South Dakota | Lawrence | 46081 | 2781 | 44 | 0 | 2737 | 44.35919441 | -103.7929428 | 2021-02-13 05:22:12 | Lawrence, South Dakota, US |
2640624 | 2640624 | 2021-02-11 | US | South Dakota | Yankton | 46135 | 2765 | 28 | 0 | 2737 | 43.00924485 | -97.39467635 | 2021-02-12 05:23:29 | Yankton, South Dakota, US |
2639465 | 2639465 | 2021-02-11 | US | Minnesota | Pine | 27115 | 2753 | 16 | 0 | 2737 | 46.12105238 | -92.74070188 | 2021-02-12 05:23:29 | Pine, Minnesota, US |
3981962 | 3981962 | 2021-02-10 | US | Virginia | Prince George | 51149 | 2747 | 10 | 0 | 2737 | 37.18497668 | -77.22922187 | 2021-02-11 05:23:55 | Prince George, Virginia, US |
615915 | 615915 | 2021-02-08 | US | New York | Fulton | 36035 | 2809 | 72 | 0 | 2737 | 43.11363907 | -74.41798804 | 2021-02-09 05:23:30 | Fulton, New York, US |
1680105 | 1680105 | 2021-02-01 | Ukraine | Sumy Oblast | 45919 | 617 | 42565 | 2737 | 50.9077 | 34.7981 | 2021-02-02 05:22:49 | Sumy Oblast, Ukraine | ||
1898075 | 1898075 | 2021-01-29 | US | Idaho | Cassia | 16031 | 2759 | 22 | 0 | 2737 | 42.28347888 | -113.6012409 | 2021-01-30 05:22:49 | Cassia, Idaho, US |
2484191 | 2484191 | 2021-01-28 | US | New York | Cortland | 36023 | 2793 | 56 | 0 | 2737 | 42.59509207 | -76.07048931 | 2021-01-29 05:22:23 | Cortland, New York, US |
14250 | 14250 | 2021-01-26 | US | Missouri | Laclede | 29105 | 2793 | 56 | 0 | 2737 | 37.65896829 | -92.5888493 | 2021-01-27 05:23:41 | Laclede, Missouri, US |
2570129 | 2570129 | 2021-01-25 | US | Ohio | Highland | 39071 | 2790 | 53 | 0 | 2737 | 39.1839264 | -83.60331456 | 2021-01-26 05:22:02 | Highland, Ohio, US |
191782 | 191782 | 2021-01-11 | US | Minnesota | Isanti | 27059 | 2776 | 39 | 0 | 2737 | 45.56181234 | -93.29487636 | 2021-01-12 05:22:15 | Isanti, Minnesota, US |
2627586 | 2627586 | 2021-01-10 | US | Minnesota | Itasca | 27061 | 2778 | 41 | 0 | 2737 | 47.51009045 | -93.63092229 | 2021-01-11 05:21:50 | Itasca, Minnesota, US |
3901774 | 3901774 | 2021-01-09 | US | Mississippi | Lincoln | 28085 | 2818 | 81 | 0 | 2737 | 31.53288662 | -90.45391915 | 2021-01-10 05:22:12 | Lincoln, Mississippi, US |
3899690 | 3899690 | 2021-01-09 | Brazil | Alagoas | 108109 | 2553 | 102819 | 2737 | -9.5713 | -36.782 | 2021-01-10 05:22:12 | Alagoas, Brazil | ||
1061795 | 1061795 | 2021-01-04 | India | Haryana | 263312 | 2923 | 257652 | 2737 | 29.20004 | 76.332824 | 2021-01-05 05:21:49 | Haryana, India | ||
767415 | 767415 | 2020-12-29 | US | Indiana | Knox | 18083 | 2806 | 69 | 0 | 2737 | 38.68861576 | -87.4194665 | 2020-12-30 05:22:34 | Knox, Indiana, US |
2225328 | 2225328 | 2020-12-26 | US | Mississippi | Monroe | 28095 | 2821 | 84 | 0 | 2737 | 33.89236763 | -88.4808438 | 2020-12-27 05:22:55 | Monroe, Mississippi, US |
3691826 | 3691826 | 2020-12-24 | US | Alabama | Chilton | 1021 | 2790 | 53 | 0 | 2737 | 32.85044126 | -86.7173256 | 2020-12-25 05:22:48 | Chilton, Alabama, US |
1036873 | 1036873 | 2020-12-15 | US | Ohio | Sandusky | 39143 | 2794 | 57 | 0 | 2737 | 41.35624126 | -83.137872 | 2020-12-16 05:28:04 | Sandusky, Ohio, US |
1601484 | 1601484 | 2020-12-10 | US | Kansas | Crawford | 20037 | 2756 | 19 | 0 | 2737 | 37.50675523 | -94.85245778 | 2020-12-11 05:26:59 | Crawford, Kansas, US |
1601041 | 1601041 | 2020-12-10 | US | Georgia | Laurens | 13175 | 2856 | 119 | 0 | 2737 | 32.46325233 | -82.92221316 | 2020-12-11 05:26:59 | Laurens, Georgia, US |
2976493 | 2976493 | 2020-12-09 | US | Kansas | Crawford | 20037 | 2756 | 19 | 0 | 2737 | 37.50675523 | -94.85245778 | 2020-12-10 05:26:19 | Crawford, Kansas, US |
2975749 | 2975749 | 2020-12-09 | US | Arkansas | Unassigned | 90005 | 2737 | 0 | 0 | 2737 | 36.38177105 | 0.0 | 2020-12-10 05:26:19 | Unassigned, Arkansas, US |
1975489 | 1975489 | 2020-11-25 | US | Tennessee | Anderson | 47001 | 2751 | 28 | 0 | 2737 | 36.12684348 | -84.19965764 | 2020-11-26 05:27:44 | Anderson, Tennessee, US |
2703936 | 2703936 | 2020-11-20 | US | North Dakota | Williams | 38105 | 3149 | 22 | 0 | 2737 | 48.34522353 | -103.4793387 | 2020-11-21 05:25:51 | Williams, North Dakota, US |
823866 | 823866 | 2020-11-19 | US | North Carolina | Craven | 37049 | 2804 | 67 | 0 | 2737 | 35.11833364 | -77.08398081 | 2020-11-20 05:26:28 | Craven, North Carolina, US |
822645 | 822645 | 2020-11-19 | US | Indiana | Floyd | 18043 | 2824 | 87 | 0 | 2737 | 38.32117957 | -85.90385377 | 2020-11-20 05:26:28 | Floyd, Indiana, US |
3340856 | 3340856 | 2020-11-17 | US | New York | Ulster | 36111 | 2835 | 98 | 0 | 2737 | 41.89027881 | -74.26252104 | 2020-11-18 05:40:31 | Ulster, New York, US |
1988543 | 1988543 | 2020-11-09 | Germany | Bremen | 7133 | 87 | 4441 | 2737 | 53.0793 | 8.8017 | 2020-11-10 05:40:07 | Bremen, Germany | ||
376411 | 376411 | 2020-11-06 | Russia | Omsk Oblast | 17016 | 434 | 13845 | 2737 | 56.09352629999999 | 73.5099936 | 2020-11-07 05:24:52 | Omsk Oblast, Russia | ||
2243155 | 2243155 | 2020-10-30 | Canada | Manitoba | 5374 | 65 | 2572 | 2737 | 53.7609 | -98.8139 | 2020-10-31 04:24:44 | Manitoba, Canada | ||
1177680 | 1177680 | 2020-10-22 | Russia | Bryansk Oblast | 11495 | 50 | 8708 | 2737 | 52.8873315 | 33.41585300000001 | 2020-10-23 04:24:46 | Bryansk Oblast, Russia | ||
2603817 | 2603817 | 2020-10-10 | US | Mississippi | Forrest | 28035 | 2813 | 76 | 0 | 2737 | 31.18961454 | -89.25832496 | 2020-10-11 04:23:46 | Forrest, Mississippi, US |
3803643 | 3803643 | 2020-10-05 | US | Minnesota | Scott | 27139 | 2770 | 33 | 0 | 2737 | 44.6490231 | -93.53340251 | 2020-10-06 04:23:33 | Scott, Minnesota, US |
2515271 | 2515271 | 2020-10-03 | US | Indiana | Monroe | 18105 | 2776 | 39 | 0 | 2737 | 39.16130004 | -86.52414358 | 2020-10-04 04:23:44 | Monroe, Indiana, US |
3390260 | 3390260 | 2020-10-02 | US | Georgia | Troup | 13285 | 2837 | 100 | 0 | 2737 | 33.03349196 | -85.02812115 | 2020-10-03 04:23:40 | Troup, Georgia, US |
548243 | 548243 | 2020-09-12 | US | Louisiana | Iberia | 22045 | 2826 | 89 | 0 | 2737 | 29.86803617 | -91.75871777 | 2020-09-13 04:30:52 | Iberia, Louisiana, US |
1446072 | 1446072 | 2020-09-11 | US | Louisiana | Iberia | 22045 | 2826 | 89 | 0 | 2737 | 29.86803617 | -91.75871777 | 2020-09-12 04:25:05 | Iberia, Louisiana, US |
194758 | 194758 | 2020-08-31 | US | Florida | Indian River | 12061 | 2835 | 98 | 0 | 2737 | 27.69308961 | -80.60556721 | 2020-09-01 04:28:31 | Indian River, Florida, US |
3263347 | 3263347 | 2020-07-31 | US | Florida | Okaloosa | 12091 | 2765 | 28 | 0 | 2737 | 30.69143028 | -86.59267105 | 2020-08-01 04:36:27 | Okaloosa, Florida, US |
441599 | 441599 | 2020-07-26 | US | New Mexico | San Juan | 35045 | 2915 | 178 | 0 | 2737 | 36.50838318 | -108.320437 | 2020-07-27 04:35:02 | San Juan, New Mexico, US |
1499904 | 1499904 | 2020-07-25 | US | Arizona | Coconino | 4005 | 2849 | 112 | 0 | 2737 | 35.83883429 | -111.7707178 | 2020-07-26 04:35:00 | Coconino, Arizona, US |
58581 | 58581 | 2020-07-23 | US | Minnesota | Anoka | 27003 | 2848 | 111 | 0 | 2737 | 45.27476015 | -93.24604565 | 2020-07-24 05:30:40 | Anoka, Minnesota, US |
2685297 | 2685297 | 2020-07-06 | Serbia | 16420 | 317 | 13366 | 2737 | 44.0165 | 21.0059 | 2020-07-07 04:34:00 | Serbia | |||
2232906 | 2232906 | 2020-07-03 | US | Pennsylvania | Luzerne | 42079 | 2915 | 178 | 0 | 2737 | 41.17823008 | -75.98447579 | 2020-07-04 04:33:51 | Luzerne, Pennsylvania, US |
1835056 | 1835056 | 2020-06-14 | US | New Hampshire | Hillsborough | 33011 | 2942 | 205 | 0 | 2737 | 42.91537785 | -71.7200253 | 2020-06-15 03:33:14 | Hillsborough, New Hampshire, US |
1829648 | 1829648 | 2020-05-16 | Czechia | 8455 | 296 | 5422 | 2737 | 49.8175 | 15.472999999999999 | 2020-05-17 02:32:32 | Czechia |
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]);