johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
420 rows where confirmed = 2150 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
328696 | 328696 | 2022-12-27 | US | Georgia | Crawford | 13079 | 2150 | 64 | 0 | 32.71391813 | -83.98061238 | 2022-12-28 04:21:04 | Crawford, Georgia, US | |
218769 | 218769 | 2022-12-26 | US | Georgia | Crawford | 13079 | 2150 | 64 | 0 | 32.71391813 | -83.98061238 | 2022-12-27 04:21:07 | Crawford, Georgia, US | |
3223226 | 3223226 | 2022-12-25 | US | Georgia | Crawford | 13079 | 2150 | 64 | 0 | 32.71391813 | -83.98061238 | 2022-12-26 04:21:06 | Crawford, Georgia, US | |
1019140 | 1019140 | 2022-12-24 | US | Georgia | Crawford | 13079 | 2150 | 64 | 0 | 32.71391813 | -83.98061238 | 2022-12-25 04:21:04 | Crawford, Georgia, US | |
691163 | 691163 | 2022-12-23 | US | Georgia | Crawford | 13079 | 2150 | 64 | 0 | 32.71391813 | -83.98061238 | 2022-12-24 04:21:02 | Crawford, Georgia, US | |
2180373 | 2180373 | 2022-12-22 | US | Georgia | Crawford | 13079 | 2150 | 64 | 0 | 32.71391813 | -83.98061238 | 2022-12-23 04:21:04 | Crawford, Georgia, US | |
452177 | 452177 | 2022-12-21 | US | Georgia | Crawford | 13079 | 2150 | 64 | 0 | 32.71391813 | -83.98061238 | 2022-12-22 04:20:56 | Crawford, Georgia, US | |
311714 | 311714 | 2022-11-13 | China | Xinjiang | 2150 | 3 | 0 | 41.1129 | 85.2401 | 2022-11-14 04:21:09 | Xinjiang, China | |||
62875 | 62875 | 2022-11-12 | China | Xinjiang | 2150 | 3 | 0 | 41.1129 | 85.2401 | 2022-11-13 04:21:14 | Xinjiang, China | |||
1053156 | 1053156 | 2022-11-06 | US | Virginia | Buena Vista | 51530 | 2150 | 45 | 0 | 37.73484642 | -79.35296097 | 2022-11-07 04:21:26 | Buena Vista, Virginia, US | |
621180 | 621180 | 2022-11-05 | US | Virginia | Buena Vista | 51530 | 2150 | 45 | 0 | 37.73484642 | -79.35296097 | 2022-11-06 04:21:24 | Buena Vista, Virginia, US | |
1025684 | 1025684 | 2022-11-04 | US | Virginia | Buena Vista | 51530 | 2150 | 45 | 0 | 37.73484642 | -79.35296097 | 2022-11-05 04:21:52 | Buena Vista, Virginia, US | |
434675 | 434675 | 2022-11-03 | US | Virginia | Buena Vista | 51530 | 2150 | 45 | 0 | 37.73484642 | -79.35296097 | 2022-11-04 04:22:11 | Buena Vista, Virginia, US | |
713768 | 713768 | 2022-11-01 | US | Virginia | Buena Vista | 51530 | 2150 | 45 | 0 | 37.73484642 | -79.35296097 | 2022-11-02 04:22:09 | Buena Vista, Virginia, US | |
2757460 | 2757460 | 2022-10-18 | US | Arkansas | Woodruff | 5147 | 2150 | 32 | 0 | 35.18902527 | -91.2439489 | 2022-10-19 04:22:26 | Woodruff, Arkansas, US | |
2025294 | 2025294 | 2022-10-17 | US | Arkansas | Woodruff | 5147 | 2150 | 32 | 0 | 35.18902527 | -91.2439489 | 2022-10-18 04:22:42 | Woodruff, Arkansas, US | |
2160072 | 2160072 | 2022-10-16 | US | Arkansas | Woodruff | 5147 | 2150 | 32 | 0 | 35.18902527 | -91.2439489 | 2022-10-17 04:20:31 | Woodruff, Arkansas, US | |
2159714 | 2159714 | 2022-10-16 | Peru | Unknown | 2150 | 122 | 0 | 2022-10-17 04:20:31 | Unknown, Peru | |||||
516269 | 516269 | 2022-10-15 | US | Arkansas | Woodruff | 5147 | 2150 | 32 | 0 | 35.18902527 | -91.2439489 | 2022-10-16 04:22:39 | Woodruff, Arkansas, US | |
3574209 | 3574209 | 2022-09-19 | US | Wyoming | Johnson | 56019 | 2150 | 21 | 0 | 44.04057166 | -106.5845174 | 2022-09-20 04:22:48 | Johnson, Wyoming, US | |
422948 | 422948 | 2022-09-18 | US | Wyoming | Johnson | 56019 | 2150 | 21 | 0 | 44.04057166 | -106.5845174 | 2022-09-19 04:21:49 | Johnson, Wyoming, US | |
3376972 | 3376972 | 2022-09-17 | US | Wyoming | Johnson | 56019 | 2150 | 21 | 0 | 44.04057166 | -106.5845174 | 2022-09-18 04:22:50 | Johnson, Wyoming, US | |
2359080 | 2359080 | 2022-09-16 | US | Wyoming | Johnson | 56019 | 2150 | 21 | 0 | 44.04057166 | -106.5845174 | 2022-09-17 04:20:19 | Johnson, Wyoming, US | |
3990237 | 3990237 | 2022-09-15 | US | Wyoming | Johnson | 56019 | 2150 | 21 | 0 | 44.04057166 | -106.5845174 | 2022-09-16 04:21:19 | Johnson, Wyoming, US | |
1892754 | 1892754 | 2022-09-14 | US | Wyoming | Johnson | 56019 | 2150 | 21 | 0 | 44.04057166 | -106.5845174 | 2022-09-15 04:21:02 | Johnson, Wyoming, US | |
375809 | 375809 | 2022-09-13 | US | Wyoming | Johnson | 56019 | 2150 | 21 | 0 | 44.04057166 | -106.5845174 | 2022-09-14 04:20:44 | Johnson, Wyoming, US | |
374588 | 374588 | 2022-09-13 | US | North Dakota | Benson | 38005 | 2150 | 23 | 0 | 48.0683985 | -99.35916363 | 2022-09-14 04:20:44 | Benson, North Dakota, US | |
2398279 | 2398279 | 2022-09-12 | US | West Virginia | Calhoun | 54013 | 2150 | 15 | 0 | 38.84315422 | -81.11934872 | 2022-09-13 04:20:57 | Calhoun, West Virginia, US | |
2397190 | 2397190 | 2022-09-12 | US | North Dakota | Benson | 38005 | 2150 | 23 | 0 | 48.0683985 | -99.35916363 | 2022-09-13 04:20:57 | Benson, North Dakota, US | |
3768268 | 3768268 | 2022-09-11 | US | North Dakota | Benson | 38005 | 2150 | 23 | 0 | 48.0683985 | -99.35916363 | 2022-09-12 04:20:58 | Benson, North Dakota, US | |
3826843 | 3826843 | 2022-09-10 | US | North Dakota | Benson | 38005 | 2150 | 23 | 0 | 48.0683985 | -99.35916363 | 2022-09-11 04:20:50 | Benson, North Dakota, US | |
965300 | 965300 | 2022-09-09 | US | North Dakota | Benson | 38005 | 2150 | 23 | 0 | 48.0683985 | -99.35916363 | 2022-09-10 04:21:10 | Benson, North Dakota, US | |
1877651 | 1877651 | 2022-08-28 | US | Colorado | Yuma | 8125 | 2150 | 26 | 0 | 40.00346839 | -102.4258673 | 2022-08-29 04:21:06 | Yuma, Colorado, US | |
2096778 | 2096778 | 2022-08-27 | US | Colorado | Yuma | 8125 | 2150 | 26 | 0 | 40.00346839 | -102.4258673 | 2022-08-28 04:21:02 | Yuma, Colorado, US | |
1532593 | 1532593 | 2022-08-26 | US | Colorado | Yuma | 8125 | 2150 | 26 | 0 | 40.00346839 | -102.4258673 | 2022-08-27 04:20:57 | Yuma, Colorado, US | |
2829963 | 2829963 | 2022-08-25 | US | Indiana | Union | 18161 | 2150 | 22 | 0 | 39.62550777 | -84.92497066 | 2022-08-26 04:21:02 | Union, Indiana, US | |
2326922 | 2326922 | 2022-08-24 | US | Wisconsin | Pepin | 55091 | 2150 | 18 | 0 | 44.58307413 | -91.99949611 | 2022-08-25 04:21:13 | Pepin, Wisconsin, US | |
2324496 | 2324496 | 2022-08-24 | US | Indiana | Union | 18161 | 2150 | 22 | 0 | 39.62550777 | -84.92497066 | 2022-08-25 04:21:13 | Union, Indiana, US | |
1254331 | 1254331 | 2022-08-23 | US | Wisconsin | Pepin | 55091 | 2150 | 18 | 0 | 44.58307413 | -91.99949611 | 2022-08-24 04:20:46 | Pepin, Wisconsin, US | |
2856479 | 2856479 | 2022-08-22 | US | Wyoming | Sublette | 56035 | 2150 | 27 | 0 | 42.76558279 | -109.9130922 | 2022-08-23 04:20:56 | Sublette, Wyoming, US | |
2406451 | 2406451 | 2022-08-21 | US | Wyoming | Sublette | 56035 | 2150 | 27 | 0 | 42.76558279 | -109.9130922 | 2022-08-22 04:20:38 | Sublette, Wyoming, US | |
3801529 | 3801529 | 2022-08-20 | US | Wyoming | Sublette | 56035 | 2150 | 27 | 0 | 42.76558279 | -109.9130922 | 2022-08-21 04:20:44 | Sublette, Wyoming, US | |
2367115 | 2367115 | 2022-08-19 | US | Wyoming | Sublette | 56035 | 2150 | 27 | 0 | 42.76558279 | -109.9130922 | 2022-08-20 04:21:01 | Sublette, Wyoming, US | |
1164786 | 1164786 | 2022-08-18 | US | Wyoming | Sublette | 56035 | 2150 | 27 | 0 | 42.76558279 | -109.9130922 | 2022-08-19 04:20:54 | Sublette, Wyoming, US | |
3954110 | 3954110 | 2022-08-17 | US | Wyoming | Sublette | 56035 | 2150 | 27 | 0 | 42.76558279 | -109.9130922 | 2022-08-18 04:21:11 | Sublette, Wyoming, US | |
3951014 | 3951014 | 2022-08-17 | US | Arkansas | Prairie | 5117 | 2150 | 43 | 0 | 34.83624419 | -91.55162157 | 2022-08-18 04:21:11 | Prairie, Arkansas, US | |
994612 | 994612 | 2022-08-16 | US | Wyoming | Sublette | 56035 | 2150 | 27 | 0 | 42.76558279 | -109.9130922 | 2022-08-17 04:20:59 | Sublette, Wyoming, US | |
991516 | 991516 | 2022-08-16 | US | Arkansas | Prairie | 5117 | 2150 | 43 | 0 | 34.83624419 | -91.55162157 | 2022-08-17 04:20:59 | Prairie, Arkansas, US | |
1073118 | 1073118 | 2022-08-07 | US | Texas | Somervell | 48425 | 2150 | 36 | 0 | 32.22236802 | -97.77403489 | 2022-08-08 04:21:08 | Somervell, Texas, US | |
1072313 | 1072313 | 2022-08-07 | US | North Dakota | Pembina | 38067 | 2150 | 16 | 0 | 48.76623521 | -97.5523809 | 2022-08-08 04:21:08 | Pembina, North Dakota, US | |
1943706 | 1943706 | 2022-08-06 | US | Texas | Somervell | 48425 | 2150 | 36 | 0 | 32.22236802 | -97.77403489 | 2022-08-07 04:20:54 | Somervell, Texas, US | |
883505 | 883505 | 2022-08-05 | US | Texas | Somervell | 48425 | 2150 | 36 | 0 | 32.22236802 | -97.77403489 | 2022-08-06 04:20:56 | Somervell, Texas, US | |
2011916 | 2011916 | 2022-08-04 | US | Texas | Somervell | 48425 | 2150 | 36 | 0 | 32.22236802 | -97.77403489 | 2022-08-05 04:20:52 | Somervell, Texas, US | |
1101343 | 1101343 | 2022-08-03 | US | Texas | Somervell | 48425 | 2150 | 36 | 0 | 32.22236802 | -97.77403489 | 2022-08-04 04:20:58 | Somervell, Texas, US | |
3112800 | 3112800 | 2022-07-13 | US | Virginia | Buena Vista | 51530 | 2150 | 45 | 0 | 37.73484642 | -79.35296097 | 2022-07-14 04:20:57 | Buena Vista, Virginia, US | |
3111693 | 3111693 | 2022-07-13 | US | New Mexico | Quay | 35037 | 2150 | 59 | 0 | 35.10403332 | -103.5481727 | 2022-07-14 04:20:57 | Quay, New Mexico, US | |
3967703 | 3967703 | 2022-07-05 | US | Indiana | Warren | 18171 | 2150 | 30 | 0 | 40.34728141 | -87.35602659 | 2022-07-06 04:20:58 | Warren, Indiana, US | |
3079214 | 3079214 | 2022-07-04 | US | Indiana | Warren | 18171 | 2150 | 30 | 0 | 40.34728141 | -87.35602659 | 2022-07-05 04:20:45 | Warren, Indiana, US | |
1768496 | 1768496 | 2022-07-03 | US | Indiana | Warren | 18171 | 2150 | 30 | 0 | 40.34728141 | -87.35602659 | 2022-07-04 04:20:54 | Warren, Indiana, US | |
3366482 | 3366482 | 2022-07-02 | US | Indiana | Warren | 18171 | 2150 | 30 | 0 | 40.34728141 | -87.35602659 | 2022-07-03 04:20:59 | Warren, Indiana, US | |
594811 | 594811 | 2022-07-01 | US | Indiana | Warren | 18171 | 2150 | 30 | 0 | 40.34728141 | -87.35602659 | 2022-07-02 04:21:16 | Warren, Indiana, US | |
2238865 | 2238865 | 2022-06-12 | US | West Virginia | Gilmer | 54021 | 2150 | 19 | 0 | 38.9251277 | -80.85952723 | 2022-06-13 04:21:14 | Gilmer, West Virginia, US | |
3145063 | 3145063 | 2022-06-11 | US | West Virginia | Gilmer | 54021 | 2150 | 19 | 0 | 38.9251277 | -80.85952723 | 2022-06-12 04:20:53 | Gilmer, West Virginia, US | |
1947979 | 1947979 | 2022-06-10 | US | West Virginia | Gilmer | 54021 | 2150 | 19 | 0 | 38.9251277 | -80.85952723 | 2022-06-11 04:21:01 | Gilmer, West Virginia, US | |
1947548 | 1947548 | 2022-06-10 | US | Texas | Clay | 48077 | 2150 | 35 | 0 | 33.78686685 | -98.20771198 | 2022-06-11 04:21:01 | Clay, Texas, US | |
3578441 | 3578441 | 2022-06-02 | China | Yunnan | 2150 | 2 | 0 | 24.974 | 101.487 | 2022-06-03 04:20:58 | Yunnan, China | |||
2600077 | 2600077 | 2022-05-05 | US | Montana | Sanders | 30089 | 2150 | 46 | 0 | 47.67657534 | -115.1329916 | 2022-05-06 04:21:00 | Sanders, Montana, US | |
3267526 | 3267526 | 2022-05-04 | US | Montana | Sanders | 30089 | 2150 | 47 | 0 | 47.67657534 | -115.1329916 | 2022-05-05 04:20:55 | Sanders, Montana, US | |
1574165 | 1574165 | 2022-05-03 | US | Montana | Sanders | 30089 | 2150 | 47 | 0 | 47.67657534 | -115.1329916 | 2022-05-04 04:20:59 | Sanders, Montana, US | |
1572885 | 1572885 | 2022-05-03 | US | Georgia | Atkinson | 13003 | 2150 | 48 | 0 | 31.29633502 | -82.87545866 | 2022-05-04 04:20:59 | Atkinson, Georgia, US | |
466556 | 466556 | 2022-05-02 | US | Texas | Live Oak | 48297 | 2150 | 42 | 0 | 28.35101362 | -98.1246786 | 2022-05-03 04:21:00 | Live Oak, Texas, US | |
464145 | 464145 | 2022-05-02 | US | Georgia | Atkinson | 13003 | 2150 | 48 | 0 | 31.29633502 | -82.87545866 | 2022-05-03 04:21:00 | Atkinson, Georgia, US | |
3916784 | 3916784 | 2022-05-01 | US | Georgia | Atkinson | 13003 | 2150 | 48 | 0 | 31.29633502 | -82.87545866 | 2022-05-02 04:21:10 | Atkinson, Georgia, US | |
2841588 | 2841588 | 2022-04-30 | US | Georgia | Atkinson | 13003 | 2150 | 48 | 0 | 31.29633502 | -82.87545866 | 2022-05-01 04:20:57 | Atkinson, Georgia, US | |
1157901 | 1157901 | 2022-04-29 | US | Georgia | Atkinson | 13003 | 2150 | 48 | 0 | 31.29633502 | -82.87545866 | 2022-04-30 04:21:05 | Atkinson, Georgia, US | |
1697083 | 1697083 | 2022-04-28 | US | Georgia | Atkinson | 13003 | 2150 | 48 | 0 | 31.29633502 | -82.87545866 | 2022-04-29 04:20:59 | Atkinson, Georgia, US | |
3853846 | 3853846 | 2022-04-27 | US | Montana | Sanders | 30089 | 2150 | 47 | 0 | 47.67657534 | -115.1329916 | 2022-04-28 04:20:47 | Sanders, Montana, US | |
3852566 | 3852566 | 2022-04-27 | US | Georgia | Atkinson | 13003 | 2150 | 48 | 0 | 31.29633502 | -82.87545866 | 2022-04-28 04:20:47 | Atkinson, Georgia, US | |
1326996 | 1326996 | 2022-04-26 | US | Georgia | Atkinson | 13003 | 2150 | 48 | 0 | 31.29633502 | -82.87545866 | 2022-04-27 04:20:52 | Atkinson, Georgia, US | |
3722950 | 3722950 | 2022-04-25 | US | Georgia | Atkinson | 13003 | 2150 | 48 | 0 | 31.29633502 | -82.87545866 | 2022-04-26 04:20:51 | Atkinson, Georgia, US | |
2029518 | 2029518 | 2022-04-24 | US | Georgia | Atkinson | 13003 | 2150 | 48 | 0 | 31.29633502 | -82.87545866 | 2022-04-25 04:20:56 | Atkinson, Georgia, US | |
749118 | 749118 | 2022-04-23 | US | Puerto Rico | Rincon | 72117 | 2150 | 0 | 0 | 18.335442999999998 | -67.23174 | 2022-04-24 04:20:56 | Rincon, Puerto Rico, US | |
747093 | 747093 | 2022-04-23 | US | Georgia | Atkinson | 13003 | 2150 | 48 | 0 | 31.29633502 | -82.87545866 | 2022-04-24 04:20:56 | Atkinson, Georgia, US | |
3437578 | 3437578 | 2022-04-22 | US | Georgia | Atkinson | 13003 | 2150 | 48 | 0 | 31.29633502 | -82.87545866 | 2022-04-23 04:20:50 | Atkinson, Georgia, US | |
2893163 | 2893163 | 2022-04-21 | US | Georgia | Atkinson | 13003 | 2150 | 48 | 0 | 31.29633502 | -82.87545866 | 2022-04-22 04:20:45 | Atkinson, Georgia, US | |
2308035 | 2308035 | 2022-04-20 | US | Georgia | Atkinson | 13003 | 2150 | 48 | 0 | 31.29633502 | -82.87545866 | 2022-04-21 04:20:46 | Atkinson, Georgia, US | |
3420398 | 3420398 | 2022-04-17 | US | West Virginia | Doddridge | 54017 | 2150 | 18 | 0 | 39.27057157 | -80.70671527 | 2022-04-18 04:21:12 | Doddridge, West Virginia, US | |
307347 | 307347 | 2022-04-16 | US | West Virginia | Doddridge | 54017 | 2150 | 18 | 0 | 39.27057157 | -80.70671527 | 2022-04-17 04:20:59 | Doddridge, West Virginia, US | |
2673292 | 2673292 | 2022-04-15 | US | West Virginia | Doddridge | 54017 | 2150 | 18 | 0 | 39.27057157 | -80.70671527 | 2022-04-16 04:20:48 | Doddridge, West Virginia, US | |
1227077 | 1227077 | 2022-04-14 | US | West Virginia | Doddridge | 54017 | 2150 | 18 | 0 | 39.27057157 | -80.70671527 | 2022-04-15 04:20:57 | Doddridge, West Virginia, US | |
1224925 | 1224925 | 2022-04-14 | US | Kansas | Norton | 20137 | 2150 | 37 | 0 | 39.78443827 | -99.90286639 | 2022-04-13 23:21:06 | Norton, Kansas, US | |
2446235 | 2446235 | 2022-04-13 | US | West Virginia | Doddridge | 54017 | 2150 | 18 | 0 | 39.27057157 | -80.70671527 | 2022-04-13 23:21:06 | Doddridge, West Virginia, US | |
2444083 | 2444083 | 2022-04-13 | US | Kansas | Norton | 20137 | 2150 | 37 | 0 | 39.78443827 | -99.90286639 | 2022-04-13 23:21:06 | Norton, Kansas, US | |
1949840 | 1949840 | 2022-04-12 | US | Kansas | Norton | 20137 | 2150 | 37 | 0 | 39.78443827 | -99.90286639 | 2022-04-13 04:21:03 | Norton, Kansas, US | |
3209282 | 3209282 | 2022-04-11 | US | Texas | Archer | 48009 | 2150 | 28 | 0 | 33.61569967 | -98.68754589 | 2022-04-12 04:20:49 | Archer, Texas, US | |
3207593 | 3207593 | 2022-04-11 | US | Kansas | Norton | 20137 | 2150 | 37 | 0 | 39.78443827 | -99.90286639 | 2022-04-12 04:20:49 | Norton, Kansas, US | |
1579168 | 1579168 | 2022-04-10 | US | Texas | Archer | 48009 | 2150 | 28 | 0 | 33.61569967 | -98.68754589 | 2022-04-11 04:21:02 | Archer, Texas, US | |
1577479 | 1577479 | 2022-04-10 | US | Kansas | Norton | 20137 | 2150 | 37 | 0 | 39.78443827 | -99.90286639 | 2022-04-11 04:21:02 | Norton, Kansas, US | |
1655410 | 1655410 | 2022-04-09 | US | Texas | Archer | 48009 | 2150 | 28 | 0 | 33.61569967 | -98.68754589 | 2022-04-10 04:20:52 | Archer, Texas, US | |
1653721 | 1653721 | 2022-04-09 | US | Kansas | Norton | 20137 | 2150 | 37 | 0 | 39.78443827 | -99.90286639 | 2022-04-10 04:20:52 | Norton, Kansas, 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]);