johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
63 rows where deaths = 1952 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
348541 | 348541 | 2022-12-14 | Russia | Pskov Oblast | 125774 | 1952 | 0 | 57.5358729 | 28.8586826 | 2022-12-15 04:20:58 | Pskov Oblast, Russia | |||
308129 | 308129 | 2022-12-13 | Russia | Pskov Oblast | 125756 | 1952 | 0 | 57.5358729 | 28.8586826 | 2022-12-14 04:21:04 | Pskov Oblast, Russia | |||
1149190 | 1149190 | 2022-12-12 | Russia | Pskov Oblast | 125743 | 1952 | 0 | 57.5358729 | 28.8586826 | 2022-12-13 04:21:01 | Pskov Oblast, Russia | |||
869044 | 869044 | 2022-12-11 | Russia | Pskov Oblast | 125730 | 1952 | 0 | 57.5358729 | 28.8586826 | 2022-12-12 04:21:01 | Pskov Oblast, Russia | |||
2529621 | 2529621 | 2022-10-06 | Russia | Orel Oblast | 131543 | 1952 | 0 | 52.9685433 | 36.0692477 | 2022-10-07 04:23:08 | Orel Oblast, Russia | |||
1811015 | 1811015 | 2022-10-05 | Russia | Orel Oblast | 131361 | 1952 | 0 | 52.9685433 | 36.0692477 | 2022-10-06 04:21:22 | Orel Oblast, Russia | |||
130989 | 130989 | 2022-10-04 | Russia | Orel Oblast | 131145 | 1952 | 0 | 52.9685433 | 36.0692477 | 2022-10-05 04:23:06 | Orel Oblast, Russia | |||
114958 | 114958 | 2022-09-06 | Russia | Kaliningrad Oblast | 178804 | 1952 | 0 | 54.7293041 | 21.1489473 | 2022-09-07 04:20:59 | Kaliningrad Oblast, Russia | |||
2633930 | 2633930 | 2022-09-05 | Russia | Kaliningrad Oblast | 178613 | 1952 | 0 | 54.7293041 | 21.1489473 | 2022-09-06 04:21:02 | Kaliningrad Oblast, Russia | |||
2987494 | 2987494 | 2022-09-04 | Russia | Kaliningrad Oblast | 178432 | 1952 | 0 | 54.7293041 | 21.1489473 | 2022-09-05 04:21:01 | Kaliningrad Oblast, Russia | |||
1250777 | 1250777 | 2022-08-23 | Japan | Saitama | 1000578 | 1952 | 0 | 35.997101 | 139.347635 | 2022-08-24 04:20:46 | Saitama, Japan | |||
1608323 | 1608323 | 2022-07-20 | Malaysia | Perak | 211939 | 1952 | 0 | 4.5921 | 101.0901 | 2022-07-21 04:21:10 | Perak, Malaysia | |||
1397934 | 1397934 | 2022-05-06 | Russia | Primorsky Krai | 174326 | 1952 | 0 | 45.0819456 | 134.726645 | 2022-05-07 04:21:09 | Primorsky Krai, Russia | |||
2598289 | 2598289 | 2022-05-05 | Russia | Primorsky Krai | 174269 | 1952 | 0 | 45.0819456 | 134.726645 | 2022-05-06 04:21:00 | Primorsky Krai, Russia | |||
3206262 | 3206262 | 2022-04-11 | Japan | Hokkaido | 244950 | 1952 | 0 | 43.385711 | 142.55231799999999 | 2022-04-12 04:20:49 | Hokkaido, Japan | |||
1656413 | 1656413 | 2022-03-19 | Japan | Kanagawa | 557572 | 1952 | 0 | 35.415312 | 139.338983 | 2022-03-20 04:20:45 | Kanagawa, Japan | |||
3912265 | 3912265 | 2022-02-20 | Russia | Sakha (Yakutiya) Republic | 149569 | 1952 | 0 | 66.941626 | 129.642371 | 2022-02-21 04:21:05 | Sakha (Yakutiya) Republic, Russia | |||
3075631 | 3075631 | 2022-02-09 | US | Maryland | Montgomery | 24031 | 163152 | 1952 | 0 | 39.13676329 | -77.20358245 | 2022-02-10 04:21:14 | Montgomery, Maryland, US | |
3061839 | 3061839 | 2022-01-29 | Colombia | Quindio | 68643 | 1952 | 0 | 4.461 | -75.6674 | 2022-01-30 04:21:26 | Quindio, Colombia | |||
2052689 | 2052689 | 2022-01-25 | US | Georgia | Fulton | 13121 | 198398 | 1952 | 0 | 33.79216944 | -84.46319413 | 2022-01-26 04:21:07 | Fulton, Georgia, US | |
1254888 | 1254888 | 2021-12-20 | Mozambique | 160457 | 1952 | 0 | -18.665695 | 35.529562 | 2021-12-21 03:21:27 | Mozambique | ||||
2903831 | 2903831 | 2021-12-19 | Mozambique | 159904 | 1952 | 0 | -18.665695 | 35.529562 | 2021-12-20 04:21:43 | Mozambique | ||||
2199298 | 2199298 | 2021-12-03 | Yemen | 10020 | 1952 | 0 | 15.552726999999999 | 48.516388 | 2021-12-04 04:22:18 | Yemen | ||||
714668 | 714668 | 2021-11-12 | Russia | Ivanovo Oblast | 58068 | 1952 | 0 | 56.9167446 | 41.43521370000001 | 2021-11-13 04:21:38 | Ivanovo Oblast, Russia | |||
30679 | 30679 | 2021-11-11 | US | New York | Richmond | 36085 | 90580 | 1952 | 0 | 40.58582155 | -74.14808598 | 2021-11-12 04:22:01 | Richmond, New York, US | |
495845 | 495845 | 2021-11-06 | Russia | Bryansk Oblast | 79355 | 1952 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-11-07 04:21:53 | Bryansk Oblast, Russia | |||
698654 | 698654 | 2021-11-04 | Russia | Smolensk Oblast | 64141 | 1952 | 0 | 55.03434960000001 | 33.0192065 | 2021-11-05 04:21:54 | Smolensk Oblast, Russia | |||
4725 | 4725 | 2021-10-28 | US | Alabama | Jefferson | 1073 | 115591 | 1952 | 0 | 33.55554728 | -86.89506300000002 | 2021-10-29 04:22:03 | Jefferson, Alabama, US | |
4536 | 4536 | 2021-10-28 | Russia | Astrakhan Oblast | 65522 | 1952 | 0 | 47.1878186 | 47.608851 | 2021-10-29 04:22:03 | Astrakhan Oblast, Russia | |||
3493780 | 3493780 | 2021-10-26 | US | Massachusetts | Worcester | 25027 | 95437 | 1952 | 0 | 42.35026951 | -71.90493363 | 2021-10-27 04:22:32 | Worcester, Massachusetts, US | |
773994 | 773994 | 2021-10-23 | Ukraine | Vinnytsia Oblast | 81388 | 1952 | 0 | 49.2331 | 28.4682 | 2021-10-24 04:21:22 | Vinnytsia Oblast, Ukraine | |||
770403 | 770403 | 2021-10-23 | Malaysia | Kedah | 145532 | 1952 | 0 | 6.1184 | 100.3685 | 2021-10-24 04:21:22 | Kedah, Malaysia | |||
654050 | 654050 | 2021-10-22 | Malaysia | Kedah | 145187 | 1952 | 0 | 6.1184 | 100.3685 | 2021-10-23 04:21:32 | Kedah, Malaysia | |||
990627 | 990627 | 2021-10-04 | Ukraine | Zhytomyr Oblast | 95938 | 1952 | 0 | 50.2547 | 28.6587 | 2021-10-05 04:21:27 | Zhytomyr Oblast, Ukraine | |||
2132101 | 2132101 | 2021-10-01 | Mexico | Campeche | 22871 | 1952 | 0 | 19.8301 | -90.5349 | 2021-10-02 04:21:25 | Campeche, Mexico | |||
1235907 | 1235907 | 2021-09-27 | Russia | Vladimir Oblast | 53647 | 1952 | 0 | 56.0503336 | 40.656163299999996 | 2021-09-28 04:21:28 | Vladimir Oblast, Russia | |||
1375602 | 1375602 | 2021-09-15 | US | Indiana | Marion | 18097 | 125200 | 1952 | 0 | 39.78163624 | -86.13826325 | 2021-09-16 04:22:19 | Marion, Indiana, US | |
509859 | 509859 | 2021-08-14 | US | New Jersey | Passaic | 34031 | 75111 | 1952 | 0 | 41.03238628 | -74.29954144 | 2021-08-15 04:21:41 | Passaic, New Jersey, US | |
2674034 | 2674034 | 2021-07-18 | Russia | Leningrad Oblast | 52924 | 1952 | 46159 | 4813 | 60.1853296 | 32.3925325 | 2021-07-19 04:21:24 | Leningrad Oblast, Russia | ||
2255582 | 2255582 | 2021-05-19 | Colombia | Huila | 56255 | 1952 | 53027 | 1276 | 2.5359 | -75.5277 | 2021-05-20 04:21:05 | Huila, Colombia | ||
3053977 | 3053977 | 2021-05-13 | Chile | Biobio | 120907 | 1952 | 115987 | 2968 | -37.4464 | -72.1416 | 2021-05-14 04:20:41 | Biobio, Chile | ||
2004946 | 2004946 | 2021-05-12 | Spain | Asturias | 51403 | 1952 | 1063 | 48388 | 43.3614 | -5.8593 | 2021-05-13 04:20:51 | Asturias, Spain | ||
3954777 | 3954777 | 2021-05-11 | Spain | Asturias | 51356 | 1952 | 1063 | 48341 | 43.3614 | -5.8593 | 2021-05-12 04:21:29 | Asturias, Spain | ||
3115076 | 3115076 | 2021-05-06 | US | Massachusetts | Essex | 25009 | 96089 | 1952 | 0 | 42.6687626 | -70.94687179 | 2021-05-07 04:20:40 | Essex, Massachusetts, US | |
1639938 | 1639938 | 2021-04-29 | Ukraine | Ivano-Frankivsk Oblast | 83766 | 1952 | 77089 | 4725 | 48.9226 | 24.7111 | 2021-04-30 04:21:03 | Ivano-Frankivsk Oblast, Ukraine | ||
1798836 | 1798836 | 2021-03-23 | Russia | Irkutsk Oblast | 60209 | 1952 | 57260 | 997 | 56.6370122 | 104.719221 | 2021-03-24 05:25:40 | Irkutsk Oblast, Russia | ||
702168 | 702168 | 2021-03-16 | Canada | Alberta | 139143 | 1952 | 132415 | 4776 | 53.9333 | -116.5765 | 2021-03-17 05:25:07 | Alberta, Canada | ||
616135 | 616135 | 2021-02-08 | US | Ohio | Cuyahoga | 39035 | 91318 | 1952 | 0 | 89365 | 41.424119 | -81.65918339 | 2021-02-09 05:23:30 | Cuyahoga, Ohio, US |
975062 | 975062 | 2021-02-06 | Pakistan | Khyber Pakhtunkhwa | 68338 | 1952 | 63953 | 2433 | 34.485332 | 72.09169 | 2021-02-07 05:23:00 | Khyber Pakhtunkhwa, Pakistan | ||
1590447 | 1590447 | 2021-02-05 | US | New York | Westchester | 36119 | 96465 | 1952 | 0 | 94513 | 41.16278376 | -73.75741653 | 2021-02-06 05:23:55 | Westchester, New York, US |
3308767 | 3308767 | 2021-01-13 | US | California | San Diego | 6073 | 211648 | 1952 | 0 | 209696 | 33.03484597 | -116.7365326 | 2021-01-14 05:22:32 | San Diego, California, US |
3859927 | 3859927 | 2020-12-04 | Mexico | Quintana Roo | 14645 | 1952 | 0 | 12693 | 19.1817 | -88.4791 | 2020-12-05 05:27:36 | Quintana Roo, Mexico | ||
3192671 | 3192671 | 2020-11-22 | US | Pennsylvania | Philadelphia | 42101 | 61136 | 1952 | 0 | 59184 | 40.00338507 | -75.1379271 | 2020-11-23 05:25:26 | Philadelphia, Pennsylvania, US |
3189685 | 3189685 | 2020-11-22 | Armenia | 126224 | 1952 | 94090 | 30182 | 40.0691 | 45.0382 | 2020-11-23 05:25:26 | Armenia | |||
3839165 | 3839165 | 2020-11-21 | US | Pennsylvania | Philadelphia | 42101 | 60378 | 1952 | 0 | 58426 | 40.00338507 | -75.1379271 | 2020-11-22 05:25:45 | Philadelphia, Pennsylvania, US |
2704193 | 2704193 | 2020-11-20 | US | Pennsylvania | Philadelphia | 42101 | 59475 | 1952 | 0 | 57523 | 40.00338507 | -75.1379271 | 2020-11-21 05:25:51 | Philadelphia, Pennsylvania, US |
3412547 | 3412547 | 2020-11-01 | US | Texas | Hidalgo | 48215 | 42785 | 1952 | 0 | 33833 | 26.39418217 | -98.18299696 | 2020-11-02 05:25:04 | Hidalgo, Texas, US |
2083036 | 2083036 | 2020-10-31 | US | Texas | Hidalgo | 48215 | 42747 | 1952 | 0 | 33833 | 26.39418217 | -98.18299696 | 2020-11-01 04:36:19 | Hidalgo, Texas, US |
2246489 | 2246489 | 2020-10-30 | US | Texas | Hidalgo | 48215 | 42701 | 1952 | 0 | 33833 | 26.39418217 | -98.18299696 | 2020-10-31 04:24:44 | Hidalgo, Texas, US |
546911 | 546911 | 2020-09-12 | Peru | Junin | 16864 | 1952 | 0 | 14912 | -11.541783 | -74.876968 | 2020-09-13 04:30:52 | Junin, Peru | ||
2708777 | 2708777 | 2020-07-17 | Pakistan | Sindh | 111238 | 1952 | 88103 | 21183 | 26.009446 | 68.77680699999999 | 2020-07-18 04:34:45 | Sindh, Pakistan | ||
2748477 | 2748477 | 2020-07-15 | Romania | 34226 | 1952 | 22049 | 10225 | 45.9432 | 24.9668 | 2020-07-16 04:44:59 | Romania | |||
1837176 | 1837176 | 2020-06-14 | Mexico | Mexico | 23359 | 1952 | 18704 | 2703 | 19.4969 | -99.7233 | 2020-06-15 03:33:14 | Mexico, Mexico |
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]);