ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Hinds" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
384153 | 384153 | 2020-07-30 | Hinds | Mississippi | 28049 | 5001 | 97 |
380936 | 380936 | 2020-07-29 | Hinds | Mississippi | 28049 | 4838 | 94 |
377719 | 377719 | 2020-07-28 | Hinds | Mississippi | 28049 | 4737 | 93 |
374504 | 374504 | 2020-07-27 | Hinds | Mississippi | 28049 | 4624 | 82 |
371292 | 371292 | 2020-07-26 | Hinds | Mississippi | 28049 | 4553 | 82 |
368082 | 368082 | 2020-07-25 | Hinds | Mississippi | 28049 | 4413 | 82 |
364874 | 364874 | 2020-07-24 | Hinds | Mississippi | 28049 | 4261 | 80 |
361667 | 361667 | 2020-07-23 | Hinds | Mississippi | 28049 | 4070 | 78 |
358462 | 358462 | 2020-07-22 | Hinds | Mississippi | 28049 | 3952 | 77 |
355259 | 355259 | 2020-07-21 | Hinds | Mississippi | 28049 | 3835 | 75 |
352057 | 352057 | 2020-07-20 | Hinds | Mississippi | 28049 | 3691 | 70 |
348857 | 348857 | 2020-07-19 | Hinds | Mississippi | 28049 | 3579 | 70 |
345656 | 345656 | 2020-07-18 | Hinds | Mississippi | 28049 | 3520 | 69 |
342456 | 342456 | 2020-07-17 | Hinds | Mississippi | 28049 | 3418 | 66 |
339260 | 339260 | 2020-07-16 | Hinds | Mississippi | 28049 | 3317 | 63 |
336064 | 336064 | 2020-07-15 | Hinds | Mississippi | 28049 | 3188 | 59 |
332871 | 332871 | 2020-07-14 | Hinds | Mississippi | 28049 | 3102 | 58 |
329684 | 329684 | 2020-07-13 | Hinds | Mississippi | 28049 | 3041 | 54 |
326498 | 326498 | 2020-07-12 | Hinds | Mississippi | 28049 | 2992 | 54 |
323315 | 323315 | 2020-07-11 | Hinds | Mississippi | 28049 | 2908 | 51 |
320136 | 320136 | 2020-07-10 | Hinds | Mississippi | 28049 | 2824 | 49 |
316961 | 316961 | 2020-07-09 | Hinds | Mississippi | 28049 | 2697 | 48 |
313787 | 313787 | 2020-07-08 | Hinds | Mississippi | 28049 | 2642 | 46 |
310617 | 310617 | 2020-07-07 | Hinds | Mississippi | 28049 | 2591 | 41 |
307449 | 307449 | 2020-07-06 | Hinds | Mississippi | 28049 | 2536 | 40 |
304282 | 304282 | 2020-07-05 | Hinds | Mississippi | 28049 | 2498 | 40 |
301118 | 301118 | 2020-07-04 | Hinds | Mississippi | 28049 | 2480 | 39 |
297955 | 297955 | 2020-07-03 | Hinds | Mississippi | 28049 | 2382 | 39 |
294797 | 294797 | 2020-07-02 | Hinds | Mississippi | 28049 | 2247 | 39 |
291643 | 291643 | 2020-07-01 | Hinds | Mississippi | 28049 | 2152 | 39 |
288492 | 288492 | 2020-06-30 | Hinds | Mississippi | 28049 | 2111 | 39 |
285342 | 285342 | 2020-06-29 | Hinds | Mississippi | 28049 | 2048 | 38 |
282197 | 282197 | 2020-06-28 | Hinds | Mississippi | 28049 | 1957 | 36 |
279049 | 279049 | 2020-06-27 | Hinds | Mississippi | 28049 | 1893 | 36 |
275901 | 275901 | 2020-06-26 | Hinds | Mississippi | 28049 | 1853 | 34 |
272758 | 272758 | 2020-06-25 | Hinds | Mississippi | 28049 | 1772 | 34 |
269621 | 269621 | 2020-06-24 | Hinds | Mississippi | 28049 | 1646 | 34 |
266488 | 266488 | 2020-06-23 | Hinds | Mississippi | 28049 | 1589 | 33 |
263362 | 263362 | 2020-06-22 | Hinds | Mississippi | 28049 | 1536 | 33 |
260233 | 260233 | 2020-06-21 | Hinds | Mississippi | 28049 | 1390 | 29 |
257107 | 257107 | 2020-06-20 | Hinds | Mississippi | 28049 | 1390 | 29 |
253987 | 253987 | 2020-06-19 | Hinds | Mississippi | 28049 | 1390 | 29 |
250872 | 250872 | 2020-06-18 | Hinds | Mississippi | 28049 | 1390 | 29 |
247760 | 247760 | 2020-06-17 | Hinds | Mississippi | 28049 | 1390 | 29 |
244647 | 244647 | 2020-06-16 | Hinds | Mississippi | 28049 | 1349 | 28 |
241536 | 241536 | 2020-06-15 | Hinds | Mississippi | 28049 | 1308 | 27 |
238427 | 238427 | 2020-06-14 | Hinds | Mississippi | 28049 | 1274 | 27 |
235320 | 235320 | 2020-06-13 | Hinds | Mississippi | 28049 | 1263 | 27 |
232214 | 232214 | 2020-06-12 | Hinds | Mississippi | 28049 | 1245 | 27 |
229110 | 229110 | 2020-06-11 | Hinds | Mississippi | 28049 | 1206 | 26 |
226008 | 226008 | 2020-06-10 | Hinds | Mississippi | 28049 | 1206 | 26 |
222910 | 222910 | 2020-06-09 | Hinds | Mississippi | 28049 | 1186 | 26 |
219815 | 219815 | 2020-06-08 | Hinds | Mississippi | 28049 | 1164 | 26 |
216723 | 216723 | 2020-06-07 | Hinds | Mississippi | 28049 | 1137 | 26 |
213635 | 213635 | 2020-06-06 | Hinds | Mississippi | 28049 | 1111 | 26 |
210551 | 210551 | 2020-06-05 | Hinds | Mississippi | 28049 | 1104 | 26 |
207470 | 207470 | 2020-06-04 | Hinds | Mississippi | 28049 | 1074 | 26 |
204389 | 204389 | 2020-06-03 | Hinds | Mississippi | 28049 | 1066 | 26 |
201312 | 201312 | 2020-06-02 | Hinds | Mississippi | 28049 | 1035 | 26 |
198239 | 198239 | 2020-06-01 | Hinds | Mississippi | 28049 | 1028 | 26 |
195168 | 195168 | 2020-05-31 | Hinds | Mississippi | 28049 | 1006 | 25 |
192100 | 192100 | 2020-05-30 | Hinds | Mississippi | 28049 | 999 | 25 |
189036 | 189036 | 2020-05-29 | Hinds | Mississippi | 28049 | 971 | 25 |
185978 | 185978 | 2020-05-28 | Hinds | Mississippi | 28049 | 959 | 24 |
182922 | 182922 | 2020-05-27 | Hinds | Mississippi | 28049 | 920 | 24 |
179876 | 179876 | 2020-05-26 | Hinds | Mississippi | 28049 | 904 | 24 |
176832 | 176832 | 2020-05-25 | Hinds | Mississippi | 28049 | 898 | 24 |
173789 | 173789 | 2020-05-24 | Hinds | Mississippi | 28049 | 893 | 24 |
170747 | 170747 | 2020-05-23 | Hinds | Mississippi | 28049 | 877 | 24 |
167709 | 167709 | 2020-05-22 | Hinds | Mississippi | 28049 | 855 | 24 |
164673 | 164673 | 2020-05-21 | Hinds | Mississippi | 28049 | 825 | 24 |
161644 | 161644 | 2020-05-20 | Hinds | Mississippi | 28049 | 800 | 23 |
158618 | 158618 | 2020-05-19 | Hinds | Mississippi | 28049 | 786 | 22 |
155600 | 155600 | 2020-05-18 | Hinds | Mississippi | 28049 | 772 | 22 |
152586 | 152586 | 2020-05-17 | Hinds | Mississippi | 28049 | 773 | 22 |
149575 | 149575 | 2020-05-16 | Hinds | Mississippi | 28049 | 768 | 22 |
146570 | 146570 | 2020-05-15 | Hinds | Mississippi | 28049 | 745 | 20 |
143570 | 143570 | 2020-05-14 | Hinds | Mississippi | 28049 | 717 | 18 |
140575 | 140575 | 2020-05-13 | Hinds | Mississippi | 28049 | 698 | 17 |
137581 | 137581 | 2020-05-12 | Hinds | Mississippi | 28049 | 681 | 17 |
134591 | 134591 | 2020-05-11 | Hinds | Mississippi | 28049 | 675 | 15 |
131600 | 131600 | 2020-05-10 | Hinds | Mississippi | 28049 | 670 | 15 |
128610 | 128610 | 2020-05-09 | Hinds | Mississippi | 28049 | 663 | 15 |
125623 | 125623 | 2020-05-08 | Hinds | Mississippi | 28049 | 657 | 11 |
122641 | 122641 | 2020-05-07 | Hinds | Mississippi | 28049 | 600 | 11 |
119667 | 119667 | 2020-05-06 | Hinds | Mississippi | 28049 | 588 | 11 |
116707 | 116707 | 2020-05-05 | Hinds | Mississippi | 28049 | 565 | 9 |
113825 | 113825 | 2020-05-04 | Hinds | Mississippi | 28049 | 542 | 9 |
110946 | 110946 | 2020-05-03 | Hinds | Mississippi | 28049 | 507 | 8 |
108075 | 108075 | 2020-05-02 | Hinds | Mississippi | 28049 | 505 | 8 |
105210 | 105210 | 2020-05-01 | Hinds | Mississippi | 28049 | 496 | 8 |
102349 | 102349 | 2020-04-30 | Hinds | Mississippi | 28049 | 470 | 8 |
99497 | 99497 | 2020-04-29 | Hinds | Mississippi | 28049 | 450 | 7 |
96651 | 96651 | 2020-04-28 | Hinds | Mississippi | 28049 | 435 | 7 |
93815 | 93815 | 2020-04-27 | Hinds | Mississippi | 28049 | 421 | 7 |
90994 | 90994 | 2020-04-26 | Hinds | Mississippi | 28049 | 415 | 7 |
88178 | 88178 | 2020-04-25 | Hinds | Mississippi | 28049 | 412 | 7 |
85368 | 85368 | 2020-04-24 | Hinds | Mississippi | 28049 | 401 | 6 |
82564 | 82564 | 2020-04-23 | Hinds | Mississippi | 28049 | 383 | 6 |
79768 | 79768 | 2020-04-22 | Hinds | Mississippi | 28049 | 377 | 6 |
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);