johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
62 rows where active = 2866 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 14
- US 44
- Russia 3
- Central African Republic 2
- India 2
- Mexico 2
- Cabo Verde 1
- Chile 1
- Colombia 1
- Italy 1
- Netherlands 1
- Pakistan 1
- Peru 1
- Spain 1
- Ukraine 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1893357 | 1893357 | 2021-06-30 | Russia | Kostroma Oblast | 23204 | 514 | 19824 | 2866 | 58.424756 | 44.2533273 | 2021-07-01 04:21:19 | Kostroma Oblast, Russia | ||
2004626 | 2004626 | 2021-05-12 | India | Sikkim | 10392 | 183 | 7343 | 2866 | 27.571671 | 88.472712 | 2021-05-13 04:20:51 | Sikkim, India | ||
2004421 | 2004421 | 2021-05-12 | Cabo Verde | 27029 | 238 | 23925 | 2866 | 16.5388 | -23.0418 | 2021-05-13 04:20:51 | Cabo Verde | |||
1732292 | 1732292 | 2021-03-14 | Chile | Valparaiso | 55712 | 1705 | 51141 | 2866 | -33.0472 | -71.6127 | 2021-03-15 05:25:51 | Valparaiso, Chile | ||
3670091 | 3670091 | 2021-03-06 | US | Ohio | Jackson | 39079 | 2918 | 52 | 0 | 2866 | 39.01914254 | -82.61818559999998 | 2021-03-07 05:21:54 | Jackson, Ohio, US |
2208359 | 2208359 | 2021-03-04 | US | Florida | Levy | 12075 | 2905 | 39 | 0 | 2866 | 29.31829741 | -82.74007147 | 2021-03-05 05:26:29 | Levy, Florida, US |
2369332 | 2369332 | 2021-02-28 | US | Mississippi | Scott | 28123 | 2936 | 70 | 0 | 2866 | 32.406704100000006 | -89.53789439 | 2021-03-01 05:23:01 | Scott, Mississippi, US |
532183 | 532183 | 2021-02-22 | US | Louisiana | Allen | 22003 | 2950 | 84 | 0 | 2866 | 30.65385745 | -92.82442028 | 2021-02-23 05:23:41 | Allen, Louisiana, US |
530923 | 530923 | 2021-02-22 | Russia | Kursk Oblast | 29886 | 433 | 26587 | 2866 | 51.6568453 | 36.4852695 | 2021-02-23 05:23:41 | Kursk Oblast, Russia | ||
3053029 | 3053029 | 2021-02-16 | US | South Dakota | Davison | 46035 | 2926 | 60 | 0 | 2866 | 43.67490933 | -98.14458906 | 2021-02-17 05:23:10 | Davison, South Dakota, US |
1339421 | 1339421 | 2021-02-15 | US | Indiana | White | 18181 | 2917 | 51 | 0 | 2866 | 40.74911165 | -86.86492015 | 2021-02-16 05:24:38 | White, Indiana, US |
2680450 | 2680450 | 2021-02-13 | US | Oregon | Polk | 41053 | 2908 | 42 | 0 | 2866 | 44.90322804 | -123.4128888 | 2021-02-14 05:23:43 | Polk, Oregon, US |
3982061 | 3982061 | 2021-02-10 | US | West Virginia | Marshall | 54051 | 2931 | 65 | 0 | 2866 | 39.86064362 | -80.66591062 | 2021-02-11 05:23:55 | Marshall, West Virginia, US |
617307 | 617307 | 2021-02-08 | Ukraine | Donetsk Oblast | 44968 | 990 | 41112 | 2866 | 48.0159 | 37.8028 | 2021-02-09 05:23:30 | Donetsk Oblast, Ukraine | ||
341969 | 341969 | 2021-02-03 | US | Minnesota | Carlton | 27017 | 2909 | 43 | 0 | 2866 | 46.59180601 | -92.67601019 | 2021-02-04 05:22:26 | Carlton, Minnesota, US |
1687020 | 1687020 | 2021-02-02 | US | Oklahoma | Adair | 40001 | 2886 | 20 | 0 | 2866 | 35.88494195 | -94.65859267 | 2021-02-03 05:22:52 | Adair, Oklahoma, US |
1461065 | 1461065 | 2021-01-31 | US | Kansas | McPherson | 20113 | 2929 | 63 | 0 | 2866 | 38.39184858 | -97.64769869 | 2021-02-01 05:22:53 | McPherson, Kansas, US |
2212973 | 2212973 | 2021-01-30 | US | Kansas | McPherson | 20113 | 2929 | 63 | 0 | 2866 | 38.39184858 | -97.64769869 | 2021-01-31 05:22:42 | McPherson, Kansas, US |
1898460 | 1898460 | 2021-01-29 | US | Kansas | McPherson | 20113 | 2929 | 63 | 0 | 2866 | 38.39184858 | -97.64769869 | 2021-01-30 05:22:49 | McPherson, Kansas, US |
3153749 | 3153749 | 2021-01-27 | Pakistan | Khyber Pakhtunkhwa | 66198 | 1870 | 61462 | 2866 | 34.485332 | 72.09169 | 2021-01-28 05:22:24 | Khyber Pakhtunkhwa, Pakistan | ||
1760385 | 1760385 | 2021-01-24 | US | Indiana | Huntington | 18069 | 2931 | 65 | 0 | 2866 | 40.82907273 | -85.48822092 | 2021-01-25 05:22:16 | Huntington, Indiana, US |
238735 | 238735 | 2021-01-18 | US | Louisiana | Evangeline | 22039 | 2933 | 67 | 0 | 2866 | 30.72985248 | -92.39915924 | 2021-01-19 05:22:15 | Evangeline, Louisiana, US |
3882775 | 3882775 | 2021-01-14 | US | Texas | Rusk | 48401 | 3215 | 60 | 0 | 2866 | 32.10773545 | -94.76176432 | 2021-01-15 05:22:24 | Rusk, Texas, US |
777773 | 777773 | 2021-01-12 | US | Washington | Cowlitz | 53015 | 2900 | 34 | 0 | 2866 | 46.19074721 | -122.6782231 | 2021-01-13 05:22:15 | Cowlitz, Washington, US |
157439 | 157439 | 2021-01-08 | US | Washington | Whitman | 53075 | 2899 | 33 | 0 | 2866 | 46.90022523 | -117.5241763 | 2021-01-09 05:22:18 | Whitman, Washington, US |
2541904 | 2541904 | 2021-01-07 | US | Arkansas | Miller | 5091 | 2891 | 25 | 0 | 2866 | 33.31403423 | -93.89285258 | 2021-01-08 05:22:42 | Miller, Arkansas, US |
1138702 | 1138702 | 2021-01-01 | US | Mississippi | Marshall | 28093 | 2929 | 63 | 0 | 2866 | 34.76216286 | -89.50299462 | 2021-01-02 05:22:33 | Marshall, Mississippi, US |
1013779 | 1013779 | 2020-12-30 | US | West Virginia | Harrison | 54033 | 2898 | 32 | 0 | 2866 | 39.2853852 | -80.37919577 | 2020-12-31 05:22:49 | Harrison, West Virginia, US |
3762663 | 3762663 | 2020-12-28 | US | Indiana | Gibson | 18051 | 2932 | 66 | 0 | 2866 | 38.30393723 | -87.58054938 | 2020-12-29 05:22:37 | Gibson, Indiana, US |
2226803 | 2226803 | 2020-12-26 | US | Virginia | Bedford | 51019 | 2896 | 30 | 0 | 2866 | 37.3080028 | -79.5281964 | 2020-12-27 05:22:55 | Bedford, Virginia, US |
205251 | 205251 | 2020-12-25 | US | Tennessee | Weakley | 47183 | 2999 | 41 | 0 | 2866 | 36.29896232 | -88.71990865 | 2020-12-26 05:22:28 | Weakley, Tennessee, US |
3694474 | 3694474 | 2020-12-24 | US | Tennessee | Weakley | 47183 | 2964 | 41 | 0 | 2866 | 36.29896232 | -88.71990865 | 2020-12-25 05:22:48 | Weakley, Tennessee, US |
2122182 | 2122182 | 2020-12-20 | US | Ohio | Jefferson | 39081 | 2936 | 70 | 0 | 2866 | 40.38614126 | -80.76259514 | 2020-12-21 05:27:58 | Jefferson, Ohio, US |
2932198 | 2932198 | 2020-12-19 | US | Illinois | Franklin | 17055 | 2903 | 37 | 0 | 2866 | 37.99189086 | -88.92567818 | 2020-12-20 05:27:32 | Franklin, Illinois, US |
2130492 | 2130492 | 2020-12-17 | US | Ohio | Sandusky | 39143 | 2926 | 60 | 0 | 2866 | 41.35624126 | -83.137872 | 2020-12-18 05:28:18 | Sandusky, Ohio, US |
1821041 | 1821041 | 2020-12-08 | US | New York | Saratoga | 36091 | 2888 | 22 | 0 | 2866 | 43.10904162 | -73.86653895 | 2020-12-09 05:28:01 | Saratoga, New York, US |
2349873 | 2349873 | 2020-12-07 | US | Ohio | Erie | 39043 | 2935 | 69 | 0 | 2866 | 41.36796058 | -82.62904521 | 2020-12-08 05:27:42 | Erie, Ohio, US |
2539263 | 2539263 | 2020-12-01 | US | Missouri | Callaway | 29027 | 2877 | 11 | 0 | 2866 | 38.83674754 | -91.92186505 | 2020-12-02 05:27:41 | Callaway, Missouri, US |
680608 | 680608 | 2020-11-23 | US | North Carolina | Craven | 37049 | 2934 | 68 | 0 | 2866 | 35.11833364 | -77.08398081 | 2020-11-24 05:27:31 | Craven, North Carolina, US |
1547087 | 1547087 | 2020-11-07 | US | Texas | Liberty | 48291 | 2676 | 59 | 0 | 2866 | 30.15152688 | -94.81205615 | 2020-11-08 05:24:56 | Liberty, Texas, US |
2082370 | 2082370 | 2020-10-31 | US | Ohio | Clermont | 39025 | 2911 | 45 | 0 | 2866 | 39.04847534 | -84.15375786 | 2020-11-01 04:36:19 | Clermont, Ohio, US |
1177754 | 1177754 | 2020-10-22 | Russia | Zabaykalsky Krai | 9508 | 99 | 6543 | 2866 | 52.248521 | 115.956325 | 2020-10-23 04:24:46 | Zabaykalsky Krai, Russia | ||
1045810 | 1045810 | 2020-09-30 | Italy | Sicilia | 7118 | 311 | 3941 | 2866 | 38.11569725 | 13.362356699999998 | 2020-10-01 04:23:42 | Sicilia, Italy | ||
969368 | 969368 | 2020-09-29 | US | Ohio | Mahoning | 39099 | 3114 | 248 | 0 | 2866 | 41.01631101 | -80.77287029 | 2020-09-30 04:23:33 | Mahoning, Ohio, US |
2656670 | 2656670 | 2020-09-23 | US | Tennessee | Bradley | 47011 | 2881 | 17 | 0 | 2866 | 35.15739424 | -84.857186 | 2020-09-24 04:23:00 | Bradley, Tennessee, US |
547444 | 547444 | 2020-09-12 | US | Florida | Indian River | 12061 | 2971 | 105 | 0 | 2866 | 27.69308961 | -80.60556721 | 2020-09-13 04:30:52 | Indian River, Florida, US |
1244049 | 1244049 | 2020-09-08 | Spain | La Rioja | 6352 | 379 | 3107 | 2866 | 42.2871 | -2.5396 | 2020-09-09 04:28:48 | La Rioja, Spain | ||
427419 | 427419 | 2020-09-07 | Mexico | Guanajuato | 34269 | 2325 | 29078 | 2866 | 21.019 | -101.2574 | 2020-09-08 04:28:25 | Guanajuato, Mexico | ||
1105390 | 1105390 | 2020-09-02 | Colombia | Atlantico | 64357 | 2917 | 58574 | 2866 | 10.6966 | -74.8741 | 2020-09-03 04:28:22 | Atlantico, Colombia | ||
2060392 | 2060392 | 2020-09-01 | US | Arkansas | Sebastian | 5131 | 2900 | 34 | 0 | 2866 | 35.19605503 | -94.27162713 | 2020-09-02 04:28:25 | Sebastian, Arkansas, US |
3562536 | 3562536 | 2020-08-25 | India | Tripura | 9523 | 83 | 6574 | 2866 | 23.746783 | 91.743565 | 2020-08-26 04:28:11 | Tripura, India | ||
3485821 | 3485821 | 2020-08-20 | US | Louisiana | St. Landry | 22097 | 2968 | 102 | 0 | 2866 | 30.59724262 | -92.00135806 | 2020-08-21 04:27:41 | St. Landry, Louisiana, US |
371689 | 371689 | 2020-08-08 | Central African Republic | 4641 | 59 | 1716 | 2866 | 6.6111 | 20.9394 | 2020-08-09 04:34:54 | Central African Republic | |||
370625 | 370625 | 2020-08-08 | US | Minnesota | Stearns | 27145 | 2886 | 20 | 0 | 2866 | 45.55192576 | -94.61078221 | 2020-08-09 04:34:54 | Stearns, Minnesota, US |
458873 | 458873 | 2020-08-07 | Central African Republic | 4641 | 59 | 1716 | 2866 | 6.6111 | 20.9394 | 2020-08-08 04:34:53 | Central African Republic | |||
3264781 | 3264781 | 2020-07-31 | Netherlands | Overijssel | 3185 | 312 | 0 | 2866 | 52.444558 | 6.441722 | 2020-08-01 04:36:27 | Overijssel, Netherlands | ||
1925973 | 1925973 | 2020-07-30 | US | New Jersey | Gloucester | 34015 | 3072 | 206 | 0 | 2866 | 39.71581067 | -75.13995546 | 2020-07-31 04:35:18 | Gloucester, New Jersey, US |
3436236 | 3436236 | 2020-07-11 | Peru | Tumbes | 3334 | 468 | 0 | 2866 | -3.857496 | -80.54525500000003 | 2020-07-12 04:34:30 | Tumbes, Peru | ||
1005539 | 1005539 | 2020-07-09 | Mexico | Mexico | 40957 | 5062 | 33029 | 2866 | 19.4969 | -99.7233 | 2020-07-10 04:34:24 | Mexico, Mexico | ||
2622068 | 2622068 | 2020-06-25 | US | Louisiana | Caddo | 22017 | 3096 | 230 | 0 | 2866 | 32.57991587 | -93.88375652 | 2020-06-26 04:33:43 | Caddo, Louisiana, US |
2436490 | 2436490 | 2020-06-20 | US | Alabama | Mobile | 1097 | 2998 | 132 | 0 | 2866 | 30.78472347 | -88.20842409 | 2020-06-21 04:33:19 | Mobile, Alabama, US |
3700568 | 3700568 | 2020-04-02 | US | Florida | Miami-Dade | 12086 | 2886 | 20 | 0 | 2866 | 25.6112362 | -80.55170587 | 4/2/20 23:25 | Miami-Dade, Florida, 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]);