johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
154 rows where confirmed = 6118 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 9
- US 131
- Japan 15
- India 2
- Chile 1
- China 1
- Cuba 1
- Netherlands 1
- Russia 1
- San Marino 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2272911 | 2272911 | 2022-10-20 | US | Illinois | Edgar | 17045 | 6118 | 60 | 0 | 39.6809186 | -87.74759563 | 2022-10-21 04:22:23 | Edgar, Illinois, US | |
3753954 | 3753954 | 2022-10-13 | US | Arkansas | Conway | 5029 | 6118 | 73 | 0 | 35.26205537 | -92.70506566 | 2022-10-14 04:22:28 | Conway, Arkansas, US | |
3099714 | 3099714 | 2022-10-09 | US | New York | Schoharie | 36095 | 6118 | 39 | 0 | 42.58831742 | -74.4433903 | 2022-10-10 04:22:32 | Schoharie, New York, US | |
4003171 | 4003171 | 2022-10-08 | US | Arkansas | Lawrence | 5075 | 6118 | 86 | 0 | 36.04188196 | -91.10867198 | 2022-10-09 04:21:16 | Lawrence, Arkansas, US | |
2376017 | 2376017 | 2022-09-29 | US | Arkansas | Clark | 5019 | 6118 | 87 | 0 | 34.04613432 | -93.17484713 | 2022-09-30 04:23:09 | Clark, Arkansas, US | |
387229 | 387229 | 2022-09-23 | US | Tennessee | Unicoi | 47171 | 6118 | 101 | 0 | 36.10890856 | -82.43709629 | 2022-09-24 04:21:40 | Unicoi, Tennessee, US | |
3774105 | 3774105 | 2022-08-30 | Russia | Chukotka Autonomous Okrug | 6118 | 42 | 0 | 66.0006475 | 169.4900869 | 2022-08-31 04:20:57 | Chukotka Autonomous Okrug, Russia | |||
1878460 | 1878460 | 2022-08-28 | US | Kentucky | Spencer | 21215 | 6118 | 64 | 0 | 38.03223971 | -85.32749335 | 2022-08-29 04:21:06 | Spencer, Kentucky, US | |
2097587 | 2097587 | 2022-08-27 | US | Kentucky | Spencer | 21215 | 6118 | 64 | 0 | 38.03223971 | -85.32749335 | 2022-08-28 04:21:02 | Spencer, Kentucky, US | |
1533402 | 1533402 | 2022-08-26 | US | Kentucky | Spencer | 21215 | 6118 | 64 | 0 | 38.03223971 | -85.32749335 | 2022-08-27 04:20:57 | Spencer, Kentucky, US | |
2830289 | 2830289 | 2022-08-25 | US | Kentucky | Spencer | 21215 | 6118 | 64 | 0 | 38.03223971 | -85.32749335 | 2022-08-26 04:21:02 | Spencer, Kentucky, US | |
2324822 | 2324822 | 2022-08-24 | US | Kentucky | Spencer | 21215 | 6118 | 64 | 0 | 38.03223971 | -85.32749335 | 2022-08-25 04:21:13 | Spencer, Kentucky, US | |
1252231 | 1252231 | 2022-08-23 | US | Kentucky | Spencer | 21215 | 6118 | 64 | 0 | 38.03223971 | -85.32749335 | 2022-08-24 04:20:46 | Spencer, Kentucky, US | |
2854335 | 2854335 | 2022-08-22 | US | Kentucky | Spencer | 21215 | 6118 | 64 | 0 | 38.03223971 | -85.32749335 | 2022-08-23 04:20:56 | Spencer, Kentucky, US | |
992560 | 992560 | 2022-08-16 | US | Maine | Sagadahoc | 23023 | 6118 | 38 | 0 | 43.95415864 | -69.85074999 | 2022-08-17 04:20:59 | Sagadahoc, Maine, US | |
3650591 | 3650591 | 2022-08-14 | US | Tennessee | Wayne | 47181 | 6118 | 75 | 0 | 35.23868267 | -87.78644456 | 2022-08-15 04:20:59 | Wayne, Tennessee, US | |
3874905 | 3874905 | 2022-07-31 | US | Virginia | Fredericksburg | 51630 | 6118 | 41 | 0 | 38.2977863 | -77.4922454 | 2022-08-01 04:21:03 | Fredericksburg, Virginia, US | |
677659 | 677659 | 2022-07-30 | US | Virginia | Fredericksburg | 51630 | 6118 | 41 | 0 | 38.2977863 | -77.4922454 | 2022-07-31 04:21:02 | Fredericksburg, Virginia, US | |
1786858 | 1786858 | 2022-07-29 | US | Virginia | Fredericksburg | 51630 | 6118 | 41 | 0 | 38.2977863 | -77.4922454 | 2022-07-30 04:20:42 | Fredericksburg, Virginia, US | |
902882 | 902882 | 2022-07-22 | US | Puerto Rico | Aibonito | 72009 | 6118 | 0 | 0 | 18.131361 | -66.264131 | 2022-07-23 04:20:53 | Aibonito, Puerto Rico, US | |
2791251 | 2791251 | 2022-07-10 | US | New Mexico | Taos | 35055 | 6118 | 96 | 0 | 36.58006022 | -105.6310198 | 2022-07-11 04:20:46 | Taos, New Mexico, US | |
145127 | 145127 | 2022-07-09 | US | Texas | Karnes | 48255 | 6118 | 71 | 0 | 28.90705334 | -97.85960149 | 2022-07-10 04:20:54 | Karnes, Texas, US | |
144204 | 144204 | 2022-07-09 | US | New Mexico | Taos | 35055 | 6118 | 96 | 0 | 36.58006022 | -105.6310198 | 2022-07-10 04:20:54 | Taos, New Mexico, US | |
1419304 | 1419304 | 2022-07-08 | US | New Mexico | Taos | 35055 | 6118 | 96 | 0 | 36.58006022 | -105.6310198 | 2022-07-09 04:20:59 | Taos, New Mexico, US | |
2743939 | 2743939 | 2022-07-07 | US | Tennessee | Chester | 47023 | 6118 | 99 | 0 | 35.42527478 | -88.6095842 | 2022-07-08 04:20:56 | Chester, Tennessee, US | |
3970108 | 3970108 | 2022-07-05 | US | Wisconsin | Kewaunee | 55061 | 6118 | 60 | 0 | 44.51727459 | -87.61468386 | 2022-07-06 04:20:58 | Kewaunee, Wisconsin, US | |
3081619 | 3081619 | 2022-07-04 | US | Wisconsin | Kewaunee | 55061 | 6118 | 60 | 0 | 44.51727459 | -87.61468386 | 2022-07-05 04:20:45 | Kewaunee, Wisconsin, US | |
167199 | 167199 | 2022-06-21 | US | Indiana | Washington | 18175 | 6118 | 87 | 0 | 38.60219804 | -86.1049363 | 2022-06-22 04:20:54 | Washington, Indiana, US | |
1764482 | 1764482 | 2022-06-20 | US | Indiana | Washington | 18175 | 6118 | 87 | 0 | 38.60219804 | -86.1049363 | 2022-06-21 04:20:56 | Washington, Indiana, US | |
2533943 | 2533943 | 2022-05-12 | US | California | Del Norte | 6015 | 6118 | 50 | 0 | 41.74228275 | -123.8974063 | 2022-05-13 04:20:51 | Del Norte, California, US | |
1574751 | 1574751 | 2022-05-03 | US | Oregon | Crook | 41013 | 6118 | 79 | 0 | 44.14230227 | -120.356297 | 2022-05-04 04:20:59 | Crook, Oregon, US | |
1572632 | 1572632 | 2022-05-03 | US | Arkansas | Jackson | 5067 | 6118 | 63 | 0 | 35.59802983 | -91.21494602 | 2022-05-04 04:20:59 | Jackson, Arkansas, US | |
466184 | 466184 | 2022-05-02 | US | Puerto Rico | Vega Alta | 72143 | 6118 | 0 | 0 | 18.409346 | -66.33725 | 2022-05-03 04:21:00 | Vega Alta, Puerto Rico, US | |
1327806 | 1327806 | 2022-04-26 | US | Maine | Knox | 23013 | 6118 | 35 | 0 | 44.11486325 | -69.10529169 | 2022-04-27 04:20:52 | Knox, Maine, US | |
3725577 | 3725577 | 2022-04-25 | US | Virginia | Mecklenburg | 51117 | 6118 | 122 | 0 | 36.67882005 | -78.36131056 | 2022-04-26 04:20:51 | Mecklenburg, Virginia, US | |
2032145 | 2032145 | 2022-04-24 | US | Virginia | Mecklenburg | 51117 | 6118 | 122 | 0 | 36.67882005 | -78.36131056 | 2022-04-25 04:20:56 | Mecklenburg, Virginia, US | |
749720 | 749720 | 2022-04-23 | US | Virginia | Mecklenburg | 51117 | 6118 | 122 | 0 | 36.67882005 | -78.36131056 | 2022-04-24 04:20:56 | Mecklenburg, Virginia, US | |
3440205 | 3440205 | 2022-04-22 | US | Virginia | Mecklenburg | 51117 | 6118 | 122 | 0 | 36.67882005 | -78.36131056 | 2022-04-23 04:20:50 | Mecklenburg, Virginia, US | |
2445353 | 2445353 | 2022-04-13 | US | Oklahoma | Seminole | 40133 | 6118 | 133 | 0 | 35.16478725 | -96.61686741 | 2022-04-13 23:21:06 | Seminole, Oklahoma, US | |
1951110 | 1951110 | 2022-04-12 | US | Oklahoma | Seminole | 40133 | 6118 | 133 | 0 | 35.16478725 | -96.61686741 | 2022-04-13 04:21:03 | Seminole, Oklahoma, US | |
3208863 | 3208863 | 2022-04-11 | US | Oklahoma | Seminole | 40133 | 6118 | 133 | 0 | 35.16478725 | -96.61686741 | 2022-04-12 04:20:49 | Seminole, Oklahoma, US | |
1578749 | 1578749 | 2022-04-10 | US | Oklahoma | Seminole | 40133 | 6118 | 133 | 0 | 35.16478725 | -96.61686741 | 2022-04-11 04:21:02 | Seminole, Oklahoma, US | |
1654991 | 1654991 | 2022-04-09 | US | Oklahoma | Seminole | 40133 | 6118 | 133 | 0 | 35.16478725 | -96.61686741 | 2022-04-10 04:20:52 | Seminole, Oklahoma, US | |
2118313 | 2118313 | 2022-04-08 | US | Oklahoma | Seminole | 40133 | 6118 | 133 | 0 | 35.16478725 | -96.61686741 | 2022-04-09 04:20:42 | Seminole, Oklahoma, US | |
3322837 | 3322837 | 2022-04-07 | US | Oklahoma | Seminole | 40133 | 6118 | 133 | 0 | 35.16478725 | -96.61686741 | 2022-04-08 04:20:48 | Seminole, Oklahoma, US | |
160384 | 160384 | 2022-03-29 | US | North Carolina | Transylvania | 37175 | 6118 | 71 | 0 | 35.20383864 | -82.79638423 | 2022-03-30 04:20:45 | Transylvania, North Carolina, US | |
1438955 | 1438955 | 2022-03-28 | US | North Carolina | Transylvania | 37175 | 6118 | 71 | 0 | 35.20383864 | -82.79638423 | 2022-03-29 04:20:46 | Transylvania, North Carolina, US | |
26454 | 26454 | 2022-03-20 | US | Nebraska | Cass | 31025 | 6118 | 16 | 0 | 40.90899107 | -96.13971217 | 2022-03-21 04:20:50 | Cass, Nebraska, US | |
1658464 | 1658464 | 2022-03-19 | US | Nebraska | Cass | 31025 | 6118 | 16 | 0 | 40.90899107 | -96.13971217 | 2022-03-20 04:20:45 | Cass, Nebraska, US | |
338181 | 338181 | 2022-03-18 | US | New York | Lewis | 36049 | 6118 | 49 | 0 | 43.784415700000004 | -75.44903992 | 2022-03-19 04:20:47 | Lewis, New York, US | |
337990 | 337990 | 2022-03-18 | US | Nebraska | Cass | 31025 | 6118 | 16 | 0 | 40.90899107 | -96.13971217 | 2022-03-19 04:20:47 | Cass, Nebraska, US | |
696634 | 696634 | 2022-03-17 | US | New York | Lewis | 36049 | 6118 | 49 | 0 | 43.784415700000004 | -75.44903992 | 2022-03-18 04:20:55 | Lewis, New York, US | |
263586 | 263586 | 2022-03-15 | US | Nebraska | Cass | 31025 | 6118 | 16 | 0 | 40.90899107 | -96.13971217 | 2022-03-16 04:20:50 | Cass, Nebraska, US | |
2666438 | 2666438 | 2022-03-04 | US | Colorado | Montezuma | 8083 | 6118 | 76 | 0 | 37.33859579 | -108.59588570000001 | 2022-03-05 04:21:10 | Montezuma, Colorado, US | |
2014073 | 2014073 | 2022-02-06 | US | Kentucky | Allen | 21003 | 6118 | 90 | 0 | 36.75197631 | -86.19457544 | 2022-02-07 04:21:05 | Allen, Kentucky, US | |
1295402 | 1295402 | 2022-02-05 | US | Kentucky | Allen | 21003 | 6118 | 90 | 0 | 36.75197631 | -86.19457544 | 2022-02-06 04:21:00 | Allen, Kentucky, US | |
2328730 | 2328730 | 2022-02-04 | US | Kentucky | Allen | 21003 | 6118 | 90 | 0 | 36.75197631 | -86.19457544 | 2022-02-05 04:21:05 | Allen, Kentucky, US | |
1782890 | 1782890 | 2022-01-27 | US | West Virginia | Nicholas | 54067 | 6118 | 80 | 0 | 38.29617706 | -80.79759588 | 2022-01-28 04:21:09 | Nicholas, West Virginia, US | |
1782794 | 1782794 | 2022-01-27 | US | Virginia | Salem | 51775 | 6118 | 86 | 0 | 37.2836193 | -80.06219455 | 2022-01-28 04:21:09 | Salem, Virginia, US | |
3608095 | 3608095 | 2021-12-25 | US | Texas | Bee | 48025 | 6118 | 136 | 0 | 28.41761668 | -97.74215593 | 2021-12-26 04:21:50 | Bee, Texas, US | |
603 | 603 | 2021-12-02 | San Marino | 6118 | 93 | 0 | 43.9424 | 12.4578 | 2021-12-03 04:23:05 | San Marino | ||||
724772 | 724772 | 2021-11-20 | US | New York | Tioga | 36107 | 6118 | 73 | 0 | 42.16852837 | -76.30835812 | 2021-11-21 04:22:13 | Tioga, New York, US | |
162038 | 162038 | 2021-11-19 | Japan | Nagasaki | 6118 | 73 | 0 | 33.235712 | 129.608033 | 2021-11-20 04:22:17 | Nagasaki, Japan | |||
3288925 | 3288925 | 2021-11-18 | Japan | Nagasaki | 6118 | 73 | 0 | 33.235712 | 129.608033 | 2021-11-19 04:21:40 | Nagasaki, Japan | |||
447381 | 447381 | 2021-11-17 | Japan | Nagasaki | 6118 | 73 | 0 | 33.235712 | 129.608033 | 2021-11-18 04:21:33 | Nagasaki, Japan | |||
3342631 | 3342631 | 2021-11-16 | Japan | Nagasaki | 6118 | 73 | 0 | 33.235712 | 129.608033 | 2021-11-17 04:21:48 | Nagasaki, Japan | |||
2287467 | 2287467 | 2021-11-15 | Japan | Nagasaki | 6118 | 73 | 0 | 33.235712 | 129.608033 | 2021-11-16 04:21:10 | Nagasaki, Japan | |||
1322241 | 1322241 | 2021-11-14 | Japan | Nagasaki | 6118 | 73 | 0 | 33.235712 | 129.608033 | 2021-11-15 04:21:36 | Nagasaki, Japan | |||
686367 | 686367 | 2021-11-13 | Japan | Nagasaki | 6118 | 73 | 0 | 33.235712 | 129.608033 | 2021-11-14 04:21:31 | Nagasaki, Japan | |||
714476 | 714476 | 2021-11-12 | Japan | Nagasaki | 6118 | 73 | 0 | 33.235712 | 129.608033 | 2021-11-13 04:21:38 | Nagasaki, Japan | |||
30986 | 30986 | 2021-11-11 | US | Oklahoma | Logan | 40083 | 6118 | 115 | 0 | 35.91899576 | -97.44352845 | 2021-11-12 04:22:01 | Logan, Oklahoma, US | |
28426 | 28426 | 2021-11-11 | Japan | Nagasaki | 6118 | 73 | 0 | 33.235712 | 129.608033 | 2021-11-12 04:22:01 | Nagasaki, Japan | |||
2847425 | 2847425 | 2021-11-10 | US | Oklahoma | Logan | 40083 | 6118 | 115 | 0 | 35.91899576 | -97.44352845 | 2021-11-11 04:21:45 | Logan, Oklahoma, US | |
2844865 | 2844865 | 2021-11-10 | Japan | Nagasaki | 6118 | 73 | 0 | 33.235712 | 129.608033 | 2021-11-11 04:21:45 | Nagasaki, Japan | |||
89695 | 89695 | 2021-11-09 | US | Oklahoma | Logan | 40083 | 6118 | 115 | 0 | 35.91899576 | -97.44352845 | 2021-11-10 04:21:38 | Logan, Oklahoma, US | |
87135 | 87135 | 2021-11-09 | Japan | Nagasaki | 6118 | 73 | 0 | 33.235712 | 129.608033 | 2021-11-10 04:21:38 | Nagasaki, Japan | |||
3642123 | 3642123 | 2021-11-08 | US | Oklahoma | Logan | 40083 | 6118 | 115 | 0 | 35.91899576 | -97.44352845 | 2021-11-09 04:21:36 | Logan, Oklahoma, US | |
3639563 | 3639563 | 2021-11-08 | Japan | Nagasaki | 6118 | 73 | 0 | 33.235712 | 129.608033 | 2021-11-09 04:21:36 | Nagasaki, Japan | |||
2003231 | 2003231 | 2021-11-07 | US | Oklahoma | Logan | 40083 | 6118 | 115 | 0 | 35.91899576 | -97.44352845 | 2021-11-08 04:21:43 | Logan, Oklahoma, US | |
2000671 | 2000671 | 2021-11-07 | Japan | Nagasaki | 6118 | 73 | 0 | 33.235712 | 129.608033 | 2021-11-08 04:21:43 | Nagasaki, Japan | |||
498222 | 498222 | 2021-11-06 | US | Oklahoma | Logan | 40083 | 6118 | 115 | 0 | 35.91899576 | -97.44352845 | 2021-11-07 04:21:53 | Logan, Oklahoma, US | |
495662 | 495662 | 2021-11-06 | Japan | Nagasaki | 6118 | 73 | 0 | 33.235712 | 129.608033 | 2021-11-07 04:21:53 | Nagasaki, Japan | |||
3124077 | 3124077 | 2021-11-05 | US | Oklahoma | Logan | 40083 | 6118 | 115 | 0 | 35.91899576 | -97.44352845 | 2021-11-06 04:21:51 | Logan, Oklahoma, US | |
3121517 | 3121517 | 2021-11-05 | Japan | Nagasaki | 6118 | 73 | 0 | 33.235712 | 129.608033 | 2021-11-06 04:21:51 | Nagasaki, Japan | |||
700975 | 700975 | 2021-11-04 | US | Oklahoma | Logan | 40083 | 6118 | 115 | 0 | 35.91899576 | -97.44352845 | 2021-11-05 04:21:54 | Logan, Oklahoma, US | |
279351 | 279351 | 2021-11-03 | US | Texas | Matagorda | 48321 | 6118 | 156 | 0 | 28.81955746 | -96.01230294 | 2021-11-04 04:22:20 | Matagorda, Texas, US | |
278753 | 278753 | 2021-11-03 | US | Oklahoma | Logan | 40083 | 6118 | 115 | 0 | 35.91899576 | -97.44352845 | 2021-11-04 04:22:20 | Logan, Oklahoma, US | |
3513889 | 3513889 | 2021-11-01 | US | Ohio | Logan | 39091 | 6118 | 107 | 0 | 40.38996525 | -83.76784341 | 2021-11-02 04:22:03 | Logan, Ohio, US | |
684121 | 684121 | 2021-10-24 | US | Minnesota | Winona | 27169 | 6118 | 54 | 0 | 43.98772283 | -91.78081305 | 2021-10-25 04:22:31 | Winona, Minnesota, US | |
772129 | 772129 | 2021-10-23 | US | Minnesota | Winona | 27169 | 6118 | 54 | 0 | 43.98772283 | -91.78081305 | 2021-10-24 04:21:22 | Winona, Minnesota, US | |
655776 | 655776 | 2021-10-22 | US | Minnesota | Winona | 27169 | 6118 | 54 | 0 | 43.98772283 | -91.78081305 | 2021-10-23 04:21:32 | Winona, Minnesota, US | |
2876673 | 2876673 | 2021-10-09 | US | Arkansas | Boone | 5009 | 6118 | 114 | 0 | 36.3084504 | -93.09374925 | 2021-10-10 04:21:38 | Boone, Arkansas, US | |
3013707 | 3013707 | 2021-09-22 | US | North Carolina | Vance | 37181 | 6118 | 93 | 0 | 36.36880673 | -78.40670845 | 2021-09-23 04:21:43 | Vance, North Carolina, US | |
1817186 | 1817186 | 2021-09-19 | US | North Dakota | Morton | 38059 | 6118 | 104 | 0 | 46.71681782 | -101.2822377 | 2021-09-20 04:21:22 | Morton, North Dakota, US | |
2811379 | 2811379 | 2021-09-16 | US | Oregon | Polk | 41053 | 6118 | 69 | 0 | 44.90322804 | -123.4128888 | 2021-09-17 04:21:46 | Polk, Oregon, US | |
3281965 | 3281965 | 2021-09-05 | US | Indiana | Jackson | 18071 | 6118 | 79 | 0 | 38.90915820000001 | -86.03851889 | 2021-09-06 04:21:22 | Jackson, Indiana, US | |
249835 | 249835 | 2021-09-04 | US | California | Lassen | 6035 | 6118 | 25 | 0 | 40.67311306 | -120.59350990000002 | 2021-09-05 04:21:33 | Lassen, California, US | |
2353972 | 2353972 | 2021-08-10 | US | Oklahoma | Cherokee | 40021 | 6118 | 79 | 0 | 35.90692775 | -94.99980896 | 2021-08-11 04:21:58 | Cherokee, Oklahoma, US | |
652501 | 652501 | 2021-08-09 | US | Oklahoma | Cherokee | 40021 | 6118 | 79 | 0 | 35.90692775 | -94.99980896 | 2021-08-10 04:21:27 | Cherokee, Oklahoma, US | |
592163 | 592163 | 2021-08-08 | US | Oklahoma | Cherokee | 40021 | 6118 | 79 | 0 | 35.90692775 | -94.99980896 | 2021-08-09 04:21:24 | Cherokee, Oklahoma, 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]);