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

788 rows where county = "Taos" 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 · 788 ✖

fips 1

county 1

  • Taos · 788 ✖
Link rowid date ▲ county state fips cases deaths
2501423 2501423 2022-05-13 Taos New Mexico 35055 5425 90
2498165 2498165 2022-05-12 Taos New Mexico 35055 5422 90
2494907 2494907 2022-05-11 Taos New Mexico 35055 5417 90
2491649 2491649 2022-05-10 Taos New Mexico 35055 5412 90
2488391 2488391 2022-05-09 Taos New Mexico 35055 5410 90
2485134 2485134 2022-05-08 Taos New Mexico 35055 5402 90
2481876 2481876 2022-05-07 Taos New Mexico 35055 5402 90
2478618 2478618 2022-05-06 Taos New Mexico 35055 5402 90
2475360 2475360 2022-05-05 Taos New Mexico 35055 5399 90
2472103 2472103 2022-05-04 Taos New Mexico 35055 5396 90
2468847 2468847 2022-05-03 Taos New Mexico 35055 5389 90
2465591 2465591 2022-05-02 Taos New Mexico 35055 5387 90
2462336 2462336 2022-05-01 Taos New Mexico 35055 5378 90
2459080 2459080 2022-04-30 Taos New Mexico 35055 5378 90
2455824 2455824 2022-04-29 Taos New Mexico 35055 5378 90
2452568 2452568 2022-04-28 Taos New Mexico 35055 5373 90
2449312 2449312 2022-04-27 Taos New Mexico 35055 5361 90
2446055 2446055 2022-04-26 Taos New Mexico 35055 5361 90
2442800 2442800 2022-04-25 Taos New Mexico 35055 5361 90
2439544 2439544 2022-04-24 Taos New Mexico 35055 5351 90
2436288 2436288 2022-04-23 Taos New Mexico 35055 5351 90
2433032 2433032 2022-04-22 Taos New Mexico 35055 5351 90
2429776 2429776 2022-04-21 Taos New Mexico 35055 5345 90
2426520 2426520 2022-04-20 Taos New Mexico 35055 5340 90
2423264 2423264 2022-04-19 Taos New Mexico 35055 5338 90
2420007 2420007 2022-04-18 Taos New Mexico 35055 5336 90
2416752 2416752 2022-04-17 Taos New Mexico 35055 5332 90
2413496 2413496 2022-04-16 Taos New Mexico 35055 5332 90
2410240 2410240 2022-04-15 Taos New Mexico 35055 5332 90
2406984 2406984 2022-04-14 Taos New Mexico 35055 5329 90
2403728 2403728 2022-04-13 Taos New Mexico 35055 5326 89
2400473 2400473 2022-04-12 Taos New Mexico 35055 5327 89
2397218 2397218 2022-04-11 Taos New Mexico 35055 5326 89
2393963 2393963 2022-04-10 Taos New Mexico 35055 5324 89
2390707 2390707 2022-04-09 Taos New Mexico 35055 5324 89
2387451 2387451 2022-04-08 Taos New Mexico 35055 5324 89
2384196 2384196 2022-04-07 Taos New Mexico 35055 5321 89
2380941 2380941 2022-04-06 Taos New Mexico 35055 5320 89
2377686 2377686 2022-04-05 Taos New Mexico 35055 5319 89
2374433 2374433 2022-04-04 Taos New Mexico 35055 5318 89
2371181 2371181 2022-04-03 Taos New Mexico 35055 5313 89
2367928 2367928 2022-04-02 Taos New Mexico 35055 5313 89
2364675 2364675 2022-04-01 Taos New Mexico 35055 5313 89
2361421 2361421 2022-03-31 Taos New Mexico 35055 5311 89
2358167 2358167 2022-03-30 Taos New Mexico 35055 5305 89
2354914 2354914 2022-03-29 Taos New Mexico 35055 5303 89
2351661 2351661 2022-03-28 Taos New Mexico 35055 5302 89
2348409 2348409 2022-03-27 Taos New Mexico 35055 5299 89
2345156 2345156 2022-03-26 Taos New Mexico 35055 5299 89
2341903 2341903 2022-03-25 Taos New Mexico 35055 5299 89
2338650 2338650 2022-03-24 Taos New Mexico 35055 5298 89
2335396 2335396 2022-03-23 Taos New Mexico 35055 5297 89
2332142 2332142 2022-03-22 Taos New Mexico 35055 5294 89
2328889 2328889 2022-03-21 Taos New Mexico 35055 5293 89
2325637 2325637 2022-03-20 Taos New Mexico 35055 5290 89
2322383 2322383 2022-03-19 Taos New Mexico 35055 5289 89
2319129 2319129 2022-03-18 Taos New Mexico 35055 5289 89
2315876 2315876 2022-03-17 Taos New Mexico 35055 5289 89
2312623 2312623 2022-03-16 Taos New Mexico 35055 5288 89
2309370 2309370 2022-03-15 Taos New Mexico 35055 5287 89
2306117 2306117 2022-03-14 Taos New Mexico 35055 5287 89
2302866 2302866 2022-03-13 Taos New Mexico 35055 5276 89
2299614 2299614 2022-03-12 Taos New Mexico 35055 5276 89
2296362 2296362 2022-03-11 Taos New Mexico 35055 5276 89
2293110 2293110 2022-03-10 Taos New Mexico 35055 5272 89
2289858 2289858 2022-03-09 Taos New Mexico 35055 5267 89
2286606 2286606 2022-03-08 Taos New Mexico 35055 5263 89
2283354 2283354 2022-03-07 Taos New Mexico 35055 5262 89
2280101 2280101 2022-03-06 Taos New Mexico 35055 5254 89
2276848 2276848 2022-03-05 Taos New Mexico 35055 5254 89
2273595 2273595 2022-03-04 Taos New Mexico 35055 5254 89
2270343 2270343 2022-03-03 Taos New Mexico 35055 5251 89
2267090 2267090 2022-03-02 Taos New Mexico 35055 5248 89
2263839 2263839 2022-03-01 Taos New Mexico 35055 5246 88
2260588 2260588 2022-02-28 Taos New Mexico 35055 5238 88
2257337 2257337 2022-02-27 Taos New Mexico 35055 5232 87
2254086 2254086 2022-02-26 Taos New Mexico 35055 5232 87
2250835 2250835 2022-02-25 Taos New Mexico 35055 5232 87
2247584 2247584 2022-02-24 Taos New Mexico 35055 5229 87
2244333 2244333 2022-02-23 Taos New Mexico 35055 5224 87
2241082 2241082 2022-02-22 Taos New Mexico 35055 5215 86
2237831 2237831 2022-02-21 Taos New Mexico 35055 5215 86
2234580 2234580 2022-02-20 Taos New Mexico 35055 5195 86
2231329 2231329 2022-02-19 Taos New Mexico 35055 5195 86
2228078 2228078 2022-02-18 Taos New Mexico 35055 5195 86
2224827 2224827 2022-02-17 Taos New Mexico 35055 5177 84
2221576 2221576 2022-02-16 Taos New Mexico 35055 5165 84
2218325 2218325 2022-02-15 Taos New Mexico 35055 5154 84
2215074 2215074 2022-02-14 Taos New Mexico 35055 5141 83
2211822 2211822 2022-02-13 Taos New Mexico 35055 5128 83
2208569 2208569 2022-02-12 Taos New Mexico 35055 5128 83
2205316 2205316 2022-02-11 Taos New Mexico 35055 5128 83
2202063 2202063 2022-02-10 Taos New Mexico 35055 5112 83
2198809 2198809 2022-02-09 Taos New Mexico 35055 5094 82
2195555 2195555 2022-02-08 Taos New Mexico 35055 5081 82
2192301 2192301 2022-02-07 Taos New Mexico 35055 5067 82
2189048 2189048 2022-02-06 Taos New Mexico 35055 5027 81
2185795 2185795 2022-02-05 Taos New Mexico 35055 5027 81
2182543 2182543 2022-02-04 Taos New Mexico 35055 5027 81
2179291 2179291 2022-02-03 Taos New Mexico 35055 4999 81

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