johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
72 rows where confirmed = 10620 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2954960 | 2954960 | 2022-12-20 | US | Wisconsin | Oneida | 55085 | 10620 | 148 | 0 | 45.70677897 | -89.51944105 | 2022-12-21 04:21:03 | Oneida, Wisconsin, US | |
2509485 | 2509485 | 2022-11-10 | US | Virginia | Warren | 51187 | 10620 | 170 | 0 | 38.90847745 | -78.20280433 | 2022-11-11 04:21:22 | Warren, Virginia, US | |
434373 | 434373 | 2022-11-03 | US | Texas | Anderson | 48001 | 10620 | 251 | 0 | 31.81534745 | -95.65354823 | 2022-11-04 04:22:11 | Anderson, Texas, US | |
852615 | 852615 | 2022-11-02 | US | Texas | Anderson | 48001 | 10620 | 251 | 0 | 31.81534745 | -95.65354823 | 2022-11-03 04:22:05 | Anderson, Texas, US | |
713234 | 713234 | 2022-11-01 | US | Puerto Rico | San Lorenzo | 72129 | 10620 | 0 | 0 | 18.147987 | -65.976392 | 2022-11-02 04:22:09 | San Lorenzo, Puerto Rico, US | |
3287683 | 3287683 | 2022-10-31 | US | Puerto Rico | San Lorenzo | 72129 | 10620 | 0 | 0 | 18.147987 | -65.976392 | 2022-11-01 04:22:36 | San Lorenzo, Puerto Rico, US | |
4003138 | 4003138 | 2022-10-08 | US | Arkansas | Boone | 5009 | 10620 | 191 | 0 | 36.3084504 | -93.09374925 | 2022-10-09 04:21:16 | Boone, Arkansas, US | |
131395 | 131395 | 2022-10-04 | US | Colorado | Montrose | 8085 | 10620 | 174 | 0 | 38.40214114 | -108.2639022 | 2022-10-05 04:23:06 | Montrose, Colorado, US | |
373422 | 373422 | 2022-09-13 | US | Iowa | Marshall | 19127 | 10620 | 119 | 0 | 42.03586837 | -92.9990819 | 2022-09-14 04:20:44 | Marshall, Iowa, US | |
2396024 | 2396024 | 2022-09-12 | US | Iowa | Marshall | 19127 | 10620 | 119 | 0 | 42.03586837 | -92.9990819 | 2022-09-13 04:20:57 | Marshall, Iowa, US | |
3767102 | 3767102 | 2022-09-11 | US | Iowa | Marshall | 19127 | 10620 | 119 | 0 | 42.03586837 | -92.9990819 | 2022-09-12 04:20:58 | Marshall, Iowa, US | |
3825677 | 3825677 | 2022-09-10 | US | Iowa | Marshall | 19127 | 10620 | 119 | 0 | 42.03586837 | -92.9990819 | 2022-09-11 04:20:50 | Marshall, Iowa, US | |
964134 | 964134 | 2022-09-09 | US | Iowa | Marshall | 19127 | 10620 | 119 | 0 | 42.03586837 | -92.9990819 | 2022-09-10 04:21:10 | Marshall, Iowa, US | |
254536 | 254536 | 2022-09-08 | US | Iowa | Marshall | 19127 | 10620 | 119 | 0 | 42.03586837 | -92.9990819 | 2022-09-09 04:21:11 | Marshall, Iowa, US | |
3746334 | 3746334 | 2022-09-07 | US | Iowa | Marshall | 19127 | 10620 | 119 | 0 | 42.03586837 | -92.9990819 | 2022-09-08 04:21:02 | Marshall, Iowa, US | |
3745032 | 3745032 | 2022-09-07 | India | Andaman and Nicobar Islands | 10620 | 129 | 0 | 11.225999 | 92.968178 | 2022-09-08 04:21:02 | Andaman and Nicobar Islands, India | |||
3079583 | 3079583 | 2022-07-04 | US | Louisiana | Natchitoches | 22069 | 10620 | 169 | 0 | 31.72321584 | -93.09816516 | 2022-07-05 04:20:45 | Natchitoches, Louisiana, US | |
1768865 | 1768865 | 2022-07-03 | US | Louisiana | Natchitoches | 22069 | 10620 | 169 | 0 | 31.72321584 | -93.09816516 | 2022-07-04 04:20:54 | Natchitoches, Louisiana, US | |
3366851 | 3366851 | 2022-07-02 | US | Louisiana | Natchitoches | 22069 | 10620 | 169 | 0 | 31.72321584 | -93.09816516 | 2022-07-03 04:20:59 | Natchitoches, Louisiana, US | |
595180 | 595180 | 2022-07-01 | US | Louisiana | Natchitoches | 22069 | 10620 | 169 | 0 | 31.72321584 | -93.09816516 | 2022-07-02 04:21:16 | Natchitoches, Louisiana, US | |
1766299 | 1766299 | 2022-06-20 | US | Tennessee | Marshall | 47117 | 10620 | 125 | 0 | 35.45798777 | -86.76420988 | 2022-06-21 04:20:56 | Marshall, Tennessee, US | |
3581871 | 3581871 | 2022-06-02 | US | Texas | Uvalde | 48463 | 10620 | 145 | 0 | 29.35739637 | -99.76229172 | 2022-06-03 04:20:58 | Uvalde, Texas, US | |
3000087 | 3000087 | 2022-05-24 | US | Georgia | Coffee | 13069 | 10620 | 281 | 0 | 31.54892966 | -82.8549206 | 2022-05-25 04:20:56 | Coffee, Georgia, US | |
3593808 | 3593808 | 2022-05-23 | US | Georgia | Coffee | 13069 | 10620 | 281 | 0 | 31.54892966 | -82.8549206 | 2022-05-24 04:20:57 | Coffee, Georgia, US | |
1110356 | 1110356 | 2022-05-21 | US | Georgia | Coffee | 13069 | 10620 | 281 | 0 | 31.54892966 | -82.8549206 | 2022-05-22 04:20:52 | Coffee, Georgia, US | |
1169980 | 1169980 | 2022-05-20 | US | Georgia | Coffee | 13069 | 10620 | 281 | 0 | 31.54892966 | -82.8549206 | 2022-05-21 04:20:58 | Coffee, Georgia, US | |
3896743 | 3896743 | 2022-05-19 | US | Georgia | Coffee | 13069 | 10620 | 281 | 0 | 31.54892966 | -82.8549206 | 2022-05-20 04:20:57 | Coffee, Georgia, US | |
2084618 | 2084618 | 2022-05-15 | US | Colorado | Summit | 8117 | 10620 | 14 | 0 | 39.63803232 | -106.1150762 | 2022-05-16 04:20:47 | Summit, Colorado, US | |
3446613 | 3446613 | 2022-05-11 | US | Minnesota | Steele | 27147 | 10620 | 62 | 0 | 44.02240351 | -93.22627088 | 2022-05-12 04:20:54 | Steele, Minnesota, US | |
466185 | 466185 | 2022-05-02 | US | Puerto Rico | Vega Baja | 72145 | 10620 | 0 | 0 | 18.428262 | -66.397924 | 2022-05-03 04:21:00 | Vega Baja, Puerto Rico, US | |
2893701 | 2893701 | 2022-04-21 | US | Kansas | Ford | 20057 | 10620 | 115 | 0 | 37.69200114 | -99.88825298 | 2022-04-22 04:20:45 | Ford, Kansas, US | |
2308573 | 2308573 | 2022-04-20 | US | Kansas | Ford | 20057 | 10620 | 115 | 0 | 37.69200114 | -99.88825298 | 2022-04-21 04:20:46 | Ford, Kansas, US | |
2252712 | 2252712 | 2022-04-19 | US | Kansas | Ford | 20057 | 10620 | 115 | 0 | 37.69200114 | -99.88825298 | 2022-04-20 04:20:45 | Ford, Kansas, US | |
1847262 | 1847262 | 2022-04-18 | US | Kansas | Ford | 20057 | 10620 | 115 | 0 | 37.69200114 | -99.88825298 | 2022-04-19 04:21:00 | Ford, Kansas, US | |
3418206 | 3418206 | 2022-04-17 | US | Kansas | Ford | 20057 | 10620 | 115 | 0 | 37.69200114 | -99.88825298 | 2022-04-18 04:21:12 | Ford, Kansas, US | |
305155 | 305155 | 2022-04-16 | US | Kansas | Ford | 20057 | 10620 | 115 | 0 | 37.69200114 | -99.88825298 | 2022-04-17 04:20:59 | Ford, Kansas, US | |
2671100 | 2671100 | 2022-04-15 | US | Kansas | Ford | 20057 | 10620 | 115 | 0 | 37.69200114 | -99.88825298 | 2022-04-16 04:20:48 | Ford, Kansas, US | |
878878 | 878878 | 2022-03-27 | US | Oregon | Coos | 41011 | 10620 | 147 | 0 | 43.17406868 | -124.0594514 | 2022-03-28 04:20:33 | Coos, Oregon, US | |
2166161 | 2166161 | 2022-03-26 | US | Oregon | Coos | 41011 | 10620 | 147 | 0 | 43.17406868 | -124.0594514 | 2022-03-27 04:20:47 | Coos, Oregon, US | |
1723097 | 1723097 | 2022-03-25 | US | Oregon | Coos | 41011 | 10620 | 147 | 0 | 43.17406868 | -124.0594514 | 2022-03-26 04:20:23 | Coos, Oregon, US | |
1993014 | 1993014 | 2022-03-01 | US | Alabama | Chilton | 1021 | 10620 | 187 | 0 | 32.85044126 | -86.7173256 | 2022-03-02 04:21:07 | Chilton, Alabama, US | |
980523 | 980523 | 2022-02-01 | US | Maryland | Calvert | 24009 | 10620 | 128 | 0 | 38.53961642 | -76.56820632 | 2022-02-02 04:21:09 | Calvert, Maryland, US | |
1319705 | 1319705 | 2022-01-26 | US | Louisiana | Avoyelles | 22009 | 10620 | 185 | 0 | 31.07796211 | -92.00079449 | 2022-01-27 04:21:19 | Avoyelles, Louisiana, US | |
2906340 | 2906340 | 2021-12-19 | US | Oregon | Josephine | 41033 | 10620 | 259 | 0 | 42.3665549 | -123.5561938 | 2021-12-20 04:21:43 | Josephine, Oregon, US | |
1261413 | 1261413 | 2021-12-18 | US | Oregon | Josephine | 41033 | 10620 | 259 | 0 | 42.3665549 | -123.5561938 | 2021-12-19 04:21:11 | Josephine, Oregon, US | |
2401441 | 2401441 | 2021-12-17 | US | Oregon | Josephine | 41033 | 10620 | 259 | 0 | 42.3665549 | -123.5561938 | 2021-12-18 02:22:20 | Josephine, Oregon, US | |
3497102 | 3497102 | 2021-12-15 | US | Hawaii | Maui | 15009 | 10620 | 103 | 0 | 20.86399628 | -156.56890969999995 | 2021-12-16 04:22:11 | Maui, Hawaii, US | |
1016154 | 1016154 | 2021-11-21 | US | Mississippi | Lamar | 28073 | 10620 | 140 | 0 | 31.20572971 | -89.5077704 | 2021-11-22 04:22:20 | Lamar, Mississippi, US | |
724318 | 724318 | 2021-11-20 | US | Mississippi | Lamar | 28073 | 10620 | 140 | 0 | 31.20572971 | -89.5077704 | 2021-11-21 04:22:13 | Lamar, Mississippi, US | |
163848 | 163848 | 2021-11-19 | US | Mississippi | Lamar | 28073 | 10620 | 140 | 0 | 31.20572971 | -89.5077704 | 2021-11-20 04:22:17 | Lamar, Mississippi, US | |
2847827 | 2847827 | 2021-11-10 | US | Tennessee | McMinn | 47107 | 10620 | 136 | 0 | 35.42812616 | -84.61520715 | 2021-11-11 04:21:45 | McMinn, Tennessee, US | |
1238009 | 1238009 | 2021-09-27 | US | North Carolina | Sampson | 37163 | 10620 | 126 | 0 | 34.98820368 | -78.36914061 | 2021-09-28 04:21:28 | Sampson, North Carolina, US | |
3806126 | 3806126 | 2021-09-11 | Russia | Magadan Oblast | 10620 | 242 | 0 | 62.48858785 | 153.9903764 | 2021-09-12 04:21:13 | Magadan Oblast, Russia | |||
3298897 | 3298897 | 2021-07-30 | US | Puerto Rico | Bayamon | 72021 | 10620 | 0 | 0 | 18.34946 | -66.168435 | 2021-07-31 04:21:35 | Bayamon, Puerto Rico, US | |
1426997 | 1426997 | 2021-05-09 | US | Missouri | Franklin | 29071 | 10620 | 183 | 0 | 38.41127108 | -91.07522826 | 2021-05-10 04:20:38 | Franklin, Missouri, US | |
3113767 | 3113767 | 2021-05-06 | South Sudan | 10620 | 115 | 10312 | 193 | 6.877000000000002 | 31.307 | 2021-05-07 04:20:40 | South Sudan | |||
380732 | 380732 | 2021-04-30 | US | California | El Dorado | 6017 | 10620 | 110 | 0 | 38.77965956 | -120.5233166 | 2021-05-01 04:20:47 | El Dorado, California, US | |
2983335 | 2983335 | 2021-04-10 | Mexico | Chiapas | 10620 | 1524 | 0 | 9096 | 16.7569 | -93.1292 | 2021-04-11 04:20:56 | Chiapas, Mexico | ||
3085369 | 3085369 | 2021-04-05 | Mali | 10620 | 393 | 6989 | 3238 | 17.570692 | -3.996166000000001 | 2021-04-06 04:20:32 | Mali | |||
2783611 | 2783611 | 2021-03-24 | US | Oregon | Lane | 41039 | 10620 | 140 | 0 | 43.93727035 | -122.847753 | 2021-03-25 05:27:00 | Lane, Oregon, US | |
2211888 | 2211888 | 2021-01-30 | Russia | Mari El Republic | 10620 | 154 | 9288 | 1178 | 56.5767504 | 47.8817512 | 2021-01-31 05:22:42 | Mari El Republic, Russia | ||
437096 | 437096 | 2021-01-21 | US | Minnesota | Olmsted | 27109 | 10620 | 75 | 0 | 10545 | 44.00374114 | -92.40209944 | 2021-01-22 05:22:10 | Olmsted, Minnesota, US |
3517615 | 3517615 | 2021-01-15 | US | New York | Broome | 36007 | 10620 | 248 | 0 | 10372 | 42.15903158 | -75.81326086 | 2021-01-16 05:22:40 | Broome, New York, US |
1064045 | 1064045 | 2021-01-04 | US | New Mexico | San Juan | 35045 | 10620 | 301 | 0 | 10319 | 36.50838318 | -108.320437 | 2021-01-05 05:21:49 | San Juan, New Mexico, US |
3772098 | 3772098 | 2020-12-22 | US | New York | Dutchess | 36027 | 10620 | 217 | 0 | 10403 | 41.76486060000001 | -73.74356679 | 2020-12-23 05:22:03 | Dutchess, New York, US |
738965 | 738965 | 2020-12-02 | US | Delaware | Sussex | 10005 | 10620 | 277 | 0 | 10343 | 38.66143781 | -75.39031349 | 2020-12-03 05:28:22 | Sussex, Delaware, US |
1732048 | 1732048 | 2020-11-08 | US | Wisconsin | Racine | 55101 | 10620 | 126 | 0 | 10494 | 42.74753117 | -88.05941254 | 2020-11-09 05:25:45 | Racine, Wisconsin, US |
895568 | 895568 | 2020-11-05 | US | Washington | Spokane | 53063 | 10620 | 205 | 0 | 10415 | 47.62113146 | -117.4046494 | 2020-11-06 05:24:55 | Spokane, Washington, US |
892013 | 892013 | 2020-11-05 | France | French Guiana | 10620 | 70 | 9995 | 555 | 4.0 | -53.0 | 2020-11-06 05:24:55 | French Guiana, France | ||
3782452 | 3782452 | 2020-10-13 | US | California | Monterey | 6053 | 10620 | 78 | 0 | 10539 | 36.21862405 | -121.2413397 | 2020-10-14 04:24:05 | Monterey, California, US |
1480543 | 1480543 | 2020-08-21 | US | Illinois | Kane | 17089 | 10620 | 306 | 0 | 10314 | 41.93842729 | -88.42861412 | 2020-08-22 04:27:49 | Kane, Illinois, US |
1690260 | 1690260 | 2020-06-19 | US | New York | Orange | 36071 | 10620 | 473 | 0 | 10147 | 41.40337468 | -74.30240757 | 2020-06-20 04:33:19 | Orange, New York, 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]);