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

8,372 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 · 8,372 ✖
Link rowid date ▲ county state fips cases deaths
1842744 1842744 2021-10-23 Grant Arkansas 5053 2870 48
1843338 1843338 2021-10-23 Grant Indiana 18053 10489 228
1843537 1843537 2021-10-23 Grant Kansas 20067 1244 27
1843649 1843649 2021-10-23 Grant Kentucky 21081 4316 38
1843750 1843750 2021-10-23 Grant Louisiana 22043 3814 77
1843960 1843960 2021-10-23 Grant Minnesota 27051 786 9
1844315 1844315 2021-10-23 Grant Nebraska 31075 74 4
1844431 1844431 2021-10-23 Grant New Mexico 35017 2434 49
1844631 1844631 2021-10-23 Grant North Dakota 38037 320 7
1844784 1844784 2021-10-23 Grant Oklahoma 40053 692 8
1844847 1844847 2021-10-23 Grant Oregon 41023 1000 13
1845094 1845094 2021-10-23 Grant South Dakota 46051 1324 44
1845679 1845679 2021-10-23 Grant Washington 53025 16950 184
1845717 1845717 2021-10-23 Grant West Virginia 54023 2130 33
1845782 1845782 2021-10-23 Grant Wisconsin 55043 7536 116
1839494 1839494 2021-10-22 Grant Arkansas 5053 2869 48
1840088 1840088 2021-10-22 Grant Indiana 18053 10489 228
1840287 1840287 2021-10-22 Grant Kansas 20067 1244 27
1840399 1840399 2021-10-22 Grant Kentucky 21081 4316 38
1840500 1840500 2021-10-22 Grant Louisiana 22043 3814 77
1840710 1840710 2021-10-22 Grant Minnesota 27051 786 9
1841065 1841065 2021-10-22 Grant Nebraska 31075 74 4
1841181 1841181 2021-10-22 Grant New Mexico 35017 2434 49
1841381 1841381 2021-10-22 Grant North Dakota 38037 319 7
1841534 1841534 2021-10-22 Grant Oklahoma 40053 692 8
1841597 1841597 2021-10-22 Grant Oregon 41023 1000 13
1841844 1841844 2021-10-22 Grant South Dakota 46051 1324 44
1842429 1842429 2021-10-22 Grant Washington 53025 16950 184
1842467 1842467 2021-10-22 Grant West Virginia 54023 2124 33
1842532 1842532 2021-10-22 Grant Wisconsin 55043 7536 116
1836245 1836245 2021-10-21 Grant Arkansas 5053 2869 48
1836839 1836839 2021-10-21 Grant Indiana 18053 10458 228
1837038 1837038 2021-10-21 Grant Kansas 20067 1244 27
1837150 1837150 2021-10-21 Grant Kentucky 21081 4297 38
1837251 1837251 2021-10-21 Grant Louisiana 22043 3810 77
1837461 1837461 2021-10-21 Grant Minnesota 27051 781 9
1837816 1837816 2021-10-21 Grant Nebraska 31075 74 4
1837932 1837932 2021-10-21 Grant New Mexico 35017 2393 49
1838132 1838132 2021-10-21 Grant North Dakota 38037 316 7
1838285 1838285 2021-10-21 Grant Oklahoma 40053 692 8
1838348 1838348 2021-10-21 Grant Oregon 41023 1000 13
1838595 1838595 2021-10-21 Grant South Dakota 46051 1321 44
1839180 1839180 2021-10-21 Grant Washington 53025 16950 184
1839218 1839218 2021-10-21 Grant West Virginia 54023 2108 33
1839283 1839283 2021-10-21 Grant Wisconsin 55043 7504 114
1832996 1832996 2021-10-20 Grant Arkansas 5053 2867 47
1833590 1833590 2021-10-20 Grant Indiana 18053 10426 227
1833789 1833789 2021-10-20 Grant Kansas 20067 1241 27
1833901 1833901 2021-10-20 Grant Kentucky 21081 4282 38
1834002 1834002 2021-10-20 Grant Louisiana 22043 3808 77
1834212 1834212 2021-10-20 Grant Minnesota 27051 779 9
1834567 1834567 2021-10-20 Grant Nebraska 31075 74 4
1834683 1834683 2021-10-20 Grant New Mexico 35017 2359 49
1834883 1834883 2021-10-20 Grant North Dakota 38037 315 7
1835036 1835036 2021-10-20 Grant Oklahoma 40053 692 8
1835099 1835099 2021-10-20 Grant Oregon 41023 995 13
1835346 1835346 2021-10-20 Grant South Dakota 46051 1317 44
1835931 1835931 2021-10-20 Grant Washington 53025 16902 184
1835969 1835969 2021-10-20 Grant West Virginia 54023 2102 33
1836034 1836034 2021-10-20 Grant Wisconsin 55043 7475 114
1829747 1829747 2021-10-19 Grant Arkansas 5053 2864 47
1830341 1830341 2021-10-19 Grant Indiana 18053 10407 226
1830540 1830540 2021-10-19 Grant Kansas 20067 1238 27
1830652 1830652 2021-10-19 Grant Kentucky 21081 4239 38
1830753 1830753 2021-10-19 Grant Louisiana 22043 3804 77
1830963 1830963 2021-10-19 Grant Minnesota 27051 775 9
1831318 1831318 2021-10-19 Grant Nebraska 31075 69 4
1831434 1831434 2021-10-19 Grant New Mexico 35017 2353 49
1831634 1831634 2021-10-19 Grant North Dakota 38037 313 7
1831787 1831787 2021-10-19 Grant Oklahoma 40053 690 7
1831850 1831850 2021-10-19 Grant Oregon 41023 995 12
1832097 1832097 2021-10-19 Grant South Dakota 46051 1316 44
1832682 1832682 2021-10-19 Grant Washington 53025 16821 184
1832720 1832720 2021-10-19 Grant West Virginia 54023 2093 32
1832785 1832785 2021-10-19 Grant Wisconsin 55043 7453 113
1826498 1826498 2021-10-18 Grant Arkansas 5053 2863 47
1827092 1827092 2021-10-18 Grant Indiana 18053 10371 226
1827291 1827291 2021-10-18 Grant Kansas 20067 1212 27
1827403 1827403 2021-10-18 Grant Kentucky 21081 4212 35
1827504 1827504 2021-10-18 Grant Louisiana 22043 3800 77
1827714 1827714 2021-10-18 Grant Minnesota 27051 768 9
1828069 1828069 2021-10-18 Grant Nebraska 31075 67 4
1828185 1828185 2021-10-18 Grant New Mexico 35017 2344 49
1828385 1828385 2021-10-18 Grant North Dakota 38037 307 7
1828538 1828538 2021-10-18 Grant Oklahoma 40053 690 7
1828601 1828601 2021-10-18 Grant Oregon 41023 980 12
1828848 1828848 2021-10-18 Grant South Dakota 46051 1310 44
1829433 1829433 2021-10-18 Grant Washington 53025 16782 184
1829471 1829471 2021-10-18 Grant West Virginia 54023 2090 32
1829536 1829536 2021-10-18 Grant Wisconsin 55043 7437 112
1823249 1823249 2021-10-17 Grant Arkansas 5053 2863 47
1823843 1823843 2021-10-17 Grant Indiana 18053 10305 225
1824042 1824042 2021-10-17 Grant Kansas 20067 1202 27
1824154 1824154 2021-10-17 Grant Kentucky 21081 4199 35
1824255 1824255 2021-10-17 Grant Louisiana 22043 3794 77
1824465 1824465 2021-10-17 Grant Minnesota 27051 766 9
1824820 1824820 2021-10-17 Grant Nebraska 31075 66 4
1824936 1824936 2021-10-17 Grant New Mexico 35017 2308 49
1825136 1825136 2021-10-17 Grant North Dakota 38037 307 7
1825289 1825289 2021-10-17 Grant Oklahoma 40053 690 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] desc);