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 347
- Arkansas 341
- Indiana 340
- Oregon 340
- Louisiana 337
- Wisconsin 335
- Kentucky 332
- North Dakota 329
- New Mexico 328
- Oklahoma 326
- West Virginia 317
- Kansas 305
- Minnesota 297
- South Dakota 293
- Nebraska 160
fips 15
county 1
- Grant · 4,727 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
1041873 | 1041873 | 2021-02-18 | Grant | Minnesota | 27051 | 480 | 8 |
1042228 | 1042228 | 2021-02-18 | Grant | Nebraska | 31075 | 35 | 3 |
1042343 | 1042343 | 2021-02-18 | Grant | New Mexico | 35017 | 1442 | 34 |
1042543 | 1042543 | 2021-02-18 | Grant | North Dakota | 38037 | 184 | 7 |
1042695 | 1042695 | 2021-02-18 | Grant | Oklahoma | 40053 | 525 | 7 |
1042758 | 1042758 | 2021-02-18 | Grant | Oregon | 41023 | 221 | 1 |
1043005 | 1043005 | 2021-02-18 | Grant | South Dakota | 46051 | 948 | 37 |
1043590 | 1043590 | 2021-02-18 | Grant | Washington | 53025 | 8762 | 108 |
1043628 | 1043628 | 2021-02-18 | Grant | West Virginia | 54023 | 1043 | 25 |
1043693 | 1043693 | 2021-02-18 | Grant | Wisconsin | 55043 | 5283 | 84 |
1037413 | 1037413 | 2021-02-17 | Grant | Arkansas | 5053 | 1536 | 32 |
1038006 | 1038006 | 2021-02-17 | Grant | Indiana | 18053 | 6773 | 161 |
1038205 | 1038205 | 2021-02-17 | Grant | Kansas | 20067 | 963 | 17 |
1038318 | 1038318 | 2021-02-17 | Grant | Kentucky | 21081 | 2100 | 12 |
1038419 | 1038419 | 2021-02-17 | Grant | Louisiana | 22043 | 1972 | 51 |
1038628 | 1038628 | 2021-02-17 | Grant | Minnesota | 27051 | 479 | 8 |
1038983 | 1038983 | 2021-02-17 | Grant | Nebraska | 31075 | 35 | 3 |
1039098 | 1039098 | 2021-02-17 | Grant | New Mexico | 35017 | 1438 | 33 |
1039298 | 1039298 | 2021-02-17 | Grant | North Dakota | 38037 | 184 | 7 |
1039450 | 1039450 | 2021-02-17 | Grant | Oklahoma | 40053 | 524 | 7 |
1039513 | 1039513 | 2021-02-17 | Grant | Oregon | 41023 | 221 | 1 |
1039760 | 1039760 | 2021-02-17 | Grant | South Dakota | 46051 | 948 | 37 |
1040345 | 1040345 | 2021-02-17 | Grant | Washington | 53025 | 8729 | 108 |
1040383 | 1040383 | 2021-02-17 | Grant | West Virginia | 54023 | 1041 | 25 |
1040448 | 1040448 | 2021-02-17 | Grant | Wisconsin | 55043 | 5281 | 84 |
1034168 | 1034168 | 2021-02-16 | Grant | Arkansas | 5053 | 1533 | 32 |
1034761 | 1034761 | 2021-02-16 | Grant | Indiana | 18053 | 6771 | 161 |
1034960 | 1034960 | 2021-02-16 | Grant | Kansas | 20067 | 962 | 17 |
1035073 | 1035073 | 2021-02-16 | Grant | Kentucky | 21081 | 2094 | 12 |
1035174 | 1035174 | 2021-02-16 | Grant | Louisiana | 22043 | 1976 | 48 |
1035383 | 1035383 | 2021-02-16 | Grant | Minnesota | 27051 | 468 | 8 |
1035738 | 1035738 | 2021-02-16 | Grant | Nebraska | 31075 | 34 | 3 |
1035853 | 1035853 | 2021-02-16 | Grant | New Mexico | 35017 | 1435 | 33 |
1036053 | 1036053 | 2021-02-16 | Grant | North Dakota | 38037 | 183 | 7 |
1036205 | 1036205 | 2021-02-16 | Grant | Oklahoma | 40053 | 524 | 7 |
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);