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

785 rows where fips = 28077 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 · 785 ✖

fips 1

  • 28077 · 785 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2501031 2501031 2022-05-13 Lawrence Mississippi 28077 3590 56
2497773 2497773 2022-05-12 Lawrence Mississippi 28077 3590 56
2494515 2494515 2022-05-11 Lawrence Mississippi 28077 3590 56
2491257 2491257 2022-05-10 Lawrence Mississippi 28077 3590 56
2488000 2488000 2022-05-09 Lawrence Mississippi 28077 3590 56
2484742 2484742 2022-05-08 Lawrence Mississippi 28077 3589 56
2481484 2481484 2022-05-07 Lawrence Mississippi 28077 3589 56
2478226 2478226 2022-05-06 Lawrence Mississippi 28077 3589 56
2474968 2474968 2022-05-05 Lawrence Mississippi 28077 3589 56
2471711 2471711 2022-05-04 Lawrence Mississippi 28077 3589 56
2468455 2468455 2022-05-03 Lawrence Mississippi 28077 3589 56
2465200 2465200 2022-05-02 Lawrence Mississippi 28077 3589 56
2461944 2461944 2022-05-01 Lawrence Mississippi 28077 3589 56
2458688 2458688 2022-04-30 Lawrence Mississippi 28077 3589 56
2455432 2455432 2022-04-29 Lawrence Mississippi 28077 3589 56
2452176 2452176 2022-04-28 Lawrence Mississippi 28077 3589 56
2448920 2448920 2022-04-27 Lawrence Mississippi 28077 3589 56
2445664 2445664 2022-04-26 Lawrence Mississippi 28077 3589 56
2442408 2442408 2022-04-25 Lawrence Mississippi 28077 3588 56
2439152 2439152 2022-04-24 Lawrence Mississippi 28077 3588 56
2435896 2435896 2022-04-23 Lawrence Mississippi 28077 3588 56
2432640 2432640 2022-04-22 Lawrence Mississippi 28077 3588 56
2429384 2429384 2022-04-21 Lawrence Mississippi 28077 3588 56
2426128 2426128 2022-04-20 Lawrence Mississippi 28077 3588 56
2422872 2422872 2022-04-19 Lawrence Mississippi 28077 3588 56
2419616 2419616 2022-04-18 Lawrence Mississippi 28077 3588 56
2416360 2416360 2022-04-17 Lawrence Mississippi 28077 3585 56
2413104 2413104 2022-04-16 Lawrence Mississippi 28077 3585 56
2409848 2409848 2022-04-15 Lawrence Mississippi 28077 3585 56
2406592 2406592 2022-04-14 Lawrence Mississippi 28077 3585 56
2403336 2403336 2022-04-13 Lawrence Mississippi 28077 3585 56
2400082 2400082 2022-04-12 Lawrence Mississippi 28077 3585 56
2396826 2396826 2022-04-11 Lawrence Mississippi 28077 3582 56
2393571 2393571 2022-04-10 Lawrence Mississippi 28077 3582 56
2390315 2390315 2022-04-09 Lawrence Mississippi 28077 3582 56
2387059 2387059 2022-04-08 Lawrence Mississippi 28077 3582 56
2383804 2383804 2022-04-07 Lawrence Mississippi 28077 3582 56
2380549 2380549 2022-04-06 Lawrence Mississippi 28077 3582 56
2377294 2377294 2022-04-05 Lawrence Mississippi 28077 3582 56
2374042 2374042 2022-04-04 Lawrence Mississippi 28077 3582 56
2370789 2370789 2022-04-03 Lawrence Mississippi 28077 3580 56
2367536 2367536 2022-04-02 Lawrence Mississippi 28077 3580 56
2364283 2364283 2022-04-01 Lawrence Mississippi 28077 3580 56
2361029 2361029 2022-03-31 Lawrence Mississippi 28077 3580 56
2357775 2357775 2022-03-30 Lawrence Mississippi 28077 3580 56
2354522 2354522 2022-03-29 Lawrence Mississippi 28077 3580 56
2351270 2351270 2022-03-28 Lawrence Mississippi 28077 3580 56
2348017 2348017 2022-03-27 Lawrence Mississippi 28077 3575 56
2344764 2344764 2022-03-26 Lawrence Mississippi 28077 3575 56
2341511 2341511 2022-03-25 Lawrence Mississippi 28077 3575 56
2338258 2338258 2022-03-24 Lawrence Mississippi 28077 3575 56
2335004 2335004 2022-03-23 Lawrence Mississippi 28077 3575 56
2331750 2331750 2022-03-22 Lawrence Mississippi 28077 3575 56
2328498 2328498 2022-03-21 Lawrence Mississippi 28077 3575 56
2325245 2325245 2022-03-20 Lawrence Mississippi 28077 3575 56
2321991 2321991 2022-03-19 Lawrence Mississippi 28077 3575 56
2318737 2318737 2022-03-18 Lawrence Mississippi 28077 3575 56
2315484 2315484 2022-03-17 Lawrence Mississippi 28077 3575 56
2312231 2312231 2022-03-16 Lawrence Mississippi 28077 3575 56
2308978 2308978 2022-03-15 Lawrence Mississippi 28077 3575 56
2305727 2305727 2022-03-14 Lawrence Mississippi 28077 3575 56
2302475 2302475 2022-03-13 Lawrence Mississippi 28077 3572 56
2299223 2299223 2022-03-12 Lawrence Mississippi 28077 3572 56
2295971 2295971 2022-03-11 Lawrence Mississippi 28077 3572 56
2292719 2292719 2022-03-10 Lawrence Mississippi 28077 3572 56
2289467 2289467 2022-03-09 Lawrence Mississippi 28077 3572 56
2286216 2286216 2022-03-08 Lawrence Mississippi 28077 3572 56
2282964 2282964 2022-03-07 Lawrence Mississippi 28077 3571 55
2279711 2279711 2022-03-06 Lawrence Mississippi 28077 3563 55
2276458 2276458 2022-03-05 Lawrence Mississippi 28077 3563 55
2273205 2273205 2022-03-04 Lawrence Mississippi 28077 3563 55
2269953 2269953 2022-03-03 Lawrence Mississippi 28077 3562 54
2266700 2266700 2022-03-02 Lawrence Mississippi 28077 3562 54
2263449 2263449 2022-03-01 Lawrence Mississippi 28077 3561 54
2260198 2260198 2022-02-28 Lawrence Mississippi 28077 3560 53
2256947 2256947 2022-02-27 Lawrence Mississippi 28077 3556 53
2253696 2253696 2022-02-26 Lawrence Mississippi 28077 3556 53
2250445 2250445 2022-02-25 Lawrence Mississippi 28077 3556 53
2247194 2247194 2022-02-24 Lawrence Mississippi 28077 3556 52
2243943 2243943 2022-02-23 Lawrence Mississippi 28077 3554 52
2240692 2240692 2022-02-22 Lawrence Mississippi 28077 3554 52
2237441 2237441 2022-02-21 Lawrence Mississippi 28077 3547 52
2234190 2234190 2022-02-20 Lawrence Mississippi 28077 3547 52
2230939 2230939 2022-02-19 Lawrence Mississippi 28077 3547 52
2227688 2227688 2022-02-18 Lawrence Mississippi 28077 3547 52
2224437 2224437 2022-02-17 Lawrence Mississippi 28077 3539 51
2221186 2221186 2022-02-16 Lawrence Mississippi 28077 3532 51
2217935 2217935 2022-02-15 Lawrence Mississippi 28077 3527 50
2214684 2214684 2022-02-14 Lawrence Mississippi 28077 3523 50
2211432 2211432 2022-02-13 Lawrence Mississippi 28077 3509 48
2208179 2208179 2022-02-12 Lawrence Mississippi 28077 3509 48
2204926 2204926 2022-02-11 Lawrence Mississippi 28077 3509 48
2201673 2201673 2022-02-10 Lawrence Mississippi 28077 3494 48
2198419 2198419 2022-02-09 Lawrence Mississippi 28077 3483 46
2195165 2195165 2022-02-08 Lawrence Mississippi 28077 3461 46
2191911 2191911 2022-02-07 Lawrence Mississippi 28077 3449 46
2188658 2188658 2022-02-06 Lawrence Mississippi 28077 3360 46
2185405 2185405 2022-02-05 Lawrence Mississippi 28077 3360 46
2182153 2182153 2022-02-04 Lawrence Mississippi 28077 3360 46
2178901 2178901 2022-02-03 Lawrence Mississippi 28077 3333 46

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