johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
437 rows where confirmed = 1418 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 418
- China 4
- India 2
- Japan 2
- Saint Vincent and the Grenadines 2
- Brazil 1
- Chile 1
- Colombia 1
- Italy 1
- Liechtenstein 1
- Lithuania 1
- Philippines 1
- Slovenia 1
- Ukraine 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
331273 | 331273 | 2022-12-27 | US | Virginia | King and Queen | 51097 | 1418 | 16 | 0 | 37.71044922 | -76.88689628 | 2022-12-28 04:21:04 | King and Queen, Virginia, US | |
315000 | 315000 | 2022-11-13 | US | Texas | Garza | 48169 | 1418 | 30 | 0 | 33.17969345 | -101.2984114 | 2022-11-14 04:21:09 | Garza, Texas, US | |
66161 | 66161 | 2022-11-12 | US | Texas | Garza | 48169 | 1418 | 30 | 0 | 33.17969345 | -101.2984114 | 2022-11-13 04:21:14 | Garza, Texas, US | |
2930323 | 2930323 | 2022-11-11 | US | Texas | Garza | 48169 | 1418 | 30 | 0 | 33.17969345 | -101.2984114 | 2022-11-12 04:20:41 | Garza, Texas, US | |
2509159 | 2509159 | 2022-11-10 | US | Texas | Garza | 48169 | 1418 | 30 | 0 | 33.17969345 | -101.2984114 | 2022-11-11 04:21:22 | Garza, Texas, US | |
2434034 | 2434034 | 2022-11-09 | US | Texas | Garza | 48169 | 1418 | 30 | 0 | 33.17969345 | -101.2984114 | 2022-11-10 04:21:16 | Garza, Texas, US | |
482690 | 482690 | 2022-11-08 | US | Texas | Garza | 48169 | 1418 | 30 | 0 | 33.17969345 | -101.2984114 | 2022-11-09 04:21:22 | Garza, Texas, US | |
2441840 | 2441840 | 2022-11-07 | US | Texas | Garza | 48169 | 1418 | 30 | 0 | 33.17969345 | -101.2984114 | 2022-11-08 04:21:21 | Garza, Texas, US | |
1833442 | 1833442 | 2022-10-25 | US | Vermont | Essex | 50009 | 1418 | 4 | 0 | 44.72736416 | -71.73579864 | 2022-10-26 04:22:19 | Essex, Vermont, US | |
797703 | 797703 | 2022-10-24 | US | Vermont | Essex | 50009 | 1418 | 4 | 0 | 44.72736416 | -71.73579864 | 2022-10-25 04:21:53 | Essex, Vermont, US | |
3280158 | 3280158 | 2022-10-23 | US | Vermont | Essex | 50009 | 1418 | 4 | 0 | 44.72736416 | -71.73579864 | 2022-10-24 04:22:29 | Essex, Vermont, US | |
2271196 | 2271196 | 2022-10-22 | US | Vermont | Essex | 50009 | 1418 | 4 | 0 | 44.72736416 | -71.73579864 | 2022-10-23 04:22:46 | Essex, Vermont, US | |
1595496 | 1595496 | 2022-10-21 | US | Vermont | Essex | 50009 | 1418 | 4 | 0 | 44.72736416 | -71.73579864 | 2022-10-22 04:22:53 | Essex, Vermont, US | |
2275212 | 2275212 | 2022-10-20 | US | Vermont | Essex | 50009 | 1418 | 4 | 0 | 44.72736416 | -71.73579864 | 2022-10-21 04:22:23 | Essex, Vermont, US | |
201547 | 201547 | 2022-10-19 | US | Vermont | Essex | 50009 | 1418 | 4 | 0 | 44.72736416 | -71.73579864 | 2022-10-20 04:22:59 | Essex, Vermont, US | |
3098101 | 3098101 | 2022-10-09 | US | Colorado | Saguache | 8109 | 1418 | 12 | 0 | 38.08054629 | -106.282466 | 2022-10-10 04:22:32 | Saguache, Colorado, US | |
4003326 | 4003326 | 2022-10-08 | US | Colorado | Saguache | 8109 | 1418 | 12 | 0 | 38.08054629 | -106.282466 | 2022-10-09 04:21:16 | Saguache, Colorado, US | |
396923 | 396923 | 2022-10-07 | US | Colorado | Saguache | 8109 | 1418 | 12 | 0 | 38.08054629 | -106.282466 | 2022-10-08 04:22:56 | Saguache, Colorado, US | |
2530040 | 2530040 | 2022-10-06 | US | Colorado | Saguache | 8109 | 1418 | 12 | 0 | 38.08054629 | -106.282466 | 2022-10-07 04:23:08 | Saguache, Colorado, US | |
2686697 | 2686697 | 2022-10-03 | US | Illinois | Henderson | 17071 | 1418 | 19 | 0 | 40.81908672 | -90.92491462 | 2022-10-04 04:22:55 | Henderson, Illinois, US | |
2018874 | 2018874 | 2022-09-20 | US | Nevada | Mineral | 32021 | 1418 | 18 | 0 | 38.53841696 | -118.4344506 | 2022-09-21 04:23:22 | Mineral, Nevada, US | |
3572747 | 3572747 | 2022-09-19 | US | Nevada | Mineral | 32021 | 1418 | 18 | 0 | 38.53841696 | -118.4344506 | 2022-09-20 04:22:48 | Mineral, Nevada, US | |
421486 | 421486 | 2022-09-18 | US | Nevada | Mineral | 32021 | 1418 | 18 | 0 | 38.53841696 | -118.4344506 | 2022-09-19 04:21:49 | Mineral, Nevada, US | |
3375510 | 3375510 | 2022-09-17 | US | Nevada | Mineral | 32021 | 1418 | 18 | 0 | 38.53841696 | -118.4344506 | 2022-09-18 04:22:50 | Mineral, Nevada, US | |
2357618 | 2357618 | 2022-09-16 | US | Nevada | Mineral | 32021 | 1418 | 18 | 0 | 38.53841696 | -118.4344506 | 2022-09-17 04:20:19 | Mineral, Nevada, US | |
3988775 | 3988775 | 2022-09-15 | US | Nevada | Mineral | 32021 | 1418 | 18 | 0 | 38.53841696 | -118.4344506 | 2022-09-16 04:21:19 | Mineral, Nevada, US | |
1891292 | 1891292 | 2022-09-14 | US | Nevada | Mineral | 32021 | 1418 | 18 | 0 | 38.53841696 | -118.4344506 | 2022-09-15 04:21:02 | Mineral, Nevada, US | |
374347 | 374347 | 2022-09-13 | US | Nevada | Mineral | 32021 | 1418 | 18 | 0 | 38.53841696 | -118.4344506 | 2022-09-14 04:20:44 | Mineral, Nevada, US | |
373445 | 373445 | 2022-09-13 | US | Iowa | Taylor | 19173 | 1418 | 23 | 0 | 40.73710579 | -94.69778563 | 2022-09-14 04:20:44 | Taylor, Iowa, US | |
2396949 | 2396949 | 2022-09-12 | US | Nevada | Mineral | 32021 | 1418 | 18 | 0 | 38.53841696 | -118.4344506 | 2022-09-13 04:20:57 | Mineral, Nevada, US | |
2396047 | 2396047 | 2022-09-12 | US | Iowa | Taylor | 19173 | 1418 | 23 | 0 | 40.73710579 | -94.69778563 | 2022-09-13 04:20:57 | Taylor, Iowa, US | |
3768027 | 3768027 | 2022-09-11 | US | Nevada | Mineral | 32021 | 1418 | 18 | 0 | 38.53841696 | -118.4344506 | 2022-09-12 04:20:58 | Mineral, Nevada, US | |
3767125 | 3767125 | 2022-09-11 | US | Iowa | Taylor | 19173 | 1418 | 23 | 0 | 40.73710579 | -94.69778563 | 2022-09-12 04:20:58 | Taylor, Iowa, US | |
3826602 | 3826602 | 2022-09-10 | US | Nevada | Mineral | 32021 | 1418 | 18 | 0 | 38.53841696 | -118.4344506 | 2022-09-11 04:20:50 | Mineral, Nevada, US | |
3825700 | 3825700 | 2022-09-10 | US | Iowa | Taylor | 19173 | 1418 | 23 | 0 | 40.73710579 | -94.69778563 | 2022-09-11 04:20:50 | Taylor, Iowa, US | |
965059 | 965059 | 2022-09-09 | US | Nevada | Mineral | 32021 | 1418 | 18 | 0 | 38.53841696 | -118.4344506 | 2022-09-10 04:21:10 | Mineral, Nevada, US | |
964157 | 964157 | 2022-09-09 | US | Iowa | Taylor | 19173 | 1418 | 23 | 0 | 40.73710579 | -94.69778563 | 2022-09-10 04:21:10 | Taylor, Iowa, US | |
255461 | 255461 | 2022-09-08 | US | Nevada | Mineral | 32021 | 1418 | 18 | 0 | 38.53841696 | -118.4344506 | 2022-09-09 04:21:11 | Mineral, Nevada, US | |
254559 | 254559 | 2022-09-08 | US | Iowa | Taylor | 19173 | 1418 | 23 | 0 | 40.73710579 | -94.69778563 | 2022-09-09 04:21:11 | Taylor, Iowa, US | |
3747259 | 3747259 | 2022-09-07 | US | Nevada | Mineral | 32021 | 1418 | 18 | 0 | 38.53841696 | -118.4344506 | 2022-09-08 04:21:02 | Mineral, Nevada, US | |
3746357 | 3746357 | 2022-09-07 | US | Iowa | Taylor | 19173 | 1418 | 23 | 0 | 40.73710579 | -94.69778563 | 2022-09-08 04:21:02 | Taylor, Iowa, US | |
3746159 | 3746159 | 2022-09-07 | US | Illinois | Scott | 17171 | 1418 | 13 | 0 | 39.6429169 | -90.47814431 | 2022-09-08 04:21:02 | Scott, Illinois, US | |
117664 | 117664 | 2022-09-06 | US | South Dakota | Walworth | 46129 | 1418 | 26 | 0 | 45.43019636 | -100.0307514 | 2022-09-07 04:20:59 | Walworth, South Dakota, US | |
2636636 | 2636636 | 2022-09-05 | US | South Dakota | Walworth | 46129 | 1418 | 26 | 0 | 45.43019636 | -100.0307514 | 2022-09-06 04:21:02 | Walworth, South Dakota, US | |
2990606 | 2990606 | 2022-09-04 | US | Virginia | Charles City | 51036 | 1418 | 31 | 0 | 37.35358063 | -77.05634116 | 2022-09-05 04:21:01 | Charles City, Virginia, US | |
2990200 | 2990200 | 2022-09-04 | US | South Dakota | Walworth | 46129 | 1418 | 26 | 0 | 45.43019636 | -100.0307514 | 2022-09-05 04:21:01 | Walworth, South Dakota, US | |
2716291 | 2716291 | 2022-09-03 | US | Virginia | Charles City | 51036 | 1418 | 31 | 0 | 37.35358063 | -77.05634116 | 2022-09-04 04:21:22 | Charles City, Virginia, US | |
2715885 | 2715885 | 2022-09-03 | US | South Dakota | Walworth | 46129 | 1418 | 26 | 0 | 45.43019636 | -100.0307514 | 2022-09-04 04:21:22 | Walworth, South Dakota, US | |
1396996 | 1396996 | 2022-09-02 | US | Virginia | Charles City | 51036 | 1418 | 31 | 0 | 37.35358063 | -77.05634116 | 2022-09-03 04:21:04 | Charles City, Virginia, US | |
1396590 | 1396590 | 2022-09-02 | US | South Dakota | Walworth | 46129 | 1418 | 26 | 0 | 45.43019636 | -100.0307514 | 2022-09-03 04:21:04 | Walworth, South Dakota, US | |
3550419 | 3550419 | 2022-09-01 | US | South Dakota | Walworth | 46129 | 1418 | 26 | 0 | 45.43019636 | -100.0307514 | 2022-09-02 04:21:07 | Walworth, South Dakota, US | |
2346339 | 2346339 | 2022-08-31 | US | South Dakota | Walworth | 46129 | 1418 | 26 | 0 | 45.43019636 | -100.0307514 | 2022-09-01 04:21:03 | Walworth, South Dakota, US | |
2326562 | 2326562 | 2022-08-24 | US | Texas | Sabine | 48403 | 1418 | 89 | 0 | 31.34318809 | -93.85440451 | 2022-08-25 04:21:13 | Sabine, Texas, US | |
1253857 | 1253857 | 2022-08-23 | US | Texas | Goliad | 48175 | 1418 | 32 | 0 | 28.65696592 | -97.42760647 | 2022-08-24 04:20:46 | Goliad, Texas, US | |
2011102 | 2011102 | 2022-08-04 | US | North Dakota | McHenry | 38049 | 1418 | 31 | 0 | 48.23104458 | -100.6324822 | 2022-08-05 04:20:52 | McHenry, North Dakota, US | |
1100529 | 1100529 | 2022-08-03 | US | North Dakota | McHenry | 38049 | 1418 | 31 | 0 | 48.23104458 | -100.6324822 | 2022-08-04 04:20:58 | McHenry, North Dakota, US | |
3432351 | 3432351 | 2022-07-14 | US | Virginia | Norton | 51720 | 1418 | 22 | 0 | 36.93357076 | -82.62750411 | 2022-07-15 04:20:53 | Norton, Virginia, US | |
3896953 | 3896953 | 2022-05-19 | US | Illinois | Gallatin | 17059 | 1418 | 17 | 0 | 37.76430935 | -88.22953869 | 2022-05-20 04:20:57 | Gallatin, Illinois, US | |
3585547 | 3585547 | 2022-05-17 | US | South Dakota | Spink | 46115 | 1418 | 36 | 0 | 44.93837606 | -98.34626602 | 2022-05-18 04:20:50 | Spink, South Dakota, US | |
1506504 | 1506504 | 2022-05-16 | US | South Dakota | Spink | 46115 | 1418 | 36 | 0 | 44.93837606 | -98.34626602 | 2022-05-17 04:20:59 | Spink, South Dakota, US | |
2086863 | 2086863 | 2022-05-15 | US | South Dakota | Spink | 46115 | 1418 | 36 | 0 | 44.93837606 | -98.34626602 | 2022-05-16 04:20:47 | Spink, South Dakota, US | |
3357573 | 3357573 | 2022-05-14 | US | South Dakota | Spink | 46115 | 1418 | 36 | 0 | 44.93837606 | -98.34626602 | 2022-05-15 04:20:53 | Spink, South Dakota, US | |
661218 | 661218 | 2022-05-13 | US | South Dakota | Spink | 46115 | 1418 | 36 | 0 | 44.93837606 | -98.34626602 | 2022-05-14 04:20:48 | Spink, South Dakota, US | |
2536301 | 2536301 | 2022-05-12 | US | South Dakota | Spink | 46115 | 1418 | 36 | 0 | 44.93837606 | -98.34626602 | 2022-05-13 04:20:51 | Spink, South Dakota, US | |
3447747 | 3447747 | 2022-05-11 | US | South Dakota | Spink | 46115 | 1418 | 36 | 0 | 44.93837606 | -98.34626602 | 2022-05-12 04:20:54 | Spink, South Dakota, US | |
2334820 | 2334820 | 2022-05-08 | US | Washington | Ferry | 53019 | 1418 | 29 | 0 | 48.4711431 | -118.5154041 | 2022-05-09 04:20:54 | Ferry, Washington, US | |
363782 | 363782 | 2022-05-07 | US | Washington | Ferry | 53019 | 1418 | 29 | 0 | 48.4711431 | -118.5154041 | 2022-05-08 04:20:49 | Ferry, Washington, US | |
1401133 | 1401133 | 2022-05-06 | US | Washington | Ferry | 53019 | 1418 | 29 | 0 | 48.4711431 | -118.5154041 | 2022-05-07 04:21:09 | Ferry, Washington, US | |
2601488 | 2601488 | 2022-05-05 | US | Washington | Ferry | 53019 | 1418 | 29 | 0 | 48.4711431 | -118.5154041 | 2022-05-06 04:21:00 | Ferry, Washington, US | |
3268937 | 3268937 | 2022-05-04 | US | Washington | Ferry | 53019 | 1418 | 29 | 0 | 48.4711431 | -118.5154041 | 2022-05-05 04:20:55 | Ferry, Washington, US | |
3854444 | 3854444 | 2022-04-27 | US | Oregon | Lake | 41037 | 1418 | 29 | 0 | 42.79246693 | -120.3850163 | 2022-04-28 04:20:47 | Lake, Oregon, US | |
1328874 | 1328874 | 2022-04-26 | US | Oregon | Lake | 41037 | 1418 | 29 | 0 | 42.79246693 | -120.38501629999999 | 2022-04-27 04:20:52 | Lake, Oregon, US | |
1467889 | 1467889 | 2022-03-24 | China | Guangxi | 1418 | 2 | 0 | 23.8298 | 108.7881 | 2022-03-25 04:20:46 | Guangxi, China | |||
1867136 | 1867136 | 2022-03-10 | US | Michigan | Luce | 26095 | 1418 | 10 | 0 | 46.47227431 | -85.54471223 | 2022-03-11 04:20:50 | Luce, Michigan, US | |
2143548 | 2143548 | 2022-03-09 | US | Virginia | Mathews | 51115 | 1418 | 28 | 0 | 37.44164146 | -76.34098896 | 2022-03-10 04:20:48 | Mathews, Virginia, US | |
2141831 | 2141831 | 2022-03-09 | US | Michigan | Luce | 26095 | 1418 | 10 | 0 | 46.47227431 | -85.54471223 | 2022-03-10 04:20:48 | Luce, Michigan, US | |
923059 | 923059 | 2022-03-08 | US | Virginia | Mathews | 51115 | 1418 | 28 | 0 | 37.44164146 | -76.34098896 | 2022-03-09 04:20:59 | Mathews, Virginia, US | |
1513467 | 1513467 | 2022-02-24 | US | Nebraska | Clay | 31035 | 1418 | 11 | 0 | 40.52439441 | -98.05126296 | 2022-02-25 04:21:11 | Clay, Nebraska, US | |
3914078 | 3914078 | 2022-02-20 | US | Nebraska | Clay | 31035 | 1418 | 11 | 0 | 40.52439441 | -98.05126296 | 2022-02-21 04:21:05 | Clay, Nebraska, US | |
3877636 | 3877636 | 2022-02-19 | US | Nebraska | Clay | 31035 | 1418 | 11 | 0 | 40.52439441 | -98.05126296 | 2022-02-20 04:21:00 | Clay, Nebraska, US | |
3857892 | 3857892 | 2022-02-18 | US | Nebraska | Clay | 31035 | 1418 | 11 | 0 | 40.52439441 | -98.05126296 | 2022-02-19 04:21:11 | Clay, Nebraska, US | |
1365396 | 1365396 | 2022-02-08 | US | Texas | Carson | 48065 | 1418 | 31 | 0 | 35.40365929 | -101.35426690000001 | 2022-02-09 04:21:04 | Carson, Texas, US | |
982500 | 982500 | 2022-02-01 | US | Wisconsin | Iron | 55051 | 1418 | 45 | 0 | 46.26302338 | -90.24295041 | 2022-02-02 04:21:09 | Iron, Wisconsin, US | |
3063963 | 3063963 | 2022-01-29 | US | Missouri | Shelby | 29205 | 1418 | 13 | 0 | 39.79742518 | -92.07634971 | 2022-01-30 04:21:26 | Shelby, Missouri, US | |
3811896 | 3811896 | 2022-01-28 | US | Missouri | Shannon | 29203 | 1418 | 32 | 0 | 37.15772072 | -91.40190382 | 2022-01-29 04:21:10 | Shannon, Missouri, US | |
3689360 | 3689360 | 2022-01-13 | US | Missouri | Caldwell | 29025 | 1418 | 28 | 0 | 39.65620858 | -93.98308093 | 2022-01-14 04:21:54 | Caldwell, Missouri, US | |
1695834 | 1695834 | 2022-01-10 | US | West Virginia | Tucker | 54093 | 1418 | 32 | 0 | 39.11240885 | -79.57053576 | 2022-01-11 04:22:01 | Tucker, West Virginia, US | |
1695088 | 1695088 | 2022-01-10 | US | Puerto Rico | Penuelas | 72111 | 1418 | 0 | 0 | 18.059645 | -66.721572 | 2022-01-11 04:22:01 | Penuelas, Puerto Rico, US | |
1285598 | 1285598 | 2022-01-05 | US | Wyoming | Johnson | 56019 | 1418 | 18 | 0 | 44.04057166 | -106.58451740000001 | 2022-01-06 04:22:09 | Johnson, Wyoming, US | |
1284042 | 1284042 | 2022-01-05 | US | Nebraska | Butler | 31023 | 1418 | 11 | 0 | 41.22703692 | -97.13106306 | 2022-01-06 04:22:09 | Butler, Nebraska, US | |
2112104 | 2112104 | 2021-12-26 | US | Alabama | Sumter | 1119 | 1418 | 42 | 0 | 32.59117397 | -88.19916205 | 2021-12-27 04:21:58 | Sumter, Alabama, US | |
3605476 | 3605476 | 2021-12-25 | US | Alabama | Sumter | 1119 | 1418 | 42 | 0 | 32.59117397 | -88.19916205 | 2021-12-26 04:21:50 | Sumter, Alabama, US | |
3832042 | 3832042 | 2021-12-21 | US | Wisconsin | Pepin | 55091 | 1418 | 12 | 0 | 44.58307413 | -91.99949611 | 2021-12-22 04:21:54 | Pepin, Wisconsin, US | |
1256165 | 1256165 | 2021-12-20 | US | Kentucky | Crittenden | 21055 | 1418 | 37 | 0 | 37.35839237 | -88.08826090000002 | 2021-12-21 03:21:27 | Crittenden, Kentucky, US | |
2090034 | 2090034 | 2021-12-14 | US | Nebraska | Cuming | 31039 | 1418 | 15 | 0 | 41.91637624 | -96.78730772 | 2021-12-15 03:22:16 | Cuming, Nebraska, US | |
784604 | 784604 | 2021-12-13 | US | New Mexico | Sierra | 35051 | 1418 | 61 | 0 | 33.13028233 | -107.1925893 | 2021-12-14 04:22:38 | Sierra, New Mexico, US | |
1660876 | 1660876 | 2021-12-12 | US | Arizona | Greenlee | 4011 | 1418 | 23 | 0 | 33.21498827 | -109.2405279 | 2021-12-13 04:22:02 | Greenlee, Arizona, US | |
1667535 | 1667535 | 2021-12-11 | US | Texas | Gaines | 48165 | 1418 | 66 | 0 | 32.74055318 | -102.6353295 | 2021-12-12 04:22:12 | Gaines, Texas, US | |
551409 | 551409 | 2021-12-08 | US | Colorado | Lincoln | 8073 | 1418 | 9 | 0 | 38.98749519 | -103.51366490000001 | 2021-12-09 04:22:49 | Lincoln, Colorado, US | |
1743373 | 1743373 | 2021-12-05 | US | South Carolina | McCormick | 45065 | 1418 | 30 | 0 | 33.90161443 | -82.30794338 | 2021-12-06 04:22:34 | McCormick, South Carolina, 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]);