johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
314 rows where confirmed = 2227 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
720874 | 720874 | 2022-12-04 | US | North Dakota | Benson | 38005 | 2227 | 23 | 0 | 48.0683985 | -99.35916363 | 2022-12-05 04:20:58 | Benson, North Dakota, US | |
1641014 | 1641014 | 2022-11-20 | US | Colorado | Yuma | 8125 | 2227 | 27 | 0 | 40.00346839 | -102.4258673 | 2022-11-21 04:21:05 | Yuma, Colorado, US | |
2064571 | 2064571 | 2022-11-19 | US | Colorado | Yuma | 8125 | 2227 | 27 | 0 | 40.00346839 | -102.4258673 | 2022-11-20 04:21:08 | Yuma, Colorado, US | |
1755965 | 1755965 | 2022-11-18 | US | Colorado | Yuma | 8125 | 2227 | 27 | 0 | 40.00346839 | -102.4258673 | 2022-11-19 04:21:14 | Yuma, Colorado, US | |
1366991 | 1366991 | 2022-10-28 | US | Arkansas | Monroe | 5095 | 2227 | 37 | 0 | 34.6815935 | -91.20540287 | 2022-10-29 04:21:13 | Monroe, Arkansas, US | |
797991 | 797991 | 2022-10-24 | US | Wisconsin | Pepin | 55091 | 2227 | 19 | 0 | 44.58307413 | -91.99949611 | 2022-10-25 04:21:53 | Pepin, Wisconsin, US | |
3280446 | 3280446 | 2022-10-23 | US | Wisconsin | Pepin | 55091 | 2227 | 19 | 0 | 44.58307413 | -91.99949611 | 2022-10-24 04:22:29 | Pepin, Wisconsin, US | |
2271484 | 2271484 | 2022-10-22 | US | Wisconsin | Pepin | 55091 | 2227 | 19 | 0 | 44.58307413 | -91.99949611 | 2022-10-23 04:22:46 | Pepin, Wisconsin, US | |
1595784 | 1595784 | 2022-10-21 | US | Wisconsin | Pepin | 55091 | 2227 | 19 | 0 | 44.58307413 | -91.99949611 | 2022-10-22 04:22:53 | Pepin, Wisconsin, US | |
3253657 | 3253657 | 2022-10-11 | US | West Virginia | Pendleton | 54071 | 2227 | 22 | 0 | 38.68314479 | -79.35084086 | 2022-10-12 04:22:51 | Pendleton, West Virginia, US | |
2970916 | 2970916 | 2022-10-10 | US | West Virginia | Pendleton | 54071 | 2227 | 22 | 0 | 38.68314479 | -79.35084086 | 2022-10-11 04:23:05 | Pendleton, West Virginia, US | |
3100952 | 3100952 | 2022-10-09 | US | West Virginia | Pendleton | 54071 | 2227 | 22 | 0 | 38.68314479 | -79.35084086 | 2022-10-10 04:22:32 | Pendleton, West Virginia, US | |
4006177 | 4006177 | 2022-10-08 | US | West Virginia | Pendleton | 54071 | 2227 | 22 | 0 | 38.68314479 | -79.35084086 | 2022-10-09 04:21:16 | Pendleton, West Virginia, US | |
399774 | 399774 | 2022-10-07 | US | West Virginia | Pendleton | 54071 | 2227 | 22 | 0 | 38.68314479 | -79.35084086 | 2022-10-08 04:22:56 | Pendleton, West Virginia, US | |
1814345 | 1814345 | 2022-10-05 | US | Wisconsin | Menominee | 55078 | 2227 | 15 | 0 | 45.00422544 | -88.70950714 | 2022-10-06 04:21:22 | Menominee, Wisconsin, US | |
1812526 | 1812526 | 2022-10-05 | US | Minnesota | Murray | 27101 | 2227 | 20 | 0 | 44.02216709 | -95.76328482 | 2022-10-06 04:21:22 | Murray, Minnesota, US | |
132500 | 132500 | 2022-10-04 | US | Minnesota | Murray | 27101 | 2227 | 20 | 0 | 44.02216709 | -95.76328482 | 2022-10-05 04:23:06 | Murray, Minnesota, US | |
2687447 | 2687447 | 2022-10-03 | US | Minnesota | Murray | 27101 | 2227 | 20 | 0 | 44.02216709 | -95.76328482 | 2022-10-04 04:22:55 | Murray, Minnesota, US | |
2261514 | 2261514 | 2022-10-02 | US | Minnesota | Murray | 27101 | 2227 | 20 | 0 | 44.02216709 | -95.76328482 | 2022-10-03 04:23:11 | Murray, Minnesota, US | |
2997040 | 2997040 | 2022-10-01 | US | Minnesota | Murray | 27101 | 2227 | 20 | 0 | 44.02216709 | -95.76328482 | 2022-10-02 04:21:23 | Murray, Minnesota, US | |
855366 | 855366 | 2022-09-30 | US | Minnesota | Murray | 27101 | 2227 | 20 | 0 | 44.02216709 | -95.76328482 | 2022-10-01 04:23:01 | Murray, Minnesota, US | |
2377292 | 2377292 | 2022-09-29 | US | Minnesota | Murray | 27101 | 2227 | 20 | 0 | 44.02216709 | -95.76328482 | 2022-09-30 04:23:09 | Murray, Minnesota, US | |
115273 | 115273 | 2022-09-06 | US | Arkansas | Prairie | 5117 | 2227 | 42 | 0 | 34.83624419 | -91.55162157 | 2022-09-07 04:20:59 | Prairie, Arkansas, US | |
2635407 | 2635407 | 2022-09-05 | US | Michigan | Presque Isle | 26141 | 2227 | 61 | 0 | 45.34018577 | -83.91498656 | 2022-09-06 04:21:02 | Presque Isle, Michigan, US | |
2634245 | 2634245 | 2022-09-05 | US | Arkansas | Prairie | 5117 | 2227 | 42 | 0 | 34.83624419 | -91.55162157 | 2022-09-06 04:21:02 | Prairie, Arkansas, US | |
2988971 | 2988971 | 2022-09-04 | US | Michigan | Presque Isle | 26141 | 2227 | 61 | 0 | 45.34018577 | -83.91498656 | 2022-09-05 04:21:01 | Presque Isle, Michigan, US | |
2714656 | 2714656 | 2022-09-03 | US | Michigan | Presque Isle | 26141 | 2227 | 61 | 0 | 45.34018577 | -83.91498656 | 2022-09-04 04:21:22 | Presque Isle, Michigan, US | |
1395361 | 1395361 | 2022-09-02 | US | Michigan | Presque Isle | 26141 | 2227 | 61 | 0 | 45.34018577 | -83.91498656 | 2022-09-03 04:21:04 | Presque Isle, Michigan, US | |
3549190 | 3549190 | 2022-09-01 | US | Michigan | Presque Isle | 26141 | 2227 | 61 | 0 | 45.34018577 | -83.91498656 | 2022-09-02 04:21:07 | Presque Isle, Michigan, US | |
2345110 | 2345110 | 2022-08-31 | US | Michigan | Presque Isle | 26141 | 2227 | 61 | 0 | 45.34018577 | -83.91498656 | 2022-09-01 04:21:03 | Presque Isle, Michigan, US | |
3909993 | 3909993 | 2022-08-11 | US | Montana | Carbon | 30009 | 2227 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-08-12 04:20:54 | Carbon, Montana, US | |
1348310 | 1348310 | 2022-08-10 | US | Montana | Carbon | 30009 | 2227 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-08-11 04:20:49 | Carbon, Montana, US | |
1088065 | 1088065 | 2022-08-09 | US | Montana | Carbon | 30009 | 2227 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-08-10 04:20:57 | Carbon, Montana, US | |
3545480 | 3545480 | 2022-08-08 | US | Montana | Carbon | 30009 | 2227 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-08-09 04:20:34 | Carbon, Montana, US | |
1071883 | 1071883 | 2022-08-07 | US | Montana | Carbon | 30009 | 2227 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-08-08 04:21:08 | Carbon, Montana, US | |
1942471 | 1942471 | 2022-08-06 | US | Montana | Carbon | 30009 | 2227 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-08-07 04:20:54 | Carbon, Montana, US | |
882270 | 882270 | 2022-08-05 | US | Montana | Carbon | 30009 | 2227 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-08-06 04:20:56 | Carbon, Montana, US | |
880069 | 880069 | 2022-08-05 | China | Guangxi | 2227 | 2 | 0 | 23.8298 | 108.7881 | 2022-08-06 04:20:56 | Guangxi, China | |||
898904 | 898904 | 2022-07-24 | US | Puerto Rico | Las Marias | 72083 | 2227 | 0 | 0 | 18.23679 | -66.98362 | 2022-07-25 04:20:51 | Las Marias, Puerto Rico, US | |
3111014 | 3111014 | 2022-07-13 | US | Louisiana | Red River | 22081 | 2227 | 54 | 0 | 32.09530039 | -93.34213308 | 2022-07-14 04:20:57 | Red River, Louisiana, US | |
2241614 | 2241614 | 2022-06-28 | US | New Mexico | Sierra | 35051 | 2227 | 77 | 0 | 33.13028233 | -107.1925893 | 2022-06-29 04:20:59 | Sierra, New Mexico, US | |
3349072 | 3349072 | 2022-06-24 | US | North Dakota | Traill | 38097 | 2227 | 26 | 0 | 47.45367788 | -97.16323288 | 2022-06-25 04:20:57 | Traill, North Dakota, US | |
1650813 | 1650813 | 2022-06-23 | US | North Dakota | Traill | 38097 | 2227 | 26 | 0 | 47.45367788 | -97.16323288 | 2022-06-24 04:20:58 | Traill, North Dakota, US | |
232243 | 232243 | 2022-05-31 | US | Texas | Archer | 48009 | 2227 | 28 | 0 | 33.61569967 | -98.68754589 | 2022-06-01 04:20:55 | Archer, Texas, US | |
3896598 | 3896598 | 2022-05-19 | US | Colorado | Lincoln | 8073 | 2227 | 9 | 0 | 38.98749519 | -103.5136649 | 2022-05-20 04:20:57 | Lincoln, Colorado, US | |
2526271 | 2526271 | 2022-03-02 | US | Georgia | Wilkes | 13317 | 2227 | 47 | 0 | 33.78290391 | -82.74286107 | 2022-03-03 04:21:01 | Wilkes, Georgia, US | |
943739 | 943739 | 2022-02-28 | US | Georgia | Wilkes | 13317 | 2227 | 47 | 0 | 33.78290391 | -82.74286107 | 2022-03-01 04:21:09 | Wilkes, Georgia, US | |
2736357 | 2736357 | 2022-02-27 | US | Virginia | Essex | 51057 | 2227 | 28 | 0 | 37.93357639 | -76.94230311 | 2022-02-28 04:21:05 | Essex, Virginia, US | |
2733930 | 2733930 | 2022-02-27 | US | Georgia | Wilkes | 13317 | 2227 | 47 | 0 | 33.78290391 | -82.74286107 | 2022-02-28 04:21:05 | Wilkes, Georgia, US | |
3049510 | 3049510 | 2022-02-26 | US | Virginia | Essex | 51057 | 2227 | 28 | 0 | 37.93357639 | -76.94230311 | 2022-02-27 04:21:04 | Essex, Virginia, US | |
3047083 | 3047083 | 2022-02-26 | US | Georgia | Wilkes | 13317 | 2227 | 47 | 0 | 33.78290391 | -82.74286107 | 2022-02-27 04:21:04 | Wilkes, Georgia, US | |
578165 | 578165 | 2022-02-25 | US | Virginia | Essex | 51057 | 2227 | 28 | 0 | 37.93357639 | -76.94230311 | 2022-02-26 04:21:12 | Essex, Virginia, US | |
575738 | 575738 | 2022-02-25 | US | Georgia | Wilkes | 13317 | 2227 | 47 | 0 | 33.78290391 | -82.74286107 | 2022-02-26 04:21:12 | Wilkes, Georgia, US | |
1512314 | 1512314 | 2022-02-24 | US | Georgia | Wilkes | 13317 | 2227 | 47 | 0 | 33.78290391 | -82.74286107 | 2022-02-25 04:21:11 | Wilkes, Georgia, US | |
3718660 | 3718660 | 2022-02-21 | US | Arkansas | Cleveland | 5025 | 2227 | 34 | 0 | 33.89723187 | -92.18537045 | 2022-02-22 04:21:01 | Cleveland, Arkansas, US | |
3912494 | 3912494 | 2022-02-20 | US | Arkansas | Cleveland | 5025 | 2227 | 34 | 0 | 33.89723187 | -92.18537045 | 2022-02-21 04:21:05 | Cleveland, Arkansas, US | |
3876052 | 3876052 | 2022-02-19 | US | Arkansas | Cleveland | 5025 | 2227 | 34 | 0 | 33.89723187 | -92.18537045 | 2022-02-20 04:21:00 | Cleveland, Arkansas, US | |
3856308 | 3856308 | 2022-02-18 | US | Arkansas | Cleveland | 5025 | 2227 | 34 | 0 | 33.89723187 | -92.18537045 | 2022-02-19 04:21:11 | Cleveland, Arkansas, US | |
3672177 | 3672177 | 2022-02-15 | US | Arkansas | Scott | 5127 | 2227 | 38 | 0 | 34.85588887 | -94.0632176 | 2022-02-16 04:21:10 | Scott, Arkansas, US | |
2642583 | 2642583 | 2022-02-14 | US | Georgia | Johnson | 13167 | 2227 | 69 | 0 | 32.70211082 | -82.66166794 | 2022-02-15 04:21:09 | Johnson, Georgia, US | |
186871 | 186871 | 2022-02-13 | US | Georgia | Evans | 13109 | 2227 | 61 | 0 | 32.15328841 | -81.8870105 | 2022-02-14 04:20:51 | Evans, Georgia, US | |
316717 | 316717 | 2022-02-12 | US | Georgia | Evans | 13109 | 2227 | 61 | 0 | 32.15328841 | -81.8870105 | 2022-02-13 04:21:00 | Evans, Georgia, US | |
234043 | 234043 | 2022-02-11 | US | Georgia | Evans | 13109 | 2227 | 61 | 0 | 32.15328841 | -81.8870105 | 2022-02-12 04:21:06 | Evans, Georgia, US | |
1365280 | 1365280 | 2022-02-08 | US | Tennessee | Clay | 47027 | 2227 | 44 | 0 | 36.55151008 | -85.53930419 | 2022-02-09 04:21:04 | Clay, Tennessee, US | |
2660523 | 2660523 | 2022-01-31 | US | Puerto Rico | Ciales | 72039 | 2227 | 0 | 0 | 18.28885 | -66.516475 | 2022-02-01 04:21:11 | Ciales, Puerto Rico, US | |
3303545 | 3303545 | 2022-01-30 | US | Virginia | Floyd | 51063 | 2227 | 33 | 0 | 36.9302126 | -80.36738849 | 2022-01-31 04:21:09 | Floyd, Virginia, US | |
3065336 | 3065336 | 2022-01-29 | US | Virginia | Floyd | 51063 | 2227 | 33 | 0 | 36.9302126 | -80.36738849 | 2022-01-30 04:21:26 | Floyd, Virginia, US | |
3813270 | 3813270 | 2022-01-28 | US | Virginia | Floyd | 51063 | 2227 | 33 | 0 | 36.9302126 | -80.36738849 | 2022-01-29 04:21:10 | Floyd, Virginia, US | |
1963795 | 1963795 | 2022-01-20 | US | Texas | Trinity | 48455 | 2227 | 65 | 0 | 31.0879489 | -95.1367187 | 2022-01-21 04:21:09 | Trinity, Texas, US | |
3227822 | 3227822 | 2022-01-19 | US | Kentucky | Bath | 21011 | 2227 | 34 | 0 | 38.14735938 | -83.74588932 | 2022-01-20 04:21:07 | Bath, Kentucky, US | |
3465347 | 3465347 | 2022-01-18 | US | Iowa | Calhoun | 19025 | 2227 | 20 | 0 | 42.38521079 | -94.64046046 | 2022-01-19 04:21:23 | Calhoun, Iowa, US | |
1473286 | 1473286 | 2022-01-17 | US | Iowa | Calhoun | 19025 | 2227 | 20 | 0 | 42.38521079 | -94.64046046 | 2022-01-18 04:21:04 | Calhoun, Iowa, US | |
555960 | 555960 | 2022-01-16 | US | Iowa | Calhoun | 19025 | 2227 | 20 | 0 | 42.38521079 | -94.64046046 | 2022-01-17 04:21:08 | Calhoun, Iowa, US | |
3841681 | 3841681 | 2022-01-15 | US | Iowa | Calhoun | 19025 | 2227 | 20 | 0 | 42.38521079 | -94.64046046 | 2022-01-16 04:21:12 | Calhoun, Iowa, US | |
100496 | 100496 | 2022-01-14 | US | Iowa | Calhoun | 19025 | 2227 | 20 | 0 | 42.38521079 | -94.64046046 | 2022-01-15 04:21:07 | Calhoun, Iowa, US | |
3690791 | 3690791 | 2022-01-13 | US | Virginia | Brunswick | 51025 | 2227 | 37 | 0 | 36.76366949 | -77.8593436 | 2022-01-14 04:21:54 | Brunswick, Virginia, US | |
3688651 | 3688651 | 2022-01-13 | US | Iowa | Calhoun | 19025 | 2227 | 20 | 0 | 42.38521079 | -94.64046046 | 2022-01-14 04:21:54 | Calhoun, Iowa, US | |
3614235 | 3614235 | 2022-01-12 | US | Iowa | Calhoun | 19025 | 2227 | 20 | 0 | 42.38521079 | -94.64046046 | 2022-01-13 08:00:09 | Calhoun, Iowa, US | |
1282945 | 1282945 | 2022-01-05 | US | Idaho | Shoshone | 16079 | 2227 | 67 | 0 | 47.35364087 | -115.89167490000001 | 2022-01-06 04:22:09 | Shoshone, Idaho, US | |
1288872 | 1288872 | 2022-01-04 | US | South Dakota | Dewey | 46041 | 2227 | 35 | 0 | 45.15639647 | -100.8709139 | 2022-01-05 04:21:59 | Dewey, South Dakota, US | |
1287845 | 1287845 | 2022-01-04 | US | Mississippi | Perry | 28111 | 2227 | 57 | 0 | 31.17161885 | -88.99281835 | 2022-01-05 04:21:59 | Perry, Mississippi, US | |
1257394 | 1257394 | 2021-12-20 | US | Oregon | Hood River | 41027 | 2227 | 38 | 0 | 45.51872811 | -121.65520359999998 | 2021-12-21 03:21:27 | Hood River, Oregon, US | |
1717066 | 1717066 | 2021-12-16 | US | Florida | Lafayette | 12067 | 2227 | 26 | 0 | 29.98484137 | -83.18166636 | 2021-12-17 04:22:14 | Lafayette, Florida, US | |
1716037 | 1716037 | 2021-12-16 | Australia | Queensland | 2227 | 7 | 0 | -27.4698 | 153.0251 | 2021-12-17 04:22:14 | Queensland, Australia | |||
3498047 | 3498047 | 2021-12-15 | US | Mississippi | Walthall | 28147 | 2227 | 66 | 0 | 31.14971548 | -90.10446654 | 2021-12-16 04:22:11 | Walthall, Mississippi, US | |
3496900 | 3496900 | 2021-12-15 | US | Florida | Lafayette | 12067 | 2227 | 26 | 0 | 29.98484137 | -83.18166636 | 2021-12-16 04:22:11 | Lafayette, Florida, US | |
2088685 | 2088685 | 2021-12-14 | US | Florida | Lafayette | 12067 | 2227 | 26 | 0 | 29.98484137 | -83.18166636 | 2021-12-15 03:22:16 | Lafayette, Florida, US | |
783102 | 783102 | 2021-12-13 | US | Florida | Lafayette | 12067 | 2227 | 26 | 0 | 29.98484137 | -83.18166636 | 2021-12-14 04:22:38 | Lafayette, Florida, US | |
1661137 | 1661137 | 2021-12-12 | US | Florida | Lafayette | 12067 | 2227 | 26 | 0 | 29.98484137 | -83.18166636 | 2021-12-13 04:22:02 | Lafayette, Florida, US | |
1665153 | 1665153 | 2021-12-11 | US | Florida | Lafayette | 12067 | 2227 | 26 | 0 | 29.98484137 | -83.18166636 | 2021-12-12 04:22:12 | Lafayette, Florida, US | |
3656305 | 3656305 | 2021-12-10 | US | Florida | Lafayette | 12067 | 2227 | 26 | 0 | 29.98484137 | -83.18166636 | 2021-12-11 04:22:45 | Lafayette, Florida, US | |
1079100 | 1079100 | 2021-12-09 | US | Iowa | Cherokee | 19035 | 2227 | 47 | 0 | 42.73538914 | -95.62389402 | 2021-12-10 04:22:28 | Cherokee, Iowa, US | |
1078636 | 1078636 | 2021-12-09 | US | Florida | Lafayette | 12067 | 2227 | 26 | 0 | 29.98484137 | -83.18166636 | 2021-12-10 04:22:28 | Lafayette, Florida, US | |
551949 | 551949 | 2021-12-08 | US | Iowa | Cherokee | 19035 | 2227 | 47 | 0 | 42.73538914 | -95.62389402 | 2021-12-09 04:22:49 | Cherokee, Iowa, US | |
551485 | 551485 | 2021-12-08 | US | Florida | Lafayette | 12067 | 2227 | 26 | 0 | 29.98484137 | -83.18166636 | 2021-12-09 04:22:49 | Lafayette, Florida, US | |
405005 | 405005 | 2021-12-07 | US | Florida | Lafayette | 12067 | 2227 | 26 | 0 | 29.98484137 | -83.18166636 | 2021-12-08 04:22:46 | Lafayette, Florida, US | |
1031367 | 1031367 | 2021-12-06 | US | Illinois | Greene | 17061 | 2227 | 40 | 0 | 39.35907414 | -90.388865 | 2021-12-07 04:22:34 | Greene, Illinois, US | |
1031087 | 1031087 | 2021-12-06 | US | Florida | Lafayette | 12067 | 2227 | 26 | 0 | 29.98484137 | -83.18166636 | 2021-12-07 04:22:34 | Lafayette, Florida, US | |
1743912 | 1743912 | 2021-12-05 | US | Virginia | Martinsville | 51690 | 2227 | 94 | 0 | 36.68212094 | -79.86352771 | 2021-12-06 04:22:34 | Martinsville, Virginia, US | |
1741250 | 1741250 | 2021-12-05 | US | Florida | Lafayette | 12067 | 2227 | 26 | 0 | 29.98484137 | -83.18166636 | 2021-12-06 04:22:34 | Lafayette, Florida, 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]);