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

781 rows where county = "Newton" and fips = 28101 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

  • 28101 · 781 ✖

county 1

  • Newton · 781 ✖
Link rowid date ▲ county state fips cases deaths
2501043 2501043 2022-05-13 Newton Mississippi 28101 6059 98
2497785 2497785 2022-05-12 Newton Mississippi 28101 6059 98
2494527 2494527 2022-05-11 Newton Mississippi 28101 6059 98
2491269 2491269 2022-05-10 Newton Mississippi 28101 6059 98
2488012 2488012 2022-05-09 Newton Mississippi 28101 6059 98
2484754 2484754 2022-05-08 Newton Mississippi 28101 6037 98
2481496 2481496 2022-05-07 Newton Mississippi 28101 6037 98
2478238 2478238 2022-05-06 Newton Mississippi 28101 6037 98
2474980 2474980 2022-05-05 Newton Mississippi 28101 6037 98
2471723 2471723 2022-05-04 Newton Mississippi 28101 6037 98
2468467 2468467 2022-05-03 Newton Mississippi 28101 6037 98
2465212 2465212 2022-05-02 Newton Mississippi 28101 6037 98
2461956 2461956 2022-05-01 Newton Mississippi 28101 6029 98
2458700 2458700 2022-04-30 Newton Mississippi 28101 6029 98
2455444 2455444 2022-04-29 Newton Mississippi 28101 6029 98
2452188 2452188 2022-04-28 Newton Mississippi 28101 6029 98
2448932 2448932 2022-04-27 Newton Mississippi 28101 6029 98
2445676 2445676 2022-04-26 Newton Mississippi 28101 6029 98
2442420 2442420 2022-04-25 Newton Mississippi 28101 6021 98
2439164 2439164 2022-04-24 Newton Mississippi 28101 6021 98
2435908 2435908 2022-04-23 Newton Mississippi 28101 6021 98
2432652 2432652 2022-04-22 Newton Mississippi 28101 6021 98
2429396 2429396 2022-04-21 Newton Mississippi 28101 6021 98
2426140 2426140 2022-04-20 Newton Mississippi 28101 6021 98
2422884 2422884 2022-04-19 Newton Mississippi 28101 6021 98
2419628 2419628 2022-04-18 Newton Mississippi 28101 6021 98
2416372 2416372 2022-04-17 Newton Mississippi 28101 6019 98
2413116 2413116 2022-04-16 Newton Mississippi 28101 6019 98
2409860 2409860 2022-04-15 Newton Mississippi 28101 6019 98
2406604 2406604 2022-04-14 Newton Mississippi 28101 6019 98
2403348 2403348 2022-04-13 Newton Mississippi 28101 6019 98
2400094 2400094 2022-04-12 Newton Mississippi 28101 6019 98
2396838 2396838 2022-04-11 Newton Mississippi 28101 6007 98
2393583 2393583 2022-04-10 Newton Mississippi 28101 6007 98
2390327 2390327 2022-04-09 Newton Mississippi 28101 6007 98
2387071 2387071 2022-04-08 Newton Mississippi 28101 6007 98
2383816 2383816 2022-04-07 Newton Mississippi 28101 6007 98
2380561 2380561 2022-04-06 Newton Mississippi 28101 6007 98
2377306 2377306 2022-04-05 Newton Mississippi 28101 6007 98
2374054 2374054 2022-04-04 Newton Mississippi 28101 6007 98
2370801 2370801 2022-04-03 Newton Mississippi 28101 5997 98
2367548 2367548 2022-04-02 Newton Mississippi 28101 5997 98
2364295 2364295 2022-04-01 Newton Mississippi 28101 5997 98
2361041 2361041 2022-03-31 Newton Mississippi 28101 5997 98
2357787 2357787 2022-03-30 Newton Mississippi 28101 5997 98
2354534 2354534 2022-03-29 Newton Mississippi 28101 5997 98
2351282 2351282 2022-03-28 Newton Mississippi 28101 5997 98
2348029 2348029 2022-03-27 Newton Mississippi 28101 5996 97
2344776 2344776 2022-03-26 Newton Mississippi 28101 5996 97
2341523 2341523 2022-03-25 Newton Mississippi 28101 5996 97
2338270 2338270 2022-03-24 Newton Mississippi 28101 5996 97
2335016 2335016 2022-03-23 Newton Mississippi 28101 5996 97
2331762 2331762 2022-03-22 Newton Mississippi 28101 5996 97
2328510 2328510 2022-03-21 Newton Mississippi 28101 5996 97
2325257 2325257 2022-03-20 Newton Mississippi 28101 5996 97
2322003 2322003 2022-03-19 Newton Mississippi 28101 5996 97
2318749 2318749 2022-03-18 Newton Mississippi 28101 5996 97
2315496 2315496 2022-03-17 Newton Mississippi 28101 5996 97
2312243 2312243 2022-03-16 Newton Mississippi 28101 5996 97
2308990 2308990 2022-03-15 Newton Mississippi 28101 5996 97
2305739 2305739 2022-03-14 Newton Mississippi 28101 5996 97
2302487 2302487 2022-03-13 Newton Mississippi 28101 5989 97
2299235 2299235 2022-03-12 Newton Mississippi 28101 5989 97
2295983 2295983 2022-03-11 Newton Mississippi 28101 5989 97
2292731 2292731 2022-03-10 Newton Mississippi 28101 5989 97
2289479 2289479 2022-03-09 Newton Mississippi 28101 5989 97
2286228 2286228 2022-03-08 Newton Mississippi 28101 5989 97
2282976 2282976 2022-03-07 Newton Mississippi 28101 5986 97
2279723 2279723 2022-03-06 Newton Mississippi 28101 5979 96
2276470 2276470 2022-03-05 Newton Mississippi 28101 5979 96
2273217 2273217 2022-03-04 Newton Mississippi 28101 5979 96
2269965 2269965 2022-03-03 Newton Mississippi 28101 5978 96
2266712 2266712 2022-03-02 Newton Mississippi 28101 5973 96
2263461 2263461 2022-03-01 Newton Mississippi 28101 5960 96
2260210 2260210 2022-02-28 Newton Mississippi 28101 5958 96
2256959 2256959 2022-02-27 Newton Mississippi 28101 5942 96
2253708 2253708 2022-02-26 Newton Mississippi 28101 5942 96
2250457 2250457 2022-02-25 Newton Mississippi 28101 5942 96
2247206 2247206 2022-02-24 Newton Mississippi 28101 5938 96
2243955 2243955 2022-02-23 Newton Mississippi 28101 5933 95
2240704 2240704 2022-02-22 Newton Mississippi 28101 5928 94
2237453 2237453 2022-02-21 Newton Mississippi 28101 5913 94
2234202 2234202 2022-02-20 Newton Mississippi 28101 5913 94
2230951 2230951 2022-02-19 Newton Mississippi 28101 5913 94
2227700 2227700 2022-02-18 Newton Mississippi 28101 5913 94
2224449 2224449 2022-02-17 Newton Mississippi 28101 5898 93
2221198 2221198 2022-02-16 Newton Mississippi 28101 5890 93
2217947 2217947 2022-02-15 Newton Mississippi 28101 5878 92
2214696 2214696 2022-02-14 Newton Mississippi 28101 5870 92
2211444 2211444 2022-02-13 Newton Mississippi 28101 5804 92
2208191 2208191 2022-02-12 Newton Mississippi 28101 5804 92
2204938 2204938 2022-02-11 Newton Mississippi 28101 5804 92
2201685 2201685 2022-02-10 Newton Mississippi 28101 5791 92
2198431 2198431 2022-02-09 Newton Mississippi 28101 5772 92
2195177 2195177 2022-02-08 Newton Mississippi 28101 5747 92
2191923 2191923 2022-02-07 Newton Mississippi 28101 5738 92
2188670 2188670 2022-02-06 Newton Mississippi 28101 5677 92
2185417 2185417 2022-02-05 Newton Mississippi 28101 5677 92
2182165 2182165 2022-02-04 Newton Mississippi 28101 5677 92
2178913 2178913 2022-02-03 Newton Mississippi 28101 5619 91

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