ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
470 rows where county = "Grant" and deaths = 8 sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 12
- Minnesota 254
- Oklahoma 91
- North Dakota 28
- Oregon 28
- Kansas 26
- West Virginia 16
- Kentucky 12
- New Mexico 4
- Arkansas 3
- Indiana 3
- Louisiana 3
- Washington 2
fips 12
county 1
- Grant · 470 ✖
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
84726 | 84726 | 2020-04-24 | Grant | Indiana | 18053 | 119 | 8 |
87536 | 87536 | 2020-04-25 | Grant | Indiana | 18053 | 120 | 8 |
90352 | 90352 | 2020-04-26 | Grant | Indiana | 18053 | 122 | 8 |
363269 | 363269 | 2020-07-23 | Grant | Washington | 53025 | 1078 | 8 |
366475 | 366475 | 2020-07-24 | Grant | Washington | 53025 | 1111 | 8 |
383856 | 383856 | 2020-07-30 | Grant | Louisiana | 22043 | 266 | 8 |
387074 | 387074 | 2020-07-31 | Grant | Louisiana | 22043 | 270 | 8 |
390291 | 390291 | 2020-08-01 | Grant | Louisiana | 22043 | 270 | 8 |
626079 | 626079 | 2020-10-13 | Grant | Kansas | 20067 | 371 | 8 |
629322 | 629322 | 2020-10-14 | Grant | Kansas | 20067 | 379 | 8 |
632566 | 632566 | 2020-10-15 | Grant | Kansas | 20067 | 379 | 8 |
635812 | 635812 | 2020-10-16 | Grant | Kansas | 20067 | 389 | 8 |
639058 | 639058 | 2020-10-17 | Grant | Kansas | 20067 | 392 | 8 |
641237 | 641237 | 2020-10-17 | Grant | West Virginia | 54023 | 178 | 8 |
642305 | 642305 | 2020-10-18 | Grant | Kansas | 20067 | 398 | 8 |
644485 | 644485 | 2020-10-18 | Grant | West Virginia | 54023 | 178 | 8 |
645552 | 645552 | 2020-10-19 | Grant | Kansas | 20067 | 400 | 8 |
647731 | 647731 | 2020-10-19 | Grant | West Virginia | 54023 | 178 | 8 |
648797 | 648797 | 2020-10-20 | Grant | Kansas | 20067 | 410 | 8 |
650975 | 650975 | 2020-10-20 | Grant | West Virginia | 54023 | 178 | 8 |
652041 | 652041 | 2020-10-21 | Grant | Kansas | 20067 | 417 | 8 |
654220 | 654220 | 2020-10-21 | Grant | West Virginia | 54023 | 179 | 8 |
655286 | 655286 | 2020-10-22 | Grant | Kansas | 20067 | 422 | 8 |
657465 | 657465 | 2020-10-22 | Grant | West Virginia | 54023 | 179 | 8 |
658531 | 658531 | 2020-10-23 | Grant | Kansas | 20067 | 424 | 8 |
660709 | 660709 | 2020-10-23 | Grant | West Virginia | 54023 | 179 | 8 |
661775 | 661775 | 2020-10-24 | Grant | Kansas | 20067 | 424 | 8 |
663953 | 663953 | 2020-10-24 | Grant | West Virginia | 54023 | 182 | 8 |
665020 | 665020 | 2020-10-25 | Grant | Kansas | 20067 | 429 | 8 |
667198 | 667198 | 2020-10-25 | Grant | West Virginia | 54023 | 185 | 8 |
668264 | 668264 | 2020-10-26 | Grant | Kansas | 20067 | 429 | 8 |
670441 | 670441 | 2020-10-26 | Grant | West Virginia | 54023 | 188 | 8 |
671507 | 671507 | 2020-10-27 | Grant | Kansas | 20067 | 434 | 8 |
673683 | 673683 | 2020-10-27 | Grant | West Virginia | 54023 | 191 | 8 |
674749 | 674749 | 2020-10-28 | Grant | Kansas | 20067 | 448 | 8 |
676926 | 676926 | 2020-10-28 | Grant | West Virginia | 54023 | 191 | 8 |
677992 | 677992 | 2020-10-29 | Grant | Kansas | 20067 | 457 | 8 |
680169 | 680169 | 2020-10-29 | Grant | West Virginia | 54023 | 194 | 8 |
681235 | 681235 | 2020-10-30 | Grant | Kansas | 20067 | 470 | 8 |
683412 | 683412 | 2020-10-30 | Grant | West Virginia | 54023 | 198 | 8 |
684478 | 684478 | 2020-10-31 | Grant | Kansas | 20067 | 473 | 8 |
686655 | 686655 | 2020-10-31 | Grant | West Virginia | 54023 | 199 | 8 |
687722 | 687722 | 2020-11-01 | Grant | Kansas | 20067 | 473 | 8 |
689900 | 689900 | 2020-11-01 | Grant | West Virginia | 54023 | 199 | 8 |
690967 | 690967 | 2020-11-02 | Grant | Kansas | 20067 | 486 | 8 |
694210 | 694210 | 2020-11-03 | Grant | Kansas | 20067 | 486 | 8 |
697452 | 697452 | 2020-11-04 | Grant | Kansas | 20067 | 486 | 8 |
700696 | 700696 | 2020-11-05 | Grant | Kansas | 20067 | 512 | 8 |
703938 | 703938 | 2020-11-06 | Grant | Kansas | 20067 | 531 | 8 |
707181 | 707181 | 2020-11-07 | Grant | Kansas | 20067 | 531 | 8 |
816720 | 816720 | 2020-12-11 | Grant | Arkansas | 5053 | 733 | 8 |
819966 | 819966 | 2020-12-12 | Grant | Arkansas | 5053 | 739 | 8 |
821651 | 821651 | 2020-12-12 | Grant | New Mexico | 35017 | 630 | 8 |
823212 | 823212 | 2020-12-13 | Grant | Arkansas | 5053 | 748 | 8 |
824897 | 824897 | 2020-12-13 | Grant | New Mexico | 35017 | 639 | 8 |
828144 | 828144 | 2020-12-14 | Grant | New Mexico | 35017 | 645 | 8 |
831390 | 831390 | 2020-12-15 | Grant | New Mexico | 35017 | 655 | 8 |
856573 | 856573 | 2020-12-23 | Grant | Kentucky | 21081 | 1222 | 8 |
859818 | 859818 | 2020-12-24 | Grant | Kentucky | 21081 | 1222 | 8 |
863063 | 863063 | 2020-12-25 | Grant | Kentucky | 21081 | 1222 | 8 |
866308 | 866308 | 2020-12-26 | Grant | Kentucky | 21081 | 1222 | 8 |
869553 | 869553 | 2020-12-27 | Grant | Kentucky | 21081 | 1222 | 8 |
872798 | 872798 | 2020-12-28 | Grant | Kentucky | 21081 | 1264 | 8 |
876043 | 876043 | 2020-12-29 | Grant | Kentucky | 21081 | 1279 | 8 |
879288 | 879288 | 2020-12-30 | Grant | Kentucky | 21081 | 1289 | 8 |
882533 | 882533 | 2020-12-31 | Grant | Kentucky | 21081 | 1289 | 8 |
885778 | 885778 | 2021-01-01 | Grant | Kentucky | 21081 | 1289 | 8 |
889024 | 889024 | 2021-01-02 | Grant | Kentucky | 21081 | 1289 | 8 |
892270 | 892270 | 2021-01-03 | Grant | Kentucky | 21081 | 1289 | 8 |
938015 | 938015 | 2021-01-17 | Grant | Minnesota | 27051 | 429 | 8 |
941260 | 941260 | 2021-01-18 | Grant | Minnesota | 27051 | 429 | 8 |
944505 | 944505 | 2021-01-19 | Grant | Minnesota | 27051 | 429 | 8 |
947752 | 947752 | 2021-01-20 | Grant | Minnesota | 27051 | 429 | 8 |
950998 | 950998 | 2021-01-21 | Grant | Minnesota | 27051 | 429 | 8 |
954243 | 954243 | 2021-01-22 | Grant | Minnesota | 27051 | 435 | 8 |
957488 | 957488 | 2021-01-23 | Grant | Minnesota | 27051 | 438 | 8 |
960734 | 960734 | 2021-01-24 | Grant | Minnesota | 27051 | 438 | 8 |
963979 | 963979 | 2021-01-25 | Grant | Minnesota | 27051 | 438 | 8 |
967223 | 967223 | 2021-01-26 | Grant | Minnesota | 27051 | 439 | 8 |
970468 | 970468 | 2021-01-27 | Grant | Minnesota | 27051 | 441 | 8 |
973713 | 973713 | 2021-01-28 | Grant | Minnesota | 27051 | 444 | 8 |
976958 | 976958 | 2021-01-29 | Grant | Minnesota | 27051 | 448 | 8 |
980204 | 980204 | 2021-01-30 | Grant | Minnesota | 27051 | 448 | 8 |
983450 | 983450 | 2021-01-31 | Grant | Minnesota | 27051 | 450 | 8 |
986697 | 986697 | 2021-02-01 | Grant | Minnesota | 27051 | 450 | 8 |
989944 | 989944 | 2021-02-02 | Grant | Minnesota | 27051 | 452 | 8 |
993190 | 993190 | 2021-02-03 | Grant | Minnesota | 27051 | 452 | 8 |
996436 | 996436 | 2021-02-04 | Grant | Minnesota | 27051 | 455 | 8 |
999682 | 999682 | 2021-02-05 | Grant | Minnesota | 27051 | 457 | 8 |
1002927 | 1002927 | 2021-02-06 | Grant | Minnesota | 27051 | 458 | 8 |
1006173 | 1006173 | 2021-02-07 | Grant | Minnesota | 27051 | 462 | 8 |
1009420 | 1009420 | 2021-02-08 | Grant | Minnesota | 27051 | 463 | 8 |
1012665 | 1012665 | 2021-02-09 | Grant | Minnesota | 27051 | 464 | 8 |
1015910 | 1015910 | 2021-02-10 | Grant | Minnesota | 27051 | 465 | 8 |
1019155 | 1019155 | 2021-02-11 | Grant | Minnesota | 27051 | 465 | 8 |
1022400 | 1022400 | 2021-02-12 | Grant | Minnesota | 27051 | 467 | 8 |
1025645 | 1025645 | 2021-02-13 | Grant | Minnesota | 27051 | 467 | 8 |
1028891 | 1028891 | 2021-02-14 | Grant | Minnesota | 27051 | 468 | 8 |
1032138 | 1032138 | 2021-02-15 | Grant | Minnesota | 27051 | 468 | 8 |
1035383 | 1035383 | 2021-02-16 | Grant | Minnesota | 27051 | 468 | 8 |
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);