ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Marshall" and fips = 1095 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
382769 | 382769 | 2020-07-30 | Marshall | Alabama | 1095 | 2843 | 29 |
379552 | 379552 | 2020-07-29 | Marshall | Alabama | 1095 | 2775 | 29 |
376336 | 376336 | 2020-07-28 | Marshall | Alabama | 1095 | 2760 | 26 |
373122 | 373122 | 2020-07-27 | Marshall | Alabama | 1095 | 2751 | 26 |
369910 | 369910 | 2020-07-26 | Marshall | Alabama | 1095 | 2707 | 26 |
366700 | 366700 | 2020-07-25 | Marshall | Alabama | 1095 | 2664 | 27 |
363493 | 363493 | 2020-07-24 | Marshall | Alabama | 1095 | 2626 | 25 |
360287 | 360287 | 2020-07-23 | Marshall | Alabama | 1095 | 2582 | 21 |
357082 | 357082 | 2020-07-22 | Marshall | Alabama | 1095 | 2494 | 21 |
353879 | 353879 | 2020-07-21 | Marshall | Alabama | 1095 | 2458 | 20 |
350677 | 350677 | 2020-07-20 | Marshall | Alabama | 1095 | 2429 | 19 |
347476 | 347476 | 2020-07-19 | Marshall | Alabama | 1095 | 2364 | 19 |
344276 | 344276 | 2020-07-18 | Marshall | Alabama | 1095 | 2310 | 19 |
341077 | 341077 | 2020-07-17 | Marshall | Alabama | 1095 | 2287 | 13 |
337881 | 337881 | 2020-07-16 | Marshall | Alabama | 1095 | 2229 | 13 |
334686 | 334686 | 2020-07-15 | Marshall | Alabama | 1095 | 2149 | 13 |
331493 | 331493 | 2020-07-14 | Marshall | Alabama | 1095 | 2105 | 12 |
328307 | 328307 | 2020-07-13 | Marshall | Alabama | 1095 | 2065 | 12 |
325121 | 325121 | 2020-07-12 | Marshall | Alabama | 1095 | 1996 | 11 |
321940 | 321940 | 2020-07-11 | Marshall | Alabama | 1095 | 1942 | 11 |
318761 | 318761 | 2020-07-10 | Marshall | Alabama | 1095 | 1918 | 11 |
315588 | 315588 | 2020-07-09 | Marshall | Alabama | 1095 | 1879 | 11 |
312413 | 312413 | 2020-07-08 | Marshall | Alabama | 1095 | 1826 | 11 |
309244 | 309244 | 2020-07-07 | Marshall | Alabama | 1095 | 1781 | 11 |
306075 | 306075 | 2020-07-06 | Marshall | Alabama | 1095 | 1732 | 10 |
302911 | 302911 | 2020-07-05 | Marshall | Alabama | 1095 | 1719 | 10 |
299747 | 299747 | 2020-07-04 | Marshall | Alabama | 1095 | 1710 | 10 |
296585 | 296585 | 2020-07-03 | Marshall | Alabama | 1095 | 1688 | 10 |
293430 | 293430 | 2020-07-02 | Marshall | Alabama | 1095 | 1631 | 10 |
290277 | 290277 | 2020-07-01 | Marshall | Alabama | 1095 | 1548 | 10 |
287127 | 287127 | 2020-06-30 | Marshall | Alabama | 1095 | 1505 | 9 |
283981 | 283981 | 2020-06-29 | Marshall | Alabama | 1095 | 1463 | 9 |
280835 | 280835 | 2020-06-28 | Marshall | Alabama | 1095 | 1418 | 9 |
277687 | 277687 | 2020-06-27 | Marshall | Alabama | 1095 | 1399 | 9 |
274539 | 274539 | 2020-06-26 | Marshall | Alabama | 1095 | 1336 | 9 |
271399 | 271399 | 2020-06-25 | Marshall | Alabama | 1095 | 1275 | 9 |
268265 | 268265 | 2020-06-24 | Marshall | Alabama | 1095 | 1192 | 9 |
265136 | 265136 | 2020-06-23 | Marshall | Alabama | 1095 | 1148 | 9 |
262007 | 262007 | 2020-06-22 | Marshall | Alabama | 1095 | 1104 | 9 |
258880 | 258880 | 2020-06-21 | Marshall | Alabama | 1095 | 1082 | 9 |
255753 | 255753 | 2020-06-20 | Marshall | Alabama | 1095 | 1061 | 9 |
252634 | 252634 | 2020-06-19 | Marshall | Alabama | 1095 | 1038 | 9 |
249519 | 249519 | 2020-06-18 | Marshall | Alabama | 1095 | 1001 | 9 |
246407 | 246407 | 2020-06-17 | Marshall | Alabama | 1095 | 962 | 9 |
243294 | 243294 | 2020-06-16 | Marshall | Alabama | 1095 | 931 | 9 |
240183 | 240183 | 2020-06-15 | Marshall | Alabama | 1095 | 901 | 9 |
237075 | 237075 | 2020-06-14 | Marshall | Alabama | 1095 | 887 | 9 |
233968 | 233968 | 2020-06-13 | Marshall | Alabama | 1095 | 854 | 9 |
230863 | 230863 | 2020-06-12 | Marshall | Alabama | 1095 | 816 | 9 |
227759 | 227759 | 2020-06-11 | Marshall | Alabama | 1095 | 791 | 9 |
224658 | 224658 | 2020-06-10 | Marshall | Alabama | 1095 | 768 | 9 |
221562 | 221562 | 2020-06-09 | Marshall | Alabama | 1095 | 756 | 9 |
218470 | 218470 | 2020-06-08 | Marshall | Alabama | 1095 | 748 | 9 |
215380 | 215380 | 2020-06-07 | Marshall | Alabama | 1095 | 743 | 9 |
212293 | 212293 | 2020-06-06 | Marshall | Alabama | 1095 | 734 | 9 |
209208 | 209208 | 2020-06-05 | Marshall | Alabama | 1095 | 718 | 9 |
206126 | 206126 | 2020-06-04 | Marshall | Alabama | 1095 | 712 | 9 |
203047 | 203047 | 2020-06-03 | Marshall | Alabama | 1095 | 709 | 9 |
199971 | 199971 | 2020-06-02 | Marshall | Alabama | 1095 | 709 | 9 |
196898 | 196898 | 2020-06-01 | Marshall | Alabama | 1095 | 704 | 9 |
193828 | 193828 | 2020-05-31 | Marshall | Alabama | 1095 | 693 | 9 |
190762 | 190762 | 2020-05-30 | Marshall | Alabama | 1095 | 687 | 9 |
187698 | 187698 | 2020-05-29 | Marshall | Alabama | 1095 | 681 | 9 |
184641 | 184641 | 2020-05-28 | Marshall | Alabama | 1095 | 668 | 9 |
181589 | 181589 | 2020-05-27 | Marshall | Alabama | 1095 | 660 | 9 |
178545 | 178545 | 2020-05-26 | Marshall | Alabama | 1095 | 660 | 9 |
175500 | 175500 | 2020-05-25 | Marshall | Alabama | 1095 | 650 | 9 |
172457 | 172457 | 2020-05-24 | Marshall | Alabama | 1095 | 649 | 9 |
169416 | 169416 | 2020-05-23 | Marshall | Alabama | 1095 | 645 | 9 |
166380 | 166380 | 2020-05-22 | Marshall | Alabama | 1095 | 642 | 9 |
163348 | 163348 | 2020-05-21 | Marshall | Alabama | 1095 | 643 | 9 |
160320 | 160320 | 2020-05-20 | Marshall | Alabama | 1095 | 641 | 9 |
157296 | 157296 | 2020-05-19 | Marshall | Alabama | 1095 | 638 | 9 |
154280 | 154280 | 2020-05-18 | Marshall | Alabama | 1095 | 632 | 9 |
151268 | 151268 | 2020-05-17 | Marshall | Alabama | 1095 | 624 | 9 |
148259 | 148259 | 2020-05-16 | Marshall | Alabama | 1095 | 624 | 9 |
145256 | 145256 | 2020-05-15 | Marshall | Alabama | 1095 | 612 | 9 |
142257 | 142257 | 2020-05-14 | Marshall | Alabama | 1095 | 599 | 9 |
139261 | 139261 | 2020-05-13 | Marshall | Alabama | 1095 | 586 | 9 |
136270 | 136270 | 2020-05-12 | Marshall | Alabama | 1095 | 581 | 8 |
133280 | 133280 | 2020-05-11 | Marshall | Alabama | 1095 | 576 | 8 |
130290 | 130290 | 2020-05-10 | Marshall | Alabama | 1095 | 558 | 8 |
127300 | 127300 | 2020-05-09 | Marshall | Alabama | 1095 | 543 | 8 |
124315 | 124315 | 2020-05-08 | Marshall | Alabama | 1095 | 525 | 8 |
121335 | 121335 | 2020-05-07 | Marshall | Alabama | 1095 | 487 | 8 |
118369 | 118369 | 2020-05-06 | Marshall | Alabama | 1095 | 470 | 8 |
115410 | 115410 | 2020-05-05 | Marshall | Alabama | 1095 | 439 | 8 |
112527 | 112527 | 2020-05-04 | Marshall | Alabama | 1095 | 355 | 7 |
109652 | 109652 | 2020-05-03 | Marshall | Alabama | 1095 | 342 | 7 |
106783 | 106783 | 2020-05-02 | Marshall | Alabama | 1095 | 334 | 7 |
103918 | 103918 | 2020-05-01 | Marshall | Alabama | 1095 | 328 | 7 |
101063 | 101063 | 2020-04-30 | Marshall | Alabama | 1095 | 317 | 6 |
98213 | 98213 | 2020-04-29 | Marshall | Alabama | 1095 | 316 | 6 |
95368 | 95368 | 2020-04-28 | Marshall | Alabama | 1095 | 313 | 6 |
92538 | 92538 | 2020-04-27 | Marshall | Alabama | 1095 | 310 | 5 |
89720 | 89720 | 2020-04-26 | Marshall | Alabama | 1095 | 307 | 5 |
86904 | 86904 | 2020-04-25 | Marshall | Alabama | 1095 | 279 | 5 |
84096 | 84096 | 2020-04-24 | Marshall | Alabama | 1095 | 267 | 4 |
81295 | 81295 | 2020-04-23 | Marshall | Alabama | 1095 | 258 | 4 |
78502 | 78502 | 2020-04-22 | Marshall | Alabama | 1095 | 241 | 4 |
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);