ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 28109 and state = "Mississippi" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
260262 | 260262 | 2020-06-21 | Pearl River | Mississippi | 28109 | 224 | 32 |
263391 | 263391 | 2020-06-22 | Pearl River | Mississippi | 28109 | 226 | 32 |
266517 | 266517 | 2020-06-23 | Pearl River | Mississippi | 28109 | 227 | 32 |
269650 | 269650 | 2020-06-24 | Pearl River | Mississippi | 28109 | 228 | 32 |
272788 | 272788 | 2020-06-25 | Pearl River | Mississippi | 28109 | 232 | 32 |
275931 | 275931 | 2020-06-26 | Pearl River | Mississippi | 28109 | 235 | 32 |
279079 | 279079 | 2020-06-27 | Pearl River | Mississippi | 28109 | 236 | 32 |
282227 | 282227 | 2020-06-28 | Pearl River | Mississippi | 28109 | 236 | 32 |
285372 | 285372 | 2020-06-29 | Pearl River | Mississippi | 28109 | 237 | 32 |
288522 | 288522 | 2020-06-30 | Pearl River | Mississippi | 28109 | 239 | 32 |
291673 | 291673 | 2020-07-01 | Pearl River | Mississippi | 28109 | 244 | 32 |
294827 | 294827 | 2020-07-02 | Pearl River | Mississippi | 28109 | 245 | 32 |
297985 | 297985 | 2020-07-03 | Pearl River | Mississippi | 28109 | 248 | 32 |
301148 | 301148 | 2020-07-04 | Pearl River | Mississippi | 28109 | 254 | 32 |
304312 | 304312 | 2020-07-05 | Pearl River | Mississippi | 28109 | 254 | 32 |
307479 | 307479 | 2020-07-06 | Pearl River | Mississippi | 28109 | 257 | 32 |
310647 | 310647 | 2020-07-07 | Pearl River | Mississippi | 28109 | 265 | 32 |
313817 | 313817 | 2020-07-08 | Pearl River | Mississippi | 28109 | 269 | 32 |
316991 | 316991 | 2020-07-09 | Pearl River | Mississippi | 28109 | 276 | 32 |
320166 | 320166 | 2020-07-10 | Pearl River | Mississippi | 28109 | 281 | 32 |
323345 | 323345 | 2020-07-11 | Pearl River | Mississippi | 28109 | 288 | 32 |
326528 | 326528 | 2020-07-12 | Pearl River | Mississippi | 28109 | 303 | 32 |
329714 | 329714 | 2020-07-13 | Pearl River | Mississippi | 28109 | 308 | 32 |
332901 | 332901 | 2020-07-14 | Pearl River | Mississippi | 28109 | 317 | 32 |
336094 | 336094 | 2020-07-15 | Pearl River | Mississippi | 28109 | 323 | 32 |
339290 | 339290 | 2020-07-16 | Pearl River | Mississippi | 28109 | 331 | 32 |
342486 | 342486 | 2020-07-17 | Pearl River | Mississippi | 28109 | 346 | 32 |
345686 | 345686 | 2020-07-18 | Pearl River | Mississippi | 28109 | 355 | 32 |
348887 | 348887 | 2020-07-19 | Pearl River | Mississippi | 28109 | 363 | 32 |
352087 | 352087 | 2020-07-20 | Pearl River | Mississippi | 28109 | 371 | 32 |
355289 | 355289 | 2020-07-21 | Pearl River | Mississippi | 28109 | 383 | 32 |
358492 | 358492 | 2020-07-22 | Pearl River | Mississippi | 28109 | 391 | 32 |
361697 | 361697 | 2020-07-23 | Pearl River | Mississippi | 28109 | 392 | 32 |
364904 | 364904 | 2020-07-24 | Pearl River | Mississippi | 28109 | 403 | 34 |
368112 | 368112 | 2020-07-25 | Pearl River | Mississippi | 28109 | 419 | 34 |
371322 | 371322 | 2020-07-26 | Pearl River | Mississippi | 28109 | 427 | 34 |
374534 | 374534 | 2020-07-27 | Pearl River | Mississippi | 28109 | 431 | 34 |
377749 | 377749 | 2020-07-28 | Pearl River | Mississippi | 28109 | 444 | 35 |
380966 | 380966 | 2020-07-29 | Pearl River | Mississippi | 28109 | 452 | 35 |
384183 | 384183 | 2020-07-30 | Pearl River | Mississippi | 28109 | 462 | 35 |
387401 | 387401 | 2020-07-31 | Pearl River | Mississippi | 28109 | 471 | 36 |
390618 | 390618 | 2020-08-01 | Pearl River | Mississippi | 28109 | 480 | 36 |
393835 | 393835 | 2020-08-02 | Pearl River | Mississippi | 28109 | 482 | 36 |
397051 | 397051 | 2020-08-03 | Pearl River | Mississippi | 28109 | 485 | 36 |
400265 | 400265 | 2020-08-04 | Pearl River | Mississippi | 28109 | 496 | 37 |
403482 | 403482 | 2020-08-05 | Pearl River | Mississippi | 28109 | 515 | 37 |
406700 | 406700 | 2020-08-06 | Pearl River | Mississippi | 28109 | 520 | 37 |
409920 | 409920 | 2020-08-07 | Pearl River | Mississippi | 28109 | 529 | 37 |
413140 | 413140 | 2020-08-08 | Pearl River | Mississippi | 28109 | 540 | 38 |
416360 | 416360 | 2020-08-09 | Pearl River | Mississippi | 28109 | 550 | 39 |
419581 | 419581 | 2020-08-10 | Pearl River | Mississippi | 28109 | 554 | 39 |
422803 | 422803 | 2020-08-11 | Pearl River | Mississippi | 28109 | 559 | 40 |
426025 | 426025 | 2020-08-12 | Pearl River | Mississippi | 28109 | 567 | 40 |
429249 | 429249 | 2020-08-13 | Pearl River | Mississippi | 28109 | 571 | 40 |
432476 | 432476 | 2020-08-14 | Pearl River | Mississippi | 28109 | 584 | 40 |
435702 | 435702 | 2020-08-15 | Pearl River | Mississippi | 28109 | 596 | 41 |
438927 | 438927 | 2020-08-16 | Pearl River | Mississippi | 28109 | 601 | 41 |
442154 | 442154 | 2020-08-17 | Pearl River | Mississippi | 28109 | 613 | 42 |
445380 | 445380 | 2020-08-18 | Pearl River | Mississippi | 28109 | 618 | 42 |
448606 | 448606 | 2020-08-19 | Pearl River | Mississippi | 28109 | 632 | 44 |
451834 | 451834 | 2020-08-20 | Pearl River | Mississippi | 28109 | 643 | 44 |
455062 | 455062 | 2020-08-21 | Pearl River | Mississippi | 28109 | 660 | 45 |
458290 | 458290 | 2020-08-22 | Pearl River | Mississippi | 28109 | 672 | 45 |
461517 | 461517 | 2020-08-23 | Pearl River | Mississippi | 28109 | 682 | 45 |
464748 | 464748 | 2020-08-24 | Pearl River | Mississippi | 28109 | 697 | 45 |
467977 | 467977 | 2020-08-25 | Pearl River | Mississippi | 28109 | 708 | 46 |
471207 | 471207 | 2020-08-26 | Pearl River | Mississippi | 28109 | 718 | 48 |
474439 | 474439 | 2020-08-27 | Pearl River | Mississippi | 28109 | 726 | 48 |
477672 | 477672 | 2020-08-28 | Pearl River | Mississippi | 28109 | 733 | 48 |
480904 | 480904 | 2020-08-29 | Pearl River | Mississippi | 28109 | 743 | 48 |
484139 | 484139 | 2020-08-30 | Pearl River | Mississippi | 28109 | 748 | 48 |
487373 | 487373 | 2020-08-31 | Pearl River | Mississippi | 28109 | 751 | 48 |
490606 | 490606 | 2020-09-01 | Pearl River | Mississippi | 28109 | 752 | 48 |
493840 | 493840 | 2020-09-02 | Pearl River | Mississippi | 28109 | 758 | 48 |
497073 | 497073 | 2020-09-03 | Pearl River | Mississippi | 28109 | 771 | 48 |
500307 | 500307 | 2020-09-04 | Pearl River | Mississippi | 28109 | 786 | 48 |
503541 | 503541 | 2020-09-05 | Pearl River | Mississippi | 28109 | 787 | 48 |
506774 | 506774 | 2020-09-06 | Pearl River | Mississippi | 28109 | 790 | 49 |
510007 | 510007 | 2020-09-07 | Pearl River | Mississippi | 28109 | 791 | 49 |
513239 | 513239 | 2020-09-08 | Pearl River | Mississippi | 28109 | 794 | 49 |
516473 | 516473 | 2020-09-09 | Pearl River | Mississippi | 28109 | 799 | 49 |
519708 | 519708 | 2020-09-10 | Pearl River | Mississippi | 28109 | 801 | 49 |
522945 | 522945 | 2020-09-11 | Pearl River | Mississippi | 28109 | 818 | 49 |
526181 | 526181 | 2020-09-12 | Pearl River | Mississippi | 28109 | 819 | 49 |
529417 | 529417 | 2020-09-13 | Pearl River | Mississippi | 28109 | 822 | 49 |
532653 | 532653 | 2020-09-14 | Pearl River | Mississippi | 28109 | 823 | 49 |
535888 | 535888 | 2020-09-15 | Pearl River | Mississippi | 28109 | 828 | 49 |
539125 | 539125 | 2020-09-16 | Pearl River | Mississippi | 28109 | 833 | 49 |
542361 | 542361 | 2020-09-17 | Pearl River | Mississippi | 28109 | 848 | 50 |
545598 | 545598 | 2020-09-18 | Pearl River | Mississippi | 28109 | 851 | 50 |
548836 | 548836 | 2020-09-19 | Pearl River | Mississippi | 28109 | 862 | 50 |
552075 | 552075 | 2020-09-20 | Pearl River | Mississippi | 28109 | 865 | 50 |
555313 | 555313 | 2020-09-21 | Pearl River | Mississippi | 28109 | 867 | 50 |
558550 | 558550 | 2020-09-22 | Pearl River | Mississippi | 28109 | 869 | 52 |
561787 | 561787 | 2020-09-23 | Pearl River | Mississippi | 28109 | 870 | 53 |
565027 | 565027 | 2020-09-24 | Pearl River | Mississippi | 28109 | 873 | 53 |
568267 | 568267 | 2020-09-25 | Pearl River | Mississippi | 28109 | 883 | 53 |
571509 | 571509 | 2020-09-26 | Pearl River | Mississippi | 28109 | 892 | 53 |
574752 | 574752 | 2020-09-27 | Pearl River | Mississippi | 28109 | 894 | 53 |
577993 | 577993 | 2020-09-28 | Pearl River | Mississippi | 28109 | 896 | 53 |
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);