johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
68 rows where deaths = 3247 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
348516 | 348516 | 2022-12-14 | Russia | Komi Republic | 191903 | 3247 | 0 | 63.9881421 | 54.3326073 | 2022-12-15 04:20:58 | Komi Republic, Russia | |||
308104 | 308104 | 2022-12-13 | Russia | Komi Republic | 191840 | 3247 | 0 | 63.9881421 | 54.3326073 | 2022-12-14 04:21:04 | Komi Republic, Russia | |||
1149165 | 1149165 | 2022-12-12 | Russia | Komi Republic | 191774 | 3247 | 0 | 63.9881421 | 54.3326073 | 2022-12-13 04:21:01 | Komi Republic, Russia | |||
869019 | 869019 | 2022-12-11 | Russia | Komi Republic | 191707 | 3247 | 0 | 63.9881421 | 54.3326073 | 2022-12-12 04:21:01 | Komi Republic, Russia | |||
257549 | 257549 | 2022-12-10 | Russia | Komi Republic | 191638 | 3247 | 0 | 63.9881421 | 54.3326073 | 2022-12-11 04:20:50 | Komi Republic, Russia | |||
3936263 | 3936263 | 2022-12-09 | Russia | Komi Republic | 191564 | 3247 | 0 | 63.9881421 | 54.3326073 | 2022-12-10 04:21:02 | Komi Republic, Russia | |||
3377595 | 3377595 | 2022-12-08 | Russia | Komi Republic | 191496 | 3247 | 0 | 63.9881421 | 54.3326073 | 2022-12-09 04:21:05 | Komi Republic, Russia | |||
1984866 | 1984866 | 2022-12-07 | Russia | Komi Republic | 191433 | 3247 | 0 | 63.9881421 | 54.3326073 | 2022-12-08 04:21:07 | Komi Republic, Russia | |||
3714389 | 3714389 | 2022-12-06 | Russia | Komi Republic | 191368 | 3247 | 0 | 63.9881421 | 54.3326073 | 2022-12-07 04:20:58 | Komi Republic, Russia | |||
718577 | 718577 | 2022-12-04 | Mexico | Nayarit | 72241 | 3247 | 0 | 21.7514 | -104.8455 | 2022-12-05 04:20:58 | Nayarit, Mexico | |||
2816866 | 2816866 | 2022-12-03 | Mexico | Nayarit | 72241 | 3247 | 0 | 21.7514 | -104.8455 | 2022-12-04 04:20:56 | Nayarit, Mexico | |||
833722 | 833722 | 2022-12-02 | Mexico | Nayarit | 72241 | 3247 | 0 | 21.7514 | -104.8455 | 2022-12-03 04:21:02 | Nayarit, Mexico | |||
2136252 | 2136252 | 2022-12-01 | Mexico | Nayarit | 72241 | 3247 | 0 | 21.7514 | -104.8455 | 2022-12-02 04:21:07 | Nayarit, Mexico | |||
1964668 | 1964668 | 2022-11-30 | Mexico | Nayarit | 72241 | 3247 | 0 | 21.7514 | -104.8455 | 2022-12-01 04:21:03 | Nayarit, Mexico | |||
2556682 | 2556682 | 2022-11-29 | Mexico | Nayarit | 72241 | 3247 | 0 | 21.7514 | -104.8455 | 2022-11-30 04:21:07 | Nayarit, Mexico | |||
1239756 | 1239756 | 2022-11-28 | Mexico | Nayarit | 72241 | 3247 | 0 | 21.7514 | -104.8455 | 2022-11-29 04:21:05 | Nayarit, Mexico | |||
3551744 | 3551744 | 2022-11-27 | Mexico | Nayarit | 72241 | 3247 | 0 | 21.7514 | -104.8455 | 2022-11-28 04:21:02 | Nayarit, Mexico | |||
2100224 | 2100224 | 2022-11-26 | Mexico | Nayarit | 72241 | 3247 | 0 | 21.7514 | -104.8455 | 2022-11-27 04:21:05 | Nayarit, Mexico | |||
487715 | 487715 | 2022-11-25 | Mexico | Nayarit | 72241 | 3247 | 0 | 21.7514 | -104.8455 | 2022-11-26 04:21:11 | Nayarit, Mexico | |||
3523544 | 3523544 | 2022-11-24 | Mexico | Nayarit | 72241 | 3247 | 0 | 21.7514 | -104.8455 | 2022-11-25 04:21:06 | Nayarit, Mexico | |||
3312327 | 3312327 | 2022-11-23 | Mexico | Nayarit | 72241 | 3247 | 0 | 21.7514 | -104.8455 | 2022-11-24 04:21:09 | Nayarit, Mexico | |||
1620368 | 1620368 | 2022-11-22 | Mexico | Nayarit | 72241 | 3247 | 0 | 21.7514 | -104.8455 | 2022-11-23 04:21:06 | Nayarit, Mexico | |||
3745444 | 3745444 | 2022-09-07 | Sweden | Vastra Gotaland | 440866 | 3247 | 0 | 58.2528 | 13.0596 | 2022-09-08 04:21:02 | Vastra Gotaland, Sweden | |||
115084 | 115084 | 2022-09-06 | Sweden | Vastra Gotaland | 440866 | 3247 | 0 | 58.2528 | 13.0596 | 2022-09-07 04:20:59 | Vastra Gotaland, Sweden | |||
2634056 | 2634056 | 2022-09-05 | Sweden | Vastra Gotaland | 440866 | 3247 | 0 | 58.2528 | 13.0596 | 2022-09-06 04:21:02 | Vastra Gotaland, Sweden | |||
2987620 | 2987620 | 2022-09-04 | Sweden | Vastra Gotaland | 440866 | 3247 | 0 | 58.2528 | 13.0596 | 2022-09-05 04:21:01 | Vastra Gotaland, Sweden | |||
2713305 | 2713305 | 2022-09-03 | Sweden | Vastra Gotaland | 440866 | 3247 | 0 | 58.2528 | 13.0596 | 2022-09-04 04:21:22 | Vastra Gotaland, Sweden | |||
1394010 | 1394010 | 2022-09-02 | Sweden | Vastra Gotaland | 440866 | 3247 | 0 | 58.2528 | 13.0596 | 2022-09-03 04:21:04 | Vastra Gotaland, Sweden | |||
3547839 | 3547839 | 2022-09-01 | Sweden | Vastra Gotaland | 440866 | 3247 | 0 | 58.2528 | 13.0596 | 2022-09-02 04:21:07 | Vastra Gotaland, Sweden | |||
3109306 | 3109306 | 2022-07-13 | Colombia | Bolivar | 200944 | 3247 | 0 | 8.6704 | -74.03 | 2022-07-14 04:20:57 | Bolivar, Colombia | |||
629729 | 629729 | 2022-07-12 | Colombia | Bolivar | 200944 | 3247 | 0 | 8.6704 | -74.03 | 2022-07-13 04:20:58 | Bolivar, Colombia | |||
1211373 | 1211373 | 2022-07-11 | Colombia | Bolivar | 200944 | 3247 | 0 | 8.6704 | -74.03 | 2022-07-12 04:20:51 | Bolivar, Colombia | |||
2788855 | 2788855 | 2022-07-10 | Colombia | Bolivar | 200944 | 3247 | 0 | 8.6704 | -74.03 | 2022-07-11 04:20:46 | Bolivar, Colombia | |||
141808 | 141808 | 2022-07-09 | Colombia | Bolivar | 200944 | 3247 | 0 | 8.6704 | -74.03 | 2022-07-10 04:20:54 | Bolivar, Colombia | |||
1416908 | 1416908 | 2022-07-08 | Colombia | Bolivar | 200944 | 3247 | 0 | 8.6704 | -74.03 | 2022-07-09 04:20:59 | Bolivar, Colombia | |||
2740833 | 2740833 | 2022-07-07 | Colombia | Bolivar | 200944 | 3247 | 0 | 8.6704 | -74.03 | 2022-07-08 04:20:56 | Bolivar, Colombia | |||
3887300 | 3887300 | 2022-06-06 | Australia | New South Wales | 2627377 | 3247 | 0 | -33.8688 | 151.2093 | 2022-06-07 04:21:08 | New South Wales, Australia | |||
1109260 | 1109260 | 2022-05-21 | Australia | Victoria | 1808418 | 3247 | 0 | -37.8136 | 144.9631 | 2022-05-22 04:20:52 | Victoria, Australia | |||
2331343 | 2331343 | 2022-05-08 | Italy | Abruzzo | 386071 | 3247 | 0 | 42.35122196 | 13.39843823 | 2022-05-09 04:20:54 | Abruzzo, Italy | |||
158242 | 158242 | 2022-03-29 | Russia | Murmansk Oblast | 133405 | 3247 | 0 | 68.00004179999999 | 33.9999151 | 2022-03-30 04:20:45 | Murmansk Oblast, Russia | |||
3022518 | 3022518 | 2022-03-23 | Russia | Ryazan Oblast | 113542 | 3247 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-03-24 04:20:43 | Ryazan Oblast, Russia | |||
942962 | 942962 | 2022-02-28 | Netherlands | Noord-Holland | 1075766 | 3247 | 0 | 52.60090600000001 | 4.9186879999999995 | 2022-03-01 04:21:09 | Noord-Holland, Netherlands | |||
2733153 | 2733153 | 2022-02-27 | Netherlands | Noord-Holland | 1069996 | 3247 | 0 | 52.60090600000001 | 4.9186879999999995 | 2022-02-28 04:21:05 | Noord-Holland, Netherlands | |||
3046306 | 3046306 | 2022-02-26 | Netherlands | Noord-Holland | 1065720 | 3247 | 0 | 52.60090600000001 | 4.9186879999999995 | 2022-02-27 04:21:04 | Noord-Holland, Netherlands | |||
1362369 | 1362369 | 2022-02-08 | Japan | Osaka | 442124 | 3247 | 0 | 34.620965000000005 | 135.507481 | 2022-02-09 04:21:04 | Osaka, Japan | |||
71116 | 71116 | 2022-02-07 | Japan | Tokyo | 705140 | 3247 | 0 | 35.711343 | 139.446921 | 2022-02-08 04:21:15 | Tokyo, Japan | |||
1475762 | 1475762 | 2022-01-17 | Ukraine | Vinnytsia Oblast | 116532 | 3247 | 0 | 49.2331 | 28.4682 | 2022-01-18 04:21:04 | Vinnytsia Oblast, Ukraine | |||
1113262 | 1113262 | 2022-01-11 | Albania | 222664 | 3247 | 0 | 41.1533 | 20.1683 | 2022-01-12 04:21:44 | Albania | ||||
1287665 | 1287665 | 2022-01-04 | US | Michigan | Macomb | 26099 | 173736 | 3247 | 0 | 42.69158356 | -82.92752801 | 2022-01-05 04:21:59 | Macomb, Michigan, US | |
1702009 | 1702009 | 2022-01-03 | US | Michigan | Macomb | 26099 | 173736 | 3247 | 0 | 42.69158356 | -82.92752801 | 2022-01-04 04:22:17 | Macomb, Michigan, US | |
1668319 | 1668319 | 2021-12-29 | Denmark | 762299 | 3247 | 0 | 56.2639 | 9.5018 | 2021-12-30 04:21:25 | Denmark | ||||
1358535 | 1358535 | 2021-11-27 | Russia | Chuvashia Republic | 42504 | 3247 | 0 | 55.4259922 | 47.0849429 | 2021-11-28 04:22:43 | Chuvashia Republic, Russia | |||
3292538 | 3292538 | 2021-11-18 | Uganda | 127073 | 3247 | 0 | 1.373333 | 32.290275 | 2021-11-19 04:21:40 | Uganda | ||||
2847640 | 2847640 | 2021-11-10 | US | Puerto Rico | Unassigned | 72999 | 4198 | 3247 | 0 | 18.459681 | -67.336525 | 2021-11-11 04:21:45 | Unassigned, Puerto Rico, US | |
89910 | 89910 | 2021-11-09 | US | Puerto Rico | Unassigned | 72999 | 4201 | 3247 | 0 | 18.459681 | -67.336525 | 2021-11-10 04:21:38 | Unassigned, Puerto Rico, US | |
625587 | 625587 | 2021-07-10 | Belarus | 426886 | 3247 | 420085 | 3554 | 53.7098 | 27.9534 | 2021-07-11 04:21:43 | Belarus | |||
50758 | 50758 | 2021-05-29 | India | Telangana | 574026 | 3247 | 533862 | 36917 | 18.1124 | 79.0193 | 2021-05-30 04:20:55 | Telangana, India | ||
646179 | 646179 | 2021-05-05 | Russia | Nizhny Novgorod Oblast | 114647 | 3247 | 110134 | 1266 | 55.47180329999999 | 44.0911594 | 2021-05-06 04:20:38 | Nizhny Novgorod Oblast, Russia | ||
2784009 | 2784009 | 2021-03-24 | US | Texas | Bexar | 48029 | 207428 | 3247 | 0 | 29.44928723 | -98.52019748 | 2021-03-25 05:27:00 | Bexar, Texas, US | |
2359171 | 2359171 | 2021-03-08 | Azerbaijan | 236963 | 3247 | 229789 | 3927 | 40.1431 | 47.5769 | 2021-03-09 05:28:19 | Azerbaijan | |||
182604 | 182604 | 2021-02-21 | US | California | San Bernardino | 6071 | 288313 | 3247 | 0 | 285565 | 34.84060306 | -116.1774685 | 2021-02-22 05:24:21 | San Bernardino, California, US |
2426650 | 2426650 | 2021-01-23 | Brazil | Rio Grande do Norte | 135774 | 3247 | 95604 | 36047 | -5.4026 | -36.9541 | 2021-01-24 05:22:35 | Rio Grande do Norte, Brazil | ||
2466552 | 2466552 | 2021-01-22 | Brazil | Rio Grande do Norte | 135736 | 3247 | 95604 | 35183 | -5.4026 | -36.9541 | 2021-01-23 05:22:03 | Rio Grande do Norte, Brazil | ||
1753506 | 1753506 | 2020-12-14 | US | New York | New York | 36061 | 52163 | 3247 | 0 | 48916 | 40.76727260000001 | -73.97152637 | 2020-12-15 05:26:38 | New York, New York, US |
3850026 | 3850026 | 2020-12-13 | US | New York | New York | 36061 | 51507 | 3247 | 0 | 48260 | 40.76727260000001 | -73.97152637 | 2020-12-14 05:26:27 | New York, New York, US |
1992286 | 1992286 | 2020-11-09 | United Kingdom | Wales | 60912 | 3247 | 0 | 58871 | 52.1307 | -3.7837 | 2020-11-10 05:40:07 | Wales, United Kingdom | ||
1045973 | 1045973 | 2020-09-30 | Peru | Ica | 27602 | 3247 | 0 | 24355 | -14.235097 | -75.574821 | 2020-10-01 04:23:42 | Ica, Peru | ||
2623402 | 2623402 | 2020-06-25 | US | California | Los Angeles | 6037 | 91577 | 3247 | 0 | 88330 | 34.30828379 | -118.2282411 | 2020-06-26 04:33:43 | Los Angeles, California, 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]);