johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
73 rows where deaths = 2267 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
452977 | 452977 | 2022-12-21 | US | Maryland | Montgomery | 24031 | 235202 | 2267 | 0 | 39.13676329 | -77.20358245 | 2022-12-22 04:20:56 | Montgomery, Maryland, US | |
2433540 | 2433540 | 2022-11-09 | US | Oklahoma | Tulsa | 40143 | 199937 | 2267 | 0 | 36.11939621 | -95.94013939 | 2022-11-10 04:21:16 | Tulsa, Oklahoma, US | |
482196 | 482196 | 2022-11-08 | US | Oklahoma | Tulsa | 40143 | 199937 | 2267 | 0 | 36.11939621 | -95.94013939 | 2022-11-09 04:21:22 | Tulsa, Oklahoma, US | |
2441346 | 2441346 | 2022-11-07 | US | Oklahoma | Tulsa | 40143 | 199937 | 2267 | 0 | 36.11939621 | -95.94013939 | 2022-11-08 04:21:21 | Tulsa, Oklahoma, US | |
1052444 | 1052444 | 2022-11-06 | US | Oklahoma | Tulsa | 40143 | 199937 | 2267 | 0 | 36.11939621 | -95.94013939 | 2022-11-07 04:21:26 | Tulsa, Oklahoma, US | |
620468 | 620468 | 2022-11-05 | US | Oklahoma | Tulsa | 40143 | 199937 | 2267 | 0 | 36.11939621 | -95.94013939 | 2022-11-06 04:21:24 | Tulsa, Oklahoma, US | |
1024972 | 1024972 | 2022-11-04 | US | Oklahoma | Tulsa | 40143 | 199937 | 2267 | 0 | 36.11939621 | -95.94013939 | 2022-11-05 04:21:52 | Tulsa, Oklahoma, US | |
433963 | 433963 | 2022-11-03 | US | Oklahoma | Tulsa | 40143 | 199937 | 2267 | 0 | 36.11939621 | -95.94013939 | 2022-11-04 04:22:11 | Tulsa, Oklahoma, US | |
2026344 | 2026344 | 2022-10-17 | US | Maryland | Prince George's | 24033 | 209834 | 2267 | 0 | 38.83070039 | -76.8496441 | 2022-10-18 04:22:42 | Prince George's, Maryland, US | |
2161122 | 2161122 | 2022-10-16 | US | Maryland | Prince George's | 24033 | 209692 | 2267 | 0 | 38.83070039 | -76.8496441 | 2022-10-17 04:20:31 | Prince George's, Maryland, US | |
517319 | 517319 | 2022-10-15 | US | Maryland | Prince George's | 24033 | 209692 | 2267 | 0 | 38.83070039 | -76.8496441 | 2022-10-16 04:22:39 | Prince George's, Maryland, US | |
2034376 | 2034376 | 2022-10-14 | US | Maryland | Prince George's | 24033 | 209692 | 2267 | 0 | 38.83070039 | -76.8496441 | 2022-10-15 04:22:00 | Prince George's, Maryland, US | |
3755064 | 3755064 | 2022-10-13 | US | Maryland | Prince George's | 24033 | 209568 | 2267 | 0 | 38.83070039 | -76.8496441 | 2022-10-14 04:22:28 | Prince George's, Maryland, US | |
3215889 | 3215889 | 2022-10-12 | US | Maryland | Prince George's | 24033 | 209483 | 2267 | 0 | 38.83070039 | -76.8496441 | 2022-10-13 04:22:39 | Prince George's, Maryland, US | |
1879164 | 1879164 | 2022-08-28 | US | New Jersey | Monmouth | 34025 | 197244 | 2267 | 0 | 40.26549699 | -74.22240686 | 2022-08-29 04:21:06 | Monmouth, New Jersey, US | |
2098291 | 2098291 | 2022-08-27 | US | New Jersey | Monmouth | 34025 | 197130 | 2267 | 0 | 40.26549699 | -74.22240686 | 2022-08-28 04:21:02 | Monmouth, New Jersey, US | |
1066456 | 1066456 | 2022-07-28 | US | California | San Joaquin | 6077 | 201319 | 2267 | 0 | 37.93433732 | -121.2730061 | 2022-07-29 04:20:45 | San Joaquin, California, US | |
2335975 | 2335975 | 2022-07-27 | US | California | San Joaquin | 6077 | 200405 | 2267 | 0 | 37.93433732 | -121.2730061 | 2022-07-28 04:20:56 | San Joaquin, California, US | |
1488165 | 1488165 | 2022-07-26 | US | California | San Joaquin | 6077 | 200345 | 2267 | 0 | 37.93433732 | -121.2730061 | 2022-07-27 04:21:04 | San Joaquin, California, US | |
2594611 | 2594611 | 2022-07-25 | US | California | San Joaquin | 6077 | 200269 | 2267 | 0 | 37.93433732 | -121.2730061 | 2022-07-26 04:20:58 | San Joaquin, California, US | |
896726 | 896726 | 2022-07-24 | US | California | San Joaquin | 6077 | 199267 | 2267 | 0 | 37.93433732 | -121.2730061 | 2022-07-25 04:20:51 | San Joaquin, California, US | |
91720 | 91720 | 2022-07-23 | US | California | San Joaquin | 6077 | 199244 | 2267 | 0 | 37.93433732 | -121.2730061 | 2022-07-24 04:20:47 | San Joaquin, California, US | |
900742 | 900742 | 2022-07-22 | US | California | San Joaquin | 6077 | 199212 | 2267 | 0 | 37.93433732 | -121.2730061 | 2022-07-23 04:20:53 | San Joaquin, California, US | |
229420 | 229420 | 2022-05-31 | Russia | Belgorod Oblast | 130872 | 2267 | 0 | 50.7080119 | 37.5837615 | 2022-06-01 04:20:55 | Belgorod Oblast, Russia | |||
3186185 | 3186185 | 2022-05-30 | Russia | Belgorod Oblast | 130839 | 2267 | 0 | 50.7080119 | 37.5837615 | 2022-05-31 04:20:51 | Belgorod Oblast, Russia | |||
1224180 | 1224180 | 2022-04-14 | US | California | Santa Clara | 6085 | 327831 | 2267 | 0 | 37.23104908 | -121.6970462 | 2022-04-15 04:20:57 | Santa Clara, California, US | |
2443338 | 2443338 | 2022-04-13 | US | California | Santa Clara | 6085 | 327381 | 2267 | 0 | 37.23104908 | -121.6970462 | 2022-04-13 23:21:06 | Santa Clara, California, US | |
1576364 | 1576364 | 2022-04-10 | Russia | Kemerovo Oblast | 159135 | 2267 | 0 | 54.53357809999999 | 87.342861 | 2022-04-11 04:21:02 | Kemerovo Oblast, Russia | |||
1652372 | 1652372 | 2022-04-09 | Italy | Sardegna | 244879 | 2267 | 0 | 39.21531192 | 9.110616306 | 2022-04-10 04:20:52 | Sardegna, Italy | |||
1539731 | 1539731 | 2022-03-31 | Chile | Los Lagos | 191188 | 2267 | 0 | -41.9198 | -72.1416 | 2022-04-01 04:20:28 | Los Lagos, Chile | |||
1468399 | 1468399 | 2022-03-24 | Spain | Extremadura | 248458 | 2267 | 0 | 39.4937 | -6.0679 | 2022-03-25 04:20:46 | Extremadura, Spain | |||
3022573 | 3022573 | 2022-03-23 | Spain | Extremadura | 248458 | 2267 | 0 | 39.4937 | -6.0679 | 2022-03-24 04:20:43 | Extremadura, Spain | |||
1905495 | 1905495 | 2022-03-22 | Spain | Extremadura | 248458 | 2267 | 0 | 39.4937 | -6.0679 | 2022-03-23 04:20:48 | Extremadura, Spain | |||
1905464 | 1905464 | 2022-03-22 | Russia | Zabaykalsky Krai | 163219 | 2267 | 0 | 52.248521000000004 | 115.956325 | 2022-03-23 04:20:48 | Zabaykalsky Krai, Russia | |||
356579 | 356579 | 2022-03-11 | Russia | Tambov Oblast | 105723 | 2267 | 0 | 52.9019574 | 41.3578918 | 2022-03-12 04:20:50 | Tambov Oblast, Russia | |||
1644234 | 1644234 | 2022-03-03 | Estonia | 507711 | 2267 | 0 | 58.5953 | 25.0136 | 2022-03-04 04:21:09 | Estonia | ||||
945524 | 945524 | 2022-02-28 | US | Pennsylvania | Montgomery | 42091 | 149812 | 2267 | 0 | 40.21053671 | -75.36652296 | 2022-03-01 04:21:09 | Montgomery, Pennsylvania, US | |
2735715 | 2735715 | 2022-02-27 | US | Pennsylvania | Montgomery | 42091 | 149771 | 2267 | 0 | 40.21053671 | -75.36652296 | 2022-02-28 04:21:05 | Montgomery, Pennsylvania, US | |
3048868 | 3048868 | 2022-02-26 | US | Pennsylvania | Montgomery | 42091 | 149717 | 2267 | 0 | 40.21053671 | -75.36652296 | 2022-02-27 04:21:04 | Montgomery, Pennsylvania, US | |
3720449 | 3720449 | 2022-02-21 | US | New York | Richmond | 36085 | 163765 | 2267 | 0 | 40.58582155 | -74.14808598 | 2022-02-22 04:21:01 | Richmond, New York, US | |
2780636 | 2780636 | 2021-12-31 | Ukraine | Rivne Oblast | 127499 | 2267 | 0 | 50.6199 | 26.2516 | 2022-01-01 04:22:14 | Rivne Oblast, Ukraine | |||
2088164 | 2088164 | 2021-12-14 | Russia | Astrakhan Oblast | 77402 | 2267 | 0 | 47.1878186 | 47.608851 | 2021-12-15 03:22:16 | Astrakhan Oblast, Russia | |||
3121768 | 3121768 | 2021-11-05 | Russia | Vladimir Oblast | 64424 | 2267 | 0 | 56.0503336 | 40.656163299999996 | 2021-11-06 04:21:51 | Vladimir Oblast, Russia | |||
3511484 | 3511484 | 2021-11-01 | Mexico | Chiapas | 23237 | 2267 | 0 | 16.7569 | -93.1292 | 2021-11-02 04:22:03 | Chiapas, Mexico | |||
288076 | 288076 | 2021-10-31 | Mexico | Chiapas | 23237 | 2267 | 0 | 16.7569 | -93.1292 | 2021-11-01 04:22:01 | Chiapas, Mexico | |||
2721082 | 2721082 | 2021-10-30 | Mexico | Chiapas | 23231 | 2267 | 0 | 16.7569 | -93.1292 | 2021-10-31 04:22:08 | Chiapas, Mexico | |||
567184 | 567184 | 2021-10-29 | Mexico | Chiapas | 23223 | 2267 | 0 | 16.7569 | -93.1292 | 2021-10-30 04:22:03 | Chiapas, Mexico | |||
2123565 | 2123565 | 2021-10-21 | Colombia | Caldas | 100584 | 2267 | 0 | 5.2983 | -75.2479 | 2021-10-22 04:21:14 | Caldas, Colombia | |||
600319 | 600319 | 2021-10-19 | US | Pennsylvania | Allegheny | 42003 | 129365 | 2267 | 0 | 40.46809875 | -79.98167747 | 2021-10-20 04:21:00 | Allegheny, Pennsylvania, US | |
2943192 | 2943192 | 2021-10-15 | Colombia | Meta | 89485 | 2267 | 0 | 3.272 | -73.0877 | 2021-10-16 04:21:15 | Meta, Colombia | |||
603866 | 603866 | 2021-09-23 | US | New Jersey | Ocean | 34029 | 88282 | 2267 | 0 | 39.8895449 | -74.28089251 | 2021-09-24 04:21:44 | Ocean, New Jersey, US | |
3757550 | 3757550 | 2021-09-21 | Mexico | Baja California Sur | 54803 | 2267 | 0 | 26.0444 | -111.6661 | 2021-09-22 04:21:45 | Baja California Sur, Mexico | |||
3757541 | 3757541 | 2021-09-21 | Malawi | 61416 | 2267 | 0 | -13.2543 | 34.3015 | 2021-09-22 04:21:45 | Malawi | ||||
2947397 | 2947397 | 2021-07-16 | Japan | Tokyo | 186676 | 2267 | 175695 | 8714 | 35.711343 | 139.446921 | 2021-07-17 04:22:22 | Tokyo, Japan | ||
2341846 | 2341846 | 2021-06-15 | US | Ohio | Cuyahoga | 39035 | 115671 | 2267 | 0 | 41.424119 | -81.65918339 | 2021-06-16 04:22:32 | Cuyahoga, Ohio, US | |
2716825 | 2716825 | 2021-06-10 | Colombia | Narino | 68228 | 2267 | 63632 | 2329 | 1.2892 | -77.3579 | 2021-06-11 04:23:20 | Narino, Colombia | ||
2318924 | 2318924 | 2021-06-04 | Ukraine | Donetsk Oblast | 89653 | 2267 | 84924 | 2462 | 48.0159 | 37.8028 | 2021-06-05 04:23:03 | Donetsk Oblast, Ukraine | ||
1773507 | 1773507 | 2021-05-23 | US | New Jersey | Hudson | 34017 | 87773 | 2267 | 0 | 40.73766234 | -74.07515667 | 2021-05-24 04:20:53 | Hudson, New Jersey, US | |
2021049 | 2021049 | 2021-04-20 | Sweden | Vastra Gotaland | 162392 | 2267 | 0 | 160125 | 58.2528 | 13.0596 | 2021-04-21 04:21:14 | Vastra Gotaland, Sweden | ||
2411170 | 2411170 | 2021-04-19 | Sweden | Vastra Gotaland | 159744 | 2267 | 0 | 157477 | 58.2528 | 13.0596 | 2021-04-20 04:20:41 | Vastra Gotaland, Sweden | ||
3129847 | 3129847 | 2021-04-18 | Sweden | Vastra Gotaland | 159744 | 2267 | 0 | 157477 | 58.2528 | 13.0596 | 2021-04-19 04:20:57 | Vastra Gotaland, Sweden | ||
983275 | 983275 | 2021-04-17 | Sweden | Vastra Gotaland | 159744 | 2267 | 0 | 157477 | 58.2528 | 13.0596 | 2021-04-18 04:20:41 | Vastra Gotaland, Sweden | ||
170370 | 170370 | 2021-04-16 | Sweden | Vastra Gotaland | 159744 | 2267 | 0 | 157477 | 58.2528 | 13.0596 | 2021-04-17 04:20:40 | Vastra Gotaland, Sweden | ||
240964 | 240964 | 2021-04-02 | Belarus | 324694 | 2267 | 315226 | 7201 | 53.7098 | 27.9534 | 2021-04-03 04:20:44 | Belarus | |||
3622123 | 3622123 | 2021-03-17 | US | Illinois | Unassigned | 90017 | 97 | 2267 | 0 | 42.36542373 | 0.0 | 2021-03-18 05:26:22 | Unassigned, Illinois, US | |
1588272 | 1588272 | 2021-02-05 | Mexico | Quintana Roo | 19145 | 2267 | 0 | 16878 | 19.1817 | -88.4791 | 2021-02-06 05:23:55 | Quintana Roo, Mexico | ||
2864585 | 2864585 | 2021-01-06 | Costa Rica | 175038 | 2267 | 134911 | 37860 | 9.7489 | -83.7534 | 2021-01-07 05:22:03 | Costa Rica | |||
3763709 | 3763709 | 2020-12-28 | US | Nevada | Clark | 32003 | 165318 | 2267 | 0 | 163051 | 36.21458855 | -115.0130241 | 2020-12-29 05:22:37 | Clark, Nevada, US |
2408984 | 2408984 | 2020-12-23 | US | New Jersey | Bergen | 34003 | 48530 | 2267 | 0 | 46263 | 40.96010917 | -74.07164325 | 2020-12-24 05:23:04 | Bergen, New Jersey, US |
3338689 | 3338689 | 2020-11-17 | Mexico | San Luis Potosi | 31962 | 2267 | 0 | 29695 | 22.1565 | -100.9855 | 2020-11-18 05:40:31 | San Luis Potosi, Mexico | ||
1988514 | 1988514 | 2020-11-09 | Dominican Republic | 130603 | 2267 | 108383 | 19953 | 18.7357 | -70.1627 | 2020-11-10 05:40:07 | Dominican Republic | |||
892036 | 892036 | 2020-11-05 | Germany | Nordrhein-Westfalen | 153766 | 2267 | 97827 | 58903 | 51.4332 | 7.6616 | 2020-11-06 05:24:55 | Nordrhein-Westfalen, Germany | ||
3531377 | 3531377 | 2020-08-12 | Guatemala | 59089 | 2267 | 47394 | 9428 | 15.7835 | -90.2308 | 2020-08-13 04:29:15 | Guatemala |
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]);