johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
156 rows where confirmed = 4938 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755738 | 2755738 | 2022-12-29 | US | South Carolina | Lee | 45061 | 4938 | 98 | 0 | 34.16393091 | -80.25690731 | 2022-12-30 04:21:04 | Lee, South Carolina, US | |
1076744 | 1076744 | 2022-12-28 | US | South Carolina | Lee | 45061 | 4938 | 98 | 0 | 34.16393091 | -80.25690731 | 2022-12-29 04:21:01 | Lee, South Carolina, US | |
330741 | 330741 | 2022-12-27 | US | South Carolina | Lee | 45061 | 4938 | 98 | 0 | 34.16393091 | -80.25690731 | 2022-12-28 04:21:04 | Lee, South Carolina, US | |
328879 | 328879 | 2022-12-27 | US | Illinois | Carroll | 17015 | 4938 | 56 | 0 | 42.06823429 | -89.93395545 | 2022-12-28 04:21:04 | Carroll, Illinois, US | |
3380650 | 3380650 | 2022-12-08 | US | Utah | San Juan | 49037 | 4938 | 51 | 0 | 37.62762978 | -109.8033714 | 2022-12-09 04:21:05 | San Juan, Utah, US | |
1987921 | 1987921 | 2022-12-07 | US | Utah | San Juan | 49037 | 4938 | 51 | 0 | 37.62762978 | -109.8033714 | 2022-12-08 04:21:07 | San Juan, Utah, US | |
3717444 | 3717444 | 2022-12-06 | US | Utah | San Juan | 49037 | 4938 | 51 | 0 | 37.62762978 | -109.8033714 | 2022-12-07 04:20:58 | San Juan, Utah, US | |
2418149 | 2418149 | 2022-12-05 | US | Utah | San Juan | 49037 | 4938 | 51 | 0 | 37.62762978 | -109.8033714 | 2022-12-06 04:21:03 | San Juan, Utah, US | |
721757 | 721757 | 2022-12-04 | US | Utah | San Juan | 49037 | 4938 | 51 | 0 | 37.62762978 | -109.8033714 | 2022-12-05 04:20:58 | San Juan, Utah, US | |
2820046 | 2820046 | 2022-12-03 | US | Utah | San Juan | 49037 | 4938 | 51 | 0 | 37.62762978 | -109.8033714 | 2022-12-04 04:20:56 | San Juan, Utah, US | |
836902 | 836902 | 2022-12-02 | US | Utah | San Juan | 49037 | 4938 | 51 | 0 | 37.62762978 | -109.8033714 | 2022-12-03 04:21:02 | San Juan, Utah, US | |
2137165 | 2137165 | 2022-12-01 | US | Illinois | Jo Daviess | 17085 | 4938 | 45 | 0 | 42.36542373 | -90.21094405 | 2022-12-02 04:21:07 | Jo Daviess, Illinois, US | |
2136904 | 2136904 | 2022-12-01 | US | Florida | Union | 12125 | 4938 | 123 | 0 | 30.04412971 | -82.37497443 | 2022-12-02 04:21:07 | Union, Florida, US | |
1965320 | 1965320 | 2022-11-30 | US | Florida | Union | 12125 | 4938 | 123 | 0 | 30.04412971 | -82.37497443 | 2022-12-01 04:21:03 | Union, Florida, US | |
2557334 | 2557334 | 2022-11-29 | US | Florida | Union | 12125 | 4938 | 123 | 0 | 30.04412971 | -82.37497443 | 2022-11-30 04:21:07 | Union, Florida, US | |
1240408 | 1240408 | 2022-11-28 | US | Florida | Union | 12125 | 4938 | 123 | 0 | 30.04412971 | -82.37497443 | 2022-11-29 04:21:05 | Union, Florida, US | |
3552396 | 3552396 | 2022-11-27 | US | Florida | Union | 12125 | 4938 | 122 | 0 | 30.04412971 | -82.37497443 | 2022-11-28 04:21:02 | Union, Florida, US | |
2100876 | 2100876 | 2022-11-26 | US | Florida | Union | 12125 | 4938 | 122 | 0 | 30.04412971 | -82.37497443 | 2022-11-27 04:21:05 | Union, Florida, US | |
488367 | 488367 | 2022-11-25 | US | Florida | Union | 12125 | 4938 | 122 | 0 | 30.04412971 | -82.37497443 | 2022-11-26 04:21:11 | Union, Florida, US | |
3524196 | 3524196 | 2022-11-24 | US | Florida | Union | 12125 | 4938 | 122 | 0 | 30.04412971 | -82.37497443 | 2022-11-25 04:21:06 | Union, Florida, US | |
3312979 | 3312979 | 2022-11-23 | US | Florida | Union | 12125 | 4938 | 122 | 0 | 30.04412971 | -82.37497443 | 2022-11-24 04:21:09 | Union, Florida, US | |
1621020 | 1621020 | 2022-11-22 | US | Florida | Union | 12125 | 4938 | 122 | 0 | 30.04412971 | -82.37497443 | 2022-11-23 04:21:06 | Union, Florida, US | |
3460908 | 3460908 | 2022-11-21 | US | Florida | Union | 12125 | 4938 | 122 | 0 | 30.04412971 | -82.37497443 | 2022-11-22 04:20:47 | Union, Florida, US | |
1641093 | 1641093 | 2022-11-20 | US | Florida | Union | 12125 | 4938 | 122 | 0 | 30.04412971 | -82.37497443 | 2022-11-21 04:21:05 | Union, Florida, US | |
2064650 | 2064650 | 2022-11-19 | US | Florida | Union | 12125 | 4938 | 122 | 0 | 30.04412971 | -82.37497443 | 2022-11-20 04:21:08 | Union, Florida, US | |
1756044 | 1756044 | 2022-11-18 | US | Florida | Union | 12125 | 4938 | 122 | 0 | 30.04412971 | -82.37497443 | 2022-11-19 04:21:14 | Union, Florida, US | |
3600649 | 3600649 | 2022-11-14 | US | Wyoming | Carbon | 56007 | 4938 | 55 | 0 | 41.69357844 | -106.9326084 | 2022-11-15 04:21:16 | Carbon, Wyoming, US | |
315507 | 315507 | 2022-11-13 | US | Wyoming | Carbon | 56007 | 4938 | 55 | 0 | 41.69357844 | -106.9326084 | 2022-11-14 04:21:09 | Carbon, Wyoming, US | |
66668 | 66668 | 2022-11-12 | US | Wyoming | Carbon | 56007 | 4938 | 55 | 0 | 41.69357844 | -106.9326084 | 2022-11-13 04:21:14 | Carbon, Wyoming, US | |
2930830 | 2930830 | 2022-11-11 | US | Wyoming | Carbon | 56007 | 4938 | 55 | 0 | 41.69357844 | -106.9326084 | 2022-11-12 04:20:41 | Carbon, Wyoming, US | |
2509666 | 2509666 | 2022-11-10 | US | Wyoming | Carbon | 56007 | 4938 | 55 | 0 | 41.69357844 | -106.9326084 | 2022-11-11 04:21:22 | Carbon, Wyoming, US | |
2434541 | 2434541 | 2022-11-09 | US | Wyoming | Carbon | 56007 | 4938 | 55 | 0 | 41.69357844 | -106.9326084 | 2022-11-10 04:21:16 | Carbon, Wyoming, US | |
483197 | 483197 | 2022-11-08 | US | Wyoming | Carbon | 56007 | 4938 | 55 | 0 | 41.69357844 | -106.9326084 | 2022-11-09 04:21:22 | Carbon, Wyoming, US | |
3276632 | 3276632 | 2022-10-23 | Canada | Yukon | 4938 | 31 | 0 | 64.2823 | -135.0 | 2022-10-24 04:22:29 | Yukon, Canada | |||
2267670 | 2267670 | 2022-10-22 | Canada | Yukon | 4938 | 31 | 0 | 64.2823 | -135.0 | 2022-10-23 04:22:46 | Yukon, Canada | |||
1591970 | 1591970 | 2022-10-21 | Canada | Yukon | 4938 | 31 | 0 | 64.2823 | -135.0 | 2022-10-22 04:22:53 | Yukon, Canada | |||
2272907 | 2272907 | 2022-10-20 | US | Illinois | De Witt | 17039 | 4938 | 41 | 0 | 40.17514519 | -88.90959682 | 2022-10-21 04:22:23 | De Witt, Illinois, US | |
2263115 | 2263115 | 2022-10-02 | US | Virginia | Grayson | 51077 | 4938 | 84 | 0 | 36.65677234 | -81.23215889 | 2022-10-03 04:23:11 | Grayson, Virginia, US | |
2998641 | 2998641 | 2022-10-01 | US | Virginia | Grayson | 51077 | 4938 | 84 | 0 | 36.65677234 | -81.23215889 | 2022-10-02 04:21:23 | Grayson, Virginia, US | |
856967 | 856967 | 2022-09-30 | US | Virginia | Grayson | 51077 | 4938 | 84 | 0 | 36.65677234 | -81.23215889 | 2022-10-01 04:23:01 | Grayson, Virginia, US | |
2378893 | 2378893 | 2022-09-29 | US | Virginia | Grayson | 51077 | 4938 | 84 | 0 | 36.65677234 | -81.23215889 | 2022-09-30 04:23:09 | Grayson, Virginia, US | |
1971348 | 1971348 | 2022-08-13 | US | Puerto Rico | Loiza | 72087 | 4938 | 0 | 0 | 18.425688 | -65.89943 | 2022-08-14 04:20:55 | Loiza, Puerto Rico, US | |
145059 | 145059 | 2022-07-09 | US | Texas | Deaf Smith | 48117 | 4938 | 114 | 0 | 34.96522957 | -102.6054267 | 2022-07-10 04:20:54 | Deaf Smith, Texas, US | |
2242166 | 2242166 | 2022-06-28 | US | Puerto Rico | Naguabo | 72103 | 4938 | 0 | 0 | 18.230637 | -65.753897 | 2022-06-29 04:20:59 | Naguabo, Puerto Rico, US | |
2240702 | 2240702 | 2022-06-28 | US | Kansas | Jefferson | 20087 | 4938 | 66 | 0 | 39.2347941 | -95.38289232 | 2022-06-29 04:20:59 | Jefferson, Kansas, US | |
2148944 | 2148944 | 2022-06-27 | US | Kansas | Jefferson | 20087 | 4938 | 66 | 0 | 39.2347941 | -95.38289232 | 2022-06-28 04:20:58 | Jefferson, Kansas, US | |
476745 | 476745 | 2022-06-26 | US | Kansas | Jefferson | 20087 | 4938 | 66 | 0 | 39.2347941 | -95.38289232 | 2022-06-27 04:21:00 | Jefferson, Kansas, US | |
940120 | 940120 | 2022-06-25 | US | Kansas | Jefferson | 20087 | 4938 | 66 | 0 | 39.2347941 | -95.38289232 | 2022-06-26 04:21:02 | Jefferson, Kansas, US | |
3347940 | 3347940 | 2022-06-24 | US | Kansas | Jefferson | 20087 | 4938 | 66 | 0 | 39.2347941 | -95.38289232 | 2022-06-25 04:20:57 | Jefferson, Kansas, US | |
1649681 | 1649681 | 2022-06-23 | US | Kansas | Jefferson | 20087 | 4938 | 66 | 0 | 39.2347941 | -95.38289232 | 2022-06-24 04:20:58 | Jefferson, Kansas, US | |
2188916 | 2188916 | 2022-06-22 | US | Kansas | Jefferson | 20087 | 4938 | 66 | 0 | 39.2347941 | -95.38289232 | 2022-06-23 04:20:55 | Jefferson, Kansas, US | |
168375 | 168375 | 2022-06-21 | US | North Carolina | Hertford | 37091 | 4938 | 86 | 0 | 36.3607755 | -76.98104134 | 2022-06-22 04:20:54 | Hertford, North Carolina, US | |
1765658 | 1765658 | 2022-06-20 | US | North Carolina | Hertford | 37091 | 4938 | 86 | 0 | 36.3607755 | -76.98104134 | 2022-06-21 04:20:56 | Hertford, North Carolina, US | |
1763809 | 1763809 | 2022-06-20 | US | Arkansas | Cross | 5037 | 4938 | 87 | 0 | 35.29631396 | -90.77185818 | 2022-06-21 04:20:56 | Cross, Arkansas, US | |
3271844 | 3271844 | 2022-06-19 | US | North Carolina | Hertford | 37091 | 4938 | 86 | 0 | 36.3607755 | -76.98104134 | 2022-06-20 04:21:01 | Hertford, North Carolina, US | |
3399756 | 3399756 | 2022-06-18 | US | North Carolina | Hertford | 37091 | 4938 | 86 | 0 | 36.3607755 | -76.98104134 | 2022-06-19 04:20:51 | Hertford, North Carolina, US | |
2313633 | 2313633 | 2022-06-17 | US | North Carolina | Hertford | 37091 | 4938 | 86 | 0 | 36.3607755 | -76.98104134 | 2022-06-18 04:21:10 | Hertford, North Carolina, US | |
561137 | 561137 | 2022-06-16 | US | North Carolina | Hertford | 37091 | 4938 | 86 | 0 | 36.3607755 | -76.98104134 | 2022-06-17 04:20:56 | Hertford, North Carolina, US | |
3984939 | 3984939 | 2022-06-15 | US | North Carolina | Hertford | 37091 | 4938 | 86 | 0 | 36.3607755 | -76.98104134 | 2022-06-16 04:20:55 | Hertford, North Carolina, US | |
974507 | 974507 | 2022-06-01 | US | Wisconsin | Taylor | 55119 | 4938 | 72 | 0 | 45.21179252 | -90.5004405 | 2022-06-02 05:20:39 | Taylor, Wisconsin, US | |
1699511 | 1699511 | 2022-04-28 | US | Texas | Milam | 48331 | 4938 | 102 | 0 | 30.7858183 | -96.97718698 | 2022-04-29 04:20:59 | Milam, Texas, US | |
3854994 | 3854994 | 2022-04-27 | US | Texas | Milam | 48331 | 4938 | 102 | 0 | 30.7858183 | -96.97718698 | 2022-04-28 04:20:47 | Milam, Texas, US | |
1329424 | 1329424 | 2022-04-26 | US | Texas | Milam | 48331 | 4938 | 102 | 0 | 30.78581830000001 | -96.97718698 | 2022-04-27 04:20:52 | Milam, Texas, US | |
3725378 | 3725378 | 2022-04-25 | US | Texas | Milam | 48331 | 4938 | 102 | 0 | 30.78581830000001 | -96.97718698 | 2022-04-26 04:20:51 | Milam, Texas, US | |
2031946 | 2031946 | 2022-04-24 | US | Texas | Milam | 48331 | 4938 | 102 | 0 | 30.78581830000001 | -96.97718698 | 2022-04-25 04:20:56 | Milam, Texas, US | |
749521 | 749521 | 2022-04-23 | US | Texas | Milam | 48331 | 4938 | 102 | 0 | 30.78581830000001 | -96.97718698 | 2022-04-24 04:20:56 | Milam, Texas, US | |
263097 | 263097 | 2022-03-15 | US | Maine | Sagadahoc | 23023 | 4938 | 28 | 0 | 43.95415864 | -69.85074999 | 2022-03-16 04:20:50 | Sagadahoc, Maine, US | |
920344 | 920344 | 2022-03-08 | US | Colorado | Teller | 8119 | 4938 | 57 | 0 | 38.88133511 | -105.16148929999999 | 2022-03-09 04:20:59 | Teller, Colorado, US | |
1548631 | 1548631 | 2022-03-07 | US | Colorado | Teller | 8119 | 4938 | 57 | 0 | 38.88133511 | -105.16148929999999 | 2022-03-08 04:20:54 | Teller, Colorado, US | |
2094877 | 2094877 | 2022-03-05 | US | Puerto Rico | San Lorenzo | 72129 | 4938 | 0 | 0 | 18.147987 | -65.976392 | 2022-03-06 04:20:49 | San Lorenzo, Puerto Rico, US | |
1994337 | 1994337 | 2022-03-01 | US | Michigan | Osceola | 26133 | 4938 | 77 | 0 | 43.98992088 | -85.32566756 | 2022-03-02 04:21:07 | Osceola, Michigan, US | |
944511 | 944511 | 2022-02-28 | US | Michigan | Osceola | 26133 | 4938 | 77 | 0 | 43.98992088 | -85.32566756 | 2022-03-01 04:21:09 | Osceola, Michigan, US | |
3915238 | 3915238 | 2022-02-20 | US | Texas | Scurry | 48415 | 4938 | 100 | 0 | 32.74613808 | -100.91626640000001 | 2022-02-21 04:21:05 | Scurry, Texas, US | |
2645043 | 2645043 | 2022-02-14 | US | Vermont | Orleans | 50019 | 4938 | 33 | 0 | 44.82964024 | -72.24562697 | 2022-02-15 04:21:09 | Orleans, Vermont, US | |
188782 | 188782 | 2022-02-13 | US | Pennsylvania | Wyoming | 42131 | 4938 | 97 | 0 | 41.51955538 | -76.01074915 | 2022-02-14 04:20:51 | Wyoming, Pennsylvania, US | |
1362804 | 1362804 | 2022-02-08 | US | Arizona | La Paz | 4012 | 4938 | 124 | 0 | 33.72854224 | -113.98100290000001 | 2022-02-09 04:21:04 | La Paz, Arizona, US | |
1319588 | 1319588 | 2022-01-26 | US | Kentucky | Bourbon | 21017 | 4938 | 45 | 0 | 38.2054607 | -84.21827874 | 2022-01-27 04:21:19 | Bourbon, Kentucky, US | |
1229508 | 1229508 | 2022-01-24 | US | Missouri | Crawford | 29055 | 4938 | 87 | 0 | 37.97663738 | -91.30528104 | 2022-01-25 04:21:05 | Crawford, Missouri, US | |
3614640 | 3614640 | 2022-01-12 | US | Maryland | Caroline | 24011 | 4938 | 59 | 0 | 38.87172293 | -75.82904158 | 2022-01-13 08:00:09 | Caroline, Maryland, US | |
1282934 | 1282934 | 2022-01-05 | US | Idaho | Latah | 16057 | 4938 | 41 | 0 | 46.81587887 | -116.71136979999999 | 2022-01-06 04:22:09 | Latah, Idaho, US | |
3521299 | 3521299 | 2022-01-02 | US | Mississippi | Yazoo | 28163 | 4938 | 94 | 0 | 32.77890365 | -90.39656148 | 2022-01-03 02:22:25 | Yazoo, Mississippi, US | |
2169429 | 2169429 | 2022-01-01 | US | Mississippi | Yazoo | 28163 | 4938 | 94 | 0 | 32.77890365 | -90.39656148 | 2022-01-02 04:20:52 | Yazoo, Mississippi, US | |
2778860 | 2778860 | 2021-12-31 | US | Mississippi | Yazoo | 28163 | 4938 | 94 | 0 | 32.77890365 | -90.39656148 | 2022-01-01 04:22:14 | Yazoo, Mississippi, US | |
4000517 | 4000517 | 2021-12-30 | US | Mississippi | Yazoo | 28163 | 4938 | 94 | 0 | 32.77890365 | -90.39656148 | 2021-12-31 04:21:50 | Yazoo, Mississippi, US | |
3606659 | 3606659 | 2021-12-25 | US | Maryland | Queen Anne's | 24035 | 4938 | 77 | 0 | 39.06198912 | -76.03530977 | 2021-12-26 04:21:50 | Queen Anne's, Maryland, US | |
1261310 | 1261310 | 2021-12-18 | US | Ohio | Van Wert | 39161 | 4938 | 112 | 0 | 40.8554138 | -84.59111700000003 | 2021-12-19 04:21:11 | Van Wert, Ohio, US | |
1260240 | 1260240 | 2021-12-18 | US | Kentucky | Montgomery | 21173 | 4938 | 70 | 0 | 38.03253032 | -83.9145241 | 2021-12-19 04:21:11 | Montgomery, Kentucky, US | |
1661265 | 1661265 | 2021-12-12 | US | Georgia | Lumpkin | 13187 | 4938 | 110 | 0 | 34.57286511 | -84.00425681 | 2021-12-13 04:22:02 | Lumpkin, Georgia, US | |
1665281 | 1665281 | 2021-12-11 | US | Georgia | Lumpkin | 13187 | 4938 | 110 | 0 | 34.57286511 | -84.00425681 | 2021-12-12 04:22:12 | Lumpkin, Georgia, US | |
3656433 | 3656433 | 2021-12-10 | US | Georgia | Lumpkin | 13187 | 4938 | 110 | 0 | 34.57286511 | -84.00425681 | 2021-12-11 04:22:45 | Lumpkin, Georgia, US | |
723905 | 723905 | 2021-11-20 | US | Kentucky | Grayson | 21085 | 4938 | 99 | 0 | 37.46231118 | -86.34248968 | 2021-11-21 04:22:13 | Grayson, Kentucky, US | |
716031 | 716031 | 2021-11-12 | US | Maine | Somerset | 23025 | 4938 | 54 | 0 | 45.51229767 | -69.95995554 | 2021-11-13 04:21:38 | Somerset, Maine, US | |
29981 | 29981 | 2021-11-11 | US | Maine | Somerset | 23025 | 4938 | 54 | 0 | 45.51229767 | -69.95995554 | 2021-11-12 04:22:01 | Somerset, Maine, US | |
498351 | 498351 | 2021-11-06 | US | Pennsylvania | Snyder | 42109 | 4938 | 106 | 0 | 40.77129231 | -77.06840691 | 2021-11-07 04:21:53 | Snyder, Pennsylvania, US | |
3512572 | 3512572 | 2021-11-01 | US | Iowa | Buena Vista | 19021 | 4938 | 47 | 0 | 42.73545875 | -95.15100162 | 2021-11-02 04:22:03 | Buena Vista, Iowa, US | |
289163 | 289163 | 2021-10-31 | US | Iowa | Buena Vista | 19021 | 4938 | 47 | 0 | 42.73545875 | -95.15100162 | 2021-11-01 04:22:01 | Buena Vista, Iowa, US | |
2722169 | 2722169 | 2021-10-30 | US | Iowa | Buena Vista | 19021 | 4938 | 47 | 0 | 42.73545875 | -95.15100162 | 2021-10-31 04:22:08 | Buena Vista, Iowa, US | |
568271 | 568271 | 2021-10-29 | US | Iowa | Buena Vista | 19021 | 4938 | 47 | 0 | 42.73545875 | -95.15100162 | 2021-10-30 04:22:03 | Buena Vista, Iowa, US | |
5513 | 5513 | 2021-10-28 | US | Iowa | Buena Vista | 19021 | 4938 | 47 | 0 | 42.73545875 | -95.15100162 | 2021-10-29 04:22:03 | Buena Vista, Iowa, US | |
535903 | 535903 | 2021-10-27 | US | Iowa | Buena Vista | 19021 | 4938 | 47 | 0 | 42.73545875 | -95.15100162 | 2021-10-28 04:22:08 | Buena Vista, Iowa, 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]);