johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
75 rows where deaths = 2157 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
544959 | 544959 | 2022-12-15 | US | New Mexico | Bernalillo | 35001 | 192776 | 2157 | 0 | 35.05163625 | -106.6703554 | 2022-12-16 04:21:01 | Bernalillo, New Mexico, US | |
134433 | 134433 | 2022-10-04 | Yemen | 11935 | 2157 | 0 | 15.552727 | 48.516388 | 2022-10-05 04:23:06 | Yemen | ||||
2689380 | 2689380 | 2022-10-03 | Yemen | 11935 | 2157 | 0 | 15.552727 | 48.516388 | 2022-10-04 04:22:55 | Yemen | ||||
2688171 | 2688171 | 2022-10-03 | US | Ohio | Hamilton | 39061 | 220948 | 2157 | 0 | 39.19673558 | -84.54502924 | 2022-10-04 04:22:55 | Hamilton, Ohio, US | |
2263447 | 2263447 | 2022-10-02 | Yemen | 11935 | 2157 | 0 | 15.552727 | 48.516388 | 2022-10-03 04:23:11 | Yemen | ||||
2262238 | 2262238 | 2022-10-02 | US | Ohio | Hamilton | 39061 | 220948 | 2157 | 0 | 39.19673558 | -84.54502924 | 2022-10-03 04:23:11 | Hamilton, Ohio, US | |
2998973 | 2998973 | 2022-10-01 | Yemen | 11935 | 2157 | 0 | 15.552727 | 48.516388 | 2022-10-02 04:21:23 | Yemen | ||||
2997764 | 2997764 | 2022-10-01 | US | Ohio | Hamilton | 39061 | 220948 | 2157 | 0 | 39.19673558 | -84.54502924 | 2022-10-02 04:21:23 | Hamilton, Ohio, US | |
857299 | 857299 | 2022-09-30 | Yemen | 11935 | 2157 | 0 | 15.552727 | 48.516388 | 2022-10-01 04:23:01 | Yemen | ||||
2379225 | 2379225 | 2022-09-29 | Yemen | 11935 | 2157 | 0 | 15.552727 | 48.516388 | 2022-09-30 04:23:09 | Yemen | ||||
1563776 | 1563776 | 2022-09-28 | Yemen | 11935 | 2157 | 0 | 15.552727 | 48.516388 | 2022-09-29 04:22:34 | Yemen | ||||
3998319 | 3998319 | 2022-09-27 | Yemen | 11935 | 2157 | 0 | 15.552727 | 48.516388 | 2022-09-28 04:23:01 | Yemen | ||||
2772647 | 2772647 | 2022-09-26 | Yemen | 11935 | 2157 | 0 | 15.552727 | 48.516388 | 2022-09-27 04:23:01 | Yemen | ||||
1980300 | 1980300 | 2022-09-25 | Yemen | 11935 | 2157 | 0 | 15.552727 | 48.516388 | 2022-09-26 04:20:52 | Yemen | ||||
2653467 | 2653467 | 2022-09-24 | Yemen | 11935 | 2157 | 0 | 15.552727 | 48.516388 | 2022-09-25 04:23:31 | Yemen | ||||
387907 | 387907 | 2022-09-23 | Yemen | 11934 | 2157 | 0 | 15.552727 | 48.516388 | 2022-09-24 04:21:40 | Yemen | ||||
1627973 | 1627973 | 2022-09-22 | Yemen | 11934 | 2157 | 0 | 15.552727 | 48.516388 | 2022-09-23 04:23:13 | Yemen | ||||
254900 | 254900 | 2022-09-08 | US | Maryland | Montgomery | 24031 | 219579 | 2157 | 0 | 39.13676329 | -77.20358245 | 2022-09-09 04:21:11 | Montgomery, Maryland, US | |
1250472 | 1250472 | 2022-08-23 | Brazil | Amapa | 177954 | 2157 | 0 | 0.902 | -52.003 | 2022-08-24 04:20:46 | Amapa, Brazil | |||
2852576 | 2852576 | 2022-08-22 | Brazil | Amapa | 177954 | 2157 | 0 | 0.902 | -52.003 | 2022-08-23 04:20:56 | Amapa, Brazil | |||
2402548 | 2402548 | 2022-08-21 | Brazil | Amapa | 177915 | 2157 | 0 | 0.902 | -52.003 | 2022-08-22 04:20:38 | Amapa, Brazil | |||
3797626 | 3797626 | 2022-08-20 | Brazil | Amapa | 177915 | 2157 | 0 | 0.902 | -52.003 | 2022-08-21 04:20:44 | Amapa, Brazil | |||
2363212 | 2363212 | 2022-08-19 | Brazil | Amapa | 177915 | 2157 | 0 | 0.902 | -52.003 | 2022-08-20 04:21:01 | Amapa, Brazil | |||
1160883 | 1160883 | 2022-08-18 | Brazil | Amapa | 177892 | 2157 | 0 | 0.902 | -52.003 | 2022-08-19 04:20:54 | Amapa, Brazil | |||
3950207 | 3950207 | 2022-08-17 | Brazil | Amapa | 177871 | 2157 | 0 | 0.902 | -52.003 | 2022-08-18 04:21:11 | Amapa, Brazil | |||
990709 | 990709 | 2022-08-16 | Brazil | Amapa | 177812 | 2157 | 0 | 0.902 | -52.003 | 2022-08-17 04:20:59 | Amapa, Brazil | |||
3446441 | 3446441 | 2022-05-11 | US | Massachusetts | Bristol | 25005 | 154195 | 2157 | 0 | 41.79228404 | -71.10872211 | 2022-05-12 04:20:54 | Bristol, Massachusetts, US | |
223582 | 223582 | 2022-05-09 | US | Maryland | Prince George's | 24033 | 174149 | 2157 | 0 | 38.83070039 | -76.8496441 | 2022-05-10 04:20:50 | Prince George's, Maryland, US | |
2892541 | 2892541 | 2022-04-21 | Netherlands | Limburg | 526934 | 2157 | 0 | 51.209227 | 5.93387 | 2022-04-22 04:20:45 | Limburg, Netherlands | |||
2307413 | 2307413 | 2022-04-20 | Netherlands | Limburg | 526799 | 2157 | 0 | 51.209227 | 5.93387 | 2022-04-21 04:20:46 | Limburg, Netherlands | |||
1658587 | 1658587 | 2022-03-19 | US | New Jersey | Monmouth | 34025 | 162501 | 2157 | 0 | 40.26549699 | -74.22240686 | 2022-03-20 04:20:45 | Monmouth, New Jersey, US | |
338113 | 338113 | 2022-03-18 | US | New Jersey | Monmouth | 34025 | 162428 | 2157 | 0 | 40.26549699 | -74.22240686 | 2022-03-19 04:20:47 | Monmouth, New Jersey, US | |
2321509 | 2321509 | 2022-03-16 | US | New Jersey | Monmouth | 34025 | 162273 | 2157 | 0 | 40.26549699 | -74.22240686 | 2022-03-17 04:20:56 | Monmouth, New Jersey, US | |
1511990 | 1511990 | 2022-02-24 | US | California | Santa Clara | 6085 | 317948 | 2157 | 0 | 37.23104908 | -121.6970462 | 2022-02-25 04:21:11 | Santa Clara, California, US | |
2052104 | 2052104 | 2022-01-25 | Russia | Kursk Oblast | 84825 | 2157 | 0 | 51.6568453 | 36.4852695 | 2022-01-26 04:21:07 | Kursk Oblast, Russia | |||
1141028 | 1141028 | 2022-01-23 | Mozambique | 222596 | 2157 | 0 | -18.665695 | 35.529562 | 2022-01-24 04:21:12 | Mozambique | ||||
3466356 | 3466356 | 2022-01-18 | US | New Jersey | Passaic | 34031 | 134094 | 2157 | 0 | 41.03238628 | -74.29954144 | 2022-01-19 04:21:23 | Passaic, New Jersey, US | |
1474295 | 1474295 | 2022-01-17 | US | New Jersey | Passaic | 34031 | 133479 | 2157 | 0 | 41.03238628 | -74.29954144 | 2022-01-18 04:21:04 | Passaic, New Jersey, US | |
3519722 | 3519722 | 2022-01-02 | Spain | Asturias | 96040 | 2157 | 0 | 43.3614 | -5.8593 | 2022-01-03 02:22:25 | Asturias, Spain | |||
2167852 | 2167852 | 2022-01-01 | Spain | Asturias | 96040 | 2157 | 0 | 43.3614 | -5.8593 | 2022-01-02 04:20:52 | Asturias, Spain | |||
2777283 | 2777283 | 2021-12-31 | Spain | Asturias | 96040 | 2157 | 0 | 43.3614 | -5.8593 | 2022-01-01 04:22:14 | Asturias, Spain | |||
3998940 | 3998940 | 2021-12-30 | Spain | Asturias | 96040 | 2157 | 0 | 43.3614 | -5.8593 | 2021-12-31 04:21:50 | Asturias, Spain | |||
3998705 | 3998705 | 2021-12-30 | Malaysia | Kedah | 168186 | 2157 | 0 | 6.1184 | 100.3685 | 2021-12-31 04:21:50 | Kedah, Malaysia | |||
3608719 | 3608719 | 2021-12-25 | Ukraine | Volyn Oblast | 103103 | 2157 | 0 | 50.7472 | 25.3254 | 2021-12-26 04:21:50 | Volyn Oblast, Ukraine | |||
1664068 | 1664068 | 2021-12-12 | Ukraine | Rivne Oblast | 124441 | 2157 | 0 | 50.6199 | 26.2516 | 2021-12-13 04:22:02 | Rivne Oblast, Ukraine | |||
1358531 | 1358531 | 2021-11-27 | Russia | Buryatia Republic | 68846 | 2157 | 0 | 52.718242599999996 | 109.492143 | 2021-11-28 04:22:43 | Buryatia Republic, Russia | |||
1804344 | 1804344 | 2021-11-25 | US | Massachusetts | Essex | 25009 | 120475 | 2157 | 0 | 42.6687626 | -70.94687179 | 2021-11-26 04:22:33 | Essex, Massachusetts, US | |
905778 | 905778 | 2021-11-24 | US | Massachusetts | Essex | 25009 | 120475 | 2157 | 0 | 42.6687626 | -70.94687179 | 2021-11-25 04:22:33 | Essex, Massachusetts, US | |
904369 | 904369 | 2021-11-24 | Russia | Astrakhan Oblast | 72472 | 2157 | 0 | 47.1878186 | 47.608851 | 2021-11-25 04:22:33 | Astrakhan Oblast, Russia | |||
534999 | 534999 | 2021-10-27 | Russia | Vologda Oblast | 76840 | 2157 | 0 | 60.0391461 | 43.1215213 | 2021-10-28 04:22:08 | Vologda Oblast, Russia | |||
654257 | 654257 | 2021-10-22 | Russia | Vladimir Oblast | 59973 | 2157 | 0 | 56.0503336 | 40.656163299999996 | 2021-10-23 04:21:32 | Vladimir Oblast, Russia | |||
67725 | 67725 | 2021-09-01 | US | Connecticut | New Haven | 9009 | 98889 | 2157 | 0 | 41.408032500000004 | -72.93620426 | 2021-09-02 04:21:15 | New Haven, Connecticut, US | |
2068567 | 2068567 | 2021-08-31 | US | Connecticut | New Haven | 9009 | 98738 | 2157 | 0 | 41.408032500000004 | -72.93620426 | 2021-09-01 04:21:38 | New Haven, Connecticut, US | |
1776021 | 1776021 | 2021-08-30 | US | Connecticut | New Haven | 9009 | 98478 | 2157 | 0 | 41.408032500000004 | -72.93620426 | 2021-08-31 04:21:46 | New Haven, Connecticut, US | |
3892595 | 3892595 | 2021-08-29 | US | Connecticut | New Haven | 9009 | 98090 | 2157 | 0 | 41.408032500000004 | -72.93620426 | 2021-08-30 04:21:23 | New Haven, Connecticut, US | |
2793698 | 2793698 | 2021-08-28 | US | Connecticut | New Haven | 9009 | 98090 | 2157 | 0 | 41.408032500000004 | -72.93620426 | 2021-08-29 04:21:14 | New Haven, Connecticut, US | |
2793102 | 2793102 | 2021-08-28 | Malawi | 60313 | 2157 | 0 | -13.2543 | 34.3015 | 2021-08-29 04:21:14 | Malawi | ||||
2923857 | 2923857 | 2021-08-27 | US | Connecticut | New Haven | 9009 | 98090 | 2157 | 0 | 41.408032500000004 | -72.93620426 | 2021-08-28 04:21:28 | New Haven, Connecticut, US | |
2203492 | 2203492 | 2021-08-07 | Colombia | Meta | 86294 | 2157 | 0 | 3.272 | -73.0877 | 2021-08-08 04:21:33 | Meta, Colombia | |||
2317473 | 2317473 | 2021-06-04 | US | New Jersey | Ocean | 34029 | 75803 | 2157 | 0 | 39.8895449 | -74.28089251 | 2021-06-05 04:23:03 | Ocean, New Jersey, US | |
3702767 | 3702767 | 2021-04-27 | US | Connecticut | Fairfield | 9001 | 97724 | 2157 | 0 | 41.26809896 | -73.3881171 | 2021-04-28 04:20:32 | Fairfield, Connecticut, US | |
888776 | 888776 | 2021-04-26 | US | Connecticut | Fairfield | 9001 | 97641 | 2157 | 0 | 41.26809896 | -73.3881171 | 2021-04-27 04:20:52 | Fairfield, Connecticut, US | |
3003166 | 3003166 | 2021-04-06 | Colombia | Tolima | 66904 | 2157 | 63963 | 784 | 4.0925 | -75.1545 | 2021-04-07 04:20:53 | Tolima, Colombia | ||
3003059 | 3003059 | 2021-04-06 | Brazil | Tocantins | 145374 | 2157 | 123684 | 18734 | -10.1753 | -48.2982 | 2021-04-07 04:20:53 | Tocantins, Brazil | ||
3369038 | 3369038 | 2021-03-21 | Belarus | 310445 | 2157 | 301442 | 6846 | 53.7098 | 27.9534 | 2021-03-22 05:25:43 | Belarus | |||
2363130 | 2363130 | 2021-03-08 | West Bank and Gaza | 198554 | 2157 | 176507 | 19890 | 31.9522 | 35.2332 | 2021-03-09 05:28:19 | West Bank and Gaza | |||
1528144 | 1528144 | 2021-02-09 | Russia | Sverdlovsk Oblast | 73377 | 2157 | 66144 | 5076 | 58.6414755 | 61.8021546 | 2021-02-10 05:22:41 | Sverdlovsk Oblast, Russia | ||
340502 | 340502 | 2021-02-03 | Russia | Nizhny Novgorod Oblast | 85840 | 2157 | 78082 | 5601 | 55.47180329999999 | 44.0911594 | 2021-02-04 05:22:26 | Nizhny Novgorod Oblast, Russia | ||
1094071 | 1094071 | 2021-01-20 | Italy | Friuli Venezia Giulia | 62045 | 2157 | 47557 | 12331 | 45.6494354 | 13.76813649 | 2021-01-21 05:22:01 | Friuli Venezia Giulia, Italy | ||
2541261 | 2541261 | 2021-01-07 | Colombia | Norte de Santander | 42446 | 2157 | 38259 | 2030 | 7.9463 | -72.8988 | 2021-01-08 05:22:42 | Norte de Santander, Colombia | ||
2864953 | 2864953 | 2021-01-06 | Russia | Rostov Oblast | 53994 | 2157 | 44308 | 7529 | 47.6222451 | 40.7957942 | 2021-01-07 05:22:03 | Rostov Oblast, Russia | ||
1177250 | 1177250 | 2020-10-22 | Brazil | Sergipe | 83139 | 2157 | 73030 | 7952 | -10.5741 | -37.3857 | 2020-10-23 04:24:46 | Sergipe, Brazil | ||
78820 | 78820 | 2020-10-14 | Brazil | Alagoas | 89082 | 2157 | 85557 | 1368 | -9.5713 | -36.782 | 2020-10-15 04:24:28 | Alagoas, Brazil | ||
3793200 | 3793200 | 2020-08-05 | Pakistan | Punjab | 93571 | 2157 | 85180 | 6234 | 30.811346 | 72.13913199999998 | 2020-08-06 04:35:02 | Punjab, Pakistan | ||
217361 | 217361 | 2020-06-08 | Sweden | Stockholm | 14803 | 2157 | 0 | 12646 | 59.6025 | 18.1384 | 2020-06-09 03:33:03 | Stockholm, Sweden |
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]);