johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
38 rows where deaths = 2855 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 20
- US 11
- Mexico 6
- Japan 3
- Russia 2
- Afghanistan 1
- Albania 1
- Brazil 1
- Chile 1
- El Salvador 1
- Germany 1
- India 1
- Italy 1
- Jamaica 1
- Netherlands 1
- Nigeria 1
- North Macedonia 1
- Peru 1
- Syria 1
- Ukraine 1
- United Kingdom 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
712736 | 712736 | 2022-11-01 | US | New York | Westchester | 36119 | 311384 | 2855 | 0 | 41.16278376 | -73.75741653 | 2022-11-02 04:22:09 | Westchester, New York, US | |
2268177 | 2268177 | 2022-10-22 | Russia | Yaroslavl Oblast | 183789 | 2855 | 0 | 57.7781976 | 39.0021095 | 2022-10-23 04:22:46 | Yaroslavl Oblast, Russia | |||
853612 | 853612 | 2022-09-30 | Japan | Hyogo | 1008548 | 2855 | 0 | 35.039913 | 134.828057 | 2022-10-01 04:23:01 | Hyogo, Japan | |||
2768948 | 2768948 | 2022-09-26 | Japan | Aichi | 1354991 | 2855 | 0 | 35.035551 | 137.211621 | 2022-09-27 04:23:01 | Aichi, Japan | |||
3543387 | 3543387 | 2022-08-08 | Germany | Hamburg | 694630 | 2855 | 0 | 53.5511 | 9.9937 | 2022-08-09 04:20:34 | Hamburg, Germany | |||
1652170 | 1652170 | 2022-04-09 | Chile | Maule | 236665 | 2855 | 0 | -35.5183 | -71.6885 | 2022-04-10 04:20:52 | Maule, Chile | |||
1907372 | 1907372 | 2022-03-22 | US | New Jersey | Middlesex | 34023 | 191243 | 2855 | 0 | 40.43629879 | -74.41426991 | 2022-03-23 04:20:48 | Middlesex, New Jersey, US | |
2319316 | 2319316 | 2022-03-16 | Jamaica | 128426 | 2855 | 0 | 18.1096 | -77.2975 | 2022-03-17 04:20:56 | Jamaica | ||||
2264141 | 2264141 | 2022-03-14 | Russia | Smolensk Oblast | 124578 | 2855 | 0 | 55.03434960000001 | 33.0192065 | 2022-03-15 04:20:47 | Smolensk Oblast, Russia | |||
3074008 | 3074008 | 2022-02-09 | Italy | Abruzzo | 237059 | 2855 | 0 | 42.35122196 | 13.39843823 | 2022-02-10 04:21:14 | Abruzzo, Italy | |||
1474084 | 1474084 | 2022-01-17 | US | Missouri | St. Louis | 29189 | 192949 | 2855 | 0 | 38.63770039999999 | -90.4458375 | 2022-01-18 04:21:04 | St. Louis, Missouri, US | |
556758 | 556758 | 2022-01-16 | US | Missouri | St. Louis | 29189 | 192949 | 2855 | 0 | 38.63770039999999 | -90.4458375 | 2022-01-17 04:21:08 | St. Louis, Missouri, US | |
3842479 | 3842479 | 2022-01-15 | US | Missouri | St. Louis | 29189 | 192949 | 2855 | 0 | 38.63770039999999 | -90.4458375 | 2022-01-16 04:21:12 | St. Louis, Missouri, US | |
3828803 | 3828803 | 2021-12-21 | Syria | 49861 | 2855 | 0 | 34.802075 | 38.99681500000001 | 2021-12-22 04:21:54 | Syria | ||||
3403100 | 3403100 | 2021-11-30 | US | Michigan | Macomb | 26099 | 140170 | 2855 | 0 | 42.69158356 | -82.92752801 | 2021-12-01 04:22:29 | Macomb, Michigan, US | |
151643 | 151643 | 2021-11-29 | US | Michigan | Macomb | 26099 | 140170 | 2855 | 0 | 42.69158356 | -82.92752801 | 2021-11-30 04:22:53 | Macomb, Michigan, US | |
654135 | 654135 | 2021-10-22 | Nigeria | 210136 | 2855 | 0 | 9.082 | 8.6753 | 2021-10-23 04:21:32 | Nigeria | ||||
2123415 | 2123415 | 2021-10-21 | Albania | 180029 | 2855 | 0 | 41.1533 | 20.1683 | 2021-10-22 04:21:14 | Albania | ||||
1728132 | 1728132 | 2021-09-25 | Ukraine | Kiev Oblast | 132930 | 2855 | 0 | 50.053000000000004 | 30.7667 | 2021-09-26 04:21:29 | Kiev Oblast, Ukraine | |||
1262821 | 1262821 | 2021-09-09 | Japan | Osaka | 186772 | 2855 | 0 | 34.620965000000005 | 135.507481 | 2021-09-10 04:21:20 | Osaka, Japan | |||
3105339 | 3105339 | 2021-08-24 | El Salvador | 92686 | 2855 | 0 | 13.7942 | -88.8965 | 2021-08-25 04:21:41 | El Salvador | ||||
522954 | 522954 | 2021-06-09 | Mexico | Quintana Roo | 28691 | 2855 | 0 | 25836 | 19.1817 | -88.4791 | 2021-06-10 04:23:17 | Quintana Roo, Mexico | ||
1309856 | 1309856 | 2021-05-26 | Afghanistan | 67743 | 2855 | 56711 | 8177 | 33.93911 | 67.709953 | 2021-05-27 04:20:59 | Afghanistan | |||
83815 | 83815 | 2021-05-25 | US | Florida | Palm Beach | 12099 | 147870 | 2855 | 0 | 26.64676272 | -80.46536002 | 2021-05-26 04:20:35 | Palm Beach, Florida, US | |
3576753 | 3576753 | 2021-05-17 | US | New Jersey | Bergen | 34003 | 103797 | 2855 | 0 | 40.96010917 | -74.07164325 | 2021-05-18 04:20:33 | Bergen, New Jersey, US | |
2941483 | 2941483 | 2021-05-16 | US | New Jersey | Bergen | 34003 | 103752 | 2855 | 0 | 40.96010917 | -74.07164325 | 2021-05-17 04:20:34 | Bergen, New Jersey, US | |
1302209 | 1302209 | 2021-04-01 | Peru | Cusco | 43654 | 2855 | 0 | 40799 | -13.191068 | -72.153609 | 2021-04-02 04:20:36 | Cusco, Peru | ||
2211306 | 2211306 | 2021-03-04 | United Kingdom | Northern Ireland | 113169 | 2855 | 0 | 111103 | 54.7877 | -6.4923 | 2021-03-05 05:26:29 | Northern Ireland, United Kingdom | ||
1091668 | 1091668 | 2021-03-03 | US | Massachusetts | Middlesex | 25017 | 112361 | 2855 | 0 | 108901 | 42.48607732 | -71.39049229 | 2021-03-04 05:24:24 | Middlesex, Massachusetts, US |
2367622 | 2367622 | 2021-02-28 | Netherlands | Noord-Brabant | 170175 | 2855 | 0 | 168723 | 51.561174 | 5.184942 | 2021-03-01 05:23:01 | Noord-Brabant, Netherlands | ||
2637476 | 2637476 | 2021-02-11 | Brazil | Sergipe | 143400 | 2855 | 130782 | 9763 | -10.5741 | -37.3857 | 2021-02-12 05:23:29 | Sergipe, Brazil | ||
1684596 | 1684596 | 2021-02-02 | Mexico | Queretaro | 48054 | 2855 | 0 | 45199 | 20.5888 | -100.3899 | 2021-02-03 05:22:52 | Queretaro, Mexico | ||
1459896 | 1459896 | 2021-01-31 | North Macedonia | 92693 | 2855 | 81681 | 8157 | 41.6086 | 21.7453 | 2021-02-01 05:22:53 | North Macedonia | |||
3101526 | 3101526 | 2021-01-16 | Mexico | Guerrero | 27956 | 2855 | 0 | 25101 | 17.4392 | -99.5451 | 2021-01-17 05:22:17 | Guerrero, Mexico | ||
821671 | 821671 | 2020-11-19 | Mexico | Tamaulipas | 33803 | 2855 | 0 | 30948 | 24.2669 | -98.8363 | 2020-11-20 05:26:28 | Tamaulipas, Mexico | ||
1053779 | 1053779 | 2020-10-23 | India | Madhya Pradesh | 165294 | 2855 | 150678 | 11761 | 23.541513 | 78.289633 | 2020-10-24 04:24:46 | Madhya Pradesh, India | ||
2729089 | 2729089 | 2020-09-15 | Mexico | Jalisco | 23565 | 2855 | 18900 | 1810 | 20.6595 | -103.3494 | 2020-09-16 04:22:53 | Jalisco, Mexico | ||
2661873 | 2661873 | 2020-09-04 | Mexico | Sinaloa | 16589 | 2855 | 13009 | 725 | 25.1721 | -107.4795 | 2020-09-05 04:28:19 | Sinaloa, Mexico |
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]);