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

751 rows where fips = 35021 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

  • 35021 · 751 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2501405 2501405 2022-05-13 Harding New Mexico 35021 85 4
2498147 2498147 2022-05-12 Harding New Mexico 35021 85 4
2494889 2494889 2022-05-11 Harding New Mexico 35021 85 4
2491631 2491631 2022-05-10 Harding New Mexico 35021 85 4
2488373 2488373 2022-05-09 Harding New Mexico 35021 85 4
2485116 2485116 2022-05-08 Harding New Mexico 35021 85 4
2481858 2481858 2022-05-07 Harding New Mexico 35021 85 4
2478600 2478600 2022-05-06 Harding New Mexico 35021 85 4
2475342 2475342 2022-05-05 Harding New Mexico 35021 85 4
2472085 2472085 2022-05-04 Harding New Mexico 35021 85 4
2468829 2468829 2022-05-03 Harding New Mexico 35021 85 4
2465573 2465573 2022-05-02 Harding New Mexico 35021 85 4
2462318 2462318 2022-05-01 Harding New Mexico 35021 85 4
2459062 2459062 2022-04-30 Harding New Mexico 35021 85 4
2455806 2455806 2022-04-29 Harding New Mexico 35021 85 4
2452550 2452550 2022-04-28 Harding New Mexico 35021 85 4
2449294 2449294 2022-04-27 Harding New Mexico 35021 83 4
2446037 2446037 2022-04-26 Harding New Mexico 35021 83 4
2442782 2442782 2022-04-25 Harding New Mexico 35021 83 4
2439526 2439526 2022-04-24 Harding New Mexico 35021 83 4
2436270 2436270 2022-04-23 Harding New Mexico 35021 83 4
2433014 2433014 2022-04-22 Harding New Mexico 35021 83 4
2429758 2429758 2022-04-21 Harding New Mexico 35021 83 4
2426502 2426502 2022-04-20 Harding New Mexico 35021 83 4
2423246 2423246 2022-04-19 Harding New Mexico 35021 83 4
2419989 2419989 2022-04-18 Harding New Mexico 35021 83 4
2416734 2416734 2022-04-17 Harding New Mexico 35021 83 4
2413478 2413478 2022-04-16 Harding New Mexico 35021 83 4
2410222 2410222 2022-04-15 Harding New Mexico 35021 83 4
2406966 2406966 2022-04-14 Harding New Mexico 35021 83 4
2403710 2403710 2022-04-13 Harding New Mexico 35021 83 4
2400455 2400455 2022-04-12 Harding New Mexico 35021 83 4
2397200 2397200 2022-04-11 Harding New Mexico 35021 83 4
2393945 2393945 2022-04-10 Harding New Mexico 35021 83 4
2390689 2390689 2022-04-09 Harding New Mexico 35021 83 4
2387433 2387433 2022-04-08 Harding New Mexico 35021 83 4
2384178 2384178 2022-04-07 Harding New Mexico 35021 83 4
2380923 2380923 2022-04-06 Harding New Mexico 35021 83 4
2377668 2377668 2022-04-05 Harding New Mexico 35021 83 4
2374415 2374415 2022-04-04 Harding New Mexico 35021 83 4
2371163 2371163 2022-04-03 Harding New Mexico 35021 83 4
2367910 2367910 2022-04-02 Harding New Mexico 35021 83 4
2364657 2364657 2022-04-01 Harding New Mexico 35021 83 4
2361403 2361403 2022-03-31 Harding New Mexico 35021 83 4
2358149 2358149 2022-03-30 Harding New Mexico 35021 83 4
2354896 2354896 2022-03-29 Harding New Mexico 35021 81 4
2351643 2351643 2022-03-28 Harding New Mexico 35021 81 4
2348391 2348391 2022-03-27 Harding New Mexico 35021 81 4
2345138 2345138 2022-03-26 Harding New Mexico 35021 81 4
2341885 2341885 2022-03-25 Harding New Mexico 35021 81 4
2338632 2338632 2022-03-24 Harding New Mexico 35021 81 4
2335378 2335378 2022-03-23 Harding New Mexico 35021 81 4
2332124 2332124 2022-03-22 Harding New Mexico 35021 81 4
2328871 2328871 2022-03-21 Harding New Mexico 35021 81 4
2325619 2325619 2022-03-20 Harding New Mexico 35021 81 4
2322365 2322365 2022-03-19 Harding New Mexico 35021 81 4
2319111 2319111 2022-03-18 Harding New Mexico 35021 81 4
2315858 2315858 2022-03-17 Harding New Mexico 35021 81 4
2312605 2312605 2022-03-16 Harding New Mexico 35021 81 4
2309352 2309352 2022-03-15 Harding New Mexico 35021 81 4
2306099 2306099 2022-03-14 Harding New Mexico 35021 81 4
2302848 2302848 2022-03-13 Harding New Mexico 35021 81 4
2299596 2299596 2022-03-12 Harding New Mexico 35021 81 4
2296344 2296344 2022-03-11 Harding New Mexico 35021 81 4
2293092 2293092 2022-03-10 Harding New Mexico 35021 81 4
2289840 2289840 2022-03-09 Harding New Mexico 35021 80 4
2286588 2286588 2022-03-08 Harding New Mexico 35021 80 4
2283336 2283336 2022-03-07 Harding New Mexico 35021 80 4
2280083 2280083 2022-03-06 Harding New Mexico 35021 78 4
2276830 2276830 2022-03-05 Harding New Mexico 35021 78 4
2273577 2273577 2022-03-04 Harding New Mexico 35021 78 4
2270325 2270325 2022-03-03 Harding New Mexico 35021 78 4
2267072 2267072 2022-03-02 Harding New Mexico 35021 77 4
2263821 2263821 2022-03-01 Harding New Mexico 35021 77 4
2260570 2260570 2022-02-28 Harding New Mexico 35021 75 4
2257319 2257319 2022-02-27 Harding New Mexico 35021 75 4
2254068 2254068 2022-02-26 Harding New Mexico 35021 75 4
2250817 2250817 2022-02-25 Harding New Mexico 35021 75 4
2247566 2247566 2022-02-24 Harding New Mexico 35021 75 4
2244315 2244315 2022-02-23 Harding New Mexico 35021 74 4
2241064 2241064 2022-02-22 Harding New Mexico 35021 74 4
2237813 2237813 2022-02-21 Harding New Mexico 35021 74 4
2234562 2234562 2022-02-20 Harding New Mexico 35021 74 4
2231311 2231311 2022-02-19 Harding New Mexico 35021 74 4
2228060 2228060 2022-02-18 Harding New Mexico 35021 74 4
2224809 2224809 2022-02-17 Harding New Mexico 35021 74 4
2221558 2221558 2022-02-16 Harding New Mexico 35021 74 4
2218307 2218307 2022-02-15 Harding New Mexico 35021 74 4
2215056 2215056 2022-02-14 Harding New Mexico 35021 74 4
2211804 2211804 2022-02-13 Harding New Mexico 35021 74 4
2208551 2208551 2022-02-12 Harding New Mexico 35021 74 4
2205298 2205298 2022-02-11 Harding New Mexico 35021 74 4
2202045 2202045 2022-02-10 Harding New Mexico 35021 74 4
2198791 2198791 2022-02-09 Harding New Mexico 35021 74 4
2195537 2195537 2022-02-08 Harding New Mexico 35021 74 4
2192283 2192283 2022-02-07 Harding New Mexico 35021 73 4
2189030 2189030 2022-02-06 Harding New Mexico 35021 72 4
2185777 2185777 2022-02-05 Harding New Mexico 35021 72 4
2182525 2182525 2022-02-04 Harding New Mexico 35021 72 4
2179273 2179273 2022-02-03 Harding New Mexico 35021 72 4

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