ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 8045 sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 76 ✖
- 38 97
- 2 88
- 5 63
- 4 57
- 90 40
- 56 21
- 60 21
- 91 20
- 59 16
- 80 16
- 0 15
- 50 15
- 57 14
- 6 13
- 52 13
- 42 12
- 87 11
- 1 10
- 39 10
- 3 9
- 35 9
- 36 9
- 65 9
- 78 9
- 88 9
- 89 9
- 58 8
- 68 8
- 75 8
- 83 8
- 10 7
- 37 7
- 69 7
- 76 7
- 77 7
- 7 6
- 24 6
- 40 5
- 43 5
- 46 5
- 61 5
- 25 4
- 55 4
- 79 4
- 86 4
- 17 3
- 26 3
- 30 3
- 34 3
- 45 3
- 47 3
- 48 3
- 51 3
- 54 3
- 73 3
- 84 3
- 14 2
- 27 2
- 28 2
- 31 2
- 53 2
- 66 2
- 81 2
- 9 1
- 16 1
- 29 1
- 41 1
- 44 1
- 49 1
- 63 1
- 64 1
- 70 1
- 71 1
- 72 1
- 74 1
- 85 1
state 1
- Colorado 790
fips 1
- 8045 · 790 ✖
county 1
- Garfield 790
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
2364 | 2364 | 2020-03-15 | Garfield | Colorado | 8045 | 1 | 0 |
2799 | 2799 | 2020-03-16 | Garfield | Colorado | 8045 | 2 | 0 |
3281 | 3281 | 2020-03-17 | Garfield | Colorado | 8045 | 2 | 0 |
3835 | 3835 | 2020-03-18 | Garfield | Colorado | 8045 | 2 | 0 |
4496 | 4496 | 2020-03-19 | Garfield | Colorado | 8045 | 3 | 0 |
5272 | 5272 | 2020-03-20 | Garfield | Colorado | 8045 | 4 | 0 |
6197 | 6197 | 2020-03-21 | Garfield | Colorado | 8045 | 7 | 0 |
7232 | 7232 | 2020-03-22 | Garfield | Colorado | 8045 | 8 | 0 |
8375 | 8375 | 2020-03-23 | Garfield | Colorado | 8045 | 8 | 0 |
9619 | 9619 | 2020-03-24 | Garfield | Colorado | 8045 | 10 | 0 |
10992 | 10992 | 2020-03-25 | Garfield | Colorado | 8045 | 13 | 0 |
12537 | 12537 | 2020-03-26 | Garfield | Colorado | 8045 | 16 | 0 |
14205 | 14205 | 2020-03-27 | Garfield | Colorado | 8045 | 16 | 0 |
15988 | 15988 | 2020-03-28 | Garfield | Colorado | 8045 | 23 | 0 |
17878 | 17878 | 2020-03-29 | Garfield | Colorado | 8045 | 25 | 0 |
19856 | 19856 | 2020-03-30 | Garfield | Colorado | 8045 | 31 | 1 |
21931 | 21931 | 2020-03-31 | Garfield | Colorado | 8045 | 33 | 1 |
24090 | 24090 | 2020-04-01 | Garfield | Colorado | 8045 | 34 | 1 |
26320 | 26320 | 2020-04-02 | Garfield | Colorado | 8045 | 43 | 1 |
28620 | 28620 | 2020-04-03 | Garfield | Colorado | 8045 | 45 | 1 |
30977 | 30977 | 2020-04-04 | Garfield | Colorado | 8045 | 45 | 1 |
33383 | 33383 | 2020-04-05 | Garfield | Colorado | 8045 | 46 | 1 |
35828 | 35828 | 2020-04-06 | Garfield | Colorado | 8045 | 47 | 1 |
38318 | 38318 | 2020-04-07 | Garfield | Colorado | 8045 | 48 | 1 |
40861 | 40861 | 2020-04-08 | Garfield | Colorado | 8045 | 49 | 1 |
43433 | 43433 | 2020-04-09 | Garfield | Colorado | 8045 | 50 | 2 |
46033 | 46033 | 2020-04-10 | Garfield | Colorado | 8045 | 52 | 2 |
48663 | 48663 | 2020-04-11 | Garfield | Colorado | 8045 | 54 | 2 |
51325 | 51325 | 2020-04-12 | Garfield | Colorado | 8045 | 55 | 2 |
54004 | 54004 | 2020-04-13 | Garfield | Colorado | 8045 | 58 | 2 |
56696 | 56696 | 2020-04-14 | Garfield | Colorado | 8045 | 59 | 2 |
59404 | 59404 | 2020-04-15 | Garfield | Colorado | 8045 | 62 | 2 |
62123 | 62123 | 2020-04-16 | Garfield | Colorado | 8045 | 64 | 2 |
64856 | 64856 | 2020-04-17 | Garfield | Colorado | 8045 | 65 | 2 |
67604 | 67604 | 2020-04-18 | Garfield | Colorado | 8045 | 70 | 2 |
70366 | 70366 | 2020-04-19 | Garfield | Colorado | 8045 | 70 | 2 |
73135 | 73135 | 2020-04-20 | Garfield | Colorado | 8045 | 71 | 2 |
75911 | 75911 | 2020-04-21 | Garfield | Colorado | 8045 | 71 | 2 |
78695 | 78695 | 2020-04-22 | Garfield | Colorado | 8045 | 71 | 2 |
81489 | 81489 | 2020-04-23 | Garfield | Colorado | 8045 | 74 | 2 |
84289 | 84289 | 2020-04-24 | Garfield | Colorado | 8045 | 81 | 2 |
87097 | 87097 | 2020-04-25 | Garfield | Colorado | 8045 | 83 | 2 |
89914 | 89914 | 2020-04-26 | Garfield | Colorado | 8045 | 87 | 2 |
92732 | 92732 | 2020-04-27 | Garfield | Colorado | 8045 | 88 | 2 |
95564 | 95564 | 2020-04-28 | Garfield | Colorado | 8045 | 89 | 2 |
98409 | 98409 | 2020-04-29 | Garfield | Colorado | 8045 | 91 | 2 |
101259 | 101259 | 2020-04-30 | Garfield | Colorado | 8045 | 93 | 2 |
104114 | 104114 | 2020-05-01 | Garfield | Colorado | 8045 | 93 | 2 |
106979 | 106979 | 2020-05-02 | Garfield | Colorado | 8045 | 95 | 2 |
109848 | 109848 | 2020-05-03 | Garfield | Colorado | 8045 | 97 | 2 |
112723 | 112723 | 2020-05-04 | Garfield | Colorado | 8045 | 95 | 2 |
115606 | 115606 | 2020-05-05 | Garfield | Colorado | 8045 | 99 | 2 |
118565 | 118565 | 2020-05-06 | Garfield | Colorado | 8045 | 99 | 2 |
121534 | 121534 | 2020-05-07 | Garfield | Colorado | 8045 | 100 | 2 |
124514 | 124514 | 2020-05-08 | Garfield | Colorado | 8045 | 102 | 2 |
127500 | 127500 | 2020-05-09 | Garfield | Colorado | 8045 | 103 | 2 |
130491 | 130491 | 2020-05-10 | Garfield | Colorado | 8045 | 104 | 2 |
133482 | 133482 | 2020-05-11 | Garfield | Colorado | 8045 | 103 | 2 |
136471 | 136471 | 2020-05-12 | Garfield | Colorado | 8045 | 111 | 2 |
139462 | 139462 | 2020-05-13 | Garfield | Colorado | 8045 | 112 | 2 |
142458 | 142458 | 2020-05-14 | Garfield | Colorado | 8045 | 112 | 2 |
145458 | 145458 | 2020-05-15 | Garfield | Colorado | 8045 | 113 | 2 |
148461 | 148461 | 2020-05-16 | Garfield | Colorado | 8045 | 113 | 2 |
151470 | 151470 | 2020-05-17 | Garfield | Colorado | 8045 | 115 | 2 |
154482 | 154482 | 2020-05-18 | Garfield | Colorado | 8045 | 114 | 2 |
157498 | 157498 | 2020-05-19 | Garfield | Colorado | 8045 | 115 | 2 |
160524 | 160524 | 2020-05-20 | Garfield | Colorado | 8045 | 114 | 2 |
163552 | 163552 | 2020-05-21 | Garfield | Colorado | 8045 | 114 | 2 |
166585 | 166585 | 2020-05-22 | Garfield | Colorado | 8045 | 120 | 2 |
169622 | 169622 | 2020-05-23 | Garfield | Colorado | 8045 | 120 | 2 |
172663 | 172663 | 2020-05-24 | Garfield | Colorado | 8045 | 121 | 2 |
175707 | 175707 | 2020-05-25 | Garfield | Colorado | 8045 | 123 | 2 |
178751 | 178751 | 2020-05-26 | Garfield | Colorado | 8045 | 134 | 2 |
181795 | 181795 | 2020-05-27 | Garfield | Colorado | 8045 | 135 | 2 |
184849 | 184849 | 2020-05-28 | Garfield | Colorado | 8045 | 135 | 2 |
187905 | 187905 | 2020-05-29 | Garfield | Colorado | 8045 | 137 | 2 |
190970 | 190970 | 2020-05-30 | Garfield | Colorado | 8045 | 138 | 2 |
194037 | 194037 | 2020-05-31 | Garfield | Colorado | 8045 | 139 | 2 |
197107 | 197107 | 2020-06-01 | Garfield | Colorado | 8045 | 143 | 2 |
200180 | 200180 | 2020-06-02 | Garfield | Colorado | 8045 | 148 | 2 |
203256 | 203256 | 2020-06-03 | Garfield | Colorado | 8045 | 150 | 2 |
206336 | 206336 | 2020-06-04 | Garfield | Colorado | 8045 | 157 | 2 |
209417 | 209417 | 2020-06-05 | Garfield | Colorado | 8045 | 158 | 2 |
212502 | 212502 | 2020-06-06 | Garfield | Colorado | 8045 | 161 | 2 |
215589 | 215589 | 2020-06-07 | Garfield | Colorado | 8045 | 162 | 2 |
218680 | 218680 | 2020-06-08 | Garfield | Colorado | 8045 | 164 | 2 |
221775 | 221775 | 2020-06-09 | Garfield | Colorado | 8045 | 166 | 2 |
224870 | 224870 | 2020-06-10 | Garfield | Colorado | 8045 | 171 | 2 |
227972 | 227972 | 2020-06-11 | Garfield | Colorado | 8045 | 176 | 2 |
231075 | 231075 | 2020-06-12 | Garfield | Colorado | 8045 | 177 | 2 |
234181 | 234181 | 2020-06-13 | Garfield | Colorado | 8045 | 181 | 2 |
237288 | 237288 | 2020-06-14 | Garfield | Colorado | 8045 | 184 | 2 |
240396 | 240396 | 2020-06-15 | Garfield | Colorado | 8045 | 193 | 2 |
243507 | 243507 | 2020-06-16 | Garfield | Colorado | 8045 | 195 | 2 |
246620 | 246620 | 2020-06-17 | Garfield | Colorado | 8045 | 199 | 2 |
249732 | 249732 | 2020-06-18 | Garfield | Colorado | 8045 | 205 | 2 |
252847 | 252847 | 2020-06-19 | Garfield | Colorado | 8045 | 214 | 2 |
255966 | 255966 | 2020-06-20 | Garfield | Colorado | 8045 | 217 | 2 |
259093 | 259093 | 2020-06-21 | Garfield | Colorado | 8045 | 222 | 2 |
262220 | 262220 | 2020-06-22 | Garfield | Colorado | 8045 | 224 | 2 |
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);