ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Tate" and state = "Mississippi" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
7700 | 7700 | 2020-03-22 | Tate | Mississippi | 28137 | 1 | 0 |
8883 | 8883 | 2020-03-23 | Tate | Mississippi | 28137 | 1 | 0 |
10181 | 10181 | 2020-03-24 | Tate | Mississippi | 28137 | 1 | 0 |
11602 | 11602 | 2020-03-25 | Tate | Mississippi | 28137 | 2 | 0 |
13196 | 13196 | 2020-03-26 | Tate | Mississippi | 28137 | 6 | 0 |
14916 | 14916 | 2020-03-27 | Tate | Mississippi | 28137 | 8 | 0 |
16740 | 16740 | 2020-03-28 | Tate | Mississippi | 28137 | 8 | 0 |
18662 | 18662 | 2020-03-29 | Tate | Mississippi | 28137 | 9 | 0 |
20686 | 20686 | 2020-03-30 | Tate | Mississippi | 28137 | 11 | 0 |
22803 | 22803 | 2020-03-31 | Tate | Mississippi | 28137 | 11 | 0 |
24987 | 24987 | 2020-04-01 | Tate | Mississippi | 28137 | 11 | 0 |
27241 | 27241 | 2020-04-02 | Tate | Mississippi | 28137 | 12 | 0 |
29560 | 29560 | 2020-04-03 | Tate | Mississippi | 28137 | 13 | 0 |
31940 | 31940 | 2020-04-04 | Tate | Mississippi | 28137 | 14 | 0 |
34368 | 34368 | 2020-04-05 | Tate | Mississippi | 28137 | 15 | 0 |
36831 | 36831 | 2020-04-06 | Tate | Mississippi | 28137 | 16 | 0 |
39342 | 39342 | 2020-04-07 | Tate | Mississippi | 28137 | 18 | 0 |
41896 | 41896 | 2020-04-08 | Tate | Mississippi | 28137 | 18 | 0 |
44473 | 44473 | 2020-04-09 | Tate | Mississippi | 28137 | 19 | 0 |
47082 | 47082 | 2020-04-10 | Tate | Mississippi | 28137 | 22 | 0 |
49728 | 49728 | 2020-04-11 | Tate | Mississippi | 28137 | 23 | 0 |
52401 | 52401 | 2020-04-12 | Tate | Mississippi | 28137 | 24 | 0 |
55083 | 55083 | 2020-04-13 | Tate | Mississippi | 28137 | 24 | 0 |
57781 | 57781 | 2020-04-14 | Tate | Mississippi | 28137 | 25 | 0 |
60492 | 60492 | 2020-04-15 | Tate | Mississippi | 28137 | 26 | 0 |
63214 | 63214 | 2020-04-16 | Tate | Mississippi | 28137 | 27 | 0 |
65954 | 65954 | 2020-04-17 | Tate | Mississippi | 28137 | 27 | 0 |
68706 | 68706 | 2020-04-18 | Tate | Mississippi | 28137 | 29 | 0 |
71472 | 71472 | 2020-04-19 | Tate | Mississippi | 28137 | 31 | 0 |
74245 | 74245 | 2020-04-20 | Tate | Mississippi | 28137 | 34 | 0 |
77026 | 77026 | 2020-04-21 | Tate | Mississippi | 28137 | 34 | 0 |
79811 | 79811 | 2020-04-22 | Tate | Mississippi | 28137 | 35 | 0 |
82607 | 82607 | 2020-04-23 | Tate | Mississippi | 28137 | 35 | 0 |
85411 | 85411 | 2020-04-24 | Tate | Mississippi | 28137 | 38 | 0 |
88221 | 88221 | 2020-04-25 | Tate | Mississippi | 28137 | 38 | 0 |
91037 | 91037 | 2020-04-26 | Tate | Mississippi | 28137 | 38 | 0 |
93858 | 93858 | 2020-04-27 | Tate | Mississippi | 28137 | 38 | 0 |
96694 | 96694 | 2020-04-28 | Tate | Mississippi | 28137 | 39 | 0 |
99540 | 99540 | 2020-04-29 | Tate | Mississippi | 28137 | 41 | 0 |
102392 | 102392 | 2020-04-30 | Tate | Mississippi | 28137 | 41 | 0 |
105253 | 105253 | 2020-05-01 | Tate | Mississippi | 28137 | 42 | 0 |
108118 | 108118 | 2020-05-02 | Tate | Mississippi | 28137 | 41 | 0 |
110989 | 110989 | 2020-05-03 | Tate | Mississippi | 28137 | 43 | 0 |
113868 | 113868 | 2020-05-04 | Tate | Mississippi | 28137 | 45 | 0 |
116750 | 116750 | 2020-05-05 | Tate | Mississippi | 28137 | 45 | 0 |
119710 | 119710 | 2020-05-06 | Tate | Mississippi | 28137 | 45 | 0 |
122684 | 122684 | 2020-05-07 | Tate | Mississippi | 28137 | 48 | 0 |
125666 | 125666 | 2020-05-08 | Tate | Mississippi | 28137 | 49 | 0 |
128653 | 128653 | 2020-05-09 | Tate | Mississippi | 28137 | 50 | 0 |
131643 | 131643 | 2020-05-10 | Tate | Mississippi | 28137 | 50 | 0 |
134634 | 134634 | 2020-05-11 | Tate | Mississippi | 28137 | 52 | 0 |
137624 | 137624 | 2020-05-12 | Tate | Mississippi | 28137 | 54 | 0 |
140618 | 140618 | 2020-05-13 | Tate | Mississippi | 28137 | 54 | 0 |
143613 | 143613 | 2020-05-14 | Tate | Mississippi | 28137 | 55 | 0 |
146613 | 146613 | 2020-05-15 | Tate | Mississippi | 28137 | 55 | 0 |
149618 | 149618 | 2020-05-16 | Tate | Mississippi | 28137 | 56 | 0 |
152629 | 152629 | 2020-05-17 | Tate | Mississippi | 28137 | 57 | 0 |
155643 | 155643 | 2020-05-18 | Tate | Mississippi | 28137 | 55 | 0 |
158661 | 158661 | 2020-05-19 | Tate | Mississippi | 28137 | 55 | 1 |
161687 | 161687 | 2020-05-20 | Tate | Mississippi | 28137 | 56 | 1 |
164716 | 164716 | 2020-05-21 | Tate | Mississippi | 28137 | 58 | 1 |
167752 | 167752 | 2020-05-22 | Tate | Mississippi | 28137 | 59 | 1 |
170790 | 170790 | 2020-05-23 | Tate | Mississippi | 28137 | 58 | 1 |
173832 | 173832 | 2020-05-24 | Tate | Mississippi | 28137 | 59 | 1 |
176875 | 176875 | 2020-05-25 | Tate | Mississippi | 28137 | 59 | 1 |
179919 | 179919 | 2020-05-26 | Tate | Mississippi | 28137 | 66 | 1 |
182965 | 182965 | 2020-05-27 | Tate | Mississippi | 28137 | 69 | 1 |
186021 | 186021 | 2020-05-28 | Tate | Mississippi | 28137 | 74 | 1 |
189079 | 189079 | 2020-05-29 | Tate | Mississippi | 28137 | 81 | 1 |
192143 | 192143 | 2020-05-30 | Tate | Mississippi | 28137 | 89 | 1 |
195211 | 195211 | 2020-05-31 | Tate | Mississippi | 28137 | 94 | 1 |
198282 | 198282 | 2020-06-01 | Tate | Mississippi | 28137 | 95 | 1 |
201355 | 201355 | 2020-06-02 | Tate | Mississippi | 28137 | 89 | 1 |
204432 | 204432 | 2020-06-03 | Tate | Mississippi | 28137 | 88 | 1 |
207513 | 207513 | 2020-06-04 | Tate | Mississippi | 28137 | 91 | 1 |
210594 | 210594 | 2020-06-05 | Tate | Mississippi | 28137 | 93 | 1 |
213678 | 213678 | 2020-06-06 | Tate | Mississippi | 28137 | 95 | 1 |
216766 | 216766 | 2020-06-07 | Tate | Mississippi | 28137 | 96 | 1 |
219858 | 219858 | 2020-06-08 | Tate | Mississippi | 28137 | 103 | 1 |
222953 | 222953 | 2020-06-09 | Tate | Mississippi | 28137 | 112 | 1 |
226051 | 226051 | 2020-06-10 | Tate | Mississippi | 28137 | 118 | 1 |
229153 | 229153 | 2020-06-11 | Tate | Mississippi | 28137 | 118 | 1 |
232257 | 232257 | 2020-06-12 | Tate | Mississippi | 28137 | 123 | 1 |
235363 | 235363 | 2020-06-13 | Tate | Mississippi | 28137 | 128 | 1 |
238470 | 238470 | 2020-06-14 | Tate | Mississippi | 28137 | 128 | 1 |
241579 | 241579 | 2020-06-15 | Tate | Mississippi | 28137 | 134 | 1 |
244690 | 244690 | 2020-06-16 | Tate | Mississippi | 28137 | 135 | 1 |
247803 | 247803 | 2020-06-17 | Tate | Mississippi | 28137 | 155 | 1 |
250915 | 250915 | 2020-06-18 | Tate | Mississippi | 28137 | 155 | 1 |
254030 | 254030 | 2020-06-19 | Tate | Mississippi | 28137 | 155 | 1 |
257150 | 257150 | 2020-06-20 | Tate | Mississippi | 28137 | 155 | 1 |
260276 | 260276 | 2020-06-21 | Tate | Mississippi | 28137 | 155 | 1 |
263405 | 263405 | 2020-06-22 | Tate | Mississippi | 28137 | 182 | 2 |
266531 | 266531 | 2020-06-23 | Tate | Mississippi | 28137 | 192 | 4 |
269664 | 269664 | 2020-06-24 | Tate | Mississippi | 28137 | 211 | 5 |
272802 | 272802 | 2020-06-25 | Tate | Mississippi | 28137 | 221 | 5 |
275945 | 275945 | 2020-06-26 | Tate | Mississippi | 28137 | 230 | 5 |
279093 | 279093 | 2020-06-27 | Tate | Mississippi | 28137 | 233 | 6 |
282241 | 282241 | 2020-06-28 | Tate | Mississippi | 28137 | 234 | 6 |
285386 | 285386 | 2020-06-29 | Tate | Mississippi | 28137 | 242 | 6 |
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);