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

763 rows where fips = 35037 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 · 763 ✖

fips 1

  • 35037 · 763 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2501414 2501414 2022-05-13 Quay New Mexico 35037 2006 54
2498156 2498156 2022-05-12 Quay New Mexico 35037 2006 54
2494898 2494898 2022-05-11 Quay New Mexico 35037 2005 54
2491640 2491640 2022-05-10 Quay New Mexico 35037 2005 54
2488382 2488382 2022-05-09 Quay New Mexico 35037 2004 54
2485125 2485125 2022-05-08 Quay New Mexico 35037 2003 54
2481867 2481867 2022-05-07 Quay New Mexico 35037 2003 54
2478609 2478609 2022-05-06 Quay New Mexico 35037 2003 54
2475351 2475351 2022-05-05 Quay New Mexico 35037 2003 54
2472094 2472094 2022-05-04 Quay New Mexico 35037 2002 53
2468838 2468838 2022-05-03 Quay New Mexico 35037 2002 53
2465582 2465582 2022-05-02 Quay New Mexico 35037 2002 52
2462327 2462327 2022-05-01 Quay New Mexico 35037 2003 52
2459071 2459071 2022-04-30 Quay New Mexico 35037 2003 52
2455815 2455815 2022-04-29 Quay New Mexico 35037 2003 52
2452559 2452559 2022-04-28 Quay New Mexico 35037 2003 52
2449303 2449303 2022-04-27 Quay New Mexico 35037 2004 51
2446046 2446046 2022-04-26 Quay New Mexico 35037 2004 51
2442791 2442791 2022-04-25 Quay New Mexico 35037 2004 51
2439535 2439535 2022-04-24 Quay New Mexico 35037 2004 51
2436279 2436279 2022-04-23 Quay New Mexico 35037 2004 51
2433023 2433023 2022-04-22 Quay New Mexico 35037 2004 51
2429767 2429767 2022-04-21 Quay New Mexico 35037 2002 51
2426511 2426511 2022-04-20 Quay New Mexico 35037 2002 51
2423255 2423255 2022-04-19 Quay New Mexico 35037 2001 51
2419998 2419998 2022-04-18 Quay New Mexico 35037 2000 51
2416743 2416743 2022-04-17 Quay New Mexico 35037 2000 51
2413487 2413487 2022-04-16 Quay New Mexico 35037 2000 51
2410231 2410231 2022-04-15 Quay New Mexico 35037 2000 51
2406975 2406975 2022-04-14 Quay New Mexico 35037 2000 51
2403719 2403719 2022-04-13 Quay New Mexico 35037 1999 51
2400464 2400464 2022-04-12 Quay New Mexico 35037 1999 51
2397209 2397209 2022-04-11 Quay New Mexico 35037 1998 51
2393954 2393954 2022-04-10 Quay New Mexico 35037 1997 51
2390698 2390698 2022-04-09 Quay New Mexico 35037 1997 51
2387442 2387442 2022-04-08 Quay New Mexico 35037 1997 51
2384187 2384187 2022-04-07 Quay New Mexico 35037 1997 51
2380932 2380932 2022-04-06 Quay New Mexico 35037 1996 50
2377677 2377677 2022-04-05 Quay New Mexico 35037 1996 50
2374424 2374424 2022-04-04 Quay New Mexico 35037 1996 50
2371172 2371172 2022-04-03 Quay New Mexico 35037 1994 50
2367919 2367919 2022-04-02 Quay New Mexico 35037 1994 50
2364666 2364666 2022-04-01 Quay New Mexico 35037 1994 50
2361412 2361412 2022-03-31 Quay New Mexico 35037 1993 50
2358158 2358158 2022-03-30 Quay New Mexico 35037 1993 49
2354905 2354905 2022-03-29 Quay New Mexico 35037 1993 49
2351652 2351652 2022-03-28 Quay New Mexico 35037 1993 49
2348400 2348400 2022-03-27 Quay New Mexico 35037 1992 49
2345147 2345147 2022-03-26 Quay New Mexico 35037 1992 49
2341894 2341894 2022-03-25 Quay New Mexico 35037 1992 49
2338641 2338641 2022-03-24 Quay New Mexico 35037 1991 49
2335387 2335387 2022-03-23 Quay New Mexico 35037 1989 49
2332133 2332133 2022-03-22 Quay New Mexico 35037 1988 49
2328880 2328880 2022-03-21 Quay New Mexico 35037 1988 49
2325628 2325628 2022-03-20 Quay New Mexico 35037 1987 49
2322374 2322374 2022-03-19 Quay New Mexico 35037 1987 49
2319120 2319120 2022-03-18 Quay New Mexico 35037 1987 49
2315867 2315867 2022-03-17 Quay New Mexico 35037 1987 49
2312614 2312614 2022-03-16 Quay New Mexico 35037 1985 49
2309361 2309361 2022-03-15 Quay New Mexico 35037 1985 49
2306108 2306108 2022-03-14 Quay New Mexico 35037 1981 49
2302857 2302857 2022-03-13 Quay New Mexico 35037 1981 49
2299605 2299605 2022-03-12 Quay New Mexico 35037 1981 49
2296353 2296353 2022-03-11 Quay New Mexico 35037 1981 49
2293101 2293101 2022-03-10 Quay New Mexico 35037 1976 49
2289849 2289849 2022-03-09 Quay New Mexico 35037 1975 49
2286597 2286597 2022-03-08 Quay New Mexico 35037 1975 49
2283345 2283345 2022-03-07 Quay New Mexico 35037 1974 49
2280092 2280092 2022-03-06 Quay New Mexico 35037 1973 49
2276839 2276839 2022-03-05 Quay New Mexico 35037 1973 49
2273586 2273586 2022-03-04 Quay New Mexico 35037 1973 49
2270334 2270334 2022-03-03 Quay New Mexico 35037 1973 48
2267081 2267081 2022-03-02 Quay New Mexico 35037 1972 48
2263830 2263830 2022-03-01 Quay New Mexico 35037 1972 48
2260579 2260579 2022-02-28 Quay New Mexico 35037 1969 48
2257328 2257328 2022-02-27 Quay New Mexico 35037 1969 48
2254077 2254077 2022-02-26 Quay New Mexico 35037 1969 48
2250826 2250826 2022-02-25 Quay New Mexico 35037 1969 48
2247575 2247575 2022-02-24 Quay New Mexico 35037 1968 47
2244324 2244324 2022-02-23 Quay New Mexico 35037 1966 47
2241073 2241073 2022-02-22 Quay New Mexico 35037 1964 47
2237822 2237822 2022-02-21 Quay New Mexico 35037 1964 47
2234571 2234571 2022-02-20 Quay New Mexico 35037 1961 47
2231320 2231320 2022-02-19 Quay New Mexico 35037 1961 47
2228069 2228069 2022-02-18 Quay New Mexico 35037 1961 47
2224818 2224818 2022-02-17 Quay New Mexico 35037 1958 47
2221567 2221567 2022-02-16 Quay New Mexico 35037 1956 47
2218316 2218316 2022-02-15 Quay New Mexico 35037 1954 46
2215065 2215065 2022-02-14 Quay New Mexico 35037 1953 44
2211813 2211813 2022-02-13 Quay New Mexico 35037 1943 44
2208560 2208560 2022-02-12 Quay New Mexico 35037 1943 44
2205307 2205307 2022-02-11 Quay New Mexico 35037 1943 44
2202054 2202054 2022-02-10 Quay New Mexico 35037 1941 44
2198800 2198800 2022-02-09 Quay New Mexico 35037 1938 42
2195546 2195546 2022-02-08 Quay New Mexico 35037 1935 39
2192292 2192292 2022-02-07 Quay New Mexico 35037 1932 39
2189039 2189039 2022-02-06 Quay New Mexico 35037 1924 39
2185786 2185786 2022-02-05 Quay New Mexico 35037 1924 39
2182534 2182534 2022-02-04 Quay New Mexico 35037 1924 39
2179282 2179282 2022-02-03 Quay New Mexico 35037 1918 39

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