ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
728 rows where fips = 29197 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387523 | 387523 | 2020-07-31 | Schuyler | Missouri | 29197 | 9 | 0 |
384305 | 384305 | 2020-07-30 | Schuyler | Missouri | 29197 | 9 | 0 |
381089 | 381089 | 2020-07-29 | Schuyler | Missouri | 29197 | 9 | 0 |
377872 | 377872 | 2020-07-28 | Schuyler | Missouri | 29197 | 9 | 0 |
374657 | 374657 | 2020-07-27 | Schuyler | Missouri | 29197 | 9 | 0 |
371445 | 371445 | 2020-07-26 | Schuyler | Missouri | 29197 | 9 | 0 |
368234 | 368234 | 2020-07-25 | Schuyler | Missouri | 29197 | 9 | 0 |
365026 | 365026 | 2020-07-24 | Schuyler | Missouri | 29197 | 9 | 0 |
361819 | 361819 | 2020-07-23 | Schuyler | Missouri | 29197 | 9 | 0 |
358614 | 358614 | 2020-07-22 | Schuyler | Missouri | 29197 | 8 | 0 |
355411 | 355411 | 2020-07-21 | Schuyler | Missouri | 29197 | 7 | 0 |
352209 | 352209 | 2020-07-20 | Schuyler | Missouri | 29197 | 6 | 0 |
349009 | 349009 | 2020-07-19 | Schuyler | Missouri | 29197 | 6 | 0 |
345808 | 345808 | 2020-07-18 | Schuyler | Missouri | 29197 | 5 | 0 |
342608 | 342608 | 2020-07-17 | Schuyler | Missouri | 29197 | 5 | 0 |
339412 | 339412 | 2020-07-16 | Schuyler | Missouri | 29197 | 5 | 0 |
336216 | 336216 | 2020-07-15 | Schuyler | Missouri | 29197 | 5 | 0 |
333023 | 333023 | 2020-07-14 | Schuyler | Missouri | 29197 | 5 | 0 |
329836 | 329836 | 2020-07-13 | Schuyler | Missouri | 29197 | 5 | 0 |
326650 | 326650 | 2020-07-12 | Schuyler | Missouri | 29197 | 5 | 0 |
323467 | 323467 | 2020-07-11 | Schuyler | Missouri | 29197 | 5 | 0 |
320288 | 320288 | 2020-07-10 | Schuyler | Missouri | 29197 | 5 | 0 |
317113 | 317113 | 2020-07-09 | Schuyler | Missouri | 29197 | 5 | 0 |
313939 | 313939 | 2020-07-08 | Schuyler | Missouri | 29197 | 5 | 0 |
310768 | 310768 | 2020-07-07 | Schuyler | Missouri | 29197 | 5 | 0 |
307600 | 307600 | 2020-07-06 | Schuyler | Missouri | 29197 | 5 | 0 |
304433 | 304433 | 2020-07-05 | Schuyler | Missouri | 29197 | 5 | 0 |
301269 | 301269 | 2020-07-04 | Schuyler | Missouri | 29197 | 5 | 0 |
298106 | 298106 | 2020-07-03 | Schuyler | Missouri | 29197 | 5 | 0 |
294948 | 294948 | 2020-07-02 | Schuyler | Missouri | 29197 | 5 | 0 |
291794 | 291794 | 2020-07-01 | Schuyler | Missouri | 29197 | 5 | 0 |
288643 | 288643 | 2020-06-30 | Schuyler | Missouri | 29197 | 5 | 0 |
285493 | 285493 | 2020-06-29 | Schuyler | Missouri | 29197 | 5 | 0 |
282348 | 282348 | 2020-06-28 | Schuyler | Missouri | 29197 | 5 | 0 |
279200 | 279200 | 2020-06-27 | Schuyler | Missouri | 29197 | 5 | 0 |
276052 | 276052 | 2020-06-26 | Schuyler | Missouri | 29197 | 5 | 0 |
272909 | 272909 | 2020-06-25 | Schuyler | Missouri | 29197 | 4 | 0 |
269770 | 269770 | 2020-06-24 | Schuyler | Missouri | 29197 | 4 | 0 |
266637 | 266637 | 2020-06-23 | Schuyler | Missouri | 29197 | 4 | 0 |
263511 | 263511 | 2020-06-22 | Schuyler | Missouri | 29197 | 4 | 0 |
260383 | 260383 | 2020-06-21 | Schuyler | Missouri | 29197 | 4 | 0 |
257257 | 257257 | 2020-06-20 | Schuyler | Missouri | 29197 | 2 | 0 |
254136 | 254136 | 2020-06-19 | Schuyler | Missouri | 29197 | 2 | 0 |
251021 | 251021 | 2020-06-18 | Schuyler | Missouri | 29197 | 1 | 0 |
247908 | 247908 | 2020-06-17 | Schuyler | Missouri | 29197 | 1 | 0 |
244795 | 244795 | 2020-06-16 | Schuyler | Missouri | 29197 | 1 | 0 |
241684 | 241684 | 2020-06-15 | Schuyler | Missouri | 29197 | 1 | 0 |
238574 | 238574 | 2020-06-14 | Schuyler | Missouri | 29197 | 1 | 0 |
235467 | 235467 | 2020-06-13 | Schuyler | Missouri | 29197 | 1 | 0 |
232361 | 232361 | 2020-06-12 | Schuyler | Missouri | 29197 | 1 | 0 |
229257 | 229257 | 2020-06-11 | Schuyler | Missouri | 29197 | 2 | 0 |
226154 | 226154 | 2020-06-10 | Schuyler | Missouri | 29197 | 1 | 0 |
223055 | 223055 | 2020-06-09 | Schuyler | Missouri | 29197 | 1 | 0 |
219960 | 219960 | 2020-06-08 | Schuyler | Missouri | 29197 | 1 | 0 |
216868 | 216868 | 2020-06-07 | Schuyler | Missouri | 29197 | 1 | 0 |
213779 | 213779 | 2020-06-06 | Schuyler | Missouri | 29197 | 1 | 0 |
210695 | 210695 | 2020-06-05 | Schuyler | Missouri | 29197 | 1 | 0 |
207614 | 207614 | 2020-06-04 | Schuyler | Missouri | 29197 | 1 | 0 |
204533 | 204533 | 2020-06-03 | Schuyler | Missouri | 29197 | 1 | 0 |
201456 | 201456 | 2020-06-02 | Schuyler | Missouri | 29197 | 1 | 0 |
198383 | 198383 | 2020-06-01 | Schuyler | Missouri | 29197 | 1 | 0 |
195312 | 195312 | 2020-05-31 | Schuyler | Missouri | 29197 | 1 | 0 |
192242 | 192242 | 2020-05-30 | Schuyler | Missouri | 29197 | 1 | 0 |
189178 | 189178 | 2020-05-29 | Schuyler | Missouri | 29197 | 1 | 0 |
186120 | 186120 | 2020-05-28 | Schuyler | Missouri | 29197 | 1 | 0 |
183064 | 183064 | 2020-05-27 | Schuyler | Missouri | 29197 | 1 | 0 |
180017 | 180017 | 2020-05-26 | Schuyler | Missouri | 29197 | 2 | 0 |
176973 | 176973 | 2020-05-25 | Schuyler | Missouri | 29197 | 2 | 0 |
173930 | 173930 | 2020-05-24 | Schuyler | Missouri | 29197 | 2 | 0 |
170888 | 170888 | 2020-05-23 | Schuyler | Missouri | 29197 | 2 | 0 |
167849 | 167849 | 2020-05-22 | Schuyler | Missouri | 29197 | 1 | 0 |
164813 | 164813 | 2020-05-21 | Schuyler | Missouri | 29197 | 1 | 0 |
161784 | 161784 | 2020-05-20 | Schuyler | Missouri | 29197 | 1 | 0 |
158758 | 158758 | 2020-05-19 | Schuyler | Missouri | 29197 | 1 | 0 |
155740 | 155740 | 2020-05-18 | Schuyler | Missouri | 29197 | 1 | 0 |
152726 | 152726 | 2020-05-17 | Schuyler | Missouri | 29197 | 1 | 0 |
149715 | 149715 | 2020-05-16 | Schuyler | Missouri | 29197 | 1 | 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);