home / covid

Menu
  • GraphQL API

ny_times_us_counties

Table actions
  • GraphQL API for ny_times_us_counties
⚠️ 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

810 rows where fips = 53063 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Washington 810

fips 1

  • 53063 · 810 ✖

county 1

  • Spokane 810
Link rowid date ▲ county state fips cases deaths
2502674 2502674 2022-05-13 Spokane Washington 53063 126131 1378
2499416 2499416 2022-05-12 Spokane Washington 53063 125953 1374
2496158 2496158 2022-05-11 Spokane Washington 53063 125953 1374
2492900 2492900 2022-05-10 Spokane Washington 53063 125788 1374
2489642 2489642 2022-05-09 Spokane Washington 53063 125788 1374
2486385 2486385 2022-05-08 Spokane Washington 53063 125416 1371
2483127 2483127 2022-05-07 Spokane Washington 53063 125416 1371
2479869 2479869 2022-05-06 Spokane Washington 53063 125416 1371
2476611 2476611 2022-05-05 Spokane Washington 53063 125416 1371
2473353 2473353 2022-05-04 Spokane Washington 53063 125416 1371
2470097 2470097 2022-05-03 Spokane Washington 53063 125550 1370
2466841 2466841 2022-05-02 Spokane Washington 53063 125550 1370
2463586 2463586 2022-05-01 Spokane Washington 53063 125079 1369
2460330 2460330 2022-04-30 Spokane Washington 53063 125079 1369
2457074 2457074 2022-04-29 Spokane Washington 53063 125079 1369
2453818 2453818 2022-04-28 Spokane Washington 53063 124853 1370
2450562 2450562 2022-04-27 Spokane Washington 53063 124853 1370
2447306 2447306 2022-04-26 Spokane Washington 53063 124732 1370
2444050 2444050 2022-04-25 Spokane Washington 53063 124732 1370
2440794 2440794 2022-04-24 Spokane Washington 53063 124569 1369
2437538 2437538 2022-04-23 Spokane Washington 53063 124569 1369
2434282 2434282 2022-04-22 Spokane Washington 53063 124569 1369
2431026 2431026 2022-04-21 Spokane Washington 53063 124389 1368
2427770 2427770 2022-04-20 Spokane Washington 53063 124389 1368
2424514 2424514 2022-04-19 Spokane Washington 53063 124348 1367
2421258 2421258 2022-04-18 Spokane Washington 53063 124348 1367
2418002 2418002 2022-04-17 Spokane Washington 53063 124264 1365
2414746 2414746 2022-04-16 Spokane Washington 53063 124264 1365
2411490 2411490 2022-04-15 Spokane Washington 53063 124264 1365
2408234 2408234 2022-04-14 Spokane Washington 53063 124132 1363
2404978 2404978 2022-04-13 Spokane Washington 53063 124132 1363
2401723 2401723 2022-04-12 Spokane Washington 53063 123909 1359
2398468 2398468 2022-04-11 Spokane Washington 53063 123909 1359
2395213 2395213 2022-04-10 Spokane Washington 53063 123909 1359
2391957 2391957 2022-04-09 Spokane Washington 53063 123909 1359
2388701 2388701 2022-04-08 Spokane Washington 53063 123909 1359
2385446 2385446 2022-04-07 Spokane Washington 53063 123671 1357
2382191 2382191 2022-04-06 Spokane Washington 53063 123671 1357
2378936 2378936 2022-04-05 Spokane Washington 53063 123514 1358
2375682 2375682 2022-04-04 Spokane Washington 53063 123514 1358
2372430 2372430 2022-04-03 Spokane Washington 53063 123410 1356
2369177 2369177 2022-04-02 Spokane Washington 53063 123410 1356
2365924 2365924 2022-04-01 Spokane Washington 53063 123410 1356
2362671 2362671 2022-03-31 Spokane Washington 53063 123281 1353
2359417 2359417 2022-03-30 Spokane Washington 53063 123281 1353
2356163 2356163 2022-03-29 Spokane Washington 53063 123127 1353
2352910 2352910 2022-03-28 Spokane Washington 53063 123127 1353
2349658 2349658 2022-03-27 Spokane Washington 53063 122987 1352
2346405 2346405 2022-03-26 Spokane Washington 53063 122987 1352
2343152 2343152 2022-03-25 Spokane Washington 53063 122987 1352
2339899 2339899 2022-03-24 Spokane Washington 53063 122781 1349
2336646 2336646 2022-03-23 Spokane Washington 53063 122781 1349
2333392 2333392 2022-03-22 Spokane Washington 53063 122671 1346
2330138 2330138 2022-03-21 Spokane Washington 53063 122671 1346
2326886 2326886 2022-03-20 Spokane Washington 53063 122575 1344
2323633 2323633 2022-03-19 Spokane Washington 53063 122575 1344
2320379 2320379 2022-03-18 Spokane Washington 53063 122575 1344
2317125 2317125 2022-03-17 Spokane Washington 53063 122369 1340
2313872 2313872 2022-03-16 Spokane Washington 53063 122369 1340
2310619 2310619 2022-03-15 Spokane Washington 53063 122201 1335
2307366 2307366 2022-03-14 Spokane Washington 53063 122201 1335
2304115 2304115 2022-03-13 Spokane Washington 53063 121821 1332
2300863 2300863 2022-03-12 Spokane Washington 53063 121821 1332
2297611 2297611 2022-03-11 Spokane Washington 53063 121821 1332
2294359 2294359 2022-03-10 Spokane Washington 53063 121441 1330
2291107 2291107 2022-03-09 Spokane Washington 53063 121441 1330
2287855 2287855 2022-03-08 Spokane Washington 53063 121178 1324
2284603 2284603 2022-03-07 Spokane Washington 53063 121178 1324
2281351 2281351 2022-03-06 Spokane Washington 53063 120984 1320
2278098 2278098 2022-03-05 Spokane Washington 53063 120984 1320
2274845 2274845 2022-03-04 Spokane Washington 53063 120984 1320
2271592 2271592 2022-03-03 Spokane Washington 53063 120580 1309
2268340 2268340 2022-03-02 Spokane Washington 53063 120580 1309
2265087 2265087 2022-03-01 Spokane Washington 53063 120303 1301
2261837 2261837 2022-02-28 Spokane Washington 53063 120303 1301
2258586 2258586 2022-02-27 Spokane Washington 53063 120201 1296
2255335 2255335 2022-02-26 Spokane Washington 53063 120201 1296
2252084 2252084 2022-02-25 Spokane Washington 53063 120201 1296
2248833 2248833 2022-02-24 Spokane Washington 53063 120076 1294
2245582 2245582 2022-02-23 Spokane Washington 53063 120076 1294
2242331 2242331 2022-02-22 Spokane Washington 53063 119960 1285
2239080 2239080 2022-02-21 Spokane Washington 53063 119960 1285
2235829 2235829 2022-02-20 Spokane Washington 53063 119960 1285
2232578 2232578 2022-02-19 Spokane Washington 53063 119960 1285
2229327 2229327 2022-02-18 Spokane Washington 53063 119960 1285
2226076 2226076 2022-02-17 Spokane Washington 53063 120458 1279
2222825 2222825 2022-02-16 Spokane Washington 53063 120458 1279
2219574 2219574 2022-02-15 Spokane Washington 53063 120776 1262
2216324 2216324 2022-02-14 Spokane Washington 53063 120776 1262
2213073 2213073 2022-02-13 Spokane Washington 53063 120580 1258
2209820 2209820 2022-02-12 Spokane Washington 53063 120580 1258
2206567 2206567 2022-02-11 Spokane Washington 53063 120580 1258
2203314 2203314 2022-02-10 Spokane Washington 53063 118688 1246
2200060 2200060 2022-02-09 Spokane Washington 53063 118688 1246
2196806 2196806 2022-02-08 Spokane Washington 53063 118015 1242
2193551 2193551 2022-02-07 Spokane Washington 53063 118015 1242
2190298 2190298 2022-02-06 Spokane Washington 53063 116882 1231
2187045 2187045 2022-02-05 Spokane Washington 53063 116882 1231
2183792 2183792 2022-02-04 Spokane Washington 53063 116882 1231
2180540 2180540 2022-02-03 Spokane Washington 53063 116250 1218

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);
Powered by Datasette · Queries took 44.046ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette