johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
237 rows where confirmed = 2866 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
544770 | 544770 | 2022-12-15 | US | Montana | Fergus | 30027 | 2866 | 60 | 0 | 47.26331584 | -109.2245206 | 2022-12-16 04:21:01 | Fergus, Montana, US | |
350298 | 350298 | 2022-12-14 | US | Montana | Fergus | 30027 | 2866 | 60 | 0 | 47.26331584 | -109.2245206 | 2022-12-15 04:20:58 | Fergus, Montana, US | |
309886 | 309886 | 2022-12-13 | US | Montana | Fergus | 30027 | 2866 | 60 | 0 | 47.26331584 | -109.2245206 | 2022-12-14 04:21:04 | Fergus, Montana, US | |
3554702 | 3554702 | 2022-11-27 | US | Texas | Childress | 48075 | 2866 | 34 | 0 | 34.5293041 | -100.2077916 | 2022-11-28 04:21:02 | Childress, Texas, US | |
2103182 | 2103182 | 2022-11-26 | US | Texas | Childress | 48075 | 2866 | 34 | 0 | 34.5293041 | -100.2077916 | 2022-11-27 04:21:05 | Childress, Texas, US | |
490673 | 490673 | 2022-11-25 | US | Texas | Childress | 48075 | 2866 | 34 | 0 | 34.5293041 | -100.2077916 | 2022-11-26 04:21:11 | Childress, Texas, US | |
3526502 | 3526502 | 2022-11-24 | US | Texas | Childress | 48075 | 2866 | 34 | 0 | 34.5293041 | -100.2077916 | 2022-11-25 04:21:06 | Childress, Texas, US | |
3315285 | 3315285 | 2022-11-23 | US | Texas | Childress | 48075 | 2866 | 34 | 0 | 34.5293041 | -100.2077916 | 2022-11-24 04:21:09 | Childress, Texas, US | |
2486609 | 2486609 | 2022-11-16 | US | Colorado | Bent | 8011 | 2866 | 49 | 0 | 37.95474293 | -103.0720195 | 2022-11-17 04:21:11 | Bent, Colorado, US | |
311715 | 311715 | 2022-11-13 | China | Yunnan | 2866 | 2 | 0 | 24.974 | 101.487 | 2022-11-14 04:21:09 | Yunnan, China | |||
2759655 | 2759655 | 2022-10-18 | US | Puerto Rico | Ceiba | 72037 | 2866 | 0 | 0 | 18.251818 | -65.666416 | 2022-10-19 04:22:26 | Ceiba, Puerto Rico, US | |
2027489 | 2027489 | 2022-10-17 | US | Puerto Rico | Ceiba | 72037 | 2866 | 0 | 0 | 18.251818 | -65.666416 | 2022-10-18 04:22:42 | Ceiba, Puerto Rico, US | |
2035203 | 2035203 | 2022-10-14 | US | North Dakota | Mercer | 38057 | 2866 | 24 | 0 | 47.31213126 | -101.8318399 | 2022-10-15 04:22:00 | Mercer, North Dakota, US | |
3755891 | 3755891 | 2022-10-13 | US | North Dakota | Mercer | 38057 | 2866 | 24 | 0 | 47.31213126 | -101.8318399 | 2022-10-14 04:22:28 | Mercer, North Dakota, US | |
2532147 | 2532147 | 2022-10-06 | US | Puerto Rico | Maunabo | 72095 | 2866 | 0 | 0 | 18.017889 | -65.922235 | 2022-10-07 04:23:08 | Maunabo, Puerto Rico, US | |
2687556 | 2687556 | 2022-10-03 | US | Mississippi | Tunica | 28143 | 2866 | 48 | 0 | 34.64967704 | -90.37481167 | 2022-10-04 04:22:55 | Tunica, Mississippi, US | |
2261623 | 2261623 | 2022-10-02 | US | Mississippi | Tunica | 28143 | 2866 | 48 | 0 | 34.64967704 | -90.37481167 | 2022-10-03 04:23:11 | Tunica, Mississippi, US | |
2997149 | 2997149 | 2022-10-01 | US | Mississippi | Tunica | 28143 | 2866 | 48 | 0 | 34.64967704 | -90.37481167 | 2022-10-02 04:21:23 | Tunica, Mississippi, US | |
855475 | 855475 | 2022-09-30 | US | Mississippi | Tunica | 28143 | 2866 | 48 | 0 | 34.64967704 | -90.37481167 | 2022-10-01 04:23:01 | Tunica, Mississippi, US | |
2377401 | 2377401 | 2022-09-29 | US | Mississippi | Tunica | 28143 | 2866 | 48 | 0 | 34.64967704 | -90.37481167 | 2022-09-30 04:23:09 | Tunica, Mississippi, US | |
1561952 | 1561952 | 2022-09-28 | US | Mississippi | Tunica | 28143 | 2866 | 48 | 0 | 34.64967704 | -90.37481167 | 2022-09-29 04:22:34 | Tunica, Mississippi, US | |
1979991 | 1979991 | 2022-09-25 | US | Virginia | Madison | 51113 | 2866 | 44 | 0 | 38.41531222 | -78.28220331 | 2022-09-26 04:20:52 | Madison, Virginia, US | |
2653158 | 2653158 | 2022-09-24 | US | Virginia | Madison | 51113 | 2866 | 44 | 0 | 38.41531222 | -78.28220331 | 2022-09-25 04:23:31 | Madison, Virginia, US | |
387598 | 387598 | 2022-09-23 | US | Virginia | Madison | 51113 | 2866 | 44 | 0 | 38.41531222 | -78.28220331 | 2022-09-24 04:21:40 | Madison, Virginia, US | |
3571272 | 3571272 | 2022-09-19 | US | Connecticut | Unassigned | 90009 | 2866 | 8 | 0 | 41.85853803 | 0.0 | 2022-09-20 04:22:48 | Unassigned, Connecticut, US | |
3550463 | 3550463 | 2022-09-01 | US | Tennessee | Houston | 47083 | 2866 | 62 | 0 | 36.28872054 | -87.71878828 | 2022-09-02 04:21:07 | Houston, Tennessee, US | |
3910010 | 3910010 | 2022-08-11 | US | Montana | Jefferson | 30043 | 2866 | 25 | 0 | 46.14907081 | -112.094396 | 2022-08-12 04:20:54 | Jefferson, Montana, US | |
1348327 | 1348327 | 2022-08-10 | US | Montana | Jefferson | 30043 | 2866 | 25 | 0 | 46.14907081 | -112.094396 | 2022-08-11 04:20:49 | Jefferson, Montana, US | |
1088082 | 1088082 | 2022-08-09 | US | Montana | Jefferson | 30043 | 2866 | 25 | 0 | 46.14907081 | -112.094396 | 2022-08-10 04:20:57 | Jefferson, Montana, US | |
3545497 | 3545497 | 2022-08-08 | US | Montana | Jefferson | 30043 | 2866 | 25 | 0 | 46.14907081 | -112.094396 | 2022-08-09 04:20:34 | Jefferson, Montana, US | |
1071900 | 1071900 | 2022-08-07 | US | Montana | Jefferson | 30043 | 2866 | 25 | 0 | 46.14907081 | -112.094396 | 2022-08-08 04:21:08 | Jefferson, Montana, US | |
1942488 | 1942488 | 2022-08-06 | US | Montana | Jefferson | 30043 | 2866 | 25 | 0 | 46.14907081 | -112.094396 | 2022-08-07 04:20:54 | Jefferson, Montana, US | |
882287 | 882287 | 2022-08-05 | US | Montana | Jefferson | 30043 | 2866 | 25 | 0 | 46.14907081 | -112.094396 | 2022-08-06 04:20:56 | Jefferson, Montana, US | |
1610845 | 1610845 | 2022-07-20 | US | Oklahoma | Nowata | 40105 | 2866 | 42 | 0 | 36.79843529 | -95.61902331 | 2022-07-21 04:21:10 | Nowata, Oklahoma, US | |
961478 | 961478 | 2022-07-19 | US | Oklahoma | Nowata | 40105 | 2866 | 42 | 0 | 36.79843529 | -95.61902331 | 2022-07-20 04:20:59 | Nowata, Oklahoma, US | |
3212865 | 3212865 | 2022-07-18 | US | Oklahoma | Nowata | 40105 | 2866 | 42 | 0 | 36.79843529 | -95.61902331 | 2022-07-19 04:20:58 | Nowata, Oklahoma, US | |
3408040 | 3408040 | 2022-07-17 | US | Oklahoma | Nowata | 40105 | 2866 | 42 | 0 | 36.79843529 | -95.61902331 | 2022-07-18 04:20:59 | Nowata, Oklahoma, US | |
2154240 | 2154240 | 2022-07-16 | US | Oklahoma | Nowata | 40105 | 2866 | 42 | 0 | 36.79843529 | -95.61902331 | 2022-07-17 04:21:15 | Nowata, Oklahoma, US | |
2152129 | 2152129 | 2022-07-16 | US | Arkansas | Chicot | 5017 | 2866 | 59 | 0 | 33.26458973 | -91.29539209 | 2022-07-17 04:21:15 | Chicot, Arkansas, US | |
2421473 | 2421473 | 2022-07-15 | US | Oklahoma | Nowata | 40105 | 2866 | 42 | 0 | 36.79843529 | -95.61902331 | 2022-07-16 04:21:05 | Nowata, Oklahoma, US | |
2419362 | 2419362 | 2022-07-15 | US | Arkansas | Chicot | 5017 | 2866 | 59 | 0 | 33.26458973 | -91.29539209 | 2022-07-16 04:21:05 | Chicot, Arkansas, US | |
3431548 | 3431548 | 2022-07-14 | US | Oklahoma | Nowata | 40105 | 2866 | 42 | 0 | 36.79843529 | -95.61902331 | 2022-07-15 04:20:53 | Nowata, Oklahoma, US | |
2240238 | 2240238 | 2022-06-28 | US | Georgia | Long | 13183 | 2866 | 35 | 0 | 31.75218791 | -81.74952375 | 2022-06-29 04:20:59 | Long, Georgia, US | |
2148480 | 2148480 | 2022-06-27 | US | Georgia | Long | 13183 | 2866 | 35 | 0 | 31.75218791 | -81.74952375 | 2022-06-28 04:20:58 | Long, Georgia, US | |
476281 | 476281 | 2022-06-26 | US | Georgia | Long | 13183 | 2866 | 35 | 0 | 31.75218791 | -81.74952375 | 2022-06-27 04:21:00 | Long, Georgia, US | |
939656 | 939656 | 2022-06-25 | US | Georgia | Long | 13183 | 2866 | 35 | 0 | 31.75218791 | -81.74952375 | 2022-06-26 04:21:02 | Long, Georgia, US | |
3347476 | 3347476 | 2022-06-24 | US | Georgia | Long | 13183 | 2866 | 35 | 0 | 31.75218791 | -81.74952375 | 2022-06-25 04:20:57 | Long, Georgia, US | |
1651702 | 1651702 | 2022-06-23 | US | Virginia | Clarke | 51043 | 2866 | 45 | 0 | 39.11271747 | -77.99199425 | 2022-06-24 04:20:58 | Clarke, Virginia, US | |
1649217 | 1649217 | 2022-06-23 | US | Georgia | Long | 13183 | 2866 | 35 | 0 | 31.75218791 | -81.74952375 | 2022-06-24 04:20:58 | Long, Georgia, US | |
2190864 | 2190864 | 2022-06-22 | US | Texas | Ward | 48475 | 2866 | 44 | 0 | 31.50999644 | -103.0927909 | 2022-06-23 04:20:55 | Ward, Texas, US | |
2188452 | 2188452 | 2022-06-22 | US | Georgia | Long | 13183 | 2866 | 35 | 0 | 31.75218791 | -81.74952375 | 2022-06-23 04:20:55 | Long, Georgia, US | |
949206 | 949206 | 2022-06-14 | US | North Carolina | Perquimans | 37143 | 2866 | 25 | 0 | 36.17847453 | -76.40603143 | 2022-06-15 04:20:54 | Perquimans, North Carolina, US | |
2981614 | 2981614 | 2022-06-13 | US | North Carolina | Perquimans | 37143 | 2866 | 25 | 0 | 36.17847453 | -76.40603143 | 2022-06-14 04:20:52 | Perquimans, North Carolina, US | |
2237740 | 2237740 | 2022-06-12 | US | North Carolina | Perquimans | 37143 | 2866 | 25 | 0 | 36.17847453 | -76.40603143 | 2022-06-13 04:21:14 | Perquimans, North Carolina, US | |
3143938 | 3143938 | 2022-06-11 | US | North Carolina | Perquimans | 37143 | 2866 | 25 | 0 | 36.17847453 | -76.40603143 | 2022-06-12 04:20:53 | Perquimans, North Carolina, US | |
1946854 | 1946854 | 2022-06-10 | US | North Carolina | Perquimans | 37143 | 2866 | 25 | 0 | 36.17847453 | -76.40603143 | 2022-06-11 04:21:01 | Perquimans, North Carolina, US | |
3159993 | 3159993 | 2022-06-09 | US | North Carolina | Perquimans | 37143 | 2866 | 25 | 0 | 36.17847453 | -76.40603143 | 2022-06-10 04:20:55 | Perquimans, North Carolina, US | |
1423460 | 1423460 | 2022-06-08 | US | North Carolina | Perquimans | 37143 | 2866 | 25 | 0 | 36.17847453 | -76.40603143 | 2022-06-09 04:20:54 | Perquimans, North Carolina, US | |
1188112 | 1188112 | 2022-05-18 | US | Virginia | Lexington | 51678 | 2866 | 40 | 0 | 37.78258621 | -79.44262866 | 2022-05-19 04:20:54 | Lexington, Virginia, US | |
3357445 | 3357445 | 2022-05-14 | US | Puerto Rico | Sabana Grande | 72121 | 2866 | 0 | 0 | 18.08282 | -66.943758 | 2022-05-15 04:20:53 | Sabana Grande, Puerto Rico, US | |
2892208 | 2892208 | 2022-04-21 | China | Henan | 2866 | 22 | 0 | 33.882 | 113.61399999999999 | 2022-04-22 04:20:45 | Henan, China | |||
2310327 | 2310327 | 2022-04-20 | US | Texas | Callahan | 48059 | 2866 | 72 | 0 | 32.29760619 | -99.37326312 | 2022-04-21 04:20:46 | Callahan, Texas, US | |
1949674 | 1949674 | 2022-04-12 | US | Iowa | Allamakee | 19005 | 2866 | 59 | 0 | 43.28383218 | -91.37860922 | 2022-04-13 04:21:03 | Allamakee, Iowa, US | |
3207427 | 3207427 | 2022-04-11 | US | Iowa | Allamakee | 19005 | 2866 | 59 | 0 | 43.28383218 | -91.37860922 | 2022-04-12 04:20:49 | Allamakee, Iowa, US | |
1577313 | 1577313 | 2022-04-10 | US | Iowa | Allamakee | 19005 | 2866 | 59 | 0 | 43.28383218 | -91.37860922 | 2022-04-11 04:21:02 | Allamakee, Iowa, US | |
1653555 | 1653555 | 2022-04-09 | US | Iowa | Allamakee | 19005 | 2866 | 59 | 0 | 43.28383218 | -91.37860922 | 2022-04-10 04:20:52 | Allamakee, Iowa, US | |
2116877 | 2116877 | 2022-04-08 | US | Iowa | Allamakee | 19005 | 2866 | 59 | 0 | 43.28383218 | -91.37860922 | 2022-04-09 04:20:42 | Allamakee, Iowa, US | |
3321401 | 3321401 | 2022-04-07 | US | Iowa | Allamakee | 19005 | 2866 | 59 | 0 | 43.28383218 | -91.37860922 | 2022-04-08 04:20:48 | Allamakee, Iowa, US | |
2801937 | 2801937 | 2022-04-06 | US | Iowa | Allamakee | 19005 | 2866 | 59 | 0 | 43.28383218 | -91.37860922 | 2022-04-07 04:20:53 | Allamakee, Iowa, US | |
2800562 | 2800562 | 2022-04-06 | China | Fujian | 2866 | 1 | 0 | 26.0789 | 117.9874 | 2022-04-07 04:20:53 | Fujian, China | |||
2140585 | 2140585 | 2022-03-09 | US | Alabama | Wilcox | 1131 | 2866 | 43 | 0 | 31.98773215 | -87.30891118 | 2022-03-10 04:20:48 | Wilcox, Alabama, US | |
575333 | 575333 | 2022-02-25 | US | Arkansas | Lee | 5077 | 2866 | 55 | 0 | 34.78498904 | -90.78383866 | 2022-02-26 04:21:12 | Lee, Arkansas, US | |
1511909 | 1511909 | 2022-02-24 | US | Arkansas | Lee | 5077 | 2866 | 55 | 0 | 34.78498904 | -90.78383866 | 2022-02-25 04:21:11 | Lee, Arkansas, US | |
1365210 | 1365210 | 2022-02-08 | US | South Dakota | Charles Mix | 46023 | 2866 | 32 | 0 | 43.20660134 | -98.58856175 | 2022-02-09 04:21:04 | Charles Mix, South Dakota, US | |
1364185 | 1364185 | 2022-02-08 | US | Mississippi | Montgomery | 28097 | 2866 | 67 | 0 | 33.49419589 | -89.61729103 | 2022-02-09 04:21:04 | Montgomery, Mississippi, US | |
2014699 | 2014699 | 2022-02-06 | US | Montana | Custer | 30017 | 2866 | 44 | 0 | 46.25319932 | -105.57375259999998 | 2022-02-07 04:21:05 | Custer, Montana, US | |
1296028 | 1296028 | 2022-02-05 | US | Montana | Custer | 30017 | 2866 | 44 | 0 | 46.25319932 | -105.57375259999998 | 2022-02-06 04:21:00 | Custer, Montana, US | |
2329356 | 2329356 | 2022-02-04 | US | Montana | Custer | 30017 | 2866 | 44 | 0 | 46.25319932 | -105.57375259999998 | 2022-02-05 04:21:05 | Custer, Montana, US | |
2476587 | 2476587 | 2022-02-03 | US | Oregon | Morrow | 41049 | 2866 | 26 | 0 | 45.41846568 | -119.584546 | 2022-02-04 04:21:10 | Morrow, Oregon, US | |
459981 | 459981 | 2022-02-02 | US | Colorado | Archuleta | 8007 | 2866 | 13 | 0 | 37.19474156 | -107.04768670000001 | 2022-02-03 04:21:21 | Archuleta, Colorado, US | |
3302965 | 3302965 | 2022-01-30 | US | Puerto Rico | Loiza | 72087 | 2866 | 0 | 0 | 18.425688 | -65.89943000000001 | 2022-01-31 04:21:09 | Loiza, Puerto Rico, US | |
3813120 | 3813120 | 2022-01-28 | US | Texas | Nolan | 48353 | 2866 | 89 | 0 | 32.30365282 | -100.4060208 | 2022-01-29 04:21:10 | Nolan, Texas, US | |
1782791 | 1782791 | 2022-01-27 | US | Virginia | Rockbridge | 51163 | 2866 | 73 | 0 | 37.81204314 | -79.44605905 | 2022-01-28 04:21:09 | Rockbridge, Virginia, US | |
1321001 | 1321001 | 2022-01-26 | US | Puerto Rico | Utuado | 72141 | 2866 | 0 | 0 | 18.271214 | -66.702984 | 2022-01-27 04:21:19 | Utuado, Puerto Rico, US | |
2055347 | 2055347 | 2022-01-25 | US | Washington | Unassigned | 90053 | 2866 | 5 | 0 | 48.82227976 | 0.0 | 2022-01-26 04:21:07 | Unassigned, Washington, US | |
1231078 | 1231078 | 2022-01-24 | US | Washington | Unassigned | 90053 | 2866 | 5 | 0 | 48.82227976 | 0.0 | 2022-01-25 04:21:05 | Unassigned, Washington, US | |
1143534 | 1143534 | 2022-01-23 | US | Oregon | Hood River | 41027 | 2866 | 38 | 0 | 45.51872811 | -121.65520359999998 | 2022-01-24 04:21:12 | Hood River, Oregon, US | |
2835452 | 2835452 | 2022-01-22 | US | Oregon | Hood River | 41027 | 2866 | 38 | 0 | 45.51872811 | -121.65520359999998 | 2022-01-23 04:21:13 | Hood River, Oregon, US | |
3427570 | 3427570 | 2022-01-21 | US | Oregon | Hood River | 41027 | 2866 | 38 | 0 | 45.51872811 | -121.65520359999998 | 2022-01-22 04:21:13 | Hood River, Oregon, US | |
1472874 | 1472874 | 2022-01-17 | US | Georgia | Bleckley | 13023 | 2866 | 86 | 0 | 32.43829035 | -83.33035166 | 2022-01-18 04:21:04 | Bleckley, Georgia, US | |
3522563 | 3522563 | 2022-01-02 | US | Texas | Jackson | 48239 | 2866 | 52 | 0 | 28.95472367 | -96.57749563 | 2022-01-03 02:22:25 | Jackson, Texas, US | |
785064 | 785064 | 2021-12-13 | US | Pennsylvania | Fulton | 42057 | 2866 | 40 | 0 | 39.92913544 | -78.11163677 | 2021-12-14 04:22:38 | Fulton, Pennsylvania, US | |
783354 | 783354 | 2021-12-13 | US | Illinois | Bond | 17005 | 2866 | 28 | 0 | 38.88829622 | -89.43534887 | 2021-12-14 04:22:38 | Bond, Illinois, US | |
1664914 | 1664914 | 2021-12-11 | US | Arkansas | Clay | 5021 | 2866 | 77 | 0 | 36.36826212 | -90.4148172 | 2021-12-12 04:22:12 | Clay, Arkansas, US | |
1743850 | 1743850 | 2021-12-05 | US | Virginia | Buchanan | 51027 | 2866 | 79 | 0 | 37.26818323 | -82.03749726 | 2021-12-06 04:22:34 | Buchanan, Virginia, US | |
141282 | 141282 | 2021-12-04 | US | Virginia | Buchanan | 51027 | 2866 | 79 | 0 | 37.26818323 | -82.03749726 | 2021-12-05 04:22:25 | Buchanan, Virginia, US | |
2198935 | 2198935 | 2021-12-03 | US | Virginia | Buchanan | 51027 | 2866 | 79 | 0 | 37.26818323 | -82.03749726 | 2021-12-04 04:22:18 | Buchanan, Virginia, US | |
2195821 | 2195821 | 2021-12-03 | Russia | Chukotka Autonomous Okrug | 2866 | 27 | 0 | 66.0006475 | 169.4900869 | 2021-12-04 04:22:18 | Chukotka Autonomous Okrug, Russia | |||
1943 | 1943 | 2021-12-02 | US | Michigan | Antrim | 26009 | 2866 | 43 | 0 | 44.99690221 | -85.15503082 | 2021-12-03 04:23:05 | Antrim, Michigan, US | |
1793 | 1793 | 2021-12-02 | US | Kentucky | Powell | 21197 | 2866 | 24 | 0 | 37.83218794 | -83.82553961 | 2021-12-03 04:23:05 | Powell, Kentucky, 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]);