ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 20111 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 |
---|---|---|---|---|---|---|---|
8648 | 8648 | 2020-03-23 | Lyon | Kansas | 20111 | 2 | 0 |
9929 | 9929 | 2020-03-24 | Lyon | Kansas | 20111 | 2 | 0 |
11327 | 11327 | 2020-03-25 | Lyon | Kansas | 20111 | 2 | 0 |
12895 | 12895 | 2020-03-26 | Lyon | Kansas | 20111 | 3 | 0 |
14595 | 14595 | 2020-03-27 | Lyon | Kansas | 20111 | 5 | 0 |
16402 | 16402 | 2020-03-28 | Lyon | Kansas | 20111 | 5 | 0 |
18308 | 18308 | 2020-03-29 | Lyon | Kansas | 20111 | 7 | 0 |
20321 | 20321 | 2020-03-30 | Lyon | Kansas | 20111 | 9 | 0 |
22420 | 22420 | 2020-03-31 | Lyon | Kansas | 20111 | 10 | 0 |
24595 | 24595 | 2020-04-01 | Lyon | Kansas | 20111 | 12 | 0 |
26839 | 26839 | 2020-04-02 | Lyon | Kansas | 20111 | 16 | 0 |
29153 | 29153 | 2020-04-03 | Lyon | Kansas | 20111 | 17 | 0 |
31527 | 31527 | 2020-04-04 | Lyon | Kansas | 20111 | 19 | 0 |
33941 | 33941 | 2020-04-05 | Lyon | Kansas | 20111 | 23 | 0 |
36398 | 36398 | 2020-04-06 | Lyon | Kansas | 20111 | 23 | 0 |
38900 | 38900 | 2020-04-07 | Lyon | Kansas | 20111 | 24 | 0 |
41447 | 41447 | 2020-04-08 | Lyon | Kansas | 20111 | 26 | 0 |
44023 | 44023 | 2020-04-09 | Lyon | Kansas | 20111 | 26 | 0 |
46630 | 46630 | 2020-04-10 | Lyon | Kansas | 20111 | 26 | 0 |
49266 | 49266 | 2020-04-11 | Lyon | Kansas | 20111 | 27 | 0 |
51931 | 51931 | 2020-04-12 | Lyon | Kansas | 20111 | 29 | 0 |
54613 | 54613 | 2020-04-13 | Lyon | Kansas | 20111 | 29 | 0 |
57307 | 57307 | 2020-04-14 | Lyon | Kansas | 20111 | 32 | 0 |
60015 | 60015 | 2020-04-15 | Lyon | Kansas | 20111 | 32 | 0 |
62736 | 62736 | 2020-04-16 | Lyon | Kansas | 20111 | 37 | 0 |
65472 | 65472 | 2020-04-17 | Lyon | Kansas | 20111 | 47 | 0 |
68221 | 68221 | 2020-04-18 | Lyon | Kansas | 20111 | 57 | 0 |
70982 | 70982 | 2020-04-19 | Lyon | Kansas | 20111 | 71 | 1 |
73754 | 73754 | 2020-04-20 | Lyon | Kansas | 20111 | 77 | 1 |
76534 | 76534 | 2020-04-21 | Lyon | Kansas | 20111 | 110 | 1 |
79319 | 79319 | 2020-04-22 | Lyon | Kansas | 20111 | 110 | 1 |
82114 | 82114 | 2020-04-23 | Lyon | Kansas | 20111 | 158 | 1 |
84916 | 84916 | 2020-04-24 | Lyon | Kansas | 20111 | 158 | 1 |
87725 | 87725 | 2020-04-25 | Lyon | Kansas | 20111 | 158 | 1 |
90541 | 90541 | 2020-04-26 | Lyon | Kansas | 20111 | 158 | 1 |
93362 | 93362 | 2020-04-27 | Lyon | Kansas | 20111 | 177 | 1 |
96194 | 96194 | 2020-04-28 | Lyon | Kansas | 20111 | 177 | 1 |
99040 | 99040 | 2020-04-29 | Lyon | Kansas | 20111 | 184 | 1 |
101892 | 101892 | 2020-04-30 | Lyon | Kansas | 20111 | 218 | 1 |
104752 | 104752 | 2020-05-01 | Lyon | Kansas | 20111 | 218 | 1 |
107617 | 107617 | 2020-05-02 | Lyon | Kansas | 20111 | 245 | 1 |
110488 | 110488 | 2020-05-03 | Lyon | Kansas | 20111 | 248 | 1 |
113365 | 113365 | 2020-05-04 | Lyon | Kansas | 20111 | 255 | 2 |
116247 | 116247 | 2020-05-05 | Lyon | Kansas | 20111 | 265 | 2 |
119208 | 119208 | 2020-05-06 | Lyon | Kansas | 20111 | 271 | 2 |
122178 | 122178 | 2020-05-07 | Lyon | Kansas | 20111 | 311 | 2 |
125160 | 125160 | 2020-05-08 | Lyon | Kansas | 20111 | 323 | 2 |
128148 | 128148 | 2020-05-09 | Lyon | Kansas | 20111 | 326 | 2 |
131138 | 131138 | 2020-05-10 | Lyon | Kansas | 20111 | 330 | 2 |
134129 | 134129 | 2020-05-11 | Lyon | Kansas | 20111 | 334 | 2 |
137119 | 137119 | 2020-05-12 | Lyon | Kansas | 20111 | 334 | 2 |
140112 | 140112 | 2020-05-13 | Lyon | Kansas | 20111 | 336 | 2 |
143108 | 143108 | 2020-05-14 | Lyon | Kansas | 20111 | 336 | 2 |
146108 | 146108 | 2020-05-15 | Lyon | Kansas | 20111 | 355 | 3 |
149112 | 149112 | 2020-05-16 | Lyon | Kansas | 20111 | 363 | 3 |
152123 | 152123 | 2020-05-17 | Lyon | Kansas | 20111 | 363 | 3 |
155135 | 155135 | 2020-05-18 | Lyon | Kansas | 20111 | 363 | 3 |
158152 | 158152 | 2020-05-19 | Lyon | Kansas | 20111 | 369 | 3 |
161177 | 161177 | 2020-05-20 | Lyon | Kansas | 20111 | 371 | 3 |
164206 | 164206 | 2020-05-21 | Lyon | Kansas | 20111 | 375 | 3 |
167241 | 167241 | 2020-05-22 | Lyon | Kansas | 20111 | 379 | 3 |
170279 | 170279 | 2020-05-23 | Lyon | Kansas | 20111 | 379 | 3 |
173320 | 173320 | 2020-05-24 | Lyon | Kansas | 20111 | 379 | 3 |
176364 | 176364 | 2020-05-25 | Lyon | Kansas | 20111 | 379 | 3 |
179408 | 179408 | 2020-05-26 | Lyon | Kansas | 20111 | 391 | 3 |
182453 | 182453 | 2020-05-27 | Lyon | Kansas | 20111 | 393 | 3 |
185507 | 185507 | 2020-05-28 | Lyon | Kansas | 20111 | 398 | 3 |
188565 | 188565 | 2020-05-29 | Lyon | Kansas | 20111 | 408 | 3 |
191629 | 191629 | 2020-05-30 | Lyon | Kansas | 20111 | 408 | 3 |
194697 | 194697 | 2020-05-31 | Lyon | Kansas | 20111 | 408 | 3 |
197767 | 197767 | 2020-06-01 | Lyon | Kansas | 20111 | 426 | 4 |
200839 | 200839 | 2020-06-02 | Lyon | Kansas | 20111 | 430 | 5 |
203915 | 203915 | 2020-06-03 | Lyon | Kansas | 20111 | 433 | 5 |
206996 | 206996 | 2020-06-04 | Lyon | Kansas | 20111 | 438 | 6 |
210077 | 210077 | 2020-06-05 | Lyon | Kansas | 20111 | 444 | 6 |
213162 | 213162 | 2020-06-06 | Lyon | Kansas | 20111 | 444 | 6 |
216249 | 216249 | 2020-06-07 | Lyon | Kansas | 20111 | 444 | 6 |
219341 | 219341 | 2020-06-08 | Lyon | Kansas | 20111 | 458 | 6 |
222436 | 222436 | 2020-06-09 | Lyon | Kansas | 20111 | 459 | 6 |
225531 | 225531 | 2020-06-10 | Lyon | Kansas | 20111 | 459 | 6 |
228633 | 228633 | 2020-06-11 | Lyon | Kansas | 20111 | 463 | 6 |
231736 | 231736 | 2020-06-12 | Lyon | Kansas | 20111 | 465 | 6 |
234842 | 234842 | 2020-06-13 | Lyon | Kansas | 20111 | 465 | 6 |
237949 | 237949 | 2020-06-14 | Lyon | Kansas | 20111 | 465 | 6 |
241058 | 241058 | 2020-06-15 | Lyon | Kansas | 20111 | 473 | 6 |
244169 | 244169 | 2020-06-16 | Lyon | Kansas | 20111 | 476 | 6 |
247282 | 247282 | 2020-06-17 | Lyon | Kansas | 20111 | 477 | 6 |
250394 | 250394 | 2020-06-18 | Lyon | Kansas | 20111 | 480 | 6 |
253509 | 253509 | 2020-06-19 | Lyon | Kansas | 20111 | 485 | 6 |
256629 | 256629 | 2020-06-20 | Lyon | Kansas | 20111 | 485 | 6 |
259755 | 259755 | 2020-06-21 | Lyon | Kansas | 20111 | 485 | 6 |
262882 | 262882 | 2020-06-22 | Lyon | Kansas | 20111 | 487 | 7 |
266010 | 266010 | 2020-06-23 | Lyon | Kansas | 20111 | 487 | 7 |
269141 | 269141 | 2020-06-24 | Lyon | Kansas | 20111 | 489 | 7 |
272278 | 272278 | 2020-06-25 | Lyon | Kansas | 20111 | 491 | 7 |
275421 | 275421 | 2020-06-26 | Lyon | Kansas | 20111 | 493 | 7 |
278569 | 278569 | 2020-06-27 | Lyon | Kansas | 20111 | 493 | 7 |
281717 | 281717 | 2020-06-28 | Lyon | Kansas | 20111 | 493 | 7 |
284862 | 284862 | 2020-06-29 | Lyon | Kansas | 20111 | 497 | 7 |
288011 | 288011 | 2020-06-30 | Lyon | Kansas | 20111 | 497 | 7 |
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);