johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
138 rows where confirmed = 4981 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
454383 | 454383 | 2022-12-21 | US | Tennessee | Sequatchie | 47153 | 4981 | 72 | 0 | 35.36979721 | -85.41022136 | 2022-12-22 04:20:56 | Sequatchie, Tennessee, US | |
1629740 | 1629740 | 2022-12-18 | US | Kentucky | Leslie | 21131 | 4981 | 57 | 0 | 37.09246661 | -83.37999606 | 2022-12-19 04:21:03 | Leslie, Kentucky, US | |
505119 | 505119 | 2022-12-17 | US | Kentucky | Leslie | 21131 | 4981 | 57 | 0 | 37.09246661 | -83.37999606 | 2022-12-18 04:21:03 | Leslie, Kentucky, US | |
3325691 | 3325691 | 2022-12-16 | US | Kentucky | Leslie | 21131 | 4981 | 57 | 0 | 37.09246661 | -83.37999606 | 2022-12-17 04:21:04 | Leslie, Kentucky, US | |
545505 | 545505 | 2022-12-15 | US | Puerto Rico | Ciales | 72039 | 4981 | 0 | 0 | 18.28885 | -66.516475 | 2022-12-16 04:21:01 | Ciales, Puerto Rico, US | |
544203 | 544203 | 2022-12-15 | US | Kentucky | Leslie | 21131 | 4981 | 57 | 0 | 37.09246661 | -83.37999606 | 2022-12-16 04:21:01 | Leslie, Kentucky, US | |
349731 | 349731 | 2022-12-14 | US | Kentucky | Leslie | 21131 | 4981 | 57 | 0 | 37.09246661 | -83.37999606 | 2022-12-15 04:20:58 | Leslie, Kentucky, US | |
309319 | 309319 | 2022-12-13 | US | Kentucky | Leslie | 21131 | 4981 | 57 | 0 | 37.09246661 | -83.37999606 | 2022-12-14 04:21:04 | Leslie, Kentucky, US | |
1150380 | 1150380 | 2022-12-12 | US | Kentucky | Leslie | 21131 | 4981 | 57 | 0 | 37.09246661 | -83.37999606 | 2022-12-13 04:21:01 | Leslie, Kentucky, US | |
3380724 | 3380724 | 2022-12-08 | US | Virginia | Giles | 51071 | 4981 | 54 | 0 | 37.31234791 | -80.70636931 | 2022-12-09 04:21:05 | Giles, Virginia, US | |
3463668 | 3463668 | 2022-11-21 | US | West Virginia | Morgan | 54065 | 4981 | 76 | 0 | 39.55439028 | -78.26311676 | 2022-11-22 04:20:47 | Morgan, West Virginia, US | |
314826 | 314826 | 2022-11-13 | US | Tennessee | Cannon | 47015 | 4981 | 72 | 0 | 35.80990797 | -86.05738983 | 2022-11-14 04:21:09 | Cannon, Tennessee, US | |
65987 | 65987 | 2022-11-12 | US | Tennessee | Cannon | 47015 | 4981 | 72 | 0 | 35.80990797 | -86.05738983 | 2022-11-13 04:21:14 | Cannon, Tennessee, US | |
2930149 | 2930149 | 2022-11-11 | US | Tennessee | Cannon | 47015 | 4981 | 72 | 0 | 35.80990797 | -86.05738983 | 2022-11-12 04:20:41 | Cannon, Tennessee, US | |
2508985 | 2508985 | 2022-11-10 | US | Tennessee | Cannon | 47015 | 4981 | 72 | 0 | 35.80990797 | -86.05738983 | 2022-11-11 04:21:22 | Cannon, Tennessee, US | |
198906 | 198906 | 2022-10-19 | US | Colorado | Otero | 8089 | 4981 | 133 | 0 | 37.9014485 | -103.7173385 | 2022-10-20 04:22:59 | Otero, Colorado, US | |
2854431 | 2854431 | 2022-08-22 | US | Maine | Washington | 23029 | 4981 | 60 | 0 | 45.01607142 | -67.62813524 | 2022-08-23 04:20:56 | Washington, Maine, US | |
2405849 | 2405849 | 2022-08-21 | US | Texas | Aransas | 48007 | 4981 | 91 | 0 | 28.10556197 | -96.9995047 | 2022-08-22 04:20:38 | Aransas, Texas, US | |
2404403 | 2404403 | 2022-08-21 | US | Maine | Washington | 23029 | 4981 | 60 | 0 | 45.01607142 | -67.62813524 | 2022-08-22 04:20:38 | Washington, Maine, US | |
3800927 | 3800927 | 2022-08-20 | US | Texas | Aransas | 48007 | 4981 | 91 | 0 | 28.10556197 | -96.9995047 | 2022-08-21 04:20:44 | Aransas, Texas, US | |
3799481 | 3799481 | 2022-08-20 | US | Maine | Washington | 23029 | 4981 | 60 | 0 | 45.01607142 | -67.62813524 | 2022-08-21 04:20:44 | Washington, Maine, US | |
2366513 | 2366513 | 2022-08-19 | US | Texas | Aransas | 48007 | 4981 | 91 | 0 | 28.10556197 | -96.9995047 | 2022-08-20 04:21:01 | Aransas, Texas, US | |
1163905 | 1163905 | 2022-08-18 | US | Puerto Rico | Comerio | 72045 | 4981 | 0 | 0 | 18.224687 | -66.221622 | 2022-08-19 04:20:54 | Comerio, Puerto Rico, US | |
3967103 | 3967103 | 2022-07-05 | US | California | Inyo | 6027 | 4981 | 56 | 0 | 36.51112084 | -117.4111978 | 2022-07-06 04:20:58 | Inyo, California, US | |
2241730 | 2241730 | 2022-06-28 | US | North Carolina | Hertford | 37091 | 4981 | 86 | 0 | 36.3607755 | -76.98104134 | 2022-06-29 04:20:59 | Hertford, North Carolina, US | |
2149972 | 2149972 | 2022-06-27 | US | North Carolina | Hertford | 37091 | 4981 | 86 | 0 | 36.3607755 | -76.98104134 | 2022-06-28 04:20:58 | Hertford, North Carolina, US | |
478823 | 478823 | 2022-06-26 | US | Virginia | New Kent | 51127 | 4981 | 32 | 0 | 37.50694406 | -76.99828634 | 2022-06-27 04:21:00 | New Kent, Virginia, US | |
477773 | 477773 | 2022-06-26 | US | North Carolina | Hertford | 37091 | 4981 | 86 | 0 | 36.3607755 | -76.98104134 | 2022-06-27 04:21:00 | Hertford, North Carolina, US | |
942198 | 942198 | 2022-06-25 | US | Virginia | New Kent | 51127 | 4981 | 32 | 0 | 37.50694406 | -76.99828634 | 2022-06-26 04:21:02 | New Kent, Virginia, US | |
941148 | 941148 | 2022-06-25 | US | North Carolina | Hertford | 37091 | 4981 | 86 | 0 | 36.3607755 | -76.98104134 | 2022-06-26 04:21:02 | Hertford, North Carolina, US | |
3350018 | 3350018 | 2022-06-24 | US | Virginia | New Kent | 51127 | 4981 | 32 | 0 | 37.50694406 | -76.99828634 | 2022-06-25 04:20:57 | New Kent, Virginia, US | |
3348968 | 3348968 | 2022-06-24 | US | North Carolina | Hertford | 37091 | 4981 | 86 | 0 | 36.3607755 | -76.98104134 | 2022-06-25 04:20:57 | Hertford, North Carolina, US | |
1651336 | 1651336 | 2022-06-23 | US | Tennessee | Humphreys | 47085 | 4981 | 76 | 0 | 36.03958805 | -87.77992872 | 2022-06-24 04:20:58 | Humphreys, Tennessee, US | |
1650709 | 1650709 | 2022-06-23 | US | North Carolina | Hertford | 37091 | 4981 | 86 | 0 | 36.3607755 | -76.98104134 | 2022-06-24 04:20:58 | Hertford, North Carolina, US | |
2189944 | 2189944 | 2022-06-22 | US | North Carolina | Hertford | 37091 | 4981 | 86 | 0 | 36.3607755 | -76.98104134 | 2022-06-23 04:20:55 | Hertford, North Carolina, US | |
2238815 | 2238815 | 2022-06-12 | US | Washington | Adams | 53001 | 4981 | 38 | 0 | 46.98299757 | -118.5601734 | 2022-06-13 04:21:14 | Adams, Washington, US | |
2238696 | 2238696 | 2022-06-12 | US | Virginia | Buchanan | 51027 | 4981 | 123 | 0 | 37.26818323 | -82.03749726 | 2022-06-13 04:21:14 | Buchanan, Virginia, US | |
3145013 | 3145013 | 2022-06-11 | US | Washington | Adams | 53001 | 4981 | 38 | 0 | 46.98299757 | -118.5601734 | 2022-06-12 04:20:53 | Adams, Washington, US | |
3144894 | 3144894 | 2022-06-11 | US | Virginia | Buchanan | 51027 | 4981 | 123 | 0 | 37.26818323 | -82.03749726 | 2022-06-12 04:20:53 | Buchanan, Virginia, US | |
1947929 | 1947929 | 2022-06-10 | US | Washington | Adams | 53001 | 4981 | 38 | 0 | 46.98299757 | -118.5601734 | 2022-06-11 04:21:01 | Adams, Washington, US | |
1947810 | 1947810 | 2022-06-10 | US | Virginia | Buchanan | 51027 | 4981 | 123 | 0 | 37.26818323 | -82.03749726 | 2022-06-11 04:21:01 | Buchanan, Virginia, US | |
2049587 | 2049587 | 2022-05-25 | US | Minnesota | Fillmore | 27045 | 4981 | 24 | 0 | 43.67394126 | -92.08980382 | 2022-05-26 04:20:50 | Fillmore, Minnesota, US | |
3001025 | 3001025 | 2022-05-24 | US | Minnesota | Fillmore | 27045 | 4981 | 24 | 0 | 43.67394126 | -92.08980382 | 2022-05-25 04:20:56 | Fillmore, Minnesota, US | |
623598 | 623598 | 2022-05-22 | US | Minnesota | Fillmore | 27045 | 4981 | 24 | 0 | 43.67394126 | -92.08980382 | 2022-05-26 04:20:50 | Fillmore, Minnesota, US | |
361002 | 361002 | 2022-05-07 | US | Colorado | Teller | 8119 | 4981 | 57 | 0 | 38.88133511 | -105.1614893 | 2022-05-08 04:20:49 | Teller, Colorado, US | |
3722821 | 3722821 | 2022-04-25 | US | Colorado | Elbert | 8039 | 4981 | 40 | 0 | 39.28656773 | -104.13587209999999 | 2022-04-26 04:20:51 | Elbert, Colorado, US | |
2029389 | 2029389 | 2022-04-24 | US | Colorado | Elbert | 8039 | 4981 | 40 | 0 | 39.28656773 | -104.13587209999999 | 2022-04-25 04:20:56 | Elbert, Colorado, US | |
1846348 | 1846348 | 2022-04-18 | US | Alabama | Fayette | 1057 | 4981 | 96 | 0 | 33.72076938 | -87.73886638 | 2022-04-19 04:21:00 | Fayette, Alabama, US | |
3417292 | 3417292 | 2022-04-17 | US | Alabama | Fayette | 1057 | 4981 | 96 | 0 | 33.72076938 | -87.73886638 | 2022-04-18 04:21:12 | Fayette, Alabama, US | |
304241 | 304241 | 2022-04-16 | US | Alabama | Fayette | 1057 | 4981 | 96 | 0 | 33.72076938 | -87.73886638 | 2022-04-17 04:20:59 | Fayette, Alabama, US | |
2670186 | 2670186 | 2022-04-15 | US | Alabama | Fayette | 1057 | 4981 | 96 | 0 | 33.72076938 | -87.73886638 | 2022-04-16 04:20:48 | Fayette, Alabama, US | |
1223971 | 1223971 | 2022-04-14 | US | Alabama | Fayette | 1057 | 4981 | 96 | 0 | 33.72076938 | -87.73886638 | 2022-04-15 04:20:57 | Fayette, Alabama, US | |
2443129 | 2443129 | 2022-04-13 | US | Alabama | Fayette | 1057 | 4981 | 96 | 0 | 33.72076938 | -87.73886638 | 2022-04-13 23:21:06 | Fayette, Alabama, US | |
1948886 | 1948886 | 2022-04-12 | US | Alabama | Fayette | 1057 | 4981 | 96 | 0 | 33.72076938 | -87.73886638 | 2022-04-13 04:21:03 | Fayette, Alabama, US | |
1907581 | 1907581 | 2022-03-22 | US | North Carolina | Yancey | 37199 | 4981 | 51 | 0 | 35.90079156 | -82.31237181 | 2022-03-23 04:20:48 | Yancey, North Carolina, US | |
2322693 | 2322693 | 2022-03-16 | US | Virginia | King George | 51099 | 4981 | 38 | 0 | 38.26818502 | -77.15852768 | 2022-03-17 04:20:56 | King George, Virginia, US | |
263741 | 263741 | 2022-03-15 | US | New Mexico | Roosevelt | 35041 | 4981 | 92 | 0 | 34.02097406 | -103.4799493 | 2022-03-16 04:20:50 | Roosevelt, New Mexico, US | |
262464 | 262464 | 2022-03-15 | US | Idaho | Cassia | 16031 | 4981 | 52 | 0 | 42.28347888 | -113.6012409 | 2022-03-16 04:20:50 | Cassia, Idaho, US | |
1645741 | 1645741 | 2022-03-03 | US | Kentucky | Breckinridge | 21027 | 4981 | 72 | 0 | 37.77377239 | -86.42885017 | 2022-03-04 04:21:09 | Breckinridge, Kentucky, US | |
1995696 | 1995696 | 2022-03-01 | US | Texas | Burleson | 48051 | 4981 | 65 | 0 | 30.49273808 | -96.62158484 | 2022-03-02 04:21:07 | Burleson, Texas, US | |
1299176 | 1299176 | 2022-02-17 | US | Indiana | Orange | 18117 | 4981 | 87 | 0 | 38.54118920000001 | -86.49523093 | 2022-02-18 04:21:04 | Orange, Indiana, US | |
1298556 | 1298556 | 2022-02-17 | US | Arkansas | Logan | 5083 | 4981 | 63 | 0 | 35.21413234 | -93.71951016 | 2022-02-18 04:21:04 | Logan, Arkansas, US | |
1464438 | 1464438 | 2022-02-10 | US | Alabama | Cherokee | 1019 | 4981 | 72 | 0 | 34.17805983 | -85.60638968 | 2022-02-11 04:21:09 | Cherokee, Alabama, US | |
2013554 | 2013554 | 2022-02-06 | US | Georgia | Mitchell | 13205 | 4981 | 104 | 0 | 31.22483255 | -84.19381821 | 2022-02-07 04:21:05 | Mitchell, Georgia, US | |
1294883 | 1294883 | 2022-02-05 | US | Georgia | Mitchell | 13205 | 4981 | 104 | 0 | 31.22483255 | -84.19381821 | 2022-02-06 04:21:00 | Mitchell, Georgia, US | |
2328211 | 2328211 | 2022-02-04 | US | Georgia | Mitchell | 13205 | 4981 | 104 | 0 | 31.22483255 | -84.19381821 | 2022-02-05 04:21:05 | Mitchell, Georgia, US | |
461595 | 461595 | 2022-02-02 | US | New Mexico | Taos | 35055 | 4981 | 80 | 0 | 36.58006022 | -105.63101979999999 | 2022-02-03 04:21:21 | Taos, New Mexico, US | |
981426 | 981426 | 2022-02-01 | US | Ohio | Holmes | 39075 | 4981 | 178 | 0 | 40.56163713 | -81.92635677 | 2022-02-02 04:21:09 | Holmes, Ohio, US | |
3813071 | 3813071 | 2022-01-28 | US | Texas | Karnes | 48255 | 4981 | 60 | 0 | 28.90705334 | -97.85960149 | 2022-01-29 04:21:10 | Karnes, Texas, US | |
1962427 | 1962427 | 2022-01-20 | US | Missouri | Audrain | 29007 | 4981 | 91 | 0 | 39.215877 | -91.84242683 | 2022-01-21 04:21:09 | Audrain, Missouri, US | |
1474049 | 1474049 | 2022-01-17 | US | Missouri | Miller | 29131 | 4981 | 105 | 0 | 38.21450288 | -92.42610898 | 2022-01-18 04:21:04 | Miller, Missouri, US | |
556723 | 556723 | 2022-01-16 | US | Missouri | Miller | 29131 | 4981 | 105 | 0 | 38.21450288 | -92.42610898 | 2022-01-17 04:21:08 | Miller, Missouri, US | |
3842444 | 3842444 | 2022-01-15 | US | Missouri | Miller | 29131 | 4981 | 105 | 0 | 38.21450288 | -92.42610898 | 2022-01-16 04:21:12 | Miller, Missouri, US | |
2168100 | 2168100 | 2022-01-01 | US | Arkansas | Yell | 5149 | 4981 | 88 | 0 | 35.00292371 | -93.41171338 | 2022-01-02 04:20:52 | Yell, Arkansas, US | |
2777531 | 2777531 | 2021-12-31 | US | Arkansas | Yell | 5149 | 4981 | 88 | 0 | 35.00292371 | -93.41171338 | 2022-01-01 04:22:14 | Yell, Arkansas, US | |
1669501 | 1669501 | 2021-12-29 | US | Illinois | Saline | 17165 | 4981 | 74 | 0 | 37.75332999 | -88.54119706 | 2021-12-30 04:21:25 | Saline, Illinois, US | |
3829 | 3829 | 2021-12-02 | US | West Virginia | Mingo | 54059 | 4981 | 88 | 0 | 37.73048351 | -82.13338365 | 2021-12-03 04:23:05 | Mingo, West Virginia, US | |
3402787 | 3402787 | 2021-11-30 | US | Kansas | Seward | 20175 | 4981 | 53 | 0 | 37.19324632 | -100.85072009999999 | 2021-12-01 04:22:29 | Seward, Kansas, US | |
151330 | 151330 | 2021-11-29 | US | Kansas | Seward | 20175 | 4981 | 53 | 0 | 37.19324632 | -100.85072009999999 | 2021-11-30 04:22:53 | Seward, Kansas, US | |
2845372 | 2845372 | 2021-11-10 | US | Arkansas | Poinsett | 5111 | 4981 | 101 | 0 | 35.57433534 | -90.66268713 | 2021-11-11 04:21:45 | Poinsett, Arkansas, US | |
277248 | 277248 | 2021-11-03 | US | Indiana | Adams | 18001 | 4981 | 78 | 0 | 40.7457653 | -84.93671406 | 2021-11-04 04:22:20 | Adams, Indiana, US | |
289023 | 289023 | 2021-10-31 | US | Illinois | Montgomery | 17135 | 4981 | 83 | 0 | 39.23198845 | -89.47809254 | 2021-11-01 04:22:01 | Montgomery, Illinois, US | |
2722029 | 2722029 | 2021-10-30 | US | Illinois | Montgomery | 17135 | 4981 | 83 | 0 | 39.23198845 | -89.47809254 | 2021-10-31 04:22:08 | Montgomery, Illinois, US | |
568131 | 568131 | 2021-10-29 | US | Illinois | Montgomery | 17135 | 4981 | 83 | 0 | 39.23198845 | -89.47809254 | 2021-10-30 04:22:03 | Montgomery, Illinois, US | |
537397 | 537397 | 2021-10-27 | US | Pennsylvania | Clinton | 42035 | 4981 | 75 | 0 | 41.23255967 | -77.63785995 | 2021-10-28 04:22:08 | Clinton, Pennsylvania, US | |
635358 | 635358 | 2021-10-13 | US | Kentucky | Logan | 21141 | 4981 | 79 | 0 | 36.85949479 | -86.877635 | 2021-10-14 04:21:29 | Logan, Kentucky, US | |
3807270 | 3807270 | 2021-09-11 | US | Kentucky | Bell | 21013 | 4981 | 69 | 0 | 36.73355174 | -83.67766671 | 2021-09-12 04:21:13 | Bell, Kentucky, US | |
2280271 | 2280271 | 2021-09-08 | US | Indiana | Miami | 18103 | 4981 | 79 | 0 | 40.76940965 | -86.04525048 | 2021-09-09 04:21:27 | Miami, Indiana, US | |
2796265 | 2796265 | 2021-08-28 | US | Texas | Titus | 48449 | 4981 | 88 | 0 | 33.21339719 | -94.96797273 | 2021-08-29 04:21:14 | Titus, Texas, US | |
3167338 | 3167338 | 2021-08-23 | US | Minnesota | Douglas | 27041 | 4981 | 83 | 0 | 45.93348491 | -95.45335469 | 2021-08-24 04:21:19 | Douglas, Minnesota, US | |
2178198 | 2178198 | 2021-08-22 | US | Pennsylvania | Bedford | 42009 | 4981 | 143 | 0 | 40.00522157 | -78.48998442 | 2021-08-23 04:21:27 | Bedford, Pennsylvania, US | |
514438 | 514438 | 2021-08-19 | US | Puerto Rico | Guaynabo | 72061 | 4981 | 0 | 0 | 18.345114000000002 | -66.11452299999999 | 2021-08-20 04:21:33 | Guaynabo, Puerto Rico, US | |
1607802 | 1607802 | 2021-08-16 | US | Wisconsin | Polk | 55095 | 4981 | 68 | 0 | 45.46130348 | -92.44182875 | 2021-08-17 04:21:49 | Polk, Wisconsin, US | |
1483336 | 1483336 | 2021-08-13 | Chad | 4981 | 174 | 0 | 15.4542 | 18.7322 | 2021-08-14 04:21:25 | Chad | ||||
2902196 | 2902196 | 2021-08-12 | US | Ohio | Shelby | 39149 | 4981 | 98 | 0 | 40.33163494 | -84.20258189 | 2021-08-13 04:21:24 | Shelby, Ohio, US | |
2899466 | 2899466 | 2021-08-12 | Chad | 4981 | 174 | 0 | 15.4542 | 18.7322 | 2021-08-13 04:21:24 | Chad | ||||
1342070 | 1342070 | 2021-08-11 | Chad | 4981 | 174 | 0 | 15.4542 | 18.7322 | 2021-08-12 04:21:25 | Chad | ||||
2351217 | 2351217 | 2021-08-10 | Chad | 4981 | 174 | 0 | 15.4542 | 18.7322 | 2021-08-11 04:21:58 | Chad | ||||
651496 | 651496 | 2021-08-09 | US | Louisiana | St. John the Baptist | 22095 | 4981 | 147 | 0 | 30.12597499 | -90.4753503 | 2021-08-10 04:21:27 | St. John the Baptist, Louisiana, US | |
2373867 | 2373867 | 2021-07-20 | US | North Carolina | Richmond | 37153 | 4981 | 98 | 0 | 35.00417719 | -79.74491009 | 2021-07-21 04:21:40 | Richmond, North Carolina, 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]);