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

749 rows where county = "Union" 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 · 749 ✖

fips 1

county 1

  • Union · 749 ✖
Link rowid date ▲ county state fips cases deaths
2501425 2501425 2022-05-13 Union New Mexico 35059 1007 16
2498167 2498167 2022-05-12 Union New Mexico 35059 1007 16
2494909 2494909 2022-05-11 Union New Mexico 35059 1008 16
2491651 2491651 2022-05-10 Union New Mexico 35059 1007 16
2488393 2488393 2022-05-09 Union New Mexico 35059 1007 16
2485136 2485136 2022-05-08 Union New Mexico 35059 1008 16
2481878 2481878 2022-05-07 Union New Mexico 35059 1008 16
2478620 2478620 2022-05-06 Union New Mexico 35059 1008 16
2475362 2475362 2022-05-05 Union New Mexico 35059 1008 16
2472105 2472105 2022-05-04 Union New Mexico 35059 1008 16
2468849 2468849 2022-05-03 Union New Mexico 35059 1008 16
2465593 2465593 2022-05-02 Union New Mexico 35059 1008 16
2462338 2462338 2022-05-01 Union New Mexico 35059 1008 16
2459082 2459082 2022-04-30 Union New Mexico 35059 1008 16
2455826 2455826 2022-04-29 Union New Mexico 35059 1008 16
2452570 2452570 2022-04-28 Union New Mexico 35059 1008 16
2449314 2449314 2022-04-27 Union New Mexico 35059 1005 16
2446057 2446057 2022-04-26 Union New Mexico 35059 1005 16
2442802 2442802 2022-04-25 Union New Mexico 35059 1005 16
2439546 2439546 2022-04-24 Union New Mexico 35059 1005 16
2436290 2436290 2022-04-23 Union New Mexico 35059 1005 16
2433034 2433034 2022-04-22 Union New Mexico 35059 1005 16
2429778 2429778 2022-04-21 Union New Mexico 35059 1005 16
2426522 2426522 2022-04-20 Union New Mexico 35059 1005 16
2423266 2423266 2022-04-19 Union New Mexico 35059 1005 16
2420009 2420009 2022-04-18 Union New Mexico 35059 1005 16
2416754 2416754 2022-04-17 Union New Mexico 35059 1005 16
2413498 2413498 2022-04-16 Union New Mexico 35059 1005 16
2410242 2410242 2022-04-15 Union New Mexico 35059 1005 16
2406986 2406986 2022-04-14 Union New Mexico 35059 1004 16
2403730 2403730 2022-04-13 Union New Mexico 35059 1004 16
2400475 2400475 2022-04-12 Union New Mexico 35059 1004 15
2397220 2397220 2022-04-11 Union New Mexico 35059 1004 15
2393965 2393965 2022-04-10 Union New Mexico 35059 1003 15
2390709 2390709 2022-04-09 Union New Mexico 35059 1003 15
2387453 2387453 2022-04-08 Union New Mexico 35059 1003 15
2384198 2384198 2022-04-07 Union New Mexico 35059 1002 15
2380943 2380943 2022-04-06 Union New Mexico 35059 1002 15
2377688 2377688 2022-04-05 Union New Mexico 35059 1002 15
2374435 2374435 2022-04-04 Union New Mexico 35059 1002 15
2371183 2371183 2022-04-03 Union New Mexico 35059 1001 15
2367930 2367930 2022-04-02 Union New Mexico 35059 1001 15
2364677 2364677 2022-04-01 Union New Mexico 35059 1001 15
2361423 2361423 2022-03-31 Union New Mexico 35059 1001 15
2358169 2358169 2022-03-30 Union New Mexico 35059 1001 15
2354916 2354916 2022-03-29 Union New Mexico 35059 1001 15
2351663 2351663 2022-03-28 Union New Mexico 35059 1001 15
2348411 2348411 2022-03-27 Union New Mexico 35059 1001 15
2345158 2345158 2022-03-26 Union New Mexico 35059 1001 15
2341905 2341905 2022-03-25 Union New Mexico 35059 1001 15
2338652 2338652 2022-03-24 Union New Mexico 35059 1001 15
2335398 2335398 2022-03-23 Union New Mexico 35059 1001 15
2332144 2332144 2022-03-22 Union New Mexico 35059 1000 15
2328891 2328891 2022-03-21 Union New Mexico 35059 1000 15
2325639 2325639 2022-03-20 Union New Mexico 35059 1000 15
2322385 2322385 2022-03-19 Union New Mexico 35059 1000 15
2319131 2319131 2022-03-18 Union New Mexico 35059 1000 15
2315878 2315878 2022-03-17 Union New Mexico 35059 1000 15
2312625 2312625 2022-03-16 Union New Mexico 35059 1000 15
2309372 2309372 2022-03-15 Union New Mexico 35059 1000 15
2306119 2306119 2022-03-14 Union New Mexico 35059 1000 15
2302868 2302868 2022-03-13 Union New Mexico 35059 1000 15
2299616 2299616 2022-03-12 Union New Mexico 35059 1000 15
2296364 2296364 2022-03-11 Union New Mexico 35059 1000 15
2293112 2293112 2022-03-10 Union New Mexico 35059 999 15
2289860 2289860 2022-03-09 Union New Mexico 35059 999 15
2286608 2286608 2022-03-08 Union New Mexico 35059 998 15
2283356 2283356 2022-03-07 Union New Mexico 35059 998 14
2280103 2280103 2022-03-06 Union New Mexico 35059 997 14
2276850 2276850 2022-03-05 Union New Mexico 35059 997 14
2273597 2273597 2022-03-04 Union New Mexico 35059 997 14
2270345 2270345 2022-03-03 Union New Mexico 35059 996 14
2267092 2267092 2022-03-02 Union New Mexico 35059 995 14
2263841 2263841 2022-03-01 Union New Mexico 35059 995 14
2260590 2260590 2022-02-28 Union New Mexico 35059 994 14
2257339 2257339 2022-02-27 Union New Mexico 35059 994 14
2254088 2254088 2022-02-26 Union New Mexico 35059 994 14
2250837 2250837 2022-02-25 Union New Mexico 35059 994 14
2247586 2247586 2022-02-24 Union New Mexico 35059 989 14
2244335 2244335 2022-02-23 Union New Mexico 35059 989 14
2241084 2241084 2022-02-22 Union New Mexico 35059 987 12
2237833 2237833 2022-02-21 Union New Mexico 35059 990 12
2234582 2234582 2022-02-20 Union New Mexico 35059 982 12
2231331 2231331 2022-02-19 Union New Mexico 35059 982 12
2228080 2228080 2022-02-18 Union New Mexico 35059 982 12
2224829 2224829 2022-02-17 Union New Mexico 35059 982 12
2221578 2221578 2022-02-16 Union New Mexico 35059 978 12
2218327 2218327 2022-02-15 Union New Mexico 35059 976 12
2215076 2215076 2022-02-14 Union New Mexico 35059 973 12
2211824 2211824 2022-02-13 Union New Mexico 35059 967 12
2208571 2208571 2022-02-12 Union New Mexico 35059 967 12
2205318 2205318 2022-02-11 Union New Mexico 35059 967 12
2202065 2202065 2022-02-10 Union New Mexico 35059 963 12
2198811 2198811 2022-02-09 Union New Mexico 35059 961 12
2195557 2195557 2022-02-08 Union New Mexico 35059 960 12
2192303 2192303 2022-02-07 Union New Mexico 35059 956 12
2189050 2189050 2022-02-06 Union New Mexico 35059 949 12
2185797 2185797 2022-02-05 Union New Mexico 35059 949 12
2182545 2182545 2022-02-04 Union New Mexico 35059 949 12
2179293 2179293 2022-02-03 Union New Mexico 35059 948 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);