johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
127 rows where deaths = 1743 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
348141 | 348141 | 2022-12-14 | Colombia | Sucre | 67008 | 1743 | 0 | 8.814 | -74.7233 | 2022-12-15 04:20:58 | Sucre, Colombia | |||
307729 | 307729 | 2022-12-13 | Colombia | Sucre | 67008 | 1743 | 0 | 8.814 | -74.7233 | 2022-12-14 04:21:04 | Sucre, Colombia | |||
1148790 | 1148790 | 2022-12-12 | Colombia | Sucre | 67008 | 1743 | 0 | 8.814 | -74.7233 | 2022-12-13 04:21:01 | Sucre, Colombia | |||
868644 | 868644 | 2022-12-11 | Colombia | Sucre | 67008 | 1743 | 0 | 8.814 | -74.7233 | 2022-12-12 04:21:01 | Sucre, Colombia | |||
257174 | 257174 | 2022-12-10 | Colombia | Sucre | 67008 | 1743 | 0 | 8.814 | -74.7233 | 2022-12-11 04:20:50 | Sucre, Colombia | |||
3935888 | 3935888 | 2022-12-09 | Colombia | Sucre | 67008 | 1743 | 0 | 8.814 | -74.7233 | 2022-12-10 04:21:02 | Sucre, Colombia | |||
3377220 | 3377220 | 2022-12-08 | Colombia | Sucre | 67008 | 1743 | 0 | 8.814 | -74.7233 | 2022-12-09 04:21:05 | Sucre, Colombia | |||
1984491 | 1984491 | 2022-12-07 | Colombia | Sucre | 67008 | 1743 | 0 | 8.814 | -74.7233 | 2022-12-08 04:21:07 | Sucre, Colombia | |||
1620735 | 1620735 | 2022-11-22 | US | Arizona | Pinal | 4021 | 149657 | 1743 | 0 | 32.90525627 | -111.3449483 | 2022-11-23 04:21:06 | Pinal, Arizona, US | |
3460623 | 3460623 | 2022-11-21 | US | Arizona | Pinal | 4021 | 149657 | 1743 | 0 | 32.90525627 | -111.3449483 | 2022-11-22 04:20:47 | Pinal, Arizona, US | |
1640808 | 1640808 | 2022-11-20 | US | Arizona | Pinal | 4021 | 149657 | 1743 | 0 | 32.90525627 | -111.3449483 | 2022-11-21 04:21:05 | Pinal, Arizona, US | |
2064365 | 2064365 | 2022-11-19 | US | Arizona | Pinal | 4021 | 149657 | 1743 | 0 | 32.90525627 | -111.3449483 | 2022-11-20 04:21:08 | Pinal, Arizona, US | |
1755759 | 1755759 | 2022-11-18 | US | Arizona | Pinal | 4021 | 149657 | 1743 | 0 | 32.90525627 | -111.3449483 | 2022-11-19 04:21:14 | Pinal, Arizona, US | |
3026752 | 3026752 | 2022-11-17 | US | Arizona | Pinal | 4021 | 149657 | 1743 | 0 | 32.90525627 | -111.3449483 | 2022-11-18 04:21:15 | Pinal, Arizona, US | |
2486463 | 2486463 | 2022-11-16 | US | Arizona | Pinal | 4021 | 149657 | 1743 | 0 | 32.90525627 | -111.3449483 | 2022-11-17 04:21:11 | Pinal, Arizona, US | |
851851 | 851851 | 2022-11-02 | US | New York | Monroe | 36055 | 182624 | 1743 | 0 | 43.14638895 | -77.69322942 | 2022-11-03 04:22:05 | Monroe, New York, US | |
198655 | 198655 | 2022-10-19 | US | Alabama | Mobile | 1097 | 128315 | 1743 | 0 | 30.78472347 | -88.20842409 | 2022-10-20 04:22:59 | Mobile, Alabama, US | |
2757316 | 2757316 | 2022-10-18 | US | Alabama | Mobile | 1097 | 128315 | 1743 | 0 | 30.78472347 | -88.20842409 | 2022-10-19 04:22:26 | Mobile, Alabama, US | |
2025150 | 2025150 | 2022-10-17 | US | Alabama | Mobile | 1097 | 128315 | 1743 | 0 | 30.78472347 | -88.20842409 | 2022-10-18 04:22:42 | Mobile, Alabama, US | |
2159928 | 2159928 | 2022-10-16 | US | Alabama | Mobile | 1097 | 128315 | 1743 | 0 | 30.78472347 | -88.20842409 | 2022-10-17 04:20:31 | Mobile, Alabama, US | |
516125 | 516125 | 2022-10-15 | US | Alabama | Mobile | 1097 | 128315 | 1743 | 0 | 30.78472347 | -88.20842409 | 2022-10-16 04:22:39 | Mobile, Alabama, US | |
2033182 | 2033182 | 2022-10-14 | US | Alabama | Mobile | 1097 | 128315 | 1743 | 0 | 30.78472347 | -88.20842409 | 2022-10-15 04:22:00 | Mobile, Alabama, US | |
3753870 | 3753870 | 2022-10-13 | US | Alabama | Mobile | 1097 | 128315 | 1743 | 0 | 30.78472347 | -88.20842409 | 2022-10-14 04:22:28 | Mobile, Alabama, US | |
3996983 | 3996983 | 2022-09-27 | US | North Carolina | Mecklenburg | 37119 | 338477 | 1743 | 0 | 35.24469268 | -80.8317671 | 2022-09-28 04:23:01 | Mecklenburg, North Carolina, US | |
2771311 | 2771311 | 2022-09-26 | US | North Carolina | Mecklenburg | 37119 | 338477 | 1743 | 0 | 35.24469268 | -80.8317671 | 2022-09-27 04:23:01 | Mecklenburg, North Carolina, US | |
1978964 | 1978964 | 2022-09-25 | US | North Carolina | Mecklenburg | 37119 | 338477 | 1743 | 0 | 35.24469268 | -80.8317671 | 2022-09-26 04:20:52 | Mecklenburg, North Carolina, US | |
2652131 | 2652131 | 2022-09-24 | US | North Carolina | Mecklenburg | 37119 | 338477 | 1743 | 0 | 35.24469268 | -80.8317671 | 2022-09-25 04:23:31 | Mecklenburg, North Carolina, US | |
386571 | 386571 | 2022-09-23 | US | North Carolina | Mecklenburg | 37119 | 338477 | 1743 | 0 | 35.24469268 | -80.8317671 | 2022-09-24 04:21:40 | Mecklenburg, North Carolina, US | |
1626637 | 1626637 | 2022-09-22 | US | North Carolina | Mecklenburg | 37119 | 338477 | 1743 | 0 | 35.24469268 | -80.8317671 | 2022-09-23 04:23:13 | Mecklenburg, North Carolina, US | |
1372841 | 1372841 | 2022-09-21 | US | North Carolina | Mecklenburg | 37119 | 338477 | 1743 | 0 | 35.24469268 | -80.8317671 | 2022-09-22 04:22:56 | Mecklenburg, North Carolina, US | |
1348924 | 1348924 | 2022-08-10 | US | Oklahoma | Unassigned | 90040 | 12327 | 1743 | 0 | 36.83532655 | 0.0 | 2022-08-11 04:20:49 | Unassigned, Oklahoma, US | |
1088679 | 1088679 | 2022-08-09 | US | Oklahoma | Unassigned | 90040 | 12327 | 1743 | 0 | 36.83532655 | 0.0 | 2022-08-10 04:20:57 | Unassigned, Oklahoma, US | |
3546094 | 3546094 | 2022-08-08 | US | Oklahoma | Unassigned | 90040 | 9088 | 1743 | 0 | 36.83532655 | 0.0 | 2022-08-09 04:20:34 | Unassigned, Oklahoma, US | |
1072497 | 1072497 | 2022-08-07 | US | Oklahoma | Unassigned | 90040 | 4528 | 1743 | 0 | 36.83532655 | 0.0 | 2022-08-08 04:21:08 | Unassigned, Oklahoma, US | |
1943085 | 1943085 | 2022-08-06 | US | Oklahoma | Unassigned | 90040 | 4528 | 1743 | 0 | 36.83532655 | 0.0 | 2022-08-07 04:20:54 | Unassigned, Oklahoma, US | |
882884 | 882884 | 2022-08-05 | US | Oklahoma | Unassigned | 90040 | 4528 | 1743 | 0 | 36.83532655 | 0.0 | 2022-08-06 04:20:56 | Unassigned, Oklahoma, US | |
2011295 | 2011295 | 2022-08-04 | US | Oklahoma | Unassigned | 90040 | 4528 | 1743 | 0 | 36.83532655 | 0.0 | 2022-08-05 04:20:52 | Unassigned, Oklahoma, US | |
2596550 | 2596550 | 2022-07-25 | US | Ohio | Summit | 39153 | 123691 | 1743 | 0 | 41.12464734 | -81.53123079 | 2022-07-26 04:20:58 | Summit, Ohio, US | |
898665 | 898665 | 2022-07-24 | US | Ohio | Summit | 39153 | 123691 | 1743 | 0 | 41.12464734 | -81.53123079 | 2022-07-25 04:20:51 | Summit, Ohio, US | |
93659 | 93659 | 2022-07-23 | US | Ohio | Summit | 39153 | 123691 | 1743 | 0 | 41.12464734 | -81.53123079 | 2022-07-24 04:20:47 | Summit, Ohio, US | |
902681 | 902681 | 2022-07-22 | US | Ohio | Summit | 39153 | 123691 | 1743 | 0 | 41.12464734 | -81.53123079 | 2022-07-23 04:20:53 | Summit, Ohio, US | |
672817 | 672817 | 2022-07-21 | US | Ohio | Summit | 39153 | 123691 | 1743 | 0 | 41.12464734 | -81.53123079 | 2022-07-22 04:21:15 | Summit, Ohio, US | |
1610780 | 1610780 | 2022-07-20 | US | Ohio | Summit | 39153 | 122758 | 1743 | 0 | 41.12464734 | -81.53123079 | 2022-07-21 04:21:10 | Summit, Ohio, US | |
1610779 | 1610779 | 2022-07-20 | US | Ohio | Stark | 39151 | 85007 | 1743 | 0 | 40.81482476 | -81.36437305 | 2022-07-21 04:21:10 | Stark, Ohio, US | |
1608327 | 1608327 | 2022-07-20 | Malaysia | Sarawak | 308967 | 1743 | 0 | 1.5533 | 110.3592 | 2022-07-21 04:21:10 | Sarawak, Malaysia | |||
961413 | 961413 | 2022-07-19 | US | Ohio | Summit | 39153 | 122758 | 1743 | 0 | 41.12464734 | -81.53123079 | 2022-07-20 04:20:59 | Summit, Ohio, US | |
958960 | 958960 | 2022-07-19 | Malaysia | Sarawak | 308882 | 1743 | 0 | 1.5533 | 110.3592 | 2022-07-20 04:20:59 | Sarawak, Malaysia | |||
3212800 | 3212800 | 2022-07-18 | US | Ohio | Summit | 39153 | 122758 | 1743 | 0 | 41.12464734 | -81.53123079 | 2022-07-19 04:20:58 | Summit, Ohio, US | |
3210347 | 3210347 | 2022-07-18 | Malaysia | Sarawak | 308776 | 1743 | 0 | 1.5533 | 110.3592 | 2022-07-19 04:20:58 | Sarawak, Malaysia | |||
3210185 | 3210185 | 2022-07-18 | Germany | Saarland | 364073 | 1743 | 0 | 49.3964 | 7.023 | 2022-07-19 04:20:58 | Saarland, Germany | |||
3405522 | 3405522 | 2022-07-17 | Malaysia | Sarawak | 308737 | 1743 | 0 | 1.5533 | 110.3592 | 2022-07-18 04:20:59 | Sarawak, Malaysia | |||
2151722 | 2151722 | 2022-07-16 | Malaysia | Sarawak | 308699 | 1743 | 0 | 1.5533 | 110.3592 | 2022-07-17 04:21:15 | Sarawak, Malaysia | |||
2418955 | 2418955 | 2022-07-15 | Malaysia | Sarawak | 308625 | 1743 | 0 | 1.5533 | 110.3592 | 2022-07-16 04:21:05 | Sarawak, Malaysia | |||
3429030 | 3429030 | 2022-07-14 | Malaysia | Sarawak | 308557 | 1743 | 0 | 1.5533 | 110.3592 | 2022-07-15 04:20:53 | Sarawak, Malaysia | |||
1651617 | 1651617 | 2022-06-23 | US | Texas | Travis | 48453 | 268767 | 1743 | 0 | 30.33432034 | -97.7853562 | 2022-06-24 04:20:58 | Travis, Texas, US | |
2190852 | 2190852 | 2022-06-22 | US | Texas | Travis | 48453 | 268133 | 1743 | 0 | 30.33432034 | -97.7853562 | 2022-06-23 04:20:55 | Travis, Texas, US | |
169283 | 169283 | 2022-06-21 | US | Texas | Travis | 48453 | 266579 | 1743 | 0 | 30.33432034 | -97.7853562 | 2022-06-22 04:20:54 | Travis, Texas, US | |
1766566 | 1766566 | 2022-06-20 | US | Texas | Travis | 48453 | 265966 | 1743 | 0 | 30.33432034 | -97.7853562 | 2022-06-21 04:20:56 | Travis, Texas, US | |
2048161 | 2048161 | 2022-05-25 | Spain | Canarias | 367712 | 1743 | 0 | 28.2916 | -16.6291 | 2022-05-26 04:20:50 | Canarias, Spain | |||
2999599 | 2999599 | 2022-05-24 | Spain | Canarias | 367712 | 1743 | 0 | 28.2916 | -16.6291 | 2022-05-25 04:20:56 | Canarias, Spain | |||
3593320 | 3593320 | 2022-05-23 | Spain | Canarias | 367712 | 1743 | 0 | 28.2916 | -16.6291 | 2022-05-24 04:20:57 | Canarias, Spain | |||
622172 | 622172 | 2022-05-22 | Spain | Canarias | 367712 | 1743 | 0 | 28.2916 | -16.6291 | 2022-05-26 04:20:50 | Canarias, Spain | |||
1109868 | 1109868 | 2022-05-21 | Spain | Canarias | 367712 | 1743 | 0 | 28.2916 | -16.6291 | 2022-05-22 04:20:52 | Canarias, Spain | |||
877044 | 877044 | 2022-03-27 | US | Georgia | Cobb | 13067 | 170482 | 1743 | 0 | 33.94243204 | -84.5761255 | 2022-03-28 04:20:33 | Cobb, Georgia, US | |
2164327 | 2164327 | 2022-03-26 | US | Georgia | Cobb | 13067 | 170482 | 1743 | 0 | 33.94243204 | -84.5761255 | 2022-03-27 04:20:47 | Cobb, Georgia, US | |
1721263 | 1721263 | 2022-03-25 | US | Georgia | Cobb | 13067 | 170482 | 1743 | 0 | 33.94243204 | -84.5761255 | 2022-03-26 04:20:23 | Cobb, Georgia, US | |
2199413 | 2199413 | 2022-03-06 | Chile | Los Lagos | 176072 | 1743 | 0 | -41.9198 | -72.1416 | 2022-03-07 04:20:47 | Los Lagos, Chile | |||
2733229 | 2733229 | 2022-02-27 | Russia | Kabardino-Balkarian Republic | 57027 | 1743 | 0 | 43.480604799999995 | 43.5978976 | 2022-02-28 04:21:05 | Kabardino-Balkarian Republic, Russia | |||
1300220 | 1300220 | 2022-02-17 | US | New Jersey | Camden | 34007 | 123487 | 1743 | 0 | 39.80343818 | -74.96388753 | 2022-02-18 04:21:04 | Camden, New Jersey, US | |
1298866 | 1298866 | 2022-02-17 | US | Georgia | Gwinnett | 13135 | 203812 | 1743 | 0 | 33.96044201 | -84.02137802 | 2022-02-18 04:21:04 | Gwinnett, Georgia, US | |
2641434 | 2641434 | 2022-02-14 | Australia | New South Wales | 1212157 | 1743 | 0 | -33.8688 | 151.2093 | 2022-02-15 04:21:09 | New South Wales, Australia | |||
3073872 | 3073872 | 2022-02-09 | Colombia | Cauca | 71329 | 1743 | 0 | 2.705 | -76.82600000000002 | 2022-02-10 04:21:14 | Cauca, Colombia | |||
3464141 | 3464141 | 2022-01-18 | Italy | Calabria | 149624 | 1743 | 0 | 38.90597598 | 16.59440194 | 2022-01-19 04:21:23 | Calabria, Italy | |||
1283587 | 1283587 | 2022-01-05 | US | Massachusetts | Bristol | 25005 | 112251 | 1743 | 0 | 41.79228404 | -71.10872211 | 2022-01-06 04:22:09 | Bristol, Massachusetts, US | |
3816097 | 3816097 | 2021-12-23 | Angola | 68362 | 1743 | 0 | -11.2027 | 17.8739 | 2021-12-24 04:21:34 | Angola | ||||
2399062 | 2399062 | 2021-12-17 | Russia | Sakha (Yakutiya) Republic | 74429 | 1743 | 0 | 66.941626 | 129.642371 | 2021-12-18 02:22:20 | Sakha (Yakutiya) Republic, Russia | |||
3499755 | 3499755 | 2021-12-15 | US | Wisconsin | Milwaukee | 55079 | 169371 | 1743 | 0 | 43.00486062 | -87.96733172 | 2021-12-16 04:22:11 | Milwaukee, Wisconsin, US | |
163614 | 163614 | 2021-11-19 | US | Maryland | Prince George's | 24033 | 101218 | 1743 | 0 | 38.83070039 | -76.8496441 | 2021-11-20 04:22:17 | Prince George's, Maryland, US | |
3125131 | 3125131 | 2021-11-05 | Ukraine | Cherkasy Oblast | 104620 | 1743 | 0 | 49.4444 | 32.0598 | 2021-11-06 04:21:51 | Cherkasy Oblast, Ukraine | |||
3511530 | 3511530 | 2021-11-01 | Netherlands | Limburg | 145403 | 1743 | 0 | 51.209227 | 5.93387 | 2021-11-02 04:22:03 | Limburg, Netherlands | |||
6521 | 6521 | 2021-10-28 | US | New Jersey | Monmouth | 34025 | 92322 | 1743 | 0 | 40.26549699 | -74.22240686 | 2021-10-29 04:22:03 | Monmouth, New Jersey, US | |
494099 | 494099 | 2021-10-14 | US | Ohio | Franklin | 39049 | 161654 | 1743 | 0 | 39.96995815 | -83.01115755 | 2021-10-15 04:21:26 | Franklin, Ohio, US | |
633764 | 633764 | 2021-10-13 | Colombia | Quindio | 56415 | 1743 | 0 | 4.461 | -75.6674 | 2021-10-14 04:21:29 | Quindio, Colombia | |||
423541 | 423541 | 2021-10-10 | Russia | Astrakhan Oblast | 61242 | 1743 | 0 | 47.1878186 | 47.608851 | 2021-10-11 04:21:31 | Astrakhan Oblast, Russia | |||
2959597 | 2959597 | 2021-10-08 | Russia | Lipetsk Oblast | 55000 | 1743 | 0 | 52.693517799999995 | 39.112266399999996 | 2021-10-09 04:21:34 | Lipetsk Oblast, Russia | |||
990651 | 990651 | 2021-10-04 | Yemen | 9214 | 1743 | 0 | 15.552726999999999 | 48.516388 | 2021-10-05 04:21:27 | Yemen | ||||
3928291 | 3928291 | 2021-10-02 | Russia | Smolensk Oblast | 50419 | 1743 | 0 | 55.03434960000001 | 33.0192065 | 2021-10-03 04:21:24 | Smolensk Oblast, Russia | |||
1376061 | 1376061 | 2021-09-15 | US | Maryland | Baltimore | 24005 | 71597 | 1743 | 0 | 39.45784712 | -76.62911955 | 2021-09-16 04:22:19 | Baltimore, Maryland, US | |
2464360 | 2464360 | 2021-09-14 | US | Maryland | Baltimore | 24005 | 71444 | 1743 | 0 | 39.45784712 | -76.62911955 | 2021-09-15 03:22:37 | Baltimore, Maryland, US | |
2071345 | 2071345 | 2021-08-31 | US | Washington | King | 53033 | 135541 | 1743 | 0 | 47.49137892 | -121.8346131 | 2021-09-01 04:21:38 | King, Washington, US | |
1853782 | 1853782 | 2021-08-20 | Chile | Maule | 100703 | 1743 | 0 | -35.5183 | -71.6885 | 2021-08-21 04:21:38 | Maule, Chile | |||
1440842 | 1440842 | 2021-07-07 | Russia | Ulyanovsk Oblast | 59864 | 1743 | 57050 | 1071 | 54.1463177 | 47.2324921 | 2021-07-08 04:21:26 | Ulyanovsk Oblast, Russia | ||
2422728 | 2422728 | 2021-06-23 | Colombia | Caldas | 85312 | 1743 | 80364 | 3205 | 5.2983 | -75.2479 | 2021-06-24 04:21:55 | Caldas, Colombia | ||
562731 | 562731 | 2021-06-22 | Canada | British Columbia | 147187 | 1743 | 144263 | 1181 | 53.7267 | -127.6476 | 2021-06-23 04:21:46 | British Columbia, Canada | ||
3358433 | 3358433 | 2021-06-21 | Canada | British Columbia | 147131 | 1743 | 144153 | 1235 | 53.7267 | -127.6476 | 2021-06-22 04:21:34 | British Columbia, Canada | ||
3472470 | 3472470 | 2021-06-08 | Peru | Tacna | 25961 | 1743 | 0 | 24218 | -17.644160999999997 | -70.27756 | 2021-06-09 04:23:31 | Tacna, Peru | ||
3145900 | 3145900 | 2021-06-07 | Sweden | Skane | 154791 | 1743 | 0 | 153048 | 55.9903 | 13.5958 | 2021-06-08 04:22:35 | Skane, Sweden | ||
3145754 | 3145754 | 2021-06-07 | Peru | Tacna | 25961 | 1743 | 0 | 24218 | -17.644160999999997 | -70.27756 | 2021-06-08 04:22:35 | Tacna, Peru | ||
825902 | 825902 | 2021-06-06 | Sweden | Skane | 154791 | 1743 | 0 | 153048 | 55.9903 | 13.5958 | 2021-06-07 04:22:51 | Skane, Sweden | ||
2586307 | 2586307 | 2021-06-05 | Sweden | Skane | 154791 | 1743 | 0 | 153048 | 55.9903 | 13.5958 | 2021-06-06 04:24:03 | Skane, Sweden |
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]);