ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
118 rows where county = "Scott" and deaths = 3 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 9
county 1
- Scott · 118 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1710085 | 1710085 | 2021-09-12 | Scott | Illinois | 17171 | 679 | 3 |
1706838 | 1706838 | 2021-09-11 | Scott | Illinois | 17171 | 679 | 3 |
1703590 | 1703590 | 2021-09-10 | Scott | Illinois | 17171 | 679 | 3 |
1700340 | 1700340 | 2021-09-09 | Scott | Illinois | 17171 | 677 | 3 |
1697091 | 1697091 | 2021-09-08 | Scott | Illinois | 17171 | 675 | 3 |
1693843 | 1693843 | 2021-09-07 | Scott | Illinois | 17171 | 674 | 3 |
1690594 | 1690594 | 2021-09-06 | Scott | Illinois | 17171 | 670 | 3 |
1687344 | 1687344 | 2021-09-05 | Scott | Illinois | 17171 | 670 | 3 |
1684094 | 1684094 | 2021-09-04 | Scott | Illinois | 17171 | 670 | 3 |
1680843 | 1680843 | 2021-09-03 | Scott | Illinois | 17171 | 670 | 3 |
816756 | 816756 | 2020-12-11 | Scott | Arkansas | 5127 | 456 | 3 |
813510 | 813510 | 2020-12-10 | Scott | Arkansas | 5127 | 454 | 3 |
810266 | 810266 | 2020-12-09 | Scott | Arkansas | 5127 | 448 | 3 |
807021 | 807021 | 2020-12-08 | Scott | Arkansas | 5127 | 437 | 3 |
803776 | 803776 | 2020-12-07 | Scott | Arkansas | 5127 | 431 | 3 |
800531 | 800531 | 2020-12-06 | Scott | Arkansas | 5127 | 430 | 3 |
797286 | 797286 | 2020-12-05 | Scott | Arkansas | 5127 | 421 | 3 |
794041 | 794041 | 2020-12-04 | Scott | Arkansas | 5127 | 411 | 3 |
790796 | 790796 | 2020-12-03 | Scott | Arkansas | 5127 | 407 | 3 |
787551 | 787551 | 2020-12-02 | Scott | Arkansas | 5127 | 396 | 3 |
784307 | 784307 | 2020-12-01 | Scott | Arkansas | 5127 | 388 | 3 |
781062 | 781062 | 2020-11-30 | Scott | Arkansas | 5127 | 382 | 3 |
781868 | 781868 | 2020-11-30 | Scott | Kansas | 20171 | 456 | 3 |
778622 | 778622 | 2020-11-29 | Scott | Kansas | 20171 | 427 | 3 |
775377 | 775377 | 2020-11-28 | Scott | Kansas | 20171 | 427 | 3 |
772132 | 772132 | 2020-11-27 | Scott | Kansas | 20171 | 427 | 3 |
768887 | 768887 | 2020-11-26 | Scott | Kansas | 20171 | 427 | 3 |
765641 | 765641 | 2020-11-25 | Scott | Kansas | 20171 | 427 | 3 |
762396 | 762396 | 2020-11-24 | Scott | Kansas | 20171 | 420 | 3 |
759151 | 759151 | 2020-11-23 | Scott | Kansas | 20171 | 414 | 3 |
755904 | 755904 | 2020-11-22 | Scott | Kansas | 20171 | 394 | 3 |
752658 | 752658 | 2020-11-21 | Scott | Kansas | 20171 | 394 | 3 |
749412 | 749412 | 2020-11-20 | Scott | Kansas | 20171 | 394 | 3 |
637485 | 637485 | 2020-10-16 | Scott | Tennessee | 47151 | 300 | 3 |
634239 | 634239 | 2020-10-15 | Scott | Tennessee | 47151 | 299 | 3 |
630994 | 630994 | 2020-10-14 | Scott | Tennessee | 47151 | 294 | 3 |
627750 | 627750 | 2020-10-13 | Scott | Tennessee | 47151 | 283 | 3 |
624508 | 624508 | 2020-10-12 | Scott | Tennessee | 47151 | 280 | 3 |
621265 | 621265 | 2020-10-11 | Scott | Tennessee | 47151 | 274 | 3 |
618022 | 618022 | 2020-10-10 | Scott | Tennessee | 47151 | 271 | 3 |
614780 | 614780 | 2020-10-09 | Scott | Tennessee | 47151 | 263 | 3 |
611539 | 611539 | 2020-10-08 | Scott | Tennessee | 47151 | 264 | 3 |
608297 | 608297 | 2020-10-07 | Scott | Tennessee | 47151 | 255 | 3 |
605054 | 605054 | 2020-10-06 | Scott | Tennessee | 47151 | 249 | 3 |
601812 | 601812 | 2020-10-05 | Scott | Tennessee | 47151 | 245 | 3 |
475995 | 475995 | 2020-08-27 | Scott | Virginia | 51169 | 144 | 3 |
472762 | 472762 | 2020-08-26 | Scott | Virginia | 51169 | 144 | 3 |
469530 | 469530 | 2020-08-25 | Scott | Virginia | 51169 | 144 | 3 |
466301 | 466301 | 2020-08-24 | Scott | Virginia | 51169 | 143 | 3 |
463072 | 463072 | 2020-08-23 | Scott | Virginia | 51169 | 140 | 3 |
459843 | 459843 | 2020-08-22 | Scott | Virginia | 51169 | 136 | 3 |
456616 | 456616 | 2020-08-21 | Scott | Virginia | 51169 | 136 | 3 |
453388 | 453388 | 2020-08-20 | Scott | Virginia | 51169 | 133 | 3 |
450160 | 450160 | 2020-08-19 | Scott | Virginia | 51169 | 128 | 3 |
446932 | 446932 | 2020-08-18 | Scott | Virginia | 51169 | 127 | 3 |
443705 | 443705 | 2020-08-17 | Scott | Virginia | 51169 | 120 | 3 |
440479 | 440479 | 2020-08-16 | Scott | Virginia | 51169 | 118 | 3 |
437253 | 437253 | 2020-08-15 | Scott | Virginia | 51169 | 114 | 3 |
434027 | 434027 | 2020-08-14 | Scott | Virginia | 51169 | 112 | 3 |
430802 | 430802 | 2020-08-13 | Scott | Virginia | 51169 | 111 | 3 |
427574 | 427574 | 2020-08-12 | Scott | Virginia | 51169 | 111 | 3 |
424350 | 424350 | 2020-08-11 | Scott | Virginia | 51169 | 111 | 3 |
421129 | 421129 | 2020-08-10 | Scott | Virginia | 51169 | 102 | 3 |
417908 | 417908 | 2020-08-09 | Scott | Virginia | 51169 | 91 | 3 |
414687 | 414687 | 2020-08-08 | Scott | Virginia | 51169 | 90 | 3 |
411467 | 411467 | 2020-08-07 | Scott | Virginia | 51169 | 85 | 3 |
408248 | 408248 | 2020-08-06 | Scott | Virginia | 51169 | 66 | 3 |
405028 | 405028 | 2020-08-05 | Scott | Virginia | 51169 | 63 | 3 |
401810 | 401810 | 2020-08-04 | Scott | Virginia | 51169 | 62 | 3 |
398594 | 398594 | 2020-08-03 | Scott | Virginia | 51169 | 60 | 3 |
395378 | 395378 | 2020-08-02 | Scott | Virginia | 51169 | 54 | 3 |
392162 | 392162 | 2020-08-01 | Scott | Virginia | 51169 | 53 | 3 |
388945 | 388945 | 2020-07-31 | Scott | Virginia | 51169 | 51 | 3 |
385728 | 385728 | 2020-07-30 | Scott | Virginia | 51169 | 47 | 3 |
382510 | 382510 | 2020-07-29 | Scott | Virginia | 51169 | 45 | 3 |
379293 | 379293 | 2020-07-28 | Scott | Virginia | 51169 | 41 | 3 |
376077 | 376077 | 2020-07-27 | Scott | Virginia | 51169 | 40 | 3 |
372863 | 372863 | 2020-07-26 | Scott | Virginia | 51169 | 37 | 3 |
369651 | 369651 | 2020-07-25 | Scott | Virginia | 51169 | 34 | 3 |
366442 | 366442 | 2020-07-24 | Scott | Virginia | 51169 | 33 | 3 |
243999 | 243999 | 2020-06-16 | Scott | Indiana | 18143 | 147 | 3 |
240888 | 240888 | 2020-06-15 | Scott | Indiana | 18143 | 145 | 3 |
237780 | 237780 | 2020-06-14 | Scott | Indiana | 18143 | 145 | 3 |
234673 | 234673 | 2020-06-13 | Scott | Indiana | 18143 | 144 | 3 |
231567 | 231567 | 2020-06-12 | Scott | Indiana | 18143 | 143 | 3 |
228464 | 228464 | 2020-06-11 | Scott | Indiana | 18143 | 141 | 3 |
225362 | 225362 | 2020-06-10 | Scott | Indiana | 18143 | 133 | 3 |
225964 | 225964 | 2020-06-10 | Scott | Minnesota | 27139 | 504 | 3 |
222267 | 222267 | 2020-06-09 | Scott | Indiana | 18143 | 132 | 3 |
219172 | 219172 | 2020-06-08 | Scott | Indiana | 18143 | 130 | 3 |
216080 | 216080 | 2020-06-07 | Scott | Indiana | 18143 | 129 | 3 |
212993 | 212993 | 2020-06-06 | Scott | Indiana | 18143 | 129 | 3 |
209908 | 209908 | 2020-06-05 | Scott | Indiana | 18143 | 127 | 3 |
206827 | 206827 | 2020-06-04 | Scott | Indiana | 18143 | 127 | 3 |
203747 | 203747 | 2020-06-03 | Scott | Indiana | 18143 | 123 | 3 |
200671 | 200671 | 2020-06-02 | Scott | Indiana | 18143 | 122 | 3 |
197598 | 197598 | 2020-06-01 | Scott | Indiana | 18143 | 121 | 3 |
194528 | 194528 | 2020-05-31 | Scott | Indiana | 18143 | 121 | 3 |
191461 | 191461 | 2020-05-30 | Scott | Indiana | 18143 | 120 | 3 |
188396 | 188396 | 2020-05-29 | Scott | Indiana | 18143 | 120 | 3 |
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);