johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
148 rows where deaths = 1502 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
- US 64
- Russia 15
- Italy 7
- Colombia 6
- Malaysia 6
- Peru 6
- Chile 4
- Mexico 4
- Netherlands 4
- India 3
- Japan 3
- New Zealand 3
- Spain 3
- Germany 2
- Oman 2
- Bangladesh 1
- Brazil 1
- Costa Rica 1
- Estonia 1
- Finland 1
- Guatemala 1
- Kuwait 1
- Kyrgyzstan 1
- Montenegro 1
- Nigeria 1
- Pakistan 1
- Paraguay 1
- Singapore 1
- United Arab Emirates 1
- United Kingdom 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2753452 | 2753452 | 2022-12-29 | US | California | Contra Costa | 6013 | 286289 | 1502 | 0 | 37.91923498 | -121.9289527 | 2022-12-30 04:21:04 | Contra Costa, California, US | |
2952401 | 2952401 | 2022-12-20 | US | Illinois | Lake | 17097 | 202456 | 1502 | 0 | 42.3224907 | -88.00367925 | 2022-12-21 04:21:03 | Lake, Illinois, US | |
543401 | 543401 | 2022-12-15 | US | Colorado | Jefferson | 8059 | 157343 | 1502 | 0 | 39.58635604 | -105.2517692 | 2022-12-16 04:21:01 | Jefferson, Colorado, US | |
348929 | 348929 | 2022-12-14 | US | Colorado | Jefferson | 8059 | 157269 | 1502 | 0 | 39.58635604 | -105.2517692 | 2022-12-15 04:20:58 | Jefferson, Colorado, US | |
3597266 | 3597266 | 2022-11-14 | Russia | Kurgan Oblast | 121854 | 1502 | 0 | 55.7655302 | 64.5632681 | 2022-11-15 04:21:16 | Kurgan Oblast, Russia | |||
312124 | 312124 | 2022-11-13 | Russia | Kurgan Oblast | 121815 | 1502 | 0 | 55.7655302 | 64.5632681 | 2022-11-14 04:21:09 | Kurgan Oblast, Russia | |||
1811521 | 1811521 | 2022-10-05 | US | Florida | Unassigned | 90012 | 2962 | 1502 | 0 | 30.86747479 | 0.0 | 2022-10-06 04:21:22 | Unassigned, Florida, US | |
3550969 | 3550969 | 2022-09-01 | US | Washington | Spokane | 53063 | 142057 | 1502 | 0 | 47.62113146 | -117.4046494 | 2022-09-02 04:21:07 | Spokane, Washington, US | |
2346889 | 2346889 | 2022-08-31 | US | Washington | Spokane | 53063 | 142057 | 1502 | 0 | 47.62113146 | -117.4046494 | 2022-09-01 04:21:03 | Spokane, Washington, US | |
1877045 | 1877045 | 2022-08-28 | Malaysia | Negeri Sembilan | 219026 | 1502 | 0 | 2.7258 | 101.9424 | 2022-08-29 04:21:06 | Negeri Sembilan, Malaysia | |||
2096172 | 2096172 | 2022-08-27 | Malaysia | Negeri Sembilan | 218907 | 1502 | 0 | 2.7258 | 101.9424 | 2022-08-28 04:21:02 | Negeri Sembilan, Malaysia | |||
1531987 | 1531987 | 2022-08-26 | Malaysia | Negeri Sembilan | 218750 | 1502 | 0 | 2.7258 | 101.9424 | 2022-08-27 04:20:57 | Negeri Sembilan, Malaysia | |||
2828874 | 2828874 | 2022-08-25 | Malaysia | Negeri Sembilan | 218590 | 1502 | 0 | 2.7258 | 101.9424 | 2022-08-26 04:21:02 | Negeri Sembilan, Malaysia | |||
3617363 | 3617363 | 2022-08-01 | Singapore | 1718765 | 1502 | 0 | 1.2833 | 103.8333 | 2022-08-02 04:20:53 | Singapore | ||||
3874896 | 3874896 | 2022-07-31 | US | Virginia | Fairfax | 51059 | 221968 | 1502 | 0 | 38.83677558 | -77.27565836 | 2022-08-01 04:21:03 | Fairfax, Virginia, US | |
3871699 | 3871699 | 2022-07-31 | New Zealand | 1621916 | 1502 | 0 | -40.9006 | 174.886 | 2022-08-01 04:21:03 | New Zealand | ||||
677650 | 677650 | 2022-07-30 | US | Virginia | Fairfax | 51059 | 221968 | 1502 | 0 | 38.83677558 | -77.27565836 | 2022-07-31 04:21:02 | Fairfax, Virginia, US | |
674453 | 674453 | 2022-07-30 | New Zealand | 1616341 | 1502 | 0 | -40.9006 | 174.886 | 2022-07-31 04:21:02 | New Zealand | ||||
1786849 | 1786849 | 2022-07-29 | US | Virginia | Fairfax | 51059 | 221968 | 1502 | 0 | 38.83677558 | -77.27565836 | 2022-07-30 04:20:42 | Fairfax, Virginia, US | |
1783652 | 1783652 | 2022-07-29 | New Zealand | 1611885 | 1502 | 0 | -40.9006 | 174.886 | 2022-07-30 04:20:42 | New Zealand | ||||
91115 | 91115 | 2022-07-23 | Italy | P.A. Bolzano | 243306 | 1502 | 0 | 46.49933453 | 11.35662422 | 2022-07-24 04:20:47 | P.A. Bolzano, Italy | |||
3943249 | 3943249 | 2022-06-30 | US | Texas | Nueces | 48355 | 104346 | 1502 | 0 | 27.736286 | -97.5433285 | 2022-07-01 04:21:10 | Nueces, Texas, US | |
2493207 | 2493207 | 2022-06-29 | US | Texas | Nueces | 48355 | 104170 | 1502 | 0 | 27.736286 | -97.5433285 | 2022-06-30 04:21:01 | Nueces, Texas, US | |
2242589 | 2242589 | 2022-06-28 | US | Texas | Nueces | 48355 | 103932 | 1502 | 0 | 27.736286 | -97.5433285 | 2022-06-29 04:20:59 | Nueces, Texas, US | |
2150831 | 2150831 | 2022-06-27 | US | Texas | Nueces | 48355 | 103733 | 1502 | 0 | 27.736286 | -97.5433285 | 2022-06-28 04:20:58 | Nueces, Texas, US | |
3585356 | 3585356 | 2022-05-17 | US | Pennsylvania | York | 42133 | 120372 | 1502 | 0 | 39.9210089 | -76.73040131 | 2022-05-18 04:20:50 | York, Pennsylvania, US | |
1506313 | 1506313 | 2022-05-16 | US | Pennsylvania | York | 42133 | 120372 | 1502 | 0 | 39.9210089 | -76.73040131 | 2022-05-17 04:20:59 | York, Pennsylvania, US | |
2086672 | 2086672 | 2022-05-15 | US | Pennsylvania | York | 42133 | 120372 | 1502 | 0 | 39.9210089 | -76.73040131 | 2022-05-16 04:20:47 | York, Pennsylvania, US | |
3357382 | 3357382 | 2022-05-14 | US | Pennsylvania | York | 42133 | 120372 | 1502 | 0 | 39.9210089 | -76.73040131 | 2022-05-15 04:20:53 | York, Pennsylvania, US | |
661027 | 661027 | 2022-05-13 | US | Pennsylvania | York | 42133 | 120372 | 1502 | 0 | 39.9210089 | -76.73040131 | 2022-05-14 04:20:48 | York, Pennsylvania, US | |
2536110 | 2536110 | 2022-05-12 | US | Pennsylvania | York | 42133 | 120372 | 1502 | 0 | 39.9210089 | -76.73040131 | 2022-05-13 04:20:51 | York, Pennsylvania, US | |
3447556 | 3447556 | 2022-05-11 | US | Pennsylvania | York | 42133 | 120372 | 1502 | 0 | 39.9210089 | -76.73040131 | 2022-05-12 04:20:54 | York, Pennsylvania, US | |
3535671 | 3535671 | 2022-05-10 | Russia | Karelia Republic | 134550 | 1502 | 0 | 62.6194031 | 33.4920267 | 2022-05-11 04:20:48 | Karelia Republic, Russia | |||
222206 | 222206 | 2022-05-09 | Russia | Karelia Republic | 134503 | 1502 | 0 | 62.6194031 | 33.4920267 | 2022-05-10 04:20:50 | Karelia Republic, Russia | |||
2331591 | 2331591 | 2022-05-08 | Russia | Karelia Republic | 134445 | 1502 | 0 | 62.6194031 | 33.4920267 | 2022-05-09 04:20:54 | Karelia Republic, Russia | |||
3725255 | 3725255 | 2022-04-25 | US | Texas | Collin | 48085 | 213702 | 1502 | 0 | 33.18820114 | -96.57264368 | 2022-04-26 04:20:51 | Collin, Texas, US | |
2031823 | 2031823 | 2022-04-24 | US | Texas | Collin | 48085 | 213658 | 1502 | 0 | 33.18820114 | -96.57264368 | 2022-04-25 04:20:56 | Collin, Texas, US | |
1846688 | 1846688 | 2022-04-18 | US | Florida | Lake | 12069 | 85525 | 1502 | 0 | 28.76202069 | -81.7125123 | 2022-04-19 04:21:00 | Lake, Florida, US | |
3417632 | 3417632 | 2022-04-17 | US | Florida | Lake | 12069 | 85525 | 1502 | 0 | 28.76202069 | -81.7125123 | 2022-04-18 04:21:12 | Lake, Florida, US | |
304581 | 304581 | 2022-04-16 | US | Florida | Lake | 12069 | 85525 | 1502 | 0 | 28.76202069 | -81.7125123 | 2022-04-17 04:20:59 | Lake, Florida, US | |
2670526 | 2670526 | 2022-04-15 | US | Florida | Lake | 12069 | 85525 | 1502 | 0 | 28.76202069 | -81.7125123 | 2022-04-16 04:20:48 | Lake, Florida, US | |
1224311 | 1224311 | 2022-04-14 | US | Florida | Lake | 12069 | 85525 | 1502 | 0 | 28.76202069 | -81.7125123 | 2022-04-15 04:20:57 | Lake, Florida, US | |
2443469 | 2443469 | 2022-04-13 | US | Florida | Lake | 12069 | 85525 | 1502 | 0 | 28.76202069 | -81.7125123 | 2022-04-13 23:21:06 | Lake, Florida, US | |
1949226 | 1949226 | 2022-04-12 | US | Florida | Lake | 12069 | 85525 | 1502 | 0 | 28.76202069 | -81.7125123 | 2022-04-13 04:21:03 | Lake, Florida, US | |
3206979 | 3206979 | 2022-04-11 | US | Florida | Lake | 12069 | 85525 | 1502 | 0 | 28.76202069 | -81.7125123 | 2022-04-12 04:20:49 | Lake, Florida, US | |
1576865 | 1576865 | 2022-04-10 | US | Florida | Lake | 12069 | 85525 | 1502 | 0 | 28.76202069 | -81.7125123 | 2022-04-11 04:21:02 | Lake, Florida, US | |
1653107 | 1653107 | 2022-04-09 | US | Florida | Lake | 12069 | 85525 | 1502 | 0 | 28.76202069 | -81.7125123 | 2022-04-10 04:20:52 | Lake, Florida, US | |
2116429 | 2116429 | 2022-04-08 | US | Florida | Lake | 12069 | 85525 | 1502 | 0 | 28.76202069 | -81.7125123 | 2022-04-09 04:20:42 | Lake, Florida, US | |
3320953 | 3320953 | 2022-04-07 | US | Florida | Lake | 12069 | 85174 | 1502 | 0 | 28.76202069 | -81.7125123 | 2022-04-08 04:20:48 | Lake, Florida, US | |
2801489 | 2801489 | 2022-04-06 | US | Florida | Lake | 12069 | 85174 | 1502 | 0 | 28.76202069 | -81.7125123 | 2022-04-07 04:20:53 | Lake, Florida, US | |
3868258 | 3868258 | 2022-04-05 | US | Florida | Lake | 12069 | 85174 | 1502 | 0 | 28.76202069 | -81.7125123 | 2022-04-06 04:20:49 | Lake, Florida, US | |
2140478 | 2140478 | 2022-03-09 | Spain | Navarra | 225068 | 1502 | 0 | 42.6954 | -1.6761 | 2022-03-10 04:20:48 | Navarra, Spain | |||
919989 | 919989 | 2022-03-08 | Spain | Navarra | 224767 | 1502 | 0 | 42.6954 | -1.6761 | 2022-03-09 04:20:59 | Navarra, Spain | |||
3046237 | 3046237 | 2022-02-26 | Malaysia | Perak | 147898 | 1502 | 0 | 4.5921 | 101.0901 | 2022-02-27 04:21:04 | Perak, Malaysia | |||
1057982 | 1057982 | 2022-02-23 | Netherlands | Utrecht | 513196 | 1502 | 0 | 52.084251 | 5.163824 | 2022-02-24 04:21:14 | Utrecht, Netherlands | |||
2446905 | 2446905 | 2022-02-22 | Netherlands | Utrecht | 509007 | 1502 | 0 | 52.084251 | 5.163824 | 2022-02-23 04:21:09 | Utrecht, Netherlands | |||
2446607 | 2446607 | 2022-02-22 | Colombia | La Guajira | 55996 | 1502 | 0 | 11.3548 | -72.5205 | 2022-02-23 04:21:09 | La Guajira, Colombia | |||
3718020 | 3718020 | 2022-02-21 | Colombia | La Guajira | 55884 | 1502 | 0 | 11.3548 | -72.5205 | 2022-02-22 04:21:01 | La Guajira, Colombia | |||
3911854 | 3911854 | 2022-02-20 | Colombia | La Guajira | 55851 | 1502 | 0 | 11.3548 | -72.5205 | 2022-02-21 04:21:05 | La Guajira, Colombia | |||
3820413 | 3820413 | 2022-02-16 | Italy | P.A. Trento | 135072 | 1502 | 0 | 46.06893511 | 11.12123097 | 2022-02-17 04:20:56 | P.A. Trento, Italy | |||
1363142 | 1363142 | 2022-02-08 | US | Georgia | DeKalb | 13089 | 141199 | 1502 | 0 | 33.76944049 | -84.22396017 | 2022-02-09 04:21:04 | DeKalb, Georgia, US | |
978944 | 978944 | 2022-02-01 | Japan | Hokkaido | 94974 | 1502 | 0 | 43.385711 | 142.552318 | 2022-02-02 04:21:09 | Hokkaido, Japan | |||
2659977 | 2659977 | 2022-01-31 | US | New Mexico | Bernalillo | 35001 | 135925 | 1502 | 0 | 35.05163625 | -106.6703554 | 2022-02-01 04:21:11 | Bernalillo, New Mexico, US | |
2658532 | 2658532 | 2022-01-31 | US | Florida | Unassigned | 90012 | 16558 | 1502 | 0 | 30.86747479 | 0.0 | 2022-02-01 04:21:11 | Unassigned, Florida, US | |
2657786 | 2657786 | 2022-01-31 | Japan | Hokkaido | 92314 | 1502 | 0 | 43.385711 | 142.55231799999999 | 2022-02-01 04:21:11 | Hokkaido, Japan | |||
3300203 | 3300203 | 2022-01-30 | Japan | Hokkaido | 90048 | 1502 | 0 | 43.385711 | 142.55231799999999 | 2022-01-31 04:21:09 | Hokkaido, Japan | |||
1472895 | 1472895 | 2022-01-17 | US | Georgia | Cobb | 13067 | 150465 | 1502 | 0 | 33.94243204 | -84.5761255 | 2022-01-18 04:21:04 | Cobb, Georgia, US | |
1703587 | 1703587 | 2022-01-03 | US | Texas | Travis | 48453 | 149861 | 1502 | 0 | 30.33432034 | -97.78535620000001 | 2022-01-04 04:22:17 | Travis, Texas, US | |
1668230 | 1668230 | 2021-12-29 | Chile | Los Lagos | 99135 | 1502 | 0 | -41.9198 | -72.1416 | 2021-12-30 04:21:25 | Los Lagos, Chile | |||
1432547 | 1432547 | 2021-12-28 | Italy | Umbria | 79749 | 1502 | 0 | 43.10675841 | 12.38824698 | 2021-12-29 03:21:43 | Umbria, Italy | |||
1432339 | 1432339 | 2021-12-28 | Chile | Los Lagos | 99058 | 1502 | 0 | -41.9198 | -72.1416 | 2021-12-29 03:21:43 | Los Lagos, Chile | |||
730300 | 730300 | 2021-12-27 | Chile | Los Lagos | 99017 | 1502 | 0 | -41.9198 | -72.1416 | 2021-12-28 04:21:47 | Los Lagos, Chile | |||
2905883 | 2905883 | 2021-12-19 | US | New Jersey | Camden | 34007 | 77225 | 1502 | 0 | 39.80343818 | -74.96388753 | 2021-12-20 04:21:43 | Camden, New Jersey, US | |
1260956 | 1260956 | 2021-12-18 | US | New Jersey | Camden | 34007 | 76902 | 1502 | 0 | 39.80343818 | -74.96388753 | 2021-12-19 04:21:11 | Camden, New Jersey, US | |
2195499 | 2195499 | 2021-12-03 | Finland | 192729 | 1502 | 0 | 61.92411 | 25.748151 | 2021-12-04 04:22:18 | Finland | ||||
1358529 | 1358529 | 2021-11-27 | Russia | Belgorod Oblast | 71816 | 1502 | 0 | 50.7080119 | 37.5837615 | 2021-11-28 04:22:43 | Belgorod Oblast, Russia | |||
722764 | 722764 | 2021-11-20 | Russia | Yaroslavl Oblast | 74606 | 1502 | 0 | 57.77819760000001 | 39.002109499999996 | 2021-11-21 04:22:13 | Yaroslavl Oblast, Russia | |||
2000906 | 2000906 | 2021-11-07 | Russia | Sakha (Yakutiya) Republic | 64135 | 1502 | 0 | 66.941626 | 129.642371 | 2021-11-08 04:21:43 | Sakha (Yakutiya) Republic, Russia | |||
495895 | 495895 | 2021-11-06 | Russia | Ryazan Oblast | 49406 | 1502 | 0 | 54.42267320000001 | 40.57052460000001 | 2021-11-07 04:21:53 | Ryazan Oblast, Russia | |||
45312 | 45312 | 2021-11-02 | US | Massachusetts | Norfolk | 25021 | 65088 | 1502 | 0 | 42.16073095 | -71.20530408 | 2021-11-03 06:22:09 | Norfolk, Massachusetts, US | |
566975 | 566975 | 2021-10-29 | Estonia | 190201 | 1502 | 0 | 58.5953 | 25.0136 | 2021-10-30 04:22:03 | Estonia | ||||
491697 | 491697 | 2021-10-14 | Malaysia | Pulau Pinang | 138787 | 1502 | 0 | 5.4141 | 100.3288 | 2021-10-15 04:21:26 | Pulau Pinang, Malaysia | |||
3007556 | 3007556 | 2021-10-11 | Russia | Kursk Oblast | 60197 | 1502 | 0 | 51.6568453 | 36.4852695 | 2021-10-12 04:21:09 | Kursk Oblast, Russia | |||
3806125 | 3806125 | 2021-09-11 | Russia | Lipetsk Oblast | 49033 | 1502 | 0 | 52.693517799999995 | 39.112266399999996 | 2021-09-12 04:21:13 | Lipetsk Oblast, Russia | |||
3193843 | 3193843 | 2021-09-06 | Colombia | Cauca | 55250 | 1502 | 0 | 2.705 | -76.82600000000002 | 2021-09-07 04:21:35 | Cauca, Colombia | |||
3105710 | 3105710 | 2021-08-24 | Russia | Tver Oblast | 59255 | 1502 | 0 | 57.1134475 | 35.174442799999994 | 2021-08-25 04:21:41 | Tver Oblast, Russia | |||
1605034 | 1605034 | 2021-08-16 | US | Georgia | Fulton | 13121 | 109824 | 1502 | 0 | 33.79216944 | -84.46319413 | 2021-08-17 04:21:49 | Fulton, Georgia, US | |
3015343 | 3015343 | 2021-08-01 | Italy | Sardegna | 62365 | 1502 | 55652 | 5211 | 39.21531192 | 9.110616306 | 2021-08-02 04:21:36 | Sardegna, Italy | ||
3903966 | 3903966 | 2021-07-31 | Italy | Sardegna | 62051 | 1502 | 55605 | 4944 | 39.21531192 | 9.110616306 | 2021-08-01 04:21:50 | Sardegna, Italy | ||
1330475 | 1330475 | 2021-07-24 | Russia | Murmansk Oblast | 60117 | 1502 | 50664 | 7951 | 68.00004179999999 | 33.9999151 | 2021-07-25 04:22:12 | Murmansk Oblast, Russia | ||
2673673 | 2673673 | 2021-07-18 | Colombia | Sucre | 55191 | 1502 | 52261 | 1428 | 8.814 | -74.7233 | 2021-07-19 04:21:24 | Sucre, Colombia | ||
1934897 | 1934897 | 2021-07-05 | US | Ohio | Franklin | 39049 | 129263 | 1502 | 0 | 39.96995815 | -83.01115755 | 2021-07-06 04:21:32 | Franklin, Ohio, US | |
1167628 | 1167628 | 2021-07-04 | US | Ohio | Franklin | 39049 | 129236 | 1502 | 0 | 39.96995815 | -83.01115755 | 2021-07-05 04:21:28 | Franklin, Ohio, US | |
1498062 | 1498062 | 2021-07-03 | US | Ohio | Franklin | 39049 | 129236 | 1502 | 0 | 39.96995815 | -83.01115755 | 2021-07-04 04:21:38 | Franklin, Ohio, US | |
2074377 | 2074377 | 2021-07-02 | US | Ohio | Franklin | 39049 | 129220 | 1502 | 0 | 39.96995815 | -83.01115755 | 2021-07-03 04:21:37 | Franklin, Ohio, US | |
1893375 | 1893375 | 2021-06-30 | Russia | Omsk Oblast | 50786 | 1502 | 48176 | 1108 | 56.09352629999999 | 73.5099936 | 2021-07-01 04:21:19 | Omsk Oblast, Russia | ||
3958297 | 3958297 | 2021-06-26 | Chile | Maule | 94744 | 1502 | 91117 | 2125 | -35.5183 | -71.6885 | 2021-06-27 04:21:39 | Maule, Chile | ||
1311767 | 1311767 | 2021-05-26 | US | Massachusetts | Suffolk | 25025 | 92625 | 1502 | 0 | 42.3279514 | -71.07850442 | 2021-05-27 04:20:59 | Suffolk, Massachusetts, US | |
3055755 | 3055755 | 2021-05-13 | US | Maryland | Baltimore | 24005 | 64807 | 1502 | 0 | 39.45784712 | -76.62911955 | 2021-05-14 04:20:41 | Baltimore, Maryland, US | |
2006225 | 2006225 | 2021-05-12 | US | Maryland | Baltimore | 24005 | 64724 | 1502 | 0 | 39.45784712 | -76.62911955 | 2021-05-13 04:20:51 | Baltimore, 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]);