johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
80 rows where deaths = 2146 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 18
- US 38
- Brazil 9
- India 6
- Russia 5
- Italy 4
- Ukraine 3
- Colombia 2
- Netherlands 2
- United Arab Emirates 2
- El Salvador 1
- Honduras 1
- Japan 1
- Malaysia 1
- Mexico 1
- Mozambique 1
- Peru 1
- Syria 1
- Yemen 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
542759 | 542759 | 2022-12-15 | Japan | Fukuoka | 1242428 | 2146 | 0 | 33.526032 | 130.666949 | 2022-12-16 04:21:01 | Fukuoka, Japan | |||
1986837 | 1986837 | 2022-12-07 | US | New Mexico | Bernalillo | 35001 | 191668 | 2146 | 0 | 35.05163625 | -106.6703554 | 2022-12-08 04:21:07 | Bernalillo, New Mexico, US | |
2433541 | 2433541 | 2022-11-09 | US | Oklahoma | Unassigned | 90040 | 110 | 2146 | 0 | 36.83532655 | 0.0 | 2022-11-10 04:21:16 | Unassigned, Oklahoma, US | |
482197 | 482197 | 2022-11-08 | US | Oklahoma | Unassigned | 90040 | 110 | 2146 | 0 | 36.83532655 | 0.0 | 2022-11-09 04:21:22 | Unassigned, Oklahoma, US | |
2441347 | 2441347 | 2022-11-07 | US | Oklahoma | Unassigned | 90040 | 110 | 2146 | 0 | 36.83532655 | 0.0 | 2022-11-08 04:21:21 | Unassigned, Oklahoma, US | |
1052445 | 1052445 | 2022-11-06 | US | Oklahoma | Unassigned | 90040 | 110 | 2146 | 0 | 36.83532655 | 0.0 | 2022-11-07 04:21:26 | Unassigned, Oklahoma, US | |
620469 | 620469 | 2022-11-05 | US | Oklahoma | Unassigned | 90040 | 110 | 2146 | 0 | 36.83532655 | 0.0 | 2022-11-06 04:21:24 | Unassigned, Oklahoma, US | |
1024973 | 1024973 | 2022-11-04 | US | Oklahoma | Unassigned | 90040 | 110 | 2146 | 0 | 36.83532655 | 0.0 | 2022-11-05 04:21:52 | Unassigned, Oklahoma, US | |
433964 | 433964 | 2022-11-03 | US | Oklahoma | Unassigned | 90040 | 110 | 2146 | 0 | 36.83532655 | 0.0 | 2022-11-04 04:22:11 | Unassigned, Oklahoma, US | |
3753454 | 3753454 | 2022-10-13 | Italy | Umbria | 389412 | 2146 | 0 | 43.10675841 | 12.38824698 | 2022-10-14 04:22:28 | Umbria, Italy | |||
3775493 | 3775493 | 2022-08-30 | US | Maryland | Montgomery | 24031 | 217936 | 2146 | 0 | 39.13676329 | -77.20358245 | 2022-08-31 04:20:57 | Montgomery, Maryland, US | |
2096055 | 2096055 | 2022-08-27 | India | Manipur | 139673 | 2146 | 0 | 24.738975 | 93.882541 | 2022-08-28 04:21:02 | Manipur, India | |||
1531870 | 1531870 | 2022-08-26 | India | Manipur | 139671 | 2146 | 0 | 24.738975 | 93.882541 | 2022-08-27 04:20:57 | Manipur, India | |||
2828757 | 2828757 | 2022-08-25 | India | Manipur | 139654 | 2146 | 0 | 24.738975 | 93.882541 | 2022-08-26 04:21:02 | Manipur, India | |||
2323290 | 2323290 | 2022-08-24 | India | Manipur | 139639 | 2146 | 0 | 24.738975 | 93.882541 | 2022-08-25 04:21:13 | Manipur, India | |||
3347322 | 3347322 | 2022-06-24 | US | Florida | Brevard | 12009 | 146634 | 2146 | 0 | 28.29409504 | -80.73091022 | 2022-06-25 04:20:57 | Brevard, Florida, US | |
1649063 | 1649063 | 2022-06-23 | US | Florida | Brevard | 12009 | 146634 | 2146 | 0 | 28.29409504 | -80.73091022 | 2022-06-24 04:20:58 | Brevard, Florida, US | |
2188298 | 2188298 | 2022-06-22 | US | Florida | Brevard | 12009 | 146634 | 2146 | 0 | 28.29409504 | -80.73091022 | 2022-06-23 04:20:55 | Brevard, Florida, US | |
166729 | 166729 | 2022-06-21 | US | Florida | Brevard | 12009 | 146634 | 2146 | 0 | 28.29409504 | -80.73091022 | 2022-06-22 04:20:54 | Brevard, Florida, US | |
1764012 | 1764012 | 2022-06-20 | US | Florida | Brevard | 12009 | 146634 | 2146 | 0 | 28.29409504 | -80.73091022 | 2022-06-21 04:20:56 | Brevard, Florida, US | |
3270198 | 3270198 | 2022-06-19 | US | Florida | Brevard | 12009 | 146634 | 2146 | 0 | 28.29409504 | -80.73091022 | 2022-06-20 04:21:01 | Brevard, Florida, US | |
3398110 | 3398110 | 2022-06-18 | US | Florida | Brevard | 12009 | 146634 | 2146 | 0 | 28.29409504 | -80.73091022 | 2022-06-19 04:20:51 | Brevard, Florida, US | |
2311987 | 2311987 | 2022-06-17 | US | Florida | Brevard | 12009 | 146634 | 2146 | 0 | 28.29409504 | -80.73091022 | 2022-06-18 04:21:10 | Brevard, Florida, US | |
559491 | 559491 | 2022-06-16 | US | Florida | Brevard | 12009 | 142624 | 2146 | 0 | 28.29409504 | -80.73091022 | 2022-06-17 04:20:56 | Brevard, Florida, US | |
3983293 | 3983293 | 2022-06-15 | US | Florida | Brevard | 12009 | 142624 | 2146 | 0 | 28.29409504 | -80.73091022 | 2022-06-16 04:20:55 | Brevard, Florida, US | |
947534 | 947534 | 2022-06-14 | US | Florida | Brevard | 12009 | 142624 | 2146 | 0 | 28.29409504 | -80.73091022 | 2022-06-15 04:20:54 | Brevard, Florida, US | |
1697932 | 1697932 | 2022-04-28 | US | Massachusetts | Bristol | 25005 | 152084 | 2146 | 0 | 41.79228404 | -71.10872211 | 2022-04-29 04:20:59 | Bristol, Massachusetts, US | |
3853415 | 3853415 | 2022-04-27 | US | Massachusetts | Bristol | 25005 | 151858 | 2146 | 0 | 41.79228404 | -71.10872211 | 2022-04-28 04:20:47 | Bristol, Massachusetts, US | |
1327834 | 1327834 | 2022-04-26 | US | Maryland | Prince George's | 24033 | 172361 | 2146 | 0 | 38.83070039 | -76.8496441 | 2022-04-27 04:20:52 | Prince George's, Maryland, US | |
2442491 | 2442491 | 2022-04-13 | Brazil | Roraima | 155342 | 2146 | 0 | -2.7376 | -62.0751 | 2022-04-13 23:21:06 | Roraima, Brazil | |||
1948248 | 1948248 | 2022-04-12 | Brazil | Roraima | 155325 | 2146 | 0 | -2.7376 | -62.0751 | 2022-04-13 04:21:03 | Roraima, Brazil | |||
3206001 | 3206001 | 2022-04-11 | Brazil | Roraima | 155295 | 2146 | 0 | -2.7376 | -62.0751 | 2022-04-12 04:20:49 | Roraima, Brazil | |||
1575887 | 1575887 | 2022-04-10 | Brazil | Roraima | 155256 | 2146 | 0 | -2.7376 | -62.0751 | 2022-04-11 04:21:02 | Roraima, Brazil | |||
1652129 | 1652129 | 2022-04-09 | Brazil | Roraima | 155256 | 2146 | 0 | -2.7376 | -62.0751 | 2022-04-10 04:20:52 | Roraima, Brazil | |||
2119394 | 2119394 | 2022-04-08 | Yemen | 11812 | 2146 | 0 | 15.552726999999999 | 48.516388 | 2022-04-09 04:20:42 | Yemen | ||||
2115451 | 2115451 | 2022-04-08 | Brazil | Roraima | 155256 | 2146 | 0 | -2.7376 | -62.0751 | 2022-04-09 04:20:42 | Roraima, Brazil | |||
3319975 | 3319975 | 2022-04-07 | Brazil | Roraima | 155237 | 2146 | 0 | -2.7376 | -62.0751 | 2022-04-08 04:20:48 | Roraima, Brazil | |||
2800511 | 2800511 | 2022-04-06 | Brazil | Roraima | 155218 | 2146 | 0 | -2.7376 | -62.0751 | 2022-04-07 04:20:53 | Roraima, Brazil | |||
3867280 | 3867280 | 2022-04-05 | Brazil | Roraima | 155212 | 2146 | 0 | -2.7376 | -62.0751 | 2022-04-06 04:20:49 | Roraima, Brazil | |||
3730360 | 3730360 | 2022-04-03 | Netherlands | Limburg | 521565 | 2146 | 0 | 51.209227 | 5.93387 | 2022-04-04 04:20:51 | Limburg, Netherlands | |||
499795 | 499795 | 2022-04-02 | Netherlands | Limburg | 520995 | 2146 | 0 | 51.209227 | 5.93387 | 2022-04-03 04:20:48 | Limburg, Netherlands | |||
1547936 | 1547936 | 2022-03-07 | Italy | Calabria | 227762 | 2146 | 0 | 38.90597598 | 16.59440194 | 2022-03-08 04:20:54 | Calabria, Italy | |||
1645169 | 1645169 | 2022-03-03 | US | Georgia | Fulton | 13121 | 212382 | 2146 | 0 | 33.79216944 | -84.46319413 | 2022-03-04 04:21:09 | Fulton, Georgia, US | |
3875662 | 3875662 | 2022-02-19 | Mexico | Colima | 53345 | 2146 | 0 | 19.1223 | -104.0072 | 2022-02-20 04:21:00 | Colima, Mexico | |||
1960672 | 1960672 | 2022-01-20 | Mozambique | 221432 | 2146 | 0 | -18.665695 | 35.529562 | 2022-01-21 04:21:09 | Mozambique | ||||
1148554 | 1148554 | 2021-12-01 | Ukraine | Chernihiv Oblast | 89106 | 2146 | 0 | 51.4982 | 31.2893 | 2021-12-02 04:22:37 | Chernihiv Oblast, Ukraine | |||
153635 | 153635 | 2021-11-29 | United Arab Emirates | 741976 | 2146 | 0 | 23.424076 | 53.847818000000004 | 2021-11-30 04:22:53 | United Arab Emirates | ||||
1235281 | 1235281 | 2021-11-28 | United Arab Emirates | 741918 | 2146 | 0 | 23.424076 | 53.847818000000004 | 2021-11-29 04:22:30 | United Arab Emirates | ||||
761952 | 761952 | 2021-11-26 | Ukraine | Cherkasy Oblast | 116398 | 2146 | 0 | 49.4444 | 32.0598 | 2021-11-27 04:22:45 | Cherkasy Oblast, Ukraine | |||
3750726 | 3750726 | 2021-11-22 | US | Massachusetts | Essex | 25009 | 119580 | 2146 | 0 | 42.6687626 | -70.94687179 | 2021-11-23 04:22:39 | Essex, Massachusetts, US | |
3749317 | 3749317 | 2021-11-22 | Russia | Astrakhan Oblast | 71948 | 2146 | 0 | 47.1878186 | 47.608851 | 2021-11-23 04:22:39 | Astrakhan Oblast, Russia | |||
3639776 | 3639776 | 2021-11-08 | Russia | Lipetsk Oblast | 65861 | 2146 | 0 | 52.693517799999995 | 39.112266399999996 | 2021-11-09 04:21:36 | Lipetsk Oblast, Russia | |||
3757805 | 3757805 | 2021-09-21 | Syria | 31148 | 2146 | 0 | 34.802075 | 38.99681500000001 | 2021-09-22 04:21:45 | Syria | ||||
1378119 | 1378119 | 2021-09-15 | Ukraine | Ivano-Frankivsk Oblast | 88974 | 2146 | 0 | 48.9226 | 24.7111 | 2021-09-16 04:22:19 | Ivano-Frankivsk Oblast, Ukraine | |||
3197687 | 3197687 | 2021-09-06 | Malaysia | W.P. Kuala Lumpur | 176988 | 2146 | 163667 | 11175 | 3.139 | 101.6869 | 2021-09-07 04:21:35 | W.P. Kuala Lumpur, Malaysia | ||
2175800 | 2175800 | 2021-08-22 | Russia | Saratov Oblast | 78646 | 2146 | 0 | 51.652055499999996 | 46.86319520000001 | 2021-08-23 04:21:27 | Saratov Oblast, Russia | |||
2518841 | 2518841 | 2021-08-18 | US | Connecticut | New Haven | 9009 | 96504 | 2146 | 0 | 41.408032500000004 | -72.93620426 | 2021-08-19 04:21:15 | New Haven, Connecticut, US | |
245933 | 245933 | 2021-08-17 | US | Connecticut | New Haven | 9009 | 96340 | 2146 | 0 | 41.408032500000004 | -72.93620426 | 2021-08-18 04:21:35 | New Haven, Connecticut, US | |
1604896 | 1604896 | 2021-08-16 | US | Connecticut | New Haven | 9009 | 96149 | 2146 | 0 | 41.408032500000004 | -72.93620426 | 2021-08-17 04:21:49 | New Haven, Connecticut, US | |
103990 | 103990 | 2021-08-15 | US | Connecticut | New Haven | 9009 | 95700 | 2146 | 0 | 41.408032500000004 | -72.93620426 | 2021-08-16 04:21:31 | New Haven, Connecticut, US | |
508348 | 508348 | 2021-08-14 | US | Connecticut | New Haven | 9009 | 95700 | 2146 | 0 | 41.408032500000004 | -72.93620426 | 2021-08-15 04:21:41 | New Haven, Connecticut, US | |
1484220 | 1484220 | 2021-08-13 | US | Connecticut | New Haven | 9009 | 95700 | 2146 | 0 | 41.408032500000004 | -72.93620426 | 2021-08-14 04:21:25 | New Haven, Connecticut, US | |
1708164 | 1708164 | 2021-06-02 | Colombia | Narino | 64771 | 2146 | 60056 | 2569 | 1.2892 | -77.3579 | 2021-06-03 04:23:32 | Narino, Colombia | ||
85265 | 85265 | 2021-05-25 | US | New Jersey | Ocean | 34029 | 75618 | 2146 | 0 | 39.8895449 | -74.28089251 | 2021-05-26 04:20:35 | Ocean, New Jersey, US | |
2501913 | 2501913 | 2021-05-07 | El Salvador | 70255 | 2146 | 65778 | 2331 | 13.7942 | -88.8965 | 2021-05-08 04:21:04 | El Salvador | |||
3702346 | 3702346 | 2021-04-27 | Russia | Perm Krai | 54142 | 2146 | 48915 | 3081 | 58.5951603 | 56.3159546 | 2021-04-28 04:20:32 | Perm Krai, Russia | ||
954836 | 954836 | 2021-04-25 | India | Uttarakhand | 151801 | 2146 | 113791 | 35864 | 30.156447 | 79.197608 | 2021-04-26 04:21:04 | Uttarakhand, India | ||
2574128 | 2574128 | 2021-04-13 | US | Ohio | Cuyahoga | 39035 | 105771 | 2146 | 0 | 41.424119 | -81.65918339 | 2021-04-14 04:20:41 | Cuyahoga, Ohio, US | |
2648530 | 2648530 | 2021-04-08 | US | Puerto Rico | Unassigned | 72999 | 3191 | 2146 | 0 | 18.459681 | -67.336525 | 2021-04-09 04:21:13 | Unassigned, Puerto Rico, US | |
1219429 | 1219429 | 2021-03-27 | Colombia | Tolima | 66421 | 2146 | 63461 | 814 | 4.0925 | -75.1545 | 2021-03-28 05:28:10 | Tolima, Colombia | ||
1734766 | 1734766 | 2021-03-14 | US | New York | Westchester | 36119 | 112854 | 2146 | 0 | 41.16278376 | -73.75741653 | 2021-03-15 05:25:51 | Westchester, New York, US | |
1838086 | 1838086 | 2021-03-12 | Peru | Cajamarca | 35453 | 2146 | 0 | 33307 | -6.430284 | -78.74559599999998 | 2021-03-13 05:25:15 | Cajamarca, Peru | ||
354461 | 354461 | 2021-03-11 | US | New Jersey | Middlesex | 34023 | 75779 | 2146 | 0 | 40.43629879 | -74.41426991 | 2021-03-12 05:26:50 | Middlesex, New Jersey, US | |
742761 | 742761 | 2021-02-20 | US | Arizona | Pima | 4019 | 108094 | 2146 | 0 | 105948 | 32.0971334 | -111.7890033 | 2021-02-21 05:24:33 | Pima, Arizona, US |
340930 | 340930 | 2021-02-03 | US | Connecticut | Hartford | 9003 | 64924 | 2146 | 0 | 62778 | 41.80283011 | -72.73103891 | 2021-02-04 05:22:26 | Hartford, Connecticut, US |
1972571 | 1972571 | 2020-11-25 | Italy | Lazio | 109592 | 2146 | 20881 | 86565 | 41.89277044 | 12.48366722 | 2020-11-26 05:27:44 | Lazio, Italy | ||
3836446 | 3836446 | 2020-11-21 | India | Rajasthan | 240676 | 2146 | 216579 | 21951 | 26.583423 | 73.847973 | 2020-11-22 05:25:45 | Rajasthan, India | ||
2848773 | 2848773 | 2020-09-18 | Honduras | 70611 | 2146 | 21149 | 47316 | 15.2 | -86.2419 | 2020-09-19 04:22:00 | Honduras | |||
2729001 | 2729001 | 2020-09-15 | Italy | Veneto | 24979 | 2146 | 19849 | 2984 | 45.43490485 | 12.33845213 | 2020-09-16 04:22:53 | Veneto, Italy | ||
371529 | 371529 | 2020-08-08 | Russia | Saint Petersburg | 32730 | 2146 | 24009 | 6575 | 59.960673899999996 | 30.158655100000004 | 2020-08-09 04:34:54 | Saint Petersburg, Russia |
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]);