ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Jackson" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
79866 | 79866 | 2020-04-22 | Jackson | Missouri | 29095 | 288 | 12 |
77080 | 77080 | 2020-04-21 | Jackson | Missouri | 29095 | 279 | 11 |
74299 | 74299 | 2020-04-20 | Jackson | Missouri | 29095 | 271 | 11 |
71526 | 71526 | 2020-04-19 | Jackson | Missouri | 29095 | 268 | 11 |
68759 | 68759 | 2020-04-18 | Jackson | Missouri | 29095 | 268 | 11 |
66007 | 66007 | 2020-04-17 | Jackson | Missouri | 29095 | 267 | 11 |
63267 | 63267 | 2020-04-16 | Jackson | Missouri | 29095 | 260 | 11 |
60545 | 60545 | 2020-04-15 | Jackson | Missouri | 29095 | 243 | 9 |
57832 | 57832 | 2020-04-14 | Jackson | Missouri | 29095 | 237 | 9 |
55134 | 55134 | 2020-04-13 | Jackson | Missouri | 29095 | 223 | 7 |
52452 | 52452 | 2020-04-12 | Jackson | Missouri | 29095 | 213 | 7 |
49779 | 49779 | 2020-04-11 | Jackson | Missouri | 29095 | 208 | 7 |
47131 | 47131 | 2020-04-10 | Jackson | Missouri | 29095 | 193 | 5 |
44522 | 44522 | 2020-04-09 | Jackson | Missouri | 29095 | 177 | 5 |
41945 | 41945 | 2020-04-08 | Jackson | Missouri | 29095 | 167 | 5 |
39391 | 39391 | 2020-04-07 | Jackson | Missouri | 29095 | 154 | 4 |
36878 | 36878 | 2020-04-06 | Jackson | Missouri | 29095 | 149 | 4 |
34414 | 34414 | 2020-04-05 | Jackson | Missouri | 29095 | 139 | 4 |
31986 | 31986 | 2020-04-04 | Jackson | Missouri | 29095 | 135 | 3 |
29606 | 29606 | 2020-04-03 | Jackson | Missouri | 29095 | 120 | 3 |
27286 | 27286 | 2020-04-02 | Jackson | Missouri | 29095 | 103 | 2 |
25030 | 25030 | 2020-04-01 | Jackson | Missouri | 29095 | 86 | 2 |
22842 | 22842 | 2020-03-31 | Jackson | Missouri | 29095 | 77 | 1 |
20723 | 20723 | 2020-03-30 | Jackson | Missouri | 29095 | 56 | 1 |
18697 | 18697 | 2020-03-29 | Jackson | Missouri | 29095 | 48 | 1 |
16775 | 16775 | 2020-03-28 | Jackson | Missouri | 29095 | 43 | 1 |
14951 | 14951 | 2020-03-27 | Jackson | Missouri | 29095 | 41 | 1 |
13226 | 13226 | 2020-03-26 | Jackson | Missouri | 29095 | 31 | 1 |
11628 | 11628 | 2020-03-25 | Jackson | Missouri | 29095 | 17 | 1 |
10206 | 10206 | 2020-03-24 | Jackson | Missouri | 29095 | 14 | 1 |
8906 | 8906 | 2020-03-23 | Jackson | Missouri | 29095 | 10 | 1 |
7718 | 7718 | 2020-03-22 | Jackson | Missouri | 29095 | 5 | 1 |
6629 | 6629 | 2020-03-21 | Jackson | Missouri | 29095 | 5 | 1 |
5641 | 5641 | 2020-03-20 | Jackson | Missouri | 29095 | 5 | 1 |
4806 | 4806 | 2020-03-19 | Jackson | Missouri | 29095 | 3 | 0 |
4087 | 4087 | 2020-03-18 | Jackson | Missouri | 29095 | 3 | 0 |
3498 | 3498 | 2020-03-17 | Jackson | Missouri | 29095 | 2 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);