ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Jefferson" and fips = 28063 sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- 2020-04-14 1
- 2020-04-15 1
- 2020-04-16 1
- 2020-04-17 1
- 2020-04-18 1
- 2020-04-19 1
- 2020-04-20 1
- 2020-04-21 1
- 2020-04-22 1
- 2020-04-23 1
- 2020-04-24 1
- 2020-04-25 1
- …
state 1
- Mississippi 778
fips 1
- 28063 · 778 ✖
county 1
- Jefferson · 778 ✖
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
14881 | 14881 | 2020-03-27 | Jefferson | Mississippi | 28063 | 1 | 0 |
16705 | 16705 | 2020-03-28 | Jefferson | Mississippi | 28063 | 1 | 0 |
18627 | 18627 | 2020-03-29 | Jefferson | Mississippi | 28063 | 1 | 0 |
20651 | 20651 | 2020-03-30 | Jefferson | Mississippi | 28063 | 1 | 0 |
22768 | 22768 | 2020-03-31 | Jefferson | Mississippi | 28063 | 1 | 0 |
24952 | 24952 | 2020-04-01 | Jefferson | Mississippi | 28063 | 1 | 0 |
27206 | 27206 | 2020-04-02 | Jefferson | Mississippi | 28063 | 1 | 0 |
29525 | 29525 | 2020-04-03 | Jefferson | Mississippi | 28063 | 1 | 0 |
31905 | 31905 | 2020-04-04 | Jefferson | Mississippi | 28063 | 2 | 0 |
34332 | 34332 | 2020-04-05 | Jefferson | Mississippi | 28063 | 3 | 0 |
36795 | 36795 | 2020-04-06 | Jefferson | Mississippi | 28063 | 3 | 0 |
39306 | 39306 | 2020-04-07 | Jefferson | Mississippi | 28063 | 3 | 0 |
41860 | 41860 | 2020-04-08 | Jefferson | Mississippi | 28063 | 4 | 0 |
44436 | 44436 | 2020-04-09 | Jefferson | Mississippi | 28063 | 4 | 0 |
47045 | 47045 | 2020-04-10 | Jefferson | Mississippi | 28063 | 4 | 0 |
49691 | 49691 | 2020-04-11 | Jefferson | Mississippi | 28063 | 4 | 0 |
52364 | 52364 | 2020-04-12 | Jefferson | Mississippi | 28063 | 4 | 0 |
55046 | 55046 | 2020-04-13 | Jefferson | Mississippi | 28063 | 4 | 0 |
57744 | 57744 | 2020-04-14 | Jefferson | Mississippi | 28063 | 4 | 0 |
60455 | 60455 | 2020-04-15 | Jefferson | Mississippi | 28063 | 4 | 0 |
63177 | 63177 | 2020-04-16 | Jefferson | Mississippi | 28063 | 4 | 0 |
65917 | 65917 | 2020-04-17 | Jefferson | Mississippi | 28063 | 4 | 0 |
68669 | 68669 | 2020-04-18 | Jefferson | Mississippi | 28063 | 4 | 0 |
71435 | 71435 | 2020-04-19 | Jefferson | Mississippi | 28063 | 4 | 0 |
74208 | 74208 | 2020-04-20 | Jefferson | Mississippi | 28063 | 6 | 0 |
76989 | 76989 | 2020-04-21 | Jefferson | Mississippi | 28063 | 5 | 0 |
79774 | 79774 | 2020-04-22 | Jefferson | Mississippi | 28063 | 5 | 0 |
82570 | 82570 | 2020-04-23 | Jefferson | Mississippi | 28063 | 5 | 0 |
85374 | 85374 | 2020-04-24 | Jefferson | Mississippi | 28063 | 5 | 0 |
88184 | 88184 | 2020-04-25 | Jefferson | Mississippi | 28063 | 8 | 0 |
91000 | 91000 | 2020-04-26 | Jefferson | Mississippi | 28063 | 9 | 0 |
93821 | 93821 | 2020-04-27 | Jefferson | Mississippi | 28063 | 12 | 0 |
96657 | 96657 | 2020-04-28 | Jefferson | Mississippi | 28063 | 16 | 0 |
99503 | 99503 | 2020-04-29 | Jefferson | Mississippi | 28063 | 23 | 0 |
102355 | 102355 | 2020-04-30 | Jefferson | Mississippi | 28063 | 18 | 0 |
105216 | 105216 | 2020-05-01 | Jefferson | Mississippi | 28063 | 20 | 0 |
108081 | 108081 | 2020-05-02 | Jefferson | Mississippi | 28063 | 21 | 0 |
110952 | 110952 | 2020-05-03 | Jefferson | Mississippi | 28063 | 22 | 0 |
113831 | 113831 | 2020-05-04 | Jefferson | Mississippi | 28063 | 23 | 0 |
116713 | 116713 | 2020-05-05 | Jefferson | Mississippi | 28063 | 24 | 0 |
119673 | 119673 | 2020-05-06 | Jefferson | Mississippi | 28063 | 26 | 0 |
122647 | 122647 | 2020-05-07 | Jefferson | Mississippi | 28063 | 30 | 0 |
125629 | 125629 | 2020-05-08 | Jefferson | Mississippi | 28063 | 30 | 0 |
128616 | 128616 | 2020-05-09 | Jefferson | Mississippi | 28063 | 30 | 0 |
131606 | 131606 | 2020-05-10 | Jefferson | Mississippi | 28063 | 30 | 0 |
134597 | 134597 | 2020-05-11 | Jefferson | Mississippi | 28063 | 31 | 0 |
137587 | 137587 | 2020-05-12 | Jefferson | Mississippi | 28063 | 32 | 0 |
140581 | 140581 | 2020-05-13 | Jefferson | Mississippi | 28063 | 32 | 0 |
143576 | 143576 | 2020-05-14 | Jefferson | Mississippi | 28063 | 33 | 0 |
146576 | 146576 | 2020-05-15 | Jefferson | Mississippi | 28063 | 34 | 0 |
149581 | 149581 | 2020-05-16 | Jefferson | Mississippi | 28063 | 35 | 0 |
152592 | 152592 | 2020-05-17 | Jefferson | Mississippi | 28063 | 37 | 0 |
155606 | 155606 | 2020-05-18 | Jefferson | Mississippi | 28063 | 37 | 0 |
158624 | 158624 | 2020-05-19 | Jefferson | Mississippi | 28063 | 38 | 0 |
161650 | 161650 | 2020-05-20 | Jefferson | Mississippi | 28063 | 38 | 0 |
164679 | 164679 | 2020-05-21 | Jefferson | Mississippi | 28063 | 40 | 0 |
167715 | 167715 | 2020-05-22 | Jefferson | Mississippi | 28063 | 40 | 0 |
170753 | 170753 | 2020-05-23 | Jefferson | Mississippi | 28063 | 40 | 0 |
173795 | 173795 | 2020-05-24 | Jefferson | Mississippi | 28063 | 40 | 0 |
176838 | 176838 | 2020-05-25 | Jefferson | Mississippi | 28063 | 40 | 0 |
179882 | 179882 | 2020-05-26 | Jefferson | Mississippi | 28063 | 41 | 0 |
182928 | 182928 | 2020-05-27 | Jefferson | Mississippi | 28063 | 40 | 0 |
185984 | 185984 | 2020-05-28 | Jefferson | Mississippi | 28063 | 40 | 0 |
189042 | 189042 | 2020-05-29 | Jefferson | Mississippi | 28063 | 41 | 1 |
192106 | 192106 | 2020-05-30 | Jefferson | Mississippi | 28063 | 42 | 1 |
195174 | 195174 | 2020-05-31 | Jefferson | Mississippi | 28063 | 42 | 1 |
198245 | 198245 | 2020-06-01 | Jefferson | Mississippi | 28063 | 42 | 1 |
201318 | 201318 | 2020-06-02 | Jefferson | Mississippi | 28063 | 43 | 1 |
204395 | 204395 | 2020-06-03 | Jefferson | Mississippi | 28063 | 42 | 1 |
207476 | 207476 | 2020-06-04 | Jefferson | Mississippi | 28063 | 42 | 1 |
210557 | 210557 | 2020-06-05 | Jefferson | Mississippi | 28063 | 42 | 1 |
213641 | 213641 | 2020-06-06 | Jefferson | Mississippi | 28063 | 46 | 1 |
216729 | 216729 | 2020-06-07 | Jefferson | Mississippi | 28063 | 46 | 1 |
219821 | 219821 | 2020-06-08 | Jefferson | Mississippi | 28063 | 50 | 1 |
222916 | 222916 | 2020-06-09 | Jefferson | Mississippi | 28063 | 49 | 1 |
226014 | 226014 | 2020-06-10 | Jefferson | Mississippi | 28063 | 50 | 2 |
229116 | 229116 | 2020-06-11 | Jefferson | Mississippi | 28063 | 50 | 2 |
232220 | 232220 | 2020-06-12 | Jefferson | Mississippi | 28063 | 52 | 2 |
235326 | 235326 | 2020-06-13 | Jefferson | Mississippi | 28063 | 53 | 2 |
238433 | 238433 | 2020-06-14 | Jefferson | Mississippi | 28063 | 54 | 2 |
241542 | 241542 | 2020-06-15 | Jefferson | Mississippi | 28063 | 55 | 2 |
244653 | 244653 | 2020-06-16 | Jefferson | Mississippi | 28063 | 54 | 2 |
247766 | 247766 | 2020-06-17 | Jefferson | Mississippi | 28063 | 57 | 2 |
250878 | 250878 | 2020-06-18 | Jefferson | Mississippi | 28063 | 57 | 2 |
253993 | 253993 | 2020-06-19 | Jefferson | Mississippi | 28063 | 57 | 2 |
257113 | 257113 | 2020-06-20 | Jefferson | Mississippi | 28063 | 57 | 2 |
260239 | 260239 | 2020-06-21 | Jefferson | Mississippi | 28063 | 57 | 2 |
263368 | 263368 | 2020-06-22 | Jefferson | Mississippi | 28063 | 63 | 2 |
266494 | 266494 | 2020-06-23 | Jefferson | Mississippi | 28063 | 64 | 2 |
269627 | 269627 | 2020-06-24 | Jefferson | Mississippi | 28063 | 65 | 3 |
272765 | 272765 | 2020-06-25 | Jefferson | Mississippi | 28063 | 69 | 3 |
275908 | 275908 | 2020-06-26 | Jefferson | Mississippi | 28063 | 76 | 3 |
279056 | 279056 | 2020-06-27 | Jefferson | Mississippi | 28063 | 78 | 3 |
282204 | 282204 | 2020-06-28 | Jefferson | Mississippi | 28063 | 80 | 3 |
285349 | 285349 | 2020-06-29 | Jefferson | Mississippi | 28063 | 83 | 3 |
288499 | 288499 | 2020-06-30 | Jefferson | Mississippi | 28063 | 84 | 3 |
291650 | 291650 | 2020-07-01 | Jefferson | Mississippi | 28063 | 92 | 3 |
294804 | 294804 | 2020-07-02 | Jefferson | Mississippi | 28063 | 96 | 3 |
297962 | 297962 | 2020-07-03 | Jefferson | Mississippi | 28063 | 99 | 3 |
301125 | 301125 | 2020-07-04 | Jefferson | Mississippi | 28063 | 107 | 3 |
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);