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

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

  • 48351 · 773 ✖

county 1

  • Newton · 773 ✖
Link rowid date ▲ county state fips cases deaths
2502382 2502382 2022-05-13 Newton Texas 48351 1367 61
2499124 2499124 2022-05-12 Newton Texas 48351 1367 61
2495866 2495866 2022-05-11 Newton Texas 48351 1367 61
2492608 2492608 2022-05-10 Newton Texas 48351 1366 61
2489350 2489350 2022-05-09 Newton Texas 48351 1366 61
2486093 2486093 2022-05-08 Newton Texas 48351 1366 61
2482835 2482835 2022-05-07 Newton Texas 48351 1366 61
2479577 2479577 2022-05-06 Newton Texas 48351 1366 61
2476319 2476319 2022-05-05 Newton Texas 48351 1366 61
2473062 2473062 2022-05-04 Newton Texas 48351 1366 61
2469806 2469806 2022-05-03 Newton Texas 48351 1366 61
2466550 2466550 2022-05-02 Newton Texas 48351 1366 61
2463295 2463295 2022-05-01 Newton Texas 48351 1366 61
2460039 2460039 2022-04-30 Newton Texas 48351 1366 61
2456783 2456783 2022-04-29 Newton Texas 48351 1366 61
2453527 2453527 2022-04-28 Newton Texas 48351 1366 61
2450271 2450271 2022-04-27 Newton Texas 48351 1365 61
2447014 2447014 2022-04-26 Newton Texas 48351 1365 61
2443759 2443759 2022-04-25 Newton Texas 48351 1365 61
2440503 2440503 2022-04-24 Newton Texas 48351 1365 61
2437247 2437247 2022-04-23 Newton Texas 48351 1365 61
2433991 2433991 2022-04-22 Newton Texas 48351 1365 61
2430735 2430735 2022-04-21 Newton Texas 48351 1365 61
2427479 2427479 2022-04-20 Newton Texas 48351 1365 61
2424223 2424223 2022-04-19 Newton Texas 48351 1365 61
2420967 2420967 2022-04-18 Newton Texas 48351 1365 61
2417711 2417711 2022-04-17 Newton Texas 48351 1365 61
2414455 2414455 2022-04-16 Newton Texas 48351 1365 61
2411199 2411199 2022-04-15 Newton Texas 48351 1365 61
2407943 2407943 2022-04-14 Newton Texas 48351 1365 61
2404687 2404687 2022-04-13 Newton Texas 48351 1365 61
2401432 2401432 2022-04-12 Newton Texas 48351 1365 61
2398177 2398177 2022-04-11 Newton Texas 48351 1365 61
2394922 2394922 2022-04-10 Newton Texas 48351 1365 61
2391666 2391666 2022-04-09 Newton Texas 48351 1365 61
2388410 2388410 2022-04-08 Newton Texas 48351 1365 61
2385155 2385155 2022-04-07 Newton Texas 48351 1365 61
2381900 2381900 2022-04-06 Newton Texas 48351 1365 61
2378645 2378645 2022-04-05 Newton Texas 48351 1365 61
2375391 2375391 2022-04-04 Newton Texas 48351 1365 61
2372139 2372139 2022-04-03 Newton Texas 48351 1365 61
2368886 2368886 2022-04-02 Newton Texas 48351 1365 61
2365633 2365633 2022-04-01 Newton Texas 48351 1365 61
2362380 2362380 2022-03-31 Newton Texas 48351 1365 61
2359126 2359126 2022-03-30 Newton Texas 48351 1365 61
2355872 2355872 2022-03-29 Newton Texas 48351 1365 61
2352619 2352619 2022-03-28 Newton Texas 48351 1365 61
2349367 2349367 2022-03-27 Newton Texas 48351 1365 61
2346114 2346114 2022-03-26 Newton Texas 48351 1365 61
2342861 2342861 2022-03-25 Newton Texas 48351 1364 61
2339608 2339608 2022-03-24 Newton Texas 48351 1363 60
2336354 2336354 2022-03-23 Newton Texas 48351 1363 60
2333100 2333100 2022-03-22 Newton Texas 48351 1363 60
2329847 2329847 2022-03-21 Newton Texas 48351 1362 60
2326595 2326595 2022-03-20 Newton Texas 48351 1362 60
2323342 2323342 2022-03-19 Newton Texas 48351 1362 60
2320088 2320088 2022-03-18 Newton Texas 48351 1362 60
2316834 2316834 2022-03-17 Newton Texas 48351 1361 60
2313581 2313581 2022-03-16 Newton Texas 48351 1361 59
2310328 2310328 2022-03-15 Newton Texas 48351 1361 59
2307075 2307075 2022-03-14 Newton Texas 48351 1361 59
2303824 2303824 2022-03-13 Newton Texas 48351 1361 59
2300572 2300572 2022-03-12 Newton Texas 48351 1359 59
2297320 2297320 2022-03-11 Newton Texas 48351 1359 59
2294068 2294068 2022-03-10 Newton Texas 48351 1359 59
2290816 2290816 2022-03-09 Newton Texas 48351 1359 59
2287564 2287564 2022-03-08 Newton Texas 48351 1358 59
2284312 2284312 2022-03-07 Newton Texas 48351 1357 59
2281060 2281060 2022-03-06 Newton Texas 48351 1357 59
2277807 2277807 2022-03-05 Newton Texas 48351 1357 59
2274554 2274554 2022-03-04 Newton Texas 48351 1357 59
2271301 2271301 2022-03-03 Newton Texas 48351 1357 59
2268049 2268049 2022-03-02 Newton Texas 48351 1356 59
2264796 2264796 2022-03-01 Newton Texas 48351 1355 59
2261546 2261546 2022-02-28 Newton Texas 48351 1353 59
2258295 2258295 2022-02-27 Newton Texas 48351 1353 59
2255044 2255044 2022-02-26 Newton Texas 48351 1353 59
2251793 2251793 2022-02-25 Newton Texas 48351 1352 59
2248542 2248542 2022-02-24 Newton Texas 48351 1341 57
2245291 2245291 2022-02-23 Newton Texas 48351 1341 57
2242040 2242040 2022-02-22 Newton Texas 48351 1341 57
2238789 2238789 2022-02-21 Newton Texas 48351 1341 57
2235538 2235538 2022-02-20 Newton Texas 48351 1341 57
2232287 2232287 2022-02-19 Newton Texas 48351 1341 57
2229036 2229036 2022-02-18 Newton Texas 48351 1341 57
2225785 2225785 2022-02-17 Newton Texas 48351 1335 57
2222534 2222534 2022-02-16 Newton Texas 48351 1333 57
2219283 2219283 2022-02-15 Newton Texas 48351 1330 57
2216032 2216032 2022-02-14 Newton Texas 48351 1329 57
2212781 2212781 2022-02-13 Newton Texas 48351 1328 57
2209528 2209528 2022-02-12 Newton Texas 48351 1325 57
2206275 2206275 2022-02-11 Newton Texas 48351 1323 57
2203022 2203022 2022-02-10 Newton Texas 48351 1321 57
2199768 2199768 2022-02-09 Newton Texas 48351 1314 57
2196514 2196514 2022-02-08 Newton Texas 48351 1310 56
2193260 2193260 2022-02-07 Newton Texas 48351 1305 56
2190006 2190006 2022-02-06 Newton Texas 48351 1299 56
2186753 2186753 2022-02-05 Newton Texas 48351 1290 56
2183501 2183501 2022-02-04 Newton Texas 48351 1288 56
2180249 2180249 2022-02-03 Newton Texas 48351 1281 56

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