daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
112 rows where deaths = 1486 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-22 | US | Colorado | Denver | 8031 | 220186 | 1486 | 0 | 39.76018276 | -104.8725695 | 2022-12-23 04:21:04 | Denver, Colorado, US | |
2022-12-21 | US | Colorado | Denver | 8031 | 220045 | 1486 | 0 | 39.76018276 | -104.8725695 | 2022-12-22 04:20:56 | Denver, Colorado, US | |
2022-12-03 | US | Ohio | Lucas | 39095 | 120945 | 1486 | 0 | 41.62101218 | -83.65468618 | 2022-12-04 04:20:56 | Lucas, Ohio, US | |
2022-12-02 | US | Ohio | Lucas | 39095 | 120945 | 1486 | 0 | 41.62101218 | -83.65468618 | 2022-12-03 04:21:02 | Lucas, Ohio, US | |
2022-12-01 | US | Ohio | Lucas | 39095 | 120945 | 1486 | 0 | 41.62101218 | -83.65468618 | 2022-12-02 04:21:07 | Lucas, Ohio, US | |
2022-11-30 | US | Ohio | Lucas | 39095 | 120486 | 1486 | 0 | 41.62101218 | -83.65468618 | 2022-12-01 04:21:03 | Lucas, Ohio, US | |
2022-11-29 | US | Ohio | Lucas | 39095 | 120486 | 1486 | 0 | 41.62101218 | -83.65468618 | 2022-11-30 04:21:07 | Lucas, Ohio, US | |
2022-11-28 | US | Ohio | Lucas | 39095 | 120486 | 1486 | 0 | 41.62101218 | -83.65468618 | 2022-11-29 04:21:05 | Lucas, Ohio, US | |
2022-11-27 | US | Ohio | Lucas | 39095 | 120486 | 1486 | 0 | 41.62101218 | -83.65468618 | 2022-11-28 04:21:02 | Lucas, Ohio, US | |
2022-11-26 | US | Ohio | Lucas | 39095 | 120486 | 1486 | 0 | 41.62101218 | -83.65468618 | 2022-11-27 04:21:05 | Lucas, Ohio, US | |
2022-11-25 | US | Ohio | Lucas | 39095 | 120486 | 1486 | 0 | 41.62101218 | -83.65468618 | 2022-11-26 04:21:11 | Lucas, Ohio, US | |
2022-10-26 | Russia | Kurgan Oblast | 120961 | 1486 | 0 | 55.7655302 | 64.5632681 | 2022-10-27 04:22:01 | Kurgan Oblast, Russia | |||
2022-10-18 | US | Pennsylvania | Luzerne | 42079 | 87370 | 1486 | 0 | 41.17823008 | -75.98447579 | 2022-10-19 04:22:26 | Luzerne, Pennsylvania, US | |
2022-10-17 | US | Pennsylvania | Luzerne | 42079 | 87370 | 1486 | 0 | 41.17823008 | -75.98447579 | 2022-10-18 04:22:42 | Luzerne, Pennsylvania, US | |
2022-10-16 | US | Pennsylvania | Luzerne | 42079 | 87370 | 1486 | 0 | 41.17823008 | -75.98447579 | 2022-10-17 04:20:31 | Luzerne, Pennsylvania, US | |
2022-10-15 | US | Pennsylvania | Luzerne | 42079 | 87370 | 1486 | 0 | 41.17823008 | -75.98447579 | 2022-10-16 04:22:39 | Luzerne, Pennsylvania, US | |
2022-10-14 | US | Pennsylvania | Luzerne | 42079 | 87370 | 1486 | 0 | 41.17823008 | -75.98447579 | 2022-10-15 04:22:00 | Luzerne, Pennsylvania, US | |
2022-10-13 | US | Pennsylvania | Luzerne | 42079 | 87370 | 1486 | 0 | 41.17823008 | -75.98447579 | 2022-10-14 04:22:28 | Luzerne, Pennsylvania, US | |
2022-10-12 | US | Pennsylvania | Luzerne | 42079 | 87370 | 1486 | 0 | 41.17823008 | -75.98447579 | 2022-10-13 04:22:39 | Luzerne, Pennsylvania, US | |
2022-09-06 | US | Kansas | Sedgwick | 20173 | 159456 | 1486 | 0 | 37.6842718 | -97.4608198 | 2022-09-07 04:20:59 | Sedgwick, Kansas, US | |
2022-09-05 | US | Kansas | Sedgwick | 20173 | 159456 | 1486 | 0 | 37.6842718 | -97.4608198 | 2022-09-06 04:21:02 | Sedgwick, Kansas, US | |
2022-09-04 | US | Kansas | Sedgwick | 20173 | 159456 | 1486 | 0 | 37.6842718 | -97.4608198 | 2022-09-05 04:21:01 | Sedgwick, Kansas, US | |
2022-09-03 | US | Kansas | Sedgwick | 20173 | 159456 | 1486 | 0 | 37.6842718 | -97.4608198 | 2022-09-04 04:21:22 | Sedgwick, Kansas, US | |
2022-09-02 | US | Kansas | Sedgwick | 20173 | 159456 | 1486 | 0 | 37.6842718 | -97.4608198 | 2022-09-03 04:21:04 | Sedgwick, Kansas, US | |
2022-09-01 | US | Kansas | Sedgwick | 20173 | 159456 | 1486 | 0 | 37.6842718 | -97.4608198 | 2022-09-02 04:21:07 | Sedgwick, Kansas, US | |
2022-08-31 | US | Kansas | Sedgwick | 20173 | 159456 | 1486 | 0 | 37.6842718 | -97.4608198 | 2022-09-01 04:21:03 | Sedgwick, Kansas, US | |
2022-08-16 | US | Washington | Pierce | 53053 | 224280 | 1486 | 0 | 47.03892768 | -122.1405958 | 2022-08-17 04:20:59 | Pierce, Washington, US | |
2022-08-15 | US | Washington | Pierce | 53053 | 224280 | 1486 | 0 | 47.03892768 | -122.1405958 | 2022-08-16 04:20:58 | Pierce, Washington, US | |
2022-07-06 | Italy | P.A. Bolzano | 230525 | 1486 | 0 | 46.49933453 | 11.35662422 | 2022-07-07 04:20:55 | P.A. Bolzano, Italy | |||
2022-07-05 | Italy | P.A. Bolzano | 229885 | 1486 | 0 | 46.49933453 | 11.35662422 | 2022-07-06 04:20:58 | P.A. Bolzano, Italy | |||
2022-07-04 | Italy | P.A. Bolzano | 228846 | 1486 | 0 | 46.49933453 | 11.35662422 | 2022-07-05 04:20:45 | P.A. Bolzano, Italy | |||
2022-07-03 | Italy | P.A. Bolzano | 228590 | 1486 | 0 | 46.49933453 | 11.35662422 | 2022-07-04 04:20:54 | P.A. Bolzano, Italy | |||
2022-07-02 | Italy | P.A. Bolzano | 228215 | 1486 | 0 | 46.49933453 | 11.35662422 | 2022-07-03 04:20:59 | P.A. Bolzano, Italy | |||
2022-05-27 | Bahrain | 583530 | 1486 | 0 | 26.0275 | 50.55 | 2022-05-28 04:21:07 | Bahrain | ||||
2022-04-04 | US | Pennsylvania | York | 42133 | 118474 | 1486 | 0 | 39.9210089 | -76.73040131 | 2022-04-05 04:20:48 | York, Pennsylvania, US | |
2022-04-03 | US | Pennsylvania | York | 42133 | 118453 | 1486 | 0 | 39.9210089 | -76.73040131 | 2022-04-04 04:20:51 | York, Pennsylvania, US | |
2022-04-02 | US | Pennsylvania | York | 42133 | 118453 | 1486 | 0 | 39.9210089 | -76.73040131 | 2022-04-03 04:20:48 | York, Pennsylvania, US | |
2022-02-14 | Colombia | La Guajira | 55562 | 1486 | 0 | 11.3548 | -72.5205 | 2022-02-15 04:21:09 | La Guajira, Colombia | |||
2022-02-08 | US | Utah | Salt Lake | 49035 | 332599 | 1486 | 0 | 40.66616532 | -111.92160109999999 | 2022-02-09 04:21:04 | Salt Lake, Utah, US | |
2022-02-03 | US | New York | Monroe | 36055 | 146231 | 1486 | 0 | 43.14638895 | -77.69322942 | 2022-02-04 04:21:10 | Monroe, New York, US | |
2022-01-31 | US | Pennsylvania | Berks | 42011 | 99047 | 1486 | 0 | 40.41570541 | -75.92457766 | 2022-02-01 04:21:11 | Berks, Pennsylvania, US | |
2022-01-30 | US | Pennsylvania | Berks | 42011 | 98904 | 1486 | 0 | 40.41570541 | -75.92457766 | 2022-01-31 04:21:09 | Berks, Pennsylvania, US | |
2022-01-29 | US | Pennsylvania | Berks | 42011 | 98678 | 1486 | 0 | 40.41570541 | -75.92457766 | 2022-01-30 04:21:26 | Berks, Pennsylvania, US | |
2022-01-27 | Netherlands | Utrecht | 331510 | 1486 | 0 | 52.084251 | 5.163824 | 2022-01-28 04:21:09 | Utrecht, Netherlands | |||
2022-01-26 | Japan | Hokkaido | 78633 | 1486 | 0 | 43.385711 | 142.55231799999999 | 2022-01-27 04:21:19 | Hokkaido, Japan | |||
2022-01-20 | US | Michigan | Genesee | 26049 | 89365 | 1486 | 0 | 43.02244215 | -83.70589709 | 2022-01-21 04:21:09 | Genesee, Michigan, US | |
2022-01-19 | US | Michigan | Genesee | 26049 | 89365 | 1486 | 0 | 43.02244215 | -83.70589709 | 2022-01-20 04:21:07 | Genesee, Michigan, US | |
2022-01-09 | Russia | Tatarstan Republic | 43547 | 1486 | 0 | 55.7648572 | 52.43104273 | 2022-01-10 04:22:07 | Tatarstan Republic, Russia | |||
2022-01-06 | US | Ohio | Summit | 39153 | 97378 | 1486 | 0 | 41.12464734 | -81.53123079 | 2022-01-07 04:22:09 | Summit, Ohio, US | |
2021-12-17 | US | Pennsylvania | Lancaster | 42071 | 84477 | 1486 | 0 | 40.03904563 | -76.24770128 | 2021-12-18 02:22:20 | Lancaster, Pennsylvania, US | |
2021-12-13 | US | Texas | Travis | 48453 | 130608 | 1486 | 0 | 30.33432034 | -97.78535620000001 | 2021-12-14 04:22:38 | Travis, Texas, US | |
2021-12-12 | US | Texas | Travis | 48453 | 130440 | 1486 | 0 | 30.33432034 | -97.78535620000001 | 2021-12-13 04:22:02 | Travis, Texas, US | |
2021-12-10 | US | Ohio | Montgomery | 39113 | 82417 | 1486 | 0 | 39.75394919 | -84.29050975 | 2021-12-11 04:22:45 | Montgomery, Ohio, US | |
2021-12-02 | US | New Jersey | Camden | 34007 | 72535 | 1486 | 0 | 39.80343818 | -74.96388753 | 2021-12-03 04:23:05 | Camden, New Jersey, US | |
2021-11-17 | US | California | Alameda | 6001 | 123716 | 1486 | 0 | 37.64629437 | -121.8929271 | 2021-11-18 04:21:33 | Alameda, California, US | |
2021-11-17 | Russia | Khakassia Republic | 47457 | 1486 | 0 | 53.72258845 | 91.44293627 | 2021-11-18 04:21:33 | Khakassia Republic, Russia | |||
2021-11-06 | Russia | Kemerovo Oblast | 65178 | 1486 | 0 | 54.53357809999999 | 87.342861 | 2021-11-07 04:21:53 | Kemerovo Oblast, Russia | |||
2021-10-14 | US | Pennsylvania | Delaware | 42045 | 61213 | 1486 | 0 | 39.91680171 | -75.40243663 | 2021-10-15 04:21:26 | Delaware, Pennsylvania, US | |
2021-09-30 | US | Massachusetts | Bristol | 25005 | 77227 | 1486 | 0 | 41.79228404 | -71.10872211 | 2021-10-01 04:21:35 | Bristol, Massachusetts, US | |
2021-09-26 | US | Kentucky | Jefferson | 21111 | 109323 | 1486 | 0 | 38.18664655 | -85.65931031 | 2021-09-27 04:21:16 | Jefferson, Kentucky, US | |
2021-09-08 | US | California | Kern | 6029 | 129325 | 1486 | 0 | 35.34329425 | -118.72777959999999 | 2021-09-09 04:21:27 | Kern, California, US | |
2021-09-02 | Yemen | 7951 | 1486 | 0 | 15.552726999999999 | 48.516388 | 2021-09-03 04:21:20 | Yemen | ||||
2021-09-01 | US | Wisconsin | Milwaukee | 55079 | 131669 | 1486 | 0 | 43.00486062 | -87.96733172 | 2021-09-02 04:21:15 | Milwaukee, Wisconsin, US | |
2021-08-20 | Russia | Tver Oblast | 58400 | 1486 | 0 | 57.1134475 | 35.174442799999994 | 2021-08-21 04:21:38 | Tver Oblast, Russia | |||
2021-06-27 | Ukraine | Crimea Republic* | 47534 | 1486 | 43029 | 3019 | 45.2835 | 34.2008 | 2021-06-28 04:21:29 | Crimea Republic*, Ukraine | ||
2021-06-21 | Mexico | Baja California Sur | 36319 | 1486 | 0 | 34833 | 26.0444 | -111.6661 | 2021-06-22 04:21:34 | Baja California Sur, Mexico | ||
2021-06-20 | Mexico | Baja California Sur | 36223 | 1486 | 0 | 34737 | 26.0444 | -111.6661 | 2021-06-21 04:21:41 | Baja California Sur, Mexico | ||
2021-06-17 | Russia | Chuvashia Republic | 26578 | 1486 | 24322 | 770 | 55.4259922 | 47.0849429 | 2021-06-18 04:22:16 | Chuvashia Republic, Russia | ||
2021-06-16 | Peru | Tumbes | 16938 | 1486 | 0 | 15452 | -3.857496 | -80.54525500000003 | 2021-06-17 04:22:36 | Tumbes, Peru | ||
2021-06-15 | Peru | Tumbes | 16938 | 1486 | 0 | 15452 | -3.857496 | -80.54525500000003 | 2021-06-16 04:22:32 | Tumbes, Peru | ||
2021-06-14 | Peru | Tumbes | 16938 | 1486 | 0 | 15452 | -3.857496 | -80.54525500000003 | 2021-06-15 04:22:22 | Tumbes, Peru | ||
2021-06-13 | Peru | Tumbes | 16916 | 1486 | 0 | 15430 | -3.857496 | -80.54525500000003 | 2021-06-14 04:22:46 | Tumbes, Peru | ||
2021-06-12 | Peru | Tumbes | 16916 | 1486 | 0 | 15430 | -3.857496 | -80.54525500000003 | 2021-06-13 04:22:44 | Tumbes, Peru | ||
2021-06-09 | US | Ohio | Franklin | 39049 | 128322 | 1486 | 0 | 39.96995815 | -83.01115755 | 2021-06-10 04:23:17 | Franklin, Ohio, US | |
2021-05-27 | Russia | Dagestan Republic | 33429 | 1486 | 31036 | 907 | 43.05749160000001 | 47.1332224 | 2021-05-28 04:20:36 | Dagestan Republic, Russia | ||
2021-05-03 | US | Massachusetts | Suffolk | 25025 | 91138 | 1486 | 0 | 42.3279514 | -71.07850442 | 2021-05-04 04:20:34 | Suffolk, Massachusetts, US | |
2021-05-02 | US | Massachusetts | Suffolk | 25025 | 91087 | 1486 | 0 | 42.3279514 | -71.07850442 | 2021-05-03 04:20:39 | Suffolk, Massachusetts, US | |
2021-04-28 | Ukraine | Vinnytsia Oblast | 67331 | 1486 | 49924 | 15921 | 49.2331 | 28.4682 | 2021-04-29 04:20:55 | Vinnytsia Oblast, Ukraine | ||
2021-04-21 | Germany | Schleswig-Holstein | 55907 | 1486 | 50150 | 4611 | 54.2194 | 9.6961 | 2021-04-22 04:20:53 | Schleswig-Holstein, Germany | ||
2021-04-08 | US | Maryland | Montgomery | 24031 | 67613 | 1486 | 0 | 39.13676329 | -77.20358245 | 2021-04-09 04:21:13 | Montgomery, Maryland, US | |
2021-04-07 | Peru | Tacna | 22131 | 1486 | 0 | 20645 | -17.644160999999997 | -70.27756 | 2021-04-08 04:21:13 | Tacna, Peru | ||
2021-03-29 | United Arab Emirates | 457071 | 1486 | 440731 | 14854 | 23.424076 | 53.847818 | 2021-03-30 04:26:23 | United Arab Emirates | |||
2021-03-25 | Chile | Biobio | 90942 | 1486 | 84184 | 5272 | -37.4464 | -72.1416 | 2021-03-26 05:26:55 | Biobio, Chile | ||
2021-03-19 | US | California | Sacramento | 6067 | 97276 | 1486 | 0 | 38.45106826 | -121.3425374 | 2021-03-20 05:25:46 | Sacramento, California, US | |
2021-03-17 | Netherlands | Limburg | 76363 | 1486 | 0 | 74795 | 51.209227 | 5.93387 | 2021-03-18 05:26:22 | Limburg, Netherlands | ||
2021-03-01 | US | Texas | Cameron | 48061 | 41159 | 1486 | 0 | 35753 | 26.14524221 | -97.48140372 | 2021-03-02 05:23:30 | Cameron, Texas, US |
2021-02-16 | Latvia | 77697 | 1486 | 65450 | 10761 | 56.8796 | 24.6032 | 2021-02-17 05:23:10 | Latvia | |||
2021-02-12 | Mexico | Nayarit | 10438 | 1486 | 0 | 8952 | 21.7514 | -104.8455 | 2021-02-13 05:22:12 | Nayarit, Mexico | ||
2021-02-09 | Korea, South | 81930 | 1486 | 72226 | 8218 | 35.90775700000001 | 127.766922 | 2021-02-10 05:22:41 | Korea, South | |||
2021-01-26 | India | Bihar | 258996 | 1486 | 255174 | 2336 | 25.679658 | 85.60484 | 2021-01-27 05:23:41 | Bihar, India | ||
2021-01-21 | US | Minnesota | Hennepin | 27053 | 93511 | 1486 | 0 | 92025 | 45.00761521 | -93.47694895 | 2021-01-22 05:22:10 | Hennepin, Minnesota, US |
2021-01-14 | Mexico | Aguascalientes | 18161 | 1486 | 0 | 16675 | 21.8853 | -102.2916 | 2021-01-15 05:22:24 | Aguascalientes, Mexico | ||
2020-12-27 | US | Connecticut | New Haven | 9009 | 44134 | 1486 | 0 | 42648 | 41.4080325 | -72.93620426 | 2020-12-28 05:22:06 | New Haven, Connecticut, US |
2020-12-26 | US | Connecticut | New Haven | 9009 | 44134 | 1486 | 0 | 42648 | 41.4080325 | -72.93620426 | 2020-12-27 05:22:55 | New Haven, Connecticut, US |
2020-12-25 | US | Connecticut | New Haven | 9009 | 44134 | 1486 | 0 | 42648 | 41.4080325 | -72.93620426 | 2020-12-26 05:22:28 | New Haven, Connecticut, US |
2020-12-24 | US | Connecticut | New Haven | 9009 | 44134 | 1486 | 0 | 42648 | 41.4080325 | -72.93620426 | 2020-12-25 05:22:48 | New Haven, Connecticut, US |
2020-12-21 | Russia | Nizhny Novgorod Oblast | 64804 | 1486 | 57794 | 5524 | 55.47180329999999 | 44.0911594 | 2020-12-22 05:22:33 | Nizhny Novgorod Oblast, Russia | ||
2020-12-14 | Peru | Puno | 18905 | 1486 | 0 | 17419 | -14.995826999999998 | -69.922726 | 2020-12-15 05:26:38 | Puno, Peru | ||
2020-11-28 | US | New Jersey | Middlesex | 34023 | 31622 | 1486 | 0 | 30136 | 40.43629879 | -74.41426991 | 2020-11-29 05:25:55 | Middlesex, New Jersey, US |
2020-11-27 | US | New Jersey | Middlesex | 34023 | 31368 | 1486 | 0 | 29882 | 40.43629879 | -74.41426991 | 2020-11-28 05:25:50 | Middlesex, New Jersey, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;