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

1,390 rows where county = "Harding" sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

state 2

fips 2

county 1

  • Harding · 1,390 ✖
Link rowid date ▲ county state fips cases deaths
2501405 2501405 2022-05-13 Harding New Mexico 35021 85 4
2502075 2502075 2022-05-13 Harding South Dakota 46063 201 3
2498147 2498147 2022-05-12 Harding New Mexico 35021 85 4
2498817 2498817 2022-05-12 Harding South Dakota 46063 201 3
2494889 2494889 2022-05-11 Harding New Mexico 35021 85 4
2495559 2495559 2022-05-11 Harding South Dakota 46063 201 3
2491631 2491631 2022-05-10 Harding New Mexico 35021 85 4
2492301 2492301 2022-05-10 Harding South Dakota 46063 201 3
2488373 2488373 2022-05-09 Harding New Mexico 35021 85 4
2489043 2489043 2022-05-09 Harding South Dakota 46063 201 3
2485116 2485116 2022-05-08 Harding New Mexico 35021 85 4
2485786 2485786 2022-05-08 Harding South Dakota 46063 201 3
2481858 2481858 2022-05-07 Harding New Mexico 35021 85 4
2482528 2482528 2022-05-07 Harding South Dakota 46063 201 3
2478600 2478600 2022-05-06 Harding New Mexico 35021 85 4
2479270 2479270 2022-05-06 Harding South Dakota 46063 201 3
2475342 2475342 2022-05-05 Harding New Mexico 35021 85 4
2476012 2476012 2022-05-05 Harding South Dakota 46063 201 3
2472085 2472085 2022-05-04 Harding New Mexico 35021 85 4
2472755 2472755 2022-05-04 Harding South Dakota 46063 201 3
2468829 2468829 2022-05-03 Harding New Mexico 35021 85 4
2469499 2469499 2022-05-03 Harding South Dakota 46063 201 3
2465573 2465573 2022-05-02 Harding New Mexico 35021 85 4
2466243 2466243 2022-05-02 Harding South Dakota 46063 201 3
2462318 2462318 2022-05-01 Harding New Mexico 35021 85 4
2462988 2462988 2022-05-01 Harding South Dakota 46063 201 3
2459062 2459062 2022-04-30 Harding New Mexico 35021 85 4
2459732 2459732 2022-04-30 Harding South Dakota 46063 201 3
2455806 2455806 2022-04-29 Harding New Mexico 35021 85 4
2456476 2456476 2022-04-29 Harding South Dakota 46063 201 3
2452550 2452550 2022-04-28 Harding New Mexico 35021 85 4
2453220 2453220 2022-04-28 Harding South Dakota 46063 201 3
2449294 2449294 2022-04-27 Harding New Mexico 35021 83 4
2449964 2449964 2022-04-27 Harding South Dakota 46063 201 3
2446037 2446037 2022-04-26 Harding New Mexico 35021 83 4
2446707 2446707 2022-04-26 Harding South Dakota 46063 201 3
2442782 2442782 2022-04-25 Harding New Mexico 35021 83 4
2443452 2443452 2022-04-25 Harding South Dakota 46063 201 3
2439526 2439526 2022-04-24 Harding New Mexico 35021 83 4
2440196 2440196 2022-04-24 Harding South Dakota 46063 201 3
2436270 2436270 2022-04-23 Harding New Mexico 35021 83 4
2436940 2436940 2022-04-23 Harding South Dakota 46063 201 3
2433014 2433014 2022-04-22 Harding New Mexico 35021 83 4
2433684 2433684 2022-04-22 Harding South Dakota 46063 201 3
2429758 2429758 2022-04-21 Harding New Mexico 35021 83 4
2430428 2430428 2022-04-21 Harding South Dakota 46063 201 3
2426502 2426502 2022-04-20 Harding New Mexico 35021 83 4
2427172 2427172 2022-04-20 Harding South Dakota 46063 201 3
2423246 2423246 2022-04-19 Harding New Mexico 35021 83 4
2423916 2423916 2022-04-19 Harding South Dakota 46063 201 3
2419989 2419989 2022-04-18 Harding New Mexico 35021 83 4
2420660 2420660 2022-04-18 Harding South Dakota 46063 201 3
2416734 2416734 2022-04-17 Harding New Mexico 35021 83 4
2417404 2417404 2022-04-17 Harding South Dakota 46063 201 3
2413478 2413478 2022-04-16 Harding New Mexico 35021 83 4
2414148 2414148 2022-04-16 Harding South Dakota 46063 201 3
2410222 2410222 2022-04-15 Harding New Mexico 35021 83 4
2410892 2410892 2022-04-15 Harding South Dakota 46063 201 3
2406966 2406966 2022-04-14 Harding New Mexico 35021 83 4
2407636 2407636 2022-04-14 Harding South Dakota 46063 201 3
2403710 2403710 2022-04-13 Harding New Mexico 35021 83 4
2404380 2404380 2022-04-13 Harding South Dakota 46063 201 3
2400455 2400455 2022-04-12 Harding New Mexico 35021 83 4
2401125 2401125 2022-04-12 Harding South Dakota 46063 201 3
2397200 2397200 2022-04-11 Harding New Mexico 35021 83 4
2397870 2397870 2022-04-11 Harding South Dakota 46063 201 3
2393945 2393945 2022-04-10 Harding New Mexico 35021 83 4
2394615 2394615 2022-04-10 Harding South Dakota 46063 201 3
2390689 2390689 2022-04-09 Harding New Mexico 35021 83 4
2391359 2391359 2022-04-09 Harding South Dakota 46063 201 3
2387433 2387433 2022-04-08 Harding New Mexico 35021 83 4
2388103 2388103 2022-04-08 Harding South Dakota 46063 201 3
2384178 2384178 2022-04-07 Harding New Mexico 35021 83 4
2384848 2384848 2022-04-07 Harding South Dakota 46063 201 3
2380923 2380923 2022-04-06 Harding New Mexico 35021 83 4
2381593 2381593 2022-04-06 Harding South Dakota 46063 201 3
2377668 2377668 2022-04-05 Harding New Mexico 35021 83 4
2378338 2378338 2022-04-05 Harding South Dakota 46063 201 3
2374415 2374415 2022-04-04 Harding New Mexico 35021 83 4
2375084 2375084 2022-04-04 Harding South Dakota 46063 201 3
2371163 2371163 2022-04-03 Harding New Mexico 35021 83 4
2371832 2371832 2022-04-03 Harding South Dakota 46063 201 3
2367910 2367910 2022-04-02 Harding New Mexico 35021 83 4
2368579 2368579 2022-04-02 Harding South Dakota 46063 201 3
2364657 2364657 2022-04-01 Harding New Mexico 35021 83 4
2365326 2365326 2022-04-01 Harding South Dakota 46063 201 3
2361403 2361403 2022-03-31 Harding New Mexico 35021 83 4
2362073 2362073 2022-03-31 Harding South Dakota 46063 201 3
2358149 2358149 2022-03-30 Harding New Mexico 35021 83 4
2358819 2358819 2022-03-30 Harding South Dakota 46063 201 3
2354896 2354896 2022-03-29 Harding New Mexico 35021 81 4
2355565 2355565 2022-03-29 Harding South Dakota 46063 201 3
2351643 2351643 2022-03-28 Harding New Mexico 35021 81 4
2352312 2352312 2022-03-28 Harding South Dakota 46063 201 3
2348391 2348391 2022-03-27 Harding New Mexico 35021 81 4
2349060 2349060 2022-03-27 Harding South Dakota 46063 201 3
2345138 2345138 2022-03-26 Harding New Mexico 35021 81 4
2345807 2345807 2022-03-26 Harding South Dakota 46063 201 3
2341885 2341885 2022-03-25 Harding New Mexico 35021 81 4
2342554 2342554 2022-03-25 Harding South Dakota 46063 201 3

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