johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
284 rows where confirmed = 2517 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1631790 | 1631790 | 2022-12-18 | US | West Virginia | Gilmer | 54021 | 2517 | 23 | 0 | 38.9251277 | -80.85952723 | 2022-12-19 04:21:03 | Gilmer, West Virginia, US | |
507169 | 507169 | 2022-12-17 | US | West Virginia | Gilmer | 54021 | 2517 | 23 | 0 | 38.9251277 | -80.85952723 | 2022-12-18 04:21:03 | Gilmer, West Virginia, US | |
3327741 | 3327741 | 2022-12-16 | US | West Virginia | Gilmer | 54021 | 2517 | 23 | 0 | 38.9251277 | -80.85952723 | 2022-12-17 04:21:04 | Gilmer, West Virginia, US | |
546253 | 546253 | 2022-12-15 | US | West Virginia | Gilmer | 54021 | 2517 | 23 | 0 | 38.9251277 | -80.85952723 | 2022-12-16 04:21:01 | Gilmer, West Virginia, US | |
351781 | 351781 | 2022-12-14 | US | West Virginia | Gilmer | 54021 | 2517 | 23 | 0 | 38.9251277 | -80.85952723 | 2022-12-15 04:20:58 | Gilmer, West Virginia, US | |
311369 | 311369 | 2022-12-13 | US | West Virginia | Gilmer | 54021 | 2517 | 23 | 0 | 38.9251277 | -80.85952723 | 2022-12-14 04:21:04 | Gilmer, West Virginia, US | |
1152430 | 1152430 | 2022-12-12 | US | West Virginia | Gilmer | 54021 | 2517 | 23 | 0 | 38.9251277 | -80.85952723 | 2022-12-13 04:21:01 | Gilmer, West Virginia, US | |
1150936 | 1150936 | 2022-12-12 | US | Montana | Blaine | 30005 | 2517 | 33 | 0 | 48.43175214 | -108.9582723 | 2022-12-11 23:21:04 | Blaine, Montana, US | |
870790 | 870790 | 2022-12-11 | US | Montana | Blaine | 30005 | 2517 | 33 | 0 | 48.43175214 | -108.9582723 | 2022-12-11 23:21:04 | Blaine, Montana, US | |
259320 | 259320 | 2022-12-10 | US | Montana | Blaine | 30005 | 2517 | 33 | 0 | 48.43175214 | -108.9582723 | 2022-12-11 04:20:50 | Blaine, Montana, US | |
3938034 | 3938034 | 2022-12-09 | US | Montana | Blaine | 30005 | 2517 | 33 | 0 | 48.43175214 | -108.9582723 | 2022-12-10 04:21:02 | Blaine, Montana, US | |
3379366 | 3379366 | 2022-12-08 | US | Montana | Blaine | 30005 | 2517 | 33 | 0 | 48.43175214 | -108.9582723 | 2022-12-09 04:21:05 | Blaine, Montana, US | |
1986637 | 1986637 | 2022-12-07 | US | Montana | Blaine | 30005 | 2517 | 33 | 0 | 48.43175214 | -108.9582723 | 2022-12-08 04:21:07 | Blaine, Montana, US | |
3717121 | 3717121 | 2022-12-06 | US | Tennessee | Hancock | 47067 | 2517 | 42 | 0 | 36.52692871 | -83.22375847 | 2022-12-07 04:20:58 | Hancock, Tennessee, US | |
3716160 | 3716160 | 2022-12-06 | US | Montana | Blaine | 30005 | 2517 | 33 | 0 | 48.43175214 | -108.9582723 | 2022-12-07 04:20:58 | Blaine, Montana, US | |
2416865 | 2416865 | 2022-12-05 | US | Montana | Blaine | 30005 | 2517 | 33 | 0 | 48.43175214 | -108.9582723 | 2022-12-06 04:21:03 | Blaine, Montana, US | |
720473 | 720473 | 2022-12-04 | US | Montana | Blaine | 30005 | 2517 | 33 | 0 | 48.43175214 | -108.9582723 | 2022-12-05 04:20:58 | Blaine, Montana, US | |
2818762 | 2818762 | 2022-12-03 | US | Montana | Blaine | 30005 | 2517 | 33 | 0 | 48.43175214 | -108.9582723 | 2022-12-04 04:20:56 | Blaine, Montana, US | |
835618 | 835618 | 2022-12-02 | US | Montana | Blaine | 30005 | 2517 | 33 | 0 | 48.43175214 | -108.9582723 | 2022-12-03 04:21:02 | Blaine, Montana, US | |
2759939 | 2759939 | 2022-10-18 | US | Texas | Archer | 48009 | 2517 | 29 | 0 | 33.61569967 | -98.68754589 | 2022-10-19 04:22:26 | Archer, Texas, US | |
2027773 | 2027773 | 2022-10-17 | US | Texas | Archer | 48009 | 2517 | 29 | 0 | 33.61569967 | -98.68754589 | 2022-10-18 04:22:42 | Archer, Texas, US | |
3214097 | 3214097 | 2022-10-12 | China | Jiangsu | 2517 | 0 | 0 | 32.9711 | 119.455 | 2022-10-13 04:22:39 | Jiangsu, China | |||
3253535 | 3253535 | 2022-10-11 | US | Virginia | Northumberland | 51133 | 2517 | 44 | 0 | 37.89202088 | -76.41949732 | 2022-10-12 04:22:51 | Northumberland, Virginia, US | |
2970794 | 2970794 | 2022-10-10 | US | Virginia | Northumberland | 51133 | 2517 | 44 | 0 | 37.89202088 | -76.41949732 | 2022-10-11 04:23:05 | Northumberland, Virginia, US | |
2018911 | 2018911 | 2022-09-20 | US | New Jersey | Unassigned | 90034 | 2517 | 0 | 0 | 41.13891592 | 0.0 | 2022-09-21 04:23:22 | Unassigned, New Jersey, US | |
422569 | 422569 | 2022-09-18 | US | Texas | Swisher | 48437 | 2517 | 34 | 0 | 34.53028891 | -101.7349174 | 2022-09-19 04:21:49 | Swisher, Texas, US | |
3376593 | 3376593 | 2022-09-17 | US | Texas | Swisher | 48437 | 2517 | 34 | 0 | 34.53028891 | -101.7349174 | 2022-09-18 04:22:50 | Swisher, Texas, US | |
2358701 | 2358701 | 2022-09-16 | US | Texas | Swisher | 48437 | 2517 | 34 | 0 | 34.53028891 | -101.7349174 | 2022-09-17 04:20:19 | Swisher, Texas, US | |
3550848 | 3550848 | 2022-09-01 | US | Virginia | Franklin City | 51620 | 2517 | 53 | 0 | 36.6831435 | -76.93859681 | 2022-09-02 04:21:07 | Franklin City, Virginia, US | |
3775199 | 3775199 | 2022-08-30 | US | Kansas | Grant | 20067 | 2517 | 37 | 0 | 37.56227336 | -101.3079758 | 2022-08-31 04:20:57 | Grant, Kansas, US | |
1681795 | 1681795 | 2022-08-29 | US | Kansas | Grant | 20067 | 2517 | 37 | 0 | 37.56227336 | -101.3079758 | 2022-08-30 04:21:03 | Grant, Kansas, US | |
1878279 | 1878279 | 2022-08-28 | US | Kansas | Grant | 20067 | 2517 | 37 | 0 | 37.56227336 | -101.3079758 | 2022-08-29 04:21:06 | Grant, Kansas, US | |
2097406 | 2097406 | 2022-08-27 | US | Kansas | Grant | 20067 | 2517 | 37 | 0 | 37.56227336 | -101.3079758 | 2022-08-28 04:21:02 | Grant, Kansas, US | |
1533221 | 1533221 | 2022-08-26 | US | Kansas | Grant | 20067 | 2517 | 37 | 0 | 37.56227336 | -101.3079758 | 2022-08-27 04:20:57 | Grant, Kansas, US | |
2830108 | 2830108 | 2022-08-25 | US | Kansas | Grant | 20067 | 2517 | 37 | 0 | 37.56227336 | -101.3079758 | 2022-08-26 04:21:02 | Grant, Kansas, US | |
2324641 | 2324641 | 2022-08-24 | US | Kansas | Grant | 20067 | 2517 | 37 | 0 | 37.56227336 | -101.3079758 | 2022-08-25 04:21:13 | Grant, Kansas, US | |
1072877 | 1072877 | 2022-08-07 | US | Tennessee | Perry | 47135 | 2517 | 56 | 0 | 35.63708728 | -87.86139634 | 2022-08-08 04:21:08 | Perry, Tennessee, US | |
1069400 | 1069400 | 2022-07-28 | US | West Virginia | Webster | 54101 | 2517 | 34 | 0 | 38.49370949 | -80.4202023 | 2022-07-29 04:20:45 | Webster, West Virginia, US | |
3408200 | 3408200 | 2022-07-17 | US | Puerto Rico | Guanica | 72055 | 2517 | 0 | 0 | 17.982429 | -66.919643 | 2022-07-18 04:20:59 | Guanica, Puerto Rico, US | |
3967517 | 3967517 | 2022-07-05 | US | Illinois | Brown | 17009 | 2517 | 15 | 0 | 39.96209138 | -90.75068024 | 2022-07-06 04:20:58 | Brown, Illinois, US | |
3079028 | 3079028 | 2022-07-04 | US | Illinois | Brown | 17009 | 2517 | 15 | 0 | 39.96209138 | -90.75068024 | 2022-07-05 04:20:45 | Brown, Illinois, US | |
1768310 | 1768310 | 2022-07-03 | US | Illinois | Brown | 17009 | 2517 | 15 | 0 | 39.96209138 | -90.75068024 | 2022-07-04 04:20:54 | Brown, Illinois, US | |
3366296 | 3366296 | 2022-07-02 | US | Illinois | Brown | 17009 | 2517 | 15 | 0 | 39.96209138 | -90.75068024 | 2022-07-03 04:20:59 | Brown, Illinois, US | |
594625 | 594625 | 2022-07-01 | US | Illinois | Brown | 17009 | 2517 | 15 | 0 | 39.96209138 | -90.75068024 | 2022-07-02 04:21:16 | Brown, Illinois, US | |
478835 | 478835 | 2022-06-26 | US | Virginia | Poquoson | 51735 | 2517 | 30 | 0 | 37.14259351 | -76.35798148 | 2022-06-27 04:21:00 | Poquoson, Virginia, US | |
942210 | 942210 | 2022-06-25 | US | Virginia | Poquoson | 51735 | 2517 | 30 | 0 | 37.14259351 | -76.35798148 | 2022-06-26 04:21:02 | Poquoson, Virginia, US | |
3350030 | 3350030 | 2022-06-24 | US | Virginia | Poquoson | 51735 | 2517 | 30 | 0 | 37.14259351 | -76.35798148 | 2022-06-25 04:20:57 | Poquoson, Virginia, US | |
3536653 | 3536653 | 2022-05-10 | US | Iowa | Franklin | 19069 | 2517 | 42 | 0 | 42.73270384 | -93.26256925 | 2022-05-11 04:20:48 | Franklin, Iowa, US | |
223188 | 223188 | 2022-05-09 | US | Iowa | Franklin | 19069 | 2517 | 42 | 0 | 42.73270384 | -93.26256925 | 2022-05-10 04:20:50 | Franklin, Iowa, US | |
2334699 | 2334699 | 2022-05-08 | US | Virginia | Charlotte | 51037 | 2517 | 45 | 0 | 37.01909701 | -78.66314092 | 2022-05-09 04:20:54 | Charlotte, Virginia, US | |
2332573 | 2332573 | 2022-05-08 | US | Iowa | Franklin | 19069 | 2517 | 42 | 0 | 42.73270384 | -93.26256925 | 2022-05-09 04:20:54 | Franklin, Iowa, US | |
363661 | 363661 | 2022-05-07 | US | Virginia | Charlotte | 51037 | 2517 | 45 | 0 | 37.01909701 | -78.66314092 | 2022-05-08 04:20:49 | Charlotte, Virginia, US | |
361535 | 361535 | 2022-05-07 | US | Iowa | Franklin | 19069 | 2517 | 42 | 0 | 42.73270384 | -93.26256925 | 2022-05-08 04:20:49 | Franklin, Iowa, US | |
1401012 | 1401012 | 2022-05-06 | US | Virginia | Charlotte | 51037 | 2517 | 45 | 0 | 37.01909701 | -78.66314092 | 2022-05-07 04:21:09 | Charlotte, Virginia, US | |
1398886 | 1398886 | 2022-05-06 | US | Iowa | Franklin | 19069 | 2517 | 42 | 0 | 42.73270384 | -93.26256925 | 2022-05-07 04:21:09 | Franklin, Iowa, US | |
2599241 | 2599241 | 2022-05-05 | US | Iowa | Franklin | 19069 | 2517 | 42 | 0 | 42.73270384 | -93.26256925 | 2022-05-06 04:21:00 | Franklin, Iowa, US | |
3266690 | 3266690 | 2022-05-04 | US | Iowa | Franklin | 19069 | 2517 | 42 | 0 | 42.73270384 | -93.26256925 | 2022-05-05 04:20:55 | Franklin, Iowa, US | |
1575455 | 1575455 | 2022-05-03 | US | Virginia | Charlotte | 51037 | 2517 | 46 | 0 | 37.01909701 | -78.66314092 | 2022-05-04 04:20:59 | Charlotte, Virginia, US | |
3724983 | 3724983 | 2022-04-25 | US | Puerto Rico | Santa Isabel | 72133 | 2517 | 0 | 0 | 17.994525 | -66.388913 | 2022-04-26 04:20:51 | Santa Isabel, Puerto Rico, US | |
1577637 | 1577637 | 2022-04-10 | US | Kentucky | Wolfe | 21237 | 2517 | 22 | 0 | 37.73941626 | -83.49303612 | 2022-04-11 04:21:02 | Wolfe, Kentucky, US | |
1653879 | 1653879 | 2022-04-09 | US | Kentucky | Wolfe | 21237 | 2517 | 22 | 0 | 37.73941626 | -83.49303612 | 2022-04-10 04:20:52 | Wolfe, Kentucky, US | |
2117201 | 2117201 | 2022-04-08 | US | Kentucky | Wolfe | 21237 | 2517 | 22 | 0 | 37.73941626 | -83.49303612 | 2022-04-09 04:20:42 | Wolfe, Kentucky, US | |
3321725 | 3321725 | 2022-04-07 | US | Kentucky | Wolfe | 21237 | 2517 | 22 | 0 | 37.73941626 | -83.49303612 | 2022-04-08 04:20:48 | Wolfe, Kentucky, US | |
2802261 | 2802261 | 2022-04-06 | US | Kentucky | Wolfe | 21237 | 2517 | 22 | 0 | 37.73941626 | -83.49303612 | 2022-04-07 04:20:53 | Wolfe, Kentucky, US | |
3869030 | 3869030 | 2022-04-05 | US | Kentucky | Wolfe | 21237 | 2517 | 22 | 0 | 37.73941626 | -83.49303612 | 2022-04-06 04:20:49 | Wolfe, Kentucky, US | |
2750372 | 2750372 | 2022-04-04 | US | Kentucky | Wolfe | 21237 | 2517 | 22 | 0 | 37.73941626 | -83.49303612 | 2022-04-05 04:20:48 | Wolfe, Kentucky, US | |
2322359 | 2322359 | 2022-03-16 | US | Texas | Blanco | 48031 | 2517 | 34 | 0 | 30.26640707 | -98.3999852 | 2022-03-17 04:20:56 | Blanco, Texas, US | |
264559 | 264559 | 2022-03-15 | US | Texas | Blanco | 48031 | 2517 | 34 | 0 | 30.26640707 | -98.3999852 | 2022-03-16 04:20:50 | Blanco, Texas, US | |
3629953 | 3629953 | 2022-03-13 | US | Montana | Deer Lodge | 30023 | 2517 | 28 | 0 | 46.05953325 | -113.073353 | 2022-03-14 04:20:46 | Deer Lodge, Montana, US | |
952861 | 952861 | 2022-03-12 | US | Montana | Deer Lodge | 30023 | 2517 | 28 | 0 | 46.05953325 | -113.073353 | 2022-03-13 04:20:49 | Deer Lodge, Montana, US | |
358322 | 358322 | 2022-03-11 | US | Montana | Deer Lodge | 30023 | 2517 | 28 | 0 | 46.05953325 | -113.073353 | 2022-03-12 04:20:50 | Deer Lodge, Montana, US | |
943911 | 943911 | 2022-02-28 | US | Indiana | Crawford | 18025 | 2517 | 34 | 0 | 38.28814402 | -86.44518825 | 2022-03-01 04:21:09 | Crawford, Indiana, US | |
2734420 | 2734420 | 2022-02-27 | US | Kentucky | Edmonson | 21061 | 2517 | 38 | 0 | 37.21218923 | -86.23955613 | 2022-02-28 04:21:05 | Edmonson, Kentucky, US | |
3047573 | 3047573 | 2022-02-26 | US | Kentucky | Edmonson | 21061 | 2517 | 38 | 0 | 37.21218923 | -86.23955613 | 2022-02-27 04:21:04 | Edmonson, Kentucky, US | |
576228 | 576228 | 2022-02-25 | US | Kentucky | Edmonson | 21061 | 2517 | 38 | 0 | 37.21218923 | -86.23955613 | 2022-02-26 04:21:12 | Edmonson, Kentucky, US | |
2476690 | 2476690 | 2022-02-03 | US | Puerto Rico | Comerio | 72045 | 2517 | 0 | 0 | 18.224687 | -66.221622 | 2022-02-04 04:21:10 | Comerio, Puerto Rico, US | |
2475026 | 2475026 | 2022-02-03 | US | Indiana | Brown | 18013 | 2517 | 58 | 0 | 39.19605589 | -86.22868909 | 2022-02-04 04:21:10 | Brown, Indiana, US | |
3302267 | 3302267 | 2022-01-30 | US | Nebraska | Colfax | 31037 | 2517 | 21 | 0 | 41.57486951 | -97.0868542 | 2022-01-31 04:21:09 | Colfax, Nebraska, US | |
3064058 | 3064058 | 2022-01-29 | US | Nebraska | Colfax | 31037 | 2517 | 21 | 0 | 41.57486951 | -97.0868542 | 2022-01-30 04:21:26 | Colfax, Nebraska, US | |
3811992 | 3811992 | 2022-01-28 | US | Nebraska | Colfax | 31037 | 2517 | 21 | 0 | 41.57486951 | -97.0868542 | 2022-01-29 04:21:10 | Colfax, Nebraska, US | |
1230575 | 1230575 | 2022-01-24 | US | Tennessee | Lake | 47095 | 2517 | 34 | 0 | 36.34180170000001 | -89.48921915 | 2022-01-25 04:21:05 | Lake, Tennessee, US | |
1229164 | 1229164 | 2022-01-24 | US | Louisiana | West Feliciana | 22125 | 2517 | 41 | 0 | 30.87882871 | -91.41485379999999 | 2022-01-25 04:21:05 | West Feliciana, Louisiana, US | |
3427991 | 3427991 | 2022-01-21 | US | Texas | Camp | 48063 | 2517 | 70 | 0 | 32.97195142 | -94.97790104 | 2022-01-22 04:21:13 | Camp, Texas, US | |
3229242 | 3229242 | 2022-01-19 | US | Puerto Rico | Villalba | 72149 | 2517 | 0 | 0 | 18.127951 | -66.473115 | 2022-01-20 04:21:07 | Villalba, Puerto Rico, US | |
3688082 | 3688082 | 2022-01-13 | US | Colorado | Archuleta | 8007 | 2517 | 12 | 0 | 37.19474156 | -107.04768670000001 | 2022-01-14 04:21:54 | Archuleta, Colorado, US | |
733939 | 733939 | 2021-12-27 | US | Virginia | Southampton | 51175 | 2517 | 72 | 0 | 36.72231125 | -77.10642712 | 2021-12-28 04:21:47 | Southampton, Virginia, US | |
2113027 | 2113027 | 2021-12-26 | US | Kansas | Osage | 20139 | 2517 | 40 | 0 | 38.65235984 | -95.72707998 | 2021-12-27 04:21:58 | Osage, Kansas, US | |
3606399 | 3606399 | 2021-12-25 | US | Kansas | Osage | 20139 | 2517 | 40 | 0 | 38.65235984 | -95.72707998 | 2021-12-26 04:21:50 | Osage, Kansas, US | |
2964717 | 2964717 | 2021-12-24 | US | Kansas | Osage | 20139 | 2517 | 40 | 0 | 38.65235984 | -95.72707998 | 2021-12-25 04:21:37 | Osage, Kansas, US | |
3817749 | 3817749 | 2021-12-23 | US | Kansas | Osage | 20139 | 2517 | 40 | 0 | 38.65235984 | -95.72707998 | 2021-12-24 04:21:34 | Osage, Kansas, US | |
799757 | 799757 | 2021-12-22 | US | Kansas | Osage | 20139 | 2517 | 40 | 0 | 38.65235984 | -95.72707998 | 2021-12-23 04:21:21 | Osage, Kansas, US | |
1255279 | 1255279 | 2021-12-20 | US | Arkansas | Marion | 5089 | 2517 | 69 | 0 | 36.26844485 | -92.68451899 | 2021-12-21 03:21:27 | Marion, Arkansas, US | |
2089870 | 2089870 | 2021-12-14 | US | Missouri | Dallas | 29059 | 2517 | 57 | 0 | 37.681135499999996 | -93.02127031 | 2021-12-15 03:22:16 | Dallas, Missouri, US | |
784287 | 784287 | 2021-12-13 | US | Missouri | Dallas | 29059 | 2517 | 57 | 0 | 37.681135499999996 | -93.02127031 | 2021-12-14 04:22:38 | Dallas, Missouri, US | |
3657522 | 3657522 | 2021-12-10 | US | Missouri | Madison | 29123 | 2517 | 40 | 0 | 37.47865134 | -90.34671429999999 | 2021-12-11 04:22:45 | Madison, Missouri, US | |
2197104 | 2197104 | 2021-12-03 | US | Kentucky | Washington | 21229 | 2517 | 48 | 0 | 37.75599461 | -85.17407732 | 2021-12-04 04:22:18 | Washington, Kentucky, US | |
1822 | 1822 | 2021-12-02 | US | Louisiana | Bienville | 22013 | 2517 | 99 | 0 | 32.34569994 | -93.05398492 | 2021-12-03 04:23:05 | Bienville, Louisiana, US | |
1146421 | 1146421 | 2021-12-01 | US | Louisiana | Bienville | 22013 | 2517 | 99 | 0 | 32.34569994 | -93.05398492 | 2021-12-02 04:22:37 | Bienville, Louisiana, US | |
151408 | 151408 | 2021-11-29 | US | Kentucky | Knott | 21119 | 2517 | 43 | 0 | 37.35388197 | -82.94981134 | 2021-11-30 04:22:53 | Knott, Kentucky, US | |
904671 | 904671 | 2021-11-24 | US | Arkansas | Howard | 5061 | 2517 | 38 | 0 | 34.09007427 | -93.9934871 | 2021-11-25 04:22:33 | Howard, Arkansas, 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]);