johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
134 rows where confirmed = 6194 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
311070 | 311070 | 2022-12-13 | US | Texas | Moore | 48341 | 6194 | 114 | 0 | 35.83769242 | -101.8930281 | 2022-12-14 04:21:04 | Moore, Texas, US | |
1152131 | 1152131 | 2022-12-12 | US | Texas | Moore | 48341 | 6194 | 114 | 0 | 35.83769242 | -101.8930281 | 2022-12-13 04:21:01 | Moore, Texas, US | |
871985 | 871985 | 2022-12-11 | US | Texas | Moore | 48341 | 6194 | 114 | 0 | 35.83769242 | -101.8930281 | 2022-12-12 04:21:01 | Moore, Texas, US | |
260515 | 260515 | 2022-12-10 | US | Texas | Moore | 48341 | 6194 | 114 | 0 | 35.83769242 | -101.8930281 | 2022-12-11 04:20:50 | Moore, Texas, US | |
3939229 | 3939229 | 2022-12-09 | US | Texas | Moore | 48341 | 6194 | 114 | 0 | 35.83769242 | -101.8930281 | 2022-12-10 04:21:02 | Moore, Texas, US | |
3380561 | 3380561 | 2022-12-08 | US | Texas | Moore | 48341 | 6194 | 114 | 0 | 35.83769242 | -101.8930281 | 2022-12-09 04:21:05 | Moore, Texas, US | |
1987832 | 1987832 | 2022-12-07 | US | Texas | Moore | 48341 | 6194 | 114 | 0 | 35.83769242 | -101.8930281 | 2022-12-08 04:21:07 | Moore, Texas, US | |
2486482 | 2486482 | 2022-11-16 | US | Arkansas | Conway | 5029 | 6194 | 74 | 0 | 35.26205537 | -92.70506566 | 2022-11-17 04:21:11 | Conway, Arkansas, US | |
2274195 | 2274195 | 2022-10-20 | US | New York | Schoharie | 36095 | 6194 | 39 | 0 | 42.58831742 | -74.4433903 | 2022-10-21 04:22:23 | Schoharie, New York, US | |
2161736 | 2161736 | 2022-10-16 | US | New Mexico | Lincoln | 35027 | 6194 | 70 | 0 | 33.74526079 | -105.4586166 | 2022-10-17 04:20:31 | Lincoln, New Mexico, US | |
517933 | 517933 | 2022-10-15 | US | New Mexico | Lincoln | 35027 | 6194 | 70 | 0 | 33.74526079 | -105.4586166 | 2022-10-16 04:22:39 | Lincoln, New Mexico, US | |
2034990 | 2034990 | 2022-10-14 | US | New Mexico | Lincoln | 35027 | 6194 | 70 | 0 | 33.74526079 | -105.4586166 | 2022-10-15 04:22:00 | Lincoln, New Mexico, US | |
993786 | 993786 | 2022-08-16 | US | Puerto Rico | Villalba | 72149 | 6194 | 0 | 0 | 18.127951 | -66.473115 | 2022-08-17 04:20:59 | Villalba, Puerto Rico, US | |
2496825 | 2496825 | 2022-08-15 | US | Puerto Rico | Villalba | 72149 | 6194 | 0 | 0 | 18.127951 | -66.473115 | 2022-08-16 04:20:58 | Villalba, Puerto Rico, US | |
1943269 | 1943269 | 2022-08-06 | US | Puerto Rico | Utuado | 72141 | 6194 | 0 | 0 | 18.271214 | -66.702984 | 2022-08-07 04:20:54 | Utuado, Puerto Rico, US | |
2337931 | 2337931 | 2022-07-27 | US | Oklahoma | Beckham | 40009 | 6194 | 107 | 0 | 35.26862449 | -99.68128023 | 2022-07-28 04:20:56 | Beckham, Oklahoma, US | |
1490121 | 1490121 | 2022-07-26 | US | Oklahoma | Beckham | 40009 | 6194 | 107 | 0 | 35.26862449 | -99.68128023 | 2022-07-27 04:21:04 | Beckham, Oklahoma, US | |
2596567 | 2596567 | 2022-07-25 | US | Oklahoma | Beckham | 40009 | 6194 | 107 | 0 | 35.26862449 | -99.68128023 | 2022-07-26 04:20:58 | Beckham, Oklahoma, US | |
898682 | 898682 | 2022-07-24 | US | Oklahoma | Beckham | 40009 | 6194 | 107 | 0 | 35.26862449 | -99.68128023 | 2022-07-25 04:20:51 | Beckham, Oklahoma, US | |
93676 | 93676 | 2022-07-23 | US | Oklahoma | Beckham | 40009 | 6194 | 107 | 0 | 35.26862449 | -99.68128023 | 2022-07-24 04:20:47 | Beckham, Oklahoma, US | |
902698 | 902698 | 2022-07-22 | US | Oklahoma | Beckham | 40009 | 6194 | 107 | 0 | 35.26862449 | -99.68128023 | 2022-07-23 04:20:53 | Beckham, Oklahoma, US | |
672834 | 672834 | 2022-07-21 | US | Oklahoma | Beckham | 40009 | 6194 | 107 | 0 | 35.26862449 | -99.68128023 | 2022-07-22 04:21:15 | Beckham, Oklahoma, US | |
3213691 | 3213691 | 2022-07-18 | US | Virginia | Salem | 51775 | 6194 | 99 | 0 | 37.2836193 | -80.06219455 | 2022-07-19 04:20:58 | Salem, Virginia, US | |
2742993 | 2742993 | 2022-07-07 | US | Missouri | Washington | 29221 | 6194 | 143 | 0 | 37.96130078 | -90.87948158 | 2022-07-08 04:20:56 | Washington, Missouri, US | |
1201788 | 1201788 | 2022-07-06 | US | Missouri | Washington | 29221 | 6194 | 143 | 0 | 37.96130078 | -90.87948158 | 2022-07-07 04:20:55 | Washington, Missouri, US | |
3968531 | 3968531 | 2022-07-05 | US | Missouri | Washington | 29221 | 6194 | 143 | 0 | 37.96130078 | -90.87948158 | 2022-07-06 04:20:58 | Washington, Missouri, US | |
3080042 | 3080042 | 2022-07-04 | US | Missouri | Washington | 29221 | 6194 | 143 | 0 | 37.96130078 | -90.87948158 | 2022-07-05 04:20:45 | Washington, Missouri, US | |
1769324 | 1769324 | 2022-07-03 | US | Missouri | Washington | 29221 | 6194 | 143 | 0 | 37.96130078 | -90.87948158 | 2022-07-04 04:20:54 | Washington, Missouri, US | |
3367310 | 3367310 | 2022-07-02 | US | Missouri | Washington | 29221 | 6194 | 143 | 0 | 37.96130078 | -90.87948158 | 2022-07-03 04:20:59 | Washington, Missouri, US | |
595639 | 595639 | 2022-07-01 | US | Missouri | Washington | 29221 | 6194 | 143 | 0 | 37.96130078 | -90.87948158 | 2022-07-02 04:21:16 | Washington, Missouri, US | |
1763824 | 1763824 | 2022-06-20 | US | Arkansas | Jackson | 5067 | 6194 | 64 | 0 | 35.59802983 | -91.21494602 | 2022-06-21 04:20:56 | Jackson, Arkansas, US | |
3270010 | 3270010 | 2022-06-19 | US | Arkansas | Jackson | 5067 | 6194 | 64 | 0 | 35.59802983 | -91.21494602 | 2022-06-20 04:21:01 | Jackson, Arkansas, US | |
2982682 | 2982682 | 2022-06-13 | US | Virginia | Waynesboro | 51820 | 6194 | 68 | 0 | 38.06451466 | -78.90293905 | 2022-06-14 04:20:52 | Waynesboro, Virginia, US | |
2982390 | 2982390 | 2022-06-13 | US | Texas | Jasper | 48241 | 6194 | 187 | 0 | 30.74685667 | -94.02667579 | 2022-06-14 04:20:52 | Jasper, Texas, US | |
3898957 | 3898957 | 2022-05-19 | US | Tennessee | Smith | 47159 | 6194 | 85 | 0 | 36.25359775 | -85.95411046 | 2022-05-20 04:20:57 | Smith, Tennessee, US | |
3447944 | 3447944 | 2022-05-11 | US | Texas | Gray | 48179 | 6194 | 125 | 0 | 35.40081878 | -100.8129222 | 2022-05-12 04:20:54 | Gray, Texas, US | |
3538561 | 3538561 | 2022-05-10 | US | Texas | Gray | 48179 | 6194 | 125 | 0 | 35.40081878 | -100.8129222 | 2022-05-11 04:20:48 | Gray, Texas, US | |
225096 | 225096 | 2022-05-09 | US | Texas | Gray | 48179 | 6194 | 125 | 0 | 35.40081878 | -100.8129222 | 2022-05-10 04:20:50 | Gray, Texas, US | |
224947 | 224947 | 2022-05-09 | US | Tennessee | Haywood | 47075 | 6194 | 102 | 0 | 35.58332824 | -89.28536625 | 2022-05-10 04:20:50 | Haywood, Tennessee, US | |
2334481 | 2334481 | 2022-05-08 | US | Texas | Gray | 48179 | 6194 | 125 | 0 | 35.40081878 | -100.8129222 | 2022-05-09 04:20:54 | Gray, Texas, US | |
363443 | 363443 | 2022-05-07 | US | Texas | Gray | 48179 | 6194 | 125 | 0 | 35.40081878 | -100.8129222 | 2022-05-08 04:20:49 | Gray, Texas, US | |
1400794 | 1400794 | 2022-05-06 | US | Texas | Gray | 48179 | 6194 | 125 | 0 | 35.40081878 | -100.8129222 | 2022-05-07 04:21:09 | Gray, Texas, US | |
2601149 | 2601149 | 2022-05-05 | US | Texas | Gray | 48179 | 6194 | 125 | 0 | 35.40081878 | -100.8129222 | 2022-05-06 04:21:00 | Gray, Texas, US | |
3268598 | 3268598 | 2022-05-04 | US | Texas | Gray | 48179 | 6194 | 125 | 0 | 35.40081878 | -100.8129222 | 2022-05-05 04:20:55 | Gray, Texas, US | |
1575237 | 1575237 | 2022-05-03 | US | Texas | Gray | 48179 | 6194 | 125 | 0 | 35.40081878 | -100.8129222 | 2022-05-04 04:20:59 | Gray, Texas, US | |
466497 | 466497 | 2022-05-02 | US | Texas | Gray | 48179 | 6194 | 125 | 0 | 35.40081878 | -100.8129222 | 2022-05-03 04:21:00 | Gray, Texas, US | |
3919136 | 3919136 | 2022-05-01 | US | Texas | Gray | 48179 | 6194 | 125 | 0 | 35.40081878 | -100.8129222 | 2022-05-02 04:21:10 | Gray, Texas, US | |
2843940 | 2843940 | 2022-04-30 | US | Texas | Gray | 48179 | 6194 | 125 | 0 | 35.40081878 | -100.8129222 | 2022-05-01 04:20:57 | Gray, Texas, US | |
1160253 | 1160253 | 2022-04-29 | US | Texas | Gray | 48179 | 6194 | 125 | 0 | 35.40081878 | -100.8129222 | 2022-04-30 04:21:05 | Gray, Texas, US | |
1158720 | 1158720 | 2022-04-29 | US | Maine | Waldo | 23027 | 6194 | 57 | 0 | 44.4858305 | -69.12061935 | 2022-04-30 04:21:05 | Waldo, Maine, US | |
1848954 | 1848954 | 2022-04-18 | US | Tennessee | Morgan | 47129 | 6194 | 86 | 0 | 36.13248031 | -84.64880098 | 2022-04-19 04:21:00 | Morgan, Tennessee, US | |
1577130 | 1577130 | 2022-04-10 | US | Illinois | Crawford | 17033 | 6194 | 45 | 0 | 39.0032229 | -87.75954624 | 2022-04-11 04:21:02 | Crawford, Illinois, US | |
1653372 | 1653372 | 2022-04-09 | US | Illinois | Crawford | 17033 | 6194 | 45 | 0 | 39.0032229 | -87.75954624 | 2022-04-10 04:20:52 | Crawford, Illinois, US | |
2116694 | 2116694 | 2022-04-08 | US | Illinois | Crawford | 17033 | 6194 | 45 | 0 | 39.0032229 | -87.75954624 | 2022-04-09 04:20:42 | Crawford, Illinois, US | |
2801824 | 2801824 | 2022-04-06 | US | Illinois | Shelby | 17173 | 6194 | 76 | 0 | 39.39133527 | -88.80611122 | 2022-04-07 04:20:53 | Shelby, Illinois, US | |
3868593 | 3868593 | 2022-04-05 | US | Illinois | Shelby | 17173 | 6194 | 76 | 0 | 39.39133527 | -88.80611122 | 2022-04-06 04:20:49 | Shelby, Illinois, US | |
2749935 | 2749935 | 2022-04-04 | US | Illinois | Shelby | 17173 | 6194 | 76 | 0 | 39.39133527 | -88.80611122 | 2022-04-05 04:20:48 | Shelby, Illinois, US | |
3023277 | 3023277 | 2022-03-23 | US | Illinois | Jersey | 17083 | 6194 | 69 | 0 | 39.08869046 | -90.35393073 | 2022-03-24 04:20:43 | Jersey, Illinois, US | |
3913487 | 3913487 | 2022-02-20 | US | Kentucky | Rowan | 21205 | 6194 | 52 | 0 | 38.19484205 | -83.42088935 | 2022-02-21 04:21:05 | Rowan, Kentucky, US | |
3877045 | 3877045 | 2022-02-19 | US | Kentucky | Rowan | 21205 | 6194 | 52 | 0 | 38.19484205 | -83.42088935 | 2022-02-20 04:21:00 | Rowan, Kentucky, US | |
3857301 | 3857301 | 2022-02-18 | US | Kentucky | Rowan | 21205 | 6194 | 52 | 0 | 38.19484205 | -83.42088935 | 2022-02-19 04:21:11 | Rowan, Kentucky, US | |
1467580 | 1467580 | 2022-02-10 | US | West Virginia | Mason | 54053 | 6194 | 85 | 0 | 38.77071799 | -82.02524219 | 2022-02-11 04:21:09 | Mason, West Virginia, US | |
2055191 | 2055191 | 2022-01-25 | US | Virginia | Botetourt | 51023 | 6194 | 70 | 0 | 37.55531756 | -79.80982182 | 2022-01-26 04:21:07 | Botetourt, Virginia, US | |
2054967 | 2054967 | 2022-01-25 | US | Texas | Fannin | 48147 | 6194 | 159 | 0 | 33.59564294 | -96.10751083 | 2022-01-26 04:21:07 | Fannin, Texas, US | |
3227293 | 3227293 | 2022-01-19 | US | Georgia | Madison | 13195 | 6194 | 85 | 0 | 34.12920917 | -83.21218732 | 2022-01-20 04:21:07 | Madison, Georgia, US | |
2779963 | 2779963 | 2021-12-31 | US | Tennessee | Marion | 47115 | 6194 | 109 | 0 | 35.12997174 | -85.62265895 | 2022-01-01 04:22:14 | Marion, Tennessee, US | |
1433938 | 1433938 | 2021-12-28 | US | Kentucky | Bell | 21013 | 6194 | 119 | 0 | 36.73355174 | -83.67766671 | 2021-12-29 03:21:43 | Bell, Kentucky, US | |
3498300 | 3498300 | 2021-12-15 | US | Nebraska | Platte | 31141 | 6194 | 50 | 0 | 41.57246836 | -97.52144359 | 2021-12-16 04:22:11 | Platte, Nebraska, US | |
140202 | 140202 | 2021-12-04 | US | New York | Cortland | 36023 | 6194 | 89 | 0 | 42.59509207 | -76.07048931 | 2021-12-05 04:22:25 | Cortland, New York, US | |
3404523 | 3404523 | 2021-11-30 | US | Texas | Erath | 48143 | 6194 | 106 | 0 | 32.23602653 | -98.21773417 | 2021-12-01 04:22:29 | Erath, Texas, US | |
3403948 | 3403948 | 2021-11-30 | US | Ohio | Preble | 39135 | 6194 | 144 | 0 | 39.7420247 | -84.64787018 | 2021-12-01 04:22:29 | Preble, Ohio, US | |
2846599 | 2846599 | 2021-11-10 | US | Minnesota | Morrison | 27097 | 6194 | 72 | 0 | 46.01265363 | -94.27341528 | 2021-11-11 04:21:45 | Morrison, Minnesota, US | |
3123982 | 3123982 | 2021-11-05 | US | Ohio | Highland | 39071 | 6194 | 114 | 0 | 39.1839264 | -83.60331456 | 2021-11-06 04:21:51 | Highland, Ohio, US | |
3494665 | 3494665 | 2021-10-26 | US | Ohio | Mercer | 39107 | 6194 | 98 | 0 | 40.54043046 | -84.62912742 | 2021-10-27 04:22:32 | Mercer, Ohio, US | |
2125462 | 2125462 | 2021-10-21 | US | Minnesota | Goodhue | 27049 | 6194 | 85 | 0 | 44.40849741 | -92.72341949999999 | 2021-10-22 04:21:14 | Goodhue, Minnesota, US | |
707967 | 707967 | 2021-09-29 | US | Louisiana | St. John the Baptist | 22095 | 6194 | 160 | 0 | 30.12597499 | -90.4753503 | 2021-09-30 04:21:20 | St. John the Baptist, Louisiana, US | |
2078797 | 2078797 | 2021-09-26 | US | South Dakota | Brown | 46013 | 6194 | 95 | 0 | 45.58994323 | -98.35165355 | 2021-09-27 04:21:16 | Brown, South Dakota, US | |
1727349 | 1727349 | 2021-09-25 | US | South Dakota | Brown | 46013 | 6194 | 95 | 0 | 45.58994323 | -98.35165355 | 2021-09-26 04:21:29 | Brown, South Dakota, US | |
1924069 | 1924069 | 2021-09-24 | US | South Dakota | Brown | 46013 | 6194 | 95 | 0 | 45.58994323 | -98.35165355 | 2021-09-25 04:21:31 | Brown, South Dakota, US | |
1921822 | 1921822 | 2021-09-24 | US | Colorado | Broomfield | 8014 | 6194 | 79 | 0 | 39.95998787 | -105.0566324 | 2021-09-25 04:21:31 | Broomfield, Colorado, US | |
1377608 | 1377608 | 2021-09-15 | US | Texas | Hill | 48217 | 6194 | 127 | 0 | 31.99045053 | -97.13423143 | 2021-09-16 04:22:19 | Hill, Texas, US | |
1388800 | 1388800 | 2021-09-13 | US | Texas | Medina | 48325 | 6194 | 138 | 0 | 29.355730100000002 | -99.11030298 | 2021-09-14 04:21:41 | Medina, Texas, US | |
2071504 | 2071504 | 2021-08-31 | US | Wyoming | Fremont | 56013 | 6194 | 96 | 0 | 43.04183996 | -108.6296893 | 2021-09-01 04:21:38 | Fremont, Wyoming, US | |
2069317 | 2069317 | 2021-08-31 | US | Kentucky | Hopkins | 21107 | 6194 | 161 | 0 | 37.30939025 | -87.54670406 | 2021-09-01 04:21:38 | Hopkins, Kentucky, US | |
3892810 | 3892810 | 2021-08-29 | US | Georgia | Thomas | 13275 | 6194 | 141 | 0 | 30.86392347 | -83.91847289 | 2021-08-30 04:21:23 | Thomas, Georgia, US | |
2793913 | 2793913 | 2021-08-28 | US | Georgia | Thomas | 13275 | 6194 | 141 | 0 | 30.86392347 | -83.91847289 | 2021-08-29 04:21:14 | Thomas, Georgia, US | |
2924072 | 2924072 | 2021-08-27 | US | Georgia | Thomas | 13275 | 6194 | 141 | 0 | 30.86392347 | -83.91847289 | 2021-08-28 04:21:28 | Thomas, Georgia, US | |
1483825 | 1483825 | 2021-08-13 | Saint Lucia | 6194 | 95 | 0 | 13.9094 | -60.9789 | 2021-08-14 04:21:25 | Saint Lucia | ||||
3141005 | 3141005 | 2021-07-23 | US | Washington | Skagit | 53057 | 6194 | 79 | 0 | 48.48171488 | -121.766131 | 2021-07-24 00:21:36 | Skagit, Washington, US | |
3479765 | 3479765 | 2021-07-22 | US | Washington | Skagit | 53057 | 6194 | 79 | 0 | 48.48171488 | -121.766131 | 2021-07-23 04:21:29 | Skagit, Washington, US | |
3333972 | 3333972 | 2021-07-21 | US | Ohio | Belmont | 39013 | 6194 | 179 | 0 | 40.01625942 | -80.9924051 | 2021-07-22 04:21:19 | Belmont, Ohio, US | |
3634658 | 3634658 | 2021-07-14 | US | Pennsylvania | Union | 42119 | 6194 | 89 | 0 | 40.96188846 | -77.05996014 | 2021-07-15 04:21:48 | Union, Pennsylvania, US | |
581533 | 581533 | 2021-07-13 | US | Pennsylvania | Union | 42119 | 6194 | 89 | 0 | 40.96188846 | -77.05996014 | 2021-07-14 04:21:35 | Union, Pennsylvania, US | |
3743782 | 3743782 | 2021-07-12 | US | Pennsylvania | Union | 42119 | 6194 | 89 | 0 | 40.96188846 | -77.05996014 | 2021-07-13 04:21:18 | Union, Pennsylvania, US | |
628116 | 628116 | 2021-07-10 | US | New York | Jefferson | 36045 | 6194 | 68 | 0 | 44.04200959 | -75.94653457 | 2021-07-11 04:21:43 | Jefferson, New York, US | |
831835 | 831835 | 2021-07-09 | US | New York | Jefferson | 36045 | 6194 | 68 | 0 | 44.04200959 | -75.94653457 | 2021-07-10 04:21:25 | Jefferson, New York, US | |
1165644 | 1165644 | 2021-07-04 | US | Arkansas | Crittenden | 5035 | 6194 | 97 | 0 | 35.21247318 | -90.30839406 | 2021-07-05 04:21:28 | Crittenden, Arkansas, US | |
1496078 | 1496078 | 2021-07-03 | US | Arkansas | Crittenden | 5035 | 6194 | 97 | 0 | 35.21247318 | -90.30839406 | 2021-07-04 04:21:38 | Crittenden, Arkansas, US | |
2072393 | 2072393 | 2021-07-02 | US | Arkansas | Crittenden | 5035 | 6194 | 97 | 0 | 35.21247318 | -90.30839406 | 2021-07-03 04:21:37 | Crittenden, Arkansas, US | |
1737075 | 1737075 | 2021-06-12 | US | California | San Benito | 6069 | 6194 | 63 | 0 | 36.60308176 | -121.069975 | 2021-06-13 04:22:44 | San Benito, California, 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]);