johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
52 rows where deaths = 2812 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3379552 | 3379552 | 2022-12-08 | US | New Jersey | Hudson | 34017 | 225072 | 2812 | 0 | 40.73766234 | -74.07515667 | 2022-12-09 04:21:05 | Hudson, New Jersey, US | |
1986823 | 1986823 | 2022-12-07 | US | New Jersey | Hudson | 34017 | 224855 | 2812 | 0 | 40.73766234 | -74.07515667 | 2022-12-08 04:21:07 | Hudson, New Jersey, US | |
3716346 | 3716346 | 2022-12-06 | US | New Jersey | Hudson | 34017 | 224494 | 2812 | 0 | 40.73766234 | -74.07515667 | 2022-12-07 04:20:58 | Hudson, New Jersey, US | |
3988910 | 3988910 | 2022-09-15 | US | New York | Westchester | 36119 | 302271 | 2812 | 0 | 41.16278376 | -73.75741653 | 2022-09-16 04:21:19 | Westchester, New York, US | |
1891427 | 1891427 | 2022-09-14 | US | New York | Westchester | 36119 | 302271 | 2812 | 0 | 41.16278376 | -73.75741653 | 2022-09-15 04:21:02 | Westchester, New York, US | |
3773812 | 3773812 | 2022-08-30 | Germany | Schleswig-Holstein | 979380 | 2812 | 0 | 54.2194 | 9.6961 | 2022-08-31 04:20:57 | Schleswig-Holstein, Germany | |||
2239525 | 2239525 | 2022-06-28 | Netherlands | Gelderland | 995451 | 2812 | 0 | 52.061738 | 5.939114 | 2022-06-29 04:20:59 | Gelderland, Netherlands | |||
1648646 | 1648646 | 2022-06-23 | Russia | Yaroslavl Oblast | 162915 | 2812 | 0 | 57.7781976 | 39.0021095 | 2022-06-24 04:20:58 | Yaroslavl Oblast, Russia | |||
2189214 | 2189214 | 2022-06-22 | US | Massachusetts | Essex | 25009 | 223964 | 2812 | 0 | 42.6687626 | -70.94687179 | 2022-06-23 04:20:55 | Essex, Massachusetts, US | |
1224267 | 1224267 | 2022-04-14 | US | Connecticut | New Haven | 9009 | 196954 | 2812 | 0 | 41.408032500000004 | -72.93620426 | 2022-04-15 04:20:57 | New Haven, Connecticut, US | |
1223666 | 1223666 | 2022-04-14 | Malaysia | W.P. Kuala Lumpur | 339910 | 2812 | 0 | 3.139 | 101.6869 | 2022-04-15 04:20:57 | W.P. Kuala Lumpur, Malaysia | |||
2443425 | 2443425 | 2022-04-13 | US | Connecticut | New Haven | 9009 | 196791 | 2812 | 0 | 41.408032500000004 | -72.93620426 | 2022-04-13 23:21:06 | New Haven, Connecticut, US | |
2442824 | 2442824 | 2022-04-13 | Malaysia | W.P. Kuala Lumpur | 339022 | 2812 | 0 | 3.139 | 101.6869 | 2022-04-13 23:21:06 | W.P. Kuala Lumpur, Malaysia | |||
1949182 | 1949182 | 2022-04-12 | US | Connecticut | New Haven | 9009 | 196585 | 2812 | 0 | 41.408032500000004 | -72.93620426 | 2022-04-13 04:21:03 | New Haven, Connecticut, US | |
943947 | 943947 | 2022-02-28 | US | Indiana | Marion | 18097 | 223235 | 2812 | 0 | 39.78163624 | -86.13826325 | 2022-03-01 04:21:09 | Marion, Indiana, US | |
575023 | 575023 | 2022-02-25 | Russia | Astrakhan Oblast | 107971 | 2812 | 0 | 47.1878186 | 47.608851 | 2022-02-26 04:21:12 | Astrakhan Oblast, Russia | |||
1511603 | 1511603 | 2022-02-24 | Russia | Buryatia Republic | 119214 | 2812 | 0 | 52.718242599999996 | 109.492143 | 2022-02-25 04:21:11 | Buryatia Republic, Russia | |||
3718388 | 3718388 | 2022-02-21 | Russia | Ivanovo Oblast | 88936 | 2812 | 0 | 56.9167446 | 41.43521370000001 | 2022-02-22 04:21:01 | Ivanovo Oblast, Russia | |||
2016331 | 2016331 | 2022-02-06 | Ukraine | Cherkasy Oblast | 144128 | 2812 | 0 | 49.4444 | 32.0598 | 2022-02-07 04:21:05 | Cherkasy Oblast, Ukraine | |||
3226514 | 3226514 | 2022-01-19 | Malaysia | Sabah | 244823 | 2812 | 0 | 5.9788 | 116.0753 | 2022-01-20 04:21:07 | Sabah, Malaysia | |||
2167786 | 2167786 | 2022-01-01 | Russia | Lipetsk Oblast | 84103 | 2812 | 0 | 52.693517799999995 | 39.112266399999996 | 2022-01-02 04:20:52 | Lipetsk Oblast, Russia | |||
2111893 | 2111893 | 2021-12-26 | Russia | Bryansk Oblast | 95468 | 2812 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-12-27 04:21:58 | Bryansk Oblast, Russia | |||
150219 | 150219 | 2021-11-29 | Russia | Omsk Oblast | 113989 | 2812 | 0 | 56.09352629999999 | 73.5099936 | 2021-11-30 04:22:53 | Omsk Oblast, Russia | |||
3071688 | 3071688 | 2021-11-23 | US | Michigan | Macomb | 26099 | 135395 | 2812 | 0 | 42.69158356 | -82.92752801 | 2021-11-24 04:22:14 | Macomb, Michigan, US | |
3750786 | 3750786 | 2021-11-22 | US | Michigan | Macomb | 26099 | 135395 | 2812 | 0 | 42.69158356 | -82.92752801 | 2021-11-23 04:22:39 | Macomb, Michigan, US | |
162156 | 162156 | 2021-11-19 | Netherlands | Noord-Holland | 401251 | 2812 | 0 | 52.60090600000001 | 4.9186879999999995 | 2021-11-20 04:22:17 | Noord-Holland, Netherlands | |||
2845054 | 2845054 | 2021-11-10 | Russia | Dagestan Republic | 57639 | 2812 | 0 | 43.05749160000001 | 47.1332224 | 2021-11-11 04:21:45 | Dagestan Republic, Russia | |||
2518061 | 2518061 | 2021-08-18 | El Salvador | 92135 | 2812 | 0 | 13.7942 | -88.8965 | 2021-08-19 04:21:15 | El Salvador | ||||
2355056 | 2355056 | 2021-08-10 | Uganda | 95955 | 2812 | 0 | 1.373333 | 32.290275 | 2021-08-11 04:21:58 | Uganda | ||||
3218134 | 3218134 | 2021-07-26 | Colombia | Bolivar | 149208 | 2812 | 144603 | 1793 | 8.6704 | -74.03 | 2021-07-27 04:21:18 | Bolivar, Colombia | ||
522964 | 522964 | 2021-06-09 | Mexico | Zacatecas | 30857 | 2812 | 0 | 28045 | 22.7709 | -102.5832 | 2021-06-10 04:23:17 | Zacatecas, Mexico | ||
1412744 | 1412744 | 2021-05-24 | Afghanistan | 66275 | 2812 | 56295 | 7168 | 33.93911 | 67.709953 | 2021-05-25 04:21:08 | Afghanistan | |||
890277 | 890277 | 2021-04-26 | US | New Jersey | Bergen | 34003 | 100215 | 2812 | 0 | 40.96010917 | -74.07164325 | 2021-04-27 04:20:52 | Bergen, New Jersey, US | |
957022 | 957022 | 2021-04-25 | US | New Jersey | Bergen | 34003 | 100210 | 2812 | 0 | 40.96010917 | -74.07164325 | 2021-04-26 04:21:04 | Bergen, New Jersey, US | |
609354 | 609354 | 2021-04-09 | West Bank and Gaza | 264395 | 2812 | 229876 | 31707 | 31.9522 | 35.2332 | 2021-04-10 04:20:59 | West Bank and Gaza | |||
605936 | 605936 | 2021-04-09 | Russia | Sverdlovsk Oblast | 83704 | 2812 | 77150 | 3742 | 58.6414755 | 61.8021546 | 2021-04-10 04:20:59 | Sverdlovsk Oblast, Russia | ||
998308 | 998308 | 2021-03-01 | Costa Rica | 205086 | 2812 | 181851 | 20423 | 9.7489 | -83.7534 | 2021-03-02 05:23:30 | Costa Rica | |||
283198 | 283198 | 2021-02-24 | US | Texas | Bexar | 48029 | 198540 | 2812 | 0 | 191520 | 29.44928723 | -98.52019748 | 2021-02-25 05:24:57 | Bexar, Texas, US |
2285665 | 2285665 | 2021-02-14 | US | New York | Nassau | 36059 | 139516 | 2812 | 0 | 136704 | 40.74066522 | -73.58941873 | 2021-02-15 05:24:49 | Nassau, New York, US |
975483 | 975483 | 2021-02-06 | US | California | San Diego | 6073 | 257505 | 2812 | 0 | 254693 | 33.03484597 | -116.7365326 | 2021-02-07 05:23:00 | San Diego, California, US |
3153770 | 3153770 | 2021-01-27 | Peru | Loreto | 26986 | 2812 | 0 | 24174 | -4.124847 | -74.424115 | 2021-01-28 05:22:24 | Loreto, Peru | ||
12477 | 12477 | 2021-01-26 | North Macedonia | 91161 | 2812 | 79621 | 8728 | 41.6086 | 21.7453 | 2021-01-27 05:23:41 | North Macedonia | |||
2426643 | 2426643 | 2021-01-23 | Brazil | Mato Grosso do Sul | 156459 | 2812 | 140908 | 12270 | -20.7722 | -54.7852 | 2021-01-24 05:22:35 | Mato Grosso do Sul, Brazil | ||
189759 | 189759 | 2021-01-11 | Algeria | 102369 | 2812 | 69403 | 30154 | 28.0339 | 1.6596 | 2021-01-12 05:22:15 | Algeria | |||
153742 | 153742 | 2021-01-08 | Burma | 129483 | 2812 | 112876 | 13795 | 21.9162 | 95.956 | 2021-01-09 05:22:18 | Burma | |||
1010286 | 1010286 | 2020-12-30 | Italy | Campania | 188119 | 2812 | 107696 | 77611 | 40.83956555 | 14.25084984 | 2020-12-31 05:22:49 | Campania, Italy | ||
74817 | 74817 | 2020-12-03 | Bosnia and Herzegovina | 91539 | 2812 | 56050 | 32677 | 43.9159 | 17.6791 | 2020-12-04 05:27:27 | Bosnia and Herzegovina | |||
666376 | 666376 | 2020-09-16 | Mexico | Sonora | 23445 | 2812 | 19939 | 694 | 29.2972 | -110.3309 | 2020-09-17 04:22:00 | Sonora, Mexico | ||
1354093 | 1354093 | 2020-09-03 | Canada | Ontario | 43488 | 2812 | 40456 | 1405 | 51.2538 | -85.3232 | 2020-09-04 04:28:26 | Ontario, Canada | ||
1105330 | 1105330 | 2020-09-02 | Canada | Ontario | 43314 | 2812 | 40321 | 1393 | 51.2538 | -85.3232 | 2020-09-03 04:28:22 | Ontario, Canada | ||
2059659 | 2059659 | 2020-09-01 | Canada | Ontario | 43164 | 2812 | 40192 | 1368 | 51.2538 | -85.3232 | 2020-09-02 04:28:25 | Ontario, Canada | ||
2991559 | 2991559 | 2020-08-24 | Spain | Castilla y Leon | 25451 | 2812 | 8716 | 13923 | 41.8357 | -4.3976 | 2020-08-25 04:28:02 | Castilla y Leon, Spain |
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]);