ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 20045 and state = "Kansas" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
3399 | 3399 | 2020-03-17 | Douglas | Kansas | 20045 | 1 | 0 |
3975 | 3975 | 2020-03-18 | Douglas | Kansas | 20045 | 1 | 0 |
4657 | 4657 | 2020-03-19 | Douglas | Kansas | 20045 | 1 | 0 |
5468 | 5468 | 2020-03-20 | Douglas | Kansas | 20045 | 1 | 0 |
6413 | 6413 | 2020-03-21 | Douglas | Kansas | 20045 | 3 | 0 |
7480 | 7480 | 2020-03-22 | Douglas | Kansas | 20045 | 4 | 0 |
8641 | 8641 | 2020-03-23 | Douglas | Kansas | 20045 | 6 | 0 |
9922 | 9922 | 2020-03-24 | Douglas | Kansas | 20045 | 6 | 0 |
11320 | 11320 | 2020-03-25 | Douglas | Kansas | 20045 | 10 | 0 |
12887 | 12887 | 2020-03-26 | Douglas | Kansas | 20045 | 13 | 0 |
14585 | 14585 | 2020-03-27 | Douglas | Kansas | 20045 | 18 | 0 |
16392 | 16392 | 2020-03-28 | Douglas | Kansas | 20045 | 23 | 0 |
18297 | 18297 | 2020-03-29 | Douglas | Kansas | 20045 | 23 | 0 |
20310 | 20310 | 2020-03-30 | Douglas | Kansas | 20045 | 23 | 0 |
22408 | 22408 | 2020-03-31 | Douglas | Kansas | 20045 | 24 | 0 |
24583 | 24583 | 2020-04-01 | Douglas | Kansas | 20045 | 30 | 0 |
26827 | 26827 | 2020-04-02 | Douglas | Kansas | 20045 | 31 | 0 |
29141 | 29141 | 2020-04-03 | Douglas | Kansas | 20045 | 31 | 0 |
31513 | 31513 | 2020-04-04 | Douglas | Kansas | 20045 | 32 | 0 |
33926 | 33926 | 2020-04-05 | Douglas | Kansas | 20045 | 33 | 0 |
36383 | 36383 | 2020-04-06 | Douglas | Kansas | 20045 | 36 | 0 |
38885 | 38885 | 2020-04-07 | Douglas | Kansas | 20045 | 38 | 0 |
41432 | 41432 | 2020-04-08 | Douglas | Kansas | 20045 | 38 | 0 |
44008 | 44008 | 2020-04-09 | Douglas | Kansas | 20045 | 38 | 0 |
46615 | 46615 | 2020-04-10 | Douglas | Kansas | 20045 | 39 | 0 |
49249 | 49249 | 2020-04-11 | Douglas | Kansas | 20045 | 39 | 0 |
51913 | 51913 | 2020-04-12 | Douglas | Kansas | 20045 | 39 | 0 |
54595 | 54595 | 2020-04-13 | Douglas | Kansas | 20045 | 40 | 0 |
57289 | 57289 | 2020-04-14 | Douglas | Kansas | 20045 | 40 | 0 |
59997 | 59997 | 2020-04-15 | Douglas | Kansas | 20045 | 41 | 0 |
62718 | 62718 | 2020-04-16 | Douglas | Kansas | 20045 | 42 | 0 |
65454 | 65454 | 2020-04-17 | Douglas | Kansas | 20045 | 42 | 0 |
68203 | 68203 | 2020-04-18 | Douglas | Kansas | 20045 | 43 | 0 |
70964 | 70964 | 2020-04-19 | Douglas | Kansas | 20045 | 43 | 0 |
73735 | 73735 | 2020-04-20 | Douglas | Kansas | 20045 | 43 | 0 |
76515 | 76515 | 2020-04-21 | Douglas | Kansas | 20045 | 43 | 0 |
79299 | 79299 | 2020-04-22 | Douglas | Kansas | 20045 | 43 | 0 |
82092 | 82092 | 2020-04-23 | Douglas | Kansas | 20045 | 44 | 0 |
84893 | 84893 | 2020-04-24 | Douglas | Kansas | 20045 | 46 | 0 |
87702 | 87702 | 2020-04-25 | Douglas | Kansas | 20045 | 48 | 0 |
90518 | 90518 | 2020-04-26 | Douglas | Kansas | 20045 | 48 | 0 |
93339 | 93339 | 2020-04-27 | Douglas | Kansas | 20045 | 49 | 0 |
96171 | 96171 | 2020-04-28 | Douglas | Kansas | 20045 | 49 | 0 |
99017 | 99017 | 2020-04-29 | Douglas | Kansas | 20045 | 49 | 0 |
101868 | 101868 | 2020-04-30 | Douglas | Kansas | 20045 | 50 | 0 |
104728 | 104728 | 2020-05-01 | Douglas | Kansas | 20045 | 51 | 0 |
107593 | 107593 | 2020-05-02 | Douglas | Kansas | 20045 | 51 | 0 |
110464 | 110464 | 2020-05-03 | Douglas | Kansas | 20045 | 51 | 0 |
113340 | 113340 | 2020-05-04 | Douglas | Kansas | 20045 | 51 | 0 |
116222 | 116222 | 2020-05-05 | Douglas | Kansas | 20045 | 51 | 0 |
119183 | 119183 | 2020-05-06 | Douglas | Kansas | 20045 | 56 | 0 |
122153 | 122153 | 2020-05-07 | Douglas | Kansas | 20045 | 56 | 0 |
125135 | 125135 | 2020-05-08 | Douglas | Kansas | 20045 | 56 | 0 |
128123 | 128123 | 2020-05-09 | Douglas | Kansas | 20045 | 56 | 0 |
131113 | 131113 | 2020-05-10 | Douglas | Kansas | 20045 | 56 | 0 |
134104 | 134104 | 2020-05-11 | Douglas | Kansas | 20045 | 57 | 0 |
137094 | 137094 | 2020-05-12 | Douglas | Kansas | 20045 | 58 | 0 |
140087 | 140087 | 2020-05-13 | Douglas | Kansas | 20045 | 58 | 0 |
143083 | 143083 | 2020-05-14 | Douglas | Kansas | 20045 | 58 | 0 |
146083 | 146083 | 2020-05-15 | Douglas | Kansas | 20045 | 58 | 0 |
149087 | 149087 | 2020-05-16 | Douglas | Kansas | 20045 | 60 | 0 |
152098 | 152098 | 2020-05-17 | Douglas | Kansas | 20045 | 60 | 0 |
155110 | 155110 | 2020-05-18 | Douglas | Kansas | 20045 | 61 | 0 |
158127 | 158127 | 2020-05-19 | Douglas | Kansas | 20045 | 62 | 0 |
161152 | 161152 | 2020-05-20 | Douglas | Kansas | 20045 | 62 | 0 |
164181 | 164181 | 2020-05-21 | Douglas | Kansas | 20045 | 62 | 0 |
167214 | 167214 | 2020-05-22 | Douglas | Kansas | 20045 | 63 | 0 |
170252 | 170252 | 2020-05-23 | Douglas | Kansas | 20045 | 63 | 0 |
173293 | 173293 | 2020-05-24 | Douglas | Kansas | 20045 | 63 | 0 |
176337 | 176337 | 2020-05-25 | Douglas | Kansas | 20045 | 63 | 0 |
179381 | 179381 | 2020-05-26 | Douglas | Kansas | 20045 | 63 | 0 |
182426 | 182426 | 2020-05-27 | Douglas | Kansas | 20045 | 63 | 0 |
185480 | 185480 | 2020-05-28 | Douglas | Kansas | 20045 | 65 | 0 |
188538 | 188538 | 2020-05-29 | Douglas | Kansas | 20045 | 66 | 0 |
191602 | 191602 | 2020-05-30 | Douglas | Kansas | 20045 | 66 | 0 |
194670 | 194670 | 2020-05-31 | Douglas | Kansas | 20045 | 66 | 0 |
197740 | 197740 | 2020-06-01 | Douglas | Kansas | 20045 | 67 | 0 |
200812 | 200812 | 2020-06-02 | Douglas | Kansas | 20045 | 67 | 0 |
203888 | 203888 | 2020-06-03 | Douglas | Kansas | 20045 | 67 | 0 |
206969 | 206969 | 2020-06-04 | Douglas | Kansas | 20045 | 69 | 0 |
210050 | 210050 | 2020-06-05 | Douglas | Kansas | 20045 | 70 | 0 |
213135 | 213135 | 2020-06-06 | Douglas | Kansas | 20045 | 70 | 0 |
216222 | 216222 | 2020-06-07 | Douglas | Kansas | 20045 | 70 | 0 |
219314 | 219314 | 2020-06-08 | Douglas | Kansas | 20045 | 74 | 0 |
222409 | 222409 | 2020-06-09 | Douglas | Kansas | 20045 | 74 | 0 |
225504 | 225504 | 2020-06-10 | Douglas | Kansas | 20045 | 78 | 0 |
228606 | 228606 | 2020-06-11 | Douglas | Kansas | 20045 | 78 | 0 |
231709 | 231709 | 2020-06-12 | Douglas | Kansas | 20045 | 82 | 0 |
234815 | 234815 | 2020-06-13 | Douglas | Kansas | 20045 | 82 | 0 |
237922 | 237922 | 2020-06-14 | Douglas | Kansas | 20045 | 82 | 0 |
241031 | 241031 | 2020-06-15 | Douglas | Kansas | 20045 | 85 | 0 |
244142 | 244142 | 2020-06-16 | Douglas | Kansas | 20045 | 85 | 0 |
247255 | 247255 | 2020-06-17 | Douglas | Kansas | 20045 | 88 | 0 |
250367 | 250367 | 2020-06-18 | Douglas | Kansas | 20045 | 88 | 0 |
253482 | 253482 | 2020-06-19 | Douglas | Kansas | 20045 | 93 | 0 |
256602 | 256602 | 2020-06-20 | Douglas | Kansas | 20045 | 93 | 0 |
259728 | 259728 | 2020-06-21 | Douglas | Kansas | 20045 | 93 | 0 |
262855 | 262855 | 2020-06-22 | Douglas | Kansas | 20045 | 103 | 0 |
265983 | 265983 | 2020-06-23 | Douglas | Kansas | 20045 | 103 | 0 |
269113 | 269113 | 2020-06-24 | Douglas | Kansas | 20045 | 106 | 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);