ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 28109 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387401 | 387401 | 2020-07-31 | Pearl River | Mississippi | 28109 | 471 | 36 |
384183 | 384183 | 2020-07-30 | Pearl River | Mississippi | 28109 | 462 | 35 |
380966 | 380966 | 2020-07-29 | Pearl River | Mississippi | 28109 | 452 | 35 |
377749 | 377749 | 2020-07-28 | Pearl River | Mississippi | 28109 | 444 | 35 |
374534 | 374534 | 2020-07-27 | Pearl River | Mississippi | 28109 | 431 | 34 |
371322 | 371322 | 2020-07-26 | Pearl River | Mississippi | 28109 | 427 | 34 |
368112 | 368112 | 2020-07-25 | Pearl River | Mississippi | 28109 | 419 | 34 |
364904 | 364904 | 2020-07-24 | Pearl River | Mississippi | 28109 | 403 | 34 |
361697 | 361697 | 2020-07-23 | Pearl River | Mississippi | 28109 | 392 | 32 |
358492 | 358492 | 2020-07-22 | Pearl River | Mississippi | 28109 | 391 | 32 |
355289 | 355289 | 2020-07-21 | Pearl River | Mississippi | 28109 | 383 | 32 |
352087 | 352087 | 2020-07-20 | Pearl River | Mississippi | 28109 | 371 | 32 |
348887 | 348887 | 2020-07-19 | Pearl River | Mississippi | 28109 | 363 | 32 |
345686 | 345686 | 2020-07-18 | Pearl River | Mississippi | 28109 | 355 | 32 |
342486 | 342486 | 2020-07-17 | Pearl River | Mississippi | 28109 | 346 | 32 |
339290 | 339290 | 2020-07-16 | Pearl River | Mississippi | 28109 | 331 | 32 |
336094 | 336094 | 2020-07-15 | Pearl River | Mississippi | 28109 | 323 | 32 |
332901 | 332901 | 2020-07-14 | Pearl River | Mississippi | 28109 | 317 | 32 |
329714 | 329714 | 2020-07-13 | Pearl River | Mississippi | 28109 | 308 | 32 |
326528 | 326528 | 2020-07-12 | Pearl River | Mississippi | 28109 | 303 | 32 |
323345 | 323345 | 2020-07-11 | Pearl River | Mississippi | 28109 | 288 | 32 |
320166 | 320166 | 2020-07-10 | Pearl River | Mississippi | 28109 | 281 | 32 |
316991 | 316991 | 2020-07-09 | Pearl River | Mississippi | 28109 | 276 | 32 |
313817 | 313817 | 2020-07-08 | Pearl River | Mississippi | 28109 | 269 | 32 |
310647 | 310647 | 2020-07-07 | Pearl River | Mississippi | 28109 | 265 | 32 |
307479 | 307479 | 2020-07-06 | Pearl River | Mississippi | 28109 | 257 | 32 |
304312 | 304312 | 2020-07-05 | Pearl River | Mississippi | 28109 | 254 | 32 |
301148 | 301148 | 2020-07-04 | Pearl River | Mississippi | 28109 | 254 | 32 |
297985 | 297985 | 2020-07-03 | Pearl River | Mississippi | 28109 | 248 | 32 |
294827 | 294827 | 2020-07-02 | Pearl River | Mississippi | 28109 | 245 | 32 |
291673 | 291673 | 2020-07-01 | Pearl River | Mississippi | 28109 | 244 | 32 |
288522 | 288522 | 2020-06-30 | Pearl River | Mississippi | 28109 | 239 | 32 |
285372 | 285372 | 2020-06-29 | Pearl River | Mississippi | 28109 | 237 | 32 |
282227 | 282227 | 2020-06-28 | Pearl River | Mississippi | 28109 | 236 | 32 |
279079 | 279079 | 2020-06-27 | Pearl River | Mississippi | 28109 | 236 | 32 |
275931 | 275931 | 2020-06-26 | Pearl River | Mississippi | 28109 | 235 | 32 |
272788 | 272788 | 2020-06-25 | Pearl River | Mississippi | 28109 | 232 | 32 |
269650 | 269650 | 2020-06-24 | Pearl River | Mississippi | 28109 | 228 | 32 |
266517 | 266517 | 2020-06-23 | Pearl River | Mississippi | 28109 | 227 | 32 |
263391 | 263391 | 2020-06-22 | Pearl River | Mississippi | 28109 | 226 | 32 |
260262 | 260262 | 2020-06-21 | Pearl River | Mississippi | 28109 | 224 | 32 |
257136 | 257136 | 2020-06-20 | Pearl River | Mississippi | 28109 | 224 | 32 |
254016 | 254016 | 2020-06-19 | Pearl River | Mississippi | 28109 | 224 | 32 |
250901 | 250901 | 2020-06-18 | Pearl River | Mississippi | 28109 | 224 | 32 |
247789 | 247789 | 2020-06-17 | Pearl River | Mississippi | 28109 | 224 | 32 |
244676 | 244676 | 2020-06-16 | Pearl River | Mississippi | 28109 | 223 | 31 |
241565 | 241565 | 2020-06-15 | Pearl River | Mississippi | 28109 | 223 | 31 |
238456 | 238456 | 2020-06-14 | Pearl River | Mississippi | 28109 | 222 | 31 |
235349 | 235349 | 2020-06-13 | Pearl River | Mississippi | 28109 | 221 | 31 |
232243 | 232243 | 2020-06-12 | Pearl River | Mississippi | 28109 | 219 | 31 |
229139 | 229139 | 2020-06-11 | Pearl River | Mississippi | 28109 | 221 | 31 |
226037 | 226037 | 2020-06-10 | Pearl River | Mississippi | 28109 | 221 | 31 |
222939 | 222939 | 2020-06-09 | Pearl River | Mississippi | 28109 | 221 | 31 |
219844 | 219844 | 2020-06-08 | Pearl River | Mississippi | 28109 | 217 | 31 |
216752 | 216752 | 2020-06-07 | Pearl River | Mississippi | 28109 | 215 | 31 |
213664 | 213664 | 2020-06-06 | Pearl River | Mississippi | 28109 | 213 | 31 |
210580 | 210580 | 2020-06-05 | Pearl River | Mississippi | 28109 | 212 | 31 |
207499 | 207499 | 2020-06-04 | Pearl River | Mississippi | 28109 | 212 | 31 |
204418 | 204418 | 2020-06-03 | Pearl River | Mississippi | 28109 | 212 | 31 |
201341 | 201341 | 2020-06-02 | Pearl River | Mississippi | 28109 | 211 | 31 |
198268 | 198268 | 2020-06-01 | Pearl River | Mississippi | 28109 | 209 | 31 |
195197 | 195197 | 2020-05-31 | Pearl River | Mississippi | 28109 | 209 | 31 |
192129 | 192129 | 2020-05-30 | Pearl River | Mississippi | 28109 | 209 | 31 |
189065 | 189065 | 2020-05-29 | Pearl River | Mississippi | 28109 | 207 | 31 |
186007 | 186007 | 2020-05-28 | Pearl River | Mississippi | 28109 | 206 | 31 |
182951 | 182951 | 2020-05-27 | Pearl River | Mississippi | 28109 | 207 | 31 |
179905 | 179905 | 2020-05-26 | Pearl River | Mississippi | 28109 | 205 | 30 |
176861 | 176861 | 2020-05-25 | Pearl River | Mississippi | 28109 | 205 | 27 |
173818 | 173818 | 2020-05-24 | Pearl River | Mississippi | 28109 | 202 | 27 |
170776 | 170776 | 2020-05-23 | Pearl River | Mississippi | 28109 | 203 | 27 |
167738 | 167738 | 2020-05-22 | Pearl River | Mississippi | 28109 | 203 | 27 |
164702 | 164702 | 2020-05-21 | Pearl River | Mississippi | 28109 | 197 | 27 |
161673 | 161673 | 2020-05-20 | Pearl River | Mississippi | 28109 | 197 | 27 |
158647 | 158647 | 2020-05-19 | Pearl River | Mississippi | 28109 | 195 | 27 |
155629 | 155629 | 2020-05-18 | Pearl River | Mississippi | 28109 | 195 | 26 |
152615 | 152615 | 2020-05-17 | Pearl River | Mississippi | 28109 | 195 | 26 |
149604 | 149604 | 2020-05-16 | Pearl River | Mississippi | 28109 | 195 | 26 |
146599 | 146599 | 2020-05-15 | Pearl River | Mississippi | 28109 | 195 | 26 |
143599 | 143599 | 2020-05-14 | Pearl River | Mississippi | 28109 | 193 | 26 |
140604 | 140604 | 2020-05-13 | Pearl River | Mississippi | 28109 | 190 | 25 |
137610 | 137610 | 2020-05-12 | Pearl River | Mississippi | 28109 | 190 | 25 |
134620 | 134620 | 2020-05-11 | Pearl River | Mississippi | 28109 | 190 | 24 |
131629 | 131629 | 2020-05-10 | Pearl River | Mississippi | 28109 | 189 | 24 |
128639 | 128639 | 2020-05-09 | Pearl River | Mississippi | 28109 | 190 | 24 |
125652 | 125652 | 2020-05-08 | Pearl River | Mississippi | 28109 | 189 | 24 |
122670 | 122670 | 2020-05-07 | Pearl River | Mississippi | 28109 | 188 | 24 |
119696 | 119696 | 2020-05-06 | Pearl River | Mississippi | 28109 | 183 | 21 |
116736 | 116736 | 2020-05-05 | Pearl River | Mississippi | 28109 | 183 | 20 |
113854 | 113854 | 2020-05-04 | Pearl River | Mississippi | 28109 | 181 | 20 |
110975 | 110975 | 2020-05-03 | Pearl River | Mississippi | 28109 | 177 | 20 |
108104 | 108104 | 2020-05-02 | Pearl River | Mississippi | 28109 | 176 | 20 |
105239 | 105239 | 2020-05-01 | Pearl River | Mississippi | 28109 | 175 | 20 |
102378 | 102378 | 2020-04-30 | Pearl River | Mississippi | 28109 | 163 | 19 |
99526 | 99526 | 2020-04-29 | Pearl River | Mississippi | 28109 | 157 | 18 |
96680 | 96680 | 2020-04-28 | Pearl River | Mississippi | 28109 | 154 | 15 |
93844 | 93844 | 2020-04-27 | Pearl River | Mississippi | 28109 | 153 | 14 |
91023 | 91023 | 2020-04-26 | Pearl River | Mississippi | 28109 | 152 | 14 |
88207 | 88207 | 2020-04-25 | Pearl River | Mississippi | 28109 | 148 | 14 |
85397 | 85397 | 2020-04-24 | Pearl River | Mississippi | 28109 | 144 | 13 |
82593 | 82593 | 2020-04-23 | Pearl River | Mississippi | 28109 | 142 | 11 |
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);