ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Sedgwick" and state = "Kansas" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-19 1
- 2020-03-20 1
- 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
- …
state 1
- Kansas · 786 ✖
fips 1
- 20173 786
county 1
- Sedgwick · 786 ✖
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
4664 | 4664 | 2020-03-19 | Sedgwick | Kansas | 20173 | 1 | 0 |
5477 | 5477 | 2020-03-20 | Sedgwick | Kansas | 20173 | 1 | 0 |
6422 | 6422 | 2020-03-21 | Sedgwick | Kansas | 20173 | 2 | 0 |
7491 | 7491 | 2020-03-22 | Sedgwick | Kansas | 20173 | 2 | 0 |
8653 | 8653 | 2020-03-23 | Sedgwick | Kansas | 20173 | 2 | 0 |
9935 | 9935 | 2020-03-24 | Sedgwick | Kansas | 20173 | 7 | 0 |
11334 | 11334 | 2020-03-25 | Sedgwick | Kansas | 20173 | 11 | 0 |
12902 | 12902 | 2020-03-26 | Sedgwick | Kansas | 20173 | 16 | 0 |
14605 | 14605 | 2020-03-27 | Sedgwick | Kansas | 20173 | 20 | 0 |
16413 | 16413 | 2020-03-28 | Sedgwick | Kansas | 20173 | 33 | 0 |
18320 | 18320 | 2020-03-29 | Sedgwick | Kansas | 20173 | 42 | 0 |
20334 | 20334 | 2020-03-30 | Sedgwick | Kansas | 20173 | 49 | 1 |
22433 | 22433 | 2020-03-31 | Sedgwick | Kansas | 20173 | 58 | 1 |
24609 | 24609 | 2020-04-01 | Sedgwick | Kansas | 20173 | 64 | 1 |
26853 | 26853 | 2020-04-02 | Sedgwick | Kansas | 20173 | 79 | 1 |
29169 | 29169 | 2020-04-03 | Sedgwick | Kansas | 20173 | 85 | 1 |
31543 | 31543 | 2020-04-04 | Sedgwick | Kansas | 20173 | 97 | 1 |
33958 | 33958 | 2020-04-05 | Sedgwick | Kansas | 20173 | 108 | 1 |
36416 | 36416 | 2020-04-06 | Sedgwick | Kansas | 20173 | 124 | 1 |
38920 | 38920 | 2020-04-07 | Sedgwick | Kansas | 20173 | 134 | 1 |
41467 | 41467 | 2020-04-08 | Sedgwick | Kansas | 20173 | 154 | 2 |
44043 | 44043 | 2020-04-09 | Sedgwick | Kansas | 20173 | 161 | 2 |
46650 | 46650 | 2020-04-10 | Sedgwick | Kansas | 20173 | 172 | 2 |
49287 | 49287 | 2020-04-11 | Sedgwick | Kansas | 20173 | 191 | 2 |
51952 | 51952 | 2020-04-12 | Sedgwick | Kansas | 20173 | 194 | 2 |
54634 | 54634 | 2020-04-13 | Sedgwick | Kansas | 20173 | 200 | 2 |
57328 | 57328 | 2020-04-14 | Sedgwick | Kansas | 20173 | 205 | 3 |
60036 | 60036 | 2020-04-15 | Sedgwick | Kansas | 20173 | 209 | 3 |
62757 | 62757 | 2020-04-16 | Sedgwick | Kansas | 20173 | 217 | 3 |
65493 | 65493 | 2020-04-17 | Sedgwick | Kansas | 20173 | 231 | 3 |
68242 | 68242 | 2020-04-18 | Sedgwick | Kansas | 20173 | 232 | 3 |
71003 | 71003 | 2020-04-19 | Sedgwick | Kansas | 20173 | 242 | 4 |
73775 | 73775 | 2020-04-20 | Sedgwick | Kansas | 20173 | 248 | 4 |
76555 | 76555 | 2020-04-21 | Sedgwick | Kansas | 20173 | 251 | 4 |
79340 | 79340 | 2020-04-22 | Sedgwick | Kansas | 20173 | 265 | 5 |
82136 | 82136 | 2020-04-23 | Sedgwick | Kansas | 20173 | 314 | 5 |
84939 | 84939 | 2020-04-24 | Sedgwick | Kansas | 20173 | 323 | 6 |
87748 | 87748 | 2020-04-25 | Sedgwick | Kansas | 20173 | 334 | 6 |
90564 | 90564 | 2020-04-26 | Sedgwick | Kansas | 20173 | 338 | 6 |
93385 | 93385 | 2020-04-27 | Sedgwick | Kansas | 20173 | 339 | 6 |
96218 | 96218 | 2020-04-28 | Sedgwick | Kansas | 20173 | 354 | 6 |
99064 | 99064 | 2020-04-29 | Sedgwick | Kansas | 20173 | 366 | 9 |
101916 | 101916 | 2020-04-30 | Sedgwick | Kansas | 20173 | 402 | 9 |
104777 | 104777 | 2020-05-01 | Sedgwick | Kansas | 20173 | 408 | 11 |
107642 | 107642 | 2020-05-02 | Sedgwick | Kansas | 20173 | 418 | 12 |
110513 | 110513 | 2020-05-03 | Sedgwick | Kansas | 20173 | 426 | 13 |
113390 | 113390 | 2020-05-04 | Sedgwick | Kansas | 20173 | 436 | 13 |
116272 | 116272 | 2020-05-05 | Sedgwick | Kansas | 20173 | 439 | 15 |
119233 | 119233 | 2020-05-06 | Sedgwick | Kansas | 20173 | 441 | 17 |
122203 | 122203 | 2020-05-07 | Sedgwick | Kansas | 20173 | 454 | 18 |
125185 | 125185 | 2020-05-08 | Sedgwick | Kansas | 20173 | 457 | 18 |
128173 | 128173 | 2020-05-09 | Sedgwick | Kansas | 20173 | 458 | 19 |
131163 | 131163 | 2020-05-10 | Sedgwick | Kansas | 20173 | 468 | 19 |
134154 | 134154 | 2020-05-11 | Sedgwick | Kansas | 20173 | 469 | 19 |
137144 | 137144 | 2020-05-12 | Sedgwick | Kansas | 20173 | 471 | 20 |
140137 | 140137 | 2020-05-13 | Sedgwick | Kansas | 20173 | 507 | 20 |
143133 | 143133 | 2020-05-14 | Sedgwick | Kansas | 20173 | 527 | 20 |
146133 | 146133 | 2020-05-15 | Sedgwick | Kansas | 20173 | 530 | 20 |
149137 | 149137 | 2020-05-16 | Sedgwick | Kansas | 20173 | 534 | 20 |
152148 | 152148 | 2020-05-17 | Sedgwick | Kansas | 20173 | 535 | 20 |
155161 | 155161 | 2020-05-18 | Sedgwick | Kansas | 20173 | 536 | 20 |
158178 | 158178 | 2020-05-19 | Sedgwick | Kansas | 20173 | 538 | 20 |
161203 | 161203 | 2020-05-20 | Sedgwick | Kansas | 20173 | 539 | 20 |
164232 | 164232 | 2020-05-21 | Sedgwick | Kansas | 20173 | 542 | 21 |
167267 | 167267 | 2020-05-22 | Sedgwick | Kansas | 20173 | 545 | 21 |
170305 | 170305 | 2020-05-23 | Sedgwick | Kansas | 20173 | 553 | 21 |
173346 | 173346 | 2020-05-24 | Sedgwick | Kansas | 20173 | 556 | 21 |
176390 | 176390 | 2020-05-25 | Sedgwick | Kansas | 20173 | 559 | 21 |
179434 | 179434 | 2020-05-26 | Sedgwick | Kansas | 20173 | 560 | 21 |
182479 | 182479 | 2020-05-27 | Sedgwick | Kansas | 20173 | 564 | 21 |
185533 | 185533 | 2020-05-28 | Sedgwick | Kansas | 20173 | 573 | 21 |
188591 | 188591 | 2020-05-29 | Sedgwick | Kansas | 20173 | 575 | 21 |
191655 | 191655 | 2020-05-30 | Sedgwick | Kansas | 20173 | 580 | 21 |
194723 | 194723 | 2020-05-31 | Sedgwick | Kansas | 20173 | 585 | 21 |
197793 | 197793 | 2020-06-01 | Sedgwick | Kansas | 20173 | 601 | 21 |
200865 | 200865 | 2020-06-02 | Sedgwick | Kansas | 20173 | 604 | 21 |
203942 | 203942 | 2020-06-03 | Sedgwick | Kansas | 20173 | 616 | 21 |
207023 | 207023 | 2020-06-04 | Sedgwick | Kansas | 20173 | 625 | 21 |
210104 | 210104 | 2020-06-05 | Sedgwick | Kansas | 20173 | 635 | 21 |
213189 | 213189 | 2020-06-06 | Sedgwick | Kansas | 20173 | 640 | 21 |
216276 | 216276 | 2020-06-07 | Sedgwick | Kansas | 20173 | 654 | 21 |
219368 | 219368 | 2020-06-08 | Sedgwick | Kansas | 20173 | 660 | 22 |
222463 | 222463 | 2020-06-09 | Sedgwick | Kansas | 20173 | 689 | 22 |
225558 | 225558 | 2020-06-10 | Sedgwick | Kansas | 20173 | 710 | 22 |
228660 | 228660 | 2020-06-11 | Sedgwick | Kansas | 20173 | 717 | 23 |
231763 | 231763 | 2020-06-12 | Sedgwick | Kansas | 20173 | 728 | 23 |
234869 | 234869 | 2020-06-13 | Sedgwick | Kansas | 20173 | 739 | 25 |
237976 | 237976 | 2020-06-14 | Sedgwick | Kansas | 20173 | 745 | 25 |
241085 | 241085 | 2020-06-15 | Sedgwick | Kansas | 20173 | 764 | 25 |
244196 | 244196 | 2020-06-16 | Sedgwick | Kansas | 20173 | 791 | 25 |
247309 | 247309 | 2020-06-17 | Sedgwick | Kansas | 20173 | 810 | 25 |
250421 | 250421 | 2020-06-18 | Sedgwick | Kansas | 20173 | 821 | 25 |
253536 | 253536 | 2020-06-19 | Sedgwick | Kansas | 20173 | 846 | 25 |
256656 | 256656 | 2020-06-20 | Sedgwick | Kansas | 20173 | 867 | 25 |
259782 | 259782 | 2020-06-21 | Sedgwick | Kansas | 20173 | 882 | 25 |
262909 | 262909 | 2020-06-22 | Sedgwick | Kansas | 20173 | 896 | 25 |
266037 | 266037 | 2020-06-23 | Sedgwick | Kansas | 20173 | 937 | 26 |
269169 | 269169 | 2020-06-24 | Sedgwick | Kansas | 20173 | 974 | 26 |
272306 | 272306 | 2020-06-25 | Sedgwick | Kansas | 20173 | 1001 | 28 |
275449 | 275449 | 2020-06-26 | Sedgwick | Kansas | 20173 | 1072 | 28 |
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);