johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
323 rows where confirmed = 2189 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2754440 | 2754440 | 2022-12-29 | US | Louisiana | St. Helena | 22091 | 2189 | 25 | 0 | 30.82210324 | -90.71013176 | 2022-12-30 04:21:04 | St. Helena, Louisiana, US | |
2753559 | 2753559 | 2022-12-29 | US | Colorado | Rio Blanco | 8103 | 2189 | 15 | 0 | 39.97913541 | -108.2179009 | 2022-12-30 04:21:04 | Rio Blanco, Colorado, US | |
1075446 | 1075446 | 2022-12-28 | US | Louisiana | St. Helena | 22091 | 2189 | 25 | 0 | 30.82210324 | -90.71013176 | 2022-12-29 04:21:01 | St. Helena, Louisiana, US | |
1968003 | 1968003 | 2022-11-30 | US | Virginia | Williamsburg | 51830 | 2189 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-12-01 04:21:03 | Williamsburg, Virginia, US | |
2560017 | 2560017 | 2022-11-29 | US | Virginia | Williamsburg | 51830 | 2189 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-11-30 04:21:07 | Williamsburg, Virginia, US | |
1243091 | 1243091 | 2022-11-28 | US | Virginia | Williamsburg | 51830 | 2189 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-11-29 04:21:05 | Williamsburg, Virginia, US | |
1622897 | 1622897 | 2022-11-22 | US | Oregon | Grant | 41023 | 2189 | 26 | 0 | 44.49024544 | -119.0068631 | 2022-11-23 04:21:06 | Grant, Oregon, US | |
3462785 | 3462785 | 2022-11-21 | US | Oregon | Grant | 41023 | 2189 | 26 | 0 | 44.49024544 | -119.0068631 | 2022-11-22 04:20:47 | Grant, Oregon, US | |
1642970 | 1642970 | 2022-11-20 | US | Oregon | Grant | 41023 | 2189 | 26 | 0 | 44.49024544 | -119.0068631 | 2022-11-21 04:21:05 | Grant, Oregon, US | |
2066527 | 2066527 | 2022-11-19 | US | Oregon | Grant | 41023 | 2189 | 26 | 0 | 44.49024544 | -119.0068631 | 2022-11-20 04:21:08 | Grant, Oregon, US | |
1757921 | 1757921 | 2022-11-18 | US | Oregon | Grant | 41023 | 2189 | 26 | 0 | 44.49024544 | -119.0068631 | 2022-11-19 04:21:14 | Grant, Oregon, US | |
3028914 | 3028914 | 2022-11-17 | US | Oregon | Grant | 41023 | 2189 | 26 | 0 | 44.49024544 | -119.0068631 | 2022-11-18 04:21:15 | Grant, Oregon, US | |
2488625 | 2488625 | 2022-11-16 | US | Oregon | Grant | 41023 | 2189 | 26 | 0 | 44.49024544 | -119.0068631 | 2022-11-17 04:21:11 | Grant, Oregon, US | |
2431548 | 2431548 | 2022-11-09 | US | Colorado | Conejos | 8021 | 2189 | 57 | 0 | 37.201606 | -106.1917488 | 2022-11-10 04:21:16 | Conejos, Colorado, US | |
1053206 | 1053206 | 2022-11-06 | US | Virginia | Lancaster | 51103 | 2189 | 38 | 0 | 37.71889653 | -76.46400482 | 2022-11-07 04:21:26 | Lancaster, Virginia, US | |
621230 | 621230 | 2022-11-05 | US | Virginia | Lancaster | 51103 | 2189 | 38 | 0 | 37.71889653 | -76.46400482 | 2022-11-06 04:21:24 | Lancaster, Virginia, US | |
1025734 | 1025734 | 2022-11-04 | US | Virginia | Lancaster | 51103 | 2189 | 38 | 0 | 37.71889653 | -76.46400482 | 2022-11-05 04:21:52 | Lancaster, Virginia, US | |
434725 | 434725 | 2022-11-03 | US | Virginia | Lancaster | 51103 | 2189 | 38 | 0 | 37.71889653 | -76.46400482 | 2022-11-04 04:22:11 | Lancaster, Virginia, US | |
433749 | 433749 | 2022-11-03 | US | North Dakota | Benson | 38005 | 2189 | 23 | 0 | 48.0683985 | -99.35916363 | 2022-11-04 04:22:11 | Benson, North Dakota, US | |
852967 | 852967 | 2022-11-02 | US | Virginia | Lancaster | 51103 | 2189 | 38 | 0 | 37.71889653 | -76.46400482 | 2022-11-03 04:22:05 | Lancaster, Virginia, US | |
851991 | 851991 | 2022-11-02 | US | North Dakota | Benson | 38005 | 2189 | 23 | 0 | 48.0683985 | -99.35916363 | 2022-11-03 04:22:05 | Benson, North Dakota, US | |
713818 | 713818 | 2022-11-01 | US | Virginia | Lancaster | 51103 | 2189 | 38 | 0 | 37.71889653 | -76.46400482 | 2022-11-02 04:22:09 | Lancaster, Virginia, US | |
712842 | 712842 | 2022-11-01 | US | North Dakota | Benson | 38005 | 2189 | 23 | 0 | 48.0683985 | -99.35916363 | 2022-11-02 04:22:09 | Benson, North Dakota, US | |
3287291 | 3287291 | 2022-10-31 | US | North Dakota | Benson | 38005 | 2189 | 23 | 0 | 48.0683985 | -99.35916363 | 2022-11-01 04:22:36 | Benson, North Dakota, US | |
322324 | 322324 | 2022-10-30 | US | North Dakota | Benson | 38005 | 2189 | 23 | 0 | 48.0683985 | -99.35916363 | 2022-10-31 04:21:36 | Benson, North Dakota, US | |
914600 | 914600 | 2022-10-29 | US | North Dakota | Benson | 38005 | 2189 | 23 | 0 | 48.0683985 | -99.35916363 | 2022-10-30 04:22:14 | Benson, North Dakota, US | |
1368869 | 1368869 | 2022-10-28 | US | North Dakota | Benson | 38005 | 2189 | 23 | 0 | 48.0683985 | -99.35916363 | 2022-10-29 04:21:13 | Benson, North Dakota, US | |
3040724 | 3040724 | 2022-10-27 | US | North Dakota | Benson | 38005 | 2189 | 23 | 0 | 48.0683985 | -99.35916363 | 2022-10-28 04:22:31 | Benson, North Dakota, US | |
541144 | 541144 | 2022-10-26 | US | North Dakota | Benson | 38005 | 2189 | 23 | 0 | 48.0683985 | -99.35916363 | 2022-10-27 04:22:01 | Benson, North Dakota, US | |
1832545 | 1832545 | 2022-10-25 | US | North Dakota | Benson | 38005 | 2189 | 23 | 0 | 48.0683985 | -99.35916363 | 2022-10-26 04:22:19 | Benson, North Dakota, US | |
2162644 | 2162644 | 2022-10-16 | US | Texas | Hansford | 48195 | 2189 | 30 | 0 | 36.27743284 | -101.3545796 | 2022-10-17 04:20:31 | Hansford, Texas, US | |
518841 | 518841 | 2022-10-15 | US | Texas | Hansford | 48195 | 2189 | 30 | 0 | 36.27743284 | -101.3545796 | 2022-10-16 04:22:39 | Hansford, Texas, US | |
2035898 | 2035898 | 2022-10-14 | US | Texas | Hansford | 48195 | 2189 | 30 | 0 | 36.27743284 | -101.3545796 | 2022-10-15 04:22:00 | Hansford, Texas, US | |
132059 | 132059 | 2022-10-04 | US | Kansas | Kingman | 20095 | 2189 | 29 | 0 | 37.55909527 | -98.13638678 | 2022-10-05 04:23:06 | Kingman, Kansas, US | |
2687006 | 2687006 | 2022-10-03 | US | Kansas | Kingman | 20095 | 2189 | 29 | 0 | 37.55909527 | -98.13638678 | 2022-10-04 04:22:55 | Kingman, Kansas, US | |
2686364 | 2686364 | 2022-10-03 | US | Colorado | Yuma | 8125 | 2189 | 27 | 0 | 40.00346839 | -102.4258673 | 2022-10-04 04:22:55 | Yuma, Colorado, US | |
2261073 | 2261073 | 2022-10-02 | US | Kansas | Kingman | 20095 | 2189 | 29 | 0 | 37.55909527 | -98.13638678 | 2022-10-03 04:23:11 | Kingman, Kansas, US | |
2260431 | 2260431 | 2022-10-02 | US | Colorado | Yuma | 8125 | 2189 | 27 | 0 | 40.00346839 | -102.4258673 | 2022-10-03 04:23:11 | Yuma, Colorado, US | |
2996599 | 2996599 | 2022-10-01 | US | Kansas | Kingman | 20095 | 2189 | 29 | 0 | 37.55909527 | -98.13638678 | 2022-10-02 04:21:23 | Kingman, Kansas, US | |
2995957 | 2995957 | 2022-10-01 | US | Colorado | Yuma | 8125 | 2189 | 27 | 0 | 40.00346839 | -102.4258673 | 2022-10-02 04:21:23 | Yuma, Colorado, US | |
854925 | 854925 | 2022-09-30 | US | Kansas | Kingman | 20095 | 2189 | 29 | 0 | 37.55909527 | -98.13638678 | 2022-10-01 04:23:01 | Kingman, Kansas, US | |
854283 | 854283 | 2022-09-30 | US | Colorado | Yuma | 8125 | 2189 | 27 | 0 | 40.00346839 | -102.4258673 | 2022-10-01 04:23:01 | Yuma, Colorado, US | |
2376851 | 2376851 | 2022-09-29 | US | Kansas | Kingman | 20095 | 2189 | 29 | 0 | 37.55909527 | -98.13638678 | 2022-09-30 04:23:09 | Kingman, Kansas, US | |
1561402 | 1561402 | 2022-09-28 | US | Kansas | Kingman | 20095 | 2189 | 29 | 0 | 37.55909527 | -98.13638678 | 2022-09-29 04:22:34 | Kingman, Kansas, US | |
2771131 | 2771131 | 2022-09-26 | US | New Hampshire | Unassigned | 90033 | 2189 | 4 | 0 | 44.69063265 | 0.0 | 2022-09-27 04:23:01 | Unassigned, New Hampshire, US | |
422563 | 422563 | 2022-09-18 | US | Texas | Somervell | 48425 | 2189 | 37 | 0 | 32.22236802 | -97.77403489 | 2022-09-19 04:21:49 | Somervell, Texas, US | |
3376587 | 3376587 | 2022-09-17 | US | Texas | Somervell | 48425 | 2189 | 37 | 0 | 32.22236802 | -97.77403489 | 2022-09-18 04:22:50 | Somervell, Texas, US | |
2358695 | 2358695 | 2022-09-16 | US | Texas | Somervell | 48425 | 2189 | 37 | 0 | 32.22236802 | -97.77403489 | 2022-09-17 04:20:19 | Somervell, Texas, US | |
3989852 | 3989852 | 2022-09-15 | US | Texas | Somervell | 48425 | 2189 | 37 | 0 | 32.22236802 | -97.77403489 | 2022-09-16 04:21:19 | Somervell, Texas, US | |
1892369 | 1892369 | 2022-09-14 | US | Texas | Somervell | 48425 | 2189 | 37 | 0 | 32.22236802 | -97.77403489 | 2022-09-15 04:21:02 | Somervell, Texas, US | |
3769386 | 3769386 | 2022-09-11 | US | West Virginia | Pendleton | 54071 | 2189 | 22 | 0 | 38.68314479 | -79.35084086 | 2022-09-12 04:20:58 | Pendleton, West Virginia, US | |
3768968 | 3768968 | 2022-09-11 | US | Texas | Floyd | 48153 | 2189 | 49 | 0 | 34.07227468 | -101.3031546 | 2022-09-12 04:20:58 | Floyd, Texas, US | |
3827961 | 3827961 | 2022-09-10 | US | West Virginia | Pendleton | 54071 | 2189 | 22 | 0 | 38.68314479 | -79.35084086 | 2022-09-11 04:20:50 | Pendleton, West Virginia, US | |
3827543 | 3827543 | 2022-09-10 | US | Texas | Floyd | 48153 | 2189 | 49 | 0 | 34.07227468 | -101.3031546 | 2022-09-11 04:20:50 | Floyd, Texas, US | |
966418 | 966418 | 2022-09-09 | US | West Virginia | Pendleton | 54071 | 2189 | 22 | 0 | 38.68314479 | -79.35084086 | 2022-09-10 04:21:10 | Pendleton, West Virginia, US | |
966000 | 966000 | 2022-09-09 | US | Texas | Floyd | 48153 | 2189 | 49 | 0 | 34.07227468 | -101.3031546 | 2022-09-10 04:21:10 | Floyd, Texas, US | |
2325096 | 2325096 | 2022-08-24 | US | Minnesota | Murray | 27101 | 2189 | 20 | 0 | 44.02216709 | -95.76328482 | 2022-08-25 04:21:13 | Murray, Minnesota, US | |
1252505 | 1252505 | 2022-08-23 | US | Minnesota | Murray | 27101 | 2189 | 20 | 0 | 44.02216709 | -95.76328482 | 2022-08-24 04:20:46 | Murray, Minnesota, US | |
2854609 | 2854609 | 2022-08-22 | US | Minnesota | Murray | 27101 | 2189 | 20 | 0 | 44.02216709 | -95.76328482 | 2022-08-23 04:20:56 | Murray, Minnesota, US | |
2404581 | 2404581 | 2022-08-21 | US | Minnesota | Murray | 27101 | 2189 | 20 | 0 | 44.02216709 | -95.76328482 | 2022-08-22 04:20:38 | Murray, Minnesota, US | |
3799659 | 3799659 | 2022-08-20 | US | Minnesota | Murray | 27101 | 2189 | 20 | 0 | 44.02216709 | -95.76328482 | 2022-08-21 04:20:44 | Murray, Minnesota, US | |
2365245 | 2365245 | 2022-08-19 | US | Minnesota | Murray | 27101 | 2189 | 20 | 0 | 44.02216709 | -95.76328482 | 2022-08-20 04:21:01 | Murray, Minnesota, US | |
1162916 | 1162916 | 2022-08-18 | US | Minnesota | Murray | 27101 | 2189 | 20 | 0 | 44.02216709 | -95.76328482 | 2022-08-19 04:20:54 | Murray, Minnesota, US | |
2597541 | 2597541 | 2022-07-25 | US | West Virginia | Pocahontas | 54075 | 2189 | 32 | 0 | 38.32758728 | -80.00993811 | 2022-07-26 04:20:58 | Pocahontas, West Virginia, US | |
3428780 | 3428780 | 2022-07-14 | China | Yunnan | 2189 | 2 | 0 | 24.974 | 101.487 | 2022-07-15 04:20:53 | Yunnan, China | |||
1202875 | 1202875 | 2022-07-06 | US | Texas | Dallam | 48111 | 2189 | 40 | 0 | 36.27787176 | -102.6020725 | 2022-07-07 04:20:55 | Dallam, Texas, US | |
3969618 | 3969618 | 2022-07-05 | US | Texas | Dallam | 48111 | 2189 | 40 | 0 | 36.27787176 | -102.6020725 | 2022-07-06 04:20:58 | Dallam, Texas, US | |
2242560 | 2242560 | 2022-06-28 | US | Texas | Live Oak | 48297 | 2189 | 42 | 0 | 28.35101362 | -98.1246786 | 2022-06-29 04:20:59 | Live Oak, Texas, US | |
947714 | 947714 | 2022-06-14 | US | Georgia | Pulaski | 13235 | 2189 | 78 | 0 | 32.23334561 | -83.4754996 | 2022-06-15 04:20:54 | Pulaski, Georgia, US | |
2980122 | 2980122 | 2022-06-13 | US | Georgia | Pulaski | 13235 | 2189 | 78 | 0 | 32.23334561 | -83.4754996 | 2022-06-14 04:20:52 | Pulaski, Georgia, US | |
2236248 | 2236248 | 2022-06-12 | US | Georgia | Pulaski | 13235 | 2189 | 78 | 0 | 32.23334561 | -83.4754996 | 2022-06-13 04:21:14 | Pulaski, Georgia, US | |
3142446 | 3142446 | 2022-06-11 | US | Georgia | Pulaski | 13235 | 2189 | 78 | 0 | 32.23334561 | -83.4754996 | 2022-06-12 04:20:53 | Pulaski, Georgia, US | |
1945362 | 1945362 | 2022-06-10 | US | Georgia | Pulaski | 13235 | 2189 | 78 | 0 | 32.23334561 | -83.4754996 | 2022-06-11 04:21:01 | Pulaski, Georgia, US | |
3159542 | 3159542 | 2022-06-09 | US | Missouri | Gentry | 29075 | 2189 | 32 | 0 | 40.21097916 | -94.40944419 | 2022-06-10 04:20:55 | Gentry, Missouri, US | |
3158501 | 3158501 | 2022-06-09 | US | Georgia | Pulaski | 13235 | 2189 | 78 | 0 | 32.23334561 | -83.4754996 | 2022-06-10 04:20:55 | Pulaski, Georgia, US | |
1423009 | 1423009 | 2022-06-08 | US | Missouri | Gentry | 29075 | 2189 | 32 | 0 | 40.21097916 | -94.40944419 | 2022-06-09 04:20:54 | Gentry, Missouri, US | |
1421968 | 1421968 | 2022-06-08 | US | Georgia | Pulaski | 13235 | 2189 | 78 | 0 | 32.23334561 | -83.4754996 | 2022-06-09 04:20:54 | Pulaski, Georgia, US | |
3728123 | 3728123 | 2022-06-07 | US | Missouri | Gentry | 29075 | 2189 | 32 | 0 | 40.21097916 | -94.40944419 | 2022-06-08 04:20:55 | Gentry, Missouri, US | |
3889525 | 3889525 | 2022-06-06 | US | Missouri | Gentry | 29075 | 2189 | 32 | 0 | 40.21097916 | -94.40944419 | 2022-06-07 04:21:08 | Gentry, Missouri, US | |
3509294 | 3509294 | 2022-06-05 | US | Missouri | Gentry | 29075 | 2189 | 32 | 0 | 40.21097916 | -94.40944419 | 2022-06-06 04:20:57 | Gentry, Missouri, US | |
3509100 | 3509100 | 2022-06-05 | US | Minnesota | Clearwater | 27029 | 2189 | 30 | 0 | 47.57992111 | -95.37790562 | 2022-06-06 04:20:57 | Clearwater, Minnesota, US | |
3508383 | 3508383 | 2022-06-05 | US | Illinois | Hamilton | 17065 | 2189 | 31 | 0 | 38.08163641 | -88.53883373 | 2022-06-06 04:20:57 | Hamilton, Illinois, US | |
3529371 | 3529371 | 2022-06-04 | US | Missouri | Gentry | 29075 | 2189 | 32 | 0 | 40.21097916 | -94.40944419 | 2022-06-05 04:20:55 | Gentry, Missouri, US | |
3529177 | 3529177 | 2022-06-04 | US | Minnesota | Clearwater | 27029 | 2189 | 30 | 0 | 47.57992111 | -95.37790562 | 2022-06-05 04:20:55 | Clearwater, Minnesota, US | |
3528460 | 3528460 | 2022-06-04 | US | Illinois | Hamilton | 17065 | 2189 | 31 | 0 | 38.08163641 | -88.53883373 | 2022-06-05 04:20:55 | Hamilton, Illinois, US | |
3135457 | 3135457 | 2022-06-03 | US | Missouri | Gentry | 29075 | 2189 | 32 | 0 | 40.21097916 | -94.40944419 | 2022-06-04 04:20:58 | Gentry, Missouri, US | |
3135263 | 3135263 | 2022-06-03 | US | Minnesota | Clearwater | 27029 | 2189 | 30 | 0 | 47.57992111 | -95.37790562 | 2022-06-04 04:20:58 | Clearwater, Minnesota, US | |
3134546 | 3134546 | 2022-06-03 | US | Illinois | Hamilton | 17065 | 2189 | 31 | 0 | 38.08163641 | -88.53883373 | 2022-06-04 04:20:58 | Hamilton, Illinois, US | |
3579621 | 3579621 | 2022-06-02 | US | Illinois | Hamilton | 17065 | 2189 | 31 | 0 | 38.08163641 | -88.53883373 | 2022-06-03 04:20:58 | Hamilton, Illinois, US | |
971914 | 971914 | 2022-06-01 | US | Illinois | Hamilton | 17065 | 2189 | 31 | 0 | 38.08163641 | -88.53883373 | 2022-06-02 05:20:39 | Hamilton, Illinois, US | |
3896474 | 3896474 | 2022-05-19 | US | Arkansas | Nevada | 5099 | 2189 | 46 | 0 | 33.66340119 | -93.30632432 | 2022-05-20 04:20:57 | Nevada, Arkansas, US | |
3583392 | 3583392 | 2022-05-17 | US | Georgia | Atkinson | 13003 | 2189 | 50 | 0 | 31.29633502 | -82.87545866 | 2022-05-18 04:20:50 | Atkinson, Georgia, US | |
1504349 | 1504349 | 2022-05-16 | US | Georgia | Atkinson | 13003 | 2189 | 50 | 0 | 31.29633502 | -82.87545866 | 2022-05-17 04:20:59 | Atkinson, Georgia, US | |
2084708 | 2084708 | 2022-05-15 | US | Georgia | Atkinson | 13003 | 2189 | 50 | 0 | 31.29633502 | -82.87545866 | 2022-05-16 04:20:47 | Atkinson, Georgia, US | |
3355418 | 3355418 | 2022-05-14 | US | Georgia | Atkinson | 13003 | 2189 | 50 | 0 | 31.29633502 | -82.87545866 | 2022-05-15 04:20:53 | Atkinson, Georgia, US | |
659063 | 659063 | 2022-05-13 | US | Georgia | Atkinson | 13003 | 2189 | 50 | 0 | 31.29633502 | -82.87545866 | 2022-05-14 04:20:48 | Atkinson, Georgia, US | |
2534146 | 2534146 | 2022-05-12 | US | Georgia | Atkinson | 13003 | 2189 | 50 | 0 | 31.29633502 | -82.87545866 | 2022-05-13 04:20:51 | Atkinson, Georgia, US | |
3445592 | 3445592 | 2022-05-11 | US | Georgia | Atkinson | 13003 | 2189 | 50 | 0 | 31.29633502 | -82.87545866 | 2022-05-12 04:20:54 | Atkinson, Georgia, US | |
1699108 | 1699108 | 2022-04-28 | US | Puerto Rico | Rincon | 72117 | 2189 | 0 | 0 | 18.335443 | -67.23174 | 2022-04-29 04:20:59 | Rincon, Puerto Rico, US | |
2254196 | 2254196 | 2022-04-19 | US | Puerto Rico | Penuelas | 72111 | 2189 | 0 | 0 | 18.059645 | -66.721572 | 2022-04-20 04:20:45 | Penuelas, Puerto Rico, 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]);