johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
83 rows where deaths = 2317 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2754494 | 2754494 | 2022-12-29 | US | Maryland | Prince George's | 24033 | 220685 | 2317 | 0 | 38.83070039 | -76.8496441 | 2022-12-30 04:21:04 | Prince George's, Maryland, US | |
3523645 | 3523645 | 2022-11-24 | Russia | Belgorod Oblast | 163362 | 2317 | 0 | 50.7080119 | 37.5837615 | 2022-11-25 04:21:06 | Belgorod Oblast, Russia | |||
3523132 | 3523132 | 2022-11-24 | Australia | Queensland | 1693178 | 2317 | 0 | -27.4698 | 153.0251 | 2022-11-25 04:21:06 | Queensland, Australia | |||
3311915 | 3311915 | 2022-11-23 | Australia | Queensland | 1683096 | 2317 | 0 | -27.4698 | 153.0251 | 2022-11-24 04:21:09 | Queensland, Australia | |||
1619956 | 1619956 | 2022-11-22 | Australia | Queensland | 1683096 | 2317 | 0 | -27.4698 | 153.0251 | 2022-11-23 04:21:06 | Queensland, Australia | |||
3459844 | 3459844 | 2022-11-21 | Australia | Queensland | 1683096 | 2317 | 0 | -27.4698 | 153.0251 | 2022-11-22 04:20:47 | Queensland, Australia | |||
1640029 | 1640029 | 2022-11-20 | Australia | Queensland | 1683096 | 2317 | 0 | -27.4698 | 153.0251 | 2022-11-21 04:21:05 | Queensland, Australia | |||
2063586 | 2063586 | 2022-11-19 | Australia | Queensland | 1683096 | 2317 | 0 | -27.4698 | 153.0251 | 2022-11-20 04:21:08 | Queensland, Australia | |||
1754980 | 1754980 | 2022-11-18 | Australia | Queensland | 1683096 | 2317 | 0 | -27.4698 | 153.0251 | 2022-11-19 04:21:14 | Queensland, Australia | |||
3025973 | 3025973 | 2022-11-17 | Australia | Queensland | 1683096 | 2317 | 0 | -27.4698 | 153.0251 | 2022-11-18 04:21:15 | Queensland, Australia | |||
674318 | 674318 | 2022-07-30 | Japan | Kanagawa | 1011249 | 2317 | 0 | 35.415312 | 139.338983 | 2022-07-31 04:21:02 | Kanagawa, Japan | |||
3368982 | 3368982 | 2022-07-02 | United Arab Emirates | 949384 | 2317 | 0 | 23.424076 | 53.847818 | 2022-07-03 04:20:59 | United Arab Emirates | ||||
597311 | 597311 | 2022-07-01 | United Arab Emirates | 947588 | 2317 | 0 | 23.424076 | 53.847818 | 2022-07-02 04:21:16 | United Arab Emirates | ||||
2191181 | 2191181 | 2022-06-22 | US | Wisconsin | Milwaukee | 55079 | 290820 | 2317 | 0 | 43.00486062 | -87.96733172 | 2022-06-23 04:20:55 | Milwaukee, Wisconsin, US | |
169612 | 169612 | 2022-06-21 | US | Wisconsin | Milwaukee | 55079 | 290494 | 2317 | 0 | 43.00486062 | -87.96733172 | 2022-06-22 04:20:54 | Milwaukee, Wisconsin, US | |
3888202 | 3888202 | 2022-06-06 | US | California | Santa Clara | 6085 | 371826 | 2317 | 0 | 37.23104908 | -121.6970462 | 2022-06-07 04:21:08 | Santa Clara, California, US | |
3507971 | 3507971 | 2022-06-05 | US | California | Santa Clara | 6085 | 366777 | 2317 | 0 | 37.23104908 | -121.6970462 | 2022-06-06 04:20:57 | Santa Clara, California, US | |
3528048 | 3528048 | 2022-06-04 | US | California | Santa Clara | 6085 | 366736 | 2317 | 0 | 37.23104908 | -121.6970462 | 2022-06-05 04:20:55 | Santa Clara, California, US | |
3134134 | 3134134 | 2022-06-03 | US | California | Santa Clara | 6085 | 366689 | 2317 | 0 | 37.23104908 | -121.6970462 | 2022-06-04 04:20:58 | Santa Clara, California, US | |
3579209 | 3579209 | 2022-06-02 | US | California | Santa Clara | 6085 | 366569 | 2317 | 0 | 37.23104908 | -121.6970462 | 2022-06-03 04:20:58 | Santa Clara, California, US | |
971502 | 971502 | 2022-06-01 | US | California | Santa Clara | 6085 | 363728 | 2317 | 0 | 37.23104908 | -121.6970462 | 2022-06-02 05:20:39 | Santa Clara, California, US | |
229809 | 229809 | 2022-05-31 | US | California | Santa Clara | 6085 | 363650 | 2317 | 0 | 37.23104908 | -121.6970462 | 2022-06-01 04:20:55 | Santa Clara, California, US | |
1850296 | 1850296 | 2022-05-26 | Spain | Murcia | 427577 | 2317 | 0 | 37.9922 | -1.1307 | 2022-05-27 04:20:56 | Murcia, Spain | |||
2048172 | 2048172 | 2022-05-25 | Spain | Murcia | 426360 | 2317 | 0 | 37.9922 | -1.1307 | 2022-05-26 04:20:50 | Murcia, Spain | |||
2999610 | 2999610 | 2022-05-24 | Spain | Murcia | 426360 | 2317 | 0 | 37.9922 | -1.1307 | 2022-05-25 04:20:56 | Murcia, Spain | |||
3593331 | 3593331 | 2022-05-23 | Spain | Murcia | 426360 | 2317 | 0 | 37.9922 | -1.1307 | 2022-05-24 04:20:57 | Murcia, Spain | |||
622183 | 622183 | 2022-05-22 | Spain | Murcia | 426360 | 2317 | 0 | 37.9922 | -1.1307 | 2022-05-26 04:20:50 | Murcia, Spain | |||
1109879 | 1109879 | 2022-05-21 | Spain | Murcia | 426360 | 2317 | 0 | 37.9922 | -1.1307 | 2022-05-22 04:20:52 | Murcia, Spain | |||
3444616 | 3444616 | 2022-05-11 | Chile | Los Lagos | 195633 | 2317 | 0 | -41.9198 | -72.1416 | 2022-05-12 04:20:54 | Los Lagos, Chile | |||
1699025 | 1699025 | 2022-04-28 | US | Pennsylvania | Montgomery | 42091 | 155096 | 2317 | 0 | 40.21053671 | -75.36652296 | 2022-04-29 04:20:59 | Montgomery, Pennsylvania, US | |
1696633 | 1696633 | 2022-04-28 | Spain | Extremadura | 259972 | 2317 | 0 | 39.4937 | -6.0679 | 2022-04-29 04:20:59 | Extremadura, Spain | |||
3854508 | 3854508 | 2022-04-27 | US | Pennsylvania | Montgomery | 42091 | 154866 | 2317 | 0 | 40.21053671 | -75.36652296 | 2022-04-28 04:20:47 | Montgomery, Pennsylvania, US | |
3852116 | 3852116 | 2022-04-27 | Spain | Extremadura | 259972 | 2317 | 0 | 39.4937 | -6.0679 | 2022-04-28 04:20:47 | Extremadura, Spain | |||
1328938 | 1328938 | 2022-04-26 | US | Pennsylvania | Montgomery | 42091 | 154723 | 2317 | 0 | 40.21053671 | -75.36652296 | 2022-04-27 04:20:52 | Montgomery, Pennsylvania, US | |
1326546 | 1326546 | 2022-04-26 | Spain | Extremadura | 259972 | 2317 | 0 | 39.4937 | -6.0679 | 2022-04-27 04:20:52 | Extremadura, Spain | |||
3724892 | 3724892 | 2022-04-25 | US | Pennsylvania | Montgomery | 42091 | 154594 | 2317 | 0 | 40.21053671 | -75.36652296 | 2022-04-26 04:20:51 | Montgomery, Pennsylvania, US | |
2031460 | 2031460 | 2022-04-24 | US | Pennsylvania | Montgomery | 42091 | 154457 | 2317 | 0 | 40.21053671 | -75.36652296 | 2022-04-25 04:20:56 | Montgomery, Pennsylvania, US | |
749035 | 749035 | 2022-04-23 | US | Pennsylvania | Montgomery | 42091 | 154337 | 2317 | 0 | 40.21053671 | -75.36652296 | 2022-04-24 04:20:56 | Montgomery, Pennsylvania, US | |
2163706 | 2163706 | 2022-03-26 | Peru | Ayacucho | 48023 | 2317 | 0 | -14.091648000000001 | -74.08344 | 2022-03-27 04:20:47 | Ayacucho, Peru | |||
1720642 | 1720642 | 2022-03-25 | Peru | Ayacucho | 48023 | 2317 | 0 | -14.091648000000001 | -74.08344 | 2022-03-26 04:20:23 | Ayacucho, Peru | |||
1468481 | 1468481 | 2022-03-24 | US | Alabama | Jefferson | 1073 | 184298 | 2317 | 0 | 33.55554728 | -86.89506300000002 | 2022-03-25 04:20:46 | Jefferson, Alabama, US | |
1468259 | 1468259 | 2022-03-24 | Peru | Ayacucho | 48023 | 2317 | 0 | -14.091648000000001 | -74.08344 | 2022-03-25 04:20:46 | Ayacucho, Peru | |||
3022433 | 3022433 | 2022-03-23 | Peru | Ayacucho | 48023 | 2317 | 0 | -14.091648000000001 | -74.08344 | 2022-03-24 04:20:43 | Ayacucho, Peru | |||
1905355 | 1905355 | 2022-03-22 | Peru | Ayacucho | 48023 | 2317 | 0 | -14.091648000000001 | -74.08344 | 2022-03-23 04:20:48 | Ayacucho, Peru | |||
3238486 | 3238486 | 2022-03-21 | Peru | Ayacucho | 48023 | 2317 | 0 | -14.091648000000001 | -74.08344 | 2022-03-22 04:20:54 | Ayacucho, Peru | |||
1867658 | 1867658 | 2022-03-10 | US | New Jersey | Passaic | 34031 | 143018 | 2317 | 0 | 41.03238628 | -74.29954144 | 2022-03-11 04:20:50 | Passaic, New Jersey, US | |
2142353 | 2142353 | 2022-03-09 | US | New Jersey | Passaic | 34031 | 142955 | 2317 | 0 | 41.03238628 | -74.29954144 | 2022-03-10 04:20:48 | Passaic, New Jersey, US | |
2140395 | 2140395 | 2022-03-09 | Russia | Kursk Oblast | 109386 | 2317 | 0 | 51.6568453 | 36.4852695 | 2022-03-10 04:20:48 | Kursk Oblast, Russia | |||
2667977 | 2667977 | 2022-03-04 | US | New Jersey | Passaic | 34031 | 142644 | 2317 | 0 | 41.03238628 | -74.29954144 | 2022-03-05 04:21:10 | Passaic, New Jersey, US | |
2474035 | 2474035 | 2022-02-03 | Mexico | Chiapas | 27892 | 2317 | 0 | 16.7569 | -93.1292 | 2022-02-04 04:21:10 | Chiapas, Mexico | |||
3466641 | 3466641 | 2022-01-18 | US | Ohio | Franklin | 39049 | 261393 | 2317 | 0 | 39.96995815 | -83.01115755 | 2022-01-19 04:21:23 | Franklin, Ohio, US | |
558432 | 558432 | 2022-01-16 | Ukraine | Rivne Oblast | 129866 | 2317 | 0 | 50.6199 | 26.2516 | 2022-01-17 04:21:08 | Rivne Oblast, Ukraine | |||
99162 | 99162 | 2022-01-14 | Colombia | Meta | 93966 | 2317 | 0 | 3.272 | -73.0877 | 2022-01-15 04:21:07 | Meta, Colombia | |||
798482 | 798482 | 2021-12-22 | Malawi | 67278 | 2317 | 0 | -13.2543 | 34.3015 | 2021-12-23 04:21:21 | Malawi | ||||
2399011 | 2399011 | 2021-12-17 | Russia | Buryatia Republic | 73482 | 2317 | 0 | 52.718242599999996 | 109.492143 | 2021-12-18 02:22:20 | Buryatia Republic, Russia | |||
1014557 | 1014557 | 2021-11-21 | Russia | Lipetsk Oblast | 71076 | 2317 | 0 | 52.693517799999995 | 39.112266399999996 | 2021-11-22 04:22:20 | Lipetsk Oblast, Russia | |||
3289579 | 3289579 | 2021-11-18 | US | Connecticut | Fairfield | 9001 | 114301 | 2317 | 0 | 41.26809896 | -73.3881171 | 2021-11-19 04:21:40 | Fairfield, Connecticut, US | |
1818462 | 1818462 | 2021-09-19 | Malaysia | W.P. Kuala Lumpur | 182863 | 2317 | 174522 | 6024 | 3.139 | 101.6869 | 2021-09-20 04:21:22 | W.P. Kuala Lumpur, Malaysia | ||
3449080 | 3449080 | 2021-09-10 | Russia | Penza Oblast | 65833 | 2317 | 0 | 53.1655415 | 44.78791810000001 | 2021-09-11 04:21:30 | Penza Oblast, Russia | |||
1265066 | 1265066 | 2021-09-09 | US | New York | Westchester | 36119 | 138583 | 2317 | 0 | 41.16278376 | -73.75741653 | 2021-09-10 04:21:20 | Westchester, New York, US | |
2281436 | 2281436 | 2021-09-08 | US | New York | Westchester | 36119 | 138417 | 2317 | 0 | 41.16278376 | -73.75741653 | 2021-09-09 04:21:27 | Westchester, New York, US | |
644215 | 644215 | 2021-09-07 | US | New York | Westchester | 36119 | 138299 | 2317 | 0 | 41.16278376 | -73.75741653 | 2021-09-08 04:21:31 | Westchester, New York, US | |
3107908 | 3107908 | 2021-08-24 | US | Ohio | Cuyahoga | 39035 | 122407 | 2317 | 0 | 41.424119 | -81.65918339 | 2021-08-25 04:21:41 | Cuyahoga, Ohio, US | |
2351478 | 2351478 | 2021-08-10 | Japan | Tokyo | 256262 | 2317 | 0 | 35.711343 | 139.446921 | 2021-08-11 04:21:58 | Tokyo, Japan | |||
1119758 | 1119758 | 2021-08-06 | US | New Jersey | Hudson | 34017 | 89950 | 2317 | 0 | 40.73766234 | -74.07515667 | 2021-08-07 04:21:30 | Hudson, New Jersey, US | |
1958695 | 1958695 | 2021-08-05 | US | New Jersey | Hudson | 34017 | 89857 | 2317 | 0 | 40.73766234 | -74.07515667 | 2021-08-06 04:21:18 | Hudson, New Jersey, US | |
334074 | 334074 | 2021-08-04 | US | New Jersey | Hudson | 34017 | 89766 | 2317 | 0 | 40.73766234 | -74.07515667 | 2021-08-05 04:21:51 | Hudson, New Jersey, US | |
3017518 | 3017518 | 2021-08-01 | US | New Jersey | Hudson | 34017 | 89525 | 2317 | 0 | 40.73766234 | -74.07515667 | 2021-08-02 04:21:36 | Hudson, New Jersey, US | |
2504196 | 2504196 | 2021-05-07 | US | New Jersey | Middlesex | 34023 | 91386 | 2317 | 0 | 40.43629879 | -74.41426991 | 2021-05-08 04:21:04 | Middlesex, New Jersey, US | |
1409214 | 1409214 | 2021-04-23 | Peru | San Martin | 38668 | 2317 | 0 | 36351 | -7.039531 | -76.729127 | 2021-04-24 04:20:38 | San Martin, Peru | ||
2410918 | 2410918 | 2021-04-19 | Mexico | Aguascalientes | 25669 | 2317 | 0 | 23352 | 21.8853 | -102.2916 | 2021-04-20 04:20:41 | Aguascalientes, Mexico | ||
3883277 | 3883277 | 2021-04-11 | Albania | 128393 | 2317 | 97723 | 28353 | 41.1533 | 20.1683 | 2021-04-12 04:21:00 | Albania | |||
1798899 | 1798899 | 2021-03-23 | Russia | Voronezh Oblast | 73490 | 2317 | 68057 | 3116 | 50.9800393 | 40.15065070000001 | 2021-03-24 05:25:40 | Voronezh Oblast, Russia | ||
3453304 | 3453304 | 2021-03-18 | US | Arizona | Pima | 4019 | 111507 | 2317 | 0 | 32.0971334 | -111.7890033 | 2021-03-19 05:26:09 | Pima, Arizona, US | |
1619871 | 1619871 | 2021-03-05 | Ukraine | Lviv Oblast | 81221 | 2317 | 70416 | 8488 | 49.8397 | 24.0297 | 2021-03-06 04:23:41 | Lviv Oblast, Ukraine | ||
3539555 | 3539555 | 2021-02-12 | Mexico | Quintana Roo | 19500 | 2317 | 0 | 17183 | 19.1817 | -88.4791 | 2021-02-13 05:22:12 | Quintana Roo, Mexico | ||
3230727 | 3230727 | 2021-01-03 | Slovakia | 289150 | 2317 | 129994 | 156839 | 48.669 | 19.699 | 2021-01-04 05:22:02 | Slovakia | |||
1584324 | 1584324 | 2020-11-30 | Peru | Junin | 25554 | 2317 | 0 | 23237 | -11.541783 | -74.876968 | 2020-12-01 05:26:18 | Junin, Peru | ||
923564 | 923564 | 2020-11-26 | Dominican Republic | 140922 | 2317 | 113687 | 24918 | 18.7357 | -70.1627 | 2020-11-27 05:26:53 | Dominican Republic | |||
3189720 | 3189720 | 2020-11-22 | Brazil | Alagoas | 93440 | 2317 | 90135 | 988 | -9.5713 | -36.782 | 2020-11-23 05:25:26 | Alagoas, Brazil | ||
3651567 | 3651567 | 2020-10-24 | Italy | Veneto | 42869 | 2317 | 24931 | 15621 | 45.43490485 | 12.33845213 | 2020-10-25 04:24:36 | Veneto, Italy | ||
1997348 | 1997348 | 2020-08-26 | US | Florida | Miami-Dade | 12086 | 154135 | 2317 | 0 | 151818 | 25.6112362 | -80.55170587 | 2020-08-27 04:28:15 | Miami-Dade, Florida, US |
3457146 | 3457146 | 2020-05-10 | US | Illinois | Cook | 17031 | 52655 | 2317 | 0 | 50338 | 41.84144849 | -87.81658794 | 2020-05-11 02:32:30 | Cook, Illinois, 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]);