johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
444 rows where deaths = 662 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
- US 291
- Papua New Guinea 36
- Sweden 22
- Russia 14
- Japan 9
- Lesotho 9
- Chile 8
- India 7
- Germany 5
- Ukraine 5
- Haiti 4
- Italy 4
- Qatar 4
- Colombia 3
- Uzbekistan 3
- Malaysia 2
- Mexico 2
- Peru 2
- Armenia 1
- Australia 1
- Bahrain 1
- Belarus 1
- Brazil 1
- Dominican Republic 1
- Ethiopia 1
- Finland 1
- Malta 1
- Pakistan 1
- Singapore 1
- Spain 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755746 | 2755746 | 2022-12-29 | US | South Carolina | Pickens | 45077 | 52897 | 662 | 0 | 34.88807695 | -82.72791551 | 2022-12-30 04:21:04 | Pickens, South Carolina, US | |
2752913 | 2752913 | 2022-12-29 | Japan | Nagano | 380555 | 662 | 0 | 36.132134 | 138.045528 | 2022-12-30 04:21:04 | Nagano, Japan | |||
1076752 | 1076752 | 2022-12-28 | US | South Carolina | Pickens | 45077 | 52897 | 662 | 0 | 34.88807695 | -82.72791551 | 2022-12-29 04:21:01 | Pickens, South Carolina, US | |
330749 | 330749 | 2022-12-27 | US | South Carolina | Pickens | 45077 | 52897 | 662 | 0 | 34.88807695 | -82.72791551 | 2022-12-28 04:21:04 | Pickens, South Carolina, US | |
327918 | 327918 | 2022-12-27 | Japan | Nara | 294447 | 662 | 0 | 34.317451 | 135.871644 | 2022-12-28 04:21:04 | Nara, Japan | |||
219601 | 219601 | 2022-12-26 | US | Michigan | Bay | 26017 | 31192 | 662 | 0 | 43.70639106 | -83.98731479 | 2022-12-27 04:21:07 | Bay, Michigan, US | |
217991 | 217991 | 2022-12-26 | Japan | Nara | 292334 | 662 | 0 | 34.317451 | 135.871644 | 2022-12-27 04:21:07 | Nara, Japan | |||
3224058 | 3224058 | 2022-12-25 | US | Michigan | Bay | 26017 | 31192 | 662 | 0 | 43.70639106 | -83.98731479 | 2022-12-26 04:21:06 | Bay, Michigan, US | |
1019972 | 1019972 | 2022-12-24 | US | Michigan | Bay | 26017 | 31192 | 662 | 0 | 43.70639106 | -83.98731479 | 2022-12-25 04:21:04 | Bay, Michigan, US | |
691995 | 691995 | 2022-12-23 | US | Michigan | Bay | 26017 | 31192 | 662 | 0 | 43.70639106 | -83.98731479 | 2022-12-24 04:21:02 | Bay, Michigan, US | |
2181205 | 2181205 | 2022-12-22 | US | Michigan | Bay | 26017 | 31192 | 662 | 0 | 43.70639106 | -83.98731479 | 2022-12-23 04:21:04 | Bay, Michigan, US | |
453009 | 453009 | 2022-12-21 | US | Michigan | Bay | 26017 | 31192 | 662 | 0 | 43.70639106 | -83.98731479 | 2022-12-22 04:20:56 | Bay, Michigan, US | |
2953008 | 2953008 | 2022-12-20 | US | Michigan | Bay | 26017 | 31192 | 662 | 0 | 43.70639106 | -83.98731479 | 2022-12-21 04:21:03 | Bay, Michigan, US | |
2951742 | 2951742 | 2022-12-20 | US | Alabama | Calhoun | 1015 | 39296 | 662 | 0 | 33.77483727 | -85.82630386 | 2022-12-21 04:21:03 | Calhoun, Alabama, US | |
3174144 | 3174144 | 2022-12-19 | US | Alabama | Calhoun | 1015 | 39296 | 662 | 0 | 33.77483727 | -85.82630386 | 2022-12-20 04:21:04 | Calhoun, Alabama, US | |
1628661 | 1628661 | 2022-12-18 | US | Alabama | Calhoun | 1015 | 39296 | 662 | 0 | 33.77483727 | -85.82630386 | 2022-12-19 04:21:03 | Calhoun, Alabama, US | |
1628329 | 1628329 | 2022-12-18 | Japan | Tochigi | 325225 | 662 | 0 | 36.689912 | 139.819213 | 2022-12-19 04:21:03 | Tochigi, Japan | |||
504040 | 504040 | 2022-12-17 | US | Alabama | Calhoun | 1015 | 39296 | 662 | 0 | 33.77483727 | -85.82630386 | 2022-12-18 04:21:03 | Calhoun, Alabama, US | |
3324612 | 3324612 | 2022-12-16 | US | Alabama | Calhoun | 1015 | 39296 | 662 | 0 | 33.77483727 | -85.82630386 | 2022-12-17 04:21:04 | Calhoun, Alabama, US | |
543124 | 543124 | 2022-12-15 | US | Alabama | Calhoun | 1015 | 39296 | 662 | 0 | 33.77483727 | -85.82630386 | 2022-12-16 04:21:01 | Calhoun, Alabama, US | |
348652 | 348652 | 2022-12-14 | US | Alabama | Calhoun | 1015 | 39296 | 662 | 0 | 33.77483727 | -85.82630386 | 2022-12-15 04:20:58 | Calhoun, Alabama, US | |
3716468 | 3716468 | 2022-12-06 | US | North Carolina | Buncombe | 37021 | 67034 | 662 | 0 | 35.61113393 | -82.53305 | 2022-12-07 04:20:58 | Buncombe, North Carolina, US | |
2417173 | 2417173 | 2022-12-05 | US | North Carolina | Buncombe | 37021 | 67034 | 662 | 0 | 35.61113393 | -82.53305 | 2022-12-06 04:21:03 | Buncombe, North Carolina, US | |
720781 | 720781 | 2022-12-04 | US | North Carolina | Buncombe | 37021 | 67034 | 662 | 0 | 35.61113393 | -82.53305 | 2022-12-05 04:20:58 | Buncombe, North Carolina, US | |
2819070 | 2819070 | 2022-12-03 | US | North Carolina | Buncombe | 37021 | 67034 | 662 | 0 | 35.61113393 | -82.53305 | 2022-12-04 04:20:56 | Buncombe, North Carolina, US | |
835926 | 835926 | 2022-12-02 | US | North Carolina | Buncombe | 37021 | 67034 | 662 | 0 | 35.61113393 | -82.53305 | 2022-12-03 04:21:02 | Buncombe, North Carolina, US | |
2138456 | 2138456 | 2022-12-01 | US | North Carolina | Buncombe | 37021 | 67034 | 662 | 0 | 35.61113393 | -82.53305 | 2022-12-02 04:21:07 | Buncombe, North Carolina, US | |
1966872 | 1966872 | 2022-11-30 | US | North Carolina | Buncombe | 37021 | 67034 | 662 | 0 | 35.61113393 | -82.53305 | 2022-12-01 04:21:03 | Buncombe, North Carolina, US | |
2559219 | 2559219 | 2022-11-29 | US | Oregon | Lane | 41039 | 75229 | 662 | 0 | 43.93727035 | -122.847753 | 2022-11-30 04:21:07 | Lane, Oregon, US | |
1242293 | 1242293 | 2022-11-28 | US | Oregon | Lane | 41039 | 75229 | 662 | 0 | 43.93727035 | -122.847753 | 2022-11-29 04:21:05 | Lane, Oregon, US | |
3554281 | 3554281 | 2022-11-27 | US | Oregon | Lane | 41039 | 75229 | 662 | 0 | 43.93727035 | -122.847753 | 2022-11-28 04:21:02 | Lane, Oregon, US | |
2102761 | 2102761 | 2022-11-26 | US | Oregon | Lane | 41039 | 75229 | 662 | 0 | 43.93727035 | -122.847753 | 2022-11-27 04:21:05 | Lane, Oregon, US | |
490252 | 490252 | 2022-11-25 | US | Oregon | Lane | 41039 | 75229 | 662 | 0 | 43.93727035 | -122.847753 | 2022-11-26 04:21:11 | Lane, Oregon, US | |
3526081 | 3526081 | 2022-11-24 | US | Oregon | Lane | 41039 | 75229 | 662 | 0 | 43.93727035 | -122.847753 | 2022-11-25 04:21:06 | Lane, Oregon, US | |
3314864 | 3314864 | 2022-11-23 | US | Oregon | Lane | 41039 | 75229 | 662 | 0 | 43.93727035 | -122.847753 | 2022-11-24 04:21:09 | Lane, Oregon, US | |
3312806 | 3312806 | 2022-11-23 | US | California | Placer | 6061 | 87179 | 662 | 0 | 39.06167234 | -120.7240569 | 2022-11-24 04:21:09 | Placer, California, US | |
1620847 | 1620847 | 2022-11-22 | US | California | Placer | 6061 | 87171 | 662 | 0 | 39.06167234 | -120.7240569 | 2022-11-23 04:21:06 | Placer, California, US | |
3460735 | 3460735 | 2022-11-21 | US | California | Placer | 6061 | 86809 | 662 | 0 | 39.06167234 | -120.7240569 | 2022-11-22 04:20:47 | Placer, California, US | |
3460154 | 3460154 | 2022-11-21 | Japan | Gifu | 342604 | 662 | 0 | 35.778671 | 137.055925 | 2022-11-22 04:20:47 | Gifu, Japan | |||
1640920 | 1640920 | 2022-11-20 | US | California | Placer | 6061 | 86805 | 662 | 0 | 39.06167234 | -120.7240569 | 2022-11-21 04:21:05 | Placer, California, US | |
2064477 | 2064477 | 2022-11-19 | US | California | Placer | 6061 | 86800 | 662 | 0 | 39.06167234 | -120.7240569 | 2022-11-20 04:21:08 | Placer, California, US | |
1755871 | 1755871 | 2022-11-18 | US | California | Placer | 6061 | 86793 | 662 | 0 | 39.06167234 | -120.7240569 | 2022-11-19 04:21:14 | Placer, California, US | |
3026864 | 3026864 | 2022-11-17 | US | California | Placer | 6061 | 86787 | 662 | 0 | 39.06167234 | -120.7240569 | 2022-11-18 04:21:15 | Placer, California, US | |
2486575 | 2486575 | 2022-11-16 | US | California | Placer | 6061 | 86785 | 662 | 0 | 39.06167234 | -120.7240569 | 2022-11-17 04:21:11 | Placer, California, US | |
292586 | 292586 | 2022-11-15 | US | California | Placer | 6061 | 86779 | 662 | 0 | 39.06167234 | -120.7240569 | 2022-11-16 04:21:09 | Placer, California, US | |
3597616 | 3597616 | 2022-11-14 | US | California | Placer | 6061 | 86282 | 662 | 0 | 39.06167234 | -120.7240569 | 2022-11-15 04:21:16 | Placer, California, US | |
312474 | 312474 | 2022-11-13 | US | California | Placer | 6061 | 86280 | 662 | 0 | 39.06167234 | -120.7240569 | 2022-11-14 04:21:09 | Placer, California, US | |
63635 | 63635 | 2022-11-12 | US | California | Placer | 6061 | 86275 | 662 | 0 | 39.06167234 | -120.7240569 | 2022-11-13 04:21:14 | Placer, California, US | |
2927797 | 2927797 | 2022-11-11 | US | California | Placer | 6061 | 86272 | 662 | 0 | 39.06167234 | -120.7240569 | 2022-11-12 04:20:41 | Placer, California, US | |
2506633 | 2506633 | 2022-11-10 | US | California | Placer | 6061 | 86266 | 662 | 0 | 39.06167234 | -120.7240569 | 2022-11-11 04:21:22 | Placer, California, US | |
2431508 | 2431508 | 2022-11-09 | US | California | Placer | 6061 | 86260 | 662 | 0 | 39.06167234 | -120.7240569 | 2022-11-10 04:21:16 | Placer, California, US | |
480164 | 480164 | 2022-11-08 | US | California | Placer | 6061 | 86254 | 662 | 0 | 39.06167234 | -120.7240569 | 2022-11-09 04:21:22 | Placer, California, US | |
2439314 | 2439314 | 2022-11-07 | US | California | Placer | 6061 | 86079 | 662 | 0 | 39.06167234 | -120.7240569 | 2022-11-08 04:21:21 | Placer, California, US | |
1050412 | 1050412 | 2022-11-06 | US | California | Placer | 6061 | 86073 | 662 | 0 | 39.06167234 | -120.7240569 | 2022-11-07 04:21:26 | Placer, California, US | |
618436 | 618436 | 2022-11-05 | US | California | Placer | 6061 | 86069 | 662 | 0 | 39.06167234 | -120.7240569 | 2022-11-06 04:21:24 | Placer, California, US | |
1022940 | 1022940 | 2022-11-04 | US | California | Placer | 6061 | 86067 | 662 | 0 | 39.06167234 | -120.7240569 | 2022-11-05 04:21:52 | Placer, California, US | |
431931 | 431931 | 2022-11-03 | US | California | Placer | 6061 | 86063 | 662 | 0 | 39.06167234 | -120.7240569 | 2022-11-04 04:22:11 | Placer, California, US | |
850173 | 850173 | 2022-11-02 | US | California | Placer | 6061 | 86057 | 662 | 0 | 39.06167234 | -120.7240569 | 2022-11-03 04:22:05 | Placer, California, US | |
849927 | 849927 | 2022-11-02 | Sweden | Sormland | 67918 | 662 | 0 | 59.0336 | 16.7519 | 2022-11-03 04:22:05 | Sormland, Sweden | |||
711024 | 711024 | 2022-11-01 | US | California | Placer | 6061 | 86046 | 662 | 0 | 39.06167234 | -120.7240569 | 2022-11-02 04:22:09 | Placer, California, US | |
710778 | 710778 | 2022-11-01 | Sweden | Sormland | 67918 | 662 | 0 | 59.0336 | 16.7519 | 2022-11-02 04:22:09 | Sormland, Sweden | |||
710455 | 710455 | 2022-11-01 | Japan | Kumamoto | 344679 | 662 | 0 | 32.608154 | 130.745231 | 2022-11-02 04:22:09 | Kumamoto, Japan | |||
3285473 | 3285473 | 2022-10-31 | US | California | Placer | 6061 | 85897 | 662 | 0 | 39.06167234 | -120.7240569 | 2022-11-01 04:22:36 | Placer, California, US | |
3285227 | 3285227 | 2022-10-31 | Sweden | Sormland | 67918 | 662 | 0 | 59.0336 | 16.7519 | 2022-11-01 04:22:36 | Sormland, Sweden | |||
3284904 | 3284904 | 2022-10-31 | Japan | Kumamoto | 343859 | 662 | 0 | 32.608154 | 130.745231 | 2022-11-01 04:22:36 | Kumamoto, Japan | |||
320506 | 320506 | 2022-10-30 | US | California | Placer | 6061 | 85894 | 662 | 0 | 39.06167234 | -120.7240569 | 2022-10-31 04:21:36 | Placer, California, US | |
320260 | 320260 | 2022-10-30 | Sweden | Sormland | 67918 | 662 | 0 | 59.0336 | 16.7519 | 2022-10-31 04:21:36 | Sormland, Sweden | |||
912782 | 912782 | 2022-10-29 | US | California | Placer | 6061 | 85891 | 662 | 0 | 39.06167234 | -120.7240569 | 2022-10-30 04:22:14 | Placer, California, US | |
912536 | 912536 | 2022-10-29 | Sweden | Sormland | 67918 | 662 | 0 | 59.0336 | 16.7519 | 2022-10-30 04:22:14 | Sormland, Sweden | |||
1367051 | 1367051 | 2022-10-28 | US | California | Placer | 6061 | 85889 | 662 | 0 | 39.06167234 | -120.7240569 | 2022-10-29 04:21:13 | Placer, California, US | |
1366805 | 1366805 | 2022-10-28 | Sweden | Sormland | 67918 | 662 | 0 | 59.0336 | 16.7519 | 2022-10-29 04:21:13 | Sormland, Sweden | |||
3038906 | 3038906 | 2022-10-27 | US | California | Placer | 6061 | 85884 | 662 | 0 | 39.06167234 | -120.7240569 | 2022-10-28 04:22:31 | Placer, California, US | |
3038660 | 3038660 | 2022-10-27 | Sweden | Sormland | 67918 | 662 | 0 | 59.0336 | 16.7519 | 2022-10-28 04:22:31 | Sormland, Sweden | |||
540352 | 540352 | 2022-10-26 | US | Massachusetts | Barnstable | 25001 | 45113 | 662 | 0 | 41.72980578 | -70.28854339 | 2022-10-27 04:22:01 | Barnstable, Massachusetts, US | |
539326 | 539326 | 2022-10-26 | US | California | Placer | 6061 | 85879 | 662 | 0 | 39.06167234 | -120.7240569 | 2022-10-27 04:22:01 | Placer, California, US | |
1831753 | 1831753 | 2022-10-25 | US | Massachusetts | Barnstable | 25001 | 45113 | 662 | 0 | 41.72980578 | -70.28854339 | 2022-10-26 04:22:19 | Barnstable, Massachusetts, US | |
1831305 | 1831305 | 2022-10-25 | US | Indiana | Vanderburgh | 18163 | 66671 | 662 | 0 | 38.02658833 | -87.58763124 | 2022-10-26 04:22:19 | Vanderburgh, Indiana, US | |
1830727 | 1830727 | 2022-10-25 | US | California | Placer | 6061 | 85875 | 662 | 0 | 39.06167234 | -120.7240569 | 2022-10-26 04:22:19 | Placer, California, US | |
796014 | 796014 | 2022-10-24 | US | Massachusetts | Barnstable | 25001 | 45113 | 662 | 0 | 41.72980578 | -70.28854339 | 2022-10-25 04:21:53 | Barnstable, Massachusetts, US | |
795566 | 795566 | 2022-10-24 | US | Indiana | Vanderburgh | 18163 | 66671 | 662 | 0 | 38.02658833 | -87.58763124 | 2022-10-25 04:21:53 | Vanderburgh, Indiana, US | |
794988 | 794988 | 2022-10-24 | US | California | Placer | 6061 | 85716 | 662 | 0 | 39.06167234 | -120.7240569 | 2022-10-25 04:21:53 | Placer, California, US | |
3278469 | 3278469 | 2022-10-23 | US | Massachusetts | Barnstable | 25001 | 45113 | 662 | 0 | 41.72980578 | -70.28854339 | 2022-10-24 04:22:29 | Barnstable, Massachusetts, US | |
3278021 | 3278021 | 2022-10-23 | US | Indiana | Vanderburgh | 18163 | 66671 | 662 | 0 | 38.02658833 | -87.58763124 | 2022-10-24 04:22:29 | Vanderburgh, Indiana, US | |
3277443 | 3277443 | 2022-10-23 | US | California | Placer | 6061 | 85712 | 662 | 0 | 39.06167234 | -120.7240569 | 2022-10-24 04:22:29 | Placer, California, US | |
2269507 | 2269507 | 2022-10-22 | US | Massachusetts | Barnstable | 25001 | 45113 | 662 | 0 | 41.72980578 | -70.28854339 | 2022-10-23 04:22:46 | Barnstable, Massachusetts, US | |
2269059 | 2269059 | 2022-10-22 | US | Indiana | Vanderburgh | 18163 | 66671 | 662 | 0 | 38.02658833 | -87.58763124 | 2022-10-23 04:22:46 | Vanderburgh, Indiana, US | |
2268481 | 2268481 | 2022-10-22 | US | California | Placer | 6061 | 85707 | 662 | 0 | 39.06167234 | -120.7240569 | 2022-10-23 04:22:46 | Placer, California, US | |
1593807 | 1593807 | 2022-10-21 | US | Massachusetts | Barnstable | 25001 | 45113 | 662 | 0 | 41.72980578 | -70.28854339 | 2022-10-22 04:22:53 | Barnstable, Massachusetts, US | |
1593359 | 1593359 | 2022-10-21 | US | Indiana | Vanderburgh | 18163 | 66671 | 662 | 0 | 38.02658833 | -87.58763124 | 2022-10-22 04:22:53 | Vanderburgh, Indiana, US | |
1592781 | 1592781 | 2022-10-21 | US | California | Placer | 6061 | 85702 | 662 | 0 | 39.06167234 | -120.7240569 | 2022-10-22 04:22:53 | Placer, California, US | |
2273523 | 2273523 | 2022-10-20 | US | Massachusetts | Barnstable | 25001 | 45113 | 662 | 0 | 41.72980578 | -70.28854339 | 2022-10-21 04:22:23 | Barnstable, Massachusetts, US | |
2273075 | 2273075 | 2022-10-20 | US | Indiana | Vanderburgh | 18163 | 66671 | 662 | 0 | 38.02658833 | -87.58763124 | 2022-10-21 04:22:23 | Vanderburgh, Indiana, US | |
2272497 | 2272497 | 2022-10-20 | US | California | Placer | 6061 | 85698 | 662 | 0 | 39.06167234 | -120.7240569 | 2022-10-21 04:22:23 | Placer, California, US | |
199410 | 199410 | 2022-10-19 | US | Indiana | Vanderburgh | 18163 | 66671 | 662 | 0 | 38.02658833 | -87.58763124 | 2022-10-20 04:22:59 | Vanderburgh, Indiana, US | |
2027578 | 2027578 | 2022-10-17 | US | South Carolina | Florence | 45041 | 47946 | 662 | 0 | 34.02361754 | -79.70189312 | 2022-10-18 04:22:42 | Florence, South Carolina, US | |
2162356 | 2162356 | 2022-10-16 | US | South Carolina | Florence | 45041 | 47946 | 662 | 0 | 34.02361754 | -79.70189312 | 2022-10-17 04:20:31 | Florence, South Carolina, US | |
518553 | 518553 | 2022-10-15 | US | South Carolina | Florence | 45041 | 47946 | 662 | 0 | 34.02361754 | -79.70189312 | 2022-10-16 04:22:39 | Florence, South Carolina, US | |
2035610 | 2035610 | 2022-10-14 | US | South Carolina | Florence | 45041 | 47946 | 662 | 0 | 34.02361754 | -79.70189312 | 2022-10-15 04:22:00 | Florence, South Carolina, US | |
3756298 | 3756298 | 2022-10-13 | US | South Carolina | Florence | 45041 | 47946 | 662 | 0 | 34.02361754 | -79.70189312 | 2022-10-14 04:22:28 | Florence, South Carolina, US | |
3754047 | 3754047 | 2022-10-13 | US | California | Placer | 6061 | 85539 | 662 | 0 | 39.06167234 | -120.7240569 | 2022-10-14 04:22:28 | Placer, California, US |
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]);