johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
43 rows where active = 4188 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 12
- US 30
- Colombia 2
- Ukraine 2
- Canada 1
- El Salvador 1
- Germany 1
- India 1
- Jamaica 1
- Netherlands 1
- Russia 1
- Sudan 1
- West Bank and Gaza 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3385041 | 3385041 | 2021-06-13 | West Bank and Gaza | 311534 | 3533 | 303813 | 4188 | 31.9522 | 35.2332 | 2021-06-14 04:22:46 | West Bank and Gaza | |||
3923926 | 3923926 | 2021-04-24 | Germany | Mecklenburg-Vorpommern | 38243 | 962 | 33380 | 4188 | 53.6127 | 12.4296 | 2021-04-25 04:20:32 | Mecklenburg-Vorpommern, Germany | ||
2571983 | 2571983 | 2021-04-13 | Sudan | 31833 | 2194 | 25451 | 4188 | 12.8628 | 30.2176 | 2021-04-14 04:20:41 | Sudan | |||
999350 | 999350 | 2021-03-01 | US | Idaho | Bingham | 16011 | 4251 | 63 | 0 | 4188 | 43.21672879999999 | -112.3978437 | 2021-03-02 05:23:30 | Bingham, Idaho, US |
1861536 | 1861536 | 2021-02-25 | US | Wisconsin | Douglas | 55031 | 4228 | 40 | 0 | 4188 | 46.43222285 | -91.91595768 | 2021-02-26 05:22:40 | Douglas, Wisconsin, US |
2287062 | 2287062 | 2021-02-14 | Ukraine | Vinnytsia Oblast | 29977 | 574 | 25215 | 4188 | 49.2331 | 28.4682 | 2021-02-15 05:24:49 | Vinnytsia Oblast, Ukraine | ||
2680795 | 2680795 | 2021-02-13 | US | Tennessee | Obion | 47131 | 4334 | 91 | 0 | 4188 | 36.35732446 | -89.14921589 | 2021-02-14 05:23:43 | Obion, Tennessee, US |
3980883 | 3980883 | 2021-02-10 | US | North Carolina | Edgecombe | 37065 | 4280 | 92 | 0 | 4188 | 35.91230639 | -77.59436892 | 2021-02-11 05:23:55 | Edgecombe, North Carolina, US |
3979564 | 3979564 | 2021-02-10 | US | Illinois | Henry | 17073 | 4241 | 53 | 0 | 4188 | 41.3533994 | -90.13296166 | 2021-02-11 05:23:55 | Henry, Illinois, US |
617251 | 617251 | 2021-02-08 | US | Wisconsin | Pierce | 55093 | 4227 | 39 | 0 | 4188 | 44.71850291 | -92.4224416 | 2021-02-09 05:23:30 | Pierce, Wisconsin, US |
1676020 | 1676020 | 2021-02-07 | US | Wisconsin | Pierce | 55093 | 4227 | 39 | 0 | 4188 | 44.71850291 | -92.4224416 | 2021-02-08 05:22:39 | Pierce, Wisconsin, US |
792614 | 792614 | 2021-02-04 | US | New York | Herkimer | 36043 | 4282 | 94 | 0 | 4188 | 43.42034246 | -74.96145307 | 2021-02-05 05:22:38 | Herkimer, New York, US |
2484406 | 2484406 | 2021-01-28 | US | Ohio | Belmont | 39013 | 4335 | 147 | 0 | 4188 | 40.01625942 | -80.9924051 | 2021-01-29 05:22:23 | Belmont, Ohio, US |
3155475 | 3155475 | 2021-01-27 | US | Missouri | Callaway | 29027 | 4222 | 34 | 0 | 4188 | 38.83674754 | -91.92186505 | 2021-01-28 05:22:24 | Callaway, Missouri, US |
435215 | 435215 | 2021-01-21 | Colombia | Santander | 79328 | 2741 | 72399 | 4188 | 6.6437 | -73.6536 | 2021-01-22 05:22:10 | Santander, Colombia | ||
776643 | 776643 | 2021-01-12 | US | North Carolina | Columbus | 37047 | 4278 | 90 | 0 | 4188 | 34.26744084 | -78.65801424 | 2021-01-13 05:22:15 | Columbus, North Carolina, US |
3900156 | 3900156 | 2021-01-09 | Russia | Irkutsk Oblast | 42908 | 1326 | 37394 | 4188 | 56.6370122 | 104.719221 | 2021-01-10 05:22:12 | Irkutsk Oblast, Russia | ||
3697740 | 3697740 | 2020-12-31 | US | New York | Rensselaer | 36083 | 4269 | 81 | 0 | 4188 | 42.71348136 | -73.51089874 | 2021-01-01 05:23:07 | Rensselaer, New York, US |
1013644 | 1013644 | 2020-12-30 | US | Virginia | Hampton | 51650 | 4236 | 48 | 0 | 4188 | 37.03513786 | -76.35879121 | 2020-12-31 05:22:49 | Hampton, Virginia, US |
768818 | 768818 | 2020-12-29 | US | Ohio | Ross | 39141 | 4287 | 99 | 0 | 4188 | 39.33705391 | -83.06000914 | 2020-12-30 05:22:34 | Ross, Ohio, US |
3763941 | 3763941 | 2020-12-28 | US | North Carolina | Surry | 37171 | 4251 | 63 | 0 | 4188 | 36.41689489 | -80.69102283 | 2020-12-29 05:22:37 | Surry, North Carolina, US |
2226460 | 2226460 | 2020-12-26 | US | Tennessee | Lawrence | 47099 | 4241 | 55 | 0 | 4188 | 35.21675201 | -87.39787695 | 2020-12-27 05:22:55 | Lawrence, Tennessee, US |
3693938 | 3693938 | 2020-12-24 | US | Ohio | Hancock | 39063 | 4276 | 88 | 0 | 4188 | 41.00250487 | -83.66838948 | 2020-12-25 05:22:48 | Hancock, Ohio, US |
3153164 | 3153164 | 2020-12-16 | US | Wisconsin | Shawano | 55115 | 4248 | 60 | 0 | 4188 | 44.78902246 | -88.76443896 | 2020-12-17 05:28:12 | Shawano, Wisconsin, US |
1037943 | 1037943 | 2020-12-15 | US | Wisconsin | Sauk | 55111 | 4213 | 25 | 0 | 4188 | 43.42574087 | -89.94966132 | 2020-12-16 05:28:04 | Sauk, Wisconsin, US |
3847567 | 3847567 | 2020-12-13 | Canada | Saskatchewan | 11969 | 89 | 7694 | 4188 | 52.9399 | -106.4509 | 2020-12-14 05:26:27 | Saskatchewan, Canada | ||
1603678 | 1603678 | 2020-12-10 | US | West Virginia | Berkeley | 54003 | 4224 | 36 | 0 | 4188 | 39.46704621 | -78.02414609 | 2020-12-11 05:26:59 | Berkeley, West Virginia, US |
1820262 | 1820262 | 2020-12-08 | US | Louisiana | Acadia | 22001 | 4307 | 119 | 0 | 4188 | 30.2950649 | -92.41419698 | 2020-12-09 05:28:01 | Acadia, Louisiana, US |
2537394 | 2537394 | 2020-12-01 | Jamaica | 10810 | 258 | 6364 | 4188 | 18.1096 | -77.2975 | 2020-12-02 05:27:41 | Jamaica | |||
393840 | 393840 | 2020-11-27 | US | Michigan | Bay | 26017 | 4277 | 89 | 0 | 4188 | 43.70639106 | -83.98731479 | 2020-11-28 05:25:50 | Bay, Michigan, US |
680844 | 680844 | 2020-11-23 | US | Oklahoma | Comanche | 40031 | 4218 | 30 | 0 | 4188 | 34.65973764 | -98.47195055 | 2020-11-24 05:27:31 | Comanche, Oklahoma, US |
2703400 | 2703400 | 2020-11-20 | US | Missouri | Franklin | 29071 | 4247 | 59 | 0 | 4188 | 38.41127108 | -91.07522826 | 2020-11-21 05:25:51 | Franklin, Missouri, US |
2881268 | 2881268 | 2020-11-15 | US | Indiana | Clark | 18019 | 4263 | 75 | 0 | 4188 | 38.48015445 | -85.70510334 | 2020-11-16 05:25:57 | Clark, Indiana, US |
3442384 | 3442384 | 2020-11-11 | US | Maryland | Harford | 24025 | 4272 | 84 | 0 | 4188 | 39.55010644 | -76.30775940000002 | 2020-11-12 05:25:55 | Harford, Maryland, US |
3992243 | 3992243 | 2020-10-20 | US | Michigan | Kalamazoo | 26077 | 4290 | 102 | 0 | 4188 | 42.24542231 | -85.53038622 | 2020-10-21 04:24:14 | Kalamazoo, Michigan, US |
79033 | 79033 | 2020-10-14 | India | Goa | 39438 | 519 | 34731 | 4188 | 15.359682 | 74.057396 | 2020-10-15 04:24:28 | Goa, India | ||
2605641 | 2605641 | 2020-10-10 | Ukraine | Chernihiv Oblast | 5425 | 87 | 1150 | 4188 | 51.4982 | 31.2893 | 2020-10-11 04:23:46 | Chernihiv Oblast, Ukraine | ||
2601919 | 2601919 | 2020-10-10 | El Salvador | 30070 | 887 | 24995 | 4188 | 13.7942 | -88.8965 | 2020-10-11 04:23:46 | El Salvador | |||
585644 | 585644 | 2020-08-13 | US | South Carolina | Spartanburg | 45083 | 4299 | 111 | 0 | 4188 | 34.92960077 | -81.99225984 | 2020-08-14 04:51:19 | Spartanburg, South Carolina, US |
98319 | 98319 | 2020-08-04 | Netherlands | Limburg | 4960 | 757 | 0 | 4188 | 51.209227 | 5.93387 | 2020-08-05 04:34:43 | Limburg, Netherlands | ||
844393 | 844393 | 2020-07-22 | US | Texas | Webb | 48479 | 2926 | 88 | 0 | 4188 | 27.7610369 | -99.33237355 | 2020-07-23 05:15:04 | Webb, Texas, US |
2974261 | 2974261 | 2020-06-30 | Colombia | Bolivar | 8949 | 365 | 4396 | 4188 | 8.6704 | -74.03 | 2020-07-01 04:33:52 | Bolivar, Colombia | ||
3082232 | 3082232 | 2020-05-04 | US | Nevada | Clark | 32003 | 4411 | 223 | 0 | 4188 | 36.21458855 | -115.0130241 | 2020-05-05 02:32:34 | Clark, Nevada, 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]);