johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
598 rows where confirmed = 646 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2954407 | 2954407 | 2022-12-20 | US | Texas | Armstrong | 48011 | 646 | 10 | 0 | 34.96507426 | -101.3574874 | 2022-12-21 04:21:03 | Armstrong, Texas, US | |
3176809 | 3176809 | 2022-12-19 | US | Texas | Armstrong | 48011 | 646 | 10 | 0 | 34.96507426 | -101.3574874 | 2022-12-20 04:21:04 | Armstrong, Texas, US | |
3176215 | 3176215 | 2022-12-19 | US | North Dakota | Renville | 38075 | 646 | 15 | 0 | 48.71982533 | -101.6603912 | 2022-12-20 04:21:04 | Renville, North Dakota, US | |
1631326 | 1631326 | 2022-12-18 | US | Texas | Armstrong | 48011 | 646 | 10 | 0 | 34.96507426 | -101.3574874 | 2022-12-19 04:21:03 | Armstrong, Texas, US | |
1630732 | 1630732 | 2022-12-18 | US | North Dakota | Renville | 38075 | 646 | 15 | 0 | 48.71982533 | -101.6603912 | 2022-12-19 04:21:03 | Renville, North Dakota, US | |
506705 | 506705 | 2022-12-17 | US | Texas | Armstrong | 48011 | 646 | 10 | 0 | 34.96507426 | -101.3574874 | 2022-12-18 04:21:03 | Armstrong, Texas, US | |
506111 | 506111 | 2022-12-17 | US | North Dakota | Renville | 38075 | 646 | 15 | 0 | 48.71982533 | -101.6603912 | 2022-12-18 04:21:03 | Renville, North Dakota, US | |
3327277 | 3327277 | 2022-12-16 | US | Texas | Armstrong | 48011 | 646 | 10 | 0 | 34.96507426 | -101.3574874 | 2022-12-17 04:21:04 | Armstrong, Texas, US | |
3326683 | 3326683 | 2022-12-16 | US | North Dakota | Renville | 38075 | 646 | 15 | 0 | 48.71982533 | -101.6603912 | 2022-12-17 04:21:04 | Renville, North Dakota, US | |
545789 | 545789 | 2022-12-15 | US | Texas | Armstrong | 48011 | 646 | 10 | 0 | 34.96507426 | -101.3574874 | 2022-12-16 04:21:01 | Armstrong, Texas, US | |
545195 | 545195 | 2022-12-15 | US | North Dakota | Renville | 38075 | 646 | 15 | 0 | 48.71982533 | -101.6603912 | 2022-12-16 04:21:01 | Renville, North Dakota, US | |
351317 | 351317 | 2022-12-14 | US | Texas | Armstrong | 48011 | 646 | 10 | 0 | 34.96507426 | -101.3574874 | 2022-12-15 04:20:58 | Armstrong, Texas, US | |
350723 | 350723 | 2022-12-14 | US | North Dakota | Renville | 38075 | 646 | 15 | 0 | 48.71982533 | -101.6603912 | 2022-12-15 04:20:58 | Renville, North Dakota, US | |
310311 | 310311 | 2022-12-13 | US | North Dakota | Renville | 38075 | 646 | 15 | 0 | 48.71982533 | -101.6603912 | 2022-12-14 04:21:04 | Renville, North Dakota, US | |
2558736 | 2558736 | 2022-11-29 | US | Nevada | Lincoln | 32017 | 646 | 10 | 0 | 37.64268459 | -114.8790388 | 2022-11-30 04:21:07 | Lincoln, Nevada, US | |
1241810 | 1241810 | 2022-11-28 | US | Nevada | Lincoln | 32017 | 646 | 10 | 0 | 37.64268459 | -114.8790388 | 2022-11-29 04:21:05 | Lincoln, Nevada, US | |
3553798 | 3553798 | 2022-11-27 | US | Nevada | Lincoln | 32017 | 646 | 10 | 0 | 37.64268459 | -114.8790388 | 2022-11-28 04:21:02 | Lincoln, Nevada, US | |
2102278 | 2102278 | 2022-11-26 | US | Nevada | Lincoln | 32017 | 646 | 10 | 0 | 37.64268459 | -114.8790388 | 2022-11-27 04:21:05 | Lincoln, Nevada, US | |
489769 | 489769 | 2022-11-25 | US | Nevada | Lincoln | 32017 | 646 | 10 | 0 | 37.64268459 | -114.8790388 | 2022-11-26 04:21:11 | Lincoln, Nevada, US | |
3525598 | 3525598 | 2022-11-24 | US | Nevada | Lincoln | 32017 | 646 | 10 | 0 | 37.64268459 | -114.8790388 | 2022-11-25 04:21:06 | Lincoln, Nevada, US | |
3314381 | 3314381 | 2022-11-23 | US | Nevada | Lincoln | 32017 | 646 | 10 | 0 | 37.64268459 | -114.8790388 | 2022-11-24 04:21:09 | Lincoln, Nevada, US | |
2688105 | 2688105 | 2022-10-03 | US | North Dakota | Griggs | 38039 | 646 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-10-04 04:22:55 | Griggs, North Dakota, US | |
2688086 | 2688086 | 2022-10-03 | US | North Dakota | Adams | 38001 | 646 | 10 | 0 | 46.09686891 | -102.5285397 | 2022-10-04 04:22:55 | Adams, North Dakota, US | |
2262153 | 2262153 | 2022-10-02 | US | North Dakota | Adams | 38001 | 646 | 10 | 0 | 46.09686891 | -102.5285397 | 2022-10-03 04:23:11 | Adams, North Dakota, US | |
2997679 | 2997679 | 2022-10-01 | US | North Dakota | Adams | 38001 | 646 | 10 | 0 | 46.09686891 | -102.5285397 | 2022-10-02 04:21:23 | Adams, North Dakota, US | |
856005 | 856005 | 2022-09-30 | US | North Dakota | Adams | 38001 | 646 | 10 | 0 | 46.09686891 | -102.5285397 | 2022-10-01 04:23:01 | Adams, North Dakota, US | |
2377931 | 2377931 | 2022-09-29 | US | North Dakota | Adams | 38001 | 646 | 10 | 0 | 46.09686891 | -102.5285397 | 2022-09-30 04:23:09 | Adams, North Dakota, US | |
2377738 | 2377738 | 2022-09-29 | US | New Mexico | De Baca | 35011 | 646 | 6 | 0 | 34.34274529 | -104.4117842 | 2022-09-30 04:23:09 | De Baca, New Mexico, US | |
1562482 | 1562482 | 2022-09-28 | US | North Dakota | Adams | 38001 | 646 | 10 | 0 | 46.09686891 | -102.5285397 | 2022-09-29 04:22:34 | Adams, North Dakota, US | |
1562289 | 1562289 | 2022-09-28 | US | New Mexico | De Baca | 35011 | 646 | 6 | 0 | 34.34274529 | -104.4117842 | 2022-09-29 04:22:34 | De Baca, New Mexico, US | |
3768073 | 3768073 | 2022-09-11 | US | New Mexico | De Baca | 35011 | 646 | 6 | 0 | 34.34274529 | -104.4117842 | 2022-09-12 04:20:58 | De Baca, New Mexico, US | |
3826648 | 3826648 | 2022-09-10 | US | New Mexico | De Baca | 35011 | 646 | 6 | 0 | 34.34274529 | -104.4117842 | 2022-09-11 04:20:50 | De Baca, New Mexico, US | |
965105 | 965105 | 2022-09-09 | US | New Mexico | De Baca | 35011 | 646 | 6 | 0 | 34.34274529 | -104.4117842 | 2022-09-10 04:21:10 | De Baca, New Mexico, US | |
255507 | 255507 | 2022-09-08 | US | New Mexico | De Baca | 35011 | 646 | 6 | 0 | 34.34274529 | -104.4117842 | 2022-09-09 04:21:11 | De Baca, New Mexico, US | |
1087011 | 1087011 | 2022-08-09 | US | Idaho | Custer | 16037 | 646 | 9 | 0 | 44.24186819 | -114.2855494 | 2022-08-10 04:20:57 | Custer, Idaho, US | |
3544426 | 3544426 | 2022-08-08 | US | Idaho | Custer | 16037 | 646 | 9 | 0 | 44.24186819 | -114.2855494 | 2022-08-09 04:20:34 | Custer, Idaho, US | |
1406367 | 1406367 | 2022-08-02 | US | Kansas | Morton | 20129 | 646 | 11 | 0 | 37.19141121 | -101.7992519 | 2022-08-03 04:20:59 | Morton, Kansas, US | |
3618405 | 3618405 | 2022-08-01 | US | Kansas | Morton | 20129 | 646 | 11 | 0 | 37.19141121 | -101.7992519 | 2022-08-02 04:20:53 | Morton, Kansas, US | |
3872885 | 3872885 | 2022-07-31 | US | Kansas | Morton | 20129 | 646 | 11 | 0 | 37.19141121 | -101.7992519 | 2022-08-01 04:21:03 | Morton, Kansas, US | |
675639 | 675639 | 2022-07-30 | US | Kansas | Morton | 20129 | 646 | 11 | 0 | 37.19141121 | -101.7992519 | 2022-07-31 04:21:02 | Morton, Kansas, US | |
1784838 | 1784838 | 2022-07-29 | US | Kansas | Morton | 20129 | 646 | 11 | 0 | 37.19141121 | -101.7992519 | 2022-07-30 04:20:42 | Morton, Kansas, US | |
1067201 | 1067201 | 2022-07-28 | US | Kansas | Morton | 20129 | 646 | 11 | 0 | 37.19141121 | -101.7992519 | 2022-07-29 04:20:45 | Morton, Kansas, US | |
2336720 | 2336720 | 2022-07-27 | US | Kansas | Morton | 20129 | 646 | 11 | 0 | 37.19141121 | -101.7992519 | 2022-07-28 04:20:56 | Morton, Kansas, US | |
3969988 | 3969988 | 2022-07-05 | US | Washington | Columbia | 53013 | 646 | 16 | 0 | 46.29442881 | -117.9051983 | 2022-07-06 04:20:58 | Columbia, Washington, US | |
3081499 | 3081499 | 2022-07-04 | US | Washington | Columbia | 53013 | 646 | 16 | 0 | 46.29442881 | -117.9051983 | 2022-07-05 04:20:45 | Columbia, Washington, US | |
1770781 | 1770781 | 2022-07-03 | US | Washington | Columbia | 53013 | 646 | 16 | 0 | 46.29442881 | -117.9051983 | 2022-07-04 04:20:54 | Columbia, Washington, US | |
3368767 | 3368767 | 2022-07-02 | US | Washington | Columbia | 53013 | 646 | 16 | 0 | 46.29442881 | -117.9051983 | 2022-07-03 04:20:59 | Columbia, Washington, US | |
597096 | 597096 | 2022-07-01 | US | Washington | Columbia | 53013 | 646 | 16 | 0 | 46.29442881 | -117.9051983 | 2022-07-02 04:21:16 | Columbia, Washington, US | |
168950 | 168950 | 2022-06-21 | US | South Dakota | Stanley | 46117 | 646 | 7 | 0 | 44.41381872 | -100.7349153 | 2022-06-22 04:20:54 | Stanley, South Dakota, US | |
1766233 | 1766233 | 2022-06-20 | US | South Dakota | Stanley | 46117 | 646 | 7 | 0 | 44.41381872 | -100.7349153 | 2022-06-21 04:20:56 | Stanley, South Dakota, US | |
3272419 | 3272419 | 2022-06-19 | US | South Dakota | Stanley | 46117 | 646 | 7 | 0 | 44.41381872 | -100.7349153 | 2022-06-20 04:21:01 | Stanley, South Dakota, US | |
3400331 | 3400331 | 2022-06-18 | US | South Dakota | Stanley | 46117 | 646 | 7 | 0 | 44.41381872 | -100.7349153 | 2022-06-19 04:20:51 | Stanley, South Dakota, US | |
2314208 | 2314208 | 2022-06-17 | US | South Dakota | Stanley | 46117 | 646 | 7 | 0 | 44.41381872 | -100.7349153 | 2022-06-18 04:21:10 | Stanley, South Dakota, US | |
561712 | 561712 | 2022-06-16 | US | South Dakota | Stanley | 46117 | 646 | 7 | 0 | 44.41381872 | -100.7349153 | 2022-06-17 04:20:56 | Stanley, South Dakota, US | |
3985514 | 3985514 | 2022-06-15 | US | South Dakota | Stanley | 46117 | 646 | 7 | 0 | 44.41381872 | -100.7349153 | 2022-06-16 04:20:55 | Stanley, South Dakota, US | |
949755 | 949755 | 2022-06-14 | US | South Dakota | Stanley | 46117 | 646 | 7 | 0 | 44.41381872 | -100.7349153 | 2022-06-15 04:20:54 | Stanley, South Dakota, US | |
2982163 | 2982163 | 2022-06-13 | US | South Dakota | Stanley | 46117 | 646 | 7 | 0 | 44.41381872 | -100.7349153 | 2022-06-14 04:20:52 | Stanley, South Dakota, US | |
2238289 | 2238289 | 2022-06-12 | US | South Dakota | Stanley | 46117 | 646 | 7 | 0 | 44.41381872 | -100.7349153 | 2022-06-13 04:21:14 | Stanley, South Dakota, US | |
3144487 | 3144487 | 2022-06-11 | US | South Dakota | Stanley | 46117 | 646 | 7 | 0 | 44.41381872 | -100.7349153 | 2022-06-12 04:20:53 | Stanley, South Dakota, US | |
1947403 | 1947403 | 2022-06-10 | US | South Dakota | Stanley | 46117 | 646 | 7 | 0 | 44.41381872 | -100.7349153 | 2022-06-11 04:21:01 | Stanley, South Dakota, US | |
3160542 | 3160542 | 2022-06-09 | US | South Dakota | Stanley | 46117 | 646 | 7 | 0 | 44.41381872 | -100.7349153 | 2022-06-10 04:20:55 | Stanley, South Dakota, US | |
1424009 | 1424009 | 2022-06-08 | US | South Dakota | Stanley | 46117 | 646 | 7 | 0 | 44.41381872 | -100.7349153 | 2022-06-09 04:20:54 | Stanley, South Dakota, US | |
3000657 | 3000657 | 2022-05-24 | US | Kansas | Smith | 20183 | 646 | 8 | 0 | 39.78516566 | -98.78566062 | 2022-05-25 04:20:56 | Smith, Kansas, US | |
3594378 | 3594378 | 2022-05-23 | US | Kansas | Smith | 20183 | 646 | 8 | 0 | 39.78516566 | -98.78566062 | 2022-05-24 04:20:57 | Smith, Kansas, US | |
1110926 | 1110926 | 2022-05-21 | US | Kansas | Smith | 20183 | 646 | 8 | 0 | 39.78516566 | -98.78566062 | 2022-05-22 04:20:52 | Smith, Kansas, US | |
1170550 | 1170550 | 2022-05-20 | US | Kansas | Smith | 20183 | 646 | 8 | 0 | 39.78516566 | -98.78566062 | 2022-05-21 04:20:58 | Smith, Kansas, US | |
3897313 | 3897313 | 2022-05-19 | US | Kansas | Smith | 20183 | 646 | 8 | 0 | 39.78516566 | -98.78566062 | 2022-05-20 04:20:57 | Smith, Kansas, US | |
1186097 | 1186097 | 2022-05-18 | US | Kansas | Smith | 20183 | 646 | 8 | 0 | 39.78516566 | -98.78566062 | 2022-05-19 04:20:54 | Smith, Kansas, US | |
3356794 | 3356794 | 2022-05-14 | US | Nebraska | Stanton | 31167 | 646 | 11 | 0 | 41.9169835 | -97.19394708 | 2022-05-15 04:20:53 | Stanton, Nebraska, US | |
660439 | 660439 | 2022-05-13 | US | Nebraska | Stanton | 31167 | 646 | 11 | 0 | 41.9169835 | -97.19394708 | 2022-05-14 04:20:48 | Stanton, Nebraska, US | |
2535522 | 2535522 | 2022-05-12 | US | Nebraska | Stanton | 31167 | 646 | 11 | 0 | 41.9169835 | -97.19394708 | 2022-05-13 04:20:51 | Stanton, Nebraska, US | |
3446968 | 3446968 | 2022-05-11 | US | Nebraska | Stanton | 31167 | 646 | 11 | 0 | 41.9169835 | -97.19394708 | 2022-05-12 04:20:54 | Stanton, Nebraska, US | |
1656197 | 1656197 | 2022-03-19 | China | Gansu | 646 | 2 | 0 | 35.7518 | 104.2861 | 2022-03-20 04:20:45 | Gansu, China | |||
946446 | 946446 | 2022-02-28 | US | Wyoming | Niobrara | 56027 | 646 | 9 | 0 | 43.05607708 | -104.47588959999999 | 2022-03-01 04:21:09 | Niobrara, Wyoming, US | |
3074658 | 3074658 | 2022-02-09 | US | Colorado | Custer | 8027 | 646 | 19 | 0 | 38.10883162 | -105.3683478 | 2022-02-10 04:21:14 | Custer, Colorado, US | |
1365229 | 1365229 | 2022-02-08 | US | South Dakota | Hanson | 46061 | 646 | 6 | 0 | 43.6746384 | -97.78715148 | 2022-02-09 04:21:04 | Hanson, South Dakota, US | |
2014703 | 2014703 | 2022-02-06 | US | Montana | Fallon | 30025 | 646 | 10 | 0 | 46.33478338 | -104.41835649999999 | 2022-02-07 04:21:05 | Fallon, Montana, US | |
2014013 | 2014013 | 2022-02-06 | US | Kansas | Kiowa | 20097 | 646 | 7 | 0 | 37.55848695 | -99.2856537 | 2022-02-07 04:21:05 | Kiowa, Kansas, US | |
1296032 | 1296032 | 2022-02-05 | US | Montana | Fallon | 30025 | 646 | 10 | 0 | 46.33478338 | -104.41835649999999 | 2022-02-06 04:21:00 | Fallon, Montana, US | |
1295342 | 1295342 | 2022-02-05 | US | Kansas | Kiowa | 20097 | 646 | 7 | 0 | 37.55848695 | -99.2856537 | 2022-02-06 04:21:00 | Kiowa, Kansas, US | |
2330508 | 2330508 | 2022-02-04 | US | Texas | Kimble | 48267 | 646 | 14 | 0 | 30.48678918 | -99.74856473 | 2022-02-05 04:21:05 | Kimble, Texas, US | |
2329360 | 2329360 | 2022-02-04 | US | Montana | Fallon | 30025 | 646 | 10 | 0 | 46.33478338 | -104.41835649999999 | 2022-02-05 04:21:05 | Fallon, Montana, US | |
2329325 | 2329325 | 2022-02-04 | US | Missouri | Scotland | 29199 | 646 | 17 | 0 | 40.45214695 | -92.14709064 | 2022-02-05 04:21:05 | Scotland, Missouri, US | |
2328670 | 2328670 | 2022-02-04 | US | Kansas | Kiowa | 20097 | 646 | 7 | 0 | 37.55848695 | -99.2856537 | 2022-02-05 04:21:05 | Kiowa, Kansas, US | |
2475224 | 2475224 | 2022-02-03 | US | Kansas | Cheyenne | 20023 | 646 | 14 | 0 | 39.78580976 | -101.7318201 | 2022-02-04 04:21:10 | Cheyenne, Kansas, US | |
460649 | 460649 | 2022-02-02 | US | Kansas | Cheyenne | 20023 | 646 | 14 | 0 | 39.78580976 | -101.7318201 | 2022-02-03 04:21:21 | Cheyenne, Kansas, US | |
1318825 | 1318825 | 2022-01-26 | US | Colorado | Costilla | 8023 | 646 | 14 | 0 | 37.27732493 | -105.4276548 | 2022-01-27 04:21:19 | Costilla, Colorado, US | |
2052493 | 2052493 | 2022-01-25 | US | Colorado | Costilla | 8023 | 646 | 14 | 0 | 37.27732493 | -105.4276548 | 2022-01-26 04:21:07 | Costilla, Colorado, US | |
1142647 | 1142647 | 2022-01-23 | US | Minnesota | Lake of the Woods | 27077 | 646 | 5 | 0 | 48.77217001 | -94.90274472 | 2022-01-24 04:21:12 | Lake of the Woods, Minnesota, US | |
2834565 | 2834565 | 2022-01-22 | US | Minnesota | Lake of the Woods | 27077 | 646 | 5 | 0 | 48.77217001 | -94.90274472 | 2022-01-23 04:21:13 | Lake of the Woods, Minnesota, US | |
3426683 | 3426683 | 2022-01-21 | US | Minnesota | Lake of the Woods | 27077 | 646 | 5 | 0 | 48.77217001 | -94.90274472 | 2022-01-22 04:21:13 | Lake of the Woods, Minnesota, US | |
1474148 | 1474148 | 2022-01-17 | US | Montana | Sweet Grass | 30097 | 646 | 8 | 0 | 45.81367654 | -109.9425686 | 2022-01-18 04:21:04 | Sweet Grass, Montana, US | |
556822 | 556822 | 2022-01-16 | US | Montana | Sweet Grass | 30097 | 646 | 8 | 0 | 45.81367654 | -109.9425686 | 2022-01-17 04:21:08 | Sweet Grass, Montana, US | |
3842543 | 3842543 | 2022-01-15 | US | Montana | Sweet Grass | 30097 | 646 | 8 | 0 | 45.81367654 | -109.9425686 | 2022-01-16 04:21:12 | Sweet Grass, Montana, US | |
101358 | 101358 | 2022-01-14 | US | Montana | Sweet Grass | 30097 | 646 | 8 | 0 | 45.81367654 | -109.9425686 | 2022-01-15 04:21:07 | Sweet Grass, Montana, US | |
3616087 | 3616087 | 2022-01-12 | US | Texas | Baylor | 48023 | 646 | 25 | 0 | 33.61640794 | -99.21352901 | 2022-01-13 08:00:09 | Baylor, Texas, US | |
1116448 | 1116448 | 2022-01-11 | US | South Dakota | Clark | 46025 | 646 | 6 | 0 | 44.85834507 | -97.72925109 | 2022-01-12 04:21:44 | Clark, South Dakota, US | |
2611396 | 2611396 | 2022-01-06 | US | Kansas | Sheridan | 20179 | 646 | 17 | 0 | 39.35018161 | -100.44182590000001 | 2022-01-07 04:22:09 | Sheridan, Kansas, US | |
1283338 | 1283338 | 2022-01-05 | US | Kansas | Sheridan | 20179 | 646 | 17 | 0 | 39.35018161 | -100.44182590000001 | 2022-01-06 04:22:09 | Sheridan, Kansas, US | |
1282637 | 1282637 | 2022-01-05 | US | Colorado | Phillips | 8095 | 646 | 15 | 0 | 40.59414277 | -102.3577703 | 2022-01-06 04:22:09 | Phillips, 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]);