ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
448 rows where county = "Benton" and deaths = 1 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 9
- Iowa 199
- Tennessee 114
- Missouri 47
- Mississippi 45
- Indiana 23
- Oregon 9
- Minnesota 7
- Washington 3
- Arkansas 1
county 1
- Benton · 448 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
758877 | 758877 | 2020-11-23 | Benton | Indiana | 18007 | 325 | 1 |
755630 | 755630 | 2020-11-22 | Benton | Indiana | 18007 | 310 | 1 |
752384 | 752384 | 2020-11-21 | Benton | Indiana | 18007 | 302 | 1 |
749138 | 749138 | 2020-11-20 | Benton | Indiana | 18007 | 297 | 1 |
745892 | 745892 | 2020-11-19 | Benton | Indiana | 18007 | 292 | 1 |
742645 | 742645 | 2020-11-18 | Benton | Indiana | 18007 | 262 | 1 |
739398 | 739398 | 2020-11-17 | Benton | Indiana | 18007 | 253 | 1 |
736154 | 736154 | 2020-11-16 | Benton | Indiana | 18007 | 249 | 1 |
732908 | 732908 | 2020-11-15 | Benton | Indiana | 18007 | 241 | 1 |
729663 | 729663 | 2020-11-14 | Benton | Indiana | 18007 | 217 | 1 |
726420 | 726420 | 2020-11-13 | Benton | Indiana | 18007 | 193 | 1 |
723177 | 723177 | 2020-11-12 | Benton | Indiana | 18007 | 195 | 1 |
719934 | 719934 | 2020-11-11 | Benton | Indiana | 18007 | 175 | 1 |
716691 | 716691 | 2020-11-10 | Benton | Indiana | 18007 | 167 | 1 |
713447 | 713447 | 2020-11-09 | Benton | Indiana | 18007 | 160 | 1 |
710203 | 710203 | 2020-11-08 | Benton | Indiana | 18007 | 152 | 1 |
706959 | 706959 | 2020-11-07 | Benton | Indiana | 18007 | 142 | 1 |
703716 | 703716 | 2020-11-06 | Benton | Indiana | 18007 | 135 | 1 |
700474 | 700474 | 2020-11-05 | Benton | Indiana | 18007 | 132 | 1 |
697230 | 697230 | 2020-11-04 | Benton | Indiana | 18007 | 131 | 1 |
693988 | 693988 | 2020-11-03 | Benton | Indiana | 18007 | 127 | 1 |
690745 | 690745 | 2020-11-02 | Benton | Indiana | 18007 | 124 | 1 |
687500 | 687500 | 2020-11-01 | Benton | Indiana | 18007 | 123 | 1 |
655158 | 655158 | 2020-10-22 | Benton | Iowa | 19011 | 540 | 1 |
651913 | 651913 | 2020-10-21 | Benton | Iowa | 19011 | 533 | 1 |
648669 | 648669 | 2020-10-20 | Benton | Iowa | 19011 | 521 | 1 |
645424 | 645424 | 2020-10-19 | Benton | Iowa | 19011 | 503 | 1 |
642177 | 642177 | 2020-10-18 | Benton | Iowa | 19011 | 497 | 1 |
638930 | 638930 | 2020-10-17 | Benton | Iowa | 19011 | 491 | 1 |
635684 | 635684 | 2020-10-16 | Benton | Iowa | 19011 | 483 | 1 |
632438 | 632438 | 2020-10-15 | Benton | Iowa | 19011 | 468 | 1 |
629194 | 629194 | 2020-10-14 | Benton | Iowa | 19011 | 451 | 1 |
625951 | 625951 | 2020-10-13 | Benton | Iowa | 19011 | 433 | 1 |
622709 | 622709 | 2020-10-12 | Benton | Iowa | 19011 | 417 | 1 |
619465 | 619465 | 2020-10-11 | Benton | Iowa | 19011 | 413 | 1 |
616223 | 616223 | 2020-10-10 | Benton | Iowa | 19011 | 408 | 1 |
612982 | 612982 | 2020-10-09 | Benton | Iowa | 19011 | 398 | 1 |
609740 | 609740 | 2020-10-08 | Benton | Iowa | 19011 | 387 | 1 |
606497 | 606497 | 2020-10-07 | Benton | Iowa | 19011 | 377 | 1 |
603255 | 603255 | 2020-10-06 | Benton | Iowa | 19011 | 372 | 1 |
600012 | 600012 | 2020-10-05 | Benton | Iowa | 19011 | 366 | 1 |
596770 | 596770 | 2020-10-04 | Benton | Iowa | 19011 | 365 | 1 |
593528 | 593528 | 2020-10-03 | Benton | Iowa | 19011 | 365 | 1 |
590287 | 590287 | 2020-10-02 | Benton | Iowa | 19011 | 357 | 1 |
587046 | 587046 | 2020-10-01 | Benton | Iowa | 19011 | 348 | 1 |
583806 | 583806 | 2020-09-30 | Benton | Iowa | 19011 | 344 | 1 |
580567 | 580567 | 2020-09-29 | Benton | Iowa | 19011 | 338 | 1 |
577326 | 577326 | 2020-09-28 | Benton | Iowa | 19011 | 328 | 1 |
574084 | 574084 | 2020-09-27 | Benton | Iowa | 19011 | 324 | 1 |
570841 | 570841 | 2020-09-26 | Benton | Iowa | 19011 | 310 | 1 |
567599 | 567599 | 2020-09-25 | Benton | Iowa | 19011 | 309 | 1 |
564359 | 564359 | 2020-09-24 | Benton | Iowa | 19011 | 306 | 1 |
561119 | 561119 | 2020-09-23 | Benton | Iowa | 19011 | 302 | 1 |
557883 | 557883 | 2020-09-22 | Benton | Iowa | 19011 | 292 | 1 |
554646 | 554646 | 2020-09-21 | Benton | Iowa | 19011 | 287 | 1 |
555263 | 555263 | 2020-09-21 | Benton | Mississippi | 28009 | 220 | 1 |
551407 | 551407 | 2020-09-20 | Benton | Iowa | 19011 | 286 | 1 |
552025 | 552025 | 2020-09-20 | Benton | Mississippi | 28009 | 219 | 1 |
548168 | 548168 | 2020-09-19 | Benton | Iowa | 19011 | 281 | 1 |
548786 | 548786 | 2020-09-19 | Benton | Mississippi | 28009 | 218 | 1 |
544930 | 544930 | 2020-09-18 | Benton | Iowa | 19011 | 278 | 1 |
545548 | 545548 | 2020-09-18 | Benton | Mississippi | 28009 | 218 | 1 |
541694 | 541694 | 2020-09-17 | Benton | Iowa | 19011 | 266 | 1 |
542311 | 542311 | 2020-09-17 | Benton | Mississippi | 28009 | 215 | 1 |
538457 | 538457 | 2020-09-16 | Benton | Iowa | 19011 | 257 | 1 |
539075 | 539075 | 2020-09-16 | Benton | Mississippi | 28009 | 208 | 1 |
535221 | 535221 | 2020-09-15 | Benton | Iowa | 19011 | 250 | 1 |
535838 | 535838 | 2020-09-15 | Benton | Mississippi | 28009 | 208 | 1 |
531986 | 531986 | 2020-09-14 | Benton | Iowa | 19011 | 247 | 1 |
532603 | 532603 | 2020-09-14 | Benton | Mississippi | 28009 | 206 | 1 |
532688 | 532688 | 2020-09-14 | Benton | Missouri | 29015 | 183 | 1 |
528749 | 528749 | 2020-09-13 | Benton | Iowa | 19011 | 244 | 1 |
529367 | 529367 | 2020-09-13 | Benton | Mississippi | 28009 | 206 | 1 |
529452 | 529452 | 2020-09-13 | Benton | Missouri | 29015 | 180 | 1 |
525513 | 525513 | 2020-09-12 | Benton | Iowa | 19011 | 239 | 1 |
526131 | 526131 | 2020-09-12 | Benton | Mississippi | 28009 | 205 | 1 |
526216 | 526216 | 2020-09-12 | Benton | Missouri | 29015 | 174 | 1 |
522277 | 522277 | 2020-09-11 | Benton | Iowa | 19011 | 236 | 1 |
522895 | 522895 | 2020-09-11 | Benton | Mississippi | 28009 | 206 | 1 |
522980 | 522980 | 2020-09-11 | Benton | Missouri | 29015 | 165 | 1 |
519040 | 519040 | 2020-09-10 | Benton | Iowa | 19011 | 232 | 1 |
519658 | 519658 | 2020-09-10 | Benton | Mississippi | 28009 | 207 | 1 |
519743 | 519743 | 2020-09-10 | Benton | Missouri | 29015 | 165 | 1 |
515805 | 515805 | 2020-09-09 | Benton | Iowa | 19011 | 228 | 1 |
516423 | 516423 | 2020-09-09 | Benton | Mississippi | 28009 | 207 | 1 |
516508 | 516508 | 2020-09-09 | Benton | Missouri | 29015 | 165 | 1 |
512572 | 512572 | 2020-09-08 | Benton | Iowa | 19011 | 226 | 1 |
513189 | 513189 | 2020-09-08 | Benton | Mississippi | 28009 | 203 | 1 |
513274 | 513274 | 2020-09-08 | Benton | Missouri | 29015 | 163 | 1 |
509339 | 509339 | 2020-09-07 | Benton | Iowa | 19011 | 223 | 1 |
509957 | 509957 | 2020-09-07 | Benton | Mississippi | 28009 | 201 | 1 |
510042 | 510042 | 2020-09-07 | Benton | Missouri | 29015 | 162 | 1 |
506107 | 506107 | 2020-09-06 | Benton | Iowa | 19011 | 221 | 1 |
506724 | 506724 | 2020-09-06 | Benton | Mississippi | 28009 | 201 | 1 |
506809 | 506809 | 2020-09-06 | Benton | Missouri | 29015 | 162 | 1 |
502873 | 502873 | 2020-09-05 | Benton | Iowa | 19011 | 220 | 1 |
503491 | 503491 | 2020-09-05 | Benton | Mississippi | 28009 | 201 | 1 |
503576 | 503576 | 2020-09-05 | Benton | Missouri | 29015 | 159 | 1 |
499639 | 499639 | 2020-09-04 | Benton | Iowa | 19011 | 217 | 1 |
500257 | 500257 | 2020-09-04 | Benton | Mississippi | 28009 | 200 | 1 |
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);