ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Shelby" and state = "Missouri" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
11645 | 11645 | 2020-03-25 | Shelby | Missouri | 29205 | 1 | 0 |
13243 | 13243 | 2020-03-26 | Shelby | Missouri | 29205 | 1 | 0 |
14971 | 14971 | 2020-03-27 | Shelby | Missouri | 29205 | 1 | 0 |
16796 | 16796 | 2020-03-28 | Shelby | Missouri | 29205 | 1 | 0 |
18718 | 18718 | 2020-03-29 | Shelby | Missouri | 29205 | 1 | 0 |
20751 | 20751 | 2020-03-30 | Shelby | Missouri | 29205 | 1 | 0 |
22870 | 22870 | 2020-03-31 | Shelby | Missouri | 29205 | 1 | 0 |
25058 | 25058 | 2020-04-01 | Shelby | Missouri | 29205 | 1 | 0 |
27315 | 27315 | 2020-04-02 | Shelby | Missouri | 29205 | 1 | 0 |
29637 | 29637 | 2020-04-03 | Shelby | Missouri | 29205 | 1 | 0 |
32018 | 32018 | 2020-04-04 | Shelby | Missouri | 29205 | 1 | 0 |
34446 | 34446 | 2020-04-05 | Shelby | Missouri | 29205 | 1 | 0 |
36912 | 36912 | 2020-04-06 | Shelby | Missouri | 29205 | 1 | 0 |
39428 | 39428 | 2020-04-07 | Shelby | Missouri | 29205 | 1 | 0 |
41982 | 41982 | 2020-04-08 | Shelby | Missouri | 29205 | 1 | 0 |
44559 | 44559 | 2020-04-09 | Shelby | Missouri | 29205 | 1 | 0 |
47168 | 47168 | 2020-04-10 | Shelby | Missouri | 29205 | 1 | 0 |
49816 | 49816 | 2020-04-11 | Shelby | Missouri | 29205 | 1 | 0 |
52489 | 52489 | 2020-04-12 | Shelby | Missouri | 29205 | 1 | 0 |
55171 | 55171 | 2020-04-13 | Shelby | Missouri | 29205 | 1 | 0 |
57869 | 57869 | 2020-04-14 | Shelby | Missouri | 29205 | 1 | 0 |
60583 | 60583 | 2020-04-15 | Shelby | Missouri | 29205 | 1 | 0 |
63305 | 63305 | 2020-04-16 | Shelby | Missouri | 29205 | 1 | 0 |
66045 | 66045 | 2020-04-17 | Shelby | Missouri | 29205 | 1 | 0 |
68799 | 68799 | 2020-04-18 | Shelby | Missouri | 29205 | 1 | 0 |
71566 | 71566 | 2020-04-19 | Shelby | Missouri | 29205 | 1 | 0 |
74339 | 74339 | 2020-04-20 | Shelby | Missouri | 29205 | 1 | 0 |
77120 | 77120 | 2020-04-21 | Shelby | Missouri | 29205 | 1 | 0 |
79907 | 79907 | 2020-04-22 | Shelby | Missouri | 29205 | 1 | 0 |
82703 | 82703 | 2020-04-23 | Shelby | Missouri | 29205 | 1 | 0 |
85507 | 85507 | 2020-04-24 | Shelby | Missouri | 29205 | 1 | 0 |
88317 | 88317 | 2020-04-25 | Shelby | Missouri | 29205 | 1 | 0 |
91133 | 91133 | 2020-04-26 | Shelby | Missouri | 29205 | 1 | 0 |
93954 | 93954 | 2020-04-27 | Shelby | Missouri | 29205 | 1 | 0 |
96790 | 96790 | 2020-04-28 | Shelby | Missouri | 29205 | 1 | 0 |
99636 | 99636 | 2020-04-29 | Shelby | Missouri | 29205 | 1 | 0 |
102488 | 102488 | 2020-04-30 | Shelby | Missouri | 29205 | 1 | 0 |
105349 | 105349 | 2020-05-01 | Shelby | Missouri | 29205 | 1 | 0 |
108214 | 108214 | 2020-05-02 | Shelby | Missouri | 29205 | 1 | 0 |
111086 | 111086 | 2020-05-03 | Shelby | Missouri | 29205 | 1 | 0 |
113965 | 113965 | 2020-05-04 | Shelby | Missouri | 29205 | 1 | 0 |
116847 | 116847 | 2020-05-05 | Shelby | Missouri | 29205 | 1 | 0 |
119807 | 119807 | 2020-05-06 | Shelby | Missouri | 29205 | 1 | 0 |
122781 | 122781 | 2020-05-07 | Shelby | Missouri | 29205 | 1 | 0 |
125763 | 125763 | 2020-05-08 | Shelby | Missouri | 29205 | 1 | 0 |
128751 | 128751 | 2020-05-09 | Shelby | Missouri | 29205 | 1 | 0 |
131741 | 131741 | 2020-05-10 | Shelby | Missouri | 29205 | 1 | 0 |
134732 | 134732 | 2020-05-11 | Shelby | Missouri | 29205 | 1 | 0 |
137722 | 137722 | 2020-05-12 | Shelby | Missouri | 29205 | 1 | 0 |
140716 | 140716 | 2020-05-13 | Shelby | Missouri | 29205 | 1 | 0 |
143711 | 143711 | 2020-05-14 | Shelby | Missouri | 29205 | 1 | 0 |
146712 | 146712 | 2020-05-15 | Shelby | Missouri | 29205 | 1 | 0 |
149718 | 149718 | 2020-05-16 | Shelby | Missouri | 29205 | 1 | 0 |
152729 | 152729 | 2020-05-17 | Shelby | Missouri | 29205 | 1 | 0 |
155743 | 155743 | 2020-05-18 | Shelby | Missouri | 29205 | 1 | 0 |
158761 | 158761 | 2020-05-19 | Shelby | Missouri | 29205 | 1 | 0 |
161787 | 161787 | 2020-05-20 | Shelby | Missouri | 29205 | 1 | 0 |
164816 | 164816 | 2020-05-21 | Shelby | Missouri | 29205 | 1 | 0 |
167852 | 167852 | 2020-05-22 | Shelby | Missouri | 29205 | 1 | 0 |
170891 | 170891 | 2020-05-23 | Shelby | Missouri | 29205 | 1 | 0 |
173933 | 173933 | 2020-05-24 | Shelby | Missouri | 29205 | 1 | 0 |
176976 | 176976 | 2020-05-25 | Shelby | Missouri | 29205 | 1 | 0 |
180020 | 180020 | 2020-05-26 | Shelby | Missouri | 29205 | 1 | 0 |
183068 | 183068 | 2020-05-27 | Shelby | Missouri | 29205 | 1 | 0 |
186124 | 186124 | 2020-05-28 | Shelby | Missouri | 29205 | 1 | 0 |
189182 | 189182 | 2020-05-29 | Shelby | Missouri | 29205 | 1 | 0 |
192246 | 192246 | 2020-05-30 | Shelby | Missouri | 29205 | 1 | 0 |
195316 | 195316 | 2020-05-31 | Shelby | Missouri | 29205 | 1 | 0 |
198387 | 198387 | 2020-06-01 | Shelby | Missouri | 29205 | 1 | 0 |
201460 | 201460 | 2020-06-02 | Shelby | Missouri | 29205 | 1 | 0 |
204537 | 204537 | 2020-06-03 | Shelby | Missouri | 29205 | 1 | 0 |
207618 | 207618 | 2020-06-04 | Shelby | Missouri | 29205 | 1 | 0 |
210699 | 210699 | 2020-06-05 | Shelby | Missouri | 29205 | 1 | 0 |
213783 | 213783 | 2020-06-06 | Shelby | Missouri | 29205 | 1 | 0 |
216872 | 216872 | 2020-06-07 | Shelby | Missouri | 29205 | 1 | 0 |
219964 | 219964 | 2020-06-08 | Shelby | Missouri | 29205 | 1 | 0 |
223059 | 223059 | 2020-06-09 | Shelby | Missouri | 29205 | 1 | 0 |
226158 | 226158 | 2020-06-10 | Shelby | Missouri | 29205 | 1 | 0 |
229261 | 229261 | 2020-06-11 | Shelby | Missouri | 29205 | 1 | 0 |
232365 | 232365 | 2020-06-12 | Shelby | Missouri | 29205 | 1 | 0 |
235471 | 235471 | 2020-06-13 | Shelby | Missouri | 29205 | 1 | 0 |
238578 | 238578 | 2020-06-14 | Shelby | Missouri | 29205 | 1 | 0 |
241688 | 241688 | 2020-06-15 | Shelby | Missouri | 29205 | 1 | 0 |
244799 | 244799 | 2020-06-16 | Shelby | Missouri | 29205 | 1 | 0 |
247912 | 247912 | 2020-06-17 | Shelby | Missouri | 29205 | 1 | 0 |
251025 | 251025 | 2020-06-18 | Shelby | Missouri | 29205 | 1 | 0 |
254140 | 254140 | 2020-06-19 | Shelby | Missouri | 29205 | 2 | 0 |
257261 | 257261 | 2020-06-20 | Shelby | Missouri | 29205 | 2 | 0 |
260387 | 260387 | 2020-06-21 | Shelby | Missouri | 29205 | 2 | 0 |
263515 | 263515 | 2020-06-22 | Shelby | Missouri | 29205 | 2 | 0 |
266641 | 266641 | 2020-06-23 | Shelby | Missouri | 29205 | 2 | 0 |
269774 | 269774 | 2020-06-24 | Shelby | Missouri | 29205 | 3 | 0 |
272913 | 272913 | 2020-06-25 | Shelby | Missouri | 29205 | 3 | 0 |
276056 | 276056 | 2020-06-26 | Shelby | Missouri | 29205 | 3 | 0 |
279204 | 279204 | 2020-06-27 | Shelby | Missouri | 29205 | 3 | 0 |
282352 | 282352 | 2020-06-28 | Shelby | Missouri | 29205 | 3 | 0 |
285497 | 285497 | 2020-06-29 | Shelby | Missouri | 29205 | 3 | 0 |
288647 | 288647 | 2020-06-30 | Shelby | Missouri | 29205 | 3 | 0 |
291798 | 291798 | 2020-07-01 | Shelby | Missouri | 29205 | 4 | 0 |
294952 | 294952 | 2020-07-02 | Shelby | Missouri | 29205 | 4 | 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);