johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,034 rows where confirmed = 208 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3214102 | 3214102 | 2022-10-12 | China | Ningxia | 208 | 0 | 0 | 37.2692 | 106.1655 | 2022-10-13 04:22:39 | Ningxia, China | |||
672340 | 672340 | 2022-07-21 | US | Montana | Wibaux | 30109 | 208 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-07-22 04:21:15 | Wibaux, Montana, US | |
1610303 | 1610303 | 2022-07-20 | US | Montana | Wibaux | 30109 | 208 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-07-21 04:21:10 | Wibaux, Montana, US | |
960936 | 960936 | 2022-07-19 | US | Montana | Wibaux | 30109 | 208 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-07-20 04:20:59 | Wibaux, Montana, US | |
3212323 | 3212323 | 2022-07-18 | US | Montana | Wibaux | 30109 | 208 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-07-19 04:20:58 | Wibaux, Montana, US | |
3407498 | 3407498 | 2022-07-17 | US | Montana | Wibaux | 30109 | 208 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-07-18 04:20:59 | Wibaux, Montana, US | |
2153698 | 2153698 | 2022-07-16 | US | Montana | Wibaux | 30109 | 208 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-07-17 04:21:15 | Wibaux, Montana, US | |
2420931 | 2420931 | 2022-07-15 | US | Montana | Wibaux | 30109 | 208 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-07-16 04:21:05 | Wibaux, Montana, US | |
3431006 | 3431006 | 2022-07-14 | US | Montana | Wibaux | 30109 | 208 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-07-15 04:20:53 | Wibaux, Montana, US | |
3111526 | 3111526 | 2022-07-13 | US | Montana | Wibaux | 30109 | 208 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-07-14 04:20:57 | Wibaux, Montana, US | |
631949 | 631949 | 2022-07-12 | US | Montana | Wibaux | 30109 | 208 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-07-13 04:20:58 | Wibaux, Montana, US | |
1213593 | 1213593 | 2022-07-11 | US | Montana | Wibaux | 30109 | 208 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-07-12 04:20:51 | Wibaux, Montana, US | |
2791075 | 2791075 | 2022-07-10 | US | Montana | Wibaux | 30109 | 208 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-07-11 04:20:46 | Wibaux, Montana, US | |
144028 | 144028 | 2022-07-09 | US | Montana | Wibaux | 30109 | 208 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-07-10 04:20:54 | Wibaux, Montana, US | |
1419128 | 1419128 | 2022-07-08 | US | Montana | Wibaux | 30109 | 208 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-07-09 04:20:59 | Wibaux, Montana, US | |
2743053 | 2743053 | 2022-07-07 | US | Montana | Wibaux | 30109 | 208 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-07-08 04:20:56 | Wibaux, Montana, US | |
1201848 | 1201848 | 2022-07-06 | US | Montana | Wibaux | 30109 | 208 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-07-07 04:20:55 | Wibaux, Montana, US | |
3968591 | 3968591 | 2022-07-05 | US | Montana | Wibaux | 30109 | 208 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-07-06 04:20:58 | Wibaux, Montana, US | |
3080102 | 3080102 | 2022-07-04 | US | Montana | Wibaux | 30109 | 208 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-07-05 04:20:45 | Wibaux, Montana, US | |
1769384 | 1769384 | 2022-07-03 | US | Montana | Wibaux | 30109 | 208 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-07-04 04:20:54 | Wibaux, Montana, US | |
3367370 | 3367370 | 2022-07-02 | US | Montana | Wibaux | 30109 | 208 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-07-03 04:20:59 | Wibaux, Montana, US | |
595699 | 595699 | 2022-07-01 | US | Montana | Wibaux | 30109 | 208 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-07-02 04:21:16 | Wibaux, Montana, US | |
3942100 | 3942100 | 2022-06-30 | US | Montana | Wibaux | 30109 | 208 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-07-01 04:21:10 | Wibaux, Montana, US | |
2492058 | 2492058 | 2022-06-29 | US | Montana | Wibaux | 30109 | 208 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-06-30 04:21:01 | Wibaux, Montana, US | |
2241440 | 2241440 | 2022-06-28 | US | Montana | Wibaux | 30109 | 208 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-06-29 04:20:59 | Wibaux, Montana, US | |
2149682 | 2149682 | 2022-06-27 | US | Montana | Wibaux | 30109 | 208 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-06-28 04:20:58 | Wibaux, Montana, US | |
477483 | 477483 | 2022-06-26 | US | Montana | Wibaux | 30109 | 208 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-06-27 04:21:00 | Wibaux, Montana, US | |
940858 | 940858 | 2022-06-25 | US | Montana | Wibaux | 30109 | 208 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-06-26 04:21:02 | Wibaux, Montana, US | |
3348678 | 3348678 | 2022-06-24 | US | Montana | Wibaux | 30109 | 208 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-06-25 04:20:57 | Wibaux, Montana, US | |
1650419 | 1650419 | 2022-06-23 | US | Montana | Wibaux | 30109 | 208 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-06-24 04:20:58 | Wibaux, Montana, US | |
2189654 | 2189654 | 2022-06-22 | US | Montana | Wibaux | 30109 | 208 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-06-23 04:20:55 | Wibaux, Montana, US | |
168085 | 168085 | 2022-06-21 | US | Montana | Wibaux | 30109 | 208 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-06-22 04:20:54 | Wibaux, Montana, US | |
1765368 | 1765368 | 2022-06-20 | US | Montana | Wibaux | 30109 | 208 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-06-21 04:20:56 | Wibaux, Montana, US | |
3271554 | 3271554 | 2022-06-19 | US | Montana | Wibaux | 30109 | 208 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-06-20 04:21:01 | Wibaux, Montana, US | |
3399466 | 3399466 | 2022-06-18 | US | Montana | Wibaux | 30109 | 208 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-06-19 04:20:51 | Wibaux, Montana, US | |
2313343 | 2313343 | 2022-06-17 | US | Montana | Wibaux | 30109 | 208 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-06-18 04:21:10 | Wibaux, Montana, US | |
3189154 | 3189154 | 2022-05-30 | US | Texas | Loving | 48301 | 208 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-05-31 04:20:51 | Loving, Texas, US | |
3201303 | 3201303 | 2022-05-29 | US | Texas | Loving | 48301 | 208 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-05-30 04:20:50 | Loving, Texas, US | |
2728181 | 2728181 | 2022-05-28 | US | Texas | Loving | 48301 | 208 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-05-29 04:20:53 | Loving, Texas, US | |
1317362 | 1317362 | 2022-05-27 | US | Texas | Loving | 48301 | 208 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-05-28 04:21:07 | Loving, Texas, US | |
1504256 | 1504256 | 2022-05-16 | US | Colorado | San Juan | 8111 | 208 | 0 | 0 | 37.76248981 | -107.6763289 | 2022-05-17 04:20:59 | San Juan, Colorado, US | |
3538549 | 3538549 | 2022-05-10 | US | Texas | Foard | 48155 | 208 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-05-11 04:20:48 | Foard, Texas, US | |
225084 | 225084 | 2022-05-09 | US | Texas | Foard | 48155 | 208 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-05-10 04:20:50 | Foard, Texas, US | |
2334469 | 2334469 | 2022-05-08 | US | Texas | Foard | 48155 | 208 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-05-09 04:20:54 | Foard, Texas, US | |
363431 | 363431 | 2022-05-07 | US | Texas | Foard | 48155 | 208 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-05-08 04:20:49 | Foard, Texas, US | |
1400782 | 1400782 | 2022-05-06 | US | Texas | Foard | 48155 | 208 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-05-07 04:21:09 | Foard, Texas, US | |
1951656 | 1951656 | 2022-04-12 | US | Texas | Kent | 48263 | 208 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-04-13 04:21:03 | Kent, Texas, US | |
3209409 | 3209409 | 2022-04-11 | US | Texas | Kent | 48263 | 208 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-04-12 04:20:49 | Kent, Texas, US | |
1579295 | 1579295 | 2022-04-10 | US | Texas | Kent | 48263 | 208 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-04-11 04:21:02 | Kent, Texas, US | |
1655537 | 1655537 | 2022-04-09 | US | Texas | Kent | 48263 | 208 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-04-10 04:20:52 | Kent, Texas, US | |
2118859 | 2118859 | 2022-04-08 | US | Texas | Kent | 48263 | 208 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-04-09 04:20:42 | Kent, Texas, US | |
3323383 | 3323383 | 2022-04-07 | US | Texas | Kent | 48263 | 208 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-04-08 04:20:48 | Kent, Texas, US | |
2803919 | 2803919 | 2022-04-06 | US | Texas | Kent | 48263 | 208 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-04-07 04:20:53 | Kent, Texas, US | |
3870688 | 3870688 | 2022-04-05 | US | Texas | Kent | 48263 | 208 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-04-06 04:20:49 | Kent, Texas, US | |
2752030 | 2752030 | 2022-04-04 | US | Texas | Kent | 48263 | 208 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-04-05 04:20:48 | Kent, Texas, US | |
3733376 | 3733376 | 2022-04-03 | US | Texas | Kent | 48263 | 208 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-04-04 04:20:51 | Kent, Texas, US | |
502811 | 502811 | 2022-04-02 | US | Texas | Kent | 48263 | 208 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-04-03 04:20:48 | Kent, Texas, US | |
3353796 | 3353796 | 2022-04-01 | US | Texas | Kent | 48263 | 208 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-04-02 04:20:47 | Kent, Texas, US | |
1543101 | 1543101 | 2022-03-31 | US | Texas | Kent | 48263 | 208 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-04-01 04:20:28 | Kent, Texas, US | |
2481114 | 2481114 | 2022-03-30 | US | Texas | Kent | 48263 | 208 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-03-31 04:20:56 | Kent, Texas, US | |
161155 | 161155 | 2022-03-29 | US | Texas | Kent | 48263 | 208 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-03-30 04:20:45 | Kent, Texas, US | |
1439726 | 1439726 | 2022-03-28 | US | Texas | Kent | 48263 | 208 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-03-29 04:20:46 | Kent, Texas, US | |
879407 | 879407 | 2022-03-27 | US | Texas | Kent | 48263 | 208 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-03-28 04:20:33 | Kent, Texas, US | |
2166690 | 2166690 | 2022-03-26 | US | Texas | Kent | 48263 | 208 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-03-27 04:20:47 | Kent, Texas, US | |
1320215 | 1320215 | 2022-01-26 | US | Montana | Garfield | 30033 | 208 | 3 | 0 | 47.27545948 | -107.0002351 | 2022-01-27 04:21:19 | Garfield, Montana, US | |
3425099 | 3425099 | 2022-01-21 | Palau | 208 | 0 | 0 | 7.515 | 134.5825 | 2022-01-22 04:21:13 | Palau | ||||
1960707 | 1960707 | 2022-01-20 | Palau | 208 | 0 | 0 | 7.515 | 134.5825 | 2022-01-21 04:21:09 | Palau | ||||
1284625 | 1284625 | 2022-01-05 | US | Oregon | Sherman | 41055 | 208 | 3 | 0 | 45.41501554 | -120.6827834 | 2022-01-06 04:22:09 | Sherman, Oregon, US | |
1288641 | 1288641 | 2022-01-04 | US | Oregon | Sherman | 41055 | 208 | 3 | 0 | 45.41501554 | -120.6827834 | 2022-01-05 04:21:59 | Sherman, Oregon, US | |
3521422 | 3521422 | 2022-01-02 | US | Montana | Carter | 30011 | 208 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2022-01-03 02:22:25 | Carter, Montana, US | |
2169552 | 2169552 | 2022-01-01 | US | Montana | Carter | 30011 | 208 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2022-01-02 04:20:52 | Carter, Montana, US | |
2778983 | 2778983 | 2021-12-31 | US | Montana | Carter | 30011 | 208 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2022-01-01 04:22:14 | Carter, Montana, US | |
4000640 | 4000640 | 2021-12-30 | US | Montana | Carter | 30011 | 208 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2021-12-31 04:21:50 | Carter, Montana, US | |
1670447 | 1670447 | 2021-12-29 | US | Montana | Carter | 30011 | 208 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2021-12-30 04:21:25 | Carter, Montana, US | |
1435423 | 1435423 | 2021-12-28 | US | South Dakota | Campbell | 46021 | 208 | 6 | 0 | 45.77074915 | -100.0510181 | 2021-12-29 03:21:43 | Campbell, South Dakota, US | |
1434556 | 1434556 | 2021-12-28 | US | Montana | Carter | 30011 | 208 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2021-12-29 03:21:43 | Carter, Montana, US | |
733384 | 733384 | 2021-12-27 | US | South Dakota | Campbell | 46021 | 208 | 6 | 0 | 45.77074915 | -100.0510181 | 2021-12-28 04:21:47 | Campbell, South Dakota, US | |
732517 | 732517 | 2021-12-27 | US | Montana | Carter | 30011 | 208 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2021-12-28 04:21:47 | Carter, Montana, US | |
2114556 | 2114556 | 2021-12-26 | US | South Dakota | Campbell | 46021 | 208 | 6 | 0 | 45.77074915 | -100.0510181 | 2021-12-27 04:21:58 | Campbell, South Dakota, US | |
2113689 | 2113689 | 2021-12-26 | US | Montana | Carter | 30011 | 208 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2021-12-27 04:21:58 | Carter, Montana, US | |
3607928 | 3607928 | 2021-12-25 | US | South Dakota | Campbell | 46021 | 208 | 6 | 0 | 45.77074915 | -100.0510181 | 2021-12-26 04:21:50 | Campbell, South Dakota, US | |
3607061 | 3607061 | 2021-12-25 | US | Montana | Carter | 30011 | 208 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2021-12-26 04:21:50 | Carter, Montana, US | |
2966246 | 2966246 | 2021-12-24 | US | South Dakota | Campbell | 46021 | 208 | 6 | 0 | 45.77074915 | -100.0510181 | 2021-12-25 04:21:37 | Campbell, South Dakota, US | |
2965379 | 2965379 | 2021-12-24 | US | Montana | Carter | 30011 | 208 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2021-12-25 04:21:37 | Carter, Montana, US | |
3819278 | 3819278 | 2021-12-23 | US | South Dakota | Campbell | 46021 | 208 | 6 | 0 | 45.77074915 | -100.0510181 | 2021-12-24 04:21:34 | Campbell, South Dakota, US | |
3818411 | 3818411 | 2021-12-23 | US | Montana | Carter | 30011 | 208 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2021-12-24 04:21:34 | Carter, Montana, US | |
801286 | 801286 | 2021-12-22 | US | South Dakota | Campbell | 46021 | 208 | 6 | 0 | 45.77074915 | -100.0510181 | 2021-12-23 04:21:21 | Campbell, South Dakota, US | |
800419 | 800419 | 2021-12-22 | US | Montana | Carter | 30011 | 208 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2021-12-23 04:21:21 | Carter, Montana, US | |
3831326 | 3831326 | 2021-12-21 | US | South Dakota | Campbell | 46021 | 208 | 6 | 0 | 45.77074915 | -100.0510181 | 2021-12-22 04:21:54 | Campbell, South Dakota, US | |
3830459 | 3830459 | 2021-12-21 | US | Montana | Carter | 30011 | 208 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2021-12-22 04:21:54 | Carter, Montana, US | |
1256762 | 1256762 | 2021-12-20 | US | Montana | Carter | 30011 | 208 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2021-12-21 03:21:27 | Carter, Montana, US | |
2905705 | 2905705 | 2021-12-19 | US | Montana | Carter | 30011 | 208 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2021-12-20 04:21:43 | Carter, Montana, US | |
1260778 | 1260778 | 2021-12-18 | US | Montana | Carter | 30011 | 208 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2021-12-19 04:21:11 | Carter, Montana, US | |
2400806 | 2400806 | 2021-12-17 | US | Montana | Carter | 30011 | 208 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2021-12-18 02:22:20 | Carter, Montana, US | |
1718344 | 1718344 | 2021-12-16 | US | Montana | Carter | 30011 | 208 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2021-12-17 04:22:14 | Carter, Montana, US | |
3498178 | 3498178 | 2021-12-15 | US | Montana | Carter | 30011 | 208 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2021-12-16 04:22:11 | Carter, Montana, US | |
1080714 | 1080714 | 2021-12-09 | US | Puerto Rico | Vieques | 72147 | 208 | 0 | 0 | 18.123276 | -65.44097099999999 | 2021-12-10 04:22:28 | Vieques, Puerto Rico, US | |
553563 | 553563 | 2021-12-08 | US | Puerto Rico | Vieques | 72147 | 208 | 0 | 0 | 18.123276 | -65.44097099999999 | 2021-12-09 04:22:49 | Vieques, Puerto Rico, US | |
3752310 | 3752310 | 2021-11-22 | US | Texas | Motley | 48345 | 208 | 9 | 0 | 34.07408766 | -100.77972199999999 | 2021-11-23 04:22:39 | Motley, Texas, US | |
1017517 | 1017517 | 2021-11-21 | US | Texas | Motley | 48345 | 208 | 9 | 0 | 34.07408766 | -100.77972199999999 | 2021-11-22 04:22:20 | Motley, Texas, 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]);