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

777 rows where fips = 38085 sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

state 1

fips 1

  • 38085 · 777 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2501628 2501628 2022-05-13 Sioux North Dakota 38085 1350 19
2498370 2498370 2022-05-12 Sioux North Dakota 38085 1348 19
2495112 2495112 2022-05-11 Sioux North Dakota 38085 1348 19
2491854 2491854 2022-05-10 Sioux North Dakota 38085 1348 19
2488596 2488596 2022-05-09 Sioux North Dakota 38085 1348 19
2485339 2485339 2022-05-08 Sioux North Dakota 38085 1348 19
2482081 2482081 2022-05-07 Sioux North Dakota 38085 1348 19
2478823 2478823 2022-05-06 Sioux North Dakota 38085 1348 19
2475565 2475565 2022-05-05 Sioux North Dakota 38085 1342 19
2472308 2472308 2022-05-04 Sioux North Dakota 38085 1342 19
2469052 2469052 2022-05-03 Sioux North Dakota 38085 1342 19
2465796 2465796 2022-05-02 Sioux North Dakota 38085 1342 19
2462541 2462541 2022-05-01 Sioux North Dakota 38085 1342 19
2459285 2459285 2022-04-30 Sioux North Dakota 38085 1342 19
2456029 2456029 2022-04-29 Sioux North Dakota 38085 1342 19
2452773 2452773 2022-04-28 Sioux North Dakota 38085 1341 19
2449517 2449517 2022-04-27 Sioux North Dakota 38085 1341 19
2446260 2446260 2022-04-26 Sioux North Dakota 38085 1341 19
2443005 2443005 2022-04-25 Sioux North Dakota 38085 1341 19
2439749 2439749 2022-04-24 Sioux North Dakota 38085 1341 19
2436493 2436493 2022-04-23 Sioux North Dakota 38085 1341 19
2433237 2433237 2022-04-22 Sioux North Dakota 38085 1341 19
2429981 2429981 2022-04-21 Sioux North Dakota 38085 1340 19
2426725 2426725 2022-04-20 Sioux North Dakota 38085 1340 19
2423469 2423469 2022-04-19 Sioux North Dakota 38085 1340 19
2420212 2420212 2022-04-18 Sioux North Dakota 38085 1340 19
2416957 2416957 2022-04-17 Sioux North Dakota 38085 1340 19
2413701 2413701 2022-04-16 Sioux North Dakota 38085 1340 19
2410445 2410445 2022-04-15 Sioux North Dakota 38085 1340 19
2407189 2407189 2022-04-14 Sioux North Dakota 38085 1337 19
2403933 2403933 2022-04-13 Sioux North Dakota 38085 1337 19
2400678 2400678 2022-04-12 Sioux North Dakota 38085 1337 19
2397423 2397423 2022-04-11 Sioux North Dakota 38085 1337 19
2394168 2394168 2022-04-10 Sioux North Dakota 38085 1337 19
2390912 2390912 2022-04-09 Sioux North Dakota 38085 1337 19
2387656 2387656 2022-04-08 Sioux North Dakota 38085 1337 19
2384401 2384401 2022-04-07 Sioux North Dakota 38085 1337 19
2381146 2381146 2022-04-06 Sioux North Dakota 38085 1337 19
2377891 2377891 2022-04-05 Sioux North Dakota 38085 1337 19
2374638 2374638 2022-04-04 Sioux North Dakota 38085 1337 19
2371386 2371386 2022-04-03 Sioux North Dakota 38085 1337 19
2368133 2368133 2022-04-02 Sioux North Dakota 38085 1337 19
2364880 2364880 2022-04-01 Sioux North Dakota 38085 1337 19
2361626 2361626 2022-03-31 Sioux North Dakota 38085 1334 19
2358372 2358372 2022-03-30 Sioux North Dakota 38085 1334 19
2355118 2355118 2022-03-29 Sioux North Dakota 38085 1334 19
2351865 2351865 2022-03-28 Sioux North Dakota 38085 1334 19
2348613 2348613 2022-03-27 Sioux North Dakota 38085 1334 19
2345360 2345360 2022-03-26 Sioux North Dakota 38085 1334 19
2342107 2342107 2022-03-25 Sioux North Dakota 38085 1334 19
2338854 2338854 2022-03-24 Sioux North Dakota 38085 1334 19
2335600 2335600 2022-03-23 Sioux North Dakota 38085 1334 19
2332346 2332346 2022-03-22 Sioux North Dakota 38085 1334 19
2329093 2329093 2022-03-21 Sioux North Dakota 38085 1334 19
2325841 2325841 2022-03-20 Sioux North Dakota 38085 1334 19
2322588 2322588 2022-03-19 Sioux North Dakota 38085 1334 19
2319334 2319334 2022-03-18 Sioux North Dakota 38085 1334 19
2316080 2316080 2022-03-17 Sioux North Dakota 38085 1332 19
2312827 2312827 2022-03-16 Sioux North Dakota 38085 1332 19
2309574 2309574 2022-03-15 Sioux North Dakota 38085 1332 19
2306321 2306321 2022-03-14 Sioux North Dakota 38085 1332 19
2303070 2303070 2022-03-13 Sioux North Dakota 38085 1332 19
2299818 2299818 2022-03-12 Sioux North Dakota 38085 1332 19
2296566 2296566 2022-03-11 Sioux North Dakota 38085 1333 19
2293314 2293314 2022-03-10 Sioux North Dakota 38085 1334 19
2290062 2290062 2022-03-09 Sioux North Dakota 38085 1334 19
2286810 2286810 2022-03-08 Sioux North Dakota 38085 1334 19
2283558 2283558 2022-03-07 Sioux North Dakota 38085 1334 19
2280306 2280306 2022-03-06 Sioux North Dakota 38085 1334 19
2277053 2277053 2022-03-05 Sioux North Dakota 38085 1334 19
2273800 2273800 2022-03-04 Sioux North Dakota 38085 1332 19
2270547 2270547 2022-03-03 Sioux North Dakota 38085 1331 19
2267295 2267295 2022-03-02 Sioux North Dakota 38085 1327 19
2264043 2264043 2022-03-01 Sioux North Dakota 38085 1324 19
2260792 2260792 2022-02-28 Sioux North Dakota 38085 1324 19
2257541 2257541 2022-02-27 Sioux North Dakota 38085 1324 19
2254290 2254290 2022-02-26 Sioux North Dakota 38085 1320 19
2251039 2251039 2022-02-25 Sioux North Dakota 38085 1319 19
2247788 2247788 2022-02-24 Sioux North Dakota 38085 1319 19
2244537 2244537 2022-02-23 Sioux North Dakota 38085 1319 19
2241286 2241286 2022-02-22 Sioux North Dakota 38085 1319 19
2238035 2238035 2022-02-21 Sioux North Dakota 38085 1319 19
2234784 2234784 2022-02-20 Sioux North Dakota 38085 1319 19
2231533 2231533 2022-02-19 Sioux North Dakota 38085 1317 19
2228282 2228282 2022-02-18 Sioux North Dakota 38085 1316 19
2225031 2225031 2022-02-17 Sioux North Dakota 38085 1314 19
2221780 2221780 2022-02-16 Sioux North Dakota 38085 1311 19
2218529 2218529 2022-02-15 Sioux North Dakota 38085 1310 19
2215278 2215278 2022-02-14 Sioux North Dakota 38085 1311 19
2212027 2212027 2022-02-13 Sioux North Dakota 38085 1311 19
2208774 2208774 2022-02-12 Sioux North Dakota 38085 1309 19
2205521 2205521 2022-02-11 Sioux North Dakota 38085 1308 19
2202268 2202268 2022-02-10 Sioux North Dakota 38085 1305 19
2199014 2199014 2022-02-09 Sioux North Dakota 38085 1300 19
2195760 2195760 2022-02-08 Sioux North Dakota 38085 1299 19
2192506 2192506 2022-02-07 Sioux North Dakota 38085 1295 19
2189252 2189252 2022-02-06 Sioux North Dakota 38085 1292 19
2185999 2185999 2022-02-05 Sioux North Dakota 38085 1292 19
2182747 2182747 2022-02-04 Sioux North Dakota 38085 1292 19
2179495 2179495 2022-02-03 Sioux North Dakota 38085 1284 19

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