johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
36 rows where deaths = 3333 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3173685 | 3173685 | 2022-12-19 | Germany | Hamburg | 788004 | 3333 | 0 | 53.5511 | 9.9937 | 2022-12-20 04:21:04 | Hamburg, Germany | |||
1200038 | 1200038 | 2022-07-06 | Russia | Murmansk Oblast | 134996 | 3333 | 0 | 68.0000418 | 33.9999151 | 2022-07-07 04:20:55 | Murmansk Oblast, Russia | |||
3507351 | 3507351 | 2022-06-05 | Italy | Abruzzo | 407946 | 3333 | 0 | 42.35122196 | 13.39843823 | 2022-06-06 04:20:57 | Abruzzo, Italy | |||
3527428 | 3527428 | 2022-06-04 | Italy | Abruzzo | 407591 | 3333 | 0 | 42.35122196 | 13.39843823 | 2022-06-05 04:20:55 | Abruzzo, Italy | |||
3133514 | 3133514 | 2022-06-03 | Italy | Abruzzo | 407005 | 3333 | 0 | 42.35122196 | 13.39843823 | 2022-06-04 04:20:58 | Abruzzo, Italy | |||
3201135 | 3201135 | 2022-05-29 | US | Tennessee | Shelby | 47157 | 243831 | 3333 | 0 | 35.1864775 | -89.89692423 | 2022-05-30 04:20:50 | Shelby, Tennessee, US | |
2728013 | 2728013 | 2022-05-28 | US | Tennessee | Shelby | 47157 | 243618 | 3333 | 0 | 35.1864775 | -89.89692423 | 2022-05-29 04:20:53 | Shelby, Tennessee, US | |
1317194 | 1317194 | 2022-05-27 | US | Tennessee | Shelby | 47157 | 243344 | 3333 | 0 | 35.1864775 | -89.89692423 | 2022-05-28 04:21:07 | Shelby, Tennessee, US | |
3671678 | 3671678 | 2022-02-15 | Japan | Tokyo | 828789 | 3333 | 0 | 35.711343 | 139.446921 | 2022-02-16 04:21:10 | Tokyo, Japan | |||
459579 | 459579 | 2022-02-02 | Russia | Dagestan Republic | 73922 | 3333 | 0 | 43.05749160000001 | 47.1332224 | 2022-02-03 04:21:21 | Dagestan Republic, Russia | |||
2054963 | 2054963 | 2022-01-25 | US | Texas | El Paso | 48141 | 184567 | 3333 | 0 | 31.76980765 | -106.23632749999999 | 2022-01-26 04:21:07 | El Paso, Texas, US | |
1960528 | 1960528 | 2022-01-20 | Italy | Marche | 204837 | 3333 | 0 | 43.61675973 | 13.5188753 | 2022-01-21 04:21:09 | Marche, Italy | |||
2609909 | 2609909 | 2022-01-06 | Denmark | 919388 | 3333 | 0 | 56.2639 | 9.5018 | 2022-01-07 04:22:09 | Denmark | ||||
1281737 | 1281737 | 2022-01-05 | Canada | Alberta | 384126 | 3333 | 0 | 53.9333 | -116.5765 | 2022-01-06 04:22:09 | Alberta, Canada | |||
732131 | 732131 | 2021-12-27 | US | Massachusetts | Middlesex | 25017 | 199271 | 3333 | 0 | 42.48607732 | -71.39049229 | 2021-12-28 04:21:47 | Middlesex, Massachusetts, US | |
457 | 457 | 2021-12-02 | Netherlands | Noord-Brabant | 411023 | 3333 | 0 | 51.561174 | 5.1849419999999995 | 2021-12-03 04:23:05 | Noord-Brabant, Netherlands | |||
682579 | 682579 | 2021-10-24 | Russia | Penza Oblast | 77672 | 3333 | 0 | 53.1655415 | 44.78791810000001 | 2021-10-25 04:22:31 | Penza Oblast, Russia | |||
633853 | 633853 | 2021-10-13 | India | Goa | 177288 | 3333 | 0 | 15.359682000000001 | 74.057396 | 2021-10-14 04:21:29 | Goa, India | |||
3928095 | 3928095 | 2021-10-02 | Malaysia | Johor | 198186 | 3333 | 0 | 1.4854 | 103.7618 | 2021-10-03 04:21:24 | Johor, Malaysia | |||
3555764 | 3555764 | 2021-08-21 | Namibia | 123483 | 3333 | 0 | -22.9576 | 18.4904 | 2021-08-22 04:21:29 | Namibia | ||||
2884222 | 2884222 | 2021-06-20 | Colombia | Norte de Santander | 69963 | 3333 | 63988 | 2642 | 7.9463 | -72.8988 | 2021-06-21 04:21:41 | Norte de Santander, Colombia | ||
3089593 | 3089593 | 2021-05-30 | Peru | Puno | 32245 | 3333 | 0 | 28912 | -14.995826999999998 | -69.922726 | 2021-05-31 03:08:59 | Puno, Peru | ||
1771590 | 1771590 | 2021-05-23 | Russia | Sverdlovsk Oblast | 88530 | 3333 | 82392 | 2805 | 58.6414755 | 61.8021546 | 2021-05-24 04:20:53 | Sverdlovsk Oblast, Russia | ||
3954719 | 3954719 | 2021-05-11 | Russia | Nizhny Novgorod Oblast | 115344 | 3333 | 110757 | 1254 | 55.47180329999999 | 44.0911594 | 2021-05-12 04:21:29 | Nizhny Novgorod Oblast, Russia | ||
2549090 | 2549090 | 2021-04-15 | Russia | Krasnoyarsk Krai | 68598 | 3333 | 63333 | 1932 | 63.3233807 | 97.0979974 | 2021-04-16 04:20:46 | Krasnoyarsk Krai, Russia | ||
3886276 | 3886276 | 2021-04-11 | US | Pennsylvania | Philadelphia | 42101 | 137835 | 3333 | 0 | 40.00338507 | -75.1379271 | 2021-04-12 04:21:00 | Philadelphia, Pennsylvania, US | |
2985944 | 2985944 | 2021-04-10 | US | Pennsylvania | Philadelphia | 42101 | 137464 | 3333 | 0 | 40.00338507 | -75.1379271 | 2021-04-11 04:20:56 | Philadelphia, Pennsylvania, US | |
608376 | 608376 | 2021-04-09 | US | Pennsylvania | Philadelphia | 42101 | 136856 | 3333 | 0 | 40.00338507 | -75.1379271 | 2021-04-10 04:20:59 | Philadelphia, Pennsylvania, US | |
2250617 | 2250617 | 2021-04-07 | US | Texas | Tarrant | 48439 | 258923 | 3333 | 0 | 32.77143818 | -97.29101614 | 2021-04-08 04:21:13 | Tarrant, Texas, US | |
1732779 | 1732779 | 2021-03-14 | Spain | Aragon | 108416 | 3333 | 3772 | 101311 | 41.5976 | -0.9057 | 2021-03-15 05:25:51 | Aragon, Spain | ||
1580436 | 1580436 | 2021-03-13 | Spain | Aragon | 108416 | 3333 | 3772 | 101311 | 41.5976 | -0.9057 | 2021-03-14 05:25:37 | Aragon, Spain | ||
1838215 | 1838215 | 2021-03-12 | Spain | Aragon | 108416 | 3333 | 3772 | 101311 | 41.5976 | -0.9057 | 2021-03-13 05:25:15 | Aragon, Spain | ||
2119859 | 2119859 | 2020-12-20 | Pakistan | Sindh | 204840 | 3333 | 180730 | 20777 | 26.009446 | 68.77680699999999 | 2020-12-21 05:27:58 | Sindh, Pakistan | ||
3480394 | 3480394 | 2020-10-26 | Mexico | Guanajuato | 47174 | 3333 | 41410 | 2431 | 21.019 | -101.2574 | 2020-10-27 04:24:45 | Guanajuato, Mexico | ||
2191886 | 2191886 | 2020-10-21 | Spain | Castilla - La Mancha | 55358 | 3333 | 6392 | 45633 | 39.2796 | -3.0977 | 2020-10-22 04:24:27 | Castilla - La Mancha, Spain | ||
458855 | 458855 | 2020-08-07 | Bangladesh | 252502 | 3333 | 145584 | 103585 | 23.685 | 90.3563 | 2020-08-08 04:34:53 | Bangladesh |
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]);