johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
36 rows where deaths = 2952 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 13
- Peru 9
- US 9
- Russia 4
- Colombia 3
- Brazil 2
- Mexico 2
- Bosnia and Herzegovina 1
- El Salvador 1
- Germany 1
- India 1
- Japan 1
- Kyrgyzstan 1
- South Africa 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3026287 | 3026287 | 2022-11-17 | Japan | Hyogo | 1076293 | 2952 | 0 | 35.039913 | 134.828057 | 2022-11-18 04:21:15 | Hyogo, Japan | |||
2686369 | 2686369 | 2022-10-03 | US | Connecticut | New Haven | 9009 | 236567 | 2952 | 0 | 41.4080325 | -72.93620426 | 2022-10-04 04:22:55 | New Haven, Connecticut, US | |
2260436 | 2260436 | 2022-10-02 | US | Connecticut | New Haven | 9009 | 236497 | 2952 | 0 | 41.4080325 | -72.93620426 | 2022-10-03 04:23:11 | New Haven, Connecticut, US | |
2995962 | 2995962 | 2022-10-01 | US | Connecticut | New Haven | 9009 | 236399 | 2952 | 0 | 41.4080325 | -72.93620426 | 2022-10-02 04:21:23 | New Haven, Connecticut, US | |
854288 | 854288 | 2022-09-30 | US | Connecticut | New Haven | 9009 | 236166 | 2952 | 0 | 41.4080325 | -72.93620426 | 2022-10-01 04:23:01 | New Haven, Connecticut, US | |
2376214 | 2376214 | 2022-09-29 | US | Connecticut | New Haven | 9009 | 235992 | 2952 | 0 | 41.4080325 | -72.93620426 | 2022-09-30 04:23:09 | New Haven, Connecticut, US | |
1560765 | 1560765 | 2022-09-28 | US | Connecticut | New Haven | 9009 | 235788 | 2952 | 0 | 41.4080325 | -72.93620426 | 2022-09-29 04:22:34 | New Haven, Connecticut, US | |
3995308 | 3995308 | 2022-09-27 | US | Connecticut | New Haven | 9009 | 235498 | 2952 | 0 | 41.4080325 | -72.93620426 | 2022-09-28 04:23:01 | New Haven, Connecticut, US | |
3766044 | 3766044 | 2022-09-11 | Peru | Huanuco | 57873 | 2952 | 0 | -9.421676 | -76.040642 | 2022-09-12 04:20:58 | Huanuco, Peru | |||
3824619 | 3824619 | 2022-09-10 | Peru | Huanuco | 57873 | 2952 | 0 | -9.421676 | -76.040642 | 2022-09-11 04:20:50 | Huanuco, Peru | |||
963076 | 963076 | 2022-09-09 | Peru | Huanuco | 57873 | 2952 | 0 | -9.421676 | -76.040642 | 2022-09-10 04:21:10 | Huanuco, Peru | |||
253478 | 253478 | 2022-09-08 | Peru | Huanuco | 57873 | 2952 | 0 | -9.421676 | -76.040642 | 2022-09-09 04:21:11 | Huanuco, Peru | |||
3745276 | 3745276 | 2022-09-07 | Peru | Huanuco | 57873 | 2952 | 0 | -9.421676 | -76.040642 | 2022-09-08 04:21:02 | Huanuco, Peru | |||
114916 | 114916 | 2022-09-06 | Peru | Huanuco | 57873 | 2952 | 0 | -9.421676 | -76.040642 | 2022-09-07 04:20:59 | Huanuco, Peru | |||
158203 | 158203 | 2022-03-29 | Russia | Astrakhan Oblast | 114497 | 2952 | 0 | 47.1878186 | 47.608851 | 2022-03-30 04:20:45 | Astrakhan Oblast, Russia | |||
574873 | 574873 | 2022-02-25 | Kyrgyzstan | 200427 | 2952 | 0 | 41.20438 | 74.766098 | 2022-02-26 04:21:12 | Kyrgyzstan | ||||
1030633 | 1030633 | 2021-12-06 | Russia | Tyumen Oblast | 82739 | 2952 | 0 | 58.8206488 | 70.36588370000001 | 2021-12-07 04:22:34 | Tyumen Oblast, Russia | |||
3401640 | 3401640 | 2021-11-30 | Russia | Dagestan Republic | 61323 | 2952 | 0 | 43.05749160000001 | 47.1332224 | 2021-12-01 04:22:29 | Dagestan Republic, Russia | |||
3121611 | 3121611 | 2021-11-05 | Mexico | Tlaxcala | 29255 | 2952 | 0 | 19.3139 | -98.2404 | 2021-11-06 04:21:51 | Tlaxcala, Mexico | |||
249167 | 249167 | 2021-09-04 | El Salvador | 96067 | 2952 | 0 | 13.7942 | -88.8965 | 2021-09-05 04:21:33 | El Salvador | ||||
335020 | 335020 | 2021-08-04 | US | Texas | Hidalgo | 48215 | 106222 | 2952 | 0 | 26.39418217 | -98.18299696 | 2021-08-05 04:21:51 | Hidalgo, Texas, US | |
3125358 | 3125358 | 2021-06-28 | Colombia | Magdalena | 79932 | 2952 | 74964 | 2016 | 10.4113 | -74.4057 | 2021-06-29 04:21:28 | Magdalena, Colombia | ||
2585949 | 2585949 | 2021-06-05 | India | Odisha | 806094 | 2952 | 732018 | 71124 | 20.505428 | 84.418059 | 2021-06-06 04:24:03 | Odisha, India | ||
2255587 | 2255587 | 2021-05-19 | Colombia | Norte de Santander | 58096 | 2952 | 53745 | 1399 | 7.9463 | -72.8988 | 2021-05-20 04:21:05 | Norte de Santander, Colombia | ||
1875118 | 1875118 | 2021-05-15 | US | New Jersey | Essex | 34013 | 93561 | 2952 | 0 | 40.78681335 | -74.24657979 | 2021-05-16 04:20:49 | Essex, New Jersey, US | |
2502199 | 2502199 | 2021-05-07 | Peru | Puno | 29300 | 2952 | 0 | 26348 | -14.995826999999998 | -69.922726 | 2021-05-08 04:21:04 | Puno, Peru | ||
2020643 | 2020643 | 2021-04-20 | Germany | Sachsen-Anhalt | 83891 | 2952 | 74420 | 7213 | 51.9503 | 11.6923 | 2021-04-21 04:21:14 | Sachsen-Anhalt, Germany | ||
36657 | 36657 | 2021-04-12 | Russia | Nizhny Novgorod Oblast | 110476 | 2952 | 105268 | 2256 | 55.47180329999999 | 44.0911594 | 2021-04-13 04:20:37 | Nizhny Novgorod Oblast, Russia | ||
1579998 | 1579998 | 2021-03-13 | Colombia | Cundinamarca | 108018 | 2952 | 103345 | 1721 | 5.026 | -74.03 | 2021-03-14 05:25:37 | Cundinamarca, Colombia | ||
2283531 | 2283531 | 2021-02-14 | Mexico | Yucatan | 31510 | 2952 | 0 | 28558 | 20.7099 | -89.0943 | 2021-02-15 05:24:49 | Yucatan, Mexico | ||
3900110 | 3900110 | 2021-01-09 | Peru | Ancash | 31484 | 2952 | 0 | 28532 | -9.407125 | -77.67179499999997 | 2021-01-10 05:22:12 | Ancash, Peru | ||
1006022 | 1006022 | 2020-12-06 | Bosnia and Herzegovina | 94507 | 2952 | 58625 | 32930 | 43.9159 | 17.6791 | 2020-12-07 05:26:14 | Bosnia and Herzegovina | |||
786131 | 786131 | 2020-10-15 | Brazil | Santa Catarina | 231412 | 2952 | 213495 | 14965 | -27.2423 | -50.2189 | 2020-10-16 04:24:01 | Santa Catarina, Brazil | ||
887163 | 887163 | 2020-07-07 | Peru | Callao | 18510 | 2952 | 0 | 15558 | -11.954609 | -77.136042 | 2020-07-08 05:33:48 | Callao, Peru | ||
887103 | 887103 | 2020-07-07 | Brazil | Amazonas | 79167 | 2952 | 66256 | 9959 | -3.4168 | -65.8561 | 2020-07-08 05:33:48 | Amazonas, Brazil | ||
2234992 | 2234992 | 2020-07-03 | South Africa | 177124 | 2952 | 86298 | 87874 | -30.5595 | 22.9375 | 2020-07-04 04:33:51 | South Africa |
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]);