daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
90 rows where deaths = 2104 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-19 | Malaysia | Perak | 238127 | 2104 | 0 | 4.5921 | 101.0901 | 2022-12-20 04:21:04 | Perak, Malaysia | |||
2022-12-18 | Malaysia | Perak | 238097 | 2104 | 0 | 4.5921 | 101.0901 | 2022-12-19 04:21:03 | Perak, Malaysia | |||
2022-11-16 | US | Massachusetts | Suffolk | 25025 | 256682 | 2104 | 0 | 42.3279514 | -71.07850442 | 2022-11-17 04:21:11 | Suffolk, Massachusetts, US | |
2022-11-16 | US | Massachusetts | Norfolk | 25021 | 164922 | 2104 | 0 | 42.16073095 | -71.20530408 | 2022-11-17 04:21:11 | Norfolk, Massachusetts, US | |
2022-11-15 | US | Massachusetts | Suffolk | 25025 | 256682 | 2104 | 0 | 42.3279514 | -71.07850442 | 2022-11-16 04:21:09 | Suffolk, Massachusetts, US | |
2022-11-15 | US | Massachusetts | Norfolk | 25021 | 164922 | 2104 | 0 | 42.16073095 | -71.20530408 | 2022-11-16 04:21:09 | Norfolk, Massachusetts, US | |
2022-11-14 | US | Massachusetts | Suffolk | 25025 | 256682 | 2104 | 0 | 42.3279514 | -71.07850442 | 2022-11-15 04:21:16 | Suffolk, Massachusetts, US | |
2022-11-14 | US | Massachusetts | Norfolk | 25021 | 164922 | 2104 | 0 | 42.16073095 | -71.20530408 | 2022-11-15 04:21:16 | Norfolk, Massachusetts, US | |
2022-11-13 | US | Massachusetts | Suffolk | 25025 | 256682 | 2104 | 0 | 42.3279514 | -71.07850442 | 2022-11-14 04:21:09 | Suffolk, Massachusetts, US | |
2022-11-13 | US | Massachusetts | Norfolk | 25021 | 164922 | 2104 | 0 | 42.16073095 | -71.20530408 | 2022-11-14 04:21:09 | Norfolk, Massachusetts, US | |
2022-11-12 | US | Massachusetts | Suffolk | 25025 | 256682 | 2104 | 0 | 42.3279514 | -71.07850442 | 2022-11-13 04:21:14 | Suffolk, Massachusetts, US | |
2022-11-12 | US | Massachusetts | Norfolk | 25021 | 164922 | 2104 | 0 | 42.16073095 | -71.20530408 | 2022-11-13 04:21:14 | Norfolk, Massachusetts, US | |
2022-11-11 | US | Massachusetts | Suffolk | 25025 | 256682 | 2104 | 0 | 42.3279514 | -71.07850442 | 2022-11-12 04:20:41 | Suffolk, Massachusetts, US | |
2022-11-11 | US | Massachusetts | Norfolk | 25021 | 164922 | 2104 | 0 | 42.16073095 | -71.20530408 | 2022-11-12 04:20:41 | Norfolk, Massachusetts, US | |
2022-11-10 | US | Massachusetts | Suffolk | 25025 | 256682 | 2104 | 0 | 42.3279514 | -71.07850442 | 2022-11-11 04:21:22 | Suffolk, Massachusetts, US | |
2022-11-10 | US | Massachusetts | Norfolk | 25021 | 164922 | 2104 | 0 | 42.16073095 | -71.20530408 | 2022-11-11 04:21:22 | Norfolk, Massachusetts, US | |
2022-10-19 | US | New Mexico | Bernalillo | 35001 | 181844 | 2104 | 0 | 35.05163625 | -106.6703554 | 2022-10-20 04:22:59 | Bernalillo, New Mexico, US | |
2022-09-25 | US | Ohio | Montgomery | 39113 | 148380 | 2104 | 0 | 39.75394919 | -84.29050975 | 2022-09-26 04:20:52 | Montgomery, Ohio, US | |
2022-09-24 | US | Ohio | Montgomery | 39113 | 148380 | 2104 | 0 | 39.75394919 | -84.29050975 | 2022-09-25 04:23:31 | Montgomery, Ohio, US | |
2022-07-20 | US | Maryland | Montgomery | 24031 | 206399 | 2104 | 0 | 39.13676329 | -77.20358245 | 2022-07-21 04:21:10 | Montgomery, Maryland, US | |
2022-07-19 | US | Maryland | Montgomery | 24031 | 205955 | 2104 | 0 | 39.13676329 | -77.20358245 | 2022-07-20 04:20:59 | Montgomery, Maryland, US | |
2022-07-09 | Japan | Aichi | 589307 | 2104 | 0 | 35.035551 | 137.211621 | 2022-07-10 04:20:54 | Aichi, Japan | |||
2022-04-15 | Russia | Sakha (Yakutiya) Republic | 176470 | 2104 | 0 | 66.941626 | 129.642371 | 2022-04-16 04:20:48 | Sakha (Yakutiya) Republic, Russia | |||
2022-04-14 | Russia | Sakha (Yakutiya) Republic | 176301 | 2104 | 0 | 66.941626 | 129.642371 | 2022-04-15 04:20:57 | Sakha (Yakutiya) Republic, Russia | |||
2022-04-13 | Russia | Sakha (Yakutiya) Republic | 176144 | 2104 | 0 | 66.941626 | 129.642371 | 2022-04-13 23:21:06 | Sakha (Yakutiya) Republic, Russia | |||
2022-03-23 | US | Oklahoma | Tulsa | 40143 | 169175 | 2104 | 0 | 36.11939621 | -95.94013939 | 2022-03-24 04:20:43 | Tulsa, Oklahoma, US | |
2022-03-22 | US | Oklahoma | Tulsa | 40143 | 169175 | 2104 | 0 | 36.11939621 | -95.94013939 | 2022-03-23 04:20:48 | Tulsa, Oklahoma, US | |
2022-03-21 | US | Oklahoma | Tulsa | 40143 | 169175 | 2104 | 0 | 36.11939621 | -95.94013939 | 2022-03-22 04:20:54 | Tulsa, Oklahoma, US | |
2022-03-20 | US | Oklahoma | Tulsa | 40143 | 169175 | 2104 | 0 | 36.11939621 | -95.94013939 | 2022-03-21 04:20:50 | Tulsa, Oklahoma, US | |
2022-03-19 | US | Oklahoma | Tulsa | 40143 | 169175 | 2104 | 0 | 36.11939621 | -95.94013939 | 2022-03-20 04:20:45 | Tulsa, Oklahoma, US | |
2022-03-18 | US | Oklahoma | Tulsa | 40143 | 169175 | 2104 | 0 | 36.11939621 | -95.94013939 | 2022-03-19 04:20:47 | Tulsa, Oklahoma, US | |
2022-03-18 | Russia | Belgorod Oblast | 123500 | 2104 | 0 | 50.7080119 | 37.5837615 | 2022-03-19 04:20:47 | Belgorod Oblast, Russia | |||
2022-03-17 | US | Oklahoma | Tulsa | 40143 | 169175 | 2104 | 0 | 36.11939621 | -95.94013939 | 2022-03-18 04:20:55 | Tulsa, Oklahoma, US | |
2022-03-09 | US | California | San Joaquin | 6077 | 175273 | 2104 | 0 | 37.93433732 | -121.2730061 | 2022-03-10 04:20:48 | San Joaquin, California, US | |
2022-03-09 | Mongolia | 914016 | 2104 | 0 | 46.8625 | 103.8467 | 2022-03-10 04:20:48 | Mongolia | ||||
2022-03-09 | Italy | Sardegna | 187466 | 2104 | 0 | 39.21531192 | 9.110616306 | 2022-03-10 04:20:48 | Sardegna, Italy | |||
2022-03-08 | Mongolia | 913444 | 2104 | 0 | 46.8625 | 103.8467 | 2022-03-09 04:20:59 | Mongolia | ||||
2022-03-07 | Mongolia | 913255 | 2104 | 0 | 46.8625 | 103.8467 | 2022-03-08 04:20:54 | Mongolia | ||||
2022-02-23 | India | Manipur | 136598 | 2104 | 0 | 24.738975 | 93.882541 | 2022-02-24 04:21:14 | Manipur, India | |||
2022-02-22 | India | Manipur | 136548 | 2104 | 0 | 24.738975 | 93.882541 | 2022-02-23 04:21:09 | Manipur, India | |||
2022-02-21 | Russia | Tambov Oblast | 91886 | 2104 | 0 | 52.9019574 | 41.3578918 | 2022-02-22 04:21:01 | Tambov Oblast, Russia | |||
2022-02-10 | Mexico | Colima | 50672 | 2104 | 0 | 19.1223 | -104.0072 | 2022-02-11 04:21:09 | Colima, Mexico | |||
2022-02-09 | Mexico | Colima | 50672 | 2104 | 0 | 19.1223 | -104.0072 | 2022-02-10 04:21:14 | Colima, Mexico | |||
2022-02-04 | Brazil | Roraima | 145077 | 2104 | 0 | -2.7376 | -62.0751 | 2022-02-05 04:21:05 | Roraima, Brazil | |||
2022-01-09 | US | New Jersey | Passaic | 34031 | 123940 | 2104 | 0 | 41.03238628 | -74.29954144 | 2022-01-10 04:22:07 | Passaic, New Jersey, US | |
2021-12-18 | Mexico | Campeche | 24246 | 2104 | 0 | 19.8301 | -90.5349 | 2021-12-19 04:21:11 | Campeche, Mexico | |||
2021-12-17 | Mexico | Campeche | 24241 | 2104 | 0 | 19.8301 | -90.5349 | 2021-12-18 02:22:20 | Campeche, Mexico | |||
2021-12-16 | Mexico | Campeche | 24241 | 2104 | 0 | 19.8301 | -90.5349 | 2021-12-17 04:22:14 | Campeche, Mexico | |||
2021-12-15 | Mexico | Campeche | 24237 | 2104 | 0 | 19.8301 | -90.5349 | 2021-12-16 04:22:11 | Campeche, Mexico | |||
2021-12-14 | Mexico | Campeche | 24234 | 2104 | 0 | 19.8301 | -90.5349 | 2021-12-15 03:22:16 | Campeche, Mexico | |||
2021-12-13 | Mexico | Campeche | 24234 | 2104 | 0 | 19.8301 | -90.5349 | 2021-12-14 04:22:38 | Campeche, Mexico | |||
2021-12-12 | Mexico | Campeche | 24233 | 2104 | 0 | 19.8301 | -90.5349 | 2021-12-13 04:22:02 | Campeche, Mexico | |||
2021-11-27 | Russia | Ivanovo Oblast | 61428 | 2104 | 0 | 56.9167446 | 41.43521370000001 | 2021-11-28 04:22:43 | Ivanovo Oblast, Russia | |||
2021-10-09 | Peru | Ayacucho | 33813 | 2104 | 0 | -14.091648000000001 | -74.08344 | 2021-10-10 04:21:38 | Ayacucho, Peru | |||
2021-10-08 | Peru | Ayacucho | 33813 | 2104 | 0 | -14.091648000000001 | -74.08344 | 2021-10-09 04:21:34 | Ayacucho, Peru | |||
2021-10-07 | Ukraine | Chernivtsi Oblast | 92722 | 2104 | 0 | 48.2917 | 25.9352 | 2021-10-08 04:21:25 | Chernivtsi Oblast, Ukraine | |||
2021-10-07 | Netherlands | Gelderland | 223384 | 2104 | 0 | 52.061738 | 5.939114 | 2021-10-08 04:21:25 | Gelderland, Netherlands | |||
2021-10-05 | United Arab Emirates | 737073 | 2104 | 0 | 23.424076 | 53.847818000000004 | 2021-10-06 04:21:33 | United Arab Emirates | ||||
2021-09-16 | Syria | 30153 | 2104 | 0 | 34.802075 | 38.99681500000001 | 2021-09-17 04:21:46 | Syria | ||||
2021-08-02 | Korea, South | 202203 | 2104 | 177909 | 22190 | 35.90775700000001 | 127.766922 | 2021-08-03 04:21:39 | Korea, South | |||
2021-07-23 | Ukraine | Ivano-Frankivsk Oblast | 86808 | 2104 | 84599 | 105 | 48.9226 | 24.7111 | 2021-07-24 00:21:36 | Ivano-Frankivsk Oblast, Ukraine | ||
2021-07-22 | Ukraine | Ivano-Frankivsk Oblast | 86798 | 2104 | 84595 | 99 | 48.9226 | 24.7111 | 2021-07-23 04:21:29 | Ivano-Frankivsk Oblast, Ukraine | ||
2021-07-21 | Ukraine | Ivano-Frankivsk Oblast | 86784 | 2104 | 84591 | 89 | 48.9226 | 24.7111 | 2021-07-22 04:21:19 | Ivano-Frankivsk Oblast, Ukraine | ||
2021-07-20 | Ukraine | Ivano-Frankivsk Oblast | 86776 | 2104 | 84585 | 87 | 48.9226 | 24.7111 | 2021-07-21 04:21:40 | Ivano-Frankivsk Oblast, Ukraine | ||
2021-07-19 | Ukraine | Ivano-Frankivsk Oblast | 86769 | 2104 | 84584 | 81 | 48.9226 | 24.7111 | 2021-07-20 04:21:48 | Ivano-Frankivsk Oblast, Ukraine | ||
2021-07-18 | Ukraine | Ivano-Frankivsk Oblast | 86769 | 2104 | 84581 | 84 | 48.9226 | 24.7111 | 2021-07-19 04:21:24 | Ivano-Frankivsk Oblast, Ukraine | ||
2021-07-17 | Ukraine | Ivano-Frankivsk Oblast | 86763 | 2104 | 84575 | 84 | 48.9226 | 24.7111 | 2021-07-18 04:22:07 | Ivano-Frankivsk Oblast, Ukraine | ||
2021-07-16 | Ukraine | Ivano-Frankivsk Oblast | 86753 | 2104 | 84565 | 84 | 48.9226 | 24.7111 | 2021-07-17 04:22:22 | Ivano-Frankivsk Oblast, Ukraine | ||
2021-07-11 | Uganda | 87277 | 2104 | 61304 | 23869 | 1.373333 | 32.290275 | 2021-07-12 04:21:34 | Uganda | |||
2021-06-12 | Russia | Tula Oblast | 40790 | 2104 | 38207 | 479 | 53.9570701 | 37.3690909 | 2021-06-13 04:22:44 | Tula Oblast, Russia | ||
2021-06-06 | Colombia | Bolivar | 110020 | 2104 | 105283 | 2633 | 8.6704 | -74.03 | 2021-06-07 04:22:51 | Bolivar, Colombia | ||
2021-05-17 | US | Connecticut | New Haven | 9009 | 91372 | 2104 | 0 | 41.4080325 | -72.93620426 | 2021-05-18 04:20:33 | New Haven, Connecticut, US | |
2021-05-07 | Russia | Altai Krai | 50144 | 2104 | 45070 | 2970 | 52.6932243 | 82.69314240000001 | 2021-05-08 04:21:04 | Altai Krai, Russia | ||
2021-05-05 | India | Odisha | 489641 | 2104 | 416403 | 71134 | 20.505428 | 84.418059 | 2021-05-06 04:20:38 | Odisha, India | ||
2021-04-14 | US | Michigan | Oakland | 26125 | 100691 | 2104 | 0 | 42.66090111 | -83.38595416 | 2021-04-15 04:20:54 | Oakland, Michigan, US | |
2021-03-27 | Kenya | 129330 | 2104 | 91665 | 35561 | -0.0236 | 37.9062 | 2021-03-28 05:28:10 | Kenya | |||
2021-03-25 | US | Connecticut | Fairfield | 9001 | 87366 | 2104 | 0 | 41.26809896 | -73.3881171 | 2021-03-26 05:26:55 | Fairfield, Connecticut, US | |
2021-03-05 | Pakistan | Khyber Pakhtunkhwa | 73515 | 2104 | 69106 | 2305 | 34.485332 | 72.09169 | 2021-03-06 04:23:41 | Khyber Pakhtunkhwa, Pakistan | ||
2021-03-03 | Mexico | Durango | 31026 | 2104 | 0 | 28922 | 24.5593 | -104.6588 | 2021-03-04 05:24:24 | Durango, Mexico | ||
2021-02-23 | Mexico | Tlaxcala | 16935 | 2104 | 0 | 14831 | 19.3139 | -98.2404 | 2021-02-24 05:29:16 | Tlaxcala, Mexico | ||
2021-02-14 | Italy | Marche | 60808 | 2104 | 50574 | 8130 | 43.61675973 | 13.5188753 | 2021-02-15 05:24:49 | Marche, Italy | ||
2021-01-19 | Germany | Rheinland-Pfalz | 85559 | 2104 | 70277 | 13702 | 50.1183 | 7.309 | 2021-01-20 05:21:54 | Rheinland-Pfalz, Germany | ||
2020-12-29 | Mexico | Oaxaca | 27945 | 2104 | 0 | 25841 | 17.0732 | -96.7266 | 2020-12-30 05:22:34 | Oaxaca, Mexico | ||
2020-11-03 | Mexico | San Luis Potosi | 29287 | 2104 | 26143 | 1040 | 22.1565 | -100.9855 | 2020-11-04 05:25:09 | San Luis Potosi, Mexico | ||
2020-08-24 | Italy | Veneto | 22071 | 2104 | 17919 | 2048 | 45.43490485 | 12.33845213 | 2020-08-25 04:28:02 | Veneto, Italy | ||
2020-08-23 | Italy | Veneto | 21955 | 2104 | 17862 | 1989 | 45.43490485 | 12.33845213 | 2020-08-24 04:27:56 | Veneto, Italy | ||
2020-08-22 | Italy | Veneto | 21810 | 2104 | 17714 | 1992 | 45.43490485 | 12.33845213 | 2020-08-23 04:27:48 | Veneto, Italy | ||
2020-08-18 | Peru | Ancash | 15409 | 2104 | 0 | 13305 | -9.407125 | -77.671795 | 2020-08-19 04:27:00 | Ancash, Peru | ||
2020-08-03 | Philippines | 106330 | 2104 | 65821 | 38405 | 12.879721 | 121.774017 | 2020-08-04 04:41:59 | Philippines | |||
2020-08-03 | US | New Jersey | Essex | 34013 | 19727 | 2104 | 0 | 17623 | 40.78681335 | -74.24657979 | 2020-08-04 04:41:59 | Essex, New Jersey, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;