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

767 rows where county = "Marshall" and state = "Oklahoma" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Oklahoma · 767 ✖

fips 1

county 1

  • Marshall · 767 ✖
Link rowid date ▲ county state fips cases deaths
2501777 2501777 2022-05-13 Marshall Oklahoma 40095 4603 46
2498519 2498519 2022-05-12 Marshall Oklahoma 40095 4603 46
2495261 2495261 2022-05-11 Marshall Oklahoma 40095 4604 46
2492003 2492003 2022-05-10 Marshall Oklahoma 40095 4604 46
2488745 2488745 2022-05-09 Marshall Oklahoma 40095 4604 46
2485488 2485488 2022-05-08 Marshall Oklahoma 40095 4604 46
2482230 2482230 2022-05-07 Marshall Oklahoma 40095 4604 46
2478972 2478972 2022-05-06 Marshall Oklahoma 40095 4604 46
2475714 2475714 2022-05-05 Marshall Oklahoma 40095 4604 46
2472457 2472457 2022-05-04 Marshall Oklahoma 40095 4602 44
2469201 2469201 2022-05-03 Marshall Oklahoma 40095 4602 44
2465945 2465945 2022-05-02 Marshall Oklahoma 40095 4602 44
2462690 2462690 2022-05-01 Marshall Oklahoma 40095 4602 44
2459434 2459434 2022-04-30 Marshall Oklahoma 40095 4602 44
2456178 2456178 2022-04-29 Marshall Oklahoma 40095 4602 44
2452922 2452922 2022-04-28 Marshall Oklahoma 40095 4602 44
2449666 2449666 2022-04-27 Marshall Oklahoma 40095 4605 43
2446409 2446409 2022-04-26 Marshall Oklahoma 40095 4605 43
2443154 2443154 2022-04-25 Marshall Oklahoma 40095 4605 43
2439898 2439898 2022-04-24 Marshall Oklahoma 40095 4605 43
2436642 2436642 2022-04-23 Marshall Oklahoma 40095 4605 43
2433386 2433386 2022-04-22 Marshall Oklahoma 40095 4605 43
2430130 2430130 2022-04-21 Marshall Oklahoma 40095 4605 43
2426874 2426874 2022-04-20 Marshall Oklahoma 40095 4602 43
2423618 2423618 2022-04-19 Marshall Oklahoma 40095 4602 43
2420361 2420361 2022-04-18 Marshall Oklahoma 40095 4602 43
2417106 2417106 2022-04-17 Marshall Oklahoma 40095 4602 43
2413850 2413850 2022-04-16 Marshall Oklahoma 40095 4602 43
2410594 2410594 2022-04-15 Marshall Oklahoma 40095 4602 43
2407338 2407338 2022-04-14 Marshall Oklahoma 40095 4602 43
2404082 2404082 2022-04-13 Marshall Oklahoma 40095 4603 42
2400827 2400827 2022-04-12 Marshall Oklahoma 40095 4603 42
2397572 2397572 2022-04-11 Marshall Oklahoma 40095 4603 42
2394317 2394317 2022-04-10 Marshall Oklahoma 40095 4603 42
2391061 2391061 2022-04-09 Marshall Oklahoma 40095 4603 42
2387805 2387805 2022-04-08 Marshall Oklahoma 40095 4603 42
2384550 2384550 2022-04-07 Marshall Oklahoma 40095 4603 42
2381295 2381295 2022-04-06 Marshall Oklahoma 40095 4598 42
2378040 2378040 2022-04-05 Marshall Oklahoma 40095 4598 42
2374786 2374786 2022-04-04 Marshall Oklahoma 40095 4598 42
2371534 2371534 2022-04-03 Marshall Oklahoma 40095 4598 42
2368281 2368281 2022-04-02 Marshall Oklahoma 40095 4598 42
2365028 2365028 2022-04-01 Marshall Oklahoma 40095 4598 42
2361775 2361775 2022-03-31 Marshall Oklahoma 40095 4598 42
2358521 2358521 2022-03-30 Marshall Oklahoma 40095 4591 42
2355267 2355267 2022-03-29 Marshall Oklahoma 40095 4591 42
2352014 2352014 2022-03-28 Marshall Oklahoma 40095 4591 42
2348762 2348762 2022-03-27 Marshall Oklahoma 40095 4591 42
2345509 2345509 2022-03-26 Marshall Oklahoma 40095 4591 42
2342256 2342256 2022-03-25 Marshall Oklahoma 40095 4591 42
2339003 2339003 2022-03-24 Marshall Oklahoma 40095 4591 42
2335749 2335749 2022-03-23 Marshall Oklahoma 40095 4588 40
2332495 2332495 2022-03-22 Marshall Oklahoma 40095 4588 40
2329242 2329242 2022-03-21 Marshall Oklahoma 40095 4588 40
2325990 2325990 2022-03-20 Marshall Oklahoma 40095 4588 40
2322737 2322737 2022-03-19 Marshall Oklahoma 40095 4588 40
2319483 2319483 2022-03-18 Marshall Oklahoma 40095 4588 40
2316229 2316229 2022-03-17 Marshall Oklahoma 40095 4588 40
2312976 2312976 2022-03-16 Marshall Oklahoma 40095 4584 40
2309723 2309723 2022-03-15 Marshall Oklahoma 40095 4584 40
2306470 2306470 2022-03-14 Marshall Oklahoma 40095 4584 40
2303219 2303219 2022-03-13 Marshall Oklahoma 40095 4584 40
2299967 2299967 2022-03-12 Marshall Oklahoma 40095 4584 40
2296715 2296715 2022-03-11 Marshall Oklahoma 40095 4584 40
2293463 2293463 2022-03-10 Marshall Oklahoma 40095 4584 40
2290211 2290211 2022-03-09 Marshall Oklahoma 40095 4527 39
2286959 2286959 2022-03-08 Marshall Oklahoma 40095 4527 39
2283707 2283707 2022-03-07 Marshall Oklahoma 40095 4527 39
2280455 2280455 2022-03-06 Marshall Oklahoma 40095 4527 39
2277202 2277202 2022-03-05 Marshall Oklahoma 40095 4527 39
2273949 2273949 2022-03-04 Marshall Oklahoma 40095 4527 39
2270696 2270696 2022-03-03 Marshall Oklahoma 40095 4527 39
2267444 2267444 2022-03-02 Marshall Oklahoma 40095 4527 39
2264191 2264191 2022-03-01 Marshall Oklahoma 40095 4507 38
2260941 2260941 2022-02-28 Marshall Oklahoma 40095 4507 38
2257690 2257690 2022-02-27 Marshall Oklahoma 40095 4507 38
2254439 2254439 2022-02-26 Marshall Oklahoma 40095 4507 38
2251188 2251188 2022-02-25 Marshall Oklahoma 40095 4507 38
2247937 2247937 2022-02-24 Marshall Oklahoma 40095 4507 38
2244686 2244686 2022-02-23 Marshall Oklahoma 40095 4507 38
2241435 2241435 2022-02-22 Marshall Oklahoma 40095 4487 36
2238184 2238184 2022-02-21 Marshall Oklahoma 40095 4487 36
2234933 2234933 2022-02-20 Marshall Oklahoma 40095 4487 36
2231682 2231682 2022-02-19 Marshall Oklahoma 40095 4487 36
2228431 2228431 2022-02-18 Marshall Oklahoma 40095 4487 36
2225180 2225180 2022-02-17 Marshall Oklahoma 40095 4487 36
2221929 2221929 2022-02-16 Marshall Oklahoma 40095 4487 36
2218678 2218678 2022-02-15 Marshall Oklahoma 40095 4444 34
2215427 2215427 2022-02-14 Marshall Oklahoma 40095 4444 34
2212176 2212176 2022-02-13 Marshall Oklahoma 40095 4444 34
2208923 2208923 2022-02-12 Marshall Oklahoma 40095 4444 34
2205670 2205670 2022-02-11 Marshall Oklahoma 40095 4444 34
2202417 2202417 2022-02-10 Marshall Oklahoma 40095 4444 34
2199163 2199163 2022-02-09 Marshall Oklahoma 40095 4444 34
2195909 2195909 2022-02-08 Marshall Oklahoma 40095 4355 32
2192655 2192655 2022-02-07 Marshall Oklahoma 40095 4355 32
2189401 2189401 2022-02-06 Marshall Oklahoma 40095 4355 32
2186148 2186148 2022-02-05 Marshall Oklahoma 40095 4355 32
2182896 2182896 2022-02-04 Marshall Oklahoma 40095 4355 32
2179644 2179644 2022-02-03 Marshall Oklahoma 40095 4355 32

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