ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 28121 sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
282233 | 282233 | 2020-06-28 | Rankin | Mississippi | 28121 | 773 | 12 |
285378 | 285378 | 2020-06-29 | Rankin | Mississippi | 28121 | 798 | 12 |
288528 | 288528 | 2020-06-30 | Rankin | Mississippi | 28121 | 816 | 12 |
291679 | 291679 | 2020-07-01 | Rankin | Mississippi | 28121 | 841 | 12 |
294833 | 294833 | 2020-07-02 | Rankin | Mississippi | 28121 | 860 | 12 |
297991 | 297991 | 2020-07-03 | Rankin | Mississippi | 28121 | 888 | 12 |
301154 | 301154 | 2020-07-04 | Rankin | Mississippi | 28121 | 916 | 12 |
304318 | 304318 | 2020-07-05 | Rankin | Mississippi | 28121 | 934 | 12 |
307485 | 307485 | 2020-07-06 | Rankin | Mississippi | 28121 | 951 | 12 |
310653 | 310653 | 2020-07-07 | Rankin | Mississippi | 28121 | 982 | 13 |
313823 | 313823 | 2020-07-08 | Rankin | Mississippi | 28121 | 999 | 15 |
316997 | 316997 | 2020-07-09 | Rankin | Mississippi | 28121 | 1035 | 15 |
320172 | 320172 | 2020-07-10 | Rankin | Mississippi | 28121 | 1063 | 15 |
323351 | 323351 | 2020-07-11 | Rankin | Mississippi | 28121 | 1087 | 15 |
326534 | 326534 | 2020-07-12 | Rankin | Mississippi | 28121 | 1126 | 19 |
329720 | 329720 | 2020-07-13 | Rankin | Mississippi | 28121 | 1137 | 19 |
332907 | 332907 | 2020-07-14 | Rankin | Mississippi | 28121 | 1173 | 20 |
336100 | 336100 | 2020-07-15 | Rankin | Mississippi | 28121 | 1234 | 20 |
339296 | 339296 | 2020-07-16 | Rankin | Mississippi | 28121 | 1276 | 20 |
342492 | 342492 | 2020-07-17 | Rankin | Mississippi | 28121 | 1322 | 21 |
345692 | 345692 | 2020-07-18 | Rankin | Mississippi | 28121 | 1402 | 21 |
348893 | 348893 | 2020-07-19 | Rankin | Mississippi | 28121 | 1415 | 22 |
352093 | 352093 | 2020-07-20 | Rankin | Mississippi | 28121 | 1459 | 22 |
355295 | 355295 | 2020-07-21 | Rankin | Mississippi | 28121 | 1537 | 23 |
358498 | 358498 | 2020-07-22 | Rankin | Mississippi | 28121 | 1623 | 23 |
361703 | 361703 | 2020-07-23 | Rankin | Mississippi | 28121 | 1644 | 23 |
364910 | 364910 | 2020-07-24 | Rankin | Mississippi | 28121 | 1709 | 23 |
368118 | 368118 | 2020-07-25 | Rankin | Mississippi | 28121 | 1763 | 23 |
371328 | 371328 | 2020-07-26 | Rankin | Mississippi | 28121 | 1830 | 23 |
374540 | 374540 | 2020-07-27 | Rankin | Mississippi | 28121 | 1856 | 23 |
377755 | 377755 | 2020-07-28 | Rankin | Mississippi | 28121 | 1920 | 25 |
380972 | 380972 | 2020-07-29 | Rankin | Mississippi | 28121 | 1988 | 27 |
384189 | 384189 | 2020-07-30 | Rankin | Mississippi | 28121 | 2048 | 27 |
387407 | 387407 | 2020-07-31 | Rankin | Mississippi | 28121 | 2091 | 28 |
390624 | 390624 | 2020-08-01 | Rankin | Mississippi | 28121 | 2111 | 28 |
393841 | 393841 | 2020-08-02 | Rankin | Mississippi | 28121 | 2124 | 28 |
397057 | 397057 | 2020-08-03 | Rankin | Mississippi | 28121 | 2146 | 28 |
400271 | 400271 | 2020-08-04 | Rankin | Mississippi | 28121 | 2168 | 30 |
403488 | 403488 | 2020-08-05 | Rankin | Mississippi | 28121 | 2202 | 31 |
406706 | 406706 | 2020-08-06 | Rankin | Mississippi | 28121 | 2220 | 32 |
409926 | 409926 | 2020-08-07 | Rankin | Mississippi | 28121 | 2251 | 32 |
413146 | 413146 | 2020-08-08 | Rankin | Mississippi | 28121 | 2276 | 33 |
416366 | 416366 | 2020-08-09 | Rankin | Mississippi | 28121 | 2283 | 34 |
419587 | 419587 | 2020-08-10 | Rankin | Mississippi | 28121 | 2292 | 35 |
422809 | 422809 | 2020-08-11 | Rankin | Mississippi | 28121 | 2307 | 35 |
426031 | 426031 | 2020-08-12 | Rankin | Mississippi | 28121 | 2322 | 38 |
429255 | 429255 | 2020-08-13 | Rankin | Mississippi | 28121 | 2337 | 38 |
432482 | 432482 | 2020-08-14 | Rankin | Mississippi | 28121 | 2382 | 41 |
435708 | 435708 | 2020-08-15 | Rankin | Mississippi | 28121 | 2411 | 41 |
438933 | 438933 | 2020-08-16 | Rankin | Mississippi | 28121 | 2429 | 42 |
442160 | 442160 | 2020-08-17 | Rankin | Mississippi | 28121 | 2437 | 42 |
445386 | 445386 | 2020-08-18 | Rankin | Mississippi | 28121 | 2456 | 43 |
448612 | 448612 | 2020-08-19 | Rankin | Mississippi | 28121 | 2507 | 44 |
451840 | 451840 | 2020-08-20 | Rankin | Mississippi | 28121 | 2529 | 44 |
455068 | 455068 | 2020-08-21 | Rankin | Mississippi | 28121 | 2556 | 45 |
458296 | 458296 | 2020-08-22 | Rankin | Mississippi | 28121 | 2635 | 47 |
461523 | 461523 | 2020-08-23 | Rankin | Mississippi | 28121 | 2665 | 47 |
464754 | 464754 | 2020-08-24 | Rankin | Mississippi | 28121 | 2688 | 47 |
467983 | 467983 | 2020-08-25 | Rankin | Mississippi | 28121 | 2708 | 54 |
471213 | 471213 | 2020-08-26 | Rankin | Mississippi | 28121 | 2756 | 59 |
474445 | 474445 | 2020-08-27 | Rankin | Mississippi | 28121 | 2785 | 60 |
477678 | 477678 | 2020-08-28 | Rankin | Mississippi | 28121 | 2797 | 61 |
480910 | 480910 | 2020-08-29 | Rankin | Mississippi | 28121 | 2817 | 62 |
484145 | 484145 | 2020-08-30 | Rankin | Mississippi | 28121 | 2842 | 63 |
487379 | 487379 | 2020-08-31 | Rankin | Mississippi | 28121 | 2850 | 63 |
490612 | 490612 | 2020-09-01 | Rankin | Mississippi | 28121 | 2857 | 63 |
493846 | 493846 | 2020-09-02 | Rankin | Mississippi | 28121 | 2882 | 65 |
497079 | 497079 | 2020-09-03 | Rankin | Mississippi | 28121 | 2914 | 66 |
500313 | 500313 | 2020-09-04 | Rankin | Mississippi | 28121 | 2956 | 69 |
503547 | 503547 | 2020-09-05 | Rankin | Mississippi | 28121 | 2987 | 69 |
506780 | 506780 | 2020-09-06 | Rankin | Mississippi | 28121 | 3003 | 69 |
510013 | 510013 | 2020-09-07 | Rankin | Mississippi | 28121 | 3010 | 69 |
513245 | 513245 | 2020-09-08 | Rankin | Mississippi | 28121 | 3018 | 69 |
516479 | 516479 | 2020-09-09 | Rankin | Mississippi | 28121 | 3025 | 70 |
519714 | 519714 | 2020-09-10 | Rankin | Mississippi | 28121 | 3035 | 71 |
522951 | 522951 | 2020-09-11 | Rankin | Mississippi | 28121 | 3053 | 71 |
526187 | 526187 | 2020-09-12 | Rankin | Mississippi | 28121 | 3067 | 72 |
529423 | 529423 | 2020-09-13 | Rankin | Mississippi | 28121 | 3075 | 72 |
532659 | 532659 | 2020-09-14 | Rankin | Mississippi | 28121 | 3075 | 72 |
535894 | 535894 | 2020-09-15 | Rankin | Mississippi | 28121 | 3094 | 73 |
539131 | 539131 | 2020-09-16 | Rankin | Mississippi | 28121 | 3121 | 73 |
542367 | 542367 | 2020-09-17 | Rankin | Mississippi | 28121 | 3134 | 73 |
545604 | 545604 | 2020-09-18 | Rankin | Mississippi | 28121 | 3161 | 74 |
548842 | 548842 | 2020-09-19 | Rankin | Mississippi | 28121 | 3188 | 75 |
552081 | 552081 | 2020-09-20 | Rankin | Mississippi | 28121 | 3190 | 75 |
555319 | 555319 | 2020-09-21 | Rankin | Mississippi | 28121 | 3193 | 75 |
558556 | 558556 | 2020-09-22 | Rankin | Mississippi | 28121 | 3202 | 76 |
561793 | 561793 | 2020-09-23 | Rankin | Mississippi | 28121 | 3225 | 77 |
565033 | 565033 | 2020-09-24 | Rankin | Mississippi | 28121 | 3256 | 77 |
568273 | 568273 | 2020-09-25 | Rankin | Mississippi | 28121 | 3293 | 77 |
571515 | 571515 | 2020-09-26 | Rankin | Mississippi | 28121 | 3306 | 79 |
574758 | 574758 | 2020-09-27 | Rankin | Mississippi | 28121 | 3308 | 79 |
577999 | 577999 | 2020-09-28 | Rankin | Mississippi | 28121 | 3311 | 79 |
581240 | 581240 | 2020-09-29 | Rankin | Mississippi | 28121 | 3346 | 79 |
584481 | 584481 | 2020-09-30 | Rankin | Mississippi | 28121 | 3372 | 80 |
587721 | 587721 | 2020-10-01 | Rankin | Mississippi | 28121 | 3401 | 80 |
590962 | 590962 | 2020-10-02 | Rankin | Mississippi | 28121 | 3419 | 80 |
594203 | 594203 | 2020-10-03 | Rankin | Mississippi | 28121 | 3431 | 80 |
597444 | 597444 | 2020-10-04 | Rankin | Mississippi | 28121 | 3446 | 80 |
600687 | 600687 | 2020-10-05 | Rankin | Mississippi | 28121 | 3458 | 80 |
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);