ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 28045 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 |
---|---|---|---|---|---|---|---|
2981 | 2981 | 2020-03-16 | Hancock | Mississippi | 28045 | 1 | 0 |
3486 | 3486 | 2020-03-17 | Hancock | Mississippi | 28045 | 1 | 0 |
4073 | 4073 | 2020-03-18 | Hancock | Mississippi | 28045 | 2 | 0 |
4785 | 4785 | 2020-03-19 | Hancock | Mississippi | 28045 | 2 | 1 |
5609 | 5609 | 2020-03-20 | Hancock | Mississippi | 28045 | 3 | 1 |
6587 | 6587 | 2020-03-21 | Hancock | Mississippi | 28045 | 4 | 1 |
7670 | 7670 | 2020-03-22 | Hancock | Mississippi | 28045 | 4 | 1 |
8850 | 8850 | 2020-03-23 | Hancock | Mississippi | 28045 | 4 | 1 |
10146 | 10146 | 2020-03-24 | Hancock | Mississippi | 28045 | 5 | 1 |
11566 | 11566 | 2020-03-25 | Hancock | Mississippi | 28045 | 5 | 1 |
13158 | 13158 | 2020-03-26 | Hancock | Mississippi | 28045 | 6 | 1 |
14874 | 14874 | 2020-03-27 | Hancock | Mississippi | 28045 | 9 | 1 |
16698 | 16698 | 2020-03-28 | Hancock | Mississippi | 28045 | 9 | 1 |
18620 | 18620 | 2020-03-29 | Hancock | Mississippi | 28045 | 15 | 1 |
20644 | 20644 | 2020-03-30 | Hancock | Mississippi | 28045 | 15 | 1 |
22761 | 22761 | 2020-03-31 | Hancock | Mississippi | 28045 | 16 | 1 |
24944 | 24944 | 2020-04-01 | Hancock | Mississippi | 28045 | 20 | 1 |
27198 | 27198 | 2020-04-02 | Hancock | Mississippi | 28045 | 22 | 1 |
29517 | 29517 | 2020-04-03 | Hancock | Mississippi | 28045 | 28 | 1 |
31897 | 31897 | 2020-04-04 | Hancock | Mississippi | 28045 | 30 | 1 |
34324 | 34324 | 2020-04-05 | Hancock | Mississippi | 28045 | 31 | 1 |
36787 | 36787 | 2020-04-06 | Hancock | Mississippi | 28045 | 30 | 1 |
39298 | 39298 | 2020-04-07 | Hancock | Mississippi | 28045 | 31 | 2 |
41852 | 41852 | 2020-04-08 | Hancock | Mississippi | 28045 | 32 | 2 |
44428 | 44428 | 2020-04-09 | Hancock | Mississippi | 28045 | 37 | 3 |
47037 | 47037 | 2020-04-10 | Hancock | Mississippi | 28045 | 37 | 5 |
49683 | 49683 | 2020-04-11 | Hancock | Mississippi | 28045 | 38 | 5 |
52356 | 52356 | 2020-04-12 | Hancock | Mississippi | 28045 | 40 | 5 |
55038 | 55038 | 2020-04-13 | Hancock | Mississippi | 28045 | 40 | 5 |
57736 | 57736 | 2020-04-14 | Hancock | Mississippi | 28045 | 46 | 5 |
60447 | 60447 | 2020-04-15 | Hancock | Mississippi | 28045 | 49 | 5 |
63169 | 63169 | 2020-04-16 | Hancock | Mississippi | 28045 | 50 | 5 |
65909 | 65909 | 2020-04-17 | Hancock | Mississippi | 28045 | 50 | 5 |
68661 | 68661 | 2020-04-18 | Hancock | Mississippi | 28045 | 50 | 5 |
71427 | 71427 | 2020-04-19 | Hancock | Mississippi | 28045 | 52 | 5 |
74200 | 74200 | 2020-04-20 | Hancock | Mississippi | 28045 | 53 | 5 |
76981 | 76981 | 2020-04-21 | Hancock | Mississippi | 28045 | 53 | 5 |
79766 | 79766 | 2020-04-22 | Hancock | Mississippi | 28045 | 54 | 5 |
82562 | 82562 | 2020-04-23 | Hancock | Mississippi | 28045 | 55 | 5 |
85366 | 85366 | 2020-04-24 | Hancock | Mississippi | 28045 | 56 | 5 |
88176 | 88176 | 2020-04-25 | Hancock | Mississippi | 28045 | 59 | 5 |
90992 | 90992 | 2020-04-26 | Hancock | Mississippi | 28045 | 60 | 5 |
93813 | 93813 | 2020-04-27 | Hancock | Mississippi | 28045 | 60 | 5 |
96649 | 96649 | 2020-04-28 | Hancock | Mississippi | 28045 | 61 | 5 |
99495 | 99495 | 2020-04-29 | Hancock | Mississippi | 28045 | 61 | 5 |
102347 | 102347 | 2020-04-30 | Hancock | Mississippi | 28045 | 62 | 5 |
105208 | 105208 | 2020-05-01 | Hancock | Mississippi | 28045 | 62 | 5 |
108073 | 108073 | 2020-05-02 | Hancock | Mississippi | 28045 | 67 | 5 |
110944 | 110944 | 2020-05-03 | Hancock | Mississippi | 28045 | 68 | 5 |
113823 | 113823 | 2020-05-04 | Hancock | Mississippi | 28045 | 68 | 5 |
116705 | 116705 | 2020-05-05 | Hancock | Mississippi | 28045 | 68 | 5 |
119665 | 119665 | 2020-05-06 | Hancock | Mississippi | 28045 | 68 | 5 |
122639 | 122639 | 2020-05-07 | Hancock | Mississippi | 28045 | 72 | 9 |
125621 | 125621 | 2020-05-08 | Hancock | Mississippi | 28045 | 72 | 9 |
128608 | 128608 | 2020-05-09 | Hancock | Mississippi | 28045 | 73 | 10 |
131598 | 131598 | 2020-05-10 | Hancock | Mississippi | 28045 | 74 | 10 |
134589 | 134589 | 2020-05-11 | Hancock | Mississippi | 28045 | 74 | 10 |
137579 | 137579 | 2020-05-12 | Hancock | Mississippi | 28045 | 74 | 10 |
140573 | 140573 | 2020-05-13 | Hancock | Mississippi | 28045 | 75 | 10 |
143568 | 143568 | 2020-05-14 | Hancock | Mississippi | 28045 | 79 | 10 |
146568 | 146568 | 2020-05-15 | Hancock | Mississippi | 28045 | 78 | 10 |
149573 | 149573 | 2020-05-16 | Hancock | Mississippi | 28045 | 79 | 10 |
152584 | 152584 | 2020-05-17 | Hancock | Mississippi | 28045 | 80 | 10 |
155598 | 155598 | 2020-05-18 | Hancock | Mississippi | 28045 | 81 | 10 |
158616 | 158616 | 2020-05-19 | Hancock | Mississippi | 28045 | 81 | 10 |
161642 | 161642 | 2020-05-20 | Hancock | Mississippi | 28045 | 81 | 10 |
164671 | 164671 | 2020-05-21 | Hancock | Mississippi | 28045 | 81 | 10 |
167707 | 167707 | 2020-05-22 | Hancock | Mississippi | 28045 | 86 | 10 |
170745 | 170745 | 2020-05-23 | Hancock | Mississippi | 28045 | 84 | 11 |
173787 | 173787 | 2020-05-24 | Hancock | Mississippi | 28045 | 87 | 11 |
176830 | 176830 | 2020-05-25 | Hancock | Mississippi | 28045 | 88 | 11 |
179874 | 179874 | 2020-05-26 | Hancock | Mississippi | 28045 | 88 | 11 |
182920 | 182920 | 2020-05-27 | Hancock | Mississippi | 28045 | 87 | 11 |
185976 | 185976 | 2020-05-28 | Hancock | Mississippi | 28045 | 87 | 11 |
189034 | 189034 | 2020-05-29 | Hancock | Mississippi | 28045 | 87 | 11 |
192098 | 192098 | 2020-05-30 | Hancock | Mississippi | 28045 | 90 | 11 |
195166 | 195166 | 2020-05-31 | Hancock | Mississippi | 28045 | 91 | 11 |
198237 | 198237 | 2020-06-01 | Hancock | Mississippi | 28045 | 91 | 11 |
201310 | 201310 | 2020-06-02 | Hancock | Mississippi | 28045 | 91 | 12 |
204387 | 204387 | 2020-06-03 | Hancock | Mississippi | 28045 | 90 | 12 |
207468 | 207468 | 2020-06-04 | Hancock | Mississippi | 28045 | 90 | 12 |
210549 | 210549 | 2020-06-05 | Hancock | Mississippi | 28045 | 90 | 12 |
213633 | 213633 | 2020-06-06 | Hancock | Mississippi | 28045 | 92 | 12 |
216721 | 216721 | 2020-06-07 | Hancock | Mississippi | 28045 | 92 | 12 |
219813 | 219813 | 2020-06-08 | Hancock | Mississippi | 28045 | 93 | 12 |
222908 | 222908 | 2020-06-09 | Hancock | Mississippi | 28045 | 93 | 12 |
226006 | 226006 | 2020-06-10 | Hancock | Mississippi | 28045 | 94 | 12 |
229108 | 229108 | 2020-06-11 | Hancock | Mississippi | 28045 | 94 | 12 |
232212 | 232212 | 2020-06-12 | Hancock | Mississippi | 28045 | 98 | 12 |
235318 | 235318 | 2020-06-13 | Hancock | Mississippi | 28045 | 100 | 12 |
238425 | 238425 | 2020-06-14 | Hancock | Mississippi | 28045 | 100 | 12 |
241534 | 241534 | 2020-06-15 | Hancock | Mississippi | 28045 | 100 | 12 |
244645 | 244645 | 2020-06-16 | Hancock | Mississippi | 28045 | 100 | 12 |
247758 | 247758 | 2020-06-17 | Hancock | Mississippi | 28045 | 100 | 13 |
250870 | 250870 | 2020-06-18 | Hancock | Mississippi | 28045 | 100 | 13 |
253985 | 253985 | 2020-06-19 | Hancock | Mississippi | 28045 | 100 | 13 |
257105 | 257105 | 2020-06-20 | Hancock | Mississippi | 28045 | 100 | 13 |
260231 | 260231 | 2020-06-21 | Hancock | Mississippi | 28045 | 100 | 13 |
263360 | 263360 | 2020-06-22 | Hancock | Mississippi | 28045 | 103 | 13 |
266486 | 266486 | 2020-06-23 | Hancock | Mississippi | 28045 | 103 | 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);