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

743 rows where fips = 38075 and state = "North Dakota" sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

state 1

  • North Dakota · 743 ✖

fips 1

  • 38075 · 743 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2501623 2501623 2022-05-13 Renville North Dakota 38075 556 15
2498365 2498365 2022-05-12 Renville North Dakota 38075 554 15
2495107 2495107 2022-05-11 Renville North Dakota 38075 554 15
2491849 2491849 2022-05-10 Renville North Dakota 38075 554 15
2488591 2488591 2022-05-09 Renville North Dakota 38075 554 15
2485334 2485334 2022-05-08 Renville North Dakota 38075 554 15
2482076 2482076 2022-05-07 Renville North Dakota 38075 554 15
2478818 2478818 2022-05-06 Renville North Dakota 38075 554 15
2475560 2475560 2022-05-05 Renville North Dakota 38075 554 15
2472303 2472303 2022-05-04 Renville North Dakota 38075 554 15
2469047 2469047 2022-05-03 Renville North Dakota 38075 554 15
2465791 2465791 2022-05-02 Renville North Dakota 38075 554 15
2462536 2462536 2022-05-01 Renville North Dakota 38075 554 15
2459280 2459280 2022-04-30 Renville North Dakota 38075 554 15
2456024 2456024 2022-04-29 Renville North Dakota 38075 554 15
2452768 2452768 2022-04-28 Renville North Dakota 38075 550 15
2449512 2449512 2022-04-27 Renville North Dakota 38075 550 15
2446255 2446255 2022-04-26 Renville North Dakota 38075 550 15
2443000 2443000 2022-04-25 Renville North Dakota 38075 550 15
2439744 2439744 2022-04-24 Renville North Dakota 38075 550 15
2436488 2436488 2022-04-23 Renville North Dakota 38075 550 15
2433232 2433232 2022-04-22 Renville North Dakota 38075 550 15
2429976 2429976 2022-04-21 Renville North Dakota 38075 549 15
2426720 2426720 2022-04-20 Renville North Dakota 38075 549 15
2423464 2423464 2022-04-19 Renville North Dakota 38075 549 15
2420207 2420207 2022-04-18 Renville North Dakota 38075 549 15
2416952 2416952 2022-04-17 Renville North Dakota 38075 549 15
2413696 2413696 2022-04-16 Renville North Dakota 38075 549 15
2410440 2410440 2022-04-15 Renville North Dakota 38075 549 15
2407184 2407184 2022-04-14 Renville North Dakota 38075 549 15
2403928 2403928 2022-04-13 Renville North Dakota 38075 549 15
2400673 2400673 2022-04-12 Renville North Dakota 38075 549 15
2397418 2397418 2022-04-11 Renville North Dakota 38075 549 15
2394163 2394163 2022-04-10 Renville North Dakota 38075 549 15
2390907 2390907 2022-04-09 Renville North Dakota 38075 549 15
2387651 2387651 2022-04-08 Renville North Dakota 38075 549 15
2384396 2384396 2022-04-07 Renville North Dakota 38075 549 15
2381141 2381141 2022-04-06 Renville North Dakota 38075 549 15
2377886 2377886 2022-04-05 Renville North Dakota 38075 549 15
2374633 2374633 2022-04-04 Renville North Dakota 38075 549 15
2371381 2371381 2022-04-03 Renville North Dakota 38075 549 15
2368128 2368128 2022-04-02 Renville North Dakota 38075 549 15
2364875 2364875 2022-04-01 Renville North Dakota 38075 549 15
2361621 2361621 2022-03-31 Renville North Dakota 38075 548 15
2358367 2358367 2022-03-30 Renville North Dakota 38075 548 15
2355113 2355113 2022-03-29 Renville North Dakota 38075 548 15
2351860 2351860 2022-03-28 Renville North Dakota 38075 548 15
2348608 2348608 2022-03-27 Renville North Dakota 38075 548 15
2345355 2345355 2022-03-26 Renville North Dakota 38075 548 15
2342102 2342102 2022-03-25 Renville North Dakota 38075 548 15
2338849 2338849 2022-03-24 Renville North Dakota 38075 548 15
2335595 2335595 2022-03-23 Renville North Dakota 38075 548 15
2332341 2332341 2022-03-22 Renville North Dakota 38075 548 15
2329088 2329088 2022-03-21 Renville North Dakota 38075 548 15
2325836 2325836 2022-03-20 Renville North Dakota 38075 548 15
2322583 2322583 2022-03-19 Renville North Dakota 38075 548 15
2319329 2319329 2022-03-18 Renville North Dakota 38075 548 15
2316075 2316075 2022-03-17 Renville North Dakota 38075 549 15
2312822 2312822 2022-03-16 Renville North Dakota 38075 549 15
2309569 2309569 2022-03-15 Renville North Dakota 38075 549 15
2306316 2306316 2022-03-14 Renville North Dakota 38075 549 15
2303065 2303065 2022-03-13 Renville North Dakota 38075 549 15
2299813 2299813 2022-03-12 Renville North Dakota 38075 548 15
2296561 2296561 2022-03-11 Renville North Dakota 38075 548 15
2293309 2293309 2022-03-10 Renville North Dakota 38075 548 15
2290057 2290057 2022-03-09 Renville North Dakota 38075 548 15
2286805 2286805 2022-03-08 Renville North Dakota 38075 548 15
2283553 2283553 2022-03-07 Renville North Dakota 38075 547 15
2280301 2280301 2022-03-06 Renville North Dakota 38075 547 15
2277048 2277048 2022-03-05 Renville North Dakota 38075 547 15
2273795 2273795 2022-03-04 Renville North Dakota 38075 546 15
2270542 2270542 2022-03-03 Renville North Dakota 38075 546 15
2267290 2267290 2022-03-02 Renville North Dakota 38075 546 15
2264038 2264038 2022-03-01 Renville North Dakota 38075 546 15
2260787 2260787 2022-02-28 Renville North Dakota 38075 546 15
2257536 2257536 2022-02-27 Renville North Dakota 38075 546 15
2254285 2254285 2022-02-26 Renville North Dakota 38075 546 15
2251034 2251034 2022-02-25 Renville North Dakota 38075 546 15
2247783 2247783 2022-02-24 Renville North Dakota 38075 546 15
2244532 2244532 2022-02-23 Renville North Dakota 38075 546 15
2241281 2241281 2022-02-22 Renville North Dakota 38075 546 15
2238030 2238030 2022-02-21 Renville North Dakota 38075 546 15
2234779 2234779 2022-02-20 Renville North Dakota 38075 546 15
2231528 2231528 2022-02-19 Renville North Dakota 38075 546 15
2228277 2228277 2022-02-18 Renville North Dakota 38075 545 15
2225026 2225026 2022-02-17 Renville North Dakota 38075 545 15
2221775 2221775 2022-02-16 Renville North Dakota 38075 544 15
2218524 2218524 2022-02-15 Renville North Dakota 38075 545 15
2215273 2215273 2022-02-14 Renville North Dakota 38075 544 15
2212022 2212022 2022-02-13 Renville North Dakota 38075 544 15
2208769 2208769 2022-02-12 Renville North Dakota 38075 544 15
2205516 2205516 2022-02-11 Renville North Dakota 38075 544 15
2202263 2202263 2022-02-10 Renville North Dakota 38075 542 15
2199009 2199009 2022-02-09 Renville North Dakota 38075 541 15
2195755 2195755 2022-02-08 Renville North Dakota 38075 540 15
2192501 2192501 2022-02-07 Renville North Dakota 38075 540 15
2189247 2189247 2022-02-06 Renville North Dakota 38075 538 15
2185994 2185994 2022-02-05 Renville North Dakota 38075 538 15
2182742 2182742 2022-02-04 Renville North Dakota 38075 539 15
2179490 2179490 2022-02-03 Renville North Dakota 38075 533 15

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