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

787 rows where county = "Morton", fips = 38059 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 · 787 ✖

fips 1

  • 38059 · 787 ✖

county 1

  • Morton · 787 ✖
Link rowid date ▲ county state fips cases deaths
2501615 2501615 2022-05-13 Morton North Dakota 38059 11274 142
2498357 2498357 2022-05-12 Morton North Dakota 38059 11255 142
2495099 2495099 2022-05-11 Morton North Dakota 38059 11255 142
2491841 2491841 2022-05-10 Morton North Dakota 38059 11255 142
2488583 2488583 2022-05-09 Morton North Dakota 38059 11255 142
2485326 2485326 2022-05-08 Morton North Dakota 38059 11255 142
2482068 2482068 2022-05-07 Morton North Dakota 38059 11255 142
2478810 2478810 2022-05-06 Morton North Dakota 38059 11255 142
2475552 2475552 2022-05-05 Morton North Dakota 38059 11240 142
2472295 2472295 2022-05-04 Morton North Dakota 38059 11240 142
2469039 2469039 2022-05-03 Morton North Dakota 38059 11240 142
2465783 2465783 2022-05-02 Morton North Dakota 38059 11240 142
2462528 2462528 2022-05-01 Morton North Dakota 38059 11240 142
2459272 2459272 2022-04-30 Morton North Dakota 38059 11240 142
2456016 2456016 2022-04-29 Morton North Dakota 38059 11240 142
2452760 2452760 2022-04-28 Morton North Dakota 38059 11233 142
2449504 2449504 2022-04-27 Morton North Dakota 38059 11233 142
2446247 2446247 2022-04-26 Morton North Dakota 38059 11233 142
2442992 2442992 2022-04-25 Morton North Dakota 38059 11233 142
2439736 2439736 2022-04-24 Morton North Dakota 38059 11233 142
2436480 2436480 2022-04-23 Morton North Dakota 38059 11233 142
2433224 2433224 2022-04-22 Morton North Dakota 38059 11233 142
2429968 2429968 2022-04-21 Morton North Dakota 38059 11225 142
2426712 2426712 2022-04-20 Morton North Dakota 38059 11225 142
2423456 2423456 2022-04-19 Morton North Dakota 38059 11225 142
2420199 2420199 2022-04-18 Morton North Dakota 38059 11225 142
2416944 2416944 2022-04-17 Morton North Dakota 38059 11225 142
2413688 2413688 2022-04-16 Morton North Dakota 38059 11225 142
2410432 2410432 2022-04-15 Morton North Dakota 38059 11225 142
2407176 2407176 2022-04-14 Morton North Dakota 38059 11225 142
2403920 2403920 2022-04-13 Morton North Dakota 38059 11225 142
2400665 2400665 2022-04-12 Morton North Dakota 38059 11225 142
2397410 2397410 2022-04-11 Morton North Dakota 38059 11225 142
2394155 2394155 2022-04-10 Morton North Dakota 38059 11225 142
2390899 2390899 2022-04-09 Morton North Dakota 38059 11225 142
2387643 2387643 2022-04-08 Morton North Dakota 38059 11225 142
2384388 2384388 2022-04-07 Morton North Dakota 38059 11222 142
2381133 2381133 2022-04-06 Morton North Dakota 38059 11222 142
2377878 2377878 2022-04-05 Morton North Dakota 38059 11222 142
2374625 2374625 2022-04-04 Morton North Dakota 38059 11222 142
2371373 2371373 2022-04-03 Morton North Dakota 38059 11222 142
2368120 2368120 2022-04-02 Morton North Dakota 38059 11222 142
2364867 2364867 2022-04-01 Morton North Dakota 38059 11222 142
2361613 2361613 2022-03-31 Morton North Dakota 38059 11221 142
2358359 2358359 2022-03-30 Morton North Dakota 38059 11221 142
2355105 2355105 2022-03-29 Morton North Dakota 38059 11221 142
2351852 2351852 2022-03-28 Morton North Dakota 38059 11221 142
2348600 2348600 2022-03-27 Morton North Dakota 38059 11221 142
2345347 2345347 2022-03-26 Morton North Dakota 38059 11221 142
2342094 2342094 2022-03-25 Morton North Dakota 38059 11221 142
2338841 2338841 2022-03-24 Morton North Dakota 38059 11211 142
2335587 2335587 2022-03-23 Morton North Dakota 38059 11211 142
2332333 2332333 2022-03-22 Morton North Dakota 38059 11211 142
2329080 2329080 2022-03-21 Morton North Dakota 38059 11211 142
2325828 2325828 2022-03-20 Morton North Dakota 38059 11211 142
2322575 2322575 2022-03-19 Morton North Dakota 38059 11211 142
2319321 2319321 2022-03-18 Morton North Dakota 38059 11211 142
2316067 2316067 2022-03-17 Morton North Dakota 38059 11182 142
2312814 2312814 2022-03-16 Morton North Dakota 38059 11171 142
2309561 2309561 2022-03-15 Morton North Dakota 38059 11166 142
2306308 2306308 2022-03-14 Morton North Dakota 38059 11164 142
2303057 2303057 2022-03-13 Morton North Dakota 38059 11163 142
2299805 2299805 2022-03-12 Morton North Dakota 38059 11161 142
2296553 2296553 2022-03-11 Morton North Dakota 38059 11170 142
2293301 2293301 2022-03-10 Morton North Dakota 38059 11170 142
2290049 2290049 2022-03-09 Morton North Dakota 38059 11168 142
2286797 2286797 2022-03-08 Morton North Dakota 38059 11161 142
2283545 2283545 2022-03-07 Morton North Dakota 38059 11156 142
2280293 2280293 2022-03-06 Morton North Dakota 38059 11154 142
2277040 2277040 2022-03-05 Morton North Dakota 38059 11152 142
2273787 2273787 2022-03-04 Morton North Dakota 38059 11148 142
2270534 2270534 2022-03-03 Morton North Dakota 38059 11142 142
2267282 2267282 2022-03-02 Morton North Dakota 38059 11135 142
2264030 2264030 2022-03-01 Morton North Dakota 38059 11125 142
2260779 2260779 2022-02-28 Morton North Dakota 38059 11112 141
2257528 2257528 2022-02-27 Morton North Dakota 38059 11111 141
2254277 2254277 2022-02-26 Morton North Dakota 38059 11110 141
2251026 2251026 2022-02-25 Morton North Dakota 38059 11102 141
2247775 2247775 2022-02-24 Morton North Dakota 38059 11098 140
2244524 2244524 2022-02-23 Morton North Dakota 38059 11086 140
2241273 2241273 2022-02-22 Morton North Dakota 38059 11076 140
2238022 2238022 2022-02-21 Morton North Dakota 38059 11072 140
2234771 2234771 2022-02-20 Morton North Dakota 38059 11070 140
2231520 2231520 2022-02-19 Morton North Dakota 38059 11064 140
2228269 2228269 2022-02-18 Morton North Dakota 38059 11054 140
2225018 2225018 2022-02-17 Morton North Dakota 38059 11051 140
2221767 2221767 2022-02-16 Morton North Dakota 38059 11038 140
2218516 2218516 2022-02-15 Morton North Dakota 38059 11027 140
2215265 2215265 2022-02-14 Morton North Dakota 38059 11013 140
2212014 2212014 2022-02-13 Morton North Dakota 38059 11010 140
2208761 2208761 2022-02-12 Morton North Dakota 38059 10996 140
2205508 2205508 2022-02-11 Morton North Dakota 38059 10979 140
2202255 2202255 2022-02-10 Morton North Dakota 38059 10956 139
2199001 2199001 2022-02-09 Morton North Dakota 38059 10932 139
2195747 2195747 2022-02-08 Morton North Dakota 38059 10891 139
2192493 2192493 2022-02-07 Morton North Dakota 38059 10828 139
2189239 2189239 2022-02-06 Morton North Dakota 38059 10796 139
2185986 2185986 2022-02-05 Morton North Dakota 38059 10795 139
2182734 2182734 2022-02-04 Morton North Dakota 38059 10761 139
2179482 2179482 2022-02-03 Morton North Dakota 38059 10718 138

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