johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
3,231 rows where deaths = 187 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 2,556
- France 344
- Japan 54
- Russia 53
- Chile 30
- Spain 26
- Malaysia 22
- Canada 14
- Pakistan 14
- Malawi 13
- Ukraine 10
- India 9
- Australia 8
- Colombia 7
- Netherlands 7
- Nicaragua 7
- Sweden 5
- Djibouti 4
- Suriname 4
- Burkina Faso 3
- Mexico 3
- Namibia 3
- Peru 3
- Germany 2
- Niger 2
- Afghanistan 1
- Azerbaijan 1
- Barbados 1
- Brazil 1
- Cabo Verde 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755521 | 2755521 | 2022-12-29 | US | Oregon | Coos | 41011 | 14566 | 187 | 0 | 43.17406868 | -124.0594514 | 2022-12-30 04:21:04 | Coos, Oregon, US | |
2754727 | 2754727 | 2022-12-29 | US | Mississippi | Lafayette | 28071 | 18275 | 187 | 0 | 34.35687874 | -89.48490961 | 2022-12-30 04:21:04 | Lafayette, Mississippi, US | |
2752784 | 2752784 | 2022-12-29 | France | Mayotte | 41969 | 187 | 0 | -12.8275 | 45.166244 | 2022-12-30 04:21:04 | Mayotte, France | |||
1076527 | 1076527 | 2022-12-28 | US | Oregon | Coos | 41011 | 14566 | 187 | 0 | 43.17406868 | -124.0594514 | 2022-12-29 04:21:01 | Coos, Oregon, US | |
1075733 | 1075733 | 2022-12-28 | US | Mississippi | Lafayette | 28071 | 18275 | 187 | 0 | 34.35687874 | -89.48490961 | 2022-12-29 04:21:01 | Lafayette, Mississippi, US | |
1073790 | 1073790 | 2022-12-28 | France | Mayotte | 41969 | 187 | 0 | -12.8275 | 45.166244 | 2022-12-29 04:21:01 | Mayotte, France | |||
329730 | 329730 | 2022-12-27 | US | Mississippi | Lafayette | 28071 | 18275 | 187 | 0 | 34.35687874 | -89.48490961 | 2022-12-28 04:21:04 | Lafayette, Mississippi, US | |
327787 | 327787 | 2022-12-27 | France | Mayotte | 41969 | 187 | 0 | -12.8275 | 45.166244 | 2022-12-28 04:21:04 | Mayotte, France | |||
219803 | 219803 | 2022-12-26 | US | Mississippi | Lafayette | 28071 | 18186 | 187 | 0 | 34.35687874 | -89.48490961 | 2022-12-27 04:21:07 | Lafayette, Mississippi, US | |
217860 | 217860 | 2022-12-26 | France | Mayotte | 41969 | 187 | 0 | -12.8275 | 45.166244 | 2022-12-27 04:21:07 | Mayotte, France | |||
3224260 | 3224260 | 2022-12-25 | US | Mississippi | Lafayette | 28071 | 18186 | 187 | 0 | 34.35687874 | -89.48490961 | 2022-12-26 04:21:06 | Lafayette, Mississippi, US | |
3222317 | 3222317 | 2022-12-25 | France | Mayotte | 41969 | 187 | 0 | -12.8275 | 45.166244 | 2022-12-26 04:21:06 | Mayotte, France | |||
1020174 | 1020174 | 2022-12-24 | US | Mississippi | Lafayette | 28071 | 18186 | 187 | 0 | 34.35687874 | -89.48490961 | 2022-12-25 04:21:04 | Lafayette, Mississippi, US | |
1018231 | 1018231 | 2022-12-24 | France | Mayotte | 41969 | 187 | 0 | -12.8275 | 45.166244 | 2022-12-25 04:21:04 | Mayotte, France | |||
692197 | 692197 | 2022-12-23 | US | Mississippi | Lafayette | 28071 | 18186 | 187 | 0 | 34.35687874 | -89.48490961 | 2022-12-24 04:21:02 | Lafayette, Mississippi, US | |
690254 | 690254 | 2022-12-23 | France | Mayotte | 41969 | 187 | 0 | -12.8275 | 45.166244 | 2022-12-24 04:21:02 | Mayotte, France | |||
2181407 | 2181407 | 2022-12-22 | US | Mississippi | Lafayette | 28071 | 18186 | 187 | 0 | 34.35687874 | -89.48490961 | 2022-12-23 04:21:04 | Lafayette, Mississippi, US | |
2179464 | 2179464 | 2022-12-22 | France | Mayotte | 41969 | 187 | 0 | -12.8275 | 45.166244 | 2022-12-23 04:21:04 | Mayotte, France | |||
453928 | 453928 | 2022-12-21 | US | Oklahoma | Caddo | 40015 | 9694 | 187 | 0 | 35.17364557 | -98.37534464 | 2022-12-22 04:20:56 | Caddo, Oklahoma, US | |
453211 | 453211 | 2022-12-21 | US | Mississippi | Lafayette | 28071 | 18186 | 187 | 0 | 34.35687874 | -89.48490961 | 2022-12-22 04:20:56 | Lafayette, Mississippi, US | |
451268 | 451268 | 2022-12-21 | France | Mayotte | 41921 | 187 | 0 | -12.8275 | 45.166244 | 2022-12-22 04:20:56 | Mayotte, France | |||
2953927 | 2953927 | 2022-12-20 | US | Oklahoma | Caddo | 40015 | 9694 | 187 | 0 | 35.17364557 | -98.37534464 | 2022-12-21 04:21:03 | Caddo, Oklahoma, US | |
2951267 | 2951267 | 2022-12-20 | France | Mayotte | 41921 | 187 | 0 | -12.8275 | 45.166244 | 2022-12-21 04:21:03 | Mayotte, France | |||
3176329 | 3176329 | 2022-12-19 | US | Oklahoma | Caddo | 40015 | 9694 | 187 | 0 | 35.17364557 | -98.37534464 | 2022-12-20 04:21:04 | Caddo, Oklahoma, US | |
3173669 | 3173669 | 2022-12-19 | France | Mayotte | 41921 | 187 | 0 | -12.8275 | 45.166244 | 2022-12-20 04:21:04 | Mayotte, France | |||
1630846 | 1630846 | 2022-12-18 | US | Oklahoma | Caddo | 40015 | 9694 | 187 | 0 | 35.17364557 | -98.37534464 | 2022-12-19 04:21:03 | Caddo, Oklahoma, US | |
1628186 | 1628186 | 2022-12-18 | France | Mayotte | 41921 | 187 | 0 | -12.8275 | 45.166244 | 2022-12-19 04:21:03 | Mayotte, France | |||
506225 | 506225 | 2022-12-17 | US | Oklahoma | Caddo | 40015 | 9694 | 187 | 0 | 35.17364557 | -98.37534464 | 2022-12-18 04:21:03 | Caddo, Oklahoma, US | |
503565 | 503565 | 2022-12-17 | France | Mayotte | 41921 | 187 | 0 | -12.8275 | 45.166244 | 2022-12-18 04:21:03 | Mayotte, France | |||
3326797 | 3326797 | 2022-12-16 | US | Oklahoma | Caddo | 40015 | 9694 | 187 | 0 | 35.17364557 | -98.37534464 | 2022-12-17 04:21:04 | Caddo, Oklahoma, US | |
3324137 | 3324137 | 2022-12-16 | France | Mayotte | 41921 | 187 | 0 | -12.8275 | 45.166244 | 2022-12-17 04:21:04 | Mayotte, France | |||
545309 | 545309 | 2022-12-15 | US | Oklahoma | Caddo | 40015 | 9694 | 187 | 0 | 35.17364557 | -98.37534464 | 2022-12-16 04:21:01 | Caddo, Oklahoma, US | |
542649 | 542649 | 2022-12-15 | France | Mayotte | 41853 | 187 | 0 | -12.8275 | 45.166244 | 2022-12-16 04:21:01 | Mayotte, France | |||
350837 | 350837 | 2022-12-14 | US | Oklahoma | Caddo | 40015 | 9636 | 187 | 0 | 35.17364557 | -98.37534464 | 2022-12-15 04:20:58 | Caddo, Oklahoma, US | |
348177 | 348177 | 2022-12-14 | France | Mayotte | 41853 | 187 | 0 | -12.8275 | 45.166244 | 2022-12-15 04:20:58 | Mayotte, France | |||
310425 | 310425 | 2022-12-13 | US | Oklahoma | Caddo | 40015 | 9636 | 187 | 0 | 35.17364557 | -98.37534464 | 2022-12-14 04:21:04 | Caddo, Oklahoma, US | |
307765 | 307765 | 2022-12-13 | France | Mayotte | 41853 | 187 | 0 | -12.8275 | 45.166244 | 2022-12-14 04:21:04 | Mayotte, France | |||
1151486 | 1151486 | 2022-12-12 | US | Oklahoma | Caddo | 40015 | 9636 | 187 | 0 | 35.17364557 | -98.37534464 | 2022-12-13 04:21:01 | Caddo, Oklahoma, US | |
1148826 | 1148826 | 2022-12-12 | France | Mayotte | 41853 | 187 | 0 | -12.8275 | 45.166244 | 2022-12-13 04:21:01 | Mayotte, France | |||
871340 | 871340 | 2022-12-11 | US | Oklahoma | Caddo | 40015 | 9636 | 187 | 0 | 35.17364557 | -98.37534464 | 2022-12-12 04:21:01 | Caddo, Oklahoma, US | |
868680 | 868680 | 2022-12-11 | France | Mayotte | 41853 | 187 | 0 | -12.8275 | 45.166244 | 2022-12-12 04:21:01 | Mayotte, France | |||
259870 | 259870 | 2022-12-10 | US | Oklahoma | Caddo | 40015 | 9636 | 187 | 0 | 35.17364557 | -98.37534464 | 2022-12-11 04:20:50 | Caddo, Oklahoma, US | |
257210 | 257210 | 2022-12-10 | France | Mayotte | 41853 | 187 | 0 | -12.8275 | 45.166244 | 2022-12-11 04:20:50 | Mayotte, France | |||
3938584 | 3938584 | 2022-12-09 | US | Oklahoma | Caddo | 40015 | 9636 | 187 | 0 | 35.17364557 | -98.37534464 | 2022-12-10 04:21:02 | Caddo, Oklahoma, US | |
3935924 | 3935924 | 2022-12-09 | France | Mayotte | 41853 | 187 | 0 | -12.8275 | 45.166244 | 2022-12-10 04:21:02 | Mayotte, France | |||
3379916 | 3379916 | 2022-12-08 | US | Oklahoma | Caddo | 40015 | 9636 | 187 | 0 | 35.17364557 | -98.37534464 | 2022-12-09 04:21:05 | Caddo, Oklahoma, US | |
3377256 | 3377256 | 2022-12-08 | France | Mayotte | 41679 | 187 | 0 | -12.8275 | 45.166244 | 2022-12-09 04:21:05 | Mayotte, France | |||
1987187 | 1987187 | 2022-12-07 | US | Oklahoma | Caddo | 40015 | 9578 | 187 | 0 | 35.17364557 | -98.37534464 | 2022-12-08 04:21:07 | Caddo, Oklahoma, US | |
1987126 | 1987126 | 2022-12-07 | US | Ohio | Highland | 39071 | 12836 | 187 | 0 | 39.1839264 | -83.60331456 | 2022-12-08 04:21:07 | Highland, Ohio, US | |
1984527 | 1984527 | 2022-12-07 | France | Mayotte | 41679 | 187 | 0 | -12.8275 | 45.166244 | 2022-12-08 04:21:07 | Mayotte, France | |||
3716710 | 3716710 | 2022-12-06 | US | Oklahoma | Caddo | 40015 | 9578 | 187 | 0 | 35.17364557 | -98.37534464 | 2022-12-07 04:20:58 | Caddo, Oklahoma, US | |
3716649 | 3716649 | 2022-12-06 | US | Ohio | Highland | 39071 | 12836 | 187 | 0 | 39.1839264 | -83.60331456 | 2022-12-07 04:20:58 | Highland, Ohio, US | |
3714050 | 3714050 | 2022-12-06 | France | Mayotte | 41679 | 187 | 0 | -12.8275 | 45.166244 | 2022-12-07 04:20:58 | Mayotte, France | |||
2417415 | 2417415 | 2022-12-05 | US | Oklahoma | Caddo | 40015 | 9578 | 187 | 0 | 35.17364557 | -98.37534464 | 2022-12-06 04:21:03 | Caddo, Oklahoma, US | |
2417354 | 2417354 | 2022-12-05 | US | Ohio | Highland | 39071 | 12836 | 187 | 0 | 39.1839264 | -83.60331456 | 2022-12-06 04:21:03 | Highland, Ohio, US | |
2416495 | 2416495 | 2022-12-05 | US | Michigan | Barry | 26015 | 16393 | 187 | 0 | 42.59513984 | -85.30834519 | 2022-12-06 04:21:03 | Barry, Michigan, US | |
2414755 | 2414755 | 2022-12-05 | France | Mayotte | 41679 | 187 | 0 | -12.8275 | 45.166244 | 2022-12-06 04:21:03 | Mayotte, France | |||
721023 | 721023 | 2022-12-04 | US | Oklahoma | Caddo | 40015 | 9578 | 187 | 0 | 35.17364557 | -98.37534464 | 2022-12-05 04:20:58 | Caddo, Oklahoma, US | |
720962 | 720962 | 2022-12-04 | US | Ohio | Highland | 39071 | 12836 | 187 | 0 | 39.1839264 | -83.60331456 | 2022-12-05 04:20:58 | Highland, Ohio, US | |
720103 | 720103 | 2022-12-04 | US | Michigan | Barry | 26015 | 16393 | 187 | 0 | 42.59513984 | -85.30834519 | 2022-12-05 04:20:58 | Barry, Michigan, US | |
718363 | 718363 | 2022-12-04 | France | Mayotte | 41206 | 187 | 0 | -12.8275 | 45.166244 | 2022-12-05 04:20:58 | Mayotte, France | |||
2819312 | 2819312 | 2022-12-03 | US | Oklahoma | Caddo | 40015 | 9578 | 187 | 0 | 35.17364557 | -98.37534464 | 2022-12-04 04:20:56 | Caddo, Oklahoma, US | |
2819251 | 2819251 | 2022-12-03 | US | Ohio | Highland | 39071 | 12836 | 187 | 0 | 39.1839264 | -83.60331456 | 2022-12-04 04:20:56 | Highland, Ohio, US | |
2818392 | 2818392 | 2022-12-03 | US | Michigan | Barry | 26015 | 16393 | 187 | 0 | 42.59513984 | -85.30834519 | 2022-12-04 04:20:56 | Barry, Michigan, US | |
2816652 | 2816652 | 2022-12-03 | France | Mayotte | 41206 | 187 | 0 | -12.8275 | 45.166244 | 2022-12-04 04:20:56 | Mayotte, France | |||
836168 | 836168 | 2022-12-02 | US | Oklahoma | Caddo | 40015 | 9578 | 187 | 0 | 35.17364557 | -98.37534464 | 2022-12-03 04:21:02 | Caddo, Oklahoma, US | |
836107 | 836107 | 2022-12-02 | US | Ohio | Highland | 39071 | 12836 | 187 | 0 | 39.1839264 | -83.60331456 | 2022-12-03 04:21:02 | Highland, Ohio, US | |
835248 | 835248 | 2022-12-02 | US | Michigan | Barry | 26015 | 16393 | 187 | 0 | 42.59513984 | -85.30834519 | 2022-12-03 04:21:02 | Barry, Michigan, US | |
833508 | 833508 | 2022-12-02 | France | Mayotte | 41206 | 187 | 0 | -12.8275 | 45.166244 | 2022-12-03 04:21:02 | Mayotte, France | |||
2138698 | 2138698 | 2022-12-01 | US | Oklahoma | Caddo | 40015 | 9578 | 187 | 0 | 35.17364557 | -98.37534464 | 2022-12-02 04:21:07 | Caddo, Oklahoma, US | |
2138637 | 2138637 | 2022-12-01 | US | Ohio | Highland | 39071 | 12836 | 187 | 0 | 39.1839264 | -83.60331456 | 2022-12-02 04:21:07 | Highland, Ohio, US | |
2137778 | 2137778 | 2022-12-01 | US | Michigan | Barry | 26015 | 16393 | 187 | 0 | 42.59513984 | -85.30834519 | 2022-12-02 04:21:07 | Barry, Michigan, US | |
2136038 | 2136038 | 2022-12-01 | France | Mayotte | 41206 | 187 | 0 | -12.8275 | 45.166244 | 2022-12-02 04:21:07 | Mayotte, France | |||
1967053 | 1967053 | 2022-11-30 | US | Ohio | Highland | 39071 | 12781 | 187 | 0 | 39.1839264 | -83.60331456 | 2022-12-01 04:21:03 | Highland, Ohio, US | |
1966194 | 1966194 | 2022-11-30 | US | Michigan | Barry | 26015 | 16393 | 187 | 0 | 42.59513984 | -85.30834519 | 2022-12-01 04:21:03 | Barry, Michigan, US | |
1964454 | 1964454 | 2022-11-30 | France | Mayotte | 41176 | 187 | 0 | -12.8275 | 45.166244 | 2022-12-01 04:21:03 | Mayotte, France | |||
2559067 | 2559067 | 2022-11-29 | US | Ohio | Highland | 39071 | 12781 | 187 | 0 | 39.1839264 | -83.60331456 | 2022-11-30 04:21:07 | Highland, Ohio, US | |
2558208 | 2558208 | 2022-11-29 | US | Michigan | Barry | 26015 | 16393 | 187 | 0 | 42.59513984 | -85.30834519 | 2022-11-30 04:21:07 | Barry, Michigan, US | |
2556468 | 2556468 | 2022-11-29 | France | Mayotte | 41176 | 187 | 0 | -12.8275 | 45.166244 | 2022-11-30 04:21:07 | Mayotte, France | |||
1242141 | 1242141 | 2022-11-28 | US | Ohio | Highland | 39071 | 12781 | 187 | 0 | 39.1839264 | -83.60331456 | 2022-11-29 04:21:05 | Highland, Ohio, US | |
1241282 | 1241282 | 2022-11-28 | US | Michigan | Barry | 26015 | 16366 | 187 | 0 | 42.59513984 | -85.30834519 | 2022-11-29 04:21:05 | Barry, Michigan, US | |
1239542 | 1239542 | 2022-11-28 | France | Mayotte | 41176 | 187 | 0 | -12.8275 | 45.166244 | 2022-11-29 04:21:05 | Mayotte, France | |||
3554129 | 3554129 | 2022-11-27 | US | Ohio | Highland | 39071 | 12781 | 187 | 0 | 39.1839264 | -83.60331456 | 2022-11-28 04:21:02 | Highland, Ohio, US | |
3553270 | 3553270 | 2022-11-27 | US | Michigan | Barry | 26015 | 16366 | 187 | 0 | 42.59513984 | -85.30834519 | 2022-11-28 04:21:02 | Barry, Michigan, US | |
3551530 | 3551530 | 2022-11-27 | France | Mayotte | 40612 | 187 | 0 | -12.8275 | 45.166244 | 2022-11-28 04:21:02 | Mayotte, France | |||
2102609 | 2102609 | 2022-11-26 | US | Ohio | Highland | 39071 | 12781 | 187 | 0 | 39.1839264 | -83.60331456 | 2022-11-27 04:21:05 | Highland, Ohio, US | |
2101750 | 2101750 | 2022-11-26 | US | Michigan | Barry | 26015 | 16366 | 187 | 0 | 42.59513984 | -85.30834519 | 2022-11-27 04:21:05 | Barry, Michigan, US | |
2100010 | 2100010 | 2022-11-26 | France | Mayotte | 40612 | 187 | 0 | -12.8275 | 45.166244 | 2022-11-27 04:21:05 | Mayotte, France | |||
490100 | 490100 | 2022-11-25 | US | Ohio | Highland | 39071 | 12781 | 187 | 0 | 39.1839264 | -83.60331456 | 2022-11-26 04:21:11 | Highland, Ohio, US | |
489241 | 489241 | 2022-11-25 | US | Michigan | Barry | 26015 | 16366 | 187 | 0 | 42.59513984 | -85.30834519 | 2022-11-26 04:21:11 | Barry, Michigan, US | |
487501 | 487501 | 2022-11-25 | France | Mayotte | 40612 | 187 | 0 | -12.8275 | 45.166244 | 2022-11-26 04:21:11 | Mayotte, France | |||
3525929 | 3525929 | 2022-11-24 | US | Ohio | Highland | 39071 | 12781 | 187 | 0 | 39.1839264 | -83.60331456 | 2022-11-25 04:21:06 | Highland, Ohio, US | |
3525070 | 3525070 | 2022-11-24 | US | Michigan | Barry | 26015 | 16366 | 187 | 0 | 42.59513984 | -85.30834519 | 2022-11-25 04:21:06 | Barry, Michigan, US | |
3523330 | 3523330 | 2022-11-24 | France | Mayotte | 40612 | 187 | 0 | -12.8275 | 45.166244 | 2022-11-25 04:21:06 | Mayotte, France | |||
3314712 | 3314712 | 2022-11-23 | US | Ohio | Highland | 39071 | 12781 | 187 | 0 | 39.1839264 | -83.60331456 | 2022-11-24 04:21:09 | Highland, Ohio, US | |
3313853 | 3313853 | 2022-11-23 | US | Michigan | Barry | 26015 | 16366 | 187 | 0 | 42.59513984 | -85.30834519 | 2022-11-24 04:21:09 | Barry, Michigan, US | |
3312113 | 3312113 | 2022-11-23 | France | Mayotte | 40612 | 187 | 0 | -12.8275 | 45.166244 | 2022-11-24 04:21:09 | Mayotte, France | |||
1622753 | 1622753 | 2022-11-22 | US | Ohio | Highland | 39071 | 12745 | 187 | 0 | 39.1839264 | -83.60331456 | 2022-11-23 04:21:06 | Highland, Ohio, US | |
1621894 | 1621894 | 2022-11-22 | US | Michigan | Barry | 26015 | 16366 | 187 | 0 | 42.59513984 | -85.30834519 | 2022-11-23 04:21:06 | Barry, Michigan, US | |
1621085 | 1621085 | 2022-11-22 | US | Georgia | Gilmer | 13123 | 7897 | 187 | 0 | 34.69316688 | -84.45802506 | 2022-11-23 04:21:06 | Gilmer, Georgia, 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]);