johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
92 rows where confirmed = 7543 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3225855 | 3225855 | 2022-12-25 | US | Virginia | Staunton | 51790 | 7543 | 132 | 0 | 38.15965544 | -79.05979937 | 2022-12-26 04:21:06 | Staunton, Virginia, US | |
1021769 | 1021769 | 2022-12-24 | US | Virginia | Staunton | 51790 | 7543 | 132 | 0 | 38.15965544 | -79.05979937 | 2022-12-25 04:21:04 | Staunton, Virginia, US | |
693792 | 693792 | 2022-12-23 | US | Virginia | Staunton | 51790 | 7543 | 132 | 0 | 38.15965544 | -79.05979937 | 2022-12-24 04:21:02 | Staunton, Virginia, US | |
2137164 | 2137164 | 2022-12-01 | US | Illinois | Jersey | 17083 | 7543 | 76 | 0 | 39.08869046 | -90.35393073 | 2022-12-02 04:21:07 | Jersey, Illinois, US | |
488173 | 488173 | 2022-11-25 | US | California | Glenn | 6021 | 7543 | 50 | 0 | 39.59875897 | -122.3938452 | 2022-11-26 04:21:11 | Glenn, California, US | |
2760350 | 2760350 | 2022-10-18 | US | Virginia | Winchester | 51840 | 7543 | 90 | 0 | 39.17054517 | -78.17325058 | 2022-10-19 04:22:26 | Winchester, Virginia, US | |
3746861 | 3746861 | 2022-09-07 | US | Minnesota | Nobles | 27105 | 7543 | 61 | 0 | 43.67434621 | -95.75329576 | 2022-09-08 04:21:02 | Nobles, Minnesota, US | |
116501 | 116501 | 2022-09-06 | US | Minnesota | Nobles | 27105 | 7543 | 61 | 0 | 43.67434621 | -95.75329576 | 2022-09-07 04:20:59 | Nobles, Minnesota, US | |
2635473 | 2635473 | 2022-09-05 | US | Minnesota | Nobles | 27105 | 7543 | 61 | 0 | 43.67434621 | -95.75329576 | 2022-09-06 04:21:02 | Nobles, Minnesota, US | |
2989037 | 2989037 | 2022-09-04 | US | Minnesota | Nobles | 27105 | 7543 | 61 | 0 | 43.67434621 | -95.75329576 | 2022-09-05 04:21:01 | Nobles, Minnesota, US | |
2714722 | 2714722 | 2022-09-03 | US | Minnesota | Nobles | 27105 | 7543 | 61 | 0 | 43.67434621 | -95.75329576 | 2022-09-04 04:21:22 | Nobles, Minnesota, US | |
1395427 | 1395427 | 2022-09-02 | US | Minnesota | Nobles | 27105 | 7543 | 61 | 0 | 43.67434621 | -95.75329576 | 2022-09-03 04:21:04 | Nobles, Minnesota, US | |
3549256 | 3549256 | 2022-09-01 | US | Minnesota | Nobles | 27105 | 7543 | 61 | 0 | 43.67434621 | -95.75329576 | 2022-09-02 04:21:07 | Nobles, Minnesota, US | |
671844 | 671844 | 2022-07-21 | US | Louisiana | Union | 22111 | 7543 | 137 | 0 | 32.83121059 | -92.3749373 | 2022-07-22 04:21:15 | Union, Louisiana, US | |
959669 | 959669 | 2022-07-19 | US | Georgia | Chattahoochee | 13053 | 7543 | 22 | 0 | 32.34341231 | -84.78809239 | 2022-07-20 04:20:59 | Chattahoochee, Georgia, US | |
3211056 | 3211056 | 2022-07-18 | US | Georgia | Chattahoochee | 13053 | 7543 | 22 | 0 | 32.34341231 | -84.78809239 | 2022-07-19 04:20:58 | Chattahoochee, Georgia, US | |
3406231 | 3406231 | 2022-07-17 | US | Georgia | Chattahoochee | 13053 | 7543 | 22 | 0 | 32.34341231 | -84.78809239 | 2022-07-18 04:20:59 | Chattahoochee, Georgia, US | |
2152431 | 2152431 | 2022-07-16 | US | Georgia | Chattahoochee | 13053 | 7543 | 22 | 0 | 32.34341231 | -84.78809239 | 2022-07-17 04:21:15 | Chattahoochee, Georgia, US | |
2419664 | 2419664 | 2022-07-15 | US | Georgia | Chattahoochee | 13053 | 7543 | 22 | 0 | 32.34341231 | -84.78809239 | 2022-07-16 04:21:05 | Chattahoochee, Georgia, US | |
3429739 | 3429739 | 2022-07-14 | US | Georgia | Chattahoochee | 13053 | 7543 | 22 | 0 | 32.34341231 | -84.78809239 | 2022-07-15 04:20:53 | Chattahoochee, Georgia, US | |
3110259 | 3110259 | 2022-07-13 | US | Georgia | Chattahoochee | 13053 | 7543 | 22 | 0 | 32.34341231 | -84.78809239 | 2022-07-14 04:20:57 | Chattahoochee, Georgia, US | |
3969808 | 3969808 | 2022-07-05 | US | Texas | Willacy | 48489 | 7543 | 133 | 0 | 26.47411727 | -97.61535848 | 2022-07-06 04:20:58 | Willacy, Texas, US | |
3081122 | 3081122 | 2022-07-04 | US | Texas | Cooke | 48097 | 7543 | 134 | 0 | 33.63979567 | -97.21240912 | 2022-07-05 04:20:45 | Cooke, Texas, US | |
1770404 | 1770404 | 2022-07-03 | US | Texas | Cooke | 48097 | 7543 | 134 | 0 | 33.63979567 | -97.21240912 | 2022-07-04 04:20:54 | Cooke, Texas, US | |
3368390 | 3368390 | 2022-07-02 | US | Texas | Cooke | 48097 | 7543 | 134 | 0 | 33.63979567 | -97.21240912 | 2022-07-03 04:20:59 | Cooke, Texas, US | |
596719 | 596719 | 2022-07-01 | US | Texas | Cooke | 48097 | 7543 | 134 | 0 | 33.63979567 | -97.21240912 | 2022-07-02 04:21:16 | Cooke, Texas, US | |
3448272 | 3448272 | 2022-05-11 | US | Virginia | Wythe | 51197 | 7543 | 149 | 0 | 36.91582035 | -81.07834059 | 2022-05-12 04:20:54 | Wythe, Virginia, US | |
1157789 | 1157789 | 2022-04-29 | US | Colorado | Logan | 8075 | 7543 | 109 | 0 | 40.7249637 | -103.110817 | 2022-04-30 04:21:05 | Logan, Colorado, US | |
1696971 | 1696971 | 2022-04-28 | US | Colorado | Logan | 8075 | 7543 | 109 | 0 | 40.7249637 | -103.110817 | 2022-04-29 04:20:59 | Logan, Colorado, US | |
1514382 | 1514382 | 2022-02-24 | US | Tennessee | McNairy | 47109 | 7543 | 113 | 0 | 35.17468549 | -88.5647812 | 2022-02-25 04:21:11 | McNairy, Tennessee, US | |
3075625 | 3075625 | 2022-02-09 | US | Maryland | Dorchester | 24019 | 7543 | 103 | 0 | 38.45413522 | -76.02752426 | 2022-02-10 04:21:14 | Dorchester, Maryland, US | |
2330561 | 2330561 | 2022-02-04 | US | Texas | Polk | 48373 | 7543 | 229 | 0 | 30.79472531 | -94.82766240000001 | 2022-02-05 04:21:05 | Polk, Texas, US | |
461206 | 461206 | 2022-02-02 | US | Mississippi | Lincoln | 28085 | 7543 | 145 | 0 | 31.53288662 | -90.45391915 | 2022-02-03 04:21:21 | Lincoln, Mississippi, US | |
2055365 | 2055365 | 2022-01-25 | US | West Virginia | Greenbrier | 54025 | 7543 | 124 | 0 | 37.9463652 | -80.45335881 | 2022-01-26 04:21:07 | Greenbrier, West Virginia, US | |
2054715 | 2054715 | 2022-01-25 | US | South Carolina | Marion | 45067 | 7543 | 150 | 0 | 34.07859748 | -79.36400756 | 2022-01-26 04:21:07 | Marion, South Carolina, US | |
1230446 | 1230446 | 2022-01-24 | US | South Carolina | Marion | 45067 | 7543 | 150 | 0 | 34.07859748 | -79.36400756 | 2022-01-25 04:21:05 | Marion, South Carolina, US | |
1143745 | 1143745 | 2022-01-23 | US | South Carolina | Marion | 45067 | 7543 | 150 | 0 | 34.07859748 | -79.36400756 | 2022-01-24 04:21:12 | Marion, South Carolina, US | |
2835934 | 2835934 | 2022-01-22 | US | Texas | Grimes | 48185 | 7543 | 111 | 0 | 30.54579585 | -95.98902499 | 2022-01-23 04:21:13 | Grimes, Texas, US | |
2835663 | 2835663 | 2022-01-22 | US | South Carolina | Marion | 45067 | 7543 | 150 | 0 | 34.07859748 | -79.36400756 | 2022-01-23 04:21:13 | Marion, South Carolina, US | |
3427781 | 3427781 | 2022-01-21 | US | South Carolina | Marion | 45067 | 7543 | 150 | 0 | 34.07859748 | -79.36400756 | 2022-01-22 04:21:13 | Marion, South Carolina, US | |
1964065 | 1964065 | 2022-01-20 | US | West Virginia | Preston | 54077 | 7543 | 112 | 0 | 39.46770987 | -79.66712803 | 2022-01-21 04:21:09 | Preston, West Virginia, US | |
1283147 | 1283147 | 2022-01-05 | US | Indiana | Whitley | 18183 | 7543 | 70 | 0 | 41.13863784 | -85.50791236 | 2022-01-06 04:22:09 | Whitley, Indiana, US | |
4001360 | 4001360 | 2021-12-30 | US | Pennsylvania | Wayne | 42127 | 7543 | 140 | 0 | 41.64938475 | -75.29956506 | 2021-12-31 04:21:50 | Wayne, Pennsylvania, US | |
731623 | 731623 | 2021-12-27 | US | Indiana | Harrison | 18061 | 7543 | 107 | 0 | 38.19467379 | -86.10948271 | 2021-12-28 04:21:47 | Harrison, Indiana, US | |
3603 | 3603 | 2021-12-02 | US | Utah | Summit | 49043 | 7543 | 19 | 0 | 40.86688146 | -110.9535882 | 2021-12-03 04:23:05 | Summit, Utah, US | |
151454 | 151454 | 2021-11-29 | US | Kentucky | Shelby | 21211 | 7543 | 115 | 0 | 38.21476019 | -85.194223 | 2021-11-30 04:22:53 | Shelby, Kentucky, US | |
1361012 | 1361012 | 2021-11-27 | US | Pennsylvania | Huntingdon | 42061 | 7543 | 177 | 0 | 40.42162652 | -77.97673273 | 2021-11-28 04:22:43 | Huntingdon, Pennsylvania, US | |
716707 | 716707 | 2021-11-12 | US | New York | Herkimer | 36043 | 7543 | 135 | 0 | 43.42034246 | -74.96145307 | 2021-11-13 04:21:38 | Herkimer, New York, US | |
2003349 | 2003349 | 2021-11-07 | US | Pennsylvania | Mifflin | 42087 | 7543 | 204 | 0 | 40.61116939 | -77.61070738 | 2021-11-08 04:21:43 | Mifflin, Pennsylvania, US | |
46543 | 46543 | 2021-11-02 | US | South Carolina | Newberry | 45071 | 7543 | 146 | 0 | 34.28629098 | -81.59935761 | 2021-11-03 06:22:09 | Newberry, South Carolina, US | |
598164 | 598164 | 2021-10-19 | US | Arkansas | Hot Spring | 5059 | 7543 | 105 | 0 | 34.31709259 | -92.95396325 | 2021-10-20 04:21:00 | Hot Spring, Arkansas, US | |
3009778 | 3009778 | 2021-10-11 | US | Ohio | Athens | 39009 | 7543 | 83 | 0 | 39.33425634 | -82.04278644 | 2021-10-12 04:21:09 | Athens, Ohio, US | |
3835759 | 3835759 | 2021-10-05 | US | Utah | TriCounty | 7543 | 59 | 0 | 40.12491499 | -109.5174415 | 2021-10-06 04:21:33 | TriCounty, Utah, US | ||
1336843 | 1336843 | 2021-09-28 | US | Oklahoma | Le Flore | 40079 | 7543 | 75 | 0 | 34.89851864 | -94.70392124 | 2021-09-29 04:21:45 | Le Flore, Oklahoma, US | |
1238212 | 1238212 | 2021-09-27 | US | Oklahoma | Le Flore | 40079 | 7543 | 75 | 0 | 34.89851864 | -94.70392124 | 2021-09-28 04:21:28 | Le Flore, Oklahoma, US | |
2078513 | 2078513 | 2021-09-26 | US | Oklahoma | Le Flore | 40079 | 7543 | 75 | 0 | 34.89851864 | -94.70392124 | 2021-09-27 04:21:16 | Le Flore, Oklahoma, US | |
1727065 | 1727065 | 2021-09-25 | US | Oklahoma | Le Flore | 40079 | 7543 | 75 | 0 | 34.89851864 | -94.70392124 | 2021-09-26 04:21:29 | Le Flore, Oklahoma, US | |
1923785 | 1923785 | 2021-09-24 | US | Oklahoma | Le Flore | 40079 | 7543 | 75 | 0 | 34.89851864 | -94.70392124 | 2021-09-25 04:21:31 | Le Flore, Oklahoma, US | |
604256 | 604256 | 2021-09-23 | US | Oklahoma | Le Flore | 40079 | 7543 | 75 | 0 | 34.89851864 | -94.70392124 | 2021-09-24 04:21:44 | Le Flore, Oklahoma, US | |
3013900 | 3013900 | 2021-09-22 | US | Oklahoma | Le Flore | 40079 | 7543 | 75 | 0 | 34.89851864 | -94.70392124 | 2021-09-23 04:21:43 | Le Flore, Oklahoma, US | |
2071304 | 2071304 | 2021-08-31 | US | Virginia | Rockingham | 51165 | 7543 | 116 | 0 | 38.51006137 | -78.87260325 | 2021-09-01 04:21:38 | Rockingham, Virginia, US | |
2923551 | 2923551 | 2021-08-27 | US | Alabama | Colbert | 1033 | 7543 | 152 | 0 | 34.69847452 | -87.80168544 | 2021-08-28 04:21:28 | Colbert, Alabama, US | |
1958777 | 1958777 | 2021-08-05 | US | New York | Ontario | 36069 | 7543 | 93 | 0 | 42.85145728 | -77.30874425 | 2021-08-06 04:21:18 | Ontario, New York, US | |
3707500 | 3707500 | 2021-07-17 | US | Kentucky | Bullitt | 21029 | 7543 | 83 | 0 | 37.97162523 | -85.68955617 | 2021-07-18 04:22:07 | Bullitt, Kentucky, US | |
403089 | 403089 | 2021-06-29 | US | South Carolina | Laurens | 45059 | 7543 | 173 | 0 | 34.48244419 | -82.00490796 | 2021-06-30 04:21:41 | Laurens, South Carolina, US | |
3128332 | 3128332 | 2021-06-28 | US | South Carolina | Laurens | 45059 | 7543 | 173 | 0 | 34.48244419 | -82.00490796 | 2021-06-29 04:21:28 | Laurens, South Carolina, US | |
3384642 | 3384642 | 2021-06-13 | US | Utah | Tooele | 49045 | 7543 | 44 | 0 | 40.44862644 | -113.1295715 | 2021-06-14 04:22:46 | Tooele, Utah, US | |
649478 | 649478 | 2021-05-05 | US | Wisconsin | Chippewa | 55017 | 7543 | 96 | 0 | 45.06939744 | -91.28068855 | 2021-05-06 04:20:38 | Chippewa, Wisconsin, US | |
648973 | 648973 | 2021-05-05 | US | Texas | Bowie | 48037 | 7543 | 214 | 0 | 33.44626922 | -94.41834132 | 2021-05-06 04:20:38 | Bowie, Texas, US | |
171122 | 171122 | 2021-04-16 | US | Indiana | Floyd | 18043 | 7543 | 176 | 0 | 38.32117957 | -85.90385377 | 2021-04-17 04:20:40 | Floyd, Indiana, US | |
2575195 | 2575195 | 2021-04-13 | US | West Virginia | Wood | 54107 | 7543 | 166 | 0 | 39.20967886 | -81.5162836 | 2021-04-14 04:20:41 | Wood, West Virginia, US | |
3424372 | 3424372 | 2021-03-19 | US | Washington | Thurston | 53067 | 7543 | 81 | 0 | 46.9291895 | -122.8290656 | 2021-03-20 05:25:46 | Thurston, Washington, US | |
2369063 | 2369063 | 2021-02-28 | US | Maryland | Carroll | 24013 | 7543 | 214 | 0 | 7329 | 39.56453592 | -77.02373735 | 2021-03-01 05:23:01 | Carroll, Maryland, US |
3053856 | 3053856 | 2021-02-16 | Malaysia | Perak | 7543 | 36 | 6330 | 1177 | 4.5921 | 101.0901 | 2021-02-17 05:23:10 | Perak, Malaysia | ||
3052459 | 3052459 | 2021-02-16 | US | North Carolina | Brunswick | 37019 | 7543 | 121 | 0 | 7422 | 34.070565 | -78.22814204 | 2021-02-17 05:23:10 | Brunswick, North Carolina, US |
3052156 | 3052156 | 2021-02-16 | US | Montana | Cascade | 30013 | 7543 | 149 | 0 | 7394 | 47.30797024 | -111.3467922 | 2021-02-17 05:23:10 | Cascade, Montana, US |
342155 | 342155 | 2021-02-03 | US | Missouri | Clay | 29047 | 7543 | 128 | 0 | 7415 | 39.31132056 | -94.41850862 | 2021-02-04 05:22:26 | Clay, Missouri, US |
1688102 | 1688102 | 2021-02-02 | US | Wyoming | Natrona | 56025 | 7543 | 121 | 0 | 7422 | 42.96180148 | -106.797885 | 2021-02-03 05:22:52 | Natrona, Wyoming, US |
14345 | 14345 | 2021-01-26 | US | Montana | Missoula | 30063 | 7543 | 78 | 0 | 7465 | 47.03728583 | -113.92135079999998 | 2021-01-27 05:23:41 | Missoula, Montana, US |
2350388 | 2350388 | 2020-12-07 | US | Tennessee | Montgomery | 47125 | 7543 | 95 | 0 | 7429 | 36.49609412 | -87.38550661 | 2020-12-08 05:27:42 | Montgomery, Tennessee, US |
3860871 | 3860871 | 2020-12-04 | US | Illinois | Tazewell | 17179 | 7543 | 109 | 0 | 7434 | 40.50716185 | -89.51404662 | 2020-12-05 05:27:36 | Tazewell, Illinois, US |
738008 | 738008 | 2020-12-02 | Bahamas | 7543 | 163 | 5934 | 1446 | 25.025885 | -78.035889 | 2020-12-03 05:28:22 | Bahamas | |||
2537102 | 2537102 | 2020-12-01 | Bahamas | 7543 | 163 | 5934 | 1446 | 25.025885 | -78.035889 | 2020-12-02 05:27:41 | Bahamas | |||
3838993 | 3838993 | 2020-11-21 | US | Ohio | Warren | 39165 | 7543 | 91 | 0 | 7452 | 39.42581994 | -84.16557457 | 2020-11-22 05:25:45 | Warren, Ohio, US |
376364 | 376364 | 2020-11-06 | Russia | Amur Oblast | 7543 | 68 | 5976 | 1499 | 52.8032368 | 128.437295 | 2020-11-07 05:24:52 | Amur Oblast, Russia | ||
3409521 | 3409521 | 2020-11-01 | Mexico | Chiapas | 7543 | 1069 | 6366 | 108 | 16.7569 | -93.1292 | 2020-11-02 05:25:04 | Chiapas, Mexico | ||
427841 | 427841 | 2020-09-07 | US | Arkansas | Pulaski | 5119 | 7543 | 113 | 0 | 7430 | 34.77054088 | -92.31355101 | 2020-09-08 04:28:25 | Pulaski, Arkansas, US |
2512814 | 2512814 | 2020-08-27 | US | Pennsylvania | Bucks | 42017 | 7543 | 585 | 0 | 6958 | 40.33682119 | -75.10836643 | 2020-08-28 04:28:11 | Bucks, Pennsylvania, US |
583031 | 583031 | 2020-08-13 | Russia | Kaluga Oblast | 7543 | 58 | 6280 | 1205 | 54.4382773 | 35.5272854 | 2020-08-14 04:51:19 | Kaluga Oblast, Russia | ||
2740331 | 2740331 | 2020-08-03 | Germany | Rheinland-Pfalz | 7543 | 239 | 7027 | 277 | 50.1183 | 7.309 | 2020-08-04 04:41:59 | Rheinland-Pfalz, Germany | ||
121976 | 121976 | 2020-07-19 | Netherlands | Noord-Holland | 7543 | 816 | 0 | 6709 | 52.60090600000001 | 4.9186879999999995 | 2020-07-20 05:34:40 | Noord-Holland, Netherlands | ||
1787974 | 1787974 | 2020-05-29 | US | Illinois | DuPage | 17043 | 7543 | 362 | 0 | 7181 | 41.85116968 | -88.08642662 | 2020-05-30 02:32:48 | DuPage, Illinois, 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]);