daily_reports (view)
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
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-20 | US | Texas | Jack | 48237 | 1640 | 31 | 0 | 33.23377248 | -98.17283469 | 2022-12-21 04:21:03 | Jack, Texas, US | |
2022-12-20 | US | Oregon | Lake | 41037 | 1640 | 32 | 0 | 42.79246693 | -120.3850163 | 2022-12-21 04:21:03 | Lake, Oregon, US | |
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 | |
2022-12-20 | US | Kansas | Phillips | 20147 | 1640 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-12-21 04:21:03 | Phillips, Kansas, US | |
2022-12-19 | US | Texas | Jack | 48237 | 1640 | 31 | 0 | 33.23377248 | -98.17283469 | 2022-12-20 04:21:04 | Jack, Texas, US | |
2022-12-19 | US | Oregon | Lake | 41037 | 1640 | 32 | 0 | 42.79246693 | -120.3850163 | 2022-12-20 04:21:04 | Lake, Oregon, US | |
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 | |
2022-12-19 | US | Kansas | Phillips | 20147 | 1640 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-12-20 04:21:04 | Phillips, Kansas, US | |
2022-12-18 | US | Texas | Jack | 48237 | 1640 | 31 | 0 | 33.23377248 | -98.17283469 | 2022-12-19 04:21:03 | Jack, Texas, US | |
2022-12-18 | US | Oregon | Lake | 41037 | 1640 | 32 | 0 | 42.79246693 | -120.3850163 | 2022-12-19 04:21:03 | Lake, Oregon, US | |
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 | |
2022-12-18 | US | Kansas | Phillips | 20147 | 1640 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-12-19 04:21:03 | Phillips, Kansas, US | |
2022-12-17 | US | Texas | Jack | 48237 | 1640 | 31 | 0 | 33.23377248 | -98.17283469 | 2022-12-18 04:21:03 | Jack, Texas, US | |
2022-12-17 | US | Oregon | Lake | 41037 | 1640 | 32 | 0 | 42.79246693 | -120.3850163 | 2022-12-18 04:21:03 | Lake, Oregon, US | |
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 | |
2022-12-17 | US | Kansas | Phillips | 20147 | 1640 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-12-18 04:21:03 | Phillips, Kansas, US | |
2022-12-16 | US | Texas | Jack | 48237 | 1640 | 31 | 0 | 33.23377248 | -98.17283469 | 2022-12-17 04:21:04 | Jack, Texas, US | |
2022-12-16 | US | Oregon | Lake | 41037 | 1640 | 32 | 0 | 42.79246693 | -120.3850163 | 2022-12-17 04:21:04 | Lake, Oregon, US | |
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 | |
2022-12-16 | US | Kansas | Phillips | 20147 | 1640 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-12-17 04:21:04 | Phillips, Kansas, US | |
2022-12-15 | US | Texas | Jack | 48237 | 1640 | 31 | 0 | 33.23377248 | -98.17283469 | 2022-12-16 04:21:01 | Jack, Texas, US | |
2022-12-15 | US | Oregon | Lake | 41037 | 1640 | 32 | 0 | 42.79246693 | -120.3850163 | 2022-12-16 04:21:01 | Lake, Oregon, US | |
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 | |
2022-12-15 | US | Kansas | Phillips | 20147 | 1640 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-12-16 04:21:01 | Phillips, Kansas, US | |
2022-12-14 | US | Texas | Jack | 48237 | 1640 | 31 | 0 | 33.23377248 | -98.17283469 | 2022-12-15 04:20:58 | Jack, Texas, US | |
2022-12-14 | US | Oregon | Lake | 41037 | 1640 | 32 | 0 | 42.79246693 | -120.3850163 | 2022-12-15 04:20:58 | Lake, Oregon, US | |
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 | |
2022-12-14 | US | Kansas | Phillips | 20147 | 1640 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-12-15 04:20:58 | Phillips, Kansas, US | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
2022-11-08 | China | Shanxi | 1640 | 0 | 0 | 37.5777 | 112.2922 | 2022-11-09 04:21:22 | Shanxi, China | |||
2022-11-07 | China | Chongqing | 1640 | 6 | 0 | 30.0572 | 107.874 | 2022-11-08 04:21:21 | Chongqing, China | |||
2022-10-20 | US | Missouri | Atchison | 29005 | 1640 | 24 | 0 | 40.43238737 | -95.42970639 | 2022-10-21 04:22:23 | Atchison, Missouri, US | |
2022-10-19 | US | Missouri | Atchison | 29005 | 1640 | 24 | 0 | 40.43238737 | -95.42970639 | 2022-10-20 04:22:59 | Atchison, Missouri, US | |
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 | |
2022-10-18 | US | Missouri | Atchison | 29005 | 1640 | 24 | 0 | 40.43238737 | -95.42970639 | 2022-10-19 04:22:26 | Atchison, Missouri, US | |
2022-10-17 | US | Missouri | Atchison | 29005 | 1640 | 24 | 0 | 40.43238737 | -95.42970639 | 2022-10-18 04:22:42 | Atchison, Missouri, US | |
2022-10-16 | US | Texas | McCulloch | 48307 | 1640 | 49 | 0 | 31.1925468 | -99.34682807 | 2022-10-17 04:20:31 | McCulloch, Texas, US | |
2022-10-16 | US | Missouri | Atchison | 29005 | 1640 | 24 | 0 | 40.43238737 | -95.42970639 | 2022-10-17 04:20:31 | Atchison, Missouri, US | |
2022-10-15 | US | Texas | McCulloch | 48307 | 1640 | 49 | 0 | 31.1925468 | -99.34682807 | 2022-10-16 04:22:39 | McCulloch, Texas, US | |
2022-10-15 | US | Missouri | Atchison | 29005 | 1640 | 24 | 0 | 40.43238737 | -95.42970639 | 2022-10-16 04:22:39 | Atchison, Missouri, US | |
2022-10-14 | US | Texas | McCulloch | 48307 | 1640 | 49 | 0 | 31.1925468 | -99.34682807 | 2022-10-15 04:22:00 | McCulloch, Texas, US | |
2022-10-14 | US | Missouri | Atchison | 29005 | 1640 | 24 | 0 | 40.43238737 | -95.42970639 | 2022-10-15 04:22:00 | Atchison, Missouri, US | |
2022-10-13 | US | Texas | McCulloch | 48307 | 1640 | 49 | 0 | 31.1925468 | -99.34682807 | 2022-10-14 04:22:28 | McCulloch, Texas, US | |
2022-10-12 | US | Texas | McCulloch | 48307 | 1640 | 49 | 0 | 31.1925468 | -99.34682807 | 2022-10-13 04:22:39 | McCulloch, Texas, US | |
2022-10-11 | US | Texas | McCulloch | 48307 | 1640 | 49 | 0 | 31.1925468 | -99.34682807 | 2022-10-12 04:22:51 | McCulloch, Texas, US | |
2022-10-10 | US | Texas | McCulloch | 48307 | 1640 | 49 | 0 | 31.1925468 | -99.34682807 | 2022-10-11 04:23:05 | McCulloch, Texas, US | |
2022-10-04 | US | Indiana | Ohio | 18115 | 1640 | 19 | 0 | 38.955305 | -84.96515993 | 2022-10-05 04:23:06 | Ohio, Indiana, US | |
2022-10-03 | US | Indiana | Ohio | 18115 | 1640 | 19 | 0 | 38.955305 | -84.96515993 | 2022-10-04 04:22:55 | Ohio, Indiana, US | |
2022-10-02 | US | Indiana | Ohio | 18115 | 1640 | 19 | 0 | 38.955305 | -84.96515993 | 2022-10-03 04:23:11 | Ohio, Indiana, US | |
2022-10-01 | US | Indiana | Ohio | 18115 | 1640 | 19 | 0 | 38.955305 | -84.96515993 | 2022-10-02 04:21:23 | Ohio, Indiana, US | |
2022-09-30 | US | Indiana | Ohio | 18115 | 1640 | 19 | 0 | 38.955305 | -84.96515993 | 2022-10-01 04:23:01 | Ohio, Indiana, US | |
2022-09-29 | US | Indiana | Ohio | 18115 | 1640 | 19 | 0 | 38.955305 | -84.96515993 | 2022-09-30 04:23:09 | Ohio, Indiana, US | |
2022-09-28 | US | Indiana | Ohio | 18115 | 1640 | 19 | 0 | 38.955305 | -84.96515993 | 2022-09-29 04:22:34 | Ohio, Indiana, US | |
2022-09-25 | US | Texas | Lynn | 48305 | 1640 | 40 | 0 | 33.17657705 | -101.8162849 | 2022-09-26 04:20:52 | Lynn, Texas, US | |
2022-09-24 | US | Texas | Lynn | 48305 | 1640 | 40 | 0 | 33.17657705 | -101.8162849 | 2022-09-25 04:23:31 | Lynn, Texas, US | |
2022-09-23 | US | Texas | Lynn | 48305 | 1640 | 40 | 0 | 33.17657705 | -101.8162849 | 2022-09-24 04:21:40 | Lynn, Texas, US | |
2022-09-15 | US | Missouri | Dade | 29057 | 1640 | 43 | 0 | 37.431814 | -93.8503345 | 2022-09-16 04:21:19 | Dade, Missouri, US | |
2022-09-14 | US | Missouri | Dade | 29057 | 1640 | 43 | 0 | 37.431814 | -93.8503345 | 2022-09-15 04:21:02 | Dade, Missouri, US | |
2022-09-13 | US | Missouri | Dade | 29057 | 1640 | 43 | 0 | 37.431814 | -93.8503345 | 2022-09-14 04:20:44 | Dade, Missouri, US | |
2022-09-12 | US | Missouri | Dade | 29057 | 1640 | 43 | 0 | 37.431814 | -93.8503345 | 2022-09-13 04:20:57 | Dade, Missouri, US | |
2022-09-11 | US | Missouri | Dade | 29057 | 1640 | 43 | 0 | 37.431814 | -93.8503345 | 2022-09-12 04:20:58 | Dade, Missouri, US | |
2022-09-10 | US | Missouri | Dade | 29057 | 1640 | 43 | 0 | 37.431814 | -93.8503345 | 2022-09-11 04:20:50 | Dade, Missouri, US | |
2022-09-09 | US | Missouri | Dade | 29057 | 1640 | 43 | 0 | 37.431814 | -93.8503345 | 2022-09-10 04:21:10 | Dade, Missouri, US | |
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 | |
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 | |
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 | |
2022-07-07 | US | Missouri | Shannon | 29203 | 1640 | 40 | 0 | 37.15772072 | -91.40190382 | 2022-07-08 04:20:56 | Shannon, Missouri, US | |
2022-07-06 | US | Missouri | Shannon | 29203 | 1640 | 40 | 0 | 37.15772072 | -91.40190382 | 2022-07-07 04:20:55 | Shannon, Missouri, US | |
2022-07-05 | US | Missouri | Shannon | 29203 | 1640 | 40 | 0 | 37.15772072 | -91.40190382 | 2022-07-06 04:20:58 | Shannon, Missouri, US | |
2022-07-04 | US | Missouri | Shannon | 29203 | 1640 | 40 | 0 | 37.15772072 | -91.40190382 | 2022-07-05 04:20:45 | Shannon, Missouri, US | |
2022-07-03 | US | Missouri | Shannon | 29203 | 1640 | 40 | 0 | 37.15772072 | -91.40190382 | 2022-07-04 04:20:54 | Shannon, Missouri, US | |
2022-07-02 | US | Missouri | Shannon | 29203 | 1640 | 40 | 0 | 37.15772072 | -91.40190382 | 2022-07-03 04:20:59 | Shannon, Missouri, US | |
2022-07-01 | US | Missouri | Shannon | 29203 | 1640 | 40 | 0 | 37.15772072 | -91.40190382 | 2022-07-02 04:21:16 | Shannon, Missouri, US | |
2022-06-23 | US | Missouri | Maries | 29125 | 1640 | 39 | 0 | 38.16193985 | -91.92249662 | 2022-06-24 04:20:58 | Maries, Missouri, US | |
2022-06-22 | US | Missouri | Maries | 29125 | 1640 | 39 | 0 | 38.16193985 | -91.92249662 | 2022-06-23 04:20:55 | Maries, Missouri, US | |
2022-06-21 | US | Missouri | Maries | 29125 | 1640 | 39 | 0 | 38.16193985 | -91.92249662 | 2022-06-22 04:20:54 | Maries, Missouri, US | |
2022-06-20 | US | Missouri | Maries | 29125 | 1640 | 39 | 0 | 38.16193985 | -91.92249662 | 2022-06-21 04:20:56 | Maries, Missouri, US | |
2022-06-19 | US | Missouri | Maries | 29125 | 1640 | 39 | 0 | 38.16193985 | -91.92249662 | 2022-06-20 04:21:01 | Maries, Missouri, US | |
2022-06-18 | US | Missouri | Maries | 29125 | 1640 | 39 | 0 | 38.16193985 | -91.92249662 | 2022-06-19 04:20:51 | Maries, Missouri, US | |
2022-06-17 | US | Missouri | Maries | 29125 | 1640 | 39 | 0 | 38.16193985 | -91.92249662 | 2022-06-18 04:21:10 | Maries, Missouri, US | |
2022-06-15 | US | Texas | Bailey | 48017 | 1640 | 39 | 0 | 34.06854817 | -102.8299707 | 2022-06-16 04:20:55 | Bailey, Texas, US | |
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 | |
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 | |
2022-05-12 | US | Kansas | Wabaunsee | 20197 | 1640 | 23 | 0 | 38.95471985 | -96.20350509 | 2022-05-13 04:20:51 | Wabaunsee, Kansas, US | |
2022-05-11 | US | Kansas | Wabaunsee | 20197 | 1640 | 23 | 0 | 38.95471985 | -96.20350509 | 2022-05-12 04:20:54 | Wabaunsee, Kansas, US | |
2022-05-10 | US | Kansas | Wabaunsee | 20197 | 1640 | 23 | 0 | 38.95471985 | -96.20350509 | 2022-05-11 04:20:48 | Wabaunsee, Kansas, US | |
2022-05-09 | US | Kansas | Wabaunsee | 20197 | 1640 | 23 | 0 | 38.95471985 | -96.20350509 | 2022-05-10 04:20:50 | Wabaunsee, Kansas, US | |
2022-05-08 | US | Kansas | Wabaunsee | 20197 | 1640 | 23 | 0 | 38.95471985 | -96.20350509 | 2022-05-09 04:20:54 | Wabaunsee, Kansas, US | |
2022-05-07 | US | Kansas | Wabaunsee | 20197 | 1640 | 23 | 0 | 38.95471985 | -96.20350509 | 2022-05-08 04:20:49 | Wabaunsee, Kansas, US | |
2022-05-06 | US | Texas | Coleman | 48083 | 1640 | 71 | 0 | 31.76736834 | -99.45240766 | 2022-05-07 04:21:09 | Coleman, Texas, US | |
2022-05-06 | US | Kansas | Wabaunsee | 20197 | 1640 | 23 | 0 | 38.95471985 | -96.20350509 | 2022-05-07 04:21:09 | Wabaunsee, Kansas, US | |
2022-05-05 | US | Texas | Coleman | 48083 | 1640 | 71 | 0 | 31.76736834 | -99.45240766 | 2022-05-06 04:21:00 | Coleman, Texas, US | |
2022-03-01 | US | Kansas | Harper | 20077 | 1640 | 25 | 0 | 37.19175361 | -98.07578384 | 2022-03-02 04:21:07 | Harper, Kansas, US | |
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 VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;