johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
54 rows where active = 3850 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3030360 | 3030360 | 2021-06-16 | Mali | 14359 | 523 | 9986 | 3850 | 17.570692 | -3.996166000000001 | 2021-06-17 04:22:36 | Mali | |||
2186497 | 2186497 | 2021-02-26 | US | Tennessee | Cheatham | 47021 | 3923 | 44 | 0 | 3850 | 36.26136216 | -87.08903581 | 2021-02-27 05:22:28 | Cheatham, Tennessee, US |
1859243 | 1859243 | 2021-02-25 | US | Iowa | Wapello | 19179 | 3958 | 108 | 0 | 3850 | 41.03064984 | -92.40954728 | 2021-02-26 05:22:40 | Wapello, Iowa, US |
1858362 | 1858362 | 2021-02-25 | US | Alabama | Covington | 1039 | 3956 | 106 | 0 | 3850 | 31.2477854 | -86.45050893 | 2021-02-26 05:22:40 | Covington, Alabama, US |
281174 | 281174 | 2021-02-24 | US | Illinois | Jefferson | 17081 | 3965 | 115 | 0 | 3850 | 38.29980057 | -88.9240025 | 2021-02-25 05:24:57 | Jefferson, Illinois, US |
1939656 | 1939656 | 2021-02-23 | US | Texas | San Patricio | 48409 | 3713 | 127 | 0 | 3850 | 28.00880118 | -97.51763891 | 2021-02-24 05:29:16 | San Patricio, Texas, US |
533911 | 533911 | 2021-02-22 | US | Texas | San Patricio | 48409 | 3713 | 127 | 0 | 3850 | 28.00880118 | -97.51763891 | 2021-02-23 05:23:41 | San Patricio, Texas, US |
533778 | 533778 | 2021-02-22 | US | Texas | Erath | 48143 | 3664 | 64 | 0 | 3850 | 32.23602653 | -98.21773417 | 2021-02-23 05:23:41 | Erath, Texas, US |
533556 | 533556 | 2021-02-22 | US | South Dakota | Codington | 46029 | 3927 | 77 | 0 | 3850 | 44.97788119 | -97.18827677 | 2021-02-23 05:23:41 | Codington, South Dakota, US |
185245 | 185245 | 2021-02-21 | US | Texas | San Patricio | 48409 | 3713 | 127 | 0 | 3850 | 28.00880118 | -97.51763891 | 2021-02-22 05:24:21 | San Patricio, Texas, US |
185112 | 185112 | 2021-02-21 | US | Texas | Erath | 48143 | 3664 | 64 | 0 | 3850 | 32.23602653 | -98.21773417 | 2021-02-22 05:24:21 | Erath, Texas, US |
184890 | 184890 | 2021-02-21 | US | South Dakota | Codington | 46029 | 3927 | 77 | 0 | 3850 | 44.97788119 | -97.18827677 | 2021-02-22 05:24:21 | Codington, South Dakota, US |
745519 | 745519 | 2021-02-20 | US | Texas | San Patricio | 48409 | 3713 | 127 | 0 | 3850 | 28.00880118 | -97.51763891 | 2021-02-21 05:24:33 | San Patricio, Texas, US |
745386 | 745386 | 2021-02-20 | US | Texas | Erath | 48143 | 3664 | 64 | 0 | 3850 | 32.23602653 | -98.21773417 | 2021-02-21 05:24:33 | Erath, Texas, US |
474617 | 474617 | 2021-02-19 | US | Texas | San Patricio | 48409 | 3713 | 127 | 0 | 3850 | 28.00880118 | -97.51763891 | 2021-02-20 05:22:51 | San Patricio, Texas, US |
473024 | 473024 | 2021-02-19 | US | Michigan | Cass | 26027 | 3913 | 63 | 0 | 3850 | 41.91522292 | -85.99405727 | 2021-02-20 05:22:51 | Cass, Michigan, US |
472808 | 472808 | 2021-02-19 | US | Kentucky | Graves | 21083 | 3920 | 70 | 0 | 3850 | 36.72292505 | -88.65143315 | 2021-02-20 05:22:51 | Graves, Kentucky, US |
1156326 | 1156326 | 2021-02-18 | US | Texas | San Patricio | 48409 | 3713 | 127 | 0 | 3850 | 28.00880118 | -97.51763891 | 2021-02-19 05:24:16 | San Patricio, Texas, US |
2679362 | 2679362 | 2021-02-13 | US | Louisiana | Washington | 22117 | 3967 | 117 | 0 | 3850 | 30.85288548 | -90.03866652 | 2021-02-14 05:23:43 | Washington, Louisiana, US |
3540995 | 3540995 | 2021-02-12 | US | Louisiana | Washington | 22117 | 3967 | 117 | 0 | 3850 | 30.85288548 | -90.03866652 | 2021-02-13 05:22:12 | Washington, Louisiana, US |
3980104 | 3980104 | 2021-02-10 | US | Louisiana | St. Mary | 22101 | 3967 | 117 | 0 | 3850 | 29.69262097 | -91.44702164 | 2021-02-11 05:23:55 | St. Mary, Louisiana, US |
977583 | 977583 | 2021-02-06 | US | Pennsylvania | Huntingdon | 42061 | 3966 | 116 | 0 | 3850 | 40.42162652 | -77.97673273 | 2021-02-07 05:23:00 | Huntingdon, Pennsylvania, US |
2213973 | 2213973 | 2021-01-30 | US | North Carolina | Edgecombe | 37065 | 3940 | 90 | 0 | 3850 | 35.91230639 | -77.59436892 | 2021-01-31 05:22:42 | Edgecombe, North Carolina, US |
2212408 | 2212408 | 2021-01-30 | US | Georgia | Baldwin | 13009 | 3944 | 94 | 0 | 3850 | 33.06882326 | -83.24701748 | 2021-01-31 05:22:42 | Baldwin, Georgia, US |
1899460 | 1899460 | 2021-01-29 | US | North Carolina | Edgecombe | 37065 | 3940 | 90 | 0 | 3850 | 35.91230639 | -77.59436892 | 2021-01-30 05:22:49 | Edgecombe, North Carolina, US |
909948 | 909948 | 2021-01-19 | US | Minnesota | Winona | 27169 | 3896 | 46 | 0 | 3850 | 43.98772283 | -91.78081305 | 2021-01-20 05:21:54 | Winona, Minnesota, US |
238126 | 238126 | 2021-01-18 | US | Georgia | Ware | 13299 | 3946 | 96 | 0 | 3850 | 31.05449097 | -82.42224148 | 2021-01-19 05:22:15 | Ware, Georgia, US |
3879643 | 3879643 | 2021-01-14 | Malawi | 9991 | 275 | 5866 | 3850 | -13.2543 | 34.3015 | 2021-01-15 05:22:24 | Malawi | |||
192282 | 192282 | 2021-01-11 | US | New York | Cayuga | 36011 | 3902 | 52 | 0 | 3850 | 42.91261714 | -76.55731592 | 2021-01-12 05:22:15 | Cayuga, New York, US |
3762694 | 3762694 | 2020-12-28 | US | Indiana | Noble | 18113 | 3912 | 62 | 0 | 3850 | 41.39672484 | -85.41966713 | 2020-12-29 05:22:37 | Noble, Indiana, US |
2406610 | 2406610 | 2020-12-23 | Canada | Saskatchewan | 14100 | 130 | 10121 | 3850 | 52.9399 | -106.4509 | 2020-12-24 05:23:04 | Saskatchewan, Canada | ||
2122016 | 2122016 | 2020-12-20 | US | North Carolina | Duplin | 37061 | 3915 | 65 | 0 | 3850 | 34.93449805 | -77.93140529 | 2020-12-21 05:27:58 | Duplin, North Carolina, US |
1753685 | 1753685 | 2020-12-14 | US | North Dakota | Stark | 38089 | 3880 | 40 | 0 | 3850 | 46.80851182 | -102.6576326 | 2020-12-15 05:26:38 | Stark, North Dakota, US |
2978227 | 2978227 | 2020-12-09 | US | Texas | Anderson | 48001 | 3284 | 51 | 0 | 3850 | 31.81534745 | -95.65354823 | 2020-12-10 05:26:19 | Anderson, Texas, US |
1633533 | 1633533 | 2020-12-05 | US | Iowa | Sioux | 19167 | 3879 | 29 | 0 | 3850 | 43.08221074 | -96.1767568 | 2020-12-06 05:26:18 | Sioux, Iowa, US |
2538272 | 2538272 | 2020-12-01 | US | Georgia | Troup | 13285 | 3970 | 120 | 0 | 3850 | 33.03349196 | -85.02812115 | 2020-12-02 05:27:41 | Troup, Georgia, US |
3339542 | 3339542 | 2020-11-17 | US | Illinois | Adams | 17001 | 3888 | 38 | 0 | 3850 | 39.98815591 | -91.18786813 | 2020-11-18 05:40:31 | Adams, Illinois, US |
1546610 | 1546610 | 2020-11-07 | US | Pennsylvania | Lackawanna | 42069 | 4072 | 222 | 0 | 3850 | 41.43564672 | -75.60379201 | 2020-11-08 05:24:56 | Lackawanna, Pennsylvania, US |
818005 | 818005 | 2020-10-09 | US | Arizona | Mohave | 4015 | 4078 | 228 | 0 | 3850 | 35.70471703 | -113.7577902 | 2020-10-10 04:23:57 | Mohave, Arizona, US |
2691181 | 2691181 | 2020-10-08 | US | Louisiana | Livingston | 22063 | 3926 | 76 | 0 | 3850 | 30.44143993 | -90.73061664 | 2020-10-09 04:23:59 | Livingston, Louisiana, US |
2605802 | 2605802 | 2020-09-24 | Canada | Ontario | 50212 | 2836 | 43902 | 3850 | 51.2538 | -85.3232 | 2020-09-25 04:23:00 | Ontario, Canada | ||
1121434 | 1121434 | 2020-09-17 | Colombia | Cesar | 16649 | 475 | 12324 | 3850 | 9.3373 | -73.6536 | 2020-09-18 05:05:00 | Cesar, Colombia | ||
816877 | 816877 | 2020-09-05 | US | Virginia | Chesapeake | 51550 | 3899 | 49 | 0 | 3850 | 36.67670048 | -76.30545744 | 2020-09-06 04:28:33 | Chesapeake, Virginia, US |
2664399 | 2664399 | 2020-09-04 | US | Oregon | Washington | 41067 | 3898 | 48 | 0 | 3850 | 45.55972701 | -123.0955257 | 2020-09-05 04:28:19 | Washington, Oregon, US |
1105256 | 1105256 | 2020-09-02 | Albania | 9728 | 296 | 5582 | 3850 | 41.1533 | 20.1683 | 2020-09-03 04:28:22 | Albania | |||
197449 | 197449 | 2020-08-31 | US | Virginia | Richmond City | 51760 | 3897 | 47 | 0 | 3850 | 37.53255773 | -77.47966921 | 2020-09-01 04:28:31 | Richmond City, Virginia, US |
612039 | 612039 | 2020-08-29 | US | North Carolina | Union | 37179 | 3898 | 48 | 0 | 3850 | 34.98960527 | -80.52955873 | 2020-08-30 04:28:22 | Union, North Carolina, US |
2300156 | 2300156 | 2020-08-22 | US | Florida | Okaloosa | 12091 | 3921 | 71 | 0 | 3850 | 30.69143028 | -86.59267105 | 2020-08-23 04:27:48 | Okaloosa, Florida, US |
3487479 | 3487479 | 2020-08-20 | US | Texas | Potter | 48375 | 3904 | 51 | 0 | 3850 | 35.40133773 | -101.893964 | 2020-08-21 04:27:41 | Potter, Texas, US |
837583 | 837583 | 2020-08-17 | India | Uttarakhand | 12493 | 158 | 8485 | 3850 | 30.156447 | 79.197608 | 2020-08-18 04:27:56 | Uttarakhand, India | ||
1501194 | 1501194 | 2020-07-25 | US | Texas | McLennan | 48309 | 1497 | 35 | 0 | 3850 | 31.55255453 | -97.20217694 | 2020-07-26 04:35:00 | McLennan, Texas, US |
3204894 | 3204894 | 2020-07-18 | US | Nevada | Washoe | 32031 | 3951 | 101 | 0 | 3850 | 40.66562265 | -119.6631594 | 2020-07-19 04:34:58 | Washoe, Nevada, US |
1273791 | 1273791 | 2020-06-11 | Congo (Kinshasa) | 4515 | 98 | 567 | 3850 | -4.0383 | 21.7587 | 2020-06-12 05:09:52 | Congo (Kinshasa) | |||
859118 | 859118 | 2020-04-15 | US | New Jersey | Ocean | 34029 | 4016 | 166 | 0 | 3850 | 39.8895449 | -74.28089251 | 2020-04-15 22:56:51 | Ocean, New Jersey, 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]);