johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
32 rows where confirmed = 12179 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2268405 | 2268405 | 2022-10-22 | US | Arkansas | Independence | 5063 | 12179 | 223 | 0 | 35.74242707 | -91.57001641 | 2022-10-23 04:22:46 | Independence, Arkansas, US | |
3648586 | 3648586 | 2022-08-14 | US | Illinois | Jefferson | 17081 | 12179 | 176 | 0 | 38.29980057 | -88.9240025 | 2022-08-15 04:20:59 | Jefferson, Illinois, US | |
1969592 | 1969592 | 2022-08-13 | US | Illinois | Jefferson | 17081 | 12179 | 176 | 0 | 38.29980057 | -88.9240025 | 2022-08-14 04:20:55 | Jefferson, Illinois, US | |
2889401 | 2889401 | 2022-08-12 | US | Illinois | Jefferson | 17081 | 12179 | 176 | 0 | 38.29980057 | -88.9240025 | 2022-08-13 04:20:52 | Jefferson, Illinois, US | |
962225 | 962225 | 2022-07-19 | US | Virginia | Danville | 51590 | 12179 | 286 | 0 | 36.58022376 | -79.40395668 | 2022-07-20 04:20:59 | Danville, Virginia, US | |
2085659 | 2085659 | 2022-05-15 | US | Minnesota | Beltrami | 27007 | 12179 | 128 | 0 | 47.97373527 | -94.93732139 | 2022-05-16 04:20:47 | Beltrami, Minnesota, US | |
3356369 | 3356369 | 2022-05-14 | US | Minnesota | Beltrami | 27007 | 12179 | 128 | 0 | 47.97373527 | -94.93732139 | 2022-05-15 04:20:53 | Beltrami, Minnesota, US | |
660014 | 660014 | 2022-05-13 | US | Minnesota | Beltrami | 27007 | 12179 | 128 | 0 | 47.97373527 | -94.93732139 | 2022-05-14 04:20:48 | Beltrami, Minnesota, US | |
3448199 | 3448199 | 2022-05-11 | US | Virginia | Henry | 51089 | 12179 | 266 | 0 | 36.68542395 | -79.87634026 | 2022-05-12 04:20:54 | Henry, Virginia, US | |
2672093 | 2672093 | 2022-04-15 | US | New York | Washington | 36115 | 12179 | 113 | 0 | 43.31153794 | -73.43043448 | 2022-04-16 04:20:48 | Washington, New York, US | |
3069841 | 3069841 | 2021-11-23 | China | Unknown | 12179 | 0 | 0 | 2021-11-24 04:22:14 | Unknown, China | |||||
47111 | 47111 | 2021-11-02 | US | Virginia | Roanoke City | 51770 | 12179 | 241 | 0 | 37.27791025 | -79.96189766 | 2021-11-03 06:22:09 | Roanoke City, Virginia, US | |
470803 | 470803 | 2021-10-07 | US | Virginia | Portsmouth | 51740 | 12179 | 228 | 0 | 36.85914825 | -76.35971629 | 2021-10-08 04:21:25 | Portsmouth, Virginia, US | |
3298859 | 3298859 | 2021-07-30 | US | Pennsylvania | Lycoming | 42081 | 12179 | 298 | 0 | 41.34310539 | -77.06629984 | 2021-07-31 04:21:35 | Lycoming, Pennsylvania, US | |
2423332 | 2423332 | 2021-06-23 | US | Arizona | Cochise | 4003 | 12179 | 292 | 0 | 31.87934684 | -109.7516088 | 2021-06-24 04:21:55 | Cochise, Arizona, US | |
3577588 | 3577588 | 2021-05-17 | US | Tennessee | Unassigned | 90047 | 12179 | 131 | 0 | 36.55606529 | 0.0 | 2021-05-18 04:20:33 | Unassigned, Tennessee, US | |
383439 | 383439 | 2021-04-30 | US | Texas | Wichita | 48485 | 12179 | 375 | 0 | 33.98842886 | -98.7041034 | 2021-05-01 04:20:47 | Wichita, Texas, US | |
1639562 | 1639562 | 2021-04-29 | US | Texas | Wichita | 48485 | 12179 | 375 | 0 | 33.98842886 | -98.7041034 | 2021-04-30 04:21:03 | Wichita, Texas, US | |
2571748 | 2571748 | 2021-04-13 | Mali | 12179 | 417 | 7194 | 4568 | 17.570692 | -3.996166000000001 | 2021-04-14 04:20:41 | Mali | |||
1205547 | 1205547 | 2021-03-22 | US | Minnesota | Olmsted | 27109 | 12179 | 93 | 0 | 44.00374114 | -92.40209944 | 2021-03-23 05:26:18 | Olmsted, Minnesota, US | |
1618777 | 1618777 | 2021-03-05 | US | Oklahoma | Comanche | 40031 | 12179 | 140 | 0 | 12039 | 34.65973764 | -98.47195055 | 2021-03-06 04:23:41 | Comanche, Oklahoma, US |
3602219 | 3602219 | 2021-02-17 | US | Iowa | Dubuque | 19061 | 12179 | 190 | 0 | 11989 | 42.46815349 | -90.88181925 | 2021-02-18 05:22:58 | Dubuque, Iowa, US |
2285229 | 2285229 | 2021-02-14 | US | Mississippi | Jackson | 28059 | 12179 | 213 | 0 | 11966 | 30.54020656 | -88.64184064 | 2021-02-15 05:24:49 | Jackson, Mississippi, US |
1591367 | 1591367 | 2021-02-05 | US | Texas | Randall | 48381 | 12179 | 245 | 0 | 15638 | 34.96585996 | -101.8971322 | 2021-02-06 05:23:55 | Randall, Texas, US |
340620 | 340620 | 2021-02-03 | US | Alabama | Calhoun | 1015 | 12179 | 239 | 0 | 11940 | 33.77483727 | -85.82630386 | 2021-02-04 05:22:26 | Calhoun, Alabama, US |
2429256 | 2429256 | 2021-01-23 | US | North Carolina | Rowan | 37159 | 12179 | 235 | 0 | 11944 | 35.64003916 | -80.52446628 | 2021-01-24 05:22:35 | Rowan, North Carolina, US |
154310 | 154310 | 2021-01-08 | Syria | 12179 | 763 | 5889 | 5527 | 34.802075 | 38.99681500000001 | 2021-01-09 05:22:18 | Syria | |||
1064170 | 1064170 | 2021-01-04 | US | North Carolina | Johnston | 37101 | 12179 | 113 | 0 | 12066 | 35.51745004 | -78.36622717 | 2021-01-05 05:21:49 | Johnston, North Carolina, US |
821970 | 821970 | 2020-11-19 | US | Alabama | Tuscaloosa | 1125 | 12179 | 149 | 0 | 12030 | 33.28726072 | -87.52556818 | 2020-11-20 05:26:28 | Tuscaloosa, Alabama, US |
2379749 | 2379749 | 2020-10-01 | Netherlands | Gelderland | 12179 | 704 | 0 | 11348 | 52.061738 | 5.939114 | 2020-10-02 04:23:51 | Gelderland, Netherlands | ||
2661771 | 2661771 | 2020-09-04 | Italy | Toscana | 12179 | 1143 | 9219 | 1817 | 43.76923077 | 11.25588885 | 2020-09-05 04:28:19 | Toscana, Italy | ||
2661570 | 2661570 | 2020-09-04 | Chile | Maule | 12179 | 270 | 10992 | 917 | -35.5183 | -71.6885 | 2020-09-05 04:28:19 | Maule, Chile |
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]);