johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
89 rows where deaths = 2003 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1622958 | 1622958 | 2022-11-22 | US | Pennsylvania | Lancaster | 42071 | 141088 | 2003 | 0 | 40.03904563 | -76.24770128 | 2022-11-23 04:21:06 | Lancaster, Pennsylvania, US | |
3462846 | 3462846 | 2022-11-21 | US | Pennsylvania | Lancaster | 42071 | 141088 | 2003 | 0 | 40.03904563 | -76.24770128 | 2022-11-22 04:20:47 | Lancaster, Pennsylvania, US | |
1643031 | 1643031 | 2022-11-20 | US | Pennsylvania | Lancaster | 42071 | 141088 | 2003 | 0 | 40.03904563 | -76.24770128 | 2022-11-21 04:21:05 | Lancaster, Pennsylvania, US | |
2066588 | 2066588 | 2022-11-19 | US | Pennsylvania | Lancaster | 42071 | 141088 | 2003 | 0 | 40.03904563 | -76.24770128 | 2022-11-20 04:21:08 | Lancaster, Pennsylvania, US | |
1757982 | 1757982 | 2022-11-18 | US | Pennsylvania | Lancaster | 42071 | 141088 | 2003 | 0 | 40.03904563 | -76.24770128 | 2022-11-19 04:21:14 | Lancaster, Pennsylvania, US | |
3028975 | 3028975 | 2022-11-17 | US | Pennsylvania | Lancaster | 42071 | 141088 | 2003 | 0 | 40.03904563 | -76.24770128 | 2022-11-18 04:21:15 | Lancaster, Pennsylvania, US | |
2488686 | 2488686 | 2022-11-16 | US | Pennsylvania | Lancaster | 42071 | 141088 | 2003 | 0 | 40.03904563 | -76.24770128 | 2022-11-17 04:21:11 | Lancaster, Pennsylvania, US | |
2486210 | 2486210 | 2022-11-16 | Russia | Kaliningrad Oblast | 190827 | 2003 | 0 | 54.7293041 | 21.1489473 | 2022-11-17 04:21:11 | Kaliningrad Oblast, Russia | |||
3570853 | 3570853 | 2022-09-19 | Russia | Tatarstan Republic | 171486 | 2003 | 0 | 55.7648572 | 52.43104273 | 2022-09-20 04:22:48 | Tatarstan Republic, Russia | |||
419592 | 419592 | 2022-09-18 | Russia | Tatarstan Republic | 170497 | 2003 | 0 | 55.7648572 | 52.43104273 | 2022-09-19 04:21:49 | Tatarstan Republic, Russia | |||
3373616 | 3373616 | 2022-09-17 | Russia | Tatarstan Republic | 169506 | 2003 | 0 | 55.7648572 | 52.43104273 | 2022-09-18 04:22:50 | Tatarstan Republic, Russia | |||
2355724 | 2355724 | 2022-09-16 | Russia | Tatarstan Republic | 168510 | 2003 | 0 | 55.7648572 | 52.43104273 | 2022-09-17 04:20:19 | Tatarstan Republic, Russia | |||
3986881 | 3986881 | 2022-09-15 | Russia | Tatarstan Republic | 167512 | 2003 | 0 | 55.7648572 | 52.43104273 | 2022-09-16 04:21:19 | Tatarstan Republic, Russia | |||
1889398 | 1889398 | 2022-09-14 | Russia | Tatarstan Republic | 166516 | 2003 | 0 | 55.7648572 | 52.43104273 | 2022-09-15 04:21:02 | Tatarstan Republic, Russia | |||
372453 | 372453 | 2022-09-13 | Russia | Tatarstan Republic | 165545 | 2003 | 0 | 55.7648572 | 52.43104273 | 2022-09-14 04:20:44 | Tatarstan Republic, Russia | |||
2395056 | 2395056 | 2022-09-12 | Russia | Tatarstan Republic | 164603 | 2003 | 0 | 55.7648572 | 52.43104273 | 2022-09-13 04:20:57 | Tatarstan Republic, Russia | |||
3766134 | 3766134 | 2022-09-11 | Russia | Tatarstan Republic | 163710 | 2003 | 0 | 55.7648572 | 52.43104273 | 2022-09-12 04:20:58 | Tatarstan Republic, Russia | |||
3824709 | 3824709 | 2022-09-10 | Russia | Tatarstan Republic | 162882 | 2003 | 0 | 55.7648572 | 52.43104273 | 2022-09-11 04:20:50 | Tatarstan Republic, Russia | |||
963166 | 963166 | 2022-09-09 | Russia | Tatarstan Republic | 162127 | 2003 | 0 | 55.7648572 | 52.43104273 | 2022-09-10 04:21:10 | Tatarstan Republic, Russia | |||
253568 | 253568 | 2022-09-08 | Russia | Tatarstan Republic | 161438 | 2003 | 0 | 55.7648572 | 52.43104273 | 2022-09-09 04:21:11 | Tatarstan Republic, Russia | |||
3745366 | 3745366 | 2022-09-07 | Russia | Tatarstan Republic | 160808 | 2003 | 0 | 55.7648572 | 52.43104273 | 2022-09-08 04:21:02 | Tatarstan Republic, Russia | |||
115006 | 115006 | 2022-09-06 | Russia | Tatarstan Republic | 160234 | 2003 | 0 | 55.7648572 | 52.43104273 | 2022-09-07 04:20:59 | Tatarstan Republic, Russia | |||
2633406 | 2633406 | 2022-09-05 | Australia | Queensland | 1615258 | 2003 | 0 | -27.4698 | 153.0251 | 2022-09-06 04:21:02 | Queensland, Australia | |||
2828876 | 2828876 | 2022-08-25 | Malaysia | Perak | 221553 | 2003 | 0 | 4.5921 | 101.0901 | 2022-08-26 04:21:02 | Perak, Malaysia | |||
2331376 | 2331376 | 2022-05-08 | Japan | Hokkaido | 309756 | 2003 | 0 | 43.385711 | 142.552318 | 2022-05-09 04:20:54 | Hokkaido, Japan | |||
2263888 | 2263888 | 2022-03-14 | Japan | Hyogo | 301692 | 2003 | 0 | 35.039913 | 134.828057 | 2022-03-15 04:20:47 | Hyogo, Japan | |||
2446750 | 2446750 | 2022-02-22 | Italy | Sardegna | 169105 | 2003 | 0 | 39.21531192 | 9.110616306 | 2022-02-23 04:21:09 | Sardegna, Italy | |||
1321889 | 1321889 | 2022-01-26 | Yemen | 10821 | 2003 | 0 | 15.552726999999999 | 48.516388 | 2022-01-27 04:21:19 | Yemen | ||||
2832702 | 2832702 | 2022-01-22 | Estonia | 287757 | 2003 | 0 | 58.5953 | 25.0136 | 2022-01-23 04:21:13 | Estonia | ||||
3613177 | 3613177 | 2022-01-12 | Mongolia | 712651 | 2003 | 0 | 46.8625 | 103.8467 | 2022-01-13 08:00:09 | Mongolia | ||||
1288696 | 1288696 | 2022-01-04 | US | Pennsylvania | Montgomery | 42091 | 116669 | 2003 | 0 | 40.21053671 | -75.36652296 | 2022-01-05 04:21:59 | Montgomery, Pennsylvania, US | |
3519374 | 3519374 | 2022-01-02 | India | Manipur | 125823 | 2003 | 0 | 24.738975 | 93.882541 | 2022-01-03 02:22:25 | Manipur, India | |||
3498653 | 3498653 | 2021-12-15 | US | Ohio | Franklin | 39049 | 186244 | 2003 | 0 | 39.96995815 | -83.01115755 | 2021-12-16 04:22:11 | Franklin, Ohio, US | |
554419 | 554419 | 2021-12-08 | Ukraine | Ternopil Oblast | 103919 | 2003 | 0 | 49.5535 | 25.5948 | 2021-12-09 04:22:49 | Ternopil Oblast, Ukraine | |||
3401155 | 3401155 | 2021-11-30 | Brazil | Amapa | 124634 | 2003 | 0 | 0.902 | -52.003 | 2021-12-01 04:22:29 | Amapa, Brazil | |||
149698 | 149698 | 2021-11-29 | Brazil | Amapa | 124574 | 2003 | 0 | 0.902 | -52.003 | 2021-11-30 04:22:53 | Amapa, Brazil | |||
3639637 | 3639637 | 2021-11-08 | Mexico | Colima | 33202 | 2003 | 0 | 19.1223 | -104.0072 | 2021-11-09 04:21:36 | Colima, Mexico | |||
2000745 | 2000745 | 2021-11-07 | Mexico | Colima | 33202 | 2003 | 0 | 19.1223 | -104.0072 | 2021-11-08 04:21:43 | Colima, Mexico | |||
1911390 | 1911390 | 2021-10-17 | US | New Jersey | Passaic | 34031 | 80984 | 2003 | 0 | 41.03238628 | -74.29954144 | 2021-10-18 04:21:10 | Passaic, New Jersey, US | |
936979 | 936979 | 2021-10-16 | US | New Jersey | Passaic | 34031 | 80939 | 2003 | 0 | 41.03238628 | -74.29954144 | 2021-10-17 04:21:29 | Passaic, New Jersey, US | |
2945534 | 2945534 | 2021-10-15 | US | New Jersey | Passaic | 34031 | 80864 | 2003 | 0 | 41.03238628 | -74.29954144 | 2021-10-16 04:21:15 | Passaic, New Jersey, US | |
3832220 | 3832220 | 2021-10-05 | Brazil | Roraima | 126238 | 2003 | 0 | -2.7376 | -62.0751 | 2021-10-06 04:21:33 | Roraima, Brazil | |||
986713 | 986713 | 2021-10-04 | Brazil | Roraima | 126238 | 2003 | 0 | -2.7376 | -62.0751 | 2021-10-05 04:21:27 | Roraima, Brazil | |||
1236757 | 1236757 | 2021-09-27 | US | Indiana | Marion | 18097 | 129908 | 2003 | 0 | 39.78163624 | -86.13826325 | 2021-09-28 04:21:28 | Marion, Indiana, US | |
812566 | 812566 | 2021-09-20 | US | Tennessee | Shelby | 47157 | 137320 | 2003 | 0 | 35.1864775 | -89.89692423 | 2021-09-21 04:21:26 | Shelby, Tennessee, US | |
69241 | 69241 | 2021-09-01 | US | New Jersey | Union | 34039 | 75633 | 2003 | 0 | 40.65835409 | -74.30680092 | 2021-09-02 04:21:15 | Union, New Jersey, US | |
3892263 | 3892263 | 2021-08-29 | Syria | 27654 | 2003 | 0 | 34.802075 | 38.99681500000001 | 2021-08-30 04:21:23 | Syria | ||||
1607879 | 1607879 | 2021-08-16 | United Arab Emirates | 702885 | 2003 | 0 | 23.424076 | 53.847818000000004 | 2021-08-17 04:21:49 | United Arab Emirates | ||||
2899947 | 2899947 | 2021-08-12 | Russia | Volgograd Oblast | 75158 | 2003 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-08-13 04:21:24 | Volgograd Oblast, Russia | |||
591223 | 591223 | 2021-08-08 | US | Massachusetts | Essex | 25009 | 99428 | 2003 | 0 | 42.6687626 | -70.94687179 | 2021-08-09 04:21:24 | Essex, Massachusetts, US | |
2205235 | 2205235 | 2021-08-07 | US | Massachusetts | Essex | 25009 | 99428 | 2003 | 0 | 42.6687626 | -70.94687179 | 2021-08-08 04:21:33 | Essex, Massachusetts, US | |
1119185 | 1119185 | 2021-08-06 | US | Massachusetts | Essex | 25009 | 99428 | 2003 | 0 | 42.6687626 | -70.94687179 | 2021-08-07 04:21:30 | Essex, Massachusetts, US | |
1958122 | 1958122 | 2021-08-05 | US | Massachusetts | Essex | 25009 | 99325 | 2003 | 0 | 42.6687626 | -70.94687179 | 2021-08-06 04:21:18 | Essex, Massachusetts, US | |
333501 | 333501 | 2021-08-04 | US | Massachusetts | Essex | 25009 | 99203 | 2003 | 0 | 42.6687626 | -70.94687179 | 2021-08-05 04:21:51 | Essex, Massachusetts, US | |
3469772 | 3469772 | 2021-08-03 | US | Massachusetts | Essex | 25009 | 99113 | 2003 | 0 | 42.6687626 | -70.94687179 | 2021-08-04 04:21:25 | Essex, Massachusetts, US | |
3685046 | 3685046 | 2021-08-02 | US | Massachusetts | Essex | 25009 | 99022 | 2003 | 0 | 42.6687626 | -70.94687179 | 2021-08-03 04:21:39 | Essex, Massachusetts, US | |
3683739 | 3683739 | 2021-08-02 | Spain | Asturias | 66962 | 2003 | 1063 | 63896 | 43.3614 | -5.8593 | 2021-08-03 04:21:39 | Asturias, Spain | ||
3016945 | 3016945 | 2021-08-01 | US | Massachusetts | Essex | 25009 | 98816 | 2003 | 0 | 42.6687626 | -70.94687179 | 2021-08-02 04:21:36 | Essex, Massachusetts, US | |
3905568 | 3905568 | 2021-07-31 | US | Massachusetts | Essex | 25009 | 98816 | 2003 | 0 | 42.6687626 | -70.94687179 | 2021-08-01 04:21:50 | Essex, Massachusetts, US | |
3297773 | 3297773 | 2021-07-30 | US | Massachusetts | Essex | 25009 | 98816 | 2003 | 0 | 42.6687626 | -70.94687179 | 2021-07-31 04:21:35 | Essex, Massachusetts, US | |
3296270 | 3296270 | 2021-07-30 | Mexico | Nayarit | 18495 | 2003 | 0 | 16492 | 21.7514 | -104.8455 | 2021-07-31 04:21:35 | Nayarit, Mexico | ||
3386984 | 3386984 | 2021-07-29 | US | Massachusetts | Essex | 25009 | 98743 | 2003 | 0 | 42.6687626 | -70.94687179 | 2021-07-30 04:21:34 | Essex, Massachusetts, US | |
409889 | 409889 | 2021-07-28 | US | Massachusetts | Essex | 25009 | 98685 | 2003 | 0 | 42.6687626 | -70.94687179 | 2021-07-29 04:21:33 | Essex, Massachusetts, US | |
2342035 | 2342035 | 2021-06-15 | US | Pennsylvania | Allegheny | 42003 | 102345 | 2003 | 0 | 40.46809875 | -79.98167747 | 2021-06-16 04:22:32 | Allegheny, Pennsylvania, US | |
2103965 | 2103965 | 2021-06-01 | Colombia | Bolivar | 102624 | 2003 | 98033 | 2588 | 8.6704 | -74.03 | 2021-06-02 04:24:34 | Bolivar, Colombia | ||
1188581 | 1188581 | 2021-05-31 | Colombia | Bolivar | 102624 | 2003 | 98033 | 2588 | 8.6704 | -74.03 | 2021-06-01 04:23:09 | Bolivar, Colombia | ||
1310018 | 1310018 | 2021-05-26 | Colombia | Huila | 57723 | 2003 | 54346 | 1374 | 2.5359 | -75.5277 | 2021-05-27 04:20:59 | Huila, Colombia | ||
83346 | 83346 | 2021-05-25 | Russia | Tula Oblast | 39817 | 2003 | 37341 | 473 | 53.9570701 | 37.3690909 | 2021-05-26 04:20:35 | Tula Oblast, Russia | ||
82948 | 82948 | 2021-05-25 | Colombia | Narino | 61136 | 2003 | 56870 | 2263 | 1.2892 | -77.3579 | 2021-05-26 04:20:35 | Narino, Colombia | ||
2255855 | 2255855 | 2021-05-19 | Netherlands | Gelderland | 180291 | 2003 | 0 | 177903 | 52.061738 | 5.939114 | 2021-05-20 04:21:05 | Gelderland, Netherlands | ||
2821344 | 2821344 | 2021-05-10 | US | California | Santa Clara | 6085 | 119556 | 2003 | 0 | 37.23104908 | -121.6970462 | 2021-05-11 04:20:41 | Santa Clara, California, US | |
1425676 | 1425676 | 2021-05-09 | US | California | Santa Clara | 6085 | 119531 | 2003 | 0 | 37.23104908 | -121.6970462 | 2021-05-10 04:20:38 | Santa Clara, California, US | |
1552544 | 1552544 | 2021-05-08 | US | California | Santa Clara | 6085 | 119484 | 2003 | 0 | 37.23104908 | -121.6970462 | 2021-05-09 04:20:35 | Santa Clara, California, US | |
2020905 | 2020905 | 2021-04-20 | Russia | Altai Krai | 48863 | 2003 | 43816 | 3044 | 52.6932243 | 82.69314240000001 | 2021-04-21 04:21:14 | Altai Krai, Russia | ||
2247554 | 2247554 | 2021-04-07 | Peru | Huanuco | 27318 | 2003 | 0 | 25315 | -9.421676 | -76.040642 | 2021-04-08 04:21:13 | Huanuco, Peru | ||
241204 | 241204 | 2021-04-02 | India | Jammu and Kashmir | 131938 | 2003 | 126720 | 3215 | 33.75943 | 76.612638 | 2021-04-03 04:20:44 | Jammu and Kashmir, India | ||
3643398 | 3643398 | 2021-03-30 | Colombia | Cordoba | 42887 | 2003 | 39619 | 1265 | 8.0493 | -75.574 | 2021-03-31 04:26:25 | Cordoba, Colombia | ||
1289890 | 1289890 | 2021-03-29 | El Salvador | 64431 | 2003 | 61640 | 788 | 13.7942 | -88.8965 | 2021-03-30 04:26:23 | El Salvador | |||
1798943 | 1798943 | 2021-03-23 | Sudan | 31147 | 2003 | 23858 | 5286 | 12.8628 | 30.2176 | 2021-03-24 05:25:40 | Sudan | |||
3978872 | 3978872 | 2021-02-10 | Spain | Galicia | 105475 | 2003 | 9204 | 94268 | 42.5751 | -8.1339 | 2021-02-11 05:23:55 | Galicia, Spain | ||
189958 | 189958 | 2021-01-11 | Ethiopia | 128616 | 2003 | 113563 | 13050 | 9.145 | 40.4897 | 2021-01-12 05:22:15 | Ethiopia | |||
3037925 | 3037925 | 2021-01-05 | Ukraine | Kiev | 114369 | 2003 | 40921 | 71445 | 50.4501 | 30.5234 | 2021-01-06 05:22:16 | Kiev, Ukraine | ||
860770 | 860770 | 2020-12-11 | Mexico | Oaxaca | 25819 | 2003 | 0 | 23816 | 17.0732 | -96.7266 | 2020-12-12 05:26:19 | Oaxaca, Mexico | ||
2848998 | 2848998 | 2020-09-18 | Peru | Junin | 17839 | 2003 | 0 | 15836 | -11.541783 | -74.876968 | 2020-09-19 04:22:00 | Junin, Peru | ||
1107806 | 1107806 | 2020-09-02 | US | New York | Suffolk | 36103 | 44940 | 2003 | 0 | 42937 | 40.88320119 | -72.8012172 | 2020-09-03 04:28:22 | Suffolk, New York, US |
3921667 | 3921667 | 2020-08-09 | US | Massachusetts | Middlesex | 25017 | 26420 | 2003 | 0 | 24417 | 42.48607732 | -71.39049229 | 2020-08-10 04:34:55 | Middlesex, Massachusetts, US |
526745 | 526745 | 2020-07-04 | US | New Jersey | Bergen | 34003 | 19732 | 2003 | 0 | 17729 | 40.96010917 | -74.07164325 | 2020-07-05 04:33:46 | Bergen, New Jersey, US |
1510846 | 1510846 | 2020-06-22 | Italy | Veneto | 19247 | 2003 | 16659 | 585 | 45.43490485 | 12.33845213 | 2020-06-23 04:33:22 | Veneto, Italy | ||
1864857 | 1864857 | 2020-05-22 | Brazil | Para | 22697 | 2003 | 0 | 19532 | -1.9981 | -54.9306 | 2020-05-23 02:32:42 | Para, Brazil |
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]);