ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
388 rows where county = "Grant" and deaths = 5 sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 14
- Nebraska 178
- Oklahoma 68
- Kentucky 31
- Minnesota 18
- Washington 16
- Arkansas 15
- Kansas 15
- North Dakota 15
- South Dakota 11
- Oregon 7
- West Virginia 6
- New Mexico 5
- Indiana 2
- Wisconsin 1
fips 14
county 1
- Grant · 388 ✖
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
76349 | 76349 | 2020-04-21 | Grant | Indiana | 18053 | 100 | 5 |
79133 | 79133 | 2020-04-22 | Grant | Indiana | 18053 | 105 | 5 |
98098 | 98098 | 2020-04-28 | Grant | Wisconsin | 55043 | 32 | 5 |
268042 | 268042 | 2020-06-23 | Grant | Washington | 53025 | 470 | 5 |
271176 | 271176 | 2020-06-24 | Grant | Washington | 53025 | 478 | 5 |
274316 | 274316 | 2020-06-25 | Grant | Washington | 53025 | 513 | 5 |
277464 | 277464 | 2020-06-26 | Grant | Washington | 53025 | 564 | 5 |
280612 | 280612 | 2020-06-27 | Grant | Washington | 53025 | 577 | 5 |
283758 | 283758 | 2020-06-28 | Grant | Washington | 53025 | 577 | 5 |
286904 | 286904 | 2020-06-29 | Grant | Washington | 53025 | 610 | 5 |
290054 | 290054 | 2020-06-30 | Grant | Washington | 53025 | 611 | 5 |
293207 | 293207 | 2020-07-01 | Grant | Washington | 53025 | 621 | 5 |
296362 | 296362 | 2020-07-02 | Grant | Washington | 53025 | 634 | 5 |
299524 | 299524 | 2020-07-03 | Grant | Washington | 53025 | 646 | 5 |
302688 | 302688 | 2020-07-04 | Grant | Washington | 53025 | 646 | 5 |
305852 | 305852 | 2020-07-05 | Grant | Washington | 53025 | 646 | 5 |
309020 | 309020 | 2020-07-06 | Grant | Washington | 53025 | 724 | 5 |
312189 | 312189 | 2020-07-07 | Grant | Washington | 53025 | 742 | 5 |
315364 | 315364 | 2020-07-08 | Grant | Washington | 53025 | 762 | 5 |
319739 | 319739 | 2020-07-10 | Grant | Kentucky | 21081 | 64 | 5 |
322918 | 322918 | 2020-07-11 | Grant | Kentucky | 21081 | 66 | 5 |
326101 | 326101 | 2020-07-12 | Grant | Kentucky | 21081 | 67 | 5 |
329287 | 329287 | 2020-07-13 | Grant | Kentucky | 21081 | 70 | 5 |
332474 | 332474 | 2020-07-14 | Grant | Kentucky | 21081 | 70 | 5 |
335667 | 335667 | 2020-07-15 | Grant | Kentucky | 21081 | 71 | 5 |
338863 | 338863 | 2020-07-16 | Grant | Kentucky | 21081 | 74 | 5 |
342059 | 342059 | 2020-07-17 | Grant | Kentucky | 21081 | 76 | 5 |
345259 | 345259 | 2020-07-18 | Grant | Kentucky | 21081 | 77 | 5 |
348460 | 348460 | 2020-07-19 | Grant | Kentucky | 21081 | 78 | 5 |
351660 | 351660 | 2020-07-20 | Grant | Kentucky | 21081 | 79 | 5 |
354862 | 354862 | 2020-07-21 | Grant | Kentucky | 21081 | 79 | 5 |
358065 | 358065 | 2020-07-22 | Grant | Kentucky | 21081 | 80 | 5 |
361270 | 361270 | 2020-07-23 | Grant | Kentucky | 21081 | 81 | 5 |
364477 | 364477 | 2020-07-24 | Grant | Kentucky | 21081 | 83 | 5 |
367684 | 367684 | 2020-07-25 | Grant | Kentucky | 21081 | 84 | 5 |
370894 | 370894 | 2020-07-26 | Grant | Kentucky | 21081 | 84 | 5 |
374106 | 374106 | 2020-07-27 | Grant | Kentucky | 21081 | 86 | 5 |
377321 | 377321 | 2020-07-28 | Grant | Kentucky | 21081 | 87 | 5 |
380538 | 380538 | 2020-07-29 | Grant | Kentucky | 21081 | 89 | 5 |
383755 | 383755 | 2020-07-30 | Grant | Kentucky | 21081 | 91 | 5 |
386973 | 386973 | 2020-07-31 | Grant | Kentucky | 21081 | 96 | 5 |
390190 | 390190 | 2020-08-01 | Grant | Kentucky | 21081 | 99 | 5 |
393407 | 393407 | 2020-08-02 | Grant | Kentucky | 21081 | 100 | 5 |
396623 | 396623 | 2020-08-03 | Grant | Kentucky | 21081 | 105 | 5 |
399838 | 399838 | 2020-08-04 | Grant | Kentucky | 21081 | 106 | 5 |
403055 | 403055 | 2020-08-05 | Grant | Kentucky | 21081 | 107 | 5 |
406273 | 406273 | 2020-08-06 | Grant | Kentucky | 21081 | 108 | 5 |
409493 | 409493 | 2020-08-07 | Grant | Kentucky | 21081 | 112 | 5 |
412713 | 412713 | 2020-08-08 | Grant | Kentucky | 21081 | 117 | 5 |
415933 | 415933 | 2020-08-09 | Grant | Kentucky | 21081 | 120 | 5 |
450232 | 450232 | 2020-08-19 | Grant | West Virginia | 54023 | 131 | 5 |
453460 | 453460 | 2020-08-20 | Grant | West Virginia | 54023 | 131 | 5 |
469602 | 469602 | 2020-08-25 | Grant | West Virginia | 54023 | 134 | 5 |
472834 | 472834 | 2020-08-26 | Grant | West Virginia | 54023 | 138 | 5 |
476067 | 476067 | 2020-08-27 | Grant | West Virginia | 54023 | 139 | 5 |
479300 | 479300 | 2020-08-28 | Grant | West Virginia | 54023 | 140 | 5 |
551535 | 551535 | 2020-09-20 | Grant | Kansas | 20067 | 236 | 5 |
554774 | 554774 | 2020-09-21 | Grant | Kansas | 20067 | 236 | 5 |
558011 | 558011 | 2020-09-22 | Grant | Kansas | 20067 | 254 | 5 |
561247 | 561247 | 2020-09-23 | Grant | Kansas | 20067 | 268 | 5 |
564487 | 564487 | 2020-09-24 | Grant | Kansas | 20067 | 268 | 5 |
567727 | 567727 | 2020-09-25 | Grant | Kansas | 20067 | 272 | 5 |
570969 | 570969 | 2020-09-26 | Grant | Kansas | 20067 | 272 | 5 |
574212 | 574212 | 2020-09-27 | Grant | Kansas | 20067 | 293 | 5 |
577454 | 577454 | 2020-09-28 | Grant | Kansas | 20067 | 301 | 5 |
580695 | 580695 | 2020-09-29 | Grant | Kansas | 20067 | 303 | 5 |
583934 | 583934 | 2020-09-30 | Grant | Kansas | 20067 | 305 | 5 |
587174 | 587174 | 2020-10-01 | Grant | Kansas | 20067 | 310 | 5 |
590415 | 590415 | 2020-10-02 | Grant | Kansas | 20067 | 318 | 5 |
593656 | 593656 | 2020-10-03 | Grant | Kansas | 20067 | 321 | 5 |
596898 | 596898 | 2020-10-04 | Grant | Kansas | 20067 | 321 | 5 |
684902 | 684902 | 2020-10-31 | Grant | Minnesota | 27051 | 110 | 5 |
688146 | 688146 | 2020-11-01 | Grant | Minnesota | 27051 | 111 | 5 |
691391 | 691391 | 2020-11-02 | Grant | Minnesota | 27051 | 113 | 5 |
694633 | 694633 | 2020-11-03 | Grant | Minnesota | 27051 | 118 | 5 |
697876 | 697876 | 2020-11-04 | Grant | Minnesota | 27051 | 123 | 5 |
701120 | 701120 | 2020-11-05 | Grant | Minnesota | 27051 | 126 | 5 |
704362 | 704362 | 2020-11-06 | Grant | Minnesota | 27051 | 131 | 5 |
707605 | 707605 | 2020-11-07 | Grant | Minnesota | 27051 | 132 | 5 |
710849 | 710849 | 2020-11-08 | Grant | Minnesota | 27051 | 139 | 5 |
714093 | 714093 | 2020-11-09 | Grant | Minnesota | 27051 | 141 | 5 |
714563 | 714563 | 2020-11-09 | Grant | New Mexico | 35017 | 247 | 5 |
717337 | 717337 | 2020-11-10 | Grant | Minnesota | 27051 | 143 | 5 |
717806 | 717806 | 2020-11-10 | Grant | New Mexico | 35017 | 252 | 5 |
720580 | 720580 | 2020-11-11 | Grant | Minnesota | 27051 | 147 | 5 |
721049 | 721049 | 2020-11-11 | Grant | New Mexico | 35017 | 254 | 5 |
723823 | 723823 | 2020-11-12 | Grant | Minnesota | 27051 | 152 | 5 |
724292 | 724292 | 2020-11-12 | Grant | New Mexico | 35017 | 271 | 5 |
727066 | 727066 | 2020-11-13 | Grant | Minnesota | 27051 | 156 | 5 |
727536 | 727536 | 2020-11-13 | Grant | New Mexico | 35017 | 279 | 5 |
730309 | 730309 | 2020-11-14 | Grant | Minnesota | 27051 | 167 | 5 |
731442 | 731442 | 2020-11-14 | Grant | South Dakota | 46051 | 462 | 5 |
732340 | 732340 | 2020-11-15 | Grant | Arkansas | 5053 | 464 | 5 |
733554 | 733554 | 2020-11-15 | Grant | Minnesota | 27051 | 177 | 5 |
734688 | 734688 | 2020-11-15 | Grant | South Dakota | 46051 | 475 | 5 |
735586 | 735586 | 2020-11-16 | Grant | Arkansas | 5053 | 468 | 5 |
736800 | 736800 | 2020-11-16 | Grant | Minnesota | 27051 | 184 | 5 |
737932 | 737932 | 2020-11-16 | Grant | South Dakota | 46051 | 482 | 5 |
738830 | 738830 | 2020-11-17 | Grant | Arkansas | 5053 | 473 | 5 |
740044 | 740044 | 2020-11-17 | Grant | Minnesota | 27051 | 189 | 5 |
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);