johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
320 rows where confirmed = 1976 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2415391 | 2415391 | 2022-12-05 | US | Arkansas | Newton | 5101 | 1976 | 51 | 0 | 35.91947491 | -93.21612969 | 2022-12-06 04:21:03 | Newton, Arkansas, US | |
3552692 | 3552692 | 2022-11-27 | US | Illinois | Pulaski | 17153 | 1976 | 24 | 0 | 37.22631423 | -89.13085001 | 2022-11-28 04:21:02 | Pulaski, Illinois, US | |
2101172 | 2101172 | 2022-11-26 | US | Illinois | Pulaski | 17153 | 1976 | 24 | 0 | 37.22631423 | -89.13085001 | 2022-11-27 04:21:05 | Pulaski, Illinois, US | |
488663 | 488663 | 2022-11-25 | US | Illinois | Pulaski | 17153 | 1976 | 24 | 0 | 37.22631423 | -89.13085001 | 2022-11-26 04:21:11 | Pulaski, Illinois, US | |
3524492 | 3524492 | 2022-11-24 | US | Illinois | Pulaski | 17153 | 1976 | 24 | 0 | 37.22631423 | -89.13085001 | 2022-11-25 04:21:06 | Pulaski, Illinois, US | |
3314780 | 3314780 | 2022-11-23 | US | Oklahoma | Coal | 40029 | 1976 | 25 | 0 | 34.58840127 | -96.29798747 | 2022-11-24 04:21:09 | Coal, Oklahoma, US | |
3313275 | 3313275 | 2022-11-23 | US | Illinois | Pulaski | 17153 | 1976 | 24 | 0 | 37.22631423 | -89.13085001 | 2022-11-24 04:21:09 | Pulaski, Illinois, US | |
1622821 | 1622821 | 2022-11-22 | US | Oklahoma | Coal | 40029 | 1976 | 25 | 0 | 34.58840127 | -96.29798747 | 2022-11-23 04:21:06 | Coal, Oklahoma, US | |
3462709 | 3462709 | 2022-11-21 | US | Oklahoma | Coal | 40029 | 1976 | 25 | 0 | 34.58840127 | -96.29798747 | 2022-11-22 04:20:47 | Coal, Oklahoma, US | |
1642894 | 1642894 | 2022-11-20 | US | Oklahoma | Coal | 40029 | 1976 | 25 | 0 | 34.58840127 | -96.29798747 | 2022-11-21 04:21:05 | Coal, Oklahoma, US | |
2066451 | 2066451 | 2022-11-19 | US | Oklahoma | Coal | 40029 | 1976 | 25 | 0 | 34.58840127 | -96.29798747 | 2022-11-20 04:21:08 | Coal, Oklahoma, US | |
1757845 | 1757845 | 2022-11-18 | US | Oklahoma | Coal | 40029 | 1976 | 25 | 0 | 34.58840127 | -96.29798747 | 2022-11-19 04:21:14 | Coal, Oklahoma, US | |
3028838 | 3028838 | 2022-11-17 | US | Oklahoma | Coal | 40029 | 1976 | 25 | 0 | 34.58840127 | -96.29798747 | 2022-11-18 04:21:15 | Coal, Oklahoma, US | |
482629 | 482629 | 2022-11-08 | US | Texas | Brooks | 48047 | 1976 | 52 | 0 | 27.03103197 | -98.21808402 | 2022-11-09 04:21:22 | Brooks, Texas, US | |
2441779 | 2441779 | 2022-11-07 | US | Texas | Brooks | 48047 | 1976 | 52 | 0 | 27.03103197 | -98.21808402 | 2022-11-08 04:21:21 | Brooks, Texas, US | |
2262839 | 2262839 | 2022-10-02 | US | Texas | Delta | 48119 | 1976 | 27 | 0 | 33.38570922 | -95.66921122 | 2022-10-03 04:23:11 | Delta, Texas, US | |
2998365 | 2998365 | 2022-10-01 | US | Texas | Delta | 48119 | 1976 | 27 | 0 | 33.38570922 | -95.66921122 | 2022-10-02 04:21:23 | Delta, Texas, US | |
856691 | 856691 | 2022-09-30 | US | Texas | Delta | 48119 | 1976 | 27 | 0 | 33.38570922 | -95.66921122 | 2022-10-01 04:23:01 | Delta, Texas, US | |
2378617 | 2378617 | 2022-09-29 | US | Texas | Delta | 48119 | 1976 | 27 | 0 | 33.38570922 | -95.66921122 | 2022-09-30 04:23:09 | Delta, Texas, US | |
2854549 | 2854549 | 2022-08-22 | US | Michigan | Schoolcraft | 26153 | 1976 | 16 | 0 | 46.19235734 | -86.19972234 | 2022-08-23 04:20:56 | Schoolcraft, Michigan, US | |
2404521 | 2404521 | 2022-08-21 | US | Michigan | Schoolcraft | 26153 | 1976 | 16 | 0 | 46.19235734 | -86.19972234 | 2022-08-22 04:20:38 | Schoolcraft, Michigan, US | |
3799599 | 3799599 | 2022-08-20 | US | Michigan | Schoolcraft | 26153 | 1976 | 16 | 0 | 46.19235734 | -86.19972234 | 2022-08-21 04:20:44 | Schoolcraft, Michigan, US | |
2365185 | 2365185 | 2022-08-19 | US | Michigan | Schoolcraft | 26153 | 1976 | 16 | 0 | 46.19235734 | -86.19972234 | 2022-08-20 04:21:01 | Schoolcraft, Michigan, US | |
1162856 | 1162856 | 2022-08-18 | US | Michigan | Schoolcraft | 26153 | 1976 | 16 | 0 | 46.19235734 | -86.19972234 | 2022-08-19 04:20:54 | Schoolcraft, Michigan, US | |
3952180 | 3952180 | 2022-08-17 | US | Michigan | Schoolcraft | 26153 | 1976 | 16 | 0 | 46.19235734 | -86.19972234 | 2022-08-18 04:21:11 | Schoolcraft, Michigan, US | |
3951145 | 3951145 | 2022-08-17 | US | Colorado | Rio Blanco | 8103 | 1976 | 13 | 0 | 39.97913541 | -108.2179009 | 2022-08-18 04:21:11 | Rio Blanco, Colorado, US | |
992682 | 992682 | 2022-08-16 | US | Michigan | Schoolcraft | 26153 | 1976 | 16 | 0 | 46.19235734 | -86.19972234 | 2022-08-17 04:20:59 | Schoolcraft, Michigan, US | |
2497260 | 2497260 | 2022-08-15 | US | Texas | Stephens | 48429 | 1976 | 49 | 0 | 32.73553157 | -98.83631615 | 2022-08-16 04:20:58 | Stephens, Texas, US | |
1408223 | 1408223 | 2022-08-02 | US | Texas | Mitchell | 48335 | 1976 | 49 | 0 | 32.30623474 | -100.9212058 | 2022-08-03 04:20:59 | Mitchell, Texas, US | |
94207 | 94207 | 2022-07-23 | US | Texas | Crosby | 48107 | 1976 | 45 | 0 | 33.61431553 | -101.3000364 | 2022-07-24 04:20:47 | Crosby, Texas, US | |
2490628 | 2490628 | 2022-06-29 | US | Colorado | Conejos | 8021 | 1976 | 57 | 0 | 37.201606 | -106.1917488 | 2022-06-30 04:21:01 | Conejos, Colorado, US | |
2240735 | 2240735 | 2022-06-28 | US | Kansas | Pratt | 20151 | 1976 | 34 | 0 | 37.64780729 | -98.73922153 | 2022-06-29 04:20:59 | Pratt, Kansas, US | |
2148977 | 2148977 | 2022-06-27 | US | Kansas | Pratt | 20151 | 1976 | 34 | 0 | 37.64780729 | -98.73922153 | 2022-06-28 04:20:58 | Pratt, Kansas, US | |
476778 | 476778 | 2022-06-26 | US | Kansas | Pratt | 20151 | 1976 | 34 | 0 | 37.64780729 | -98.73922153 | 2022-06-27 04:21:00 | Pratt, Kansas, US | |
940153 | 940153 | 2022-06-25 | US | Kansas | Pratt | 20151 | 1976 | 34 | 0 | 37.64780729 | -98.73922153 | 2022-06-26 04:21:02 | Pratt, Kansas, US | |
3347973 | 3347973 | 2022-06-24 | US | Kansas | Pratt | 20151 | 1976 | 34 | 0 | 37.64780729 | -98.73922153 | 2022-06-25 04:20:57 | Pratt, Kansas, US | |
3347148 | 3347148 | 2022-06-24 | US | Arkansas | Monroe | 5095 | 1976 | 36 | 0 | 34.6815935 | -91.20540287 | 2022-06-25 04:20:57 | Monroe, Arkansas, US | |
1649714 | 1649714 | 2022-06-23 | US | Kansas | Pratt | 20151 | 1976 | 34 | 0 | 37.64780729 | -98.73922153 | 2022-06-24 04:20:58 | Pratt, Kansas, US | |
1648889 | 1648889 | 2022-06-23 | US | Arkansas | Monroe | 5095 | 1976 | 36 | 0 | 34.6815935 | -91.20540287 | 2022-06-24 04:20:58 | Monroe, Arkansas, US | |
2188949 | 2188949 | 2022-06-22 | US | Kansas | Pratt | 20151 | 1976 | 34 | 0 | 37.64780729 | -98.73922153 | 2022-06-23 04:20:55 | Pratt, Kansas, US | |
1766945 | 1766945 | 2022-06-20 | US | Wyoming | Sublette | 56035 | 1976 | 27 | 0 | 42.76558279 | -109.9130922 | 2022-06-21 04:20:56 | Sublette, Wyoming, US | |
3273131 | 3273131 | 2022-06-19 | US | Wyoming | Sublette | 56035 | 1976 | 27 | 0 | 42.76558279 | -109.9130922 | 2022-06-20 04:21:01 | Sublette, Wyoming, US | |
3401043 | 3401043 | 2022-06-18 | US | Wyoming | Sublette | 56035 | 1976 | 27 | 0 | 42.76558279 | -109.9130922 | 2022-06-19 04:20:51 | Sublette, Wyoming, US | |
2314920 | 2314920 | 2022-06-17 | US | Wyoming | Sublette | 56035 | 1976 | 27 | 0 | 42.76558279 | -109.9130922 | 2022-06-18 04:21:10 | Sublette, Wyoming, US | |
562424 | 562424 | 2022-06-16 | US | Wyoming | Sublette | 56035 | 1976 | 27 | 0 | 42.76558279 | -109.9130922 | 2022-06-17 04:20:56 | Sublette, Wyoming, US | |
3986226 | 3986226 | 2022-06-15 | US | Wyoming | Sublette | 56035 | 1976 | 27 | 0 | 42.76558279 | -109.9130922 | 2022-06-16 04:20:55 | Sublette, Wyoming, US | |
950467 | 950467 | 2022-06-14 | US | Wyoming | Sublette | 56035 | 1976 | 27 | 0 | 42.76558279 | -109.9130922 | 2022-06-15 04:20:54 | Sublette, Wyoming, US | |
1947606 | 1947606 | 2022-06-10 | US | Texas | Hamilton | 48193 | 1976 | 33 | 0 | 31.70470573 | -98.11083887 | 2022-06-11 04:21:01 | Hamilton, Texas, US | |
3160745 | 3160745 | 2022-06-09 | US | Texas | Hamilton | 48193 | 1976 | 33 | 0 | 31.70470573 | -98.11083887 | 2022-06-10 04:20:55 | Hamilton, Texas, US | |
3448409 | 3448409 | 2022-05-11 | US | Wisconsin | Menominee | 55078 | 1976 | 14 | 0 | 45.00422544 | -88.70950714 | 2022-05-12 04:20:54 | Menominee, Wisconsin, US | |
1575642 | 1575642 | 2022-05-03 | US | West Virginia | Pendleton | 54071 | 1976 | 22 | 0 | 38.68314479 | -79.35084086 | 2022-05-04 04:20:59 | Pendleton, West Virginia, US | |
3854236 | 3854236 | 2022-04-27 | US | North Dakota | Pembina | 38067 | 1976 | 16 | 0 | 48.76623521 | -97.5523809 | 2022-04-28 04:20:47 | Pembina, North Dakota, US | |
1328666 | 1328666 | 2022-04-26 | US | North Dakota | Pembina | 38067 | 1976 | 16 | 0 | 48.76623521 | -97.5523809 | 2022-04-27 04:20:52 | Pembina, North Dakota, US | |
3724620 | 3724620 | 2022-04-25 | US | North Dakota | Pembina | 38067 | 1976 | 16 | 0 | 48.76623521 | -97.5523809 | 2022-04-26 04:20:51 | Pembina, North Dakota, US | |
2031188 | 2031188 | 2022-04-24 | US | North Dakota | Pembina | 38067 | 1976 | 16 | 0 | 48.76623521 | -97.5523809 | 2022-04-25 04:20:56 | Pembina, North Dakota, US | |
748763 | 748763 | 2022-04-23 | US | North Dakota | Pembina | 38067 | 1976 | 16 | 0 | 48.76623521 | -97.5523809 | 2022-04-24 04:20:56 | Pembina, North Dakota, US | |
3439248 | 3439248 | 2022-04-22 | US | North Dakota | Pembina | 38067 | 1976 | 16 | 0 | 48.76623521 | -97.5523809 | 2022-04-23 04:20:50 | Pembina, North Dakota, US | |
2443637 | 2443637 | 2022-04-13 | US | Georgia | Taylor | 13269 | 1976 | 53 | 0 | 32.55792548 | -84.25077141 | 2022-04-13 23:21:06 | Taylor, Georgia, US | |
1949394 | 1949394 | 2022-04-12 | US | Georgia | Taylor | 13269 | 1976 | 53 | 0 | 32.55792548 | -84.25077141 | 2022-04-13 04:21:03 | Taylor, Georgia, US | |
3207147 | 3207147 | 2022-04-11 | US | Georgia | Taylor | 13269 | 1976 | 53 | 0 | 32.55792548 | -84.25077141 | 2022-04-12 04:20:49 | Taylor, Georgia, US | |
1577033 | 1577033 | 2022-04-10 | US | Georgia | Taylor | 13269 | 1976 | 53 | 0 | 32.55792548 | -84.25077141 | 2022-04-11 04:21:02 | Taylor, Georgia, US | |
1653275 | 1653275 | 2022-04-09 | US | Georgia | Taylor | 13269 | 1976 | 53 | 0 | 32.55792548 | -84.25077141 | 2022-04-10 04:20:52 | Taylor, Georgia, US | |
2116597 | 2116597 | 2022-04-08 | US | Georgia | Taylor | 13269 | 1976 | 53 | 0 | 32.55792548 | -84.25077141 | 2022-04-09 04:20:42 | Taylor, Georgia, US | |
3320032 | 3320032 | 2022-04-07 | China | Hebei | 1976 | 7 | 0 | 37.8957 | 114.9042 | 2022-04-08 04:20:48 | Hebei, China | |||
1867685 | 1867685 | 2022-03-10 | US | New Mexico | Quay | 35037 | 1976 | 49 | 0 | 35.10403332 | -103.54817270000001 | 2022-03-11 04:20:50 | Quay, New Mexico, US | |
2199455 | 2199455 | 2022-03-06 | China | Yunnan | 1976 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-03-07 04:20:47 | Yunnan, China | |||
1646117 | 1646117 | 2022-03-03 | US | Minnesota | Pipestone | 27117 | 1976 | 34 | 0 | 44.02301619 | -96.25841142 | 2022-03-04 04:21:09 | Pipestone, Minnesota, US | |
2736338 | 2736338 | 2022-02-27 | US | Virginia | Buena Vista | 51530 | 1976 | 39 | 0 | 37.73484642 | -79.35296097 | 2022-02-28 04:21:05 | Buena Vista, Virginia, US | |
3049491 | 3049491 | 2022-02-26 | US | Virginia | Buena Vista | 51530 | 1976 | 39 | 0 | 37.73484642 | -79.35296097 | 2022-02-27 04:21:04 | Buena Vista, Virginia, US | |
578146 | 578146 | 2022-02-25 | US | Virginia | Buena Vista | 51530 | 1976 | 39 | 0 | 37.73484642 | -79.35296097 | 2022-02-26 04:21:12 | Buena Vista, Virginia, US | |
1512313 | 1512313 | 2022-02-24 | US | Georgia | Wilcox | 13315 | 1976 | 66 | 0 | 31.97496928 | -83.43438555 | 2022-02-25 04:21:11 | Wilcox, Georgia, US | |
1058754 | 1058754 | 2022-02-23 | US | Georgia | Wilcox | 13315 | 1976 | 66 | 0 | 31.97496928 | -83.43438555 | 2022-02-24 04:21:14 | Wilcox, Georgia, US | |
3858607 | 3858607 | 2022-02-18 | US | Puerto Rico | Rincon | 72117 | 1976 | 0 | 0 | 18.335442999999998 | -67.23174 | 2022-02-19 04:21:11 | Rincon, Puerto Rico, US | |
3673641 | 3673641 | 2022-02-15 | US | Montana | Carbon | 30009 | 1976 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-02-16 04:21:10 | Carbon, Montana, US | |
2643500 | 2643500 | 2022-02-14 | US | Minnesota | Murray | 27101 | 1976 | 15 | 0 | 44.02216709 | -95.76328482 | 2022-02-15 04:21:09 | Murray, Minnesota, US | |
2642680 | 2642680 | 2022-02-14 | US | Idaho | Boundary | 16021 | 1976 | 56 | 0 | 48.76684761 | -116.4630179 | 2022-02-15 04:21:09 | Boundary, Idaho, US | |
71616 | 71616 | 2022-02-07 | US | Arkansas | Searcy | 5129 | 1976 | 39 | 0 | 35.9109364 | -92.69936482 | 2022-02-08 04:21:15 | Searcy, Arkansas, US | |
1297542 | 1297542 | 2022-02-05 | US | West Virginia | Pleasants | 54073 | 1976 | 34 | 0 | 39.37091679 | -81.16771771 | 2022-02-06 04:21:00 | Pleasants, West Virginia, US | |
980915 | 980915 | 2022-02-01 | US | Missouri | St. Clair | 29185 | 1976 | 29 | 0 | 38.03699437 | -93.77631447 | 2022-02-02 04:21:09 | St. Clair, Missouri, US | |
3065014 | 3065014 | 2022-01-29 | US | Texas | Archer | 48009 | 1976 | 24 | 0 | 33.61569967 | -98.68754589 | 2022-01-30 04:21:26 | Archer, Texas, US | |
1141742 | 1141742 | 2022-01-23 | US | Georgia | Johnson | 13167 | 1976 | 64 | 0 | 32.70211082 | -82.66166794 | 2022-01-24 04:21:12 | Johnson, Georgia, US | |
2833660 | 2833660 | 2022-01-22 | US | Georgia | Johnson | 13167 | 1976 | 64 | 0 | 32.70211082 | -82.66166794 | 2022-01-23 04:21:13 | Johnson, Georgia, US | |
3425778 | 3425778 | 2022-01-21 | US | Georgia | Johnson | 13167 | 1976 | 64 | 0 | 32.70211082 | -82.66166794 | 2022-01-22 04:21:13 | Johnson, Georgia, US | |
1474848 | 1474848 | 2022-01-17 | US | Puerto Rico | Ciales | 72039 | 1976 | 0 | 0 | 18.28885 | -66.516475 | 2022-01-18 04:21:04 | Ciales, Puerto Rico, US | |
558000 | 558000 | 2022-01-16 | US | Texas | Runnels | 48399 | 1976 | 57 | 0 | 31.8314342 | -99.97616148 | 2022-01-17 04:21:08 | Runnels, Texas, US | |
127801 | 127801 | 2022-01-09 | US | Indiana | Benton | 18007 | 1976 | 21 | 0 | 40.60626947 | -87.31093999 | 2022-01-10 04:22:07 | Benton, Indiana, US | |
1216636 | 1216636 | 2022-01-08 | US | Indiana | Benton | 18007 | 1976 | 21 | 0 | 40.60626947 | -87.31093999 | 2022-01-09 04:21:46 | Benton, Indiana, US | |
1390729 | 1390729 | 2022-01-07 | US | Indiana | Benton | 18007 | 1976 | 21 | 0 | 40.60626947 | -87.31093999 | 2022-01-08 04:21:53 | Benton, Indiana, US | |
1702166 | 1702166 | 2022-01-03 | US | Mississippi | Jefferson Davis | 28065 | 1976 | 43 | 0 | 31.56884708 | -89.82670990000004 | 2022-01-04 04:22:17 | Jefferson Davis, Mississippi, US | |
4001064 | 4001064 | 2021-12-30 | US | North Dakota | Mercer | 38057 | 1976 | 22 | 0 | 47.31213126 | -101.8318399 | 2021-12-31 04:21:50 | Mercer, North Dakota, US | |
732259 | 732259 | 2021-12-27 | US | Minnesota | Koochiching | 27071 | 1976 | 29 | 0 | 48.24539665 | -93.78352843 | 2021-12-28 04:21:47 | Koochiching, Minnesota, US | |
3829590 | 3829590 | 2021-12-21 | US | Indiana | Newton | 18111 | 1976 | 55 | 0 | 40.95610449 | -87.39635768 | 2021-12-22 04:21:54 | Newton, Indiana, US | |
1256648 | 1256648 | 2021-12-20 | US | Missouri | Bollinger | 29017 | 1976 | 34 | 0 | 37.32449052 | -90.02725304 | 2021-12-21 03:21:27 | Bollinger, Missouri, US | |
2401339 | 2401339 | 2021-12-17 | US | Ohio | Vinton | 39163 | 1976 | 46 | 0 | 39.25208988 | -82.4831444 | 2021-12-18 02:22:20 | Vinton, Ohio, US | |
405608 | 405608 | 2021-12-07 | US | Kansas | Marion | 20115 | 1976 | 36 | 0 | 38.35855394 | -97.09852509999999 | 2021-12-08 04:22:46 | Marion, Kansas, US | |
1031690 | 1031690 | 2021-12-06 | US | Kansas | Marion | 20115 | 1976 | 36 | 0 | 38.35855394 | -97.09852509999999 | 2021-12-07 04:22:34 | Marion, Kansas, US | |
1147685 | 1147685 | 2021-12-01 | US | Puerto Rico | Las Piedras | 72085 | 1976 | 0 | 0 | 18.187527 | -65.86946800000001 | 2021-12-02 04:22:37 | Las Piedras, Puerto Rico, US | |
906915 | 906915 | 2021-11-24 | US | Puerto Rico | Corozal | 72047 | 1976 | 0 | 0 | 18.304264 | -66.327738 | 2021-11-25 04:22:33 | Corozal, Puerto Rico, US | |
162652 | 162652 | 2021-11-19 | US | Colorado | Gunnison | 8051 | 1976 | 12 | 0 | 38.66611652 | -107.0320729 | 2021-11-20 04:22:17 | Gunnison, Colorado, US | |
2290312 | 2290312 | 2021-11-15 | US | South Dakota | Butte | 46019 | 1976 | 33 | 0 | 44.90608745 | -103.5079318 | 2021-11-16 04:21:10 | Butte, South 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]);