ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 20011 and state = "Kansas" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
8638 | 8638 | 2020-03-23 | Bourbon | Kansas | 20011 | 1 | 0 |
9918 | 9918 | 2020-03-24 | Bourbon | Kansas | 20011 | 1 | 0 |
11315 | 11315 | 2020-03-25 | Bourbon | Kansas | 20011 | 1 | 0 |
12882 | 12882 | 2020-03-26 | Bourbon | Kansas | 20011 | 1 | 0 |
14578 | 14578 | 2020-03-27 | Bourbon | Kansas | 20011 | 3 | 0 |
16385 | 16385 | 2020-03-28 | Bourbon | Kansas | 20011 | 3 | 0 |
18290 | 18290 | 2020-03-29 | Bourbon | Kansas | 20011 | 3 | 0 |
20303 | 20303 | 2020-03-30 | Bourbon | Kansas | 20011 | 3 | 0 |
22400 | 22400 | 2020-03-31 | Bourbon | Kansas | 20011 | 3 | 0 |
24575 | 24575 | 2020-04-01 | Bourbon | Kansas | 20011 | 3 | 0 |
26817 | 26817 | 2020-04-02 | Bourbon | Kansas | 20011 | 3 | 0 |
29131 | 29131 | 2020-04-03 | Bourbon | Kansas | 20011 | 3 | 0 |
31503 | 31503 | 2020-04-04 | Bourbon | Kansas | 20011 | 4 | 0 |
33916 | 33916 | 2020-04-05 | Bourbon | Kansas | 20011 | 6 | 0 |
36373 | 36373 | 2020-04-06 | Bourbon | Kansas | 20011 | 6 | 0 |
38875 | 38875 | 2020-04-07 | Bourbon | Kansas | 20011 | 6 | 1 |
41422 | 41422 | 2020-04-08 | Bourbon | Kansas | 20011 | 6 | 1 |
43998 | 43998 | 2020-04-09 | Bourbon | Kansas | 20011 | 6 | 1 |
46605 | 46605 | 2020-04-10 | Bourbon | Kansas | 20011 | 6 | 1 |
49239 | 49239 | 2020-04-11 | Bourbon | Kansas | 20011 | 6 | 1 |
51903 | 51903 | 2020-04-12 | Bourbon | Kansas | 20011 | 6 | 1 |
54585 | 54585 | 2020-04-13 | Bourbon | Kansas | 20011 | 6 | 1 |
57278 | 57278 | 2020-04-14 | Bourbon | Kansas | 20011 | 6 | 1 |
59986 | 59986 | 2020-04-15 | Bourbon | Kansas | 20011 | 6 | 1 |
62707 | 62707 | 2020-04-16 | Bourbon | Kansas | 20011 | 6 | 1 |
65442 | 65442 | 2020-04-17 | Bourbon | Kansas | 20011 | 6 | 1 |
68191 | 68191 | 2020-04-18 | Bourbon | Kansas | 20011 | 6 | 1 |
70952 | 70952 | 2020-04-19 | Bourbon | Kansas | 20011 | 6 | 1 |
73723 | 73723 | 2020-04-20 | Bourbon | Kansas | 20011 | 6 | 1 |
76503 | 76503 | 2020-04-21 | Bourbon | Kansas | 20011 | 6 | 1 |
79287 | 79287 | 2020-04-22 | Bourbon | Kansas | 20011 | 6 | 1 |
82079 | 82079 | 2020-04-23 | Bourbon | Kansas | 20011 | 6 | 1 |
84880 | 84880 | 2020-04-24 | Bourbon | Kansas | 20011 | 6 | 1 |
87689 | 87689 | 2020-04-25 | Bourbon | Kansas | 20011 | 6 | 1 |
90505 | 90505 | 2020-04-26 | Bourbon | Kansas | 20011 | 6 | 1 |
93326 | 93326 | 2020-04-27 | Bourbon | Kansas | 20011 | 6 | 1 |
96158 | 96158 | 2020-04-28 | Bourbon | Kansas | 20011 | 6 | 1 |
99003 | 99003 | 2020-04-29 | Bourbon | Kansas | 20011 | 6 | 1 |
101854 | 101854 | 2020-04-30 | Bourbon | Kansas | 20011 | 6 | 1 |
104714 | 104714 | 2020-05-01 | Bourbon | Kansas | 20011 | 6 | 1 |
107579 | 107579 | 2020-05-02 | Bourbon | Kansas | 20011 | 6 | 1 |
110450 | 110450 | 2020-05-03 | Bourbon | Kansas | 20011 | 6 | 1 |
113325 | 113325 | 2020-05-04 | Bourbon | Kansas | 20011 | 6 | 1 |
116207 | 116207 | 2020-05-05 | Bourbon | Kansas | 20011 | 6 | 1 |
119168 | 119168 | 2020-05-06 | Bourbon | Kansas | 20011 | 6 | 1 |
122138 | 122138 | 2020-05-07 | Bourbon | Kansas | 20011 | 6 | 1 |
125120 | 125120 | 2020-05-08 | Bourbon | Kansas | 20011 | 6 | 1 |
128108 | 128108 | 2020-05-09 | Bourbon | Kansas | 20011 | 6 | 1 |
131098 | 131098 | 2020-05-10 | Bourbon | Kansas | 20011 | 6 | 1 |
134089 | 134089 | 2020-05-11 | Bourbon | Kansas | 20011 | 6 | 1 |
137079 | 137079 | 2020-05-12 | Bourbon | Kansas | 20011 | 6 | 1 |
140072 | 140072 | 2020-05-13 | Bourbon | Kansas | 20011 | 6 | 1 |
143068 | 143068 | 2020-05-14 | Bourbon | Kansas | 20011 | 6 | 1 |
146068 | 146068 | 2020-05-15 | Bourbon | Kansas | 20011 | 6 | 1 |
149072 | 149072 | 2020-05-16 | Bourbon | Kansas | 20011 | 6 | 1 |
152083 | 152083 | 2020-05-17 | Bourbon | Kansas | 20011 | 6 | 1 |
155095 | 155095 | 2020-05-18 | Bourbon | Kansas | 20011 | 6 | 1 |
158112 | 158112 | 2020-05-19 | Bourbon | Kansas | 20011 | 6 | 1 |
161137 | 161137 | 2020-05-20 | Bourbon | Kansas | 20011 | 7 | 1 |
164166 | 164166 | 2020-05-21 | Bourbon | Kansas | 20011 | 7 | 1 |
167198 | 167198 | 2020-05-22 | Bourbon | Kansas | 20011 | 7 | 1 |
170236 | 170236 | 2020-05-23 | Bourbon | Kansas | 20011 | 7 | 1 |
173277 | 173277 | 2020-05-24 | Bourbon | Kansas | 20011 | 7 | 1 |
176321 | 176321 | 2020-05-25 | Bourbon | Kansas | 20011 | 7 | 1 |
179365 | 179365 | 2020-05-26 | Bourbon | Kansas | 20011 | 7 | 1 |
182410 | 182410 | 2020-05-27 | Bourbon | Kansas | 20011 | 8 | 1 |
185464 | 185464 | 2020-05-28 | Bourbon | Kansas | 20011 | 8 | 1 |
188522 | 188522 | 2020-05-29 | Bourbon | Kansas | 20011 | 8 | 1 |
191586 | 191586 | 2020-05-30 | Bourbon | Kansas | 20011 | 8 | 1 |
194654 | 194654 | 2020-05-31 | Bourbon | Kansas | 20011 | 8 | 1 |
197724 | 197724 | 2020-06-01 | Bourbon | Kansas | 20011 | 8 | 1 |
200796 | 200796 | 2020-06-02 | Bourbon | Kansas | 20011 | 8 | 1 |
203872 | 203872 | 2020-06-03 | Bourbon | Kansas | 20011 | 8 | 1 |
206953 | 206953 | 2020-06-04 | Bourbon | Kansas | 20011 | 8 | 1 |
210034 | 210034 | 2020-06-05 | Bourbon | Kansas | 20011 | 8 | 1 |
213119 | 213119 | 2020-06-06 | Bourbon | Kansas | 20011 | 8 | 1 |
216206 | 216206 | 2020-06-07 | Bourbon | Kansas | 20011 | 8 | 1 |
219298 | 219298 | 2020-06-08 | Bourbon | Kansas | 20011 | 8 | 1 |
222393 | 222393 | 2020-06-09 | Bourbon | Kansas | 20011 | 8 | 1 |
225488 | 225488 | 2020-06-10 | Bourbon | Kansas | 20011 | 8 | 1 |
228590 | 228590 | 2020-06-11 | Bourbon | Kansas | 20011 | 8 | 1 |
231693 | 231693 | 2020-06-12 | Bourbon | Kansas | 20011 | 8 | 1 |
234799 | 234799 | 2020-06-13 | Bourbon | Kansas | 20011 | 8 | 1 |
237906 | 237906 | 2020-06-14 | Bourbon | Kansas | 20011 | 8 | 1 |
241015 | 241015 | 2020-06-15 | Bourbon | Kansas | 20011 | 8 | 1 |
244126 | 244126 | 2020-06-16 | Bourbon | Kansas | 20011 | 8 | 1 |
247239 | 247239 | 2020-06-17 | Bourbon | Kansas | 20011 | 9 | 1 |
250351 | 250351 | 2020-06-18 | Bourbon | Kansas | 20011 | 9 | 1 |
253466 | 253466 | 2020-06-19 | Bourbon | Kansas | 20011 | 9 | 1 |
256586 | 256586 | 2020-06-20 | Bourbon | Kansas | 20011 | 9 | 1 |
259712 | 259712 | 2020-06-21 | Bourbon | Kansas | 20011 | 9 | 1 |
262839 | 262839 | 2020-06-22 | Bourbon | Kansas | 20011 | 10 | 1 |
265967 | 265967 | 2020-06-23 | Bourbon | Kansas | 20011 | 10 | 1 |
269097 | 269097 | 2020-06-24 | Bourbon | Kansas | 20011 | 12 | 1 |
272234 | 272234 | 2020-06-25 | Bourbon | Kansas | 20011 | 12 | 1 |
275376 | 275376 | 2020-06-26 | Bourbon | Kansas | 20011 | 16 | 1 |
278524 | 278524 | 2020-06-27 | Bourbon | Kansas | 20011 | 16 | 1 |
281672 | 281672 | 2020-06-28 | Bourbon | Kansas | 20011 | 16 | 1 |
284817 | 284817 | 2020-06-29 | Bourbon | Kansas | 20011 | 19 | 1 |
287966 | 287966 | 2020-06-30 | Bourbon | Kansas | 20011 | 19 | 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);