johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
328 rows where confirmed = 2185 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 315
- Netherlands 3
- Russia 3
- Japan 2
- China 1
- India 1
- Tunisia 1
- United Kingdom 1
- West Bank and Gaza 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3176796 | 3176796 | 2022-12-19 | US | Tennessee | Van Buren | 47175 | 2185 | 48 | 0 | 35.69864497 | -85.45221699 | 2022-12-20 04:21:04 | Van Buren, Tennessee, US | |
1631623 | 1631623 | 2022-12-18 | US | Virginia | Buena Vista | 51530 | 2185 | 46 | 0 | 37.73484642 | -79.35296097 | 2022-12-19 04:21:03 | Buena Vista, Virginia, US | |
507002 | 507002 | 2022-12-17 | US | Virginia | Buena Vista | 51530 | 2185 | 46 | 0 | 37.73484642 | -79.35296097 | 2022-12-18 04:21:03 | Buena Vista, Virginia, US | |
3327574 | 3327574 | 2022-12-16 | US | Virginia | Buena Vista | 51530 | 2185 | 46 | 0 | 37.73484642 | -79.35296097 | 2022-12-17 04:21:04 | Buena Vista, Virginia, US | |
546086 | 546086 | 2022-12-15 | US | Virginia | Buena Vista | 51530 | 2185 | 46 | 0 | 37.73484642 | -79.35296097 | 2022-12-16 04:21:01 | Buena Vista, Virginia, US | |
833424 | 833424 | 2022-12-02 | China | Hunan | 2185 | 4 | 0 | 27.6104 | 111.7088 | 2022-12-03 04:21:02 | Hunan, China | |||
295442 | 295442 | 2022-11-15 | US | Virginia | Williamsburg | 51830 | 2185 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-11-16 04:21:09 | Williamsburg, Virginia, US | |
480204 | 480204 | 2022-11-08 | US | Colorado | Conejos | 8021 | 2185 | 57 | 0 | 37.201606 | -106.1917488 | 2022-11-09 04:21:22 | Conejos, Colorado, US | |
710877 | 710877 | 2022-11-01 | US | Alaska | Dillingham | 2070 | 2185 | 12 | 0 | 59.79603738 | -158.2381942 | 2022-11-02 04:22:09 | Dillingham, Alaska, US | |
3285326 | 3285326 | 2022-10-31 | US | Alaska | Dillingham | 2070 | 2185 | 12 | 0 | 59.79603738 | -158.2381942 | 2022-11-01 04:22:36 | Dillingham, Alaska, US | |
320359 | 320359 | 2022-10-30 | US | Alaska | Dillingham | 2070 | 2185 | 12 | 0 | 59.79603738 | -158.2381942 | 2022-10-31 04:21:36 | Dillingham, Alaska, US | |
912635 | 912635 | 2022-10-29 | US | Alaska | Dillingham | 2070 | 2185 | 12 | 0 | 59.79603738 | -158.2381942 | 2022-10-30 04:22:14 | Dillingham, Alaska, US | |
1366904 | 1366904 | 2022-10-28 | US | Alaska | Dillingham | 2070 | 2185 | 12 | 0 | 59.79603738 | -158.2381942 | 2022-10-29 04:21:13 | Dillingham, Alaska, US | |
3038759 | 3038759 | 2022-10-27 | US | Alaska | Dillingham | 2070 | 2185 | 12 | 0 | 59.79603738 | -158.2381942 | 2022-10-28 04:22:31 | Dillingham, Alaska, US | |
539179 | 539179 | 2022-10-26 | US | Alaska | Dillingham | 2070 | 2185 | 12 | 0 | 59.79603738 | -158.2381942 | 2022-10-27 04:22:01 | Dillingham, Alaska, US | |
2379022 | 2379022 | 2022-09-29 | US | West Virginia | Calhoun | 54013 | 2185 | 15 | 0 | 38.84315422 | -81.11934872 | 2022-09-30 04:23:09 | Calhoun, West Virginia, US | |
2769631 | 2769631 | 2022-09-26 | US | Colorado | Yuma | 8125 | 2185 | 27 | 0 | 40.00346839 | -102.4258673 | 2022-09-27 04:23:01 | Yuma, Colorado, US | |
1977284 | 1977284 | 2022-09-25 | US | Colorado | Yuma | 8125 | 2185 | 27 | 0 | 40.00346839 | -102.4258673 | 2022-09-26 04:20:52 | Yuma, Colorado, US | |
2650451 | 2650451 | 2022-09-24 | US | Colorado | Yuma | 8125 | 2185 | 27 | 0 | 40.00346839 | -102.4258673 | 2022-09-25 04:23:31 | Yuma, Colorado, US | |
384891 | 384891 | 2022-09-23 | US | Colorado | Yuma | 8125 | 2185 | 27 | 0 | 40.00346839 | -102.4258673 | 2022-09-24 04:21:40 | Yuma, Colorado, US | |
1624957 | 1624957 | 2022-09-22 | US | Colorado | Yuma | 8125 | 2185 | 27 | 0 | 40.00346839 | -102.4258673 | 2022-09-23 04:23:13 | Yuma, Colorado, US | |
3988536 | 3988536 | 2022-09-15 | US | Missouri | Harrison | 29081 | 2185 | 35 | 0 | 40.35570088 | -93.99222144 | 2022-09-16 04:21:19 | Harrison, Missouri, US | |
1891053 | 1891053 | 2022-09-14 | US | Missouri | Harrison | 29081 | 2185 | 35 | 0 | 40.35570088 | -93.99222144 | 2022-09-15 04:21:02 | Harrison, Missouri, US | |
374108 | 374108 | 2022-09-13 | US | Missouri | Harrison | 29081 | 2185 | 35 | 0 | 40.35570088 | -93.99222144 | 2022-09-14 04:20:44 | Harrison, Missouri, US | |
2396710 | 2396710 | 2022-09-12 | US | Missouri | Harrison | 29081 | 2185 | 35 | 0 | 40.35570088 | -93.99222144 | 2022-09-13 04:20:57 | Harrison, Missouri, US | |
3767788 | 3767788 | 2022-09-11 | US | Missouri | Harrison | 29081 | 2185 | 35 | 0 | 40.35570088 | -93.99222144 | 2022-09-12 04:20:58 | Harrison, Missouri, US | |
3826363 | 3826363 | 2022-09-10 | US | Missouri | Harrison | 29081 | 2185 | 35 | 0 | 40.35570088 | -93.99222144 | 2022-09-11 04:20:50 | Harrison, Missouri, US | |
964820 | 964820 | 2022-09-09 | US | Missouri | Harrison | 29081 | 2185 | 35 | 0 | 40.35570088 | -93.99222144 | 2022-09-10 04:21:10 | Harrison, Missouri, US | |
672289 | 672289 | 2022-07-21 | US | Montana | Carbon | 30009 | 2185 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-07-22 04:21:15 | Carbon, Montana, US | |
672287 | 672287 | 2022-07-21 | US | Montana | Blaine | 30005 | 2185 | 33 | 0 | 48.43175214 | -108.9582723 | 2022-07-22 04:21:15 | Blaine, Montana, US | |
1610252 | 1610252 | 2022-07-20 | US | Montana | Carbon | 30009 | 2185 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-07-21 04:21:10 | Carbon, Montana, US | |
1610250 | 1610250 | 2022-07-20 | US | Montana | Blaine | 30005 | 2185 | 33 | 0 | 48.43175214 | -108.9582723 | 2022-07-21 04:21:10 | Blaine, Montana, US | |
960885 | 960885 | 2022-07-19 | US | Montana | Carbon | 30009 | 2185 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-07-20 04:20:59 | Carbon, Montana, US | |
960883 | 960883 | 2022-07-19 | US | Montana | Blaine | 30005 | 2185 | 33 | 0 | 48.43175214 | -108.9582723 | 2022-07-20 04:20:59 | Blaine, Montana, US | |
3212272 | 3212272 | 2022-07-18 | US | Montana | Carbon | 30009 | 2185 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-07-19 04:20:58 | Carbon, Montana, US | |
3212270 | 3212270 | 2022-07-18 | US | Montana | Blaine | 30005 | 2185 | 33 | 0 | 48.43175214 | -108.9582723 | 2022-07-19 04:20:58 | Blaine, Montana, US | |
3407447 | 3407447 | 2022-07-17 | US | Montana | Carbon | 30009 | 2185 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-07-18 04:20:59 | Carbon, Montana, US | |
3407445 | 3407445 | 2022-07-17 | US | Montana | Blaine | 30005 | 2185 | 33 | 0 | 48.43175214 | -108.9582723 | 2022-07-18 04:20:59 | Blaine, Montana, US | |
2153647 | 2153647 | 2022-07-16 | US | Montana | Carbon | 30009 | 2185 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-07-17 04:21:15 | Carbon, Montana, US | |
2153645 | 2153645 | 2022-07-16 | US | Montana | Blaine | 30005 | 2185 | 33 | 0 | 48.43175214 | -108.9582723 | 2022-07-17 04:21:15 | Blaine, Montana, US | |
2420880 | 2420880 | 2022-07-15 | US | Montana | Carbon | 30009 | 2185 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-07-16 04:21:05 | Carbon, Montana, US | |
2420878 | 2420878 | 2022-07-15 | US | Montana | Blaine | 30005 | 2185 | 33 | 0 | 48.43175214 | -108.9582723 | 2022-07-16 04:21:05 | Blaine, Montana, US | |
2150977 | 2150977 | 2022-06-27 | US | Virginia | Fairfax City | 51600 | 2185 | 43 | 0 | 38.85157547 | -77.2977964 | 2022-06-28 04:20:58 | Fairfax City, Virginia, US | |
2150802 | 2150802 | 2022-06-27 | US | Texas | Live Oak | 48297 | 2185 | 42 | 0 | 28.35101362 | -98.1246786 | 2022-06-28 04:20:58 | Live Oak, Texas, US | |
560836 | 560836 | 2022-06-16 | US | Montana | Sanders | 30089 | 2185 | 51 | 0 | 47.67657534 | -115.1329916 | 2022-06-17 04:20:56 | Sanders, Montana, US | |
3984638 | 3984638 | 2022-06-15 | US | Montana | Sanders | 30089 | 2185 | 51 | 0 | 47.67657534 | -115.1329916 | 2022-06-16 04:20:55 | Sanders, Montana, US | |
948879 | 948879 | 2022-06-14 | US | Montana | Sanders | 30089 | 2185 | 51 | 0 | 47.67657534 | -115.1329916 | 2022-06-15 04:20:54 | Sanders, Montana, US | |
2981287 | 2981287 | 2022-06-13 | US | Montana | Sanders | 30089 | 2185 | 51 | 0 | 47.67657534 | -115.1329916 | 2022-06-14 04:20:52 | Sanders, Montana, US | |
2237413 | 2237413 | 2022-06-12 | US | Montana | Sanders | 30089 | 2185 | 51 | 0 | 47.67657534 | -115.1329916 | 2022-06-13 04:21:14 | Sanders, Montana, US | |
3143611 | 3143611 | 2022-06-11 | US | Montana | Sanders | 30089 | 2185 | 51 | 0 | 47.67657534 | -115.1329916 | 2022-06-12 04:20:53 | Sanders, Montana, US | |
1946527 | 1946527 | 2022-06-10 | US | Montana | Sanders | 30089 | 2185 | 51 | 0 | 47.67657534 | -115.1329916 | 2022-06-11 04:21:01 | Sanders, Montana, US | |
3510868 | 3510868 | 2022-06-05 | US | West Virginia | Doddridge | 54017 | 2185 | 18 | 0 | 39.27057157 | -80.70671527 | 2022-06-06 04:20:57 | Doddridge, West Virginia, US | |
3530945 | 3530945 | 2022-06-04 | US | West Virginia | Doddridge | 54017 | 2185 | 18 | 0 | 39.27057157 | -80.70671527 | 2022-06-05 04:20:55 | Doddridge, West Virginia, US | |
3137031 | 3137031 | 2022-06-03 | US | West Virginia | Doddridge | 54017 | 2185 | 18 | 0 | 39.27057157 | -80.70671527 | 2022-06-04 04:20:58 | Doddridge, West Virginia, US | |
972631 | 972631 | 2022-06-01 | US | Minnesota | Clearwater | 27029 | 2185 | 30 | 0 | 47.57992111 | -95.37790562 | 2022-06-02 05:20:39 | Clearwater, Minnesota, US | |
1851108 | 1851108 | 2022-05-26 | US | Indiana | Martin | 18101 | 2185 | 25 | 0 | 38.7099921 | -86.80373186 | 2022-05-27 04:20:56 | Martin, Indiana, US | |
2048984 | 2048984 | 2022-05-25 | US | Indiana | Martin | 18101 | 2185 | 25 | 0 | 38.7099921 | -86.80373186 | 2022-05-26 04:20:50 | Martin, Indiana, US | |
622995 | 622995 | 2022-05-22 | US | Indiana | Martin | 18101 | 2185 | 25 | 0 | 38.7099921 | -86.80373186 | 2022-05-26 04:20:50 | Martin, Indiana, US | |
3538796 | 3538796 | 2022-05-10 | US | Virginia | Falls Church | 51610 | 2185 | 17 | 0 | 38.88485255 | -77.17560759 | 2022-05-11 04:20:48 | Falls Church, Virginia, US | |
1398205 | 1398205 | 2022-05-06 | US | Arkansas | Nevada | 5099 | 2185 | 46 | 0 | 33.66340119 | -93.30632432 | 2022-05-07 04:21:09 | Nevada, Arkansas, US | |
2598560 | 2598560 | 2022-05-05 | US | Arkansas | Nevada | 5099 | 2185 | 46 | 0 | 33.66340119 | -93.30632432 | 2022-05-06 04:21:00 | Nevada, Arkansas, US | |
3266009 | 3266009 | 2022-05-04 | US | Arkansas | Nevada | 5099 | 2185 | 46 | 0 | 33.66340119 | -93.30632432 | 2022-05-05 04:20:55 | Nevada, Arkansas, US | |
1572648 | 1572648 | 2022-05-03 | US | Arkansas | Nevada | 5099 | 2185 | 46 | 0 | 33.66340119 | -93.30632432 | 2022-05-04 04:20:59 | Nevada, Arkansas, US | |
463908 | 463908 | 2022-05-02 | US | Arkansas | Nevada | 5099 | 2185 | 46 | 0 | 33.66340119 | -93.30632432 | 2022-05-03 04:21:00 | Nevada, Arkansas, US | |
3916547 | 3916547 | 2022-05-01 | US | Arkansas | Nevada | 5099 | 2185 | 46 | 0 | 33.66340119 | -93.30632432 | 2022-05-02 04:21:10 | Nevada, Arkansas, US | |
2841351 | 2841351 | 2022-04-30 | US | Arkansas | Nevada | 5099 | 2185 | 46 | 0 | 33.66340119 | -93.30632432 | 2022-05-01 04:20:57 | Nevada, Arkansas, US | |
1157664 | 1157664 | 2022-04-29 | US | Arkansas | Nevada | 5099 | 2185 | 46 | 0 | 33.66340119 | -93.30632432 | 2022-04-30 04:21:05 | Nevada, Arkansas, US | |
1696846 | 1696846 | 2022-04-28 | US | Arkansas | Nevada | 5099 | 2185 | 46 | 0 | 33.66340119 | -93.30632432 | 2022-04-29 04:20:59 | Nevada, Arkansas, US | |
3852329 | 3852329 | 2022-04-27 | US | Arkansas | Nevada | 5099 | 2185 | 46 | 0 | 33.66340119 | -93.30632432 | 2022-04-28 04:20:47 | Nevada, Arkansas, US | |
1326759 | 1326759 | 2022-04-26 | US | Arkansas | Nevada | 5099 | 2185 | 45 | 0 | 33.66340119 | -93.30632432 | 2022-04-27 04:20:52 | Nevada, Arkansas, US | |
3724635 | 3724635 | 2022-04-25 | US | North Dakota | Traill | 38097 | 2185 | 26 | 0 | 47.45367788 | -97.16323288 | 2022-04-26 04:20:51 | Traill, North Dakota, US | |
3722713 | 3722713 | 2022-04-25 | US | Arkansas | Nevada | 5099 | 2185 | 45 | 0 | 33.66340119 | -93.30632432 | 2022-04-26 04:20:51 | Nevada, Arkansas, US | |
2031203 | 2031203 | 2022-04-24 | US | North Dakota | Traill | 38097 | 2185 | 26 | 0 | 47.45367788 | -97.16323288 | 2022-04-25 04:20:56 | Traill, North Dakota, US | |
2029281 | 2029281 | 2022-04-24 | US | Arkansas | Nevada | 5099 | 2185 | 45 | 0 | 33.66340119 | -93.30632432 | 2022-04-25 04:20:56 | Nevada, Arkansas, US | |
748778 | 748778 | 2022-04-23 | US | North Dakota | Traill | 38097 | 2185 | 26 | 0 | 47.45367788 | -97.16323288 | 2022-04-24 04:20:56 | Traill, North Dakota, US | |
3439263 | 3439263 | 2022-04-22 | US | North Dakota | Traill | 38097 | 2185 | 26 | 0 | 47.45367788 | -97.16323288 | 2022-04-23 04:20:50 | Traill, North Dakota, US | |
2254139 | 2254139 | 2022-04-19 | US | Puerto Rico | Adjuntas | 72001 | 2185 | 0 | 0 | 18.180117000000006 | -66.754367 | 2022-04-20 04:20:45 | Adjuntas, Puerto Rico, US | |
1868930 | 1868930 | 2022-03-10 | US | Washington | Lincoln | 53043 | 2185 | 27 | 0 | 47.57705241 | -118.41943880000001 | 2022-03-11 04:20:50 | Lincoln, Washington, US | |
2143625 | 2143625 | 2022-03-09 | US | Washington | Lincoln | 53043 | 2185 | 27 | 0 | 47.57705241 | -118.41943880000001 | 2022-03-10 04:20:48 | Lincoln, Washington, US | |
2668987 | 2668987 | 2022-03-04 | US | Texas | Ochiltree | 48357 | 2185 | 48 | 0 | 36.27829105 | -100.8158184 | 2022-03-05 04:21:10 | Ochiltree, Texas, US | |
1512342 | 1512342 | 2022-02-24 | US | Idaho | Clearwater | 16035 | 2185 | 31 | 0 | 46.67459924 | -115.6622393 | 2022-02-25 04:21:11 | Clearwater, Idaho, US | |
1058783 | 1058783 | 2022-02-23 | US | Idaho | Clearwater | 16035 | 2185 | 31 | 0 | 46.67459924 | -115.6622393 | 2022-02-24 04:21:14 | Clearwater, Idaho, US | |
3823588 | 3823588 | 2022-02-16 | US | Texas | La Salle | 48283 | 2185 | 42 | 0 | 28.34453111 | -99.09908775 | 2022-02-17 04:20:56 | La Salle, Texas, US | |
3674802 | 3674802 | 2022-02-15 | US | Texas | La Salle | 48283 | 2185 | 42 | 0 | 28.34453111 | -99.09908775 | 2022-02-16 04:21:10 | La Salle, Texas, US | |
3672925 | 3672925 | 2022-02-15 | US | Kansas | Cloud | 20029 | 2185 | 36 | 0 | 39.48028352 | -97.64925343 | 2022-02-16 04:21:10 | Cloud, Kansas, US | |
188180 | 188180 | 2022-02-13 | US | Nebraska | Phelps | 31137 | 2185 | 10 | 0 | 40.51156033 | -99.41461667 | 2022-02-14 04:20:51 | Phelps, Nebraska, US | |
318026 | 318026 | 2022-02-12 | US | Nebraska | Phelps | 31137 | 2185 | 10 | 0 | 40.51156033 | -99.41461667 | 2022-02-13 04:21:00 | Phelps, Nebraska, US | |
235352 | 235352 | 2022-02-11 | US | Nebraska | Phelps | 31137 | 2185 | 10 | 0 | 40.51156033 | -99.41461667 | 2022-02-12 04:21:06 | Phelps, Nebraska, US | |
2474891 | 2474891 | 2022-02-03 | US | Idaho | Franklin | 16041 | 2185 | 27 | 0 | 42.18332217 | -111.81496659999999 | 2022-02-04 04:21:10 | Franklin, Idaho, US | |
1320195 | 1320195 | 2022-01-26 | US | Missouri | Wayne | 29223 | 2185 | 42 | 0 | 37.11303869 | -90.46001416 | 2022-01-27 04:21:19 | Wayne, Missouri, US | |
2054784 | 2054784 | 2022-01-25 | US | South Dakota | Roberts | 46109 | 2185 | 45 | 0 | 45.62975048 | -96.94672673 | 2022-01-26 04:21:07 | Roberts, South Dakota, US | |
3467517 | 3467517 | 2022-01-18 | US | Virginia | Franklin City | 51620 | 2185 | 43 | 0 | 36.6831435 | -76.93859681 | 2022-01-19 04:21:23 | Franklin City, Virginia, US | |
558190 | 558190 | 2022-01-16 | US | Virginia | Richmond | 51159 | 2185 | 17 | 0 | 37.937575 | -76.72920628 | 2022-01-17 04:21:08 | Richmond, Virginia, US | |
3843911 | 3843911 | 2022-01-15 | US | Virginia | Richmond | 51159 | 2185 | 17 | 0 | 37.937575 | -76.72920628 | 2022-01-16 04:21:12 | Richmond, Virginia, US | |
102726 | 102726 | 2022-01-14 | US | Virginia | Richmond | 51159 | 2185 | 17 | 0 | 37.937575 | -76.72920628 | 2022-01-15 04:21:07 | Richmond, Virginia, US | |
127385 | 127385 | 2022-01-09 | US | Colorado | Rio Grande | 8105 | 2185 | 41 | 0 | 37.5836865 | -106.3847838 | 2022-01-10 04:22:07 | Rio Grande, Colorado, US | |
1218764 | 1218764 | 2022-01-08 | US | Texas | Pecos | 48371 | 2185 | 58 | 0 | 30.78097267 | -102.72412609999999 | 2022-01-09 04:21:46 | Pecos, Texas, US | |
3523033 | 3523033 | 2022-01-02 | US | Wyoming | Big Horn | 56003 | 2185 | 58 | 0 | 44.52405055 | -107.9960365 | 2022-01-03 02:22:25 | Big Horn, Wyoming, US | |
2171163 | 2171163 | 2022-01-01 | US | Wyoming | Big Horn | 56003 | 2185 | 58 | 0 | 44.52405055 | -107.9960365 | 2022-01-02 04:20:52 | Big Horn, Wyoming, US | |
2780594 | 2780594 | 2021-12-31 | US | Wyoming | Big Horn | 56003 | 2185 | 58 | 0 | 44.52405055 | -107.9960365 | 2022-01-01 04:22:14 | Big Horn, Wyoming, 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]);