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

779 rows where fips = 38049 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 · 779 ✖

fips 1

  • 38049 · 779 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2501610 2501610 2022-05-13 McHenry North Dakota 38049 1318 31
2498352 2498352 2022-05-12 McHenry North Dakota 38049 1313 31
2495094 2495094 2022-05-11 McHenry North Dakota 38049 1313 31
2491836 2491836 2022-05-10 McHenry North Dakota 38049 1313 31
2488578 2488578 2022-05-09 McHenry North Dakota 38049 1313 31
2485321 2485321 2022-05-08 McHenry North Dakota 38049 1313 31
2482063 2482063 2022-05-07 McHenry North Dakota 38049 1313 31
2478805 2478805 2022-05-06 McHenry North Dakota 38049 1313 31
2475547 2475547 2022-05-05 McHenry North Dakota 38049 1312 31
2472290 2472290 2022-05-04 McHenry North Dakota 38049 1312 31
2469034 2469034 2022-05-03 McHenry North Dakota 38049 1312 31
2465778 2465778 2022-05-02 McHenry North Dakota 38049 1312 31
2462523 2462523 2022-05-01 McHenry North Dakota 38049 1312 31
2459267 2459267 2022-04-30 McHenry North Dakota 38049 1312 31
2456011 2456011 2022-04-29 McHenry North Dakota 38049 1312 31
2452755 2452755 2022-04-28 McHenry North Dakota 38049 1312 31
2449499 2449499 2022-04-27 McHenry North Dakota 38049 1312 31
2446242 2446242 2022-04-26 McHenry North Dakota 38049 1312 31
2442987 2442987 2022-04-25 McHenry North Dakota 38049 1312 31
2439731 2439731 2022-04-24 McHenry North Dakota 38049 1312 31
2436475 2436475 2022-04-23 McHenry North Dakota 38049 1312 31
2433219 2433219 2022-04-22 McHenry North Dakota 38049 1312 31
2429963 2429963 2022-04-21 McHenry North Dakota 38049 1308 31
2426707 2426707 2022-04-20 McHenry North Dakota 38049 1308 31
2423451 2423451 2022-04-19 McHenry North Dakota 38049 1308 31
2420194 2420194 2022-04-18 McHenry North Dakota 38049 1308 31
2416939 2416939 2022-04-17 McHenry North Dakota 38049 1308 31
2413683 2413683 2022-04-16 McHenry North Dakota 38049 1308 31
2410427 2410427 2022-04-15 McHenry North Dakota 38049 1308 31
2407171 2407171 2022-04-14 McHenry North Dakota 38049 1306 31
2403915 2403915 2022-04-13 McHenry North Dakota 38049 1306 31
2400660 2400660 2022-04-12 McHenry North Dakota 38049 1306 31
2397405 2397405 2022-04-11 McHenry North Dakota 38049 1306 31
2394150 2394150 2022-04-10 McHenry North Dakota 38049 1306 31
2390894 2390894 2022-04-09 McHenry North Dakota 38049 1306 31
2387638 2387638 2022-04-08 McHenry North Dakota 38049 1306 31
2384383 2384383 2022-04-07 McHenry North Dakota 38049 1301 31
2381128 2381128 2022-04-06 McHenry North Dakota 38049 1301 31
2377873 2377873 2022-04-05 McHenry North Dakota 38049 1301 31
2374620 2374620 2022-04-04 McHenry North Dakota 38049 1301 31
2371368 2371368 2022-04-03 McHenry North Dakota 38049 1301 31
2368115 2368115 2022-04-02 McHenry North Dakota 38049 1301 31
2364862 2364862 2022-04-01 McHenry North Dakota 38049 1301 31
2361608 2361608 2022-03-31 McHenry North Dakota 38049 1302 31
2358354 2358354 2022-03-30 McHenry North Dakota 38049 1302 31
2355100 2355100 2022-03-29 McHenry North Dakota 38049 1302 31
2351847 2351847 2022-03-28 McHenry North Dakota 38049 1302 31
2348595 2348595 2022-03-27 McHenry North Dakota 38049 1302 31
2345342 2345342 2022-03-26 McHenry North Dakota 38049 1302 31
2342089 2342089 2022-03-25 McHenry North Dakota 38049 1302 31
2338836 2338836 2022-03-24 McHenry North Dakota 38049 1301 31
2335582 2335582 2022-03-23 McHenry North Dakota 38049 1301 31
2332328 2332328 2022-03-22 McHenry North Dakota 38049 1301 31
2329075 2329075 2022-03-21 McHenry North Dakota 38049 1301 31
2325823 2325823 2022-03-20 McHenry North Dakota 38049 1301 31
2322570 2322570 2022-03-19 McHenry North Dakota 38049 1301 31
2319316 2319316 2022-03-18 McHenry North Dakota 38049 1301 31
2316062 2316062 2022-03-17 McHenry North Dakota 38049 1300 31
2312809 2312809 2022-03-16 McHenry North Dakota 38049 1301 31
2309556 2309556 2022-03-15 McHenry North Dakota 38049 1300 31
2306303 2306303 2022-03-14 McHenry North Dakota 38049 1300 31
2303052 2303052 2022-03-13 McHenry North Dakota 38049 1300 31
2299800 2299800 2022-03-12 McHenry North Dakota 38049 1300 31
2296548 2296548 2022-03-11 McHenry North Dakota 38049 1297 31
2293296 2293296 2022-03-10 McHenry North Dakota 38049 1297 31
2290044 2290044 2022-03-09 McHenry North Dakota 38049 1297 31
2286792 2286792 2022-03-08 McHenry North Dakota 38049 1294 31
2283540 2283540 2022-03-07 McHenry North Dakota 38049 1294 31
2280288 2280288 2022-03-06 McHenry North Dakota 38049 1293 31
2277035 2277035 2022-03-05 McHenry North Dakota 38049 1293 31
2273782 2273782 2022-03-04 McHenry North Dakota 38049 1292 30
2270529 2270529 2022-03-03 McHenry North Dakota 38049 1292 30
2267277 2267277 2022-03-02 McHenry North Dakota 38049 1292 30
2264025 2264025 2022-03-01 McHenry North Dakota 38049 1292 30
2260774 2260774 2022-02-28 McHenry North Dakota 38049 1291 30
2257523 2257523 2022-02-27 McHenry North Dakota 38049 1291 30
2254272 2254272 2022-02-26 McHenry North Dakota 38049 1290 30
2251021 2251021 2022-02-25 McHenry North Dakota 38049 1289 30
2247770 2247770 2022-02-24 McHenry North Dakota 38049 1289 30
2244519 2244519 2022-02-23 McHenry North Dakota 38049 1288 30
2241268 2241268 2022-02-22 McHenry North Dakota 38049 1289 30
2238017 2238017 2022-02-21 McHenry North Dakota 38049 1285 30
2234766 2234766 2022-02-20 McHenry North Dakota 38049 1285 30
2231515 2231515 2022-02-19 McHenry North Dakota 38049 1280 30
2228264 2228264 2022-02-18 McHenry North Dakota 38049 1276 30
2225013 2225013 2022-02-17 McHenry North Dakota 38049 1273 30
2221762 2221762 2022-02-16 McHenry North Dakota 38049 1269 30
2218511 2218511 2022-02-15 McHenry North Dakota 38049 1270 30
2215260 2215260 2022-02-14 McHenry North Dakota 38049 1268 30
2212009 2212009 2022-02-13 McHenry North Dakota 38049 1267 30
2208756 2208756 2022-02-12 McHenry North Dakota 38049 1266 30
2205503 2205503 2022-02-11 McHenry North Dakota 38049 1263 30
2202250 2202250 2022-02-10 McHenry North Dakota 38049 1260 30
2198996 2198996 2022-02-09 McHenry North Dakota 38049 1260 30
2195742 2195742 2022-02-08 McHenry North Dakota 38049 1257 30
2192488 2192488 2022-02-07 McHenry North Dakota 38049 1252 30
2189234 2189234 2022-02-06 McHenry North Dakota 38049 1246 30
2185981 2185981 2022-02-05 McHenry North Dakota 38049 1246 30
2182729 2182729 2022-02-04 McHenry North Dakota 38049 1242 30
2179477 2179477 2022-02-03 McHenry North Dakota 38049 1236 30

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