johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
846 rows where confirmed = 351 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2559753 | 2559753 | 2022-11-29 | US | Texas | Loving | 48301 | 351 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-11-30 04:21:07 | Loving, Texas, US | |
1242827 | 1242827 | 2022-11-28 | US | Texas | Loving | 48301 | 351 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-11-29 04:21:05 | Loving, Texas, US | |
3554815 | 3554815 | 2022-11-27 | US | Texas | Loving | 48301 | 351 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-11-28 04:21:02 | Loving, Texas, US | |
2103295 | 2103295 | 2022-11-26 | US | Texas | Loving | 48301 | 351 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-11-27 04:21:05 | Loving, Texas, US | |
490786 | 490786 | 2022-11-25 | US | Texas | Loving | 48301 | 351 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-11-26 04:21:11 | Loving, Texas, US | |
3526615 | 3526615 | 2022-11-24 | US | Texas | Loving | 48301 | 351 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-11-25 04:21:06 | Loving, Texas, US | |
3315398 | 3315398 | 2022-11-23 | US | Texas | Loving | 48301 | 351 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-11-24 04:21:09 | Loving, Texas, US | |
2636786 | 2636786 | 2022-09-05 | US | Texas | Cottle | 48101 | 351 | 9 | 0 | 34.07783319 | -100.2785062 | 2022-09-06 04:21:02 | Cottle, Texas, US | |
2990350 | 2990350 | 2022-09-04 | US | Texas | Cottle | 48101 | 351 | 9 | 0 | 34.07783319 | -100.2785062 | 2022-09-05 04:21:01 | Cottle, Texas, US | |
2987896 | 2987896 | 2022-09-04 | US | Colorado | Cheyenne | 8017 | 351 | 11 | 0 | 38.82777431 | -102.6032558 | 2022-09-05 04:21:01 | Cheyenne, Colorado, US | |
2716035 | 2716035 | 2022-09-03 | US | Texas | Cottle | 48101 | 351 | 9 | 0 | 34.07783319 | -100.2785062 | 2022-09-04 04:21:22 | Cottle, Texas, US | |
2713581 | 2713581 | 2022-09-03 | US | Colorado | Cheyenne | 8017 | 351 | 11 | 0 | 38.82777431 | -102.6032558 | 2022-09-04 04:21:22 | Cheyenne, Colorado, US | |
1396740 | 1396740 | 2022-09-02 | US | Texas | Cottle | 48101 | 351 | 9 | 0 | 34.07783319 | -100.2785062 | 2022-09-03 04:21:04 | Cottle, Texas, US | |
1394286 | 1394286 | 2022-09-02 | US | Colorado | Cheyenne | 8017 | 351 | 11 | 0 | 38.82777431 | -102.6032558 | 2022-09-03 04:21:04 | Cheyenne, Colorado, US | |
3550569 | 3550569 | 2022-09-01 | US | Texas | Cottle | 48101 | 351 | 9 | 0 | 34.07783319 | -100.2785062 | 2022-09-02 04:21:07 | Cottle, Texas, US | |
3548115 | 3548115 | 2022-09-01 | US | Colorado | Cheyenne | 8017 | 351 | 11 | 0 | 38.82777431 | -102.6032558 | 2022-09-02 04:21:07 | Cheyenne, Colorado, US | |
2346489 | 2346489 | 2022-08-31 | US | Texas | Cottle | 48101 | 351 | 9 | 0 | 34.07783319 | -100.2785062 | 2022-09-01 04:21:03 | Cottle, Texas, US | |
3776969 | 3776969 | 2022-08-30 | US | Texas | Cottle | 48101 | 351 | 9 | 0 | 34.07783319 | -100.2785062 | 2022-08-31 04:20:57 | Cottle, Texas, US | |
1683565 | 1683565 | 2022-08-29 | US | Texas | Cottle | 48101 | 351 | 9 | 0 | 34.07783319 | -100.2785062 | 2022-08-30 04:21:03 | Cottle, Texas, US | |
1880049 | 1880049 | 2022-08-28 | US | Texas | Cottle | 48101 | 351 | 9 | 0 | 34.07783319 | -100.2785062 | 2022-08-29 04:21:06 | Cottle, Texas, US | |
2099176 | 2099176 | 2022-08-27 | US | Texas | Cottle | 48101 | 351 | 9 | 0 | 34.07783319 | -100.2785062 | 2022-08-28 04:21:02 | Cottle, Texas, US | |
1534991 | 1534991 | 2022-08-26 | US | Texas | Cottle | 48101 | 351 | 9 | 0 | 34.07783319 | -100.2785062 | 2022-08-27 04:20:57 | Cottle, Texas, US | |
2831878 | 2831878 | 2022-08-25 | US | Texas | Cottle | 48101 | 351 | 9 | 0 | 34.07783319 | -100.2785062 | 2022-08-26 04:21:02 | Cottle, Texas, US | |
2326411 | 2326411 | 2022-08-24 | US | Texas | Cottle | 48101 | 351 | 9 | 0 | 34.07783319 | -100.2785062 | 2022-08-25 04:21:13 | Cottle, Texas, US | |
1253820 | 1253820 | 2022-08-23 | US | Texas | Cottle | 48101 | 351 | 9 | 0 | 34.07783319 | -100.2785062 | 2022-08-24 04:20:46 | Cottle, Texas, US | |
2855924 | 2855924 | 2022-08-22 | US | Texas | Cottle | 48101 | 351 | 9 | 0 | 34.07783319 | -100.2785062 | 2022-08-23 04:20:56 | Cottle, Texas, US | |
2405896 | 2405896 | 2022-08-21 | US | Texas | Cottle | 48101 | 351 | 9 | 0 | 34.07783319 | -100.2785062 | 2022-08-22 04:20:38 | Cottle, Texas, US | |
3800974 | 3800974 | 2022-08-20 | US | Texas | Cottle | 48101 | 351 | 9 | 0 | 34.07783319 | -100.2785062 | 2022-08-21 04:20:44 | Cottle, Texas, US | |
2366560 | 2366560 | 2022-08-19 | US | Texas | Cottle | 48101 | 351 | 9 | 0 | 34.07783319 | -100.2785062 | 2022-08-20 04:21:01 | Cottle, Texas, US | |
1164231 | 1164231 | 2022-08-18 | US | Texas | Cottle | 48101 | 351 | 9 | 0 | 34.07783319 | -100.2785062 | 2022-08-19 04:20:54 | Cottle, Texas, US | |
3953555 | 3953555 | 2022-08-17 | US | Texas | Cottle | 48101 | 351 | 9 | 0 | 34.07783319 | -100.2785062 | 2022-08-18 04:21:11 | Cottle, Texas, US | |
994057 | 994057 | 2022-08-16 | US | Texas | Cottle | 48101 | 351 | 9 | 0 | 34.07783319 | -100.2785062 | 2022-08-17 04:20:59 | Cottle, Texas, US | |
2497096 | 2497096 | 2022-08-15 | US | Texas | Cottle | 48101 | 351 | 9 | 0 | 34.07783319 | -100.2785062 | 2022-08-16 04:20:58 | Cottle, Texas, US | |
3650646 | 3650646 | 2022-08-14 | US | Texas | Cottle | 48101 | 351 | 9 | 0 | 34.07783319 | -100.2785062 | 2022-08-15 04:20:59 | Cottle, Texas, US | |
1971652 | 1971652 | 2022-08-13 | US | Texas | Cottle | 48101 | 351 | 9 | 0 | 34.07783319 | -100.2785062 | 2022-08-14 04:20:55 | Cottle, Texas, US | |
2891461 | 2891461 | 2022-08-12 | US | Texas | Cottle | 48101 | 351 | 9 | 0 | 34.07783319 | -100.2785062 | 2022-08-13 04:20:52 | Cottle, Texas, US | |
3911066 | 3911066 | 2022-08-11 | US | Texas | Cottle | 48101 | 351 | 9 | 0 | 34.07783319 | -100.2785062 | 2022-08-12 04:20:54 | Cottle, Texas, US | |
1784100 | 1784100 | 2022-07-29 | US | California | Sierra | 6091 | 351 | 4 | 0 | 39.57713498 | -120.5200701 | 2022-07-30 04:20:42 | Sierra, California, US | |
1066463 | 1066463 | 2022-07-28 | US | California | Sierra | 6091 | 351 | 4 | 0 | 39.57713498 | -120.5200701 | 2022-07-29 04:20:45 | Sierra, California, US | |
2335982 | 2335982 | 2022-07-27 | US | California | Sierra | 6091 | 351 | 4 | 0 | 39.57713498 | -120.5200701 | 2022-07-28 04:20:56 | Sierra, California, US | |
1488172 | 1488172 | 2022-07-26 | US | California | Sierra | 6091 | 351 | 4 | 0 | 39.57713498 | -120.5200701 | 2022-07-27 04:21:04 | Sierra, California, US | |
2594618 | 2594618 | 2022-07-25 | US | California | Sierra | 6091 | 351 | 4 | 0 | 39.57713498 | -120.5200701 | 2022-07-26 04:20:58 | Sierra, California, US | |
896733 | 896733 | 2022-07-24 | US | California | Sierra | 6091 | 351 | 4 | 0 | 39.57713498 | -120.5200701 | 2022-07-25 04:20:51 | Sierra, California, US | |
91727 | 91727 | 2022-07-23 | US | California | Sierra | 6091 | 351 | 4 | 0 | 39.57713498 | -120.5200701 | 2022-07-24 04:20:47 | Sierra, California, US | |
900749 | 900749 | 2022-07-22 | US | California | Sierra | 6091 | 351 | 4 | 0 | 39.57713498 | -120.5200701 | 2022-07-23 04:20:53 | Sierra, California, US | |
670885 | 670885 | 2022-07-21 | US | California | Sierra | 6091 | 351 | 4 | 0 | 39.57713498 | -120.5200701 | 2022-07-22 04:21:15 | Sierra, California, US | |
2791671 | 2791671 | 2022-07-10 | US | Oregon | Sherman | 41055 | 351 | 6 | 0 | 45.41501554 | -120.6827834 | 2022-07-11 04:20:46 | Sherman, Oregon, US | |
144624 | 144624 | 2022-07-09 | US | Oregon | Sherman | 41055 | 351 | 6 | 0 | 45.41501554 | -120.6827834 | 2022-07-10 04:20:54 | Sherman, Oregon, US | |
1419724 | 1419724 | 2022-07-08 | US | Oregon | Sherman | 41055 | 351 | 6 | 0 | 45.41501554 | -120.6827834 | 2022-07-09 04:20:59 | Sherman, Oregon, US | |
3271597 | 3271597 | 2022-06-19 | US | Nebraska | Harlan | 31083 | 351 | 3 | 0 | 40.17658508 | -99.40438879 | 2022-06-20 04:21:01 | Harlan, Nebraska, US | |
3399509 | 3399509 | 2022-06-18 | US | Nebraska | Harlan | 31083 | 351 | 3 | 0 | 40.17658508 | -99.40438879 | 2022-06-19 04:20:51 | Harlan, Nebraska, US | |
2313386 | 2313386 | 2022-06-17 | US | Nebraska | Harlan | 31083 | 351 | 3 | 0 | 40.17658508 | -99.40438879 | 2022-06-18 04:21:10 | Harlan, Nebraska, US | |
560890 | 560890 | 2022-06-16 | US | Nebraska | Harlan | 31083 | 351 | 3 | 0 | 40.17658508 | -99.40438879 | 2022-06-17 04:20:56 | Harlan, Nebraska, US | |
3984692 | 3984692 | 2022-06-15 | US | Nebraska | Harlan | 31083 | 351 | 3 | 0 | 40.17658508 | -99.40438879 | 2022-06-16 04:20:55 | Harlan, Nebraska, US | |
948933 | 948933 | 2022-06-14 | US | Nebraska | Harlan | 31083 | 351 | 3 | 0 | 40.17658508 | -99.40438879 | 2022-06-15 04:20:54 | Harlan, Nebraska, US | |
2981341 | 2981341 | 2022-06-13 | US | Nebraska | Harlan | 31083 | 351 | 3 | 0 | 40.17658508 | -99.40438879 | 2022-06-14 04:20:52 | Harlan, Nebraska, US | |
2237467 | 2237467 | 2022-06-12 | US | Nebraska | Harlan | 31083 | 351 | 3 | 0 | 40.17658508 | -99.40438879 | 2022-06-13 04:21:14 | Harlan, Nebraska, US | |
3143665 | 3143665 | 2022-06-11 | US | Nebraska | Harlan | 31083 | 351 | 3 | 0 | 40.17658508 | -99.40438879 | 2022-06-12 04:20:53 | Harlan, Nebraska, US | |
1946581 | 1946581 | 2022-06-10 | US | Nebraska | Harlan | 31083 | 351 | 3 | 0 | 40.17658508 | -99.40438879 | 2022-06-11 04:21:01 | Harlan, Nebraska, US | |
3207512 | 3207512 | 2022-04-11 | US | Iowa | Unassigned | 90019 | 351 | 0 | 0 | 43.38107862 | 0.0 | 2022-04-12 04:20:49 | Unassigned, Iowa, US | |
1577398 | 1577398 | 2022-04-10 | US | Iowa | Unassigned | 90019 | 351 | 0 | 0 | 43.38107862 | 0.0 | 2022-04-11 04:21:02 | Unassigned, Iowa, US | |
1575961 | 1575961 | 2022-04-10 | China | Shanxi | 351 | 0 | 0 | 37.5777 | 112.2922 | 2022-04-11 04:21:02 | Shanxi, China | |||
1653640 | 1653640 | 2022-04-09 | US | Iowa | Unassigned | 90019 | 351 | 0 | 0 | 43.38107862 | 0.0 | 2022-04-10 04:20:52 | Unassigned, Iowa, US | |
2528593 | 2528593 | 2022-03-02 | US | Texas | Stonewall | 48433 | 351 | 7 | 0 | 33.17906744 | -100.25384009999999 | 2022-03-03 04:21:01 | Stonewall, Texas, US | |
1995887 | 1995887 | 2022-03-01 | US | Texas | Stonewall | 48433 | 351 | 7 | 0 | 33.17906744 | -100.25384009999999 | 2022-03-02 04:21:07 | Stonewall, Texas, US | |
946061 | 946061 | 2022-02-28 | US | Texas | Stonewall | 48433 | 351 | 7 | 0 | 33.17906744 | -100.25384009999999 | 2022-03-01 04:21:09 | Stonewall, Texas, US | |
2736252 | 2736252 | 2022-02-27 | US | Texas | Stonewall | 48433 | 351 | 7 | 0 | 33.17906744 | -100.25384009999999 | 2022-02-28 04:21:05 | Stonewall, Texas, US | |
3049405 | 3049405 | 2022-02-26 | US | Texas | Stonewall | 48433 | 351 | 7 | 0 | 33.17906744 | -100.25384009999999 | 2022-02-27 04:21:04 | Stonewall, Texas, US | |
578060 | 578060 | 2022-02-25 | US | Texas | Stonewall | 48433 | 351 | 7 | 0 | 33.17906744 | -100.25384009999999 | 2022-02-26 04:21:12 | Stonewall, Texas, US | |
1061206 | 1061206 | 2022-02-23 | US | Virginia | Highland | 51091 | 351 | 5 | 0 | 38.35799465 | -79.56124594 | 2022-02-24 04:21:14 | Highland, Virginia, US | |
2450129 | 2450129 | 2022-02-22 | US | Virginia | Highland | 51091 | 351 | 5 | 0 | 38.35799465 | -79.56124594 | 2022-02-23 04:21:09 | Highland, Virginia, US | |
3822516 | 3822516 | 2022-02-16 | US | Nebraska | Gosper | 31073 | 351 | 5 | 0 | 40.51481965 | -99.83020279 | 2022-02-17 04:20:56 | Gosper, Nebraska, US | |
3673730 | 3673730 | 2022-02-15 | US | Nebraska | Gosper | 31073 | 351 | 5 | 0 | 40.51481965 | -99.83020279 | 2022-02-16 04:21:10 | Gosper, Nebraska, US | |
2643831 | 2643831 | 2022-02-14 | US | Nebraska | Gosper | 31073 | 351 | 5 | 0 | 40.51481965 | -99.83020279 | 2022-02-15 04:21:09 | Gosper, Nebraska, US | |
3302217 | 3302217 | 2022-01-30 | US | Montana | Liberty | 30051 | 351 | 2 | 0 | 48.56084317 | -111.02430700000001 | 2022-01-31 04:21:09 | Liberty, Montana, US | |
3064008 | 3064008 | 2022-01-29 | US | Montana | Liberty | 30051 | 351 | 2 | 0 | 48.56084317 | -111.02430700000001 | 2022-01-30 04:21:26 | Liberty, Montana, US | |
3811942 | 3811942 | 2022-01-28 | US | Montana | Liberty | 30051 | 351 | 2 | 0 | 48.56084317 | -111.02430700000001 | 2022-01-29 04:21:10 | Liberty, Montana, US | |
1962636 | 1962636 | 2022-01-20 | US | Nebraska | Greeley | 31077 | 351 | 1 | 0 | 41.56742671 | -98.52150266 | 2022-01-21 04:21:09 | Greeley, Nebraska, US | |
1962633 | 1962633 | 2022-01-20 | US | Nebraska | Garfield | 31071 | 351 | 1 | 0 | 41.91428955 | -98.99111827 | 2022-01-21 04:21:09 | Garfield, Nebraska, US | |
3466259 | 3466259 | 2022-01-18 | US | Nebraska | Harlan | 31083 | 351 | 0 | 0 | 40.17658508 | -99.40438879 | 2022-01-19 04:21:23 | Harlan, Nebraska, US | |
1433862 | 1433862 | 2021-12-28 | US | Kansas | Hamilton | 20075 | 351 | 2 | 0 | 37.99978709 | -101.7921066 | 2021-12-29 03:21:43 | Hamilton, Kansas, US | |
731823 | 731823 | 2021-12-27 | US | Kansas | Hamilton | 20075 | 351 | 2 | 0 | 37.99978709 | -101.7921066 | 2021-12-28 04:21:47 | Hamilton, Kansas, US | |
2114573 | 2114573 | 2021-12-26 | US | South Dakota | Haakon | 46055 | 351 | 11 | 0 | 44.29299053 | -101.539099 | 2021-12-27 04:21:58 | Haakon, South Dakota, US | |
2114108 | 2114108 | 2021-12-26 | US | North Dakota | Logan | 38047 | 351 | 11 | 0 | 46.45729487 | -99.47719806 | 2021-12-27 04:21:58 | Logan, North Dakota, US | |
2112995 | 2112995 | 2021-12-26 | US | Kansas | Hamilton | 20075 | 351 | 2 | 0 | 37.99978709 | -101.7921066 | 2021-12-27 04:21:58 | Hamilton, Kansas, US | |
3607945 | 3607945 | 2021-12-25 | US | South Dakota | Haakon | 46055 | 351 | 11 | 0 | 44.29299053 | -101.539099 | 2021-12-26 04:21:50 | Haakon, South Dakota, US | |
3607480 | 3607480 | 2021-12-25 | US | North Dakota | Logan | 38047 | 351 | 11 | 0 | 46.45729487 | -99.47719806 | 2021-12-26 04:21:50 | Logan, North Dakota, US | |
3606367 | 3606367 | 2021-12-25 | US | Kansas | Hamilton | 20075 | 351 | 2 | 0 | 37.99978709 | -101.7921066 | 2021-12-26 04:21:50 | Hamilton, Kansas, US | |
2966263 | 2966263 | 2021-12-24 | US | South Dakota | Haakon | 46055 | 351 | 11 | 0 | 44.29299053 | -101.539099 | 2021-12-25 04:21:37 | Haakon, South Dakota, US | |
2965798 | 2965798 | 2021-12-24 | US | North Dakota | Logan | 38047 | 351 | 11 | 0 | 46.45729487 | -99.47719806 | 2021-12-25 04:21:37 | Logan, North Dakota, US | |
2964685 | 2964685 | 2021-12-24 | US | Kansas | Hamilton | 20075 | 351 | 2 | 0 | 37.99978709 | -101.7921066 | 2021-12-25 04:21:37 | Hamilton, Kansas, US | |
3819295 | 3819295 | 2021-12-23 | US | South Dakota | Haakon | 46055 | 351 | 11 | 0 | 44.29299053 | -101.539099 | 2021-12-24 04:21:34 | Haakon, South Dakota, US | |
3818830 | 3818830 | 2021-12-23 | US | North Dakota | Logan | 38047 | 351 | 11 | 0 | 46.45729487 | -99.47719806 | 2021-12-24 04:21:34 | Logan, North Dakota, US | |
3817717 | 3817717 | 2021-12-23 | US | Kansas | Hamilton | 20075 | 351 | 2 | 0 | 37.99978709 | -101.7921066 | 2021-12-24 04:21:34 | Hamilton, Kansas, US | |
799725 | 799725 | 2021-12-22 | US | Kansas | Hamilton | 20075 | 351 | 2 | 0 | 37.99978709 | -101.7921066 | 2021-12-23 04:21:21 | Hamilton, Kansas, US | |
2904990 | 2904990 | 2021-12-19 | US | Kansas | Comanche | 20033 | 351 | 13 | 0 | 37.19114520000001 | -99.27113247 | 2021-12-20 04:21:43 | Comanche, Kansas, US | |
1260063 | 1260063 | 2021-12-18 | US | Kansas | Comanche | 20033 | 351 | 13 | 0 | 37.19114520000001 | -99.27113247 | 2021-12-19 04:21:11 | Comanche, Kansas, US | |
2400091 | 2400091 | 2021-12-17 | US | Kansas | Comanche | 20033 | 351 | 13 | 0 | 37.19114520000001 | -99.27113247 | 2021-12-18 02:22:20 | Comanche, Kansas, US | |
1719096 | 1719096 | 2021-12-16 | US | Puerto Rico | Guanica | 72055 | 351 | 0 | 0 | 17.982429 | -66.91964300000001 | 2021-12-17 04:22:14 | Guanica, Puerto Rico, US | |
1716036 | 1716036 | 2021-12-16 | Australia | Northern Territory | 351 | 1 | 0 | -12.4634 | 130.8456 | 2021-12-17 04:22:14 | Northern Territory, Australia |
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]);