johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
59 rows where confirmed = 9211 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1053151 | 1053151 | 2022-11-06 | US | Virginia | Botetourt | 51023 | 9211 | 109 | 0 | 37.55531756 | -79.80982182 | 2022-11-07 04:21:26 | Botetourt, Virginia, US | |
621175 | 621175 | 2022-11-05 | US | Virginia | Botetourt | 51023 | 9211 | 109 | 0 | 37.55531756 | -79.80982182 | 2022-11-06 04:21:24 | Botetourt, Virginia, US | |
1025679 | 1025679 | 2022-11-04 | US | Virginia | Botetourt | 51023 | 9211 | 109 | 0 | 37.55531756 | -79.80982182 | 2022-11-05 04:21:52 | Botetourt, Virginia, US | |
1833205 | 1833205 | 2022-10-25 | US | Texas | Cherokee | 48073 | 9211 | 257 | 0 | 31.837258 | -95.16559897 | 2022-10-26 04:22:19 | Cherokee, Texas, US | |
797466 | 797466 | 2022-10-24 | US | Texas | Cherokee | 48073 | 9211 | 257 | 0 | 31.837258 | -95.16559897 | 2022-10-25 04:21:53 | Cherokee, Texas, US | |
993278 | 993278 | 2022-08-16 | US | New York | Wyoming | 36121 | 9211 | 86 | 0 | 42.70145109 | -78.22199579 | 2022-08-17 04:20:59 | Wyoming, New York, US | |
3648551 | 3648551 | 2022-08-14 | US | Illinois | Bureau | 17011 | 9211 | 129 | 0 | 41.40385234 | -89.5283051 | 2022-08-15 04:20:59 | Bureau, Illinois, US | |
1969557 | 1969557 | 2022-08-13 | US | Illinois | Bureau | 17011 | 9211 | 129 | 0 | 41.40385234 | -89.5283051 | 2022-08-14 04:20:55 | Bureau, Illinois, US | |
2889366 | 2889366 | 2022-08-12 | US | Illinois | Bureau | 17011 | 9211 | 129 | 0 | 41.40385234 | -89.5283051 | 2022-08-13 04:20:52 | Bureau, Illinois, US | |
2011305 | 2011305 | 2022-08-04 | US | Oregon | Columbia | 41009 | 9211 | 103 | 0 | 45.94464254 | -123.0890898 | 2022-08-05 04:20:52 | Columbia, Oregon, US | |
358563 | 358563 | 2022-03-11 | US | New York | Franklin | 36033 | 9211 | 44 | 0 | 44.59040891 | -74.29926032 | 2022-03-12 04:20:50 | Franklin, New York, US | |
2526482 | 2526482 | 2022-03-02 | US | Indiana | Miami | 18103 | 9211 | 150 | 0 | 40.76940965 | -86.04525048 | 2022-03-03 04:21:01 | Miami, Indiana, US | |
1994151 | 1994151 | 2022-03-01 | US | Louisiana | Beauregard | 22011 | 9211 | 137 | 0 | 30.64836518 | -93.34173616 | 2022-03-02 04:21:07 | Beauregard, Louisiana, US | |
944325 | 944325 | 2022-02-28 | US | Louisiana | Beauregard | 22011 | 9211 | 137 | 0 | 30.64836518 | -93.34173616 | 2022-03-01 04:21:09 | Beauregard, Louisiana, US | |
2734516 | 2734516 | 2022-02-27 | US | Louisiana | Beauregard | 22011 | 9211 | 137 | 0 | 30.64836518 | -93.34173616 | 2022-02-28 04:21:05 | Beauregard, Louisiana, US | |
3047669 | 3047669 | 2022-02-26 | US | Louisiana | Beauregard | 22011 | 9211 | 137 | 0 | 30.64836518 | -93.34173616 | 2022-02-27 04:21:04 | Beauregard, Louisiana, US | |
576324 | 576324 | 2022-02-25 | US | Louisiana | Beauregard | 22011 | 9211 | 137 | 0 | 30.64836518 | -93.34173616 | 2022-02-26 04:21:12 | Beauregard, Louisiana, US | |
1298519 | 1298519 | 2022-02-17 | US | Arkansas | Boone | 5009 | 9211 | 158 | 0 | 36.3084504 | -93.09374925 | 2022-02-18 04:21:04 | Boone, Arkansas, US | |
2477274 | 2477274 | 2022-02-03 | US | Virginia | Charlottesville | 51540 | 9211 | 63 | 0 | 38.03527919 | -78.48569588 | 2022-02-04 04:21:10 | Charlottesville, Virginia, US | |
3428192 | 3428192 | 2022-01-21 | US | Texas | Uvalde | 48463 | 9211 | 120 | 0 | 29.35739637 | -99.76229172 | 2022-01-22 04:21:13 | Uvalde, Texas, US | |
1216017 | 1216017 | 2022-01-08 | US | Arizona | Graham | 4009 | 9211 | 159 | 0 | 32.93166885 | -109.8882178 | 2022-01-09 04:21:46 | Graham, Arizona, US | |
2612753 | 2612753 | 2022-01-06 | US | Pennsylvania | Union | 42119 | 9211 | 135 | 0 | 40.96188846 | -77.05996014 | 2022-01-07 04:22:09 | Union, Pennsylvania, US | |
732347 | 732347 | 2021-12-27 | US | Mississippi | Lafayette | 28071 | 9211 | 143 | 0 | 34.35687874 | -89.48490961 | 2021-12-28 04:21:47 | Lafayette, Mississippi, US | |
3605438 | 3605438 | 2021-12-25 | US | Alabama | Dale | 1045 | 9211 | 194 | 0 | 31.43037123 | -85.61095742 | 2021-12-26 04:21:50 | Dale, Alabama, US | |
3498814 | 3498814 | 2021-12-15 | US | Oregon | Klamath | 41035 | 9211 | 162 | 0 | 42.68762984 | -121.64964609999998 | 2021-12-16 04:22:11 | Klamath, Oregon, US | |
28776 | 28776 | 2021-11-11 | US | Alabama | Colbert | 1033 | 9211 | 206 | 0 | 34.69847452 | -87.80168544 | 2021-11-12 04:22:01 | Colbert, Alabama, US | |
570018 | 570018 | 2021-10-29 | US | Tennessee | Bedford | 47003 | 9211 | 156 | 0 | 35.51123746 | -86.45549096 | 2021-10-30 04:22:03 | Bedford, Tennessee, US | |
3794253 | 3794253 | 2021-10-25 | US | Alabama | Coffee | 1031 | 9211 | 191 | 0 | 31.39932826 | -85.98901039 | 2021-10-26 04:22:09 | Coffee, Alabama, US | |
682699 | 682699 | 2021-10-24 | US | Alabama | Coffee | 1031 | 9211 | 191 | 0 | 31.39932826 | -85.98901039 | 2021-10-25 04:22:31 | Coffee, Alabama, US | |
3805910 | 3805910 | 2021-09-11 | Japan | Fukushima | 9211 | 173 | 0 | 37.378867 | 140.223295 | 2021-09-12 04:21:13 | Fukushima, Japan | |||
2521734 | 2521734 | 2021-08-18 | US | Wisconsin | Manitowoc | 55071 | 9211 | 97 | 0 | 44.11946801 | -87.80928853 | 2021-08-19 04:21:15 | Manitowoc, Wisconsin, US | |
485188 | 485188 | 2021-07-19 | US | Massachusetts | Hampshire | 25015 | 9211 | 235 | 0 | 42.33997957 | -72.65898478 | 2021-07-20 04:21:48 | Hampshire, Massachusetts, US | |
3126000 | 3126000 | 2021-06-28 | US | Arkansas | Jefferson | 5069 | 9211 | 170 | 0 | 34.26767081 | -91.92619839 | 2021-06-29 04:21:28 | Jefferson, Arkansas, US | |
1738670 | 1738670 | 2021-06-12 | US | New Jersey | Cape May | 34009 | 9211 | 207 | 0 | 39.15008829 | -74.80170244 | 2021-06-13 04:22:44 | Cape May, New Jersey, US | |
3972711 | 3972711 | 2021-06-11 | US | New Jersey | Cape May | 34009 | 9211 | 207 | 0 | 39.15008829 | -74.80170244 | 2021-06-12 04:22:22 | Cape May, New Jersey, US | |
3678746 | 3678746 | 2021-05-04 | US | Texas | Gregg | 48183 | 9211 | 352 | 0 | 32.47940482 | -94.81591935 | 2021-05-05 04:20:43 | Gregg, Texas, US | |
2764013 | 2764013 | 2021-05-03 | US | Texas | Gregg | 48183 | 9211 | 352 | 0 | 32.47940482 | -94.81591935 | 2021-05-04 04:20:34 | Gregg, Texas, US | |
2453866 | 2453866 | 2021-05-02 | US | Texas | Gregg | 48183 | 9211 | 352 | 0 | 32.47940482 | -94.81591935 | 2021-05-03 04:20:39 | Gregg, Texas, US | |
2827879 | 2827879 | 2021-05-01 | US | Texas | Gregg | 48183 | 9211 | 353 | 0 | 32.47940482 | -94.81591935 | 2021-05-02 04:20:48 | Gregg, Texas, US | |
383287 | 383287 | 2021-04-30 | US | Texas | Gregg | 48183 | 9211 | 353 | 0 | 32.47940482 | -94.81591935 | 2021-05-01 04:20:47 | Gregg, Texas, US | |
2249092 | 2249092 | 2021-04-07 | US | Minnesota | Carver | 27019 | 9211 | 41 | 0 | 44.82017001 | -93.8009918 | 2021-04-08 04:21:13 | Carver, Minnesota, US | |
241836 | 241836 | 2021-04-02 | US | California | Sutter | 6101 | 9211 | 106 | 0 | 39.03417539 | -121.6945899 | 2021-04-03 04:20:44 | Sutter, California, US | |
702426 | 702426 | 2021-03-16 | Japan | Kyoto | 9211 | 164 | 8871 | 176 | 35.253815 | 135.443341 | 2021-03-17 05:25:07 | Kyoto, Japan | ||
2056971 | 2056971 | 2021-03-15 | US | Indiana | Howard | 18067 | 9211 | 206 | 0 | 40.48527731 | -86.11351892 | 2021-03-16 05:25:13 | Howard, Indiana, US | |
1735506 | 1735506 | 2021-03-14 | US | Texas | Bastrop | 48021 | 9211 | 86 | 0 | 30.10370699 | -97.31206354 | 2021-03-15 05:25:51 | Bastrop, Texas, US | |
1583163 | 1583163 | 2021-03-13 | US | Texas | Bastrop | 48021 | 9211 | 86 | 0 | 30.10370699 | -97.31206354 | 2021-03-14 05:25:37 | Bastrop, Texas, US | |
614225 | 614225 | 2021-02-08 | US | California | El Dorado | 6017 | 9211 | 86 | 0 | 9152 | 38.77965956 | -120.5233166 | 2021-02-09 05:23:30 | El Dorado, California, US |
3899771 | 3899771 | 2021-01-09 | China | Hong Kong | 9211 | 157 | 8374 | 680 | 22.3 | 114.2 | 2021-01-10 05:22:12 | Hong Kong, China | ||
2130977 | 2130977 | 2020-12-17 | US | Tennessee | Sullivan | 47163 | 9211 | 154 | 0 | 8926 | 36.51240691 | -82.30412917 | 2020-12-18 05:28:18 | Sullivan, Tennessee, US |
3152041 | 3152041 | 2020-12-16 | US | Ohio | Delaware | 39041 | 9211 | 60 | 0 | 9151 | 40.27942393 | -83.00457058 | 2020-12-17 05:28:12 | Delaware, Ohio, US |
1818960 | 1818960 | 2020-12-08 | Peru | Tumbes | 9211 | 738 | 0 | 8473 | -3.857496 | -80.54525500000003 | 2020-12-09 05:28:01 | Tumbes, Peru | ||
2347596 | 2347596 | 2020-12-07 | Peru | Tumbes | 9211 | 736 | 0 | 8475 | -3.857496 | -80.54525500000003 | 2020-12-08 05:27:42 | Tumbes, Peru | ||
3836413 | 3836413 | 2020-11-21 | Haiti | 9211 | 232 | 7854 | 1125 | 18.9712 | -72.2852 | 2020-11-22 05:25:45 | Haiti | |||
213875 | 213875 | 2020-10-29 | Ukraine | Zaporizhia Oblast | 9211 | 114 | 2151 | 6946 | 47.8388 | 35.1396 | 2020-10-30 04:24:49 | Zaporizhia Oblast, Ukraine | ||
2614284 | 2614284 | 2020-09-26 | Russia | Tyumen Oblast | 9211 | 36 | 7544 | 1631 | 58.8206488 | 70.3658837 | 2020-09-27 04:23:00 | Tyumen Oblast, Russia | ||
3319146 | 3319146 | 2020-09-22 | US | Tennessee | Hamilton | 47065 | 9211 | 89 | 0 | 9122 | 35.17670231 | -85.16652245 | 2020-09-23 04:23:00 | Hamilton, Tennessee, US |
546984 | 546984 | 2020-09-12 | Russia | Penza Oblast | 9211 | 117 | 8234 | 860 | 53.1655415 | 44.78791810000001 | 2020-09-13 04:30:52 | Penza Oblast, Russia | ||
1107132 | 1107132 | 2020-09-02 | US | Massachusetts | Bristol | 25005 | 9211 | 606 | 0 | 8556 | 41.79228404 | -71.10872211 | 2020-09-03 04:28:22 | Bristol, Massachusetts, US |
2991713 | 2991713 | 2020-08-24 | US | Arizona | Pinal | 4021 | 9211 | 177 | 0 | 9034 | 32.90525627 | -111.3449483 | 2020-08-25 04:28:02 | Pinal, Arizona, 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]);