johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
37 rows where deaths = 3252 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3222656 | 3222656 | 2022-12-25 | Russia | Komi Republic | 192346 | 3252 | 0 | 63.9881421 | 54.3326073 | 2022-12-26 04:21:06 | Komi Republic, Russia | |||
3774573 | 3774573 | 2022-08-30 | US | Connecticut | Hartford | 9003 | 211085 | 3252 | 0 | 41.80283011 | -72.73103891 | 2022-08-31 04:20:57 | Hartford, Connecticut, US | |
1680486 | 1680486 | 2022-08-29 | Jamaica | 149714 | 3252 | 0 | 18.1096 | -77.2975 | 2022-08-30 04:21:03 | Jamaica | ||||
2748763 | 2748763 | 2022-04-04 | Finland | 901336 | 3252 | 0 | 61.92411 | 25.748151 | 2022-04-05 04:20:48 | Finland | ||||
3733227 | 3733227 | 2022-04-03 | US | Tennessee | Shelby | 47157 | 235322 | 3252 | 0 | 35.1864775 | -89.89692423 | 2022-04-04 04:20:51 | Shelby, Tennessee, US | |
2525494 | 2525494 | 2022-03-02 | Netherlands | Noord-Holland | 1089542 | 3252 | 0 | 52.60090600000001 | 4.9186879999999995 | 2022-03-03 04:21:01 | Noord-Holland, Netherlands | |||
575056 | 575056 | 2022-02-25 | Russia | Lipetsk Oblast | 124531 | 3252 | 0 | 52.693517799999995 | 39.112266399999996 | 2022-02-26 04:21:12 | Lipetsk Oblast, Russia | |||
2641591 | 2641591 | 2022-02-14 | Colombia | Narino | 103876 | 3252 | 0 | 1.2892 | -77.3579 | 2022-02-15 04:21:09 | Narino, Colombia | |||
3519404 | 3519404 | 2022-01-02 | Italy | Marche | 147782 | 3252 | 0 | 43.61675973 | 13.5188753 | 2022-01-03 02:22:25 | Marche, Italy | |||
2171213 | 2171213 | 2022-01-01 | Ukraine | Zhytomyr Oblast | 140617 | 3252 | 0 | 50.2547 | 28.6587 | 2022-01-02 04:20:52 | Zhytomyr Oblast, Ukraine | |||
2115339 | 2115339 | 2021-12-26 | Ukraine | Mykolaiv Oblast | 114924 | 3252 | 0 | 46.975 | 31.9946 | 2021-12-27 04:21:58 | Mykolaiv Oblast, Ukraine | |||
2904024 | 2904024 | 2021-12-19 | Sudan | 45112 | 3252 | 0 | 12.8628 | 30.2176 | 2021-12-20 04:21:43 | Sudan | ||||
1259097 | 1259097 | 2021-12-18 | Sudan | 45112 | 3252 | 0 | 12.8628 | 30.2176 | 2021-12-19 04:21:11 | Sudan | ||||
2399125 | 2399125 | 2021-12-17 | Sudan | 45112 | 3252 | 0 | 12.8628 | 30.2176 | 2021-12-18 02:22:20 | Sudan | ||||
1716663 | 1716663 | 2021-12-16 | Sudan | 45112 | 3252 | 0 | 12.8628 | 30.2176 | 2021-12-17 04:22:14 | Sudan | ||||
3496497 | 3496497 | 2021-12-15 | Sudan | 45112 | 3252 | 0 | 12.8628 | 30.2176 | 2021-12-16 04:22:11 | Sudan | ||||
2088282 | 2088282 | 2021-12-14 | Sudan | 45112 | 3252 | 0 | 12.8628 | 30.2176 | 2021-12-15 03:22:16 | Sudan | ||||
405897 | 405897 | 2021-12-07 | US | Massachusetts | Middlesex | 25017 | 177499 | 3252 | 0 | 42.48607732 | -71.39049229 | 2021-12-08 04:22:46 | Middlesex, Massachusetts, US | |
3953 | 3953 | 2021-12-02 | Uganda | 127618 | 3252 | 0 | 1.373333 | 32.290275 | 2021-12-03 04:23:05 | Uganda | ||||
1148552 | 1148552 | 2021-12-01 | Uganda | 127589 | 3252 | 0 | 1.373333 | 32.290275 | 2021-12-02 04:22:37 | Uganda | ||||
3405064 | 3405064 | 2021-11-30 | Uganda | 127550 | 3252 | 0 | 1.373333 | 32.290275 | 2021-12-01 04:22:29 | Uganda | ||||
153607 | 153607 | 2021-11-29 | Uganda | 127523 | 3252 | 0 | 1.373333 | 32.290275 | 2021-11-30 04:22:53 | Uganda | ||||
1235253 | 1235253 | 2021-11-28 | Uganda | 127451 | 3252 | 0 | 1.373333 | 32.290275 | 2021-11-29 04:22:30 | Uganda | ||||
1361960 | 1361960 | 2021-11-27 | Uganda | 127423 | 3252 | 0 | 1.373333 | 32.290275 | 2021-11-28 04:22:43 | Uganda | ||||
1325858 | 1325858 | 2021-11-14 | Ukraine | Crimea Republic* | 107784 | 3252 | 0 | 45.2835 | 34.2008 | 2021-11-15 04:21:36 | Crimea Republic*, Ukraine | |||
31201 | 31201 | 2021-11-11 | US | Puerto Rico | Unassigned | 72999 | 4198 | 3252 | 0 | 18.459681 | -67.336525 | 2021-11-12 04:22:01 | Unassigned, Puerto Rico, US | |
3832594 | 3832594 | 2021-10-05 | Mexico | Zacatecas | 40672 | 3252 | 0 | 22.7709 | -102.5832 | 2021-10-06 04:21:33 | Zacatecas, Mexico | |||
987087 | 987087 | 2021-10-04 | Mexico | Zacatecas | 40672 | 3252 | 0 | 22.7709 | -102.5832 | 2021-10-05 04:21:27 | Zacatecas, Mexico | |||
3013581 | 3013581 | 2021-09-22 | US | New York | Nassau | 36059 | 206711 | 3252 | 0 | 40.74066522 | -73.58941873 | 2021-09-23 04:21:43 | Nassau, New York, US | |
2518028 | 2518028 | 2021-08-18 | Colombia | Magdalena | 90765 | 3252 | 0 | 10.4113 | -74.4057 | 2021-08-19 04:21:15 | Magdalena, Colombia | |||
1913132 | 1913132 | 2021-05-20 | Germany | Sachsen-Anhalt | 97127 | 3252 | 88990 | 5141 | 51.9503 | 11.6923 | 2021-05-21 04:20:43 | Sachsen-Anhalt, Germany | ||
2008321 | 2008321 | 2021-05-12 | Uruguay | 228102 | 3252 | 198922 | 25928 | -32.5228 | -55.7658 | 2021-05-13 04:20:51 | Uruguay | |||
1841834 | 1841834 | 2021-04-14 | Ethiopia | 234405 | 3252 | 174591 | 56562 | 9.145 | 40.4897 | 2021-04-15 04:20:54 | Ethiopia | |||
2983204 | 2983204 | 2021-04-10 | India | Haryana | 313441 | 3252 | 290736 | 19453 | 29.20004 | 76.332824 | 2021-04-11 04:20:56 | Haryana, India | ||
3369434 | 3369434 | 2021-03-21 | Mexico | Yucatan | 34431 | 3252 | 0 | 31179 | 20.7099 | -89.0943 | 2021-03-22 05:25:43 | Yucatan, Mexico | ||
2740192 | 2740192 | 2020-08-03 | Peru | La Libertad | 15903 | 3252 | 0 | 12651 | -7.92139 | -78.370238 | 2020-08-04 04:41:59 | La Libertad, Peru | ||
1928157 | 1928157 | 2020-07-30 | Brazil | Amazonas | 100140 | 3252 | 84218 | 12670 | -3.4168 | -65.8561 | 2020-07-31 04:35:18 | Amazonas, Brazil |
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]);