johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
873 rows where confirmed = 314 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
451526 | 451526 | 2022-12-21 | New Zealand | Niue | 314 | 0 | 0 | -19.0544 | -169.8672 | 2022-12-22 04:20:56 | Niue, New Zealand | |||
115631 | 115631 | 2022-09-06 | US | Georgia | Taliaferro | 13265 | 314 | 4 | 0 | 33.56543317 | -82.88136816 | 2022-09-07 04:20:59 | Taliaferro, Georgia, US | |
2634603 | 2634603 | 2022-09-05 | US | Georgia | Taliaferro | 13265 | 314 | 4 | 0 | 33.56543317 | -82.88136816 | 2022-09-06 04:21:02 | Taliaferro, Georgia, US | |
2988167 | 2988167 | 2022-09-04 | US | Georgia | Taliaferro | 13265 | 314 | 4 | 0 | 33.56543317 | -82.88136816 | 2022-09-05 04:21:01 | Taliaferro, Georgia, US | |
2713852 | 2713852 | 2022-09-03 | US | Georgia | Taliaferro | 13265 | 314 | 4 | 0 | 33.56543317 | -82.88136816 | 2022-09-04 04:21:22 | Taliaferro, Georgia, US | |
1394557 | 1394557 | 2022-09-02 | US | Georgia | Taliaferro | 13265 | 314 | 4 | 0 | 33.56543317 | -82.88136816 | 2022-09-03 04:21:04 | Taliaferro, Georgia, US | |
3548386 | 3548386 | 2022-09-01 | US | Georgia | Taliaferro | 13265 | 314 | 4 | 0 | 33.56543317 | -82.88136816 | 2022-09-02 04:21:07 | Taliaferro, Georgia, US | |
2344306 | 2344306 | 2022-08-31 | US | Georgia | Taliaferro | 13265 | 314 | 4 | 0 | 33.56543317 | -82.88136816 | 2022-09-01 04:21:03 | Taliaferro, Georgia, US | |
994157 | 994157 | 2022-08-16 | US | Texas | Loving | 48301 | 314 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-08-17 04:20:59 | Loving, Texas, US | |
993422 | 993422 | 2022-08-16 | US | North Dakota | Sheridan | 38083 | 314 | 7 | 0 | 47.57700669 | -100.3426391 | 2022-08-17 04:20:59 | Sheridan, North Dakota, US | |
2497196 | 2497196 | 2022-08-15 | US | Texas | Loving | 48301 | 314 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-08-16 04:20:58 | Loving, Texas, US | |
2496461 | 2496461 | 2022-08-15 | US | North Dakota | Sheridan | 38083 | 314 | 7 | 0 | 47.57700669 | -100.3426391 | 2022-08-16 04:20:58 | Sheridan, North Dakota, US | |
3650011 | 3650011 | 2022-08-14 | US | North Dakota | Sheridan | 38083 | 314 | 7 | 0 | 47.57700669 | -100.3426391 | 2022-08-15 04:20:59 | Sheridan, North Dakota, US | |
1971017 | 1971017 | 2022-08-13 | US | North Dakota | Sheridan | 38083 | 314 | 7 | 0 | 47.57700669 | -100.3426391 | 2022-08-14 04:20:55 | Sheridan, North Dakota, US | |
2890826 | 2890826 | 2022-08-12 | US | North Dakota | Sheridan | 38083 | 314 | 7 | 0 | 47.57700669 | -100.3426391 | 2022-08-13 04:20:52 | Sheridan, North Dakota, US | |
3910431 | 3910431 | 2022-08-11 | US | North Dakota | Sheridan | 38083 | 314 | 7 | 0 | 47.57700669 | -100.3426391 | 2022-08-12 04:20:54 | Sheridan, North Dakota, US | |
1348748 | 1348748 | 2022-08-10 | US | North Dakota | Sheridan | 38083 | 314 | 7 | 0 | 47.57700669 | -100.3426391 | 2022-08-11 04:20:49 | Sheridan, North Dakota, US | |
2310348 | 2310348 | 2022-04-20 | US | Texas | Cottle | 48101 | 314 | 9 | 0 | 34.07783319 | -100.27850620000001 | 2022-04-21 04:20:46 | Cottle, Texas, US | |
316501 | 316501 | 2022-02-12 | US | California | Sierra | 6091 | 314 | 0 | 0 | 39.57713498 | -120.52007009999998 | 2022-02-13 04:21:00 | Sierra, California, US | |
2014728 | 2014728 | 2022-02-06 | US | Montana | Powder River | 30075 | 314 | 10 | 0 | 45.39617714 | -105.636738 | 2022-02-07 04:21:05 | Powder River, Montana, US | |
1296057 | 1296057 | 2022-02-05 | US | Montana | Powder River | 30075 | 314 | 10 | 0 | 45.39617714 | -105.636738 | 2022-02-06 04:21:00 | Powder River, Montana, US | |
2329385 | 2329385 | 2022-02-04 | US | Montana | Powder River | 30075 | 314 | 10 | 0 | 45.39617714 | -105.636738 | 2022-02-05 04:21:05 | Powder River, Montana, US | |
3302625 | 3302625 | 2022-01-30 | US | North Dakota | Oliver | 38065 | 314 | 4 | 0 | 47.11530482 | -101.3406158 | 2022-01-31 04:21:09 | Oliver, North Dakota, US | |
3813160 | 3813160 | 2022-01-28 | US | Texas | Stonewall | 48433 | 314 | 7 | 0 | 33.17906744 | -100.25384009999999 | 2022-01-29 04:21:10 | Stonewall, Texas, US | |
1782743 | 1782743 | 2022-01-27 | US | Virginia | Highland | 51091 | 314 | 5 | 0 | 38.35799465 | -79.56124594 | 2022-01-28 04:21:09 | Highland, Virginia, US | |
1781425 | 1781425 | 2022-01-27 | US | Montana | Wheatland | 30107 | 314 | 13 | 0 | 46.46652491 | -109.84646359999999 | 2022-01-28 04:21:09 | Wheatland, Montana, US | |
2833460 | 2833460 | 2022-01-22 | US | Colorado | Kiowa | 8061 | 314 | 6 | 0 | 38.43260896 | -102.7392145 | 2022-01-23 04:21:13 | Kiowa, Colorado, US | |
1962626 | 1962626 | 2022-01-20 | US | Nebraska | Dundy | 31057 | 314 | 4 | 0 | 40.17638677 | -101.6876522 | 2022-01-21 04:21:09 | Dundy, Nebraska, US | |
1475244 | 1475244 | 2022-01-17 | US | Texas | Irion | 48235 | 314 | 2 | 0 | 31.30375559 | -100.982439 | 2022-01-18 04:21:04 | Irion, Texas, US | |
3615142 | 3615142 | 2022-01-12 | US | Nebraska | Gosper | 31073 | 314 | 5 | 0 | 40.51481965 | -99.83020279 | 2022-01-13 08:00:09 | Gosper, Nebraska, US | |
1115583 | 1115583 | 2022-01-11 | US | Montana | Daniels | 30019 | 314 | 9 | 0 | 48.78420029 | -105.54763429999998 | 2022-01-12 04:21:44 | Daniels, Montana, US | |
1694311 | 1694311 | 2022-01-10 | US | Montana | Daniels | 30019 | 314 | 9 | 0 | 48.78420029 | -105.54763429999998 | 2022-01-11 04:22:01 | Daniels, Montana, US | |
1288054 | 1288054 | 2022-01-04 | US | Nebraska | Boyd | 31015 | 314 | 3 | 0 | 42.899727399999996 | -98.76486568 | 2022-01-05 04:21:59 | Boyd, Nebraska, US | |
1702398 | 1702398 | 2022-01-03 | US | Nebraska | Boyd | 31015 | 314 | 3 | 0 | 42.899727399999996 | -98.76486568 | 2022-01-04 04:22:17 | Boyd, Nebraska, US | |
1671923 | 1671923 | 2021-12-29 | US | Washington | Wahkiakum | 53069 | 314 | 5 | 0 | 46.29180039999999 | -123.4250831 | 2021-12-30 04:21:25 | Wahkiakum, Washington, US | |
1434549 | 1434549 | 2021-12-28 | US | Missouri | Worth | 29227 | 314 | 3 | 0 | 40.47945588 | -94.42328751 | 2021-12-29 03:21:43 | Worth, Missouri, US | |
732510 | 732510 | 2021-12-27 | US | Missouri | Worth | 29227 | 314 | 2 | 0 | 40.47945588 | -94.42328751 | 2021-12-28 04:21:47 | Worth, Missouri, US | |
2401890 | 2401890 | 2021-12-17 | US | Texas | Dickens | 48125 | 314 | 15 | 0 | 33.61616822 | -100.7788855 | 2021-12-18 02:22:20 | Dickens, Texas, US | |
1718434 | 1718434 | 2021-12-16 | US | Nebraska | Greeley | 31077 | 314 | 1 | 0 | 41.56742671 | -98.52150266 | 2021-12-17 04:22:14 | Greeley, Nebraska, US | |
405070 | 405070 | 2021-12-07 | US | Georgia | Clay | 13061 | 314 | 4 | 0 | 31.62221166 | -84.97713865 | 2021-12-08 04:22:46 | Clay, Georgia, US | |
1031152 | 1031152 | 2021-12-06 | US | Georgia | Clay | 13061 | 314 | 4 | 0 | 31.62221166 | -84.97713865 | 2021-12-07 04:22:34 | Clay, Georgia, US | |
1742250 | 1742250 | 2021-12-05 | US | Minnesota | Cook | 27031 | 314 | 1 | 0 | 47.90504893 | -90.52629546 | 2021-12-06 04:22:34 | Cook, Minnesota, US | |
1741315 | 1741315 | 2021-12-05 | US | Georgia | Clay | 13061 | 314 | 4 | 0 | 31.62221166 | -84.97713865 | 2021-12-06 04:22:34 | Clay, Georgia, US | |
139682 | 139682 | 2021-12-04 | US | Minnesota | Cook | 27031 | 314 | 1 | 0 | 47.90504893 | -90.52629546 | 2021-12-05 04:22:25 | Cook, Minnesota, US | |
138747 | 138747 | 2021-12-04 | US | Georgia | Clay | 13061 | 314 | 4 | 0 | 31.62221166 | -84.97713865 | 2021-12-05 04:22:25 | Clay, Georgia, US | |
2197335 | 2197335 | 2021-12-03 | US | Minnesota | Cook | 27031 | 314 | 1 | 0 | 47.90504893 | -90.52629546 | 2021-12-04 04:22:18 | Cook, Minnesota, US | |
2196400 | 2196400 | 2021-12-03 | US | Georgia | Clay | 13061 | 314 | 4 | 0 | 31.62221166 | -84.97713865 | 2021-12-04 04:22:18 | Clay, Georgia, US | |
1106 | 1106 | 2021-12-02 | US | Georgia | Clay | 13061 | 314 | 4 | 0 | 31.62221166 | -84.97713865 | 2021-12-03 04:23:05 | Clay, Georgia, US | |
1145705 | 1145705 | 2021-12-01 | US | Georgia | Clay | 13061 | 314 | 4 | 0 | 31.62221166 | -84.97713865 | 2021-12-02 04:22:37 | Clay, Georgia, US | |
1233712 | 1233712 | 2021-11-28 | US | Nebraska | Harlan | 31083 | 314 | 0 | 0 | 40.17658508 | -99.40438879 | 2021-11-29 04:22:30 | Harlan, Nebraska, US | |
1360419 | 1360419 | 2021-11-27 | US | Nebraska | Harlan | 31083 | 314 | 0 | 0 | 40.17658508 | -99.40438879 | 2021-11-28 04:22:43 | Harlan, Nebraska, US | |
760410 | 760410 | 2021-11-26 | US | Nebraska | Harlan | 31083 | 314 | 0 | 0 | 40.17658508 | -99.40438879 | 2021-11-27 04:22:45 | Harlan, Nebraska, US | |
1804827 | 1804827 | 2021-11-25 | US | Nebraska | Harlan | 31083 | 314 | 0 | 0 | 40.17658508 | -99.40438879 | 2021-11-26 04:22:33 | Harlan, Nebraska, US | |
906261 | 906261 | 2021-11-24 | US | Nebraska | Harlan | 31083 | 314 | 0 | 0 | 40.17658508 | -99.40438879 | 2021-11-25 04:22:33 | Harlan, Nebraska, US | |
3072221 | 3072221 | 2021-11-23 | US | New Mexico | De Baca | 35011 | 314 | 3 | 0 | 34.34274529 | -104.4117842 | 2021-11-24 04:22:14 | De Baca, New Mexico, US | |
3072111 | 3072111 | 2021-11-23 | US | Nebraska | Harlan | 31083 | 314 | 0 | 0 | 40.17658508 | -99.40438879 | 2021-11-24 04:22:14 | Harlan, Nebraska, US | |
3751209 | 3751209 | 2021-11-22 | US | Nebraska | Harlan | 31083 | 314 | 0 | 0 | 40.17658508 | -99.40438879 | 2021-11-23 04:22:39 | Harlan, Nebraska, US | |
3290210 | 3290210 | 2021-11-18 | US | Kansas | Hamilton | 20075 | 314 | 1 | 0 | 37.99978709 | -101.7921066 | 2021-11-19 04:21:40 | Hamilton, Kansas, US | |
448666 | 448666 | 2021-11-17 | US | Kansas | Hamilton | 20075 | 314 | 1 | 0 | 37.99978709 | -101.7921066 | 2021-11-18 04:21:33 | Hamilton, Kansas, US | |
46099 | 46099 | 2021-11-02 | US | North Dakota | Burke | 38013 | 314 | 3 | 0 | 48.79094471 | -102.51821170000001 | 2021-11-03 06:22:09 | Burke, North Dakota, US | |
445425 | 445425 | 2021-10-20 | US | Nebraska | Franklin | 31061 | 314 | 4 | 0 | 40.17636348 | -98.95299073 | 2021-10-21 04:21:18 | Franklin, Nebraska, US | |
599744 | 599744 | 2021-10-19 | US | Nebraska | Franklin | 31061 | 314 | 4 | 0 | 40.17636348 | -98.95299073 | 2021-10-20 04:21:00 | Franklin, Nebraska, US | |
2944012 | 2944012 | 2021-10-15 | US | Colorado | Sedgwick | 8115 | 314 | 5 | 0 | 40.87595412 | -102.3519227 | 2021-10-16 04:21:15 | Sedgwick, Colorado, US | |
637380 | 637380 | 2021-10-13 | US | Washington | San Juan | 53055 | 314 | 0 | 0 | 48.60182783 | -122.96745 | 2021-10-14 04:21:29 | San Juan, Washington, US | |
1494009 | 1494009 | 2021-10-12 | US | North Dakota | Logan | 38047 | 314 | 10 | 0 | 46.45729487 | -99.47719806 | 2021-10-13 04:20:51 | Logan, North Dakota, US | |
1491390 | 1491390 | 2021-10-12 | China | Guangxi | 314 | 2 | 0 | 23.8298 | 108.7881 | 2021-10-13 04:20:51 | Guangxi, China | |||
3009742 | 3009742 | 2021-10-11 | US | North Dakota | Logan | 38047 | 314 | 10 | 0 | 46.45729487 | -99.47719806 | 2021-10-12 04:21:09 | Logan, North Dakota, US | |
425758 | 425758 | 2021-10-10 | US | North Dakota | Logan | 38047 | 314 | 10 | 0 | 46.45729487 | -99.47719806 | 2021-10-11 04:21:31 | Logan, North Dakota, US | |
468338 | 468338 | 2021-10-07 | US | Idaho | Butte | 16023 | 314 | 3 | 0 | 43.72592209 | -113.1735463 | 2021-10-08 04:21:25 | Butte, Idaho, US | |
2461664 | 2461664 | 2021-10-06 | US | South Dakota | Haakon | 46055 | 314 | 11 | 0 | 44.29299053 | -101.539099 | 2021-10-07 04:21:36 | Haakon, South Dakota, US | |
3835357 | 3835357 | 2021-10-05 | US | South Dakota | Haakon | 46055 | 314 | 11 | 0 | 44.29299053 | -101.539099 | 2021-10-06 04:21:33 | Haakon, South Dakota, US | |
989850 | 989850 | 2021-10-04 | US | South Dakota | Haakon | 46055 | 314 | 11 | 0 | 44.29299053 | -101.539099 | 2021-10-05 04:21:27 | Haakon, South Dakota, US | |
1277899 | 1277899 | 2021-10-03 | US | Wyoming | Niobrara | 56027 | 314 | 5 | 0 | 43.05607708 | -104.47588959999999 | 2021-10-04 04:21:31 | Niobrara, Wyoming, US | |
1277573 | 1277573 | 2021-10-03 | US | Vermont | Grand Isle | 50013 | 314 | 2 | 0 | 44.797582399999996 | -73.29679772 | 2021-10-04 04:21:31 | Grand Isle, Vermont, US | |
1275577 | 1275577 | 2021-10-03 | US | Kansas | Graham | 20065 | 314 | 10 | 0 | 39.34987223 | -99.88332493 | 2021-10-04 04:21:31 | Graham, Kansas, US | |
3931652 | 3931652 | 2021-10-02 | US | Wyoming | Niobrara | 56027 | 314 | 5 | 0 | 43.05607708 | -104.47588959999999 | 2021-10-03 04:21:24 | Niobrara, Wyoming, US | |
3931326 | 3931326 | 2021-10-02 | US | Vermont | Grand Isle | 50013 | 314 | 2 | 0 | 44.797582399999996 | -73.29679772 | 2021-10-03 04:21:24 | Grand Isle, Vermont, US | |
3929330 | 3929330 | 2021-10-02 | US | Kansas | Graham | 20065 | 314 | 10 | 0 | 39.34987223 | -99.88332493 | 2021-10-03 04:21:24 | Graham, Kansas, US | |
2135632 | 2135632 | 2021-10-01 | US | Wyoming | Niobrara | 56027 | 314 | 5 | 0 | 43.05607708 | -104.47588959999999 | 2021-10-02 04:21:25 | Niobrara, Wyoming, US | |
2133310 | 2133310 | 2021-10-01 | US | Kansas | Graham | 20065 | 314 | 10 | 0 | 39.34987223 | -99.88332493 | 2021-10-02 04:21:25 | Graham, Kansas, US | |
2774258 | 2774258 | 2021-09-30 | US | Kansas | Edwards | 20047 | 314 | 12 | 0 | 37.88735543 | -99.31263309 | 2021-10-01 04:21:35 | Edwards, Kansas, US | |
709607 | 709607 | 2021-09-29 | US | Texas | Menard | 48327 | 314 | 11 | 0 | 30.88990665 | -99.82047940000001 | 2021-09-30 04:21:20 | Menard, Texas, US | |
707714 | 707714 | 2021-09-29 | US | Kansas | Edwards | 20047 | 314 | 12 | 0 | 37.88735543 | -99.31263309 | 2021-09-30 04:21:20 | Edwards, Kansas, US | |
2077222 | 2077222 | 2021-09-26 | US | Kansas | Decatur | 20039 | 314 | 12 | 0 | 39.78468441 | -100.45940809999999 | 2021-09-27 04:21:16 | Decatur, Kansas, US | |
1725774 | 1725774 | 2021-09-25 | US | Kansas | Decatur | 20039 | 314 | 12 | 0 | 39.78468441 | -100.45940809999999 | 2021-09-26 04:21:29 | Decatur, Kansas, US | |
1922494 | 1922494 | 2021-09-24 | US | Kansas | Decatur | 20039 | 314 | 12 | 0 | 39.78468441 | -100.45940809999999 | 2021-09-25 04:21:31 | Decatur, Kansas, US | |
603038 | 603038 | 2021-09-23 | US | Kansas | Smith | 20183 | 314 | 3 | 0 | 39.78516566 | -98.78566062 | 2021-09-24 04:21:44 | Smith, Kansas, US | |
3012682 | 3012682 | 2021-09-22 | US | Kansas | Smith | 20183 | 314 | 3 | 0 | 39.78516566 | -98.78566062 | 2021-09-23 04:21:43 | Smith, Kansas, US | |
3758404 | 3758404 | 2021-09-21 | US | Idaho | Custer | 16037 | 314 | 3 | 0 | 44.24186819 | -114.2855494 | 2021-09-22 04:21:45 | Custer, Idaho, US | |
1388706 | 1388706 | 2021-09-13 | US | Texas | Edwards | 48137 | 314 | 6 | 0 | 29.98202582 | -100.304252 | 2021-09-14 04:21:41 | Edwards, Texas, US | |
3807860 | 3807860 | 2021-09-11 | US | Missouri | Scotland | 29199 | 314 | 4 | 0 | 40.45214695 | -92.14709064 | 2021-09-12 04:21:13 | Scotland, Missouri, US | |
3451855 | 3451855 | 2021-09-10 | US | Texas | Armstrong | 48011 | 314 | 7 | 0 | 34.96507426 | -101.35748740000001 | 2021-09-11 04:21:30 | Armstrong, Texas, US | |
3450800 | 3450800 | 2021-09-10 | US | Missouri | Scotland | 29199 | 314 | 4 | 0 | 40.45214695 | -92.14709064 | 2021-09-11 04:21:30 | Scotland, Missouri, US | |
1265801 | 1265801 | 2021-09-09 | US | Texas | Armstrong | 48011 | 314 | 7 | 0 | 34.96507426 | -101.35748740000001 | 2021-09-10 04:21:20 | Armstrong, Texas, US | |
1264746 | 1264746 | 2021-09-09 | US | Missouri | Scotland | 29199 | 314 | 4 | 0 | 40.45214695 | -92.14709064 | 2021-09-10 04:21:20 | Scotland, Missouri, US | |
2281116 | 2281116 | 2021-09-08 | US | Missouri | Scotland | 29199 | 314 | 4 | 0 | 40.45214695 | -92.14709064 | 2021-09-09 04:21:27 | Scotland, Missouri, US | |
3284170 | 3284170 | 2021-09-05 | US | Virginia | Bath | 51017 | 314 | 11 | 0 | 38.05852573 | -79.73912095 | 2021-09-06 04:21:22 | Bath, Virginia, US | |
252584 | 252584 | 2021-09-04 | US | Virginia | Bath | 51017 | 314 | 11 | 0 | 38.05852573 | -79.73912095 | 2021-09-05 04:21:33 | Bath, Virginia, US | |
3977865 | 3977865 | 2021-09-03 | US | Virginia | Bath | 51017 | 314 | 11 | 0 | 38.05852573 | -79.73912095 | 2021-09-04 04:21:28 | Bath, Virginia, US | |
1778247 | 1778247 | 2021-08-30 | US | South Dakota | Miner | 46097 | 314 | 10 | 0 | 44.02197882 | -97.60992207 | 2021-08-31 04:21:46 | Miner, South Dakota, 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]);