johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
908 rows where confirmed = 295 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
133980 | 133980 | 2022-10-04 | US | Texas | Sterling | 48431 | 295 | 9 | 0 | 31.82781912 | -101.0500746 | 2022-10-05 04:23:06 | Sterling, Texas, US | |
133610 | 133610 | 2022-10-04 | US | South Dakota | Campbell | 46021 | 295 | 7 | 0 | 45.77074915 | -100.0510181 | 2022-10-05 04:23:06 | Campbell, South Dakota, US | |
2688927 | 2688927 | 2022-10-03 | US | Texas | Sterling | 48431 | 295 | 9 | 0 | 31.82781912 | -101.0500746 | 2022-10-04 04:22:55 | Sterling, Texas, US | |
2688557 | 2688557 | 2022-10-03 | US | South Dakota | Campbell | 46021 | 295 | 7 | 0 | 45.77074915 | -100.0510181 | 2022-10-04 04:22:55 | Campbell, South Dakota, US | |
2262994 | 2262994 | 2022-10-02 | US | Texas | Sterling | 48431 | 295 | 9 | 0 | 31.82781912 | -101.0500746 | 2022-10-03 04:23:11 | Sterling, Texas, US | |
2262624 | 2262624 | 2022-10-02 | US | South Dakota | Campbell | 46021 | 295 | 7 | 0 | 45.77074915 | -100.0510181 | 2022-10-03 04:23:11 | Campbell, South Dakota, US | |
2998520 | 2998520 | 2022-10-01 | US | Texas | Sterling | 48431 | 295 | 9 | 0 | 31.82781912 | -101.0500746 | 2022-10-02 04:21:23 | Sterling, Texas, US | |
2998150 | 2998150 | 2022-10-01 | US | South Dakota | Campbell | 46021 | 295 | 7 | 0 | 45.77074915 | -100.0510181 | 2022-10-02 04:21:23 | Campbell, South Dakota, US | |
856846 | 856846 | 2022-09-30 | US | Texas | Sterling | 48431 | 295 | 9 | 0 | 31.82781912 | -101.0500746 | 2022-10-01 04:23:01 | Sterling, Texas, US | |
856476 | 856476 | 2022-09-30 | US | South Dakota | Campbell | 46021 | 295 | 7 | 0 | 45.77074915 | -100.0510181 | 2022-10-01 04:23:01 | Campbell, South Dakota, US | |
2378772 | 2378772 | 2022-09-29 | US | Texas | Sterling | 48431 | 295 | 9 | 0 | 31.82781912 | -101.0500746 | 2022-09-30 04:23:09 | Sterling, Texas, US | |
2378402 | 2378402 | 2022-09-29 | US | South Dakota | Campbell | 46021 | 295 | 7 | 0 | 45.77074915 | -100.0510181 | 2022-09-30 04:23:09 | Campbell, South Dakota, US | |
1563323 | 1563323 | 2022-09-28 | US | Texas | Sterling | 48431 | 295 | 9 | 0 | 31.82781912 | -101.0500746 | 2022-09-29 04:22:34 | Sterling, Texas, US | |
1562953 | 1562953 | 2022-09-28 | US | South Dakota | Campbell | 46021 | 295 | 7 | 0 | 45.77074915 | -100.0510181 | 2022-09-29 04:22:34 | Campbell, South Dakota, US | |
3997866 | 3997866 | 2022-09-27 | US | Texas | Sterling | 48431 | 295 | 9 | 0 | 31.82781912 | -101.0500746 | 2022-09-28 04:23:01 | Sterling, Texas, US | |
3997496 | 3997496 | 2022-09-27 | US | South Dakota | Campbell | 46021 | 295 | 7 | 0 | 45.77074915 | -100.0510181 | 2022-09-28 04:23:01 | Campbell, South Dakota, US | |
2772194 | 2772194 | 2022-09-26 | US | Texas | Sterling | 48431 | 295 | 9 | 0 | 31.82781912 | -101.0500746 | 2022-09-27 04:23:01 | Sterling, Texas, US | |
2771824 | 2771824 | 2022-09-26 | US | South Dakota | Campbell | 46021 | 295 | 7 | 0 | 45.77074915 | -100.0510181 | 2022-09-27 04:23:01 | Campbell, South Dakota, US | |
1979847 | 1979847 | 2022-09-25 | US | Texas | Sterling | 48431 | 295 | 9 | 0 | 31.82781912 | -101.0500746 | 2022-09-26 04:20:52 | Sterling, Texas, US | |
1979477 | 1979477 | 2022-09-25 | US | South Dakota | Campbell | 46021 | 295 | 7 | 0 | 45.77074915 | -100.0510181 | 2022-09-26 04:20:52 | Campbell, South Dakota, US | |
2653014 | 2653014 | 2022-09-24 | US | Texas | Sterling | 48431 | 295 | 9 | 0 | 31.82781912 | -101.0500746 | 2022-09-25 04:23:31 | Sterling, Texas, US | |
2652644 | 2652644 | 2022-09-24 | US | South Dakota | Campbell | 46021 | 295 | 7 | 0 | 45.77074915 | -100.0510181 | 2022-09-25 04:23:31 | Campbell, South Dakota, US | |
387454 | 387454 | 2022-09-23 | US | Texas | Sterling | 48431 | 295 | 9 | 0 | 31.82781912 | -101.0500746 | 2022-09-24 04:21:40 | Sterling, Texas, US | |
387084 | 387084 | 2022-09-23 | US | South Dakota | Campbell | 46021 | 295 | 7 | 0 | 45.77074915 | -100.0510181 | 2022-09-24 04:21:40 | Campbell, South Dakota, US | |
1627150 | 1627150 | 2022-09-22 | US | South Dakota | Campbell | 46021 | 295 | 7 | 0 | 45.77074915 | -100.0510181 | 2022-09-23 04:23:13 | Campbell, South Dakota, US | |
1373354 | 1373354 | 2022-09-21 | US | South Dakota | Campbell | 46021 | 295 | 7 | 0 | 45.77074915 | -100.0510181 | 2022-09-22 04:22:56 | Campbell, South Dakota, US | |
2344083 | 2344083 | 2022-08-31 | US | Colorado | San Juan | 8111 | 295 | 0 | 0 | 37.76248981 | -107.6763289 | 2022-09-01 04:21:03 | San Juan, Colorado, US | |
3774563 | 3774563 | 2022-08-30 | US | Colorado | San Juan | 8111 | 295 | 0 | 0 | 37.76248981 | -107.6763289 | 2022-08-31 04:20:57 | San Juan, Colorado, US | |
1681159 | 1681159 | 2022-08-29 | US | Colorado | San Juan | 8111 | 295 | 0 | 0 | 37.76248981 | -107.6763289 | 2022-08-30 04:21:03 | San Juan, Colorado, US | |
1877643 | 1877643 | 2022-08-28 | US | Colorado | San Juan | 8111 | 295 | 0 | 0 | 37.76248981 | -107.6763289 | 2022-08-29 04:21:06 | San Juan, Colorado, US | |
2096770 | 2096770 | 2022-08-27 | US | Colorado | San Juan | 8111 | 295 | 0 | 0 | 37.76248981 | -107.6763289 | 2022-08-28 04:21:02 | San Juan, Colorado, US | |
1532585 | 1532585 | 2022-08-26 | US | Colorado | San Juan | 8111 | 295 | 0 | 0 | 37.76248981 | -107.6763289 | 2022-08-27 04:20:57 | San Juan, Colorado, US | |
2599357 | 2599357 | 2022-05-05 | US | Kansas | Lane | 20101 | 295 | 12 | 0 | 38.48119447 | -100.4660754 | 2022-05-06 04:21:00 | Lane, Kansas, US | |
3266806 | 3266806 | 2022-05-04 | US | Kansas | Lane | 20101 | 295 | 12 | 0 | 38.48119447 | -100.4660754 | 2022-05-05 04:20:55 | Lane, Kansas, US | |
1573445 | 1573445 | 2022-05-03 | US | Kansas | Lane | 20101 | 295 | 12 | 0 | 38.48119447 | -100.4660754 | 2022-05-04 04:20:59 | Lane, Kansas, US | |
464705 | 464705 | 2022-05-02 | US | Kansas | Lane | 20101 | 295 | 12 | 0 | 38.48119447 | -100.4660754 | 2022-05-03 04:21:00 | Lane, Kansas, US | |
3917344 | 3917344 | 2022-05-01 | US | Kansas | Lane | 20101 | 295 | 12 | 0 | 38.48119447 | -100.4660754 | 2022-05-02 04:21:10 | Lane, Kansas, US | |
2842148 | 2842148 | 2022-04-30 | US | Kansas | Lane | 20101 | 295 | 12 | 0 | 38.48119447 | -100.4660754 | 2022-05-01 04:20:57 | Lane, Kansas, US | |
1158461 | 1158461 | 2022-04-29 | US | Kansas | Lane | 20101 | 295 | 12 | 0 | 38.48119447 | -100.4660754 | 2022-04-30 04:21:05 | Lane, Kansas, US | |
3724628 | 3724628 | 2022-04-25 | US | North Dakota | Sheridan | 38083 | 295 | 7 | 0 | 47.57700669 | -100.3426391 | 2022-04-26 04:20:51 | Sheridan, North Dakota, US | |
2031196 | 2031196 | 2022-04-24 | US | North Dakota | Sheridan | 38083 | 295 | 7 | 0 | 47.57700669 | -100.3426391 | 2022-04-25 04:20:56 | Sheridan, North Dakota, US | |
748771 | 748771 | 2022-04-23 | US | North Dakota | Sheridan | 38083 | 295 | 7 | 0 | 47.57700669 | -100.3426391 | 2022-04-24 04:20:56 | Sheridan, North Dakota, US | |
3439256 | 3439256 | 2022-04-22 | US | North Dakota | Sheridan | 38083 | 295 | 7 | 0 | 47.57700669 | -100.3426391 | 2022-04-23 04:20:50 | Sheridan, North Dakota, US | |
2894841 | 2894841 | 2022-04-21 | US | North Dakota | Sheridan | 38083 | 295 | 7 | 0 | 47.57700669 | -100.3426391 | 2022-04-22 04:20:45 | Sheridan, North Dakota, US | |
2309713 | 2309713 | 2022-04-20 | US | North Dakota | Sheridan | 38083 | 295 | 7 | 0 | 47.57700669 | -100.3426391 | 2022-04-21 04:20:46 | Sheridan, North Dakota, US | |
2253852 | 2253852 | 2022-04-19 | US | North Dakota | Sheridan | 38083 | 295 | 7 | 0 | 47.57700669 | -100.3426391 | 2022-04-20 04:20:45 | Sheridan, North Dakota, US | |
1848402 | 1848402 | 2022-04-18 | US | North Dakota | Sheridan | 38083 | 295 | 7 | 0 | 47.57700669 | -100.3426391 | 2022-04-19 04:21:00 | Sheridan, North Dakota, US | |
3419346 | 3419346 | 2022-04-17 | US | North Dakota | Sheridan | 38083 | 295 | 7 | 0 | 47.57700669 | -100.3426391 | 2022-04-18 04:21:12 | Sheridan, North Dakota, US | |
306295 | 306295 | 2022-04-16 | US | North Dakota | Sheridan | 38083 | 295 | 7 | 0 | 47.57700669 | -100.3426391 | 2022-04-17 04:20:59 | Sheridan, North Dakota, US | |
2672240 | 2672240 | 2022-04-15 | US | North Dakota | Sheridan | 38083 | 295 | 7 | 0 | 47.57700669 | -100.3426391 | 2022-04-16 04:20:48 | Sheridan, North Dakota, US | |
1226025 | 1226025 | 2022-04-14 | US | North Dakota | Sheridan | 38083 | 295 | 7 | 0 | 47.57700669 | -100.3426391 | 2022-04-15 04:20:57 | Sheridan, North Dakota, US | |
1224907 | 1224907 | 2022-04-14 | US | Kansas | Lane | 20101 | 295 | 12 | 0 | 38.48119447 | -100.46607540000001 | 2022-04-13 23:21:06 | Lane, Kansas, US | |
2445183 | 2445183 | 2022-04-13 | US | North Dakota | Sheridan | 38083 | 295 | 7 | 0 | 47.57700669 | -100.3426391 | 2022-04-13 23:21:06 | Sheridan, North Dakota, US | |
2444065 | 2444065 | 2022-04-13 | US | Kansas | Lane | 20101 | 295 | 12 | 0 | 38.48119447 | -100.46607540000001 | 2022-04-13 23:21:06 | Lane, Kansas, US | |
1950940 | 1950940 | 2022-04-12 | US | North Dakota | Sheridan | 38083 | 295 | 7 | 0 | 47.57700669 | -100.3426391 | 2022-04-13 04:21:03 | Sheridan, North Dakota, US | |
1949822 | 1949822 | 2022-04-12 | US | Kansas | Lane | 20101 | 295 | 12 | 0 | 38.48119447 | -100.46607540000001 | 2022-04-13 04:21:03 | Lane, Kansas, US | |
3208693 | 3208693 | 2022-04-11 | US | North Dakota | Sheridan | 38083 | 295 | 7 | 0 | 47.57700669 | -100.3426391 | 2022-04-12 04:20:49 | Sheridan, North Dakota, US | |
3207575 | 3207575 | 2022-04-11 | US | Kansas | Lane | 20101 | 295 | 12 | 0 | 38.48119447 | -100.46607540000001 | 2022-04-12 04:20:49 | Lane, Kansas, US | |
1578579 | 1578579 | 2022-04-10 | US | North Dakota | Sheridan | 38083 | 295 | 7 | 0 | 47.57700669 | -100.3426391 | 2022-04-11 04:21:02 | Sheridan, North Dakota, US | |
1577461 | 1577461 | 2022-04-10 | US | Kansas | Lane | 20101 | 295 | 12 | 0 | 38.48119447 | -100.46607540000001 | 2022-04-11 04:21:02 | Lane, Kansas, US | |
1654821 | 1654821 | 2022-04-09 | US | North Dakota | Sheridan | 38083 | 295 | 7 | 0 | 47.57700669 | -100.3426391 | 2022-04-10 04:20:52 | Sheridan, North Dakota, US | |
1653703 | 1653703 | 2022-04-09 | US | Kansas | Lane | 20101 | 295 | 12 | 0 | 38.48119447 | -100.46607540000001 | 2022-04-10 04:20:52 | Lane, Kansas, US | |
2118143 | 2118143 | 2022-04-08 | US | North Dakota | Sheridan | 38083 | 295 | 7 | 0 | 47.57700669 | -100.3426391 | 2022-04-09 04:20:42 | Sheridan, North Dakota, US | |
2117025 | 2117025 | 2022-04-08 | US | Kansas | Lane | 20101 | 295 | 12 | 0 | 38.48119447 | -100.46607540000001 | 2022-04-09 04:20:42 | Lane, Kansas, US | |
3322667 | 3322667 | 2022-04-07 | US | North Dakota | Sheridan | 38083 | 295 | 7 | 0 | 47.57700669 | -100.3426391 | 2022-04-08 04:20:48 | Sheridan, North Dakota, US | |
3321549 | 3321549 | 2022-04-07 | US | Kansas | Lane | 20101 | 295 | 12 | 0 | 38.48119447 | -100.46607540000001 | 2022-04-08 04:20:48 | Lane, Kansas, US | |
2803203 | 2803203 | 2022-04-06 | US | North Dakota | Sheridan | 38083 | 295 | 7 | 0 | 47.57700669 | -100.3426391 | 2022-04-07 04:20:53 | Sheridan, North Dakota, US | |
2802085 | 2802085 | 2022-04-06 | US | Kansas | Lane | 20101 | 295 | 12 | 0 | 38.48119447 | -100.46607540000001 | 2022-04-07 04:20:53 | Lane, Kansas, US | |
3869972 | 3869972 | 2022-04-05 | US | North Dakota | Sheridan | 38083 | 295 | 7 | 0 | 47.57700669 | -100.3426391 | 2022-04-06 04:20:49 | Sheridan, North Dakota, US | |
3868854 | 3868854 | 2022-04-05 | US | Kansas | Lane | 20101 | 295 | 12 | 0 | 38.48119447 | -100.46607540000001 | 2022-04-06 04:20:49 | Lane, Kansas, US | |
2751314 | 2751314 | 2022-04-04 | US | North Dakota | Sheridan | 38083 | 295 | 7 | 0 | 47.57700669 | -100.3426391 | 2022-04-05 04:20:48 | Sheridan, North Dakota, US | |
2750196 | 2750196 | 2022-04-04 | US | Kansas | Lane | 20101 | 295 | 12 | 0 | 38.48119447 | -100.46607540000001 | 2022-04-05 04:20:48 | Lane, Kansas, US | |
3732660 | 3732660 | 2022-04-03 | US | North Dakota | Sheridan | 38083 | 295 | 7 | 0 | 47.57700669 | -100.3426391 | 2022-04-04 04:20:51 | Sheridan, North Dakota, US | |
3731542 | 3731542 | 2022-04-03 | US | Kansas | Lane | 20101 | 295 | 12 | 0 | 38.48119447 | -100.46607540000001 | 2022-04-04 04:20:51 | Lane, Kansas, US | |
502095 | 502095 | 2022-04-02 | US | North Dakota | Sheridan | 38083 | 295 | 7 | 0 | 47.57700669 | -100.3426391 | 2022-04-03 04:20:48 | Sheridan, North Dakota, US | |
500977 | 500977 | 2022-04-02 | US | Kansas | Lane | 20101 | 295 | 12 | 0 | 38.48119447 | -100.46607540000001 | 2022-04-03 04:20:48 | Lane, Kansas, US | |
3353080 | 3353080 | 2022-04-01 | US | North Dakota | Sheridan | 38083 | 295 | 7 | 0 | 47.57700669 | -100.3426391 | 2022-04-02 04:20:47 | Sheridan, North Dakota, US | |
3351962 | 3351962 | 2022-04-01 | US | Kansas | Lane | 20101 | 295 | 12 | 0 | 38.48119447 | -100.46607540000001 | 2022-04-02 04:20:47 | Lane, Kansas, US | |
1542385 | 1542385 | 2022-03-31 | US | North Dakota | Sheridan | 38083 | 295 | 7 | 0 | 47.57700669 | -100.3426391 | 2022-04-01 04:20:28 | Sheridan, North Dakota, US | |
1541267 | 1541267 | 2022-03-31 | US | Kansas | Lane | 20101 | 295 | 12 | 0 | 38.48119447 | -100.46607540000001 | 2022-04-01 04:20:28 | Lane, Kansas, US | |
2480398 | 2480398 | 2022-03-30 | US | North Dakota | Sheridan | 38083 | 295 | 7 | 0 | 47.57700669 | -100.3426391 | 2022-03-31 04:20:56 | Sheridan, North Dakota, US | |
2479280 | 2479280 | 2022-03-30 | US | Kansas | Lane | 20101 | 295 | 12 | 0 | 38.48119447 | -100.46607540000001 | 2022-03-31 04:20:56 | Lane, Kansas, US | |
160439 | 160439 | 2022-03-29 | US | North Dakota | Sheridan | 38083 | 295 | 7 | 0 | 47.57700669 | -100.3426391 | 2022-03-30 04:20:45 | Sheridan, North Dakota, US | |
159321 | 159321 | 2022-03-29 | US | Kansas | Lane | 20101 | 295 | 12 | 0 | 38.48119447 | -100.46607540000001 | 2022-03-30 04:20:45 | Lane, Kansas, US | |
1439010 | 1439010 | 2022-03-28 | US | North Dakota | Sheridan | 38083 | 295 | 7 | 0 | 47.57700669 | -100.3426391 | 2022-03-29 04:20:46 | Sheridan, North Dakota, US | |
1437892 | 1437892 | 2022-03-28 | US | Kansas | Lane | 20101 | 295 | 12 | 0 | 38.48119447 | -100.46607540000001 | 2022-03-29 04:20:46 | Lane, Kansas, US | |
878691 | 878691 | 2022-03-27 | US | North Dakota | Sheridan | 38083 | 295 | 7 | 0 | 47.57700669 | -100.3426391 | 2022-03-28 04:20:33 | Sheridan, North Dakota, US | |
877573 | 877573 | 2022-03-27 | US | Kansas | Lane | 20101 | 295 | 12 | 0 | 38.48119447 | -100.46607540000001 | 2022-03-28 04:20:33 | Lane, Kansas, US | |
2165974 | 2165974 | 2022-03-26 | US | North Dakota | Sheridan | 38083 | 295 | 7 | 0 | 47.57700669 | -100.3426391 | 2022-03-27 04:20:47 | Sheridan, North Dakota, US | |
2164856 | 2164856 | 2022-03-26 | US | Kansas | Lane | 20101 | 295 | 12 | 0 | 38.48119447 | -100.46607540000001 | 2022-03-27 04:20:47 | Lane, Kansas, US | |
1722910 | 1722910 | 2022-03-25 | US | North Dakota | Sheridan | 38083 | 295 | 7 | 0 | 47.57700669 | -100.3426391 | 2022-03-26 04:20:23 | Sheridan, North Dakota, US | |
1721792 | 1721792 | 2022-03-25 | US | Kansas | Lane | 20101 | 295 | 12 | 0 | 38.48119447 | -100.46607540000001 | 2022-03-26 04:20:23 | Lane, Kansas, US | |
1470527 | 1470527 | 2022-03-24 | US | North Dakota | Sheridan | 38083 | 295 | 7 | 0 | 47.57700669 | -100.3426391 | 2022-03-25 04:20:46 | Sheridan, North Dakota, US | |
1469409 | 1469409 | 2022-03-24 | US | Kansas | Lane | 20101 | 295 | 12 | 0 | 38.48119447 | -100.46607540000001 | 2022-03-25 04:20:46 | Lane, Kansas, US | |
3024701 | 3024701 | 2022-03-23 | US | North Dakota | Sheridan | 38083 | 295 | 7 | 0 | 47.57700669 | -100.3426391 | 2022-03-24 04:20:43 | Sheridan, North Dakota, US | |
3023583 | 3023583 | 2022-03-23 | US | Kansas | Lane | 20101 | 295 | 12 | 0 | 38.48119447 | -100.46607540000001 | 2022-03-24 04:20:43 | Lane, Kansas, US | |
3022547 | 3022547 | 2022-03-23 | Samoa | 295 | 0 | 0 | -13.759 | -172.1046 | 2022-03-24 04:20:43 | Samoa | ||||
1907623 | 1907623 | 2022-03-22 | US | North Dakota | Sheridan | 38083 | 295 | 7 | 0 | 47.57700669 | -100.3426391 | 2022-03-23 04:20:48 | Sheridan, North Dakota, US | |
1906505 | 1906505 | 2022-03-22 | US | Kansas | Lane | 20101 | 295 | 12 | 0 | 38.48119447 | -100.46607540000001 | 2022-03-23 04:20:48 | Lane, Kansas, US | |
1905469 | 1905469 | 2022-03-22 | Samoa | 295 | 0 | 0 | -13.759 | -172.1046 | 2022-03-23 04:20:48 | Samoa |
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]);