johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
50 rows where confirmed = 12673 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 7
- US 39
- Sweden 6
- Burkina Faso 1
- Germany 1
- Russia 1
- Saint Lucia 1
- Spain 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3217730 | 3217730 | 2022-10-12 | US | Virginia | Wise | 51195 | 12673 | 208 | 0 | 36.9746148 | -82.62410519 | 2022-10-13 04:22:39 | Wise, Virginia, US | |
256753 | 256753 | 2022-09-08 | US | Washington | Douglas | 53017 | 12673 | 79 | 0 | 47.7361335 | -119.692937 | 2022-09-09 04:21:11 | Douglas, Washington, US | |
3748551 | 3748551 | 2022-09-07 | US | Washington | Douglas | 53017 | 12673 | 79 | 0 | 47.7361335 | -119.692937 | 2022-09-08 04:21:02 | Douglas, Washington, US | |
3549782 | 3549782 | 2022-09-01 | US | New York | Tioga | 36107 | 12673 | 88 | 0 | 42.16852837 | -76.30835812 | 2022-09-02 04:21:07 | Tioga, New York, US | |
3650913 | 3650913 | 2022-08-14 | US | Virginia | Danville | 51590 | 12673 | 286 | 0 | 36.58022376 | -79.40395668 | 2022-08-15 04:20:59 | Danville, Virginia, US | |
1971919 | 1971919 | 2022-08-13 | US | Virginia | Danville | 51590 | 12673 | 286 | 0 | 36.58022376 | -79.40395668 | 2022-08-14 04:20:55 | Danville, Virginia, US | |
2891728 | 2891728 | 2022-08-12 | US | Virginia | Danville | 51590 | 12673 | 286 | 0 | 36.58022376 | -79.40395668 | 2022-08-13 04:20:52 | Danville, Virginia, US | |
1067409 | 1067409 | 2022-07-28 | US | Louisiana | St. Bernard | 22087 | 12673 | 114 | 0 | 29.87761636 | -89.51887093 | 2022-07-29 04:20:45 | St. Bernard, Louisiana, US | |
1490336 | 1490336 | 2022-07-26 | US | Puerto Rico | Humacao | 72069 | 12673 | 0 | 0 | 18.145211 | -65.810174 | 2022-07-27 04:21:04 | Humacao, Puerto Rico, US | |
478629 | 478629 | 2022-06-26 | US | Texas | Navarro | 48349 | 12673 | 221 | 0 | 32.04620681 | -96.47428766 | 2022-06-27 04:21:00 | Navarro, Texas, US | |
562375 | 562375 | 2022-06-16 | US | Wisconsin | Monroe | 55081 | 12673 | 97 | 0 | 43.94641218 | -90.618819 | 2022-06-17 04:20:56 | Monroe, Wisconsin, US | |
2309891 | 2309891 | 2022-04-20 | US | Oklahoma | Washington | 40147 | 12673 | 257 | 0 | 36.71380786 | -95.90514104 | 2022-04-21 04:20:46 | Washington, Oklahoma, US | |
2254030 | 2254030 | 2022-04-19 | US | Oklahoma | Washington | 40147 | 12673 | 257 | 0 | 36.71380786 | -95.90514104 | 2022-04-20 04:20:45 | Washington, Oklahoma, US | |
1848580 | 1848580 | 2022-04-18 | US | Oklahoma | Washington | 40147 | 12673 | 257 | 0 | 36.71380786 | -95.90514104 | 2022-04-19 04:21:00 | Washington, Oklahoma, US | |
3419524 | 3419524 | 2022-04-17 | US | Oklahoma | Washington | 40147 | 12673 | 257 | 0 | 36.71380786 | -95.90514104 | 2022-04-18 04:21:12 | Washington, Oklahoma, US | |
306473 | 306473 | 2022-04-16 | US | Oklahoma | Washington | 40147 | 12673 | 257 | 0 | 36.71380786 | -95.90514104 | 2022-04-17 04:20:59 | Washington, Oklahoma, US | |
2672418 | 2672418 | 2022-04-15 | US | Oklahoma | Washington | 40147 | 12673 | 257 | 0 | 36.71380786 | -95.90514104 | 2022-04-16 04:20:48 | Washington, Oklahoma, US | |
1226203 | 1226203 | 2022-04-14 | US | Oklahoma | Washington | 40147 | 12673 | 257 | 0 | 36.71380786 | -95.90514104 | 2022-04-15 04:20:57 | Washington, Oklahoma, US | |
2141190 | 2141190 | 2022-03-09 | US | Illinois | Macoupin | 17117 | 12673 | 137 | 0 | 39.26119767 | -89.92424028 | 2022-03-10 04:20:48 | Macoupin, Illinois, US | |
462922 | 462922 | 2022-02-02 | US | Wisconsin | Dunn | 55033 | 12673 | 66 | 0 | 44.94562799 | -91.8962481 | 2022-02-03 04:21:21 | Dunn, Wisconsin, US | |
2170787 | 2170787 | 2022-01-01 | US | Texas | Starr | 48427 | 12673 | 337 | 0 | 26.56150059 | -98.73892358 | 2022-01-02 04:20:52 | Starr, Texas, US | |
3752530 | 3752530 | 2021-11-22 | US | Virginia | Roanoke City | 51770 | 12673 | 255 | 0 | 37.27791025 | -79.96189766 | 2021-11-23 04:22:39 | Roanoke City, Virginia, US | |
3121777 | 3121777 | 2021-11-05 | Saint Lucia | 12673 | 260 | 0 | 13.9094 | -60.9789 | 2021-11-06 04:21:51 | Saint Lucia | ||||
599100 | 599100 | 2021-10-19 | US | Kentucky | Laurel | 21125 | 12673 | 112 | 0 | 37.10975748 | -84.11321779 | 2021-10-20 04:21:00 | Laurel, Kentucky, US | |
604034 | 604034 | 2021-09-23 | US | North Carolina | Moore | 37125 | 12673 | 228 | 0 | 35.30885257 | -79.48474178 | 2021-09-24 04:21:44 | Moore, North Carolina, US | |
3282742 | 3282742 | 2021-09-05 | US | Missouri | Buchanan | 29021 | 12673 | 172 | 0 | 39.65816401 | -94.80138942 | 2021-09-06 04:21:22 | Buchanan, Missouri, US | |
3685658 | 3685658 | 2021-08-02 | US | New Mexico | Sandoval | 35043 | 12673 | 244 | 0 | 35.68862401 | -106.8687803 | 2021-08-03 04:21:39 | Sandoval, New Mexico, US | |
3684564 | 3684564 | 2021-08-02 | US | Indiana | Monroe | 18105 | 12673 | 178 | 0 | 39.16130004 | -86.52414358 | 2021-08-03 04:21:39 | Monroe, Indiana, US | |
781566 | 781566 | 2021-07-08 | US | Texas | Rockwall | 48397 | 12673 | 158 | 0 | 32.89779518 | -96.40771592 | 2021-07-09 04:21:21 | Rockwall, Texas, US | |
3384808 | 3384808 | 2021-06-13 | US | Washington | Franklin | 53021 | 12673 | 114 | 0 | 46.53351425 | -118.9018212 | 2021-06-14 04:22:46 | Franklin, Washington, US | |
1739942 | 1739942 | 2021-06-12 | US | Washington | Franklin | 53021 | 12673 | 114 | 0 | 46.53351425 | -118.9018212 | 2021-06-13 04:22:44 | Franklin, Washington, US | |
3575296 | 3575296 | 2021-05-17 | US | Florida | Indian River | 12061 | 12673 | 304 | 0 | 27.69308961 | -80.60556721 | 2021-05-18 04:20:33 | Indian River, Florida, US | |
3955596 | 3955596 | 2021-05-11 | US | Indiana | Madison | 18095 | 12673 | 339 | 0 | 40.16143691 | -85.71964711 | 2021-05-12 04:21:29 | Madison, Indiana, US | |
382691 | 382691 | 2021-04-30 | US | Ohio | Portage | 39133 | 12673 | 210 | 0 | 41.16793482 | -81.19735782 | 2021-05-01 04:20:47 | Portage, Ohio, US | |
1219325 | 1219325 | 2021-03-27 | Burkina Faso | 12673 | 145 | 12330 | 198 | 12.2383 | -1.5616 | 2021-03-28 05:28:10 | Burkina Faso | |||
1206998 | 1206998 | 2021-03-22 | US | Texas | Randall | 48381 | 12673 | 271 | 0 | 34.96585996 | -101.8971322 | 2021-03-23 05:26:18 | Randall, Texas, US | |
3372520 | 3372520 | 2021-03-21 | US | Texas | Randall | 48381 | 12673 | 271 | 0 | 34.96585996 | -101.8971322 | 2021-03-22 05:25:43 | Randall, Texas, US | |
1747730 | 1747730 | 2021-03-20 | US | Texas | Randall | 48381 | 12673 | 271 | 0 | 34.96585996 | -101.8971322 | 2021-03-21 05:25:44 | Randall, Texas, US | |
1062942 | 1062942 | 2021-01-04 | US | Indiana | Johnson | 18081 | 12673 | 270 | 0 | 12403 | 39.48994426 | -86.10149107 | 2021-01-05 05:21:49 | Johnson, Indiana, US |
3761908 | 3761908 | 2020-12-28 | Sweden | Vastmanland | 12673 | 241 | 0 | 12432 | 59.6714 | 16.2159 | 2020-12-29 05:22:37 | Vastmanland, Sweden | ||
3778228 | 3778228 | 2020-12-27 | Sweden | Vastmanland | 12673 | 241 | 0 | 12432 | 59.6714 | 16.2159 | 2020-12-28 05:22:06 | Vastmanland, Sweden | ||
2227090 | 2227090 | 2020-12-26 | US | Wisconsin | Washington | 55131 | 12673 | 98 | 0 | 12575 | 43.36863664 | -88.22974712 | 2020-12-27 05:22:55 | Washington, Wisconsin, US |
2223833 | 2223833 | 2020-12-26 | Sweden | Vastmanland | 12673 | 241 | 0 | 12432 | 59.6714 | 16.2159 | 2020-12-27 05:22:55 | Vastmanland, Sweden | ||
203278 | 203278 | 2020-12-25 | US | Illinois | Peoria | 17143 | 12673 | 180 | 0 | 12493 | 40.78702156 | -89.76078901 | 2020-12-26 05:22:28 | Peoria, Illinois, US |
202580 | 202580 | 2020-12-25 | Sweden | Vastmanland | 12673 | 241 | 0 | 12432 | 59.6714 | 16.2159 | 2020-12-26 05:22:28 | Vastmanland, Sweden | ||
3691803 | 3691803 | 2020-12-24 | Sweden | Vastmanland | 12673 | 241 | 0 | 12432 | 59.6714 | 16.2159 | 2020-12-25 05:22:48 | Vastmanland, Sweden | ||
2407155 | 2407155 | 2020-12-23 | Sweden | Vastmanland | 12673 | 241 | 0 | 12432 | 59.6714 | 16.2159 | 2020-12-24 05:23:04 | Vastmanland, Sweden | ||
2537588 | 2537588 | 2020-12-01 | Russia | Chuvashia Republic | 12673 | 284 | 11543 | 846 | 55.4259922 | 47.0849429 | 2020-12-02 05:27:41 | Chuvashia Republic, Russia | ||
1584082 | 1584082 | 2020-11-30 | Germany | Saarland | 12673 | 252 | 10601 | 2075 | 49.3964 | 7.023 | 2020-12-01 05:26:18 | Saarland, Germany | ||
1793799 | 1793799 | 2020-05-31 | Spain | Andalusia | 12673 | 1404 | 10671 | 598 | 37.5443 | -4.7278 | 2020-06-01 02:32:46 | Andalusia, Spain |
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]);