ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
11,402 rows where county = "Grant" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 15
- Washington 350
- Arkansas 343
- Oregon 343
- Indiana 342
- Louisiana 339
- Wisconsin 338
- Kentucky 334
- North Dakota 331
- New Mexico 330
- Oklahoma 328
- West Virginia 320
- Kansas 307
- Minnesota 299
- South Dakota 296
- Nebraska 162
fips 15
county 1
- Grant · 4,762 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1065479 | 1065479 | 2021-02-25 | Grant | Oregon | 41023 | 222 | 1 |
1065726 | 1065726 | 2021-02-25 | Grant | South Dakota | 46051 | 965 | 37 |
1066311 | 1066311 | 2021-02-25 | Grant | Washington | 53025 | 8903 | 114 |
1066349 | 1066349 | 2021-02-25 | Grant | West Virginia | 54023 | 1059 | 26 |
1066414 | 1066414 | 2021-02-25 | Grant | Wisconsin | 55043 | 5323 | 85 |
1060134 | 1060134 | 2021-02-24 | Grant | Arkansas | 5053 | 1550 | 32 |
1060727 | 1060727 | 2021-02-24 | Grant | Indiana | 18053 | 6821 | 164 |
1060926 | 1060926 | 2021-02-24 | Grant | Kansas | 20067 | 966 | 17 |
1061039 | 1061039 | 2021-02-24 | Grant | Kentucky | 21081 | 2170 | 13 |
1061140 | 1061140 | 2021-02-24 | Grant | Louisiana | 22043 | 2005 | 51 |
1061350 | 1061350 | 2021-02-24 | Grant | Minnesota | 27051 | 488 | 8 |
1061705 | 1061705 | 2021-02-24 | Grant | Nebraska | 31075 | 35 | 4 |
1061820 | 1061820 | 2021-02-24 | Grant | New Mexico | 35017 | 1462 | 34 |
1062020 | 1062020 | 2021-02-24 | Grant | North Dakota | 38037 | 184 | 7 |
1062172 | 1062172 | 2021-02-24 | Grant | Oklahoma | 40053 | 533 | 7 |
1062234 | 1062234 | 2021-02-24 | Grant | Oregon | 41023 | 222 | 1 |
1062481 | 1062481 | 2021-02-24 | Grant | South Dakota | 46051 | 962 | 37 |
1063066 | 1063066 | 2021-02-24 | Grant | Washington | 53025 | 8878 | 108 |
1063104 | 1063104 | 2021-02-24 | Grant | West Virginia | 54023 | 1054 | 26 |
1063169 | 1063169 | 2021-02-24 | Grant | Wisconsin | 55043 | 5304 | 84 |
1056888 | 1056888 | 2021-02-23 | Grant | Arkansas | 5053 | 1545 | 32 |
1057481 | 1057481 | 2021-02-23 | Grant | Indiana | 18053 | 6810 | 164 |
1057680 | 1057680 | 2021-02-23 | Grant | Kansas | 20067 | 966 | 17 |
1057793 | 1057793 | 2021-02-23 | Grant | Kentucky | 21081 | 2149 | 13 |
1057894 | 1057894 | 2021-02-23 | Grant | Louisiana | 22043 | 2001 | 51 |
1058104 | 1058104 | 2021-02-23 | Grant | Minnesota | 27051 | 484 | 8 |
1058459 | 1058459 | 2021-02-23 | Grant | Nebraska | 31075 | 35 | 4 |
1058574 | 1058574 | 2021-02-23 | Grant | New Mexico | 35017 | 1460 | 34 |
1058774 | 1058774 | 2021-02-23 | Grant | North Dakota | 38037 | 184 | 7 |
1058926 | 1058926 | 2021-02-23 | Grant | Oklahoma | 40053 | 533 | 7 |
1058989 | 1058989 | 2021-02-23 | Grant | Oregon | 41023 | 222 | 1 |
1059236 | 1059236 | 2021-02-23 | Grant | South Dakota | 46051 | 959 | 37 |
1059821 | 1059821 | 2021-02-23 | Grant | Washington | 53025 | 8863 | 108 |
1059859 | 1059859 | 2021-02-23 | Grant | West Virginia | 54023 | 1052 | 25 |
1059924 | 1059924 | 2021-02-23 | Grant | Wisconsin | 55043 | 5300 | 84 |
1053642 | 1053642 | 2021-02-22 | Grant | Arkansas | 5053 | 1540 | 32 |
1054235 | 1054235 | 2021-02-22 | Grant | Indiana | 18053 | 6806 | 163 |
1054434 | 1054434 | 2021-02-22 | Grant | Kansas | 20067 | 965 | 17 |
1054547 | 1054547 | 2021-02-22 | Grant | Kentucky | 21081 | 2144 | 13 |
1054648 | 1054648 | 2021-02-22 | Grant | Louisiana | 22043 | 1992 | 51 |
1054858 | 1054858 | 2021-02-22 | Grant | Minnesota | 27051 | 482 | 8 |
1055213 | 1055213 | 2021-02-22 | Grant | Nebraska | 31075 | 35 | 4 |
1055328 | 1055328 | 2021-02-22 | Grant | New Mexico | 35017 | 1456 | 34 |
1055528 | 1055528 | 2021-02-22 | Grant | North Dakota | 38037 | 184 | 7 |
1055680 | 1055680 | 2021-02-22 | Grant | Oklahoma | 40053 | 531 | 7 |
1055743 | 1055743 | 2021-02-22 | Grant | Oregon | 41023 | 221 | 1 |
1055990 | 1055990 | 2021-02-22 | Grant | South Dakota | 46051 | 954 | 37 |
1056575 | 1056575 | 2021-02-22 | Grant | Washington | 53025 | 8826 | 108 |
1056613 | 1056613 | 2021-02-22 | Grant | West Virginia | 54023 | 1049 | 25 |
1056678 | 1056678 | 2021-02-22 | Grant | Wisconsin | 55043 | 5296 | 84 |
1050395 | 1050395 | 2021-02-21 | Grant | Arkansas | 5053 | 1538 | 32 |
1050988 | 1050988 | 2021-02-21 | Grant | Indiana | 18053 | 6803 | 162 |
1051187 | 1051187 | 2021-02-21 | Grant | Kansas | 20067 | 964 | 17 |
1051300 | 1051300 | 2021-02-21 | Grant | Kentucky | 21081 | 2142 | 13 |
1051401 | 1051401 | 2021-02-21 | Grant | Louisiana | 22043 | 1984 | 51 |
1051611 | 1051611 | 2021-02-21 | Grant | Minnesota | 27051 | 481 | 8 |
1051966 | 1051966 | 2021-02-21 | Grant | Nebraska | 31075 | 35 | 4 |
1052081 | 1052081 | 2021-02-21 | Grant | New Mexico | 35017 | 1455 | 34 |
1052282 | 1052282 | 2021-02-21 | Grant | North Dakota | 38037 | 184 | 7 |
1052434 | 1052434 | 2021-02-21 | Grant | Oklahoma | 40053 | 531 | 7 |
1052497 | 1052497 | 2021-02-21 | Grant | Oregon | 41023 | 221 | 1 |
1052744 | 1052744 | 2021-02-21 | Grant | South Dakota | 46051 | 954 | 37 |
1053329 | 1053329 | 2021-02-21 | Grant | Washington | 53025 | 8794 | 108 |
1053367 | 1053367 | 2021-02-21 | Grant | West Virginia | 54023 | 1048 | 25 |
1053432 | 1053432 | 2021-02-21 | Grant | Wisconsin | 55043 | 5295 | 84 |
1047148 | 1047148 | 2021-02-20 | Grant | Arkansas | 5053 | 1535 | 32 |
1047741 | 1047741 | 2021-02-20 | Grant | Indiana | 18053 | 6797 | 162 |
1047940 | 1047940 | 2021-02-20 | Grant | Kansas | 20067 | 964 | 17 |
1048053 | 1048053 | 2021-02-20 | Grant | Kentucky | 21081 | 2133 | 13 |
1048154 | 1048154 | 2021-02-20 | Grant | Louisiana | 22043 | 1976 | 51 |
1048364 | 1048364 | 2021-02-20 | Grant | Minnesota | 27051 | 481 | 8 |
1048719 | 1048719 | 2021-02-20 | Grant | Nebraska | 31075 | 35 | 4 |
1048834 | 1048834 | 2021-02-20 | Grant | New Mexico | 35017 | 1454 | 34 |
1049035 | 1049035 | 2021-02-20 | Grant | North Dakota | 38037 | 184 | 7 |
1049187 | 1049187 | 2021-02-20 | Grant | Oklahoma | 40053 | 531 | 7 |
1049250 | 1049250 | 2021-02-20 | Grant | Oregon | 41023 | 221 | 1 |
1049497 | 1049497 | 2021-02-20 | Grant | South Dakota | 46051 | 951 | 37 |
1050082 | 1050082 | 2021-02-20 | Grant | Washington | 53025 | 8794 | 108 |
1050120 | 1050120 | 2021-02-20 | Grant | West Virginia | 54023 | 1047 | 25 |
1050185 | 1050185 | 2021-02-20 | Grant | Wisconsin | 55043 | 5296 | 84 |
1043903 | 1043903 | 2021-02-19 | Grant | Arkansas | 5053 | 1535 | 32 |
1044496 | 1044496 | 2021-02-19 | Grant | Indiana | 18053 | 6787 | 161 |
1044695 | 1044695 | 2021-02-19 | Grant | Kansas | 20067 | 964 | 17 |
1044808 | 1044808 | 2021-02-19 | Grant | Kentucky | 21081 | 2123 | 12 |
1044909 | 1044909 | 2021-02-19 | Grant | Louisiana | 22043 | 1976 | 51 |
1045118 | 1045118 | 2021-02-19 | Grant | Minnesota | 27051 | 482 | 8 |
1045473 | 1045473 | 2021-02-19 | Grant | Nebraska | 31075 | 35 | 4 |
1045588 | 1045588 | 2021-02-19 | Grant | New Mexico | 35017 | 1449 | 34 |
1045788 | 1045788 | 2021-02-19 | Grant | North Dakota | 38037 | 184 | 7 |
1045940 | 1045940 | 2021-02-19 | Grant | Oklahoma | 40053 | 528 | 7 |
1046003 | 1046003 | 2021-02-19 | Grant | Oregon | 41023 | 221 | 1 |
1046250 | 1046250 | 2021-02-19 | Grant | South Dakota | 46051 | 949 | 37 |
1046835 | 1046835 | 2021-02-19 | Grant | Washington | 53025 | 8794 | 108 |
1046873 | 1046873 | 2021-02-19 | Grant | West Virginia | 54023 | 1044 | 25 |
1046938 | 1046938 | 2021-02-19 | Grant | Wisconsin | 55043 | 5293 | 84 |
1040658 | 1040658 | 2021-02-18 | Grant | Arkansas | 5053 | 1536 | 32 |
1041251 | 1041251 | 2021-02-18 | Grant | Indiana | 18053 | 6783 | 161 |
1041450 | 1041450 | 2021-02-18 | Grant | Kansas | 20067 | 964 | 17 |
1041563 | 1041563 | 2021-02-18 | Grant | Kentucky | 21081 | 2107 | 12 |
1041664 | 1041664 | 2021-02-18 | Grant | Louisiana | 22043 | 1980 | 51 |
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);