ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 20015 and state = "Kansas" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
1730 | 1730 | 2020-03-13 | Butler | Kansas | 20015 | 1 | 0 |
2064 | 2064 | 2020-03-14 | Butler | Kansas | 20015 | 1 | 0 |
2460 | 2460 | 2020-03-15 | Butler | Kansas | 20015 | 1 | 0 |
2905 | 2905 | 2020-03-16 | Butler | Kansas | 20015 | 1 | 0 |
3398 | 3398 | 2020-03-17 | Butler | Kansas | 20015 | 1 | 0 |
3974 | 3974 | 2020-03-18 | Butler | Kansas | 20015 | 1 | 0 |
4655 | 4655 | 2020-03-19 | Butler | Kansas | 20015 | 1 | 0 |
5466 | 5466 | 2020-03-20 | Butler | Kansas | 20015 | 2 | 0 |
6411 | 6411 | 2020-03-21 | Butler | Kansas | 20015 | 2 | 0 |
7478 | 7478 | 2020-03-22 | Butler | Kansas | 20015 | 3 | 0 |
8639 | 8639 | 2020-03-23 | Butler | Kansas | 20015 | 3 | 0 |
9919 | 9919 | 2020-03-24 | Butler | Kansas | 20015 | 3 | 0 |
11316 | 11316 | 2020-03-25 | Butler | Kansas | 20015 | 3 | 0 |
12883 | 12883 | 2020-03-26 | Butler | Kansas | 20015 | 3 | 0 |
14579 | 14579 | 2020-03-27 | Butler | Kansas | 20015 | 3 | 0 |
16386 | 16386 | 2020-03-28 | Butler | Kansas | 20015 | 3 | 0 |
18291 | 18291 | 2020-03-29 | Butler | Kansas | 20015 | 3 | 0 |
20304 | 20304 | 2020-03-30 | Butler | Kansas | 20015 | 3 | 0 |
22401 | 22401 | 2020-03-31 | Butler | Kansas | 20015 | 3 | 0 |
24576 | 24576 | 2020-04-01 | Butler | Kansas | 20015 | 5 | 0 |
26818 | 26818 | 2020-04-02 | Butler | Kansas | 20015 | 7 | 0 |
29132 | 29132 | 2020-04-03 | Butler | Kansas | 20015 | 7 | 0 |
31504 | 31504 | 2020-04-04 | Butler | Kansas | 20015 | 8 | 0 |
33917 | 33917 | 2020-04-05 | Butler | Kansas | 20015 | 8 | 0 |
36374 | 36374 | 2020-04-06 | Butler | Kansas | 20015 | 8 | 0 |
38876 | 38876 | 2020-04-07 | Butler | Kansas | 20015 | 8 | 0 |
41423 | 41423 | 2020-04-08 | Butler | Kansas | 20015 | 8 | 0 |
43999 | 43999 | 2020-04-09 | Butler | Kansas | 20015 | 8 | 0 |
46606 | 46606 | 2020-04-10 | Butler | Kansas | 20015 | 8 | 0 |
49240 | 49240 | 2020-04-11 | Butler | Kansas | 20015 | 8 | 0 |
51904 | 51904 | 2020-04-12 | Butler | Kansas | 20015 | 8 | 0 |
54586 | 54586 | 2020-04-13 | Butler | Kansas | 20015 | 9 | 0 |
57279 | 57279 | 2020-04-14 | Butler | Kansas | 20015 | 9 | 0 |
59987 | 59987 | 2020-04-15 | Butler | Kansas | 20015 | 10 | 0 |
62708 | 62708 | 2020-04-16 | Butler | Kansas | 20015 | 10 | 0 |
65443 | 65443 | 2020-04-17 | Butler | Kansas | 20015 | 12 | 0 |
68192 | 68192 | 2020-04-18 | Butler | Kansas | 20015 | 12 | 0 |
70953 | 70953 | 2020-04-19 | Butler | Kansas | 20015 | 12 | 0 |
73724 | 73724 | 2020-04-20 | Butler | Kansas | 20015 | 12 | 0 |
76504 | 76504 | 2020-04-21 | Butler | Kansas | 20015 | 12 | 0 |
79288 | 79288 | 2020-04-22 | Butler | Kansas | 20015 | 13 | 0 |
82080 | 82080 | 2020-04-23 | Butler | Kansas | 20015 | 13 | 0 |
84881 | 84881 | 2020-04-24 | Butler | Kansas | 20015 | 13 | 0 |
87690 | 87690 | 2020-04-25 | Butler | Kansas | 20015 | 13 | 0 |
90506 | 90506 | 2020-04-26 | Butler | Kansas | 20015 | 13 | 0 |
93327 | 93327 | 2020-04-27 | Butler | Kansas | 20015 | 14 | 0 |
96159 | 96159 | 2020-04-28 | Butler | Kansas | 20015 | 15 | 0 |
125122 | 125122 | 2020-05-08 | Butler | Kansas | 20015 | 15 | 0 |
128110 | 128110 | 2020-05-09 | Butler | Kansas | 20015 | 15 | 0 |
99004 | 99004 | 2020-04-29 | Butler | Kansas | 20015 | 16 | 0 |
101855 | 101855 | 2020-04-30 | Butler | Kansas | 20015 | 16 | 0 |
104715 | 104715 | 2020-05-01 | Butler | Kansas | 20015 | 16 | 0 |
107580 | 107580 | 2020-05-02 | Butler | Kansas | 20015 | 16 | 0 |
110451 | 110451 | 2020-05-03 | Butler | Kansas | 20015 | 16 | 0 |
113327 | 113327 | 2020-05-04 | Butler | Kansas | 20015 | 16 | 0 |
116209 | 116209 | 2020-05-05 | Butler | Kansas | 20015 | 16 | 0 |
119170 | 119170 | 2020-05-06 | Butler | Kansas | 20015 | 16 | 0 |
122140 | 122140 | 2020-05-07 | Butler | Kansas | 20015 | 16 | 0 |
131100 | 131100 | 2020-05-10 | Butler | Kansas | 20015 | 17 | 0 |
134091 | 134091 | 2020-05-11 | Butler | Kansas | 20015 | 18 | 0 |
137081 | 137081 | 2020-05-12 | Butler | Kansas | 20015 | 18 | 0 |
140074 | 140074 | 2020-05-13 | Butler | Kansas | 20015 | 19 | 0 |
143070 | 143070 | 2020-05-14 | Butler | Kansas | 20015 | 19 | 0 |
146070 | 146070 | 2020-05-15 | Butler | Kansas | 20015 | 22 | 0 |
149074 | 149074 | 2020-05-16 | Butler | Kansas | 20015 | 22 | 0 |
152085 | 152085 | 2020-05-17 | Butler | Kansas | 20015 | 22 | 0 |
155097 | 155097 | 2020-05-18 | Butler | Kansas | 20015 | 23 | 0 |
158114 | 158114 | 2020-05-19 | Butler | Kansas | 20015 | 23 | 0 |
161139 | 161139 | 2020-05-20 | Butler | Kansas | 20015 | 23 | 0 |
164168 | 164168 | 2020-05-21 | Butler | Kansas | 20015 | 24 | 0 |
167200 | 167200 | 2020-05-22 | Butler | Kansas | 20015 | 26 | 0 |
170238 | 170238 | 2020-05-23 | Butler | Kansas | 20015 | 27 | 0 |
173279 | 173279 | 2020-05-24 | Butler | Kansas | 20015 | 30 | 0 |
176323 | 176323 | 2020-05-25 | Butler | Kansas | 20015 | 30 | 0 |
179367 | 179367 | 2020-05-26 | Butler | Kansas | 20015 | 31 | 0 |
182412 | 182412 | 2020-05-27 | Butler | Kansas | 20015 | 31 | 0 |
185466 | 185466 | 2020-05-28 | Butler | Kansas | 20015 | 33 | 0 |
188524 | 188524 | 2020-05-29 | Butler | Kansas | 20015 | 34 | 0 |
191588 | 191588 | 2020-05-30 | Butler | Kansas | 20015 | 34 | 0 |
194656 | 194656 | 2020-05-31 | Butler | Kansas | 20015 | 35 | 0 |
197726 | 197726 | 2020-06-01 | Butler | Kansas | 20015 | 37 | 0 |
200798 | 200798 | 2020-06-02 | Butler | Kansas | 20015 | 38 | 0 |
203874 | 203874 | 2020-06-03 | Butler | Kansas | 20015 | 39 | 0 |
206955 | 206955 | 2020-06-04 | Butler | Kansas | 20015 | 39 | 0 |
210036 | 210036 | 2020-06-05 | Butler | Kansas | 20015 | 40 | 0 |
213121 | 213121 | 2020-06-06 | Butler | Kansas | 20015 | 40 | 0 |
216208 | 216208 | 2020-06-07 | Butler | Kansas | 20015 | 40 | 0 |
219300 | 219300 | 2020-06-08 | Butler | Kansas | 20015 | 40 | 0 |
222395 | 222395 | 2020-06-09 | Butler | Kansas | 20015 | 40 | 0 |
225490 | 225490 | 2020-06-10 | Butler | Kansas | 20015 | 40 | 0 |
228592 | 228592 | 2020-06-11 | Butler | Kansas | 20015 | 40 | 0 |
231695 | 231695 | 2020-06-12 | Butler | Kansas | 20015 | 41 | 0 |
234801 | 234801 | 2020-06-13 | Butler | Kansas | 20015 | 41 | 0 |
237908 | 237908 | 2020-06-14 | Butler | Kansas | 20015 | 41 | 0 |
241017 | 241017 | 2020-06-15 | Butler | Kansas | 20015 | 41 | 0 |
244128 | 244128 | 2020-06-16 | Butler | Kansas | 20015 | 41 | 0 |
247241 | 247241 | 2020-06-17 | Butler | Kansas | 20015 | 42 | 0 |
250353 | 250353 | 2020-06-18 | Butler | Kansas | 20015 | 43 | 0 |
253468 | 253468 | 2020-06-19 | Butler | Kansas | 20015 | 49 | 0 |
256588 | 256588 | 2020-06-20 | Butler | Kansas | 20015 | 49 | 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);