johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
50 rows where deaths = 3072 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 15
- Russia 11
- US 10
- Colombia 6
- Japan 5
- Mexico 4
- Brazil 3
- Italy 3
- Azerbaijan 1
- Belarus 1
- Germany 1
- India 1
- Libya 1
- Netherlands 1
- Ukraine 1
- United Kingdom 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
849602 | 849602 | 2022-11-02 | Japan | Kanagawa | 1555614 | 3072 | 0 | 35.415312 | 139.338983 | 2022-11-03 04:22:05 | Kanagawa, Japan | |||
710453 | 710453 | 2022-11-01 | Japan | Kanagawa | 1551975 | 3072 | 0 | 35.415312 | 139.338983 | 2022-11-02 04:22:09 | Kanagawa, Japan | |||
3284902 | 3284902 | 2022-10-31 | Japan | Kanagawa | 1548182 | 3072 | 0 | 35.415312 | 139.338983 | 2022-11-01 04:22:36 | Kanagawa, Japan | |||
319935 | 319935 | 2022-10-30 | Japan | Kanagawa | 1546523 | 3072 | 0 | 35.415312 | 139.338983 | 2022-10-31 04:21:36 | Kanagawa, Japan | |||
2967303 | 2967303 | 2022-10-10 | Germany | Hamburg | 735609 | 3072 | 0 | 53.5511 | 9.9937 | 2022-10-11 04:23:05 | Hamburg, Germany | |||
2685894 | 2685894 | 2022-10-03 | Russia | Buryatia Republic | 150998 | 3072 | 0 | 52.7182426 | 109.492143 | 2022-10-04 04:22:55 | Buryatia Republic, Russia | |||
2259961 | 2259961 | 2022-10-02 | Russia | Buryatia Republic | 150916 | 3072 | 0 | 52.7182426 | 109.492143 | 2022-10-03 04:23:11 | Buryatia Republic, Russia | |||
2995487 | 2995487 | 2022-10-01 | Russia | Buryatia Republic | 150845 | 3072 | 0 | 52.7182426 | 109.492143 | 2022-10-02 04:21:23 | Buryatia Republic, Russia | |||
1878101 | 1878101 | 2022-08-28 | US | Indiana | Marion | 18097 | 250432 | 3072 | 0 | 39.78163624 | -86.13826325 | 2022-08-29 04:21:06 | Marion, Indiana, US | |
2097228 | 2097228 | 2022-08-27 | US | Indiana | Marion | 18097 | 250432 | 3072 | 0 | 39.78163624 | -86.13826325 | 2022-08-28 04:21:02 | Marion, Indiana, US | |
1533043 | 1533043 | 2022-08-26 | US | Indiana | Marion | 18097 | 250432 | 3072 | 0 | 39.78163624 | -86.13826325 | 2022-08-27 04:20:57 | Marion, Indiana, US | |
475693 | 475693 | 2022-06-26 | Russia | Smolensk Oblast | 131778 | 3072 | 0 | 55.0343496 | 33.0192065 | 2022-06-27 04:21:00 | Smolensk Oblast, Russia | |||
939068 | 939068 | 2022-06-25 | Russia | Smolensk Oblast | 131759 | 3072 | 0 | 55.0343496 | 33.0192065 | 2022-06-26 04:21:02 | Smolensk Oblast, Russia | |||
2892617 | 2892617 | 2022-04-21 | Russia | Ivanovo Oblast | 109790 | 3072 | 0 | 56.9167446 | 41.43521370000001 | 2022-04-22 04:20:45 | Ivanovo Oblast, Russia | |||
1652499 | 1652499 | 2022-04-09 | Mexico | Tlaxcala | 43743 | 3072 | 0 | 19.3139 | -98.2404 | 2022-04-10 04:20:52 | Tlaxcala, Mexico | |||
2115821 | 2115821 | 2022-04-08 | Mexico | Tlaxcala | 43740 | 3072 | 0 | 19.3139 | -98.2404 | 2022-04-09 04:20:42 | Tlaxcala, Mexico | |||
3226468 | 3226468 | 2022-01-19 | Japan | Osaka | 236905 | 3072 | 0 | 34.620965000000005 | 135.507481 | 2022-01-20 04:21:07 | Osaka, Japan | |||
554983 | 554983 | 2022-01-16 | Russia | Bryansk Oblast | 99082 | 3072 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-01-17 04:21:08 | Bryansk Oblast, Russia | |||
99548 | 99548 | 2022-01-14 | Russia | Leningrad Oblast | 105080 | 3072 | 0 | 60.185329599999996 | 32.3925325 | 2022-01-15 04:21:07 | Leningrad Oblast, Russia | |||
2779159 | 2779159 | 2021-12-31 | US | New Jersey | Bergen | 34003 | 157470 | 3072 | 0 | 40.96010917 | -74.07164325 | 2022-01-01 04:22:14 | Bergen, New Jersey, US | |
1436213 | 1436213 | 2021-12-28 | Ukraine | Vinnytsia Oblast | 111648 | 3072 | 0 | 49.2331 | 28.4682 | 2021-12-29 03:21:43 | Vinnytsia Oblast, Ukraine | |||
1334248 | 1334248 | 2021-09-28 | Italy | Marche | 113704 | 3072 | 0 | 43.61675973 | 13.5188753 | 2021-09-29 04:21:45 | Marche, Italy | |||
1235617 | 1235617 | 2021-09-27 | Italy | Marche | 113643 | 3072 | 0 | 43.61675973 | 13.5188753 | 2021-09-28 04:21:28 | Marche, Italy | |||
2075918 | 2075918 | 2021-09-26 | Italy | Marche | 113617 | 3072 | 0 | 43.61675973 | 13.5188753 | 2021-09-27 04:21:16 | Marche, Italy | |||
19137 | 19137 | 2021-09-18 | US | Puerto Rico | Unassigned | 72999 | 3579 | 3072 | 0 | 18.459681 | -67.336525 | 2021-09-19 04:21:34 | Unassigned, Puerto Rico, US | |
68660 | 68660 | 2021-09-01 | US | Massachusetts | Middlesex | 25017 | 144708 | 3072 | 0 | 42.48607732 | -71.39049229 | 2021-09-02 04:21:15 | Middlesex, Massachusetts, US | |
2069502 | 2069502 | 2021-08-31 | US | Massachusetts | Middlesex | 25017 | 144407 | 3072 | 0 | 42.48607732 | -71.39049229 | 2021-09-01 04:21:38 | Middlesex, Massachusetts, US | |
3894097 | 3894097 | 2021-08-29 | US | New Jersey | Essex | 34013 | 99808 | 3072 | 0 | 40.78681335 | -74.24657979 | 2021-08-30 04:21:23 | Essex, New Jersey, US | |
3892038 | 3892038 | 2021-08-29 | Mexico | Zacatecas | 38216 | 3072 | 0 | 22.7709 | -102.5832 | 2021-08-30 04:21:23 | Zacatecas, Mexico | |||
2518026 | 2518026 | 2021-08-18 | Colombia | Huila | 87314 | 3072 | 0 | 2.5359 | -75.5277 | 2021-08-19 04:21:15 | Huila, Colombia | |||
245118 | 245118 | 2021-08-17 | Colombia | Huila | 87280 | 3072 | 0 | 2.5359 | -75.5277 | 2021-08-18 04:21:35 | Huila, Colombia | |||
1121248 | 1121248 | 2021-08-06 | United Kingdom | Northern Ireland | 163586 | 3072 | 0 | 54.7877 | -6.4923 | 2021-08-07 04:21:30 | Northern Ireland, United Kingdom | |||
1440444 | 1440444 | 2021-07-07 | Colombia | Tolima | 95947 | 3072 | 89805 | 3070 | 4.0925 | -75.1545 | 2021-07-08 04:21:26 | Tolima, Colombia | ||
2764778 | 2764778 | 2021-07-01 | Colombia | Cordoba | 82973 | 3072 | 76619 | 3282 | 8.0493 | -75.574 | 2021-07-02 04:21:47 | Cordoba, Colombia | ||
2422599 | 2422599 | 2021-06-23 | Belarus | 412353 | 3072 | 405045 | 4236 | 53.7098 | 27.9534 | 2021-06-24 04:21:55 | Belarus | |||
2910926 | 2910926 | 2021-06-17 | Brazil | Tocantins | 191469 | 3072 | 171927 | 15555 | -10.1753 | -48.2982 | 2021-06-18 04:22:16 | Tocantins, Brazil | ||
2717233 | 2717233 | 2021-06-10 | Russia | Voronezh Oblast | 86380 | 3072 | 81772 | 1536 | 50.9800393 | 40.15065070000001 | 2021-06-11 04:23:20 | Voronezh Oblast, Russia | ||
2315517 | 2315517 | 2021-06-04 | Russia | Krasnodar Krai | 48813 | 3072 | 43811 | 1930 | 45.7684014 | 39.0261044 | 2021-06-05 04:23:03 | Krasnodar Krai, Russia | ||
3954617 | 3954617 | 2021-05-11 | Netherlands | Noord-Brabant | 251690 | 3072 | 0 | 250256 | 51.561174 | 5.184942 | 2021-05-12 04:21:29 | Noord-Brabant, Netherlands | ||
2820832 | 2820832 | 2021-05-10 | Libya | 180226 | 3072 | 166680 | 10474 | 26.3351 | 17.228331 | 2021-05-11 04:20:41 | Libya | |||
170008 | 170008 | 2021-04-16 | India | Rajasthan | 395309 | 3072 | 338424 | 53813 | 26.583423 | 73.847973 | 2021-04-17 04:20:40 | Rajasthan, India | ||
1798854 | 1798854 | 2021-03-23 | Russia | Krasnoyarsk Krai | 65784 | 3072 | 60889 | 1823 | 63.3233807 | 97.0979974 | 2021-03-24 05:25:40 | Krasnoyarsk Krai, Russia | ||
352049 | 352049 | 2021-03-11 | Brazil | Sergipe | 157340 | 3072 | 145642 | 8626 | -10.5741 | -37.3857 | 2021-03-12 05:26:50 | Sergipe, Brazil | ||
533391 | 533391 | 2021-02-22 | US | Pennsylvania | Philadelphia | 42101 | 117867 | 3072 | 0 | 114795 | 40.00338507 | -75.1379271 | 2021-02-23 05:23:41 | Philadelphia, Pennsylvania, US |
3981634 | 3981634 | 2021-02-10 | US | Texas | Dallas | 48113 | 245894 | 3072 | 0 | 267724 | 32.76670599 | -96.7779605 | 2021-02-11 05:23:55 | Dallas, Texas, US |
1527992 | 1527992 | 2021-02-09 | Mexico | Queretaro | 50962 | 3072 | 0 | 47890 | 20.5888 | -100.3899 | 2021-02-10 05:22:41 | Queretaro, Mexico | ||
613547 | 613547 | 2021-02-08 | Colombia | Santander | 86131 | 3072 | 79837 | 3222 | 6.6437 | -73.6536 | 2021-02-09 05:23:30 | Santander, Colombia | ||
1676217 | 1676217 | 2021-02-01 | Brazil | Piaui | 159741 | 3072 | 155732 | 493 | -7.7183 | -42.7289 | 2021-02-02 05:22:49 | Piaui, Brazil | ||
2426608 | 2426608 | 2021-01-23 | Azerbaijan | 228688 | 3072 | 219724 | 5892 | 40.1431 | 47.5769 | 2021-01-24 05:22:35 | Azerbaijan | |||
1045652 | 1045652 | 2020-09-30 | Colombia | Atlantico | 67551 | 3072 | 63682 | 797 | 10.6966 | -74.8741 | 2020-10-01 04:23:42 | Atlantico, Colombia |
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]);