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 306
- Arkansas 299
- Indiana 299
- Oregon 299
- Louisiana 296
- Wisconsin 294
- Kentucky 291
- North Dakota 288
- New Mexico 287
- Oklahoma 285
- West Virginia 276
- Kansas 264
- Minnesota 256
- South Dakota 252
- Nebraska 119
fips 15
county 1
- Grant · 4,111 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921166 | 921166 | 2021-01-12 | Grant | Indiana | 18053 | 6036 | 113 |
921365 | 921365 | 2021-01-12 | Grant | Kansas | 20067 | 933 | 15 |
921478 | 921478 | 2021-01-12 | Grant | Kentucky | 21081 | 1486 | 10 |
921579 | 921579 | 2021-01-12 | Grant | Louisiana | 22043 | 1689 | 41 |
921789 | 921789 | 2021-01-12 | Grant | Minnesota | 27051 | 423 | 7 |
922144 | 922144 | 2021-01-12 | Grant | Nebraska | 31075 | 23 | 4 |
922259 | 922259 | 2021-01-12 | Grant | New Mexico | 35017 | 1115 | 20 |
922459 | 922459 | 2021-01-12 | Grant | North Dakota | 38037 | 178 | 7 |
922611 | 922611 | 2021-01-12 | Grant | Oklahoma | 40053 | 439 | 5 |
922674 | 922674 | 2021-01-12 | Grant | Oregon | 41023 | 174 | 1 |
922921 | 922921 | 2021-01-12 | Grant | South Dakota | 46051 | 851 | 35 |
923506 | 923506 | 2021-01-12 | Grant | Washington | 53025 | 7529 | 90 |
923544 | 923544 | 2021-01-12 | Grant | West Virginia | 54023 | 882 | 19 |
923609 | 923609 | 2021-01-12 | Grant | Wisconsin | 55043 | 4797 | 82 |
917329 | 917329 | 2021-01-11 | Grant | Arkansas | 5053 | 1200 | 19 |
917921 | 917921 | 2021-01-11 | Grant | Indiana | 18053 | 6001 | 113 |
918120 | 918120 | 2021-01-11 | Grant | Kansas | 20067 | 927 | 14 |
918233 | 918233 | 2021-01-11 | Grant | Kentucky | 21081 | 1472 | 10 |
918334 | 918334 | 2021-01-11 | Grant | Louisiana | 22043 | 1673 | 41 |
918544 | 918544 | 2021-01-11 | Grant | Minnesota | 27051 | 423 | 7 |
918899 | 918899 | 2021-01-11 | Grant | Nebraska | 31075 | 23 | 4 |
919014 | 919014 | 2021-01-11 | Grant | New Mexico | 35017 | 1107 | 20 |
919214 | 919214 | 2021-01-11 | Grant | North Dakota | 38037 | 178 | 7 |
919366 | 919366 | 2021-01-11 | Grant | Oklahoma | 40053 | 436 | 5 |
919429 | 919429 | 2021-01-11 | Grant | Oregon | 41023 | 174 | 1 |
919676 | 919676 | 2021-01-11 | Grant | South Dakota | 46051 | 849 | 35 |
920261 | 920261 | 2021-01-11 | Grant | Washington | 53025 | 7486 | 90 |
920299 | 920299 | 2021-01-11 | Grant | West Virginia | 54023 | 879 | 18 |
920364 | 920364 | 2021-01-11 | Grant | Wisconsin | 55043 | 4775 | 83 |
914084 | 914084 | 2021-01-10 | Grant | Arkansas | 5053 | 1195 | 16 |
914676 | 914676 | 2021-01-10 | Grant | Indiana | 18053 | 5962 | 113 |
914875 | 914875 | 2021-01-10 | Grant | Kansas | 20067 | 927 | 14 |
914988 | 914988 | 2021-01-10 | Grant | Kentucky | 21081 | 1460 | 10 |
915089 | 915089 | 2021-01-10 | Grant | Louisiana | 22043 | 1663 | 41 |
915299 | 915299 | 2021-01-10 | Grant | Minnesota | 27051 | 422 | 7 |
915654 | 915654 | 2021-01-10 | Grant | Nebraska | 31075 | 23 | 3 |
915769 | 915769 | 2021-01-10 | Grant | New Mexico | 35017 | 1094 | 18 |
915969 | 915969 | 2021-01-10 | Grant | North Dakota | 38037 | 178 | 7 |
916121 | 916121 | 2021-01-10 | Grant | Oklahoma | 40053 | 432 | 5 |
916184 | 916184 | 2021-01-10 | Grant | Oregon | 41023 | 174 | 1 |
916431 | 916431 | 2021-01-10 | Grant | South Dakota | 46051 | 849 | 35 |
917016 | 917016 | 2021-01-10 | Grant | Washington | 53025 | 7303 | 90 |
917054 | 917054 | 2021-01-10 | Grant | West Virginia | 54023 | 877 | 18 |
917119 | 917119 | 2021-01-10 | Grant | Wisconsin | 55043 | 4771 | 83 |
910839 | 910839 | 2021-01-09 | Grant | Arkansas | 5053 | 1189 | 15 |
911431 | 911431 | 2021-01-09 | Grant | Indiana | 18053 | 5920 | 113 |
911630 | 911630 | 2021-01-09 | Grant | Kansas | 20067 | 927 | 14 |
911743 | 911743 | 2021-01-09 | Grant | Kentucky | 21081 | 1442 | 10 |
911844 | 911844 | 2021-01-09 | Grant | Louisiana | 22043 | 1651 | 41 |
912054 | 912054 | 2021-01-09 | Grant | Minnesota | 27051 | 417 | 7 |
912409 | 912409 | 2021-01-09 | Grant | Nebraska | 31075 | 23 | 3 |
912524 | 912524 | 2021-01-09 | Grant | New Mexico | 35017 | 1070 | 17 |
912724 | 912724 | 2021-01-09 | Grant | North Dakota | 38037 | 178 | 7 |
912876 | 912876 | 2021-01-09 | Grant | Oklahoma | 40053 | 423 | 5 |
912939 | 912939 | 2021-01-09 | Grant | Oregon | 41023 | 174 | 1 |
913186 | 913186 | 2021-01-09 | Grant | South Dakota | 46051 | 848 | 35 |
913771 | 913771 | 2021-01-09 | Grant | Washington | 53025 | 7303 | 90 |
913809 | 913809 | 2021-01-09 | Grant | West Virginia | 54023 | 868 | 18 |
913874 | 913874 | 2021-01-09 | Grant | Wisconsin | 55043 | 4753 | 82 |
907594 | 907594 | 2021-01-08 | Grant | Arkansas | 5053 | 1176 | 15 |
908186 | 908186 | 2021-01-08 | Grant | Indiana | 18053 | 5864 | 111 |
908385 | 908385 | 2021-01-08 | Grant | Kansas | 20067 | 923 | 14 |
908498 | 908498 | 2021-01-08 | Grant | Kentucky | 21081 | 1425 | 10 |
908599 | 908599 | 2021-01-08 | Grant | Louisiana | 22043 | 1651 | 41 |
908809 | 908809 | 2021-01-08 | Grant | Minnesota | 27051 | 414 | 7 |
909164 | 909164 | 2021-01-08 | Grant | Nebraska | 31075 | 23 | 3 |
909279 | 909279 | 2021-01-08 | Grant | New Mexico | 35017 | 1050 | 16 |
909479 | 909479 | 2021-01-08 | Grant | North Dakota | 38037 | 178 | 7 |
909631 | 909631 | 2021-01-08 | Grant | Oklahoma | 40053 | 416 | 5 |
909694 | 909694 | 2021-01-08 | Grant | Oregon | 41023 | 174 | 1 |
909941 | 909941 | 2021-01-08 | Grant | South Dakota | 46051 | 846 | 35 |
910526 | 910526 | 2021-01-08 | Grant | Washington | 53025 | 7303 | 90 |
910564 | 910564 | 2021-01-08 | Grant | West Virginia | 54023 | 851 | 18 |
910629 | 910629 | 2021-01-08 | Grant | Wisconsin | 55043 | 4733 | 82 |
904348 | 904348 | 2021-01-07 | Grant | Arkansas | 5053 | 1162 | 15 |
904940 | 904940 | 2021-01-07 | Grant | Indiana | 18053 | 5789 | 108 |
905139 | 905139 | 2021-01-07 | Grant | Kansas | 20067 | 920 | 14 |
905252 | 905252 | 2021-01-07 | Grant | Kentucky | 21081 | 1415 | 10 |
905353 | 905353 | 2021-01-07 | Grant | Louisiana | 22043 | 1631 | 41 |
905563 | 905563 | 2021-01-07 | Grant | Minnesota | 27051 | 412 | 7 |
905918 | 905918 | 2021-01-07 | Grant | Nebraska | 31075 | 23 | 3 |
906033 | 906033 | 2021-01-07 | Grant | New Mexico | 35017 | 1030 | 16 |
906234 | 906234 | 2021-01-07 | Grant | North Dakota | 38037 | 175 | 7 |
906386 | 906386 | 2021-01-07 | Grant | Oklahoma | 40053 | 412 | 5 |
906449 | 906449 | 2021-01-07 | Grant | Oregon | 41023 | 174 | 1 |
906696 | 906696 | 2021-01-07 | Grant | South Dakota | 46051 | 842 | 35 |
907281 | 907281 | 2021-01-07 | Grant | Washington | 53025 | 7226 | 90 |
907319 | 907319 | 2021-01-07 | Grant | West Virginia | 54023 | 835 | 18 |
907384 | 907384 | 2021-01-07 | Grant | Wisconsin | 55043 | 4711 | 82 |
901103 | 901103 | 2021-01-06 | Grant | Arkansas | 5053 | 1155 | 14 |
901695 | 901695 | 2021-01-06 | Grant | Indiana | 18053 | 5707 | 108 |
901894 | 901894 | 2021-01-06 | Grant | Kansas | 20067 | 920 | 14 |
902007 | 902007 | 2021-01-06 | Grant | Kentucky | 21081 | 1398 | 10 |
902108 | 902108 | 2021-01-06 | Grant | Louisiana | 22043 | 1614 | 40 |
902318 | 902318 | 2021-01-06 | Grant | Minnesota | 27051 | 408 | 7 |
902673 | 902673 | 2021-01-06 | Grant | Nebraska | 31075 | 23 | 3 |
902788 | 902788 | 2021-01-06 | Grant | New Mexico | 35017 | 997 | 15 |
902988 | 902988 | 2021-01-06 | Grant | North Dakota | 38037 | 174 | 7 |
903140 | 903140 | 2021-01-06 | Grant | Oklahoma | 40053 | 409 | 5 |
903203 | 903203 | 2021-01-06 | Grant | Oregon | 41023 | 171 | 1 |
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);