johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
162 rows where deaths = 1018 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1150915 | 1150915 | 2022-12-12 | US | Missouri | St. Charles | 29183 | 114874 | 1018 | 0 | 38.77875681 | -90.66662425 | 2022-12-13 04:21:01 | St. Charles, Missouri, US | |
870769 | 870769 | 2022-12-11 | US | Missouri | St. Charles | 29183 | 114874 | 1018 | 0 | 38.77875681 | -90.66662425 | 2022-12-12 04:21:01 | St. Charles, Missouri, US | |
259299 | 259299 | 2022-12-10 | US | Missouri | St. Charles | 29183 | 114874 | 1018 | 0 | 38.77875681 | -90.66662425 | 2022-12-11 04:20:50 | St. Charles, Missouri, US | |
3938013 | 3938013 | 2022-12-09 | US | Missouri | St. Charles | 29183 | 114874 | 1018 | 0 | 38.77875681 | -90.66662425 | 2022-12-10 04:21:02 | St. Charles, Missouri, US | |
3379345 | 3379345 | 2022-12-08 | US | Missouri | St. Charles | 29183 | 114874 | 1018 | 0 | 38.77875681 | -90.66662425 | 2022-12-09 04:21:05 | St. Charles, Missouri, US | |
1986616 | 1986616 | 2022-12-07 | US | Missouri | St. Charles | 29183 | 114874 | 1018 | 0 | 38.77875681 | -90.66662425 | 2022-12-08 04:21:07 | St. Charles, Missouri, US | |
3716139 | 3716139 | 2022-12-06 | US | Missouri | St. Charles | 29183 | 114874 | 1018 | 0 | 38.77875681 | -90.66662425 | 2022-12-07 04:20:58 | St. Charles, Missouri, US | |
3460221 | 3460221 | 2022-11-21 | Malaysia | Pahang | 180441 | 1018 | 0 | 3.8126 | 103.3256 | 2022-11-22 04:20:47 | Pahang, Malaysia | |||
713121 | 713121 | 2022-11-01 | US | Pennsylvania | Dauphin | 42043 | 68130 | 1018 | 0 | 40.41377078 | -76.77993242 | 2022-11-02 04:22:09 | Dauphin, Pennsylvania, US | |
3287570 | 3287570 | 2022-10-31 | US | Pennsylvania | Dauphin | 42043 | 68130 | 1018 | 0 | 40.41377078 | -76.77993242 | 2022-11-01 04:22:36 | Dauphin, Pennsylvania, US | |
322603 | 322603 | 2022-10-30 | US | Pennsylvania | Dauphin | 42043 | 68130 | 1018 | 0 | 40.41377078 | -76.77993242 | 2022-10-31 04:21:36 | Dauphin, Pennsylvania, US | |
914879 | 914879 | 2022-10-29 | US | Pennsylvania | Dauphin | 42043 | 68130 | 1018 | 0 | 40.41377078 | -76.77993242 | 2022-10-30 04:22:14 | Dauphin, Pennsylvania, US | |
1369148 | 1369148 | 2022-10-28 | US | Pennsylvania | Dauphin | 42043 | 68130 | 1018 | 0 | 40.41377078 | -76.77993242 | 2022-10-29 04:21:13 | Dauphin, Pennsylvania, US | |
3041003 | 3041003 | 2022-10-27 | US | Pennsylvania | Dauphin | 42043 | 68130 | 1018 | 0 | 40.41377078 | -76.77993242 | 2022-10-28 04:22:31 | Dauphin, Pennsylvania, US | |
3038521 | 3038521 | 2022-10-27 | Russia | Adygea Republic | 54104 | 1018 | 0 | 44.6939006 | 40.1520421 | 2022-10-28 04:22:31 | Adygea Republic, Russia | |||
541423 | 541423 | 2022-10-26 | US | Pennsylvania | Dauphin | 42043 | 68130 | 1018 | 0 | 40.41377078 | -76.77993242 | 2022-10-27 04:22:01 | Dauphin, Pennsylvania, US | |
538941 | 538941 | 2022-10-26 | Russia | Adygea Republic | 54093 | 1018 | 0 | 44.6939006 | 40.1520421 | 2022-10-27 04:22:01 | Adygea Republic, Russia | |||
1832824 | 1832824 | 2022-10-25 | US | Pennsylvania | Dauphin | 42043 | 67895 | 1018 | 0 | 40.41377078 | -76.77993242 | 2022-10-26 04:22:19 | Dauphin, Pennsylvania, US | |
1830342 | 1830342 | 2022-10-25 | Russia | Adygea Republic | 54086 | 1018 | 0 | 44.6939006 | 40.1520421 | 2022-10-26 04:22:19 | Adygea Republic, Russia | |||
797085 | 797085 | 2022-10-24 | US | Pennsylvania | Dauphin | 42043 | 67895 | 1018 | 0 | 40.41377078 | -76.77993242 | 2022-10-25 04:21:53 | Dauphin, Pennsylvania, US | |
794603 | 794603 | 2022-10-24 | Russia | Adygea Republic | 54080 | 1018 | 0 | 44.6939006 | 40.1520421 | 2022-10-25 04:21:53 | Adygea Republic, Russia | |||
3279540 | 3279540 | 2022-10-23 | US | Pennsylvania | Dauphin | 42043 | 67895 | 1018 | 0 | 40.41377078 | -76.77993242 | 2022-10-24 04:22:29 | Dauphin, Pennsylvania, US | |
2270578 | 2270578 | 2022-10-22 | US | Pennsylvania | Dauphin | 42043 | 67895 | 1018 | 0 | 40.41377078 | -76.77993242 | 2022-10-23 04:22:46 | Dauphin, Pennsylvania, US | |
1594878 | 1594878 | 2022-10-21 | US | Pennsylvania | Dauphin | 42043 | 67895 | 1018 | 0 | 40.41377078 | -76.77993242 | 2022-10-22 04:22:53 | Dauphin, Pennsylvania, US | |
2274594 | 2274594 | 2022-10-20 | US | Pennsylvania | Dauphin | 42043 | 67895 | 1018 | 0 | 40.41377078 | -76.77993242 | 2022-10-21 04:22:23 | Dauphin, Pennsylvania, US | |
200929 | 200929 | 2022-10-19 | US | Pennsylvania | Dauphin | 42043 | 67895 | 1018 | 0 | 40.41377078 | -76.77993242 | 2022-10-20 04:22:59 | Dauphin, Pennsylvania, US | |
2759954 | 2759954 | 2022-10-18 | US | Texas | Brazoria | 48039 | 112127 | 1018 | 0 | 29.18757369 | -95.44563172 | 2022-10-19 04:22:26 | Brazoria, Texas, US | |
2027788 | 2027788 | 2022-10-17 | US | Texas | Brazoria | 48039 | 112127 | 1018 | 0 | 29.18757369 | -95.44563172 | 2022-10-18 04:22:42 | Brazoria, Texas, US | |
2162566 | 2162566 | 2022-10-16 | US | Texas | Brazoria | 48039 | 112071 | 1018 | 0 | 29.18757369 | -95.44563172 | 2022-10-17 04:20:31 | Brazoria, Texas, US | |
518763 | 518763 | 2022-10-15 | US | Texas | Brazoria | 48039 | 112071 | 1018 | 0 | 29.18757369 | -95.44563172 | 2022-10-16 04:22:39 | Brazoria, Texas, US | |
2035820 | 2035820 | 2022-10-14 | US | Texas | Brazoria | 48039 | 112071 | 1018 | 0 | 29.18757369 | -95.44563172 | 2022-10-15 04:22:00 | Brazoria, Texas, US | |
3214691 | 3214691 | 2022-10-12 | US | Alabama | Madison | 1089 | 107405 | 1018 | 0 | 34.76327133 | -86.55069633 | 2022-10-13 04:22:39 | Madison, Alabama, US | |
3250540 | 3250540 | 2022-10-11 | US | Alabama | Madison | 1089 | 107405 | 1018 | 0 | 34.76327133 | -86.55069633 | 2022-10-12 04:22:51 | Madison, Alabama, US | |
2967799 | 2967799 | 2022-10-10 | US | Alabama | Madison | 1089 | 107405 | 1018 | 0 | 34.76327133 | -86.55069633 | 2022-10-11 04:23:05 | Madison, Alabama, US | |
3099933 | 3099933 | 2022-10-09 | US | Ohio | Lorain | 39093 | 81397 | 1018 | 0 | 41.29553751 | -82.15083537 | 2022-10-10 04:22:32 | Lorain, Ohio, US | |
3097835 | 3097835 | 2022-10-09 | US | Alabama | Madison | 1089 | 107405 | 1018 | 0 | 34.76327133 | -86.55069633 | 2022-10-10 04:22:32 | Madison, Alabama, US | |
4005158 | 4005158 | 2022-10-08 | US | Ohio | Lorain | 39093 | 81397 | 1018 | 0 | 41.29553751 | -82.15083537 | 2022-10-09 04:21:16 | Lorain, Ohio, US | |
4003060 | 4003060 | 2022-10-08 | US | Alabama | Madison | 1089 | 107405 | 1018 | 0 | 34.76327133 | -86.55069633 | 2022-10-09 04:21:16 | Madison, Alabama, US | |
396657 | 396657 | 2022-10-07 | US | Alabama | Madison | 1089 | 107405 | 1018 | 0 | 34.76327133 | -86.55069633 | 2022-10-08 04:22:56 | Madison, Alabama, US | |
2529774 | 2529774 | 2022-10-06 | US | Alabama | Madison | 1089 | 107405 | 1018 | 0 | 34.76327133 | -86.55069633 | 2022-10-07 04:23:08 | Madison, Alabama, US | |
253891 | 253891 | 2022-09-08 | US | California | San Francisco | 6075 | 188501 | 1018 | 0 | 37.75215114 | -122.4385672 | 2022-09-09 04:21:11 | San Francisco, California, US | |
3745689 | 3745689 | 2022-09-07 | US | California | San Francisco | 6075 | 188364 | 1018 | 0 | 37.75215114 | -122.4385672 | 2022-09-08 04:21:02 | San Francisco, California, US | |
115329 | 115329 | 2022-09-06 | US | California | San Francisco | 6075 | 188352 | 1018 | 0 | 37.75215114 | -122.4385672 | 2022-09-07 04:20:59 | San Francisco, California, US | |
2323174 | 2323174 | 2022-08-24 | Colombia | Casanare | 42670 | 1018 | 0 | 5.7589 | -71.5724 | 2022-08-25 04:21:13 | Casanare, Colombia | |||
1250583 | 1250583 | 2022-08-23 | Colombia | Casanare | 42670 | 1018 | 0 | 5.7589 | -71.5724 | 2022-08-24 04:20:46 | Casanare, Colombia | |||
2852687 | 2852687 | 2022-08-22 | Colombia | Casanare | 42670 | 1018 | 0 | 5.7589 | -71.5724 | 2022-08-23 04:20:56 | Casanare, Colombia | |||
2402659 | 2402659 | 2022-08-21 | Colombia | Casanare | 42670 | 1018 | 0 | 5.7589 | -71.5724 | 2022-08-22 04:20:38 | Casanare, Colombia | |||
3797737 | 3797737 | 2022-08-20 | Colombia | Casanare | 42670 | 1018 | 0 | 5.7589 | -71.5724 | 2022-08-21 04:20:44 | Casanare, Colombia | |||
2363323 | 2363323 | 2022-08-19 | Colombia | Casanare | 42670 | 1018 | 0 | 5.7589 | -71.5724 | 2022-08-20 04:21:01 | Casanare, Colombia | |||
1160994 | 1160994 | 2022-08-18 | Colombia | Casanare | 42670 | 1018 | 0 | 5.7589 | -71.5724 | 2022-08-19 04:20:54 | Casanare, Colombia | |||
2149807 | 2149807 | 2022-06-27 | US | New Jersey | Atlantic | 34001 | 75087 | 1018 | 0 | 39.47538693 | -74.65848483 | 2022-06-28 04:20:58 | Atlantic, New Jersey, US | |
1572370 | 1572370 | 2022-05-03 | Russia | Novgorod Oblast | 99152 | 1018 | 0 | 58.2843833 | 32.5169757 | 2022-05-04 04:20:59 | Novgorod Oblast, Russia | |||
463630 | 463630 | 2022-05-02 | Russia | Novgorod Oblast | 99107 | 1018 | 0 | 58.2843833 | 32.5169757 | 2022-05-03 04:21:00 | Novgorod Oblast, Russia | |||
3627782 | 3627782 | 2022-03-13 | Colombia | Caqueta | 24893 | 1018 | 0 | 0.8699 | -73.8419 | 2022-03-14 04:20:46 | Caqueta, Colombia | |||
950690 | 950690 | 2022-03-12 | Colombia | Caqueta | 24871 | 1018 | 0 | 0.8699 | -73.8419 | 2022-03-13 04:20:49 | Caqueta, Colombia | |||
1865744 | 1865744 | 2022-03-10 | Russia | Yamalo-Nenets Autonomous Okrug | 131555 | 1018 | 0 | 67.1471631 | 74.3415488 | 2022-03-11 04:20:50 | Yamalo-Nenets Autonomous Okrug, Russia | |||
2199787 | 2199787 | 2022-03-06 | Pakistan | Islamabad | 134643 | 1018 | 0 | 33.665087 | 73.121219 | 2022-03-07 04:20:47 | Islamabad, Pakistan | |||
3720819 | 3720819 | 2022-02-21 | US | Oregon | Multnomah | 41051 | 109428 | 1018 | 0 | 45.54747959 | -122.4169351 | 2022-02-22 04:21:01 | Multnomah, Oregon, US | |
3914653 | 3914653 | 2022-02-20 | US | Oregon | Multnomah | 41051 | 109428 | 1018 | 0 | 45.54747959 | -122.4169351 | 2022-02-21 04:21:05 | Multnomah, Oregon, US | |
3878211 | 3878211 | 2022-02-19 | US | Oregon | Multnomah | 41051 | 109428 | 1018 | 0 | 45.54747959 | -122.4169351 | 2022-02-20 04:21:00 | Multnomah, Oregon, US | |
3858467 | 3858467 | 2022-02-18 | US | Oregon | Multnomah | 41051 | 109428 | 1018 | 0 | 45.54747959 | -122.4169351 | 2022-02-19 04:21:11 | Multnomah, Oregon, US | |
3427438 | 3427438 | 2022-01-21 | US | Ohio | Mahoning | 39099 | 50752 | 1018 | 0 | 41.01631101 | -80.77287029 | 2022-01-22 04:21:13 | Mahoning, Ohio, US | |
99558 | 99558 | 2022-01-14 | Russia | North Ossetia - Alania Republic | 31928 | 1018 | 0 | 42.79336110000001 | 44.6324493 | 2022-01-15 04:21:07 | North Ossetia - Alania Republic, Russia | |||
2778297 | 2778297 | 2021-12-31 | US | Kansas | Johnson | 20091 | 92698 | 1018 | 0 | 38.88548175 | -94.82250877 | 2022-01-01 04:22:14 | Johnson, Kansas, US | |
3605672 | 3605672 | 2021-12-25 | US | Colorado | Arapahoe | 8005 | 100600 | 1018 | 0 | 39.64977461 | -104.3353617 | 2021-12-26 04:21:50 | Arapahoe, Colorado, US | |
2090658 | 2090658 | 2021-12-14 | US | Pennsylvania | Luzerne | 42079 | 49135 | 1018 | 0 | 41.17823008 | -75.98447579 | 2021-12-15 03:22:16 | Luzerne, Pennsylvania, US | |
3402039 | 3402039 | 2021-11-30 | US | Colorado | Adams | 8001 | 86688 | 1018 | 0 | 39.87432092 | -104.3362578 | 2021-12-01 04:22:29 | Adams, Colorado, US | |
904469 | 904469 | 2021-11-24 | Spain | Baleares | 104268 | 1018 | 0 | 39.710358 | 2.995148 | 2021-11-25 04:22:33 | Baleares, Spain | |||
904391 | 904391 | 2021-11-24 | Russia | Khabarovsk Krai | 106584 | 1018 | 0 | 51.6312684 | 136.121524 | 2021-11-25 04:22:33 | Khabarovsk Krai, Russia | |||
1014962 | 1014962 | 2021-11-21 | US | Colorado | Jefferson | 8059 | 72453 | 1018 | 0 | 39.58635604 | -105.2517692 | 2021-11-22 04:22:20 | Jefferson, Colorado, US | |
722739 | 722739 | 2021-11-20 | Russia | Pskov Oblast | 63525 | 1018 | 0 | 57.535872899999994 | 28.8586826 | 2021-11-21 04:22:13 | Pskov Oblast, Russia | |||
2002835 | 2002835 | 2021-11-07 | US | New Jersey | Mercer | 34021 | 39978 | 1018 | 0 | 40.28047017 | -74.70479631 | 2021-11-08 04:21:43 | Mercer, New Jersey, US | |
497826 | 497826 | 2021-11-06 | US | New Jersey | Mercer | 34021 | 39949 | 1018 | 0 | 40.28047017 | -74.70479631 | 2021-11-07 04:21:53 | Mercer, New Jersey, US | |
3124579 | 3124579 | 2021-11-05 | US | Texas | Denton | 48121 | 105043 | 1018 | 0 | 33.20521901 | -97.11691153 | 2021-11-06 04:21:51 | Denton, Texas, US | |
276857 | 276857 | 2021-11-03 | US | Delaware | New Castle | 10003 | 82309 | 1018 | 0 | 39.57992638 | -75.64054974 | 2021-11-04 04:22:20 | New Castle, Delaware, US | |
45053 | 45053 | 2021-11-02 | US | Kansas | Sedgwick | 20173 | 81797 | 1018 | 0 | 37.6842718 | -97.4608198 | 2021-11-03 06:22:09 | Sedgwick, Kansas, US | |
3512749 | 3512749 | 2021-11-01 | US | Kansas | Sedgwick | 20173 | 81797 | 1018 | 0 | 37.6842718 | -97.4608198 | 2021-11-02 04:22:03 | Sedgwick, Kansas, US | |
4889 | 4889 | 2021-10-28 | US | California | Contra Costa | 6013 | 100704 | 1018 | 0 | 37.91923498 | -121.9289527 | 2021-10-29 04:22:03 | Contra Costa, California, US | |
633943 | 633943 | 2021-10-13 | Japan | Saitama | 115333 | 1018 | 0 | 35.997101 | 139.347635 | 2021-10-14 04:21:29 | Saitama, Japan | |||
3759104 | 3759104 | 2021-09-21 | US | Michigan | Genesee | 26049 | 46330 | 1018 | 0 | 43.02244215 | -83.70589709 | 2021-09-22 04:21:45 | Genesee, Michigan, US | |
811207 | 811207 | 2021-09-20 | US | Michigan | Genesee | 26049 | 46330 | 1018 | 0 | 43.02244215 | -83.70589709 | 2021-09-21 04:21:26 | Genesee, Michigan, US | |
1816406 | 1816406 | 2021-09-19 | US | Michigan | Genesee | 26049 | 46092 | 1018 | 0 | 43.02244215 | -83.70589709 | 2021-09-20 04:21:22 | Genesee, Michigan, US | |
17986 | 17986 | 2021-09-18 | US | Michigan | Genesee | 26049 | 46092 | 1018 | 0 | 43.02244215 | -83.70589709 | 2021-09-19 04:21:34 | Genesee, Michigan, US | |
2619671 | 2619671 | 2021-09-17 | US | Michigan | Genesee | 26049 | 46092 | 1018 | 0 | 43.02244215 | -83.70589709 | 2021-09-18 04:21:24 | Genesee, Michigan, US | |
1375107 | 1375107 | 2021-09-15 | US | Colorado | El Paso | 8041 | 88727 | 1018 | 0 | 38.83240149 | -104.5251411 | 2021-09-16 04:22:19 | El Paso, Colorado, US | |
1385843 | 1385843 | 2021-09-13 | Russia | Khakassia Republic | 36830 | 1018 | 0 | 53.72258845 | 91.44293627 | 2021-09-14 04:21:41 | Khakassia Republic, Russia | |||
1885212 | 1885212 | 2021-09-12 | Russia | Khakassia Republic | 36727 | 1018 | 0 | 53.72258845 | 91.44293627 | 2021-09-13 04:21:15 | Khakassia Republic, Russia | |||
1264971 | 1264971 | 2021-09-09 | US | New Mexico | Bernalillo | 35001 | 67666 | 1018 | 0 | 35.05163625 | -106.6703554 | 2021-09-10 04:21:20 | Bernalillo, New Mexico, US | |
3978241 | 3978241 | 2021-09-03 | Malaysia | Negeri Sembilan | 92339 | 1018 | 87210 | 4111 | 2.7258 | 101.9424 | 2021-09-04 04:21:28 | Negeri Sembilan, Malaysia | ||
181703 | 181703 | 2021-09-02 | Malaysia | Negeri Sembilan | 92069 | 1018 | 86676 | 4375 | 2.7258 | 101.9424 | 2021-09-03 04:21:20 | Negeri Sembilan, Malaysia | ||
2069410 | 2069410 | 2021-08-31 | US | Louisiana | Jefferson | 22051 | 65340 | 1018 | 0 | 29.74075478 | -90.11115756 | 2021-09-01 04:21:38 | Jefferson, Louisiana, US | |
1776864 | 1776864 | 2021-08-30 | US | Louisiana | Jefferson | 22051 | 65340 | 1018 | 0 | 29.74075478 | -90.11115756 | 2021-08-31 04:21:46 | Jefferson, Louisiana, US | |
3893438 | 3893438 | 2021-08-29 | US | Louisiana | Jefferson | 22051 | 65340 | 1018 | 0 | 29.74075478 | -90.11115756 | 2021-08-30 04:21:23 | Jefferson, Louisiana, US | |
2794541 | 2794541 | 2021-08-28 | US | Louisiana | Jefferson | 22051 | 65340 | 1018 | 0 | 29.74075478 | -90.11115756 | 2021-08-29 04:21:14 | Jefferson, Louisiana, US | |
2924700 | 2924700 | 2021-08-27 | US | Louisiana | Jefferson | 22051 | 65340 | 1018 | 0 | 29.74075478 | -90.11115756 | 2021-08-28 04:21:28 | Jefferson, Louisiana, US | |
1604232 | 1604232 | 2021-08-16 | Japan | Aichi | 60940 | 1018 | 0 | 35.035551 | 137.211621 | 2021-08-17 04:21:49 | Aichi, Japan | |||
103326 | 103326 | 2021-08-15 | Japan | Aichi | 60369 | 1018 | 0 | 35.035551 | 137.211621 | 2021-08-16 04:21:31 | Aichi, Japan | |||
2899704 | 2899704 | 2021-08-12 | Japan | Kanagawa | 103858 | 1018 | 0 | 35.415312 | 139.338983 | 2021-08-13 04:21:24 | Kanagawa, Japan | |||
332490 | 332490 | 2021-08-04 | US | California | Stanislaus | 6099 | 65891 | 1018 | 0 | 37.55862499 | -120.9970722 | 2021-08-05 04:21:51 | Stanislaus, California, US | |
3683142 | 3683142 | 2021-08-02 | Angola | 42970 | 1018 | 38360 | 3592 | -11.2027 | 17.8739 | 2021-08-03 04:21:39 | Angola |
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]);