daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
497 rows where confirmed = 1295 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-15 | US | New Mexico | Hidalgo | 35023 | 1295 | 16 | 0 | 31.91383467 | -108.7151824 | 2022-12-16 04:21:01 | Hidalgo, New Mexico, US | |
2022-11-29 | US | Wisconsin | Florence | 55037 | 1295 | 17 | 0 | 45.84963535 | -88.39804137 | 2022-11-30 04:21:07 | Florence, Wisconsin, US | |
2022-11-22 | US | Texas | Concho | 48095 | 1295 | 12 | 0 | 31.32635934 | -99.86473038 | 2022-11-23 04:21:06 | Concho, Texas, US | |
2022-11-21 | US | Texas | Concho | 48095 | 1295 | 12 | 0 | 31.32635934 | -99.86473038 | 2022-11-22 04:20:47 | Concho, Texas, US | |
2022-10-27 | US | Virginia | Surry | 51181 | 1295 | 21 | 0 | 37.11781893 | -76.88450012 | 2022-10-28 04:22:31 | Surry, Virginia, US | |
2022-10-25 | US | Virginia | Surry | 51181 | 1295 | 21 | 0 | 37.11781893 | -76.88450012 | 2022-10-26 04:22:19 | Surry, Virginia, US | |
2022-10-24 | US | Virginia | Surry | 51181 | 1295 | 21 | 0 | 37.11781893 | -76.88450012 | 2022-10-25 04:21:53 | Surry, Virginia, US | |
2022-09-27 | US | Georgia | Talbot | 13263 | 1295 | 34 | 0 | 32.69642758 | -84.53351366 | 2022-09-28 04:23:01 | Talbot, Georgia, US | |
2022-09-26 | US | Georgia | Talbot | 13263 | 1295 | 34 | 0 | 32.69642758 | -84.53351366 | 2022-09-27 04:23:01 | Talbot, Georgia, US | |
2022-09-25 | US | Georgia | Talbot | 13263 | 1295 | 34 | 0 | 32.69642758 | -84.53351366 | 2022-09-26 04:20:52 | Talbot, Georgia, US | |
2022-09-24 | US | Georgia | Talbot | 13263 | 1295 | 34 | 0 | 32.69642758 | -84.53351366 | 2022-09-25 04:23:31 | Talbot, Georgia, US | |
2022-09-23 | US | Georgia | Talbot | 13263 | 1295 | 34 | 0 | 32.69642758 | -84.53351366 | 2022-09-24 04:21:40 | Talbot, Georgia, US | |
2022-09-22 | US | Georgia | Talbot | 13263 | 1295 | 34 | 0 | 32.69642758 | -84.53351366 | 2022-09-23 04:23:13 | Talbot, Georgia, US | |
2022-09-21 | US | Georgia | Talbot | 13263 | 1295 | 34 | 0 | 32.69642758 | -84.53351366 | 2022-09-22 04:22:56 | Talbot, Georgia, US | |
2022-09-20 | China | Tibet | 1295 | 0 | 0 | 31.6927 | 88.0924 | 2022-09-21 04:23:22 | Tibet, China | |||
2022-09-07 | US | Illinois | Hardin | 17069 | 1295 | 20 | 0 | 37.51810645 | -88.26873022 | 2022-09-08 04:21:02 | Hardin, Illinois, US | |
2022-08-23 | US | South Dakota | Lyman | 46085 | 1295 | 13 | 0 | 43.89522709 | -99.85201878 | 2022-08-24 04:20:46 | Lyman, South Dakota, US | |
2022-08-23 | US | Louisiana | Cameron | 22023 | 1295 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-08-24 04:20:46 | Cameron, Louisiana, US | |
2022-08-22 | US | South Dakota | Lyman | 46085 | 1295 | 13 | 0 | 43.89522709 | -99.85201878 | 2022-08-23 04:20:56 | Lyman, South Dakota, US | |
2022-08-22 | US | Louisiana | Cameron | 22023 | 1295 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-08-23 04:20:56 | Cameron, Louisiana, US | |
2022-08-21 | US | South Dakota | Lyman | 46085 | 1295 | 13 | 0 | 43.89522709 | -99.85201878 | 2022-08-22 04:20:38 | Lyman, South Dakota, US | |
2022-08-20 | US | South Dakota | Lyman | 46085 | 1295 | 13 | 0 | 43.89522709 | -99.85201878 | 2022-08-21 04:20:44 | Lyman, South Dakota, US | |
2022-08-19 | US | South Dakota | Lyman | 46085 | 1295 | 13 | 0 | 43.89522709 | -99.85201878 | 2022-08-20 04:21:01 | Lyman, South Dakota, US | |
2022-08-18 | US | South Dakota | Lyman | 46085 | 1295 | 13 | 0 | 43.89522709 | -99.85201878 | 2022-08-19 04:20:54 | Lyman, South Dakota, US | |
2022-08-17 | US | South Dakota | Lyman | 46085 | 1295 | 13 | 0 | 43.89522709 | -99.85201878 | 2022-08-18 04:21:11 | Lyman, South Dakota, US | |
2022-08-16 | US | South Dakota | Lyman | 46085 | 1295 | 13 | 0 | 43.89522709 | -99.85201878 | 2022-08-17 04:20:59 | Lyman, South Dakota, US | |
2022-08-15 | US | South Dakota | Lyman | 46085 | 1295 | 13 | 0 | 43.89522709 | -99.85201878 | 2022-08-16 04:20:58 | Lyman, South Dakota, US | |
2022-08-14 | US | South Dakota | Lyman | 46085 | 1295 | 13 | 0 | 43.89522709 | -99.85201878 | 2022-08-15 04:20:59 | Lyman, South Dakota, US | |
2022-08-13 | US | South Dakota | Lyman | 46085 | 1295 | 13 | 0 | 43.89522709 | -99.85201878 | 2022-08-14 04:20:55 | Lyman, South Dakota, US | |
2022-08-12 | US | South Dakota | Lyman | 46085 | 1295 | 13 | 0 | 43.89522709 | -99.85201878 | 2022-08-13 04:20:52 | Lyman, South Dakota, US | |
2022-08-11 | US | South Dakota | Lyman | 46085 | 1295 | 13 | 0 | 43.89522709 | -99.85201878 | 2022-08-12 04:20:54 | Lyman, South Dakota, US | |
2022-08-10 | US | South Dakota | Lyman | 46085 | 1295 | 13 | 0 | 43.89522709 | -99.85201878 | 2022-08-11 04:20:49 | Lyman, South Dakota, US | |
2022-08-10 | US | Minnesota | Lincoln | 27081 | 1295 | 6 | 0 | 44.41311883 | -96.26688165 | 2022-08-11 04:20:49 | Lincoln, Minnesota, US | |
2022-08-09 | US | Minnesota | Lincoln | 27081 | 1295 | 6 | 0 | 44.41311883 | -96.26688165 | 2022-08-10 04:20:57 | Lincoln, Minnesota, US | |
2022-08-08 | US | Minnesota | Lincoln | 27081 | 1295 | 6 | 0 | 44.41311883 | -96.26688165 | 2022-08-09 04:20:34 | Lincoln, Minnesota, US | |
2022-08-07 | US | Minnesota | Lincoln | 27081 | 1295 | 6 | 0 | 44.41311883 | -96.26688165 | 2022-08-08 04:21:08 | Lincoln, Minnesota, US | |
2022-08-06 | US | Minnesota | Lincoln | 27081 | 1295 | 6 | 0 | 44.41311883 | -96.26688165 | 2022-08-07 04:20:54 | Lincoln, Minnesota, US | |
2022-08-05 | US | Minnesota | Lincoln | 27081 | 1295 | 6 | 0 | 44.41311883 | -96.26688165 | 2022-08-06 04:20:56 | Lincoln, Minnesota, US | |
2022-08-04 | US | Minnesota | Lincoln | 27081 | 1295 | 6 | 0 | 44.41311883 | -96.26688165 | 2022-08-05 04:20:52 | Lincoln, Minnesota, US | |
2022-07-27 | US | Virginia | Charles City | 51036 | 1295 | 29 | 0 | 37.35358063 | -77.05634116 | 2022-07-28 04:20:56 | Charles City, Virginia, US | |
2022-07-10 | US | Texas | Goliad | 48175 | 1295 | 32 | 0 | 28.65696592 | -97.42760647 | 2022-07-11 04:20:46 | Goliad, Texas, US | |
2022-06-29 | US | Texas | Garza | 48169 | 1295 | 28 | 0 | 33.17969345 | -101.2984114 | 2022-06-30 04:21:01 | Garza, Texas, US | |
2022-06-27 | US | Texas | Sabine | 48403 | 1295 | 89 | 0 | 31.34318809 | -93.85440451 | 2022-06-28 04:20:58 | Sabine, Texas, US | |
2022-06-26 | US | Texas | Sabine | 48403 | 1295 | 89 | 0 | 31.34318809 | -93.85440451 | 2022-06-27 04:21:00 | Sabine, Texas, US | |
2022-06-25 | US | Texas | Sabine | 48403 | 1295 | 89 | 0 | 31.34318809 | -93.85440451 | 2022-06-26 04:21:02 | Sabine, Texas, US | |
2022-06-06 | US | Montana | Broadwater | 30007 | 1295 | 21 | 0 | 46.33277565 | -111.4955813 | 2022-06-07 04:21:08 | Broadwater, Montana, US | |
2022-06-05 | US | Montana | Broadwater | 30007 | 1295 | 21 | 0 | 46.33277565 | -111.4955813 | 2022-06-06 04:20:57 | Broadwater, Montana, US | |
2022-06-05 | US | Illinois | Scott | 17171 | 1295 | 12 | 0 | 39.6429169 | -90.47814431 | 2022-06-06 04:20:57 | Scott, Illinois, US | |
2022-06-04 | US | Montana | Broadwater | 30007 | 1295 | 21 | 0 | 46.33277565 | -111.4955813 | 2022-06-05 04:20:55 | Broadwater, Montana, US | |
2022-06-04 | US | Illinois | Scott | 17171 | 1295 | 12 | 0 | 39.6429169 | -90.47814431 | 2022-06-05 04:20:55 | Scott, Illinois, US | |
2022-06-03 | US | Texas | Crane | 48103 | 1295 | 24 | 0 | 31.43052248 | -102.5143314 | 2022-06-04 04:20:58 | Crane, Texas, US | |
2022-06-03 | US | Montana | Broadwater | 30007 | 1295 | 21 | 0 | 46.33277565 | -111.4955813 | 2022-06-04 04:20:58 | Broadwater, Montana, US | |
2022-06-03 | US | Illinois | Scott | 17171 | 1295 | 12 | 0 | 39.6429169 | -90.47814431 | 2022-06-04 04:20:58 | Scott, Illinois, US | |
2022-06-02 | US | Texas | Crane | 48103 | 1295 | 24 | 0 | 31.43052248 | -102.5143314 | 2022-06-03 04:20:58 | Crane, Texas, US | |
2022-06-02 | US | Montana | Broadwater | 30007 | 1295 | 21 | 0 | 46.33277565 | -111.4955813 | 2022-06-03 04:20:58 | Broadwater, Montana, US | |
2022-06-01 | US | Montana | Broadwater | 30007 | 1295 | 21 | 0 | 46.33277565 | -111.4955813 | 2022-06-02 05:20:39 | Broadwater, Montana, US | |
2022-05-31 | US | Montana | Broadwater | 30007 | 1295 | 21 | 0 | 46.33277565 | -111.4955813 | 2022-06-01 04:20:55 | Broadwater, Montana, US | |
2022-05-30 | US | Montana | Broadwater | 30007 | 1295 | 21 | 0 | 46.33277565 | -111.4955813 | 2022-05-31 04:20:51 | Broadwater, Montana, US | |
2022-05-29 | US | Montana | Broadwater | 30007 | 1295 | 21 | 0 | 46.33277565 | -111.4955813 | 2022-05-30 04:20:50 | Broadwater, Montana, US | |
2022-05-28 | US | Montana | Broadwater | 30007 | 1295 | 21 | 0 | 46.33277565 | -111.4955813 | 2022-05-29 04:20:53 | Broadwater, Montana, US | |
2022-05-27 | US | Montana | Broadwater | 30007 | 1295 | 21 | 0 | 46.33277565 | -111.4955813 | 2022-05-28 04:21:07 | Broadwater, Montana, US | |
2022-05-17 | US | South Dakota | Day | 46037 | 1295 | 35 | 0 | 45.367281 | -97.60737498 | 2022-05-18 04:20:50 | Day, South Dakota, US | |
2022-05-16 | US | South Dakota | Day | 46037 | 1295 | 35 | 0 | 45.367281 | -97.60737498 | 2022-05-17 04:20:59 | Day, South Dakota, US | |
2022-05-15 | US | South Dakota | Day | 46037 | 1295 | 35 | 0 | 45.367281 | -97.60737498 | 2022-05-16 04:20:47 | Day, South Dakota, US | |
2022-05-14 | US | South Dakota | Day | 46037 | 1295 | 35 | 0 | 45.367281 | -97.60737498 | 2022-05-15 04:20:53 | Day, South Dakota, US | |
2022-05-13 | US | South Dakota | Day | 46037 | 1295 | 35 | 0 | 45.367281 | -97.60737498 | 2022-05-14 04:20:48 | Day, South Dakota, US | |
2022-05-12 | US | South Dakota | Day | 46037 | 1295 | 35 | 0 | 45.367281 | -97.60737498 | 2022-05-13 04:20:51 | Day, South Dakota, US | |
2022-05-11 | US | South Dakota | Day | 46037 | 1295 | 35 | 0 | 45.367281 | -97.60737498 | 2022-05-12 04:20:54 | Day, South Dakota, US | |
2022-05-04 | US | Oklahoma | Greer | 40055 | 1295 | 37 | 0 | 34.93535801 | -99.5605612 | 2022-05-05 04:20:55 | Greer, Oklahoma, US | |
2022-05-03 | US | Oklahoma | Greer | 40055 | 1295 | 37 | 0 | 34.93535801 | -99.5605612 | 2022-05-04 04:20:59 | Greer, Oklahoma, US | |
2022-05-02 | US | Oklahoma | Greer | 40055 | 1295 | 37 | 0 | 34.93535801 | -99.5605612 | 2022-05-03 04:21:00 | Greer, Oklahoma, US | |
2022-05-01 | US | Oklahoma | Greer | 40055 | 1295 | 37 | 0 | 34.93535801 | -99.5605612 | 2022-05-02 04:21:10 | Greer, Oklahoma, US | |
2022-04-30 | US | Oklahoma | Greer | 40055 | 1295 | 37 | 0 | 34.93535801 | -99.5605612 | 2022-05-01 04:20:57 | Greer, Oklahoma, US | |
2022-04-29 | US | Oklahoma | Greer | 40055 | 1295 | 37 | 0 | 34.93535801 | -99.5605612 | 2022-04-30 04:21:05 | Greer, Oklahoma, US | |
2022-04-28 | US | Oklahoma | Greer | 40055 | 1295 | 37 | 0 | 34.93535801 | -99.5605612 | 2022-04-29 04:20:59 | Greer, Oklahoma, US | |
2022-04-27 | US | Oklahoma | Greer | 40055 | 1295 | 37 | 0 | 34.93535801 | -99.5605612 | 2022-04-28 04:20:47 | Greer, Oklahoma, US | |
2022-04-26 | US | Oklahoma | Greer | 40055 | 1295 | 37 | 0 | 34.93535801 | -99.56056120000001 | 2022-04-27 04:20:52 | Greer, Oklahoma, US | |
2022-04-25 | US | Oklahoma | Greer | 40055 | 1295 | 37 | 0 | 34.93535801 | -99.56056120000001 | 2022-04-26 04:20:51 | Greer, Oklahoma, US | |
2022-04-24 | US | Oklahoma | Greer | 40055 | 1295 | 37 | 0 | 34.93535801 | -99.56056120000001 | 2022-04-25 04:20:56 | Greer, Oklahoma, US | |
2022-04-23 | US | Oklahoma | Greer | 40055 | 1295 | 37 | 0 | 34.93535801 | -99.56056120000001 | 2022-04-24 04:20:56 | Greer, Oklahoma, US | |
2022-04-22 | US | Oklahoma | Greer | 40055 | 1295 | 37 | 0 | 34.93535801 | -99.56056120000001 | 2022-04-23 04:20:50 | Greer, Oklahoma, US | |
2022-04-21 | US | Oklahoma | Greer | 40055 | 1295 | 37 | 0 | 34.93535801 | -99.56056120000001 | 2022-04-22 04:20:45 | Greer, Oklahoma, US | |
2022-04-10 | US | Virginia | Cumberland | 51049 | 1295 | 26 | 0 | 37.51328851 | -78.24398086 | 2022-04-11 04:21:02 | Cumberland, Virginia, US | |
2022-04-09 | US | Virginia | Cumberland | 51049 | 1295 | 26 | 0 | 37.51328851 | -78.24398086 | 2022-04-10 04:20:52 | Cumberland, Virginia, US | |
2022-04-08 | US | Virginia | Cumberland | 51049 | 1295 | 26 | 0 | 37.51328851 | -78.24398086 | 2022-04-09 04:20:42 | Cumberland, Virginia, US | |
2022-03-24 | US | Arkansas | Lafayette | 5073 | 1295 | 31 | 0 | 33.24116713 | -93.60677071 | 2022-03-25 04:20:46 | Lafayette, Arkansas, US | |
2022-03-09 | US | Virginia | Norton | 51720 | 1295 | 22 | 0 | 36.93357076 | -82.62750411 | 2022-03-10 04:20:48 | Norton, Virginia, US | |
2022-03-08 | US | Virginia | Norton | 51720 | 1295 | 22 | 0 | 36.93357076 | -82.62750411 | 2022-03-09 04:20:59 | Norton, Virginia, US | |
2022-03-06 | China | Shandong | 1295 | 7 | 0 | 36.3427 | 118.1498 | 2022-03-07 04:20:47 | Shandong, China | |||
2022-03-05 | US | North Dakota | McHenry | 38049 | 1295 | 31 | 0 | 48.23104458 | -100.6324822 | 2022-03-06 04:20:49 | McHenry, North Dakota, US | |
2022-03-04 | US | North Dakota | McHenry | 38049 | 1295 | 30 | 0 | 48.23104458 | -100.6324822 | 2022-03-05 04:21:10 | McHenry, North Dakota, US | |
2022-02-27 | US | North Carolina | Hyde | 37095 | 1295 | 13 | 0 | 35.42017674 | -76.15180542 | 2022-02-28 04:21:05 | Hyde, North Carolina, US | |
2022-02-26 | US | North Carolina | Hyde | 37095 | 1295 | 13 | 0 | 35.42017674 | -76.15180542 | 2022-02-27 04:21:04 | Hyde, North Carolina, US | |
2022-02-25 | US | North Carolina | Hyde | 37095 | 1295 | 13 | 0 | 35.42017674 | -76.15180542 | 2022-02-26 04:21:12 | Hyde, North Carolina, US | |
2022-02-15 | US | Texas | Hartley | 48205 | 1295 | 3 | 0 | 35.84008013 | -102.6029022 | 2022-02-16 04:21:10 | Hartley, Texas, US | |
2022-02-15 | US | South Dakota | Walworth | 46129 | 1295 | 23 | 0 | 45.43019636 | -100.03075140000001 | 2022-02-16 04:21:10 | Walworth, South Dakota, US | |
2022-02-10 | US | Kentucky | Menifee | 21165 | 1295 | 30 | 0 | 37.94090733 | -83.59985712 | 2022-02-11 04:21:09 | Menifee, Kentucky, US | |
2022-02-02 | US | Nebraska | Dawes | 31045 | 1295 | 12 | 0 | 42.71985036 | -103.1313774 | 2022-02-03 04:21:21 | Dawes, Nebraska, US | |
2022-01-27 | US | South Dakota | McCook | 46087 | 1295 | 30 | 0 | 43.6742571 | -97.36863144 | 2022-01-28 04:21:09 | McCook, South Dakota, US | |
2022-01-27 | US | Minnesota | Grant | 27051 | 1295 | 12 | 0 | 45.93424769 | -96.01139609 | 2022-01-28 04:21:09 | Grant, Minnesota, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;