johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
151 rows where confirmed = 4929 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
221382 | 221382 | 2022-12-26 | US | Virginia | Radford | 51750 | 4929 | 49 | 0 | 37.12222899 | -80.5602732 | 2022-12-27 04:21:07 | Radford, Virginia, US | |
2952572 | 2952572 | 2022-12-20 | US | Iowa | Crawford | 19047 | 4929 | 56 | 0 | 42.03718237 | -95.3819718 | 2022-12-21 04:21:03 | Crawford, Iowa, US | |
3174974 | 3174974 | 2022-12-19 | US | Iowa | Crawford | 19047 | 4929 | 56 | 0 | 42.03718237 | -95.3819718 | 2022-12-20 04:21:04 | Crawford, Iowa, US | |
1629491 | 1629491 | 2022-12-18 | US | Iowa | Crawford | 19047 | 4929 | 56 | 0 | 42.03718237 | -95.3819718 | 2022-12-19 04:21:03 | Crawford, Iowa, US | |
504870 | 504870 | 2022-12-17 | US | Iowa | Crawford | 19047 | 4929 | 56 | 0 | 42.03718237 | -95.3819718 | 2022-12-18 04:21:03 | Crawford, Iowa, US | |
3325442 | 3325442 | 2022-12-16 | US | Iowa | Crawford | 19047 | 4929 | 56 | 0 | 42.03718237 | -95.3819718 | 2022-12-17 04:21:04 | Crawford, Iowa, US | |
543954 | 543954 | 2022-12-15 | US | Iowa | Crawford | 19047 | 4929 | 56 | 0 | 42.03718237 | -95.3819718 | 2022-12-16 04:21:01 | Crawford, Iowa, US | |
349482 | 349482 | 2022-12-14 | US | Iowa | Crawford | 19047 | 4929 | 56 | 0 | 42.03718237 | -95.3819718 | 2022-12-15 04:20:58 | Crawford, Iowa, US | |
836623 | 836623 | 2022-12-02 | US | Tennessee | Sequatchie | 47153 | 4929 | 72 | 0 | 35.36979721 | -85.41022136 | 2022-12-03 04:21:02 | Sequatchie, Tennessee, US | |
2139153 | 2139153 | 2022-12-01 | US | Tennessee | Sequatchie | 47153 | 4929 | 72 | 0 | 35.36979721 | -85.41022136 | 2022-12-02 04:21:07 | Sequatchie, Tennessee, US | |
1240669 | 1240669 | 2022-11-28 | US | Illinois | Jo Daviess | 17085 | 4929 | 45 | 0 | 42.36542373 | -90.21094405 | 2022-11-29 04:21:05 | Jo Daviess, Illinois, US | |
3551455 | 3551455 | 2022-11-27 | China | Shaanxi | 4929 | 3 | 0 | 35.1917 | 108.8701 | 2022-11-28 04:21:02 | Shaanxi, China | |||
2487769 | 2487769 | 2022-11-16 | US | Minnesota | Roseau | 27135 | 4929 | 47 | 0 | 48.77501878 | -95.81079919 | 2022-11-17 04:21:11 | Roseau, Minnesota, US | |
293780 | 293780 | 2022-11-15 | US | Minnesota | Roseau | 27135 | 4929 | 47 | 0 | 48.77501878 | -95.81079919 | 2022-11-16 04:21:09 | Roseau, Minnesota, US | |
3598810 | 3598810 | 2022-11-14 | US | Minnesota | Roseau | 27135 | 4929 | 47 | 0 | 48.77501878 | -95.81079919 | 2022-11-15 04:21:16 | Roseau, Minnesota, US | |
313668 | 313668 | 2022-11-13 | US | Minnesota | Roseau | 27135 | 4929 | 47 | 0 | 48.77501878 | -95.81079919 | 2022-11-14 04:21:09 | Roseau, Minnesota, US | |
64829 | 64829 | 2022-11-12 | US | Minnesota | Roseau | 27135 | 4929 | 47 | 0 | 48.77501878 | -95.81079919 | 2022-11-13 04:21:14 | Roseau, Minnesota, US | |
2928991 | 2928991 | 2022-11-11 | US | Minnesota | Roseau | 27135 | 4929 | 47 | 0 | 48.77501878 | -95.81079919 | 2022-11-12 04:20:41 | Roseau, Minnesota, US | |
2507827 | 2507827 | 2022-11-10 | US | Minnesota | Roseau | 27135 | 4929 | 47 | 0 | 48.77501878 | -95.81079919 | 2022-11-11 04:21:22 | Roseau, Minnesota, US | |
1595133 | 1595133 | 2022-10-21 | US | Tennessee | Cannon | 47015 | 4929 | 70 | 0 | 35.80990797 | -86.05738983 | 2022-10-22 04:22:53 | Cannon, Tennessee, US | |
2159294 | 2159294 | 2022-10-16 | Canada | Yukon | 4929 | 31 | 0 | 64.2823 | -135.0 | 2022-10-17 04:20:31 | Yukon, Canada | |||
515491 | 515491 | 2022-10-15 | Canada | Yukon | 4929 | 31 | 0 | 64.2823 | -135.0 | 2022-10-16 04:22:39 | Yukon, Canada | |||
2032548 | 2032548 | 2022-10-14 | Canada | Yukon | 4929 | 31 | 0 | 64.2823 | -135.0 | 2022-10-15 04:22:00 | Yukon, Canada | |||
3753236 | 3753236 | 2022-10-13 | Canada | Yukon | 4929 | 31 | 0 | 64.2823 | -135.0 | 2022-10-14 04:22:28 | Yukon, Canada | |||
3214061 | 3214061 | 2022-10-12 | Canada | Yukon | 4929 | 31 | 0 | 64.2823 | -135.0 | 2022-10-13 04:22:39 | Yukon, Canada | |||
2686680 | 2686680 | 2022-10-03 | US | Illinois | De Witt | 17039 | 4929 | 41 | 0 | 40.17514519 | -88.90959682 | 2022-10-04 04:22:55 | De Witt, Illinois, US | |
2017371 | 2017371 | 2022-09-20 | US | Colorado | Otero | 8089 | 4929 | 132 | 0 | 37.9014485 | -103.7173385 | 2022-09-21 04:23:22 | Otero, Colorado, US | |
115241 | 115241 | 2022-09-06 | US | Arkansas | Grant | 5053 | 4929 | 61 | 0 | 34.29017991 | -92.42320562 | 2022-09-07 04:20:59 | Grant, Arkansas, US | |
2406043 | 2406043 | 2022-08-21 | US | Texas | Robertson | 48395 | 4929 | 77 | 0 | 31.02539637 | -96.51272246 | 2022-08-22 04:20:38 | Robertson, Texas, US | |
3801121 | 3801121 | 2022-08-20 | US | Texas | Robertson | 48395 | 4929 | 77 | 0 | 31.02539637 | -96.51272246 | 2022-08-21 04:20:44 | Robertson, Texas, US | |
2366707 | 2366707 | 2022-08-19 | US | Texas | Robertson | 48395 | 4929 | 77 | 0 | 31.02539637 | -96.51272246 | 2022-08-20 04:21:01 | Robertson, Texas, US | |
2597227 | 2597227 | 2022-07-25 | US | Texas | Panola | 48365 | 4929 | 130 | 0 | 32.1639596 | -94.30552481 | 2022-07-26 04:20:58 | Panola, Texas, US | |
897275 | 897275 | 2022-07-24 | US | Indiana | Perry | 18123 | 4929 | 69 | 0 | 38.07809328 | -86.63741946 | 2022-07-25 04:20:51 | Perry, Indiana, US | |
92269 | 92269 | 2022-07-23 | US | Indiana | Perry | 18123 | 4929 | 69 | 0 | 38.07809328 | -86.63741946 | 2022-07-24 04:20:47 | Perry, Indiana, US | |
901291 | 901291 | 2022-07-22 | US | Indiana | Perry | 18123 | 4929 | 69 | 0 | 38.07809328 | -86.63741946 | 2022-07-23 04:20:53 | Perry, Indiana, US | |
3970134 | 3970134 | 2022-07-05 | US | Wisconsin | Sawyer | 55113 | 4929 | 63 | 0 | 45.87931905 | -91.14504927 | 2022-07-06 04:20:58 | Sawyer, Wisconsin, US | |
3942071 | 3942071 | 2022-06-30 | US | Montana | Lincoln | 30053 | 4929 | 90 | 0 | 48.54265777 | -115.4046155 | 2022-07-01 04:21:10 | Lincoln, Montana, US | |
2492029 | 2492029 | 2022-06-29 | US | Montana | Lincoln | 30053 | 4929 | 90 | 0 | 48.54265777 | -115.4046155 | 2022-06-30 04:21:01 | Lincoln, Montana, US | |
2241411 | 2241411 | 2022-06-28 | US | Montana | Lincoln | 30053 | 4929 | 90 | 0 | 48.54265777 | -115.4046155 | 2022-06-29 04:20:59 | Lincoln, Montana, US | |
2240503 | 2240503 | 2022-06-28 | US | Indiana | Jay | 18075 | 4929 | 78 | 0 | 40.43781032 | -85.00576229 | 2022-06-29 04:20:59 | Jay, Indiana, US | |
2149653 | 2149653 | 2022-06-27 | US | Montana | Lincoln | 30053 | 4929 | 90 | 0 | 48.54265777 | -115.4046155 | 2022-06-28 04:20:58 | Lincoln, Montana, US | |
2148745 | 2148745 | 2022-06-27 | US | Indiana | Jay | 18075 | 4929 | 78 | 0 | 40.43781032 | -85.00576229 | 2022-06-28 04:20:58 | Jay, Indiana, US | |
477454 | 477454 | 2022-06-26 | US | Montana | Lincoln | 30053 | 4929 | 90 | 0 | 48.54265777 | -115.4046155 | 2022-06-27 04:21:00 | Lincoln, Montana, US | |
940829 | 940829 | 2022-06-25 | US | Montana | Lincoln | 30053 | 4929 | 90 | 0 | 48.54265777 | -115.4046155 | 2022-06-26 04:21:02 | Lincoln, Montana, US | |
3348649 | 3348649 | 2022-06-24 | US | Montana | Lincoln | 30053 | 4929 | 90 | 0 | 48.54265777 | -115.4046155 | 2022-06-25 04:20:57 | Lincoln, Montana, US | |
971422 | 971422 | 2022-06-01 | US | Arkansas | Lincoln | 5079 | 4929 | 68 | 0 | 33.95317155 | -91.74002806 | 2022-06-02 05:20:39 | Lincoln, Arkansas, US | |
229729 | 229729 | 2022-05-31 | US | Arkansas | Lincoln | 5079 | 4929 | 68 | 0 | 33.95317155 | -91.74002806 | 2022-06-01 04:20:55 | Lincoln, Arkansas, US | |
3189579 | 3189579 | 2022-05-30 | US | Wisconsin | Taylor | 55119 | 4929 | 72 | 0 | 45.21179252 | -90.5004405 | 2022-05-31 04:20:51 | Taylor, Wisconsin, US | |
2048475 | 2048475 | 2022-05-25 | US | Colorado | Chaffee | 8015 | 4929 | 48 | 0 | 38.74745778 | -106.1926573 | 2022-05-26 04:20:50 | Chaffee, Colorado, US | |
2599138 | 2599138 | 2022-05-05 | US | Indiana | Fulton | 18049 | 4929 | 103 | 0 | 41.0469907 | -86.26252745 | 2022-05-06 04:21:00 | Fulton, Indiana, US | |
3266587 | 3266587 | 2022-05-04 | US | Indiana | Fulton | 18049 | 4929 | 103 | 0 | 41.0469907 | -86.26252745 | 2022-05-05 04:20:55 | Fulton, Indiana, US | |
2310685 | 2310685 | 2022-04-20 | US | Virginia | Radford | 51750 | 4929 | 52 | 0 | 37.12222899 | -80.56027320000003 | 2022-04-21 04:20:46 | Radford, Virginia, US | |
3207991 | 3207991 | 2022-04-11 | US | Minnesota | Hubbard | 27057 | 4929 | 59 | 0 | 47.10778564 | -94.91693868 | 2022-04-12 04:20:49 | Hubbard, Minnesota, US | |
3868302 | 3868302 | 2022-04-05 | US | Georgia | Berrien | 13019 | 4929 | 82 | 0 | 31.27590016 | -83.22529920000002 | 2022-04-06 04:20:49 | Berrien, Georgia, US | |
2749644 | 2749644 | 2022-04-04 | US | Georgia | Berrien | 13019 | 4929 | 82 | 0 | 31.27590016 | -83.22529920000002 | 2022-04-05 04:20:48 | Berrien, Georgia, US | |
3628889 | 3628889 | 2022-03-13 | US | Idaho | Cassia | 16031 | 4929 | 52 | 0 | 42.28347888 | -113.6012409 | 2022-03-14 04:20:46 | Cassia, Idaho, US | |
951797 | 951797 | 2022-03-12 | US | Idaho | Cassia | 16031 | 4929 | 52 | 0 | 42.28347888 | -113.6012409 | 2022-03-13 04:20:49 | Cassia, Idaho, US | |
357258 | 357258 | 2022-03-11 | US | Idaho | Cassia | 16031 | 4929 | 52 | 0 | 42.28347888 | -113.6012409 | 2022-03-12 04:20:50 | Cassia, Idaho, US | |
943493 | 943493 | 2022-02-28 | US | Colorado | Teller | 8119 | 4929 | 57 | 0 | 38.88133511 | -105.16148929999999 | 2022-03-01 04:21:09 | Teller, Colorado, US | |
2735804 | 2735804 | 2022-02-27 | US | Puerto Rico | San Lorenzo | 72129 | 4929 | 0 | 0 | 18.147987 | -65.976392 | 2022-02-28 04:21:05 | San Lorenzo, Puerto Rico, US | |
2734821 | 2734821 | 2022-02-27 | US | Mississippi | Clay | 28025 | 4929 | 93 | 0 | 33.65358105 | -88.77784255 | 2022-02-28 04:21:05 | Clay, Mississippi, US | |
3047974 | 3047974 | 2022-02-26 | US | Mississippi | Clay | 28025 | 4929 | 93 | 0 | 33.65358105 | -88.77784255 | 2022-02-27 04:21:04 | Clay, Mississippi, US | |
3047737 | 3047737 | 2022-02-26 | US | Maine | Lincoln | 23015 | 4929 | 29 | 0 | 44.05996956 | -69.54227124 | 2022-02-27 04:21:04 | Lincoln, Maine, US | |
576629 | 576629 | 2022-02-25 | US | Mississippi | Clay | 28025 | 4929 | 93 | 0 | 33.65358105 | -88.77784255 | 2022-02-26 04:21:12 | Clay, Mississippi, US | |
3720394 | 3720394 | 2022-02-21 | US | New Mexico | Roosevelt | 35041 | 4929 | 91 | 0 | 34.02097406 | -103.4799493 | 2022-02-22 04:21:01 | Roosevelt, New Mexico, US | |
3823657 | 3823657 | 2022-02-16 | US | Texas | Scurry | 48415 | 4929 | 100 | 0 | 32.74613808 | -100.91626640000001 | 2022-02-17 04:20:56 | Scurry, Texas, US | |
2642584 | 2642584 | 2022-02-14 | US | Georgia | Jones | 13169 | 4929 | 104 | 0 | 33.02512137 | -83.56019163 | 2022-02-15 04:21:09 | Jones, Georgia, US | |
3077005 | 3077005 | 2022-02-09 | US | Tennessee | Johnson | 47091 | 4929 | 75 | 0 | 36.45523950000001 | -81.84886538 | 2022-02-10 04:21:14 | Johnson, Tennessee, US | |
979420 | 979420 | 2022-02-01 | US | Arkansas | Clark | 5019 | 4929 | 70 | 0 | 34.04613432 | -93.17484713 | 2022-02-02 04:21:09 | Clark, Arkansas, US | |
2660887 | 2660887 | 2022-01-31 | US | Texas | Gillespie | 48171 | 4929 | 96 | 0 | 30.31824095 | -98.94676915 | 2022-02-01 04:21:11 | Gillespie, Texas, US | |
1318728 | 1318728 | 2022-01-26 | US | Arkansas | Ouachita | 5103 | 4929 | 92 | 0 | 33.58839816 | -92.87795984 | 2022-01-27 04:21:19 | Ouachita, Arkansas, US | |
2054497 | 2054497 | 2022-01-25 | US | Oregon | Crook | 41013 | 4929 | 62 | 0 | 44.14230227 | -120.356297 | 2022-01-26 04:21:07 | Crook, Oregon, US | |
3229188 | 3229188 | 2022-01-19 | US | Puerto Rico | Corozal | 72047 | 4929 | 0 | 0 | 18.304264 | -66.327738 | 2022-01-20 04:21:07 | Corozal, Puerto Rico, US | |
1692692 | 1692692 | 2022-01-10 | US | Alabama | Geneva | 1061 | 4929 | 138 | 0 | 31.09389027 | -85.83572839 | 2022-01-11 04:22:01 | Geneva, Alabama, US | |
1434412 | 1434412 | 2021-12-28 | US | Mississippi | Scott | 28123 | 4929 | 99 | 0 | 32.406704100000006 | -89.53789439 | 2021-12-29 03:21:43 | Scott, Mississippi, US | |
784623 | 784623 | 2021-12-13 | US | New York | Delaware | 36025 | 4929 | 55 | 0 | 42.19837623 | -74.96709306 | 2021-12-14 04:22:38 | Delaware, New York, US | |
141163 | 141163 | 2021-12-04 | US | Texas | Palo Pinto | 48363 | 4929 | 123 | 0 | 32.75310985 | -98.31319001 | 2021-12-05 04:22:25 | Palo Pinto, Texas, US | |
1296 | 1296 | 2021-12-02 | US | Illinois | Bureau | 17011 | 4929 | 98 | 0 | 41.40385234 | -89.5283051 | 2021-12-03 04:23:05 | Bureau, Illinois, US | |
3751265 | 3751265 | 2021-11-22 | US | Nevada | Douglas | 32005 | 4929 | 66 | 0 | 38.912862 | -119.61713329999999 | 2021-11-23 04:22:39 | Douglas, Nevada, US | |
3750205 | 3750205 | 2021-11-22 | US | Indiana | Daviess | 18027 | 4929 | 116 | 0 | 38.70186039 | -87.07185406 | 2021-11-23 04:22:39 | Daviess, Indiana, US | |
3291197 | 3291197 | 2021-11-18 | US | New York | Wyoming | 36121 | 4929 | 63 | 0 | 42.70145109 | -78.22199579 | 2021-11-19 04:21:40 | Wyoming, New York, US | |
30153 | 30153 | 2021-11-11 | US | Minnesota | Lyon | 27083 | 4929 | 59 | 0 | 44.41327865 | -95.83806103 | 2021-11-12 04:22:01 | Lyon, Minnesota, US | |
568168 | 568168 | 2021-10-29 | US | Indiana | Adams | 18001 | 4929 | 77 | 0 | 40.7457653 | -84.93671406 | 2021-10-30 04:22:03 | Adams, Indiana, US | |
1911428 | 1911428 | 2021-10-17 | US | New Mexico | Unassigned | 90035 | 4929 | 0 | 0 | 36.60569702 | -108.7151824 | 2021-10-18 04:21:10 | Unassigned, New Mexico, US | |
938308 | 938308 | 2021-10-16 | US | West Virginia | Preston | 54077 | 4929 | 77 | 0 | 39.46770987 | -79.66712803 | 2021-10-17 04:21:29 | Preston, West Virginia, US | |
937017 | 937017 | 2021-10-16 | US | New Mexico | Unassigned | 90035 | 4929 | 0 | 0 | 36.60569702 | -108.7151824 | 2021-10-17 04:21:29 | Unassigned, New Mexico, US | |
2945572 | 2945572 | 2021-10-15 | US | New Mexico | Unassigned | 90035 | 4929 | 0 | 0 | 36.60569702 | -108.7151824 | 2021-10-16 04:21:15 | Unassigned, New Mexico, US | |
2460180 | 2460180 | 2021-10-06 | US | Kentucky | Clark | 21049 | 4929 | 32 | 0 | 37.9689263 | -84.14615986 | 2021-10-07 04:21:36 | Clark, Kentucky, US | |
2135514 | 2135514 | 2021-10-01 | US | West Virginia | Marshall | 54051 | 4929 | 99 | 0 | 39.86064362 | -80.66591062 | 2021-10-02 04:21:25 | Marshall, West Virginia, US | |
1239164 | 1239164 | 2021-09-27 | US | West Virginia | Wayne | 54099 | 4929 | 58 | 0 | 38.14901357 | -82.42287994 | 2021-09-28 04:21:28 | Wayne, West Virginia, US | |
1237034 | 1237034 | 2021-09-27 | US | Kentucky | Clay | 21051 | 4929 | 54 | 0 | 37.16451126 | -83.712575 | 2021-09-28 04:21:28 | Clay, Kentucky, US | |
2077095 | 2077095 | 2021-09-26 | US | Indiana | Wabash | 18169 | 4929 | 92 | 0 | 40.84704239 | -85.79328272 | 2021-09-27 04:21:16 | Wabash, Indiana, US | |
604808 | 604808 | 2021-09-23 | US | Texas | Hockley | 48219 | 4929 | 125 | 0 | 33.60771256 | -102.3431676 | 2021-09-24 04:21:44 | Hockley, Texas, US | |
3758923 | 3758923 | 2021-09-21 | US | Kentucky | Muhlenberg | 21177 | 4929 | 81 | 0 | 37.21425819 | -87.14632053 | 2021-09-22 04:21:45 | Muhlenberg, Kentucky, US | |
641983 | 641983 | 2021-09-07 | Japan | Wakayama | 4929 | 55 | 0 | 33.911879 | 135.505446 | 2021-09-08 04:21:31 | Wakayama, Japan | |||
3281397 | 3281397 | 2021-09-05 | US | Arkansas | Unassigned | 90005 | 4929 | 0 | 0 | 36.38177105 | 0.0 | 2021-09-06 04:21:22 | Unassigned, Arkansas, US | |
180836 | 180836 | 2021-09-02 | US | South Carolina | Colleton | 45029 | 4929 | 153 | 0 | 32.87582989 | -80.67641292 | 2021-09-03 04:21:20 | Colleton, South Carolina, US | |
1606059 | 1606059 | 2021-08-16 | US | Mississippi | Monroe | 28095 | 4929 | 138 | 0 | 33.89236763 | -88.4808438 | 2021-08-17 04:21:49 | Monroe, Mississippi, US | |
510659 | 510659 | 2021-08-14 | US | Tennessee | Obion | 47131 | 4929 | 97 | 0 | 36.35732446 | -89.14921589 | 2021-08-15 04:21:41 | Obion, Tennessee, US | |
1343058 | 1343058 | 2021-08-11 | US | Georgia | Chattahoochee | 13053 | 4929 | 17 | 0 | 32.34341231 | -84.78809239 | 2021-08-12 04:21:25 | Chattahoochee, Georgia, 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]);