johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
536 rows where confirmed = 886 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
330758 | 330758 | 2022-12-27 | US | South Dakota | Aurora | 46003 | 886 | 18 | 0 | 43.71757685 | -98.56050467 | 2022-12-28 04:21:04 | Aurora, South Dakota, US | |
220831 | 220831 | 2022-12-26 | US | South Dakota | Aurora | 46003 | 886 | 18 | 0 | 43.71757685 | -98.56050467 | 2022-12-27 04:21:07 | Aurora, South Dakota, US | |
3225288 | 3225288 | 2022-12-25 | US | South Dakota | Aurora | 46003 | 886 | 18 | 0 | 43.71757685 | -98.56050467 | 2022-12-26 04:21:06 | Aurora, South Dakota, US | |
1021202 | 1021202 | 2022-12-24 | US | South Dakota | Aurora | 46003 | 886 | 18 | 0 | 43.71757685 | -98.56050467 | 2022-12-25 04:21:04 | Aurora, South Dakota, US | |
693225 | 693225 | 2022-12-23 | US | South Dakota | Aurora | 46003 | 886 | 18 | 0 | 43.71757685 | -98.56050467 | 2022-12-24 04:21:02 | Aurora, South Dakota, US | |
2182435 | 2182435 | 2022-12-22 | US | South Dakota | Aurora | 46003 | 886 | 18 | 0 | 43.71757685 | -98.56050467 | 2022-12-23 04:21:04 | Aurora, South Dakota, US | |
454239 | 454239 | 2022-12-21 | US | South Dakota | Aurora | 46003 | 886 | 18 | 0 | 43.71757685 | -98.56050467 | 2022-12-22 04:20:56 | Aurora, South Dakota, US | |
2954238 | 2954238 | 2022-12-20 | US | South Dakota | Aurora | 46003 | 886 | 18 | 0 | 43.71757685 | -98.56050467 | 2022-12-21 04:21:03 | Aurora, South Dakota, US | |
2952747 | 2952747 | 2022-12-20 | US | Kansas | Trego | 20195 | 886 | 13 | 0 | 38.91467218 | -99.87284448 | 2022-12-21 04:21:03 | Trego, Kansas, US | |
3176640 | 3176640 | 2022-12-19 | US | South Dakota | Aurora | 46003 | 886 | 18 | 0 | 43.71757685 | -98.56050467 | 2022-12-20 04:21:04 | Aurora, South Dakota, US | |
3175149 | 3175149 | 2022-12-19 | US | Kansas | Trego | 20195 | 886 | 13 | 0 | 38.91467218 | -99.87284448 | 2022-12-20 04:21:04 | Trego, Kansas, US | |
1631157 | 1631157 | 2022-12-18 | US | South Dakota | Aurora | 46003 | 886 | 18 | 0 | 43.71757685 | -98.56050467 | 2022-12-19 04:21:03 | Aurora, South Dakota, US | |
1629666 | 1629666 | 2022-12-18 | US | Kansas | Trego | 20195 | 886 | 13 | 0 | 38.91467218 | -99.87284448 | 2022-12-19 04:21:03 | Trego, Kansas, US | |
506536 | 506536 | 2022-12-17 | US | South Dakota | Aurora | 46003 | 886 | 18 | 0 | 43.71757685 | -98.56050467 | 2022-12-18 04:21:03 | Aurora, South Dakota, US | |
505045 | 505045 | 2022-12-17 | US | Kansas | Trego | 20195 | 886 | 13 | 0 | 38.91467218 | -99.87284448 | 2022-12-18 04:21:03 | Trego, Kansas, US | |
3327108 | 3327108 | 2022-12-16 | US | South Dakota | Aurora | 46003 | 886 | 18 | 0 | 43.71757685 | -98.56050467 | 2022-12-17 04:21:04 | Aurora, South Dakota, US | |
3325617 | 3325617 | 2022-12-16 | US | Kansas | Trego | 20195 | 886 | 13 | 0 | 38.91467218 | -99.87284448 | 2022-12-17 04:21:04 | Trego, Kansas, US | |
545620 | 545620 | 2022-12-15 | US | South Dakota | Aurora | 46003 | 886 | 18 | 0 | 43.71757685 | -98.56050467 | 2022-12-16 04:21:01 | Aurora, South Dakota, US | |
544129 | 544129 | 2022-12-15 | US | Kansas | Trego | 20195 | 886 | 13 | 0 | 38.91467218 | -99.87284448 | 2022-12-16 04:21:01 | Trego, Kansas, US | |
351148 | 351148 | 2022-12-14 | US | South Dakota | Aurora | 46003 | 886 | 18 | 0 | 43.71757685 | -98.56050467 | 2022-12-15 04:20:58 | Aurora, South Dakota, US | |
349657 | 349657 | 2022-12-14 | US | Kansas | Trego | 20195 | 886 | 13 | 0 | 38.91467218 | -99.87284448 | 2022-12-15 04:20:58 | Trego, Kansas, US | |
2417295 | 2417295 | 2022-12-05 | US | North Dakota | Nelson | 38063 | 886 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-12-06 04:21:03 | Nelson, North Dakota, US | |
720903 | 720903 | 2022-12-04 | US | North Dakota | Nelson | 38063 | 886 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-12-05 04:20:58 | Nelson, North Dakota, US | |
2819192 | 2819192 | 2022-12-03 | US | North Dakota | Nelson | 38063 | 886 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-12-04 04:20:56 | Nelson, North Dakota, US | |
836048 | 836048 | 2022-12-02 | US | North Dakota | Nelson | 38063 | 886 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-12-03 04:21:02 | Nelson, North Dakota, US | |
713344 | 713344 | 2022-11-01 | US | South Dakota | Marshall | 46091 | 886 | 15 | 0 | 45.75870838 | -97.59855639 | 2022-11-02 04:22:09 | Marshall, South Dakota, US | |
3287793 | 3287793 | 2022-10-31 | US | South Dakota | Marshall | 46091 | 886 | 15 | 0 | 45.75870838 | -97.59855639 | 2022-11-01 04:22:36 | Marshall, South Dakota, US | |
322826 | 322826 | 2022-10-30 | US | South Dakota | Marshall | 46091 | 886 | 15 | 0 | 45.75870838 | -97.59855639 | 2022-10-31 04:21:36 | Marshall, South Dakota, US | |
915102 | 915102 | 2022-10-29 | US | South Dakota | Marshall | 46091 | 886 | 15 | 0 | 45.75870838 | -97.59855639 | 2022-10-30 04:22:14 | Marshall, South Dakota, US | |
1369371 | 1369371 | 2022-10-28 | US | South Dakota | Marshall | 46091 | 886 | 15 | 0 | 45.75870838 | -97.59855639 | 2022-10-29 04:21:13 | Marshall, South Dakota, US | |
3041226 | 3041226 | 2022-10-27 | US | South Dakota | Marshall | 46091 | 886 | 15 | 0 | 45.75870838 | -97.59855639 | 2022-10-28 04:22:31 | Marshall, South Dakota, US | |
541646 | 541646 | 2022-10-26 | US | South Dakota | Marshall | 46091 | 886 | 15 | 0 | 45.75870838 | -97.59855639 | 2022-10-27 04:22:01 | Marshall, South Dakota, US | |
3277484 | 3277484 | 2022-10-23 | US | Colorado | Costilla | 8023 | 886 | 19 | 0 | 37.27732493 | -105.4276548 | 2022-10-24 04:22:29 | Costilla, Colorado, US | |
2268522 | 2268522 | 2022-10-22 | US | Colorado | Costilla | 8023 | 886 | 19 | 0 | 37.27732493 | -105.4276548 | 2022-10-23 04:22:46 | Costilla, Colorado, US | |
1592822 | 1592822 | 2022-10-21 | US | Colorado | Costilla | 8023 | 886 | 19 | 0 | 37.27732493 | -105.4276548 | 2022-10-22 04:22:53 | Costilla, Colorado, US | |
2758265 | 2758265 | 2022-10-18 | US | Kansas | Rush | 20165 | 886 | 20 | 0 | 38.52275276 | -99.30863983 | 2022-10-19 04:22:26 | Rush, Kansas, US | |
2026099 | 2026099 | 2022-10-17 | US | Kansas | Rush | 20165 | 886 | 20 | 0 | 38.52275276 | -99.30863983 | 2022-10-18 04:22:42 | Rush, Kansas, US | |
2160877 | 2160877 | 2022-10-16 | US | Kansas | Rush | 20165 | 886 | 20 | 0 | 38.52275276 | -99.30863983 | 2022-10-17 04:20:31 | Rush, Kansas, US | |
2160146 | 2160146 | 2022-10-16 | US | Colorado | Costilla | 8023 | 886 | 19 | 0 | 37.27732493 | -105.4276548 | 2022-10-17 04:20:31 | Costilla, Colorado, US | |
517074 | 517074 | 2022-10-15 | US | Kansas | Rush | 20165 | 886 | 20 | 0 | 38.52275276 | -99.30863983 | 2022-10-16 04:22:39 | Rush, Kansas, US | |
516343 | 516343 | 2022-10-15 | US | Colorado | Costilla | 8023 | 886 | 19 | 0 | 37.27732493 | -105.4276548 | 2022-10-16 04:22:39 | Costilla, Colorado, US | |
2034131 | 2034131 | 2022-10-14 | US | Kansas | Rush | 20165 | 886 | 20 | 0 | 38.52275276 | -99.30863983 | 2022-10-15 04:22:00 | Rush, Kansas, US | |
2033400 | 2033400 | 2022-10-14 | US | Colorado | Costilla | 8023 | 886 | 19 | 0 | 37.27732493 | -105.4276548 | 2022-10-15 04:22:00 | Costilla, Colorado, US | |
3754819 | 3754819 | 2022-10-13 | US | Kansas | Rush | 20165 | 886 | 20 | 0 | 38.52275276 | -99.30863983 | 2022-10-14 04:22:28 | Rush, Kansas, US | |
3215644 | 3215644 | 2022-10-12 | US | Kansas | Rush | 20165 | 886 | 20 | 0 | 38.52275276 | -99.30863983 | 2022-10-13 04:22:39 | Rush, Kansas, US | |
3769109 | 3769109 | 2022-09-11 | US | Texas | Sutton | 48435 | 886 | 14 | 0 | 30.49856623 | -100.5382014 | 2022-09-12 04:20:58 | Sutton, Texas, US | |
3827684 | 3827684 | 2022-09-10 | US | Texas | Sutton | 48435 | 886 | 14 | 0 | 30.49856623 | -100.5382014 | 2022-09-11 04:20:50 | Sutton, Texas, US | |
966141 | 966141 | 2022-09-09 | US | Texas | Sutton | 48435 | 886 | 14 | 0 | 30.49856623 | -100.5382014 | 2022-09-10 04:21:10 | Sutton, Texas, US | |
256543 | 256543 | 2022-09-08 | US | Texas | Sutton | 48435 | 886 | 14 | 0 | 30.49856623 | -100.5382014 | 2022-09-09 04:21:11 | Sutton, Texas, US | |
1879378 | 1879378 | 2022-08-28 | US | North Dakota | Bowman | 38011 | 886 | 9 | 0 | 46.11285362 | -103.5203343 | 2022-08-29 04:21:06 | Bowman, North Dakota, US | |
2098505 | 2098505 | 2022-08-27 | US | North Dakota | Bowman | 38011 | 886 | 9 | 0 | 46.11285362 | -103.5203343 | 2022-08-28 04:21:02 | Bowman, North Dakota, US | |
1534320 | 1534320 | 2022-08-26 | US | North Dakota | Bowman | 38011 | 886 | 9 | 0 | 46.11285362 | -103.5203343 | 2022-08-27 04:20:57 | Bowman, North Dakota, US | |
2325901 | 2325901 | 2022-08-24 | US | Oklahoma | Ellis | 40045 | 886 | 11 | 0 | 36.2180194 | -99.75324573 | 2022-08-25 04:21:13 | Ellis, Oklahoma, US | |
1253310 | 1253310 | 2022-08-23 | US | Oklahoma | Ellis | 40045 | 886 | 11 | 0 | 36.2180194 | -99.75324573 | 2022-08-24 04:20:46 | Ellis, Oklahoma, US | |
2855414 | 2855414 | 2022-08-22 | US | Oklahoma | Ellis | 40045 | 886 | 11 | 0 | 36.2180194 | -99.75324573 | 2022-08-23 04:20:56 | Ellis, Oklahoma, US | |
2405386 | 2405386 | 2022-08-21 | US | Oklahoma | Ellis | 40045 | 886 | 11 | 0 | 36.2180194 | -99.75324573 | 2022-08-22 04:20:38 | Ellis, Oklahoma, US | |
3800464 | 3800464 | 2022-08-20 | US | Oklahoma | Ellis | 40045 | 886 | 11 | 0 | 36.2180194 | -99.75324573 | 2022-08-21 04:20:44 | Ellis, Oklahoma, US | |
2366050 | 2366050 | 2022-08-19 | US | Oklahoma | Ellis | 40045 | 886 | 11 | 0 | 36.2180194 | -99.75324573 | 2022-08-20 04:21:01 | Ellis, Oklahoma, US | |
1163721 | 1163721 | 2022-08-18 | US | Oklahoma | Ellis | 40045 | 886 | 11 | 0 | 36.2180194 | -99.75324573 | 2022-08-19 04:20:54 | Ellis, Oklahoma, US | |
1348599 | 1348599 | 2022-08-10 | US | New York | Unassigned | 90036 | 886 | 2 | 0 | 44.74530905 | 0.0 | 2022-08-11 04:20:49 | Unassigned, New York, US | |
1610468 | 1610468 | 2022-07-20 | US | New Mexico | Mora | 35033 | 886 | 20 | 0 | 36.01095101 | -104.9497716 | 2022-07-21 04:21:10 | Mora, New Mexico, US | |
2311906 | 2311906 | 2022-06-17 | US | Colorado | Baca | 8009 | 886 | 14 | 0 | 37.31940883 | -102.5603223 | 2022-06-18 04:21:10 | Baca, Colorado, US | |
559410 | 559410 | 2022-06-16 | US | Colorado | Baca | 8009 | 886 | 14 | 0 | 37.31940883 | -102.5603223 | 2022-06-17 04:20:56 | Baca, Colorado, US | |
3983212 | 3983212 | 2022-06-15 | US | Colorado | Baca | 8009 | 886 | 14 | 0 | 37.31940883 | -102.5603223 | 2022-06-16 04:20:55 | Baca, Colorado, US | |
947453 | 947453 | 2022-06-14 | US | Colorado | Baca | 8009 | 886 | 14 | 0 | 37.31940883 | -102.5603223 | 2022-06-15 04:20:54 | Baca, Colorado, US | |
2979861 | 2979861 | 2022-06-13 | US | Colorado | Baca | 8009 | 886 | 14 | 0 | 37.31940883 | -102.5603223 | 2022-06-14 04:20:52 | Baca, Colorado, US | |
2029414 | 2029414 | 2022-04-24 | US | Colorado | Ouray | 8091 | 886 | 6 | 0 | 38.14717457 | -107.7675136 | 2022-04-25 04:20:56 | Ouray, Colorado, US | |
746989 | 746989 | 2022-04-23 | US | Colorado | Ouray | 8091 | 886 | 6 | 0 | 38.14717457 | -107.7675136 | 2022-04-24 04:20:56 | Ouray, Colorado, US | |
3437474 | 3437474 | 2022-04-22 | US | Colorado | Ouray | 8091 | 886 | 6 | 0 | 38.14717457 | -107.7675136 | 2022-04-23 04:20:50 | Ouray, Colorado, US | |
2893059 | 2893059 | 2022-04-21 | US | Colorado | Ouray | 8091 | 886 | 6 | 0 | 38.14717457 | -107.7675136 | 2022-04-22 04:20:45 | Ouray, Colorado, US | |
2307931 | 2307931 | 2022-04-20 | US | Colorado | Ouray | 8091 | 886 | 6 | 0 | 38.14717457 | -107.7675136 | 2022-04-21 04:20:46 | Ouray, Colorado, US | |
2253666 | 2253666 | 2022-04-19 | US | New York | Hamilton | 36041 | 886 | 5 | 0 | 43.66146647 | -74.49721957 | 2022-04-20 04:20:45 | Hamilton, New York, US | |
2252070 | 2252070 | 2022-04-19 | US | Colorado | Ouray | 8091 | 886 | 6 | 0 | 38.14717457 | -107.7675136 | 2022-04-20 04:20:45 | Ouray, Colorado, US | |
1849026 | 1849026 | 2022-04-18 | US | Texas | Cochran | 48079 | 886 | 23 | 0 | 33.60425307 | -102.82844990000001 | 2022-04-19 04:21:00 | Cochran, Texas, US | |
1846620 | 1846620 | 2022-04-18 | US | Colorado | Ouray | 8091 | 886 | 6 | 0 | 38.14717457 | -107.7675136 | 2022-04-19 04:21:00 | Ouray, Colorado, US | |
3417564 | 3417564 | 2022-04-17 | US | Colorado | Ouray | 8091 | 886 | 6 | 0 | 38.14717457 | -107.7675136 | 2022-04-18 04:21:12 | Ouray, Colorado, US | |
1514523 | 1514523 | 2022-02-24 | US | Texas | Haskell | 48207 | 886 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-02-25 04:21:11 | Haskell, Texas, US | |
1060964 | 1060964 | 2022-02-23 | US | Texas | Haskell | 48207 | 886 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-02-24 04:21:14 | Haskell, Texas, US | |
2449887 | 2449887 | 2022-02-22 | US | Texas | Haskell | 48207 | 886 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-02-23 04:21:09 | Haskell, Texas, US | |
3721300 | 3721300 | 2022-02-21 | US | Texas | Haskell | 48207 | 886 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-02-22 04:21:01 | Haskell, Texas, US | |
3915134 | 3915134 | 2022-02-20 | US | Texas | Haskell | 48207 | 886 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-02-21 04:21:05 | Haskell, Texas, US | |
3878692 | 3878692 | 2022-02-19 | US | Texas | Haskell | 48207 | 886 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-02-20 04:21:00 | Haskell, Texas, US | |
3858948 | 3858948 | 2022-02-18 | US | Texas | Haskell | 48207 | 886 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-02-19 04:21:11 | Haskell, Texas, US | |
2475713 | 2475713 | 2022-02-03 | US | Minnesota | Red Lake | 27125 | 886 | 11 | 0 | 47.87197525 | -96.09561104 | 2022-02-04 04:21:10 | Red Lake, Minnesota, US | |
461485 | 461485 | 2022-02-02 | US | Nebraska | Nuckolls | 31129 | 886 | 11 | 0 | 40.17637905 | -98.04743961 | 2022-02-03 04:21:21 | Nuckolls, Nebraska, US | |
2658467 | 2658467 | 2022-01-31 | US | Delaware | Unassigned | 90010 | 886 | 0 | 0 | 39.57992638 | 0.0 | 2022-02-01 04:21:11 | Unassigned, Delaware, US | |
3300884 | 3300884 | 2022-01-30 | US | Delaware | Unassigned | 90010 | 886 | 0 | 0 | 39.57992638 | 0.0 | 2022-01-31 04:21:09 | Unassigned, Delaware, US | |
3062675 | 3062675 | 2022-01-29 | US | Delaware | Unassigned | 90010 | 886 | 0 | 0 | 39.57992638 | 0.0 | 2022-01-30 04:21:26 | Unassigned, Delaware, US | |
3810609 | 3810609 | 2022-01-28 | US | Delaware | Unassigned | 90010 | 886 | 0 | 0 | 39.57992638 | 0.0 | 2022-01-29 04:21:10 | Unassigned, Delaware, US | |
2054283 | 2054283 | 2022-01-25 | US | North Dakota | Foster | 38031 | 886 | 20 | 0 | 47.457108399999996 | -98.88279923 | 2022-01-26 04:21:07 | Foster, North Dakota, US | |
1230720 | 1230720 | 2022-01-24 | US | Texas | Hall | 48191 | 886 | 19 | 0 | 34.5307555 | -100.68138520000001 | 2022-01-25 04:21:05 | Hall, Texas, US | |
3467042 | 3467042 | 2022-01-18 | US | South Dakota | Deuel | 46039 | 886 | 12 | 0 | 44.75994309 | -96.66943645 | 2022-01-19 04:21:23 | Deuel, South Dakota, US | |
1474981 | 1474981 | 2022-01-17 | US | South Dakota | Deuel | 46039 | 886 | 12 | 0 | 44.75994309 | -96.66943645 | 2022-01-18 04:21:04 | Deuel, South Dakota, US | |
1474136 | 1474136 | 2022-01-17 | US | Montana | Pondera | 30073 | 886 | 6 | 0 | 48.22773388 | -112.22527029999999 | 2022-01-18 04:21:04 | Pondera, Montana, US | |
557655 | 557655 | 2022-01-16 | US | South Dakota | Deuel | 46039 | 886 | 12 | 0 | 44.75994309 | -96.66943645 | 2022-01-17 04:21:08 | Deuel, South Dakota, US | |
556810 | 556810 | 2022-01-16 | US | Montana | Pondera | 30073 | 886 | 6 | 0 | 48.22773388 | -112.22527029999999 | 2022-01-17 04:21:08 | Pondera, Montana, US | |
3843376 | 3843376 | 2022-01-15 | US | South Dakota | Deuel | 46039 | 886 | 12 | 0 | 44.75994309 | -96.66943645 | 2022-01-16 04:21:12 | Deuel, South Dakota, US | |
3842531 | 3842531 | 2022-01-15 | US | Montana | Pondera | 30073 | 886 | 6 | 0 | 48.22773388 | -112.22527029999999 | 2022-01-16 04:21:12 | Pondera, Montana, US | |
102191 | 102191 | 2022-01-14 | US | South Dakota | Deuel | 46039 | 886 | 12 | 0 | 44.75994309 | -96.66943645 | 2022-01-15 04:21:07 | Deuel, South Dakota, US | |
101346 | 101346 | 2022-01-14 | US | Montana | Pondera | 30073 | 886 | 6 | 0 | 48.22773388 | -112.22527029999999 | 2022-01-15 04:21:07 | Pondera, Montana, 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]);