ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Scott" and fips = 28123 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387408 | 387408 | 2020-07-31 | Scott | Mississippi | 28123 | 947 | 17 |
384190 | 384190 | 2020-07-30 | Scott | Mississippi | 28123 | 944 | 17 |
380973 | 380973 | 2020-07-29 | Scott | Mississippi | 28123 | 941 | 17 |
377756 | 377756 | 2020-07-28 | Scott | Mississippi | 28123 | 936 | 17 |
374541 | 374541 | 2020-07-27 | Scott | Mississippi | 28123 | 932 | 16 |
371329 | 371329 | 2020-07-26 | Scott | Mississippi | 28123 | 930 | 16 |
368119 | 368119 | 2020-07-25 | Scott | Mississippi | 28123 | 926 | 16 |
364911 | 364911 | 2020-07-24 | Scott | Mississippi | 28123 | 919 | 16 |
361704 | 361704 | 2020-07-23 | Scott | Mississippi | 28123 | 917 | 16 |
358499 | 358499 | 2020-07-22 | Scott | Mississippi | 28123 | 911 | 16 |
355296 | 355296 | 2020-07-21 | Scott | Mississippi | 28123 | 901 | 16 |
352094 | 352094 | 2020-07-20 | Scott | Mississippi | 28123 | 886 | 16 |
348894 | 348894 | 2020-07-19 | Scott | Mississippi | 28123 | 873 | 16 |
345693 | 345693 | 2020-07-18 | Scott | Mississippi | 28123 | 872 | 16 |
342493 | 342493 | 2020-07-17 | Scott | Mississippi | 28123 | 848 | 16 |
339297 | 339297 | 2020-07-16 | Scott | Mississippi | 28123 | 847 | 15 |
336101 | 336101 | 2020-07-15 | Scott | Mississippi | 28123 | 843 | 15 |
332908 | 332908 | 2020-07-14 | Scott | Mississippi | 28123 | 837 | 15 |
329721 | 329721 | 2020-07-13 | Scott | Mississippi | 28123 | 831 | 15 |
326535 | 326535 | 2020-07-12 | Scott | Mississippi | 28123 | 824 | 15 |
323352 | 323352 | 2020-07-11 | Scott | Mississippi | 28123 | 819 | 15 |
320173 | 320173 | 2020-07-10 | Scott | Mississippi | 28123 | 809 | 15 |
316998 | 316998 | 2020-07-09 | Scott | Mississippi | 28123 | 792 | 15 |
313824 | 313824 | 2020-07-08 | Scott | Mississippi | 28123 | 785 | 15 |
310654 | 310654 | 2020-07-07 | Scott | Mississippi | 28123 | 779 | 15 |
307486 | 307486 | 2020-07-06 | Scott | Mississippi | 28123 | 773 | 15 |
304319 | 304319 | 2020-07-05 | Scott | Mississippi | 28123 | 771 | 15 |
301155 | 301155 | 2020-07-04 | Scott | Mississippi | 28123 | 770 | 15 |
297992 | 297992 | 2020-07-03 | Scott | Mississippi | 28123 | 762 | 15 |
294834 | 294834 | 2020-07-02 | Scott | Mississippi | 28123 | 757 | 15 |
291680 | 291680 | 2020-07-01 | Scott | Mississippi | 28123 | 750 | 15 |
288529 | 288529 | 2020-06-30 | Scott | Mississippi | 28123 | 742 | 15 |
285379 | 285379 | 2020-06-29 | Scott | Mississippi | 28123 | 733 | 15 |
282234 | 282234 | 2020-06-28 | Scott | Mississippi | 28123 | 726 | 14 |
279086 | 279086 | 2020-06-27 | Scott | Mississippi | 28123 | 725 | 14 |
275938 | 275938 | 2020-06-26 | Scott | Mississippi | 28123 | 723 | 14 |
272795 | 272795 | 2020-06-25 | Scott | Mississippi | 28123 | 721 | 14 |
269657 | 269657 | 2020-06-24 | Scott | Mississippi | 28123 | 709 | 14 |
266524 | 266524 | 2020-06-23 | Scott | Mississippi | 28123 | 707 | 14 |
263398 | 263398 | 2020-06-22 | Scott | Mississippi | 28123 | 700 | 14 |
260269 | 260269 | 2020-06-21 | Scott | Mississippi | 28123 | 696 | 12 |
257143 | 257143 | 2020-06-20 | Scott | Mississippi | 28123 | 696 | 12 |
254023 | 254023 | 2020-06-19 | Scott | Mississippi | 28123 | 696 | 12 |
250908 | 250908 | 2020-06-18 | Scott | Mississippi | 28123 | 696 | 12 |
247796 | 247796 | 2020-06-17 | Scott | Mississippi | 28123 | 696 | 12 |
244683 | 244683 | 2020-06-16 | Scott | Mississippi | 28123 | 692 | 12 |
241572 | 241572 | 2020-06-15 | Scott | Mississippi | 28123 | 690 | 12 |
238463 | 238463 | 2020-06-14 | Scott | Mississippi | 28123 | 688 | 12 |
235356 | 235356 | 2020-06-13 | Scott | Mississippi | 28123 | 688 | 12 |
232250 | 232250 | 2020-06-12 | Scott | Mississippi | 28123 | 685 | 12 |
229146 | 229146 | 2020-06-11 | Scott | Mississippi | 28123 | 682 | 12 |
226044 | 226044 | 2020-06-10 | Scott | Mississippi | 28123 | 682 | 12 |
222946 | 222946 | 2020-06-09 | Scott | Mississippi | 28123 | 677 | 12 |
219851 | 219851 | 2020-06-08 | Scott | Mississippi | 28123 | 673 | 12 |
216759 | 216759 | 2020-06-07 | Scott | Mississippi | 28123 | 671 | 12 |
213671 | 213671 | 2020-06-06 | Scott | Mississippi | 28123 | 670 | 12 |
210587 | 210587 | 2020-06-05 | Scott | Mississippi | 28123 | 663 | 12 |
207506 | 207506 | 2020-06-04 | Scott | Mississippi | 28123 | 663 | 12 |
204425 | 204425 | 2020-06-03 | Scott | Mississippi | 28123 | 662 | 12 |
201348 | 201348 | 2020-06-02 | Scott | Mississippi | 28123 | 661 | 12 |
198275 | 198275 | 2020-06-01 | Scott | Mississippi | 28123 | 648 | 12 |
195204 | 195204 | 2020-05-31 | Scott | Mississippi | 28123 | 644 | 12 |
192136 | 192136 | 2020-05-30 | Scott | Mississippi | 28123 | 650 | 12 |
189072 | 189072 | 2020-05-29 | Scott | Mississippi | 28123 | 640 | 11 |
186014 | 186014 | 2020-05-28 | Scott | Mississippi | 28123 | 630 | 10 |
182958 | 182958 | 2020-05-27 | Scott | Mississippi | 28123 | 623 | 10 |
179912 | 179912 | 2020-05-26 | Scott | Mississippi | 28123 | 597 | 10 |
176868 | 176868 | 2020-05-25 | Scott | Mississippi | 28123 | 592 | 10 |
173825 | 173825 | 2020-05-24 | Scott | Mississippi | 28123 | 589 | 10 |
170783 | 170783 | 2020-05-23 | Scott | Mississippi | 28123 | 587 | 10 |
167745 | 167745 | 2020-05-22 | Scott | Mississippi | 28123 | 578 | 10 |
164709 | 164709 | 2020-05-21 | Scott | Mississippi | 28123 | 569 | 10 |
161680 | 161680 | 2020-05-20 | Scott | Mississippi | 28123 | 567 | 10 |
158654 | 158654 | 2020-05-19 | Scott | Mississippi | 28123 | 550 | 10 |
155636 | 155636 | 2020-05-18 | Scott | Mississippi | 28123 | 532 | 8 |
152622 | 152622 | 2020-05-17 | Scott | Mississippi | 28123 | 524 | 7 |
149611 | 149611 | 2020-05-16 | Scott | Mississippi | 28123 | 521 | 6 |
146606 | 146606 | 2020-05-15 | Scott | Mississippi | 28123 | 504 | 6 |
143606 | 143606 | 2020-05-14 | Scott | Mississippi | 28123 | 487 | 6 |
140611 | 140611 | 2020-05-13 | Scott | Mississippi | 28123 | 483 | 6 |
137617 | 137617 | 2020-05-12 | Scott | Mississippi | 28123 | 475 | 6 |
134627 | 134627 | 2020-05-11 | Scott | Mississippi | 28123 | 462 | 6 |
131636 | 131636 | 2020-05-10 | Scott | Mississippi | 28123 | 457 | 6 |
128646 | 128646 | 2020-05-09 | Scott | Mississippi | 28123 | 454 | 6 |
125659 | 125659 | 2020-05-08 | Scott | Mississippi | 28123 | 438 | 6 |
122677 | 122677 | 2020-05-07 | Scott | Mississippi | 28123 | 423 | 5 |
119703 | 119703 | 2020-05-06 | Scott | Mississippi | 28123 | 410 | 3 |
116743 | 116743 | 2020-05-05 | Scott | Mississippi | 28123 | 404 | 3 |
113861 | 113861 | 2020-05-04 | Scott | Mississippi | 28123 | 369 | 2 |
110982 | 110982 | 2020-05-03 | Scott | Mississippi | 28123 | 358 | 2 |
108111 | 108111 | 2020-05-02 | Scott | Mississippi | 28123 | 354 | 1 |
105246 | 105246 | 2020-05-01 | Scott | Mississippi | 28123 | 339 | 0 |
102385 | 102385 | 2020-04-30 | Scott | Mississippi | 28123 | 316 | 0 |
99533 | 99533 | 2020-04-29 | Scott | Mississippi | 28123 | 296 | 0 |
96687 | 96687 | 2020-04-28 | Scott | Mississippi | 28123 | 281 | 0 |
93851 | 93851 | 2020-04-27 | Scott | Mississippi | 28123 | 258 | 0 |
91030 | 91030 | 2020-04-26 | Scott | Mississippi | 28123 | 249 | 0 |
88214 | 88214 | 2020-04-25 | Scott | Mississippi | 28123 | 240 | 0 |
85404 | 85404 | 2020-04-24 | Scott | Mississippi | 28123 | 200 | 0 |
82600 | 82600 | 2020-04-23 | Scott | Mississippi | 28123 | 177 | 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);