johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
117 rows where deaths = 1802 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 20
- US 64
- Russia 7
- Ukraine 7
- Brazil 5
- India 5
- Chile 4
- Switzerland 4
- Germany 3
- Ireland 3
- Mexico 3
- Japan 2
- Peru 2
- Canada 1
- Colombia 1
- Korea, South 1
- Libya 1
- Saudi Arabia 1
- Spain 1
- United Arab Emirates 1
- Yemen 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
330843 | 330843 | 2022-12-27 | US | Tennessee | Davidson | 47037 | 229589 | 1802 | 0 | 36.17007426 | -86.78646056 | 2022-12-28 04:21:04 | Davidson, Tennessee, US | |
330158 | 330158 | 2022-12-27 | US | New York | Monroe | 36055 | 187402 | 1802 | 0 | 43.14638895 | -77.69322942 | 2022-12-28 04:21:04 | Monroe, New York, US | |
220916 | 220916 | 2022-12-26 | US | Tennessee | Davidson | 47037 | 229589 | 1802 | 0 | 36.17007426 | -86.78646056 | 2022-12-27 04:21:07 | Davidson, Tennessee, US | |
220231 | 220231 | 2022-12-26 | US | New York | Monroe | 36055 | 187358 | 1802 | 0 | 43.14638895 | -77.69322942 | 2022-12-27 04:21:07 | Monroe, New York, US | |
3225373 | 3225373 | 2022-12-25 | US | Tennessee | Davidson | 47037 | 229589 | 1802 | 0 | 36.17007426 | -86.78646056 | 2022-12-26 04:21:06 | Davidson, Tennessee, US | |
3224688 | 3224688 | 2022-12-25 | US | New York | Monroe | 36055 | 187309 | 1802 | 0 | 43.14638895 | -77.69322942 | 2022-12-26 04:21:06 | Monroe, New York, US | |
1021287 | 1021287 | 2022-12-24 | US | Tennessee | Davidson | 47037 | 229589 | 1802 | 0 | 36.17007426 | -86.78646056 | 2022-12-25 04:21:04 | Davidson, Tennessee, US | |
1020602 | 1020602 | 2022-12-24 | US | New York | Monroe | 36055 | 187214 | 1802 | 0 | 43.14638895 | -77.69322942 | 2022-12-25 04:21:04 | Monroe, New York, US | |
693310 | 693310 | 2022-12-23 | US | Tennessee | Davidson | 47037 | 229561 | 1802 | 0 | 36.17007426 | -86.78646056 | 2022-12-24 04:21:02 | Davidson, Tennessee, US | |
692625 | 692625 | 2022-12-23 | US | New York | Monroe | 36055 | 187096 | 1802 | 0 | 43.14638895 | -77.69322942 | 2022-12-24 04:21:02 | Monroe, New York, US | |
2182520 | 2182520 | 2022-12-22 | US | Tennessee | Davidson | 47037 | 229430 | 1802 | 0 | 36.17007426 | -86.78646056 | 2022-12-23 04:21:04 | Davidson, Tennessee, US | |
2181835 | 2181835 | 2022-12-22 | US | New York | Monroe | 36055 | 186913 | 1802 | 0 | 43.14638895 | -77.69322942 | 2022-12-23 04:21:04 | Monroe, New York, US | |
454324 | 454324 | 2022-12-21 | US | Tennessee | Davidson | 47037 | 229319 | 1802 | 0 | 36.17007426 | -86.78646056 | 2022-12-22 04:20:56 | Davidson, Tennessee, US | |
453639 | 453639 | 2022-12-21 | US | New York | Monroe | 36055 | 186757 | 1802 | 0 | 43.14638895 | -77.69322942 | 2022-12-22 04:20:56 | Monroe, New York, US | |
2954323 | 2954323 | 2022-12-20 | US | Tennessee | Davidson | 47037 | 229202 | 1802 | 0 | 36.17007426 | -86.78646056 | 2022-12-21 04:21:03 | Davidson, Tennessee, US | |
3176725 | 3176725 | 2022-12-19 | US | Tennessee | Davidson | 47037 | 229028 | 1802 | 0 | 36.17007426 | -86.78646056 | 2022-12-20 04:21:04 | Davidson, Tennessee, US | |
433878 | 433878 | 2022-11-03 | US | Ohio | Summit | 39153 | 134550 | 1802 | 0 | 41.12464734 | -81.53123079 | 2022-11-04 04:22:11 | Summit, Ohio, US | |
323174 | 323174 | 2022-10-30 | US | Texas | Travis | 48453 | 314762 | 1802 | 0 | 30.33432034 | -97.7853562 | 2022-10-31 04:21:36 | Travis, Texas, US | |
915450 | 915450 | 2022-10-29 | US | Texas | Travis | 48453 | 314762 | 1802 | 0 | 30.33432034 | -97.7853562 | 2022-10-30 04:22:14 | Travis, Texas, US | |
1369719 | 1369719 | 2022-10-28 | US | Texas | Travis | 48453 | 314762 | 1802 | 0 | 30.33432034 | -97.7853562 | 2022-10-29 04:21:13 | Travis, Texas, US | |
3214921 | 3214921 | 2022-10-12 | US | Colorado | El Paso | 8041 | 222980 | 1802 | 0 | 38.83240149 | -104.5251411 | 2022-10-13 04:22:39 | El Paso, Colorado, US | |
2395537 | 2395537 | 2022-09-12 | US | Florida | Sarasota | 12115 | 113515 | 1802 | 0 | 27.18546175 | -82.33174248 | 2022-09-13 04:20:57 | Sarasota, Florida, US | |
3766615 | 3766615 | 2022-09-11 | US | Florida | Sarasota | 12115 | 113515 | 1802 | 0 | 27.18546175 | -82.33174248 | 2022-09-12 04:20:58 | Sarasota, Florida, US | |
3825190 | 3825190 | 2022-09-10 | US | Florida | Sarasota | 12115 | 113515 | 1802 | 0 | 27.18546175 | -82.33174248 | 2022-09-11 04:20:50 | Sarasota, Florida, US | |
963647 | 963647 | 2022-09-09 | US | Florida | Sarasota | 12115 | 113515 | 1802 | 0 | 27.18546175 | -82.33174248 | 2022-09-10 04:21:10 | Sarasota, Florida, US | |
254049 | 254049 | 2022-09-08 | US | Florida | Sarasota | 12115 | 112292 | 1802 | 0 | 27.18546175 | -82.33174248 | 2022-09-09 04:21:11 | Sarasota, Florida, US | |
3745847 | 3745847 | 2022-09-07 | US | Florida | Sarasota | 12115 | 112292 | 1802 | 0 | 27.18546175 | -82.33174248 | 2022-09-08 04:21:02 | Sarasota, Florida, US | |
115487 | 115487 | 2022-09-06 | US | Florida | Sarasota | 12115 | 112292 | 1802 | 0 | 27.18546175 | -82.33174248 | 2022-09-07 04:20:59 | Sarasota, Florida, US | |
1531700 | 1531700 | 2022-08-26 | Chile | Coquimbo | 180376 | 1802 | 0 | -29.959 | -71.3389 | 2022-08-27 04:20:57 | Coquimbo, Chile | |||
1968609 | 1968609 | 2022-08-13 | Japan | Saitama | 908370 | 1802 | 0 | 35.997101 | 139.347635 | 2022-08-14 04:20:55 | Saitama, Japan | |||
2595668 | 2595668 | 2022-07-25 | US | Michigan | Genesee | 26049 | 110122 | 1802 | 0 | 43.02244215 | -83.70589709 | 2022-07-26 04:20:58 | Genesee, Michigan, US | |
897783 | 897783 | 2022-07-24 | US | Michigan | Genesee | 26049 | 110122 | 1802 | 0 | 43.02244215 | -83.70589709 | 2022-07-25 04:20:51 | Genesee, Michigan, US | |
92777 | 92777 | 2022-07-23 | US | Michigan | Genesee | 26049 | 110122 | 1802 | 0 | 43.02244215 | -83.70589709 | 2022-07-24 04:20:47 | Genesee, Michigan, US | |
901799 | 901799 | 2022-07-22 | US | Michigan | Genesee | 26049 | 110122 | 1802 | 0 | 43.02244215 | -83.70589709 | 2022-07-23 04:20:53 | Genesee, Michigan, US | |
671935 | 671935 | 2022-07-21 | US | Michigan | Genesee | 26049 | 110122 | 1802 | 0 | 43.02244215 | -83.70589709 | 2022-07-22 04:21:15 | Genesee, Michigan, US | |
1609898 | 1609898 | 2022-07-20 | US | Michigan | Genesee | 26049 | 110122 | 1802 | 0 | 43.02244215 | -83.70589709 | 2022-07-21 04:21:10 | Genesee, Michigan, US | |
960531 | 960531 | 2022-07-19 | US | Michigan | Genesee | 26049 | 110122 | 1802 | 0 | 43.02244215 | -83.70589709 | 2022-07-20 04:20:59 | Genesee, Michigan, US | |
2741000 | 2741000 | 2022-07-07 | Japan | Chiba | 473000 | 1802 | 0 | 35.510141 | 140.198917 | 2022-07-08 04:20:56 | Chiba, Japan | |||
560381 | 560381 | 2022-06-16 | US | Maryland | Baltimore City | 24510 | 123549 | 1802 | 0 | 39.30211911 | -76.61151012 | 2022-06-17 04:20:56 | Baltimore City, Maryland, US | |
3446445 | 3446445 | 2022-05-11 | US | Massachusetts | Hampden | 25013 | 138220 | 1802 | 0 | 42.13440424 | -72.63235561 | 2022-05-12 04:20:54 | Hampden, Massachusetts, US | |
3537062 | 3537062 | 2022-05-10 | US | Massachusetts | Hampden | 25013 | 137917 | 1802 | 0 | 42.13440424 | -72.63235561 | 2022-05-11 04:20:48 | Hampden, Massachusetts, US | |
2332982 | 2332982 | 2022-05-08 | US | Massachusetts | Hampden | 25013 | 137100 | 1802 | 0 | 42.13440424 | -72.63235561 | 2022-05-09 04:20:54 | Hampden, Massachusetts, US | |
361944 | 361944 | 2022-05-07 | US | Massachusetts | Hampden | 25013 | 137100 | 1802 | 0 | 42.13440424 | -72.63235561 | 2022-05-08 04:20:49 | Hampden, Massachusetts, US | |
1399295 | 1399295 | 2022-05-06 | US | Massachusetts | Hampden | 25013 | 137100 | 1802 | 0 | 42.13440424 | -72.63235561 | 2022-05-07 04:21:09 | Hampden, Massachusetts, US | |
1159320 | 1159320 | 2022-04-29 | US | New Jersey | Camden | 34007 | 127612 | 1802 | 0 | 39.80343818 | -74.96388753 | 2022-04-30 04:21:05 | Camden, New Jersey, US | |
1846217 | 1846217 | 2022-04-18 | Russia | Pskov Oblast | 108745 | 1802 | 0 | 57.535872899999994 | 28.8586826 | 2022-04-19 04:21:00 | Pskov Oblast, Russia | |||
1468639 | 1468639 | 2022-03-24 | US | California | Alameda | 6001 | 268584 | 1802 | 0 | 37.64629437 | -121.8929271 | 2022-03-25 04:20:46 | Alameda, California, US | |
3022813 | 3022813 | 2022-03-23 | US | California | Alameda | 6001 | 268441 | 1802 | 0 | 37.64629437 | -121.8929271 | 2022-03-24 04:20:43 | Alameda, California, US | |
1511649 | 1511649 | 2022-02-24 | Russia | Primorsky Krai | 144879 | 1802 | 0 | 45.0819456 | 134.726645 | 2022-02-25 04:21:11 | Primorsky Krai, Russia | |||
2449440 | 2449440 | 2022-02-22 | US | Pennsylvania | Delaware | 42045 | 108557 | 1802 | 0 | 39.91680171 | -75.40243663 | 2022-02-23 04:21:09 | Delaware, Pennsylvania, US | |
3720853 | 3720853 | 2022-02-21 | US | Pennsylvania | Delaware | 42045 | 108479 | 1802 | 0 | 39.91680171 | -75.40243663 | 2022-02-22 04:21:01 | Delaware, Pennsylvania, US | |
3914687 | 3914687 | 2022-02-20 | US | Pennsylvania | Delaware | 42045 | 108479 | 1802 | 0 | 39.91680171 | -75.40243663 | 2022-02-21 04:21:05 | Delaware, Pennsylvania, US | |
3674306 | 3674306 | 2022-02-15 | US | Pennsylvania | Bucks | 42017 | 120812 | 1802 | 0 | 40.33682119 | -75.10836643 | 2022-02-16 04:21:10 | Bucks, Pennsylvania, US | |
1391247 | 1391247 | 2022-01-07 | US | Maryland | Prince George's | 24033 | 143999 | 1802 | 0 | 38.83070039 | -76.8496441 | 2022-01-08 04:21:53 | Prince George's, Maryland, US | |
1282235 | 1282235 | 2022-01-05 | Russia | Sakha (Yakutiya) Republic | 76475 | 1802 | 0 | 66.941626 | 129.642371 | 2022-01-06 04:22:09 | Sakha (Yakutiya) Republic, Russia | |||
1256949 | 1256949 | 2021-12-20 | US | New Jersey | Monmouth | 34025 | 106958 | 1802 | 0 | 40.26549699 | -74.22240686 | 2021-12-21 03:21:27 | Monmouth, New Jersey, US | |
1262432 | 1262432 | 2021-12-18 | Ukraine | Sevastopol* | 51785 | 1802 | 0 | 44.6054 | 33.522 | 2021-12-19 04:21:11 | Sevastopol*, Ukraine | |||
1145150 | 1145150 | 2021-12-01 | Russia | Kursk Oblast | 76814 | 1802 | 0 | 51.6568453 | 36.4852695 | 2021-12-02 04:22:37 | Kursk Oblast, Russia | |||
1144769 | 1144769 | 2021-12-01 | Colombia | Quindio | 58036 | 1802 | 0 | 4.461 | -75.6674 | 2021-12-02 04:22:37 | Quindio, Colombia | |||
2290498 | 2290498 | 2021-11-15 | US | Texas | Cameron | 48061 | 70356 | 1802 | 0 | 26.14524221 | -97.48140372 | 2021-11-16 04:21:10 | Cameron, Texas, US | |
1325876 | 1325876 | 2021-11-14 | Ukraine | Ternopil Oblast | 97765 | 1802 | 0 | 49.5535 | 25.5948 | 2021-11-15 04:21:36 | Ternopil Oblast, Ukraine | |||
1325272 | 1325272 | 2021-11-14 | US | Texas | Cameron | 48061 | 70356 | 1802 | 0 | 26.14524221 | -97.48140372 | 2021-11-15 04:21:36 | Cameron, Texas, US | |
714241 | 714241 | 2021-11-12 | Chile | Maule | 105431 | 1802 | 0 | -35.5183 | -71.6885 | 2021-11-13 04:21:38 | Maule, Chile | |||
28191 | 28191 | 2021-11-11 | Chile | Maule | 105277 | 1802 | 0 | -35.5183 | -71.6885 | 2021-11-12 04:22:01 | Maule, Chile | |||
3492375 | 3492375 | 2021-10-26 | Russia | Ivanovo Oblast | 54201 | 1802 | 0 | 56.9167446 | 41.43521370000001 | 2021-10-27 04:22:32 | Ivanovo Oblast, Russia | |||
684804 | 684804 | 2021-10-24 | US | Ohio | Franklin | 39049 | 164479 | 1802 | 0 | 39.96995815 | -83.01115755 | 2021-10-25 04:22:31 | Franklin, Ohio, US | |
938474 | 938474 | 2021-10-16 | Yemen | 9512 | 1802 | 0 | 15.552726999999999 | 48.516388 | 2021-10-17 04:21:29 | Yemen | ||||
635495 | 635495 | 2021-10-13 | US | Maryland | Baltimore | 24005 | 75171 | 1802 | 0 | 39.45784712 | -76.62911955 | 2021-10-14 04:21:29 | Baltimore, Maryland, US | |
470101 | 470101 | 2021-10-07 | US | Pennsylvania | Montgomery | 42091 | 82468 | 1802 | 0 | 40.21053671 | -75.36652296 | 2021-10-08 04:21:25 | Montgomery, Pennsylvania, US | |
1885193 | 1885193 | 2021-09-12 | Russia | Buryatia Republic | 57333 | 1802 | 0 | 52.718242599999996 | 109.492143 | 2021-09-13 04:21:15 | Buryatia Republic, Russia | |||
3806096 | 3806096 | 2021-09-11 | Russia | Buryatia Republic | 57255 | 1802 | 0 | 52.718242599999996 | 109.492143 | 2021-09-12 04:21:13 | Buryatia Republic, Russia | |||
641895 | 641895 | 2021-09-07 | India | Manipur | 115866 | 1802 | 0 | 24.738975 | 93.882541 | 2021-09-08 04:21:31 | Manipur, India | |||
3193958 | 3193958 | 2021-09-06 | India | Manipur | 115584 | 1802 | 0 | 24.738975 | 93.882541 | 2021-09-07 04:21:35 | Manipur, India | |||
32180 | 32180 | 2021-08-25 | Canada | British Columbia | 161969 | 1802 | 0 | 53.7267 | -127.6476 | 2021-08-26 04:21:28 | British Columbia, Canada | |||
2176121 | 2176121 | 2021-08-22 | US | California | Sacramento | 6067 | 130980 | 1802 | 0 | 38.45106826 | -121.34253740000001 | 2021-08-23 04:21:27 | Sacramento, California, US | |
2521166 | 2521166 | 2021-08-18 | US | Tennessee | Shelby | 47157 | 116069 | 1802 | 0 | 35.1864775 | -89.89692423 | 2021-08-19 04:21:15 | Shelby, Tennessee, US | |
1345912 | 1345912 | 2021-08-11 | Ukraine | Chernivtsi Oblast | 80385 | 1802 | 0 | 48.2917 | 25.9352 | 2021-08-12 04:21:25 | Chernivtsi Oblast, Ukraine | |||
1956255 | 1956255 | 2021-08-05 | Brazil | Acre | 87291 | 1802 | 0 | -9.0238 | -70.812 | 2021-08-06 04:21:18 | Acre, Brazil | |||
331634 | 331634 | 2021-08-04 | Brazil | Acre | 87232 | 1802 | 83084 | 2346 | -9.0238 | -70.812 | 2021-08-05 04:21:51 | Acre, Brazil | ||
3467905 | 3467905 | 2021-08-03 | Brazil | Acre | 87188 | 1802 | 83084 | 2302 | -9.0238 | -70.812 | 2021-08-04 04:21:25 | Acre, Brazil | ||
3683179 | 3683179 | 2021-08-02 | Brazil | Acre | 87186 | 1802 | 83084 | 2300 | -9.0238 | -70.812 | 2021-08-03 04:21:39 | Acre, Brazil | ||
409898 | 409898 | 2021-07-28 | US | Massachusetts | Worcester | 25027 | 78220 | 1802 | 0 | 42.35026951 | -71.90493363 | 2021-07-29 04:21:33 | Worcester, Massachusetts, US | |
3221944 | 3221944 | 2021-07-26 | Ukraine | Zhytomyr Oblast | 88740 | 1802 | 86665 | 273 | 50.2547 | 28.6587 | 2021-07-27 04:21:18 | Zhytomyr Oblast, Ukraine | ||
1382153 | 1382153 | 2021-07-25 | Ukraine | Zhytomyr Oblast | 88723 | 1802 | 86659 | 262 | 50.2547 | 28.6587 | 2021-07-26 04:21:28 | Zhytomyr Oblast, Ukraine | ||
3129154 | 3129154 | 2021-06-28 | United Arab Emirates | 628976 | 1802 | 607606 | 19568 | 23.424076 | 53.847818 | 2021-06-29 04:21:28 | United Arab Emirates | |||
2719199 | 2719199 | 2021-06-10 | US | New York | Erie | 36029 | 89520 | 1802 | 0 | 42.76249024 | -78.73063652 | 2021-06-11 04:23:20 | Erie, New York, US | |
1192377 | 1192377 | 2021-05-31 | Ukraine | Mykolaiv Oblast | 68604 | 1802 | 65209 | 1593 | 46.975 | 31.9946 | 2021-06-01 04:23:09 | Mykolaiv Oblast, Ukraine | ||
727196 | 727196 | 2021-05-22 | US | Florida | Hillsborough | 12057 | 141599 | 1802 | 0 | 27.9276559 | -82.32013172 | 2021-05-23 04:20:51 | Hillsborough, Florida, US | |
2410896 | 2410896 | 2021-04-19 | Korea, South | 115195 | 1802 | 105227 | 8166 | 35.90775700000001 | 127.766922 | 2021-04-20 04:20:41 | Korea, South | |||
2548846 | 2548846 | 2021-04-15 | India | Uttarakhand | 116244 | 1802 | 101958 | 12484 | 30.156447 | 79.197608 | 2021-04-16 04:20:46 | Uttarakhand, India | ||
1292642 | 1292642 | 2021-03-29 | US | Pennsylvania | Allegheny | 42003 | 85182 | 1802 | 0 | 40.46809875 | -79.98167747 | 2021-03-30 04:26:23 | Allegheny, Pennsylvania, US | |
1980413 | 1980413 | 2021-03-25 | Chile | Valparaiso | 61832 | 1802 | 56161 | 3869 | -33.0472 | -71.6127 | 2021-03-26 05:26:55 | Valparaiso, Chile | ||
3663893 | 3663893 | 2021-03-09 | Spain | Asturias | 44662 | 1802 | 1063 | 41797 | 43.3614 | -5.8593 | 2021-03-10 05:24:35 | Asturias, Spain | ||
471586 | 471586 | 2021-02-19 | Peru | Ucayali | 22146 | 1802 | 0 | 20344 | -9.621718 | -73.444929 | 2021-02-20 05:22:51 | Ucayali, Peru | ||
1459916 | 1459916 | 2021-01-31 | Peru | Cusco | 28377 | 1802 | 0 | 26575 | -13.191068 | -72.153609 | 2021-02-01 05:22:53 | Cusco, Peru | ||
3153666 | 3153666 | 2021-01-27 | Libya | 116064 | 1802 | 95406 | 18856 | 26.3351 | 17.228331 | 2021-01-28 05:22:24 | Libya | |||
2567747 | 2567747 | 2021-01-25 | Mexico | Durango | 28081 | 1802 | 0 | 26279 | 24.5593 | -104.6588 | 2021-01-26 05:22:02 | Durango, Mexico | ||
1759379 | 1759379 | 2021-01-24 | Mexico | Durango | 28003 | 1802 | 0 | 26201 | 24.5593 | -104.6588 | 2021-01-25 05:22:16 | Durango, Mexico | ||
3761499 | 3761499 | 2020-12-28 | Germany | Niedersachsen | 103244 | 1802 | 87411 | 14488 | 52.6367 | 9.8451 | 2020-12-29 05:22:37 | Niedersachsen, Germany | ||
3695101 | 3695101 | 2020-12-24 | Ukraine | Kiev | 105040 | 1802 | 35761 | 67477 | 50.4501 | 30.5234 | 2020-12-25 05:22:48 | Kiev, Ukraine |
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]);