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 fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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 |
---|---|---|---|---|---|---|---|
10862 | 10862 | 2020-03-25 | Marshall | Alabama | 1095 | 1 | 0 |
12401 | 12401 | 2020-03-26 | Marshall | Alabama | 1095 | 3 | 0 |
14062 | 14062 | 2020-03-27 | Marshall | Alabama | 1095 | 4 | 0 |
15840 | 15840 | 2020-03-28 | Marshall | Alabama | 1095 | 4 | 0 |
17724 | 17724 | 2020-03-29 | Marshall | Alabama | 1095 | 5 | 0 |
19696 | 19696 | 2020-03-30 | Marshall | Alabama | 1095 | 7 | 0 |
21768 | 21768 | 2020-03-31 | Marshall | Alabama | 1095 | 6 | 0 |
23924 | 23924 | 2020-04-01 | Marshall | Alabama | 1095 | 6 | 0 |
26146 | 26146 | 2020-04-02 | Marshall | Alabama | 1095 | 7 | 0 |
28443 | 28443 | 2020-04-03 | Marshall | Alabama | 1095 | 17 | 0 |
30800 | 30800 | 2020-04-04 | Marshall | Alabama | 1095 | 17 | 0 |
33204 | 33204 | 2020-04-05 | Marshall | Alabama | 1095 | 26 | 0 |
35643 | 35643 | 2020-04-06 | Marshall | Alabama | 1095 | 34 | 1 |
38131 | 38131 | 2020-04-07 | Marshall | Alabama | 1095 | 40 | 1 |
40673 | 40673 | 2020-04-08 | Marshall | Alabama | 1095 | 45 | 1 |
43246 | 43246 | 2020-04-09 | Marshall | Alabama | 1095 | 64 | 2 |
45844 | 45844 | 2020-04-10 | Marshall | Alabama | 1095 | 72 | 2 |
48473 | 48473 | 2020-04-11 | Marshall | Alabama | 1095 | 84 | 2 |
51135 | 51135 | 2020-04-12 | Marshall | Alabama | 1095 | 99 | 2 |
53813 | 53813 | 2020-04-13 | Marshall | Alabama | 1095 | 103 | 2 |
56505 | 56505 | 2020-04-14 | Marshall | Alabama | 1095 | 104 | 2 |
59213 | 59213 | 2020-04-15 | Marshall | Alabama | 1095 | 109 | 2 |
61931 | 61931 | 2020-04-16 | Marshall | Alabama | 1095 | 117 | 2 |
64664 | 64664 | 2020-04-17 | Marshall | Alabama | 1095 | 123 | 4 |
67412 | 67412 | 2020-04-18 | Marshall | Alabama | 1095 | 139 | 4 |
70174 | 70174 | 2020-04-19 | Marshall | Alabama | 1095 | 150 | 4 |
72943 | 72943 | 2020-04-20 | Marshall | Alabama | 1095 | 167 | 3 |
75719 | 75719 | 2020-04-21 | Marshall | Alabama | 1095 | 195 | 5 |
78502 | 78502 | 2020-04-22 | Marshall | Alabama | 1095 | 241 | 4 |
81295 | 81295 | 2020-04-23 | Marshall | Alabama | 1095 | 258 | 4 |
84096 | 84096 | 2020-04-24 | Marshall | Alabama | 1095 | 267 | 4 |
86904 | 86904 | 2020-04-25 | Marshall | Alabama | 1095 | 279 | 5 |
89720 | 89720 | 2020-04-26 | Marshall | Alabama | 1095 | 307 | 5 |
92538 | 92538 | 2020-04-27 | Marshall | Alabama | 1095 | 310 | 5 |
95368 | 95368 | 2020-04-28 | Marshall | Alabama | 1095 | 313 | 6 |
98213 | 98213 | 2020-04-29 | Marshall | Alabama | 1095 | 316 | 6 |
101063 | 101063 | 2020-04-30 | Marshall | Alabama | 1095 | 317 | 6 |
103918 | 103918 | 2020-05-01 | Marshall | Alabama | 1095 | 328 | 7 |
106783 | 106783 | 2020-05-02 | Marshall | Alabama | 1095 | 334 | 7 |
109652 | 109652 | 2020-05-03 | Marshall | Alabama | 1095 | 342 | 7 |
112527 | 112527 | 2020-05-04 | Marshall | Alabama | 1095 | 355 | 7 |
115410 | 115410 | 2020-05-05 | Marshall | Alabama | 1095 | 439 | 8 |
118369 | 118369 | 2020-05-06 | Marshall | Alabama | 1095 | 470 | 8 |
121335 | 121335 | 2020-05-07 | Marshall | Alabama | 1095 | 487 | 8 |
124315 | 124315 | 2020-05-08 | Marshall | Alabama | 1095 | 525 | 8 |
127300 | 127300 | 2020-05-09 | Marshall | Alabama | 1095 | 543 | 8 |
130290 | 130290 | 2020-05-10 | Marshall | Alabama | 1095 | 558 | 8 |
133280 | 133280 | 2020-05-11 | Marshall | Alabama | 1095 | 576 | 8 |
136270 | 136270 | 2020-05-12 | Marshall | Alabama | 1095 | 581 | 8 |
139261 | 139261 | 2020-05-13 | Marshall | Alabama | 1095 | 586 | 9 |
142257 | 142257 | 2020-05-14 | Marshall | Alabama | 1095 | 599 | 9 |
145256 | 145256 | 2020-05-15 | Marshall | Alabama | 1095 | 612 | 9 |
148259 | 148259 | 2020-05-16 | Marshall | Alabama | 1095 | 624 | 9 |
151268 | 151268 | 2020-05-17 | Marshall | Alabama | 1095 | 624 | 9 |
154280 | 154280 | 2020-05-18 | Marshall | Alabama | 1095 | 632 | 9 |
157296 | 157296 | 2020-05-19 | Marshall | Alabama | 1095 | 638 | 9 |
160320 | 160320 | 2020-05-20 | Marshall | Alabama | 1095 | 641 | 9 |
163348 | 163348 | 2020-05-21 | Marshall | Alabama | 1095 | 643 | 9 |
166380 | 166380 | 2020-05-22 | Marshall | Alabama | 1095 | 642 | 9 |
169416 | 169416 | 2020-05-23 | Marshall | Alabama | 1095 | 645 | 9 |
172457 | 172457 | 2020-05-24 | Marshall | Alabama | 1095 | 649 | 9 |
175500 | 175500 | 2020-05-25 | Marshall | Alabama | 1095 | 650 | 9 |
178545 | 178545 | 2020-05-26 | Marshall | Alabama | 1095 | 660 | 9 |
181589 | 181589 | 2020-05-27 | Marshall | Alabama | 1095 | 660 | 9 |
184641 | 184641 | 2020-05-28 | Marshall | Alabama | 1095 | 668 | 9 |
187698 | 187698 | 2020-05-29 | Marshall | Alabama | 1095 | 681 | 9 |
190762 | 190762 | 2020-05-30 | Marshall | Alabama | 1095 | 687 | 9 |
193828 | 193828 | 2020-05-31 | Marshall | Alabama | 1095 | 693 | 9 |
196898 | 196898 | 2020-06-01 | Marshall | Alabama | 1095 | 704 | 9 |
199971 | 199971 | 2020-06-02 | Marshall | Alabama | 1095 | 709 | 9 |
203047 | 203047 | 2020-06-03 | Marshall | Alabama | 1095 | 709 | 9 |
206126 | 206126 | 2020-06-04 | Marshall | Alabama | 1095 | 712 | 9 |
209208 | 209208 | 2020-06-05 | Marshall | Alabama | 1095 | 718 | 9 |
212293 | 212293 | 2020-06-06 | Marshall | Alabama | 1095 | 734 | 9 |
215380 | 215380 | 2020-06-07 | Marshall | Alabama | 1095 | 743 | 9 |
218470 | 218470 | 2020-06-08 | Marshall | Alabama | 1095 | 748 | 9 |
221562 | 221562 | 2020-06-09 | Marshall | Alabama | 1095 | 756 | 9 |
224658 | 224658 | 2020-06-10 | Marshall | Alabama | 1095 | 768 | 9 |
227759 | 227759 | 2020-06-11 | Marshall | Alabama | 1095 | 791 | 9 |
230863 | 230863 | 2020-06-12 | Marshall | Alabama | 1095 | 816 | 9 |
233968 | 233968 | 2020-06-13 | Marshall | Alabama | 1095 | 854 | 9 |
237075 | 237075 | 2020-06-14 | Marshall | Alabama | 1095 | 887 | 9 |
240183 | 240183 | 2020-06-15 | Marshall | Alabama | 1095 | 901 | 9 |
243294 | 243294 | 2020-06-16 | Marshall | Alabama | 1095 | 931 | 9 |
246407 | 246407 | 2020-06-17 | Marshall | Alabama | 1095 | 962 | 9 |
249519 | 249519 | 2020-06-18 | Marshall | Alabama | 1095 | 1001 | 9 |
252634 | 252634 | 2020-06-19 | Marshall | Alabama | 1095 | 1038 | 9 |
255753 | 255753 | 2020-06-20 | Marshall | Alabama | 1095 | 1061 | 9 |
258880 | 258880 | 2020-06-21 | Marshall | Alabama | 1095 | 1082 | 9 |
262007 | 262007 | 2020-06-22 | Marshall | Alabama | 1095 | 1104 | 9 |
265136 | 265136 | 2020-06-23 | Marshall | Alabama | 1095 | 1148 | 9 |
268265 | 268265 | 2020-06-24 | Marshall | Alabama | 1095 | 1192 | 9 |
271399 | 271399 | 2020-06-25 | Marshall | Alabama | 1095 | 1275 | 9 |
274539 | 274539 | 2020-06-26 | Marshall | Alabama | 1095 | 1336 | 9 |
277687 | 277687 | 2020-06-27 | Marshall | Alabama | 1095 | 1399 | 9 |
280835 | 280835 | 2020-06-28 | Marshall | Alabama | 1095 | 1418 | 9 |
283981 | 283981 | 2020-06-29 | Marshall | Alabama | 1095 | 1463 | 9 |
287127 | 287127 | 2020-06-30 | Marshall | Alabama | 1095 | 1505 | 9 |
290277 | 290277 | 2020-07-01 | Marshall | Alabama | 1095 | 1548 | 10 |
293430 | 293430 | 2020-07-02 | Marshall | Alabama | 1095 | 1631 | 10 |
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);