johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
427 rows where confirmed = 1640 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 405
- China 8
- Japan 3
- Netherlands 2
- Niger 2
- El Salvador 1
- Germany 1
- Italy 1
- Madagascar 1
- Togo 1
- Ukraine 1
- Yemen 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2954520 | 2954520 | 2022-12-20 | US | Texas | Jack | 48237 | 1640 | 31 | 0 | 33.23377248 | -98.17283469 | 2022-12-21 04:21:03 | Jack, Texas, US | |
2954017 | 2954017 | 2022-12-20 | US | Oregon | Lake | 41037 | 1640 | 32 | 0 | 42.79246693 | -120.3850163 | 2022-12-21 04:21:03 | Lake, Oregon, US | |
2953722 | 2953722 | 2022-12-20 | US | North Carolina | Hyde | 37095 | 1640 | 15 | 0 | 35.42017674 | -76.15180542 | 2022-12-21 04:21:03 | Hyde, North Carolina, US | |
2952723 | 2952723 | 2022-12-20 | US | Kansas | Phillips | 20147 | 1640 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-12-21 04:21:03 | Phillips, Kansas, US | |
3176922 | 3176922 | 2022-12-19 | US | Texas | Jack | 48237 | 1640 | 31 | 0 | 33.23377248 | -98.17283469 | 2022-12-20 04:21:04 | Jack, Texas, US | |
3176419 | 3176419 | 2022-12-19 | US | Oregon | Lake | 41037 | 1640 | 32 | 0 | 42.79246693 | -120.3850163 | 2022-12-20 04:21:04 | Lake, Oregon, US | |
3176124 | 3176124 | 2022-12-19 | US | North Carolina | Hyde | 37095 | 1640 | 15 | 0 | 35.42017674 | -76.15180542 | 2022-12-20 04:21:04 | Hyde, North Carolina, US | |
3175125 | 3175125 | 2022-12-19 | US | Kansas | Phillips | 20147 | 1640 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-12-20 04:21:04 | Phillips, Kansas, US | |
1631439 | 1631439 | 2022-12-18 | US | Texas | Jack | 48237 | 1640 | 31 | 0 | 33.23377248 | -98.17283469 | 2022-12-19 04:21:03 | Jack, Texas, US | |
1630936 | 1630936 | 2022-12-18 | US | Oregon | Lake | 41037 | 1640 | 32 | 0 | 42.79246693 | -120.3850163 | 2022-12-19 04:21:03 | Lake, Oregon, US | |
1630641 | 1630641 | 2022-12-18 | US | North Carolina | Hyde | 37095 | 1640 | 15 | 0 | 35.42017674 | -76.15180542 | 2022-12-19 04:21:03 | Hyde, North Carolina, US | |
1629642 | 1629642 | 2022-12-18 | US | Kansas | Phillips | 20147 | 1640 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-12-19 04:21:03 | Phillips, Kansas, US | |
506818 | 506818 | 2022-12-17 | US | Texas | Jack | 48237 | 1640 | 31 | 0 | 33.23377248 | -98.17283469 | 2022-12-18 04:21:03 | Jack, Texas, US | |
506315 | 506315 | 2022-12-17 | US | Oregon | Lake | 41037 | 1640 | 32 | 0 | 42.79246693 | -120.3850163 | 2022-12-18 04:21:03 | Lake, Oregon, US | |
506020 | 506020 | 2022-12-17 | US | North Carolina | Hyde | 37095 | 1640 | 15 | 0 | 35.42017674 | -76.15180542 | 2022-12-18 04:21:03 | Hyde, North Carolina, US | |
505021 | 505021 | 2022-12-17 | US | Kansas | Phillips | 20147 | 1640 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-12-18 04:21:03 | Phillips, Kansas, US | |
3327390 | 3327390 | 2022-12-16 | US | Texas | Jack | 48237 | 1640 | 31 | 0 | 33.23377248 | -98.17283469 | 2022-12-17 04:21:04 | Jack, Texas, US | |
3326887 | 3326887 | 2022-12-16 | US | Oregon | Lake | 41037 | 1640 | 32 | 0 | 42.79246693 | -120.3850163 | 2022-12-17 04:21:04 | Lake, Oregon, US | |
3326592 | 3326592 | 2022-12-16 | US | North Carolina | Hyde | 37095 | 1640 | 15 | 0 | 35.42017674 | -76.15180542 | 2022-12-17 04:21:04 | Hyde, North Carolina, US | |
3325593 | 3325593 | 2022-12-16 | US | Kansas | Phillips | 20147 | 1640 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-12-17 04:21:04 | Phillips, Kansas, US | |
545902 | 545902 | 2022-12-15 | US | Texas | Jack | 48237 | 1640 | 31 | 0 | 33.23377248 | -98.17283469 | 2022-12-16 04:21:01 | Jack, Texas, US | |
545399 | 545399 | 2022-12-15 | US | Oregon | Lake | 41037 | 1640 | 32 | 0 | 42.79246693 | -120.3850163 | 2022-12-16 04:21:01 | Lake, Oregon, US | |
545104 | 545104 | 2022-12-15 | US | North Carolina | Hyde | 37095 | 1640 | 15 | 0 | 35.42017674 | -76.15180542 | 2022-12-16 04:21:01 | Hyde, North Carolina, US | |
544105 | 544105 | 2022-12-15 | US | Kansas | Phillips | 20147 | 1640 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-12-16 04:21:01 | Phillips, Kansas, US | |
351430 | 351430 | 2022-12-14 | US | Texas | Jack | 48237 | 1640 | 31 | 0 | 33.23377248 | -98.17283469 | 2022-12-15 04:20:58 | Jack, Texas, US | |
350927 | 350927 | 2022-12-14 | US | Oregon | Lake | 41037 | 1640 | 32 | 0 | 42.79246693 | -120.3850163 | 2022-12-15 04:20:58 | Lake, Oregon, US | |
350632 | 350632 | 2022-12-14 | US | North Carolina | Hyde | 37095 | 1640 | 15 | 0 | 35.42017674 | -76.15180542 | 2022-12-15 04:20:58 | Hyde, North Carolina, US | |
349633 | 349633 | 2022-12-14 | US | Kansas | Phillips | 20147 | 1640 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-12-15 04:20:58 | Phillips, Kansas, US | |
3717027 | 3717027 | 2022-12-06 | US | South Dakota | Brule | 46015 | 1640 | 27 | 0 | 43.71756379 | -99.08118954 | 2022-12-07 04:20:58 | Brule, South Dakota, US | |
2417732 | 2417732 | 2022-12-05 | US | South Dakota | Brule | 46015 | 1640 | 27 | 0 | 43.71756379 | -99.08118954 | 2022-12-06 04:21:03 | Brule, South Dakota, US | |
721340 | 721340 | 2022-12-04 | US | South Dakota | Brule | 46015 | 1640 | 27 | 0 | 43.71756379 | -99.08118954 | 2022-12-05 04:20:58 | Brule, South Dakota, US | |
2819629 | 2819629 | 2022-12-03 | US | South Dakota | Brule | 46015 | 1640 | 27 | 0 | 43.71756379 | -99.08118954 | 2022-12-04 04:20:56 | Brule, South Dakota, US | |
836485 | 836485 | 2022-12-02 | US | South Dakota | Brule | 46015 | 1640 | 27 | 0 | 43.71756379 | -99.08118954 | 2022-12-03 04:21:02 | Brule, South Dakota, US | |
2139015 | 2139015 | 2022-12-01 | US | South Dakota | Brule | 46015 | 1640 | 27 | 0 | 43.71756379 | -99.08118954 | 2022-12-02 04:21:07 | Brule, South Dakota, US | |
1967431 | 1967431 | 2022-11-30 | US | South Dakota | Brule | 46015 | 1640 | 27 | 0 | 43.71756379 | -99.08118954 | 2022-12-01 04:21:03 | Brule, South Dakota, US | |
479399 | 479399 | 2022-11-08 | China | Shanxi | 1640 | 0 | 0 | 37.5777 | 112.2922 | 2022-11-09 04:21:22 | Shanxi, China | |||
2438525 | 2438525 | 2022-11-07 | China | Chongqing | 1640 | 6 | 0 | 30.0572 | 107.874 | 2022-11-08 04:21:21 | Chongqing, China | |||
2273797 | 2273797 | 2022-10-20 | US | Missouri | Atchison | 29005 | 1640 | 24 | 0 | 40.43238737 | -95.42970639 | 2022-10-21 04:22:23 | Atchison, Missouri, US | |
200132 | 200132 | 2022-10-19 | US | Missouri | Atchison | 29005 | 1640 | 24 | 0 | 40.43238737 | -95.42970639 | 2022-10-20 04:22:59 | Atchison, Missouri, US | |
2759713 | 2759713 | 2022-10-18 | US | Puerto Rico | Vieques | 72147 | 1640 | 0 | 0 | 18.123276 | -65.440971 | 2022-10-19 04:22:26 | Vieques, Puerto Rico, US | |
2758793 | 2758793 | 2022-10-18 | US | Missouri | Atchison | 29005 | 1640 | 24 | 0 | 40.43238737 | -95.42970639 | 2022-10-19 04:22:26 | Atchison, Missouri, US | |
2026627 | 2026627 | 2022-10-17 | US | Missouri | Atchison | 29005 | 1640 | 24 | 0 | 40.43238737 | -95.42970639 | 2022-10-18 04:22:42 | Atchison, Missouri, US | |
2162706 | 2162706 | 2022-10-16 | US | Texas | McCulloch | 48307 | 1640 | 49 | 0 | 31.1925468 | -99.34682807 | 2022-10-17 04:20:31 | McCulloch, Texas, US | |
2161405 | 2161405 | 2022-10-16 | US | Missouri | Atchison | 29005 | 1640 | 24 | 0 | 40.43238737 | -95.42970639 | 2022-10-17 04:20:31 | Atchison, Missouri, US | |
518903 | 518903 | 2022-10-15 | US | Texas | McCulloch | 48307 | 1640 | 49 | 0 | 31.1925468 | -99.34682807 | 2022-10-16 04:22:39 | McCulloch, Texas, US | |
517602 | 517602 | 2022-10-15 | US | Missouri | Atchison | 29005 | 1640 | 24 | 0 | 40.43238737 | -95.42970639 | 2022-10-16 04:22:39 | Atchison, Missouri, US | |
2035960 | 2035960 | 2022-10-14 | US | Texas | McCulloch | 48307 | 1640 | 49 | 0 | 31.1925468 | -99.34682807 | 2022-10-15 04:22:00 | McCulloch, Texas, US | |
2034659 | 2034659 | 2022-10-14 | US | Missouri | Atchison | 29005 | 1640 | 24 | 0 | 40.43238737 | -95.42970639 | 2022-10-15 04:22:00 | Atchison, Missouri, US | |
3756648 | 3756648 | 2022-10-13 | US | Texas | McCulloch | 48307 | 1640 | 49 | 0 | 31.1925468 | -99.34682807 | 2022-10-14 04:22:28 | McCulloch, Texas, US | |
3217473 | 3217473 | 2022-10-12 | US | Texas | McCulloch | 48307 | 1640 | 49 | 0 | 31.1925468 | -99.34682807 | 2022-10-13 04:22:39 | McCulloch, Texas, US | |
3253322 | 3253322 | 2022-10-11 | US | Texas | McCulloch | 48307 | 1640 | 49 | 0 | 31.1925468 | -99.34682807 | 2022-10-12 04:22:51 | McCulloch, Texas, US | |
2970581 | 2970581 | 2022-10-10 | US | Texas | McCulloch | 48307 | 1640 | 49 | 0 | 31.1925468 | -99.34682807 | 2022-10-11 04:23:05 | McCulloch, Texas, US | |
131876 | 131876 | 2022-10-04 | US | Indiana | Ohio | 18115 | 1640 | 19 | 0 | 38.955305 | -84.96515993 | 2022-10-05 04:23:06 | Ohio, Indiana, US | |
2686823 | 2686823 | 2022-10-03 | US | Indiana | Ohio | 18115 | 1640 | 19 | 0 | 38.955305 | -84.96515993 | 2022-10-04 04:22:55 | Ohio, Indiana, US | |
2260890 | 2260890 | 2022-10-02 | US | Indiana | Ohio | 18115 | 1640 | 19 | 0 | 38.955305 | -84.96515993 | 2022-10-03 04:23:11 | Ohio, Indiana, US | |
2996416 | 2996416 | 2022-10-01 | US | Indiana | Ohio | 18115 | 1640 | 19 | 0 | 38.955305 | -84.96515993 | 2022-10-02 04:21:23 | Ohio, Indiana, US | |
854742 | 854742 | 2022-09-30 | US | Indiana | Ohio | 18115 | 1640 | 19 | 0 | 38.955305 | -84.96515993 | 2022-10-01 04:23:01 | Ohio, Indiana, US | |
2376668 | 2376668 | 2022-09-29 | US | Indiana | Ohio | 18115 | 1640 | 19 | 0 | 38.955305 | -84.96515993 | 2022-09-30 04:23:09 | Ohio, Indiana, US | |
1561219 | 1561219 | 2022-09-28 | US | Indiana | Ohio | 18115 | 1640 | 19 | 0 | 38.955305 | -84.96515993 | 2022-09-29 04:22:34 | Ohio, Indiana, US | |
1979784 | 1979784 | 2022-09-25 | US | Texas | Lynn | 48305 | 1640 | 40 | 0 | 33.17657705 | -101.8162849 | 2022-09-26 04:20:52 | Lynn, Texas, US | |
2652951 | 2652951 | 2022-09-24 | US | Texas | Lynn | 48305 | 1640 | 40 | 0 | 33.17657705 | -101.8162849 | 2022-09-25 04:23:31 | Lynn, Texas, US | |
387391 | 387391 | 2022-09-23 | US | Texas | Lynn | 48305 | 1640 | 40 | 0 | 33.17657705 | -101.8162849 | 2022-09-24 04:21:40 | Lynn, Texas, US | |
3988524 | 3988524 | 2022-09-15 | US | Missouri | Dade | 29057 | 1640 | 43 | 0 | 37.431814 | -93.8503345 | 2022-09-16 04:21:19 | Dade, Missouri, US | |
1891041 | 1891041 | 2022-09-14 | US | Missouri | Dade | 29057 | 1640 | 43 | 0 | 37.431814 | -93.8503345 | 2022-09-15 04:21:02 | Dade, Missouri, US | |
374096 | 374096 | 2022-09-13 | US | Missouri | Dade | 29057 | 1640 | 43 | 0 | 37.431814 | -93.8503345 | 2022-09-14 04:20:44 | Dade, Missouri, US | |
2396698 | 2396698 | 2022-09-12 | US | Missouri | Dade | 29057 | 1640 | 43 | 0 | 37.431814 | -93.8503345 | 2022-09-13 04:20:57 | Dade, Missouri, US | |
3767776 | 3767776 | 2022-09-11 | US | Missouri | Dade | 29057 | 1640 | 43 | 0 | 37.431814 | -93.8503345 | 2022-09-12 04:20:58 | Dade, Missouri, US | |
3826351 | 3826351 | 2022-09-10 | US | Missouri | Dade | 29057 | 1640 | 43 | 0 | 37.431814 | -93.8503345 | 2022-09-11 04:20:50 | Dade, Missouri, US | |
964808 | 964808 | 2022-09-09 | US | Missouri | Dade | 29057 | 1640 | 43 | 0 | 37.431814 | -93.8503345 | 2022-09-10 04:21:10 | Dade, Missouri, US | |
3649980 | 3649980 | 2022-08-14 | US | North Dakota | Dickey | 38021 | 1640 | 39 | 0 | 46.11017712 | -98.5049008 | 2022-08-15 04:20:59 | Dickey, North Dakota, US | |
1970986 | 1970986 | 2022-08-13 | US | North Dakota | Dickey | 38021 | 1640 | 39 | 0 | 46.11017712 | -98.5049008 | 2022-08-14 04:20:55 | Dickey, North Dakota, US | |
2890795 | 2890795 | 2022-08-12 | US | North Dakota | Dickey | 38021 | 1640 | 39 | 0 | 46.11017712 | -98.5049008 | 2022-08-13 04:20:52 | Dickey, North Dakota, US | |
2742977 | 2742977 | 2022-07-07 | US | Missouri | Shannon | 29203 | 1640 | 40 | 0 | 37.15772072 | -91.40190382 | 2022-07-08 04:20:56 | Shannon, Missouri, US | |
1201772 | 1201772 | 2022-07-06 | US | Missouri | Shannon | 29203 | 1640 | 40 | 0 | 37.15772072 | -91.40190382 | 2022-07-07 04:20:55 | Shannon, Missouri, US | |
3968515 | 3968515 | 2022-07-05 | US | Missouri | Shannon | 29203 | 1640 | 40 | 0 | 37.15772072 | -91.40190382 | 2022-07-06 04:20:58 | Shannon, Missouri, US | |
3080026 | 3080026 | 2022-07-04 | US | Missouri | Shannon | 29203 | 1640 | 40 | 0 | 37.15772072 | -91.40190382 | 2022-07-05 04:20:45 | Shannon, Missouri, US | |
1769308 | 1769308 | 2022-07-03 | US | Missouri | Shannon | 29203 | 1640 | 40 | 0 | 37.15772072 | -91.40190382 | 2022-07-04 04:20:54 | Shannon, Missouri, US | |
3367294 | 3367294 | 2022-07-02 | US | Missouri | Shannon | 29203 | 1640 | 40 | 0 | 37.15772072 | -91.40190382 | 2022-07-03 04:20:59 | Shannon, Missouri, US | |
595623 | 595623 | 2022-07-01 | US | Missouri | Shannon | 29203 | 1640 | 40 | 0 | 37.15772072 | -91.40190382 | 2022-07-02 04:21:16 | Shannon, Missouri, US | |
1650309 | 1650309 | 2022-06-23 | US | Missouri | Maries | 29125 | 1640 | 39 | 0 | 38.16193985 | -91.92249662 | 2022-06-24 04:20:58 | Maries, Missouri, US | |
2189544 | 2189544 | 2022-06-22 | US | Missouri | Maries | 29125 | 1640 | 39 | 0 | 38.16193985 | -91.92249662 | 2022-06-23 04:20:55 | Maries, Missouri, US | |
167975 | 167975 | 2022-06-21 | US | Missouri | Maries | 29125 | 1640 | 39 | 0 | 38.16193985 | -91.92249662 | 2022-06-22 04:20:54 | Maries, Missouri, US | |
1765258 | 1765258 | 2022-06-20 | US | Missouri | Maries | 29125 | 1640 | 39 | 0 | 38.16193985 | -91.92249662 | 2022-06-21 04:20:56 | Maries, Missouri, US | |
3271444 | 3271444 | 2022-06-19 | US | Missouri | Maries | 29125 | 1640 | 39 | 0 | 38.16193985 | -91.92249662 | 2022-06-20 04:21:01 | Maries, Missouri, US | |
3399356 | 3399356 | 2022-06-18 | US | Missouri | Maries | 29125 | 1640 | 39 | 0 | 38.16193985 | -91.92249662 | 2022-06-19 04:20:51 | Maries, Missouri, US | |
2313233 | 2313233 | 2022-06-17 | US | Missouri | Maries | 29125 | 1640 | 39 | 0 | 38.16193985 | -91.92249662 | 2022-06-18 04:21:10 | Maries, Missouri, US | |
3985629 | 3985629 | 2022-06-15 | US | Texas | Bailey | 48017 | 1640 | 39 | 0 | 34.06854817 | -102.8299707 | 2022-06-16 04:20:55 | Bailey, Texas, US | |
1169830 | 1169830 | 2022-05-20 | US | Colorado | Kit Carson | 8063 | 1640 | 33 | 0 | 39.30497777 | -102.6022199 | 2022-05-21 04:20:58 | Kit Carson, Colorado, US | |
3896593 | 3896593 | 2022-05-19 | US | Colorado | Kit Carson | 8063 | 1640 | 33 | 0 | 39.30497777 | -102.6022199 | 2022-05-20 04:20:57 | Kit Carson, Colorado, US | |
2534756 | 2534756 | 2022-05-12 | US | Kansas | Wabaunsee | 20197 | 1640 | 23 | 0 | 38.95471985 | -96.20350509 | 2022-05-13 04:20:51 | Wabaunsee, Kansas, US | |
3446202 | 3446202 | 2022-05-11 | US | Kansas | Wabaunsee | 20197 | 1640 | 23 | 0 | 38.95471985 | -96.20350509 | 2022-05-12 04:20:54 | Wabaunsee, Kansas, US | |
3536819 | 3536819 | 2022-05-10 | US | Kansas | Wabaunsee | 20197 | 1640 | 23 | 0 | 38.95471985 | -96.20350509 | 2022-05-11 04:20:48 | Wabaunsee, Kansas, US | |
223354 | 223354 | 2022-05-09 | US | Kansas | Wabaunsee | 20197 | 1640 | 23 | 0 | 38.95471985 | -96.20350509 | 2022-05-10 04:20:50 | Wabaunsee, Kansas, US | |
2332739 | 2332739 | 2022-05-08 | US | Kansas | Wabaunsee | 20197 | 1640 | 23 | 0 | 38.95471985 | -96.20350509 | 2022-05-09 04:20:54 | Wabaunsee, Kansas, US | |
361701 | 361701 | 2022-05-07 | US | Kansas | Wabaunsee | 20197 | 1640 | 23 | 0 | 38.95471985 | -96.20350509 | 2022-05-08 04:20:49 | Wabaunsee, Kansas, US | |
1400746 | 1400746 | 2022-05-06 | US | Texas | Coleman | 48083 | 1640 | 71 | 0 | 31.76736834 | -99.45240766 | 2022-05-07 04:21:09 | Coleman, Texas, US | |
1399052 | 1399052 | 2022-05-06 | US | Kansas | Wabaunsee | 20197 | 1640 | 23 | 0 | 38.95471985 | -96.20350509 | 2022-05-07 04:21:09 | Wabaunsee, Kansas, US | |
2601101 | 2601101 | 2022-05-05 | US | Texas | Coleman | 48083 | 1640 | 71 | 0 | 31.76736834 | -99.45240766 | 2022-05-06 04:21:00 | Coleman, Texas, US | |
1993956 | 1993956 | 2022-03-01 | US | Kansas | Harper | 20077 | 1640 | 25 | 0 | 37.19175361 | -98.07578384 | 2022-03-02 04:21:07 | Harper, Kansas, US | |
944130 | 944130 | 2022-02-28 | US | Kansas | Harper | 20077 | 1640 | 25 | 0 | 37.19175361 | -98.07578384 | 2022-03-01 04:21:09 | Harper, Kansas, 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]);