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,862 rows where county = "Grant" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips

county

  • Grant · 4,862 ✖
Link rowid date ▲ county state fips cases deaths
1082852 1082852 2021-03-03 Grant Arkansas 5053 1587 32
1083445 1083445 2021-03-03 Grant Indiana 18053 6854 165
1083644 1083644 2021-03-03 Grant Kansas 20067 966 17
1083757 1083757 2021-03-03 Grant Kentucky 21081 2229 14
1083858 1083858 2021-03-03 Grant Louisiana 22043 2016 52
1084068 1084068 2021-03-03 Grant Minnesota 27051 491 8
1084423 1084423 2021-03-03 Grant Nebraska 31075 37 4
1084538 1084538 2021-03-03 Grant New Mexico 35017 1505 35
1084738 1084738 2021-03-03 Grant North Dakota 38037 184 7
1084890 1084890 2021-03-03 Grant Oklahoma 40053 536 7
1084953 1084953 2021-03-03 Grant Oregon 41023 225 1
1085200 1085200 2021-03-03 Grant South Dakota 46051 979 38
1085785 1085785 2021-03-03 Grant Washington 53025 8975 114
1085823 1085823 2021-03-03 Grant West Virginia 54023 1073 26
1085888 1085888 2021-03-03 Grant Wisconsin 55043 5352 86
1079606 1079606 2021-03-02 Grant Arkansas 5053 1586 31
1080199 1080199 2021-03-02 Grant Indiana 18053 6847 164
1080398 1080398 2021-03-02 Grant Kansas 20067 966 17
1080511 1080511 2021-03-02 Grant Kentucky 21081 2212 13
1080612 1080612 2021-03-02 Grant Louisiana 22043 2020 52
1080822 1080822 2021-03-02 Grant Minnesota 27051 491 8
1081177 1081177 2021-03-02 Grant Nebraska 31075 36 4
1081292 1081292 2021-03-02 Grant New Mexico 35017 1499 35
1081492 1081492 2021-03-02 Grant North Dakota 38037 184 7
1081644 1081644 2021-03-02 Grant Oklahoma 40053 535 7
1081707 1081707 2021-03-02 Grant Oregon 41023 223 1
1081954 1081954 2021-03-02 Grant South Dakota 46051 976 38
1082539 1082539 2021-03-02 Grant Washington 53025 8963 114
1082577 1082577 2021-03-02 Grant West Virginia 54023 1071 26
1082642 1082642 2021-03-02 Grant Wisconsin 55043 5344 85
1076361 1076361 2021-03-01 Grant Arkansas 5053 1582 31
1076954 1076954 2021-03-01 Grant Indiana 18053 6842 164
1077153 1077153 2021-03-01 Grant Kansas 20067 966 17
1077266 1077266 2021-03-01 Grant Kentucky 21081 2205 13
1077367 1077367 2021-03-01 Grant Louisiana 22043 2016 52
1077576 1077576 2021-03-01 Grant Minnesota 27051 491 8
1077931 1077931 2021-03-01 Grant Nebraska 31075 36 4
1078046 1078046 2021-03-01 Grant New Mexico 35017 1496 34
1078246 1078246 2021-03-01 Grant North Dakota 38037 184 7
1078398 1078398 2021-03-01 Grant Oklahoma 40053 535 7
1078461 1078461 2021-03-01 Grant Oregon 41023 223 1
1078708 1078708 2021-03-01 Grant South Dakota 46051 974 38
1079293 1079293 2021-03-01 Grant Washington 53025 8953 114
1079331 1079331 2021-03-01 Grant West Virginia 54023 1069 26
1079396 1079396 2021-03-01 Grant Wisconsin 55043 5341 85
1073115 1073115 2021-02-28 Grant Arkansas 5053 1580 31
1073708 1073708 2021-02-28 Grant Indiana 18053 6839 164
1073907 1073907 2021-02-28 Grant Kansas 20067 966 17
1074020 1074020 2021-02-28 Grant Kentucky 21081 2203 13
1074121 1074121 2021-02-28 Grant Louisiana 22043 2013 52
1074330 1074330 2021-02-28 Grant Minnesota 27051 491 8
1074685 1074685 2021-02-28 Grant Nebraska 31075 36 4
1074800 1074800 2021-02-28 Grant New Mexico 35017 1492 34
1075001 1075001 2021-02-28 Grant North Dakota 38037 184 7
1075153 1075153 2021-02-28 Grant Oklahoma 40053 535 7
1075216 1075216 2021-02-28 Grant Oregon 41023 223 1
1075463 1075463 2021-02-28 Grant South Dakota 46051 974 38
1076048 1076048 2021-02-28 Grant Washington 53025 8916 114
1076086 1076086 2021-02-28 Grant West Virginia 54023 1068 26
1076151 1076151 2021-02-28 Grant Wisconsin 55043 5338 85
1069869 1069869 2021-02-27 Grant Arkansas 5053 1562 32
1070462 1070462 2021-02-27 Grant Indiana 18053 6837 164
1070661 1070661 2021-02-27 Grant Kansas 20067 966 17
1070774 1070774 2021-02-27 Grant Kentucky 21081 2199 13
1070875 1070875 2021-02-27 Grant Louisiana 22043 2014 52
1071084 1071084 2021-02-27 Grant Minnesota 27051 490 8
1071439 1071439 2021-02-27 Grant Nebraska 31075 36 4
1071554 1071554 2021-02-27 Grant New Mexico 35017 1488 34
1071755 1071755 2021-02-27 Grant North Dakota 38037 184 7
1071907 1071907 2021-02-27 Grant Oklahoma 40053 534 7
1071970 1071970 2021-02-27 Grant Oregon 41023 222 1
1072217 1072217 2021-02-27 Grant South Dakota 46051 973 38
1072802 1072802 2021-02-27 Grant Washington 53025 8916 114
1072840 1072840 2021-02-27 Grant West Virginia 54023 1067 26
1072905 1072905 2021-02-27 Grant Wisconsin 55043 5335 85
1066624 1066624 2021-02-26 Grant Arkansas 5053 1559 32
1067217 1067217 2021-02-26 Grant Indiana 18053 6828 164
1067416 1067416 2021-02-26 Grant Kansas 20067 966 17
1067529 1067529 2021-02-26 Grant Kentucky 21081 2192 13
1067630 1067630 2021-02-26 Grant Louisiana 22043 2014 52
1067839 1067839 2021-02-26 Grant Minnesota 27051 489 8
1068194 1068194 2021-02-26 Grant Nebraska 31075 36 4
1068309 1068309 2021-02-26 Grant New Mexico 35017 1482 34
1068509 1068509 2021-02-26 Grant North Dakota 38037 184 7
1068661 1068661 2021-02-26 Grant Oklahoma 40053 534 7
1068724 1068724 2021-02-26 Grant Oregon 41023 222 1
1068971 1068971 2021-02-26 Grant South Dakota 46051 969 38
1069556 1069556 2021-02-26 Grant Washington 53025 8916 114
1069594 1069594 2021-02-26 Grant West Virginia 54023 1062 26
1069659 1069659 2021-02-26 Grant Wisconsin 55043 5329 85
1063379 1063379 2021-02-25 Grant Arkansas 5053 1555 32
1063972 1063972 2021-02-25 Grant Indiana 18053 6826 164
1064171 1064171 2021-02-25 Grant Kansas 20067 966 17
1064284 1064284 2021-02-25 Grant Kentucky 21081 2172 13
1064385 1064385 2021-02-25 Grant Louisiana 22043 2009 52
1064594 1064594 2021-02-25 Grant Minnesota 27051 489 8
1064949 1064949 2021-02-25 Grant Nebraska 31075 35 4
1065064 1065064 2021-02-25 Grant New Mexico 35017 1474 34
1065264 1065264 2021-02-25 Grant North Dakota 38037 184 7
1065416 1065416 2021-02-25 Grant Oklahoma 40053 534 7

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]);
CREATE INDEX [idx_ny_times_us_counties_date]
    ON [ny_times_us_counties] ([date]);