johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
85 rows where deaths = 2096 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 20
- US 24
- Mexico 10
- Japan 9
- Peru 8
- Brazil 5
- Italy 5
- Russia 5
- Netherlands 3
- Malaysia 2
- Mongolia 2
- Pakistan 2
- Ukraine 2
- Bangladesh 1
- Cambodia 1
- Canada 1
- Colombia 1
- India 1
- Mozambique 1
- North Macedonia 1
- Switzerland 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3936104 | 3936104 | 2022-12-09 | Malaysia | Perak | 237671 | 2096 | 0 | 4.5921 | 101.0901 | 2022-12-10 04:21:02 | Perak, Malaysia | |||
3377436 | 3377436 | 2022-12-08 | Malaysia | Perak | 237575 | 2096 | 0 | 4.5921 | 101.0901 | 2022-12-09 04:21:05 | Perak, Malaysia | |||
2687887 | 2687887 | 2022-10-03 | US | New Mexico | Bernalillo | 35001 | 180256 | 2096 | 0 | 35.05163625 | -106.6703554 | 2022-10-04 04:22:55 | Bernalillo, New Mexico, US | |
2016704 | 2016704 | 2022-09-20 | Italy | Umbria | 371742 | 2096 | 0 | 43.10675841 | 12.38824698 | 2022-09-21 04:23:22 | Umbria, Italy | |||
2397299 | 2397299 | 2022-09-12 | US | Ohio | Montgomery | 39113 | 146953 | 2096 | 0 | 39.75394919 | -84.29050975 | 2022-09-13 04:20:57 | Montgomery, Ohio, US | |
3966546 | 3966546 | 2022-07-05 | Japan | Hokkaido | 384612 | 2096 | 0 | 43.385711 | 142.552318 | 2022-07-06 04:20:58 | Hokkaido, Japan | |||
3078057 | 3078057 | 2022-07-04 | Japan | Hokkaido | 384051 | 2096 | 0 | 43.385711 | 142.552318 | 2022-07-05 04:20:45 | Hokkaido, Japan | |||
1767339 | 1767339 | 2022-07-03 | Japan | Hokkaido | 383644 | 2096 | 0 | 43.385711 | 142.552318 | 2022-07-04 04:20:54 | Hokkaido, Japan | |||
3365325 | 3365325 | 2022-07-02 | Japan | Hokkaido | 383027 | 2096 | 0 | 43.385711 | 142.552318 | 2022-07-03 04:20:59 | Hokkaido, Japan | |||
593654 | 593654 | 2022-07-01 | Japan | Hokkaido | 382401 | 2096 | 0 | 43.385711 | 142.552318 | 2022-07-02 04:21:16 | Hokkaido, Japan | |||
3940055 | 3940055 | 2022-06-30 | Japan | Hokkaido | 381760 | 2096 | 0 | 43.385711 | 142.552318 | 2022-07-01 04:21:10 | Hokkaido, Japan | |||
2490013 | 2490013 | 2022-06-29 | Japan | Hokkaido | 381115 | 2096 | 0 | 43.385711 | 142.552318 | 2022-06-30 04:21:01 | Hokkaido, Japan | |||
475427 | 475427 | 2022-06-26 | Japan | Aichi | 566159 | 2096 | 0 | 35.035551 | 137.211621 | 2022-06-27 04:21:00 | Aichi, Japan | |||
464080 | 464080 | 2022-05-02 | US | Florida | Brevard | 12009 | 134978 | 2096 | 0 | 28.29409504 | -80.73091022 | 2022-05-03 04:21:00 | Brevard, Florida, US | |
3916719 | 3916719 | 2022-05-01 | US | Florida | Brevard | 12009 | 134978 | 2096 | 0 | 28.29409504 | -80.73091022 | 2022-05-02 04:21:10 | Brevard, Florida, US | |
2841523 | 2841523 | 2022-04-30 | US | Florida | Brevard | 12009 | 134978 | 2096 | 0 | 28.29409504 | -80.73091022 | 2022-05-01 04:20:57 | Brevard, Florida, US | |
1157836 | 1157836 | 2022-04-29 | US | Florida | Brevard | 12009 | 134978 | 2096 | 0 | 28.29409504 | -80.73091022 | 2022-04-30 04:21:05 | Brevard, Florida, US | |
1697018 | 1697018 | 2022-04-28 | US | Florida | Brevard | 12009 | 134978 | 2096 | 0 | 28.29409504 | -80.73091022 | 2022-04-29 04:20:59 | Brevard, Florida, US | |
3852501 | 3852501 | 2022-04-27 | US | Florida | Brevard | 12009 | 134978 | 2096 | 0 | 28.29409504 | -80.73091022 | 2022-04-28 04:20:47 | Brevard, Florida, US | |
1326931 | 1326931 | 2022-04-26 | US | Florida | Brevard | 12009 | 134978 | 2096 | 0 | 28.29409504 | -80.73091022 | 2022-04-27 04:20:52 | Brevard, Florida, US | |
1540204 | 1540204 | 2022-03-31 | Russia | Sakha (Yakutiya) Republic | 173378 | 2096 | 0 | 66.941626 | 129.642371 | 2022-04-01 04:20:28 | Sakha (Yakutiya) Republic, Russia | |||
2478217 | 2478217 | 2022-03-30 | Russia | Sakha (Yakutiya) Republic | 173046 | 2096 | 0 | 66.941626 | 129.642371 | 2022-03-31 04:20:56 | Sakha (Yakutiya) Republic, Russia | |||
2477968 | 2477968 | 2022-03-30 | Japan | Hyogo | 332097 | 2096 | 0 | 35.039913 | 134.828057 | 2022-03-31 04:20:56 | Hyogo, Japan | |||
942946 | 942946 | 2022-02-28 | Mongolia | 908157 | 2096 | 0 | 46.8625 | 103.8467 | 2022-03-01 04:21:09 | Mongolia | ||||
2733137 | 2733137 | 2022-02-27 | Mongolia | 905968 | 2096 | 0 | 46.8625 | 103.8467 | 2022-02-28 04:21:05 | Mongolia | ||||
2448359 | 2448359 | 2022-02-22 | US | Maryland | Prince George's | 24033 | 168453 | 2096 | 0 | 38.83070039 | -76.8496441 | 2022-02-23 04:21:09 | Prince George's, Maryland, US | |
3875519 | 3875519 | 2022-02-19 | India | Manipur | 136384 | 2096 | 0 | 24.738975 | 93.882541 | 2022-02-20 04:21:00 | Manipur, India | |||
188247 | 188247 | 2022-02-13 | US | New Jersey | Monmouth | 34025 | 160068 | 2096 | 0 | 40.26549699 | -74.22240686 | 2022-02-14 04:20:51 | Monmouth, New Jersey, US | |
1294120 | 1294120 | 2022-02-05 | Mexico | Colima | 49568 | 2096 | 0 | 19.1223 | -104.0072 | 2022-02-06 04:21:00 | Colima, Mexico | |||
978683 | 978683 | 2022-02-01 | Brazil | Roraima | 142645 | 2096 | 0 | -2.7376 | -62.0751 | 2022-02-02 04:21:09 | Roraima, Brazil | |||
2657525 | 2657525 | 2022-01-31 | Brazil | Roraima | 142566 | 2096 | 0 | -2.7376 | -62.0751 | 2022-02-01 04:21:11 | Roraima, Brazil | |||
3299942 | 3299942 | 2022-01-30 | Brazil | Roraima | 142296 | 2096 | 0 | -2.7376 | -62.0751 | 2022-01-31 04:21:09 | Roraima, Brazil | |||
3061733 | 3061733 | 2022-01-29 | Brazil | Roraima | 141628 | 2096 | 0 | -2.7376 | -62.0751 | 2022-01-30 04:21:26 | Roraima, Brazil | |||
3809667 | 3809667 | 2022-01-28 | Brazil | Roraima | 140646 | 2096 | 0 | -2.7376 | -62.0751 | 2022-01-29 04:21:10 | Roraima, Brazil | |||
3425162 | 3425162 | 2022-01-21 | Russia | Khakassia Republic | 55362 | 2096 | 0 | 53.72258845 | 91.44293627 | 2022-01-22 04:21:13 | Khakassia Republic, Russia | |||
1692433 | 1692433 | 2022-01-10 | Mozambique | 210991 | 2096 | 0 | -18.665695 | 35.529562 | 2022-01-11 04:22:01 | Mozambique | ||||
1670066 | 1670066 | 2021-12-29 | US | Massachusetts | Worcester | 25027 | 124404 | 2096 | 0 | 42.35026951 | -71.90493363 | 2021-12-30 04:21:25 | Worcester, Massachusetts, US | |
734173 | 734173 | 2021-12-27 | Ukraine | Ternopil Oblast | 107067 | 2096 | 0 | 49.5535 | 25.5948 | 2021-12-28 04:21:47 | Ternopil Oblast, Ukraine | |||
404373 | 404373 | 2021-12-07 | Mexico | Campeche | 24216 | 2096 | 0 | 19.8301 | -90.5349 | 2021-12-08 04:22:46 | Campeche, Mexico | |||
1030455 | 1030455 | 2021-12-06 | Mexico | Campeche | 24216 | 2096 | 0 | 19.8301 | -90.5349 | 2021-12-07 04:22:34 | Campeche, Mexico | |||
1740618 | 1740618 | 2021-12-05 | Mexico | Campeche | 24215 | 2096 | 0 | 19.8301 | -90.5349 | 2021-12-06 04:22:34 | Campeche, Mexico | |||
138050 | 138050 | 2021-12-04 | Mexico | Campeche | 24204 | 2096 | 0 | 19.8301 | -90.5349 | 2021-12-05 04:22:25 | Campeche, Mexico | |||
2195703 | 2195703 | 2021-12-03 | Mexico | Campeche | 24204 | 2096 | 0 | 19.8301 | -90.5349 | 2021-12-04 04:22:18 | Campeche, Mexico | |||
904428 | 904428 | 2021-11-24 | Russia | Smolensk Oblast | 75686 | 2096 | 0 | 55.03434960000001 | 33.0192065 | 2021-11-25 04:22:33 | Smolensk Oblast, Russia | |||
3493771 | 3493771 | 2021-10-26 | US | Massachusetts | Essex | 25009 | 112647 | 2096 | 0 | 42.6687626 | -70.94687179 | 2021-10-27 04:22:32 | Essex, Massachusetts, US | |
2123491 | 2123491 | 2021-10-21 | Canada | British Columbia | 200249 | 2096 | 0 | 53.7267 | -127.6476 | 2021-10-22 04:21:14 | British Columbia, Canada | |||
706593 | 706593 | 2021-09-29 | Peru | Ayacucho | 33602 | 2096 | 0 | -14.091648000000001 | -74.08344 | 2021-09-30 04:21:20 | Ayacucho, Peru | |||
706559 | 706559 | 2021-09-29 | Netherlands | Gelderland | 221275 | 2096 | 0 | 52.061738 | 5.939114 | 2021-09-30 04:21:20 | Gelderland, Netherlands | |||
1334435 | 1334435 | 2021-09-28 | Peru | Ayacucho | 33602 | 2096 | 0 | -14.091648000000001 | -74.08344 | 2021-09-29 04:21:45 | Ayacucho, Peru | |||
1334401 | 1334401 | 2021-09-28 | Netherlands | Gelderland | 221051 | 2096 | 0 | 52.061738 | 5.939114 | 2021-09-29 04:21:45 | Gelderland, Netherlands | |||
1235804 | 1235804 | 2021-09-27 | Peru | Ayacucho | 33602 | 2096 | 0 | -14.091648000000001 | -74.08344 | 2021-09-28 04:21:28 | Ayacucho, Peru | |||
2076105 | 2076105 | 2021-09-26 | Peru | Ayacucho | 33568 | 2096 | 0 | -14.091648000000001 | -74.08344 | 2021-09-27 04:21:16 | Ayacucho, Peru | |||
1724657 | 1724657 | 2021-09-25 | Peru | Ayacucho | 33568 | 2096 | 0 | -14.091648000000001 | -74.08344 | 2021-09-26 04:21:29 | Ayacucho, Peru | |||
601848 | 601848 | 2021-09-23 | Peru | Ayacucho | 33532 | 2096 | 0 | -14.091648000000001 | -74.08344 | 2021-09-24 04:21:44 | Ayacucho, Peru | |||
3011492 | 3011492 | 2021-09-22 | Peru | Ayacucho | 33513 | 2096 | 0 | -14.091648000000001 | -74.08344 | 2021-09-23 04:21:43 | Ayacucho, Peru | |||
3757630 | 3757630 | 2021-09-21 | Peru | Ayacucho | 33513 | 2096 | 0 | -14.091648000000001 | -74.08344 | 2021-09-22 04:21:45 | Ayacucho, Peru | |||
16116 | 16116 | 2021-09-18 | Cambodia | 103482 | 2096 | 0 | 11.55 | 104.9167 | 2021-09-19 04:21:34 | Cambodia | ||||
3904194 | 3904194 | 2021-07-31 | Russia | Leningrad Oblast | 56088 | 2096 | 47185 | 6807 | 60.1853296 | 32.3925325 | 2021-08-01 04:21:50 | Leningrad Oblast, Russia | ||
2939986 | 2939986 | 2021-05-16 | US | Connecticut | New Haven | 9009 | 91189 | 2096 | 0 | 41.4080325 | -72.93620426 | 2021-05-17 04:20:34 | New Haven, Connecticut, US | |
1873616 | 1873616 | 2021-05-15 | US | Connecticut | New Haven | 9009 | 91189 | 2096 | 0 | 41.4080325 | -72.93620426 | 2021-05-16 04:20:49 | New Haven, Connecticut, US | |
1082585 | 1082585 | 2021-05-14 | US | Connecticut | New Haven | 9009 | 91189 | 2096 | 0 | 41.4080325 | -72.93620426 | 2021-05-15 04:20:58 | New Haven, Connecticut, US | |
38095 | 38095 | 2021-04-12 | US | Michigan | Oakland | 26125 | 98298 | 2096 | 0 | 42.66090111 | -83.38595416 | 2021-04-13 04:20:37 | Oakland, Michigan, US | |
3885254 | 3885254 | 2021-04-11 | US | Michigan | Oakland | 26125 | 97070 | 2096 | 0 | 42.66090111 | -83.38595416 | 2021-04-12 04:21:00 | Oakland, Michigan, US | |
2984922 | 2984922 | 2021-04-10 | US | Michigan | Oakland | 26125 | 97070 | 2096 | 0 | 42.66090111 | -83.38595416 | 2021-04-11 04:20:56 | Oakland, Michigan, US | |
3372104 | 3372104 | 2021-03-21 | US | Puerto Rico | Unassigned | 72999 | 3015 | 2096 | 0 | 18.459681 | -67.336525 | 2021-03-22 05:25:43 | Unassigned, Puerto Rico, US | |
1747314 | 1747314 | 2021-03-20 | US | Puerto Rico | Unassigned | 72999 | 3009 | 2096 | 0 | 18.459681 | -67.336525 | 2021-03-21 05:25:44 | Unassigned, Puerto Rico, US | |
704852 | 704852 | 2021-03-16 | US | Ohio | Cuyahoga | 39035 | 98710 | 2096 | 0 | 41.424119 | -81.65918339 | 2021-03-17 05:25:07 | Cuyahoga, Ohio, US | |
1090219 | 1090219 | 2021-03-03 | Pakistan | Khyber Pakhtunkhwa | 73007 | 2096 | 68676 | 2235 | 34.485332 | 72.09169 | 2021-03-04 05:24:24 | Khyber Pakhtunkhwa, Pakistan | ||
2367358 | 2367358 | 2021-02-28 | Colombia | Tolima | 65172 | 2096 | 62102 | 974 | 4.0925 | -75.1545 | 2021-03-01 05:23:01 | Tolima, Colombia | ||
2677813 | 2677813 | 2021-02-13 | Italy | Marche | 60453 | 2096 | 50278 | 8079 | 43.61675973 | 13.5188753 | 2021-02-14 05:23:43 | Marche, Italy | ||
3978703 | 3978703 | 2021-02-10 | Netherlands | Noord-Holland | 171228 | 2096 | 0 | 168899 | 52.60090600000001 | 4.918688 | 2021-02-11 05:23:55 | Noord-Holland, Netherlands | ||
1688129 | 1688129 | 2021-02-02 | Ukraine | Lviv Oblast | 71446 | 2096 | 61708 | 7642 | 49.8397 | 24.0297 | 2021-02-03 05:22:52 | Lviv Oblast, Ukraine | ||
1676577 | 1676577 | 2021-02-01 | Mexico | Zacatecas | 25262 | 2096 | 0 | 23166 | 22.7709 | -102.5832 | 2021-02-02 05:22:49 | Zacatecas, Mexico | ||
845706 | 845706 | 2020-12-12 | North Macedonia | 73025 | 2096 | 48726 | 22203 | 41.6086 | 21.7453 | 2020-12-13 05:27:20 | North Macedonia | |||
739892 | 739892 | 2020-12-02 | US | Massachusetts | Middlesex | 25017 | 47671 | 2096 | 0 | 45236 | 42.48607732 | -71.39049229 | 2020-12-03 05:28:22 | Middlesex, Massachusetts, US |
823723 | 823723 | 2020-11-19 | US | New Jersey | Bergen | 34003 | 32722 | 2096 | 0 | 30626 | 40.96010917 | -74.07164325 | 2020-11-20 05:26:28 | Bergen, New Jersey, US |
3651893 | 3651893 | 2020-10-24 | Switzerland | 103653 | 2096 | 55800 | 45757 | 46.8182 | 8.2275 | 2020-10-25 04:24:36 | Switzerland | |||
1177578 | 1177578 | 2020-10-22 | Mexico | Guerrero | 21580 | 2096 | 18764 | 720 | 17.4392 | -99.5451 | 2020-10-23 04:24:46 | Guerrero, Mexico | ||
2191683 | 2191683 | 2020-10-21 | Mexico | Guerrero | 21404 | 2096 | 18644 | 664 | 17.4392 | -99.5451 | 2020-10-22 04:24:27 | Guerrero, Mexico | ||
3316318 | 3316318 | 2020-09-22 | Mexico | Tamaulipas | 27968 | 2096 | 25039 | 833 | 24.2669 | -98.8363 | 2020-09-23 04:23:00 | Tamaulipas, Mexico | ||
837610 | 837610 | 2020-08-17 | Italy | Veneto | 21256 | 2096 | 17526 | 1634 | 45.43490485 | 12.33845213 | 2020-08-18 04:27:56 | Veneto, Italy | ||
1555968 | 1555968 | 2020-08-16 | Italy | Veneto | 21210 | 2096 | 17507 | 1607 | 45.43490485 | 12.33845213 | 2020-08-17 04:27:20 | Veneto, Italy | ||
145970 | 145970 | 2020-08-15 | Italy | Veneto | 21132 | 2096 | 17476 | 1560 | 45.43490485 | 12.33845213 | 2020-08-16 04:27:42 | Veneto, Italy | ||
62138 | 62138 | 2020-07-23 | Pakistan | Sindh | 115883 | 2096 | 100002 | 13785 | 26.009446 | 68.77680699999999 | 2020-07-24 05:30:40 | Sindh, Pakistan | ||
2685174 | 2685174 | 2020-07-06 | Bangladesh | 165618 | 2096 | 76149 | 87373 | 23.685 | 90.3563 | 2020-07-07 04:34:00 | Bangladesh |
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]);