ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 28049 and state = "Mississippi" sorted by county descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2529 | 2529 | 2020-03-15 | Hinds | Mississippi | 28049 | 2 | 0 |
2982 | 2982 | 2020-03-16 | Hinds | Mississippi | 28049 | 2 | 0 |
3488 | 3488 | 2020-03-17 | Hinds | Mississippi | 28049 | 6 | 0 |
4075 | 4075 | 2020-03-18 | Hinds | Mississippi | 28049 | 6 | 0 |
4787 | 4787 | 2020-03-19 | Hinds | Mississippi | 28049 | 6 | 0 |
5611 | 5611 | 2020-03-20 | Hinds | Mississippi | 28049 | 7 | 0 |
6589 | 6589 | 2020-03-21 | Hinds | Mississippi | 28049 | 14 | 0 |
7672 | 7672 | 2020-03-22 | Hinds | Mississippi | 28049 | 20 | 0 |
8852 | 8852 | 2020-03-23 | Hinds | Mississippi | 28049 | 24 | 0 |
10148 | 10148 | 2020-03-24 | Hinds | Mississippi | 28049 | 31 | 0 |
11568 | 11568 | 2020-03-25 | Hinds | Mississippi | 28049 | 38 | 0 |
13160 | 13160 | 2020-03-26 | Hinds | Mississippi | 28049 | 43 | 0 |
14876 | 14876 | 2020-03-27 | Hinds | Mississippi | 28049 | 50 | 0 |
16700 | 16700 | 2020-03-28 | Hinds | Mississippi | 28049 | 58 | 0 |
18622 | 18622 | 2020-03-29 | Hinds | Mississippi | 28049 | 66 | 0 |
20646 | 20646 | 2020-03-30 | Hinds | Mississippi | 28049 | 74 | 0 |
22763 | 22763 | 2020-03-31 | Hinds | Mississippi | 28049 | 90 | 0 |
24946 | 24946 | 2020-04-01 | Hinds | Mississippi | 28049 | 109 | 0 |
27200 | 27200 | 2020-04-02 | Hinds | Mississippi | 28049 | 118 | 0 |
29519 | 29519 | 2020-04-03 | Hinds | Mississippi | 28049 | 139 | 0 |
31899 | 31899 | 2020-04-04 | Hinds | Mississippi | 28049 | 140 | 0 |
34326 | 34326 | 2020-04-05 | Hinds | Mississippi | 28049 | 154 | 0 |
36789 | 36789 | 2020-04-06 | Hinds | Mississippi | 28049 | 158 | 0 |
39300 | 39300 | 2020-04-07 | Hinds | Mississippi | 28049 | 169 | 0 |
41854 | 41854 | 2020-04-08 | Hinds | Mississippi | 28049 | 178 | 1 |
44430 | 44430 | 2020-04-09 | Hinds | Mississippi | 28049 | 203 | 2 |
47039 | 47039 | 2020-04-10 | Hinds | Mississippi | 28049 | 219 | 2 |
49685 | 49685 | 2020-04-11 | Hinds | Mississippi | 28049 | 234 | 2 |
52358 | 52358 | 2020-04-12 | Hinds | Mississippi | 28049 | 247 | 2 |
55040 | 55040 | 2020-04-13 | Hinds | Mississippi | 28049 | 259 | 2 |
57738 | 57738 | 2020-04-14 | Hinds | Mississippi | 28049 | 263 | 2 |
60449 | 60449 | 2020-04-15 | Hinds | Mississippi | 28049 | 280 | 4 |
63171 | 63171 | 2020-04-16 | Hinds | Mississippi | 28049 | 301 | 4 |
65911 | 65911 | 2020-04-17 | Hinds | Mississippi | 28049 | 314 | 5 |
68663 | 68663 | 2020-04-18 | Hinds | Mississippi | 28049 | 325 | 5 |
71429 | 71429 | 2020-04-19 | Hinds | Mississippi | 28049 | 337 | 5 |
74202 | 74202 | 2020-04-20 | Hinds | Mississippi | 28049 | 347 | 5 |
76983 | 76983 | 2020-04-21 | Hinds | Mississippi | 28049 | 357 | 6 |
79768 | 79768 | 2020-04-22 | Hinds | Mississippi | 28049 | 377 | 6 |
82564 | 82564 | 2020-04-23 | Hinds | Mississippi | 28049 | 383 | 6 |
85368 | 85368 | 2020-04-24 | Hinds | Mississippi | 28049 | 401 | 6 |
88178 | 88178 | 2020-04-25 | Hinds | Mississippi | 28049 | 412 | 7 |
90994 | 90994 | 2020-04-26 | Hinds | Mississippi | 28049 | 415 | 7 |
93815 | 93815 | 2020-04-27 | Hinds | Mississippi | 28049 | 421 | 7 |
96651 | 96651 | 2020-04-28 | Hinds | Mississippi | 28049 | 435 | 7 |
99497 | 99497 | 2020-04-29 | Hinds | Mississippi | 28049 | 450 | 7 |
102349 | 102349 | 2020-04-30 | Hinds | Mississippi | 28049 | 470 | 8 |
105210 | 105210 | 2020-05-01 | Hinds | Mississippi | 28049 | 496 | 8 |
108075 | 108075 | 2020-05-02 | Hinds | Mississippi | 28049 | 505 | 8 |
110946 | 110946 | 2020-05-03 | Hinds | Mississippi | 28049 | 507 | 8 |
113825 | 113825 | 2020-05-04 | Hinds | Mississippi | 28049 | 542 | 9 |
116707 | 116707 | 2020-05-05 | Hinds | Mississippi | 28049 | 565 | 9 |
119667 | 119667 | 2020-05-06 | Hinds | Mississippi | 28049 | 588 | 11 |
122641 | 122641 | 2020-05-07 | Hinds | Mississippi | 28049 | 600 | 11 |
125623 | 125623 | 2020-05-08 | Hinds | Mississippi | 28049 | 657 | 11 |
128610 | 128610 | 2020-05-09 | Hinds | Mississippi | 28049 | 663 | 15 |
131600 | 131600 | 2020-05-10 | Hinds | Mississippi | 28049 | 670 | 15 |
134591 | 134591 | 2020-05-11 | Hinds | Mississippi | 28049 | 675 | 15 |
137581 | 137581 | 2020-05-12 | Hinds | Mississippi | 28049 | 681 | 17 |
140575 | 140575 | 2020-05-13 | Hinds | Mississippi | 28049 | 698 | 17 |
143570 | 143570 | 2020-05-14 | Hinds | Mississippi | 28049 | 717 | 18 |
146570 | 146570 | 2020-05-15 | Hinds | Mississippi | 28049 | 745 | 20 |
149575 | 149575 | 2020-05-16 | Hinds | Mississippi | 28049 | 768 | 22 |
152586 | 152586 | 2020-05-17 | Hinds | Mississippi | 28049 | 773 | 22 |
155600 | 155600 | 2020-05-18 | Hinds | Mississippi | 28049 | 772 | 22 |
158618 | 158618 | 2020-05-19 | Hinds | Mississippi | 28049 | 786 | 22 |
161644 | 161644 | 2020-05-20 | Hinds | Mississippi | 28049 | 800 | 23 |
164673 | 164673 | 2020-05-21 | Hinds | Mississippi | 28049 | 825 | 24 |
167709 | 167709 | 2020-05-22 | Hinds | Mississippi | 28049 | 855 | 24 |
170747 | 170747 | 2020-05-23 | Hinds | Mississippi | 28049 | 877 | 24 |
173789 | 173789 | 2020-05-24 | Hinds | Mississippi | 28049 | 893 | 24 |
176832 | 176832 | 2020-05-25 | Hinds | Mississippi | 28049 | 898 | 24 |
179876 | 179876 | 2020-05-26 | Hinds | Mississippi | 28049 | 904 | 24 |
182922 | 182922 | 2020-05-27 | Hinds | Mississippi | 28049 | 920 | 24 |
185978 | 185978 | 2020-05-28 | Hinds | Mississippi | 28049 | 959 | 24 |
189036 | 189036 | 2020-05-29 | Hinds | Mississippi | 28049 | 971 | 25 |
192100 | 192100 | 2020-05-30 | Hinds | Mississippi | 28049 | 999 | 25 |
195168 | 195168 | 2020-05-31 | Hinds | Mississippi | 28049 | 1006 | 25 |
198239 | 198239 | 2020-06-01 | Hinds | Mississippi | 28049 | 1028 | 26 |
201312 | 201312 | 2020-06-02 | Hinds | Mississippi | 28049 | 1035 | 26 |
204389 | 204389 | 2020-06-03 | Hinds | Mississippi | 28049 | 1066 | 26 |
207470 | 207470 | 2020-06-04 | Hinds | Mississippi | 28049 | 1074 | 26 |
210551 | 210551 | 2020-06-05 | Hinds | Mississippi | 28049 | 1104 | 26 |
213635 | 213635 | 2020-06-06 | Hinds | Mississippi | 28049 | 1111 | 26 |
216723 | 216723 | 2020-06-07 | Hinds | Mississippi | 28049 | 1137 | 26 |
219815 | 219815 | 2020-06-08 | Hinds | Mississippi | 28049 | 1164 | 26 |
222910 | 222910 | 2020-06-09 | Hinds | Mississippi | 28049 | 1186 | 26 |
226008 | 226008 | 2020-06-10 | Hinds | Mississippi | 28049 | 1206 | 26 |
229110 | 229110 | 2020-06-11 | Hinds | Mississippi | 28049 | 1206 | 26 |
232214 | 232214 | 2020-06-12 | Hinds | Mississippi | 28049 | 1245 | 27 |
235320 | 235320 | 2020-06-13 | Hinds | Mississippi | 28049 | 1263 | 27 |
238427 | 238427 | 2020-06-14 | Hinds | Mississippi | 28049 | 1274 | 27 |
241536 | 241536 | 2020-06-15 | Hinds | Mississippi | 28049 | 1308 | 27 |
244647 | 244647 | 2020-06-16 | Hinds | Mississippi | 28049 | 1349 | 28 |
247760 | 247760 | 2020-06-17 | Hinds | Mississippi | 28049 | 1390 | 29 |
250872 | 250872 | 2020-06-18 | Hinds | Mississippi | 28049 | 1390 | 29 |
253987 | 253987 | 2020-06-19 | Hinds | Mississippi | 28049 | 1390 | 29 |
257107 | 257107 | 2020-06-20 | Hinds | Mississippi | 28049 | 1390 | 29 |
260233 | 260233 | 2020-06-21 | Hinds | Mississippi | 28049 | 1390 | 29 |
263362 | 263362 | 2020-06-22 | Hinds | Mississippi | 28049 | 1536 | 33 |
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);