ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Clay" and fips = 28025 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 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
- …
state 1
- Mississippi 784
fips 1
- 28025 · 784 ✖
county 1
- Clay · 784 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
6579 | 6579 | 2020-03-21 | Clay | Mississippi | 28025 | 1 | 0 |
7662 | 7662 | 2020-03-22 | Clay | Mississippi | 28025 | 1 | 0 |
8842 | 8842 | 2020-03-23 | Clay | Mississippi | 28025 | 1 | 0 |
10138 | 10138 | 2020-03-24 | Clay | Mississippi | 28025 | 1 | 0 |
11558 | 11558 | 2020-03-25 | Clay | Mississippi | 28025 | 1 | 0 |
13150 | 13150 | 2020-03-26 | Clay | Mississippi | 28025 | 1 | 0 |
14866 | 14866 | 2020-03-27 | Clay | Mississippi | 28025 | 2 | 0 |
16689 | 16689 | 2020-03-28 | Clay | Mississippi | 28025 | 2 | 0 |
18611 | 18611 | 2020-03-29 | Clay | Mississippi | 28025 | 2 | 0 |
20635 | 20635 | 2020-03-30 | Clay | Mississippi | 28025 | 4 | 0 |
22752 | 22752 | 2020-03-31 | Clay | Mississippi | 28025 | 4 | 0 |
24935 | 24935 | 2020-04-01 | Clay | Mississippi | 28025 | 5 | 0 |
27189 | 27189 | 2020-04-02 | Clay | Mississippi | 28025 | 7 | 0 |
29508 | 29508 | 2020-04-03 | Clay | Mississippi | 28025 | 7 | 0 |
31888 | 31888 | 2020-04-04 | Clay | Mississippi | 28025 | 7 | 0 |
34315 | 34315 | 2020-04-05 | Clay | Mississippi | 28025 | 7 | 0 |
36777 | 36777 | 2020-04-06 | Clay | Mississippi | 28025 | 9 | 0 |
39288 | 39288 | 2020-04-07 | Clay | Mississippi | 28025 | 10 | 0 |
41842 | 41842 | 2020-04-08 | Clay | Mississippi | 28025 | 11 | 0 |
44418 | 44418 | 2020-04-09 | Clay | Mississippi | 28025 | 14 | 0 |
47027 | 47027 | 2020-04-10 | Clay | Mississippi | 28025 | 17 | 0 |
49673 | 49673 | 2020-04-11 | Clay | Mississippi | 28025 | 17 | 0 |
52346 | 52346 | 2020-04-12 | Clay | Mississippi | 28025 | 18 | 0 |
55028 | 55028 | 2020-04-13 | Clay | Mississippi | 28025 | 20 | 0 |
57726 | 57726 | 2020-04-14 | Clay | Mississippi | 28025 | 20 | 0 |
60437 | 60437 | 2020-04-15 | Clay | Mississippi | 28025 | 21 | 0 |
63159 | 63159 | 2020-04-16 | Clay | Mississippi | 28025 | 21 | 0 |
65899 | 65899 | 2020-04-17 | Clay | Mississippi | 28025 | 22 | 1 |
68651 | 68651 | 2020-04-18 | Clay | Mississippi | 28025 | 24 | 1 |
71417 | 71417 | 2020-04-19 | Clay | Mississippi | 28025 | 25 | 1 |
74190 | 74190 | 2020-04-20 | Clay | Mississippi | 28025 | 26 | 1 |
76971 | 76971 | 2020-04-21 | Clay | Mississippi | 28025 | 27 | 1 |
79756 | 79756 | 2020-04-22 | Clay | Mississippi | 28025 | 27 | 2 |
82552 | 82552 | 2020-04-23 | Clay | Mississippi | 28025 | 28 | 2 |
85356 | 85356 | 2020-04-24 | Clay | Mississippi | 28025 | 29 | 2 |
88166 | 88166 | 2020-04-25 | Clay | Mississippi | 28025 | 32 | 2 |
90982 | 90982 | 2020-04-26 | Clay | Mississippi | 28025 | 31 | 2 |
93803 | 93803 | 2020-04-27 | Clay | Mississippi | 28025 | 31 | 2 |
96639 | 96639 | 2020-04-28 | Clay | Mississippi | 28025 | 33 | 2 |
99485 | 99485 | 2020-04-29 | Clay | Mississippi | 28025 | 34 | 2 |
102337 | 102337 | 2020-04-30 | Clay | Mississippi | 28025 | 40 | 2 |
105198 | 105198 | 2020-05-01 | Clay | Mississippi | 28025 | 42 | 2 |
108063 | 108063 | 2020-05-02 | Clay | Mississippi | 28025 | 47 | 2 |
110934 | 110934 | 2020-05-03 | Clay | Mississippi | 28025 | 48 | 2 |
113813 | 113813 | 2020-05-04 | Clay | Mississippi | 28025 | 52 | 2 |
116695 | 116695 | 2020-05-05 | Clay | Mississippi | 28025 | 57 | 2 |
119655 | 119655 | 2020-05-06 | Clay | Mississippi | 28025 | 58 | 3 |
122629 | 122629 | 2020-05-07 | Clay | Mississippi | 28025 | 63 | 3 |
125611 | 125611 | 2020-05-08 | Clay | Mississippi | 28025 | 64 | 3 |
128598 | 128598 | 2020-05-09 | Clay | Mississippi | 28025 | 65 | 3 |
131588 | 131588 | 2020-05-10 | Clay | Mississippi | 28025 | 66 | 3 |
134579 | 134579 | 2020-05-11 | Clay | Mississippi | 28025 | 66 | 3 |
137569 | 137569 | 2020-05-12 | Clay | Mississippi | 28025 | 68 | 3 |
140563 | 140563 | 2020-05-13 | Clay | Mississippi | 28025 | 72 | 3 |
143558 | 143558 | 2020-05-14 | Clay | Mississippi | 28025 | 75 | 3 |
146558 | 146558 | 2020-05-15 | Clay | Mississippi | 28025 | 78 | 3 |
149563 | 149563 | 2020-05-16 | Clay | Mississippi | 28025 | 79 | 3 |
152574 | 152574 | 2020-05-17 | Clay | Mississippi | 28025 | 79 | 3 |
155588 | 155588 | 2020-05-18 | Clay | Mississippi | 28025 | 79 | 3 |
158606 | 158606 | 2020-05-19 | Clay | Mississippi | 28025 | 86 | 3 |
161632 | 161632 | 2020-05-20 | Clay | Mississippi | 28025 | 86 | 3 |
164661 | 164661 | 2020-05-21 | Clay | Mississippi | 28025 | 90 | 3 |
167697 | 167697 | 2020-05-22 | Clay | Mississippi | 28025 | 95 | 3 |
170735 | 170735 | 2020-05-23 | Clay | Mississippi | 28025 | 96 | 3 |
173777 | 173777 | 2020-05-24 | Clay | Mississippi | 28025 | 99 | 3 |
176820 | 176820 | 2020-05-25 | Clay | Mississippi | 28025 | 99 | 3 |
179864 | 179864 | 2020-05-26 | Clay | Mississippi | 28025 | 101 | 3 |
182910 | 182910 | 2020-05-27 | Clay | Mississippi | 28025 | 104 | 3 |
185966 | 185966 | 2020-05-28 | Clay | Mississippi | 28025 | 108 | 4 |
189024 | 189024 | 2020-05-29 | Clay | Mississippi | 28025 | 111 | 4 |
192088 | 192088 | 2020-05-30 | Clay | Mississippi | 28025 | 112 | 4 |
195156 | 195156 | 2020-05-31 | Clay | Mississippi | 28025 | 112 | 4 |
198227 | 198227 | 2020-06-01 | Clay | Mississippi | 28025 | 114 | 4 |
201300 | 201300 | 2020-06-02 | Clay | Mississippi | 28025 | 115 | 4 |
204377 | 204377 | 2020-06-03 | Clay | Mississippi | 28025 | 118 | 4 |
207458 | 207458 | 2020-06-04 | Clay | Mississippi | 28025 | 125 | 4 |
210539 | 210539 | 2020-06-05 | Clay | Mississippi | 28025 | 125 | 4 |
213623 | 213623 | 2020-06-06 | Clay | Mississippi | 28025 | 130 | 4 |
216711 | 216711 | 2020-06-07 | Clay | Mississippi | 28025 | 132 | 4 |
219803 | 219803 | 2020-06-08 | Clay | Mississippi | 28025 | 134 | 4 |
222898 | 222898 | 2020-06-09 | Clay | Mississippi | 28025 | 137 | 4 |
225996 | 225996 | 2020-06-10 | Clay | Mississippi | 28025 | 145 | 5 |
229098 | 229098 | 2020-06-11 | Clay | Mississippi | 28025 | 145 | 5 |
232202 | 232202 | 2020-06-12 | Clay | Mississippi | 28025 | 169 | 5 |
235308 | 235308 | 2020-06-13 | Clay | Mississippi | 28025 | 173 | 6 |
238415 | 238415 | 2020-06-14 | Clay | Mississippi | 28025 | 174 | 6 |
241524 | 241524 | 2020-06-15 | Clay | Mississippi | 28025 | 174 | 6 |
244635 | 244635 | 2020-06-16 | Clay | Mississippi | 28025 | 174 | 6 |
247748 | 247748 | 2020-06-17 | Clay | Mississippi | 28025 | 185 | 6 |
250860 | 250860 | 2020-06-18 | Clay | Mississippi | 28025 | 185 | 6 |
253975 | 253975 | 2020-06-19 | Clay | Mississippi | 28025 | 185 | 6 |
257095 | 257095 | 2020-06-20 | Clay | Mississippi | 28025 | 185 | 6 |
260221 | 260221 | 2020-06-21 | Clay | Mississippi | 28025 | 185 | 6 |
263350 | 263350 | 2020-06-22 | Clay | Mississippi | 28025 | 210 | 6 |
266476 | 266476 | 2020-06-23 | Clay | Mississippi | 28025 | 218 | 6 |
269609 | 269609 | 2020-06-24 | Clay | Mississippi | 28025 | 222 | 7 |
272746 | 272746 | 2020-06-25 | Clay | Mississippi | 28025 | 229 | 7 |
275889 | 275889 | 2020-06-26 | Clay | Mississippi | 28025 | 233 | 7 |
279037 | 279037 | 2020-06-27 | Clay | Mississippi | 28025 | 234 | 7 |
282185 | 282185 | 2020-06-28 | Clay | Mississippi | 28025 | 235 | 7 |
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);