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

772 rows where county = "Mitchell" and fips = 37121 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

  • 37121 · 772 ✖

county 1

  • Mitchell · 772 ✖
Link rowid date ▲ county state fips cases deaths
2501546 2501546 2022-05-13 Mitchell North Carolina 37121 3474 37
2498288 2498288 2022-05-12 Mitchell North Carolina 37121 3474 37
2495030 2495030 2022-05-11 Mitchell North Carolina 37121 3474 37
2491772 2491772 2022-05-10 Mitchell North Carolina 37121 3466 37
2488514 2488514 2022-05-09 Mitchell North Carolina 37121 3466 37
2485257 2485257 2022-05-08 Mitchell North Carolina 37121 3466 37
2481999 2481999 2022-05-07 Mitchell North Carolina 37121 3466 37
2478741 2478741 2022-05-06 Mitchell North Carolina 37121 3466 37
2475483 2475483 2022-05-05 Mitchell North Carolina 37121 3466 37
2472226 2472226 2022-05-04 Mitchell North Carolina 37121 3466 37
2468970 2468970 2022-05-03 Mitchell North Carolina 37121 3464 34
2465714 2465714 2022-05-02 Mitchell North Carolina 37121 3464 34
2462459 2462459 2022-05-01 Mitchell North Carolina 37121 3464 34
2459203 2459203 2022-04-30 Mitchell North Carolina 37121 3464 34
2455947 2455947 2022-04-29 Mitchell North Carolina 37121 3464 34
2452691 2452691 2022-04-28 Mitchell North Carolina 37121 3464 34
2449435 2449435 2022-04-27 Mitchell North Carolina 37121 3464 34
2446178 2446178 2022-04-26 Mitchell North Carolina 37121 3435 34
2442923 2442923 2022-04-25 Mitchell North Carolina 37121 3435 34
2439667 2439667 2022-04-24 Mitchell North Carolina 37121 3435 34
2436411 2436411 2022-04-23 Mitchell North Carolina 37121 3435 34
2433155 2433155 2022-04-22 Mitchell North Carolina 37121 3435 34
2429899 2429899 2022-04-21 Mitchell North Carolina 37121 3435 34
2426643 2426643 2022-04-20 Mitchell North Carolina 37121 3435 34
2423387 2423387 2022-04-19 Mitchell North Carolina 37121 3430 34
2420130 2420130 2022-04-18 Mitchell North Carolina 37121 3430 34
2416875 2416875 2022-04-17 Mitchell North Carolina 37121 3430 34
2413619 2413619 2022-04-16 Mitchell North Carolina 37121 3430 34
2410363 2410363 2022-04-15 Mitchell North Carolina 37121 3430 34
2407107 2407107 2022-04-14 Mitchell North Carolina 37121 3430 34
2403851 2403851 2022-04-13 Mitchell North Carolina 37121 3430 34
2400596 2400596 2022-04-12 Mitchell North Carolina 37121 3425 34
2397341 2397341 2022-04-11 Mitchell North Carolina 37121 3425 34
2394086 2394086 2022-04-10 Mitchell North Carolina 37121 3425 34
2390830 2390830 2022-04-09 Mitchell North Carolina 37121 3425 34
2387574 2387574 2022-04-08 Mitchell North Carolina 37121 3425 34
2384319 2384319 2022-04-07 Mitchell North Carolina 37121 3425 34
2381064 2381064 2022-04-06 Mitchell North Carolina 37121 3425 34
2377809 2377809 2022-04-05 Mitchell North Carolina 37121 3425 34
2374556 2374556 2022-04-04 Mitchell North Carolina 37121 3424 34
2371304 2371304 2022-04-03 Mitchell North Carolina 37121 3419 34
2368051 2368051 2022-04-02 Mitchell North Carolina 37121 3419 34
2364798 2364798 2022-04-01 Mitchell North Carolina 37121 3419 34
2361544 2361544 2022-03-31 Mitchell North Carolina 37121 3417 34
2358290 2358290 2022-03-30 Mitchell North Carolina 37121 3416 34
2355036 2355036 2022-03-29 Mitchell North Carolina 37121 3416 34
2351783 2351783 2022-03-28 Mitchell North Carolina 37121 3416 34
2348531 2348531 2022-03-27 Mitchell North Carolina 37121 3377 34
2345278 2345278 2022-03-26 Mitchell North Carolina 37121 3377 34
2342025 2342025 2022-03-25 Mitchell North Carolina 37121 3377 34
2338772 2338772 2022-03-24 Mitchell North Carolina 37121 3370 34
2335518 2335518 2022-03-23 Mitchell North Carolina 37121 3362 34
2332264 2332264 2022-03-22 Mitchell North Carolina 37121 3362 34
2329011 2329011 2022-03-21 Mitchell North Carolina 37121 3348 34
2325759 2325759 2022-03-20 Mitchell North Carolina 37121 3319 34
2322506 2322506 2022-03-19 Mitchell North Carolina 37121 3319 34
2319252 2319252 2022-03-18 Mitchell North Carolina 37121 3319 34
2315998 2315998 2022-03-17 Mitchell North Carolina 37121 3315 34
2312745 2312745 2022-03-16 Mitchell North Carolina 37121 3303 34
2309492 2309492 2022-03-15 Mitchell North Carolina 37121 3292 34
2306239 2306239 2022-03-14 Mitchell North Carolina 37121 3287 34
2302988 2302988 2022-03-13 Mitchell North Carolina 37121 3271 34
2299736 2299736 2022-03-12 Mitchell North Carolina 37121 3271 34
2296484 2296484 2022-03-11 Mitchell North Carolina 37121 3271 34
2293232 2293232 2022-03-10 Mitchell North Carolina 37121 3263 34
2289980 2289980 2022-03-09 Mitchell North Carolina 37121 3261 34
2286728 2286728 2022-03-08 Mitchell North Carolina 37121 3259 34
2283476 2283476 2022-03-07 Mitchell North Carolina 37121 3258 34
2280224 2280224 2022-03-06 Mitchell North Carolina 37121 3257 34
2276971 2276971 2022-03-05 Mitchell North Carolina 37121 3257 34
2273718 2273718 2022-03-04 Mitchell North Carolina 37121 3257 34
2270465 2270465 2022-03-03 Mitchell North Carolina 37121 3253 34
2267213 2267213 2022-03-02 Mitchell North Carolina 37121 3251 33
2263961 2263961 2022-03-01 Mitchell North Carolina 37121 3247 33
2260710 2260710 2022-02-28 Mitchell North Carolina 37121 3244 33
2257459 2257459 2022-02-27 Mitchell North Carolina 37121 3236 33
2254208 2254208 2022-02-26 Mitchell North Carolina 37121 3236 33
2250957 2250957 2022-02-25 Mitchell North Carolina 37121 3236 33
2247706 2247706 2022-02-24 Mitchell North Carolina 37121 3230 33
2244455 2244455 2022-02-23 Mitchell North Carolina 37121 3225 33
2241204 2241204 2022-02-22 Mitchell North Carolina 37121 3220 33
2237953 2237953 2022-02-21 Mitchell North Carolina 37121 3218 33
2234702 2234702 2022-02-20 Mitchell North Carolina 37121 3204 33
2231451 2231451 2022-02-19 Mitchell North Carolina 37121 3204 33
2228200 2228200 2022-02-18 Mitchell North Carolina 37121 3204 33
2224949 2224949 2022-02-17 Mitchell North Carolina 37121 3197 33
2221698 2221698 2022-02-16 Mitchell North Carolina 37121 3191 33
2218447 2218447 2022-02-15 Mitchell North Carolina 37121 3183 33
2215196 2215196 2022-02-14 Mitchell North Carolina 37121 3183 33
2211945 2211945 2022-02-13 Mitchell North Carolina 37121 3165 33
2208692 2208692 2022-02-12 Mitchell North Carolina 37121 3165 33
2205439 2205439 2022-02-11 Mitchell North Carolina 37121 3165 33
2202186 2202186 2022-02-10 Mitchell North Carolina 37121 3153 33
2198932 2198932 2022-02-09 Mitchell North Carolina 37121 3127 33
2195678 2195678 2022-02-08 Mitchell North Carolina 37121 3103 33
2192424 2192424 2022-02-07 Mitchell North Carolina 37121 3075 33
2189170 2189170 2022-02-06 Mitchell North Carolina 37121 3043 31
2185917 2185917 2022-02-05 Mitchell North Carolina 37121 3043 31
2182665 2182665 2022-02-04 Mitchell North Carolina 37121 3043 31
2179413 2179413 2022-02-03 Mitchell North Carolina 37121 3033 28

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