johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
75 rows where deaths = 2269 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
199849 | 199849 | 2022-10-19 | US | Maryland | Prince George's | 24033 | 210199 | 2269 | 0 | 38.83070039 | -76.8496441 | 2022-10-20 04:22:59 | Prince George's, Maryland, US | |
3776084 | 3776084 | 2022-08-30 | US | New Jersey | Monmouth | 34025 | 197432 | 2269 | 0 | 40.26549699 | -74.22240686 | 2022-08-31 04:20:57 | Monmouth, New Jersey, US | |
1405124 | 1405124 | 2022-08-02 | Mexico | Campeche | 41998 | 2269 | 0 | 19.8301 | -90.5349 | 2022-08-03 04:20:59 | Campeche, Mexico | |||
3617162 | 3617162 | 2022-08-01 | Mexico | Campeche | 41900 | 2269 | 0 | 19.8301 | -90.5349 | 2022-08-02 04:20:53 | Campeche, Mexico | |||
3871642 | 3871642 | 2022-07-31 | Mexico | Campeche | 41619 | 2269 | 0 | 19.8301 | -90.5349 | 2022-08-01 04:21:03 | Campeche, Mexico | |||
674396 | 674396 | 2022-07-30 | Mexico | Campeche | 41619 | 2269 | 0 | 19.8301 | -90.5349 | 2022-07-31 04:21:02 | Campeche, Mexico | |||
1783595 | 1783595 | 2022-07-29 | Mexico | Campeche | 41619 | 2269 | 0 | 19.8301 | -90.5349 | 2022-07-30 04:20:42 | Campeche, Mexico | |||
1065958 | 1065958 | 2022-07-28 | Mexico | Campeche | 41484 | 2269 | 0 | 19.8301 | -90.5349 | 2022-07-29 04:20:45 | Campeche, Mexico | |||
2335477 | 2335477 | 2022-07-27 | Mexico | Campeche | 41484 | 2269 | 0 | 19.8301 | -90.5349 | 2022-07-28 04:20:56 | Campeche, Mexico | |||
900160 | 900160 | 2022-07-22 | Japan | Hyogo | 518936 | 2269 | 0 | 35.039913 | 134.828057 | 2022-07-23 04:20:53 | Hyogo, Japan | |||
670296 | 670296 | 2022-07-21 | Japan | Hyogo | 509684 | 2269 | 0 | 35.039913 | 134.828057 | 2022-07-22 04:21:15 | Hyogo, Japan | |||
3507582 | 3507582 | 2022-06-05 | Russia | Belgorod Oblast | 131049 | 2269 | 0 | 50.7080119 | 37.5837615 | 2022-06-06 04:20:57 | Belgorod Oblast, Russia | |||
1440150 | 1440150 | 2022-03-28 | US | Wisconsin | Milwaukee | 55079 | 267926 | 2269 | 0 | 43.00486062 | -87.96733172 | 2022-03-29 04:20:46 | Milwaukee, Wisconsin, US | |
1436882 | 1436882 | 2022-03-28 | Spain | Extremadura | 250928 | 2269 | 0 | 39.4937 | -6.0679 | 2022-03-29 04:20:46 | Extremadura, Spain | |||
876563 | 876563 | 2022-03-27 | Spain | Extremadura | 250928 | 2269 | 0 | 39.4937 | -6.0679 | 2022-03-28 04:20:33 | Extremadura, Spain | |||
2163846 | 2163846 | 2022-03-26 | Spain | Extremadura | 250928 | 2269 | 0 | 39.4937 | -6.0679 | 2022-03-27 04:20:47 | Extremadura, Spain | |||
1720782 | 1720782 | 2022-03-25 | Spain | Extremadura | 250928 | 2269 | 0 | 39.4937 | -6.0679 | 2022-03-26 04:20:23 | Extremadura, Spain | |||
1548185 | 1548185 | 2022-03-07 | Russia | Khakassia Republic | 84902 | 2269 | 0 | 53.72258845 | 91.44293627 | 2022-03-08 04:20:54 | Khakassia Republic, Russia | |||
2446669 | 2446669 | 2022-02-22 | Germany | Hamburg | 336552 | 2269 | 0 | 53.5511 | 9.9937 | 2022-02-23 04:21:09 | Hamburg, Germany | |||
1366004 | 1366004 | 2022-02-08 | United Arab Emirates | 860976 | 2269 | 0 | 23.424076 | 53.847818000000004 | 2022-02-09 04:21:04 | United Arab Emirates | ||||
2171205 | 2171205 | 2022-01-01 | Ukraine | Rivne Oblast | 127582 | 2269 | 0 | 50.6199 | 26.2516 | 2022-01-02 04:20:52 | Rivne Oblast, Ukraine | |||
3828311 | 3828311 | 2021-12-21 | Colombia | Risaralda | 89133 | 2269 | 0 | 5.3158 | -75.9928 | 2021-12-22 04:21:54 | Risaralda, Colombia | |||
279176 | 279176 | 2021-11-03 | US | Tennessee | Shelby | 47157 | 144796 | 2269 | 0 | 35.1864775 | -89.89692423 | 2021-11-04 04:22:20 | Shelby, Tennessee, US | |
770171 | 770171 | 2021-10-23 | Colombia | Caldas | 100597 | 2269 | 0 | 5.2983 | -75.2479 | 2021-10-24 04:21:22 | Caldas, Colombia | |||
637553 | 637553 | 2021-10-13 | Ukraine | Ivano-Frankivsk Oblast | 94899 | 2269 | 0 | 48.9226 | 24.7111 | 2021-10-14 04:21:29 | Ivano-Frankivsk Oblast, Ukraine | |||
2076145 | 2076145 | 2021-09-26 | Russia | Chuvashia Republic | 33631 | 2269 | 0 | 55.4259922 | 47.0849429 | 2021-09-27 04:21:16 | Chuvashia Republic, Russia | |||
1923395 | 1923395 | 2021-09-24 | US | New Jersey | Ocean | 34029 | 88552 | 2269 | 0 | 39.8895449 | -74.28089251 | 2021-09-25 04:21:31 | Ocean, New Jersey, US | |
601742 | 601742 | 2021-09-23 | Malawi | 61453 | 2269 | 0 | -13.2543 | 34.3015 | 2021-09-24 04:21:44 | Malawi | ||||
642175 | 642175 | 2021-09-07 | Russia | Penza Oblast | 65136 | 2269 | 0 | 53.1655415 | 44.78791810000001 | 2021-09-08 04:21:31 | Penza Oblast, Russia | |||
3284492 | 3284492 | 2021-09-05 | Ukraine | Crimea Republic* | 72380 | 2269 | 0 | 45.2835 | 34.2008 | 2021-09-06 04:21:22 | Crimea Republic*, Ukraine | |||
1342511 | 1342511 | 2021-08-11 | Russia | Leningrad Oblast | 58683 | 2269 | 0 | 60.185329599999996 | 32.3925325 | 2021-08-12 04:21:25 | Leningrad Oblast, Russia | |||
331960 | 331960 | 2021-08-04 | Kosovo | 108844 | 2269 | 105688 | 887 | 42.602636 | 20.902977 | 2021-08-05 04:21:51 | Kosovo | |||
3468231 | 3468231 | 2021-08-03 | Kosovo | 108623 | 2269 | 105667 | 687 | 42.602636 | 20.902977 | 2021-08-04 04:21:25 | Kosovo | |||
3683505 | 3683505 | 2021-08-02 | Kosovo | 108513 | 2269 | 105665 | 579 | 42.602636 | 20.902977 | 2021-08-03 04:21:39 | Kosovo | |||
3015404 | 3015404 | 2021-08-01 | Kosovo | 108465 | 2269 | 105660 | 536 | 42.602636 | 20.902977 | 2021-08-02 04:21:36 | Kosovo | |||
3904027 | 3904027 | 2021-07-31 | Kosovo | 108365 | 2269 | 105657 | 439 | 42.602636 | 20.902977 | 2021-08-01 04:21:50 | Kosovo | |||
3296232 | 3296232 | 2021-07-30 | Kosovo | 108273 | 2269 | 105641 | 363 | 42.602636 | 20.902977 | 2021-07-31 04:21:35 | Kosovo | |||
3385443 | 3385443 | 2021-07-29 | Kosovo | 108203 | 2269 | 105633 | 301 | 42.602636 | 20.902977 | 2021-07-30 04:21:34 | Kosovo | |||
408348 | 408348 | 2021-07-28 | Kosovo | 108131 | 2269 | 105616 | 246 | 42.602636 | 20.902977 | 2021-07-29 04:21:33 | Kosovo | |||
1306209 | 1306209 | 2021-07-27 | Kosovo | 108073 | 2269 | 105613 | 191 | 42.602636 | 20.902977 | 2021-07-28 04:21:39 | Kosovo | |||
3218352 | 3218352 | 2021-07-26 | Kosovo | 108031 | 2269 | 105597 | 165 | 42.602636 | 20.902977 | 2021-07-27 04:21:18 | Kosovo | |||
1378561 | 1378561 | 2021-07-25 | Kosovo | 108017 | 2269 | 105591 | 157 | 42.602636 | 20.902977 | 2021-07-26 04:21:28 | Kosovo | |||
1330301 | 1330301 | 2021-07-24 | Kosovo | 107992 | 2269 | 105590 | 133 | 42.602636 | 20.902977 | 2021-07-25 04:22:12 | Kosovo | |||
3137605 | 3137605 | 2021-07-23 | Kosovo | 107973 | 2269 | 105582 | 122 | 42.602636 | 20.902977 | 2021-07-24 00:21:36 | Kosovo | |||
3476365 | 3476365 | 2021-07-22 | Kosovo | 107954 | 2269 | 105575 | 110 | 42.602636 | 20.902977 | 2021-07-23 04:21:29 | Kosovo | |||
3331584 | 3331584 | 2021-07-21 | Kosovo | 107926 | 2269 | 105557 | 100 | 42.602636 | 20.902977 | 2021-07-22 04:21:19 | Kosovo | |||
2673854 | 2673854 | 2021-07-18 | Japan | Tokyo | 189095 | 2269 | 177075 | 9751 | 35.711343 | 139.446921 | 2021-07-19 04:21:24 | Tokyo, Japan | ||
3706166 | 3706166 | 2021-07-17 | Japan | Tokyo | 188087 | 2269 | 176353 | 9465 | 35.711343 | 139.446921 | 2021-07-18 04:22:07 | Tokyo, Japan | ||
3659437 | 3659437 | 2021-07-11 | Colombia | Cesar | 82867 | 2269 | 78357 | 2241 | 9.3373 | -73.6536 | 2021-07-12 04:21:34 | Cesar, Colombia | ||
625721 | 625721 | 2021-07-10 | Colombia | Cesar | 82620 | 2269 | 78357 | 1994 | 9.3373 | -73.6536 | 2021-07-11 04:21:43 | Cesar, Colombia | ||
829440 | 829440 | 2021-07-09 | Colombia | Cesar | 82360 | 2269 | 78078 | 2013 | 9.3373 | -73.6536 | 2021-07-10 04:21:25 | Cesar, Colombia | ||
1895105 | 1895105 | 2021-06-30 | US | Missouri | St. Louis | 29189 | 101753 | 2269 | 0 | 38.63770039999999 | -90.4458375 | 2021-07-01 04:21:19 | St. Louis, Missouri, US | |
402228 | 402228 | 2021-06-29 | US | Missouri | St. Louis | 29189 | 101651 | 2269 | 0 | 38.63770039999999 | -90.4458375 | 2021-06-30 04:21:41 | St. Louis, Missouri, US | |
2913624 | 2913624 | 2021-06-17 | US | Ohio | Cuyahoga | 39035 | 115738 | 2269 | 0 | 41.424119 | -81.65918339 | 2021-06-18 04:22:16 | Cuyahoga, Ohio, US | |
3032740 | 3032740 | 2021-06-16 | US | Ohio | Cuyahoga | 39035 | 115713 | 2269 | 0 | 41.424119 | -81.65918339 | 2021-06-17 04:22:36 | Cuyahoga, Ohio, US | |
1736272 | 1736272 | 2021-06-12 | Canada | Alberta | 230298 | 2269 | 224782 | 3247 | 53.9333 | -116.5765 | 2021-06-13 04:22:44 | Alberta, Canada | ||
1415221 | 1415221 | 2021-05-24 | US | New Jersey | Hudson | 34017 | 87773 | 2269 | 0 | 40.73766234 | -74.07515667 | 2021-05-25 04:21:08 | Hudson, New Jersey, US | |
3574653 | 3574653 | 2021-05-17 | Latvia | 128125 | 2269 | 117799 | 8057 | 56.8796 | 24.6032 | 2021-05-18 04:20:33 | Latvia | |||
1425262 | 1425262 | 2021-05-09 | Peru | Huanuco | 30512 | 2269 | 0 | 28243 | -9.421676 | -76.040642 | 2021-05-10 04:20:38 | Huanuco, Peru | ||
2571657 | 2571657 | 2021-04-13 | Italy | Abruzzo | 68265 | 2269 | 55735 | 10261 | 42.35122196 | 13.39843823 | 2021-04-14 04:20:41 | Abruzzo, Italy | ||
3883343 | 3883343 | 2021-04-11 | Brazil | Tocantins | 148347 | 2269 | 126456 | 19361 | -10.1753 | -48.2982 | 2021-04-12 04:21:00 | Tocantins, Brazil | ||
3644595 | 3644595 | 2021-03-30 | US | Illinois | Unassigned | 90017 | 90 | 2269 | 0 | 42.36542373 | 0.0 | 2021-03-31 04:26:25 | Unassigned, Illinois, US | |
1882028 | 1882028 | 2021-03-26 | US | Illinois | Unassigned | 90017 | 99 | 2269 | 0 | 42.36542373 | 0.0 | 2021-03-27 05:25:04 | Unassigned, Illinois, US | |
2637599 | 2637599 | 2021-02-11 | Denmark | 203365 | 2269 | 195124 | 5972 | 56.2639 | 9.5018 | 2021-02-12 05:23:29 | Denmark | |||
614406 | 614406 | 2021-02-08 | US | Florida | Palm Beach | 12099 | 111437 | 2269 | 0 | 109168 | 26.64676272 | -80.46536002 | 2021-02-09 05:23:30 | Palm Beach, Florida, US |
3311309 | 3311309 | 2021-01-13 | US | Texas | Hidalgo | 48215 | 63961 | 2269 | 0 | 53994 | 26.39418217 | -98.18299696 | 2021-01-14 05:22:32 | Hidalgo, Texas, US |
1008531 | 1008531 | 2020-12-06 | US | New York | Nassau | 36059 | 65098 | 2269 | 0 | 62829 | 40.74066522 | -73.58941873 | 2020-12-07 05:26:14 | Nassau, New York, US |
1634540 | 1634540 | 2020-12-05 | US | New York | Nassau | 36059 | 64359 | 2269 | 0 | 62090 | 40.74066522 | -73.58941873 | 2020-12-06 05:26:18 | Nassau, New York, US |
2935339 | 2935339 | 2020-11-28 | Moldova | 105852 | 2269 | 93028 | 10555 | 47.4116 | 28.3699 | 2020-11-29 05:25:55 | Moldova | |||
1972676 | 1972676 | 2020-11-25 | Mexico | Michoacan | 27748 | 2269 | 0 | 25479 | 19.5665 | -101.7068 | 2020-11-26 05:27:44 | Michoacan, Mexico | ||
864930 | 864930 | 2020-11-12 | Peru | Junin | 24157 | 2269 | 0 | 21888 | -11.541783 | -74.876968 | 2020-11-13 05:25:30 | Junin, Peru | ||
272037 | 272037 | 2020-11-10 | Dominican Republic | 131131 | 2269 | 108765 | 20097 | 18.7357 | -70.1627 | 2020-11-11 05:25:30 | Dominican Republic | |||
786125 | 786125 | 2020-10-15 | Brazil | Piaui | 105156 | 2269 | 99255 | 2813 | -7.7183 | -42.7289 | 2020-10-16 04:24:01 | Piaui, Brazil | ||
2958960 | 2958960 | 2020-07-29 | Romania | 48235 | 2269 | 26446 | 19520 | 45.9432 | 24.9668 | 2020-07-30 04:35:05 | Romania | |||
1707758 | 1707758 | 2020-07-21 | Mexico | Veracruz | 17406 | 2269 | 12296 | 2841 | 19.1738 | -96.1342 | 2020-07-22 04:34:42 | Veracruz, 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]);