johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
305 rows where deaths = 783 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
328959 | 328959 | 2022-12-27 | US | Illinois | St. Clair | 17163 | 79056 | 783 | 0 | 38.46996033 | -89.93063427 | 2022-12-28 04:21:04 | St. Clair, Illinois, US | |
219032 | 219032 | 2022-12-26 | US | Illinois | St. Clair | 17163 | 78942 | 783 | 0 | 38.46996033 | -89.93063427 | 2022-12-27 04:21:07 | St. Clair, Illinois, US | |
3223489 | 3223489 | 2022-12-25 | US | Illinois | St. Clair | 17163 | 78942 | 783 | 0 | 38.46996033 | -89.93063427 | 2022-12-26 04:21:06 | St. Clair, Illinois, US | |
1019403 | 1019403 | 2022-12-24 | US | Illinois | St. Clair | 17163 | 78942 | 783 | 0 | 38.46996033 | -89.93063427 | 2022-12-25 04:21:04 | St. Clair, Illinois, US | |
691426 | 691426 | 2022-12-23 | US | Illinois | St. Clair | 17163 | 78942 | 783 | 0 | 38.46996033 | -89.93063427 | 2022-12-24 04:21:02 | St. Clair, Illinois, US | |
2180636 | 2180636 | 2022-12-22 | US | Illinois | St. Clair | 17163 | 78903 | 783 | 0 | 38.46996033 | -89.93063427 | 2022-12-23 04:21:04 | St. Clair, Illinois, US | |
2951379 | 2951379 | 2022-12-20 | Japan | Gifu | 414474 | 783 | 0 | 35.778671 | 137.055925 | 2022-12-21 04:21:03 | Gifu, Japan | |||
1967574 | 1967574 | 2022-11-30 | US | Tennessee | Sullivan | 47163 | 56686 | 783 | 0 | 36.51240691 | -82.30412917 | 2022-12-01 04:21:03 | Sullivan, Tennessee, US | |
314387 | 314387 | 2022-11-13 | US | Ohio | Lake | 39085 | 58203 | 783 | 0 | 41.69710807 | -81.23676539 | 2022-11-14 04:21:09 | Lake, Ohio, US | |
482250 | 482250 | 2022-11-08 | US | Pennsylvania | Cambria | 42021 | 41108 | 783 | 0 | 40.49527404 | -78.71377428 | 2022-11-09 04:21:22 | Cambria, Pennsylvania, US | |
2441400 | 2441400 | 2022-11-07 | US | Pennsylvania | Cambria | 42021 | 41108 | 783 | 0 | 40.49527404 | -78.71377428 | 2022-11-08 04:21:21 | Cambria, Pennsylvania, US | |
1052498 | 1052498 | 2022-11-06 | US | Pennsylvania | Cambria | 42021 | 41108 | 783 | 0 | 40.49527404 | -78.71377428 | 2022-11-07 04:21:26 | Cambria, Pennsylvania, US | |
620522 | 620522 | 2022-11-05 | US | Pennsylvania | Cambria | 42021 | 41108 | 783 | 0 | 40.49527404 | -78.71377428 | 2022-11-06 04:21:24 | Cambria, Pennsylvania, US | |
1025026 | 1025026 | 2022-11-04 | US | Pennsylvania | Cambria | 42021 | 41108 | 783 | 0 | 40.49527404 | -78.71377428 | 2022-11-05 04:21:52 | Cambria, Pennsylvania, US | |
434017 | 434017 | 2022-11-03 | US | Pennsylvania | Cambria | 42021 | 41108 | 783 | 0 | 40.49527404 | -78.71377428 | 2022-11-04 04:22:11 | Cambria, Pennsylvania, US | |
852259 | 852259 | 2022-11-02 | US | Pennsylvania | Cambria | 42021 | 41108 | 783 | 0 | 40.49527404 | -78.71377428 | 2022-11-03 04:22:05 | Cambria, Pennsylvania, US | |
2267902 | 2267902 | 2022-10-22 | Japan | Hiroshima | 452420 | 783 | 0 | 34.605309 | 132.788719 | 2022-10-23 04:22:46 | Hiroshima, Japan | |||
3997271 | 3997271 | 2022-09-27 | US | Oregon | Marion | 41047 | 82387 | 783 | 0 | 44.90287942 | -122.5815117 | 2022-09-28 04:23:01 | Marion, Oregon, US | |
2771599 | 2771599 | 2022-09-26 | US | Oregon | Marion | 41047 | 82387 | 783 | 0 | 44.90287942 | -122.5815117 | 2022-09-27 04:23:01 | Marion, Oregon, US | |
1980017 | 1980017 | 2022-09-25 | US | Virginia | Prince William | 51153 | 116711 | 783 | 0 | 38.70916224 | -77.48713689 | 2022-09-26 04:20:52 | Prince William, Virginia, US | |
1979252 | 1979252 | 2022-09-25 | US | Oregon | Marion | 41047 | 82387 | 783 | 0 | 44.90287942 | -122.5815117 | 2022-09-26 04:20:52 | Marion, Oregon, US | |
2653184 | 2653184 | 2022-09-24 | US | Virginia | Prince William | 51153 | 116711 | 783 | 0 | 38.70916224 | -77.48713689 | 2022-09-25 04:23:31 | Prince William, Virginia, US | |
2652419 | 2652419 | 2022-09-24 | US | Oregon | Marion | 41047 | 82387 | 783 | 0 | 44.90287942 | -122.5815117 | 2022-09-25 04:23:31 | Marion, Oregon, US | |
387624 | 387624 | 2022-09-23 | US | Virginia | Prince William | 51153 | 116711 | 783 | 0 | 38.70916224 | -77.48713689 | 2022-09-24 04:21:40 | Prince William, Virginia, US | |
386859 | 386859 | 2022-09-23 | US | Oregon | Marion | 41047 | 82387 | 783 | 0 | 44.90287942 | -122.5815117 | 2022-09-24 04:21:40 | Marion, Oregon, US | |
1626925 | 1626925 | 2022-09-22 | US | Oregon | Marion | 41047 | 82387 | 783 | 0 | 44.90287942 | -122.5815117 | 2022-09-23 04:23:13 | Marion, Oregon, US | |
1373129 | 1373129 | 2022-09-21 | US | Oregon | Marion | 41047 | 82387 | 783 | 0 | 44.90287942 | -122.5815117 | 2022-09-22 04:22:56 | Marion, Oregon, US | |
2324872 | 2324872 | 2022-08-24 | US | Louisiana | Ouachita | 22073 | 57408 | 783 | 0 | 32.47645559 | -92.15704172 | 2022-08-25 04:21:13 | Ouachita, Louisiana, US | |
1252281 | 1252281 | 2022-08-23 | US | Louisiana | Ouachita | 22073 | 57317 | 783 | 0 | 32.47645559 | -92.15704172 | 2022-08-24 04:20:46 | Ouachita, Louisiana, US | |
1069899 | 1069899 | 2022-08-07 | Japan | Kyoto | 324582 | 783 | 0 | 35.253815 | 135.443341 | 2022-08-08 04:21:08 | Kyoto, Japan | |||
900237 | 900237 | 2022-07-22 | Malta | 111983 | 783 | 0 | 35.9375 | 14.3754 | 2022-07-23 04:20:53 | Malta | ||||
3080272 | 3080272 | 2022-07-04 | US | New Mexico | San Juan | 35045 | 43413 | 783 | 0 | 36.50838318 | -108.320437 | 2022-07-05 04:20:45 | San Juan, New Mexico, US | |
1769554 | 1769554 | 2022-07-03 | US | New Mexico | San Juan | 35045 | 43413 | 783 | 0 | 36.50838318 | -108.320437 | 2022-07-04 04:20:54 | San Juan, New Mexico, US | |
3367540 | 3367540 | 2022-07-02 | US | New Mexico | San Juan | 35045 | 43413 | 783 | 0 | 36.50838318 | -108.320437 | 2022-07-03 04:20:59 | San Juan, New Mexico, US | |
595869 | 595869 | 2022-07-01 | US | New Mexico | San Juan | 35045 | 43413 | 783 | 0 | 36.50838318 | -108.320437 | 2022-07-02 04:21:16 | San Juan, New Mexico, US | |
3942270 | 3942270 | 2022-06-30 | US | New Mexico | San Juan | 35045 | 43329 | 783 | 0 | 36.50838318 | -108.320437 | 2022-07-01 04:21:10 | San Juan, New Mexico, US | |
2492228 | 2492228 | 2022-06-29 | US | New Mexico | San Juan | 35045 | 43244 | 783 | 0 | 36.50838318 | -108.320437 | 2022-06-30 04:21:01 | San Juan, New Mexico, US | |
2241610 | 2241610 | 2022-06-28 | US | New Mexico | San Juan | 35045 | 43124 | 783 | 0 | 36.50838318 | -108.320437 | 2022-06-29 04:20:59 | San Juan, New Mexico, US | |
2149852 | 2149852 | 2022-06-27 | US | New Mexico | San Juan | 35045 | 43031 | 783 | 0 | 36.50838318 | -108.320437 | 2022-06-28 04:20:58 | San Juan, New Mexico, US | |
477653 | 477653 | 2022-06-26 | US | New Mexico | San Juan | 35045 | 42850 | 783 | 0 | 36.50838318 | -108.320437 | 2022-06-27 04:21:00 | San Juan, New Mexico, US | |
941028 | 941028 | 2022-06-25 | US | New Mexico | San Juan | 35045 | 42850 | 783 | 0 | 36.50838318 | -108.320437 | 2022-06-26 04:21:02 | San Juan, New Mexico, US | |
3348848 | 3348848 | 2022-06-24 | US | New Mexico | San Juan | 35045 | 42850 | 783 | 0 | 36.50838318 | -108.320437 | 2022-06-25 04:20:57 | San Juan, New Mexico, US | |
2237594 | 2237594 | 2022-06-12 | US | New Mexico | San Juan | 35045 | 41818 | 783 | 0 | 36.50838318 | -108.320437 | 2022-06-13 04:21:14 | San Juan, New Mexico, US | |
3143792 | 3143792 | 2022-06-11 | US | New Mexico | San Juan | 35045 | 41818 | 783 | 0 | 36.50838318 | -108.320437 | 2022-06-12 04:20:53 | San Juan, New Mexico, US | |
1946708 | 1946708 | 2022-06-10 | US | New Mexico | San Juan | 35045 | 41818 | 783 | 0 | 36.50838318 | -108.320437 | 2022-06-11 04:21:01 | San Juan, New Mexico, US | |
3580342 | 3580342 | 2022-06-02 | US | Minnesota | Dakota | 27037 | 116510 | 783 | 0 | 44.67172617 | -93.06299363 | 2022-06-03 04:20:58 | Dakota, Minnesota, US | |
1851962 | 1851962 | 2022-05-26 | US | Missouri | St. Louis City | 29510 | 58723 | 783 | 0 | 38.63555736 | -90.24349225 | 2022-05-27 04:20:56 | St. Louis City, Missouri, US | |
2049838 | 2049838 | 2022-05-25 | US | Missouri | St. Louis City | 29510 | 58723 | 783 | 0 | 38.63555736 | -90.24349225 | 2022-05-26 04:20:50 | St. Louis City, Missouri, US | |
3001276 | 3001276 | 2022-05-24 | US | Missouri | St. Louis City | 29510 | 58723 | 783 | 0 | 38.63555736 | -90.24349225 | 2022-05-25 04:20:56 | St. Louis City, Missouri, US | |
3595221 | 3595221 | 2022-05-23 | US | New Mexico | Dona Ana | 35013 | 64035 | 783 | 0 | 32.35275771 | -106.8329387 | 2022-05-24 04:20:57 | Dona Ana, New Mexico, US | |
3594997 | 3594997 | 2022-05-23 | US | Missouri | St. Louis City | 29510 | 58723 | 783 | 0 | 38.63555736 | -90.24349225 | 2022-05-24 04:20:57 | St. Louis City, Missouri, US | |
623849 | 623849 | 2022-05-22 | US | Missouri | St. Louis City | 29510 | 58723 | 783 | 0 | 38.63555736 | -90.24349225 | 2022-05-26 04:20:50 | St. Louis City, Missouri, US | |
1111769 | 1111769 | 2022-05-21 | US | New Mexico | Dona Ana | 35013 | 63932 | 783 | 0 | 32.35275771 | -106.8329387 | 2022-05-22 04:20:52 | Dona Ana, New Mexico, US | |
1111545 | 1111545 | 2022-05-21 | US | Missouri | St. Louis City | 29510 | 58723 | 783 | 0 | 38.63555736 | -90.24349225 | 2022-05-22 04:20:52 | St. Louis City, Missouri, US | |
1171393 | 1171393 | 2022-05-20 | US | New Mexico | Dona Ana | 35013 | 63932 | 783 | 0 | 32.35275771 | -106.8329387 | 2022-05-21 04:20:58 | Dona Ana, New Mexico, US | |
1171169 | 1171169 | 2022-05-20 | US | Missouri | St. Louis City | 29510 | 58723 | 783 | 0 | 38.63555736 | -90.24349225 | 2022-05-21 04:20:58 | St. Louis City, Missouri, US | |
3898156 | 3898156 | 2022-05-19 | US | New Mexico | Dona Ana | 35013 | 63863 | 783 | 0 | 32.35275771 | -106.8329387 | 2022-05-20 04:20:57 | Dona Ana, New Mexico, US | |
2535526 | 2535526 | 2022-05-12 | US | Nebraska | Unassigned | 90031 | 8701 | 783 | 0 | 42.8997274 | 0.0 | 2022-05-13 04:20:51 | Unassigned, Nebraska, US | |
3537141 | 3537141 | 2022-05-10 | US | Michigan | Ottawa | 26139 | 75716 | 783 | 0 | 42.95996803 | -85.9969107 | 2022-05-11 04:20:48 | Ottawa, Michigan, US | |
223676 | 223676 | 2022-05-09 | US | Michigan | Ottawa | 26139 | 75716 | 783 | 0 | 42.95996803 | -85.9969107 | 2022-05-10 04:20:50 | Ottawa, Michigan, US | |
2333061 | 2333061 | 2022-05-08 | US | Michigan | Ottawa | 26139 | 75716 | 783 | 0 | 42.95996803 | -85.9969107 | 2022-05-09 04:20:54 | Ottawa, Michigan, US | |
362023 | 362023 | 2022-05-07 | US | Michigan | Ottawa | 26139 | 75716 | 783 | 0 | 42.95996803 | -85.9969107 | 2022-05-08 04:20:49 | Ottawa, Michigan, US | |
1399374 | 1399374 | 2022-05-06 | US | Michigan | Ottawa | 26139 | 75716 | 783 | 0 | 42.95996803 | -85.9969107 | 2022-05-07 04:21:09 | Ottawa, Michigan, US | |
2599729 | 2599729 | 2022-05-05 | US | Michigan | Ottawa | 26139 | 75716 | 783 | 0 | 42.95996803 | -85.9969107 | 2022-05-06 04:21:00 | Ottawa, Michigan, US | |
3267178 | 3267178 | 2022-05-04 | US | Michigan | Ottawa | 26139 | 75716 | 783 | 0 | 42.95996803 | -85.9969107 | 2022-05-05 04:20:55 | Ottawa, Michigan, US | |
1848228 | 1848228 | 2022-04-18 | US | New York | Oneida | 36065 | 55009 | 783 | 0 | 43.24375382 | -75.43710392 | 2022-04-19 04:21:00 | Oneida, New York, US | |
3419172 | 3419172 | 2022-04-17 | US | New York | Oneida | 36065 | 54781 | 783 | 0 | 43.24375382 | -75.43710392 | 2022-04-18 04:21:12 | Oneida, New York, US | |
306121 | 306121 | 2022-04-16 | US | New York | Oneida | 36065 | 54781 | 783 | 0 | 43.24375382 | -75.43710392 | 2022-04-17 04:20:59 | Oneida, New York, US | |
2672066 | 2672066 | 2022-04-15 | US | New York | Oneida | 36065 | 54630 | 783 | 0 | 43.24375382 | -75.43710392 | 2022-04-16 04:20:48 | Oneida, New York, US | |
1225851 | 1225851 | 2022-04-14 | US | New York | Oneida | 36065 | 54480 | 783 | 0 | 43.24375382 | -75.43710392 | 2022-04-15 04:20:57 | Oneida, New York, US | |
2445009 | 2445009 | 2022-04-13 | US | New York | Oneida | 36065 | 54154 | 783 | 0 | 43.24375382 | -75.43710392 | 2022-04-13 23:21:06 | Oneida, New York, US | |
1541639 | 1541639 | 2022-03-31 | US | Michigan | Ottawa | 26139 | 74601 | 783 | 0 | 42.95996803 | -85.9969107 | 2022-04-01 04:20:28 | Ottawa, Michigan, US | |
2479652 | 2479652 | 2022-03-30 | US | Michigan | Ottawa | 26139 | 74601 | 783 | 0 | 42.95996803 | -85.9969107 | 2022-03-31 04:20:56 | Ottawa, Michigan, US | |
877945 | 877945 | 2022-03-27 | US | Michigan | Ottawa | 26139 | 74526 | 783 | 0 | 42.95996803 | -85.9969107 | 2022-03-28 04:20:33 | Ottawa, Michigan, US | |
2165228 | 2165228 | 2022-03-26 | US | Michigan | Ottawa | 26139 | 74526 | 783 | 0 | 42.95996803 | -85.9969107 | 2022-03-27 04:20:47 | Ottawa, Michigan, US | |
1722164 | 1722164 | 2022-03-25 | US | Michigan | Ottawa | 26139 | 74526 | 783 | 0 | 42.95996803 | -85.9969107 | 2022-03-26 04:20:23 | Ottawa, Michigan, US | |
3239345 | 3239345 | 2022-03-21 | US | Illinois | Madison | 17119 | 70051 | 783 | 0 | 38.83042506 | -89.90422563 | 2022-03-22 04:20:54 | Madison, Illinois, US | |
25418 | 25418 | 2022-03-20 | US | Illinois | Madison | 17119 | 70029 | 783 | 0 | 38.83042506 | -89.90422563 | 2022-03-21 04:20:50 | Madison, Illinois, US | |
1657428 | 1657428 | 2022-03-19 | US | Illinois | Madison | 17119 | 70029 | 783 | 0 | 38.83042506 | -89.90422563 | 2022-03-20 04:20:45 | Madison, Illinois, US | |
336954 | 336954 | 2022-03-18 | US | Illinois | Madison | 17119 | 70029 | 783 | 0 | 38.83042506 | -89.90422563 | 2022-03-19 04:20:47 | Madison, Illinois, US | |
695407 | 695407 | 2022-03-17 | US | Illinois | Madison | 17119 | 70021 | 783 | 0 | 38.83042506 | -89.90422563 | 2022-03-18 04:20:55 | Madison, Illinois, US | |
695242 | 695242 | 2022-03-17 | US | Georgia | Muscogee | 13215 | 37828 | 783 | 0 | 32.50931999 | -84.87142262 | 2022-03-18 04:20:55 | Muscogee, Georgia, US | |
2320350 | 2320350 | 2022-03-16 | US | Illinois | Madison | 17119 | 70008 | 783 | 0 | 38.83042506 | -89.90422563 | 2022-03-17 04:20:56 | Madison, Illinois, US | |
262550 | 262550 | 2022-03-15 | US | Illinois | Madison | 17119 | 69999 | 783 | 0 | 38.83042506 | -89.90422563 | 2022-03-16 04:20:50 | Madison, Illinois, US | |
922004 | 922004 | 2022-03-08 | US | North Carolina | Gaston | 37071 | 64780 | 783 | 0 | 35.29373559 | -81.17477045 | 2022-03-09 04:20:59 | Gaston, North Carolina, US | |
1644428 | 1644428 | 2022-03-03 | Malaysia | Terengganu | 100105 | 783 | 0 | 5.3117 | 103.1324 | 2022-03-04 04:21:09 | Terengganu, Malaysia | |||
1993125 | 1993125 | 2022-03-01 | US | Arkansas | Benton | 5007 | 65846 | 783 | 0 | 36.33644656 | -94.25680817 | 2022-03-02 04:21:07 | Benton, Arkansas, US | |
3912163 | 3912163 | 2022-02-20 | Pakistan | Azad Jammu and Kashmir | 42669 | 783 | 0 | 34.027401 | 73.947253 | 2022-02-21 04:21:05 | Azad Jammu and Kashmir, Pakistan | |||
319050 | 319050 | 2022-02-12 | US | Texas | Jefferson | 48245 | 42550 | 783 | 0 | 29.8832777 | -94.16434171 | 2022-02-13 04:21:00 | Jefferson, Texas, US | |
981973 | 981973 | 2022-02-01 | US | Texas | Bell | 48027 | 60734 | 783 | 0 | 31.03736027 | -97.4785025 | 2022-02-02 04:21:09 | Bell, Texas, US | |
2658659 | 2658659 | 2022-01-31 | US | Georgia | Richmond | 13245 | 47602 | 783 | 0 | 33.35777107 | -82.07026432 | 2022-02-01 04:21:11 | Richmond, Georgia, US | |
2054548 | 2054548 | 2022-01-25 | US | Pennsylvania | Cumberland | 42041 | 46699 | 783 | 0 | 40.1625372 | -77.26130755 | 2022-01-26 04:21:07 | Cumberland, Pennsylvania, US | |
1227529 | 1227529 | 2022-01-24 | Haiti | 28743 | 783 | 0 | 18.9712 | -72.2852 | 2022-01-25 04:21:05 | Haiti | ||||
1140828 | 1140828 | 2022-01-23 | Haiti | 28709 | 783 | 0 | 18.9712 | -72.2852 | 2022-01-24 04:21:12 | Haiti | ||||
2832746 | 2832746 | 2022-01-22 | Haiti | 28561 | 783 | 0 | 18.9712 | -72.2852 | 2022-01-23 04:21:13 | Haiti | ||||
3424864 | 3424864 | 2022-01-21 | Haiti | 28471 | 783 | 0 | 18.9712 | -72.2852 | 2022-01-22 04:21:13 | Haiti | ||||
1961011 | 1961011 | 2022-01-20 | US | Arizona | Navajo | 4017 | 32154 | 783 | 0 | 35.3997715 | -110.3218983 | 2022-01-21 04:21:09 | Navajo, Arizona, US | |
1960472 | 1960472 | 2022-01-20 | Haiti | 28352 | 783 | 0 | 18.9712 | -72.2852 | 2022-01-21 04:21:09 | Haiti | ||||
1113648 | 1113648 | 2022-01-11 | Malaysia | Pahang | 97498 | 783 | 0 | 3.8126 | 103.3256 | 2022-01-12 04:21:44 | Pahang, Malaysia | |||
129399 | 129399 | 2022-01-09 | US | Pennsylvania | Dauphin | 42043 | 48629 | 783 | 0 | 40.41377078 | -76.77993242 | 2022-01-10 04:22:07 | Dauphin, Pennsylvania, 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]);