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 = 28159 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 · 786 ✖

fips 1

  • 28159 · 786 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2501073 2501073 2022-05-13 Winston Mississippi 28159 5231 104
2497815 2497815 2022-05-12 Winston Mississippi 28159 5231 104
2494557 2494557 2022-05-11 Winston Mississippi 28159 5231 104
2491299 2491299 2022-05-10 Winston Mississippi 28159 5231 104
2488041 2488041 2022-05-09 Winston Mississippi 28159 5231 104
2484784 2484784 2022-05-08 Winston Mississippi 28159 5226 104
2481526 2481526 2022-05-07 Winston Mississippi 28159 5226 104
2478268 2478268 2022-05-06 Winston Mississippi 28159 5226 104
2475010 2475010 2022-05-05 Winston Mississippi 28159 5226 104
2471753 2471753 2022-05-04 Winston Mississippi 28159 5226 104
2468497 2468497 2022-05-03 Winston Mississippi 28159 5226 104
2465241 2465241 2022-05-02 Winston Mississippi 28159 5226 104
2461986 2461986 2022-05-01 Winston Mississippi 28159 5224 104
2458730 2458730 2022-04-30 Winston Mississippi 28159 5224 104
2455474 2455474 2022-04-29 Winston Mississippi 28159 5224 104
2452218 2452218 2022-04-28 Winston Mississippi 28159 5224 104
2448962 2448962 2022-04-27 Winston Mississippi 28159 5224 104
2445705 2445705 2022-04-26 Winston Mississippi 28159 5224 104
2442450 2442450 2022-04-25 Winston Mississippi 28159 5221 104
2439194 2439194 2022-04-24 Winston Mississippi 28159 5221 104
2435938 2435938 2022-04-23 Winston Mississippi 28159 5221 104
2432682 2432682 2022-04-22 Winston Mississippi 28159 5221 104
2429426 2429426 2022-04-21 Winston Mississippi 28159 5221 104
2426170 2426170 2022-04-20 Winston Mississippi 28159 5221 104
2422914 2422914 2022-04-19 Winston Mississippi 28159 5221 104
2419657 2419657 2022-04-18 Winston Mississippi 28159 5221 104
2416402 2416402 2022-04-17 Winston Mississippi 28159 5220 104
2413146 2413146 2022-04-16 Winston Mississippi 28159 5220 104
2409890 2409890 2022-04-15 Winston Mississippi 28159 5220 104
2406634 2406634 2022-04-14 Winston Mississippi 28159 5220 104
2403378 2403378 2022-04-13 Winston Mississippi 28159 5220 104
2400123 2400123 2022-04-12 Winston Mississippi 28159 5220 104
2396868 2396868 2022-04-11 Winston Mississippi 28159 5215 104
2393613 2393613 2022-04-10 Winston Mississippi 28159 5215 104
2390357 2390357 2022-04-09 Winston Mississippi 28159 5215 104
2387101 2387101 2022-04-08 Winston Mississippi 28159 5215 104
2383846 2383846 2022-04-07 Winston Mississippi 28159 5215 104
2380591 2380591 2022-04-06 Winston Mississippi 28159 5215 104
2377336 2377336 2022-04-05 Winston Mississippi 28159 5215 104
2374083 2374083 2022-04-04 Winston Mississippi 28159 5215 104
2370831 2370831 2022-04-03 Winston Mississippi 28159 5208 104
2367578 2367578 2022-04-02 Winston Mississippi 28159 5208 104
2364325 2364325 2022-04-01 Winston Mississippi 28159 5208 104
2361071 2361071 2022-03-31 Winston Mississippi 28159 5208 104
2357817 2357817 2022-03-30 Winston Mississippi 28159 5208 104
2354564 2354564 2022-03-29 Winston Mississippi 28159 5208 104
2351311 2351311 2022-03-28 Winston Mississippi 28159 5208 104
2348059 2348059 2022-03-27 Winston Mississippi 28159 5207 104
2344806 2344806 2022-03-26 Winston Mississippi 28159 5207 104
2341553 2341553 2022-03-25 Winston Mississippi 28159 5207 104
2338300 2338300 2022-03-24 Winston Mississippi 28159 5207 104
2335046 2335046 2022-03-23 Winston Mississippi 28159 5207 104
2331792 2331792 2022-03-22 Winston Mississippi 28159 5207 104
2328539 2328539 2022-03-21 Winston Mississippi 28159 5207 104
2325287 2325287 2022-03-20 Winston Mississippi 28159 5200 103
2322033 2322033 2022-03-19 Winston Mississippi 28159 5200 103
2318779 2318779 2022-03-18 Winston Mississippi 28159 5200 103
2315526 2315526 2022-03-17 Winston Mississippi 28159 5200 103
2312273 2312273 2022-03-16 Winston Mississippi 28159 5200 103
2309020 2309020 2022-03-15 Winston Mississippi 28159 5200 103
2305768 2305768 2022-03-14 Winston Mississippi 28159 5200 103
2302517 2302517 2022-03-13 Winston Mississippi 28159 5199 103
2299265 2299265 2022-03-12 Winston Mississippi 28159 5199 103
2296013 2296013 2022-03-11 Winston Mississippi 28159 5199 103
2292761 2292761 2022-03-10 Winston Mississippi 28159 5199 103
2289509 2289509 2022-03-09 Winston Mississippi 28159 5199 103
2286257 2286257 2022-03-08 Winston Mississippi 28159 5199 103
2283005 2283005 2022-03-07 Winston Mississippi 28159 5199 103
2279752 2279752 2022-03-06 Winston Mississippi 28159 5197 103
2276499 2276499 2022-03-05 Winston Mississippi 28159 5197 103
2273246 2273246 2022-03-04 Winston Mississippi 28159 5197 103
2269994 2269994 2022-03-03 Winston Mississippi 28159 5197 103
2266741 2266741 2022-03-02 Winston Mississippi 28159 5189 103
2263490 2263490 2022-03-01 Winston Mississippi 28159 5185 103
2260239 2260239 2022-02-28 Winston Mississippi 28159 5181 102
2256988 2256988 2022-02-27 Winston Mississippi 28159 5176 102
2253737 2253737 2022-02-26 Winston Mississippi 28159 5176 102
2250486 2250486 2022-02-25 Winston Mississippi 28159 5176 102
2247235 2247235 2022-02-24 Winston Mississippi 28159 5172 102
2243984 2243984 2022-02-23 Winston Mississippi 28159 5168 102
2240733 2240733 2022-02-22 Winston Mississippi 28159 5164 102
2237482 2237482 2022-02-21 Winston Mississippi 28159 5143 100
2234231 2234231 2022-02-20 Winston Mississippi 28159 5143 100
2230980 2230980 2022-02-19 Winston Mississippi 28159 5143 100
2227729 2227729 2022-02-18 Winston Mississippi 28159 5143 100
2224478 2224478 2022-02-17 Winston Mississippi 28159 5131 100
2221227 2221227 2022-02-16 Winston Mississippi 28159 5118 100
2217976 2217976 2022-02-15 Winston Mississippi 28159 5101 100
2214725 2214725 2022-02-14 Winston Mississippi 28159 5090 100
2211473 2211473 2022-02-13 Winston Mississippi 28159 5026 99
2208220 2208220 2022-02-12 Winston Mississippi 28159 5026 99
2204967 2204967 2022-02-11 Winston Mississippi 28159 5026 99
2201714 2201714 2022-02-10 Winston Mississippi 28159 5011 98
2198460 2198460 2022-02-09 Winston Mississippi 28159 4993 98
2195206 2195206 2022-02-08 Winston Mississippi 28159 4955 98
2191952 2191952 2022-02-07 Winston Mississippi 28159 4935 98
2188699 2188699 2022-02-06 Winston Mississippi 28159 4841 98
2185446 2185446 2022-02-05 Winston Mississippi 28159 4841 98
2182194 2182194 2022-02-04 Winston Mississippi 28159 4841 98
2178942 2178942 2022-02-03 Winston Mississippi 28159 4827 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);