ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Winston" and fips = 28159 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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 |
Advanced export
JSON shape: default, array, newline-delimited
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);