johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
999 rows where confirmed = 218 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 25
- US 941
- China 13
- Japan 10
- Dominica 7
- Malaysia 4
- Antigua and Barbuda 2
- Colombia 2
- Ukraine 2
- United Kingdom 2
- Australia 1
- Bangladesh 1
- Barbados 1
- Bulgaria 1
- Cabo Verde 1
- Chile 1
- Cote d'Ivoire 1
- El Salvador 1
- France 1
- Georgia 1
- Mainland China 1
- Monaco 1
- Others 1
- Russia 1
- San Marino 1
- Vietnam 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755785 | 2755785 | 2022-12-29 | US | South Dakota | Harding | 46063 | 218 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-12-30 04:21:04 | Harding, South Dakota, US | |
1076791 | 1076791 | 2022-12-28 | US | South Dakota | Harding | 46063 | 218 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-12-29 04:21:01 | Harding, South Dakota, US | |
330788 | 330788 | 2022-12-27 | US | South Dakota | Harding | 46063 | 218 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-12-28 04:21:04 | Harding, South Dakota, US | |
220861 | 220861 | 2022-12-26 | US | South Dakota | Harding | 46063 | 218 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-12-27 04:21:07 | Harding, South Dakota, US | |
3225318 | 3225318 | 2022-12-25 | US | South Dakota | Harding | 46063 | 218 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-12-26 04:21:06 | Harding, South Dakota, US | |
1021232 | 1021232 | 2022-12-24 | US | South Dakota | Harding | 46063 | 218 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-12-25 04:21:04 | Harding, South Dakota, US | |
693255 | 693255 | 2022-12-23 | US | South Dakota | Harding | 46063 | 218 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-12-24 04:21:02 | Harding, South Dakota, US | |
2182465 | 2182465 | 2022-12-22 | US | South Dakota | Harding | 46063 | 218 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-12-23 04:21:04 | Harding, South Dakota, US | |
454269 | 454269 | 2022-12-21 | US | South Dakota | Harding | 46063 | 218 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-12-22 04:20:56 | Harding, South Dakota, US | |
2954268 | 2954268 | 2022-12-20 | US | South Dakota | Harding | 46063 | 218 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-12-21 04:21:03 | Harding, South Dakota, US | |
3176670 | 3176670 | 2022-12-19 | US | South Dakota | Harding | 46063 | 218 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-12-20 04:21:04 | Harding, South Dakota, US | |
1631187 | 1631187 | 2022-12-18 | US | South Dakota | Harding | 46063 | 218 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-12-19 04:21:03 | Harding, South Dakota, US | |
506566 | 506566 | 2022-12-17 | US | South Dakota | Harding | 46063 | 218 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-12-18 04:21:03 | Harding, South Dakota, US | |
3327138 | 3327138 | 2022-12-16 | US | South Dakota | Harding | 46063 | 218 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-12-17 04:21:04 | Harding, South Dakota, US | |
545650 | 545650 | 2022-12-15 | US | South Dakota | Harding | 46063 | 218 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-12-16 04:21:01 | Harding, South Dakota, US | |
351178 | 351178 | 2022-12-14 | US | South Dakota | Harding | 46063 | 218 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-12-15 04:20:58 | Harding, South Dakota, US | |
310766 | 310766 | 2022-12-13 | US | South Dakota | Harding | 46063 | 218 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-12-14 04:21:04 | Harding, South Dakota, US | |
1151827 | 1151827 | 2022-12-12 | US | South Dakota | Harding | 46063 | 218 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-12-13 04:21:01 | Harding, South Dakota, US | |
871681 | 871681 | 2022-12-11 | US | South Dakota | Harding | 46063 | 218 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-12-12 04:21:01 | Harding, South Dakota, US | |
260211 | 260211 | 2022-12-10 | US | South Dakota | Harding | 46063 | 218 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-12-11 04:20:50 | Harding, South Dakota, US | |
3938925 | 3938925 | 2022-12-09 | US | South Dakota | Harding | 46063 | 218 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-12-10 04:21:02 | Harding, South Dakota, US | |
3380257 | 3380257 | 2022-12-08 | US | South Dakota | Harding | 46063 | 218 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-12-09 04:21:05 | Harding, South Dakota, US | |
1987528 | 1987528 | 2022-12-07 | US | South Dakota | Harding | 46063 | 218 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-12-08 04:21:07 | Harding, South Dakota, US | |
3717051 | 3717051 | 2022-12-06 | US | South Dakota | Harding | 46063 | 218 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-12-07 04:20:58 | Harding, South Dakota, US | |
2417756 | 2417756 | 2022-12-05 | US | South Dakota | Harding | 46063 | 218 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-12-06 04:21:03 | Harding, South Dakota, US | |
721364 | 721364 | 2022-12-04 | US | South Dakota | Harding | 46063 | 218 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-12-05 04:20:58 | Harding, South Dakota, US | |
2819653 | 2819653 | 2022-12-03 | US | South Dakota | Harding | 46063 | 218 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-12-04 04:20:56 | Harding, South Dakota, US | |
836509 | 836509 | 2022-12-02 | US | South Dakota | Harding | 46063 | 218 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-12-03 04:21:02 | Harding, South Dakota, US | |
2139039 | 2139039 | 2022-12-01 | US | South Dakota | Harding | 46063 | 218 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-12-02 04:21:07 | Harding, South Dakota, US | |
1967455 | 1967455 | 2022-11-30 | US | South Dakota | Harding | 46063 | 218 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-12-01 04:21:03 | Harding, South Dakota, US | |
2532528 | 2532528 | 2022-10-06 | US | Texas | Kent | 48263 | 218 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-10-07 04:23:08 | Kent, Texas, US | |
1813922 | 1813922 | 2022-10-05 | US | Texas | Kent | 48263 | 218 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-10-06 04:21:22 | Kent, Texas, US | |
133896 | 133896 | 2022-10-04 | US | Texas | Kent | 48263 | 218 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-10-05 04:23:06 | Kent, Texas, US | |
2688843 | 2688843 | 2022-10-03 | US | Texas | Kent | 48263 | 218 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-10-04 04:22:55 | Kent, Texas, US | |
1977866 | 1977866 | 2022-09-25 | US | Iowa | Unassigned | 90019 | 218 | 0 | 0 | 43.38107862 | 0.0 | 2022-09-26 04:20:52 | Unassigned, Iowa, US | |
2651033 | 2651033 | 2022-09-24 | US | Iowa | Unassigned | 90019 | 218 | 0 | 0 | 43.38107862 | 0.0 | 2022-09-25 04:23:31 | Unassigned, Iowa, US | |
385473 | 385473 | 2022-09-23 | US | Iowa | Unassigned | 90019 | 218 | 0 | 0 | 43.38107862 | 0.0 | 2022-09-24 04:21:40 | Unassigned, Iowa, US | |
1625539 | 1625539 | 2022-09-22 | US | Iowa | Unassigned | 90019 | 218 | 0 | 0 | 43.38107862 | 0.0 | 2022-09-23 04:23:13 | Unassigned, Iowa, US | |
962701 | 962701 | 2022-09-09 | China | Guizhou | 218 | 2 | 0 | 26.8154 | 106.8748 | 2022-09-10 04:21:10 | Guizhou, China | |||
2633528 | 2633528 | 2022-09-05 | China | Qinghai | 218 | 0 | 0 | 35.7452 | 95.9956 | 2022-09-06 04:21:02 | Qinghai, China | |||
2830856 | 2830856 | 2022-08-25 | US | Montana | Wibaux | 30109 | 218 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-08-26 04:21:02 | Wibaux, Montana, US | |
2325389 | 2325389 | 2022-08-24 | US | Montana | Wibaux | 30109 | 218 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-08-25 04:21:13 | Wibaux, Montana, US | |
1252798 | 1252798 | 2022-08-23 | US | Montana | Wibaux | 30109 | 218 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-08-24 04:20:46 | Wibaux, Montana, US | |
2854902 | 2854902 | 2022-08-22 | US | Montana | Wibaux | 30109 | 218 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-08-23 04:20:56 | Wibaux, Montana, US | |
2405932 | 2405932 | 2022-08-21 | US | Texas | Glasscock | 48173 | 218 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-08-22 04:20:38 | Glasscock, Texas, US | |
2404874 | 2404874 | 2022-08-21 | US | Montana | Wibaux | 30109 | 218 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-08-22 04:20:38 | Wibaux, Montana, US | |
3801010 | 3801010 | 2022-08-20 | US | Texas | Glasscock | 48173 | 218 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-08-21 04:20:44 | Glasscock, Texas, US | |
3799952 | 3799952 | 2022-08-20 | US | Montana | Wibaux | 30109 | 218 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-08-21 04:20:44 | Wibaux, Montana, US | |
2366596 | 2366596 | 2022-08-19 | US | Texas | Glasscock | 48173 | 218 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-08-20 04:21:01 | Glasscock, Texas, US | |
2365538 | 2365538 | 2022-08-19 | US | Montana | Wibaux | 30109 | 218 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-08-20 04:21:01 | Wibaux, Montana, US | |
1164267 | 1164267 | 2022-08-18 | US | Texas | Glasscock | 48173 | 218 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-08-19 04:20:54 | Glasscock, Texas, US | |
3953591 | 3953591 | 2022-08-17 | US | Texas | Glasscock | 48173 | 218 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-08-18 04:21:11 | Glasscock, Texas, US | |
994093 | 994093 | 2022-08-16 | US | Texas | Glasscock | 48173 | 218 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-08-17 04:20:59 | Glasscock, Texas, US | |
2497132 | 2497132 | 2022-08-15 | US | Texas | Glasscock | 48173 | 218 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-08-16 04:20:58 | Glasscock, Texas, US | |
3650682 | 3650682 | 2022-08-14 | US | Texas | Glasscock | 48173 | 218 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-08-15 04:20:59 | Glasscock, Texas, US | |
1971688 | 1971688 | 2022-08-13 | US | Texas | Glasscock | 48173 | 218 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-08-14 04:20:55 | Glasscock, Texas, US | |
2891497 | 2891497 | 2022-08-12 | US | Texas | Glasscock | 48173 | 218 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-08-13 04:20:52 | Glasscock, Texas, US | |
3911102 | 3911102 | 2022-08-11 | US | Texas | Glasscock | 48173 | 218 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-08-12 04:20:54 | Glasscock, Texas, US | |
1349419 | 1349419 | 2022-08-10 | US | Texas | Glasscock | 48173 | 218 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-08-11 04:20:49 | Glasscock, Texas, US | |
1089174 | 1089174 | 2022-08-09 | US | Texas | Glasscock | 48173 | 218 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-08-10 04:20:57 | Glasscock, Texas, US | |
3546589 | 3546589 | 2022-08-08 | US | Texas | Glasscock | 48173 | 218 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-08-09 04:20:34 | Glasscock, Texas, US | |
1072992 | 1072992 | 2022-08-07 | US | Texas | Glasscock | 48173 | 218 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-08-08 04:21:08 | Glasscock, Texas, US | |
1943580 | 1943580 | 2022-08-06 | US | Texas | Glasscock | 48173 | 218 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-08-07 04:20:54 | Glasscock, Texas, US | |
883379 | 883379 | 2022-08-05 | US | Texas | Glasscock | 48173 | 218 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-08-06 04:20:56 | Glasscock, Texas, US | |
2744102 | 2744102 | 2022-07-07 | US | Texas | Foard | 48155 | 218 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-07-08 04:20:56 | Foard, Texas, US | |
1202897 | 1202897 | 2022-07-06 | US | Texas | Foard | 48155 | 218 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-07-07 04:20:55 | Foard, Texas, US | |
3969640 | 3969640 | 2022-07-05 | US | Texas | Foard | 48155 | 218 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-07-06 04:20:58 | Foard, Texas, US | |
3081151 | 3081151 | 2022-07-04 | US | Texas | Foard | 48155 | 218 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-07-05 04:20:45 | Foard, Texas, US | |
1770433 | 1770433 | 2022-07-03 | US | Texas | Foard | 48155 | 218 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-07-04 04:20:54 | Foard, Texas, US | |
3368419 | 3368419 | 2022-07-02 | US | Texas | Foard | 48155 | 218 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-07-03 04:20:59 | Foard, Texas, US | |
596748 | 596748 | 2022-07-01 | US | Texas | Foard | 48155 | 218 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-07-02 04:21:16 | Foard, Texas, US | |
3272676 | 3272676 | 2022-06-19 | US | Texas | Loving | 48301 | 218 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-06-20 04:21:01 | Loving, Texas, US | |
3400588 | 3400588 | 2022-06-18 | US | Texas | Loving | 48301 | 218 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-06-19 04:20:51 | Loving, Texas, US | |
2314465 | 2314465 | 2022-06-17 | US | Texas | Loving | 48301 | 218 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-06-18 04:21:10 | Loving, Texas, US | |
1506338 | 1506338 | 2022-05-16 | US | Puerto Rico | Culebra | 72049 | 218 | 0 | 0 | 18.31586 | -65.28813 | 2022-05-17 04:20:59 | Culebra, Puerto Rico, US | |
3720192 | 3720192 | 2022-02-21 | US | Montana | Judith Basin | 30045 | 218 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-02-22 04:21:01 | Judith Basin, Montana, US | |
3914026 | 3914026 | 2022-02-20 | US | Montana | Judith Basin | 30045 | 218 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-02-21 04:21:05 | Judith Basin, Montana, US | |
3877584 | 3877584 | 2022-02-19 | US | Montana | Judith Basin | 30045 | 218 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-02-20 04:21:00 | Judith Basin, Montana, US | |
3857840 | 3857840 | 2022-02-18 | US | Montana | Judith Basin | 30045 | 218 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-02-19 04:21:11 | Judith Basin, Montana, US | |
1300059 | 1300059 | 2022-02-17 | US | Montana | Judith Basin | 30045 | 218 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-02-18 04:21:04 | Judith Basin, Montana, US | |
3674785 | 3674785 | 2022-02-15 | US | Texas | Jeff Davis | 48243 | 218 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-02-16 04:21:10 | Jeff Davis, Texas, US | |
2644886 | 2644886 | 2022-02-14 | US | Texas | Jeff Davis | 48243 | 218 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-02-15 04:21:09 | Jeff Davis, Texas, US | |
189203 | 189203 | 2022-02-13 | US | Texas | Jeff Davis | 48243 | 218 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-02-14 04:20:51 | Jeff Davis, Texas, US | |
319049 | 319049 | 2022-02-12 | US | Texas | Jeff Davis | 48243 | 218 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-02-13 04:21:00 | Jeff Davis, Texas, US | |
236375 | 236375 | 2022-02-11 | US | Texas | Jeff Davis | 48243 | 218 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-02-12 04:21:06 | Jeff Davis, Texas, US | |
1467217 | 1467217 | 2022-02-10 | US | Texas | Jeff Davis | 48243 | 218 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-02-11 04:21:09 | Jeff Davis, Texas, US | |
3077178 | 3077178 | 2022-02-09 | US | Texas | Jeff Davis | 48243 | 218 | 8 | 0 | 30.71490589 | -104.1399973 | 2022-02-10 04:21:14 | Jeff Davis, Texas, US | |
3301260 | 3301260 | 2022-01-30 | US | Illinois | Unassigned | 90017 | 218 | 3751 | 0 | 42.36542373 | 0.0 | 2022-01-31 04:21:09 | Unassigned, Illinois, US | |
3063051 | 3063051 | 2022-01-29 | US | Illinois | Unassigned | 90017 | 218 | 3751 | 0 | 42.36542373 | 0.0 | 2022-01-30 04:21:26 | Unassigned, Illinois, US | |
3810985 | 3810985 | 2022-01-28 | US | Illinois | Unassigned | 90017 | 218 | 3730 | 0 | 42.36542373 | 0.0 | 2022-01-29 04:21:10 | Unassigned, Illinois, US | |
1141791 | 1141791 | 2022-01-23 | US | Georgia | Taliaferro | 13265 | 218 | 3 | 0 | 33.56543317 | -82.88136816 | 2022-01-24 04:21:12 | Taliaferro, Georgia, US | |
2833709 | 2833709 | 2022-01-22 | US | Georgia | Taliaferro | 13265 | 218 | 3 | 0 | 33.56543317 | -82.88136816 | 2022-01-23 04:21:13 | Taliaferro, Georgia, US | |
3425827 | 3425827 | 2022-01-21 | US | Georgia | Taliaferro | 13265 | 218 | 3 | 0 | 33.56543317 | -82.88136816 | 2022-01-22 04:21:13 | Taliaferro, Georgia, US | |
3228441 | 3228441 | 2022-01-19 | US | Montana | Carter | 30011 | 218 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2022-01-20 04:21:07 | Carter, Montana, US | |
3228263 | 3228263 | 2022-01-19 | US | Mississippi | Issaquena | 28055 | 218 | 7 | 0 | 32.72531359 | -90.97392828 | 2022-01-20 04:21:07 | Issaquena, Mississippi, US | |
3466166 | 3466166 | 2022-01-18 | US | Montana | Carter | 30011 | 218 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2022-01-19 04:21:23 | Carter, Montana, US | |
3465229 | 3465229 | 2022-01-18 | US | Illinois | Unassigned | 90017 | 218 | 3433 | 0 | 42.36542373 | 0.0 | 2022-01-19 04:21:23 | Unassigned, Illinois, US | |
1474105 | 1474105 | 2022-01-17 | US | Montana | Carter | 30011 | 218 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2022-01-18 04:21:04 | Carter, Montana, US | |
556779 | 556779 | 2022-01-16 | US | Montana | Carter | 30011 | 218 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2022-01-17 04:21:08 | Carter, Montana, US | |
3842500 | 3842500 | 2022-01-15 | US | Montana | Carter | 30011 | 218 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2022-01-16 04:21:12 | Carter, Montana, 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]);