ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Skagit" 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 |
---|---|---|---|---|---|---|---|
2502671 | 2502671 | 2022-05-13 | Skagit | Washington | 53057 | 22747 | 204 |
2499413 | 2499413 | 2022-05-12 | Skagit | Washington | 53057 | 22693 | 204 |
2496155 | 2496155 | 2022-05-11 | Skagit | Washington | 53057 | 22693 | 204 |
2492897 | 2492897 | 2022-05-10 | Skagit | Washington | 53057 | 22627 | 204 |
2489639 | 2489639 | 2022-05-09 | Skagit | Washington | 53057 | 22627 | 204 |
2486382 | 2486382 | 2022-05-08 | Skagit | Washington | 53057 | 22491 | 204 |
2483124 | 2483124 | 2022-05-07 | Skagit | Washington | 53057 | 22491 | 204 |
2479866 | 2479866 | 2022-05-06 | Skagit | Washington | 53057 | 22491 | 204 |
2476608 | 2476608 | 2022-05-05 | Skagit | Washington | 53057 | 22491 | 204 |
2473350 | 2473350 | 2022-05-04 | Skagit | Washington | 53057 | 22491 | 204 |
2470094 | 2470094 | 2022-05-03 | Skagit | Washington | 53057 | 22723 | 204 |
2466838 | 2466838 | 2022-05-02 | Skagit | Washington | 53057 | 22723 | 204 |
2463583 | 2463583 | 2022-05-01 | Skagit | Washington | 53057 | 22351 | 204 |
2460327 | 2460327 | 2022-04-30 | Skagit | Washington | 53057 | 22351 | 204 |
2457071 | 2457071 | 2022-04-29 | Skagit | Washington | 53057 | 22351 | 204 |
2453815 | 2453815 | 2022-04-28 | Skagit | Washington | 53057 | 22276 | 204 |
2450559 | 2450559 | 2022-04-27 | Skagit | Washington | 53057 | 22276 | 204 |
2447303 | 2447303 | 2022-04-26 | Skagit | Washington | 53057 | 22240 | 204 |
2444047 | 2444047 | 2022-04-25 | Skagit | Washington | 53057 | 22240 | 204 |
2440791 | 2440791 | 2022-04-24 | Skagit | Washington | 53057 | 22199 | 204 |
2437535 | 2437535 | 2022-04-23 | Skagit | Washington | 53057 | 22199 | 204 |
2434279 | 2434279 | 2022-04-22 | Skagit | Washington | 53057 | 22199 | 204 |
2431023 | 2431023 | 2022-04-21 | Skagit | Washington | 53057 | 22175 | 204 |
2427767 | 2427767 | 2022-04-20 | Skagit | Washington | 53057 | 22175 | 204 |
2424511 | 2424511 | 2022-04-19 | Skagit | Washington | 53057 | 22154 | 204 |
2421255 | 2421255 | 2022-04-18 | Skagit | Washington | 53057 | 22154 | 204 |
2417999 | 2417999 | 2022-04-17 | Skagit | Washington | 53057 | 22121 | 204 |
2414743 | 2414743 | 2022-04-16 | Skagit | Washington | 53057 | 22121 | 204 |
2411487 | 2411487 | 2022-04-15 | Skagit | Washington | 53057 | 22121 | 204 |
2408231 | 2408231 | 2022-04-14 | Skagit | Washington | 53057 | 22106 | 203 |
2404975 | 2404975 | 2022-04-13 | Skagit | Washington | 53057 | 22106 | 203 |
2401720 | 2401720 | 2022-04-12 | Skagit | Washington | 53057 | 22054 | 203 |
2398465 | 2398465 | 2022-04-11 | Skagit | Washington | 53057 | 22054 | 203 |
2395210 | 2395210 | 2022-04-10 | Skagit | Washington | 53057 | 22054 | 203 |
2391954 | 2391954 | 2022-04-09 | Skagit | Washington | 53057 | 22054 | 203 |
2388698 | 2388698 | 2022-04-08 | Skagit | Washington | 53057 | 22054 | 203 |
2385443 | 2385443 | 2022-04-07 | Skagit | Washington | 53057 | 22038 | 203 |
2382188 | 2382188 | 2022-04-06 | Skagit | Washington | 53057 | 22038 | 203 |
2378933 | 2378933 | 2022-04-05 | Skagit | Washington | 53057 | 22018 | 203 |
2375679 | 2375679 | 2022-04-04 | Skagit | Washington | 53057 | 22018 | 203 |
2372427 | 2372427 | 2022-04-03 | Skagit | Washington | 53057 | 22003 | 203 |
2369174 | 2369174 | 2022-04-02 | Skagit | Washington | 53057 | 22003 | 203 |
2365921 | 2365921 | 2022-04-01 | Skagit | Washington | 53057 | 22003 | 203 |
2362668 | 2362668 | 2022-03-31 | Skagit | Washington | 53057 | 21989 | 202 |
2359414 | 2359414 | 2022-03-30 | Skagit | Washington | 53057 | 21989 | 202 |
2356160 | 2356160 | 2022-03-29 | Skagit | Washington | 53057 | 21973 | 199 |
2352907 | 2352907 | 2022-03-28 | Skagit | Washington | 53057 | 21973 | 199 |
2349655 | 2349655 | 2022-03-27 | Skagit | Washington | 53057 | 21960 | 198 |
2346402 | 2346402 | 2022-03-26 | Skagit | Washington | 53057 | 21960 | 198 |
2343149 | 2343149 | 2022-03-25 | Skagit | Washington | 53057 | 21960 | 198 |
2339896 | 2339896 | 2022-03-24 | Skagit | Washington | 53057 | 21939 | 197 |
2336643 | 2336643 | 2022-03-23 | Skagit | Washington | 53057 | 21939 | 197 |
2333389 | 2333389 | 2022-03-22 | Skagit | Washington | 53057 | 21917 | 198 |
2330135 | 2330135 | 2022-03-21 | Skagit | Washington | 53057 | 21917 | 198 |
2326883 | 2326883 | 2022-03-20 | Skagit | Washington | 53057 | 21906 | 197 |
2323630 | 2323630 | 2022-03-19 | Skagit | Washington | 53057 | 21906 | 197 |
2320376 | 2320376 | 2022-03-18 | Skagit | Washington | 53057 | 21906 | 197 |
2317122 | 2317122 | 2022-03-17 | Skagit | Washington | 53057 | 21886 | 194 |
2313869 | 2313869 | 2022-03-16 | Skagit | Washington | 53057 | 21886 | 194 |
2310616 | 2310616 | 2022-03-15 | Skagit | Washington | 53057 | 21863 | 192 |
2307363 | 2307363 | 2022-03-14 | Skagit | Washington | 53057 | 21863 | 192 |
2304112 | 2304112 | 2022-03-13 | Skagit | Washington | 53057 | 21834 | 191 |
2300860 | 2300860 | 2022-03-12 | Skagit | Washington | 53057 | 21834 | 191 |
2297608 | 2297608 | 2022-03-11 | Skagit | Washington | 53057 | 21834 | 191 |
2294356 | 2294356 | 2022-03-10 | Skagit | Washington | 53057 | 21808 | 191 |
2291104 | 2291104 | 2022-03-09 | Skagit | Washington | 53057 | 21808 | 191 |
2287852 | 2287852 | 2022-03-08 | Skagit | Washington | 53057 | 21792 | 189 |
2284600 | 2284600 | 2022-03-07 | Skagit | Washington | 53057 | 21792 | 189 |
2281348 | 2281348 | 2022-03-06 | Skagit | Washington | 53057 | 21751 | 188 |
2278095 | 2278095 | 2022-03-05 | Skagit | Washington | 53057 | 21751 | 188 |
2274842 | 2274842 | 2022-03-04 | Skagit | Washington | 53057 | 21751 | 188 |
2271589 | 2271589 | 2022-03-03 | Skagit | Washington | 53057 | 21718 | 187 |
2268337 | 2268337 | 2022-03-02 | Skagit | Washington | 53057 | 21718 | 187 |
2265084 | 2265084 | 2022-03-01 | Skagit | Washington | 53057 | 21689 | 188 |
2261834 | 2261834 | 2022-02-28 | Skagit | Washington | 53057 | 21689 | 188 |
2258583 | 2258583 | 2022-02-27 | Skagit | Washington | 53057 | 21643 | 187 |
2255332 | 2255332 | 2022-02-26 | Skagit | Washington | 53057 | 21643 | 187 |
2252081 | 2252081 | 2022-02-25 | Skagit | Washington | 53057 | 21643 | 187 |
2248830 | 2248830 | 2022-02-24 | Skagit | Washington | 53057 | 21635 | 186 |
2245579 | 2245579 | 2022-02-23 | Skagit | Washington | 53057 | 21635 | 186 |
2242328 | 2242328 | 2022-02-22 | Skagit | Washington | 53057 | 21645 | 183 |
2239077 | 2239077 | 2022-02-21 | Skagit | Washington | 53057 | 21645 | 183 |
2235826 | 2235826 | 2022-02-20 | Skagit | Washington | 53057 | 21645 | 183 |
2232575 | 2232575 | 2022-02-19 | Skagit | Washington | 53057 | 21645 | 183 |
2229324 | 2229324 | 2022-02-18 | Skagit | Washington | 53057 | 21645 | 183 |
2226073 | 2226073 | 2022-02-17 | Skagit | Washington | 53057 | 21637 | 180 |
2222822 | 2222822 | 2022-02-16 | Skagit | Washington | 53057 | 21637 | 180 |
2219571 | 2219571 | 2022-02-15 | Skagit | Washington | 53057 | 21610 | 179 |
2216321 | 2216321 | 2022-02-14 | Skagit | Washington | 53057 | 21610 | 179 |
2213070 | 2213070 | 2022-02-13 | Skagit | Washington | 53057 | 21511 | 178 |
2209817 | 2209817 | 2022-02-12 | Skagit | Washington | 53057 | 21511 | 178 |
2206564 | 2206564 | 2022-02-11 | Skagit | Washington | 53057 | 21511 | 178 |
2203311 | 2203311 | 2022-02-10 | Skagit | Washington | 53057 | 21181 | 176 |
2200057 | 2200057 | 2022-02-09 | Skagit | Washington | 53057 | 21181 | 176 |
2196803 | 2196803 | 2022-02-08 | Skagit | Washington | 53057 | 21028 | 174 |
2193548 | 2193548 | 2022-02-07 | Skagit | Washington | 53057 | 21028 | 174 |
2190295 | 2190295 | 2022-02-06 | Skagit | Washington | 53057 | 20781 | 172 |
2187042 | 2187042 | 2022-02-05 | Skagit | Washington | 53057 | 20781 | 172 |
2183789 | 2183789 | 2022-02-04 | Skagit | Washington | 53057 | 20781 | 172 |
2180537 | 2180537 | 2022-02-03 | Skagit | Washington | 53057 | 20631 | 170 |
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);