johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
172 rows where confirmed = 5090 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 9
- US 143
- San Marino 19
- Colombia 2
- Mexico 2
- Russia 2
- Australia 1
- Japan 1
- Kazakhstan 1
- Senegal 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
292815 | 292815 | 2022-11-15 | US | Georgia | Elbert | 13105 | 5090 | 119 | 0 | 34.11302332 | -82.83936148 | 2022-11-16 04:21:09 | Elbert, Georgia, US | |
3597845 | 3597845 | 2022-11-14 | US | Georgia | Elbert | 13105 | 5090 | 119 | 0 | 34.11302332 | -82.83936148 | 2022-11-15 04:21:16 | Elbert, Georgia, US | |
312703 | 312703 | 2022-11-13 | US | Georgia | Elbert | 13105 | 5090 | 119 | 0 | 34.11302332 | -82.83936148 | 2022-11-14 04:21:09 | Elbert, Georgia, US | |
63864 | 63864 | 2022-11-12 | US | Georgia | Elbert | 13105 | 5090 | 119 | 0 | 34.11302332 | -82.83936148 | 2022-11-13 04:21:14 | Elbert, Georgia, US | |
2928026 | 2928026 | 2022-11-11 | US | Georgia | Elbert | 13105 | 5090 | 119 | 0 | 34.11302332 | -82.83936148 | 2022-11-12 04:20:41 | Elbert, Georgia, US | |
2506862 | 2506862 | 2022-11-10 | US | Georgia | Elbert | 13105 | 5090 | 119 | 0 | 34.11302332 | -82.83936148 | 2022-11-11 04:21:22 | Elbert, Georgia, US | |
2431737 | 2431737 | 2022-11-09 | US | Georgia | Elbert | 13105 | 5090 | 119 | 0 | 34.11302332 | -82.83936148 | 2022-11-10 04:21:16 | Elbert, Georgia, US | |
481886 | 481886 | 2022-11-08 | US | North Carolina | Bertie | 37015 | 5090 | 75 | 0 | 36.0688473 | -76.96545943 | 2022-11-09 04:21:22 | Bertie, North Carolina, US | |
480589 | 480589 | 2022-11-08 | US | Illinois | Hancock | 17067 | 5090 | 51 | 0 | 40.40423981 | -91.16313899 | 2022-11-09 04:21:22 | Hancock, Illinois, US | |
2441036 | 2441036 | 2022-11-07 | US | North Carolina | Bertie | 37015 | 5090 | 75 | 0 | 36.0688473 | -76.96545943 | 2022-11-08 04:21:21 | Bertie, North Carolina, US | |
2439739 | 2439739 | 2022-11-07 | US | Illinois | Hancock | 17067 | 5090 | 51 | 0 | 40.40423981 | -91.16313899 | 2022-11-08 04:21:21 | Hancock, Illinois, US | |
1052134 | 1052134 | 2022-11-06 | US | North Carolina | Bertie | 37015 | 5090 | 75 | 0 | 36.0688473 | -76.96545943 | 2022-11-07 04:21:26 | Bertie, North Carolina, US | |
620158 | 620158 | 2022-11-05 | US | North Carolina | Bertie | 37015 | 5090 | 75 | 0 | 36.0688473 | -76.96545943 | 2022-11-06 04:21:24 | Bertie, North Carolina, US | |
1024662 | 1024662 | 2022-11-04 | US | North Carolina | Bertie | 37015 | 5090 | 75 | 0 | 36.0688473 | -76.96545943 | 2022-11-05 04:21:52 | Bertie, North Carolina, US | |
433653 | 433653 | 2022-11-03 | US | North Carolina | Bertie | 37015 | 5090 | 75 | 0 | 36.0688473 | -76.96545943 | 2022-11-04 04:22:11 | Bertie, North Carolina, US | |
851895 | 851895 | 2022-11-02 | US | North Carolina | Bertie | 37015 | 5090 | 75 | 0 | 36.0688473 | -76.96545943 | 2022-11-03 04:22:05 | Bertie, North Carolina, US | |
2760061 | 2760061 | 2022-10-18 | US | Texas | Jones | 48253 | 5090 | 94 | 0 | 32.73997145 | -99.87861576 | 2022-10-19 04:22:26 | Jones, Texas, US | |
2027895 | 2027895 | 2022-10-17 | US | Texas | Jones | 48253 | 5090 | 94 | 0 | 32.73997145 | -99.87861576 | 2022-10-18 04:22:42 | Jones, Texas, US | |
2025301 | 2025301 | 2022-10-17 | US | California | Colusa | 6011 | 5090 | 22 | 0 | 39.17881957 | -122.2331726 | 2022-10-18 04:22:42 | Colusa, California, US | |
2160079 | 2160079 | 2022-10-16 | US | California | Colusa | 6011 | 5090 | 22 | 0 | 39.17881957 | -122.2331726 | 2022-10-17 04:20:31 | Colusa, California, US | |
516276 | 516276 | 2022-10-15 | US | California | Colusa | 6011 | 5090 | 22 | 0 | 39.17881957 | -122.2331726 | 2022-10-16 04:22:39 | Colusa, California, US | |
2033333 | 2033333 | 2022-10-14 | US | California | Colusa | 6011 | 5090 | 22 | 0 | 39.17881957 | -122.2331726 | 2022-10-15 04:22:00 | Colusa, California, US | |
3754021 | 3754021 | 2022-10-13 | US | California | Colusa | 6011 | 5090 | 22 | 0 | 39.17881957 | -122.2331726 | 2022-10-14 04:22:28 | Colusa, California, US | |
3214846 | 3214846 | 2022-10-12 | US | California | Colusa | 6011 | 5090 | 22 | 0 | 39.17881957 | -122.2331726 | 2022-10-13 04:22:39 | Colusa, California, US | |
3253360 | 3253360 | 2022-10-11 | US | Texas | Robertson | 48395 | 5090 | 79 | 0 | 31.02539637 | -96.51272246 | 2022-10-12 04:22:51 | Robertson, Texas, US | |
3250695 | 3250695 | 2022-10-11 | US | California | Colusa | 6011 | 5090 | 22 | 0 | 39.17881957 | -122.2331726 | 2022-10-12 04:22:51 | Colusa, California, US | |
2970619 | 2970619 | 2022-10-10 | US | Texas | Robertson | 48395 | 5090 | 79 | 0 | 31.02539637 | -96.51272246 | 2022-10-11 04:23:05 | Robertson, Texas, US | |
2530445 | 2530445 | 2022-10-06 | US | Illinois | White | 17193 | 5090 | 53 | 0 | 38.08706198 | -88.17657461 | 2022-10-07 04:23:08 | White, Illinois, US | |
2686688 | 2686688 | 2022-10-03 | US | Illinois | Ford | 17053 | 5090 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-10-04 04:22:55 | Ford, Illinois, US | |
1626298 | 1626298 | 2022-09-22 | US | Montana | Hill | 30041 | 5090 | 73 | 0 | 48.62879827 | -110.1129252 | 2022-09-23 04:23:13 | Hill, Montana, US | |
1372502 | 1372502 | 2022-09-21 | US | Montana | Hill | 30041 | 5090 | 73 | 0 | 48.62879827 | -110.1129252 | 2022-09-22 04:22:56 | Hill, Montana, US | |
2018732 | 2018732 | 2022-09-20 | US | Montana | Hill | 30041 | 5090 | 73 | 0 | 48.62879827 | -110.1129252 | 2022-09-21 04:23:22 | Hill, Montana, US | |
3572605 | 3572605 | 2022-09-19 | US | Montana | Hill | 30041 | 5090 | 73 | 0 | 48.62879827 | -110.1129252 | 2022-09-20 04:22:48 | Hill, Montana, US | |
421344 | 421344 | 2022-09-18 | US | Montana | Hill | 30041 | 5090 | 73 | 0 | 48.62879827 | -110.1129252 | 2022-09-19 04:21:49 | Hill, Montana, US | |
3375368 | 3375368 | 2022-09-17 | US | Montana | Hill | 30041 | 5090 | 73 | 0 | 48.62879827 | -110.1129252 | 2022-09-18 04:22:50 | Hill, Montana, US | |
2357476 | 2357476 | 2022-09-16 | US | Montana | Hill | 30041 | 5090 | 73 | 0 | 48.62879827 | -110.1129252 | 2022-09-17 04:20:19 | Hill, Montana, US | |
3769312 | 3769312 | 2022-09-11 | US | Washington | Asotin | 53003 | 5090 | 74 | 0 | 46.18894415 | -117.2022851 | 2022-09-12 04:20:58 | Asotin, Washington, US | |
3827887 | 3827887 | 2022-09-10 | US | Washington | Asotin | 53003 | 5090 | 74 | 0 | 46.18894415 | -117.2022851 | 2022-09-11 04:20:50 | Asotin, Washington, US | |
966344 | 966344 | 2022-09-09 | US | Washington | Asotin | 53003 | 5090 | 74 | 0 | 46.18894415 | -117.2022851 | 2022-09-10 04:21:10 | Asotin, Washington, US | |
2346185 | 2346185 | 2022-08-31 | US | Puerto Rico | Loiza | 72087 | 5090 | 0 | 0 | 18.425688 | -65.89943 | 2022-09-01 04:21:03 | Loiza, Puerto Rico, US | |
2337890 | 2337890 | 2022-07-27 | US | Ohio | Meigs | 39105 | 5090 | 93 | 0 | 39.09224872 | -82.0305041 | 2022-07-28 04:20:56 | Meigs, Ohio, US | |
1490080 | 1490080 | 2022-07-26 | US | Ohio | Meigs | 39105 | 5090 | 93 | 0 | 39.09224872 | -82.0305041 | 2022-07-27 04:21:04 | Meigs, Ohio, US | |
2596526 | 2596526 | 2022-07-25 | US | Ohio | Meigs | 39105 | 5090 | 93 | 0 | 39.09224872 | -82.0305041 | 2022-07-26 04:20:58 | Meigs, Ohio, US | |
898641 | 898641 | 2022-07-24 | US | Ohio | Meigs | 39105 | 5090 | 93 | 0 | 39.09224872 | -82.0305041 | 2022-07-25 04:20:51 | Meigs, Ohio, US | |
93635 | 93635 | 2022-07-23 | US | Ohio | Meigs | 39105 | 5090 | 93 | 0 | 39.09224872 | -82.0305041 | 2022-07-24 04:20:47 | Meigs, Ohio, US | |
902657 | 902657 | 2022-07-22 | US | Ohio | Meigs | 39105 | 5090 | 93 | 0 | 39.09224872 | -82.0305041 | 2022-07-23 04:20:53 | Meigs, Ohio, US | |
672793 | 672793 | 2022-07-21 | US | Ohio | Meigs | 39105 | 5090 | 93 | 0 | 39.09224872 | -82.0305041 | 2022-07-22 04:21:15 | Meigs, Ohio, US | |
1201527 | 1201527 | 2022-07-06 | US | Minnesota | Fillmore | 27045 | 5090 | 24 | 0 | 43.67394126 | -92.08980382 | 2022-07-07 04:20:55 | Fillmore, Minnesota, US | |
3968270 | 3968270 | 2022-07-05 | US | Minnesota | Fillmore | 27045 | 5090 | 24 | 0 | 43.67394126 | -92.08980382 | 2022-07-06 04:20:58 | Fillmore, Minnesota, US | |
3081239 | 3081239 | 2022-07-04 | US | Texas | Milam | 48331 | 5090 | 102 | 0 | 30.7858183 | -96.97718698 | 2022-07-05 04:20:45 | Milam, Texas, US | |
3079781 | 3079781 | 2022-07-04 | US | Minnesota | Fillmore | 27045 | 5090 | 24 | 0 | 43.67394126 | -92.08980382 | 2022-07-05 04:20:45 | Fillmore, Minnesota, US | |
1770521 | 1770521 | 2022-07-03 | US | Texas | Milam | 48331 | 5090 | 102 | 0 | 30.7858183 | -96.97718698 | 2022-07-04 04:20:54 | Milam, Texas, US | |
1769063 | 1769063 | 2022-07-03 | US | Minnesota | Fillmore | 27045 | 5090 | 24 | 0 | 43.67394126 | -92.08980382 | 2022-07-04 04:20:54 | Fillmore, Minnesota, US | |
3368507 | 3368507 | 2022-07-02 | US | Texas | Milam | 48331 | 5090 | 102 | 0 | 30.7858183 | -96.97718698 | 2022-07-03 04:20:59 | Milam, Texas, US | |
3367049 | 3367049 | 2022-07-02 | US | Minnesota | Fillmore | 27045 | 5090 | 24 | 0 | 43.67394126 | -92.08980382 | 2022-07-03 04:20:59 | Fillmore, Minnesota, US | |
596836 | 596836 | 2022-07-01 | US | Texas | Milam | 48331 | 5090 | 102 | 0 | 30.7858183 | -96.97718698 | 2022-07-02 04:21:16 | Milam, Texas, US | |
595378 | 595378 | 2022-07-01 | US | Minnesota | Fillmore | 27045 | 5090 | 24 | 0 | 43.67394126 | -92.08980382 | 2022-07-02 04:21:16 | Fillmore, Minnesota, US | |
3941779 | 3941779 | 2022-06-30 | US | Minnesota | Fillmore | 27045 | 5090 | 24 | 0 | 43.67394126 | -92.08980382 | 2022-07-01 04:21:10 | Fillmore, Minnesota, US | |
2491737 | 2491737 | 2022-06-29 | US | Minnesota | Fillmore | 27045 | 5090 | 24 | 0 | 43.67394126 | -92.08980382 | 2022-06-30 04:21:01 | Fillmore, Minnesota, US | |
2240007 | 2240007 | 2022-06-28 | US | Colorado | Chaffee | 8015 | 5090 | 50 | 0 | 38.74745778 | -106.1926573 | 2022-06-29 04:20:59 | Chaffee, Colorado, US | |
1422829 | 1422829 | 2022-06-08 | US | Minnesota | Hubbard | 27057 | 5090 | 60 | 0 | 47.10778564 | -94.91693868 | 2022-06-09 04:20:54 | Hubbard, Minnesota, US | |
1187386 | 1187386 | 2022-05-18 | US | Oregon | Union | 41061 | 5090 | 80 | 0 | 45.30915495 | -118.0068979 | 2022-05-19 04:20:54 | Union, Oregon, US | |
222396 | 222396 | 2022-05-09 | US | Alabama | Randolph | 1111 | 5090 | 75 | 0 | 33.29526734 | -85.45708831 | 2022-05-10 04:20:50 | Randolph, Alabama, US | |
1848243 | 1848243 | 2022-04-18 | US | New York | Schoharie | 36095 | 5090 | 36 | 0 | 42.58831742 | -74.44339029999998 | 2022-04-19 04:21:00 | Schoharie, New York, US | |
1950014 | 1950014 | 2022-04-12 | US | Louisiana | Concordia | 22029 | 5090 | 89 | 0 | 31.44817835 | -91.63814433 | 2022-04-13 04:21:03 | Concordia, Louisiana, US | |
3207767 | 3207767 | 2022-04-11 | US | Louisiana | Concordia | 22029 | 5090 | 89 | 0 | 31.44817835 | -91.63814433 | 2022-04-12 04:20:49 | Concordia, Louisiana, US | |
2478773 | 2478773 | 2022-03-30 | US | Georgia | Fannin | 13111 | 5090 | 152 | 0 | 34.86430205 | -84.316964 | 2022-03-31 04:20:56 | Fannin, Georgia, US | |
694853 | 694853 | 2022-03-17 | US | Arkansas | Ashley | 5003 | 5090 | 64 | 0 | 33.19153461 | -91.76984709999999 | 2022-03-18 04:20:55 | Ashley, Arkansas, US | |
2266533 | 2266533 | 2022-03-14 | US | Oregon | Wasco | 41065 | 5090 | 57 | 0 | 45.16292781 | -121.16709540000001 | 2022-03-15 04:20:47 | Wasco, Oregon, US | |
922162 | 922162 | 2022-03-08 | US | Ohio | Holmes | 39075 | 5090 | 182 | 0 | 40.56163713 | -81.92635677 | 2022-03-09 04:20:59 | Holmes, Ohio, US | |
2202118 | 2202118 | 2022-03-06 | US | Ohio | Holmes | 39075 | 5090 | 182 | 0 | 40.56163713 | -81.92635677 | 2022-03-07 04:20:47 | Holmes, Ohio, US | |
2199994 | 2199994 | 2022-03-06 | US | Alabama | Cherokee | 1019 | 5090 | 79 | 0 | 34.17805983 | -85.60638968 | 2022-03-07 04:20:47 | Cherokee, Alabama, US | |
2092451 | 2092451 | 2022-03-05 | US | Alabama | Cherokee | 1019 | 5090 | 79 | 0 | 34.17805983 | -85.60638968 | 2022-03-06 04:20:49 | Cherokee, Alabama, US | |
2666151 | 2666151 | 2022-03-04 | US | Alabama | Cherokee | 1019 | 5090 | 79 | 0 | 34.17805983 | -85.60638968 | 2022-03-05 04:21:10 | Cherokee, Alabama, US | |
1644716 | 1644716 | 2022-03-03 | US | Alabama | Cherokee | 1019 | 5090 | 79 | 0 | 34.17805983 | -85.60638968 | 2022-03-04 04:21:09 | Cherokee, Alabama, US | |
1512392 | 1512392 | 2022-02-24 | US | Illinois | Edgar | 17045 | 5090 | 57 | 0 | 39.6809186 | -87.74759563 | 2022-02-25 04:21:11 | Edgar, Illinois, US | |
2645250 | 2645250 | 2022-02-14 | US | West Virginia | McDowell | 54047 | 5090 | 60 | 0 | 37.38002939 | -81.65083669 | 2022-02-15 04:21:09 | McDowell, West Virginia, US | |
2643618 | 2643618 | 2022-02-14 | US | Mississippi | Winston | 28159 | 5090 | 100 | 0 | 33.08747908 | -89.03391385 | 2022-02-15 04:21:09 | Winston, Mississippi, US | |
3303146 | 3303146 | 2022-01-30 | US | Tennessee | Fentress | 47049 | 5090 | 108 | 0 | 36.38128818 | -84.92870012 | 2022-01-31 04:21:09 | Fentress, Tennessee, US | |
3302443 | 3302443 | 2022-01-30 | US | New York | Essex | 36031 | 5090 | 52 | 0 | 44.11630765 | -73.77297842 | 2022-01-31 04:21:09 | Essex, New York, US | |
1962898 | 1962898 | 2022-01-20 | US | North Carolina | Martin | 37117 | 5090 | 77 | 0 | 35.84326734 | -77.10860251 | 2022-01-21 04:21:09 | Martin, North Carolina, US | |
1702085 | 1702085 | 2022-01-03 | US | Minnesota | Le Sueur | 27079 | 5090 | 42 | 0 | 44.37136597 | -93.72844721 | 2022-01-04 04:22:17 | Le Sueur, Minnesota, US | |
784529 | 784529 | 2021-12-13 | US | Nevada | Douglas | 32005 | 5090 | 72 | 0 | 38.912862 | -119.61713329999999 | 2021-12-14 04:22:38 | Douglas, Nevada, US | |
450919 | 450919 | 2021-11-17 | US | Wisconsin | Green | 55045 | 5090 | 35 | 0 | 42.6794956 | -89.60243287 | 2021-11-18 04:21:33 | Green, Wisconsin, US | |
3123786 | 3123786 | 2021-11-05 | US | New York | Washington | 36115 | 5090 | 71 | 0 | 43.31153794 | -73.43043448 | 2021-11-06 04:21:51 | Washington, New York, US | |
3514775 | 3514775 | 2021-11-01 | US | Virginia | Manassas | 51683 | 5090 | 53 | 0 | 38.7464321 | -77.48509905 | 2021-11-02 04:22:03 | Manassas, Virginia, US | |
568538 | 568538 | 2021-10-29 | US | Kentucky | Logan | 21141 | 5090 | 81 | 0 | 36.85949479 | -86.877635 | 2021-10-30 04:22:03 | Logan, Kentucky, US | |
773856 | 773856 | 2021-10-23 | US | West Virginia | Preston | 54077 | 5090 | 82 | 0 | 39.46770987 | -79.66712803 | 2021-10-24 04:21:22 | Preston, West Virginia, US | |
425959 | 425959 | 2021-10-10 | US | Oregon | Benton | 41003 | 5090 | 30 | 0 | 44.49167306 | -123.4316987 | 2021-10-11 04:21:31 | Benton, Oregon, US | |
2878816 | 2878816 | 2021-10-09 | US | Oregon | Benton | 41003 | 5090 | 30 | 0 | 44.49167306 | -123.4316987 | 2021-10-10 04:21:38 | Benton, Oregon, US | |
2961982 | 2961982 | 2021-10-08 | US | Oregon | Benton | 41003 | 5090 | 30 | 0 | 44.49167306 | -123.4316987 | 2021-10-09 04:21:34 | Benton, Oregon, US | |
1816085 | 1816085 | 2021-09-19 | US | Kansas | Lyon | 20111 | 5090 | 90 | 0 | 38.45576156 | -96.15275715 | 2021-09-20 04:21:22 | Lyon, Kansas, US | |
17665 | 17665 | 2021-09-18 | US | Kansas | Lyon | 20111 | 5090 | 90 | 0 | 38.45576156 | -96.15275715 | 2021-09-19 04:21:34 | Lyon, Kansas, US | |
2619350 | 2619350 | 2021-09-17 | US | Kansas | Lyon | 20111 | 5090 | 90 | 0 | 38.45576156 | -96.15275715 | 2021-09-18 04:21:24 | Lyon, Kansas, US | |
644180 | 644180 | 2021-09-07 | US | New York | Madison | 36053 | 5090 | 91 | 0 | 42.91653905 | -75.67266639 | 2021-09-08 04:21:31 | Madison, New York, US | |
3107944 | 3107944 | 2021-08-24 | US | Ohio | Mercer | 39107 | 5090 | 88 | 0 | 40.54043046 | -84.62912742 | 2021-08-25 04:21:41 | Mercer, Ohio, US | |
245730 | 245730 | 2021-08-17 | US | Arkansas | Baxter | 5005 | 5090 | 137 | 0 | 36.28784385 | -92.33782872 | 2021-08-18 04:21:35 | Baxter, Arkansas, US | |
103174 | 103174 | 2021-08-15 | Colombia | Guaviare | 5090 | 91 | 0 | 1.0654 | -73.2603 | 2021-08-16 04:21:31 | Guaviare, Colombia | |||
508188 | 508188 | 2021-08-14 | US | Arkansas | Miller | 5091 | 5090 | 38 | 0 | 33.31403423 | -93.89285258 | 2021-08-15 04:21:41 | Miller, Arkansas, US | |
507532 | 507532 | 2021-08-14 | Colombia | Guaviare | 5090 | 91 | 0 | 1.0654 | -73.2603 | 2021-08-15 04:21:41 | Guaviare, Colombia |
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]);