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

1,564 rows where county = "Winston" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 2

fips 2

county 1

  • Winston · 1,564 ✖
Link rowid date ▲ county state fips cases deaths
2499641 2499641 2022-05-13 Winston Alabama 1133 7576 131
2501073 2501073 2022-05-13 Winston Mississippi 28159 5231 104
2496383 2496383 2022-05-12 Winston Alabama 1133 7575 131
2497815 2497815 2022-05-12 Winston Mississippi 28159 5231 104
2493125 2493125 2022-05-11 Winston Alabama 1133 7574 131
2494557 2494557 2022-05-11 Winston Mississippi 28159 5231 104
2489867 2489867 2022-05-10 Winston Alabama 1133 7572 131
2491299 2491299 2022-05-10 Winston Mississippi 28159 5231 104
2486610 2486610 2022-05-09 Winston Alabama 1133 7572 131
2488041 2488041 2022-05-09 Winston Mississippi 28159 5231 104
2483352 2483352 2022-05-08 Winston Alabama 1133 7569 131
2484784 2484784 2022-05-08 Winston Mississippi 28159 5226 104
2480094 2480094 2022-05-07 Winston Alabama 1133 7569 131
2481526 2481526 2022-05-07 Winston Mississippi 28159 5226 104
2476836 2476836 2022-05-06 Winston Alabama 1133 7569 131
2478268 2478268 2022-05-06 Winston Mississippi 28159 5226 104
2473578 2473578 2022-05-05 Winston Alabama 1133 7569 131
2475010 2475010 2022-05-05 Winston Mississippi 28159 5226 104
2470321 2470321 2022-05-04 Winston Alabama 1133 7569 131
2471753 2471753 2022-05-04 Winston Mississippi 28159 5226 104
2467065 2467065 2022-05-03 Winston Alabama 1133 7569 131
2468497 2468497 2022-05-03 Winston Mississippi 28159 5226 104
2463810 2463810 2022-05-02 Winston Alabama 1133 7568 131
2465241 2465241 2022-05-02 Winston Mississippi 28159 5226 104
2460554 2460554 2022-05-01 Winston Alabama 1133 7567 131
2461986 2461986 2022-05-01 Winston Mississippi 28159 5224 104
2457298 2457298 2022-04-30 Winston Alabama 1133 7567 131
2458730 2458730 2022-04-30 Winston Mississippi 28159 5224 104
2454042 2454042 2022-04-29 Winston Alabama 1133 7567 131
2455474 2455474 2022-04-29 Winston Mississippi 28159 5224 104
2450786 2450786 2022-04-28 Winston Alabama 1133 7566 131
2452218 2452218 2022-04-28 Winston Mississippi 28159 5224 104
2447530 2447530 2022-04-27 Winston Alabama 1133 7565 131
2448962 2448962 2022-04-27 Winston Mississippi 28159 5224 104
2444274 2444274 2022-04-26 Winston Alabama 1133 7565 131
2445705 2445705 2022-04-26 Winston Mississippi 28159 5224 104
2441018 2441018 2022-04-25 Winston Alabama 1133 7565 131
2442450 2442450 2022-04-25 Winston Mississippi 28159 5221 104
2437762 2437762 2022-04-24 Winston Alabama 1133 7566 131
2439194 2439194 2022-04-24 Winston Mississippi 28159 5221 104
2434506 2434506 2022-04-23 Winston Alabama 1133 7566 131
2435938 2435938 2022-04-23 Winston Mississippi 28159 5221 104
2431250 2431250 2022-04-22 Winston Alabama 1133 7566 131
2432682 2432682 2022-04-22 Winston Mississippi 28159 5221 104
2427994 2427994 2022-04-21 Winston Alabama 1133 7566 130
2429426 2429426 2022-04-21 Winston Mississippi 28159 5221 104
2424738 2424738 2022-04-20 Winston Alabama 1133 7566 130
2426170 2426170 2022-04-20 Winston Mississippi 28159 5221 104
2421482 2421482 2022-04-19 Winston Alabama 1133 7569 130
2422914 2422914 2022-04-19 Winston Mississippi 28159 5221 104
2418226 2418226 2022-04-18 Winston Alabama 1133 7563 130
2419657 2419657 2022-04-18 Winston Mississippi 28159 5221 104
2414970 2414970 2022-04-17 Winston Alabama 1133 7563 130
2416402 2416402 2022-04-17 Winston Mississippi 28159 5220 104
2411714 2411714 2022-04-16 Winston Alabama 1133 7563 130
2413146 2413146 2022-04-16 Winston Mississippi 28159 5220 104
2408458 2408458 2022-04-15 Winston Alabama 1133 7563 130
2409890 2409890 2022-04-15 Winston Mississippi 28159 5220 104
2405202 2405202 2022-04-14 Winston Alabama 1133 7563 129
2406634 2406634 2022-04-14 Winston Mississippi 28159 5220 104
2401947 2401947 2022-04-13 Winston Alabama 1133 7565 129
2403378 2403378 2022-04-13 Winston Mississippi 28159 5220 104
2398692 2398692 2022-04-12 Winston Alabama 1133 7565 129
2400123 2400123 2022-04-12 Winston Mississippi 28159 5220 104
2395437 2395437 2022-04-11 Winston Alabama 1133 7566 129
2396868 2396868 2022-04-11 Winston Mississippi 28159 5215 104
2392181 2392181 2022-04-10 Winston Alabama 1133 7566 129
2393613 2393613 2022-04-10 Winston Mississippi 28159 5215 104
2388925 2388925 2022-04-09 Winston Alabama 1133 7566 129
2390357 2390357 2022-04-09 Winston Mississippi 28159 5215 104
2385670 2385670 2022-04-08 Winston Alabama 1133 7566 129
2387101 2387101 2022-04-08 Winston Mississippi 28159 5215 104
2382415 2382415 2022-04-07 Winston Alabama 1133 7568 129
2383846 2383846 2022-04-07 Winston Mississippi 28159 5215 104
2379160 2379160 2022-04-06 Winston Alabama 1133 7572 129
2380591 2380591 2022-04-06 Winston Mississippi 28159 5215 104
2375906 2375906 2022-04-05 Winston Alabama 1133 7572 129
2377336 2377336 2022-04-05 Winston Mississippi 28159 5215 104
2372654 2372654 2022-04-04 Winston Alabama 1133 7573 129
2374083 2374083 2022-04-04 Winston Mississippi 28159 5215 104
2369401 2369401 2022-04-03 Winston Alabama 1133 7572 129
2370831 2370831 2022-04-03 Winston Mississippi 28159 5208 104
2366148 2366148 2022-04-02 Winston Alabama 1133 7572 129
2367578 2367578 2022-04-02 Winston Mississippi 28159 5208 104
2362895 2362895 2022-04-01 Winston Alabama 1133 7572 129
2364325 2364325 2022-04-01 Winston Mississippi 28159 5208 104
2359641 2359641 2022-03-31 Winston Alabama 1133 7570 129
2361071 2361071 2022-03-31 Winston Mississippi 28159 5208 104
2356387 2356387 2022-03-30 Winston Alabama 1133 7570 129
2357817 2357817 2022-03-30 Winston Mississippi 28159 5208 104
2353134 2353134 2022-03-29 Winston Alabama 1133 7570 129
2354564 2354564 2022-03-29 Winston Mississippi 28159 5208 104
2349882 2349882 2022-03-28 Winston Alabama 1133 7568 128
2351311 2351311 2022-03-28 Winston Mississippi 28159 5208 104
2346629 2346629 2022-03-27 Winston Alabama 1133 7569 128
2348059 2348059 2022-03-27 Winston Mississippi 28159 5207 104
2343376 2343376 2022-03-26 Winston Alabama 1133 7569 128
2344806 2344806 2022-03-26 Winston Mississippi 28159 5207 104
2340123 2340123 2022-03-25 Winston Alabama 1133 7569 128
2341553 2341553 2022-03-25 Winston Mississippi 28159 5207 104

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