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

780 rows where county = "Calhoun", fips = 28013 and state = "Mississippi" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Mississippi · 780 ✖

fips 1

  • 28013 · 780 ✖

county 1

  • Calhoun · 780 ✖
Link rowid date ▲ county state fips cases deaths
2500999 2500999 2022-05-13 Calhoun Mississippi 28013 4641 71
2497741 2497741 2022-05-12 Calhoun Mississippi 28013 4641 71
2494483 2494483 2022-05-11 Calhoun Mississippi 28013 4641 71
2491225 2491225 2022-05-10 Calhoun Mississippi 28013 4641 71
2487968 2487968 2022-05-09 Calhoun Mississippi 28013 4641 71
2484710 2484710 2022-05-08 Calhoun Mississippi 28013 4639 71
2481452 2481452 2022-05-07 Calhoun Mississippi 28013 4639 71
2478194 2478194 2022-05-06 Calhoun Mississippi 28013 4639 71
2474936 2474936 2022-05-05 Calhoun Mississippi 28013 4639 71
2471679 2471679 2022-05-04 Calhoun Mississippi 28013 4639 71
2468423 2468423 2022-05-03 Calhoun Mississippi 28013 4639 71
2465168 2465168 2022-05-02 Calhoun Mississippi 28013 4639 71
2461912 2461912 2022-05-01 Calhoun Mississippi 28013 4638 71
2458656 2458656 2022-04-30 Calhoun Mississippi 28013 4638 71
2455400 2455400 2022-04-29 Calhoun Mississippi 28013 4638 71
2452144 2452144 2022-04-28 Calhoun Mississippi 28013 4638 71
2448888 2448888 2022-04-27 Calhoun Mississippi 28013 4638 71
2445632 2445632 2022-04-26 Calhoun Mississippi 28013 4638 71
2442376 2442376 2022-04-25 Calhoun Mississippi 28013 4638 70
2439120 2439120 2022-04-24 Calhoun Mississippi 28013 4638 70
2435864 2435864 2022-04-23 Calhoun Mississippi 28013 4638 70
2432608 2432608 2022-04-22 Calhoun Mississippi 28013 4638 70
2429352 2429352 2022-04-21 Calhoun Mississippi 28013 4638 70
2426096 2426096 2022-04-20 Calhoun Mississippi 28013 4638 70
2422840 2422840 2022-04-19 Calhoun Mississippi 28013 4638 70
2419584 2419584 2022-04-18 Calhoun Mississippi 28013 4638 70
2416328 2416328 2022-04-17 Calhoun Mississippi 28013 4638 70
2413072 2413072 2022-04-16 Calhoun Mississippi 28013 4638 70
2409816 2409816 2022-04-15 Calhoun Mississippi 28013 4638 70
2406560 2406560 2022-04-14 Calhoun Mississippi 28013 4638 70
2403304 2403304 2022-04-13 Calhoun Mississippi 28013 4638 70
2400050 2400050 2022-04-12 Calhoun Mississippi 28013 4638 70
2396794 2396794 2022-04-11 Calhoun Mississippi 28013 4637 70
2393539 2393539 2022-04-10 Calhoun Mississippi 28013 4637 70
2390283 2390283 2022-04-09 Calhoun Mississippi 28013 4637 70
2387027 2387027 2022-04-08 Calhoun Mississippi 28013 4637 70
2383772 2383772 2022-04-07 Calhoun Mississippi 28013 4637 70
2380517 2380517 2022-04-06 Calhoun Mississippi 28013 4637 70
2377262 2377262 2022-04-05 Calhoun Mississippi 28013 4637 70
2374010 2374010 2022-04-04 Calhoun Mississippi 28013 4637 70
2370757 2370757 2022-04-03 Calhoun Mississippi 28013 4636 70
2367504 2367504 2022-04-02 Calhoun Mississippi 28013 4636 70
2364251 2364251 2022-04-01 Calhoun Mississippi 28013 4636 70
2360997 2360997 2022-03-31 Calhoun Mississippi 28013 4636 70
2357743 2357743 2022-03-30 Calhoun Mississippi 28013 4636 70
2354490 2354490 2022-03-29 Calhoun Mississippi 28013 4636 70
2351238 2351238 2022-03-28 Calhoun Mississippi 28013 4636 70
2347985 2347985 2022-03-27 Calhoun Mississippi 28013 4636 70
2344732 2344732 2022-03-26 Calhoun Mississippi 28013 4636 70
2341479 2341479 2022-03-25 Calhoun Mississippi 28013 4636 70
2338226 2338226 2022-03-24 Calhoun Mississippi 28013 4636 70
2334972 2334972 2022-03-23 Calhoun Mississippi 28013 4636 70
2331718 2331718 2022-03-22 Calhoun Mississippi 28013 4636 70
2328466 2328466 2022-03-21 Calhoun Mississippi 28013 4636 70
2325213 2325213 2022-03-20 Calhoun Mississippi 28013 4635 70
2321959 2321959 2022-03-19 Calhoun Mississippi 28013 4635 70
2318705 2318705 2022-03-18 Calhoun Mississippi 28013 4635 70
2315452 2315452 2022-03-17 Calhoun Mississippi 28013 4635 70
2312199 2312199 2022-03-16 Calhoun Mississippi 28013 4635 70
2308946 2308946 2022-03-15 Calhoun Mississippi 28013 4635 70
2305695 2305695 2022-03-14 Calhoun Mississippi 28013 4635 70
2302443 2302443 2022-03-13 Calhoun Mississippi 28013 4632 70
2299191 2299191 2022-03-12 Calhoun Mississippi 28013 4632 70
2295939 2295939 2022-03-11 Calhoun Mississippi 28013 4632 70
2292687 2292687 2022-03-10 Calhoun Mississippi 28013 4632 70
2289435 2289435 2022-03-09 Calhoun Mississippi 28013 4632 70
2286184 2286184 2022-03-08 Calhoun Mississippi 28013 4632 70
2282932 2282932 2022-03-07 Calhoun Mississippi 28013 4632 70
2279679 2279679 2022-03-06 Calhoun Mississippi 28013 4632 70
2276426 2276426 2022-03-05 Calhoun Mississippi 28013 4632 70
2273173 2273173 2022-03-04 Calhoun Mississippi 28013 4632 70
2269921 2269921 2022-03-03 Calhoun Mississippi 28013 4632 70
2266668 2266668 2022-03-02 Calhoun Mississippi 28013 4632 69
2263417 2263417 2022-03-01 Calhoun Mississippi 28013 4632 69
2260166 2260166 2022-02-28 Calhoun Mississippi 28013 4631 67
2256915 2256915 2022-02-27 Calhoun Mississippi 28013 4622 65
2253664 2253664 2022-02-26 Calhoun Mississippi 28013 4622 65
2250413 2250413 2022-02-25 Calhoun Mississippi 28013 4622 65
2247162 2247162 2022-02-24 Calhoun Mississippi 28013 4603 65
2243911 2243911 2022-02-23 Calhoun Mississippi 28013 4593 65
2240660 2240660 2022-02-22 Calhoun Mississippi 28013 4589 63
2237409 2237409 2022-02-21 Calhoun Mississippi 28013 4566 62
2234158 2234158 2022-02-20 Calhoun Mississippi 28013 4566 62
2230907 2230907 2022-02-19 Calhoun Mississippi 28013 4566 62
2227656 2227656 2022-02-18 Calhoun Mississippi 28013 4566 62
2224405 2224405 2022-02-17 Calhoun Mississippi 28013 4544 60
2221154 2221154 2022-02-16 Calhoun Mississippi 28013 4543 60
2217903 2217903 2022-02-15 Calhoun Mississippi 28013 4536 59
2214652 2214652 2022-02-14 Calhoun Mississippi 28013 4531 59
2211400 2211400 2022-02-13 Calhoun Mississippi 28013 4496 58
2208147 2208147 2022-02-12 Calhoun Mississippi 28013 4496 58
2204894 2204894 2022-02-11 Calhoun Mississippi 28013 4496 58
2201641 2201641 2022-02-10 Calhoun Mississippi 28013 4491 57
2198387 2198387 2022-02-09 Calhoun Mississippi 28013 4485 57
2195133 2195133 2022-02-08 Calhoun Mississippi 28013 4473 57
2191879 2191879 2022-02-07 Calhoun Mississippi 28013 4461 56
2188626 2188626 2022-02-06 Calhoun Mississippi 28013 4417 56
2185373 2185373 2022-02-05 Calhoun Mississippi 28013 4417 56
2182121 2182121 2022-02-04 Calhoun Mississippi 28013 4417 56
2178869 2178869 2022-02-03 Calhoun Mississippi 28013 4367 56

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