johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
143 rows where confirmed = 6175 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3177267 | 3177267 | 2022-12-19 | US | West Virginia | Brooke | 54009 | 6175 | 109 | 0 | 40.27367263 | -80.57915332 | 2022-12-20 04:21:04 | Brooke, West Virginia, US | |
1631703 | 1631703 | 2022-12-18 | US | Virginia | Powhatan | 51145 | 6175 | 68 | 0 | 37.55016038 | -77.91267882 | 2022-12-19 04:21:03 | Powhatan, Virginia, US | |
507082 | 507082 | 2022-12-17 | US | Virginia | Powhatan | 51145 | 6175 | 68 | 0 | 37.55016038 | -77.91267882 | 2022-12-18 04:21:03 | Powhatan, Virginia, US | |
3327654 | 3327654 | 2022-12-16 | US | Virginia | Powhatan | 51145 | 6175 | 68 | 0 | 37.55016038 | -77.91267882 | 2022-12-17 04:21:04 | Powhatan, Virginia, US | |
3717355 | 3717355 | 2022-12-06 | US | Texas | Moore | 48341 | 6175 | 114 | 0 | 35.83769242 | -101.8930281 | 2022-12-07 04:20:58 | Moore, Texas, US | |
2418060 | 2418060 | 2022-12-05 | US | Texas | Moore | 48341 | 6175 | 114 | 0 | 35.83769242 | -101.8930281 | 2022-12-06 04:21:03 | Moore, Texas, US | |
721668 | 721668 | 2022-12-04 | US | Texas | Moore | 48341 | 6175 | 114 | 0 | 35.83769242 | -101.8930281 | 2022-12-05 04:20:58 | Moore, Texas, US | |
2819957 | 2819957 | 2022-12-03 | US | Texas | Moore | 48341 | 6175 | 114 | 0 | 35.83769242 | -101.8930281 | 2022-12-04 04:20:56 | Moore, Texas, US | |
836813 | 836813 | 2022-12-02 | US | Texas | Moore | 48341 | 6175 | 114 | 0 | 35.83769242 | -101.8930281 | 2022-12-03 04:21:02 | Moore, Texas, US | |
2139343 | 2139343 | 2022-12-01 | US | Texas | Moore | 48341 | 6175 | 114 | 0 | 35.83769242 | -101.8930281 | 2022-12-02 04:21:07 | Moore, Texas, US | |
1967759 | 1967759 | 2022-11-30 | US | Texas | Moore | 48341 | 6175 | 114 | 0 | 35.83769242 | -101.8930281 | 2022-12-01 04:21:03 | Moore, Texas, US | |
2557758 | 2557758 | 2022-11-29 | US | Iowa | Bremer | 19017 | 6175 | 86 | 0 | 42.77461496 | -92.31795937 | 2022-11-30 04:21:07 | Bremer, Iowa, US | |
1240832 | 1240832 | 2022-11-28 | US | Iowa | Bremer | 19017 | 6175 | 86 | 0 | 42.77461496 | -92.31795937 | 2022-11-29 04:21:05 | Bremer, Iowa, US | |
3553459 | 3553459 | 2022-11-27 | US | Mississippi | Grenada | 28043 | 6175 | 136 | 0 | 33.77036166 | -89.80245083 | 2022-11-28 04:21:02 | Grenada, Mississippi, US | |
3552820 | 3552820 | 2022-11-27 | US | Iowa | Bremer | 19017 | 6175 | 86 | 0 | 42.77461496 | -92.31795937 | 2022-11-28 04:21:02 | Bremer, Iowa, US | |
2101939 | 2101939 | 2022-11-26 | US | Mississippi | Grenada | 28043 | 6175 | 136 | 0 | 33.77036166 | -89.80245083 | 2022-11-27 04:21:05 | Grenada, Mississippi, US | |
2101300 | 2101300 | 2022-11-26 | US | Iowa | Bremer | 19017 | 6175 | 86 | 0 | 42.77461496 | -92.31795937 | 2022-11-27 04:21:05 | Bremer, Iowa, US | |
489430 | 489430 | 2022-11-25 | US | Mississippi | Grenada | 28043 | 6175 | 136 | 0 | 33.77036166 | -89.80245083 | 2022-11-26 04:21:11 | Grenada, Mississippi, US | |
488791 | 488791 | 2022-11-25 | US | Iowa | Bremer | 19017 | 6175 | 86 | 0 | 42.77461496 | -92.31795937 | 2022-11-26 04:21:11 | Bremer, Iowa, US | |
3525259 | 3525259 | 2022-11-24 | US | Mississippi | Grenada | 28043 | 6175 | 136 | 0 | 33.77036166 | -89.80245083 | 2022-11-25 04:21:06 | Grenada, Mississippi, US | |
3524620 | 3524620 | 2022-11-24 | US | Iowa | Bremer | 19017 | 6175 | 86 | 0 | 42.77461496 | -92.31795937 | 2022-11-25 04:21:06 | Bremer, Iowa, US | |
3314042 | 3314042 | 2022-11-23 | US | Mississippi | Grenada | 28043 | 6175 | 136 | 0 | 33.77036166 | -89.80245083 | 2022-11-24 04:21:09 | Grenada, Mississippi, US | |
3313403 | 3313403 | 2022-11-23 | US | Iowa | Bremer | 19017 | 6175 | 86 | 0 | 42.77461496 | -92.31795937 | 2022-11-24 04:21:09 | Bremer, Iowa, US | |
1622083 | 1622083 | 2022-11-22 | US | Mississippi | Grenada | 28043 | 6175 | 136 | 0 | 33.77036166 | -89.80245083 | 2022-11-23 04:21:06 | Grenada, Mississippi, US | |
3462919 | 3462919 | 2022-11-21 | US | Puerto Rico | Lajas | 72079 | 6175 | 0 | 0 | 18.011661 | -67.040585 | 2022-11-22 04:20:47 | Lajas, Puerto Rico, US | |
3461971 | 3461971 | 2022-11-21 | US | Mississippi | Grenada | 28043 | 6175 | 136 | 0 | 33.77036166 | -89.80245083 | 2022-11-22 04:20:47 | Grenada, Mississippi, US | |
1643104 | 1643104 | 2022-11-20 | US | Puerto Rico | Lajas | 72079 | 6175 | 0 | 0 | 18.011661 | -67.040585 | 2022-11-21 04:21:05 | Lajas, Puerto Rico, US | |
1642156 | 1642156 | 2022-11-20 | US | Mississippi | Grenada | 28043 | 6175 | 136 | 0 | 33.77036166 | -89.80245083 | 2022-11-21 04:21:05 | Grenada, Mississippi, US | |
2065713 | 2065713 | 2022-11-19 | US | Mississippi | Grenada | 28043 | 6175 | 136 | 0 | 33.77036166 | -89.80245083 | 2022-11-20 04:21:08 | Grenada, Mississippi, US | |
1757107 | 1757107 | 2022-11-18 | US | Mississippi | Grenada | 28043 | 6175 | 136 | 0 | 33.77036166 | -89.80245083 | 2022-11-19 04:21:14 | Grenada, Mississippi, US | |
3028100 | 3028100 | 2022-11-17 | US | Mississippi | Grenada | 28043 | 6175 | 136 | 0 | 33.77036166 | -89.80245083 | 2022-11-18 04:21:15 | Grenada, Mississippi, US | |
2487811 | 2487811 | 2022-11-16 | US | Mississippi | Grenada | 28043 | 6175 | 136 | 0 | 33.77036166 | -89.80245083 | 2022-11-17 04:21:11 | Grenada, Mississippi, US | |
293822 | 293822 | 2022-11-15 | US | Mississippi | Grenada | 28043 | 6175 | 136 | 0 | 33.77036166 | -89.80245083 | 2022-11-16 04:21:09 | Grenada, Mississippi, US | |
2532387 | 2532387 | 2022-10-06 | US | Tennessee | Unicoi | 47171 | 6175 | 101 | 0 | 36.10890856 | -82.43709629 | 2022-10-07 04:23:08 | Unicoi, Tennessee, US | |
2326737 | 2326737 | 2022-08-24 | US | Virginia | Page | 51139 | 6175 | 124 | 0 | 38.61807452 | -78.48797204 | 2022-08-25 04:21:13 | Page, Virginia, US | |
2324914 | 2324914 | 2022-08-24 | US | Maine | Sagadahoc | 23023 | 6175 | 40 | 0 | 43.95415864 | -69.85074999 | 2022-08-25 04:21:13 | Sagadahoc, Maine, US | |
1608906 | 1608906 | 2022-07-20 | US | Colorado | Morgan | 8087 | 6175 | 138 | 0 | 40.2627981 | -103.8093302 | 2022-07-21 04:21:10 | Morgan, Colorado, US | |
3112579 | 3112579 | 2022-07-13 | US | Texas | Frio | 48163 | 6175 | 94 | 0 | 28.86751206 | -99.10804207 | 2022-07-14 04:20:57 | Frio, Texas, US | |
948792 | 948792 | 2022-06-14 | US | Missouri | Nodaway | 29147 | 6175 | 45 | 0 | 40.36079813 | -94.88133008 | 2022-06-15 04:20:54 | Nodaway, Missouri, US | |
2981200 | 2981200 | 2022-06-13 | US | Missouri | Nodaway | 29147 | 6175 | 45 | 0 | 40.36079813 | -94.88133008 | 2022-06-14 04:20:52 | Nodaway, Missouri, US | |
2237326 | 2237326 | 2022-06-12 | US | Missouri | Nodaway | 29147 | 6175 | 45 | 0 | 40.36079813 | -94.88133008 | 2022-06-13 04:21:14 | Nodaway, Missouri, US | |
3143524 | 3143524 | 2022-06-11 | US | Missouri | Nodaway | 29147 | 6175 | 45 | 0 | 40.36079813 | -94.88133008 | 2022-06-12 04:20:53 | Nodaway, Missouri, US | |
1946440 | 1946440 | 2022-06-10 | US | Missouri | Nodaway | 29147 | 6175 | 45 | 0 | 40.36079813 | -94.88133008 | 2022-06-11 04:21:01 | Nodaway, Missouri, US | |
3160769 | 3160769 | 2022-06-09 | US | Texas | Jasper | 48241 | 6175 | 187 | 0 | 30.74685667 | -94.02667579 | 2022-06-10 04:20:55 | Jasper, Texas, US | |
1112933 | 1112933 | 2022-05-21 | US | Virginia | Hopewell | 51670 | 6175 | 118 | 0 | 37.29186313 | -77.29754684 | 2022-05-22 04:20:52 | Hopewell, Virginia, US | |
1172557 | 1172557 | 2022-05-20 | US | Virginia | Hopewell | 51670 | 6175 | 118 | 0 | 37.29186313 | -77.29754684 | 2022-05-21 04:20:58 | Hopewell, Virginia, US | |
3584219 | 3584219 | 2022-05-17 | US | Maryland | Caroline | 24011 | 6175 | 80 | 0 | 38.87172293 | -75.82904158 | 2022-05-18 04:20:50 | Caroline, Maryland, US | |
1949428 | 1949428 | 2022-04-12 | US | Hawaii | Out of HI | 80015 | 6175 | 12 | 0 | 22.03935037 | 0.0 | 2022-04-13 04:21:03 | Out of HI, Hawaii, US | |
3207181 | 3207181 | 2022-04-11 | US | Hawaii | Out of HI | 80015 | 6175 | 12 | 0 | 22.03935037 | 0.0 | 2022-04-12 04:20:49 | Out of HI, Hawaii, US | |
1577067 | 1577067 | 2022-04-10 | US | Hawaii | Out of HI | 80015 | 6175 | 12 | 0 | 22.03935037 | 0.0 | 2022-04-11 04:21:02 | Out of HI, Hawaii, US | |
1653309 | 1653309 | 2022-04-09 | US | Hawaii | Out of HI | 80015 | 6175 | 12 | 0 | 22.03935037 | 0.0 | 2022-04-10 04:20:52 | Out of HI, Hawaii, US | |
2116631 | 2116631 | 2022-04-08 | US | Hawaii | Out of HI | 80015 | 6175 | 12 | 0 | 22.03935037 | 0.0 | 2022-04-09 04:20:42 | Out of HI, Hawaii, US | |
3323341 | 3323341 | 2022-04-07 | US | Texas | Gray | 48179 | 6175 | 124 | 0 | 35.40081878 | -100.8129222 | 2022-04-08 04:20:48 | Gray, Texas, US | |
3321155 | 3321155 | 2022-04-07 | US | Hawaii | Out of HI | 80015 | 6175 | 12 | 0 | 22.03935037 | 0.0 | 2022-04-08 04:20:48 | Out of HI, Hawaii, US | |
2803877 | 2803877 | 2022-04-06 | US | Texas | Gray | 48179 | 6175 | 124 | 0 | 35.40081878 | -100.8129222 | 2022-04-07 04:20:53 | Gray, Texas, US | |
2803771 | 2803771 | 2022-04-06 | US | Tennessee | Smith | 47159 | 6175 | 83 | 0 | 36.25359775 | -85.95411046 | 2022-04-07 04:20:53 | Smith, Tennessee, US | |
2801691 | 2801691 | 2022-04-06 | US | Hawaii | Out of HI | 80015 | 6175 | 12 | 0 | 22.03935037 | 0.0 | 2022-04-07 04:20:53 | Out of HI, Hawaii, US | |
3870646 | 3870646 | 2022-04-05 | US | Texas | Gray | 48179 | 6175 | 124 | 0 | 35.40081878 | -100.8129222 | 2022-04-06 04:20:49 | Gray, Texas, US | |
3870540 | 3870540 | 2022-04-05 | US | Tennessee | Smith | 47159 | 6175 | 83 | 0 | 36.25359775 | -85.95411046 | 2022-04-06 04:20:49 | Smith, Tennessee, US | |
2751988 | 2751988 | 2022-04-04 | US | Texas | Gray | 48179 | 6175 | 124 | 0 | 35.40081878 | -100.8129222 | 2022-04-05 04:20:48 | Gray, Texas, US | |
2751882 | 2751882 | 2022-04-04 | US | Tennessee | Smith | 47159 | 6175 | 83 | 0 | 36.25359775 | -85.95411046 | 2022-04-05 04:20:48 | Smith, Tennessee, US | |
3733228 | 3733228 | 2022-04-03 | US | Tennessee | Smith | 47159 | 6175 | 83 | 0 | 36.25359775 | -85.95411046 | 2022-04-04 04:20:51 | Smith, Tennessee, US | |
502663 | 502663 | 2022-04-02 | US | Tennessee | Smith | 47159 | 6175 | 83 | 0 | 36.25359775 | -85.95411046 | 2022-04-03 04:20:48 | Smith, Tennessee, US | |
3353648 | 3353648 | 2022-04-01 | US | Tennessee | Smith | 47159 | 6175 | 83 | 0 | 36.25359775 | -85.95411046 | 2022-04-02 04:20:47 | Smith, Tennessee, US | |
1542953 | 1542953 | 2022-03-31 | US | Tennessee | Smith | 47159 | 6175 | 83 | 0 | 36.25359775 | -85.95411046 | 2022-04-01 04:20:28 | Smith, Tennessee, US | |
2480966 | 2480966 | 2022-03-30 | US | Tennessee | Smith | 47159 | 6175 | 83 | 0 | 36.25359775 | -85.95411046 | 2022-03-31 04:20:56 | Smith, Tennessee, US | |
161007 | 161007 | 2022-03-29 | US | Tennessee | Smith | 47159 | 6175 | 83 | 0 | 36.25359775 | -85.95411046 | 2022-03-30 04:20:45 | Smith, Tennessee, US | |
3628960 | 3628960 | 2022-03-13 | US | Illinois | Jersey | 17083 | 6175 | 69 | 0 | 39.08869046 | -90.35393073 | 2022-03-14 04:20:46 | Jersey, Illinois, US | |
951868 | 951868 | 2022-03-12 | US | Illinois | Jersey | 17083 | 6175 | 69 | 0 | 39.08869046 | -90.35393073 | 2022-03-13 04:20:49 | Jersey, Illinois, US | |
357329 | 357329 | 2022-03-11 | US | Illinois | Jersey | 17083 | 6175 | 69 | 0 | 39.08869046 | -90.35393073 | 2022-03-12 04:20:50 | Jersey, Illinois, US | |
1551336 | 1551336 | 2022-03-07 | US | Virginia | Lee | 51105 | 6175 | 86 | 0 | 36.70586667 | -83.12606515 | 2022-03-08 04:20:54 | Lee, Virginia, US | |
1299609 | 1299609 | 2022-02-17 | US | Maine | Hancock | 23009 | 6175 | 75 | 0 | 44.59816444 | -68.38401854 | 2022-02-18 04:21:04 | Hancock, Maine, US | |
1287710 | 1287710 | 2022-01-04 | US | Minnesota | Carlton | 27017 | 6175 | 80 | 0 | 46.59180601 | -92.67601019 | 2022-01-05 04:21:59 | Carlton, Minnesota, US | |
1701379 | 1701379 | 2022-01-03 | US | Illinois | Morgan | 17137 | 6175 | 106 | 0 | 39.71654544 | -90.20255104 | 2022-01-04 04:22:17 | Morgan, Illinois, US | |
4001573 | 4001573 | 2021-12-30 | US | Tennessee | Carroll | 47017 | 6175 | 125 | 0 | 35.97366108 | -88.45189331 | 2021-12-31 04:21:50 | Carroll, Tennessee, US | |
732861 | 732861 | 2021-12-27 | US | North Carolina | Jackson | 37099 | 6175 | 76 | 0 | 35.28814273 | -83.14093385 | 2021-12-28 04:21:47 | Jackson, North Carolina, US | |
2114033 | 2114033 | 2021-12-26 | US | North Carolina | Jackson | 37099 | 6175 | 76 | 0 | 35.28814273 | -83.14093385 | 2021-12-27 04:21:58 | Jackson, North Carolina, US | |
3607405 | 3607405 | 2021-12-25 | US | North Carolina | Jackson | 37099 | 6175 | 76 | 0 | 35.28814273 | -83.14093385 | 2021-12-26 04:21:50 | Jackson, North Carolina, US | |
2965723 | 2965723 | 2021-12-24 | US | North Carolina | Jackson | 37099 | 6175 | 76 | 0 | 35.28814273 | -83.14093385 | 2021-12-25 04:21:37 | Jackson, North Carolina, US | |
3818755 | 3818755 | 2021-12-23 | US | North Carolina | Jackson | 37099 | 6175 | 76 | 0 | 35.28814273 | -83.14093385 | 2021-12-24 04:21:34 | Jackson, North Carolina, US | |
800763 | 800763 | 2021-12-22 | US | North Carolina | Jackson | 37099 | 6175 | 76 | 0 | 35.28814273 | -83.14093385 | 2021-12-23 04:21:21 | Jackson, North Carolina, US | |
1146420 | 1146420 | 2021-12-01 | US | Louisiana | Beauregard | 22011 | 6175 | 124 | 0 | 30.64836518 | -93.34173616 | 2021-12-02 04:22:37 | Beauregard, Louisiana, US | |
165110 | 165110 | 2021-11-19 | US | Texas | Erath | 48143 | 6175 | 105 | 0 | 32.23602653 | -98.21773417 | 2021-11-20 04:22:17 | Erath, Texas, US | |
30273 | 30273 | 2021-11-11 | US | Mississippi | Union | 28145 | 6175 | 94 | 0 | 34.49162015 | -89.00776006 | 2021-11-12 04:22:01 | Union, Mississippi, US | |
2846712 | 2846712 | 2021-11-10 | US | Mississippi | Union | 28145 | 6175 | 94 | 0 | 34.49162015 | -89.00776006 | 2021-11-11 04:21:45 | Union, Mississippi, US | |
700880 | 700880 | 2021-11-04 | US | Ohio | Highland | 39071 | 6175 | 114 | 0 | 39.1839264 | -83.60331456 | 2021-11-05 04:21:54 | Highland, Ohio, US | |
1493746 | 1493746 | 2021-10-12 | US | Nevada | Lyon | 32019 | 6175 | 99 | 0 | 39.01777974 | -119.18704790000001 | 2021-10-13 04:20:51 | Lyon, Nevada, US | |
1336849 | 1336849 | 2021-09-28 | US | Oklahoma | Mayes | 40097 | 6175 | 94 | 0 | 36.30179091 | -95.23175116 | 2021-09-29 04:21:45 | Mayes, Oklahoma, US | |
1238218 | 1238218 | 2021-09-27 | US | Oklahoma | Mayes | 40097 | 6175 | 94 | 0 | 36.30179091 | -95.23175116 | 2021-09-28 04:21:28 | Mayes, Oklahoma, US | |
2078519 | 2078519 | 2021-09-26 | US | Oklahoma | Mayes | 40097 | 6175 | 94 | 0 | 36.30179091 | -95.23175116 | 2021-09-27 04:21:16 | Mayes, Oklahoma, US | |
1727071 | 1727071 | 2021-09-25 | US | Oklahoma | Mayes | 40097 | 6175 | 94 | 0 | 36.30179091 | -95.23175116 | 2021-09-26 04:21:29 | Mayes, Oklahoma, US | |
1923791 | 1923791 | 2021-09-24 | US | Oklahoma | Mayes | 40097 | 6175 | 94 | 0 | 36.30179091 | -95.23175116 | 2021-09-25 04:21:31 | Mayes, Oklahoma, US | |
604262 | 604262 | 2021-09-23 | US | Oklahoma | Mayes | 40097 | 6175 | 94 | 0 | 36.30179091 | -95.23175116 | 2021-09-24 04:21:44 | Mayes, Oklahoma, US | |
3013906 | 3013906 | 2021-09-22 | US | Oklahoma | Mayes | 40097 | 6175 | 94 | 0 | 36.30179091 | -95.23175116 | 2021-09-23 04:21:43 | Mayes, Oklahoma, US | |
513310 | 513310 | 2021-08-19 | US | Michigan | Barry | 26015 | 6175 | 72 | 0 | 42.59513984 | -85.30834519 | 2021-08-20 04:21:33 | Barry, Michigan, US | |
2519789 | 2519789 | 2021-08-18 | US | Michigan | Barry | 26015 | 6175 | 72 | 0 | 42.59513984 | -85.30834519 | 2021-08-19 04:21:15 | Barry, Michigan, US | |
104419 | 104419 | 2021-08-15 | US | Indiana | Henry | 18065 | 6175 | 112 | 0 | 39.93029017 | -85.39625719 | 2021-08-16 04:21:31 | Henry, Indiana, US | |
508777 | 508777 | 2021-08-14 | US | Indiana | Henry | 18065 | 6175 | 112 | 0 | 39.93029017 | -85.39625719 | 2021-08-15 04:21:41 | Henry, Indiana, US | |
1484649 | 1484649 | 2021-08-13 | US | Indiana | Henry | 18065 | 6175 | 112 | 0 | 39.93029017 | -85.39625719 | 2021-08-14 04:21:25 | Henry, Indiana, US | |
1345590 | 1345590 | 2021-08-11 | US | Virginia | Augusta | 51015 | 6175 | 81 | 0 | 38.16404586 | -79.12461614 | 2021-08-12 04:21:25 | Augusta, Virginia, 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]);