ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
9,222 rows where county = "Marshall" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 12
- Mississippi 211
- West Virginia 210
- Illinois 206
- Alabama 205
- Indiana 205
- Iowa 204
- Kentucky 201
- South Dakota 201
- Tennessee 201
- Oklahoma 193
- Minnesota 181
- Kansas 115
fips 12
county 1
- Marshall · 2,333 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635542 | 635542 | 2020-10-16 | Marshall | Illinois | 17123 | 132 | 3 |
635636 | 635636 | 2020-10-16 | Marshall | Indiana | 18099 | 1261 | 26 |
635742 | 635742 | 2020-10-16 | Marshall | Iowa | 19127 | 1911 | 36 |
635836 | 635836 | 2020-10-16 | Marshall | Kansas | 20117 | 62 | 0 |
635960 | 635960 | 2020-10-16 | Marshall | Kentucky | 21157 | 406 | 4 |
636254 | 636254 | 2020-10-16 | Marshall | Minnesota | 27089 | 76 | 1 |
636345 | 636345 | 2020-10-16 | Marshall | Mississippi | 28093 | 1273 | 25 |
637076 | 637076 | 2020-10-16 | Marshall | Oklahoma | 40095 | 246 | 2 |
637386 | 637386 | 2020-10-16 | Marshall | South Dakota | 46091 | 54 | 0 |
637466 | 637466 | 2020-10-16 | Marshall | Tennessee | 47117 | 992 | 8 |
638003 | 638003 | 2020-10-16 | Marshall | West Virginia | 54051 | 238 | 1 |
631687 | 631687 | 2020-10-15 | Marshall | Alabama | 1095 | 4194 | 47 |
632296 | 632296 | 2020-10-15 | Marshall | Illinois | 17123 | 129 | 3 |
632390 | 632390 | 2020-10-15 | Marshall | Indiana | 18099 | 1239 | 26 |
632496 | 632496 | 2020-10-15 | Marshall | Iowa | 19127 | 1893 | 36 |
632590 | 632590 | 2020-10-15 | Marshall | Kansas | 20117 | 61 | 0 |
632714 | 632714 | 2020-10-15 | Marshall | Kentucky | 21157 | 405 | 4 |
633008 | 633008 | 2020-10-15 | Marshall | Minnesota | 27089 | 74 | 1 |
633099 | 633099 | 2020-10-15 | Marshall | Mississippi | 28093 | 1244 | 25 |
633830 | 633830 | 2020-10-15 | Marshall | Oklahoma | 40095 | 235 | 2 |
634140 | 634140 | 2020-10-15 | Marshall | South Dakota | 46091 | 54 | 0 |
634220 | 634220 | 2020-10-15 | Marshall | Tennessee | 47117 | 987 | 8 |
634758 | 634758 | 2020-10-15 | Marshall | West Virginia | 54051 | 231 | 1 |
628443 | 628443 | 2020-10-14 | Marshall | Alabama | 1095 | 4182 | 46 |
629052 | 629052 | 2020-10-14 | Marshall | Illinois | 17123 | 129 | 3 |
629146 | 629146 | 2020-10-14 | Marshall | Indiana | 18099 | 1218 | 26 |
629252 | 629252 | 2020-10-14 | Marshall | Iowa | 19127 | 1883 | 36 |
629346 | 629346 | 2020-10-14 | Marshall | Kansas | 20117 | 61 | 0 |
629470 | 629470 | 2020-10-14 | Marshall | Kentucky | 21157 | 393 | 4 |
629763 | 629763 | 2020-10-14 | Marshall | Minnesota | 27089 | 73 | 1 |
629854 | 629854 | 2020-10-14 | Marshall | Mississippi | 28093 | 1228 | 24 |
630585 | 630585 | 2020-10-14 | Marshall | Oklahoma | 40095 | 228 | 2 |
630895 | 630895 | 2020-10-14 | Marshall | South Dakota | 46091 | 54 | 0 |
630975 | 630975 | 2020-10-14 | Marshall | Tennessee | 47117 | 968 | 6 |
631513 | 631513 | 2020-10-14 | Marshall | West Virginia | 54051 | 221 | 1 |
625200 | 625200 | 2020-10-13 | Marshall | Alabama | 1095 | 4172 | 45 |
625809 | 625809 | 2020-10-13 | Marshall | Illinois | 17123 | 127 | 1 |
625903 | 625903 | 2020-10-13 | Marshall | Indiana | 18099 | 1209 | 26 |
626009 | 626009 | 2020-10-13 | Marshall | Iowa | 19127 | 1877 | 36 |
626103 | 626103 | 2020-10-13 | Marshall | Kansas | 20117 | 61 | 0 |
626226 | 626226 | 2020-10-13 | Marshall | Kentucky | 21157 | 381 | 4 |
626519 | 626519 | 2020-10-13 | Marshall | Minnesota | 27089 | 70 | 1 |
626610 | 626610 | 2020-10-13 | Marshall | Mississippi | 28093 | 1209 | 23 |
627341 | 627341 | 2020-10-13 | Marshall | Oklahoma | 40095 | 222 | 2 |
627651 | 627651 | 2020-10-13 | Marshall | South Dakota | 46091 | 52 | 0 |
627731 | 627731 | 2020-10-13 | Marshall | Tennessee | 47117 | 956 | 5 |
628269 | 628269 | 2020-10-13 | Marshall | West Virginia | 54051 | 218 | 1 |
621957 | 621957 | 2020-10-12 | Marshall | Alabama | 1095 | 4153 | 45 |
622567 | 622567 | 2020-10-12 | Marshall | Illinois | 17123 | 124 | 1 |
622661 | 622661 | 2020-10-12 | Marshall | Indiana | 18099 | 1189 | 26 |
622767 | 622767 | 2020-10-12 | Marshall | Iowa | 19127 | 1873 | 36 |
622861 | 622861 | 2020-10-12 | Marshall | Kansas | 20117 | 61 | 0 |
622984 | 622984 | 2020-10-12 | Marshall | Kentucky | 21157 | 374 | 4 |
623277 | 623277 | 2020-10-12 | Marshall | Minnesota | 27089 | 70 | 1 |
623368 | 623368 | 2020-10-12 | Marshall | Mississippi | 28093 | 1195 | 22 |
624099 | 624099 | 2020-10-12 | Marshall | Oklahoma | 40095 | 218 | 2 |
624409 | 624409 | 2020-10-12 | Marshall | South Dakota | 46091 | 51 | 0 |
624489 | 624489 | 2020-10-12 | Marshall | Tennessee | 47117 | 946 | 5 |
625026 | 625026 | 2020-10-12 | Marshall | West Virginia | 54051 | 205 | 1 |
618714 | 618714 | 2020-10-11 | Marshall | Alabama | 1095 | 4147 | 45 |
619323 | 619323 | 2020-10-11 | Marshall | Illinois | 17123 | 121 | 1 |
619417 | 619417 | 2020-10-11 | Marshall | Indiana | 18099 | 1157 | 26 |
619523 | 619523 | 2020-10-11 | Marshall | Iowa | 19127 | 1868 | 36 |
619617 | 619617 | 2020-10-11 | Marshall | Kansas | 20117 | 50 | 0 |
619740 | 619740 | 2020-10-11 | Marshall | Kentucky | 21157 | 372 | 4 |
620034 | 620034 | 2020-10-11 | Marshall | Minnesota | 27089 | 70 | 1 |
620125 | 620125 | 2020-10-11 | Marshall | Mississippi | 28093 | 1182 | 22 |
620856 | 620856 | 2020-10-11 | Marshall | Oklahoma | 40095 | 215 | 2 |
621166 | 621166 | 2020-10-11 | Marshall | South Dakota | 46091 | 51 | 0 |
621246 | 621246 | 2020-10-11 | Marshall | Tennessee | 47117 | 920 | 5 |
621783 | 621783 | 2020-10-11 | Marshall | West Virginia | 54051 | 205 | 1 |
615472 | 615472 | 2020-10-10 | Marshall | Alabama | 1095 | 4137 | 45 |
616081 | 616081 | 2020-10-10 | Marshall | Illinois | 17123 | 120 | 1 |
616175 | 616175 | 2020-10-10 | Marshall | Indiana | 18099 | 1137 | 26 |
616281 | 616281 | 2020-10-10 | Marshall | Iowa | 19127 | 1863 | 36 |
616375 | 616375 | 2020-10-10 | Marshall | Kansas | 20117 | 50 | 0 |
616498 | 616498 | 2020-10-10 | Marshall | Kentucky | 21157 | 368 | 4 |
616792 | 616792 | 2020-10-10 | Marshall | Minnesota | 27089 | 68 | 1 |
616883 | 616883 | 2020-10-10 | Marshall | Mississippi | 28093 | 1180 | 22 |
617614 | 617614 | 2020-10-10 | Marshall | Oklahoma | 40095 | 212 | 2 |
617923 | 617923 | 2020-10-10 | Marshall | South Dakota | 46091 | 51 | 0 |
618003 | 618003 | 2020-10-10 | Marshall | Tennessee | 47117 | 900 | 5 |
618540 | 618540 | 2020-10-10 | Marshall | West Virginia | 54051 | 201 | 1 |
612231 | 612231 | 2020-10-09 | Marshall | Alabama | 1095 | 4121 | 45 |
612840 | 612840 | 2020-10-09 | Marshall | Illinois | 17123 | 120 | 1 |
612934 | 612934 | 2020-10-09 | Marshall | Indiana | 18099 | 1123 | 26 |
613040 | 613040 | 2020-10-09 | Marshall | Iowa | 19127 | 1860 | 36 |
613134 | 613134 | 2020-10-09 | Marshall | Kansas | 20117 | 50 | 0 |
613257 | 613257 | 2020-10-09 | Marshall | Kentucky | 21157 | 364 | 4 |
613551 | 613551 | 2020-10-09 | Marshall | Minnesota | 27089 | 63 | 1 |
613642 | 613642 | 2020-10-09 | Marshall | Mississippi | 28093 | 1164 | 22 |
614372 | 614372 | 2020-10-09 | Marshall | Oklahoma | 40095 | 209 | 2 |
614681 | 614681 | 2020-10-09 | Marshall | South Dakota | 46091 | 51 | 0 |
614761 | 614761 | 2020-10-09 | Marshall | Tennessee | 47117 | 878 | 5 |
615298 | 615298 | 2020-10-09 | Marshall | West Virginia | 54051 | 196 | 1 |
608989 | 608989 | 2020-10-08 | Marshall | Alabama | 1095 | 4083 | 45 |
609598 | 609598 | 2020-10-08 | Marshall | Illinois | 17123 | 120 | 0 |
609692 | 609692 | 2020-10-08 | Marshall | Indiana | 18099 | 1105 | 26 |
609798 | 609798 | 2020-10-08 | Marshall | Iowa | 19127 | 1854 | 36 |
609892 | 609892 | 2020-10-08 | Marshall | Kansas | 20117 | 43 | 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);