johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
78 rows where active = 2570 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 12
- US 59
- Russia 7
- Chile 2
- Ukraine 2
- El Salvador 1
- Italy 1
- Japan 1
- Morocco 1
- Namibia 1
- Netherlands 1
- Sweden 1
- Uzbekistan 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1806629 | 1806629 | 2021-05-27 | El Salvador | 72821 | 2233 | 68018 | 2570 | 13.7942 | -88.8965 | 2021-05-28 04:20:36 | El Salvador | |||
1310418 | 1310418 | 2021-05-26 | Russia | Tatarstan Republic | 21327 | 493 | 18264 | 2570 | 55.7648572 | 52.43104273 | 2021-05-27 04:20:59 | Tatarstan Republic, Russia | ||
1771361 | 1771361 | 2021-05-23 | Japan | Kanagawa | 59755 | 869 | 56316 | 2570 | 35.415312 | 139.338983 | 2021-05-24 04:20:53 | Kanagawa, Japan | ||
1203598 | 1203598 | 2021-03-22 | Chile | Maule | 50100 | 954 | 46576 | 2570 | -35.5183 | -71.6885 | 2021-03-23 05:26:18 | Maule, Chile | ||
1732750 | 1732750 | 2021-03-14 | Russia | Udmurt Republic | 29272 | 697 | 26005 | 2570 | 57.1961165 | 52.69598320000001 | 2021-03-15 05:25:51 | Udmurt Republic, Russia | ||
352551 | 352551 | 2021-03-11 | Russia | Udmurt Republic | 29045 | 682 | 25793 | 2570 | 57.1961165 | 52.69598320000001 | 2021-03-12 05:26:50 | Udmurt Republic, Russia | ||
2210142 | 2210142 | 2021-03-04 | US | Ohio | Morrow | 39117 | 2609 | 39 | 0 | 2570 | 40.52363560000001 | -82.7892599 | 2021-03-05 05:26:29 | Morrow, Ohio, US |
1859124 | 1859124 | 2021-02-25 | US | Indiana | Posey | 18129 | 2601 | 31 | 0 | 2570 | 38.02097333 | -87.86480429 | 2021-02-26 05:22:40 | Posey, Indiana, US |
280919 | 280919 | 2021-02-24 | US | Florida | Washington | 12133 | 2611 | 41 | 0 | 2570 | 30.61359259 | -85.66002461 | 2021-02-25 05:24:57 | Washington, Florida, US |
474942 | 474942 | 2021-02-19 | US | Wisconsin | Door | 55029 | 2594 | 24 | 0 | 2570 | 44.95856458 | -87.30002707 | 2021-02-20 05:22:51 | Door, Wisconsin, US |
1156065 | 1156065 | 2021-02-18 | US | Tennessee | Hickman | 47081 | 2613 | 38 | 0 | 2570 | 35.80609681 | -87.47643507 | 2021-02-19 05:24:16 | Hickman, Tennessee, US |
1155135 | 1155135 | 2021-02-18 | US | Montana | Ravalli | 30081 | 2598 | 28 | 0 | 2570 | 46.08520862 | -114.11891640000002 | 2021-02-19 05:24:16 | Ravalli, Montana, US |
3052669 | 3052669 | 2021-02-16 | US | Ohio | Perry | 39127 | 2618 | 48 | 0 | 2570 | 39.73508655 | -82.23804971 | 2021-02-17 05:23:10 | Perry, Ohio, US |
3981707 | 3981707 | 2021-02-10 | US | Texas | Kendall | 48259 | 2988 | 57 | 0 | 2570 | 29.94414155 | -98.7113588 | 2021-02-11 05:23:55 | Kendall, Texas, US |
3981100 | 3981100 | 2021-02-10 | US | Oklahoma | Beckham | 40009 | 2603 | 33 | 0 | 2570 | 35.26862449 | -99.68128023 | 2021-02-11 05:23:55 | Beckham, Oklahoma, US |
3979065 | 3979065 | 2021-02-10 | US | Arkansas | Johnson | 5071 | 2600 | 30 | 0 | 2570 | 35.56759135 | -93.46036368 | 2021-02-11 05:23:55 | Johnson, Arkansas, US |
615197 | 615197 | 2021-02-08 | US | Louisiana | Morehouse | 22067 | 2634 | 64 | 0 | 2570 | 32.81686191 | -91.80421614 | 2021-02-09 05:23:30 | Morehouse, Louisiana, US |
1675124 | 1675124 | 2021-02-07 | US | Pennsylvania | Jefferson | 42065 | 2650 | 80 | 0 | 2570 | 41.12913106 | -78.9986361 | 2021-02-08 05:22:39 | Jefferson, Pennsylvania, US |
1591718 | 1591718 | 2021-02-05 | US | Wisconsin | Jackson | 55053 | 2592 | 22 | 0 | 2570 | 44.31864893 | -90.80566792 | 2021-02-06 05:23:55 | Jackson, Wisconsin, US |
1588560 | 1588560 | 2021-02-05 | US | Alabama | Marion | 1093 | 2651 | 81 | 0 | 2570 | 34.13697363 | -87.88704173 | 2021-02-06 05:23:55 | Marion, Alabama, US |
1463176 | 1463176 | 2021-01-31 | US | Virginia | Wise | 51195 | 2654 | 84 | 0 | 2570 | 36.9746148 | -82.62410519 | 2021-02-01 05:22:53 | Wise, Virginia, US |
1462597 | 1462597 | 2021-01-31 | US | South Dakota | Beadle | 46005 | 2609 | 39 | 0 | 2570 | 44.41464384 | -98.27858469 | 2021-02-01 05:22:53 | Beadle, South Dakota, US |
2213082 | 2213082 | 2021-01-30 | US | Kentucky | Knox | 21121 | 2581 | 11 | 0 | 2570 | 36.89225732 | -83.85403396 | 2021-01-31 05:22:42 | Knox, Kentucky, US |
3155233 | 3155233 | 2021-01-27 | US | Michigan | Gratiot | 26057 | 2665 | 95 | 0 | 2570 | 43.29265605 | -84.60505416 | 2021-01-28 05:22:24 | Gratiot, Michigan, US |
2429707 | 2429707 | 2021-01-23 | US | South Carolina | Colleton | 45029 | 2638 | 68 | 0 | 2570 | 32.87582989 | -80.67641292 | 2021-01-24 05:22:35 | Colleton, South Carolina, US |
239042 | 239042 | 2021-01-18 | US | Mississippi | Itawamba | 28057 | 2629 | 59 | 0 | 2570 | 34.27993475 | -88.3606733 | 2021-01-19 05:22:15 | Itawamba, Mississippi, US |
3504904 | 3504904 | 2021-01-17 | US | Maine | Kennebec | 23011 | 2606 | 36 | 0 | 2570 | 44.40759555 | -69.76738544 | 2021-01-18 05:22:34 | Kennebec, Maine, US |
3102934 | 3102934 | 2021-01-16 | US | Louisiana | East Feliciana | 22037 | 2666 | 96 | 0 | 2570 | 30.84425359 | -91.04976723 | 2021-01-17 05:22:17 | East Feliciana, Louisiana, US |
3516896 | 3516896 | 2021-01-15 | US | Louisiana | East Feliciana | 22037 | 2666 | 96 | 0 | 2570 | 30.84425359 | -91.04976723 | 2021-01-16 05:22:40 | East Feliciana, Louisiana, US |
777248 | 777248 | 2021-01-12 | US | South Dakota | Yankton | 46135 | 2597 | 27 | 0 | 2570 | 43.00924485 | -97.39467635 | 2021-01-13 05:22:15 | Yankton, South Dakota, US |
3233036 | 3233036 | 2021-01-03 | US | Oklahoma | Sequoyah | 40135 | 2587 | 17 | 0 | 2570 | 35.49447108 | -94.75463785 | 2021-01-04 05:22:02 | Sequoyah, Oklahoma, US |
2229333 | 2229333 | 2021-01-02 | US | Mississippi | Leflore | 28083 | 2671 | 101 | 0 | 2570 | 33.55545125 | -90.29900733 | 2021-01-03 05:22:52 | Leflore, Mississippi, US |
2229212 | 2229212 | 2021-01-02 | US | Minnesota | Carlton | 27017 | 2608 | 38 | 0 | 2570 | 46.59180601 | -92.67601019 | 2021-01-03 05:22:52 | Carlton, Minnesota, US |
203727 | 203727 | 2020-12-25 | US | Kentucky | Whitley | 21235 | 2579 | 9 | 0 | 2570 | 36.75700531 | -84.14541217 | 2020-12-26 05:22:28 | Whitley, Kentucky, US |
3693324 | 3693324 | 2020-12-24 | US | Mississippi | Union | 28145 | 2604 | 34 | 0 | 2570 | 34.49162015 | -89.00776006 | 2020-12-25 05:22:48 | Union, Mississippi, US |
3692950 | 3692950 | 2020-12-24 | US | Kentucky | Whitley | 21235 | 2579 | 9 | 0 | 2570 | 36.75700531 | -84.14541217 | 2020-12-25 05:22:48 | Whitley, Kentucky, US |
2408302 | 2408302 | 2020-12-23 | US | Kentucky | Whitley | 21235 | 2579 | 9 | 0 | 2570 | 36.75700531 | -84.14541217 | 2020-12-24 05:23:04 | Whitley, Kentucky, US |
2121882 | 2121882 | 2020-12-20 | US | New Jersey | Salem | 34033 | 2674 | 104 | 0 | 2570 | 39.58719656 | -75.34696629999998 | 2020-12-21 05:27:58 | Salem, New Jersey, US |
2119827 | 2119827 | 2020-12-20 | Namibia | 18714 | 177 | 15967 | 2570 | -22.9576 | 18.4904 | 2020-12-21 05:27:58 | Namibia | |||
2130283 | 2130283 | 2020-12-17 | US | North Carolina | Chatham | 37037 | 2635 | 65 | 0 | 2570 | 35.70394416 | -79.25541492 | 2020-12-18 05:28:18 | Chatham, North Carolina, US |
1821421 | 1821421 | 2020-12-08 | US | Pennsylvania | Adams | 42001 | 2622 | 52 | 0 | 2570 | 39.87140411 | -77.21610347 | 2020-12-09 05:28:01 | Adams, Pennsylvania, US |
1818978 | 1818978 | 2020-12-08 | Russia | Chechen Republic | 5465 | 81 | 2814 | 2570 | 43.39761470000001 | 45.6985005 | 2020-12-09 05:28:01 | Chechen Republic, Russia | ||
739071 | 739071 | 2020-12-02 | US | Georgia | Colquitt | 13071 | 2617 | 47 | 0 | 2570 | 31.18810588 | -83.7677946 | 2020-12-03 05:28:22 | Colquitt, Georgia, US |
2539568 | 2539568 | 2020-12-01 | US | New Jersey | Warren | 34041 | 2743 | 173 | 0 | 2570 | 40.85951833 | -74.99556527 | 2020-12-02 05:27:41 | Warren, New Jersey, US |
394604 | 394604 | 2020-11-27 | US | North Carolina | Wilkes | 37193 | 2620 | 50 | 0 | 2570 | 36.2084135 | -81.16232895 | 2020-11-28 05:25:50 | Wilkes, North Carolina, US |
3170118 | 3170118 | 2020-11-16 | US | Arkansas | Hot Spring | 5059 | 2611 | 41 | 0 | 2570 | 34.31709259 | -92.95396325 | 2020-11-17 05:25:54 | Hot Spring, Arkansas, US |
2921721 | 2921721 | 2020-11-04 | US | Oklahoma | Garfield | 40047 | 2599 | 29 | 0 | 2570 | 36.3791334 | -97.78265517 | 2020-11-05 06:05:03 | Garfield, Oklahoma, US |
2500950 | 2500950 | 2020-11-03 | US | Tennessee | Hamblen | 47063 | 2608 | 50 | 0 | 2570 | 36.21990035 | -83.26586179 | 2020-11-04 05:25:09 | Hamblen, Tennessee, US |
1455099 | 1455099 | 2020-10-27 | US | Ohio | Wood | 39173 | 2648 | 78 | 0 | 2570 | 41.36224827 | -83.62285108 | 2020-10-28 04:24:39 | Wood, Ohio, US |
1454652 | 1454652 | 2020-10-27 | US | Nebraska | Hall | 31079 | 2620 | 50 | 0 | 2570 | 40.87257079 | -98.50218293 | 2020-10-28 04:24:39 | Hall, Nebraska, US |
1053952 | 1053952 | 2020-10-23 | Netherlands | Zeeland | 2649 | 80 | 0 | 2570 | 51.47936 | 3.861559 | 2020-10-24 04:24:46 | Zeeland, Netherlands | ||
3782207 | 3782207 | 2020-10-13 | Sweden | Dalarna | 2749 | 179 | 0 | 2570 | 61.0917 | 14.6664 | 2020-10-14 04:24:05 | Dalarna, Sweden | ||
2605685 | 2605685 | 2020-10-10 | Uzbekistan | 60776 | 502 | 57704 | 2570 | 41.377491 | 64.585262 | 2020-10-11 04:23:46 | Uzbekistan | |||
1825667 | 1825667 | 2020-10-04 | US | South Dakota | Pennington | 46103 | 2607 | 37 | 0 | 2570 | 44.0025835 | -102.8240777 | 2020-10-05 04:23:33 | Pennington, South Dakota, US |
970528 | 970528 | 2020-09-29 | Ukraine | Zaporizhia Oblast | 3895 | 61 | 1264 | 2570 | 47.8388 | 35.1396 | 2020-09-30 04:23:33 | Zaporizhia Oblast, Ukraine | ||
967664 | 967664 | 2020-09-29 | US | Georgia | Coweta | 13077 | 2617 | 47 | 0 | 2570 | 33.35334302 | -84.76129976 | 2020-09-30 04:23:33 | Coweta, Georgia, US |
2583728 | 2583728 | 2020-09-27 | US | Minnesota | Scott | 27139 | 2603 | 33 | 0 | 2570 | 44.6490231 | -93.53340251 | 2020-09-28 04:23:00 | Scott, Minnesota, US |
3317848 | 3317848 | 2020-09-22 | US | Michigan | Kalamazoo | 26077 | 2661 | 91 | 0 | 2570 | 42.24542231 | -85.53038622 | 2020-09-23 04:23:00 | Kalamazoo, Michigan, US |
666970 | 666970 | 2020-09-16 | US | Florida | Jackson | 12063 | 2644 | 74 | 0 | 2570 | 30.7954597 | -85.21500423 | 2020-09-17 04:22:00 | Jackson, Florida, US |
1999110 | 1999110 | 2020-08-26 | US | Ohio | Mahoning | 39099 | 2812 | 242 | 0 | 2570 | 41.01631101 | -80.77287029 | 2020-08-27 04:28:15 | Mahoning, Ohio, US |
2217869 | 2217869 | 2020-08-23 | US | New York | Albany | 36001 | 2699 | 129 | 0 | 2570 | 42.60060306 | -73.97723916 | 2020-08-24 04:27:56 | Albany, New York, US |
148228 | 148228 | 2020-08-15 | US | North Carolina | Alamance | 37001 | 2612 | 42 | 0 | 2570 | 36.0434701 | -79.39976137 | 2020-08-16 04:27:42 | Alamance, North Carolina, US |
1614417 | 1614417 | 2020-08-14 | US | New Mexico | Dona Ana | 35013 | 2602 | 32 | 0 | 2570 | 32.35275771 | -106.8329387 | 2020-08-15 04:27:31 | Dona Ana, New Mexico, US |
753705 | 753705 | 2020-08-01 | Russia | Stavropol Krai | 8341 | 159 | 5612 | 2570 | 44.86325770000001 | 43.4406913 | 2020-08-02 04:34:47 | Stavropol Krai, Russia | ||
2955558 | 2955558 | 2020-07-29 | US | Georgia | Cherokee | 13057 | 2623 | 53 | 0 | 2570 | 34.24393976 | -84.47431861 | 2020-07-30 04:35:05 | Cherokee, Georgia, US |
325486 | 325486 | 2020-07-20 | US | California | Merced | 6047 | 2586 | 15 | 0 | 2570 | 37.18922369 | -120.72090349999999 | 2020-07-21 04:38:46 | Merced, California, US |
3435885 | 3435885 | 2020-07-11 | Russia | Chuvashia Republic | 5775 | 46 | 3159 | 2570 | 55.4259922 | 47.0849429 | 2020-07-12 04:34:30 | Chuvashia Republic, Russia | ||
2221042 | 2221042 | 2020-07-08 | US | Ohio | Lucas | 39095 | 2836 | 266 | 0 | 2570 | 41.62101218 | -83.65468618 | 2020-07-09 04:34:23 | Lucas, Ohio, US |
2220358 | 2220358 | 2020-07-08 | US | Michigan | Genesee | 26049 | 2860 | 290 | 0 | 2570 | 43.02244215 | -83.70589709 | 2020-07-09 04:34:23 | Genesee, Michigan, US |
2232652 | 2232652 | 2020-07-03 | US | Missouri | Kansas City | 2601 | 31 | 0 | 2570 | 39.0997 | -94.5786 | 2020-07-04 04:33:51 | Kansas City, Missouri, US | |
1691766 | 1691766 | 2020-06-19 | Russia | Voronezh Oblast | 5461 | 30 | 2861 | 2570 | 50.9800393 | 40.15065070000001 | 2020-06-20 04:33:19 | Voronezh Oblast, Russia | ||
1691368 | 1691368 | 2020-06-19 | Ukraine | Chernivtsi Oblast | 4211 | 171 | 1470 | 2570 | 48.2917 | 25.9352 | 2020-06-20 04:33:19 | Chernivtsi Oblast, Ukraine | ||
286604 | 286604 | 2020-06-15 | US | California | Tulare | 6107 | 2672 | 96 | 0 | 2570 | 36.22026558 | -118.8020203 | 2020-06-16 04:33:09 | Tulare, California, US |
1210763 | 1210763 | 2020-06-09 | Italy | Lazio | 7851 | 766 | 4515 | 2570 | 41.89277044 | 12.48366722 | 2020-06-10 04:07:00 | Lazio, Italy | ||
998019 | 998019 | 2020-05-23 | Morocco | 7406 | 198 | 4638 | 2570 | 31.7917 | -7.0926 | 2020-05-24 02:32:43 | Morocco | |||
3330371 | 3330371 | 2020-05-11 | US | Washington | Snohomish | 53061 | 2690 | 120 | 0 | 2570 | 48.04615983 | -121.7170703 | 2020-05-12 03:32:27 | Snohomish, Washington, US |
3739204 | 3739204 | 2020-04-03 | US | Washington | King | 53033 | 2787 | 217 | 0 | 2570 | 47.49137892 | -121.8346131 | 2020-04-03 22:46:37 | King, Washington, US |
3815913 | 3815913 | 2020-03-31 | Chile | 2738 | 12 | 156 | 2570 | -35.6751 | -71.543 | 2020-03-31 23:43:43 | Chile |
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]);