johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
321 rows where confirmed = 2446 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2560098 | 2560098 | 2022-11-29 | US | West Virginia | Pleasants | 54073 | 2446 | 38 | 0 | 39.37091679 | -81.16771771 | 2022-11-30 04:21:07 | Pleasants, West Virginia, US | |
1243172 | 1243172 | 2022-11-28 | US | West Virginia | Pleasants | 54073 | 2446 | 38 | 0 | 39.37091679 | -81.16771771 | 2022-11-29 04:21:05 | Pleasants, West Virginia, US | |
1243144 | 1243144 | 2022-11-28 | US | West Virginia | Doddridge | 54017 | 2446 | 19 | 0 | 39.27057157 | -80.70671527 | 2022-11-29 04:21:05 | Doddridge, West Virginia, US | |
1241602 | 1241602 | 2022-11-28 | US | Missouri | Monroe | 29137 | 2446 | 50 | 0 | 39.49593978 | -92.00043978 | 2022-11-29 04:21:05 | Monroe, Missouri, US | |
3553590 | 3553590 | 2022-11-27 | US | Missouri | Monroe | 29137 | 2446 | 50 | 0 | 39.49593978 | -92.00043978 | 2022-11-28 04:21:02 | Monroe, Missouri, US | |
2102070 | 2102070 | 2022-11-26 | US | Missouri | Monroe | 29137 | 2446 | 50 | 0 | 39.49593978 | -92.00043978 | 2022-11-27 04:21:05 | Monroe, Missouri, US | |
489561 | 489561 | 2022-11-25 | US | Missouri | Monroe | 29137 | 2446 | 50 | 0 | 39.49593978 | -92.00043978 | 2022-11-26 04:21:11 | Monroe, Missouri, US | |
3526788 | 3526788 | 2022-11-24 | US | Virginia | Fairfax City | 51600 | 2446 | 48 | 0 | 38.85157547 | -77.2977964 | 2022-11-25 04:21:06 | Fairfax City, Virginia, US | |
3525390 | 3525390 | 2022-11-24 | US | Missouri | Monroe | 29137 | 2446 | 50 | 0 | 39.49593978 | -92.00043978 | 2022-11-25 04:21:06 | Monroe, Missouri, US | |
3315571 | 3315571 | 2022-11-23 | US | Virginia | Fairfax City | 51600 | 2446 | 48 | 0 | 38.85157547 | -77.2977964 | 2022-11-24 04:21:09 | Fairfax City, Virginia, US | |
3314173 | 3314173 | 2022-11-23 | US | Missouri | Monroe | 29137 | 2446 | 50 | 0 | 39.49593978 | -92.00043978 | 2022-11-24 04:21:09 | Monroe, Missouri, US | |
1623612 | 1623612 | 2022-11-22 | US | Virginia | Fairfax City | 51600 | 2446 | 48 | 0 | 38.85157547 | -77.2977964 | 2022-11-23 04:21:06 | Fairfax City, Virginia, US | |
1622214 | 1622214 | 2022-11-22 | US | Missouri | Monroe | 29137 | 2446 | 50 | 0 | 39.49593978 | -92.00043978 | 2022-11-23 04:21:06 | Monroe, Missouri, US | |
433348 | 433348 | 2022-11-03 | US | Montana | Blaine | 30005 | 2446 | 33 | 0 | 48.43175214 | -108.9582723 | 2022-11-04 04:22:11 | Blaine, Montana, US | |
851590 | 851590 | 2022-11-02 | US | Montana | Blaine | 30005 | 2446 | 33 | 0 | 48.43175214 | -108.9582723 | 2022-11-03 04:22:05 | Blaine, Montana, US | |
712441 | 712441 | 2022-11-01 | US | Montana | Blaine | 30005 | 2446 | 33 | 0 | 48.43175214 | -108.9582723 | 2022-11-02 04:22:09 | Blaine, Montana, US | |
3286890 | 3286890 | 2022-10-31 | US | Montana | Blaine | 30005 | 2446 | 33 | 0 | 48.43175214 | -108.9582723 | 2022-11-01 04:22:36 | Blaine, Montana, US | |
321923 | 321923 | 2022-10-30 | US | Montana | Blaine | 30005 | 2446 | 33 | 0 | 48.43175214 | -108.9582723 | 2022-10-31 04:21:36 | Blaine, Montana, US | |
914199 | 914199 | 2022-10-29 | US | Montana | Blaine | 30005 | 2446 | 33 | 0 | 48.43175214 | -108.9582723 | 2022-10-30 04:22:14 | Blaine, Montana, US | |
1368468 | 1368468 | 2022-10-28 | US | Montana | Blaine | 30005 | 2446 | 33 | 0 | 48.43175214 | -108.9582723 | 2022-10-29 04:21:13 | Blaine, Montana, US | |
2273826 | 2273826 | 2022-10-20 | US | Missouri | DeKalb | 29063 | 2446 | 47 | 0 | 39.89201062 | -94.40476508 | 2022-10-21 04:22:23 | DeKalb, Missouri, US | |
200161 | 200161 | 2022-10-19 | US | Missouri | DeKalb | 29063 | 2446 | 47 | 0 | 39.89201062 | -94.40476508 | 2022-10-20 04:22:59 | DeKalb, Missouri, US | |
2758822 | 2758822 | 2022-10-18 | US | Missouri | DeKalb | 29063 | 2446 | 47 | 0 | 39.89201062 | -94.40476508 | 2022-10-19 04:22:26 | DeKalb, Missouri, US | |
2758183 | 2758183 | 2022-10-18 | US | Kansas | Anderson | 20003 | 2446 | 37 | 0 | 38.21413251 | -95.29272815 | 2022-10-19 04:22:26 | Anderson, Kansas, US | |
2026656 | 2026656 | 2022-10-17 | US | Missouri | DeKalb | 29063 | 2446 | 47 | 0 | 39.89201062 | -94.40476508 | 2022-10-18 04:22:42 | DeKalb, Missouri, US | |
2026017 | 2026017 | 2022-10-17 | US | Kansas | Anderson | 20003 | 2446 | 37 | 0 | 38.21413251 | -95.29272815 | 2022-10-18 04:22:42 | Anderson, Kansas, US | |
2161434 | 2161434 | 2022-10-16 | US | Missouri | DeKalb | 29063 | 2446 | 47 | 0 | 39.89201062 | -94.40476508 | 2022-10-17 04:20:31 | DeKalb, Missouri, US | |
2160795 | 2160795 | 2022-10-16 | US | Kansas | Anderson | 20003 | 2446 | 37 | 0 | 38.21413251 | -95.29272815 | 2022-10-17 04:20:31 | Anderson, Kansas, US | |
517631 | 517631 | 2022-10-15 | US | Missouri | DeKalb | 29063 | 2446 | 47 | 0 | 39.89201062 | -94.40476508 | 2022-10-16 04:22:39 | DeKalb, Missouri, US | |
516992 | 516992 | 2022-10-15 | US | Kansas | Anderson | 20003 | 2446 | 37 | 0 | 38.21413251 | -95.29272815 | 2022-10-16 04:22:39 | Anderson, Kansas, US | |
2034688 | 2034688 | 2022-10-14 | US | Missouri | DeKalb | 29063 | 2446 | 47 | 0 | 39.89201062 | -94.40476508 | 2022-10-15 04:22:00 | DeKalb, Missouri, US | |
2034049 | 2034049 | 2022-10-14 | US | Kansas | Anderson | 20003 | 2446 | 37 | 0 | 38.21413251 | -95.29272815 | 2022-10-15 04:22:00 | Anderson, Kansas, US | |
3754737 | 3754737 | 2022-10-13 | US | Kansas | Anderson | 20003 | 2446 | 37 | 0 | 38.21413251 | -95.29272815 | 2022-10-14 04:22:28 | Anderson, Kansas, US | |
3215562 | 3215562 | 2022-10-12 | US | Kansas | Anderson | 20003 | 2446 | 37 | 0 | 38.21413251 | -95.29272815 | 2022-10-13 04:22:39 | Anderson, Kansas, US | |
2532866 | 2532866 | 2022-10-06 | US | West Virginia | Gilmer | 54021 | 2446 | 22 | 0 | 38.9251277 | -80.85952723 | 2022-10-07 04:23:08 | Gilmer, West Virginia, US | |
1814260 | 1814260 | 2022-10-05 | US | West Virginia | Gilmer | 54021 | 2446 | 22 | 0 | 38.9251277 | -80.85952723 | 2022-10-06 04:21:22 | Gilmer, West Virginia, US | |
3995755 | 3995755 | 2022-09-27 | US | Indiana | Martin | 18101 | 2446 | 27 | 0 | 38.7099921 | -86.80373186 | 2022-09-28 04:23:01 | Martin, Indiana, US | |
2770083 | 2770083 | 2022-09-26 | US | Indiana | Martin | 18101 | 2446 | 27 | 0 | 38.7099921 | -86.80373186 | 2022-09-27 04:23:01 | Martin, Indiana, US | |
1977736 | 1977736 | 2022-09-25 | US | Indiana | Martin | 18101 | 2446 | 27 | 0 | 38.7099921 | -86.80373186 | 2022-09-26 04:20:52 | Martin, Indiana, US | |
2650903 | 2650903 | 2022-09-24 | US | Indiana | Martin | 18101 | 2446 | 27 | 0 | 38.7099921 | -86.80373186 | 2022-09-25 04:23:31 | Martin, Indiana, US | |
385343 | 385343 | 2022-09-23 | US | Indiana | Martin | 18101 | 2446 | 27 | 0 | 38.7099921 | -86.80373186 | 2022-09-24 04:21:40 | Martin, Indiana, US | |
1625409 | 1625409 | 2022-09-22 | US | Indiana | Martin | 18101 | 2446 | 27 | 0 | 38.7099921 | -86.80373186 | 2022-09-23 04:23:13 | Martin, Indiana, US | |
1371613 | 1371613 | 2022-09-21 | US | Indiana | Martin | 18101 | 2446 | 27 | 0 | 38.7099921 | -86.80373186 | 2022-09-22 04:22:56 | Martin, Indiana, US | |
254308 | 254308 | 2022-09-08 | US | Illinois | Hamilton | 17065 | 2446 | 32 | 0 | 38.08163641 | -88.53883373 | 2022-09-09 04:21:11 | Hamilton, Illinois, US | |
1880353 | 1880353 | 2022-08-28 | US | Virginia | Lexington | 51678 | 2446 | 34 | 0 | 37.78258621 | -79.44262866 | 2022-08-29 04:21:06 | Lexington, Virginia, US | |
2099480 | 2099480 | 2022-08-27 | US | Virginia | Lexington | 51678 | 2446 | 34 | 0 | 37.78258621 | -79.44262866 | 2022-08-28 04:21:02 | Lexington, Virginia, US | |
1535295 | 1535295 | 2022-08-26 | US | Virginia | Lexington | 51678 | 2446 | 34 | 0 | 37.78258621 | -79.44262866 | 2022-08-27 04:20:57 | Lexington, Virginia, US | |
1164399 | 1164399 | 2022-08-18 | US | Texas | Swisher | 48437 | 2446 | 34 | 0 | 34.53028891 | -101.7349174 | 2022-08-19 04:20:54 | Swisher, Texas, US | |
3908938 | 3908938 | 2022-08-11 | US | Idaho | Clearwater | 16035 | 2446 | 34 | 0 | 46.67459924 | -115.6622393 | 2022-08-12 04:20:54 | Clearwater, Idaho, US | |
1347255 | 1347255 | 2022-08-10 | US | Idaho | Clearwater | 16035 | 2446 | 34 | 0 | 46.67459924 | -115.6622393 | 2022-08-11 04:20:49 | Clearwater, Idaho, US | |
883043 | 883043 | 2022-08-05 | US | Puerto Rico | Maunabo | 72095 | 2446 | 0 | 0 | 18.017889 | -65.922235 | 2022-08-06 04:20:56 | Maunabo, Puerto Rico, US | |
1068924 | 1068924 | 2022-07-28 | US | Texas | Castro | 48069 | 2446 | 47 | 0 | 34.53016752 | -102.2617243 | 2022-07-29 04:20:45 | Castro, Texas, US | |
2597374 | 2597374 | 2022-07-25 | US | Virginia | Franklin City | 51620 | 2446 | 53 | 0 | 36.6831435 | -76.93859681 | 2022-07-26 04:20:58 | Franklin City, Virginia, US | |
3112964 | 3112964 | 2022-07-13 | US | West Virginia | Clay | 54015 | 2446 | 47 | 0 | 38.46231092 | -81.07652217 | 2022-07-14 04:20:57 | Clay, West Virginia, US | |
1767694 | 1767694 | 2022-07-03 | US | Alabama | Bullock | 1011 | 2446 | 54 | 0 | 32.10030533 | -85.71265535 | 2022-07-04 04:20:54 | Bullock, Alabama, US | |
3365680 | 3365680 | 2022-07-02 | US | Alabama | Bullock | 1011 | 2446 | 54 | 0 | 32.10030533 | -85.71265535 | 2022-07-03 04:20:59 | Bullock, Alabama, US | |
594009 | 594009 | 2022-07-01 | US | Alabama | Bullock | 1011 | 2446 | 54 | 0 | 32.10030533 | -85.71265535 | 2022-07-02 04:21:16 | Bullock, Alabama, US | |
476364 | 476364 | 2022-06-26 | US | Idaho | Benewah | 16009 | 2446 | 41 | 0 | 47.21754179 | -116.6586851 | 2022-06-27 04:21:00 | Benewah, Idaho, US | |
939739 | 939739 | 2022-06-25 | US | Idaho | Benewah | 16009 | 2446 | 41 | 0 | 47.21754179 | -116.6586851 | 2022-06-26 04:21:02 | Benewah, Idaho, US | |
3347559 | 3347559 | 2022-06-24 | US | Idaho | Benewah | 16009 | 2446 | 41 | 0 | 47.21754179 | -116.6586851 | 2022-06-25 04:20:57 | Benewah, Idaho, US | |
561997 | 561997 | 2022-06-16 | US | Texas | Ochiltree | 48357 | 2446 | 48 | 0 | 36.27829105 | -100.8158184 | 2022-06-17 04:20:56 | Ochiltree, Texas, US | |
2982408 | 2982408 | 2022-06-13 | US | Texas | La Salle | 48283 | 2446 | 48 | 0 | 28.34453111 | -99.09908775 | 2022-06-14 04:20:52 | La Salle, Texas, US | |
2238534 | 2238534 | 2022-06-12 | US | Texas | La Salle | 48283 | 2446 | 48 | 0 | 28.34453111 | -99.09908775 | 2022-06-13 04:21:14 | La Salle, Texas, US | |
3144732 | 3144732 | 2022-06-11 | US | Texas | La Salle | 48283 | 2446 | 48 | 0 | 28.34453111 | -99.09908775 | 2022-06-12 04:20:53 | La Salle, Texas, US | |
3528123 | 3528123 | 2022-06-04 | US | Colorado | San Miguel | 8113 | 2446 | 8 | 0 | 38.00450883 | -108.4020725 | 2022-06-05 04:20:55 | San Miguel, Colorado, US | |
232129 | 232129 | 2022-05-31 | US | South Dakota | Roberts | 46109 | 2446 | 53 | 0 | 45.62975048 | -96.94672673 | 2022-06-01 04:20:55 | Roberts, South Dakota, US | |
3188894 | 3188894 | 2022-05-30 | US | South Dakota | Roberts | 46109 | 2446 | 53 | 0 | 45.62975048 | -96.94672673 | 2022-05-31 04:20:51 | Roberts, South Dakota, US | |
3188183 | 3188183 | 2022-05-30 | US | New Mexico | Colfax | 35007 | 2446 | 65 | 0 | 36.60569702 | -104.6472674 | 2022-05-31 04:20:51 | Colfax, New Mexico, US | |
3201043 | 3201043 | 2022-05-29 | US | South Dakota | Roberts | 46109 | 2446 | 53 | 0 | 45.62975048 | -96.94672673 | 2022-05-30 04:20:50 | Roberts, South Dakota, US | |
3200332 | 3200332 | 2022-05-29 | US | New Mexico | Colfax | 35007 | 2446 | 65 | 0 | 36.60569702 | -104.6472674 | 2022-05-30 04:20:50 | Colfax, New Mexico, US | |
2727921 | 2727921 | 2022-05-28 | US | South Dakota | Roberts | 46109 | 2446 | 53 | 0 | 45.62975048 | -96.94672673 | 2022-05-29 04:20:53 | Roberts, South Dakota, US | |
2727210 | 2727210 | 2022-05-28 | US | New Mexico | Colfax | 35007 | 2446 | 65 | 0 | 36.60569702 | -104.6472674 | 2022-05-29 04:20:53 | Colfax, New Mexico, US | |
1317102 | 1317102 | 2022-05-27 | US | South Dakota | Roberts | 46109 | 2446 | 53 | 0 | 45.62975048 | -96.94672673 | 2022-05-28 04:21:07 | Roberts, South Dakota, US | |
1316391 | 1316391 | 2022-05-27 | US | New Mexico | Colfax | 35007 | 2446 | 65 | 0 | 36.60569702 | -104.6472674 | 2022-05-28 04:21:07 | Colfax, New Mexico, US | |
1852894 | 1852894 | 2022-05-26 | US | South Dakota | Roberts | 46109 | 2446 | 53 | 0 | 45.62975048 | -96.94672673 | 2022-05-27 04:20:56 | Roberts, South Dakota, US | |
2050770 | 2050770 | 2022-05-25 | US | South Dakota | Roberts | 46109 | 2446 | 53 | 0 | 45.62975048 | -96.94672673 | 2022-05-26 04:20:50 | Roberts, South Dakota, US | |
624781 | 624781 | 2022-05-22 | US | South Dakota | Roberts | 46109 | 2446 | 53 | 0 | 45.62975048 | -96.94672673 | 2022-05-26 04:20:50 | Roberts, South Dakota, US | |
2254938 | 2254938 | 2022-04-19 | US | West Virginia | Ritchie | 54085 | 2446 | 31 | 0 | 39.18094587 | -81.06356878 | 2022-04-20 04:20:45 | Ritchie, West Virginia, US | |
1849488 | 1849488 | 2022-04-18 | US | West Virginia | Ritchie | 54085 | 2446 | 31 | 0 | 39.18094587 | -81.06356878 | 2022-04-19 04:21:00 | Ritchie, West Virginia, US | |
3420432 | 3420432 | 2022-04-17 | US | West Virginia | Ritchie | 54085 | 2446 | 31 | 0 | 39.18094587 | -81.06356878 | 2022-04-18 04:21:12 | Ritchie, West Virginia, US | |
307381 | 307381 | 2022-04-16 | US | West Virginia | Ritchie | 54085 | 2446 | 31 | 0 | 39.18094587 | -81.06356878 | 2022-04-17 04:20:59 | Ritchie, West Virginia, US | |
2673326 | 2673326 | 2022-04-15 | US | West Virginia | Ritchie | 54085 | 2446 | 31 | 0 | 39.18094587 | -81.06356878 | 2022-04-16 04:20:48 | Ritchie, West Virginia, US | |
2480506 | 2480506 | 2022-03-30 | US | Oklahoma | Blaine | 40011 | 2446 | 40 | 0 | 35.87518314 | -98.43307003 | 2022-03-31 04:20:56 | Blaine, Oklahoma, US | |
160547 | 160547 | 2022-03-29 | US | Oklahoma | Blaine | 40011 | 2446 | 40 | 0 | 35.87518314 | -98.43307003 | 2022-03-30 04:20:45 | Blaine, Oklahoma, US | |
1439118 | 1439118 | 2022-03-28 | US | Oklahoma | Blaine | 40011 | 2446 | 40 | 0 | 35.87518314 | -98.43307003 | 2022-03-29 04:20:46 | Blaine, Oklahoma, US | |
878799 | 878799 | 2022-03-27 | US | Oklahoma | Blaine | 40011 | 2446 | 40 | 0 | 35.87518314 | -98.43307003 | 2022-03-28 04:20:33 | Blaine, Oklahoma, US | |
2166082 | 2166082 | 2022-03-26 | US | Oklahoma | Blaine | 40011 | 2446 | 40 | 0 | 35.87518314 | -98.43307003 | 2022-03-27 04:20:47 | Blaine, Oklahoma, US | |
1723018 | 1723018 | 2022-03-25 | US | Oklahoma | Blaine | 40011 | 2446 | 40 | 0 | 35.87518314 | -98.43307003 | 2022-03-26 04:20:23 | Blaine, Oklahoma, US | |
1470635 | 1470635 | 2022-03-24 | US | Oklahoma | Blaine | 40011 | 2446 | 40 | 0 | 35.87518314 | -98.43307003 | 2022-03-25 04:20:46 | Blaine, Oklahoma, US | |
2321905 | 2321905 | 2022-03-16 | US | Oklahoma | Major | 40093 | 2446 | 40 | 0 | 36.31149996 | -98.53467076 | 2022-03-17 04:20:56 | Major, Oklahoma, US | |
264105 | 264105 | 2022-03-15 | US | Oklahoma | Major | 40093 | 2446 | 40 | 0 | 36.31149996 | -98.53467076 | 2022-03-16 04:20:50 | Major, Oklahoma, US | |
2266464 | 2266464 | 2022-03-14 | US | Oklahoma | Major | 40093 | 2446 | 40 | 0 | 36.31149996 | -98.53467076 | 2022-03-15 04:20:47 | Major, Oklahoma, US | |
3630530 | 3630530 | 2022-03-13 | US | Oklahoma | Major | 40093 | 2446 | 40 | 0 | 36.31149996 | -98.53467076 | 2022-03-14 04:20:46 | Major, Oklahoma, US | |
953438 | 953438 | 2022-03-12 | US | Oklahoma | Major | 40093 | 2446 | 40 | 0 | 36.31149996 | -98.53467076 | 2022-03-13 04:20:49 | Major, Oklahoma, US | |
358899 | 358899 | 2022-03-11 | US | Oklahoma | Major | 40093 | 2446 | 40 | 0 | 36.31149996 | -98.53467076 | 2022-03-12 04:20:50 | Major, Oklahoma, US | |
1868051 | 1868051 | 2022-03-10 | US | Oklahoma | Major | 40093 | 2446 | 40 | 0 | 36.31149996 | -98.53467076 | 2022-03-11 04:20:50 | Major, Oklahoma, US | |
2141584 | 2141584 | 2022-03-09 | US | Kentucky | Hancock | 21091 | 2446 | 21 | 0 | 37.83766422 | -86.78280584 | 2022-03-10 04:20:48 | Hancock, Kentucky, US | |
922923 | 922923 | 2022-03-08 | US | Texas | Trinity | 48455 | 2446 | 72 | 0 | 31.0879489 | -95.1367187 | 2022-03-09 04:20:59 | Trinity, Texas, US | |
921095 | 921095 | 2022-03-08 | US | Kentucky | Hancock | 21091 | 2446 | 21 | 0 | 37.83766422 | -86.78280584 | 2022-03-09 04:20:59 | Hancock, Kentucky, US | |
1549382 | 1549382 | 2022-03-07 | US | Kentucky | Hancock | 21091 | 2446 | 21 | 0 | 37.83766422 | -86.78280584 | 2022-03-08 04:20:54 | Hancock, Kentucky, 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]);