johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
129 rows where confirmed = 5501 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
220741 | 220741 | 2022-12-26 | US | Puerto Rico | Loiza | 72087 | 5501 | 0 | 0 | 18.425688 | -65.89943 | 2022-12-27 04:21:07 | Loiza, Puerto Rico, US | |
3225198 | 3225198 | 2022-12-25 | US | Puerto Rico | Loiza | 72087 | 5501 | 0 | 0 | 18.425688 | -65.89943 | 2022-12-26 04:21:06 | Loiza, Puerto Rico, US | |
1021112 | 1021112 | 2022-12-24 | US | Puerto Rico | Loiza | 72087 | 5501 | 0 | 0 | 18.425688 | -65.89943 | 2022-12-25 04:21:04 | Loiza, Puerto Rico, US | |
3026901 | 3026901 | 2022-11-17 | US | Colorado | Chaffee | 8015 | 5501 | 56 | 0 | 38.74745778 | -106.1926573 | 2022-11-18 04:21:15 | Chaffee, Colorado, US | |
482273 | 482273 | 2022-11-08 | US | Pennsylvania | Juniata | 42067 | 5501 | 187 | 0 | 40.53358749 | -77.3997513 | 2022-11-09 04:21:22 | Juniata, Pennsylvania, US | |
2441423 | 2441423 | 2022-11-07 | US | Pennsylvania | Juniata | 42067 | 5501 | 187 | 0 | 40.53358749 | -77.3997513 | 2022-11-08 04:21:21 | Juniata, Pennsylvania, US | |
1052521 | 1052521 | 2022-11-06 | US | Pennsylvania | Juniata | 42067 | 5501 | 187 | 0 | 40.53358749 | -77.3997513 | 2022-11-07 04:21:26 | Juniata, Pennsylvania, US | |
620545 | 620545 | 2022-11-05 | US | Pennsylvania | Juniata | 42067 | 5501 | 187 | 0 | 40.53358749 | -77.3997513 | 2022-11-06 04:21:24 | Juniata, Pennsylvania, US | |
1025049 | 1025049 | 2022-11-04 | US | Pennsylvania | Juniata | 42067 | 5501 | 187 | 0 | 40.53358749 | -77.3997513 | 2022-11-05 04:21:52 | Juniata, Pennsylvania, US | |
434040 | 434040 | 2022-11-03 | US | Pennsylvania | Juniata | 42067 | 5501 | 187 | 0 | 40.53358749 | -77.3997513 | 2022-11-04 04:22:11 | Juniata, Pennsylvania, US | |
852282 | 852282 | 2022-11-02 | US | Pennsylvania | Juniata | 42067 | 5501 | 187 | 0 | 40.53358749 | -77.3997513 | 2022-11-03 04:22:05 | Juniata, Pennsylvania, US | |
1833537 | 1833537 | 2022-10-25 | US | Virginia | New Kent | 51127 | 5501 | 41 | 0 | 37.50694406 | -76.99828634 | 2022-10-26 04:22:19 | New Kent, Virginia, US | |
1592692 | 1592692 | 2022-10-21 | US | Arkansas | Cross | 5037 | 5501 | 97 | 0 | 35.29631396 | -90.77185818 | 2022-10-22 04:22:53 | Cross, Arkansas, US | |
2272408 | 2272408 | 2022-10-20 | US | Arkansas | Cross | 5037 | 5501 | 97 | 0 | 35.29631396 | -90.77185818 | 2022-10-21 04:22:23 | Cross, Arkansas, US | |
2532901 | 2532901 | 2022-10-06 | US | West Virginia | Taylor | 54091 | 5501 | 79 | 0 | 39.33602617 | -80.0421439 | 2022-10-07 04:23:08 | Taylor, West Virginia, US | |
856333 | 856333 | 2022-09-30 | US | Puerto Rico | Adjuntas | 72001 | 5501 | 0 | 0 | 18.180117 | -66.754367 | 2022-10-01 04:23:01 | Adjuntas, Puerto Rico, US | |
2379128 | 2379128 | 2022-09-29 | US | Wisconsin | Sawyer | 55113 | 5501 | 63 | 0 | 45.87931905 | -91.14504927 | 2022-09-30 04:23:09 | Sawyer, Wisconsin, US | |
256533 | 256533 | 2022-09-08 | US | Texas | Scurry | 48415 | 5501 | 105 | 0 | 32.74613808 | -100.9162664 | 2022-09-09 04:21:11 | Scurry, Texas, US | |
2496674 | 2496674 | 2022-08-15 | US | Oregon | Union | 41061 | 5501 | 86 | 0 | 45.30915495 | -118.0068979 | 2022-08-16 04:20:58 | Union, Oregon, US | |
1086736 | 1086736 | 2022-08-09 | US | Colorado | Teller | 8119 | 5501 | 59 | 0 | 38.88133511 | -105.1614893 | 2022-08-10 04:20:57 | Teller, Colorado, US | |
671342 | 671342 | 2022-07-21 | US | Illinois | Richland | 17159 | 5501 | 74 | 0 | 38.71240969 | -88.08475366 | 2022-07-22 04:21:15 | Richland, Illinois, US | |
959295 | 959295 | 2022-07-19 | US | Alabama | Pickens | 1107 | 5501 | 105 | 0 | 33.28094866 | -88.08818103 | 2022-07-20 04:20:59 | Pickens, Alabama, US | |
3349356 | 3349356 | 2022-06-24 | US | Puerto Rico | Aibonito | 72009 | 5501 | 0 | 0 | 18.131361 | -66.264131 | 2022-06-25 04:20:57 | Aibonito, Puerto Rico, US | |
1651740 | 1651740 | 2022-06-23 | US | Virginia | King George | 51099 | 5501 | 40 | 0 | 38.26818502 | -77.15852768 | 2022-06-24 04:20:58 | King George, Virginia, US | |
3397898 | 3397898 | 2022-06-18 | US | Arkansas | Clark | 5019 | 5501 | 82 | 0 | 34.04613432 | -93.17484713 | 2022-06-19 04:20:51 | Clark, Arkansas, US | |
560739 | 560739 | 2022-06-16 | US | Missouri | McDonald | 29119 | 5501 | 77 | 0 | 36.62869595 | -94.34867205 | 2022-06-17 04:20:56 | McDonald, Missouri, US | |
3984541 | 3984541 | 2022-06-15 | US | Missouri | McDonald | 29119 | 5501 | 77 | 0 | 36.62869595 | -94.34867205 | 2022-06-16 04:20:55 | McDonald, Missouri, US | |
948782 | 948782 | 2022-06-14 | US | Missouri | McDonald | 29119 | 5501 | 77 | 0 | 36.62869595 | -94.34867205 | 2022-06-15 04:20:54 | McDonald, Missouri, US | |
947326 | 947326 | 2022-06-14 | US | Arkansas | Columbia | 5027 | 5501 | 97 | 0 | 33.21230701 | -93.22642793 | 2022-06-15 04:20:54 | Columbia, Arkansas, US | |
2981190 | 2981190 | 2022-06-13 | US | Missouri | McDonald | 29119 | 5501 | 77 | 0 | 36.62869595 | -94.34867205 | 2022-06-14 04:20:52 | McDonald, Missouri, US | |
2237316 | 2237316 | 2022-06-12 | US | Missouri | McDonald | 29119 | 5501 | 77 | 0 | 36.62869595 | -94.34867205 | 2022-06-13 04:21:14 | McDonald, Missouri, US | |
2235564 | 2235564 | 2022-06-12 | Peru | Unknown | 5501 | 65 | 0 | 2022-06-13 04:21:14 | Unknown, Peru | |||||
3143514 | 3143514 | 2022-06-11 | US | Missouri | McDonald | 29119 | 5501 | 77 | 0 | 36.62869595 | -94.34867205 | 2022-06-12 04:20:53 | McDonald, Missouri, US | |
1946430 | 1946430 | 2022-06-10 | US | Missouri | McDonald | 29119 | 5501 | 77 | 0 | 36.62869595 | -94.34867205 | 2022-06-11 04:21:01 | McDonald, Missouri, US | |
3579681 | 3579681 | 2022-06-02 | US | Illinois | Union | 17181 | 5501 | 65 | 0 | 37.47119609 | -89.25548938 | 2022-06-03 04:20:58 | Union, Illinois, US | |
3594039 | 3594039 | 2022-05-23 | US | Illinois | Lawrence | 17101 | 5501 | 43 | 0 | 38.71987914 | -87.72884035 | 2022-05-24 04:20:57 | Lawrence, Illinois, US | |
3353405 | 3353405 | 2022-04-01 | US | Puerto Rico | Juana Diaz | 72075 | 5501 | 0 | 0 | 18.050764 | -66.49458100000001 | 2022-04-02 04:20:47 | Juana Diaz, Puerto Rico, US | |
2479839 | 2479839 | 2022-03-30 | US | Missouri | Adair | 29001 | 5501 | 62 | 0 | 40.19058551 | -92.60078167 | 2022-03-31 04:20:56 | Adair, Missouri, US | |
878070 | 878070 | 2022-03-27 | US | Mississippi | Grenada | 28043 | 5501 | 129 | 0 | 33.77036166 | -89.80245083 | 2022-03-28 04:20:33 | Grenada, Mississippi, US | |
2165353 | 2165353 | 2022-03-26 | US | Mississippi | Grenada | 28043 | 5501 | 129 | 0 | 33.77036166 | -89.80245083 | 2022-03-27 04:20:47 | Grenada, Mississippi, US | |
1722289 | 1722289 | 2022-03-25 | US | Mississippi | Grenada | 28043 | 5501 | 129 | 0 | 33.77036166 | -89.80245083 | 2022-03-26 04:20:23 | Grenada, Mississippi, US | |
1469906 | 1469906 | 2022-03-24 | US | Mississippi | Grenada | 28043 | 5501 | 129 | 0 | 33.77036166 | -89.80245083 | 2022-03-25 04:20:46 | Grenada, Mississippi, US | |
3024080 | 3024080 | 2022-03-23 | US | Mississippi | Grenada | 28043 | 5501 | 129 | 0 | 33.77036166 | -89.80245083 | 2022-03-24 04:20:43 | Grenada, Mississippi, US | |
1908688 | 1908688 | 2022-03-22 | US | West Virginia | Lincoln | 54043 | 5501 | 76 | 0 | 38.172154 | -82.07017953 | 2022-03-23 04:20:48 | Lincoln, West Virginia, US | |
1907002 | 1907002 | 2022-03-22 | US | Mississippi | Grenada | 28043 | 5501 | 129 | 0 | 33.77036166 | -89.80245083 | 2022-03-23 04:20:48 | Grenada, Mississippi, US | |
3241819 | 3241819 | 2022-03-21 | US | West Virginia | Lincoln | 54043 | 5501 | 76 | 0 | 38.172154 | -82.07017953 | 2022-03-22 04:20:54 | Lincoln, West Virginia, US | |
3240133 | 3240133 | 2022-03-21 | US | Mississippi | Grenada | 28043 | 5501 | 129 | 0 | 33.77036166 | -89.80245083 | 2022-03-22 04:20:54 | Grenada, Mississippi, US | |
921460 | 921460 | 2022-03-08 | US | Minnesota | Wabasha | 27157 | 5501 | 16 | 0 | 44.28424356 | -92.23121312 | 2022-03-09 04:20:59 | Wabasha, Minnesota, US | |
3914807 | 3914807 | 2022-02-20 | US | Puerto Rico | Vega Alta | 72143 | 5501 | 0 | 0 | 18.409346 | -66.33725 | 2022-02-21 04:21:05 | Vega Alta, Puerto Rico, US | |
3673368 | 3673368 | 2022-02-15 | US | Minnesota | Dodge | 27039 | 5501 | 19 | 0 | 44.02238415 | -92.86244324 | 2022-02-16 04:21:10 | Dodge, Minnesota, US | |
71553 | 71553 | 2022-02-07 | US | Arkansas | Arkansas | 5001 | 5501 | 69 | 0 | 34.29145151 | -91.37277296 | 2022-02-08 04:21:15 | Arkansas, Arkansas, US | |
3689698 | 3689698 | 2022-01-13 | US | New Mexico | Unassigned | 90035 | 5501 | 0 | 0 | 36.60569702 | -108.7151824 | 2022-01-14 04:21:54 | Unassigned, New Mexico, US | |
3688515 | 3688515 | 2022-01-13 | US | Illinois | Perry | 17145 | 5501 | 87 | 0 | 38.08510853 | -89.36856219 | 2022-01-14 04:21:54 | Perry, Illinois, US | |
3829905 | 3829905 | 2021-12-21 | US | Kentucky | Logan | 21141 | 5501 | 97 | 0 | 36.85949479 | -86.877635 | 2021-12-22 04:21:54 | Logan, Kentucky, US | |
1719726 | 1719726 | 2021-12-16 | US | Virginia | Manassas | 51683 | 5501 | 54 | 0 | 38.7464321 | -77.48509905 | 2021-12-17 04:22:14 | Manassas, Virginia, US | |
1717248 | 1717248 | 2021-12-16 | US | Georgia | Upson | 13293 | 5501 | 190 | 0 | 32.87920671 | -84.30024826 | 2021-12-17 04:22:14 | Upson, Georgia, US | |
1661440 | 1661440 | 2021-12-12 | US | Illinois | Logan | 17107 | 5501 | 77 | 0 | 40.12581572 | -89.36638784 | 2021-12-13 04:22:02 | Logan, Illinois, US | |
1665456 | 1665456 | 2021-12-11 | US | Illinois | Logan | 17107 | 5501 | 77 | 0 | 40.12581572 | -89.36638784 | 2021-12-12 04:22:12 | Logan, Illinois, US | |
3656608 | 3656608 | 2021-12-10 | US | Illinois | Logan | 17107 | 5501 | 77 | 0 | 40.12581572 | -89.36638784 | 2021-12-11 04:22:45 | Logan, Illinois, US | |
551659 | 551659 | 2021-12-08 | US | Georgia | Toombs | 13279 | 5501 | 176 | 0 | 32.12059861 | -82.32957247 | 2021-12-09 04:22:49 | Toombs, Georgia, US | |
656273 | 656273 | 2021-10-22 | US | New York | Warren | 36113 | 5501 | 84 | 0 | 43.56173026 | -73.8433699 | 2021-10-23 04:21:32 | Warren, New York, US | |
2124601 | 2124601 | 2021-10-21 | US | Georgia | Pickens | 13227 | 5501 | 112 | 0 | 34.46589159 | -84.46406611 | 2021-10-22 04:21:14 | Pickens, Georgia, US | |
634963 | 634963 | 2021-10-13 | US | Illinois | Randolph | 17157 | 5501 | 99 | 0 | 38.05095369 | -89.82512254 | 2021-10-14 04:21:29 | Randolph, Illinois, US | |
3010987 | 3010987 | 2021-10-11 | United Kingdom | Bermuda | 5501 | 89 | 0 | 32.3078 | -64.7505 | 2021-10-12 04:21:09 | Bermuda, United Kingdom | |||
427003 | 427003 | 2021-10-10 | United Kingdom | Bermuda | 5501 | 89 | 0 | 32.3078 | -64.7505 | 2021-10-11 04:21:31 | Bermuda, United Kingdom | |||
2879860 | 2879860 | 2021-10-09 | United Kingdom | Bermuda | 5501 | 89 | 0 | 32.3078 | -64.7505 | 2021-10-10 04:21:38 | Bermuda, United Kingdom | |||
2963026 | 2963026 | 2021-10-08 | United Kingdom | Bermuda | 5501 | 89 | 0 | 32.3078 | -64.7505 | 2021-10-09 04:21:34 | Bermuda, United Kingdom | |||
1335406 | 1335406 | 2021-09-28 | US | Indiana | Putnam | 18133 | 5501 | 69 | 0 | 39.66437981 | -86.84517605 | 2021-09-29 04:21:45 | Putnam, Indiana, US | |
2466029 | 2466029 | 2021-09-14 | US | Texas | Upshur | 48459 | 5501 | 96 | 0 | 32.73706798 | -94.93999853 | 2021-09-15 03:22:37 | Upshur, Texas, US | |
2464009 | 2464009 | 2021-09-14 | US | Iowa | Marshall | 19127 | 5501 | 79 | 0 | 42.03586837 | -92.99908190000001 | 2021-09-15 03:22:37 | Marshall, Iowa, US | |
1386848 | 1386848 | 2021-09-13 | US | Iowa | Marshall | 19127 | 5501 | 79 | 0 | 42.03586837 | -92.99908190000001 | 2021-09-14 04:21:41 | Marshall, Iowa, US | |
1886217 | 1886217 | 2021-09-12 | US | Iowa | Marshall | 19127 | 5501 | 79 | 0 | 42.03586837 | -92.99908190000001 | 2021-09-13 04:21:15 | Marshall, Iowa, US | |
3807120 | 3807120 | 2021-09-11 | US | Iowa | Marshall | 19127 | 5501 | 79 | 0 | 42.03586837 | -92.99908190000001 | 2021-09-12 04:21:13 | Marshall, Iowa, US | |
3450060 | 3450060 | 2021-09-10 | US | Iowa | Marshall | 19127 | 5501 | 79 | 0 | 42.03586837 | -92.99908190000001 | 2021-09-11 04:21:30 | Marshall, Iowa, US | |
1264006 | 1264006 | 2021-09-09 | US | Iowa | Marshall | 19127 | 5501 | 79 | 0 | 42.03586837 | -92.99908190000001 | 2021-09-10 04:21:20 | Marshall, Iowa, US | |
2280376 | 2280376 | 2021-09-08 | US | Iowa | Marshall | 19127 | 5501 | 79 | 0 | 42.03586837 | -92.99908190000001 | 2021-09-09 04:21:27 | Marshall, Iowa, US | |
32777 | 32777 | 2021-08-25 | US | Alabama | Covington | 1039 | 5501 | 138 | 0 | 31.247785399999998 | -86.45050893 | 2021-08-26 04:21:28 | Covington, Alabama, US | |
3105816 | 3105816 | 2021-08-24 | US | Alabama | Covington | 1039 | 5501 | 138 | 0 | 31.247785399999998 | -86.45050893 | 2021-08-25 04:21:41 | Covington, Alabama, US | |
3165987 | 3165987 | 2021-08-23 | US | Alabama | Covington | 1039 | 5501 | 138 | 0 | 31.247785399999998 | -86.45050893 | 2021-08-24 04:21:19 | Covington, Alabama, US | |
1855868 | 1855868 | 2021-08-20 | US | Missouri | Camden | 29029 | 5501 | 111 | 0 | 38.02199522 | -92.76083747 | 2021-08-21 04:21:38 | Camden, Missouri, US | |
1604833 | 1604833 | 2021-08-16 | US | Colorado | Broomfield | 8014 | 5501 | 78 | 0 | 39.95998787 | -105.0566324 | 2021-08-17 04:21:49 | Broomfield, Colorado, US | |
1485790 | 1485790 | 2021-08-13 | US | New York | Genesee | 36037 | 5501 | 124 | 0 | 43.0022601 | -78.19135193 | 2021-08-14 04:21:25 | Genesee, New York, US | |
591966 | 591966 | 2021-08-08 | US | North Carolina | McDowell | 37111 | 5501 | 63 | 0 | 35.67736232 | -82.0482425 | 2021-08-09 04:21:24 | McDowell, North Carolina, US | |
2205978 | 2205978 | 2021-08-07 | US | North Carolina | McDowell | 37111 | 5501 | 63 | 0 | 35.67736232 | -82.0482425 | 2021-08-08 04:21:33 | McDowell, North Carolina, US | |
1119928 | 1119928 | 2021-08-06 | US | North Carolina | McDowell | 37111 | 5501 | 63 | 0 | 35.67736232 | -82.0482425 | 2021-08-07 04:21:30 | McDowell, North Carolina, US | |
1332931 | 1332931 | 2021-07-24 | US | Pennsylvania | Mifflin | 42087 | 5501 | 183 | 0 | 40.61116939 | -77.61070738 | 2021-07-25 04:22:12 | Mifflin, Pennsylvania, US | |
3140235 | 3140235 | 2021-07-23 | US | Pennsylvania | Mifflin | 42087 | 5501 | 183 | 0 | 40.61116939 | -77.61070738 | 2021-07-24 00:21:36 | Mifflin, Pennsylvania, US | |
3478995 | 3478995 | 2021-07-22 | US | Pennsylvania | Mifflin | 42087 | 5501 | 183 | 0 | 40.61116939 | -77.61070738 | 2021-07-23 04:21:29 | Mifflin, Pennsylvania, US | |
3334214 | 3334214 | 2021-07-21 | US | Pennsylvania | Mifflin | 42087 | 5501 | 183 | 0 | 40.61116939 | -77.61070738 | 2021-07-22 04:21:19 | Mifflin, Pennsylvania, US | |
2374195 | 2374195 | 2021-07-20 | US | Pennsylvania | Mifflin | 42087 | 5501 | 183 | 0 | 40.61116939 | -77.61070738 | 2021-07-21 04:21:40 | Mifflin, Pennsylvania, US | |
1894759 | 1894759 | 2021-06-30 | US | Michigan | Cass | 26027 | 5501 | 77 | 0 | 41.91522292 | -85.99405727 | 2021-07-01 04:21:19 | Cass, Michigan, US | |
1713790 | 1713790 | 2021-06-25 | US | Kentucky | Scott | 21209 | 5501 | 36 | 0 | 38.29622293 | -84.5816631 | 2021-06-26 04:21:43 | Scott, Kentucky, US | |
2912636 | 2912636 | 2021-06-17 | US | Kentucky | Scott | 21209 | 5501 | 36 | 0 | 38.29622293 | -84.5816631 | 2021-06-18 04:22:16 | Scott, Kentucky, US | |
1710782 | 1710782 | 2021-06-02 | US | Ohio | Huron | 39077 | 5501 | 123 | 0 | 41.14651175 | -82.59867951 | 2021-06-03 04:23:32 | Huron, Ohio, US | |
1709478 | 1709478 | 2021-06-02 | US | Iowa | Cerro Gordo | 19033 | 5501 | 90 | 0 | 43.08177563 | -93.2612239 | 2021-06-03 04:23:32 | Cerro Gordo, Iowa, US | |
2105296 | 2105296 | 2021-06-01 | US | Iowa | Cerro Gordo | 19033 | 5501 | 90 | 0 | 43.08177563 | -93.2612239 | 2021-06-02 04:24:34 | Cerro Gordo, Iowa, US | |
85441 | 85441 | 2021-05-25 | US | North Carolina | Pender | 37141 | 5501 | 69 | 0 | 34.52265624 | -77.90352133 | 2021-05-26 04:20:35 | Pender, North Carolina, US | |
3956534 | 3956534 | 2021-05-11 | US | Nebraska | Buffalo | 31019 | 5501 | 57 | 0 | 40.85486962 | -99.07500296 | 2021-05-12 04:21:29 | Buffalo, Nebraska, US | |
2822813 | 2822813 | 2021-05-10 | US | Nebraska | Buffalo | 31019 | 5501 | 57 | 0 | 40.85486962 | -99.07500296 | 2021-05-11 04:20:41 | Buffalo, Nebraska, US | |
649402 | 649402 | 2021-05-05 | US | Washington | Skagit | 53057 | 5501 | 67 | 0 | 48.48171488 | -121.766131 | 2021-05-06 04:20:38 | Skagit, Washington, 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]);