johns_hopkins_csse_daily_reports

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

1,013 rows where combined_key = "Union, South Dakota, US" and province_or_state = "South Dakota" sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: day (date), last_update (date)

province_or_state 1

  • South Dakota · 1,013 ✖

country_or_region 1

  • US 1,013
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2755818 2755818 2022-12-29 US South Dakota Union 46127 4299 55 0   42.83112163 -96.6557828 2022-12-30 04:21:04 Union, South Dakota, US
1076824 1076824 2022-12-28 US South Dakota Union 46127 4299 55 0   42.83112163 -96.6557828 2022-12-29 04:21:01 Union, South Dakota, US
330821 330821 2022-12-27 US South Dakota Union 46127 4298 55 0   42.83112163 -96.6557828 2022-12-28 04:21:04 Union, South Dakota, US
220894 220894 2022-12-26 US South Dakota Union 46127 4298 55 0   42.83112163 -96.6557828 2022-12-27 04:21:07 Union, South Dakota, US
3225351 3225351 2022-12-25 US South Dakota Union 46127 4298 55 0   42.83112163 -96.6557828 2022-12-26 04:21:06 Union, South Dakota, US
1021265 1021265 2022-12-24 US South Dakota Union 46127 4298 55 0   42.83112163 -96.6557828 2022-12-25 04:21:04 Union, South Dakota, US
693288 693288 2022-12-23 US South Dakota Union 46127 4298 55 0   42.83112163 -96.6557828 2022-12-24 04:21:02 Union, South Dakota, US
2182498 2182498 2022-12-22 US South Dakota Union 46127 4298 55 0   42.83112163 -96.6557828 2022-12-23 04:21:04 Union, South Dakota, US
454302 454302 2022-12-21 US South Dakota Union 46127 4298 55 0   42.83112163 -96.6557828 2022-12-22 04:20:56 Union, South Dakota, US
2954301 2954301 2022-12-20 US South Dakota Union 46127 4290 55 0   42.83112163 -96.6557828 2022-12-21 04:21:03 Union, South Dakota, US
3176703 3176703 2022-12-19 US South Dakota Union 46127 4290 55 0   42.83112163 -96.6557828 2022-12-20 04:21:04 Union, South Dakota, US
1631220 1631220 2022-12-18 US South Dakota Union 46127 4290 55 0   42.83112163 -96.6557828 2022-12-19 04:21:03 Union, South Dakota, US
506599 506599 2022-12-17 US South Dakota Union 46127 4290 55 0   42.83112163 -96.6557828 2022-12-18 04:21:03 Union, South Dakota, US
3327171 3327171 2022-12-16 US South Dakota Union 46127 4290 55 0   42.83112163 -96.6557828 2022-12-17 04:21:04 Union, South Dakota, US
545683 545683 2022-12-15 US South Dakota Union 46127 4290 55 0   42.83112163 -96.6557828 2022-12-16 04:21:01 Union, South Dakota, US
351211 351211 2022-12-14 US South Dakota Union 46127 4290 55 0   42.83112163 -96.6557828 2022-12-15 04:20:58 Union, South Dakota, US
310799 310799 2022-12-13 US South Dakota Union 46127 4278 55 0   42.83112163 -96.6557828 2022-12-14 04:21:04 Union, South Dakota, US
1151860 1151860 2022-12-12 US South Dakota Union 46127 4278 55 0   42.83112163 -96.6557828 2022-12-13 04:21:01 Union, South Dakota, US
871714 871714 2022-12-11 US South Dakota Union 46127 4278 55 0   42.83112163 -96.6557828 2022-12-12 04:21:01 Union, South Dakota, US
260244 260244 2022-12-10 US South Dakota Union 46127 4278 55 0   42.83112163 -96.6557828 2022-12-11 04:20:50 Union, South Dakota, US
3938958 3938958 2022-12-09 US South Dakota Union 46127 4278 55 0   42.83112163 -96.6557828 2022-12-10 04:21:02 Union, South Dakota, US
3380290 3380290 2022-12-08 US South Dakota Union 46127 4278 55 0   42.83112163 -96.6557828 2022-12-09 04:21:05 Union, South Dakota, US
1987561 1987561 2022-12-07 US South Dakota Union 46127 4278 55 0   42.83112163 -96.6557828 2022-12-08 04:21:07 Union, South Dakota, US
3717084 3717084 2022-12-06 US South Dakota Union 46127 4265 55 0   42.83112163 -96.6557828 2022-12-07 04:20:58 Union, South Dakota, US
2417789 2417789 2022-12-05 US South Dakota Union 46127 4265 55 0   42.83112163 -96.6557828 2022-12-06 04:21:03 Union, South Dakota, US
721397 721397 2022-12-04 US South Dakota Union 46127 4265 55 0   42.83112163 -96.6557828 2022-12-05 04:20:58 Union, South Dakota, US
2819686 2819686 2022-12-03 US South Dakota Union 46127 4265 55 0   42.83112163 -96.6557828 2022-12-04 04:20:56 Union, South Dakota, US
836542 836542 2022-12-02 US South Dakota Union 46127 4265 55 0   42.83112163 -96.6557828 2022-12-03 04:21:02 Union, South Dakota, US
2139072 2139072 2022-12-01 US South Dakota Union 46127 4265 55 0   42.83112163 -96.6557828 2022-12-02 04:21:07 Union, South Dakota, US
1967488 1967488 2022-11-30 US South Dakota Union 46127 4265 55 0   42.83112163 -96.6557828 2022-12-01 04:21:03 Union, South Dakota, US
2559502 2559502 2022-11-29 US South Dakota Union 46127 4251 55 0   42.83112163 -96.6557828 2022-11-30 04:21:07 Union, South Dakota, US
1242576 1242576 2022-11-28 US South Dakota Union 46127 4251 55 0   42.83112163 -96.6557828 2022-11-29 04:21:05 Union, South Dakota, US
3554564 3554564 2022-11-27 US South Dakota Union 46127 4251 55 0   42.83112163 -96.6557828 2022-11-28 04:21:02 Union, South Dakota, US
2103044 2103044 2022-11-26 US South Dakota Union 46127 4251 55 0   42.83112163 -96.6557828 2022-11-27 04:21:05 Union, South Dakota, US
490535 490535 2022-11-25 US South Dakota Union 46127 4251 55 0   42.83112163 -96.6557828 2022-11-26 04:21:11 Union, South Dakota, US
3526364 3526364 2022-11-24 US South Dakota Union 46127 4251 55 0   42.83112163 -96.6557828 2022-11-25 04:21:06 Union, South Dakota, US
3315147 3315147 2022-11-23 US South Dakota Union 46127 4251 55 0   42.83112163 -96.6557828 2022-11-24 04:21:09 Union, South Dakota, US
1623188 1623188 2022-11-22 US South Dakota Union 46127 4243 55 0   42.83112163 -96.6557828 2022-11-23 04:21:06 Union, South Dakota, US
3463076 3463076 2022-11-21 US South Dakota Union 46127 4243 55 0   42.83112163 -96.6557828 2022-11-22 04:20:47 Union, South Dakota, US
1643261 1643261 2022-11-20 US South Dakota Union 46127 4243 55 0   42.83112163 -96.6557828 2022-11-21 04:21:05 Union, South Dakota, US
2066818 2066818 2022-11-19 US South Dakota Union 46127 4243 55 0   42.83112163 -96.6557828 2022-11-20 04:21:08 Union, South Dakota, US
1758212 1758212 2022-11-18 US South Dakota Union 46127 4243 55 0   42.83112163 -96.6557828 2022-11-19 04:21:14 Union, South Dakota, US
3029205 3029205 2022-11-17 US South Dakota Union 46127 4243 55 0   42.83112163 -96.6557828 2022-11-18 04:21:15 Union, South Dakota, US
2488916 2488916 2022-11-16 US South Dakota Union 46127 4243 55 0   42.83112163 -96.6557828 2022-11-17 04:21:11 Union, South Dakota, US
294927 294927 2022-11-15 US South Dakota Union 46127 4234 54 0   42.83112163 -96.6557828 2022-11-16 04:21:09 Union, South Dakota, US
3599957 3599957 2022-11-14 US South Dakota Union 46127 4234 54 0   42.83112163 -96.6557828 2022-11-15 04:21:16 Union, South Dakota, US
314815 314815 2022-11-13 US South Dakota Union 46127 4234 54 0   42.83112163 -96.6557828 2022-11-14 04:21:09 Union, South Dakota, US
65976 65976 2022-11-12 US South Dakota Union 46127 4234 54 0   42.83112163 -96.6557828 2022-11-13 04:21:14 Union, South Dakota, US
2930138 2930138 2022-11-11 US South Dakota Union 46127 4234 54 0   42.83112163 -96.6557828 2022-11-12 04:20:41 Union, South Dakota, US
2508974 2508974 2022-11-10 US South Dakota Union 46127 4234 54 0   42.83112163 -96.6557828 2022-11-11 04:21:22 Union, South Dakota, US
2433849 2433849 2022-11-09 US South Dakota Union 46127 4234 54 0   42.83112163 -96.6557828 2022-11-10 04:21:16 Union, South Dakota, US
482505 482505 2022-11-08 US South Dakota Union 46127 4230 53 0   42.83112163 -96.6557828 2022-11-09 04:21:22 Union, South Dakota, US
2441655 2441655 2022-11-07 US South Dakota Union 46127 4230 53 0   42.83112163 -96.6557828 2022-11-08 04:21:21 Union, South Dakota, US
1052753 1052753 2022-11-06 US South Dakota Union 46127 4230 53 0   42.83112163 -96.6557828 2022-11-07 04:21:26 Union, South Dakota, US
620777 620777 2022-11-05 US South Dakota Union 46127 4230 53 0   42.83112163 -96.6557828 2022-11-06 04:21:24 Union, South Dakota, US
1025281 1025281 2022-11-04 US South Dakota Union 46127 4230 53 0   42.83112163 -96.6557828 2022-11-05 04:21:52 Union, South Dakota, US
434272 434272 2022-11-03 US South Dakota Union 46127 4230 53 0   42.83112163 -96.6557828 2022-11-04 04:22:11 Union, South Dakota, US
852514 852514 2022-11-02 US South Dakota Union 46127 4230 53 0   42.83112163 -96.6557828 2022-11-03 04:22:05 Union, South Dakota, US
713365 713365 2022-11-01 US South Dakota Union 46127 4219 53 0   42.83112163 -96.6557828 2022-11-02 04:22:09 Union, South Dakota, US
3287814 3287814 2022-10-31 US South Dakota Union 46127 4219 53 0   42.83112163 -96.6557828 2022-11-01 04:22:36 Union, South Dakota, US
322847 322847 2022-10-30 US South Dakota Union 46127 4219 53 0   42.83112163 -96.6557828 2022-10-31 04:21:36 Union, South Dakota, US
915123 915123 2022-10-29 US South Dakota Union 46127 4219 53 0   42.83112163 -96.6557828 2022-10-30 04:22:14 Union, South Dakota, US
1369392 1369392 2022-10-28 US South Dakota Union 46127 4219 53 0   42.83112163 -96.6557828 2022-10-29 04:21:13 Union, South Dakota, US
3041247 3041247 2022-10-27 US South Dakota Union 46127 4219 53 0   42.83112163 -96.6557828 2022-10-28 04:22:31 Union, South Dakota, US
541667 541667 2022-10-26 US South Dakota Union 46127 4219 53 0   42.83112163 -96.6557828 2022-10-27 04:22:01 Union, South Dakota, US
1833068 1833068 2022-10-25 US South Dakota Union 46127 4218 53 0   42.83112163 -96.6557828 2022-10-26 04:22:19 Union, South Dakota, US
797329 797329 2022-10-24 US South Dakota Union 46127 4218 53 0   42.83112163 -96.6557828 2022-10-25 04:21:53 Union, South Dakota, US
3279784 3279784 2022-10-23 US South Dakota Union 46127 4218 53 0   42.83112163 -96.6557828 2022-10-24 04:22:29 Union, South Dakota, US
2270822 2270822 2022-10-22 US South Dakota Union 46127 4218 53 0   42.83112163 -96.6557828 2022-10-23 04:22:46 Union, South Dakota, US
1595122 1595122 2022-10-21 US South Dakota Union 46127 4218 53 0   42.83112163 -96.6557828 2022-10-22 04:22:53 Union, South Dakota, US
2274838 2274838 2022-10-20 US South Dakota Union 46127 4218 53 0   42.83112163 -96.6557828 2022-10-21 04:22:23 Union, South Dakota, US
201173 201173 2022-10-19 US South Dakota Union 46127 4218 53 0   42.83112163 -96.6557828 2022-10-20 04:22:59 Union, South Dakota, US
2759834 2759834 2022-10-18 US South Dakota Union 46127 4217 53 0   42.83112163 -96.6557828 2022-10-19 04:22:26 Union, South Dakota, US
2027668 2027668 2022-10-17 US South Dakota Union 46127 4217 53 0   42.83112163 -96.6557828 2022-10-18 04:22:42 Union, South Dakota, US
2162446 2162446 2022-10-16 US South Dakota Union 46127 4217 53 0   42.83112163 -96.6557828 2022-10-17 04:20:31 Union, South Dakota, US
518643 518643 2022-10-15 US South Dakota Union 46127 4217 53 0   42.83112163 -96.6557828 2022-10-16 04:22:39 Union, South Dakota, US
2035700 2035700 2022-10-14 US South Dakota Union 46127 4217 53 0   42.83112163 -96.6557828 2022-10-15 04:22:00 Union, South Dakota, US
3756388 3756388 2022-10-13 US South Dakota Union 46127 4217 53 0   42.83112163 -96.6557828 2022-10-14 04:22:28 Union, South Dakota, US
3217213 3217213 2022-10-12 US South Dakota Union 46127 4217 53 0   42.83112163 -96.6557828 2022-10-13 04:22:39 Union, South Dakota, US
3253062 3253062 2022-10-11 US South Dakota Union 46127 4215 53 0   42.83112163 -96.6557828 2022-10-12 04:22:51 Union, South Dakota, US
2970321 2970321 2022-10-10 US South Dakota Union 46127 4215 53 0   42.83112163 -96.6557828 2022-10-11 04:23:05 Union, South Dakota, US
3100357 3100357 2022-10-09 US South Dakota Union 46127 4215 53 0   42.83112163 -96.6557828 2022-10-10 04:22:32 Union, South Dakota, US
4005582 4005582 2022-10-08 US South Dakota Union 46127 4215 53 0   42.83112163 -96.6557828 2022-10-09 04:21:16 Union, South Dakota, US
399179 399179 2022-10-07 US South Dakota Union 46127 4215 53 0   42.83112163 -96.6557828 2022-10-08 04:22:56 Union, South Dakota, US
2532296 2532296 2022-10-06 US South Dakota Union 46127 4215 53 0   42.83112163 -96.6557828 2022-10-07 04:23:08 Union, South Dakota, US
1813690 1813690 2022-10-05 US South Dakota Union 46127 4215 53 0   42.83112163 -96.6557828 2022-10-06 04:21:22 Union, South Dakota, US
133664 133664 2022-10-04 US South Dakota Union 46127 4206 52 0   42.83112163 -96.6557828 2022-10-05 04:23:06 Union, South Dakota, US
2688611 2688611 2022-10-03 US South Dakota Union 46127 4206 52 0   42.83112163 -96.6557828 2022-10-04 04:22:55 Union, South Dakota, US
2262678 2262678 2022-10-02 US South Dakota Union 46127 4206 52 0   42.83112163 -96.6557828 2022-10-03 04:23:11 Union, South Dakota, US
2998204 2998204 2022-10-01 US South Dakota Union 46127 4206 52 0   42.83112163 -96.6557828 2022-10-02 04:21:23 Union, South Dakota, US
856530 856530 2022-09-30 US South Dakota Union 46127 4206 52 0   42.83112163 -96.6557828 2022-10-01 04:23:01 Union, South Dakota, US
2378456 2378456 2022-09-29 US South Dakota Union 46127 4206 52 0   42.83112163 -96.6557828 2022-09-30 04:23:09 Union, South Dakota, US
1563007 1563007 2022-09-28 US South Dakota Union 46127 4206 52 0   42.83112163 -96.6557828 2022-09-29 04:22:34 Union, South Dakota, US
3997550 3997550 2022-09-27 US South Dakota Union 46127 4202 52 0   42.83112163 -96.6557828 2022-09-28 04:23:01 Union, South Dakota, US
2771878 2771878 2022-09-26 US South Dakota Union 46127 4202 52 0   42.83112163 -96.6557828 2022-09-27 04:23:01 Union, South Dakota, US
1979531 1979531 2022-09-25 US South Dakota Union 46127 4202 52 0   42.83112163 -96.6557828 2022-09-26 04:20:52 Union, South Dakota, US
2652698 2652698 2022-09-24 US South Dakota Union 46127 4202 52 0   42.83112163 -96.6557828 2022-09-25 04:23:31 Union, South Dakota, US
387138 387138 2022-09-23 US South Dakota Union 46127 4202 52 0   42.83112163 -96.6557828 2022-09-24 04:21:40 Union, South Dakota, US
1627204 1627204 2022-09-22 US South Dakota Union 46127 4202 52 0   42.83112163 -96.6557828 2022-09-23 04:23:13 Union, South Dakota, US
1373408 1373408 2022-09-21 US South Dakota Union 46127 4202 52 0   42.83112163 -96.6557828 2022-09-22 04:22:56 Union, South Dakota, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);