ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
768 rows where county = "Marion" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535278 | 535278 | 2020-09-15 | Marion | Iowa | 19125 | 674 | 3 |
532043 | 532043 | 2020-09-14 | Marion | Iowa | 19125 | 666 | 3 |
528806 | 528806 | 2020-09-13 | Marion | Iowa | 19125 | 660 | 3 |
525570 | 525570 | 2020-09-12 | Marion | Iowa | 19125 | 652 | 3 |
522334 | 522334 | 2020-09-11 | Marion | Iowa | 19125 | 643 | 3 |
519097 | 519097 | 2020-09-10 | Marion | Iowa | 19125 | 622 | 3 |
515862 | 515862 | 2020-09-09 | Marion | Iowa | 19125 | 610 | 3 |
512629 | 512629 | 2020-09-08 | Marion | Iowa | 19125 | 605 | 2 |
509396 | 509396 | 2020-09-07 | Marion | Iowa | 19125 | 597 | 2 |
506164 | 506164 | 2020-09-06 | Marion | Iowa | 19125 | 592 | 2 |
502930 | 502930 | 2020-09-05 | Marion | Iowa | 19125 | 578 | 2 |
499696 | 499696 | 2020-09-04 | Marion | Iowa | 19125 | 561 | 2 |
496463 | 496463 | 2020-09-03 | Marion | Iowa | 19125 | 540 | 2 |
493229 | 493229 | 2020-09-02 | Marion | Iowa | 19125 | 511 | 2 |
489996 | 489996 | 2020-09-01 | Marion | Iowa | 19125 | 490 | 1 |
486763 | 486763 | 2020-08-31 | Marion | Iowa | 19125 | 486 | 1 |
483528 | 483528 | 2020-08-30 | Marion | Iowa | 19125 | 475 | 0 |
480294 | 480294 | 2020-08-29 | Marion | Iowa | 19125 | 464 | 0 |
477061 | 477061 | 2020-08-28 | Marion | Iowa | 19125 | 456 | 0 |
473828 | 473828 | 2020-08-27 | Marion | Iowa | 19125 | 423 | 0 |
470596 | 470596 | 2020-08-26 | Marion | Iowa | 19125 | 377 | 0 |
467367 | 467367 | 2020-08-25 | Marion | Iowa | 19125 | 339 | 0 |
464138 | 464138 | 2020-08-24 | Marion | Iowa | 19125 | 325 | 0 |
460909 | 460909 | 2020-08-23 | Marion | Iowa | 19125 | 306 | 0 |
457682 | 457682 | 2020-08-22 | Marion | Iowa | 19125 | 290 | 0 |
454454 | 454454 | 2020-08-21 | Marion | Iowa | 19125 | 268 | 0 |
451226 | 451226 | 2020-08-20 | Marion | Iowa | 19125 | 247 | 0 |
447998 | 447998 | 2020-08-19 | Marion | Iowa | 19125 | 222 | 0 |
444771 | 444771 | 2020-08-18 | Marion | Iowa | 19125 | 217 | 0 |
441545 | 441545 | 2020-08-17 | Marion | Iowa | 19125 | 209 | 0 |
438319 | 438319 | 2020-08-16 | Marion | Iowa | 19125 | 209 | 0 |
435093 | 435093 | 2020-08-15 | Marion | Iowa | 19125 | 198 | 0 |
431868 | 431868 | 2020-08-14 | Marion | Iowa | 19125 | 193 | 0 |
428640 | 428640 | 2020-08-13 | Marion | Iowa | 19125 | 187 | 0 |
425416 | 425416 | 2020-08-12 | Marion | Iowa | 19125 | 177 | 0 |
422195 | 422195 | 2020-08-11 | Marion | Iowa | 19125 | 175 | 0 |
418972 | 418972 | 2020-08-10 | Marion | Iowa | 19125 | 174 | 0 |
415751 | 415751 | 2020-08-09 | Marion | Iowa | 19125 | 173 | 0 |
412531 | 412531 | 2020-08-08 | Marion | Iowa | 19125 | 169 | 0 |
409312 | 409312 | 2020-08-07 | Marion | Iowa | 19125 | 166 | 0 |
406092 | 406092 | 2020-08-06 | Marion | Iowa | 19125 | 162 | 0 |
402874 | 402874 | 2020-08-05 | Marion | Iowa | 19125 | 159 | 0 |
399658 | 399658 | 2020-08-04 | Marion | Iowa | 19125 | 155 | 0 |
396442 | 396442 | 2020-08-03 | Marion | Iowa | 19125 | 153 | 0 |
393226 | 393226 | 2020-08-02 | Marion | Iowa | 19125 | 152 | 0 |
390009 | 390009 | 2020-08-01 | Marion | Iowa | 19125 | 148 | 0 |
386792 | 386792 | 2020-07-31 | Marion | Iowa | 19125 | 147 | 0 |
383574 | 383574 | 2020-07-30 | Marion | Iowa | 19125 | 142 | 0 |
380357 | 380357 | 2020-07-29 | Marion | Iowa | 19125 | 141 | 0 |
377140 | 377140 | 2020-07-28 | Marion | Iowa | 19125 | 138 | 0 |
373925 | 373925 | 2020-07-27 | Marion | Iowa | 19125 | 137 | 0 |
370713 | 370713 | 2020-07-26 | Marion | Iowa | 19125 | 136 | 0 |
367503 | 367503 | 2020-07-25 | Marion | Iowa | 19125 | 129 | 0 |
364296 | 364296 | 2020-07-24 | Marion | Iowa | 19125 | 127 | 0 |
361089 | 361089 | 2020-07-23 | Marion | Iowa | 19125 | 113 | 0 |
357884 | 357884 | 2020-07-22 | Marion | Iowa | 19125 | 112 | 0 |
354682 | 354682 | 2020-07-21 | Marion | Iowa | 19125 | 110 | 0 |
351480 | 351480 | 2020-07-20 | Marion | Iowa | 19125 | 105 | 0 |
348280 | 348280 | 2020-07-19 | Marion | Iowa | 19125 | 101 | 0 |
345079 | 345079 | 2020-07-18 | Marion | Iowa | 19125 | 97 | 0 |
341879 | 341879 | 2020-07-17 | Marion | Iowa | 19125 | 97 | 0 |
338683 | 338683 | 2020-07-16 | Marion | Iowa | 19125 | 94 | 0 |
335487 | 335487 | 2020-07-15 | Marion | Iowa | 19125 | 87 | 0 |
332294 | 332294 | 2020-07-14 | Marion | Iowa | 19125 | 85 | 0 |
329107 | 329107 | 2020-07-13 | Marion | Iowa | 19125 | 84 | 0 |
325921 | 325921 | 2020-07-12 | Marion | Iowa | 19125 | 85 | 0 |
322740 | 322740 | 2020-07-11 | Marion | Iowa | 19125 | 80 | 0 |
319561 | 319561 | 2020-07-10 | Marion | Iowa | 19125 | 77 | 0 |
316388 | 316388 | 2020-07-09 | Marion | Iowa | 19125 | 75 | 0 |
313214 | 313214 | 2020-07-08 | Marion | Iowa | 19125 | 74 | 0 |
310044 | 310044 | 2020-07-07 | Marion | Iowa | 19125 | 71 | 0 |
306876 | 306876 | 2020-07-06 | Marion | Iowa | 19125 | 70 | 0 |
303711 | 303711 | 2020-07-05 | Marion | Iowa | 19125 | 70 | 0 |
300547 | 300547 | 2020-07-04 | Marion | Iowa | 19125 | 70 | 0 |
297385 | 297385 | 2020-07-03 | Marion | Iowa | 19125 | 68 | 0 |
294227 | 294227 | 2020-07-02 | Marion | Iowa | 19125 | 68 | 0 |
291073 | 291073 | 2020-07-01 | Marion | Iowa | 19125 | 67 | 0 |
287923 | 287923 | 2020-06-30 | Marion | Iowa | 19125 | 67 | 0 |
284774 | 284774 | 2020-06-29 | Marion | Iowa | 19125 | 64 | 0 |
281629 | 281629 | 2020-06-28 | Marion | Iowa | 19125 | 60 | 0 |
278481 | 278481 | 2020-06-27 | Marion | Iowa | 19125 | 58 | 0 |
275333 | 275333 | 2020-06-26 | Marion | Iowa | 19125 | 55 | 0 |
272191 | 272191 | 2020-06-25 | Marion | Iowa | 19125 | 52 | 0 |
269054 | 269054 | 2020-06-24 | Marion | Iowa | 19125 | 50 | 0 |
265924 | 265924 | 2020-06-23 | Marion | Iowa | 19125 | 48 | 0 |
262796 | 262796 | 2020-06-22 | Marion | Iowa | 19125 | 48 | 0 |
259669 | 259669 | 2020-06-21 | Marion | Iowa | 19125 | 46 | 0 |
256543 | 256543 | 2020-06-20 | Marion | Iowa | 19125 | 45 | 0 |
253423 | 253423 | 2020-06-19 | Marion | Iowa | 19125 | 45 | 0 |
250308 | 250308 | 2020-06-18 | Marion | Iowa | 19125 | 44 | 0 |
247196 | 247196 | 2020-06-17 | Marion | Iowa | 19125 | 41 | 0 |
244083 | 244083 | 2020-06-16 | Marion | Iowa | 19125 | 41 | 0 |
240972 | 240972 | 2020-06-15 | Marion | Iowa | 19125 | 42 | 0 |
237864 | 237864 | 2020-06-14 | Marion | Iowa | 19125 | 43 | 0 |
234757 | 234757 | 2020-06-13 | Marion | Iowa | 19125 | 43 | 0 |
231651 | 231651 | 2020-06-12 | Marion | Iowa | 19125 | 40 | 0 |
228548 | 228548 | 2020-06-11 | Marion | Iowa | 19125 | 39 | 0 |
225446 | 225446 | 2020-06-10 | Marion | Iowa | 19125 | 38 | 0 |
222351 | 222351 | 2020-06-09 | Marion | Iowa | 19125 | 37 | 0 |
219256 | 219256 | 2020-06-08 | Marion | Iowa | 19125 | 36 | 0 |
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);