ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Jefferson" and state = "Kansas" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
12891 | 12891 | 2020-03-26 | Jefferson | Kansas | 20087 | 1 | 0 |
14591 | 14591 | 2020-03-27 | Jefferson | Kansas | 20087 | 1 | 0 |
16398 | 16398 | 2020-03-28 | Jefferson | Kansas | 20087 | 1 | 0 |
18304 | 18304 | 2020-03-29 | Jefferson | Kansas | 20087 | 1 | 0 |
20317 | 20317 | 2020-03-30 | Jefferson | Kansas | 20087 | 1 | 0 |
22415 | 22415 | 2020-03-31 | Jefferson | Kansas | 20087 | 1 | 0 |
24590 | 24590 | 2020-04-01 | Jefferson | Kansas | 20087 | 1 | 0 |
26834 | 26834 | 2020-04-02 | Jefferson | Kansas | 20087 | 1 | 0 |
29148 | 29148 | 2020-04-03 | Jefferson | Kansas | 20087 | 2 | 0 |
31521 | 31521 | 2020-04-04 | Jefferson | Kansas | 20087 | 2 | 0 |
33935 | 33935 | 2020-04-05 | Jefferson | Kansas | 20087 | 2 | 0 |
36392 | 36392 | 2020-04-06 | Jefferson | Kansas | 20087 | 3 | 0 |
38894 | 38894 | 2020-04-07 | Jefferson | Kansas | 20087 | 3 | 0 |
41441 | 41441 | 2020-04-08 | Jefferson | Kansas | 20087 | 5 | 0 |
44017 | 44017 | 2020-04-09 | Jefferson | Kansas | 20087 | 5 | 0 |
46624 | 46624 | 2020-04-10 | Jefferson | Kansas | 20087 | 5 | 0 |
49260 | 49260 | 2020-04-11 | Jefferson | Kansas | 20087 | 5 | 0 |
51924 | 51924 | 2020-04-12 | Jefferson | Kansas | 20087 | 5 | 0 |
54606 | 54606 | 2020-04-13 | Jefferson | Kansas | 20087 | 5 | 0 |
57300 | 57300 | 2020-04-14 | Jefferson | Kansas | 20087 | 5 | 0 |
60008 | 60008 | 2020-04-15 | Jefferson | Kansas | 20087 | 5 | 0 |
62729 | 62729 | 2020-04-16 | Jefferson | Kansas | 20087 | 5 | 0 |
65465 | 65465 | 2020-04-17 | Jefferson | Kansas | 20087 | 6 | 0 |
68214 | 68214 | 2020-04-18 | Jefferson | Kansas | 20087 | 5 | 0 |
70975 | 70975 | 2020-04-19 | Jefferson | Kansas | 20087 | 5 | 0 |
73747 | 73747 | 2020-04-20 | Jefferson | Kansas | 20087 | 6 | 0 |
76527 | 76527 | 2020-04-21 | Jefferson | Kansas | 20087 | 6 | 0 |
79312 | 79312 | 2020-04-22 | Jefferson | Kansas | 20087 | 6 | 0 |
82106 | 82106 | 2020-04-23 | Jefferson | Kansas | 20087 | 7 | 0 |
84908 | 84908 | 2020-04-24 | Jefferson | Kansas | 20087 | 8 | 0 |
87717 | 87717 | 2020-04-25 | Jefferson | Kansas | 20087 | 8 | 0 |
90533 | 90533 | 2020-04-26 | Jefferson | Kansas | 20087 | 8 | 0 |
93354 | 93354 | 2020-04-27 | Jefferson | Kansas | 20087 | 8 | 0 |
96186 | 96186 | 2020-04-28 | Jefferson | Kansas | 20087 | 8 | 0 |
99032 | 99032 | 2020-04-29 | Jefferson | Kansas | 20087 | 9 | 0 |
101884 | 101884 | 2020-04-30 | Jefferson | Kansas | 20087 | 9 | 0 |
104744 | 104744 | 2020-05-01 | Jefferson | Kansas | 20087 | 9 | 0 |
107609 | 107609 | 2020-05-02 | Jefferson | Kansas | 20087 | 10 | 0 |
110480 | 110480 | 2020-05-03 | Jefferson | Kansas | 20087 | 10 | 0 |
113357 | 113357 | 2020-05-04 | Jefferson | Kansas | 20087 | 10 | 0 |
116239 | 116239 | 2020-05-05 | Jefferson | Kansas | 20087 | 10 | 0 |
119200 | 119200 | 2020-05-06 | Jefferson | Kansas | 20087 | 11 | 0 |
122170 | 122170 | 2020-05-07 | Jefferson | Kansas | 20087 | 12 | 0 |
125152 | 125152 | 2020-05-08 | Jefferson | Kansas | 20087 | 12 | 0 |
128140 | 128140 | 2020-05-09 | Jefferson | Kansas | 20087 | 12 | 0 |
131130 | 131130 | 2020-05-10 | Jefferson | Kansas | 20087 | 12 | 0 |
134121 | 134121 | 2020-05-11 | Jefferson | Kansas | 20087 | 13 | 0 |
137111 | 137111 | 2020-05-12 | Jefferson | Kansas | 20087 | 13 | 0 |
140104 | 140104 | 2020-05-13 | Jefferson | Kansas | 20087 | 16 | 0 |
143100 | 143100 | 2020-05-14 | Jefferson | Kansas | 20087 | 16 | 0 |
146100 | 146100 | 2020-05-15 | Jefferson | Kansas | 20087 | 18 | 0 |
149104 | 149104 | 2020-05-16 | Jefferson | Kansas | 20087 | 18 | 0 |
152115 | 152115 | 2020-05-17 | Jefferson | Kansas | 20087 | 18 | 0 |
155127 | 155127 | 2020-05-18 | Jefferson | Kansas | 20087 | 20 | 0 |
158144 | 158144 | 2020-05-19 | Jefferson | Kansas | 20087 | 20 | 0 |
161169 | 161169 | 2020-05-20 | Jefferson | Kansas | 20087 | 21 | 0 |
164198 | 164198 | 2020-05-21 | Jefferson | Kansas | 20087 | 21 | 0 |
167232 | 167232 | 2020-05-22 | Jefferson | Kansas | 20087 | 21 | 0 |
170270 | 170270 | 2020-05-23 | Jefferson | Kansas | 20087 | 21 | 0 |
173311 | 173311 | 2020-05-24 | Jefferson | Kansas | 20087 | 21 | 0 |
176355 | 176355 | 2020-05-25 | Jefferson | Kansas | 20087 | 22 | 0 |
179399 | 179399 | 2020-05-26 | Jefferson | Kansas | 20087 | 22 | 0 |
182444 | 182444 | 2020-05-27 | Jefferson | Kansas | 20087 | 22 | 0 |
185498 | 185498 | 2020-05-28 | Jefferson | Kansas | 20087 | 22 | 0 |
188556 | 188556 | 2020-05-29 | Jefferson | Kansas | 20087 | 22 | 0 |
191620 | 191620 | 2020-05-30 | Jefferson | Kansas | 20087 | 22 | 0 |
194688 | 194688 | 2020-05-31 | Jefferson | Kansas | 20087 | 22 | 0 |
197758 | 197758 | 2020-06-01 | Jefferson | Kansas | 20087 | 22 | 0 |
200830 | 200830 | 2020-06-02 | Jefferson | Kansas | 20087 | 22 | 0 |
203906 | 203906 | 2020-06-03 | Jefferson | Kansas | 20087 | 22 | 0 |
206987 | 206987 | 2020-06-04 | Jefferson | Kansas | 20087 | 22 | 0 |
210068 | 210068 | 2020-06-05 | Jefferson | Kansas | 20087 | 22 | 0 |
213153 | 213153 | 2020-06-06 | Jefferson | Kansas | 20087 | 22 | 0 |
216240 | 216240 | 2020-06-07 | Jefferson | Kansas | 20087 | 22 | 0 |
219332 | 219332 | 2020-06-08 | Jefferson | Kansas | 20087 | 23 | 0 |
222427 | 222427 | 2020-06-09 | Jefferson | Kansas | 20087 | 23 | 0 |
225522 | 225522 | 2020-06-10 | Jefferson | Kansas | 20087 | 23 | 0 |
228624 | 228624 | 2020-06-11 | Jefferson | Kansas | 20087 | 23 | 0 |
231727 | 231727 | 2020-06-12 | Jefferson | Kansas | 20087 | 23 | 0 |
234833 | 234833 | 2020-06-13 | Jefferson | Kansas | 20087 | 23 | 0 |
237940 | 237940 | 2020-06-14 | Jefferson | Kansas | 20087 | 23 | 0 |
241049 | 241049 | 2020-06-15 | Jefferson | Kansas | 20087 | 23 | 0 |
244160 | 244160 | 2020-06-16 | Jefferson | Kansas | 20087 | 23 | 0 |
247273 | 247273 | 2020-06-17 | Jefferson | Kansas | 20087 | 23 | 0 |
250385 | 250385 | 2020-06-18 | Jefferson | Kansas | 20087 | 23 | 0 |
253500 | 253500 | 2020-06-19 | Jefferson | Kansas | 20087 | 23 | 0 |
256620 | 256620 | 2020-06-20 | Jefferson | Kansas | 20087 | 23 | 0 |
259746 | 259746 | 2020-06-21 | Jefferson | Kansas | 20087 | 23 | 0 |
262873 | 262873 | 2020-06-22 | Jefferson | Kansas | 20087 | 23 | 0 |
266001 | 266001 | 2020-06-23 | Jefferson | Kansas | 20087 | 23 | 0 |
269131 | 269131 | 2020-06-24 | Jefferson | Kansas | 20087 | 25 | 0 |
272268 | 272268 | 2020-06-25 | Jefferson | Kansas | 20087 | 25 | 0 |
275411 | 275411 | 2020-06-26 | Jefferson | Kansas | 20087 | 26 | 0 |
278559 | 278559 | 2020-06-27 | Jefferson | Kansas | 20087 | 26 | 0 |
281707 | 281707 | 2020-06-28 | Jefferson | Kansas | 20087 | 26 | 0 |
284852 | 284852 | 2020-06-29 | Jefferson | Kansas | 20087 | 25 | 0 |
288001 | 288001 | 2020-06-30 | Jefferson | Kansas | 20087 | 25 | 0 |
291151 | 291151 | 2020-07-01 | Jefferson | Kansas | 20087 | 25 | 0 |
294305 | 294305 | 2020-07-02 | Jefferson | Kansas | 20087 | 25 | 0 |
297463 | 297463 | 2020-07-03 | Jefferson | Kansas | 20087 | 28 | 0 |
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);