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

773 rows where county = "Grant" and fips = 35017 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

fips 1

  • 35017 · 773 ✖

county 1

  • Grant · 773 ✖
Link rowid date ▲ county state fips cases deaths
2501403 2501403 2022-05-13 Grant New Mexico 35017 6748 90
2498145 2498145 2022-05-12 Grant New Mexico 35017 6736 90
2494887 2494887 2022-05-11 Grant New Mexico 35017 6731 90
2491629 2491629 2022-05-10 Grant New Mexico 35017 6718 90
2488371 2488371 2022-05-09 Grant New Mexico 35017 6707 90
2485114 2485114 2022-05-08 Grant New Mexico 35017 6698 90
2481856 2481856 2022-05-07 Grant New Mexico 35017 6698 90
2478598 2478598 2022-05-06 Grant New Mexico 35017 6698 90
2475340 2475340 2022-05-05 Grant New Mexico 35017 6694 90
2472083 2472083 2022-05-04 Grant New Mexico 35017 6694 89
2468827 2468827 2022-05-03 Grant New Mexico 35017 6688 89
2465571 2465571 2022-05-02 Grant New Mexico 35017 6684 89
2462316 2462316 2022-05-01 Grant New Mexico 35017 6684 88
2459060 2459060 2022-04-30 Grant New Mexico 35017 6684 88
2455804 2455804 2022-04-29 Grant New Mexico 35017 6684 88
2452548 2452548 2022-04-28 Grant New Mexico 35017 6683 88
2449292 2449292 2022-04-27 Grant New Mexico 35017 6677 87
2446035 2446035 2022-04-26 Grant New Mexico 35017 6677 87
2442780 2442780 2022-04-25 Grant New Mexico 35017 6677 87
2439524 2439524 2022-04-24 Grant New Mexico 35017 6673 87
2436268 2436268 2022-04-23 Grant New Mexico 35017 6673 87
2433012 2433012 2022-04-22 Grant New Mexico 35017 6673 87
2429756 2429756 2022-04-21 Grant New Mexico 35017 6673 87
2426500 2426500 2022-04-20 Grant New Mexico 35017 6674 87
2423244 2423244 2022-04-19 Grant New Mexico 35017 6673 86
2419987 2419987 2022-04-18 Grant New Mexico 35017 6672 86
2416732 2416732 2022-04-17 Grant New Mexico 35017 6666 86
2413476 2413476 2022-04-16 Grant New Mexico 35017 6666 86
2410220 2410220 2022-04-15 Grant New Mexico 35017 6666 86
2406964 2406964 2022-04-14 Grant New Mexico 35017 6664 86
2403708 2403708 2022-04-13 Grant New Mexico 35017 6664 86
2400453 2400453 2022-04-12 Grant New Mexico 35017 6657 86
2397198 2397198 2022-04-11 Grant New Mexico 35017 6657 85
2393943 2393943 2022-04-10 Grant New Mexico 35017 6652 85
2390687 2390687 2022-04-09 Grant New Mexico 35017 6652 85
2387431 2387431 2022-04-08 Grant New Mexico 35017 6652 85
2384176 2384176 2022-04-07 Grant New Mexico 35017 6652 84
2380921 2380921 2022-04-06 Grant New Mexico 35017 6650 84
2377666 2377666 2022-04-05 Grant New Mexico 35017 6646 84
2374413 2374413 2022-04-04 Grant New Mexico 35017 6645 84
2371161 2371161 2022-04-03 Grant New Mexico 35017 6643 83
2367908 2367908 2022-04-02 Grant New Mexico 35017 6643 83
2364655 2364655 2022-04-01 Grant New Mexico 35017 6643 83
2361401 2361401 2022-03-31 Grant New Mexico 35017 6642 83
2358147 2358147 2022-03-30 Grant New Mexico 35017 6641 83
2354894 2354894 2022-03-29 Grant New Mexico 35017 6640 82
2351641 2351641 2022-03-28 Grant New Mexico 35017 6639 82
2348389 2348389 2022-03-27 Grant New Mexico 35017 6637 81
2345136 2345136 2022-03-26 Grant New Mexico 35017 6637 81
2341883 2341883 2022-03-25 Grant New Mexico 35017 6637 81
2338630 2338630 2022-03-24 Grant New Mexico 35017 6635 81
2335376 2335376 2022-03-23 Grant New Mexico 35017 6633 81
2332122 2332122 2022-03-22 Grant New Mexico 35017 6628 81
2328869 2328869 2022-03-21 Grant New Mexico 35017 6625 81
2325617 2325617 2022-03-20 Grant New Mexico 35017 6621 81
2322363 2322363 2022-03-19 Grant New Mexico 35017 6618 80
2319109 2319109 2022-03-18 Grant New Mexico 35017 6618 80
2315856 2315856 2022-03-17 Grant New Mexico 35017 6618 80
2312603 2312603 2022-03-16 Grant New Mexico 35017 6616 80
2309350 2309350 2022-03-15 Grant New Mexico 35017 6607 79
2306097 2306097 2022-03-14 Grant New Mexico 35017 6601 78
2302846 2302846 2022-03-13 Grant New Mexico 35017 6597 78
2299594 2299594 2022-03-12 Grant New Mexico 35017 6597 78
2296342 2296342 2022-03-11 Grant New Mexico 35017 6597 78
2293090 2293090 2022-03-10 Grant New Mexico 35017 6590 78
2289838 2289838 2022-03-09 Grant New Mexico 35017 6580 77
2286586 2286586 2022-03-08 Grant New Mexico 35017 6573 77
2283334 2283334 2022-03-07 Grant New Mexico 35017 6563 77
2280081 2280081 2022-03-06 Grant New Mexico 35017 6548 77
2276828 2276828 2022-03-05 Grant New Mexico 35017 6548 77
2273575 2273575 2022-03-04 Grant New Mexico 35017 6548 77
2270323 2270323 2022-03-03 Grant New Mexico 35017 6544 77
2267070 2267070 2022-03-02 Grant New Mexico 35017 6531 76
2263819 2263819 2022-03-01 Grant New Mexico 35017 6520 76
2260568 2260568 2022-02-28 Grant New Mexico 35017 6510 76
2257317 2257317 2022-02-27 Grant New Mexico 35017 6499 76
2254066 2254066 2022-02-26 Grant New Mexico 35017 6499 76
2250815 2250815 2022-02-25 Grant New Mexico 35017 6499 76
2247564 2247564 2022-02-24 Grant New Mexico 35017 6489 76
2244313 2244313 2022-02-23 Grant New Mexico 35017 6481 75
2241062 2241062 2022-02-22 Grant New Mexico 35017 6460 75
2237811 2237811 2022-02-21 Grant New Mexico 35017 6456 74
2234560 2234560 2022-02-20 Grant New Mexico 35017 6436 74
2231309 2231309 2022-02-19 Grant New Mexico 35017 6436 74
2228058 2228058 2022-02-18 Grant New Mexico 35017 6436 74
2224807 2224807 2022-02-17 Grant New Mexico 35017 6410 74
2221556 2221556 2022-02-16 Grant New Mexico 35017 6391 74
2218305 2218305 2022-02-15 Grant New Mexico 35017 6362 74
2215054 2215054 2022-02-14 Grant New Mexico 35017 6344 73
2211802 2211802 2022-02-13 Grant New Mexico 35017 6309 73
2208549 2208549 2022-02-12 Grant New Mexico 35017 6309 73
2205296 2205296 2022-02-11 Grant New Mexico 35017 6309 73
2202043 2202043 2022-02-10 Grant New Mexico 35017 6289 72
2198789 2198789 2022-02-09 Grant New Mexico 35017 6247 71
2195535 2195535 2022-02-08 Grant New Mexico 35017 6192 71
2192281 2192281 2022-02-07 Grant New Mexico 35017 6173 71
2189028 2189028 2022-02-06 Grant New Mexico 35017 6124 71
2185775 2185775 2022-02-05 Grant New Mexico 35017 6124 71
2182523 2182523 2022-02-04 Grant New Mexico 35017 6124 71
2179271 2179271 2022-02-03 Grant New Mexico 35017 6071 71

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