johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
138 rows where deaths = 1604 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 29
- US 40
- Canada 18
- Spain 18
- Peru 13
- Russia 8
- Colombia 4
- India 4
- Ukraine 4
- Chile 3
- Italy 3
- Mexico 3
- Germany 2
- Netherlands 2
- Brazil 1
- El Salvador 1
- Ireland 1
- Israel 1
- Japan 1
- Kenya 1
- Kyrgyzstan 1
- Mongolia 1
- Montenegro 1
- Serbia 1
- Singapore 1
- United Arab Emirates 1
- Uzbekistan 1
- West Bank and Gaza 1
- Yemen 1
- Zimbabwe 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
543062 | 543062 | 2022-12-15 | Spain | Baleares | 312622 | 1604 | 0 | 39.710358 | 2.995148 | 2022-12-16 04:21:01 | Baleares, Spain | |||
348590 | 348590 | 2022-12-14 | Spain | Baleares | 312622 | 1604 | 0 | 39.710358 | 2.995148 | 2022-12-15 04:20:58 | Baleares, Spain | |||
308178 | 308178 | 2022-12-13 | Spain | Baleares | 312622 | 1604 | 0 | 39.710358 | 2.995148 | 2022-12-14 04:21:04 | Baleares, Spain | |||
1149239 | 1149239 | 2022-12-12 | Spain | Baleares | 312622 | 1604 | 0 | 39.710358 | 2.995148 | 2022-12-13 04:21:01 | Baleares, Spain | |||
869093 | 869093 | 2022-12-11 | Spain | Baleares | 312622 | 1604 | 0 | 39.710358 | 2.995148 | 2022-12-12 04:21:01 | Baleares, Spain | |||
257623 | 257623 | 2022-12-10 | Spain | Baleares | 312622 | 1604 | 0 | 39.710358 | 2.995148 | 2022-12-11 04:20:50 | Baleares, Spain | |||
3936337 | 3936337 | 2022-12-09 | Spain | Baleares | 312622 | 1604 | 0 | 39.710358 | 2.995148 | 2022-12-10 04:21:02 | Baleares, Spain | |||
1622990 | 1622990 | 2022-11-22 | US | Pennsylvania | York | 42133 | 139393 | 1604 | 0 | 39.9210089 | -76.73040131 | 2022-11-23 04:21:06 | York, Pennsylvania, US | |
3462878 | 3462878 | 2022-11-21 | US | Pennsylvania | York | 42133 | 139393 | 1604 | 0 | 39.9210089 | -76.73040131 | 2022-11-22 04:20:47 | York, Pennsylvania, US | |
1643063 | 1643063 | 2022-11-20 | US | Pennsylvania | York | 42133 | 139393 | 1604 | 0 | 39.9210089 | -76.73040131 | 2022-11-21 04:21:05 | York, Pennsylvania, US | |
2066620 | 2066620 | 2022-11-19 | US | Pennsylvania | York | 42133 | 139393 | 1604 | 0 | 39.9210089 | -76.73040131 | 2022-11-20 04:21:08 | York, Pennsylvania, US | |
1758014 | 1758014 | 2022-11-18 | US | Pennsylvania | York | 42133 | 139393 | 1604 | 0 | 39.9210089 | -76.73040131 | 2022-11-19 04:21:14 | York, Pennsylvania, US | |
3029007 | 3029007 | 2022-11-17 | US | Pennsylvania | York | 42133 | 139393 | 1604 | 0 | 39.9210089 | -76.73040131 | 2022-11-18 04:21:15 | York, Pennsylvania, US | |
2488718 | 2488718 | 2022-11-16 | US | Pennsylvania | York | 42133 | 139393 | 1604 | 0 | 39.9210089 | -76.73040131 | 2022-11-17 04:21:11 | York, Pennsylvania, US | |
3596804 | 3596804 | 2022-11-14 | Canada | Saskatchewan | 146888 | 1604 | 0 | 52.9399 | -106.4509 | 2022-11-15 04:21:16 | Saskatchewan, Canada | |||
311662 | 311662 | 2022-11-13 | Canada | Saskatchewan | 146888 | 1604 | 0 | 52.9399 | -106.4509 | 2022-11-14 04:21:09 | Saskatchewan, Canada | |||
62823 | 62823 | 2022-11-12 | Canada | Saskatchewan | 146888 | 1604 | 0 | 52.9399 | -106.4509 | 2022-11-13 04:21:14 | Saskatchewan, Canada | |||
2926985 | 2926985 | 2022-11-11 | Canada | Saskatchewan | 146888 | 1604 | 0 | 52.9399 | -106.4509 | 2022-11-12 04:20:41 | Saskatchewan, Canada | |||
2505821 | 2505821 | 2022-11-10 | Canada | Saskatchewan | 146888 | 1604 | 0 | 52.9399 | -106.4509 | 2022-11-11 04:21:22 | Saskatchewan, Canada | |||
2430696 | 2430696 | 2022-11-09 | Canada | Saskatchewan | 146888 | 1604 | 0 | 52.9399 | -106.4509 | 2022-11-10 04:21:16 | Saskatchewan, Canada | |||
479352 | 479352 | 2022-11-08 | Canada | Saskatchewan | 146888 | 1604 | 0 | 52.9399 | -106.4509 | 2022-11-09 04:21:22 | Saskatchewan, Canada | |||
2438502 | 2438502 | 2022-11-07 | Canada | Saskatchewan | 146888 | 1604 | 0 | 52.9399 | -106.4509 | 2022-11-08 04:21:21 | Saskatchewan, Canada | |||
1049600 | 1049600 | 2022-11-06 | Canada | Saskatchewan | 146888 | 1604 | 0 | 52.9399 | -106.4509 | 2022-11-07 04:21:26 | Saskatchewan, Canada | |||
617624 | 617624 | 2022-11-05 | Canada | Saskatchewan | 146888 | 1604 | 0 | 52.9399 | -106.4509 | 2022-11-06 04:21:24 | Saskatchewan, Canada | |||
1022128 | 1022128 | 2022-11-04 | Canada | Saskatchewan | 146888 | 1604 | 0 | 52.9399 | -106.4509 | 2022-11-05 04:21:52 | Saskatchewan, Canada | |||
431119 | 431119 | 2022-11-03 | Canada | Saskatchewan | 146888 | 1604 | 0 | 52.9399 | -106.4509 | 2022-11-04 04:22:11 | Saskatchewan, Canada | |||
849361 | 849361 | 2022-11-02 | Canada | Saskatchewan | 146888 | 1604 | 0 | 52.9399 | -106.4509 | 2022-11-03 04:22:05 | Saskatchewan, Canada | |||
710212 | 710212 | 2022-11-01 | Canada | Saskatchewan | 146888 | 1604 | 0 | 52.9399 | -106.4509 | 2022-11-02 04:22:09 | Saskatchewan, Canada | |||
3284661 | 3284661 | 2022-10-31 | Canada | Saskatchewan | 146888 | 1604 | 0 | 52.9399 | -106.4509 | 2022-11-01 04:22:36 | Saskatchewan, Canada | |||
319694 | 319694 | 2022-10-30 | Canada | Saskatchewan | 146888 | 1604 | 0 | 52.9399 | -106.4509 | 2022-10-31 04:21:36 | Saskatchewan, Canada | |||
911970 | 911970 | 2022-10-29 | Canada | Saskatchewan | 146888 | 1604 | 0 | 52.9399 | -106.4509 | 2022-10-30 04:22:14 | Saskatchewan, Canada | |||
1366239 | 1366239 | 2022-10-28 | Canada | Saskatchewan | 146888 | 1604 | 0 | 52.9399 | -106.4509 | 2022-10-29 04:21:13 | Saskatchewan, Canada | |||
797752 | 797752 | 2022-10-24 | US | Virginia | Fairfax | 51059 | 239527 | 1604 | 0 | 38.83677558 | -77.27565836 | 2022-10-25 04:21:53 | Fairfax, Virginia, US | |
2032760 | 2032760 | 2022-10-14 | Italy | P.A. Trento | 223329 | 1604 | 0 | 46.06893511 | 11.12123097 | 2022-10-15 04:22:00 | P.A. Trento, Italy | |||
1889425 | 1889425 | 2022-09-14 | Singapore | 1867168 | 1604 | 0 | 1.2833 | 103.8333 | 2022-09-15 04:21:02 | Singapore | ||||
3766942 | 3766942 | 2022-09-11 | US | Illinois | Will | 17197 | 197341 | 1604 | 0 | 41.44619267 | -87.97862712 | 2022-09-12 04:20:58 | Will, Illinois, US | |
3825517 | 3825517 | 2022-09-10 | US | Illinois | Will | 17197 | 197341 | 1604 | 0 | 41.44619267 | -87.97862712 | 2022-09-11 04:20:50 | Will, Illinois, US | |
963974 | 963974 | 2022-09-09 | US | Illinois | Will | 17197 | 197341 | 1604 | 0 | 41.44619267 | -87.97862712 | 2022-09-10 04:21:10 | Will, Illinois, US | |
254376 | 254376 | 2022-09-08 | US | Illinois | Will | 17197 | 197182 | 1604 | 0 | 41.44619267 | -87.97862712 | 2022-09-09 04:21:11 | Will, Illinois, US | |
1879165 | 1879165 | 2022-08-28 | US | New Jersey | Morris | 34027 | 146156 | 1604 | 0 | 40.86095313 | -74.5455371 | 2022-08-29 04:21:06 | Morris, New Jersey, US | |
2098292 | 2098292 | 2022-08-27 | US | New Jersey | Morris | 34027 | 146078 | 1604 | 0 | 40.86095313 | -74.5455371 | 2022-08-28 04:21:02 | Morris, New Jersey, US | |
1534107 | 1534107 | 2022-08-26 | US | New Jersey | Morris | 34027 | 145933 | 1604 | 0 | 40.86095313 | -74.5455371 | 2022-08-27 04:20:57 | Morris, New Jersey, US | |
2830994 | 2830994 | 2022-08-25 | US | New Jersey | Morris | 34027 | 145816 | 1604 | 0 | 40.86095313 | -74.5455371 | 2022-08-26 04:21:02 | Morris, New Jersey, US | |
3238315 | 3238315 | 2022-03-21 | Japan | Chiba | 333713 | 1604 | 0 | 35.510141 | 140.198917 | 2022-03-22 04:20:54 | Chiba, Japan | |||
3628129 | 3628129 | 2022-03-13 | Peru | Moquegua | 48089 | 1604 | 0 | -16.860271 | -70.839046 | 2022-03-14 04:20:46 | Moquegua, Peru | |||
951037 | 951037 | 2022-03-12 | Peru | Moquegua | 48089 | 1604 | 0 | -16.860271 | -70.839046 | 2022-03-13 04:20:49 | Moquegua, Peru | |||
356498 | 356498 | 2022-03-11 | Peru | Moquegua | 48089 | 1604 | 0 | -16.860271 | -70.839046 | 2022-03-12 04:20:50 | Moquegua, Peru | |||
1865650 | 1865650 | 2022-03-10 | Peru | Moquegua | 48089 | 1604 | 0 | -16.860271 | -70.839046 | 2022-03-11 04:20:50 | Moquegua, Peru | |||
2140345 | 2140345 | 2022-03-09 | Peru | Moquegua | 48089 | 1604 | 0 | -16.860271 | -70.839046 | 2022-03-10 04:20:48 | Moquegua, Peru | |||
919856 | 919856 | 2022-03-08 | Peru | Moquegua | 48089 | 1604 | 0 | -16.860271 | -70.839046 | 2022-03-09 04:20:59 | Moquegua, Peru | |||
1548143 | 1548143 | 2022-03-07 | Peru | Moquegua | 48089 | 1604 | 0 | -16.860271 | -70.839046 | 2022-03-08 04:20:54 | Moquegua, Peru | |||
2199812 | 2199812 | 2022-03-06 | Peru | Moquegua | 48089 | 1604 | 0 | -16.860271 | -70.839046 | 2022-03-07 04:20:47 | Moquegua, Peru | |||
2092269 | 2092269 | 2022-03-05 | Peru | Moquegua | 48089 | 1604 | 0 | -16.860271 | -70.839046 | 2022-03-06 04:20:49 | Moquegua, Peru | |||
2665969 | 2665969 | 2022-03-04 | Peru | Moquegua | 48089 | 1604 | 0 | -16.860271 | -70.839046 | 2022-03-05 04:21:10 | Moquegua, Peru | |||
575421 | 575421 | 2022-02-25 | US | California | Stanislaus | 6099 | 134425 | 1604 | 0 | 37.55862499 | -120.9970722 | 2022-02-26 04:21:12 | Stanislaus, California, US | |
2645423 | 2645423 | 2022-02-14 | Uzbekistan | 233761 | 1604 | 0 | 41.377491 | 64.585262 | 2022-02-15 04:21:09 | Uzbekistan | ||||
185843 | 185843 | 2022-02-13 | Chile | Los Lagos | 134434 | 1604 | 0 | -41.9198 | -72.1416 | 2022-02-14 04:20:51 | Los Lagos, Chile | |||
3230088 | 3230088 | 2022-01-19 | Ukraine | Kirovohrad Oblast | 34209 | 1604 | 0 | 48.5079 | 32.2623 | 2022-01-20 04:21:07 | Kirovohrad Oblast, Ukraine | |||
3687307 | 3687307 | 2022-01-13 | Colombia | Cauca | 62003 | 1604 | 0 | 2.705 | -76.82600000000002 | 2022-01-14 04:21:54 | Cauca, Colombia | |||
3612891 | 3612891 | 2022-01-12 | Colombia | Cauca | 61234 | 1604 | 0 | 2.705 | -76.82600000000002 | 2022-01-13 08:00:09 | Cauca, Colombia | |||
1694985 | 1694985 | 2022-01-10 | US | Pennsylvania | Delaware | 42045 | 93468 | 1604 | 0 | 39.91680171 | -75.40243663 | 2022-01-11 04:22:01 | Delaware, Pennsylvania, US | |
129400 | 129400 | 2022-01-09 | US | Pennsylvania | Delaware | 42045 | 92202 | 1604 | 0 | 39.91680171 | -75.40243663 | 2022-01-10 04:22:07 | Delaware, Pennsylvania, US | |
1218235 | 1218235 | 2022-01-08 | US | Pennsylvania | Delaware | 42045 | 90745 | 1604 | 0 | 39.91680171 | -75.40243663 | 2022-01-09 04:21:46 | Delaware, Pennsylvania, US | |
1283594 | 1283594 | 2022-01-05 | US | Massachusetts | Norfolk | 25021 | 93967 | 1604 | 0 | 42.16073095 | -71.20530408 | 2022-01-06 04:22:09 | Norfolk, Massachusetts, US | |
2170059 | 2170059 | 2022-01-01 | US | Ohio | Montgomery | 39113 | 89842 | 1604 | 0 | 39.75394919 | -84.29050975 | 2022-01-02 04:20:52 | Montgomery, Ohio, US | |
1078117 | 1078117 | 2021-12-09 | Russia | Belgorod Oblast | 75851 | 1604 | 0 | 50.7080119 | 37.5837615 | 2021-12-10 04:22:28 | Belgorod Oblast, Russia | |||
1231843 | 1231843 | 2021-11-28 | Russia | Khakassia Republic | 49436 | 1604 | 0 | 53.72258845 | 91.44293627 | 2021-11-29 04:22:30 | Khakassia Republic, Russia | |||
2289063 | 2289063 | 2021-11-15 | US | Massachusetts | Suffolk | 25025 | 110095 | 1604 | 0 | 42.327951399999996 | -71.07850442 | 2021-11-16 04:21:10 | Suffolk, Massachusetts, US | |
3492285 | 3492285 | 2021-10-26 | Mongolia | 544794 | 1604 | 0 | 46.8625 | 103.8467 | 2021-10-27 04:22:32 | Mongolia | ||||
2773181 | 2773181 | 2021-09-30 | Russia | Ivanovo Oblast | 48937 | 1604 | 0 | 56.9167446 | 41.43521370000001 | 2021-10-01 04:21:35 | Ivanovo Oblast, Russia | |||
1374708 | 1374708 | 2021-09-15 | Russia | Komi Republic | 66701 | 1604 | 0 | 63.9881421 | 54.3326073 | 2021-09-16 04:22:19 | Komi Republic, Russia | |||
1389301 | 1389301 | 2021-09-13 | Yemen | 8452 | 1604 | 0 | 15.552726999999999 | 48.516388 | 2021-09-14 04:21:41 | Yemen | ||||
1388091 | 1388091 | 2021-09-13 | US | Ohio | Franklin | 39049 | 146809 | 1604 | 0 | 39.96995815 | -83.01115755 | 2021-09-14 04:21:41 | Franklin, Ohio, US | |
1262782 | 1262782 | 2021-09-09 | Italy | Sardegna | 73814 | 1604 | 0 | 39.21531192 | 9.110616306 | 2021-09-10 04:21:20 | Sardegna, Italy | |||
3974822 | 3974822 | 2021-09-03 | Russia | Udmurt Republic | 47027 | 1604 | 0 | 57.1961165 | 52.69598320000001 | 2021-09-04 04:21:28 | Udmurt Republic, Russia | |||
2067986 | 2067986 | 2021-08-31 | Mexico | Colima | 26143 | 1604 | 0 | 19.1223 | -104.0072 | 2021-09-01 04:21:38 | Colima, Mexico | |||
1854251 | 1854251 | 2021-08-20 | Russia | Vladimir Oblast | 47210 | 1604 | 0 | 56.0503336 | 40.656163299999996 | 2021-08-21 04:21:38 | Vladimir Oblast, Russia | |||
3905555 | 3905555 | 2021-07-31 | US | Maryland | Prince George's | 24033 | 86765 | 1604 | 0 | 38.83070039 | -76.8496441 | 2021-08-01 04:21:50 | Prince George's, Maryland, US | |
3297760 | 3297760 | 2021-07-30 | US | Maryland | Prince George's | 24033 | 86656 | 1604 | 0 | 38.83070039 | -76.8496441 | 2021-07-31 04:21:35 | Prince George's, Maryland, US | |
626075 | 626075 | 2021-07-10 | Russia | Chuvashia Republic | 27886 | 1604 | 25468 | 814 | 55.4259922 | 47.0849429 | 2021-07-11 04:21:43 | Chuvashia Republic, Russia | ||
1440660 | 1440660 | 2021-07-07 | Mexico | Baja California Sur | 41868 | 1604 | 0 | 40264 | 26.0444 | -111.6661 | 2021-07-08 04:21:26 | Baja California Sur, Mexico | ||
2075561 | 2075561 | 2021-07-02 | Ukraine | Zakarpattia Oblast | 62100 | 1604 | 60340 | 156 | 48.6208 | 22.2879 | 2021-07-03 04:21:37 | Zakarpattia Oblast, Ukraine | ||
2768577 | 2768577 | 2021-07-01 | Ukraine | Zakarpattia Oblast | 62095 | 1604 | 60322 | 169 | 48.6208 | 22.2879 | 2021-07-02 04:21:47 | Zakarpattia Oblast, Ukraine | ||
2884670 | 2884670 | 2021-06-20 | Spain | Murcia | 114090 | 1604 | 2180 | 110306 | 37.9922 | -1.1307 | 2021-06-21 04:21:41 | Murcia, Spain | ||
107753 | 107753 | 2021-06-19 | Spain | Murcia | 114090 | 1604 | 2180 | 110306 | 37.9922 | -1.1307 | 2021-06-20 04:21:48 | Murcia, Spain | ||
1125896 | 1125896 | 2021-06-18 | Spain | Murcia | 114090 | 1604 | 2180 | 110306 | 37.9922 | -1.1307 | 2021-06-19 04:22:33 | Murcia, Spain | ||
2911474 | 2911474 | 2021-06-17 | Spain | Murcia | 114032 | 1604 | 2180 | 110248 | 37.9922 | -1.1307 | 2021-06-18 04:22:16 | Murcia, Spain | ||
2911284 | 2911284 | 2021-06-17 | Montenegro | 100020 | 1604 | 98057 | 359 | 42.708678000000006 | 19.37439 | 2021-06-18 04:22:16 | Montenegro | |||
3030590 | 3030590 | 2021-06-16 | Spain | Murcia | 113942 | 1604 | 2180 | 110158 | 37.9922 | -1.1307 | 2021-06-17 04:22:36 | Murcia, Spain | ||
2339696 | 2339696 | 2021-06-15 | Spain | Murcia | 113869 | 1604 | 2180 | 110085 | 37.9922 | -1.1307 | 2021-06-16 04:22:32 | Murcia, Spain | ||
1564392 | 1564392 | 2021-06-14 | Spain | Murcia | 113831 | 1604 | 2180 | 110047 | 37.9922 | -1.1307 | 2021-06-15 04:22:22 | Murcia, Spain | ||
3381675 | 3381675 | 2021-06-13 | Spain | Murcia | 113680 | 1604 | 2180 | 109896 | 37.9922 | -1.1307 | 2021-06-14 04:22:46 | Murcia, Spain | ||
1736809 | 1736809 | 2021-06-12 | Spain | Murcia | 113680 | 1604 | 2180 | 109896 | 37.9922 | -1.1307 | 2021-06-13 04:22:44 | Murcia, Spain | ||
3970850 | 3970850 | 2021-06-11 | Spain | Murcia | 113680 | 1604 | 2180 | 109896 | 37.9922 | -1.1307 | 2021-06-12 04:22:22 | Murcia, Spain | ||
526296 | 526296 | 2021-06-09 | US | Washington | King | 53033 | 110688 | 1604 | 0 | 47.49137892 | -121.8346131 | 2021-06-10 04:23:17 | King, Washington, US | |
3145502 | 3145502 | 2021-06-07 | Germany | Schleswig-Holstein | 63384 | 1604 | 60900 | 901 | 54.2194 | 9.6961 | 2021-06-08 04:22:35 | Schleswig-Holstein, Germany | ||
1452256 | 1452256 | 2021-06-03 | Zimbabwe | 39092 | 1604 | 36680 | 808 | -19.015438 | 29.154857 | 2021-06-04 04:23:37 | Zimbabwe | |||
1450165 | 1450165 | 2021-06-03 | US | Maryland | Montgomery | 24031 | 70944 | 1604 | 0 | 39.13676329 | -77.20358245 | 2021-06-04 04:23:37 | Montgomery, Maryland, US | |
1709889 | 1709889 | 2021-06-02 | US | Maryland | Montgomery | 24031 | 70935 | 1604 | 0 | 39.13676329 | -77.20358245 | 2021-06-03 04:23:32 | Montgomery, Maryland, US | |
2105707 | 2105707 | 2021-06-01 | US | Maryland | Montgomery | 24031 | 70930 | 1604 | 0 | 39.13676329 | -77.20358245 | 2021-06-02 04:24:34 | Montgomery, Maryland, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);