johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
132 rows where confirmed = 6483 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1631869 | 1631869 | 2022-12-18 | US | Wisconsin | Langlade | 55067 | 6483 | 103 | 0 | 45.26271619 | -89.07483625 | 2022-12-19 04:21:03 | Langlade, Wisconsin, US | |
507248 | 507248 | 2022-12-17 | US | Wisconsin | Langlade | 55067 | 6483 | 103 | 0 | 45.26271619 | -89.07483625 | 2022-12-18 04:21:03 | Langlade, Wisconsin, US | |
3327820 | 3327820 | 2022-12-16 | US | Wisconsin | Langlade | 55067 | 6483 | 103 | 0 | 45.26271619 | -89.07483625 | 2022-12-17 04:21:04 | Langlade, Wisconsin, US | |
2559233 | 2559233 | 2022-11-29 | US | Oregon | Wasco | 41065 | 6483 | 73 | 0 | 45.16292781 | -121.1670954 | 2022-11-30 04:21:07 | Wasco, Oregon, US | |
1242307 | 1242307 | 2022-11-28 | US | Oregon | Wasco | 41065 | 6483 | 73 | 0 | 45.16292781 | -121.1670954 | 2022-11-29 04:21:05 | Wasco, Oregon, US | |
1240677 | 1240677 | 2022-11-28 | US | Illinois | Lawrence | 17101 | 6483 | 45 | 0 | 38.71987914 | -87.72884035 | 2022-11-29 04:21:05 | Lawrence, Illinois, US | |
3554295 | 3554295 | 2022-11-27 | US | Oregon | Wasco | 41065 | 6483 | 73 | 0 | 45.16292781 | -121.1670954 | 2022-11-28 04:21:02 | Wasco, Oregon, US | |
2102775 | 2102775 | 2022-11-26 | US | Oregon | Wasco | 41065 | 6483 | 73 | 0 | 45.16292781 | -121.1670954 | 2022-11-27 04:21:05 | Wasco, Oregon, US | |
490266 | 490266 | 2022-11-25 | US | Oregon | Wasco | 41065 | 6483 | 73 | 0 | 45.16292781 | -121.1670954 | 2022-11-26 04:21:11 | Wasco, Oregon, US | |
3526095 | 3526095 | 2022-11-24 | US | Oregon | Wasco | 41065 | 6483 | 73 | 0 | 45.16292781 | -121.1670954 | 2022-11-25 04:21:06 | Wasco, Oregon, US | |
3314878 | 3314878 | 2022-11-23 | US | Oregon | Wasco | 41065 | 6483 | 73 | 0 | 45.16292781 | -121.1670954 | 2022-11-24 04:21:09 | Wasco, Oregon, US | |
1050356 | 1050356 | 2022-11-06 | US | Arkansas | Ouachita | 5103 | 6483 | 119 | 0 | 33.58839816 | -92.87795984 | 2022-11-07 04:21:26 | Ouachita, Arkansas, US | |
542307 | 542307 | 2022-10-26 | US | Wisconsin | Iowa | 55049 | 6483 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-10-27 04:22:01 | Iowa, Wisconsin, US | |
133617 | 133617 | 2022-10-04 | US | South Dakota | Davison | 46035 | 6483 | 82 | 0 | 43.67490933 | -98.14458906 | 2022-10-05 04:23:06 | Davison, South Dakota, US | |
2688564 | 2688564 | 2022-10-03 | US | South Dakota | Davison | 46035 | 6483 | 82 | 0 | 43.67490933 | -98.14458906 | 2022-10-04 04:22:55 | Davison, South Dakota, US | |
2262631 | 2262631 | 2022-10-02 | US | South Dakota | Davison | 46035 | 6483 | 82 | 0 | 43.67490933 | -98.14458906 | 2022-10-03 04:23:11 | Davison, South Dakota, US | |
2998300 | 2998300 | 2022-10-01 | US | Tennessee | Wayne | 47181 | 6483 | 76 | 0 | 35.23868267 | -87.78644456 | 2022-10-02 04:21:23 | Wayne, Tennessee, US | |
2998157 | 2998157 | 2022-10-01 | US | South Dakota | Davison | 46035 | 6483 | 82 | 0 | 43.67490933 | -98.14458906 | 2022-10-02 04:21:23 | Davison, South Dakota, US | |
856626 | 856626 | 2022-09-30 | US | Tennessee | Wayne | 47181 | 6483 | 76 | 0 | 35.23868267 | -87.78644456 | 2022-10-01 04:23:01 | Wayne, Tennessee, US | |
856483 | 856483 | 2022-09-30 | US | South Dakota | Davison | 46035 | 6483 | 82 | 0 | 43.67490933 | -98.14458906 | 2022-10-01 04:23:01 | Davison, South Dakota, US | |
2378409 | 2378409 | 2022-09-29 | US | South Dakota | Davison | 46035 | 6483 | 82 | 0 | 43.67490933 | -98.14458906 | 2022-09-30 04:23:09 | Davison, South Dakota, US | |
1562960 | 1562960 | 2022-09-28 | US | South Dakota | Davison | 46035 | 6483 | 82 | 0 | 43.67490933 | -98.14458906 | 2022-09-29 04:22:34 | Davison, South Dakota, US | |
2019820 | 2019820 | 2022-09-20 | US | Texas | Frio | 48163 | 6483 | 95 | 0 | 28.86751206 | -99.10804207 | 2022-09-21 04:23:22 | Frio, Texas, US | |
3573693 | 3573693 | 2022-09-19 | US | Texas | Frio | 48163 | 6483 | 95 | 0 | 28.86751206 | -99.10804207 | 2022-09-20 04:22:48 | Frio, Texas, US | |
3768883 | 3768883 | 2022-09-11 | US | Tennessee | Union | 47173 | 6483 | 79 | 0 | 36.28590426 | -83.83651902 | 2022-09-12 04:20:58 | Union, Tennessee, US | |
3768096 | 3768096 | 2022-09-11 | US | New Mexico | Taos | 35055 | 6483 | 98 | 0 | 36.58006022 | -105.6310198 | 2022-09-12 04:20:58 | Taos, New Mexico, US | |
3827458 | 3827458 | 2022-09-10 | US | Tennessee | Union | 47173 | 6483 | 79 | 0 | 36.28590426 | -83.83651902 | 2022-09-11 04:20:50 | Union, Tennessee, US | |
3826671 | 3826671 | 2022-09-10 | US | New Mexico | Taos | 35055 | 6483 | 98 | 0 | 36.58006022 | -105.6310198 | 2022-09-11 04:20:50 | Taos, New Mexico, US | |
965128 | 965128 | 2022-09-09 | US | New Mexico | Taos | 35055 | 6483 | 98 | 0 | 36.58006022 | -105.6310198 | 2022-09-10 04:21:10 | Taos, New Mexico, US | |
3775040 | 3775040 | 2022-08-30 | US | Indiana | Randolph | 18135 | 6483 | 152 | 0 | 40.15734772 | -85.01139319 | 2022-08-31 04:20:57 | Randolph, Indiana, US | |
3774719 | 3774719 | 2022-08-30 | US | Georgia | Grady | 13131 | 6483 | 113 | 0 | 30.87454847 | -84.23418364 | 2022-08-31 04:20:57 | Grady, Georgia, US | |
1681636 | 1681636 | 2022-08-29 | US | Indiana | Randolph | 18135 | 6483 | 152 | 0 | 40.15734772 | -85.01139319 | 2022-08-30 04:21:03 | Randolph, Indiana, US | |
1681315 | 1681315 | 2022-08-29 | US | Georgia | Grady | 13131 | 6483 | 113 | 0 | 30.87454847 | -84.23418364 | 2022-08-30 04:21:03 | Grady, Georgia, US | |
1877799 | 1877799 | 2022-08-28 | US | Georgia | Grady | 13131 | 6483 | 113 | 0 | 30.87454847 | -84.23418364 | 2022-08-29 04:21:06 | Grady, Georgia, US | |
2096926 | 2096926 | 2022-08-27 | US | Georgia | Grady | 13131 | 6483 | 113 | 0 | 30.87454847 | -84.23418364 | 2022-08-28 04:21:02 | Grady, Georgia, US | |
1532741 | 1532741 | 2022-08-26 | US | Georgia | Grady | 13131 | 6483 | 113 | 0 | 30.87454847 | -84.23418364 | 2022-08-27 04:20:57 | Grady, Georgia, US | |
2829628 | 2829628 | 2022-08-25 | US | Georgia | Grady | 13131 | 6483 | 113 | 0 | 30.87454847 | -84.23418364 | 2022-08-26 04:21:02 | Grady, Georgia, US | |
2324161 | 2324161 | 2022-08-24 | US | Georgia | Grady | 13131 | 6483 | 113 | 0 | 30.87454847 | -84.23418364 | 2022-08-25 04:21:13 | Grady, Georgia, US | |
1164188 | 1164188 | 2022-08-18 | US | Texas | Austin | 48015 | 6483 | 78 | 0 | 29.88548725 | -96.27736949 | 2022-08-19 04:20:54 | Austin, Texas, US | |
1101220 | 1101220 | 2022-08-03 | US | Texas | Gray | 48179 | 6483 | 128 | 0 | 35.40081878 | -100.8129222 | 2022-08-04 04:20:58 | Gray, Texas, US | |
1407761 | 1407761 | 2022-08-02 | US | Puerto Rico | Aguas Buenas | 72007 | 6483 | 0 | 0 | 18.251619 | -66.126806 | 2022-08-03 04:20:59 | Aguas Buenas, Puerto Rico, US | |
1405863 | 1405863 | 2022-08-02 | US | Georgia | Harris | 13145 | 6483 | 118 | 0 | 32.73709786 | -84.90538572 | 2022-08-03 04:20:59 | Harris, Georgia, US | |
3619799 | 3619799 | 2022-08-01 | US | Puerto Rico | Aguas Buenas | 72007 | 6483 | 0 | 0 | 18.251619 | -66.126806 | 2022-08-02 04:20:53 | Aguas Buenas, Puerto Rico, US | |
3617901 | 3617901 | 2022-08-01 | US | Georgia | Harris | 13145 | 6483 | 118 | 0 | 32.73709786 | -84.90538572 | 2022-08-02 04:20:53 | Harris, Georgia, US | |
3872381 | 3872381 | 2022-07-31 | US | Georgia | Harris | 13145 | 6483 | 118 | 0 | 32.73709786 | -84.90538572 | 2022-08-01 04:21:03 | Harris, Georgia, US | |
675135 | 675135 | 2022-07-30 | US | Georgia | Harris | 13145 | 6483 | 118 | 0 | 32.73709786 | -84.90538572 | 2022-07-31 04:21:02 | Harris, Georgia, US | |
1784334 | 1784334 | 2022-07-29 | US | Georgia | Harris | 13145 | 6483 | 118 | 0 | 32.73709786 | -84.90538572 | 2022-07-30 04:20:42 | Harris, Georgia, US | |
1066697 | 1066697 | 2022-07-28 | US | Georgia | Harris | 13145 | 6483 | 118 | 0 | 32.73709786 | -84.90538572 | 2022-07-29 04:20:45 | Harris, Georgia, US | |
2336216 | 2336216 | 2022-07-27 | US | Georgia | Harris | 13145 | 6483 | 118 | 0 | 32.73709786 | -84.90538572 | 2022-07-28 04:20:56 | Harris, Georgia, US | |
960129 | 960129 | 2022-07-19 | US | Iowa | Plymouth | 19149 | 6483 | 104 | 0 | 42.737633 | -96.21366621 | 2022-07-20 04:20:59 | Plymouth, Iowa, US | |
3211516 | 3211516 | 2022-07-18 | US | Iowa | Plymouth | 19149 | 6483 | 104 | 0 | 42.737633 | -96.21366621 | 2022-07-19 04:20:58 | Plymouth, Iowa, US | |
3406691 | 3406691 | 2022-07-17 | US | Iowa | Plymouth | 19149 | 6483 | 104 | 0 | 42.737633 | -96.21366621 | 2022-07-18 04:20:59 | Plymouth, Iowa, US | |
2152891 | 2152891 | 2022-07-16 | US | Iowa | Plymouth | 19149 | 6483 | 104 | 0 | 42.737633 | -96.21366621 | 2022-07-17 04:21:15 | Plymouth, Iowa, US | |
2420124 | 2420124 | 2022-07-15 | US | Iowa | Plymouth | 19149 | 6483 | 104 | 0 | 42.737633 | -96.21366621 | 2022-07-16 04:21:05 | Plymouth, Iowa, US | |
3430199 | 3430199 | 2022-07-14 | US | Iowa | Plymouth | 19149 | 6483 | 104 | 0 | 42.737633 | -96.21366621 | 2022-07-15 04:20:53 | Plymouth, Iowa, US | |
3110719 | 3110719 | 2022-07-13 | US | Iowa | Plymouth | 19149 | 6483 | 104 | 0 | 42.737633 | -96.21366621 | 2022-07-14 04:20:57 | Plymouth, Iowa, US | |
2742061 | 2742061 | 2022-07-07 | US | Illinois | Shelby | 17173 | 6483 | 77 | 0 | 39.39133527 | -88.80611122 | 2022-07-08 04:20:56 | Shelby, Illinois, US | |
3508829 | 3508829 | 2022-06-05 | US | Kentucky | Marion | 21155 | 6483 | 85 | 0 | 37.55218078 | -85.26898542 | 2022-06-06 04:20:57 | Marion, Kentucky, US | |
3528906 | 3528906 | 2022-06-04 | US | Kentucky | Marion | 21155 | 6483 | 85 | 0 | 37.55218078 | -85.26898542 | 2022-06-05 04:20:55 | Marion, Kentucky, US | |
3134992 | 3134992 | 2022-06-03 | US | Kentucky | Marion | 21155 | 6483 | 85 | 0 | 37.55218078 | -85.26898542 | 2022-06-04 04:20:58 | Marion, Kentucky, US | |
3580067 | 3580067 | 2022-06-02 | US | Kentucky | Marion | 21155 | 6483 | 85 | 0 | 37.55218078 | -85.26898542 | 2022-06-03 04:20:58 | Marion, Kentucky, US | |
972360 | 972360 | 2022-06-01 | US | Kentucky | Marion | 21155 | 6483 | 85 | 0 | 37.55218078 | -85.26898542 | 2022-06-02 05:20:39 | Marion, Kentucky, US | |
230667 | 230667 | 2022-05-31 | US | Kentucky | Marion | 21155 | 6483 | 85 | 0 | 37.55218078 | -85.26898542 | 2022-06-01 04:20:55 | Marion, Kentucky, US | |
2999780 | 2999780 | 2022-05-24 | US | Arkansas | Cleburne | 5023 | 6483 | 128 | 0 | 35.53864922 | -92.02640019 | 2022-05-25 04:20:56 | Cleburne, Arkansas, US | |
3446368 | 3446368 | 2022-05-11 | US | Louisiana | Plaquemines | 22075 | 6483 | 45 | 0 | 29.42245447 | -89.60322085 | 2022-05-12 04:20:54 | Plaquemines, Louisiana, US | |
2893396 | 2893396 | 2022-04-21 | US | Illinois | Douglas | 17041 | 6483 | 55 | 0 | 39.76768052 | -88.21854195 | 2022-04-22 04:20:45 | Douglas, Illinois, US | |
877527 | 877527 | 2022-03-27 | US | Kansas | Barton | 20009 | 6483 | 89 | 0 | 38.47889676 | -98.75636726 | 2022-03-28 04:20:33 | Barton, Kansas, US | |
2164810 | 2164810 | 2022-03-26 | US | Kansas | Barton | 20009 | 6483 | 89 | 0 | 38.47889676 | -98.75636726 | 2022-03-27 04:20:47 | Barton, Kansas, US | |
1721746 | 1721746 | 2022-03-25 | US | Kansas | Barton | 20009 | 6483 | 89 | 0 | 38.47889676 | -98.75636726 | 2022-03-26 04:20:23 | Barton, Kansas, US | |
2141329 | 2141329 | 2022-03-09 | US | Indiana | Wells | 18179 | 6483 | 127 | 0 | 40.72934187 | -85.22132966 | 2022-03-10 04:20:48 | Wells, Indiana, US | |
920840 | 920840 | 2022-03-08 | US | Indiana | Wells | 18179 | 6483 | 127 | 0 | 40.72934187 | -85.22132966 | 2022-03-09 04:20:59 | Wells, Indiana, US | |
188273 | 188273 | 2022-02-13 | US | New Mexico | Luna | 35029 | 6483 | 115 | 0 | 32.18179341 | -107.75088259999998 | 2022-02-14 04:20:51 | Luna, New Mexico, US | |
318119 | 318119 | 2022-02-12 | US | New Mexico | Luna | 35029 | 6483 | 115 | 0 | 32.18179341 | -107.75088259999998 | 2022-02-13 04:21:00 | Luna, New Mexico, US | |
236370 | 236370 | 2022-02-11 | US | Texas | Hutchinson | 48233 | 6483 | 128 | 0 | 35.84006574 | -101.3546643 | 2022-02-12 04:21:06 | Hutchinson, Texas, US | |
235445 | 235445 | 2022-02-11 | US | New Mexico | Luna | 35029 | 6483 | 115 | 0 | 32.18179341 | -107.75088259999998 | 2022-02-12 04:21:06 | Luna, New Mexico, US | |
1297120 | 1297120 | 2022-02-05 | US | Texas | Fannin | 48147 | 6483 | 166 | 0 | 33.59564294 | -96.10751083 | 2022-02-06 04:21:00 | Fannin, Texas, US | |
981694 | 981694 | 2022-02-01 | US | Puerto Rico | Gurabo | 72063 | 6483 | 0 | 0 | 18.266461 | -65.97970500000001 | 2022-02-02 04:21:09 | Gurabo, Puerto Rico, US | |
1780674 | 1780674 | 2022-01-27 | US | Kansas | Franklin | 20059 | 6483 | 69 | 0 | 38.56443815 | -95.28644341 | 2022-01-28 04:21:09 | Franklin, Kansas, US | |
1319502 | 1319502 | 2022-01-26 | US | Kansas | Franklin | 20059 | 6483 | 69 | 0 | 38.56443815 | -95.28644341 | 2022-01-27 04:21:19 | Franklin, Kansas, US | |
1229101 | 1229101 | 2022-01-24 | US | Louisiana | Allen | 22003 | 6483 | 120 | 0 | 30.65385745 | -92.82442028 | 2022-01-25 04:21:05 | Allen, Louisiana, US | |
129756 | 129756 | 2022-01-09 | US | Texas | Bee | 48025 | 6483 | 137 | 0 | 28.41761668 | -97.74215593 | 2022-01-10 04:22:07 | Bee, Texas, US | |
2610095 | 2610095 | 2022-01-06 | Liechtenstein | 6483 | 71 | 0 | 47.14 | 9.55 | 2022-01-07 04:22:09 | Liechtenstein | ||||
1287479 | 1287479 | 2022-01-04 | US | Kentucky | Taylor | 21217 | 6483 | 102 | 0 | 37.3677562 | -85.3329931 | 2022-01-05 04:21:59 | Taylor, Kentucky, US | |
3522862 | 3522862 | 2022-01-02 | US | Virginia | York | 51199 | 6483 | 87 | 0 | 37.24374789 | -76.54412815 | 2022-01-03 02:22:25 | York, Virginia, US | |
2170992 | 2170992 | 2022-01-01 | US | Virginia | York | 51199 | 6483 | 87 | 0 | 37.24374789 | -76.54412815 | 2022-01-02 04:20:52 | York, Virginia, US | |
2780423 | 2780423 | 2021-12-31 | US | Virginia | York | 51199 | 6483 | 87 | 0 | 37.24374789 | -76.54412815 | 2022-01-01 04:22:14 | York, Virginia, US | |
3782 | 3782 | 2021-12-02 | US | Washington | Mason | 53045 | 6483 | 82 | 0 | 47.35007586 | -123.1863685 | 2021-12-03 04:23:05 | Mason, Washington, US | |
3493271 | 3493271 | 2021-10-26 | US | Indiana | Huntington | 18069 | 6483 | 100 | 0 | 40.82907273 | -85.48822092 | 2021-10-27 04:22:32 | Huntington, Indiana, US | |
684545 | 684545 | 2021-10-24 | US | New Mexico | Otero | 35035 | 6483 | 99 | 0 | 32.61348406 | -105.7417604 | 2021-10-25 04:22:31 | Otero, New Mexico, US | |
772553 | 772553 | 2021-10-23 | US | New Mexico | Otero | 35035 | 6483 | 99 | 0 | 32.61348406 | -105.7417604 | 2021-10-24 04:21:22 | Otero, New Mexico, US | |
656200 | 656200 | 2021-10-22 | US | New Mexico | Otero | 35035 | 6483 | 99 | 0 | 32.61348406 | -105.7417604 | 2021-10-23 04:21:32 | Otero, New Mexico, US | |
600525 | 600525 | 2021-10-19 | US | South Dakota | Brown | 46013 | 6483 | 99 | 0 | 45.58994323 | -98.35165355 | 2021-10-20 04:21:00 | Brown, South Dakota, US | |
2046702 | 2046702 | 2021-10-18 | US | South Dakota | Brown | 46013 | 6483 | 99 | 0 | 45.58994323 | -98.35165355 | 2021-10-19 04:20:54 | Brown, South Dakota, US | |
1912063 | 1912063 | 2021-10-17 | US | South Dakota | Brown | 46013 | 6483 | 99 | 0 | 45.58994323 | -98.35165355 | 2021-10-18 04:21:10 | Brown, South Dakota, US | |
937652 | 937652 | 2021-10-16 | US | South Dakota | Brown | 46013 | 6483 | 99 | 0 | 45.58994323 | -98.35165355 | 2021-10-17 04:21:29 | Brown, South Dakota, US | |
2946207 | 2946207 | 2021-10-15 | US | South Dakota | Brown | 46013 | 6483 | 99 | 0 | 45.58994323 | -98.35165355 | 2021-10-16 04:21:15 | Brown, South Dakota, US | |
494754 | 494754 | 2021-10-14 | US | Texas | Hill | 48217 | 6483 | 150 | 0 | 31.99045053 | -97.13423143 | 2021-10-15 04:21:26 | Hill, Texas, US | |
2962861 | 2962861 | 2021-10-08 | US | West Virginia | Jefferson | 54037 | 6483 | 80 | 0 | 39.30776166 | -77.86014147 | 2021-10-09 04:21:34 | Jefferson, West Virginia, US | |
17488 | 17488 | 2021-09-18 | US | Indiana | Shelby | 18145 | 6483 | 107 | 0 | 39.52305623 | -85.79158570000001 | 2021-09-19 04:21:34 | Shelby, Indiana, US | |
513383 | 513383 | 2021-08-19 | US | Michigan | St. Joseph | 26149 | 6483 | 104 | 0 | 41.91441767 | -85.52797979 | 2021-08-20 04:21:33 | St. Joseph, Michigan, 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]);