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

775 rows where fips = 38065 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

  • 38065 · 775 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2501618 2501618 2022-05-13 Oliver North Dakota 38065 329 5
2498360 2498360 2022-05-12 Oliver North Dakota 38065 329 5
2495102 2495102 2022-05-11 Oliver North Dakota 38065 329 5
2491844 2491844 2022-05-10 Oliver North Dakota 38065 329 5
2488586 2488586 2022-05-09 Oliver North Dakota 38065 329 5
2485329 2485329 2022-05-08 Oliver North Dakota 38065 329 5
2482071 2482071 2022-05-07 Oliver North Dakota 38065 329 5
2478813 2478813 2022-05-06 Oliver North Dakota 38065 329 5
2475555 2475555 2022-05-05 Oliver North Dakota 38065 329 5
2472298 2472298 2022-05-04 Oliver North Dakota 38065 329 5
2469042 2469042 2022-05-03 Oliver North Dakota 38065 329 5
2465786 2465786 2022-05-02 Oliver North Dakota 38065 329 5
2462531 2462531 2022-05-01 Oliver North Dakota 38065 329 5
2459275 2459275 2022-04-30 Oliver North Dakota 38065 329 5
2456019 2456019 2022-04-29 Oliver North Dakota 38065 329 5
2452763 2452763 2022-04-28 Oliver North Dakota 38065 329 5
2449507 2449507 2022-04-27 Oliver North Dakota 38065 329 5
2446250 2446250 2022-04-26 Oliver North Dakota 38065 329 5
2442995 2442995 2022-04-25 Oliver North Dakota 38065 329 5
2439739 2439739 2022-04-24 Oliver North Dakota 38065 329 5
2436483 2436483 2022-04-23 Oliver North Dakota 38065 329 5
2433227 2433227 2022-04-22 Oliver North Dakota 38065 329 5
2429971 2429971 2022-04-21 Oliver North Dakota 38065 329 5
2426715 2426715 2022-04-20 Oliver North Dakota 38065 329 5
2423459 2423459 2022-04-19 Oliver North Dakota 38065 329 5
2420202 2420202 2022-04-18 Oliver North Dakota 38065 329 5
2416947 2416947 2022-04-17 Oliver North Dakota 38065 329 5
2413691 2413691 2022-04-16 Oliver North Dakota 38065 329 5
2410435 2410435 2022-04-15 Oliver North Dakota 38065 329 5
2407179 2407179 2022-04-14 Oliver North Dakota 38065 329 5
2403923 2403923 2022-04-13 Oliver North Dakota 38065 329 5
2400668 2400668 2022-04-12 Oliver North Dakota 38065 329 5
2397413 2397413 2022-04-11 Oliver North Dakota 38065 329 5
2394158 2394158 2022-04-10 Oliver North Dakota 38065 329 5
2390902 2390902 2022-04-09 Oliver North Dakota 38065 329 5
2387646 2387646 2022-04-08 Oliver North Dakota 38065 329 5
2384391 2384391 2022-04-07 Oliver North Dakota 38065 329 5
2381136 2381136 2022-04-06 Oliver North Dakota 38065 329 5
2377881 2377881 2022-04-05 Oliver North Dakota 38065 329 5
2374628 2374628 2022-04-04 Oliver North Dakota 38065 329 5
2371376 2371376 2022-04-03 Oliver North Dakota 38065 329 5
2368123 2368123 2022-04-02 Oliver North Dakota 38065 329 5
2364870 2364870 2022-04-01 Oliver North Dakota 38065 329 5
2361616 2361616 2022-03-31 Oliver North Dakota 38065 329 5
2358362 2358362 2022-03-30 Oliver North Dakota 38065 329 5
2355108 2355108 2022-03-29 Oliver North Dakota 38065 329 5
2351855 2351855 2022-03-28 Oliver North Dakota 38065 329 5
2348603 2348603 2022-03-27 Oliver North Dakota 38065 329 5
2345350 2345350 2022-03-26 Oliver North Dakota 38065 329 5
2342097 2342097 2022-03-25 Oliver North Dakota 38065 329 5
2338844 2338844 2022-03-24 Oliver North Dakota 38065 328 5
2335590 2335590 2022-03-23 Oliver North Dakota 38065 328 5
2332336 2332336 2022-03-22 Oliver North Dakota 38065 328 5
2329083 2329083 2022-03-21 Oliver North Dakota 38065 328 5
2325831 2325831 2022-03-20 Oliver North Dakota 38065 328 5
2322578 2322578 2022-03-19 Oliver North Dakota 38065 328 5
2319324 2319324 2022-03-18 Oliver North Dakota 38065 328 5
2316070 2316070 2022-03-17 Oliver North Dakota 38065 326 5
2312817 2312817 2022-03-16 Oliver North Dakota 38065 326 5
2309564 2309564 2022-03-15 Oliver North Dakota 38065 326 5
2306311 2306311 2022-03-14 Oliver North Dakota 38065 326 5
2303060 2303060 2022-03-13 Oliver North Dakota 38065 326 5
2299808 2299808 2022-03-12 Oliver North Dakota 38065 326 5
2296556 2296556 2022-03-11 Oliver North Dakota 38065 326 5
2293304 2293304 2022-03-10 Oliver North Dakota 38065 326 5
2290052 2290052 2022-03-09 Oliver North Dakota 38065 326 5
2286800 2286800 2022-03-08 Oliver North Dakota 38065 326 5
2283548 2283548 2022-03-07 Oliver North Dakota 38065 326 5
2280296 2280296 2022-03-06 Oliver North Dakota 38065 326 5
2277043 2277043 2022-03-05 Oliver North Dakota 38065 326 5
2273790 2273790 2022-03-04 Oliver North Dakota 38065 326 5
2270537 2270537 2022-03-03 Oliver North Dakota 38065 326 5
2267285 2267285 2022-03-02 Oliver North Dakota 38065 326 5
2264033 2264033 2022-03-01 Oliver North Dakota 38065 326 5
2260782 2260782 2022-02-28 Oliver North Dakota 38065 326 5
2257531 2257531 2022-02-27 Oliver North Dakota 38065 326 5
2254280 2254280 2022-02-26 Oliver North Dakota 38065 326 5
2251029 2251029 2022-02-25 Oliver North Dakota 38065 326 5
2247778 2247778 2022-02-24 Oliver North Dakota 38065 326 5
2244527 2244527 2022-02-23 Oliver North Dakota 38065 326 5
2241276 2241276 2022-02-22 Oliver North Dakota 38065 326 4
2238025 2238025 2022-02-21 Oliver North Dakota 38065 326 4
2234774 2234774 2022-02-20 Oliver North Dakota 38065 326 4
2231523 2231523 2022-02-19 Oliver North Dakota 38065 325 4
2228272 2228272 2022-02-18 Oliver North Dakota 38065 325 4
2225021 2225021 2022-02-17 Oliver North Dakota 38065 325 4
2221770 2221770 2022-02-16 Oliver North Dakota 38065 324 4
2218519 2218519 2022-02-15 Oliver North Dakota 38065 323 4
2215268 2215268 2022-02-14 Oliver North Dakota 38065 323 4
2212017 2212017 2022-02-13 Oliver North Dakota 38065 321 4
2208764 2208764 2022-02-12 Oliver North Dakota 38065 321 4
2205511 2205511 2022-02-11 Oliver North Dakota 38065 319 4
2202258 2202258 2022-02-10 Oliver North Dakota 38065 319 4
2199004 2199004 2022-02-09 Oliver North Dakota 38065 319 4
2195750 2195750 2022-02-08 Oliver North Dakota 38065 316 4
2192496 2192496 2022-02-07 Oliver North Dakota 38065 316 4
2189242 2189242 2022-02-06 Oliver North Dakota 38065 316 4
2185989 2185989 2022-02-05 Oliver North Dakota 38065 316 4
2182737 2182737 2022-02-04 Oliver North Dakota 38065 316 4
2179485 2179485 2022-02-03 Oliver North Dakota 38065 315 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);