ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
62 rows where county = "Green" and deaths = 9 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
845725 | 845725 | 2020-12-19 | Green | Wisconsin | 55045 | 2181 | 9 |
842479 | 842479 | 2020-12-18 | Green | Wisconsin | 55045 | 2167 | 9 |
839234 | 839234 | 2020-12-17 | Green | Wisconsin | 55045 | 2130 | 9 |
835989 | 835989 | 2020-12-16 | Green | Wisconsin | 55045 | 2093 | 9 |
832743 | 832743 | 2020-12-15 | Green | Wisconsin | 55045 | 2071 | 9 |
826250 | 826250 | 2020-12-13 | Green | Wisconsin | 55045 | 2057 | 9 |
823003 | 823003 | 2020-12-12 | Green | Wisconsin | 55045 | 2041 | 9 |
819757 | 819757 | 2020-12-11 | Green | Wisconsin | 55045 | 2005 | 9 |
687838 | 687838 | 2020-11-01 | Green | Kentucky | 21087 | 365 | 9 |
684594 | 684594 | 2020-10-31 | Green | Kentucky | 21087 | 362 | 9 |
681351 | 681351 | 2020-10-30 | Green | Kentucky | 21087 | 361 | 9 |
678107 | 678107 | 2020-10-29 | Green | Kentucky | 21087 | 355 | 9 |
674865 | 674865 | 2020-10-28 | Green | Kentucky | 21087 | 352 | 9 |
671622 | 671622 | 2020-10-27 | Green | Kentucky | 21087 | 349 | 9 |
668380 | 668380 | 2020-10-26 | Green | Kentucky | 21087 | 347 | 9 |
665136 | 665136 | 2020-10-25 | Green | Kentucky | 21087 | 344 | 9 |
661891 | 661891 | 2020-10-24 | Green | Kentucky | 21087 | 344 | 9 |
658647 | 658647 | 2020-10-23 | Green | Kentucky | 21087 | 339 | 9 |
655402 | 655402 | 2020-10-22 | Green | Kentucky | 21087 | 337 | 9 |
652157 | 652157 | 2020-10-21 | Green | Kentucky | 21087 | 334 | 9 |
648912 | 648912 | 2020-10-20 | Green | Kentucky | 21087 | 329 | 9 |
645668 | 645668 | 2020-10-19 | Green | Kentucky | 21087 | 326 | 9 |
642421 | 642421 | 2020-10-18 | Green | Kentucky | 21087 | 320 | 9 |
639174 | 639174 | 2020-10-17 | Green | Kentucky | 21087 | 320 | 9 |
635928 | 635928 | 2020-10-16 | Green | Kentucky | 21087 | 314 | 9 |
632682 | 632682 | 2020-10-15 | Green | Kentucky | 21087 | 311 | 9 |
629438 | 629438 | 2020-10-14 | Green | Kentucky | 21087 | 311 | 9 |
626194 | 626194 | 2020-10-13 | Green | Kentucky | 21087 | 306 | 9 |
622952 | 622952 | 2020-10-12 | Green | Kentucky | 21087 | 302 | 9 |
619708 | 619708 | 2020-10-11 | Green | Kentucky | 21087 | 301 | 9 |
616466 | 616466 | 2020-10-10 | Green | Kentucky | 21087 | 298 | 9 |
613225 | 613225 | 2020-10-09 | Green | Kentucky | 21087 | 295 | 9 |
609983 | 609983 | 2020-10-08 | Green | Kentucky | 21087 | 294 | 9 |
606741 | 606741 | 2020-10-07 | Green | Kentucky | 21087 | 291 | 9 |
603499 | 603499 | 2020-10-06 | Green | Kentucky | 21087 | 289 | 9 |
600256 | 600256 | 2020-10-05 | Green | Kentucky | 21087 | 287 | 9 |
597014 | 597014 | 2020-10-04 | Green | Kentucky | 21087 | 286 | 9 |
593772 | 593772 | 2020-10-03 | Green | Kentucky | 21087 | 284 | 9 |
590531 | 590531 | 2020-10-02 | Green | Kentucky | 21087 | 284 | 9 |
587290 | 587290 | 2020-10-01 | Green | Kentucky | 21087 | 283 | 9 |
584050 | 584050 | 2020-09-30 | Green | Kentucky | 21087 | 282 | 9 |
580810 | 580810 | 2020-09-29 | Green | Kentucky | 21087 | 281 | 9 |
577569 | 577569 | 2020-09-28 | Green | Kentucky | 21087 | 279 | 9 |
574327 | 574327 | 2020-09-27 | Green | Kentucky | 21087 | 275 | 9 |
571084 | 571084 | 2020-09-26 | Green | Kentucky | 21087 | 274 | 9 |
567842 | 567842 | 2020-09-25 | Green | Kentucky | 21087 | 274 | 9 |
564602 | 564602 | 2020-09-24 | Green | Kentucky | 21087 | 267 | 9 |
561362 | 561362 | 2020-09-23 | Green | Kentucky | 21087 | 265 | 9 |
558126 | 558126 | 2020-09-22 | Green | Kentucky | 21087 | 264 | 9 |
554889 | 554889 | 2020-09-21 | Green | Kentucky | 21087 | 261 | 9 |
551650 | 551650 | 2020-09-20 | Green | Kentucky | 21087 | 260 | 9 |
548411 | 548411 | 2020-09-19 | Green | Kentucky | 21087 | 257 | 9 |
545173 | 545173 | 2020-09-18 | Green | Kentucky | 21087 | 255 | 9 |
541937 | 541937 | 2020-09-17 | Green | Kentucky | 21087 | 254 | 9 |
538701 | 538701 | 2020-09-16 | Green | Kentucky | 21087 | 250 | 9 |
535464 | 535464 | 2020-09-15 | Green | Kentucky | 21087 | 248 | 9 |
532229 | 532229 | 2020-09-14 | Green | Kentucky | 21087 | 242 | 9 |
528992 | 528992 | 2020-09-13 | Green | Kentucky | 21087 | 240 | 9 |
525756 | 525756 | 2020-09-12 | Green | Kentucky | 21087 | 237 | 9 |
522520 | 522520 | 2020-09-11 | Green | Kentucky | 21087 | 237 | 9 |
519283 | 519283 | 2020-09-10 | Green | Kentucky | 21087 | 233 | 9 |
516048 | 516048 | 2020-09-09 | Green | Kentucky | 21087 | 226 | 9 |
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);