johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
32 rows where deaths = 3838 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1767273 | 1767273 | 2022-07-03 | India | Goa | 249095 | 3838 | 0 | 15.359682 | 74.057396 | 2022-07-04 04:20:54 | Goa, India | |||
3365259 | 3365259 | 2022-07-02 | India | Goa | 249002 | 3838 | 0 | 15.359682 | 74.057396 | 2022-07-03 04:20:59 | Goa, India | |||
593588 | 593588 | 2022-07-01 | India | Goa | 248849 | 3838 | 0 | 15.359682 | 74.057396 | 2022-07-02 04:21:16 | Goa, India | |||
3939989 | 3939989 | 2022-06-30 | India | Goa | 248724 | 3838 | 0 | 15.359682 | 74.057396 | 2022-07-01 04:21:10 | Goa, India | |||
2489947 | 2489947 | 2022-06-29 | India | Goa | 248540 | 3838 | 0 | 15.359682 | 74.057396 | 2022-06-30 04:21:01 | Goa, India | |||
2239329 | 2239329 | 2022-06-28 | India | Goa | 248339 | 3838 | 0 | 15.359682 | 74.057396 | 2022-06-29 04:20:59 | Goa, India | |||
1572478 | 1572478 | 2022-05-03 | Trinidad and Tobago | 148977 | 3838 | 0 | 10.6918 | -61.2225 | 2022-05-04 04:20:59 | Trinidad and Tobago | ||||
1656519 | 1656519 | 2022-03-19 | Mexico | Zacatecas | 67276 | 3838 | 0 | 22.7709 | -102.5832 | 2022-03-20 04:20:45 | Zacatecas, Mexico | |||
2143292 | 2143292 | 2022-03-09 | US | Texas | Hidalgo | 48215 | 196096 | 3838 | 0 | 26.39418217 | -98.18299696 | 2022-03-10 04:20:48 | Hidalgo, Texas, US | |
904111 | 904111 | 2021-11-24 | India | Himachal Pradesh | 226705 | 3838 | 0 | 31.927213000000002 | 77.233081 | 2021-11-25 04:22:33 | Himachal Pradesh, India | |||
3832774 | 3832774 | 2021-10-05 | Spain | Aragon | 161270 | 3838 | 0 | 41.5976 | -0.9057 | 2021-10-06 04:21:33 | Aragon, Spain | |||
3757383 | 3757383 | 2021-09-21 | Germany | Brandenburg | 114759 | 3838 | 0 | 52.4125 | 12.5316 | 2021-09-22 04:21:45 | Brandenburg, Germany | |||
2279256 | 2279256 | 2021-09-08 | Mexico | Quintana Roo | 55789 | 3838 | 0 | 19.1817 | -88.4791 | 2021-09-09 04:21:27 | Quintana Roo, Mexico | |||
3196692 | 3196692 | 2021-09-06 | US | Pennsylvania | Philadelphia | 42101 | 169032 | 3838 | 0 | 40.00338507 | -75.1379271 | 2021-09-07 04:21:35 | Philadelphia, Pennsylvania, US | |
3283560 | 3283560 | 2021-09-05 | US | Pennsylvania | Philadelphia | 42101 | 168798 | 3838 | 0 | 40.00338507 | -75.1379271 | 2021-09-06 04:21:22 | Philadelphia, Pennsylvania, US | |
251974 | 251974 | 2021-09-04 | US | Pennsylvania | Philadelphia | 42101 | 168594 | 3838 | 0 | 40.00338507 | -75.1379271 | 2021-09-05 04:21:33 | Philadelphia, Pennsylvania, US | |
3977255 | 3977255 | 2021-09-03 | US | Pennsylvania | Philadelphia | 42101 | 168272 | 3838 | 0 | 40.00338507 | -75.1379271 | 2021-09-04 04:21:28 | Philadelphia, Pennsylvania, US | |
3105718 | 3105718 | 2021-08-24 | Russia | Voronezh Oblast | 115311 | 3838 | 0 | 50.9800393 | 40.15065070000001 | 2021-08-25 04:21:41 | Voronezh Oblast, Russia | |||
1483523 | 1483523 | 2021-08-13 | India | Telangana | 651715 | 3838 | 0 | 18.1124 | 79.0193 | 2021-08-14 04:21:25 | Telangana, India | |||
3137602 | 3137602 | 2021-07-23 | Kenya | 195898 | 3838 | 184885 | 7175 | -0.0236 | 37.9062 | 2021-07-24 00:21:36 | Kenya | |||
3659352 | 3659352 | 2021-07-11 | Burma | 192213 | 3838 | 146358 | 42017 | 21.9162 | 95.956 | 2021-07-12 04:21:34 | Burma | |||
1293063 | 1293063 | 2021-03-29 | US | Texas | Dallas | 48113 | 267437 | 3838 | 0 | 32.76670599 | -96.7779605 | 2021-03-30 04:26:23 | Dallas, Texas, US | |
280175 | 280175 | 2021-02-24 | Italy | Puglia | 142616 | 3838 | 106688 | 32090 | 41.12559576 | 16.86736689 | 2021-02-25 05:24:57 | Puglia, Italy | ||
1338230 | 1338230 | 2021-02-15 | India | Madhya Pradesh | 257849 | 3838 | 252164 | 1847 | 23.541513 | 78.289633 | 2021-02-16 05:24:38 | Madhya Pradesh, India | ||
2637655 | 2637655 | 2021-02-11 | Honduras | 158355 | 3838 | 62991 | 91526 | 15.2 | -86.2419 | 2021-02-12 05:23:29 | Honduras | |||
1676306 | 1676306 | 2021-02-01 | Colombia | Atlantico | 115485 | 3838 | 108577 | 3070 | 10.6966 | -74.8741 | 2021-02-02 05:22:49 | Atlantico, Colombia | ||
2406559 | 2406559 | 2020-12-23 | Bosnia and Herzegovina | 107570 | 3838 | 73149 | 30583 | 43.9159 | 17.6791 | 2020-12-24 05:23:04 | Bosnia and Herzegovina | |||
2080007 | 2080007 | 2020-10-31 | Mexico | Baja California | 23114 | 3838 | 18057 | 1219 | 30.8406 | -115.2838 | 2020-11-01 04:36:19 | Baja California, Mexico | ||
2689422 | 2689422 | 2020-10-08 | Brazil | Maranhao | 177584 | 3838 | 167126 | 6620 | -4.9609 | -45.2744 | 2020-10-09 04:23:59 | Maranhao, Brazil | ||
1928586 | 1928586 | 2020-07-30 | India | Tamil Nadu | 239978 | 3838 | 178178 | 57962 | 11.006091 | 78.400624 | 2020-07-31 04:35:18 | Tamil Nadu, India | ||
2748186 | 2748186 | 2020-07-15 | Peru | Piura | 19096 | 3838 | 0 | 15258 | -5.133361 | -80.335861 | 2020-07-16 04:44:59 | Piura, Peru | ||
2712327 | 2712327 | 2020-05-28 | Italy | Piemonte | 30445 | 3838 | 20535 | 6072 | 45.0732745 | 7.680687483 | 2020-05-29 02:32:50 | Piemonte, Italy |
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]);