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 301
- Arkansas 294
- Indiana 293
- Oregon 293
- Louisiana 290
- Wisconsin 289
- Kentucky 285
- North Dakota 282
- New Mexico 281
- Oklahoma 279
- West Virginia 271
- Kansas 258
- Minnesota 250
- South Dakota 247
- Nebraska 113
fips 15
county 1
- Grant · 4,026 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
903450 | 903450 | 2021-01-06 | Grant | South Dakota | 46051 | 841 | 35 |
904035 | 904035 | 2021-01-06 | Grant | Washington | 53025 | 7172 | 82 |
904073 | 904073 | 2021-01-06 | Grant | West Virginia | 54023 | 826 | 18 |
904138 | 904138 | 2021-01-06 | Grant | Wisconsin | 55043 | 4669 | 82 |
897858 | 897858 | 2021-01-05 | Grant | Arkansas | 5053 | 1139 | 12 |
898450 | 898450 | 2021-01-05 | Grant | Indiana | 18053 | 5648 | 106 |
898649 | 898649 | 2021-01-05 | Grant | Kansas | 20067 | 916 | 14 |
898762 | 898762 | 2021-01-05 | Grant | Kentucky | 21081 | 1376 | 10 |
898863 | 898863 | 2021-01-05 | Grant | Louisiana | 22043 | 1539 | 40 |
899073 | 899073 | 2021-01-05 | Grant | Minnesota | 27051 | 409 | 7 |
899428 | 899428 | 2021-01-05 | Grant | Nebraska | 31075 | 23 | 3 |
899543 | 899543 | 2021-01-05 | Grant | New Mexico | 35017 | 974 | 15 |
899743 | 899743 | 2021-01-05 | Grant | North Dakota | 38037 | 173 | 7 |
899895 | 899895 | 2021-01-05 | Grant | Oklahoma | 40053 | 408 | 5 |
899958 | 899958 | 2021-01-05 | Grant | Oregon | 41023 | 170 | 1 |
900205 | 900205 | 2021-01-05 | Grant | South Dakota | 46051 | 835 | 35 |
900790 | 900790 | 2021-01-05 | Grant | Washington | 53025 | 7124 | 82 |
900828 | 900828 | 2021-01-05 | Grant | West Virginia | 54023 | 822 | 18 |
900893 | 900893 | 2021-01-05 | Grant | Wisconsin | 55043 | 4620 | 82 |
894613 | 894613 | 2021-01-04 | Grant | Arkansas | 5053 | 1124 | 12 |
895205 | 895205 | 2021-01-04 | Grant | Indiana | 18053 | 5582 | 106 |
895404 | 895404 | 2021-01-04 | Grant | Kansas | 20067 | 915 | 14 |
895517 | 895517 | 2021-01-04 | Grant | Kentucky | 21081 | 1362 | 10 |
895618 | 895618 | 2021-01-04 | Grant | Louisiana | 22043 | 1528 | 40 |
895828 | 895828 | 2021-01-04 | Grant | Minnesota | 27051 | 403 | 7 |
896183 | 896183 | 2021-01-04 | Grant | Nebraska | 31075 | 23 | 3 |
896298 | 896298 | 2021-01-04 | Grant | New Mexico | 35017 | 964 | 15 |
896498 | 896498 | 2021-01-04 | Grant | North Dakota | 38037 | 173 | 7 |
896650 | 896650 | 2021-01-04 | Grant | Oklahoma | 40053 | 405 | 5 |
896713 | 896713 | 2021-01-04 | Grant | Oregon | 41023 | 170 | 1 |
896960 | 896960 | 2021-01-04 | Grant | South Dakota | 46051 | 830 | 35 |
897545 | 897545 | 2021-01-04 | Grant | Washington | 53025 | 7071 | 82 |
897583 | 897583 | 2021-01-04 | Grant | West Virginia | 54023 | 807 | 18 |
897648 | 897648 | 2021-01-04 | Grant | Wisconsin | 55043 | 4596 | 82 |
891366 | 891366 | 2021-01-03 | Grant | Arkansas | 5053 | 1117 | 12 |
891958 | 891958 | 2021-01-03 | Grant | Indiana | 18053 | 5558 | 106 |
892157 | 892157 | 2021-01-03 | Grant | Kansas | 20067 | 912 | 14 |
892270 | 892270 | 2021-01-03 | Grant | Kentucky | 21081 | 1289 | 8 |
892371 | 892371 | 2021-01-03 | Grant | Louisiana | 22043 | 1521 | 40 |
892581 | 892581 | 2021-01-03 | Grant | Minnesota | 27051 | 394 | 7 |
892936 | 892936 | 2021-01-03 | Grant | Nebraska | 31075 | 23 | 3 |
893051 | 893051 | 2021-01-03 | Grant | New Mexico | 35017 | 961 | 15 |
893252 | 893252 | 2021-01-03 | Grant | North Dakota | 38037 | 172 | 7 |
893404 | 893404 | 2021-01-03 | Grant | Oklahoma | 40053 | 402 | 5 |
893467 | 893467 | 2021-01-03 | Grant | Oregon | 41023 | 170 | 1 |
893714 | 893714 | 2021-01-03 | Grant | South Dakota | 46051 | 829 | 35 |
894299 | 894299 | 2021-01-03 | Grant | Washington | 53025 | 6923 | 82 |
894337 | 894337 | 2021-01-03 | Grant | West Virginia | 54023 | 803 | 17 |
894402 | 894402 | 2021-01-03 | Grant | Wisconsin | 55043 | 4583 | 82 |
888119 | 888119 | 2021-01-02 | Grant | Arkansas | 5053 | 1109 | 12 |
888712 | 888712 | 2021-01-02 | Grant | Indiana | 18053 | 5496 | 105 |
888911 | 888911 | 2021-01-02 | Grant | Kansas | 20067 | 912 | 14 |
889024 | 889024 | 2021-01-02 | Grant | Kentucky | 21081 | 1289 | 8 |
889125 | 889125 | 2021-01-02 | Grant | Louisiana | 22043 | 1501 | 40 |
889335 | 889335 | 2021-01-02 | Grant | Minnesota | 27051 | 393 | 7 |
889690 | 889690 | 2021-01-02 | Grant | Nebraska | 31075 | 23 | 3 |
889805 | 889805 | 2021-01-02 | Grant | New Mexico | 35017 | 941 | 15 |
890006 | 890006 | 2021-01-02 | Grant | North Dakota | 38037 | 172 | 7 |
890158 | 890158 | 2021-01-02 | Grant | Oklahoma | 40053 | 386 | 5 |
890221 | 890221 | 2021-01-02 | Grant | Oregon | 41023 | 170 | 1 |
890468 | 890468 | 2021-01-02 | Grant | South Dakota | 46051 | 826 | 35 |
891053 | 891053 | 2021-01-02 | Grant | Washington | 53025 | 6923 | 82 |
891091 | 891091 | 2021-01-02 | Grant | West Virginia | 54023 | 784 | 17 |
891156 | 891156 | 2021-01-02 | Grant | Wisconsin | 55043 | 4572 | 82 |
884874 | 884874 | 2021-01-01 | Grant | Arkansas | 5053 | 1101 | 12 |
885466 | 885466 | 2021-01-01 | Grant | Indiana | 18053 | 5462 | 105 |
885665 | 885665 | 2021-01-01 | Grant | Kansas | 20067 | 912 | 14 |
885778 | 885778 | 2021-01-01 | Grant | Kentucky | 21081 | 1289 | 8 |
885879 | 885879 | 2021-01-01 | Grant | Louisiana | 22043 | 1501 | 40 |
886089 | 886089 | 2021-01-01 | Grant | Minnesota | 27051 | 390 | 7 |
886444 | 886444 | 2021-01-01 | Grant | Nebraska | 31075 | 23 | 3 |
886559 | 886559 | 2021-01-01 | Grant | New Mexico | 35017 | 921 | 15 |
886759 | 886759 | 2021-01-01 | Grant | North Dakota | 38037 | 172 | 7 |
886911 | 886911 | 2021-01-01 | Grant | Oklahoma | 40053 | 380 | 5 |
886974 | 886974 | 2021-01-01 | Grant | Oregon | 41023 | 170 | 1 |
887221 | 887221 | 2021-01-01 | Grant | South Dakota | 46051 | 826 | 35 |
887806 | 887806 | 2021-01-01 | Grant | Washington | 53025 | 6923 | 82 |
887844 | 887844 | 2021-01-01 | Grant | West Virginia | 54023 | 776 | 17 |
887909 | 887909 | 2021-01-01 | Grant | Wisconsin | 55043 | 4557 | 82 |
881629 | 881629 | 2020-12-31 | Grant | Arkansas | 5053 | 1071 | 12 |
882221 | 882221 | 2020-12-31 | Grant | Indiana | 18053 | 5404 | 102 |
882420 | 882420 | 2020-12-31 | Grant | Kansas | 20067 | 912 | 14 |
882533 | 882533 | 2020-12-31 | Grant | Kentucky | 21081 | 1289 | 8 |
882634 | 882634 | 2020-12-31 | Grant | Louisiana | 22043 | 1501 | 40 |
882844 | 882844 | 2020-12-31 | Grant | Minnesota | 27051 | 390 | 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);