johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
138 rows where confirmed = 5981 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
260109 | 260109 | 2022-12-10 | US | Puerto Rico | Sabana Grande | 72121 | 5981 | 0 | 0 | 18.08282 | -66.943758 | 2022-12-11 04:20:50 | Sabana Grande, Puerto Rico, US | |
2557633 | 2557633 | 2022-11-29 | US | Illinois | Richland | 17159 | 5981 | 77 | 0 | 38.71240969 | -88.08475366 | 2022-11-30 04:21:07 | Richland, Illinois, US | |
2017491 | 2017491 | 2022-09-20 | US | Georgia | Burke | 13033 | 5981 | 115 | 0 | 33.05917989 | -81.99928721 | 2022-09-21 04:23:22 | Burke, Georgia, US | |
3571364 | 3571364 | 2022-09-19 | US | Georgia | Burke | 13033 | 5981 | 115 | 0 | 33.05917989 | -81.99928721 | 2022-09-20 04:22:48 | Burke, Georgia, US | |
420103 | 420103 | 2022-09-18 | US | Georgia | Burke | 13033 | 5981 | 115 | 0 | 33.05917989 | -81.99928721 | 2022-09-19 04:21:49 | Burke, Georgia, US | |
3374127 | 3374127 | 2022-09-17 | US | Georgia | Burke | 13033 | 5981 | 115 | 0 | 33.05917989 | -81.99928721 | 2022-09-18 04:22:50 | Burke, Georgia, US | |
2356235 | 2356235 | 2022-09-16 | US | Georgia | Burke | 13033 | 5981 | 115 | 0 | 33.05917989 | -81.99928721 | 2022-09-17 04:20:19 | Burke, Georgia, US | |
3987392 | 3987392 | 2022-09-15 | US | Georgia | Burke | 13033 | 5981 | 115 | 0 | 33.05917989 | -81.99928721 | 2022-09-16 04:21:19 | Burke, Georgia, US | |
1889909 | 1889909 | 2022-09-14 | US | Georgia | Burke | 13033 | 5981 | 115 | 0 | 33.05917989 | -81.99928721 | 2022-09-15 04:21:02 | Burke, Georgia, US | |
373018 | 373018 | 2022-09-13 | US | Georgia | Haralson | 13143 | 5981 | 181 | 0 | 33.79602175 | -85.21005667 | 2022-09-14 04:20:44 | Haralson, Georgia, US | |
2395620 | 2395620 | 2022-09-12 | US | Georgia | Haralson | 13143 | 5981 | 181 | 0 | 33.79602175 | -85.21005667 | 2022-09-13 04:20:57 | Haralson, Georgia, US | |
3766698 | 3766698 | 2022-09-11 | US | Georgia | Haralson | 13143 | 5981 | 181 | 0 | 33.79602175 | -85.21005667 | 2022-09-12 04:20:58 | Haralson, Georgia, US | |
3825273 | 3825273 | 2022-09-10 | US | Georgia | Haralson | 13143 | 5981 | 181 | 0 | 33.79602175 | -85.21005667 | 2022-09-11 04:20:50 | Haralson, Georgia, US | |
963730 | 963730 | 2022-09-09 | US | Georgia | Haralson | 13143 | 5981 | 181 | 0 | 33.79602175 | -85.21005667 | 2022-09-10 04:21:10 | Haralson, Georgia, US | |
254132 | 254132 | 2022-09-08 | US | Georgia | Haralson | 13143 | 5981 | 181 | 0 | 33.79602175 | -85.21005667 | 2022-09-09 04:21:11 | Haralson, Georgia, US | |
3745930 | 3745930 | 2022-09-07 | US | Georgia | Haralson | 13143 | 5981 | 181 | 0 | 33.79602175 | -85.21005667 | 2022-09-08 04:21:02 | Haralson, Georgia, US | |
2346429 | 2346429 | 2022-08-31 | US | Tennessee | Unicoi | 47171 | 5981 | 99 | 0 | 36.10890856 | -82.43709629 | 2022-09-01 04:21:03 | Unicoi, Tennessee, US | |
3777467 | 3777467 | 2022-08-30 | US | Wisconsin | Langlade | 55067 | 5981 | 95 | 0 | 45.26271619 | -89.07483625 | 2022-08-31 04:20:57 | Langlade, Wisconsin, US | |
3951505 | 3951505 | 2022-08-17 | US | Illinois | Lawrence | 17101 | 5981 | 44 | 0 | 38.71987914 | -87.72884035 | 2022-08-18 04:21:11 | Lawrence, Illinois, US | |
1943259 | 1943259 | 2022-08-06 | US | Puerto Rico | Salinas | 72123 | 5981 | 0 | 0 | 18.010387 | -66.256592 | 2022-08-07 04:20:54 | Salinas, Puerto Rico, US | |
1099860 | 1099860 | 2022-08-03 | US | Minnesota | Martin | 27091 | 5981 | 65 | 0 | 43.67429718 | -94.55099908 | 2022-08-04 04:20:58 | Martin, Minnesota, US | |
1406785 | 1406785 | 2022-08-02 | US | Minnesota | Martin | 27091 | 5981 | 65 | 0 | 43.67429718 | -94.55099908 | 2022-08-03 04:20:59 | Martin, Minnesota, US | |
3618823 | 3618823 | 2022-08-01 | US | Minnesota | Martin | 27091 | 5981 | 65 | 0 | 43.67429718 | -94.55099908 | 2022-08-02 04:20:53 | Martin, Minnesota, US | |
3873303 | 3873303 | 2022-07-31 | US | Minnesota | Martin | 27091 | 5981 | 65 | 0 | 43.67429718 | -94.55099908 | 2022-08-01 04:21:03 | Martin, Minnesota, US | |
676057 | 676057 | 2022-07-30 | US | Minnesota | Martin | 27091 | 5981 | 65 | 0 | 43.67429718 | -94.55099908 | 2022-07-31 04:21:02 | Martin, Minnesota, US | |
1785256 | 1785256 | 2022-07-29 | US | Minnesota | Martin | 27091 | 5981 | 65 | 0 | 43.67429718 | -94.55099908 | 2022-07-30 04:20:42 | Martin, Minnesota, US | |
1067619 | 1067619 | 2022-07-28 | US | Minnesota | Martin | 27091 | 5981 | 65 | 0 | 43.67429718 | -94.55099908 | 2022-07-29 04:20:45 | Martin, Minnesota, US | |
2597108 | 2597108 | 2022-07-25 | US | Texas | Dimmit | 48127 | 5981 | 51 | 0 | 28.42270064 | -99.75645095 | 2022-07-26 04:20:58 | Dimmit, Texas, US | |
1609828 | 1609828 | 2022-07-20 | US | Maine | Sagadahoc | 23023 | 5981 | 37 | 0 | 43.95415864 | -69.85074999 | 2022-07-21 04:21:10 | Sagadahoc, Maine, US | |
1766743 | 1766743 | 2022-06-20 | US | Virginia | Staunton | 51790 | 5981 | 117 | 0 | 38.15965544 | -79.05979937 | 2022-06-21 04:20:56 | Staunton, Virginia, US | |
3159171 | 3159171 | 2022-06-09 | US | Louisiana | St. James | 22093 | 5981 | 76 | 0 | 30.02531716 | -90.80212061 | 2022-06-10 04:20:55 | St. James, Louisiana, US | |
971448 | 971448 | 2022-06-01 | US | Arkansas | Sevier | 5133 | 5981 | 75 | 0 | 33.99780401 | -94.2424869 | 2022-06-02 05:20:39 | Sevier, Arkansas, US | |
229755 | 229755 | 2022-05-31 | US | Arkansas | Sevier | 5133 | 5981 | 75 | 0 | 33.99780401 | -94.2424869 | 2022-06-01 04:20:55 | Sevier, Arkansas, US | |
1851117 | 1851117 | 2022-05-26 | US | Indiana | Owen | 18119 | 5981 | 121 | 0 | 39.31145587 | -86.83900724 | 2022-05-27 04:20:56 | Owen, Indiana, US | |
2048993 | 2048993 | 2022-05-25 | US | Indiana | Owen | 18119 | 5981 | 121 | 0 | 39.31145587 | -86.83900724 | 2022-05-26 04:20:50 | Owen, Indiana, US | |
623004 | 623004 | 2022-05-22 | US | Indiana | Owen | 18119 | 5981 | 121 | 0 | 39.31145587 | -86.83900724 | 2022-05-26 04:20:50 | Owen, Indiana, US | |
2480571 | 2480571 | 2022-03-30 | US | Oklahoma | Texas | 40139 | 5981 | 54 | 0 | 36.74777635 | -101.4889765 | 2022-03-31 04:20:56 | Texas, Oklahoma, US | |
160612 | 160612 | 2022-03-29 | US | Oklahoma | Texas | 40139 | 5981 | 54 | 0 | 36.74777635 | -101.4889765 | 2022-03-30 04:20:45 | Texas, Oklahoma, US | |
1439183 | 1439183 | 2022-03-28 | US | Oklahoma | Texas | 40139 | 5981 | 54 | 0 | 36.74777635 | -101.4889765 | 2022-03-29 04:20:46 | Texas, Oklahoma, US | |
878864 | 878864 | 2022-03-27 | US | Oklahoma | Texas | 40139 | 5981 | 54 | 0 | 36.74777635 | -101.4889765 | 2022-03-28 04:20:33 | Texas, Oklahoma, US | |
2166147 | 2166147 | 2022-03-26 | US | Oklahoma | Texas | 40139 | 5981 | 54 | 0 | 36.74777635 | -101.4889765 | 2022-03-27 04:20:47 | Texas, Oklahoma, US | |
1723083 | 1723083 | 2022-03-25 | US | Oklahoma | Texas | 40139 | 5981 | 54 | 0 | 36.74777635 | -101.4889765 | 2022-03-26 04:20:23 | Texas, Oklahoma, US | |
1470700 | 1470700 | 2022-03-24 | US | Oklahoma | Texas | 40139 | 5981 | 54 | 0 | 36.74777635 | -101.4889765 | 2022-03-25 04:20:46 | Texas, Oklahoma, US | |
3024874 | 3024874 | 2022-03-23 | US | Oklahoma | Texas | 40139 | 5981 | 54 | 0 | 36.74777635 | -101.4889765 | 2022-03-24 04:20:43 | Texas, Oklahoma, US | |
1908786 | 1908786 | 2022-03-22 | US | Wisconsin | Vernon | 55123 | 5981 | 93 | 0 | 43.59422667 | -90.8324691 | 2022-03-23 04:20:48 | Vernon, Wisconsin, US | |
1907796 | 1907796 | 2022-03-22 | US | Oklahoma | Texas | 40139 | 5981 | 54 | 0 | 36.74777635 | -101.4889765 | 2022-03-23 04:20:48 | Texas, Oklahoma, US | |
3240927 | 3240927 | 2022-03-21 | US | Oklahoma | Texas | 40139 | 5981 | 54 | 0 | 36.74777635 | -101.4889765 | 2022-03-22 04:20:54 | Texas, Oklahoma, US | |
27000 | 27000 | 2022-03-20 | US | Oklahoma | Texas | 40139 | 5981 | 54 | 0 | 36.74777635 | -101.4889765 | 2022-03-21 04:20:50 | Texas, Oklahoma, US | |
1659010 | 1659010 | 2022-03-19 | US | Oklahoma | Texas | 40139 | 5981 | 54 | 0 | 36.74777635 | -101.4889765 | 2022-03-20 04:20:45 | Texas, Oklahoma, US | |
338536 | 338536 | 2022-03-18 | US | Oklahoma | Texas | 40139 | 5981 | 54 | 0 | 36.74777635 | -101.4889765 | 2022-03-19 04:20:47 | Texas, Oklahoma, US | |
696989 | 696989 | 2022-03-17 | US | Oklahoma | Texas | 40139 | 5981 | 54 | 0 | 36.74777635 | -101.4889765 | 2022-03-18 04:20:55 | Texas, Oklahoma, US | |
262686 | 262686 | 2022-03-15 | US | Indiana | Washington | 18175 | 5981 | 78 | 0 | 38.60219804 | -86.1049363 | 2022-03-16 04:20:50 | Washington, Indiana, US | |
2265045 | 2265045 | 2022-03-14 | US | Indiana | Washington | 18175 | 5981 | 78 | 0 | 38.60219804 | -86.1049363 | 2022-03-15 04:20:47 | Washington, Indiana, US | |
2201596 | 2201596 | 2022-03-06 | US | Missouri | Randolph | 29175 | 5981 | 100 | 0 | 39.44007257 | -92.49713740000001 | 2022-03-07 04:20:47 | Randolph, Missouri, US | |
2094053 | 2094053 | 2022-03-05 | US | Missouri | Randolph | 29175 | 5981 | 100 | 0 | 39.44007257 | -92.49713740000001 | 2022-03-06 04:20:49 | Randolph, Missouri, US | |
2667753 | 2667753 | 2022-03-04 | US | Missouri | Randolph | 29175 | 5981 | 100 | 0 | 39.44007257 | -92.49713740000001 | 2022-03-05 04:21:10 | Randolph, Missouri, US | |
1646318 | 1646318 | 2022-03-03 | US | Missouri | Randolph | 29175 | 5981 | 100 | 0 | 39.44007257 | -92.49713740000001 | 2022-03-04 04:21:09 | Randolph, Missouri, US | |
72138 | 72138 | 2022-02-07 | US | Illinois | Shelby | 17173 | 5981 | 64 | 0 | 39.39133527 | -88.80611122 | 2022-02-08 04:21:15 | Shelby, Illinois, US | |
2835305 | 2835305 | 2022-01-22 | US | Ohio | Henry | 39069 | 5981 | 101 | 0 | 41.333964200000004 | -84.06830637 | 2022-01-23 04:21:13 | Henry, Ohio, US | |
1961391 | 1961391 | 2022-01-20 | US | Georgia | Lee | 13177 | 5981 | 90 | 0 | 31.779330600000005 | -84.14324253 | 2022-01-21 04:21:09 | Lee, Georgia, US | |
3229197 | 3229197 | 2022-01-19 | US | Puerto Rico | Gurabo | 72063 | 5981 | 0 | 0 | 18.266461 | -65.97970500000001 | 2022-01-20 04:21:07 | Gurabo, Puerto Rico, US | |
3466643 | 3466643 | 2022-01-18 | US | Ohio | Gallia | 39053 | 5981 | 105 | 0 | 38.82708533 | -82.31647569 | 2022-01-19 04:21:23 | Gallia, Ohio, US | |
3466029 | 3466029 | 2022-01-18 | US | Mississippi | Tate | 28137 | 5981 | 123 | 0 | 34.65133709 | -89.94485778 | 2022-01-19 04:21:23 | Tate, Mississippi, US | |
1473159 | 1473159 | 2022-01-17 | US | Illinois | Saline | 17165 | 5981 | 80 | 0 | 37.75332999 | -88.54119706 | 2022-01-18 04:21:04 | Saline, Illinois, US | |
555833 | 555833 | 2022-01-16 | US | Illinois | Saline | 17165 | 5981 | 80 | 0 | 37.75332999 | -88.54119706 | 2022-01-17 04:21:08 | Saline, Illinois, US | |
3841554 | 3841554 | 2022-01-15 | US | Illinois | Saline | 17165 | 5981 | 80 | 0 | 37.75332999 | -88.54119706 | 2022-01-16 04:21:12 | Saline, Illinois, US | |
100369 | 100369 | 2022-01-14 | US | Illinois | Saline | 17165 | 5981 | 80 | 0 | 37.75332999 | -88.54119706 | 2022-01-15 04:21:07 | Saline, Illinois, US | |
2779961 | 2779961 | 2021-12-31 | US | Tennessee | Macon | 47111 | 5981 | 117 | 0 | 36.53157855 | -86.00778595 | 2022-01-01 04:22:14 | Macon, Tennessee, US | |
1433107 | 1433107 | 2021-12-28 | US | California | Amador | 6005 | 5981 | 70 | 0 | 38.44583082 | -120.65696000000001 | 2021-12-29 03:21:43 | Amador, California, US | |
3831169 | 3831169 | 2021-12-21 | US | Pennsylvania | Snyder | 42109 | 5981 | 121 | 0 | 40.77129231 | -77.06840691 | 2021-12-22 04:21:54 | Snyder, Pennsylvania, US | |
2401743 | 2401743 | 2021-12-17 | US | Tennessee | Claiborne | 47025 | 5981 | 119 | 0 | 36.48319149 | -83.65947309 | 2021-12-18 02:22:20 | Claiborne, Tennessee, US | |
2400206 | 2400206 | 2021-12-17 | US | Kentucky | Clark | 21049 | 5981 | 48 | 0 | 37.9689263 | -84.14615986 | 2021-12-18 02:22:20 | Clark, Kentucky, US | |
2198885 | 2198885 | 2021-12-03 | US | Texas | Wood | 48499 | 5981 | 232 | 0 | 32.78722382 | -95.38236368 | 2021-12-04 04:22:18 | Wood, Texas, US | |
3404301 | 3404301 | 2021-11-30 | US | South Dakota | Codington | 46029 | 5981 | 86 | 0 | 44.97788119 | -97.18827677 | 2021-12-01 04:22:29 | Codington, South Dakota, US | |
151558 | 151558 | 2021-11-29 | US | Maryland | Calvert | 24009 | 5981 | 101 | 0 | 38.53961642 | -76.56820632 | 2021-11-30 04:22:53 | Calvert, Maryland, US | |
1361033 | 1361033 | 2021-11-27 | US | Pennsylvania | Pike | 42103 | 5981 | 69 | 0 | 41.33155042 | -75.03208106 | 2021-11-28 04:22:43 | Pike, Pennsylvania, US | |
3752545 | 3752545 | 2021-11-22 | US | Virginia | Tazewell | 51185 | 5981 | 115 | 0 | 37.12191123 | -81.56685568 | 2021-11-23 04:22:39 | Tazewell, Virginia, US | |
279635 | 279635 | 2021-11-03 | US | Washington | Mason | 53045 | 5981 | 72 | 0 | 47.35007586 | -123.1863685 | 2021-11-04 04:22:20 | Mason, Washington, US | |
2126977 | 2126977 | 2021-10-21 | US | Texas | Titus | 48449 | 5981 | 101 | 0 | 33.21339719 | -94.96797273 | 2021-10-22 04:21:14 | Titus, Texas, US | |
424841 | 424841 | 2021-10-10 | US | Louisiana | Beauregard | 22011 | 5981 | 122 | 0 | 30.64836518 | -93.34173616 | 2021-10-11 04:21:31 | Beauregard, Louisiana, US | |
2877698 | 2877698 | 2021-10-09 | US | Louisiana | Beauregard | 22011 | 5981 | 122 | 0 | 30.64836518 | -93.34173616 | 2021-10-10 04:21:38 | Beauregard, Louisiana, US | |
2960864 | 2960864 | 2021-10-08 | US | Louisiana | Beauregard | 22011 | 5981 | 122 | 0 | 30.64836518 | -93.34173616 | 2021-10-09 04:21:34 | Beauregard, Louisiana, US | |
988386 | 988386 | 2021-10-04 | US | Kentucky | Greenup | 21089 | 5981 | 74 | 0 | 38.54332505 | -82.9215658 | 2021-10-05 04:21:27 | Greenup, Kentucky, US | |
2133138 | 2133138 | 2021-10-01 | US | Indiana | Montgomery | 18107 | 5981 | 106 | 0 | 40.04034823 | -86.89335024 | 2021-10-02 04:21:25 | Montgomery, Indiana, US | |
3760958 | 3760958 | 2021-09-21 | US | West Virginia | Jefferson | 54037 | 5981 | 70 | 0 | 39.30776166 | -77.86014147 | 2021-09-22 04:21:45 | Jefferson, West Virginia, US | |
1815773 | 1815773 | 2021-09-19 | US | Illinois | Jefferson | 17081 | 5981 | 131 | 0 | 38.29980057 | -88.9240025 | 2021-09-20 04:21:22 | Jefferson, Illinois, US | |
17353 | 17353 | 2021-09-18 | US | Illinois | Jefferson | 17081 | 5981 | 131 | 0 | 38.29980057 | -88.9240025 | 2021-09-19 04:21:34 | Jefferson, Illinois, US | |
2619918 | 2619918 | 2021-09-17 | US | Missouri | Camden | 29029 | 5981 | 115 | 0 | 38.02199522 | -92.76083747 | 2021-09-18 04:21:24 | Camden, Missouri, US | |
2619038 | 2619038 | 2021-09-17 | US | Illinois | Jefferson | 17081 | 5981 | 131 | 0 | 38.29980057 | -88.9240025 | 2021-09-18 04:21:24 | Jefferson, Illinois, US | |
1265112 | 1265112 | 2021-09-09 | US | North Carolina | Haywood | 37087 | 5981 | 113 | 0 | 35.55269063 | -82.98196486 | 2021-09-10 04:21:20 | Haywood, North Carolina, US | |
644904 | 644904 | 2021-09-07 | US | Tennessee | Marshall | 47117 | 5981 | 70 | 0 | 35.45798777 | -86.76420988 | 2021-09-08 04:21:31 | Marshall, Tennessee, US | |
1605928 | 1605928 | 2021-08-16 | US | Minnesota | Benton | 27009 | 5981 | 98 | 0 | 45.69804958 | -93.99514135 | 2021-08-17 04:21:49 | Benton, Minnesota, US | |
1119533 | 1119533 | 2021-08-06 | US | Missouri | Pettis | 29159 | 5981 | 80 | 0 | 38.72798918 | -93.28471706 | 2021-08-07 04:21:30 | Pettis, Missouri, US | |
1498573 | 1498573 | 2021-07-03 | US | Tennessee | Monroe | 47123 | 5981 | 97 | 0 | 35.44550387 | -84.24902965 | 2021-07-04 04:21:38 | Monroe, Tennessee, US | |
2074888 | 2074888 | 2021-07-02 | US | Tennessee | Monroe | 47123 | 5981 | 97 | 0 | 35.44550387 | -84.24902965 | 2021-07-03 04:21:37 | Monroe, Tennessee, US | |
2590298 | 2590298 | 2021-06-27 | Spain | Ceuta | 5981 | 116 | 163 | 5702 | 35.8894 | -5.3213 | 2021-06-28 04:21:29 | Ceuta, Spain | ||
3958802 | 3958802 | 2021-06-26 | Spain | Ceuta | 5981 | 116 | 163 | 5702 | 35.8894 | -5.3213 | 2021-06-27 04:21:39 | Ceuta, Spain | ||
1712621 | 1712621 | 2021-06-25 | Spain | Ceuta | 5981 | 116 | 163 | 5702 | 35.8894 | -5.3213 | 2021-06-26 04:21:43 | Ceuta, Spain | ||
3971535 | 3971535 | 2021-06-11 | US | Illinois | Grundy | 17063 | 5981 | 78 | 0 | 41.28569601 | -88.41905692 | 2021-06-12 04:22:22 | Grundy, Illinois, US | |
1312085 | 1312085 | 2021-05-26 | US | Missouri | Lincoln | 29113 | 5981 | 48 | 0 | 39.05345619 | -90.95588181 | 2021-05-27 04:20:59 | Lincoln, Missouri, 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]);