johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
484 rows where confirmed = 1342 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
292887 | 292887 | 2022-11-15 | US | Georgia | Schley | 13249 | 1342 | 11 | 0 | 32.2654021 | -84.31258912 | 2022-11-16 04:21:09 | Schley, Georgia, US | |
3597917 | 3597917 | 2022-11-14 | US | Georgia | Schley | 13249 | 1342 | 11 | 0 | 32.2654021 | -84.31258912 | 2022-11-15 04:21:16 | Schley, Georgia, US | |
315021 | 315021 | 2022-11-13 | US | Texas | Hemphill | 48211 | 1342 | 8 | 0 | 35.83764858 | -100.2703577 | 2022-11-14 04:21:09 | Hemphill, Texas, US | |
312775 | 312775 | 2022-11-13 | US | Georgia | Schley | 13249 | 1342 | 11 | 0 | 32.2654021 | -84.31258912 | 2022-11-14 04:21:09 | Schley, Georgia, US | |
66182 | 66182 | 2022-11-12 | US | Texas | Hemphill | 48211 | 1342 | 8 | 0 | 35.83764858 | -100.2703577 | 2022-11-13 04:21:14 | Hemphill, Texas, US | |
63936 | 63936 | 2022-11-12 | US | Georgia | Schley | 13249 | 1342 | 11 | 0 | 32.2654021 | -84.31258912 | 2022-11-13 04:21:14 | Schley, Georgia, US | |
2930344 | 2930344 | 2022-11-11 | US | Texas | Hemphill | 48211 | 1342 | 8 | 0 | 35.83764858 | -100.2703577 | 2022-11-12 04:20:41 | Hemphill, Texas, US | |
2928098 | 2928098 | 2022-11-11 | US | Georgia | Schley | 13249 | 1342 | 11 | 0 | 32.2654021 | -84.31258912 | 2022-11-12 04:20:41 | Schley, Georgia, US | |
2509180 | 2509180 | 2022-11-10 | US | Texas | Hemphill | 48211 | 1342 | 8 | 0 | 35.83764858 | -100.2703577 | 2022-11-11 04:21:22 | Hemphill, Texas, US | |
2506934 | 2506934 | 2022-11-10 | US | Georgia | Schley | 13249 | 1342 | 11 | 0 | 32.2654021 | -84.31258912 | 2022-11-11 04:21:22 | Schley, Georgia, US | |
2434055 | 2434055 | 2022-11-09 | US | Texas | Hemphill | 48211 | 1342 | 8 | 0 | 35.83764858 | -100.2703577 | 2022-11-10 04:21:16 | Hemphill, Texas, US | |
2431809 | 2431809 | 2022-11-09 | US | Georgia | Schley | 13249 | 1342 | 11 | 0 | 32.2654021 | -84.31258912 | 2022-11-10 04:21:16 | Schley, Georgia, US | |
482711 | 482711 | 2022-11-08 | US | Texas | Hemphill | 48211 | 1342 | 8 | 0 | 35.83764858 | -100.2703577 | 2022-11-09 04:21:22 | Hemphill, Texas, US | |
2441861 | 2441861 | 2022-11-07 | US | Texas | Hemphill | 48211 | 1342 | 8 | 0 | 35.83764858 | -100.2703577 | 2022-11-08 04:21:21 | Hemphill, Texas, US | |
1052959 | 1052959 | 2022-11-06 | US | Texas | Hemphill | 48211 | 1342 | 8 | 0 | 35.83764858 | -100.2703577 | 2022-11-07 04:21:26 | Hemphill, Texas, US | |
620983 | 620983 | 2022-11-05 | US | Texas | Hemphill | 48211 | 1342 | 8 | 0 | 35.83764858 | -100.2703577 | 2022-11-06 04:21:24 | Hemphill, Texas, US | |
1025487 | 1025487 | 2022-11-04 | US | Texas | Hemphill | 48211 | 1342 | 8 | 0 | 35.83764858 | -100.2703577 | 2022-11-05 04:21:52 | Hemphill, Texas, US | |
434478 | 434478 | 2022-11-03 | US | Texas | Hemphill | 48211 | 1342 | 8 | 0 | 35.83764858 | -100.2703577 | 2022-11-04 04:22:11 | Hemphill, Texas, US | |
852720 | 852720 | 2022-11-02 | US | Texas | Hemphill | 48211 | 1342 | 8 | 0 | 35.83764858 | -100.2703577 | 2022-11-03 04:22:05 | Hemphill, Texas, US | |
713571 | 713571 | 2022-11-01 | US | Texas | Hemphill | 48211 | 1342 | 8 | 0 | 35.83764858 | -100.2703577 | 2022-11-02 04:22:09 | Hemphill, Texas, US | |
3288020 | 3288020 | 2022-10-31 | US | Texas | Hemphill | 48211 | 1342 | 8 | 0 | 35.83764858 | -100.2703577 | 2022-11-01 04:22:36 | Hemphill, Texas, US | |
323053 | 323053 | 2022-10-30 | US | Texas | Hemphill | 48211 | 1342 | 8 | 0 | 35.83764858 | -100.2703577 | 2022-10-31 04:21:36 | Hemphill, Texas, US | |
320976 | 320976 | 2022-10-30 | US | Illinois | Putnam | 17155 | 1342 | 11 | 0 | 41.2013541 | -89.2869272 | 2022-10-31 04:21:36 | Putnam, Illinois, US | |
915329 | 915329 | 2022-10-29 | US | Texas | Hemphill | 48211 | 1342 | 8 | 0 | 35.83764858 | -100.2703577 | 2022-10-30 04:22:14 | Hemphill, Texas, US | |
913252 | 913252 | 2022-10-29 | US | Illinois | Putnam | 17155 | 1342 | 11 | 0 | 41.2013541 | -89.2869272 | 2022-10-30 04:22:14 | Putnam, Illinois, US | |
1369598 | 1369598 | 2022-10-28 | US | Texas | Hemphill | 48211 | 1342 | 8 | 0 | 35.83764858 | -100.2703577 | 2022-10-29 04:21:13 | Hemphill, Texas, US | |
1367521 | 1367521 | 2022-10-28 | US | Illinois | Putnam | 17155 | 1342 | 11 | 0 | 41.2013541 | -89.2869272 | 2022-10-29 04:21:13 | Putnam, Illinois, US | |
3041453 | 3041453 | 2022-10-27 | US | Texas | Hemphill | 48211 | 1342 | 8 | 0 | 35.83764858 | -100.2703577 | 2022-10-28 04:22:31 | Hemphill, Texas, US | |
3039332 | 3039332 | 2022-10-27 | US | Illinois | Hardin | 17069 | 1342 | 20 | 0 | 37.51810645 | -88.26873022 | 2022-10-28 04:22:31 | Hardin, Illinois, US | |
541873 | 541873 | 2022-10-26 | US | Texas | Hemphill | 48211 | 1342 | 8 | 0 | 35.83764858 | -100.2703577 | 2022-10-27 04:22:01 | Hemphill, Texas, US | |
539752 | 539752 | 2022-10-26 | US | Illinois | Hardin | 17069 | 1342 | 20 | 0 | 37.51810645 | -88.26873022 | 2022-10-27 04:22:01 | Hardin, Illinois, US | |
1833274 | 1833274 | 2022-10-25 | US | Texas | Hemphill | 48211 | 1342 | 8 | 0 | 35.83764858 | -100.2703577 | 2022-10-26 04:22:19 | Hemphill, Texas, US | |
1831153 | 1831153 | 2022-10-25 | US | Illinois | Hardin | 17069 | 1342 | 20 | 0 | 37.51810645 | -88.26873022 | 2022-10-26 04:22:19 | Hardin, Illinois, US | |
797535 | 797535 | 2022-10-24 | US | Texas | Hemphill | 48211 | 1342 | 8 | 0 | 35.83764858 | -100.2703577 | 2022-10-25 04:21:53 | Hemphill, Texas, US | |
795414 | 795414 | 2022-10-24 | US | Illinois | Hardin | 17069 | 1342 | 20 | 0 | 37.51810645 | -88.26873022 | 2022-10-25 04:21:53 | Hardin, Illinois, US | |
2532552 | 2532552 | 2022-10-06 | US | Texas | Martin | 48317 | 1342 | 26 | 0 | 32.30600051 | -101.9513518 | 2022-10-07 04:23:08 | Martin, Texas, US | |
1813946 | 1813946 | 2022-10-05 | US | Texas | Martin | 48317 | 1342 | 26 | 0 | 32.30600051 | -101.9513518 | 2022-10-06 04:21:22 | Martin, Texas, US | |
373530 | 373530 | 2022-09-13 | US | Kansas | Ottawa | 20143 | 1342 | 23 | 0 | 39.13237408 | -97.65020313 | 2022-09-14 04:20:44 | Ottawa, Kansas, US | |
2396132 | 2396132 | 2022-09-12 | US | Kansas | Ottawa | 20143 | 1342 | 23 | 0 | 39.13237408 | -97.65020313 | 2022-09-13 04:20:57 | Ottawa, Kansas, US | |
3767210 | 3767210 | 2022-09-11 | US | Kansas | Ottawa | 20143 | 1342 | 23 | 0 | 39.13237408 | -97.65020313 | 2022-09-12 04:20:58 | Ottawa, Kansas, US | |
3825785 | 3825785 | 2022-09-10 | US | Kansas | Ottawa | 20143 | 1342 | 23 | 0 | 39.13237408 | -97.65020313 | 2022-09-11 04:20:50 | Ottawa, Kansas, US | |
964242 | 964242 | 2022-09-09 | US | Kansas | Ottawa | 20143 | 1342 | 23 | 0 | 39.13237408 | -97.65020313 | 2022-09-10 04:21:10 | Ottawa, Kansas, US | |
254644 | 254644 | 2022-09-08 | US | Kansas | Ottawa | 20143 | 1342 | 23 | 0 | 39.13237408 | -97.65020313 | 2022-09-09 04:21:11 | Ottawa, Kansas, US | |
3746442 | 3746442 | 2022-09-07 | US | Kansas | Ottawa | 20143 | 1342 | 23 | 0 | 39.13237408 | -97.65020313 | 2022-09-08 04:21:02 | Ottawa, Kansas, US | |
2828602 | 2828602 | 2022-08-25 | China | Gansu | 1342 | 2 | 0 | 35.7518 | 104.2861 | 2022-08-26 04:21:02 | Gansu, China | |||
2323135 | 2323135 | 2022-08-24 | China | Gansu | 1342 | 2 | 0 | 35.7518 | 104.2861 | 2022-08-25 04:21:13 | Gansu, China | |||
1250544 | 1250544 | 2022-08-23 | China | Gansu | 1342 | 2 | 0 | 35.7518 | 104.2861 | 2022-08-24 04:20:46 | Gansu, China | |||
1088941 | 1088941 | 2022-08-09 | US | South Dakota | Day | 46037 | 1342 | 35 | 0 | 45.367281 | -97.60737498 | 2022-08-10 04:20:57 | Day, South Dakota, US | |
3546356 | 3546356 | 2022-08-08 | US | South Dakota | Day | 46037 | 1342 | 35 | 0 | 45.367281 | -97.60737498 | 2022-08-09 04:20:34 | Day, South Dakota, US | |
1072990 | 1072990 | 2022-08-07 | US | Texas | Garza | 48169 | 1342 | 29 | 0 | 33.17969345 | -101.2984114 | 2022-08-08 04:21:08 | Garza, Texas, US | |
1072759 | 1072759 | 2022-08-07 | US | South Dakota | Day | 46037 | 1342 | 35 | 0 | 45.367281 | -97.60737498 | 2022-08-08 04:21:08 | Day, South Dakota, US | |
1943578 | 1943578 | 2022-08-06 | US | Texas | Garza | 48169 | 1342 | 29 | 0 | 33.17969345 | -101.2984114 | 2022-08-07 04:20:54 | Garza, Texas, US | |
1943347 | 1943347 | 2022-08-06 | US | South Dakota | Day | 46037 | 1342 | 35 | 0 | 45.367281 | -97.60737498 | 2022-08-07 04:20:54 | Day, South Dakota, US | |
883377 | 883377 | 2022-08-05 | US | Texas | Garza | 48169 | 1342 | 29 | 0 | 33.17969345 | -101.2984114 | 2022-08-06 04:20:56 | Garza, Texas, US | |
883146 | 883146 | 2022-08-05 | US | South Dakota | Day | 46037 | 1342 | 35 | 0 | 45.367281 | -97.60737498 | 2022-08-06 04:20:56 | Day, South Dakota, US | |
2011557 | 2011557 | 2022-08-04 | US | South Dakota | Day | 46037 | 1342 | 35 | 0 | 45.367281 | -97.60737498 | 2022-08-05 04:20:52 | Day, South Dakota, US | |
1100984 | 1100984 | 2022-08-03 | US | South Dakota | Day | 46037 | 1342 | 35 | 0 | 45.367281 | -97.60737498 | 2022-08-04 04:20:58 | Day, South Dakota, US | |
1488839 | 1488839 | 2022-07-26 | US | Iowa | Wayne | 19185 | 1342 | 33 | 0 | 40.73969028 | -93.32752197 | 2022-07-27 04:21:04 | Wayne, Iowa, US | |
2595285 | 2595285 | 2022-07-25 | US | Iowa | Wayne | 19185 | 1342 | 33 | 0 | 40.73969028 | -93.32752197 | 2022-07-26 04:20:58 | Wayne, Iowa, US | |
897400 | 897400 | 2022-07-24 | US | Iowa | Wayne | 19185 | 1342 | 33 | 0 | 40.73969028 | -93.32752197 | 2022-07-25 04:20:51 | Wayne, Iowa, US | |
92394 | 92394 | 2022-07-23 | US | Iowa | Wayne | 19185 | 1342 | 33 | 0 | 40.73969028 | -93.32752197 | 2022-07-24 04:20:47 | Wayne, Iowa, US | |
901416 | 901416 | 2022-07-22 | US | Iowa | Wayne | 19185 | 1342 | 33 | 0 | 40.73969028 | -93.32752197 | 2022-07-23 04:20:53 | Wayne, Iowa, US | |
671552 | 671552 | 2022-07-21 | US | Iowa | Wayne | 19185 | 1342 | 33 | 0 | 40.73969028 | -93.32752197 | 2022-07-22 04:21:15 | Wayne, Iowa, US | |
1609515 | 1609515 | 2022-07-20 | US | Iowa | Wayne | 19185 | 1342 | 33 | 0 | 40.73969028 | -93.32752197 | 2022-07-21 04:21:10 | Wayne, Iowa, US | |
3429465 | 3429465 | 2022-07-14 | US | Arkansas | Lafayette | 5073 | 1342 | 31 | 0 | 33.24116713 | -93.60677071 | 2022-07-15 04:20:53 | Lafayette, Arkansas, US | |
2790082 | 2790082 | 2022-07-10 | US | Illinois | Scott | 17171 | 1342 | 12 | 0 | 39.6429169 | -90.47814431 | 2022-07-11 04:20:46 | Scott, Illinois, US | |
143035 | 143035 | 2022-07-09 | US | Illinois | Scott | 17171 | 1342 | 12 | 0 | 39.6429169 | -90.47814431 | 2022-07-10 04:20:54 | Scott, Illinois, US | |
1420351 | 1420351 | 2022-07-08 | US | Texas | Yoakum | 48501 | 1342 | 42 | 0 | 33.17320212 | -102.8276433 | 2022-07-09 04:20:59 | Yoakum, Texas, US | |
1418135 | 1418135 | 2022-07-08 | US | Illinois | Scott | 17171 | 1342 | 12 | 0 | 39.6429169 | -90.47814431 | 2022-07-09 04:20:59 | Scott, Illinois, US | |
2744276 | 2744276 | 2022-07-07 | US | Texas | Yoakum | 48501 | 1342 | 42 | 0 | 33.17320212 | -102.8276433 | 2022-07-08 04:20:56 | Yoakum, Texas, US | |
2743001 | 2743001 | 2022-07-07 | US | Montana | Broadwater | 30007 | 1342 | 21 | 0 | 46.33277565 | -111.4955813 | 2022-07-08 04:20:56 | Broadwater, Montana, US | |
1203071 | 1203071 | 2022-07-06 | US | Texas | Yoakum | 48501 | 1342 | 42 | 0 | 33.17320212 | -102.8276433 | 2022-07-07 04:20:55 | Yoakum, Texas, US | |
1201796 | 1201796 | 2022-07-06 | US | Montana | Broadwater | 30007 | 1342 | 21 | 0 | 46.33277565 | -111.4955813 | 2022-07-07 04:20:55 | Broadwater, Montana, US | |
3969814 | 3969814 | 2022-07-05 | US | Texas | Yoakum | 48501 | 1342 | 42 | 0 | 33.17320212 | -102.8276433 | 2022-07-06 04:20:58 | Yoakum, Texas, US | |
3968539 | 3968539 | 2022-07-05 | US | Montana | Broadwater | 30007 | 1342 | 21 | 0 | 46.33277565 | -111.4955813 | 2022-07-06 04:20:58 | Broadwater, Montana, US | |
3081325 | 3081325 | 2022-07-04 | US | Texas | Yoakum | 48501 | 1342 | 42 | 0 | 33.17320212 | -102.8276433 | 2022-07-05 04:20:45 | Yoakum, Texas, US | |
3080050 | 3080050 | 2022-07-04 | US | Montana | Broadwater | 30007 | 1342 | 21 | 0 | 46.33277565 | -111.4955813 | 2022-07-05 04:20:45 | Broadwater, Montana, US | |
1770607 | 1770607 | 2022-07-03 | US | Texas | Yoakum | 48501 | 1342 | 42 | 0 | 33.17320212 | -102.8276433 | 2022-07-04 04:20:54 | Yoakum, Texas, US | |
1769332 | 1769332 | 2022-07-03 | US | Montana | Broadwater | 30007 | 1342 | 21 | 0 | 46.33277565 | -111.4955813 | 2022-07-04 04:20:54 | Broadwater, Montana, US | |
3368593 | 3368593 | 2022-07-02 | US | Texas | Yoakum | 48501 | 1342 | 42 | 0 | 33.17320212 | -102.8276433 | 2022-07-03 04:20:59 | Yoakum, Texas, US | |
3367318 | 3367318 | 2022-07-02 | US | Montana | Broadwater | 30007 | 1342 | 21 | 0 | 46.33277565 | -111.4955813 | 2022-07-03 04:20:59 | Broadwater, Montana, US | |
596922 | 596922 | 2022-07-01 | US | Texas | Yoakum | 48501 | 1342 | 42 | 0 | 33.17320212 | -102.8276433 | 2022-07-02 04:21:16 | Yoakum, Texas, US | |
595647 | 595647 | 2022-07-01 | US | Montana | Broadwater | 30007 | 1342 | 21 | 0 | 46.33277565 | -111.4955813 | 2022-07-02 04:21:16 | Broadwater, Montana, US | |
3943323 | 3943323 | 2022-06-30 | US | Texas | Yoakum | 48501 | 1342 | 42 | 0 | 33.17320212 | -102.8276433 | 2022-07-01 04:21:10 | Yoakum, Texas, US | |
2493281 | 2493281 | 2022-06-29 | US | Texas | Yoakum | 48501 | 1342 | 42 | 0 | 33.17320212 | -102.8276433 | 2022-06-30 04:21:01 | Yoakum, Texas, US | |
2242663 | 2242663 | 2022-06-28 | US | Texas | Yoakum | 48501 | 1342 | 42 | 0 | 33.17320212 | -102.8276433 | 2022-06-29 04:20:59 | Yoakum, Texas, US | |
2150905 | 2150905 | 2022-06-27 | US | Texas | Yoakum | 48501 | 1342 | 42 | 0 | 33.17320212 | -102.8276433 | 2022-06-28 04:20:58 | Yoakum, Texas, US | |
941989 | 941989 | 2022-06-25 | US | Texas | McCulloch | 48307 | 1342 | 47 | 0 | 31.1925468 | -99.34682807 | 2022-06-26 04:21:02 | McCulloch, Texas, US | |
3582012 | 3582012 | 2022-06-02 | US | Virginia | Norton | 51720 | 1342 | 22 | 0 | 36.93357076 | -82.62750411 | 2022-06-03 04:20:58 | Norton, Virginia, US | |
1316305 | 1316305 | 2022-05-27 | US | Nebraska | Nemaha | 31127 | 1342 | 20 | 0 | 40.38514847 | -95.85433992 | 2022-05-28 04:21:07 | Nemaha, Nebraska, US | |
1852097 | 1852097 | 2022-05-26 | US | Nebraska | Nemaha | 31127 | 1342 | 20 | 0 | 40.38514847 | -95.85433992 | 2022-05-27 04:20:56 | Nemaha, Nebraska, US | |
2049973 | 2049973 | 2022-05-25 | US | Nebraska | Nemaha | 31127 | 1342 | 20 | 0 | 40.38514847 | -95.85433992 | 2022-05-26 04:20:50 | Nemaha, Nebraska, US | |
623984 | 623984 | 2022-05-22 | US | Nebraska | Nemaha | 31127 | 1342 | 20 | 0 | 40.38514847 | -95.85433992 | 2022-05-26 04:20:50 | Nemaha, Nebraska, US | |
3583409 | 3583409 | 2022-05-17 | US | Georgia | Calhoun | 13037 | 1342 | 22 | 0 | 31.53169785 | -84.62725131 | 2022-05-18 04:20:50 | Calhoun, Georgia, US | |
1504366 | 1504366 | 2022-05-16 | US | Georgia | Calhoun | 13037 | 1342 | 22 | 0 | 31.53169785 | -84.62725131 | 2022-05-17 04:20:59 | Calhoun, Georgia, US | |
2086387 | 2086387 | 2022-05-15 | US | North Dakota | Sioux | 38085 | 1342 | 19 | 0 | 46.11323337 | -101.0440149 | 2022-05-16 04:20:47 | Sioux, North Dakota, US | |
2084725 | 2084725 | 2022-05-15 | US | Georgia | Calhoun | 13037 | 1342 | 22 | 0 | 31.53169785 | -84.62725131 | 2022-05-16 04:20:47 | Calhoun, Georgia, US | |
3357097 | 3357097 | 2022-05-14 | US | North Dakota | Sioux | 38085 | 1342 | 19 | 0 | 46.11323337 | -101.0440149 | 2022-05-15 04:20:53 | Sioux, North Dakota, US | |
3355435 | 3355435 | 2022-05-14 | US | Georgia | Calhoun | 13037 | 1342 | 22 | 0 | 31.53169785 | -84.62725131 | 2022-05-15 04:20:53 | Calhoun, Georgia, US | |
660742 | 660742 | 2022-05-13 | US | North Dakota | Sioux | 38085 | 1342 | 19 | 0 | 46.11323337 | -101.0440149 | 2022-05-14 04:20:48 | Sioux, North Dakota, 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]);