daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
264 rows where deaths = 774 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 29
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-27 | US | Pennsylvania | Franklin | 42055 | 49643 | 774 | 0 | 39.92956518 | -77.72157791 | 2022-12-28 04:21:04 | Franklin, Pennsylvania, US | |
2022-12-26 | US | Pennsylvania | Franklin | 42055 | 49643 | 774 | 0 | 39.92956518 | -77.72157791 | 2022-12-27 04:21:07 | Franklin, Pennsylvania, US | |
2022-12-25 | US | Pennsylvania | Franklin | 42055 | 49643 | 774 | 0 | 39.92956518 | -77.72157791 | 2022-12-26 04:21:06 | Franklin, Pennsylvania, US | |
2022-12-24 | US | Pennsylvania | Franklin | 42055 | 49643 | 774 | 0 | 39.92956518 | -77.72157791 | 2022-12-25 04:21:04 | Franklin, Pennsylvania, US | |
2022-12-23 | US | Pennsylvania | Franklin | 42055 | 49643 | 774 | 0 | 39.92956518 | -77.72157791 | 2022-12-24 04:21:02 | Franklin, Pennsylvania, US | |
2022-12-22 | US | Pennsylvania | Franklin | 42055 | 49643 | 774 | 0 | 39.92956518 | -77.72157791 | 2022-12-23 04:21:04 | Franklin, Pennsylvania, US | |
2022-12-21 | US | Pennsylvania | Franklin | 42055 | 49643 | 774 | 0 | 39.92956518 | -77.72157791 | 2022-12-22 04:20:56 | Franklin, Pennsylvania, US | |
2022-12-19 | Japan | Gifu | 409654 | 774 | 0 | 35.778671 | 137.055925 | 2022-12-20 04:21:04 | Gifu, Japan | |||
2022-12-01 | US | Illinois | St. Clair | 17163 | 77612 | 774 | 0 | 38.46996033 | -89.93063427 | 2022-12-02 04:21:07 | St. Clair, Illinois, US | |
2022-10-20 | US | Tennessee | Sullivan | 47163 | 55046 | 774 | 0 | 36.51240691 | -82.30412917 | 2022-10-21 04:22:23 | Sullivan, Tennessee, US | |
2022-10-19 | US | Tennessee | Sullivan | 47163 | 55024 | 774 | 0 | 36.51240691 | -82.30412917 | 2022-10-20 04:22:59 | Sullivan, Tennessee, US | |
2022-10-18 | US | Tennessee | Sullivan | 47163 | 54989 | 774 | 0 | 36.51240691 | -82.30412917 | 2022-10-19 04:22:26 | Sullivan, Tennessee, US | |
2022-10-18 | US | Ohio | Lake | 39085 | 57285 | 774 | 0 | 41.69710807 | -81.23676539 | 2022-10-19 04:22:26 | Lake, Ohio, US | |
2022-10-17 | US | Tennessee | Sullivan | 47163 | 54964 | 774 | 0 | 36.51240691 | -82.30412917 | 2022-10-18 04:22:42 | Sullivan, Tennessee, US | |
2022-10-16 | US | Tennessee | Sullivan | 47163 | 54914 | 774 | 0 | 36.51240691 | -82.30412917 | 2022-10-17 04:20:31 | Sullivan, Tennessee, US | |
2022-10-15 | US | Tennessee | Sullivan | 47163 | 54904 | 774 | 0 | 36.51240691 | -82.30412917 | 2022-10-16 04:22:39 | Sullivan, Tennessee, US | |
2022-10-14 | US | Tennessee | Sullivan | 47163 | 54889 | 774 | 0 | 36.51240691 | -82.30412917 | 2022-10-15 04:22:00 | Sullivan, Tennessee, US | |
2022-10-13 | US | Tennessee | Sullivan | 47163 | 54866 | 774 | 0 | 36.51240691 | -82.30412917 | 2022-10-14 04:22:28 | Sullivan, Tennessee, US | |
2022-10-10 | US | Tennessee | Sumner | 47165 | 61450 | 774 | 0 | 36.46824103 | -86.45917204 | 2022-10-11 04:23:05 | Sumner, Tennessee, US | |
2022-10-09 | US | Tennessee | Sumner | 47165 | 61433 | 774 | 0 | 36.46824103 | -86.45917204 | 2022-10-10 04:22:32 | Sumner, Tennessee, US | |
2022-10-08 | US | Tennessee | Sumner | 47165 | 61419 | 774 | 0 | 36.46824103 | -86.45917204 | 2022-10-09 04:21:16 | Sumner, Tennessee, US | |
2022-10-07 | US | Tennessee | Sumner | 47165 | 61410 | 774 | 0 | 36.46824103 | -86.45917204 | 2022-10-08 04:22:56 | Sumner, Tennessee, US | |
2022-10-06 | US | Tennessee | Sumner | 47165 | 61397 | 774 | 0 | 36.46824103 | -86.45917204 | 2022-10-07 04:23:08 | Sumner, Tennessee, US | |
2022-09-06 | US | Pennsylvania | Butler | 42019 | 50535 | 774 | 0 | 40.91152759 | -79.91351055 | 2022-09-07 04:20:59 | Butler, Pennsylvania, US | |
2022-09-05 | US | Pennsylvania | Butler | 42019 | 50535 | 774 | 0 | 40.91152759 | -79.91351055 | 2022-09-06 04:21:02 | Butler, Pennsylvania, US | |
2022-09-04 | US | Pennsylvania | Butler | 42019 | 50535 | 774 | 0 | 40.91152759 | -79.91351055 | 2022-09-05 04:21:01 | Butler, Pennsylvania, US | |
2022-09-03 | US | Pennsylvania | Butler | 42019 | 50535 | 774 | 0 | 40.91152759 | -79.91351055 | 2022-09-04 04:21:22 | Butler, Pennsylvania, US | |
2022-09-02 | US | Pennsylvania | Butler | 42019 | 50535 | 774 | 0 | 40.91152759 | -79.91351055 | 2022-09-03 04:21:04 | Butler, Pennsylvania, US | |
2022-09-01 | US | Pennsylvania | Butler | 42019 | 50535 | 774 | 0 | 40.91152759 | -79.91351055 | 2022-09-02 04:21:07 | Butler, Pennsylvania, US | |
2022-08-31 | US | Pennsylvania | Butler | 42019 | 50535 | 774 | 0 | 40.91152759 | -79.91351055 | 2022-09-01 04:21:03 | Butler, Pennsylvania, US | |
2022-08-25 | Australia | South Australia | 750458 | 774 | 0 | -34.9285 | 138.6007 | 2022-08-26 04:21:02 | South Australia, Australia | |||
2022-08-22 | US | West Virginia | Kanawha | 54039 | 54082 | 774 | 0 | 38.33860077 | -81.52857054 | 2022-08-23 04:20:56 | Kanawha, West Virginia, US | |
2022-08-22 | US | Oregon | Marion | 41047 | 80911 | 774 | 0 | 44.90287942 | -122.5815117 | 2022-08-23 04:20:56 | Marion, Oregon, US | |
2022-08-21 | US | Oregon | Marion | 41047 | 80736 | 774 | 0 | 44.90287942 | -122.5815117 | 2022-08-22 04:20:38 | Marion, Oregon, US | |
2022-08-20 | US | Oregon | Marion | 41047 | 80736 | 774 | 0 | 44.90287942 | -122.5815117 | 2022-08-21 04:20:44 | Marion, Oregon, US | |
2022-08-19 | US | Oregon | Marion | 41047 | 80736 | 774 | 0 | 44.90287942 | -122.5815117 | 2022-08-20 04:21:01 | Marion, Oregon, US | |
2022-08-03 | Japan | Kyoto | 303925 | 774 | 0 | 35.253815 | 135.443341 | 2022-08-04 04:20:58 | Kyoto, Japan | |||
2022-05-31 | Germany | Bremen | 200544 | 774 | 0 | 53.0793 | 8.8017 | 2022-06-01 04:20:55 | Bremen, Germany | |||
2022-05-30 | Germany | Bremen | 200057 | 774 | 0 | 53.0793 | 8.8017 | 2022-05-31 04:20:51 | Bremen, Germany | |||
2022-05-29 | Germany | Bremen | 200057 | 774 | 0 | 53.0793 | 8.8017 | 2022-05-30 04:20:50 | Bremen, Germany | |||
2022-05-28 | Germany | Bremen | 200057 | 774 | 0 | 53.0793 | 8.8017 | 2022-05-29 04:20:53 | Bremen, Germany | |||
2022-05-27 | Germany | Bremen | 199618 | 774 | 0 | 53.0793 | 8.8017 | 2022-05-28 04:21:07 | Bremen, Germany | |||
2022-05-12 | US | Minnesota | Dakota | 27037 | 113389 | 774 | 0 | 44.67172617 | -93.06299363 | 2022-05-13 04:20:51 | Dakota, Minnesota, US | |
2022-04-08 | Australia | Queensland | 849753 | 774 | 0 | -27.4698 | 153.0251 | 2022-04-09 04:20:42 | Queensland, Australia | |||
2022-04-07 | US | Washington | Yakima | 53077 | 71444 | 774 | 0 | 46.45738486 | -120.73801259999999 | 2022-04-08 04:20:48 | Yakima, Washington, US | |
2022-04-06 | US | Washington | Yakima | 53077 | 71444 | 774 | 0 | 46.45738486 | -120.73801259999999 | 2022-04-07 04:20:53 | Yakima, Washington, US | |
2022-04-06 | US | Georgia | Bibb | 13021 | 37043 | 774 | 0 | 32.80904227 | -83.70489165 | 2022-04-07 04:20:53 | Bibb, Georgia, US | |
2022-03-29 | Colombia | Putumayo | 20476 | 774 | 0 | 0.436 | -75.5277 | 2022-03-30 04:20:45 | Putumayo, Colombia | |||
2022-03-28 | Colombia | Putumayo | 20472 | 774 | 0 | 0.436 | -75.5277 | 2022-03-29 04:20:46 | Putumayo, Colombia | |||
2022-03-27 | Colombia | Putumayo | 20472 | 774 | 0 | 0.436 | -75.5277 | 2022-03-28 04:20:33 | Putumayo, Colombia | |||
2022-03-22 | US | Utah | Utah | 49049 | 201332 | 774 | 0 | 40.116672200000004 | -111.66576620000001 | 2022-03-23 04:20:48 | Utah, Utah, US | |
2022-03-16 | US | Washington | Clark | 53011 | 86514 | 774 | 0 | 45.77568046 | -122.48292040000001 | 2022-03-17 04:20:56 | Clark, Washington, US | |
2022-03-16 | US | Oklahoma | Cleveland | 40027 | 78688 | 774 | 0 | 35.20413532 | -97.32519562 | 2022-03-17 04:20:56 | Cleveland, Oklahoma, US | |
2022-03-15 | US | Washington | Clark | 53011 | 86514 | 774 | 0 | 45.77568046 | -122.48292040000001 | 2022-03-16 04:20:50 | Clark, Washington, US | |
2022-03-15 | US | Oklahoma | Cleveland | 40027 | 78688 | 774 | 0 | 35.20413532 | -97.32519562 | 2022-03-16 04:20:50 | Cleveland, Oklahoma, US | |
2022-03-14 | US | Washington | Clark | 53011 | 86514 | 774 | 0 | 45.77568046 | -122.48292040000001 | 2022-03-15 04:20:47 | Clark, Washington, US | |
2022-03-14 | US | Oklahoma | Cleveland | 40027 | 78688 | 774 | 0 | 35.20413532 | -97.32519562 | 2022-03-15 04:20:47 | Cleveland, Oklahoma, US | |
2022-03-13 | US | Oklahoma | Cleveland | 40027 | 78688 | 774 | 0 | 35.20413532 | -97.32519562 | 2022-03-14 04:20:46 | Cleveland, Oklahoma, US | |
2022-03-12 | US | Oklahoma | Cleveland | 40027 | 78688 | 774 | 0 | 35.20413532 | -97.32519562 | 2022-03-13 04:20:49 | Cleveland, Oklahoma, US | |
2022-03-11 | US | Oklahoma | Cleveland | 40027 | 78688 | 774 | 0 | 35.20413532 | -97.32519562 | 2022-03-12 04:20:50 | Cleveland, Oklahoma, US | |
2022-03-10 | US | Oklahoma | Cleveland | 40027 | 78688 | 774 | 0 | 35.20413532 | -97.32519562 | 2022-03-11 04:20:50 | Cleveland, Oklahoma, US | |
2022-03-10 | US | North Carolina | Forsyth | 37067 | 91610 | 774 | 0 | 36.12859861 | -80.25459052 | 2022-03-11 04:20:50 | Forsyth, North Carolina, US | |
2022-03-05 | Italy | Basilicata | 85782 | 774 | 0 | 40.63947052 | 15.80514834 | 2022-03-06 04:20:49 | Basilicata, Italy | |||
2022-03-03 | US | Illinois | Madison | 17119 | 69772 | 774 | 0 | 38.83042506 | -89.90422563 | 2022-03-04 04:21:09 | Madison, Illinois, US | |
2022-03-01 | US | New York | Oneida | 36065 | 52169 | 774 | 0 | 43.24375382 | -75.43710392 | 2022-03-02 04:21:07 | Oneida, New York, US | |
2022-02-15 | US | Michigan | St. Clair | 26147 | 39582 | 774 | 0 | 42.92655373 | -82.67937954 | 2022-02-16 04:21:10 | St. Clair, Michigan, US | |
2022-02-14 | US | Michigan | St. Clair | 26147 | 39582 | 774 | 0 | 42.92655373 | -82.67937954 | 2022-02-15 04:21:09 | St. Clair, Michigan, US | |
2022-02-08 | US | Texas | Jefferson | 48245 | 41973 | 774 | 0 | 29.8832777 | -94.16434171 | 2022-02-09 04:21:04 | Jefferson, Texas, US | |
2022-02-02 | US | South Carolina | Lexington | 45063 | 90286 | 774 | 0 | 33.89665987 | -81.27146426 | 2022-02-03 04:21:21 | Lexington, South Carolina, US | |
2022-01-28 | US | Missouri | St. Charles | 29183 | 89526 | 774 | 0 | 38.77875681 | -90.66662425 | 2022-01-29 04:21:10 | St. Charles, Missouri, US | |
2022-01-27 | US | Missouri | St. Charles | 29183 | 89107 | 774 | 0 | 38.77875681 | -90.66662425 | 2022-01-28 04:21:09 | St. Charles, Missouri, US | |
2022-01-26 | US | Missouri | St. Charles | 29183 | 88620 | 774 | 0 | 38.77875681 | -90.66662425 | 2022-01-27 04:21:19 | St. Charles, Missouri, US | |
2022-01-25 | US | Missouri | St. Charles | 29183 | 88114 | 774 | 0 | 38.77875681 | -90.66662425 | 2022-01-26 04:21:07 | St. Charles, Missouri, US | |
2022-01-24 | US | Missouri | St. Charles | 29183 | 87685 | 774 | 0 | 38.77875681 | -90.66662425 | 2022-01-25 04:21:05 | St. Charles, Missouri, US | |
2022-01-19 | US | Texas | Williamson | 48491 | 108125 | 774 | 0 | 30.64655664 | -97.60048540000001 | 2022-01-20 04:21:07 | Williamson, Texas, US | |
2022-01-19 | US | South Carolina | Charleston | 45019 | 94092 | 774 | 0 | 32.82487866 | -79.96512315 | 2022-01-20 04:21:07 | Charleston, South Carolina, US | |
2022-01-18 | US | South Carolina | Charleston | 45019 | 93398 | 774 | 0 | 32.82487866 | -79.96512315 | 2022-01-19 04:21:23 | Charleston, South Carolina, US | |
2022-01-18 | US | Georgia | Richmond | 13245 | 43985 | 774 | 0 | 33.35777107 | -82.07026432 | 2022-01-19 04:21:23 | Richmond, Georgia, US | |
2022-01-17 | US | Georgia | Richmond | 13245 | 43829 | 774 | 0 | 33.35777107 | -82.07026432 | 2022-01-18 04:21:04 | Richmond, Georgia, US | |
2022-01-15 | US | Arizona | Navajo | 4017 | 30211 | 774 | 0 | 35.3997715 | -110.3218983 | 2022-01-16 04:21:12 | Navajo, Arizona, US | |
2022-01-14 | US | Arizona | Navajo | 4017 | 30211 | 774 | 0 | 35.3997715 | -110.3218983 | 2022-01-15 04:21:07 | Navajo, Arizona, US | |
2022-01-05 | Haiti | 26304 | 774 | 0 | 18.9712 | -72.2852 | 2022-01-06 04:22:09 | Haiti | ||||
2022-01-04 | Haiti | 26259 | 774 | 0 | 18.9712 | -72.2852 | 2022-01-05 04:21:59 | Haiti | ||||
2022-01-03 | Peru | Madre de Dios | 14091 | 774 | 0 | -11.972699 | -70.53171999999998 | 2022-01-04 04:22:17 | Madre de Dios, Peru | |||
2022-01-03 | Haiti | 26259 | 774 | 0 | 18.9712 | -72.2852 | 2022-01-04 04:22:17 | Haiti | ||||
2022-01-02 | Peru | Madre de Dios | 14091 | 774 | 0 | -11.972699 | -70.53171999999998 | 2022-01-03 02:22:25 | Madre de Dios, Peru | |||
2022-01-01 | Peru | Madre de Dios | 14091 | 774 | 0 | -11.972699 | -70.53171999999998 | 2022-01-02 04:20:52 | Madre de Dios, Peru | |||
2021-12-31 | Peru | Madre de Dios | 14091 | 774 | 0 | -11.972699 | -70.53171999999998 | 2022-01-01 04:22:14 | Madre de Dios, Peru | |||
2021-12-30 | Peru | Madre de Dios | 14091 | 774 | 0 | -11.972699 | -70.53171999999998 | 2021-12-31 04:21:50 | Madre de Dios, Peru | |||
2021-12-29 | US | Ohio | Trumbull | 39155 | 31362 | 774 | 0 | 41.31735028 | -80.76109643 | 2021-12-30 04:21:25 | Trumbull, Ohio, US | |
2021-12-29 | Peru | Madre de Dios | 14091 | 774 | 0 | -11.972699 | -70.53171999999998 | 2021-12-30 04:21:25 | Madre de Dios, Peru | |||
2021-12-28 | Peru | Madre de Dios | 14091 | 774 | 0 | -11.972699 | -70.53171999999998 | 2021-12-29 03:21:43 | Madre de Dios, Peru | |||
2021-12-27 | Peru | Madre de Dios | 14091 | 774 | 0 | -11.972699 | -70.53171999999998 | 2021-12-28 04:21:47 | Madre de Dios, Peru | |||
2021-12-22 | US | Ohio | Lorain | 39093 | 48101 | 774 | 0 | 41.29553751 | -82.15083537 | 2021-12-23 04:21:21 | Lorain, Ohio, US | |
2021-12-21 | US | New Jersey | Gloucester | 34015 | 44927 | 774 | 0 | 39.71581067 | -75.13995546 | 2021-12-22 04:21:54 | Gloucester, New Jersey, US | |
2021-12-08 | Singapore | 271297 | 774 | 0 | 1.2833 | 103.8333 | 2021-12-09 04:22:49 | Singapore | ||||
2021-12-05 | US | Georgia | Clayton | 13063 | 40253 | 774 | 0 | 33.54187245 | -84.35594188 | 2021-12-06 04:22:34 | Clayton, Georgia, US | |
2021-12-04 | US | Georgia | Clayton | 13063 | 40253 | 774 | 0 | 33.54187245 | -84.35594188 | 2021-12-05 04:22:25 | Clayton, Georgia, US | |
2021-12-03 | US | Georgia | Clayton | 13063 | 40253 | 774 | 0 | 33.54187245 | -84.35594188 | 2021-12-04 04:22:18 | Clayton, Georgia, US | |
2021-12-02 | US | Georgia | Clayton | 13063 | 40204 | 774 | 0 | 33.54187245 | -84.35594188 | 2021-12-03 04:23:05 | Clayton, Georgia, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;