daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
99 rows where deaths = 1907 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-15 | US | Maryland | Baltimore City | 24510 | 142855 | 1907 | 0 | 39.30211911 | -76.61151012 | 2022-12-16 04:21:01 | Baltimore City, Maryland, US | |
2022-11-24 | Chile | Antofagasta | 172359 | 1907 | 0 | -23.6509 | -70.3975 | 2022-11-25 04:21:06 | Antofagasta, Chile | |||
2022-11-02 | US | New Jersey | Camden | 34007 | 156482 | 1907 | 0 | 39.80343818 | -74.96388753 | 2022-11-03 04:22:05 | Camden, New Jersey, US | |
2022-11-01 | US | New Jersey | Camden | 34007 | 156352 | 1907 | 0 | 39.80343818 | -74.96388753 | 2022-11-02 04:22:09 | Camden, New Jersey, US | |
2022-10-01 | Russia | Kabardino-Balkarian Republic | 72109 | 1907 | 0 | 43.4806048 | 43.5978976 | 2022-10-02 04:21:23 | Kabardino-Balkarian Republic, Russia | |||
2022-09-30 | Russia | Kabardino-Balkarian Republic | 72008 | 1907 | 0 | 43.4806048 | 43.5978976 | 2022-10-01 04:23:01 | Kabardino-Balkarian Republic, Russia | |||
2022-09-29 | Russia | Kabardino-Balkarian Republic | 71874 | 1907 | 0 | 43.4806048 | 43.5978976 | 2022-09-30 04:23:09 | Kabardino-Balkarian Republic, Russia | |||
2022-09-28 | US | Massachusetts | Hampden | 25013 | 156846 | 1907 | 0 | 42.13440424 | -72.63235561 | 2022-09-29 04:22:34 | Hampden, Massachusetts, US | |
2022-09-27 | US | Massachusetts | Hampden | 25013 | 156846 | 1907 | 0 | 42.13440424 | -72.63235561 | 2022-09-28 04:23:01 | Hampden, Massachusetts, US | |
2022-09-26 | US | Massachusetts | Hampden | 25013 | 156846 | 1907 | 0 | 42.13440424 | -72.63235561 | 2022-09-27 04:23:01 | Hampden, Massachusetts, US | |
2022-09-25 | US | Massachusetts | Hampden | 25013 | 156846 | 1907 | 0 | 42.13440424 | -72.63235561 | 2022-09-26 04:20:52 | Hampden, Massachusetts, US | |
2022-09-24 | US | Massachusetts | Hampden | 25013 | 156846 | 1907 | 0 | 42.13440424 | -72.63235561 | 2022-09-25 04:23:31 | Hampden, Massachusetts, US | |
2022-09-23 | US | Massachusetts | Hampden | 25013 | 156846 | 1907 | 0 | 42.13440424 | -72.63235561 | 2022-09-24 04:21:40 | Hampden, Massachusetts, US | |
2022-09-22 | US | Massachusetts | Hampden | 25013 | 156846 | 1907 | 0 | 42.13440424 | -72.63235561 | 2022-09-23 04:23:13 | Hampden, Massachusetts, US | |
2022-08-02 | US | Pennsylvania | Delaware | 42045 | 124389 | 1907 | 0 | 39.91680171 | -75.40243663 | 2022-08-03 04:20:59 | Delaware, Pennsylvania, US | |
2022-08-01 | US | Pennsylvania | Delaware | 42045 | 124389 | 1907 | 0 | 39.91680171 | -75.40243663 | 2022-08-02 04:20:53 | Delaware, Pennsylvania, US | |
2022-07-31 | US | Pennsylvania | Delaware | 42045 | 124389 | 1907 | 0 | 39.91680171 | -75.40243663 | 2022-08-01 04:21:03 | Delaware, Pennsylvania, US | |
2022-07-30 | US | Pennsylvania | Delaware | 42045 | 124389 | 1907 | 0 | 39.91680171 | -75.40243663 | 2022-07-31 04:21:02 | Delaware, Pennsylvania, US | |
2022-07-29 | US | Pennsylvania | Delaware | 42045 | 124389 | 1907 | 0 | 39.91680171 | -75.40243663 | 2022-07-30 04:20:42 | Delaware, Pennsylvania, US | |
2022-07-28 | US | Pennsylvania | Delaware | 42045 | 124389 | 1907 | 0 | 39.91680171 | -75.40243663 | 2022-07-29 04:20:45 | Delaware, Pennsylvania, US | |
2022-07-27 | US | Pennsylvania | Delaware | 42045 | 124389 | 1907 | 0 | 39.91680171 | -75.40243663 | 2022-07-28 04:20:56 | Delaware, Pennsylvania, US | |
2022-07-26 | US | Pennsylvania | Delaware | 42045 | 123472 | 1907 | 0 | 39.91680171 | -75.40243663 | 2022-07-27 04:21:04 | Delaware, Pennsylvania, US | |
2022-07-25 | US | Pennsylvania | Delaware | 42045 | 123472 | 1907 | 0 | 39.91680171 | -75.40243663 | 2022-07-26 04:20:58 | Delaware, Pennsylvania, US | |
2022-07-24 | US | Pennsylvania | Delaware | 42045 | 123472 | 1907 | 0 | 39.91680171 | -75.40243663 | 2022-07-25 04:20:51 | Delaware, Pennsylvania, US | |
2022-07-23 | US | Pennsylvania | Delaware | 42045 | 123472 | 1907 | 0 | 39.91680171 | -75.40243663 | 2022-07-24 04:20:47 | Delaware, Pennsylvania, US | |
2022-07-22 | US | Pennsylvania | Delaware | 42045 | 123472 | 1907 | 0 | 39.91680171 | -75.40243663 | 2022-07-23 04:20:53 | Delaware, Pennsylvania, US | |
2022-07-21 | US | Pennsylvania | Delaware | 42045 | 123472 | 1907 | 0 | 39.91680171 | -75.40243663 | 2022-07-22 04:21:15 | Delaware, Pennsylvania, US | |
2022-07-20 | US | Pennsylvania | Delaware | 42045 | 123472 | 1907 | 0 | 39.91680171 | -75.40243663 | 2022-07-21 04:21:10 | Delaware, Pennsylvania, US | |
2022-07-05 | US | Georgia | Gwinnett | 13135 | 221254 | 1907 | 0 | 33.96044201 | -84.02137802 | 2022-07-06 04:20:58 | Gwinnett, Georgia, US | |
2022-07-04 | US | Georgia | Gwinnett | 13135 | 221254 | 1907 | 0 | 33.96044201 | -84.02137802 | 2022-07-05 04:20:45 | Gwinnett, Georgia, US | |
2022-07-03 | US | Georgia | Gwinnett | 13135 | 221254 | 1907 | 0 | 33.96044201 | -84.02137802 | 2022-07-04 04:20:54 | Gwinnett, Georgia, US | |
2022-07-02 | US | Georgia | Gwinnett | 13135 | 221254 | 1907 | 0 | 33.96044201 | -84.02137802 | 2022-07-03 04:20:59 | Gwinnett, Georgia, US | |
2022-07-01 | US | Georgia | Gwinnett | 13135 | 221254 | 1907 | 0 | 33.96044201 | -84.02137802 | 2022-07-02 04:21:16 | Gwinnett, Georgia, US | |
2022-06-30 | US | Georgia | Gwinnett | 13135 | 221254 | 1907 | 0 | 33.96044201 | -84.02137802 | 2022-07-01 04:21:10 | Gwinnett, Georgia, US | |
2022-06-29 | US | Georgia | Gwinnett | 13135 | 221254 | 1907 | 0 | 33.96044201 | -84.02137802 | 2022-06-30 04:21:01 | Gwinnett, Georgia, US | |
2022-06-07 | US | Pennsylvania | Lancaster | 42071 | 125435 | 1907 | 0 | 40.03904563 | -76.24770128 | 2022-06-08 04:20:55 | Lancaster, Pennsylvania, US | |
2022-06-06 | US | Pennsylvania | Lancaster | 42071 | 125435 | 1907 | 0 | 40.03904563 | -76.24770128 | 2022-06-07 04:21:08 | Lancaster, Pennsylvania, US | |
2022-06-05 | US | Pennsylvania | Lancaster | 42071 | 125435 | 1907 | 0 | 40.03904563 | -76.24770128 | 2022-06-06 04:20:57 | Lancaster, Pennsylvania, US | |
2022-06-04 | US | Pennsylvania | Lancaster | 42071 | 125435 | 1907 | 0 | 40.03904563 | -76.24770128 | 2022-06-05 04:20:55 | Lancaster, Pennsylvania, US | |
2022-06-03 | US | Pennsylvania | Lancaster | 42071 | 125435 | 1907 | 0 | 40.03904563 | -76.24770128 | 2022-06-04 04:20:58 | Lancaster, Pennsylvania, US | |
2022-06-02 | US | Pennsylvania | Lancaster | 42071 | 125435 | 1907 | 0 | 40.03904563 | -76.24770128 | 2022-06-03 04:20:58 | Lancaster, Pennsylvania, US | |
2022-06-01 | US | Pennsylvania | Lancaster | 42071 | 125435 | 1907 | 0 | 40.03904563 | -76.24770128 | 2022-06-02 05:20:39 | Lancaster, Pennsylvania, US | |
2022-05-19 | US | Massachusetts | Norfolk | 25021 | 143365 | 1907 | 0 | 42.16073095 | -71.20530408 | 2022-05-20 04:20:57 | Norfolk, Massachusetts, US | |
2022-05-18 | Russia | Kaliningrad Oblast | 168507 | 1907 | 0 | 54.7293041 | 21.1489473 | 2022-05-19 04:20:54 | Kaliningrad Oblast, Russia | |||
2022-05-17 | Russia | Kaliningrad Oblast | 168486 | 1907 | 0 | 54.7293041 | 21.1489473 | 2022-05-18 04:20:50 | Kaliningrad Oblast, Russia | |||
2022-05-16 | Russia | Kaliningrad Oblast | 168461 | 1907 | 0 | 54.7293041 | 21.1489473 | 2022-05-17 04:20:59 | Kaliningrad Oblast, Russia | |||
2022-05-05 | Russia | Orel Oblast | 111879 | 1907 | 0 | 52.9685433 | 36.0692477 | 2022-05-06 04:21:00 | Orel Oblast, Russia | |||
2022-04-28 | Malaysia | Perak | 200390 | 1907 | 0 | 4.5921 | 101.0901 | 2022-04-29 04:20:59 | Perak, Malaysia | |||
2022-04-27 | Malaysia | Perak | 200197 | 1907 | 0 | 4.5921 | 101.0901 | 2022-04-28 04:20:47 | Perak, Malaysia | |||
2022-04-26 | Malaysia | Perak | 200055 | 1907 | 0 | 4.5921 | 101.0901 | 2022-04-27 04:20:52 | Perak, Malaysia | |||
2022-03-17 | Ukraine | Unknown | 113277 | 1907 | 0 | 0 | 2022-03-18 04:20:55 | Unknown, Ukraine | ||||
2022-02-10 | Russia | Sakha (Yakutiya) Republic | 132924 | 1907 | 0 | 66.941626 | 129.642371 | 2022-02-11 04:21:09 | Sakha (Yakutiya) Republic, Russia | |||
2022-02-10 | Cameroon | 117676 | 1907 | 0 | 3.8480000000000003 | 11.5021 | 2022-02-11 04:21:09 | Cameroon | ||||
2022-02-09 | Cameroon | 117676 | 1907 | 0 | 3.8480000000000003 | 11.5021 | 2022-02-10 04:21:14 | Cameroon | ||||
2022-02-08 | Cameroon | 117676 | 1907 | 0 | 3.8480000000000003 | 11.5021 | 2022-02-09 04:21:04 | Cameroon | ||||
2022-02-07 | Cameroon | 117676 | 1907 | 0 | 3.8480000000000003 | 11.5021 | 2022-02-08 04:21:15 | Cameroon | ||||
2022-01-28 | Russia | Belgorod Oblast | 86082 | 1907 | 0 | 50.7080119 | 37.5837615 | 2022-01-29 04:21:10 | Belgorod Oblast, Russia | |||
2022-01-23 | US | Ohio | Hamilton | 39061 | 175147 | 1907 | 0 | 39.19673558 | -84.54502924 | 2022-01-24 04:21:12 | Hamilton, Ohio, US | |
2022-01-21 | Colombia | Quindio | 66981 | 1907 | 0 | 4.461 | -75.6674 | 2022-01-22 04:21:13 | Quindio, Colombia | |||
2022-01-20 | Spain | Murcia | 278829 | 1907 | 0 | 37.9922 | -1.1307 | 2022-01-21 04:21:09 | Murcia, Spain | |||
2022-01-09 | Russia | Zabaykalsky Krai | 96883 | 1907 | 0 | 52.248521000000004 | 115.956325 | 2022-01-10 04:22:07 | Zabaykalsky Krai, Russia | |||
2021-12-25 | Estonia | 236133 | 1907 | 0 | 58.5953 | 25.0136 | 2021-12-26 04:21:50 | Estonia | ||||
2021-12-24 | Estonia | 235668 | 1907 | 0 | 58.5953 | 25.0136 | 2021-12-25 04:21:37 | Estonia | ||||
2021-12-08 | Germany | Hamburg | 119162 | 1907 | 0 | 53.5511 | 9.9937 | 2021-12-09 04:22:49 | Hamburg, Germany | |||
2021-11-06 | Yemen | 9858 | 1907 | 0 | 15.552726999999999 | 48.516388 | 2021-11-07 04:21:53 | Yemen | ||||
2021-11-02 | US | California | Santa Clara | 6085 | 147446 | 1907 | 0 | 37.23104908 | -121.6970462 | 2021-11-03 06:22:09 | Santa Clara, California, US | |
2021-10-23 | India | Manipur | 123229 | 1907 | 0 | 24.738975 | 93.882541 | 2021-10-24 04:21:22 | Manipur, India | |||
2021-10-22 | India | Manipur | 123107 | 1907 | 0 | 24.738975 | 93.882541 | 2021-10-23 04:21:32 | Manipur, India | |||
2021-10-15 | Russia | Buryatia Republic | 60503 | 1907 | 0 | 52.718242599999996 | 109.492143 | 2021-10-16 04:21:15 | Buryatia Republic, Russia | |||
2021-09-24 | Russia | Udmurt Republic | 51802 | 1907 | 0 | 57.1961165 | 52.69598320000001 | 2021-09-25 04:21:31 | Udmurt Republic, Russia | |||
2021-09-23 | Mozambique | 150370 | 1907 | 0 | -18.665695 | 35.529562 | 2021-09-24 04:21:44 | Mozambique | ||||
2021-09-20 | Ukraine | Mykolaiv Oblast | 72176 | 1907 | 0 | 46.975 | 31.9946 | 2021-09-21 04:21:26 | Mykolaiv Oblast, Ukraine | |||
2021-09-09 | Russia | Murmansk Oblast | 69468 | 1907 | 0 | 68.00004179999999 | 33.9999151 | 2021-09-10 04:21:20 | Murmansk Oblast, Russia | |||
2021-09-07 | Spain | Extremadura | 101223 | 1907 | 0 | 39.4937 | -6.0679 | 2021-09-08 04:21:31 | Extremadura, Spain | |||
2021-08-29 | Malaysia | Johor | 134226 | 1907 | 109408 | 22911 | 1.4854 | 103.7618 | 2021-08-30 04:21:23 | Johor, Malaysia | ||
2021-08-21 | Russia | Chuvashia Republic | 30908 | 1907 | 0 | 55.4259922 | 47.0849429 | 2021-08-22 04:21:29 | Chuvashia Republic, Russia | |||
2021-08-17 | Ukraine | Khmelnytskyi Oblast | 89730 | 1907 | 0 | 49.423 | 26.9871 | 2021-08-18 04:21:35 | Khmelnytskyi Oblast, Ukraine | |||
2021-08-12 | Brazil | Roraima | 121666 | 1907 | 0 | -2.7376 | -62.0751 | 2021-08-13 04:21:24 | Roraima, Brazil | |||
2021-08-06 | Russia | Volgograd Oblast | 73181 | 1907 | 0 | 49.6048339 | 44.29035820000001 | 2021-08-07 04:21:30 | Volgograd Oblast, Russia | |||
2021-08-03 | Russia | Stavropol Krai | 65547 | 1907 | 57075 | 6565 | 44.86325770000001 | 43.4406913 | 2021-08-04 04:21:25 | Stavropol Krai, Russia | ||
2021-08-01 | Brazil | Amapa | 121284 | 1907 | 102852 | 16525 | 0.902 | -52.003 | 2021-08-02 04:21:36 | Amapa, Brazil | ||
2021-07-31 | Brazil | Amapa | 121218 | 1907 | 102852 | 16459 | 0.902 | -52.003 | 2021-08-01 04:21:50 | Amapa, Brazil | ||
2021-07-21 | United Arab Emirates | 665533 | 1907 | 643234 | 20392 | 23.424076 | 53.847818 | 2021-07-22 04:21:19 | United Arab Emirates | |||
2021-07-17 | Mexico | Nayarit | 14327 | 1907 | 0 | 12420 | 21.7514 | -104.8455 | 2021-07-18 04:22:07 | Nayarit, Mexico | ||
2021-07-05 | Colombia | Risaralda | 78266 | 1907 | 73415 | 2944 | 5.3158 | -75.9928 | 2021-07-06 04:21:32 | Risaralda, Colombia | ||
2021-06-06 | Russia | Novosibirsk Oblast | 43835 | 1907 | 39674 | 2254 | 54.9720169 | 79.48139240000002 | 2021-06-07 04:22:51 | Novosibirsk Oblast, Russia | ||
2021-05-20 | US | New Jersey | Passaic | 34031 | 72532 | 1907 | 0 | 41.03238628 | -74.29954144 | 2021-05-21 04:20:43 | Passaic, New Jersey, US | |
2021-05-19 | US | New Jersey | Passaic | 34031 | 72478 | 1907 | 0 | 41.03238628 | -74.29954144 | 2021-05-20 04:21:05 | Passaic, New Jersey, US | |
2021-03-07 | El Salvador | 61251 | 1907 | 56807 | 2537 | 13.7942 | -88.8965 | 2021-03-08 05:24:48 | El Salvador | |||
2021-02-28 | Nigeria | 155657 | 1907 | 133768 | 19982 | 9.082 | 8.6753 | 2021-03-01 05:23:01 | Nigeria | |||
2021-02-12 | US | Puerto Rico | Unassigned | 72999 | 2849 | 1907 | 0 | 942 | 18.459681 | -67.336525 | 2021-02-13 05:22:12 | Unassigned, Puerto Rico, US |
2021-02-04 | India | Odisha | 335369 | 1907 | 332611 | 851 | 20.505428 | 84.418059 | 2021-02-05 05:22:38 | Odisha, India | ||
2021-02-03 | US | Michigan | Oakland | 26125 | 71177 | 1907 | 0 | 69270 | 42.66090111 | -83.38595416 | 2021-02-04 05:22:26 | Oakland, Michigan, US |
2021-01-23 | Russia | Sverdlovsk Oblast | 67526 | 1907 | 60015 | 5604 | 58.6414755 | 61.8021546 | 2021-01-24 05:22:35 | Sverdlovsk Oblast, Russia | ||
2021-01-06 | US | Connecticut | Hartford | 9003 | 50223 | 1907 | 0 | 48316 | 41.80283011 | -72.73103891 | 2021-01-07 05:22:03 | Hartford, Connecticut, US |
2020-11-10 | Spain | C. Valenciana | 73151 | 1907 | 9970 | 61274 | 39.484 | -0.7533 | 2020-11-11 05:25:30 | C. Valenciana, Spain | ||
2020-11-09 | Spain | C. Valenciana | 73151 | 1907 | 9970 | 61274 | 39.484 | -0.7533 | 2020-11-10 05:40:07 | C. Valenciana, Spain | ||
2020-10-31 | India | Rajasthan | 196993 | 1907 | 179984 | 15102 | 26.583423 | 73.847973 | 2020-11-01 04:36:19 | Rajasthan, India | ||
2020-10-24 | Algeria | 55880 | 1907 | 38932 | 15041 | 28.0339 | 1.6596 | 2020-10-25 04:24:36 | Algeria |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;