ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
38 rows where cases = 109 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
756366 | 756366 | 2020-11-22 | Issaquena | Mississippi | 28055 | 109 | 4 |
355300 | 355300 | 2020-07-21 | Stone | Mississippi | 28131 | 109 | 2 |
329730 | 329730 | 2020-07-13 | Tishomingo | Mississippi | 28141 | 109 | 1 |
297963 | 297963 | 2020-07-03 | Jefferson Davis | Mississippi | 28065 | 109 | 4 |
275903 | 275903 | 2020-06-26 | Humphreys | Mississippi | 28053 | 109 | 9 |
269665 | 269665 | 2020-06-24 | Tippah | Mississippi | 28139 | 109 | 11 |
263365 | 263365 | 2020-06-22 | Itawamba | Mississippi | 28057 | 109 | 8 |
260280 | 260280 | 2020-06-21 | Union | Mississippi | 28145 | 109 | 8 |
260286 | 260286 | 2020-06-21 | Webster | Mississippi | 28155 | 109 | 8 |
257154 | 257154 | 2020-06-20 | Union | Mississippi | 28145 | 109 | 8 |
257160 | 257160 | 2020-06-20 | Webster | Mississippi | 28155 | 109 | 8 |
254034 | 254034 | 2020-06-19 | Union | Mississippi | 28145 | 109 | 8 |
254040 | 254040 | 2020-06-19 | Webster | Mississippi | 28155 | 109 | 8 |
250919 | 250919 | 2020-06-18 | Union | Mississippi | 28145 | 109 | 8 |
250925 | 250925 | 2020-06-18 | Webster | Mississippi | 28155 | 109 | 8 |
247807 | 247807 | 2020-06-17 | Union | Mississippi | 28145 | 109 | 8 |
247812 | 247812 | 2020-06-17 | Webster | Mississippi | 28155 | 109 | 8 |
244699 | 244699 | 2020-06-16 | Webster | Mississippi | 28155 | 109 | 8 |
241588 | 241588 | 2020-06-15 | Webster | Mississippi | 28155 | 109 | 8 |
235372 | 235372 | 2020-06-13 | Webster | Mississippi | 28155 | 109 | 8 |
232266 | 232266 | 2020-06-12 | Webster | Mississippi | 28155 | 109 | 8 |
229151 | 229151 | 2020-06-11 | Sunflower | Mississippi | 28133 | 109 | 4 |
226049 | 226049 | 2020-06-10 | Sunflower | Mississippi | 28133 | 109 | 4 |
222923 | 222923 | 2020-06-09 | Lawrence | Mississippi | 28077 | 109 | 1 |
219828 | 219828 | 2020-06-08 | Lawrence | Mississippi | 28077 | 109 | 1 |
189090 | 189090 | 2020-05-29 | Winston | Mississippi | 28159 | 109 | 1 |
173840 | 173840 | 2020-05-24 | Wayne | Mississippi | 28153 | 109 | 0 |
158628 | 158628 | 2020-05-19 | Lafayette | Mississippi | 28071 | 109 | 3 |
155610 | 155610 | 2020-05-18 | Lafayette | Mississippi | 28071 | 109 | 3 |
152596 | 152596 | 2020-05-17 | Lafayette | Mississippi | 28071 | 109 | 3 |
146553 | 146553 | 2020-05-15 | Carroll | Mississippi | 28015 | 109 | 4 |
146609 | 146609 | 2020-05-15 | Smith | Mississippi | 28129 | 109 | 7 |
105189 | 105189 | 2020-05-01 | Attala | Mississippi | 28007 | 109 | 0 |
88154 | 88154 | 2020-04-25 | Adams | Mississippi | 28001 | 109 | 7 |
82586 | 82586 | 2020-04-23 | Monroe | Mississippi | 28095 | 109 | 9 |
76999 | 76999 | 2020-04-21 | Leflore | Mississippi | 28083 | 109 | 12 |
77000 | 77000 | 2020-04-21 | Lincoln | Mississippi | 28085 | 109 | 6 |
24946 | 24946 | 2020-04-01 | Hinds | Mississippi | 28049 | 109 | 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);