johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
110 rows where confirmed = 6604 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2182948 | 2182948 | 2022-12-22 | US | Virginia | King George | 51099 | 6604 | 52 | 0 | 38.26818502 | -77.15852768 | 2022-12-23 04:21:04 | King George, Virginia, US | |
349312 | 349312 | 2022-12-14 | US | Illinois | Lawrence | 17101 | 6604 | 45 | 0 | 38.71987914 | -87.72884035 | 2022-12-15 04:20:58 | Lawrence, Illinois, US | |
3939054 | 3939054 | 2022-12-09 | US | Tennessee | Wayne | 47181 | 6604 | 80 | 0 | 35.23868267 | -87.78644456 | 2022-12-10 04:21:02 | Wayne, Tennessee, US | |
1968128 | 1968128 | 2022-11-30 | US | Wisconsin | Iowa | 55049 | 6604 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-12-01 04:21:03 | Iowa, Wisconsin, US | |
2440717 | 2440717 | 2022-11-07 | US | Missouri | Stone | 29209 | 6604 | 128 | 0 | 36.75000327 | -93.45256475 | 2022-11-08 04:21:21 | Stone, Missouri, US | |
1051815 | 1051815 | 2022-11-06 | US | Missouri | Stone | 29209 | 6604 | 128 | 0 | 36.75000327 | -93.45256475 | 2022-11-07 04:21:26 | Stone, Missouri, US | |
619839 | 619839 | 2022-11-05 | US | Missouri | Stone | 29209 | 6604 | 128 | 0 | 36.75000327 | -93.45256475 | 2022-11-06 04:21:24 | Stone, Missouri, US | |
1024343 | 1024343 | 2022-11-04 | US | Missouri | Stone | 29209 | 6604 | 128 | 0 | 36.75000327 | -93.45256475 | 2022-11-05 04:21:52 | Stone, Missouri, US | |
433334 | 433334 | 2022-11-03 | US | Missouri | Stone | 29209 | 6604 | 128 | 0 | 36.75000327 | -93.45256475 | 2022-11-04 04:22:11 | Stone, Missouri, US | |
851576 | 851576 | 2022-11-02 | US | Missouri | Stone | 29209 | 6604 | 128 | 0 | 36.75000327 | -93.45256475 | 2022-11-03 04:22:05 | Stone, Missouri, US | |
712427 | 712427 | 2022-11-01 | US | Missouri | Stone | 29209 | 6604 | 128 | 0 | 36.75000327 | -93.45256475 | 2022-11-02 04:22:09 | Stone, Missouri, US | |
3041889 | 3041889 | 2022-10-27 | US | Wisconsin | Jackson | 55053 | 6604 | 45 | 0 | 44.31864893 | -90.80566792 | 2022-10-28 04:22:31 | Jackson, Wisconsin, US | |
541486 | 541486 | 2022-10-26 | US | Puerto Rico | Catano | 72033 | 6604 | 0 | 0 | 18.437269 | -66.143306 | 2022-10-27 04:22:01 | Catano, Puerto Rico, US | |
3989647 | 3989647 | 2022-09-15 | US | Texas | Austin | 48015 | 6604 | 81 | 0 | 29.88548725 | -96.27736949 | 2022-09-16 04:21:19 | Austin, Texas, US | |
3989405 | 3989405 | 2022-09-15 | US | Puerto Rico | Salinas | 72123 | 6604 | 0 | 0 | 18.010387 | -66.256592 | 2022-09-16 04:21:19 | Salinas, Puerto Rico, US | |
1892164 | 1892164 | 2022-09-14 | US | Texas | Austin | 48015 | 6604 | 81 | 0 | 29.88548725 | -96.27736949 | 2022-09-15 04:21:02 | Austin, Texas, US | |
1396465 | 1396465 | 2022-09-02 | US | Puerto Rico | Utuado | 72141 | 6604 | 0 | 0 | 18.271214 | -66.702984 | 2022-09-03 04:21:04 | Utuado, Puerto Rico, US | |
2403330 | 2403330 | 2022-08-21 | US | Arkansas | Jackson | 5067 | 6604 | 67 | 0 | 35.59802983 | -91.21494602 | 2022-08-22 04:20:38 | Jackson, Arkansas, US | |
3798408 | 3798408 | 2022-08-20 | US | Arkansas | Jackson | 5067 | 6604 | 67 | 0 | 35.59802983 | -91.21494602 | 2022-08-21 04:20:44 | Jackson, Arkansas, US | |
630550 | 630550 | 2022-07-12 | US | Colorado | Montezuma | 8083 | 6604 | 83 | 0 | 37.33859579 | -108.5958857 | 2022-07-13 04:20:58 | Montezuma, Colorado, US | |
144233 | 144233 | 2022-07-09 | US | New York | Lewis | 36049 | 6604 | 50 | 0 | 43.7844157 | -75.44903992 | 2022-07-10 04:20:54 | Lewis, New York, US | |
1419333 | 1419333 | 2022-07-08 | US | New York | Lewis | 36049 | 6604 | 50 | 0 | 43.7844157 | -75.44903992 | 2022-07-09 04:20:59 | Lewis, New York, US | |
1203398 | 1203398 | 2022-07-06 | US | Wisconsin | Vernon | 55123 | 6604 | 102 | 0 | 43.59422667 | -90.8324691 | 2022-07-07 04:20:55 | Vernon, Wisconsin, US | |
3201738 | 3201738 | 2022-05-29 | US | Wisconsin | Waushara | 55137 | 6604 | 87 | 0 | 44.11324419 | -89.24317107 | 2022-05-30 04:20:50 | Waushara, Wisconsin, US | |
2728616 | 2728616 | 2022-05-28 | US | Wisconsin | Waushara | 55137 | 6604 | 87 | 0 | 44.11324419 | -89.24317107 | 2022-05-29 04:20:53 | Waushara, Wisconsin, US | |
1317797 | 1317797 | 2022-05-27 | US | Wisconsin | Waushara | 55137 | 6604 | 87 | 0 | 44.11324419 | -89.24317107 | 2022-05-28 04:21:07 | Waushara, Wisconsin, US | |
697706 | 697706 | 2022-03-17 | US | Virginia | Carroll | 51035 | 6604 | 141 | 0 | 36.73066666 | -80.73455942 | 2022-03-18 04:20:55 | Carroll, Virginia, US | |
262840 | 262840 | 2022-03-15 | US | Kansas | Labette | 20099 | 6604 | 72 | 0 | 37.19113093 | -95.29849679 | 2022-03-16 04:20:50 | Labette, Kansas, US | |
2266607 | 2266607 | 2022-03-14 | US | Puerto Rico | Aguadilla | 72005 | 6604 | 0 | 0 | 18.459681 | -67.12081500000001 | 2022-03-15 04:20:47 | Aguadilla, Puerto Rico, US | |
2265199 | 2265199 | 2022-03-14 | US | Kansas | Labette | 20099 | 6604 | 72 | 0 | 37.19113093 | -95.29849679 | 2022-03-15 04:20:47 | Labette, Kansas, US | |
3630673 | 3630673 | 2022-03-13 | US | Puerto Rico | Aguadilla | 72005 | 6604 | 0 | 0 | 18.459681 | -67.12081500000001 | 2022-03-14 04:20:46 | Aguadilla, Puerto Rico, US | |
1866225 | 1866225 | 2022-03-10 | US | Florida | Washington | 12133 | 6604 | 104 | 0 | 30.61359259 | -85.66002461 | 2022-03-11 04:20:50 | Washington, Florida, US | |
2140920 | 2140920 | 2022-03-09 | US | Florida | Washington | 12133 | 6604 | 104 | 0 | 30.61359259 | -85.66002461 | 2022-03-10 04:20:48 | Washington, Florida, US | |
920431 | 920431 | 2022-03-08 | US | Florida | Washington | 12133 | 6604 | 104 | 0 | 30.61359259 | -85.66002461 | 2022-03-09 04:20:59 | Washington, Florida, US | |
1548718 | 1548718 | 2022-03-07 | US | Florida | Washington | 12133 | 6604 | 104 | 0 | 30.61359259 | -85.66002461 | 2022-03-08 04:20:54 | Washington, Florida, US | |
2200387 | 2200387 | 2022-03-06 | US | Florida | Washington | 12133 | 6604 | 104 | 0 | 30.61359259 | -85.66002461 | 2022-03-07 04:20:47 | Washington, Florida, US | |
2092844 | 2092844 | 2022-03-05 | US | Florida | Washington | 12133 | 6604 | 104 | 0 | 30.61359259 | -85.66002461 | 2022-03-06 04:20:49 | Washington, Florida, US | |
2668925 | 2668925 | 2022-03-04 | US | Texas | Hutchinson | 48233 | 6604 | 133 | 0 | 35.84006574 | -101.3546643 | 2022-03-05 04:21:10 | Hutchinson, Texas, US | |
2666544 | 2666544 | 2022-03-04 | US | Florida | Washington | 12133 | 6604 | 104 | 0 | 30.61359259 | -85.66002461 | 2022-03-05 04:21:10 | Washington, Florida, US | |
2448204 | 2448204 | 2022-02-22 | US | Kentucky | Letcher | 21133 | 6604 | 90 | 0 | 37.12306748 | -82.85346474 | 2022-02-23 04:21:09 | Letcher, Kentucky, US | |
3674909 | 3674909 | 2022-02-15 | US | Texas | Willacy | 48489 | 6604 | 123 | 0 | 26.47411727 | -97.61535848 | 2022-02-16 04:21:10 | Willacy, Texas, US | |
3674737 | 3674737 | 2022-02-15 | US | Texas | Fannin | 48147 | 6604 | 169 | 0 | 33.59564294 | -96.10751083 | 2022-02-16 04:21:10 | Fannin, Texas, US | |
2475856 | 2475856 | 2022-02-03 | US | Missouri | Dunklin | 29069 | 6604 | 93 | 0 | 36.27167174 | -90.09122243 | 2022-02-04 04:21:10 | Dunklin, Missouri, US | |
462003 | 462003 | 2022-02-02 | US | Oregon | Jefferson | 41031 | 6604 | 73 | 0 | 44.62806839 | -121.17832 | 2022-02-03 04:21:21 | Jefferson, Oregon, US | |
2835779 | 2835779 | 2022-01-22 | US | Tennessee | Hardeman | 47069 | 6604 | 100 | 0 | 35.20772017 | -88.99161161 | 2022-01-23 04:21:13 | Hardeman, Tennessee, US | |
3226723 | 3226723 | 2022-01-19 | Saint Vincent and the Grenadines | 6604 | 88 | 0 | 12.9843 | -61.2872 | 2022-01-20 04:21:07 | Saint Vincent and the Grenadines | ||||
3466807 | 3466807 | 2022-01-18 | US | Oregon | Malheur | 41045 | 6604 | 95 | 0 | 43.1937027 | -117.62273950000001 | 2022-01-19 04:21:23 | Malheur, Oregon, US | |
3464448 | 3464448 | 2022-01-18 | Saint Vincent and the Grenadines | 6604 | 88 | 0 | 12.9843 | -61.2872 | 2022-01-19 04:21:23 | Saint Vincent and the Grenadines | ||||
3688893 | 3688893 | 2022-01-13 | US | Kentucky | Harlan | 21095 | 6604 | 164 | 0 | 36.85699301 | -83.21899516 | 2022-01-14 04:21:54 | Harlan, Kentucky, US | |
3615916 | 3615916 | 2022-01-12 | US | South Dakota | Brookings | 46011 | 6604 | 41 | 0 | 44.36974375 | -96.79079945 | 2022-01-13 08:00:09 | Brookings, South Dakota, US | |
3615357 | 3615357 | 2022-01-12 | US | North Carolina | Bladen | 37017 | 6604 | 100 | 0 | 34.61296243 | -78.56180059 | 2022-01-13 08:00:09 | Bladen, North Carolina, US | |
1114483 | 1114483 | 2022-01-11 | US | Georgia | Upson | 13293 | 6604 | 193 | 0 | 32.87920671 | -84.30024826 | 2022-01-12 04:21:44 | Upson, Georgia, US | |
2966052 | 2966052 | 2021-12-24 | US | Pennsylvania | Clinton | 42035 | 6604 | 102 | 0 | 41.23255967 | -77.63785995 | 2021-12-25 04:21:37 | Clinton, Pennsylvania, US | |
2905835 | 2905835 | 2021-12-19 | US | Nebraska | Scotts Bluff | 31157 | 6604 | 48 | 0 | 41.85070896 | -103.70809859999999 | 2021-12-20 04:21:43 | Scotts Bluff, Nebraska, US | |
1260908 | 1260908 | 2021-12-18 | US | Nebraska | Scotts Bluff | 31157 | 6604 | 48 | 0 | 41.85070896 | -103.70809859999999 | 2021-12-19 04:21:11 | Scotts Bluff, Nebraska, US | |
2400936 | 2400936 | 2021-12-17 | US | Nebraska | Scotts Bluff | 31157 | 6604 | 48 | 0 | 41.85070896 | -103.70809859999999 | 2021-12-18 02:22:20 | Scotts Bluff, Nebraska, US | |
1718586 | 1718586 | 2021-12-16 | US | New York | Cortland | 36023 | 6604 | 90 | 0 | 42.59509207 | -76.07048931 | 2021-12-17 04:22:14 | Cortland, New York, US | |
1661557 | 1661557 | 2021-12-12 | US | Indiana | Putnam | 18133 | 6604 | 86 | 0 | 39.66437981 | -86.84517605 | 2021-12-13 04:22:02 | Putnam, Indiana, US | |
1665573 | 1665573 | 2021-12-11 | US | Indiana | Putnam | 18133 | 6604 | 86 | 0 | 39.66437981 | -86.84517605 | 2021-12-12 04:22:12 | Putnam, Indiana, US | |
3656725 | 3656725 | 2021-12-10 | US | Indiana | Putnam | 18133 | 6604 | 86 | 0 | 39.66437981 | -86.84517605 | 2021-12-11 04:22:45 | Putnam, Indiana, US | |
551838 | 551838 | 2021-12-08 | US | Illinois | Woodford | 17203 | 6604 | 93 | 0 | 40.78579374 | -89.20973757 | 2021-12-09 04:22:49 | Woodford, Illinois, US | |
1742813 | 1742813 | 2021-12-05 | US | New York | Tioga | 36107 | 6604 | 74 | 0 | 42.16852837 | -76.30835812 | 2021-12-06 04:22:34 | Tioga, New York, US | |
3290745 | 3290745 | 2021-11-18 | US | Mississippi | Marshall | 28093 | 6604 | 141 | 0 | 34.76216286 | -89.50299462 | 2021-11-19 04:21:40 | Marshall, Mississippi, US | |
497898 | 497898 | 2021-11-06 | US | New York | Madison | 36053 | 6604 | 107 | 0 | 42.91653905 | -75.67266639 | 2021-11-07 04:21:53 | Madison, New York, US | |
3512499 | 3512499 | 2021-11-01 | US | Indiana | Harrison | 18061 | 6604 | 95 | 0 | 38.19467379 | -86.10948271 | 2021-11-02 04:22:03 | Harrison, Indiana, US | |
3493173 | 3493173 | 2021-10-26 | US | Illinois | Jefferson | 17081 | 6604 | 143 | 0 | 38.29980057 | -88.9240025 | 2021-10-27 04:22:32 | Jefferson, Illinois, US | |
636225 | 636225 | 2021-10-13 | US | North Carolina | Chatham | 37037 | 6604 | 91 | 0 | 35.70394416 | -79.25541492 | 2021-10-14 04:21:29 | Chatham, North Carolina, US | |
635756 | 635756 | 2021-10-13 | US | Mississippi | Neshoba | 28099 | 6604 | 204 | 0 | 32.75339664 | -89.11726492 | 2021-10-14 04:21:29 | Neshoba, Mississippi, US | |
426025 | 426025 | 2021-10-10 | US | Pennsylvania | Huntingdon | 42061 | 6604 | 150 | 0 | 40.42162652 | -77.97673273 | 2021-10-11 04:21:31 | Huntingdon, Pennsylvania, US | |
470747 | 470747 | 2021-10-07 | US | Virginia | Fauquier | 51061 | 6604 | 81 | 0 | 38.73564842 | -77.80647472 | 2021-10-08 04:21:25 | Fauquier, Virginia, US | |
1336788 | 1336788 | 2021-09-28 | US | Ohio | Seneca | 39147 | 6604 | 145 | 0 | 41.12351311 | -83.12783209 | 2021-09-29 04:21:45 | Seneca, Ohio, US | |
1887831 | 1887831 | 2021-09-12 | US | South Carolina | Newberry | 45071 | 6604 | 124 | 0 | 34.28629098 | -81.59935761 | 2021-09-13 04:21:15 | Newberry, South Carolina, US | |
3808734 | 3808734 | 2021-09-11 | US | South Carolina | Newberry | 45071 | 6604 | 124 | 0 | 34.28629098 | -81.59935761 | 2021-09-12 04:21:13 | Newberry, South Carolina, US | |
3451674 | 3451674 | 2021-09-10 | US | South Carolina | Newberry | 45071 | 6604 | 124 | 0 | 34.28629098 | -81.59935761 | 2021-09-11 04:21:30 | Newberry, South Carolina, US | |
179476 | 179476 | 2021-09-02 | US | Kentucky | Nelson | 21179 | 6604 | 68 | 0 | 37.80335779 | -85.4657193 | 2021-09-03 04:21:20 | Nelson, Kentucky, US | |
248240 | 248240 | 2021-08-17 | US | Tennessee | Monroe | 47123 | 6604 | 98 | 0 | 35.44550387 | -84.24902965 | 2021-08-18 04:21:35 | Monroe, Tennessee, US | |
1486209 | 1486209 | 2021-08-13 | US | Pennsylvania | Carbon | 42025 | 6604 | 176 | 0 | 40.91545395 | -75.7068525 | 2021-08-14 04:21:25 | Carbon, Pennsylvania, US | |
3471123 | 3471123 | 2021-08-03 | US | Tennessee | Hawkins | 47073 | 6604 | 116 | 0 | 36.44355426 | -82.94885298 | 2021-08-04 04:21:25 | Hawkins, Tennessee, US | |
3685266 | 3685266 | 2021-08-02 | US | Mississippi | Lafayette | 28071 | 6604 | 125 | 0 | 34.35687874 | -89.48490961 | 2021-08-03 04:21:39 | Lafayette, Mississippi, US | |
3477903 | 3477903 | 2021-07-22 | US | Massachusetts | Berkshire | 25003 | 6604 | 247 | 0 | 42.37428441 | -73.20524838 | 2021-07-23 04:21:29 | Berkshire, Massachusetts, US | |
581949 | 581949 | 2021-07-13 | US | Texas | Hood | 48221 | 6604 | 134 | 0 | 32.42990927 | -97.83242024 | 2021-07-14 04:21:35 | Hood, Texas, US | |
3742904 | 3742904 | 2021-07-12 | US | Mississippi | Lowndes | 28087 | 6604 | 150 | 0 | 33.47386518 | -88.44191529999998 | 2021-07-13 04:21:18 | Lowndes, Mississippi, US | |
2693824 | 2693824 | 2021-07-06 | Nicaragua | 6604 | 191 | 4225 | 4044 | 12.865416 | -85.207229 | 2021-07-07 04:21:20 | Nicaragua | |||
1933897 | 1933897 | 2021-07-05 | US | Kentucky | Pulaski | 21199 | 6604 | 111 | 0 | 37.10466131 | -84.57629079 | 2021-07-06 04:21:32 | Pulaski, Kentucky, US | |
1932573 | 1932573 | 2021-07-05 | Nicaragua | 6604 | 191 | 4225 | 3762 | 12.865416 | -85.207229 | 2021-07-06 04:21:32 | Nicaragua | |||
1166628 | 1166628 | 2021-07-04 | US | Kentucky | Pulaski | 21199 | 6604 | 111 | 0 | 37.10466131 | -84.57629079 | 2021-07-05 04:21:28 | Pulaski, Kentucky, US | |
1165304 | 1165304 | 2021-07-04 | Nicaragua | 6604 | 191 | 4225 | 3762 | 12.865416 | -85.207229 | 2021-07-05 04:21:28 | Nicaragua | |||
1495738 | 1495738 | 2021-07-03 | Nicaragua | 6604 | 191 | 4225 | 3762 | 12.865416 | -85.207229 | 2021-07-04 04:21:38 | Nicaragua | |||
2072053 | 2072053 | 2021-07-02 | Nicaragua | 6604 | 191 | 4225 | 3762 | 12.865416 | -85.207229 | 2021-07-03 04:21:37 | Nicaragua | |||
2765069 | 2765069 | 2021-07-01 | Nicaragua | 6604 | 191 | 4225 | 3762 | 12.865416 | -85.207229 | 2021-07-02 04:21:47 | Nicaragua | |||
1893277 | 1893277 | 2021-06-30 | Nicaragua | 6604 | 191 | 4225 | 3762 | 12.865416 | -85.207229 | 2021-07-01 04:21:19 | Nicaragua | |||
3960059 | 3960059 | 2021-06-26 | US | Maine | Kennebec | 23011 | 6604 | 74 | 0 | 44.40759555 | -69.76738544 | 2021-06-27 04:21:39 | Kennebec, Maine, US | |
3472232 | 3472232 | 2021-06-08 | Iceland | 6604 | 30 | 6476 | 98 | 64.9631 | -19.0208 | 2021-06-09 04:23:31 | Iceland | |||
3145516 | 3145516 | 2021-06-07 | Iceland | 6604 | 30 | 6476 | 98 | 64.9631 | -19.0208 | 2021-06-08 04:22:35 | Iceland | |||
825518 | 825518 | 2021-06-06 | Iceland | 6604 | 30 | 6476 | 98 | 64.9631 | -19.0208 | 2021-06-07 04:22:51 | Iceland | |||
3955927 | 3955927 | 2021-05-11 | US | Kentucky | McCracken | 21145 | 6604 | 123 | 0 | 37.05350953 | -88.70445755 | 2021-05-12 04:21:29 | McCracken, Kentucky, US | |
2452191 | 2452191 | 2021-05-02 | US | Kentucky | Laurel | 21125 | 6604 | 70 | 0 | 37.10975748 | -84.11321779 | 2021-05-03 04:20:39 | Laurel, Kentucky, US | |
889182 | 889182 | 2021-04-26 | US | Indiana | Boone | 18011 | 6604 | 100 | 0 | 40.0509304 | -86.46841646 | 2021-04-27 04:20:52 | Boone, Indiana, US | |
3006744 | 3006744 | 2021-04-06 | US | Washington | Kitsap | 53035 | 6604 | 95 | 0 | 47.63479026 | -122.6436061 | 2021-04-07 04:20:53 | Kitsap, Washington, US | |
3372248 | 3372248 | 2021-03-21 | US | Tennessee | Coffee | 47031 | 6604 | 117 | 0 | 35.49090731 | -86.07311784 | 2021-03-22 05:25:43 | Coffee, 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]);