ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
97 rows where county = "Scott" and deaths = 4 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 1
- Scott · 97 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1713332 | 1713332 | 2021-09-13 | Scott | Illinois | 17171 | 685 | 4 |
829741 | 829741 | 2020-12-15 | Scott | Arkansas | 5127 | 475 | 4 |
826495 | 826495 | 2020-12-14 | Scott | Arkansas | 5127 | 470 | 4 |
823248 | 823248 | 2020-12-13 | Scott | Arkansas | 5127 | 469 | 4 |
820002 | 820002 | 2020-12-12 | Scott | Arkansas | 5127 | 465 | 4 |
785113 | 785113 | 2020-12-01 | Scott | Kansas | 20171 | 460 | 4 |
656959 | 656959 | 2020-10-22 | Scott | Tennessee | 47151 | 351 | 4 |
653714 | 653714 | 2020-10-21 | Scott | Tennessee | 47151 | 344 | 4 |
650469 | 650469 | 2020-10-20 | Scott | Tennessee | 47151 | 332 | 4 |
647225 | 647225 | 2020-10-19 | Scott | Tennessee | 47151 | 324 | 4 |
643979 | 643979 | 2020-10-18 | Scott | Tennessee | 47151 | 314 | 4 |
640731 | 640731 | 2020-10-17 | Scott | Tennessee | 47151 | 311 | 4 |
624941 | 624941 | 2020-10-12 | Scott | Virginia | 51169 | 223 | 4 |
621698 | 621698 | 2020-10-11 | Scott | Virginia | 51169 | 223 | 4 |
618455 | 618455 | 2020-10-10 | Scott | Virginia | 51169 | 221 | 4 |
615213 | 615213 | 2020-10-09 | Scott | Virginia | 51169 | 214 | 4 |
611972 | 611972 | 2020-10-08 | Scott | Virginia | 51169 | 210 | 4 |
608730 | 608730 | 2020-10-07 | Scott | Virginia | 51169 | 205 | 4 |
605487 | 605487 | 2020-10-06 | Scott | Virginia | 51169 | 205 | 4 |
602245 | 602245 | 2020-10-05 | Scott | Virginia | 51169 | 203 | 4 |
599002 | 599002 | 2020-10-04 | Scott | Virginia | 51169 | 202 | 4 |
595759 | 595759 | 2020-10-03 | Scott | Virginia | 51169 | 199 | 4 |
592517 | 592517 | 2020-10-02 | Scott | Virginia | 51169 | 195 | 4 |
589277 | 589277 | 2020-10-01 | Scott | Virginia | 51169 | 194 | 4 |
586036 | 586036 | 2020-09-30 | Scott | Virginia | 51169 | 191 | 4 |
582796 | 582796 | 2020-09-29 | Scott | Virginia | 51169 | 189 | 4 |
579557 | 579557 | 2020-09-28 | Scott | Virginia | 51169 | 189 | 4 |
576316 | 576316 | 2020-09-27 | Scott | Virginia | 51169 | 186 | 4 |
573072 | 573072 | 2020-09-26 | Scott | Virginia | 51169 | 185 | 4 |
569830 | 569830 | 2020-09-25 | Scott | Virginia | 51169 | 184 | 4 |
566589 | 566589 | 2020-09-24 | Scott | Virginia | 51169 | 181 | 4 |
563348 | 563348 | 2020-09-23 | Scott | Virginia | 51169 | 181 | 4 |
560109 | 560109 | 2020-09-22 | Scott | Virginia | 51169 | 181 | 4 |
556873 | 556873 | 2020-09-21 | Scott | Virginia | 51169 | 180 | 4 |
553636 | 553636 | 2020-09-20 | Scott | Virginia | 51169 | 180 | 4 |
550397 | 550397 | 2020-09-19 | Scott | Virginia | 51169 | 179 | 4 |
547158 | 547158 | 2020-09-18 | Scott | Virginia | 51169 | 177 | 4 |
543921 | 543921 | 2020-09-17 | Scott | Virginia | 51169 | 177 | 4 |
540685 | 540685 | 2020-09-16 | Scott | Virginia | 51169 | 176 | 4 |
537448 | 537448 | 2020-09-15 | Scott | Virginia | 51169 | 176 | 4 |
534212 | 534212 | 2020-09-14 | Scott | Virginia | 51169 | 174 | 4 |
530977 | 530977 | 2020-09-13 | Scott | Virginia | 51169 | 174 | 4 |
527740 | 527740 | 2020-09-12 | Scott | Virginia | 51169 | 172 | 4 |
524504 | 524504 | 2020-09-11 | Scott | Virginia | 51169 | 172 | 4 |
521268 | 521268 | 2020-09-10 | Scott | Virginia | 51169 | 170 | 4 |
518031 | 518031 | 2020-09-09 | Scott | Virginia | 51169 | 168 | 4 |
514796 | 514796 | 2020-09-08 | Scott | Virginia | 51169 | 167 | 4 |
511563 | 511563 | 2020-09-07 | Scott | Virginia | 51169 | 166 | 4 |
508330 | 508330 | 2020-09-06 | Scott | Virginia | 51169 | 166 | 4 |
505098 | 505098 | 2020-09-05 | Scott | Virginia | 51169 | 162 | 4 |
501864 | 501864 | 2020-09-04 | Scott | Virginia | 51169 | 161 | 4 |
498630 | 498630 | 2020-09-03 | Scott | Virginia | 51169 | 161 | 4 |
495397 | 495397 | 2020-09-02 | Scott | Virginia | 51169 | 156 | 4 |
492163 | 492163 | 2020-09-01 | Scott | Virginia | 51169 | 156 | 4 |
488930 | 488930 | 2020-08-31 | Scott | Virginia | 51169 | 153 | 4 |
485697 | 485697 | 2020-08-30 | Scott | Virginia | 51169 | 151 | 4 |
482462 | 482462 | 2020-08-29 | Scott | Virginia | 51169 | 150 | 4 |
479228 | 479228 | 2020-08-28 | Scott | Virginia | 51169 | 148 | 4 |
474075 | 474075 | 2020-08-27 | Scott | Kentucky | 21209 | 558 | 4 |
470843 | 470843 | 2020-08-26 | Scott | Kentucky | 21209 | 539 | 4 |
467614 | 467614 | 2020-08-25 | Scott | Kentucky | 21209 | 513 | 4 |
336020 | 336020 | 2020-07-15 | Scott | Minnesota | 27139 | 953 | 4 |
332827 | 332827 | 2020-07-14 | Scott | Minnesota | 27139 | 923 | 4 |
329640 | 329640 | 2020-07-13 | Scott | Minnesota | 27139 | 899 | 4 |
326454 | 326454 | 2020-07-12 | Scott | Minnesota | 27139 | 881 | 4 |
323271 | 323271 | 2020-07-11 | Scott | Minnesota | 27139 | 858 | 4 |
320092 | 320092 | 2020-07-10 | Scott | Minnesota | 27139 | 823 | 4 |
316917 | 316917 | 2020-07-09 | Scott | Minnesota | 27139 | 803 | 4 |
313743 | 313743 | 2020-07-08 | Scott | Minnesota | 27139 | 783 | 4 |
310573 | 310573 | 2020-07-07 | Scott | Minnesota | 27139 | 762 | 4 |
307405 | 307405 | 2020-07-06 | Scott | Minnesota | 27139 | 734 | 4 |
304238 | 304238 | 2020-07-05 | Scott | Minnesota | 27139 | 715 | 4 |
301074 | 301074 | 2020-07-04 | Scott | Minnesota | 27139 | 700 | 4 |
297911 | 297911 | 2020-07-03 | Scott | Minnesota | 27139 | 700 | 4 |
294753 | 294753 | 2020-07-02 | Scott | Minnesota | 27139 | 684 | 4 |
291599 | 291599 | 2020-07-01 | Scott | Minnesota | 27139 | 671 | 4 |
288448 | 288448 | 2020-06-30 | Scott | Minnesota | 27139 | 658 | 4 |
285298 | 285298 | 2020-06-29 | Scott | Minnesota | 27139 | 641 | 4 |
282153 | 282153 | 2020-06-28 | Scott | Minnesota | 27139 | 637 | 4 |
279005 | 279005 | 2020-06-27 | Scott | Minnesota | 27139 | 627 | 4 |
275857 | 275857 | 2020-06-26 | Scott | Minnesota | 27139 | 616 | 4 |
272714 | 272714 | 2020-06-25 | Scott | Minnesota | 27139 | 609 | 4 |
269577 | 269577 | 2020-06-24 | Scott | Minnesota | 27139 | 603 | 4 |
266444 | 266444 | 2020-06-23 | Scott | Minnesota | 27139 | 595 | 4 |
263318 | 263318 | 2020-06-22 | Scott | Minnesota | 27139 | 587 | 4 |
260189 | 260189 | 2020-06-21 | Scott | Minnesota | 27139 | 570 | 4 |
257063 | 257063 | 2020-06-20 | Scott | Minnesota | 27139 | 561 | 4 |
253943 | 253943 | 2020-06-19 | Scott | Minnesota | 27139 | 555 | 4 |
250828 | 250828 | 2020-06-18 | Scott | Minnesota | 27139 | 551 | 4 |
247716 | 247716 | 2020-06-17 | Scott | Minnesota | 27139 | 546 | 4 |
244603 | 244603 | 2020-06-16 | Scott | Minnesota | 27139 | 541 | 4 |
241492 | 241492 | 2020-06-15 | Scott | Minnesota | 27139 | 536 | 4 |
238383 | 238383 | 2020-06-14 | Scott | Minnesota | 27139 | 528 | 4 |
235276 | 235276 | 2020-06-13 | Scott | Minnesota | 27139 | 526 | 4 |
232170 | 232170 | 2020-06-12 | Scott | Minnesota | 27139 | 525 | 4 |
229066 | 229066 | 2020-06-11 | Scott | Minnesota | 27139 | 517 | 4 |
84859 | 84859 | 2020-04-24 | Scott | Iowa | 19163 | 197 | 4 |
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);