johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
999 rows where confirmed = 211 and country_or_region = "US" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- Texas 104
- Kansas 102
- Georgia 52
- Nebraska 49
- South Dakota 47
- Puerto Rico 43
- Virginia 34
- Michigan 33
- Kentucky 31
- North Dakota 28
- Colorado 27
- Illinois 26
- Mississippi 25
- Montana 24
- North Carolina 23
- Iowa 22
- Tennessee 22
- Minnesota 21
- Indiana 20
- Missouri 19
- New Mexico 19
- Ohio 18
- Washington 18
- Idaho 16
- Arkansas 15
- Pennsylvania 15
- Alabama 14
- New York 14
- Louisiana 13
- Oklahoma 12
- …
country_or_region 1
- US · 999 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2019605 | 2019605 | 2022-09-20 | US | South Dakota | Harding | 46063 | 211 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-09-21 04:23:22 | Harding, South Dakota, US | |
3573478 | 3573478 | 2022-09-19 | US | South Dakota | Harding | 46063 | 211 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-09-20 04:22:48 | Harding, South Dakota, US | |
422217 | 422217 | 2022-09-18 | US | South Dakota | Harding | 46063 | 211 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-09-19 04:21:49 | Harding, South Dakota, US | |
3376241 | 3376241 | 2022-09-17 | US | South Dakota | Harding | 46063 | 211 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-09-18 04:22:50 | Harding, South Dakota, US | |
2358349 | 2358349 | 2022-09-16 | US | South Dakota | Harding | 46063 | 211 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-09-17 04:20:19 | Harding, South Dakota, US | |
3989506 | 3989506 | 2022-09-15 | US | South Dakota | Harding | 46063 | 211 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-09-16 04:21:19 | Harding, South Dakota, US | |
1892023 | 1892023 | 2022-09-14 | US | South Dakota | Harding | 46063 | 211 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-09-15 04:21:02 | Harding, South Dakota, US | |
375078 | 375078 | 2022-09-13 | US | South Dakota | Harding | 46063 | 211 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-09-14 04:20:44 | Harding, South Dakota, US | |
2397680 | 2397680 | 2022-09-12 | US | South Dakota | Harding | 46063 | 211 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-09-13 04:20:57 | Harding, South Dakota, US | |
3768758 | 3768758 | 2022-09-11 | US | South Dakota | Harding | 46063 | 211 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-09-12 04:20:58 | Harding, South Dakota, US | |
3827333 | 3827333 | 2022-09-10 | US | South Dakota | Harding | 46063 | 211 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-09-11 04:20:50 | Harding, South Dakota, US | |
965790 | 965790 | 2022-09-09 | US | South Dakota | Harding | 46063 | 211 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-09-10 04:21:10 | Harding, South Dakota, US | |
256192 | 256192 | 2022-09-08 | US | South Dakota | Harding | 46063 | 211 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-09-09 04:21:11 | Harding, South Dakota, US | |
3747990 | 3747990 | 2022-09-07 | US | South Dakota | Harding | 46063 | 211 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-09-08 04:21:02 | Harding, South Dakota, US | |
117630 | 117630 | 2022-09-06 | US | South Dakota | Harding | 46063 | 211 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-09-07 04:20:59 | Harding, South Dakota, US | |
2636602 | 2636602 | 2022-09-05 | US | South Dakota | Harding | 46063 | 211 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-09-06 04:21:02 | Harding, South Dakota, US | |
2990166 | 2990166 | 2022-09-04 | US | South Dakota | Harding | 46063 | 211 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-09-05 04:21:01 | Harding, South Dakota, US | |
2715851 | 2715851 | 2022-09-03 | US | South Dakota | Harding | 46063 | 211 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-09-04 04:21:22 | Harding, South Dakota, US | |
1396556 | 1396556 | 2022-09-02 | US | South Dakota | Harding | 46063 | 211 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-09-03 04:21:04 | Harding, South Dakota, US | |
3550385 | 3550385 | 2022-09-01 | US | South Dakota | Harding | 46063 | 211 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-09-02 04:21:07 | Harding, South Dakota, US | |
2346305 | 2346305 | 2022-08-31 | US | South Dakota | Harding | 46063 | 211 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-09-01 04:21:03 | Harding, South Dakota, US | |
3776785 | 3776785 | 2022-08-30 | US | South Dakota | Harding | 46063 | 211 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-08-31 04:20:57 | Harding, South Dakota, US | |
1683381 | 1683381 | 2022-08-29 | US | South Dakota | Harding | 46063 | 211 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-08-30 04:21:03 | Harding, South Dakota, US | |
1879865 | 1879865 | 2022-08-28 | US | South Dakota | Harding | 46063 | 211 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-08-29 04:21:06 | Harding, South Dakota, US | |
2098992 | 2098992 | 2022-08-27 | US | South Dakota | Harding | 46063 | 211 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-08-28 04:21:02 | Harding, South Dakota, US | |
1534807 | 1534807 | 2022-08-26 | US | South Dakota | Harding | 46063 | 211 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-08-27 04:20:57 | Harding, South Dakota, US | |
2831694 | 2831694 | 2022-08-25 | US | South Dakota | Harding | 46063 | 211 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-08-26 04:21:02 | Harding, South Dakota, US | |
2326227 | 2326227 | 2022-08-24 | US | South Dakota | Harding | 46063 | 211 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-08-25 04:21:13 | Harding, South Dakota, US | |
1163209 | 1163209 | 2022-08-18 | US | Montana | Wibaux | 30109 | 211 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-08-19 04:20:54 | Wibaux, Montana, US | |
3952533 | 3952533 | 2022-08-17 | US | Montana | Wibaux | 30109 | 211 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-08-18 04:21:11 | Wibaux, Montana, US | |
993035 | 993035 | 2022-08-16 | US | Montana | Wibaux | 30109 | 211 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-08-17 04:20:59 | Wibaux, Montana, US | |
2496074 | 2496074 | 2022-08-15 | US | Montana | Wibaux | 30109 | 211 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-08-16 04:20:58 | Wibaux, Montana, US | |
3649624 | 3649624 | 2022-08-14 | US | Montana | Wibaux | 30109 | 211 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-08-15 04:20:59 | Wibaux, Montana, US | |
1970630 | 1970630 | 2022-08-13 | US | Montana | Wibaux | 30109 | 211 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-08-14 04:20:55 | Wibaux, Montana, US | |
2890439 | 2890439 | 2022-08-12 | US | Montana | Wibaux | 30109 | 211 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-08-13 04:20:52 | Wibaux, Montana, US | |
2422034 | 2422034 | 2022-07-15 | US | Texas | Kent | 48263 | 211 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-07-16 04:21:05 | Kent, Texas, US | |
3432109 | 3432109 | 2022-07-14 | US | Texas | Kent | 48263 | 211 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-07-15 04:20:53 | Kent, Texas, US | |
3112629 | 3112629 | 2022-07-13 | US | Texas | Kent | 48263 | 211 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-07-14 04:20:57 | Kent, Texas, US | |
633052 | 633052 | 2022-07-12 | US | Texas | Kent | 48263 | 211 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-07-13 04:20:58 | Kent, Texas, US | |
1214696 | 1214696 | 2022-07-11 | US | Texas | Kent | 48263 | 211 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-07-12 04:20:51 | Kent, Texas, US | |
2792178 | 2792178 | 2022-07-10 | US | Texas | Kent | 48263 | 211 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-07-11 04:20:46 | Kent, Texas, US | |
145131 | 145131 | 2022-07-09 | US | Texas | Kent | 48263 | 211 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-07-10 04:20:54 | Kent, Texas, US | |
1420231 | 1420231 | 2022-07-08 | US | Texas | Kent | 48263 | 211 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-07-09 04:20:59 | Kent, Texas, US | |
2744156 | 2744156 | 2022-07-07 | US | Texas | Kent | 48263 | 211 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-07-08 04:20:56 | Kent, Texas, US | |
1202951 | 1202951 | 2022-07-06 | US | Texas | Kent | 48263 | 211 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-07-07 04:20:55 | Kent, Texas, US | |
3969694 | 3969694 | 2022-07-05 | US | Texas | Kent | 48263 | 211 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-07-06 04:20:58 | Kent, Texas, US | |
3081205 | 3081205 | 2022-07-04 | US | Texas | Kent | 48263 | 211 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-07-05 04:20:45 | Kent, Texas, US | |
1770487 | 1770487 | 2022-07-03 | US | Texas | Kent | 48263 | 211 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-07-04 04:20:54 | Kent, Texas, US | |
3368473 | 3368473 | 2022-07-02 | US | Texas | Kent | 48263 | 211 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-07-03 04:20:59 | Kent, Texas, US | |
596802 | 596802 | 2022-07-01 | US | Texas | Kent | 48263 | 211 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-07-02 04:21:16 | Kent, Texas, US | |
3943203 | 3943203 | 2022-06-30 | US | Texas | Kent | 48263 | 211 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-07-01 04:21:10 | Kent, Texas, US | |
2493161 | 2493161 | 2022-06-29 | US | Texas | Kent | 48263 | 211 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-06-30 04:21:01 | Kent, Texas, US | |
2242543 | 2242543 | 2022-06-28 | US | Texas | Kent | 48263 | 211 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-06-29 04:20:59 | Kent, Texas, US | |
2150785 | 2150785 | 2022-06-27 | US | Texas | Kent | 48263 | 211 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-06-28 04:20:58 | Kent, Texas, US | |
478586 | 478586 | 2022-06-26 | US | Texas | Kent | 48263 | 211 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-06-27 04:21:00 | Kent, Texas, US | |
941961 | 941961 | 2022-06-25 | US | Texas | Kent | 48263 | 211 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-06-26 04:21:02 | Kent, Texas, US | |
3349781 | 3349781 | 2022-06-24 | US | Texas | Kent | 48263 | 211 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-06-25 04:20:57 | Kent, Texas, US | |
1651522 | 1651522 | 2022-06-23 | US | Texas | Kent | 48263 | 211 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-06-24 04:20:58 | Kent, Texas, US | |
2190757 | 2190757 | 2022-06-22 | US | Texas | Kent | 48263 | 211 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-06-23 04:20:55 | Kent, Texas, US | |
169188 | 169188 | 2022-06-21 | US | Texas | Kent | 48263 | 211 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-06-22 04:20:54 | Kent, Texas, US | |
1766417 | 1766417 | 2022-06-20 | US | Texas | Foard | 48155 | 211 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-06-21 04:20:56 | Foard, Texas, US | |
1766471 | 1766471 | 2022-06-20 | US | Texas | Kent | 48263 | 211 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-06-21 04:20:56 | Kent, Texas, US | |
3272603 | 3272603 | 2022-06-19 | US | Texas | Foard | 48155 | 211 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-06-20 04:21:01 | Foard, Texas, US | |
3272657 | 3272657 | 2022-06-19 | US | Texas | Kent | 48263 | 211 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-06-20 04:21:01 | Kent, Texas, US | |
3400515 | 3400515 | 2022-06-18 | US | Texas | Foard | 48155 | 211 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-06-19 04:20:51 | Foard, Texas, US | |
3400569 | 3400569 | 2022-06-18 | US | Texas | Kent | 48263 | 211 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-06-19 04:20:51 | Kent, Texas, US | |
2314446 | 2314446 | 2022-06-17 | US | Texas | Kent | 48263 | 211 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-06-18 04:21:10 | Kent, Texas, US | |
561950 | 561950 | 2022-06-16 | US | Texas | Kent | 48263 | 211 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-06-17 04:20:56 | Kent, Texas, US | |
3985752 | 3985752 | 2022-06-15 | US | Texas | Kent | 48263 | 211 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-06-16 04:20:55 | Kent, Texas, US | |
949993 | 949993 | 2022-06-14 | US | Texas | Kent | 48263 | 211 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-06-15 04:20:54 | Kent, Texas, US | |
2982401 | 2982401 | 2022-06-13 | US | Texas | Kent | 48263 | 211 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-06-14 04:20:52 | Kent, Texas, US | |
2238527 | 2238527 | 2022-06-12 | US | Texas | Kent | 48263 | 211 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-06-13 04:21:14 | Kent, Texas, US | |
3144725 | 3144725 | 2022-06-11 | US | Texas | Kent | 48263 | 211 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-06-12 04:20:53 | Kent, Texas, US | |
1947641 | 1947641 | 2022-06-10 | US | Texas | Kent | 48263 | 211 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-06-11 04:21:01 | Kent, Texas, US | |
3160780 | 3160780 | 2022-06-09 | US | Texas | Kent | 48263 | 211 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-06-10 04:20:55 | Kent, Texas, US | |
3581789 | 3581789 | 2022-06-02 | US | Texas | Loving | 48301 | 211 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-06-03 04:20:58 | Loving, Texas, US | |
974082 | 974082 | 2022-06-01 | US | Texas | Loving | 48301 | 211 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-06-02 05:20:39 | Loving, Texas, US | |
232389 | 232389 | 2022-05-31 | US | Texas | Loving | 48301 | 211 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-06-01 04:20:55 | Loving, Texas, US | |
3198797 | 3198797 | 2022-05-29 | US | Colorado | San Juan | 8111 | 211 | 0 | 0 | 37.76248981 | -107.6763289 | 2022-05-30 04:20:50 | San Juan, Colorado, US | |
3302208 | 3302208 | 2022-01-30 | US | Montana | Garfield | 30033 | 211 | 3 | 0 | 47.27545948 | -107.0002351 | 2022-01-31 04:21:09 | Garfield, Montana, US | |
3063999 | 3063999 | 2022-01-29 | US | Montana | Garfield | 30033 | 211 | 3 | 0 | 47.27545948 | -107.0002351 | 2022-01-30 04:21:26 | Garfield, Montana, US | |
3811933 | 3811933 | 2022-01-28 | US | Montana | Garfield | 30033 | 211 | 3 | 0 | 47.27545948 | -107.0002351 | 2022-01-29 04:21:10 | Garfield, Montana, US | |
3465055 | 3465055 | 2022-01-18 | US | Georgia | Taliaferro | 13265 | 211 | 3 | 0 | 33.56543317 | -82.88136816 | 2022-01-19 04:21:23 | Taliaferro, Georgia, US | |
1472994 | 1472994 | 2022-01-17 | US | Georgia | Taliaferro | 13265 | 211 | 3 | 0 | 33.56543317 | -82.88136816 | 2022-01-18 04:21:04 | Taliaferro, Georgia, US | |
1695544 | 1695544 | 2022-01-10 | US | Texas | Sterling | 48431 | 211 | 5 | 0 | 31.82781912 | -101.05007459999999 | 2022-01-11 04:22:01 | Sterling, Texas, US | |
2612666 | 2612666 | 2022-01-06 | US | Oregon | Gilliam | 41021 | 211 | 4 | 0 | 45.37160076 | -120.20488689999999 | 2022-01-07 04:22:09 | Gilliam, Oregon, US | |
2612953 | 2612953 | 2022-01-06 | US | South Dakota | Sully | 46119 | 211 | 3 | 0 | 44.71571812 | -100.1278092 | 2022-01-07 04:22:09 | Sully, South Dakota, US | |
1284608 | 1284608 | 2022-01-05 | US | Oregon | Gilliam | 41021 | 211 | 4 | 0 | 45.37160076 | -120.20488689999999 | 2022-01-06 04:22:09 | Gilliam, Oregon, US | |
2170323 | 2170323 | 2022-01-01 | US | Puerto Rico | Maricao | 72093 | 211 | 0 | 0 | 18.171795 | -66.942126 | 2022-01-02 04:20:52 | Maricao, Puerto Rico, US | |
2779754 | 2779754 | 2021-12-31 | US | Puerto Rico | Maricao | 72093 | 211 | 0 | 0 | 18.171795 | -66.942126 | 2022-01-01 04:22:14 | Maricao, Puerto Rico, US | |
3831653 | 3831653 | 2021-12-21 | US | Texas | Motley | 48345 | 211 | 9 | 0 | 34.07408766 | -100.77972199999999 | 2021-12-22 04:21:54 | Motley, Texas, US | |
1257956 | 1257956 | 2021-12-20 | US | Texas | Motley | 48345 | 211 | 9 | 0 | 34.07408766 | -100.77972199999999 | 2021-12-21 03:21:27 | Motley, Texas, US | |
2906899 | 2906899 | 2021-12-19 | US | Texas | Motley | 48345 | 211 | 9 | 0 | 34.07408766 | -100.77972199999999 | 2021-12-20 04:21:43 | Motley, Texas, US | |
1261972 | 1261972 | 2021-12-18 | US | Texas | Motley | 48345 | 211 | 9 | 0 | 34.07408766 | -100.77972199999999 | 2021-12-19 04:21:11 | Motley, Texas, US | |
2402000 | 2402000 | 2021-12-17 | US | Texas | Motley | 48345 | 211 | 9 | 0 | 34.07408766 | -100.77972199999999 | 2021-12-18 02:22:20 | Motley, Texas, US | |
2402108 | 2402108 | 2021-12-17 | US | Vermont | Unassigned | 90050 | 211 | 0 | 0 | 44.85627605 | 0.0 | 2021-12-18 02:22:20 | Unassigned, Vermont, US | |
1719538 | 1719538 | 2021-12-16 | US | Texas | Motley | 48345 | 211 | 9 | 0 | 34.07408766 | -100.77972199999999 | 2021-12-17 04:22:14 | Motley, Texas, US | |
3499372 | 3499372 | 2021-12-15 | US | Texas | Motley | 48345 | 211 | 9 | 0 | 34.07408766 | -100.77972199999999 | 2021-12-16 04:22:11 | Motley, Texas, US | |
2091157 | 2091157 | 2021-12-14 | US | Texas | Motley | 48345 | 211 | 9 | 0 | 34.07408766 | -100.77972199999999 | 2021-12-15 03:22:16 | Motley, Texas, US | |
785574 | 785574 | 2021-12-13 | US | Texas | Motley | 48345 | 211 | 9 | 0 | 34.07408766 | -100.77972199999999 | 2021-12-14 04:22:38 | 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]);