ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
60 rows where "date" is on date 2020-03-25 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
11552 | 11552 | 2020-03-25 | Adams | Mississippi | 28001 | 2 | 0 |
11553 | 11553 | 2020-03-25 | Attala | Mississippi | 28007 | 4 | 0 |
11554 | 11554 | 2020-03-25 | Bolivar | Mississippi | 28011 | 4 | 0 |
11555 | 11555 | 2020-03-25 | Calhoun | Mississippi | 28013 | 1 | 0 |
11556 | 11556 | 2020-03-25 | Chickasaw | Mississippi | 28017 | 6 | 0 |
11557 | 11557 | 2020-03-25 | Choctaw | Mississippi | 28019 | 3 | 0 |
11558 | 11558 | 2020-03-25 | Clay | Mississippi | 28025 | 1 | 0 |
11559 | 11559 | 2020-03-25 | Coahoma | Mississippi | 28027 | 11 | 0 |
11560 | 11560 | 2020-03-25 | Copiah | Mississippi | 28029 | 6 | 0 |
11561 | 11561 | 2020-03-25 | DeSoto | Mississippi | 28033 | 36 | 0 |
11562 | 11562 | 2020-03-25 | Forrest | Mississippi | 28035 | 15 | 0 |
11563 | 11563 | 2020-03-25 | Franklin | Mississippi | 28037 | 3 | 0 |
11564 | 11564 | 2020-03-25 | George | Mississippi | 28039 | 1 | 0 |
11565 | 11565 | 2020-03-25 | Grenada | Mississippi | 28043 | 2 | 0 |
11566 | 11566 | 2020-03-25 | Hancock | Mississippi | 28045 | 5 | 1 |
11567 | 11567 | 2020-03-25 | Harrison | Mississippi | 28047 | 25 | 0 |
11568 | 11568 | 2020-03-25 | Hinds | Mississippi | 28049 | 38 | 0 |
11569 | 11569 | 2020-03-25 | Holmes | Mississippi | 28051 | 7 | 1 |
11570 | 11570 | 2020-03-25 | Humphreys | Mississippi | 28053 | 1 | 0 |
11571 | 11571 | 2020-03-25 | Itawamba | Mississippi | 28057 | 3 | 0 |
11572 | 11572 | 2020-03-25 | Jackson | Mississippi | 28059 | 12 | 0 |
11573 | 11573 | 2020-03-25 | Jones | Mississippi | 28067 | 1 | 0 |
11574 | 11574 | 2020-03-25 | Lafayette | Mississippi | 28071 | 8 | 0 |
11575 | 11575 | 2020-03-25 | Lamar | Mississippi | 28073 | 2 | 0 |
11576 | 11576 | 2020-03-25 | Lawrence | Mississippi | 28077 | 3 | 0 |
11577 | 11577 | 2020-03-25 | Leake | Mississippi | 28079 | 3 | 0 |
11578 | 11578 | 2020-03-25 | Lee | Mississippi | 28081 | 14 | 0 |
11579 | 11579 | 2020-03-25 | Leflore | Mississippi | 28083 | 13 | 0 |
11580 | 11580 | 2020-03-25 | Lincoln | Mississippi | 28085 | 4 | 0 |
11581 | 11581 | 2020-03-25 | Lowndes | Mississippi | 28087 | 6 | 0 |
11582 | 11582 | 2020-03-25 | Madison | Mississippi | 28089 | 17 | 0 |
11583 | 11583 | 2020-03-25 | Marion | Mississippi | 28091 | 1 | 0 |
11584 | 11584 | 2020-03-25 | Marshall | Mississippi | 28093 | 4 | 0 |
11585 | 11585 | 2020-03-25 | Monroe | Mississippi | 28095 | 3 | 0 |
11586 | 11586 | 2020-03-25 | Montgomery | Mississippi | 28097 | 4 | 0 |
11587 | 11587 | 2020-03-25 | Newton | Mississippi | 28101 | 1 | 0 |
11588 | 11588 | 2020-03-25 | Noxubee | Mississippi | 28103 | 1 | 0 |
11589 | 11589 | 2020-03-25 | Oktibbeha | Mississippi | 28105 | 7 | 0 |
11590 | 11590 | 2020-03-25 | Panola | Mississippi | 28107 | 2 | 0 |
11591 | 11591 | 2020-03-25 | Pearl River | Mississippi | 28109 | 13 | 0 |
11592 | 11592 | 2020-03-25 | Perry | Mississippi | 28111 | 1 | 0 |
11593 | 11593 | 2020-03-25 | Pike | Mississippi | 28113 | 10 | 0 |
11594 | 11594 | 2020-03-25 | Pontotoc | Mississippi | 28115 | 2 | 0 |
11595 | 11595 | 2020-03-25 | Prentiss | Mississippi | 28117 | 1 | 0 |
11596 | 11596 | 2020-03-25 | Rankin | Mississippi | 28121 | 20 | 0 |
11597 | 11597 | 2020-03-25 | Scott | Mississippi | 28123 | 3 | 0 |
11598 | 11598 | 2020-03-25 | Simpson | Mississippi | 28127 | 1 | 0 |
11599 | 11599 | 2020-03-25 | Smith | Mississippi | 28129 | 1 | 0 |
11600 | 11600 | 2020-03-25 | Sunflower | Mississippi | 28133 | 3 | 0 |
11601 | 11601 | 2020-03-25 | Tallahatchie | Mississippi | 28135 | 2 | 0 |
11602 | 11602 | 2020-03-25 | Tate | Mississippi | 28137 | 2 | 0 |
11603 | 11603 | 2020-03-25 | Tippah | Mississippi | 28139 | 11 | 0 |
11604 | 11604 | 2020-03-25 | Tunica | Mississippi | 28143 | 3 | 1 |
11605 | 11605 | 2020-03-25 | Union | Mississippi | 28145 | 2 | 0 |
11606 | 11606 | 2020-03-25 | Walthall | Mississippi | 28147 | 3 | 0 |
11607 | 11607 | 2020-03-25 | Washington | Mississippi | 28151 | 5 | 0 |
11608 | 11608 | 2020-03-25 | Webster | Mississippi | 28155 | 2 | 1 |
11609 | 11609 | 2020-03-25 | Wilkinson | Mississippi | 28157 | 5 | 1 |
11610 | 11610 | 2020-03-25 | Winston | Mississippi | 28159 | 3 | 0 |
11611 | 11611 | 2020-03-25 | Yazoo | Mississippi | 28163 | 3 | 0 |
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);