ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
801 rows where fips = 53007 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 116 ✖
- 7 65
- 162 38
- 64 37
- 67 34
- 6 31
- 20 26
- 74 21
- 12 20
- 72 20
- 1 19
- 24 15
- 102 15
- 75 14
- 14 13
- 30 12
- 31 12
- 62 12
- 63 12
- 68 12
- 161 12
- 143 10
- 3 9
- 19 9
- 157 9
- 65 8
- 135 8
- 139 8
- 142 8
- 8 7
- 13 7
- 17 7
- 35 7
- 73 7
- 86 7
- 100 7
- 2 6
- 10 6
- 16 6
- 36 6
- 58 6
- 70 6
- 81 6
- 96 6
- 105 6
- 117 6
- 140 6
- 15 5
- 43 5
- 46 5
- 89 5
- 103 5
- 133 5
- 147 5
- 151 5
- 153 5
- 156 5
- 158 5
- 0 4
- 34 4
- 37 4
- 39 4
- 50 4
- 54 4
- 91 4
- 98 4
- 108 4
- 116 4
- 120 4
- 121 4
- 124 4
- 130 4
- 145 4
- 33 3
- 107 3
- 11 2
- 18 2
- 44 2
- 51 2
- 52 2
- 90 2
- 94 2
- 122 2
- 131 2
- 136 2
- 150 2
- 152 2
- 154 2
- 160 2
- 9 1
- 23 1
- 32 1
- 40 1
- 41 1
- 48 1
- 49 1
- 56 1
- 59 1
- 60 1
- 61 1
- 66 1
- 69 1
- 71 1
- 78 1
- 80 1
- 84 1
- 85 1
- 93 1
- 97 1
- 99 1
- 104 1
- 110 1
- 112 1
- 114 1
- 123 1
- 127 1
- 129 1
state 1
- Washington 801
fips 1
- 53007 · 801 ✖
county 1
- Chelan 801
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502646 | 2502646 | 2022-05-13 | Chelan | Washington | 53007 | 20463 | 162 |
2499388 | 2499388 | 2022-05-12 | Chelan | Washington | 53007 | 20426 | 162 |
2496130 | 2496130 | 2022-05-11 | Chelan | Washington | 53007 | 20426 | 162 |
2492872 | 2492872 | 2022-05-10 | Chelan | Washington | 53007 | 20369 | 162 |
2489614 | 2489614 | 2022-05-09 | Chelan | Washington | 53007 | 20367 | 162 |
2486357 | 2486357 | 2022-05-08 | Chelan | Washington | 53007 | 20321 | 162 |
2483099 | 2483099 | 2022-05-07 | Chelan | Washington | 53007 | 20321 | 162 |
2479841 | 2479841 | 2022-05-06 | Chelan | Washington | 53007 | 20321 | 162 |
2476583 | 2476583 | 2022-05-05 | Chelan | Washington | 53007 | 20310 | 162 |
2473325 | 2473325 | 2022-05-04 | Chelan | Washington | 53007 | 20308 | 162 |
2470069 | 2470069 | 2022-05-03 | Chelan | Washington | 53007 | 20277 | 162 |
2466813 | 2466813 | 2022-05-02 | Chelan | Washington | 53007 | 20276 | 162 |
2463558 | 2463558 | 2022-05-01 | Chelan | Washington | 53007 | 20247 | 162 |
2460302 | 2460302 | 2022-04-30 | Chelan | Washington | 53007 | 20247 | 162 |
2457046 | 2457046 | 2022-04-29 | Chelan | Washington | 53007 | 20247 | 162 |
2453790 | 2453790 | 2022-04-28 | Chelan | Washington | 53007 | 20224 | 162 |
2450534 | 2450534 | 2022-04-27 | Chelan | Washington | 53007 | 20222 | 162 |
2447278 | 2447278 | 2022-04-26 | Chelan | Washington | 53007 | 20195 | 162 |
2444022 | 2444022 | 2022-04-25 | Chelan | Washington | 53007 | 20195 | 162 |
2440766 | 2440766 | 2022-04-24 | Chelan | Washington | 53007 | 20175 | 162 |
2437510 | 2437510 | 2022-04-23 | Chelan | Washington | 53007 | 20175 | 162 |
2434254 | 2434254 | 2022-04-22 | Chelan | Washington | 53007 | 20175 | 162 |
2430998 | 2430998 | 2022-04-21 | Chelan | Washington | 53007 | 20154 | 162 |
2427742 | 2427742 | 2022-04-20 | Chelan | Washington | 53007 | 20154 | 162 |
2424486 | 2424486 | 2022-04-19 | Chelan | Washington | 53007 | 20149 | 162 |
2421230 | 2421230 | 2022-04-18 | Chelan | Washington | 53007 | 20149 | 162 |
2417974 | 2417974 | 2022-04-17 | Chelan | Washington | 53007 | 20131 | 162 |
2414718 | 2414718 | 2022-04-16 | Chelan | Washington | 53007 | 20131 | 162 |
2411462 | 2411462 | 2022-04-15 | Chelan | Washington | 53007 | 20131 | 162 |
2408206 | 2408206 | 2022-04-14 | Chelan | Washington | 53007 | 20131 | 162 |
2404950 | 2404950 | 2022-04-13 | Chelan | Washington | 53007 | 20119 | 162 |
2401695 | 2401695 | 2022-04-12 | Chelan | Washington | 53007 | 20091 | 162 |
2398440 | 2398440 | 2022-04-11 | Chelan | Washington | 53007 | 20091 | 162 |
2395185 | 2395185 | 2022-04-10 | Chelan | Washington | 53007 | 20091 | 162 |
2391929 | 2391929 | 2022-04-09 | Chelan | Washington | 53007 | 20091 | 162 |
2388673 | 2388673 | 2022-04-08 | Chelan | Washington | 53007 | 20091 | 162 |
2385418 | 2385418 | 2022-04-07 | Chelan | Washington | 53007 | 20086 | 162 |
2382163 | 2382163 | 2022-04-06 | Chelan | Washington | 53007 | 20073 | 162 |
2378908 | 2378908 | 2022-04-05 | Chelan | Washington | 53007 | 20067 | 161 |
2375654 | 2375654 | 2022-04-04 | Chelan | Washington | 53007 | 20067 | 161 |
2372402 | 2372402 | 2022-04-03 | Chelan | Washington | 53007 | 20058 | 161 |
2369149 | 2369149 | 2022-04-02 | Chelan | Washington | 53007 | 20058 | 161 |
2365896 | 2365896 | 2022-04-01 | Chelan | Washington | 53007 | 20058 | 161 |
2362643 | 2362643 | 2022-03-31 | Chelan | Washington | 53007 | 20047 | 161 |
2359389 | 2359389 | 2022-03-30 | Chelan | Washington | 53007 | 20042 | 161 |
2356135 | 2356135 | 2022-03-29 | Chelan | Washington | 53007 | 20039 | 161 |
2352882 | 2352882 | 2022-03-28 | Chelan | Washington | 53007 | 20036 | 161 |
2349630 | 2349630 | 2022-03-27 | Chelan | Washington | 53007 | 20025 | 161 |
2346377 | 2346377 | 2022-03-26 | Chelan | Washington | 53007 | 20025 | 161 |
2343124 | 2343124 | 2022-03-25 | Chelan | Washington | 53007 | 20025 | 161 |
2339871 | 2339871 | 2022-03-24 | Chelan | Washington | 53007 | 20014 | 160 |
2336618 | 2336618 | 2022-03-23 | Chelan | Washington | 53007 | 20014 | 160 |
2333364 | 2333364 | 2022-03-22 | Chelan | Washington | 53007 | 20004 | 158 |
2330110 | 2330110 | 2022-03-21 | Chelan | Washington | 53007 | 20000 | 158 |
2326858 | 2326858 | 2022-03-20 | Chelan | Washington | 53007 | 19983 | 158 |
2323605 | 2323605 | 2022-03-19 | Chelan | Washington | 53007 | 19983 | 158 |
2320351 | 2320351 | 2022-03-18 | Chelan | Washington | 53007 | 19983 | 158 |
2317097 | 2317097 | 2022-03-17 | Chelan | Washington | 53007 | 19978 | 157 |
2313844 | 2313844 | 2022-03-16 | Chelan | Washington | 53007 | 19968 | 157 |
2310591 | 2310591 | 2022-03-15 | Chelan | Washington | 53007 | 19947 | 157 |
2307338 | 2307338 | 2022-03-14 | Chelan | Washington | 53007 | 19947 | 157 |
2304087 | 2304087 | 2022-03-13 | Chelan | Washington | 53007 | 19931 | 157 |
2300835 | 2300835 | 2022-03-12 | Chelan | Washington | 53007 | 19931 | 157 |
2297583 | 2297583 | 2022-03-11 | Chelan | Washington | 53007 | 19931 | 157 |
2294331 | 2294331 | 2022-03-10 | Chelan | Washington | 53007 | 19928 | 157 |
2291079 | 2291079 | 2022-03-09 | Chelan | Washington | 53007 | 19912 | 157 |
2287827 | 2287827 | 2022-03-08 | Chelan | Washington | 53007 | 19886 | 156 |
2284575 | 2284575 | 2022-03-07 | Chelan | Washington | 53007 | 19886 | 156 |
2281323 | 2281323 | 2022-03-06 | Chelan | Washington | 53007 | 19864 | 156 |
2278070 | 2278070 | 2022-03-05 | Chelan | Washington | 53007 | 19864 | 156 |
2274817 | 2274817 | 2022-03-04 | Chelan | Washington | 53007 | 19864 | 156 |
2271564 | 2271564 | 2022-03-03 | Chelan | Washington | 53007 | 19844 | 154 |
2268312 | 2268312 | 2022-03-02 | Chelan | Washington | 53007 | 19812 | 154 |
2265059 | 2265059 | 2022-03-01 | Chelan | Washington | 53007 | 19783 | 153 |
2261809 | 2261809 | 2022-02-28 | Chelan | Washington | 53007 | 19744 | 153 |
2258558 | 2258558 | 2022-02-27 | Chelan | Washington | 53007 | 19711 | 153 |
2255307 | 2255307 | 2022-02-26 | Chelan | Washington | 53007 | 19711 | 153 |
2252056 | 2252056 | 2022-02-25 | Chelan | Washington | 53007 | 19711 | 153 |
2248805 | 2248805 | 2022-02-24 | Chelan | Washington | 53007 | 19588 | 152 |
2245554 | 2245554 | 2022-02-23 | Chelan | Washington | 53007 | 19588 | 152 |
2242303 | 2242303 | 2022-02-22 | Chelan | Washington | 53007 | 19525 | 151 |
2239052 | 2239052 | 2022-02-21 | Chelan | Washington | 53007 | 19525 | 151 |
2235801 | 2235801 | 2022-02-20 | Chelan | Washington | 53007 | 19525 | 151 |
2232550 | 2232550 | 2022-02-19 | Chelan | Washington | 53007 | 19525 | 151 |
2229299 | 2229299 | 2022-02-18 | Chelan | Washington | 53007 | 19525 | 151 |
2226048 | 2226048 | 2022-02-17 | Chelan | Washington | 53007 | 19615 | 150 |
2222797 | 2222797 | 2022-02-16 | Chelan | Washington | 53007 | 19615 | 150 |
2219546 | 2219546 | 2022-02-15 | Chelan | Washington | 53007 | 19571 | 147 |
2216296 | 2216296 | 2022-02-14 | Chelan | Washington | 53007 | 19571 | 147 |
2213045 | 2213045 | 2022-02-13 | Chelan | Washington | 53007 | 19510 | 147 |
2209792 | 2209792 | 2022-02-12 | Chelan | Washington | 53007 | 19510 | 147 |
2206539 | 2206539 | 2022-02-11 | Chelan | Washington | 53007 | 19510 | 147 |
2203286 | 2203286 | 2022-02-10 | Chelan | Washington | 53007 | 19246 | 145 |
2200032 | 2200032 | 2022-02-09 | Chelan | Washington | 53007 | 19246 | 145 |
2196778 | 2196778 | 2022-02-08 | Chelan | Washington | 53007 | 19111 | 145 |
2193523 | 2193523 | 2022-02-07 | Chelan | Washington | 53007 | 19111 | 145 |
2190270 | 2190270 | 2022-02-06 | Chelan | Washington | 53007 | 18931 | 143 |
2187017 | 2187017 | 2022-02-05 | Chelan | Washington | 53007 | 18931 | 143 |
2183764 | 2183764 | 2022-02-04 | Chelan | Washington | 53007 | 18931 | 143 |
2180512 | 2180512 | 2022-02-03 | Chelan | Washington | 53007 | 18703 | 142 |
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);