daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
357 rows where active = 685 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-07-29 | Ukraine | Kharkiv Oblast | 149314 | 3601 | 145028 | 685 | 49.9935 | 36.2304 | 2021-07-30 04:21:34 | Kharkiv Oblast, Ukraine | ||
2021-07-19 | Croatia | 361613 | 8240 | 352688 | 685 | 45.1 | 15.2 | 2021-07-20 04:21:48 | Croatia | |||
2021-07-16 | Croatia | 361349 | 8234 | 352430 | 685 | 45.1 | 15.2 | 2021-07-17 04:22:22 | Croatia | |||
2021-07-09 | Ukraine | Kharkiv Oblast | 148737 | 3554 | 144498 | 685 | 49.9935 | 36.2304 | 2021-07-10 04:21:25 | Kharkiv Oblast, Ukraine | ||
2021-07-09 | Latvia | 137831 | 2536 | 134610 | 685 | 56.8796 | 24.6032 | 2021-07-10 04:21:25 | Latvia | |||
2021-07-08 | Ukraine | Odessa Oblast | 140887 | 2990 | 137212 | 685 | 46.4846 | 30.7326 | 2021-07-09 04:21:21 | Odessa Oblast, Ukraine | ||
2021-07-06 | Italy | Basilicata | 26993 | 591 | 25717 | 685 | 40.63947052 | 15.80514834 | 2021-07-07 04:21:20 | Basilicata, Italy | ||
2021-07-04 | Russia | Kalmykia Republic | 21928 | 419 | 20824 | 685 | 46.2313018 | 45.3275745 | 2021-07-05 04:21:28 | Kalmykia Republic, Russia | ||
2021-06-23 | Chile | Nuble | 33422 | 555 | 32182 | 685 | -36.7226 | -71.7622 | 2021-06-24 04:21:55 | Nuble, Chile | ||
2021-06-08 | India | Chandigarh | 60778 | 779 | 59314 | 685 | 30.733839 | 76.76827800000002 | 2021-06-09 04:23:31 | Chandigarh, India | ||
2021-05-04 | Italy | Valle d'Aosta | 11066 | 459 | 9922 | 685 | 45.73750286 | 7.320149366 | 2021-05-05 04:20:43 | Valle d'Aosta, Italy | ||
2021-04-20 | Colombia | Meta | 45321 | 1035 | 43601 | 685 | 3.272 | -73.0877 | 2021-04-21 04:21:14 | Meta, Colombia | ||
2021-04-19 | Colombia | Meta | 45170 | 1030 | 43455 | 685 | 3.272 | -73.0877 | 2021-04-20 04:20:41 | Meta, Colombia | ||
2021-04-16 | Trinidad and Tobago | 8678 | 150 | 7843 | 685 | 10.6918 | -61.2225 | 2021-04-17 04:20:40 | Trinidad and Tobago | |||
2021-04-15 | Trinidad and Tobago | 8678 | 150 | 7843 | 685 | 10.6918 | -61.2225 | 2021-04-16 04:20:46 | Trinidad and Tobago | |||
2021-04-10 | Russia | Buryatia Republic | 36465 | 803 | 34977 | 685 | 52.7182426 | 109.492143 | 2021-04-11 04:20:56 | Buryatia Republic, Russia | ||
2021-03-24 | Russia | Mari El Republic | 12389 | 199 | 11505 | 685 | 56.5767504 | 47.8817512 | 2021-03-25 05:27:00 | Mari El Republic, Russia | ||
2021-03-06 | US | West Virginia | Summers | 54089 | 708 | 23 | 0 | 685 | 37.65390597 | -80.86009693 | 2021-03-07 05:21:54 | Summers, West Virginia, US |
2021-03-06 | US | South Dakota | Brule | 46015 | 694 | 9 | 0 | 685 | 43.71756379 | -99.08118954 | 2021-03-07 05:21:54 | Brule, South Dakota, US |
2021-03-05 | US | South Dakota | Brule | 46015 | 694 | 9 | 0 | 685 | 43.71756379 | -99.08118954 | 2021-03-06 04:23:41 | Brule, South Dakota, US |
2021-03-04 | US | South Dakota | Brule | 46015 | 694 | 9 | 0 | 685 | 43.71756379 | -99.08118954 | 2021-03-05 05:26:29 | Brule, South Dakota, US |
2021-03-01 | US | Texas | Dallam | 48111 | 1095 | 22 | 0 | 685 | 36.27787176 | -102.6020725 | 2021-03-02 05:23:30 | Dallam, Texas, US |
2021-02-28 | US | Texas | Dallam | 48111 | 1095 | 22 | 0 | 685 | 36.27787176 | -102.6020725 | 2021-03-01 05:23:01 | Dallam, Texas, US |
2021-02-28 | US | Missouri | Cedar | 29039 | 703 | 18 | 0 | 685 | 37.72391475 | -93.85445441 | 2021-03-01 05:23:01 | Cedar, Missouri, US |
2021-02-28 | US | Iowa | Lucas | 19117 | 706 | 21 | 0 | 685 | 41.02958964 | -93.32780803 | 2021-03-01 05:23:01 | Lucas, Iowa, US |
2021-02-27 | US | Texas | Dallam | 48111 | 1095 | 22 | 0 | 685 | 36.27787176 | -102.6020725 | 2021-02-28 05:22:20 | Dallam, Texas, US |
2021-02-25 | US | Texas | Winkler | 48495 | 697 | 20 | 0 | 685 | 31.85008651 | -103.0485163 | 2021-02-26 05:22:40 | Winkler, Texas, US |
2021-02-24 | US | Colorado | Yuma | 8125 | 830 | 17 | 0 | 685 | 40.00346839 | -102.4258673 | 2021-02-25 05:24:57 | Yuma, Colorado, US |
2021-02-23 | US | Kansas | Coffey | 20031 | 702 | 17 | 0 | 685 | 38.2365018 | -95.73379515 | 2021-02-24 05:29:16 | Coffey, Kansas, US |
2021-02-22 | US | Kansas | Coffey | 20031 | 702 | 17 | 0 | 685 | 38.2365018 | -95.73379515 | 2021-02-23 05:23:41 | Coffey, Kansas, US |
2021-02-21 | US | Kansas | Coffey | 20031 | 701 | 16 | 0 | 685 | 38.2365018 | -95.73379515 | 2021-02-22 05:24:21 | Coffey, Kansas, US |
2021-02-20 | US | Kansas | Coffey | 20031 | 701 | 16 | 0 | 685 | 38.2365018 | -95.73379515 | 2021-02-21 05:24:33 | Coffey, Kansas, US |
2021-02-19 | US | Maine | Washington | 23029 | 699 | 14 | 0 | 685 | 45.01607142 | -67.62813524 | 2021-02-20 05:22:51 | Washington, Maine, US |
2021-02-19 | US | Kansas | Coffey | 20031 | 701 | 16 | 0 | 685 | 38.2365018 | -95.73379515 | 2021-02-20 05:22:51 | Coffey, Kansas, US |
2021-02-18 | US | Maine | Washington | 23029 | 698 | 13 | 0 | 685 | 45.01607142 | -67.62813524 | 2021-02-19 05:24:16 | Washington, Maine, US |
2021-02-18 | US | Kansas | Coffey | 20031 | 700 | 15 | 0 | 685 | 38.2365018 | -95.73379515 | 2021-02-19 05:24:16 | Coffey, Kansas, US |
2021-02-17 | US | Kansas | Coffey | 20031 | 700 | 15 | 0 | 685 | 38.2365018 | -95.73379515 | 2021-02-18 05:22:58 | Coffey, Kansas, US |
2021-02-15 | US | Minnesota | Lake | 27075 | 702 | 17 | 0 | 685 | 47.64270764 | -91.44557998 | 2021-02-16 05:24:38 | Lake, Minnesota, US |
2021-02-13 | US | Virginia | Floyd | 51063 | 703 | 18 | 0 | 685 | 36.9302126 | -80.36738849 | 2021-02-14 05:23:43 | Floyd, Virginia, US |
2021-02-12 | US | Minnesota | Clearwater | 27029 | 699 | 14 | 0 | 685 | 47.57992111 | -95.37790562 | 2021-02-13 05:22:12 | Clearwater, Minnesota, US |
2021-02-11 | US | Minnesota | Clearwater | 27029 | 699 | 14 | 0 | 685 | 47.57992111 | -95.37790562 | 2021-02-12 05:23:29 | Clearwater, Minnesota, US |
2021-02-09 | US | Georgia | Terrell | 13273 | 722 | 37 | 0 | 685 | 31.77527543 | -84.44069698 | 2021-02-10 05:22:41 | Terrell, Georgia, US |
2021-02-07 | US | Michigan | Missaukee | 26113 | 702 | 17 | 0 | 685 | 44.33772443 | -85.09256478 | 2021-02-08 05:22:39 | Missaukee, Michigan, US |
2021-02-06 | Malaysia | Terengganu | 2561 | 5 | 1871 | 685 | 5.3117 | 103.1324 | 2021-02-07 05:23:00 | Terengganu, Malaysia | ||
2021-02-06 | US | Michigan | Missaukee | 26113 | 702 | 17 | 0 | 685 | 44.33772443 | -85.09256478 | 2021-02-07 05:23:00 | Missaukee, Michigan, US |
2021-02-06 | US | Georgia | Lanier | 13173 | 695 | 10 | 0 | 685 | 31.038285700000007 | -83.06472457 | 2021-02-07 05:23:00 | Lanier, Georgia, US |
2021-02-01 | US | Tennessee | Pickett | 47137 | 727 | 21 | 0 | 685 | 36.55606529 | -85.07763299999998 | 2021-02-02 05:22:49 | Pickett, Tennessee, US |
2021-01-31 | US | Tennessee | Pickett | 47137 | 726 | 21 | 0 | 685 | 36.55606529 | -85.07763299999998 | 2021-02-01 05:22:53 | Pickett, Tennessee, US |
2021-01-31 | US | South Dakota | Walworth | 46129 | 700 | 15 | 0 | 685 | 45.43019636 | -100.0307514 | 2021-02-01 05:22:53 | Walworth, South Dakota, US |
2021-01-30 | US | South Dakota | Walworth | 46129 | 700 | 15 | 0 | 685 | 45.43019636 | -100.0307514 | 2021-01-31 05:22:42 | Walworth, South Dakota, US |
2021-01-29 | US | Indiana | Switzerland | 18155 | 691 | 6 | 0 | 685 | 38.82767338 | -85.03022429 | 2021-01-30 05:22:49 | Switzerland, Indiana, US |
2021-01-28 | US | Missouri | Howard | 29089 | 689 | 4 | 0 | 685 | 39.1435761 | -92.69756691 | 2021-01-29 05:22:23 | Howard, Missouri, US |
2021-01-28 | US | Arkansas | Nevada | 5099 | 708 | 23 | 0 | 685 | 33.66340119 | -93.30632432 | 2021-01-29 05:22:23 | Nevada, Arkansas, US |
2021-01-27 | US | South Dakota | Walworth | 46129 | 699 | 14 | 0 | 685 | 45.43019636 | -100.0307514 | 2021-01-28 05:22:24 | Walworth, South Dakota, US |
2021-01-27 | Cabo Verde | 13722 | 129 | 12908 | 685 | 16.5388 | -23.0418 | 2021-01-28 05:22:24 | Cabo Verde | |||
2021-01-26 | Chile | Coquimbo | 16345 | 329 | 15331 | 685 | -29.959 | -71.3389 | 2021-01-27 05:23:41 | Coquimbo, Chile | ||
2021-01-25 | US | Virginia | Buena Vista | 51530 | 695 | 10 | 0 | 685 | 37.73484642 | -79.35296097 | 2021-01-26 05:22:02 | Buena Vista, Virginia, US |
2021-01-25 | US | Kentucky | Hancock | 21091 | 697 | 12 | 0 | 685 | 37.83766422 | -86.78280584 | 2021-01-26 05:22:02 | Hancock, Kentucky, US |
2021-01-24 | US | South Dakota | Walworth | 46129 | 699 | 14 | 0 | 685 | 45.43019636 | -100.0307514 | 2021-01-25 05:22:16 | Walworth, South Dakota, US |
2021-01-24 | US | Missouri | Gentry | 29075 | 703 | 18 | 0 | 685 | 40.21097916 | -94.40944419 | 2021-01-25 05:22:16 | Gentry, Missouri, US |
2021-01-24 | US | Georgia | Heard | 13149 | 698 | 13 | 0 | 685 | 33.29686567 | -85.12886832 | 2021-01-25 05:22:16 | Heard, Georgia, US |
2021-01-23 | US | Nebraska | Merrick | 31121 | 696 | 11 | 0 | 685 | 41.16624273 | -98.0374887 | 2021-01-24 05:22:35 | Merrick, Nebraska, US |
2021-01-22 | US | Oklahoma | Latimer | 40077 | 692 | 7 | 0 | 685 | 34.87844729 | -95.25215049 | 2021-01-23 05:22:03 | Latimer, Oklahoma, US |
2021-01-22 | US | North Carolina | Pamlico | 37137 | 691 | 6 | 0 | 685 | 35.15253315 | -76.66559823 | 2021-01-23 05:22:03 | Pamlico, North Carolina, US |
2021-01-22 | US | Georgia | Jenkins | 13165 | 719 | 34 | 0 | 685 | 32.79248718 | -81.96040187 | 2021-01-23 05:22:03 | Jenkins, Georgia, US |
2021-01-22 | Suriname | 7945 | 148 | 7112 | 685 | 3.9193 | -56.0278 | 2021-01-23 05:22:03 | Suriname | |||
2021-01-21 | US | Nebraska | Merrick | 31121 | 696 | 11 | 0 | 685 | 41.16624273 | -98.0374887 | 2021-01-22 05:22:10 | Merrick, Nebraska, US |
2021-01-20 | US | Nebraska | Merrick | 31121 | 696 | 11 | 0 | 685 | 41.16624273 | -98.0374887 | 2021-01-21 05:22:01 | Merrick, Nebraska, US |
2021-01-20 | US | Idaho | Boundary | 16021 | 695 | 10 | 0 | 685 | 48.76684761 | -116.4630179 | 2021-01-21 05:22:01 | Boundary, Idaho, US |
2021-01-19 | US | North Dakota | Dickey | 38021 | 713 | 32 | 0 | 685 | 46.11017712 | -98.5049008 | 2021-01-20 05:21:54 | Dickey, North Dakota, US |
2021-01-19 | US | Iowa | Greene | 19073 | 692 | 7 | 0 | 685 | 42.03614551 | -94.39658081 | 2021-01-20 05:21:54 | Greene, Iowa, US |
2021-01-17 | US | West Virginia | Braxton | 54007 | 686 | 1 | 0 | 685 | 38.70036159 | -80.72011184 | 2021-01-18 05:22:34 | Braxton, West Virginia, US |
2021-01-17 | US | Michigan | Manistee | 26101 | 703 | 18 | 0 | 685 | 44.33352407 | -86.05626916 | 2021-01-18 05:22:34 | Manistee, Michigan, US |
2021-01-16 | US | Puerto Rico | Juana Diaz | 72075 | 685 | 0 | 0 | 685 | 18.050764 | -66.49458100000001 | 2021-01-17 05:22:17 | Juana Diaz, Puerto Rico, US |
2021-01-16 | US | Michigan | Manistee | 26101 | 703 | 18 | 0 | 685 | 44.33352407 | -86.05626916 | 2021-01-17 05:22:17 | Manistee, Michigan, US |
2021-01-15 | US | Michigan | Manistee | 26101 | 703 | 18 | 0 | 685 | 44.33352407 | -86.05626916 | 2021-01-16 05:22:40 | Manistee, Michigan, US |
2021-01-15 | US | Georgia | Pulaski | 13235 | 717 | 32 | 0 | 685 | 32.23334561 | -83.47549959999998 | 2021-01-16 05:22:40 | Pulaski, Georgia, US |
2021-01-13 | US | Missouri | Harrison | 29081 | 695 | 10 | 0 | 685 | 40.35570088 | -93.99222144 | 2021-01-14 05:22:32 | Harrison, Missouri, US |
2021-01-12 | US | West Virginia | Pleasants | 54073 | 692 | 7 | 0 | 685 | 39.37091679 | -81.16771771 | 2021-01-13 05:22:15 | Pleasants, West Virginia, US |
2021-01-12 | US | South Dakota | McCook | 46087 | 707 | 22 | 0 | 685 | 43.6742571 | -97.36863144 | 2021-01-13 05:22:15 | McCook, South Dakota, US |
2021-01-12 | US | Missouri | Harrison | 29081 | 695 | 10 | 0 | 685 | 40.35570088 | -93.99222144 | 2021-01-13 05:22:15 | Harrison, Missouri, US |
2021-01-12 | US | Kentucky | Carroll | 21041 | 692 | 7 | 0 | 685 | 38.66599534 | -85.12601074 | 2021-01-13 05:22:15 | Carroll, Kentucky, US |
2021-01-11 | US | Indiana | Crawford | 18025 | 698 | 13 | 0 | 685 | 38.28814402 | -86.44518825 | 2021-01-12 05:22:15 | Crawford, Indiana, US |
2021-01-09 | US | Virginia | Franklin City | 51620 | 703 | 18 | 0 | 685 | 36.6831435 | -76.93859681 | 2021-01-10 05:22:12 | Franklin City, Virginia, US |
2021-01-09 | US | Missouri | Sullivan | 29211 | 695 | 10 | 0 | 685 | 40.2099105 | -93.11150106 | 2021-01-10 05:22:12 | Sullivan, Missouri, US |
2021-01-09 | US | Georgia | Stewart | 13259 | 702 | 17 | 0 | 685 | 32.07996777 | -84.83208037 | 2021-01-10 05:22:12 | Stewart, Georgia, US |
2021-01-05 | US | Georgia | Irwin | 13155 | 702 | 17 | 0 | 685 | 31.60213036 | -83.27501387 | 2021-01-06 05:22:16 | Irwin, Georgia, US |
2021-01-04 | US | Oklahoma | Blaine | 40011 | 689 | 4 | 0 | 685 | 35.87518314 | -98.43307003 | 2021-01-05 05:21:49 | Blaine, Oklahoma, US |
2021-01-04 | US | Georgia | Candler | 13043 | 722 | 37 | 0 | 685 | 32.40209349 | -82.07702563 | 2021-01-05 05:21:49 | Candler, Georgia, US |
2021-01-02 | US | South Dakota | Hutchinson | 46067 | 701 | 16 | 0 | 685 | 43.33449012 | -97.75536441 | 2021-01-03 05:22:52 | Hutchinson, South Dakota, US |
2021-01-02 | US | Ohio | Harrison | 39067 | 704 | 19 | 0 | 685 | 40.29380509 | -81.09068544 | 2021-01-03 05:22:52 | Harrison, Ohio, US |
2021-01-02 | Chile | Tarapaca | 16006 | 289 | 15032 | 685 | -19.9232 | -69.5132 | 2021-01-03 05:22:52 | Tarapaca, Chile | ||
2021-01-01 | Chile | Tarapaca | 15896 | 287 | 14924 | 685 | -19.9232 | -69.5132 | 2021-01-02 05:22:33 | Tarapaca, Chile | ||
2020-12-30 | US | Minnesota | Pope | 27121 | 689 | 4 | 0 | 685 | 45.58606667 | -95.44451209 | 2020-12-31 05:22:49 | Pope, Minnesota, US |
2020-12-29 | US | Puerto Rico | Catano | 72033 | 685 | 0 | 0 | 685 | 18.437269 | -66.14330600000001 | 2020-12-30 05:22:34 | Catano, Puerto Rico, US |
2020-12-29 | US | Nebraska | Thurston | 31173 | 694 | 9 | 0 | 685 | 42.15725356 | -96.54157099 | 2020-12-30 05:22:34 | Thurston, Nebraska, US |
2020-12-29 | US | Nebraska | Hamilton | 31081 | 699 | 14 | 0 | 685 | 40.87349452 | -98.02099117 | 2020-12-30 05:22:34 | Hamilton, Nebraska, US |
2020-12-29 | US | Mississippi | Humphreys | 28053 | 707 | 22 | 0 | 685 | 33.12825718 | -90.52252707 | 2020-12-30 05:22:34 | Humphreys, Mississippi, US |
2020-12-28 | US | Mississippi | Webster | 28155 | 703 | 18 | 0 | 685 | 33.61300486 | -89.28392912 | 2020-12-29 05:22:37 | Webster, Mississippi, US |
2020-12-27 | US | Washington | Clallam | 53009 | 689 | 4 | 0 | 685 | 48.04754642 | -123.9226319 | 2020-12-28 05:22:06 | Clallam, Washington, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;