ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,524 rows where county = "Mississippi" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
26223 | 26223 | 2020-04-02 | Mississippi | Arkansas | 5093 | 1 | 0 |
28521 | 28521 | 2020-04-03 | Mississippi | Arkansas | 5093 | 1 | 0 |
30879 | 30879 | 2020-04-04 | Mississippi | Arkansas | 5093 | 2 | 0 |
33283 | 33283 | 2020-04-05 | Mississippi | Arkansas | 5093 | 4 | 0 |
35727 | 35727 | 2020-04-06 | Mississippi | Arkansas | 5093 | 4 | 0 |
38216 | 38216 | 2020-04-07 | Mississippi | Arkansas | 5093 | 4 | 0 |
40760 | 40760 | 2020-04-08 | Mississippi | Arkansas | 5093 | 4 | 0 |
43332 | 43332 | 2020-04-09 | Mississippi | Arkansas | 5093 | 6 | 0 |
45932 | 45932 | 2020-04-10 | Mississippi | Arkansas | 5093 | 7 | 0 |
48562 | 48562 | 2020-04-11 | Mississippi | Arkansas | 5093 | 7 | 0 |
51224 | 51224 | 2020-04-12 | Mississippi | Arkansas | 5093 | 7 | 0 |
53903 | 53903 | 2020-04-13 | Mississippi | Arkansas | 5093 | 7 | 0 |
56595 | 56595 | 2020-04-14 | Mississippi | Arkansas | 5093 | 7 | 0 |
59303 | 59303 | 2020-04-15 | Mississippi | Arkansas | 5093 | 7 | 0 |
62022 | 62022 | 2020-04-16 | Mississippi | Arkansas | 5093 | 8 | 0 |
64755 | 64755 | 2020-04-17 | Mississippi | Arkansas | 5093 | 8 | 0 |
67503 | 67503 | 2020-04-18 | Mississippi | Arkansas | 5093 | 8 | 0 |
70265 | 70265 | 2020-04-19 | Mississippi | Arkansas | 5093 | 8 | 0 |
73034 | 73034 | 2020-04-20 | Mississippi | Arkansas | 5093 | 9 | 0 |
75810 | 75810 | 2020-04-21 | Mississippi | Arkansas | 5093 | 9 | 0 |
78594 | 78594 | 2020-04-22 | Mississippi | Arkansas | 5093 | 9 | 0 |
79882 | 79882 | 2020-04-22 | Mississippi | Missouri | 29133 | 1 | 0 |
81388 | 81388 | 2020-04-23 | Mississippi | Arkansas | 5093 | 10 | 0 |
82678 | 82678 | 2020-04-23 | Mississippi | Missouri | 29133 | 3 | 0 |
84188 | 84188 | 2020-04-24 | Mississippi | Arkansas | 5093 | 10 | 0 |
85482 | 85482 | 2020-04-24 | Mississippi | Missouri | 29133 | 3 | 0 |
86996 | 86996 | 2020-04-25 | Mississippi | Arkansas | 5093 | 11 | 0 |
88292 | 88292 | 2020-04-25 | Mississippi | Missouri | 29133 | 23 | 0 |
89813 | 89813 | 2020-04-26 | Mississippi | Arkansas | 5093 | 11 | 0 |
91108 | 91108 | 2020-04-26 | Mississippi | Missouri | 29133 | 23 | 0 |
92631 | 92631 | 2020-04-27 | Mississippi | Arkansas | 5093 | 13 | 0 |
93929 | 93929 | 2020-04-27 | Mississippi | Missouri | 29133 | 23 | 0 |
95461 | 95461 | 2020-04-28 | Mississippi | Arkansas | 5093 | 14 | 0 |
96765 | 96765 | 2020-04-28 | Mississippi | Missouri | 29133 | 23 | 0 |
98306 | 98306 | 2020-04-29 | Mississippi | Arkansas | 5093 | 15 | 0 |
99611 | 99611 | 2020-04-29 | Mississippi | Missouri | 29133 | 23 | 0 |
101156 | 101156 | 2020-04-30 | Mississippi | Arkansas | 5093 | 19 | 0 |
102463 | 102463 | 2020-04-30 | Mississippi | Missouri | 29133 | 29 | 0 |
104011 | 104011 | 2020-05-01 | Mississippi | Arkansas | 5093 | 20 | 0 |
105324 | 105324 | 2020-05-01 | Mississippi | Missouri | 29133 | 29 | 0 |
106876 | 106876 | 2020-05-02 | Mississippi | Arkansas | 5093 | 20 | 0 |
108189 | 108189 | 2020-05-02 | Mississippi | Missouri | 29133 | 29 | 0 |
109745 | 109745 | 2020-05-03 | Mississippi | Arkansas | 5093 | 20 | 0 |
111061 | 111061 | 2020-05-03 | Mississippi | Missouri | 29133 | 29 | 0 |
112620 | 112620 | 2020-05-04 | Mississippi | Arkansas | 5093 | 23 | 0 |
113940 | 113940 | 2020-05-04 | Mississippi | Missouri | 29133 | 29 | 0 |
115503 | 115503 | 2020-05-05 | Mississippi | Arkansas | 5093 | 41 | 0 |
116822 | 116822 | 2020-05-05 | Mississippi | Missouri | 29133 | 29 | 0 |
118462 | 118462 | 2020-05-06 | Mississippi | Arkansas | 5093 | 42 | 0 |
119782 | 119782 | 2020-05-06 | Mississippi | Missouri | 29133 | 32 | 0 |
121429 | 121429 | 2020-05-07 | Mississippi | Arkansas | 5093 | 42 | 0 |
122756 | 122756 | 2020-05-07 | Mississippi | Missouri | 29133 | 33 | 0 |
124409 | 124409 | 2020-05-08 | Mississippi | Arkansas | 5093 | 47 | 0 |
125738 | 125738 | 2020-05-08 | Mississippi | Missouri | 29133 | 49 | 0 |
127394 | 127394 | 2020-05-09 | Mississippi | Arkansas | 5093 | 47 | 0 |
128726 | 128726 | 2020-05-09 | Mississippi | Missouri | 29133 | 47 | 0 |
130384 | 130384 | 2020-05-10 | Mississippi | Arkansas | 5093 | 52 | 0 |
131716 | 131716 | 2020-05-10 | Mississippi | Missouri | 29133 | 47 | 0 |
133374 | 133374 | 2020-05-11 | Mississippi | Arkansas | 5093 | 52 | 0 |
134707 | 134707 | 2020-05-11 | Mississippi | Missouri | 29133 | 47 | 0 |
136364 | 136364 | 2020-05-12 | Mississippi | Arkansas | 5093 | 53 | 0 |
137697 | 137697 | 2020-05-12 | Mississippi | Missouri | 29133 | 47 | 0 |
139355 | 139355 | 2020-05-13 | Mississippi | Arkansas | 5093 | 54 | 0 |
140691 | 140691 | 2020-05-13 | Mississippi | Missouri | 29133 | 47 | 0 |
142351 | 142351 | 2020-05-14 | Mississippi | Arkansas | 5093 | 55 | 0 |
143686 | 143686 | 2020-05-14 | Mississippi | Missouri | 29133 | 47 | 0 |
145350 | 145350 | 2020-05-15 | Mississippi | Arkansas | 5093 | 58 | 0 |
146687 | 146687 | 2020-05-15 | Mississippi | Missouri | 29133 | 47 | 0 |
148354 | 148354 | 2020-05-16 | Mississippi | Arkansas | 5093 | 61 | 0 |
149692 | 149692 | 2020-05-16 | Mississippi | Missouri | 29133 | 47 | 0 |
151363 | 151363 | 2020-05-17 | Mississippi | Arkansas | 5093 | 61 | 0 |
152703 | 152703 | 2020-05-17 | Mississippi | Missouri | 29133 | 47 | 0 |
154375 | 154375 | 2020-05-18 | Mississippi | Arkansas | 5093 | 62 | 0 |
155717 | 155717 | 2020-05-18 | Mississippi | Missouri | 29133 | 48 | 0 |
157391 | 157391 | 2020-05-19 | Mississippi | Arkansas | 5093 | 65 | 1 |
158735 | 158735 | 2020-05-19 | Mississippi | Missouri | 29133 | 49 | 0 |
160417 | 160417 | 2020-05-20 | Mississippi | Arkansas | 5093 | 66 | 1 |
161761 | 161761 | 2020-05-20 | Mississippi | Missouri | 29133 | 49 | 0 |
163445 | 163445 | 2020-05-21 | Mississippi | Arkansas | 5093 | 69 | 1 |
164790 | 164790 | 2020-05-21 | Mississippi | Missouri | 29133 | 50 | 0 |
166477 | 166477 | 2020-05-22 | Mississippi | Arkansas | 5093 | 70 | 1 |
167826 | 167826 | 2020-05-22 | Mississippi | Missouri | 29133 | 53 | 0 |
169513 | 169513 | 2020-05-23 | Mississippi | Arkansas | 5093 | 70 | 1 |
170865 | 170865 | 2020-05-23 | Mississippi | Missouri | 29133 | 54 | 0 |
172554 | 172554 | 2020-05-24 | Mississippi | Arkansas | 5093 | 70 | 1 |
173907 | 173907 | 2020-05-24 | Mississippi | Missouri | 29133 | 53 | 0 |
175598 | 175598 | 2020-05-25 | Mississippi | Arkansas | 5093 | 70 | 2 |
176950 | 176950 | 2020-05-25 | Mississippi | Missouri | 29133 | 53 | 0 |
178642 | 178642 | 2020-05-26 | Mississippi | Arkansas | 5093 | 72 | 2 |
179994 | 179994 | 2020-05-26 | Mississippi | Missouri | 29133 | 53 | 0 |
181686 | 181686 | 2020-05-27 | Mississippi | Arkansas | 5093 | 72 | 2 |
183040 | 183040 | 2020-05-27 | Mississippi | Missouri | 29133 | 54 | 0 |
184740 | 184740 | 2020-05-28 | Mississippi | Arkansas | 5093 | 73 | 2 |
186096 | 186096 | 2020-05-28 | Mississippi | Missouri | 29133 | 55 | 0 |
187796 | 187796 | 2020-05-29 | Mississippi | Arkansas | 5093 | 73 | 2 |
189154 | 189154 | 2020-05-29 | Mississippi | Missouri | 29133 | 56 | 0 |
190861 | 190861 | 2020-05-30 | Mississippi | Arkansas | 5093 | 75 | 2 |
192218 | 192218 | 2020-05-30 | Mississippi | Missouri | 29133 | 55 | 0 |
193928 | 193928 | 2020-05-31 | Mississippi | Arkansas | 5093 | 75 | 2 |
195288 | 195288 | 2020-05-31 | Mississippi | Missouri | 29133 | 58 | 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);