johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
42 rows where confirmed = 11609 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1025085 | 1025085 | 2022-11-04 | US | Puerto Rico | Aguada | 72003 | 11609 | 0 | 0 | 18.360255 | -67.175131 | 2022-11-05 04:21:52 | Aguada, Puerto Rico, US | |
133927 | 133927 | 2022-10-04 | US | Texas | Medina | 48325 | 11609 | 208 | 0 | 29.3557301 | -99.11030298 | 2022-10-05 04:23:06 | Medina, Texas, US | |
2688874 | 2688874 | 2022-10-03 | US | Texas | Medina | 48325 | 11609 | 208 | 0 | 29.3557301 | -99.11030298 | 2022-10-04 04:22:55 | Medina, Texas, US | |
3406848 | 3406848 | 2022-07-17 | US | Kentucky | Clark | 21049 | 11609 | 73 | 0 | 37.9689263 | -84.14615986 | 2022-07-18 04:20:59 | Clark, Kentucky, US | |
2153048 | 2153048 | 2022-07-16 | US | Kentucky | Clark | 21049 | 11609 | 73 | 0 | 37.9689263 | -84.14615986 | 2022-07-17 04:21:15 | Clark, Kentucky, US | |
2420281 | 2420281 | 2022-07-15 | US | Kentucky | Clark | 21049 | 11609 | 73 | 0 | 37.9689263 | -84.14615986 | 2022-07-16 04:21:05 | Clark, Kentucky, US | |
3430356 | 3430356 | 2022-07-14 | US | Kentucky | Clark | 21049 | 11609 | 73 | 0 | 37.9689263 | -84.14615986 | 2022-07-15 04:20:53 | Clark, Kentucky, US | |
3110876 | 3110876 | 2022-07-13 | US | Kentucky | Clark | 21049 | 11609 | 73 | 0 | 37.9689263 | -84.14615986 | 2022-07-14 04:20:57 | Clark, Kentucky, US | |
631299 | 631299 | 2022-07-12 | US | Kentucky | Clark | 21049 | 11609 | 73 | 0 | 37.9689263 | -84.14615986 | 2022-07-13 04:20:58 | Clark, Kentucky, US | |
630401 | 630401 | 2022-07-12 | US | Arkansas | Hot Spring | 5059 | 11609 | 138 | 0 | 34.31709259 | -92.95396325 | 2022-07-13 04:20:58 | Hot Spring, Arkansas, US | |
1212943 | 1212943 | 2022-07-11 | US | Kentucky | Clark | 21049 | 11609 | 73 | 0 | 37.9689263 | -84.14615986 | 2022-07-12 04:20:51 | Clark, Kentucky, US | |
2321762 | 2321762 | 2022-03-16 | US | North Dakota | Stark | 38089 | 11609 | 86 | 0 | 46.80851182 | -102.65763259999999 | 2022-03-17 04:20:56 | Stark, North Dakota, US | |
3048897 | 3048897 | 2022-02-26 | US | Puerto Rico | Arecibo | 72013 | 11609 | 0 | 0 | 18.406631 | -66.675077 | 2022-02-27 04:21:04 | Arecibo, Puerto Rico, US | |
3301308 | 3301308 | 2022-01-30 | US | Indiana | Jackson | 18071 | 11609 | 105 | 0 | 38.90915820000001 | -86.03851889 | 2022-01-31 04:21:09 | Jackson, Indiana, US | |
3063099 | 3063099 | 2022-01-29 | US | Indiana | Jackson | 18071 | 11609 | 105 | 0 | 38.90915820000001 | -86.03851889 | 2022-01-30 04:21:26 | Jackson, Indiana, US | |
3811033 | 3811033 | 2022-01-28 | US | Indiana | Jackson | 18071 | 11609 | 105 | 0 | 38.90915820000001 | -86.03851889 | 2022-01-29 04:21:10 | Jackson, Indiana, US | |
2054088 | 2054088 | 2022-01-25 | US | New Mexico | Otero | 35035 | 11609 | 157 | 0 | 32.61348406 | -105.7417604 | 2022-01-26 04:21:07 | Otero, New Mexico, US | |
99916 | 99916 | 2022-01-14 | US | California | Tehama | 6103 | 11609 | 141 | 0 | 40.12570935 | -122.23701709999999 | 2022-01-15 04:21:07 | Tehama, California, US | |
1115926 | 1115926 | 2022-01-11 | US | North Carolina | Lee | 37105 | 11609 | 121 | 0 | 35.47623147 | -79.17569362 | 2022-01-12 04:21:44 | Lee, North Carolina, US | |
1664001 | 1664001 | 2021-12-12 | US | Wisconsin | Portage | 55097 | 11609 | 121 | 0 | 44.47558711 | -89.50152965 | 2021-12-13 04:22:02 | Portage, Wisconsin, US | |
1668017 | 1668017 | 2021-12-11 | US | Wisconsin | Portage | 55097 | 11609 | 121 | 0 | 44.47558711 | -89.50152965 | 2021-12-12 04:22:12 | Portage, Wisconsin, US | |
3659169 | 3659169 | 2021-12-10 | US | Wisconsin | Portage | 55097 | 11609 | 121 | 0 | 44.47558711 | -89.50152965 | 2021-12-11 04:22:45 | Portage, Wisconsin, US | |
3750037 | 3750037 | 2021-11-22 | US | Hawaii | Hawaii | 15001 | 11609 | 132 | 0 | 19.60121157 | -155.5210167 | 2021-11-23 04:22:39 | Hawaii, Hawaii, US | |
2847125 | 2847125 | 2021-11-10 | US | New York | St. Lawrence | 36089 | 11609 | 138 | 0 | 44.4976179 | -75.06550039 | 2021-11-11 04:21:45 | St. Lawrence, New York, US | |
581208 | 581208 | 2021-07-13 | US | North Carolina | Wayne | 37191 | 11609 | 243 | 0 | 35.36438125 | -78.00027268 | 2021-07-14 04:21:35 | Wayne, North Carolina, US | |
628842 | 628842 | 2021-07-10 | US | Tennessee | Madison | 47113 | 11609 | 243 | 0 | 35.61181957 | -88.84076036 | 2021-07-11 04:21:43 | Madison, Tennessee, US | |
1440462 | 1440462 | 2021-07-07 | Djibouti | 11609 | 155 | 11446 | 8 | 11.8251 | 42.5903 | 2021-07-08 04:21:26 | Djibouti | |||
2693567 | 2693567 | 2021-07-06 | Djibouti | 11609 | 155 | 11446 | 8 | 11.8251 | 42.5903 | 2021-07-07 04:21:20 | Djibouti | |||
3961124 | 3961124 | 2021-06-26 | US | Oregon | Jackson | 41029 | 11609 | 147 | 0 | 42.43201126 | -122.7289309 | 2021-06-27 04:21:39 | Jackson, Oregon, US | |
1708308 | 1708308 | 2021-06-02 | Italy | Valle d'Aosta | 11609 | 472 | 10933 | 204 | 45.73750286 | 7.320149366 | 2021-06-03 04:23:32 | Valle d'Aosta, Italy | ||
2822528 | 2822528 | 2021-05-10 | US | Minnesota | Sherburne | 27141 | 11609 | 85 | 0 | 45.44447208 | -93.77617511 | 2021-05-11 04:20:41 | Sherburne, Minnesota, US | |
3115918 | 3115918 | 2021-05-06 | US | Ohio | Allen | 39003 | 11609 | 236 | 0 | 40.77285242 | -84.10802343 | 2021-05-07 04:20:40 | Allen, Ohio, US | |
1744679 | 1744679 | 2021-03-20 | Pakistan | Azad Jammu and Kashmir | 11609 | 333 | 10296 | 980 | 34.027401 | 73.947253 | 2021-03-21 05:25:44 | Azad Jammu and Kashmir, Pakistan | ||
615677 | 615677 | 2021-02-08 | US | Montana | Gallatin | 30031 | 11609 | 50 | 0 | 11559 | 45.54486106 | -111.1692571 | 2021-02-09 05:23:30 | Gallatin, Montana, US |
2215345 | 2215345 | 2021-01-30 | Malaysia | Negeri Sembilan | 11609 | 20 | 10531 | 1058 | 2.7258 | 101.9424 | 2021-01-31 05:22:42 | Negeri Sembilan, Malaysia | ||
3651817 | 3651817 | 2020-10-24 | Russia | Tula Oblast | 11609 | 409 | 10267 | 933 | 53.9570701 | 37.3690909 | 2020-10-25 04:24:36 | Tula Oblast, Russia | ||
1515627 | 1515627 | 2020-09-28 | Russia | Primorsky Krai | 11609 | 118 | 10014 | 1477 | 45.0819456 | 134.726645 | 2020-09-29 04:23:42 | Primorsky Krai, Russia | ||
2851467 | 2851467 | 2020-09-18 | US | Pennsylvania | Allegheny | 42003 | 11609 | 344 | 0 | 11265 | 40.46809875 | -79.98167747 | 2020-09-19 04:22:00 | Allegheny, Pennsylvania, US |
194739 | 194739 | 2020-08-31 | US | Florida | Collier | 12021 | 11609 | 176 | 0 | 11433 | 26.11091986 | -81.34687065 | 2020-09-01 04:28:31 | Collier, Florida, US |
3484457 | 3484457 | 2020-08-20 | Peru | Cajamarca | 11609 | 1033 | 0 | 10576 | -6.430284 | -78.74559599999998 | 2020-08-21 04:27:41 | Cajamarca, Peru | ||
1920154 | 1920154 | 2020-08-10 | US | Arizona | Yuma | 4027 | 11609 | 289 | 0 | 11320 | 32.76895712 | -113.90666740000002 | 2020-08-11 04:35:08 | Yuma, Arizona, US |
3793336 | 3793336 | 2020-08-05 | Russia | Voronezh Oblast | 11609 | 88 | 9607 | 1914 | 50.9800393 | 40.15065070000001 | 2020-08-06 04:35:02 | Voronezh Oblast, Russia |
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]);