daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
490 rows where confirmed = 1345 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-27 | US | Kansas | Meade | 20119 | 1345 | 24 | 0 | 37.23859987 | -100.364831 | 2022-12-28 04:21:04 | Meade, Kansas, US | |
2022-12-26 | US | Kansas | Meade | 20119 | 1345 | 24 | 0 | 37.23859987 | -100.364831 | 2022-12-27 04:21:07 | Meade, Kansas, US | |
2022-12-25 | US | Kansas | Meade | 20119 | 1345 | 24 | 0 | 37.23859987 | -100.364831 | 2022-12-26 04:21:06 | Meade, Kansas, US | |
2022-12-24 | US | Kansas | Meade | 20119 | 1345 | 24 | 0 | 37.23859987 | -100.364831 | 2022-12-25 04:21:04 | Meade, Kansas, US | |
2022-12-23 | US | Kansas | Meade | 20119 | 1345 | 24 | 0 | 37.23859987 | -100.364831 | 2022-12-24 04:21:02 | Meade, Kansas, US | |
2022-12-22 | US | Kansas | Meade | 20119 | 1345 | 24 | 0 | 37.23859987 | -100.364831 | 2022-12-23 04:21:04 | Meade, Kansas, US | |
2022-12-21 | US | Kansas | Meade | 20119 | 1345 | 24 | 0 | 37.23859987 | -100.364831 | 2022-12-22 04:20:56 | Meade, Kansas, US | |
2022-12-19 | US | Virginia | Surry | 51181 | 1345 | 22 | 0 | 37.11781893 | -76.88450012 | 2022-12-20 04:21:04 | Surry, Virginia, US | |
2022-11-29 | US | Georgia | Schley | 13249 | 1345 | 11 | 0 | 32.2654021 | -84.31258912 | 2022-11-30 04:21:07 | Schley, Georgia, US | |
2022-11-28 | US | Georgia | Schley | 13249 | 1345 | 11 | 0 | 32.2654021 | -84.31258912 | 2022-11-29 04:21:05 | Schley, Georgia, US | |
2022-11-27 | US | Georgia | Schley | 13249 | 1345 | 11 | 0 | 32.2654021 | -84.31258912 | 2022-11-28 04:21:02 | Schley, Georgia, US | |
2022-11-26 | US | Georgia | Schley | 13249 | 1345 | 11 | 0 | 32.2654021 | -84.31258912 | 2022-11-27 04:21:05 | Schley, Georgia, US | |
2022-11-25 | US | Georgia | Schley | 13249 | 1345 | 11 | 0 | 32.2654021 | -84.31258912 | 2022-11-26 04:21:11 | Schley, Georgia, US | |
2022-11-24 | US | Georgia | Schley | 13249 | 1345 | 11 | 0 | 32.2654021 | -84.31258912 | 2022-11-25 04:21:06 | Schley, Georgia, US | |
2022-11-23 | US | Georgia | Schley | 13249 | 1345 | 11 | 0 | 32.2654021 | -84.31258912 | 2022-11-24 04:21:09 | Schley, Georgia, US | |
2022-11-02 | US | Illinois | Putnam | 17155 | 1345 | 11 | 0 | 41.2013541 | -89.2869272 | 2022-11-03 04:22:05 | Putnam, Illinois, US | |
2022-11-01 | US | Illinois | Putnam | 17155 | 1345 | 11 | 0 | 41.2013541 | -89.2869272 | 2022-11-02 04:22:09 | Putnam, Illinois, US | |
2022-10-02 | US | Oklahoma | Unassigned | 90040 | 1345 | 2101 | 0 | 36.83532655 | 0.0 | 2022-10-03 04:23:11 | Unassigned, Oklahoma, US | |
2022-10-01 | US | Oklahoma | Unassigned | 90040 | 1345 | 2101 | 0 | 36.83532655 | 0.0 | 2022-10-02 04:21:23 | Unassigned, Oklahoma, US | |
2022-09-30 | US | Oklahoma | Unassigned | 90040 | 1345 | 2101 | 0 | 36.83532655 | 0.0 | 2022-10-01 04:23:01 | Unassigned, Oklahoma, US | |
2022-09-29 | US | Oklahoma | Unassigned | 90040 | 1345 | 2101 | 0 | 36.83532655 | 0.0 | 2022-09-30 04:23:09 | Unassigned, Oklahoma, US | |
2022-09-25 | China | Tibet | 1345 | 0 | 0 | 31.6927 | 88.0924 | 2022-09-26 04:20:52 | Tibet, China | |||
2022-09-22 | US | Montana | Toole | 30101 | 1345 | 25 | 0 | 48.65577551 | -111.6942414 | 2022-09-23 04:23:13 | Toole, Montana, US | |
2022-09-21 | US | Montana | Toole | 30101 | 1345 | 25 | 0 | 48.65577551 | -111.6942414 | 2022-09-22 04:22:56 | Toole, Montana, US | |
2022-09-20 | US | Montana | Toole | 30101 | 1345 | 25 | 0 | 48.65577551 | -111.6942414 | 2022-09-21 04:23:22 | Toole, Montana, US | |
2022-09-19 | US | Montana | Toole | 30101 | 1345 | 25 | 0 | 48.65577551 | -111.6942414 | 2022-09-20 04:22:48 | Toole, Montana, US | |
2022-09-18 | US | Montana | Toole | 30101 | 1345 | 25 | 0 | 48.65577551 | -111.6942414 | 2022-09-19 04:21:49 | Toole, Montana, US | |
2022-09-17 | US | Montana | Toole | 30101 | 1345 | 25 | 0 | 48.65577551 | -111.6942414 | 2022-09-18 04:22:50 | Toole, Montana, US | |
2022-09-16 | US | Montana | Toole | 30101 | 1345 | 25 | 0 | 48.65577551 | -111.6942414 | 2022-09-17 04:20:19 | Toole, Montana, US | |
2022-08-29 | China | Gansu | 1345 | 2 | 0 | 35.7518 | 104.2861 | 2022-08-30 04:21:03 | Gansu, China | |||
2022-08-28 | China | Gansu | 1345 | 2 | 0 | 35.7518 | 104.2861 | 2022-08-29 04:21:06 | Gansu, China | |||
2022-07-18 | US | Colorado | Saguache | 8109 | 1345 | 12 | 0 | 38.08054629 | -106.282466 | 2022-07-19 04:20:58 | Saguache, Colorado, US | |
2022-07-14 | US | Texas | Yoakum | 48501 | 1345 | 42 | 0 | 33.17320212 | -102.8276433 | 2022-07-15 04:20:53 | Yoakum, Texas, US | |
2022-07-13 | US | Texas | Yoakum | 48501 | 1345 | 42 | 0 | 33.17320212 | -102.8276433 | 2022-07-14 04:20:57 | Yoakum, Texas, US | |
2022-07-12 | US | Texas | Yoakum | 48501 | 1345 | 42 | 0 | 33.17320212 | -102.8276433 | 2022-07-13 04:20:58 | Yoakum, Texas, US | |
2022-07-11 | US | Texas | Yoakum | 48501 | 1345 | 42 | 0 | 33.17320212 | -102.8276433 | 2022-07-12 04:20:51 | Yoakum, Texas, US | |
2022-07-10 | US | Texas | Yoakum | 48501 | 1345 | 42 | 0 | 33.17320212 | -102.8276433 | 2022-07-11 04:20:46 | Yoakum, Texas, US | |
2022-07-05 | US | Vermont | Essex | 50009 | 1345 | 3 | 0 | 44.72736416 | -71.73579864 | 2022-07-06 04:20:58 | Essex, Vermont, US | |
2022-07-04 | US | Vermont | Essex | 50009 | 1345 | 3 | 0 | 44.72736416 | -71.73579864 | 2022-07-05 04:20:45 | Essex, Vermont, US | |
2022-07-03 | US | Vermont | Essex | 50009 | 1345 | 3 | 0 | 44.72736416 | -71.73579864 | 2022-07-04 04:20:54 | Essex, Vermont, US | |
2022-07-02 | US | Vermont | Essex | 50009 | 1345 | 3 | 0 | 44.72736416 | -71.73579864 | 2022-07-03 04:20:59 | Essex, Vermont, US | |
2022-07-01 | US | Vermont | Essex | 50009 | 1345 | 3 | 0 | 44.72736416 | -71.73579864 | 2022-07-02 04:21:16 | Essex, Vermont, US | |
2022-06-30 | US | Vermont | Essex | 50009 | 1345 | 3 | 0 | 44.72736416 | -71.73579864 | 2022-07-01 04:21:10 | Essex, Vermont, US | |
2022-06-29 | US | Vermont | Essex | 50009 | 1345 | 3 | 0 | 44.72736416 | -71.73579864 | 2022-06-30 04:21:01 | Essex, Vermont, US | |
2022-06-15 | US | Oklahoma | Jefferson | 40067 | 1345 | 27 | 0 | 34.11130184 | -97.83182974 | 2022-06-16 04:20:55 | Jefferson, Oklahoma, US | |
2022-06-14 | US | Oklahoma | Jefferson | 40067 | 1345 | 27 | 0 | 34.11130184 | -97.83182974 | 2022-06-15 04:20:54 | Jefferson, Oklahoma, US | |
2022-06-14 | US | Georgia | Calhoun | 13037 | 1345 | 23 | 0 | 31.53169785 | -84.62725131 | 2022-06-15 04:20:54 | Calhoun, Georgia, US | |
2022-06-13 | US | Oklahoma | Jefferson | 40067 | 1345 | 27 | 0 | 34.11130184 | -97.83182974 | 2022-06-14 04:20:52 | Jefferson, Oklahoma, US | |
2022-06-13 | US | Georgia | Calhoun | 13037 | 1345 | 23 | 0 | 31.53169785 | -84.62725131 | 2022-06-14 04:20:52 | Calhoun, Georgia, US | |
2022-06-12 | US | Oklahoma | Jefferson | 40067 | 1345 | 27 | 0 | 34.11130184 | -97.83182974 | 2022-06-13 04:21:14 | Jefferson, Oklahoma, US | |
2022-06-12 | US | Georgia | Calhoun | 13037 | 1345 | 23 | 0 | 31.53169785 | -84.62725131 | 2022-06-13 04:21:14 | Calhoun, Georgia, US | |
2022-06-11 | US | Oklahoma | Jefferson | 40067 | 1345 | 27 | 0 | 34.11130184 | -97.83182974 | 2022-06-12 04:20:53 | Jefferson, Oklahoma, US | |
2022-06-11 | US | Georgia | Calhoun | 13037 | 1345 | 23 | 0 | 31.53169785 | -84.62725131 | 2022-06-12 04:20:53 | Calhoun, Georgia, US | |
2022-06-10 | US | Oklahoma | Jefferson | 40067 | 1345 | 27 | 0 | 34.11130184 | -97.83182974 | 2022-06-11 04:21:01 | Jefferson, Oklahoma, US | |
2022-06-10 | US | Georgia | Calhoun | 13037 | 1345 | 23 | 0 | 31.53169785 | -84.62725131 | 2022-06-11 04:21:01 | Calhoun, Georgia, US | |
2022-06-09 | US | Oklahoma | Jefferson | 40067 | 1345 | 27 | 0 | 34.11130184 | -97.83182974 | 2022-06-10 04:20:55 | Jefferson, Oklahoma, US | |
2022-06-09 | US | Georgia | Calhoun | 13037 | 1345 | 23 | 0 | 31.53169785 | -84.62725131 | 2022-06-10 04:20:55 | Calhoun, Georgia, US | |
2022-06-08 | US | Georgia | Calhoun | 13037 | 1345 | 23 | 0 | 31.53169785 | -84.62725131 | 2022-06-09 04:20:54 | Calhoun, Georgia, US | |
2022-06-05 | US | Virginia | Norton | 51720 | 1345 | 22 | 0 | 36.93357076 | -82.62750411 | 2022-06-06 04:20:57 | Norton, Virginia, US | |
2022-06-04 | US | Virginia | Norton | 51720 | 1345 | 22 | 0 | 36.93357076 | -82.62750411 | 2022-06-05 04:20:55 | Norton, Virginia, US | |
2022-06-03 | US | Virginia | Norton | 51720 | 1345 | 22 | 0 | 36.93357076 | -82.62750411 | 2022-06-04 04:20:58 | Norton, Virginia, US | |
2022-05-30 | US | Nebraska | Nemaha | 31127 | 1345 | 20 | 0 | 40.38514847 | -95.85433992 | 2022-05-31 04:20:51 | Nemaha, Nebraska, US | |
2022-05-29 | US | Nebraska | Nemaha | 31127 | 1345 | 20 | 0 | 40.38514847 | -95.85433992 | 2022-05-30 04:20:50 | Nemaha, Nebraska, US | |
2022-05-28 | US | Nebraska | Nemaha | 31127 | 1345 | 20 | 0 | 40.38514847 | -95.85433992 | 2022-05-29 04:20:53 | Nemaha, Nebraska, US | |
2022-05-26 | US | Virginia | Covington | 51580 | 1345 | 27 | 0 | 37.7824656 | -79.98631446 | 2022-05-27 04:20:56 | Covington, Virginia, US | |
2022-05-25 | US | North Dakota | McHenry | 38049 | 1345 | 31 | 0 | 48.23104458 | -100.6324822 | 2022-05-26 04:20:50 | McHenry, North Dakota, US | |
2022-05-23 | US | North Dakota | Sioux | 38085 | 1345 | 19 | 0 | 46.11323337 | -101.0440149 | 2022-05-24 04:20:57 | Sioux, North Dakota, US | |
2022-05-22 | US | North Dakota | Sioux | 38085 | 1345 | 19 | 0 | 46.11323337 | -101.0440149 | 2022-05-26 04:20:50 | Sioux, North Dakota, US | |
2022-05-21 | US | North Dakota | Sioux | 38085 | 1345 | 19 | 0 | 46.11323337 | -101.0440149 | 2022-05-22 04:20:52 | Sioux, North Dakota, US | |
2022-05-20 | US | North Dakota | Sioux | 38085 | 1345 | 19 | 0 | 46.11323337 | -101.0440149 | 2022-05-21 04:20:58 | Sioux, North Dakota, US | |
2022-05-19 | US | North Dakota | Sioux | 38085 | 1345 | 19 | 0 | 46.11323337 | -101.0440149 | 2022-05-20 04:20:57 | Sioux, North Dakota, US | |
2022-04-17 | US | Nebraska | Burt | 31021 | 1345 | 16 | 0 | 41.85056773 | -96.32605633 | 2022-04-18 04:21:12 | Burt, Nebraska, US | |
2022-04-16 | US | Nebraska | Burt | 31021 | 1345 | 16 | 0 | 41.85056773 | -96.32605633 | 2022-04-17 04:20:59 | Burt, Nebraska, US | |
2022-04-15 | US | Nebraska | Burt | 31021 | 1345 | 16 | 0 | 41.85056773 | -96.32605633 | 2022-04-16 04:20:48 | Burt, Nebraska, US | |
2022-04-14 | US | Nebraska | Burt | 31021 | 1345 | 16 | 0 | 41.85056773 | -96.32605633 | 2022-04-15 04:20:57 | Burt, Nebraska, US | |
2022-04-13 | US | Nebraska | Burt | 31021 | 1345 | 16 | 0 | 41.85056773 | -96.32605633 | 2022-04-13 23:21:06 | Burt, Nebraska, US | |
2022-04-12 | US | Nebraska | Burt | 31021 | 1345 | 16 | 0 | 41.85056773 | -96.32605633 | 2022-04-13 04:21:03 | Burt, Nebraska, US | |
2022-04-11 | US | Wyoming | Crook | 56011 | 1345 | 28 | 0 | 44.58855102 | -104.56977049999999 | 2022-04-12 04:20:49 | Crook, Wyoming, US | |
2022-04-11 | US | Nebraska | Burt | 31021 | 1345 | 16 | 0 | 41.85056773 | -96.32605633 | 2022-04-12 04:20:49 | Burt, Nebraska, US | |
2022-04-10 | US | Wyoming | Crook | 56011 | 1345 | 28 | 0 | 44.58855102 | -104.56977049999999 | 2022-04-11 04:21:02 | Crook, Wyoming, US | |
2022-04-10 | US | Nebraska | Burt | 31021 | 1345 | 16 | 0 | 41.85056773 | -96.32605633 | 2022-04-11 04:21:02 | Burt, Nebraska, US | |
2022-04-09 | US | Wyoming | Crook | 56011 | 1345 | 28 | 0 | 44.58855102 | -104.56977049999999 | 2022-04-10 04:20:52 | Crook, Wyoming, US | |
2022-04-09 | US | Nebraska | Burt | 31021 | 1345 | 16 | 0 | 41.85056773 | -96.32605633 | 2022-04-10 04:20:52 | Burt, Nebraska, US | |
2022-04-08 | US | Wyoming | Crook | 56011 | 1345 | 28 | 0 | 44.58855102 | -104.56977049999999 | 2022-04-09 04:20:42 | Crook, Wyoming, US | |
2022-04-08 | US | Nebraska | Burt | 31021 | 1345 | 16 | 0 | 41.85056773 | -96.32605633 | 2022-04-09 04:20:42 | Burt, Nebraska, US | |
2022-04-07 | US | Nebraska | Burt | 31021 | 1345 | 16 | 0 | 41.85056773 | -96.32605633 | 2022-04-08 04:20:48 | Burt, Nebraska, US | |
2022-04-07 | US | Kansas | Republic | 20157 | 1345 | 16 | 0 | 39.82799632 | -97.65036709 | 2022-04-08 04:20:48 | Republic, Kansas, US | |
2022-04-06 | US | Nebraska | Burt | 31021 | 1345 | 16 | 0 | 41.85056773 | -96.32605633 | 2022-04-07 04:20:53 | Burt, Nebraska, US | |
2022-04-06 | US | Kansas | Republic | 20157 | 1345 | 16 | 0 | 39.82799632 | -97.65036709 | 2022-04-07 04:20:53 | Republic, Kansas, US | |
2022-04-05 | US | Nebraska | Burt | 31021 | 1345 | 16 | 0 | 41.85056773 | -96.32605633 | 2022-04-06 04:20:49 | Burt, Nebraska, US | |
2022-04-05 | US | Kansas | Republic | 20157 | 1345 | 16 | 0 | 39.82799632 | -97.65036709 | 2022-04-06 04:20:49 | Republic, Kansas, US | |
2022-04-04 | US | Kansas | Republic | 20157 | 1345 | 16 | 0 | 39.82799632 | -97.65036709 | 2022-04-05 04:20:48 | Republic, Kansas, US | |
2022-04-03 | US | Kansas | Republic | 20157 | 1345 | 16 | 0 | 39.82799632 | -97.65036709 | 2022-04-04 04:20:51 | Republic, Kansas, US | |
2022-04-02 | US | Puerto Rico | Guanica | 72055 | 1345 | 0 | 0 | 17.982429 | -66.91964300000001 | 2022-04-03 04:20:48 | Guanica, Puerto Rico, US | |
2022-04-02 | US | Kansas | Republic | 20157 | 1345 | 16 | 0 | 39.82799632 | -97.65036709 | 2022-04-03 04:20:48 | Republic, Kansas, US | |
2022-04-01 | US | Kansas | Republic | 20157 | 1345 | 16 | 0 | 39.82799632 | -97.65036709 | 2022-04-02 04:20:47 | Republic, Kansas, US | |
2022-03-31 | US | Kansas | Republic | 20157 | 1345 | 16 | 0 | 39.82799632 | -97.65036709 | 2022-04-01 04:20:28 | Republic, Kansas, US | |
2022-03-30 | US | Kansas | Republic | 20157 | 1345 | 16 | 0 | 39.82799632 | -97.65036709 | 2022-03-31 04:20:56 | Republic, Kansas, US | |
2022-03-29 | US | Kansas | Republic | 20157 | 1345 | 16 | 0 | 39.82799632 | -97.65036709 | 2022-03-30 04:20:45 | Republic, Kansas, US | |
2022-03-28 | US | Kansas | Republic | 20157 | 1345 | 16 | 0 | 39.82799632 | -97.65036709 | 2022-03-29 04:20:46 | Republic, Kansas, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;