johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
51 rows where deaths = 3228 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
308063 | 308063 | 2022-12-13 | Peru | San Martin | 68654 | 3228 | 0 | -7.039531 | -76.729127 | 2022-12-14 04:21:04 | San Martin, Peru | |||
1149124 | 1149124 | 2022-12-12 | Peru | San Martin | 68654 | 3228 | 0 | -7.039531 | -76.729127 | 2022-12-13 04:21:01 | San Martin, Peru | |||
868978 | 868978 | 2022-12-11 | Peru | San Martin | 68654 | 3228 | 0 | -7.039531 | -76.729127 | 2022-12-12 04:21:01 | San Martin, Peru | |||
257508 | 257508 | 2022-12-10 | Peru | San Martin | 68654 | 3228 | 0 | -7.039531 | -76.729127 | 2022-12-11 04:20:50 | San Martin, Peru | |||
3936222 | 3936222 | 2022-12-09 | Peru | San Martin | 68654 | 3228 | 0 | -7.039531 | -76.729127 | 2022-12-10 04:21:02 | San Martin, Peru | |||
3377554 | 3377554 | 2022-12-08 | Peru | San Martin | 68654 | 3228 | 0 | -7.039531 | -76.729127 | 2022-12-09 04:21:05 | San Martin, Peru | |||
1984825 | 1984825 | 2022-12-07 | Peru | San Martin | 68654 | 3228 | 0 | -7.039531 | -76.729127 | 2022-12-08 04:21:07 | San Martin, Peru | |||
3714348 | 3714348 | 2022-12-06 | Peru | San Martin | 68654 | 3228 | 0 | -7.039531 | -76.729127 | 2022-12-07 04:20:58 | San Martin, Peru | |||
312079 | 312079 | 2022-11-13 | Peru | San Martin | 67254 | 3228 | 0 | -7.039531 | -76.729127 | 2022-11-14 04:21:09 | San Martin, Peru | |||
63240 | 63240 | 2022-11-12 | Peru | San Martin | 67254 | 3228 | 0 | -7.039531 | -76.729127 | 2022-11-13 04:21:14 | San Martin, Peru | |||
2927402 | 2927402 | 2022-11-11 | Peru | San Martin | 67254 | 3228 | 0 | -7.039531 | -76.729127 | 2022-11-12 04:20:41 | San Martin, Peru | |||
2506238 | 2506238 | 2022-11-10 | Peru | San Martin | 67254 | 3228 | 0 | -7.039531 | -76.729127 | 2022-11-11 04:21:22 | San Martin, Peru | |||
2431113 | 2431113 | 2022-11-09 | Peru | San Martin | 67254 | 3228 | 0 | -7.039531 | -76.729127 | 2022-11-10 04:21:16 | San Martin, Peru | |||
479769 | 479769 | 2022-11-08 | Peru | San Martin | 67254 | 3228 | 0 | -7.039531 | -76.729127 | 2022-11-09 04:21:22 | San Martin, Peru | |||
2438919 | 2438919 | 2022-11-07 | Peru | San Martin | 67254 | 3228 | 0 | -7.039531 | -76.729127 | 2022-11-08 04:21:21 | San Martin, Peru | |||
1050017 | 1050017 | 2022-11-06 | Peru | San Martin | 67214 | 3228 | 0 | -7.039531 | -76.729127 | 2022-11-07 04:21:26 | San Martin, Peru | |||
618041 | 618041 | 2022-11-05 | Peru | San Martin | 67214 | 3228 | 0 | -7.039531 | -76.729127 | 2022-11-06 04:21:24 | San Martin, Peru | |||
1022545 | 1022545 | 2022-11-04 | Peru | San Martin | 67214 | 3228 | 0 | -7.039531 | -76.729127 | 2022-11-05 04:21:52 | San Martin, Peru | |||
431536 | 431536 | 2022-11-03 | Peru | San Martin | 67214 | 3228 | 0 | -7.039531 | -76.729127 | 2022-11-04 04:22:11 | San Martin, Peru | |||
849778 | 849778 | 2022-11-02 | Peru | San Martin | 67214 | 3228 | 0 | -7.039531 | -76.729127 | 2022-11-03 04:22:05 | San Martin, Peru | |||
710629 | 710629 | 2022-11-01 | Peru | San Martin | 67214 | 3228 | 0 | -7.039531 | -76.729127 | 2022-11-02 04:22:09 | San Martin, Peru | |||
3285078 | 3285078 | 2022-10-31 | Peru | San Martin | 67214 | 3228 | 0 | -7.039531 | -76.729127 | 2022-11-01 04:22:36 | San Martin, Peru | |||
198478 | 198478 | 2022-10-19 | Russia | Komi Republic | 188386 | 3228 | 0 | 63.9881421 | 54.3326073 | 2022-10-20 04:22:59 | Komi Republic, Russia | |||
2494700 | 2494700 | 2022-08-15 | US | Connecticut | Hartford | 9003 | 208668 | 3228 | 0 | 41.80283011 | -72.73103891 | 2022-08-16 04:20:58 | Hartford, Connecticut, US | |
3648250 | 3648250 | 2022-08-14 | US | Connecticut | Hartford | 9003 | 208618 | 3228 | 0 | 41.80283011 | -72.73103891 | 2022-08-15 04:20:59 | Hartford, Connecticut, US | |
1969256 | 1969256 | 2022-08-13 | US | Connecticut | Hartford | 9003 | 208520 | 3228 | 0 | 41.80283011 | -72.73103891 | 2022-08-14 04:20:55 | Hartford, Connecticut, US | |
2889065 | 2889065 | 2022-08-12 | US | Connecticut | Hartford | 9003 | 208344 | 3228 | 0 | 41.80283011 | -72.73103891 | 2022-08-13 04:20:52 | Hartford, Connecticut, US | |
3908670 | 3908670 | 2022-08-11 | US | Connecticut | Hartford | 9003 | 208180 | 3228 | 0 | 41.80283011 | -72.73103891 | 2022-08-12 04:20:54 | Hartford, Connecticut, US | |
1346987 | 1346987 | 2022-08-10 | US | Connecticut | Hartford | 9003 | 207982 | 3228 | 0 | 41.80283011 | -72.73103891 | 2022-08-11 04:20:49 | Hartford, Connecticut, US | |
3241321 | 3241321 | 2022-03-21 | US | Tennessee | Shelby | 47157 | 234912 | 3228 | 0 | 35.1864775 | -89.89692423 | 2022-03-22 04:20:54 | Shelby, Tennessee, US | |
1783017 | 1783017 | 2022-01-27 | Ukraine | Ivano-Frankivsk Oblast | 153688 | 3228 | 0 | 48.9226 | 24.7111 | 2022-01-28 04:21:09 | Ivano-Frankivsk Oblast, Ukraine | |||
2832916 | 2832916 | 2022-01-22 | Mexico | Durango | 60597 | 3228 | 0 | 24.5593 | -104.6588 | 2022-01-23 04:21:13 | Durango, Mexico | |||
3425034 | 3425034 | 2022-01-21 | Mexico | Durango | 60597 | 3228 | 0 | 24.5593 | -104.6588 | 2022-01-22 04:21:13 | Durango, Mexico | |||
102972 | 102972 | 2022-01-14 | Ukraine | Vinnytsia Oblast | 115673 | 3228 | 0 | 49.2331 | 28.4682 | 2022-01-15 04:21:07 | Vinnytsia Oblast, Ukraine | |||
2609720 | 2609720 | 2022-01-06 | Albania | 213257 | 3228 | 0 | 41.1533 | 20.1683 | 2022-01-07 04:22:09 | Albania | ||||
1282225 | 1282225 | 2022-01-05 | Russia | Omsk Oblast | 131726 | 3228 | 0 | 56.09352629999999 | 73.5099936 | 2022-01-06 04:22:09 | Omsk Oblast, Russia | |||
447498 | 447498 | 2021-11-17 | Netherlands | Noord-Brabant | 359349 | 3228 | 0 | 51.561174 | 5.1849419999999995 | 2021-11-18 04:21:33 | Noord-Brabant, Netherlands | |||
3643176 | 3643176 | 2021-11-08 | Uganda | 126625 | 3228 | 0 | 1.373333 | 32.290275 | 2021-11-09 04:21:36 | Uganda | ||||
7130 | 7130 | 2021-10-28 | US | Puerto Rico | Unassigned | 72999 | 4111 | 3228 | 0 | 18.459681 | -67.336525 | 2021-10-29 04:22:03 | Unassigned, Puerto Rico, US | |
601886 | 601886 | 2021-09-23 | Russia | Chelyabinsk Oblast | 93416 | 3228 | 0 | 54.4223954 | 61.1865846 | 2021-09-24 04:21:44 | Chelyabinsk Oblast, Russia | |||
3472055 | 3472055 | 2021-06-08 | Burma | 144579 | 3228 | 132615 | 8736 | 21.9162 | 95.956 | 2021-06-09 04:23:31 | Burma | |||
3663745 | 3663745 | 2021-03-09 | North Macedonia | 108350 | 3228 | 95822 | 9300 | 41.6086 | 21.7453 | 2021-03-10 05:24:35 | North Macedonia | |||
471271 | 471271 | 2021-02-19 | Colombia | Santander | 89269 | 3228 | 83573 | 2468 | 6.6437 | -73.6536 | 2021-02-20 05:22:51 | Santander, Colombia | ||
1676463 | 1676463 | 2021-02-01 | Italy | Puglia | 123286 | 3228 | 67974 | 52084 | 41.12559576 | 16.86736689 | 2021-02-02 05:22:49 | Puglia, Italy | ||
3515510 | 3515510 | 2021-01-15 | Moldova | 152263 | 3228 | 141975 | 7060 | 47.4116 | 28.3699 | 2021-01-16 05:22:40 | Moldova | |||
740539 | 740539 | 2020-12-02 | US | New York | New York | 36061 | 45515 | 3228 | 0 | 42287 | 40.76727260000001 | -73.97152637 | 2020-12-03 05:28:22 | New York, New York, US |
2785104 | 2785104 | 2020-11-13 | Mexico | Sonora | 40182 | 3228 | 0 | 36954 | 29.2972 | -110.3309 | 2020-11-14 05:25:37 | Sonora, Mexico | ||
1516098 | 1516098 | 2020-09-28 | US | Florida | Miami-Dade | 12086 | 169466 | 3228 | 0 | 166238 | 25.6112362 | -80.55170587 | 2020-09-29 04:23:42 | Miami-Dade, Florida, US |
194039 | 194039 | 2020-08-31 | India | West Bengal | 162778 | 3228 | 134270 | 25280 | 23.814082 | 87.979803 | 2020-09-01 04:28:31 | West Bengal, India | ||
582572 | 582572 | 2020-08-13 | Brazil | Maranhao | 134193 | 3228 | 123772 | 7193 | -4.9609 | -45.2744 | 2020-08-14 04:51:19 | Maranhao, Brazil | ||
2740496 | 2740496 | 2020-08-03 | Bolivia | 81846 | 3228 | 24510 | 54108 | -16.2902 | -63.5887 | 2020-08-04 04:41:59 | Bolivia |
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]);