ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 28155 and state = "Mississippi" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
7706 | 7706 | 2020-03-22 | Webster | Mississippi | 28155 | 1 | 0 |
8889 | 8889 | 2020-03-23 | Webster | Mississippi | 28155 | 1 | 0 |
10187 | 10187 | 2020-03-24 | Webster | Mississippi | 28155 | 2 | 0 |
11608 | 11608 | 2020-03-25 | Webster | Mississippi | 28155 | 2 | 1 |
13202 | 13202 | 2020-03-26 | Webster | Mississippi | 28155 | 2 | 1 |
14923 | 14923 | 2020-03-27 | Webster | Mississippi | 28155 | 3 | 1 |
16747 | 16747 | 2020-03-28 | Webster | Mississippi | 28155 | 3 | 1 |
18669 | 18669 | 2020-03-29 | Webster | Mississippi | 28155 | 3 | 1 |
20693 | 20693 | 2020-03-30 | Webster | Mississippi | 28155 | 5 | 1 |
22811 | 22811 | 2020-03-31 | Webster | Mississippi | 28155 | 5 | 1 |
24995 | 24995 | 2020-04-01 | Webster | Mississippi | 28155 | 7 | 1 |
27250 | 27250 | 2020-04-02 | Webster | Mississippi | 28155 | 8 | 1 |
29569 | 29569 | 2020-04-03 | Webster | Mississippi | 28155 | 8 | 1 |
31949 | 31949 | 2020-04-04 | Webster | Mississippi | 28155 | 11 | 1 |
34377 | 34377 | 2020-04-05 | Webster | Mississippi | 28155 | 11 | 1 |
36840 | 36840 | 2020-04-06 | Webster | Mississippi | 28155 | 12 | 1 |
39351 | 39351 | 2020-04-07 | Webster | Mississippi | 28155 | 12 | 1 |
41905 | 41905 | 2020-04-08 | Webster | Mississippi | 28155 | 13 | 1 |
44482 | 44482 | 2020-04-09 | Webster | Mississippi | 28155 | 13 | 1 |
47091 | 47091 | 2020-04-10 | Webster | Mississippi | 28155 | 13 | 1 |
49737 | 49737 | 2020-04-11 | Webster | Mississippi | 28155 | 14 | 1 |
52410 | 52410 | 2020-04-12 | Webster | Mississippi | 28155 | 14 | 1 |
55092 | 55092 | 2020-04-13 | Webster | Mississippi | 28155 | 14 | 1 |
57790 | 57790 | 2020-04-14 | Webster | Mississippi | 28155 | 14 | 1 |
60501 | 60501 | 2020-04-15 | Webster | Mississippi | 28155 | 14 | 1 |
63223 | 63223 | 2020-04-16 | Webster | Mississippi | 28155 | 15 | 1 |
65963 | 65963 | 2020-04-17 | Webster | Mississippi | 28155 | 17 | 1 |
68715 | 68715 | 2020-04-18 | Webster | Mississippi | 28155 | 15 | 1 |
71481 | 71481 | 2020-04-19 | Webster | Mississippi | 28155 | 15 | 1 |
74254 | 74254 | 2020-04-20 | Webster | Mississippi | 28155 | 15 | 1 |
77035 | 77035 | 2020-04-21 | Webster | Mississippi | 28155 | 16 | 1 |
79820 | 79820 | 2020-04-22 | Webster | Mississippi | 28155 | 16 | 1 |
82616 | 82616 | 2020-04-23 | Webster | Mississippi | 28155 | 16 | 1 |
85420 | 85420 | 2020-04-24 | Webster | Mississippi | 28155 | 17 | 1 |
88230 | 88230 | 2020-04-25 | Webster | Mississippi | 28155 | 16 | 1 |
91046 | 91046 | 2020-04-26 | Webster | Mississippi | 28155 | 16 | 1 |
93867 | 93867 | 2020-04-27 | Webster | Mississippi | 28155 | 16 | 1 |
96703 | 96703 | 2020-04-28 | Webster | Mississippi | 28155 | 17 | 1 |
99549 | 99549 | 2020-04-29 | Webster | Mississippi | 28155 | 17 | 1 |
102401 | 102401 | 2020-04-30 | Webster | Mississippi | 28155 | 18 | 1 |
105262 | 105262 | 2020-05-01 | Webster | Mississippi | 28155 | 19 | 1 |
108127 | 108127 | 2020-05-02 | Webster | Mississippi | 28155 | 19 | 1 |
110998 | 110998 | 2020-05-03 | Webster | Mississippi | 28155 | 19 | 1 |
113877 | 113877 | 2020-05-04 | Webster | Mississippi | 28155 | 20 | 1 |
116759 | 116759 | 2020-05-05 | Webster | Mississippi | 28155 | 21 | 1 |
119719 | 119719 | 2020-05-06 | Webster | Mississippi | 28155 | 21 | 1 |
122693 | 122693 | 2020-05-07 | Webster | Mississippi | 28155 | 21 | 1 |
125675 | 125675 | 2020-05-08 | Webster | Mississippi | 28155 | 21 | 1 |
128662 | 128662 | 2020-05-09 | Webster | Mississippi | 28155 | 21 | 1 |
131652 | 131652 | 2020-05-10 | Webster | Mississippi | 28155 | 22 | 1 |
134643 | 134643 | 2020-05-11 | Webster | Mississippi | 28155 | 22 | 1 |
137633 | 137633 | 2020-05-12 | Webster | Mississippi | 28155 | 22 | 1 |
140627 | 140627 | 2020-05-13 | Webster | Mississippi | 28155 | 22 | 1 |
143622 | 143622 | 2020-05-14 | Webster | Mississippi | 28155 | 22 | 1 |
146622 | 146622 | 2020-05-15 | Webster | Mississippi | 28155 | 22 | 1 |
149627 | 149627 | 2020-05-16 | Webster | Mississippi | 28155 | 23 | 1 |
152638 | 152638 | 2020-05-17 | Webster | Mississippi | 28155 | 23 | 1 |
155652 | 155652 | 2020-05-18 | Webster | Mississippi | 28155 | 22 | 1 |
158670 | 158670 | 2020-05-19 | Webster | Mississippi | 28155 | 22 | 1 |
161696 | 161696 | 2020-05-20 | Webster | Mississippi | 28155 | 22 | 1 |
164725 | 164725 | 2020-05-21 | Webster | Mississippi | 28155 | 25 | 1 |
167761 | 167761 | 2020-05-22 | Webster | Mississippi | 28155 | 27 | 1 |
170799 | 170799 | 2020-05-23 | Webster | Mississippi | 28155 | 27 | 1 |
173841 | 173841 | 2020-05-24 | Webster | Mississippi | 28155 | 27 | 1 |
176884 | 176884 | 2020-05-25 | Webster | Mississippi | 28155 | 28 | 1 |
179928 | 179928 | 2020-05-26 | Webster | Mississippi | 28155 | 63 | 1 |
182974 | 182974 | 2020-05-27 | Webster | Mississippi | 28155 | 59 | 1 |
186030 | 186030 | 2020-05-28 | Webster | Mississippi | 28155 | 61 | 1 |
189088 | 189088 | 2020-05-29 | Webster | Mississippi | 28155 | 64 | 1 |
192152 | 192152 | 2020-05-30 | Webster | Mississippi | 28155 | 69 | 1 |
195220 | 195220 | 2020-05-31 | Webster | Mississippi | 28155 | 69 | 2 |
198291 | 198291 | 2020-06-01 | Webster | Mississippi | 28155 | 68 | 2 |
201364 | 201364 | 2020-06-02 | Webster | Mississippi | 28155 | 67 | 3 |
204441 | 204441 | 2020-06-03 | Webster | Mississippi | 28155 | 67 | 3 |
207522 | 207522 | 2020-06-04 | Webster | Mississippi | 28155 | 84 | 4 |
210603 | 210603 | 2020-06-05 | Webster | Mississippi | 28155 | 88 | 5 |
213687 | 213687 | 2020-06-06 | Webster | Mississippi | 28155 | 93 | 5 |
216775 | 216775 | 2020-06-07 | Webster | Mississippi | 28155 | 96 | 5 |
219867 | 219867 | 2020-06-08 | Webster | Mississippi | 28155 | 98 | 6 |
222962 | 222962 | 2020-06-09 | Webster | Mississippi | 28155 | 98 | 7 |
226060 | 226060 | 2020-06-10 | Webster | Mississippi | 28155 | 99 | 8 |
229162 | 229162 | 2020-06-11 | Webster | Mississippi | 28155 | 99 | 8 |
232266 | 232266 | 2020-06-12 | Webster | Mississippi | 28155 | 109 | 8 |
235372 | 235372 | 2020-06-13 | Webster | Mississippi | 28155 | 109 | 8 |
238479 | 238479 | 2020-06-14 | Webster | Mississippi | 28155 | 110 | 8 |
241588 | 241588 | 2020-06-15 | Webster | Mississippi | 28155 | 109 | 8 |
244699 | 244699 | 2020-06-16 | Webster | Mississippi | 28155 | 109 | 8 |
247812 | 247812 | 2020-06-17 | Webster | Mississippi | 28155 | 109 | 8 |
250925 | 250925 | 2020-06-18 | Webster | Mississippi | 28155 | 109 | 8 |
254040 | 254040 | 2020-06-19 | Webster | Mississippi | 28155 | 109 | 8 |
257160 | 257160 | 2020-06-20 | Webster | Mississippi | 28155 | 109 | 8 |
260286 | 260286 | 2020-06-21 | Webster | Mississippi | 28155 | 109 | 8 |
263414 | 263414 | 2020-06-22 | Webster | Mississippi | 28155 | 118 | 10 |
266540 | 266540 | 2020-06-23 | Webster | Mississippi | 28155 | 122 | 10 |
269673 | 269673 | 2020-06-24 | Webster | Mississippi | 28155 | 124 | 10 |
272811 | 272811 | 2020-06-25 | Webster | Mississippi | 28155 | 124 | 10 |
275954 | 275954 | 2020-06-26 | Webster | Mississippi | 28155 | 124 | 10 |
279102 | 279102 | 2020-06-27 | Webster | Mississippi | 28155 | 123 | 10 |
282250 | 282250 | 2020-06-28 | Webster | Mississippi | 28155 | 123 | 10 |
285395 | 285395 | 2020-06-29 | Webster | Mississippi | 28155 | 122 | 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);