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

786 rows where fips = 28163 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

fips 1

  • 28163 · 786 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2501075 2501075 2022-05-13 Yazoo Mississippi 28163 8054 107
2497817 2497817 2022-05-12 Yazoo Mississippi 28163 8054 107
2494559 2494559 2022-05-11 Yazoo Mississippi 28163 8054 107
2491301 2491301 2022-05-10 Yazoo Mississippi 28163 8054 107
2488043 2488043 2022-05-09 Yazoo Mississippi 28163 8054 107
2484786 2484786 2022-05-08 Yazoo Mississippi 28163 8051 107
2481528 2481528 2022-05-07 Yazoo Mississippi 28163 8051 107
2478270 2478270 2022-05-06 Yazoo Mississippi 28163 8051 107
2475012 2475012 2022-05-05 Yazoo Mississippi 28163 8051 107
2471755 2471755 2022-05-04 Yazoo Mississippi 28163 8051 107
2468499 2468499 2022-05-03 Yazoo Mississippi 28163 8051 107
2465243 2465243 2022-05-02 Yazoo Mississippi 28163 8051 107
2461988 2461988 2022-05-01 Yazoo Mississippi 28163 8047 107
2458732 2458732 2022-04-30 Yazoo Mississippi 28163 8047 107
2455476 2455476 2022-04-29 Yazoo Mississippi 28163 8047 107
2452220 2452220 2022-04-28 Yazoo Mississippi 28163 8047 107
2448964 2448964 2022-04-27 Yazoo Mississippi 28163 8047 107
2445707 2445707 2022-04-26 Yazoo Mississippi 28163 8047 107
2442452 2442452 2022-04-25 Yazoo Mississippi 28163 8044 107
2439196 2439196 2022-04-24 Yazoo Mississippi 28163 8044 107
2435940 2435940 2022-04-23 Yazoo Mississippi 28163 8044 107
2432684 2432684 2022-04-22 Yazoo Mississippi 28163 8044 107
2429428 2429428 2022-04-21 Yazoo Mississippi 28163 8044 107
2426172 2426172 2022-04-20 Yazoo Mississippi 28163 8044 107
2422916 2422916 2022-04-19 Yazoo Mississippi 28163 8044 107
2419659 2419659 2022-04-18 Yazoo Mississippi 28163 8044 107
2416404 2416404 2022-04-17 Yazoo Mississippi 28163 8042 107
2413148 2413148 2022-04-16 Yazoo Mississippi 28163 8042 107
2409892 2409892 2022-04-15 Yazoo Mississippi 28163 8042 107
2406636 2406636 2022-04-14 Yazoo Mississippi 28163 8042 107
2403380 2403380 2022-04-13 Yazoo Mississippi 28163 8042 107
2400125 2400125 2022-04-12 Yazoo Mississippi 28163 8042 107
2396870 2396870 2022-04-11 Yazoo Mississippi 28163 8041 107
2393615 2393615 2022-04-10 Yazoo Mississippi 28163 8041 107
2390359 2390359 2022-04-09 Yazoo Mississippi 28163 8041 107
2387103 2387103 2022-04-08 Yazoo Mississippi 28163 8041 107
2383848 2383848 2022-04-07 Yazoo Mississippi 28163 8041 107
2380593 2380593 2022-04-06 Yazoo Mississippi 28163 8041 107
2377338 2377338 2022-04-05 Yazoo Mississippi 28163 8041 107
2374085 2374085 2022-04-04 Yazoo Mississippi 28163 8041 107
2370833 2370833 2022-04-03 Yazoo Mississippi 28163 8022 106
2367580 2367580 2022-04-02 Yazoo Mississippi 28163 8022 106
2364327 2364327 2022-04-01 Yazoo Mississippi 28163 8022 106
2361073 2361073 2022-03-31 Yazoo Mississippi 28163 8022 106
2357819 2357819 2022-03-30 Yazoo Mississippi 28163 8022 106
2354566 2354566 2022-03-29 Yazoo Mississippi 28163 8022 106
2351313 2351313 2022-03-28 Yazoo Mississippi 28163 8022 106
2348061 2348061 2022-03-27 Yazoo Mississippi 28163 8019 106
2344808 2344808 2022-03-26 Yazoo Mississippi 28163 8019 106
2341555 2341555 2022-03-25 Yazoo Mississippi 28163 8019 106
2338302 2338302 2022-03-24 Yazoo Mississippi 28163 8019 106
2335048 2335048 2022-03-23 Yazoo Mississippi 28163 8019 106
2331794 2331794 2022-03-22 Yazoo Mississippi 28163 8019 106
2328541 2328541 2022-03-21 Yazoo Mississippi 28163 8019 106
2325289 2325289 2022-03-20 Yazoo Mississippi 28163 8010 104
2322035 2322035 2022-03-19 Yazoo Mississippi 28163 8010 104
2318781 2318781 2022-03-18 Yazoo Mississippi 28163 8010 104
2315528 2315528 2022-03-17 Yazoo Mississippi 28163 8010 104
2312275 2312275 2022-03-16 Yazoo Mississippi 28163 8010 104
2309022 2309022 2022-03-15 Yazoo Mississippi 28163 8010 104
2305770 2305770 2022-03-14 Yazoo Mississippi 28163 8010 104
2302519 2302519 2022-03-13 Yazoo Mississippi 28163 8006 103
2299267 2299267 2022-03-12 Yazoo Mississippi 28163 8006 103
2296015 2296015 2022-03-11 Yazoo Mississippi 28163 8006 103
2292763 2292763 2022-03-10 Yazoo Mississippi 28163 8006 103
2289511 2289511 2022-03-09 Yazoo Mississippi 28163 8006 103
2286259 2286259 2022-03-08 Yazoo Mississippi 28163 8006 103
2283007 2283007 2022-03-07 Yazoo Mississippi 28163 8006 103
2279754 2279754 2022-03-06 Yazoo Mississippi 28163 8000 103
2276501 2276501 2022-03-05 Yazoo Mississippi 28163 8000 103
2273248 2273248 2022-03-04 Yazoo Mississippi 28163 8000 103
2269996 2269996 2022-03-03 Yazoo Mississippi 28163 7999 103
2266743 2266743 2022-03-02 Yazoo Mississippi 28163 7998 103
2263492 2263492 2022-03-01 Yazoo Mississippi 28163 7995 103
2260241 2260241 2022-02-28 Yazoo Mississippi 28163 7995 103
2256990 2256990 2022-02-27 Yazoo Mississippi 28163 7988 103
2253739 2253739 2022-02-26 Yazoo Mississippi 28163 7988 103
2250488 2250488 2022-02-25 Yazoo Mississippi 28163 7988 103
2247237 2247237 2022-02-24 Yazoo Mississippi 28163 7988 102
2243986 2243986 2022-02-23 Yazoo Mississippi 28163 7983 102
2240735 2240735 2022-02-22 Yazoo Mississippi 28163 7979 102
2237484 2237484 2022-02-21 Yazoo Mississippi 28163 7973 102
2234233 2234233 2022-02-20 Yazoo Mississippi 28163 7973 102
2230982 2230982 2022-02-19 Yazoo Mississippi 28163 7973 102
2227731 2227731 2022-02-18 Yazoo Mississippi 28163 7973 102
2224480 2224480 2022-02-17 Yazoo Mississippi 28163 7957 102
2221229 2221229 2022-02-16 Yazoo Mississippi 28163 7957 102
2217978 2217978 2022-02-15 Yazoo Mississippi 28163 7951 100
2214727 2214727 2022-02-14 Yazoo Mississippi 28163 7945 99
2211475 2211475 2022-02-13 Yazoo Mississippi 28163 7918 99
2208222 2208222 2022-02-12 Yazoo Mississippi 28163 7918 99
2204969 2204969 2022-02-11 Yazoo Mississippi 28163 7918 99
2201716 2201716 2022-02-10 Yazoo Mississippi 28163 7887 99
2198462 2198462 2022-02-09 Yazoo Mississippi 28163 7880 99
2195208 2195208 2022-02-08 Yazoo Mississippi 28163 7867 98
2191954 2191954 2022-02-07 Yazoo Mississippi 28163 7859 98
2188701 2188701 2022-02-06 Yazoo Mississippi 28163 7800 97
2185448 2185448 2022-02-05 Yazoo Mississippi 28163 7800 97
2182196 2182196 2022-02-04 Yazoo Mississippi 28163 7800 97
2178944 2178944 2022-02-03 Yazoo Mississippi 28163 7727 97

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