ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 28045 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535856 | 535856 | 2020-09-15 | Hancock | Mississippi | 28045 | 542 | 20 |
532621 | 532621 | 2020-09-14 | Hancock | Mississippi | 28045 | 540 | 20 |
529385 | 529385 | 2020-09-13 | Hancock | Mississippi | 28045 | 538 | 20 |
526149 | 526149 | 2020-09-12 | Hancock | Mississippi | 28045 | 537 | 20 |
522913 | 522913 | 2020-09-11 | Hancock | Mississippi | 28045 | 538 | 20 |
519676 | 519676 | 2020-09-10 | Hancock | Mississippi | 28045 | 529 | 20 |
516441 | 516441 | 2020-09-09 | Hancock | Mississippi | 28045 | 526 | 20 |
513207 | 513207 | 2020-09-08 | Hancock | Mississippi | 28045 | 520 | 20 |
509975 | 509975 | 2020-09-07 | Hancock | Mississippi | 28045 | 517 | 20 |
506742 | 506742 | 2020-09-06 | Hancock | Mississippi | 28045 | 515 | 20 |
503509 | 503509 | 2020-09-05 | Hancock | Mississippi | 28045 | 513 | 20 |
500275 | 500275 | 2020-09-04 | Hancock | Mississippi | 28045 | 510 | 20 |
497041 | 497041 | 2020-09-03 | Hancock | Mississippi | 28045 | 508 | 20 |
493808 | 493808 | 2020-09-02 | Hancock | Mississippi | 28045 | 502 | 20 |
490574 | 490574 | 2020-09-01 | Hancock | Mississippi | 28045 | 501 | 20 |
487341 | 487341 | 2020-08-31 | Hancock | Mississippi | 28045 | 495 | 20 |
484107 | 484107 | 2020-08-30 | Hancock | Mississippi | 28045 | 490 | 20 |
480872 | 480872 | 2020-08-29 | Hancock | Mississippi | 28045 | 487 | 18 |
477640 | 477640 | 2020-08-28 | Hancock | Mississippi | 28045 | 480 | 18 |
474407 | 474407 | 2020-08-27 | Hancock | Mississippi | 28045 | 472 | 18 |
471175 | 471175 | 2020-08-26 | Hancock | Mississippi | 28045 | 466 | 18 |
467945 | 467945 | 2020-08-25 | Hancock | Mississippi | 28045 | 463 | 18 |
464716 | 464716 | 2020-08-24 | Hancock | Mississippi | 28045 | 457 | 18 |
461485 | 461485 | 2020-08-23 | Hancock | Mississippi | 28045 | 454 | 18 |
458258 | 458258 | 2020-08-22 | Hancock | Mississippi | 28045 | 450 | 18 |
455030 | 455030 | 2020-08-21 | Hancock | Mississippi | 28045 | 448 | 18 |
451802 | 451802 | 2020-08-20 | Hancock | Mississippi | 28045 | 442 | 17 |
448574 | 448574 | 2020-08-19 | Hancock | Mississippi | 28045 | 436 | 17 |
445348 | 445348 | 2020-08-18 | Hancock | Mississippi | 28045 | 432 | 17 |
442122 | 442122 | 2020-08-17 | Hancock | Mississippi | 28045 | 432 | 16 |
438895 | 438895 | 2020-08-16 | Hancock | Mississippi | 28045 | 425 | 15 |
435670 | 435670 | 2020-08-15 | Hancock | Mississippi | 28045 | 422 | 15 |
432444 | 432444 | 2020-08-14 | Hancock | Mississippi | 28045 | 419 | 15 |
429217 | 429217 | 2020-08-13 | Hancock | Mississippi | 28045 | 414 | 15 |
425993 | 425993 | 2020-08-12 | Hancock | Mississippi | 28045 | 409 | 15 |
422771 | 422771 | 2020-08-11 | Hancock | Mississippi | 28045 | 402 | 14 |
419549 | 419549 | 2020-08-10 | Hancock | Mississippi | 28045 | 395 | 14 |
416328 | 416328 | 2020-08-09 | Hancock | Mississippi | 28045 | 390 | 14 |
413108 | 413108 | 2020-08-08 | Hancock | Mississippi | 28045 | 388 | 14 |
409888 | 409888 | 2020-08-07 | Hancock | Mississippi | 28045 | 373 | 14 |
406668 | 406668 | 2020-08-06 | Hancock | Mississippi | 28045 | 363 | 14 |
403450 | 403450 | 2020-08-05 | Hancock | Mississippi | 28045 | 349 | 14 |
400233 | 400233 | 2020-08-04 | Hancock | Mississippi | 28045 | 344 | 14 |
397019 | 397019 | 2020-08-03 | Hancock | Mississippi | 28045 | 336 | 14 |
393803 | 393803 | 2020-08-02 | Hancock | Mississippi | 28045 | 326 | 14 |
390586 | 390586 | 2020-08-01 | Hancock | Mississippi | 28045 | 324 | 14 |
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 |
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);