ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Jasper" and fips = 19099 sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
9901 | 9901 | 2020-03-24 | Jasper | Iowa | 19099 | 1 | 0 |
11298 | 11298 | 2020-03-25 | Jasper | Iowa | 19099 | 1 | 0 |
12862 | 12862 | 2020-03-26 | Jasper | Iowa | 19099 | 2 | 0 |
14554 | 14554 | 2020-03-27 | Jasper | Iowa | 19099 | 2 | 0 |
16358 | 16358 | 2020-03-28 | Jasper | Iowa | 19099 | 3 | 0 |
18263 | 18263 | 2020-03-29 | Jasper | Iowa | 19099 | 4 | 0 |
20273 | 20273 | 2020-03-30 | Jasper | Iowa | 19099 | 5 | 0 |
22369 | 22369 | 2020-03-31 | Jasper | Iowa | 19099 | 6 | 0 |
24541 | 24541 | 2020-04-01 | Jasper | Iowa | 19099 | 7 | 0 |
26782 | 26782 | 2020-04-02 | Jasper | Iowa | 19099 | 7 | 0 |
29093 | 29093 | 2020-04-03 | Jasper | Iowa | 19099 | 8 | 0 |
31463 | 31463 | 2020-04-04 | Jasper | Iowa | 19099 | 8 | 0 |
33876 | 33876 | 2020-04-05 | Jasper | Iowa | 19099 | 8 | 0 |
36331 | 36331 | 2020-04-06 | Jasper | Iowa | 19099 | 8 | 0 |
38832 | 38832 | 2020-04-07 | Jasper | Iowa | 19099 | 8 | 0 |
41378 | 41378 | 2020-04-08 | Jasper | Iowa | 19099 | 8 | 0 |
43954 | 43954 | 2020-04-09 | Jasper | Iowa | 19099 | 9 | 0 |
46559 | 46559 | 2020-04-10 | Jasper | Iowa | 19099 | 10 | 0 |
49193 | 49193 | 2020-04-11 | Jasper | Iowa | 19099 | 10 | 0 |
51857 | 51857 | 2020-04-12 | Jasper | Iowa | 19099 | 11 | 0 |
54539 | 54539 | 2020-04-13 | Jasper | Iowa | 19099 | 12 | 0 |
57232 | 57232 | 2020-04-14 | Jasper | Iowa | 19099 | 15 | 0 |
59940 | 59940 | 2020-04-15 | Jasper | Iowa | 19099 | 17 | 0 |
62661 | 62661 | 2020-04-16 | Jasper | Iowa | 19099 | 23 | 0 |
65395 | 65395 | 2020-04-17 | Jasper | Iowa | 19099 | 28 | 0 |
68144 | 68144 | 2020-04-18 | Jasper | Iowa | 19099 | 33 | 0 |
70906 | 70906 | 2020-04-19 | Jasper | Iowa | 19099 | 36 | 0 |
73677 | 73677 | 2020-04-20 | Jasper | Iowa | 19099 | 42 | 0 |
76456 | 76456 | 2020-04-21 | Jasper | Iowa | 19099 | 53 | 0 |
79240 | 79240 | 2020-04-22 | Jasper | Iowa | 19099 | 53 | 0 |
82033 | 82033 | 2020-04-23 | Jasper | Iowa | 19099 | 55 | 0 |
84833 | 84833 | 2020-04-24 | Jasper | Iowa | 19099 | 73 | 0 |
87643 | 87643 | 2020-04-25 | Jasper | Iowa | 19099 | 79 | 0 |
90459 | 90459 | 2020-04-26 | Jasper | Iowa | 19099 | 83 | 0 |
93278 | 93278 | 2020-04-27 | Jasper | Iowa | 19099 | 91 | 0 |
96110 | 96110 | 2020-04-28 | Jasper | Iowa | 19099 | 109 | 0 |
98955 | 98955 | 2020-04-29 | Jasper | Iowa | 19099 | 130 | 1 |
101806 | 101806 | 2020-04-30 | Jasper | Iowa | 19099 | 130 | 1 |
104664 | 104664 | 2020-05-01 | Jasper | Iowa | 19099 | 155 | 1 |
107529 | 107529 | 2020-05-02 | Jasper | Iowa | 19099 | 175 | 1 |
110399 | 110399 | 2020-05-03 | Jasper | Iowa | 19099 | 193 | 1 |
113274 | 113274 | 2020-05-04 | Jasper | Iowa | 19099 | 210 | 2 |
116157 | 116157 | 2020-05-05 | Jasper | Iowa | 19099 | 219 | 3 |
119117 | 119117 | 2020-05-06 | Jasper | Iowa | 19099 | 220 | 5 |
122087 | 122087 | 2020-05-07 | Jasper | Iowa | 19099 | 229 | 5 |
125068 | 125068 | 2020-05-08 | Jasper | Iowa | 19099 | 235 | 6 |
128055 | 128055 | 2020-05-09 | Jasper | Iowa | 19099 | 238 | 8 |
131046 | 131046 | 2020-05-10 | Jasper | Iowa | 19099 | 238 | 8 |
134036 | 134036 | 2020-05-11 | Jasper | Iowa | 19099 | 238 | 8 |
137026 | 137026 | 2020-05-12 | Jasper | Iowa | 19099 | 239 | 8 |
140019 | 140019 | 2020-05-13 | Jasper | Iowa | 19099 | 239 | 10 |
143015 | 143015 | 2020-05-14 | Jasper | Iowa | 19099 | 240 | 11 |
146015 | 146015 | 2020-05-15 | Jasper | Iowa | 19099 | 241 | 11 |
149019 | 149019 | 2020-05-16 | Jasper | Iowa | 19099 | 242 | 12 |
152029 | 152029 | 2020-05-17 | Jasper | Iowa | 19099 | 247 | 12 |
155041 | 155041 | 2020-05-18 | Jasper | Iowa | 19099 | 249 | 13 |
158057 | 158057 | 2020-05-19 | Jasper | Iowa | 19099 | 250 | 14 |
161083 | 161083 | 2020-05-20 | Jasper | Iowa | 19099 | 251 | 14 |
164111 | 164111 | 2020-05-21 | Jasper | Iowa | 19099 | 251 | 15 |
167144 | 167144 | 2020-05-22 | Jasper | Iowa | 19099 | 250 | 15 |
170181 | 170181 | 2020-05-23 | Jasper | Iowa | 19099 | 250 | 15 |
173222 | 173222 | 2020-05-24 | Jasper | Iowa | 19099 | 256 | 16 |
176266 | 176266 | 2020-05-25 | Jasper | Iowa | 19099 | 256 | 16 |
179310 | 179310 | 2020-05-26 | Jasper | Iowa | 19099 | 257 | 16 |
182355 | 182355 | 2020-05-27 | Jasper | Iowa | 19099 | 258 | 16 |
185409 | 185409 | 2020-05-28 | Jasper | Iowa | 19099 | 260 | 16 |
188467 | 188467 | 2020-05-29 | Jasper | Iowa | 19099 | 260 | 16 |
191532 | 191532 | 2020-05-30 | Jasper | Iowa | 19099 | 261 | 16 |
194599 | 194599 | 2020-05-31 | Jasper | Iowa | 19099 | 260 | 16 |
197669 | 197669 | 2020-06-01 | Jasper | Iowa | 19099 | 260 | 17 |
200742 | 200742 | 2020-06-02 | Jasper | Iowa | 19099 | 261 | 17 |
203818 | 203818 | 2020-06-03 | Jasper | Iowa | 19099 | 263 | 17 |
206898 | 206898 | 2020-06-04 | Jasper | Iowa | 19099 | 269 | 17 |
209979 | 209979 | 2020-06-05 | Jasper | Iowa | 19099 | 269 | 17 |
213064 | 213064 | 2020-06-06 | Jasper | Iowa | 19099 | 271 | 17 |
216151 | 216151 | 2020-06-07 | Jasper | Iowa | 19099 | 274 | 17 |
219243 | 219243 | 2020-06-08 | Jasper | Iowa | 19099 | 273 | 17 |
222338 | 222338 | 2020-06-09 | Jasper | Iowa | 19099 | 275 | 17 |
225433 | 225433 | 2020-06-10 | Jasper | Iowa | 19099 | 277 | 17 |
228535 | 228535 | 2020-06-11 | Jasper | Iowa | 19099 | 278 | 17 |
231638 | 231638 | 2020-06-12 | Jasper | Iowa | 19099 | 279 | 17 |
234744 | 234744 | 2020-06-13 | Jasper | Iowa | 19099 | 280 | 17 |
237851 | 237851 | 2020-06-14 | Jasper | Iowa | 19099 | 283 | 17 |
240959 | 240959 | 2020-06-15 | Jasper | Iowa | 19099 | 282 | 17 |
244070 | 244070 | 2020-06-16 | Jasper | Iowa | 19099 | 283 | 17 |
247183 | 247183 | 2020-06-17 | Jasper | Iowa | 19099 | 287 | 17 |
250295 | 250295 | 2020-06-18 | Jasper | Iowa | 19099 | 290 | 17 |
253410 | 253410 | 2020-06-19 | Jasper | Iowa | 19099 | 290 | 17 |
256530 | 256530 | 2020-06-20 | Jasper | Iowa | 19099 | 291 | 17 |
259656 | 259656 | 2020-06-21 | Jasper | Iowa | 19099 | 296 | 17 |
262783 | 262783 | 2020-06-22 | Jasper | Iowa | 19099 | 298 | 17 |
265911 | 265911 | 2020-06-23 | Jasper | Iowa | 19099 | 304 | 17 |
269041 | 269041 | 2020-06-24 | Jasper | Iowa | 19099 | 305 | 17 |
272178 | 272178 | 2020-06-25 | Jasper | Iowa | 19099 | 305 | 17 |
275320 | 275320 | 2020-06-26 | Jasper | Iowa | 19099 | 306 | 17 |
278468 | 278468 | 2020-06-27 | Jasper | Iowa | 19099 | 309 | 17 |
281616 | 281616 | 2020-06-28 | Jasper | Iowa | 19099 | 313 | 17 |
284761 | 284761 | 2020-06-29 | Jasper | Iowa | 19099 | 315 | 17 |
287910 | 287910 | 2020-06-30 | Jasper | Iowa | 19099 | 317 | 17 |
291060 | 291060 | 2020-07-01 | Jasper | Iowa | 19099 | 318 | 17 |
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);