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

787 rows where fips = 28027 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 · 787 ✖

fips 1

  • 28027 · 787 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2501006 2501006 2022-05-13 Coahoma Mississippi 28027 6486 126
2497748 2497748 2022-05-12 Coahoma Mississippi 28027 6486 126
2494490 2494490 2022-05-11 Coahoma Mississippi 28027 6486 126
2491232 2491232 2022-05-10 Coahoma Mississippi 28027 6486 126
2487975 2487975 2022-05-09 Coahoma Mississippi 28027 6486 126
2484717 2484717 2022-05-08 Coahoma Mississippi 28027 6471 126
2481459 2481459 2022-05-07 Coahoma Mississippi 28027 6471 126
2478201 2478201 2022-05-06 Coahoma Mississippi 28027 6471 126
2474943 2474943 2022-05-05 Coahoma Mississippi 28027 6471 126
2471686 2471686 2022-05-04 Coahoma Mississippi 28027 6471 126
2468430 2468430 2022-05-03 Coahoma Mississippi 28027 6471 126
2465175 2465175 2022-05-02 Coahoma Mississippi 28027 6471 126
2461919 2461919 2022-05-01 Coahoma Mississippi 28027 6464 126
2458663 2458663 2022-04-30 Coahoma Mississippi 28027 6464 126
2455407 2455407 2022-04-29 Coahoma Mississippi 28027 6464 126
2452151 2452151 2022-04-28 Coahoma Mississippi 28027 6464 126
2448895 2448895 2022-04-27 Coahoma Mississippi 28027 6464 126
2445639 2445639 2022-04-26 Coahoma Mississippi 28027 6464 126
2442383 2442383 2022-04-25 Coahoma Mississippi 28027 6464 126
2439127 2439127 2022-04-24 Coahoma Mississippi 28027 6464 126
2435871 2435871 2022-04-23 Coahoma Mississippi 28027 6464 126
2432615 2432615 2022-04-22 Coahoma Mississippi 28027 6464 126
2429359 2429359 2022-04-21 Coahoma Mississippi 28027 6464 126
2426103 2426103 2022-04-20 Coahoma Mississippi 28027 6464 126
2422847 2422847 2022-04-19 Coahoma Mississippi 28027 6464 126
2419591 2419591 2022-04-18 Coahoma Mississippi 28027 6464 126
2416335 2416335 2022-04-17 Coahoma Mississippi 28027 6462 126
2413079 2413079 2022-04-16 Coahoma Mississippi 28027 6462 126
2409823 2409823 2022-04-15 Coahoma Mississippi 28027 6462 126
2406567 2406567 2022-04-14 Coahoma Mississippi 28027 6462 126
2403311 2403311 2022-04-13 Coahoma Mississippi 28027 6462 126
2400057 2400057 2022-04-12 Coahoma Mississippi 28027 6462 126
2396801 2396801 2022-04-11 Coahoma Mississippi 28027 6460 125
2393546 2393546 2022-04-10 Coahoma Mississippi 28027 6460 125
2390290 2390290 2022-04-09 Coahoma Mississippi 28027 6460 125
2387034 2387034 2022-04-08 Coahoma Mississippi 28027 6460 125
2383779 2383779 2022-04-07 Coahoma Mississippi 28027 6460 125
2380524 2380524 2022-04-06 Coahoma Mississippi 28027 6460 125
2377269 2377269 2022-04-05 Coahoma Mississippi 28027 6460 125
2374017 2374017 2022-04-04 Coahoma Mississippi 28027 6460 125
2370764 2370764 2022-04-03 Coahoma Mississippi 28027 6454 123
2367511 2367511 2022-04-02 Coahoma Mississippi 28027 6454 123
2364258 2364258 2022-04-01 Coahoma Mississippi 28027 6454 123
2361004 2361004 2022-03-31 Coahoma Mississippi 28027 6454 123
2357750 2357750 2022-03-30 Coahoma Mississippi 28027 6454 123
2354497 2354497 2022-03-29 Coahoma Mississippi 28027 6454 123
2351245 2351245 2022-03-28 Coahoma Mississippi 28027 6454 123
2347992 2347992 2022-03-27 Coahoma Mississippi 28027 6441 122
2344739 2344739 2022-03-26 Coahoma Mississippi 28027 6441 122
2341486 2341486 2022-03-25 Coahoma Mississippi 28027 6441 122
2338233 2338233 2022-03-24 Coahoma Mississippi 28027 6441 122
2334979 2334979 2022-03-23 Coahoma Mississippi 28027 6441 122
2331725 2331725 2022-03-22 Coahoma Mississippi 28027 6441 122
2328473 2328473 2022-03-21 Coahoma Mississippi 28027 6441 122
2325220 2325220 2022-03-20 Coahoma Mississippi 28027 6439 121
2321966 2321966 2022-03-19 Coahoma Mississippi 28027 6439 121
2318712 2318712 2022-03-18 Coahoma Mississippi 28027 6439 121
2315459 2315459 2022-03-17 Coahoma Mississippi 28027 6439 121
2312206 2312206 2022-03-16 Coahoma Mississippi 28027 6439 121
2308953 2308953 2022-03-15 Coahoma Mississippi 28027 6439 121
2305702 2305702 2022-03-14 Coahoma Mississippi 28027 6439 121
2302450 2302450 2022-03-13 Coahoma Mississippi 28027 6432 121
2299198 2299198 2022-03-12 Coahoma Mississippi 28027 6432 121
2295946 2295946 2022-03-11 Coahoma Mississippi 28027 6432 121
2292694 2292694 2022-03-10 Coahoma Mississippi 28027 6432 121
2289442 2289442 2022-03-09 Coahoma Mississippi 28027 6432 121
2286191 2286191 2022-03-08 Coahoma Mississippi 28027 6432 121
2282939 2282939 2022-03-07 Coahoma Mississippi 28027 6432 120
2279686 2279686 2022-03-06 Coahoma Mississippi 28027 6430 120
2276433 2276433 2022-03-05 Coahoma Mississippi 28027 6430 120
2273180 2273180 2022-03-04 Coahoma Mississippi 28027 6430 120
2269928 2269928 2022-03-03 Coahoma Mississippi 28027 6429 120
2266675 2266675 2022-03-02 Coahoma Mississippi 28027 6430 120
2263424 2263424 2022-03-01 Coahoma Mississippi 28027 6427 120
2260173 2260173 2022-02-28 Coahoma Mississippi 28027 6430 120
2256922 2256922 2022-02-27 Coahoma Mississippi 28027 6423 120
2253671 2253671 2022-02-26 Coahoma Mississippi 28027 6423 120
2250420 2250420 2022-02-25 Coahoma Mississippi 28027 6423 120
2247169 2247169 2022-02-24 Coahoma Mississippi 28027 6412 120
2243918 2243918 2022-02-23 Coahoma Mississippi 28027 6411 120
2240667 2240667 2022-02-22 Coahoma Mississippi 28027 6409 119
2237416 2237416 2022-02-21 Coahoma Mississippi 28027 6404 119
2234165 2234165 2022-02-20 Coahoma Mississippi 28027 6404 119
2230914 2230914 2022-02-19 Coahoma Mississippi 28027 6404 119
2227663 2227663 2022-02-18 Coahoma Mississippi 28027 6404 119
2224412 2224412 2022-02-17 Coahoma Mississippi 28027 6397 119
2221161 2221161 2022-02-16 Coahoma Mississippi 28027 6395 119
2217910 2217910 2022-02-15 Coahoma Mississippi 28027 6393 119
2214659 2214659 2022-02-14 Coahoma Mississippi 28027 6383 119
2211407 2211407 2022-02-13 Coahoma Mississippi 28027 6337 119
2208154 2208154 2022-02-12 Coahoma Mississippi 28027 6337 119
2204901 2204901 2022-02-11 Coahoma Mississippi 28027 6337 119
2201648 2201648 2022-02-10 Coahoma Mississippi 28027 6335 119
2198394 2198394 2022-02-09 Coahoma Mississippi 28027 6330 119
2195140 2195140 2022-02-08 Coahoma Mississippi 28027 6315 119
2191886 2191886 2022-02-07 Coahoma Mississippi 28027 6297 119
2188633 2188633 2022-02-06 Coahoma Mississippi 28027 6150 119
2185380 2185380 2022-02-05 Coahoma Mississippi 28027 6150 119
2182128 2182128 2022-02-04 Coahoma Mississippi 28027 6150 119
2178876 2178876 2022-02-03 Coahoma Mississippi 28027 6084 119

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