ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Monroe", fips = 28095 and state = "Mississippi" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
2984 | 2984 | 2020-03-16 | Monroe | Mississippi | 28095 | 1 | 0 |
3491 | 3491 | 2020-03-17 | Monroe | Mississippi | 28095 | 1 | 0 |
4079 | 4079 | 2020-03-18 | Monroe | Mississippi | 28095 | 1 | 0 |
4793 | 4793 | 2020-03-19 | Monroe | Mississippi | 28095 | 1 | 0 |
5622 | 5622 | 2020-03-20 | Monroe | Mississippi | 28095 | 2 | 0 |
6604 | 6604 | 2020-03-21 | Monroe | Mississippi | 28095 | 2 | 0 |
7687 | 7687 | 2020-03-22 | Monroe | Mississippi | 28095 | 2 | 0 |
8869 | 8869 | 2020-03-23 | Monroe | Mississippi | 28095 | 2 | 0 |
10165 | 10165 | 2020-03-24 | Monroe | Mississippi | 28095 | 3 | 0 |
11585 | 11585 | 2020-03-25 | Monroe | Mississippi | 28095 | 3 | 0 |
13178 | 13178 | 2020-03-26 | Monroe | Mississippi | 28095 | 3 | 0 |
14896 | 14896 | 2020-03-27 | Monroe | Mississippi | 28095 | 3 | 0 |
16720 | 16720 | 2020-03-28 | Monroe | Mississippi | 28095 | 3 | 0 |
18642 | 18642 | 2020-03-29 | Monroe | Mississippi | 28095 | 5 | 0 |
20666 | 20666 | 2020-03-30 | Monroe | Mississippi | 28095 | 5 | 0 |
22783 | 22783 | 2020-03-31 | Monroe | Mississippi | 28095 | 6 | 0 |
24967 | 24967 | 2020-04-01 | Monroe | Mississippi | 28095 | 7 | 0 |
27221 | 27221 | 2020-04-02 | Monroe | Mississippi | 28095 | 11 | 1 |
29540 | 29540 | 2020-04-03 | Monroe | Mississippi | 28095 | 12 | 1 |
31920 | 31920 | 2020-04-04 | Monroe | Mississippi | 28095 | 12 | 1 |
34347 | 34347 | 2020-04-05 | Monroe | Mississippi | 28095 | 13 | 1 |
36810 | 36810 | 2020-04-06 | Monroe | Mississippi | 28095 | 16 | 1 |
39321 | 39321 | 2020-04-07 | Monroe | Mississippi | 28095 | 18 | 1 |
41875 | 41875 | 2020-04-08 | Monroe | Mississippi | 28095 | 19 | 1 |
44452 | 44452 | 2020-04-09 | Monroe | Mississippi | 28095 | 24 | 1 |
47061 | 47061 | 2020-04-10 | Monroe | Mississippi | 28095 | 25 | 1 |
49707 | 49707 | 2020-04-11 | Monroe | Mississippi | 28095 | 31 | 2 |
52380 | 52380 | 2020-04-12 | Monroe | Mississippi | 28095 | 36 | 2 |
55062 | 55062 | 2020-04-13 | Monroe | Mississippi | 28095 | 37 | 2 |
57760 | 57760 | 2020-04-14 | Monroe | Mississippi | 28095 | 38 | 2 |
60471 | 60471 | 2020-04-15 | Monroe | Mississippi | 28095 | 46 | 2 |
63193 | 63193 | 2020-04-16 | Monroe | Mississippi | 28095 | 54 | 3 |
65933 | 65933 | 2020-04-17 | Monroe | Mississippi | 28095 | 58 | 3 |
68685 | 68685 | 2020-04-18 | Monroe | Mississippi | 28095 | 62 | 4 |
71451 | 71451 | 2020-04-19 | Monroe | Mississippi | 28095 | 68 | 5 |
74224 | 74224 | 2020-04-20 | Monroe | Mississippi | 28095 | 75 | 5 |
77005 | 77005 | 2020-04-21 | Monroe | Mississippi | 28095 | 95 | 8 |
79790 | 79790 | 2020-04-22 | Monroe | Mississippi | 28095 | 99 | 9 |
82586 | 82586 | 2020-04-23 | Monroe | Mississippi | 28095 | 109 | 9 |
85390 | 85390 | 2020-04-24 | Monroe | Mississippi | 28095 | 117 | 9 |
88200 | 88200 | 2020-04-25 | Monroe | Mississippi | 28095 | 123 | 9 |
91016 | 91016 | 2020-04-26 | Monroe | Mississippi | 28095 | 134 | 9 |
93837 | 93837 | 2020-04-27 | Monroe | Mississippi | 28095 | 144 | 9 |
96673 | 96673 | 2020-04-28 | Monroe | Mississippi | 28095 | 153 | 12 |
99519 | 99519 | 2020-04-29 | Monroe | Mississippi | 28095 | 157 | 13 |
102371 | 102371 | 2020-04-30 | Monroe | Mississippi | 28095 | 157 | 14 |
105232 | 105232 | 2020-05-01 | Monroe | Mississippi | 28095 | 161 | 16 |
108097 | 108097 | 2020-05-02 | Monroe | Mississippi | 28095 | 173 | 16 |
110968 | 110968 | 2020-05-03 | Monroe | Mississippi | 28095 | 175 | 16 |
113847 | 113847 | 2020-05-04 | Monroe | Mississippi | 28095 | 175 | 16 |
116729 | 116729 | 2020-05-05 | Monroe | Mississippi | 28095 | 177 | 16 |
119689 | 119689 | 2020-05-06 | Monroe | Mississippi | 28095 | 178 | 20 |
122663 | 122663 | 2020-05-07 | Monroe | Mississippi | 28095 | 188 | 20 |
125645 | 125645 | 2020-05-08 | Monroe | Mississippi | 28095 | 191 | 20 |
128632 | 128632 | 2020-05-09 | Monroe | Mississippi | 28095 | 200 | 20 |
131622 | 131622 | 2020-05-10 | Monroe | Mississippi | 28095 | 199 | 21 |
134613 | 134613 | 2020-05-11 | Monroe | Mississippi | 28095 | 199 | 21 |
137603 | 137603 | 2020-05-12 | Monroe | Mississippi | 28095 | 202 | 21 |
140597 | 140597 | 2020-05-13 | Monroe | Mississippi | 28095 | 203 | 21 |
143592 | 143592 | 2020-05-14 | Monroe | Mississippi | 28095 | 209 | 22 |
146592 | 146592 | 2020-05-15 | Monroe | Mississippi | 28095 | 215 | 23 |
149597 | 149597 | 2020-05-16 | Monroe | Mississippi | 28095 | 222 | 23 |
152608 | 152608 | 2020-05-17 | Monroe | Mississippi | 28095 | 222 | 23 |
155622 | 155622 | 2020-05-18 | Monroe | Mississippi | 28095 | 220 | 23 |
158640 | 158640 | 2020-05-19 | Monroe | Mississippi | 28095 | 220 | 23 |
161666 | 161666 | 2020-05-20 | Monroe | Mississippi | 28095 | 226 | 23 |
164695 | 164695 | 2020-05-21 | Monroe | Mississippi | 28095 | 229 | 23 |
167731 | 167731 | 2020-05-22 | Monroe | Mississippi | 28095 | 231 | 24 |
170769 | 170769 | 2020-05-23 | Monroe | Mississippi | 28095 | 241 | 24 |
173811 | 173811 | 2020-05-24 | Monroe | Mississippi | 28095 | 242 | 24 |
176854 | 176854 | 2020-05-25 | Monroe | Mississippi | 28095 | 246 | 24 |
179898 | 179898 | 2020-05-26 | Monroe | Mississippi | 28095 | 249 | 24 |
182944 | 182944 | 2020-05-27 | Monroe | Mississippi | 28095 | 253 | 24 |
186000 | 186000 | 2020-05-28 | Monroe | Mississippi | 28095 | 252 | 25 |
189058 | 189058 | 2020-05-29 | Monroe | Mississippi | 28095 | 254 | 25 |
192122 | 192122 | 2020-05-30 | Monroe | Mississippi | 28095 | 255 | 25 |
195190 | 195190 | 2020-05-31 | Monroe | Mississippi | 28095 | 257 | 25 |
198261 | 198261 | 2020-06-01 | Monroe | Mississippi | 28095 | 261 | 25 |
201334 | 201334 | 2020-06-02 | Monroe | Mississippi | 28095 | 265 | 25 |
204411 | 204411 | 2020-06-03 | Monroe | Mississippi | 28095 | 267 | 25 |
207492 | 207492 | 2020-06-04 | Monroe | Mississippi | 28095 | 269 | 25 |
210573 | 210573 | 2020-06-05 | Monroe | Mississippi | 28095 | 269 | 25 |
213657 | 213657 | 2020-06-06 | Monroe | Mississippi | 28095 | 273 | 25 |
216745 | 216745 | 2020-06-07 | Monroe | Mississippi | 28095 | 277 | 25 |
219837 | 219837 | 2020-06-08 | Monroe | Mississippi | 28095 | 280 | 25 |
222932 | 222932 | 2020-06-09 | Monroe | Mississippi | 28095 | 285 | 25 |
226030 | 226030 | 2020-06-10 | Monroe | Mississippi | 28095 | 290 | 25 |
229132 | 229132 | 2020-06-11 | Monroe | Mississippi | 28095 | 290 | 25 |
232236 | 232236 | 2020-06-12 | Monroe | Mississippi | 28095 | 291 | 25 |
235342 | 235342 | 2020-06-13 | Monroe | Mississippi | 28095 | 291 | 25 |
238449 | 238449 | 2020-06-14 | Monroe | Mississippi | 28095 | 293 | 25 |
241558 | 241558 | 2020-06-15 | Monroe | Mississippi | 28095 | 295 | 25 |
244669 | 244669 | 2020-06-16 | Monroe | Mississippi | 28095 | 297 | 25 |
247782 | 247782 | 2020-06-17 | Monroe | Mississippi | 28095 | 301 | 26 |
250894 | 250894 | 2020-06-18 | Monroe | Mississippi | 28095 | 301 | 26 |
254009 | 254009 | 2020-06-19 | Monroe | Mississippi | 28095 | 301 | 26 |
257129 | 257129 | 2020-06-20 | Monroe | Mississippi | 28095 | 301 | 26 |
260255 | 260255 | 2020-06-21 | Monroe | Mississippi | 28095 | 301 | 26 |
263384 | 263384 | 2020-06-22 | Monroe | Mississippi | 28095 | 311 | 27 |
266510 | 266510 | 2020-06-23 | Monroe | Mississippi | 28095 | 314 | 28 |
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);