johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
831 rows where confirmed = 338 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 20
- US 775
- Japan 14
- China 9
- Russia 4
- United Kingdom 4
- Brunei 3
- Ukraine 3
- Canada 2
- India 2
- Mainland China 2
- Malaysia 2
- Sierra Leone 2
- Uruguay 2
- Chile 1
- France 1
- Mongolia 1
- New Zealand 1
- Peru 1
- Syria 1
- Togo 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3597225 | 3597225 | 2022-11-14 | Peru | Unknown | 338 | 8 | 0 | 2022-11-15 04:21:16 | Unknown, Peru | |||||
373509 | 373509 | 2022-09-13 | US | Kansas | Lane | 20101 | 338 | 12 | 0 | 38.48119447 | -100.4660754 | 2022-09-14 04:20:44 | Lane, Kansas, US | |
2396111 | 2396111 | 2022-09-12 | US | Kansas | Lane | 20101 | 338 | 12 | 0 | 38.48119447 | -100.4660754 | 2022-09-13 04:20:57 | Lane, Kansas, US | |
3767189 | 3767189 | 2022-09-11 | US | Kansas | Lane | 20101 | 338 | 12 | 0 | 38.48119447 | -100.4660754 | 2022-09-12 04:20:58 | Lane, Kansas, US | |
3825764 | 3825764 | 2022-09-10 | US | Kansas | Lane | 20101 | 338 | 12 | 0 | 38.48119447 | -100.4660754 | 2022-09-11 04:20:50 | Lane, Kansas, US | |
964221 | 964221 | 2022-09-09 | US | Kansas | Lane | 20101 | 338 | 12 | 0 | 38.48119447 | -100.4660754 | 2022-09-10 04:21:10 | Lane, Kansas, US | |
254623 | 254623 | 2022-09-08 | US | Kansas | Lane | 20101 | 338 | 12 | 0 | 38.48119447 | -100.4660754 | 2022-09-09 04:21:11 | Lane, Kansas, US | |
3746421 | 3746421 | 2022-09-07 | US | Kansas | Lane | 20101 | 338 | 12 | 0 | 38.48119447 | -100.4660754 | 2022-09-08 04:21:02 | Lane, Kansas, US | |
672718 | 672718 | 2022-07-21 | US | North Dakota | Oliver | 38065 | 338 | 5 | 0 | 47.11530482 | -101.3406158 | 2022-07-22 04:21:15 | Oliver, North Dakota, US | |
2242036 | 2242036 | 2022-06-28 | US | Oregon | Sherman | 41055 | 338 | 6 | 0 | 45.41501554 | -120.6827834 | 2022-06-29 04:20:59 | Sherman, Oregon, US | |
941556 | 941556 | 2022-06-25 | US | Puerto Rico | Culebra | 72049 | 338 | 0 | 0 | 18.31586 | -65.28813 | 2022-06-26 04:21:02 | Culebra, Puerto Rico, US | |
3348708 | 3348708 | 2022-06-24 | US | Nebraska | Dundy | 31057 | 338 | 6 | 0 | 40.17638677 | -101.6876522 | 2022-06-25 04:20:57 | Dundy, Nebraska, US | |
1650449 | 1650449 | 2022-06-23 | US | Nebraska | Dundy | 31057 | 338 | 6 | 0 | 40.17638677 | -101.6876522 | 2022-06-24 04:20:58 | Dundy, Nebraska, US | |
2189684 | 2189684 | 2022-06-22 | US | Nebraska | Dundy | 31057 | 338 | 6 | 0 | 40.17638677 | -101.6876522 | 2022-06-23 04:20:55 | Dundy, Nebraska, US | |
168115 | 168115 | 2022-06-21 | US | Nebraska | Dundy | 31057 | 338 | 6 | 0 | 40.17638677 | -101.6876522 | 2022-06-22 04:20:54 | Dundy, Nebraska, US | |
1765398 | 1765398 | 2022-06-20 | US | Nebraska | Dundy | 31057 | 338 | 6 | 0 | 40.17638677 | -101.6876522 | 2022-06-21 04:20:56 | Dundy, Nebraska, US | |
3271584 | 3271584 | 2022-06-19 | US | Nebraska | Dundy | 31057 | 338 | 6 | 0 | 40.17638677 | -101.6876522 | 2022-06-20 04:21:01 | Dundy, Nebraska, US | |
3399496 | 3399496 | 2022-06-18 | US | Nebraska | Dundy | 31057 | 338 | 6 | 0 | 40.17638677 | -101.6876522 | 2022-06-19 04:20:51 | Dundy, Nebraska, US | |
2313373 | 2313373 | 2022-06-17 | US | Nebraska | Dundy | 31057 | 338 | 6 | 0 | 40.17638677 | -101.6876522 | 2022-06-18 04:21:10 | Dundy, Nebraska, US | |
560877 | 560877 | 2022-06-16 | US | Nebraska | Dundy | 31057 | 338 | 6 | 0 | 40.17638677 | -101.6876522 | 2022-06-17 04:20:56 | Dundy, Nebraska, US | |
3984679 | 3984679 | 2022-06-15 | US | Nebraska | Dundy | 31057 | 338 | 6 | 0 | 40.17638677 | -101.6876522 | 2022-06-16 04:20:55 | Dundy, Nebraska, US | |
948920 | 948920 | 2022-06-14 | US | Nebraska | Dundy | 31057 | 338 | 6 | 0 | 40.17638677 | -101.6876522 | 2022-06-15 04:20:54 | Dundy, Nebraska, US | |
1314830 | 1314830 | 2022-05-27 | US | Colorado | Kiowa | 8061 | 338 | 6 | 0 | 38.43260896 | -102.7392145 | 2022-05-28 04:21:07 | Kiowa, Colorado, US | |
1850622 | 1850622 | 2022-05-26 | US | Colorado | Kiowa | 8061 | 338 | 6 | 0 | 38.43260896 | -102.7392145 | 2022-05-27 04:20:56 | Kiowa, Colorado, US | |
2048498 | 2048498 | 2022-05-25 | US | Colorado | Kiowa | 8061 | 338 | 6 | 0 | 38.43260896 | -102.7392145 | 2022-05-26 04:20:50 | Kiowa, Colorado, US | |
2999936 | 2999936 | 2022-05-24 | US | Colorado | Kiowa | 8061 | 338 | 6 | 0 | 38.43260896 | -102.7392145 | 2022-05-25 04:20:56 | Kiowa, Colorado, US | |
3593657 | 3593657 | 2022-05-23 | US | Colorado | Kiowa | 8061 | 338 | 6 | 0 | 38.43260896 | -102.7392145 | 2022-05-24 04:20:57 | Kiowa, Colorado, US | |
622509 | 622509 | 2022-05-22 | US | Colorado | Kiowa | 8061 | 338 | 6 | 0 | 38.43260896 | -102.7392145 | 2022-05-26 04:20:50 | Kiowa, Colorado, US | |
1110205 | 1110205 | 2022-05-21 | US | Colorado | Kiowa | 8061 | 338 | 6 | 0 | 38.43260896 | -102.7392145 | 2022-05-22 04:20:52 | Kiowa, Colorado, US | |
1169829 | 1169829 | 2022-05-20 | US | Colorado | Kiowa | 8061 | 338 | 6 | 0 | 38.43260896 | -102.7392145 | 2022-05-21 04:20:58 | Kiowa, Colorado, US | |
3896592 | 3896592 | 2022-05-19 | US | Colorado | Kiowa | 8061 | 338 | 6 | 0 | 38.43260896 | -102.7392145 | 2022-05-20 04:20:57 | Kiowa, Colorado, US | |
2264027 | 2264027 | 2022-03-14 | New Zealand | Cook Islands | 338 | 0 | 0 | -21.2367 | -159.7777 | 2022-03-15 04:20:47 | Cook Islands, New Zealand | |||
1059999 | 1059999 | 2022-02-23 | US | Nevada | Storey | 32029 | 338 | 9 | 0 | 39.44875482 | -119.5250207 | 2022-02-24 04:21:14 | Storey, Nevada, US | |
1300202 | 1300202 | 2022-02-17 | US | Nevada | Storey | 32029 | 338 | 9 | 0 | 39.44875482 | -119.5250207 | 2022-02-18 04:21:04 | Storey, Nevada, US | |
2052304 | 2052304 | 2022-01-25 | US | Alaska | Denali | 2068 | 338 | 1 | 0 | 63.67264044 | -150.0076108 | 2022-01-26 04:21:07 | Denali, Alaska, US | |
1228035 | 1228035 | 2022-01-24 | US | Alaska | Denali | 2068 | 338 | 1 | 0 | 63.67264044 | -150.0076108 | 2022-01-25 04:21:05 | Denali, Alaska, US | |
1141528 | 1141528 | 2022-01-23 | US | Colorado | Dolores | 8033 | 338 | 7 | 0 | 37.75208676 | -108.5211585 | 2022-01-24 04:21:12 | Dolores, Colorado, US | |
1963685 | 1963685 | 2022-01-20 | US | Texas | Irion | 48235 | 338 | 2 | 0 | 31.30375559 | -100.982439 | 2022-01-21 04:21:09 | Irion, Texas, US | |
3467642 | 3467642 | 2022-01-18 | US | Washington | Wahkiakum | 53069 | 338 | 5 | 0 | 46.29180039999999 | -123.4250831 | 2022-01-19 04:21:23 | Wahkiakum, Washington, US | |
1217550 | 1217550 | 2022-01-08 | US | Missouri | Worth | 29227 | 338 | 3 | 0 | 40.47945588 | -94.42328751 | 2022-01-09 04:21:46 | Worth, Missouri, US | |
1288888 | 1288888 | 2022-01-04 | US | South Dakota | Jerauld | 46073 | 338 | 19 | 0 | 44.06637798 | -98.62965972 | 2022-01-05 04:21:59 | Jerauld, South Dakota, US | |
3521515 | 3521515 | 2022-01-02 | US | Nebraska | Harlan | 31083 | 338 | 0 | 0 | 40.17658508 | -99.40438879 | 2022-01-03 02:22:25 | Harlan, Nebraska, US | |
2169645 | 2169645 | 2022-01-01 | US | Nebraska | Harlan | 31083 | 338 | 0 | 0 | 40.17658508 | -99.40438879 | 2022-01-02 04:20:52 | Harlan, Nebraska, US | |
2779076 | 2779076 | 2021-12-31 | US | Nebraska | Harlan | 31083 | 338 | 0 | 0 | 40.17658508 | -99.40438879 | 2022-01-01 04:22:14 | Harlan, Nebraska, US | |
4001047 | 4001047 | 2021-12-30 | US | North Dakota | Divide | 38023 | 338 | 3 | 0 | 48.814938700000006 | -103.48736109999999 | 2021-12-31 04:21:50 | Divide, North Dakota, US | |
4000733 | 4000733 | 2021-12-30 | US | Nebraska | Harlan | 31083 | 338 | 0 | 0 | 40.17658508 | -99.40438879 | 2021-12-31 04:21:50 | Harlan, Nebraska, US | |
1670854 | 1670854 | 2021-12-29 | US | North Dakota | Divide | 38023 | 338 | 3 | 0 | 48.814938700000006 | -103.48736109999999 | 2021-12-30 04:21:25 | Divide, North Dakota, US | |
1433919 | 1433919 | 2021-12-28 | US | Kansas | Stanton | 20187 | 338 | 7 | 0 | 37.56304714 | -101.78435340000001 | 2021-12-29 03:21:43 | Stanton, Kansas, US | |
731880 | 731880 | 2021-12-27 | US | Kansas | Stanton | 20187 | 338 | 7 | 0 | 37.56304714 | -101.78435340000001 | 2021-12-28 04:21:47 | Stanton, Kansas, US | |
3830181 | 3830181 | 2021-12-21 | US | Minnesota | Cook | 27031 | 338 | 1 | 0 | 47.90504893 | -90.52629546 | 2021-12-22 04:21:54 | Cook, Minnesota, US | |
2089335 | 2089335 | 2021-12-14 | US | Kansas | Wichita | 20203 | 338 | 8 | 0 | 38.48178252 | -101.3471509 | 2021-12-15 03:22:16 | Wichita, Kansas, US | |
783752 | 783752 | 2021-12-13 | US | Kansas | Wichita | 20203 | 338 | 8 | 0 | 38.48178252 | -101.3471509 | 2021-12-14 04:22:38 | Wichita, Kansas, US | |
1234523 | 1234523 | 2021-11-28 | US | South Dakota | Mellette | 46095 | 338 | 4 | 0 | 43.58078848 | -100.7563186 | 2021-11-29 04:22:30 | Mellette, South Dakota, US | |
1361230 | 1361230 | 2021-11-27 | US | South Dakota | Mellette | 46095 | 338 | 4 | 0 | 43.58078848 | -100.7563186 | 2021-11-28 04:22:43 | Mellette, South Dakota, US | |
761221 | 761221 | 2021-11-26 | US | South Dakota | Mellette | 46095 | 338 | 4 | 0 | 43.58078848 | -100.7563186 | 2021-11-27 04:22:45 | Mellette, South Dakota, US | |
1805638 | 1805638 | 2021-11-25 | US | South Dakota | Mellette | 46095 | 338 | 4 | 0 | 43.58078848 | -100.7563186 | 2021-11-26 04:22:33 | Mellette, South Dakota, US | |
907072 | 907072 | 2021-11-24 | US | South Dakota | Mellette | 46095 | 338 | 4 | 0 | 43.58078848 | -100.7563186 | 2021-11-25 04:22:33 | Mellette, South Dakota, US | |
450244 | 450244 | 2021-11-17 | US | South Dakota | Haakon | 46055 | 338 | 11 | 0 | 44.29299053 | -101.539099 | 2021-11-18 04:21:33 | Haakon, South Dakota, US | |
29686 | 29686 | 2021-11-11 | US | Kansas | Clark | 20025 | 338 | 7 | 0 | 37.23577007 | -99.81883015 | 2021-11-12 04:22:01 | Clark, Kansas, US | |
2846125 | 2846125 | 2021-11-10 | US | Kansas | Clark | 20025 | 338 | 7 | 0 | 37.23577007 | -99.81883015 | 2021-11-11 04:21:45 | Clark, Kansas, US | |
90016 | 90016 | 2021-11-09 | US | South Dakota | McPherson | 46089 | 338 | 7 | 0 | 45.76626028 | -99.22118798 | 2021-11-10 04:21:38 | McPherson, South Dakota, US | |
2001095 | 2001095 | 2021-11-07 | US | Alaska | Petersburg | 2195 | 338 | 3 | 0 | 57.13978948 | -132.9540995 | 2021-11-08 04:21:43 | Petersburg, Alaska, US | |
496086 | 496086 | 2021-11-06 | US | Alaska | Petersburg | 2195 | 338 | 3 | 0 | 57.13978948 | -132.9540995 | 2021-11-07 04:21:53 | Petersburg, Alaska, US | |
495438 | 495438 | 2021-11-06 | China | Gansu | 338 | 2 | 0 | 35.7518 | 104.2861 | 2021-11-07 04:21:53 | Gansu, China | |||
3121941 | 3121941 | 2021-11-05 | US | Alaska | Petersburg | 2195 | 338 | 3 | 0 | 57.13978948 | -132.9540995 | 2021-11-06 04:21:51 | Petersburg, Alaska, US | |
46449 | 46449 | 2021-11-02 | US | Puerto Rico | Guanica | 72055 | 338 | 0 | 0 | 17.982429 | -66.91964300000001 | 2021-11-03 06:22:09 | Guanica, Puerto Rico, US | |
3514145 | 3514145 | 2021-11-01 | US | Puerto Rico | Guanica | 72055 | 338 | 0 | 0 | 17.982429 | -66.91964300000001 | 2021-11-02 04:22:03 | Guanica, Puerto Rico, US | |
290736 | 290736 | 2021-10-31 | US | Puerto Rico | Guanica | 72055 | 338 | 0 | 0 | 17.982429 | -66.91964300000001 | 2021-11-01 04:22:01 | Guanica, Puerto Rico, US | |
2723742 | 2723742 | 2021-10-30 | US | Puerto Rico | Guanica | 72055 | 338 | 0 | 0 | 17.982429 | -66.91964300000001 | 2021-10-31 04:22:08 | Guanica, Puerto Rico, US | |
2720790 | 2720790 | 2021-10-30 | China | Guangxi | 338 | 2 | 0 | 23.8298 | 108.7881 | 2021-10-31 04:22:08 | Guangxi, China | |||
569844 | 569844 | 2021-10-29 | US | Puerto Rico | Guanica | 72055 | 338 | 0 | 0 | 17.982429 | -66.91964300000001 | 2021-10-30 04:22:03 | Guanica, Puerto Rico, US | |
7086 | 7086 | 2021-10-28 | US | Puerto Rico | Guanica | 72055 | 338 | 0 | 0 | 17.982429 | -66.91964300000001 | 2021-10-29 04:22:03 | Guanica, Puerto Rico, US | |
444281 | 444281 | 2021-10-20 | US | Idaho | Butte | 16023 | 338 | 3 | 0 | 43.72592209 | -113.1735463 | 2021-10-21 04:21:18 | Butte, Idaho, US | |
492941 | 492941 | 2021-10-14 | US | Kansas | Kiowa | 20097 | 338 | 4 | 0 | 37.55848695 | -99.2856537 | 2021-10-15 04:21:26 | Kiowa, Kansas, US | |
492901 | 492901 | 2021-10-14 | US | Kansas | Chase | 20017 | 338 | 4 | 0 | 38.30292938 | -96.59563862 | 2021-10-15 04:21:26 | Chase, Kansas, US | |
635229 | 635229 | 2021-10-13 | US | Kansas | Kiowa | 20097 | 338 | 4 | 0 | 37.55848695 | -99.2856537 | 2021-10-14 04:21:29 | Kiowa, Kansas, US | |
635189 | 635189 | 2021-10-13 | US | Kansas | Chase | 20017 | 338 | 4 | 0 | 38.30292938 | -96.59563862 | 2021-10-14 04:21:29 | Chase, Kansas, US | |
1495213 | 1495213 | 2021-10-12 | US | Wyoming | Niobrara | 56027 | 338 | 5 | 0 | 43.05607708 | -104.47588959999999 | 2021-10-13 04:20:51 | Niobrara, Wyoming, US | |
469817 | 469817 | 2021-10-07 | US | North Dakota | Kidder | 38043 | 338 | 10 | 0 | 46.97830064 | -99.77507857 | 2021-10-08 04:21:25 | Kidder, North Dakota, US | |
2459403 | 2459403 | 2021-10-06 | US | Colorado | Custer | 8027 | 338 | 7 | 0 | 38.10883162 | -105.3683478 | 2021-10-07 04:21:36 | Custer, Colorado, US | |
2069234 | 2069234 | 2021-08-31 | US | Kansas | Rawlins | 20153 | 338 | 7 | 0 | 39.78525843 | -101.07616170000001 | 2021-09-01 04:21:38 | Rawlins, Kansas, US | |
1776688 | 1776688 | 2021-08-30 | US | Kansas | Rawlins | 20153 | 338 | 7 | 0 | 39.78525843 | -101.07616170000001 | 2021-08-31 04:21:46 | Rawlins, Kansas, US | |
3893262 | 3893262 | 2021-08-29 | US | Kansas | Rawlins | 20153 | 338 | 7 | 0 | 39.78525843 | -101.07616170000001 | 2021-08-30 04:21:23 | Rawlins, Kansas, US | |
2795452 | 2795452 | 2021-08-28 | US | North Dakota | Renville | 38075 | 338 | 14 | 0 | 48.71982533 | -101.6603912 | 2021-08-29 04:21:14 | Renville, North Dakota, US | |
2794365 | 2794365 | 2021-08-28 | US | Kansas | Rawlins | 20153 | 338 | 7 | 0 | 39.78525843 | -101.07616170000001 | 2021-08-29 04:21:14 | Rawlins, Kansas, US | |
2924524 | 2924524 | 2021-08-27 | US | Kansas | Rawlins | 20153 | 338 | 7 | 0 | 39.78525843 | -101.07616170000001 | 2021-08-28 04:21:28 | Rawlins, Kansas, US | |
1598199 | 1598199 | 2021-08-26 | US | Montana | Fallon | 30025 | 338 | 3 | 0 | 46.33478338 | -104.41835649999999 | 2021-08-27 04:21:37 | Fallon, Montana, US | |
3168054 | 3168054 | 2021-08-23 | US | North Dakota | Towner | 38095 | 338 | 11 | 0 | 48.68565745 | -99.24564265 | 2021-08-24 04:21:19 | Towner, North Dakota, US | |
2520413 | 2520413 | 2021-08-18 | US | New York | Hamilton | 36041 | 338 | 2 | 0 | 43.66146647 | -74.49721957 | 2021-08-19 04:21:15 | Hamilton, New York, US | |
247985 | 247985 | 2021-08-17 | US | Puerto Rico | Arroyo | 72015 | 338 | 0 | 0 | 17.998457000000005 | -66.056546 | 2021-08-18 04:21:35 | Arroyo, Puerto Rico, US | |
1606948 | 1606948 | 2021-08-16 | US | Puerto Rico | Arroyo | 72015 | 338 | 0 | 0 | 17.998457000000005 | -66.056546 | 2021-08-17 04:21:49 | Arroyo, Puerto Rico, US | |
103966 | 103966 | 2021-08-15 | US | Colorado | Ouray | 8091 | 338 | 5 | 0 | 38.14717457 | -107.7675136 | 2021-08-16 04:21:31 | Ouray, Colorado, US | |
1485484 | 1485484 | 2021-08-13 | US | Missouri | Mercer | 29129 | 338 | 2 | 0 | 40.42212303 | -93.56829590000001 | 2021-08-14 04:21:25 | Mercer, Missouri, US | |
334988 | 334988 | 2021-08-04 | US | Texas | Fisher | 48151 | 338 | 14 | 0 | 32.74281316 | -100.4019302 | 2021-08-05 04:21:51 | Fisher, Texas, US | |
334065 | 334065 | 2021-08-04 | US | New Hampshire | Unassigned | 90033 | 338 | 1 | 0 | 44.69063265 | 0.0 | 2021-08-05 04:21:51 | Unassigned, New Hampshire, US | |
331661 | 331661 | 2021-08-04 | Brunei | 338 | 3 | 280 | 55 | 4.5353 | 114.7277 | 2021-08-05 04:21:51 | Brunei | |||
3471259 | 3471259 | 2021-08-03 | US | Texas | Fisher | 48151 | 338 | 14 | 0 | 32.74281316 | -100.4019302 | 2021-08-04 04:21:25 | Fisher, Texas, US | |
3470319 | 3470319 | 2021-08-03 | US | Nevada | Mineral | 32021 | 338 | 8 | 0 | 38.53841696 | -118.4344506 | 2021-08-04 04:21:25 | Mineral, Nevada, US | |
3467932 | 3467932 | 2021-08-03 | Brunei | 338 | 3 | 280 | 55 | 4.5353 | 114.7277 | 2021-08-04 04:21:25 | Brunei | |||
3686533 | 3686533 | 2021-08-02 | US | Texas | Fisher | 48151 | 338 | 14 | 0 | 32.74281316 | -100.4019302 | 2021-08-03 04:21:39 | Fisher, 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]);