ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,537 rows where county = "Colfax" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501267 | 2501267 | 2022-05-13 | Colfax | Nebraska | 31037 | 2693 | 27 |
2501398 | 2501398 | 2022-05-13 | Colfax | New Mexico | 35007 | 2708 | 65 |
2498009 | 2498009 | 2022-05-12 | Colfax | Nebraska | 31037 | 2691 | 27 |
2498140 | 2498140 | 2022-05-12 | Colfax | New Mexico | 35007 | 2707 | 65 |
2494751 | 2494751 | 2022-05-11 | Colfax | Nebraska | 31037 | 2691 | 27 |
2494882 | 2494882 | 2022-05-11 | Colfax | New Mexico | 35007 | 2707 | 65 |
2491493 | 2491493 | 2022-05-10 | Colfax | Nebraska | 31037 | 2741 | 27 |
2491624 | 2491624 | 2022-05-10 | Colfax | New Mexico | 35007 | 2707 | 65 |
2488235 | 2488235 | 2022-05-09 | Colfax | Nebraska | 31037 | 2741 | 27 |
2488366 | 2488366 | 2022-05-09 | Colfax | New Mexico | 35007 | 2707 | 65 |
2484978 | 2484978 | 2022-05-08 | Colfax | Nebraska | 31037 | 2741 | 27 |
2485109 | 2485109 | 2022-05-08 | Colfax | New Mexico | 35007 | 2707 | 65 |
2481720 | 2481720 | 2022-05-07 | Colfax | Nebraska | 31037 | 2741 | 27 |
2481851 | 2481851 | 2022-05-07 | Colfax | New Mexico | 35007 | 2707 | 64 |
2478462 | 2478462 | 2022-05-06 | Colfax | Nebraska | 31037 | 2741 | 27 |
2478593 | 2478593 | 2022-05-06 | Colfax | New Mexico | 35007 | 2707 | 64 |
2475204 | 2475204 | 2022-05-05 | Colfax | Nebraska | 31037 | 2741 | 27 |
2475335 | 2475335 | 2022-05-05 | Colfax | New Mexico | 35007 | 2707 | 65 |
2471947 | 2471947 | 2022-05-04 | Colfax | Nebraska | 31037 | 2739 | 27 |
2472078 | 2472078 | 2022-05-04 | Colfax | New Mexico | 35007 | 2706 | 65 |
2468691 | 2468691 | 2022-05-03 | Colfax | Nebraska | 31037 | 2739 | 27 |
2468822 | 2468822 | 2022-05-03 | Colfax | New Mexico | 35007 | 2706 | 65 |
2465435 | 2465435 | 2022-05-02 | Colfax | Nebraska | 31037 | 2741 | 27 |
2465566 | 2465566 | 2022-05-02 | Colfax | New Mexico | 35007 | 2705 | 65 |
2462180 | 2462180 | 2022-05-01 | Colfax | Nebraska | 31037 | 2741 | 27 |
2462311 | 2462311 | 2022-05-01 | Colfax | New Mexico | 35007 | 2702 | 65 |
2458924 | 2458924 | 2022-04-30 | Colfax | Nebraska | 31037 | 2741 | 27 |
2459055 | 2459055 | 2022-04-30 | Colfax | New Mexico | 35007 | 2702 | 65 |
2455668 | 2455668 | 2022-04-29 | Colfax | Nebraska | 31037 | 2741 | 27 |
2455799 | 2455799 | 2022-04-29 | Colfax | New Mexico | 35007 | 2702 | 65 |
2452412 | 2452412 | 2022-04-28 | Colfax | Nebraska | 31037 | 2741 | 27 |
2452543 | 2452543 | 2022-04-28 | Colfax | New Mexico | 35007 | 2702 | 65 |
2449156 | 2449156 | 2022-04-27 | Colfax | Nebraska | 31037 | 2741 | 27 |
2449287 | 2449287 | 2022-04-27 | Colfax | New Mexico | 35007 | 2700 | 65 |
2445899 | 2445899 | 2022-04-26 | Colfax | Nebraska | 31037 | 2740 | 27 |
2446030 | 2446030 | 2022-04-26 | Colfax | New Mexico | 35007 | 2700 | 65 |
2442644 | 2442644 | 2022-04-25 | Colfax | Nebraska | 31037 | 2740 | 27 |
2442775 | 2442775 | 2022-04-25 | Colfax | New Mexico | 35007 | 2700 | 65 |
2439388 | 2439388 | 2022-04-24 | Colfax | Nebraska | 31037 | 2740 | 27 |
2439519 | 2439519 | 2022-04-24 | Colfax | New Mexico | 35007 | 2700 | 65 |
2436132 | 2436132 | 2022-04-23 | Colfax | Nebraska | 31037 | 2740 | 27 |
2436263 | 2436263 | 2022-04-23 | Colfax | New Mexico | 35007 | 2700 | 65 |
2432876 | 2432876 | 2022-04-22 | Colfax | Nebraska | 31037 | 2740 | 27 |
2433007 | 2433007 | 2022-04-22 | Colfax | New Mexico | 35007 | 2700 | 65 |
2429620 | 2429620 | 2022-04-21 | Colfax | Nebraska | 31037 | 2738 | 27 |
2429751 | 2429751 | 2022-04-21 | Colfax | New Mexico | 35007 | 2698 | 65 |
2426364 | 2426364 | 2022-04-20 | Colfax | Nebraska | 31037 | 2738 | 27 |
2426495 | 2426495 | 2022-04-20 | Colfax | New Mexico | 35007 | 2697 | 65 |
2423108 | 2423108 | 2022-04-19 | Colfax | Nebraska | 31037 | 2738 | 27 |
2423239 | 2423239 | 2022-04-19 | Colfax | New Mexico | 35007 | 2697 | 65 |
2419851 | 2419851 | 2022-04-18 | Colfax | Nebraska | 31037 | 2738 | 27 |
2419982 | 2419982 | 2022-04-18 | Colfax | New Mexico | 35007 | 2697 | 65 |
2416596 | 2416596 | 2022-04-17 | Colfax | Nebraska | 31037 | 2738 | 27 |
2416727 | 2416727 | 2022-04-17 | Colfax | New Mexico | 35007 | 2695 | 65 |
2413340 | 2413340 | 2022-04-16 | Colfax | Nebraska | 31037 | 2738 | 27 |
2413471 | 2413471 | 2022-04-16 | Colfax | New Mexico | 35007 | 2695 | 65 |
2410084 | 2410084 | 2022-04-15 | Colfax | Nebraska | 31037 | 2738 | 27 |
2410215 | 2410215 | 2022-04-15 | Colfax | New Mexico | 35007 | 2695 | 65 |
2406828 | 2406828 | 2022-04-14 | Colfax | Nebraska | 31037 | 2738 | 27 |
2406959 | 2406959 | 2022-04-14 | Colfax | New Mexico | 35007 | 2695 | 65 |
2403572 | 2403572 | 2022-04-13 | Colfax | Nebraska | 31037 | 2737 | 27 |
2403703 | 2403703 | 2022-04-13 | Colfax | New Mexico | 35007 | 2694 | 65 |
2400317 | 2400317 | 2022-04-12 | Colfax | Nebraska | 31037 | 2736 | 26 |
2400448 | 2400448 | 2022-04-12 | Colfax | New Mexico | 35007 | 2693 | 65 |
2397062 | 2397062 | 2022-04-11 | Colfax | Nebraska | 31037 | 2736 | 26 |
2397193 | 2397193 | 2022-04-11 | Colfax | New Mexico | 35007 | 2693 | 65 |
2393807 | 2393807 | 2022-04-10 | Colfax | Nebraska | 31037 | 2735 | 26 |
2393938 | 2393938 | 2022-04-10 | Colfax | New Mexico | 35007 | 2692 | 65 |
2390551 | 2390551 | 2022-04-09 | Colfax | Nebraska | 31037 | 2735 | 26 |
2390682 | 2390682 | 2022-04-09 | Colfax | New Mexico | 35007 | 2692 | 65 |
2387295 | 2387295 | 2022-04-08 | Colfax | Nebraska | 31037 | 2735 | 26 |
2387426 | 2387426 | 2022-04-08 | Colfax | New Mexico | 35007 | 2692 | 65 |
2384040 | 2384040 | 2022-04-07 | Colfax | Nebraska | 31037 | 2735 | 26 |
2384171 | 2384171 | 2022-04-07 | Colfax | New Mexico | 35007 | 2691 | 65 |
2380785 | 2380785 | 2022-04-06 | Colfax | Nebraska | 31037 | 2734 | 26 |
2380916 | 2380916 | 2022-04-06 | Colfax | New Mexico | 35007 | 2691 | 65 |
2377530 | 2377530 | 2022-04-05 | Colfax | Nebraska | 31037 | 2734 | 26 |
2377661 | 2377661 | 2022-04-05 | Colfax | New Mexico | 35007 | 2691 | 65 |
2374277 | 2374277 | 2022-04-04 | Colfax | Nebraska | 31037 | 2733 | 26 |
2374408 | 2374408 | 2022-04-04 | Colfax | New Mexico | 35007 | 2691 | 65 |
2371025 | 2371025 | 2022-04-03 | Colfax | Nebraska | 31037 | 2733 | 26 |
2371156 | 2371156 | 2022-04-03 | Colfax | New Mexico | 35007 | 2689 | 65 |
2367772 | 2367772 | 2022-04-02 | Colfax | Nebraska | 31037 | 2733 | 26 |
2367903 | 2367903 | 2022-04-02 | Colfax | New Mexico | 35007 | 2689 | 65 |
2364519 | 2364519 | 2022-04-01 | Colfax | Nebraska | 31037 | 2733 | 26 |
2364650 | 2364650 | 2022-04-01 | Colfax | New Mexico | 35007 | 2689 | 65 |
2361265 | 2361265 | 2022-03-31 | Colfax | Nebraska | 31037 | 2733 | 26 |
2361396 | 2361396 | 2022-03-31 | Colfax | New Mexico | 35007 | 2689 | 65 |
2358011 | 2358011 | 2022-03-30 | Colfax | Nebraska | 31037 | 2736 | 26 |
2358142 | 2358142 | 2022-03-30 | Colfax | New Mexico | 35007 | 2689 | 65 |
2354758 | 2354758 | 2022-03-29 | Colfax | Nebraska | 31037 | 2737 | 26 |
2354889 | 2354889 | 2022-03-29 | Colfax | New Mexico | 35007 | 2688 | 65 |
2351505 | 2351505 | 2022-03-28 | Colfax | Nebraska | 31037 | 2735 | 26 |
2351636 | 2351636 | 2022-03-28 | Colfax | New Mexico | 35007 | 2687 | 65 |
2348253 | 2348253 | 2022-03-27 | Colfax | Nebraska | 31037 | 2722 | 26 |
2348384 | 2348384 | 2022-03-27 | Colfax | New Mexico | 35007 | 2687 | 65 |
2345000 | 2345000 | 2022-03-26 | Colfax | Nebraska | 31037 | 2722 | 26 |
2345131 | 2345131 | 2022-03-26 | Colfax | New Mexico | 35007 | 2687 | 65 |
2341747 | 2341747 | 2022-03-25 | Colfax | Nebraska | 31037 | 2722 | 26 |
2341878 | 2341878 | 2022-03-25 | Colfax | New Mexico | 35007 | 2687 | 65 |
Advanced export
JSON shape: default, array, newline-delimited
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);