ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 53065 and state = "Washington" 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 |
---|---|---|---|---|---|---|---|
2502675 | 2502675 | 2022-05-13 | Stevens | Washington | 53065 | 8277 | 147 |
2499417 | 2499417 | 2022-05-12 | Stevens | Washington | 53065 | 8269 | 147 |
2496159 | 2496159 | 2022-05-11 | Stevens | Washington | 53065 | 8269 | 147 |
2492901 | 2492901 | 2022-05-10 | Stevens | Washington | 53065 | 8248 | 146 |
2489643 | 2489643 | 2022-05-09 | Stevens | Washington | 53065 | 8248 | 146 |
2486386 | 2486386 | 2022-05-08 | Stevens | Washington | 53065 | 8213 | 146 |
2483128 | 2483128 | 2022-05-07 | Stevens | Washington | 53065 | 8213 | 146 |
2479870 | 2479870 | 2022-05-06 | Stevens | Washington | 53065 | 8213 | 146 |
2476612 | 2476612 | 2022-05-05 | Stevens | Washington | 53065 | 8213 | 146 |
2473354 | 2473354 | 2022-05-04 | Stevens | Washington | 53065 | 8213 | 146 |
2470098 | 2470098 | 2022-05-03 | Stevens | Washington | 53065 | 8206 | 146 |
2466842 | 2466842 | 2022-05-02 | Stevens | Washington | 53065 | 8206 | 146 |
2463587 | 2463587 | 2022-05-01 | Stevens | Washington | 53065 | 8188 | 146 |
2460331 | 2460331 | 2022-04-30 | Stevens | Washington | 53065 | 8188 | 146 |
2457075 | 2457075 | 2022-04-29 | Stevens | Washington | 53065 | 8188 | 146 |
2453819 | 2453819 | 2022-04-28 | Stevens | Washington | 53065 | 8175 | 146 |
2450563 | 2450563 | 2022-04-27 | Stevens | Washington | 53065 | 8175 | 146 |
2447307 | 2447307 | 2022-04-26 | Stevens | Washington | 53065 | 8167 | 146 |
2444051 | 2444051 | 2022-04-25 | Stevens | Washington | 53065 | 8167 | 146 |
2440795 | 2440795 | 2022-04-24 | Stevens | Washington | 53065 | 8155 | 146 |
2437539 | 2437539 | 2022-04-23 | Stevens | Washington | 53065 | 8155 | 146 |
2434283 | 2434283 | 2022-04-22 | Stevens | Washington | 53065 | 8155 | 146 |
2431027 | 2431027 | 2022-04-21 | Stevens | Washington | 53065 | 8141 | 145 |
2427771 | 2427771 | 2022-04-20 | Stevens | Washington | 53065 | 8141 | 145 |
2424515 | 2424515 | 2022-04-19 | Stevens | Washington | 53065 | 8131 | 144 |
2421259 | 2421259 | 2022-04-18 | Stevens | Washington | 53065 | 8131 | 144 |
2418003 | 2418003 | 2022-04-17 | Stevens | Washington | 53065 | 8122 | 144 |
2414747 | 2414747 | 2022-04-16 | Stevens | Washington | 53065 | 8122 | 144 |
2411491 | 2411491 | 2022-04-15 | Stevens | Washington | 53065 | 8122 | 144 |
2408235 | 2408235 | 2022-04-14 | Stevens | Washington | 53065 | 8118 | 144 |
2404979 | 2404979 | 2022-04-13 | Stevens | Washington | 53065 | 8118 | 144 |
2401724 | 2401724 | 2022-04-12 | Stevens | Washington | 53065 | 8110 | 143 |
2398469 | 2398469 | 2022-04-11 | Stevens | Washington | 53065 | 8110 | 143 |
2395214 | 2395214 | 2022-04-10 | Stevens | Washington | 53065 | 8110 | 143 |
2391958 | 2391958 | 2022-04-09 | Stevens | Washington | 53065 | 8110 | 143 |
2388702 | 2388702 | 2022-04-08 | Stevens | Washington | 53065 | 8110 | 143 |
2385447 | 2385447 | 2022-04-07 | Stevens | Washington | 53065 | 8101 | 143 |
2382192 | 2382192 | 2022-04-06 | Stevens | Washington | 53065 | 8101 | 143 |
2378937 | 2378937 | 2022-04-05 | Stevens | Washington | 53065 | 8097 | 142 |
2375683 | 2375683 | 2022-04-04 | Stevens | Washington | 53065 | 8097 | 142 |
2372431 | 2372431 | 2022-04-03 | Stevens | Washington | 53065 | 8091 | 142 |
2369178 | 2369178 | 2022-04-02 | Stevens | Washington | 53065 | 8091 | 142 |
2365925 | 2365925 | 2022-04-01 | Stevens | Washington | 53065 | 8091 | 142 |
2362672 | 2362672 | 2022-03-31 | Stevens | Washington | 53065 | 8089 | 142 |
2359418 | 2359418 | 2022-03-30 | Stevens | Washington | 53065 | 8089 | 142 |
2356164 | 2356164 | 2022-03-29 | Stevens | Washington | 53065 | 8082 | 141 |
2352911 | 2352911 | 2022-03-28 | Stevens | Washington | 53065 | 8082 | 141 |
2349659 | 2349659 | 2022-03-27 | Stevens | Washington | 53065 | 8062 | 140 |
2346406 | 2346406 | 2022-03-26 | Stevens | Washington | 53065 | 8062 | 140 |
2343153 | 2343153 | 2022-03-25 | Stevens | Washington | 53065 | 8062 | 140 |
2339900 | 2339900 | 2022-03-24 | Stevens | Washington | 53065 | 8046 | 140 |
2336647 | 2336647 | 2022-03-23 | Stevens | Washington | 53065 | 8046 | 140 |
2333393 | 2333393 | 2022-03-22 | Stevens | Washington | 53065 | 8032 | 140 |
2330139 | 2330139 | 2022-03-21 | Stevens | Washington | 53065 | 8032 | 140 |
2326887 | 2326887 | 2022-03-20 | Stevens | Washington | 53065 | 8018 | 140 |
2323634 | 2323634 | 2022-03-19 | Stevens | Washington | 53065 | 8018 | 140 |
2320380 | 2320380 | 2022-03-18 | Stevens | Washington | 53065 | 8018 | 140 |
2317126 | 2317126 | 2022-03-17 | Stevens | Washington | 53065 | 8011 | 140 |
2313873 | 2313873 | 2022-03-16 | Stevens | Washington | 53065 | 8011 | 140 |
2310620 | 2310620 | 2022-03-15 | Stevens | Washington | 53065 | 7991 | 140 |
2307367 | 2307367 | 2022-03-14 | Stevens | Washington | 53065 | 7991 | 140 |
2304116 | 2304116 | 2022-03-13 | Stevens | Washington | 53065 | 7975 | 141 |
2300864 | 2300864 | 2022-03-12 | Stevens | Washington | 53065 | 7975 | 141 |
2297612 | 2297612 | 2022-03-11 | Stevens | Washington | 53065 | 7975 | 141 |
2294360 | 2294360 | 2022-03-10 | Stevens | Washington | 53065 | 7958 | 139 |
2291108 | 2291108 | 2022-03-09 | Stevens | Washington | 53065 | 7958 | 139 |
2287856 | 2287856 | 2022-03-08 | Stevens | Washington | 53065 | 7943 | 140 |
2284604 | 2284604 | 2022-03-07 | Stevens | Washington | 53065 | 7943 | 140 |
2281352 | 2281352 | 2022-03-06 | Stevens | Washington | 53065 | 7925 | 139 |
2278099 | 2278099 | 2022-03-05 | Stevens | Washington | 53065 | 7925 | 139 |
2274846 | 2274846 | 2022-03-04 | Stevens | Washington | 53065 | 7925 | 139 |
2271593 | 2271593 | 2022-03-03 | Stevens | Washington | 53065 | 7904 | 138 |
2268341 | 2268341 | 2022-03-02 | Stevens | Washington | 53065 | 7904 | 138 |
2265088 | 2265088 | 2022-03-01 | Stevens | Washington | 53065 | 7890 | 133 |
2261838 | 2261838 | 2022-02-28 | Stevens | Washington | 53065 | 7890 | 133 |
2258587 | 2258587 | 2022-02-27 | Stevens | Washington | 53065 | 7885 | 132 |
2255336 | 2255336 | 2022-02-26 | Stevens | Washington | 53065 | 7885 | 132 |
2252085 | 2252085 | 2022-02-25 | Stevens | Washington | 53065 | 7885 | 132 |
2248834 | 2248834 | 2022-02-24 | Stevens | Washington | 53065 | 7884 | 132 |
2245583 | 2245583 | 2022-02-23 | Stevens | Washington | 53065 | 7884 | 132 |
2242332 | 2242332 | 2022-02-22 | Stevens | Washington | 53065 | 7891 | 129 |
2239081 | 2239081 | 2022-02-21 | Stevens | Washington | 53065 | 7891 | 129 |
2235830 | 2235830 | 2022-02-20 | Stevens | Washington | 53065 | 7891 | 129 |
2232579 | 2232579 | 2022-02-19 | Stevens | Washington | 53065 | 7891 | 129 |
2229328 | 2229328 | 2022-02-18 | Stevens | Washington | 53065 | 7891 | 129 |
2226077 | 2226077 | 2022-02-17 | Stevens | Washington | 53065 | 7888 | 128 |
2222826 | 2222826 | 2022-02-16 | Stevens | Washington | 53065 | 7888 | 128 |
2219575 | 2219575 | 2022-02-15 | Stevens | Washington | 53065 | 7854 | 128 |
2216325 | 2216325 | 2022-02-14 | Stevens | Washington | 53065 | 7854 | 128 |
2213074 | 2213074 | 2022-02-13 | Stevens | Washington | 53065 | 7816 | 127 |
2209821 | 2209821 | 2022-02-12 | Stevens | Washington | 53065 | 7816 | 127 |
2206568 | 2206568 | 2022-02-11 | Stevens | Washington | 53065 | 7816 | 127 |
2203315 | 2203315 | 2022-02-10 | Stevens | Washington | 53065 | 7686 | 125 |
2200061 | 2200061 | 2022-02-09 | Stevens | Washington | 53065 | 7686 | 125 |
2196807 | 2196807 | 2022-02-08 | Stevens | Washington | 53065 | 7633 | 121 |
2193552 | 2193552 | 2022-02-07 | Stevens | Washington | 53065 | 7633 | 121 |
2190299 | 2190299 | 2022-02-06 | Stevens | Washington | 53065 | 7588 | 121 |
2187046 | 2187046 | 2022-02-05 | Stevens | Washington | 53065 | 7588 | 121 |
2183793 | 2183793 | 2022-02-04 | Stevens | Washington | 53065 | 7588 | 121 |
2180541 | 2180541 | 2022-02-03 | Stevens | Washington | 53065 | 7498 | 120 |
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);