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

717 rows where county = "Unknown" and state = "North Dakota" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • North Dakota · 717 ✖

fips 1

  • - 717

county 1

  • Unknown · 717 ✖
Link rowid date ▲ county state fips cases deaths
2501635 2501635 2022-05-13 Unknown North Dakota   0 87
2498377 2498377 2022-05-12 Unknown North Dakota   483 87
2495119 2495119 2022-05-11 Unknown North Dakota   326 83
2491861 2491861 2022-05-10 Unknown North Dakota   177 83
2488603 2488603 2022-05-09 Unknown North Dakota   0 83
2485346 2485346 2022-05-08 Unknown North Dakota   0 83
2482088 2482088 2022-05-07 Unknown North Dakota   0 83
2478830 2478830 2022-05-06 Unknown North Dakota   0 83
2475572 2475572 2022-05-05 Unknown North Dakota   361 83
2472315 2472315 2022-05-04 Unknown North Dakota   258 83
2469059 2469059 2022-05-03 Unknown North Dakota   144 83
2465803 2465803 2022-05-02 Unknown North Dakota   0 83
2462548 2462548 2022-05-01 Unknown North Dakota   0 83
2459292 2459292 2022-04-30 Unknown North Dakota   0 83
2456036 2456036 2022-04-29 Unknown North Dakota   0 83
2452780 2452780 2022-04-28 Unknown North Dakota   255 83
2449524 2449524 2022-04-27 Unknown North Dakota   201 78
2446267 2446267 2022-04-26 Unknown North Dakota   105 78
2443012 2443012 2022-04-25 Unknown North Dakota   0 76
2439756 2439756 2022-04-24 Unknown North Dakota   0 76
2436500 2436500 2022-04-23 Unknown North Dakota   0 76
2433244 2433244 2022-04-22 Unknown North Dakota   0 75
2429988 2429988 2022-04-21 Unknown North Dakota   212 72
2426732 2426732 2022-04-20 Unknown North Dakota   146 72
2423476 2423476 2022-04-19 Unknown North Dakota   51 72
2420219 2420219 2022-04-18 Unknown North Dakota   0 72
2416964 2416964 2022-04-17 Unknown North Dakota   0 72
2413708 2413708 2022-04-16 Unknown North Dakota   0 72
2410452 2410452 2022-04-15 Unknown North Dakota   0 72
2407196 2407196 2022-04-14 Unknown North Dakota   202 72
2403940 2403940 2022-04-13 Unknown North Dakota   126 69
2400685 2400685 2022-04-12 Unknown North Dakota   62 69
2397430 2397430 2022-04-11 Unknown North Dakota   0 69
2394175 2394175 2022-04-10 Unknown North Dakota   0 69
2390919 2390919 2022-04-09 Unknown North Dakota   0 69
2387663 2387663 2022-04-08 Unknown North Dakota   0 66
2384408 2384408 2022-04-07 Unknown North Dakota   157 47
2381153 2381153 2022-04-06 Unknown North Dakota   107 47
2377898 2377898 2022-04-05 Unknown North Dakota   42 47
2374645 2374645 2022-04-04 Unknown North Dakota   0 47
2371393 2371393 2022-04-03 Unknown North Dakota   0 47
2368140 2368140 2022-04-02 Unknown North Dakota   0 47
2364887 2364887 2022-04-01 Unknown North Dakota   0 47
2361633 2361633 2022-03-31 Unknown North Dakota   105 47
2358379 2358379 2022-03-30 Unknown North Dakota   71 47
2355125 2355125 2022-03-29 Unknown North Dakota   30 47
2351872 2351872 2022-03-28 Unknown North Dakota   0 47
2348620 2348620 2022-03-27 Unknown North Dakota   0 47
2345367 2345367 2022-03-26 Unknown North Dakota   0 47
2342114 2342114 2022-03-25 Unknown North Dakota   0 47
2338861 2338861 2022-03-24 Unknown North Dakota   0 47
2335607 2335607 2022-03-23 Unknown North Dakota   0 47
2332353 2332353 2022-03-22 Unknown North Dakota   0 47
2329100 2329100 2022-03-21 Unknown North Dakota   0 47
2325848 2325848 2022-03-20 Unknown North Dakota   0 47
2322595 2322595 2022-03-19 Unknown North Dakota   0 47
2319341 2319341 2022-03-18 Unknown North Dakota   0 47
2316087 2316087 2022-03-17 Unknown North Dakota   0 47
2312834 2312834 2022-03-16 Unknown North Dakota   0 47
2309581 2309581 2022-03-15 Unknown North Dakota   0 47
2306328 2306328 2022-03-14 Unknown North Dakota   0 47
2303077 2303077 2022-03-13 Unknown North Dakota   0 47
2299825 2299825 2022-03-12 Unknown North Dakota   0 47
2296573 2296573 2022-03-11 Unknown North Dakota   0 47
2293321 2293321 2022-03-10 Unknown North Dakota   0 47
2290069 2290069 2022-03-09 Unknown North Dakota   0 47
2286817 2286817 2022-03-08 Unknown North Dakota   0 47
2283565 2283565 2022-03-07 Unknown North Dakota   0 47
2280313 2280313 2022-03-06 Unknown North Dakota   0 47
2277060 2277060 2022-03-05 Unknown North Dakota   0 47
2273807 2273807 2022-03-04 Unknown North Dakota   0 47
2270554 2270554 2022-03-03 Unknown North Dakota   0 47
2267302 2267302 2022-03-02 Unknown North Dakota   0 47
2264050 2264050 2022-03-01 Unknown North Dakota   0 47
2260799 2260799 2022-02-28 Unknown North Dakota   0 47
2257548 2257548 2022-02-27 Unknown North Dakota   0 47
2254297 2254297 2022-02-26 Unknown North Dakota   0 47
2251046 2251046 2022-02-25 Unknown North Dakota   0 47
2247795 2247795 2022-02-24 Unknown North Dakota   0 47
2244544 2244544 2022-02-23 Unknown North Dakota   0 47
2241293 2241293 2022-02-22 Unknown North Dakota   0 47
2238042 2238042 2022-02-21 Unknown North Dakota   0 47
2234791 2234791 2022-02-20 Unknown North Dakota   0 47
2231540 2231540 2022-02-19 Unknown North Dakota   0 47
2228289 2228289 2022-02-18 Unknown North Dakota   0 47
2225038 2225038 2022-02-17 Unknown North Dakota   0 47
2221787 2221787 2022-02-16 Unknown North Dakota   0 47
2218536 2218536 2022-02-15 Unknown North Dakota   0 47
2215285 2215285 2022-02-14 Unknown North Dakota   0 47
2212034 2212034 2022-02-13 Unknown North Dakota   0 47
2208781 2208781 2022-02-12 Unknown North Dakota   0 47
2205528 2205528 2022-02-11 Unknown North Dakota   0 47
2202275 2202275 2022-02-10 Unknown North Dakota   0 47
2199021 2199021 2022-02-09 Unknown North Dakota   0 47
2195767 2195767 2022-02-08 Unknown North Dakota   0 47
2192513 2192513 2022-02-07 Unknown North Dakota   0 47
2189259 2189259 2022-02-06 Unknown North Dakota   0 47
2186006 2186006 2022-02-05 Unknown North Dakota   0 47
2182754 2182754 2022-02-04 Unknown North Dakota   0 47
2179502 2179502 2022-02-03 Unknown North Dakota   0 47

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