johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
182 rows where confirmed = 4507 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
868606 | 868606 | 2022-12-11 | China | Shandong | 4507 | 8 | 0 | 36.3427 | 118.1498 | 2022-12-12 04:21:01 | Shandong, China | |||
1986852 | 1986852 | 2022-12-07 | US | New Mexico | Los Alamos | 35028 | 4507 | 22 | 0 | 35.86631386 | -106.3134985 | 2022-12-08 04:21:07 | Los Alamos, New Mexico, US | |
1243272 | 1243272 | 2022-11-28 | US | Wyoming | Goshen | 56015 | 4507 | 59 | 0 | 42.08798185 | -104.3534743 | 2022-11-29 04:21:05 | Goshen, Wyoming, US | |
3555260 | 3555260 | 2022-11-27 | US | Wyoming | Goshen | 56015 | 4507 | 59 | 0 | 42.08798185 | -104.3534743 | 2022-11-28 04:21:02 | Goshen, Wyoming, US | |
2103740 | 2103740 | 2022-11-26 | US | Wyoming | Goshen | 56015 | 4507 | 59 | 0 | 42.08798185 | -104.3534743 | 2022-11-27 04:21:05 | Goshen, Wyoming, US | |
491231 | 491231 | 2022-11-25 | US | Wyoming | Goshen | 56015 | 4507 | 59 | 0 | 42.08798185 | -104.3534743 | 2022-11-26 04:21:11 | Goshen, Wyoming, US | |
3527060 | 3527060 | 2022-11-24 | US | Wyoming | Goshen | 56015 | 4507 | 59 | 0 | 42.08798185 | -104.3534743 | 2022-11-25 04:21:06 | Goshen, Wyoming, US | |
3315843 | 3315843 | 2022-11-23 | US | Wyoming | Goshen | 56015 | 4507 | 59 | 0 | 42.08798185 | -104.3534743 | 2022-11-24 04:21:09 | Goshen, Wyoming, US | |
1623884 | 1623884 | 2022-11-22 | US | Wyoming | Goshen | 56015 | 4507 | 59 | 0 | 42.08798185 | -104.3534743 | 2022-11-23 04:21:06 | Goshen, Wyoming, US | |
3288385 | 3288385 | 2022-10-31 | US | West Virginia | Grant | 54023 | 4507 | 60 | 0 | 39.10314817 | -79.19440518 | 2022-11-01 04:22:36 | Grant, West Virginia, US | |
3753996 | 3753996 | 2022-10-13 | US | Arkansas | Polk | 5113 | 4507 | 156 | 0 | 34.48254879 | -94.22728802 | 2022-10-14 04:22:28 | Polk, Arkansas, US | |
3573903 | 3573903 | 2022-09-19 | US | Virginia | Appomattox | 51011 | 4507 | 57 | 0 | 37.37569884 | -78.81340003 | 2022-09-20 04:22:48 | Appomattox, Virginia, US | |
117752 | 117752 | 2022-09-06 | US | Tennessee | Trousdale | 47169 | 4507 | 47 | 0 | 36.39026213 | -86.16087954 | 2022-09-07 04:20:59 | Trousdale, Tennessee, US | |
2635124 | 2635124 | 2022-09-05 | US | Kentucky | Fleming | 21069 | 4507 | 66 | 0 | 38.36758311 | -83.69657514 | 2022-09-06 04:21:02 | Fleming, Kentucky, US | |
2988688 | 2988688 | 2022-09-04 | US | Kentucky | Fleming | 21069 | 4507 | 66 | 0 | 38.36758311 | -83.69657514 | 2022-09-05 04:21:01 | Fleming, Kentucky, US | |
2714373 | 2714373 | 2022-09-03 | US | Kentucky | Fleming | 21069 | 4507 | 66 | 0 | 38.36758311 | -83.69657514 | 2022-09-04 04:21:22 | Fleming, Kentucky, US | |
1395078 | 1395078 | 2022-09-02 | US | Kentucky | Fleming | 21069 | 4507 | 66 | 0 | 38.36758311 | -83.69657514 | 2022-09-03 04:21:04 | Fleming, Kentucky, US | |
3548907 | 3548907 | 2022-09-01 | US | Kentucky | Fleming | 21069 | 4507 | 66 | 0 | 38.36758311 | -83.69657514 | 2022-09-02 04:21:07 | Fleming, Kentucky, US | |
2344827 | 2344827 | 2022-08-31 | US | Kentucky | Fleming | 21069 | 4507 | 66 | 0 | 38.36758311 | -83.69657514 | 2022-09-01 04:21:03 | Fleming, Kentucky, US | |
3775307 | 3775307 | 2022-08-30 | US | Kentucky | Fleming | 21069 | 4507 | 66 | 0 | 38.36758311 | -83.69657514 | 2022-08-31 04:20:57 | Fleming, Kentucky, US | |
1681903 | 1681903 | 2022-08-29 | US | Kentucky | Fleming | 21069 | 4507 | 66 | 0 | 38.36758311 | -83.69657514 | 2022-08-30 04:21:03 | Fleming, Kentucky, US | |
2324842 | 2324842 | 2022-08-24 | US | Louisiana | Bienville | 22013 | 4507 | 114 | 0 | 32.34569994 | -93.05398492 | 2022-08-25 04:21:13 | Bienville, Louisiana, US | |
1349914 | 1349914 | 2022-08-10 | US | Wisconsin | Washburn | 55129 | 4507 | 47 | 0 | 45.89838588 | -91.79050449 | 2022-08-11 04:20:49 | Washburn, Wisconsin, US | |
1072531 | 1072531 | 2022-08-07 | US | Oregon | Tillamook | 41057 | 4507 | 69 | 0 | 45.46248721 | -123.712066 | 2022-08-08 04:21:08 | Tillamook, Oregon, US | |
1943119 | 1943119 | 2022-08-06 | US | Oregon | Tillamook | 41057 | 4507 | 69 | 0 | 45.46248721 | -123.712066 | 2022-08-07 04:20:54 | Tillamook, Oregon, US | |
882918 | 882918 | 2022-08-05 | US | Oregon | Tillamook | 41057 | 4507 | 69 | 0 | 45.46248721 | -123.712066 | 2022-08-06 04:20:56 | Tillamook, Oregon, US | |
232537 | 232537 | 2022-05-31 | US | Virginia | Bristol | 51520 | 4507 | 81 | 0 | 36.6163024 | -82.16359122 | 2022-06-01 04:20:55 | Bristol, Virginia, US | |
2600841 | 2600841 | 2022-05-05 | US | Puerto Rico | Yauco | 72153 | 4507 | 0 | 0 | 18.080374 | -66.858814 | 2022-05-06 04:21:00 | Yauco, Puerto Rico, US | |
3266041 | 3266041 | 2022-05-04 | US | California | Colusa | 6011 | 4507 | 21 | 0 | 39.17881957 | -122.2331726 | 2022-05-05 04:20:55 | Colusa, California, US | |
1572680 | 1572680 | 2022-05-03 | US | California | Colusa | 6011 | 4507 | 21 | 0 | 39.17881957 | -122.2331726 | 2022-05-04 04:20:59 | Colusa, California, US | |
463940 | 463940 | 2022-05-02 | US | California | Colusa | 6011 | 4507 | 21 | 0 | 39.17881957 | -122.2331726 | 2022-05-03 04:21:00 | Colusa, California, US | |
1542650 | 1542650 | 2022-03-31 | US | Pennsylvania | Montour | 42093 | 4507 | 93 | 0 | 41.03023987 | -76.66345939 | 2022-04-01 04:20:28 | Montour, Pennsylvania, US | |
1468951 | 1468951 | 2022-03-24 | US | Georgia | Morgan | 13211 | 4507 | 62 | 0 | 33.59232073 | -83.49129491 | 2022-03-25 04:20:46 | Morgan, Georgia, US | |
262383 | 262383 | 2022-03-15 | US | Georgia | Morgan | 13211 | 4507 | 60 | 0 | 33.59232073 | -83.49129491 | 2022-03-16 04:20:50 | Morgan, Georgia, US | |
3631540 | 3631540 | 2022-03-13 | US | Wisconsin | Sawyer | 55113 | 4507 | 59 | 0 | 45.87931905 | -91.14504927 | 2022-03-14 04:20:46 | Sawyer, Wisconsin, US | |
954448 | 954448 | 2022-03-12 | US | Wisconsin | Sawyer | 55113 | 4507 | 59 | 0 | 45.87931905 | -91.14504927 | 2022-03-13 04:20:49 | Sawyer, Wisconsin, US | |
359909 | 359909 | 2022-03-11 | US | Wisconsin | Sawyer | 55113 | 4507 | 59 | 0 | 45.87931905 | -91.14504927 | 2022-03-12 04:20:50 | Sawyer, Wisconsin, US | |
2202834 | 2202834 | 2022-03-06 | US | Texas | Panola | 48365 | 4507 | 128 | 0 | 32.163959600000005 | -94.30552481 | 2022-03-07 04:20:47 | Panola, Texas, US | |
2095306 | 2095306 | 2022-03-05 | US | Texas | Robertson | 48395 | 4507 | 75 | 0 | 31.02539637 | -96.51272246 | 2022-03-06 04:20:49 | Robertson, Texas, US | |
2095291 | 2095291 | 2022-03-05 | US | Texas | Panola | 48365 | 4507 | 128 | 0 | 32.163959600000005 | -94.30552481 | 2022-03-06 04:20:49 | Panola, Texas, US | |
2669006 | 2669006 | 2022-03-04 | US | Texas | Robertson | 48395 | 4507 | 75 | 0 | 31.02539637 | -96.51272246 | 2022-03-05 04:21:10 | Robertson, Texas, US | |
1995233 | 1995233 | 2022-03-01 | US | Oklahoma | Marshall | 40095 | 4507 | 38 | 0 | 34.02311222 | -96.76855464 | 2022-03-02 04:21:07 | Marshall, Oklahoma, US | |
945407 | 945407 | 2022-02-28 | US | Oklahoma | Marshall | 40095 | 4507 | 38 | 0 | 34.02311222 | -96.76855464 | 2022-03-01 04:21:09 | Marshall, Oklahoma, US | |
2735636 | 2735636 | 2022-02-27 | US | Oregon | Clatsop | 41007 | 4507 | 38 | 0 | 45.99712889 | -123.660711 | 2022-02-28 04:21:05 | Clatsop, Oregon, US | |
2735598 | 2735598 | 2022-02-27 | US | Oklahoma | Marshall | 40095 | 4507 | 38 | 0 | 34.02311222 | -96.76855464 | 2022-02-28 04:21:05 | Marshall, Oklahoma, US | |
3048789 | 3048789 | 2022-02-26 | US | Oregon | Clatsop | 41007 | 4507 | 38 | 0 | 45.99712889 | -123.660711 | 2022-02-27 04:21:04 | Clatsop, Oregon, US | |
3048751 | 3048751 | 2022-02-26 | US | Oklahoma | Marshall | 40095 | 4507 | 38 | 0 | 34.02311222 | -96.76855464 | 2022-02-27 04:21:04 | Marshall, Oklahoma, US | |
577444 | 577444 | 2022-02-25 | US | Oregon | Clatsop | 41007 | 4507 | 38 | 0 | 45.99712889 | -123.660711 | 2022-02-26 04:21:12 | Clatsop, Oregon, US | |
577406 | 577406 | 2022-02-25 | US | Oklahoma | Marshall | 40095 | 4507 | 38 | 0 | 34.02311222 | -96.76855464 | 2022-02-26 04:21:12 | Marshall, Oklahoma, US | |
1513982 | 1513982 | 2022-02-24 | US | Oklahoma | Marshall | 40095 | 4507 | 38 | 0 | 34.02311222 | -96.76855464 | 2022-02-25 04:21:11 | Marshall, Oklahoma, US | |
1060423 | 1060423 | 2022-02-23 | US | Oklahoma | Marshall | 40095 | 4507 | 38 | 0 | 34.02311222 | -96.76855464 | 2022-02-24 04:21:14 | Marshall, Oklahoma, US | |
3672859 | 3672859 | 2022-02-15 | US | Iowa | Jackson | 19097 | 4507 | 66 | 0 | 42.17178824 | -90.57354837 | 2022-02-16 04:21:10 | Jackson, Iowa, US | |
2642960 | 2642960 | 2022-02-14 | US | Iowa | Jackson | 19097 | 4507 | 66 | 0 | 42.17178824 | -90.57354837 | 2022-02-15 04:21:09 | Jackson, Iowa, US | |
2642282 | 2642282 | 2022-02-14 | US | Arkansas | Sharp | 5135 | 4507 | 92 | 0 | 36.16258158 | -91.47819342 | 2022-02-15 04:21:09 | Sharp, Arkansas, US | |
187277 | 187277 | 2022-02-13 | US | Iowa | Jackson | 19097 | 4507 | 66 | 0 | 42.17178824 | -90.57354837 | 2022-02-14 04:20:51 | Jackson, Iowa, US | |
317123 | 317123 | 2022-02-12 | US | Iowa | Jackson | 19097 | 4507 | 66 | 0 | 42.17178824 | -90.57354837 | 2022-02-13 04:21:00 | Jackson, Iowa, US | |
234449 | 234449 | 2022-02-11 | US | Iowa | Jackson | 19097 | 4507 | 66 | 0 | 42.17178824 | -90.57354837 | 2022-02-12 04:21:06 | Jackson, Iowa, US | |
1465291 | 1465291 | 2022-02-10 | US | Iowa | Jackson | 19097 | 4507 | 66 | 0 | 42.17178824 | -90.57354837 | 2022-02-11 04:21:09 | Jackson, Iowa, US | |
3075252 | 3075252 | 2022-02-09 | US | Iowa | Jackson | 19097 | 4507 | 66 | 0 | 42.17178824 | -90.57354837 | 2022-02-10 04:21:14 | Jackson, Iowa, US | |
2474741 | 2474741 | 2022-02-03 | US | Georgia | Crisp | 13081 | 4507 | 129 | 0 | 31.92289565 | -83.76811843 | 2022-02-04 04:21:10 | Crisp, Georgia, US | |
3301310 | 3301310 | 2022-01-30 | US | Indiana | Jay | 18075 | 4507 | 66 | 0 | 40.43781032 | -85.00576229 | 2022-01-31 04:21:09 | Jay, Indiana, US | |
3063101 | 3063101 | 2022-01-29 | US | Indiana | Jay | 18075 | 4507 | 66 | 0 | 40.43781032 | -85.00576229 | 2022-01-30 04:21:26 | Jay, Indiana, US | |
3811035 | 3811035 | 2022-01-28 | US | Indiana | Jay | 18075 | 4507 | 66 | 0 | 40.43781032 | -85.00576229 | 2022-01-29 04:21:10 | Jay, Indiana, US | |
1229732 | 1229732 | 2022-01-24 | US | Nebraska | Saunders | 31155 | 4507 | 16 | 0 | 41.227810299999994 | -96.63773905 | 2022-01-25 04:21:05 | Saunders, Nebraska, US | |
3690499 | 3690499 | 2022-01-13 | US | Texas | Austin | 48015 | 4507 | 58 | 0 | 29.88548725 | -96.27736949 | 2022-01-14 04:21:54 | Austin, Texas, US | |
129871 | 129871 | 2022-01-09 | US | Texas | Karnes | 48255 | 4507 | 58 | 0 | 28.90705334 | -97.85960149 | 2022-01-10 04:22:07 | Karnes, Texas, US | |
1288605 | 1288605 | 2022-01-04 | US | Oklahoma | Texas | 40139 | 4507 | 42 | 0 | 36.74777635 | -101.4889765 | 2022-01-05 04:21:59 | Texas, Oklahoma, US | |
1287876 | 1287876 | 2022-01-04 | US | Missouri | Audrain | 29007 | 4507 | 89 | 0 | 39.215877 | -91.84242683 | 2022-01-05 04:21:59 | Audrain, Missouri, US | |
1703757 | 1703757 | 2022-01-03 | US | Virginia | Salem | 51775 | 4507 | 83 | 0 | 37.2836193 | -80.06219455 | 2022-01-04 04:22:17 | Salem, Virginia, US | |
1702973 | 1702973 | 2022-01-03 | US | Oregon | Jefferson | 41031 | 4507 | 69 | 0 | 44.62806839 | -121.17832 | 2022-01-04 04:22:17 | Jefferson, Oregon, US | |
1702949 | 1702949 | 2022-01-03 | US | Oklahoma | Texas | 40139 | 4507 | 42 | 0 | 36.74777635 | -101.4889765 | 2022-01-04 04:22:17 | Texas, Oklahoma, US | |
3522032 | 3522032 | 2022-01-02 | US | Oklahoma | Texas | 40139 | 4507 | 42 | 0 | 36.74777635 | -101.4889765 | 2022-01-03 02:22:25 | Texas, Oklahoma, US | |
3519858 | 3519858 | 2022-01-02 | US | Alaska | Juneau | 2110 | 4507 | 15 | 0 | 58.45031811 | -134.200436 | 2022-01-03 02:22:25 | Juneau, Alaska, US | |
2170162 | 2170162 | 2022-01-01 | US | Oklahoma | Texas | 40139 | 4507 | 42 | 0 | 36.74777635 | -101.4889765 | 2022-01-02 04:20:52 | Texas, Oklahoma, US | |
2167988 | 2167988 | 2022-01-01 | US | Alaska | Juneau | 2110 | 4507 | 15 | 0 | 58.45031811 | -134.200436 | 2022-01-02 04:20:52 | Juneau, Alaska, US | |
2779593 | 2779593 | 2021-12-31 | US | Oklahoma | Texas | 40139 | 4507 | 42 | 0 | 36.74777635 | -101.4889765 | 2022-01-01 04:22:14 | Texas, Oklahoma, US | |
2777419 | 2777419 | 2021-12-31 | US | Alaska | Juneau | 2110 | 4507 | 15 | 0 | 58.45031811 | -134.200436 | 2022-01-01 04:22:14 | Juneau, Alaska, US | |
4001947 | 4001947 | 2021-12-30 | US | Virginia | Accomack | 51001 | 4507 | 83 | 0 | 37.76707161 | -75.63234615 | 2021-12-31 04:21:50 | Accomack, Virginia, US | |
4001250 | 4001250 | 2021-12-30 | US | Oklahoma | Texas | 40139 | 4507 | 42 | 0 | 36.74777635 | -101.4889765 | 2021-12-31 04:21:50 | Texas, Oklahoma, US | |
3999076 | 3999076 | 2021-12-30 | US | Alaska | Juneau | 2110 | 4507 | 15 | 0 | 58.45031811 | -134.200436 | 2021-12-31 04:21:50 | Juneau, Alaska, US | |
1671057 | 1671057 | 2021-12-29 | US | Oklahoma | Texas | 40139 | 4507 | 42 | 0 | 36.74777635 | -101.4889765 | 2021-12-30 04:21:25 | Texas, Oklahoma, US | |
1668883 | 1668883 | 2021-12-29 | US | Alaska | Juneau | 2110 | 4507 | 15 | 0 | 58.45031811 | -134.200436 | 2021-12-30 04:21:25 | Juneau, Alaska, US | |
1434199 | 1434199 | 2021-12-28 | US | Michigan | Emmet | 26047 | 4507 | 59 | 0 | 45.52625509 | -84.89083249 | 2021-12-29 03:21:43 | Emmet, Michigan, US | |
732160 | 732160 | 2021-12-27 | US | Michigan | Emmet | 26047 | 4507 | 59 | 0 | 45.52625509 | -84.89083249 | 2021-12-28 04:21:47 | Emmet, Michigan, US | |
799452 | 799452 | 2021-12-22 | US | Illinois | McDonough | 17109 | 4507 | 70 | 0 | 40.45674722 | -90.67775541 | 2021-12-23 04:21:21 | McDonough, Illinois, US | |
2906847 | 2906847 | 2021-12-19 | US | Texas | Jasper | 48241 | 4507 | 165 | 0 | 30.74685667 | -94.02667579 | 2021-12-20 04:21:43 | Jasper, Texas, US | |
1719670 | 1719670 | 2021-12-16 | US | Virginia | Caroline | 51033 | 4507 | 56 | 0 | 38.02679129 | -77.34901405 | 2021-12-17 04:22:14 | Caroline, Virginia, US | |
1716824 | 1716824 | 2021-12-16 | US | Arkansas | Carroll | 5015 | 4507 | 78 | 0 | 36.34038560000001 | -93.54270261 | 2021-12-17 04:22:14 | Carroll, Arkansas, US | |
1661688 | 1661688 | 2021-12-12 | US | Kansas | Barton | 20009 | 4507 | 71 | 0 | 38.47889676 | -98.75636726 | 2021-12-13 04:22:02 | Barton, Kansas, US | |
1665704 | 1665704 | 2021-12-11 | US | Kansas | Barton | 20009 | 4507 | 71 | 0 | 38.47889676 | -98.75636726 | 2021-12-12 04:22:12 | Barton, Kansas, US | |
3656856 | 3656856 | 2021-12-10 | US | Kansas | Barton | 20009 | 4507 | 71 | 0 | 38.47889676 | -98.75636726 | 2021-12-11 04:22:45 | Barton, Kansas, US | |
139550 | 139550 | 2021-12-04 | US | Maryland | Dorchester | 24019 | 4507 | 87 | 0 | 38.45413522 | -76.02752426 | 2021-12-05 04:22:25 | Dorchester, Maryland, US | |
3404485 | 3404485 | 2021-11-30 | US | Texas | Cass | 48067 | 4507 | 155 | 0 | 33.07499881 | -94.34646905 | 2021-12-01 04:22:29 | Cass, Texas, US | |
1232673 | 1232673 | 2021-11-28 | US | Illinois | Saline | 17165 | 4507 | 71 | 0 | 37.75332999 | -88.54119706 | 2021-11-29 04:22:30 | Saline, Illinois, US | |
1231677 | 1231677 | 2021-11-28 | Liechtenstein | 4507 | 61 | 0 | 47.14 | 9.55 | 2021-11-29 04:22:30 | Liechtenstein | ||||
1359380 | 1359380 | 2021-11-27 | US | Illinois | Saline | 17165 | 4507 | 71 | 0 | 37.75332999 | -88.54119706 | 2021-11-28 04:22:43 | Saline, Illinois, US | |
759371 | 759371 | 2021-11-26 | US | Illinois | Saline | 17165 | 4507 | 71 | 0 | 37.75332999 | -88.54119706 | 2021-11-27 04:22:45 | Saline, Illinois, US | |
1803788 | 1803788 | 2021-11-25 | US | Illinois | Saline | 17165 | 4507 | 71 | 0 | 37.75332999 | -88.54119706 | 2021-11-26 04:22:33 | Saline, Illinois, US | |
905222 | 905222 | 2021-11-24 | US | Illinois | Saline | 17165 | 4507 | 71 | 0 | 37.75332999 | -88.54119706 | 2021-11-25 04:22:33 | Saline, Illinois, US | |
3070524 | 3070524 | 2021-11-23 | US | Arkansas | Jackson | 5067 | 4507 | 46 | 0 | 35.59802983 | -91.21494602 | 2021-11-24 04:22:14 | Jackson, Arkansas, 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]);