ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
810 rows where fips = 53063 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 |
---|---|---|---|---|---|---|---|
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 |
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);