johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
40 rows where active = 3427 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3129576 | 3129576 | 2021-04-18 | Kyrgyzstan | 91883 | 1549 | 86907 | 3427 | 41.20438 | 74.766098 | 2021-04-19 04:20:57 | Kyrgyzstan | |||
2210243 | 2210243 | 2021-03-04 | US | Oklahoma | Texas | 40139 | 3451 | 24 | 0 | 3427 | 36.74777635 | -101.4889765 | 2021-03-05 05:26:29 | Texas, Oklahoma, US |
998673 | 998673 | 2021-03-01 | Russia | Penza Oblast | 38459 | 440 | 34592 | 3427 | 53.1655415 | 44.78791810000001 | 2021-03-02 05:23:30 | Penza Oblast, Russia | ||
2368515 | 2368515 | 2021-02-28 | US | Illinois | Montgomery | 17135 | 3495 | 68 | 0 | 3427 | 39.23198845 | -89.47809254 | 2021-03-01 05:23:01 | Montgomery, Illinois, US |
2183812 | 2183812 | 2021-02-26 | Russia | Novgorod Oblast | 27014 | 113 | 23474 | 3427 | 58.2843833 | 32.5169757 | 2021-02-27 05:22:28 | Novgorod Oblast, Russia | ||
1937598 | 1937598 | 2021-02-23 | US | Indiana | Whitley | 18183 | 3462 | 35 | 0 | 3427 | 41.13863784 | -85.50791236 | 2021-02-24 05:29:16 | Whitley, Indiana, US |
182571 | 182571 | 2021-02-21 | US | California | Amador | 6005 | 3464 | 39 | 0 | 3427 | 38.44583082 | -120.65696 | 2021-02-22 05:24:21 | Amador, California, US |
3979258 | 3979258 | 2021-02-10 | US | Florida | DeSoto | 12027 | 3496 | 69 | 0 | 3427 | 27.18677893 | -81.80941373 | 2021-02-11 05:23:55 | DeSoto, Florida, US |
1591659 | 1591659 | 2021-02-05 | US | West Virginia | Marion | 54049 | 3455 | 28 | 0 | 3427 | 39.50984542 | -80.24244659 | 2021-02-06 05:23:55 | Marion, West Virginia, US |
341329 | 341329 | 2021-02-03 | US | Illinois | Woodford | 17203 | 3484 | 57 | 0 | 3427 | 40.78579374 | -89.20973757 | 2021-02-04 05:22:26 | Woodford, Illinois, US |
1685766 | 1685766 | 2021-02-02 | US | Kansas | Cowley | 20035 | 3491 | 64 | 0 | 3427 | 37.23781842 | -96.83776647 | 2021-02-03 05:22:52 | Cowley, Kansas, US |
1677736 | 1677736 | 2021-02-01 | US | Kansas | Cowley | 20035 | 3491 | 64 | 0 | 3427 | 37.23781842 | -96.83776647 | 2021-02-02 05:22:49 | Cowley, Kansas, US |
911137 | 911137 | 2021-01-19 | US | Tennessee | Marshall | 47117 | 3523 | 36 | 0 | 3427 | 35.45798777 | -86.76420988 | 2021-01-20 05:21:54 | Marshall, Tennessee, US |
3310843 | 3310843 | 2021-01-13 | US | Pennsylvania | Bradford | 42015 | 3487 | 60 | 0 | 3427 | 41.78869215 | -76.51570822 | 2021-01-14 05:22:32 | Bradford, Pennsylvania, US |
776253 | 776253 | 2021-01-12 | US | Missouri | Johnson | 29101 | 3461 | 34 | 0 | 3427 | 38.74719601 | -93.80691168 | 2021-01-13 05:22:15 | Johnson, Missouri, US |
3034662 | 3034662 | 2021-01-05 | US | Alabama | Dale | 1045 | 3491 | 64 | 0 | 3427 | 31.43037123 | -85.61095742 | 2021-01-06 05:22:16 | Dale, Alabama, US |
1062092 | 1062092 | 2021-01-04 | Russia | Smolensk Oblast | 17693 | 344 | 13922 | 3427 | 55.03434960000001 | 33.0192065 | 2021-01-05 05:21:49 | Smolensk Oblast, Russia | ||
3779816 | 3779816 | 2020-12-27 | US | Missouri | Lincoln | 29113 | 3447 | 20 | 0 | 3427 | 39.05345619 | -90.95588181 | 2020-12-28 05:22:06 | Lincoln, Missouri, US |
2934036 | 2934036 | 2020-12-19 | US | South Carolina | Kershaw | 45055 | 3499 | 72 | 0 | 3427 | 34.33988254 | -80.58763164 | 2020-12-20 05:27:32 | Kershaw, South Carolina, US |
3850234 | 3850234 | 2020-12-13 | US | Ohio | Darke | 39037 | 3500 | 73 | 0 | 3427 | 40.13412966 | -84.6194517 | 2020-12-14 05:26:27 | Darke, Ohio, US |
2977578 | 2977578 | 2020-12-09 | US | North Carolina | Rockingham | 37157 | 3450 | 23 | 0 | 3427 | 36.39593137 | -79.77504841 | 2020-12-10 05:26:19 | Rockingham, North Carolina, US |
1584742 | 1584742 | 2020-11-30 | US | California | Sutter | 6101 | 3442 | 16 | 0 | 3427 | 39.03417539 | -121.6945899 | 2020-12-01 05:26:18 | Sutter, California, US |
1351559 | 1351559 | 2020-11-24 | US | Iowa | Webster | 19187 | 3458 | 31 | 0 | 3427 | 42.42853483 | -94.17987389 | 2020-11-25 05:27:20 | Webster, Iowa, US |
124880 | 124880 | 2020-11-18 | US | New Mexico | Chaves | 35005 | 3452 | 25 | 0 | 3427 | 33.36406072 | -104.4665365 | 2020-11-19 05:25:23 | Chaves, New Mexico, US |
867769 | 867769 | 2020-11-12 | US | Texas | Anderson | 48001 | 2865 | 43 | 0 | 3427 | 31.81534745 | -95.65354823 | 2020-11-13 05:25:30 | Anderson, Texas, US |
1728344 | 1728344 | 2020-11-08 | Colombia | Santander | 45561 | 1778 | 40356 | 3427 | 6.6437 | -73.6536 | 2020-11-09 05:25:45 | Santander, Colombia | ||
2615259 | 2615259 | 2020-09-26 | US | Iowa | Story | 19169 | 3444 | 17 | 0 | 3427 | 42.03621213 | -93.46499005 | 2020-09-27 04:23:00 | Story, Iowa, US |
546660 | 546660 | 2020-09-12 | Germany | Baden-Wurttemberg | 44903 | 1867 | 39608 | 3427 | 48.6616 | 9.3501 | 2020-09-13 04:30:52 | Baden-Wurttemberg, Germany | ||
3163410 | 3163410 | 2020-09-06 | US | Mississippi | Harrison | 28047 | 3490 | 63 | 0 | 3427 | 30.51359752 | -89.12467576 | 2020-09-07 04:28:30 | Harrison, Mississippi, US |
194322 | 194322 | 2020-08-31 | Russia | Volgograd Oblast | 12125 | 101 | 8597 | 3427 | 49.6048339 | 44.29035820000001 | 2020-09-01 04:28:31 | Volgograd Oblast, Russia | ||
1558042 | 1558042 | 2020-08-16 | US | Nebraska | Lancaster | 31109 | 3446 | 19 | 0 | 3427 | 40.78416049 | -96.68777155 | 2020-08-17 04:27:20 | Lancaster, Nebraska, US |
585059 | 585059 | 2020-08-13 | US | New York | Onondaga | 36067 | 3627 | 200 | 0 | 3427 | 43.00491923 | -76.19971155 | 2020-08-14 04:51:19 | Onondaga, New York, US |
2805730 | 2805730 | 2020-08-02 | US | Virginia | Henrico | 51087 | 3609 | 182 | 0 | 3427 | 37.53460572 | -77.39326555 | 2020-08-03 04:34:35 | Henrico, Virginia, US |
2956365 | 2956365 | 2020-07-29 | US | New Hampshire | Hillsborough | 33011 | 3701 | 274 | 0 | 3427 | 42.91537785 | -71.7200253 | 2020-07-30 04:35:05 | Hillsborough, New Hampshire, US |
3205121 | 3205121 | 2020-07-18 | Peru | Cajamarca | 3857 | 430 | 0 | 3427 | -6.4302839999999994 | -78.74559599999998 | 2020-07-19 04:34:58 | Cajamarca, Peru | ||
2157299 | 2157299 | 2020-07-14 | US | Texas | Montgomery | 48339 | 4072 | 44 | 0 | 3427 | 30.30079133 | -95.50572772 | 2020-07-15 04:34:39 | Montgomery, Texas, US |
302269 | 302269 | 2020-07-01 | US | Washington | Snohomish | 53061 | 3595 | 168 | 0 | 3427 | 48.04615983 | -121.7170703 | 2020-07-02 04:33:46 | Snohomish, Washington, US |
802906 | 802906 | 2020-06-01 | US | Louisiana | East Baton Rouge | 22033 | 3666 | 239 | 0 | 3427 | 30.53842039 | -91.09777565 | 2020-06-02 02:33:08 | East Baton Rouge, Louisiana, US |
1105103 | 1105103 | 2020-05-25 | Guatemala | 3760 | 59 | 274 | 3427 | 15.7835 | -90.2308 | 2020-05-26 02:32:35 | Guatemala | |||
1826659 | 1826659 | 2020-05-16 | US | Pennsylvania | Berks | 42011 | 3635 | 208 | 0 | 3427 | 40.41570541 | -75.92457766 | 2020-05-17 02:32:32 | Berks, Pennsylvania, 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]);