johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
176 rows where confirmed = 4782 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
351603 | 351603 | 2022-12-14 | US | Virginia | Appomattox | 51011 | 4782 | 59 | 0 | 37.37569884 | -78.81340003 | 2022-12-15 04:20:58 | Appomattox, Virginia, US | |
3715364 | 3715364 | 2022-12-06 | US | Iowa | Fayette | 19065 | 4782 | 84 | 0 | 42.86271799 | -91.8441231 | 2022-12-07 04:20:58 | Fayette, Iowa, US | |
2416069 | 2416069 | 2022-12-05 | US | Iowa | Fayette | 19065 | 4782 | 84 | 0 | 42.86271799 | -91.8441231 | 2022-12-06 04:21:03 | Fayette, Iowa, US | |
719677 | 719677 | 2022-12-04 | US | Iowa | Fayette | 19065 | 4782 | 84 | 0 | 42.86271799 | -91.8441231 | 2022-12-05 04:20:58 | Fayette, Iowa, US | |
2817966 | 2817966 | 2022-12-03 | US | Iowa | Fayette | 19065 | 4782 | 84 | 0 | 42.86271799 | -91.8441231 | 2022-12-04 04:20:56 | Fayette, Iowa, US | |
834822 | 834822 | 2022-12-02 | US | Iowa | Fayette | 19065 | 4782 | 84 | 0 | 42.86271799 | -91.8441231 | 2022-12-03 04:21:02 | Fayette, Iowa, US | |
2137352 | 2137352 | 2022-12-01 | US | Iowa | Fayette | 19065 | 4782 | 84 | 0 | 42.86271799 | -91.8441231 | 2022-12-02 04:21:07 | Fayette, Iowa, US | |
1965768 | 1965768 | 2022-11-30 | US | Iowa | Fayette | 19065 | 4782 | 84 | 0 | 42.86271799 | -91.8441231 | 2022-12-01 04:21:03 | Fayette, Iowa, US | |
3312709 | 3312709 | 2022-11-23 | US | Arkansas | Clay | 5021 | 4782 | 100 | 0 | 36.36826212 | -90.4148172 | 2022-11-24 04:21:09 | Clay, Arkansas, US | |
1623626 | 1623626 | 2022-11-22 | US | Virginia | Greene | 51079 | 4782 | 63 | 0 | 38.29545894 | -78.46525378 | 2022-11-23 04:21:06 | Greene, Virginia, US | |
3463744 | 3463744 | 2022-11-21 | US | Wisconsin | Richland | 55103 | 4782 | 53 | 0 | 43.3762778 | -90.43012729 | 2022-11-22 04:20:47 | Richland, Wisconsin, US | |
3463514 | 3463514 | 2022-11-21 | US | Virginia | Greene | 51079 | 4782 | 63 | 0 | 38.29545894 | -78.46525378 | 2022-11-22 04:20:47 | Greene, Virginia, US | |
711654 | 711654 | 2022-11-01 | US | Iowa | Hardin | 19083 | 4782 | 66 | 0 | 42.38353877 | -93.23654611 | 2022-11-02 04:22:09 | Hardin, Iowa, US | |
3286103 | 3286103 | 2022-10-31 | US | Iowa | Hardin | 19083 | 4782 | 66 | 0 | 42.38353877 | -93.23654611 | 2022-11-01 04:22:36 | Hardin, Iowa, US | |
321136 | 321136 | 2022-10-30 | US | Iowa | Hardin | 19083 | 4782 | 66 | 0 | 42.38353877 | -93.23654611 | 2022-10-31 04:21:36 | Hardin, Iowa, US | |
913412 | 913412 | 2022-10-29 | US | Iowa | Hardin | 19083 | 4782 | 66 | 0 | 42.38353877 | -93.23654611 | 2022-10-30 04:22:14 | Hardin, Iowa, US | |
1367681 | 1367681 | 2022-10-28 | US | Iowa | Hardin | 19083 | 4782 | 66 | 0 | 42.38353877 | -93.23654611 | 2022-10-29 04:21:13 | Hardin, Iowa, US | |
3039536 | 3039536 | 2022-10-27 | US | Iowa | Hardin | 19083 | 4782 | 66 | 0 | 42.38353877 | -93.23654611 | 2022-10-28 04:22:31 | Hardin, Iowa, US | |
539956 | 539956 | 2022-10-26 | US | Iowa | Hardin | 19083 | 4782 | 66 | 0 | 42.38353877 | -93.23654611 | 2022-10-27 04:22:01 | Hardin, Iowa, US | |
2760397 | 2760397 | 2022-10-18 | US | West Virginia | Braxton | 54007 | 4782 | 48 | 0 | 38.70036159 | -80.72011184 | 2022-10-19 04:22:26 | Braxton, West Virginia, US | |
420308 | 420308 | 2022-09-18 | US | Illinois | Carroll | 17015 | 4782 | 51 | 0 | 42.06823429 | -89.93395545 | 2022-09-19 04:21:49 | Carroll, Illinois, US | |
3374332 | 3374332 | 2022-09-17 | US | Illinois | Carroll | 17015 | 4782 | 51 | 0 | 42.06823429 | -89.93395545 | 2022-09-18 04:22:50 | Carroll, Illinois, US | |
2356440 | 2356440 | 2022-09-16 | US | Illinois | Carroll | 17015 | 4782 | 51 | 0 | 42.06823429 | -89.93395545 | 2022-09-17 04:20:19 | Carroll, Illinois, US | |
3989349 | 3989349 | 2022-09-15 | US | Puerto Rico | Arroyo | 72015 | 4782 | 0 | 0 | 17.998457 | -66.056546 | 2022-09-16 04:21:19 | Arroyo, Puerto Rico, US | |
1609815 | 1609815 | 2022-07-20 | US | Louisiana | Winn | 22127 | 4782 | 64 | 0 | 31.94449367 | -92.63789413 | 2022-07-21 04:21:10 | Winn, Louisiana, US | |
3406002 | 3406002 | 2022-07-17 | US | California | Colusa | 6011 | 4782 | 22 | 0 | 39.17881957 | -122.2331726 | 2022-07-18 04:20:59 | Colusa, California, US | |
1202726 | 1202726 | 2022-07-06 | US | Tennessee | Bledsoe | 47007 | 4782 | 61 | 0 | 35.59942968 | -85.20611967 | 2022-07-07 04:20:55 | Bledsoe, Tennessee, US | |
3081665 | 3081665 | 2022-07-04 | US | Wyoming | Carbon | 56007 | 4782 | 52 | 0 | 41.69357844 | -106.9326084 | 2022-07-05 04:20:45 | Carbon, Wyoming, US | |
1770947 | 1770947 | 2022-07-03 | US | Wyoming | Carbon | 56007 | 4782 | 52 | 0 | 41.69357844 | -106.9326084 | 2022-07-04 04:20:54 | Carbon, Wyoming, US | |
3368933 | 3368933 | 2022-07-02 | US | Wyoming | Carbon | 56007 | 4782 | 52 | 0 | 41.69357844 | -106.9326084 | 2022-07-03 04:20:59 | Carbon, Wyoming, US | |
597262 | 597262 | 2022-07-01 | US | Wyoming | Carbon | 56007 | 4782 | 52 | 0 | 41.69357844 | -106.9326084 | 2022-07-02 04:21:16 | Carbon, Wyoming, US | |
3943663 | 3943663 | 2022-06-30 | US | Wyoming | Carbon | 56007 | 4782 | 52 | 0 | 41.69357844 | -106.9326084 | 2022-07-01 04:21:10 | Carbon, Wyoming, US | |
2493621 | 2493621 | 2022-06-29 | US | Wyoming | Carbon | 56007 | 4782 | 52 | 0 | 41.69357844 | -106.9326084 | 2022-06-30 04:21:01 | Carbon, Wyoming, US | |
2490396 | 2490396 | 2022-06-29 | US | Alabama | Henry | 1067 | 4782 | 77 | 0 | 31.51148016 | -85.24267944 | 2022-06-30 04:21:01 | Henry, Alabama, US | |
2243003 | 2243003 | 2022-06-28 | US | Wyoming | Carbon | 56007 | 4782 | 52 | 0 | 41.69357844 | -106.9326084 | 2022-06-29 04:20:59 | Carbon, Wyoming, US | |
2238484 | 2238484 | 2022-06-12 | US | Texas | Gonzales | 48177 | 4782 | 99 | 0 | 29.45634206 | -97.49424032 | 2022-06-13 04:21:14 | Gonzales, Texas, US | |
1422828 | 1422828 | 2022-06-08 | US | Minnesota | Houston | 27055 | 4782 | 20 | 0 | 43.67129565 | -91.49143057 | 2022-06-09 04:20:54 | Houston, Minnesota, US | |
3530451 | 3530451 | 2022-06-04 | US | Tennessee | Polk | 47139 | 4782 | 76 | 0 | 35.12245443 | -84.52075859 | 2022-06-05 04:20:55 | Polk, Tennessee, US | |
3899342 | 3899342 | 2022-05-19 | US | Virginia | New Kent | 51127 | 4782 | 32 | 0 | 37.50694406 | -76.99828634 | 2022-05-20 04:20:57 | New Kent, Virginia, US | |
2085423 | 2085423 | 2022-05-15 | US | Kentucky | Powell | 21197 | 4782 | 44 | 0 | 37.83218794 | -83.82553961 | 2022-05-16 04:20:47 | Powell, Kentucky, US | |
3356133 | 3356133 | 2022-05-14 | US | Kentucky | Powell | 21197 | 4782 | 44 | 0 | 37.83218794 | -83.82553961 | 2022-05-15 04:20:53 | Powell, Kentucky, US | |
659778 | 659778 | 2022-05-13 | US | Kentucky | Powell | 21197 | 4782 | 44 | 0 | 37.83218794 | -83.82553961 | 2022-05-14 04:20:48 | Powell, Kentucky, US | |
2534861 | 2534861 | 2022-05-12 | US | Kentucky | Powell | 21197 | 4782 | 44 | 0 | 37.83218794 | -83.82553961 | 2022-05-13 04:20:51 | Powell, Kentucky, US | |
2533548 | 2533548 | 2022-05-12 | Palau | 4782 | 6 | 0 | 7.515 | 134.5825 | 2022-05-13 04:20:51 | Palau | ||||
3447390 | 3447390 | 2022-05-11 | US | Oklahoma | Craig | 40035 | 4782 | 55 | 0 | 36.76268118 | -95.20916602 | 2022-05-12 04:20:54 | Craig, Oklahoma, US | |
3446307 | 3446307 | 2022-05-11 | US | Kentucky | Powell | 21197 | 4782 | 44 | 0 | 37.83218794 | -83.82553961 | 2022-05-12 04:20:54 | Powell, Kentucky, US | |
3444994 | 3444994 | 2022-05-11 | Palau | 4782 | 6 | 0 | 7.515 | 134.5825 | 2022-05-12 04:20:54 | Palau | ||||
3538007 | 3538007 | 2022-05-10 | US | Oklahoma | Craig | 40035 | 4782 | 55 | 0 | 36.76268118 | -95.20916602 | 2022-05-11 04:20:48 | Craig, Oklahoma, US | |
3536924 | 3536924 | 2022-05-10 | US | Kentucky | Powell | 21197 | 4782 | 44 | 0 | 37.83218794 | -83.82553961 | 2022-05-11 04:20:48 | Powell, Kentucky, US | |
3535611 | 3535611 | 2022-05-10 | Palau | 4782 | 6 | 0 | 7.515 | 134.5825 | 2022-05-11 04:20:48 | Palau | ||||
224542 | 224542 | 2022-05-09 | US | Oklahoma | Craig | 40035 | 4782 | 55 | 0 | 36.76268118 | -95.20916602 | 2022-05-10 04:20:50 | Craig, Oklahoma, US | |
223459 | 223459 | 2022-05-09 | US | Kentucky | Powell | 21197 | 4782 | 44 | 0 | 37.83218794 | -83.82553961 | 2022-05-10 04:20:50 | Powell, Kentucky, US | |
2333927 | 2333927 | 2022-05-08 | US | Oklahoma | Craig | 40035 | 4782 | 55 | 0 | 36.76268118 | -95.20916602 | 2022-05-09 04:20:54 | Craig, Oklahoma, US | |
362889 | 362889 | 2022-05-07 | US | Oklahoma | Craig | 40035 | 4782 | 55 | 0 | 36.76268118 | -95.20916602 | 2022-05-08 04:20:49 | Craig, Oklahoma, US | |
1400240 | 1400240 | 2022-05-06 | US | Oklahoma | Craig | 40035 | 4782 | 55 | 0 | 36.76268118 | -95.20916602 | 2022-05-07 04:21:09 | Craig, Oklahoma, US | |
2600595 | 2600595 | 2022-05-05 | US | Oklahoma | Craig | 40035 | 4782 | 55 | 0 | 36.76268118 | -95.20916602 | 2022-05-06 04:21:00 | Craig, Oklahoma, US | |
2600059 | 2600059 | 2022-05-05 | US | Montana | Lincoln | 30053 | 4782 | 89 | 0 | 48.54265777 | -115.4046155 | 2022-05-06 04:21:00 | Lincoln, Montana, US | |
3724968 | 3724968 | 2022-04-25 | US | Puerto Rico | Naranjito | 72105 | 4782 | 0 | 0 | 18.288019 | -66.252703 | 2022-04-26 04:20:51 | Naranjito, Puerto Rico, US | |
2254152 | 2254152 | 2022-04-19 | US | Puerto Rico | Camuy | 72027 | 4782 | 0 | 0 | 18.418578 | -66.860206 | 2022-04-20 04:20:45 | Camuy, Puerto Rico, US | |
1848702 | 1848702 | 2022-04-18 | US | Puerto Rico | Camuy | 72027 | 4782 | 0 | 0 | 18.418578 | -66.860206 | 2022-04-19 04:21:00 | Camuy, Puerto Rico, US | |
3730840 | 3730840 | 2022-04-03 | US | Colorado | Chaffee | 8015 | 4782 | 47 | 0 | 38.74745778 | -106.19265729999998 | 2022-04-04 04:20:51 | Chaffee, Colorado, US | |
500275 | 500275 | 2022-04-02 | US | Colorado | Chaffee | 8015 | 4782 | 47 | 0 | 38.74745778 | -106.19265729999998 | 2022-04-03 04:20:48 | Chaffee, Colorado, US | |
3351260 | 3351260 | 2022-04-01 | US | Colorado | Chaffee | 8015 | 4782 | 47 | 0 | 38.74745778 | -106.19265729999998 | 2022-04-02 04:20:47 | Chaffee, Colorado, US | |
879735 | 879735 | 2022-03-27 | US | West Virginia | Barbour | 54001 | 4782 | 76 | 0 | 39.1307219 | -80.00350858 | 2022-03-28 04:20:33 | Barbour, West Virginia, US | |
2167018 | 2167018 | 2022-03-26 | US | West Virginia | Barbour | 54001 | 4782 | 76 | 0 | 39.1307219 | -80.00350858 | 2022-03-27 04:20:47 | Barbour, West Virginia, US | |
1723954 | 1723954 | 2022-03-25 | US | West Virginia | Barbour | 54001 | 4782 | 76 | 0 | 39.1307219 | -80.00350858 | 2022-03-26 04:20:23 | Barbour, West Virginia, US | |
1471571 | 1471571 | 2022-03-24 | US | West Virginia | Barbour | 54001 | 4782 | 75 | 0 | 39.1307219 | -80.00350858 | 2022-03-25 04:20:46 | Barbour, West Virginia, US | |
944819 | 944819 | 2022-02-28 | US | Montana | Big Horn | 30003 | 4782 | 92 | 0 | 45.42335905 | -107.492347 | 2022-03-01 04:21:09 | Big Horn, Montana, US | |
3075135 | 3075135 | 2022-02-09 | US | Indiana | Fulton | 18049 | 4782 | 98 | 0 | 41.0469907 | -86.26252745 | 2022-02-10 04:21:14 | Fulton, Indiana, US | |
1364620 | 1364620 | 2022-02-08 | US | New York | Schoharie | 36095 | 4782 | 34 | 0 | 42.58831742 | -74.44339029999998 | 2022-02-09 04:21:04 | Schoharie, New York, US | |
1363442 | 1363442 | 2022-02-08 | US | Indiana | Fulton | 18049 | 4782 | 98 | 0 | 41.0469907 | -86.26252745 | 2022-02-09 04:21:04 | Fulton, Indiana, US | |
2474456 | 2474456 | 2022-02-03 | US | Arkansas | Lincoln | 5079 | 4782 | 60 | 0 | 33.95317155 | -91.74002806 | 2022-02-04 04:21:10 | Lincoln, Arkansas, US | |
1142420 | 1142420 | 2022-01-23 | US | Louisiana | Grant | 22043 | 4782 | 81 | 0 | 31.59882456 | -92.56124347 | 2022-01-24 04:21:12 | Grant, Louisiana, US | |
2834338 | 2834338 | 2022-01-22 | US | Louisiana | Grant | 22043 | 4782 | 81 | 0 | 31.59882456 | -92.56124347 | 2022-01-23 04:21:13 | Grant, Louisiana, US | |
3427708 | 3427708 | 2022-01-21 | US | Puerto Rico | Manati | 72091 | 4782 | 0 | 0 | 18.420473 | -66.490461 | 2022-01-22 04:21:13 | Manati, Puerto Rico, US | |
3426456 | 3426456 | 2022-01-21 | US | Louisiana | Grant | 22043 | 4782 | 81 | 0 | 31.59882456 | -92.56124347 | 2022-01-22 04:21:13 | Grant, Louisiana, US | |
3688121 | 3688121 | 2022-01-13 | US | Colorado | Montezuma | 8083 | 4782 | 64 | 0 | 37.33859579 | -108.59588570000001 | 2022-01-14 04:21:54 | Montezuma, Colorado, US | |
2611790 | 2611790 | 2022-01-06 | US | Minnesota | Meeker | 27093 | 4782 | 68 | 0 | 45.12328869 | -94.52839455 | 2022-01-07 04:22:09 | Meeker, Minnesota, US | |
2114805 | 2114805 | 2021-12-26 | US | Texas | Hale | 48189 | 4782 | 203 | 0 | 34.07044901 | -101.82681140000001 | 2021-12-27 04:21:58 | Hale, Texas, US | |
1718256 | 1718256 | 2021-12-16 | US | Missouri | Dunklin | 29069 | 4782 | 93 | 0 | 36.27167174 | -90.09122243 | 2021-12-17 04:22:14 | Dunklin, Missouri, US | |
551088 | 551088 | 2021-12-08 | Sweden | Gotland | 4782 | 54 | 0 | 57.4684 | 18.4867 | 2021-12-09 04:22:49 | Gotland, Sweden | |||
1146774 | 1146774 | 2021-12-01 | US | Mississippi | Scott | 28123 | 4782 | 99 | 0 | 32.406704100000006 | -89.53789439 | 2021-12-02 04:22:37 | Scott, Mississippi, US | |
3073002 | 3073002 | 2021-11-23 | US | Tennessee | McNairy | 47109 | 4782 | 72 | 0 | 35.17468549 | -88.5647812 | 2021-11-24 04:22:14 | McNairy, Tennessee, US | |
3070836 | 3070836 | 2021-11-23 | US | Georgia | Gilmer | 13123 | 4782 | 137 | 0 | 34.69316688 | -84.45802506 | 2021-11-24 04:22:14 | Gilmer, Georgia, US | |
3290621 | 3290621 | 2021-11-18 | US | Minnesota | Cass | 27021 | 4782 | 50 | 0 | 46.95043611 | -94.32603968 | 2021-11-19 04:21:40 | Cass, Minnesota, US | |
3345465 | 3345465 | 2021-11-16 | US | South Carolina | Union | 45087 | 4782 | 105 | 0 | 34.68835752 | -81.61730349 | 2021-11-17 04:21:48 | Union, South Carolina, US | |
277057 | 277057 | 2021-11-03 | US | Georgia | Stephens | 13257 | 4782 | 109 | 0 | 34.55151201 | -83.29405315 | 2021-11-04 04:22:20 | Stephens, Georgia, US | |
44064 | 44064 | 2021-11-02 | US | Alabama | Clarke | 1025 | 4782 | 84 | 0 | 31.68099859 | -87.83548597 | 2021-11-03 06:22:09 | Clarke, Alabama, US | |
6573 | 6573 | 2021-10-28 | US | New York | Chenango | 36017 | 4782 | 88 | 0 | 42.49430041 | -75.60887553 | 2021-10-29 04:22:03 | Chenango, New York, US | |
598202 | 598202 | 2021-10-19 | US | Arkansas | St. Francis | 5123 | 4782 | 66 | 0 | 35.02201976 | -90.74828138 | 2021-10-20 04:21:00 | St. Francis, Arkansas, US | |
637371 | 637371 | 2021-10-13 | US | Washington | Kittitas | 53037 | 4782 | 52 | 0 | 47.12521214 | -120.67943899999999 | 2021-10-14 04:21:29 | Kittitas, Washington, US | |
2462047 | 2462047 | 2021-10-06 | US | Texas | Willacy | 48489 | 4782 | 105 | 0 | 26.47411727 | -97.61535848 | 2021-10-07 04:21:36 | Willacy, Texas, US | |
3835995 | 3835995 | 2021-10-05 | US | West Virginia | Randolph | 54083 | 4782 | 37 | 0 | 38.769899 | -79.87919615 | 2021-10-06 04:21:33 | Randolph, West Virginia, US | |
2077689 | 2077689 | 2021-09-26 | US | Minnesota | Morrison | 27097 | 4782 | 63 | 0 | 46.01265363 | -94.27341528 | 2021-09-27 04:21:16 | Morrison, Minnesota, US | |
1726241 | 1726241 | 2021-09-25 | US | Minnesota | Morrison | 27097 | 4782 | 63 | 0 | 46.01265363 | -94.27341528 | 2021-09-26 04:21:29 | Morrison, Minnesota, US | |
1725909 | 1725909 | 2021-09-25 | US | Kentucky | Harlan | 21095 | 4782 | 111 | 0 | 36.85699301 | -83.21899516 | 2021-09-26 04:21:29 | Harlan, Kentucky, US | |
1922961 | 1922961 | 2021-09-24 | US | Minnesota | Morrison | 27097 | 4782 | 63 | 0 | 46.01265363 | -94.27341528 | 2021-09-25 04:21:31 | Morrison, Minnesota, US | |
2465494 | 2465494 | 2021-09-14 | US | Pennsylvania | Venango | 42121 | 4782 | 109 | 0 | 41.40323442 | -79.75845449 | 2021-09-15 03:22:37 | Venango, Pennsylvania, US | |
3196214 | 3196214 | 2021-09-06 | US | New Mexico | Unassigned | 90035 | 4782 | 0 | 0 | 36.60569702 | -108.7151824 | 2021-09-07 04:21:35 | Unassigned, New Mexico, US | |
3283082 | 3283082 | 2021-09-05 | US | New Mexico | Unassigned | 90035 | 4782 | 0 | 0 | 36.60569702 | -108.7151824 | 2021-09-06 04:21:22 | Unassigned, New Mexico, 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]);