johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
118 rows where deaths = 1499 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
308899 | 308899 | 2022-12-13 | US | Illinois | Lake | 17097 | 201227 | 1499 | 0 | 42.3224907 | -88.00367925 | 2022-12-14 04:21:04 | Lake, Illinois, US | |
3777369 | 3777369 | 2022-08-30 | US | Washington | Spokane | 53063 | 141884 | 1499 | 0 | 47.62113146 | -117.4046494 | 2022-08-31 04:20:57 | Spokane, Washington, US | |
3777364 | 3777364 | 2022-08-30 | US | Washington | Pierce | 53053 | 225906 | 1499 | 0 | 47.03892768 | -122.1405958 | 2022-08-31 04:20:57 | Pierce, Washington, US | |
1683965 | 1683965 | 2022-08-29 | US | Washington | Spokane | 53063 | 141884 | 1499 | 0 | 47.62113146 | -117.4046494 | 2022-08-30 04:21:03 | Spokane, Washington, US | |
1683960 | 1683960 | 2022-08-29 | US | Washington | Pierce | 53053 | 225906 | 1499 | 0 | 47.03892768 | -122.1405958 | 2022-08-30 04:21:03 | Pierce, Washington, US | |
2338731 | 2338731 | 2022-07-27 | US | Virginia | Fairfax | 51059 | 221145 | 1499 | 0 | 38.83677558 | -77.27565836 | 2022-07-28 04:20:56 | Fairfax, Virginia, US | |
3940653 | 3940653 | 2022-06-30 | US | California | Tulare | 6107 | 142691 | 1499 | 0 | 36.22026558 | -118.8020203 | 2022-07-01 04:21:10 | Tulare, California, US | |
2490611 | 2490611 | 2022-06-29 | US | California | Tulare | 6107 | 142206 | 1499 | 0 | 36.22026558 | -118.8020203 | 2022-06-30 04:21:01 | Tulare, California, US | |
2239993 | 2239993 | 2022-06-28 | US | California | Tulare | 6107 | 142132 | 1499 | 0 | 36.22026558 | -118.8020203 | 2022-06-29 04:20:59 | Tulare, California, US | |
2598259 | 2598259 | 2022-05-05 | Russia | Karelia Republic | 134293 | 1499 | 0 | 62.6194031 | 33.4920267 | 2022-05-06 04:21:00 | Karelia Republic, Russia | |||
3265708 | 3265708 | 2022-05-04 | Russia | Karelia Republic | 134245 | 1499 | 0 | 62.6194031 | 33.4920267 | 2022-05-05 04:20:55 | Karelia Republic, Russia | |||
466109 | 466109 | 2022-05-02 | US | Pennsylvania | York | 42133 | 119574 | 1499 | 0 | 39.9210089 | -76.73040131 | 2022-05-03 04:21:00 | York, Pennsylvania, US | |
3918748 | 3918748 | 2022-05-01 | US | Pennsylvania | York | 42133 | 119534 | 1499 | 0 | 39.9210089 | -76.73040131 | 2022-05-02 04:21:10 | York, Pennsylvania, US | |
2843552 | 2843552 | 2022-04-30 | US | Pennsylvania | York | 42133 | 119489 | 1499 | 0 | 39.9210089 | -76.73040131 | 2022-05-01 04:20:57 | York, Pennsylvania, US | |
3870599 | 3870599 | 2022-04-05 | US | Texas | Collin | 48085 | 210350 | 1499 | 0 | 33.18820114 | -96.57264368 | 2022-04-06 04:20:49 | Collin, Texas, US | |
2749600 | 2749600 | 2022-04-04 | US | Florida | Lake | 12069 | 85174 | 1499 | 0 | 28.76202069 | -81.7125123 | 2022-04-05 04:20:48 | Lake, Florida, US | |
3730946 | 3730946 | 2022-04-03 | US | Florida | Lake | 12069 | 85174 | 1499 | 0 | 28.76202069 | -81.7125123 | 2022-04-04 04:20:51 | Lake, Florida, US | |
500381 | 500381 | 2022-04-02 | US | Florida | Lake | 12069 | 85174 | 1499 | 0 | 28.76202069 | -81.7125123 | 2022-04-03 04:20:48 | Lake, Florida, US | |
3351366 | 3351366 | 2022-04-01 | US | Florida | Lake | 12069 | 85174 | 1499 | 0 | 28.76202069 | -81.7125123 | 2022-04-02 04:20:47 | Lake, Florida, US | |
1540671 | 1540671 | 2022-03-31 | US | Florida | Lake | 12069 | 85174 | 1499 | 0 | 28.76202069 | -81.7125123 | 2022-04-01 04:20:28 | Lake, Florida, US | |
2478684 | 2478684 | 2022-03-30 | US | Florida | Lake | 12069 | 85174 | 1499 | 0 | 28.76202069 | -81.7125123 | 2022-03-31 04:20:56 | Lake, Florida, US | |
158725 | 158725 | 2022-03-29 | US | Florida | Lake | 12069 | 85174 | 1499 | 0 | 28.76202069 | -81.7125123 | 2022-03-30 04:20:45 | Lake, Florida, US | |
876167 | 876167 | 2022-03-27 | Germany | Saarland | 227982 | 1499 | 0 | 49.3964 | 7.023 | 2022-03-26 23:20:45 | Saarland, Germany | |||
2163450 | 2163450 | 2022-03-26 | Germany | Saarland | 227982 | 1499 | 0 | 49.3964 | 7.023 | 2022-03-26 23:20:45 | Saarland, Germany | |||
1720386 | 1720386 | 2022-03-25 | Germany | Saarland | 227982 | 1499 | 0 | 49.3964 | 7.023 | 2022-03-26 04:20:23 | Saarland, Germany | |||
1468313 | 1468313 | 2022-03-24 | Russia | Khabarovsk Krai | 194657 | 1499 | 0 | 51.6312684 | 136.121524 | 2022-03-25 04:20:46 | Khabarovsk Krai, Russia | |||
2199945 | 2199945 | 2022-03-06 | Spain | Navarra | 223910 | 1499 | 0 | 42.6954 | -1.6761 | 2022-03-07 04:20:47 | Navarra, Spain | |||
2092402 | 2092402 | 2022-03-05 | Spain | Navarra | 223910 | 1499 | 0 | 42.6954 | -1.6761 | 2022-03-06 04:20:49 | Navarra, Spain | |||
2666102 | 2666102 | 2022-03-04 | Spain | Navarra | 223910 | 1499 | 0 | 42.6954 | -1.6761 | 2022-03-05 04:21:10 | Navarra, Spain | |||
3875412 | 3875412 | 2022-02-19 | Colombia | La Guajira | 55688 | 1499 | 0 | 11.3548 | -72.5205 | 2022-02-20 04:21:00 | La Guajira, Colombia | |||
3855668 | 3855668 | 2022-02-18 | Colombia | La Guajira | 55688 | 1499 | 0 | 11.3548 | -72.5205 | 2022-02-19 04:21:11 | La Guajira, Colombia | |||
1300230 | 1300230 | 2022-02-17 | US | New Jersey | Morris | 34027 | 115417 | 1499 | 0 | 40.86095313 | -74.54553709999998 | 2022-02-18 04:21:04 | Morris, New Jersey, US | |
1297887 | 1297887 | 2022-02-17 | Colombia | La Guajira | 55626 | 1499 | 0 | 11.3548 | -72.5205 | 2022-02-18 04:21:04 | La Guajira, Colombia | |||
3820273 | 3820273 | 2022-02-16 | Colombia | La Guajira | 55604 | 1499 | 0 | 11.3548 | -72.5205 | 2022-02-17 04:20:56 | La Guajira, Colombia | |||
3672110 | 3672110 | 2022-02-15 | US | Arizona | Pinal | 4021 | 127193 | 1499 | 0 | 32.90525627 | -111.3449483 | 2022-02-16 04:21:10 | Pinal, Arizona, US | |
2642211 | 2642211 | 2022-02-14 | US | Arizona | Pinal | 4021 | 127193 | 1499 | 0 | 32.90525627 | -111.3449483 | 2022-02-15 04:21:09 | Pinal, Arizona, US | |
186528 | 186528 | 2022-02-13 | US | Arizona | Pinal | 4021 | 126941 | 1499 | 0 | 32.90525627 | -111.3449483 | 2022-02-14 04:20:51 | Pinal, Arizona, US | |
316374 | 316374 | 2022-02-12 | US | Arizona | Pinal | 4021 | 126672 | 1499 | 0 | 32.90525627 | -111.3449483 | 2022-02-13 04:21:00 | Pinal, Arizona, US | |
316158 | 316158 | 2022-02-12 | Russia | Pskov Oblast | 80803 | 1499 | 0 | 57.535872899999994 | 28.8586826 | 2022-02-13 04:21:00 | Pskov Oblast, Russia | |||
3074338 | 3074338 | 2022-02-09 | Spain | Canarias | 267335 | 1499 | 0 | 28.2916 | -16.6291 | 2022-02-10 04:21:14 | Canarias, Spain | |||
2476887 | 2476887 | 2022-02-03 | US | Tennessee | Davidson | 47037 | 184385 | 1499 | 0 | 36.17007426 | -86.78646056 | 2022-02-04 04:21:10 | Davidson, Tennessee, US | |
3061994 | 3061994 | 2022-01-29 | Japan | Hokkaido | 87266 | 1499 | 0 | 43.385711 | 142.55231799999999 | 2022-01-30 04:21:26 | Hokkaido, Japan | |||
2051825 | 2051825 | 2022-01-25 | India | Meghalaya | 89161 | 1499 | 0 | 25.536934 | 91.278882 | 2022-01-26 04:21:07 | Meghalaya, India | |||
1113794 | 1113794 | 2022-01-11 | Russia | Kabardino-Balkarian Republic | 42925 | 1499 | 0 | 43.480604799999995 | 43.5978976 | 2022-01-12 04:21:44 | Kabardino-Balkarian Republic, Russia | |||
1218084 | 1218084 | 2022-01-08 | US | Ohio | Summit | 39153 | 98890 | 1499 | 0 | 41.12464734 | -81.53123079 | 2022-01-09 04:21:46 | Summit, Ohio, US | |
1392176 | 1392176 | 2022-01-07 | US | Ohio | Stark | 39151 | 67610 | 1499 | 0 | 40.81482476 | -81.36437305 | 2022-01-08 04:21:53 | Stark, Ohio, US | |
730213 | 730213 | 2021-12-27 | Australia | Victoria | 161845 | 1499 | 0 | -37.8136 | 144.9631 | 2021-12-28 04:21:47 | Victoria, Australia | |||
2111472 | 2111472 | 2021-12-26 | Chile | Los Lagos | 98967 | 1499 | 0 | -41.9198 | -72.1416 | 2021-12-27 04:21:58 | Los Lagos, Chile | |||
3816402 | 3816402 | 2021-12-23 | Italy | Umbria | 73403 | 1499 | 0 | 43.10675841 | 12.38824698 | 2021-12-24 04:21:34 | Umbria, Italy | |||
798410 | 798410 | 2021-12-22 | Italy | Umbria | 72470 | 1499 | 0 | 43.10675841 | 12.38824698 | 2021-12-23 04:21:21 | Umbria, Italy | |||
3828450 | 3828450 | 2021-12-21 | Italy | Umbria | 71793 | 1499 | 0 | 43.10675841 | 12.38824698 | 2021-12-22 04:21:54 | Umbria, Italy | |||
3498356 | 3498356 | 2021-12-15 | US | New Jersey | Camden | 34007 | 75817 | 1499 | 0 | 39.80343818 | -74.96388753 | 2021-12-16 04:22:11 | Camden, New Jersey, US | |
1662922 | 1662922 | 2021-12-12 | US | Ohio | Montgomery | 39113 | 82855 | 1499 | 0 | 39.75394919 | -84.29050975 | 2021-12-13 04:22:02 | Montgomery, Ohio, US | |
3658247 | 3658247 | 2021-12-10 | US | Pennsylvania | Bucks | 42017 | 81974 | 1499 | 0 | 40.33682119 | -75.10836643 | 2021-12-11 04:22:45 | Bucks, Pennsylvania, US | |
3401405 | 3401405 | 2021-11-30 | Italy | Calabria | 92936 | 1499 | 0 | 38.90597598 | 16.59440194 | 2021-12-01 04:22:29 | Calabria, Italy | |||
1803283 | 1803283 | 2021-11-25 | US | California | Alameda | 6001 | 124454 | 1499 | 0 | 37.64629437 | -121.8929271 | 2021-11-26 04:22:33 | Alameda, California, US | |
537402 | 537402 | 2021-10-27 | US | Pennsylvania | Delaware | 42045 | 62513 | 1499 | 0 | 39.91680171 | -75.40243663 | 2021-10-28 04:22:08 | Delaware, Pennsylvania, US | |
3834081 | 3834081 | 2021-10-05 | US | Massachusetts | Bristol | 25005 | 77988 | 1499 | 0 | 41.79228404 | -71.10872211 | 2021-10-06 04:21:33 | Bristol, Massachusetts, US | |
1921375 | 1921375 | 2021-09-24 | Peru | Apurimac | 26015 | 1499 | 0 | -14.027713 | -72.975378 | 2021-09-25 04:21:31 | Apurimac, Peru | |||
1884782 | 1884782 | 2021-09-12 | Chile | Araucania | 98061 | 1499 | 0 | -38.9489 | -72.3311 | 2021-09-13 04:21:15 | Araucania, Chile | |||
3194202 | 3194202 | 2021-09-06 | Russia | Ivanovo Oblast | 45930 | 1499 | 0 | 56.9167446 | 41.43521370000001 | 2021-09-07 04:21:35 | Ivanovo Oblast, Russia | |||
3194190 | 3194190 | 2021-09-06 | Russia | Astrakhan Oblast | 54019 | 1499 | 0 | 47.1878186 | 47.608851 | 2021-09-07 04:21:35 | Astrakhan Oblast, Russia | |||
3974406 | 3974406 | 2021-09-03 | Colombia | Cauca | 55180 | 1499 | 0 | 2.705 | -76.82600000000002 | 2021-09-04 04:21:28 | Cauca, Colombia | |||
3166199 | 3166199 | 2021-08-23 | US | California | San Joaquin | 6077 | 87885 | 1499 | 0 | 37.93433732 | -121.2730061 | 2021-08-24 04:21:19 | San Joaquin, California, US | |
2352239 | 2352239 | 2021-08-10 | US | Georgia | Fulton | 13121 | 107186 | 1499 | 0 | 33.79216944 | -84.46319413 | 2021-08-11 04:21:58 | Fulton, Georgia, US | |
2693544 | 2693544 | 2021-07-06 | Colombia | Quindio | 50578 | 1499 | 48047 | 1032 | 4.461 | -75.6674 | 2021-07-07 04:21:20 | Quindio, Colombia | ||
1165344 | 1165344 | 2021-07-04 | Peru | Tumbes | 17321 | 1499 | 0 | 15822 | -3.857496 | -80.54525500000003 | 2021-07-05 04:21:28 | Tumbes, Peru | ||
1495778 | 1495778 | 2021-07-03 | Peru | Tumbes | 17321 | 1499 | 0 | 15822 | -3.857496 | -80.54525500000003 | 2021-07-04 04:21:38 | Tumbes, Peru | ||
2072093 | 2072093 | 2021-07-02 | Peru | Tumbes | 17321 | 1499 | 0 | 15822 | -3.857496 | -80.54525500000003 | 2021-07-03 04:21:37 | Tumbes, Peru | ||
2765109 | 2765109 | 2021-07-01 | Peru | Tumbes | 17321 | 1499 | 0 | 15822 | -3.857496 | -80.54525500000003 | 2021-07-02 04:21:47 | Tumbes, Peru | ||
1893317 | 1893317 | 2021-06-30 | Peru | Tumbes | 17321 | 1499 | 0 | 15822 | -3.857496 | -80.54525500000003 | 2021-07-01 04:21:19 | Tumbes, Peru | ||
400498 | 400498 | 2021-06-29 | Russia | Omsk Oblast | 50550 | 1499 | 47955 | 1096 | 56.09352629999999 | 73.5099936 | 2021-06-30 04:21:41 | Omsk Oblast, Russia | ||
400440 | 400440 | 2021-06-29 | Peru | Tumbes | 17321 | 1499 | 0 | 15822 | -3.857496 | -80.54525500000003 | 2021-06-30 04:21:41 | Tumbes, Peru | ||
3125683 | 3125683 | 2021-06-28 | Peru | Tumbes | 17321 | 1499 | 0 | 15822 | -3.857496 | -80.54525500000003 | 2021-06-29 04:21:28 | Tumbes, Peru | ||
2590178 | 2590178 | 2021-06-27 | Peru | Tumbes | 17321 | 1499 | 0 | 15822 | -3.857496 | -80.54525500000003 | 2021-06-28 04:21:29 | Tumbes, Peru | ||
3958682 | 3958682 | 2021-06-26 | Peru | Tumbes | 17321 | 1499 | 0 | 15822 | -3.857496 | -80.54525500000003 | 2021-06-27 04:21:39 | Tumbes, Peru | ||
1712501 | 1712501 | 2021-06-25 | Peru | Tumbes | 17321 | 1499 | 0 | 15822 | -3.857496 | -80.54525500000003 | 2021-06-26 04:21:43 | Tumbes, Peru | ||
2295626 | 2295626 | 2021-06-24 | Peru | Tumbes | 17321 | 1499 | 0 | 15822 | -3.857496 | -80.54525500000003 | 2021-06-25 04:21:33 | Tumbes, Peru | ||
2425349 | 2425349 | 2021-06-23 | US | Ohio | Franklin | 39049 | 128952 | 1499 | 0 | 39.96995815 | -83.01115755 | 2021-06-24 04:21:55 | Franklin, Ohio, US | |
2423066 | 2423066 | 2021-06-23 | Peru | Tumbes | 17321 | 1499 | 0 | 15822 | -3.857496 | -80.54525500000003 | 2021-06-24 04:21:55 | Tumbes, Peru | ||
565426 | 565426 | 2021-06-22 | US | Ohio | Franklin | 39049 | 128856 | 1499 | 0 | 39.96995815 | -83.01115755 | 2021-06-23 04:21:46 | Franklin, Ohio, US | |
3361128 | 3361128 | 2021-06-21 | US | Ohio | Franklin | 39049 | 128765 | 1499 | 0 | 39.96995815 | -83.01115755 | 2021-06-22 04:21:34 | Franklin, Ohio, US | |
2884565 | 2884565 | 2021-06-20 | Russia | Chuvashia Republic | 26735 | 1499 | 24463 | 773 | 55.4259922 | 47.0849429 | 2021-06-21 04:21:41 | Chuvashia Republic, Russia | ||
2717168 | 2717168 | 2021-06-10 | Russia | Dagestan Republic | 34120 | 1499 | 31563 | 1058 | 43.05749160000001 | 47.1332224 | 2021-06-11 04:23:20 | Dagestan Republic, Russia | ||
1954111 | 1954111 | 2021-05-21 | US | Massachusetts | Suffolk | 25025 | 92436 | 1499 | 0 | 42.3279514 | -71.07850442 | 2021-05-22 04:20:45 | Suffolk, Massachusetts, US | |
1914810 | 1914810 | 2021-05-20 | US | Massachusetts | Suffolk | 25025 | 92378 | 1499 | 0 | 42.3279514 | -71.07850442 | 2021-05-21 04:20:43 | Suffolk, Massachusetts, US | |
2257331 | 2257331 | 2021-05-19 | US | Massachusetts | Suffolk | 25025 | 92313 | 1499 | 0 | 42.3279514 | -71.07850442 | 2021-05-20 04:21:05 | Suffolk, Massachusetts, US | |
2392369 | 2392369 | 2021-05-18 | US | Massachusetts | Suffolk | 25025 | 92264 | 1499 | 0 | 42.3279514 | -71.07850442 | 2021-05-19 04:20:42 | Suffolk, Massachusetts, US | |
3576194 | 3576194 | 2021-05-17 | US | Massachusetts | Suffolk | 25025 | 92228 | 1499 | 0 | 42.3279514 | -71.07850442 | 2021-05-18 04:20:33 | Suffolk, Massachusetts, US | |
1081782 | 1081782 | 2021-05-14 | Colombia | Risaralda | 59485 | 1499 | 56848 | 1138 | 5.3158 | -75.9928 | 2021-05-15 04:20:58 | Risaralda, Colombia | ||
3954684 | 3954684 | 2021-05-11 | Russia | Chelyabinsk Oblast | 60010 | 1499 | 55639 | 2872 | 54.4223954 | 61.1865846 | 2021-05-12 04:21:29 | Chelyabinsk Oblast, Russia | ||
958505 | 958505 | 2021-04-25 | Ukraine | Zakarpattia Oblast | 59537 | 1499 | 51639 | 6399 | 48.6208 | 22.2879 | 2021-04-26 04:21:04 | Zakarpattia Oblast, Ukraine | ||
1408879 | 1408879 | 2021-04-23 | Colombia | Bolivar | 76785 | 1499 | 73685 | 1601 | 8.6704 | -74.03 | 2021-04-24 04:20:38 | Bolivar, Colombia | ||
984526 | 984526 | 2021-04-17 | US | Maryland | Montgomery | 24031 | 68718 | 1499 | 0 | 39.13676329 | -77.20358245 | 2021-04-18 04:20:41 | Montgomery, Maryland, US | |
1305693 | 1305693 | 2021-04-01 | United Arab Emirates | 463759 | 1499 | 447790 | 14470 | 23.424076 | 53.847818 | 2021-04-02 04:20:36 | United Arab Emirates | |||
640090 | 640090 | 2021-03-31 | US | New Jersey | Monmouth | 34025 | 67982 | 1499 | 0 | 40.26549699 | -74.22240686 | 2021-04-01 04:27:05 | Monmouth, New Jersey, US | |
1219354 | 1219354 | 2021-03-27 | Chile | Biobio | 92750 | 1499 | 85886 | 5365 | -37.4464 | -72.1416 | 2021-03-28 05:28:10 | Biobio, Chile | ||
1881237 | 1881237 | 2021-03-26 | Russia | Tula Oblast | 35793 | 1499 | 33208 | 1086 | 53.9570701 | 37.3690909 | 2021-03-27 05:25:04 | Tula Oblast, Russia | ||
1203931 | 1203931 | 2021-03-22 | Netherlands | Limburg | 78556 | 1499 | 0 | 76962 | 51.209227 | 5.93387 | 2021-03-23 05:26:18 | Limburg, Netherlands | ||
1203658 | 1203658 | 2021-03-22 | Colombia | Magdalena | 40283 | 1499 | 36981 | 1803 | 10.4113 | -74.4057 | 2021-03-23 05:26:18 | Magdalena, Colombia |
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]);