ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 28143 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387418 | 387418 | 2020-07-31 | Tunica | Mississippi | 28143 | 228 | 5 |
384200 | 384200 | 2020-07-30 | Tunica | Mississippi | 28143 | 224 | 5 |
380983 | 380983 | 2020-07-29 | Tunica | Mississippi | 28143 | 209 | 4 |
377766 | 377766 | 2020-07-28 | Tunica | Mississippi | 28143 | 196 | 4 |
374551 | 374551 | 2020-07-27 | Tunica | Mississippi | 28143 | 184 | 4 |
371339 | 371339 | 2020-07-26 | Tunica | Mississippi | 28143 | 182 | 4 |
368129 | 368129 | 2020-07-25 | Tunica | Mississippi | 28143 | 180 | 4 |
364921 | 364921 | 2020-07-24 | Tunica | Mississippi | 28143 | 175 | 4 |
361714 | 361714 | 2020-07-23 | Tunica | Mississippi | 28143 | 173 | 3 |
358509 | 358509 | 2020-07-22 | Tunica | Mississippi | 28143 | 168 | 3 |
355306 | 355306 | 2020-07-21 | Tunica | Mississippi | 28143 | 155 | 3 |
352104 | 352104 | 2020-07-20 | Tunica | Mississippi | 28143 | 147 | 3 |
348904 | 348904 | 2020-07-19 | Tunica | Mississippi | 28143 | 146 | 3 |
345703 | 345703 | 2020-07-18 | Tunica | Mississippi | 28143 | 138 | 3 |
342503 | 342503 | 2020-07-17 | Tunica | Mississippi | 28143 | 139 | 3 |
339307 | 339307 | 2020-07-16 | Tunica | Mississippi | 28143 | 132 | 3 |
336111 | 336111 | 2020-07-15 | Tunica | Mississippi | 28143 | 129 | 3 |
332918 | 332918 | 2020-07-14 | Tunica | Mississippi | 28143 | 127 | 3 |
329731 | 329731 | 2020-07-13 | Tunica | Mississippi | 28143 | 126 | 3 |
326545 | 326545 | 2020-07-12 | Tunica | Mississippi | 28143 | 125 | 3 |
323362 | 323362 | 2020-07-11 | Tunica | Mississippi | 28143 | 123 | 3 |
320183 | 320183 | 2020-07-10 | Tunica | Mississippi | 28143 | 121 | 3 |
317008 | 317008 | 2020-07-09 | Tunica | Mississippi | 28143 | 119 | 3 |
313834 | 313834 | 2020-07-08 | Tunica | Mississippi | 28143 | 115 | 3 |
310664 | 310664 | 2020-07-07 | Tunica | Mississippi | 28143 | 113 | 3 |
307496 | 307496 | 2020-07-06 | Tunica | Mississippi | 28143 | 105 | 3 |
304329 | 304329 | 2020-07-05 | Tunica | Mississippi | 28143 | 100 | 3 |
301165 | 301165 | 2020-07-04 | Tunica | Mississippi | 28143 | 100 | 3 |
298002 | 298002 | 2020-07-03 | Tunica | Mississippi | 28143 | 93 | 3 |
294844 | 294844 | 2020-07-02 | Tunica | Mississippi | 28143 | 90 | 3 |
291690 | 291690 | 2020-07-01 | Tunica | Mississippi | 28143 | 89 | 3 |
288539 | 288539 | 2020-06-30 | Tunica | Mississippi | 28143 | 89 | 3 |
285389 | 285389 | 2020-06-29 | Tunica | Mississippi | 28143 | 88 | 3 |
282244 | 282244 | 2020-06-28 | Tunica | Mississippi | 28143 | 82 | 3 |
279096 | 279096 | 2020-06-27 | Tunica | Mississippi | 28143 | 82 | 3 |
275948 | 275948 | 2020-06-26 | Tunica | Mississippi | 28143 | 81 | 3 |
272805 | 272805 | 2020-06-25 | Tunica | Mississippi | 28143 | 81 | 3 |
269667 | 269667 | 2020-06-24 | Tunica | Mississippi | 28143 | 78 | 3 |
266534 | 266534 | 2020-06-23 | Tunica | Mississippi | 28143 | 77 | 3 |
263408 | 263408 | 2020-06-22 | Tunica | Mississippi | 28143 | 76 | 3 |
260279 | 260279 | 2020-06-21 | Tunica | Mississippi | 28143 | 67 | 3 |
257153 | 257153 | 2020-06-20 | Tunica | Mississippi | 28143 | 67 | 3 |
254033 | 254033 | 2020-06-19 | Tunica | Mississippi | 28143 | 67 | 3 |
250918 | 250918 | 2020-06-18 | Tunica | Mississippi | 28143 | 67 | 3 |
247806 | 247806 | 2020-06-17 | Tunica | Mississippi | 28143 | 67 | 3 |
244693 | 244693 | 2020-06-16 | Tunica | Mississippi | 28143 | 67 | 3 |
241582 | 241582 | 2020-06-15 | Tunica | Mississippi | 28143 | 66 | 3 |
238473 | 238473 | 2020-06-14 | Tunica | Mississippi | 28143 | 64 | 3 |
235366 | 235366 | 2020-06-13 | Tunica | Mississippi | 28143 | 64 | 3 |
232260 | 232260 | 2020-06-12 | Tunica | Mississippi | 28143 | 62 | 3 |
229156 | 229156 | 2020-06-11 | Tunica | Mississippi | 28143 | 61 | 3 |
226054 | 226054 | 2020-06-10 | Tunica | Mississippi | 28143 | 61 | 3 |
222956 | 222956 | 2020-06-09 | Tunica | Mississippi | 28143 | 60 | 3 |
219861 | 219861 | 2020-06-08 | Tunica | Mississippi | 28143 | 58 | 3 |
216769 | 216769 | 2020-06-07 | Tunica | Mississippi | 28143 | 58 | 3 |
213681 | 213681 | 2020-06-06 | Tunica | Mississippi | 28143 | 57 | 3 |
210597 | 210597 | 2020-06-05 | Tunica | Mississippi | 28143 | 58 | 3 |
207516 | 207516 | 2020-06-04 | Tunica | Mississippi | 28143 | 58 | 3 |
204435 | 204435 | 2020-06-03 | Tunica | Mississippi | 28143 | 56 | 3 |
201358 | 201358 | 2020-06-02 | Tunica | Mississippi | 28143 | 56 | 3 |
198285 | 198285 | 2020-06-01 | Tunica | Mississippi | 28143 | 55 | 3 |
195214 | 195214 | 2020-05-31 | Tunica | Mississippi | 28143 | 55 | 3 |
192146 | 192146 | 2020-05-30 | Tunica | Mississippi | 28143 | 54 | 3 |
189082 | 189082 | 2020-05-29 | Tunica | Mississippi | 28143 | 53 | 3 |
186024 | 186024 | 2020-05-28 | Tunica | Mississippi | 28143 | 53 | 3 |
182968 | 182968 | 2020-05-27 | Tunica | Mississippi | 28143 | 52 | 3 |
179922 | 179922 | 2020-05-26 | Tunica | Mississippi | 28143 | 50 | 3 |
176878 | 176878 | 2020-05-25 | Tunica | Mississippi | 28143 | 48 | 3 |
173835 | 173835 | 2020-05-24 | Tunica | Mississippi | 28143 | 48 | 3 |
170793 | 170793 | 2020-05-23 | Tunica | Mississippi | 28143 | 48 | 2 |
167755 | 167755 | 2020-05-22 | Tunica | Mississippi | 28143 | 47 | 2 |
164719 | 164719 | 2020-05-21 | Tunica | Mississippi | 28143 | 45 | 2 |
161690 | 161690 | 2020-05-20 | Tunica | Mississippi | 28143 | 45 | 2 |
158664 | 158664 | 2020-05-19 | Tunica | Mississippi | 28143 | 45 | 2 |
155646 | 155646 | 2020-05-18 | Tunica | Mississippi | 28143 | 44 | 2 |
152632 | 152632 | 2020-05-17 | Tunica | Mississippi | 28143 | 44 | 2 |
149621 | 149621 | 2020-05-16 | Tunica | Mississippi | 28143 | 44 | 2 |
146616 | 146616 | 2020-05-15 | Tunica | Mississippi | 28143 | 44 | 2 |
143616 | 143616 | 2020-05-14 | Tunica | Mississippi | 28143 | 40 | 2 |
140621 | 140621 | 2020-05-13 | Tunica | Mississippi | 28143 | 40 | 2 |
137627 | 137627 | 2020-05-12 | Tunica | Mississippi | 28143 | 40 | 2 |
134637 | 134637 | 2020-05-11 | Tunica | Mississippi | 28143 | 39 | 2 |
131646 | 131646 | 2020-05-10 | Tunica | Mississippi | 28143 | 38 | 2 |
128656 | 128656 | 2020-05-09 | Tunica | Mississippi | 28143 | 38 | 2 |
125669 | 125669 | 2020-05-08 | Tunica | Mississippi | 28143 | 38 | 2 |
122687 | 122687 | 2020-05-07 | Tunica | Mississippi | 28143 | 39 | 2 |
119713 | 119713 | 2020-05-06 | Tunica | Mississippi | 28143 | 37 | 2 |
116753 | 116753 | 2020-05-05 | Tunica | Mississippi | 28143 | 36 | 2 |
113871 | 113871 | 2020-05-04 | Tunica | Mississippi | 28143 | 36 | 2 |
110992 | 110992 | 2020-05-03 | Tunica | Mississippi | 28143 | 36 | 2 |
108121 | 108121 | 2020-05-02 | Tunica | Mississippi | 28143 | 35 | 2 |
105256 | 105256 | 2020-05-01 | Tunica | Mississippi | 28143 | 35 | 2 |
102395 | 102395 | 2020-04-30 | Tunica | Mississippi | 28143 | 35 | 1 |
99543 | 99543 | 2020-04-29 | Tunica | Mississippi | 28143 | 35 | 1 |
96697 | 96697 | 2020-04-28 | Tunica | Mississippi | 28143 | 35 | 1 |
93861 | 93861 | 2020-04-27 | Tunica | Mississippi | 28143 | 35 | 1 |
91040 | 91040 | 2020-04-26 | Tunica | Mississippi | 28143 | 35 | 1 |
88224 | 88224 | 2020-04-25 | Tunica | Mississippi | 28143 | 34 | 1 |
85414 | 85414 | 2020-04-24 | Tunica | Mississippi | 28143 | 34 | 1 |
82610 | 82610 | 2020-04-23 | Tunica | Mississippi | 28143 | 34 | 1 |
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);