johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
69 rows where deaths = 2847 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1074124 | 1074124 | 2022-12-28 | Russia | Kemerovo Oblast | 212840 | 2847 | 0 | 54.5335781 | 87.342861 | 2022-12-29 04:21:01 | Kemerovo Oblast, Russia | |||
1149014 | 1149014 | 2022-12-12 | Malaysia | W.P. Kuala Lumpur | 464864 | 2847 | 0 | 3.139 | 101.6869 | 2022-12-13 04:21:01 | W.P. Kuala Lumpur, Malaysia | |||
868868 | 868868 | 2022-12-11 | Malaysia | W.P. Kuala Lumpur | 464805 | 2847 | 0 | 3.139 | 101.6869 | 2022-12-12 04:21:01 | W.P. Kuala Lumpur, Malaysia | |||
257398 | 257398 | 2022-12-10 | Malaysia | W.P. Kuala Lumpur | 464743 | 2847 | 0 | 3.139 | 101.6869 | 2022-12-11 04:20:50 | W.P. Kuala Lumpur, Malaysia | |||
1621886 | 1621886 | 2022-11-22 | US | Massachusetts | Worcester | 25027 | 229554 | 2847 | 0 | 42.35026951 | -71.90493363 | 2022-11-23 04:21:06 | Worcester, Massachusetts, US | |
3461774 | 3461774 | 2022-11-21 | US | Massachusetts | Worcester | 25027 | 229554 | 2847 | 0 | 42.35026951 | -71.90493363 | 2022-11-22 04:20:47 | Worcester, Massachusetts, US | |
1641959 | 1641959 | 2022-11-20 | US | Massachusetts | Worcester | 25027 | 229554 | 2847 | 0 | 42.35026951 | -71.90493363 | 2022-11-21 04:21:05 | Worcester, Massachusetts, US | |
2065516 | 2065516 | 2022-11-19 | US | Massachusetts | Worcester | 25027 | 229554 | 2847 | 0 | 42.35026951 | -71.90493363 | 2022-11-20 04:21:08 | Worcester, Massachusetts, US | |
1756910 | 1756910 | 2022-11-18 | US | Massachusetts | Worcester | 25027 | 229554 | 2847 | 0 | 42.35026951 | -71.90493363 | 2022-11-19 04:21:14 | Worcester, Massachusetts, US | |
3027903 | 3027903 | 2022-11-17 | US | Massachusetts | Worcester | 25027 | 229554 | 2847 | 0 | 42.35026951 | -71.90493363 | 2022-11-18 04:21:15 | Worcester, Massachusetts, US | |
2274209 | 2274209 | 2022-10-20 | US | New York | Westchester | 36119 | 309286 | 2847 | 0 | 41.16278376 | -73.75741653 | 2022-10-21 04:22:23 | Westchester, New York, US | |
200544 | 200544 | 2022-10-19 | US | New York | Westchester | 36119 | 309063 | 2847 | 0 | 41.16278376 | -73.75741653 | 2022-10-20 04:22:59 | Westchester, New York, US | |
198528 | 198528 | 2022-10-19 | Russia | Yaroslavl Oblast | 183192 | 2847 | 0 | 57.7781976 | 39.0021095 | 2022-10-20 04:22:59 | Yaroslavl Oblast, Russia | |||
2757189 | 2757189 | 2022-10-18 | Russia | Yaroslavl Oblast | 182955 | 2847 | 0 | 57.7781976 | 39.0021095 | 2022-10-19 04:22:26 | Yaroslavl Oblast, Russia | |||
2025023 | 2025023 | 2022-10-17 | Russia | Yaroslavl Oblast | 182678 | 2847 | 0 | 57.7781976 | 39.0021095 | 2022-10-18 04:22:42 | Yaroslavl Oblast, Russia | |||
2159801 | 2159801 | 2022-10-16 | Russia | Yaroslavl Oblast | 182407 | 2847 | 0 | 57.7781976 | 39.0021095 | 2022-10-17 04:20:31 | Yaroslavl Oblast, Russia | |||
114754 | 114754 | 2022-09-06 | Japan | Kanagawa | 1390834 | 2847 | 0 | 35.415312 | 139.338983 | 2022-09-07 04:20:59 | Kanagawa, Japan | |||
880245 | 880245 | 2022-08-05 | Italy | Calabria | 505054 | 2847 | 0 | 38.90597598 | 16.59440194 | 2022-08-06 04:20:56 | Calabria, Italy | |||
3157927 | 3157927 | 2022-06-09 | Spain | Asturias | 233574 | 2847 | 0 | 43.3614 | -5.8593 | 2022-06-10 04:20:55 | Asturias, Spain | |||
1421394 | 1421394 | 2022-06-08 | Spain | Asturias | 233574 | 2847 | 0 | 43.3614 | -5.8593 | 2022-06-09 04:20:54 | Asturias, Spain | |||
3726508 | 3726508 | 2022-06-07 | Spain | Asturias | 233574 | 2847 | 0 | 43.3614 | -5.8593 | 2022-06-08 04:20:55 | Asturias, Spain | |||
229896 | 229896 | 2022-05-31 | US | Connecticut | New Haven | 9009 | 212631 | 2847 | 0 | 41.4080325 | -72.93620426 | 2022-06-01 04:20:55 | New Haven, Connecticut, US | |
3186661 | 3186661 | 2022-05-30 | US | Connecticut | New Haven | 9009 | 211937 | 2847 | 0 | 41.4080325 | -72.93620426 | 2022-05-31 04:20:51 | New Haven, Connecticut, US | |
3198810 | 3198810 | 2022-05-29 | US | Connecticut | New Haven | 9009 | 211937 | 2847 | 0 | 41.4080325 | -72.93620426 | 2022-05-30 04:20:50 | New Haven, Connecticut, US | |
2725688 | 2725688 | 2022-05-28 | US | Connecticut | New Haven | 9009 | 211937 | 2847 | 0 | 41.4080325 | -72.93620426 | 2022-05-29 04:20:53 | New Haven, Connecticut, US | |
1314869 | 1314869 | 2022-05-27 | US | Connecticut | New Haven | 9009 | 211937 | 2847 | 0 | 41.4080325 | -72.93620426 | 2022-05-28 04:21:07 | New Haven, Connecticut, US | |
1850661 | 1850661 | 2022-05-26 | US | Connecticut | New Haven | 9009 | 211752 | 2847 | 0 | 41.4080325 | -72.93620426 | 2022-05-27 04:20:56 | New Haven, Connecticut, US | |
3628207 | 3628207 | 2022-03-13 | Russia | Smolensk Oblast | 124310 | 2847 | 0 | 55.03434960000001 | 33.0192065 | 2022-03-14 04:20:46 | Smolensk Oblast, Russia | |||
1550147 | 1550147 | 2022-03-07 | US | New Jersey | Middlesex | 34023 | 189836 | 2847 | 0 | 40.43629879 | -74.41426991 | 2022-03-08 04:20:54 | Middlesex, New Jersey, US | |
1992991 | 1992991 | 2022-03-01 | Sweden | Vastra Gotaland | 427997 | 2847 | 0 | 58.2528 | 13.0596 | 2022-03-02 04:21:07 | Vastra Gotaland, Sweden | |||
943165 | 943165 | 2022-02-28 | Sweden | Vastra Gotaland | 427046 | 2847 | 0 | 58.2528 | 13.0596 | 2022-03-01 04:21:09 | Vastra Gotaland, Sweden | |||
2733356 | 2733356 | 2022-02-27 | Sweden | Vastra Gotaland | 427046 | 2847 | 0 | 58.2528 | 13.0596 | 2022-02-28 04:21:05 | Vastra Gotaland, Sweden | |||
3046509 | 3046509 | 2022-02-26 | Sweden | Vastra Gotaland | 427046 | 2847 | 0 | 58.2528 | 13.0596 | 2022-02-27 04:21:04 | Vastra Gotaland, Sweden | |||
575164 | 575164 | 2022-02-25 | Sweden | Vastra Gotaland | 427046 | 2847 | 0 | 58.2528 | 13.0596 | 2022-02-26 04:21:12 | Vastra Gotaland, Sweden | |||
3856050 | 3856050 | 2022-02-18 | Russia | Komi Republic | 138510 | 2847 | 0 | 63.9881421 | 54.3326073 | 2022-02-19 04:21:11 | Komi Republic, Russia | |||
3821011 | 3821011 | 2022-02-16 | US | California | Sacramento | 6067 | 295353 | 2847 | 0 | 38.45106826 | -121.34253740000001 | 2022-02-17 04:20:56 | Sacramento, California, US | |
1281760 | 1281760 | 2022-01-05 | Chile | Biobio | 168453 | 2847 | 0 | -37.4464 | -72.1416 | 2022-01-06 04:22:09 | Biobio, Chile | |||
1285776 | 1285776 | 2022-01-04 | Chile | Biobio | 168339 | 2847 | 0 | -37.4464 | -72.1416 | 2022-01-05 04:21:59 | Biobio, Chile | |||
1700120 | 1700120 | 2022-01-03 | Chile | Biobio | 168252 | 2847 | 0 | -37.4464 | -72.1416 | 2022-01-04 04:22:17 | Biobio, Chile | |||
782652 | 782652 | 2021-12-13 | Russia | Vladimir Oblast | 76408 | 2847 | 0 | 56.0503336 | 40.656163299999996 | 2021-12-14 04:22:38 | Vladimir Oblast, Russia | |||
550996 | 550996 | 2021-12-08 | Russia | Leningrad Oblast | 93444 | 2847 | 0 | 60.185329599999996 | 32.3925325 | 2021-12-09 04:22:49 | Leningrad Oblast, Russia | |||
600753 | 600753 | 2021-10-19 | US | Texas | El Paso | 48141 | 127020 | 2847 | 0 | 31.76980765 | -106.23632749999999 | 2021-10-20 04:21:00 | El Paso, Texas, US | |
16588 | 16588 | 2021-09-18 | Russia | Novosibirsk Oblast | 61534 | 2847 | 0 | 54.9720169 | 79.48139240000002 | 2021-09-19 04:21:34 | Novosibirsk Oblast, Russia | |||
2279191 | 2279191 | 2021-09-08 | Japan | Osaka | 185284 | 2847 | 0 | 34.620965000000005 | 135.507481 | 2021-09-09 04:21:27 | Osaka, Japan | |||
483697 | 483697 | 2021-07-19 | Mexico | Zacatecas | 31703 | 2847 | 0 | 28856 | 22.7709 | -102.5832 | 2021-07-20 04:21:48 | Zacatecas, Mexico | ||
2673920 | 2673920 | 2021-07-18 | Mexico | Zacatecas | 31673 | 2847 | 0 | 28826 | 22.7709 | -102.5832 | 2021-07-19 04:21:24 | Zacatecas, Mexico | ||
3706232 | 3706232 | 2021-07-17 | Mexico | Zacatecas | 31643 | 2847 | 0 | 28796 | 22.7709 | -102.5832 | 2021-07-18 04:22:07 | Zacatecas, Mexico | ||
579168 | 579168 | 2021-07-13 | Thailand | 353712 | 2847 | 26873 | 323992 | 15.870032 | 100.992541 | 2021-07-14 04:21:35 | Thailand | |||
2589863 | 2589863 | 2021-06-27 | Colombia | Tolima | 88653 | 2847 | 83097 | 2709 | 4.0925 | -75.1545 | 2021-06-28 04:21:29 | Tolima, Colombia | ||
563141 | 563141 | 2021-06-22 | Peru | San Martin | 45266 | 2847 | 0 | 42419 | -7.039531 | -76.729127 | 2021-06-23 04:21:46 | San Martin, Peru | ||
3358843 | 3358843 | 2021-06-21 | Peru | San Martin | 45266 | 2847 | 0 | 42419 | -7.039531 | -76.729127 | 2021-06-22 04:21:34 | San Martin, Peru | ||
2884542 | 2884542 | 2021-06-20 | Peru | San Martin | 45266 | 2847 | 0 | 42419 | -7.039531 | -76.729127 | 2021-06-21 04:21:41 | San Martin, Peru | ||
107625 | 107625 | 2021-06-19 | Peru | San Martin | 45266 | 2847 | 0 | 42419 | -7.039531 | -76.729127 | 2021-06-20 04:21:48 | San Martin, Peru | ||
1125768 | 1125768 | 2021-06-18 | Peru | San Martin | 45266 | 2847 | 0 | 42419 | -7.039531 | -76.729127 | 2021-06-19 04:22:33 | San Martin, Peru | ||
2911346 | 2911346 | 2021-06-17 | Peru | San Martin | 45266 | 2847 | 0 | 42419 | -7.039531 | -76.729127 | 2021-06-18 04:22:16 | San Martin, Peru | ||
3954666 | 3954666 | 2021-05-11 | Peru | Ucayali | 30459 | 2847 | 0 | 27612 | -9.621718 | -73.444929 | 2021-05-12 04:21:29 | Ucayali, Peru | ||
3954441 | 3954441 | 2021-05-11 | India | Jammu and Kashmir | 224898 | 2847 | 171350 | 50701 | 33.75943 | 76.612638 | 2021-05-12 04:21:29 | Jammu and Kashmir, India | ||
2824639 | 2824639 | 2021-05-01 | Colombia | Norte de Santander | 55206 | 2847 | 51329 | 1030 | 7.9463 | -72.8988 | 2021-05-02 04:20:48 | Norte de Santander, Colombia | ||
380047 | 380047 | 2021-04-30 | Colombia | Norte de Santander | 55039 | 2847 | 51147 | 1045 | 7.9463 | -72.8988 | 2021-05-01 04:20:47 | Norte de Santander, Colombia | ||
3131683 | 3131683 | 2021-04-18 | US | New Jersey | Essex | 34013 | 92705 | 2847 | 0 | 40.78681335 | -74.24657979 | 2021-04-19 04:20:57 | Essex, New Jersey, US | |
36677 | 36677 | 2021-04-12 | Russia | Sverdlovsk Oblast | 84083 | 2847 | 77559 | 3677 | 58.6414755 | 61.8021546 | 2021-04-13 04:20:37 | Sverdlovsk Oblast, Russia | ||
638151 | 638151 | 2021-03-31 | Russia | Nizhny Novgorod Oblast | 107452 | 2847 | 101555 | 3050 | 55.47180329999999 | 44.0911594 | 2021-04-01 04:27:05 | Nizhny Novgorod Oblast, Russia | ||
3257799 | 3257799 | 2021-03-02 | United Kingdom | Northern Ireland | 112780 | 2847 | 0 | 110721 | 54.7877 | -6.4923 | 2021-03-03 05:23:28 | Northern Ireland, United Kingdom | ||
1000032 | 1000032 | 2021-03-01 | US | Massachusetts | Middlesex | 25017 | 112066 | 2847 | 0 | 108622 | 42.48607732 | -71.39049229 | 2021-03-02 05:23:30 | Middlesex, Massachusetts, US |
3065921 | 3065921 | 2021-02-27 | Germany | Thuringen | 75947 | 2847 | 68343 | 5089 | 51.011 | 10.8453 | 2021-02-28 05:22:20 | Thuringen, Germany | ||
1687558 | 1687558 | 2021-02-02 | US | Texas | Dallas | 48113 | 236273 | 2847 | 0 | 258535 | 32.76670599 | -96.7779605 | 2021-02-03 05:22:52 | Dallas, Texas, US |
2406778 | 2406778 | 2020-12-23 | India | Haryana | 259226 | 2847 | 251149 | 5230 | 29.20004 | 76.332824 | 2020-12-24 05:23:04 | Haryana, India | ||
1822541 | 1822541 | 2020-10-04 | Brazil | Santa Catarina | 219218 | 2847 | 208547 | 7824 | -27.2423 | -50.2189 | 2020-10-05 04:23:33 | Santa Catarina, Brazil | ||
207929 | 207929 | 2020-08-19 | US | Michigan | Wayne | 26163 | 29517 | 2847 | 0 | 26670 | 42.28098405 | -83.281255 | 2020-08-20 04:27:43 | Wayne, Michigan, 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]);