ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 19157 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535294 | 535294 | 2020-09-15 | Poweshiek | Iowa | 19157 | 221 | 8 |
532059 | 532059 | 2020-09-14 | Poweshiek | Iowa | 19157 | 219 | 8 |
528822 | 528822 | 2020-09-13 | Poweshiek | Iowa | 19157 | 219 | 8 |
525586 | 525586 | 2020-09-12 | Poweshiek | Iowa | 19157 | 216 | 8 |
522350 | 522350 | 2020-09-11 | Poweshiek | Iowa | 19157 | 212 | 8 |
519113 | 519113 | 2020-09-10 | Poweshiek | Iowa | 19157 | 210 | 8 |
515878 | 515878 | 2020-09-09 | Poweshiek | Iowa | 19157 | 207 | 8 |
512645 | 512645 | 2020-09-08 | Poweshiek | Iowa | 19157 | 205 | 8 |
509412 | 509412 | 2020-09-07 | Poweshiek | Iowa | 19157 | 204 | 8 |
506180 | 506180 | 2020-09-06 | Poweshiek | Iowa | 19157 | 203 | 8 |
502946 | 502946 | 2020-09-05 | Poweshiek | Iowa | 19157 | 200 | 8 |
499712 | 499712 | 2020-09-04 | Poweshiek | Iowa | 19157 | 196 | 8 |
496479 | 496479 | 2020-09-03 | Poweshiek | Iowa | 19157 | 187 | 8 |
493245 | 493245 | 2020-09-02 | Poweshiek | Iowa | 19157 | 185 | 8 |
490012 | 490012 | 2020-09-01 | Poweshiek | Iowa | 19157 | 184 | 8 |
486779 | 486779 | 2020-08-31 | Poweshiek | Iowa | 19157 | 183 | 8 |
483544 | 483544 | 2020-08-30 | Poweshiek | Iowa | 19157 | 184 | 8 |
480310 | 480310 | 2020-08-29 | Poweshiek | Iowa | 19157 | 182 | 8 |
477077 | 477077 | 2020-08-28 | Poweshiek | Iowa | 19157 | 182 | 8 |
473844 | 473844 | 2020-08-27 | Poweshiek | Iowa | 19157 | 181 | 8 |
470612 | 470612 | 2020-08-26 | Poweshiek | Iowa | 19157 | 178 | 8 |
467383 | 467383 | 2020-08-25 | Poweshiek | Iowa | 19157 | 177 | 8 |
464154 | 464154 | 2020-08-24 | Poweshiek | Iowa | 19157 | 178 | 8 |
460925 | 460925 | 2020-08-23 | Poweshiek | Iowa | 19157 | 177 | 8 |
457698 | 457698 | 2020-08-22 | Poweshiek | Iowa | 19157 | 176 | 8 |
454470 | 454470 | 2020-08-21 | Poweshiek | Iowa | 19157 | 175 | 8 |
451242 | 451242 | 2020-08-20 | Poweshiek | Iowa | 19157 | 172 | 8 |
448014 | 448014 | 2020-08-19 | Poweshiek | Iowa | 19157 | 167 | 8 |
444787 | 444787 | 2020-08-18 | Poweshiek | Iowa | 19157 | 164 | 8 |
441561 | 441561 | 2020-08-17 | Poweshiek | Iowa | 19157 | 163 | 8 |
438335 | 438335 | 2020-08-16 | Poweshiek | Iowa | 19157 | 163 | 8 |
435109 | 435109 | 2020-08-15 | Poweshiek | Iowa | 19157 | 162 | 8 |
431884 | 431884 | 2020-08-14 | Poweshiek | Iowa | 19157 | 160 | 8 |
428656 | 428656 | 2020-08-13 | Poweshiek | Iowa | 19157 | 160 | 8 |
425432 | 425432 | 2020-08-12 | Poweshiek | Iowa | 19157 | 159 | 8 |
422211 | 422211 | 2020-08-11 | Poweshiek | Iowa | 19157 | 160 | 8 |
418988 | 418988 | 2020-08-10 | Poweshiek | Iowa | 19157 | 159 | 8 |
415767 | 415767 | 2020-08-09 | Poweshiek | Iowa | 19157 | 159 | 8 |
412547 | 412547 | 2020-08-08 | Poweshiek | Iowa | 19157 | 157 | 8 |
409328 | 409328 | 2020-08-07 | Poweshiek | Iowa | 19157 | 155 | 8 |
406108 | 406108 | 2020-08-06 | Poweshiek | Iowa | 19157 | 153 | 8 |
402890 | 402890 | 2020-08-05 | Poweshiek | Iowa | 19157 | 151 | 8 |
399674 | 399674 | 2020-08-04 | Poweshiek | Iowa | 19157 | 150 | 8 |
396458 | 396458 | 2020-08-03 | Poweshiek | Iowa | 19157 | 146 | 8 |
393242 | 393242 | 2020-08-02 | Poweshiek | Iowa | 19157 | 146 | 8 |
390025 | 390025 | 2020-08-01 | Poweshiek | Iowa | 19157 | 145 | 8 |
386808 | 386808 | 2020-07-31 | Poweshiek | Iowa | 19157 | 137 | 8 |
383590 | 383590 | 2020-07-30 | Poweshiek | Iowa | 19157 | 136 | 8 |
380373 | 380373 | 2020-07-29 | Poweshiek | Iowa | 19157 | 135 | 8 |
377156 | 377156 | 2020-07-28 | Poweshiek | Iowa | 19157 | 128 | 8 |
373941 | 373941 | 2020-07-27 | Poweshiek | Iowa | 19157 | 123 | 8 |
370729 | 370729 | 2020-07-26 | Poweshiek | Iowa | 19157 | 123 | 8 |
367519 | 367519 | 2020-07-25 | Poweshiek | Iowa | 19157 | 123 | 8 |
364312 | 364312 | 2020-07-24 | Poweshiek | Iowa | 19157 | 121 | 8 |
361105 | 361105 | 2020-07-23 | Poweshiek | Iowa | 19157 | 118 | 8 |
357900 | 357900 | 2020-07-22 | Poweshiek | Iowa | 19157 | 117 | 8 |
354698 | 354698 | 2020-07-21 | Poweshiek | Iowa | 19157 | 114 | 8 |
351496 | 351496 | 2020-07-20 | Poweshiek | Iowa | 19157 | 114 | 8 |
348296 | 348296 | 2020-07-19 | Poweshiek | Iowa | 19157 | 114 | 8 |
345095 | 345095 | 2020-07-18 | Poweshiek | Iowa | 19157 | 115 | 8 |
341895 | 341895 | 2020-07-17 | Poweshiek | Iowa | 19157 | 115 | 8 |
338699 | 338699 | 2020-07-16 | Poweshiek | Iowa | 19157 | 114 | 8 |
335503 | 335503 | 2020-07-15 | Poweshiek | Iowa | 19157 | 114 | 8 |
332310 | 332310 | 2020-07-14 | Poweshiek | Iowa | 19157 | 111 | 8 |
329123 | 329123 | 2020-07-13 | Poweshiek | Iowa | 19157 | 112 | 8 |
325937 | 325937 | 2020-07-12 | Poweshiek | Iowa | 19157 | 113 | 8 |
322756 | 322756 | 2020-07-11 | Poweshiek | Iowa | 19157 | 112 | 8 |
319577 | 319577 | 2020-07-10 | Poweshiek | Iowa | 19157 | 110 | 8 |
316404 | 316404 | 2020-07-09 | Poweshiek | Iowa | 19157 | 109 | 8 |
313230 | 313230 | 2020-07-08 | Poweshiek | Iowa | 19157 | 107 | 8 |
310060 | 310060 | 2020-07-07 | Poweshiek | Iowa | 19157 | 107 | 8 |
306892 | 306892 | 2020-07-06 | Poweshiek | Iowa | 19157 | 106 | 8 |
303727 | 303727 | 2020-07-05 | Poweshiek | Iowa | 19157 | 105 | 8 |
300563 | 300563 | 2020-07-04 | Poweshiek | Iowa | 19157 | 104 | 8 |
297401 | 297401 | 2020-07-03 | Poweshiek | Iowa | 19157 | 104 | 8 |
294243 | 294243 | 2020-07-02 | Poweshiek | Iowa | 19157 | 104 | 8 |
291089 | 291089 | 2020-07-01 | Poweshiek | Iowa | 19157 | 104 | 8 |
287939 | 287939 | 2020-06-30 | Poweshiek | Iowa | 19157 | 104 | 8 |
284790 | 284790 | 2020-06-29 | Poweshiek | Iowa | 19157 | 104 | 8 |
281645 | 281645 | 2020-06-28 | Poweshiek | Iowa | 19157 | 104 | 8 |
278497 | 278497 | 2020-06-27 | Poweshiek | Iowa | 19157 | 104 | 8 |
275349 | 275349 | 2020-06-26 | Poweshiek | Iowa | 19157 | 102 | 8 |
272207 | 272207 | 2020-06-25 | Poweshiek | Iowa | 19157 | 101 | 8 |
269070 | 269070 | 2020-06-24 | Poweshiek | Iowa | 19157 | 98 | 8 |
265940 | 265940 | 2020-06-23 | Poweshiek | Iowa | 19157 | 97 | 8 |
262812 | 262812 | 2020-06-22 | Poweshiek | Iowa | 19157 | 97 | 8 |
259685 | 259685 | 2020-06-21 | Poweshiek | Iowa | 19157 | 96 | 8 |
256559 | 256559 | 2020-06-20 | Poweshiek | Iowa | 19157 | 95 | 8 |
253439 | 253439 | 2020-06-19 | Poweshiek | Iowa | 19157 | 95 | 8 |
250324 | 250324 | 2020-06-18 | Poweshiek | Iowa | 19157 | 95 | 8 |
247212 | 247212 | 2020-06-17 | Poweshiek | Iowa | 19157 | 95 | 8 |
244099 | 244099 | 2020-06-16 | Poweshiek | Iowa | 19157 | 95 | 8 |
240988 | 240988 | 2020-06-15 | Poweshiek | Iowa | 19157 | 95 | 8 |
237880 | 237880 | 2020-06-14 | Poweshiek | Iowa | 19157 | 95 | 8 |
234773 | 234773 | 2020-06-13 | Poweshiek | Iowa | 19157 | 95 | 8 |
231667 | 231667 | 2020-06-12 | Poweshiek | Iowa | 19157 | 95 | 8 |
228564 | 228564 | 2020-06-11 | Poweshiek | Iowa | 19157 | 95 | 8 |
225462 | 225462 | 2020-06-10 | Poweshiek | Iowa | 19157 | 95 | 8 |
222367 | 222367 | 2020-06-09 | Poweshiek | Iowa | 19157 | 94 | 8 |
219272 | 219272 | 2020-06-08 | Poweshiek | Iowa | 19157 | 94 | 8 |
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);