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 county
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-06-24 12
- 2020-06-25 12
- 2020-06-26 12
- 2020-06-27 12
- 2020-06-28 12
- 2020-06-29 12
- 2020-06-30 12
- 2020-07-01 12
- 2020-07-02 12
- 2020-07-03 12
- 2020-07-04 12
- 2020-07-05 12
- 2020-07-06 12
- 2020-07-07 12
- 2020-07-08 12
- 2020-07-09 12
- 2020-07-10 12
- 2020-07-11 12
- 2020-07-12 12
- 2020-07-13 12
- 2020-07-14 12
- 2020-07-15 12
- 2020-07-16 12
- 2020-07-17 12
- 2020-07-18 12
- 2020-07-19 12
- 2020-07-20 12
- 2020-07-21 12
- 2020-07-22 12
- 2020-07-23 12
- …
state 12
- Mississippi 785
- West Virginia 784
- Alabama 780
- Illinois 780
- Indiana 779
- Iowa 778
- Kentucky 775
- South Dakota 775
- Tennessee 775
- Oklahoma 767
- Minnesota 755
- Kansas 689
fips 12
county 1
- Marshall · 9,222 ✖
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5621 | 5621 | 2020-03-20 | Marshall | Mississippi | 28093 | 1 | 0 |
6603 | 6603 | 2020-03-21 | Marshall | Mississippi | 28093 | 2 | 0 |
7075 | 7075 | 2020-03-21 | Marshall | West Virginia | 54051 | 2 | 0 |
7686 | 7686 | 2020-03-22 | Marshall | Mississippi | 28093 | 3 | 0 |
8213 | 8213 | 2020-03-22 | Marshall | West Virginia | 54051 | 2 | 0 |
8868 | 8868 | 2020-03-23 | Marshall | Mississippi | 28093 | 3 | 0 |
9438 | 9438 | 2020-03-23 | Marshall | West Virginia | 54051 | 2 | 0 |
10164 | 10164 | 2020-03-24 | Marshall | Mississippi | 28093 | 3 | 0 |
10790 | 10790 | 2020-03-24 | Marshall | West Virginia | 54051 | 2 | 0 |
10862 | 10862 | 2020-03-25 | Marshall | Alabama | 1095 | 1 | 0 |
11212 | 11212 | 2020-03-25 | Marshall | Illinois | 17123 | 1 | 0 |
11584 | 11584 | 2020-03-25 | Marshall | Mississippi | 28093 | 4 | 0 |
12315 | 12315 | 2020-03-25 | Marshall | West Virginia | 54051 | 2 | 0 |
12401 | 12401 | 2020-03-26 | Marshall | Alabama | 1095 | 3 | 0 |
12768 | 12768 | 2020-03-26 | Marshall | Illinois | 17123 | 1 | 0 |
12817 | 12817 | 2020-03-26 | Marshall | Indiana | 18099 | 1 | 0 |
13177 | 13177 | 2020-03-26 | Marshall | Mississippi | 28093 | 7 | 0 |
13966 | 13966 | 2020-03-26 | Marshall | West Virginia | 54051 | 3 | 0 |
14062 | 14062 | 2020-03-27 | Marshall | Alabama | 1095 | 4 | 0 |
14446 | 14446 | 2020-03-27 | Marshall | Illinois | 17123 | 1 | 0 |
14502 | 14502 | 2020-03-27 | Marshall | Indiana | 18099 | 4 | 0 |
14559 | 14559 | 2020-03-27 | Marshall | Iowa | 19127 | 1 | 0 |
14895 | 14895 | 2020-03-27 | Marshall | Mississippi | 28093 | 9 | 0 |
15737 | 15737 | 2020-03-27 | Marshall | West Virginia | 54051 | 3 | 0 |
15840 | 15840 | 2020-03-28 | Marshall | Alabama | 1095 | 4 | 0 |
16242 | 16242 | 2020-03-28 | Marshall | Illinois | 17123 | 1 | 0 |
16300 | 16300 | 2020-03-28 | Marshall | Indiana | 18099 | 3 | 0 |
16364 | 16364 | 2020-03-28 | Marshall | Iowa | 19127 | 5 | 0 |
16719 | 16719 | 2020-03-28 | Marshall | Mississippi | 28093 | 11 | 0 |
17617 | 17617 | 2020-03-28 | Marshall | West Virginia | 54051 | 4 | 0 |
17724 | 17724 | 2020-03-29 | Marshall | Alabama | 1095 | 5 | 0 |
18142 | 18142 | 2020-03-29 | Marshall | Illinois | 17123 | 1 | 0 |
18204 | 18204 | 2020-03-29 | Marshall | Indiana | 18099 | 3 | 0 |
18269 | 18269 | 2020-03-29 | Marshall | Iowa | 19127 | 6 | 0 |
18641 | 18641 | 2020-03-29 | Marshall | Mississippi | 28093 | 13 | 0 |
19583 | 19583 | 2020-03-29 | Marshall | West Virginia | 54051 | 4 | 0 |
19696 | 19696 | 2020-03-30 | Marshall | Alabama | 1095 | 7 | 0 |
20145 | 20145 | 2020-03-30 | Marshall | Illinois | 17123 | 1 | 0 |
20210 | 20210 | 2020-03-30 | Marshall | Indiana | 18099 | 3 | 0 |
20280 | 20280 | 2020-03-30 | Marshall | Iowa | 19127 | 6 | 0 |
20377 | 20377 | 2020-03-30 | Marshall | Kentucky | 21157 | 1 | 0 |
20665 | 20665 | 2020-03-30 | Marshall | Mississippi | 28093 | 13 | 0 |
21279 | 21279 | 2020-03-30 | Marshall | South Dakota | 46091 | 1 | 0 |
21334 | 21334 | 2020-03-30 | Marshall | Tennessee | 47117 | 1 | 0 |
21650 | 21650 | 2020-03-30 | Marshall | West Virginia | 54051 | 4 | 0 |
21768 | 21768 | 2020-03-31 | Marshall | Alabama | 1095 | 6 | 0 |
22237 | 22237 | 2020-03-31 | Marshall | Illinois | 17123 | 1 | 0 |
22305 | 22305 | 2020-03-31 | Marshall | Indiana | 18099 | 3 | 0 |
22376 | 22376 | 2020-03-31 | Marshall | Iowa | 19127 | 8 | 0 |
22482 | 22482 | 2020-03-31 | Marshall | Kentucky | 21157 | 1 | 0 |
22782 | 22782 | 2020-03-31 | Marshall | Mississippi | 28093 | 14 | 0 |
23417 | 23417 | 2020-03-31 | Marshall | South Dakota | 46091 | 1 | 0 |
23473 | 23473 | 2020-03-31 | Marshall | Tennessee | 47117 | 1 | 0 |
23800 | 23800 | 2020-03-31 | Marshall | West Virginia | 54051 | 4 | 0 |
23924 | 23924 | 2020-04-01 | Marshall | Alabama | 1095 | 6 | 0 |
24405 | 24405 | 2020-04-01 | Marshall | Illinois | 17123 | 1 | 0 |
24476 | 24476 | 2020-04-01 | Marshall | Indiana | 18099 | 3 | 0 |
24549 | 24549 | 2020-04-01 | Marshall | Iowa | 19127 | 8 | 0 |
24658 | 24658 | 2020-04-01 | Marshall | Kentucky | 21157 | 1 | 0 |
24966 | 24966 | 2020-04-01 | Marshall | Mississippi | 28093 | 15 | 0 |
25615 | 25615 | 2020-04-01 | Marshall | South Dakota | 46091 | 1 | 0 |
25675 | 25675 | 2020-04-01 | Marshall | Tennessee | 47117 | 1 | 0 |
26018 | 26018 | 2020-04-01 | Marshall | West Virginia | 54051 | 4 | 0 |
26146 | 26146 | 2020-04-02 | Marshall | Alabama | 1095 | 7 | 0 |
26640 | 26640 | 2020-04-02 | Marshall | Illinois | 17123 | 1 | 0 |
26715 | 26715 | 2020-04-02 | Marshall | Indiana | 18099 | 4 | 0 |
26791 | 26791 | 2020-04-02 | Marshall | Iowa | 19127 | 9 | 0 |
26906 | 26906 | 2020-04-02 | Marshall | Kentucky | 21157 | 1 | 0 |
27220 | 27220 | 2020-04-02 | Marshall | Mississippi | 28093 | 18 | 1 |
27892 | 27892 | 2020-04-02 | Marshall | South Dakota | 46091 | 1 | 0 |
27954 | 27954 | 2020-04-02 | Marshall | Tennessee | 47117 | 2 | 0 |
28310 | 28310 | 2020-04-02 | Marshall | West Virginia | 54051 | 4 | 0 |
28443 | 28443 | 2020-04-03 | Marshall | Alabama | 1095 | 17 | 0 |
28950 | 28950 | 2020-04-03 | Marshall | Illinois | 17123 | 1 | 0 |
29025 | 29025 | 2020-04-03 | Marshall | Indiana | 18099 | 4 | 0 |
29104 | 29104 | 2020-04-03 | Marshall | Iowa | 19127 | 10 | 0 |
29222 | 29222 | 2020-04-03 | Marshall | Kentucky | 21157 | 1 | 0 |
29539 | 29539 | 2020-04-03 | Marshall | Mississippi | 28093 | 19 | 1 |
30227 | 30227 | 2020-04-03 | Marshall | South Dakota | 46091 | 1 | 0 |
30289 | 30289 | 2020-04-03 | Marshall | Tennessee | 47117 | 4 | 0 |
30663 | 30663 | 2020-04-03 | Marshall | West Virginia | 54051 | 4 | 0 |
30800 | 30800 | 2020-04-04 | Marshall | Alabama | 1095 | 17 | 0 |
31314 | 31314 | 2020-04-04 | Marshall | Illinois | 17123 | 1 | 0 |
31391 | 31391 | 2020-04-04 | Marshall | Indiana | 18099 | 4 | 0 |
31475 | 31475 | 2020-04-04 | Marshall | Iowa | 19127 | 10 | 0 |
31598 | 31598 | 2020-04-04 | Marshall | Kentucky | 21157 | 1 | 0 |
31919 | 31919 | 2020-04-04 | Marshall | Mississippi | 28093 | 20 | 1 |
32618 | 32618 | 2020-04-04 | Marshall | South Dakota | 46091 | 1 | 0 |
32680 | 32680 | 2020-04-04 | Marshall | Tennessee | 47117 | 4 | 0 |
33064 | 33064 | 2020-04-04 | Marshall | West Virginia | 54051 | 4 | 0 |
33204 | 33204 | 2020-04-05 | Marshall | Alabama | 1095 | 26 | 0 |
33724 | 33724 | 2020-04-05 | Marshall | Illinois | 17123 | 1 | 0 |
33802 | 33802 | 2020-04-05 | Marshall | Indiana | 18099 | 6 | 0 |
33888 | 33888 | 2020-04-05 | Marshall | Iowa | 19127 | 10 | 0 |
34020 | 34020 | 2020-04-05 | Marshall | Kentucky | 21157 | 1 | 0 |
34346 | 34346 | 2020-04-05 | Marshall | Mississippi | 28093 | 20 | 1 |
35054 | 35054 | 2020-04-05 | Marshall | South Dakota | 46091 | 1 | 0 |
35117 | 35117 | 2020-04-05 | Marshall | Tennessee | 47117 | 6 | 0 |
35502 | 35502 | 2020-04-05 | Marshall | West Virginia | 54051 | 5 | 0 |
35643 | 35643 | 2020-04-06 | Marshall | Alabama | 1095 | 34 | 1 |
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);