ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Jasper" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054350 | 1054350 | 2021-02-22 | Jasper | Iowa | 19099 | 3692 | 65 |
1051103 | 1051103 | 2021-02-21 | Jasper | Iowa | 19099 | 3692 | 65 |
1047856 | 1047856 | 2021-02-20 | Jasper | Iowa | 19099 | 3692 | 65 |
1044611 | 1044611 | 2021-02-19 | Jasper | Iowa | 19099 | 3692 | 65 |
1041366 | 1041366 | 2021-02-18 | Jasper | Iowa | 19099 | 3668 | 65 |
1038121 | 1038121 | 2021-02-17 | Jasper | Iowa | 19099 | 3659 | 65 |
1034876 | 1034876 | 2021-02-16 | Jasper | Iowa | 19099 | 3647 | 65 |
1031630 | 1031630 | 2021-02-15 | Jasper | Iowa | 19099 | 3624 | 65 |
1028383 | 1028383 | 2021-02-14 | Jasper | Iowa | 19099 | 3570 | 65 |
1025138 | 1025138 | 2021-02-13 | Jasper | Iowa | 19099 | 3560 | 65 |
1021893 | 1021893 | 2021-02-12 | Jasper | Iowa | 19099 | 3558 | 65 |
1018648 | 1018648 | 2021-02-11 | Jasper | Iowa | 19099 | 3540 | 65 |
1015403 | 1015403 | 2021-02-10 | Jasper | Iowa | 19099 | 3530 | 65 |
1012158 | 1012158 | 2021-02-09 | Jasper | Iowa | 19099 | 3486 | 64 |
1008912 | 1008912 | 2021-02-08 | Jasper | Iowa | 19099 | 3474 | 64 |
1005666 | 1005666 | 2021-02-07 | Jasper | Iowa | 19099 | 3464 | 64 |
1002420 | 1002420 | 2021-02-06 | Jasper | Iowa | 19099 | 3455 | 64 |
999174 | 999174 | 2021-02-05 | Jasper | Iowa | 19099 | 3450 | 64 |
995928 | 995928 | 2021-02-04 | Jasper | Iowa | 19099 | 3438 | 63 |
992682 | 992682 | 2021-02-03 | Jasper | Iowa | 19099 | 3428 | 63 |
989436 | 989436 | 2021-02-02 | Jasper | Iowa | 19099 | 3424 | 63 |
986189 | 986189 | 2021-02-01 | Jasper | Iowa | 19099 | 3409 | 63 |
982942 | 982942 | 2021-01-31 | Jasper | Iowa | 19099 | 3405 | 63 |
979696 | 979696 | 2021-01-30 | Jasper | Iowa | 19099 | 3397 | 63 |
976450 | 976450 | 2021-01-29 | Jasper | Iowa | 19099 | 3381 | 61 |
973205 | 973205 | 2021-01-28 | Jasper | Iowa | 19099 | 3374 | 61 |
969960 | 969960 | 2021-01-27 | Jasper | Iowa | 19099 | 3358 | 59 |
966716 | 966716 | 2021-01-26 | Jasper | Iowa | 19099 | 3351 | 59 |
963471 | 963471 | 2021-01-25 | Jasper | Iowa | 19099 | 3333 | 59 |
960226 | 960226 | 2021-01-24 | Jasper | Iowa | 19099 | 3328 | 59 |
956980 | 956980 | 2021-01-23 | Jasper | Iowa | 19099 | 3316 | 59 |
953735 | 953735 | 2021-01-22 | Jasper | Iowa | 19099 | 3301 | 59 |
950490 | 950490 | 2021-01-21 | Jasper | Iowa | 19099 | 3285 | 59 |
947244 | 947244 | 2021-01-20 | Jasper | Iowa | 19099 | 3240 | 59 |
943997 | 943997 | 2021-01-19 | Jasper | Iowa | 19099 | 3219 | 59 |
940752 | 940752 | 2021-01-18 | Jasper | Iowa | 19099 | 3212 | 58 |
937507 | 937507 | 2021-01-17 | Jasper | Iowa | 19099 | 3204 | 58 |
934262 | 934262 | 2021-01-16 | Jasper | Iowa | 19099 | 3196 | 58 |
931017 | 931017 | 2021-01-15 | Jasper | Iowa | 19099 | 3178 | 55 |
927772 | 927772 | 2021-01-14 | Jasper | Iowa | 19099 | 3159 | 55 |
924526 | 924526 | 2021-01-13 | Jasper | Iowa | 19099 | 3140 | 55 |
921281 | 921281 | 2021-01-12 | Jasper | Iowa | 19099 | 3093 | 55 |
918036 | 918036 | 2021-01-11 | Jasper | Iowa | 19099 | 3074 | 55 |
914791 | 914791 | 2021-01-10 | Jasper | Iowa | 19099 | 3063 | 55 |
911546 | 911546 | 2021-01-09 | Jasper | Iowa | 19099 | 3049 | 55 |
908301 | 908301 | 2021-01-08 | Jasper | Iowa | 19099 | 3027 | 55 |
905055 | 905055 | 2021-01-07 | Jasper | Iowa | 19099 | 3013 | 55 |
901810 | 901810 | 2021-01-06 | Jasper | Iowa | 19099 | 2994 | 55 |
898565 | 898565 | 2021-01-05 | Jasper | Iowa | 19099 | 2959 | 54 |
895320 | 895320 | 2021-01-04 | Jasper | Iowa | 19099 | 2944 | 54 |
892073 | 892073 | 2021-01-03 | Jasper | Iowa | 19099 | 2930 | 54 |
888827 | 888827 | 2021-01-02 | Jasper | Iowa | 19099 | 2919 | 54 |
885581 | 885581 | 2021-01-01 | Jasper | Iowa | 19099 | 2914 | 53 |
882336 | 882336 | 2020-12-31 | Jasper | Iowa | 19099 | 2867 | 53 |
879091 | 879091 | 2020-12-30 | Jasper | Iowa | 19099 | 2847 | 53 |
875846 | 875846 | 2020-12-29 | Jasper | Iowa | 19099 | 2841 | 53 |
872601 | 872601 | 2020-12-28 | Jasper | Iowa | 19099 | 2833 | 52 |
869356 | 869356 | 2020-12-27 | Jasper | Iowa | 19099 | 2817 | 52 |
866111 | 866111 | 2020-12-26 | Jasper | Iowa | 19099 | 2813 | 52 |
862866 | 862866 | 2020-12-25 | Jasper | Iowa | 19099 | 2808 | 52 |
859621 | 859621 | 2020-12-24 | Jasper | Iowa | 19099 | 2803 | 52 |
856376 | 856376 | 2020-12-23 | Jasper | Iowa | 19099 | 2762 | 51 |
853131 | 853131 | 2020-12-22 | Jasper | Iowa | 19099 | 2740 | 51 |
849886 | 849886 | 2020-12-21 | Jasper | Iowa | 19099 | 2700 | 50 |
846641 | 846641 | 2020-12-20 | Jasper | Iowa | 19099 | 2679 | 50 |
843395 | 843395 | 2020-12-19 | Jasper | Iowa | 19099 | 2673 | 50 |
840150 | 840150 | 2020-12-18 | Jasper | Iowa | 19099 | 2647 | 50 |
836905 | 836905 | 2020-12-17 | Jasper | Iowa | 19099 | 2617 | 50 |
833659 | 833659 | 2020-12-16 | Jasper | Iowa | 19099 | 2611 | 48 |
830412 | 830412 | 2020-12-15 | Jasper | Iowa | 19099 | 2578 | 48 |
827166 | 827166 | 2020-12-14 | Jasper | Iowa | 19099 | 2544 | 48 |
823919 | 823919 | 2020-12-13 | Jasper | Iowa | 19099 | 2533 | 48 |
820673 | 820673 | 2020-12-12 | Jasper | Iowa | 19099 | 2494 | 48 |
817427 | 817427 | 2020-12-11 | Jasper | Iowa | 19099 | 2480 | 48 |
814181 | 814181 | 2020-12-10 | Jasper | Iowa | 19099 | 2430 | 48 |
810936 | 810936 | 2020-12-09 | Jasper | Iowa | 19099 | 2411 | 48 |
807691 | 807691 | 2020-12-08 | Jasper | Iowa | 19099 | 2395 | 44 |
804446 | 804446 | 2020-12-07 | Jasper | Iowa | 19099 | 2395 | 47 |
801201 | 801201 | 2020-12-06 | Jasper | Iowa | 19099 | 2382 | 47 |
797956 | 797956 | 2020-12-05 | Jasper | Iowa | 19099 | 2365 | 46 |
794711 | 794711 | 2020-12-04 | Jasper | Iowa | 19099 | 2333 | 46 |
791466 | 791466 | 2020-12-03 | Jasper | Iowa | 19099 | 2315 | 46 |
788221 | 788221 | 2020-12-02 | Jasper | Iowa | 19099 | 2297 | 46 |
784977 | 784977 | 2020-12-01 | Jasper | Iowa | 19099 | 2267 | 44 |
781732 | 781732 | 2020-11-30 | Jasper | Iowa | 19099 | 2243 | 44 |
778486 | 778486 | 2020-11-29 | Jasper | Iowa | 19099 | 2179 | 44 |
775241 | 775241 | 2020-11-28 | Jasper | Iowa | 19099 | 2174 | 43 |
771996 | 771996 | 2020-11-27 | Jasper | Iowa | 19099 | 2146 | 43 |
768751 | 768751 | 2020-11-26 | Jasper | Iowa | 19099 | 2124 | 43 |
765505 | 765505 | 2020-11-25 | Jasper | Iowa | 19099 | 2109 | 42 |
762260 | 762260 | 2020-11-24 | Jasper | Iowa | 19099 | 2084 | 40 |
759015 | 759015 | 2020-11-23 | Jasper | Iowa | 19099 | 2066 | 39 |
755768 | 755768 | 2020-11-22 | Jasper | Iowa | 19099 | 2027 | 39 |
752522 | 752522 | 2020-11-21 | Jasper | Iowa | 19099 | 1998 | 39 |
749276 | 749276 | 2020-11-20 | Jasper | Iowa | 19099 | 1981 | 39 |
746030 | 746030 | 2020-11-19 | Jasper | Iowa | 19099 | 1958 | 39 |
742783 | 742783 | 2020-11-18 | Jasper | Iowa | 19099 | 1919 | 37 |
739536 | 739536 | 2020-11-17 | Jasper | Iowa | 19099 | 1876 | 36 |
736292 | 736292 | 2020-11-16 | Jasper | Iowa | 19099 | 1854 | 36 |
733046 | 733046 | 2020-11-15 | Jasper | Iowa | 19099 | 1829 | 36 |
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);