johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
72 rows where confirmed = 11815 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 6
- US 66
- Yemen 2
- Mexico 1
- Netherlands 1
- Tajikistan 1
- Vanuatu 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
322661 | 322661 | 2022-10-30 | US | Puerto Rico | Cabo Rojo | 72023 | 11815 | 0 | 0 | 18.040993 | -67.154391 | 2022-10-31 04:21:36 | Cabo Rojo, Puerto Rico, US | |
2263087 | 2263087 | 2022-10-02 | US | Virginia | Charlottesville | 51540 | 11815 | 82 | 0 | 38.03527919 | -78.48569588 | 2022-10-03 04:23:11 | Charlottesville, Virginia, US | |
2260832 | 2260832 | 2022-10-02 | US | Illinois | Woodford | 17203 | 11815 | 116 | 0 | 40.78579374 | -89.20973757 | 2022-10-03 04:23:11 | Woodford, Illinois, US | |
2998613 | 2998613 | 2022-10-01 | US | Virginia | Charlottesville | 51540 | 11815 | 82 | 0 | 38.03527919 | -78.48569588 | 2022-10-02 04:21:23 | Charlottesville, Virginia, US | |
2996358 | 2996358 | 2022-10-01 | US | Illinois | Woodford | 17203 | 11815 | 116 | 0 | 40.78579374 | -89.20973757 | 2022-10-02 04:21:23 | Woodford, Illinois, US | |
856939 | 856939 | 2022-09-30 | US | Virginia | Charlottesville | 51540 | 11815 | 82 | 0 | 38.03527919 | -78.48569588 | 2022-10-01 04:23:01 | Charlottesville, Virginia, US | |
854684 | 854684 | 2022-09-30 | US | Illinois | Woodford | 17203 | 11815 | 116 | 0 | 40.78579374 | -89.20973757 | 2022-10-01 04:23:01 | Woodford, Illinois, US | |
2378865 | 2378865 | 2022-09-29 | US | Virginia | Charlottesville | 51540 | 11815 | 82 | 0 | 38.03527919 | -78.48569588 | 2022-09-30 04:23:09 | Charlottesville, Virginia, US | |
2635178 | 2635178 | 2022-09-05 | US | Kentucky | Muhlenberg | 21177 | 11815 | 128 | 0 | 37.21425819 | -87.14632053 | 2022-09-06 04:21:02 | Muhlenberg, Kentucky, US | |
2988742 | 2988742 | 2022-09-04 | US | Kentucky | Muhlenberg | 21177 | 11815 | 128 | 0 | 37.21425819 | -87.14632053 | 2022-09-05 04:21:01 | Muhlenberg, Kentucky, US | |
2714427 | 2714427 | 2022-09-03 | US | Kentucky | Muhlenberg | 21177 | 11815 | 128 | 0 | 37.21425819 | -87.14632053 | 2022-09-04 04:21:22 | Muhlenberg, Kentucky, US | |
1395132 | 1395132 | 2022-09-02 | US | Kentucky | Muhlenberg | 21177 | 11815 | 128 | 0 | 37.21425819 | -87.14632053 | 2022-09-03 04:21:04 | Muhlenberg, Kentucky, US | |
3548961 | 3548961 | 2022-09-01 | US | Kentucky | Muhlenberg | 21177 | 11815 | 128 | 0 | 37.21425819 | -87.14632053 | 2022-09-02 04:21:07 | Muhlenberg, Kentucky, US | |
2347101 | 2347101 | 2022-08-31 | Vanuatu | 11815 | 14 | 0 | -15.3767 | 166.9592 | 2022-09-01 04:21:03 | Vanuatu | ||||
2344881 | 2344881 | 2022-08-31 | US | Kentucky | Muhlenberg | 21177 | 11815 | 128 | 0 | 37.21425819 | -87.14632053 | 2022-09-01 04:21:03 | Muhlenberg, Kentucky, US | |
3775361 | 3775361 | 2022-08-30 | US | Kentucky | Muhlenberg | 21177 | 11815 | 128 | 0 | 37.21425819 | -87.14632053 | 2022-08-31 04:20:57 | Muhlenberg, Kentucky, US | |
1681957 | 1681957 | 2022-08-29 | US | Kentucky | Muhlenberg | 21177 | 11815 | 128 | 0 | 37.21425819 | -87.14632053 | 2022-08-30 04:21:03 | Muhlenberg, Kentucky, US | |
2324335 | 2324335 | 2022-08-24 | US | Illinois | Effingham | 17049 | 11815 | 142 | 0 | 39.05935711 | -88.58969584 | 2022-08-25 04:21:13 | Effingham, Illinois, US | |
2337628 | 2337628 | 2022-07-27 | US | New York | Columbia | 36021 | 11815 | 150 | 0 | 42.24819348 | -73.63089095 | 2022-07-28 04:20:56 | Columbia, New York, US | |
1489818 | 1489818 | 2022-07-26 | US | New York | Columbia | 36021 | 11815 | 150 | 0 | 42.24819348 | -73.63089095 | 2022-07-27 04:21:04 | Columbia, New York, US | |
3984100 | 3984100 | 2022-06-15 | US | Louisiana | Avoyelles | 22009 | 11815 | 211 | 0 | 31.07796211 | -92.00079449 | 2022-06-16 04:20:55 | Avoyelles, Louisiana, US | |
973496 | 973496 | 2022-06-01 | US | Oklahoma | McClain | 40087 | 11815 | 137 | 0 | 35.01123903 | -97.44572302 | 2022-06-02 05:20:39 | McClain, Oklahoma, US | |
231803 | 231803 | 2022-05-31 | US | Oklahoma | McClain | 40087 | 11815 | 137 | 0 | 35.01123903 | -97.44572302 | 2022-06-01 04:20:55 | McClain, Oklahoma, US | |
3188568 | 3188568 | 2022-05-30 | US | Oklahoma | McClain | 40087 | 11815 | 137 | 0 | 35.01123903 | -97.44572302 | 2022-05-31 04:20:51 | McClain, Oklahoma, US | |
3200717 | 3200717 | 2022-05-29 | US | Oklahoma | McClain | 40087 | 11815 | 137 | 0 | 35.01123903 | -97.44572302 | 2022-05-30 04:20:50 | McClain, Oklahoma, US | |
2727595 | 2727595 | 2022-05-28 | US | Oklahoma | McClain | 40087 | 11815 | 137 | 0 | 35.01123903 | -97.44572302 | 2022-05-29 04:20:53 | McClain, Oklahoma, US | |
1316776 | 1316776 | 2022-05-27 | US | Oklahoma | McClain | 40087 | 11815 | 137 | 0 | 35.01123903 | -97.44572302 | 2022-05-28 04:21:07 | McClain, Oklahoma, US | |
1852568 | 1852568 | 2022-05-26 | US | Oklahoma | McClain | 40087 | 11815 | 137 | 0 | 35.01123903 | -97.44572302 | 2022-05-27 04:20:56 | McClain, Oklahoma, US | |
1227276 | 1227276 | 2022-04-14 | Yemen | 11815 | 2147 | 0 | 15.552726999999999 | 48.516388 | 2022-04-15 04:20:57 | Yemen | ||||
2446434 | 2446434 | 2022-04-13 | Yemen | 11815 | 2147 | 0 | 15.552726999999999 | 48.516388 | 2022-04-13 23:21:06 | Yemen | ||||
3731096 | 3731096 | 2022-04-03 | US | Georgia | Polk | 13233 | 11815 | 189 | 0 | 34.00267074 | -85.18677781 | 2022-04-04 04:20:51 | Polk, Georgia, US | |
500531 | 500531 | 2022-04-02 | US | Georgia | Polk | 13233 | 11815 | 189 | 0 | 34.00267074 | -85.18677781 | 2022-04-03 04:20:48 | Polk, Georgia, US | |
3351516 | 3351516 | 2022-04-01 | US | Georgia | Polk | 13233 | 11815 | 189 | 0 | 34.00267074 | -85.18677781 | 2022-04-02 04:20:47 | Polk, Georgia, US | |
1540821 | 1540821 | 2022-03-31 | US | Georgia | Polk | 13233 | 11815 | 189 | 0 | 34.00267074 | -85.18677781 | 2022-04-01 04:20:28 | Polk, Georgia, US | |
2320444 | 2320444 | 2022-03-16 | US | Indiana | Lawrence | 18093 | 11815 | 253 | 0 | 38.84112637 | -86.48361629 | 2022-03-17 04:20:56 | Lawrence, Indiana, US | |
1144455 | 1144455 | 2022-01-23 | US | Wisconsin | Dunn | 55033 | 11815 | 63 | 0 | 44.94562799 | -91.8962481 | 2022-01-24 04:21:12 | Dunn, Wisconsin, US | |
2836373 | 2836373 | 2022-01-22 | US | Wisconsin | Dunn | 55033 | 11815 | 63 | 0 | 44.94562799 | -91.8962481 | 2022-01-23 04:21:13 | Dunn, Wisconsin, US | |
3428491 | 3428491 | 2022-01-21 | US | Wisconsin | Dunn | 55033 | 11815 | 63 | 0 | 44.94562799 | -91.8962481 | 2022-01-22 04:21:13 | Dunn, Wisconsin, US | |
1961678 | 1961678 | 2022-01-20 | US | Indiana | Noble | 18113 | 11815 | 141 | 0 | 41.39672484 | -85.41966713 | 2022-01-21 04:21:09 | Noble, Indiana, US | |
3658854 | 3658854 | 2021-12-10 | US | Texas | Wise | 48497 | 11815 | 207 | 0 | 33.21570665 | -97.65460265 | 2021-12-11 04:22:45 | Wise, Texas, US | |
1233296 | 1233296 | 2021-11-28 | US | Michigan | Midland | 26111 | 11815 | 156 | 0 | 43.64330771 | -84.38804374 | 2021-11-29 04:22:30 | Midland, Michigan, US | |
1360003 | 1360003 | 2021-11-27 | US | Michigan | Midland | 26111 | 11815 | 156 | 0 | 43.64330771 | -84.38804374 | 2021-11-28 04:22:43 | Midland, Michigan, US | |
759994 | 759994 | 2021-11-26 | US | Michigan | Midland | 26111 | 11815 | 156 | 0 | 43.64330771 | -84.38804374 | 2021-11-27 04:22:45 | Midland, Michigan, US | |
1804411 | 1804411 | 2021-11-25 | US | Michigan | Midland | 26111 | 11815 | 156 | 0 | 43.64330771 | -84.38804374 | 2021-11-26 04:22:33 | Midland, Michigan, US | |
905845 | 905845 | 2021-11-24 | US | Michigan | Midland | 26111 | 11815 | 156 | 0 | 43.64330771 | -84.38804374 | 2021-11-25 04:22:33 | Midland, Michigan, US | |
3514773 | 3514773 | 2021-11-01 | US | Virginia | Lynchburg | 51680 | 11815 | 186 | 0 | 37.40021399 | -79.19888138 | 2021-11-02 04:22:03 | Lynchburg, Virginia, US | |
425719 | 425719 | 2021-10-10 | US | North Carolina | Surry | 37171 | 11815 | 220 | 0 | 36.41689489 | -80.69102283 | 2021-10-11 04:21:31 | Surry, North Carolina, US | |
2878576 | 2878576 | 2021-10-09 | US | North Carolina | Surry | 37171 | 11815 | 220 | 0 | 36.41689489 | -80.69102283 | 2021-10-10 04:21:38 | Surry, North Carolina, US | |
2878174 | 2878174 | 2021-10-09 | US | Missouri | St. Francois | 29187 | 11815 | 158 | 0 | 37.81214171 | -90.47598685 | 2021-10-10 04:21:38 | St. Francois, Missouri, US | |
2961742 | 2961742 | 2021-10-08 | US | North Carolina | Surry | 37171 | 11815 | 220 | 0 | 36.41689489 | -80.69102283 | 2021-10-09 04:21:34 | Surry, North Carolina, US | |
3835002 | 3835002 | 2021-10-05 | US | Ohio | Tuscarawas | 39157 | 11815 | 307 | 0 | 40.44214695 | -81.47226262 | 2021-10-06 04:21:33 | Tuscarawas, Ohio, US | |
988084 | 988084 | 2021-10-04 | US | Indiana | Kosciusko | 18085 | 11815 | 142 | 0 | 41.24521668 | -85.86312322 | 2021-10-05 04:21:27 | Kosciusko, Indiana, US | |
2773895 | 2773895 | 2021-09-30 | US | Idaho | Bannock | 16005 | 11815 | 145 | 0 | 42.67002716 | -112.2233311 | 2021-10-01 04:21:35 | Bannock, Idaho, US | |
1885403 | 1885403 | 2021-09-12 | US | Alabama | Talladega | 1121 | 11815 | 197 | 0 | 33.37823223 | -86.16886178 | 2021-09-13 04:21:15 | Talladega, Alabama, US | |
3018759 | 3018759 | 2021-08-01 | US | Virginia | Stafford | 51179 | 11815 | 83 | 0 | 38.41758738 | -77.45917053 | 2021-08-02 04:21:36 | Stafford, Virginia, US | |
3907382 | 3907382 | 2021-07-31 | US | Virginia | Stafford | 51179 | 11815 | 83 | 0 | 38.41758738 | -77.45917053 | 2021-08-01 04:21:50 | Stafford, Virginia, US | |
3299587 | 3299587 | 2021-07-30 | US | Virginia | Stafford | 51179 | 11815 | 83 | 0 | 38.41758738 | -77.45917053 | 2021-07-31 04:21:35 | Stafford, Virginia, US | |
410637 | 410637 | 2021-07-28 | US | North Carolina | Nash | 37127 | 11815 | 200 | 0 | 35.96575634 | -77.98422508 | 2021-07-29 04:21:33 | Nash, North Carolina, US | |
83177 | 83177 | 2021-05-25 | Mexico | Colima | 11815 | 1192 | 0 | 10623 | 19.1223 | -104.0072 | 2021-05-26 04:20:35 | Colima, Mexico | ||
2007709 | 2007709 | 2021-05-12 | US | Texas | Comal | 48091 | 11815 | 296 | 0 | 29.80811278 | -98.27647225 | 2021-05-13 04:20:51 | Comal, Texas, US | |
2022241 | 2022241 | 2021-04-20 | US | Louisiana | Rapides | 22079 | 11815 | 311 | 0 | 31.19778499 | -92.52997303 | 2021-04-21 04:21:14 | Rapides, Louisiana, US | |
2550355 | 2550355 | 2021-04-15 | US | Louisiana | Ascension | 22005 | 11815 | 162 | 0 | 30.20406249 | -90.91328409999998 | 2021-04-16 04:20:46 | Ascension, Louisiana, US | |
2360569 | 2360569 | 2021-03-08 | US | Indiana | Madison | 18095 | 11815 | 323 | 0 | 40.16143691 | -85.71964711 | 2021-03-09 05:28:19 | Madison, Indiana, US | |
1939433 | 1939433 | 2021-02-23 | US | Tennessee | Sevier | 47155 | 11815 | 160 | 0 | 11710 | 35.78077323 | -83.52244332 | 2021-02-24 05:29:16 | Sevier, Tennessee, US |
3981018 | 3981018 | 2021-02-10 | US | Ohio | Clark | 39023 | 11815 | 271 | 0 | 11544 | 39.91592258 | -83.78498252 | 2021-02-11 05:23:55 | Clark, Ohio, US |
1591137 | 1591137 | 2021-02-05 | US | Tennessee | Maury | 47119 | 11815 | 150 | 0 | 11700 | 35.6187413 | -87.07462444 | 2021-02-06 05:23:55 | Maury, Tennessee, US |
2470352 | 2470352 | 2021-01-22 | US | Wisconsin | La Crosse | 55063 | 11815 | 69 | 0 | 11746 | 43.90632465 | -91.11451093 | 2021-01-23 05:22:03 | La Crosse, Wisconsin, US |
2628144 | 2628144 | 2021-01-10 | US | North Carolina | Alamance | 37001 | 11815 | 164 | 0 | 11651 | 36.0434701 | -79.39976137 | 2021-01-11 05:21:50 | Alamance, North Carolina, US |
3836811 | 3836811 | 2020-11-21 | Tajikistan | 11815 | 86 | 11229 | 500 | 38.861 | 71.2761 | 2020-11-22 05:25:45 | Tajikistan | |||
3117612 | 3117612 | 2020-10-06 | Netherlands | Utrecht | 11815 | 454 | 0 | 11302 | 52.084251 | 5.163824 | 2020-10-07 04:23:40 | Utrecht, Netherlands | ||
1245917 | 1245917 | 2020-09-08 | US | New Jersey | Ocean | 34029 | 11815 | 1030 | 0 | 10785 | 39.8895449 | -74.28089251 | 2020-09-09 04:28:48 | Ocean, New Jersey, US |
1278822 | 1278822 | 2020-06-04 | US | Virginia | Fairfax | 51059 | 11815 | 403 | 0 | 11412 | 38.83677558 | -77.27565836 | 2020-06-05 02:33:06 | Fairfax, Virginia, 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]);