johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
80 rows where deaths = 2100 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
307945 | 307945 | 2022-12-13 | Malaysia | Perak | 237863 | 2100 | 0 | 4.5921 | 101.0901 | 2022-12-14 04:21:04 | Perak, Malaysia | |||
1149006 | 1149006 | 2022-12-12 | Malaysia | Perak | 237832 | 2100 | 0 | 4.5921 | 101.0901 | 2022-12-13 04:21:01 | Perak, Malaysia | |||
2816762 | 2816762 | 2022-12-03 | Japan | Fukuoka | 1182951 | 2100 | 0 | 33.526032 | 130.666949 | 2022-12-04 04:20:56 | Fukuoka, Japan | |||
1372994 | 1372994 | 2022-09-21 | US | Ohio | Montgomery | 39113 | 147784 | 2100 | 0 | 39.75394919 | -84.29050975 | 2022-09-22 04:22:56 | Montgomery, Ohio, US | |
3111072 | 3111072 | 2022-07-13 | US | Maryland | Montgomery | 24031 | 203679 | 2100 | 0 | 39.13676329 | -77.20358245 | 2022-07-14 04:20:57 | Montgomery, Maryland, US | |
1417083 | 1417083 | 2022-07-08 | Japan | Hokkaido | 387221 | 2100 | 0 | 43.385711 | 142.552318 | 2022-07-09 04:20:59 | Hokkaido, Japan | |||
2740997 | 2740997 | 2022-07-07 | Japan | Aichi | 583260 | 2100 | 0 | 35.035551 | 137.211621 | 2022-07-08 04:20:56 | Aichi, Japan | |||
1199792 | 1199792 | 2022-07-06 | Japan | Aichi | 580548 | 2100 | 0 | 35.035551 | 137.211621 | 2022-07-07 04:20:55 | Aichi, Japan | |||
3966535 | 3966535 | 2022-07-05 | Japan | Aichi | 577811 | 2100 | 0 | 35.035551 | 137.211621 | 2022-07-06 04:20:58 | Aichi, Japan | |||
3896646 | 3896646 | 2022-05-19 | US | Florida | Brevard | 12009 | 136485 | 2100 | 0 | 28.29409504 | -80.73091022 | 2022-05-20 04:20:57 | Brevard, Florida, US | |
1185430 | 1185430 | 2022-05-18 | US | Florida | Brevard | 12009 | 136485 | 2100 | 0 | 28.29409504 | -80.73091022 | 2022-05-19 04:20:54 | Brevard, Florida, US | |
3583327 | 3583327 | 2022-05-17 | US | Florida | Brevard | 12009 | 136485 | 2100 | 0 | 28.29409504 | -80.73091022 | 2022-05-18 04:20:50 | Brevard, Florida, US | |
1504284 | 1504284 | 2022-05-16 | US | Florida | Brevard | 12009 | 136485 | 2100 | 0 | 28.29409504 | -80.73091022 | 2022-05-17 04:20:59 | Brevard, Florida, US | |
2084643 | 2084643 | 2022-05-15 | US | Florida | Brevard | 12009 | 136485 | 2100 | 0 | 28.29409504 | -80.73091022 | 2022-05-16 04:20:47 | Brevard, Florida, US | |
3355353 | 3355353 | 2022-05-14 | US | Florida | Brevard | 12009 | 136485 | 2100 | 0 | 28.29409504 | -80.73091022 | 2022-05-15 04:20:53 | Brevard, Florida, US | |
658998 | 658998 | 2022-05-13 | US | Florida | Brevard | 12009 | 136485 | 2100 | 0 | 28.29409504 | -80.73091022 | 2022-05-14 04:20:48 | Brevard, Florida, US | |
2534081 | 2534081 | 2022-05-12 | US | Florida | Brevard | 12009 | 136485 | 2100 | 0 | 28.29409504 | -80.73091022 | 2022-05-13 04:20:51 | Brevard, Florida, US | |
3445527 | 3445527 | 2022-05-11 | US | Florida | Brevard | 12009 | 136485 | 2100 | 0 | 28.29409504 | -80.73091022 | 2022-05-12 04:20:54 | Brevard, Florida, US | |
3536144 | 3536144 | 2022-05-10 | US | Florida | Brevard | 12009 | 136485 | 2100 | 0 | 28.29409504 | -80.73091022 | 2022-05-11 04:20:48 | Brevard, Florida, US | |
3730479 | 3730479 | 2022-04-03 | Russia | Sakha (Yakutiya) Republic | 174369 | 2100 | 0 | 66.941626 | 129.642371 | 2022-04-04 04:20:51 | Sakha (Yakutiya) Republic, Russia | |||
499914 | 499914 | 2022-04-02 | Russia | Sakha (Yakutiya) Republic | 174045 | 2100 | 0 | 66.941626 | 129.642371 | 2022-04-03 04:20:48 | Sakha (Yakutiya) Republic, Russia | |||
1539955 | 1539955 | 2022-03-31 | Japan | Hyogo | 334167 | 2100 | 0 | 35.039913 | 134.828057 | 2022-04-01 04:20:28 | Hyogo, Japan | |||
1539639 | 1539639 | 2022-03-31 | Australia | New South Wales | 1843078 | 2100 | 0 | -33.8688 | 151.2093 | 2022-04-01 04:20:28 | New South Wales, Australia | |||
694582 | 694582 | 2022-03-17 | Russia | Belgorod Oblast | 123198 | 2100 | 0 | 50.7080119 | 37.5837615 | 2022-03-18 04:20:55 | Belgorod Oblast, Russia | |||
1644475 | 1644475 | 2022-03-03 | Mongolia | 910377 | 2100 | 0 | 46.8625 | 103.8467 | 2022-03-04 04:21:09 | Mongolia | ||||
1992624 | 1992624 | 2022-03-01 | Italy | Calabria | 217806 | 2100 | 0 | 38.90597598 | 16.59440194 | 2022-03-02 04:21:07 | Calabria, Italy | |||
575044 | 575044 | 2022-02-25 | Russia | Kemerovo Oblast | 141205 | 2100 | 0 | 54.53357809999999 | 87.342861 | 2022-02-26 04:21:12 | Kemerovo Oblast, Russia | |||
1058656 | 1058656 | 2022-02-23 | US | Georgia | Fulton | 13121 | 211625 | 2100 | 0 | 33.79216944 | -84.46319413 | 2022-02-24 04:21:14 | Fulton, Georgia, US | |
1057564 | 1057564 | 2022-02-23 | Brazil | Amapa | 160025 | 2100 | 0 | 0.902 | -52.003 | 2022-02-24 04:21:14 | Amapa, Brazil | |||
3911961 | 3911961 | 2022-02-20 | India | Manipur | 136433 | 2100 | 0 | 24.738975 | 93.882541 | 2022-02-21 04:21:05 | Manipur, India | |||
236918 | 236918 | 2022-02-11 | Yemen | 11659 | 2100 | 0 | 15.552726999999999 | 48.516388 | 2022-02-12 04:21:06 | Yemen | ||||
233114 | 233114 | 2022-02-11 | Estonia | 410210 | 2100 | 0 | 58.5953 | 25.0136 | 2022-02-12 04:21:06 | Estonia | ||||
71175 | 71175 | 2022-02-07 | Mexico | Colima | 50046 | 2100 | 0 | 19.1223 | -104.0072 | 2022-02-08 04:21:15 | Colima, Mexico | |||
1227912 | 1227912 | 2022-01-24 | Spain | Extremadura | 197589 | 2100 | 0 | 39.4937 | -6.0679 | 2022-01-25 04:21:05 | Extremadura, Spain | |||
3689053 | 3689053 | 2022-01-13 | US | Maryland | Baltimore | 24005 | 119103 | 2100 | 0 | 39.45784712 | -76.62911955 | 2022-01-14 04:21:54 | Baltimore, Maryland, US | |
1436212 | 1436212 | 2021-12-28 | Ukraine | Ternopil Oblast | 107110 | 2100 | 0 | 49.5535 | 25.5948 | 2021-12-29 03:21:43 | Ternopil Oblast, Ukraine | |||
406528 | 406528 | 2021-12-07 | US | New York | Erie | 36029 | 130221 | 2100 | 0 | 42.76249024 | -78.73063652 | 2021-12-08 04:22:46 | Erie, New York, US | |
1744187 | 1744187 | 2021-12-05 | Ukraine | Zakarpattia Oblast | 82031 | 2100 | 0 | 48.6208 | 22.2879 | 2021-12-06 04:22:34 | Zakarpattia Oblast, Ukraine | |||
153609 | 153609 | 2021-11-29 | Ukraine | Chernihiv Oblast | 88776 | 2100 | 0 | 51.4982 | 31.2893 | 2021-11-30 04:22:53 | Chernihiv Oblast, Ukraine | |||
1802994 | 1802994 | 2021-11-25 | Russia | Smolensk Oblast | 76175 | 2100 | 0 | 55.03434960000001 | 33.0192065 | 2021-11-26 04:22:33 | Smolensk Oblast, Russia | |||
162222 | 162222 | 2021-11-19 | Russia | Buryatia Republic | 66957 | 2100 | 0 | 52.718242599999996 | 109.492143 | 2021-11-20 04:22:17 | Buryatia Republic, Russia | |||
1322421 | 1322421 | 2021-11-14 | Russia | Astrakhan Oblast | 69871 | 2100 | 0 | 47.1878186 | 47.608851 | 2021-11-15 04:21:36 | Astrakhan Oblast, Russia | |||
686573 | 686573 | 2021-11-13 | Russia | Komi Republic | 84068 | 2100 | 0 | 63.9881421 | 54.3326073 | 2021-11-14 04:21:31 | Komi Republic, Russia | |||
289594 | 289594 | 2021-10-31 | US | Massachusetts | Essex | 25009 | 113176 | 2100 | 0 | 42.6687626 | -70.94687179 | 2021-11-01 04:22:01 | Essex, Massachusetts, US | |
2722600 | 2722600 | 2021-10-30 | US | Massachusetts | Essex | 25009 | 113176 | 2100 | 0 | 42.6687626 | -70.94687179 | 2021-10-31 04:22:08 | Essex, Massachusetts, US | |
2721115 | 2721115 | 2021-10-30 | Montenegro | 143785 | 2100 | 0 | 42.708678000000006 | 19.37439 | 2021-10-31 04:22:08 | Montenegro | ||||
568702 | 568702 | 2021-10-29 | US | Massachusetts | Essex | 25009 | 113176 | 2100 | 0 | 42.6687626 | -70.94687179 | 2021-10-30 04:22:03 | Essex, Massachusetts, US | |
2124006 | 2124006 | 2021-10-21 | Russia | Vologda Oblast | 74816 | 2100 | 0 | 60.0391461 | 43.1215213 | 2021-10-22 04:21:14 | Vologda Oblast, Russia | |||
495285 | 495285 | 2021-10-14 | Ukraine | Zhytomyr Oblast | 101123 | 2100 | 0 | 50.2547 | 28.6587 | 2021-10-15 04:21:26 | Zhytomyr Oblast, Ukraine | |||
2879840 | 2879840 | 2021-10-09 | Ukraine | Khmelnytskyi Oblast | 99599 | 2100 | 0 | 49.423 | 26.9871 | 2021-10-10 04:21:38 | Khmelnytskyi Oblast, Ukraine | |||
2458950 | 2458950 | 2021-10-06 | Peru | Ayacucho | 33745 | 2100 | 0 | -14.091648000000001 | -74.08344 | 2021-10-07 04:21:36 | Ayacucho, Peru | |||
3832644 | 3832644 | 2021-10-05 | Peru | Ayacucho | 33745 | 2100 | 0 | -14.091648000000001 | -74.08344 | 2021-10-06 04:21:33 | Ayacucho, Peru | |||
987208 | 987208 | 2021-10-04 | Russia | Murmansk Oblast | 73155 | 2100 | 0 | 68.00004179999999 | 33.9999151 | 2021-10-05 04:21:27 | Murmansk Oblast, Russia | |||
987137 | 987137 | 2021-10-04 | Peru | Ayacucho | 33745 | 2100 | 0 | -14.091648000000001 | -74.08344 | 2021-10-05 04:21:27 | Ayacucho, Peru | |||
3931691 | 3931691 | 2021-10-02 | United Arab Emirates | 736524 | 2100 | 0 | 23.424076 | 53.847818000000004 | 2021-10-03 04:21:24 | United Arab Emirates | ||||
2135671 | 2135671 | 2021-10-01 | United Arab Emirates | 736268 | 2100 | 0 | 23.424076 | 53.847818000000004 | 2021-10-02 04:21:25 | United Arab Emirates | ||||
3978250 | 3978250 | 2021-09-03 | Malaysia | W.P. Kuala Lumpur | 175282 | 2100 | 160586 | 12596 | 3.139 | 101.6869 | 2021-09-04 04:21:28 | W.P. Kuala Lumpur, Malaysia | ||
3331368 | 3331368 | 2021-07-21 | Colombia | Caldas | 96767 | 2100 | 92208 | 2459 | 5.2983 | -75.2479 | 2021-07-22 04:21:19 | Caldas, Colombia | ||
625933 | 625933 | 2021-07-10 | Kuwait | 374104 | 2100 | 353936 | 18068 | 29.31166 | 47.481766 | 2021-07-11 04:21:43 | Kuwait | |||
1936063 | 1936063 | 2021-07-05 | Ukraine | Ivano-Frankivsk Oblast | 86688 | 2100 | 84505 | 83 | 48.9226 | 24.7111 | 2021-07-06 04:21:32 | Ivano-Frankivsk Oblast, Ukraine | ||
1932670 | 1932670 | 2021-07-05 | Russia | Novosibirsk Oblast | 47691 | 2100 | 42049 | 3542 | 54.9720169 | 79.48139240000002 | 2021-07-06 04:21:32 | Novosibirsk Oblast, Russia | ||
1168794 | 1168794 | 2021-07-04 | Ukraine | Ivano-Frankivsk Oblast | 86684 | 2100 | 84498 | 86 | 48.9226 | 24.7111 | 2021-07-05 04:21:28 | Ivano-Frankivsk Oblast, Ukraine | ||
1499228 | 1499228 | 2021-07-03 | Ukraine | Ivano-Frankivsk Oblast | 86678 | 2100 | 84486 | 92 | 48.9226 | 24.7111 | 2021-07-04 04:21:38 | Ivano-Frankivsk Oblast, Ukraine | ||
2075543 | 2075543 | 2021-07-02 | Ukraine | Ivano-Frankivsk Oblast | 86674 | 2100 | 84473 | 101 | 48.9226 | 24.7111 | 2021-07-03 04:21:37 | Ivano-Frankivsk Oblast, Ukraine | ||
3923863 | 3923863 | 2021-04-24 | Colombia | Magdalena | 56048 | 2100 | 51740 | 2208 | 10.4113 | -74.4057 | 2021-04-25 04:20:32 | Magdalena, Colombia | ||
1289984 | 1289984 | 2021-03-29 | Italy | Abruzzo | 64774 | 2100 | 52112 | 10562 | 42.35122196 | 13.39843823 | 2021-03-30 04:26:23 | Abruzzo, Italy | ||
1801414 | 1801414 | 2021-03-23 | US | Puerto Rico | Unassigned | 72999 | 3036 | 2100 | 0 | 18.459681 | -67.336525 | 2021-03-24 05:25:40 | Unassigned, Puerto Rico, US | |
3455304 | 3455304 | 2021-03-18 | US | Ohio | Cuyahoga | 39035 | 99155 | 2100 | 0 | 41.424119 | -81.65918339 | 2021-03-19 05:26:09 | Cuyahoga, Ohio, US | |
3256312 | 3256312 | 2021-03-02 | US | New Jersey | Middlesex | 34023 | 73117 | 2100 | 0 | 71017 | 40.43629879 | -74.41426991 | 2021-03-03 05:23:28 | Middlesex, New Jersey, US |
1684607 | 1684607 | 2021-02-02 | Mexico | Zacatecas | 25285 | 2100 | 0 | 23185 | 22.7709 | -102.5832 | 2021-02-03 05:22:52 | Zacatecas, Mexico | ||
2127985 | 2127985 | 2020-12-17 | Italy | Puglia | 77112 | 2100 | 22396 | 52616 | 41.12559576 | 16.86736689 | 2020-12-18 05:28:18 | Puglia, Italy | ||
3441149 | 3441149 | 2020-11-11 | Tunisia | 74522 | 2100 | 51750 | 20672 | 33.886917 | 9.537499 | 2020-11-12 05:25:55 | Tunisia | |||
2661950 | 2661950 | 2020-09-04 | Poland | 69820 | 2100 | 49820 | 17900 | 51.9194 | 19.1451 | 2020-09-05 04:28:19 | Poland | |||
1996735 | 1996735 | 2020-08-26 | Mexico | Nuevo Leon | 27314 | 2100 | 22481 | 2733 | 25.5922 | -99.9962 | 2020-08-27 04:28:15 | Nuevo Leon, Mexico | ||
3484303 | 3484303 | 2020-08-20 | Italy | Veneto | 21534 | 2100 | 17645 | 1789 | 45.43490485 | 12.33845213 | 2020-08-21 04:27:41 | Veneto, Italy | ||
1920663 | 1920663 | 2020-08-10 | India | West Bengal | 98459 | 2100 | 70328 | 26031 | 23.814082 | 87.979803 | 2020-08-11 04:35:08 | West Bengal, India | ||
1925807 | 1925807 | 2020-07-30 | US | New Jersey | Essex | 34013 | 19600 | 2100 | 0 | 17500 | 40.78681335 | -74.24657979 | 2020-07-31 04:35:18 | Essex, New Jersey, US |
2955975 | 2955975 | 2020-07-29 | US | New Jersey | Essex | 34013 | 19584 | 2100 | 0 | 17484 | 40.78681335 | -74.24657979 | 2020-07-30 04:35:05 | Essex, New Jersey, US |
844893 | 844893 | 2020-07-22 | Pakistan | Punjab | 91129 | 2100 | 66802 | 22227 | 30.811346 | 72.13913199999998 | 2020-07-23 05:15:04 | Punjab, Pakistan | ||
1005911 | 1005911 | 2020-07-09 | Saudi Arabia | 223327 | 2100 | 161096 | 60131 | 23.885942 | 45.079162 | 2020-07-10 04:34:24 | Saudi Arabia |
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]);