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

771 rows where county = "Slope" 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 · 771 ✖

fips 1

county 1

  • Slope · 771 ✖
Link rowid date ▲ county state fips cases deaths
2501629 2501629 2022-05-13 Slope North Dakota 38087 63 0
2498371 2498371 2022-05-12 Slope North Dakota 38087 63 0
2495113 2495113 2022-05-11 Slope North Dakota 38087 63 0
2491855 2491855 2022-05-10 Slope North Dakota 38087 63 0
2488597 2488597 2022-05-09 Slope North Dakota 38087 63 0
2485340 2485340 2022-05-08 Slope North Dakota 38087 63 0
2482082 2482082 2022-05-07 Slope North Dakota 38087 63 0
2478824 2478824 2022-05-06 Slope North Dakota 38087 63 0
2475566 2475566 2022-05-05 Slope North Dakota 38087 63 0
2472309 2472309 2022-05-04 Slope North Dakota 38087 63 0
2469053 2469053 2022-05-03 Slope North Dakota 38087 63 0
2465797 2465797 2022-05-02 Slope North Dakota 38087 63 0
2462542 2462542 2022-05-01 Slope North Dakota 38087 63 0
2459286 2459286 2022-04-30 Slope North Dakota 38087 63 0
2456030 2456030 2022-04-29 Slope North Dakota 38087 63 0
2452774 2452774 2022-04-28 Slope North Dakota 38087 63 0
2449518 2449518 2022-04-27 Slope North Dakota 38087 63 0
2446261 2446261 2022-04-26 Slope North Dakota 38087 63 0
2443006 2443006 2022-04-25 Slope North Dakota 38087 63 0
2439750 2439750 2022-04-24 Slope North Dakota 38087 63 0
2436494 2436494 2022-04-23 Slope North Dakota 38087 63 0
2433238 2433238 2022-04-22 Slope North Dakota 38087 63 0
2429982 2429982 2022-04-21 Slope North Dakota 38087 63 0
2426726 2426726 2022-04-20 Slope North Dakota 38087 63 0
2423470 2423470 2022-04-19 Slope North Dakota 38087 63 0
2420213 2420213 2022-04-18 Slope North Dakota 38087 63 0
2416958 2416958 2022-04-17 Slope North Dakota 38087 63 0
2413702 2413702 2022-04-16 Slope North Dakota 38087 63 0
2410446 2410446 2022-04-15 Slope North Dakota 38087 63 0
2407190 2407190 2022-04-14 Slope North Dakota 38087 63 0
2403934 2403934 2022-04-13 Slope North Dakota 38087 63 0
2400679 2400679 2022-04-12 Slope North Dakota 38087 63 0
2397424 2397424 2022-04-11 Slope North Dakota 38087 63 0
2394169 2394169 2022-04-10 Slope North Dakota 38087 63 0
2390913 2390913 2022-04-09 Slope North Dakota 38087 63 0
2387657 2387657 2022-04-08 Slope North Dakota 38087 63 0
2384402 2384402 2022-04-07 Slope North Dakota 38087 63 0
2381147 2381147 2022-04-06 Slope North Dakota 38087 63 0
2377892 2377892 2022-04-05 Slope North Dakota 38087 63 0
2374639 2374639 2022-04-04 Slope North Dakota 38087 63 0
2371387 2371387 2022-04-03 Slope North Dakota 38087 63 0
2368134 2368134 2022-04-02 Slope North Dakota 38087 63 0
2364881 2364881 2022-04-01 Slope North Dakota 38087 63 0
2361627 2361627 2022-03-31 Slope North Dakota 38087 63 0
2358373 2358373 2022-03-30 Slope North Dakota 38087 63 0
2355119 2355119 2022-03-29 Slope North Dakota 38087 63 0
2351866 2351866 2022-03-28 Slope North Dakota 38087 63 0
2348614 2348614 2022-03-27 Slope North Dakota 38087 63 0
2345361 2345361 2022-03-26 Slope North Dakota 38087 63 0
2342108 2342108 2022-03-25 Slope North Dakota 38087 63 0
2338855 2338855 2022-03-24 Slope North Dakota 38087 63 0
2335601 2335601 2022-03-23 Slope North Dakota 38087 63 0
2332347 2332347 2022-03-22 Slope North Dakota 38087 63 0
2329094 2329094 2022-03-21 Slope North Dakota 38087 63 0
2325842 2325842 2022-03-20 Slope North Dakota 38087 63 0
2322589 2322589 2022-03-19 Slope North Dakota 38087 63 0
2319335 2319335 2022-03-18 Slope North Dakota 38087 63 0
2316081 2316081 2022-03-17 Slope North Dakota 38087 61 0
2312828 2312828 2022-03-16 Slope North Dakota 38087 61 0
2309575 2309575 2022-03-15 Slope North Dakota 38087 61 0
2306322 2306322 2022-03-14 Slope North Dakota 38087 61 0
2303071 2303071 2022-03-13 Slope North Dakota 38087 61 0
2299819 2299819 2022-03-12 Slope North Dakota 38087 61 0
2296567 2296567 2022-03-11 Slope North Dakota 38087 63 0
2293315 2293315 2022-03-10 Slope North Dakota 38087 63 0
2290063 2290063 2022-03-09 Slope North Dakota 38087 63 0
2286811 2286811 2022-03-08 Slope North Dakota 38087 63 0
2283559 2283559 2022-03-07 Slope North Dakota 38087 63 0
2280307 2280307 2022-03-06 Slope North Dakota 38087 63 0
2277054 2277054 2022-03-05 Slope North Dakota 38087 63 0
2273801 2273801 2022-03-04 Slope North Dakota 38087 63 0
2270548 2270548 2022-03-03 Slope North Dakota 38087 63 0
2267296 2267296 2022-03-02 Slope North Dakota 38087 63 0
2264044 2264044 2022-03-01 Slope North Dakota 38087 63 0
2260793 2260793 2022-02-28 Slope North Dakota 38087 63 0
2257542 2257542 2022-02-27 Slope North Dakota 38087 63 0
2254291 2254291 2022-02-26 Slope North Dakota 38087 63 0
2251040 2251040 2022-02-25 Slope North Dakota 38087 63 0
2247789 2247789 2022-02-24 Slope North Dakota 38087 63 0
2244538 2244538 2022-02-23 Slope North Dakota 38087 64 0
2241287 2241287 2022-02-22 Slope North Dakota 38087 64 0
2238036 2238036 2022-02-21 Slope North Dakota 38087 64 0
2234785 2234785 2022-02-20 Slope North Dakota 38087 64 0
2231534 2231534 2022-02-19 Slope North Dakota 38087 64 0
2228283 2228283 2022-02-18 Slope North Dakota 38087 64 0
2225032 2225032 2022-02-17 Slope North Dakota 38087 64 0
2221781 2221781 2022-02-16 Slope North Dakota 38087 63 0
2218530 2218530 2022-02-15 Slope North Dakota 38087 63 0
2215279 2215279 2022-02-14 Slope North Dakota 38087 63 0
2212028 2212028 2022-02-13 Slope North Dakota 38087 63 0
2208775 2208775 2022-02-12 Slope North Dakota 38087 63 0
2205522 2205522 2022-02-11 Slope North Dakota 38087 63 0
2202269 2202269 2022-02-10 Slope North Dakota 38087 63 0
2199015 2199015 2022-02-09 Slope North Dakota 38087 62 0
2195761 2195761 2022-02-08 Slope North Dakota 38087 62 0
2192507 2192507 2022-02-07 Slope North Dakota 38087 62 0
2189253 2189253 2022-02-06 Slope North Dakota 38087 62 0
2186000 2186000 2022-02-05 Slope North Dakota 38087 62 0
2182748 2182748 2022-02-04 Slope North Dakota 38087 62 0
2179496 2179496 2022-02-03 Slope North Dakota 38087 62 0

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