johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,115 rows where confirmed = 219 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3100589 | 3100589 | 2022-10-09 | US | Texas | Kent | 48263 | 219 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-10-10 04:22:32 | Kent, Texas, US | |
4005814 | 4005814 | 2022-10-08 | US | Texas | Kent | 48263 | 219 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-10-09 04:21:16 | Kent, Texas, US | |
399411 | 399411 | 2022-10-07 | US | Texas | Kent | 48263 | 219 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-10-08 04:22:56 | Kent, Texas, US | |
114556 | 114556 | 2022-09-06 | China | Qinghai | 219 | 0 | 0 | 35.7452 | 95.9956 | 2022-09-07 04:20:59 | Qinghai, China | |||
1880085 | 1880085 | 2022-08-28 | US | Texas | Glasscock | 48173 | 219 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-08-29 04:21:06 | Glasscock, Texas, US | |
2099212 | 2099212 | 2022-08-27 | US | Texas | Glasscock | 48173 | 219 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-08-28 04:21:02 | Glasscock, Texas, US | |
1535027 | 1535027 | 2022-08-26 | US | Texas | Glasscock | 48173 | 219 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-08-27 04:20:57 | Glasscock, Texas, US | |
2831914 | 2831914 | 2022-08-25 | US | Texas | Glasscock | 48173 | 219 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-08-26 04:21:02 | Glasscock, Texas, US | |
2326447 | 2326447 | 2022-08-24 | US | Texas | Glasscock | 48173 | 219 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-08-25 04:21:13 | Glasscock, Texas, US | |
1253856 | 1253856 | 2022-08-23 | US | Texas | Glasscock | 48173 | 219 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-08-24 04:20:46 | Glasscock, Texas, US | |
2855960 | 2855960 | 2022-08-22 | US | Texas | Glasscock | 48173 | 219 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-08-23 04:20:56 | Glasscock, Texas, US | |
1420177 | 1420177 | 2022-07-08 | US | Texas | Foard | 48155 | 219 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-07-09 04:20:59 | Foard, Texas, US | |
971576 | 971576 | 2022-06-01 | US | Colorado | San Juan | 8111 | 219 | 0 | 0 | 37.76248981 | -107.6763289 | 2022-06-02 05:20:39 | San Juan, Colorado, US | |
3585381 | 3585381 | 2022-05-17 | US | Puerto Rico | Culebra | 72049 | 219 | 0 | 0 | 18.31586 | -65.28813 | 2022-05-18 04:20:50 | Culebra, Puerto Rico, US | |
2321339 | 2321339 | 2022-03-16 | US | Montana | Judith Basin | 30045 | 219 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-03-17 04:20:56 | Judith Basin, Montana, US | |
263539 | 263539 | 2022-03-15 | US | Montana | Judith Basin | 30045 | 219 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-03-16 04:20:50 | Judith Basin, Montana, US | |
2265898 | 2265898 | 2022-03-14 | US | Montana | Judith Basin | 30045 | 219 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-03-15 04:20:47 | Judith Basin, Montana, US | |
3629964 | 3629964 | 2022-03-13 | US | Montana | Judith Basin | 30045 | 219 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-03-14 04:20:46 | Judith Basin, Montana, US | |
952872 | 952872 | 2022-03-12 | US | Montana | Judith Basin | 30045 | 219 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-03-13 04:20:49 | Judith Basin, Montana, US | |
358333 | 358333 | 2022-03-11 | US | Montana | Judith Basin | 30045 | 219 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-03-12 04:20:50 | Judith Basin, Montana, US | |
1867485 | 1867485 | 2022-03-10 | US | Montana | Judith Basin | 30045 | 219 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-03-11 04:20:50 | Judith Basin, Montana, US | |
2142180 | 2142180 | 2022-03-09 | US | Montana | Judith Basin | 30045 | 219 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-03-10 04:20:48 | Judith Basin, Montana, US | |
921691 | 921691 | 2022-03-08 | US | Montana | Judith Basin | 30045 | 219 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-03-09 04:20:59 | Judith Basin, Montana, US | |
1549978 | 1549978 | 2022-03-07 | US | Montana | Judith Basin | 30045 | 219 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-03-08 04:20:54 | Judith Basin, Montana, US | |
2201647 | 2201647 | 2022-03-06 | US | Montana | Judith Basin | 30045 | 219 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-03-07 04:20:47 | Judith Basin, Montana, US | |
2094104 | 2094104 | 2022-03-05 | US | Montana | Judith Basin | 30045 | 219 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-03-06 04:20:49 | Judith Basin, Montana, US | |
2667804 | 2667804 | 2022-03-04 | US | Montana | Judith Basin | 30045 | 219 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-03-05 04:21:10 | Judith Basin, Montana, US | |
1646369 | 1646369 | 2022-03-03 | US | Montana | Judith Basin | 30045 | 219 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-03-04 04:21:09 | Judith Basin, Montana, US | |
2527372 | 2527372 | 2022-03-02 | US | Montana | Judith Basin | 30045 | 219 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-03-03 04:21:01 | Judith Basin, Montana, US | |
1994666 | 1994666 | 2022-03-01 | US | Montana | Judith Basin | 30045 | 219 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-03-02 04:21:07 | Judith Basin, Montana, US | |
944840 | 944840 | 2022-02-28 | US | Montana | Judith Basin | 30045 | 219 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-03-01 04:21:09 | Judith Basin, Montana, US | |
2735031 | 2735031 | 2022-02-27 | US | Montana | Judith Basin | 30045 | 219 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-02-28 04:21:05 | Judith Basin, Montana, US | |
3048184 | 3048184 | 2022-02-26 | US | Montana | Judith Basin | 30045 | 219 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-02-27 04:21:04 | Judith Basin, Montana, US | |
576839 | 576839 | 2022-02-25 | US | Montana | Judith Basin | 30045 | 219 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-02-26 04:21:12 | Judith Basin, Montana, US | |
1513415 | 1513415 | 2022-02-24 | US | Montana | Judith Basin | 30045 | 219 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-02-25 04:21:11 | Judith Basin, Montana, US | |
1059856 | 1059856 | 2022-02-23 | US | Montana | Judith Basin | 30045 | 219 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-02-24 04:21:14 | Judith Basin, Montana, US | |
2448779 | 2448779 | 2022-02-22 | US | Montana | Judith Basin | 30045 | 219 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-02-23 04:21:09 | Judith Basin, Montana, US | |
1301185 | 1301185 | 2022-02-17 | US | Texas | Jeff Davis | 48243 | 219 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-02-18 04:21:04 | Jeff Davis, Texas, US | |
3823571 | 3823571 | 2022-02-16 | US | Texas | Jeff Davis | 48243 | 219 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-02-17 04:20:56 | Jeff Davis, Texas, US | |
2643754 | 2643754 | 2022-02-14 | US | Montana | Garfield | 30033 | 219 | 3 | 0 | 47.27545948 | -107.0002351 | 2022-02-15 04:21:09 | Garfield, Montana, US | |
188071 | 188071 | 2022-02-13 | US | Montana | Garfield | 30033 | 219 | 3 | 0 | 47.27545948 | -107.0002351 | 2022-02-14 04:20:51 | Garfield, Montana, US | |
317917 | 317917 | 2022-02-12 | US | Montana | Garfield | 30033 | 219 | 3 | 0 | 47.27545948 | -107.0002351 | 2022-02-13 04:21:00 | Garfield, Montana, US | |
235243 | 235243 | 2022-02-11 | US | Montana | Garfield | 30033 | 219 | 3 | 0 | 47.27545948 | -107.0002351 | 2022-02-12 04:21:06 | Garfield, Montana, US | |
1466085 | 1466085 | 2022-02-10 | US | Montana | Garfield | 30033 | 219 | 3 | 0 | 47.27545948 | -107.0002351 | 2022-02-11 04:21:09 | Garfield, Montana, US | |
1229603 | 1229603 | 2022-01-24 | US | Montana | Carter | 30011 | 219 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2022-01-25 04:21:05 | Carter, Montana, US | |
1142902 | 1142902 | 2022-01-23 | US | Montana | Carter | 30011 | 219 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2022-01-24 04:21:12 | Carter, Montana, US | |
2834820 | 2834820 | 2022-01-22 | US | Montana | Carter | 30011 | 219 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2022-01-23 04:21:13 | Carter, Montana, US | |
3426938 | 3426938 | 2022-01-21 | US | Montana | Carter | 30011 | 219 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2022-01-22 04:21:13 | Carter, Montana, US | |
1962546 | 1962546 | 2022-01-20 | US | Montana | Carter | 30011 | 219 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2022-01-21 04:21:09 | Carter, Montana, US | |
3228475 | 3228475 | 2022-01-19 | US | Montana | Prairie | 30079 | 219 | 3 | 0 | 46.86048047 | -105.379384 | 2022-01-20 04:21:07 | Prairie, Montana, US | |
4001834 | 4001834 | 2021-12-30 | US | Texas | Motley | 48345 | 219 | 9 | 0 | 34.07408766 | -100.77972199999999 | 2021-12-31 04:21:50 | Motley, Texas, US | |
2907072 | 2907072 | 2021-12-19 | US | Virginia | Highland | 51091 | 219 | 4 | 0 | 38.35799465 | -79.56124594 | 2021-12-20 04:21:43 | Highland, Virginia, US | |
1262145 | 1262145 | 2021-12-18 | US | Virginia | Highland | 51091 | 219 | 4 | 0 | 38.35799465 | -79.56124594 | 2021-12-19 04:21:11 | Highland, Virginia, US | |
2402173 | 2402173 | 2021-12-17 | US | Virginia | Highland | 51091 | 219 | 4 | 0 | 38.35799465 | -79.56124594 | 2021-12-18 02:22:20 | Highland, Virginia, US | |
1719235 | 1719235 | 2021-12-16 | US | South Dakota | Hyde | 46069 | 219 | 5 | 0 | 44.54747703 | -99.48572582 | 2021-12-17 04:22:14 | Hyde, South Dakota, US | |
1717663 | 1717663 | 2021-12-16 | US | Kansas | Lane | 20101 | 219 | 8 | 0 | 38.48119447 | -100.46607540000001 | 2021-12-17 04:22:14 | Lane, Kansas, US | |
3499069 | 3499069 | 2021-12-15 | US | South Dakota | Hyde | 46069 | 219 | 5 | 0 | 44.54747703 | -99.48572582 | 2021-12-16 04:22:11 | Hyde, South Dakota, US | |
3497497 | 3497497 | 2021-12-15 | US | Kansas | Lane | 20101 | 219 | 8 | 0 | 38.48119447 | -100.46607540000001 | 2021-12-16 04:22:11 | Lane, Kansas, US | |
1663306 | 1663306 | 2021-12-12 | US | South Dakota | Hyde | 46069 | 219 | 5 | 0 | 44.54747703 | -99.48572582 | 2021-12-13 04:22:02 | Hyde, South Dakota, US | |
1667322 | 1667322 | 2021-12-11 | US | South Dakota | Hyde | 46069 | 219 | 5 | 0 | 44.54747703 | -99.48572582 | 2021-12-12 04:22:12 | Hyde, South Dakota, US | |
3658474 | 3658474 | 2021-12-10 | US | South Dakota | Hyde | 46069 | 219 | 5 | 0 | 44.54747703 | -99.48572582 | 2021-12-11 04:22:45 | Hyde, South Dakota, US | |
1080805 | 1080805 | 2021-12-09 | US | South Dakota | Hyde | 46069 | 219 | 5 | 0 | 44.54747703 | -99.48572582 | 2021-12-10 04:22:28 | Hyde, South Dakota, US | |
1030960 | 1030960 | 2021-12-06 | US | California | Sierra | 6091 | 219 | 0 | 0 | 39.57713498 | -120.52007009999998 | 2021-12-07 04:22:34 | Sierra, California, US | |
1741123 | 1741123 | 2021-12-05 | US | California | Sierra | 6091 | 219 | 0 | 0 | 39.57713498 | -120.52007009999998 | 2021-12-06 04:22:34 | Sierra, California, US | |
2289874 | 2289874 | 2021-11-15 | US | North Dakota | Oliver | 38065 | 219 | 3 | 0 | 47.11530482 | -101.3406158 | 2021-11-16 04:21:10 | Oliver, North Dakota, US | |
2002736 | 2002736 | 2021-11-07 | US | Nebraska | Garden | 31069 | 219 | 1 | 0 | 41.61703149 | -102.3313973 | 2021-11-08 04:21:43 | Garden, Nebraska, US | |
497727 | 497727 | 2021-11-06 | US | Nebraska | Garden | 31069 | 219 | 1 | 0 | 41.61703149 | -102.3313973 | 2021-11-07 04:21:53 | Garden, Nebraska, US | |
3123582 | 3123582 | 2021-11-05 | US | Nebraska | Garden | 31069 | 219 | 1 | 0 | 41.61703149 | -102.3313973 | 2021-11-06 04:21:51 | Garden, Nebraska, US | |
700480 | 700480 | 2021-11-04 | US | Nebraska | Garden | 31069 | 219 | 1 | 0 | 41.61703149 | -102.3313973 | 2021-11-05 04:21:54 | Garden, Nebraska, US | |
278258 | 278258 | 2021-11-03 | US | Nebraska | Garden | 31069 | 219 | 1 | 0 | 41.61703149 | -102.3313973 | 2021-11-04 04:22:20 | Garden, Nebraska, US | |
2459215 | 2459215 | 2021-10-06 | US | Alaska | Haines | 2100 | 219 | 0 | 0 | 59.09893571 | -135.4679843 | 2021-10-07 04:21:36 | Haines, Alaska, US | |
3833843 | 3833843 | 2021-10-05 | US | Kansas | Wallace | 20199 | 219 | 4 | 0 | 38.91686134 | -101.76388759999999 | 2021-10-06 04:21:33 | Wallace, Kansas, US | |
988336 | 988336 | 2021-10-04 | US | Kansas | Wallace | 20199 | 219 | 4 | 0 | 38.91686134 | -101.76388759999999 | 2021-10-05 04:21:27 | Wallace, Kansas, US | |
1275646 | 1275646 | 2021-10-03 | US | Kansas | Wallace | 20199 | 219 | 4 | 0 | 38.91686134 | -101.76388759999999 | 2021-10-04 04:21:31 | Wallace, Kansas, US | |
3929399 | 3929399 | 2021-10-02 | US | Kansas | Wallace | 20199 | 219 | 4 | 0 | 38.91686134 | -101.76388759999999 | 2021-10-03 04:21:24 | Wallace, Kansas, US | |
2133379 | 2133379 | 2021-10-01 | US | Kansas | Wallace | 20199 | 219 | 4 | 0 | 38.91686134 | -101.76388759999999 | 2021-10-02 04:21:25 | Wallace, Kansas, US | |
2774688 | 2774688 | 2021-09-30 | US | Minnesota | Cook | 27031 | 219 | 0 | 0 | 47.90504893 | -90.52629546 | 2021-10-01 04:21:35 | Cook, Minnesota, US | |
708510 | 708510 | 2021-09-29 | US | Nebraska | Gosper | 31073 | 219 | 5 | 0 | 40.51481965 | -99.83020279 | 2021-09-30 04:21:20 | Gosper, Nebraska, US | |
1237692 | 1237692 | 2021-09-27 | US | Nebraska | Boyd | 31015 | 219 | 3 | 0 | 42.899727399999996 | -98.76486568 | 2021-09-28 04:21:28 | Boyd, Nebraska, US | |
2078137 | 2078137 | 2021-09-26 | US | New Mexico | De Baca | 35011 | 219 | 3 | 0 | 34.34274529 | -104.4117842 | 2021-09-27 04:21:16 | De Baca, New Mexico, US | |
2077993 | 2077993 | 2021-09-26 | US | Nebraska | Boyd | 31015 | 219 | 3 | 0 | 42.899727399999996 | -98.76486568 | 2021-09-27 04:21:16 | Boyd, Nebraska, US | |
1726689 | 1726689 | 2021-09-25 | US | New Mexico | De Baca | 35011 | 219 | 3 | 0 | 34.34274529 | -104.4117842 | 2021-09-26 04:21:29 | De Baca, New Mexico, US | |
1726545 | 1726545 | 2021-09-25 | US | Nebraska | Boyd | 31015 | 219 | 3 | 0 | 42.899727399999996 | -98.76486568 | 2021-09-26 04:21:29 | Boyd, Nebraska, US | |
1923409 | 1923409 | 2021-09-24 | US | New Mexico | De Baca | 35011 | 219 | 3 | 0 | 34.34274529 | -104.4117842 | 2021-09-25 04:21:31 | De Baca, New Mexico, US | |
1923299 | 1923299 | 2021-09-24 | US | Nebraska | Harlan | 31083 | 219 | 0 | 0 | 40.17658508 | -99.40438879 | 2021-09-25 04:21:31 | Harlan, Nebraska, US | |
603770 | 603770 | 2021-09-23 | US | Nebraska | Harlan | 31083 | 219 | 0 | 0 | 40.17658508 | -99.40438879 | 2021-09-24 04:21:44 | Harlan, Nebraska, US | |
3013414 | 3013414 | 2021-09-22 | US | Nebraska | Harlan | 31083 | 219 | 0 | 0 | 40.17658508 | -99.40438879 | 2021-09-23 04:21:43 | Harlan, Nebraska, US | |
3013325 | 3013325 | 2021-09-22 | US | Montana | Daniels | 30019 | 219 | 9 | 0 | 48.78420029 | -105.54763429999998 | 2021-09-23 04:21:43 | Daniels, Montana, US | |
3759552 | 3759552 | 2021-09-21 | US | Nebraska | Harlan | 31083 | 219 | 0 | 0 | 40.17658508 | -99.40438879 | 2021-09-22 04:21:45 | Harlan, Nebraska, US | |
811655 | 811655 | 2021-09-20 | US | Nebraska | Harlan | 31083 | 219 | 0 | 0 | 40.17658508 | -99.40438879 | 2021-09-21 04:21:26 | Harlan, Nebraska, US | |
1816854 | 1816854 | 2021-09-19 | US | Nebraska | Harlan | 31083 | 219 | 0 | 0 | 40.17658508 | -99.40438879 | 2021-09-20 04:21:22 | Harlan, Nebraska, US | |
18434 | 18434 | 2021-09-18 | US | Nebraska | Harlan | 31083 | 219 | 0 | 0 | 40.17658508 | -99.40438879 | 2021-09-19 04:21:34 | Harlan, Nebraska, US | |
2620119 | 2620119 | 2021-09-17 | US | Nebraska | Harlan | 31083 | 219 | 0 | 0 | 40.17658508 | -99.40438879 | 2021-09-18 04:21:24 | Harlan, Nebraska, US | |
2810827 | 2810827 | 2021-09-16 | US | Nebraska | Harlan | 31083 | 219 | 0 | 0 | 40.17658508 | -99.40438879 | 2021-09-17 04:21:46 | Harlan, Nebraska, US | |
2809645 | 2809645 | 2021-09-16 | US | Georgia | Webster | 13307 | 219 | 4 | 0 | 32.04066113 | -84.54742852 | 2021-09-17 04:21:46 | Webster, Georgia, US | |
1376571 | 1376571 | 2021-09-15 | US | Nebraska | Harlan | 31083 | 219 | 0 | 0 | 40.17658508 | -99.40438879 | 2021-09-16 04:22:19 | Harlan, Nebraska, US | |
1375389 | 1375389 | 2021-09-15 | US | Georgia | Webster | 13307 | 219 | 4 | 0 | 32.04066113 | -84.54742852 | 2021-09-16 04:22:19 | Webster, Georgia, US | |
2464870 | 2464870 | 2021-09-14 | US | Nebraska | Harlan | 31083 | 219 | 0 | 0 | 40.17658508 | -99.40438879 | 2021-09-15 03:22:37 | Harlan, Nebraska, US | |
1387709 | 1387709 | 2021-09-13 | US | Nebraska | Harlan | 31083 | 219 | 0 | 0 | 40.17658508 | -99.40438879 | 2021-09-14 04:21:41 | Harlan, Nebraska, US | |
1386063 | 1386063 | 2021-09-13 | US | Alaska | Petersburg | 2195 | 219 | 2 | 0 | 57.13978948 | -132.9540995 | 2021-09-14 04:21:41 | Petersburg, Alaska, 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]);