johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
388 rows where confirmed = 1582 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 12
- US 368
- China 6
- Denmark 3
- Canada 2
- Japan 2
- India 1
- Mexico 1
- Mozambique 1
- Netherlands 1
- Rwanda 1
- Ukraine 1
- United Kingdom 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2267704 | 2267704 | 2022-10-22 | China | Hunan | 1582 | 4 | 0 | 27.6104 | 111.7088 | 2022-10-23 04:22:46 | Hunan, China | |||
2758171 | 2758171 | 2022-10-18 | US | Iowa | Van Buren | 19177 | 1582 | 27 | 0 | 40.75326764 | -91.95017958 | 2022-10-19 04:22:26 | Van Buren, Iowa, US | |
2026005 | 2026005 | 2022-10-17 | US | Iowa | Van Buren | 19177 | 1582 | 27 | 0 | 40.75326764 | -91.95017958 | 2022-10-18 04:22:42 | Van Buren, Iowa, US | |
2160783 | 2160783 | 2022-10-16 | US | Iowa | Van Buren | 19177 | 1582 | 27 | 0 | 40.75326764 | -91.95017958 | 2022-10-17 04:20:31 | Van Buren, Iowa, US | |
516980 | 516980 | 2022-10-15 | US | Iowa | Van Buren | 19177 | 1582 | 27 | 0 | 40.75326764 | -91.95017958 | 2022-10-16 04:22:39 | Van Buren, Iowa, US | |
2034037 | 2034037 | 2022-10-14 | US | Iowa | Van Buren | 19177 | 1582 | 27 | 0 | 40.75326764 | -91.95017958 | 2022-10-15 04:22:00 | Van Buren, Iowa, US | |
3754725 | 3754725 | 2022-10-13 | US | Iowa | Van Buren | 19177 | 1582 | 27 | 0 | 40.75326764 | -91.95017958 | 2022-10-14 04:22:28 | Van Buren, Iowa, US | |
3215550 | 3215550 | 2022-10-12 | US | Iowa | Van Buren | 19177 | 1582 | 27 | 0 | 40.75326764 | -91.95017958 | 2022-10-13 04:22:39 | Van Buren, Iowa, US | |
2260722 | 2260722 | 2022-10-02 | US | Idaho | Power | 16077 | 1582 | 20 | 0 | 42.69254894 | -112.8395742 | 2022-10-03 04:23:11 | Power, Idaho, US | |
2996248 | 2996248 | 2022-10-01 | US | Idaho | Power | 16077 | 1582 | 20 | 0 | 42.69254894 | -112.8395742 | 2022-10-02 04:21:23 | Power, Idaho, US | |
854574 | 854574 | 2022-09-30 | US | Idaho | Power | 16077 | 1582 | 20 | 0 | 42.69254894 | -112.8395742 | 2022-10-01 04:23:01 | Power, Idaho, US | |
3997493 | 3997493 | 2022-09-27 | US | South Dakota | Brule | 46015 | 1582 | 23 | 0 | 43.71756379 | -99.08118954 | 2022-09-28 04:23:01 | Brule, South Dakota, US | |
2771821 | 2771821 | 2022-09-26 | US | South Dakota | Brule | 46015 | 1582 | 23 | 0 | 43.71756379 | -99.08118954 | 2022-09-27 04:23:01 | Brule, South Dakota, US | |
1979474 | 1979474 | 2022-09-25 | US | South Dakota | Brule | 46015 | 1582 | 23 | 0 | 43.71756379 | -99.08118954 | 2022-09-26 04:20:52 | Brule, South Dakota, US | |
2652641 | 2652641 | 2022-09-24 | US | South Dakota | Brule | 46015 | 1582 | 23 | 0 | 43.71756379 | -99.08118954 | 2022-09-25 04:23:31 | Brule, South Dakota, US | |
387081 | 387081 | 2022-09-23 | US | South Dakota | Brule | 46015 | 1582 | 23 | 0 | 43.71756379 | -99.08118954 | 2022-09-24 04:21:40 | Brule, South Dakota, US | |
1627147 | 1627147 | 2022-09-22 | US | South Dakota | Brule | 46015 | 1582 | 23 | 0 | 43.71756379 | -99.08118954 | 2022-09-23 04:23:13 | Brule, South Dakota, US | |
1373351 | 1373351 | 2022-09-21 | US | South Dakota | Brule | 46015 | 1582 | 23 | 0 | 43.71756379 | -99.08118954 | 2022-09-22 04:22:56 | Brule, South Dakota, US | |
3550297 | 3550297 | 2022-09-01 | US | Puerto Rico | Vieques | 72147 | 1582 | 0 | 0 | 18.123276 | -65.440971 | 2022-09-02 04:21:07 | Vieques, Puerto Rico, US | |
3549377 | 3549377 | 2022-09-01 | US | Missouri | Atchison | 29005 | 1582 | 23 | 0 | 40.43238737 | -95.42970639 | 2022-09-02 04:21:07 | Atchison, Missouri, US | |
2345297 | 2345297 | 2022-08-31 | US | Missouri | Atchison | 29005 | 1582 | 23 | 0 | 40.43238737 | -95.42970639 | 2022-09-01 04:21:03 | Atchison, Missouri, US | |
3775777 | 3775777 | 2022-08-30 | US | Missouri | Atchison | 29005 | 1582 | 23 | 0 | 40.43238737 | -95.42970639 | 2022-08-31 04:20:57 | Atchison, Missouri, US | |
3774838 | 3774838 | 2022-08-30 | US | Idaho | Caribou | 16029 | 1582 | 33 | 0 | 42.77149116 | -111.5597683 | 2022-08-31 04:20:57 | Caribou, Idaho, US | |
1682373 | 1682373 | 2022-08-29 | US | Missouri | Atchison | 29005 | 1582 | 23 | 0 | 40.43238737 | -95.42970639 | 2022-08-30 04:21:03 | Atchison, Missouri, US | |
1878857 | 1878857 | 2022-08-28 | US | Missouri | Atchison | 29005 | 1582 | 23 | 0 | 40.43238737 | -95.42970639 | 2022-08-29 04:21:06 | Atchison, Missouri, US | |
1877918 | 1877918 | 2022-08-28 | US | Idaho | Caribou | 16029 | 1582 | 33 | 0 | 42.77149116 | -111.5597683 | 2022-08-29 04:21:06 | Caribou, Idaho, US | |
2097984 | 2097984 | 2022-08-27 | US | Missouri | Atchison | 29005 | 1582 | 23 | 0 | 40.43238737 | -95.42970639 | 2022-08-28 04:21:02 | Atchison, Missouri, US | |
2097045 | 2097045 | 2022-08-27 | US | Idaho | Caribou | 16029 | 1582 | 33 | 0 | 42.77149116 | -111.5597683 | 2022-08-28 04:21:02 | Caribou, Idaho, US | |
1533799 | 1533799 | 2022-08-26 | US | Missouri | Atchison | 29005 | 1582 | 23 | 0 | 40.43238737 | -95.42970639 | 2022-08-27 04:20:57 | Atchison, Missouri, US | |
1532860 | 1532860 | 2022-08-26 | US | Idaho | Caribou | 16029 | 1582 | 33 | 0 | 42.77149116 | -111.5597683 | 2022-08-27 04:20:57 | Caribou, Idaho, US | |
2829747 | 2829747 | 2022-08-25 | US | Idaho | Caribou | 16029 | 1582 | 33 | 0 | 42.77149116 | -111.5597683 | 2022-08-26 04:21:02 | Caribou, Idaho, US | |
2324280 | 2324280 | 2022-08-24 | US | Idaho | Caribou | 16029 | 1582 | 33 | 0 | 42.77149116 | -111.5597683 | 2022-08-25 04:21:13 | Caribou, Idaho, US | |
1251689 | 1251689 | 2022-08-23 | US | Idaho | Caribou | 16029 | 1582 | 33 | 0 | 42.77149116 | -111.5597683 | 2022-08-24 04:20:46 | Caribou, Idaho, US | |
2853793 | 2853793 | 2022-08-22 | US | Idaho | Caribou | 16029 | 1582 | 33 | 0 | 42.77149116 | -111.5597683 | 2022-08-23 04:20:56 | Caribou, Idaho, US | |
2403765 | 2403765 | 2022-08-21 | US | Idaho | Caribou | 16029 | 1582 | 33 | 0 | 42.77149116 | -111.5597683 | 2022-08-22 04:20:38 | Caribou, Idaho, US | |
3798843 | 3798843 | 2022-08-20 | US | Idaho | Caribou | 16029 | 1582 | 33 | 0 | 42.77149116 | -111.5597683 | 2022-08-21 04:20:44 | Caribou, Idaho, US | |
2364429 | 2364429 | 2022-08-19 | US | Idaho | Caribou | 16029 | 1582 | 33 | 0 | 42.77149116 | -111.5597683 | 2022-08-20 04:21:01 | Caribou, Idaho, US | |
3911191 | 3911191 | 2022-08-11 | US | Texas | Newton | 48351 | 1582 | 62 | 0 | 30.78548982 | -93.74408813 | 2022-08-12 04:20:54 | Newton, Texas, US | |
2338527 | 2338527 | 2022-07-27 | US | Texas | Jack | 48237 | 1582 | 29 | 0 | 33.23377248 | -98.17283469 | 2022-07-28 04:20:56 | Jack, Texas, US | |
1490717 | 1490717 | 2022-07-26 | US | Texas | Jack | 48237 | 1582 | 28 | 0 | 33.23377248 | -98.17283469 | 2022-07-27 04:21:04 | Jack, Texas, US | |
903328 | 903328 | 2022-07-22 | US | Texas | Lynn | 48305 | 1582 | 38 | 0 | 33.17657705 | -101.8162849 | 2022-07-23 04:20:53 | Lynn, Texas, US | |
2789662 | 2789662 | 2022-07-10 | US | Colorado | Huerfano | 8055 | 1582 | 37 | 0 | 37.68473101 | -104.9612585 | 2022-07-11 04:20:46 | Huerfano, Colorado, US | |
2743045 | 2743045 | 2022-07-07 | US | Montana | Stillwater | 30095 | 1582 | 32 | 0 | 45.67071407 | -109.3950061 | 2022-07-08 04:20:56 | Stillwater, Montana, US | |
1201840 | 1201840 | 2022-07-06 | US | Montana | Stillwater | 30095 | 1582 | 32 | 0 | 45.67071407 | -109.3950061 | 2022-07-07 04:20:55 | Stillwater, Montana, US | |
1200319 | 1200319 | 2022-07-06 | US | Arkansas | Montgomery | 5097 | 1582 | 56 | 0 | 34.53704874 | -93.65824478 | 2022-07-07 04:20:55 | Montgomery, Arkansas, US | |
3968583 | 3968583 | 2022-07-05 | US | Montana | Stillwater | 30095 | 1582 | 32 | 0 | 45.67071407 | -109.3950061 | 2022-07-06 04:20:58 | Stillwater, Montana, US | |
3080094 | 3080094 | 2022-07-04 | US | Montana | Stillwater | 30095 | 1582 | 32 | 0 | 45.67071407 | -109.3950061 | 2022-07-05 04:20:45 | Stillwater, Montana, US | |
1769376 | 1769376 | 2022-07-03 | US | Montana | Stillwater | 30095 | 1582 | 32 | 0 | 45.67071407 | -109.3950061 | 2022-07-04 04:20:54 | Stillwater, Montana, US | |
3367362 | 3367362 | 2022-07-02 | US | Montana | Stillwater | 30095 | 1582 | 32 | 0 | 45.67071407 | -109.3950061 | 2022-07-03 04:20:59 | Stillwater, Montana, US | |
595691 | 595691 | 2022-07-01 | US | Montana | Stillwater | 30095 | 1582 | 32 | 0 | 45.67071407 | -109.3950061 | 2022-07-02 04:21:16 | Stillwater, Montana, US | |
1111419 | 1111419 | 2022-05-21 | US | Mississippi | Quitman | 28119 | 1582 | 31 | 0 | 34.25157572 | -90.28908 | 2022-05-22 04:20:52 | Quitman, Mississippi, US | |
1171043 | 1171043 | 2022-05-20 | US | Mississippi | Quitman | 28119 | 1582 | 31 | 0 | 34.25157572 | -90.28908 | 2022-05-21 04:20:58 | Quitman, Mississippi, US | |
3897806 | 3897806 | 2022-05-19 | US | Mississippi | Quitman | 28119 | 1582 | 31 | 0 | 34.25157572 | -90.28908 | 2022-05-20 04:20:57 | Quitman, Mississippi, US | |
1186590 | 1186590 | 2022-05-18 | US | Mississippi | Quitman | 28119 | 1582 | 31 | 0 | 34.25157572 | -90.28908 | 2022-05-19 04:20:54 | Quitman, Mississippi, US | |
3584487 | 3584487 | 2022-05-17 | US | Mississippi | Quitman | 28119 | 1582 | 31 | 0 | 34.25157572 | -90.28908 | 2022-05-18 04:20:50 | Quitman, Mississippi, US | |
1505444 | 1505444 | 2022-05-16 | US | Mississippi | Quitman | 28119 | 1582 | 31 | 0 | 34.25157572 | -90.28908 | 2022-05-17 04:20:59 | Quitman, Mississippi, US | |
1539760 | 1539760 | 2022-03-31 | China | Liaoning | 1582 | 2 | 0 | 41.2956 | 122.6085 | 2022-04-01 04:20:28 | Liaoning, China | |||
3240217 | 3240217 | 2022-03-21 | US | Missouri | Clark | 29045 | 1582 | 32 | 0 | 40.41040752 | -91.73661677 | 2022-03-22 04:20:54 | Clark, Missouri, US | |
2266281 | 2266281 | 2022-03-14 | US | North Dakota | Bottineau | 38009 | 1582 | 25 | 0 | 48.79106111 | -100.8378166 | 2022-03-15 04:20:47 | Bottineau, North Dakota, US | |
3630347 | 3630347 | 2022-03-13 | US | North Dakota | Bottineau | 38009 | 1582 | 25 | 0 | 48.79106111 | -100.8378166 | 2022-03-14 04:20:46 | Bottineau, North Dakota, US | |
953255 | 953255 | 2022-03-12 | US | North Dakota | Bottineau | 38009 | 1582 | 25 | 0 | 48.79106111 | -100.8378166 | 2022-03-13 04:20:49 | Bottineau, North Dakota, US | |
358716 | 358716 | 2022-03-11 | US | North Dakota | Bottineau | 38009 | 1582 | 25 | 0 | 48.79106111 | -100.8378166 | 2022-03-12 04:20:50 | Bottineau, North Dakota, US | |
2734954 | 2734954 | 2022-02-27 | US | Missouri | Maries | 29125 | 1582 | 33 | 0 | 38.16193985 | -91.92249662 | 2022-02-28 04:21:05 | Maries, Missouri, US | |
3048107 | 3048107 | 2022-02-26 | US | Missouri | Maries | 29125 | 1582 | 33 | 0 | 38.16193985 | -91.92249662 | 2022-02-27 04:21:04 | Maries, Missouri, US | |
576762 | 576762 | 2022-02-25 | US | Missouri | Maries | 29125 | 1582 | 33 | 0 | 38.16193985 | -91.92249662 | 2022-02-26 04:21:12 | Maries, Missouri, US | |
1298889 | 1298889 | 2022-02-17 | US | Georgia | Lincoln | 13181 | 1582 | 35 | 0 | 33.79201475 | -82.45024131 | 2022-02-18 04:21:04 | Lincoln, Georgia, US | |
3672489 | 3672489 | 2022-02-15 | US | Georgia | Lincoln | 13181 | 1582 | 35 | 0 | 33.79201475 | -82.45024131 | 2022-02-16 04:21:10 | Lincoln, Georgia, US | |
3077211 | 3077211 | 2022-02-09 | US | Texas | Marion | 48315 | 1582 | 56 | 0 | 32.79868409 | -94.35661230000001 | 2022-02-10 04:21:14 | Marion, Texas, US | |
2474563 | 2474563 | 2022-02-03 | US | Colorado | Clear Creek | 8019 | 1582 | 11 | 0 | 39.68864463 | -105.6463118 | 2022-02-04 04:21:10 | Clear Creek, Colorado, US | |
462100 | 462100 | 2022-02-02 | US | Puerto Rico | Arroyo | 72015 | 1582 | 0 | 0 | 17.998457000000005 | -66.056546 | 2022-02-03 04:21:21 | Arroyo, Puerto Rico, US | |
2054752 | 2054752 | 2022-01-25 | US | South Dakota | Fall River | 46047 | 1582 | 34 | 0 | 43.23929297 | -103.5275691 | 2022-01-26 04:21:07 | Fall River, South Dakota, US | |
1144276 | 1144276 | 2022-01-23 | US | Virginia | Lancaster | 51103 | 1582 | 24 | 0 | 37.71889653 | -76.46400482 | 2022-01-24 04:21:12 | Lancaster, Virginia, US | |
2836194 | 2836194 | 2022-01-22 | US | Virginia | Lancaster | 51103 | 1582 | 24 | 0 | 37.71889653 | -76.46400482 | 2022-01-23 04:21:13 | Lancaster, Virginia, US | |
3428312 | 3428312 | 2022-01-21 | US | Virginia | Lancaster | 51103 | 1582 | 24 | 0 | 37.71889653 | -76.46400482 | 2022-01-22 04:21:13 | Lancaster, Virginia, US | |
3467270 | 3467270 | 2022-01-18 | US | Texas | Gaines | 48165 | 1582 | 72 | 0 | 32.74055318 | -102.6353295 | 2022-01-19 04:21:23 | Gaines, Texas, US | |
557737 | 557737 | 2022-01-16 | US | Tennessee | Hancock | 47067 | 1582 | 29 | 0 | 36.52692871 | -83.22375847 | 2022-01-17 04:21:08 | Hancock, Tennessee, US | |
102039 | 102039 | 2022-01-14 | US | Puerto Rico | Adjuntas | 72001 | 1582 | 0 | 0 | 18.180117000000006 | -66.754367 | 2022-01-15 04:21:07 | Adjuntas, Puerto Rico, US | |
3615278 | 3615278 | 2022-01-12 | US | New Mexico | Sierra | 35051 | 1582 | 65 | 0 | 33.13028233 | -107.1925893 | 2022-01-13 08:00:09 | Sierra, New Mexico, US | |
127884 | 127884 | 2022-01-09 | US | Indiana | Warren | 18171 | 1582 | 20 | 0 | 40.34728141 | -87.35602659 | 2022-01-10 04:22:07 | Warren, Indiana, US | |
1216719 | 1216719 | 2022-01-08 | US | Indiana | Warren | 18171 | 1582 | 20 | 0 | 40.34728141 | -87.35602659 | 2022-01-09 04:21:46 | Warren, Indiana, US | |
1215965 | 1215965 | 2022-01-08 | US | Alabama | Perry | 1105 | 1582 | 41 | 0 | 32.64048341 | -87.29770589 | 2022-01-09 04:21:46 | Perry, Alabama, US | |
1390812 | 1390812 | 2022-01-07 | US | Indiana | Warren | 18171 | 1582 | 20 | 0 | 40.34728141 | -87.35602659 | 2022-01-08 04:21:53 | Warren, Indiana, US | |
1703682 | 1703682 | 2022-01-03 | US | Virginia | Essex | 51057 | 1582 | 21 | 0 | 37.93357639 | -76.94230311 | 2022-01-04 04:22:17 | Essex, Virginia, US | |
1436047 | 1436047 | 2021-12-28 | US | West Virginia | Gilmer | 54021 | 1582 | 15 | 0 | 38.9251277 | -80.85952723 | 2021-12-29 03:21:43 | Gilmer, West Virginia, US | |
1432916 | 1432916 | 2021-12-28 | US | Alabama | Bullock | 1011 | 1582 | 46 | 0 | 32.10030533 | -85.71265535 | 2021-12-29 03:21:43 | Bullock, Alabama, US | |
734008 | 734008 | 2021-12-27 | US | West Virginia | Gilmer | 54021 | 1582 | 15 | 0 | 38.9251277 | -80.85952723 | 2021-12-28 04:21:47 | Gilmer, West Virginia, US | |
2966568 | 2966568 | 2021-12-24 | US | Texas | Mitchell | 48335 | 1582 | 43 | 0 | 32.30623474 | -100.9212058 | 2021-12-25 04:21:37 | Mitchell, Texas, US | |
1032360 | 1032360 | 2021-12-06 | US | Montana | Beaverhead | 30001 | 1582 | 22 | 0 | 45.13434354 | -112.89846940000001 | 2021-12-07 04:22:34 | Beaverhead, Montana, US | |
1744051 | 1744051 | 2021-12-05 | US | West Virginia | Ritchie | 54085 | 1582 | 22 | 0 | 39.18094587 | -81.06356878 | 2021-12-06 04:22:34 | Ritchie, West Virginia, US | |
1742523 | 1742523 | 2021-12-05 | US | Montana | Beaverhead | 30001 | 1582 | 22 | 0 | 45.13434354 | -112.89846940000001 | 2021-12-06 04:22:34 | Beaverhead, Montana, US | |
1741498 | 1741498 | 2021-12-05 | US | Idaho | Valley | 16085 | 1582 | 13 | 0 | 44.76728382 | -115.5676773 | 2021-12-06 04:22:34 | Valley, Idaho, US | |
1741444 | 1741444 | 2021-12-05 | US | Georgia | Wilkes | 13317 | 1582 | 38 | 0 | 33.78290391 | -82.74286107 | 2021-12-06 04:22:34 | Wilkes, Georgia, US | |
1740399 | 1740399 | 2021-12-05 | Denmark | Greenland | 1582 | 0 | 0 | 71.7069 | -42.6043 | 2021-12-06 04:22:34 | Greenland, Denmark | |||
140697 | 140697 | 2021-12-04 | US | Puerto Rico | Camuy | 72027 | 1582 | 0 | 0 | 18.418578 | -66.860206 | 2021-12-05 04:22:25 | Camuy, Puerto Rico, US | |
139955 | 139955 | 2021-12-04 | US | Montana | Beaverhead | 30001 | 1582 | 22 | 0 | 45.13434354 | -112.89846940000001 | 2021-12-05 04:22:25 | Beaverhead, Montana, US | |
138930 | 138930 | 2021-12-04 | US | Idaho | Valley | 16085 | 1582 | 13 | 0 | 44.76728382 | -115.5676773 | 2021-12-05 04:22:25 | Valley, Idaho, US | |
138876 | 138876 | 2021-12-04 | US | Georgia | Wilkes | 13317 | 1582 | 38 | 0 | 33.78290391 | -82.74286107 | 2021-12-05 04:22:25 | Wilkes, Georgia, US | |
137831 | 137831 | 2021-12-04 | Denmark | Greenland | 1582 | 0 | 0 | 71.7069 | -42.6043 | 2021-12-05 04:22:25 | Greenland, Denmark | |||
2197608 | 2197608 | 2021-12-03 | US | Montana | Beaverhead | 30001 | 1582 | 22 | 0 | 45.13434354 | -112.89846940000001 | 2021-12-04 04:22:18 | Beaverhead, Montana, US | |
2196529 | 2196529 | 2021-12-03 | US | Georgia | Wilkes | 13317 | 1582 | 38 | 0 | 33.78290391 | -82.74286107 | 2021-12-04 04:22:18 | Wilkes, Georgia, 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]);