ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 20037 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 |
---|---|---|---|---|---|---|---|
11318 | 11318 | 2020-03-25 | Crawford | Kansas | 20037 | 1 | 0 |
12885 | 12885 | 2020-03-26 | Crawford | Kansas | 20037 | 3 | 0 |
14583 | 14583 | 2020-03-27 | Crawford | Kansas | 20037 | 3 | 0 |
16390 | 16390 | 2020-03-28 | Crawford | Kansas | 20037 | 3 | 0 |
18295 | 18295 | 2020-03-29 | Crawford | Kansas | 20037 | 4 | 0 |
20308 | 20308 | 2020-03-30 | Crawford | Kansas | 20037 | 5 | 1 |
22406 | 22406 | 2020-03-31 | Crawford | Kansas | 20037 | 5 | 1 |
24581 | 24581 | 2020-04-01 | Crawford | Kansas | 20037 | 5 | 1 |
99014 | 99014 | 2020-04-29 | Crawford | Kansas | 20037 | 5 | 1 |
101865 | 101865 | 2020-04-30 | Crawford | Kansas | 20037 | 5 | 1 |
26825 | 26825 | 2020-04-02 | Crawford | Kansas | 20037 | 6 | 1 |
29139 | 29139 | 2020-04-03 | Crawford | Kansas | 20037 | 6 | 1 |
31511 | 31511 | 2020-04-04 | Crawford | Kansas | 20037 | 6 | 1 |
33924 | 33924 | 2020-04-05 | Crawford | Kansas | 20037 | 6 | 1 |
36381 | 36381 | 2020-04-06 | Crawford | Kansas | 20037 | 6 | 1 |
38883 | 38883 | 2020-04-07 | Crawford | Kansas | 20037 | 6 | 1 |
41430 | 41430 | 2020-04-08 | Crawford | Kansas | 20037 | 6 | 1 |
44006 | 44006 | 2020-04-09 | Crawford | Kansas | 20037 | 6 | 1 |
46613 | 46613 | 2020-04-10 | Crawford | Kansas | 20037 | 6 | 1 |
49247 | 49247 | 2020-04-11 | Crawford | Kansas | 20037 | 6 | 1 |
51911 | 51911 | 2020-04-12 | Crawford | Kansas | 20037 | 6 | 1 |
54593 | 54593 | 2020-04-13 | Crawford | Kansas | 20037 | 6 | 1 |
57286 | 57286 | 2020-04-14 | Crawford | Kansas | 20037 | 6 | 1 |
59994 | 59994 | 2020-04-15 | Crawford | Kansas | 20037 | 6 | 1 |
62715 | 62715 | 2020-04-16 | Crawford | Kansas | 20037 | 6 | 1 |
65451 | 65451 | 2020-04-17 | Crawford | Kansas | 20037 | 6 | 1 |
68200 | 68200 | 2020-04-18 | Crawford | Kansas | 20037 | 6 | 1 |
70961 | 70961 | 2020-04-19 | Crawford | Kansas | 20037 | 6 | 1 |
73732 | 73732 | 2020-04-20 | Crawford | Kansas | 20037 | 6 | 1 |
76512 | 76512 | 2020-04-21 | Crawford | Kansas | 20037 | 6 | 1 |
79296 | 79296 | 2020-04-22 | Crawford | Kansas | 20037 | 6 | 1 |
82089 | 82089 | 2020-04-23 | Crawford | Kansas | 20037 | 6 | 1 |
84890 | 84890 | 2020-04-24 | Crawford | Kansas | 20037 | 6 | 1 |
87699 | 87699 | 2020-04-25 | Crawford | Kansas | 20037 | 6 | 1 |
90515 | 90515 | 2020-04-26 | Crawford | Kansas | 20037 | 6 | 1 |
104725 | 104725 | 2020-05-01 | Crawford | Kansas | 20037 | 6 | 1 |
107590 | 107590 | 2020-05-02 | Crawford | Kansas | 20037 | 6 | 1 |
110461 | 110461 | 2020-05-03 | Crawford | Kansas | 20037 | 6 | 1 |
113337 | 113337 | 2020-05-04 | Crawford | Kansas | 20037 | 6 | 1 |
116219 | 116219 | 2020-05-05 | Crawford | Kansas | 20037 | 6 | 1 |
119180 | 119180 | 2020-05-06 | Crawford | Kansas | 20037 | 6 | 1 |
122150 | 122150 | 2020-05-07 | Crawford | Kansas | 20037 | 6 | 1 |
125132 | 125132 | 2020-05-08 | Crawford | Kansas | 20037 | 6 | 1 |
128120 | 128120 | 2020-05-09 | Crawford | Kansas | 20037 | 6 | 1 |
131110 | 131110 | 2020-05-10 | Crawford | Kansas | 20037 | 6 | 1 |
134101 | 134101 | 2020-05-11 | Crawford | Kansas | 20037 | 6 | 1 |
137091 | 137091 | 2020-05-12 | Crawford | Kansas | 20037 | 6 | 1 |
140084 | 140084 | 2020-05-13 | Crawford | Kansas | 20037 | 6 | 1 |
143080 | 143080 | 2020-05-14 | Crawford | Kansas | 20037 | 6 | 1 |
146080 | 146080 | 2020-05-15 | Crawford | Kansas | 20037 | 6 | 1 |
149084 | 149084 | 2020-05-16 | Crawford | Kansas | 20037 | 6 | 1 |
152095 | 152095 | 2020-05-17 | Crawford | Kansas | 20037 | 6 | 1 |
155107 | 155107 | 2020-05-18 | Crawford | Kansas | 20037 | 6 | 1 |
158124 | 158124 | 2020-05-19 | Crawford | Kansas | 20037 | 6 | 1 |
167211 | 167211 | 2020-05-22 | Crawford | Kansas | 20037 | 6 | 1 |
170249 | 170249 | 2020-05-23 | Crawford | Kansas | 20037 | 6 | 1 |
173290 | 173290 | 2020-05-24 | Crawford | Kansas | 20037 | 6 | 1 |
176334 | 176334 | 2020-05-25 | Crawford | Kansas | 20037 | 6 | 1 |
179378 | 179378 | 2020-05-26 | Crawford | Kansas | 20037 | 6 | 1 |
182423 | 182423 | 2020-05-27 | Crawford | Kansas | 20037 | 6 | 1 |
185477 | 185477 | 2020-05-28 | Crawford | Kansas | 20037 | 6 | 1 |
188535 | 188535 | 2020-05-29 | Crawford | Kansas | 20037 | 6 | 1 |
191599 | 191599 | 2020-05-30 | Crawford | Kansas | 20037 | 6 | 1 |
194667 | 194667 | 2020-05-31 | Crawford | Kansas | 20037 | 6 | 1 |
197737 | 197737 | 2020-06-01 | Crawford | Kansas | 20037 | 6 | 1 |
200809 | 200809 | 2020-06-02 | Crawford | Kansas | 20037 | 6 | 1 |
203885 | 203885 | 2020-06-03 | Crawford | Kansas | 20037 | 6 | 1 |
206966 | 206966 | 2020-06-04 | Crawford | Kansas | 20037 | 6 | 1 |
210047 | 210047 | 2020-06-05 | Crawford | Kansas | 20037 | 6 | 1 |
213132 | 213132 | 2020-06-06 | Crawford | Kansas | 20037 | 6 | 1 |
216219 | 216219 | 2020-06-07 | Crawford | Kansas | 20037 | 6 | 1 |
219311 | 219311 | 2020-06-08 | Crawford | Kansas | 20037 | 6 | 1 |
222406 | 222406 | 2020-06-09 | Crawford | Kansas | 20037 | 6 | 1 |
93336 | 93336 | 2020-04-27 | Crawford | Kansas | 20037 | 7 | 1 |
96168 | 96168 | 2020-04-28 | Crawford | Kansas | 20037 | 7 | 1 |
161149 | 161149 | 2020-05-20 | Crawford | Kansas | 20037 | 7 | 1 |
164178 | 164178 | 2020-05-21 | Crawford | Kansas | 20037 | 7 | 1 |
225501 | 225501 | 2020-06-10 | Crawford | Kansas | 20037 | 9 | 1 |
228603 | 228603 | 2020-06-11 | Crawford | Kansas | 20037 | 9 | 1 |
231706 | 231706 | 2020-06-12 | Crawford | Kansas | 20037 | 18 | 1 |
234812 | 234812 | 2020-06-13 | Crawford | Kansas | 20037 | 18 | 1 |
237919 | 237919 | 2020-06-14 | Crawford | Kansas | 20037 | 18 | 1 |
241028 | 241028 | 2020-06-15 | Crawford | Kansas | 20037 | 96 | 1 |
244139 | 244139 | 2020-06-16 | Crawford | Kansas | 20037 | 96 | 1 |
247252 | 247252 | 2020-06-17 | Crawford | Kansas | 20037 | 156 | 1 |
250364 | 250364 | 2020-06-18 | Crawford | Kansas | 20037 | 156 | 1 |
253479 | 253479 | 2020-06-19 | Crawford | Kansas | 20037 | 167 | 1 |
256599 | 256599 | 2020-06-20 | Crawford | Kansas | 20037 | 167 | 1 |
259725 | 259725 | 2020-06-21 | Crawford | Kansas | 20037 | 167 | 1 |
262852 | 262852 | 2020-06-22 | Crawford | Kansas | 20037 | 192 | 1 |
265980 | 265980 | 2020-06-23 | Crawford | Kansas | 20037 | 192 | 1 |
269110 | 269110 | 2020-06-24 | Crawford | Kansas | 20037 | 220 | 1 |
272247 | 272247 | 2020-06-25 | Crawford | Kansas | 20037 | 220 | 1 |
275389 | 275389 | 2020-06-26 | Crawford | Kansas | 20037 | 246 | 1 |
278537 | 278537 | 2020-06-27 | Crawford | Kansas | 20037 | 246 | 1 |
281685 | 281685 | 2020-06-28 | Crawford | Kansas | 20037 | 246 | 1 |
284830 | 284830 | 2020-06-29 | Crawford | Kansas | 20037 | 256 | 1 |
287979 | 287979 | 2020-06-30 | Crawford | Kansas | 20037 | 256 | 1 |
291129 | 291129 | 2020-07-01 | Crawford | Kansas | 20037 | 263 | 1 |
294283 | 294283 | 2020-07-02 | Crawford | Kansas | 20037 | 263 | 1 |
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);