johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
323 rows where deaths = 840 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 29
- US 198
- Tanzania 43
- Russia 17
- Spain 8
- Haiti 6
- Ukraine 6
- Brazil 4
- Chile 4
- Japan 4
- Mozambique 4
- Taiwan* 3
- Australia 2
- India 2
- Italy 2
- Malaysia 2
- Mexico 2
- Netherlands 2
- Peru 2
- United Kingdom 2
- Austria 1
- Azerbaijan 1
- Colombia 1
- Cuba 1
- Germany 1
- Guyana 1
- Luxembourg 1
- Mauritania 1
- Senegal 1
- Singapore 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2952408 | 2952408 | 2022-12-20 | US | Illinois | Madison | 17119 | 85079 | 840 | 0 | 38.83042506 | -89.90422563 | 2022-12-21 04:21:03 | Madison, Illinois, US | |
310098 | 310098 | 2022-12-13 | US | New Mexico | San Juan | 35045 | 51233 | 840 | 0 | 36.50838318 | -108.320437 | 2022-12-14 04:21:04 | San Juan, New Mexico, US | |
2487720 | 2487720 | 2022-11-16 | US | Minnesota | Dakota | 27037 | 130898 | 840 | 0 | 44.67172617 | -93.06299363 | 2022-11-17 04:21:11 | Dakota, Minnesota, US | |
293731 | 293731 | 2022-11-15 | US | Minnesota | Dakota | 27037 | 130898 | 840 | 0 | 44.67172617 | -93.06299363 | 2022-11-16 04:21:09 | Dakota, Minnesota, US | |
3598761 | 3598761 | 2022-11-14 | US | Minnesota | Dakota | 27037 | 130898 | 840 | 0 | 44.67172617 | -93.06299363 | 2022-11-15 04:21:16 | Dakota, Minnesota, US | |
313619 | 313619 | 2022-11-13 | US | Minnesota | Dakota | 27037 | 130898 | 840 | 0 | 44.67172617 | -93.06299363 | 2022-11-14 04:21:09 | Dakota, Minnesota, US | |
64780 | 64780 | 2022-11-12 | US | Minnesota | Dakota | 27037 | 130898 | 840 | 0 | 44.67172617 | -93.06299363 | 2022-11-13 04:21:14 | Dakota, Minnesota, US | |
2928942 | 2928942 | 2022-11-11 | US | Minnesota | Dakota | 27037 | 130898 | 840 | 0 | 44.67172617 | -93.06299363 | 2022-11-12 04:20:41 | Dakota, Minnesota, US | |
2507778 | 2507778 | 2022-11-10 | US | Minnesota | Dakota | 27037 | 130898 | 840 | 0 | 44.67172617 | -93.06299363 | 2022-11-11 04:21:22 | Dakota, Minnesota, US | |
482264 | 482264 | 2022-11-08 | US | Pennsylvania | Erie | 42049 | 68255 | 840 | 0 | 41.99253829 | -80.03301954 | 2022-11-09 04:21:22 | Erie, Pennsylvania, US | |
2441414 | 2441414 | 2022-11-07 | US | Pennsylvania | Erie | 42049 | 68255 | 840 | 0 | 41.99253829 | -80.03301954 | 2022-11-08 04:21:21 | Erie, Pennsylvania, US | |
1052512 | 1052512 | 2022-11-06 | US | Pennsylvania | Erie | 42049 | 68255 | 840 | 0 | 41.99253829 | -80.03301954 | 2022-11-07 04:21:26 | Erie, Pennsylvania, US | |
620536 | 620536 | 2022-11-05 | US | Pennsylvania | Erie | 42049 | 68255 | 840 | 0 | 41.99253829 | -80.03301954 | 2022-11-06 04:21:24 | Erie, Pennsylvania, US | |
1025040 | 1025040 | 2022-11-04 | US | Pennsylvania | Erie | 42049 | 68255 | 840 | 0 | 41.99253829 | -80.03301954 | 2022-11-05 04:21:52 | Erie, Pennsylvania, US | |
434031 | 434031 | 2022-11-03 | US | Pennsylvania | Erie | 42049 | 68255 | 840 | 0 | 41.99253829 | -80.03301954 | 2022-11-04 04:22:11 | Erie, Pennsylvania, US | |
852273 | 852273 | 2022-11-02 | US | Pennsylvania | Erie | 42049 | 68255 | 840 | 0 | 41.99253829 | -80.03301954 | 2022-11-03 04:22:05 | Erie, Pennsylvania, US | |
796671 | 796671 | 2022-10-24 | US | New York | Oneida | 36065 | 65615 | 840 | 0 | 43.24375382 | -75.43710392 | 2022-10-25 04:21:53 | Oneida, New York, US | |
3995290 | 3995290 | 2022-09-27 | US | Colorado | Pueblo | 8101 | 56573 | 840 | 0 | 38.17359144 | -104.5127437 | 2022-09-28 04:23:01 | Pueblo, Colorado, US | |
2769618 | 2769618 | 2022-09-26 | US | Colorado | Pueblo | 8101 | 56539 | 840 | 0 | 38.17359144 | -104.5127437 | 2022-09-27 04:23:01 | Pueblo, Colorado, US | |
1977271 | 1977271 | 2022-09-25 | US | Colorado | Pueblo | 8101 | 56471 | 840 | 0 | 38.17359144 | -104.5127437 | 2022-09-26 04:20:52 | Pueblo, Colorado, US | |
2650438 | 2650438 | 2022-09-24 | US | Colorado | Pueblo | 8101 | 56471 | 840 | 0 | 38.17359144 | -104.5127437 | 2022-09-25 04:23:31 | Pueblo, Colorado, US | |
384878 | 384878 | 2022-09-23 | US | Colorado | Pueblo | 8101 | 56471 | 840 | 0 | 38.17359144 | -104.5127437 | 2022-09-24 04:21:40 | Pueblo, Colorado, US | |
1624944 | 1624944 | 2022-09-22 | US | Colorado | Pueblo | 8101 | 56429 | 840 | 0 | 38.17359144 | -104.5127437 | 2022-09-23 04:23:13 | Pueblo, Colorado, US | |
3747655 | 3747655 | 2022-09-07 | US | Oklahoma | Cleveland | 40027 | 90492 | 840 | 0 | 35.20413532 | -97.32519562 | 2022-09-08 04:21:02 | Cleveland, Oklahoma, US | |
117295 | 117295 | 2022-09-06 | US | Oklahoma | Cleveland | 40027 | 90492 | 840 | 0 | 35.20413532 | -97.32519562 | 2022-09-07 04:20:59 | Cleveland, Oklahoma, US | |
2636267 | 2636267 | 2022-09-05 | US | Oklahoma | Cleveland | 40027 | 90492 | 840 | 0 | 35.20413532 | -97.32519562 | 2022-09-06 04:21:02 | Cleveland, Oklahoma, US | |
2989831 | 2989831 | 2022-09-04 | US | Oklahoma | Cleveland | 40027 | 90492 | 840 | 0 | 35.20413532 | -97.32519562 | 2022-09-05 04:21:01 | Cleveland, Oklahoma, US | |
2715516 | 2715516 | 2022-09-03 | US | Oklahoma | Cleveland | 40027 | 90492 | 840 | 0 | 35.20413532 | -97.32519562 | 2022-09-04 04:21:22 | Cleveland, Oklahoma, US | |
1396221 | 1396221 | 2022-09-02 | US | Oklahoma | Cleveland | 40027 | 90492 | 840 | 0 | 35.20413532 | -97.32519562 | 2022-09-03 04:21:04 | Cleveland, Oklahoma, US | |
3550050 | 3550050 | 2022-09-01 | US | Oklahoma | Cleveland | 40027 | 90492 | 840 | 0 | 35.20413532 | -97.32519562 | 2022-09-02 04:21:07 | Cleveland, Oklahoma, US | |
3950408 | 3950408 | 2022-08-17 | Haiti | 33017 | 840 | 0 | 18.9712 | -72.2852 | 2022-08-18 04:21:11 | Haiti | ||||
990910 | 990910 | 2022-08-16 | Haiti | 32994 | 840 | 0 | 18.9712 | -72.2852 | 2022-08-17 04:20:59 | Haiti | ||||
2493949 | 2493949 | 2022-08-15 | Haiti | 32961 | 840 | 0 | 18.9712 | -72.2852 | 2022-08-16 04:20:58 | Haiti | ||||
3647499 | 3647499 | 2022-08-14 | Haiti | 32942 | 840 | 0 | 18.9712 | -72.2852 | 2022-08-15 04:20:59 | Haiti | ||||
1968505 | 1968505 | 2022-08-13 | Haiti | 32873 | 840 | 0 | 18.9712 | -72.2852 | 2022-08-14 04:20:55 | Haiti | ||||
2888314 | 2888314 | 2022-08-12 | Haiti | 32843 | 840 | 0 | 18.9712 | -72.2852 | 2022-08-13 04:20:52 | Haiti | ||||
1086758 | 1086758 | 2022-08-09 | US | Florida | Bay | 12005 | 51239 | 840 | 0 | 30.26548745 | -85.62122584 | 2022-08-10 04:20:57 | Bay, Florida, US | |
3544173 | 3544173 | 2022-08-08 | US | Florida | Bay | 12005 | 51239 | 840 | 0 | 30.26548745 | -85.62122584 | 2022-08-09 04:20:34 | Bay, Florida, US | |
1070576 | 1070576 | 2022-08-07 | US | Florida | Bay | 12005 | 51239 | 840 | 0 | 30.26548745 | -85.62122584 | 2022-08-08 04:21:08 | Bay, Florida, US | |
1941164 | 1941164 | 2022-08-06 | US | Florida | Bay | 12005 | 51239 | 840 | 0 | 30.26548745 | -85.62122584 | 2022-08-07 04:20:54 | Bay, Florida, US | |
880963 | 880963 | 2022-08-05 | US | Florida | Bay | 12005 | 51239 | 840 | 0 | 30.26548745 | -85.62122584 | 2022-08-06 04:20:56 | Bay, Florida, US | |
2009374 | 2009374 | 2022-08-04 | US | Florida | Bay | 12005 | 51239 | 840 | 0 | 30.26548745 | -85.62122584 | 2022-08-05 04:20:52 | Bay, Florida, US | |
1098801 | 1098801 | 2022-08-03 | US | Florida | Bay | 12005 | 51239 | 840 | 0 | 30.26548745 | -85.62122584 | 2022-08-04 04:20:58 | Bay, Florida, US | |
1609327 | 1609327 | 2022-07-20 | US | Illinois | Winnebago | 17201 | 85993 | 840 | 0 | 42.33641854 | -89.16085327 | 2022-07-21 04:21:10 | Winnebago, Illinois, US | |
959960 | 959960 | 2022-07-19 | US | Illinois | Winnebago | 17201 | 85858 | 840 | 0 | 42.33641854 | -89.16085327 | 2022-07-20 04:20:59 | Winnebago, Illinois, US | |
3211347 | 3211347 | 2022-07-18 | US | Illinois | Winnebago | 17201 | 85790 | 840 | 0 | 42.33641854 | -89.16085327 | 2022-07-19 04:20:58 | Winnebago, Illinois, US | |
3943481 | 3943481 | 2022-06-30 | US | Virginia | Virginia Beach | 51810 | 97974 | 840 | 0 | 36.73285734 | -76.04566934 | 2022-07-01 04:21:10 | Virginia Beach, Virginia, US | |
2242836 | 2242836 | 2022-06-28 | US | Washington | Clark | 53011 | 97421 | 840 | 0 | 45.77568046 | -122.4829204 | 2022-06-29 04:20:59 | Clark, Washington, US | |
2151078 | 2151078 | 2022-06-27 | US | Washington | Clark | 53011 | 97421 | 840 | 0 | 45.77568046 | -122.4829204 | 2022-06-28 04:20:58 | Clark, Washington, US | |
166382 | 166382 | 2022-06-21 | Tanzania | 35354 | 840 | 0 | -6.369028 | 34.888822 | 2022-06-22 04:20:54 | Tanzania | ||||
1763665 | 1763665 | 2022-06-20 | Tanzania | 35354 | 840 | 0 | -6.369028 | 34.888822 | 2022-06-21 04:20:56 | Tanzania | ||||
3269851 | 3269851 | 2022-06-19 | Tanzania | 35354 | 840 | 0 | -6.369028 | 34.888822 | 2022-06-20 04:21:01 | Tanzania | ||||
3397763 | 3397763 | 2022-06-18 | Tanzania | 35354 | 840 | 0 | -6.369028 | 34.888822 | 2022-06-19 04:20:51 | Tanzania | ||||
2311640 | 2311640 | 2022-06-17 | Tanzania | 35354 | 840 | 0 | -6.369028 | 34.888822 | 2022-06-18 04:21:10 | Tanzania | ||||
559144 | 559144 | 2022-06-16 | Tanzania | 35354 | 840 | 0 | -6.369028 | 34.888822 | 2022-06-17 04:20:56 | Tanzania | ||||
3982946 | 3982946 | 2022-06-15 | Tanzania | 35354 | 840 | 0 | -6.369028 | 34.888822 | 2022-06-16 04:20:55 | Tanzania | ||||
947187 | 947187 | 2022-06-14 | Tanzania | 35354 | 840 | 0 | -6.369028 | 34.888822 | 2022-06-15 04:20:54 | Tanzania | ||||
2979595 | 2979595 | 2022-06-13 | Tanzania | 35354 | 840 | 0 | -6.369028 | 34.888822 | 2022-06-14 04:20:52 | Tanzania | ||||
2235721 | 2235721 | 2022-06-12 | Tanzania | 35354 | 840 | 0 | -6.369028 | 34.888822 | 2022-06-13 04:21:14 | Tanzania | ||||
3141919 | 3141919 | 2022-06-11 | Tanzania | 35354 | 840 | 0 | -6.369028 | 34.888822 | 2022-06-12 04:20:53 | Tanzania | ||||
1944835 | 1944835 | 2022-06-10 | Tanzania | 35354 | 840 | 0 | -6.369028 | 34.888822 | 2022-06-11 04:21:01 | Tanzania | ||||
3157974 | 3157974 | 2022-06-09 | Tanzania | 35354 | 840 | 0 | -6.369028 | 34.888822 | 2022-06-10 04:20:55 | Tanzania | ||||
1421441 | 1421441 | 2022-06-08 | Tanzania | 35354 | 840 | 0 | -6.369028 | 34.888822 | 2022-06-09 04:20:54 | Tanzania | ||||
3726555 | 3726555 | 2022-06-07 | Tanzania | 35354 | 840 | 0 | -6.369028 | 34.888822 | 2022-06-08 04:20:55 | Tanzania | ||||
3887957 | 3887957 | 2022-06-06 | Tanzania | 35354 | 840 | 0 | -6.369028 | 34.888822 | 2022-06-07 04:21:08 | Tanzania | ||||
3507726 | 3507726 | 2022-06-05 | Tanzania | 35354 | 840 | 0 | -6.369028 | 34.888822 | 2022-06-06 04:20:57 | Tanzania | ||||
3527803 | 3527803 | 2022-06-04 | Tanzania | 35354 | 840 | 0 | -6.369028 | 34.888822 | 2022-06-05 04:20:55 | Tanzania | ||||
3133889 | 3133889 | 2022-06-03 | Tanzania | 35354 | 840 | 0 | -6.369028 | 34.888822 | 2022-06-04 04:20:58 | Tanzania | ||||
3578964 | 3578964 | 2022-06-02 | Tanzania | 35354 | 840 | 0 | -6.369028 | 34.888822 | 2022-06-03 04:20:58 | Tanzania | ||||
971257 | 971257 | 2022-06-01 | Tanzania | 35354 | 840 | 0 | -6.369028 | 34.888822 | 2022-06-02 05:20:39 | Tanzania | ||||
229564 | 229564 | 2022-05-31 | Tanzania | 35354 | 840 | 0 | -6.369028 | 34.888822 | 2022-06-01 04:20:55 | Tanzania | ||||
3186329 | 3186329 | 2022-05-30 | Tanzania | 35354 | 840 | 0 | -6.369028 | 34.888822 | 2022-05-31 04:20:51 | Tanzania | ||||
3198478 | 3198478 | 2022-05-29 | Tanzania | 35354 | 840 | 0 | -6.369028 | 34.888822 | 2022-05-30 04:20:50 | Tanzania | ||||
2725356 | 2725356 | 2022-05-28 | Tanzania | 35354 | 840 | 0 | -6.369028 | 34.888822 | 2022-05-29 04:20:53 | Tanzania | ||||
1314537 | 1314537 | 2022-05-27 | Tanzania | 35354 | 840 | 0 | -6.369028 | 34.888822 | 2022-05-28 04:21:07 | Tanzania | ||||
1850329 | 1850329 | 2022-05-26 | Tanzania | 35354 | 840 | 0 | -6.369028 | 34.888822 | 2022-05-27 04:20:56 | Tanzania | ||||
2048205 | 2048205 | 2022-05-25 | Tanzania | 35354 | 840 | 0 | -6.369028 | 34.888822 | 2022-05-26 04:20:50 | Tanzania | ||||
2999643 | 2999643 | 2022-05-24 | Tanzania | 35354 | 840 | 0 | -6.369028 | 34.888822 | 2022-05-25 04:20:56 | Tanzania | ||||
3593364 | 3593364 | 2022-05-23 | Tanzania | 35354 | 840 | 0 | -6.369028 | 34.888822 | 2022-05-24 04:20:57 | Tanzania | ||||
622216 | 622216 | 2022-05-22 | Tanzania | 35354 | 840 | 0 | -6.369028 | 34.888822 | 2022-05-26 04:20:50 | Tanzania | ||||
1109912 | 1109912 | 2022-05-21 | Tanzania | 35354 | 840 | 0 | -6.369028 | 34.888822 | 2022-05-22 04:20:52 | Tanzania | ||||
1169536 | 1169536 | 2022-05-20 | Tanzania | 35354 | 840 | 0 | -6.369028 | 34.888822 | 2022-05-21 04:20:58 | Tanzania | ||||
3896299 | 3896299 | 2022-05-19 | Tanzania | 35354 | 840 | 0 | -6.369028 | 34.888822 | 2022-05-20 04:20:57 | Tanzania | ||||
1185083 | 1185083 | 2022-05-18 | Tanzania | 35354 | 840 | 0 | -6.369028 | 34.888822 | 2022-05-19 04:20:54 | Tanzania | ||||
3582980 | 3582980 | 2022-05-17 | Tanzania | 35354 | 840 | 0 | -6.369028 | 34.888822 | 2022-05-18 04:20:50 | Tanzania | ||||
1503937 | 1503937 | 2022-05-16 | Tanzania | 35354 | 840 | 0 | -6.369028 | 34.888822 | 2022-05-17 04:20:59 | Tanzania | ||||
2084296 | 2084296 | 2022-05-15 | Tanzania | 35354 | 840 | 0 | -6.369028 | 34.888822 | 2022-05-16 04:20:47 | Tanzania | ||||
3355006 | 3355006 | 2022-05-14 | Tanzania | 35354 | 840 | 0 | -6.369028 | 34.888822 | 2022-05-15 04:20:53 | Tanzania | ||||
658651 | 658651 | 2022-05-13 | Tanzania | 35354 | 840 | 0 | -6.369028 | 34.888822 | 2022-05-14 04:20:48 | Tanzania | ||||
2533734 | 2533734 | 2022-05-12 | Tanzania | 35354 | 840 | 0 | -6.369028 | 34.888822 | 2022-05-13 04:20:51 | Tanzania | ||||
3445180 | 3445180 | 2022-05-11 | Tanzania | 35354 | 840 | 0 | -6.369028 | 34.888822 | 2022-05-12 04:20:54 | Tanzania | ||||
3535797 | 3535797 | 2022-05-10 | Tanzania | 35354 | 840 | 0 | -6.369028 | 34.888822 | 2022-05-11 04:20:48 | Tanzania | ||||
1572952 | 1572952 | 2022-05-03 | US | Georgia | Hall | 13139 | 53500 | 840 | 0 | 34.32207823 | -83.81896936 | 2022-05-04 04:20:59 | Hall, Georgia, US | |
1572343 | 1572343 | 2022-05-03 | Russia | Kalmykia Republic | 51185 | 840 | 0 | 46.2313018 | 45.3275745 | 2022-05-04 04:20:59 | Kalmykia Republic, Russia | |||
464212 | 464212 | 2022-05-02 | US | Georgia | Hall | 13139 | 53500 | 840 | 0 | 34.32207823 | -83.81896936 | 2022-05-03 04:21:00 | Hall, Georgia, US | |
463603 | 463603 | 2022-05-02 | Russia | Kalmykia Republic | 51174 | 840 | 0 | 46.2313018 | 45.3275745 | 2022-05-03 04:21:00 | Kalmykia Republic, Russia | |||
3916851 | 3916851 | 2022-05-01 | US | Georgia | Hall | 13139 | 53500 | 840 | 0 | 34.32207823 | -83.81896936 | 2022-05-02 04:21:10 | Hall, Georgia, US | |
3916242 | 3916242 | 2022-05-01 | Russia | Kalmykia Republic | 51154 | 840 | 0 | 46.2313018 | 45.3275745 | 2022-05-02 04:21:10 | Kalmykia Republic, Russia | |||
2841655 | 2841655 | 2022-04-30 | US | Georgia | Hall | 13139 | 53500 | 840 | 0 | 34.32207823 | -83.81896936 | 2022-05-01 04:20:57 | Hall, Georgia, US | |
1157968 | 1157968 | 2022-04-29 | US | Georgia | Hall | 13139 | 53500 | 840 | 0 | 34.32207823 | -83.81896936 | 2022-04-30 04:21:05 | Hall, Georgia, 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]);