johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
193 rows where confirmed = 5032 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3175742 | 3175742 | 2022-12-19 | US | Missouri | Pike | 29163 | 5032 | 65 | 0 | 39.34310674 | -91.16980779 | 2022-12-20 04:21:04 | Pike, Missouri, US | |
1630259 | 1630259 | 2022-12-18 | US | Missouri | Pike | 29163 | 5032 | 65 | 0 | 39.34310674 | -91.16980779 | 2022-12-19 04:21:03 | Pike, Missouri, US | |
505638 | 505638 | 2022-12-17 | US | Missouri | Pike | 29163 | 5032 | 65 | 0 | 39.34310674 | -91.16980779 | 2022-12-18 04:21:03 | Pike, Missouri, US | |
3326210 | 3326210 | 2022-12-16 | US | Missouri | Pike | 29163 | 5032 | 65 | 0 | 39.34310674 | -91.16980779 | 2022-12-17 04:21:04 | Pike, Missouri, US | |
544722 | 544722 | 2022-12-15 | US | Missouri | Pike | 29163 | 5032 | 65 | 0 | 39.34310674 | -91.16980779 | 2022-12-16 04:21:01 | Pike, Missouri, US | |
350250 | 350250 | 2022-12-14 | US | Missouri | Pike | 29163 | 5032 | 65 | 0 | 39.34310674 | -91.16980779 | 2022-12-15 04:20:58 | Pike, Missouri, US | |
309838 | 309838 | 2022-12-13 | US | Missouri | Pike | 29163 | 5032 | 65 | 0 | 39.34310674 | -91.16980779 | 2022-12-14 04:21:04 | Pike, Missouri, US | |
719466 | 719466 | 2022-12-04 | US | Illinois | De Witt | 17039 | 5032 | 41 | 0 | 40.17514519 | -88.90959682 | 2022-12-05 04:20:58 | De Witt, Illinois, US | |
2817755 | 2817755 | 2022-12-03 | US | Illinois | De Witt | 17039 | 5032 | 41 | 0 | 40.17514519 | -88.90959682 | 2022-12-04 04:20:56 | De Witt, Illinois, US | |
834611 | 834611 | 2022-12-02 | US | Illinois | De Witt | 17039 | 5032 | 41 | 0 | 40.17514519 | -88.90959682 | 2022-12-03 04:21:02 | De Witt, Illinois, US | |
1241475 | 1241475 | 2022-11-28 | US | Mississippi | Holmes | 28051 | 5032 | 105 | 0 | 33.12345854 | -90.08923538 | 2022-11-29 04:21:05 | Holmes, Mississippi, US | |
292980 | 292980 | 2022-11-15 | US | Illinois | Bond | 17005 | 5032 | 31 | 0 | 38.88829622 | -89.43534887 | 2022-11-16 04:21:09 | Bond, Illinois, US | |
3598010 | 3598010 | 2022-11-14 | US | Illinois | Bond | 17005 | 5032 | 31 | 0 | 38.88829622 | -89.43534887 | 2022-11-15 04:21:16 | Bond, Illinois, US | |
1251794 | 1251794 | 2022-08-23 | US | Illinois | Piatt | 17147 | 5032 | 23 | 0 | 40.01360584 | -88.59319339 | 2022-08-24 04:20:46 | Piatt, Illinois, US | |
2854373 | 2854373 | 2022-08-22 | US | Louisiana | Jackson | 22049 | 5032 | 77 | 0 | 32.30251776 | -92.55692092 | 2022-08-23 04:20:56 | Jackson, Louisiana, US | |
2404259 | 2404259 | 2022-08-21 | US | Kentucky | Knott | 21119 | 5032 | 67 | 0 | 37.35388197 | -82.94981134 | 2022-08-22 04:20:38 | Knott, Kentucky, US | |
3799337 | 3799337 | 2022-08-20 | US | Kentucky | Knott | 21119 | 5032 | 67 | 0 | 37.35388197 | -82.94981134 | 2022-08-21 04:20:44 | Knott, Kentucky, US | |
2364923 | 2364923 | 2022-08-19 | US | Kentucky | Knott | 21119 | 5032 | 67 | 0 | 37.35388197 | -82.94981134 | 2022-08-20 04:21:01 | Knott, Kentucky, US | |
1162594 | 1162594 | 2022-08-18 | US | Kentucky | Knott | 21119 | 5032 | 67 | 0 | 37.35388197 | -82.94981134 | 2022-08-19 04:20:54 | Knott, Kentucky, US | |
3951918 | 3951918 | 2022-08-17 | US | Kentucky | Knott | 21119 | 5032 | 67 | 0 | 37.35388197 | -82.94981134 | 2022-08-18 04:21:11 | Knott, Kentucky, US | |
992420 | 992420 | 2022-08-16 | US | Kentucky | Knott | 21119 | 5032 | 67 | 0 | 37.35388197 | -82.94981134 | 2022-08-17 04:20:59 | Knott, Kentucky, US | |
2495459 | 2495459 | 2022-08-15 | US | Kentucky | Knott | 21119 | 5032 | 67 | 0 | 37.35388197 | -82.94981134 | 2022-08-16 04:20:58 | Knott, Kentucky, US | |
3909980 | 3909980 | 2022-08-11 | US | Missouri | Texas | 29215 | 5032 | 107 | 0 | 37.31728859 | -91.96564727 | 2022-08-12 04:20:54 | Texas, Missouri, US | |
1348297 | 1348297 | 2022-08-10 | US | Missouri | Texas | 29215 | 5032 | 107 | 0 | 37.31728859 | -91.96564727 | 2022-08-11 04:20:49 | Texas, Missouri, US | |
1088052 | 1088052 | 2022-08-09 | US | Missouri | Texas | 29215 | 5032 | 107 | 0 | 37.31728859 | -91.96564727 | 2022-08-10 04:20:57 | Texas, Missouri, US | |
3545467 | 3545467 | 2022-08-08 | US | Missouri | Texas | 29215 | 5032 | 107 | 0 | 37.31728859 | -91.96564727 | 2022-08-09 04:20:34 | Texas, Missouri, US | |
1071870 | 1071870 | 2022-08-07 | US | Missouri | Texas | 29215 | 5032 | 107 | 0 | 37.31728859 | -91.96564727 | 2022-08-08 04:21:08 | Texas, Missouri, US | |
1942458 | 1942458 | 2022-08-06 | US | Missouri | Texas | 29215 | 5032 | 107 | 0 | 37.31728859 | -91.96564727 | 2022-08-07 04:20:54 | Texas, Missouri, US | |
882257 | 882257 | 2022-08-05 | US | Missouri | Texas | 29215 | 5032 | 107 | 0 | 37.31728859 | -91.96564727 | 2022-08-06 04:20:56 | Texas, Missouri, US | |
961982 | 961982 | 2022-07-19 | US | Texas | Fayette | 48149 | 5032 | 109 | 0 | 29.87788372 | -96.92076062 | 2022-07-20 04:20:59 | Fayette, Texas, US | |
1417604 | 1417604 | 2022-07-08 | US | Arkansas | Phillips | 5107 | 5032 | 99 | 0 | 34.43268455 | -90.84800154 | 2022-07-09 04:20:59 | Phillips, Arkansas, US | |
3968881 | 3968881 | 2022-07-05 | US | North Carolina | Hertford | 37091 | 5032 | 88 | 0 | 36.3607755 | -76.98104134 | 2022-07-06 04:20:58 | Hertford, North Carolina, US | |
3080392 | 3080392 | 2022-07-04 | US | North Carolina | Hertford | 37091 | 5032 | 88 | 0 | 36.3607755 | -76.98104134 | 2022-07-05 04:20:45 | Hertford, North Carolina, US | |
1769674 | 1769674 | 2022-07-03 | US | North Carolina | Hertford | 37091 | 5032 | 88 | 0 | 36.3607755 | -76.98104134 | 2022-07-04 04:20:54 | Hertford, North Carolina, US | |
3367660 | 3367660 | 2022-07-02 | US | North Carolina | Hertford | 37091 | 5032 | 88 | 0 | 36.3607755 | -76.98104134 | 2022-07-03 04:20:59 | Hertford, North Carolina, US | |
3365930 | 3365930 | 2022-07-02 | US | Colorado | Alamosa | 8003 | 5032 | 62 | 0 | 37.57250606 | -105.7885451 | 2022-07-03 04:20:59 | Alamosa, Colorado, US | |
595989 | 595989 | 2022-07-01 | US | North Carolina | Hertford | 37091 | 5032 | 88 | 0 | 36.3607755 | -76.98104134 | 2022-07-02 04:21:16 | Hertford, North Carolina, US | |
3942826 | 3942826 | 2022-06-30 | US | Puerto Rico | Naguabo | 72103 | 5032 | 0 | 0 | 18.230637 | -65.753897 | 2022-07-01 04:21:10 | Naguabo, Puerto Rico, US | |
3942390 | 3942390 | 2022-06-30 | US | North Carolina | Hertford | 37091 | 5032 | 88 | 0 | 36.3607755 | -76.98104134 | 2022-07-01 04:21:10 | Hertford, North Carolina, US | |
2492348 | 2492348 | 2022-06-29 | US | North Carolina | Hertford | 37091 | 5032 | 88 | 0 | 36.3607755 | -76.98104134 | 2022-06-30 04:21:01 | Hertford, North Carolina, US | |
3897687 | 3897687 | 2022-05-19 | US | Minnesota | Hubbard | 27057 | 5032 | 59 | 0 | 47.10778564 | -94.91693868 | 2022-05-20 04:20:57 | Hubbard, Minnesota, US | |
3583575 | 3583575 | 2022-05-17 | US | Idaho | Cassia | 16031 | 5032 | 52 | 0 | 42.28347888 | -113.6012409 | 2022-05-18 04:20:50 | Cassia, Idaho, US | |
1504532 | 1504532 | 2022-05-16 | US | Idaho | Cassia | 16031 | 5032 | 52 | 0 | 42.28347888 | -113.6012409 | 2022-05-17 04:20:59 | Cassia, Idaho, US | |
2084891 | 2084891 | 2022-05-15 | US | Idaho | Cassia | 16031 | 5032 | 52 | 0 | 42.28347888 | -113.6012409 | 2022-05-16 04:20:47 | Cassia, Idaho, US | |
3355601 | 3355601 | 2022-05-14 | US | Idaho | Cassia | 16031 | 5032 | 52 | 0 | 42.28347888 | -113.6012409 | 2022-05-15 04:20:53 | Cassia, Idaho, US | |
659246 | 659246 | 2022-05-13 | US | Idaho | Cassia | 16031 | 5032 | 52 | 0 | 42.28347888 | -113.6012409 | 2022-05-14 04:20:48 | Cassia, Idaho, US | |
2534329 | 2534329 | 2022-05-12 | US | Idaho | Cassia | 16031 | 5032 | 52 | 0 | 42.28347888 | -113.6012409 | 2022-05-13 04:20:51 | Cassia, Idaho, US | |
3445775 | 3445775 | 2022-05-11 | US | Idaho | Cassia | 16031 | 5032 | 52 | 0 | 42.28347888 | -113.6012409 | 2022-05-12 04:20:54 | Cassia, Idaho, US | |
2332312 | 2332312 | 2022-05-08 | US | Idaho | Cassia | 16031 | 5032 | 52 | 0 | 42.28347888 | -113.6012409 | 2022-05-09 04:20:54 | Cassia, Idaho, US | |
361274 | 361274 | 2022-05-07 | US | Idaho | Cassia | 16031 | 5032 | 52 | 0 | 42.28347888 | -113.6012409 | 2022-05-08 04:20:49 | Cassia, Idaho, US | |
1398625 | 1398625 | 2022-05-06 | US | Idaho | Cassia | 16031 | 5032 | 52 | 0 | 42.28347888 | -113.6012409 | 2022-05-07 04:21:09 | Cassia, Idaho, US | |
2599995 | 2599995 | 2022-05-05 | US | Missouri | Perry | 29157 | 5032 | 46 | 0 | 37.70660776 | -89.82741088 | 2022-05-06 04:21:00 | Perry, Missouri, US | |
2598980 | 2598980 | 2022-05-05 | US | Idaho | Cassia | 16031 | 5032 | 52 | 0 | 42.28347888 | -113.6012409 | 2022-05-06 04:21:00 | Cassia, Idaho, US | |
3267444 | 3267444 | 2022-05-04 | US | Missouri | Perry | 29157 | 5032 | 46 | 0 | 37.70660776 | -89.82741088 | 2022-05-05 04:20:55 | Perry, Missouri, US | |
3266429 | 3266429 | 2022-05-04 | US | Idaho | Cassia | 16031 | 5032 | 52 | 0 | 42.28347888 | -113.6012409 | 2022-05-05 04:20:55 | Cassia, Idaho, US | |
1574083 | 1574083 | 2022-05-03 | US | Missouri | Perry | 29157 | 5032 | 46 | 0 | 37.70660776 | -89.82741088 | 2022-05-04 04:20:59 | Perry, Missouri, US | |
465515 | 465515 | 2022-05-02 | US | Nebraska | Saunders | 31155 | 5032 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-05-03 04:21:00 | Saunders, Nebraska, US | |
465343 | 465343 | 2022-05-02 | US | Missouri | Perry | 29157 | 5032 | 46 | 0 | 37.70660776 | -89.82741088 | 2022-05-03 04:21:00 | Perry, Missouri, US | |
3918154 | 3918154 | 2022-05-01 | US | Nebraska | Saunders | 31155 | 5032 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-05-02 04:21:10 | Saunders, Nebraska, US | |
3917982 | 3917982 | 2022-05-01 | US | Missouri | Perry | 29157 | 5032 | 46 | 0 | 37.70660776 | -89.82741088 | 2022-05-02 04:21:10 | Perry, Missouri, US | |
2842958 | 2842958 | 2022-04-30 | US | Nebraska | Saunders | 31155 | 5032 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-05-01 04:20:57 | Saunders, Nebraska, US | |
2842786 | 2842786 | 2022-04-30 | US | Missouri | Perry | 29157 | 5032 | 46 | 0 | 37.70660776 | -89.82741088 | 2022-05-01 04:20:57 | Perry, Missouri, US | |
1159099 | 1159099 | 2022-04-29 | US | Missouri | Perry | 29157 | 5032 | 46 | 0 | 37.70660776 | -89.82741088 | 2022-04-30 04:21:05 | Perry, Missouri, US | |
1699077 | 1699077 | 2022-04-28 | US | Puerto Rico | Guayama | 72057 | 5032 | 0 | 0 | 18.007516 | -66.133908 | 2022-04-29 04:20:59 | Guayama, Puerto Rico, US | |
1698281 | 1698281 | 2022-04-28 | US | Missouri | Perry | 29157 | 5032 | 46 | 0 | 37.70660776 | -89.82741088 | 2022-04-29 04:20:59 | Perry, Missouri, US | |
1327078 | 1327078 | 2022-04-26 | US | Georgia | Jones | 13169 | 5032 | 108 | 0 | 33.02512137 | -83.56019163 | 2022-04-27 04:20:52 | Jones, Georgia, US | |
3723032 | 3723032 | 2022-04-25 | US | Georgia | Jones | 13169 | 5032 | 108 | 0 | 33.02512137 | -83.56019163 | 2022-04-26 04:20:51 | Jones, Georgia, US | |
2029600 | 2029600 | 2022-04-24 | US | Georgia | Jones | 13169 | 5032 | 108 | 0 | 33.02512137 | -83.56019163 | 2022-04-25 04:20:56 | Jones, Georgia, US | |
747175 | 747175 | 2022-04-23 | US | Georgia | Jones | 13169 | 5032 | 108 | 0 | 33.02512137 | -83.56019163 | 2022-04-24 04:20:56 | Jones, Georgia, US | |
3437660 | 3437660 | 2022-04-22 | US | Georgia | Jones | 13169 | 5032 | 108 | 0 | 33.02512137 | -83.56019163 | 2022-04-23 04:20:50 | Jones, Georgia, US | |
2893245 | 2893245 | 2022-04-21 | US | Georgia | Jones | 13169 | 5032 | 108 | 0 | 33.02512137 | -83.56019163 | 2022-04-22 04:20:45 | Jones, Georgia, US | |
2308117 | 2308117 | 2022-04-20 | US | Georgia | Jones | 13169 | 5032 | 108 | 0 | 33.02512137 | -83.56019163 | 2022-04-21 04:20:46 | Jones, Georgia, US | |
3418043 | 3418043 | 2022-04-17 | US | Indiana | Orange | 18117 | 5032 | 96 | 0 | 38.54118920000001 | -86.49523093 | 2022-04-18 04:21:12 | Orange, Indiana, US | |
304992 | 304992 | 2022-04-16 | US | Indiana | Orange | 18117 | 5032 | 96 | 0 | 38.54118920000001 | -86.49523093 | 2022-04-17 04:20:59 | Orange, Indiana, US | |
2670937 | 2670937 | 2022-04-15 | US | Indiana | Orange | 18117 | 5032 | 96 | 0 | 38.54118920000001 | -86.49523093 | 2022-04-16 04:20:48 | Orange, Indiana, US | |
1224722 | 1224722 | 2022-04-14 | US | Indiana | Orange | 18117 | 5032 | 96 | 0 | 38.54118920000001 | -86.49523093 | 2022-04-15 04:20:57 | Orange, Indiana, US | |
2443880 | 2443880 | 2022-04-13 | US | Indiana | Orange | 18117 | 5032 | 96 | 0 | 38.54118920000001 | -86.49523093 | 2022-04-13 23:21:06 | Orange, Indiana, US | |
1949637 | 1949637 | 2022-04-12 | US | Indiana | Orange | 18117 | 5032 | 96 | 0 | 38.54118920000001 | -86.49523093 | 2022-04-13 04:21:03 | Orange, Indiana, US | |
3207390 | 3207390 | 2022-04-11 | US | Indiana | Orange | 18117 | 5032 | 96 | 0 | 38.54118920000001 | -86.49523093 | 2022-04-12 04:20:49 | Orange, Indiana, US | |
159577 | 159577 | 2022-03-29 | US | Maine | Sagadahoc | 23023 | 5032 | 29 | 0 | 43.95415864 | -69.85074999 | 2022-03-30 04:20:45 | Sagadahoc, Maine, US | |
158856 | 158856 | 2022-03-29 | US | Georgia | McDuffie | 13189 | 5032 | 93 | 0 | 33.47851918 | -82.48252774 | 2022-03-30 04:20:45 | McDuffie, Georgia, US | |
3239259 | 3239259 | 2022-03-21 | US | Idaho | Cassia | 16031 | 5032 | 52 | 0 | 42.28347888 | -113.6012409 | 2022-03-22 04:20:54 | Cassia, Idaho, US | |
1647074 | 1647074 | 2022-03-03 | US | Pennsylvania | Wyoming | 42131 | 5032 | 100 | 0 | 41.51955538 | -76.01074915 | 2022-03-04 04:21:09 | Wyoming, Pennsylvania, US | |
943337 | 943337 | 2022-02-28 | US | Arkansas | Logan | 5083 | 5032 | 69 | 0 | 35.21413234 | -93.71951016 | 2022-03-01 04:21:09 | Logan, Arkansas, US | |
2736574 | 2736574 | 2022-02-27 | US | Wisconsin | Green Lake | 55047 | 5032 | 58 | 0 | 43.80025981 | -89.04679553 | 2022-02-28 04:21:05 | Green Lake, Wisconsin, US | |
3049727 | 3049727 | 2022-02-26 | US | Wisconsin | Green Lake | 55047 | 5032 | 58 | 0 | 43.80025981 | -89.04679553 | 2022-02-27 04:21:04 | Green Lake, Wisconsin, US | |
578382 | 578382 | 2022-02-25 | US | Wisconsin | Green Lake | 55047 | 5032 | 58 | 0 | 43.80025981 | -89.04679553 | 2022-02-26 04:21:12 | Green Lake, Wisconsin, US | |
1514958 | 1514958 | 2022-02-24 | US | Wisconsin | Green Lake | 55047 | 5032 | 58 | 0 | 43.80025981 | -89.04679553 | 2022-02-25 04:21:11 | Green Lake, Wisconsin, US | |
1514698 | 1514698 | 2022-02-24 | US | Vermont | Orleans | 50019 | 5032 | 33 | 0 | 44.82964024 | -72.24562697 | 2022-02-25 04:21:11 | Orleans, Vermont, US | |
1511759 | 1511759 | 2022-02-24 | US | Alabama | Butler | 1013 | 5032 | 116 | 0 | 31.75300095 | -86.68057478 | 2022-02-25 04:21:11 | Butler, Alabama, US | |
3875978 | 3875978 | 2022-02-19 | US | Alabama | Randolph | 1111 | 5032 | 72 | 0 | 33.29526734 | -85.45708831 | 2022-02-20 04:21:00 | Randolph, Alabama, US | |
1299377 | 1299377 | 2022-02-17 | US | Kansas | Neosho | 20133 | 5032 | 62 | 0 | 37.55862897 | -95.30670046 | 2022-02-18 04:21:04 | Neosho, Kansas, US | |
1298854 | 1298854 | 2022-02-17 | US | Georgia | Fannin | 13111 | 5032 | 134 | 0 | 34.86430205 | -84.316964 | 2022-02-18 04:21:04 | Fannin, Georgia, US | |
1298406 | 1298406 | 2022-02-17 | US | Alabama | Cherokee | 1019 | 5032 | 77 | 0 | 34.17805983 | -85.60638968 | 2022-02-18 04:21:04 | Cherokee, Alabama, US | |
3821763 | 3821763 | 2022-02-16 | US | Kansas | Neosho | 20133 | 5032 | 62 | 0 | 37.55862897 | -95.30670046 | 2022-02-17 04:20:56 | Neosho, Kansas, US | |
318394 | 318394 | 2022-02-12 | US | Ohio | Holmes | 39075 | 5032 | 180 | 0 | 40.56163713 | -81.92635677 | 2022-02-13 04:21:00 | Holmes, Ohio, US | |
1363718 | 1363718 | 2022-02-08 | US | Kentucky | Adair | 21001 | 5032 | 95 | 0 | 37.10459774 | -85.28129668 | 2022-02-09 04:21:04 | Adair, Kentucky, US | |
2330460 | 2330460 | 2022-02-04 | US | Texas | Gillespie | 48171 | 5032 | 97 | 0 | 30.31824095 | -98.94676915 | 2022-02-05 04:21:05 | Gillespie, Texas, US | |
99353 | 99353 | 2022-01-14 | Japan | Toyama | 5032 | 52 | 0 | 36.637464 | 137.26934599999998 | 2022-01-15 04:21:07 | Toyama, Japan | |||
3520537 | 3520537 | 2022-01-02 | US | Indiana | Jennings | 18079 | 5032 | 70 | 0 | 38.99588883 | -85.62710784 | 2022-01-03 02:22:25 | Jennings, Indiana, 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]);