ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Rankin" and state = "Mississippi" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5626 | 5626 | 2020-03-20 | Rankin | Mississippi | 28121 | 3 | 0 |
6609 | 6609 | 2020-03-21 | Rankin | Mississippi | 28121 | 7 | 0 |
7695 | 7695 | 2020-03-22 | Rankin | Mississippi | 28121 | 7 | 0 |
8877 | 8877 | 2020-03-23 | Rankin | Mississippi | 28121 | 8 | 0 |
10175 | 10175 | 2020-03-24 | Rankin | Mississippi | 28121 | 13 | 0 |
11596 | 11596 | 2020-03-25 | Rankin | Mississippi | 28121 | 20 | 0 |
13190 | 13190 | 2020-03-26 | Rankin | Mississippi | 28121 | 23 | 1 |
14909 | 14909 | 2020-03-27 | Rankin | Mississippi | 28121 | 29 | 1 |
16733 | 16733 | 2020-03-28 | Rankin | Mississippi | 28121 | 31 | 1 |
18655 | 18655 | 2020-03-29 | Rankin | Mississippi | 28121 | 35 | 1 |
20679 | 20679 | 2020-03-30 | Rankin | Mississippi | 28121 | 37 | 1 |
22796 | 22796 | 2020-03-31 | Rankin | Mississippi | 28121 | 40 | 1 |
24980 | 24980 | 2020-04-01 | Rankin | Mississippi | 28121 | 48 | 1 |
27234 | 27234 | 2020-04-02 | Rankin | Mississippi | 28121 | 50 | 1 |
29553 | 29553 | 2020-04-03 | Rankin | Mississippi | 28121 | 64 | 1 |
31933 | 31933 | 2020-04-04 | Rankin | Mississippi | 28121 | 66 | 1 |
34360 | 34360 | 2020-04-05 | Rankin | Mississippi | 28121 | 72 | 1 |
36823 | 36823 | 2020-04-06 | Rankin | Mississippi | 28121 | 74 | 1 |
39334 | 39334 | 2020-04-07 | Rankin | Mississippi | 28121 | 78 | 1 |
41888 | 41888 | 2020-04-08 | Rankin | Mississippi | 28121 | 79 | 2 |
44465 | 44465 | 2020-04-09 | Rankin | Mississippi | 28121 | 85 | 2 |
47074 | 47074 | 2020-04-10 | Rankin | Mississippi | 28121 | 88 | 2 |
49720 | 49720 | 2020-04-11 | Rankin | Mississippi | 28121 | 94 | 2 |
52393 | 52393 | 2020-04-12 | Rankin | Mississippi | 28121 | 99 | 2 |
55075 | 55075 | 2020-04-13 | Rankin | Mississippi | 28121 | 100 | 2 |
57773 | 57773 | 2020-04-14 | Rankin | Mississippi | 28121 | 105 | 2 |
60484 | 60484 | 2020-04-15 | Rankin | Mississippi | 28121 | 113 | 2 |
63206 | 63206 | 2020-04-16 | Rankin | Mississippi | 28121 | 122 | 2 |
65946 | 65946 | 2020-04-17 | Rankin | Mississippi | 28121 | 128 | 2 |
68698 | 68698 | 2020-04-18 | Rankin | Mississippi | 28121 | 130 | 2 |
71464 | 71464 | 2020-04-19 | Rankin | Mississippi | 28121 | 133 | 2 |
74237 | 74237 | 2020-04-20 | Rankin | Mississippi | 28121 | 141 | 2 |
77018 | 77018 | 2020-04-21 | Rankin | Mississippi | 28121 | 146 | 4 |
79803 | 79803 | 2020-04-22 | Rankin | Mississippi | 28121 | 148 | 4 |
82599 | 82599 | 2020-04-23 | Rankin | Mississippi | 28121 | 153 | 4 |
85403 | 85403 | 2020-04-24 | Rankin | Mississippi | 28121 | 154 | 4 |
88213 | 88213 | 2020-04-25 | Rankin | Mississippi | 28121 | 162 | 5 |
91029 | 91029 | 2020-04-26 | Rankin | Mississippi | 28121 | 167 | 5 |
93850 | 93850 | 2020-04-27 | Rankin | Mississippi | 28121 | 171 | 5 |
96686 | 96686 | 2020-04-28 | Rankin | Mississippi | 28121 | 179 | 5 |
99532 | 99532 | 2020-04-29 | Rankin | Mississippi | 28121 | 182 | 5 |
102384 | 102384 | 2020-04-30 | Rankin | Mississippi | 28121 | 186 | 5 |
105245 | 105245 | 2020-05-01 | Rankin | Mississippi | 28121 | 194 | 5 |
108110 | 108110 | 2020-05-02 | Rankin | Mississippi | 28121 | 197 | 5 |
110981 | 110981 | 2020-05-03 | Rankin | Mississippi | 28121 | 200 | 6 |
113860 | 113860 | 2020-05-04 | Rankin | Mississippi | 28121 | 207 | 6 |
116742 | 116742 | 2020-05-05 | Rankin | Mississippi | 28121 | 221 | 6 |
119702 | 119702 | 2020-05-06 | Rankin | Mississippi | 28121 | 226 | 6 |
122676 | 122676 | 2020-05-07 | Rankin | Mississippi | 28121 | 231 | 6 |
125658 | 125658 | 2020-05-08 | Rankin | Mississippi | 28121 | 238 | 6 |
128645 | 128645 | 2020-05-09 | Rankin | Mississippi | 28121 | 248 | 6 |
131635 | 131635 | 2020-05-10 | Rankin | Mississippi | 28121 | 250 | 6 |
134626 | 134626 | 2020-05-11 | Rankin | Mississippi | 28121 | 251 | 6 |
137616 | 137616 | 2020-05-12 | Rankin | Mississippi | 28121 | 256 | 6 |
140610 | 140610 | 2020-05-13 | Rankin | Mississippi | 28121 | 262 | 6 |
143605 | 143605 | 2020-05-14 | Rankin | Mississippi | 28121 | 271 | 6 |
146605 | 146605 | 2020-05-15 | Rankin | Mississippi | 28121 | 276 | 6 |
149610 | 149610 | 2020-05-16 | Rankin | Mississippi | 28121 | 282 | 6 |
152621 | 152621 | 2020-05-17 | Rankin | Mississippi | 28121 | 285 | 6 |
155635 | 155635 | 2020-05-18 | Rankin | Mississippi | 28121 | 287 | 6 |
158653 | 158653 | 2020-05-19 | Rankin | Mississippi | 28121 | 295 | 6 |
161679 | 161679 | 2020-05-20 | Rankin | Mississippi | 28121 | 310 | 6 |
164708 | 164708 | 2020-05-21 | Rankin | Mississippi | 28121 | 315 | 6 |
167744 | 167744 | 2020-05-22 | Rankin | Mississippi | 28121 | 325 | 6 |
170782 | 170782 | 2020-05-23 | Rankin | Mississippi | 28121 | 336 | 6 |
173824 | 173824 | 2020-05-24 | Rankin | Mississippi | 28121 | 349 | 6 |
176867 | 176867 | 2020-05-25 | Rankin | Mississippi | 28121 | 356 | 6 |
179911 | 179911 | 2020-05-26 | Rankin | Mississippi | 28121 | 358 | 6 |
182957 | 182957 | 2020-05-27 | Rankin | Mississippi | 28121 | 373 | 6 |
186013 | 186013 | 2020-05-28 | Rankin | Mississippi | 28121 | 385 | 6 |
189071 | 189071 | 2020-05-29 | Rankin | Mississippi | 28121 | 399 | 7 |
192135 | 192135 | 2020-05-30 | Rankin | Mississippi | 28121 | 421 | 7 |
195203 | 195203 | 2020-05-31 | Rankin | Mississippi | 28121 | 439 | 8 |
198274 | 198274 | 2020-06-01 | Rankin | Mississippi | 28121 | 446 | 8 |
201347 | 201347 | 2020-06-02 | Rankin | Mississippi | 28121 | 446 | 8 |
204424 | 204424 | 2020-06-03 | Rankin | Mississippi | 28121 | 453 | 8 |
207505 | 207505 | 2020-06-04 | Rankin | Mississippi | 28121 | 456 | 9 |
210586 | 210586 | 2020-06-05 | Rankin | Mississippi | 28121 | 463 | 9 |
213670 | 213670 | 2020-06-06 | Rankin | Mississippi | 28121 | 473 | 9 |
216758 | 216758 | 2020-06-07 | Rankin | Mississippi | 28121 | 480 | 9 |
219850 | 219850 | 2020-06-08 | Rankin | Mississippi | 28121 | 485 | 9 |
222945 | 222945 | 2020-06-09 | Rankin | Mississippi | 28121 | 498 | 10 |
226043 | 226043 | 2020-06-10 | Rankin | Mississippi | 28121 | 505 | 10 |
229145 | 229145 | 2020-06-11 | Rankin | Mississippi | 28121 | 505 | 10 |
232249 | 232249 | 2020-06-12 | Rankin | Mississippi | 28121 | 529 | 10 |
235355 | 235355 | 2020-06-13 | Rankin | Mississippi | 28121 | 536 | 10 |
238462 | 238462 | 2020-06-14 | Rankin | Mississippi | 28121 | 537 | 10 |
241571 | 241571 | 2020-06-15 | Rankin | Mississippi | 28121 | 539 | 10 |
244682 | 244682 | 2020-06-16 | Rankin | Mississippi | 28121 | 550 | 10 |
247795 | 247795 | 2020-06-17 | Rankin | Mississippi | 28121 | 563 | 10 |
250907 | 250907 | 2020-06-18 | Rankin | Mississippi | 28121 | 563 | 10 |
254022 | 254022 | 2020-06-19 | Rankin | Mississippi | 28121 | 563 | 10 |
257142 | 257142 | 2020-06-20 | Rankin | Mississippi | 28121 | 563 | 10 |
260268 | 260268 | 2020-06-21 | Rankin | Mississippi | 28121 | 563 | 10 |
263397 | 263397 | 2020-06-22 | Rankin | Mississippi | 28121 | 611 | 12 |
266523 | 266523 | 2020-06-23 | Rankin | Mississippi | 28121 | 620 | 12 |
269656 | 269656 | 2020-06-24 | Rankin | Mississippi | 28121 | 636 | 12 |
272794 | 272794 | 2020-06-25 | Rankin | Mississippi | 28121 | 682 | 12 |
275937 | 275937 | 2020-06-26 | Rankin | Mississippi | 28121 | 700 | 12 |
279085 | 279085 | 2020-06-27 | Rankin | Mississippi | 28121 | 715 | 12 |
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);