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

770 rows where county = "Lincoln" and state = "New Mexico" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • New Mexico · 770 ✖

fips 1

county 1

  • Lincoln · 770 ✖
Link rowid date ▲ county state fips cases deaths
2501408 2501408 2022-05-13 Lincoln New Mexico 35027 5296 67
2498150 2498150 2022-05-12 Lincoln New Mexico 35027 5295 67
2494892 2494892 2022-05-11 Lincoln New Mexico 35027 5292 67
2491634 2491634 2022-05-10 Lincoln New Mexico 35027 5290 67
2488376 2488376 2022-05-09 Lincoln New Mexico 35027 5287 67
2485119 2485119 2022-05-08 Lincoln New Mexico 35027 5283 67
2481861 2481861 2022-05-07 Lincoln New Mexico 35027 5283 67
2478603 2478603 2022-05-06 Lincoln New Mexico 35027 5283 67
2475345 2475345 2022-05-05 Lincoln New Mexico 35027 5280 67
2472088 2472088 2022-05-04 Lincoln New Mexico 35027 5276 67
2468832 2468832 2022-05-03 Lincoln New Mexico 35027 5275 67
2465576 2465576 2022-05-02 Lincoln New Mexico 35027 5269 67
2462321 2462321 2022-05-01 Lincoln New Mexico 35027 5265 66
2459065 2459065 2022-04-30 Lincoln New Mexico 35027 5265 66
2455809 2455809 2022-04-29 Lincoln New Mexico 35027 5265 66
2452553 2452553 2022-04-28 Lincoln New Mexico 35027 5260 66
2449297 2449297 2022-04-27 Lincoln New Mexico 35027 5256 66
2446040 2446040 2022-04-26 Lincoln New Mexico 35027 5256 66
2442785 2442785 2022-04-25 Lincoln New Mexico 35027 5256 66
2439529 2439529 2022-04-24 Lincoln New Mexico 35027 5253 66
2436273 2436273 2022-04-23 Lincoln New Mexico 35027 5253 66
2433017 2433017 2022-04-22 Lincoln New Mexico 35027 5253 66
2429761 2429761 2022-04-21 Lincoln New Mexico 35027 5253 66
2426505 2426505 2022-04-20 Lincoln New Mexico 35027 5251 66
2423249 2423249 2022-04-19 Lincoln New Mexico 35027 5249 66
2419992 2419992 2022-04-18 Lincoln New Mexico 35027 5249 66
2416737 2416737 2022-04-17 Lincoln New Mexico 35027 5244 66
2413481 2413481 2022-04-16 Lincoln New Mexico 35027 5244 66
2410225 2410225 2022-04-15 Lincoln New Mexico 35027 5244 66
2406969 2406969 2022-04-14 Lincoln New Mexico 35027 5243 66
2403713 2403713 2022-04-13 Lincoln New Mexico 35027 5243 66
2400458 2400458 2022-04-12 Lincoln New Mexico 35027 5240 66
2397203 2397203 2022-04-11 Lincoln New Mexico 35027 5239 65
2393948 2393948 2022-04-10 Lincoln New Mexico 35027 5229 65
2390692 2390692 2022-04-09 Lincoln New Mexico 35027 5229 65
2387436 2387436 2022-04-08 Lincoln New Mexico 35027 5229 65
2384181 2384181 2022-04-07 Lincoln New Mexico 35027 5226 65
2380926 2380926 2022-04-06 Lincoln New Mexico 35027 5226 65
2377671 2377671 2022-04-05 Lincoln New Mexico 35027 5223 65
2374418 2374418 2022-04-04 Lincoln New Mexico 35027 5221 65
2371166 2371166 2022-04-03 Lincoln New Mexico 35027 5219 65
2367913 2367913 2022-04-02 Lincoln New Mexico 35027 5219 65
2364660 2364660 2022-04-01 Lincoln New Mexico 35027 5219 65
2361406 2361406 2022-03-31 Lincoln New Mexico 35027 5218 65
2358152 2358152 2022-03-30 Lincoln New Mexico 35027 5216 65
2354899 2354899 2022-03-29 Lincoln New Mexico 35027 5213 65
2351646 2351646 2022-03-28 Lincoln New Mexico 35027 5213 65
2348394 2348394 2022-03-27 Lincoln New Mexico 35027 5209 65
2345141 2345141 2022-03-26 Lincoln New Mexico 35027 5209 65
2341888 2341888 2022-03-25 Lincoln New Mexico 35027 5209 65
2338635 2338635 2022-03-24 Lincoln New Mexico 35027 5200 65
2335381 2335381 2022-03-23 Lincoln New Mexico 35027 5191 65
2332127 2332127 2022-03-22 Lincoln New Mexico 35027 5188 65
2328874 2328874 2022-03-21 Lincoln New Mexico 35027 5186 65
2325622 2325622 2022-03-20 Lincoln New Mexico 35027 5179 65
2322368 2322368 2022-03-19 Lincoln New Mexico 35027 5174 64
2319114 2319114 2022-03-18 Lincoln New Mexico 35027 5174 64
2315861 2315861 2022-03-17 Lincoln New Mexico 35027 5174 64
2312608 2312608 2022-03-16 Lincoln New Mexico 35027 5173 64
2309355 2309355 2022-03-15 Lincoln New Mexico 35027 5172 64
2306102 2306102 2022-03-14 Lincoln New Mexico 35027 5173 64
2302851 2302851 2022-03-13 Lincoln New Mexico 35027 5167 64
2299599 2299599 2022-03-12 Lincoln New Mexico 35027 5167 64
2296347 2296347 2022-03-11 Lincoln New Mexico 35027 5167 64
2293095 2293095 2022-03-10 Lincoln New Mexico 35027 5166 64
2289843 2289843 2022-03-09 Lincoln New Mexico 35027 5165 64
2286591 2286591 2022-03-08 Lincoln New Mexico 35027 5162 64
2283339 2283339 2022-03-07 Lincoln New Mexico 35027 5157 64
2280086 2280086 2022-03-06 Lincoln New Mexico 35027 5150 64
2276833 2276833 2022-03-05 Lincoln New Mexico 35027 5150 64
2273580 2273580 2022-03-04 Lincoln New Mexico 35027 5150 64
2270328 2270328 2022-03-03 Lincoln New Mexico 35027 5148 64
2267075 2267075 2022-03-02 Lincoln New Mexico 35027 5145 64
2263824 2263824 2022-03-01 Lincoln New Mexico 35027 5139 64
2260573 2260573 2022-02-28 Lincoln New Mexico 35027 5136 64
2257322 2257322 2022-02-27 Lincoln New Mexico 35027 5129 63
2254071 2254071 2022-02-26 Lincoln New Mexico 35027 5129 63
2250820 2250820 2022-02-25 Lincoln New Mexico 35027 5129 63
2247569 2247569 2022-02-24 Lincoln New Mexico 35027 5128 63
2244318 2244318 2022-02-23 Lincoln New Mexico 35027 5121 63
2241067 2241067 2022-02-22 Lincoln New Mexico 35027 5111 62
2237816 2237816 2022-02-21 Lincoln New Mexico 35027 5106 61
2234565 2234565 2022-02-20 Lincoln New Mexico 35027 5093 60
2231314 2231314 2022-02-19 Lincoln New Mexico 35027 5093 60
2228063 2228063 2022-02-18 Lincoln New Mexico 35027 5093 60
2224812 2224812 2022-02-17 Lincoln New Mexico 35027 5083 60
2221561 2221561 2022-02-16 Lincoln New Mexico 35027 5081 60
2218310 2218310 2022-02-15 Lincoln New Mexico 35027 5068 59
2215059 2215059 2022-02-14 Lincoln New Mexico 35027 5066 59
2211807 2211807 2022-02-13 Lincoln New Mexico 35027 5051 59
2208554 2208554 2022-02-12 Lincoln New Mexico 35027 5051 59
2205301 2205301 2022-02-11 Lincoln New Mexico 35027 5051 59
2202048 2202048 2022-02-10 Lincoln New Mexico 35027 5045 59
2198794 2198794 2022-02-09 Lincoln New Mexico 35027 5026 59
2195540 2195540 2022-02-08 Lincoln New Mexico 35027 4996 58
2192286 2192286 2022-02-07 Lincoln New Mexico 35027 4991 58
2189033 2189033 2022-02-06 Lincoln New Mexico 35027 4974 58
2185780 2185780 2022-02-05 Lincoln New Mexico 35027 4974 58
2182528 2182528 2022-02-04 Lincoln New Mexico 35027 4974 58
2179276 2179276 2022-02-03 Lincoln New Mexico 35027 4964 58

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