ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Wapello" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
291101 | 291101 | 2020-07-01 | Wapello | Iowa | 19179 | 701 | 30 |
294255 | 294255 | 2020-07-02 | Wapello | Iowa | 19179 | 702 | 30 |
297413 | 297413 | 2020-07-03 | Wapello | Iowa | 19179 | 705 | 30 |
300575 | 300575 | 2020-07-04 | Wapello | Iowa | 19179 | 707 | 30 |
303739 | 303739 | 2020-07-05 | Wapello | Iowa | 19179 | 708 | 30 |
306904 | 306904 | 2020-07-06 | Wapello | Iowa | 19179 | 708 | 30 |
310072 | 310072 | 2020-07-07 | Wapello | Iowa | 19179 | 708 | 30 |
313242 | 313242 | 2020-07-08 | Wapello | Iowa | 19179 | 712 | 31 |
316416 | 316416 | 2020-07-09 | Wapello | Iowa | 19179 | 712 | 31 |
319589 | 319589 | 2020-07-10 | Wapello | Iowa | 19179 | 714 | 31 |
322768 | 322768 | 2020-07-11 | Wapello | Iowa | 19179 | 714 | 31 |
325949 | 325949 | 2020-07-12 | Wapello | Iowa | 19179 | 715 | 31 |
329135 | 329135 | 2020-07-13 | Wapello | Iowa | 19179 | 716 | 31 |
332322 | 332322 | 2020-07-14 | Wapello | Iowa | 19179 | 715 | 31 |
335515 | 335515 | 2020-07-15 | Wapello | Iowa | 19179 | 717 | 31 |
338711 | 338711 | 2020-07-16 | Wapello | Iowa | 19179 | 726 | 31 |
341907 | 341907 | 2020-07-17 | Wapello | Iowa | 19179 | 726 | 31 |
345107 | 345107 | 2020-07-18 | Wapello | Iowa | 19179 | 731 | 31 |
348308 | 348308 | 2020-07-19 | Wapello | Iowa | 19179 | 738 | 31 |
351508 | 351508 | 2020-07-20 | Wapello | Iowa | 19179 | 746 | 31 |
354710 | 354710 | 2020-07-21 | Wapello | Iowa | 19179 | 757 | 31 |
357912 | 357912 | 2020-07-22 | Wapello | Iowa | 19179 | 769 | 31 |
361117 | 361117 | 2020-07-23 | Wapello | Iowa | 19179 | 773 | 31 |
364324 | 364324 | 2020-07-24 | Wapello | Iowa | 19179 | 777 | 31 |
367531 | 367531 | 2020-07-25 | Wapello | Iowa | 19179 | 781 | 31 |
370741 | 370741 | 2020-07-26 | Wapello | Iowa | 19179 | 788 | 31 |
373953 | 373953 | 2020-07-27 | Wapello | Iowa | 19179 | 796 | 31 |
377168 | 377168 | 2020-07-28 | Wapello | Iowa | 19179 | 808 | 31 |
380385 | 380385 | 2020-07-29 | Wapello | Iowa | 19179 | 812 | 31 |
383602 | 383602 | 2020-07-30 | Wapello | Iowa | 19179 | 821 | 31 |
386820 | 386820 | 2020-07-31 | Wapello | Iowa | 19179 | 827 | 31 |
390037 | 390037 | 2020-08-01 | Wapello | Iowa | 19179 | 829 | 31 |
393254 | 393254 | 2020-08-02 | Wapello | Iowa | 19179 | 845 | 31 |
396470 | 396470 | 2020-08-03 | Wapello | Iowa | 19179 | 849 | 32 |
399685 | 399685 | 2020-08-04 | Wapello | Iowa | 19179 | 850 | 32 |
402902 | 402902 | 2020-08-05 | Wapello | Iowa | 19179 | 866 | 33 |
406120 | 406120 | 2020-08-06 | Wapello | Iowa | 19179 | 872 | 33 |
409339 | 409339 | 2020-08-07 | Wapello | Iowa | 19179 | 876 | 33 |
412559 | 412559 | 2020-08-08 | Wapello | Iowa | 19179 | 880 | 33 |
415779 | 415779 | 2020-08-09 | Wapello | Iowa | 19179 | 900 | 33 |
419000 | 419000 | 2020-08-10 | Wapello | Iowa | 19179 | 904 | 33 |
422223 | 422223 | 2020-08-11 | Wapello | Iowa | 19179 | 905 | 33 |
425444 | 425444 | 2020-08-12 | Wapello | Iowa | 19179 | 927 | 33 |
428668 | 428668 | 2020-08-13 | Wapello | Iowa | 19179 | 936 | 36 |
431896 | 431896 | 2020-08-14 | Wapello | Iowa | 19179 | 943 | 36 |
435121 | 435121 | 2020-08-15 | Wapello | Iowa | 19179 | 947 | 37 |
438346 | 438346 | 2020-08-16 | Wapello | Iowa | 19179 | 955 | 37 |
441573 | 441573 | 2020-08-17 | Wapello | Iowa | 19179 | 959 | 38 |
444799 | 444799 | 2020-08-18 | Wapello | Iowa | 19179 | 968 | 38 |
448026 | 448026 | 2020-08-19 | Wapello | Iowa | 19179 | 970 | 39 |
451254 | 451254 | 2020-08-20 | Wapello | Iowa | 19179 | 982 | 39 |
454482 | 454482 | 2020-08-21 | Wapello | Iowa | 19179 | 991 | 43 |
457710 | 457710 | 2020-08-22 | Wapello | Iowa | 19179 | 1000 | 43 |
460937 | 460937 | 2020-08-23 | Wapello | Iowa | 19179 | 1007 | 43 |
464166 | 464166 | 2020-08-24 | Wapello | Iowa | 19179 | 1021 | 45 |
467395 | 467395 | 2020-08-25 | Wapello | Iowa | 19179 | 1030 | 45 |
470624 | 470624 | 2020-08-26 | Wapello | Iowa | 19179 | 1042 | 46 |
473856 | 473856 | 2020-08-27 | Wapello | Iowa | 19179 | 1053 | 48 |
477089 | 477089 | 2020-08-28 | Wapello | Iowa | 19179 | 1067 | 49 |
480322 | 480322 | 2020-08-29 | Wapello | Iowa | 19179 | 1071 | 49 |
483556 | 483556 | 2020-08-30 | Wapello | Iowa | 19179 | 1082 | 49 |
486791 | 486791 | 2020-08-31 | Wapello | Iowa | 19179 | 1087 | 50 |
490024 | 490024 | 2020-09-01 | Wapello | Iowa | 19179 | 1089 | 51 |
493257 | 493257 | 2020-09-02 | Wapello | Iowa | 19179 | 1096 | 51 |
496491 | 496491 | 2020-09-03 | Wapello | Iowa | 19179 | 1105 | 51 |
499724 | 499724 | 2020-09-04 | Wapello | Iowa | 19179 | 1117 | 54 |
502958 | 502958 | 2020-09-05 | Wapello | Iowa | 19179 | 1124 | 54 |
506192 | 506192 | 2020-09-06 | Wapello | Iowa | 19179 | 1128 | 54 |
509424 | 509424 | 2020-09-07 | Wapello | Iowa | 19179 | 1134 | 54 |
512657 | 512657 | 2020-09-08 | Wapello | Iowa | 19179 | 1149 | 55 |
515890 | 515890 | 2020-09-09 | Wapello | Iowa | 19179 | 1149 | 56 |
519125 | 519125 | 2020-09-10 | Wapello | Iowa | 19179 | 1162 | 56 |
522362 | 522362 | 2020-09-11 | Wapello | Iowa | 19179 | 1176 | 56 |
525598 | 525598 | 2020-09-12 | Wapello | Iowa | 19179 | 1184 | 56 |
528834 | 528834 | 2020-09-13 | Wapello | Iowa | 19179 | 1193 | 56 |
532071 | 532071 | 2020-09-14 | Wapello | Iowa | 19179 | 1199 | 57 |
535306 | 535306 | 2020-09-15 | Wapello | Iowa | 19179 | 1200 | 57 |
538542 | 538542 | 2020-09-16 | Wapello | Iowa | 19179 | 1216 | 57 |
541779 | 541779 | 2020-09-17 | Wapello | Iowa | 19179 | 1223 | 57 |
545015 | 545015 | 2020-09-18 | Wapello | Iowa | 19179 | 1243 | 57 |
548253 | 548253 | 2020-09-19 | Wapello | Iowa | 19179 | 1257 | 57 |
551492 | 551492 | 2020-09-20 | Wapello | Iowa | 19179 | 1267 | 57 |
554731 | 554731 | 2020-09-21 | Wapello | Iowa | 19179 | 1270 | 57 |
557968 | 557968 | 2020-09-22 | Wapello | Iowa | 19179 | 1281 | 57 |
561204 | 561204 | 2020-09-23 | Wapello | Iowa | 19179 | 1296 | 57 |
564444 | 564444 | 2020-09-24 | Wapello | Iowa | 19179 | 1314 | 57 |
567684 | 567684 | 2020-09-25 | Wapello | Iowa | 19179 | 1328 | 57 |
570926 | 570926 | 2020-09-26 | Wapello | Iowa | 19179 | 1333 | 57 |
574169 | 574169 | 2020-09-27 | Wapello | Iowa | 19179 | 1334 | 57 |
577411 | 577411 | 2020-09-28 | Wapello | Iowa | 19179 | 1339 | 57 |
580652 | 580652 | 2020-09-29 | Wapello | Iowa | 19179 | 1340 | 57 |
583891 | 583891 | 2020-09-30 | Wapello | Iowa | 19179 | 1346 | 57 |
587131 | 587131 | 2020-10-01 | Wapello | Iowa | 19179 | 1363 | 57 |
590372 | 590372 | 2020-10-02 | Wapello | Iowa | 19179 | 1371 | 57 |
593613 | 593613 | 2020-10-03 | Wapello | Iowa | 19179 | 1375 | 57 |
596855 | 596855 | 2020-10-04 | Wapello | Iowa | 19179 | 1384 | 57 |
600097 | 600097 | 2020-10-05 | Wapello | Iowa | 19179 | 1389 | 57 |
603340 | 603340 | 2020-10-06 | Wapello | Iowa | 19179 | 1393 | 58 |
606582 | 606582 | 2020-10-07 | Wapello | Iowa | 19179 | 1401 | 58 |
609825 | 609825 | 2020-10-08 | Wapello | Iowa | 19179 | 1405 | 58 |
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);