ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 28123 and state = "Mississippi" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
4796 | 4796 | 2020-03-19 | Scott | Mississippi | 28123 | 1 | 0 |
5627 | 5627 | 2020-03-20 | Scott | Mississippi | 28123 | 1 | 0 |
6610 | 6610 | 2020-03-21 | Scott | Mississippi | 28123 | 1 | 0 |
7696 | 7696 | 2020-03-22 | Scott | Mississippi | 28123 | 1 | 0 |
8878 | 8878 | 2020-03-23 | Scott | Mississippi | 28123 | 1 | 0 |
10176 | 10176 | 2020-03-24 | Scott | Mississippi | 28123 | 2 | 0 |
11597 | 11597 | 2020-03-25 | Scott | Mississippi | 28123 | 3 | 0 |
13191 | 13191 | 2020-03-26 | Scott | Mississippi | 28123 | 4 | 0 |
14910 | 14910 | 2020-03-27 | Scott | Mississippi | 28123 | 6 | 0 |
16734 | 16734 | 2020-03-28 | Scott | Mississippi | 28123 | 7 | 0 |
18656 | 18656 | 2020-03-29 | Scott | Mississippi | 28123 | 7 | 0 |
20680 | 20680 | 2020-03-30 | Scott | Mississippi | 28123 | 9 | 0 |
22797 | 22797 | 2020-03-31 | Scott | Mississippi | 28123 | 10 | 0 |
24981 | 24981 | 2020-04-01 | Scott | Mississippi | 28123 | 12 | 0 |
27235 | 27235 | 2020-04-02 | Scott | Mississippi | 28123 | 13 | 0 |
29554 | 29554 | 2020-04-03 | Scott | Mississippi | 28123 | 17 | 0 |
31934 | 31934 | 2020-04-04 | Scott | Mississippi | 28123 | 17 | 0 |
34361 | 34361 | 2020-04-05 | Scott | Mississippi | 28123 | 23 | 0 |
36824 | 36824 | 2020-04-06 | Scott | Mississippi | 28123 | 23 | 0 |
39335 | 39335 | 2020-04-07 | Scott | Mississippi | 28123 | 32 | 0 |
41889 | 41889 | 2020-04-08 | Scott | Mississippi | 28123 | 34 | 0 |
44466 | 44466 | 2020-04-09 | Scott | Mississippi | 28123 | 43 | 0 |
47075 | 47075 | 2020-04-10 | Scott | Mississippi | 28123 | 47 | 0 |
49721 | 49721 | 2020-04-11 | Scott | Mississippi | 28123 | 52 | 0 |
52394 | 52394 | 2020-04-12 | Scott | Mississippi | 28123 | 54 | 0 |
55076 | 55076 | 2020-04-13 | Scott | Mississippi | 28123 | 58 | 0 |
57774 | 57774 | 2020-04-14 | Scott | Mississippi | 28123 | 62 | 0 |
60485 | 60485 | 2020-04-15 | Scott | Mississippi | 28123 | 79 | 0 |
65947 | 65947 | 2020-04-17 | Scott | Mississippi | 28123 | 96 | 0 |
63207 | 63207 | 2020-04-16 | Scott | Mississippi | 28123 | 100 | 0 |
68699 | 68699 | 2020-04-18 | Scott | Mississippi | 28123 | 106 | 0 |
71465 | 71465 | 2020-04-19 | Scott | Mississippi | 28123 | 130 | 0 |
74238 | 74238 | 2020-04-20 | Scott | Mississippi | 28123 | 148 | 0 |
77019 | 77019 | 2020-04-21 | Scott | Mississippi | 28123 | 158 | 0 |
79804 | 79804 | 2020-04-22 | Scott | Mississippi | 28123 | 163 | 0 |
82600 | 82600 | 2020-04-23 | Scott | Mississippi | 28123 | 177 | 0 |
85404 | 85404 | 2020-04-24 | Scott | Mississippi | 28123 | 200 | 0 |
88214 | 88214 | 2020-04-25 | Scott | Mississippi | 28123 | 240 | 0 |
91030 | 91030 | 2020-04-26 | Scott | Mississippi | 28123 | 249 | 0 |
93851 | 93851 | 2020-04-27 | Scott | Mississippi | 28123 | 258 | 0 |
96687 | 96687 | 2020-04-28 | Scott | Mississippi | 28123 | 281 | 0 |
99533 | 99533 | 2020-04-29 | Scott | Mississippi | 28123 | 296 | 0 |
102385 | 102385 | 2020-04-30 | Scott | Mississippi | 28123 | 316 | 0 |
105246 | 105246 | 2020-05-01 | Scott | Mississippi | 28123 | 339 | 0 |
108111 | 108111 | 2020-05-02 | Scott | Mississippi | 28123 | 354 | 1 |
110982 | 110982 | 2020-05-03 | Scott | Mississippi | 28123 | 358 | 2 |
113861 | 113861 | 2020-05-04 | Scott | Mississippi | 28123 | 369 | 2 |
116743 | 116743 | 2020-05-05 | Scott | Mississippi | 28123 | 404 | 3 |
119703 | 119703 | 2020-05-06 | Scott | Mississippi | 28123 | 410 | 3 |
122677 | 122677 | 2020-05-07 | Scott | Mississippi | 28123 | 423 | 5 |
125659 | 125659 | 2020-05-08 | Scott | Mississippi | 28123 | 438 | 6 |
128646 | 128646 | 2020-05-09 | Scott | Mississippi | 28123 | 454 | 6 |
131636 | 131636 | 2020-05-10 | Scott | Mississippi | 28123 | 457 | 6 |
134627 | 134627 | 2020-05-11 | Scott | Mississippi | 28123 | 462 | 6 |
137617 | 137617 | 2020-05-12 | Scott | Mississippi | 28123 | 475 | 6 |
140611 | 140611 | 2020-05-13 | Scott | Mississippi | 28123 | 483 | 6 |
143606 | 143606 | 2020-05-14 | Scott | Mississippi | 28123 | 487 | 6 |
146606 | 146606 | 2020-05-15 | Scott | Mississippi | 28123 | 504 | 6 |
149611 | 149611 | 2020-05-16 | Scott | Mississippi | 28123 | 521 | 6 |
152622 | 152622 | 2020-05-17 | Scott | Mississippi | 28123 | 524 | 7 |
155636 | 155636 | 2020-05-18 | Scott | Mississippi | 28123 | 532 | 8 |
158654 | 158654 | 2020-05-19 | Scott | Mississippi | 28123 | 550 | 10 |
161680 | 161680 | 2020-05-20 | Scott | Mississippi | 28123 | 567 | 10 |
164709 | 164709 | 2020-05-21 | Scott | Mississippi | 28123 | 569 | 10 |
167745 | 167745 | 2020-05-22 | Scott | Mississippi | 28123 | 578 | 10 |
170783 | 170783 | 2020-05-23 | Scott | Mississippi | 28123 | 587 | 10 |
173825 | 173825 | 2020-05-24 | Scott | Mississippi | 28123 | 589 | 10 |
176868 | 176868 | 2020-05-25 | Scott | Mississippi | 28123 | 592 | 10 |
179912 | 179912 | 2020-05-26 | Scott | Mississippi | 28123 | 597 | 10 |
182958 | 182958 | 2020-05-27 | Scott | Mississippi | 28123 | 623 | 10 |
186014 | 186014 | 2020-05-28 | Scott | Mississippi | 28123 | 630 | 10 |
189072 | 189072 | 2020-05-29 | Scott | Mississippi | 28123 | 640 | 11 |
195204 | 195204 | 2020-05-31 | Scott | Mississippi | 28123 | 644 | 12 |
198275 | 198275 | 2020-06-01 | Scott | Mississippi | 28123 | 648 | 12 |
192136 | 192136 | 2020-05-30 | Scott | Mississippi | 28123 | 650 | 12 |
201348 | 201348 | 2020-06-02 | Scott | Mississippi | 28123 | 661 | 12 |
204425 | 204425 | 2020-06-03 | Scott | Mississippi | 28123 | 662 | 12 |
207506 | 207506 | 2020-06-04 | Scott | Mississippi | 28123 | 663 | 12 |
210587 | 210587 | 2020-06-05 | Scott | Mississippi | 28123 | 663 | 12 |
213671 | 213671 | 2020-06-06 | Scott | Mississippi | 28123 | 670 | 12 |
216759 | 216759 | 2020-06-07 | Scott | Mississippi | 28123 | 671 | 12 |
219851 | 219851 | 2020-06-08 | Scott | Mississippi | 28123 | 673 | 12 |
222946 | 222946 | 2020-06-09 | Scott | Mississippi | 28123 | 677 | 12 |
226044 | 226044 | 2020-06-10 | Scott | Mississippi | 28123 | 682 | 12 |
229146 | 229146 | 2020-06-11 | Scott | Mississippi | 28123 | 682 | 12 |
232250 | 232250 | 2020-06-12 | Scott | Mississippi | 28123 | 685 | 12 |
235356 | 235356 | 2020-06-13 | Scott | Mississippi | 28123 | 688 | 12 |
238463 | 238463 | 2020-06-14 | Scott | Mississippi | 28123 | 688 | 12 |
241572 | 241572 | 2020-06-15 | Scott | Mississippi | 28123 | 690 | 12 |
244683 | 244683 | 2020-06-16 | Scott | Mississippi | 28123 | 692 | 12 |
247796 | 247796 | 2020-06-17 | Scott | Mississippi | 28123 | 696 | 12 |
250908 | 250908 | 2020-06-18 | Scott | Mississippi | 28123 | 696 | 12 |
254023 | 254023 | 2020-06-19 | Scott | Mississippi | 28123 | 696 | 12 |
257143 | 257143 | 2020-06-20 | Scott | Mississippi | 28123 | 696 | 12 |
260269 | 260269 | 2020-06-21 | Scott | Mississippi | 28123 | 696 | 12 |
263398 | 263398 | 2020-06-22 | Scott | Mississippi | 28123 | 700 | 14 |
266524 | 266524 | 2020-06-23 | Scott | Mississippi | 28123 | 707 | 14 |
269657 | 269657 | 2020-06-24 | Scott | Mississippi | 28123 | 709 | 14 |
272795 | 272795 | 2020-06-25 | Scott | Mississippi | 28123 | 721 | 14 |
275938 | 275938 | 2020-06-26 | Scott | Mississippi | 28123 | 723 | 14 |
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);