johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
73 rows where confirmed = 6839 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3041113 | 3041113 | 2022-10-27 | US | Puerto Rico | Salinas | 72123 | 6839 | 0 | 0 | 18.010387 | -66.256592 | 2022-10-28 04:22:31 | Salinas, Puerto Rico, US | |
253784 | 253784 | 2022-09-08 | US | Arkansas | Carroll | 5015 | 6839 | 115 | 0 | 36.3403856 | -93.54270261 | 2022-09-09 04:21:11 | Carroll, Arkansas, US | |
3776177 | 3776177 | 2022-08-30 | US | New York | Seneca | 36099 | 6839 | 94 | 0 | 42.78081007 | -76.82497064 | 2022-08-31 04:20:57 | Seneca, New York, US | |
1253047 | 1253047 | 2022-08-23 | US | North Carolina | Ashe | 37009 | 6839 | 85 | 0 | 36.43296207 | -81.49862729 | 2022-08-24 04:20:46 | Ashe, North Carolina, US | |
2856277 | 2856277 | 2022-08-22 | US | Virginia | Staunton | 51790 | 6839 | 122 | 0 | 38.15965544 | -79.05979937 | 2022-08-23 04:20:56 | Staunton, Virginia, US | |
2855151 | 2855151 | 2022-08-22 | US | North Carolina | Ashe | 37009 | 6839 | 85 | 0 | 36.43296207 | -81.49862729 | 2022-08-23 04:20:56 | Ashe, North Carolina, US | |
2854717 | 2854717 | 2022-08-22 | US | Mississippi | Tishomingo | 28141 | 6839 | 122 | 0 | 34.74023475 | -88.23917219 | 2022-08-23 04:20:56 | Tishomingo, Mississippi, US | |
2405123 | 2405123 | 2022-08-21 | US | North Carolina | Ashe | 37009 | 6839 | 85 | 0 | 36.43296207 | -81.49862729 | 2022-08-22 04:20:38 | Ashe, North Carolina, US | |
2404689 | 2404689 | 2022-08-21 | US | Mississippi | Tishomingo | 28141 | 6839 | 122 | 0 | 34.74023475 | -88.23917219 | 2022-08-22 04:20:38 | Tishomingo, Mississippi, US | |
3800201 | 3800201 | 2022-08-20 | US | North Carolina | Ashe | 37009 | 6839 | 85 | 0 | 36.43296207 | -81.49862729 | 2022-08-21 04:20:44 | Ashe, North Carolina, US | |
3799767 | 3799767 | 2022-08-20 | US | Mississippi | Tishomingo | 28141 | 6839 | 122 | 0 | 34.74023475 | -88.23917219 | 2022-08-21 04:20:44 | Tishomingo, Mississippi, US | |
2365787 | 2365787 | 2022-08-19 | US | North Carolina | Ashe | 37009 | 6839 | 85 | 0 | 36.43296207 | -81.49862729 | 2022-08-20 04:21:01 | Ashe, North Carolina, US | |
2365353 | 2365353 | 2022-08-19 | US | Mississippi | Tishomingo | 28141 | 6839 | 122 | 0 | 34.74023475 | -88.23917219 | 2022-08-20 04:21:01 | Tishomingo, Mississippi, US | |
1163458 | 1163458 | 2022-08-18 | US | North Carolina | Ashe | 37009 | 6839 | 85 | 0 | 36.43296207 | -81.49862729 | 2022-08-19 04:20:54 | Ashe, North Carolina, US | |
1163024 | 1163024 | 2022-08-18 | US | Mississippi | Tishomingo | 28141 | 6839 | 122 | 0 | 34.74023475 | -88.23917219 | 2022-08-19 04:20:54 | Tishomingo, Mississippi, US | |
3952782 | 3952782 | 2022-08-17 | US | North Carolina | Ashe | 37009 | 6839 | 85 | 0 | 36.43296207 | -81.49862729 | 2022-08-18 04:21:11 | Ashe, North Carolina, US | |
3952348 | 3952348 | 2022-08-17 | US | Mississippi | Tishomingo | 28141 | 6839 | 122 | 0 | 34.74023475 | -88.23917219 | 2022-08-18 04:21:11 | Tishomingo, Mississippi, US | |
992850 | 992850 | 2022-08-16 | US | Mississippi | Tishomingo | 28141 | 6839 | 122 | 0 | 34.74023475 | -88.23917219 | 2022-08-17 04:20:59 | Tishomingo, Mississippi, US | |
2495889 | 2495889 | 2022-08-15 | US | Mississippi | Tishomingo | 28141 | 6839 | 122 | 0 | 34.74023475 | -88.23917219 | 2022-08-16 04:20:58 | Tishomingo, Mississippi, US | |
3872718 | 3872718 | 2022-07-31 | US | Indiana | Wells | 18179 | 6839 | 134 | 0 | 40.72934187 | -85.22132966 | 2022-08-01 04:21:03 | Wells, Indiana, US | |
675472 | 675472 | 2022-07-30 | US | Indiana | Wells | 18179 | 6839 | 134 | 0 | 40.72934187 | -85.22132966 | 2022-07-31 04:21:02 | Wells, Indiana, US | |
1784671 | 1784671 | 2022-07-29 | US | Indiana | Wells | 18179 | 6839 | 134 | 0 | 40.72934187 | -85.22132966 | 2022-07-30 04:20:42 | Wells, Indiana, US | |
1213112 | 1213112 | 2022-07-11 | US | Maine | Knox | 23013 | 6839 | 40 | 0 | 44.11486325 | -69.10529169 | 2022-07-12 04:20:51 | Knox, Maine, US | |
2790594 | 2790594 | 2022-07-10 | US | Maine | Knox | 23013 | 6839 | 40 | 0 | 44.11486325 | -69.10529169 | 2022-07-11 04:20:46 | Knox, Maine, US | |
143547 | 143547 | 2022-07-09 | US | Maine | Knox | 23013 | 6839 | 40 | 0 | 44.11486325 | -69.10529169 | 2022-07-10 04:20:54 | Knox, Maine, US | |
2536131 | 2536131 | 2022-05-12 | US | Puerto Rico | Cidra | 72041 | 6839 | 0 | 0 | 18.173559 | -66.161179 | 2022-05-13 04:20:51 | Cidra, Puerto Rico, US | |
1329541 | 1329541 | 2022-04-26 | US | Vermont | Windham | 50025 | 6839 | 35 | 0 | 42.986982 | -72.71268875 | 2022-04-27 04:20:52 | Windham, Vermont, US | |
3725721 | 3725721 | 2022-04-25 | US | West Virginia | Upshur | 54097 | 6839 | 95 | 0 | 38.89285061 | -80.23689136 | 2022-04-26 04:20:51 | Upshur, West Virginia, US | |
3725495 | 3725495 | 2022-04-25 | US | Vermont | Windham | 50025 | 6839 | 35 | 0 | 42.986982 | -72.71268875 | 2022-04-26 04:20:51 | Windham, Vermont, US | |
3420326 | 3420326 | 2022-04-17 | US | Virginia | Russell | 51167 | 6839 | 111 | 0 | 36.93028320000001 | -82.10095486 | 2022-04-18 04:21:12 | Russell, Virginia, US | |
307275 | 307275 | 2022-04-16 | US | Virginia | Russell | 51167 | 6839 | 111 | 0 | 36.93028320000001 | -82.10095486 | 2022-04-17 04:20:59 | Russell, Virginia, US | |
2673220 | 2673220 | 2022-04-15 | US | Virginia | Russell | 51167 | 6839 | 111 | 0 | 36.93028320000001 | -82.10095486 | 2022-04-16 04:20:48 | Russell, Virginia, US | |
3321839 | 3321839 | 2022-04-07 | US | Massachusetts | Dukes and Nantucket | 6839 | 16 | 0 | 41.40674725 | -70.68763497 | 2022-04-08 04:20:48 | Dukes and Nantucket, Massachusetts, US | ||
1439538 | 1439538 | 2022-03-28 | US | Tennessee | Hickman | 47081 | 6839 | 108 | 0 | 35.80609681 | -87.47643507 | 2022-03-29 04:20:46 | Hickman, Tennessee, US | |
3023431 | 3023431 | 2022-03-23 | US | Indiana | White | 18181 | 6839 | 91 | 0 | 40.74911165 | -86.86492015 | 2022-03-24 04:20:43 | White, Indiana, US | |
3023063 | 3023063 | 2022-03-23 | US | Georgia | Dawson | 13085 | 6839 | 99 | 0 | 34.44244079 | -84.16964071 | 2022-03-24 04:20:43 | Dawson, Georgia, US | |
2322107 | 2322107 | 2022-03-16 | US | Puerto Rico | Rio Grande | 72119 | 6839 | 0 | 0 | 18.346329 | -65.813742 | 2022-03-17 04:20:56 | Rio Grande, Puerto Rico, US | |
2267379 | 2267379 | 2022-03-14 | US | West Virginia | Jackson | 54035 | 6839 | 133 | 0 | 38.84263974 | -81.68148753 | 2022-03-15 04:20:47 | Jackson, West Virginia, US | |
3721572 | 3721572 | 2022-02-21 | US | Virginia | Orange | 51137 | 6839 | 84 | 0 | 38.24530219 | -78.01560400000002 | 2022-02-22 04:21:01 | Orange, Virginia, US | |
1695866 | 1695866 | 2022-01-10 | US | Wisconsin | Green | 55045 | 6839 | 46 | 0 | 42.6794956 | -89.60243287 | 2022-01-11 04:22:01 | Green, Wisconsin, US | |
3607293 | 3607293 | 2021-12-25 | US | New York | Allegany | 36003 | 6839 | 134 | 0 | 42.25748406 | -78.02750466 | 2021-12-26 04:21:50 | Allegany, New York, US | |
2965611 | 2965611 | 2021-12-24 | US | New York | Allegany | 36003 | 6839 | 134 | 0 | 42.25748406 | -78.02750466 | 2021-12-25 04:21:37 | Allegany, New York, US | |
1079472 | 1079472 | 2021-12-09 | US | Louisiana | Webster | 22119 | 6839 | 151 | 0 | 32.70847669 | -93.33121835 | 2021-12-10 04:22:28 | Webster, Louisiana, US | |
1079152 | 1079152 | 2021-12-09 | US | Iowa | Muscatine | 19139 | 6839 | 117 | 0 | 41.48370744 | -91.11216970000001 | 2021-12-10 04:22:28 | Muscatine, Iowa, US | |
552001 | 552001 | 2021-12-08 | US | Iowa | Muscatine | 19139 | 6839 | 117 | 0 | 41.48370744 | -91.11216970000001 | 2021-12-09 04:22:49 | Muscatine, Iowa, US | |
404710 | 404710 | 2021-12-07 | US | Alaska | Bethel | 2050 | 6839 | 27 | 0 | 60.90980451 | -159.8561831 | 2021-12-08 04:22:46 | Bethel, Alaska, US | |
1030792 | 1030792 | 2021-12-06 | US | Alaska | Bethel | 2050 | 6839 | 27 | 0 | 60.90980451 | -159.8561831 | 2021-12-07 04:22:34 | Bethel, Alaska, US | |
3403934 | 3403934 | 2021-11-30 | US | Ohio | Mercer | 39107 | 6839 | 104 | 0 | 40.54043046 | -84.62912742 | 2021-12-01 04:22:29 | Mercer, Ohio, US | |
28779 | 28779 | 2021-11-11 | US | Alabama | Covington | 1039 | 6839 | 191 | 0 | 31.247785399999998 | -86.45050893 | 2021-11-12 04:22:01 | Covington, Alabama, US | |
3511274 | 3511274 | 2021-11-01 | Eritrea | 6839 | 45 | 0 | 15.1794 | 39.7823 | 2021-11-02 04:22:03 | Eritrea | ||||
3796864 | 3796864 | 2021-10-25 | US | Tennessee | Marshall | 47117 | 6839 | 86 | 0 | 35.45798777 | -86.76420988 | 2021-10-26 04:22:09 | Marshall, Tennessee, US | |
3832241 | 3832241 | 2021-10-05 | Canada | Nova Scotia | 6839 | 97 | 0 | 44.681999999999995 | -63.7443 | 2021-10-06 04:21:33 | Nova Scotia, Canada | |||
2078426 | 2078426 | 2021-09-26 | US | Ohio | Knox | 39083 | 6839 | 127 | 0 | 40.39830217 | -82.42027563 | 2021-09-27 04:21:16 | Knox, Ohio, US | |
1727425 | 1727425 | 2021-09-25 | US | Tennessee | Cocke | 47029 | 6839 | 103 | 0 | 35.9278914 | -83.11828725 | 2021-09-26 04:21:29 | Cocke, Tennessee, US | |
3758284 | 3758284 | 2021-09-21 | US | Georgia | Habersham | 13137 | 6839 | 172 | 0 | 34.63331566 | -83.53094677 | 2021-09-22 04:21:45 | Habersham, Georgia, US | |
35522 | 35522 | 2021-08-25 | US | Texas | Hardin | 48199 | 6839 | 129 | 0 | 30.33364686 | -94.38931817 | 2021-08-26 04:21:28 | Hardin, Texas, US | |
1485109 | 1485109 | 2021-08-13 | US | Maine | Kennebec | 23011 | 6839 | 83 | 0 | 44.40759555 | -69.76738544 | 2021-08-14 04:21:25 | Kennebec, Maine, US | |
1117948 | 1117948 | 2021-08-06 | US | Alabama | Colbert | 1033 | 6839 | 142 | 0 | 34.69847452 | -87.80168544 | 2021-08-07 04:21:30 | Colbert, Alabama, US | |
3904459 | 3904459 | 2021-07-31 | US | Arkansas | Greene | 5055 | 6839 | 80 | 0 | 36.11735460000001 | -90.55832668 | 2021-08-01 04:21:50 | Greene, Arkansas, US | |
1442292 | 1442292 | 2021-07-07 | US | Minnesota | Crow Wing | 27035 | 6839 | 97 | 0 | 46.48096553 | -94.06755609 | 2021-07-08 04:21:26 | Crow Wing, Minnesota, US | |
3126265 | 3126265 | 2021-06-28 | US | Georgia | Bulloch | 13031 | 6839 | 121 | 0 | 32.39577406 | -81.74811421 | 2021-06-29 04:21:28 | Bulloch, Georgia, US | |
3474509 | 3474509 | 2021-06-08 | US | New Mexico | Valencia | 35061 | 6839 | 117 | 0 | 34.71669834 | -106.8103733 | 2021-06-09 04:23:31 | Valencia, New Mexico, US | |
1954776 | 1954776 | 2021-05-21 | US | New York | Steuben | 36101 | 6839 | 143 | 0 | 42.2689144 | -77.3829924 | 2021-05-22 04:20:45 | Steuben, New York, US | |
1840748 | 1840748 | 2021-03-12 | US | South Carolina | Kershaw | 45055 | 6839 | 128 | 0 | 34.33988254 | -80.58763164 | 2021-03-13 05:25:15 | Kershaw, South Carolina, US | |
745673 | 745673 | 2021-02-20 | US | Virginia | Lynchburg | 51680 | 6839 | 93 | 0 | 6746 | 37.40021399 | -79.19888138 | 2021-02-21 05:24:33 | Lynchburg, Virginia, US |
2571154 | 2571154 | 2021-01-25 | US | West Virginia | Monongalia | 54061 | 6839 | 54 | 0 | 6785 | 39.63218457 | -80.04766838 | 2021-01-26 05:22:02 | Monongalia, West Virginia, US |
190976 | 190976 | 2021-01-11 | US | Idaho | Bannock | 16005 | 6839 | 70 | 0 | 6769 | 42.67002716 | -112.2233311 | 2021-01-12 05:22:15 | Bannock, Idaho, US |
2865091 | 2865091 | 2021-01-06 | US | Alabama | Lauderdale | 1077 | 6839 | 70 | 0 | 6769 | 34.90171875 | -87.65624729 | 2021-01-07 05:22:03 | Lauderdale, Alabama, US |
822292 | 822292 | 2020-11-19 | US | Florida | Santa Rosa | 12113 | 6839 | 96 | 0 | 6743 | 30.693414500000006 | -87.02458128 | 2020-11-20 05:26:28 | Santa Rosa, Florida, US |
821688 | 821688 | 2020-11-19 | Netherlands | Drenthe | 6839 | 102 | 0 | 6727 | 52.862485 | 6.618435000000002 | 2020-11-20 05:26:28 | Drenthe, Netherlands | ||
2234257 | 2234257 | 2020-07-03 | US | Illinois | Will | 17197 | 6839 | 320 | 0 | 6519 | 41.44619267 | -87.97862712 | 2020-07-04 04:33:51 | Will, Illinois, US |
284619 | 284619 | 2020-06-15 | US | Pennsylvania | Delaware | 42045 | 6839 | 620 | 0 | 6219 | 39.91680171 | -75.40243663 | 2020-06-16 04:33:09 | Delaware, Pennsylvania, US |
2555653 | 2555653 | 2020-06-02 | Germany | Berlin | 6839 | 198 | 6358 | 317 | 52.52 | 13.405 | 2020-06-03 02:33:13 | Berlin, 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]);