ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Rankin" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387407 | 387407 | 2020-07-31 | Rankin | Mississippi | 28121 | 2091 | 28 |
384189 | 384189 | 2020-07-30 | Rankin | Mississippi | 28121 | 2048 | 27 |
380972 | 380972 | 2020-07-29 | Rankin | Mississippi | 28121 | 1988 | 27 |
377755 | 377755 | 2020-07-28 | Rankin | Mississippi | 28121 | 1920 | 25 |
374540 | 374540 | 2020-07-27 | Rankin | Mississippi | 28121 | 1856 | 23 |
371328 | 371328 | 2020-07-26 | Rankin | Mississippi | 28121 | 1830 | 23 |
368118 | 368118 | 2020-07-25 | Rankin | Mississippi | 28121 | 1763 | 23 |
364910 | 364910 | 2020-07-24 | Rankin | Mississippi | 28121 | 1709 | 23 |
361703 | 361703 | 2020-07-23 | Rankin | Mississippi | 28121 | 1644 | 23 |
358498 | 358498 | 2020-07-22 | Rankin | Mississippi | 28121 | 1623 | 23 |
355295 | 355295 | 2020-07-21 | Rankin | Mississippi | 28121 | 1537 | 23 |
352093 | 352093 | 2020-07-20 | Rankin | Mississippi | 28121 | 1459 | 22 |
348893 | 348893 | 2020-07-19 | Rankin | Mississippi | 28121 | 1415 | 22 |
345692 | 345692 | 2020-07-18 | Rankin | Mississippi | 28121 | 1402 | 21 |
342492 | 342492 | 2020-07-17 | Rankin | Mississippi | 28121 | 1322 | 21 |
339296 | 339296 | 2020-07-16 | Rankin | Mississippi | 28121 | 1276 | 20 |
336100 | 336100 | 2020-07-15 | Rankin | Mississippi | 28121 | 1234 | 20 |
332907 | 332907 | 2020-07-14 | Rankin | Mississippi | 28121 | 1173 | 20 |
329720 | 329720 | 2020-07-13 | Rankin | Mississippi | 28121 | 1137 | 19 |
326534 | 326534 | 2020-07-12 | Rankin | Mississippi | 28121 | 1126 | 19 |
323351 | 323351 | 2020-07-11 | Rankin | Mississippi | 28121 | 1087 | 15 |
320172 | 320172 | 2020-07-10 | Rankin | Mississippi | 28121 | 1063 | 15 |
316997 | 316997 | 2020-07-09 | Rankin | Mississippi | 28121 | 1035 | 15 |
313823 | 313823 | 2020-07-08 | Rankin | Mississippi | 28121 | 999 | 15 |
310653 | 310653 | 2020-07-07 | Rankin | Mississippi | 28121 | 982 | 13 |
307485 | 307485 | 2020-07-06 | Rankin | Mississippi | 28121 | 951 | 12 |
304318 | 304318 | 2020-07-05 | Rankin | Mississippi | 28121 | 934 | 12 |
301154 | 301154 | 2020-07-04 | Rankin | Mississippi | 28121 | 916 | 12 |
297991 | 297991 | 2020-07-03 | Rankin | Mississippi | 28121 | 888 | 12 |
294833 | 294833 | 2020-07-02 | Rankin | Mississippi | 28121 | 860 | 12 |
291679 | 291679 | 2020-07-01 | Rankin | Mississippi | 28121 | 841 | 12 |
288528 | 288528 | 2020-06-30 | Rankin | Mississippi | 28121 | 816 | 12 |
285378 | 285378 | 2020-06-29 | Rankin | Mississippi | 28121 | 798 | 12 |
282233 | 282233 | 2020-06-28 | Rankin | Mississippi | 28121 | 773 | 12 |
279085 | 279085 | 2020-06-27 | Rankin | Mississippi | 28121 | 715 | 12 |
275937 | 275937 | 2020-06-26 | Rankin | Mississippi | 28121 | 700 | 12 |
272794 | 272794 | 2020-06-25 | Rankin | Mississippi | 28121 | 682 | 12 |
269656 | 269656 | 2020-06-24 | Rankin | Mississippi | 28121 | 636 | 12 |
266523 | 266523 | 2020-06-23 | Rankin | Mississippi | 28121 | 620 | 12 |
263397 | 263397 | 2020-06-22 | Rankin | Mississippi | 28121 | 611 | 12 |
260268 | 260268 | 2020-06-21 | Rankin | Mississippi | 28121 | 563 | 10 |
257142 | 257142 | 2020-06-20 | Rankin | Mississippi | 28121 | 563 | 10 |
254022 | 254022 | 2020-06-19 | Rankin | Mississippi | 28121 | 563 | 10 |
250907 | 250907 | 2020-06-18 | Rankin | Mississippi | 28121 | 563 | 10 |
247795 | 247795 | 2020-06-17 | Rankin | Mississippi | 28121 | 563 | 10 |
244682 | 244682 | 2020-06-16 | Rankin | Mississippi | 28121 | 550 | 10 |
241571 | 241571 | 2020-06-15 | Rankin | Mississippi | 28121 | 539 | 10 |
238462 | 238462 | 2020-06-14 | Rankin | Mississippi | 28121 | 537 | 10 |
235355 | 235355 | 2020-06-13 | Rankin | Mississippi | 28121 | 536 | 10 |
232249 | 232249 | 2020-06-12 | Rankin | Mississippi | 28121 | 529 | 10 |
229145 | 229145 | 2020-06-11 | Rankin | Mississippi | 28121 | 505 | 10 |
226043 | 226043 | 2020-06-10 | Rankin | Mississippi | 28121 | 505 | 10 |
222945 | 222945 | 2020-06-09 | Rankin | Mississippi | 28121 | 498 | 10 |
219850 | 219850 | 2020-06-08 | Rankin | Mississippi | 28121 | 485 | 9 |
216758 | 216758 | 2020-06-07 | Rankin | Mississippi | 28121 | 480 | 9 |
213670 | 213670 | 2020-06-06 | Rankin | Mississippi | 28121 | 473 | 9 |
210586 | 210586 | 2020-06-05 | Rankin | Mississippi | 28121 | 463 | 9 |
207505 | 207505 | 2020-06-04 | Rankin | Mississippi | 28121 | 456 | 9 |
204424 | 204424 | 2020-06-03 | Rankin | Mississippi | 28121 | 453 | 8 |
201347 | 201347 | 2020-06-02 | Rankin | Mississippi | 28121 | 446 | 8 |
198274 | 198274 | 2020-06-01 | Rankin | Mississippi | 28121 | 446 | 8 |
195203 | 195203 | 2020-05-31 | Rankin | Mississippi | 28121 | 439 | 8 |
192135 | 192135 | 2020-05-30 | Rankin | Mississippi | 28121 | 421 | 7 |
189071 | 189071 | 2020-05-29 | Rankin | Mississippi | 28121 | 399 | 7 |
186013 | 186013 | 2020-05-28 | Rankin | Mississippi | 28121 | 385 | 6 |
182957 | 182957 | 2020-05-27 | Rankin | Mississippi | 28121 | 373 | 6 |
179911 | 179911 | 2020-05-26 | Rankin | Mississippi | 28121 | 358 | 6 |
176867 | 176867 | 2020-05-25 | Rankin | Mississippi | 28121 | 356 | 6 |
173824 | 173824 | 2020-05-24 | Rankin | Mississippi | 28121 | 349 | 6 |
170782 | 170782 | 2020-05-23 | Rankin | Mississippi | 28121 | 336 | 6 |
167744 | 167744 | 2020-05-22 | Rankin | Mississippi | 28121 | 325 | 6 |
164708 | 164708 | 2020-05-21 | Rankin | Mississippi | 28121 | 315 | 6 |
161679 | 161679 | 2020-05-20 | Rankin | Mississippi | 28121 | 310 | 6 |
158653 | 158653 | 2020-05-19 | Rankin | Mississippi | 28121 | 295 | 6 |
155635 | 155635 | 2020-05-18 | Rankin | Mississippi | 28121 | 287 | 6 |
152621 | 152621 | 2020-05-17 | Rankin | Mississippi | 28121 | 285 | 6 |
149610 | 149610 | 2020-05-16 | Rankin | Mississippi | 28121 | 282 | 6 |
146605 | 146605 | 2020-05-15 | Rankin | Mississippi | 28121 | 276 | 6 |
143605 | 143605 | 2020-05-14 | Rankin | Mississippi | 28121 | 271 | 6 |
140610 | 140610 | 2020-05-13 | Rankin | Mississippi | 28121 | 262 | 6 |
137616 | 137616 | 2020-05-12 | Rankin | Mississippi | 28121 | 256 | 6 |
134626 | 134626 | 2020-05-11 | Rankin | Mississippi | 28121 | 251 | 6 |
131635 | 131635 | 2020-05-10 | Rankin | Mississippi | 28121 | 250 | 6 |
128645 | 128645 | 2020-05-09 | Rankin | Mississippi | 28121 | 248 | 6 |
125658 | 125658 | 2020-05-08 | Rankin | Mississippi | 28121 | 238 | 6 |
122676 | 122676 | 2020-05-07 | Rankin | Mississippi | 28121 | 231 | 6 |
119702 | 119702 | 2020-05-06 | Rankin | Mississippi | 28121 | 226 | 6 |
116742 | 116742 | 2020-05-05 | Rankin | Mississippi | 28121 | 221 | 6 |
113860 | 113860 | 2020-05-04 | Rankin | Mississippi | 28121 | 207 | 6 |
110981 | 110981 | 2020-05-03 | Rankin | Mississippi | 28121 | 200 | 6 |
108110 | 108110 | 2020-05-02 | Rankin | Mississippi | 28121 | 197 | 5 |
105245 | 105245 | 2020-05-01 | Rankin | Mississippi | 28121 | 194 | 5 |
102384 | 102384 | 2020-04-30 | Rankin | Mississippi | 28121 | 186 | 5 |
99532 | 99532 | 2020-04-29 | Rankin | Mississippi | 28121 | 182 | 5 |
96686 | 96686 | 2020-04-28 | Rankin | Mississippi | 28121 | 179 | 5 |
93850 | 93850 | 2020-04-27 | Rankin | Mississippi | 28121 | 171 | 5 |
91029 | 91029 | 2020-04-26 | Rankin | Mississippi | 28121 | 167 | 5 |
88213 | 88213 | 2020-04-25 | Rankin | Mississippi | 28121 | 162 | 5 |
85403 | 85403 | 2020-04-24 | Rankin | Mississippi | 28121 | 154 | 4 |
82599 | 82599 | 2020-04-23 | Rankin | Mississippi | 28121 | 153 | 4 |
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);