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

655 rows where county = "Adams" and state = "North Dakota" sorted by date descending

✎ View and edit SQL

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

state 1

  • North Dakota · 655 ✖

fips 1

county 1

  • Adams · 655 ✖
Link rowid date ▲ county state fips cases deaths
2501586 2501586 2022-05-13 Adams North Dakota 38001 598 10
2498328 2498328 2022-05-12 Adams North Dakota 38001 598 10
2495070 2495070 2022-05-11 Adams North Dakota 38001 598 10
2491812 2491812 2022-05-10 Adams North Dakota 38001 598 10
2488554 2488554 2022-05-09 Adams North Dakota 38001 598 10
2485297 2485297 2022-05-08 Adams North Dakota 38001 598 10
2482039 2482039 2022-05-07 Adams North Dakota 38001 598 10
2478781 2478781 2022-05-06 Adams North Dakota 38001 598 10
2475523 2475523 2022-05-05 Adams North Dakota 38001 598 10
2472266 2472266 2022-05-04 Adams North Dakota 38001 598 10
2469010 2469010 2022-05-03 Adams North Dakota 38001 598 10
2465754 2465754 2022-05-02 Adams North Dakota 38001 598 10
2462499 2462499 2022-05-01 Adams North Dakota 38001 598 10
2459243 2459243 2022-04-30 Adams North Dakota 38001 598 10
2455987 2455987 2022-04-29 Adams North Dakota 38001 598 10
2452731 2452731 2022-04-28 Adams North Dakota 38001 598 10
2449475 2449475 2022-04-27 Adams North Dakota 38001 598 10
2446218 2446218 2022-04-26 Adams North Dakota 38001 598 10
2442963 2442963 2022-04-25 Adams North Dakota 38001 598 10
2439707 2439707 2022-04-24 Adams North Dakota 38001 598 10
2436451 2436451 2022-04-23 Adams North Dakota 38001 598 10
2433195 2433195 2022-04-22 Adams North Dakota 38001 598 10
2429939 2429939 2022-04-21 Adams North Dakota 38001 598 10
2426683 2426683 2022-04-20 Adams North Dakota 38001 598 10
2423427 2423427 2022-04-19 Adams North Dakota 38001 598 10
2420170 2420170 2022-04-18 Adams North Dakota 38001 598 10
2416915 2416915 2022-04-17 Adams North Dakota 38001 598 10
2413659 2413659 2022-04-16 Adams North Dakota 38001 598 10
2410403 2410403 2022-04-15 Adams North Dakota 38001 598 10
2407147 2407147 2022-04-14 Adams North Dakota 38001 598 10
2403891 2403891 2022-04-13 Adams North Dakota 38001 598 10
2400636 2400636 2022-04-12 Adams North Dakota 38001 598 10
2397381 2397381 2022-04-11 Adams North Dakota 38001 598 10
2394126 2394126 2022-04-10 Adams North Dakota 38001 598 10
2390870 2390870 2022-04-09 Adams North Dakota 38001 598 10
2387614 2387614 2022-04-08 Adams North Dakota 38001 598 10
2384359 2384359 2022-04-07 Adams North Dakota 38001 598 10
2381104 2381104 2022-04-06 Adams North Dakota 38001 598 10
2377849 2377849 2022-04-05 Adams North Dakota 38001 598 10
2374596 2374596 2022-04-04 Adams North Dakota 38001 598 10
2371344 2371344 2022-04-03 Adams North Dakota 38001 598 10
2368091 2368091 2022-04-02 Adams North Dakota 38001 598 10
2364838 2364838 2022-04-01 Adams North Dakota 38001 598 10
2361584 2361584 2022-03-31 Adams North Dakota 38001 598 10
2358330 2358330 2022-03-30 Adams North Dakota 38001 598 10
2355076 2355076 2022-03-29 Adams North Dakota 38001 598 10
2351823 2351823 2022-03-28 Adams North Dakota 38001 598 10
2348571 2348571 2022-03-27 Adams North Dakota 38001 598 10
2345318 2345318 2022-03-26 Adams North Dakota 38001 598 10
2342065 2342065 2022-03-25 Adams North Dakota 38001 598 10
2338812 2338812 2022-03-24 Adams North Dakota 38001 597 10
2335558 2335558 2022-03-23 Adams North Dakota 38001 597 10
2332304 2332304 2022-03-22 Adams North Dakota 38001 597 10
2329051 2329051 2022-03-21 Adams North Dakota 38001 597 10
2325799 2325799 2022-03-20 Adams North Dakota 38001 597 10
2322546 2322546 2022-03-19 Adams North Dakota 38001 597 10
2319292 2319292 2022-03-18 Adams North Dakota 38001 597 10
2316038 2316038 2022-03-17 Adams North Dakota 38001 598 10
2312785 2312785 2022-03-16 Adams North Dakota 38001 598 10
2309532 2309532 2022-03-15 Adams North Dakota 38001 598 10
2306279 2306279 2022-03-14 Adams North Dakota 38001 598 10
2303028 2303028 2022-03-13 Adams North Dakota 38001 598 10
2299776 2299776 2022-03-12 Adams North Dakota 38001 597 10
2296524 2296524 2022-03-11 Adams North Dakota 38001 597 10
2293272 2293272 2022-03-10 Adams North Dakota 38001 594 10
2290020 2290020 2022-03-09 Adams North Dakota 38001 594 10
2286768 2286768 2022-03-08 Adams North Dakota 38001 594 10
2283516 2283516 2022-03-07 Adams North Dakota 38001 594 10
2280264 2280264 2022-03-06 Adams North Dakota 38001 594 10
2277011 2277011 2022-03-05 Adams North Dakota 38001 594 10
2273758 2273758 2022-03-04 Adams North Dakota 38001 594 10
2270505 2270505 2022-03-03 Adams North Dakota 38001 592 10
2267253 2267253 2022-03-02 Adams North Dakota 38001 592 10
2264001 2264001 2022-03-01 Adams North Dakota 38001 590 10
2260750 2260750 2022-02-28 Adams North Dakota 38001 591 10
2257499 2257499 2022-02-27 Adams North Dakota 38001 591 10
2254248 2254248 2022-02-26 Adams North Dakota 38001 591 10
2250997 2250997 2022-02-25 Adams North Dakota 38001 590 10
2247746 2247746 2022-02-24 Adams North Dakota 38001 589 9
2244495 2244495 2022-02-23 Adams North Dakota 38001 585 9
2241244 2241244 2022-02-22 Adams North Dakota 38001 585 9
2237993 2237993 2022-02-21 Adams North Dakota 38001 584 9
2234742 2234742 2022-02-20 Adams North Dakota 38001 584 9
2231491 2231491 2022-02-19 Adams North Dakota 38001 583 9
2228240 2228240 2022-02-18 Adams North Dakota 38001 581 9
2224989 2224989 2022-02-17 Adams North Dakota 38001 575 9
2221738 2221738 2022-02-16 Adams North Dakota 38001 574 9
2218487 2218487 2022-02-15 Adams North Dakota 38001 570 9
2215236 2215236 2022-02-14 Adams North Dakota 38001 569 9
2211985 2211985 2022-02-13 Adams North Dakota 38001 569 9
2208732 2208732 2022-02-12 Adams North Dakota 38001 569 9
2205479 2205479 2022-02-11 Adams North Dakota 38001 566 9
2202226 2202226 2022-02-10 Adams North Dakota 38001 560 9
2198972 2198972 2022-02-09 Adams North Dakota 38001 560 9
2195718 2195718 2022-02-08 Adams North Dakota 38001 560 9
2192464 2192464 2022-02-07 Adams North Dakota 38001 559 9
2189210 2189210 2022-02-06 Adams North Dakota 38001 558 9
2185957 2185957 2022-02-05 Adams North Dakota 38001 558 9
2182705 2182705 2022-02-04 Adams North Dakota 38001 557 9
2179453 2179453 2022-02-03 Adams North Dakota 38001 556 9

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