johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
51 rows where confirmed = 10749 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3380306 | 3380306 | 2022-12-08 | US | Tennessee | Claiborne | 47025 | 10749 | 206 | 0 | 36.48319149 | -83.65947309 | 2022-12-09 04:21:05 | Claiborne, Tennessee, US | |
3747851 | 3747851 | 2022-09-07 | US | Puerto Rico | Dorado | 72051 | 10749 | 0 | 0 | 18.436115 | -66.278669 | 2022-09-08 04:21:02 | Dorado, Puerto Rico, US | |
3943479 | 3943479 | 2022-06-30 | US | Virginia | Tazewell | 51185 | 10749 | 177 | 0 | 37.12191123 | -81.56685568 | 2022-07-01 04:21:10 | Tazewell, Virginia, US | |
3161067 | 3161067 | 2022-06-09 | US | Virginia | York | 51199 | 10749 | 109 | 0 | 37.24374789 | -76.54412815 | 2022-06-10 04:20:55 | York, Virginia, US | |
3186978 | 3186978 | 2022-05-30 | US | Illinois | Effingham | 17049 | 10749 | 139 | 0 | 39.05935711 | -88.58969584 | 2022-05-31 04:20:51 | Effingham, Illinois, US | |
3199127 | 3199127 | 2022-05-29 | US | Illinois | Effingham | 17049 | 10749 | 139 | 0 | 39.05935711 | -88.58969584 | 2022-05-30 04:20:50 | Effingham, Illinois, US | |
2726005 | 2726005 | 2022-05-28 | US | Illinois | Effingham | 17049 | 10749 | 139 | 0 | 39.05935711 | -88.58969584 | 2022-05-29 04:20:53 | Effingham, Illinois, US | |
1315186 | 1315186 | 2022-05-27 | US | Illinois | Effingham | 17049 | 10749 | 139 | 0 | 39.05935711 | -88.58969584 | 2022-05-28 04:21:07 | Effingham, Illinois, US | |
2085349 | 2085349 | 2022-05-15 | US | Kentucky | Clark | 21049 | 10749 | 68 | 0 | 37.9689263 | -84.14615986 | 2022-05-16 04:20:47 | Clark, Kentucky, US | |
3356059 | 3356059 | 2022-05-14 | US | Kentucky | Clark | 21049 | 10749 | 68 | 0 | 37.9689263 | -84.14615986 | 2022-05-15 04:20:53 | Clark, Kentucky, US | |
659704 | 659704 | 2022-05-13 | US | Kentucky | Clark | 21049 | 10749 | 68 | 0 | 37.9689263 | -84.14615986 | 2022-05-14 04:20:48 | Clark, Kentucky, US | |
2534787 | 2534787 | 2022-05-12 | US | Kentucky | Clark | 21049 | 10749 | 68 | 0 | 37.9689263 | -84.14615986 | 2022-05-13 04:20:51 | Clark, Kentucky, US | |
3446233 | 3446233 | 2022-05-11 | US | Kentucky | Clark | 21049 | 10749 | 68 | 0 | 37.9689263 | -84.14615986 | 2022-05-12 04:20:54 | Clark, Kentucky, US | |
3536850 | 3536850 | 2022-05-10 | US | Kentucky | Clark | 21049 | 10749 | 68 | 0 | 37.9689263 | -84.14615986 | 2022-05-11 04:20:48 | Clark, Kentucky, US | |
223385 | 223385 | 2022-05-09 | US | Kentucky | Clark | 21049 | 10749 | 68 | 0 | 37.9689263 | -84.14615986 | 2022-05-10 04:20:50 | Clark, Kentucky, US | |
1469739 | 1469739 | 2022-03-24 | US | Michigan | Gratiot | 26057 | 10749 | 178 | 0 | 43.29265605 | -84.60505416 | 2022-03-25 04:20:46 | Gratiot, Michigan, US | |
3023913 | 3023913 | 2022-03-23 | US | Michigan | Gratiot | 26057 | 10749 | 178 | 0 | 43.29265605 | -84.60505416 | 2022-03-24 04:20:43 | Gratiot, Michigan, US | |
2449358 | 2449358 | 2022-02-22 | US | Oklahoma | Osage | 40113 | 10749 | 152 | 0 | 36.62888819 | -96.39635704 | 2022-02-23 04:21:09 | Osage, Oklahoma, US | |
3720771 | 3720771 | 2022-02-21 | US | Oklahoma | Osage | 40113 | 10749 | 152 | 0 | 36.62888819 | -96.39635704 | 2022-02-22 04:21:01 | Osage, Oklahoma, US | |
3914605 | 3914605 | 2022-02-20 | US | Oklahoma | Osage | 40113 | 10749 | 152 | 0 | 36.62888819 | -96.39635704 | 2022-02-21 04:21:05 | Osage, Oklahoma, US | |
3878163 | 3878163 | 2022-02-19 | US | Oklahoma | Osage | 40113 | 10749 | 152 | 0 | 36.62888819 | -96.39635704 | 2022-02-20 04:21:00 | Osage, Oklahoma, US | |
3858419 | 3858419 | 2022-02-18 | US | Oklahoma | Osage | 40113 | 10749 | 152 | 0 | 36.62888819 | -96.39635704 | 2022-02-19 04:21:11 | Osage, Oklahoma, US | |
1300638 | 1300638 | 2022-02-17 | US | Oklahoma | Osage | 40113 | 10749 | 152 | 0 | 36.62888819 | -96.39635704 | 2022-02-18 04:21:04 | Osage, Oklahoma, US | |
3823024 | 3823024 | 2022-02-16 | US | Oklahoma | Osage | 40113 | 10749 | 152 | 0 | 36.62888819 | -96.39635704 | 2022-02-17 04:20:56 | Osage, Oklahoma, US | |
187902 | 187902 | 2022-02-13 | US | Mississippi | Monroe | 28095 | 10749 | 204 | 0 | 33.89236763 | -88.4808438 | 2022-02-14 04:20:51 | Monroe, Mississippi, US | |
317748 | 317748 | 2022-02-12 | US | Mississippi | Monroe | 28095 | 10749 | 204 | 0 | 33.89236763 | -88.4808438 | 2022-02-13 04:21:00 | Monroe, Mississippi, US | |
235074 | 235074 | 2022-02-11 | US | Mississippi | Monroe | 28095 | 10749 | 204 | 0 | 33.89236763 | -88.4808438 | 2022-02-12 04:21:06 | Monroe, Mississippi, US | |
1467009 | 1467009 | 2022-02-10 | US | Tennessee | Cheatham | 47021 | 10749 | 108 | 0 | 36.26136216 | -87.08903581 | 2022-02-11 04:21:09 | Cheatham, Tennessee, US | |
127093 | 127093 | 2022-01-09 | US | Alabama | Colbert | 1033 | 10749 | 217 | 0 | 34.69847452 | -87.80168544 | 2022-01-10 04:22:07 | Colbert, Alabama, US | |
2611422 | 2611422 | 2022-01-06 | US | Kentucky | Boyd | 21019 | 10749 | 131 | 0 | 38.36176608 | -82.68652187 | 2022-01-07 04:22:09 | Boyd, Kentucky, US | |
3345550 | 3345550 | 2021-11-16 | US | Tennessee | Coffee | 47031 | 10749 | 162 | 0 | 35.49090731 | -86.07311784 | 2021-11-17 04:21:48 | Coffee, Tennessee, US | |
3343930 | 3343930 | 2021-11-16 | US | Kansas | Leavenworth | 20103 | 10749 | 134 | 0 | 39.20183497 | -95.03620809 | 2021-11-17 04:21:48 | Leavenworth, Kansas, US | |
2288766 | 2288766 | 2021-11-15 | US | Kansas | Leavenworth | 20103 | 10749 | 134 | 0 | 39.20183497 | -95.03620809 | 2021-11-16 04:21:10 | Leavenworth, Kansas, US | |
446888 | 446888 | 2021-10-20 | US | Wisconsin | Chippewa | 55017 | 10749 | 115 | 0 | 45.06939744 | -91.28068855 | 2021-10-21 04:21:18 | Chippewa, Wisconsin, US | |
2132430 | 2132430 | 2021-10-01 | US | Alabama | Walker | 1127 | 10749 | 340 | 0 | 33.80270512 | -87.30027177 | 2021-10-02 04:21:25 | Walker, Alabama, US | |
2281883 | 2281883 | 2021-09-08 | US | Puerto Rico | Carolina | 72031 | 10749 | 0 | 0 | 18.374986 | -65.95683100000001 | 2021-09-09 04:21:27 | Carolina, Puerto Rico, US | |
1443930 | 1443930 | 2021-07-07 | US | Virginia | Hampton | 51650 | 10749 | 182 | 0 | 37.03513786 | -76.35879121 | 2021-07-08 04:21:26 | Hampton, Virginia, US | |
2339474 | 2339474 | 2021-06-15 | Mexico | Campeche | 10749 | 1245 | 0 | 9504 | 19.8301 | -90.5349 | 2021-06-16 04:22:32 | Campeche, Mexico | ||
2718506 | 2718506 | 2021-06-10 | US | Louisiana | Terrebonne | 22109 | 10749 | 225 | 0 | 29.37343766 | -90.82626855 | 2021-06-11 04:23:20 | Terrebonne, Louisiana, US | |
827478 | 827478 | 2021-06-06 | US | Missouri | Franklin | 29071 | 10749 | 185 | 0 | 38.41127108 | -91.07522826 | 2021-06-07 04:22:51 | Franklin, Missouri, US | |
2317197 | 2317197 | 2021-06-04 | US | Missouri | Franklin | 29071 | 10749 | 185 | 0 | 38.41127108 | -91.07522826 | 2021-06-05 04:23:03 | Franklin, Missouri, US | |
3113544 | 3113544 | 2021-05-06 | Lesotho | 10749 | 319 | 6427 | 4003 | -29.61 | 28.2336 | 2021-05-07 04:20:40 | Lesotho | |||
646011 | 646011 | 2021-05-05 | Lesotho | 10749 | 319 | 6267 | 4163 | -29.61 | 28.2336 | 2021-05-06 04:20:38 | Lesotho | |||
1980698 | 1980698 | 2021-03-25 | Mexico | Colima | 10749 | 1132 | 0 | 9617 | 19.1223 | -104.0072 | 2021-03-26 05:26:55 | Colima, Mexico | ||
2678823 | 2678823 | 2021-02-13 | US | Illinois | Kendall | 17093 | 10749 | 81 | 0 | 10668 | 41.59081014 | -88.42869583 | 2021-02-14 05:23:43 | Kendall, Illinois, US |
239074 | 239074 | 2021-01-18 | US | Mississippi | Rankin | 28121 | 10749 | 211 | 0 | 10538 | 32.26469147 | -89.94537876 | 2021-01-19 05:22:15 | Rankin, Mississippi, US |
238052 | 238052 | 2021-01-18 | US | Georgia | Houston | 13153 | 10749 | 152 | 0 | 10597 | 32.45802497 | -83.66879087 | 2021-01-19 05:22:15 | Houston, Georgia, US |
1035184 | 1035184 | 2020-12-15 | US | Georgia | Henry | 13151 | 10749 | 146 | 0 | 10603 | 33.4533428 | -84.14814659999998 | 2020-12-16 05:28:04 | Henry, Georgia, US |
1584385 | 1584385 | 2020-11-30 | Russia | Mordovia Republic | 10749 | 64 | 8802 | 1883 | 54.4419829 | 44.4661144 | 2020-12-01 05:26:18 | Mordovia Republic, Russia | ||
3172882 | 3172882 | 2020-11-16 | US | Texas | Williamson | 48491 | 10749 | 160 | 0 | 11743 | 30.64655664 | -97.6004854 | 2020-11-17 05:25:54 | Williamson, Texas, US |
1041899 | 1041899 | 2020-10-07 | Mexico | Baja California Sur | 10749 | 502 | 9524 | 723 | 26.0444 | -111.6661 | 2020-10-08 04:23:56 | Baja California Sur, Mexico |
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]);