johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
184 rows where confirmed = 4448 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755748 | 2755748 | 2022-12-29 | US | South Carolina | Saluda | 45081 | 4448 | 84 | 0 | 34.00795823 | -81.72713237 | 2022-12-30 04:21:04 | Saluda, South Carolina, US | |
1076754 | 1076754 | 2022-12-28 | US | South Carolina | Saluda | 45081 | 4448 | 84 | 0 | 34.00795823 | -81.72713237 | 2022-12-29 04:21:01 | Saluda, South Carolina, US | |
330751 | 330751 | 2022-12-27 | US | South Carolina | Saluda | 45081 | 4448 | 84 | 0 | 34.00795823 | -81.72713237 | 2022-12-28 04:21:04 | Saluda, South Carolina, US | |
2952143 | 2952143 | 2022-12-20 | US | Georgia | Banks | 13011 | 4448 | 100 | 0 | 34.35607081 | -83.49644388 | 2022-12-21 04:21:03 | Banks, Georgia, US | |
3174545 | 3174545 | 2022-12-19 | US | Georgia | Banks | 13011 | 4448 | 100 | 0 | 34.35607081 | -83.49644388 | 2022-12-20 04:21:04 | Banks, Georgia, US | |
1629062 | 1629062 | 2022-12-18 | US | Georgia | Banks | 13011 | 4448 | 100 | 0 | 34.35607081 | -83.49644388 | 2022-12-19 04:21:03 | Banks, Georgia, US | |
504441 | 504441 | 2022-12-17 | US | Georgia | Banks | 13011 | 4448 | 100 | 0 | 34.35607081 | -83.49644388 | 2022-12-18 04:21:03 | Banks, Georgia, US | |
3325013 | 3325013 | 2022-12-16 | US | Georgia | Banks | 13011 | 4448 | 100 | 0 | 34.35607081 | -83.49644388 | 2022-12-17 04:21:04 | Banks, Georgia, US | |
543525 | 543525 | 2022-12-15 | US | Georgia | Banks | 13011 | 4448 | 100 | 0 | 34.35607081 | -83.49644388 | 2022-12-16 04:21:01 | Banks, Georgia, US | |
349053 | 349053 | 2022-12-14 | US | Georgia | Banks | 13011 | 4448 | 100 | 0 | 34.35607081 | -83.49644388 | 2022-12-15 04:20:58 | Banks, Georgia, US | |
1965070 | 1965070 | 2022-11-30 | US | Arkansas | Howard | 5061 | 4448 | 57 | 0 | 34.09007427 | -93.9934871 | 2022-12-01 04:21:03 | Howard, Arkansas, US | |
1622899 | 1622899 | 2022-11-22 | US | Oregon | Hood River | 41027 | 4448 | 48 | 0 | 45.51872811 | -121.6552036 | 2022-11-23 04:21:06 | Hood River, Oregon, US | |
3462787 | 3462787 | 2022-11-21 | US | Oregon | Hood River | 41027 | 4448 | 48 | 0 | 45.51872811 | -121.6552036 | 2022-11-22 04:20:47 | Hood River, Oregon, US | |
1642972 | 1642972 | 2022-11-20 | US | Oregon | Hood River | 41027 | 4448 | 48 | 0 | 45.51872811 | -121.6552036 | 2022-11-21 04:21:05 | Hood River, Oregon, US | |
2066529 | 2066529 | 2022-11-19 | US | Oregon | Hood River | 41027 | 4448 | 48 | 0 | 45.51872811 | -121.6552036 | 2022-11-20 04:21:08 | Hood River, Oregon, US | |
1757923 | 1757923 | 2022-11-18 | US | Oregon | Hood River | 41027 | 4448 | 48 | 0 | 45.51872811 | -121.6552036 | 2022-11-19 04:21:14 | Hood River, Oregon, US | |
3028916 | 3028916 | 2022-11-17 | US | Oregon | Hood River | 41027 | 4448 | 48 | 0 | 45.51872811 | -121.6552036 | 2022-11-18 04:21:15 | Hood River, Oregon, US | |
2488627 | 2488627 | 2022-11-16 | US | Oregon | Hood River | 41027 | 4448 | 48 | 0 | 45.51872811 | -121.6552036 | 2022-11-17 04:21:11 | Hood River, Oregon, US | |
712669 | 712669 | 2022-11-01 | US | New Mexico | Socorro | 35053 | 4448 | 96 | 0 | 34.00715494 | -106.9298354 | 2022-11-02 04:22:09 | Socorro, New Mexico, US | |
3277929 | 3277929 | 2022-10-23 | US | Illinois | Wabash | 17185 | 4448 | 30 | 0 | 38.44272901 | -87.84922065 | 2022-10-24 04:22:29 | Wabash, Illinois, US | |
2268967 | 2268967 | 2022-10-22 | US | Illinois | Wabash | 17185 | 4448 | 30 | 0 | 38.44272901 | -87.84922065 | 2022-10-23 04:22:46 | Wabash, Illinois, US | |
1593267 | 1593267 | 2022-10-21 | US | Illinois | Wabash | 17185 | 4448 | 30 | 0 | 38.44272901 | -87.84922065 | 2022-10-22 04:22:53 | Wabash, Illinois, US | |
2162480 | 2162480 | 2022-10-16 | US | Tennessee | Grundy | 47061 | 4448 | 79 | 0 | 35.38433717 | -85.72142731 | 2022-10-17 04:20:31 | Grundy, Tennessee, US | |
518677 | 518677 | 2022-10-15 | US | Tennessee | Grundy | 47061 | 4448 | 79 | 0 | 35.38433717 | -85.72142731 | 2022-10-16 04:22:39 | Grundy, Tennessee, US | |
2035734 | 2035734 | 2022-10-14 | US | Tennessee | Grundy | 47061 | 4448 | 79 | 0 | 35.38433717 | -85.72142731 | 2022-10-15 04:22:00 | Grundy, Tennessee, US | |
3251479 | 3251479 | 2022-10-11 | US | Kansas | Osage | 20139 | 4448 | 65 | 0 | 38.65235984 | -95.72707998 | 2022-10-12 04:22:51 | Osage, Kansas, US | |
2968738 | 2968738 | 2022-10-10 | US | Kansas | Osage | 20139 | 4448 | 65 | 0 | 38.65235984 | -95.72707998 | 2022-10-11 04:23:05 | Osage, Kansas, US | |
3098774 | 3098774 | 2022-10-09 | US | Kansas | Osage | 20139 | 4448 | 65 | 0 | 38.65235984 | -95.72707998 | 2022-10-10 04:22:32 | Osage, Kansas, US | |
4003999 | 4003999 | 2022-10-08 | US | Kansas | Osage | 20139 | 4448 | 65 | 0 | 38.65235984 | -95.72707998 | 2022-10-09 04:21:16 | Osage, Kansas, US | |
397596 | 397596 | 2022-10-07 | US | Kansas | Osage | 20139 | 4448 | 65 | 0 | 38.65235984 | -95.72707998 | 2022-10-08 04:22:56 | Osage, Kansas, US | |
2530713 | 2530713 | 2022-10-06 | US | Kansas | Osage | 20139 | 4448 | 65 | 0 | 38.65235984 | -95.72707998 | 2022-10-07 04:23:08 | Osage, Kansas, US | |
2529167 | 2529167 | 2022-10-06 | China | Fujian | 4448 | 1 | 0 | 26.0789 | 117.9874 | 2022-10-07 04:23:08 | Fujian, China | |||
1812107 | 1812107 | 2022-10-05 | US | Kansas | Osage | 20139 | 4448 | 65 | 0 | 38.65235984 | -95.72707998 | 2022-10-06 04:21:22 | Osage, Kansas, US | |
3746133 | 3746133 | 2022-09-07 | US | Illinois | Mason | 17125 | 4448 | 64 | 0 | 40.23917274 | -89.91824452 | 2022-09-08 04:21:02 | Mason, Illinois, US | |
2987807 | 2987807 | 2022-09-04 | US | Arkansas | Polk | 5113 | 4448 | 152 | 0 | 34.48254879 | -94.22728802 | 2022-09-05 04:21:01 | Polk, Arkansas, US | |
3550810 | 3550810 | 2022-09-01 | US | Virginia | Appomattox | 51011 | 4448 | 56 | 0 | 37.37569884 | -78.81340003 | 2022-09-02 04:21:07 | Appomattox, Virginia, US | |
3776666 | 3776666 | 2022-08-30 | US | Puerto Rico | Luquillo | 72089 | 4448 | 0 | 0 | 18.342114 | -65.725097 | 2022-08-31 04:20:57 | Luquillo, Puerto Rico, US | |
2404315 | 2404315 | 2022-08-21 | US | Kentucky | Washington | 21229 | 4448 | 63 | 0 | 37.75599461 | -85.17407732 | 2022-08-22 04:20:38 | Washington, Kentucky, US | |
3799393 | 3799393 | 2022-08-20 | US | Kentucky | Washington | 21229 | 4448 | 63 | 0 | 37.75599461 | -85.17407732 | 2022-08-21 04:20:44 | Washington, Kentucky, US | |
2364979 | 2364979 | 2022-08-19 | US | Kentucky | Washington | 21229 | 4448 | 63 | 0 | 37.75599461 | -85.17407732 | 2022-08-20 04:21:01 | Washington, Kentucky, US | |
1162650 | 1162650 | 2022-08-18 | US | Kentucky | Washington | 21229 | 4448 | 63 | 0 | 37.75599461 | -85.17407732 | 2022-08-19 04:20:54 | Washington, Kentucky, US | |
3951974 | 3951974 | 2022-08-17 | US | Kentucky | Washington | 21229 | 4448 | 63 | 0 | 37.75599461 | -85.17407732 | 2022-08-18 04:21:11 | Washington, Kentucky, US | |
992476 | 992476 | 2022-08-16 | US | Kentucky | Washington | 21229 | 4448 | 63 | 0 | 37.75599461 | -85.17407732 | 2022-08-17 04:20:59 | Washington, Kentucky, US | |
2495515 | 2495515 | 2022-08-15 | US | Kentucky | Washington | 21229 | 4448 | 63 | 0 | 37.75599461 | -85.17407732 | 2022-08-16 04:20:58 | Washington, Kentucky, US | |
2011853 | 2011853 | 2022-08-04 | US | Texas | Llano | 48299 | 4448 | 97 | 0 | 30.70645047 | -98.68475262 | 2022-08-05 04:20:52 | Llano, Texas, US | |
1069411 | 1069411 | 2022-07-28 | US | Wisconsin | Burnett | 55013 | 4448 | 46 | 0 | 45.86303537 | -92.36711412 | 2022-07-29 04:20:45 | Burnett, Wisconsin, US | |
2493521 | 2493521 | 2022-06-29 | US | West Virginia | Morgan | 54065 | 4448 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-06-30 04:21:01 | Morgan, West Virginia, US | |
1185726 | 1185726 | 2022-05-18 | US | Illinois | De Witt | 17039 | 4448 | 38 | 0 | 40.17514519 | -88.90959682 | 2022-05-19 04:20:54 | De Witt, Illinois, US | |
3584257 | 3584257 | 2022-05-17 | US | Michigan | Antrim | 26009 | 4448 | 66 | 0 | 44.99690221 | -85.15503082 | 2022-05-18 04:20:50 | Antrim, Michigan, US | |
1505214 | 1505214 | 2022-05-16 | US | Michigan | Antrim | 26009 | 4448 | 66 | 0 | 44.99690221 | -85.15503082 | 2022-05-17 04:20:59 | Antrim, Michigan, US | |
2085573 | 2085573 | 2022-05-15 | US | Michigan | Antrim | 26009 | 4448 | 66 | 0 | 44.99690221 | -85.15503082 | 2022-05-16 04:20:47 | Antrim, Michigan, US | |
3356283 | 3356283 | 2022-05-14 | US | Michigan | Antrim | 26009 | 4448 | 66 | 0 | 44.99690221 | -85.15503082 | 2022-05-15 04:20:53 | Antrim, Michigan, US | |
659928 | 659928 | 2022-05-13 | US | Michigan | Antrim | 26009 | 4448 | 66 | 0 | 44.99690221 | -85.15503082 | 2022-05-14 04:20:48 | Antrim, Michigan, US | |
2535011 | 2535011 | 2022-05-12 | US | Michigan | Antrim | 26009 | 4448 | 66 | 0 | 44.99690221 | -85.15503082 | 2022-05-13 04:20:51 | Antrim, Michigan, US | |
3446457 | 3446457 | 2022-05-11 | US | Michigan | Antrim | 26009 | 4448 | 66 | 0 | 44.99690221 | -85.15503082 | 2022-05-12 04:20:54 | Antrim, Michigan, US | |
225305 | 225305 | 2022-05-09 | US | Virginia | Bristol | 51520 | 4448 | 80 | 0 | 36.6163024 | -82.16359122 | 2022-05-10 04:20:50 | Bristol, Virginia, US | |
2478817 | 2478817 | 2022-03-30 | US | Georgia | Meriwether | 13199 | 4448 | 140 | 0 | 33.04163534 | -84.68859732 | 2022-03-31 04:20:56 | Meriwether, Georgia, US | |
158858 | 158858 | 2022-03-29 | US | Georgia | Meriwether | 13199 | 4448 | 140 | 0 | 33.04163534 | -84.68859732 | 2022-03-30 04:20:45 | Meriwether, Georgia, US | |
1437429 | 1437429 | 2022-03-28 | US | Georgia | Meriwether | 13199 | 4448 | 140 | 0 | 33.04163534 | -84.68859732 | 2022-03-29 04:20:46 | Meriwether, Georgia, US | |
877110 | 877110 | 2022-03-27 | US | Georgia | Meriwether | 13199 | 4448 | 140 | 0 | 33.04163534 | -84.68859732 | 2022-03-28 04:20:33 | Meriwether, Georgia, US | |
2164393 | 2164393 | 2022-03-26 | US | Georgia | Meriwether | 13199 | 4448 | 140 | 0 | 33.04163534 | -84.68859732 | 2022-03-27 04:20:47 | Meriwether, Georgia, US | |
1721329 | 1721329 | 2022-03-25 | US | Georgia | Meriwether | 13199 | 4448 | 140 | 0 | 33.04163534 | -84.68859732 | 2022-03-26 04:20:23 | Meriwether, Georgia, US | |
1468946 | 1468946 | 2022-03-24 | US | Georgia | Meriwether | 13199 | 4448 | 140 | 0 | 33.04163534 | -84.68859732 | 2022-03-25 04:20:46 | Meriwether, Georgia, US | |
3023120 | 3023120 | 2022-03-23 | US | Georgia | Meriwether | 13199 | 4448 | 140 | 0 | 33.04163534 | -84.68859732 | 2022-03-24 04:20:43 | Meriwether, Georgia, US | |
1906042 | 1906042 | 2022-03-22 | US | Georgia | Meriwether | 13199 | 4448 | 140 | 0 | 33.04163534 | -84.68859732 | 2022-03-23 04:20:48 | Meriwether, Georgia, US | |
25246 | 25246 | 2022-03-20 | US | Georgia | Meriwether | 13199 | 4448 | 140 | 0 | 33.04163534 | -84.68859732 | 2022-03-21 04:20:50 | Meriwether, Georgia, US | |
1657256 | 1657256 | 2022-03-19 | US | Georgia | Meriwether | 13199 | 4448 | 140 | 0 | 33.04163534 | -84.68859732 | 2022-03-20 04:20:45 | Meriwether, Georgia, US | |
336782 | 336782 | 2022-03-18 | US | Georgia | Meriwether | 13199 | 4448 | 140 | 0 | 33.04163534 | -84.68859732 | 2022-03-19 04:20:47 | Meriwether, Georgia, US | |
920549 | 920549 | 2022-03-08 | US | Georgia | Putnam | 13237 | 4448 | 101 | 0 | 33.32056115 | -83.37552891 | 2022-03-09 04:20:59 | Putnam, Georgia, US | |
577970 | 577970 | 2022-02-25 | US | Texas | Jones | 48253 | 4448 | 89 | 0 | 32.73997145 | -99.87861576 | 2022-02-26 04:21:12 | Jones, Texas, US | |
1300664 | 1300664 | 2022-02-17 | US | Oregon | Clatsop | 41007 | 4448 | 38 | 0 | 45.99712889 | -123.660711 | 2022-02-18 04:21:04 | Clatsop, Oregon, US | |
1299495 | 1299495 | 2022-02-17 | US | Kentucky | Mason | 21161 | 4448 | 93 | 0 | 38.59471935 | -83.82151043 | 2022-02-18 04:21:04 | Mason, Kentucky, US | |
2327740 | 2327740 | 2022-02-04 | US | Alabama | Hale | 1065 | 4448 | 95 | 0 | 32.76039258 | -87.63284988 | 2022-02-05 04:21:05 | Hale, Alabama, US | |
1779993 | 1779993 | 2022-01-27 | US | Colorado | Chaffee | 8015 | 4448 | 42 | 0 | 38.74745778 | -106.19265729999998 | 2022-01-28 04:21:09 | Chaffee, Colorado, US | |
1963593 | 1963593 | 2022-01-20 | US | Texas | Burleson | 48051 | 4448 | 62 | 0 | 30.49273808 | -96.62158484 | 2022-01-21 04:21:09 | Burleson, Texas, US | |
1960957 | 1960957 | 2022-01-20 | US | Alabama | Randolph | 1111 | 4448 | 69 | 0 | 33.29526734 | -85.45708831 | 2022-01-21 04:21:09 | Randolph, Alabama, US | |
3691100 | 3691100 | 2022-01-13 | US | Wyoming | Uinta | 56041 | 4448 | 34 | 0 | 41.2878183 | -110.54757820000002 | 2022-01-14 04:21:54 | Uinta, Wyoming, US | |
2612848 | 2612848 | 2022-01-06 | US | South Carolina | Abbeville | 45001 | 4448 | 56 | 0 | 34.22333378 | -82.46170658 | 2022-01-07 04:22:09 | Abbeville, South Carolina, US | |
1700992 | 1700992 | 2022-01-03 | US | Colorado | Morgan | 8087 | 4448 | 129 | 0 | 40.26279810000001 | -103.8093302 | 2022-01-04 04:22:17 | Morgan, Colorado, US | |
1434034 | 1434034 | 2021-12-28 | US | Kentucky | Rowan | 21205 | 4448 | 46 | 0 | 38.19484205 | -83.42088935 | 2021-12-29 03:21:43 | Rowan, Kentucky, US | |
1255708 | 1255708 | 2021-12-20 | US | Idaho | Elmore | 16039 | 4448 | 52 | 0 | 43.3507101 | -115.4701578 | 2021-12-21 03:21:27 | Elmore, Idaho, US | |
1743141 | 1743141 | 2021-12-05 | US | Oklahoma | Unassigned | 90040 | 4448 | 1120 | 0 | 36.83532655 | 0.0 | 2021-12-06 04:22:34 | Unassigned, Oklahoma, US | |
140573 | 140573 | 2021-12-04 | US | Oklahoma | Unassigned | 90040 | 4448 | 1120 | 0 | 36.83532655 | 0.0 | 2021-12-05 04:22:25 | Unassigned, Oklahoma, US | |
2198226 | 2198226 | 2021-12-03 | US | Oklahoma | Unassigned | 90040 | 4448 | 1120 | 0 | 36.83532655 | 0.0 | 2021-12-04 04:22:18 | Unassigned, Oklahoma, US | |
3404960 | 3404960 | 2021-11-30 | US | West Virginia | Upshur | 54097 | 4448 | 69 | 0 | 38.89285061 | -80.23689136 | 2021-12-01 04:22:29 | Upshur, West Virginia, US | |
3345922 | 3345922 | 2021-11-16 | US | Virginia | Amherst | 51009 | 4448 | 60 | 0 | 37.60308293 | -79.14548696 | 2021-11-17 04:21:48 | Amherst, Virginia, US | |
89630 | 89630 | 2021-11-09 | US | Ohio | Pike | 39131 | 4448 | 77 | 0 | 39.07634001 | -83.06769584 | 2021-11-10 04:21:38 | Pike, Ohio, US | |
3642371 | 3642371 | 2021-11-08 | US | South Carolina | Edgefield | 45037 | 4448 | 57 | 0 | 33.77221995 | -81.96231108 | 2021-11-09 04:21:36 | Edgefield, South Carolina, US | |
45451 | 45451 | 2021-11-02 | US | Minnesota | Mille Lacs | 27095 | 4448 | 67 | 0 | 45.93705297 | -93.63236823 | 2021-11-03 06:22:09 | Mille Lacs, Minnesota, US | |
569339 | 569339 | 2021-10-29 | US | New York | Franklin | 36033 | 4448 | 22 | 0 | 44.59040891 | -74.29926032 | 2021-10-30 04:22:03 | Franklin, New York, US | |
5796 | 5796 | 2021-10-28 | US | Kentucky | Montgomery | 21173 | 4448 | 55 | 0 | 38.03253032 | -83.9145241 | 2021-10-29 04:22:03 | Montgomery, Kentucky, US | |
5480 | 5480 | 2021-10-28 | US | Indiana | Scott | 18143 | 4448 | 76 | 0 | 38.68672078 | -85.74627859 | 2021-10-29 04:22:03 | Scott, Indiana, US | |
536974 | 536974 | 2021-10-27 | US | New York | Greene | 36039 | 4448 | 87 | 0 | 42.275797 | -74.12384884 | 2021-10-28 04:22:08 | Greene, New York, US | |
3795760 | 3795760 | 2021-10-25 | US | Mississippi | Yazoo | 28163 | 4448 | 87 | 0 | 32.77890365 | -90.39656148 | 2021-10-26 04:22:09 | Yazoo, Mississippi, US | |
3795741 | 3795741 | 2021-10-25 | US | Mississippi | Simpson | 28127 | 4448 | 116 | 0 | 31.91282117 | -89.91716179 | 2021-10-26 04:22:09 | Simpson, Mississippi, US | |
2126634 | 2126634 | 2021-10-21 | US | South Dakota | Meade | 46093 | 4448 | 46 | 0 | 44.56676791 | -102.71627409999999 | 2021-10-22 04:21:14 | Meade, South Dakota, US | |
2043981 | 2043981 | 2021-10-18 | Netherlands | Sint Maarten | 4448 | 73 | 0 | 18.0425 | -63.0548 | 2021-10-19 04:20:54 | Sint Maarten, Netherlands | |||
636181 | 636181 | 2021-10-13 | US | New York | Otsego | 36077 | 4448 | 52 | 0 | 42.63492579 | -75.03151402 | 2021-10-14 04:21:29 | Otsego, New York, US | |
2961601 | 2961601 | 2021-10-08 | US | New York | Chenango | 36017 | 4448 | 86 | 0 | 42.49430041 | -75.60887553 | 2021-10-09 04:21:34 | Chenango, New York, US | |
3012397 | 3012397 | 2021-09-22 | US | Indiana | Adams | 18001 | 4448 | 68 | 0 | 40.7457653 | -84.93671406 | 2021-09-23 04:21:43 | Adams, Indiana, 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]);