johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
101 rows where confirmed = 6485 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1833372 | 1833372 | 2022-10-25 | US | Texas | San Jacinto | 48407 | 6485 | 107 | 0 | 30.57933681 | -95.16260304 | 2022-10-26 04:22:19 | San Jacinto, Texas, US | |
797633 | 797633 | 2022-10-24 | US | Texas | San Jacinto | 48407 | 6485 | 107 | 0 | 30.57933681 | -95.16260304 | 2022-10-25 04:21:53 | San Jacinto, Texas, US | |
2970967 | 2970967 | 2022-10-10 | US | Wisconsin | Kewaunee | 55061 | 6485 | 62 | 0 | 44.51727459 | -87.61468386 | 2022-10-11 04:23:05 | Kewaunee, Wisconsin, US | |
2262774 | 2262774 | 2022-10-02 | US | Tennessee | Wayne | 47181 | 6485 | 76 | 0 | 35.23868267 | -87.78644456 | 2022-10-03 04:23:11 | Wayne, Tennessee, US | |
373993 | 373993 | 2022-09-13 | US | Mississippi | Chickasaw | 28017 | 6485 | 98 | 0 | 33.91983202 | -88.9481545 | 2022-09-14 04:20:44 | Chickasaw, Mississippi, US | |
2396595 | 2396595 | 2022-09-12 | US | Mississippi | Chickasaw | 28017 | 6485 | 98 | 0 | 33.91983202 | -88.9481545 | 2022-09-13 04:20:57 | Chickasaw, Mississippi, US | |
3767673 | 3767673 | 2022-09-11 | US | Mississippi | Chickasaw | 28017 | 6485 | 98 | 0 | 33.91983202 | -88.9481545 | 2022-09-12 04:20:58 | Chickasaw, Mississippi, US | |
3826248 | 3826248 | 2022-09-10 | US | Mississippi | Chickasaw | 28017 | 6485 | 98 | 0 | 33.91983202 | -88.9481545 | 2022-09-11 04:20:50 | Chickasaw, Mississippi, US | |
964705 | 964705 | 2022-09-09 | US | Mississippi | Chickasaw | 28017 | 6485 | 98 | 0 | 33.91983202 | -88.9481545 | 2022-09-10 04:21:10 | Chickasaw, Mississippi, US | |
255107 | 255107 | 2022-09-08 | US | Mississippi | Chickasaw | 28017 | 6485 | 98 | 0 | 33.91983202 | -88.9481545 | 2022-09-09 04:21:11 | Chickasaw, Mississippi, US | |
3747903 | 3747903 | 2022-09-07 | US | Puerto Rico | Villalba | 72149 | 6485 | 0 | 0 | 18.127951 | -66.473115 | 2022-09-08 04:21:02 | Villalba, Puerto Rico, US | |
3746905 | 3746905 | 2022-09-07 | US | Mississippi | Chickasaw | 28017 | 6485 | 98 | 0 | 33.91983202 | -88.9481545 | 2022-09-08 04:21:02 | Chickasaw, Mississippi, US | |
116545 | 116545 | 2022-09-06 | US | Mississippi | Chickasaw | 28017 | 6485 | 98 | 0 | 33.91983202 | -88.9481545 | 2022-09-07 04:20:59 | Chickasaw, Mississippi, US | |
2713436 | 2713436 | 2022-09-03 | US | Arkansas | Arkansas | 5001 | 6485 | 82 | 0 | 34.29145151 | -91.37277296 | 2022-09-04 04:21:22 | Arkansas, Arkansas, US | |
1968860 | 1968860 | 2022-08-13 | Saint Kitts and Nevis | 6485 | 46 | 0 | 17.357822 | -62.782998 | 2022-08-14 04:20:55 | Saint Kitts and Nevis | ||||
2888669 | 2888669 | 2022-08-12 | Saint Kitts and Nevis | 6485 | 46 | 0 | 17.357822 | -62.782998 | 2022-08-13 04:20:52 | Saint Kitts and Nevis | ||||
3908274 | 3908274 | 2022-08-11 | Saint Kitts and Nevis | 6485 | 46 | 0 | 17.357822 | -62.782998 | 2022-08-12 04:20:54 | Saint Kitts and Nevis | ||||
1346591 | 1346591 | 2022-08-10 | Saint Kitts and Nevis | 6485 | 46 | 0 | 17.357822 | -62.782998 | 2022-08-11 04:20:49 | Saint Kitts and Nevis | ||||
1943200 | 1943200 | 2022-08-06 | US | Puerto Rico | Aibonito | 72009 | 6485 | 0 | 0 | 18.131361 | -66.264131 | 2022-08-07 04:20:54 | Aibonito, Puerto Rico, US | |
674812 | 674812 | 2022-07-30 | US | Arkansas | Jackson | 5067 | 6485 | 64 | 0 | 35.59802983 | -91.21494602 | 2022-07-31 04:21:02 | Jackson, Arkansas, US | |
1489121 | 1489121 | 2022-07-26 | US | Louisiana | St. James | 22093 | 6485 | 76 | 0 | 30.02531716 | -90.80212061 | 2022-07-27 04:21:04 | St. James, Louisiana, US | |
2595567 | 2595567 | 2022-07-25 | US | Louisiana | St. James | 22093 | 6485 | 76 | 0 | 30.02531716 | -90.80212061 | 2022-07-26 04:20:58 | St. James, Louisiana, US | |
2419361 | 2419361 | 2022-07-15 | US | Arkansas | Carroll | 5015 | 6485 | 107 | 0 | 36.3403856 | -93.54270261 | 2022-07-16 04:21:05 | Carroll, Arkansas, US | |
478377 | 478377 | 2022-06-26 | US | Tennessee | DeKalb | 47041 | 6485 | 102 | 0 | 35.97616272 | -85.83689361 | 2022-06-27 04:21:00 | DeKalb, Tennessee, US | |
3271044 | 3271044 | 2022-06-19 | US | Louisiana | Sabine | 22085 | 6485 | 113 | 0 | 31.56388699 | -93.55433981 | 2022-06-20 04:21:01 | Sabine, Louisiana, US | |
3398956 | 3398956 | 2022-06-18 | US | Louisiana | Sabine | 22085 | 6485 | 113 | 0 | 31.56388699 | -93.55433981 | 2022-06-19 04:20:51 | Sabine, Louisiana, US | |
2312833 | 2312833 | 2022-06-17 | US | Louisiana | Sabine | 22085 | 6485 | 113 | 0 | 31.56388699 | -93.55433981 | 2022-06-18 04:21:10 | Sabine, Louisiana, US | |
560337 | 560337 | 2022-06-16 | US | Louisiana | Sabine | 22085 | 6485 | 113 | 0 | 31.56388699 | -93.55433981 | 2022-06-17 04:20:56 | Sabine, Louisiana, US | |
1187221 | 1187221 | 2022-05-18 | US | Ohio | Henry | 39069 | 6485 | 107 | 0 | 41.3339642 | -84.06830637 | 2022-05-19 04:20:54 | Henry, Ohio, US | |
3585118 | 3585118 | 2022-05-17 | US | Ohio | Henry | 39069 | 6485 | 107 | 0 | 41.3339642 | -84.06830637 | 2022-05-18 04:20:50 | Henry, Ohio, US | |
1506075 | 1506075 | 2022-05-16 | US | Ohio | Henry | 39069 | 6485 | 107 | 0 | 41.3339642 | -84.06830637 | 2022-05-17 04:20:59 | Henry, Ohio, US | |
2086434 | 2086434 | 2022-05-15 | US | Ohio | Henry | 39069 | 6485 | 107 | 0 | 41.3339642 | -84.06830637 | 2022-05-16 04:20:47 | Henry, Ohio, US | |
3357144 | 3357144 | 2022-05-14 | US | Ohio | Henry | 39069 | 6485 | 107 | 0 | 41.3339642 | -84.06830637 | 2022-05-15 04:20:53 | Henry, Ohio, US | |
660789 | 660789 | 2022-05-13 | US | Ohio | Henry | 39069 | 6485 | 107 | 0 | 41.3339642 | -84.06830637 | 2022-05-14 04:20:48 | Henry, Ohio, US | |
2535872 | 2535872 | 2022-05-12 | US | Ohio | Henry | 39069 | 6485 | 107 | 0 | 41.3339642 | -84.06830637 | 2022-05-13 04:20:51 | Henry, Ohio, US | |
25868 | 25868 | 2022-03-20 | US | Kentucky | Rowan | 21205 | 6485 | 57 | 0 | 38.19484205 | -83.42088935 | 2022-03-21 04:20:50 | Rowan, Kentucky, US | |
1657878 | 1657878 | 2022-03-19 | US | Kentucky | Rowan | 21205 | 6485 | 57 | 0 | 38.19484205 | -83.42088935 | 2022-03-20 04:20:45 | Rowan, Kentucky, US | |
337404 | 337404 | 2022-03-18 | US | Kentucky | Rowan | 21205 | 6485 | 57 | 0 | 38.19484205 | -83.42088935 | 2022-03-19 04:20:47 | Rowan, Kentucky, US | |
695857 | 695857 | 2022-03-17 | US | Kentucky | Rowan | 21205 | 6485 | 57 | 0 | 38.19484205 | -83.42088935 | 2022-03-18 04:20:55 | Rowan, Kentucky, US | |
3629113 | 3629113 | 2022-03-13 | US | Indiana | Wells | 18179 | 6485 | 127 | 0 | 40.72934187 | -85.22132966 | 2022-03-14 04:20:46 | Wells, Indiana, US | |
952021 | 952021 | 2022-03-12 | US | Indiana | Wells | 18179 | 6485 | 127 | 0 | 40.72934187 | -85.22132966 | 2022-03-13 04:20:49 | Wells, Indiana, US | |
357482 | 357482 | 2022-03-11 | US | Indiana | Wells | 18179 | 6485 | 127 | 0 | 40.72934187 | -85.22132966 | 2022-03-12 04:20:50 | Wells, Indiana, US | |
3675059 | 3675059 | 2022-02-15 | US | Virginia | Russell | 51167 | 6485 | 94 | 0 | 36.93028320000001 | -82.10095486 | 2022-02-16 04:21:10 | Russell, Virginia, US | |
460282 | 460282 | 2022-02-02 | US | Georgia | White | 13311 | 6485 | 145 | 0 | 34.64624278 | -83.74905525 | 2022-02-03 04:21:21 | White, Georgia, US | |
3812373 | 3812373 | 2022-01-28 | US | Ohio | Adams | 39001 | 6485 | 137 | 0 | 38.84541072 | -83.4718964 | 2022-01-29 04:21:10 | Adams, Ohio, US | |
99437 | 99437 | 2022-01-14 | Monaco | 6485 | 44 | 0 | 43.7333 | 7.4167 | 2022-01-15 04:21:07 | Monaco | ||||
1389692 | 1389692 | 2022-01-07 | Japan | Yamaguchi | 6485 | 93 | 0 | 34.201190000000004 | 131.573293 | 2022-01-08 04:21:53 | Yamaguchi, Japan | |||
2170798 | 2170798 | 2022-01-01 | US | Texas | Titus | 48449 | 6485 | 105 | 0 | 33.21339719 | -94.96797273 | 2022-01-02 04:20:52 | Titus, Texas, US | |
1436087 | 1436087 | 2021-12-28 | US | West Virginia | Wayne | 54099 | 6485 | 94 | 0 | 38.14901357 | -82.42287994 | 2021-12-29 03:21:43 | Wayne, West Virginia, US | |
3605445 | 3605445 | 2021-12-25 | US | Alabama | Franklin | 1059 | 6485 | 110 | 0 | 34.44235334 | -87.84289505 | 2021-12-26 04:21:50 | Franklin, Alabama, US | |
799401 | 799401 | 2021-12-22 | US | Illinois | Christian | 17021 | 6485 | 84 | 0 | 39.54581621 | -89.27780482 | 2021-12-23 04:21:21 | Christian, Illinois, US | |
1017772 | 1017772 | 2021-11-21 | US | Washington | Douglas | 53017 | 6485 | 43 | 0 | 47.7361335 | -119.69293700000001 | 2021-11-22 04:22:20 | Douglas, Washington, US | |
725936 | 725936 | 2021-11-20 | US | Washington | Douglas | 53017 | 6485 | 43 | 0 | 47.7361335 | -119.69293700000001 | 2021-11-21 04:22:13 | Douglas, Washington, US | |
165466 | 165466 | 2021-11-19 | US | Washington | Douglas | 53017 | 6485 | 43 | 0 | 47.7361335 | -119.69293700000001 | 2021-11-20 04:22:17 | Douglas, Washington, US | |
2845348 | 2845348 | 2021-11-10 | US | Arkansas | Independence | 5063 | 6485 | 159 | 0 | 35.74242707 | -91.57001641 | 2021-11-11 04:21:45 | Independence, Arkansas, US | |
2003909 | 2003909 | 2021-11-07 | US | Texas | Waller | 48473 | 6485 | 81 | 0 | 30.01058447 | -95.99011759 | 2021-11-08 04:21:43 | Waller, Texas, US | |
1886747 | 1886747 | 2021-09-12 | US | Minnesota | Otter Tail | 27111 | 6485 | 90 | 0 | 46.40846929 | -95.70835255 | 2021-09-13 04:21:15 | Otter Tail, Minnesota, US | |
3807650 | 3807650 | 2021-09-11 | US | Minnesota | Otter Tail | 27111 | 6485 | 90 | 0 | 46.40846929 | -95.70835255 | 2021-09-12 04:21:13 | Otter Tail, Minnesota, US | |
3450590 | 3450590 | 2021-09-10 | US | Minnesota | Otter Tail | 27111 | 6485 | 90 | 0 | 46.40846929 | -95.70835255 | 2021-09-11 04:21:30 | Otter Tail, Minnesota, US | |
644597 | 644597 | 2021-09-07 | US | Pennsylvania | Columbia | 42037 | 6485 | 138 | 0 | 41.04821986 | -76.40565017 | 2021-09-08 04:21:31 | Columbia, Pennsylvania, US | |
1959152 | 1959152 | 2021-08-05 | US | Oregon | Linn | 41043 | 6485 | 82 | 0 | 44.48899494 | -122.5373154 | 2021-08-06 04:21:18 | Linn, Oregon, US | |
3386962 | 3386962 | 2021-07-29 | US | Maryland | Cecil | 24015 | 6485 | 158 | 0 | 39.56647682 | -75.94627411 | 2021-07-30 04:21:34 | Cecil, Maryland, US | |
3220113 | 3220113 | 2021-07-26 | US | Mississippi | Lafayette | 28071 | 6485 | 124 | 0 | 34.35687874 | -89.48490961 | 2021-07-27 04:21:18 | Lafayette, Mississippi, US | |
2372124 | 2372124 | 2021-07-20 | US | Colorado | Eagle | 8037 | 6485 | 25 | 0 | 39.62754308 | -106.6933637 | 2021-07-21 04:21:40 | Eagle, Colorado, US | |
3634629 | 3634629 | 2021-07-14 | US | Pennsylvania | Indiana | 42063 | 6485 | 179 | 0 | 40.65241041 | -79.08963285 | 2021-07-15 04:21:48 | Indiana, Pennsylvania, US | |
2764953 | 2764953 | 2021-07-01 | Japan | Kumamoto | 6485 | 117 | 6306 | 62 | 32.608154 | 130.74523100000002 | 2021-07-02 04:21:47 | Kumamoto, Japan | ||
21132 | 21132 | 2021-05-28 | US | Georgia | Catoosa | 13047 | 6485 | 71 | 0 | 34.89872298 | -85.13757014 | 2021-05-29 04:20:41 | Catoosa, Georgia, US | |
85599 | 85599 | 2021-05-25 | US | Ohio | Scioto | 39145 | 6485 | 106 | 0 | 38.80270163 | -82.98907345 | 2021-05-26 04:20:35 | Scioto, Ohio, US | |
2394116 | 2394116 | 2021-05-18 | US | Virginia | Harrisonburg | 51660 | 6485 | 94 | 0 | 38.43542574 | -78.87536254 | 2021-05-19 04:20:42 | Harrisonburg, Virginia, US | |
3577941 | 3577941 | 2021-05-17 | US | Virginia | Harrisonburg | 51660 | 6485 | 94 | 0 | 38.43542574 | -78.87536254 | 2021-05-18 04:20:33 | Harrisonburg, Virginia, US | |
2940914 | 2940914 | 2021-05-16 | US | Massachusetts | Berkshire | 25003 | 6485 | 243 | 0 | 42.37428441 | -73.20524838 | 2021-05-17 04:20:34 | Berkshire, Massachusetts, US | |
2824437 | 2824437 | 2021-05-10 | Yemen | 6485 | 1275 | 3001 | 2209 | 15.552727 | 48.516388 | 2021-05-11 04:20:41 | Yemen | |||
1639248 | 1639248 | 2021-04-29 | US | Tennessee | Gibson | 47053 | 6485 | 143 | 0 | 35.99438059 | -88.93358327 | 2021-04-30 04:21:03 | Gibson, Tennessee, US | |
39337 | 39337 | 2021-04-12 | US | Tennessee | Bedford | 47003 | 6485 | 125 | 0 | 35.51123746 | -86.45549096 | 2021-04-13 04:20:37 | Bedford, Tennessee, US | |
2647964 | 2647964 | 2021-04-08 | US | New Mexico | Valencia | 35061 | 6485 | 104 | 0 | 34.71669834 | -106.8103733 | 2021-04-09 04:21:13 | Valencia, New Mexico, US | |
3664546 | 3664546 | 2021-03-09 | US | Idaho | Madison | 16065 | 6485 | 22 | 0 | 43.78141028 | -111.65384740000002 | 2021-03-10 05:24:35 | Madison, Idaho, US | |
531017 | 531017 | 2021-02-22 | Sweden | Jamtland Harjedalen | 6485 | 113 | 0 | 6372 | 63.1712 | 14.9592 | 2021-02-23 05:23:41 | Jamtland Harjedalen, Sweden | ||
182351 | 182351 | 2021-02-21 | Sweden | Jamtland Harjedalen | 6485 | 113 | 0 | 6372 | 63.1712 | 14.9592 | 2021-02-22 05:24:21 | Jamtland Harjedalen, Sweden | ||
742625 | 742625 | 2021-02-20 | Sweden | Jamtland Harjedalen | 6485 | 113 | 0 | 6372 | 63.1712 | 14.9592 | 2021-02-21 05:24:33 | Jamtland Harjedalen, Sweden | ||
471723 | 471723 | 2021-02-19 | Sweden | Jamtland Harjedalen | 6485 | 113 | 0 | 6372 | 63.1712 | 14.9592 | 2021-02-20 05:22:51 | Jamtland Harjedalen, Sweden | ||
1530249 | 1530249 | 2021-02-09 | US | North Carolina | Rockingham | 37157 | 6485 | 51 | 0 | 6434 | 36.39593137 | -79.77504841 | 2021-02-10 05:22:41 | Rockingham, North Carolina, US |
1463151 | 1463151 | 2021-01-31 | US | Virginia | Roanoke | 51161 | 6485 | 78 | 0 | 6407 | 37.26865804 | -80.06396753 | 2021-02-01 05:22:53 | Roanoke, Virginia, US |
908905 | 908905 | 2021-01-19 | US | Florida | Sumter | 12119 | 6485 | 157 | 0 | 6328 | 28.70181754 | -82.0794267 | 2021-01-20 05:21:54 | Sumter, Florida, US |
3035806 | 3035806 | 2021-01-05 | US | Louisiana | Lafourche | 22057 | 6485 | 163 | 0 | 6322 | 29.52470226 | -90.40976986 | 2021-01-06 05:22:16 | Lafourche, Louisiana, US |
3691646 | 3691646 | 2020-12-24 | Peru | Pasco | 6485 | 324 | 0 | 6161 | -10.39655 | -75.307635 | 2020-12-25 05:22:48 | Pasco, Peru | ||
2407927 | 2407927 | 2020-12-23 | US | Indiana | Kosciusko | 18085 | 6485 | 76 | 0 | 6409 | 41.24521668 | -85.86312322 | 2020-12-24 05:23:04 | Kosciusko, Indiana, US |
2406998 | 2406998 | 2020-12-23 | Peru | Pasco | 6485 | 323 | 0 | 6162 | -10.39655 | -75.307635 | 2020-12-24 05:23:04 | Pasco, Peru | ||
931360 | 931360 | 2020-12-21 | China | Unknown | 6485 | 0 | 0 | 0 | 2020-12-22 05:22:33 | Unknown, China | ||||
2128506 | 2128506 | 2020-12-17 | US | Arkansas | Saline | 5125 | 6485 | 82 | 0 | 6403 | 34.64916145 | -92.67583224 | 2020-12-18 05:28:18 | Saline, Arkansas, US |
1633012 | 1633012 | 2020-12-05 | US | Florida | Martin | 12085 | 6485 | 179 | 0 | 6306 | 27.0772071 | -80.43109784 | 2020-12-06 05:26:18 | Martin, Florida, US |
925250 | 925250 | 2020-11-26 | US | Maryland | Frederick | 24021 | 6485 | 146 | 0 | 6339 | 39.47296601 | -77.39999394 | 2020-11-27 05:26:53 | Frederick, Maryland, US |
2788625 | 2788625 | 2020-11-13 | Ukraine | Kherson Oblast | 6485 | 135 | 2539 | 3811 | 46.6354 | 32.6169 | 2020-11-14 05:25:37 | Kherson Oblast, Ukraine | ||
2785727 | 2785727 | 2020-11-13 | US | Florida | Santa Rosa | 12113 | 6485 | 90 | 0 | 6395 | 30.693414500000006 | -87.02458128 | 2020-11-14 05:25:37 | Santa Rosa, Florida, US |
2291433 | 2291433 | 2020-10-12 | Italy | P.A. Trento | 6485 | 409 | 5396 | 680 | 46.06893511 | 11.12123097 | 2020-10-13 04:24:02 | P.A. Trento, Italy | ||
750303 | 750303 | 2020-08-01 | US | Texas | Brazoria | 48039 | 6485 | 72 | 0 | 6462 | 29.18757369 | -95.44563172 | 2020-08-02 04:34:47 | Brazoria, Texas, US |
177320 | 177320 | 2020-07-27 | Russia | Orenburg Oblast | 6485 | 41 | 4798 | 1646 | 52.02692620000001 | 54.7276647 | 2020-07-28 04:58:43 | Orenburg Oblast, Russia | ||
844725 | 844725 | 2020-07-22 | India | Jharkhand | 6485 | 64 | 3024 | 3397 | 23.654536 | 85.557631 | 2020-07-23 05:15:04 | Jharkhand, India | ||
1005813 | 1005813 | 2020-07-09 | Costa Rica | 6485 | 25 | 2023 | 4437 | 9.7489 | -83.7534 | 2020-07-10 04:34:24 | Costa Rica | |||
1270053 | 1270053 | 2020-06-05 | Guatemala | 6485 | 216 | 1053 | 5216 | 15.7835 | -90.2308 | 2020-06-06 02:33:00 | Guatemala | |||
802847 | 802847 | 2020-06-01 | US | Colorado | Denver | 8031 | 6485 | 369 | 0 | 5473 | 39.76018276 | -104.87256950000001 | 2020-06-02 02:33:08 | Denver, Colorado, 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]);