johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
389 rows where confirmed = 1427 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3554749 | 3554749 | 2022-11-27 | US | Texas | Garza | 48169 | 1427 | 30 | 0 | 33.17969345 | -101.2984114 | 2022-11-28 04:21:02 | Garza, Texas, US | |
2103229 | 2103229 | 2022-11-26 | US | Texas | Garza | 48169 | 1427 | 30 | 0 | 33.17969345 | -101.2984114 | 2022-11-27 04:21:05 | Garza, Texas, US | |
490720 | 490720 | 2022-11-25 | US | Texas | Garza | 48169 | 1427 | 30 | 0 | 33.17969345 | -101.2984114 | 2022-11-26 04:21:11 | Garza, Texas, US | |
3526549 | 3526549 | 2022-11-24 | US | Texas | Garza | 48169 | 1427 | 30 | 0 | 33.17969345 | -101.2984114 | 2022-11-25 04:21:06 | Garza, Texas, US | |
3315332 | 3315332 | 2022-11-23 | US | Texas | Garza | 48169 | 1427 | 30 | 0 | 33.17969345 | -101.2984114 | 2022-11-24 04:21:09 | Garza, Texas, US | |
1623373 | 1623373 | 2022-11-22 | US | Texas | Garza | 48169 | 1427 | 30 | 0 | 33.17969345 | -101.2984114 | 2022-11-23 04:21:06 | Garza, Texas, US | |
3463261 | 3463261 | 2022-11-21 | US | Texas | Garza | 48169 | 1427 | 30 | 0 | 33.17969345 | -101.2984114 | 2022-11-22 04:20:47 | Garza, Texas, US | |
713739 | 713739 | 2022-11-01 | US | Vermont | Essex | 50009 | 1427 | 4 | 0 | 44.72736416 | -71.73579864 | 2022-11-02 04:22:09 | Essex, Vermont, US | |
3288188 | 3288188 | 2022-10-31 | US | Vermont | Essex | 50009 | 1427 | 4 | 0 | 44.72736416 | -71.73579864 | 2022-11-01 04:22:36 | Essex, Vermont, US | |
323221 | 323221 | 2022-10-30 | US | Vermont | Essex | 50009 | 1427 | 4 | 0 | 44.72736416 | -71.73579864 | 2022-10-31 04:21:36 | Essex, Vermont, US | |
915497 | 915497 | 2022-10-29 | US | Vermont | Essex | 50009 | 1427 | 4 | 0 | 44.72736416 | -71.73579864 | 2022-10-30 04:22:14 | Essex, Vermont, US | |
1369766 | 1369766 | 2022-10-28 | US | Vermont | Essex | 50009 | 1427 | 4 | 0 | 44.72736416 | -71.73579864 | 2022-10-29 04:21:13 | Essex, Vermont, US | |
3041621 | 3041621 | 2022-10-27 | US | Vermont | Essex | 50009 | 1427 | 4 | 0 | 44.72736416 | -71.73579864 | 2022-10-28 04:22:31 | Essex, Vermont, US | |
542041 | 542041 | 2022-10-26 | US | Vermont | Essex | 50009 | 1427 | 4 | 0 | 44.72736416 | -71.73579864 | 2022-10-27 04:22:01 | Essex, Vermont, US | |
373247 | 373247 | 2022-09-13 | US | Illinois | Scott | 17171 | 1427 | 13 | 0 | 39.6429169 | -90.47814431 | 2022-09-14 04:20:44 | Scott, Illinois, US | |
3768943 | 3768943 | 2022-09-11 | US | Texas | Crane | 48103 | 1427 | 24 | 0 | 31.43052248 | -102.5143314 | 2022-09-12 04:20:58 | Crane, Texas, US | |
3827518 | 3827518 | 2022-09-10 | US | Texas | Crane | 48103 | 1427 | 24 | 0 | 31.43052248 | -102.5143314 | 2022-09-11 04:20:50 | Crane, Texas, US | |
965975 | 965975 | 2022-09-09 | US | Texas | Crane | 48103 | 1427 | 24 | 0 | 31.43052248 | -102.5143314 | 2022-09-10 04:21:10 | Crane, Texas, US | |
256377 | 256377 | 2022-09-08 | US | Texas | Crane | 48103 | 1427 | 24 | 0 | 31.43052248 | -102.5143314 | 2022-09-09 04:21:11 | Crane, Texas, US | |
116097 | 116097 | 2022-09-06 | US | Kansas | Scott | 20171 | 1427 | 34 | 0 | 38.48222076 | -100.9066539 | 2022-09-07 04:20:59 | Scott, Kansas, US | |
2637042 | 2637042 | 2022-09-05 | US | Virginia | Charles City | 51036 | 1427 | 31 | 0 | 37.35358063 | -77.05634116 | 2022-09-06 04:21:02 | Charles City, Virginia, US | |
2636365 | 2636365 | 2022-09-05 | US | Oregon | Wallowa | 41063 | 1427 | 20 | 0 | 45.57894064 | -117.183538 | 2022-09-06 04:21:02 | Wallowa, Oregon, US | |
2635069 | 2635069 | 2022-09-05 | US | Kansas | Scott | 20171 | 1427 | 34 | 0 | 38.48222076 | -100.9066539 | 2022-09-06 04:21:02 | Scott, Kansas, US | |
2989929 | 2989929 | 2022-09-04 | US | Oregon | Wallowa | 41063 | 1427 | 20 | 0 | 45.57894064 | -117.183538 | 2022-09-05 04:21:01 | Wallowa, Oregon, US | |
2988633 | 2988633 | 2022-09-04 | US | Kansas | Scott | 20171 | 1427 | 34 | 0 | 38.48222076 | -100.9066539 | 2022-09-05 04:21:01 | Scott, Kansas, US | |
2715614 | 2715614 | 2022-09-03 | US | Oregon | Wallowa | 41063 | 1427 | 20 | 0 | 45.57894064 | -117.183538 | 2022-09-04 04:21:22 | Wallowa, Oregon, US | |
2714318 | 2714318 | 2022-09-03 | US | Kansas | Scott | 20171 | 1427 | 34 | 0 | 38.48222076 | -100.9066539 | 2022-09-04 04:21:22 | Scott, Kansas, US | |
1396319 | 1396319 | 2022-09-02 | US | Oregon | Wallowa | 41063 | 1427 | 20 | 0 | 45.57894064 | -117.183538 | 2022-09-03 04:21:04 | Wallowa, Oregon, US | |
1395023 | 1395023 | 2022-09-02 | US | Kansas | Scott | 20171 | 1427 | 34 | 0 | 38.48222076 | -100.9066539 | 2022-09-03 04:21:04 | Scott, Kansas, US | |
3550148 | 3550148 | 2022-09-01 | US | Oregon | Wallowa | 41063 | 1427 | 19 | 0 | 45.57894064 | -117.183538 | 2022-09-02 04:21:07 | Wallowa, Oregon, US | |
3548852 | 3548852 | 2022-09-01 | US | Kansas | Scott | 20171 | 1427 | 34 | 0 | 38.48222076 | -100.9066539 | 2022-09-02 04:21:07 | Scott, Kansas, US | |
2346068 | 2346068 | 2022-08-31 | US | Oregon | Wallowa | 41063 | 1427 | 19 | 0 | 45.57894064 | -117.183538 | 2022-09-01 04:21:03 | Wallowa, Oregon, US | |
2344772 | 2344772 | 2022-08-31 | US | Kansas | Scott | 20171 | 1427 | 34 | 0 | 38.48222076 | -100.9066539 | 2022-09-01 04:21:03 | Scott, Kansas, US | |
3776548 | 3776548 | 2022-08-30 | US | Oregon | Wallowa | 41063 | 1427 | 19 | 0 | 45.57894064 | -117.183538 | 2022-08-31 04:20:57 | Wallowa, Oregon, US | |
1347284 | 1347284 | 2022-08-10 | US | Illinois | Alexander | 17003 | 1427 | 16 | 0 | 37.18049267 | -89.32910838 | 2022-08-11 04:20:49 | Alexander, Illinois, US | |
1073065 | 1073065 | 2022-08-07 | US | Texas | McCulloch | 48307 | 1427 | 47 | 0 | 31.1925468 | -99.34682807 | 2022-08-08 04:21:08 | McCulloch, Texas, US | |
1943653 | 1943653 | 2022-08-06 | US | Texas | McCulloch | 48307 | 1427 | 47 | 0 | 31.1925468 | -99.34682807 | 2022-08-07 04:20:54 | McCulloch, Texas, US | |
883452 | 883452 | 2022-08-05 | US | Texas | McCulloch | 48307 | 1427 | 47 | 0 | 31.1925468 | -99.34682807 | 2022-08-06 04:20:56 | McCulloch, Texas, US | |
2011863 | 2011863 | 2022-08-04 | US | Texas | McCulloch | 48307 | 1427 | 47 | 0 | 31.1925468 | -99.34682807 | 2022-08-05 04:20:52 | McCulloch, Texas, US | |
1101290 | 1101290 | 2022-08-03 | US | Texas | McCulloch | 48307 | 1427 | 47 | 0 | 31.1925468 | -99.34682807 | 2022-08-04 04:20:58 | McCulloch, Texas, US | |
1406274 | 1406274 | 2022-08-02 | US | Iowa | Osceola | 19143 | 1427 | 22 | 0 | 43.37824276 | -95.62422844 | 2022-08-03 04:20:59 | Osceola, Iowa, US | |
1405810 | 1405810 | 2022-08-02 | US | Georgia | Calhoun | 13037 | 1427 | 24 | 0 | 31.53169785 | -84.62725131 | 2022-08-03 04:20:59 | Calhoun, Georgia, US | |
3618312 | 3618312 | 2022-08-01 | US | Iowa | Osceola | 19143 | 1427 | 22 | 0 | 43.37824276 | -95.62422844 | 2022-08-02 04:20:53 | Osceola, Iowa, US | |
3617848 | 3617848 | 2022-08-01 | US | Georgia | Calhoun | 13037 | 1427 | 24 | 0 | 31.53169785 | -84.62725131 | 2022-08-02 04:20:53 | Calhoun, Georgia, US | |
3872792 | 3872792 | 2022-07-31 | US | Iowa | Osceola | 19143 | 1427 | 22 | 0 | 43.37824276 | -95.62422844 | 2022-08-01 04:21:03 | Osceola, Iowa, US | |
3872328 | 3872328 | 2022-07-31 | US | Georgia | Calhoun | 13037 | 1427 | 24 | 0 | 31.53169785 | -84.62725131 | 2022-08-01 04:21:03 | Calhoun, Georgia, US | |
675546 | 675546 | 2022-07-30 | US | Iowa | Osceola | 19143 | 1427 | 22 | 0 | 43.37824276 | -95.62422844 | 2022-07-31 04:21:02 | Osceola, Iowa, US | |
675082 | 675082 | 2022-07-30 | US | Georgia | Calhoun | 13037 | 1427 | 24 | 0 | 31.53169785 | -84.62725131 | 2022-07-31 04:21:02 | Calhoun, Georgia, US | |
1784745 | 1784745 | 2022-07-29 | US | Iowa | Osceola | 19143 | 1427 | 22 | 0 | 43.37824276 | -95.62422844 | 2022-07-30 04:20:42 | Osceola, Iowa, US | |
1784281 | 1784281 | 2022-07-29 | US | Georgia | Calhoun | 13037 | 1427 | 24 | 0 | 31.53169785 | -84.62725131 | 2022-07-30 04:20:42 | Calhoun, Georgia, US | |
1067108 | 1067108 | 2022-07-28 | US | Iowa | Osceola | 19143 | 1427 | 22 | 0 | 43.37824276 | -95.62422844 | 2022-07-29 04:20:45 | Osceola, Iowa, US | |
1066644 | 1066644 | 2022-07-28 | US | Georgia | Calhoun | 13037 | 1427 | 24 | 0 | 31.53169785 | -84.62725131 | 2022-07-29 04:20:45 | Calhoun, Georgia, US | |
2336627 | 2336627 | 2022-07-27 | US | Iowa | Osceola | 19143 | 1427 | 22 | 0 | 43.37824276 | -95.62422844 | 2022-07-28 04:20:56 | Osceola, Iowa, US | |
2336163 | 2336163 | 2022-07-27 | US | Georgia | Calhoun | 13037 | 1427 | 24 | 0 | 31.53169785 | -84.62725131 | 2022-07-28 04:20:56 | Calhoun, Georgia, US | |
1610691 | 1610691 | 2022-07-20 | US | North Dakota | Sioux | 38085 | 1427 | 19 | 0 | 46.11323337 | -101.0440149 | 2022-07-21 04:21:10 | Sioux, North Dakota, US | |
3213668 | 3213668 | 2022-07-18 | US | Virginia | Norton | 51720 | 1427 | 22 | 0 | 36.93357076 | -82.62750411 | 2022-07-19 04:20:58 | Norton, Virginia, US | |
3969448 | 3969448 | 2022-07-05 | US | South Dakota | Moody | 46101 | 1427 | 28 | 0 | 44.02266214 | -96.67081159 | 2022-07-06 04:20:58 | Moody, South Dakota, US | |
3080959 | 3080959 | 2022-07-04 | US | South Dakota | Moody | 46101 | 1427 | 28 | 0 | 44.02266214 | -96.67081159 | 2022-07-05 04:20:45 | Moody, South Dakota, US | |
1770241 | 1770241 | 2022-07-03 | US | South Dakota | Moody | 46101 | 1427 | 28 | 0 | 44.02266214 | -96.67081159 | 2022-07-04 04:20:54 | Moody, South Dakota, US | |
3368227 | 3368227 | 2022-07-02 | US | South Dakota | Moody | 46101 | 1427 | 28 | 0 | 44.02266214 | -96.67081159 | 2022-07-03 04:20:59 | Moody, South Dakota, US | |
596556 | 596556 | 2022-07-01 | US | South Dakota | Moody | 46101 | 1427 | 28 | 0 | 44.02266214 | -96.67081159 | 2022-07-02 04:21:16 | Moody, South Dakota, US | |
3942957 | 3942957 | 2022-06-30 | US | South Dakota | Moody | 46101 | 1427 | 28 | 0 | 44.02266214 | -96.67081159 | 2022-07-01 04:21:10 | Moody, South Dakota, US | |
3941930 | 3941930 | 2022-06-30 | US | Missouri | Atchison | 29005 | 1427 | 23 | 0 | 40.43238737 | -95.42970639 | 2022-07-01 04:21:10 | Atchison, Missouri, US | |
2492915 | 2492915 | 2022-06-29 | US | South Dakota | Moody | 46101 | 1427 | 28 | 0 | 44.02266214 | -96.67081159 | 2022-06-30 04:21:01 | Moody, South Dakota, US | |
2491888 | 2491888 | 2022-06-29 | US | Missouri | Atchison | 29005 | 1427 | 23 | 0 | 40.43238737 | -95.42970639 | 2022-06-30 04:21:01 | Atchison, Missouri, US | |
2242587 | 2242587 | 2022-06-28 | US | Texas | Newton | 48351 | 1427 | 62 | 0 | 30.78548982 | -93.74408813 | 2022-06-29 04:20:59 | Newton, Texas, US | |
2242308 | 2242308 | 2022-06-28 | US | South Dakota | Tripp | 46123 | 1427 | 24 | 0 | 43.34459388 | -99.8854891 | 2022-06-29 04:20:59 | Tripp, South Dakota, US | |
2241270 | 2241270 | 2022-06-28 | US | Missouri | Atchison | 29005 | 1427 | 23 | 0 | 40.43238737 | -95.42970639 | 2022-06-29 04:20:59 | Atchison, Missouri, US | |
2150550 | 2150550 | 2022-06-27 | US | South Dakota | Tripp | 46123 | 1427 | 24 | 0 | 43.34459388 | -99.8854891 | 2022-06-28 04:20:58 | Tripp, South Dakota, US | |
2149512 | 2149512 | 2022-06-27 | US | Missouri | Atchison | 29005 | 1427 | 23 | 0 | 40.43238737 | -95.42970639 | 2022-06-28 04:20:58 | Atchison, Missouri, US | |
478351 | 478351 | 2022-06-26 | US | South Dakota | Tripp | 46123 | 1427 | 24 | 0 | 43.34459388 | -99.8854891 | 2022-06-27 04:21:00 | Tripp, South Dakota, US | |
477313 | 477313 | 2022-06-26 | US | Missouri | Atchison | 29005 | 1427 | 23 | 0 | 40.43238737 | -95.42970639 | 2022-06-27 04:21:00 | Atchison, Missouri, US | |
941726 | 941726 | 2022-06-25 | US | South Dakota | Tripp | 46123 | 1427 | 24 | 0 | 43.34459388 | -99.8854891 | 2022-06-26 04:21:02 | Tripp, South Dakota, US | |
940688 | 940688 | 2022-06-25 | US | Missouri | Atchison | 29005 | 1427 | 23 | 0 | 40.43238737 | -95.42970639 | 2022-06-26 04:21:02 | Atchison, Missouri, US | |
3349546 | 3349546 | 2022-06-24 | US | South Dakota | Tripp | 46123 | 1427 | 24 | 0 | 43.34459388 | -99.8854891 | 2022-06-25 04:20:57 | Tripp, South Dakota, US | |
3348508 | 3348508 | 2022-06-24 | US | Missouri | Atchison | 29005 | 1427 | 23 | 0 | 40.43238737 | -95.42970639 | 2022-06-25 04:20:57 | Atchison, Missouri, US | |
1651287 | 1651287 | 2022-06-23 | US | South Dakota | Tripp | 46123 | 1427 | 24 | 0 | 43.34459388 | -99.8854891 | 2022-06-24 04:20:58 | Tripp, South Dakota, US | |
2190522 | 2190522 | 2022-06-22 | US | South Dakota | Tripp | 46123 | 1427 | 24 | 0 | 43.34459388 | -99.8854891 | 2022-06-23 04:20:55 | Tripp, South Dakota, US | |
167406 | 167406 | 2022-06-21 | US | Kansas | Washington | 20201 | 1427 | 23 | 0 | 39.78420784 | -97.0875323 | 2022-06-22 04:20:54 | Washington, Kansas, US | |
1764689 | 1764689 | 2022-06-20 | US | Kansas | Washington | 20201 | 1427 | 23 | 0 | 39.78420784 | -97.0875323 | 2022-06-21 04:20:56 | Washington, Kansas, US | |
3270875 | 3270875 | 2022-06-19 | US | Kansas | Washington | 20201 | 1427 | 23 | 0 | 39.78420784 | -97.0875323 | 2022-06-20 04:21:01 | Washington, Kansas, US | |
3398787 | 3398787 | 2022-06-18 | US | Kansas | Washington | 20201 | 1427 | 23 | 0 | 39.78420784 | -97.0875323 | 2022-06-19 04:20:51 | Washington, Kansas, US | |
2312664 | 2312664 | 2022-06-17 | US | Kansas | Washington | 20201 | 1427 | 23 | 0 | 39.78420784 | -97.0875323 | 2022-06-18 04:21:10 | Washington, Kansas, US | |
560168 | 560168 | 2022-06-16 | US | Kansas | Washington | 20201 | 1427 | 23 | 0 | 39.78420784 | -97.0875323 | 2022-06-17 04:20:56 | Washington, Kansas, US | |
3983970 | 3983970 | 2022-06-15 | US | Kansas | Washington | 20201 | 1427 | 23 | 0 | 39.78420784 | -97.0875323 | 2022-06-16 04:20:55 | Washington, Kansas, US | |
3000297 | 3000297 | 2022-05-24 | US | Illinois | Gallatin | 17059 | 1427 | 17 | 0 | 37.76430935 | -88.22953869 | 2022-05-25 04:20:56 | Gallatin, Illinois, US | |
3899402 | 3899402 | 2022-05-19 | US | Washington | Ferry | 53019 | 1427 | 29 | 0 | 48.4711431 | -118.5154041 | 2022-05-20 04:20:57 | Ferry, Washington, US | |
3897664 | 3897664 | 2022-05-19 | US | Minnesota | Big Stone | 27011 | 1427 | 9 | 0 | 45.42712824 | -96.41403739 | 2022-05-20 04:20:57 | Big Stone, Minnesota, US | |
1188186 | 1188186 | 2022-05-18 | US | Washington | Ferry | 53019 | 1427 | 29 | 0 | 48.4711431 | -118.5154041 | 2022-05-19 04:20:54 | Ferry, Washington, US | |
1186448 | 1186448 | 2022-05-18 | US | Minnesota | Big Stone | 27011 | 1427 | 9 | 0 | 45.42712824 | -96.41403739 | 2022-05-19 04:20:54 | Big Stone, Minnesota, US | |
3584345 | 3584345 | 2022-05-17 | US | Minnesota | Big Stone | 27011 | 1427 | 9 | 0 | 45.42712824 | -96.41403739 | 2022-05-18 04:20:50 | Big Stone, Minnesota, US | |
2481346 | 2481346 | 2022-03-30 | US | Virginia | Mathews | 51115 | 1427 | 28 | 0 | 37.44164146 | -76.34098896 | 2022-03-31 04:20:56 | Mathews, Virginia, US | |
3629636 | 3629636 | 2022-03-13 | US | Michigan | Oscoda | 26135 | 1427 | 54 | 0 | 44.68192279 | -84.12939244 | 2022-03-14 04:20:46 | Oscoda, Michigan, US | |
952544 | 952544 | 2022-03-12 | US | Michigan | Oscoda | 26135 | 1427 | 54 | 0 | 44.68192279 | -84.12939244 | 2022-03-13 04:20:49 | Oscoda, Michigan, US | |
358005 | 358005 | 2022-03-11 | US | Michigan | Oscoda | 26135 | 1427 | 54 | 0 | 44.68192279 | -84.12939244 | 2022-03-12 04:20:50 | Oscoda, Michigan, US | |
2203164 | 2203164 | 2022-03-06 | US | West Virginia | Wirt | 54105 | 1427 | 23 | 0 | 39.02775007 | -81.37473928 | 2022-03-07 04:20:47 | Wirt, West Virginia, US | |
2095621 | 2095621 | 2022-03-05 | US | West Virginia | Wirt | 54105 | 1427 | 23 | 0 | 39.02775007 | -81.37473928 | 2022-03-06 04:20:49 | Wirt, West Virginia, US | |
2669321 | 2669321 | 2022-03-04 | US | West Virginia | Wirt | 54105 | 1427 | 23 | 0 | 39.02775007 | -81.37473928 | 2022-03-05 04:21:10 | Wirt, West Virginia, US | |
3673374 | 3673374 | 2022-02-15 | US | Minnesota | Grant | 27051 | 1427 | 12 | 0 | 45.93424769 | -96.01139609 | 2022-02-16 04:21:10 | Grant, Minnesota, US | |
189530 | 189530 | 2022-02-13 | US | Washington | Skamania | 53059 | 1427 | 10 | 0 | 46.02408726 | -121.91644029999999 | 2022-02-14 04:20:51 | Skamania, Washington, 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]);