johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
81 rows where confirmed = 7481 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
452032 | 452032 | 2022-12-21 | US | Colorado | Montezuma | 8083 | 7481 | 89 | 0 | 37.33859579 | -108.5958857 | 2022-12-22 04:20:56 | Montezuma, Colorado, US | |
351715 | 351715 | 2022-12-14 | US | Virginia | Staunton | 51790 | 7481 | 132 | 0 | 38.15965544 | -79.05979937 | 2022-12-15 04:20:58 | Staunton, Virginia, US | |
311303 | 311303 | 2022-12-13 | US | Virginia | Staunton | 51790 | 7481 | 132 | 0 | 38.15965544 | -79.05979937 | 2022-12-14 04:21:04 | Staunton, Virginia, US | |
3936585 | 3936585 | 2022-12-09 | US | Arkansas | Yell | 5149 | 7481 | 117 | 0 | 35.00292371 | -93.41171338 | 2022-12-10 04:21:02 | Yell, Arkansas, US | |
2559016 | 2559016 | 2022-11-29 | US | North Dakota | Rolette | 38079 | 7481 | 43 | 0 | 48.77245354 | -99.84097493 | 2022-11-30 04:21:07 | Rolette, North Dakota, US | |
1641353 | 1641353 | 2022-11-20 | US | Illinois | Jersey | 17083 | 7481 | 76 | 0 | 39.08869046 | -90.35393073 | 2022-11-21 04:21:05 | Jersey, Illinois, US | |
2064910 | 2064910 | 2022-11-19 | US | Illinois | Jersey | 17083 | 7481 | 76 | 0 | 39.08869046 | -90.35393073 | 2022-11-20 04:21:08 | Jersey, Illinois, US | |
1756304 | 1756304 | 2022-11-18 | US | Illinois | Jersey | 17083 | 7481 | 76 | 0 | 39.08869046 | -90.35393073 | 2022-11-19 04:21:14 | Jersey, Illinois, US | |
3998066 | 3998066 | 2022-09-27 | US | Virginia | Winchester | 51840 | 7481 | 88 | 0 | 39.17054517 | -78.17325058 | 2022-09-28 04:23:01 | Winchester, Virginia, US | |
1370845 | 1370845 | 2022-09-21 | US | Alabama | Bibb | 1007 | 7481 | 107 | 0 | 32.99642064 | -87.1251146 | 2022-09-22 04:22:56 | Bibb, Alabama, US | |
2017075 | 2017075 | 2022-09-20 | US | Alabama | Bibb | 1007 | 7481 | 107 | 0 | 32.99642064 | -87.1251146 | 2022-09-21 04:23:22 | Bibb, Alabama, US | |
3570948 | 3570948 | 2022-09-19 | US | Alabama | Bibb | 1007 | 7481 | 107 | 0 | 32.99642064 | -87.1251146 | 2022-09-20 04:22:48 | Bibb, Alabama, US | |
419687 | 419687 | 2022-09-18 | US | Alabama | Bibb | 1007 | 7481 | 107 | 0 | 32.99642064 | -87.1251146 | 2022-09-19 04:21:49 | Bibb, Alabama, US | |
3373711 | 3373711 | 2022-09-17 | US | Alabama | Bibb | 1007 | 7481 | 107 | 0 | 32.99642064 | -87.1251146 | 2022-09-18 04:22:50 | Bibb, Alabama, US | |
2355819 | 2355819 | 2022-09-16 | US | Alabama | Bibb | 1007 | 7481 | 107 | 0 | 32.99642064 | -87.1251146 | 2022-09-17 04:20:19 | Bibb, Alabama, US | |
3986976 | 3986976 | 2022-09-15 | US | Alabama | Bibb | 1007 | 7481 | 107 | 0 | 32.99642064 | -87.1251146 | 2022-09-16 04:21:19 | Bibb, Alabama, US | |
1089269 | 1089269 | 2022-08-09 | US | Texas | Palo Pinto | 48363 | 7481 | 155 | 0 | 32.75310985 | -98.31319001 | 2022-08-10 04:20:57 | Palo Pinto, Texas, US | |
1406126 | 1406126 | 2022-08-02 | US | Indiana | Decatur | 18031 | 7481 | 148 | 0 | 39.30712658 | -85.50087166 | 2022-08-03 04:20:59 | Decatur, Indiana, US | |
3618164 | 3618164 | 2022-08-01 | US | Indiana | Decatur | 18031 | 7481 | 148 | 0 | 39.30712658 | -85.50087166 | 2022-08-02 04:20:53 | Decatur, Indiana, US | |
3144362 | 3144362 | 2022-06-11 | US | Puerto Rico | San Lorenzo | 72129 | 7481 | 0 | 0 | 18.147987 | -65.976392 | 2022-06-12 04:20:53 | San Lorenzo, Puerto Rico, US | |
3917070 | 3917070 | 2022-05-01 | US | Illinois | Perry | 17145 | 7481 | 97 | 0 | 38.08510853 | -89.36856219 | 2022-05-02 04:21:10 | Perry, Illinois, US | |
2841874 | 2841874 | 2022-04-30 | US | Illinois | Perry | 17145 | 7481 | 97 | 0 | 38.08510853 | -89.36856219 | 2022-05-01 04:20:57 | Perry, Illinois, US | |
1158187 | 1158187 | 2022-04-29 | US | Illinois | Perry | 17145 | 7481 | 97 | 0 | 38.08510853 | -89.36856219 | 2022-04-30 04:21:05 | Perry, Illinois, US | |
1697369 | 1697369 | 2022-04-28 | US | Illinois | Perry | 17145 | 7481 | 97 | 0 | 38.08510853 | -89.36856219 | 2022-04-29 04:20:59 | Perry, Illinois, US | |
2445223 | 2445223 | 2022-04-13 | US | Ohio | Gallia | 39053 | 7481 | 128 | 0 | 38.82708533 | -82.31647569 | 2022-04-13 23:21:06 | Gallia, Ohio, US | |
1950980 | 1950980 | 2022-04-12 | US | Ohio | Gallia | 39053 | 7481 | 128 | 0 | 38.82708533 | -82.31647569 | 2022-04-13 04:21:03 | Gallia, Ohio, US | |
3208733 | 3208733 | 2022-04-11 | US | Ohio | Gallia | 39053 | 7481 | 128 | 0 | 38.82708533 | -82.31647569 | 2022-04-12 04:20:49 | Gallia, Ohio, US | |
1578619 | 1578619 | 2022-04-10 | US | Ohio | Gallia | 39053 | 7481 | 128 | 0 | 38.82708533 | -82.31647569 | 2022-04-11 04:21:02 | Gallia, Ohio, US | |
1654861 | 1654861 | 2022-04-09 | US | Ohio | Gallia | 39053 | 7481 | 128 | 0 | 38.82708533 | -82.31647569 | 2022-04-10 04:20:52 | Gallia, Ohio, US | |
2118183 | 2118183 | 2022-04-08 | US | Ohio | Gallia | 39053 | 7481 | 128 | 0 | 38.82708533 | -82.31647569 | 2022-04-09 04:20:42 | Gallia, Ohio, US | |
3322707 | 3322707 | 2022-04-07 | US | Ohio | Gallia | 39053 | 7481 | 128 | 0 | 38.82708533 | -82.31647569 | 2022-04-08 04:20:48 | Gallia, Ohio, US | |
188773 | 188773 | 2022-02-13 | US | Pennsylvania | Susquehanna | 42115 | 7481 | 103 | 0 | 41.82147784 | -75.80071959 | 2022-02-14 04:20:51 | Susquehanna, Pennsylvania, US | |
2015540 | 2015540 | 2022-02-06 | US | South Carolina | Marlboro | 45069 | 7481 | 94 | 0 | 34.59905577 | -79.67561152 | 2022-02-07 04:21:05 | Marlboro, South Carolina, US | |
1296869 | 1296869 | 2022-02-05 | US | South Carolina | Marlboro | 45069 | 7481 | 94 | 0 | 34.59905577 | -79.67561152 | 2022-02-06 04:21:00 | Marlboro, South Carolina, US | |
2330197 | 2330197 | 2022-02-04 | US | South Carolina | Marlboro | 45069 | 7481 | 94 | 0 | 34.59905577 | -79.67561152 | 2022-02-05 04:21:05 | Marlboro, South Carolina, US | |
1231096 | 1231096 | 2022-01-24 | US | West Virginia | Greenbrier | 54025 | 7481 | 124 | 0 | 37.9463652 | -80.45335881 | 2022-01-25 04:21:05 | Greenbrier, West Virginia, US | |
1283820 | 1283820 | 2022-01-05 | US | Mississippi | Marshall | 28093 | 7481 | 147 | 0 | 34.76216286 | -89.50299462 | 2022-01-06 04:22:09 | Marshall, Mississippi, US | |
2113190 | 2113190 | 2021-12-26 | US | Louisiana | Avoyelles | 22009 | 7481 | 181 | 0 | 31.07796211 | -92.00079449 | 2021-12-27 04:21:58 | Avoyelles, Louisiana, US | |
3606562 | 3606562 | 2021-12-25 | US | Louisiana | Avoyelles | 22009 | 7481 | 181 | 0 | 31.07796211 | -92.00079449 | 2021-12-26 04:21:50 | Avoyelles, Louisiana, US | |
2964880 | 2964880 | 2021-12-24 | US | Louisiana | Avoyelles | 22009 | 7481 | 181 | 0 | 31.07796211 | -92.00079449 | 2021-12-25 04:21:37 | Avoyelles, Louisiana, US | |
3817912 | 3817912 | 2021-12-23 | US | Louisiana | Avoyelles | 22009 | 7481 | 181 | 0 | 31.07796211 | -92.00079449 | 2021-12-24 04:21:34 | Avoyelles, Louisiana, US | |
2904806 | 2904806 | 2021-12-19 | US | Indiana | Gibson | 18051 | 7481 | 121 | 0 | 38.30393723 | -87.58054938 | 2021-12-20 04:21:43 | Gibson, Indiana, US | |
1259879 | 1259879 | 2021-12-18 | US | Indiana | Gibson | 18051 | 7481 | 121 | 0 | 38.30393723 | -87.58054938 | 2021-12-19 04:21:11 | Gibson, Indiana, US | |
2399907 | 2399907 | 2021-12-17 | US | Indiana | Gibson | 18051 | 7481 | 121 | 0 | 38.30393723 | -87.58054938 | 2021-12-18 02:22:20 | Gibson, Indiana, US | |
1232646 | 1232646 | 2021-11-28 | US | Illinois | Macoupin | 17117 | 7481 | 115 | 0 | 39.26119767 | -89.92424028 | 2021-11-29 04:22:30 | Macoupin, Illinois, US | |
1359353 | 1359353 | 2021-11-27 | US | Illinois | Macoupin | 17117 | 7481 | 115 | 0 | 39.26119767 | -89.92424028 | 2021-11-28 04:22:43 | Macoupin, Illinois, US | |
759344 | 759344 | 2021-11-26 | US | Illinois | Macoupin | 17117 | 7481 | 115 | 0 | 39.26119767 | -89.92424028 | 2021-11-27 04:22:45 | Macoupin, Illinois, US | |
1803761 | 1803761 | 2021-11-25 | US | Illinois | Macoupin | 17117 | 7481 | 115 | 0 | 39.26119767 | -89.92424028 | 2021-11-26 04:22:33 | Macoupin, Illinois, US | |
905195 | 905195 | 2021-11-24 | US | Illinois | Macoupin | 17117 | 7481 | 115 | 0 | 39.26119767 | -89.92424028 | 2021-11-25 04:22:33 | Macoupin, Illinois, US | |
3750843 | 3750843 | 2021-11-22 | US | Minnesota | Douglas | 27041 | 7481 | 99 | 0 | 45.93348491 | -95.45335469 | 2021-11-23 04:22:39 | Douglas, Minnesota, US | |
1016296 | 1016296 | 2021-11-21 | US | Missouri | Scott | 29201 | 7481 | 120 | 0 | 37.05588075 | -89.56474493 | 2021-11-22 04:22:20 | Scott, Missouri, US | |
724460 | 724460 | 2021-11-20 | US | Missouri | Scott | 29201 | 7481 | 120 | 0 | 37.05588075 | -89.56474493 | 2021-11-21 04:22:13 | Scott, Missouri, US | |
3512185 | 3512185 | 2021-11-01 | US | Georgia | Colquitt | 13071 | 7481 | 187 | 0 | 31.18810588 | -83.7677946 | 2021-11-02 04:22:03 | Colquitt, Georgia, US | |
537248 | 537248 | 2021-10-27 | US | Ohio | Seneca | 39147 | 7481 | 152 | 0 | 41.12351311 | -83.12783209 | 2021-10-28 04:22:08 | Seneca, Ohio, US | |
3495789 | 3495789 | 2021-10-26 | US | Wyoming | Sweetwater | 56037 | 7481 | 80 | 0 | 41.65943896 | -108.8827882 | 2021-10-27 04:22:32 | Sweetwater, Wyoming, US | |
3794745 | 3794745 | 2021-10-25 | US | Georgia | Murray | 13213 | 7481 | 134 | 0 | 34.78897608 | -84.74993177 | 2021-10-26 04:22:09 | Murray, Georgia, US | |
3794729 | 3794729 | 2021-10-25 | US | Georgia | Liberty | 13179 | 7481 | 111 | 0 | 31.82588896 | -81.49251135 | 2021-10-26 04:22:09 | Liberty, Georgia, US | |
771459 | 771459 | 2021-10-23 | US | Indiana | Lawrence | 18093 | 7481 | 171 | 0 | 38.84112637 | -86.48361629 | 2021-10-24 04:21:22 | Lawrence, Indiana, US | |
1597263 | 1597263 | 2021-08-26 | US | Illinois | Whiteside | 17195 | 7481 | 174 | 0 | 41.75509713 | -89.91556058 | 2021-08-27 04:21:37 | Whiteside, Illinois, US | |
246138 | 246138 | 2021-08-17 | US | Georgia | Spalding | 13255 | 7481 | 208 | 0 | 33.26310031 | -84.28013991 | 2021-08-18 04:21:35 | Spalding, Georgia, US | |
652897 | 652897 | 2021-08-09 | US | Tennessee | Dickson | 47043 | 7481 | 113 | 0 | 36.14669837 | -87.35891709 | 2021-08-10 04:21:27 | Dickson, Tennessee, US | |
3684395 | 3684395 | 2021-08-02 | US | Idaho | Madison | 16065 | 7481 | 28 | 0 | 43.78141028 | -111.65384740000002 | 2021-08-03 04:21:39 | Madison, Idaho, US | |
581192 | 581192 | 2021-07-13 | US | North Carolina | Rutherford | 37161 | 7481 | 218 | 0 | 35.40114178 | -81.92112099 | 2021-07-14 04:21:35 | Rutherford, North Carolina, US | |
2768298 | 2768298 | 2021-07-01 | US | Virginia | Lynchburg | 51680 | 7481 | 147 | 0 | 37.40021399 | -79.19888138 | 2021-07-02 04:21:47 | Lynchburg, Virginia, US | |
2007480 | 2007480 | 2021-05-12 | US | South Carolina | Kershaw | 45055 | 7481 | 141 | 0 | 34.33988254 | -80.58763164 | 2021-05-13 04:20:51 | Kershaw, South Carolina, US | |
647537 | 647537 | 2021-05-05 | US | Maryland | Wicomico | 24045 | 7481 | 152 | 0 | 38.37301947 | -75.62705831 | 2021-05-06 04:20:38 | Wicomico, Maryland, US | |
1637101 | 1637101 | 2021-04-29 | US | Georgia | Dougherty | 13095 | 7481 | 302 | 0 | 31.53328528 | -84.21722377 | 2021-04-30 04:21:03 | Dougherty, Georgia, US | |
2573432 | 2573432 | 2021-04-13 | US | Minnesota | Rice | 27131 | 7481 | 101 | 0 | 44.3543376 | -93.29658715 | 2021-04-14 04:20:41 | Rice, Minnesota, US | |
3088816 | 3088816 | 2021-04-05 | US | West Virginia | Wood | 54107 | 7481 | 164 | 0 | 39.20967886 | -81.5162836 | 2021-04-06 04:20:32 | Wood, West Virginia, US | |
3455008 | 3455008 | 2021-03-18 | US | New Hampshire | Strafford | 33017 | 7481 | 76 | 0 | 43.291833 | -71.02336013 | 2021-03-19 05:26:09 | Strafford, New Hampshire, US | |
1858404 | 1858404 | 2021-02-25 | US | Alabama | Talladega | 1121 | 7481 | 163 | 0 | 7318 | 33.37823223 | -86.16886178 | 2021-02-26 05:22:40 | Talladega, Alabama, US |
2639679 | 2639679 | 2021-02-11 | US | Missouri | St. Francois | 29187 | 7481 | 96 | 0 | 7385 | 37.81214171 | -90.47598685 | 2021-02-12 05:23:29 | St. Francois, Missouri, US |
1897576 | 1897576 | 2021-01-29 | US | Alaska | Matanuska-Susitna | 2170 | 7481 | 27 | 0 | 7454 | 62.31305045 | -149.5741743 | 2021-01-30 05:22:49 | Matanuska-Susitna, Alaska, US |
3879653 | 3879653 | 2021-01-14 | Mexico | Campeche | 7481 | 984 | 0 | 6497 | 19.8301 | -90.5349 | 2021-01-15 05:22:24 | Campeche, Mexico | ||
1035320 | 1035320 | 2020-12-15 | US | Idaho | Twin Falls | 16083 | 7481 | 107 | 0 | 7374 | 42.35440512 | -114.6685381 | 2020-12-16 05:28:04 | Twin Falls, Idaho, US |
379490 | 379490 | 2020-11-06 | US | Virginia | Chesterfield | 51041 | 7481 | 120 | 0 | 7361 | 37.37373208 | -77.58680140000001 | 2020-11-07 05:24:52 | Chesterfield, Virginia, US |
197305 | 197305 | 2020-08-31 | US | Texas | Williamson | 48491 | 7481 | 123 | 0 | 7826 | 30.64655664 | -97.6004854 | 2020-09-01 04:28:31 | Williamson, Texas, US |
2299640 | 2299640 | 2020-08-22 | Russia | Chuvashia Republic | 7481 | 68 | 6169 | 1244 | 55.4259922 | 47.0849429 | 2020-08-23 04:27:48 | Chuvashia Republic, Russia | ||
1558124 | 1558124 | 2020-08-16 | US | New Jersey | Morris | 34027 | 7481 | 830 | 0 | 6651 | 40.86095313 | -74.54553709999998 | 2020-08-17 04:27:20 | Morris, New Jersey, US |
1837280 | 1837280 | 2020-06-14 | Russia | Rostov Oblast | 7481 | 67 | 2931 | 4483 | 47.6222451 | 40.7957942 | 2020-06-15 03:33:14 | Rostov Oblast, Russia | ||
1793132 | 1793132 | 2020-05-31 | US | California | San Diego | 6073 | 7481 | 269 | 0 | 7212 | 33.03484597 | -116.7365326 | 2020-06-01 02:32:46 | San Diego, 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]);