johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
730 rows where confirmed = 494 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 26
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3715448 | 3715448 | 2022-12-06 | US | Kansas | Comanche | 20033 | 494 | 17 | 0 | 37.1911452 | -99.27113247 | 2022-12-07 04:20:58 | Comanche, Kansas, US | |
2416153 | 2416153 | 2022-12-05 | US | Kansas | Comanche | 20033 | 494 | 17 | 0 | 37.1911452 | -99.27113247 | 2022-12-06 04:21:03 | Comanche, Kansas, US | |
719761 | 719761 | 2022-12-04 | US | Kansas | Comanche | 20033 | 494 | 17 | 0 | 37.1911452 | -99.27113247 | 2022-12-05 04:20:58 | Comanche, Kansas, US | |
2818050 | 2818050 | 2022-12-03 | US | Kansas | Comanche | 20033 | 494 | 17 | 0 | 37.1911452 | -99.27113247 | 2022-12-04 04:20:56 | Comanche, Kansas, US | |
834906 | 834906 | 2022-12-02 | US | Kansas | Comanche | 20033 | 494 | 17 | 0 | 37.1911452 | -99.27113247 | 2022-12-03 04:21:02 | Comanche, Kansas, US | |
2137436 | 2137436 | 2022-12-01 | US | Kansas | Comanche | 20033 | 494 | 17 | 0 | 37.1911452 | -99.27113247 | 2022-12-02 04:21:07 | Comanche, Kansas, US | |
1965852 | 1965852 | 2022-11-30 | US | Kansas | Comanche | 20033 | 494 | 17 | 0 | 37.1911452 | -99.27113247 | 2022-12-01 04:21:03 | Comanche, Kansas, US | |
3041410 | 3041410 | 2022-10-27 | US | Texas | Dickens | 48125 | 494 | 16 | 0 | 33.61616822 | -100.7788855 | 2022-10-28 04:22:31 | Dickens, Texas, US | |
541830 | 541830 | 2022-10-26 | US | Texas | Dickens | 48125 | 494 | 16 | 0 | 33.61616822 | -100.7788855 | 2022-10-27 04:22:01 | Dickens, Texas, US | |
1833231 | 1833231 | 2022-10-25 | US | Texas | Dickens | 48125 | 494 | 16 | 0 | 33.61616822 | -100.7788855 | 2022-10-26 04:22:19 | Dickens, Texas, US | |
797492 | 797492 | 2022-10-24 | US | Texas | Dickens | 48125 | 494 | 16 | 0 | 33.61616822 | -100.7788855 | 2022-10-25 04:21:53 | Dickens, Texas, US | |
3279947 | 3279947 | 2022-10-23 | US | Texas | Dickens | 48125 | 494 | 16 | 0 | 33.61616822 | -100.7788855 | 2022-10-24 04:22:29 | Dickens, Texas, US | |
2270985 | 2270985 | 2022-10-22 | US | Texas | Dickens | 48125 | 494 | 16 | 0 | 33.61616822 | -100.7788855 | 2022-10-23 04:22:46 | Dickens, Texas, US | |
1595285 | 1595285 | 2022-10-21 | US | Texas | Dickens | 48125 | 494 | 16 | 0 | 33.61616822 | -100.7788855 | 2022-10-22 04:22:53 | Dickens, Texas, US | |
2275001 | 2275001 | 2022-10-20 | US | Texas | Dickens | 48125 | 494 | 16 | 0 | 33.61616822 | -100.7788855 | 2022-10-21 04:22:23 | Dickens, Texas, US | |
201336 | 201336 | 2022-10-19 | US | Texas | Dickens | 48125 | 494 | 16 | 0 | 33.61616822 | -100.7788855 | 2022-10-20 04:22:59 | Dickens, Texas, US | |
2759997 | 2759997 | 2022-10-18 | US | Texas | Dickens | 48125 | 494 | 16 | 0 | 33.61616822 | -100.7788855 | 2022-10-19 04:22:26 | Dickens, Texas, US | |
2027831 | 2027831 | 2022-10-17 | US | Texas | Dickens | 48125 | 494 | 16 | 0 | 33.61616822 | -100.7788855 | 2022-10-18 04:22:42 | Dickens, Texas, US | |
2162609 | 2162609 | 2022-10-16 | US | Texas | Dickens | 48125 | 494 | 16 | 0 | 33.61616822 | -100.7788855 | 2022-10-17 04:20:31 | Dickens, Texas, US | |
518806 | 518806 | 2022-10-15 | US | Texas | Dickens | 48125 | 494 | 16 | 0 | 33.61616822 | -100.7788855 | 2022-10-16 04:22:39 | Dickens, Texas, US | |
2035863 | 2035863 | 2022-10-14 | US | Texas | Dickens | 48125 | 494 | 16 | 0 | 33.61616822 | -100.7788855 | 2022-10-15 04:22:00 | Dickens, Texas, US | |
3756551 | 3756551 | 2022-10-13 | US | Texas | Dickens | 48125 | 494 | 16 | 0 | 33.61616822 | -100.7788855 | 2022-10-14 04:22:28 | Dickens, Texas, US | |
3217376 | 3217376 | 2022-10-12 | US | Texas | Dickens | 48125 | 494 | 16 | 0 | 33.61616822 | -100.7788855 | 2022-10-13 04:22:39 | Dickens, Texas, US | |
3253225 | 3253225 | 2022-10-11 | US | Texas | Dickens | 48125 | 494 | 16 | 0 | 33.61616822 | -100.7788855 | 2022-10-12 04:22:51 | Dickens, Texas, US | |
2970484 | 2970484 | 2022-10-10 | US | Texas | Dickens | 48125 | 494 | 16 | 0 | 33.61616822 | -100.7788855 | 2022-10-11 04:23:05 | Dickens, Texas, US | |
2259572 | 2259572 | 2022-10-02 | China | Shanxi | 494 | 0 | 0 | 37.5777 | 112.2922 | 2022-10-03 04:23:11 | Shanxi, China | |||
3549909 | 3549909 | 2022-09-01 | US | North Dakota | Golden Valley | 38033 | 494 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-09-02 04:21:07 | Golden Valley, North Dakota, US | |
2345829 | 2345829 | 2022-08-31 | US | North Dakota | Golden Valley | 38033 | 494 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-09-01 04:21:03 | Golden Valley, North Dakota, US | |
3776309 | 3776309 | 2022-08-30 | US | North Dakota | Golden Valley | 38033 | 494 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-08-31 04:20:57 | Golden Valley, North Dakota, US | |
1682905 | 1682905 | 2022-08-29 | US | North Dakota | Golden Valley | 38033 | 494 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-08-30 04:21:03 | Golden Valley, North Dakota, US | |
1879389 | 1879389 | 2022-08-28 | US | North Dakota | Golden Valley | 38033 | 494 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-08-29 04:21:06 | Golden Valley, North Dakota, US | |
2098516 | 2098516 | 2022-08-27 | US | North Dakota | Golden Valley | 38033 | 494 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-08-28 04:21:02 | Golden Valley, North Dakota, US | |
1534331 | 1534331 | 2022-08-26 | US | North Dakota | Golden Valley | 38033 | 494 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-08-27 04:20:57 | Golden Valley, North Dakota, US | |
2497068 | 2497068 | 2022-08-15 | US | Texas | Briscoe | 48045 | 494 | 8 | 0 | 34.53026962 | -101.2084947 | 2022-08-16 04:20:58 | Briscoe, Texas, US | |
3432095 | 3432095 | 2022-07-14 | US | Texas | Irion | 48235 | 494 | 3 | 0 | 31.30375559 | -100.982439 | 2022-07-15 04:20:53 | Irion, Texas, US | |
3112615 | 3112615 | 2022-07-13 | US | Texas | Irion | 48235 | 494 | 3 | 0 | 31.30375559 | -100.982439 | 2022-07-14 04:20:57 | Irion, Texas, US | |
2789963 | 2789963 | 2022-07-10 | US | Idaho | Butte | 16023 | 494 | 10 | 0 | 43.72592209 | -113.1735463 | 2022-07-11 04:20:46 | Butte, Idaho, US | |
142916 | 142916 | 2022-07-09 | US | Idaho | Butte | 16023 | 494 | 10 | 0 | 43.72592209 | -113.1735463 | 2022-07-10 04:20:54 | Butte, Idaho, US | |
1418016 | 1418016 | 2022-07-08 | US | Idaho | Butte | 16023 | 494 | 10 | 0 | 43.72592209 | -113.1735463 | 2022-07-09 04:20:59 | Butte, Idaho, US | |
1202888 | 1202888 | 2022-07-06 | US | Texas | Edwards | 48137 | 494 | 11 | 0 | 29.98202582 | -100.304252 | 2022-07-07 04:20:55 | Edwards, Texas, US | |
3969631 | 3969631 | 2022-07-05 | US | Texas | Edwards | 48137 | 494 | 11 | 0 | 29.98202582 | -100.304252 | 2022-07-06 04:20:58 | Edwards, Texas, US | |
3579285 | 3579285 | 2022-06-02 | US | Colorado | Sedgwick | 8115 | 494 | 10 | 0 | 40.87595412 | -102.3519227 | 2022-06-03 04:20:58 | Sedgwick, Colorado, US | |
971578 | 971578 | 2022-06-01 | US | Colorado | Sedgwick | 8115 | 494 | 10 | 0 | 40.87595412 | -102.3519227 | 2022-06-02 05:20:39 | Sedgwick, Colorado, US | |
230589 | 230589 | 2022-05-31 | US | Kansas | Wichita | 20203 | 494 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-06-01 04:20:55 | Wichita, Kansas, US | |
3187354 | 3187354 | 2022-05-30 | US | Kansas | Wichita | 20203 | 494 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-05-31 04:20:51 | Wichita, Kansas, US | |
3199503 | 3199503 | 2022-05-29 | US | Kansas | Wichita | 20203 | 494 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-05-30 04:20:50 | Wichita, Kansas, US | |
2726381 | 2726381 | 2022-05-28 | US | Kansas | Wichita | 20203 | 494 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-05-29 04:20:53 | Wichita, Kansas, US | |
1315562 | 1315562 | 2022-05-27 | US | Kansas | Wichita | 20203 | 494 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-05-28 04:21:07 | Wichita, Kansas, US | |
1851354 | 1851354 | 2022-05-26 | US | Kansas | Wichita | 20203 | 494 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-05-27 04:20:56 | Wichita, Kansas, US | |
2049230 | 2049230 | 2022-05-25 | US | Kansas | Wichita | 20203 | 494 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-05-26 04:20:50 | Wichita, Kansas, US | |
623241 | 623241 | 2022-05-22 | US | Kansas | Wichita | 20203 | 494 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-05-26 04:20:50 | Wichita, Kansas, US | |
1906558 | 1906558 | 2022-03-22 | US | Kansas | Wichita | 20203 | 494 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-03-23 04:20:48 | Wichita, Kansas, US | |
3239689 | 3239689 | 2022-03-21 | US | Kansas | Wichita | 20203 | 494 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-03-22 04:20:54 | Wichita, Kansas, US | |
25762 | 25762 | 2022-03-20 | US | Kansas | Wichita | 20203 | 494 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-03-21 04:20:50 | Wichita, Kansas, US | |
1657772 | 1657772 | 2022-03-19 | US | Kansas | Wichita | 20203 | 494 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-03-20 04:20:45 | Wichita, Kansas, US | |
337298 | 337298 | 2022-03-18 | US | Kansas | Wichita | 20203 | 494 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-03-19 04:20:47 | Wichita, Kansas, US | |
695751 | 695751 | 2022-03-17 | US | Kansas | Wichita | 20203 | 494 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-03-18 04:20:55 | Wichita, Kansas, US | |
2320694 | 2320694 | 2022-03-16 | US | Kansas | Wichita | 20203 | 494 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-03-17 04:20:56 | Wichita, Kansas, US | |
262894 | 262894 | 2022-03-15 | US | Kansas | Wichita | 20203 | 494 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-03-16 04:20:50 | Wichita, Kansas, US | |
2265253 | 2265253 | 2022-03-14 | US | Kansas | Wichita | 20203 | 494 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-03-15 04:20:47 | Wichita, Kansas, US | |
3629319 | 3629319 | 2022-03-13 | US | Kansas | Wichita | 20203 | 494 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-03-14 04:20:46 | Wichita, Kansas, US | |
952227 | 952227 | 2022-03-12 | US | Kansas | Wichita | 20203 | 494 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-03-13 04:20:49 | Wichita, Kansas, US | |
357688 | 357688 | 2022-03-11 | US | Kansas | Wichita | 20203 | 494 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-03-12 04:20:50 | Wichita, Kansas, US | |
1866840 | 1866840 | 2022-03-10 | US | Kansas | Wichita | 20203 | 494 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-03-11 04:20:50 | Wichita, Kansas, US | |
2141535 | 2141535 | 2022-03-09 | US | Kansas | Wichita | 20203 | 494 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-03-10 04:20:48 | Wichita, Kansas, US | |
921046 | 921046 | 2022-03-08 | US | Kansas | Wichita | 20203 | 494 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-03-09 04:20:59 | Wichita, Kansas, US | |
1549333 | 1549333 | 2022-03-07 | US | Kansas | Wichita | 20203 | 494 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-03-08 04:20:54 | Wichita, Kansas, US | |
2201002 | 2201002 | 2022-03-06 | US | Kansas | Wichita | 20203 | 494 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-03-07 04:20:47 | Wichita, Kansas, US | |
2093459 | 2093459 | 2022-03-05 | US | Kansas | Wichita | 20203 | 494 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-03-06 04:20:49 | Wichita, Kansas, US | |
2667159 | 2667159 | 2022-03-04 | US | Kansas | Wichita | 20203 | 494 | 8 | 0 | 38.48178252 | -101.3471509 | 2022-03-05 04:21:10 | Wichita, Kansas, US | |
1060866 | 1060866 | 2022-02-23 | US | Texas | Armstrong | 48011 | 494 | 8 | 0 | 34.96507426 | -101.35748740000001 | 2022-02-24 04:21:14 | Armstrong, Texas, US | |
2449789 | 2449789 | 2022-02-22 | US | Texas | Armstrong | 48011 | 494 | 8 | 0 | 34.96507426 | -101.35748740000001 | 2022-02-23 04:21:09 | Armstrong, Texas, US | |
3721202 | 3721202 | 2022-02-21 | US | Texas | Armstrong | 48011 | 494 | 8 | 0 | 34.96507426 | -101.35748740000001 | 2022-02-22 04:21:01 | Armstrong, Texas, US | |
1300459 | 1300459 | 2022-02-17 | US | North Dakota | Kidder | 38043 | 494 | 13 | 0 | 46.97830064 | -99.77507857 | 2022-02-18 04:21:04 | Kidder, North Dakota, US | |
2643838 | 2643838 | 2022-02-14 | US | Nebraska | Hitchcock | 31087 | 494 | 5 | 0 | 40.17609175 | -101.04164770000001 | 2022-02-15 04:21:09 | Hitchcock, Nebraska, US | |
188155 | 188155 | 2022-02-13 | US | Nebraska | Hitchcock | 31087 | 494 | 5 | 0 | 40.17609175 | -101.04164770000001 | 2022-02-14 04:20:51 | Hitchcock, Nebraska, US | |
318001 | 318001 | 2022-02-12 | US | Nebraska | Hitchcock | 31087 | 494 | 5 | 0 | 40.17609175 | -101.04164770000001 | 2022-02-13 04:21:00 | Hitchcock, Nebraska, US | |
235327 | 235327 | 2022-02-11 | US | Nebraska | Hitchcock | 31087 | 494 | 5 | 0 | 40.17609175 | -101.04164770000001 | 2022-02-12 04:21:06 | Hitchcock, Nebraska, US | |
3076130 | 3076130 | 2022-02-09 | US | Nebraska | Hitchcock | 31087 | 494 | 5 | 0 | 40.17609175 | -101.04164770000001 | 2022-02-10 04:21:14 | Hitchcock, Nebraska, US | |
73175 | 73175 | 2022-02-07 | US | Nebraska | Hitchcock | 31087 | 494 | 5 | 0 | 40.17609175 | -101.04164770000001 | 2022-02-08 04:21:15 | Hitchcock, Nebraska, US | |
1320287 | 1320287 | 2022-01-26 | US | Nebraska | Frontier | 31063 | 494 | 1 | 0 | 40.52993007 | -100.3924658 | 2022-01-27 04:21:19 | Frontier, Nebraska, US | |
2052633 | 2052633 | 2022-01-25 | US | Georgia | Baker | 13007 | 494 | 14 | 0 | 31.32669878 | -84.44218806 | 2022-01-26 04:21:07 | Baker, Georgia, US | |
3467367 | 3467367 | 2022-01-18 | US | Texas | Oldham | 48359 | 494 | 6 | 0 | 35.40425596 | -102.6027606 | 2022-01-19 04:21:23 | Oldham, Texas, US | |
1472000 | 1472000 | 2022-01-17 | France | Saint Pierre and Miquelon | 494 | 0 | 0 | 46.8852 | -56.3159 | 2022-01-18 04:21:04 | Saint Pierre and Miquelon, France | |||
3689603 | 3689603 | 2022-01-13 | US | Nebraska | Sherman | 31163 | 494 | 4 | 0 | 41.22045983 | -98.97588642 | 2022-01-14 04:21:54 | Sherman, Nebraska, US | |
1694750 | 1694750 | 2022-01-10 | US | North Dakota | Towner | 38095 | 494 | 11 | 0 | 48.68565745 | -99.24564265 | 2022-01-11 04:22:01 | Towner, North Dakota, US | |
129646 | 129646 | 2022-01-09 | US | South Dakota | Ziebach | 46137 | 494 | 11 | 0 | 44.97881876 | -101.6654622 | 2022-01-10 04:22:07 | Ziebach, South Dakota, US | |
1218481 | 1218481 | 2022-01-08 | US | South Dakota | Ziebach | 46137 | 494 | 11 | 0 | 44.97881876 | -101.6654622 | 2022-01-09 04:21:46 | Ziebach, South Dakota, US | |
1392574 | 1392574 | 2022-01-07 | US | South Dakota | Ziebach | 46137 | 494 | 11 | 0 | 44.97881876 | -101.6654622 | 2022-01-08 04:21:53 | Ziebach, South Dakota, US | |
3522890 | 3522890 | 2022-01-02 | US | Washington | San Juan | 53055 | 494 | 0 | 0 | 48.60182783 | -122.96745 | 2022-01-03 02:22:25 | San Juan, Washington, US | |
2171020 | 2171020 | 2022-01-01 | US | Washington | San Juan | 53055 | 494 | 0 | 0 | 48.60182783 | -122.96745 | 2022-01-02 04:20:52 | San Juan, Washington, US | |
2780451 | 2780451 | 2021-12-31 | US | Washington | San Juan | 53055 | 494 | 0 | 0 | 48.60182783 | -122.96745 | 2022-01-01 04:22:14 | San Juan, Washington, US | |
4002108 | 4002108 | 2021-12-30 | US | Washington | San Juan | 53055 | 494 | 0 | 0 | 48.60182783 | -122.96745 | 2021-12-31 04:21:50 | San Juan, Washington, US | |
1257649 | 1257649 | 2021-12-20 | US | South Dakota | Hanson | 46061 | 494 | 5 | 0 | 43.6746384 | -97.78715148 | 2021-12-21 03:21:27 | Hanson, South Dakota, US | |
2906592 | 2906592 | 2021-12-19 | US | South Dakota | Hanson | 46061 | 494 | 5 | 0 | 43.6746384 | -97.78715148 | 2021-12-20 04:21:43 | Hanson, South Dakota, US | |
2904328 | 2904328 | 2021-12-19 | US | Colorado | Custer | 8027 | 494 | 14 | 0 | 38.10883162 | -105.3683478 | 2021-12-20 04:21:43 | Custer, Colorado, US | |
1261665 | 1261665 | 2021-12-18 | US | South Dakota | Hanson | 46061 | 494 | 5 | 0 | 43.6746384 | -97.78715148 | 2021-12-19 04:21:11 | Hanson, South Dakota, US | |
1259401 | 1259401 | 2021-12-18 | US | Colorado | Custer | 8027 | 494 | 14 | 0 | 38.10883162 | -105.3683478 | 2021-12-19 04:21:11 | Custer, Colorado, US | |
2401693 | 2401693 | 2021-12-17 | US | South Dakota | Hanson | 46061 | 494 | 5 | 0 | 43.6746384 | -97.78715148 | 2021-12-18 02:22:20 | Hanson, South Dakota, US | |
2399429 | 2399429 | 2021-12-17 | US | Colorado | Custer | 8027 | 494 | 14 | 0 | 38.10883162 | -105.3683478 | 2021-12-18 02:22:20 | Custer, Colorado, 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]);