ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Hancock" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387369 | 387369 | 2020-07-31 | Hancock | Mississippi | 28045 | 323 | 14 |
384151 | 384151 | 2020-07-30 | Hancock | Mississippi | 28045 | 310 | 14 |
380934 | 380934 | 2020-07-29 | Hancock | Mississippi | 28045 | 298 | 14 |
377717 | 377717 | 2020-07-28 | Hancock | Mississippi | 28045 | 291 | 14 |
374502 | 374502 | 2020-07-27 | Hancock | Mississippi | 28045 | 277 | 14 |
371290 | 371290 | 2020-07-26 | Hancock | Mississippi | 28045 | 269 | 14 |
368080 | 368080 | 2020-07-25 | Hancock | Mississippi | 28045 | 247 | 14 |
364872 | 364872 | 2020-07-24 | Hancock | Mississippi | 28045 | 235 | 14 |
361665 | 361665 | 2020-07-23 | Hancock | Mississippi | 28045 | 219 | 14 |
358460 | 358460 | 2020-07-22 | Hancock | Mississippi | 28045 | 214 | 14 |
355257 | 355257 | 2020-07-21 | Hancock | Mississippi | 28045 | 212 | 14 |
352055 | 352055 | 2020-07-20 | Hancock | Mississippi | 28045 | 204 | 14 |
348855 | 348855 | 2020-07-19 | Hancock | Mississippi | 28045 | 190 | 14 |
345654 | 345654 | 2020-07-18 | Hancock | Mississippi | 28045 | 187 | 14 |
342454 | 342454 | 2020-07-17 | Hancock | Mississippi | 28045 | 180 | 14 |
339258 | 339258 | 2020-07-16 | Hancock | Mississippi | 28045 | 172 | 14 |
336062 | 336062 | 2020-07-15 | Hancock | Mississippi | 28045 | 162 | 14 |
332869 | 332869 | 2020-07-14 | Hancock | Mississippi | 28045 | 158 | 13 |
329682 | 329682 | 2020-07-13 | Hancock | Mississippi | 28045 | 152 | 13 |
326496 | 326496 | 2020-07-12 | Hancock | Mississippi | 28045 | 148 | 13 |
323313 | 323313 | 2020-07-11 | Hancock | Mississippi | 28045 | 144 | 13 |
320134 | 320134 | 2020-07-10 | Hancock | Mississippi | 28045 | 141 | 13 |
316959 | 316959 | 2020-07-09 | Hancock | Mississippi | 28045 | 138 | 13 |
313785 | 313785 | 2020-07-08 | Hancock | Mississippi | 28045 | 134 | 13 |
310615 | 310615 | 2020-07-07 | Hancock | Mississippi | 28045 | 134 | 13 |
307447 | 307447 | 2020-07-06 | Hancock | Mississippi | 28045 | 130 | 13 |
304280 | 304280 | 2020-07-05 | Hancock | Mississippi | 28045 | 128 | 13 |
301116 | 301116 | 2020-07-04 | Hancock | Mississippi | 28045 | 126 | 13 |
297953 | 297953 | 2020-07-03 | Hancock | Mississippi | 28045 | 126 | 13 |
294795 | 294795 | 2020-07-02 | Hancock | Mississippi | 28045 | 123 | 13 |
291641 | 291641 | 2020-07-01 | Hancock | Mississippi | 28045 | 120 | 13 |
288490 | 288490 | 2020-06-30 | Hancock | Mississippi | 28045 | 120 | 13 |
285340 | 285340 | 2020-06-29 | Hancock | Mississippi | 28045 | 120 | 13 |
282195 | 282195 | 2020-06-28 | Hancock | Mississippi | 28045 | 116 | 13 |
279047 | 279047 | 2020-06-27 | Hancock | Mississippi | 28045 | 116 | 13 |
275899 | 275899 | 2020-06-26 | Hancock | Mississippi | 28045 | 115 | 13 |
272756 | 272756 | 2020-06-25 | Hancock | Mississippi | 28045 | 112 | 13 |
269619 | 269619 | 2020-06-24 | Hancock | Mississippi | 28045 | 106 | 13 |
266486 | 266486 | 2020-06-23 | Hancock | Mississippi | 28045 | 103 | 13 |
263360 | 263360 | 2020-06-22 | Hancock | Mississippi | 28045 | 103 | 13 |
260231 | 260231 | 2020-06-21 | Hancock | Mississippi | 28045 | 100 | 13 |
257105 | 257105 | 2020-06-20 | Hancock | Mississippi | 28045 | 100 | 13 |
253985 | 253985 | 2020-06-19 | Hancock | Mississippi | 28045 | 100 | 13 |
250870 | 250870 | 2020-06-18 | Hancock | Mississippi | 28045 | 100 | 13 |
247758 | 247758 | 2020-06-17 | Hancock | Mississippi | 28045 | 100 | 13 |
244645 | 244645 | 2020-06-16 | Hancock | Mississippi | 28045 | 100 | 12 |
241534 | 241534 | 2020-06-15 | Hancock | Mississippi | 28045 | 100 | 12 |
238425 | 238425 | 2020-06-14 | Hancock | Mississippi | 28045 | 100 | 12 |
235318 | 235318 | 2020-06-13 | Hancock | Mississippi | 28045 | 100 | 12 |
232212 | 232212 | 2020-06-12 | Hancock | Mississippi | 28045 | 98 | 12 |
229108 | 229108 | 2020-06-11 | Hancock | Mississippi | 28045 | 94 | 12 |
226006 | 226006 | 2020-06-10 | Hancock | Mississippi | 28045 | 94 | 12 |
222908 | 222908 | 2020-06-09 | Hancock | Mississippi | 28045 | 93 | 12 |
219813 | 219813 | 2020-06-08 | Hancock | Mississippi | 28045 | 93 | 12 |
216721 | 216721 | 2020-06-07 | Hancock | Mississippi | 28045 | 92 | 12 |
213633 | 213633 | 2020-06-06 | Hancock | Mississippi | 28045 | 92 | 12 |
210549 | 210549 | 2020-06-05 | Hancock | Mississippi | 28045 | 90 | 12 |
207468 | 207468 | 2020-06-04 | Hancock | Mississippi | 28045 | 90 | 12 |
204387 | 204387 | 2020-06-03 | Hancock | Mississippi | 28045 | 90 | 12 |
201310 | 201310 | 2020-06-02 | Hancock | Mississippi | 28045 | 91 | 12 |
198237 | 198237 | 2020-06-01 | Hancock | Mississippi | 28045 | 91 | 11 |
195166 | 195166 | 2020-05-31 | Hancock | Mississippi | 28045 | 91 | 11 |
192098 | 192098 | 2020-05-30 | Hancock | Mississippi | 28045 | 90 | 11 |
189034 | 189034 | 2020-05-29 | Hancock | Mississippi | 28045 | 87 | 11 |
185976 | 185976 | 2020-05-28 | Hancock | Mississippi | 28045 | 87 | 11 |
182920 | 182920 | 2020-05-27 | Hancock | Mississippi | 28045 | 87 | 11 |
179874 | 179874 | 2020-05-26 | Hancock | Mississippi | 28045 | 88 | 11 |
176830 | 176830 | 2020-05-25 | Hancock | Mississippi | 28045 | 88 | 11 |
173787 | 173787 | 2020-05-24 | Hancock | Mississippi | 28045 | 87 | 11 |
170745 | 170745 | 2020-05-23 | Hancock | Mississippi | 28045 | 84 | 11 |
167707 | 167707 | 2020-05-22 | Hancock | Mississippi | 28045 | 86 | 10 |
164671 | 164671 | 2020-05-21 | Hancock | Mississippi | 28045 | 81 | 10 |
161642 | 161642 | 2020-05-20 | Hancock | Mississippi | 28045 | 81 | 10 |
158616 | 158616 | 2020-05-19 | Hancock | Mississippi | 28045 | 81 | 10 |
155598 | 155598 | 2020-05-18 | Hancock | Mississippi | 28045 | 81 | 10 |
152584 | 152584 | 2020-05-17 | Hancock | Mississippi | 28045 | 80 | 10 |
149573 | 149573 | 2020-05-16 | Hancock | Mississippi | 28045 | 79 | 10 |
146568 | 146568 | 2020-05-15 | Hancock | Mississippi | 28045 | 78 | 10 |
143568 | 143568 | 2020-05-14 | Hancock | Mississippi | 28045 | 79 | 10 |
140573 | 140573 | 2020-05-13 | Hancock | Mississippi | 28045 | 75 | 10 |
137579 | 137579 | 2020-05-12 | Hancock | Mississippi | 28045 | 74 | 10 |
134589 | 134589 | 2020-05-11 | Hancock | Mississippi | 28045 | 74 | 10 |
131598 | 131598 | 2020-05-10 | Hancock | Mississippi | 28045 | 74 | 10 |
128608 | 128608 | 2020-05-09 | Hancock | Mississippi | 28045 | 73 | 10 |
125621 | 125621 | 2020-05-08 | Hancock | Mississippi | 28045 | 72 | 9 |
122639 | 122639 | 2020-05-07 | Hancock | Mississippi | 28045 | 72 | 9 |
119665 | 119665 | 2020-05-06 | Hancock | Mississippi | 28045 | 68 | 5 |
116705 | 116705 | 2020-05-05 | Hancock | Mississippi | 28045 | 68 | 5 |
113823 | 113823 | 2020-05-04 | Hancock | Mississippi | 28045 | 68 | 5 |
110944 | 110944 | 2020-05-03 | Hancock | Mississippi | 28045 | 68 | 5 |
108073 | 108073 | 2020-05-02 | Hancock | Mississippi | 28045 | 67 | 5 |
105208 | 105208 | 2020-05-01 | Hancock | Mississippi | 28045 | 62 | 5 |
102347 | 102347 | 2020-04-30 | Hancock | Mississippi | 28045 | 62 | 5 |
99495 | 99495 | 2020-04-29 | Hancock | Mississippi | 28045 | 61 | 5 |
96649 | 96649 | 2020-04-28 | Hancock | Mississippi | 28045 | 61 | 5 |
93813 | 93813 | 2020-04-27 | Hancock | Mississippi | 28045 | 60 | 5 |
90992 | 90992 | 2020-04-26 | Hancock | Mississippi | 28045 | 60 | 5 |
88176 | 88176 | 2020-04-25 | Hancock | Mississippi | 28045 | 59 | 5 |
85366 | 85366 | 2020-04-24 | Hancock | Mississippi | 28045 | 56 | 5 |
82562 | 82562 | 2020-04-23 | Hancock | Mississippi | 28045 | 55 | 5 |
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);