ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 28011 and state = "Mississippi" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4068 | 4068 | 2020-03-18 | Bolivar | Mississippi | 28011 | 2 | 0 |
4780 | 4780 | 2020-03-19 | Bolivar | Mississippi | 28011 | 2 | 0 |
5603 | 5603 | 2020-03-20 | Bolivar | Mississippi | 28011 | 2 | 0 |
6578 | 6578 | 2020-03-21 | Bolivar | Mississippi | 28011 | 2 | 0 |
7660 | 7660 | 2020-03-22 | Bolivar | Mississippi | 28011 | 3 | 0 |
8840 | 8840 | 2020-03-23 | Bolivar | Mississippi | 28011 | 4 | 0 |
10135 | 10135 | 2020-03-24 | Bolivar | Mississippi | 28011 | 4 | 0 |
11554 | 11554 | 2020-03-25 | Bolivar | Mississippi | 28011 | 4 | 0 |
13146 | 13146 | 2020-03-26 | Bolivar | Mississippi | 28011 | 6 | 0 |
14862 | 14862 | 2020-03-27 | Bolivar | Mississippi | 28011 | 9 | 0 |
16684 | 16684 | 2020-03-28 | Bolivar | Mississippi | 28011 | 11 | 0 |
18604 | 18604 | 2020-03-29 | Bolivar | Mississippi | 28011 | 11 | 0 |
20628 | 20628 | 2020-03-30 | Bolivar | Mississippi | 28011 | 16 | 0 |
22745 | 22745 | 2020-03-31 | Bolivar | Mississippi | 28011 | 22 | 1 |
24928 | 24928 | 2020-04-01 | Bolivar | Mississippi | 28011 | 25 | 1 |
27182 | 27182 | 2020-04-02 | Bolivar | Mississippi | 28011 | 27 | 1 |
29501 | 29501 | 2020-04-03 | Bolivar | Mississippi | 28011 | 32 | 1 |
31881 | 31881 | 2020-04-04 | Bolivar | Mississippi | 28011 | 34 | 1 |
34308 | 34308 | 2020-04-05 | Bolivar | Mississippi | 28011 | 45 | 2 |
36770 | 36770 | 2020-04-06 | Bolivar | Mississippi | 28011 | 51 | 2 |
39281 | 39281 | 2020-04-07 | Bolivar | Mississippi | 28011 | 54 | 2 |
41835 | 41835 | 2020-04-08 | Bolivar | Mississippi | 28011 | 54 | 2 |
44411 | 44411 | 2020-04-09 | Bolivar | Mississippi | 28011 | 57 | 3 |
47020 | 47020 | 2020-04-10 | Bolivar | Mississippi | 28011 | 61 | 3 |
49666 | 49666 | 2020-04-11 | Bolivar | Mississippi | 28011 | 65 | 3 |
52339 | 52339 | 2020-04-12 | Bolivar | Mississippi | 28011 | 68 | 3 |
55021 | 55021 | 2020-04-13 | Bolivar | Mississippi | 28011 | 68 | 3 |
57719 | 57719 | 2020-04-14 | Bolivar | Mississippi | 28011 | 69 | 4 |
60430 | 60430 | 2020-04-15 | Bolivar | Mississippi | 28011 | 70 | 5 |
63152 | 63152 | 2020-04-16 | Bolivar | Mississippi | 28011 | 74 | 5 |
65892 | 65892 | 2020-04-17 | Bolivar | Mississippi | 28011 | 76 | 5 |
68644 | 68644 | 2020-04-18 | Bolivar | Mississippi | 28011 | 79 | 5 |
71410 | 71410 | 2020-04-19 | Bolivar | Mississippi | 28011 | 82 | 5 |
74183 | 74183 | 2020-04-20 | Bolivar | Mississippi | 28011 | 85 | 6 |
76964 | 76964 | 2020-04-21 | Bolivar | Mississippi | 28011 | 86 | 6 |
79749 | 79749 | 2020-04-22 | Bolivar | Mississippi | 28011 | 87 | 6 |
82545 | 82545 | 2020-04-23 | Bolivar | Mississippi | 28011 | 89 | 7 |
85349 | 85349 | 2020-04-24 | Bolivar | Mississippi | 28011 | 90 | 7 |
88159 | 88159 | 2020-04-25 | Bolivar | Mississippi | 28011 | 94 | 7 |
90975 | 90975 | 2020-04-26 | Bolivar | Mississippi | 28011 | 96 | 7 |
93796 | 93796 | 2020-04-27 | Bolivar | Mississippi | 28011 | 101 | 7 |
96632 | 96632 | 2020-04-28 | Bolivar | Mississippi | 28011 | 101 | 7 |
99478 | 99478 | 2020-04-29 | Bolivar | Mississippi | 28011 | 101 | 7 |
102330 | 102330 | 2020-04-30 | Bolivar | Mississippi | 28011 | 102 | 7 |
105191 | 105191 | 2020-05-01 | Bolivar | Mississippi | 28011 | 102 | 7 |
108056 | 108056 | 2020-05-02 | Bolivar | Mississippi | 28011 | 105 | 7 |
110927 | 110927 | 2020-05-03 | Bolivar | Mississippi | 28011 | 107 | 7 |
113806 | 113806 | 2020-05-04 | Bolivar | Mississippi | 28011 | 110 | 7 |
116688 | 116688 | 2020-05-05 | Bolivar | Mississippi | 28011 | 112 | 8 |
119648 | 119648 | 2020-05-06 | Bolivar | Mississippi | 28011 | 115 | 8 |
122622 | 122622 | 2020-05-07 | Bolivar | Mississippi | 28011 | 115 | 8 |
125604 | 125604 | 2020-05-08 | Bolivar | Mississippi | 28011 | 118 | 8 |
128591 | 128591 | 2020-05-09 | Bolivar | Mississippi | 28011 | 119 | 8 |
131581 | 131581 | 2020-05-10 | Bolivar | Mississippi | 28011 | 118 | 9 |
134572 | 134572 | 2020-05-11 | Bolivar | Mississippi | 28011 | 118 | 9 |
137562 | 137562 | 2020-05-12 | Bolivar | Mississippi | 28011 | 120 | 9 |
140556 | 140556 | 2020-05-13 | Bolivar | Mississippi | 28011 | 120 | 9 |
143551 | 143551 | 2020-05-14 | Bolivar | Mississippi | 28011 | 120 | 10 |
146551 | 146551 | 2020-05-15 | Bolivar | Mississippi | 28011 | 127 | 10 |
149556 | 149556 | 2020-05-16 | Bolivar | Mississippi | 28011 | 130 | 10 |
152567 | 152567 | 2020-05-17 | Bolivar | Mississippi | 28011 | 129 | 10 |
155581 | 155581 | 2020-05-18 | Bolivar | Mississippi | 28011 | 129 | 10 |
158599 | 158599 | 2020-05-19 | Bolivar | Mississippi | 28011 | 129 | 10 |
161625 | 161625 | 2020-05-20 | Bolivar | Mississippi | 28011 | 132 | 10 |
164654 | 164654 | 2020-05-21 | Bolivar | Mississippi | 28011 | 133 | 10 |
167690 | 167690 | 2020-05-22 | Bolivar | Mississippi | 28011 | 134 | 10 |
170728 | 170728 | 2020-05-23 | Bolivar | Mississippi | 28011 | 136 | 10 |
173770 | 173770 | 2020-05-24 | Bolivar | Mississippi | 28011 | 140 | 10 |
176813 | 176813 | 2020-05-25 | Bolivar | Mississippi | 28011 | 141 | 11 |
179857 | 179857 | 2020-05-26 | Bolivar | Mississippi | 28011 | 142 | 11 |
182903 | 182903 | 2020-05-27 | Bolivar | Mississippi | 28011 | 149 | 11 |
185959 | 185959 | 2020-05-28 | Bolivar | Mississippi | 28011 | 154 | 11 |
189017 | 189017 | 2020-05-29 | Bolivar | Mississippi | 28011 | 156 | 11 |
192081 | 192081 | 2020-05-30 | Bolivar | Mississippi | 28011 | 160 | 11 |
195149 | 195149 | 2020-05-31 | Bolivar | Mississippi | 28011 | 162 | 11 |
198220 | 198220 | 2020-06-01 | Bolivar | Mississippi | 28011 | 165 | 11 |
201293 | 201293 | 2020-06-02 | Bolivar | Mississippi | 28011 | 165 | 11 |
204370 | 204370 | 2020-06-03 | Bolivar | Mississippi | 28011 | 166 | 11 |
207451 | 207451 | 2020-06-04 | Bolivar | Mississippi | 28011 | 169 | 11 |
210532 | 210532 | 2020-06-05 | Bolivar | Mississippi | 28011 | 169 | 11 |
213616 | 213616 | 2020-06-06 | Bolivar | Mississippi | 28011 | 170 | 11 |
216704 | 216704 | 2020-06-07 | Bolivar | Mississippi | 28011 | 174 | 11 |
219796 | 219796 | 2020-06-08 | Bolivar | Mississippi | 28011 | 176 | 11 |
222891 | 222891 | 2020-06-09 | Bolivar | Mississippi | 28011 | 179 | 11 |
225989 | 225989 | 2020-06-10 | Bolivar | Mississippi | 28011 | 180 | 11 |
229091 | 229091 | 2020-06-11 | Bolivar | Mississippi | 28011 | 180 | 11 |
232195 | 232195 | 2020-06-12 | Bolivar | Mississippi | 28011 | 185 | 11 |
235301 | 235301 | 2020-06-13 | Bolivar | Mississippi | 28011 | 185 | 12 |
238408 | 238408 | 2020-06-14 | Bolivar | Mississippi | 28011 | 190 | 12 |
241517 | 241517 | 2020-06-15 | Bolivar | Mississippi | 28011 | 194 | 12 |
244628 | 244628 | 2020-06-16 | Bolivar | Mississippi | 28011 | 194 | 13 |
247741 | 247741 | 2020-06-17 | Bolivar | Mississippi | 28011 | 197 | 13 |
250853 | 250853 | 2020-06-18 | Bolivar | Mississippi | 28011 | 197 | 13 |
253968 | 253968 | 2020-06-19 | Bolivar | Mississippi | 28011 | 197 | 13 |
257088 | 257088 | 2020-06-20 | Bolivar | Mississippi | 28011 | 197 | 13 |
260214 | 260214 | 2020-06-21 | Bolivar | Mississippi | 28011 | 197 | 13 |
263343 | 263343 | 2020-06-22 | Bolivar | Mississippi | 28011 | 208 | 13 |
266469 | 266469 | 2020-06-23 | Bolivar | Mississippi | 28011 | 223 | 13 |
269602 | 269602 | 2020-06-24 | Bolivar | Mississippi | 28011 | 230 | 13 |
272739 | 272739 | 2020-06-25 | Bolivar | Mississippi | 28011 | 233 | 13 |
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);