johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
18 rows where deaths = 6658 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3241395 | 3241395 | 2022-03-21 | US | Texas | Dallas | 48113 | 567906 | 6658 | 0 | 32.76670599 | -96.77796049999999 | 2022-03-22 04:20:54 | Dallas, Texas, US | |
2200208 | 2200208 | 2022-03-06 | US | California | Orange | 6059 | 582267 | 6658 | 0 | 33.70147516 | -117.76459979999998 | 2022-03-07 04:20:47 | Orange, California, US | |
2092665 | 2092665 | 2022-03-05 | US | California | Orange | 6059 | 582267 | 6658 | 0 | 33.70147516 | -117.76459979999998 | 2022-03-06 04:20:49 | Orange, California, US | |
2666365 | 2666365 | 2022-03-04 | US | California | Orange | 6059 | 582267 | 6658 | 0 | 33.70147516 | -117.76459979999998 | 2022-03-05 04:21:10 | Orange, California, US | |
2525453 | 2525453 | 2022-03-02 | Mexico | Guerrero | 97036 | 6658 | 0 | 17.4392 | -99.5451 | 2022-03-03 04:21:01 | Guerrero, Mexico | |||
1992747 | 1992747 | 2022-03-01 | Mexico | Guerrero | 97036 | 6658 | 0 | 17.4392 | -99.5451 | 2022-03-02 04:21:07 | Guerrero, Mexico | |||
404027 | 404027 | 2021-12-07 | Brazil | Rondonia | 279901 | 6658 | 0 | -11.5057 | -63.5806 | 2021-12-08 04:22:46 | Rondonia, Brazil | |||
1030109 | 1030109 | 2021-12-06 | Brazil | Rondonia | 279421 | 6658 | 0 | -11.5057 | -63.5806 | 2021-12-07 04:22:34 | Rondonia, Brazil | |||
447470 | 447470 | 2021-11-17 | Mexico | San Luis Potosi | 104337 | 6658 | 0 | 22.1565 | -100.9855 | 2021-11-18 04:21:33 | San Luis Potosi, Mexico | |||
934956 | 934956 | 2021-10-16 | Peru | Ancash | 77443 | 6658 | 0 | -9.407125 | -77.67179499999997 | 2021-10-17 04:21:29 | Ancash, Peru | |||
2943511 | 2943511 | 2021-10-15 | Peru | Ancash | 77443 | 6658 | 0 | -9.407125 | -77.67179499999997 | 2021-10-16 04:21:15 | Ancash, Peru | |||
634142 | 634142 | 2021-10-13 | Russia | Krasnodar Krai | 76846 | 6658 | 0 | 45.768401399999995 | 39.0261044 | 2021-10-14 04:21:29 | Krasnodar Krai, Russia | |||
2947348 | 2947348 | 2021-07-16 | Italy | Puglia | 254045 | 6658 | 245746 | 1641 | 41.12559576 | 16.86736689 | 2021-07-17 04:22:22 | Puglia, Italy | ||
296004 | 296004 | 2021-07-15 | Italy | Puglia | 253999 | 6658 | 245690 | 1651 | 41.12559576 | 16.86736689 | 2021-07-16 04:21:22 | Puglia, Italy | ||
1636395 | 1636395 | 2021-04-29 | Mexico | Chihuahua | 52167 | 6658 | 0 | 45509 | 28.633000000000006 | -106.0691 | 2021-04-30 04:21:03 | Chihuahua, Mexico | ||
2247686 | 2247686 | 2021-04-07 | Spain | Castilla y Leon | 214908 | 6658 | 8716 | 199534 | 41.8357 | -4.3976 | 2021-04-08 04:21:13 | Castilla y Leon, Spain | ||
998726 | 998726 | 2021-03-01 | Spain | C. Valenciana | 379103 | 6658 | 9970 | 362475 | 39.484 | -0.7533 | 2021-03-02 05:23:30 | C. Valenciana, Spain | ||
762284 | 762284 | 2020-10-18 | India | Uttar Pradesh | 455146 | 6658 | 415592 | 32896 | 26.925425 | 80.560982 | 2020-10-19 04:24:16 | Uttar Pradesh, India |
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]);