ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Warren" and fips = 28149 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636373 | 636373 | 2020-10-16 | Warren | Mississippi | 28149 | 1511 | 54 |
633127 | 633127 | 2020-10-15 | Warren | Mississippi | 28149 | 1486 | 54 |
629882 | 629882 | 2020-10-14 | Warren | Mississippi | 28149 | 1481 | 54 |
626638 | 626638 | 2020-10-13 | Warren | Mississippi | 28149 | 1476 | 53 |
623396 | 623396 | 2020-10-12 | Warren | Mississippi | 28149 | 1470 | 53 |
620153 | 620153 | 2020-10-11 | Warren | Mississippi | 28149 | 1470 | 53 |
616911 | 616911 | 2020-10-10 | Warren | Mississippi | 28149 | 1467 | 53 |
613670 | 613670 | 2020-10-09 | Warren | Mississippi | 28149 | 1459 | 53 |
610428 | 610428 | 2020-10-08 | Warren | Mississippi | 28149 | 1452 | 53 |
607186 | 607186 | 2020-10-07 | Warren | Mississippi | 28149 | 1443 | 52 |
603943 | 603943 | 2020-10-06 | Warren | Mississippi | 28149 | 1438 | 52 |
600701 | 600701 | 2020-10-05 | Warren | Mississippi | 28149 | 1431 | 51 |
597458 | 597458 | 2020-10-04 | Warren | Mississippi | 28149 | 1429 | 51 |
594217 | 594217 | 2020-10-03 | Warren | Mississippi | 28149 | 1428 | 50 |
590976 | 590976 | 2020-10-02 | Warren | Mississippi | 28149 | 1425 | 50 |
587735 | 587735 | 2020-10-01 | Warren | Mississippi | 28149 | 1423 | 50 |
584495 | 584495 | 2020-09-30 | Warren | Mississippi | 28149 | 1418 | 50 |
581254 | 581254 | 2020-09-29 | Warren | Mississippi | 28149 | 1415 | 50 |
578013 | 578013 | 2020-09-28 | Warren | Mississippi | 28149 | 1409 | 50 |
574772 | 574772 | 2020-09-27 | Warren | Mississippi | 28149 | 1409 | 50 |
571529 | 571529 | 2020-09-26 | Warren | Mississippi | 28149 | 1407 | 50 |
568287 | 568287 | 2020-09-25 | Warren | Mississippi | 28149 | 1405 | 50 |
565047 | 565047 | 2020-09-24 | Warren | Mississippi | 28149 | 1402 | 50 |
561807 | 561807 | 2020-09-23 | Warren | Mississippi | 28149 | 1384 | 50 |
558570 | 558570 | 2020-09-22 | Warren | Mississippi | 28149 | 1382 | 50 |
555333 | 555333 | 2020-09-21 | Warren | Mississippi | 28149 | 1381 | 50 |
552095 | 552095 | 2020-09-20 | Warren | Mississippi | 28149 | 1381 | 50 |
548856 | 548856 | 2020-09-19 | Warren | Mississippi | 28149 | 1380 | 50 |
545618 | 545618 | 2020-09-18 | Warren | Mississippi | 28149 | 1372 | 50 |
542381 | 542381 | 2020-09-17 | Warren | Mississippi | 28149 | 1366 | 50 |
539145 | 539145 | 2020-09-16 | Warren | Mississippi | 28149 | 1362 | 49 |
535908 | 535908 | 2020-09-15 | Warren | Mississippi | 28149 | 1360 | 48 |
532673 | 532673 | 2020-09-14 | Warren | Mississippi | 28149 | 1354 | 48 |
529437 | 529437 | 2020-09-13 | Warren | Mississippi | 28149 | 1354 | 47 |
526201 | 526201 | 2020-09-12 | Warren | Mississippi | 28149 | 1352 | 47 |
522965 | 522965 | 2020-09-11 | Warren | Mississippi | 28149 | 1348 | 47 |
519728 | 519728 | 2020-09-10 | Warren | Mississippi | 28149 | 1347 | 46 |
516493 | 516493 | 2020-09-09 | Warren | Mississippi | 28149 | 1342 | 46 |
513259 | 513259 | 2020-09-08 | Warren | Mississippi | 28149 | 1341 | 46 |
510027 | 510027 | 2020-09-07 | Warren | Mississippi | 28149 | 1341 | 46 |
506794 | 506794 | 2020-09-06 | Warren | Mississippi | 28149 | 1341 | 46 |
503561 | 503561 | 2020-09-05 | Warren | Mississippi | 28149 | 1340 | 47 |
500327 | 500327 | 2020-09-04 | Warren | Mississippi | 28149 | 1335 | 47 |
497093 | 497093 | 2020-09-03 | Warren | Mississippi | 28149 | 1328 | 46 |
493860 | 493860 | 2020-09-02 | Warren | Mississippi | 28149 | 1317 | 46 |
490626 | 490626 | 2020-09-01 | Warren | Mississippi | 28149 | 1314 | 46 |
487393 | 487393 | 2020-08-31 | Warren | Mississippi | 28149 | 1314 | 46 |
484159 | 484159 | 2020-08-30 | Warren | Mississippi | 28149 | 1313 | 46 |
480924 | 480924 | 2020-08-29 | Warren | Mississippi | 28149 | 1303 | 46 |
477692 | 477692 | 2020-08-28 | Warren | Mississippi | 28149 | 1293 | 46 |
474459 | 474459 | 2020-08-27 | Warren | Mississippi | 28149 | 1281 | 46 |
471227 | 471227 | 2020-08-26 | Warren | Mississippi | 28149 | 1274 | 43 |
467997 | 467997 | 2020-08-25 | Warren | Mississippi | 28149 | 1260 | 43 |
464768 | 464768 | 2020-08-24 | Warren | Mississippi | 28149 | 1248 | 41 |
461537 | 461537 | 2020-08-23 | Warren | Mississippi | 28149 | 1245 | 41 |
458310 | 458310 | 2020-08-22 | Warren | Mississippi | 28149 | 1242 | 41 |
455082 | 455082 | 2020-08-21 | Warren | Mississippi | 28149 | 1236 | 39 |
451854 | 451854 | 2020-08-20 | Warren | Mississippi | 28149 | 1220 | 38 |
448626 | 448626 | 2020-08-19 | Warren | Mississippi | 28149 | 1207 | 38 |
445400 | 445400 | 2020-08-18 | Warren | Mississippi | 28149 | 1204 | 37 |
442174 | 442174 | 2020-08-17 | Warren | Mississippi | 28149 | 1182 | 37 |
438947 | 438947 | 2020-08-16 | Warren | Mississippi | 28149 | 1179 | 37 |
435722 | 435722 | 2020-08-15 | Warren | Mississippi | 28149 | 1173 | 37 |
432496 | 432496 | 2020-08-14 | Warren | Mississippi | 28149 | 1166 | 37 |
429269 | 429269 | 2020-08-13 | Warren | Mississippi | 28149 | 1151 | 36 |
426045 | 426045 | 2020-08-12 | Warren | Mississippi | 28149 | 1137 | 35 |
422823 | 422823 | 2020-08-11 | Warren | Mississippi | 28149 | 1125 | 35 |
419601 | 419601 | 2020-08-10 | Warren | Mississippi | 28149 | 1095 | 33 |
416380 | 416380 | 2020-08-09 | Warren | Mississippi | 28149 | 1093 | 33 |
413160 | 413160 | 2020-08-08 | Warren | Mississippi | 28149 | 1089 | 32 |
409940 | 409940 | 2020-08-07 | Warren | Mississippi | 28149 | 1033 | 32 |
406720 | 406720 | 2020-08-06 | Warren | Mississippi | 28149 | 1007 | 31 |
403502 | 403502 | 2020-08-05 | Warren | Mississippi | 28149 | 995 | 31 |
400285 | 400285 | 2020-08-04 | Warren | Mississippi | 28149 | 976 | 30 |
397071 | 397071 | 2020-08-03 | Warren | Mississippi | 28149 | 964 | 27 |
393855 | 393855 | 2020-08-02 | Warren | Mississippi | 28149 | 964 | 26 |
390638 | 390638 | 2020-08-01 | Warren | Mississippi | 28149 | 964 | 25 |
387421 | 387421 | 2020-07-31 | Warren | Mississippi | 28149 | 946 | 25 |
384203 | 384203 | 2020-07-30 | Warren | Mississippi | 28149 | 930 | 24 |
380987 | 380987 | 2020-07-29 | Warren | Mississippi | 28149 | 897 | 24 |
377770 | 377770 | 2020-07-28 | Warren | Mississippi | 28149 | 886 | 24 |
374555 | 374555 | 2020-07-27 | Warren | Mississippi | 28149 | 856 | 24 |
371343 | 371343 | 2020-07-26 | Warren | Mississippi | 28149 | 853 | 24 |
368132 | 368132 | 2020-07-25 | Warren | Mississippi | 28149 | 842 | 23 |
364924 | 364924 | 2020-07-24 | Warren | Mississippi | 28149 | 825 | 23 |
361717 | 361717 | 2020-07-23 | Warren | Mississippi | 28149 | 776 | 23 |
358512 | 358512 | 2020-07-22 | Warren | Mississippi | 28149 | 762 | 23 |
355309 | 355309 | 2020-07-21 | Warren | Mississippi | 28149 | 748 | 22 |
352107 | 352107 | 2020-07-20 | Warren | Mississippi | 28149 | 727 | 22 |
348907 | 348907 | 2020-07-19 | Warren | Mississippi | 28149 | 690 | 22 |
345706 | 345706 | 2020-07-18 | Warren | Mississippi | 28149 | 686 | 22 |
342506 | 342506 | 2020-07-17 | Warren | Mississippi | 28149 | 671 | 22 |
339310 | 339310 | 2020-07-16 | Warren | Mississippi | 28149 | 649 | 22 |
336114 | 336114 | 2020-07-15 | Warren | Mississippi | 28149 | 616 | 22 |
332921 | 332921 | 2020-07-14 | Warren | Mississippi | 28149 | 612 | 22 |
329734 | 329734 | 2020-07-13 | Warren | Mississippi | 28149 | 600 | 21 |
326548 | 326548 | 2020-07-12 | Warren | Mississippi | 28149 | 600 | 21 |
323365 | 323365 | 2020-07-11 | Warren | Mississippi | 28149 | 594 | 21 |
320186 | 320186 | 2020-07-10 | Warren | Mississippi | 28149 | 577 | 20 |
317011 | 317011 | 2020-07-09 | Warren | Mississippi | 28149 | 553 | 20 |
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);