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 county = "Divide", fips = 38023 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 · 777 ✖

fips 1

  • 38023 · 777 ✖

county 1

  • Divide · 777 ✖
Link rowid date ▲ county state fips cases deaths
2501597 2501597 2022-05-13 Divide North Dakota 38023 459 4
2498339 2498339 2022-05-12 Divide North Dakota 38023 459 4
2495081 2495081 2022-05-11 Divide North Dakota 38023 459 4
2491823 2491823 2022-05-10 Divide North Dakota 38023 459 4
2488565 2488565 2022-05-09 Divide North Dakota 38023 459 4
2485308 2485308 2022-05-08 Divide North Dakota 38023 459 4
2482050 2482050 2022-05-07 Divide North Dakota 38023 459 4
2478792 2478792 2022-05-06 Divide North Dakota 38023 459 4
2475534 2475534 2022-05-05 Divide North Dakota 38023 458 4
2472277 2472277 2022-05-04 Divide North Dakota 38023 458 4
2469021 2469021 2022-05-03 Divide North Dakota 38023 458 4
2465765 2465765 2022-05-02 Divide North Dakota 38023 458 4
2462510 2462510 2022-05-01 Divide North Dakota 38023 458 4
2459254 2459254 2022-04-30 Divide North Dakota 38023 458 4
2455998 2455998 2022-04-29 Divide North Dakota 38023 458 4
2452742 2452742 2022-04-28 Divide North Dakota 38023 457 4
2449486 2449486 2022-04-27 Divide North Dakota 38023 457 4
2446229 2446229 2022-04-26 Divide North Dakota 38023 457 4
2442974 2442974 2022-04-25 Divide North Dakota 38023 457 4
2439718 2439718 2022-04-24 Divide North Dakota 38023 457 4
2436462 2436462 2022-04-23 Divide North Dakota 38023 457 4
2433206 2433206 2022-04-22 Divide North Dakota 38023 457 4
2429950 2429950 2022-04-21 Divide North Dakota 38023 457 4
2426694 2426694 2022-04-20 Divide North Dakota 38023 457 4
2423438 2423438 2022-04-19 Divide North Dakota 38023 457 4
2420181 2420181 2022-04-18 Divide North Dakota 38023 457 4
2416926 2416926 2022-04-17 Divide North Dakota 38023 457 4
2413670 2413670 2022-04-16 Divide North Dakota 38023 457 4
2410414 2410414 2022-04-15 Divide North Dakota 38023 457 4
2407158 2407158 2022-04-14 Divide North Dakota 38023 456 4
2403902 2403902 2022-04-13 Divide North Dakota 38023 456 4
2400647 2400647 2022-04-12 Divide North Dakota 38023 456 4
2397392 2397392 2022-04-11 Divide North Dakota 38023 456 4
2394137 2394137 2022-04-10 Divide North Dakota 38023 456 4
2390881 2390881 2022-04-09 Divide North Dakota 38023 456 4
2387625 2387625 2022-04-08 Divide North Dakota 38023 456 4
2384370 2384370 2022-04-07 Divide North Dakota 38023 454 4
2381115 2381115 2022-04-06 Divide North Dakota 38023 454 4
2377860 2377860 2022-04-05 Divide North Dakota 38023 454 4
2374607 2374607 2022-04-04 Divide North Dakota 38023 454 4
2371355 2371355 2022-04-03 Divide North Dakota 38023 454 4
2368102 2368102 2022-04-02 Divide North Dakota 38023 454 4
2364849 2364849 2022-04-01 Divide North Dakota 38023 454 4
2361595 2361595 2022-03-31 Divide North Dakota 38023 454 4
2358341 2358341 2022-03-30 Divide North Dakota 38023 454 4
2355087 2355087 2022-03-29 Divide North Dakota 38023 454 4
2351834 2351834 2022-03-28 Divide North Dakota 38023 454 4
2348582 2348582 2022-03-27 Divide North Dakota 38023 454 4
2345329 2345329 2022-03-26 Divide North Dakota 38023 454 4
2342076 2342076 2022-03-25 Divide North Dakota 38023 454 4
2338823 2338823 2022-03-24 Divide North Dakota 38023 454 4
2335569 2335569 2022-03-23 Divide North Dakota 38023 454 4
2332315 2332315 2022-03-22 Divide North Dakota 38023 454 4
2329062 2329062 2022-03-21 Divide North Dakota 38023 454 4
2325810 2325810 2022-03-20 Divide North Dakota 38023 454 4
2322557 2322557 2022-03-19 Divide North Dakota 38023 454 4
2319303 2319303 2022-03-18 Divide North Dakota 38023 454 4
2316049 2316049 2022-03-17 Divide North Dakota 38023 455 4
2312796 2312796 2022-03-16 Divide North Dakota 38023 455 4
2309543 2309543 2022-03-15 Divide North Dakota 38023 455 4
2306290 2306290 2022-03-14 Divide North Dakota 38023 455 4
2303039 2303039 2022-03-13 Divide North Dakota 38023 455 4
2299787 2299787 2022-03-12 Divide North Dakota 38023 455 4
2296535 2296535 2022-03-11 Divide North Dakota 38023 454 4
2293283 2293283 2022-03-10 Divide North Dakota 38023 454 4
2290031 2290031 2022-03-09 Divide North Dakota 38023 454 4
2286779 2286779 2022-03-08 Divide North Dakota 38023 454 4
2283527 2283527 2022-03-07 Divide North Dakota 38023 454 4
2280275 2280275 2022-03-06 Divide North Dakota 38023 454 4
2277022 2277022 2022-03-05 Divide North Dakota 38023 454 4
2273769 2273769 2022-03-04 Divide North Dakota 38023 454 4
2270516 2270516 2022-03-03 Divide North Dakota 38023 454 4
2267264 2267264 2022-03-02 Divide North Dakota 38023 454 4
2264012 2264012 2022-03-01 Divide North Dakota 38023 454 4
2260761 2260761 2022-02-28 Divide North Dakota 38023 454 4
2257510 2257510 2022-02-27 Divide North Dakota 38023 454 4
2254259 2254259 2022-02-26 Divide North Dakota 38023 454 4
2251008 2251008 2022-02-25 Divide North Dakota 38023 454 4
2247757 2247757 2022-02-24 Divide North Dakota 38023 454 4
2244506 2244506 2022-02-23 Divide North Dakota 38023 454 4
2241255 2241255 2022-02-22 Divide North Dakota 38023 454 4
2238004 2238004 2022-02-21 Divide North Dakota 38023 454 4
2234753 2234753 2022-02-20 Divide North Dakota 38023 454 4
2231502 2231502 2022-02-19 Divide North Dakota 38023 454 4
2228251 2228251 2022-02-18 Divide North Dakota 38023 454 4
2225000 2225000 2022-02-17 Divide North Dakota 38023 454 4
2221749 2221749 2022-02-16 Divide North Dakota 38023 454 4
2218498 2218498 2022-02-15 Divide North Dakota 38023 454 4
2215247 2215247 2022-02-14 Divide North Dakota 38023 453 4
2211996 2211996 2022-02-13 Divide North Dakota 38023 452 4
2208743 2208743 2022-02-12 Divide North Dakota 38023 452 4
2205490 2205490 2022-02-11 Divide North Dakota 38023 452 4
2202237 2202237 2022-02-10 Divide North Dakota 38023 451 4
2198983 2198983 2022-02-09 Divide North Dakota 38023 450 4
2195729 2195729 2022-02-08 Divide North Dakota 38023 450 4
2192475 2192475 2022-02-07 Divide North Dakota 38023 451 4
2189221 2189221 2022-02-06 Divide North Dakota 38023 451 4
2185968 2185968 2022-02-05 Divide North Dakota 38023 451 4
2182716 2182716 2022-02-04 Divide North Dakota 38023 450 4
2179464 2179464 2022-02-03 Divide North Dakota 38023 447 4

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