johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
38 rows where confirmed = 14890 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2952379 | 2952379 | 2022-12-20 | US | Illinois | Franklin | 17055 | 14890 | 178 | 0 | 37.99189086 | -88.92567818 | 2022-12-21 04:21:03 | Franklin, Illinois, US | |
797423 | 797423 | 2022-10-24 | US | Tennessee | Warren | 47177 | 14890 | 189 | 0 | 35.6728299 | -85.77969117 | 2022-10-25 04:21:53 | Warren, Tennessee, US | |
117865 | 117865 | 2022-09-06 | US | Texas | Harrison | 48203 | 14890 | 229 | 0 | 32.54935988 | -94.36934071 | 2022-09-07 04:20:59 | Harrison, Texas, US | |
1254095 | 1254095 | 2022-08-23 | US | Virginia | Fauquier | 51061 | 14890 | 153 | 0 | 38.73564842 | -77.80647472 | 2022-08-24 04:20:46 | Fauquier, Virginia, US | |
595898 | 595898 | 2022-07-01 | US | New York | Genesee | 36037 | 14890 | 192 | 0 | 43.0022601 | -78.19135193 | 2022-07-02 04:21:16 | Genesee, New York, US | |
3942299 | 3942299 | 2022-06-30 | US | New York | Genesee | 36037 | 14890 | 192 | 0 | 43.0022601 | -78.19135193 | 2022-07-01 04:21:10 | Genesee, New York, US | |
3022623 | 3022623 | 2022-03-23 | US | Alabama | Blount | 1009 | 14890 | 230 | 0 | 33.98210918 | -86.56790593 | 2022-03-24 04:20:43 | Blount, Alabama, US | |
2736216 | 2736216 | 2022-02-27 | US | Texas | Orange | 48361 | 14890 | 337 | 0 | 30.11879481 | -93.89412775 | 2022-02-28 04:21:05 | Orange, Texas, US | |
2734446 | 2734446 | 2022-02-27 | US | Kentucky | Jessamine | 21113 | 14890 | 128 | 0 | 37.87119786 | -84.58252003 | 2022-02-28 04:21:05 | Jessamine, Kentucky, US | |
3049369 | 3049369 | 2022-02-26 | US | Texas | Orange | 48361 | 14890 | 337 | 0 | 30.11879481 | -93.89412775 | 2022-02-27 04:21:04 | Orange, Texas, US | |
3047599 | 3047599 | 2022-02-26 | US | Kentucky | Jessamine | 21113 | 14890 | 128 | 0 | 37.87119786 | -84.58252003 | 2022-02-27 04:21:04 | Jessamine, Kentucky, US | |
576254 | 576254 | 2022-02-25 | US | Kentucky | Jessamine | 21113 | 14890 | 128 | 0 | 37.87119786 | -84.58252003 | 2022-02-26 04:21:12 | Jessamine, Kentucky, US | |
3720820 | 3720820 | 2022-02-21 | US | Oregon | Polk | 41053 | 14890 | 118 | 0 | 44.90322804 | -123.4128888 | 2022-02-22 04:21:01 | Polk, Oregon, US | |
3914654 | 3914654 | 2022-02-20 | US | Oregon | Polk | 41053 | 14890 | 118 | 0 | 44.90322804 | -123.4128888 | 2022-02-21 04:21:05 | Polk, Oregon, US | |
3878212 | 3878212 | 2022-02-19 | US | Oregon | Polk | 41053 | 14890 | 118 | 0 | 44.90322804 | -123.4128888 | 2022-02-20 04:21:00 | Polk, Oregon, US | |
3858468 | 3858468 | 2022-02-18 | US | Oregon | Polk | 41053 | 14890 | 118 | 0 | 44.90322804 | -123.4128888 | 2022-02-19 04:21:11 | Polk, Oregon, US | |
2643142 | 2643142 | 2022-02-14 | US | Kentucky | Christian | 21047 | 14890 | 192 | 0 | 36.89267803 | -87.49055367 | 2022-02-15 04:21:09 | Christian, Kentucky, US | |
2013517 | 2013517 | 2022-02-06 | US | Georgia | Gordon | 13129 | 14890 | 232 | 0 | 34.50487351 | -84.87296253 | 2022-02-07 04:21:05 | Gordon, Georgia, US | |
1294846 | 1294846 | 2022-02-05 | US | Georgia | Gordon | 13129 | 14890 | 232 | 0 | 34.50487351 | -84.87296253 | 2022-02-06 04:21:00 | Gordon, Georgia, US | |
2328174 | 2328174 | 2022-02-04 | US | Georgia | Gordon | 13129 | 14890 | 232 | 0 | 34.50487351 | -84.87296253 | 2022-02-05 04:21:05 | Gordon, Georgia, US | |
2327985 | 2327985 | 2022-02-04 | US | Colorado | Garfield | 8045 | 14890 | 90 | 0 | 39.59921777 | -107.902708 | 2022-02-05 04:21:05 | Garfield, Colorado, US | |
981770 | 981770 | 2022-02-01 | US | South Carolina | Georgetown | 45043 | 14890 | 202 | 0 | 33.43443342 | -79.33202141 | 2022-02-02 04:21:09 | Georgetown, South Carolina, US | |
2612709 | 2612709 | 2022-01-06 | US | Pennsylvania | Clearfield | 42033 | 14890 | 265 | 0 | 41.00110782 | -78.47592663 | 2022-01-07 04:22:09 | Clearfield, Pennsylvania, US | |
3796393 | 3796393 | 2021-10-25 | US | Ohio | Muskingum | 39119 | 14890 | 197 | 0 | 39.96575964 | -81.94363275 | 2021-10-26 04:22:09 | Muskingum, Ohio, US | |
685691 | 685691 | 2021-10-24 | US | Virginia | Hampton | 51650 | 14890 | 237 | 0 | 37.03513786 | -76.35879121 | 2021-10-25 04:22:31 | Hampton, Virginia, US | |
773699 | 773699 | 2021-10-23 | US | Virginia | Hampton | 51650 | 14890 | 237 | 0 | 37.03513786 | -76.35879121 | 2021-10-24 04:21:22 | Hampton, Virginia, US | |
657346 | 657346 | 2021-10-22 | US | Virginia | Hampton | 51650 | 14890 | 237 | 0 | 37.03513786 | -76.35879121 | 2021-10-23 04:21:32 | Hampton, Virginia, US | |
3833601 | 3833601 | 2021-10-05 | US | Indiana | Monroe | 18105 | 14890 | 196 | 0 | 39.16130004 | -86.52414358 | 2021-10-06 04:21:33 | Monroe, Indiana, US | |
2696373 | 2696373 | 2021-07-06 | US | Pennsylvania | Monroe | 42089 | 14890 | 321 | 0 | 41.05934058 | -75.34031025 | 2021-07-07 04:21:20 | Monroe, Pennsylvania, US | |
3031037 | 3031037 | 2021-06-16 | US | Georgia | Bartow | 13015 | 14890 | 236 | 0 | 34.23732119 | -84.83887523 | 2021-06-17 04:22:36 | Bartow, Georgia, US | |
2864969 | 2864969 | 2021-01-06 | Russia | Tyva Republic | 14890 | 157 | 13713 | 1020 | 51.4017149 | 93.8582593 | 2021-01-07 05:22:03 | Tyva Republic, Russia | ||
928361 | 928361 | 2020-12-21 | US | Florida | Alachua | 12001 | 14890 | 116 | 0 | 14774 | 29.67866525 | -82.35928158 | 2020-12-22 05:22:33 | Alachua, Florida, US |
3149746 | 3149746 | 2020-12-16 | Peru | Ayacucho | 14890 | 821 | 0 | 14069 | -14.091648 | -74.08344 | 2020-12-17 05:28:12 | Ayacucho, Peru | ||
1034527 | 1034527 | 2020-12-15 | Peru | Ayacucho | 14890 | 821 | 0 | 14069 | -14.091648 | -74.08344 | 2020-12-16 05:28:04 | Ayacucho, Peru | ||
2538988 | 2538988 | 2020-12-01 | US | Massachusetts | Plymouth | 25023 | 14890 | 753 | 0 | 13994 | 41.94070556 | -70.80802823 | 2020-12-02 05:27:41 | Plymouth, Massachusetts, US |
2701727 | 2701727 | 2020-11-20 | Russia | Leningrad Oblast | 14890 | 131 | 9224 | 5535 | 60.1853296 | 32.3925325 | 2020-11-21 05:25:51 | Leningrad Oblast, Russia | ||
967064 | 967064 | 2020-09-29 | Peru | Puno | 14890 | 1296 | 0 | 13594 | -14.995826999999998 | -69.922726 | 2020-09-30 04:23:33 | Puno, Peru | ||
3094905 | 3094905 | 2020-09-20 | US | Louisiana | East Baton Rouge | 22033 | 14890 | 437 | 0 | 14453 | 30.53842039 | -91.09777565 | 2020-09-21 04:23:00 | East Baton Rouge, Louisiana, 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]);