ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where fips = 28153 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387423 | 387423 | 2020-07-31 | Wayne | Mississippi | 28153 | 729 | 21 |
384205 | 384205 | 2020-07-30 | Wayne | Mississippi | 28153 | 717 | 21 |
380989 | 380989 | 2020-07-29 | Wayne | Mississippi | 28153 | 708 | 21 |
377772 | 377772 | 2020-07-28 | Wayne | Mississippi | 28153 | 702 | 21 |
374557 | 374557 | 2020-07-27 | Wayne | Mississippi | 28153 | 693 | 21 |
371345 | 371345 | 2020-07-26 | Wayne | Mississippi | 28153 | 689 | 21 |
368134 | 368134 | 2020-07-25 | Wayne | Mississippi | 28153 | 669 | 21 |
364926 | 364926 | 2020-07-24 | Wayne | Mississippi | 28153 | 660 | 21 |
361719 | 361719 | 2020-07-23 | Wayne | Mississippi | 28153 | 656 | 21 |
358514 | 358514 | 2020-07-22 | Wayne | Mississippi | 28153 | 654 | 21 |
355311 | 355311 | 2020-07-21 | Wayne | Mississippi | 28153 | 650 | 21 |
352109 | 352109 | 2020-07-20 | Wayne | Mississippi | 28153 | 636 | 20 |
348909 | 348909 | 2020-07-19 | Wayne | Mississippi | 28153 | 622 | 20 |
345708 | 345708 | 2020-07-18 | Wayne | Mississippi | 28153 | 623 | 20 |
342508 | 342508 | 2020-07-17 | Wayne | Mississippi | 28153 | 606 | 20 |
339312 | 339312 | 2020-07-16 | Wayne | Mississippi | 28153 | 595 | 20 |
336116 | 336116 | 2020-07-15 | Wayne | Mississippi | 28153 | 588 | 19 |
332923 | 332923 | 2020-07-14 | Wayne | Mississippi | 28153 | 575 | 19 |
329736 | 329736 | 2020-07-13 | Wayne | Mississippi | 28153 | 568 | 19 |
326550 | 326550 | 2020-07-12 | Wayne | Mississippi | 28153 | 565 | 19 |
323367 | 323367 | 2020-07-11 | Wayne | Mississippi | 28153 | 562 | 18 |
320188 | 320188 | 2020-07-10 | Wayne | Mississippi | 28153 | 560 | 18 |
317013 | 317013 | 2020-07-09 | Wayne | Mississippi | 28153 | 554 | 16 |
313839 | 313839 | 2020-07-08 | Wayne | Mississippi | 28153 | 551 | 16 |
310669 | 310669 | 2020-07-07 | Wayne | Mississippi | 28153 | 545 | 15 |
307501 | 307501 | 2020-07-06 | Wayne | Mississippi | 28153 | 545 | 13 |
304334 | 304334 | 2020-07-05 | Wayne | Mississippi | 28153 | 545 | 13 |
301170 | 301170 | 2020-07-04 | Wayne | Mississippi | 28153 | 542 | 13 |
298007 | 298007 | 2020-07-03 | Wayne | Mississippi | 28153 | 535 | 13 |
294849 | 294849 | 2020-07-02 | Wayne | Mississippi | 28153 | 522 | 12 |
291695 | 291695 | 2020-07-01 | Wayne | Mississippi | 28153 | 521 | 12 |
288544 | 288544 | 2020-06-30 | Wayne | Mississippi | 28153 | 515 | 11 |
285394 | 285394 | 2020-06-29 | Wayne | Mississippi | 28153 | 509 | 10 |
282249 | 282249 | 2020-06-28 | Wayne | Mississippi | 28153 | 499 | 10 |
279101 | 279101 | 2020-06-27 | Wayne | Mississippi | 28153 | 468 | 10 |
275953 | 275953 | 2020-06-26 | Wayne | Mississippi | 28153 | 462 | 10 |
272810 | 272810 | 2020-06-25 | Wayne | Mississippi | 28153 | 461 | 9 |
269672 | 269672 | 2020-06-24 | Wayne | Mississippi | 28153 | 446 | 8 |
266539 | 266539 | 2020-06-23 | Wayne | Mississippi | 28153 | 441 | 8 |
263413 | 263413 | 2020-06-22 | Wayne | Mississippi | 28153 | 434 | 8 |
260285 | 260285 | 2020-06-21 | Wayne | Mississippi | 28153 | 409 | 8 |
257159 | 257159 | 2020-06-20 | Wayne | Mississippi | 28153 | 409 | 8 |
254039 | 254039 | 2020-06-19 | Wayne | Mississippi | 28153 | 409 | 8 |
250924 | 250924 | 2020-06-18 | Wayne | Mississippi | 28153 | 409 | 8 |
247811 | 247811 | 2020-06-17 | Wayne | Mississippi | 28153 | 409 | 8 |
244698 | 244698 | 2020-06-16 | Wayne | Mississippi | 28153 | 398 | 8 |
241587 | 241587 | 2020-06-15 | Wayne | Mississippi | 28153 | 389 | 7 |
238478 | 238478 | 2020-06-14 | Wayne | Mississippi | 28153 | 375 | 7 |
235371 | 235371 | 2020-06-13 | Wayne | Mississippi | 28153 | 373 | 7 |
232265 | 232265 | 2020-06-12 | Wayne | Mississippi | 28153 | 373 | 7 |
229161 | 229161 | 2020-06-11 | Wayne | Mississippi | 28153 | 346 | 5 |
226059 | 226059 | 2020-06-10 | Wayne | Mississippi | 28153 | 346 | 5 |
222961 | 222961 | 2020-06-09 | Wayne | Mississippi | 28153 | 335 | 5 |
219866 | 219866 | 2020-06-08 | Wayne | Mississippi | 28153 | 328 | 4 |
216774 | 216774 | 2020-06-07 | Wayne | Mississippi | 28153 | 315 | 3 |
213686 | 213686 | 2020-06-06 | Wayne | Mississippi | 28153 | 295 | 3 |
210602 | 210602 | 2020-06-05 | Wayne | Mississippi | 28153 | 280 | 3 |
207521 | 207521 | 2020-06-04 | Wayne | Mississippi | 28153 | 262 | 3 |
204440 | 204440 | 2020-06-03 | Wayne | Mississippi | 28153 | 235 | 3 |
201363 | 201363 | 2020-06-02 | Wayne | Mississippi | 28153 | 224 | 2 |
198290 | 198290 | 2020-06-01 | Wayne | Mississippi | 28153 | 210 | 1 |
195219 | 195219 | 2020-05-31 | Wayne | Mississippi | 28153 | 204 | 1 |
192151 | 192151 | 2020-05-30 | Wayne | Mississippi | 28153 | 177 | 1 |
189087 | 189087 | 2020-05-29 | Wayne | Mississippi | 28153 | 171 | 0 |
186029 | 186029 | 2020-05-28 | Wayne | Mississippi | 28153 | 154 | 0 |
182973 | 182973 | 2020-05-27 | Wayne | Mississippi | 28153 | 148 | 0 |
179927 | 179927 | 2020-05-26 | Wayne | Mississippi | 28153 | 133 | 0 |
176883 | 176883 | 2020-05-25 | Wayne | Mississippi | 28153 | 125 | 0 |
173840 | 173840 | 2020-05-24 | Wayne | Mississippi | 28153 | 109 | 0 |
170798 | 170798 | 2020-05-23 | Wayne | Mississippi | 28153 | 76 | 0 |
167760 | 167760 | 2020-05-22 | Wayne | Mississippi | 28153 | 72 | 0 |
164724 | 164724 | 2020-05-21 | Wayne | Mississippi | 28153 | 58 | 0 |
161695 | 161695 | 2020-05-20 | Wayne | Mississippi | 28153 | 51 | 0 |
158669 | 158669 | 2020-05-19 | Wayne | Mississippi | 28153 | 45 | 0 |
155651 | 155651 | 2020-05-18 | Wayne | Mississippi | 28153 | 39 | 0 |
152637 | 152637 | 2020-05-17 | Wayne | Mississippi | 28153 | 39 | 0 |
149626 | 149626 | 2020-05-16 | Wayne | Mississippi | 28153 | 37 | 0 |
146621 | 146621 | 2020-05-15 | Wayne | Mississippi | 28153 | 33 | 0 |
143621 | 143621 | 2020-05-14 | Wayne | Mississippi | 28153 | 32 | 0 |
140626 | 140626 | 2020-05-13 | Wayne | Mississippi | 28153 | 29 | 0 |
137632 | 137632 | 2020-05-12 | Wayne | Mississippi | 28153 | 29 | 0 |
134642 | 134642 | 2020-05-11 | Wayne | Mississippi | 28153 | 28 | 0 |
131651 | 131651 | 2020-05-10 | Wayne | Mississippi | 28153 | 27 | 0 |
128661 | 128661 | 2020-05-09 | Wayne | Mississippi | 28153 | 27 | 0 |
125674 | 125674 | 2020-05-08 | Wayne | Mississippi | 28153 | 27 | 0 |
122692 | 122692 | 2020-05-07 | Wayne | Mississippi | 28153 | 27 | 0 |
119718 | 119718 | 2020-05-06 | Wayne | Mississippi | 28153 | 26 | 0 |
116758 | 116758 | 2020-05-05 | Wayne | Mississippi | 28153 | 25 | 0 |
113876 | 113876 | 2020-05-04 | Wayne | Mississippi | 28153 | 24 | 0 |
110997 | 110997 | 2020-05-03 | Wayne | Mississippi | 28153 | 24 | 0 |
108126 | 108126 | 2020-05-02 | Wayne | Mississippi | 28153 | 24 | 0 |
105261 | 105261 | 2020-05-01 | Wayne | Mississippi | 28153 | 23 | 0 |
102400 | 102400 | 2020-04-30 | Wayne | Mississippi | 28153 | 23 | 0 |
99548 | 99548 | 2020-04-29 | Wayne | Mississippi | 28153 | 20 | 0 |
96702 | 96702 | 2020-04-28 | Wayne | Mississippi | 28153 | 19 | 0 |
93866 | 93866 | 2020-04-27 | Wayne | Mississippi | 28153 | 19 | 0 |
91045 | 91045 | 2020-04-26 | Wayne | Mississippi | 28153 | 19 | 0 |
88229 | 88229 | 2020-04-25 | Wayne | Mississippi | 28153 | 19 | 0 |
85419 | 85419 | 2020-04-24 | Wayne | Mississippi | 28153 | 16 | 0 |
82615 | 82615 | 2020-04-23 | Wayne | Mississippi | 28153 | 17 | 0 |
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);