johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,071 rows where confirmed = 198 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 21
- US 939
- China 85
- Japan 16
- Malaysia 5
- Australia 3
- Colombia 3
- France 3
- India 2
- Uganda 2
- Ukraine 2
- Antigua and Barbuda 1
- Cambodia 1
- Canada 1
- Netherlands 1
- New Zealand 1
- Peru 1
- Sri Lanka 1
- Summer Olympics 2020 1
- Syria 1
- United Arab Emirates 1
- United Kingdom 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1149084 | 1149084 | 2022-12-12 | New Zealand | Niue | 198 | 0 | 0 | -19.0544 | -169.8672 | 2022-12-13 04:21:01 | Niue, New Zealand | |||
1393467 | 1393467 | 2022-09-02 | China | Guizhou | 198 | 2 | 0 | 26.8154 | 106.8748 | 2022-09-03 04:21:04 | Guizhou, China | |||
1187908 | 1187908 | 2022-05-18 | US | Texas | Loving | 48301 | 198 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-05-19 04:20:54 | Loving, Texas, US | |
3585805 | 3585805 | 2022-05-17 | US | Texas | Loving | 48301 | 198 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-05-18 04:20:50 | Loving, Texas, US | |
3583081 | 3583081 | 2022-05-17 | US | Alaska | Skagway | 2230 | 198 | 0 | 0 | 59.56149996 | -135.3337748 | 2022-05-18 04:20:50 | Skagway, Alaska, US | |
1504038 | 1504038 | 2022-05-16 | US | Alaska | Skagway | 2230 | 198 | 0 | 0 | 59.56149996 | -135.3337748 | 2022-05-17 04:20:59 | Skagway, Alaska, US | |
2084397 | 2084397 | 2022-05-15 | US | Alaska | Skagway | 2230 | 198 | 0 | 0 | 59.56149996 | -135.3337748 | 2022-05-16 04:20:47 | Skagway, Alaska, US | |
3355107 | 3355107 | 2022-05-14 | US | Alaska | Skagway | 2230 | 198 | 0 | 0 | 59.56149996 | -135.3337748 | 2022-05-15 04:20:53 | Skagway, Alaska, US | |
658752 | 658752 | 2022-05-13 | US | Alaska | Skagway | 2230 | 198 | 0 | 0 | 59.56149996 | -135.3337748 | 2022-05-14 04:20:48 | Skagway, Alaska, US | |
2533835 | 2533835 | 2022-05-12 | US | Alaska | Skagway | 2230 | 198 | 0 | 0 | 59.56149996 | -135.3337748 | 2022-05-13 04:20:51 | Skagway, Alaska, US | |
3447581 | 3447581 | 2022-05-11 | US | Puerto Rico | Culebra | 72049 | 198 | 0 | 0 | 18.31586 | -65.28813 | 2022-05-12 04:20:54 | Culebra, Puerto Rico, US | |
3445281 | 3445281 | 2022-05-11 | US | Alaska | Skagway | 2230 | 198 | 0 | 0 | 59.56149996 | -135.3337748 | 2022-05-12 04:20:54 | Skagway, Alaska, US | |
3025372 | 3025372 | 2022-03-23 | US | Texas | Glasscock | 48173 | 198 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-03-24 04:20:43 | Glasscock, Texas, US | |
2202729 | 2202729 | 2022-03-06 | US | Texas | Foard | 48155 | 198 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-03-07 04:20:47 | Foard, Texas, US | |
2200296 | 2200296 | 2022-03-06 | US | Colorado | San Juan | 8111 | 198 | 0 | 0 | 37.76248981 | -107.67632890000002 | 2022-03-07 04:20:47 | San Juan, Colorado, US | |
2095186 | 2095186 | 2022-03-05 | US | Texas | Foard | 48155 | 198 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-03-06 04:20:49 | Foard, Texas, US | |
2092753 | 2092753 | 2022-03-05 | US | Colorado | San Juan | 8111 | 198 | 0 | 0 | 37.76248981 | -107.67632890000002 | 2022-03-06 04:20:49 | San Juan, Colorado, US | |
2668886 | 2668886 | 2022-03-04 | US | Texas | Foard | 48155 | 198 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-03-05 04:21:10 | Foard, Texas, US | |
2666453 | 2666453 | 2022-03-04 | US | Colorado | San Juan | 8111 | 198 | 0 | 0 | 37.76248981 | -107.67632890000002 | 2022-03-05 04:21:10 | San Juan, Colorado, US | |
1647451 | 1647451 | 2022-03-03 | US | Texas | Foard | 48155 | 198 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-03-04 04:21:09 | Foard, Texas, US | |
2528454 | 2528454 | 2022-03-02 | US | Texas | Foard | 48155 | 198 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-03-03 04:21:01 | Foard, Texas, US | |
1995748 | 1995748 | 2022-03-01 | US | Texas | Foard | 48155 | 198 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-03-02 04:21:07 | Foard, Texas, US | |
945922 | 945922 | 2022-02-28 | US | Texas | Foard | 48155 | 198 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-03-01 04:21:09 | Foard, Texas, US | |
2736113 | 2736113 | 2022-02-27 | US | Texas | Foard | 48155 | 198 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-02-28 04:21:05 | Foard, Texas, US | |
3049266 | 3049266 | 2022-02-26 | US | Texas | Foard | 48155 | 198 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-02-27 04:21:04 | Foard, Texas, US | |
577921 | 577921 | 2022-02-25 | US | Texas | Foard | 48155 | 198 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-02-26 04:21:12 | Foard, Texas, US | |
1514497 | 1514497 | 2022-02-24 | US | Texas | Foard | 48155 | 198 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-02-25 04:21:11 | Foard, Texas, US | |
1060938 | 1060938 | 2022-02-23 | US | Texas | Foard | 48155 | 198 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-02-24 04:21:14 | Foard, Texas, US | |
2449861 | 2449861 | 2022-02-22 | US | Texas | Foard | 48155 | 198 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-02-23 04:21:09 | Foard, Texas, US | |
3721274 | 3721274 | 2022-02-21 | US | Texas | Foard | 48155 | 198 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-02-22 04:21:01 | Foard, Texas, US | |
3915108 | 3915108 | 2022-02-20 | US | Texas | Foard | 48155 | 198 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-02-21 04:21:05 | Foard, Texas, US | |
3878666 | 3878666 | 2022-02-19 | US | Texas | Foard | 48155 | 198 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-02-20 04:21:00 | Foard, Texas, US | |
3858922 | 3858922 | 2022-02-18 | US | Texas | Foard | 48155 | 198 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-02-19 04:21:11 | Foard, Texas, US | |
1301141 | 1301141 | 2022-02-17 | US | Texas | Foard | 48155 | 198 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-02-18 04:21:04 | Foard, Texas, US | |
3823527 | 3823527 | 2022-02-16 | US | Texas | Foard | 48155 | 198 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-02-17 04:20:56 | Foard, Texas, US | |
3674741 | 3674741 | 2022-02-15 | US | Texas | Foard | 48155 | 198 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-02-16 04:21:10 | Foard, Texas, US | |
2644842 | 2644842 | 2022-02-14 | US | Texas | Foard | 48155 | 198 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-02-15 04:21:09 | Foard, Texas, US | |
189159 | 189159 | 2022-02-13 | US | Texas | Foard | 48155 | 198 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-02-14 04:20:51 | Foard, Texas, US | |
319005 | 319005 | 2022-02-12 | US | Texas | Foard | 48155 | 198 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-02-13 04:21:00 | Foard, Texas, US | |
236331 | 236331 | 2022-02-11 | US | Texas | Foard | 48155 | 198 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-02-12 04:21:06 | Foard, Texas, US | |
1467173 | 1467173 | 2022-02-10 | US | Texas | Foard | 48155 | 198 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-02-11 04:21:09 | Foard, Texas, US | |
3077134 | 3077134 | 2022-02-09 | US | Texas | Foard | 48155 | 198 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-02-10 04:21:14 | Foard, Texas, US | |
1365495 | 1365495 | 2022-02-08 | US | Texas | Kent | 48263 | 198 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-02-09 04:21:04 | Kent, Texas, US | |
74233 | 74233 | 2022-02-07 | US | Texas | Kent | 48263 | 198 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-02-08 04:21:15 | Kent, Texas, US | |
981826 | 981826 | 2022-02-01 | US | South Dakota | Harding | 46063 | 198 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-02-02 04:21:09 | Harding, South Dakota, US | |
2660668 | 2660668 | 2022-01-31 | US | South Dakota | Harding | 46063 | 198 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-02-01 04:21:11 | Harding, South Dakota, US | |
2658843 | 2658843 | 2022-01-31 | US | Illinois | Unassigned | 90017 | 198 | 3751 | 0 | 42.36542373 | 0.0 | 2022-02-01 04:21:11 | Unassigned, Illinois, US | |
2053889 | 2053889 | 2022-01-25 | US | Montana | Judith Basin | 30045 | 198 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-01-26 04:21:07 | Judith Basin, Montana, US | |
3228452 | 3228452 | 2022-01-19 | US | Montana | Garfield | 30033 | 198 | 3 | 0 | 47.27545948 | -107.0002351 | 2022-01-20 04:21:07 | Garfield, Montana, US | |
3613943 | 3613943 | 2022-01-12 | US | Georgia | Taliaferro | 13265 | 198 | 3 | 0 | 33.56543317 | -82.88136816 | 2022-01-13 08:00:09 | Taliaferro, Georgia, US | |
1694129 | 1694129 | 2022-01-10 | US | Mississippi | Issaquena | 28055 | 198 | 7 | 0 | 32.72531359 | -90.97392828 | 2022-01-11 04:22:01 | Issaquena, Mississippi, US | |
128544 | 128544 | 2022-01-09 | US | Mississippi | Issaquena | 28055 | 198 | 7 | 0 | 32.72531359 | -90.97392828 | 2022-01-10 04:22:07 | Issaquena, Mississippi, US | |
1217379 | 1217379 | 2022-01-08 | US | Mississippi | Issaquena | 28055 | 198 | 7 | 0 | 32.72531359 | -90.97392828 | 2022-01-09 04:21:46 | Issaquena, Mississippi, US | |
1391472 | 1391472 | 2022-01-07 | US | Mississippi | Issaquena | 28055 | 198 | 7 | 0 | 32.72531359 | -90.97392828 | 2022-01-08 04:21:53 | Issaquena, Mississippi, US | |
2611859 | 2611859 | 2022-01-06 | US | Mississippi | Issaquena | 28055 | 198 | 7 | 0 | 32.72531359 | -90.97392828 | 2022-01-07 04:22:09 | Issaquena, Mississippi, US | |
1671093 | 1671093 | 2021-12-29 | US | Oregon | Sherman | 41055 | 198 | 3 | 0 | 45.41501554 | -120.6827834 | 2021-12-30 04:21:25 | Sherman, Oregon, US | |
1669510 | 1669510 | 2021-12-29 | US | Illinois | Unassigned | 90017 | 198 | 3167 | 0 | 42.36542373 | 0.0 | 2021-12-30 04:21:25 | Unassigned, Illinois, US | |
1435202 | 1435202 | 2021-12-28 | US | Oregon | Sherman | 41055 | 198 | 3 | 0 | 45.41501554 | -120.6827834 | 2021-12-29 03:21:43 | Sherman, Oregon, US | |
733163 | 733163 | 2021-12-27 | US | Oregon | Sherman | 41055 | 198 | 3 | 0 | 45.41501554 | -120.6827834 | 2021-12-28 04:21:47 | Sherman, Oregon, US | |
2114335 | 2114335 | 2021-12-26 | US | Oregon | Sherman | 41055 | 198 | 3 | 0 | 45.41501554 | -120.6827834 | 2021-12-27 04:21:58 | Sherman, Oregon, US | |
3607707 | 3607707 | 2021-12-25 | US | Oregon | Sherman | 41055 | 198 | 3 | 0 | 45.41501554 | -120.6827834 | 2021-12-26 04:21:50 | Sherman, Oregon, US | |
2966025 | 2966025 | 2021-12-24 | US | Oregon | Sherman | 41055 | 198 | 3 | 0 | 45.41501554 | -120.6827834 | 2021-12-25 04:21:37 | Sherman, Oregon, US | |
3819057 | 3819057 | 2021-12-23 | US | Oregon | Sherman | 41055 | 198 | 3 | 0 | 45.41501554 | -120.6827834 | 2021-12-24 04:21:34 | Sherman, Oregon, US | |
1257678 | 1257678 | 2021-12-20 | US | South Dakota | Sully | 46119 | 198 | 3 | 0 | 44.71571812 | -100.1278092 | 2021-12-21 03:21:27 | Sully, South Dakota, US | |
2906621 | 2906621 | 2021-12-19 | US | South Dakota | Sully | 46119 | 198 | 3 | 0 | 44.71571812 | -100.1278092 | 2021-12-20 04:21:43 | Sully, South Dakota, US | |
1261694 | 1261694 | 2021-12-18 | US | South Dakota | Sully | 46119 | 198 | 3 | 0 | 44.71571812 | -100.1278092 | 2021-12-19 04:21:11 | Sully, South Dakota, US | |
2401722 | 2401722 | 2021-12-17 | US | South Dakota | Sully | 46119 | 198 | 3 | 0 | 44.71571812 | -100.1278092 | 2021-12-18 02:22:20 | Sully, South Dakota, US | |
554130 | 554130 | 2021-12-08 | US | Virginia | Highland | 51091 | 198 | 4 | 0 | 38.35799465 | -79.56124594 | 2021-12-09 04:22:49 | Highland, Virginia, US | |
407650 | 407650 | 2021-12-07 | US | Virginia | Highland | 51091 | 198 | 4 | 0 | 38.35799465 | -79.56124594 | 2021-12-08 04:22:46 | Highland, Virginia, US | |
3404573 | 3404573 | 2021-11-30 | US | Texas | Jeff Davis | 48243 | 198 | 6 | 0 | 30.71490589 | -104.1399973 | 2021-12-01 04:22:29 | Jeff Davis, Texas, US | |
3402749 | 3402749 | 2021-11-30 | US | Kansas | Lane | 20101 | 198 | 8 | 0 | 38.48119447 | -100.46607540000001 | 2021-12-01 04:22:29 | Lane, Kansas, US | |
153116 | 153116 | 2021-11-29 | US | Texas | Jeff Davis | 48243 | 198 | 6 | 0 | 30.71490589 | -104.1399973 | 2021-11-30 04:22:53 | Jeff Davis, Texas, US | |
151292 | 151292 | 2021-11-29 | US | Kansas | Lane | 20101 | 198 | 8 | 0 | 38.48119447 | -100.46607540000001 | 2021-11-30 04:22:53 | Lane, Kansas, US | |
1234762 | 1234762 | 2021-11-28 | US | Texas | Jeff Davis | 48243 | 198 | 6 | 0 | 30.71490589 | -104.1399973 | 2021-11-29 04:22:30 | Jeff Davis, Texas, US | |
1361469 | 1361469 | 2021-11-27 | US | Texas | Jeff Davis | 48243 | 198 | 6 | 0 | 30.71490589 | -104.1399973 | 2021-11-28 04:22:43 | Jeff Davis, Texas, US | |
761460 | 761460 | 2021-11-26 | US | Texas | Jeff Davis | 48243 | 198 | 6 | 0 | 30.71490589 | -104.1399973 | 2021-11-27 04:22:45 | Jeff Davis, Texas, US | |
1805877 | 1805877 | 2021-11-25 | US | Texas | Jeff Davis | 48243 | 198 | 6 | 0 | 30.71490589 | -104.1399973 | 2021-11-26 04:22:33 | Jeff Davis, Texas, US | |
907311 | 907311 | 2021-11-24 | US | Texas | Jeff Davis | 48243 | 198 | 6 | 0 | 30.71490589 | -104.1399973 | 2021-11-25 04:22:33 | Jeff Davis, Texas, US | |
3073161 | 3073161 | 2021-11-23 | US | Texas | Jeff Davis | 48243 | 198 | 6 | 0 | 30.71490589 | -104.1399973 | 2021-11-24 04:22:14 | Jeff Davis, Texas, US | |
3752259 | 3752259 | 2021-11-22 | US | Texas | Jeff Davis | 48243 | 198 | 6 | 0 | 30.71490589 | -104.1399973 | 2021-11-23 04:22:39 | Jeff Davis, Texas, US | |
1017466 | 1017466 | 2021-11-21 | US | Texas | Jeff Davis | 48243 | 198 | 6 | 0 | 30.71490589 | -104.1399973 | 2021-11-22 04:22:20 | Jeff Davis, Texas, US | |
725630 | 725630 | 2021-11-20 | US | Texas | Jeff Davis | 48243 | 198 | 6 | 0 | 30.71490589 | -104.1399973 | 2021-11-21 04:22:13 | Jeff Davis, Texas, US | |
165160 | 165160 | 2021-11-19 | US | Texas | Jeff Davis | 48243 | 198 | 6 | 0 | 30.71490589 | -104.1399973 | 2021-11-20 04:22:17 | Jeff Davis, Texas, US | |
3292047 | 3292047 | 2021-11-18 | US | Texas | Jeff Davis | 48243 | 198 | 6 | 0 | 30.71490589 | -104.1399973 | 2021-11-19 04:21:40 | Jeff Davis, Texas, US | |
450503 | 450503 | 2021-11-17 | US | Texas | Jeff Davis | 48243 | 198 | 6 | 0 | 30.71490589 | -104.1399973 | 2021-11-18 04:21:33 | Jeff Davis, Texas, US | |
3345753 | 3345753 | 2021-11-16 | US | Texas | Jeff Davis | 48243 | 198 | 6 | 0 | 30.71490589 | -104.1399973 | 2021-11-17 04:21:48 | Jeff Davis, Texas, US | |
2290589 | 2290589 | 2021-11-15 | US | Texas | Jeff Davis | 48243 | 198 | 6 | 0 | 30.71490589 | -104.1399973 | 2021-11-16 04:21:10 | Jeff Davis, Texas, US | |
1325363 | 1325363 | 2021-11-14 | US | Texas | Jeff Davis | 48243 | 198 | 6 | 0 | 30.71490589 | -104.1399973 | 2021-11-15 04:21:36 | Jeff Davis, Texas, US | |
689489 | 689489 | 2021-11-13 | US | Texas | Jeff Davis | 48243 | 198 | 6 | 0 | 30.71490589 | -104.1399973 | 2021-11-14 04:21:31 | Jeff Davis, Texas, US | |
717598 | 717598 | 2021-11-12 | US | Texas | Jeff Davis | 48243 | 198 | 6 | 0 | 30.71490589 | -104.1399973 | 2021-11-13 04:21:38 | Jeff Davis, Texas, US | |
31548 | 31548 | 2021-11-11 | US | Texas | Jeff Davis | 48243 | 198 | 6 | 0 | 30.71490589 | -104.1399973 | 2021-11-12 04:22:01 | Jeff Davis, Texas, US | |
31296 | 31296 | 2021-11-11 | US | South Dakota | Hyde | 46069 | 198 | 4 | 0 | 44.54747703 | -99.48572582 | 2021-11-12 04:22:01 | Hyde, South Dakota, US | |
2847987 | 2847987 | 2021-11-10 | US | Texas | Jeff Davis | 48243 | 198 | 6 | 0 | 30.71490589 | -104.1399973 | 2021-11-11 04:21:45 | Jeff Davis, Texas, US | |
2847735 | 2847735 | 2021-11-10 | US | South Dakota | Hyde | 46069 | 198 | 4 | 0 | 44.54747703 | -99.48572582 | 2021-11-11 04:21:45 | Hyde, South Dakota, US | |
498784 | 498784 | 2021-11-06 | US | Texas | Jeff Davis | 48243 | 198 | 6 | 0 | 30.71490589 | -104.1399973 | 2021-11-07 04:21:53 | Jeff Davis, Texas, US | |
496259 | 496259 | 2021-11-06 | US | Colorado | Cheyenne | 8017 | 198 | 7 | 0 | 38.82777431 | -102.6032558 | 2021-11-07 04:21:53 | Cheyenne, Colorado, US | |
3123933 | 3123933 | 2021-11-05 | US | North Dakota | Sheridan | 38083 | 198 | 3 | 0 | 47.57700669 | -100.3426391 | 2021-11-06 04:21:51 | Sheridan, North Dakota, US | |
45783 | 45783 | 2021-11-02 | US | Nebraska | Garden | 31069 | 198 | 1 | 0 | 41.61703149 | -102.3313973 | 2021-11-03 06:22:09 | Garden, Nebraska, US | |
3513479 | 3513479 | 2021-11-01 | US | Nebraska | Garden | 31069 | 198 | 1 | 0 | 41.61703149 | -102.3313973 | 2021-11-02 04:22:03 | Garden, Nebraska, US | |
290070 | 290070 | 2021-10-31 | US | Nebraska | Garden | 31069 | 198 | 1 | 0 | 41.61703149 | -102.3313973 | 2021-11-01 04:22:01 | Garden, Nebraska, 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]);