ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where county = "Scott" and fips = 20171 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535401 | 535401 | 2020-09-15 | Scott | Kansas | 20171 | 113 | 1 |
532166 | 532166 | 2020-09-14 | Scott | Kansas | 20171 | 113 | 1 |
528929 | 528929 | 2020-09-13 | Scott | Kansas | 20171 | 113 | 1 |
525693 | 525693 | 2020-09-12 | Scott | Kansas | 20171 | 113 | 1 |
522457 | 522457 | 2020-09-11 | Scott | Kansas | 20171 | 113 | 1 |
519220 | 519220 | 2020-09-10 | Scott | Kansas | 20171 | 108 | 1 |
515985 | 515985 | 2020-09-09 | Scott | Kansas | 20171 | 108 | 1 |
512752 | 512752 | 2020-09-08 | Scott | Kansas | 20171 | 108 | 1 |
509519 | 509519 | 2020-09-07 | Scott | Kansas | 20171 | 107 | 1 |
506287 | 506287 | 2020-09-06 | Scott | Kansas | 20171 | 107 | 1 |
503053 | 503053 | 2020-09-05 | Scott | Kansas | 20171 | 98 | 1 |
499819 | 499819 | 2020-09-04 | Scott | Kansas | 20171 | 98 | 1 |
496586 | 496586 | 2020-09-03 | Scott | Kansas | 20171 | 97 | 1 |
493352 | 493352 | 2020-09-02 | Scott | Kansas | 20171 | 97 | 1 |
490119 | 490119 | 2020-09-01 | Scott | Kansas | 20171 | 97 | 1 |
486886 | 486886 | 2020-08-31 | Scott | Kansas | 20171 | 96 | 1 |
483651 | 483651 | 2020-08-30 | Scott | Kansas | 20171 | 95 | 1 |
480417 | 480417 | 2020-08-29 | Scott | Kansas | 20171 | 95 | 1 |
477184 | 477184 | 2020-08-28 | Scott | Kansas | 20171 | 95 | 1 |
473951 | 473951 | 2020-08-27 | Scott | Kansas | 20171 | 91 | 1 |
470719 | 470719 | 2020-08-26 | Scott | Kansas | 20171 | 91 | 1 |
467490 | 467490 | 2020-08-25 | Scott | Kansas | 20171 | 88 | 0 |
464261 | 464261 | 2020-08-24 | Scott | Kansas | 20171 | 88 | 0 |
461031 | 461031 | 2020-08-23 | Scott | Kansas | 20171 | 87 | 0 |
457804 | 457804 | 2020-08-22 | Scott | Kansas | 20171 | 87 | 0 |
454576 | 454576 | 2020-08-21 | Scott | Kansas | 20171 | 87 | 0 |
451348 | 451348 | 2020-08-20 | Scott | Kansas | 20171 | 79 | 0 |
448120 | 448120 | 2020-08-19 | Scott | Kansas | 20171 | 79 | 0 |
444893 | 444893 | 2020-08-18 | Scott | Kansas | 20171 | 79 | 0 |
441667 | 441667 | 2020-08-17 | Scott | Kansas | 20171 | 79 | 0 |
438440 | 438440 | 2020-08-16 | Scott | Kansas | 20171 | 79 | 0 |
435215 | 435215 | 2020-08-15 | Scott | Kansas | 20171 | 75 | 0 |
431990 | 431990 | 2020-08-14 | Scott | Kansas | 20171 | 69 | 0 |
428762 | 428762 | 2020-08-13 | Scott | Kansas | 20171 | 53 | 0 |
425538 | 425538 | 2020-08-12 | Scott | Kansas | 20171 | 53 | 0 |
422317 | 422317 | 2020-08-11 | Scott | Kansas | 20171 | 53 | 0 |
419094 | 419094 | 2020-08-10 | Scott | Kansas | 20171 | 38 | 0 |
415873 | 415873 | 2020-08-09 | Scott | Kansas | 20171 | 32 | 0 |
412653 | 412653 | 2020-08-08 | Scott | Kansas | 20171 | 32 | 0 |
409433 | 409433 | 2020-08-07 | Scott | Kansas | 20171 | 32 | 0 |
406214 | 406214 | 2020-08-06 | Scott | Kansas | 20171 | 32 | 0 |
402996 | 402996 | 2020-08-05 | Scott | Kansas | 20171 | 32 | 0 |
399779 | 399779 | 2020-08-04 | Scott | Kansas | 20171 | 32 | 0 |
396564 | 396564 | 2020-08-03 | Scott | Kansas | 20171 | 32 | 0 |
393348 | 393348 | 2020-08-02 | Scott | Kansas | 20171 | 32 | 0 |
390131 | 390131 | 2020-08-01 | Scott | Kansas | 20171 | 28 | 0 |
386914 | 386914 | 2020-07-31 | Scott | Kansas | 20171 | 28 | 0 |
383696 | 383696 | 2020-07-30 | Scott | Kansas | 20171 | 26 | 0 |
380479 | 380479 | 2020-07-29 | Scott | Kansas | 20171 | 26 | 0 |
377262 | 377262 | 2020-07-28 | Scott | Kansas | 20171 | 26 | 0 |
374047 | 374047 | 2020-07-27 | Scott | Kansas | 20171 | 25 | 0 |
370835 | 370835 | 2020-07-26 | Scott | Kansas | 20171 | 24 | 0 |
367625 | 367625 | 2020-07-25 | Scott | Kansas | 20171 | 22 | 0 |
364418 | 364418 | 2020-07-24 | Scott | Kansas | 20171 | 22 | 0 |
361211 | 361211 | 2020-07-23 | Scott | Kansas | 20171 | 21 | 0 |
358006 | 358006 | 2020-07-22 | Scott | Kansas | 20171 | 21 | 0 |
354804 | 354804 | 2020-07-21 | Scott | Kansas | 20171 | 20 | 0 |
351602 | 351602 | 2020-07-20 | Scott | Kansas | 20171 | 20 | 0 |
348402 | 348402 | 2020-07-19 | Scott | Kansas | 20171 | 19 | 0 |
345201 | 345201 | 2020-07-18 | Scott | Kansas | 20171 | 19 | 0 |
342001 | 342001 | 2020-07-17 | Scott | Kansas | 20171 | 19 | 0 |
338805 | 338805 | 2020-07-16 | Scott | Kansas | 20171 | 19 | 0 |
335609 | 335609 | 2020-07-15 | Scott | Kansas | 20171 | 19 | 0 |
332416 | 332416 | 2020-07-14 | Scott | Kansas | 20171 | 19 | 0 |
329229 | 329229 | 2020-07-13 | Scott | Kansas | 20171 | 18 | 0 |
326043 | 326043 | 2020-07-12 | Scott | Kansas | 20171 | 18 | 0 |
322860 | 322860 | 2020-07-11 | Scott | Kansas | 20171 | 17 | 0 |
319681 | 319681 | 2020-07-10 | Scott | Kansas | 20171 | 17 | 0 |
316506 | 316506 | 2020-07-09 | Scott | Kansas | 20171 | 16 | 0 |
313332 | 313332 | 2020-07-08 | Scott | Kansas | 20171 | 16 | 0 |
310162 | 310162 | 2020-07-07 | Scott | Kansas | 20171 | 16 | 0 |
306994 | 306994 | 2020-07-06 | Scott | Kansas | 20171 | 16 | 0 |
303827 | 303827 | 2020-07-05 | Scott | Kansas | 20171 | 16 | 0 |
300663 | 300663 | 2020-07-04 | Scott | Kansas | 20171 | 16 | 0 |
297501 | 297501 | 2020-07-03 | Scott | Kansas | 20171 | 16 | 0 |
294343 | 294343 | 2020-07-02 | Scott | Kansas | 20171 | 16 | 0 |
291189 | 291189 | 2020-07-01 | Scott | Kansas | 20171 | 16 | 0 |
288039 | 288039 | 2020-06-30 | Scott | Kansas | 20171 | 17 | 0 |
284890 | 284890 | 2020-06-29 | Scott | Kansas | 20171 | 17 | 0 |
281744 | 281744 | 2020-06-28 | Scott | Kansas | 20171 | 16 | 0 |
278596 | 278596 | 2020-06-27 | Scott | Kansas | 20171 | 16 | 0 |
275448 | 275448 | 2020-06-26 | Scott | Kansas | 20171 | 16 | 0 |
272305 | 272305 | 2020-06-25 | Scott | Kansas | 20171 | 16 | 0 |
269168 | 269168 | 2020-06-24 | Scott | Kansas | 20171 | 16 | 0 |
266036 | 266036 | 2020-06-23 | Scott | Kansas | 20171 | 16 | 0 |
262908 | 262908 | 2020-06-22 | Scott | Kansas | 20171 | 16 | 0 |
259781 | 259781 | 2020-06-21 | Scott | Kansas | 20171 | 16 | 0 |
256655 | 256655 | 2020-06-20 | Scott | Kansas | 20171 | 16 | 0 |
253535 | 253535 | 2020-06-19 | Scott | Kansas | 20171 | 16 | 0 |
250420 | 250420 | 2020-06-18 | Scott | Kansas | 20171 | 16 | 0 |
247308 | 247308 | 2020-06-17 | Scott | Kansas | 20171 | 16 | 0 |
244195 | 244195 | 2020-06-16 | Scott | Kansas | 20171 | 16 | 0 |
241084 | 241084 | 2020-06-15 | Scott | Kansas | 20171 | 16 | 0 |
237975 | 237975 | 2020-06-14 | Scott | Kansas | 20171 | 15 | 0 |
234868 | 234868 | 2020-06-13 | Scott | Kansas | 20171 | 15 | 0 |
231762 | 231762 | 2020-06-12 | Scott | Kansas | 20171 | 15 | 0 |
228659 | 228659 | 2020-06-11 | Scott | Kansas | 20171 | 15 | 0 |
225557 | 225557 | 2020-06-10 | Scott | Kansas | 20171 | 15 | 0 |
222462 | 222462 | 2020-06-09 | Scott | Kansas | 20171 | 15 | 0 |
219367 | 219367 | 2020-06-08 | Scott | Kansas | 20171 | 15 | 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);