ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Coahoma" and state = "Mississippi" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
275890 | 275890 | 2020-06-26 | Coahoma | Mississippi | 28027 | 176 | 6 |
279038 | 279038 | 2020-06-27 | Coahoma | Mississippi | 28027 | 177 | 6 |
282186 | 282186 | 2020-06-28 | Coahoma | Mississippi | 28027 | 178 | 6 |
285331 | 285331 | 2020-06-29 | Coahoma | Mississippi | 28027 | 180 | 6 |
288481 | 288481 | 2020-06-30 | Coahoma | Mississippi | 28027 | 183 | 6 |
291632 | 291632 | 2020-07-01 | Coahoma | Mississippi | 28027 | 186 | 6 |
294786 | 294786 | 2020-07-02 | Coahoma | Mississippi | 28027 | 190 | 6 |
297944 | 297944 | 2020-07-03 | Coahoma | Mississippi | 28027 | 191 | 6 |
301107 | 301107 | 2020-07-04 | Coahoma | Mississippi | 28027 | 199 | 6 |
304271 | 304271 | 2020-07-05 | Coahoma | Mississippi | 28027 | 201 | 6 |
307438 | 307438 | 2020-07-06 | Coahoma | Mississippi | 28027 | 201 | 6 |
310606 | 310606 | 2020-07-07 | Coahoma | Mississippi | 28027 | 205 | 6 |
313776 | 313776 | 2020-07-08 | Coahoma | Mississippi | 28027 | 213 | 6 |
316950 | 316950 | 2020-07-09 | Coahoma | Mississippi | 28027 | 215 | 6 |
320125 | 320125 | 2020-07-10 | Coahoma | Mississippi | 28027 | 219 | 6 |
323304 | 323304 | 2020-07-11 | Coahoma | Mississippi | 28027 | 222 | 6 |
326487 | 326487 | 2020-07-12 | Coahoma | Mississippi | 28027 | 230 | 6 |
329673 | 329673 | 2020-07-13 | Coahoma | Mississippi | 28027 | 235 | 6 |
332860 | 332860 | 2020-07-14 | Coahoma | Mississippi | 28027 | 237 | 6 |
336053 | 336053 | 2020-07-15 | Coahoma | Mississippi | 28027 | 251 | 6 |
339249 | 339249 | 2020-07-16 | Coahoma | Mississippi | 28027 | 257 | 6 |
342445 | 342445 | 2020-07-17 | Coahoma | Mississippi | 28027 | 276 | 7 |
345645 | 345645 | 2020-07-18 | Coahoma | Mississippi | 28027 | 285 | 7 |
348846 | 348846 | 2020-07-19 | Coahoma | Mississippi | 28027 | 410 | 7 |
352046 | 352046 | 2020-07-20 | Coahoma | Mississippi | 28027 | 422 | 7 |
355248 | 355248 | 2020-07-21 | Coahoma | Mississippi | 28027 | 443 | 7 |
358451 | 358451 | 2020-07-22 | Coahoma | Mississippi | 28027 | 465 | 7 |
361656 | 361656 | 2020-07-23 | Coahoma | Mississippi | 28027 | 471 | 7 |
364863 | 364863 | 2020-07-24 | Coahoma | Mississippi | 28027 | 492 | 7 |
368071 | 368071 | 2020-07-25 | Coahoma | Mississippi | 28027 | 508 | 7 |
371281 | 371281 | 2020-07-26 | Coahoma | Mississippi | 28027 | 535 | 7 |
374493 | 374493 | 2020-07-27 | Coahoma | Mississippi | 28027 | 547 | 7 |
377708 | 377708 | 2020-07-28 | Coahoma | Mississippi | 28027 | 567 | 7 |
380925 | 380925 | 2020-07-29 | Coahoma | Mississippi | 28027 | 593 | 7 |
384142 | 384142 | 2020-07-30 | Coahoma | Mississippi | 28027 | 626 | 7 |
387360 | 387360 | 2020-07-31 | Coahoma | Mississippi | 28027 | 632 | 10 |
390577 | 390577 | 2020-08-01 | Coahoma | Mississippi | 28027 | 648 | 10 |
393794 | 393794 | 2020-08-02 | Coahoma | Mississippi | 28027 | 659 | 10 |
397010 | 397010 | 2020-08-03 | Coahoma | Mississippi | 28027 | 663 | 10 |
400224 | 400224 | 2020-08-04 | Coahoma | Mississippi | 28027 | 677 | 10 |
403441 | 403441 | 2020-08-05 | Coahoma | Mississippi | 28027 | 684 | 10 |
406659 | 406659 | 2020-08-06 | Coahoma | Mississippi | 28027 | 697 | 11 |
409879 | 409879 | 2020-08-07 | Coahoma | Mississippi | 28027 | 715 | 11 |
413099 | 413099 | 2020-08-08 | Coahoma | Mississippi | 28027 | 743 | 12 |
416319 | 416319 | 2020-08-09 | Coahoma | Mississippi | 28027 | 760 | 13 |
419540 | 419540 | 2020-08-10 | Coahoma | Mississippi | 28027 | 772 | 13 |
422762 | 422762 | 2020-08-11 | Coahoma | Mississippi | 28027 | 781 | 13 |
425984 | 425984 | 2020-08-12 | Coahoma | Mississippi | 28027 | 789 | 13 |
429208 | 429208 | 2020-08-13 | Coahoma | Mississippi | 28027 | 798 | 13 |
432435 | 432435 | 2020-08-14 | Coahoma | Mississippi | 28027 | 810 | 13 |
435661 | 435661 | 2020-08-15 | Coahoma | Mississippi | 28027 | 812 | 13 |
438886 | 438886 | 2020-08-16 | Coahoma | Mississippi | 28027 | 817 | 13 |
442113 | 442113 | 2020-08-17 | Coahoma | Mississippi | 28027 | 830 | 13 |
445339 | 445339 | 2020-08-18 | Coahoma | Mississippi | 28027 | 834 | 14 |
448565 | 448565 | 2020-08-19 | Coahoma | Mississippi | 28027 | 875 | 14 |
451793 | 451793 | 2020-08-20 | Coahoma | Mississippi | 28027 | 890 | 14 |
455021 | 455021 | 2020-08-21 | Coahoma | Mississippi | 28027 | 895 | 14 |
458249 | 458249 | 2020-08-22 | Coahoma | Mississippi | 28027 | 899 | 14 |
461476 | 461476 | 2020-08-23 | Coahoma | Mississippi | 28027 | 903 | 14 |
464707 | 464707 | 2020-08-24 | Coahoma | Mississippi | 28027 | 910 | 14 |
467936 | 467936 | 2020-08-25 | Coahoma | Mississippi | 28027 | 923 | 16 |
471166 | 471166 | 2020-08-26 | Coahoma | Mississippi | 28027 | 926 | 17 |
474398 | 474398 | 2020-08-27 | Coahoma | Mississippi | 28027 | 946 | 17 |
477631 | 477631 | 2020-08-28 | Coahoma | Mississippi | 28027 | 959 | 17 |
480863 | 480863 | 2020-08-29 | Coahoma | Mississippi | 28027 | 969 | 17 |
484098 | 484098 | 2020-08-30 | Coahoma | Mississippi | 28027 | 975 | 18 |
487332 | 487332 | 2020-08-31 | Coahoma | Mississippi | 28027 | 984 | 19 |
490565 | 490565 | 2020-09-01 | Coahoma | Mississippi | 28027 | 987 | 19 |
493799 | 493799 | 2020-09-02 | Coahoma | Mississippi | 28027 | 1013 | 20 |
497032 | 497032 | 2020-09-03 | Coahoma | Mississippi | 28027 | 1022 | 20 |
500266 | 500266 | 2020-09-04 | Coahoma | Mississippi | 28027 | 1033 | 20 |
503500 | 503500 | 2020-09-05 | Coahoma | Mississippi | 28027 | 1041 | 21 |
506733 | 506733 | 2020-09-06 | Coahoma | Mississippi | 28027 | 1042 | 22 |
509966 | 509966 | 2020-09-07 | Coahoma | Mississippi | 28027 | 1044 | 22 |
513198 | 513198 | 2020-09-08 | Coahoma | Mississippi | 28027 | 1046 | 22 |
516432 | 516432 | 2020-09-09 | Coahoma | Mississippi | 28027 | 1055 | 22 |
519667 | 519667 | 2020-09-10 | Coahoma | Mississippi | 28027 | 1063 | 23 |
522904 | 522904 | 2020-09-11 | Coahoma | Mississippi | 28027 | 1067 | 23 |
526140 | 526140 | 2020-09-12 | Coahoma | Mississippi | 28027 | 1070 | 24 |
529376 | 529376 | 2020-09-13 | Coahoma | Mississippi | 28027 | 1072 | 24 |
532612 | 532612 | 2020-09-14 | Coahoma | Mississippi | 28027 | 1073 | 24 |
535847 | 535847 | 2020-09-15 | Coahoma | Mississippi | 28027 | 1079 | 24 |
539084 | 539084 | 2020-09-16 | Coahoma | Mississippi | 28027 | 1089 | 26 |
542320 | 542320 | 2020-09-17 | Coahoma | Mississippi | 28027 | 1109 | 27 |
545557 | 545557 | 2020-09-18 | Coahoma | Mississippi | 28027 | 1112 | 27 |
548795 | 548795 | 2020-09-19 | Coahoma | Mississippi | 28027 | 1123 | 27 |
552034 | 552034 | 2020-09-20 | Coahoma | Mississippi | 28027 | 1123 | 27 |
555272 | 555272 | 2020-09-21 | Coahoma | Mississippi | 28027 | 1128 | 27 |
558509 | 558509 | 2020-09-22 | Coahoma | Mississippi | 28027 | 1136 | 27 |
561746 | 561746 | 2020-09-23 | Coahoma | Mississippi | 28027 | 1144 | 28 |
564986 | 564986 | 2020-09-24 | Coahoma | Mississippi | 28027 | 1150 | 28 |
568226 | 568226 | 2020-09-25 | Coahoma | Mississippi | 28027 | 1155 | 28 |
571468 | 571468 | 2020-09-26 | Coahoma | Mississippi | 28027 | 1163 | 29 |
574711 | 574711 | 2020-09-27 | Coahoma | Mississippi | 28027 | 1162 | 29 |
577952 | 577952 | 2020-09-28 | Coahoma | Mississippi | 28027 | 1163 | 29 |
581193 | 581193 | 2020-09-29 | Coahoma | Mississippi | 28027 | 1167 | 30 |
584434 | 584434 | 2020-09-30 | Coahoma | Mississippi | 28027 | 1175 | 30 |
587674 | 587674 | 2020-10-01 | Coahoma | Mississippi | 28027 | 1178 | 30 |
590915 | 590915 | 2020-10-02 | Coahoma | Mississippi | 28027 | 1184 | 31 |
594156 | 594156 | 2020-10-03 | Coahoma | Mississippi | 28027 | 1188 | 31 |
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);