ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

4,127 rows where county = "Grant" sorted by date descending

✎ View and edit SQL

This data as json, yaml, copyable, CSV (advanced)

Suggested facets: date (date)

fips

county

  • Grant · 4,127 ✖
Link rowid date ▲ county state fips cases deaths
923899 923899 2021-01-13 Grant Arkansas 5053 1232 21
924491 924491 2021-01-13 Grant Indiana 18053 6070 113
924690 924690 2021-01-13 Grant Kansas 20067 935 15
924803 924803 2021-01-13 Grant Kentucky 21081 1519 10
924904 924904 2021-01-13 Grant Louisiana 22043 1691 41
925114 925114 2021-01-13 Grant Minnesota 27051 422 7
925469 925469 2021-01-13 Grant Nebraska 31075 23 4
925584 925584 2021-01-13 Grant New Mexico 35017 1126 21
925785 925785 2021-01-13 Grant North Dakota 38037 178 7
925937 925937 2021-01-13 Grant Oklahoma 40053 443 5
926000 926000 2021-01-13 Grant Oregon 41023 182 1
926247 926247 2021-01-13 Grant South Dakota 46051 857 35
926832 926832 2021-01-13 Grant Washington 53025 7540 90
926870 926870 2021-01-13 Grant West Virginia 54023 896 19
926935 926935 2021-01-13 Grant Wisconsin 55043 4821 82
920654 920654 2021-01-12 Grant Arkansas 5053 1219 19
921246 921246 2021-01-12 Grant Indiana 18053 6036 113
921445 921445 2021-01-12 Grant Kansas 20067 933 15
921558 921558 2021-01-12 Grant Kentucky 21081 1486 10
921659 921659 2021-01-12 Grant Louisiana 22043 1689 41
921869 921869 2021-01-12 Grant Minnesota 27051 423 7
922224 922224 2021-01-12 Grant Nebraska 31075 23 4
922339 922339 2021-01-12 Grant New Mexico 35017 1115 20
922539 922539 2021-01-12 Grant North Dakota 38037 178 7
922691 922691 2021-01-12 Grant Oklahoma 40053 439 5
922754 922754 2021-01-12 Grant Oregon 41023 174 1
923001 923001 2021-01-12 Grant South Dakota 46051 851 35
923586 923586 2021-01-12 Grant Washington 53025 7529 90
923624 923624 2021-01-12 Grant West Virginia 54023 882 19
923689 923689 2021-01-12 Grant Wisconsin 55043 4797 82
917409 917409 2021-01-11 Grant Arkansas 5053 1200 19
918001 918001 2021-01-11 Grant Indiana 18053 6001 113
918200 918200 2021-01-11 Grant Kansas 20067 927 14
918313 918313 2021-01-11 Grant Kentucky 21081 1472 10
918414 918414 2021-01-11 Grant Louisiana 22043 1673 41
918624 918624 2021-01-11 Grant Minnesota 27051 423 7
918979 918979 2021-01-11 Grant Nebraska 31075 23 4
919094 919094 2021-01-11 Grant New Mexico 35017 1107 20
919294 919294 2021-01-11 Grant North Dakota 38037 178 7
919446 919446 2021-01-11 Grant Oklahoma 40053 436 5
919509 919509 2021-01-11 Grant Oregon 41023 174 1
919756 919756 2021-01-11 Grant South Dakota 46051 849 35
920341 920341 2021-01-11 Grant Washington 53025 7486 90
920379 920379 2021-01-11 Grant West Virginia 54023 879 18
920444 920444 2021-01-11 Grant Wisconsin 55043 4775 83
914164 914164 2021-01-10 Grant Arkansas 5053 1195 16
914756 914756 2021-01-10 Grant Indiana 18053 5962 113
914955 914955 2021-01-10 Grant Kansas 20067 927 14
915068 915068 2021-01-10 Grant Kentucky 21081 1460 10
915169 915169 2021-01-10 Grant Louisiana 22043 1663 41
915379 915379 2021-01-10 Grant Minnesota 27051 422 7
915734 915734 2021-01-10 Grant Nebraska 31075 23 3
915849 915849 2021-01-10 Grant New Mexico 35017 1094 18
916049 916049 2021-01-10 Grant North Dakota 38037 178 7
916201 916201 2021-01-10 Grant Oklahoma 40053 432 5
916264 916264 2021-01-10 Grant Oregon 41023 174 1
916511 916511 2021-01-10 Grant South Dakota 46051 849 35
917096 917096 2021-01-10 Grant Washington 53025 7303 90
917134 917134 2021-01-10 Grant West Virginia 54023 877 18
917199 917199 2021-01-10 Grant Wisconsin 55043 4771 83
910919 910919 2021-01-09 Grant Arkansas 5053 1189 15
911511 911511 2021-01-09 Grant Indiana 18053 5920 113
911710 911710 2021-01-09 Grant Kansas 20067 927 14
911823 911823 2021-01-09 Grant Kentucky 21081 1442 10
911924 911924 2021-01-09 Grant Louisiana 22043 1651 41
912134 912134 2021-01-09 Grant Minnesota 27051 417 7
912489 912489 2021-01-09 Grant Nebraska 31075 23 3
912604 912604 2021-01-09 Grant New Mexico 35017 1070 17
912804 912804 2021-01-09 Grant North Dakota 38037 178 7
912956 912956 2021-01-09 Grant Oklahoma 40053 423 5
913019 913019 2021-01-09 Grant Oregon 41023 174 1
913266 913266 2021-01-09 Grant South Dakota 46051 848 35
913851 913851 2021-01-09 Grant Washington 53025 7303 90
913889 913889 2021-01-09 Grant West Virginia 54023 868 18
913954 913954 2021-01-09 Grant Wisconsin 55043 4753 82
907674 907674 2021-01-08 Grant Arkansas 5053 1176 15
908266 908266 2021-01-08 Grant Indiana 18053 5864 111
908465 908465 2021-01-08 Grant Kansas 20067 923 14
908578 908578 2021-01-08 Grant Kentucky 21081 1425 10
908679 908679 2021-01-08 Grant Louisiana 22043 1651 41
908889 908889 2021-01-08 Grant Minnesota 27051 414 7
909244 909244 2021-01-08 Grant Nebraska 31075 23 3
909359 909359 2021-01-08 Grant New Mexico 35017 1050 16
909559 909559 2021-01-08 Grant North Dakota 38037 178 7
909711 909711 2021-01-08 Grant Oklahoma 40053 416 5
909774 909774 2021-01-08 Grant Oregon 41023 174 1
910021 910021 2021-01-08 Grant South Dakota 46051 846 35
910606 910606 2021-01-08 Grant Washington 53025 7303 90
910644 910644 2021-01-08 Grant West Virginia 54023 851 18
910709 910709 2021-01-08 Grant Wisconsin 55043 4733 82
904428 904428 2021-01-07 Grant Arkansas 5053 1162 15
905020 905020 2021-01-07 Grant Indiana 18053 5789 108
905219 905219 2021-01-07 Grant Kansas 20067 920 14
905332 905332 2021-01-07 Grant Kentucky 21081 1415 10
905433 905433 2021-01-07 Grant Louisiana 22043 1631 41
905643 905643 2021-01-07 Grant Minnesota 27051 412 7
905998 905998 2021-01-07 Grant Nebraska 31075 23 3
906113 906113 2021-01-07 Grant New Mexico 35017 1030 16
906314 906314 2021-01-07 Grant North Dakota 38037 175 7
906466 906466 2021-01-07 Grant Oklahoma 40053 412 5

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);