johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
165 rows where confirmed = 5272 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3327178 | 3327178 | 2022-12-16 | US | Tennessee | Bledsoe | 47007 | 5272 | 63 | 0 | 35.59942968 | -85.20611967 | 2022-12-17 04:21:04 | Bledsoe, Tennessee, US | |
351070 | 351070 | 2022-12-14 | US | Puerto Rico | Patillas | 72109 | 5272 | 0 | 0 | 18.03174 | -66.012242 | 2022-12-15 04:20:58 | Patillas, Puerto Rico, US | |
711362 | 711362 | 2022-11-01 | US | Georgia | Worth | 13321 | 5272 | 124 | 0 | 31.55162306 | -83.85090513 | 2022-11-02 04:22:09 | Worth, Georgia, US | |
3285811 | 3285811 | 2022-10-31 | US | Georgia | Worth | 13321 | 5272 | 124 | 0 | 31.55162306 | -83.85090513 | 2022-11-01 04:22:36 | Worth, Georgia, US | |
320844 | 320844 | 2022-10-30 | US | Georgia | Worth | 13321 | 5272 | 124 | 0 | 31.55162306 | -83.85090513 | 2022-10-31 04:21:36 | Worth, Georgia, US | |
913120 | 913120 | 2022-10-29 | US | Georgia | Worth | 13321 | 5272 | 124 | 0 | 31.55162306 | -83.85090513 | 2022-10-30 04:22:14 | Worth, Georgia, US | |
1367389 | 1367389 | 2022-10-28 | US | Georgia | Worth | 13321 | 5272 | 124 | 0 | 31.55162306 | -83.85090513 | 2022-10-29 04:21:13 | Worth, Georgia, US | |
3041253 | 3041253 | 2022-10-27 | US | Tennessee | Benton | 47005 | 5272 | 101 | 0 | 36.07110411 | -88.06849355 | 2022-10-28 04:22:31 | Benton, Tennessee, US | |
3039244 | 3039244 | 2022-10-27 | US | Georgia | Worth | 13321 | 5272 | 124 | 0 | 31.55162306 | -83.85090513 | 2022-10-28 04:22:31 | Worth, Georgia, US | |
539664 | 539664 | 2022-10-26 | US | Georgia | Worth | 13321 | 5272 | 124 | 0 | 31.55162306 | -83.85090513 | 2022-10-27 04:22:01 | Worth, Georgia, US | |
3280067 | 3280067 | 2022-10-23 | US | Texas | Panola | 48365 | 5272 | 133 | 0 | 32.1639596 | -94.30552481 | 2022-10-24 04:22:29 | Panola, Texas, US | |
2271105 | 2271105 | 2022-10-22 | US | Texas | Panola | 48365 | 5272 | 133 | 0 | 32.1639596 | -94.30552481 | 2022-10-23 04:22:46 | Panola, Texas, US | |
1595405 | 1595405 | 2022-10-21 | US | Texas | Panola | 48365 | 5272 | 133 | 0 | 32.1639596 | -94.30552481 | 2022-10-22 04:22:53 | Panola, Texas, US | |
1811749 | 1811749 | 2022-10-05 | US | Illinois | Cass | 17017 | 5272 | 37 | 0 | 39.96991073 | -90.24734436 | 2022-10-06 04:21:22 | Cass, Illinois, US | |
2687384 | 2687384 | 2022-10-03 | US | Michigan | Roscommon | 26143 | 5272 | 122 | 0 | 44.33473082 | -84.61067651 | 2022-10-04 04:22:55 | Roscommon, Michigan, US | |
2261451 | 2261451 | 2022-10-02 | US | Michigan | Roscommon | 26143 | 5272 | 122 | 0 | 44.33473082 | -84.61067651 | 2022-10-03 04:23:11 | Roscommon, Michigan, US | |
2996977 | 2996977 | 2022-10-01 | US | Michigan | Roscommon | 26143 | 5272 | 122 | 0 | 44.33473082 | -84.61067651 | 2022-10-02 04:21:23 | Roscommon, Michigan, US | |
855303 | 855303 | 2022-09-30 | US | Michigan | Roscommon | 26143 | 5272 | 122 | 0 | 44.33473082 | -84.61067651 | 2022-10-01 04:23:01 | Roscommon, Michigan, US | |
2377229 | 2377229 | 2022-09-29 | US | Michigan | Roscommon | 26143 | 5272 | 122 | 0 | 44.33473082 | -84.61067651 | 2022-09-30 04:23:09 | Roscommon, Michigan, US | |
1561780 | 1561780 | 2022-09-28 | US | Michigan | Roscommon | 26143 | 5272 | 122 | 0 | 44.33473082 | -84.61067651 | 2022-09-29 04:22:34 | Roscommon, Michigan, US | |
3996323 | 3996323 | 2022-09-27 | US | Michigan | Roscommon | 26143 | 5272 | 122 | 0 | 44.33473082 | -84.61067651 | 2022-09-28 04:23:01 | Roscommon, Michigan, US | |
3570406 | 3570406 | 2022-09-19 | China | Sichuan | 5272 | 3 | 0 | 30.6171 | 102.7103 | 2022-09-20 04:22:48 | Sichuan, China | |||
374879 | 374879 | 2022-09-13 | US | Pennsylvania | Juniata | 42067 | 5272 | 183 | 0 | 40.53358749 | -77.3997513 | 2022-09-14 04:20:44 | Juniata, Pennsylvania, US | |
2397481 | 2397481 | 2022-09-12 | US | Pennsylvania | Juniata | 42067 | 5272 | 183 | 0 | 40.53358749 | -77.3997513 | 2022-09-13 04:20:57 | Juniata, Pennsylvania, US | |
3768559 | 3768559 | 2022-09-11 | US | Pennsylvania | Juniata | 42067 | 5272 | 183 | 0 | 40.53358749 | -77.3997513 | 2022-09-12 04:20:58 | Juniata, Pennsylvania, US | |
3827134 | 3827134 | 2022-09-10 | US | Pennsylvania | Juniata | 42067 | 5272 | 183 | 0 | 40.53358749 | -77.3997513 | 2022-09-11 04:20:50 | Juniata, Pennsylvania, US | |
965591 | 965591 | 2022-09-09 | US | Pennsylvania | Juniata | 42067 | 5272 | 183 | 0 | 40.53358749 | -77.3997513 | 2022-09-10 04:21:10 | Juniata, Pennsylvania, US | |
255993 | 255993 | 2022-09-08 | US | Pennsylvania | Juniata | 42067 | 5272 | 183 | 0 | 40.53358749 | -77.3997513 | 2022-09-09 04:21:11 | Juniata, Pennsylvania, US | |
3747791 | 3747791 | 2022-09-07 | US | Pennsylvania | Juniata | 42067 | 5272 | 183 | 0 | 40.53358749 | -77.3997513 | 2022-09-08 04:21:02 | Juniata, Pennsylvania, US | |
2096643 | 2096643 | 2022-08-27 | US | Arkansas | Sharp | 5135 | 5272 | 113 | 0 | 36.16258158 | -91.47819342 | 2022-08-28 04:21:02 | Sharp, Arkansas, US | |
2832343 | 2832343 | 2022-08-25 | US | Wisconsin | Adams | 55001 | 5272 | 65 | 0 | 43.96974651 | -89.76782777 | 2022-08-26 04:21:02 | Adams, Wisconsin, US | |
1162259 | 1162259 | 2022-08-18 | US | Indiana | Fulton | 18049 | 5272 | 109 | 0 | 41.0469907 | -86.26252745 | 2022-08-19 04:20:54 | Fulton, Indiana, US | |
3953564 | 3953564 | 2022-08-17 | US | Texas | Deaf Smith | 48117 | 5272 | 115 | 0 | 34.96522957 | -102.6054267 | 2022-08-18 04:21:11 | Deaf Smith, Texas, US | |
3951583 | 3951583 | 2022-08-17 | US | Indiana | Fulton | 18049 | 5272 | 109 | 0 | 41.0469907 | -86.26252745 | 2022-08-18 04:21:11 | Fulton, Indiana, US | |
1969142 | 1969142 | 2022-08-13 | US | California | Inyo | 6027 | 5272 | 58 | 0 | 36.51112084 | -117.4111978 | 2022-08-14 04:20:55 | Inyo, California, US | |
3911587 | 3911587 | 2022-08-11 | US | Wisconsin | Sawyer | 55113 | 5272 | 63 | 0 | 45.87931905 | -91.14504927 | 2022-08-12 04:20:54 | Sawyer, Wisconsin, US | |
1101499 | 1101499 | 2022-08-03 | US | Virginia | New Kent | 51127 | 5272 | 38 | 0 | 37.50694406 | -76.99828634 | 2022-08-04 04:20:58 | New Kent, Virginia, US | |
1099092 | 1099092 | 2022-08-03 | US | Illinois | Clark | 17023 | 5272 | 52 | 0 | 39.33425789 | -87.78705622 | 2022-08-04 04:20:58 | Clark, Illinois, US | |
903341 | 903341 | 2022-07-22 | US | Texas | Milam | 48331 | 5272 | 103 | 0 | 30.7858183 | -96.97718698 | 2022-07-23 04:20:53 | Milam, Texas, US | |
630753 | 630753 | 2022-07-12 | US | Georgia | McDuffie | 13189 | 5272 | 103 | 0 | 33.47851918 | -82.48252774 | 2022-07-13 04:20:58 | McDuffie, Georgia, US | |
1212397 | 1212397 | 2022-07-11 | US | Georgia | McDuffie | 13189 | 5272 | 103 | 0 | 33.47851918 | -82.48252774 | 2022-07-12 04:20:51 | McDuffie, Georgia, US | |
2789879 | 2789879 | 2022-07-10 | US | Georgia | McDuffie | 13189 | 5272 | 103 | 0 | 33.47851918 | -82.48252774 | 2022-07-11 04:20:46 | McDuffie, Georgia, US | |
142832 | 142832 | 2022-07-09 | US | Georgia | McDuffie | 13189 | 5272 | 103 | 0 | 33.47851918 | -82.48252774 | 2022-07-10 04:20:54 | McDuffie, Georgia, US | |
1417932 | 1417932 | 2022-07-08 | US | Georgia | McDuffie | 13189 | 5272 | 103 | 0 | 33.47851918 | -82.48252774 | 2022-07-09 04:20:59 | McDuffie, Georgia, US | |
1417592 | 1417592 | 2022-07-08 | US | Arkansas | Logan | 5083 | 5272 | 79 | 0 | 35.21413234 | -93.71951016 | 2022-07-09 04:20:59 | Logan, Arkansas, US | |
2741857 | 2741857 | 2022-07-07 | US | Georgia | McDuffie | 13189 | 5272 | 103 | 0 | 33.47851918 | -82.48252774 | 2022-07-08 04:20:56 | McDuffie, Georgia, US | |
1200652 | 1200652 | 2022-07-06 | US | Georgia | McDuffie | 13189 | 5272 | 103 | 0 | 33.47851918 | -82.48252774 | 2022-07-07 04:20:55 | McDuffie, Georgia, US | |
2240192 | 2240192 | 2022-06-28 | US | Georgia | Dodge | 13091 | 5272 | 154 | 0 | 32.17265114 | -83.16948926 | 2022-06-29 04:20:59 | Dodge, Georgia, US | |
2148434 | 2148434 | 2022-06-27 | US | Georgia | Dodge | 13091 | 5272 | 154 | 0 | 32.17265114 | -83.16948926 | 2022-06-28 04:20:58 | Dodge, Georgia, US | |
476235 | 476235 | 2022-06-26 | US | Georgia | Dodge | 13091 | 5272 | 154 | 0 | 32.17265114 | -83.16948926 | 2022-06-27 04:21:00 | Dodge, Georgia, US | |
939610 | 939610 | 2022-06-25 | US | Georgia | Dodge | 13091 | 5272 | 154 | 0 | 32.17265114 | -83.16948926 | 2022-06-26 04:21:02 | Dodge, Georgia, US | |
3347430 | 3347430 | 2022-06-24 | US | Georgia | Dodge | 13091 | 5272 | 154 | 0 | 32.17265114 | -83.16948926 | 2022-06-25 04:20:57 | Dodge, Georgia, US | |
1649171 | 1649171 | 2022-06-23 | US | Georgia | Dodge | 13091 | 5272 | 154 | 0 | 32.17265114 | -83.16948926 | 2022-06-24 04:20:58 | Dodge, Georgia, US | |
2188406 | 2188406 | 2022-06-22 | US | Georgia | Dodge | 13091 | 5272 | 154 | 0 | 32.17265114 | -83.16948926 | 2022-06-23 04:20:55 | Dodge, Georgia, US | |
2982733 | 2982733 | 2022-06-13 | US | West Virginia | Brooke | 54009 | 5272 | 104 | 0 | 40.27367263 | -80.57915332 | 2022-06-14 04:20:52 | Brooke, West Virginia, US | |
1111640 | 1111640 | 2022-05-21 | US | Nebraska | Dawson | 31047 | 5272 | 44 | 0 | 40.87028216 | -99.8201461 | 2022-05-22 04:20:52 | Dawson, Nebraska, US | |
1171264 | 1171264 | 2022-05-20 | US | Nebraska | Dawson | 31047 | 5272 | 44 | 0 | 40.87028216 | -99.8201461 | 2022-05-21 04:20:58 | Dawson, Nebraska, US | |
3898027 | 3898027 | 2022-05-19 | US | Nebraska | Dawson | 31047 | 5272 | 44 | 0 | 40.87028216 | -99.8201461 | 2022-05-20 04:20:57 | Dawson, Nebraska, US | |
1186811 | 1186811 | 2022-05-18 | US | Nebraska | Dawson | 31047 | 5272 | 44 | 0 | 40.87028216 | -99.8201461 | 2022-05-19 04:20:54 | Dawson, Nebraska, US | |
3584708 | 3584708 | 2022-05-17 | US | Nebraska | Dawson | 31047 | 5272 | 44 | 0 | 40.87028216 | -99.8201461 | 2022-05-18 04:20:50 | Dawson, Nebraska, US | |
1506994 | 1506994 | 2022-05-16 | US | Virginia | Powhatan | 51145 | 5272 | 59 | 0 | 37.55016038 | -77.91267882 | 2022-05-17 04:20:59 | Powhatan, Virginia, US | |
1505665 | 1505665 | 2022-05-16 | US | Nebraska | Dawson | 31047 | 5272 | 44 | 0 | 40.87028216 | -99.8201461 | 2022-05-17 04:20:59 | Dawson, Nebraska, US | |
2086024 | 2086024 | 2022-05-15 | US | Nebraska | Dawson | 31047 | 5272 | 44 | 0 | 40.87028216 | -99.8201461 | 2022-05-16 04:20:47 | Dawson, Nebraska, US | |
2085412 | 2085412 | 2022-05-15 | US | Kentucky | Morgan | 21175 | 5272 | 28 | 0 | 37.92465657 | -83.25558245 | 2022-05-16 04:20:47 | Morgan, Kentucky, US | |
3356734 | 3356734 | 2022-05-14 | US | Nebraska | Dawson | 31047 | 5272 | 44 | 0 | 40.87028216 | -99.8201461 | 2022-05-15 04:20:53 | Dawson, Nebraska, US | |
3356122 | 3356122 | 2022-05-14 | US | Kentucky | Morgan | 21175 | 5272 | 28 | 0 | 37.92465657 | -83.25558245 | 2022-05-15 04:20:53 | Morgan, Kentucky, US | |
660379 | 660379 | 2022-05-13 | US | Nebraska | Dawson | 31047 | 5272 | 44 | 0 | 40.87028216 | -99.8201461 | 2022-05-14 04:20:48 | Dawson, Nebraska, US | |
659767 | 659767 | 2022-05-13 | US | Kentucky | Morgan | 21175 | 5272 | 28 | 0 | 37.92465657 | -83.25558245 | 2022-05-14 04:20:48 | Morgan, Kentucky, US | |
2535462 | 2535462 | 2022-05-12 | US | Nebraska | Dawson | 31047 | 5272 | 44 | 0 | 40.87028216 | -99.8201461 | 2022-05-13 04:20:51 | Dawson, Nebraska, US | |
2534850 | 2534850 | 2022-05-12 | US | Kentucky | Morgan | 21175 | 5272 | 28 | 0 | 37.92465657 | -83.25558245 | 2022-05-13 04:20:51 | Morgan, Kentucky, US | |
3446908 | 3446908 | 2022-05-11 | US | Nebraska | Dawson | 31047 | 5272 | 44 | 0 | 40.87028216 | -99.8201461 | 2022-05-12 04:20:54 | Dawson, Nebraska, US | |
3446296 | 3446296 | 2022-05-11 | US | Kentucky | Morgan | 21175 | 5272 | 28 | 0 | 37.92465657 | -83.25558245 | 2022-05-12 04:20:54 | Morgan, Kentucky, US | |
3537525 | 3537525 | 2022-05-10 | US | Nebraska | Dawson | 31047 | 5272 | 44 | 0 | 40.87028216 | -99.8201461 | 2022-05-11 04:20:48 | Dawson, Nebraska, US | |
3536913 | 3536913 | 2022-05-10 | US | Kentucky | Morgan | 21175 | 5272 | 28 | 0 | 37.92465657 | -83.25558245 | 2022-05-11 04:20:48 | Morgan, Kentucky, US | |
223448 | 223448 | 2022-05-09 | US | Kentucky | Morgan | 21175 | 5272 | 28 | 0 | 37.92465657 | -83.25558245 | 2022-05-10 04:20:50 | Morgan, Kentucky, US | |
2252189 | 2252189 | 2022-04-19 | US | Georgia | Burke | 13033 | 5272 | 108 | 0 | 33.05917989 | -81.99928721 | 2022-04-20 04:20:45 | Burke, Georgia, US | |
1846739 | 1846739 | 2022-04-18 | US | Georgia | Burke | 13033 | 5272 | 108 | 0 | 33.05917989 | -81.99928721 | 2022-04-19 04:21:00 | Burke, Georgia, US | |
3417683 | 3417683 | 2022-04-17 | US | Georgia | Burke | 13033 | 5272 | 108 | 0 | 33.05917989 | -81.99928721 | 2022-04-18 04:21:12 | Burke, Georgia, US | |
304632 | 304632 | 2022-04-16 | US | Georgia | Burke | 13033 | 5272 | 108 | 0 | 33.05917989 | -81.99928721 | 2022-04-17 04:20:59 | Burke, Georgia, US | |
2670577 | 2670577 | 2022-04-15 | US | Georgia | Burke | 13033 | 5272 | 108 | 0 | 33.05917989 | -81.99928721 | 2022-04-16 04:20:48 | Burke, Georgia, US | |
3629016 | 3629016 | 2022-03-13 | US | Illinois | Wayne | 17191 | 5272 | 82 | 0 | 38.42955355 | -88.42586459 | 2022-03-14 04:20:46 | Wayne, Illinois, US | |
951924 | 951924 | 2022-03-12 | US | Illinois | Wayne | 17191 | 5272 | 82 | 0 | 38.42955355 | -88.42586459 | 2022-03-13 04:20:49 | Wayne, Illinois, US | |
357385 | 357385 | 2022-03-11 | US | Illinois | Wayne | 17191 | 5272 | 82 | 0 | 38.42955355 | -88.42586459 | 2022-03-12 04:20:50 | Wayne, Illinois, US | |
1867694 | 1867694 | 2022-03-10 | US | New Mexico | Taos | 35055 | 5272 | 89 | 0 | 36.58006022 | -105.63101979999999 | 2022-03-11 04:20:50 | Taos, New Mexico, US | |
1995756 | 1995756 | 2022-03-01 | US | Texas | Gillespie | 48171 | 5272 | 105 | 0 | 30.31824095 | -98.94676915 | 2022-03-02 04:21:07 | Gillespie, Texas, US | |
1060580 | 1060580 | 2022-02-23 | US | Puerto Rico | Cayey | 72035 | 5272 | 0 | 0 | 18.102851 | -66.14914 | 2022-02-24 04:21:14 | Cayey, Puerto Rico, US | |
3720916 | 3720916 | 2022-02-21 | US | Puerto Rico | Cayey | 72035 | 5272 | 0 | 0 | 18.102851 | -66.14914 | 2022-02-22 04:21:01 | Cayey, Puerto Rico, US | |
3855860 | 3855860 | 2022-02-18 | Japan | Tottori | 5272 | 8 | 0 | 35.359069 | 133.863619 | 2022-02-19 04:21:11 | Tottori, Japan | |||
1295903 | 1295903 | 2022-02-05 | US | Missouri | Adair | 29001 | 5272 | 58 | 0 | 40.19058551 | -92.60078167 | 2022-02-06 04:21:00 | Adair, Missouri, US | |
462673 | 462673 | 2022-02-02 | US | Vermont | Windham | 50025 | 5272 | 33 | 0 | 42.986982 | -72.71268875 | 2022-02-03 04:21:21 | Windham, Vermont, US | |
3466136 | 3466136 | 2022-01-18 | US | Missouri | Saline | 29195 | 5272 | 90 | 0 | 39.13734288 | -93.20259964 | 2022-01-19 04:21:23 | Saline, Missouri, US | |
1695423 | 1695423 | 2022-01-10 | US | Texas | Hale | 48189 | 5272 | 209 | 0 | 34.07044901 | -101.82681140000001 | 2022-01-11 04:22:01 | Hale, Texas, US | |
1694663 | 1694663 | 2022-01-10 | US | North Carolina | Montgomery | 37123 | 5272 | 111 | 0 | 35.33155144 | -79.90416657 | 2022-01-11 04:22:01 | Montgomery, North Carolina, US | |
1218859 | 1218859 | 2022-01-08 | US | Vermont | Unassigned | 90050 | 5272 | 0 | 0 | 44.85627605 | 0.0 | 2022-01-09 04:21:46 | Unassigned, Vermont, US | |
1288575 | 1288575 | 2022-01-04 | US | Oklahoma | Lincoln | 40081 | 5272 | 118 | 0 | 35.70270942 | -96.8812462 | 2022-01-05 04:21:59 | Lincoln, Oklahoma, US | |
1702919 | 1702919 | 2022-01-03 | US | Oklahoma | Lincoln | 40081 | 5272 | 118 | 0 | 35.70270942 | -96.8812462 | 2022-01-04 04:22:17 | Lincoln, Oklahoma, US | |
3522002 | 3522002 | 2022-01-02 | US | Oklahoma | Lincoln | 40081 | 5272 | 118 | 0 | 35.70270942 | -96.8812462 | 2022-01-03 02:22:25 | Lincoln, Oklahoma, US | |
2170132 | 2170132 | 2022-01-01 | US | Oklahoma | Lincoln | 40081 | 5272 | 118 | 0 | 35.70270942 | -96.8812462 | 2022-01-02 04:20:52 | Lincoln, Oklahoma, US | |
2779563 | 2779563 | 2021-12-31 | US | Oklahoma | Lincoln | 40081 | 5272 | 118 | 0 | 35.70270942 | -96.8812462 | 2022-01-01 04:22:14 | Lincoln, Oklahoma, US | |
4001220 | 4001220 | 2021-12-30 | US | Oklahoma | Lincoln | 40081 | 5272 | 118 | 0 | 35.70270942 | -96.8812462 | 2021-12-31 04:21:50 | Lincoln, Oklahoma, 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]);