johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
73 rows where confirmed = 8793 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
308923 | 308923 | 2022-12-13 | US | Illinois | Perry | 17145 | 8793 | 99 | 0 | 38.08510853 | -89.36856219 | 2022-12-14 04:21:04 | Perry, Illinois, US | |
2415464 | 2415464 | 2022-12-05 | US | California | Siskiyou | 6093 | 8793 | 95 | 0 | 41.59198861 | -122.5407434 | 2022-12-06 04:21:03 | Siskiyou, California, US | |
3029596 | 3029596 | 2022-11-17 | US | Virginia | Amherst | 51009 | 8793 | 104 | 0 | 37.60308293 | -79.14548696 | 2022-11-18 04:21:15 | Amherst, Virginia, US | |
2162881 | 2162881 | 2022-10-16 | US | Virginia | Gloucester | 51073 | 8793 | 110 | 0 | 37.40809042 | -76.53524337 | 2022-10-17 04:20:31 | Gloucester, Virginia, US | |
519078 | 519078 | 2022-10-15 | US | Virginia | Gloucester | 51073 | 8793 | 110 | 0 | 37.40809042 | -76.53524337 | 2022-10-16 04:22:39 | Gloucester, Virginia, US | |
2036135 | 2036135 | 2022-10-14 | US | Virginia | Gloucester | 51073 | 8793 | 110 | 0 | 37.40809042 | -76.53524337 | 2022-10-15 04:22:00 | Gloucester, Virginia, US | |
2687188 | 2687188 | 2022-10-03 | US | Louisiana | Allen | 22003 | 8793 | 143 | 0 | 30.65385745 | -92.82442028 | 2022-10-04 04:22:55 | Allen, Louisiana, US | |
3777216 | 3777216 | 2022-08-30 | US | Virginia | Botetourt | 51023 | 8793 | 107 | 0 | 37.55531756 | -79.80982182 | 2022-08-31 04:20:57 | Botetourt, Virginia, US | |
1610011 | 1610011 | 2022-07-20 | US | Minnesota | Nicollet | 27103 | 8793 | 68 | 0 | 44.35291112 | -94.24710352 | 2022-07-21 04:21:10 | Nicollet, Minnesota, US | |
960644 | 960644 | 2022-07-19 | US | Minnesota | Nicollet | 27103 | 8793 | 68 | 0 | 44.35291112 | -94.24710352 | 2022-07-20 04:20:59 | Nicollet, Minnesota, US | |
959756 | 959756 | 2022-07-19 | US | Georgia | Pickens | 13227 | 8793 | 171 | 0 | 34.46589159 | -84.46406611 | 2022-07-20 04:20:59 | Pickens, Georgia, US | |
3212031 | 3212031 | 2022-07-18 | US | Minnesota | Nicollet | 27103 | 8793 | 68 | 0 | 44.35291112 | -94.24710352 | 2022-07-19 04:20:58 | Nicollet, Minnesota, US | |
3211143 | 3211143 | 2022-07-18 | US | Georgia | Pickens | 13227 | 8793 | 171 | 0 | 34.46589159 | -84.46406611 | 2022-07-19 04:20:58 | Pickens, Georgia, US | |
3407206 | 3407206 | 2022-07-17 | US | Minnesota | Nicollet | 27103 | 8793 | 68 | 0 | 44.35291112 | -94.24710352 | 2022-07-18 04:20:59 | Nicollet, Minnesota, US | |
3406318 | 3406318 | 2022-07-17 | US | Georgia | Pickens | 13227 | 8793 | 171 | 0 | 34.46589159 | -84.46406611 | 2022-07-18 04:20:59 | Pickens, Georgia, US | |
2153406 | 2153406 | 2022-07-16 | US | Minnesota | Nicollet | 27103 | 8793 | 68 | 0 | 44.35291112 | -94.24710352 | 2022-07-17 04:21:15 | Nicollet, Minnesota, US | |
2152518 | 2152518 | 2022-07-16 | US | Georgia | Pickens | 13227 | 8793 | 171 | 0 | 34.46589159 | -84.46406611 | 2022-07-17 04:21:15 | Pickens, Georgia, US | |
2420639 | 2420639 | 2022-07-15 | US | Minnesota | Nicollet | 27103 | 8793 | 68 | 0 | 44.35291112 | -94.24710352 | 2022-07-16 04:21:05 | Nicollet, Minnesota, US | |
2419751 | 2419751 | 2022-07-15 | US | Georgia | Pickens | 13227 | 8793 | 171 | 0 | 34.46589159 | -84.46406611 | 2022-07-16 04:21:05 | Pickens, Georgia, US | |
3430714 | 3430714 | 2022-07-14 | US | Minnesota | Nicollet | 27103 | 8793 | 68 | 0 | 44.35291112 | -94.24710352 | 2022-07-15 04:20:53 | Nicollet, Minnesota, US | |
3429826 | 3429826 | 2022-07-14 | US | Georgia | Pickens | 13227 | 8793 | 171 | 0 | 34.46589159 | -84.46406611 | 2022-07-15 04:20:53 | Pickens, Georgia, US | |
3110346 | 3110346 | 2022-07-13 | US | Georgia | Pickens | 13227 | 8793 | 171 | 0 | 34.46589159 | -84.46406611 | 2022-07-14 04:20:57 | Pickens, Georgia, US | |
1420112 | 1420112 | 2022-07-08 | US | Texas | Bee | 48025 | 8793 | 154 | 0 | 28.41761668 | -97.74215593 | 2022-07-09 04:20:59 | Bee, Texas, US | |
3357752 | 3357752 | 2022-05-14 | US | Texas | Erath | 48143 | 8793 | 123 | 0 | 32.23602653 | -98.21773417 | 2022-05-15 04:20:53 | Erath, Texas, US | |
3447793 | 3447793 | 2022-05-11 | US | Tennessee | Hardin | 47071 | 8793 | 145 | 0 | 35.19732531 | -88.18593755 | 2022-05-12 04:20:54 | Hardin, Tennessee, US | |
3725612 | 3725612 | 2022-04-25 | US | Virginia | Smyth | 51173 | 8793 | 170 | 0 | 36.84455636 | -81.53344948 | 2022-04-26 04:20:51 | Smyth, Virginia, US | |
3321939 | 3321939 | 2022-04-07 | US | Minnesota | Becker | 27005 | 8793 | 92 | 0 | 46.93479392 | -95.67158144 | 2022-04-08 04:20:48 | Becker, Minnesota, US | |
2142126 | 2142126 | 2022-03-09 | US | Missouri | Pulaski | 29169 | 8793 | 113 | 0 | 37.82462075 | -92.20783203 | 2022-03-10 04:20:48 | Pulaski, Missouri, US | |
3878255 | 3878255 | 2022-02-19 | US | Pennsylvania | Jefferson | 42065 | 8793 | 212 | 0 | 41.12913106 | -78.9986361 | 2022-02-20 04:21:00 | Jefferson, Pennsylvania, US | |
978949 | 978949 | 2022-02-01 | Japan | Kagawa | 8793 | 41 | 0 | 34.217292 | 133.969047 | 2022-02-02 04:21:09 | Kagawa, Japan | |||
1672026 | 1672026 | 2021-12-29 | US | Wisconsin | Oconto | 55083 | 8793 | 88 | 0 | 45.02715345 | -88.26807503 | 2021-12-30 04:21:25 | Oconto, Wisconsin, US | |
1257479 | 1257479 | 2021-12-20 | US | Pennsylvania | Venango | 42121 | 8793 | 189 | 0 | 41.40323442 | -79.75845449 | 2021-12-21 03:21:27 | Venango, Pennsylvania, US | |
782840 | 782840 | 2021-12-13 | US | Arizona | Graham | 4009 | 8793 | 143 | 0 | 32.93166885 | -109.8882178 | 2021-12-14 04:22:38 | Graham, Arizona, US | |
1147442 | 1147442 | 2021-12-01 | US | Ohio | Seneca | 39147 | 8793 | 174 | 0 | 41.12351311 | -83.12783209 | 2021-12-02 04:22:37 | Seneca, Ohio, US | |
538244 | 538244 | 2021-10-27 | US | West Virginia | Putnam | 54079 | 8793 | 123 | 0 | 38.50782345 | -81.9082131 | 2021-10-28 04:22:08 | Putnam, West Virginia, US | |
2959383 | 2959383 | 2021-10-08 | Japan | Nagano | 8793 | 96 | 0 | 36.132134 | 138.045528 | 2021-10-09 04:21:34 | Nagano, Japan | |||
1335108 | 1335108 | 2021-09-28 | US | Georgia | Laurens | 13175 | 8793 | 218 | 0 | 32.46325233 | -82.92221316 | 2021-09-29 04:21:45 | Laurens, Georgia, US | |
1921577 | 1921577 | 2021-09-24 | US | Alabama | Coffee | 1031 | 8793 | 175 | 0 | 31.39932826 | -85.98901039 | 2021-09-25 04:21:31 | Coffee, Alabama, US | |
812879 | 812879 | 2021-09-20 | US | Virginia | Bedford | 51019 | 8793 | 118 | 0 | 37.3080028 | -79.5281964 | 2021-09-21 04:21:26 | Bedford, Virginia, US | |
180851 | 180851 | 2021-09-02 | US | South Carolina | Laurens | 45059 | 8793 | 176 | 0 | 34.48244419 | -82.00490796 | 2021-09-03 04:21:20 | Laurens, South Carolina, US | |
1776946 | 1776946 | 2021-08-30 | US | Maryland | Wicomico | 24045 | 8793 | 183 | 0 | 38.37301947 | -75.62705831 | 2021-08-31 04:21:46 | Wicomico, Maryland, US | |
589563 | 589563 | 2021-08-08 | Iceland | 8793 | 30 | 0 | 64.9631 | -19.0208 | 2021-08-09 04:21:24 | Iceland | ||||
334392 | 334392 | 2021-08-04 | US | Ohio | Marion | 39101 | 8793 | 140 | 0 | 40.58610662 | -83.15736305 | 2021-08-05 04:21:51 | Marion, Ohio, US | |
3385890 | 3385890 | 2021-07-29 | US | Arkansas | Lonoke | 5085 | 8793 | 131 | 0 | 34.75392199 | -91.88742357 | 2021-07-30 04:21:34 | Lonoke, Arkansas, US | |
3385416 | 3385416 | 2021-07-29 | Japan | Nara | 8793 | 133 | 8466 | 194 | 34.317451 | 135.871644 | 2021-07-30 04:21:34 | Nara, Japan | ||
2593445 | 2593445 | 2021-06-27 | US | Washington | Kitsap | 53035 | 8793 | 117 | 0 | 47.63479026 | -122.6436061 | 2021-06-28 04:21:29 | Kitsap, Washington, US | |
3961949 | 3961949 | 2021-06-26 | US | Washington | Kitsap | 53035 | 8793 | 117 | 0 | 47.63479026 | -122.6436061 | 2021-06-27 04:21:39 | Kitsap, Washington, US | |
2717670 | 2717670 | 2021-06-10 | US | Florida | Highlands | 12055 | 8793 | 366 | 0 | 27.34254618 | -81.34071957 | 2021-06-11 04:23:20 | Highlands, Florida, US | |
525764 | 525764 | 2021-06-09 | US | Tennessee | Anderson | 47001 | 8793 | 172 | 0 | 36.12684348 | -84.19965764 | 2021-06-10 04:23:17 | Anderson, Tennessee, US | |
523555 | 523555 | 2021-06-09 | US | Florida | Highlands | 12055 | 8793 | 366 | 0 | 27.34254618 | -81.34071957 | 2021-06-10 04:23:17 | Highlands, Florida, US | |
3475204 | 3475204 | 2021-06-08 | US | Tennessee | Anderson | 47001 | 8793 | 172 | 0 | 36.12684348 | -84.19965764 | 2021-06-09 04:23:31 | Anderson, Tennessee, US | |
3472995 | 3472995 | 2021-06-08 | US | Florida | Highlands | 12055 | 8793 | 366 | 0 | 27.34254618 | -81.34071957 | 2021-06-09 04:23:31 | Highlands, Florida, US | |
3146279 | 3146279 | 2021-06-07 | US | Florida | Highlands | 12055 | 8793 | 366 | 0 | 27.34254618 | -81.34071957 | 2021-06-08 04:22:35 | Highlands, Florida, US | |
826281 | 826281 | 2021-06-06 | US | Florida | Highlands | 12055 | 8793 | 366 | 0 | 27.34254618 | -81.34071957 | 2021-06-07 04:22:51 | Highlands, Florida, US | |
2586686 | 2586686 | 2021-06-05 | US | Florida | Highlands | 12055 | 8793 | 366 | 0 | 27.34254618 | -81.34071957 | 2021-06-06 04:24:03 | Highlands, Florida, US | |
1554488 | 1554488 | 2021-05-08 | US | Ohio | Wayne | 39169 | 8793 | 219 | 0 | 40.82925852 | -81.88844833 | 2021-05-09 04:20:35 | Wayne, Ohio, US | |
608927 | 608927 | 2021-04-09 | US | Texas | Victoria | 48469 | 8793 | 198 | 0 | 28.79780988 | -96.96813006 | 2021-04-10 04:20:59 | Victoria, Texas, US | |
2647930 | 2647930 | 2021-04-08 | US | New Jersey | Warren | 34041 | 8793 | 229 | 0 | 40.85951833 | -74.99556527 | 2021-04-09 04:21:13 | Warren, New Jersey, US | |
1582027 | 1582027 | 2021-03-13 | US | Missouri | Cass | 29037 | 8793 | 93 | 0 | 38.64789422 | -94.353399 | 2021-03-14 05:25:37 | Cass, Missouri, US | |
1090497 | 1090497 | 2021-03-03 | US | Alaska | Matanuska-Susitna | 2170 | 8793 | 36 | 0 | 8757 | 62.31305045 | -149.5741743 | 2021-03-04 05:24:24 | Matanuska-Susitna, Alaska, US |
1001266 | 1001266 | 2021-03-01 | US | South Carolina | Orangeburg | 45075 | 8793 | 217 | 0 | 8576 | 33.4391073 | -80.79886287 | 2021-03-02 05:23:30 | Orangeburg, South Carolina, US |
341806 | 341806 | 2021-02-03 | US | Louisiana | Terrebonne | 22109 | 8793 | 186 | 0 | 8607 | 29.37343766 | -90.82626855 | 2021-02-04 05:22:26 | Terrebonne, Louisiana, US |
341222 | 341222 | 2021-02-03 | US | Idaho | Twin Falls | 16083 | 8793 | 119 | 0 | 8674 | 42.35440512 | -114.6685381 | 2021-02-04 05:22:26 | Twin Falls, Idaho, US |
340654 | 340654 | 2021-02-03 | US | Alabama | Limestone | 1083 | 8793 | 113 | 0 | 8680 | 34.81185586 | -86.98310072 | 2021-02-04 05:22:26 | Limestone, Alabama, US |
3903584 | 3903584 | 2021-01-09 | Ukraine | Kirovohrad Oblast | 8793 | 272 | 4836 | 3685 | 48.5079 | 32.2623 | 2021-01-10 05:22:12 | Kirovohrad Oblast, Ukraine | ||
1064484 | 1064484 | 2021-01-04 | US | Pennsylvania | Beaver | 42007 | 8793 | 260 | 0 | 8533 | 40.6825484 | -80.34921611 | 2021-01-05 05:21:49 | Beaver, Pennsylvania, US |
3697322 | 3697322 | 2020-12-31 | US | Mississippi | Rankin | 28121 | 8793 | 165 | 0 | 8628 | 32.26469147 | -89.94537876 | 2021-01-01 05:23:07 | Rankin, Mississippi, US |
930029 | 930029 | 2020-12-21 | US | North Carolina | New Hanover | 37129 | 8793 | 71 | 0 | 8722 | 34.25758282 | -77.87075626 | 2020-12-22 05:22:33 | New Hanover, North Carolina, US |
2935945 | 2935945 | 2020-11-28 | US | Florida | Okaloosa | 12091 | 8793 | 147 | 0 | 8646 | 30.69143028 | -86.59267105 | 2020-11-29 05:25:55 | Okaloosa, Florida, US |
377038 | 377038 | 2020-11-06 | US | Georgia | Richmond | 13245 | 8793 | 202 | 0 | 8591 | 33.35777107 | -82.07026432 | 2020-11-07 05:24:52 | Richmond, Georgia, US |
2079695 | 2079695 | 2020-10-31 | Cabo Verde | 8793 | 95 | 7981 | 717 | 16.5388 | -23.0418 | 2020-11-01 04:36:19 | Cabo Verde | |||
3483756 | 3483756 | 2020-10-26 | US | Washington | Snohomish | 53061 | 8793 | 227 | 0 | 8566 | 48.04615983 | -121.7170703 | 2020-10-27 04:24:45 | Snohomish, Washington, US |
1837521 | 1837521 | 2020-06-14 | Morocco | 8793 | 212 | 7765 | 816 | 31.7917 | -7.0926 | 2020-06-15 03:33:14 | Morocco |
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]);