ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Carroll" and state = "Mississippi" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
18606 | 18606 | 2020-03-29 | Carroll | Mississippi | 28015 | 1 | 0 |
20630 | 20630 | 2020-03-30 | Carroll | Mississippi | 28015 | 1 | 0 |
22747 | 22747 | 2020-03-31 | Carroll | Mississippi | 28015 | 1 | 0 |
24930 | 24930 | 2020-04-01 | Carroll | Mississippi | 28015 | 2 | 0 |
27184 | 27184 | 2020-04-02 | Carroll | Mississippi | 28015 | 3 | 0 |
29503 | 29503 | 2020-04-03 | Carroll | Mississippi | 28015 | 5 | 0 |
31883 | 31883 | 2020-04-04 | Carroll | Mississippi | 28015 | 5 | 0 |
34310 | 34310 | 2020-04-05 | Carroll | Mississippi | 28015 | 5 | 0 |
36772 | 36772 | 2020-04-06 | Carroll | Mississippi | 28015 | 6 | 0 |
39283 | 39283 | 2020-04-07 | Carroll | Mississippi | 28015 | 7 | 0 |
41837 | 41837 | 2020-04-08 | Carroll | Mississippi | 28015 | 7 | 0 |
44413 | 44413 | 2020-04-09 | Carroll | Mississippi | 28015 | 7 | 0 |
47022 | 47022 | 2020-04-10 | Carroll | Mississippi | 28015 | 7 | 0 |
49668 | 49668 | 2020-04-11 | Carroll | Mississippi | 28015 | 7 | 0 |
52341 | 52341 | 2020-04-12 | Carroll | Mississippi | 28015 | 7 | 0 |
55023 | 55023 | 2020-04-13 | Carroll | Mississippi | 28015 | 8 | 0 |
57721 | 57721 | 2020-04-14 | Carroll | Mississippi | 28015 | 8 | 0 |
60432 | 60432 | 2020-04-15 | Carroll | Mississippi | 28015 | 9 | 0 |
63154 | 63154 | 2020-04-16 | Carroll | Mississippi | 28015 | 9 | 1 |
65894 | 65894 | 2020-04-17 | Carroll | Mississippi | 28015 | 10 | 1 |
68646 | 68646 | 2020-04-18 | Carroll | Mississippi | 28015 | 10 | 1 |
71412 | 71412 | 2020-04-19 | Carroll | Mississippi | 28015 | 14 | 1 |
74185 | 74185 | 2020-04-20 | Carroll | Mississippi | 28015 | 14 | 1 |
76966 | 76966 | 2020-04-21 | Carroll | Mississippi | 28015 | 14 | 1 |
79751 | 79751 | 2020-04-22 | Carroll | Mississippi | 28015 | 15 | 1 |
82547 | 82547 | 2020-04-23 | Carroll | Mississippi | 28015 | 15 | 1 |
85351 | 85351 | 2020-04-24 | Carroll | Mississippi | 28015 | 15 | 1 |
88161 | 88161 | 2020-04-25 | Carroll | Mississippi | 28015 | 15 | 1 |
90977 | 90977 | 2020-04-26 | Carroll | Mississippi | 28015 | 18 | 1 |
93798 | 93798 | 2020-04-27 | Carroll | Mississippi | 28015 | 20 | 1 |
96634 | 96634 | 2020-04-28 | Carroll | Mississippi | 28015 | 22 | 1 |
99480 | 99480 | 2020-04-29 | Carroll | Mississippi | 28015 | 25 | 1 |
102332 | 102332 | 2020-04-30 | Carroll | Mississippi | 28015 | 38 | 1 |
105193 | 105193 | 2020-05-01 | Carroll | Mississippi | 28015 | 58 | 1 |
108058 | 108058 | 2020-05-02 | Carroll | Mississippi | 28015 | 60 | 1 |
110929 | 110929 | 2020-05-03 | Carroll | Mississippi | 28015 | 62 | 2 |
113808 | 113808 | 2020-05-04 | Carroll | Mississippi | 28015 | 77 | 2 |
116690 | 116690 | 2020-05-05 | Carroll | Mississippi | 28015 | 111 | 3 |
119650 | 119650 | 2020-05-06 | Carroll | Mississippi | 28015 | 102 | 3 |
122624 | 122624 | 2020-05-07 | Carroll | Mississippi | 28015 | 99 | 3 |
125606 | 125606 | 2020-05-08 | Carroll | Mississippi | 28015 | 97 | 4 |
128593 | 128593 | 2020-05-09 | Carroll | Mississippi | 28015 | 101 | 4 |
131583 | 131583 | 2020-05-10 | Carroll | Mississippi | 28015 | 103 | 4 |
134574 | 134574 | 2020-05-11 | Carroll | Mississippi | 28015 | 103 | 4 |
137564 | 137564 | 2020-05-12 | Carroll | Mississippi | 28015 | 105 | 4 |
140558 | 140558 | 2020-05-13 | Carroll | Mississippi | 28015 | 105 | 4 |
143553 | 143553 | 2020-05-14 | Carroll | Mississippi | 28015 | 106 | 4 |
146553 | 146553 | 2020-05-15 | Carroll | Mississippi | 28015 | 109 | 4 |
149558 | 149558 | 2020-05-16 | Carroll | Mississippi | 28015 | 110 | 6 |
152569 | 152569 | 2020-05-17 | Carroll | Mississippi | 28015 | 110 | 7 |
155583 | 155583 | 2020-05-18 | Carroll | Mississippi | 28015 | 110 | 7 |
158601 | 158601 | 2020-05-19 | Carroll | Mississippi | 28015 | 110 | 8 |
161627 | 161627 | 2020-05-20 | Carroll | Mississippi | 28015 | 111 | 8 |
164656 | 164656 | 2020-05-21 | Carroll | Mississippi | 28015 | 112 | 9 |
167692 | 167692 | 2020-05-22 | Carroll | Mississippi | 28015 | 113 | 9 |
170730 | 170730 | 2020-05-23 | Carroll | Mississippi | 28015 | 113 | 9 |
173772 | 173772 | 2020-05-24 | Carroll | Mississippi | 28015 | 113 | 10 |
176815 | 176815 | 2020-05-25 | Carroll | Mississippi | 28015 | 113 | 10 |
179859 | 179859 | 2020-05-26 | Carroll | Mississippi | 28015 | 114 | 10 |
182905 | 182905 | 2020-05-27 | Carroll | Mississippi | 28015 | 114 | 10 |
185961 | 185961 | 2020-05-28 | Carroll | Mississippi | 28015 | 115 | 11 |
189019 | 189019 | 2020-05-29 | Carroll | Mississippi | 28015 | 118 | 11 |
192083 | 192083 | 2020-05-30 | Carroll | Mississippi | 28015 | 117 | 11 |
195151 | 195151 | 2020-05-31 | Carroll | Mississippi | 28015 | 117 | 11 |
198222 | 198222 | 2020-06-01 | Carroll | Mississippi | 28015 | 117 | 11 |
201295 | 201295 | 2020-06-02 | Carroll | Mississippi | 28015 | 116 | 11 |
204372 | 204372 | 2020-06-03 | Carroll | Mississippi | 28015 | 116 | 11 |
207453 | 207453 | 2020-06-04 | Carroll | Mississippi | 28015 | 119 | 11 |
210534 | 210534 | 2020-06-05 | Carroll | Mississippi | 28015 | 119 | 11 |
213618 | 213618 | 2020-06-06 | Carroll | Mississippi | 28015 | 119 | 11 |
216706 | 216706 | 2020-06-07 | Carroll | Mississippi | 28015 | 119 | 11 |
219798 | 219798 | 2020-06-08 | Carroll | Mississippi | 28015 | 120 | 11 |
222893 | 222893 | 2020-06-09 | Carroll | Mississippi | 28015 | 121 | 11 |
225991 | 225991 | 2020-06-10 | Carroll | Mississippi | 28015 | 123 | 11 |
229093 | 229093 | 2020-06-11 | Carroll | Mississippi | 28015 | 123 | 11 |
232197 | 232197 | 2020-06-12 | Carroll | Mississippi | 28015 | 122 | 11 |
235303 | 235303 | 2020-06-13 | Carroll | Mississippi | 28015 | 122 | 11 |
238410 | 238410 | 2020-06-14 | Carroll | Mississippi | 28015 | 122 | 11 |
241519 | 241519 | 2020-06-15 | Carroll | Mississippi | 28015 | 122 | 11 |
244630 | 244630 | 2020-06-16 | Carroll | Mississippi | 28015 | 122 | 11 |
247743 | 247743 | 2020-06-17 | Carroll | Mississippi | 28015 | 122 | 11 |
250855 | 250855 | 2020-06-18 | Carroll | Mississippi | 28015 | 122 | 11 |
253970 | 253970 | 2020-06-19 | Carroll | Mississippi | 28015 | 122 | 11 |
257090 | 257090 | 2020-06-20 | Carroll | Mississippi | 28015 | 122 | 11 |
260216 | 260216 | 2020-06-21 | Carroll | Mississippi | 28015 | 122 | 11 |
263345 | 263345 | 2020-06-22 | Carroll | Mississippi | 28015 | 133 | 11 |
266471 | 266471 | 2020-06-23 | Carroll | Mississippi | 28015 | 135 | 11 |
269604 | 269604 | 2020-06-24 | Carroll | Mississippi | 28015 | 138 | 11 |
272741 | 272741 | 2020-06-25 | Carroll | Mississippi | 28015 | 141 | 11 |
275884 | 275884 | 2020-06-26 | Carroll | Mississippi | 28015 | 145 | 11 |
279032 | 279032 | 2020-06-27 | Carroll | Mississippi | 28015 | 147 | 11 |
282180 | 282180 | 2020-06-28 | Carroll | Mississippi | 28015 | 147 | 11 |
285325 | 285325 | 2020-06-29 | Carroll | Mississippi | 28015 | 149 | 11 |
288475 | 288475 | 2020-06-30 | Carroll | Mississippi | 28015 | 157 | 11 |
291626 | 291626 | 2020-07-01 | Carroll | Mississippi | 28015 | 160 | 11 |
294780 | 294780 | 2020-07-02 | Carroll | Mississippi | 28015 | 161 | 11 |
297938 | 297938 | 2020-07-03 | Carroll | Mississippi | 28015 | 164 | 11 |
301101 | 301101 | 2020-07-04 | Carroll | Mississippi | 28015 | 164 | 11 |
304265 | 304265 | 2020-07-05 | Carroll | Mississippi | 28015 | 165 | 11 |
307432 | 307432 | 2020-07-06 | Carroll | Mississippi | 28015 | 166 | 11 |
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);