johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
43 rows where active = 3497 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2589970 | 2589970 | 2021-06-27 | India | Tripura | 64863 | 672 | 60694 | 3497 | 23.746783 | 91.743565 | 2021-06-28 04:21:29 | Tripura, India | ||
1712555 | 1712555 | 2021-06-25 | Russia | Nizhny Novgorod Oblast | 123156 | 4091 | 115568 | 3497 | 55.47180329999999 | 44.0911594 | 2021-06-26 04:21:43 | Nizhny Novgorod Oblast, Russia | ||
388408 | 388408 | 2021-04-04 | Russia | Arkhangelsk Oblast | 60019 | 834 | 55688 | 3497 | 63.5589686 | 43.1221646 | 2021-04-05 04:20:35 | Arkhangelsk Oblast, Russia | ||
3670097 | 3670097 | 2021-03-06 | US | Ohio | Logan | 39091 | 3573 | 76 | 0 | 3497 | 40.38996525 | -83.76784341 | 2021-03-07 05:21:54 | Logan, Ohio, US |
2185886 | 2185886 | 2021-02-26 | US | North Carolina | Davie | 37059 | 3525 | 28 | 0 | 3497 | 35.93099927 | -80.54496571 | 2021-02-27 05:22:28 | Davie, North Carolina, US |
281202 | 281202 | 2021-02-24 | US | Illinois | Morgan | 17137 | 3573 | 76 | 0 | 3497 | 39.71654544 | -90.20255104 | 2021-02-25 05:24:57 | Morgan, Illinois, US |
1155479 | 1155479 | 2021-02-18 | US | North Carolina | Stokes | 37169 | 3561 | 64 | 0 | 3497 | 36.4017975 | -80.23893369 | 2021-02-19 05:24:16 | Stokes, North Carolina, US |
1153578 | 1153578 | 2021-02-18 | US | Arkansas | Boone | 5009 | 3574 | 77 | 0 | 3497 | 36.3084504 | -93.09374925 | 2021-02-19 05:24:16 | Boone, Arkansas, US |
1338798 | 1338798 | 2021-02-15 | US | Arkansas | Union | 5139 | 3595 | 98 | 0 | 3497 | 33.16887091 | -92.59746952 | 2021-02-16 05:24:38 | Union, Arkansas, US |
2283910 | 2283910 | 2021-02-14 | US | Arkansas | Independence | 5063 | 3616 | 119 | 0 | 3497 | 35.74242707 | -91.57001641 | 2021-02-15 05:24:49 | Independence, Arkansas, US |
2681068 | 2681068 | 2021-02-13 | US | Texas | Wharton | 48481 | 3609 | 96 | 0 | 3497 | 29.27765923 | -96.22319248 | 2021-02-14 05:23:43 | Wharton, Texas, US |
3540513 | 3540513 | 2021-02-12 | US | Illinois | Woodford | 17203 | 3556 | 59 | 0 | 3497 | 40.78579374 | -89.20973757 | 2021-02-13 05:22:12 | Woodford, Illinois, US |
1530214 | 1530214 | 2021-02-09 | US | North Carolina | Haywood | 37087 | 3578 | 81 | 0 | 3497 | 35.55269063 | -82.98196486 | 2021-02-10 05:22:41 | Haywood, North Carolina, US |
790731 | 790731 | 2021-02-04 | US | Alabama | Chilton | 1021 | 3579 | 82 | 0 | 3497 | 32.85044126 | -86.7173256 | 2021-02-05 05:22:38 | Chilton, Alabama, US |
1685960 | 1685960 | 2021-02-02 | US | Kentucky | Scott | 21209 | 3521 | 24 | 0 | 3497 | 38.29622293 | -84.5816631 | 2021-02-03 05:22:52 | Scott, Kentucky, US |
2567862 | 2567862 | 2021-01-25 | Russia | Ivanovo Oblast | 25736 | 704 | 21535 | 3497 | 56.9167446 | 41.43521370000001 | 2021-01-26 05:22:02 | Ivanovo Oblast, Russia | ||
1762657 | 1762657 | 2021-01-24 | US | Virginia | Manassas | 51683 | 3529 | 32 | 0 | 3497 | 38.7464321 | -77.48509905 | 2021-01-25 05:22:16 | Manassas, Virginia, US |
2429821 | 2429821 | 2021-01-23 | US | Tennessee | Cocke | 47029 | 3580 | 60 | 0 | 3497 | 35.9278914 | -83.11828725 | 2021-01-24 05:22:35 | Cocke, Tennessee, US |
2867182 | 2867182 | 2021-01-06 | US | Ohio | Huron | 39077 | 3582 | 85 | 0 | 3497 | 41.14651175 | -82.59867951 | 2021-01-07 05:22:03 | Huron, Ohio, US |
3697704 | 3697704 | 2020-12-31 | US | New York | Chautauqua | 36013 | 3518 | 21 | 0 | 3497 | 42.22769210000001 | -79.36691763 | 2021-01-01 05:23:07 | Chautauqua, New York, US |
2223705 | 2223705 | 2020-12-26 | Russia | Irkutsk Oblast | 39202 | 1169 | 34536 | 3497 | 56.6370122 | 104.719221 | 2020-12-27 05:22:55 | Irkutsk Oblast, Russia | ||
928551 | 928551 | 2020-12-21 | US | Georgia | Rockdale | 13247 | 3571 | 74 | 0 | 3497 | 33.65145002 | -84.02202167 | 2020-12-22 05:22:33 | Rockdale, Georgia, US |
2119958 | 2119958 | 2020-12-20 | Russia | Smolensk Oblast | 15298 | 307 | 11494 | 3497 | 55.03434960000001 | 33.0192065 | 2020-12-21 05:27:58 | Smolensk Oblast, Russia | ||
3149789 | 3149789 | 2020-12-16 | Russia | Irkutsk Oblast | 36464 | 1009 | 31958 | 3497 | 56.6370122 | 104.719221 | 2020-12-17 05:28:12 | Irkutsk Oblast, Russia | ||
1753203 | 1753203 | 2020-12-14 | US | Missouri | Pettis | 29159 | 3535 | 38 | 0 | 3497 | 38.72798918 | -93.28471706 | 2020-12-15 05:26:38 | Pettis, Missouri, US |
3849476 | 3849476 | 2020-12-13 | US | Minnesota | Benton | 27009 | 3562 | 65 | 0 | 3497 | 45.69804958 | -93.99514135 | 2020-12-14 05:26:27 | Benton, Minnesota, US |
3848313 | 3848313 | 2020-12-13 | US | Arkansas | White | 5145 | 3560 | 63 | 0 | 3497 | 35.25688493 | -91.74908296 | 2020-12-14 05:26:27 | White, Arkansas, US |
1587585 | 1587585 | 2020-11-30 | US | Washington | Chelan | 53007 | 3525 | 28 | 0 | 3497 | 47.87046092 | -120.6173956 | 2020-12-01 05:26:18 | Chelan, Washington, US |
924923 | 924923 | 2020-11-26 | US | Iowa | Webster | 19187 | 3530 | 33 | 0 | 3497 | 42.42853483 | -94.17987389 | 2020-11-27 05:26:53 | Webster, Iowa, US |
3409303 | 3409303 | 2020-11-01 | Colombia | Santander | 42806 | 1700 | 37609 | 3497 | 6.6437 | -73.6536 | 2020-11-02 05:25:04 | Santander, Colombia | ||
1029316 | 1029316 | 2020-10-17 | US | Tennessee | Out of TN | 80047 | 2546 | 34 | 0 | 3497 | 36.55606529 | 0.0 | 2020-10-18 04:24:25 | Out of TN, Tennessee, US |
2813310 | 2813310 | 2020-09-25 | US | California | San Luis Obispo | 6079 | 3529 | 31 | 0 | 3497 | 35.38822029 | -120.4039028 | 2020-09-26 04:23:00 | San Luis Obispo, California, US |
1174972 | 1174972 | 2020-09-10 | US | Mississippi | Harrison | 28047 | 3563 | 66 | 0 | 3497 | 30.51359752 | -89.12467576 | 2020-09-11 04:46:23 | Harrison, Mississippi, US |
430620 | 430620 | 2020-09-07 | US | Virginia | Arlington | 51013 | 3640 | 143 | 0 | 3497 | 38.8767675 | -77.10139853 | 2020-09-08 04:28:25 | Arlington, Virginia, US |
3922866 | 3922866 | 2020-08-09 | US | Georgia | Whitfield | 13313 | 3527 | 30 | 0 | 3497 | 34.80987459 | -84.96093476 | 2020-08-10 04:34:55 | Whitfield, Georgia, US |
3922405 | 3922405 | 2020-08-09 | US | California | Sonoma | 6097 | 3539 | 41 | 0 | 3497 | 38.52746429 | -122.8862506 | 2020-08-10 04:34:55 | Sonoma, California, US |
2564005 | 2564005 | 2020-07-24 | Russia | Volgograd Oblast | 8517 | 57 | 4963 | 3497 | 49.604833899999996 | 44.29035820000001 | 2020-07-25 04:47:39 | Volgograd Oblast, Russia | ||
3489136 | 3489136 | 2020-07-13 | US | Tennessee | Hamilton | 47065 | 3439 | 38 | 0 | 3497 | 35.17670231 | -85.16652245 | 2020-07-14 04:34:46 | Hamilton, Tennessee, US |
2681855 | 2681855 | 2020-07-06 | US | Louisiana | Caddo | 22017 | 3740 | 243 | 0 | 3497 | 32.57991587 | -93.88375652 | 2020-07-07 04:34:00 | Caddo, Louisiana, US |
415629 | 415629 | 2020-07-05 | Algeria | 15941 | 952 | 11492 | 3497 | 28.0339 | 1.6596 | 2020-07-06 04:33:57 | Algeria | |||
2698752 | 2698752 | 2020-06-24 | US | Kentucky | Jefferson | 21111 | 3682 | 185 | 0 | 3497 | 38.18664655 | -85.65931031 | 2020-06-25 05:26:54 | Jefferson, Kentucky, US |
996847 | 996847 | 2020-05-23 | US | Iowa | Polk | 19153 | 3603 | 106 | 0 | 3497 | 41.68679484 | -93.57767461 | 2020-05-24 02:32:43 | Polk, Iowa, US |
1829470 | 1829470 | 2020-05-16 | Germany | Bayern | 45340 | 2273 | 39880 | 3497 | 48.7904 | 11.4979 | 2020-05-17 02:32:32 | Bayern, Germany |
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]);