ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Marshall" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054258 | 1054258 | 2021-02-22 | Marshall | Indiana | 18099 | 5387 | 105 |
1051011 | 1051011 | 2021-02-21 | Marshall | Indiana | 18099 | 5383 | 105 |
1047764 | 1047764 | 2021-02-20 | Marshall | Indiana | 18099 | 5376 | 105 |
1044519 | 1044519 | 2021-02-19 | Marshall | Indiana | 18099 | 5370 | 105 |
1041274 | 1041274 | 2021-02-18 | Marshall | Indiana | 18099 | 5367 | 105 |
1038029 | 1038029 | 2021-02-17 | Marshall | Indiana | 18099 | 5367 | 104 |
1034784 | 1034784 | 2021-02-16 | Marshall | Indiana | 18099 | 5355 | 104 |
1031538 | 1031538 | 2021-02-15 | Marshall | Indiana | 18099 | 5354 | 104 |
1028291 | 1028291 | 2021-02-14 | Marshall | Indiana | 18099 | 5352 | 104 |
1025046 | 1025046 | 2021-02-13 | Marshall | Indiana | 18099 | 5347 | 104 |
1021801 | 1021801 | 2021-02-12 | Marshall | Indiana | 18099 | 5341 | 104 |
1018556 | 1018556 | 2021-02-11 | Marshall | Indiana | 18099 | 5328 | 104 |
1015311 | 1015311 | 2021-02-10 | Marshall | Indiana | 18099 | 5316 | 102 |
1012066 | 1012066 | 2021-02-09 | Marshall | Indiana | 18099 | 5306 | 100 |
1008820 | 1008820 | 2021-02-08 | Marshall | Indiana | 18099 | 5300 | 99 |
1005574 | 1005574 | 2021-02-07 | Marshall | Indiana | 18099 | 5293 | 97 |
1002328 | 1002328 | 2021-02-06 | Marshall | Indiana | 18099 | 5270 | 97 |
999082 | 999082 | 2021-02-05 | Marshall | Indiana | 18099 | 5251 | 97 |
995836 | 995836 | 2021-02-04 | Marshall | Indiana | 18099 | 5228 | 97 |
992590 | 992590 | 2021-02-03 | Marshall | Indiana | 18099 | 5211 | 84 |
989344 | 989344 | 2021-02-02 | Marshall | Indiana | 18099 | 5195 | 84 |
986097 | 986097 | 2021-02-01 | Marshall | Indiana | 18099 | 5187 | 84 |
982850 | 982850 | 2021-01-31 | Marshall | Indiana | 18099 | 5172 | 84 |
979604 | 979604 | 2021-01-30 | Marshall | Indiana | 18099 | 5165 | 84 |
976358 | 976358 | 2021-01-29 | Marshall | Indiana | 18099 | 5138 | 84 |
973113 | 973113 | 2021-01-28 | Marshall | Indiana | 18099 | 5123 | 84 |
969868 | 969868 | 2021-01-27 | Marshall | Indiana | 18099 | 5098 | 84 |
966624 | 966624 | 2021-01-26 | Marshall | Indiana | 18099 | 5080 | 84 |
963379 | 963379 | 2021-01-25 | Marshall | Indiana | 18099 | 5071 | 84 |
960134 | 960134 | 2021-01-24 | Marshall | Indiana | 18099 | 5055 | 84 |
956888 | 956888 | 2021-01-23 | Marshall | Indiana | 18099 | 5041 | 84 |
953643 | 953643 | 2021-01-22 | Marshall | Indiana | 18099 | 5028 | 84 |
950398 | 950398 | 2021-01-21 | Marshall | Indiana | 18099 | 5000 | 84 |
947152 | 947152 | 2021-01-20 | Marshall | Indiana | 18099 | 4979 | 84 |
943905 | 943905 | 2021-01-19 | Marshall | Indiana | 18099 | 4955 | 84 |
940660 | 940660 | 2021-01-18 | Marshall | Indiana | 18099 | 4951 | 84 |
937415 | 937415 | 2021-01-17 | Marshall | Indiana | 18099 | 4943 | 84 |
934170 | 934170 | 2021-01-16 | Marshall | Indiana | 18099 | 4926 | 84 |
930925 | 930925 | 2021-01-15 | Marshall | Indiana | 18099 | 4907 | 84 |
927680 | 927680 | 2021-01-14 | Marshall | Indiana | 18099 | 4872 | 84 |
924434 | 924434 | 2021-01-13 | Marshall | Indiana | 18099 | 4850 | 84 |
921189 | 921189 | 2021-01-12 | Marshall | Indiana | 18099 | 4819 | 84 |
917944 | 917944 | 2021-01-11 | Marshall | Indiana | 18099 | 4806 | 84 |
914699 | 914699 | 2021-01-10 | Marshall | Indiana | 18099 | 4791 | 84 |
911454 | 911454 | 2021-01-09 | Marshall | Indiana | 18099 | 4750 | 84 |
908209 | 908209 | 2021-01-08 | Marshall | Indiana | 18099 | 4722 | 84 |
904963 | 904963 | 2021-01-07 | Marshall | Indiana | 18099 | 4701 | 83 |
901718 | 901718 | 2021-01-06 | Marshall | Indiana | 18099 | 4651 | 82 |
898473 | 898473 | 2021-01-05 | Marshall | Indiana | 18099 | 4631 | 81 |
895228 | 895228 | 2021-01-04 | Marshall | Indiana | 18099 | 4623 | 81 |
891981 | 891981 | 2021-01-03 | Marshall | Indiana | 18099 | 4611 | 81 |
888735 | 888735 | 2021-01-02 | Marshall | Indiana | 18099 | 4603 | 78 |
885489 | 885489 | 2021-01-01 | Marshall | Indiana | 18099 | 4521 | 77 |
882244 | 882244 | 2020-12-31 | Marshall | Indiana | 18099 | 4469 | 77 |
878999 | 878999 | 2020-12-30 | Marshall | Indiana | 18099 | 4452 | 77 |
875754 | 875754 | 2020-12-29 | Marshall | Indiana | 18099 | 4393 | 76 |
872509 | 872509 | 2020-12-28 | Marshall | Indiana | 18099 | 4387 | 73 |
869264 | 869264 | 2020-12-27 | Marshall | Indiana | 18099 | 4382 | 72 |
866019 | 866019 | 2020-12-26 | Marshall | Indiana | 18099 | 4378 | 71 |
862774 | 862774 | 2020-12-25 | Marshall | Indiana | 18099 | 4359 | 69 |
859529 | 859529 | 2020-12-24 | Marshall | Indiana | 18099 | 4324 | 68 |
856284 | 856284 | 2020-12-23 | Marshall | Indiana | 18099 | 4298 | 68 |
853039 | 853039 | 2020-12-22 | Marshall | Indiana | 18099 | 4273 | 67 |
849794 | 849794 | 2020-12-21 | Marshall | Indiana | 18099 | 4256 | 66 |
846549 | 846549 | 2020-12-20 | Marshall | Indiana | 18099 | 4217 | 65 |
843303 | 843303 | 2020-12-19 | Marshall | Indiana | 18099 | 4193 | 62 |
840058 | 840058 | 2020-12-18 | Marshall | Indiana | 18099 | 4172 | 62 |
836813 | 836813 | 2020-12-17 | Marshall | Indiana | 18099 | 4123 | 62 |
833567 | 833567 | 2020-12-16 | Marshall | Indiana | 18099 | 4088 | 62 |
830320 | 830320 | 2020-12-15 | Marshall | Indiana | 18099 | 4051 | 61 |
827074 | 827074 | 2020-12-14 | Marshall | Indiana | 18099 | 3988 | 61 |
823827 | 823827 | 2020-12-13 | Marshall | Indiana | 18099 | 3974 | 61 |
820581 | 820581 | 2020-12-12 | Marshall | Indiana | 18099 | 3923 | 60 |
817335 | 817335 | 2020-12-11 | Marshall | Indiana | 18099 | 3866 | 57 |
814089 | 814089 | 2020-12-10 | Marshall | Indiana | 18099 | 3790 | 57 |
810844 | 810844 | 2020-12-09 | Marshall | Indiana | 18099 | 3730 | 57 |
807599 | 807599 | 2020-12-08 | Marshall | Indiana | 18099 | 3677 | 56 |
804354 | 804354 | 2020-12-07 | Marshall | Indiana | 18099 | 3649 | 52 |
801109 | 801109 | 2020-12-06 | Marshall | Indiana | 18099 | 3637 | 52 |
797864 | 797864 | 2020-12-05 | Marshall | Indiana | 18099 | 3566 | 52 |
794619 | 794619 | 2020-12-04 | Marshall | Indiana | 18099 | 3473 | 52 |
791374 | 791374 | 2020-12-03 | Marshall | Indiana | 18099 | 3431 | 50 |
788129 | 788129 | 2020-12-02 | Marshall | Indiana | 18099 | 3339 | 49 |
784885 | 784885 | 2020-12-01 | Marshall | Indiana | 18099 | 3233 | 48 |
781640 | 781640 | 2020-11-30 | Marshall | Indiana | 18099 | 3204 | 46 |
778394 | 778394 | 2020-11-29 | Marshall | Indiana | 18099 | 3179 | 46 |
775149 | 775149 | 2020-11-28 | Marshall | Indiana | 18099 | 3149 | 46 |
771904 | 771904 | 2020-11-27 | Marshall | Indiana | 18099 | 3118 | 46 |
768659 | 768659 | 2020-11-26 | Marshall | Indiana | 18099 | 3081 | 46 |
765413 | 765413 | 2020-11-25 | Marshall | Indiana | 18099 | 2991 | 44 |
762168 | 762168 | 2020-11-24 | Marshall | Indiana | 18099 | 2937 | 44 |
758923 | 758923 | 2020-11-23 | Marshall | Indiana | 18099 | 2899 | 44 |
755676 | 755676 | 2020-11-22 | Marshall | Indiana | 18099 | 2836 | 42 |
752430 | 752430 | 2020-11-21 | Marshall | Indiana | 18099 | 2796 | 41 |
749184 | 749184 | 2020-11-20 | Marshall | Indiana | 18099 | 2760 | 39 |
745938 | 745938 | 2020-11-19 | Marshall | Indiana | 18099 | 2696 | 39 |
742691 | 742691 | 2020-11-18 | Marshall | Indiana | 18099 | 2637 | 38 |
739444 | 739444 | 2020-11-17 | Marshall | Indiana | 18099 | 2558 | 38 |
736200 | 736200 | 2020-11-16 | Marshall | Indiana | 18099 | 2501 | 34 |
732954 | 732954 | 2020-11-15 | Marshall | Indiana | 18099 | 2452 | 34 |
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);