johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
74 rows where confirmed = 7677 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 9
- US 57
- Sierra Leone 5
- Russia 4
- Japan 2
- Peru 2
- Cote d'Ivoire 1
- India 1
- Malaysia 1
- Mauritania 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
328888 | 328888 | 2022-12-27 | US | Illinois | Crawford | 17033 | 7677 | 48 | 0 | 39.0032229 | -87.75954624 | 2022-12-28 04:21:04 | Crawford, Illinois, US | |
3378361 | 3378361 | 2022-12-08 | US | Illinois | Douglas | 17041 | 7677 | 59 | 0 | 39.76768052 | -88.21854195 | 2022-12-09 04:21:05 | Douglas, Illinois, US | |
3040539 | 3040539 | 2022-10-27 | US | New Mexico | Luna | 35029 | 7677 | 147 | 0 | 32.18179341 | -107.7508826 | 2022-10-28 04:22:31 | Luna, New Mexico, US | |
2530915 | 2530915 | 2022-10-06 | US | Louisiana | Sabine | 22085 | 7677 | 122 | 0 | 31.56388699 | -93.55433981 | 2022-10-07 04:23:08 | Sabine, Louisiana, US | |
133859 | 133859 | 2022-10-04 | US | Texas | Hale | 48189 | 7677 | 248 | 0 | 34.07044901 | -101.8268114 | 2022-10-05 04:23:06 | Hale, Texas, US | |
2688806 | 2688806 | 2022-10-03 | US | Texas | Hale | 48189 | 7677 | 248 | 0 | 34.07044901 | -101.8268114 | 2022-10-04 04:22:55 | Hale, Texas, US | |
2405266 | 2405266 | 2022-08-21 | US | North Dakota | Stutsman | 38093 | 7677 | 97 | 0 | 46.97962541 | -98.95637318 | 2022-08-22 04:20:38 | Stutsman, North Dakota, US | |
1071399 | 1071399 | 2022-08-07 | US | Louisiana | East Feliciana | 22037 | 7677 | 171 | 0 | 30.84425359 | -91.04976723 | 2022-08-08 04:21:08 | East Feliciana, Louisiana, US | |
1941987 | 1941987 | 2022-08-06 | US | Louisiana | East Feliciana | 22037 | 7677 | 171 | 0 | 30.84425359 | -91.04976723 | 2022-08-07 04:20:54 | East Feliciana, Louisiana, US | |
881786 | 881786 | 2022-08-05 | US | Louisiana | East Feliciana | 22037 | 7677 | 171 | 0 | 30.84425359 | -91.04976723 | 2022-08-06 04:20:56 | East Feliciana, Louisiana, US | |
1101101 | 1101101 | 2022-08-03 | US | Tennessee | Overton | 47133 | 7677 | 126 | 0 | 36.34117832 | -85.28989535 | 2022-08-04 04:20:58 | Overton, Tennessee, US | |
2338784 | 2338784 | 2022-07-27 | US | Virginia | Orange | 51137 | 7677 | 91 | 0 | 38.24530219 | -78.015604 | 2022-07-28 04:20:56 | Orange, Virginia, US | |
2790441 | 2790441 | 2022-07-10 | US | Kentucky | Grant | 21081 | 7677 | 67 | 0 | 38.64962758 | -84.62415957 | 2022-07-11 04:20:46 | Grant, Kentucky, US | |
143394 | 143394 | 2022-07-09 | US | Kentucky | Grant | 21081 | 7677 | 67 | 0 | 38.64962758 | -84.62415957 | 2022-07-10 04:20:54 | Grant, Kentucky, US | |
1418494 | 1418494 | 2022-07-08 | US | Kentucky | Grant | 21081 | 7677 | 67 | 0 | 38.64962758 | -84.62415957 | 2022-07-09 04:20:59 | Grant, Kentucky, US | |
2742419 | 2742419 | 2022-07-07 | US | Kentucky | Grant | 21081 | 7677 | 67 | 0 | 38.64962758 | -84.62415957 | 2022-07-08 04:20:56 | Grant, Kentucky, US | |
1201214 | 1201214 | 2022-07-06 | US | Kentucky | Grant | 21081 | 7677 | 67 | 0 | 38.64962758 | -84.62415957 | 2022-07-07 04:20:55 | Grant, Kentucky, US | |
3967957 | 3967957 | 2022-07-05 | US | Kentucky | Grant | 21081 | 7677 | 67 | 0 | 38.64962758 | -84.62415957 | 2022-07-06 04:20:58 | Grant, Kentucky, US | |
1763728 | 1763728 | 2022-06-20 | US | Alabama | Pike | 1109 | 7677 | 134 | 0 | 31.80396383 | -85.9408295 | 2022-06-21 04:20:56 | Pike, Alabama, US | |
3269927 | 3269927 | 2022-06-19 | US | Alabama | Winston | 1133 | 7677 | 132 | 0 | 34.15030532 | -87.37325922 | 2022-06-20 04:21:01 | Winston, Alabama, US | |
3397839 | 3397839 | 2022-06-18 | US | Alabama | Winston | 1133 | 7677 | 132 | 0 | 34.15030532 | -87.37325922 | 2022-06-19 04:20:51 | Winston, Alabama, US | |
2311716 | 2311716 | 2022-06-17 | US | Alabama | Winston | 1133 | 7677 | 132 | 0 | 34.15030532 | -87.37325922 | 2022-06-18 04:21:10 | Winston, Alabama, US | |
1317149 | 1317149 | 2022-05-27 | US | Tennessee | Hardeman | 47069 | 7677 | 118 | 0 | 35.20772017 | -88.99161161 | 2022-05-28 04:21:07 | Hardeman, Tennessee, US | |
2598432 | 2598432 | 2022-05-05 | US | Alabama | Lawrence | 1079 | 7677 | 158 | 0 | 34.52041498 | -87.31069453 | 2022-05-06 04:21:00 | Lawrence, Alabama, US | |
2443036 | 2443036 | 2022-04-13 | Sierra Leone | 7677 | 125 | 0 | 8.460555000000001 | -11.779889 | 2022-04-13 23:21:06 | Sierra Leone | ||||
1948793 | 1948793 | 2022-04-12 | Sierra Leone | 7677 | 125 | 0 | 8.460555000000001 | -11.779889 | 2022-04-13 04:21:03 | Sierra Leone | ||||
3206546 | 3206546 | 2022-04-11 | Sierra Leone | 7677 | 125 | 0 | 8.460555000000001 | -11.779889 | 2022-04-12 04:20:49 | Sierra Leone | ||||
1576432 | 1576432 | 2022-04-10 | Sierra Leone | 7677 | 125 | 0 | 8.460555000000001 | -11.779889 | 2022-04-11 04:21:02 | Sierra Leone | ||||
1652674 | 1652674 | 2022-04-09 | Sierra Leone | 7677 | 125 | 0 | 8.460555000000001 | -11.779889 | 2022-04-10 04:20:52 | Sierra Leone | ||||
3323795 | 3323795 | 2022-04-07 | US | Wisconsin | Juneau | 55057 | 7677 | 68 | 0 | 43.92456975 | -90.11120239 | 2022-04-08 04:20:48 | Juneau, Wisconsin, US | |
359029 | 359029 | 2022-03-11 | US | Pennsylvania | Susquehanna | 42115 | 7677 | 107 | 0 | 41.82147784 | -75.80071959 | 2022-03-12 04:20:50 | Susquehanna, Pennsylvania, US | |
3467118 | 3467118 | 2022-01-18 | US | Tennessee | Giles | 47055 | 7677 | 154 | 0 | 35.20222469 | -87.03992678 | 2022-01-19 04:21:23 | Giles, Tennessee, US | |
3616238 | 3616238 | 2022-01-12 | US | Texas | Medina | 48325 | 7677 | 174 | 0 | 29.355730100000002 | -99.11030298 | 2022-01-13 08:00:09 | Medina, Texas, US | |
1670760 | 1670760 | 2021-12-29 | US | North Carolina | Chatham | 37037 | 7677 | 99 | 0 | 35.70394416 | -79.25541492 | 2021-12-30 04:21:25 | Chatham, North Carolina, US | |
2906163 | 2906163 | 2021-12-19 | US | Ohio | Brown | 39015 | 7677 | 142 | 0 | 38.93416837 | -83.86788395 | 2021-12-20 04:21:43 | Brown, Ohio, US | |
1081060 | 1081060 | 2021-12-09 | US | Texas | Jim Wells | 48249 | 7677 | 183 | 0 | 27.73103938 | -98.0904705 | 2021-12-10 04:22:28 | Jim Wells, Texas, US | |
1360986 | 1360986 | 2021-11-27 | US | Pennsylvania | Bedford | 42009 | 7677 | 191 | 0 | 40.00522157 | -78.48998442 | 2021-11-28 04:22:43 | Bedford, Pennsylvania, US | |
1803350 | 1803350 | 2021-11-25 | US | Colorado | Broomfield | 8014 | 7677 | 92 | 0 | 39.95998787 | -105.0566324 | 2021-11-26 04:22:33 | Broomfield, Colorado, US | |
1802665 | 1802665 | 2021-11-25 | India | Andaman and Nicobar Islands | 7677 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-11-26 04:22:33 | Andaman and Nicobar Islands, India | |||
3072471 | 3072471 | 2021-11-23 | US | Ohio | Ashland | 39005 | 7677 | 152 | 0 | 40.84772277 | -82.27280781 | 2021-11-24 04:22:14 | Ashland, Ohio, US | |
288878 | 288878 | 2021-10-31 | US | Georgia | Thomas | 13275 | 7677 | 180 | 0 | 30.86392347 | -83.91847289 | 2021-11-01 04:22:01 | Thomas, Georgia, US | |
2721884 | 2721884 | 2021-10-30 | US | Georgia | Thomas | 13275 | 7677 | 180 | 0 | 30.86392347 | -83.91847289 | 2021-10-31 04:22:08 | Thomas, Georgia, US | |
567986 | 567986 | 2021-10-29 | US | Georgia | Thomas | 13275 | 7677 | 180 | 0 | 30.86392347 | -83.91847289 | 2021-10-30 04:22:03 | Thomas, Georgia, US | |
937311 | 937311 | 2021-10-16 | US | Ohio | Sandusky | 39143 | 7677 | 157 | 0 | 41.35624126 | -83.137872 | 2021-10-17 04:21:29 | Sandusky, Ohio, US | |
1493352 | 1493352 | 2021-10-12 | US | Minnesota | Otter Tail | 27111 | 7677 | 102 | 0 | 46.40846929 | -95.70835255 | 2021-10-13 04:20:51 | Otter Tail, Minnesota, US | |
2776014 | 2776014 | 2021-09-30 | US | Texas | Burnet | 48053 | 7677 | 106 | 0 | 30.78801353 | -98.181887 | 2021-10-01 04:21:35 | Burnet, Texas, US | |
3706155 | 3706155 | 2021-07-17 | Japan | Okayama | 7677 | 127 | 7472 | 78 | 34.89246 | 133.826252 | 2021-07-18 04:22:07 | Okayama, Japan | ||
3031740 | 3031740 | 2021-06-16 | US | Kentucky | Oldham | 21185 | 7677 | 84 | 0 | 38.39791089 | -85.448222 | 2021-06-17 04:22:36 | Oldham, Kentucky, US | |
828257 | 828257 | 2021-06-06 | US | Pennsylvania | Lawrence | 42073 | 7677 | 212 | 0 | 40.99206278 | -80.33393706 | 2021-06-07 04:22:51 | Lawrence, Pennsylvania, US | |
1313854 | 1313854 | 2021-05-26 | Malaysia | Terengganu | 7677 | 26 | 5453 | 2198 | 5.3117 | 103.1324 | 2021-05-27 04:20:59 | Terengganu, Malaysia | ||
1083003 | 1083003 | 2021-05-14 | US | Indiana | Floyd | 18043 | 7677 | 178 | 0 | 38.32117957 | -85.90385377 | 2021-05-15 04:20:58 | Floyd, Indiana, US | |
2006454 | 2006454 | 2021-05-12 | US | Mississippi | Forrest | 28035 | 7677 | 152 | 0 | 31.18961454 | -89.25832496 | 2021-05-13 04:20:51 | Forrest, Mississippi, US | |
3244399 | 3244399 | 2021-04-21 | US | Nebraska | Hall | 31079 | 7677 | 116 | 0 | 40.87257079 | -98.50218293 | 2021-04-22 04:20:53 | Hall, Nebraska, US | |
1580678 | 1580678 | 2021-03-13 | US | Arkansas | White | 5145 | 7677 | 115 | 0 | 35.25688493 | -91.74908296 | 2021-03-14 05:25:37 | White, Arkansas, US | |
2360266 | 2360266 | 2021-03-08 | US | Georgia | Glynn | 13127 | 7677 | 162 | 0 | 31.23279254 | -81.53811412 | 2021-03-09 05:28:19 | Glynn, Georgia, US | |
1155457 | 1155457 | 2021-02-18 | US | North Carolina | Moore | 37125 | 7677 | 169 | 0 | 7508 | 35.30885257 | -79.48474178 | 2021-02-19 05:24:16 | Moore, North Carolina, US |
3053080 | 3053080 | 2021-02-16 | US | Tennessee | Anderson | 47001 | 7677 | 149 | 0 | 7597 | 36.12684348 | -84.19965764 | 2021-02-17 05:23:10 | Anderson, Tennessee, US |
2569065 | 2569065 | 2021-01-25 | US | Kentucky | Hardin | 21093 | 7677 | 59 | 0 | 7618 | 37.6976111 | -85.96319251 | 2021-01-26 05:22:02 | Hardin, Kentucky, US |
3881752 | 3881752 | 2021-01-14 | US | New Mexico | Chaves | 35005 | 7677 | 113 | 0 | 7564 | 33.36406072 | -104.4665365 | 2021-01-15 05:22:24 | Chaves, New Mexico, US |
3231144 | 3231144 | 2021-01-03 | US | Florida | Hernando | 12053 | 7677 | 281 | 0 | 7396 | 28.55364461 | -82.42700204 | 2021-01-04 05:22:02 | Hernando, Florida, US |
2226691 | 2226691 | 2020-12-26 | US | Texas | Parker | 48367 | 7677 | 89 | 0 | 7645 | 32.77757172 | -97.80500621 | 2020-12-27 05:22:55 | Parker, Texas, US |
3772177 | 3772177 | 2020-12-22 | US | North Carolina | Davidson | 37057 | 7677 | 74 | 0 | 7603 | 35.79115496 | -80.21256572 | 2020-12-23 05:22:03 | Davidson, North Carolina, US |
738521 | 738521 | 2020-12-02 | Russia | Mari El Republic | 7677 | 94 | 6728 | 855 | 56.5767504 | 47.8817512 | 2020-12-03 05:28:22 | Mari El Republic, Russia | ||
3480382 | 3480382 | 2020-10-26 | Mauritania | 7677 | 163 | 7387 | 127 | 21.0079 | -10.9408 | 2020-10-27 04:24:45 | Mauritania | |||
79258 | 79258 | 2020-10-14 | Peru | Tumbes | 7677 | 675 | 0 | 7002 | -3.857496 | -80.54525500000003 | 2020-10-15 04:24:28 | Tumbes, Peru | ||
79106 | 79106 | 2020-10-14 | Japan | Kanagawa | 7677 | 153 | 6925 | 599 | 35.415312 | 139.338983 | 2020-10-15 04:24:28 | Kanagawa, Japan | ||
3782073 | 3782073 | 2020-10-13 | Peru | Tumbes | 7677 | 671 | 0 | 7006 | -3.857496 | -80.54525500000003 | 2020-10-14 04:24:05 | Tumbes, Peru | ||
820199 | 820199 | 2020-10-09 | US | Pennsylvania | Berks | 42011 | 7677 | 404 | 0 | 7273 | 40.41570541 | -75.92457766 | 2020-10-10 04:23:57 | Berks, Pennsylvania, US |
2689884 | 2689884 | 2020-10-08 | Russia | Karachay-Cherkess Republic | 7677 | 29 | 4960 | 2688 | 43.7368326 | 41.7267991 | 2020-10-09 04:23:59 | Karachay-Cherkess Republic, Russia | ||
2582519 | 2582519 | 2020-09-27 | US | California | Kings | 6031 | 7677 | 78 | 0 | 7605 | 36.07409056 | -119.8159973 | 2020-09-28 04:23:00 | Kings, California, US |
3316433 | 3316433 | 2020-09-22 | Russia | Leningrad Oblast | 7677 | 95 | 5380 | 2202 | 60.1853296 | 32.3925325 | 2020-09-23 04:23:00 | Leningrad Oblast, Russia | ||
662485 | 662485 | 2020-08-11 | Russia | Bryansk Oblast | 7677 | 35 | 6270 | 1372 | 52.8873315 | 33.41585300000001 | 2020-08-12 04:27:29 | Bryansk Oblast, Russia | ||
1510912 | 1510912 | 2020-06-22 | Cote d'Ivoire | 7677 | 56 | 3493 | 4128 | 7.54 | -5.5471 | 2020-06-23 04:33:22 | Cote d'Ivoire | |||
1194959 | 1194959 | 2020-06-17 | US | California | San Bernardino | 6071 | 7677 | 225 | 0 | 7451 | 34.84060306 | -116.1774685 | 2020-06-18 04:33:18 | San Bernardino, California, 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]);