johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
63 rows where deaths = 2370 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 18
- US 19
- Peru 14
- Russia 6
- Ukraine 5
- Mexico 3
- Colombia 2
- India 2
- Latvia 2
- Afghanistan 1
- Brazil 1
- Chile 1
- Denmark 1
- Kosovo 1
- Netherlands 1
- Oman 1
- Saudi Arabia 1
- Spain 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3460432 | 3460432 | 2022-11-21 | Russia | Zabaykalsky Krai | 188531 | 2370 | 0 | 52.248521 | 115.956325 | 2022-11-22 04:20:47 | Zabaykalsky Krai, Russia | |||
1640617 | 1640617 | 2022-11-20 | Russia | Zabaykalsky Krai | 188493 | 2370 | 0 | 52.248521 | 115.956325 | 2022-11-21 04:21:05 | Zabaykalsky Krai, Russia | |||
422906 | 422906 | 2022-09-18 | US | Wisconsin | Milwaukee | 55079 | 314522 | 2370 | 0 | 43.00486062 | -87.96733172 | 2022-09-19 04:21:49 | Milwaukee, Wisconsin, US | |
3376930 | 3376930 | 2022-09-17 | US | Wisconsin | Milwaukee | 55079 | 314522 | 2370 | 0 | 43.00486062 | -87.96733172 | 2022-09-18 04:22:50 | Milwaukee, Wisconsin, US | |
2359038 | 2359038 | 2022-09-16 | US | Wisconsin | Milwaukee | 55079 | 314522 | 2370 | 0 | 43.00486062 | -87.96733172 | 2022-09-17 04:20:19 | Milwaukee, Wisconsin, US | |
3990195 | 3990195 | 2022-09-15 | US | Wisconsin | Milwaukee | 55079 | 314320 | 2370 | 0 | 43.00486062 | -87.96733172 | 2022-09-16 04:21:19 | Milwaukee, Wisconsin, US | |
3766039 | 3766039 | 2022-09-11 | Peru | Ayacucho | 53376 | 2370 | 0 | -14.091648 | -74.08344 | 2022-09-12 04:20:58 | Ayacucho, Peru | |||
3824614 | 3824614 | 2022-09-10 | Peru | Ayacucho | 53376 | 2370 | 0 | -14.091648 | -74.08344 | 2022-09-11 04:20:50 | Ayacucho, Peru | |||
963071 | 963071 | 2022-09-09 | Peru | Ayacucho | 53376 | 2370 | 0 | -14.091648 | -74.08344 | 2022-09-10 04:21:10 | Ayacucho, Peru | |||
253473 | 253473 | 2022-09-08 | Peru | Ayacucho | 53376 | 2370 | 0 | -14.091648 | -74.08344 | 2022-09-09 04:21:11 | Ayacucho, Peru | |||
3745271 | 3745271 | 2022-09-07 | Peru | Ayacucho | 53376 | 2370 | 0 | -14.091648 | -74.08344 | 2022-09-08 04:21:02 | Ayacucho, Peru | |||
114911 | 114911 | 2022-09-06 | Peru | Ayacucho | 53376 | 2370 | 0 | -14.091648 | -74.08344 | 2022-09-07 04:20:59 | Ayacucho, Peru | |||
2633883 | 2633883 | 2022-09-05 | Peru | Ayacucho | 53229 | 2370 | 0 | -14.091648 | -74.08344 | 2022-09-06 04:21:02 | Ayacucho, Peru | |||
2987447 | 2987447 | 2022-09-04 | Peru | Ayacucho | 53229 | 2370 | 0 | -14.091648 | -74.08344 | 2022-09-05 04:21:01 | Ayacucho, Peru | |||
2713132 | 2713132 | 2022-09-03 | Peru | Ayacucho | 53229 | 2370 | 0 | -14.091648 | -74.08344 | 2022-09-04 04:21:22 | Ayacucho, Peru | |||
1393837 | 1393837 | 2022-09-02 | Peru | Ayacucho | 53229 | 2370 | 0 | -14.091648 | -74.08344 | 2022-09-03 04:21:04 | Ayacucho, Peru | |||
3547666 | 3547666 | 2022-09-01 | Peru | Ayacucho | 53229 | 2370 | 0 | -14.091648 | -74.08344 | 2022-09-02 04:21:07 | Ayacucho, Peru | |||
2343586 | 2343586 | 2022-08-31 | Peru | Ayacucho | 53229 | 2370 | 0 | -14.091648 | -74.08344 | 2022-09-01 04:21:03 | Ayacucho, Peru | |||
3774066 | 3774066 | 2022-08-30 | Peru | Ayacucho | 53229 | 2370 | 0 | -14.091648 | -74.08344 | 2022-08-31 04:20:57 | Ayacucho, Peru | |||
1680662 | 1680662 | 2022-08-29 | Peru | Ayacucho | 53229 | 2370 | 0 | -14.091648 | -74.08344 | 2022-08-30 04:21:03 | Ayacucho, Peru | |||
3910184 | 3910184 | 2022-08-11 | US | New Jersey | Passaic | 34031 | 167585 | 2370 | 0 | 41.03238628 | -74.29954144 | 2022-08-12 04:20:54 | Passaic, New Jersey, US | |
1348501 | 1348501 | 2022-08-10 | US | New Jersey | Passaic | 34031 | 167376 | 2370 | 0 | 41.03238628 | -74.29954144 | 2022-08-11 04:20:49 | Passaic, New Jersey, US | |
2008464 | 2008464 | 2022-08-04 | Chile | Los Lagos | 210600 | 2370 | 0 | -41.9198 | -72.1416 | 2022-08-05 04:20:52 | Los Lagos, Chile | |||
2307539 | 2307539 | 2022-04-20 | Russia | Tambov Oblast | 114461 | 2370 | 0 | 52.9019574 | 41.3578918 | 2022-04-21 04:20:46 | Tambov Oblast, Russia | |||
3061840 | 3061840 | 2022-01-29 | Colombia | Risaralda | 103229 | 2370 | 0 | 5.3158 | -75.9928 | 2022-01-30 04:21:26 | Risaralda, Colombia | |||
3813575 | 3813575 | 2022-01-28 | Ukraine | Rivne Oblast | 139034 | 2370 | 0 | 50.6199 | 26.2516 | 2022-01-29 04:21:10 | Rivne Oblast, Ukraine | |||
1115189 | 1115189 | 2022-01-11 | US | Massachusetts | Essex | 25009 | 175240 | 2370 | 0 | 42.6687626 | -70.94687179 | 2022-01-12 04:21:44 | Essex, Massachusetts, US | |
2905997 | 2905997 | 2021-12-19 | US | New York | Westchester | 36119 | 157296 | 2370 | 0 | 41.16278376 | -73.75741653 | 2021-12-20 04:21:43 | Westchester, New York, US | |
1261070 | 1261070 | 2021-12-18 | US | New York | Westchester | 36119 | 156313 | 2370 | 0 | 41.16278376 | -73.75741653 | 2021-12-19 04:21:11 | Westchester, New York, US | |
89303 | 89303 | 2021-11-09 | US | New Jersey | Ocean | 34029 | 97056 | 2370 | 0 | 39.8895449 | -74.28089251 | 2021-11-10 04:21:38 | Ocean, New Jersey, US | |
32470 | 32470 | 2021-08-25 | Kosovo | 134818 | 2370 | 0 | 42.602636 | 20.902977 | 2021-08-26 04:21:28 | Kosovo | ||||
3476565 | 3476565 | 2021-07-22 | Russia | Tula Oblast | 46115 | 2370 | 40580 | 3165 | 53.9570701 | 37.3690909 | 2021-07-23 04:21:29 | Tula Oblast, Russia | ||
581003 | 581003 | 2021-07-13 | US | New Jersey | Middlesex | 34023 | 92872 | 2370 | 0 | 40.43629879 | -74.41426991 | 2021-07-14 04:21:35 | Middlesex, New Jersey, US | |
3743252 | 3743252 | 2021-07-12 | US | New Jersey | Middlesex | 34023 | 92846 | 2370 | 0 | 40.43629879 | -74.41426991 | 2021-07-13 04:21:18 | Middlesex, New Jersey, US | |
3661765 | 3661765 | 2021-07-11 | US | New Jersey | Middlesex | 34023 | 92840 | 2370 | 0 | 40.43629879 | -74.41426991 | 2021-07-12 04:21:34 | Middlesex, New Jersey, US | |
628049 | 628049 | 2021-07-10 | US | New Jersey | Middlesex | 34023 | 92825 | 2370 | 0 | 40.43629879 | -74.41426991 | 2021-07-11 04:21:43 | Middlesex, New Jersey, US | |
831768 | 831768 | 2021-07-09 | US | New Jersey | Middlesex | 34023 | 92801 | 2370 | 0 | 40.43629879 | -74.41426991 | 2021-07-10 04:21:25 | Middlesex, New Jersey, US | |
780532 | 780532 | 2021-07-08 | US | New Jersey | Middlesex | 34023 | 92772 | 2370 | 0 | 40.43629879 | -74.41426991 | 2021-07-09 04:21:21 | Middlesex, New Jersey, US | |
1442754 | 1442754 | 2021-07-07 | US | New Jersey | Middlesex | 34023 | 92734 | 2370 | 0 | 40.43629879 | -74.41426991 | 2021-07-08 04:21:26 | Middlesex, New Jersey, US | |
3149223 | 3149223 | 2021-06-07 | Ukraine | Zaporizhia Oblast | 103644 | 2370 | 98471 | 2803 | 47.8388 | 35.1396 | 2021-06-08 04:22:35 | Zaporizhia Oblast, Ukraine | ||
829225 | 829225 | 2021-06-06 | Ukraine | Zaporizhia Oblast | 103644 | 2370 | 98405 | 2869 | 47.8388 | 35.1396 | 2021-06-07 04:22:51 | Zaporizhia Oblast, Ukraine | ||
2589630 | 2589630 | 2021-06-05 | Ukraine | Zaporizhia Oblast | 103629 | 2370 | 98240 | 3019 | 47.8388 | 35.1396 | 2021-06-06 04:24:03 | Zaporizhia Oblast, Ukraine | ||
2318944 | 2318944 | 2021-06-04 | Ukraine | Zaporizhia Oblast | 103491 | 2370 | 97735 | 3386 | 47.8388 | 35.1396 | 2021-06-05 04:23:03 | Zaporizhia Oblast, Ukraine | ||
1708451 | 1708451 | 2021-06-02 | Oman | 219529 | 2370 | 201113 | 16046 | 21.512583 | 55.92325500000001 | 2021-06-03 04:23:32 | Oman | |||
3089480 | 3089480 | 2021-05-30 | Latvia | 133098 | 2370 | 125340 | 5388 | 56.8796 | 24.6032 | 2021-05-31 03:08:59 | Latvia | |||
50849 | 50849 | 2021-05-29 | Latvia | 132918 | 2370 | 125340 | 5208 | 56.8796 | 24.6032 | 2021-05-30 04:20:55 | Latvia | |||
726359 | 726359 | 2021-05-22 | Colombia | Tolima | 73217 | 2370 | 69684 | 1163 | 4.0925 | -75.1545 | 2021-05-23 04:20:51 | Tolima, Colombia | ||
2256777 | 2256777 | 2021-05-19 | US | Illinois | Unassigned | 90017 | 95 | 2370 | 0 | 42.36542373 | 0.0 | 2021-05-20 04:21:05 | Unassigned, Illinois, US | |
2450721 | 2450721 | 2021-05-02 | India | Jammu and Kashmir | 183486 | 2370 | 148695 | 32421 | 33.75943 | 76.612638 | 2021-05-03 04:20:39 | Jammu and Kashmir, India | ||
2983706 | 2983706 | 2021-04-10 | US | Arizona | Pima | 4019 | 113542 | 2370 | 0 | 32.0971334 | -111.7890033 | 2021-04-11 04:20:56 | Pima, Arizona, US | |
1219828 | 1219828 | 2021-03-27 | Russia | Voronezh Oblast | 74330 | 2370 | 68971 | 2989 | 50.9800393 | 40.15065070000001 | 2021-03-28 05:28:10 | Voronezh Oblast, Russia | ||
1980742 | 1980742 | 2021-03-25 | Netherlands | Noord-Holland | 213551 | 2370 | 0 | 210871 | 52.60090600000001 | 4.918688 | 2021-03-26 05:26:55 | Noord-Holland, Netherlands | ||
1089952 | 1089952 | 2021-03-03 | Denmark | 212798 | 2370 | 203433 | 6995 | 56.2639 | 9.5018 | 2021-03-04 05:24:24 | Denmark | |||
182136 | 182136 | 2021-02-21 | Mexico | Quintana Roo | 19896 | 2370 | 0 | 17526 | 19.1817 | -88.4791 | 2021-02-22 05:24:21 | Quintana Roo, Mexico | ||
2466493 | 2466493 | 2021-01-22 | Afghanistan | 54483 | 2370 | 46912 | 5201 | 33.93911 | 67.709953 | 2021-01-23 05:22:03 | Afghanistan | |||
439008 | 439008 | 2021-01-21 | United Kingdom | Northern Ireland | 98351 | 2370 | 0 | 96659 | 54.7877 | -6.4923 | 2021-01-22 05:22:10 | Northern Ireland, United Kingdom | ||
908415 | 908415 | 2021-01-19 | Russia | Rostov Oblast | 59100 | 2370 | 48864 | 7866 | 47.6222451 | 40.7957942 | 2021-01-20 05:21:54 | Rostov Oblast, Russia | ||
1751023 | 1751023 | 2020-12-14 | Brazil | Sergipe | 99753 | 2370 | 86854 | 10529 | -10.5741 | -37.3857 | 2020-12-15 05:26:38 | Sergipe, Brazil | ||
75053 | 75053 | 2020-12-03 | India | Rajasthan | 274486 | 2370 | 246572 | 25544 | 26.583423 | 73.847973 | 2020-12-04 05:27:27 | Rajasthan, India | ||
2785090 | 2785090 | 2020-11-13 | Mexico | Guerrero | 22856 | 2370 | 0 | 20486 | 17.4392 | -99.5451 | 2020-11-14 05:25:37 | Guerrero, Mexico | ||
1452867 | 1452867 | 2020-10-27 | Spain | Andalusia | 117612 | 2370 | 10671 | 104571 | 37.5443 | -4.7278 | 2020-10-28 04:24:39 | Andalusia, Spain | ||
1822887 | 1822887 | 2020-10-04 | Mexico | Tamaulipas | 29384 | 2370 | 26118 | 896 | 24.2669 | -98.8363 | 2020-10-05 04:23:33 | Tamaulipas, Mexico | ||
367817 | 367817 | 2020-07-16 | Saudi Arabia | 243238 | 2370 | 187622 | 53246 | 23.885942 | 45.079162 | 2020-07-17 04:34:50 | 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]);