johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
127 rows where confirmed = 5853 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1074573 | 1074573 | 2022-12-28 | US | Colorado | Teller | 8119 | 5853 | 64 | 0 | 38.88133511 | -105.1614893 | 2022-12-29 04:21:01 | Teller, Colorado, US | |
2442056 | 2442056 | 2022-11-07 | US | Virginia | Buchanan | 51027 | 5853 | 134 | 0 | 37.26818323 | -82.03749726 | 2022-11-08 04:21:21 | Buchanan, Virginia, US | |
1832487 | 1832487 | 2022-10-25 | US | North Carolina | Hertford | 37091 | 5853 | 93 | 0 | 36.3607755 | -76.98104134 | 2022-10-26 04:22:19 | Hertford, North Carolina, US | |
796748 | 796748 | 2022-10-24 | US | North Carolina | Hertford | 37091 | 5853 | 93 | 0 | 36.3607755 | -76.98104134 | 2022-10-25 04:21:53 | Hertford, North Carolina, US | |
3279203 | 3279203 | 2022-10-23 | US | North Carolina | Hertford | 37091 | 5853 | 93 | 0 | 36.3607755 | -76.98104134 | 2022-10-24 04:22:29 | Hertford, North Carolina, US | |
2270241 | 2270241 | 2022-10-22 | US | North Carolina | Hertford | 37091 | 5853 | 93 | 0 | 36.3607755 | -76.98104134 | 2022-10-23 04:22:46 | Hertford, North Carolina, US | |
1594541 | 1594541 | 2022-10-21 | US | North Carolina | Hertford | 37091 | 5853 | 93 | 0 | 36.3607755 | -76.98104134 | 2022-10-22 04:22:53 | Hertford, North Carolina, US | |
2274257 | 2274257 | 2022-10-20 | US | North Carolina | Hertford | 37091 | 5853 | 93 | 0 | 36.3607755 | -76.98104134 | 2022-10-21 04:22:23 | Hertford, North Carolina, US | |
200592 | 200592 | 2022-10-19 | US | North Carolina | Hertford | 37091 | 5853 | 93 | 0 | 36.3607755 | -76.98104134 | 2022-10-20 04:22:59 | Hertford, North Carolina, US | |
2759253 | 2759253 | 2022-10-18 | US | North Carolina | Hertford | 37091 | 5853 | 93 | 0 | 36.3607755 | -76.98104134 | 2022-10-19 04:22:26 | Hertford, North Carolina, US | |
2027087 | 2027087 | 2022-10-17 | US | North Carolina | Hertford | 37091 | 5853 | 93 | 0 | 36.3607755 | -76.98104134 | 2022-10-18 04:22:42 | Hertford, North Carolina, US | |
2161865 | 2161865 | 2022-10-16 | US | North Carolina | Hertford | 37091 | 5853 | 93 | 0 | 36.3607755 | -76.98104134 | 2022-10-17 04:20:31 | Hertford, North Carolina, US | |
518062 | 518062 | 2022-10-15 | US | North Carolina | Hertford | 37091 | 5853 | 93 | 0 | 36.3607755 | -76.98104134 | 2022-10-16 04:22:39 | Hertford, North Carolina, US | |
2035119 | 2035119 | 2022-10-14 | US | North Carolina | Hertford | 37091 | 5853 | 93 | 0 | 36.3607755 | -76.98104134 | 2022-10-15 04:22:00 | Hertford, North Carolina, US | |
3755807 | 3755807 | 2022-10-13 | US | North Carolina | Hertford | 37091 | 5853 | 93 | 0 | 36.3607755 | -76.98104134 | 2022-10-14 04:22:28 | Hertford, North Carolina, US | |
3216632 | 3216632 | 2022-10-12 | US | North Carolina | Hertford | 37091 | 5853 | 93 | 0 | 36.3607755 | -76.98104134 | 2022-10-13 04:22:39 | Hertford, North Carolina, US | |
2261356 | 2261356 | 2022-10-02 | US | Maryland | Somerset | 24039 | 5853 | 77 | 0 | 38.1163542 | -75.75118623 | 2022-10-03 04:23:11 | Somerset, Maryland, US | |
2996882 | 2996882 | 2022-10-01 | US | Maryland | Somerset | 24039 | 5853 | 77 | 0 | 38.1163542 | -75.75118623 | 2022-10-02 04:21:23 | Somerset, Maryland, US | |
855208 | 855208 | 2022-09-30 | US | Maryland | Somerset | 24039 | 5853 | 77 | 0 | 38.1163542 | -75.75118623 | 2022-10-01 04:23:01 | Somerset, Maryland, US | |
2772442 | 2772442 | 2022-09-26 | US | West Virginia | Brooke | 54009 | 5853 | 106 | 0 | 40.27367263 | -80.57915332 | 2022-09-27 04:23:01 | Brooke, West Virginia, US | |
2397414 | 2397414 | 2022-09-12 | US | Oregon | Clatsop | 41007 | 5853 | 58 | 0 | 45.99712889 | -123.660711 | 2022-09-13 04:20:57 | Clatsop, Oregon, US | |
1880381 | 1880381 | 2022-08-28 | US | Virginia | Powhatan | 51145 | 5853 | 64 | 0 | 37.55016038 | -77.91267882 | 2022-08-29 04:21:06 | Powhatan, Virginia, US | |
2099508 | 2099508 | 2022-08-27 | US | Virginia | Powhatan | 51145 | 5853 | 64 | 0 | 37.55016038 | -77.91267882 | 2022-08-28 04:21:02 | Powhatan, Virginia, US | |
1535323 | 1535323 | 2022-08-26 | US | Virginia | Powhatan | 51145 | 5853 | 64 | 0 | 37.55016038 | -77.91267882 | 2022-08-27 04:20:57 | Powhatan, Virginia, US | |
3408461 | 3408461 | 2022-07-17 | US | Tennessee | Union | 47173 | 5853 | 78 | 0 | 36.28590426 | -83.83651902 | 2022-07-18 04:20:59 | Union, Tennessee, US | |
144706 | 144706 | 2022-07-09 | US | Puerto Rico | Aibonito | 72009 | 5853 | 0 | 0 | 18.131361 | -66.264131 | 2022-07-10 04:20:54 | Aibonito, Puerto Rico, US | |
2149383 | 2149383 | 2022-06-27 | US | Minnesota | Martin | 27091 | 5853 | 65 | 0 | 43.67429718 | -94.55099908 | 2022-06-28 04:20:58 | Martin, Minnesota, US | |
1423844 | 1423844 | 2022-06-08 | US | Puerto Rico | Fajardo | 72053 | 5853 | 0 | 0 | 18.318373 | -65.666866 | 2022-06-09 04:20:54 | Fajardo, Puerto Rico, US | |
232246 | 232246 | 2022-05-31 | US | Texas | Austin | 48015 | 5853 | 73 | 0 | 29.88548725 | -96.27736949 | 2022-06-01 04:20:55 | Austin, Texas, US | |
2895507 | 2895507 | 2022-04-21 | US | Texas | Frio | 48163 | 5853 | 93 | 0 | 28.86751206 | -99.10804207 | 2022-04-22 04:20:45 | Frio, Texas, US | |
1951439 | 1951439 | 2022-04-12 | US | Tennessee | Chester | 47023 | 5853 | 97 | 0 | 35.42527478 | -88.6095842 | 2022-04-13 04:21:03 | Chester, Tennessee, US | |
3209192 | 3209192 | 2022-04-11 | US | Tennessee | Chester | 47023 | 5853 | 96 | 0 | 35.42527478 | -88.6095842 | 2022-04-12 04:20:49 | Chester, Tennessee, US | |
3207774 | 3207774 | 2022-04-11 | US | Louisiana | Grant | 22043 | 5853 | 94 | 0 | 31.59882456 | -92.56124347 | 2022-04-12 04:20:49 | Grant, Louisiana, US | |
1577660 | 1577660 | 2022-04-10 | US | Louisiana | Grant | 22043 | 5853 | 94 | 0 | 31.59882456 | -92.56124347 | 2022-04-11 04:21:02 | Grant, Louisiana, US | |
1653902 | 1653902 | 2022-04-09 | US | Louisiana | Grant | 22043 | 5853 | 94 | 0 | 31.59882456 | -92.56124347 | 2022-04-10 04:20:52 | Grant, Louisiana, US | |
2117224 | 2117224 | 2022-04-08 | US | Louisiana | Grant | 22043 | 5853 | 94 | 0 | 31.59882456 | -92.56124347 | 2022-04-09 04:20:42 | Grant, Louisiana, US | |
3321748 | 3321748 | 2022-04-07 | US | Louisiana | Grant | 22043 | 5853 | 94 | 0 | 31.59882456 | -92.56124347 | 2022-04-08 04:20:48 | Grant, Louisiana, US | |
1647090 | 1647090 | 2022-03-03 | US | Puerto Rico | Canovanas | 72029 | 5853 | 0 | 0 | 18.328802 | -65.887612 | 2022-03-04 04:21:09 | Canovanas, Puerto Rico, US | |
2474773 | 2474773 | 2022-02-03 | US | Georgia | Harris | 13145 | 5853 | 99 | 0 | 32.73709786 | -84.90538572 | 2022-02-04 04:21:10 | Harris, Georgia, US | |
3303727 | 3303727 | 2022-01-30 | US | West Virginia | Upshur | 54097 | 5853 | 77 | 0 | 38.89285061 | -80.23689136 | 2022-01-31 04:21:09 | Upshur, West Virginia, US | |
3229880 | 3229880 | 2022-01-19 | US | Virginia | Wythe | 51197 | 5853 | 121 | 0 | 36.91582035 | -81.07834059 | 2022-01-20 04:21:07 | Wythe, Virginia, US | |
3464719 | 3464719 | 2022-01-18 | US | California | Calaveras | 6009 | 5853 | 94 | 0 | 38.20537103 | -120.55291299999999 | 2022-01-19 04:21:23 | Calaveras, California, US | |
557535 | 557535 | 2022-01-16 | US | Puerto Rico | Gurabo | 72063 | 5853 | 0 | 0 | 18.266461 | -65.97970500000001 | 2022-01-17 04:21:08 | Gurabo, Puerto Rico, US | |
3613594 | 3613594 | 2022-01-12 | US | Arkansas | St. Francis | 5123 | 5853 | 74 | 0 | 35.02201976 | -90.74828138 | 2022-01-13 08:00:09 | St. Francis, Arkansas, US | |
4001496 | 4001496 | 2021-12-30 | US | South Carolina | Williamsburg | 45089 | 5853 | 131 | 0 | 33.62190129 | -79.72767442 | 2021-12-31 04:21:50 | Williamsburg, South Carolina, US | |
2904615 | 2904615 | 2021-12-19 | US | Georgia | Wayne | 13305 | 5853 | 176 | 0 | 31.5521809 | -81.91894878 | 2021-12-20 04:21:43 | Wayne, Georgia, US | |
1259688 | 1259688 | 2021-12-18 | US | Georgia | Wayne | 13305 | 5853 | 176 | 0 | 31.5521809 | -81.91894878 | 2021-12-19 04:21:11 | Wayne, Georgia, US | |
2399716 | 2399716 | 2021-12-17 | US | Georgia | Wayne | 13305 | 5853 | 176 | 0 | 31.5521809 | -81.91894878 | 2021-12-18 02:22:20 | Wayne, Georgia, US | |
1717254 | 1717254 | 2021-12-16 | US | Georgia | Wayne | 13305 | 5853 | 176 | 0 | 31.5521809 | -81.91894878 | 2021-12-17 04:22:14 | Wayne, Georgia, US | |
3499197 | 3499197 | 2021-12-15 | US | Tennessee | White | 47185 | 5853 | 103 | 0 | 35.92929884 | -85.45591799 | 2021-12-16 04:22:11 | White, Tennessee, US | |
3497088 | 3497088 | 2021-12-15 | US | Georgia | Wayne | 13305 | 5853 | 176 | 0 | 31.5521809 | -81.91894878 | 2021-12-16 04:22:11 | Wayne, Georgia, US | |
3291837 | 3291837 | 2021-11-18 | US | Tennessee | Carroll | 47017 | 5853 | 104 | 0 | 35.97366108 | -88.45189331 | 2021-11-19 04:21:40 | Carroll, Tennessee, US | |
1323740 | 1323740 | 2021-11-14 | US | Louisiana | Iberville | 22047 | 5853 | 127 | 0 | 30.25734305 | -91.3499598 | 2021-11-15 04:21:36 | Iberville, Louisiana, US | |
687866 | 687866 | 2021-11-13 | US | Louisiana | Iberville | 22047 | 5853 | 127 | 0 | 30.25734305 | -91.3499598 | 2021-11-14 04:21:31 | Iberville, Louisiana, US | |
715975 | 715975 | 2021-11-12 | US | Louisiana | Iberville | 22047 | 5853 | 127 | 0 | 30.25734305 | -91.3499598 | 2021-11-13 04:21:38 | Iberville, Louisiana, US | |
45213 | 45213 | 2021-11-02 | US | Louisiana | Evangeline | 22039 | 5853 | 140 | 0 | 30.72985248 | -92.39915924 | 2021-11-03 06:22:09 | Evangeline, Louisiana, US | |
3512909 | 3512909 | 2021-11-01 | US | Louisiana | Evangeline | 22039 | 5853 | 140 | 0 | 30.72985248 | -92.39915924 | 2021-11-02 04:22:03 | Evangeline, Louisiana, US | |
289624 | 289624 | 2021-10-31 | US | Michigan | Delta | 26041 | 5853 | 106 | 0 | 45.90484910000001 | -86.9080745 | 2021-11-01 04:22:01 | Delta, Michigan, US | |
288014 | 288014 | 2021-10-31 | Japan | Saga | 5853 | 30 | 0 | 33.286977 | 130.115738 | 2021-11-01 04:22:01 | Saga, Japan | |||
2722630 | 2722630 | 2021-10-30 | US | Michigan | Delta | 26041 | 5853 | 106 | 0 | 45.90484910000001 | -86.9080745 | 2021-10-31 04:22:08 | Delta, Michigan, US | |
2721020 | 2721020 | 2021-10-30 | Japan | Saga | 5853 | 30 | 0 | 33.286977 | 130.115738 | 2021-10-31 04:22:08 | Saga, Japan | |||
568732 | 568732 | 2021-10-29 | US | Michigan | Delta | 26041 | 5853 | 106 | 0 | 45.90484910000001 | -86.9080745 | 2021-10-30 04:22:03 | Delta, Michigan, US | |
568179 | 568179 | 2021-10-29 | US | Indiana | Clinton | 18023 | 5853 | 72 | 0 | 40.30319754 | -86.47277257 | 2021-10-30 04:22:03 | Clinton, Indiana, US | |
567122 | 567122 | 2021-10-29 | Japan | Saga | 5853 | 30 | 0 | 33.286977 | 130.115738 | 2021-10-30 04:22:03 | Saga, Japan | |||
3494756 | 3494756 | 2021-10-26 | US | Oklahoma | Okmulgee | 40111 | 5853 | 138 | 0 | 35.64661916 | -95.96432828 | 2021-10-27 04:22:32 | Okmulgee, Oklahoma, US | |
3796478 | 3796478 | 2021-10-25 | US | Oklahoma | Okmulgee | 40111 | 5853 | 138 | 0 | 35.64661916 | -95.96432828 | 2021-10-26 04:22:09 | Okmulgee, Oklahoma, US | |
684924 | 684924 | 2021-10-24 | US | Oklahoma | Okmulgee | 40111 | 5853 | 138 | 0 | 35.64661916 | -95.96432828 | 2021-10-25 04:22:31 | Okmulgee, Oklahoma, US | |
683112 | 683112 | 2021-10-24 | US | Georgia | Chattahoochee | 13053 | 5853 | 19 | 0 | 32.34341231 | -84.78809239 | 2021-10-25 04:22:31 | Chattahoochee, Georgia, US | |
772932 | 772932 | 2021-10-23 | US | Oklahoma | Okmulgee | 40111 | 5853 | 138 | 0 | 35.64661916 | -95.96432828 | 2021-10-24 04:21:22 | Okmulgee, Oklahoma, US | |
771120 | 771120 | 2021-10-23 | US | Georgia | Chattahoochee | 13053 | 5853 | 19 | 0 | 32.34341231 | -84.78809239 | 2021-10-24 04:21:22 | Chattahoochee, Georgia, US | |
656579 | 656579 | 2021-10-22 | US | Oklahoma | Okmulgee | 40111 | 5853 | 138 | 0 | 35.64661916 | -95.96432828 | 2021-10-23 04:21:32 | Okmulgee, Oklahoma, US | |
654767 | 654767 | 2021-10-22 | US | Georgia | Chattahoochee | 13053 | 5853 | 19 | 0 | 32.34341231 | -84.78809239 | 2021-10-23 04:21:32 | Chattahoochee, Georgia, US | |
2126326 | 2126326 | 2021-10-21 | US | Oklahoma | Okmulgee | 40111 | 5853 | 138 | 0 | 35.64661916 | -95.96432828 | 2021-10-22 04:21:14 | Okmulgee, Oklahoma, US | |
445938 | 445938 | 2021-10-20 | US | Oklahoma | Okmulgee | 40111 | 5853 | 138 | 0 | 35.64661916 | -95.96432828 | 2021-10-21 04:21:18 | Okmulgee, Oklahoma, US | |
989345 | 989345 | 2021-10-04 | US | North Carolina | Stokes | 37169 | 5853 | 99 | 0 | 36.4017975 | -80.23893369 | 2021-10-05 04:21:27 | Stokes, North Carolina, US | |
3196849 | 3196849 | 2021-09-06 | US | South Dakota | Brown | 46013 | 5853 | 95 | 0 | 45.58994323 | -98.35165355 | 2021-09-07 04:21:35 | Brown, South Dakota, US | |
3194602 | 3194602 | 2021-09-06 | US | Colorado | Broomfield | 8014 | 5853 | 79 | 0 | 39.95998787 | -105.0566324 | 2021-09-07 04:21:35 | Broomfield, Colorado, US | |
3283835 | 3283835 | 2021-09-05 | US | Tennessee | Marshall | 47117 | 5853 | 69 | 0 | 35.45798777 | -86.76420988 | 2021-09-06 04:21:22 | Marshall, Tennessee, US | |
3283717 | 3283717 | 2021-09-05 | US | South Dakota | Brown | 46013 | 5853 | 95 | 0 | 45.58994323 | -98.35165355 | 2021-09-06 04:21:22 | Brown, South Dakota, US | |
252131 | 252131 | 2021-09-04 | US | South Dakota | Brown | 46013 | 5853 | 95 | 0 | 45.58994323 | -98.35165355 | 2021-09-05 04:21:33 | Brown, South Dakota, US | |
3977412 | 3977412 | 2021-09-03 | US | South Dakota | Brown | 46013 | 5853 | 95 | 0 | 45.58994323 | -98.35165355 | 2021-09-04 04:21:28 | Brown, South Dakota, US | |
2175581 | 2175581 | 2021-08-22 | Japan | Niigata | 5853 | 54 | 0 | 37.521819 | 138.918647 | 2021-08-23 04:21:27 | Niigata, Japan | |||
2521431 | 2521431 | 2021-08-18 | US | Texas | Wilson | 48493 | 5853 | 76 | 0 | 29.1732598 | -98.08693082 | 2021-08-19 04:21:15 | Wilson, Texas, US | |
3471210 | 3471210 | 2021-08-03 | US | Texas | Burnet | 48053 | 5853 | 73 | 0 | 30.78801353 | -98.181887 | 2021-08-04 04:21:25 | Burnet, Texas, US | |
3906249 | 3906249 | 2021-07-31 | US | New York | Wayne | 36117 | 5853 | 73 | 0 | 43.15494365 | -77.02976528 | 2021-08-01 04:21:50 | Wayne, New York, US | |
411474 | 411474 | 2021-07-28 | US | Texas | Nacogdoches | 48347 | 5853 | 176 | 0 | 31.62017125 | -94.61803994 | 2021-07-29 04:21:33 | Nacogdoches, Texas, US | |
3219994 | 3219994 | 2021-07-26 | US | Minnesota | Benton | 27009 | 5853 | 98 | 0 | 45.69804958 | -93.99514135 | 2021-07-27 04:21:18 | Benton, Minnesota, US | |
3219127 | 3219127 | 2021-07-26 | US | Georgia | Laurens | 13175 | 5853 | 173 | 0 | 32.46325233 | -82.92221316 | 2021-07-27 04:21:18 | Laurens, Georgia, US | |
3706482 | 3706482 | 2021-07-17 | US | Alabama | Coffee | 1031 | 5853 | 130 | 0 | 31.39932826 | -85.98901039 | 2021-07-18 04:22:07 | Coffee, Alabama, US | |
3633484 | 3633484 | 2021-07-14 | US | Louisiana | St. Charles | 22089 | 5853 | 98 | 0 | 29.90709658 | -90.35555967 | 2021-07-15 04:21:48 | St. Charles, Louisiana, US | |
1164939 | 1164939 | 2021-07-04 | Canada | Nova Scotia | 5853 | 92 | 5708 | 53 | 44.682 | -63.7443 | 2021-07-05 04:21:28 | Nova Scotia, Canada | ||
2073162 | 2073162 | 2021-07-02 | US | Iowa | Warren | 19181 | 5853 | 92 | 0 | 41.33559454 | -93.56007641 | 2021-07-03 04:21:37 | Warren, Iowa, US | |
3128023 | 3128023 | 2021-06-28 | US | Ohio | Union | 39159 | 5853 | 49 | 0 | 40.30016061 | -83.37239023 | 2021-06-29 04:21:28 | Union, Ohio, US | |
2592518 | 2592518 | 2021-06-27 | US | Ohio | Union | 39159 | 5853 | 49 | 0 | 40.30016061 | -83.37239023 | 2021-06-28 04:21:29 | Union, Ohio, US | |
3961022 | 3961022 | 2021-06-26 | US | Ohio | Union | 39159 | 5853 | 49 | 0 | 40.30016061 | -83.37239023 | 2021-06-27 04:21:39 | Union, Ohio, US | |
2424859 | 2424859 | 2021-06-23 | US | Missouri | Taney | 29213 | 5853 | 99 | 0 | 36.65465345 | -93.04075153 | 2021-06-24 04:21:55 | Taney, Missouri, US | |
3972294 | 3972294 | 2021-06-11 | US | Minnesota | Otter Tail | 27111 | 5853 | 84 | 0 | 46.40846929 | -95.70835255 | 2021-06-12 04:22:22 | Otter Tail, Minnesota, US | |
23821 | 23821 | 2021-05-28 | US | Washington | Skagit | 53057 | 5853 | 73 | 0 | 48.48171488 | -121.766131 | 2021-05-29 04:20:41 | Skagit, Washington, US | |
84167 | 84167 | 2021-05-25 | US | Indiana | Dearborn | 18029 | 5853 | 78 | 0 | 39.14647946 | -84.97333539 | 2021-05-26 04:20:35 | Dearborn, Indiana, US | |
1085453 | 1085453 | 2021-05-14 | US | Wisconsin | Columbia | 55021 | 5853 | 69 | 0 | 43.46492199 | -89.33589004 | 2021-05-15 04:20:58 | Columbia, Wisconsin, 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]);