johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
58 rows where active = 2942 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 44
- Russia 6
- France 2
- Bahrain 1
- Cabo Verde 1
- Colombia 1
- Italy 1
- North Macedonia 1
- Serbia 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1306412 | 1306412 | 2021-07-27 | Russia | Tyva Republic | 20657 | 228 | 17487 | 2942 | 51.4017149 | 93.8582593 | 2021-07-28 04:21:39 | Tyva Republic, Russia | ||
3054424 | 3054424 | 2021-05-13 | Russia | Orenburg Oblast | 43125 | 906 | 39277 | 2942 | 52.02692620000001 | 54.7276647 | 2021-05-14 04:20:41 | Orenburg Oblast, Russia | ||
954625 | 954625 | 2021-04-25 | Cabo Verde | 22349 | 203 | 19204 | 2942 | 16.5388 | -23.0418 | 2021-04-26 04:21:04 | Cabo Verde | |||
3369543 | 3369543 | 2021-03-21 | Russia | Krasnodar Krai | 41219 | 2208 | 36069 | 2942 | 45.7684014 | 39.0261044 | 2021-03-22 05:25:43 | Krasnodar Krai, Russia | ||
1732330 | 1732330 | 2021-03-14 | Colombia | Atlantico | 129066 | 4104 | 122020 | 2942 | 10.6966 | -74.8741 | 2021-03-15 05:25:51 | Atlantico, Colombia | ||
1092046 | 1092046 | 2021-03-03 | US | Missouri | Webster | 29225 | 2995 | 53 | 0 | 2942 | 37.2813734 | -92.876329 | 2021-03-04 05:24:24 | Webster, Missouri, US |
1092017 | 1092017 | 2021-03-03 | US | Missouri | Pulaski | 29169 | 2990 | 48 | 0 | 2942 | 37.82462075 | -92.20783203 | 2021-03-04 05:24:24 | Pulaski, Missouri, US |
2370981 | 2370981 | 2021-02-28 | US | West Virginia | Marshall | 54051 | 3008 | 66 | 0 | 2942 | 39.86064362 | -80.66591062 | 2021-03-01 05:23:01 | Marshall, West Virginia, US |
3067970 | 3067970 | 2021-02-27 | US | Missouri | Webster | 29225 | 2995 | 53 | 0 | 2942 | 37.2813734 | -92.876329 | 2021-02-28 05:22:20 | Webster, Missouri, US |
472436 | 472436 | 2021-02-19 | US | Illinois | Perry | 17145 | 2999 | 57 | 0 | 2942 | 38.08510853 | -89.36856219 | 2021-02-20 05:22:51 | Perry, Illinois, US |
2286584 | 2286584 | 2021-02-14 | US | Texas | Matagorda | 48321 | 3076 | 86 | 0 | 2942 | 28.81955746 | -96.01230294 | 2021-02-15 05:24:49 | Matagorda, Texas, US |
341150 | 341150 | 2021-02-03 | US | Georgia | Toombs | 13279 | 3034 | 92 | 0 | 2942 | 32.12059861 | -82.32957247 | 2021-02-04 05:22:26 | Toombs, Georgia, US |
1685235 | 1685235 | 2021-02-02 | US | Florida | Wakulla | 12129 | 2983 | 41 | 0 | 2942 | 30.16548905 | -84.39895211 | 2021-02-03 05:22:52 | Wakulla, Florida, US |
1677360 | 1677360 | 2021-02-01 | US | Georgia | Wayne | 13305 | 3006 | 64 | 0 | 2942 | 31.5521809 | -81.91894878 | 2021-02-02 05:22:49 | Wayne, Georgia, US |
1899645 | 1899645 | 2021-01-29 | US | Ohio | Ottawa | 39123 | 3011 | 69 | 0 | 2942 | 41.53781826 | -83.0940185 | 2021-01-30 05:22:49 | Ottawa, Ohio, US |
1899389 | 1899389 | 2021-01-29 | US | New York | Livingston | 36051 | 2987 | 45 | 0 | 2942 | 42.72596275 | -77.77966158 | 2021-01-30 05:22:49 | Livingston, New York, US |
2484567 | 2484567 | 2021-01-28 | US | Oklahoma | Woodward | 40153 | 2954 | 12 | 0 | 2942 | 36.42316318 | -99.26283045 | 2021-01-29 05:22:23 | Woodward, Oklahoma, US |
2466512 | 2466512 | 2021-01-22 | Bahrain | 99210 | 366 | 95902 | 2942 | 26.0275 | 50.55 | 2021-01-23 05:22:03 | Bahrain | |||
911116 | 911116 | 2021-01-19 | US | Tennessee | Hardin | 47071 | 3065 | 47 | 0 | 2942 | 35.19732531 | -88.18593755 | 2021-01-20 05:21:54 | Hardin, Tennessee, US |
240680 | 240680 | 2021-01-18 | US | Washington | Lewis | 53041 | 2978 | 36 | 0 | 2942 | 46.57756476 | -122.3925769 | 2021-01-19 05:22:15 | Lewis, Washington, US |
237791 | 237791 | 2021-01-18 | US | California | Mendocino | 6045 | 2976 | 31 | 0 | 2942 | 39.4381191 | -123.3911313 | 2021-01-19 05:22:15 | Mendocino, California, US |
237697 | 237697 | 2021-01-18 | US | Arkansas | Boone | 5009 | 3014 | 72 | 0 | 2942 | 36.3084504 | -93.09374925 | 2021-01-19 05:22:15 | Boone, Arkansas, US |
3506797 | 3506797 | 2021-01-17 | US | Washington | Lewis | 53041 | 2978 | 36 | 0 | 2942 | 46.57756476 | -122.3925769 | 2021-01-18 05:22:34 | Lewis, Washington, US |
3882486 | 3882486 | 2021-01-14 | US | Tennessee | Carroll | 47017 | 3094 | 59 | 0 | 2942 | 35.97366108 | -88.45189331 | 2021-01-15 05:22:24 | Carroll, Tennessee, US |
776073 | 776073 | 2021-01-12 | US | Minnesota | Lyon | 27083 | 2976 | 34 | 0 | 2942 | 44.41327865 | -95.83806103 | 2021-01-13 05:22:15 | Lyon, Minnesota, US |
3900554 | 3900554 | 2021-01-09 | US | Colorado | Broomfield | 8014 | 3267 | 68 | 0 | 2942 | 39.95998787 | -105.0566324 | 2021-01-10 05:22:12 | Broomfield, Colorado, US |
2230432 | 2230432 | 2021-01-02 | US | Tennessee | Cheatham | 47021 | 3009 | 24 | 0 | 2942 | 36.26136216 | -87.08903581 | 2021-01-03 05:22:52 | Cheatham, Tennessee, US |
1137902 | 1137902 | 2021-01-01 | US | Illinois | Morgan | 17137 | 3007 | 65 | 0 | 2942 | 39.71654544 | -90.20255104 | 2021-01-02 05:22:33 | Morgan, Illinois, US |
3696508 | 3696508 | 2020-12-31 | US | Illinois | Morgan | 17137 | 3007 | 65 | 0 | 2942 | 39.71654544 | -90.20255104 | 2021-01-01 05:23:07 | Morgan, Illinois, US |
1012878 | 1012878 | 2020-12-30 | US | Oklahoma | Osage | 40113 | 2968 | 26 | 0 | 2942 | 36.62888819 | -96.39635704 | 2020-12-31 05:22:49 | Osage, Oklahoma, US |
3693724 | 3693724 | 2020-12-24 | US | New York | Oswego | 36075 | 2970 | 28 | 0 | 2942 | 43.42778894 | -76.14635194 | 2020-12-25 05:22:48 | Oswego, New York, US |
928670 | 928670 | 2020-12-21 | US | Illinois | Franklin | 17055 | 2979 | 37 | 0 | 2942 | 37.99189086 | -88.92567818 | 2020-12-22 05:22:33 | Franklin, Illinois, US |
1901533 | 1901533 | 2020-12-18 | US | Alabama | Franklin | 1059 | 2978 | 36 | 0 | 2942 | 34.44235334 | -87.84289505 | 2020-12-19 05:27:52 | Franklin, Alabama, US |
2128238 | 2128238 | 2020-12-17 | Russia | Stavropol Krai | 31683 | 649 | 28092 | 2942 | 44.86325770000001 | 43.4406913 | 2020-12-18 05:28:18 | Stavropol Krai, Russia | ||
1601099 | 1601099 | 2020-12-10 | US | Georgia | Unassigned | 90013 | 2943 | 1 | 0 | 2942 | 34.91369188 | 0.0 | 2020-12-11 05:26:59 | Unassigned, Georgia, US |
1585540 | 1585540 | 2020-11-30 | US | Kentucky | Christian | 21047 | 2981 | 39 | 0 | 2942 | 36.89267803 | -87.49055367 | 2020-12-01 05:26:18 | Christian, Kentucky, US |
3192501 | 3192501 | 2020-11-22 | US | Ohio | Wayne | 39169 | 3035 | 93 | 0 | 2942 | 40.82925852 | -81.88844833 | 2020-11-23 05:25:26 | Wayne, Ohio, US |
2701946 | 2701946 | 2020-11-20 | US | Arizona | Cochise | 4003 | 3020 | 78 | 0 | 2942 | 31.87934684 | -109.7516088 | 2020-11-21 05:25:51 | Cochise, Arizona, US |
1989861 | 1989861 | 2020-11-09 | US | Iowa | Sioux | 19167 | 2963 | 21 | 0 | 2942 | 43.08221074 | -96.1767568 | 2020-11-10 05:40:07 | Sioux, Iowa, US |
754512 | 754512 | 2020-10-28 | Russia | Komi Republic | 12701 | 214 | 9545 | 2942 | 63.9881421 | 54.3326073 | 2020-10-29 04:24:49 | Komi Republic, Russia | ||
3652629 | 3652629 | 2020-10-24 | US | Indiana | Clark | 18019 | 3007 | 65 | 0 | 2942 | 38.48015445 | -85.70510334 | 2020-10-25 04:24:36 | Clark, Indiana, US |
3094197 | 3094197 | 2020-09-20 | US | Georgia | Dougherty | 13095 | 3124 | 182 | 0 | 2942 | 31.53328528 | -84.21722377 | 2020-09-21 04:23:00 | Dougherty, Georgia, US |
3161602 | 3161602 | 2020-09-06 | Italy | Campania | 7868 | 448 | 4478 | 2942 | 40.83956555 | 14.25084984 | 2020-09-07 04:28:30 | Campania, Italy | ||
195827 | 195827 | 2020-08-31 | US | Minnesota | Washington | 27163 | 2996 | 54 | 0 | 2942 | 45.03864533 | -92.88429635 | 2020-09-01 04:28:31 | Washington, Minnesota, US |
610093 | 610093 | 2020-08-29 | US | Alaska | Anchorage | 2020 | 2963 | 21 | 0 | 2942 | 61.14998174 | -149.14269860000005 | 2020-08-30 04:28:22 | Anchorage, Alaska, US |
1481746 | 1481746 | 2020-08-21 | US | New Mexico | San Juan | 35045 | 3131 | 189 | 0 | 2942 | 36.50838318 | -108.320437 | 2020-08-22 04:27:49 | San Juan, New Mexico, US |
3919812 | 3919812 | 2020-08-09 | US | Virginia | Arlington | 51013 | 3077 | 135 | 0 | 2942 | 38.8767675 | -77.10139853 | 2020-08-10 04:34:55 | Arlington, Virginia, US |
3185031 | 3185031 | 2020-07-28 | Russia | Chuvashia Republic | 6609 | 51 | 3616 | 2942 | 55.4259922 | 47.0849429 | 2020-07-29 04:35:11 | Chuvashia Republic, Russia | ||
3203146 | 3203146 | 2020-07-18 | US | Maryland | Howard | 24027 | 3040 | 98 | 0 | 2942 | 39.25305293 | -76.93126208 | 2020-07-19 04:34:58 | Howard, Maryland, US |
3201934 | 3201934 | 2020-07-18 | US | New Jersey | Atlantic | 34001 | 3178 | 236 | 0 | 2942 | 39.47538693 | -74.65848483 | 2020-07-19 04:34:58 | Atlantic, New Jersey, US |
3737517 | 3737517 | 2020-07-12 | France | French Guiana | 5949 | 26 | 2981 | 2942 | 4.0 | -53.0 | 2020-07-13 04:43:04 | French Guiana, France | ||
3435912 | 3435912 | 2020-07-11 | France | French Guiana | 5949 | 26 | 2981 | 2942 | 4.0 | -53.0 | 2020-07-12 04:34:30 | French Guiana, France | ||
887737 | 887737 | 2020-07-07 | Serbia | 16719 | 330 | 13447 | 2942 | 44.0165 | 21.0059 | 2020-07-08 05:33:48 | Serbia | |||
1509254 | 1509254 | 2020-06-22 | US | Arizona | Navajo | 4017 | 3037 | 95 | 0 | 2942 | 35.3997715 | -110.3218983 | 2020-06-23 04:33:22 | Navajo, Arizona, US |
3249730 | 3249730 | 2020-06-21 | North Macedonia | 5106 | 238 | 1926 | 2942 | 41.6086 | 21.7453 | 2020-06-22 04:33:20 | North Macedonia | |||
3680302 | 3680302 | 2020-06-18 | US | California | Fresno | 6019 | 3010 | 57 | 0 | 2942 | 36.75733899 | -119.6466953 | 2020-06-19 04:33:17 | Fresno, California, US |
284962 | 284962 | 2020-06-15 | US | South Carolina | Greenville | 45045 | 3011 | 69 | 0 | 2942 | 34.89502264 | -82.37295012 | 2020-06-16 04:33:09 | Greenville, South Carolina, US |
265917 | 265917 | 2020-05-21 | US | Georgia | DeKalb | 13089 | 3038 | 96 | 0 | 2942 | 33.76944049 | -84.22396017 | 2020-05-22 02:36:51 | DeKalb, Georgia, 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]);