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

765 rows where county = "Colfax" 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 · 765 ✖

fips 1

county 1

  • Colfax · 765 ✖
Link rowid date ▲ county state fips cases deaths
2501398 2501398 2022-05-13 Colfax New Mexico 35007 2708 65
2498140 2498140 2022-05-12 Colfax New Mexico 35007 2707 65
2494882 2494882 2022-05-11 Colfax New Mexico 35007 2707 65
2491624 2491624 2022-05-10 Colfax New Mexico 35007 2707 65
2488366 2488366 2022-05-09 Colfax New Mexico 35007 2707 65
2485109 2485109 2022-05-08 Colfax New Mexico 35007 2707 65
2481851 2481851 2022-05-07 Colfax New Mexico 35007 2707 64
2478593 2478593 2022-05-06 Colfax New Mexico 35007 2707 64
2475335 2475335 2022-05-05 Colfax New Mexico 35007 2707 65
2472078 2472078 2022-05-04 Colfax New Mexico 35007 2706 65
2468822 2468822 2022-05-03 Colfax New Mexico 35007 2706 65
2465566 2465566 2022-05-02 Colfax New Mexico 35007 2705 65
2462311 2462311 2022-05-01 Colfax New Mexico 35007 2702 65
2459055 2459055 2022-04-30 Colfax New Mexico 35007 2702 65
2455799 2455799 2022-04-29 Colfax New Mexico 35007 2702 65
2452543 2452543 2022-04-28 Colfax New Mexico 35007 2702 65
2449287 2449287 2022-04-27 Colfax New Mexico 35007 2700 65
2446030 2446030 2022-04-26 Colfax New Mexico 35007 2700 65
2442775 2442775 2022-04-25 Colfax New Mexico 35007 2700 65
2439519 2439519 2022-04-24 Colfax New Mexico 35007 2700 65
2436263 2436263 2022-04-23 Colfax New Mexico 35007 2700 65
2433007 2433007 2022-04-22 Colfax New Mexico 35007 2700 65
2429751 2429751 2022-04-21 Colfax New Mexico 35007 2698 65
2426495 2426495 2022-04-20 Colfax New Mexico 35007 2697 65
2423239 2423239 2022-04-19 Colfax New Mexico 35007 2697 65
2419982 2419982 2022-04-18 Colfax New Mexico 35007 2697 65
2416727 2416727 2022-04-17 Colfax New Mexico 35007 2695 65
2413471 2413471 2022-04-16 Colfax New Mexico 35007 2695 65
2410215 2410215 2022-04-15 Colfax New Mexico 35007 2695 65
2406959 2406959 2022-04-14 Colfax New Mexico 35007 2695 65
2403703 2403703 2022-04-13 Colfax New Mexico 35007 2694 65
2400448 2400448 2022-04-12 Colfax New Mexico 35007 2693 65
2397193 2397193 2022-04-11 Colfax New Mexico 35007 2693 65
2393938 2393938 2022-04-10 Colfax New Mexico 35007 2692 65
2390682 2390682 2022-04-09 Colfax New Mexico 35007 2692 65
2387426 2387426 2022-04-08 Colfax New Mexico 35007 2692 65
2384171 2384171 2022-04-07 Colfax New Mexico 35007 2691 65
2380916 2380916 2022-04-06 Colfax New Mexico 35007 2691 65
2377661 2377661 2022-04-05 Colfax New Mexico 35007 2691 65
2374408 2374408 2022-04-04 Colfax New Mexico 35007 2691 65
2371156 2371156 2022-04-03 Colfax New Mexico 35007 2689 65
2367903 2367903 2022-04-02 Colfax New Mexico 35007 2689 65
2364650 2364650 2022-04-01 Colfax New Mexico 35007 2689 65
2361396 2361396 2022-03-31 Colfax New Mexico 35007 2689 65
2358142 2358142 2022-03-30 Colfax New Mexico 35007 2689 65
2354889 2354889 2022-03-29 Colfax New Mexico 35007 2688 65
2351636 2351636 2022-03-28 Colfax New Mexico 35007 2687 65
2348384 2348384 2022-03-27 Colfax New Mexico 35007 2687 65
2345131 2345131 2022-03-26 Colfax New Mexico 35007 2687 65
2341878 2341878 2022-03-25 Colfax New Mexico 35007 2687 65
2338625 2338625 2022-03-24 Colfax New Mexico 35007 2687 65
2335371 2335371 2022-03-23 Colfax New Mexico 35007 2687 65
2332117 2332117 2022-03-22 Colfax New Mexico 35007 2686 65
2328864 2328864 2022-03-21 Colfax New Mexico 35007 2686 65
2325612 2325612 2022-03-20 Colfax New Mexico 35007 2686 65
2322358 2322358 2022-03-19 Colfax New Mexico 35007 2685 65
2319104 2319104 2022-03-18 Colfax New Mexico 35007 2685 65
2315851 2315851 2022-03-17 Colfax New Mexico 35007 2685 65
2312598 2312598 2022-03-16 Colfax New Mexico 35007 2685 65
2309345 2309345 2022-03-15 Colfax New Mexico 35007 2685 65
2306092 2306092 2022-03-14 Colfax New Mexico 35007 2686 65
2302841 2302841 2022-03-13 Colfax New Mexico 35007 2686 65
2299589 2299589 2022-03-12 Colfax New Mexico 35007 2686 65
2296337 2296337 2022-03-11 Colfax New Mexico 35007 2686 65
2293085 2293085 2022-03-10 Colfax New Mexico 35007 2682 65
2289833 2289833 2022-03-09 Colfax New Mexico 35007 2675 65
2286581 2286581 2022-03-08 Colfax New Mexico 35007 2670 65
2283329 2283329 2022-03-07 Colfax New Mexico 35007 2670 65
2280076 2280076 2022-03-06 Colfax New Mexico 35007 2667 65
2276823 2276823 2022-03-05 Colfax New Mexico 35007 2667 65
2273570 2273570 2022-03-04 Colfax New Mexico 35007 2667 65
2270318 2270318 2022-03-03 Colfax New Mexico 35007 2665 65
2267065 2267065 2022-03-02 Colfax New Mexico 35007 2661 65
2263814 2263814 2022-03-01 Colfax New Mexico 35007 2654 65
2260563 2260563 2022-02-28 Colfax New Mexico 35007 2648 65
2257312 2257312 2022-02-27 Colfax New Mexico 35007 2647 65
2254061 2254061 2022-02-26 Colfax New Mexico 35007 2647 65
2250810 2250810 2022-02-25 Colfax New Mexico 35007 2647 65
2247559 2247559 2022-02-24 Colfax New Mexico 35007 2642 65
2244308 2244308 2022-02-23 Colfax New Mexico 35007 2639 65
2241057 2241057 2022-02-22 Colfax New Mexico 35007 2632 65
2237806 2237806 2022-02-21 Colfax New Mexico 35007 2632 65
2234555 2234555 2022-02-20 Colfax New Mexico 35007 2627 65
2231304 2231304 2022-02-19 Colfax New Mexico 35007 2627 65
2228053 2228053 2022-02-18 Colfax New Mexico 35007 2627 65
2224802 2224802 2022-02-17 Colfax New Mexico 35007 2621 64
2221551 2221551 2022-02-16 Colfax New Mexico 35007 2617 64
2218300 2218300 2022-02-15 Colfax New Mexico 35007 2615 64
2215049 2215049 2022-02-14 Colfax New Mexico 35007 2611 64
2211797 2211797 2022-02-13 Colfax New Mexico 35007 2600 63
2208544 2208544 2022-02-12 Colfax New Mexico 35007 2600 63
2205291 2205291 2022-02-11 Colfax New Mexico 35007 2600 63
2202038 2202038 2022-02-10 Colfax New Mexico 35007 2595 63
2198784 2198784 2022-02-09 Colfax New Mexico 35007 2586 62
2195530 2195530 2022-02-08 Colfax New Mexico 35007 2571 62
2192276 2192276 2022-02-07 Colfax New Mexico 35007 2562 62
2189023 2189023 2022-02-06 Colfax New Mexico 35007 2550 60
2185770 2185770 2022-02-05 Colfax New Mexico 35007 2550 59
2182518 2182518 2022-02-04 Colfax New Mexico 35007 2550 59
2179266 2179266 2022-02-03 Colfax New Mexico 35007 2546 60

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