johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
65 rows where deaths = 2414 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 17
- US 25
- Russia 10
- Ukraine 6
- Canada 5
- Mexico 4
- Spain 3
- Colombia 2
- Afghanistan 1
- Brazil 1
- Denmark 1
- Dominican Republic 1
- El Salvador 1
- Germany 1
- Kuwait 1
- Montenegro 1
- Panama 1
- Peru 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1988217 | 1988217 | 2022-12-07 | US | Wisconsin | Milwaukee | 55079 | 327916 | 2414 | 0 | 43.00486062 | -87.96733172 | 2022-12-08 04:21:07 | Milwaukee, Wisconsin, US | |
2488185 | 2488185 | 2022-11-16 | US | New Jersey | Passaic | 34031 | 178803 | 2414 | 0 | 41.03238628 | -74.29954144 | 2022-11-17 04:21:11 | Passaic, New Jersey, US | |
993686 | 993686 | 2022-08-16 | US | Pennsylvania | Montgomery | 42091 | 177313 | 2414 | 0 | 40.21053671 | -75.36652296 | 2022-08-17 04:20:59 | Montgomery, Pennsylvania, US | |
2497678 | 2497678 | 2022-08-15 | Ukraine | Sevastopol* | 86890 | 2414 | 0 | 44.6054 | 33.522 | 2022-08-16 04:20:58 | Sevastopol*, Ukraine | |||
2496725 | 2496725 | 2022-08-15 | US | Pennsylvania | Montgomery | 42091 | 177313 | 2414 | 0 | 40.21053671 | -75.36652296 | 2022-08-16 04:20:58 | Montgomery, Pennsylvania, US | |
3651228 | 3651228 | 2022-08-14 | Ukraine | Sevastopol* | 86777 | 2414 | 0 | 44.6054 | 33.522 | 2022-08-15 04:20:59 | Sevastopol*, Ukraine | |||
3650275 | 3650275 | 2022-08-14 | US | Pennsylvania | Montgomery | 42091 | 177313 | 2414 | 0 | 40.21053671 | -75.36652296 | 2022-08-15 04:20:59 | Montgomery, Pennsylvania, US | |
1972234 | 1972234 | 2022-08-13 | Ukraine | Sevastopol* | 86632 | 2414 | 0 | 44.6054 | 33.522 | 2022-08-14 04:20:55 | Sevastopol*, Ukraine | |||
1971281 | 1971281 | 2022-08-13 | US | Pennsylvania | Montgomery | 42091 | 177313 | 2414 | 0 | 40.21053671 | -75.36652296 | 2022-08-14 04:20:55 | Montgomery, Pennsylvania, US | |
2892043 | 2892043 | 2022-08-12 | Ukraine | Sevastopol* | 86420 | 2414 | 0 | 44.6054 | 33.522 | 2022-08-13 04:20:52 | Sevastopol*, Ukraine | |||
2891090 | 2891090 | 2022-08-12 | US | Pennsylvania | Montgomery | 42091 | 177313 | 2414 | 0 | 40.21053671 | -75.36652296 | 2022-08-13 04:20:52 | Montgomery, Pennsylvania, US | |
3910695 | 3910695 | 2022-08-11 | US | Pennsylvania | Montgomery | 42091 | 177313 | 2414 | 0 | 40.21053671 | -75.36652296 | 2022-08-12 04:20:54 | Montgomery, Pennsylvania, US | |
3910189 | 3910189 | 2022-08-11 | US | New Jersey | Union | 34039 | 170447 | 2414 | 0 | 40.65835409 | -74.30680092 | 2022-08-12 04:20:54 | Union, New Jersey, US | |
1349012 | 1349012 | 2022-08-10 | US | Pennsylvania | Montgomery | 42091 | 177313 | 2414 | 0 | 40.21053671 | -75.36652296 | 2022-08-11 04:20:49 | Montgomery, Pennsylvania, US | |
1348506 | 1348506 | 2022-08-10 | US | New Jersey | Union | 34039 | 170250 | 2414 | 0 | 40.65835409 | -74.30680092 | 2022-08-11 04:20:49 | Union, New Jersey, US | |
2741227 | 2741227 | 2022-07-07 | Russia | Khakassia Republic | 88189 | 2414 | 0 | 53.72258845 | 91.44293627 | 2022-07-08 04:20:56 | Khakassia Republic, Russia | |||
3365411 | 3365411 | 2022-07-02 | Mexico | Chiapas | 39945 | 2414 | 0 | 16.7569 | -93.1292 | 2022-07-03 04:20:59 | Chiapas, Mexico | |||
593740 | 593740 | 2022-07-01 | Mexico | Chiapas | 39945 | 2414 | 0 | 16.7569 | -93.1292 | 2022-07-02 04:21:16 | Chiapas, Mexico | |||
3940141 | 3940141 | 2022-06-30 | Mexico | Chiapas | 39886 | 2414 | 0 | 16.7569 | -93.1292 | 2022-07-01 04:21:10 | Chiapas, Mexico | |||
3133805 | 3133805 | 2022-06-03 | Russia | Tambov Oblast | 116982 | 2414 | 0 | 52.9019574 | 41.3578918 | 2022-06-04 04:20:58 | Tambov Oblast, Russia | |||
3578880 | 3578880 | 2022-06-02 | Russia | Tambov Oblast | 116952 | 2414 | 0 | 52.9019574 | 41.3578918 | 2022-06-03 04:20:58 | Tambov Oblast, Russia | |||
971173 | 971173 | 2022-06-01 | Russia | Tambov Oblast | 116925 | 2414 | 0 | 52.9019574 | 41.3578918 | 2022-06-02 05:20:39 | Tambov Oblast, Russia | |||
3671942 | 3671942 | 2022-02-15 | Spain | Asturias | 188565 | 2414 | 0 | 43.3614 | -5.8593 | 2022-02-16 04:21:10 | Asturias, Spain | |||
1293872 | 1293872 | 2022-02-05 | Colombia | Meta | 102068 | 2414 | 0 | 3.272 | -73.0877 | 2022-02-06 04:21:00 | Meta, Colombia | |||
2327200 | 2327200 | 2022-02-04 | Colombia | Meta | 101734 | 2414 | 0 | 3.272 | -73.0877 | 2022-02-05 04:21:05 | Meta, Colombia | |||
1320679 | 1320679 | 2022-01-26 | US | Ohio | Franklin | 39049 | 274393 | 2414 | 0 | 39.96995815 | -83.01115755 | 2022-01-27 04:21:19 | Franklin, Ohio, US | |
1114254 | 1114254 | 2022-01-11 | US | Connecticut | Fairfield | 9001 | 171407 | 2414 | 0 | 41.26809896 | -73.3881171 | 2022-01-12 04:21:44 | Fairfield, Connecticut, US | |
1215817 | 1215817 | 2022-01-08 | Russia | Smolensk Oblast | 85632 | 2414 | 0 | 55.03434960000001 | 33.0192065 | 2022-01-09 04:21:46 | Smolensk Oblast, Russia | |||
2167676 | 2167676 | 2022-01-01 | Montenegro | 171873 | 2414 | 0 | 42.708678000000006 | 19.37439 | 2022-01-02 04:20:52 | Montenegro | ||||
1432315 | 1432315 | 2021-12-28 | Canada | British Columbia | 235658 | 2414 | 0 | 53.7267 | -127.6476 | 2021-12-29 03:21:43 | British Columbia, Canada | |||
730276 | 730276 | 2021-12-27 | Canada | British Columbia | 235658 | 2414 | 0 | 53.7267 | -127.6476 | 2021-12-28 04:21:47 | British Columbia, Canada | |||
2111448 | 2111448 | 2021-12-26 | Canada | British Columbia | 235658 | 2414 | 0 | 53.7267 | -127.6476 | 2021-12-27 04:21:58 | British Columbia, Canada | |||
3604820 | 3604820 | 2021-12-25 | Canada | British Columbia | 235658 | 2414 | 0 | 53.7267 | -127.6476 | 2021-12-26 04:21:50 | British Columbia, Canada | |||
2963138 | 2963138 | 2021-12-24 | Canada | British Columbia | 235658 | 2414 | 0 | 53.7267 | -127.6476 | 2021-12-25 04:21:37 | British Columbia, Canada | |||
3498361 | 3498361 | 2021-12-15 | US | New Jersey | Hudson | 34017 | 103247 | 2414 | 0 | 40.73766234 | -74.07515667 | 2021-12-16 04:22:11 | Hudson, New Jersey, US | |
2090146 | 2090146 | 2021-12-14 | US | New Jersey | Hudson | 34017 | 102974 | 2414 | 0 | 40.73766234 | -74.07515667 | 2021-12-15 03:22:16 | Hudson, New Jersey, US | |
1662598 | 1662598 | 2021-12-12 | US | New Jersey | Hudson | 34017 | 102561 | 2414 | 0 | 40.73766234 | -74.07515667 | 2021-12-13 04:22:02 | Hudson, New Jersey, US | |
1666614 | 1666614 | 2021-12-11 | US | New Jersey | Hudson | 34017 | 102374 | 2414 | 0 | 40.73766234 | -74.07515667 | 2021-12-12 04:22:12 | Hudson, New Jersey, US | |
552952 | 552952 | 2021-12-08 | US | New Jersey | Ocean | 34029 | 104468 | 2414 | 0 | 39.8895449 | -74.28089251 | 2021-12-09 04:22:49 | Ocean, New Jersey, US | |
3289178 | 3289178 | 2021-11-18 | Russia | Vologda Oblast | 85361 | 2414 | 0 | 60.0391461 | 43.1215213 | 2021-11-19 04:21:40 | Vologda Oblast, Russia | |||
717112 | 717112 | 2021-11-12 | US | Pennsylvania | Allegheny | 42003 | 139322 | 2414 | 0 | 40.46809875 | -79.98167747 | 2021-11-13 04:21:38 | Allegheny, Pennsylvania, US | |
28645 | 28645 | 2021-11-11 | Russia | Murmansk Oblast | 81863 | 2414 | 0 | 68.00004179999999 | 33.9999151 | 2021-11-12 04:22:01 | Murmansk Oblast, Russia | |||
3492408 | 3492408 | 2021-10-26 | Russia | Omsk Oblast | 94652 | 2414 | 0 | 56.09352629999999 | 73.5099936 | 2021-10-27 04:22:32 | Omsk Oblast, Russia | |||
2959572 | 2959572 | 2021-10-08 | Russia | Chuvashia Republic | 34711 | 2414 | 0 | 55.4259922 | 47.0849429 | 2021-10-09 04:21:34 | Chuvashia Republic, Russia | |||
1237819 | 1237819 | 2021-09-27 | US | New Jersey | Middlesex | 34023 | 102859 | 2414 | 0 | 40.43629879 | -74.41426991 | 2021-09-28 04:21:28 | Middlesex, New Jersey, US | |
3450807 | 3450807 | 2021-09-10 | US | Missouri | St. Louis | 29189 | 119948 | 2414 | 0 | 38.63770039999999 | -90.4458375 | 2021-09-11 04:21:30 | St. Louis, Missouri, US | |
1596262 | 1596262 | 2021-08-26 | Kuwait | 409009 | 2414 | 0 | 29.311659999999996 | 47.481766 | 2021-08-27 04:21:37 | Kuwait | ||||
2693572 | 2693572 | 2021-07-06 | El Salvador | 80235 | 2414 | 73590 | 4231 | 13.7942 | -88.8965 | 2021-07-07 04:21:20 | El Salvador | |||
2914816 | 2914816 | 2021-06-17 | Ukraine | Zaporizhia Oblast | 104208 | 2414 | 100873 | 921 | 47.8388 | 35.1396 | 2021-06-18 04:22:16 | Zaporizhia Oblast, Ukraine | ||
3971000 | 3971000 | 2021-06-11 | US | Arizona | Pima | 4019 | 116903 | 2414 | 0 | 32.0971334 | -111.7890033 | 2021-06-12 04:22:22 | Pima, Arizona, US | |
523153 | 523153 | 2021-06-09 | Spain | Galicia | 127731 | 2414 | 9204 | 116113 | 42.5751 | -8.1339 | 2021-06-10 04:23:17 | Galicia, Spain | ||
3472593 | 3472593 | 2021-06-08 | Spain | Galicia | 127656 | 2414 | 9204 | 116038 | 42.5751 | -8.1339 | 2021-06-09 04:23:31 | Galicia, Spain | ||
51027 | 51027 | 2021-05-29 | Russia | Perm Krai | 57275 | 2414 | 51525 | 3336 | 58.5951603 | 56.3159546 | 2021-05-30 04:20:55 | Perm Krai, Russia | ||
1808397 | 1808397 | 2021-05-27 | US | Michigan | Macomb | 26099 | 99481 | 2414 | 0 | 42.69158356 | -82.92752801 | 2021-05-28 04:20:36 | Macomb, Michigan, US | |
2004763 | 2004763 | 2021-05-12 | Mexico | Tlaxcala | 19647 | 2414 | 0 | 17233 | 19.3139 | -98.2404 | 2021-05-13 04:20:51 | Tlaxcala, Mexico | ||
2020477 | 2020477 | 2021-04-20 | Brazil | Tocantins | 154764 | 2414 | 133331 | 18399 | -10.1753 | -48.2982 | 2021-04-21 04:21:14 | Tocantins, Brazil | ||
1535805 | 1535805 | 2021-03-28 | Denmark | 228013 | 2414 | 216590 | 9009 | 56.2639 | 9.5018 | 2021-03-29 04:28:35 | Denmark | |||
2367417 | 2367417 | 2021-02-28 | Germany | Sachsen-Anhalt | 60472 | 2414 | 54557 | 3870 | 51.9503 | 11.6923 | 2021-03-01 05:23:01 | Sachsen-Anhalt, Germany | ||
1937169 | 1937169 | 2021-02-23 | US | Florida | Palm Beach | 12099 | 118151 | 2414 | 0 | 115737 | 26.64676272 | -80.46536002 | 2021-02-24 05:29:16 | Palm Beach, Florida, US |
1527585 | 1527585 | 2021-02-09 | Afghanistan | 55384 | 2414 | 48109 | 4861 | 33.93911 | 67.709953 | 2021-02-10 05:22:41 | Afghanistan | |||
1591800 | 1591800 | 2021-02-05 | Ukraine | Kiev | 129827 | 2414 | 77813 | 49600 | 50.4501 | 30.5234 | 2021-02-06 05:23:55 | Kiev, Ukraine | ||
3695372 | 3695372 | 2020-12-31 | Dominican Republic | 170785 | 2414 | 131185 | 37186 | 18.7357 | -70.1627 | 2021-01-01 05:23:07 | Dominican Republic | |||
2514315 | 2514315 | 2020-10-03 | Panama | 114653 | 2414 | 91195 | 21044 | 8.538 | -80.7821 | 2020-10-04 04:23:44 | Panama | |||
2729151 | 2729151 | 2020-09-15 | Peru | Ancash | 20530 | 2414 | 0 | 18116 | -9.407125 | -77.67179499999997 | 2020-09-16 04:22:53 | Ancash, Peru | ||
549845 | 549845 | 2020-09-12 | US | Texas | Harris | 48201 | 155479 | 2414 | 0 | 112735 | 29.85864939 | -95.39339521 | 2020-09-13 04:30:52 | Harris, Texas, 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]);