johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
43 rows where active = 3949 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
833280 | 833280 | 2021-07-09 | Malaysia | Sarawak | 68247 | 431 | 63867 | 3949 | 1.5533 | 110.3592 | 2021-07-10 04:21:25 | Sarawak, Malaysia | ||
1810376 | 1810376 | 2021-05-27 | Ukraine | Lviv Oblast | 135329 | 3546 | 127834 | 3949 | 49.8397 | 24.0297 | 2021-05-28 04:20:36 | Lviv Oblast, Ukraine | ||
1310348 | 1310348 | 2021-05-26 | Qatar | 216397 | 552 | 211896 | 3949 | 25.3548 | 51.1839 | 2021-05-27 04:20:59 | Qatar | |||
3675652 | 3675652 | 2021-05-04 | Japan | Aichi | 34747 | 638 | 30160 | 3949 | 35.035551 | 137.211621 | 2021-05-05 04:20:43 | Aichi, Japan | ||
3670209 | 3670209 | 2021-03-06 | US | Oklahoma | Sequoyah | 40135 | 3980 | 31 | 0 | 3949 | 35.49447108 | -94.75463785 | 2021-03-07 05:21:54 | Sequoyah, Oklahoma, US |
3256707 | 3256707 | 2021-03-02 | US | Oklahoma | Logan | 40083 | 3977 | 28 | 0 | 3949 | 35.91899576 | -97.44352845 | 2021-03-03 05:23:28 | Logan, Oklahoma, US |
1861366 | 1861366 | 2021-02-25 | US | Virginia | Manassas | 51683 | 3985 | 36 | 0 | 3949 | 38.7464321 | -77.48509905 | 2021-02-26 05:22:40 | Manassas, Virginia, US |
183567 | 183567 | 2021-02-21 | US | Louisiana | St. Mary | 22101 | 4068 | 119 | 0 | 3949 | 29.69262097 | -91.44702164 | 2021-02-22 05:24:21 | St. Mary, Louisiana, US |
3052468 | 3052468 | 2021-02-16 | US | North Carolina | Chatham | 37037 | 4022 | 73 | 0 | 3949 | 35.70394416 | -79.25541492 | 2021-02-17 05:23:10 | Chatham, North Carolina, US |
3542284 | 3542284 | 2021-02-12 | US | South Carolina | Newberry | 45071 | 4040 | 91 | 0 | 3949 | 34.28629098 | -81.59935761 | 2021-02-13 05:22:12 | Newberry, South Carolina, US |
3541290 | 3541290 | 2021-02-12 | US | Mississippi | Pontotoc | 28115 | 4014 | 65 | 0 | 3949 | 34.226046000000004 | -89.03636807 | 2021-02-13 05:22:12 | Pontotoc, Mississippi, US |
614561 | 614561 | 2021-02-08 | US | Georgia | Thomas | 13275 | 4049 | 100 | 0 | 3949 | 30.86392347 | -83.91847289 | 2021-02-09 05:23:30 | Thomas, Georgia, US |
2482663 | 2482663 | 2021-01-28 | US | Florida | Hendry | 12051 | 4004 | 55 | 0 | 3949 | 26.55386945 | -81.16469006 | 2021-01-29 05:22:23 | Hendry, Florida, US |
2466594 | 2466594 | 2021-01-22 | Chile | Los Lagos | 36642 | 344 | 32349 | 3949 | -41.9198 | -72.1416 | 2021-01-23 05:22:03 | Los Lagos, Chile | ||
438325 | 438325 | 2021-01-21 | US | Tennessee | Obion | 47131 | 4157 | 82 | 0 | 3949 | 36.35732446 | -89.14921589 | 2021-01-22 05:22:10 | Obion, Tennessee, US |
438034 | 438034 | 2021-01-21 | US | Pennsylvania | Mifflin | 42087 | 4093 | 144 | 0 | 3949 | 40.61116939 | -77.61070738 | 2021-01-22 05:22:10 | Mifflin, Pennsylvania, US |
1097618 | 1097618 | 2021-01-20 | US | Wisconsin | Douglas | 55031 | 3980 | 31 | 0 | 3949 | 46.43222285 | -91.91595768 | 2021-01-21 05:22:01 | Douglas, Wisconsin, US |
3037896 | 3037896 | 2021-01-05 | US | Wyoming | Fremont | 56013 | 4013 | 64 | 0 | 3949 | 43.04183996 | -108.6296893 | 2021-01-06 05:22:16 | Fremont, Wyoming, US |
2121145 | 2121145 | 2020-12-20 | US | Kentucky | McCracken | 21145 | 3985 | 36 | 0 | 3949 | 37.05350953 | -88.70445755 | 2020-12-21 05:27:58 | McCracken, Kentucky, US |
3151847 | 3151847 | 2020-12-16 | US | New York | Schenectady | 36093 | 4014 | 65 | 0 | 3949 | 42.81668777 | -74.05278291 | 2020-12-17 05:28:12 | Schenectady, New York, US |
3151174 | 3151174 | 2020-12-16 | US | Maryland | Wicomico | 24045 | 4018 | 69 | 0 | 3949 | 38.37301947 | -75.62705831 | 2020-12-17 05:28:12 | Wicomico, Maryland, US |
1037373 | 1037373 | 2020-12-15 | US | Texas | Anderson | 48001 | 3467 | 54 | 0 | 3949 | 31.81534745 | -95.65354823 | 2020-12-16 05:28:04 | Anderson, Texas, US |
3849826 | 3849826 | 2020-12-13 | US | Nebraska | Buffalo | 31019 | 3994 | 45 | 0 | 3949 | 40.85486962 | -99.07500296 | 2020-12-14 05:26:27 | Buffalo, Nebraska, US |
3848868 | 3848868 | 2020-12-13 | US | Indiana | Grant | 18053 | 4027 | 78 | 0 | 3949 | 40.51587228 | -85.65468702 | 2020-12-14 05:26:27 | Grant, Indiana, US |
1632488 | 1632488 | 2020-12-05 | Russia | Astrakhan Oblast | 14483 | 273 | 10261 | 3949 | 47.1878186 | 47.608851 | 2020-12-06 05:26:18 | Astrakhan Oblast, Russia | ||
76962 | 76962 | 2020-12-03 | US | Missouri | Cass | 29037 | 3989 | 40 | 0 | 3949 | 38.64789422 | -94.353399 | 2020-12-04 05:27:27 | Cass, Missouri, US |
741277 | 741277 | 2020-12-02 | US | Tennessee | Robertson | 47147 | 4017 | 53 | 0 | 3949 | 36.52454807 | -86.87346725 | 2020-12-03 05:28:22 | Robertson, Tennessee, US |
3170911 | 3170911 | 2020-11-16 | US | Kansas | Finney | 20055 | 3972 | 23 | 0 | 3949 | 38.04340344 | -100.7381938 | 2020-11-17 05:25:54 | Finney, Kansas, US |
1798239 | 1798239 | 2020-10-19 | Ukraine | Cherkasy Oblast | 6892 | 70 | 2873 | 3949 | 49.4444 | 32.0598 | 2020-10-20 04:24:22 | Cherkasy Oblast, Ukraine | ||
1026792 | 1026792 | 2020-10-17 | US | Arizona | Mohave | 4015 | 4178 | 229 | 0 | 3949 | 35.70471703 | -113.7577902 | 2020-10-18 04:24:25 | Mohave, Arizona, US |
1042137 | 1042137 | 2020-10-07 | Sweden | Ostergotland | 4227 | 278 | 0 | 3949 | 58.3454 | 15.5198 | 2020-10-08 04:23:56 | Ostergotland, Sweden | ||
1444771 | 1444771 | 2020-09-11 | Russia | Chelyabinsk Oblast | 14384 | 111 | 10324 | 3949 | 54.4223954 | 61.1865846 | 2020-09-12 04:25:05 | Chelyabinsk Oblast, Russia | ||
2171713 | 2171713 | 2020-09-09 | Peru | Pasco | 4179 | 230 | 0 | 3949 | -10.39655 | -75.307635 | 2020-09-10 04:29:01 | Pasco, Peru | ||
2060768 | 2060768 | 2020-09-01 | US | Georgia | Whitfield | 13313 | 4002 | 53 | 0 | 3949 | 34.80987459 | -84.96093476 | 2020-09-02 04:28:25 | Whitfield, Georgia, US |
609831 | 609831 | 2020-08-29 | Pakistan | Sindh | 129179 | 2395 | 122835 | 3949 | 26.009446 | 68.77680699999999 | 2020-08-30 04:28:22 | Sindh, Pakistan | ||
2990988 | 2990988 | 2020-08-24 | Australia | Victoria | 18464 | 438 | 14077 | 3949 | -37.8136 | 144.9631 | 2020-08-25 04:28:02 | Victoria, Australia | ||
3179789 | 3179789 | 2020-08-18 | US | Mississippi | DeSoto | 28033 | 3983 | 34 | 0 | 3949 | 34.87625235 | -89.99091418 | 2020-08-19 04:27:00 | DeSoto, Mississippi, US |
839290 | 839290 | 2020-08-17 | US | Minnesota | Anoka | 27003 | 4064 | 115 | 0 | 3949 | 45.27476015 | -93.24604565 | 2020-08-18 04:27:56 | Anoka, Minnesota, US |
3921147 | 3921147 | 2020-08-09 | US | Colorado | Jefferson | 8059 | 4406 | 234 | 0 | 3949 | 39.58635604 | -105.2517692 | 2020-08-10 04:34:55 | Jefferson, Colorado, US |
2223131 | 2223131 | 2020-07-08 | Singapore | 45298 | 26 | 41323 | 3949 | 1.2833 | 103.8333 | 2020-07-09 04:34:23 | Singapore | |||
2685017 | 2685017 | 2020-07-06 | India | Rajasthan | 20688 | 461 | 16278 | 3949 | 26.583423 | 73.847973 | 2020-07-07 04:34:00 | Rajasthan, India | ||
933173 | 933173 | 2020-04-16 | US | Connecticut | New Haven | 9009 | 4163 | 214 | 0 | 3949 | 41.408032500000004 | -72.93620426 | 2020-04-16 23:30:51 | New Haven, Connecticut, US |
2565494 | 2565494 | 2020-04-11 | US | Washington | King | 53033 | 4262 | 313 | 0 | 3949 | 47.49137892 | -121.8346131 | 2020-04-11 22:45:33 | King, Washington, 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]);