daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
248 rows where deaths = 942 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-11-27 | US | Texas | McLennan | 48309 | 71229 | 942 | 0 | 31.55255453 | -97.20217694 | 2022-11-28 04:21:02 | McLennan, Texas, US | |
2022-11-26 | US | Texas | McLennan | 48309 | 71229 | 942 | 0 | 31.55255453 | -97.20217694 | 2022-11-27 04:21:05 | McLennan, Texas, US | |
2022-11-25 | US | Texas | McLennan | 48309 | 71229 | 942 | 0 | 31.55255453 | -97.20217694 | 2022-11-26 04:21:11 | McLennan, Texas, US | |
2022-11-24 | US | Texas | McLennan | 48309 | 71229 | 942 | 0 | 31.55255453 | -97.20217694 | 2022-11-25 04:21:06 | McLennan, Texas, US | |
2022-11-23 | US | Texas | McLennan | 48309 | 71229 | 942 | 0 | 31.55255453 | -97.20217694 | 2022-11-24 04:21:09 | McLennan, Texas, US | |
2022-11-23 | US | Arkansas | Benton | 5007 | 74672 | 942 | 0 | 36.33644656 | -94.25680817 | 2022-11-24 04:21:09 | Benton, Arkansas, US | |
2022-11-22 | US | Texas | McLennan | 48309 | 71181 | 942 | 0 | 31.55255453 | -97.20217694 | 2022-11-23 04:21:06 | McLennan, Texas, US | |
2022-11-22 | US | Arkansas | Benton | 5007 | 74632 | 942 | 0 | 36.33644656 | -94.25680817 | 2022-11-23 04:21:06 | Benton, Arkansas, US | |
2022-11-21 | US | Texas | McLennan | 48309 | 71181 | 942 | 0 | 31.55255453 | -97.20217694 | 2022-11-22 04:20:47 | McLennan, Texas, US | |
2022-11-20 | US | Texas | McLennan | 48309 | 71083 | 942 | 0 | 31.55255453 | -97.20217694 | 2022-11-21 04:21:05 | McLennan, Texas, US | |
2022-11-19 | US | Texas | McLennan | 48309 | 71083 | 942 | 0 | 31.55255453 | -97.20217694 | 2022-11-20 04:21:08 | McLennan, Texas, US | |
2022-11-18 | US | Texas | McLennan | 48309 | 71083 | 942 | 0 | 31.55255453 | -97.20217694 | 2022-11-19 04:21:14 | McLennan, Texas, US | |
2022-09-26 | US | Tennessee | Rutherford | 47149 | 110047 | 942 | 0 | 35.84591405 | -86.4107263 | 2022-09-27 04:23:01 | Rutherford, Tennessee, US | |
2022-09-25 | US | Tennessee | Rutherford | 47149 | 110027 | 942 | 0 | 35.84591405 | -86.4107263 | 2022-09-26 04:20:52 | Rutherford, Tennessee, US | |
2022-09-24 | US | Tennessee | Rutherford | 47149 | 110003 | 942 | 0 | 35.84591405 | -86.4107263 | 2022-09-25 04:23:31 | Rutherford, Tennessee, US | |
2022-09-23 | US | Tennessee | Rutherford | 47149 | 109986 | 942 | 0 | 35.84591405 | -86.4107263 | 2022-09-24 04:21:40 | Rutherford, Tennessee, US | |
2022-09-22 | US | Tennessee | Rutherford | 47149 | 109926 | 942 | 0 | 35.84591405 | -86.4107263 | 2022-09-23 04:23:13 | Rutherford, Tennessee, US | |
2022-09-21 | US | Tennessee | Rutherford | 47149 | 109894 | 942 | 0 | 35.84591405 | -86.4107263 | 2022-09-22 04:22:56 | Rutherford, Tennessee, US | |
2022-08-15 | Spain | La Rioja | 108012 | 942 | 0 | 42.2871 | -2.5396 | 2022-08-16 04:20:58 | La Rioja, Spain | |||
2022-08-14 | Spain | La Rioja | 108012 | 942 | 0 | 42.2871 | -2.5396 | 2022-08-15 04:20:59 | La Rioja, Spain | |||
2022-08-13 | Spain | La Rioja | 108012 | 942 | 0 | 42.2871 | -2.5396 | 2022-08-14 04:20:55 | La Rioja, Spain | |||
2022-08-12 | Spain | La Rioja | 108012 | 942 | 0 | 42.2871 | -2.5396 | 2022-08-13 04:20:52 | La Rioja, Spain | |||
2022-08-07 | US | Texas | Williamson | 48491 | 153334 | 942 | 0 | 30.64655664 | -97.6004854 | 2022-08-08 04:21:08 | Williamson, Texas, US | |
2022-08-06 | US | Texas | Williamson | 48491 | 153334 | 942 | 0 | 30.64655664 | -97.6004854 | 2022-08-07 04:20:54 | Williamson, Texas, US | |
2022-08-05 | US | Texas | Williamson | 48491 | 153334 | 942 | 0 | 30.64655664 | -97.6004854 | 2022-08-06 04:20:56 | Williamson, Texas, US | |
2022-08-04 | US | Texas | Williamson | 48491 | 153334 | 942 | 0 | 30.64655664 | -97.6004854 | 2022-08-05 04:20:52 | Williamson, Texas, US | |
2022-07-27 | US | New Hampshire | Hillsborough | 33011 | 108484 | 942 | 0 | 42.91537785 | -71.7200253 | 2022-07-28 04:20:56 | Hillsborough, New Hampshire, US | |
2022-07-26 | US | New Hampshire | Hillsborough | 33011 | 108396 | 942 | 0 | 42.91537785 | -71.7200253 | 2022-07-27 04:21:04 | Hillsborough, New Hampshire, US | |
2022-07-10 | Italy | Basilicata | 154843 | 942 | 0 | 40.63947052 | 15.80514834 | 2022-07-11 04:20:46 | Basilicata, Italy | |||
2022-07-09 | Italy | Basilicata | 154156 | 942 | 0 | 40.63947052 | 15.80514834 | 2022-07-10 04:20:54 | Basilicata, Italy | |||
2022-06-23 | US | Missouri | St. Charles | 29183 | 100164 | 942 | 0 | 38.77875681 | -90.66662425 | 2022-06-24 04:20:58 | St. Charles, Missouri, US | |
2022-06-22 | US | Missouri | St. Charles | 29183 | 100164 | 942 | 0 | 38.77875681 | -90.66662425 | 2022-06-23 04:20:55 | St. Charles, Missouri, US | |
2022-06-21 | US | Missouri | St. Charles | 29183 | 100164 | 942 | 0 | 38.77875681 | -90.66662425 | 2022-06-22 04:20:54 | St. Charles, Missouri, US | |
2022-06-20 | US | Missouri | St. Charles | 29183 | 100164 | 942 | 0 | 38.77875681 | -90.66662425 | 2022-06-21 04:20:56 | St. Charles, Missouri, US | |
2022-06-19 | US | Missouri | St. Charles | 29183 | 100164 | 942 | 0 | 38.77875681 | -90.66662425 | 2022-06-20 04:21:01 | St. Charles, Missouri, US | |
2022-06-18 | US | Missouri | St. Charles | 29183 | 100164 | 942 | 0 | 38.77875681 | -90.66662425 | 2022-06-19 04:20:51 | St. Charles, Missouri, US | |
2022-06-17 | US | Missouri | St. Charles | 29183 | 100164 | 942 | 0 | 38.77875681 | -90.66662425 | 2022-06-18 04:21:10 | St. Charles, Missouri, US | |
2022-06-16 | US | Missouri | St. Charles | 29183 | 99166 | 942 | 0 | 38.77875681 | -90.66662425 | 2022-06-17 04:20:56 | St. Charles, Missouri, US | |
2022-06-15 | US | Missouri | St. Charles | 29183 | 99166 | 942 | 0 | 38.77875681 | -90.66662425 | 2022-06-16 04:20:55 | St. Charles, Missouri, US | |
2022-06-14 | US | Missouri | St. Charles | 29183 | 99166 | 942 | 0 | 38.77875681 | -90.66662425 | 2022-06-15 04:20:54 | St. Charles, Missouri, US | |
2022-06-13 | US | Missouri | St. Charles | 29183 | 99166 | 942 | 0 | 38.77875681 | -90.66662425 | 2022-06-14 04:20:52 | St. Charles, Missouri, US | |
2022-06-13 | France | Martinique | 172883 | 942 | 0 | 14.6415 | -61.0242 | 2022-06-14 04:20:52 | Martinique, France | |||
2022-06-12 | US | Missouri | St. Charles | 29183 | 99166 | 942 | 0 | 38.77875681 | -90.66662425 | 2022-06-13 04:21:14 | St. Charles, Missouri, US | |
2022-06-12 | France | Martinique | 172883 | 942 | 0 | 14.6415 | -61.0242 | 2022-06-13 04:21:14 | Martinique, France | |||
2022-06-11 | US | Missouri | St. Charles | 29183 | 99166 | 942 | 0 | 38.77875681 | -90.66662425 | 2022-06-12 04:20:53 | St. Charles, Missouri, US | |
2022-06-11 | France | Martinique | 172883 | 942 | 0 | 14.6415 | -61.0242 | 2022-06-12 04:20:53 | Martinique, France | |||
2022-06-10 | US | Missouri | St. Charles | 29183 | 99166 | 942 | 0 | 38.77875681 | -90.66662425 | 2022-06-11 04:21:01 | St. Charles, Missouri, US | |
2022-06-10 | France | Martinique | 172883 | 942 | 0 | 14.6415 | -61.0242 | 2022-06-11 04:21:01 | Martinique, France | |||
2022-06-09 | US | Missouri | St. Charles | 29183 | 98214 | 942 | 0 | 38.77875681 | -90.66662425 | 2022-06-10 04:20:55 | St. Charles, Missouri, US | |
2022-06-09 | France | Martinique | 172883 | 942 | 0 | 14.6415 | -61.0242 | 2022-06-10 04:20:55 | Martinique, France | |||
2022-06-08 | US | Virginia | Henrico | 51087 | 70879 | 942 | 0 | 37.53460572 | -77.39326555 | 2022-06-09 04:20:54 | Henrico, Virginia, US | |
2022-06-08 | US | Missouri | St. Charles | 29183 | 98214 | 942 | 0 | 38.77875681 | -90.66662425 | 2022-06-09 04:20:54 | St. Charles, Missouri, US | |
2022-06-08 | France | Martinique | 172883 | 942 | 0 | 14.6415 | -61.0242 | 2022-06-09 04:20:54 | Martinique, France | |||
2022-06-07 | US | Virginia | Henrico | 51087 | 70767 | 942 | 0 | 37.53460572 | -77.39326555 | 2022-06-08 04:20:55 | Henrico, Virginia, US | |
2022-06-07 | US | Missouri | St. Charles | 29183 | 98214 | 942 | 0 | 38.77875681 | -90.66662425 | 2022-06-08 04:20:55 | St. Charles, Missouri, US | |
2022-06-07 | France | Martinique | 172883 | 942 | 0 | 14.6415 | -61.0242 | 2022-06-08 04:20:55 | Martinique, France | |||
2022-06-06 | US | Missouri | St. Charles | 29183 | 98214 | 942 | 0 | 38.77875681 | -90.66662425 | 2022-06-07 04:21:08 | St. Charles, Missouri, US | |
2022-06-05 | US | Missouri | St. Charles | 29183 | 98214 | 942 | 0 | 38.77875681 | -90.66662425 | 2022-06-06 04:20:57 | St. Charles, Missouri, US | |
2022-06-04 | US | Missouri | St. Charles | 29183 | 98214 | 942 | 0 | 38.77875681 | -90.66662425 | 2022-06-05 04:20:55 | St. Charles, Missouri, US | |
2022-06-03 | US | Missouri | St. Charles | 29183 | 98214 | 942 | 0 | 38.77875681 | -90.66662425 | 2022-06-04 04:20:58 | St. Charles, Missouri, US | |
2022-05-03 | US | Michigan | Saginaw | 26145 | 49492 | 942 | 0 | 43.33433923 | -84.0513121 | 2022-05-04 04:20:59 | Saginaw, Michigan, US | |
2022-05-02 | US | Michigan | Saginaw | 26145 | 49492 | 942 | 0 | 43.33433923 | -84.0513121 | 2022-05-03 04:21:00 | Saginaw, Michigan, US | |
2022-05-02 | France | Guadeloupe | 147607 | 942 | 0 | 16.265 | -61.551 | 2022-05-03 04:21:00 | Guadeloupe, France | |||
2022-05-01 | US | Michigan | Saginaw | 26145 | 49492 | 942 | 0 | 43.33433923 | -84.0513121 | 2022-05-02 04:21:10 | Saginaw, Michigan, US | |
2022-05-01 | France | Guadeloupe | 147607 | 942 | 0 | 16.265 | -61.551 | 2022-05-02 04:21:10 | Guadeloupe, France | |||
2022-04-30 | US | Michigan | Saginaw | 26145 | 49492 | 942 | 0 | 43.33433923 | -84.0513121 | 2022-05-01 04:20:57 | Saginaw, Michigan, US | |
2022-04-30 | France | Guadeloupe | 147607 | 942 | 0 | 16.265 | -61.551 | 2022-05-01 04:20:57 | Guadeloupe, France | |||
2022-04-29 | US | Michigan | Saginaw | 26145 | 49492 | 942 | 0 | 43.33433923 | -84.0513121 | 2022-04-30 04:21:05 | Saginaw, Michigan, US | |
2022-04-29 | France | Guadeloupe | 147607 | 942 | 0 | 16.265 | -61.551 | 2022-04-30 04:21:05 | Guadeloupe, France | |||
2022-04-28 | US | Michigan | Saginaw | 26145 | 49492 | 942 | 0 | 43.33433923 | -84.0513121 | 2022-04-29 04:20:59 | Saginaw, Michigan, US | |
2022-04-28 | France | Guadeloupe | 147607 | 942 | 0 | 16.265 | -61.551 | 2022-04-29 04:20:59 | Guadeloupe, France | |||
2022-04-27 | US | Michigan | Saginaw | 26145 | 49492 | 942 | 0 | 43.33433923 | -84.0513121 | 2022-04-28 04:20:47 | Saginaw, Michigan, US | |
2022-04-27 | France | Guadeloupe | 147607 | 942 | 0 | 16.265 | -61.551 | 2022-04-28 04:20:47 | Guadeloupe, France | |||
2022-04-26 | France | Guadeloupe | 147607 | 942 | 0 | 16.265 | -61.551 | 2022-04-27 04:20:52 | Guadeloupe, France | |||
2022-04-25 | France | Guadeloupe | 147607 | 942 | 0 | 16.265 | -61.551 | 2022-04-26 04:20:51 | Guadeloupe, France | |||
2022-04-22 | US | Ohio | Trumbull | 39155 | 41686 | 942 | 0 | 41.31735028 | -80.76109643 | 2022-04-23 04:20:50 | Trumbull, Ohio, US | |
2022-04-01 | Malaysia | Pahang | 166294 | 942 | 0 | 3.8126 | 103.3256 | 2022-04-02 04:20:47 | Pahang, Malaysia | |||
2022-04-01 | Cyprus | 433217 | 942 | 0 | 35.1264 | 33.4299 | 2022-04-02 04:20:47 | Cyprus | ||||
2022-03-28 | US | Georgia | Clayton | 13063 | 63365 | 942 | 0 | 33.54187245 | -84.35594188 | 2022-03-29 04:20:46 | Clayton, Georgia, US | |
2022-03-27 | US | Georgia | Clayton | 13063 | 63351 | 942 | 0 | 33.54187245 | -84.35594188 | 2022-03-28 04:20:33 | Clayton, Georgia, US | |
2022-03-26 | US | Georgia | Clayton | 13063 | 63351 | 942 | 0 | 33.54187245 | -84.35594188 | 2022-03-27 04:20:47 | Clayton, Georgia, US | |
2022-03-25 | US | Georgia | Clayton | 13063 | 63351 | 942 | 0 | 33.54187245 | -84.35594188 | 2022-03-26 04:20:23 | Clayton, Georgia, US | |
2022-03-23 | Russia | Kirov Oblast | 148248 | 942 | 0 | 57.9665589 | 49.4074599 | 2022-03-24 04:20:43 | Kirov Oblast, Russia | |||
2022-03-11 | US | New Jersey | Gloucester | 34015 | 69256 | 942 | 0 | 39.71581067 | -75.13995546 | 2022-03-12 04:20:50 | Gloucester, New Jersey, US | |
2022-02-11 | US | Texas | Brazoria | 48039 | 91411 | 942 | 0 | 29.18757369 | -95.44563172 | 2022-02-12 04:21:06 | Brazoria, Texas, US | |
2022-02-02 | US | New Jersey | Somerset | 34035 | 64917 | 942 | 0 | 40.56465737 | -74.61683016 | 2022-02-03 04:21:21 | Somerset, New Jersey, US | |
2022-01-20 | US | North Carolina | Wake | 37183 | 234688 | 942 | 0 | 35.78879266 | -78.65249174 | 2022-01-21 04:21:09 | Wake, North Carolina, US | |
2022-01-09 | Colombia | Casanare | 36515 | 942 | 0 | 5.7589 | -71.5724 | 2022-01-10 04:22:07 | Casanare, Colombia | |||
2022-01-08 | Colombia | Casanare | 36454 | 942 | 0 | 5.7589 | -71.5724 | 2022-01-09 04:21:46 | Casanare, Colombia | |||
2022-01-07 | Colombia | Casanare | 36401 | 942 | 0 | 5.7589 | -71.5724 | 2022-01-08 04:21:53 | Casanare, Colombia | |||
2022-01-04 | Russia | Chechen Republic | 31130 | 942 | 0 | 43.39761470000001 | 45.6985005 | 2022-01-05 04:21:59 | Chechen Republic, Russia | |||
2021-12-20 | Canada | Saskatchewan | 82267 | 942 | 0 | 52.9399 | -106.4509 | 2021-12-21 03:21:27 | Saskatchewan, Canada | |||
2021-12-19 | Canada | Saskatchewan | 82208 | 942 | 0 | 52.9399 | -106.4509 | 2021-12-20 04:21:43 | Saskatchewan, Canada | |||
2021-12-18 | Canada | Saskatchewan | 82130 | 942 | 0 | 52.9399 | -106.4509 | 2021-12-19 04:21:11 | Saskatchewan, Canada | |||
2021-12-17 | Canada | Saskatchewan | 82069 | 942 | 0 | 52.9399 | -106.4509 | 2021-12-18 02:22:20 | Saskatchewan, Canada | |||
2021-12-14 | Colombia | Caqueta | 23045 | 942 | 0 | 0.8699 | -73.8419 | 2021-12-15 03:22:16 | Caqueta, Colombia | |||
2021-12-13 | US | Arizona | Yuma | 4027 | 43424 | 942 | 0 | 32.76895712 | -113.90666740000002 | 2021-12-14 04:22:38 | Yuma, Arizona, US | |
2021-12-13 | Colombia | Caqueta | 23041 | 942 | 0 | 0.8699 | -73.8419 | 2021-12-14 04:22:38 | Caqueta, Colombia | |||
2021-12-12 | US | Arizona | Yuma | 4027 | 43393 | 942 | 0 | 32.76895712 | -113.90666740000002 | 2021-12-13 04:22:02 | Yuma, Arizona, US | |
2021-12-12 | Colombia | Caqueta | 23034 | 942 | 0 | 0.8699 | -73.8419 | 2021-12-13 04:22:02 | Caqueta, Colombia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;