johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
133 rows where confirmed = 4553 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 8
- US 122
- Russia 3
- Colombia 2
- Japan 2
- Hungary 1
- Netherlands 1
- Sierra Leone 1
- Sweden 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2954752 | 2954752 | 2022-12-20 | US | Virginia | King William | 51101 | 4553 | 51 | 0 | 37.70965316 | -77.09384941 | 2022-12-21 04:21:03 | King William, Virginia, US | |
711267 | 711267 | 2022-11-01 | US | Georgia | Greene | 13133 | 4553 | 89 | 0 | 33.5769205 | -83.17139104 | 2022-11-02 04:22:09 | Greene, Georgia, US | |
3285716 | 3285716 | 2022-10-31 | US | Georgia | Greene | 13133 | 4553 | 89 | 0 | 33.5769205 | -83.17139104 | 2022-11-01 04:22:36 | Greene, Georgia, US | |
320749 | 320749 | 2022-10-30 | US | Georgia | Greene | 13133 | 4553 | 89 | 0 | 33.5769205 | -83.17139104 | 2022-10-31 04:21:36 | Greene, Georgia, US | |
913025 | 913025 | 2022-10-29 | US | Georgia | Greene | 13133 | 4553 | 89 | 0 | 33.5769205 | -83.17139104 | 2022-10-30 04:22:14 | Greene, Georgia, US | |
1367294 | 1367294 | 2022-10-28 | US | Georgia | Greene | 13133 | 4553 | 89 | 0 | 33.5769205 | -83.17139104 | 2022-10-29 04:21:13 | Greene, Georgia, US | |
3039149 | 3039149 | 2022-10-27 | US | Georgia | Greene | 13133 | 4553 | 89 | 0 | 33.5769205 | -83.17139104 | 2022-10-28 04:22:31 | Greene, Georgia, US | |
539569 | 539569 | 2022-10-26 | US | Georgia | Greene | 13133 | 4553 | 89 | 0 | 33.5769205 | -83.17139104 | 2022-10-27 04:22:01 | Greene, Georgia, US | |
3756477 | 3756477 | 2022-10-13 | US | Tennessee | Trousdale | 47169 | 4553 | 47 | 0 | 36.39026213 | -86.16087954 | 2022-10-14 04:22:28 | Trousdale, Tennessee, US | |
3252575 | 3252575 | 2022-10-11 | US | North Dakota | Richland | 38077 | 4553 | 23 | 0 | 46.26440649 | -96.94852979 | 2022-10-12 04:22:51 | Richland, North Dakota, US | |
3777220 | 3777220 | 2022-08-30 | US | Virginia | Buckingham | 51029 | 4553 | 60 | 0 | 37.57242268 | -78.52518834 | 2022-08-31 04:20:57 | Buckingham, Virginia, US | |
2856023 | 2856023 | 2022-08-22 | US | Texas | Llano | 48299 | 4553 | 98 | 0 | 30.70645047 | -98.68475262 | 2022-08-23 04:20:56 | Llano, Texas, US | |
3950966 | 3950966 | 2022-08-17 | US | Arkansas | Clay | 5021 | 4553 | 96 | 0 | 36.36826212 | -90.4148172 | 2022-08-18 04:21:11 | Clay, Arkansas, US | |
994469 | 994469 | 2022-08-16 | US | West Virginia | Braxton | 54007 | 4553 | 48 | 0 | 38.70036159 | -80.72011184 | 2022-08-17 04:20:59 | Braxton, West Virginia, US | |
3648588 | 3648588 | 2022-08-14 | US | Illinois | Jo Daviess | 17085 | 4553 | 38 | 0 | 42.36542373 | -90.21094405 | 2022-08-15 04:20:59 | Jo Daviess, Illinois, US | |
1969594 | 1969594 | 2022-08-13 | US | Illinois | Jo Daviess | 17085 | 4553 | 38 | 0 | 42.36542373 | -90.21094405 | 2022-08-14 04:20:55 | Jo Daviess, Illinois, US | |
2889403 | 2889403 | 2022-08-12 | US | Illinois | Jo Daviess | 17085 | 4553 | 38 | 0 | 42.36542373 | -90.21094405 | 2022-08-13 04:20:52 | Jo Daviess, Illinois, US | |
1066621 | 1066621 | 2022-07-28 | US | Florida | Union | 12125 | 4553 | 117 | 0 | 30.04412971 | -82.37497443 | 2022-07-29 04:20:45 | Union, Florida, US | |
2338389 | 2338389 | 2022-07-27 | US | Tennessee | Sequatchie | 47153 | 4553 | 70 | 0 | 35.36979721 | -85.41022136 | 2022-07-28 04:20:56 | Sequatchie, Tennessee, US | |
2336140 | 2336140 | 2022-07-27 | US | Florida | Union | 12125 | 4553 | 117 | 0 | 30.04412971 | -82.37497443 | 2022-07-28 04:20:56 | Union, Florida, US | |
1488330 | 1488330 | 2022-07-26 | US | Florida | Union | 12125 | 4553 | 117 | 0 | 30.04412971 | -82.37497443 | 2022-07-27 04:21:04 | Union, Florida, US | |
2594776 | 2594776 | 2022-07-25 | US | Florida | Union | 12125 | 4553 | 117 | 0 | 30.04412971 | -82.37497443 | 2022-07-26 04:20:58 | Union, Florida, US | |
896891 | 896891 | 2022-07-24 | US | Florida | Union | 12125 | 4553 | 117 | 0 | 30.04412971 | -82.37497443 | 2022-07-25 04:20:51 | Union, Florida, US | |
91885 | 91885 | 2022-07-23 | US | Florida | Union | 12125 | 4553 | 117 | 0 | 30.04412971 | -82.37497443 | 2022-07-24 04:20:47 | Union, Florida, US | |
900907 | 900907 | 2022-07-22 | US | Florida | Union | 12125 | 4553 | 117 | 0 | 30.04412971 | -82.37497443 | 2022-07-23 04:20:53 | Union, Florida, US | |
671043 | 671043 | 2022-07-21 | US | Florida | Union | 12125 | 4553 | 117 | 0 | 30.04412971 | -82.37497443 | 2022-07-22 04:21:15 | Union, Florida, US | |
1609006 | 1609006 | 2022-07-20 | US | Florida | Union | 12125 | 4553 | 117 | 0 | 30.04412971 | -82.37497443 | 2022-07-21 04:21:10 | Union, Florida, US | |
959639 | 959639 | 2022-07-19 | US | Florida | Union | 12125 | 4553 | 117 | 0 | 30.04412971 | -82.37497443 | 2022-07-20 04:20:59 | Union, Florida, US | |
3211026 | 3211026 | 2022-07-18 | US | Florida | Union | 12125 | 4553 | 117 | 0 | 30.04412971 | -82.37497443 | 2022-07-19 04:20:58 | Union, Florida, US | |
3406201 | 3406201 | 2022-07-17 | US | Florida | Union | 12125 | 4553 | 117 | 0 | 30.04412971 | -82.37497443 | 2022-07-18 04:20:59 | Union, Florida, US | |
2152401 | 2152401 | 2022-07-16 | US | Florida | Union | 12125 | 4553 | 117 | 0 | 30.04412971 | -82.37497443 | 2022-07-17 04:21:15 | Union, Florida, US | |
2419634 | 2419634 | 2022-07-15 | US | Florida | Union | 12125 | 4553 | 117 | 0 | 30.04412971 | -82.37497443 | 2022-07-16 04:21:05 | Union, Florida, US | |
631091 | 631091 | 2022-07-12 | US | Iowa | Crawford | 19047 | 4553 | 54 | 0 | 42.03718237 | -95.3819718 | 2022-07-13 04:20:58 | Crawford, Iowa, US | |
1212735 | 1212735 | 2022-07-11 | US | Iowa | Crawford | 19047 | 4553 | 54 | 0 | 42.03718237 | -95.3819718 | 2022-07-12 04:20:51 | Crawford, Iowa, US | |
2790217 | 2790217 | 2022-07-10 | US | Iowa | Crawford | 19047 | 4553 | 54 | 0 | 42.03718237 | -95.3819718 | 2022-07-11 04:20:46 | Crawford, Iowa, US | |
143170 | 143170 | 2022-07-09 | US | Iowa | Crawford | 19047 | 4553 | 54 | 0 | 42.03718237 | -95.3819718 | 2022-07-10 04:20:54 | Crawford, Iowa, US | |
1418270 | 1418270 | 2022-07-08 | US | Iowa | Crawford | 19047 | 4553 | 54 | 0 | 42.03718237 | -95.3819718 | 2022-07-09 04:20:59 | Crawford, Iowa, US | |
2742195 | 2742195 | 2022-07-07 | US | Iowa | Crawford | 19047 | 4553 | 54 | 0 | 42.03718237 | -95.3819718 | 2022-07-08 04:20:56 | Crawford, Iowa, US | |
1200990 | 1200990 | 2022-07-06 | US | Iowa | Crawford | 19047 | 4553 | 54 | 0 | 42.03718237 | -95.3819718 | 2022-07-07 04:20:55 | Crawford, Iowa, US | |
1649343 | 1649343 | 2022-06-23 | US | Illinois | Bond | 17005 | 4553 | 31 | 0 | 38.88829622 | -89.43534887 | 2022-06-24 04:20:58 | Bond, Illinois, US | |
947830 | 947830 | 2022-06-14 | US | Illinois | De Witt | 17039 | 4553 | 40 | 0 | 40.17514519 | -88.90959682 | 2022-06-15 04:20:54 | De Witt, Illinois, US | |
3594032 | 3594032 | 2022-05-23 | US | Illinois | Johnson | 17087 | 4553 | 40 | 0 | 37.45939802 | -88.88165419 | 2022-05-24 04:20:57 | Johnson, Illinois, US | |
1187663 | 1187663 | 2022-05-18 | US | Tennessee | Benton | 47005 | 4553 | 93 | 0 | 36.07110411 | -88.06849355 | 2022-05-19 04:20:54 | Benton, Tennessee, US | |
1227181 | 1227181 | 2022-04-14 | US | Wisconsin | Sawyer | 55113 | 4553 | 62 | 0 | 45.87931905 | -91.14504927 | 2022-04-15 04:20:57 | Sawyer, Wisconsin, US | |
1438714 | 1438714 | 2022-03-28 | US | Nebraska | Washington | 31177 | 4553 | 25 | 0 | 41.52815707 | -96.22019892 | 2022-03-29 04:20:46 | Washington, Nebraska, US | |
1720974 | 1720974 | 2022-03-25 | US | Arkansas | Hempstead | 5057 | 4553 | 65 | 0 | 33.73325583 | -93.66935133 | 2022-03-26 04:20:23 | Hempstead, Arkansas, US | |
264144 | 264144 | 2022-03-15 | US | Oregon | Clatsop | 41007 | 4553 | 39 | 0 | 45.99712889 | -123.660711 | 2022-03-16 04:20:50 | Clatsop, Oregon, US | |
1548571 | 1548571 | 2022-03-07 | US | Colorado | Alamosa | 8003 | 4553 | 62 | 0 | 37.57250606 | -105.7885451 | 2022-03-08 04:20:54 | Alamosa, Colorado, US | |
2527858 | 2527858 | 2022-03-02 | US | Ohio | Meigs | 39105 | 4553 | 88 | 0 | 39.09224872 | -82.0305041 | 2022-03-03 04:21:01 | Meigs, Ohio, US | |
3915414 | 3915414 | 2022-02-20 | US | Virginia | Prince Edward | 51147 | 4553 | 59 | 0 | 37.22554789 | -78.43597949 | 2022-02-21 04:21:05 | Prince Edward, Virginia, US | |
3878972 | 3878972 | 2022-02-19 | US | Virginia | Prince Edward | 51147 | 4553 | 59 | 0 | 37.22554789 | -78.43597949 | 2022-02-20 04:21:00 | Prince Edward, Virginia, US | |
3859228 | 3859228 | 2022-02-18 | US | Virginia | Prince Edward | 51147 | 4553 | 59 | 0 | 37.22554789 | -78.43597949 | 2022-02-19 04:21:11 | Prince Edward, Virginia, US | |
2476633 | 2476633 | 2022-02-03 | US | Pennsylvania | Juniata | 42067 | 4553 | 168 | 0 | 40.53358749 | -77.39975129999998 | 2022-02-04 04:21:10 | Juniata, Pennsylvania, US | |
461709 | 461709 | 2022-02-02 | US | North Carolina | Hertford | 37091 | 4553 | 80 | 0 | 36.3607755 | -76.98104134 | 2022-02-03 04:21:21 | Hertford, North Carolina, US | |
1231200 | 1231200 | 2022-01-24 | US | Wisconsin | Taylor | 55119 | 4553 | 63 | 0 | 45.21179252 | -90.5004405 | 2022-01-25 04:21:05 | Taylor, Wisconsin, US | |
1141966 | 1141966 | 2022-01-23 | US | Illinois | Union | 17181 | 4553 | 58 | 0 | 37.47119609 | -89.25548938 | 2022-01-24 04:21:12 | Union, Illinois, US | |
2833884 | 2833884 | 2022-01-22 | US | Illinois | Union | 17181 | 4553 | 58 | 0 | 37.47119609 | -89.25548938 | 2022-01-23 04:21:13 | Union, Illinois, US | |
3426002 | 3426002 | 2022-01-21 | US | Illinois | Union | 17181 | 4553 | 58 | 0 | 37.47119609 | -89.25548938 | 2022-01-22 04:21:13 | Union, Illinois, US | |
1960560 | 1960560 | 2022-01-20 | Japan | Kochi | 4553 | 33 | 0 | 33.422519 | 133.367307 | 2022-01-21 04:21:09 | Kochi, Japan | |||
1671844 | 1671844 | 2021-12-29 | US | Virginia | Orange | 51137 | 4553 | 69 | 0 | 38.24530219 | -78.01560400000002 | 2021-12-30 04:21:25 | Orange, Virginia, US | |
1663929 | 1663929 | 2021-12-12 | US | West Virginia | Nicholas | 54067 | 4553 | 70 | 0 | 38.29617706 | -80.79759588 | 2021-12-13 04:22:02 | Nicholas, West Virginia, US | |
3071895 | 3071895 | 2021-11-23 | US | Mississippi | Yazoo | 28163 | 4553 | 91 | 0 | 32.77890365 | -90.39656148 | 2021-11-24 04:22:14 | Yazoo, Mississippi, US | |
3750993 | 3750993 | 2021-11-22 | US | Mississippi | Yazoo | 28163 | 4553 | 91 | 0 | 32.77890365 | -90.39656148 | 2021-11-23 04:22:39 | Yazoo, Mississippi, US | |
276768 | 276768 | 2021-11-03 | US | California | Siskiyou | 6093 | 4553 | 46 | 0 | 41.59198861 | -122.54074340000001 | 2021-11-04 04:22:20 | Siskiyou, California, US | |
290251 | 290251 | 2021-10-31 | US | New York | Orleans | 36073 | 4553 | 90 | 0 | 43.2516977 | -78.2320066 | 2021-11-01 04:22:01 | Orleans, New York, US | |
445852 | 445852 | 2021-10-20 | US | Ohio | Morrow | 39117 | 4553 | 60 | 0 | 40.52363560000001 | -82.7892599 | 2021-10-21 04:21:18 | Morrow, Ohio, US | |
2045702 | 2045702 | 2021-10-18 | US | Mississippi | Tate | 28137 | 4553 | 109 | 0 | 34.65133709 | -89.94485778 | 2021-10-19 04:20:54 | Tate, Mississippi, US | |
3930541 | 3930541 | 2021-10-02 | US | Ohio | Ottawa | 39123 | 4553 | 87 | 0 | 41.53781826 | -83.0940185 | 2021-10-03 04:21:24 | Ottawa, Ohio, US | |
1237983 | 1237983 | 2021-09-27 | US | North Carolina | Macon | 37113 | 4553 | 49 | 0 | 35.14867843 | -83.41696617 | 2021-09-28 04:21:28 | Macon, North Carolina, US | |
602527 | 602527 | 2021-09-23 | US | Georgia | Lumpkin | 13187 | 4553 | 90 | 0 | 34.57286511 | -84.00425681 | 2021-09-24 04:21:44 | Lumpkin, Georgia, US | |
2463429 | 2463429 | 2021-09-14 | US | Colorado | Montrose | 8085 | 4553 | 80 | 0 | 38.40214114 | -108.26390220000002 | 2021-09-15 03:22:37 | Montrose, Colorado, US | |
3448859 | 3448859 | 2021-09-10 | Japan | Kagawa | 4553 | 34 | 0 | 34.217292 | 133.969047 | 2021-09-11 04:21:30 | Kagawa, Japan | |||
513899 | 513899 | 2021-08-19 | US | New Mexico | Otero | 35035 | 4553 | 89 | 0 | 32.61348406 | -105.7417604 | 2021-08-20 04:21:33 | Otero, New Mexico, US | |
2521641 | 2521641 | 2021-08-18 | US | Washington | Whitman | 53075 | 4553 | 54 | 0 | 46.90022523 | -117.52417630000001 | 2021-08-19 04:21:15 | Whitman, Washington, US | |
247195 | 247195 | 2021-08-17 | US | Missouri | Marion | 29127 | 4553 | 56 | 0 | 39.80601912 | -91.62203062 | 2021-08-18 04:21:35 | Marion, Missouri, US | |
3684474 | 3684474 | 2021-08-02 | US | Illinois | Monroe | 17133 | 4553 | 94 | 0 | 38.27594376 | -90.17761038 | 2021-08-03 04:21:39 | Monroe, Illinois, US | |
3015811 | 3015811 | 2021-08-01 | US | Arkansas | Baxter | 5005 | 4553 | 120 | 0 | 36.28784385 | -92.33782872 | 2021-08-02 04:21:36 | Baxter, Arkansas, US | |
410535 | 410535 | 2021-07-28 | US | New York | Livingston | 36051 | 4553 | 60 | 0 | 42.72596275 | -77.77966158 | 2021-07-29 04:21:33 | Livingston, New York, US | |
1308396 | 1308396 | 2021-07-27 | US | New York | Livingston | 36051 | 4553 | 60 | 0 | 42.72596275 | -77.77966158 | 2021-07-28 04:21:39 | Livingston, New York, US | |
1894125 | 1894125 | 2021-06-30 | US | Illinois | Franklin | 17055 | 4553 | 78 | 0 | 37.99189086 | -88.92567818 | 2021-07-01 04:21:19 | Franklin, Illinois, US | |
401248 | 401248 | 2021-06-29 | US | Illinois | Franklin | 17055 | 4553 | 78 | 0 | 37.99189086 | -88.92567818 | 2021-06-30 04:21:41 | Franklin, Illinois, US | |
3959052 | 3959052 | 2021-06-26 | US | California | Humboldt | 6023 | 4553 | 49 | 0 | 40.69923009 | -123.876044 | 2021-06-27 04:21:39 | Humboldt, California, US | |
2911450 | 2911450 | 2021-06-17 | Sierra Leone | 4553 | 82 | 3208 | 1263 | 8.460555000000001 | -11.779889 | 2021-06-18 04:22:16 | Sierra Leone | |||
3147820 | 3147820 | 2021-06-07 | US | New York | Madison | 36053 | 4553 | 89 | 0 | 42.91653905 | -75.67266639 | 2021-06-08 04:22:35 | Madison, New York, US | |
827822 | 827822 | 2021-06-06 | US | New York | Madison | 36053 | 4553 | 89 | 0 | 42.91653905 | -75.67266639 | 2021-06-07 04:22:51 | Madison, New York, US | |
1711618 | 1711618 | 2021-06-02 | US | Virginia | Campbell | 51031 | 4553 | 87 | 0 | 37.20553386 | -79.09678609 | 2021-06-03 04:23:32 | Campbell, Virginia, US | |
54098 | 54098 | 2021-05-29 | US | Virginia | Campbell | 51031 | 4553 | 89 | 0 | 37.20553386 | -79.09678609 | 2021-05-30 04:20:55 | Campbell, Virginia, US | |
53265 | 53265 | 2021-05-29 | US | Ohio | Knox | 39083 | 4553 | 113 | 0 | 40.39830217 | -82.42027563 | 2021-05-30 04:20:55 | Knox, Ohio, US | |
21114 | 21114 | 2021-05-28 | US | Georgia | Baldwin | 13009 | 4553 | 132 | 0 | 33.06882326 | -83.24701748 | 2021-05-29 04:20:41 | Baldwin, Georgia, US | |
1913632 | 1913632 | 2021-05-20 | US | Alaska | Kenai Peninsula | 2122 | 4553 | 22 | 0 | 60.24429722 | -151.53888840000005 | 2021-05-21 04:20:43 | Kenai Peninsula, Alaska, US | |
2005839 | 2005839 | 2021-05-12 | US | Iowa | Des Moines | 19057 | 4553 | 66 | 0 | 40.92012606 | -91.18326592 | 2021-05-13 04:20:51 | Des Moines, Iowa, US | |
2764237 | 2764237 | 2021-05-03 | US | Virginia | Culpeper | 51047 | 4553 | 61 | 0 | 38.48199985 | -77.95630870000002 | 2021-05-04 04:20:34 | Culpeper, Virginia, US | |
2762332 | 2762332 | 2021-05-03 | US | Kentucky | Jessamine | 21113 | 4553 | 64 | 0 | 37.87119786 | -84.58252003 | 2021-05-04 04:20:34 | Jessamine, Kentucky, US | |
1571434 | 1571434 | 2021-04-22 | US | Virginia | Fauquier | 51061 | 4553 | 63 | 0 | 38.73564842 | -77.80647472 | 2021-04-23 04:20:52 | Fauquier, Virginia, US | |
2412306 | 2412306 | 2021-04-19 | US | Kentucky | Shelby | 21211 | 4553 | 70 | 0 | 38.21476019 | -85.194223 | 2021-04-20 04:20:41 | Shelby, Kentucky, US | |
37837 | 37837 | 2021-04-12 | US | Kentucky | Henderson | 21101 | 4553 | 68 | 0 | 37.79344553 | -87.57392021 | 2021-04-13 04:20:37 | Henderson, Kentucky, US | |
1222370 | 1222370 | 2021-03-27 | US | South Carolina | Chesterfield | 45025 | 4553 | 98 | 0 | 34.64137396 | -80.15640140000002 | 2021-03-28 05:28:10 | Chesterfield, South Carolina, US | |
705047 | 705047 | 2021-03-16 | US | Pennsylvania | Bradford | 42015 | 4553 | 79 | 0 | 41.78869215 | -76.51570822 | 2021-03-17 05:25:07 | Bradford, Pennsylvania, US | |
1093238 | 1093238 | 2021-03-03 | US | Texas | Medina | 48325 | 4553 | 97 | 0 | 4531 | 29.3557301 | -99.11030298 | 2021-03-04 05:24:24 | Medina, Texas, US |
744797 | 744797 | 2021-02-20 | US | Ohio | Mercer | 39107 | 4553 | 85 | 0 | 4468 | 40.54043046 | -84.62912742 | 2021-02-21 05:24:33 | Mercer, Ohio, 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]);