johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
155 rows where confirmed = 4162 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 11
- US 141
- Russia 3
- Antigua and Barbuda 2
- Colombia 2
- China 1
- Guyana 1
- Japan 1
- Malaysia 1
- New Zealand 1
- Sierra Leone 1
- Ukraine 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
870264 | 870264 | 2022-12-11 | US | Kentucky | Pendleton | 21191 | 4162 | 43 | 0 | 38.69607718 | -84.35599463 | 2022-12-12 04:21:01 | Pendleton, Kentucky, US | |
258794 | 258794 | 2022-12-10 | US | Kentucky | Pendleton | 21191 | 4162 | 43 | 0 | 38.69607718 | -84.35599463 | 2022-12-11 04:20:50 | Pendleton, Kentucky, US | |
3937508 | 3937508 | 2022-12-09 | US | Kentucky | Pendleton | 21191 | 4162 | 43 | 0 | 38.69607718 | -84.35599463 | 2022-12-10 04:21:02 | Pendleton, Kentucky, US | |
3378840 | 3378840 | 2022-12-08 | US | Kentucky | Pendleton | 21191 | 4162 | 43 | 0 | 38.69607718 | -84.35599463 | 2022-12-09 04:21:05 | Pendleton, Kentucky, US | |
1986111 | 1986111 | 2022-12-07 | US | Kentucky | Pendleton | 21191 | 4162 | 43 | 0 | 38.69607718 | -84.35599463 | 2022-12-08 04:21:07 | Pendleton, Kentucky, US | |
3715634 | 3715634 | 2022-12-06 | US | Kentucky | Pendleton | 21191 | 4162 | 43 | 0 | 38.69607718 | -84.35599463 | 2022-12-07 04:20:58 | Pendleton, Kentucky, US | |
2416339 | 2416339 | 2022-12-05 | US | Kentucky | Pendleton | 21191 | 4162 | 43 | 0 | 38.69607718 | -84.35599463 | 2022-12-06 04:21:03 | Pendleton, Kentucky, US | |
719020 | 719020 | 2022-12-04 | US | Arkansas | Van Buren | 5141 | 4162 | 65 | 0 | 35.58095779 | -92.51295036 | 2022-12-05 04:20:58 | Van Buren, Arkansas, US | |
1239477 | 1239477 | 2022-11-28 | China | Zhejiang | 4162 | 1 | 0 | 29.1832 | 120.0934 | 2022-11-29 04:21:05 | Zhejiang, China | |||
1053142 | 1053142 | 2022-11-06 | US | Virginia | Alleghany | 51005 | 4162 | 108 | 0 | 37.78636074 | -80.00222498 | 2022-11-07 04:21:26 | Alleghany, Virginia, US | |
621166 | 621166 | 2022-11-05 | US | Virginia | Alleghany | 51005 | 4162 | 108 | 0 | 37.78636074 | -80.00222498 | 2022-11-06 04:21:24 | Alleghany, Virginia, US | |
1025670 | 1025670 | 2022-11-04 | US | Virginia | Alleghany | 51005 | 4162 | 108 | 0 | 37.78636074 | -80.00222498 | 2022-11-05 04:21:52 | Alleghany, Virginia, US | |
3040605 | 3040605 | 2022-10-27 | US | New York | Schuyler | 36097 | 4162 | 30 | 0 | 42.39184015 | -76.8773299 | 2022-10-28 04:22:31 | Schuyler, New York, US | |
3756569 | 3756569 | 2022-10-13 | US | Texas | Freestone | 48161 | 4162 | 85 | 0 | 31.70422788 | -96.15072516 | 2022-10-14 04:22:28 | Freestone, Texas, US | |
3217394 | 3217394 | 2022-10-12 | US | Texas | Freestone | 48161 | 4162 | 85 | 0 | 31.70422788 | -96.15072516 | 2022-10-13 04:22:39 | Freestone, Texas, US | |
3253243 | 3253243 | 2022-10-11 | US | Texas | Freestone | 48161 | 4162 | 85 | 0 | 31.70422788 | -96.15072516 | 2022-10-12 04:22:51 | Freestone, Texas, US | |
2970502 | 2970502 | 2022-10-10 | US | Texas | Freestone | 48161 | 4162 | 85 | 0 | 31.70422788 | -96.15072516 | 2022-10-11 04:23:05 | Freestone, Texas, US | |
131779 | 131779 | 2022-10-04 | US | Illinois | Menard | 17129 | 4162 | 25 | 0 | 40.02742725 | -89.80246001 | 2022-10-05 04:23:06 | Menard, Illinois, US | |
2686726 | 2686726 | 2022-10-03 | US | Illinois | Menard | 17129 | 4162 | 25 | 0 | 40.02742725 | -89.80246001 | 2022-10-04 04:22:55 | Menard, Illinois, US | |
419899 | 419899 | 2022-09-18 | US | California | Mariposa | 6043 | 4162 | 37 | 0 | 37.57978556 | -119.9073334 | 2022-09-19 04:21:49 | Mariposa, California, US | |
3373923 | 3373923 | 2022-09-17 | US | California | Mariposa | 6043 | 4162 | 37 | 0 | 37.57978556 | -119.9073334 | 2022-09-18 04:22:50 | Mariposa, California, US | |
2356031 | 2356031 | 2022-09-16 | US | California | Mariposa | 6043 | 4162 | 37 | 0 | 37.57978556 | -119.9073334 | 2022-09-17 04:20:19 | Mariposa, California, US | |
3987188 | 3987188 | 2022-09-15 | US | California | Mariposa | 6043 | 4162 | 37 | 0 | 37.57978556 | -119.9073334 | 2022-09-16 04:21:19 | Mariposa, California, US | |
3767008 | 3767008 | 2022-09-11 | US | Indiana | Pike | 18125 | 4162 | 51 | 0 | 38.40112197 | -87.23574907 | 2022-09-12 04:20:58 | Pike, Indiana, US | |
3825583 | 3825583 | 2022-09-10 | US | Indiana | Pike | 18125 | 4162 | 51 | 0 | 38.40112197 | -87.23574907 | 2022-09-11 04:20:50 | Pike, Indiana, US | |
964040 | 964040 | 2022-09-09 | US | Indiana | Pike | 18125 | 4162 | 51 | 0 | 38.40112197 | -87.23574907 | 2022-09-10 04:21:10 | Pike, Indiana, US | |
898892 | 898892 | 2022-07-24 | US | Puerto Rico | Guayanilla | 72059 | 4162 | 0 | 0 | 18.039942 | -66.79186 | 2022-07-25 04:20:51 | Guayanilla, Puerto Rico, US | |
1610478 | 1610478 | 2022-07-20 | US | New Mexico | Socorro | 35053 | 4162 | 92 | 0 | 34.00715494 | -106.9298354 | 2022-07-21 04:21:10 | Socorro, New Mexico, US | |
2744468 | 2744468 | 2022-07-07 | US | Washington | Pacific | 53049 | 4162 | 62 | 0 | 46.55418369 | -123.7285716 | 2022-07-08 04:20:56 | Pacific, Washington, US | |
1203263 | 1203263 | 2022-07-06 | US | Washington | Pacific | 53049 | 4162 | 62 | 0 | 46.55418369 | -123.7285716 | 2022-07-07 04:20:55 | Pacific, Washington, US | |
3967810 | 3967810 | 2022-07-05 | US | Kansas | Allen | 20001 | 4162 | 58 | 0 | 37.88582951 | -95.30030847 | 2022-07-06 04:20:58 | Allen, Kansas, US | |
3079538 | 3079538 | 2022-07-04 | US | Kentucky | Trigg | 21221 | 4162 | 45 | 0 | 36.80767017 | -87.87333656 | 2022-07-05 04:20:45 | Trigg, Kentucky, US | |
3079321 | 3079321 | 2022-07-04 | US | Kansas | Allen | 20001 | 4162 | 58 | 0 | 37.88582951 | -95.30030847 | 2022-07-05 04:20:45 | Allen, Kansas, US | |
1768820 | 1768820 | 2022-07-03 | US | Kentucky | Trigg | 21221 | 4162 | 45 | 0 | 36.80767017 | -87.87333656 | 2022-07-04 04:20:54 | Trigg, Kentucky, US | |
1768603 | 1768603 | 2022-07-03 | US | Kansas | Allen | 20001 | 4162 | 58 | 0 | 37.88582951 | -95.30030847 | 2022-07-04 04:20:54 | Allen, Kansas, US | |
3366806 | 3366806 | 2022-07-02 | US | Kentucky | Trigg | 21221 | 4162 | 45 | 0 | 36.80767017 | -87.87333656 | 2022-07-03 04:20:59 | Trigg, Kentucky, US | |
3366589 | 3366589 | 2022-07-02 | US | Kansas | Allen | 20001 | 4162 | 58 | 0 | 37.88582951 | -95.30030847 | 2022-07-03 04:20:59 | Allen, Kansas, US | |
595135 | 595135 | 2022-07-01 | US | Kentucky | Trigg | 21221 | 4162 | 45 | 0 | 36.80767017 | -87.87333656 | 2022-07-02 04:21:16 | Trigg, Kentucky, US | |
594918 | 594918 | 2022-07-01 | US | Kansas | Allen | 20001 | 4162 | 58 | 0 | 37.88582951 | -95.30030847 | 2022-07-02 04:21:16 | Allen, Kansas, US | |
3941536 | 3941536 | 2022-06-30 | US | Kentucky | Trigg | 21221 | 4162 | 45 | 0 | 36.80767017 | -87.87333656 | 2022-07-01 04:21:10 | Trigg, Kentucky, US | |
3941319 | 3941319 | 2022-06-30 | US | Kansas | Allen | 20001 | 4162 | 58 | 0 | 37.88582951 | -95.30030847 | 2022-07-01 04:21:10 | Allen, Kansas, US | |
2491494 | 2491494 | 2022-06-29 | US | Kentucky | Trigg | 21221 | 4162 | 45 | 0 | 36.80767017 | -87.87333656 | 2022-06-30 04:21:01 | Trigg, Kentucky, US | |
2491277 | 2491277 | 2022-06-29 | US | Kansas | Allen | 20001 | 4162 | 58 | 0 | 37.88582951 | -95.30030847 | 2022-06-30 04:21:01 | Allen, Kansas, US | |
2240876 | 2240876 | 2022-06-28 | US | Kentucky | Trigg | 21221 | 4162 | 45 | 0 | 36.80767017 | -87.87333656 | 2022-06-29 04:20:59 | Trigg, Kentucky, US | |
2149118 | 2149118 | 2022-06-27 | US | Kentucky | Trigg | 21221 | 4162 | 45 | 0 | 36.80767017 | -87.87333656 | 2022-06-28 04:20:58 | Trigg, Kentucky, US | |
167231 | 167231 | 2022-06-21 | US | Iowa | Delaware | 19055 | 4162 | 68 | 0 | 42.47104597 | -91.3664492 | 2022-06-22 04:20:54 | Delaware, Iowa, US | |
1764514 | 1764514 | 2022-06-20 | US | Iowa | Delaware | 19055 | 4162 | 68 | 0 | 42.47104597 | -91.3664492 | 2022-06-21 04:20:56 | Delaware, Iowa, US | |
3270700 | 3270700 | 2022-06-19 | US | Iowa | Delaware | 19055 | 4162 | 68 | 0 | 42.47104597 | -91.3664492 | 2022-06-20 04:21:01 | Delaware, Iowa, US | |
3398612 | 3398612 | 2022-06-18 | US | Iowa | Delaware | 19055 | 4162 | 68 | 0 | 42.47104597 | -91.3664492 | 2022-06-19 04:20:51 | Delaware, Iowa, US | |
2312489 | 2312489 | 2022-06-17 | US | Iowa | Delaware | 19055 | 4162 | 68 | 0 | 42.47104597 | -91.3664492 | 2022-06-18 04:21:10 | Delaware, Iowa, US | |
559993 | 559993 | 2022-06-16 | US | Iowa | Delaware | 19055 | 4162 | 68 | 0 | 42.47104597 | -91.3664492 | 2022-06-17 04:20:56 | Delaware, Iowa, US | |
3985367 | 3985367 | 2022-06-15 | US | Puerto Rico | Loiza | 72087 | 4162 | 0 | 0 | 18.425688 | -65.89943 | 2022-06-16 04:20:55 | Loiza, Puerto Rico, US | |
3983795 | 3983795 | 2022-06-15 | US | Iowa | Delaware | 19055 | 4162 | 68 | 0 | 42.47104597 | -91.3664492 | 2022-06-16 04:20:55 | Delaware, Iowa, US | |
1424133 | 1424133 | 2022-06-08 | US | Texas | Bosque | 48035 | 4162 | 70 | 0 | 31.89978581 | -97.63613524 | 2022-06-09 04:20:54 | Bosque, Texas, US | |
3888139 | 3888139 | 2022-06-06 | US | Arkansas | Polk | 5113 | 4162 | 149 | 0 | 34.48254879 | -94.22728802 | 2022-06-07 04:21:08 | Polk, Arkansas, US | |
3507908 | 3507908 | 2022-06-05 | US | Arkansas | Polk | 5113 | 4162 | 149 | 0 | 34.48254879 | -94.22728802 | 2022-06-06 04:20:57 | Polk, Arkansas, US | |
2051217 | 2051217 | 2022-05-25 | US | Virginia | Greene | 51079 | 4162 | 62 | 0 | 38.29545894 | -78.46525378 | 2022-05-26 04:20:50 | Greene, Virginia, US | |
625228 | 625228 | 2022-05-22 | US | Virginia | Greene | 51079 | 4162 | 62 | 0 | 38.29545894 | -78.46525378 | 2022-05-26 04:20:50 | Greene, Virginia, US | |
3583403 | 3583403 | 2022-05-17 | US | Georgia | Brantley | 13025 | 4162 | 109 | 0 | 31.19576557 | -81.97743999 | 2022-05-18 04:20:50 | Brantley, Georgia, US | |
1504360 | 1504360 | 2022-05-16 | US | Georgia | Brantley | 13025 | 4162 | 109 | 0 | 31.19576557 | -81.97743999 | 2022-05-17 04:20:59 | Brantley, Georgia, US | |
2084719 | 2084719 | 2022-05-15 | US | Georgia | Brantley | 13025 | 4162 | 109 | 0 | 31.19576557 | -81.97743999 | 2022-05-16 04:20:47 | Brantley, Georgia, US | |
3355429 | 3355429 | 2022-05-14 | US | Georgia | Brantley | 13025 | 4162 | 109 | 0 | 31.19576557 | -81.97743999 | 2022-05-15 04:20:53 | Brantley, Georgia, US | |
659074 | 659074 | 2022-05-13 | US | Georgia | Brantley | 13025 | 4162 | 109 | 0 | 31.19576557 | -81.97743999 | 2022-05-14 04:20:48 | Brantley, Georgia, US | |
2534157 | 2534157 | 2022-05-12 | US | Georgia | Brantley | 13025 | 4162 | 109 | 0 | 31.19576557 | -81.97743999 | 2022-05-13 04:20:51 | Brantley, Georgia, US | |
3445603 | 3445603 | 2022-05-11 | US | Georgia | Brantley | 13025 | 4162 | 109 | 0 | 31.19576557 | -81.97743999 | 2022-05-12 04:20:54 | Brantley, Georgia, US | |
3878342 | 3878342 | 2022-02-19 | US | Puerto Rico | Morovis | 72101 | 4162 | 0 | 0 | 18.316963 | -66.420383 | 2022-02-20 04:21:00 | Morovis, Puerto Rico, US | |
3822234 | 3822234 | 2022-02-16 | US | Mississippi | Clarke | 28023 | 4162 | 103 | 0 | 32.04158545 | -88.68896219999998 | 2022-02-17 04:20:56 | Clarke, Mississippi, US | |
189225 | 189225 | 2022-02-13 | US | Texas | Lee | 48287 | 4162 | 56 | 0 | 30.31120597 | -96.97045773 | 2022-02-14 04:20:51 | Lee, Texas, US | |
2474918 | 2474918 | 2022-02-03 | US | Illinois | Bond | 17005 | 4162 | 28 | 0 | 38.88829622 | -89.43534887 | 2022-02-04 04:21:10 | Bond, Illinois, US | |
460343 | 460343 | 2022-02-02 | US | Illinois | Bond | 17005 | 4162 | 28 | 0 | 38.88829622 | -89.43534887 | 2022-02-03 04:21:21 | Bond, Illinois, US | |
459868 | 459868 | 2022-02-02 | US | Arkansas | Grant | 5053 | 4162 | 53 | 0 | 34.29017991 | -92.42320562 | 2022-02-03 04:21:21 | Grant, Arkansas, US | |
557720 | 557720 | 2022-01-16 | US | Tennessee | Crockett | 47033 | 4162 | 75 | 0 | 35.81830662 | -89.14916269 | 2022-01-17 04:21:08 | Crockett, Tennessee, US | |
3688622 | 3688622 | 2022-01-13 | US | Indiana | Sullivan | 18153 | 4162 | 63 | 0 | 39.08952258 | -87.41414469 | 2022-01-14 04:21:54 | Sullivan, Indiana, US | |
1289045 | 1289045 | 2022-01-04 | US | Texas | Calhoun | 48057 | 4162 | 39 | 0 | 28.47048236 | -96.61633945 | 2022-01-05 04:21:59 | Calhoun, Texas, US | |
4001179 | 4001179 | 2021-12-30 | US | Ohio | Wyandot | 39175 | 4162 | 87 | 0 | 40.84339621 | -83.30734173 | 2021-12-31 04:21:50 | Wyandot, Ohio, US | |
1670033 | 1670033 | 2021-12-29 | US | Maryland | Caroline | 24011 | 4162 | 57 | 0 | 38.87172293 | -75.82904158 | 2021-12-30 04:21:25 | Caroline, Maryland, US | |
1255246 | 1255246 | 2021-12-20 | US | Arkansas | Cleburne | 5023 | 4162 | 99 | 0 | 35.53864922 | -92.02640019 | 2021-12-21 03:21:27 | Cleburne, Arkansas, US | |
1718408 | 1718408 | 2021-12-16 | US | Nebraska | Cass | 31025 | 4162 | 16 | 0 | 40.90899107 | -96.13971217 | 2021-12-17 04:22:14 | Cass, Nebraska, US | |
782067 | 782067 | 2021-12-13 | Antigua and Barbuda | 4162 | 117 | 0 | 17.0608 | -61.7964 | 2021-12-14 04:22:38 | Antigua and Barbuda | ||||
1660102 | 1660102 | 2021-12-12 | Antigua and Barbuda | 4162 | 117 | 0 | 17.0608 | -61.7964 | 2021-12-13 04:22:02 | Antigua and Barbuda | ||||
3657062 | 3657062 | 2021-12-10 | US | Kentucky | Russell | 21207 | 4162 | 61 | 0 | 36.99308373 | -85.06070117 | 2021-12-11 04:22:45 | Russell, Kentucky, US | |
552838 | 552838 | 2021-12-08 | US | Nebraska | Dawson | 31047 | 4162 | 31 | 0 | 40.87028216 | -99.82014609999999 | 2021-12-09 04:22:49 | Dawson, Nebraska, US | |
3797378 | 3797378 | 2021-10-25 | US | West Virginia | Hancock | 54029 | 4162 | 113 | 0 | 40.51943859 | -80.57461608 | 2021-10-26 04:22:09 | Hancock, West Virginia, US | |
2126208 | 2126208 | 2021-10-21 | US | Ohio | Gallia | 39053 | 4162 | 74 | 0 | 38.82708533 | -82.31647569 | 2021-10-22 04:21:14 | Gallia, Ohio, US | |
3834989 | 3834989 | 2021-10-05 | US | Ohio | Pike | 39131 | 4162 | 66 | 0 | 39.07634001 | -83.06769584 | 2021-10-06 04:21:33 | Pike, Ohio, US | |
709931 | 709931 | 2021-09-29 | US | West Virginia | Mineral | 54057 | 4162 | 104 | 0 | 39.41561583 | -78.94104895 | 2021-09-30 04:21:20 | Mineral, West Virginia, US | |
1921355 | 1921355 | 2021-09-24 | New Zealand | 4162 | 29 | 0 | -40.9006 | 174.886 | 2021-09-25 04:21:31 | New Zealand | ||||
3759728 | 3759728 | 2021-09-21 | US | New York | Otsego | 36077 | 4162 | 51 | 0 | 42.63492579 | -75.03151402 | 2021-09-22 04:21:45 | Otsego, New York, US | |
1375296 | 1375296 | 2021-09-15 | US | Georgia | Gilmer | 13123 | 4162 | 107 | 0 | 34.69316688 | -84.45802506 | 2021-09-16 04:22:19 | Gilmer, Georgia, US | |
1888583 | 1888583 | 2021-09-12 | US | Wisconsin | Trempealeau | 55121 | 4162 | 51 | 0 | 44.30360275 | -91.35893614 | 2021-09-13 04:21:15 | Trempealeau, Wisconsin, US | |
3809486 | 3809486 | 2021-09-11 | US | Wisconsin | Trempealeau | 55121 | 4162 | 51 | 0 | 44.30360275 | -91.35893614 | 2021-09-12 04:21:13 | Trempealeau, Wisconsin, US | |
3452426 | 3452426 | 2021-09-10 | US | Wisconsin | Trempealeau | 55121 | 4162 | 51 | 0 | 44.30360275 | -91.35893614 | 2021-09-11 04:21:30 | Trempealeau, Wisconsin, US | |
251257 | 251257 | 2021-09-04 | US | Missouri | Warren | 29219 | 4162 | 33 | 0 | 38.76529479 | -91.16124662 | 2021-09-05 04:21:33 | Warren, Missouri, US | |
514950 | 514950 | 2021-08-19 | US | Texas | Willacy | 48489 | 4162 | 93 | 0 | 26.47411727 | -97.61535848 | 2021-08-20 04:21:33 | Willacy, Texas, US | |
1605997 | 1605997 | 2021-08-16 | US | Minnesota | Steele | 27147 | 4162 | 19 | 0 | 44.02240351 | -93.22627088 | 2021-08-17 04:21:49 | Steele, Minnesota, US | |
103958 | 103958 | 2021-08-15 | US | Colorado | Logan | 8075 | 4162 | 69 | 0 | 40.7249637 | -103.110817 | 2021-08-16 04:21:31 | Logan, Colorado, US | |
2353062 | 2353062 | 2021-08-10 | US | Michigan | Delta | 26041 | 4162 | 95 | 0 | 45.90484910000001 | -86.9080745 | 2021-08-11 04:21:58 | Delta, Michigan, US | |
651591 | 651591 | 2021-08-09 | US | Michigan | Delta | 26041 | 4162 | 95 | 0 | 45.90484910000001 | -86.9080745 | 2021-08-10 04:21:27 | Delta, Michigan, US | |
590265 | 590265 | 2021-08-08 | US | Colorado | Montrose | 8085 | 4162 | 75 | 0 | 38.40214114 | -108.26390220000002 | 2021-08-09 04:21:24 | Montrose, Colorado, US | |
3137919 | 3137919 | 2021-07-23 | US | Alabama | Escambia | 1053 | 4162 | 82 | 0 | 31.1256789 | -87.15918694 | 2021-07-24 00:21:36 | Escambia, Alabama, 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]);