johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
167 rows where confirmed = 4428 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2754557 | 2754557 | 2022-12-29 | US | Michigan | Kalkaska | 26079 | 4428 | 69 | 0 | 44.68512729 | -85.09085699 | 2022-12-30 04:21:04 | Kalkaska, Michigan, US | |
1075563 | 1075563 | 2022-12-28 | US | Michigan | Kalkaska | 26079 | 4428 | 69 | 0 | 44.68512729 | -85.09085699 | 2022-12-29 04:21:01 | Kalkaska, Michigan, US | |
329560 | 329560 | 2022-12-27 | US | Michigan | Kalkaska | 26079 | 4428 | 69 | 0 | 44.68512729 | -85.09085699 | 2022-12-28 04:21:04 | Kalkaska, Michigan, US | |
2557828 | 2557828 | 2022-11-29 | US | Iowa | Poweshiek | 19157 | 4428 | 65 | 0 | 41.68625425 | -92.53155731 | 2022-11-30 04:21:07 | Poweshiek, Iowa, US | |
1240902 | 1240902 | 2022-11-28 | US | Iowa | Poweshiek | 19157 | 4428 | 65 | 0 | 41.68625425 | -92.53155731 | 2022-11-29 04:21:05 | Poweshiek, Iowa, US | |
3552890 | 3552890 | 2022-11-27 | US | Iowa | Poweshiek | 19157 | 4428 | 65 | 0 | 41.68625425 | -92.53155731 | 2022-11-28 04:21:02 | Poweshiek, Iowa, US | |
2101370 | 2101370 | 2022-11-26 | US | Iowa | Poweshiek | 19157 | 4428 | 65 | 0 | 41.68625425 | -92.53155731 | 2022-11-27 04:21:05 | Poweshiek, Iowa, US | |
488861 | 488861 | 2022-11-25 | US | Iowa | Poweshiek | 19157 | 4428 | 65 | 0 | 41.68625425 | -92.53155731 | 2022-11-26 04:21:11 | Poweshiek, Iowa, US | |
3524690 | 3524690 | 2022-11-24 | US | Iowa | Poweshiek | 19157 | 4428 | 65 | 0 | 41.68625425 | -92.53155731 | 2022-11-25 04:21:06 | Poweshiek, Iowa, US | |
3313473 | 3313473 | 2022-11-23 | US | Iowa | Poweshiek | 19157 | 4428 | 65 | 0 | 41.68625425 | -92.53155731 | 2022-11-24 04:21:09 | Poweshiek, Iowa, US | |
1627238 | 1627238 | 2022-09-22 | US | Tennessee | Grundy | 47061 | 4428 | 79 | 0 | 35.38433717 | -85.72142731 | 2022-09-23 04:23:13 | Grundy, Tennessee, US | |
2326589 | 2326589 | 2022-08-24 | US | Texas | Tyler | 48457 | 4428 | 88 | 0 | 30.77031716 | -94.37690895 | 2022-08-25 04:21:13 | Tyler, Texas, US | |
1349592 | 1349592 | 2022-08-10 | US | Utah | San Juan | 49037 | 4428 | 50 | 0 | 37.62762978 | -109.8033714 | 2022-08-11 04:20:49 | San Juan, Utah, US | |
1089347 | 1089347 | 2022-08-09 | US | Utah | San Juan | 49037 | 4428 | 50 | 0 | 37.62762978 | -109.8033714 | 2022-08-10 04:20:57 | San Juan, Utah, US | |
3546762 | 3546762 | 2022-08-08 | US | Utah | San Juan | 49037 | 4428 | 50 | 0 | 37.62762978 | -109.8033714 | 2022-08-09 04:20:34 | San Juan, Utah, US | |
1073165 | 1073165 | 2022-08-07 | US | Utah | San Juan | 49037 | 4428 | 50 | 0 | 37.62762978 | -109.8033714 | 2022-08-08 04:21:08 | San Juan, Utah, US | |
1943753 | 1943753 | 2022-08-06 | US | Utah | San Juan | 49037 | 4428 | 50 | 0 | 37.62762978 | -109.8033714 | 2022-08-07 04:20:54 | San Juan, Utah, US | |
883552 | 883552 | 2022-08-05 | US | Utah | San Juan | 49037 | 4428 | 50 | 0 | 37.62762978 | -109.8033714 | 2022-08-06 04:20:56 | San Juan, Utah, US | |
2011963 | 2011963 | 2022-08-04 | US | Utah | San Juan | 49037 | 4428 | 50 | 0 | 37.62762978 | -109.8033714 | 2022-08-05 04:20:52 | San Juan, Utah, US | |
3872512 | 3872512 | 2022-07-31 | US | Idaho | Minidoka | 16067 | 4428 | 65 | 0 | 42.85518524 | -113.6357257 | 2022-08-01 04:21:03 | Minidoka, Idaho, US | |
675266 | 675266 | 2022-07-30 | US | Idaho | Minidoka | 16067 | 4428 | 65 | 0 | 42.85518524 | -113.6357257 | 2022-07-31 04:21:02 | Minidoka, Idaho, US | |
1784465 | 1784465 | 2022-07-29 | US | Idaho | Minidoka | 16067 | 4428 | 65 | 0 | 42.85518524 | -113.6357257 | 2022-07-30 04:20:42 | Minidoka, Idaho, US | |
1069352 | 1069352 | 2022-07-28 | US | West Virginia | Braxton | 54007 | 4428 | 45 | 0 | 38.70036159 | -80.72011184 | 2022-07-29 04:20:45 | Braxton, West Virginia, US | |
2335870 | 2335870 | 2022-07-27 | US | Arkansas | Clay | 5021 | 4428 | 95 | 0 | 36.36826212 | -90.4148172 | 2022-07-28 04:20:56 | Clay, Arkansas, US | |
959900 | 959900 | 2022-07-19 | US | Illinois | Jo Daviess | 17085 | 4428 | 37 | 0 | 42.36542373 | -90.21094405 | 2022-07-20 04:20:59 | Jo Daviess, Illinois, US | |
632831 | 632831 | 2022-07-12 | US | Tennessee | Cannon | 47015 | 4428 | 68 | 0 | 35.80990797 | -86.05738983 | 2022-07-13 04:20:58 | Cannon, Tennessee, US | |
167014 | 167014 | 2022-06-21 | US | Illinois | Carroll | 17015 | 4428 | 48 | 0 | 42.06823429 | -89.93395545 | 2022-06-22 04:20:54 | Carroll, Illinois, US | |
3510155 | 3510155 | 2022-06-05 | US | Puerto Rico | Naguabo | 72103 | 4428 | 0 | 0 | 18.230637 | -65.753897 | 2022-06-06 04:20:57 | Naguabo, Puerto Rico, US | |
230126 | 230126 | 2022-05-31 | US | Georgia | Washington | 13303 | 4428 | 137 | 0 | 32.96711864 | -82.79357039 | 2022-06-01 04:20:55 | Washington, Georgia, US | |
3186891 | 3186891 | 2022-05-30 | US | Georgia | Washington | 13303 | 4428 | 137 | 0 | 32.96711864 | -82.79357039 | 2022-05-31 04:20:51 | Washington, Georgia, US | |
3199040 | 3199040 | 2022-05-29 | US | Georgia | Washington | 13303 | 4428 | 137 | 0 | 32.96711864 | -82.79357039 | 2022-05-30 04:20:50 | Washington, Georgia, US | |
2725918 | 2725918 | 2022-05-28 | US | Georgia | Washington | 13303 | 4428 | 137 | 0 | 32.96711864 | -82.79357039 | 2022-05-29 04:20:53 | Washington, Georgia, US | |
1315099 | 1315099 | 2022-05-27 | US | Georgia | Washington | 13303 | 4428 | 137 | 0 | 32.96711864 | -82.79357039 | 2022-05-28 04:21:07 | Washington, Georgia, US | |
1850891 | 1850891 | 2022-05-26 | US | Georgia | Washington | 13303 | 4428 | 137 | 0 | 32.96711864 | -82.79357039 | 2022-05-27 04:20:56 | Washington, Georgia, US | |
2048767 | 2048767 | 2022-05-25 | US | Georgia | Washington | 13303 | 4428 | 137 | 0 | 32.96711864 | -82.79357039 | 2022-05-26 04:20:50 | Washington, Georgia, US | |
622778 | 622778 | 2022-05-22 | US | Georgia | Washington | 13303 | 4428 | 137 | 0 | 32.96711864 | -82.79357039 | 2022-05-26 04:20:50 | Washington, Georgia, US | |
1506319 | 1506319 | 2022-05-16 | US | Puerto Rico | Anasco | 72011 | 4428 | 0 | 0 | 18.287985 | -67.120611 | 2022-05-17 04:20:59 | Anasco, Puerto Rico, US | |
3537624 | 3537624 | 2022-05-10 | US | New Hampshire | Unassigned | 90033 | 4428 | 2 | 0 | 44.69063265 | 0.0 | 2022-05-11 04:20:48 | Unassigned, New Hampshire, US | |
1400466 | 1400466 | 2022-05-06 | US | Puerto Rico | Quebradillas | 72115 | 4428 | 0 | 0 | 18.439692 | -66.926113 | 2022-05-07 04:21:09 | Quebradillas, Puerto Rico, US | |
3919345 | 3919345 | 2022-05-01 | US | Virginia | Bristol | 51520 | 4428 | 80 | 0 | 36.6163024 | -82.16359122 | 2022-05-02 04:21:10 | Bristol, Virginia, US | |
2844149 | 2844149 | 2022-04-30 | US | Virginia | Bristol | 51520 | 4428 | 80 | 0 | 36.6163024 | -82.16359122 | 2022-05-01 04:20:57 | Bristol, Virginia, US | |
1160462 | 1160462 | 2022-04-29 | US | Virginia | Bristol | 51520 | 4428 | 80 | 0 | 36.6163024 | -82.16359122 | 2022-04-30 04:21:05 | Bristol, Virginia, US | |
159564 | 159564 | 2022-03-29 | US | Louisiana | Winn | 22127 | 4428 | 62 | 0 | 31.94449367 | -92.63789413 | 2022-03-30 04:20:45 | Winn, Louisiana, US | |
1438135 | 1438135 | 2022-03-28 | US | Louisiana | Winn | 22127 | 4428 | 62 | 0 | 31.94449367 | -92.63789413 | 2022-03-29 04:20:46 | Winn, Louisiana, US | |
877816 | 877816 | 2022-03-27 | US | Louisiana | Winn | 22127 | 4428 | 62 | 0 | 31.94449367 | -92.63789413 | 2022-03-28 04:20:33 | Winn, Louisiana, US | |
2165099 | 2165099 | 2022-03-26 | US | Louisiana | Winn | 22127 | 4428 | 62 | 0 | 31.94449367 | -92.63789413 | 2022-03-27 04:20:47 | Winn, Louisiana, US | |
1722035 | 1722035 | 2022-03-25 | US | Louisiana | Winn | 22127 | 4428 | 62 | 0 | 31.94449367 | -92.63789413 | 2022-03-26 04:20:23 | Winn, Louisiana, US | |
1512273 | 1512273 | 2022-02-24 | US | Georgia | Putnam | 13237 | 4428 | 100 | 0 | 33.32056115 | -83.37552891 | 2022-02-25 04:21:11 | Putnam, Georgia, US | |
1061043 | 1061043 | 2022-02-23 | US | Texas | Panola | 48365 | 4428 | 124 | 0 | 32.163959600000005 | -94.30552481 | 2022-02-24 04:21:14 | Panola, Texas, US | |
1059854 | 1059854 | 2022-02-23 | US | Montana | Hill | 30041 | 4428 | 72 | 0 | 48.62879827 | -110.1129252 | 2022-02-24 04:21:14 | Hill, Montana, US | |
2015047 | 2015047 | 2022-02-06 | US | North Carolina | Madison | 37115 | 4428 | 76 | 0 | 35.85402722 | -82.71346418 | 2022-02-07 04:21:05 | Madison, North Carolina, US | |
1296376 | 1296376 | 2022-02-05 | US | North Carolina | Madison | 37115 | 4428 | 76 | 0 | 35.85402722 | -82.71346418 | 2022-02-06 04:21:00 | Madison, North Carolina, US | |
2329704 | 2329704 | 2022-02-04 | US | North Carolina | Madison | 37115 | 4428 | 76 | 0 | 35.85402722 | -82.71346418 | 2022-02-05 04:21:05 | Madison, North Carolina, US | |
3464678 | 3464678 | 2022-01-18 | US | Arkansas | Lincoln | 5079 | 4428 | 59 | 0 | 33.95317155 | -91.74002806 | 2022-01-19 04:21:23 | Lincoln, Arkansas, US | |
555261 | 555261 | 2022-01-16 | US | Arkansas | Clark | 5019 | 4428 | 66 | 0 | 34.04613432 | -93.17484713 | 2022-01-17 04:21:08 | Clark, Arkansas, US | |
3689348 | 3689348 | 2022-01-13 | US | Missouri | Adair | 29001 | 4428 | 54 | 0 | 40.19058551 | -92.60078167 | 2022-01-14 04:21:54 | Adair, Missouri, US | |
2611573 | 2611573 | 2022-01-06 | US | Louisiana | Pointe Coupee | 22077 | 4428 | 85 | 0 | 30.71409502 | -91.60209535 | 2022-01-07 04:22:09 | Pointe Coupee, Louisiana, US | |
733824 | 733824 | 2021-12-27 | US | Virginia | Accomack | 51001 | 4428 | 83 | 0 | 37.76707161 | -75.63234615 | 2021-12-28 04:21:47 | Accomack, Virginia, US | |
2906192 | 2906192 | 2021-12-19 | US | Ohio | Hocking | 39073 | 4428 | 100 | 0 | 39.49537927 | -82.47991446 | 2021-12-20 04:21:43 | Hocking, Ohio, US | |
1146014 | 1146014 | 2021-12-01 | US | Indiana | Fayette | 18041 | 4428 | 94 | 0 | 39.63684962 | -85.17797541 | 2021-12-02 04:22:37 | Fayette, Indiana, US | |
3072469 | 3072469 | 2021-11-23 | US | Ohio | Adams | 39001 | 4428 | 111 | 0 | 38.84541072 | -83.4718964 | 2021-11-24 04:22:14 | Adams, Ohio, US | |
723903 | 723903 | 2021-11-20 | US | Kentucky | Grant | 21081 | 4428 | 36 | 0 | 38.64962758 | -84.62415957 | 2021-11-21 04:22:13 | Grant, Kentucky, US | |
29459 | 29459 | 2021-11-11 | US | Illinois | Saline | 17165 | 4428 | 71 | 0 | 37.75332999 | -88.54119706 | 2021-11-12 04:22:01 | Saline, Illinois, US | |
2846558 | 2846558 | 2021-11-10 | US | Minnesota | Brown | 27015 | 4428 | 53 | 0 | 44.24205652 | -94.72562874 | 2021-11-11 04:21:45 | Brown, Minnesota, US | |
2845898 | 2845898 | 2021-11-10 | US | Illinois | Saline | 17165 | 4428 | 71 | 0 | 37.75332999 | -88.54119706 | 2021-11-11 04:21:45 | Saline, Illinois, US | |
288013 | 288013 | 2021-10-31 | Japan | Port Quarantine | 4428 | 7 | 0 | 2021-11-01 04:22:01 | Port Quarantine, Japan | |||||
7163 | 7163 | 2021-10-28 | US | South Carolina | Edgefield | 45037 | 4428 | 57 | 0 | 33.77221995 | -81.96231108 | 2021-10-29 04:22:03 | Edgefield, South Carolina, US | |
537553 | 537553 | 2021-10-27 | US | South Carolina | Edgefield | 45037 | 4428 | 57 | 0 | 33.77221995 | -81.96231108 | 2021-10-28 04:22:08 | Edgefield, South Carolina, US | |
3495530 | 3495530 | 2021-10-26 | US | Virginia | Isle of Wight | 51093 | 4428 | 86 | 0 | 36.90579348 | -76.70842863 | 2021-10-27 04:22:32 | Isle of Wight, Virginia, US | |
3493307 | 3493307 | 2021-10-26 | US | Indiana | Scott | 18143 | 4428 | 76 | 0 | 38.68672078 | -85.74627859 | 2021-10-27 04:22:32 | Scott, Indiana, US | |
684622 | 684622 | 2021-10-24 | US | New York | Wyoming | 36121 | 4428 | 58 | 0 | 42.70145109 | -78.22199579 | 2021-10-25 04:22:31 | Wyoming, New York, US | |
444802 | 444802 | 2021-10-20 | US | Kentucky | Mercer | 21167 | 4428 | 73 | 0 | 37.81474237 | -84.87488475 | 2021-10-21 04:21:18 | Mercer, Kentucky, US | |
600717 | 600717 | 2021-10-19 | US | Texas | Cass | 48067 | 4428 | 143 | 0 | 33.07499881 | -94.34646905 | 2021-10-20 04:21:00 | Cass, Texas, US | |
599539 | 599539 | 2021-10-19 | US | Mississippi | Yazoo | 28163 | 4428 | 87 | 0 | 32.77890365 | -90.39656148 | 2021-10-20 04:21:00 | Yazoo, Mississippi, US | |
2773717 | 2773717 | 2021-09-30 | US | Florida | Taylor | 12123 | 4428 | 48 | 0 | 30.04848048 | -83.60445406 | 2021-10-01 04:21:35 | Taylor, Florida, US | |
707173 | 707173 | 2021-09-29 | US | Florida | Taylor | 12123 | 4428 | 48 | 0 | 30.04848048 | -83.60445406 | 2021-09-30 04:21:20 | Taylor, Florida, US | |
1337229 | 1337229 | 2021-09-28 | US | Tennessee | Hickman | 47081 | 4428 | 65 | 0 | 35.80609681 | -87.47643507 | 2021-09-29 04:21:45 | Hickman, Tennessee, US | |
1336578 | 1336578 | 2021-09-28 | US | North Carolina | Cherokee | 37039 | 4428 | 67 | 0 | 35.1349263 | -84.05970864 | 2021-09-29 04:21:45 | Cherokee, North Carolina, US | |
1335015 | 1335015 | 2021-09-28 | US | Florida | Taylor | 12123 | 4428 | 48 | 0 | 30.04848048 | -83.60445406 | 2021-09-29 04:21:45 | Taylor, Florida, US | |
1239213 | 1239213 | 2021-09-27 | US | Wisconsin | Oneida | 55085 | 4428 | 84 | 0 | 45.70677897 | -89.51944105 | 2021-09-28 04:21:28 | Oneida, Wisconsin, US | |
1236384 | 1236384 | 2021-09-27 | US | Florida | Taylor | 12123 | 4428 | 48 | 0 | 30.04848048 | -83.60445406 | 2021-09-28 04:21:28 | Taylor, Florida, US | |
2076685 | 2076685 | 2021-09-26 | US | Florida | Taylor | 12123 | 4428 | 48 | 0 | 30.04848048 | -83.60445406 | 2021-09-27 04:21:16 | Taylor, Florida, US | |
1725237 | 1725237 | 2021-09-25 | US | Florida | Taylor | 12123 | 4428 | 48 | 0 | 30.04848048 | -83.60445406 | 2021-09-26 04:21:29 | Taylor, Florida, US | |
1921957 | 1921957 | 2021-09-24 | US | Florida | Taylor | 12123 | 4428 | 48 | 0 | 30.04848048 | -83.60445406 | 2021-09-25 04:21:31 | Taylor, Florida, US | |
3759295 | 3759295 | 2021-09-21 | US | Mississippi | Leflore | 28083 | 4428 | 140 | 0 | 33.55545125 | -90.29900733 | 2021-09-22 04:21:45 | Leflore, Mississippi, US | |
1818167 | 1818167 | 2021-09-19 | US | Virginia | Prince George | 51149 | 4428 | 33 | 0 | 37.18497668 | -77.22922187 | 2021-09-20 04:21:22 | Prince George, Virginia, US | |
19747 | 19747 | 2021-09-18 | US | Virginia | Prince George | 51149 | 4428 | 33 | 0 | 37.18497668 | -77.22922187 | 2021-09-19 04:21:34 | Prince George, Virginia, US | |
2621432 | 2621432 | 2021-09-17 | US | Virginia | Prince George | 51149 | 4428 | 33 | 0 | 37.18497668 | -77.22922187 | 2021-09-18 04:21:24 | Prince George, Virginia, US | |
2812197 | 2812197 | 2021-09-16 | US | Washington | Mason | 53045 | 4428 | 52 | 0 | 47.35007586 | -123.1863685 | 2021-09-17 04:21:46 | Mason, Washington, US | |
3807339 | 3807339 | 2021-09-11 | US | Kentucky | Marshall | 21157 | 4428 | 71 | 0 | 36.88007070000001 | -88.32803576 | 2021-09-12 04:21:13 | Marshall, Kentucky, US | |
3282255 | 3282255 | 2021-09-05 | US | Kentucky | Clay | 21051 | 4428 | 48 | 0 | 37.16451126 | -83.712575 | 2021-09-06 04:21:22 | Clay, Kentucky, US | |
34111 | 34111 | 2021-08-25 | US | Minnesota | Beltrami | 27007 | 4428 | 66 | 0 | 47.97373527 | -94.93732139 | 2021-08-26 04:21:28 | Beltrami, Minnesota, US | |
3169060 | 3169060 | 2021-08-23 | US | Washington | Douglas | 53017 | 4428 | 25 | 0 | 47.7361335 | -119.69293700000001 | 2021-08-24 04:21:19 | Douglas, Washington, US | |
248636 | 248636 | 2021-08-17 | US | Virginia | Manassas | 51683 | 4428 | 48 | 0 | 38.7464321 | -77.48509905 | 2021-08-18 04:21:35 | Manassas, Virginia, US | |
247513 | 247513 | 2021-08-17 | US | New York | Montgomery | 36057 | 4428 | 128 | 0 | 42.90123494 | -74.44011632 | 2021-08-18 04:21:35 | Montgomery, New York, US | |
1485126 | 1485126 | 2021-08-13 | US | Maryland | Calvert | 24009 | 4428 | 86 | 0 | 38.53961642 | -76.56820632 | 2021-08-14 04:21:25 | Calvert, Maryland, US | |
1118217 | 1118217 | 2021-08-06 | US | Colorado | La Plata | 8067 | 4428 | 47 | 0 | 37.28632032 | -107.8429014 | 2021-08-07 04:21:30 | La Plata, Colorado, US | |
3387660 | 3387660 | 2021-07-29 | US | New York | Tompkins | 36109 | 4428 | 52 | 0 | 42.44945765 | -76.47229843 | 2021-07-30 04:21:34 | Tompkins, New York, US | |
1307992 | 1307992 | 2021-07-27 | US | Mississippi | Pontotoc | 28115 | 4428 | 73 | 0 | 34.226046000000004 | -89.03636807 | 2021-07-28 04:21:39 | Pontotoc, Mississippi, US | |
3479293 | 3479293 | 2021-07-22 | US | Tennessee | Rhea | 47143 | 4428 | 82 | 0 | 35.60536161 | -84.93076643 | 2021-07-23 04:21:29 | Rhea, Tennessee, 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]);