johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
373 rows where confirmed = 2098 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756133 | 2756133 | 2022-12-29 | US | Texas | Stephens | 48429 | 2098 | 51 | 0 | 32.73553157 | -98.83631615 | 2022-12-30 04:21:04 | Stephens, Texas, US | |
1077139 | 1077139 | 2022-12-28 | US | Texas | Stephens | 48429 | 2098 | 51 | 0 | 32.73553157 | -98.83631615 | 2022-12-29 04:21:01 | Stephens, Texas, US | |
3716472 | 3716472 | 2022-12-06 | US | North Carolina | Camden | 37029 | 2098 | 10 | 0 | 36.33804939 | -76.15568396 | 2022-12-07 04:20:58 | Camden, North Carolina, US | |
2417862 | 2417862 | 2022-12-05 | US | Tennessee | Pickett | 47137 | 2098 | 38 | 0 | 36.55606529 | -85.077633 | 2022-12-06 04:21:03 | Pickett, Tennessee, US | |
2417177 | 2417177 | 2022-12-05 | US | North Carolina | Camden | 37029 | 2098 | 10 | 0 | 36.33804939 | -76.15568396 | 2022-12-06 04:21:03 | Camden, North Carolina, US | |
720785 | 720785 | 2022-12-04 | US | North Carolina | Camden | 37029 | 2098 | 10 | 0 | 36.33804939 | -76.15568396 | 2022-12-05 04:20:58 | Camden, North Carolina, US | |
2819074 | 2819074 | 2022-12-03 | US | North Carolina | Camden | 37029 | 2098 | 10 | 0 | 36.33804939 | -76.15568396 | 2022-12-04 04:20:56 | Camden, North Carolina, US | |
835930 | 835930 | 2022-12-02 | US | North Carolina | Camden | 37029 | 2098 | 10 | 0 | 36.33804939 | -76.15568396 | 2022-12-03 04:21:02 | Camden, North Carolina, US | |
2138460 | 2138460 | 2022-12-01 | US | North Carolina | Camden | 37029 | 2098 | 10 | 0 | 36.33804939 | -76.15568396 | 2022-12-02 04:21:07 | Camden, North Carolina, US | |
1966876 | 1966876 | 2022-11-30 | US | North Carolina | Camden | 37029 | 2098 | 10 | 0 | 36.33804939 | -76.15568396 | 2022-12-01 04:21:03 | Camden, North Carolina, US | |
1621620 | 1621620 | 2022-11-22 | US | Kansas | Russell | 20167 | 2098 | 42 | 0 | 38.91462787 | -98.76254297 | 2022-11-23 04:21:06 | Russell, Kansas, US | |
3461508 | 3461508 | 2022-11-21 | US | Kansas | Russell | 20167 | 2098 | 42 | 0 | 38.91462787 | -98.76254297 | 2022-11-22 04:20:47 | Russell, Kansas, US | |
1641693 | 1641693 | 2022-11-20 | US | Kansas | Russell | 20167 | 2098 | 42 | 0 | 38.91462787 | -98.76254297 | 2022-11-21 04:21:05 | Russell, Kansas, US | |
2065250 | 2065250 | 2022-11-19 | US | Kansas | Russell | 20167 | 2098 | 42 | 0 | 38.91462787 | -98.76254297 | 2022-11-20 04:21:08 | Russell, Kansas, US | |
1756644 | 1756644 | 2022-11-18 | US | Kansas | Russell | 20167 | 2098 | 42 | 0 | 38.91462787 | -98.76254297 | 2022-11-19 04:21:14 | Russell, Kansas, US | |
3027637 | 3027637 | 2022-11-17 | US | Kansas | Russell | 20167 | 2098 | 42 | 0 | 38.91462787 | -98.76254297 | 2022-11-18 04:21:15 | Russell, Kansas, US | |
2487348 | 2487348 | 2022-11-16 | US | Kansas | Russell | 20167 | 2098 | 42 | 0 | 38.91462787 | -98.76254297 | 2022-11-17 04:21:11 | Russell, Kansas, US | |
2162742 | 2162742 | 2022-10-16 | US | Texas | Refugio | 48391 | 2098 | 39 | 0 | 28.3238976 | -97.15766311 | 2022-10-17 04:20:31 | Refugio, Texas, US | |
518939 | 518939 | 2022-10-15 | US | Texas | Refugio | 48391 | 2098 | 39 | 0 | 28.3238976 | -97.15766311 | 2022-10-16 04:22:39 | Refugio, Texas, US | |
2035996 | 2035996 | 2022-10-14 | US | Texas | Refugio | 48391 | 2098 | 39 | 0 | 28.3238976 | -97.15766311 | 2022-10-15 04:22:00 | Refugio, Texas, US | |
3756684 | 3756684 | 2022-10-13 | US | Texas | Refugio | 48391 | 2098 | 39 | 0 | 28.3238976 | -97.15766311 | 2022-10-14 04:22:28 | Refugio, Texas, US | |
3217509 | 3217509 | 2022-10-12 | US | Texas | Refugio | 48391 | 2098 | 39 | 0 | 28.3238976 | -97.15766311 | 2022-10-13 04:22:39 | Refugio, Texas, US | |
3995974 | 3995974 | 2022-09-27 | US | Kansas | Pratt | 20151 | 2098 | 35 | 0 | 37.64780729 | -98.73922153 | 2022-09-28 04:23:01 | Pratt, Kansas, US | |
2770302 | 2770302 | 2022-09-26 | US | Kansas | Pratt | 20151 | 2098 | 35 | 0 | 37.64780729 | -98.73922153 | 2022-09-27 04:23:01 | Pratt, Kansas, US | |
1977955 | 1977955 | 2022-09-25 | US | Kansas | Pratt | 20151 | 2098 | 35 | 0 | 37.64780729 | -98.73922153 | 2022-09-26 04:20:52 | Pratt, Kansas, US | |
2651122 | 2651122 | 2022-09-24 | US | Kansas | Pratt | 20151 | 2098 | 35 | 0 | 37.64780729 | -98.73922153 | 2022-09-25 04:23:31 | Pratt, Kansas, US | |
385562 | 385562 | 2022-09-23 | US | Kansas | Pratt | 20151 | 2098 | 35 | 0 | 37.64780729 | -98.73922153 | 2022-09-24 04:21:40 | Pratt, Kansas, US | |
1625628 | 1625628 | 2022-09-22 | US | Kansas | Pratt | 20151 | 2098 | 35 | 0 | 37.64780729 | -98.73922153 | 2022-09-23 04:23:13 | Pratt, Kansas, US | |
1371832 | 1371832 | 2022-09-21 | US | Kansas | Pratt | 20151 | 2098 | 35 | 0 | 37.64780729 | -98.73922153 | 2022-09-22 04:22:56 | Pratt, Kansas, US | |
2017513 | 2017513 | 2022-09-20 | US | Georgia | Crawford | 13079 | 2098 | 61 | 0 | 32.71391813 | -83.98061238 | 2022-09-21 04:23:22 | Crawford, Georgia, US | |
3571386 | 3571386 | 2022-09-19 | US | Georgia | Crawford | 13079 | 2098 | 61 | 0 | 32.71391813 | -83.98061238 | 2022-09-20 04:22:48 | Crawford, Georgia, US | |
420125 | 420125 | 2022-09-18 | US | Georgia | Crawford | 13079 | 2098 | 61 | 0 | 32.71391813 | -83.98061238 | 2022-09-19 04:21:49 | Crawford, Georgia, US | |
3374149 | 3374149 | 2022-09-17 | US | Georgia | Crawford | 13079 | 2098 | 61 | 0 | 32.71391813 | -83.98061238 | 2022-09-18 04:22:50 | Crawford, Georgia, US | |
2356257 | 2356257 | 2022-09-16 | US | Georgia | Crawford | 13079 | 2098 | 61 | 0 | 32.71391813 | -83.98061238 | 2022-09-17 04:20:19 | Crawford, Georgia, US | |
3987414 | 3987414 | 2022-09-15 | US | Georgia | Crawford | 13079 | 2098 | 61 | 0 | 32.71391813 | -83.98061238 | 2022-09-16 04:21:19 | Crawford, Georgia, US | |
1889931 | 1889931 | 2022-09-14 | US | Georgia | Crawford | 13079 | 2098 | 61 | 0 | 32.71391813 | -83.98061238 | 2022-09-15 04:21:02 | Crawford, Georgia, US | |
2396855 | 2396855 | 2022-09-12 | US | Nebraska | Butler | 31023 | 2098 | 18 | 0 | 41.22703692 | -97.13106306 | 2022-09-13 04:20:57 | Butler, Nebraska, US | |
3767933 | 3767933 | 2022-09-11 | US | Nebraska | Butler | 31023 | 2098 | 18 | 0 | 41.22703692 | -97.13106306 | 2022-09-12 04:20:58 | Butler, Nebraska, US | |
3826508 | 3826508 | 2022-09-10 | US | Nebraska | Butler | 31023 | 2098 | 18 | 0 | 41.22703692 | -97.13106306 | 2022-09-11 04:20:50 | Butler, Nebraska, US | |
964965 | 964965 | 2022-09-09 | US | Nebraska | Butler | 31023 | 2098 | 18 | 0 | 41.22703692 | -97.13106306 | 2022-09-10 04:21:10 | Butler, Nebraska, US | |
255367 | 255367 | 2022-09-08 | US | Nebraska | Butler | 31023 | 2098 | 18 | 0 | 41.22703692 | -97.13106306 | 2022-09-09 04:21:11 | Butler, Nebraska, US | |
3747165 | 3747165 | 2022-09-07 | US | Nebraska | Butler | 31023 | 2098 | 18 | 0 | 41.22703692 | -97.13106306 | 2022-09-08 04:21:02 | Butler, Nebraska, US | |
116805 | 116805 | 2022-09-06 | US | Nebraska | Butler | 31023 | 2098 | 18 | 0 | 41.22703692 | -97.13106306 | 2022-09-07 04:20:59 | Butler, Nebraska, US | |
3954059 | 3954059 | 2022-08-17 | US | Wisconsin | Menominee | 55078 | 2098 | 15 | 0 | 45.00422544 | -88.70950714 | 2022-08-18 04:21:11 | Menominee, Wisconsin, US | |
3953060 | 3953060 | 2022-08-17 | US | Oklahoma | Kiowa | 40075 | 2098 | 55 | 0 | 34.91671958 | -98.97720696 | 2022-08-18 04:21:11 | Kiowa, Oklahoma, US | |
993562 | 993562 | 2022-08-16 | US | Oklahoma | Kiowa | 40075 | 2098 | 55 | 0 | 34.91671958 | -98.97720696 | 2022-08-17 04:20:59 | Kiowa, Oklahoma, US | |
2496601 | 2496601 | 2022-08-15 | US | Oklahoma | Kiowa | 40075 | 2098 | 55 | 0 | 34.91671958 | -98.97720696 | 2022-08-16 04:20:58 | Kiowa, Oklahoma, US | |
3650151 | 3650151 | 2022-08-14 | US | Oklahoma | Kiowa | 40075 | 2098 | 55 | 0 | 34.91671958 | -98.97720696 | 2022-08-15 04:20:59 | Kiowa, Oklahoma, US | |
1971157 | 1971157 | 2022-08-13 | US | Oklahoma | Kiowa | 40075 | 2098 | 55 | 0 | 34.91671958 | -98.97720696 | 2022-08-14 04:20:55 | Kiowa, Oklahoma, US | |
2890966 | 2890966 | 2022-08-12 | US | Oklahoma | Kiowa | 40075 | 2098 | 55 | 0 | 34.91671958 | -98.97720696 | 2022-08-13 04:20:52 | Kiowa, Oklahoma, US | |
3910571 | 3910571 | 2022-08-11 | US | Oklahoma | Kiowa | 40075 | 2098 | 55 | 0 | 34.91671958 | -98.97720696 | 2022-08-12 04:20:54 | Kiowa, Oklahoma, US | |
1071697 | 1071697 | 2022-08-07 | US | Mississippi | Franklin | 28037 | 2098 | 38 | 0 | 31.47786634 | -90.89672989 | 2022-08-08 04:21:08 | Franklin, Mississippi, US | |
1942285 | 1942285 | 2022-08-06 | US | Mississippi | Franklin | 28037 | 2098 | 38 | 0 | 31.47786634 | -90.89672989 | 2022-08-07 04:20:54 | Franklin, Mississippi, US | |
882084 | 882084 | 2022-08-05 | US | Mississippi | Franklin | 28037 | 2098 | 38 | 0 | 31.47786634 | -90.89672989 | 2022-08-06 04:20:56 | Franklin, Mississippi, US | |
2010495 | 2010495 | 2022-08-04 | US | Mississippi | Franklin | 28037 | 2098 | 38 | 0 | 31.47786634 | -90.89672989 | 2022-08-05 04:20:52 | Franklin, Mississippi, US | |
1101228 | 1101228 | 2022-08-03 | US | Texas | Hansford | 48195 | 2098 | 29 | 0 | 36.27743284 | -101.3545796 | 2022-08-04 04:20:58 | Hansford, Texas, US | |
1408153 | 1408153 | 2022-08-02 | US | Texas | Hansford | 48195 | 2098 | 29 | 0 | 36.27743284 | -101.3545796 | 2022-08-03 04:20:59 | Hansford, Texas, US | |
2336061 | 2336061 | 2022-07-27 | US | Colorado | Yuma | 8125 | 2098 | 26 | 0 | 40.00346839 | -102.4258673 | 2022-07-28 04:20:56 | Yuma, Colorado, US | |
2791983 | 2791983 | 2022-07-10 | US | Tennessee | Hancock | 47067 | 2098 | 37 | 0 | 36.52692871 | -83.22375847 | 2022-07-11 04:20:46 | Hancock, Tennessee, US | |
2743432 | 2743432 | 2022-07-07 | US | North Dakota | Pembina | 38067 | 2098 | 16 | 0 | 48.76623521 | -97.5523809 | 2022-07-08 04:20:56 | Pembina, North Dakota, US | |
593456 | 593456 | 2022-07-01 | China | Inner Mongolia | 2098 | 1 | 0 | 44.0935 | 113.9448 | 2022-07-02 04:21:16 | Inner Mongolia, China | |||
2491064 | 2491064 | 2022-06-29 | US | Illinois | Schuyler | 17169 | 2098 | 17 | 0 | 40.1571798 | -90.61114163 | 2022-06-30 04:21:01 | Schuyler, Illinois, US | |
2190928 | 2190928 | 2022-06-22 | US | Virginia | Buena Vista | 51530 | 2098 | 44 | 0 | 37.73484642 | -79.35296097 | 2022-06-23 04:20:55 | Buena Vista, Virginia, US | |
2238892 | 2238892 | 2022-06-12 | US | West Virginia | Pocahontas | 54075 | 2098 | 32 | 0 | 38.32758728 | -80.00993811 | 2022-06-13 04:21:14 | Pocahontas, West Virginia, US | |
3145090 | 3145090 | 2022-06-11 | US | West Virginia | Pocahontas | 54075 | 2098 | 32 | 0 | 38.32758728 | -80.00993811 | 2022-06-12 04:20:53 | Pocahontas, West Virginia, US | |
1948006 | 1948006 | 2022-06-10 | US | West Virginia | Pocahontas | 54075 | 2098 | 32 | 0 | 38.32758728 | -80.00993811 | 2022-06-11 04:21:01 | Pocahontas, West Virginia, US | |
3890423 | 3890423 | 2022-06-06 | US | South Carolina | Allendale | 45005 | 2098 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-06-07 04:21:08 | Allendale, South Carolina, US | |
3510192 | 3510192 | 2022-06-05 | US | South Carolina | Allendale | 45005 | 2098 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-06-06 04:20:57 | Allendale, South Carolina, US | |
3530269 | 3530269 | 2022-06-04 | US | South Carolina | Allendale | 45005 | 2098 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-06-05 04:20:55 | Allendale, South Carolina, US | |
3136355 | 3136355 | 2022-06-03 | US | South Carolina | Allendale | 45005 | 2098 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-06-04 04:20:58 | Allendale, South Carolina, US | |
3581430 | 3581430 | 2022-06-02 | US | South Carolina | Allendale | 45005 | 2098 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-06-03 04:20:58 | Allendale, South Carolina, US | |
973723 | 973723 | 2022-06-01 | US | South Carolina | Allendale | 45005 | 2098 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-06-02 05:20:39 | Allendale, South Carolina, US | |
3186390 | 3186390 | 2022-05-30 | US | Alabama | Perry | 1105 | 2098 | 47 | 0 | 32.64048341 | -87.29770589 | 2022-05-31 04:20:51 | Perry, Alabama, US | |
3198539 | 3198539 | 2022-05-29 | US | Alabama | Perry | 1105 | 2098 | 47 | 0 | 32.64048341 | -87.29770589 | 2022-05-30 04:20:50 | Perry, Alabama, US | |
2725417 | 2725417 | 2022-05-28 | US | Alabama | Perry | 1105 | 2098 | 47 | 0 | 32.64048341 | -87.29770589 | 2022-05-29 04:20:53 | Perry, Alabama, US | |
1314598 | 1314598 | 2022-05-27 | US | Alabama | Perry | 1105 | 2098 | 47 | 0 | 32.64048341 | -87.29770589 | 2022-05-28 04:21:07 | Perry, Alabama, US | |
1850390 | 1850390 | 2022-05-26 | US | Alabama | Perry | 1105 | 2098 | 47 | 0 | 32.64048341 | -87.29770589 | 2022-05-27 04:20:56 | Perry, Alabama, US | |
2048266 | 2048266 | 2022-05-25 | US | Alabama | Perry | 1105 | 2098 | 47 | 0 | 32.64048341 | -87.29770589 | 2022-05-26 04:20:50 | Perry, Alabama, US | |
2999704 | 2999704 | 2022-05-24 | US | Alabama | Perry | 1105 | 2098 | 47 | 0 | 32.64048341 | -87.29770589 | 2022-05-25 04:20:56 | Perry, Alabama, US | |
3593425 | 3593425 | 2022-05-23 | US | Alabama | Perry | 1105 | 2098 | 47 | 0 | 32.64048341 | -87.29770589 | 2022-05-24 04:20:57 | Perry, Alabama, US | |
622277 | 622277 | 2022-05-22 | US | Alabama | Perry | 1105 | 2098 | 47 | 0 | 32.64048341 | -87.29770589 | 2022-05-26 04:20:50 | Perry, Alabama, US | |
1109973 | 1109973 | 2022-05-21 | US | Alabama | Perry | 1105 | 2098 | 47 | 0 | 32.64048341 | -87.29770589 | 2022-05-22 04:20:52 | Perry, Alabama, US | |
1172249 | 1172249 | 2022-05-20 | US | Texas | Clay | 48077 | 2098 | 35 | 0 | 33.78686685 | -98.20771198 | 2022-05-21 04:20:58 | Clay, Texas, US | |
1169597 | 1169597 | 2022-05-20 | US | Alabama | Perry | 1105 | 2098 | 47 | 0 | 32.64048341 | -87.29770589 | 2022-05-21 04:20:58 | Perry, Alabama, US | |
3899012 | 3899012 | 2022-05-19 | US | Texas | Clay | 48077 | 2098 | 35 | 0 | 33.78686685 | -98.20771198 | 2022-05-20 04:20:57 | Clay, Texas, US | |
3896360 | 3896360 | 2022-05-19 | US | Alabama | Perry | 1105 | 2098 | 47 | 0 | 32.64048341 | -87.29770589 | 2022-05-20 04:20:57 | Perry, Alabama, US | |
1187796 | 1187796 | 2022-05-18 | US | Texas | Clay | 48077 | 2098 | 35 | 0 | 33.78686685 | -98.20771198 | 2022-05-19 04:20:54 | Clay, Texas, US | |
3538941 | 3538941 | 2022-05-10 | US | West Virginia | Gilmer | 54021 | 2098 | 19 | 0 | 38.9251277 | -80.85952723 | 2022-05-11 04:20:48 | Gilmer, West Virginia, US | |
225476 | 225476 | 2022-05-09 | US | West Virginia | Gilmer | 54021 | 2098 | 19 | 0 | 38.9251277 | -80.85952723 | 2022-05-10 04:20:50 | Gilmer, West Virginia, US | |
2332307 | 2332307 | 2022-05-08 | US | Idaho | Boundary | 16021 | 2098 | 62 | 0 | 48.76684761 | -116.4630179 | 2022-05-09 04:20:54 | Boundary, Idaho, US | |
361269 | 361269 | 2022-05-07 | US | Idaho | Boundary | 16021 | 2098 | 62 | 0 | 48.76684761 | -116.4630179 | 2022-05-08 04:20:49 | Boundary, Idaho, US | |
1398620 | 1398620 | 2022-05-06 | US | Idaho | Boundary | 16021 | 2098 | 62 | 0 | 48.76684761 | -116.4630179 | 2022-05-07 04:21:09 | Boundary, Idaho, US | |
3855298 | 3855298 | 2022-04-27 | US | West Virginia | Gilmer | 54021 | 2098 | 19 | 0 | 38.9251277 | -80.85952723 | 2022-04-28 04:20:47 | Gilmer, West Virginia, US | |
3853784 | 3853784 | 2022-04-27 | US | Missouri | St. Clair | 29185 | 2098 | 35 | 0 | 38.03699437 | -93.77631447 | 2022-04-28 04:20:47 | St. Clair, Missouri, US | |
3853557 | 3853557 | 2022-04-27 | US | Minnesota | Marshall | 27089 | 2098 | 23 | 0 | 48.35825983 | -96.37017407 | 2022-04-28 04:20:47 | Marshall, Minnesota, US | |
1329728 | 1329728 | 2022-04-26 | US | West Virginia | Gilmer | 54021 | 2098 | 19 | 0 | 38.9251277 | -80.85952723 | 2022-04-27 04:20:52 | Gilmer, West Virginia, US | |
1328214 | 1328214 | 2022-04-26 | US | Missouri | St. Clair | 29185 | 2098 | 35 | 0 | 38.03699437 | -93.77631447 | 2022-04-27 04:20:52 | St. Clair, Missouri, US | |
3724971 | 3724971 | 2022-04-25 | US | Puerto Rico | Patillas | 72109 | 2098 | 0 | 0 | 18.03174 | -66.012242 | 2022-04-26 04:20:51 | Patillas, Puerto Rico, US | |
3724168 | 3724168 | 2022-04-25 | US | Missouri | St. Clair | 29185 | 2098 | 35 | 0 | 38.03699437 | -93.77631447 | 2022-04-26 04:20:51 | St. Clair, Missouri, US | |
2030736 | 2030736 | 2022-04-24 | US | Missouri | St. Clair | 29185 | 2098 | 35 | 0 | 38.03699437 | -93.77631447 | 2022-04-25 04:20:56 | St. Clair, Missouri, 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]);