johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
78 rows where active = 2568 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3015419 | 3015419 | 2021-08-01 | Maldives | 77547 | 221 | 74758 | 2568 | 3.2028 | 73.2207 | 2021-08-02 04:21:36 | Maldives | |||
3904160 | 3904160 | 2021-07-31 | Russia | Amur Oblast | 27706 | 341 | 24797 | 2568 | 52.8032368 | 128.437295 | 2021-08-01 04:21:50 | Amur Oblast, Russia | ||
1165361 | 1165361 | 2021-07-04 | Russia | Buryatia Republic | 45566 | 1315 | 41683 | 2568 | 52.7182426 | 109.492143 | 2021-07-05 04:21:28 | Buryatia Republic, Russia | ||
3054440 | 3054440 | 2021-05-13 | Russia | Tatarstan Republic | 20911 | 475 | 17868 | 2568 | 55.7648572 | 52.43104273 | 2021-05-14 04:20:41 | Tatarstan Republic, Russia | ||
2450957 | 2450957 | 2021-05-02 | Russia | Arkhangelsk Oblast | 62067 | 940 | 58559 | 2568 | 63.5589686 | 43.1221646 | 2021-05-03 04:20:39 | Arkhangelsk Oblast, Russia | ||
3713806 | 3713806 | 2021-04-03 | Zambia | 88800 | 1215 | 85017 | 2568 | -13.133897 | 27.849332 | 2021-04-04 04:20:49 | Zambia | |||
1619332 | 1619332 | 2021-03-05 | US | Texas | Gonzales | 48177 | 2646 | 52 | 0 | 2568 | 29.45634206 | -97.49424032 | 2021-03-06 04:23:41 | Gonzales, Texas, US |
2208951 | 2208951 | 2021-03-04 | US | Kansas | Labette | 20099 | 2616 | 48 | 0 | 2568 | 37.19113093 | -95.29849679 | 2021-03-05 05:26:29 | Labette, Kansas, US |
1091372 | 1091372 | 2021-03-03 | US | Kansas | Labette | 20099 | 2616 | 48 | 0 | 2568 | 37.19113093 | -95.29849679 | 2021-03-04 05:24:24 | Labette, Kansas, US |
2368988 | 2368988 | 2021-02-28 | US | Louisiana | De Soto | 22031 | 2639 | 71 | 0 | 2568 | 32.05457447 | -93.74130302 | 2021-03-01 05:23:01 | De Soto, Louisiana, US |
1939374 | 1939374 | 2021-02-23 | US | Tennessee | DeKalb | 47041 | 2633 | 47 | 0 | 2568 | 35.97616272 | -85.83689361 | 2021-02-24 05:29:16 | DeKalb, Tennessee, US |
472875 | 472875 | 2021-02-19 | US | Kentucky | Taylor | 21217 | 2598 | 30 | 0 | 2568 | 37.3677562 | -85.3329931 | 2021-02-20 05:22:51 | Taylor, Kentucky, US |
1156651 | 1156651 | 2021-02-18 | US | Wisconsin | Door | 55029 | 2592 | 24 | 0 | 2568 | 44.95856458 | -87.30002707 | 2021-02-19 05:24:16 | Door, Wisconsin, US |
3053139 | 3053139 | 2021-02-16 | US | Tennessee | McNairy | 47109 | 2592 | 49 | 0 | 2568 | 35.17468549 | -88.5647812 | 2021-02-17 05:23:10 | McNairy, Tennessee, US |
3053120 | 3053120 | 2021-02-16 | US | Tennessee | Hickman | 47081 | 2610 | 38 | 0 | 2568 | 35.80609681 | -87.47643507 | 2021-02-17 05:23:10 | Hickman, Tennessee, US |
3051332 | 3051332 | 2021-02-16 | US | Iowa | Bremer | 19017 | 2621 | 53 | 0 | 2568 | 42.77461496 | -92.31795937 | 2021-02-17 05:23:10 | Bremer, Iowa, US |
1590313 | 1590313 | 2021-02-05 | US | Nevada | Nye | 32023 | 2654 | 86 | 0 | 2568 | 38.04264256 | -116.4722702 | 2021-02-06 05:23:55 | Nye, Nevada, US |
342118 | 342118 | 2021-02-03 | US | Mississippi | Tippah | 28139 | 2623 | 55 | 0 | 2568 | 34.76872156 | -88.90988194 | 2021-02-04 05:22:26 | Tippah, Mississippi, US |
340980 | 340980 | 2021-02-03 | US | Florida | Levy | 12075 | 2592 | 24 | 0 | 2568 | 29.31829741 | -82.74007147 | 2021-02-04 05:22:26 | Levy, Florida, US |
1684810 | 1684810 | 2021-02-02 | Sweden | Gotland | 2612 | 44 | 0 | 2568 | 57.4684 | 18.4867 | 2021-02-03 05:22:52 | Gotland, Sweden | ||
2214505 | 2214505 | 2021-01-30 | US | South Dakota | Beadle | 46005 | 2607 | 39 | 0 | 2568 | 44.41464384 | -98.27858469 | 2021-01-31 05:22:42 | Beadle, South Dakota, US |
2484941 | 2484941 | 2021-01-28 | US | Tennessee | Overton | 47133 | 2790 | 46 | 0 | 2568 | 36.34117832 | -85.28989535 | 2021-01-29 05:22:23 | Overton, Tennessee, US |
3155140 | 3155140 | 2021-01-27 | US | Louisiana | Vernon | 22115 | 2654 | 86 | 0 | 2568 | 31.10884837 | -93.18153838 | 2021-01-28 05:22:24 | Vernon, Louisiana, US |
1760284 | 1760284 | 2021-01-24 | US | Illinois | Iroquois | 17075 | 2624 | 56 | 0 | 2568 | 40.74717633 | -87.82466784 | 2021-01-25 05:22:16 | Iroquois, Illinois, US |
437825 | 437825 | 2021-01-21 | US | Ohio | Jackson | 39079 | 2613 | 45 | 0 | 2568 | 39.01914254 | -82.61818559999998 | 2021-01-22 05:22:10 | Jackson, Ohio, US |
435295 | 435295 | 2021-01-21 | India | Assam | 216940 | 1077 | 213295 | 2568 | 26.357149 | 92.830441 | 2021-01-22 05:22:10 | Assam, India | ||
1095155 | 1095155 | 2021-01-20 | US | Indiana | Daviess | 18027 | 2647 | 79 | 0 | 2568 | 38.70186039 | -87.07185406 | 2021-01-21 05:22:01 | Daviess, Indiana, US |
239791 | 239791 | 2021-01-18 | US | Oklahoma | Jackson | 40065 | 2607 | 39 | 0 | 2568 | 34.58781741 | -99.41138784 | 2021-01-19 05:22:15 | Jackson, Oklahoma, US |
237861 | 237861 | 2021-01-18 | US | Colorado | La Plata | 8067 | 2663 | 37 | 0 | 2568 | 37.28632032 | -107.8429014 | 2021-01-19 05:22:15 | La Plata, Colorado, US |
3103675 | 3103675 | 2021-01-16 | US | New York | Livingston | 36051 | 2605 | 37 | 0 | 2568 | 42.72596275 | -77.77966158 | 2021-01-17 05:22:17 | Livingston, New York, US |
3900977 | 3900977 | 2021-01-09 | US | Illinois | Montgomery | 17135 | 2597 | 29 | 0 | 2568 | 39.23198845 | -89.47809254 | 2021-01-10 05:22:12 | Montgomery, Illinois, US |
155821 | 155821 | 2021-01-08 | US | Mississippi | Sunflower | 28133 | 2634 | 66 | 0 | 2568 | 33.60192578 | -90.58882684 | 2021-01-09 05:22:18 | Sunflower, Mississippi, US |
3034160 | 3034160 | 2021-01-05 | Colombia | Risaralda | 35977 | 797 | 32612 | 2568 | 5.3158 | -75.9928 | 2021-01-06 05:22:16 | Risaralda, Colombia | ||
3231808 | 3231808 | 2021-01-03 | US | Kentucky | Barren | 21009 | 2603 | 35 | 0 | 2568 | 36.96469836 | -85.93338945 | 2021-01-04 05:22:02 | Barren, Kentucky, US |
1139616 | 1139616 | 2021-01-01 | US | Puerto Rico | Guaynabo | 72061 | 2568 | 0 | 0 | 2568 | 18.345114 | -66.11452299999999 | 2021-01-02 05:22:33 | Guaynabo, Puerto Rico, US |
769270 | 769270 | 2020-12-29 | US | Tennessee | Lauderdale | 47097 | 2572 | 28 | 0 | 2568 | 35.75893438 | -89.63015909999999 | 2020-12-30 05:22:34 | Lauderdale, Tennessee, US |
3778776 | 3778776 | 2020-12-27 | US | Georgia | Thomas | 13275 | 2651 | 83 | 0 | 2568 | 30.86392347 | -83.91847289 | 2020-12-28 05:22:06 | Thomas, Georgia, US |
2223754 | 2223754 | 2020-12-26 | Russia | Stavropol Krai | 33861 | 699 | 30594 | 2568 | 44.86325770000001 | 43.4406913 | 2020-12-27 05:22:55 | Stavropol Krai, Russia | ||
3769739 | 3769739 | 2020-12-22 | Colombia | Tolima | 39136 | 1143 | 35425 | 2568 | 4.0925 | -75.1545 | 2020-12-23 05:22:03 | Tolima, Colombia | ||
929407 | 929407 | 2020-12-21 | US | Minnesota | Itasca | 27061 | 2600 | 32 | 0 | 2568 | 47.51009045 | -93.63092229 | 2020-12-22 05:22:33 | Itasca, Minnesota, US |
2122654 | 2122654 | 2020-12-20 | US | Tennessee | Henderson | 47077 | 2656 | 40 | 0 | 2568 | 35.65581134 | -88.38600175 | 2020-12-21 05:27:58 | Henderson, Tennessee, US |
2933697 | 2933697 | 2020-12-19 | US | Ohio | Madison | 39097 | 2603 | 35 | 0 | 2568 | 39.89381073 | -83.40178317 | 2020-12-20 05:27:32 | Madison, Ohio, US |
1037546 | 1037546 | 2020-12-15 | US | Texas | Nacogdoches | 48347 | 2913 | 90 | 0 | 2568 | 31.62017125 | -94.61803994 | 2020-12-16 05:28:04 | Nacogdoches, Texas, US |
1753734 | 1753734 | 2020-12-14 | US | Ohio | Huron | 39077 | 2630 | 62 | 0 | 2568 | 41.14651175 | -82.59867951 | 2020-12-15 05:26:38 | Huron, Ohio, US |
1820565 | 1820565 | 2020-12-08 | US | Mississippi | Bolivar | 28011 | 2657 | 89 | 0 | 2568 | 33.79696941 | -90.87372121 | 2020-12-09 05:28:01 | Bolivar, Mississippi, US |
1008963 | 1008963 | 2020-12-06 | US | Pennsylvania | Lawrence | 42073 | 2646 | 78 | 0 | 2568 | 40.99206278 | -80.33393706 | 2020-12-07 05:26:14 | Lawrence, Pennsylvania, US |
1587212 | 1587212 | 2020-11-30 | US | Texas | Coryell | 48099 | 3273 | 16 | 0 | 2568 | 31.39078397 | -97.79936155 | 2020-12-01 05:26:18 | Coryell, Texas, US |
824579 | 824579 | 2020-11-19 | US | Texas | Bastrop | 48021 | 2281 | 34 | 0 | 2568 | 30.10370699 | -97.31206354 | 2020-11-20 05:26:28 | Bastrop, Texas, US |
124985 | 124985 | 2020-11-18 | US | North Carolina | Brunswick | 37019 | 2623 | 55 | 0 | 2568 | 34.070565 | -78.22814204 | 2020-11-19 05:25:23 | Brunswick, North Carolina, US |
2882718 | 2882718 | 2020-11-15 | US | Ohio | Wayne | 39169 | 2655 | 87 | 0 | 2568 | 40.82925852 | -81.88844833 | 2020-11-16 05:25:57 | Wayne, Ohio, US |
1731407 | 1731407 | 2020-11-08 | US | Tennessee | Dyer | 47045 | 2668 | 39 | 0 | 2568 | 36.05931946 | -89.41542855 | 2020-11-09 05:25:45 | Dyer, Tennessee, US |
3412056 | 3412056 | 2020-11-01 | US | Oregon | Lane | 41039 | 2596 | 28 | 0 | 2568 | 43.93727035 | -122.847753 | 2020-11-02 05:25:04 | Lane, Oregon, US |
3410983 | 3410983 | 2020-11-01 | US | Maine | Cumberland | 23005 | 2638 | 70 | 0 | 2568 | 43.8370751 | -70.37226999 | 2020-11-02 05:25:04 | Cumberland, Maine, US |
2081627 | 2081627 | 2020-10-31 | US | Minnesota | Clay | 27027 | 2613 | 45 | 0 | 2568 | 46.89289518 | -96.48761922 | 2020-11-01 04:36:19 | Clay, Minnesota, US |
211145 | 211145 | 2020-10-29 | US | Idaho | Bannock | 16005 | 2582 | 14 | 0 | 2568 | 42.67002716 | -112.2233311 | 2020-10-30 04:24:49 | Bannock, Idaho, US |
3786984 | 3786984 | 2020-10-11 | US | Indiana | Johnson | 18081 | 2706 | 138 | 0 | 2568 | 39.48994426 | -86.10149107 | 2020-10-12 04:23:45 | Johnson, Indiana, US |
3117332 | 3117332 | 2020-10-06 | Colombia | Cundinamarca | 35087 | 1043 | 31476 | 2568 | 5.026 | -74.03 | 2020-10-07 04:23:40 | Cundinamarca, Colombia | ||
1516161 | 1516161 | 2020-09-28 | US | Georgia | Coweta | 13077 | 2614 | 46 | 0 | 2568 | 33.35334302 | -84.76129976 | 2020-09-29 04:23:42 | Coweta, Georgia, US |
2607105 | 2607105 | 2020-09-24 | US | Indiana | Hendricks | 18063 | 2694 | 126 | 0 | 2568 | 39.76719009 | -86.51037283 | 2020-09-25 04:23:00 | Hendricks, Indiana, US |
2730028 | 2730028 | 2020-09-15 | US | Illinois | Rock Island | 17161 | 2637 | 69 | 0 | 2568 | 41.46613806 | -90.57042164 | 2020-09-16 04:22:53 | Rock Island, Illinois, US |
1106778 | 1106778 | 2020-09-02 | US | Iowa | Story | 19169 | 2584 | 16 | 0 | 2568 | 42.03621213 | -93.46499005 | 2020-09-03 04:28:22 | Story, Iowa, US |
1523251 | 1523251 | 2020-08-28 | Maldives | 7469 | 28 | 4873 | 2568 | 3.2028 | 73.2207 | 2020-08-29 04:28:19 | Maldives | |||
2992464 | 2992464 | 2020-08-24 | US | Iowa | Johnson | 19103 | 2592 | 24 | 0 | 2568 | 41.67169354 | -91.58754744 | 2020-08-25 04:28:02 | Johnson, Iowa, US |
97396 | 97396 | 2020-08-04 | US | Arizona | Santa Cruz | 4023 | 2618 | 50 | 0 | 2568 | 31.52508998 | -110.8479088 | 2020-08-05 04:34:43 | Santa Cruz, Arizona, US |
3182248 | 3182248 | 2020-07-28 | US | Florida | Clay | 12019 | 2615 | 47 | 0 | 2568 | 29.98319144 | -81.85609986 | 2020-07-29 04:35:11 | Clay, Florida, US |
442725 | 442725 | 2020-07-26 | Russia | Stavropol Krai | 7678 | 145 | 4965 | 2568 | 44.86325770000001 | 43.4406913 | 2020-07-27 04:35:02 | Stavropol Krai, Russia | ||
327448 | 327448 | 2020-07-20 | US | Minnesota | Anoka | 27003 | 2678 | 110 | 0 | 2568 | 45.27476015 | -93.24604565 | 2020-07-21 04:00:07 | Anoka, Minnesota, US |
3435934 | 3435934 | 2020-07-11 | Mexico | Guanajuato | 11807 | 553 | 8686 | 2568 | 21.019 | -101.2574 | 2020-07-12 04:34:30 | Guanajuato, Mexico | ||
2683210 | 2683210 | 2020-07-06 | US | Texas | Lubbock | 48303 | 251 | 52 | 0 | 2568 | 33.61008596 | -101.8204789 | 2020-07-07 04:34:00 | Lubbock, Texas, US |
413674 | 413674 | 2020-07-05 | US | Texas | Lubbock | 48303 | 241 | 52 | 0 | 2568 | 33.61008596 | -101.8204789 | 2020-07-06 04:33:57 | Lubbock, Texas, US |
528237 | 528237 | 2020-07-04 | US | Texas | Lubbock | 48303 | 235 | 52 | 0 | 2568 | 33.61008596 | -101.8204789 | 2020-07-05 04:33:46 | Lubbock, Texas, US |
2232899 | 2232899 | 2020-07-03 | US | Texas | Lubbock | 48303 | 231 | 52 | 0 | 2568 | 33.61008596 | -101.8204789 | 2020-07-04 04:33:51 | Lubbock, Texas, US |
2974236 | 2974236 | 2020-06-30 | India | Assam | 8227 | 12 | 5647 | 2568 | 26.357149 | 92.83044100000001 | 2020-07-01 04:33:52 | Assam, India | ||
3059754 | 3059754 | 2020-06-13 | US | Alabama | Mobile | 1097 | 2697 | 129 | 0 | 2568 | 30.78472347 | -88.20842409 | 2020-06-14 03:33:15 | Mobile, Alabama, US |
1273616 | 1273616 | 2020-06-11 | Brazil | Rio Grande do Sul | 14168 | 323 | 11277 | 2568 | -30.0346 | -51.2177 | 2020-06-12 05:09:52 | Rio Grande do Sul, Brazil | ||
1270100 | 1270100 | 2020-06-05 | Nepal | 2912 | 11 | 333 | 2568 | 28.1667 | 84.25 | 2020-06-06 02:33:00 | Nepal | |||
803748 | 803748 | 2020-06-01 | US | Pennsylvania | Luzerne | 42079 | 2717 | 149 | 0 | 2568 | 41.17823008 | -75.98447579 | 2020-06-02 02:33:08 | Luzerne, Pennsylvania, US |
1039918 | 1039918 | 2020-05-26 | US | New York | Monroe | 36055 | 2762 | 194 | 0 | 2568 | 43.14638895 | -77.69322942 | 2020-05-27 02:32:31 | Monroe, New York, 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]);