johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
82 rows where deaths = 1833 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 19
- US 35
- Colombia 10
- Russia 7
- Germany 5
- Mexico 4
- Brazil 3
- Ukraine 3
- Netherlands 2
- Peru 2
- Switzerland 2
- India 1
- Japan 1
- Korea, South 1
- Malaysia 1
- Paraguay 1
- Portugal 1
- Senegal 1
- United Kingdom 1
- West Bank and Gaza 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2953734 | 2953734 | 2022-12-20 | US | North Carolina | Mecklenburg | 37119 | 350674 | 1833 | 0 | 35.24469268 | -80.8317671 | 2022-12-21 04:21:03 | Mecklenburg, North Carolina, US | |
3176136 | 3176136 | 2022-12-19 | US | North Carolina | Mecklenburg | 37119 | 350674 | 1833 | 0 | 35.24469268 | -80.8317671 | 2022-12-20 04:21:04 | Mecklenburg, North Carolina, US | |
1630653 | 1630653 | 2022-12-18 | US | North Carolina | Mecklenburg | 37119 | 350674 | 1833 | 0 | 35.24469268 | -80.8317671 | 2022-12-19 04:21:03 | Mecklenburg, North Carolina, US | |
506032 | 506032 | 2022-12-17 | US | North Carolina | Mecklenburg | 37119 | 350674 | 1833 | 0 | 35.24469268 | -80.8317671 | 2022-12-18 04:21:03 | Mecklenburg, North Carolina, US | |
3326604 | 3326604 | 2022-12-16 | US | North Carolina | Mecklenburg | 37119 | 350674 | 1833 | 0 | 35.24469268 | -80.8317671 | 2022-12-17 04:21:04 | Mecklenburg, North Carolina, US | |
545116 | 545116 | 2022-12-15 | US | North Carolina | Mecklenburg | 37119 | 350674 | 1833 | 0 | 35.24469268 | -80.8317671 | 2022-12-16 04:21:01 | Mecklenburg, North Carolina, US | |
350644 | 350644 | 2022-12-14 | US | North Carolina | Mecklenburg | 37119 | 350674 | 1833 | 0 | 35.24469268 | -80.8317671 | 2022-12-15 04:20:58 | Mecklenburg, North Carolina, US | |
3765782 | 3765782 | 2022-09-11 | Germany | Saarland | 400540 | 1833 | 0 | 49.3964 | 7.023 | 2022-09-12 04:20:58 | Saarland, Germany | |||
3824357 | 3824357 | 2022-09-10 | Germany | Saarland | 400540 | 1833 | 0 | 49.3964 | 7.023 | 2022-09-11 04:20:50 | Saarland, Germany | |||
962814 | 962814 | 2022-09-09 | Germany | Saarland | 400540 | 1833 | 0 | 49.3964 | 7.023 | 2022-09-10 04:21:10 | Saarland, Germany | |||
253216 | 253216 | 2022-09-08 | Germany | Saarland | 400120 | 1833 | 0 | 49.3964 | 7.023 | 2022-09-09 04:21:11 | Saarland, Germany | |||
2343253 | 2343253 | 2022-08-31 | Colombia | Cauca | 76028 | 1833 | 0 | 2.705 | -76.826 | 2022-09-01 04:21:03 | Cauca, Colombia | |||
3773733 | 3773733 | 2022-08-30 | Colombia | Cauca | 76028 | 1833 | 0 | 2.705 | -76.826 | 2022-08-31 04:20:57 | Cauca, Colombia | |||
1680329 | 1680329 | 2022-08-29 | Colombia | Cauca | 76028 | 1833 | 0 | 2.705 | -76.826 | 2022-08-30 04:21:03 | Cauca, Colombia | |||
1876813 | 1876813 | 2022-08-28 | Colombia | Cauca | 76028 | 1833 | 0 | 2.705 | -76.826 | 2022-08-29 04:21:06 | Cauca, Colombia | |||
2095940 | 2095940 | 2022-08-27 | Colombia | Cauca | 76028 | 1833 | 0 | 2.705 | -76.826 | 2022-08-28 04:21:02 | Cauca, Colombia | |||
1531755 | 1531755 | 2022-08-26 | Colombia | Cauca | 76028 | 1833 | 0 | 2.705 | -76.826 | 2022-08-27 04:20:57 | Cauca, Colombia | |||
2828642 | 2828642 | 2022-08-25 | Colombia | Cauca | 76028 | 1833 | 0 | 2.705 | -76.826 | 2022-08-26 04:21:02 | Cauca, Colombia | |||
3873136 | 3873136 | 2022-07-31 | US | Maryland | Baltimore City | 24510 | 129540 | 1833 | 0 | 39.30211911 | -76.61151012 | 2022-08-01 04:21:03 | Baltimore City, Maryland, US | |
675890 | 675890 | 2022-07-30 | US | Maryland | Baltimore City | 24510 | 129540 | 1833 | 0 | 39.30211911 | -76.61151012 | 2022-07-31 04:21:02 | Baltimore City, Maryland, US | |
1785089 | 1785089 | 2022-07-29 | US | Maryland | Baltimore City | 24510 | 129540 | 1833 | 0 | 39.30211911 | -76.61151012 | 2022-07-30 04:20:42 | Baltimore City, Maryland, US | |
1487574 | 1487574 | 2022-07-26 | Japan | Chiba | 571052 | 1833 | 0 | 35.510141 | 140.198917 | 2022-07-27 04:21:04 | Chiba, Japan | |||
3984211 | 3984211 | 2022-06-15 | US | Massachusetts | Hampden | 25013 | 145447 | 1833 | 0 | 42.13440424 | -72.63235561 | 2022-06-16 04:20:55 | Hampden, Massachusetts, US | |
2237552 | 2237552 | 2022-06-12 | US | New Jersey | Camden | 34007 | 136937 | 1833 | 0 | 39.80343818 | -74.96388753 | 2022-06-13 04:21:14 | Camden, New Jersey, US | |
3143750 | 3143750 | 2022-06-11 | US | New Jersey | Camden | 34007 | 136834 | 1833 | 0 | 39.80343818 | -74.96388753 | 2022-06-12 04:20:53 | Camden, New Jersey, US | |
658556 | 658556 | 2022-05-13 | Russia | Pskov Oblast | 109998 | 1833 | 0 | 57.5358729 | 28.8586826 | 2022-05-14 04:20:48 | Pskov Oblast, Russia | |||
2534508 | 2534508 | 2022-05-12 | US | Indiana | Lake | 18089 | 108373 | 1833 | 0 | 41.41874274 | -87.38277575 | 2022-05-13 04:20:51 | Lake, Indiana, US | |
2533639 | 2533639 | 2022-05-12 | Russia | Pskov Oblast | 109960 | 1833 | 0 | 57.5358729 | 28.8586826 | 2022-05-13 04:20:51 | Pskov Oblast, Russia | |||
3445954 | 3445954 | 2022-05-11 | US | Indiana | Lake | 18089 | 108373 | 1833 | 0 | 41.41874274 | -87.38277575 | 2022-05-12 04:20:54 | Lake, Indiana, US | |
3445085 | 3445085 | 2022-05-11 | Russia | Pskov Oblast | 109924 | 1833 | 0 | 57.5358729 | 28.8586826 | 2022-05-12 04:20:54 | Pskov Oblast, Russia | |||
465583 | 465583 | 2022-05-02 | US | New Mexico | Bernalillo | 35001 | 148266 | 1833 | 0 | 35.05163625 | -106.6703554 | 2022-05-03 04:21:00 | Bernalillo, New Mexico, US | |
1224137 | 1224137 | 2022-04-14 | US | California | Alameda | 6001 | 271974 | 1833 | 0 | 37.64629437 | -121.8929271 | 2022-04-15 04:20:57 | Alameda, California, US | |
2443295 | 2443295 | 2022-04-13 | US | California | Alameda | 6001 | 271497 | 1833 | 0 | 37.64629437 | -121.8929271 | 2022-04-13 23:21:06 | Alameda, California, US | |
1540018 | 1540018 | 2022-03-31 | Malaysia | Perak | 189456 | 1833 | 0 | 4.5921 | 101.0901 | 2022-04-01 04:20:28 | Perak, Malaysia | |||
877078 | 877078 | 2022-03-27 | US | Georgia | Gwinnett | 13135 | 206174 | 1833 | 0 | 33.96044201 | -84.02137802 | 2022-03-28 04:20:33 | Gwinnett, Georgia, US | |
2164361 | 2164361 | 2022-03-26 | US | Georgia | Gwinnett | 13135 | 206174 | 1833 | 0 | 33.96044201 | -84.02137802 | 2022-03-27 04:20:47 | Gwinnett, Georgia, US | |
1721297 | 1721297 | 2022-03-25 | US | Georgia | Gwinnett | 13135 | 206174 | 1833 | 0 | 33.96044201 | -84.02137802 | 2022-03-26 04:20:23 | Gwinnett, Georgia, US | |
1468354 | 1468354 | 2022-03-24 | Russia | Tatarstan Republic | 135300 | 1833 | 0 | 55.7648572 | 52.43104273 | 2022-03-25 04:20:46 | Tatarstan Republic, Russia | |||
1232207 | 1232207 | 2021-11-28 | US | California | San Joaquin | 6077 | 107434 | 1833 | 0 | 37.93433732 | -121.2730061 | 2021-11-29 04:22:30 | San Joaquin, California, US | |
1358914 | 1358914 | 2021-11-27 | US | California | San Joaquin | 6077 | 106904 | 1833 | 0 | 37.93433732 | -121.2730061 | 2021-11-28 04:22:43 | San Joaquin, California, US | |
758905 | 758905 | 2021-11-26 | US | California | San Joaquin | 6077 | 106903 | 1833 | 0 | 37.93433732 | -121.2730061 | 2021-11-27 04:22:45 | San Joaquin, California, US | |
1803322 | 1803322 | 2021-11-25 | US | California | San Joaquin | 6077 | 106899 | 1833 | 0 | 37.93433732 | -121.2730061 | 2021-11-26 04:22:33 | San Joaquin, California, US | |
904756 | 904756 | 2021-11-24 | US | California | San Joaquin | 6077 | 106896 | 1833 | 0 | 37.93433732 | -121.2730061 | 2021-11-25 04:22:33 | San Joaquin, California, US | |
3070606 | 3070606 | 2021-11-23 | US | California | San Joaquin | 6077 | 106885 | 1833 | 0 | 37.93433732 | -121.2730061 | 2021-11-24 04:22:14 | San Joaquin, California, US | |
3749704 | 3749704 | 2021-11-22 | US | California | San Joaquin | 6077 | 106811 | 1833 | 0 | 37.93433732 | -121.2730061 | 2021-11-23 04:22:39 | San Joaquin, California, US | |
1014460 | 1014460 | 2021-11-21 | Netherlands | Limburg | 173783 | 1833 | 0 | 51.209227 | 5.93387 | 2021-11-22 04:22:20 | Limburg, Netherlands | |||
290459 | 290459 | 2021-10-31 | US | Ohio | Franklin | 39049 | 166294 | 1833 | 0 | 39.96995815 | -83.01115755 | 2021-11-01 04:22:01 | Franklin, Ohio, US | |
1909461 | 1909461 | 2021-10-17 | Russia | Smolensk Oblast | 54488 | 1833 | 0 | 55.03434960000001 | 33.0192065 | 2021-10-18 04:21:10 | Smolensk Oblast, Russia | |||
2076210 | 2076210 | 2021-09-26 | Russia | Vologda Oblast | 67730 | 1833 | 0 | 60.0391461 | 43.1215213 | 2021-09-27 04:21:16 | Vologda Oblast, Russia | |||
3757556 | 3757556 | 2021-09-21 | Mexico | Colima | 30418 | 1833 | 0 | 19.1223 | -104.0072 | 2021-09-22 04:21:45 | Colima, Mexico | |||
1375070 | 1375070 | 2021-09-15 | US | California | Santa Clara | 6085 | 139472 | 1833 | 0 | 37.23104908 | -121.6970462 | 2021-09-16 04:22:19 | Santa Clara, California, US | |
1385906 | 1385906 | 2021-09-13 | Senegal | 73500 | 1833 | 0 | 14.4974 | -14.4524 | 2021-09-14 04:21:41 | Senegal | ||||
3284515 | 3284515 | 2021-09-05 | Ukraine | Zhytomyr Oblast | 90089 | 1833 | 0 | 50.2547 | 28.6587 | 2021-09-06 04:21:22 | Zhytomyr Oblast, Ukraine | |||
2069621 | 2069621 | 2021-08-31 | US | Minnesota | Hennepin | 27053 | 135016 | 1833 | 0 | 45.00761521 | -93.47694895 | 2021-09-01 04:21:38 | Hennepin, Minnesota, US | |
650045 | 650045 | 2021-08-09 | Mexico | Chiapas | 16496 | 1833 | 0 | 16.7569 | -93.1292 | 2021-08-10 04:21:27 | Chiapas, Mexico | |||
1117788 | 1117788 | 2021-08-06 | Russia | Dagestan Republic | 42909 | 1833 | 0 | 43.05749160000001 | 47.1332224 | 2021-08-07 04:21:30 | Dagestan Republic, Russia | |||
1892979 | 1892979 | 2021-06-30 | Colombia | Caldas | 89206 | 1833 | 84426 | 2947 | 5.2983 | -75.2479 | 2021-07-01 04:21:19 | Caldas, Colombia | ||
399994 | 399994 | 2021-06-29 | Brazil | Amapa | 116991 | 1833 | 94183 | 20975 | 0.902 | -52.003 | 2021-06-30 04:21:41 | Amapa, Brazil | ||
3362303 | 3362303 | 2021-06-21 | Ukraine | Mykolaiv Oblast | 69757 | 1833 | 67398 | 526 | 46.975 | 31.9946 | 2021-06-22 04:21:34 | Mykolaiv Oblast, Ukraine | ||
1191001 | 1191001 | 2021-05-31 | US | New York | Richmond | 36085 | 74665 | 1833 | 0 | 40.58582155 | -74.14808598 | 2021-06-01 04:23:09 | Richmond, New York, US | |
3091678 | 3091678 | 2021-05-30 | US | New York | Richmond | 36085 | 74644 | 1833 | 0 | 40.58582155 | -74.14808598 | 2021-05-31 03:08:59 | Richmond, New York, US | |
2824837 | 2824837 | 2021-05-01 | Korea, South | 123240 | 1833 | 112865 | 8542 | 35.90775700000001 | 127.766922 | 2021-05-02 04:20:48 | Korea, South | |||
2020572 | 2020572 | 2021-04-20 | Colombia | Huila | 52560 | 1833 | 49970 | 757 | 2.5359 | -75.5277 | 2021-04-21 04:21:14 | Huila, Colombia | ||
40052 | 40052 | 2021-04-12 | Ukraine | Ivano-Frankivsk Oblast | 81833 | 1833 | 70196 | 9804 | 48.9226 | 24.7111 | 2021-04-13 04:20:37 | Ivano-Frankivsk Oblast, Ukraine | ||
3667744 | 3667744 | 2021-03-06 | Netherlands | Gelderland | 124618 | 1833 | 0 | 122625 | 52.061738 | 5.939114 | 2021-03-07 05:21:54 | Gelderland, Netherlands | ||
998284 | 998284 | 2021-03-01 | Colombia | Cordoba | 37350 | 1833 | 34268 | 1249 | 8.0493 | -75.574 | 2021-03-02 05:23:30 | Cordoba, Colombia | ||
282351 | 282351 | 2021-02-24 | US | New Jersey | Ocean | 34029 | 57480 | 1833 | 0 | 55647 | 39.8895449 | -74.28089251 | 2021-02-25 05:24:57 | Ocean, New Jersey, US |
280357 | 280357 | 2021-02-24 | Peru | Ucayali | 22453 | 1833 | 0 | 20620 | -9.621718 | -73.444929 | 2021-02-25 05:24:57 | Ucayali, Peru | ||
1463422 | 1463422 | 2021-01-31 | West Bank and Gaza | 158962 | 1833 | 148993 | 8136 | 31.9522 | 35.2332 | 2021-02-01 05:22:53 | West Bank and Gaza | |||
237150 | 237150 | 2021-01-18 | Germany | Berlin | 112511 | 1833 | 95722 | 15478 | 52.52 | 13.405 | 2021-01-19 05:22:15 | Berlin, Germany | ||
2227159 | 2227159 | 2020-12-26 | United Kingdom | Northern Ireland | 63723 | 1833 | 0 | 62483 | 54.7877 | -6.4923 | 2020-12-27 05:22:55 | Northern Ireland, United Kingdom | ||
1901116 | 1901116 | 2020-12-18 | India | Jammu and Kashmir | 117705 | 1833 | 111628 | 4244 | 33.75943 | 76.612638 | 2020-12-19 05:27:52 | Jammu and Kashmir, India | ||
1632451 | 1632451 | 2020-12-05 | Paraguay | 87213 | 1833 | 61283 | 24097 | -23.4425 | -58.4438 | 2020-12-06 05:26:18 | Paraguay | |||
1632044 | 1632044 | 2020-12-05 | Brazil | Mato Grosso do Sul | 105223 | 1833 | 90152 | 12748 | -20.7722 | -54.7852 | 2020-12-06 05:26:18 | Mato Grosso do Sul, Brazil | ||
81766 | 81766 | 2020-10-14 | US | Pennsylvania | Philadelphia | 42101 | 39631 | 1833 | 0 | 37798 | 40.00338507 | -75.1379271 | 2020-10-15 04:24:28 | Philadelphia, Pennsylvania, US |
1121674 | 1121674 | 2020-09-17 | Mexico | Hidalgo | 11764 | 1833 | 9402 | 529 | 20.0911 | -98.7624 | 2020-09-18 05:05:00 | Hidalgo, Mexico | ||
2661951 | 2661951 | 2020-09-04 | Portugal | 59457 | 1833 | 42576 | 15048 | 39.3999 | -8.2245 | 2020-09-05 04:28:19 | Portugal | |||
3923637 | 3923637 | 2020-08-09 | Switzerland | 36603 | 1833 | 32300 | 2470 | 46.8182 | 8.2275 | 2020-08-10 04:34:55 | Switzerland | |||
371805 | 371805 | 2020-08-08 | Switzerland | 36451 | 1833 | 31900 | 2718 | 46.8182 | 8.2275 | 2020-08-09 04:34:54 | Switzerland | |||
753621 | 753621 | 2020-08-01 | Brazil | Paraiba | 83461 | 1833 | 35971 | 45657 | -7.24 | -36.782 | 2020-08-02 04:34:47 | Paraiba, Brazil | ||
753289 | 753289 | 2020-08-01 | Peru | Ancash | 11796 | 1833 | 0 | 9963 | -9.407125 | -77.67179499999997 | 2020-08-02 04:34:47 | Ancash, Peru | ||
442730 | 442730 | 2020-07-26 | Mexico | Tabasco | 19556 | 1833 | 15372 | 2351 | 17.8409 | -92.6189 | 2020-07-27 04:35:02 | Tabasco, Mexico |
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]);