johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
83 rows where confirmed = 8740 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
311275 | 311275 | 2022-12-13 | US | Virginia | Orange | 51137 | 8740 | 103 | 0 | 38.24530219 | -78.015604 | 2022-12-14 04:21:04 | Orange, Virginia, US | |
712605 | 712605 | 2022-11-01 | US | Nevada | Unassigned | 90032 | 8740 | 0 | 0 | 41.40692186 | 0.0 | 2022-11-02 04:22:09 | Unassigned, Nevada, US | |
3287054 | 3287054 | 2022-10-31 | US | Nevada | Unassigned | 90032 | 8740 | 0 | 0 | 41.40692186 | 0.0 | 2022-11-01 04:22:36 | Unassigned, Nevada, US | |
322087 | 322087 | 2022-10-30 | US | Nevada | Unassigned | 90032 | 8740 | 0 | 0 | 41.40692186 | 0.0 | 2022-10-31 04:21:36 | Unassigned, Nevada, US | |
914363 | 914363 | 2022-10-29 | US | Nevada | Unassigned | 90032 | 8740 | 0 | 0 | 41.40692186 | 0.0 | 2022-10-30 04:22:14 | Unassigned, Nevada, US | |
1368632 | 1368632 | 2022-10-28 | US | Nevada | Unassigned | 90032 | 8740 | 0 | 0 | 41.40692186 | 0.0 | 2022-10-29 04:21:13 | Unassigned, Nevada, US | |
3040487 | 3040487 | 2022-10-27 | US | Nevada | Unassigned | 90032 | 8740 | 0 | 0 | 41.40692186 | 0.0 | 2022-10-28 04:22:31 | Unassigned, Nevada, US | |
540907 | 540907 | 2022-10-26 | US | Nevada | Unassigned | 90032 | 8740 | 0 | 0 | 41.40692186 | 0.0 | 2022-10-27 04:22:01 | Unassigned, Nevada, US | |
3251365 | 3251365 | 2022-10-11 | US | Iowa | Lee | 19111 | 8740 | 147 | 0 | 40.64181461 | -91.48183025 | 2022-10-12 04:22:51 | Lee, Iowa, US | |
2968624 | 2968624 | 2022-10-10 | US | Iowa | Lee | 19111 | 8740 | 147 | 0 | 40.64181461 | -91.48183025 | 2022-10-11 04:23:05 | Lee, Iowa, US | |
3098660 | 3098660 | 2022-10-09 | US | Iowa | Lee | 19111 | 8740 | 147 | 0 | 40.64181461 | -91.48183025 | 2022-10-10 04:22:32 | Lee, Iowa, US | |
4003885 | 4003885 | 2022-10-08 | US | Iowa | Lee | 19111 | 8740 | 147 | 0 | 40.64181461 | -91.48183025 | 2022-10-09 04:21:16 | Lee, Iowa, US | |
397482 | 397482 | 2022-10-07 | US | Iowa | Lee | 19111 | 8740 | 147 | 0 | 40.64181461 | -91.48183025 | 2022-10-08 04:22:56 | Lee, Iowa, US | |
2530599 | 2530599 | 2022-10-06 | US | Iowa | Lee | 19111 | 8740 | 147 | 0 | 40.64181461 | -91.48183025 | 2022-10-07 04:23:08 | Lee, Iowa, US | |
1814125 | 1814125 | 2022-10-05 | US | Virginia | Gloucester | 51073 | 8740 | 110 | 0 | 37.40809042 | -76.53524337 | 2022-10-06 04:21:22 | Gloucester, Virginia, US | |
1811993 | 1811993 | 2022-10-05 | US | Iowa | Lee | 19111 | 8740 | 147 | 0 | 40.64181461 | -91.48183025 | 2022-10-06 04:21:22 | Lee, Iowa, US | |
420827 | 420827 | 2022-09-18 | US | Louisiana | Allen | 22003 | 8740 | 143 | 0 | 30.65385745 | -92.82442028 | 2022-09-19 04:21:49 | Allen, Louisiana, US | |
3374851 | 3374851 | 2022-09-17 | US | Louisiana | Allen | 22003 | 8740 | 143 | 0 | 30.65385745 | -92.82442028 | 2022-09-18 04:22:50 | Allen, Louisiana, US | |
2356959 | 2356959 | 2022-09-16 | US | Louisiana | Allen | 22003 | 8740 | 143 | 0 | 30.65385745 | -92.82442028 | 2022-09-17 04:20:19 | Allen, Louisiana, US | |
2325926 | 2325926 | 2022-08-24 | US | Oklahoma | McCurtain | 40089 | 8740 | 166 | 0 | 34.11664328 | -94.77222373 | 2022-08-25 04:21:13 | McCurtain, Oklahoma, US | |
1253335 | 1253335 | 2022-08-23 | US | Oklahoma | McCurtain | 40089 | 8740 | 166 | 0 | 34.11664328 | -94.77222373 | 2022-08-24 04:20:46 | McCurtain, Oklahoma, US | |
2855439 | 2855439 | 2022-08-22 | US | Oklahoma | McCurtain | 40089 | 8740 | 166 | 0 | 34.11664328 | -94.77222373 | 2022-08-23 04:20:56 | McCurtain, Oklahoma, US | |
2405411 | 2405411 | 2022-08-21 | US | Oklahoma | McCurtain | 40089 | 8740 | 166 | 0 | 34.11664328 | -94.77222373 | 2022-08-22 04:20:38 | McCurtain, Oklahoma, US | |
3800489 | 3800489 | 2022-08-20 | US | Oklahoma | McCurtain | 40089 | 8740 | 166 | 0 | 34.11664328 | -94.77222373 | 2022-08-21 04:20:44 | McCurtain, Oklahoma, US | |
2366075 | 2366075 | 2022-08-19 | US | Oklahoma | McCurtain | 40089 | 8740 | 166 | 0 | 34.11664328 | -94.77222373 | 2022-08-20 04:21:01 | McCurtain, Oklahoma, US | |
1163746 | 1163746 | 2022-08-18 | US | Oklahoma | McCurtain | 40089 | 8740 | 166 | 0 | 34.11664328 | -94.77222373 | 2022-08-19 04:20:54 | McCurtain, Oklahoma, US | |
961600 | 961600 | 2022-07-19 | US | Pennsylvania | Tioga | 42117 | 8740 | 200 | 0 | 41.77255149 | -77.25433032 | 2022-07-20 04:20:59 | Tioga, Pennsylvania, US | |
3212987 | 3212987 | 2022-07-18 | US | Pennsylvania | Tioga | 42117 | 8740 | 200 | 0 | 41.77255149 | -77.25433032 | 2022-07-19 04:20:58 | Tioga, Pennsylvania, US | |
3408162 | 3408162 | 2022-07-17 | US | Pennsylvania | Tioga | 42117 | 8740 | 200 | 0 | 41.77255149 | -77.25433032 | 2022-07-18 04:20:59 | Tioga, Pennsylvania, US | |
2154362 | 2154362 | 2022-07-16 | US | Pennsylvania | Tioga | 42117 | 8740 | 200 | 0 | 41.77255149 | -77.25433032 | 2022-07-17 04:21:15 | Tioga, Pennsylvania, US | |
2421595 | 2421595 | 2022-07-15 | US | Pennsylvania | Tioga | 42117 | 8740 | 200 | 0 | 41.77255149 | -77.25433032 | 2022-07-16 04:21:05 | Tioga, Pennsylvania, US | |
3431670 | 3431670 | 2022-07-14 | US | Pennsylvania | Tioga | 42117 | 8740 | 200 | 0 | 41.77255149 | -77.25433032 | 2022-07-15 04:20:53 | Tioga, Pennsylvania, US | |
3112440 | 3112440 | 2022-07-13 | US | Tennessee | Henry | 47079 | 8740 | 165 | 0 | 36.33160906 | -88.30121797 | 2022-07-14 04:20:57 | Henry, Tennessee, US | |
3112190 | 3112190 | 2022-07-13 | US | Pennsylvania | Tioga | 42117 | 8740 | 200 | 0 | 41.77255149 | -77.25433032 | 2022-07-14 04:20:57 | Tioga, Pennsylvania, US | |
477676 | 477676 | 2022-06-26 | US | New York | Delaware | 36025 | 8740 | 78 | 0 | 42.19837623 | -74.96709306 | 2022-06-27 04:21:00 | Delaware, New York, US | |
1505883 | 1505883 | 2022-05-16 | US | New York | Wyoming | 36121 | 8740 | 84 | 0 | 42.70145109 | -78.22199579 | 2022-05-17 04:20:59 | Wyoming, New York, US | |
3870956 | 3870956 | 2022-04-05 | US | Virginia | Smyth | 51173 | 8740 | 170 | 0 | 36.84455636 | -81.53344948 | 2022-04-06 04:20:49 | Smyth, Virginia, US | |
2448994 | 2448994 | 2022-02-22 | US | New York | Allegany | 36003 | 8740 | 147 | 0 | 42.25748406 | -78.02750466 | 2022-02-23 04:21:09 | Allegany, New York, US | |
3076165 | 3076165 | 2022-02-09 | US | Nebraska | Scotts Bluff | 31157 | 8740 | 48 | 0 | 41.85070896 | -103.70809859999999 | 2022-02-10 04:21:14 | Scotts Bluff, Nebraska, US | |
980050 | 980050 | 2022-02-01 | US | Indiana | Jasper | 18073 | 8740 | 123 | 0 | 41.02078733 | -87.11553319 | 2022-02-02 04:21:09 | Jasper, Indiana, US | |
3301284 | 3301284 | 2022-01-30 | US | Indiana | Clinton | 18023 | 8740 | 101 | 0 | 40.30319754 | -86.47277257 | 2022-01-31 04:21:09 | Clinton, Indiana, US | |
3063075 | 3063075 | 2022-01-29 | US | Indiana | Clinton | 18023 | 8740 | 101 | 0 | 40.30319754 | -86.47277257 | 2022-01-30 04:21:26 | Clinton, Indiana, US | |
3811009 | 3811009 | 2022-01-28 | US | Indiana | Clinton | 18023 | 8740 | 101 | 0 | 40.30319754 | -86.47277257 | 2022-01-29 04:21:10 | Clinton, Indiana, US | |
1318244 | 1318244 | 2022-01-26 | Japan | Wakayama | 8740 | 64 | 0 | 33.911879 | 135.505446 | 2022-01-27 04:21:19 | Wakayama, Japan | |||
3689443 | 3689443 | 2022-01-13 | US | Missouri | Scott | 29201 | 8740 | 136 | 0 | 37.05588075 | -89.56474493 | 2022-01-14 04:21:54 | Scott, Missouri, US | |
130059 | 130059 | 2022-01-09 | US | Virginia | Culpeper | 51047 | 8740 | 96 | 0 | 38.48199985 | -77.95630870000002 | 2022-01-10 04:22:07 | Culpeper, Virginia, US | |
1218894 | 1218894 | 2022-01-08 | US | Virginia | Culpeper | 51047 | 8740 | 96 | 0 | 38.48199985 | -77.95630870000002 | 2022-01-09 04:21:46 | Culpeper, Virginia, US | |
1392987 | 1392987 | 2022-01-07 | US | Virginia | Culpeper | 51047 | 8740 | 96 | 0 | 38.48199985 | -77.95630870000002 | 2022-01-08 04:21:53 | Culpeper, Virginia, US | |
1286994 | 1286994 | 2022-01-04 | US | Illinois | Franklin | 17055 | 8740 | 131 | 0 | 37.99189086 | -88.92567818 | 2022-01-05 04:21:59 | Franklin, Illinois, US | |
1719708 | 1719708 | 2021-12-16 | US | Virginia | Harrisonburg | 51660 | 8740 | 114 | 0 | 38.43542574 | -78.87536254 | 2021-12-17 04:22:14 | Harrisonburg, Virginia, US | |
1741099 | 1741099 | 2021-12-05 | US | California | Mendocino | 6045 | 8740 | 99 | 0 | 39.4381191 | -123.39113130000001 | 2021-12-06 04:22:34 | Mendocino, California, US | |
469857 | 469857 | 2021-10-07 | US | Ohio | Belmont | 39013 | 8740 | 213 | 0 | 40.01625942 | -80.9924051 | 2021-10-08 04:21:25 | Belmont, Ohio, US | |
1337850 | 1337850 | 2021-09-28 | US | Wisconsin | Portage | 55097 | 8740 | 89 | 0 | 44.47558711 | -89.50152965 | 2021-09-29 04:21:45 | Portage, Wisconsin, US | |
2076778 | 2076778 | 2021-09-26 | US | Georgia | Laurens | 13175 | 8740 | 214 | 0 | 32.46325233 | -82.92221316 | 2021-09-27 04:21:16 | Laurens, Georgia, US | |
1725330 | 1725330 | 2021-09-25 | US | Georgia | Laurens | 13175 | 8740 | 214 | 0 | 32.46325233 | -82.92221316 | 2021-09-26 04:21:29 | Laurens, Georgia, US | |
1922050 | 1922050 | 2021-09-24 | US | Georgia | Laurens | 13175 | 8740 | 214 | 0 | 32.46325233 | -82.92221316 | 2021-09-25 04:21:31 | Laurens, Georgia, US | |
2282665 | 2282665 | 2021-09-08 | US | West Virginia | Raleigh | 54081 | 8740 | 114 | 0 | 37.76936795 | -81.2456041 | 2021-09-09 04:21:27 | Raleigh, West Virginia, US | |
643643 | 643643 | 2021-09-07 | US | Minnesota | Clay | 27027 | 8740 | 92 | 0 | 46.89289518 | -96.48761922 | 2021-09-08 04:21:31 | Clay, Minnesota, US | |
335058 | 335058 | 2021-08-04 | US | Texas | Liberty | 48291 | 8740 | 205 | 0 | 30.15152688 | -94.81205615 | 2021-08-05 04:21:51 | Liberty, Texas, US | |
1307245 | 1307245 | 2021-07-27 | US | Indiana | Hancock | 18059 | 8740 | 150 | 0 | 39.82304555 | -85.77566351 | 2021-07-28 04:21:39 | Hancock, Indiana, US | |
2950297 | 2950297 | 2021-07-16 | US | Tennessee | Hamblen | 47063 | 8740 | 174 | 0 | 36.21990035 | -83.26586179 | 2021-07-17 04:22:22 | Hamblen, Tennessee, US | |
1443216 | 1443216 | 2021-07-07 | US | Oregon | Umatilla | 41059 | 8740 | 88 | 0 | 45.59073056 | -118.7353826 | 2021-07-08 04:21:26 | Umatilla, Oregon, US | |
2296407 | 2296407 | 2021-06-24 | US | Illinois | Adams | 17001 | 8740 | 127 | 0 | 39.98815591 | -91.18786813 | 2021-06-25 04:21:33 | Adams, Illinois, US | |
2258639 | 2258639 | 2021-05-19 | US | Tennessee | Anderson | 47001 | 8740 | 172 | 0 | 36.12684348 | -84.19965764 | 2021-05-20 04:21:05 | Anderson, Tennessee, US | |
1411534 | 1411534 | 2021-04-23 | US | Ohio | Muskingum | 39119 | 8740 | 135 | 0 | 39.96575964 | -81.94363275 | 2021-04-24 04:20:38 | Muskingum, Ohio, US | |
3886304 | 3886304 | 2021-04-11 | US | Puerto Rico | Bayamon | 72021 | 8740 | 0 | 0 | 18.34946 | -66.168435 | 2021-04-12 04:21:00 | Bayamon, Puerto Rico, US | |
2250654 | 2250654 | 2021-04-07 | US | Utah | Central Utah | 8740 | 61 | 0 | 39.37231946 | -111.5758676 | 2021-04-08 04:21:13 | Central Utah, Utah, US | ||
1747365 | 1747365 | 2021-03-20 | US | South Carolina | Oconee | 45073 | 8740 | 131 | 0 | 34.75225169 | -83.06742317 | 2021-03-21 05:25:44 | Oconee, South Carolina, US | |
3669049 | 3669049 | 2021-03-06 | US | Kentucky | Madison | 21151 | 8740 | 90 | 0 | 8650 | 37.71659336 | -84.27220275 | 2021-03-07 05:21:54 | Madison, Kentucky, US |
3254569 | 3254569 | 2021-03-02 | US | Alaska | Matanuska-Susitna | 2170 | 8740 | 36 | 0 | 8704 | 62.31305045 | -149.5741743 | 2021-03-03 05:23:28 | Matanuska-Susitna, Alaska, US |
182783 | 182783 | 2021-02-21 | US | Georgia | Barrow | 13013 | 8740 | 114 | 0 | 8626 | 33.99148694 | -83.71436292 | 2021-02-22 05:24:21 | Barrow, Georgia, US |
614047 | 614047 | 2021-02-08 | US | Alabama | Cullman | 1043 | 8740 | 163 | 0 | 8577 | 34.13020303 | -86.86888037 | 2021-02-09 05:23:30 | Cullman, Alabama, US |
976477 | 976477 | 2021-02-06 | US | Maine | York | 23031 | 8740 | 108 | 0 | 8632 | 43.47808377 | -70.71052375 | 2021-02-07 05:23:00 | York, Maine, US |
2627096 | 2627096 | 2021-01-10 | US | Iowa | Pottawattamie | 19155 | 8740 | 104 | 0 | 8636 | 41.33640314 | -95.53907776 | 2021-01-11 05:21:50 | Pottawattamie, Iowa, US |
1035841 | 1035841 | 2020-12-15 | US | Kentucky | Warren | 21227 | 8740 | 83 | 0 | 8657 | 36.99903045 | -86.42672751 | 2020-12-16 05:28:04 | Warren, Kentucky, US |
2704495 | 2704495 | 2020-11-20 | US | Tennessee | Sumner | 47165 | 8740 | 131 | 0 | 8565 | 36.46824103 | -86.45917204 | 2020-11-21 05:25:51 | Sumner, Tennessee, US |
2191801 | 2191801 | 2020-10-21 | Russia | Karachay-Cherkess Republic | 8740 | 30 | 5186 | 3524 | 43.7368326 | 41.7267991 | 2020-10-22 04:24:27 | Karachay-Cherkess Republic, Russia | ||
2381786 | 2381786 | 2020-10-01 | US | New Jersey | Mercer | 34021 | 8740 | 636 | 0 | 8104 | 40.28047017 | -74.70479631 | 2020-10-02 04:23:51 | Mercer, New Jersey, US |
1045747 | 1045747 | 2020-09-30 | Haiti | 8740 | 227 | 6829 | 1684 | 18.9712 | -72.2852 | 2020-10-01 04:23:42 | Haiti | |||
966828 | 966828 | 2020-09-29 | Haiti | 8740 | 227 | 6757 | 1756 | 18.9712 | -72.2852 | 2020-09-30 04:23:33 | Haiti | |||
2684833 | 2684833 | 2020-07-06 | Russia | Irkutsk Oblast | 8740 | 69 | 3322 | 5349 | 56.6370122 | 104.719221 | 2020-07-07 04:34:00 | Irkutsk Oblast, Russia | ||
414235 | 414235 | 2020-07-05 | US | Massachusetts | Plymouth | 25023 | 8740 | 668 | 0 | 8072 | 41.94070556 | -70.80802823 | 2020-07-06 04:33:57 | Plymouth, Massachusetts, US |
589179 | 589179 | 2020-04-05 | Israel | 8740 | 56 | 820 | 7864 | 31.046051000000002 | 34.851612 | 2020-04-05 23:06:26 | Israel |
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]);