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 fips = 35028 sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

state 1

fips 1

  • 35028 · 770 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2501409 2501409 2022-05-13 Los Alamos New Mexico 35028 2880 16
2498151 2498151 2022-05-12 Los Alamos New Mexico 35028 2880 16
2494893 2494893 2022-05-11 Los Alamos New Mexico 35028 2869 16
2491635 2491635 2022-05-10 Los Alamos New Mexico 35028 2867 16
2488377 2488377 2022-05-09 Los Alamos New Mexico 35028 2865 16
2485120 2485120 2022-05-08 Los Alamos New Mexico 35028 2852 16
2481862 2481862 2022-05-07 Los Alamos New Mexico 35028 2852 16
2478604 2478604 2022-05-06 Los Alamos New Mexico 35028 2852 16
2475346 2475346 2022-05-05 Los Alamos New Mexico 35028 2845 16
2472089 2472089 2022-05-04 Los Alamos New Mexico 35028 2829 16
2468833 2468833 2022-05-03 Los Alamos New Mexico 35028 2827 16
2465577 2465577 2022-05-02 Los Alamos New Mexico 35028 2827 16
2462322 2462322 2022-05-01 Los Alamos New Mexico 35028 2814 16
2459066 2459066 2022-04-30 Los Alamos New Mexico 35028 2814 16
2455810 2455810 2022-04-29 Los Alamos New Mexico 35028 2814 16
2452554 2452554 2022-04-28 Los Alamos New Mexico 35028 2814 16
2449298 2449298 2022-04-27 Los Alamos New Mexico 35028 2794 16
2446041 2446041 2022-04-26 Los Alamos New Mexico 35028 2794 16
2442786 2442786 2022-04-25 Los Alamos New Mexico 35028 2794 16
2439530 2439530 2022-04-24 Los Alamos New Mexico 35028 2781 16
2436274 2436274 2022-04-23 Los Alamos New Mexico 35028 2781 16
2433018 2433018 2022-04-22 Los Alamos New Mexico 35028 2781 16
2429762 2429762 2022-04-21 Los Alamos New Mexico 35028 2777 16
2426506 2426506 2022-04-20 Los Alamos New Mexico 35028 2774 16
2423250 2423250 2022-04-19 Los Alamos New Mexico 35028 2766 16
2419993 2419993 2022-04-18 Los Alamos New Mexico 35028 2764 16
2416738 2416738 2022-04-17 Los Alamos New Mexico 35028 2751 16
2413482 2413482 2022-04-16 Los Alamos New Mexico 35028 2751 16
2410226 2410226 2022-04-15 Los Alamos New Mexico 35028 2751 16
2406970 2406970 2022-04-14 Los Alamos New Mexico 35028 2751 16
2403714 2403714 2022-04-13 Los Alamos New Mexico 35028 2743 16
2400459 2400459 2022-04-12 Los Alamos New Mexico 35028 2742 16
2397204 2397204 2022-04-11 Los Alamos New Mexico 35028 2744 16
2393949 2393949 2022-04-10 Los Alamos New Mexico 35028 2737 16
2390693 2390693 2022-04-09 Los Alamos New Mexico 35028 2737 16
2387437 2387437 2022-04-08 Los Alamos New Mexico 35028 2737 16
2384182 2384182 2022-04-07 Los Alamos New Mexico 35028 2735 16
2380927 2380927 2022-04-06 Los Alamos New Mexico 35028 2730 16
2377672 2377672 2022-04-05 Los Alamos New Mexico 35028 2727 16
2374419 2374419 2022-04-04 Los Alamos New Mexico 35028 2725 16
2371167 2371167 2022-04-03 Los Alamos New Mexico 35028 2715 16
2367914 2367914 2022-04-02 Los Alamos New Mexico 35028 2715 16
2364661 2364661 2022-04-01 Los Alamos New Mexico 35028 2715 16
2361407 2361407 2022-03-31 Los Alamos New Mexico 35028 2715 15
2358153 2358153 2022-03-30 Los Alamos New Mexico 35028 2711 14
2354900 2354900 2022-03-29 Los Alamos New Mexico 35028 2710 14
2351647 2351647 2022-03-28 Los Alamos New Mexico 35028 2709 14
2348395 2348395 2022-03-27 Los Alamos New Mexico 35028 2707 14
2345142 2345142 2022-03-26 Los Alamos New Mexico 35028 2707 14
2341889 2341889 2022-03-25 Los Alamos New Mexico 35028 2707 14
2338636 2338636 2022-03-24 Los Alamos New Mexico 35028 2707 14
2335382 2335382 2022-03-23 Los Alamos New Mexico 35028 2706 14
2332128 2332128 2022-03-22 Los Alamos New Mexico 35028 2702 14
2328875 2328875 2022-03-21 Los Alamos New Mexico 35028 2702 14
2325623 2325623 2022-03-20 Los Alamos New Mexico 35028 2701 14
2322369 2322369 2022-03-19 Los Alamos New Mexico 35028 2700 14
2319115 2319115 2022-03-18 Los Alamos New Mexico 35028 2700 14
2315862 2315862 2022-03-17 Los Alamos New Mexico 35028 2700 14
2312609 2312609 2022-03-16 Los Alamos New Mexico 35028 2700 13
2309356 2309356 2022-03-15 Los Alamos New Mexico 35028 2698 13
2306103 2306103 2022-03-14 Los Alamos New Mexico 35028 2698 13
2302852 2302852 2022-03-13 Los Alamos New Mexico 35028 2692 13
2299600 2299600 2022-03-12 Los Alamos New Mexico 35028 2692 13
2296348 2296348 2022-03-11 Los Alamos New Mexico 35028 2692 13
2293096 2293096 2022-03-10 Los Alamos New Mexico 35028 2686 13
2289844 2289844 2022-03-09 Los Alamos New Mexico 35028 2682 13
2286592 2286592 2022-03-08 Los Alamos New Mexico 35028 2678 13
2283340 2283340 2022-03-07 Los Alamos New Mexico 35028 2678 13
2280087 2280087 2022-03-06 Los Alamos New Mexico 35028 2671 13
2276834 2276834 2022-03-05 Los Alamos New Mexico 35028 2671 13
2273581 2273581 2022-03-04 Los Alamos New Mexico 35028 2671 13
2270329 2270329 2022-03-03 Los Alamos New Mexico 35028 2669 13
2267076 2267076 2022-03-02 Los Alamos New Mexico 35028 2658 13
2263825 2263825 2022-03-01 Los Alamos New Mexico 35028 2652 13
2260574 2260574 2022-02-28 Los Alamos New Mexico 35028 2641 13
2257323 2257323 2022-02-27 Los Alamos New Mexico 35028 2635 13
2254072 2254072 2022-02-26 Los Alamos New Mexico 35028 2635 13
2250821 2250821 2022-02-25 Los Alamos New Mexico 35028 2635 13
2247570 2247570 2022-02-24 Los Alamos New Mexico 35028 2626 13
2244319 2244319 2022-02-23 Los Alamos New Mexico 35028 2610 13
2241068 2241068 2022-02-22 Los Alamos New Mexico 35028 2608 13
2237817 2237817 2022-02-21 Los Alamos New Mexico 35028 2605 13
2234566 2234566 2022-02-20 Los Alamos New Mexico 35028 2583 13
2231315 2231315 2022-02-19 Los Alamos New Mexico 35028 2583 13
2228064 2228064 2022-02-18 Los Alamos New Mexico 35028 2583 13
2224813 2224813 2022-02-17 Los Alamos New Mexico 35028 2581 13
2221562 2221562 2022-02-16 Los Alamos New Mexico 35028 2569 13
2218311 2218311 2022-02-15 Los Alamos New Mexico 35028 2559 13
2215060 2215060 2022-02-14 Los Alamos New Mexico 35028 2551 13
2211808 2211808 2022-02-13 Los Alamos New Mexico 35028 2510 13
2208555 2208555 2022-02-12 Los Alamos New Mexico 35028 2510 13
2205302 2205302 2022-02-11 Los Alamos New Mexico 35028 2510 13
2202049 2202049 2022-02-10 Los Alamos New Mexico 35028 2498 12
2198795 2198795 2022-02-09 Los Alamos New Mexico 35028 2489 12
2195541 2195541 2022-02-08 Los Alamos New Mexico 35028 2479 12
2192287 2192287 2022-02-07 Los Alamos New Mexico 35028 2478 12
2189034 2189034 2022-02-06 Los Alamos New Mexico 35028 2456 12
2185781 2185781 2022-02-05 Los Alamos New Mexico 35028 2456 12
2182529 2182529 2022-02-04 Los Alamos New Mexico 35028 2456 12
2179277 2179277 2022-02-03 Los Alamos New Mexico 35028 2448 12

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