daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
147 rows where deaths = 1193 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 | Pennsylvania | Northampton | 42095 | 96114 | 1193 | 0 | 40.75182733 | -75.30471829 | 2022-12-21 04:21:03 | Northampton, Pennsylvania, US | |
2022-12-19 | US | Pennsylvania | Northampton | 42095 | 96114 | 1193 | 0 | 40.75182733 | -75.30471829 | 2022-12-20 04:21:04 | Northampton, Pennsylvania, US | |
2022-12-18 | US | Pennsylvania | Northampton | 42095 | 96114 | 1193 | 0 | 40.75182733 | -75.30471829 | 2022-12-19 04:21:03 | Northampton, Pennsylvania, US | |
2022-12-17 | US | Pennsylvania | Northampton | 42095 | 96114 | 1193 | 0 | 40.75182733 | -75.30471829 | 2022-12-18 04:21:03 | Northampton, Pennsylvania, US | |
2022-12-16 | US | Pennsylvania | Northampton | 42095 | 96114 | 1193 | 0 | 40.75182733 | -75.30471829 | 2022-12-17 04:21:04 | Northampton, Pennsylvania, US | |
2022-12-15 | US | Pennsylvania | Northampton | 42095 | 96114 | 1193 | 0 | 40.75182733 | -75.30471829 | 2022-12-16 04:21:01 | Northampton, Pennsylvania, US | |
2022-12-14 | US | Pennsylvania | Northampton | 42095 | 96114 | 1193 | 0 | 40.75182733 | -75.30471829 | 2022-12-15 04:20:58 | Northampton, Pennsylvania, US | |
2022-11-30 | Malaysia | Melaka | 141909 | 1193 | 0 | 2.1896 | 102.2501 | 2022-12-01 04:21:03 | Melaka, Malaysia | |||
2022-08-04 | US | Tennessee | Hamilton | 47065 | 109505 | 1193 | 0 | 35.17670231 | -85.16652245 | 2022-08-05 04:20:52 | Hamilton, Tennessee, US | |
2022-08-03 | US | Tennessee | Hamilton | 47065 | 109362 | 1193 | 0 | 35.17670231 | -85.16652245 | 2022-08-04 04:20:58 | Hamilton, Tennessee, US | |
2022-08-02 | US | Tennessee | Hamilton | 47065 | 109214 | 1193 | 0 | 35.17670231 | -85.16652245 | 2022-08-03 04:20:59 | Hamilton, Tennessee, US | |
2022-07-20 | US | Arkansas | Pulaski | 5119 | 113130 | 1193 | 0 | 34.77054088 | -92.31355101 | 2022-07-21 04:21:10 | Pulaski, Arkansas, US | |
2022-07-19 | US | Arkansas | Pulaski | 5119 | 112838 | 1193 | 0 | 34.77054088 | -92.31355101 | 2022-07-20 04:20:59 | Pulaski, Arkansas, US | |
2022-07-18 | US | Arkansas | Pulaski | 5119 | 112605 | 1193 | 0 | 34.77054088 | -92.31355101 | 2022-07-19 04:20:58 | Pulaski, Arkansas, US | |
2022-07-17 | US | Arkansas | Pulaski | 5119 | 112528 | 1193 | 0 | 34.77054088 | -92.31355101 | 2022-07-18 04:20:59 | Pulaski, Arkansas, US | |
2022-07-16 | US | Arkansas | Pulaski | 5119 | 112367 | 1193 | 0 | 34.77054088 | -92.31355101 | 2022-07-17 04:21:15 | Pulaski, Arkansas, US | |
2022-07-15 | US | Arkansas | Pulaski | 5119 | 112209 | 1193 | 0 | 34.77054088 | -92.31355101 | 2022-07-16 04:21:05 | Pulaski, Arkansas, US | |
2022-07-14 | US | Arkansas | Pulaski | 5119 | 112022 | 1193 | 0 | 34.77054088 | -92.31355101 | 2022-07-15 04:20:53 | Pulaski, Arkansas, US | |
2022-07-13 | US | Arkansas | Pulaski | 5119 | 111697 | 1193 | 0 | 34.77054088 | -92.31355101 | 2022-07-14 04:20:57 | Pulaski, Arkansas, US | |
2022-06-19 | US | Indiana | Allen | 18003 | 106758 | 1193 | 0 | 41.09194313 | -85.06800636 | 2022-06-20 04:21:01 | Allen, Indiana, US | |
2022-06-18 | US | Indiana | Allen | 18003 | 106758 | 1193 | 0 | 41.09194313 | -85.06800636 | 2022-06-19 04:20:51 | Allen, Indiana, US | |
2022-06-17 | US | Indiana | Allen | 18003 | 106758 | 1193 | 0 | 41.09194313 | -85.06800636 | 2022-06-18 04:21:10 | Allen, Indiana, US | |
2022-06-16 | US | Indiana | Allen | 18003 | 106657 | 1193 | 0 | 41.09194313 | -85.06800636 | 2022-06-17 04:20:56 | Allen, Indiana, US | |
2022-06-15 | US | Indiana | Allen | 18003 | 106657 | 1193 | 0 | 41.09194313 | -85.06800636 | 2022-06-16 04:20:55 | Allen, Indiana, US | |
2022-06-14 | US | Indiana | Allen | 18003 | 106572 | 1193 | 0 | 41.09194313 | -85.06800636 | 2022-06-15 04:20:54 | Allen, Indiana, US | |
2022-06-13 | US | Indiana | Allen | 18003 | 106572 | 1193 | 0 | 41.09194313 | -85.06800636 | 2022-06-14 04:20:52 | Allen, Indiana, US | |
2022-06-12 | US | Indiana | Allen | 18003 | 106392 | 1193 | 0 | 41.09194313 | -85.06800636 | 2022-06-13 04:21:14 | Allen, Indiana, US | |
2022-06-11 | US | Indiana | Allen | 18003 | 106392 | 1193 | 0 | 41.09194313 | -85.06800636 | 2022-06-12 04:20:53 | Allen, Indiana, US | |
2022-06-10 | US | Indiana | Allen | 18003 | 106392 | 1193 | 0 | 41.09194313 | -85.06800636 | 2022-06-11 04:21:01 | Allen, Indiana, US | |
2022-04-26 | US | Nevada | Washoe | 32031 | 104836 | 1193 | 0 | 40.66562265 | -119.6631594 | 2022-04-27 04:20:52 | Washoe, Nevada, US | |
2022-04-25 | US | Nevada | Washoe | 32031 | 104836 | 1193 | 0 | 40.66562265 | -119.6631594 | 2022-04-26 04:20:51 | Washoe, Nevada, US | |
2022-04-24 | US | Oregon | Multnomah | 41051 | 116609 | 1193 | 0 | 45.54747959 | -122.4169351 | 2022-04-25 04:20:56 | Multnomah, Oregon, US | |
2022-04-24 | US | Nevada | Washoe | 32031 | 104836 | 1193 | 0 | 40.66562265 | -119.6631594 | 2022-04-25 04:20:56 | Washoe, Nevada, US | |
2022-04-23 | US | Oregon | Multnomah | 41051 | 116609 | 1193 | 0 | 45.54747959 | -122.4169351 | 2022-04-24 04:20:56 | Multnomah, Oregon, US | |
2022-04-23 | US | Nevada | Washoe | 32031 | 104836 | 1193 | 0 | 40.66562265 | -119.6631594 | 2022-04-24 04:20:56 | Washoe, Nevada, US | |
2022-04-22 | US | Oregon | Multnomah | 41051 | 116609 | 1193 | 0 | 45.54747959 | -122.4169351 | 2022-04-23 04:20:50 | Multnomah, Oregon, US | |
2022-04-22 | US | Nevada | Washoe | 32031 | 104836 | 1193 | 0 | 40.66562265 | -119.6631594 | 2022-04-23 04:20:50 | Washoe, Nevada, US | |
2022-04-21 | US | Oregon | Multnomah | 41051 | 116347 | 1193 | 0 | 45.54747959 | -122.4169351 | 2022-04-22 04:20:45 | Multnomah, Oregon, US | |
2022-04-21 | US | Nevada | Washoe | 32031 | 104836 | 1193 | 0 | 40.66562265 | -119.6631594 | 2022-04-22 04:20:45 | Washoe, Nevada, US | |
2022-04-20 | US | Nevada | Washoe | 32031 | 104836 | 1193 | 0 | 40.66562265 | -119.6631594 | 2022-04-21 04:20:46 | Washoe, Nevada, US | |
2022-04-03 | US | Colorado | Arapahoe | 8005 | 158490 | 1193 | 0 | 39.64977461 | -104.3353617 | 2022-04-04 04:20:51 | Arapahoe, Colorado, US | |
2022-04-02 | US | Colorado | Arapahoe | 8005 | 158463 | 1193 | 0 | 39.64977461 | -104.3353617 | 2022-04-03 04:20:48 | Arapahoe, Colorado, US | |
2022-04-01 | US | Colorado | Arapahoe | 8005 | 158437 | 1193 | 0 | 39.64977461 | -104.3353617 | 2022-04-02 04:20:47 | Arapahoe, Colorado, US | |
2022-03-31 | US | New Jersey | Burlington | 34005 | 101903 | 1193 | 0 | 39.87681124 | -74.66927768 | 2022-04-01 04:20:28 | Burlington, New Jersey, US | |
2022-03-31 | US | Colorado | Arapahoe | 8005 | 158395 | 1193 | 0 | 39.64977461 | -104.3353617 | 2022-04-01 04:20:28 | Arapahoe, Colorado, US | |
2022-03-30 | US | New Jersey | Burlington | 34005 | 101853 | 1193 | 0 | 39.87681124 | -74.66927768 | 2022-03-31 04:20:56 | Burlington, New Jersey, US | |
2022-03-29 | US | New Jersey | Burlington | 34005 | 101808 | 1193 | 0 | 39.87681124 | -74.66927768 | 2022-03-30 04:20:45 | Burlington, New Jersey, US | |
2022-03-28 | US | New Jersey | Burlington | 34005 | 101756 | 1193 | 0 | 39.87681124 | -74.66927768 | 2022-03-29 04:20:46 | Burlington, New Jersey, US | |
2022-03-27 | US | New Jersey | Burlington | 34005 | 101732 | 1193 | 0 | 39.87681124 | -74.66927768 | 2022-03-28 04:20:33 | Burlington, New Jersey, US | |
2022-03-26 | US | New Jersey | Burlington | 34005 | 101700 | 1193 | 0 | 39.87681124 | -74.66927768 | 2022-03-27 04:20:47 | Burlington, New Jersey, US | |
2022-03-24 | US | Kansas | Johnson | 20091 | 144965 | 1193 | 0 | 38.88548175 | -94.82250877 | 2022-03-25 04:20:46 | Johnson, Kansas, US | |
2022-03-23 | US | Kansas | Johnson | 20091 | 144965 | 1193 | 0 | 38.88548175 | -94.82250877 | 2022-03-24 04:20:43 | Johnson, Kansas, US | |
2022-02-11 | Russia | Kostroma Oblast | 60842 | 1193 | 0 | 58.424756 | 44.253327299999995 | 2022-02-12 04:21:06 | Kostroma Oblast, Russia | |||
2022-02-10 | US | Pennsylvania | Lehigh | 42077 | 88000 | 1193 | 0 | 40.6154815 | -75.59435245 | 2022-02-11 04:21:09 | Lehigh, Pennsylvania, US | |
2022-02-10 | Russia | Mordovia Republic | 48701 | 1193 | 0 | 54.4419829 | 44.466114399999995 | 2022-02-11 04:21:09 | Mordovia Republic, Russia | |||
2022-02-02 | US | Texas | Denton | 48121 | 165595 | 1193 | 0 | 33.20521901 | -97.11691153 | 2022-02-03 04:21:21 | Denton, Texas, US | |
2022-01-31 | US | Texas | Montgomery | 48339 | 129046 | 1193 | 0 | 30.30079133 | -95.50572772 | 2022-02-01 04:21:11 | Montgomery, Texas, US | |
2022-01-30 | US | Texas | Montgomery | 48339 | 128567 | 1193 | 0 | 30.30079133 | -95.50572772 | 2022-01-31 04:21:09 | Montgomery, Texas, US | |
2022-01-29 | US | Texas | Montgomery | 48339 | 128049 | 1193 | 0 | 30.30079133 | -95.50572772 | 2022-01-30 04:21:26 | Montgomery, Texas, US | |
2022-01-24 | US | Oklahoma | Unassigned | 90040 | 77407 | 1193 | 0 | 36.83532655 | 0.0 | 2022-01-25 04:21:05 | Unassigned, Oklahoma, US | |
2022-01-20 | US | Minnesota | Ramsey | 27123 | 103109 | 1193 | 0 | 45.01625271 | -93.09872295 | 2022-01-21 04:21:09 | Ramsey, Minnesota, US | |
2022-01-20 | US | Delaware | New Castle | 10003 | 133641 | 1193 | 0 | 39.57992638 | -75.64054974 | 2022-01-21 04:21:09 | New Castle, Delaware, US | |
2022-01-11 | US | Georgia | Out of GA | 80013 | 58479 | 1193 | 0 | 34.91369188 | 0.0 | 2022-01-12 04:21:44 | Out of GA, Georgia, US | |
2022-01-05 | Suriname | 55376 | 1193 | 0 | 3.9193 | -56.0278 | 2022-01-06 04:22:09 | Suriname | ||||
2022-01-03 | US | Louisiana | Jefferson | 22051 | 82443 | 1193 | 0 | 29.74075478 | -90.11115756 | 2022-01-04 04:22:17 | Jefferson, Louisiana, US | |
2022-01-02 | US | Louisiana | Jefferson | 22051 | 77982 | 1193 | 0 | 29.74075478 | -90.11115756 | 2022-01-03 02:22:25 | Jefferson, Louisiana, US | |
2022-01-01 | US | Louisiana | Jefferson | 22051 | 77982 | 1193 | 0 | 29.74075478 | -90.11115756 | 2022-01-02 04:20:52 | Jefferson, Louisiana, US | |
2021-12-31 | US | Louisiana | Jefferson | 22051 | 77982 | 1193 | 0 | 29.74075478 | -90.11115756 | 2022-01-01 04:22:14 | Jefferson, Louisiana, US | |
2021-12-30 | US | Louisiana | Jefferson | 22051 | 77982 | 1193 | 0 | 29.74075478 | -90.11115756 | 2021-12-31 04:21:50 | Jefferson, Louisiana, US | |
2021-12-30 | Russia | Karelia Republic | 89903 | 1193 | 0 | 62.61940309999999 | 33.4920267 | 2021-12-31 04:21:50 | Karelia Republic, Russia | |||
2021-12-26 | US | Virginia | Fairfax | 51059 | 105063 | 1193 | 0 | 38.83677558 | -77.27565836 | 2021-12-27 04:21:58 | Fairfax, Virginia, US | |
2021-12-25 | US | Virginia | Fairfax | 51059 | 105063 | 1193 | 0 | 38.83677558 | -77.27565836 | 2021-12-26 04:21:50 | Fairfax, Virginia, US | |
2021-12-24 | US | Virginia | Fairfax | 51059 | 105063 | 1193 | 0 | 38.83677558 | -77.27565836 | 2021-12-25 04:21:37 | Fairfax, Virginia, US | |
2021-12-16 | US | Texas | Collin | 48085 | 132712 | 1193 | 0 | 33.18820114 | -96.57264368 | 2021-12-17 04:22:14 | Collin, Texas, US | |
2021-12-15 | US | Texas | Collin | 48085 | 132551 | 1193 | 0 | 33.18820114 | -96.57264368 | 2021-12-16 04:22:11 | Collin, Texas, US | |
2021-11-11 | US | District of Columbia | District of Columbia | 11001 | 65159 | 1193 | 0 | 38.90417773 | -77.01655992 | 2021-11-12 04:22:01 | District of Columbia, District of Columbia ,US | |
2021-11-10 | US | District of Columbia | District of Columbia | 11001 | 65159 | 1193 | 0 | 38.90417773 | -77.01655992 | 2021-11-11 04:21:45 | District of Columbia, District of Columbia ,US | |
2021-11-09 | US | District of Columbia | District of Columbia | 11001 | 65094 | 1193 | 0 | 38.90417773 | -77.01655992 | 2021-11-10 04:21:38 | District of Columbia, District of Columbia ,US | |
2021-11-08 | US | District of Columbia | District of Columbia | 11001 | 65050 | 1193 | 0 | 38.90417773 | -77.01655992 | 2021-11-09 04:21:36 | District of Columbia, District of Columbia ,US | |
2021-11-07 | US | District of Columbia | District of Columbia | 11001 | 64799 | 1193 | 0 | 38.90417773 | -77.01655992 | 2021-11-08 04:21:43 | District of Columbia, District of Columbia ,US | |
2021-11-06 | US | District of Columbia | District of Columbia | 11001 | 64799 | 1193 | 0 | 38.90417773 | -77.01655992 | 2021-11-07 04:21:53 | District of Columbia, District of Columbia ,US | |
2021-11-05 | US | District of Columbia | District of Columbia | 11001 | 64799 | 1193 | 0 | 38.90417773 | -77.01655992 | 2021-11-06 04:21:51 | District of Columbia, District of Columbia ,US | |
2021-11-04 | US | District of Columbia | District of Columbia | 11001 | 64708 | 1193 | 0 | 38.90417773 | -77.01655992 | 2021-11-05 04:21:54 | District of Columbia, District of Columbia ,US | |
2021-11-03 | US | District of Columbia | District of Columbia | 11001 | 64602 | 1193 | 0 | 38.90417773 | -77.01655992 | 2021-11-04 04:22:20 | District of Columbia, District of Columbia ,US | |
2021-11-02 | US | District of Columbia | District of Columbia | 11001 | 64541 | 1193 | 0 | 38.90417773 | -77.01655992 | 2021-11-03 06:22:09 | District of Columbia, District of Columbia ,US | |
2021-10-10 | Ukraine | Luhansk Oblast | 37768 | 1193 | 0 | 48.574 | 39.3078 | 2021-10-11 04:21:31 | Luhansk Oblast, Ukraine | |||
2021-10-04 | US | Massachusetts | Plymouth | 25023 | 56907 | 1193 | 0 | 41.94070556 | -70.80802823 | 2021-10-05 04:21:27 | Plymouth, Massachusetts, US | |
2021-10-01 | Italy | P.A. Bolzano | 76980 | 1193 | 0 | 46.49933453 | 11.35662422 | 2021-10-02 04:21:25 | P.A. Bolzano, Italy | |||
2021-09-29 | Malaysia | Negeri Sembilan | 97113 | 1193 | 0 | 2.7258 | 101.9424 | 2021-09-30 04:21:20 | Negeri Sembilan, Malaysia | |||
2021-09-28 | Malaysia | Negeri Sembilan | 96944 | 1193 | 0 | 2.7258 | 101.9424 | 2021-09-29 04:21:45 | Negeri Sembilan, Malaysia | |||
2021-09-27 | Malaysia | Negeri Sembilan | 96855 | 1193 | 0 | 2.7258 | 101.9424 | 2021-09-28 04:21:28 | Negeri Sembilan, Malaysia | |||
2021-09-16 | Rwanda | 94478 | 1193 | 0 | -1.9403 | 29.8739 | 2021-09-17 04:21:46 | Rwanda | ||||
2021-09-06 | Germany | Mecklenburg-Vorpommern | 46726 | 1193 | 0 | 53.6127 | 12.4296 | 2021-09-07 04:21:35 | Mecklenburg-Vorpommern, Germany | |||
2021-09-02 | US | Georgia | Cobb | 13067 | 96190 | 1193 | 0 | 33.94243204 | -84.5761255 | 2021-09-03 04:21:20 | Cobb, Georgia, US | |
2021-08-04 | Spain | Navarra | 77238 | 1193 | 3905 | 72140 | 42.6954 | -1.6761 | 2021-08-05 04:21:51 | Navarra, Spain | ||
2021-07-30 | Chile | Antofagasta | 59624 | 1193 | 58121 | 310 | -23.6509 | -70.3975 | 2021-07-31 04:21:35 | Antofagasta, Chile | ||
2021-07-15 | Peru | Amazonas | 30408 | 1193 | 0 | 29215 | -5.077253 | -78.050172 | 2021-07-16 04:21:22 | Amazonas, Peru | ||
2021-07-14 | Peru | Amazonas | 30408 | 1193 | 0 | 29215 | -5.077253 | -78.050172 | 2021-07-15 04:21:48 | Amazonas, Peru | ||
2021-07-11 | Russia | Smolensk Oblast | 37395 | 1193 | 32533 | 3669 | 55.03434960000001 | 33.0192065 | 2021-07-12 04:21:34 | Smolensk Oblast, Russia | ||
2021-07-07 | Russia | Vologda Oblast | 49347 | 1193 | 44664 | 3490 | 60.0391461 | 43.1215213 | 2021-07-08 04:21:26 | Vologda Oblast, Russia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;