johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
78 rows where deaths = 2237 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 23
- US 33
- Colombia 9
- Italy 9
- Mexico 3
- Russia 3
- Netherlands 2
- Spain 2
- Ukraine 2
- Afghanistan 1
- Belarus 1
- Brazil 1
- Chile 1
- El Salvador 1
- Ethiopia 1
- Germany 1
- India 1
- Ireland 1
- Japan 1
- Korea, South 1
- Montenegro 1
- Pakistan 1
- Peru 1
- Poland 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3523430 | 3523430 | 2022-11-24 | Italy | Umbria | 410100 | 2237 | 0 | 43.10675841 | 12.38824698 | 2022-11-25 04:21:06 | Umbria, Italy | |||
3312213 | 3312213 | 2022-11-23 | Italy | Umbria | 410100 | 2237 | 0 | 43.10675841 | 12.38824698 | 2022-11-24 04:21:09 | Umbria, Italy | |||
1620254 | 1620254 | 2022-11-22 | Italy | Umbria | 410100 | 2237 | 0 | 43.10675841 | 12.38824698 | 2022-11-23 04:21:06 | Umbria, Italy | |||
3460142 | 3460142 | 2022-11-21 | Italy | Umbria | 410100 | 2237 | 0 | 43.10675841 | 12.38824698 | 2022-11-22 04:20:47 | Umbria, Italy | |||
1640327 | 1640327 | 2022-11-20 | Italy | Umbria | 410100 | 2237 | 0 | 43.10675841 | 12.38824698 | 2022-11-21 04:21:05 | Umbria, Italy | |||
2063884 | 2063884 | 2022-11-19 | Italy | Umbria | 410100 | 2237 | 0 | 43.10675841 | 12.38824698 | 2022-11-20 04:21:08 | Umbria, Italy | |||
1755278 | 1755278 | 2022-11-18 | Italy | Umbria | 410100 | 2237 | 0 | 43.10675841 | 12.38824698 | 2022-11-19 04:21:14 | Umbria, Italy | |||
254901 | 254901 | 2022-09-08 | US | Maryland | Prince George's | 24033 | 205008 | 2237 | 0 | 38.83070039 | -76.8496441 | 2022-09-09 04:21:11 | Prince George's, Maryland, US | |
2323434 | 2323434 | 2022-08-24 | Mexico | Colima | 66943 | 2237 | 0 | 19.1223 | -104.0072 | 2022-08-25 04:21:13 | Colima, Mexico | |||
3952091 | 3952091 | 2022-08-17 | US | Massachusetts | Bristol | 25005 | 165957 | 2237 | 0 | 41.79228404 | -71.10872211 | 2022-08-18 04:21:11 | Bristol, Massachusetts, US | |
992593 | 992593 | 2022-08-16 | US | Massachusetts | Bristol | 25005 | 165957 | 2237 | 0 | 41.79228404 | -71.10872211 | 2022-08-17 04:20:59 | Bristol, Massachusetts, US | |
2495632 | 2495632 | 2022-08-15 | US | Massachusetts | Bristol | 25005 | 165957 | 2237 | 0 | 41.79228404 | -71.10872211 | 2022-08-16 04:20:58 | Bristol, Massachusetts, US | |
3649182 | 3649182 | 2022-08-14 | US | Massachusetts | Bristol | 25005 | 165957 | 2237 | 0 | 41.79228404 | -71.10872211 | 2022-08-15 04:20:59 | Bristol, Massachusetts, US | |
3647579 | 3647579 | 2022-08-14 | Japan | Hokkaido | 546808 | 2237 | 0 | 43.385711 | 142.552318 | 2022-08-15 04:20:59 | Hokkaido, Japan | |||
1970188 | 1970188 | 2022-08-13 | US | Massachusetts | Bristol | 25005 | 165957 | 2237 | 0 | 41.79228404 | -71.10872211 | 2022-08-14 04:20:55 | Bristol, Massachusetts, US | |
2889997 | 2889997 | 2022-08-12 | US | Massachusetts | Bristol | 25005 | 165957 | 2237 | 0 | 41.79228404 | -71.10872211 | 2022-08-13 04:20:52 | Bristol, Massachusetts, US | |
3909602 | 3909602 | 2022-08-11 | US | Massachusetts | Bristol | 25005 | 165957 | 2237 | 0 | 41.79228404 | -71.10872211 | 2022-08-12 04:20:54 | Bristol, Massachusetts, US | |
3593605 | 3593605 | 2022-05-23 | US | California | San Joaquin | 6077 | 181564 | 2237 | 0 | 37.93433732 | -121.2730061 | 2022-05-24 04:20:57 | San Joaquin, California, US | |
1110153 | 1110153 | 2022-05-21 | US | California | San Joaquin | 6077 | 180623 | 2237 | 0 | 37.93433732 | -121.2730061 | 2022-05-22 04:20:52 | San Joaquin, California, US | |
1169777 | 1169777 | 2022-05-20 | US | California | San Joaquin | 6077 | 180615 | 2237 | 0 | 37.93433732 | -121.2730061 | 2022-05-21 04:20:58 | San Joaquin, California, US | |
1397886 | 1397886 | 2022-05-06 | Russia | Belgorod Oblast | 130127 | 2237 | 0 | 50.7080119 | 37.5837615 | 2022-05-07 04:21:09 | Belgorod Oblast, Russia | |||
3350631 | 3350631 | 2022-04-01 | Italy | Sardegna | 231668 | 2237 | 0 | 39.21531192 | 9.110616306 | 2022-04-02 04:20:47 | Sardegna, Italy | |||
1656186 | 1656186 | 2022-03-19 | Chile | Maule | 226074 | 2237 | 0 | -35.5183 | -71.6885 | 2022-03-20 04:20:45 | Maule, Chile | |||
1297949 | 1297949 | 2022-02-17 | Germany | Hamburg | 324404 | 2237 | 0 | 53.5511 | 9.9937 | 2022-02-18 04:21:04 | Hamburg, Germany | |||
1116387 | 1116387 | 2022-01-11 | US | Rhode Island | Providence | 44007 | 150844 | 2237 | 0 | 41.87064746 | -71.57753536 | 2022-01-12 04:21:44 | Providence, Rhode Island, US | |
1695115 | 1695115 | 2022-01-10 | US | Rhode Island | Providence | 44007 | 150844 | 2237 | 0 | 41.87064746 | -71.57753536 | 2022-01-11 04:22:01 | Providence, Rhode Island, US | |
129530 | 129530 | 2022-01-09 | US | Rhode Island | Providence | 44007 | 150844 | 2237 | 0 | 41.87064746 | -71.57753536 | 2022-01-10 04:22:07 | Providence, Rhode Island, US | |
1218365 | 1218365 | 2022-01-08 | US | Rhode Island | Providence | 44007 | 150844 | 2237 | 0 | 41.87064746 | -71.57753536 | 2022-01-09 04:21:46 | Providence, Rhode Island, US | |
1392458 | 1392458 | 2022-01-07 | US | Rhode Island | Providence | 44007 | 150844 | 2237 | 0 | 41.87064746 | -71.57753536 | 2022-01-08 04:21:53 | Providence, Rhode Island, US | |
2612845 | 2612845 | 2022-01-06 | US | Rhode Island | Providence | 44007 | 150844 | 2237 | 0 | 41.87064746 | -71.57753536 | 2022-01-07 04:22:09 | Providence, Rhode Island, US | |
1284787 | 1284787 | 2022-01-05 | US | Rhode Island | Providence | 44007 | 150844 | 2237 | 0 | 41.87064746 | -71.57753536 | 2022-01-06 04:22:09 | Providence, Rhode Island, US | |
1443 | 1443 | 2021-12-02 | US | Indiana | Marion | 18097 | 145083 | 2237 | 0 | 39.78163624 | -86.13826325 | 2021-12-03 04:23:05 | Marion, Indiana, US | |
162141 | 162141 | 2021-11-19 | Montenegro | 154128 | 2237 | 0 | 42.708678000000006 | 19.37439 | 2021-11-20 04:22:17 | Montenegro | ||||
686198 | 686198 | 2021-11-13 | Colombia | Risaralda | 88128 | 2237 | 0 | 5.3158 | -75.9928 | 2021-11-14 04:21:31 | Risaralda, Colombia | |||
714307 | 714307 | 2021-11-12 | Colombia | Risaralda | 88106 | 2237 | 0 | 5.3158 | -75.9928 | 2021-11-13 04:21:38 | Risaralda, Colombia | |||
28257 | 28257 | 2021-11-11 | Colombia | Risaralda | 88092 | 2237 | 0 | 5.3158 | -75.9928 | 2021-11-12 04:22:01 | Risaralda, Colombia | |||
2844696 | 2844696 | 2021-11-10 | Colombia | Risaralda | 88073 | 2237 | 0 | 5.3158 | -75.9928 | 2021-11-11 04:21:45 | Risaralda, Colombia | |||
86966 | 86966 | 2021-11-09 | Colombia | Risaralda | 88047 | 2237 | 0 | 5.3158 | -75.9928 | 2021-11-10 04:21:38 | Risaralda, Colombia | |||
471041 | 471041 | 2021-10-07 | Ukraine | Ivano-Frankivsk Oblast | 93349 | 2237 | 0 | 48.9226 | 24.7111 | 2021-10-08 04:21:25 | Ivano-Frankivsk Oblast, Ukraine | |||
986815 | 986815 | 2021-10-04 | Colombia | Meta | 88449 | 2237 | 0 | 3.272 | -73.0877 | 2021-10-05 04:21:27 | Meta, Colombia | |||
2463452 | 2463452 | 2021-09-14 | US | Connecticut | Fairfield | 9001 | 107840 | 2237 | 0 | 41.26809896 | -73.3881171 | 2021-09-15 03:22:37 | Fairfield, Connecticut, US | |
2281333 | 2281333 | 2021-09-08 | US | New Jersey | Ocean | 34029 | 84733 | 2237 | 0 | 39.8895449 | -74.28089251 | 2021-09-09 04:21:27 | Ocean, New Jersey, US | |
3281106 | 3281106 | 2021-09-05 | Russia | Penza Oblast | 64682 | 2237 | 0 | 53.1655415 | 44.78791810000001 | 2021-09-06 04:21:22 | Penza Oblast, Russia | |||
2067741 | 2067741 | 2021-08-31 | Colombia | Caldas | 99848 | 2237 | 0 | 5.2983 | -75.2479 | 2021-09-01 04:21:38 | Caldas, Colombia | |||
1775195 | 1775195 | 2021-08-30 | Colombia | Caldas | 99833 | 2237 | 0 | 5.2983 | -75.2479 | 2021-08-31 04:21:46 | Caldas, Colombia | |||
3105508 | 3105508 | 2021-08-24 | Korea, South | 241439 | 2237 | 0 | 35.90775700000001 | 127.766922 | 2021-08-25 04:21:41 | Korea, South | ||||
2106090 | 2106090 | 2021-06-01 | US | Missouri | St. Louis | 29189 | 100092 | 2237 | 0 | 38.63770039999999 | -90.4458375 | 2021-06-02 04:24:34 | St. Louis, Missouri, US | |
1190706 | 1190706 | 2021-05-31 | US | Missouri | St. Louis | 29189 | 100061 | 2237 | 0 | 38.63770039999999 | -90.4458375 | 2021-06-01 04:23:09 | St. Louis, Missouri, US | |
3091383 | 3091383 | 2021-05-30 | US | Missouri | St. Louis | 29189 | 100038 | 2237 | 0 | 38.63770039999999 | -90.4458375 | 2021-05-31 03:08:59 | St. Louis, Missouri, US | |
52752 | 52752 | 2021-05-29 | US | Missouri | St. Louis | 29189 | 100014 | 2237 | 0 | 38.63770039999999 | -90.4458375 | 2021-05-30 04:20:55 | St. Louis, Missouri, US | |
22331 | 22331 | 2021-05-28 | US | Missouri | St. Louis | 29189 | 99977 | 2237 | 0 | 38.63770039999999 | -90.4458375 | 2021-05-29 04:20:41 | St. Louis, Missouri, US | |
20254 | 20254 | 2021-05-28 | El Salvador | 73246 | 2237 | 68408 | 2601 | 13.7942 | -88.8965 | 2021-05-29 04:20:41 | El Salvador | |||
1808706 | 1808706 | 2021-05-27 | US | Missouri | St. Louis | 29189 | 99925 | 2237 | 0 | 38.63770039999999 | -90.4458375 | 2021-05-28 04:20:36 | St. Louis, Missouri, US | |
1312129 | 1312129 | 2021-05-26 | US | Missouri | St. Louis | 29189 | 99865 | 2237 | 0 | 38.63770039999999 | -90.4458375 | 2021-05-27 04:20:59 | St. Louis, Missouri, US | |
728947 | 728947 | 2021-05-22 | US | Ohio | Cuyahoga | 39035 | 114052 | 2237 | 0 | 41.424119 | -81.65918339 | 2021-05-23 04:20:51 | Cuyahoga, Ohio, US | |
2822935 | 2822935 | 2021-05-10 | US | New Jersey | Hudson | 34017 | 87596 | 2237 | 0 | 40.73766234 | -74.07515667 | 2021-05-11 04:20:41 | Hudson, New Jersey, US | |
2503694 | 2503694 | 2021-05-07 | US | Michigan | Oakland | 26125 | 113840 | 2237 | 0 | 42.66090111 | -83.38595416 | 2021-05-08 04:21:04 | Oakland, Michigan, US | |
2502264 | 2502264 | 2021-05-07 | Russia | Perm Krai | 55147 | 2237 | 49884 | 3026 | 58.5951603 | 56.3159546 | 2021-05-08 04:21:04 | Perm Krai, Russia | ||
40053 | 40053 | 2021-04-12 | Ukraine | Kharkiv Oblast | 117759 | 2237 | 91764 | 23758 | 49.9935 | 36.2304 | 2021-04-13 04:20:37 | Kharkiv Oblast, Ukraine | ||
3643262 | 3643262 | 2021-03-30 | Belarus | 320594 | 2237 | 310983 | 7374 | 53.7098 | 27.9534 | 2021-03-31 04:26:25 | Belarus | |||
1980699 | 1980699 | 2021-03-25 | Mexico | Durango | 32095 | 2237 | 0 | 29858 | 24.5593 | -104.6588 | 2021-03-26 05:26:55 | Durango, Mexico | ||
2207949 | 2207949 | 2021-03-04 | Spain | Galicia | 112535 | 2237 | 9204 | 101094 | 42.5751 | -8.1339 | 2021-03-05 05:26:29 | Galicia, Spain | ||
280309 | 280309 | 2021-02-24 | Netherlands | Noord-Holland | 182526 | 2237 | 0 | 180070 | 52.60090600000001 | 4.918688 | 2021-02-25 05:24:57 | Noord-Holland, Netherlands | ||
3600930 | 3600930 | 2021-02-17 | Ethiopia | 149308 | 2237 | 130124 | 16947 | 9.145 | 40.4897 | 2021-02-18 05:22:58 | Ethiopia | |||
2544513 | 2544513 | 2021-01-07 | US | Texas | Hidalgo | 48215 | 61553 | 2237 | 0 | 51605 | 26.39418217 | -98.18299696 | 2021-01-08 05:22:42 | Hidalgo, Texas, US |
3033991 | 3033991 | 2021-01-05 | Afghanistan | 53011 | 2237 | 42666 | 8108 | 33.93911 | 67.709953 | 2021-01-06 05:22:16 | Afghanistan | |||
3695466 | 3695466 | 2020-12-31 | Ireland | 91779 | 2237 | 23364 | 66178 | 53.1424 | -7.6921 | 2021-01-01 05:23:07 | Ireland | |||
2119838 | 2119838 | 2020-12-20 | Netherlands | Noord-Brabant | 109039 | 2237 | 0 | 107276 | 51.561174 | 5.184942 | 2020-12-21 05:27:58 | Noord-Brabant, Netherlands | ||
1903320 | 1903320 | 2020-12-18 | US | New Jersey | Bergen | 34003 | 46404 | 2237 | 0 | 44167 | 40.96010917 | -74.07164325 | 2020-12-19 05:27:52 | Bergen, New Jersey, US |
923646 | 923646 | 2020-11-26 | India | Rajasthan | 256947 | 2237 | 227408 | 27302 | 26.583423 | 73.847973 | 2020-11-27 05:26:53 | Rajasthan, India | ||
1350604 | 1350604 | 2020-11-24 | Spain | C. Valenciana | 96469 | 2237 | 9970 | 84262 | 39.484 | -0.7533 | 2020-11-25 05:27:20 | C. Valenciana, Spain | ||
1452672 | 1452672 | 2020-10-27 | Mexico | Hidalgo | 15358 | 2237 | 12244 | 877 | 20.0911 | -98.7624 | 2020-10-28 04:24:39 | Hidalgo, Mexico | ||
786375 | 786375 | 2020-10-15 | Italy | Veneto | 33573 | 2237 | 23728 | 7608 | 45.43490485 | 12.33845213 | 2020-10-16 04:24:01 | Veneto, Italy | ||
2291191 | 2291191 | 2020-10-12 | Brazil | Piaui | 102813 | 2237 | 99255 | 1015 | -7.7183 | -42.7289 | 2020-10-13 04:24:02 | Piaui, Brazil | ||
2379772 | 2379772 | 2020-10-01 | Pakistan | Punjab | 99605 | 2237 | 95687 | 1681 | 30.811346 | 72.13913199999998 | 2020-10-02 04:23:51 | Punjab, Pakistan | ||
1515258 | 1515258 | 2020-09-28 | Colombia | Valle del Cauca | 61637 | 2237 | 53624 | 5776 | 3.8009 | -76.6413 | 2020-09-29 04:23:42 | Valle del Cauca, Colombia | ||
666452 | 666452 | 2020-09-16 | Poland | 75734 | 2237 | 62110 | 11387 | 51.9194 | 19.1451 | 2020-09-17 04:22:00 | Poland | |||
1136095 | 1136095 | 2020-06-26 | Peru | Lambayeque | 13098 | 2237 | 0 | 10861 | -6.3530489999999995 | -79.824113 | 2020-06-27 04:33:35 | Lambayeque, Peru |
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]);