johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
78 rows where confirmed = 6416 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 7
- US 72
- Chile 1
- Dominican Republic 1
- India 1
- Italy 1
- Netherlands 1
- Russia 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
349359 | 349359 | 2022-12-14 | US | Illinois | Wayne | 17191 | 6416 | 91 | 0 | 38.42955355 | -88.42586459 | 2022-12-15 04:20:58 | Wayne, Illinois, US | |
2161008 | 2161008 | 2022-10-16 | US | Kentucky | Spencer | 21215 | 6416 | 65 | 0 | 38.03223971 | -85.32749335 | 2022-10-17 04:20:31 | Spencer, Kentucky, US | |
517205 | 517205 | 2022-10-15 | US | Kentucky | Spencer | 21215 | 6416 | 65 | 0 | 38.03223971 | -85.32749335 | 2022-10-16 04:22:39 | Spencer, Kentucky, US | |
516246 | 516246 | 2022-10-15 | US | Arkansas | Ouachita | 5103 | 6416 | 119 | 0 | 33.58839816 | -92.87795984 | 2022-10-16 04:22:39 | Ouachita, Arkansas, US | |
2034262 | 2034262 | 2022-10-14 | US | Kentucky | Spencer | 21215 | 6416 | 65 | 0 | 38.03223971 | -85.32749335 | 2022-10-15 04:22:00 | Spencer, Kentucky, US | |
3754950 | 3754950 | 2022-10-13 | US | Kentucky | Spencer | 21215 | 6416 | 65 | 0 | 38.03223971 | -85.32749335 | 2022-10-14 04:22:28 | Spencer, Kentucky, US | |
3215775 | 3215775 | 2022-10-12 | US | Kentucky | Spencer | 21215 | 6416 | 65 | 0 | 38.03223971 | -85.32749335 | 2022-10-13 04:22:39 | Spencer, Kentucky, US | |
3251624 | 3251624 | 2022-10-11 | US | Kentucky | Spencer | 21215 | 6416 | 65 | 0 | 38.03223971 | -85.32749335 | 2022-10-12 04:22:51 | Spencer, Kentucky, US | |
2970961 | 2970961 | 2022-10-10 | US | Wisconsin | Iowa | 55049 | 6416 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-10-11 04:23:05 | Iowa, Wisconsin, US | |
2968883 | 2968883 | 2022-10-10 | US | Kentucky | Spencer | 21215 | 6416 | 65 | 0 | 38.03223971 | -85.32749335 | 2022-10-11 04:23:05 | Spencer, Kentucky, US | |
1609819 | 1609819 | 2022-07-20 | US | Maine | Franklin | 23007 | 6416 | 63 | 0 | 44.97330019 | -70.44381045 | 2022-07-21 04:21:10 | Franklin, Maine, US | |
3112910 | 3112910 | 2022-07-13 | US | Virginia | Waynesboro | 51820 | 6416 | 68 | 0 | 38.06451466 | -78.90293905 | 2022-07-14 04:20:57 | Waynesboro, Virginia, US | |
2190369 | 2190369 | 2022-06-22 | US | Puerto Rico | Lares | 72081 | 6416 | 0 | 0 | 18.269035 | -66.867236 | 2022-06-23 04:20:55 | Lares, Puerto Rico, US | |
3727744 | 3727744 | 2022-06-07 | US | Louisiana | Pointe Coupee | 22077 | 6416 | 93 | 0 | 30.71409502 | -91.60209535 | 2022-06-08 04:20:55 | Pointe Coupee, Louisiana, US | |
3888234 | 3888234 | 2022-06-06 | US | Colorado | Delta | 8029 | 6416 | 139 | 0 | 38.86246243 | -107.8631342 | 2022-06-07 04:21:08 | Delta, Colorado, US | |
3917475 | 3917475 | 2022-05-01 | US | Kentucky | Marion | 21155 | 6416 | 82 | 0 | 37.55218078 | -85.26898542 | 2022-05-02 04:21:10 | Marion, Kentucky, US | |
2842279 | 2842279 | 2022-04-30 | US | Kentucky | Marion | 21155 | 6416 | 82 | 0 | 37.55218078 | -85.26898542 | 2022-05-01 04:20:57 | Marion, Kentucky, US | |
1158592 | 1158592 | 2022-04-29 | US | Kentucky | Marion | 21155 | 6416 | 82 | 0 | 37.55218078 | -85.26898542 | 2022-04-30 04:21:05 | Marion, Kentucky, US | |
1697774 | 1697774 | 2022-04-28 | US | Kentucky | Marion | 21155 | 6416 | 82 | 0 | 37.55218078 | -85.26898542 | 2022-04-29 04:20:59 | Marion, Kentucky, US | |
3853257 | 3853257 | 2022-04-27 | US | Kentucky | Marion | 21155 | 6416 | 82 | 0 | 37.55218078 | -85.26898542 | 2022-04-28 04:20:47 | Marion, Kentucky, US | |
1327687 | 1327687 | 2022-04-26 | US | Kentucky | Marion | 21155 | 6416 | 82 | 0 | 37.55218078 | -85.26898542 | 2022-04-27 04:20:52 | Marion, Kentucky, US | |
3723641 | 3723641 | 2022-04-25 | US | Kentucky | Marion | 21155 | 6416 | 82 | 0 | 37.55218078 | -85.26898542 | 2022-04-26 04:20:51 | Marion, Kentucky, US | |
3869070 | 3869070 | 2022-04-05 | US | Louisiana | Plaquemines | 22075 | 6416 | 45 | 0 | 29.42245447 | -89.60322085 | 2022-04-06 04:20:49 | Plaquemines, Louisiana, US | |
1436931 | 1436931 | 2022-03-28 | US | Alabama | Bibb | 1007 | 6416 | 101 | 0 | 32.99642064 | -87.12511459999996 | 2022-03-29 04:20:46 | Bibb, Alabama, US | |
336410 | 336410 | 2022-03-18 | US | Arkansas | Cleburne | 5023 | 6416 | 127 | 0 | 35.53864922 | -92.02640019 | 2022-03-19 04:20:47 | Cleburne, Arkansas, US | |
2321807 | 2321807 | 2022-03-16 | US | Ohio | Henry | 39069 | 6416 | 106 | 0 | 41.333964200000004 | -84.06830637 | 2022-03-17 04:20:56 | Henry, Ohio, US | |
264007 | 264007 | 2022-03-15 | US | Ohio | Henry | 39069 | 6416 | 106 | 0 | 41.333964200000004 | -84.06830637 | 2022-03-16 04:20:50 | Henry, Ohio, US | |
2266366 | 2266366 | 2022-03-14 | US | Ohio | Henry | 39069 | 6416 | 106 | 0 | 41.333964200000004 | -84.06830637 | 2022-03-15 04:20:47 | Henry, Ohio, US | |
3630432 | 3630432 | 2022-03-13 | US | Ohio | Henry | 39069 | 6416 | 106 | 0 | 41.333964200000004 | -84.06830637 | 2022-03-14 04:20:46 | Henry, Ohio, US | |
2142648 | 2142648 | 2022-03-09 | US | Ohio | Henry | 39069 | 6416 | 106 | 0 | 41.333964200000004 | -84.06830637 | 2022-03-10 04:20:48 | Henry, Ohio, US | |
922159 | 922159 | 2022-03-08 | US | Ohio | Henry | 39069 | 6416 | 106 | 0 | 41.333964200000004 | -84.06830637 | 2022-03-09 04:20:59 | Henry, Ohio, US | |
2528435 | 2528435 | 2022-03-02 | US | Texas | DeWitt | 48123 | 6416 | 96 | 0 | 29.08101855 | -97.35681170000001 | 2022-03-03 04:21:01 | DeWitt, Texas, US | |
1996027 | 1996027 | 2022-03-01 | US | Virginia | Louisa | 51109 | 6416 | 73 | 0 | 37.97850256 | -77.96274807 | 2022-03-02 04:21:07 | Louisa, Virginia, US | |
73293 | 73293 | 2022-02-07 | US | New Mexico | Luna | 35029 | 6416 | 113 | 0 | 32.18179341 | -107.75088259999998 | 2022-02-08 04:21:15 | Luna, New Mexico, US | |
1297080 | 1297080 | 2022-02-05 | US | Texas | Cass | 48067 | 6416 | 177 | 0 | 33.07499881 | -94.34646905 | 2022-02-06 04:21:00 | Cass, Texas, US | |
980034 | 980034 | 2022-02-01 | US | Indiana | Fayette | 18041 | 6416 | 125 | 0 | 39.63684962 | -85.17797541 | 2022-02-02 04:21:09 | Fayette, Indiana, US | |
1218829 | 1218829 | 2022-01-08 | US | Texas | Wood | 48499 | 6416 | 243 | 0 | 32.78722382 | -95.38236368 | 2022-01-09 04:21:46 | Wood, Texas, US | |
1391844 | 1391844 | 2022-01-07 | US | New Jersey | Unassigned | 90034 | 6416 | 0 | 0 | 41.13891592 | 0.0 | 2022-01-08 04:21:53 | Unassigned, New Jersey, US | |
2613542 | 2613542 | 2022-01-06 | US | West Virginia | Marshall | 54051 | 6416 | 133 | 0 | 39.86064362 | -80.66591062 | 2022-01-07 04:22:09 | Marshall, West Virginia, US | |
1283123 | 1283123 | 2022-01-05 | US | Indiana | Ripley | 18137 | 6416 | 103 | 0 | 39.10235626 | -85.26212744 | 2022-01-06 04:22:09 | Ripley, Indiana, US | |
1255744 | 1255744 | 2021-12-20 | US | Illinois | Christian | 17021 | 6416 | 84 | 0 | 39.54581621 | -89.27780482 | 2021-12-21 03:21:27 | Christian, Illinois, US | |
2089527 | 2089527 | 2021-12-14 | US | Maine | Aroostook | 23003 | 6416 | 90 | 0 | 46.65926321 | -68.59841248 | 2021-12-15 03:22:16 | Aroostook, Maine, US | |
3658102 | 3658102 | 2021-12-10 | US | Ohio | Putnam | 39137 | 6416 | 131 | 0 | 41.02094889 | -84.1336111 | 2021-12-11 04:22:45 | Putnam, Ohio, US | |
2197185 | 2197185 | 2021-12-03 | US | Maine | Oxford | 23017 | 6416 | 89 | 0 | 44.49952995 | -70.75682123 | 2021-12-04 04:22:18 | Oxford, Maine, US | |
1146786 | 1146786 | 2021-12-01 | US | Mississippi | Union | 28145 | 6416 | 98 | 0 | 34.49162015 | -89.00776006 | 2021-12-02 04:22:37 | Union, Mississippi, US | |
290140 | 290140 | 2021-10-31 | US | Nevada | Lyon | 32019 | 6416 | 107 | 0 | 39.01777974 | -119.18704790000001 | 2021-11-01 04:22:01 | Lyon, Nevada, US | |
2723146 | 2723146 | 2021-10-30 | US | Nevada | Lyon | 32019 | 6416 | 107 | 0 | 39.01777974 | -119.18704790000001 | 2021-10-31 04:22:08 | Lyon, Nevada, US | |
569248 | 569248 | 2021-10-29 | US | Nevada | Lyon | 32019 | 6416 | 107 | 0 | 39.01777974 | -119.18704790000001 | 2021-10-30 04:22:03 | Lyon, Nevada, US | |
6490 | 6490 | 2021-10-28 | US | Nevada | Lyon | 32019 | 6416 | 107 | 0 | 39.01777974 | -119.18704790000001 | 2021-10-29 04:22:03 | Lyon, Nevada, US | |
2809763 | 2809763 | 2021-09-16 | US | Illinois | Marion | 17121 | 6416 | 135 | 0 | 38.64963204 | -88.91899208 | 2021-09-17 04:21:46 | Marion, Illinois, US | |
247619 | 247619 | 2021-08-17 | US | North Carolina | Pender | 37141 | 6416 | 72 | 0 | 34.52265624 | -77.90352133 | 2021-08-18 04:21:35 | Pender, North Carolina, US | |
2676796 | 2676796 | 2021-07-18 | US | Tennessee | Roane | 47145 | 6416 | 109 | 0 | 35.84923189 | -84.52458689 | 2021-07-19 04:21:24 | Roane, Tennessee, US | |
3973980 | 3973980 | 2021-06-11 | US | Washington | Cowlitz | 53015 | 6416 | 85 | 0 | 46.19074721 | -122.6782231 | 2021-06-12 04:22:22 | Cowlitz, Washington, US | |
2257552 | 2257552 | 2021-05-19 | US | Mississippi | Lowndes | 28087 | 6416 | 148 | 0 | 33.47386518 | -88.44191529999998 | 2021-05-20 04:21:05 | Lowndes, Mississippi, US | |
3713062 | 3713062 | 2021-04-03 | US | Tennessee | Cumberland | 47035 | 6416 | 124 | 0 | 35.95271721 | -84.99840585 | 2021-04-04 04:20:49 | Cumberland, Tennessee, US | |
1580490 | 1580490 | 2021-03-13 | US | Alabama | Autauga | 1001 | 6416 | 95 | 0 | 32.53952745 | -86.64408227 | 2021-03-14 05:25:37 | Autauga, Alabama, US | |
355115 | 355115 | 2021-03-11 | US | South Carolina | Laurens | 45059 | 6416 | 162 | 0 | 34.48244419 | -82.00490796 | 2021-03-12 05:26:50 | Laurens, South Carolina, US | |
1617803 | 1617803 | 2021-03-05 | US | Maryland | Allegany | 24001 | 6416 | 200 | 0 | 6216 | 39.62357628 | -78.69280486 | 2021-03-06 04:23:41 | Allegany, Maryland, US |
1860189 | 1860189 | 2021-02-25 | US | New Mexico | Eddy | 35015 | 6416 | 116 | 0 | 6300 | 32.47167456 | -104.3053527 | 2021-02-26 05:22:40 | Eddy, New Mexico, US |
281042 | 281042 | 2021-02-24 | US | Georgia | Rockdale | 13247 | 6416 | 139 | 0 | 6277 | 33.65145002 | -84.02202167 | 2021-02-25 05:24:57 | Rockdale, Georgia, US |
3601414 | 3601414 | 2021-02-17 | US | Alabama | Jackson | 1071 | 6416 | 93 | 0 | 6323 | 34.78144169 | -85.99750489 | 2021-02-18 05:22:58 | Jackson, Alabama, US |
1531228 | 1531228 | 2021-02-09 | US | Virginia | Frederick | 51069 | 6416 | 47 | 0 | 6369 | 39.20172582 | -78.25974949 | 2021-02-10 05:22:41 | Frederick, Virginia, US |
2428781 | 2428781 | 2021-01-23 | US | Missouri | Christian | 29043 | 6416 | 61 | 0 | 6355 | 36.9711783 | -93.18537118 | 2021-01-24 05:22:35 | Christian, Missouri, US |
1096157 | 1096157 | 2021-01-20 | US | Nebraska | Hall | 31079 | 6416 | 104 | 0 | 6312 | 40.87257079 | -98.50218293 | 2021-01-21 05:22:01 | Hall, Nebraska, US |
1010701 | 1010701 | 2020-12-30 | US | Alabama | St. Clair | 1115 | 6416 | 72 | 0 | 6344 | 33.71902176 | -86.31029372 | 2020-12-31 05:22:49 | St. Clair, Alabama, US |
77286 | 77286 | 2020-12-03 | US | New Mexico | San Juan | 35045 | 6416 | 246 | 0 | 6170 | 36.50838318 | -108.320437 | 2020-12-04 05:27:27 | San Juan, New Mexico, US |
741294 | 741294 | 2020-12-02 | US | Tennessee | Washington | 47179 | 6416 | 114 | 0 | 6355 | 36.29472368 | -82.49454720000001 | 2020-12-03 05:28:22 | Washington, Tennessee, US |
2935229 | 2935229 | 2020-11-28 | Italy | Valle d'Aosta | 6416 | 310 | 4641 | 1465 | 45.73750286 | 7.320149366 | 2020-11-29 05:25:55 | Valle d'Aosta, Italy | ||
822468 | 822468 | 2020-11-19 | US | Guam | 66 | 6416 | 101 | 0 | 6315 | 13.4443 | 144.7937 | 2020-11-20 05:26:28 | Guam, US | |
376301 | 376301 | 2020-11-06 | Netherlands | Friesland | 6416 | 93 | 0 | 6316 | 53.087337 | 5.7925 | 2020-11-07 05:24:52 | Friesland, Netherlands | ||
2859140 | 2859140 | 2020-10-16 | US | North Carolina | Cumberland | 37051 | 6416 | 91 | 0 | 6325 | 35.04762133 | -78.82623165 | 2020-10-17 04:24:12 | Cumberland, North Carolina, US |
2837019 | 2837019 | 2020-09-21 | Russia | Karachay-Cherkess Republic | 6416 | 28 | 4703 | 1685 | 43.7368326 | 41.7267991 | 2020-09-22 04:23:00 | Karachay-Cherkess Republic, Russia | ||
3093206 | 3093206 | 2020-09-20 | Chile | Araucania | 6416 | 104 | 5843 | 469 | -38.9489 | -72.3311 | 2020-09-21 04:23:00 | Araucania, Chile | ||
1105501 | 1105501 | 2020-09-02 | India | Himachal Pradesh | 6416 | 43 | 4760 | 1613 | 31.927213 | 77.233081 | 2020-09-03 04:28:22 | Himachal Pradesh, India | ||
3564716 | 3564716 | 2020-08-25 | US | New Jersey | Burlington | 34005 | 6416 | 482 | 0 | 5934 | 39.87681124 | -74.66927768 | 2020-08-26 04:28:11 | Burlington, New Jersey, US |
3184101 | 3184101 | 2020-07-28 | US | Minnesota | Ramsey | 27123 | 6416 | 254 | 0 | 6162 | 45.01625271 | -93.09872295 | 2020-07-29 04:35:11 | Ramsey, Minnesota, US |
874265 | 874265 | 2020-05-24 | US | New Jersey | Mercer | 34021 | 6416 | 449 | 0 | 5967 | 40.28047017 | -74.70479631 | 2020-05-25 02:32:44 | Mercer, New Jersey, US |
271686 | 271686 | 2020-04-28 | Dominican Republic | 6416 | 286 | 1165 | 4965 | 18.7357 | -70.1627 | 2020-04-29 02:32:29 | Dominican Republic |
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]);