ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Muscatine" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054370 | 1054370 | 2021-02-22 | Muscatine | Iowa | 19139 | 4138 | 88 |
1051123 | 1051123 | 2021-02-21 | Muscatine | Iowa | 19139 | 4138 | 88 |
1047876 | 1047876 | 2021-02-20 | Muscatine | Iowa | 19139 | 4138 | 88 |
1044631 | 1044631 | 2021-02-19 | Muscatine | Iowa | 19139 | 4138 | 88 |
1041386 | 1041386 | 2021-02-18 | Muscatine | Iowa | 19139 | 4134 | 88 |
1038141 | 1038141 | 2021-02-17 | Muscatine | Iowa | 19139 | 4126 | 87 |
1034896 | 1034896 | 2021-02-16 | Muscatine | Iowa | 19139 | 4118 | 87 |
1031650 | 1031650 | 2021-02-15 | Muscatine | Iowa | 19139 | 4107 | 87 |
1028403 | 1028403 | 2021-02-14 | Muscatine | Iowa | 19139 | 4097 | 87 |
1025158 | 1025158 | 2021-02-13 | Muscatine | Iowa | 19139 | 4093 | 87 |
1021913 | 1021913 | 2021-02-12 | Muscatine | Iowa | 19139 | 4089 | 87 |
1018668 | 1018668 | 2021-02-11 | Muscatine | Iowa | 19139 | 4073 | 87 |
1015423 | 1015423 | 2021-02-10 | Muscatine | Iowa | 19139 | 4072 | 87 |
1012178 | 1012178 | 2021-02-09 | Muscatine | Iowa | 19139 | 4057 | 85 |
1008932 | 1008932 | 2021-02-08 | Muscatine | Iowa | 19139 | 4050 | 85 |
1005686 | 1005686 | 2021-02-07 | Muscatine | Iowa | 19139 | 4046 | 85 |
1002440 | 1002440 | 2021-02-06 | Muscatine | Iowa | 19139 | 4043 | 85 |
999194 | 999194 | 2021-02-05 | Muscatine | Iowa | 19139 | 4042 | 85 |
995948 | 995948 | 2021-02-04 | Muscatine | Iowa | 19139 | 4037 | 84 |
992702 | 992702 | 2021-02-03 | Muscatine | Iowa | 19139 | 4028 | 83 |
989456 | 989456 | 2021-02-02 | Muscatine | Iowa | 19139 | 4019 | 83 |
986209 | 986209 | 2021-02-01 | Muscatine | Iowa | 19139 | 4015 | 83 |
982962 | 982962 | 2021-01-31 | Muscatine | Iowa | 19139 | 4012 | 83 |
979716 | 979716 | 2021-01-30 | Muscatine | Iowa | 19139 | 4005 | 81 |
976470 | 976470 | 2021-01-29 | Muscatine | Iowa | 19139 | 3993 | 81 |
973225 | 973225 | 2021-01-28 | Muscatine | Iowa | 19139 | 3987 | 81 |
969980 | 969980 | 2021-01-27 | Muscatine | Iowa | 19139 | 3980 | 79 |
966736 | 966736 | 2021-01-26 | Muscatine | Iowa | 19139 | 3973 | 79 |
963491 | 963491 | 2021-01-25 | Muscatine | Iowa | 19139 | 3965 | 78 |
960246 | 960246 | 2021-01-24 | Muscatine | Iowa | 19139 | 3961 | 78 |
957000 | 957000 | 2021-01-23 | Muscatine | Iowa | 19139 | 3958 | 78 |
953755 | 953755 | 2021-01-22 | Muscatine | Iowa | 19139 | 3949 | 78 |
950510 | 950510 | 2021-01-21 | Muscatine | Iowa | 19139 | 3930 | 78 |
947264 | 947264 | 2021-01-20 | Muscatine | Iowa | 19139 | 3922 | 78 |
944017 | 944017 | 2021-01-19 | Muscatine | Iowa | 19139 | 3904 | 77 |
940772 | 940772 | 2021-01-18 | Muscatine | Iowa | 19139 | 3884 | 77 |
937527 | 937527 | 2021-01-17 | Muscatine | Iowa | 19139 | 3867 | 77 |
934282 | 934282 | 2021-01-16 | Muscatine | Iowa | 19139 | 3861 | 77 |
931037 | 931037 | 2021-01-15 | Muscatine | Iowa | 19139 | 3843 | 75 |
927792 | 927792 | 2021-01-14 | Muscatine | Iowa | 19139 | 3822 | 75 |
924546 | 924546 | 2021-01-13 | Muscatine | Iowa | 19139 | 3805 | 75 |
921301 | 921301 | 2021-01-12 | Muscatine | Iowa | 19139 | 3785 | 75 |
918056 | 918056 | 2021-01-11 | Muscatine | Iowa | 19139 | 3766 | 75 |
914811 | 914811 | 2021-01-10 | Muscatine | Iowa | 19139 | 3751 | 75 |
911566 | 911566 | 2021-01-09 | Muscatine | Iowa | 19139 | 3741 | 75 |
908321 | 908321 | 2021-01-08 | Muscatine | Iowa | 19139 | 3725 | 75 |
905075 | 905075 | 2021-01-07 | Muscatine | Iowa | 19139 | 3703 | 75 |
901830 | 901830 | 2021-01-06 | Muscatine | Iowa | 19139 | 3678 | 75 |
898585 | 898585 | 2021-01-05 | Muscatine | Iowa | 19139 | 3651 | 75 |
895340 | 895340 | 2021-01-04 | Muscatine | Iowa | 19139 | 3624 | 75 |
892093 | 892093 | 2021-01-03 | Muscatine | Iowa | 19139 | 3611 | 75 |
888847 | 888847 | 2021-01-02 | Muscatine | Iowa | 19139 | 3597 | 75 |
885601 | 885601 | 2021-01-01 | Muscatine | Iowa | 19139 | 3584 | 75 |
882356 | 882356 | 2020-12-31 | Muscatine | Iowa | 19139 | 3574 | 75 |
879111 | 879111 | 2020-12-30 | Muscatine | Iowa | 19139 | 3557 | 75 |
875866 | 875866 | 2020-12-29 | Muscatine | Iowa | 19139 | 3525 | 75 |
872621 | 872621 | 2020-12-28 | Muscatine | Iowa | 19139 | 3502 | 73 |
869376 | 869376 | 2020-12-27 | Muscatine | Iowa | 19139 | 3488 | 73 |
866131 | 866131 | 2020-12-26 | Muscatine | Iowa | 19139 | 3481 | 73 |
862886 | 862886 | 2020-12-25 | Muscatine | Iowa | 19139 | 3477 | 73 |
859641 | 859641 | 2020-12-24 | Muscatine | Iowa | 19139 | 3471 | 73 |
856396 | 856396 | 2020-12-23 | Muscatine | Iowa | 19139 | 3456 | 73 |
853151 | 853151 | 2020-12-22 | Muscatine | Iowa | 19139 | 3440 | 72 |
849906 | 849906 | 2020-12-21 | Muscatine | Iowa | 19139 | 3428 | 72 |
846661 | 846661 | 2020-12-20 | Muscatine | Iowa | 19139 | 3408 | 72 |
843415 | 843415 | 2020-12-19 | Muscatine | Iowa | 19139 | 3407 | 71 |
840170 | 840170 | 2020-12-18 | Muscatine | Iowa | 19139 | 3384 | 69 |
836925 | 836925 | 2020-12-17 | Muscatine | Iowa | 19139 | 3360 | 69 |
833679 | 833679 | 2020-12-16 | Muscatine | Iowa | 19139 | 3343 | 67 |
830432 | 830432 | 2020-12-15 | Muscatine | Iowa | 19139 | 3325 | 66 |
827186 | 827186 | 2020-12-14 | Muscatine | Iowa | 19139 | 3308 | 63 |
823939 | 823939 | 2020-12-13 | Muscatine | Iowa | 19139 | 3296 | 63 |
820693 | 820693 | 2020-12-12 | Muscatine | Iowa | 19139 | 3286 | 63 |
817447 | 817447 | 2020-12-11 | Muscatine | Iowa | 19139 | 3269 | 63 |
814201 | 814201 | 2020-12-10 | Muscatine | Iowa | 19139 | 3248 | 63 |
810956 | 810956 | 2020-12-09 | Muscatine | Iowa | 19139 | 3224 | 62 |
807711 | 807711 | 2020-12-08 | Muscatine | Iowa | 19139 | 3192 | 59 |
804466 | 804466 | 2020-12-07 | Muscatine | Iowa | 19139 | 3189 | 74 |
801221 | 801221 | 2020-12-06 | Muscatine | Iowa | 19139 | 3159 | 73 |
797976 | 797976 | 2020-12-05 | Muscatine | Iowa | 19139 | 3137 | 72 |
794731 | 794731 | 2020-12-04 | Muscatine | Iowa | 19139 | 3116 | 72 |
791486 | 791486 | 2020-12-03 | Muscatine | Iowa | 19139 | 3051 | 72 |
788241 | 788241 | 2020-12-02 | Muscatine | Iowa | 19139 | 2982 | 71 |
784997 | 784997 | 2020-12-01 | Muscatine | Iowa | 19139 | 2962 | 69 |
781752 | 781752 | 2020-11-30 | Muscatine | Iowa | 19139 | 2934 | 69 |
778506 | 778506 | 2020-11-29 | Muscatine | Iowa | 19139 | 2892 | 68 |
775261 | 775261 | 2020-11-28 | Muscatine | Iowa | 19139 | 2864 | 68 |
772016 | 772016 | 2020-11-27 | Muscatine | Iowa | 19139 | 2826 | 68 |
768771 | 768771 | 2020-11-26 | Muscatine | Iowa | 19139 | 2809 | 68 |
765525 | 765525 | 2020-11-25 | Muscatine | Iowa | 19139 | 2782 | 68 |
762280 | 762280 | 2020-11-24 | Muscatine | Iowa | 19139 | 2739 | 68 |
759035 | 759035 | 2020-11-23 | Muscatine | Iowa | 19139 | 2703 | 66 |
755788 | 755788 | 2020-11-22 | Muscatine | Iowa | 19139 | 2669 | 64 |
752542 | 752542 | 2020-11-21 | Muscatine | Iowa | 19139 | 2631 | 64 |
749296 | 749296 | 2020-11-20 | Muscatine | Iowa | 19139 | 2575 | 64 |
746050 | 746050 | 2020-11-19 | Muscatine | Iowa | 19139 | 2528 | 63 |
742803 | 742803 | 2020-11-18 | Muscatine | Iowa | 19139 | 2469 | 62 |
739556 | 739556 | 2020-11-17 | Muscatine | Iowa | 19139 | 2409 | 62 |
736312 | 736312 | 2020-11-16 | Muscatine | Iowa | 19139 | 2341 | 61 |
733066 | 733066 | 2020-11-15 | Muscatine | Iowa | 19139 | 2291 | 61 |
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);